OFF MARKET
Google street view image for 5240 Green Cook Rd, New Albany, OH 43054
Off market
$1,005,172
4
bd
•
3.5 ba
•
4,078
sq ft

5240 Green Cook Rd, New Albany, OH 43054

map-entry

About this home

5240 Green Cook Rd is a 4,078 square foot house on a 6.34 acre lot with 4 bedrooms and 3.5 bathrooms. Based on Redfin's New Albany data, we estimate the home's value is $1,005,172.
Single-familyProperty Type
2018Year Built
6.34 acresLot Size
$246Est. Price/Sq.Ft.
Source:Public Records

Redfin Estimate

$1,005,172
$12K since October

This home's estimate is 15.7% lower than the average sale price ($1.19M) of 6 comparable homes.

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

Earn from this home

Sell
$945,390
Est. take-home

List your home with Redfin and save $10,052

Rent
$3,944/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

Provided by Redfin

Sale history for 5240 Green Cook Rd

As the MLS and public records start to fill up, we'll list the details here.

Tax history for 5240 Green Cook Rd

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

Zoning

AR-1

Agricultural Residential District

The Agricultural Residential District (AR-1) is intended to protect extensive land areas currently in agricultural use and/or extensive areas possessing soils that are especially suited to agricultural purposes and to protect them from uncontrolled encroachment by urban types of development, while preventing pollution of these lands, and underlying water resources. In addition, the Agricultural Residential District (AR-1) is intended to permit construction of low density, large lot (5 acres and greater) single family residences.

Property details

Around this home

Schools

Hylen Souders Elementary School

Public K-3 • Assigned • 3.6mi

5/10
Big Walnut Middle School

Public 5-8 • Assigned • 8.3mi

9/10
Big Walnut High School

Public 9-12 • Assigned • 10.3mi

7/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

7 days above 99° expected this year, 16 days in 30 years

2/10 Wind Factor

1% 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)
30
16
39
24
59
37
68
46
70
52
82
64
86
68
81
62
81
57
66
47
53
38
40
27
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
$955,000 – $1.16M

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

Need the cash from your home fast? Sell to .

Nearby similar homes

$419,000
3 beds1.5 baths1,545 sq ft
4953 E Walnut St, Westerville, OH 43081
Brick farmhouse • 1.16 acres • Large front porch
Stephen Knox • Best Homes Real Estate Ltd., (614) 870-8893
OPEN SAT, 1PM TO 3PM
$359,900
3 beds2 baths1,174 sq ft
6210 New Albany Rd W, New Albany, OH 43054
Open floor plan • New flooring • Private patio
Sandy Raines • The Raines Group, Inc., (614) 924-9000
$1,799,900
4 beds4.5 baths7,040 sq ft
4457 Green Cook Rd, Westerville, OH 43082
1/2-acre pond • Amish cabinetry • Large walk-in pantry
Sandy Raines • The Raines Group, Inc., (614) 924-9000
OPEN SAT, 12PM TO 2PMVIDEO TOUR
$539,900
4 beds2.5 baths3,251 sq ft
6399 Gossamer Ct, Westerville, OH 43081
Cul-de-sac lot • Wooded parkland • Elevated deck
Charles Collins II Collins • Red 1 Realty, (614) 585-9020
NEW CONSTRUCTION
$653,525
2 beds2 baths1,894 sq ft
9571 Findlay Dr, New Albany, OH 43054
Grand entrance • Open layout • Private den
Listing provided by Zillow
NEW CONSTRUCTION
$652,090
2 beds2 baths1,846 sq ft
5574 Wooster Dr, New Albany, OH 43054
Private den • Deluxe kitchen • Fenced courtyard
Joshua Vietmeier • EPCON Realty, Inc., (614) 761-1010

New listings for sale in 43054

NEW 3 HRS AGO
$385,000
2 beds2 baths1,627 sq ft
6224 Stonewalk Ln, New Albany, OH 43054
Open floor plan • Vaulted ceilings • Abundant cabinetry
Ann Goetz-Sullivan • Keller Williams Greater Cols, (614) 944-5900
OPEN SUN, 1PM TO 3PMVIDEO TOUR
$890,000
4 beds3.5 baths4,069 sq ft
5214 Hanover Close, New Albany, OH 43054
Great room • Cozy fireplace • Hardwood floors
Larry Schottenstein • RE/MAX Revealty, (614) 505-7438
COMING SOON
$224,900
2 beds2.5 baths1,370 sq ft
5987 Silver Charms Way #31, New Albany, OH 43054
Finished basement • Community pool • Fitness center
Jenny Assmann • Core Realty Collection, (614) 202-9631
$435,000
4 beds2.5 baths1,901 sq ft
6994 Norton Crossing St, New Albany, OH 43054
Wooded views • Open floor plan • Great room
Jon Kirk • RE/MAX Premier Choice, (800) 759-1112
OPEN SAT, 1PM TO 3PM
$359,900
3 beds2 baths1,174 sq ft
6210 New Albany Rd W, New Albany, OH 43054
Open floor plan • New flooring • Private patio
Sandy Raines • The Raines Group, Inc., (614) 924-9000
$699,900
3 beds2.5 baths2,603 sq ft
5089 Butterworth Green Dr, New Albany, OH 43054
New albany location • Windsor community • First-floor living
Glen Whitten • Ohio Property Group, LLC, (419) 790-3106
$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
OPEN SUN, 1PM TO 3PM
$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
$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

Home values near 5240 Green Cook Rd

Data from public records.

More real estate resources

Dublin homes for sale
Columbus homes for sale
Upper Arlington homes for sale
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

Download the Redfin App on the Apple App Store
Download the Redfin App from the Google Play Store

About us

Why Redfin?
Community Impact
Inclusion
Culture
Press
Investors
Blog
Real Estate News

Find us

Contact Us
Help Center
Advertise

Subsidiaries

Rent.
ApartmentGuide

Affiliated Business

Rocket Close
Rocket Mortgage

Countries

US flagUnited States

Canadian flagCanada

Copyright: © 2026 Redfin. All rights reserved.

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.

Redfin Brokerage Licenses

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.