MLS Listings

Your search results

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

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 fle ...

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.

Compare Listings