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!
Pending
$1,199,000
4182 Mary Ingles Hwy W, Foster, KY 41043
4beds
6,276sqft
Est.:
Single Family Residence, Residential
Built in 1996
75 Acres Lot
$-- Zestimate®
$191/sqft
$-- HOA
What's special
Full entertainment basementWood-burning fireplacesStunning full-brick estateWooded acreageThree-tiered deck
- 24 days
- on Zillow |
- 1,514 |
- 120 |
Zillow last checked: 7 hours ago
Listing updated: August 06, 2025 at 06:44am
Listed by:
Madison Eisenman 859-815-9972,
Sibcy Cline, REALTORS-CC
Source: NKMLS,MLS#: 634419

Travel times
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 4
- Full bathrooms: 3
- 1/2 bathrooms: 1
Primary bedroom
- Features: Cathedral Ceiling(s), Ceiling Fan(s), Dressing Area, Bath Adjoins, Luxury Vinyl Flooring, Walk-In Closet(s), Walk-Out Access
- Level: First
- Area: 360
- Dimensions: 18 x 20
Bedroom 2
- Features: Bath Adjoins, Luxury Vinyl Flooring, Walk-Out Access
- Level: Second
- Area: 182
- Dimensions: 13 x 14
Bedroom 3
- Features: Luxury Vinyl Flooring, Walk-Out Access, Bath Adjoins
- Level: Second
- Area: 182
- Dimensions: 13 x 14
Bedroom 4
- Features: Bath Adjoins, Luxury Vinyl Flooring, Walk-Out Access
- 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: Luxury Vinyl Flooring, Walk-Out Access
- Level: First
- Area: 238
- Dimensions: 14 x 17
Den
- Features: Built-in Features, Fireplace(s), Walk-Out Access
- Level: Basement
- Area: 420
- Dimensions: 20 x 21
Entry
- Features: Bookcases, Entrance Foyer, Transom, Luxury Vinyl Flooring, Walk-Out Access
- Level: First
- Area: 500
- Dimensions: 20 x 25
Kitchen
- Features: Breakfast Bar, Eat-in Kitchen, Fireplace(s), Kitchen Island, Pantry, Recessed Lighting, Luxury Vinyl Flooring, Wood Cabinets, Walk-Out Access
- 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: Built-in Features, Ceiling Fan(s), Fireplace(s), Recessed Lighting, Luxury Vinyl Flooring, Walk-Out Access
- Level: First
- Area: 420
- Dimensions: 20 x 21
Office
- Features: Luxury Vinyl Flooring, Walk-Out Access
- 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 & HOA
HOA
- Has HOA: No
Location
- Region: Foster
Financial & listing details
- Price per square foot: $191/sqft
- Tax assessed value: $387,500
- Annual tax amount: $4,435
- Date on market: 7/18/2025
- Loading