Skip main navigation
Sold for $1,199,000
Street View
  • $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,223,600 Zestimate®
    $191/sqft
    $4,754 Estimated rent

    Home value

    $1,223,600

    Estimated sales range

    Not available

    $4,754/mo

    Zestimate® history
    Loading
    Loading...

    Owner options

    List your home for rent

    $4,754/mo

    Rent Zestimate®

    Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.

    Learn more

    $4,754/mo

    Rent Zestimate®

    Refinance and save

    $6,008/mo

    Est. payment

    Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.

    See today's rates

    $6,008/mo

    Est. payment

    Explore your selling options

    Work with a Zillow partner agent

    Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.

    Get started

    List with your own agent

    Get your home in front of millions of buyers by listing it on Zillow.

    Learn how to do it

    Sell it yourself

    Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).

    List your home

    What's special

    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!

    Zillow last checked:

    Listing updated:

    Listed by:

    Madison Eisenman 859-815-9972,

    Sibcy Cline, REALTORS-CC

    Bought with:

    Madison Eisenman, 247012

    Sibcy Cline, REALTORS-CC

    Source: NKMLS,MLS#: 634419MLS Logo

    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 & 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: $5,069
    • Date on market: 10/2/2025
    • Cumulative days on market: 19 days

    Price history

    DateEventPrice
    9/17/2025Sold$1,199,000$191/sqft
    Source: NKMLS #634419 Report a problem
    8/6/2025Pending sale$1,199,000$191/sqft
    Source: NKMLS #634419 Report a problem
    7/17/2025Listed for sale$1,199,000-4%$191/sqft
    Source: NKMLS #634419 Report a problem
    11/16/2024Listing removed$1,249,500$199/sqft
    Source: NKMLS #625448 Report a problem
    9/13/2024Price change$1,249,5000%$199/sqft
    Source: NKMLS #625448 Report a problem
    8/9/2024Listed for sale$1,250,000+28.2%$199/sqft
    Source: NKMLS #625448 Report a problem
    10/27/2022Listing removed--
    Source: Huff Realty Report a problem
    10/7/2022Price change$975,000-18.7%$155/sqft
    Source: NKMLS #604811 Report a problem
    8/31/2022Price change$1,199,900-5.9%$191/sqft
    Source: Imagine MLS #22012127 Report a problem
    6/9/2022Listed for sale$1,275,000$203/sqft
    Source: Imagine MLS #22012127 Report a problem

    Public tax history

    YearProperty taxesTax assessment
    2024$5,069 -0.6%$387,500
    2023$5,100 +12.9%$387,500
    2022$4,518 -0.7%$387,500
    2021$4,549 +2.6%$387,500
    2020$4,435 0%$387,500
    2019$4,437 +1.2%$387,500
    2018$4,382 +1.2%$387,500
    2017$4,331 $387,500
    2016-- $387,500 -7.7%
    2015-- $420,000 -3.4%
    2013-- $434,900
    2011-- $434,900
    2010-- $434,900
    Find assessor info on the county website

    Neighborhood: 41043

    Nearby schools

    GreatSchools rating
    Schools provided by the listing agent
    • Elementary: Taylor Elementary
    • Middle: Bracken County Middle
    • High: Bracken County High

    Source: NKMLS. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.

    Get pre-qualified for a loan
    At Zillow Home Loans, we can pre-qualify you in as little as 5 minutes with no impact to your credit score.

    An equal housing lender. NMLS #10287.