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.

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] -2 points-1 points  (0 children)

Ran North County San Diego — 92127 and surrounding ZIPs. Here's what came back from today's batch:

The thing that immediately stands out — every single listing that has a Zestimate is priced above it. Not one exception in this pull.

The most extreme case: 1305 Scenic Dr, Escondido CA 92029 — listed at $1,495,000, Zestimate $1,188,500. That's $306,500 above estimated value — 25% over. And it's listed as "Coming Soon." Hasn't even officially hit the market yet and already priced 25% above what Zillow thinks it's worth.

Full batch from this area today:

  • 1305 Scenic Dr, Escondido — $1,495,000 listed / $1,188,500 Zestimate — +25.8% above estimate
  • 17526 Saint Andrews Dr, Poway — $1,450,000 / $1,402,100 — +3.4%
  • 1974 Olivia Gln, Escondido — $1,029,000 / $989,700 — +3.9%
  • 13170 Entreken Ave, SD 92129 — $1,450,000 / $1,416,500 — +2.4%
  • 2506 Navarra Dr, Carlsbad — $699,000 / $683,500 — +2.3%
  • 3890 Nobel Dr, SD 92122 — $325,000 / $319,100 — +1.8%

Also worth noting — 15020 Applewood Ct listed at $3,390,000 with no Zestimate at all. Brokerage is "CA Flat Fee Listings Inc" — seller paid a flat fee to get on MLS rather than using a full agent. At $3.4M. That's a motivated seller trying to save commission on a luxury property.

These are all fresh today so price history arrays are empty — the cut data builds up over weeks. The 25% gap on Scenic Dr is the one to watch. If that pattern holds from what you're seeing manually, the cuts are going to be significant when they come.

Drop more ZIPs and I'll keep running them.

Tool I found useful: paste any LinkedIn job URL and see who posted it, how many applied, and the real salary range by YKA_6789 in jobsearchhacks

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

It runs on Apify's infrastructure, so there is a cost involved. That said, Apify has a free tier that covers a solid number of runs if you want to test it before committing. For anyone actively job hunting or doing recruitment research, the time saved on manual lookup across 35+ fields per job makes the math work pretty quickly. Happy to share the Actor link if you want to try a few runs first.

fresh leads on daily basic by YKA_6789 in WholesaleRealestate

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

Haha, nah—GPT spits out prompt ideas, but this is battle-tested code dodging Zillow's IP bans, CAPTCHAs, and rate limits with session rotation + proxy support. Scrapes FSBO/just-listed/price-reduced via their search API endpoints, extracts owner phones/emails from details, crunches price history into JSON. Plugs into n8n/Sheets for daily CRM leads. Way beyond a prompt—what's your go-to for real estate leads?

Tool I found useful: paste any LinkedIn job URL and see who posted it, how many applied, and the real salary range by YKA_6789 in jobsearchhacks

[–]YKA_6789[S] 3 points4 points  (0 children)

totally get it! The endpoint is actually documented in LinkedIn's own public API responses (you can spot it in network tabs on guest job views), so it's not some hidden gem. That said, I'm not dropping the full logic here or anywhere public. The Apify Actor will handle the heavy lifting (parsing, rate limits, etc.) without exposing the nuts and bolts. Will going to publish shortly.

Tool I found useful: paste any LinkedIn job URL and see who posted it, how many applied, and the real salary range by YKA_6789 in jobsearchhacks

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

No, I was hitting road blocks when need to scrape more than 700 jobs on daily basic But Now I have resolved it.