Public Remarks: Nearly-new custom ranch on almost 4 acres! Boasting over 3600 above grade square feet, this sprawling Schumacher build features an open floorplan offering a vaulted living room with stone fireplace, eat-in kitchen with center island, light-filled family room, home office space, two spacious primary suites - each with double vanity baths + walk-in closets, additional bedroom with en suite bath on 1st floor, finished lower level with huge rec space/full bath/4th bedroom with egress, and 4-car attached garage. Outdoors, a swoon-worthy outdoor oasis awaits. Professionally designed by Werbrich's, the $400K installation includes an inground pool with water feature + automatic cover, built-in outdoor kitchen, and pool house complete with kitchenette and bathroom. Don't miss your opportunity to own this one-of-a-kind property for less than you could build for today!
Single-familyProperty Type
2023Year Built
3.95 acresLot Size
$265Est. Price/Sq.Ft.
4 car garageParking
Listed by Eleanor Kowalchik• Keller Williams Pinnacle Group
•513-616-2323 (agent)
•ellie@move2team.com (agent)
•513-697-7355 (broker)
•jeff@marmerrealty.com (broker)
Bought with Lindsay Morrison• ERA REAL Solutions Realty. LLC
*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
3
Baths
3.5
Stories
—
Lot width
—
Lot depth
—
Lot size
3.95 Acres
Year renovated
2023
Sq. Ft.
3,678
Year built
2023
Style
Vacant Land
County
Warren County
APN
17201000140
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Sep 8, 2026.
R-1
Rural Residence
It is the purpose of the R-1 Rural Residence District to establish and maintain an area that allows residential development densities based on the urban service area boundary, with low density
residential development outside the urban service area boundary, protecting rural character, natural
areas and agriculture, and increased residential densities inside the urban service area.
Permitted uses
Include but are not limited to:
Agriculture-Other
Housing-Single unit
Park & open space
Property details
Parking
Parking Information
# of Garage Spaces: 4
Garage/Carport: Oversized, Side, Garage Attached
Parking Features: Driveway
Interior
Virtual Tour
Accessibility Information
Bedroom Level 1: Yes
Bathroom Level 1: Yes
Bathroom Level 1 Type: Full, Partial
Bathroom Information
# of Bathrooms (1/2): 2
# of Bathrooms (Full): 4
Bath 1: Full
Bath 1 Level: 1
Bath 2: Full
Bath 2 Level: 1
Bath 3: Full
Bath 3 Level: 1
Bath 4: Full
Bath 4 Level: Lower
Primary Bathroom: Shower
Bedroom Information
# of Bedrooms Total: 4
Primary Bedroom: 18x20 Level: 1
Primary Bedroom Area: 360
Primary Bedroom Dimensions: 18 x 20
Primary Bedroom Length: 18
Primary Bedroom Width: 20
Bedroom 2: 14x18 Level: 1
Bedroom 2 Area: 252
Bedroom 2 Dimensions: 14 x 18
Bedroom 2 Length: 14
Bedroom 2 Width: 18
Bedroom 3: 11x15 Level: 1
Bedroom 3 Area: 165
Bedroom 3 Dimensions: 11 x 15
Bedroom 3 Length: 11
Bedroom 3 Width: 15
Bedroom 4: 13x21 Level: Lower
Bedroom 4 Area: 273
Bedroom 4 Dimensions: 13 x 21
Bedroom 4 Length: 13
Bedroom 4 Width: 21
Den/Recreation Room Information
Recreation Room: 26x60 Level: Lower
Recreation Room Area: 1,560
Recreation Room Dimensions: 26 x 60
Recreation Room Length: 26
Recreation Room Width: 60
Study (Lib/Den): 14x15 Level: 1
Study Features: Walkout, Laminate Floor
Study/Library/Den Area: 210
Study/Library/Den Dimensions: 14 x 15
Study/Library/Den Length: 14
Study Library/Den Width: 15
Kitchen/Dining Room Information
Kitchen Features: Pantry, Counter Bar, Eat-In, Island, Wood Cabinets, Laminate Floor, Marble/Granite/Slate