4835 Duke Philip Dr Unit 39A · Hilliard, OH 43026

$214,500

3 bd · 2.5 ba · 1,344 sqft · Condo public records · 22 Days on market

Built 1989 $153/mo HOA · 7% of rent

---

Why this score? — see what drove the D 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).

• Cash flow +11.1/30.0
• ARV discount +7.5/15.0
• Schools +5.3/10.0
• 1% rule +4.6/10.0
• Livability +4.4/5.0
• DSCR +3.2/10.0
• Rent growth +2.8/5.0
• Condition / age +2.5/5.0
• Appreciation +0.0/10.0

Listing remarks MLS

Two family , 3 bed Rms- 2 1/2 baths, . Non conforming condo to be sold with adjoining 4937 Duke Phillip. New tenants. Do not disturb. Both sides new lease $925 per mo. Newer carpet/vinyls, paint furnace/CA, hot water tank. Master bedroom w/ full bath, generous bedrooms, convenient lst floor lav. Minutes to schools. Curb offers with lender preapproval letter. Great location. Home Gard 1 yr Warranty.

Key facts

• $153 HOA
• 2 garage spots
• Built 1989

Property features AI

Finance

• Other: Home warranty included
• HOA & community: Homeowners association with a monthly fee of $153 covering lawn care, trash, and snow removal

Exterior

• Parking: Attached garage with 1 garage space
• Utilities: Public water; Public sewer
• Home design: Condominium (townhouse-style) built in 1989; Two levels; End unit with one common wall
• Construction: Townhouse structure
• Exterior features: Block foundation

Interior

• Flooring: Carpet; Vinyl
• Bathrooms: Two full bathrooms and one half bathroom (total 3 bathrooms)
• Heating & cooling: Forced air heating; Central air conditioning
• Interior features: Full basement

What this means for you Summary

Snapshot

• This is a 3-bed/2.5-bath condo listed at $214k.

Deal economics

• At list price, monthly cash flow is $-85 ($-1k/yr) — negative.
• To cash-flow at today's rent, offer at most $199k (7.0% below list).
• To meet the 1% rule (rent ≥ 1% of price), the offer needs to be $206k (4.0% below list).
• Recommended offer: $199k (7.0% below list) — sets the bar for cash-flow.
• Cap rate 5.8% vs local median 1.8% in Hilliard — top-decile yield for the area; either an underpriced asset or a hidden risk that comps aren't pricing in. Stress-test before assuming the spread holds.

Location & tenants

• Location reads 87/100 on livability (#34 in OH, #331 nationally) — a professional / high-income tenant draw. Strengths: crime A+, employment A+, housing A+; Watch: commute F.
• Hilliard City (suburban): math 57% / reading 62% proficiency, ranked #246 of 656 in OH (top 38%) — acceptable for families but not a draw, mixed tenant base, ~2y average lease; only 20% free/reduced lunch — higher-income household profile.
• Zoned schools: Avery Elementary School (math 57% / reading 62%, grade B-, #670 of 1,584 statewide, top 45%, 424 students, 19% FRL); Hilliard Weaver Middle School (math 65% / reading 65%, grade A-, #194 of 654 statewide, top 31%, 880 students, 25% FRL); Hilliard Davidson High School (math 51% / reading 66%, grade C, #265 of 781 statewide, top 34%, 1,891 students, 20% FRL) — zoned schools at 21% FRL track the district average.
• Market conditions: Rents rising (+1.2%/yr); 256 active listings in the ZIP; 30 comparable units currently listed for rent nearby; rentals leasing fast (median 10d on market — plan ~1-2 weeks tenant-placement turnaround); high-income renter base; 8,139 units permitted in Franklin County in 2024 (5,940 in 5+ unit buildings).

Forward outlook

• Local home prices are declining (-3.0%/yr); year-one equity from $1k of loan paydown is wiped out by about $6k of value loss. Plan a longer hold.
• Franklin County population projected at +34% by 2050 — long-run rental-demand tailwind backs the buy-and-hold thesis.

Negotiation context

• It's been on market 22 days — a 2% lower offer ($211k) is reasonable based on typical stale-listing flexibility.
• 2 sale attempts since 10y ago with the ask held roughly flat each time — persistent listings suggest the price (not the market) is what's stuck; bring a comps-based counter.
• Current owner paid $75k; list at $214k implies a 186% gain — meaningful room to come down on a strong offer.

Recommended offer $199,491 (7.0% below list)

Questions for the listing agent

1. 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?
2. What does the HOA fee cover, when was the last increase, and are there any pending special assessments or reserve-fund shortfalls?
3. Any open or pending special assessments — roof, HVAC, plumbing, elevator, façade? What's the per-unit balance and payoff schedule, and is the seller paying it off at close or rolling it to the buyer?
4. Is there a deadline driving the sale (1031 exchange, divorce, estate, relocation)? That informs how much negotiation room exists.
5. Schools are A-rated — typically a magnet for longer-tenancy family renters. What's the average tenant stay here, and is there a school-zone premium baked into asking?
6. 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?
7. 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.
8. 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.
9. How much new apartment / multifamily construction is in the pipeline within 1–3 miles? Heavy new supply (>2% of stock underway) typically softens rents 12–24 months out; light construction supports rent growth.

Investment metrics

• 1% rule: 0.96% ✗
• Cap rate: 5.82%
• Cash-on-cash: -1.70%
• DSCR: 0.92
• GRM: 8.7

CMA / ARV

No comps found within radius.

Projected returns pro-forma

-3.0% appreciation · 1.25% rent growth · sell at horizon

5-year hold

• IRR: -21.3%
• Equity multiple: 0.27×
• Total profit: $-43,562
• Equity at exit: $31,983

10-year hold

• IRR: -20.2%
• Equity multiple: 0.03×
• Total profit: $-58,324
• Equity at exit: $18,546

Cash invested: $60,060 (down + closing). Projections, not guarantees.

Landlord ↔ Tenant lean methodology

• Overall (STATE): 73 Landlord-Friendly
• State Ohio: 73 Landlord-Friendly · R+6
• County: — inherits STATE
• City: — inherits STATE

3-day notice; Cleveland / Columbus have some habitability code enforcement; otherwise landlord-leaning.

Methodology + full state rankings →

ZIP-level market 43026

• Rents YoY: 1.2%
• Active inventory: 256
• Price-to-rent: 8.7×

Monthly cashflow live

• Estimated rent: $2,060 high
• Mortgage (P&I): −$1,125
• Tax from tax record: −$345 /mo · $4,139/yr
• Insurance: −$89
• HOA: −$153
• Vacancy / Maint / Mgmt: −$433
• Net cashflow: $-85

Break-even live

Break-even rent $2,167

Max offer price $199,491

Occupancy floor 99%

Sensitivity live

Price	-10% $36	-5% $-24	+0% $-85	+5% $-146	+10% $-206
Rent	-10% $-248	-5% $-166	+0% $-85	+5% $-4	+10% $78
Rate	-1.0pp $23	-0.5pp $-30	base $-85	+0.5pp $-141	+1.0pp $-197

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: $53,625
• Closing costs: $6,435
• Reserves months: —
• Total cash needed: —

Rent comps 30 comps

Address	Beds	Baths	Sqft	Rent	$/sqft	DOM	Units	Dist
4884 Leybourne Dr Hilliard, OH	3.0	1.5	1685	$2,414	$1.43	45d	1	0.25mi
4964 Abberton Ct Hilliard, OH	3.0	2.0	1172	$2,350	$2.01	45d	1	0.27mi
4663 Crystal Ball Dr Hilliard, OH	1.0–2.0	1.0–2.5	1180	$1,889	$1.60	6d	9	0.48mi
5220 Riggins Run Rd Dublin, OH	1.0–2.0	1.0–2.0	930	$2,018	$2.17	0d	27	0.70mi
5252 Riggins Run Dublin, OH	1.0–2.0	1.0–2.0	970	$1,838	$1.89	0d	15	0.75mi
5288 Royal Arch Cascade Dr Dublin, OH	2.0	2.5	1224	$1,850	$1.51	5d	1	0.80mi
5261 Berthold Pass Dr Columbus, OH	2.0	2.5	1248	$1,900	$1.52	5d	1	0.91mi
5464 Eagle River Dr Dublin, OH	2.0	2.0	1313	$2,430	$1.85	0d	7	1.09mi
5787 Passage Creek Dr Unit 1 Dublin, OH	2.0	3.0	1456	$2,200	$1.51	19d	1	1.13mi
5787 Passage Creek Dr Dublin, OH	2.0	2.5	1456	$2,200	$1.51	19d	1	1.13mi
5399 Grand Dr Dublin, OH	1.0–3.0	1.0–2.5	1145	$2,803	$2.45	0d	30	1.18mi
5845 Marble Creek St Dublin, OH	3.0	1.5	1244	$2,049	$1.65	0d	1	1.25mi
5845 Marble Creek St Dublin, OH	3.0	1.5	1244	$2,049	$1.65	5d	1	1.25mi
4761 Riggins Rd Dublin, OH	1.0–2.0	1.0–2.5	1221	$2,550	$2.09	0d	13	1.32mi
5260 Franklin St Hilliard, OH	1.0–2.0	1.0–2.0	792	$1,735	$2.19	4d	11	1.33mi
4460 Mountain Laurel Rd Hilliard, OH	1.0–3.0	1.0–2.0	921	$2,034	$2.21	4d	30	1.34mi
5037 Vail Pine Pl Dublin, OH	2.0	2.0	1343	$1,840	$1.37	45d	1	1.36mi
5677 Laurel Pine Ln Dublin, OH	2.0	2.0	1165	$1,640	$1.41	25d	1	1.37mi
6007 Haydens Crossing Blvd Dublin, OH	2.0	2.5	1335	$2,500	$1.87	9d	1	1.39mi
4003 Darby Park Rd Hilliard, OH	3.0	3.0	1574	$2,373	$1.51	45d	1	1.40mi
5027 Stratford Pine Ln Dublin, OH	2.0	2.0	1284	$1,795	$1.40	45d	1	1.41mi
5755 Laurel Pine Ln Dublin, OH	2.0	2.0	1180	$1,595	$1.35	45d	1	1.43mi
5002 Stratford Pine Ln Dublin, OH	2.0	2.5	1347	$2,015	$1.50	45d	1	1.44mi
1745 Sledge Dr Hilliard, OH	1.0–2.0	1.0–2.5	983	$2,052	$2.09	3d	12	1.47mi
5080 Aspen Pine Blvd Dublin, OH	2.0	2.0	1165	$1,595	$1.37	45d	1	1.48mi
4978 Aspen Pine Blvd Dublin, OH	2.0	2.0	1180	$1,640	$1.39	9d	1	1.48mi
5137 Foxtail Pine St Dublin, OH	2.0	2.0	1319	$1,850	$1.40	45d	1	1.48mi
4918 Stratford Pine Ln Dublin, OH	2.0	1.0	950	$1,440	$1.52	9d	1	1.49mi
5168 Foxtail Pine St Dublin, OH	2.0	2.0	1403	$1,910	$1.36	45d	1	1.49mi
5814 Avery Crest Dr E Dublin, OH	1.0–3.0	1.0–2.0	971	$1,990	$2.05	45d	1	1.49mi

HOA detail condo

• Monthly dues: $153 · $1,836/yr
• Likely covers: water
• Assessments: None detected in remarks — confirm with the listing agent.

Listing history 18 events

1. 2026-06-18
   status $214,500 Pending 22 DOM
2. 2026-06-17
   days on market $214,500 Active 22 DOM
3. 2026-06-16
   days on market $214,500 Active 21 DOM
4. 2026-06-15
   days on market $214,500 Active 20 DOM
5. 2026-06-13
   remarks 695-char remark
6. 2026-06-13
   days on market $214,500 Active 18 DOM
7. 2026-06-09
   days on market $214,500 Active 14 DOM
8. 2026-06-08
   days on market $214,500 Active 13 DOM
9. 2026-06-07
   days on market $214,500 Active 12 DOM
10. 2026-06-05
    days on market $214,500 Active 9 DOM
11. 2026-06-03
    days on market $214,500 Active 8 DOM
12. 2026-06-02
    days on market $214,500 Active 7 DOM
13. 2026-06-01
    days on market $214,500 Active 6 DOM
14. 2026-05-31
    days on market $214,500 Active 5 DOM
15. 2026-05-26
    listed $214,500 Active
16. 2016-07-25
    soldstatus $75,000 Closed 402-char remark

    Show marketing remark (402 chars)

    Two family , 3 bed Rms- 2 1/2 baths, . Non conforming condo to be sold with adjoining 4937 Duke Phillip. New tenants. Do not disturb. Both sides new lease $925 per mo. Newer carpet/vinyls, paint furnace/CA, hot water tank. Master bedroom w/ full bath, generous bedrooms, convenient lst floor lav. Minutes to schools. Curb offers with lender preapproval letter. Great location. Home Gard 1 yr Warranty.

17. 2016-06-09
    historical Contingent Finance and Inspection 402-char remark

    Show marketing remark (402 chars)

    Two family , 3 bed Rms- 2 1/2 baths, . Non conforming condo to be sold with adjoining 4937 Duke Phillip. New tenants. Do not disturb. Both sides new lease $925 per mo. Newer carpet/vinyls, paint furnace/CA, hot water tank. Master bedroom w/ full bath, generous bedrooms, convenient lst floor lav. Minutes to schools. Curb offers with lender preapproval letter. Great location. Home Gard 1 yr Warranty.

18. 2016-06-02
    listed $75,000 Active 402-char remark

    Show marketing remark (402 chars)

    Two family , 3 bed Rms- 2 1/2 baths, . Non conforming condo to be sold with adjoining 4937 Duke Phillip. New tenants. Do not disturb. Both sides new lease $925 per mo. Newer carpet/vinyls, paint furnace/CA, hot water tank. Master bedroom w/ full bath, generous bedrooms, convenient lst floor lav. Minutes to schools. Curb offers with lender preapproval letter. Great location. Home Gard 1 yr Warranty.

ⓘ Source: listings_history table (triggers on properties + properties_extension) + one-shot backfill from property_details.listing_events for pre-trigger history.

Tax reassessment forecast OH · Partial reset (capped growth)

• Current annual tax: $4,139 · $345/mo
• Projected year-2 tax: $4,139 · $345/mo
• Expected delta: $0/yr ($0/mo · 0.0%)

ⓘ Screening estimate from a state-policy table — verify with the county assessor before closing.

Climate risk First Street

• 🌊 Flood 1/10 Low FEMA zone X (unshaded) · 0% chance over 30 yrs
• 🔥 Wildfire 1/10 Low
• 🌡 Heat 3/10 Moderate 7 d/yr ≥100°F today · 18 d/yr by 30 yrs out
• 💨 Wind 2/10 Low 100% chance of damaging wind over 30 yrs
• 🫁 Air quality 3/10 Moderate 3 unhealthy d/yr today · 4 by 30 yrs out

Taxation est. · year 1

• Rental income: $24,717
• − Mortgage interest: −$12,015
• − Property taxes: −$4,139
• − Insurance: −$1,072
• − Repairs & maintenance: −$1,977
• − Management: −$1,977
• − HOA: −$1,836
• − Depreciation: −$6,240
• Taxable loss: −$4,541
• Est. tax savings @ 24.0%: +$1,090
• After-tax cash flow: $70/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.

Schools (NCES district)

• District: Hilliard City
• NCES district ID: 3904701
• Math proficiency: 57% ▼ -14.00%
• Reading proficiency: 62% ▼ -6.00%
• Median HH income: $77,944
• Composite: 53.32/100
• National rank: #1479
• State rank: #246 of 656 in OH

Livability — Hilliard

• Score: 87/100
• State rank: #34
• US rank: #331

Category grades

Amenities B+ Commute F Cost of living B Crime A+ Employment A+ Housing A+ Health & safety A+ User ratings A+

Schools grade is shown separately in the Schools card above.

Census & demographics

• Census place: Hilliard, OH
• County: Franklin County · 1,351,780 people
• City population: 65,238
• Metro: Columbus, OH
• Population (ZIP): 65,238
• Household income: $111,440
• Rent vs Own: 31.7% rent · 68.3% own
• Severe rent burden: 1356.0

Population outlook (Franklin County) Hauer SSP2

• Today (2025): 1,456,139 people
• By 2030: 1,556,890 · +6.9%
• By 2040: 1,757,349 · +20.7%
• By 2050: 1,950,539 · +34.0%
• By 2075: 2,376,171 · +63.2%
• By 2100: 2,636,796 · +81.1%

Race, ethnicity, and origin ACS 2023

• Neighborhood character: Predominantly White (76%)
• Race & ethnicity: White 76% Two or more races 7% Asian 6% Black 6% Hispanic / Latino 6%
• Hispanic origin (detail): Mexican 2%
• Common ancestry: Romanian 4% Italian 2% Lithuanian 2%
• Foreign-born: 11% · Canada, China
• Languages at home: 85% English-only · Spanish 4% Other Indo-European 3% Arabic 2%

Political lean MEDSL · Franklin

• 2024 margin: Strong D (+28.4) · D 63.7% · R 35.3% · Other 1.0%
• 2008→2024 swing: +7.7pp toward D · 2008: 20.7pp · 2024: 28.4pp
• All cycles: 2024: D+28.4 2020: D+31.4 2016: D+25.9 2012: D+21.7 2008: D+20.7

Not yet ingested

• Civics: —

Market trends

• HPI YoY: ▼ -277.31%
• Current HPI: 268.491
• Rent YoY: ▲ 1.25%
• Metro: Columbus, OH
• State GDP YoY: ▲ 1.98%
• F500 in state: 48

Industry mix (Fortune 500 HQ in OH)

Industry	F500 HQs	Revenue
▸Insurance	3	$145B
▸Industrial Machinery	3	$49B
▸Financial Services	3	$24B
▸Consumer Goods	2	$93B
▸Aerospace / Defense	2	$47B
▸Utilities	2	$33B

Price history

+186.0% since first listed

4 events — show timeline

• 2026-05-26 Listed $214,500 CBRMLS
• 2016-07-25 Sold (MLS) $75,000 CBRMLS
• 2016-06-09 Contingent — CBRMLS
• 2016-06-02 Listed $75,000 CBRMLS

Property tax history

+5.6%/yr

Latest (2024): $4,139 · +22.2% YoY. Source: county tax records.