# How to make an app like Zillow with advanced filtering **URL:** \ **Category:** Project Showcase\ **Created:** [April 21, 2020, 2:36pm UTC](https://community.glideapps.com/t/how-to-make-an-app-like-zillow-with-advanced-filtering/7517 "2020-04-21T14:36:41Z")\ **Posts on this page:** 20\ **Page:** 2
**Author:** ![Aidan\_Lawlor](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/aidan_lawlor/32/6664_2.png) [@Aidan\_Lawlor](https://community.glideapps.com/u/Aidan_Lawlor)\ **Post date:** [May 2, 2020, 2:06pm UTC](https://community.glideapps.com/t/how-to-make-an-app-like-zillow-with-advanced-filtering/7517/21 "2020-05-02T14:06:25Z")
Hi Seth, II have been attemptiing to build a directory website in Wordpress with many different themes on and off for over 3 years. Each theme just became so restrictive after a few weeks/months of working on it and I always gave up. I cam across Glide today and it really piqued my interest. Then I see this post and voila!!! You may be my saviour. I will go through your lessons tmro and I’ll let you know how i get on. Thanks so much for creating the tutorials and sharing them. You rock!! ---
**Author:** ![seth](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/seth/32/5959_2.png) [@seth](https://community.glideapps.com/u/seth)\ **Post date:** [May 2, 2020, 3:02pm UTC](https://community.glideapps.com/t/how-to-make-an-app-like-zillow-with-advanced-filtering/7517/22 "2020-05-02T15:02:40Z")
Hey Aidan, awesome!! Let me know if you have any questions! ---
**Author:** ![Aidan\_Lawlor](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/aidan_lawlor/32/6664_2.png) [@Aidan\_Lawlor](https://community.glideapps.com/u/Aidan_Lawlor)\ **Post date:** [May 4, 2020, 9:10am UTC](https://community.glideapps.com/t/how-to-make-an-app-like-zillow-with-advanced-filtering/7517/23 "2020-05-04T09:10:47Z")
Just finished your tutorial, Seth. Amazing work. Thanks so much. I have a few questions if you don’t mind? 1. How can you get real estate agents. or homeowners to upload and manage their own listings? Just wondering how this would scale without you having to input and manage all the listings? 1. Does Glide provide the options to monetise this app? e.g. Paid listings, ads etc? Thanks so much, Aidan ---
**Author:** ![seth](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/seth/32/5959_2.png) [@seth](https://community.glideapps.com/u/seth)\ **Post date:** [May 4, 2020, 11:10pm UTC](https://community.glideapps.com/t/how-to-make-an-app-like-zillow-with-advanced-filtering/7517/24 "2020-05-04T23:10:59Z")
Thanks so much Aidan! I’m glad it was helpful. One way to get real estate agents to manage / upload their own listings is to create a 2nd app that uses the same spreadsheet and have that be the “agent” app. In that app, agents could upload their homes (through a form button) that goes to the homes sheet. They could also have the ability to edit their own listings that way. Eventually I will add a section to my tutorial that includes this, but hopefully this makes sense and you would be able to build this out. You definitely could do paid listings. Glide has the ability to accept stripe payments. In the agent app, one option would be to allow them to pay for a promoted listing, and you could have logic that pushes those homes to the top of the listings. You could do something similar with ads I think. Hope that’s helpful! ---
**Author:** ![Andres\_Romero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/andres_romero/32/6960_2.png) [@Andres\_Romero](https://community.glideapps.com/u/Andres_Romero)\ **Post date:** [May 8, 2020, 9:50pm UTC](https://community.glideapps.com/t/how-to-make-an-app-like-zillow-with-advanced-filtering/7517/25 "2020-05-08T21:50:58Z")
Amazing, well done! ---
**Author:** ![seth](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/seth/32/5959_2.png) [@seth](https://community.glideapps.com/u/seth)\ **Post date:** [May 9, 2020, 4:56pm UTC](https://community.glideapps.com/t/how-to-make-an-app-like-zillow-with-advanced-filtering/7517/26 "2020-05-09T16:56:31Z")
Thanks Andres!! ---
**Author:** ![Glyde123](https://avatars.discourse-cdn.com/v4/letter/g/8797f3/32.png) [@Glyde123](https://community.glideapps.com/u/Glyde123)\ **Post date:** [May 11, 2020, 10:32pm UTC](https://community.glideapps.com/t/how-to-make-an-app-like-zillow-with-advanced-filtering/7517/27 "2020-05-11T22:32:58Z")
Thanks Seth! This is great. Unfortunately I got stuck in Section 3 under the formula when trying to concatenate the Full Address. Got a #REF! **Error** Array result was not expanded because it would overwrite data in W3. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/d/d0b32b8d650f88f9efac5dd14dfa21a6221134b5.png) Am I missing something? ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [May 11, 2020, 10:36pm UTC](https://community.glideapps.com/t/how-to-make-an-app-like-zillow-with-advanced-filtering/7517/28 "2020-05-11T22:36:29Z")
That means you have something in the column below the formula. Make sure the entire column is empty. ---
**Author:** ![Glyde123](https://avatars.discourse-cdn.com/v4/letter/g/8797f3/32.png) [@Glyde123](https://community.glideapps.com/u/Glyde123)\ **Post date:** [May 11, 2020, 10:57pm UTC](https://community.glideapps.com/t/how-to-make-an-app-like-zillow-with-advanced-filtering/7517/29 "2020-05-11T22:57:42Z")
Thanks Jeff. I deleted everything under that column and still have the error. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/7/7b7b6cf10059b140e10245f6db963574916e5653.png) It’s selecting the appropriate columns to concatenate but something else is causing the error… ---
**Author:** ![Glyde123](https://avatars.discourse-cdn.com/v4/letter/g/8797f3/32.png) [@Glyde123](https://community.glideapps.com/u/Glyde123)\ **Post date:** [May 11, 2020, 11:00pm UTC](https://community.glideapps.com/t/how-to-make-an-app-like-zillow-with-advanced-filtering/7517/30 "2020-05-11T23:00:16Z")
I even deleted the Full Address column (W) and created a new one to ensure that there’s nothing under that column but same error ---
**Author:** ![Glyde123](https://avatars.discourse-cdn.com/v4/letter/g/8797f3/32.png) [@Glyde123](https://community.glideapps.com/u/Glyde123)\ **Post date:** [May 11, 2020, 11:14pm UTC](https://community.glideapps.com/t/how-to-make-an-app-like-zillow-with-advanced-filtering/7517/31 "2020-05-11T23:14:22Z")
Here’s the screenshot of the #REF! error ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/c/c843492fb9ac5f14ec9aac8308953defa0bb5026.png) ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [May 11, 2020, 11:29pm UTC](https://community.glideapps.com/t/how-to-make-an-app-like-zillow-with-advanced-filtering/7517/32 "2020-05-11T23:29:47Z")
I think you are trying to put the formula in W2. It should be in W1, since the formula also contains the heading. It’s trying to write the heading in the second row, and then perform the array formula on the rest, but at that point everything is offset and it’s trying to infinitely write the previous row data on the current row instead of the current row data on the current row. ---
**Author:** ![Glyde123](https://avatars.discourse-cdn.com/v4/letter/g/8797f3/32.png) [@Glyde123](https://community.glideapps.com/u/Glyde123)\ **Post date:** [May 11, 2020, 11:38pm UTC](https://community.glideapps.com/t/how-to-make-an-app-like-zillow-with-advanced-filtering/7517/33 "2020-05-11T23:38:50Z")
You’re genius! Thank you!!! ---
**Author:** ![seth](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/seth/32/5959_2.png) [@seth](https://community.glideapps.com/u/seth)\ **Post date:** [May 12, 2020, 12:31am UTC](https://community.glideapps.com/t/how-to-make-an-app-like-zillow-with-advanced-filtering/7517/34 "2020-05-12T00:31:22Z")
> [@Jeff\_Hager](#): > > I think you are trying to put the formula in W2. It should be in W1, since the formula also contains the heading. It’s trying to write the heading in the second row, and then perform the array formula on the rest, but at that point everything is offset and it’s trying to infinitely write the previous row data on the current row instead of the current row data on the current row. Thanks for finding the solution Jeff! ---
**Author:** ![Glyde123](https://avatars.discourse-cdn.com/v4/letter/g/8797f3/32.png) [@Glyde123](https://community.glideapps.com/u/Glyde123)\ **Post date:** [May 12, 2020, 1:08pm UTC](https://community.glideapps.com/t/how-to-make-an-app-like-zillow-with-advanced-filtering/7517/35 "2020-05-12T13:08:36Z")
Thanks Seth. I must of missed that detail in your video tutorial. ---
**Author:** ![onepixelman](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/onepixelman/32/130_2.png) [@onepixelman](https://community.glideapps.com/u/onepixelman)\ **Post date:** [May 12, 2020, 1:34pm UTC](https://community.glideapps.com/t/how-to-make-an-app-like-zillow-with-advanced-filtering/7517/36 "2020-05-12T13:34:05Z")
I think this is going to help me become more advanced with Glide. I’m excited! I will be sure to give you feedback. Thanks for offering this. ---
**Author:** ![onepixelman](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/onepixelman/32/130_2.png) [@onepixelman](https://community.glideapps.com/u/onepixelman)\ **Post date:** [May 12, 2020, 4:38pm UTC](https://community.glideapps.com/t/how-to-make-an-app-like-zillow-with-advanced-filtering/7517/37 "2020-05-12T16:38:14Z")
I just started with the first video where you’re showing how to set up the Google Sheet. A link to your Sheet that I could copy would be super helpful. Have you considered? ---
**Author:** ![seth](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/seth/32/5959_2.png) [@seth](https://community.glideapps.com/u/seth)\ **Post date:** [May 12, 2020, 4:58pm UTC](https://community.glideapps.com/t/how-to-make-an-app-like-zillow-with-advanced-filtering/7517/38 "2020-05-12T16:58:01Z")
Awesome! Yeah for sure - I may enable that in the future to make it easier to clone the app. ---
**Author:** ![onepixelman](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/onepixelman/32/130_2.png) [@onepixelman](https://community.glideapps.com/u/onepixelman)\ **Post date:** [May 12, 2020, 6:38pm UTC](https://community.glideapps.com/t/how-to-make-an-app-like-zillow-with-advanced-filtering/7517/40 "2020-05-12T18:38:47Z")
Maybe even better (for you) could be for you to publish this as a Glide Template for $5-15 and have people buy it if they want an easy way to follow along with your tutorials. Maybe that’s what you already have planned? ---
**Author:** ![seth](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/seth/32/5959_2.png) [@seth](https://community.glideapps.com/u/seth)\ **Post date:** [May 12, 2020, 7:44pm UTC](https://community.glideapps.com/t/how-to-make-an-app-like-zillow-with-advanced-filtering/7517/41 "2020-05-12T19:44:47Z")
Yeah, definitely a good potential option! I’m still deciding on the best way to potentially monetize, but I do think charging for templates could make sense. [Previous page](https://community.glideapps.com/t/how-to-make-an-app-like-zillow-with-advanced-filtering/7517.md?page=1) [Next page](https://community.glideapps.com/t/how-to-make-an-app-like-zillow-with-advanced-filtering/7517.md?page=3)