OFF MARKET

Off market aug 2016 for $275K

$1,038,905

Est. refi paymentEst. refi $1,748/mo

•

1,862

sq ft

5187 Harlem Rd, New Albany, OH 43054

About this home

Opportunity in a Terrific Location Next to the New Albany Country Club Community but without fees! Harlem Rd between Dublin Granville & Greensward is in transition with New 2-Story Homes popping up everywhere! This 1969 home needs updating and TLC but it’s an inspiration for someone with HGTV decorating or handyman skills. In the alternative, start over and build your own new home! New Albany Schools. 5 BR, 3BA. with a screened back porch, 2-car attached and 3 car detached workshop

Single-familyProperty Type

1969Year Built

0.67 acresLot Size

$558Est. Price/Sq.Ft.

2 car garageParking

Listed by Jane Kessler-Lennox • New Albany Realty, LTD

•614-562-1212 (agent)

•janel@newalbanyrealty.com (agent)

•614-939-8900 (broker)

•cindys@newalbanyrealty.com (broker)

Bought with Alan Hinson • New Albany Realty, LTD

•614-939-8900 (agent)

•alanh@newalbanyrealty.com (agent)

•614-939-8900 (broker)

•cindys@newalbanyrealty.com (broker)

Redfin checked: 2 minutes ago

•Source:CBRMLS #216021447

Redfin Estimate

$1,038,905

$764K since sold in August 2016$8,000 since October

Recently sold homes
Estimate history
Homes for sale

This home's estimate is 17.4% higher than the average sale price ($885K) of 6 comparable homes.

SOLD JUN 25, 2026
4871 Sloane Pl, New Albany, OH 43054
$780,000
A
4 beds2.5 baths2,470 sq ft
4871 Sloane Pl, New Albany, OH 43054
SOLD SEP 16, 2026
$725,000
B
4 beds2.5 baths3,044 sq ft
4937 Meadway Dr, New Albany, OH 43054
SOLD JUN 30, 2026
$720,000
C
4 beds2.5 baths2,717 sq ft
4888 Sloane Pl, New Albany, OH 43054
SOLD AUG 24, 2026
$865,000
D
4 beds2.5 baths2,903 sq ft
5597 Harlem Rd, New Albany, OH 43054
SOLD SEP 30, 2026
$625,000
E
4 beds2.5 baths3,187 sq ft
5069 Heath Gate Dr, New Albany, OH 43054
SOLD SEP 17, 2026
$1,595,000
F
4 beds3.5 baths4,559 sq ft
6920 Clivdon Mews, New Albany, OH 43054

Claim this home to receive a free report every month with insights on the changing estimate.

Earn from this home

Sell

$805,187

Est. take-home

List your home with Redfin and save $10,389

Refinance

Est. cash available

Get cash now or lower your monthly rate

Rent

$3,921/mo

Redfin rental estimate

List your home for rent

Market trends in 43054, OH

Last updated October 2026

Buyer's Market

Seller's Market

Seller's market

Sale-to-list price

99.1%

0.2% MoM

Median sale price

$625K

$35K MoM

Avg. days on market

38d

2 days MoM

Recently sold homes

125

26 MoM

New listings for sale

$279,500
2 beds1.5 baths1,011 sq ft
6817 Rolfe Ave, New Albany, OH 43054
Isaiah X. Thompson • Collective House Realty, (614) 470-5560
$1,149,000
5 beds3.5 baths5,007 sq ft
4114 James River Rd, New Albany, OH 43054
Jean Lesnick • New Albany Realty, LTD, (614) 939-8900
$589,900
3 beds3 baths2,459 sq ft
6906 Rothwell St #22, New Albany, OH 43054
Anita Smith • EPCON Realty, Inc., (614) 761-1010
OPEN TODAY, 1PM TO 3PM
$839,900
4 beds3.5 baths4,970 sq ft
6900 Kindler Dr, New Albany, OH 43054
Linda Veltri • Coldwell Banker Realty, (614) 759-0808
OPEN TODAY, 12PM TO 2PM
$320,000
3 beds2.5 baths2,212 sq ft
7046 Hill Gail Dr #28, New Albany, OH 43054
Paige Ludwig • CRT, Realtors, (614) 528-1144
OPEN TODAY, 11AM TO 1PM
$650,000
4 beds3 baths2,800 sq ft
6290 Harlem Rd, New Albany, OH 43054
Rob Riddle • New Albany Realty, LTD, (614) 939-8900
3D WALKTHROUGH
$419,900
3 beds2.5 baths1,682 sq ft
6205 Home Park Dr, New Albany, OH 43054
Michelle Brooks • Red 1 Realty, (614) 585-9020
OPEN TODAY, 1PM TO 3PM
$699,900
4 beds3.5 baths4,495 sq ft
6372 Skipping Stone Dr, New Albany, OH 43054
Sandy Raines • The Raines Group, Inc., (614) 924-9000
$389,900
2 beds2 baths1,520 sq ft
4157 Windsor Bridge Pl Unit 2-4157, New Albany, OH 43054
Brenda Carsey • RE/MAX Revealty, (614) 505-7438
$225,000
2 beds1.5 baths1,014 sq ft
7004 Gallant Fox Dr #11, New Albany, OH 43054
Ashley Henry • Keller Williams Consultants, (614) 932-2000
See all

Provided by Redfin

Sale history for 5187 Harlem Rd

Year

Property tax

Land + Additions

Assessment*

2025

$26,710

$99,680 + $328,475

$428,155

2024

$26,703 (+8.4%)

$99,680 + $328,475

$428,155

2023

$24,643 (−11.4%)

$99,680 + $328,475

$428,155

2022

$27,801 (+3.3%)

$139,545 + $232,050

$371,595

2021

$26,922 (+29.9%)

$142,275 + $141,470

$283,745

2020

$20,722 (+76.2%)

$142,275 + $141,470

$283,745

2019

$11,762 (+62.7%)

$135,485 + $11,515

$147,000

2017

$7,231 (+10.3%)

$43,400 + $46,900

$90,300

2016

$6,558

$37,765 + $48,510

$86,275

2015

$6,552 (+1.8%)

$37,765 + $48,510

$86,275

2014

$6,434 (+2.9%)

$37,765 + $48,510

$86,275

2013

$6,255

$35,980 + $46,200

$82,180

Tax history for 5187 Harlem Rd

Year

Property tax

Land + Additions

Assessment*

2025

$26,710

$99,680 + $328,475

$428,155

2024

$26,703 (+8.4%)

$99,680 + $328,475

$428,155

2023

$24,643 (−11.4%)

$99,680 + $328,475

$428,155

2022

$27,801 (+3.3%)

$139,545 + $232,050

$371,595

2021

$26,922 (+29.9%)

$142,275 + $141,470

$283,745

2020

$20,722 (+76.2%)

$142,275 + $141,470

$283,745

2019

$11,762 (+62.7%)

$135,485 + $11,515

$147,000

2017

$7,231 (+10.3%)

$43,400 + $46,900

$90,300

2016

$6,558

$37,765 + $48,510

$86,275

2015

$6,552 (+1.8%)

$37,765 + $48,510

$86,275

2014

$6,434 (+2.9%)

$37,765 + $48,510

$86,275

2013

$6,255

$35,980 + $46,200

$82,180

*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.

Public record

Public record
Zoning

Beds

Baths

3.5

Stories

Lot width

—

Lot depth

—

Lot size

3.64 Acres

Year renovated

—

Sq. Ft.

5,269

Year built

2019

Style

Single Family Residential

County

Franklin County

APN

222-000682-00

Parking Spaces

—

Basement

—

Accessible

—

HOA Dues

—

Garage

—

Features

—

Last updated by owner on Sep 23, 2026.

R-2

Low-Density Single-Family Residential District

The districts are established to accommodate a variety of single-family residential housing environments, at densities consistent with that which exist in the respective area. The objective is to discourage large concentrations of intensive development in specific areas where such intensity would be inconsistent with the existing character of the area.

Property details

Parking

Parking and Garage Information
Has Garage
Has Attached Garage
# of Garage Spaces: 2
Parking Features: Garage Door Opener, Attached Garage, Detached Garage

Interior

Bathroom Information
# of Full Bathrooms: 3
Bathrooms Total Integer: 3
Bathrooms Total Decimal: 3

Bedroom Information
# of Main Level Bedrooms: 5

Heating & Cooling
Has Cooling
Cooling: Central Air
Has Heating
Heating: Oil

Interior Features
Living Area: 1862.0
Flooring: Carpet, Vinyl
Window Features: Insulated All
Interior Features: Dishwasher, Electric Range, Microwave, Refrigerator
Has Fireplace(s)
Basement: Full
Has Basement

Exterior

Exterior Features
Exterior Features: Waste Tr/Sys
Patio And Porch Features: Screened Porch
Foundation Details: Block

Property Information
Property Sub-Type: Single Family Residence
Year Built: 1969
Building Area Total: 1862.0

Lot Information
Lot Features: Wooded
Lot Size Area: 0.67
Lot Size Square Feet: 29185.2
Lot Size Acres: 0.67

Financial

Tax Information
Tax Annual Amount: $6,552
Tax Year: 2015

Utilities

Utilities Information
Water Source: Well

Location

School Information
High School District: NEW ALBANY PLAIN LSD 2508 FRA CO.

Location Information
Township: Plain

Public facts

Beds: 4
Baths: 3.5
Sq. Ft.: 5,269
Stories: 1.0
Lot Size: 3.64 acres
Style: Single Family Residential
Year Built: 2019
Year Renovated: —
County: Franklin County
APN: 222-000682-00

Home facts updated by county records on Sep 23, 2026

Around this home

Schools

New Albany Early Learning Center

Public PreK-K • Assigned • 1.1mi

New Albany Middle School

Public 7-8 • Assigned • 1.1mi

8/10

New Albany High School

Public 9-12 • Assigned • 1.0mi

9/10

Provided by GreatSchools

Lifestyle

Provided by Walk Score and Local Logic

Climate risks

1/10 Flood Factor

Minimal risk of a flood reaching the building in the next 30 years

1/10 Fire Factor

Unlikely to be in a wildfire in next 30 years

3/10 Heat Factor

6 days above 98° expected this year, 15 days in 30 years

2/10 Wind Factor

0% chance of strong winds in next 30 years

3/10 Air Factor

3 unhealthy days expected this year, 5 days in 30 years

Provided by First Street

Historical weather

New Albany, OH • 43054

Average low and high temperatures (°F)

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

Sun exposure

In this area, properties receive around 8.5 hours in June and 2.6 hours in December, placing it below the U.S. average for solar exposure.

8.5 hrs

2.6 hrs

JuneDecember

Provided by Shadowmap

Estimated sale price

$987,000 – $1.20M

Reach more buyers when you sell with Redfin. Save up to $10,389 in fees. 3 minutes to get started.

Need the cash from your home fast? Sell to .

Nearby similar homes

$359,500

3 beds3 baths1,719 sq ft

5310 Knotting Woods Dr, Westerville, OH 43081

Move in ready • 3 season room • Thoughtfully updated

Subodh Singh • Howard Hanna Real Estate Svcs, (614) 888-7400

$775,000

5 beds3.5 baths3,301 sq ft

6816 Bishops Wood Dr, New Albany, OH 43054

Two story foyer • Private office • Dining room

M Scott Siebenaler • REP One Realty LLC, (614) 475-7200

NEW CONSTRUCTION

$999,000

4 beds3 baths3,130 sq ft

1356 Woodland Run Way, New Albany, OH 43054

8,276 sq ft lot • 3 garage spots • Built 2026

Robb Harpster • Century 21 Excellence Realty, (800) 783-2100

$2,695,000

5 beds5.5 baths5,812 sq ft

15 Edge Of Woods Rd, New Albany, OH 43054

Gourmet kitchen • Gathering room • Formal dining room

Jane Kessler-Lennox • New Albany Realty, LTD, (614) 939-8900

$799,000

4 beds3.5 baths4,400 sq ft

1237 Whispering Meadow Ct, New Albany, OH 43054

Wooded setting • Great room • Granite counters

Jeremy Pape • CRT, Realtors, (614) 528-1144

$725,000

3 beds2.5 baths3,387 sq ft

4116 Audley Rd, New Albany, OH 43054

Great room • Vaulted ceiling • Custom built-ins

Jill Beckett-Hill • Beckett Realty Group, (614) 457-4000

New listings for sale in 43054

$279,500

2 beds1.5 baths1,011 sq ft

6817 Rolfe Ave, New Albany, OH 43054

Full front porch • Quartz countertops • Large island

Isaiah X. Thompson • Collective House Realty, (614) 470-5560

$1,149,000

5 beds3.5 baths5,007 sq ft

4114 James River Rd, New Albany, OH 43054

Wooded corner lot • All-new windows • Hardy plank siding

Jean Lesnick • New Albany Realty, LTD, (614) 939-8900

$589,900

3 beds3 baths2,459 sq ft

6906 Rothwell St #22, New Albany, OH 43054

Private den • Bonus suite • Covered porch

Anita Smith • EPCON Realty, Inc., (614) 761-1010

OPEN TODAY, 1PM TO 3PM

$839,900

4 beds3.5 baths4,970 sq ft

6900 Kindler Dr, New Albany, OH 43054

Custom-built • Full-brick front • Two-story great room

Linda Veltri • Coldwell Banker Realty, (614) 759-0808

OPEN TODAY, 12PM TO 2PM

$320,000

3 beds2.5 baths2,212 sq ft

7046 Hill Gail Dr #28, New Albany, OH 43054

Quartz countertops • Updated backsplash • Cozy gas fireplace

Paige Ludwig • CRT, Realtors, (614) 528-1144

OPEN TODAY, 11AM TO 1PM

$650,000

4 beds3 baths2,800 sq ft

6290 Harlem Rd, New Albany, OH 43054

Wooded acres • Private setting • Finished lower level

Rob Riddle • New Albany Realty, LTD, (614) 939-8900

3D WALKTHROUGH

$419,900

3 beds2.5 baths1,682 sq ft

6205 Home Park Dr, New Albany, OH 43054

Covered front porch • Premium lot • Mature trees

Michelle Brooks • Red 1 Realty, (614) 585-9020

OPEN TODAY, 1PM TO 3PM

$699,900

4 beds3.5 baths4,495 sq ft

6372 Skipping Stone Dr, New Albany, OH 43054

Private fenced lot • Vaulted ceilings • Finished lower level

Sandy Raines • The Raines Group, Inc., (614) 924-9000

$389,900

2 beds2 baths1,520 sq ft

4157 Windsor Bridge Pl Unit 2-4157, New Albany, OH 43054

Gourmet kitchen • Granite countertops • Breakfast bar

Brenda Carsey • RE/MAX Revealty, (614) 505-7438

Home values near 5187 Harlem Rd

Data from public records.

Address	Redfin Estimate
5321 Harlem Rd, New Albany, OH 3 Beds \| 2.5 Baths \| 2415 Sq. Ft.	$2,935,277
5171 Harlem Rd, New Albany, OH 3 Beds \| 2.5 Baths \| 2310 Sq. Ft.	$925,288

Address	Redfin Estimate
5170 Harlem Rd, New Albany, OH 4 Beds \| 1.5 Baths \| 2710 Sq. Ft.	$1,596,816
5166 Harlem Rd, New Albany, OH 2 Beds \| 1.5 Baths \| 1068 Sq. Ft.	$591,599

Address	Redfin Estimate
5270 Harlem Rd, New Albany, OH 3 Beds \| 1.5 Baths \| 1512 Sq. Ft.	$504,581
5199 Harlem Rd, New Albany, OH 3 Beds \| 3.5 Baths \| 3257 Sq. Ft.	$600,333

Property information provided by CBRMLS when last listed in 2016. This data may not match . Learn more.

Download the Redfin App on the Apple App Store

Download the Redfin App from the Google Play Store

Join us

Become an Agent

Get referrals

Careers

Find homes faster

About us

Find us

Subsidiaries

Affiliated Business

Countries

United States

Canada

Updated September 2025: By searching, you agree to the Terms of Use, and Privacy Policy.

Do not sell or share my personal information.

REDFIN and all REDFIN variants, WALK SCORE, and the R logos, are trademarks of Redfin Corporation, registered or pending in the USPTO.

California DRE #01521930

Redfin is licensed to do business in New York as Redfin Real Estate. NY Standard Operating Procedures

New Mexico Real Estate Licenses

TREC: Info About Brokerage Services, Consumer Protection Notice

All mortgage lending products and information are provided by Rocket Mortgage, LLC | NMLS #3030; www.NMLSConsumerAccess.org. Licensed in 50 states. This site is not authorized by the New York State Department of Financial Services for mortgage solicitation or loan applications activities related to properties located in the State of New York.

Redfin Corporation is an affiliated business of Rocket Limited Partnership. Each company, and their subsidiaries, are separate legal entities operated and managed through its own management and governance structures.

If you are using a screen reader, or having trouble reading this website, please call Redfin Customer Support for help at 1-844-759-7732.

REDFIN IS COMMITTED TO AND ABIDES BY THE FAIR HOUSING ACT AND EQUAL OPPORTUNITY ACT. READ REDFIN'S FAIR HOUSING POLICY AND THE NEW YORK STATE FAIR HOUSING NOTICE.

GreatSchools Ratings provided by GreatSchools.org.

43081 homes for sale
43062 homes for sale
43004 homes for sale
43230 homes for sale
43054 homes for sale

Houses for rent in New Albany	Agents near me	Dayton, OH homes for sale	New Albany Housing Market
Houses for sale near me	Columbus, OH homes for sale	Westerville, OH homes for sale
Land for sale near me	Cincinnati, OH homes for sale	Toledo, OH homes for sale
Open Houses near me	Cleveland, OH homes for sale	New Albany Property Records
Condos for sale near me	Dublin, OH homes for sale	OH New Listings

Dublin homes for sale
Columbus homes for sale
Westerville homes for sale

About this home

Redfin Estimate

Earn from this home

Market trends in 43054, OH

Sale history for 5187 Harlem Rd

Tax history for 5187 Harlem Rd

Public record

Property details

Around this home

Schools

Lifestyle

Climate risks

Historical weather

Sun exposure

Nearby similar homes

New listings for sale in 43054

Home values near 5187 Harlem Rd

More real estate resources