x
Showing 1 of 0
X
Save

5597 Harlem Road
New Albany OH 43054 US

$799,000

Active Listing ID 226027583
bed icon
4 bed
bath icon
3.00 Bath (2 Full , 1 Half)
lot icon
Lot: 0.37 Acres
home icon
Single Family Residence

$799,000

Active Listing ID 226027583
Save

5597 Harlem Road 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.

Collapse all

Property Features

  • Facts
  • Lot Size: 0.37 Acres
  • Property Type: Residential
  • Property Sub-type: Single Family Residence
  • Features
  • Full Bathrooms: 2
  • 1/2 Bathrooms: 1
  • Cooling System: Central Air
  • Floor Covering: Carpet
  • Heating Fuels: Forced Air
  • Additional Features
  • Basement
  • Fireplace
  • Patio

Property

  • propertytype: Residential
  • propertysubtype: Single Family Residence
  • listprice: 799000
  • unparsedaddress: 5597 Harlem Road
  • postalcity: New Albany
  • stateorprovince: OH
  • country: US
  • postalcode: 43054
  • bathroomsfull: 2
  • bathroomshalf: 1
  • bathroomsonequarter: 0
  • bathroomsthreequarter: 0
  • lotsizeacres: 0.37
  • lotsizeunits: Acres
  • lotsizearea: 0.37
  • livingarea: 2903
  • livingareaunits: Square Feet
  • latitude: 40.084779
  • longitude: -82.83572
  • listagentfullname: Robert J Riddle
  • listagentemail: robr@thomasriddle.com
  • listagentkey: 3yd-CCOMLSOH-658020251
  • listagentmlsid: 658020251
  • listagentpreferredphone: 6145784199
  • listagentofficephone: 6145784199
  • listofficekey: 3yd-CCOMLSOH-05150
  • listofficemlsid: 05150
  • disclaimer: Copyright © 2026 Columbus and Central Ohio Multiple Listing Service. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.
  • sourcesystemid: CCOMLSOH
  • yearbuilt: 2000
  • listingcontractdate: 2026-07-22
  • listagenturl: http://www.newalbanyohio.com
  • countyorparish: Franklin
  • parcelnumber: 545-237753
  • elementaryschooldistrict: NEW ALBANY PLAIN LSD 2508 FRA CO.
  • middleorjuniorschooldistrict: NEW ALBANY PLAIN LSD 2508 FRA CO.
  • highschooldistrict: NEW ALBANY PLAIN LSD 2508 FRA CO.
  • appliances: Dishwasher, Gas Range, Humidifier, Microwave, Refrigerator
  • cooling: Central Air
  • flooring: Carpet
  • heating: Forced Air
  • fireplaceyn: True
  • transactiontype: ForSale
  • storiestotal: 2
  • parkingtotal: 0
  • parkingfeatures: Garage - Attached, Open
  • waterfrontyn: False
  • franchiseaffiliation: Independent
  • architecturalstyle: Other
  • rooms: Bedroom 4, Basement, Dining Room, Bedroom 1, Bedroom 3, Bathroom 2, Bathroom 3, Bedroom 2, Bathroom 1
  • securityfeatures: Security System
  • patioandporchfeatures: Patio
  • speciallistingconditions: Standard
  • basement: Partial, Crawl Space
  • dock: False
  • poolprivateyn: False
  • spayn: False
  • fencing: Fenced
  • internetaddressdisplayyn: True
  • internetautomatedvaluationdisplayyn: False
  • internetconsumercommentyn: False
  • location: -82.83572, 40.084778
  • customfields: {"AdditionalInformation":{}, "AlternatePrices":[], "BrokerName":"New Albany Reatly, LTD", "BuilderEmail":null, "BuilderFax":null, "BuilderPhone":null, "City":null, "Country":null, "CustomSourceId":null, "Expenses":[], "GeocodeOptions":null, "LeadRoutingEmail":"robr@thomasriddle.com", "ListBrokerageCity":"New Albany", "ListBrokerageCountry":"US", "ListBrokerageEmail":"info@newalbanyohio.com", "ListBrokerageLogoUrl":"http://brokerlogos.listhub.net/CCOMLSOH/8ddb3211228b11e68d6b0e0fbc721485/20160610211352168.png", "ListBrokerageName":"New Albany Reatly, LTD", "ListBrokeragePhone":"(614) 939-1234", "ListBrokeragePostalCode":"43054", "ListBrokerageStateOrProvince":"OH", "ListBrokerageUnitNumber":"Suite 200", "ListBrokerageUnparsedAddress":"220 Market Street", "ListBrokerageWebsiteUrl":"http://www.newalbanyohio.com", "ListOfficeAddress1":"220 Market Street, Suite D ", "ListOfficeAddress2":"Suite 200", "ListOfficeBrokerMlsId":"05150", "ListOfficeCity":"New Albany", "ListOfficeCountry":"US", "ListOfficeEmail":"cindys@newalbanyrealty.com", "ListOfficePostalCode":"43054", "ListOfficeStateOrProvince":"OH", "ListPriceCurrencyType":"USD", "ListingTitle":"SINGLE_FAMILY - Other - New Albany, OH", "ListingURL":"https://www.realtor.com/realestateandhomes-detail/5597-Harlem-Rd_New-Albany_OH_43054_M41919-25437?f=listhub&s=CCOMLSOH&m=226027583&c=rexren", "MLSModificationTimestamp":"2026-07-24 16:02:00", "Neighborhoods":[{"Description":null, "Name":"Hampsted Green"}], "PostalCode":null, "RoomCount":null, "StateOrProvince":null, "Taxes":[{"TaxAnnualAmount":11066, "TaxDescription":null, "TaxYear":"2025"}], "UnitNumber":null, "UnparsedAddress":null}
Listing Changed: 7/24/2026 4:13:00 PM GMT
Source Updated Date: 7/26/2026 12:50:39 AM GMT

Courtesy of: Robert J Riddle, New Albany Realty, LTD, robr@thomasriddle.com

Copyright © 2026 Columbus and Central Ohio Multiple Listing Service. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.