Tucked within the highly sought-after Hampsted community, this extensively renovated 4-bedroom, 2.5-bath residence showcases timeless architecture, thoughtfully curated updates, and one of the neighborhood's rare oversized fenced homesites. The main level features 9-foot ceilings, solid hardwood flooring, fresh designer paint, custom millwork and accent walls, updated lighting, and a stunning redesigned staircase. The beautifully renovated kitchen offers leathered granite countertops, refinished cabinetry, a tile backsplash, new sink and faucet, Samsung stainless steel appliances, a large center island, and casual dining space. A vaulted great room with fireplace opens to the backyard, while formal living and dining rooms and a redesigned mudroom with brick flooring and custom built-ins add both elegance and functionality. Upstairs, new carpeting leads to a completely renovated vaulted owner's suite with a walk-in closet and spa-inspired bath. Three additional bedrooms, including a flexible bonus room, share an updated full bath with dual vanities. Outside, the professionally landscaped backyard is designed for entertaining with a brick patio, built-in grilling station, additional entertaining space, and exceptional privacy. Additional improvements include a new roof, new A/C, new glass in most windows, updated exterior lighting, a finished front porch ceiling, and epoxy-coated garage floors. Located just minutes from New Albany Schools, Taylor Farm Park, leisure trails, shopping, dining, and the Village Center, this move-in-ready home offers an exceptional combination of luxury finishes, extensive updates, and an unbeatable location.
Est. $3,413 per month, based on comparable rentals
Sale and tax history for 5597 Harlem Rd
Sale History
Tax History
Date
Event
Price
CBRMLS #226027583
Aug 24, 2026
Sold
$865,000
$298/sq ft
Jul 26, 2026
Contingent
—
Jul 24, 2026
Listed
$799,000
$275/sq ft
Jul 22, 2026
Coming Soon
$799,000
$275/sq ft
CBRMLS #216042177
Mar 15, 2017
Sold
$342,500
$118/sq ft
Feb 1, 2017
Contingent
—
Dec 12, 2016
Price Changed
$354,900
$122/sq ft
Dec 2, 2016
Listed
$369,900
$127/sq ft
+30
There’s room for everyone in this must-see home in popular Hampsted Green on hard-to-find oversized lot! This 4-BR, 2.5-BA home offers an open plan w/ hardwood floors & brand new carpeting on the 1st level. Formal living/dining room combo leads to spacious island kitchen w/ SS appliances, tile backsplash & casual dining area. Roomy vaulted great room features a fireplace & access to patio & backyard. Upstairs you’ll find the vaulted master suite w/ WI closet & private bath w/ soaking tub & glass shower. Also on 2nd level are 2 add’l bedrooms, full bath w/ dual sinks, & 4th bedroom/bonus room. Enormous backyard is fully fenced & includes brick patio, large wooden play structure & irrigation system. Location is ideal – close to village center, shopping, dining, leisure trails & NA Schools!
CBRMLS #2835875
Oct 31, 2008
Sold
$298,000
$103/sq ft
Sep 23, 2008
Listing Removed
—
Aug 21, 2008
Listed
$309,416
$107/sq ft
+12
This home in the Hampsted Green subdivision sits on a great over sized fenced lot. The 4-BR, 2 BA home boasts stainless steel appls. , irrigation system and plenty of room for play. The 1st floor layout is made for entertaining!
CBRMLS #2400748
Mar 17, 2004
Sold
$308,000
$106/sq ft
Jan 8, 2004
Listed
$309,900
$107/sq ft
Year
Property tax
Land + Additions
Assessment*
2025
$11,066
$55,825 + $147,595
$203,420
2024
$11,063 (+0.8%)
$55,825 + $147,595
$203,420
2023
$10,972 (+6.5%)
$55,825 + $147,595
$203,420
2022
$10,302 (+4.3%)
$33,600 + $112,070
$145,670
2021
$9,877 (+0.8%)
$33,600 + $112,070
$145,670
2020
$9,795 (+10.8%)
$33,600 + $112,070
$145,670
2019
$8,840 (+0.2%)
$28,000 + $91,455
$119,455
2017
$8,826 (+5.4%)
$28,000 + $91,455
$119,455
2016
$8,375 (−0.2%)
$22,295 + $81,865
$104,160
2015
$8,394 (−0.9%)
$22,295 + $81,865
$104,160
2014
$8,469
$22,295 + $81,865
$104,160
Public record
Public record
Zoning
Beds
4
Baths
2.5
Stories
2.5
Lot width
—
Lot depth
—
Lot size
0.37 Acres
Year renovated
2000
Sq. Ft.
2,903
Year built
2000
Style
Single Family Residential
County
Franklin County
APN
545-237753-00
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Sep 23, 2026.
SR
Suburban Residential District
The following districts provide an opportunity for development of single, twin-single, three and four unit dwellings, manufactured housing, specific public uses, religious and educational, and accessory uses with specific denoted standards structured to ensure the health, safety and general welfare of the residents in these districts.
Permitted uses
Include but are not limited to:
Agriculture
Greenhouse / nursery
Community / recreation center
Religious facility
Housing-Single unit
Educational/school
Library
Agriculture-Cropland
Park & open space
Property details
Parking
Parking and Garage Information
Has Garage
# of Garage Spaces: 2
Parking Features: Garage Door Opener, Attached Garage, Side Load
Interior
Bathroom Information
# of Full Bathrooms: 2
# of Half Bathrooms: 1
Bathrooms Total Integer: 3
Bathrooms Total Decimal: 2.5
Heating & Cooling
Has Cooling
Cooling: Central Air
Has Heating
Heating: Forced Air
Interior Features
Living Area: 2903.0
Flooring: Carpet
Window Features: Insulated All
Has Fireplace(s)
Fireplace Features: One, Gas Log
Basement: Crawl Space, Partial
Has Basement
Exterior
Exterior Features
Patio And Porch Features: Patio
Fencing: Fenced
Foundation Details: Block
Property Information
Property Sub-Type: Single Family Residence
Year Built: 2000
Common Walls: No Common Walls
Levels: Two
Security Features: Security System
Building Area Total: 2903.0
Building Area Source: Realist
Lot Information
Lot Size Area: 0.37
Lot Size Square Feet: 16117.2
Lot Size Acres: 0.37
Financial
Tax Information
Tax Annual Amount: $11,066
Tax Year: 2025
Utilities
Utilities Information
Sewer: Public Sewer
Water Source: Public
Location
HOA Information
Has Homeowners Association
Association Amenities: Bike/Walk Path, Park, Sidewalk
Association Fee: $594.32
Association Fee Frequency: Annually
Association Phone: 614-939-8601
School Information
High School District: NEW ALBANY PLAIN LSD 2508 FRA CO.
Location Information
Township: None
Subdivision Name: Hampsted Green
Public facts
Beds: 4
Baths: 2.5
Sq. Ft.: 2,903
Stories: 2.5
Lot Size: 0.37 acres
Style: Single Family Residential
Year Built: 2000
Year Renovated: 2000
County: Franklin County
APN: 545-237753-00
Home facts updated by county records on Sep 23, 2026
Other
Information For Agents
Special Listing Conditions: Standard
Around this home
Schools
New Albany Early Learning Center
Public PreK-K • Assigned • 0.8mi
New Albany Middle School
Public 7-8 • Assigned • 1.2mi
8/10
New Albany High School
Public 9-12 • Assigned • 1.1mi
9/10
Provided by GreatSchools
Climate risks
1/10 Flood Factor
Minimal risk of a flood reaching the building in the next 30 years
1/10 Fire Factor
Unlikely to be in a wildfire in next 30 years
3/10 Heat Factor
7 days above 98° expected this year, 18 days in 30 years
2/10 Wind Factor
0% chance of strong winds in next 30 years
3/10 Air Factor
3 unhealthy days expected this year, 5 days in 30 years
Provided by First Street
Historical weather
New Albany, OH • 43054
Average low and high temperatures (°F)
30
16
39
24
59
37
68
46
70
52
82
64
86
68
81
62
81
57
68
47
53
38
40
27
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
87/ 100
Very good sunlight
Sunscore
This home receives average direct sun exposure in New Albany. There appears to be minimal shading by surrounding buildings, terrain, and vegetation.
8.8 hrs
5.3 hrs
JuneDecember
Provided by Shadowmap
Estimated sale price
$758,000 – $918,000
Reach more buyers when you sell with Redfin. Plus, you'll save $7,975 in fees.