The four things costing us showings
- Three different prices are live at once. The listing tour says $309,900 “Just Reduced”, Coldwell Banker’s page still shows $325,000, and our own plan has been talking $319,000 (the 188 split). A buyer or agent comparing portals sees a listing that can’t keep its own price straight — that reads as a stale or distressed listing and kills urgency.
- A stale 2023 “SOLD” record for the same address is still indexed. MLS# 144196 (Trademark Real Estate, Tammy Browning) shows 186 Echo as sold 11/7/2023 at $320K, 2,084 sq ft — a different brokerage and a different square footage than the live listing (2,151 sq ft). Address searches can land on the wrong, dead record.
- The MLS listing sells the shop we intend to keep. The marketing describes a “large three-lot property with Lake Hamilton access” and a detached 28′×32′ shop with electricity and water. That’s the opposite of the split plan (house on its own half-acre; shop kept, sold later). The public listing and the private plan contradict each other.
- No video, and the planned 188 relist isn’t anywhere. The tour has 54+ stills and aerials but no video/drone-video walk-through, the single biggest conversion lever for a lake-area home. And every portal still says 186 Echo Point — the 188 Echo Point @ $319K relist has not reached the MLS or any aggregator.
1. Platform-by-platform
Where the listing shows up, and how each site is handling it.
| Platform | Carries it? | Price shown | How it’s handled / what’s wrong |
|---|---|---|---|
| MLS (CARMLS / HSBOR) | Yes | $309,900 | MLS# 26034896 (also ShowingTime ID 156971). The source feed. Still addressed 186 Echo Point, still bundles the shop + “three lots.” Everything downstream inherits this. |
| Listing tour (Snap Magic Media) | Yes | $309,900 “Just Reduced” | Best asset we have: 54+ photos incl. aerials, labeled rooms, shop views, hot tub. No video. Agent/brokerage not named on the page — a branding + lead-capture miss. Lake described as “access.” |
| Zillow | Thin | (snippet: none) | Present with KW/Bergeron as agent, but the indexed snippet carries no price and a listing age that looks older than reality. Needs the price, full description and all photos confirmed live; owner can claim the listing to control facts and see the view/save counts. |
| Coldwell Banker (aggregator) | Stale | $325,000 | Shows the live MLS# but at the old $325K price — hasn’t picked up the cut to $309,900. Also hosts the dead 2023 record at the same URL slug, which is what search engines surface first. |
| Realtor.com | Unconfirmed | — | Could not be read (blocks automation). Should carry the MLS feed; needs a manual check that price, photos and description are current and the shop/lot framing matches whatever we decide. |
| Redfin | Stale | $325,000 | The 71913 ZIP page carries 186 Echo Pt at the old $325K, 3/2, 2,151 sf — so it’s present but wrong, not missing. It doesn’t surface cleanly as a single active listing either. Confirm syndication and claim it so the price and facts are right. |
| Lake-focused portals (LakeHomes.com etc.) | Absent | — | For a home sold on its lake-area story, not being on the lake-specific portals is a gap — though honesty matters: it’s lake-area, not waterfront, so the framing has to be right if we pursue them. |
| Our own 186echopoint.com | Conflicts | $1,800/mo rent | Our own domain — the one that ranks for the exact address — shows the house FOR RENT. A buyer or buyer’s agent googling “186 Echo Point” sees “for rent,” which signals the house isn’t selling and undercuts the sale. No for-sale page exists on our own site. |
2. How one listing becomes 150 sites
Almost every site that carries this house sits downstream of a single MLS record. The Cooperative Arkansas REALTORS MLS feeds ShowingTime (ID# 156971) and ListHub, and ListHub pushes the listing out to a network the industry counts at 150 to 330+ publisher and vendor sites on top of the national portals. Nancy’s own weekly report names ListHub, Homes.com and SnapMagic by name, so we know this house is in that pipe. That one fact is the whole strategy for the tertiary sites, in both directions.
The leverage: fix the source record once and the correction cascades to most of the tail within a syndication cycle (roughly 24–72 hours). The trap: leave the source wrong, or let an old record live on its own separate feed, and the error multiplies across a hundred pages that each rank for the address. We are living the trap right now — the $309,900 cut reached the tour and the MLS but not the franchise aggregators, and a dead 2023 record from a different brokerage is riding its own feed.
| Tier | Sites | Why it matters | Fed by | State today |
|---|---|---|---|---|
| 0 · Source | CARMLS / HSBOR → ShowingTime 156971 + ListHub | Origin; everything inherits from here | The agent types it once | $309,900, correct — but still 186, shop bundled |
| 1 · Major portals | Zillow, Realtor.com, Redfin | Where most buyer eyeballs are | ListHub + direct feeds | Zillow thin; Redfin stale $325K; Realtor unverified |
| 2 · Franchise & brokerage | Coldwell Banker, RE/MAX, Century 21 (even century21global.com), kw.com, propertyforsaleinhotsprings.com, thebergerongroup.com, Homes.com (boosted) | Brand reach + the agent’s own funnels | Franchise feeds + ListHub | Coldwell Banker stale $325K + hosts the dead record |
| 3 · Niche & long tail | LakeHomes.com, Movoto, Trulia, HotPads, Rocket Homes, Homesnap, Point2, Weichert, MapQuest + 150+ ListHub vendor sites, and the SnapMagic tour | SEO surface area — this tier is the Google results page for the address | ListHub | Mixed; LakeHomes absent; SnapMagic correct |
| Orphan | The 2023 “SOLD” record (MLS# 144196, Trademark R.E.) | Tells buyers the house already sold — the single most damaging result | A separate, old feed — does NOT inherit our fixes | Live, intercepting searches |
3. The case for fixing the tertiary sites
It’s tempting to ignore the long tail and only mind Zillow. Here is why the tertiary sites are worth a focused push, and why the return on the hour is higher here than almost anywhere else on this listing.
~150+downstream sites fed from one record via ListHub
1 fixcorrecting the source cascades to most of the tail
$325Kstale price still live on Redfin & Coldwell Banker
“SOLD”the 2023 orphan record tells buyers it’s gone
- The tertiary sites ARE the search results. When a buyer or a buyer’s agent googles “186 Echo Point,” the first page is a stack of these aggregators, not the MLS. If half of them show $325K and one says “sold in 2023,” the first impression is “stale, overpriced, maybe already gone” before they ever reach the real listing. We don’t control Google’s ranking; we control what each result says.
- Stale prices anchor against us. A buyer who sees $325,000 first and $309,900 second reads the $309,900 as a desperate cut and starts mentally subtracting again. A buyer who sees $309,900 everywhere reads it as the price. Consistency is what makes the number hold in negotiation.
- Inconsistency is the stale-listing tell — and it kills the save-to-showing step. This is the same gap the strategy and the note to Nancy flag: 117 saves, one showing. In a scam-wary market, a listing whose facts don’t agree across sites is exactly what makes an interested buyer hesitate to book. Cleaning the tail is a direct lever on conversion, not cosmetics.
- The leverage is extreme and the cost is near zero. Fixing one source record corrects ~150 sites automatically. The real marginal cost of “fix 150 sites” is “fix one, claim two, kill one orphan.” There is no higher return-per-hour task on this listing.
- Every tertiary page is a free door to the house. Each one is an indexed entry point that can send a buyer to a showing. A dead or wrong one doesn’t just fail to help — it actively turns buyers away, a negative asset we’re paying for in lost showings.
- The niche gap is the expensive miss. LakeHomes.com is the one portal whose entire audience is our buyer — people who typed “lake house” — and we’re not on it. Honestly framed (lake-area, community access, no private dock), that is the highest-intent traffic we’re leaving on the table.
- The orphan is the one that needs hands. Everything else cascades from the source; the 2023 “sold” record rides a separate old feed and will not. It’s both the most damaging single result and the only one that truly requires per-site claim/correction work. Do it first.
The fix hierarchy — do it in this order:
- Fix the source. One agreed price and one agreed description/framing into the MLS via Nancy. Paul + Nancy
- Wait 48–72h, then verify the cascade on a sample of tertiary sites (Zillow, Redfin, Homes.com, Movoto, Trulia). Feeds lag; confirm they actually moved. prompt 7
- Hand-kill the orphan 2023 record and any site stuck on a manual override that didn’t follow the feed. Paul claims prompt 3
- Claim the owner dashboards (Zillow, Redfin) to lock the facts and read the analytics. Paul claims
- Fill the niche gap — get on LakeHomes.com, honestly framed, and confirm the Homes.com boosted data is current. prompt 7
4. The data problems, in detail
Price: pick one number and force it everywhere
$309,900 (tour/MLS), $325,000 (Coldwell Banker), $319,000 (our 188 plan). Until one number is live on every surface, the listing looks adrift. Decide the number, have Nancy push the MLS correction, and re-check each aggregator 48 hours later — feeds lag but they do update.
Address & the split: decide, then make the MLS match
The plan (12 Sep) was to relist the house as 188 Echo Point at $319,000 and keep the shop parcel as 186. None of that is public. Every portal still shows one listing, 186 Echo Point, bundling the house, the shop and “three lots.” Two honest options:
- Execute the split: have Nancy file the house-only listing (new address/price, shop excluded) so the MLS stops selling the shop. Cleanest, but a new MLS entry resets days-on-market and takes a few days to propagate.
- Drop the split for now and sell the bundle as-is at one clear price, keeping the shop language accurate. Faster, but gives up the kept-shop plan.
What we can’t keep doing is running a private plan that the public listing contradicts.
The stale 2023 record: claim or correct it
MLS# 144196 (sold 11/7/2023, Trademark R.E., 2,084 sq ft, built 1970) is a dead record for the same address with the wrong brokerage and wrong square footage. It’s indexed and can intercept address searches. On Zillow/Redfin the owner can claim the property and suppress or correct old data; on the aggregators it’s a request to update. Worth an hour.
Square footage & facts don’t agree
Live listing: 2,151 sq ft. Dead 2023 record: 2,084 sq ft. Our own site: 2,151 sq ft. Lot shows as 0.84 ac on the tour vs the “two parcels” (0.50 + 0.33) in our notes. Pin the canonical numbers once and use them everywhere.
5. Media & copy
- Photos: good. 54+ including aerials and labeled rooms. Keep.
- Video: missing. No walk-through or drone video. For a lake-area, character home this is the top conversion add — a 60–90 second video lifts inquiries and time-on-listing on Zillow and gives something to post to social and to the Austin-expat audience.
- Lake language: tighten for honesty. “Lake Hamilton access” is softer than “waterfront,” which is good, but it’s still loose. Say plainly it’s a block off the lake with community/public access, no private dock — the same honesty rule the rental page follows. It prevents the disappointing showing that turns into no offer.
- Branding: name the agent on the tour. The tour page names only the photographer. The listing agent and a “book a showing” contact should be on it.
- Description: strong bones. Beamed vaulted living room, hardwoods, sunroom, bonus spaces, fenced yard — good material. Just reconcile the shop/lot framing with whatever split decision we make.
6. How the agent is handling it
Nancy Bergeron / The Bergeron Group bills as the #1 team in Hot Springs, and she’s present everywhere an agent should be (KW, homes.com, Yelp, her own site, MapQuest). The listing has pro photos, is on the MLS, and took one price cut. That’s a competent standard listing — and after six weeks it has produced views and saves but no offer, which is exactly the pattern Paul flagged: the resources exist but aren’t being spent on this house.
What’s missing is everything beyond the default: no video, no visible open house, no boosted campaign, no buyer-list email, no agent-to-agent outreach to Austin relocation agents, and the price/data inconsistencies above that a hands-on listing agent would have caught. The move is to hand her a specific deploy checklist (see the strategy page) rather than ask “any news,” and to run our own reach in parallel.
7. Scorecard: the listing’s online handling
| Dimension | Grade | Notes |
|---|---|---|
| Photos | A | 54+, aerials, labeled rooms — strong |
| Price consistency | D | $309,900 / $319K / $325K live at once across surfaces |
| Data accuracy | D | Stale 2023 record, conflicting sqft, shop/lot framing fights the plan |
| Address / split execution | F | Planned 188 relist is nowhere; MLS still 186 + shop bundled |
| Video | F | None |
| Redfin accuracy | D | Carries it, but at the stale $325K on the ZIP page |
| Syndication hygiene | D | ~150 ListHub-fed sites; several stale, plus the 2023 orphan record |
| Zillow completeness | C | Present but thin; unclaimed |
| Honesty of lake claim | B | “access” not “waterfront” — close, tighten it |
| Agent marketing beyond MLS | C | Pro photos + one cut; nothing extra visible |
| Our own site alignment | D | Own domain shows “for rent,” undercuts the sale |
8. The fix list, prioritized
Do this week (before Oct 29)
- Decide the one price and the split question (execute 188-house-only, or sell the 186 bundle), and put both in writing to Nancy so the MLS can be corrected. Paul + Nancy prompt 1
- Reconcile every surface to that one price & framing — MLS correction via Nancy, then verify Coldwell Banker, Zillow, Realtor.com, Redfin 48h later. prompt 2
- Claim/correct the stale 2023 record and claim the Zillow/Redfin listings as owner so facts and photos are right and the dead record stops intercepting searches. Paul claims prompt 3
- Stop our own site from undercutting the sale: add a for-sale page on 186echopoint.com (or a clear “also for sale” banner) so the address’s top organic result isn’t only “for rent.” prompt 4
Next (Nov)
- Get a video. Ask Nancy for a 60–90s walk-through/drone video, or shoot one; add it to the MLS, Zillow, the tour and our pages. Nancy / vendor prompt 5
- Tighten the lake language to the honest “block off the lake, community access, no private dock” line on every surface we control, and ask Nancy to match it on the MLS. prompt 2
- Get it onto Redfin and the lake portals (honestly framed), and confirm Realtor.com is current. prompt 3
- Hand Nancy the deploy checklist from the strategy page and track what actually ships. see strategy prompt 1
Ongoing
- Weekly listing-handling check: re-audit price/photos/status/DOM across the portals and flag drift. prompt 6
- Keep this page current as surfaces get fixed — it’s the single view of how the listing looks to the world. prompt 6
9. Claude prompts to carry it out
Run from C:\Users\walhu\websites, one per session. Each repeats the guardrails.
Prompt 1 · Decide price + split, draft the MLS instruction to Nancy
CONTEXT (read first): 186 Echo Point, Hot Springs AR, is listed for sale by Nancy Bergeron (KW, The Bergeron Group), MLS# 26034896 / ShowingTime 156971. Across portals the price is INCONSISTENT right now: the Snap Magic Media listing tour shows $309,900 "Just Reduced", Coldwell Banker shows $325,000, and our own plan has been $319,000 as part of a split (relist the house as 188 Echo Point and keep the shop parcel as 186). The MLS still shows ONE listing at 186 Echo Point that bundles the house + a 28'x32' shop + "three lots". House is owned free and clear. The Mariposa #206 Austin purchase is contingent on this sale by Oct 29, 2026. GUARDRAILS: never the owner's real name in public copy; honest that it's lake-AREA not waterfront, no private dock; our own words and facts only; I DRAFT messages, Paul reviews and sends; ask before any money/MLS/price change — I never change a live listing myself. TASK: Help Paul make two decisions and draft the instruction. 1) Lay out the price decision crisply ($309,900 vs $319,000 vs $325,000) with the one-paragraph case for a single number, given the Oct 29 clock and that the house is already below the 71913 median per-foot. 2) Lay out the split decision: EXECUTE the 188-house-only relist (shop excluded) vs SELL the 186 bundle as-is — pros/cons, what each does to days-on-market and to the kept-shop plan. 3) Draft (do NOT send) a short, plain-voice message to Nancy stating the chosen price and framing and asking her to correct the MLS accordingly, plus confirm it syndicates to Zillow, Realtor.com and Redfin. Save as a Gmail draft and show it here.
Prompt 2 · Reconcile the listing facts across every surface
CONTEXT (read first): The 186 Echo Point for-sale listing shows inconsistent facts across platforms: price ($309,900 / $319,000 / $325,000), square footage (2,151 live vs 2,084 on an old record), lot framing (0.84 ac vs our "two parcels 0.50+0.33"), and lake wording ("Lake Hamilton access"). Canonical facts to standardize: 3 bed / 2 bath, 2,151 sq ft, single-level brick ranch, built 1970, lake-AREA (a block off Lake Hamilton, community/public access, NO private dock). Our own site is 186echopoint.com (live). GUARDRAILS: our own words and facts only, honest about the water; never the owner's real name in public copy; I can edit OUR pages but I DRAFT anything for Nancy/MLS (Paul sends); ask before nginx/DNS/auth/money; verify live with curl.
TASK: 1) Produce a one-page canonical fact sheet for 186 Echo Point (the agreed price once decided, beds/baths/sqft/year, lot, honest lake line, school district Lakeside, shop status per the split decision) that every surface should match. 2) Audit each platform against it and list the exact corrections needed per platform (MLS via Nancy, Coldwell Banker, Zillow, Realtor.com, Redfin, our own site). 3) Fix the surfaces WE control (186echopoint.com) to match, backing up first and verifying live with curl. 4) Draft the correction requests for the platforms we don't control. Report what you changed and what's pending.Prompt 3 · Claim listings + kill the stale 2023 record
CONTEXT (read first): Two records exist for 186 Echo Point: the LIVE listing (MLS# 26034896, KW/Bergeron, 2,151 sqft) and a STALE one (MLS# 144196, Trademark Real Estate / Tammy Browning, SOLD 11/7/2023, 2,084 sqft, built 1970) that is still indexed and can intercept address searches. The live listing is thin on Zillow (no price in the snippet) and not surfacing as active on Redfin. GUARDRAILS: I prepare steps and drafts; PAUL does any account claim/login himself (Zillow/Redfin owner claim, aggregator corrections); never the owner's real name in public copy; our facts only; ask before money. TASK: Write Paul an exact, click-by-click playbook to: 1) claim 186 Echo Point as the owner on Zillow and on Redfin, so he can fix price/photos/description and see view & save counts; 2) correct or suppress the stale 2023 SOLD record (wrong brokerage, wrong sqft) on Zillow/Redfin/Coldwell Banker and anywhere else it's indexed — the specific "report/claim/update" path for each; 3) confirm the live listing is syndicating to Redfin and Realtor.com and, if not, what to ask Nancy/the MLS to do. Keep it concrete and ordered. Nothing requires me to log into his accounts — produce the steps and any draft correction text.
Prompt 4 · Add a for-sale presence on our own domain
CONTEXT (read first): 186echopoint.com is LIVE as a RENTAL listing ($1,800/mo), at /var/www/186echopoint.com on root@143.198.182.180; homepage is HAND-deployed; generator C:\Users\walhu\websites\_night\echopoint-rent\echo_gen.py. Problem: our own domain ranks for the exact address but shows only "for rent," which undercuts the active SALE (188/186 Echo Point via Nancy Bergeron) — a buyer googling the address sees "for rent" and reads it as "not selling." We may also still sell; both tracks run at once (whichever closes first wins). GUARDRAILS: honest lake-AREA not waterfront; never the owner's real name in public copy; our words only, no scraping/no best-of lists; back up the live homepage before any change and never let a generator rerun flatten it; content deploys OK but ASK before nginx/DNS/auth/email/money; verify live with curl. TASK: Give the address's own site a for-sale presence without killing the rental. Option A: a /for-sale/ page (price, honest lake line, flyers, "contact the listing agent / book a showing" CTA) linked from the homepage. Option B: a tasteful "Also available to buy" band on the rental homepage pointing to it. Recommend one, build it, back up first, add to sitemap, deploy, verify live with curl. Keep sale and rental clearly separate so neither confuses the other. Show the copy before it goes wide.
Prompt 5 · Get a listing video
CONTEXT (read first): The 186 Echo Point for-sale listing has 54+ photos and aerials but NO video. A short walk-through/drone video is the top conversion add for a lake-area character home and gives us something to post to social and the Austin-expat audience. Pro photos came from Snap Magic Media. GUARDRAILS: honest lake-AREA not waterfront, no dock; never the owner's real name in public copy; our own media only; I DRAFT the ask, Paul sends; ask before money. TASK: 1) Draft (do not send) a short message to Nancy asking whether a 60-90s listing video / drone video can be added (via her usual media vendor or Snap Magic Media), and what it would cost. 2) Write the shot list and a 60-90s voiceover script in the honest house voice (beamed great room, sunroom, kitchen, shop exterior if we're keeping the bundle, the lake-area setting stated honestly). 3) Note exactly where the finished video goes (MLS, Zillow, the tour, our /for-sale/ page, YouTube via the youtube-publish skill, social). Show it all here.
Prompt 6 · Weekly listing-handling re-audit
CONTEXT (read first): This page (186echopoint.com/sites/) audits how the 186 Echo Point for-sale listing is handled across platforms. It needs to stay current as fixes land. Live at /var/www/186echopoint.com/sites/ on root@143.198.182.180; source C:\Users\walhu\websites\186echopoint.com\sites\index.html; same house style as /strategy/. Portals (Zillow/Realtor/Redfin) block automated reads, so use search snippets + the Snap Magic Media tour + Coldwell Banker + any owner-claimed dashboards, and label uncertain data as such. GUARDRAILS: our facts only; never the owner's real name in public copy; back up before editing; ask before nginx/DNS/auth/money; verify live with curl. TASK: Re-run the audit: for each platform (MLS/tour, Zillow, Realtor.com, Redfin, Coldwell Banker, lake portals, our own site) check current price, status, photos, DOM and whether facts match the canonical sheet; flag any drift and whether the stale 2023 record is gone. Update the platform grid, the scorecard and the headline problems in sites/index.html (back up first), redeploy, verify live with curl, and give Paul a 5-line "what changed since last week" summary.
Prompt 7 · Verify the syndication cascade + fill the niche gap
CONTEXT (read first): The 186 Echo Point for-sale listing feeds roughly 150 downstream sites via the CARMLS/HSBOR + ShowingTime (ID 156971) + ListHub pipeline. Nancy's team also names Homes.com (boosted) and SnapMagic. Once the MLS SOURCE is corrected (one agreed price, one agreed description/framing), most tertiary sites should self-correct in 24-72h; the 2023 "SOLD" orphan record (MLS# 144196, Trademark Real Estate) rides a SEPARATE old feed and will NOT. Right now the cut to $309,900 reached the MLS and the SnapMagic tour but Coldwell Banker and Redfin still show the old $325,000. LakeHomes.com (our highest-intent niche) does not carry the listing. Portals (Zillow/Realtor.com/Redfin) block automated reads, so use search snippets + any owner-claimed dashboards and LABEL uncertain data. This page is 186echopoint.com/sites/ (source C:\Users\walhu\websites\186echopoint.com\sites\index.html, live /var/www/186echopoint.com/sites/ on root@143.198.182.180). GUARDRAILS: our own facts only; honest lake-AREA not waterfront, no dock; never the owner's real name in public copy; I prepare steps and drafts, PAUL does any account claim/login; ask before money; verify our own pages with curl. TASK: 48-72h after the MLS source is corrected, verify the cascade actually happened. 1) Check a sample of tertiary sites (Zillow, Redfin, Homes.com, Movoto, Trulia, Rocket Homes, Coldwell Banker) and report which now show the correct price and facts and which are still stale. 2) For any stuck site, give the exact per-site "report a problem / claim / correct" path. 3) Confirm whether the 2023 orphan record is still live and give the claim/suppress steps per site if so. 4) Produce the steps plus any draft needed to get the listing onto LakeHomes.com, honestly framed, and confirm the Homes.com boosted data is current. 5) Update the syndication tier table and the scorecard in sites/index.html (back up first), redeploy, and verify live with curl. Report a short "cascade status" summary for Paul.
Companion document: 186echopoint.com/strategy/ — the rent-or-sell plan this audit feeds into.