Exceptional executive home on over 3.5 acres of scenic countryside, boasting custom full brick construction. Step inside to discover the elegance of bamboo floors and intricate decorative ceilings. Savor the panoramic river views from the comfort of your living spaces. Unwind in the luxurious walk-in custom master shower. This home features five bedrooms, three and a half baths, and a finished basement for added space. Outside, enjoy the above ground 33'x18' swimming pool and vast outdoor area, new deck, perfect for relaxation and entertainment. Embrace country living at its finest in this remarkable residence.
For sale
$400,000
4991 Mary Ingles Hwy W, Foster, KY 41043
5beds
2,672sqft
Est.:
Single Family Residence, Residential
Built in 2001
3.37 Acres Lot
$-- Zestimate®
$150/sqft
$-- HOA
What's special
- 79 days
- on Zillow |
- 740 |
- 40 |
Zillow last checked: 7 hours ago
Listing updated: April 15, 2025 at 01:48pm
Listed by:
Elizabeth Earick Dykes 513-675-8349,
Howard Hanna Real Estate Services
Source: NKMLS,MLS#: 629565

Travel times
Tour with a buyer’s agent
Tour with a buyer’s agent
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 5
- Bathrooms: 4
- Full bathrooms: 3
- 1/2 bathrooms: 1
Primary bedroom
- Features: Bath Adjoins, Dressing Area, Tray Ceiling(s), Walk-In Closet(s)
- Level: First
- Area: 289
- Dimensions: 17 x 17
Bedroom 2
- Features: See Remarks
- Level: First
- Area: 154
- Dimensions: 14 x 11
Bedroom 3
- Features: See Remarks
- Level: Lower
- Area: 221
- Dimensions: 17 x 13
Bathroom 2
- Features: Tub With Shower
- Level: First
- Area: 48
- Dimensions: 8 x 6
Bathroom 3
- Features: Full Finished Half Bath
- Level: First
- Area: 18
- Dimensions: 3 x 6
Bonus room
- Features: Built-in Features, Fireplace(s)
- Level: Lower
- Area: 465
- Dimensions: 15 x 31
Kitchen
- Features: Breakfast Bar, Gourmet Kitchen, Solid Surface Counters, Pantry, Wood Cabinets
- Level: First
- Area: 289
- Dimensions: 17 x 17
Living room
- Features: Ceiling Fan(s), See Remarks
- Level: First
- Area: 289
- Dimensions: 17 x 17
Other
- Features: See Remarks
- Level: Basement
- Area: 1
- Dimensions: 1 x 1
Other
- Features: See Remarks
- Level: Basement
- Area: 1
- Dimensions: 1 x 1
Other
- Features: See Remarks
- Level: Basement
- Area: 1
- Dimensions: 1 x 1
Primary bath
- Features: Ceramic Tile Flooring, Double Vanity
- Level: First
- Area: 192
- Dimensions: 16 x 12
Heating
- Forced Air, Electric
Cooling
- Central Air
Appliances
- Included: Other, See Remarks, Stainless Steel Appliance(s), Electric Oven, Electric Range, Dishwasher, Microwave, Refrigerator
- Laundry: Electric Dryer Hookup, In Basement, Laundry Room, Washer Hookup
Features
- Walk-In Closet(s), Pantry, Open Floorplan, Eat-in Kitchen, Double Vanity, Crown Molding, Coffered Ceiling(s), Chandelier, Breakfast Bar, Ceiling Fan(s), High Ceilings, Natural Woodwork, Recessed Lighting
- Doors: Multi Panel Doors
- Windows: Double Hung, Wood Frames
- Basement: Full
- Number of fireplaces: 1
- Fireplace features: Electric
Interior area
- Total structure area: 2,672
- Total interior livable area: 2,672 sqft
Property
Parking
- Parking features: Driveway
- Has uncovered spaces: Yes
Accessibility
- Accessibility features: Accessible Doors
Features
- Levels: One
- Stories: 1
- Patio & porch: Deck
- Exterior features: Balcony
- Pool features: Above Ground
- Has view: Yes
- View description: River, Trees/Woods
- Has water view: Yes
- Water view: River
Lot
- Size: 3.37 Acres
- Dimensions: 3.374 acres
- Features: Cleared
Details
- Additional parcels included: 28257
- Parcel number: 28256A
- Zoning description: Residential
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Other
- Property subtype: Single Family Residence, Residential
Materials
- Brick
- Foundation: Poured Concrete
- Roof: Composition
Condition
- Existing Structure
- New construction: No
- Year built: 2001
Utilities & green energy
- Sewer: Septic Tank
- Water: Public
Community & HOA
HOA
- Has HOA: No
Location
- Region: Foster
Financial & listing details
- Price per square foot: $150/sqft
- Tax assessed value: $10,000
- Date on market: 2/6/2025
- Road surface type: Paved
- Loading
- Loading