Skip main navigation
For sale
  • $3,200,000

    5114 Harlem Rd, New Albany, OH 43054

    6beds
    6,730sqft
    : 
    $23,536/mo
    Get pre-qualified
    Single Family Residence
    Built in 2006
    1 Acres Lot
    $-- Zestimate®
    $475/sqft
    $-- HOA

    What's special

    There are homes that are beautiful and then there are homes that feel like an embrace the moment you step inside. This extraordinary New Albany renovated residence offers 6,730 square feet across three finished levels, six bedrooms, and five and a half baths - every detail curated with an unwavering eye for warmth, elegance, and light. Upon entering, a sweeping curved staircase sets the tone. Ten-foot ceilings, custom millwork, and multi-plank oak hardwood floors flow throughout grounding every space with richness and character. The oversized dining room and butler's pantry speak to a home built for gracious entertaining. The inspired kitchen features a large island, handcrafted cabinetry, quartz countertops, walk-in pantry, and designer lighting opening to sweeping views of the pool and backyard, a daily reminder of just how special this setting is. Three distinct gathering rooms invite easy living, anchored by a see-through gas fireplace connecting the kitchen and hearth room. The primary suite is a true retreat completely reimagined in 2026 with a spa bath of exceptional finish and a custom closet of the same intention. The second level features a private staircase, four additional expansive bedrooms, three full baths, and an oversized laundry room. An elevator serves all three levels. Set on a private, tree-lined ravine acre, the outdoor living is equally compelling. A heated 40-foot salt-and-chlorine pool, expansive stone patio, two pergolas, and a screened porch with 12-foot ceilings create a backyard sanctuary for every season. A four-car heated garage, Generac generator, new asphalt shingle roof, and finished lower level with media and game room, private office, potential sixth bedroom, full bath, gym, and sauna complete this exceptional offering. Ideally located in the heart of New Albany with easy access to downtown, schools, the performing arts, and local amenities. This property is not subject to NACC deed restrictions or HOA dues.
    18 days
    |
    2,778
    |
    96
    |

    Zillow last checked:

    Listing updated:

    Listed by:

    Jill Beckett-Hill 614-563-9819,

    Beckett Realty Group

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

      Facts & features

      Interior

      Bedrooms & bathrooms
      • Bedrooms: 6
      • Bathrooms: 6
      • Full bathrooms: 5
      • 1/2 bathrooms: 1
      Heating
      • Forced Air
      Cooling
      • Central Air
      Appliances
      • Included: Instant Hot Water, Dishwasher, Gas Range, Gas Water Heater, Humidifier, Microwave, Refrigerator, Water Purifier
      • Laundry: Electric Dryer Hookup
      Features
      • Elevator
      • Flooring: Wood, Carpet, Ceramic/Porcelain
      • Windows: Insulated Windows
      • Basement: Egress Window(s),Full
      • Number of fireplaces: 2
      • Fireplace features: Two, Gas Log
      • Common walls with other units/homes: No Common Walls
      Interior area
      • Total structure area: 6,730
      • Total interior livable area: 6,730 sqft
      Video & virtual tour

      Property

      Parking
      • Total spaces: 4
      • Parking features: Garage Door Opener, Heated Garage, Attached, Side Load
      • Garage spaces: 4
      Features
      • Levels: Two
      • Patio & porch: Porch, Patio
      • Has private pool: Yes
      • Fencing: Invisible
      Lot
      • Size: 1 Acres
      • Features: Ravine Lot, Wooded
      Details
      • Parcel number: 222000833
      • Special conditions: Standard
      • Other equipment: Irrigation Equipment

      Construction

      Type & style
      • Home type: SingleFamily
      • Architectural style: Farmhouse
      • Property subtype: Single Family Residence
      Condition
      • New construction: No
      • Year built: 2006

      Utilities & green energy

      • Sewer: Public Sewer
      • Water: Public

      Community & HOA

      Community
      • Security: Security System
      HOA
      • Has HOA: No
      Location
      • Region: New Albany

      Financial & listing details

      • Price per square foot: $475/sqft
      • Tax assessed value: $1,579,800
      • Annual tax amount: $34,409
      • Date on market: 7/23/2026
      • Listing terms: Conventional

        Estimated market value

        Not available

        Estimated sales range

        Not available

        Not available

        Price history

        DateEventPrice
        7/23/2026Listed for sale$3,200,000+93.9%$475/sqft
        Source: Columbus and Central Ohio Regional MLS #226027331 Report a problem
        10/27/2021Sold$1,650,000+3.1%$245/sqft
        Source: Columbus and Central Ohio Regional MLS #221039234 Report a problem
        10/17/2021Pending sale$1,599,900$238/sqft
        Source: Columbus and Central Ohio Regional MLS #221039234 Report a problem
        10/10/2021Contingent$1,599,900$238/sqft
        Source: Columbus and Central Ohio Regional MLS #221039234 Report a problem
        10/4/2021Listed for sale$1,599,900+611.1%$238/sqft
        Source: NextHome #221039234 Report a problem
        4/16/2004Sold$225,000$33/sqft
        Source: Public Record Report a problem

        Public tax history

        YearProperty taxesTax assessment
        2024$34,400 +10.3%$552,940 +1.7%
        2023$31,194 +28.7%$543,450 +67%
        2022$24,236 +17.5%$325,370 +12.9%
        2021$20,631 +0.6%$288,230
        2020$20,510 -4.2%$288,230 +5%
        2019$21,401 +1.3%$274,540
        2018$21,135 $274,540
        2017$21,135 -8.3%$274,540 -2.5%
        2016$23,058 +0.1%$281,580
        2015$23,036 $281,580
        2014$23,036 +108.7%$281,580 +5%
        2013$11,039 -45.7%$268,170
        2011$20,345 -10.9%$268,170 -12%
        2010$22,829 +8.8%$304,850
        2008$20,979 +67.5%$304,850
        2007$12,523 +111.6%--
        2006$5,918 +63.3%--
        2005$3,623 -5.2%--
        2004$3,822 +2%--
        2003$3,746 +15.1%--
        2002$3,255 +4.5%--
        2001$3,115 -0.8%--
        2000$3,141 --
        Find assessor info on the county website

        Monthly payment

        Est. payment

        Payment breakdown

        Explore the cost of this home by adjusting the details. Changes won't be saved.
        All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
        HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
        Mortgage interest rates are dependent on a number of factors, including credit score, down payment, and repayment length. Interest rate data provided by Zillow Group Marketplace, Inc. as of 1/1/1970 from various mortgage lenders with which we have lead or other similar arrangements; the Estimated Payment is an average of those rates.
        See how much you could borrow to make a competitive offer.

        Climate risks

        Neighborhood: 43054

        Getting around

        5 / 100
        Car-Dependent
        27 / 100
        Somewhat Bikeable

        Nearby schools

        GreatSchools rating

        A local agent can set up tours, give advice and negotiate with sellers.

        A local lender can help you make sure your offer is ready when you are.

        Browse local experts

        Similar homes