Where land and luxury meet—this stunning full-brick estate sits atop 75 acres with one of the best views of the Ohio River you'll find. Just 45 minutes from Cincinnati, the home is accessed by a private concrete driveway and offers 4 spacious bedrooms, each with its own en suite, and 3 with walk-out access to sweeping sunrise-to-sunset views. Enjoy a full entertainment basement, 2 laundry rooms, elevator to all 3 levels, and 4 wood-burning fireplaces. Outdoor living includes a three-tiered deck and full patio with river views from every level. The land is fully usable—open area plus wooded acreage full of timber and prime location for deer and turkey hunting. A large 2-car garage completes this rare opportunity to own a truly private, luxurious retreat that perfectly blends elegance, nature, and function!
Sold for $1,199,000 on 09/17/25
$1,199,000
4182 Mary Ingles Hwy W, Foster, KY 41043
4beds
6,276sqft
Single Family Residence, Residential
Built in 1996
75 Acres Lot
$1,200,200 Zestimate®
$191/sqft
$4,092 Estimated rent
Owner options
What's special
Zillow last checked: 8 hours ago
Listing updated: October 17, 2025 at 10:17pm
Listed by:
Madison Eisenman 859-815-9972,
Sibcy Cline, REALTORS-CC
Bought with:
Madison Eisenman, 247012
Sibcy Cline, REALTORS-CC
Source: NKMLS,MLS#: 634419

Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 4
- Full bathrooms: 3
- 1/2 bathrooms: 1
Primary bedroom
- Features: Walk-Out Access, Walk-In Closet(s), Bath Adjoins, Dressing Area, Cathedral Ceiling(s), Ceiling Fan(s), Luxury Vinyl Flooring
- Level: First
- Area: 360
- Dimensions: 18 x 20
Bedroom 2
- Features: Walk-Out Access, Bath Adjoins, Luxury Vinyl Flooring
- Level: Second
- Area: 182
- Dimensions: 13 x 14
Bedroom 3
- Features: Walk-Out Access, Bath Adjoins, Luxury Vinyl Flooring
- Level: Second
- Area: 182
- Dimensions: 13 x 14
Bedroom 4
- Features: Walk-Out Access, Bath Adjoins, Luxury Vinyl Flooring
- Level: Basement
- Area: 144
- Dimensions: 12 x 12
Bathroom 2
- Features: Full Finished Half Bath
- Level: First
- Area: 32
- Dimensions: 4 x 8
Bathroom 3
- Features: Full Finished Bath, Tub With Shower
- Level: Second
- Area: 48
- Dimensions: 6 x 8
Bathroom 4
- Features: Full Finished Bath, Tub With Shower
- Level: Second
- Area: 64
- Dimensions: 8 x 8
Bathroom 5
- Features: Full Finished Bath, Shower
- Level: Basement
- Area: 90
- Dimensions: 9 x 10
Other
- Features: Built-in Features, Recessed Lighting
- Level: Basement
- Area: 420
- Dimensions: 20 x 21
Bonus room
- Features: Walk-Out Access
- Level: Basement
- Area: 96
- Dimensions: 12 x 8
Breakfast room
- Features: Walk-Out Access, Luxury Vinyl Flooring
- Level: First
- Area: 238
- Dimensions: 14 x 17
Den
- Features: Walk-Out Access, Fireplace(s), Built-in Features
- Level: Basement
- Area: 420
- Dimensions: 20 x 21
Entry
- Features: Walk-Out Access, Bookcases, Transom, Entrance Foyer, Luxury Vinyl Flooring
- Level: First
- Area: 500
- Dimensions: 20 x 25
Kitchen
- Features: Walk-Out Access, Fireplace(s), Breakfast Bar, Kitchen Island, Eat-in Kitchen, Pantry, Wood Cabinets, Recessed Lighting, Luxury Vinyl Flooring
- Level: First
- Area: 360
- Dimensions: 18 x 20
Laundry
- Features: Built-in Features, Luxury Vinyl Flooring
- Level: First
- Area: 100
- Dimensions: 10 x 10
Living room
- Features: Walk-Out Access, Fireplace(s), Built-in Features, Ceiling Fan(s), Recessed Lighting, Luxury Vinyl Flooring
- Level: First
- Area: 420
- Dimensions: 20 x 21
Office
- Features: Walk-Out Access, Luxury Vinyl Flooring
- Level: Basement
- Area: 252
- Dimensions: 12 x 21
Primary bath
- Features: Ceramic Tile Flooring, Double Vanity, Shower
- Level: First
- Area: 216
- Dimensions: 12 x 18
Workshop
- Features: Walk-Out Access, Built-in Features
- Level: Basement
- Area: 728
- Dimensions: 26 x 28
Heating
- Geothermal, Forced Air
Cooling
- Geothermal
Appliances
- Included: Stainless Steel Appliance(s), Electric Cooktop, Electric Oven, Dishwasher, Dryer, Microwave, Refrigerator, Washer
Features
- Kitchen Island, Walk-In Closet(s), Storage, Pantry, Open Floorplan, Granite Counters, Entrance Foyer, Eat-in Kitchen, Double Vanity, Ceiling Fan(s), Elevator, High Ceilings, Natural Woodwork, Recessed Lighting, Built-in Features, Master Downstairs
- Windows: Wood Frames
- Basement: See Remarks
- Number of fireplaces: 4
- Fireplace features: Stone, Wood Burning
Interior area
- Total structure area: 6,276
- Total interior livable area: 6,276 sqft
Property
Parking
- Total spaces: 2
- Parking features: Driveway, Garage, Garage Faces Front
- Garage spaces: 2
- Has uncovered spaces: Yes
Accessibility
- Accessibility features: Accessible Doors, Accessible Elevator Installed
Features
- Levels: Two
- Stories: 2
- Patio & porch: Covered, Deck, Patio, Porch
- Exterior features: Private Yard, Fire Pit, Balcony, Lighting
- Has view: Yes
- View description: River, Trees/Woods
- Has water view: Yes
- Water view: River
Lot
- Size: 75 Acres
- Features: Rolling Slope, Wooded
- Residential vegetation: Partially Wooded
Details
- Parcel number: 3603
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Traditional
- Property subtype: Single Family Residence, Residential
Materials
- Brick
- Foundation: Poured Concrete
- Roof: Metal
Condition
- Existing Structure
- New construction: No
- Year built: 1996
Utilities & green energy
- Sewer: Septic Tank
- Water: Cistern
- Utilities for property: Propane
Community & neighborhood
Location
- Region: Foster