With a portal, you are able to save your searches and receive alerts
5597 Harlem Road, New Albany, OH 43054
$865,000
Property Type:
Residential
Bedrooms:
4
Baths:
3
Square Footage:
2,903
Lot Size (sq. ft.):
16,117
Status:
Closed
Current Price:
$865,000
List Date:
7/24/2026
Last Modified:
8/24/2026
Overview
Description
...
(Read more)
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.
Listing Details MLS# 226027583
Location Property Info
- Property Sub Type
- Single Family Residence
- Original List Price
- 799000
- Street #
- 5597
- Street Name
- Harlem
- Street Suffix
- Road
- County
- Franklin
- State
- OH
- Zip Code
- 43054
- School District
- NEW ALBANY PLAIN LSD 2508 FRA CO.
- Township
- None
- Subdiv/Cmplx/Comm
- Hampsted Green
OfficeContract Info
- MLS Entry Date
- 2026-07-22
General Property Info
- Total Baths
- 3
- Baths F.H
- 2.1
- Full Baths
- 2
- Half Baths
- Yes
- Built Prior to 1978
- No
- Garage/EnclosdSpaces
- 2
- Year Built
- 2000
- SqFt Documented
- 2903
- Documented SqFt Source
- Realist
- SqFt ATFLS
- 2903
- ATFLS Source
- Realist
- Acreage
- 0.37
- Manufactured Housing Y/N
- No
- HOA/COA Y/N
- Yes
- Assoc/Condo Fee
- 594.32
- Association Fee Frequency
- Annually
Tax Info
- Parcel #
- 545-237753
- Tax Year
- 2025
- Tax Abatement
- No
- Taxes (Yrly)
- 11066
Status Change Info
- Under Contract Date
- 2026-07-25
- Sold Date
- 2026-08-24
- Sold Price/SqFt
- 297.97
Bedroom Level
- Beds UP1
- 4
More Information
Full Baths Level
- Full Baths UP1
- 2
Half Baths Level
- Half B Entry Level
- Yes
Living Room Level
- Living R Entry Level
- Yes
Dining Room Level
- Dining Entry Level
- Yes
Eating Space Level
- Eating S Entry Level
- Yes
Family Room Level
- Family R Entry Level
- Yes
Rec Room Level
- Rec Room Down1
- Yes
Utility Space Level
- Utility Down1
- Yes
Basement
- Basement Y/N
- Yes
Accessory Dwelling Unit
- Existing Accessory Dwelling Unit
- No
Accessible Features
- Accessible Features
- No
Auction Info
- Auction/Online Bidding Y/N
- No
Sale Info
- Seller Assisted Fin
- N
- Seller/Buyer Concessions
- N
Green Features
- Green Features Y/N
- No
Location & Property Info
- List Price/SqFt
- 275.23
- Mid/High Rise
- No
- City (Mailing Addr)
- New Albany
- Corp LimitPerAuditor
- Columbus
- New Construction
- No
Office/Contract Info
- Active on MLS
- 2026-07-24
Remarks & Misc
- Property Description
- 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.
Addl Acceptance Cond
- None Known
- Yes
Levels
- Two
- Yes
Architectural Style
- Traditional
- Yes
Common Walls
- No Common Walls
- Yes
Parking Features
- Attached Garage
- Yes
- Garage Door Opener
- Yes
- Side Load
- Yes
Water Source
- Public
- Yes
Sewer
- Public Sewer
- Yes
Basement Description
- Crawl Space
- Yes
- Partial
- Yes
Foundation
- Block
- Yes
Rooms
- LL Laundry
- Yes
- Den/Home Office - Non Bsmt
- Yes
- Dining Room
- Yes
- Eat Space/Kit
- Yes
- Family Rm/Non Bsmt
- Yes
- Great Room
- Yes
- Living Room
- Yes
- Rec Rm/Bsmt
- Yes
Fireplace
- One
- Yes
- Gas Log
- Yes
Heating
- Forced Air
- Yes
- Gas
- Yes
New Financing
- Conventional
- Yes
- FHA
- Yes
- VA
- Yes
Air Conditioning
- Central Air
- Yes
Windows
- Insulated All
- Yes
Interior Flooring
- Carpet
- Yes
HOA/COA Fee Includes
- Common Area Only
- Yes
Interior Amenities
- Dishwasher
- Yes
- Gas Range
- Yes
- Humidifier
- Yes
- Microwave
- Yes
- Refrigerator
- Yes
- Security System
- Yes
Cmplex/Sub Amenities
- Bike/Walk Path
- Yes
- Park
- Yes
- Sidewalk
- Yes
Patio and Porch Features
- Patio
- Yes
Fencing
- Fenced
- Yes
Exterior
- Brick
- Yes
- Vinyl Siding
- Yes
MLS Primary PhotoSrc
- Realtor Provided
- Yes
Printing Services
- No Printing Services
- Yes
Leased Items Y/N
- Leased Items
- No
Property Features
Levels:
Two
Architectural Style:
Traditional
Common Walls:
No Common Walls
Addl Acceptance Cond:
None Known
Parking Features:
Attached Garage; Garage Door Opener; Side Load
Basement Description:
Crawl Space; Partial
Foundation:
Block
Exterior:
Brick; Vinyl Siding
Rooms:
LL Laundry; Den/Home Office - Non Bsmt; Dining Room; Eat Space/Kit; Family Rm/Non Bsmt; Great Room; Living Room; Rec Rm/Bsmt
Fireplace:
One; Gas Log
Heating:
Forced Air; Gas
Air Conditioning:
Central Air
Windows:
Insulated All
Interior Flooring:
Carpet
Sewer:
Public Sewer
Water Source:
Public
Interior Amenities:
Dishwasher; Gas Range; Humidifier; Microwave; Refrigerator; Security System
Patio and Porch Features:
Patio
Fencing:
Fenced
New Financing:
Conventional; FHA; VA
MLS Primary PhotoSrc:
Realtor Provided
Printing Services:
No Printing Services
Documents
Listing Office:
New Albany Realty, LTD
Listing Agent:
Robert J Riddle
Last Updated: August - 24 - 2026
The data relating to real estate for sale on this site comes from the Broker Reciprocity/IDX of Columbus Board of Realtors Multiple Listing Service.Information provided is thought to be reliable but is not guaranteed to be accurate; you are advised to verify facts that are important to you. No warranties, expressed or implied, are provided for the data herein, or for their use or interpretation by the user. Columbus Board of Realtors Multiple Listing Service does not create, control or review the property data displayed herein and take no responsibility for the content of such records. Federal law prohibits discrimination on the basis of race, color, religion, sex, handicap, familial status or national origin in the sale, rental or financing of housing. Copyright 2026 Columbus Board of Realtors. All rights reserved.
UPDATE LIST ›