🏗️ New Construction
Sequoia Plan · Hampshire, IL
Flood risk No data
- FEMA flood zone
- —
- Chance of flooding over 30 yrs
- —
- Est. flood insurance / yr
- —
Fire risk No data
- Est. fire insurance / yr
- —
Heat risk No data
- Hot days now (above threshold)
- —
- Hot days in 30 yrs
- —
Wind risk No data
- Chance of severe wind over 30 yrs
- —
Air-quality risk No data
- Unhealthy air days now
- —
- Unhealthy air days in 30 yrs
- —
Risk factors via First Street. Map © Google.
Why this score? — see what drove the F grade
The composite is a weighted blend of 9 inputs, each scored 0–100. Each bar is that input's sub-score; the figure is the points it added to the 100-point composite (weight × sub-score).
- ARV discount +7.5/15.0
- Cash flow +6.9/30.0
- Condition / age +4.0/5.0
- Livability +3.6/5.0
- Schools +2.6/10.0
- Rent growth +2.5/5.0
- 1% rule +2.0/10.0
- DSCR +1.1/10.0
- Appreciation +0.0/10.0
$359,990
🖨 Deal sheet (PDF) 📄 Offer letter ✓ Due diligence
Listing remarks
Welcome to Prairie Ridge Crossings, the lowest-priced new single-family homes in Hampshire. Schedule your visit today! The Sequoia single-family home is just as inviting as it is functional. Discover a thoughtfully designed two-story floor plan with efficient living and a bright flex space. The welcoming great room effortlessly flows into the kitchen and dining area, so you never miss a moment. Enjoy brand-new appliances included - even the washer and dryer! On the second floor, four well-proportioned bedrooms await, including a versatile flex space at the top of the stairs perfect for reading or homework nook.
Key facts
- Bright flex space
- Welcoming great room
- Large walk-in closet
Tags
Neighborhood map
What this means for you Summary
Snapshot
- This is a 4-bed/2.5-bath single-family listed at $360k. Condition is rated good.
Deal economics
- At list price, monthly cash flow is $-668 ($-8k/yr) — negative.
- To cash-flow at today's rent, offer at most $344k (4.4% below list).
- To meet the 1% rule (rent ≥ 1% of price), the offer needs to be $307k (14.7% below list).
- Recommended offer: $307k (14.7% below list) — sets the bar for 1% rule.
Location & tenants
- Location reads 71/100 on livability (#350 in IL) — a middle-class / working-renter tenant base. Strengths: crime A+, employment A+, housing A+; Watch: amenities F, commute F, health & safety F.
- CUSD 300 (suburban): math 24% / reading 27% proficiency, ranked #261 of 620 in IL (top 42%) — low school quality limits family demand, transient renter base, plan for 1-2y turnover.
- Zoned schools: Gary D Wright Elem Sch (math 24% / reading 24%, grade F, #922 of 2,056 statewide, top 45%, 638 students, 0% FRL); Hampshire Middle School (math 23% / reading 21%, grade F, #389 of 665 statewide, top 60%, 795 students, 0% FRL); Hampshire High School (math 30% / reading 35%, grade F, #152 of 693 statewide, top 22%, 1,938 students, 0% FRL) — zoned schools average 0% FRL vs 37% district-wide (37 pts lower); this property's tenant base skews higher-income than the district average.
- Market conditions: 357 active listings in the ZIP; 4 comparable units currently listed for rent nearby; rentals leasing fast (median 8d on market — plan ~1-2 weeks tenant-placement turnaround); high-income renter base; 1,944 units permitted in Kane County in 2024 (357 in 5+ unit buildings).
- This rent runs 33% of the median local income ($111k/yr) — at the standard rent-burdened threshold; future hikes will face affordability resistance.
Forward outlook
- Local home prices are declining (-3.0%/yr); year-one equity from $3k of loan paydown is wiped out by about $13k of value loss. Plan a longer hold.
Negotiation context
- It's been on market 105 days — a 9% lower offer ($328k) is reasonable based on typical stale-listing flexibility.
Questions for the listing agent
- What do current leases actually rent for vs. the listed asking? Can we see a recent rent roll and the last 12 months of T-12 income?
- It's been on market 105 days. Have you received any prior offers? Is the seller open to a 15% concession, seller financing, or rate buy-down credit?
- What does the HOA fee cover, when was the last increase, and are there any pending special assessments or reserve-fund shortfalls?
- Why hasn't it sold? Are there any deal-killer items the seller is aware of (foundation, flood, title, zoning, code violations)?
- Is there a deadline driving the sale (1031 exchange, divorce, estate, relocation)? That informs how much negotiation room exists.
- The area grade is low — what's the realistic commute time and amenity access for the typical tenant pool here? Any planned neighborhood developments (good or bad) we should know about?
- What's the average days-on-market for RENTAL listings here right now (not sales)? A rising rental-DOM trend means longer vacancies and softer asking-rent achievability than the comps imply.
- What's the recent tenant-quality profile in this submarket — average credit score on applications, eviction rate, late-payment / NSF rate, and stable-employment percentage? A property-management company in the area should have these aggregated.
- How much new for-sale + rental construction is in the pipeline within 1–3 miles? Heavy new supply typically softens prices + rents 12–24 months out; constrained supply supports both.
Investment metrics
- 1% rule
- 0.70% ✗
- Cap rate
- 4.48%
- Cash-on-cash
- -6.49%
- DSCR
- 0.71
- GRM
- 12.0
CMA / ARV
- ARV (median comp)
- $440,934
- List price
- $359,990
- Delta
- -19.94%
- Verdict
- UNDERPRICED
- Comps
- 20 within 1.0 mi
Show comp detail 12 sales within ~0.75 mi
| Address | Dist | Beds/Ba | Sqft | Sold | Price | $/sf | Match |
|---|---|---|---|---|---|---|---|
| 512 Dawns End | 0.53mi | 4/2.5 | 1,700 (-3%) | 6mo | $385,000 | $226 | 66 |
| 713 Wild Prairie Pt | 0.73mi | 4/2.5 | 1,798 (+3%) | 6mo | $405,000 | $225 | 56 |
| 1248 Linden Ter | 0.70mi | 4/2.5 | 1,847 (+6%) | 3mo | $403,990 | $219 | 55 |
| 127 Cornerstone Xing | 0.72mi | 4/2.5 | 1,847 (+6%) | 4mo | $406,990 | $220 | 54 |
| 123 Cornerstone Xing | 0.74mi | 4/2.5 | 1,847 (+6%) | 5mo | $393,990 | $213 | 52 |
| 130 Cornerstone Xing | 0.74mi | 4/2.5 | 1,847 (+6%) | 5mo | $392,990 | $213 | 52 |
| 470 E Meadowdale Cir | 0.71mi | 4/2.5 | 1,903 (+9%) | 3mo | $415,000 | $218 | 50 |
| 132 Cornerstone Xing | 0.73mi | 4/2.5 | 1,953 (+12%) | 4mo | $406,990 | $208 | 43 |
| 117 Fieldcrest Ave | 0.75mi | 4/2.5 | 1,965 (+12%) | 3mo | $435,000 | $221 | 42 |
| 1250 Linden Ter | 0.70mi | 3/2.5 (-1) | 1,561 (-11%) | 4mo | $369,990 | $237 | 41 |
| 47W185 Kelley Rd | 0.70mi | 3/1.5 (-1) | 1,579 (-10%) | 4mo | $535,000 | $339 | 38 |
| 611 W Meadowdale Cir | 0.75mi | 3/2.0 (-1) | 2,009 (+15%) | 5mo | $550,000 | $274 | 29 |
Match score weights: distance 35% · size 25% · config 20% · recency 20%. Top-matched comps best support the ARV.
Projected returns pro-forma
-3.0% appreciation · 3.0% rent growth · sell at horizon
- IRR
- -27.5%
- Equity multiple
- 0.08×
- Total profit
- $-113,905
- Equity at exit
- $65,745
- IRR
- -25.6%
- Equity multiple
- -0.24×
- Total profit
- $-153,649
- Equity at exit
- $38,124
Cash invested: $123,462 (down + closing). Projections, not guarantees.
Landlord ↔ Tenant lean methodology
- Overall (STATE)
- 43 Moderately Tenant-Leaning
- State Illinois
- 43 Moderately Tenant-Leaning · D+7
- County
- — inherits STATE
- City
- — inherits STATE
Active competition Active MLS
- For sale now
- 22 active · 21 under contract
- Months of supply
- 5.7 mo (17%/mo absorbed)
- Median asking
- $409,990 ($223/sqft)
- Median days on market
- 120 d
- This list price
- 9% of active listings are priced below it
- ARV vs active asking
- +13.1% above current asking $/sqft
Closed sales set the value; these active listings set current market conditions and a practical price ceiling.
ZIP-level market 60140
- Home prices YoY
- -24.6%
- Active inventory
- 357
- Price-to-rent
- 9.8×
Monthly cashflow live
- Estimated rent
- $3,069 medium interval (Pro) →
- Mortgage (P&I)
- −$2,312
- Tax est. 1.5%
- −$551 /mo · $6,614/yr
- Insurance
- −$184
- HOA
- −$45
- Lot rent
- −$0
- Vacancy / Maint / Mgmt
- −$644
- Net cashflow
- $-668
Break-even live
Sensitivity live
| Price | -10% $-363 | -5% $-515 | +0% $-668 | +5% $-820 | +10% $-972 |
|---|---|---|---|---|---|
| Rent | -10% $-910 | -5% $-789 | +0% $-668 | +5% $-547 | +10% $-425 |
| Rate | -1.0pp $-446 | -0.5pp $-556 | base $-668 | +0.5pp $-782 | +1.0pp $-898 |
UW: 25.0% down · 7.5% · 30yr · 1.5% tax · 5.0% vac · 8.0% maint · 8.0% mgmt
Financing live
Cash to close
- Down payment
- $110,234
- Closing costs
- $13,228
- Club membership (one-time)
- —
- Reserves months
- —
- Total cash needed
- —
Loan-product check · same deal, 3 products live
Conventional
25% down · 7.5% · 30yr
- Cash invested
- —
- Monthly P&I
- —
- Monthly cashflow
- —
- DSCR
- —
- Eligible?
- —
Personal DTI + credit; lowest rate.
DSCR
20% down · 8.5% · 30yr
- Cash invested
- —
- Monthly P&I
- —
- Monthly cashflow
- —
- DSCR
- —
- Eligible?
- —
No personal income docs; deal must DSCR.
Hard money
10% down · 12.0% · 12mo
- Cash invested
- —
- Monthly P&I
- —
- Monthly cashflow
- —
- DSCR
- —
- Eligible?
- —
Short-term bridge; refi at stabilization.
Rent comps 4 comps
| Address | Beds | Baths | Sqft | Rent | $/sqft | DOM | Units | Dist |
|---|---|---|---|---|---|---|---|---|
| 870 Briar Glen Ct Hampshire, IL | 3.0 | 2.5 | 1760 | $2,600 | $1.48 | 7d | 1 | 0.47mi |
| 863 Briar Glen Ct Unit 863 Hampshire, IL | 3.0 | 2.5 | 1758 | $2,595 | $1.48 | 139d | 1 | 0.52mi |
| 101 Fieldcrest Ave Hampshire, IL | 3.0 | 2.5 | 1561 | $2,800 | $1.79 | 0d | 1 | 0.84mi |
| 179 Terrabrook Way Hampshire, IL | 3.0–4.0 | 2.5 | 1828 | $2,825 | $1.55 | 0d | 1 | 1.13mi |
Property features AI
Finance
- Other
- Address: Sequoia Plan, Hampshire, IL 60140Status: Active
- Financial info
- List price $339,990
Exterior
- Parking
- 2 parking spaces
- Utilities
- Central air conditioning
- Home design
- Plan: SequoiaNew construction plan
- Exterior features
- Living area approximately 1,749
Interior
- Bedrooms
- 4 bedrooms
- Bathrooms
- 2 full bathrooms and 1 half bathroom (2.5 total)
- Heating & cooling
- Central air
- Interior features
- Central air conditioning
Listing history 50 events
-
2026-09-23days on market $359,990 Active 105 DOM
-
2026-09-22days on market $359,990 Active 104 DOM
-
2026-09-21days on market $359,990 Active 103 DOM
-
2026-09-20days on market $359,990 Active 102 DOM
-
2026-09-19days on market $359,990 Active 101 DOM
-
2026-09-18days on market $359,990 Active 100 DOM
-
2026-09-17pricedays on market $359,990 Active 99 DOM
-
2026-09-16days on market $352,990 Active 98 DOM
-
2026-09-15days on market $352,990 Active 97 DOM
-
2026-09-14days on market $352,990 Active 96 DOM
-
2026-09-13days on market $352,990 Active 95 DOM
-
2026-09-12days on market $352,990 Active 94 DOM
-
2026-09-11days on market $352,990 Active 93 DOM
-
2026-09-05days on market $352,990 Active 87 DOM
-
2026-09-04days on market $352,990 Active 86 DOM
-
2026-09-02days on market $352,990 Active 84 DOM
-
2026-08-31days on market $352,990 Active 82 DOM
-
2026-08-30days on market $352,990 Active 81 DOM
-
2026-08-29days on market $352,990 Active 80 DOM
-
2026-08-28days on market $352,990 Active 79 DOM
-
2026-08-27days on market $352,990 Active 78 DOM
-
2026-08-26days on market $352,990 Active 77 DOM
-
2026-08-25days on market $352,990 Active 76 DOM
-
2026-08-24days on market $352,990 Active 75 DOM
-
2026-08-23days on market $352,990 Active 74 DOM
-
2026-08-22days on market $352,990 Active 73 DOM
-
2026-08-21days on market $352,990 Active 72 DOM
-
2026-08-20days on market $352,990 Active 71 DOM
-
2026-08-19days on market $352,990 Active 70 DOM
-
2026-08-18days on market $352,990 Active 69 DOM
-
2026-08-17days on market $352,990 Active 68 DOM
-
2026-08-16days on market $352,990 Active 67 DOM
-
2026-08-15days on market $352,990 Active 66 DOM
-
2026-08-14days on market $352,990 Active 65 DOM
-
2026-08-13days on market $352,990 Active 64 DOM
-
2026-08-12days on market $352,990 Active 63 DOM
-
2026-08-11days on market $352,990 Active 62 DOM
-
2026-08-10days on market $352,990 Active 61 DOM
-
2026-08-09days on market $352,990 Active 60 DOM
-
2026-08-08days on market $352,990 Active 59 DOM
-
2026-08-06days on market $352,990 Active 57 DOM
-
2026-08-05days on market $352,990 Active 56 DOM
-
2026-08-04days on market $352,990 Active 55 DOM
-
2026-08-03pricedays on market $352,990 Active 54 DOM
-
2026-07-31days on market $349,990 Active 51 DOM
-
2026-07-30days on market $349,990 Active 50 DOM
-
2026-07-30days on market $349,990 Active 49 DOM
-
2026-07-28days on market $349,990 Active 48 DOM
-
2026-07-26days on market $349,990 Active 46 DOM
-
2026-07-24days on market $349,990 Active 44 DOM
ⓘ Source: listings_history table (triggers on properties + properties_extension) + one-shot
backfill from property_details.listing_events for pre-trigger history.
Nearby sold comps map
Loading sold comps map…
Walkable amenities ~0.75 mi
Loading nearby amenities…
Taxation est. · year 1
- Rental income
- $36,827
- − Mortgage interest
- −$24,699
- − Property taxes
- −$6,614
- − Insurance
- −$2,205
- − Repairs & maintenance
- −$2,946
- − Management
- −$2,946
- − HOA
- −$540
- − Depreciation
- −$12,827
- Taxable loss
- −$15,950
- Est. tax savings @ 24.0%
- +$3,828
- After-tax cash flow
- $-4,185/yr
For passive investors: Depreciation is non-cash, so a rental often shows a tax loss while cash-flowing — sheltering income. Rental losses are passive: they offset passive income freely, and up to $25,000/yr can offset ordinary (W-2) income if you actively participate and your MAGI is under $100k (phasing out to $0 by $150k); unused losses carry forward. On sale, claimed depreciation is recaptured at up to 25%, and gains may owe capital-gains tax (a 1031 exchange can defer both). Figures are a year-1 estimate at your 24.0% rate — not tax advice; consult a CPA.
Condition & rehab AI · 2 photos
The home is in good condition with a cosmetic rehab level, featuring a well-maintained exterior and interior. Minor updates such as painting and landscaping can significantly increase its value.
Value-add opportunities
- Both Painting the exterior siding — Fresh paint can enhance the curb appeal and increase the home's value ↑
- Both Landscaping improvements — A well-maintained landscape can increase the home's curb appeal and attract more potential buyers ↑
- Both Interior touch-ups — Fresh paint and minor touch-ups can improve the home's appearance and increase its value ↑
ⓘ Rehab cost is a screening estimate — Cosmetic scope × the home's square footage at US $/sqft rules of thumb (the same model as the Flip Finder). Get contractor quotes + a written scope before underwriting.
Zoned Schools
Schools (NCES district)
- District
- CUSD 300
- NCES district ID
- 1708550
- Math proficiency
- 24% ▼ -12.00%
- Reading proficiency
- 27% ▼ -11.00%
- Median HH income
- $77,706
- Composite
- 25.12/100
- National rank
- #7524
- State rank
- #261 of 620 in IL
Livability — Hampshire
- Score
- 71/100
- State rank
- #350
- US rank
- #7222
Category grades
Schools grade is shown separately in the Schools card above.
Census & demographics
- Census place
- Hampshire, IL
- County
- Kane County · 559,449 people
- City population
- 22,689
- Metro
- Chicago-Naperville-Elgin, IL-IN-WI
- Population (ZIP)
- 22,689
- Household income
- $111,241
- Rent vs Own
- Severe rent burden
- 14% of renters
Population outlook (Kane County) Hauer SSP2
- Today (2025)
- 559,449 people
- By 2030
- 568,757 · +1.7%
- By 2040
- 575,969 · +3.0%
- By 2050
- 563,477 · +0.7%
- By 2075
- 492,321 · -12.0%
- By 2100
- 380,943 · -31.9%
Race, ethnicity, and origin ACS 2023
- Neighborhood character
- Predominantly White (70%)
- Race & ethnicity
- White 70% Hispanic / Latino 15% Two or more races 7% Asian 6% Black 5%
- Hispanic origin (detail)
- Mexican 11%
- Common ancestry
- Romanian 12% Lithuanian 3% Italian 2%
- Foreign-born
- 11% · Canada, Jamaica
- Languages at home
- 83% English-only · Spanish 11% Russian/Polish/Slavic 2% Tagalog/Filipino 2%
Political lean MEDSL · Kane
- 2024 margin
- Lean D (+9.4) · D 54.0% · R 44.6% · Other 1.4%
- 2008→2024 swing
- -2.4pp toward R · 2008: 11.8pp · 2024: 9.4pp
- All cycles
- 2024: D+9.4 2020: D+14.4 2016: D+8.9 2012: D+0.9 2008: D+11.8
Not yet ingested
- Civics
- —
Market trends
- HPI YoY
- ▼ -71.68%
- Current HPI
- 219.0902
- Rent YoY
- —
- Metro
- Chicago-Naperville-Elgin, IL-IN-WI
- State GDP YoY
- ▲ 1.59%
- F500 in state
- 60
Industry mix (Fortune 500 HQ in IL)
| Industry | F500 HQs | Revenue |
|---|---|---|
| Insurance | 4 | $201B |
|
||
| Consumer Goods | 4 | $87B |
|
||
| Industrial Machinery | 3 | $64B |
|
||
| Healthcare | 2 | $55B |
|
||
| Retail / Pharmacy | 1 | $148B |
|
||
| Agriculture / Food | 1 | $86B |
|
||
Cash-flow waterfall
monthlySold comps — $/sqft
last 12 mo · ≤1 miLoading sold comps…