Skip main navigation
Sold for $865,000
  • $865,000

    5597 Harlem Rd, New Albany, OH 43054

    4beds
    2,903sqft
    Single Family Residence
    Built in 2000
    0.37 Acres Lot
    $864,900 Zestimate®
    $298/sqft
    $3,594 Estimated rent

    Home value

    $864,900

    $822,000 - $908,000

    $3,594/mo

    Zestimate® history
    Loading
    Loading...

    Owner options

    List your home for rent

    $3,594/mo

    Rent Zestimate®

    Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.

    Learn more

    $3,594/mo

    Rent Zestimate®

    Refinance and save

    $6,373/mo

    Est. payment

    Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.

    See today's rates

    $6,373/mo

    Est. payment

    Explore your selling options

    Work with a Zillow partner agent

    Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.

    Get started

    List with your own agent

    Get your home in front of millions of buyers by listing it on Zillow.

    Learn how to do it

    Sell it yourself

    Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).

    List your home

    What's special

    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.

    Zillow last checked:

    Listing updated:

    Listed by:

    Robert J Riddle 614-578-4199,

    New Albany Realty, LTD,

    Kandis Hall 740-404-9547,

    New Albany Realty, LTD

    Bought with:

    Daniel B Bobry, 2020005529

    Triumph Realty

    Source: Columbus and Central Ohio Regional MLS ,MLS#: 226027583MLS Logo

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 4
    • Bathrooms: 3
    • Full bathrooms: 2
    • 1/2 bathrooms: 1
    Heating
    • Forced Air
    Cooling
    • Central Air
    Appliances
    • Included: Dishwasher, Gas Range, Humidifier, Microwave, Refrigerator
    Features
    • Flooring: Carpet
    • Windows: Insulated Windows
    • Basement: Crawl Space,Partial
    • Number of fireplaces: 1
    • Fireplace features: One, Gas Log
    • Common walls with other units/homes: No Common Walls
    Interior area
    • Total structure area: 2,903
    • Total interior livable area: 2,903 sqft

    Property

    Parking
    • Total spaces: 2
    • Parking features: Garage Door Opener, Attached, Side Load
    • Garage spaces: 2
    Features
    • Levels: Two
    • Patio & porch: Patio
    • Fencing: Fenced
    Lot
    • Size: 0.37 Acres
    Details
    • Parcel number: 545237753
    • Special conditions: Standard

    Construction

    Type & style
    • Home type: SingleFamily
    • Architectural style: Traditional
    • Property subtype: Single Family Residence
    Materials
    • Foundation: Block
    Condition
    • New construction: No
    • Year built: 2000

    Utilities & green energy

    • Sewer: Public Sewer
    • Water: Public

    Community & HOA

    Community
    • Security: Security System
    • Subdivision: Hampsted Green
    HOA
    • Has HOA: Yes
    • Amenities included: Bike/Walk Path, Park, Sidewalk
    • HOA fee: $594 annually
    Location
    • Region: New Albany

    Financial & listing details

    • Price per square foot: $298/sqft
    • Tax assessed value: $581,200
    • Annual tax amount: $11,066
    • Date on market: 7/24/2026
    • Listing terms: VA Loan,FHA,Conventional

    Price history

    DateEventPrice
    8/24/2026Sold$865,000+8.3%$298/sqft
    Source: Columbus and Central Ohio Regional MLS #226027583 Report a problem
    7/26/2026Contingent$799,000$275/sqft
    Source: Columbus and Central Ohio Regional MLS #226027583 Report a problem
    7/24/2026Listed for sale$799,000+133.3%$275/sqft
    Source: Columbus and Central Ohio Regional MLS #226027583 Report a problem
    3/15/2017Sold$342,500-3.5%$118/sqft
    Source: Columbus and Central Ohio Regional MLS #216042177 Report a problem
    12/12/2016Price change$354,900-4.1%$122/sqft
    Source: New Albany Realty, LTD #216042177 Report a problem
    12/3/2016Listed for sale$369,900+24.1%$127/sqft
    Source: New Albany Realty, LTD #216042177 Report a problem
    11/7/2008Sold$298,000-3.7%$103/sqft
    Source: Public Record Report a problem
    9/18/2008Price change$309,416-2.9%$107/sqft
    Source: Real Living #2835875 Report a problem
    8/22/2008Listed for sale$318,500+3.4%$110/sqft
    Source: Real Living #2835875 Report a problem
    4/7/2004Sold$308,000+10.8%$106/sqft
    Source: Public Record Report a problem
    4/3/2001Sold$278,100$96/sqft
    Source: Public Record Report a problem

    Public tax history

    YearProperty taxesTax assessment
    2025-- $203,430
    2024$11,063 +3.5%$203,430
    2023$10,688 +8.2%$203,430 +39.7%
    2022$9,879 +4.5%$145,670
    2021$9,455 +0.7%$145,670
    2020$9,389 +11.3%$145,670 +21.9%
    2019$8,434 -3.3%$119,460
    2018$8,719 $119,460
    2017$8,719 +9.2%$119,460 +14.7%
    2016$7,985 -4.9%$104,170
    2015$8,394 $104,170
    2014$8,394 +102.8%$104,170 +5%
    2013$4,140 -46.3%$99,225
    2011$7,711 -7.8%$99,225 -12.3%
    2010$8,363 +8.8%$113,190
    2008$7,684 +1.1%$113,190
    2007$7,602 -0.1%--
    2006$7,609 +13.8%--
    2005$6,688 +8.6%--
    2004$6,159 +0.9%--
    2003$6,106 +16.9%--
    2002$5,224 +9.5%--
    2001$4,769 +363.2%--
    2000$1,030 --
    Find assessor info on the county website

    Neighborhood: Fodor

    Nearby schools

    GreatSchools rating
    Get a cash offer in 3 minutes
    Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
    Estimated market value
    $864,900
    Get a cash offer in 3 minutes
    Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
    Estimated market value
    $864,900