Stunning custom built home situated on 3 acres in the sought-after Big Walnut School district. The open concept great room boast tray ceilings, engineered hardwood floors, gas fireplace with build-ins. The kitchen adjacent has 10 ft Quartz island with farmhouse sink, 42 in cabinets, chefs gas stove, massive walk in pantry and large eat in area with screened in porch out back. All 4 bedrooms are on this level with large primary suite with zero entry shower with bench and double vanities. There is office on this level along with 1/2 bath at garage entry for convenience. The walk-out lower level, accessible via elevator, host a large gathering area with projector, home bar, 1/2 bath and covered patio. Outside there is electric gate, fenced yard , storage shed and whole house generator.
Aubrey Herb • Hart Real Estate Agency LLC, (614) 562-6872
See all
Provided by Redfin
Sale history for 5151 Green Cook Rd
Date
Event
Price
CBRMLS #224040572
Dec 3, 2024
Sold
$1,200,000
$290/sq ft
Dec 2, 2024
Pending
—
Nov 18, 2024
Pending
—
Nov 18, 2024
Contingent
—
Nov 15, 2024
Listed
$1,200,000
$290/sq ft
Public Records
Oct 30, 2019
Sold
$137,000
$33/sq ft
Public Records
Mar 2, 2018
Sold
$112,000
$27/sq ft
CBRMLS #217020411
Sep 5, 2017
Sold
$118,500
$29/sq ft
Jul 17, 2017
Pending
—
Jun 13, 2017
Listed
$129,900
$31/sq ft
+5
Tract 11A on Green-Cook Road features: 3.2 Acres (New Survey 2017) Big Walnut School District New Albany Mailing Address, NOT New Albany taxes Tract 11A of a Countrytyme Estate Home Site Development Choose Your Own Builder - No Time Limit To Build Tremendous Building Site Tree Lined on 2 Sides Nice Creek Flowing Across the Property Walkout Basement Possible with Views Overlooking Creek Soil Testing Complete for Onsite Septic Consolidated Electric Cooperative Del-Co Water Consumers Gas Harlem Township, Delaware County Recently Rezoned to FR-1 (Farm Residential District) Part of Parcel # 316-440-01-043-010 Conveniently Located: Less than 1 Mile to Bevelhymer Park Green-Cook Rd beco
Year
Property tax
Land + Additions
Assessment*
2025
$14,150 (−1.4%)
$51,170 + $274,470
$325,640
2024
$14,358 (+3.6%)
$51,170 + $274,470
$325,640
2023
$13,852 (+10.5%)
$51,170 + $274,470
$325,640
2022
$12,540 (+0.5%)
$35,910 + $216,090
$252,000
2021
$12,483 (+681.6%)
$35,910 + $216,090
$252,000
2020
$1,597 (+35.0%)
$32,130
2019
$1,183 (+5.8%)
$22,960
2018
$1,119
$22,960
Tax history for 5151 Green Cook Rd
Year
Property tax
Land + Additions
Assessment*
2025
$14,150 (−1.4%)
$51,170 + $274,470
$325,640
2024
$14,358 (+3.6%)
$51,170 + $274,470
$325,640
2023
$13,852 (+10.5%)
$51,170 + $274,470
$325,640
2022
$12,540 (+0.5%)
$35,910 + $216,090
$252,000
2021
$12,483 (+681.6%)
$35,910 + $216,090
$252,000
2020
$1,597 (+35.0%)
$32,130
2019
$1,183 (+5.8%)
$22,960
2018
$1,119
$22,960
*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
4
Baths
3.5
Stories
1
Lot width
—
Lot depth
—
Lot size
3.19 Acres
Year renovated
—
Sq. Ft.
3,240
Year built
2020
Style
Single Family Residential
County
Delaware County
APN
316-440-01-043-023
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Aug 3, 2026.
FR-1
Farm Residential District
There is created within Harlem Township a Farm Residential District (FR-1) to provide for the use of appropriate lands for continued agricultural purposes and to permit construction of low density single family residences and other essentially non-urban types of residential and agricultural activitiesso that the basic rural character of these areas may be preserved and maintained, including the preservation of natural resources, scenic areas, wildlife habitats, and the historic and unique features of the land. The township shall permit the development of these lands in accordance with the ability ofsuch lands to support development and to prevent pollution of air, soil, and water supplies
Property details
Parking
Parking and Garage Information
Has Garage
Has Attached Garage
# of Garage Spaces: 3
Parking Features: Garage Door Opener, Attached Garage
Interior
Bathroom Information
# of Full Bathrooms: 3
# of Half Bathrooms: 2
Bathrooms Total Integer: 5
Bathrooms Total Decimal: 4
Bedroom Information
# of Main Level Bedrooms: 4
Heating & Cooling
Has Cooling
Cooling: Central Air
Has Heating
Heating: Forced Air
Interior Features
Living Area: 4140.0
Flooring: Carpet, Ceramic/Porcelain, Vinyl
Window Features: Insulated All
Interior Features: Dishwasher, Electric Dryer Hookup, Elevator, Gas Range, Gas Water Heater, Microwave, Refrigerator, Security System
Has Fireplace(s)
Fireplace Features: Gas Log
Basement: Full
Has Basement
Exterior
Exterior Features
Patio And Porch Features: Screened Porch
Fencing: Invisible
Foundation Details: Poured
Property Information
Property Sub-Type: Single Family Residence
Year Built: 2020
Other Structures: Shed(s)
Building Area Total: 3240.0
Building Area Source: Realist
Lot Information
Lot Size Area: 3.19
Lot Size Square Feet: 138956.4
Lot Size Acres: 3.19
Financial
Tax Information
Tax Annual Amount: $13,852
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: 3.5
Sq. Ft.: 3,240
Stories: 1.0
Lot Size: 3.19 acres
Style: Single Family Residential
Year Built: 2020
Year Renovated: —
County: Delaware County
APN: 316-440-01-043-023
Home facts updated by county records on Aug 3, 2026
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, 17 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
69
81
62
81
59
68
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
$1.16M – $1.40M
Reach more buyers when you sell with Redfin. Save up to $12,205 in fees.3 minutes to get started.