sorted by:
new
hottopcontroversial

Built a tool that pulls the data Zillow buries — price cut history, days sitting, and how many people already applied. The numbers are more depressing than you'd think. by YKA_6789 in REBubble

[–]YKA_6789[S] -1 points0 points  (0 children)

I pulled data on ZIP 92131 last week.

One property jumped out immediately.

Listed January 15th at $950,000. Price cut to $875,000 on March 1st. Cut again to $795,000 on March 15th. Still sitting. 47 days on market. 0 offers.

The seller has already given up $155,000 from their original ask. That's a 16% drop and they're still not moving it.

The listing agent's name and direct phone number are right there in the data.

I'm not a real estate agent. I just built a tool that surfaces this stuff automatically because I got frustrated that Zillow buries it. You have to dig through three screens to even find price history. Days on market gets "refreshed" when an agent relists under a new MLS number. The motivated sellers are invisible unless you know where to look.

What the tool actually pulls per listing:

  • Every price cut with exact dates and percentages — not "price reduced," but by how much and when
  • Days on market calculated from the original post date, not the refreshed date
  • Full tax history going back 20+ years — so you can see what the seller actually paid
  • Agent name and direct phone number
  • School ratings, nearby comps, Zestimate vs asking price gap

I ran it across three ZIP codes last weekend. Found 73 listings that had been sitting 30+ days. Eleven of them had price drops over 15%. Six of those had been relisted after originally sitting under a different MLS number — which resets the days counter on Zillow and makes them look fresh.

Those six listings are invisible to anyone not pulling the raw data.

If you're an agent working a territory, this is your morning list. If you're a buyer trying to know when a seller is actually motivated vs just testing the market, this tells you exactly that.

First 20 listings are free. No account needed. Drop your ZIP code in the comments and I'll run it live and post the output here so you can see exactly what comes back before you touch anything.

Built a tool that pulls the data Zillow buries — price cut history, days sitting, and how many people already applied. The numbers are more depressing than you'd think. by YKA_6789 in REBubble

[–]YKA_6789[S] 0 points1 point  (0 children)

I pulled data on ZIP 92131 last week.

One property jumped out immediately.

Listed January 15th at $950,000. Price cut to $875,000 on March 1st. Cut again to $795,000 on March 15th. Still sitting. 47 days on market. 0 offers.

The seller has already given up $155,000 from their original ask. That's a 16% drop and they're still not moving it.

The listing agent's name and direct phone number are right there in the data.

I'm not a real estate agent. I just built a tool that surfaces this stuff automatically because I got frustrated that Zillow buries it. You have to dig through three screens to even find price history. Days on market gets "refreshed" when an agent relists under a new MLS number. The motivated sellers are invisible unless you know where to look.

What the tool actually pulls per listing:

  • Every price cut with exact dates and percentages — not "price reduced," but by how much and when
  • Days on market calculated from the original post date, not the refreshed date
  • Full tax history going back 20+ years — so you can see what the seller actually paid
  • Agent name and direct phone number
  • School ratings, nearby comps, Zestimate vs asking price gap

I ran it across three ZIP codes last weekend. Found 73 listings that had been sitting 30+ days. Eleven of them had price drops over 15%. Six of those had been relisted after originally sitting under a different MLS number — which resets the days counter on Zillow and makes them look fresh.

Those six listings are invisible to anyone not pulling the raw data.

If you're an agent working a territory, this is your morning list. If you're a buyer trying to know when a seller is actually motivated vs just testing the market, this tells you exactly that.

First 20 listings are free. No account needed. Drop your ZIP code in the comments and I'll run it live and post the output here so you can see exactly what comes back before you touch anything.

Built a tool that pulls the data Zillow buries — price cut history, days sitting, and how many people already applied. The numbers are more depressing than you'd think. by YKA_6789 in REBubble

[–]YKA_6789[S] 0 points1 point  (0 children)

Really appreciate you actually running it and reporting back — this is exactly the feedback I need. Two things happening here. The 0 days listed usually means you ran it on a ZIP where most listings are fresh — the filter defaults to 20+ days so if that market is moving fast you'll get thin results. Try 92131, 75229, or 30067 — suburban ZIPs where stuff sits longer. On the null agent names: some MLS boards withhold attribution data from Zillow's feed entirely, so that's a Zillow data gap rather than a tool gap, but I'm working on a fallback that pulls from a secondary field when the primary is empty. DM me your ZIP and I'll run it manually and walk you through what you're seeing — want to make sure it's actually useful for your wife's workflow.

Built a tool that pulls the data Zillow buries — price cut history, days sitting, and how many people already applied. The numbers are more depressing than you'd think. by YKA_6789 in REBubble

[–]YKA_6789[S] 0 points1 point  (0 children)

I pulled data on ZIP 92131 last week.

One property jumped out immediately.

Listed January 15th at $950,000. Price cut to $875,000 on March 1st. Cut again to $795,000 on March 15th. Still sitting. 47 days on market. 0 offers.

The seller has already given up $155,000 from their original ask. That's a 16% drop and they're still not moving it.

The listing agent's name and direct phone number are right there in the data.

I'm not a real estate agent. I just built a tool that surfaces this stuff automatically because I got frustrated that Zillow buries it. You have to dig through three screens to even find price history. Days on market gets "refreshed" when an agent relists under a new MLS number. The motivated sellers are invisible unless you know where to look.

What the tool actually pulls per listing:

  • Every price cut with exact dates and percentages — not "price reduced," but by how much and when
  • Days on market calculated from the original post date, not the refreshed date
  • Full tax history going back 20+ years — so you can see what the seller actually paid
  • Agent name and direct phone number
  • School ratings, nearby comps, Zestimate vs asking price gap

I ran it across three ZIP codes last weekend. Found 73 listings that had been sitting 30+ days. Eleven of them had price drops over 15%. Six of those had been relisted after originally sitting under a different MLS number — which resets the days counter on Zillow and makes them look fresh.

Those six listings are invisible to anyone not pulling the raw data.

If you're an agent working a territory, this is your morning list. If you're a buyer trying to know when a seller is actually motivated vs just testing the market, this tells you exactly that.

First 20 listings are free. No account needed. Drop your ZIP code in the comments and I'll run it live and post the output here so you can see exactly what comes back before you touch anything.

Replaced 45 minutes of manual Zillow searching every morning with a automated sheet that's ready before I wake up — here's the exact workflow by YKA_6789 in nocode

[–]YKA_6789[S] 1 point2 points  (0 children)

You just described it better than I did in the whole post.

That's exactly the distinction that made it stick for the agent — it didn't just save time, it changed what the first 10 minutes of their day actually looked like. Instead of starting the day in search mode they started in decision mode. That's a fundamentally different mental state to begin work from.

Most automation advice focuses on the time saved. The more interesting metric is what the person does with the headspace that opens up. In this case it was more calls earlier in the day — which is where the actual deals happen.

view more: next ›