405 Chestnut Tree Hill Rd
Oxford, CT 06478
PASS
Price
$687,300
Beds
5
Baths
2.5
Sq Ft
3,220
Year
1979
Days Listed
6850
◆ Executive Summary
Overall: PASS — This zombie listing has failed to sell through multiple cycles over 18+ years with massive information gaps that make proper evaluation impossible. Though some experts called for investigation, the consensus recognizes this as a fundamentally flawed listing with critical missing system data for a 47-year-old home, unexplained price volatility ($725K down to $687K in 2025), and chronic market rejection spanning nearly two decades. The complete absence of heating, cooling, roof, foundation, and environmental information combined with zero renovation permits despite a 46% price increase since 2007 creates unacceptable due diligence risk. This property's extreme days on market (6,850 days) and repeated listing failures signal serious underlying issues that buyers should avoid.
Next steps
Deepen research, collaborate, and walk into conversations with your agent with clearer asks. Links open in a new tab. Not legal or financial advice.
Policy & statutes
CT buyer disclosure / tax context (web search)Seeded web search
Suggested query from this report:
405 Chestnut Tree Hill Rd, Oxford, CT, 06478 home PASS Zombie Listing Alert Missing Critical System Information Catastrophic Price Explosion Red Flag Missing Critical Tax Information
Schools (by ZIP)
Share & collaborate
Text to partner / family (SMS)Email draft to realtor (mailto)Paste into ChatGPT, Claude, etc., with your report link so the thread stays grounded.
Save & generate
▲ Top Findings
Zombie Listing Alert
Property has been on Zillow for 6,850 days (18+ years) with multiple failed listing attempts in 2025. Listed at $725K in May, cut to $695K in June, removed in August, relisted at $709K in September, then removed again in November before current $687K listing.
Missing Critical System Information
Listing lacks essential details about heating, cooling, parking spaces, roof condition, exterior materials, foundation type, and flooring. For a $687K purchase, buyers need comprehensive system information to assess maintenance costs and potential issues.
Catastrophic Price Explosion Red Flag
Price jumped from $470K in 2007 to current $687K asking - a 46% increase with zero evidence of renovations or improvements. No permits found for the last 10 years despite nearly doubling in value.
Missing Critical Tax Information
No property tax, assessed value, or effective tax rate data available. Cannot calculate cash flow or cap rate without this fundamental expense component.
Zombie Listing Alert - Multiple Failed Sale Attempts
Property has been repeatedly listed and removed since May 2025 with declining prices ($725K→$695K→$709K→$687K). Currently on market 6,850 days with only 5 views suggests serious underlying issues or overpricing.
Zombie Listing Alert - Multiple Failed Cycles
Property has failed to sell through three listing cycles (May 2025 to present), with price drops from $725k to $687k. Currently shows 'OTHER' status after 6850+ days on Zillow, indicating serious market rejection or undisclosed issues.
Complete Environmental Data Blackout
No information available on flood zones, contamination history, radon levels, soil conditions, or any environmental hazards for this 5-acre property. This data gap is critical for proper environmental assessment.
Complete Information Blackout
Zero data available on crime, schools quality, flood zones, permits, neighborhood trends, or environmental factors. Research yielded no meaningful intelligence about this community's trajectory or livability.
Massive Appreciation Since Purchase
Property sold for $470K in July 2007 and is now listed at $687K, representing 46% appreciation over 19 years. With no permit data or renovation evidence available, this $217K gain appears to be primarily market beta rather than property improvements.
Comparable Sales Data Issues
Nearby comps show massive price variance ($585K to $772K) with questionable data quality - one 1,150 sq ft home allegedly sold for $732K ($637/sqft vs this property's $213/sqft). Research found no reliable recent comparable sales data for proper valuation.
Expert Panel (10/10)
Failed listing with 18+ year stale ownership and massive data gaps makes this impossible to properly evaluate.
Zombie Listing Alert
Property has been on Zillow for 6,850 days (18+ years) with multiple failed listing attempts in 2025. Listed at $725K in May, cut to $695K in June, removed in August, relisted at $709K in September, then removed again in November before current $687K listing.
Massive Appreciation Since Purchase
Property sold for $470K in July 2007 and is now listed at $687K, representing 46% appreciation over 19 years. With no permit data or renovation evidence available, this $217K gain appears to be primarily market beta rather than property improvements.
Missing Critical System Information
Listing lacks essential details about heating, cooling, parking spaces, roof condition, exterior materials, foundation type, and flooring. For a $687K purchase, buyers need comprehensive system information to assess maintenance costs and potential issues.
Comparable Sales Data Issues
Nearby comps show massive price variance ($585K to $772K) with questionable data quality - one 1,150 sq ft home allegedly sold for $732K ($637/sqft vs this property's $213/sqft). Research found no reliable recent comparable sales data for proper valuation.
Elementary School Performance Concern
Quaker Farms School serving this address has a 0/10 rating, which could significantly impact family buyers and long-term resale value. The middle and high schools perform better at 7/10 and 6/10 respectively.
Zombie listing with failed sales pattern, massive unexplained price explosion, and critical system information gaps.
Zombie Listing Alert
Property has been cycling on/off market repeatedly with multiple failed sales attempts and price changes from $725K down to current $687K. Days on Zillow shows 6850 days (nearly 19 years) indicating serious marketability issues.
Catastrophic Price Explosion Red Flag
Price jumped from $470K in 2007 to current $687K asking - a 46% increase with zero evidence of renovations or improvements. No permits found for the last 10 years despite nearly doubling in value.
Missing Critical System Information
Listing completely lacks heating/cooling, roof condition, foundation type, flooring details, and parking information. This level of missing data suggests either major problems being hidden or a lazy/inexperienced listing agent.
School District Value Destroyer
Elementary school rated 0/10 is a massive red flag for resale value and family appeal. Even with middle/high schools at 6-7/10, the elementary rating will severely limit buyer pool.
Comparable Sales Disconnect
Asking $213/sqft while similar sized homes sold for $259/sqft (4020sf at $771K) and smaller homes going for $636/sqft. Either this is priced high relative to condition or location is inferior to comps.
Zombie listing with 18+ year stale ownership and catastrophic information gaps makes this uninvestable.
Zombie Listing Alert
Property has been cycling on and off market since May 2025 with multiple price cuts ($725K→$695K→$709K→$687K). Days on Zillow shows 6,850 days indicating chronic listing issues.
Massive Appreciation Since Purchase
Property jumped from $470K (2007) to current $687K ask - a 46% gain over 19 years. Without renovation permits or improvement documentation, this suggests potential overpricing versus actual condition.
Missing Critical System Information
Zero information on HVAC, roof condition, foundation type, or major systems for a 47-year-old home. This creates massive due diligence risk for any investor.
Missing Critical Tax Information
No property tax, assessed value, or effective tax rate data available. Cannot calculate cash flow or cap rate without this fundamental expense component.
Terrible Estimated Cap Rate
Rent estimate of $3,908/month yields only $46,896 annual income on $687,300 purchase. Even with minimal expenses, cap rate likely below 5% in current interest rate environment.
Classic zombie listing with massive price gaps and nearly two decades of appreciation concerns - proceed with extreme caution.
Zombie Listing Alert
This property has been sitting on Zillow for 6,850 days (nearly 19 years) with repeated failed listing attempts in 2025. Multiple price drops and removals signal serious marketability issues that first-time buyers should avoid.
Massive Appreciation Since Purchase
Property jumped from $470,000 in 2007 to current ask of $687,300 - a 46% increase over 19 years. While some appreciation is normal, this gain significantly outpaced typical market returns without any documented renovations to justify the premium.
Missing Critical System Information
Zero details about heating, cooling, roof condition, foundation, or other major systems for a 47-year-old home. This is a huge red flag - older homes need thorough system disclosures, and the silence suggests potential expensive surprises.
Concerning School Quality
The elementary school scores 0/10 and requires a 3.3-mile commute, which could impact family life and resale value. Even the high school only scores 6/10, limiting options for families with children.
Price vs Comparable Mismatch
At $213/sq ft, this property is priced above several nearby comparables. A 4-bedroom with similar square footage sold for $598,000, suggesting this 5-bedroom may be overpriced for the market.
Troubled 1970s home with chronic listing failures, missing critical systems data, and potential deferred maintenance red flags.
Zombie Listing Alert - Multiple Failed Sale Attempts
Property has been repeatedly listed and removed since May 2025 with declining prices ($725K→$695K→$709K→$687K). Currently on market 6,850 days with only 5 views suggests serious underlying issues or overpricing.
Missing Critical System Information
No data available on HVAC, electrical, plumbing, roof, foundation, or exterior materials - all critical for a 1979 home approaching major system replacement cycles. This data gap is a major inspection risk.
1979 Construction Era Concerns
Built during transition period with potential lead paint, early aluminum wiring, polybutylene plumbing, and original HVAC systems likely at end-of-life. Electrical panel and main systems need immediate professional inspection.
Massive Appreciation Since Purchase
Price increased 46% from 2007 purchase ($470K to $687K) but with no renovation permits found and generic listing description suggesting minimal updates. Appreciation may not reflect actual improvements.
Large Lot Maintenance Burden
5-acre lot (217,800 sq ft) represents significant ongoing maintenance costs and potential septic/well system responsibilities typical for rural Connecticut properties of this era.
Zombie listing with major design red flags - 18+ months on market, minimal interior details, and alarming lack of system information.
Zombie Listing Alert
Property has been cycling on and off market for 18+ months with multiple price drops from $725K to current $687K. Status shows 'OTHER' and 6,850 days on Zillow suggests serious marketability issues.
Missing Critical System Information
Complete absence of HVAC, flooring, roof, foundation, and exterior details makes renovation cost assessment impossible. For a 1979 home, these systems likely need major updates.
Bare-Bones Listing Presentation
Generic 2-sentence description with no interior photos, staging, or design features mentioned. This level of marketing effort suggests either distressed sale or poor property condition hiding behind minimal disclosure.
Dated 1979 Construction Needs Major Updates
47-year-old home likely has original kitchen, baths, flooring, and systems requiring $75K-150K+ in renovations to meet modern design standards. Layout from this era often choppy and closed-off.
Massive 5-Acre Lot Maintenance Burden
217,800 sq ft lot creates significant ongoing landscaping and maintenance costs that many buyers overlook. Could limit buyer pool to those wanting rural lifestyle with associated upkeep.
Multi-cycle listing failure with zombie status and missing critical municipal data creates high regulatory uncertainty.
Zombie Listing Alert - Multiple Failed Cycles
Property has failed to sell through three listing cycles (May 2025 to present), with price drops from $725k to $687k. Currently shows 'OTHER' status after 6850+ days on Zillow, indicating serious market rejection or undisclosed issues.
Missing Critical Zoning and Tax Information
No zoning classification, tax assessment data, or property tax rates available for analysis. This 5-acre lot in rural Connecticut could face agricultural, residential, or conservation restrictions that significantly impact development rights and value.
Large Lot Regulatory Risk
At 217,800 sq ft (5 acres), this property likely faces wetlands regulations, septic system rules, and potential conservation easements typical in rural Connecticut. State environmental policies could restrict future development or mandate costly upgrades.
School District Performance Concern
Quaker Farms Elementary shows 0/10 rating, creating potential municipal funding pressure that could drive property tax increases. Poor school performance may also limit buyer pool and resale value.
Zombie listing with failed sale pattern and missing critical system/environmental data creates significant insurance uncertainty.
Zombie Listing Alert
Property has been on market for 6850 days with multiple failed attempts - listed at $725k in May 2025, reduced to $695k, removed, relisted at $709k, then removed again in November 2025. Current listing at $687.3k represents third attempt with ongoing price cuts.
Missing Critical System Information
Heating, cooling, roof material, foundation type, and electrical systems are all unknown. These are fundamental to insurance underwriting as they affect both coverage eligibility and premium calculations.
Environmental Risk Data Void
No flood zone classification, wildfire risk assessment, or environmental hazard information available. Connecticut properties can face flood risks from coastal storms and inland flooding, making this a significant coverage gap.
Aging Property Concerns
Built in 1979 (47 years old) with no renovation permits on record. Electrical, plumbing, and HVAC systems may be original or aging, potentially affecting coverage or requiring costly updates to maintain insurability.
Large Lot Liability Exposure
5-acre lot creates significant general liability exposure and potential attractive nuisance concerns. Larger properties often have higher liability limits requirements and premium costs.
Chronic listing failure with 46% price appreciation since 2007 but zero environmental data available for this rural Connecticut property.
Complete Environmental Data Blackout
No information available on flood zones, contamination history, radon levels, soil conditions, or any environmental hazards for this 5-acre property. This data gap is critical for proper environmental assessment.
Failed Sale Pattern - Multiple Listing Cycles
Property listed and removed three times in 2025 with declining prices from $725K to $695K to current $687K. This indicates market resistance and potential underlying issues.
Zombie Listing Alert
Property shows 6,850 days on Zillow with only 5 views, suggesting stale or problematic listing data. Current status shows 'OTHER' rather than active for sale.
Rural Site Requires Environmental Due Diligence
Large 5-acre lot built in 1979 may have well water, septic systems, and potential for historical contamination. No permits or renovation data available to assess system conditions.
Unexplained Price Delta Since 2007
Property appreciated from $470K (2007) to $687K current asking price with no renovation permits or improvement documentation to justify the 46% increase beyond general market trends.
Nearly 19-year zombie listing with mysterious price patterns and zero neighborhood intelligence available.
Zombie Listing Alert
Property has been on Zillow for 6,850 days (nearly 19 years) with multiple failed listing attempts in 2025. This extreme market time suggests serious underlying issues preventing sale completion.
Failed Sale Pattern
Listed and removed three times in 2025 alone ($725K→$695K→$709K→$687.3K), indicating buyer resistance or deal-killing discoveries. Price volatility suggests uncertainty about true value.
Complete Information Blackout
Zero data available on crime, schools quality, flood zones, permits, neighborhood trends, or environmental factors. Research yielded no meaningful intelligence about this community's trajectory or livability.
Appreciation Since 2007 Purchase
Property gained 46% since 2007 purchase ($470K→$687K), which spans the housing crisis, recovery, and recent boom. Without renovation permits or local context, this appears consistent with broad market movements.