474 Glenwood Ave
Mordecai · Raleigh, NC 27610
Demo data. Every property, comp, tax record, and estimate on this page is synthetic and generated for demonstration — not a real listing. Connect MLS, PropertyRadar, ATTOM, or RentCast (and a Google Places key) to serve live data with no code changes.
Reconciled value
Similarity-weighted from comps
Overview
Original-condition multi-family property in Mordecai, Raleigh. 3 bed / 4 bath across 2,280 sqft on a 12.2k sqft lot, built in 1965. Smart thermostat, Vaulted ceilings, Solar panels.
Features
- Bedrooms
- 3
- Bathrooms
- 4
- Living area
- 2,280 sqft
- Lot size
- 12,200 sqft · 0.28 ac
- Year built
- 1,965
- Stories
- 2
- Parking
- 3 spaces
- Type
- Multi-Family
- Condition
- Dated
- Price / sqft
- $220/sqft
- School rating
- 5/10
- Walk score
- 50/100
Assessed value trend
County assessment over time
Property score
Value · condition · deal · risk · location
- Value vs. comps79 · weight 30%
Asking 1.2% below the comp-reconciled value of $520,221.
- Condition40 · weight 20%
Reported condition “Dated” — original finishes likely; budget for meaningful updates.
- Deal math30 · weight 20%
3.5% cap rate with $1,055/mo negative cash flow at default financing (25% down, 7%, 30yr).
- Risk60 · weight 15%
No flood data — FEMA returned no mapped zone for this point; scored neutral.
- Location50 · weight 15%
Schools rated 5/10; Walk Score 50/100.
Transparent formula — every input shown; demo/partial sources score neutral, not flattering.
Sale history
Listing & transaction events
- $502,000Listed$168,000
- $334,000Sold$85,000
- $249,000Sold
Ownership & records
County records (demo)
- Owner
- Elena Pemberton
- Occupancy
- Owner-occupied
- APN
- 409-74-280
- Zoning
- PUD Planned unit
- Last recorded deed
- Warranty deed · Sep 5, 2018 · $334,000
Public data
Free government sources — FEMA & U.S. Census
Checking FEMA flood zone & Census ZIP profile…
Location & environment
Live from free government & open data
Where this data comes from
Per-field source attribution from the merge layer
- List priceDemo dataset
- Value estimateDemo dataset
- Listing statusDemo dataset
- Beds / baths / sizeDemo dataset
- ConditionDemo dataset
- Comparable salesDemo dataset
- Tax historyDemo dataset
- OwnershipCounty records (demo)
- Parcel (APN)County records (demo)
- ZoningCounty records (demo)
- Last deedCounty records (demo)
- DescriptionDemo dataset
Lotline merges MLS, public records, valuation, and agent-direct feeds per field — the freshest authoritative source wins, and every figure keeps its receipt.
Comparable sales
$/sqft vs. sale price
Bubble size = similarity to subject
Value reconciliation
Where the comps land
- Comps used
- 5
- Avg adjusted
- $519,900
- Avg $/sqft
- $229
- Median $/sqft
- $234
- $/sqft range
- $214 – $243
- Implied subject $/sqft
- $228
Comparable detail (5)
Ranked by similarity, with line-item adjustments
| Comparable | Sold | Beds / Baths | Sqft | $/sqft | Sold price | Adjustments | Adjusted | Match |
|---|---|---|---|---|---|---|---|---|
1994 Fairview Rd Raleigh, NC · 0.9 mi away | Sep 21, 2025 | 3 / 4 | 2,232 | $243/sqft | $542,000 | Size +48 sqft+$9,000Age older 2y-$2,000Lot -1.3k sqft-$8,000 | ||
3214 Fairview Rd Raleigh, NC · 1.6 mi away | Jul 19, 2025 | 4 / 4.5 | 2,237 | $236/sqft | $527,000 | Size +43 sqft+$8,000Age newer 2y+$2,000Baths -0.5-$6,000 | ||
8647 Oberlin Rd Raleigh, NC · 0.3 mi away | Sep 8, 2025 | 4 / 4 | 2,534 | $220/sqft | $557,000 | Size -254 sqft-$47,500Age newer 9y+$8,000 | ||
4034 Glenwood Ave Raleigh, NC · 0.9 mi away | May 20, 2025 | 3 / 3 | 2,398 | $214/sqft | $512,000 | Size -118 sqft-$22,000Age newer 6y+$5,500Baths +1+$12,000Lot -2.9k sqft-$17,500 | ||
8101 Oberlin Rd Raleigh, NC · 0.8 mi away | Feb 25, 2025 | 2 / 3 | 1,954 | $234/sqft | $458,000 | Size +326 sqft+$61,000Age older 12y-$11,000Baths +1+$12,000 |
Property tax
Tax history
Annual bill (bars) & effective rate (line)
Latest effective rate 0.80% on a $476,420 assessment.
Tax breakdown
Latest year & projection
Investment analysis
Deal inputs
Adjust assumptions to model the return
Return summary
Annualized, at the assumptions on the left
Monthly outlay breakdown
$3,830 total per month
- Principal & interest$2,565
- Property taxes$317
- Insurance$171
- HOA$0
- Operating expenses$777
Planning estimate only. Figures use demo assumptions (30-year loan, 28% expense ratio) and do not account for closing-cost variance, capital reserves, appreciation, or tax treatment. Not financial advice.
Damage & remodel estimate
Inspector — photo condition analysis
Synthetic demo imagery — the Inspector runs its scripted demo analysis
The Inspector reads the photos room by room — condition score, detected features, flagged defects — and turns what it sees into remodel scopes, so the estimator below is filled from evidence instead of guesses.
Full cosmetic + systems
Aging systems and finishes. Expect kitchen, baths, HVAC, windows.
Scope of work
Toggle the work this property needs
Structural
Systems
Kitchen & Bath
Interior
Exterior
Budget
Regional factor 0.95× · NC
Cost by scope
Midpoint per line item
| Scope | Quantity | Low | High | Midpoint | Recoup |
|---|---|---|---|---|---|
Kitchen remodel Cabinets, counters, appliances, fixtures (mid-grade). | project | $17,100 | $42,750 | $29,925 | 72% |
Bathroom remodel Per bathroom: tile, vanity, fixtures, surround. | 4 baths | $30,400 | $72,200 | $51,300 | 66% |
Flooring LVP / engineered wood / tile throughout living areas. | 2,280 sqft | $10,830 | $25,992 | $18,411 | 70% |
Interior paint Walls, ceilings, trim — full interior repaint. | 2,280 sqft | $4,332 | $9,747 | $7,040 | 80% |
HVAC system New furnace + AC condenser, ducts as needed. | project | $6,175 | $13,775 | $9,975 | 60% |
Window replacement Energy-efficient double-pane units, whole house. | whole house | $8,550 | $19,950 | $14,250 | 68% |
| Total (6 scopes) | $77,387 | $184,414 | $130,901 | $89,598 | |
Planning estimates, not contractor bids. Ranges are demo national averages scaled by a regional factor and do not reflect a site inspection, permits, finish level, or hidden conditions. Confirm scope and pricing with licensed trades before transacting.
Studio — staging & renovation renders
Studio — staging & renovation renders
Compose a render brief for any image tool, or generate live when a provider key is configured
No listing photos on this record — Studio composes a text-to-image brief from the listed facts instead.
Document intelligence
Counsel — document intelligence
Paste an inspection report, disclosure, or HOA doc for a plain-English read and red-flag scan