OFF MARKET

Off market jun 2024 for $1.2M

$1,368,295

Est. refi paymentEst. refi $8,395/mo

•

5,569

sq ft

5401 Green Cook Rd, New Albany, OH 43054

About this home

Must see this amazing custom built luxury home situated on 5+ acres of land. Exceeding 5,500 finished square feet with an open concept design this home includes 5 Bedrooms with primary/ owner's suite on the 1st floor, 4 1/2 bathrooms, loft, 2 story great room, finished lower level/ in-law suite with an egress window & kitchenette, 2 main floor office/ dens, exercise room in lower level w/ built in sauna. Other notable features include massive kitchen island overlooking great room dining room/ breakfast area, messy kitchen/ large pantry, oversized 1st floor laundry room, built in seating in mudroom, custom built elevated patio w/ outdoor kitchen, gas fire pit & hot tub, oversized 3 car side load garage, full basement w/ 9' poured wall foundation & much more.

Single-familyProperty Type

2017Year Built

5.17 acresLot Size

$246Est. Price/Sq.Ft.

3 car garageParking

Listed by Ryan Plowman • Plowman Properties LLC.

•614-499-7776 (agent)

•ryan@plowmanproperties.com (agent)

•614-499-7776 (broker)

•ryan@plowmanproperties.com (broker)

Bought with Carol Reeves • RE/MAX Achievers

•614-419-1042 (agent)

•Reevesteam@gmail.com (agent)

•614-848-9400 (broker)

•pcugini@remax.net (broker)

Redfin checked: a minute ago

•Source:CBRMLS #224008662

Redfin Estimate

$1,368,295

$168K since sold in June 2024$2,000 since September

Recently sold homes
Estimate history
Homes for sale

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

SOLD JUL 15, 2026
$1,795,000
A
4 beds4.5 baths6,340 sq ft
15340 Robins Rd, Johnstown, OH 43031
SOLD APR 13, 2026
$1,795,000
B
5 beds3.5 baths5,481 sq ft
14338 Fancher Rd, Westerville, OH 43082
SOLD JUN 24, 2026
$945,000
C
4 beds4.5 baths4,246 sq ft
7425 Steeplechase Ln, New Albany, OH 43054
SOLD AUG 12, 2026
$940,000
D
5 beds4.5 baths5,446 sq ft
8411 Galdino Dr, New Albany, OH 43054
SOLD MAR 9, 2026
$1,075,000
E
5 beds4.5 baths4,750 sq ft
7342 New Albany Links Dr, New Albany, OH 43054
SOLD JUN 15, 2026
$2,125,000
F
5 beds5.5 baths6,497 sq ft
8140 Schleppi Rd, Westerville, OH 43081

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

Earn from this home

Sell

$367,670

Est. take-home

List your home with Redfin and save $13,683

Refinance

Est. cash available

Get cash now or lower your monthly rate

Rent

$4,450/mo

Redfin rental estimate

List your home for rent

Market trends in 43054, OH

Last updated September 2026

Buyer's Market

Seller's Market

Seller's market

Sale-to-List Price

99.3%

+0.0% MoM

Median sale price

$600K

$260 MoM

Avg. days on market

39d

1 days MoM

Recently sold homes

153

7 MoM

New listings for sale

$400,000
3 beds2.5 baths2,250 sq ft
5893 Blaverly Dr, New Albany, OH 43054
Stacey Lambright • EXP Realty, LLC, (216) 242-2322
OPEN TODAY, 12PM TO 2PM
$675,000
3 beds2 baths2,259 sq ft
8605 Swisher Creek Xing, New Albany, OH 43054
Ann Goetz-Sullivan • Keller Williams Greater Cols, (614) 944-5900
$389,900
3 beds2.5 baths2,013 sq ft
4142 Aumbrey Ct #32, New Albany, OH 43054
Matt Glanzman • RE/MAX ONE, (614) 729-7555
$321,000
3 beds2 baths1,609 sq ft
6814 Winrock Dr #4, New Albany, OH 43054
Nicholas Huscroft • Chosen Real Estate Group, (330) 249-3499
COMING SOON
$395,000
2 beds2 baths1,627 sq ft
4173 Cobbler Rd #9, New Albany, OH 43054
Tammy Elliott • RE/MAX ONE, (614) 729-7555
OPEN TODAY, 11AM TO 1PM
$599,900
3 beds3 baths2,597 sq ft
5420 Tathwell Dr #43, New Albany, OH 43054
Melissa Gilbert • EXP Realty, LLC, (216) 242-2322
$479,000
2 beds2 baths1,395 sq ft
5489 Welbourne Pl #2, New Albany, OH 43054
Carol Goff • Carol Goff & Assoc., (740) 454-6777
$2,900,000
5 beds5.5 baths6,026 sq ft
3905 Ebrington Rd, New Albany, OH 43054
Rob Riddle • New Albany Realty, LTD, (614) 939-8900
COMING SOON
$195,000
1 bed1.5 baths1,050 sq ft
5964 Thunder Gulch Dr #34, New Albany, OH 43054
Sandy Raines • The Raines Group, Inc., (614) 924-9000
$750,000
3 beds2.5 baths3,387 sq ft
4116 Audley Rd, New Albany, OH 43054
Jill Beckett-Hill • Beckett Realty Group, (614) 457-4000
See all

Provided by Redfin

Sale history for 5401 Green Cook Rd

Date

Event

Price

CBRMLS #224008662

Jun 28, 2024

Sold

$1,200,000

$215/sq ft

Jun 3, 2024

Contingent

—

May 29, 2024

Price Changed

$1,300,000

$233/sq ft

May 9, 2024

Price Changed

$1,350,000

$242/sq ft

May 2, 2024

Price Changed

$1,425,000

$256/sq ft

Apr 18, 2024

Price Changed

$1,475,000

$265/sq ft

Mar 29, 2024

Listed

$1,500,000

$269/sq ft

Mar 25, 2024

Coming Soon

$1,500,000

$269/sq ft

CBRMLS #215042765

May 9, 2016

Sold

$96,000

$17/sq ft

Mar 4, 2016

Pending

—

Dec 15, 2015

Listed

$99,900

$18/sq ft

5401 Green-Cook Road in New Albany, OH features: • 5.166 Acres (New Survey 2015) • Big Walnut School District • New Building Lot That Has Never Been Listed Before • Tract #18 of a New Countrytyme Estate Home Site Development • Choose Your Own Builder - No Time Limit To Build • This Tract is Tree Lined on 2 Sides • Franklin County Line is the Southern Boundary • Long Driveway for Private Setting Back away from the Road • Property is Currently in CAUV offering discounted property taxes. • Seller shall pay any recoupment due if removed from the CAUV program. • Consolidated Electric Cooperative • Del-Co Water • Harlem Township, Delaware County • Zoned AR1

Year

Property tax

Land + Additions

Assessment*

2025

$14,842 (+11.5%)

$67,830 + $273,390

$341,220

2024

$13,313 (+3.8%)

$67,830 + $239,330

$307,160

2023

$12,831 (+29.9%)

$67,830 + $239,330

$307,160

2022

$9,875 (+0.5%)

$47,500 + $154,350

$201,850

2021

$9,827 (−0.3%)

$47,500 + $154,350

$201,850

2020

$9,859 (+1.6%)

$47,500 + $154,350

$201,850

2019

$9,704 (+5.8%)

$33,920 + $154,350

$188,270

2018

$9,176 (+539.6%)

$33,920 + $154,350

$188,270

2017

$1,435 (−32.1%)

$31,470

2016

$2,113 (+892.0%)

$23,730

2015

$213

$11,660

Tax history for 5401 Green Cook Rd

Year

Property tax

Land + Additions

Assessment*

2025

$14,842 (+11.5%)

$67,830 + $273,390

$341,220

2024

$13,313 (+3.8%)

$67,830 + $239,330

$307,160

2023

$12,831 (+29.9%)

$67,830 + $239,330

$307,160

2022

$9,875 (+0.5%)

$47,500 + $154,350

$201,850

2021

$9,827 (−0.3%)

$47,500 + $154,350

$201,850

2020

$9,859 (+1.6%)

$47,500 + $154,350

$201,850

2019

$9,704 (+5.8%)

$33,920 + $154,350

$188,270

2018

$9,176 (+539.6%)

$33,920 + $154,350

$188,270

2017

$1,435 (−32.1%)

$31,470

2016

$2,113 (+892.0%)

$23,730

2015

$213

$11,660

*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

4.5

Stories

Lot width

—

Lot depth

—

Lot size

5.17 Acres

Year renovated

—

Sq. Ft.

3,897

Year built

2017

Style

Single Family Residential

County

Delaware County

APN

316-440-01-043-017

Parking Spaces

—

Basement

—

Accessible

—

HOA Dues

—

Garage

—

Features

—

Last updated by owner on Aug 3, 2026.

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

Parking

Parking and Garage Information
Has Garage
Has Attached Garage
# of Garage Spaces: 3
Parking Features: Garage Door Opener, Attached Garage, Side Load

Interior

Virtual Tour Information

Bathroom Information
# of Full Bathrooms: 4
# of Half Bathrooms: 1
Bathrooms Total Integer: 5
Bathrooms Total Decimal: 4.5

Bedroom Information
# of Main Level Bedrooms: 1

Heating & Cooling
Has Cooling
Cooling: Central Air
Has Heating
Heating: Forced Air

Interior Features
Living Area: 5569.0
Flooring: Carpet, Vinyl
Window Features: Insulated All
Interior Features: Dishwasher, Electric Dryer Hookup, Garden/Soak Tub, Gas Range, Gas Water Heater, Hot Tub, Microwave, Refrigerator
Has Fireplace(s)
Fireplace Features: Gas Log
Basement: Egress Window(s), Full
Has Basement

Exterior

Exterior Features
Exterior Features: Waste Tr/Sys
Fencing: Invisible
Foundation Details: Poured

Property Information
Property Sub-Type: Single Family Residence
Year Built: 2017
Building Area Total: 5569.0
Building Area Source: Appraiser

Lot Information
Lot Size Area: 5.17
Lot Size Square Feet: 225205.2
Lot Size Acres: 5.17

Financial

Tax Information
Tax Annual Amount: $12,831
Tax Year: 2023

Utilities

Utilities Information
Sewer: Private Sewer
Water Source: Public

Location

School Information
High School District: BIG WALNUT LSD 2101 DEL CO.

Location Information
Township: Harlem

Public facts

Beds: 4
Baths: 4.5
Sq. Ft.: 3,897
Stories: 2.0
Lot Size: 5.17 acres
Style: Single Family Residential
Year Built: 2017
Year Renovated: —
County: Delaware County
APN: 316-440-01-043-017

Home facts updated by county records on Aug 3, 2026

Other

Information For Agents
Concessions Comments: $7,500 towards Buyer closing cost.
Special Listing Conditions: Standard

Around this home

Schools

Hylen Souders Elementary School

Public K-3 • Assigned • 3.9mi

5/10

Big Walnut Middle School

Public 5-8 • Assigned • 8.5mi

9/10

Big Walnut High School

Public 9-12 • Assigned • 10.5mi

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, 18 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)

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

$1.30M – $1.57M

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

Need the cash from your home fast? Sell to .

Nearby similar homes

$1,799,900

4 beds4.5 baths7,040 sq ft

4457 Green Cook Rd, Westerville, OH 43082

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

$665,000

4 beds3 baths3,250 sq ft

5725 Triplett Sq, New Albany, OH 43054

Jeffery Ruff • Cutler Real Estate, (614) 255-0600

$499,000

3 beds3 baths1,905 sq ft

6924 Joysmith Cir, New Albany, OH 43054

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

$674,900

3 beds3 baths2,422 sq ft

7056 Souder Rd, New Albany, OH 43054

Fred Troyer • Home Equity Realty Group, (330) 952-2244

$485,000

4 beds3.5 baths3,125 sq ft

311 Central Station Dr, Johnstown, OH 43031

Debbie McNichols • RE/MAX Connection, (614) 478-2121

$1,300,000

4 beds3 baths2,265 sq ft

1681 Mink St SW, Pataskala, OH 43062

Jeff Jonas • Keller Williams Capital Ptnrs, (614) 888-1000

New listings for sale in 43054

$400,000

3 beds2.5 baths2,250 sq ft

5893 Blaverly Dr, New Albany, OH 43054

Stacey Lambright • EXP Realty, LLC, (216) 242-2322

OPEN TODAY, 12PM TO 2PM

$675,000

3 beds2 baths2,259 sq ft

8605 Swisher Creek Xing, New Albany, OH 43054

Ann Goetz-Sullivan • Keller Williams Greater Cols, (614) 944-5900

$389,900

3 beds2.5 baths2,013 sq ft

4142 Aumbrey Ct #32, New Albany, OH 43054

Matt Glanzman • RE/MAX ONE, (614) 729-7555

$321,000

3 beds2 baths1,609 sq ft

6814 Winrock Dr #4, New Albany, OH 43054

Nicholas Huscroft • Chosen Real Estate Group, (330) 249-3499

COMING SOON

$395,000

2 beds2 baths1,627 sq ft

4173 Cobbler Rd #9, New Albany, OH 43054

Tammy Elliott • RE/MAX ONE, (614) 729-7555

OPEN TODAY, 11AM TO 1PM

$599,900

3 beds3 baths2,597 sq ft

5420 Tathwell Dr #43, New Albany, OH 43054

Melissa Gilbert • EXP Realty, LLC, (216) 242-2322

$479,000

2 beds2 baths1,395 sq ft

5489 Welbourne Pl #2, New Albany, OH 43054

Carol Goff • Carol Goff & Assoc., (740) 454-6777

$2,900,000

5 beds5.5 baths6,026 sq ft

3905 Ebrington Rd, New Albany, OH 43054

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

COMING SOON

$195,000

1 bed1.5 baths1,050 sq ft

5964 Thunder Gulch Dr #34, New Albany, OH 43054

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

Home values near 5401 Green Cook Rd

Data from public records.

Address	Redfin Estimate
5320 Green Cook Rd, New Albany, OH 3 Beds \| 3 Baths \| 1576 Sq. Ft.	$589,617
5370 Green Cook Rd, New Albany, OH 3 Beds \| 2 Baths \| - Sq. Ft.	$553,062

Address	Redfin Estimate
5288 Green Cook Rd, New Albany, OH 4 Beds \| 2.5 Baths \| 2800 Sq. Ft.	$616,945
5327 Green Cook Rd, New Albany, OH 4 Beds \| 3.5 Baths \| 3200 Sq. Ft.	$1,232,854

Address	Redfin Estimate
5400 Green Cook Rd, New Albany, OH 3 Beds \| 2 Baths \| 1804 Sq. Ft.	$533,997
5257 Green Cook Rd, New Albany, OH - Beds \| - Baths \| - Sq. Ft.	—

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

More real estate resources

Cities
Zip Codes
Neighborhoods
Popular Searches

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

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

Hampsted Village homes for sale
The New Albany Country Club homes for sale
Jefferson homes for sale
New Albany Park Condominiums homes for sale
West Albany 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