Welcome to your dream home in Holiday Park Estates! This stunning 3-bedroom, 4-bath home offers exceptional curb appeal and an abundance of space inside and out. The inviting main-level living room features a cozy fireplace, while the oversized kitchen is a dream—complete with a large island, tons of cabinet space, and an adjoining breakfast room perfect for casual dining.
The luxurious master suite includes a 6x15 walk-in closet, double sink vanity, a jetted tub, and a separate shower. The finished basement is built for entertaining, featuring a wet bar, a second fireplace, an enormous 41x30 family room, and a dedicated playroom. Enjoy the huge laundry room, a 2-car attached garage, and extensive storage throughout makes this home as practical as it is beautiful.
With remarkable square footage, thoughtful design, and a prime location—this home truly has it all!
Closed
Listing Provided by:
Vanessa L Trokey 573-330-6261,
Coldwell Banker Hulsey
Bought with: Coldwell Banker Realty - Gundaker
Price Unknown
457 Yellowstone Dr, Farmington, MO 63640
3beds
4,092sqft
Single Family Residence
Built in 2003
0.48 Acres Lot
$415,500 Zestimate®
$--/sqft
$2,523 Estimated rent
Owner options
What's special
Zillow last checked: 8 hours ago
Listing updated: October 27, 2025 at 11:56am
Listing Provided by:
Vanessa L Trokey 573-330-6261,
Coldwell Banker Hulsey
Bought with:
Liz Mull, 2017016449
Coldwell Banker Realty - Gundaker
Source: MARIS,MLS#: 25036524
Originating MLS: Mineral Area Board of REALTORS
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 3
- Bathrooms: 4
- Full bathrooms: 2
- 1/2 bathrooms: 2
- Main level bathrooms: 3
- Main level bedrooms: 3
Bedroom
- Features: Floor Covering: Carpeting
- Level: Main
- Area: 210
- Dimensions: 14x15
Bedroom 2
- Features: Floor Covering: Carpeting
- Level: Main
- Area: 144
- Dimensions: 12x12
Bedroom 3
- Features: Floor Covering: Carpeting
- Level: Main
- Area: 132
- Dimensions: 12x11
Bathroom
- Features: Floor Covering: Wood
- Level: Main
- Area: 25
- Dimensions: 5x5
Bathroom 2
- Features: Floor Covering: Ceramic Tile
- Level: Main
- Area: 135
- Dimensions: 9x15
Bathroom 3
- Features: Floor Covering: Laminate
- Level: Main
- Area: 40
- Dimensions: 5x8
Bathroom 4
- Features: Floor Covering: Vinyl
- Level: Lower
- Area: 30
- Dimensions: 5x6
Breakfast room
- Features: Floor Covering: Wood
- Level: Main
- Area: 128
- Dimensions: 16x8
Dining room
- Features: Floor Covering: Carpeting
- Level: Main
- Area: 156
- Dimensions: 13x12
Family room
- Features: Floor Covering: Carpeting
- Level: Lower
- Area: 1230
- Dimensions: 41x30
Kitchen
- Features: Floor Covering: Wood
- Level: Main
- Area: 224
- Dimensions: 14x16
Laundry
- Features: Floor Covering: Laminate
- Level: Main
- Area: 81
- Dimensions: 9x9
Living room
- Features: Floor Covering: Carpeting
- Level: Main
- Area: 288
- Dimensions: 16x18
Other
- Features: Floor Covering: Carpeting
- Level: Main
- Area: 110
- Dimensions: 10x11
Recreation room
- Features: Floor Covering: Carpeting
- Level: Lower
- Area: 315
- Dimensions: 21x15
Heating
- Forced Air, Natural Gas
Cooling
- Ceiling Fan(s), Central Air
Appliances
- Included: Dishwasher, Disposal, Microwave, Electric Oven, Water Softener
- Laundry: Laundry Room, Main Level
Features
- Breakfast Room, Built-in Features, Ceiling Fan(s), Kitchen Island, Vaulted Ceiling(s), Walk-In Closet(s), Wet Bar
- Basement: Concrete,Full,Walk-Out Access
- Number of fireplaces: 2
- Fireplace features: Basement, Gas, Living Room
Interior area
- Total structure area: 4,092
- Total interior livable area: 4,092 sqft
- Finished area above ground: 3,286
- Finished area below ground: 806
Property
Parking
- Total spaces: 2
- Parking features: Garage - Attached
- Attached garage spaces: 2
Features
- Levels: One
- Patio & porch: Covered
Lot
- Size: 0.48 Acres
- Dimensions: 147 x 140
- Features: Level
Details
- Parcel number: 097025030190001.00
- Special conditions: Standard
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Ranch
- Property subtype: Single Family Residence
Condition
- New construction: No
- Year built: 2003
Utilities & green energy
- Sewer: Public Sewer
- Water: Public
- Utilities for property: Electricity Connected
Community & neighborhood
Security
- Security features: Smoke Detector(s)
Location
- Region: Farmington
- Subdivision: Holiday Park Estates
HOA & financial
HOA
- Has HOA: Yes
- Association name: Holiday Park
Other
Other facts
- Listing terms: Cash,Conventional,FHA,USDA Loan,VA Loan
- Ownership: Private