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!
Active
$455,000
457 Yellowstone Dr, Farmington, MO 63640
3beds
4,092sqft
Est.:
Single Family Residence
Built in 2003
0.48 Acres Lot
$-- Zestimate®
$111/sqft
$-- HOA
What's special
- 13 days
- on Zillow |
- 810 |
- 28 |
Likely to sell faster than
Zillow last checked: 7 hours ago
Listing updated: June 05, 2025 at 08:37am
Listing Provided by:
Vanessa L Trokey 573-330-6261,
Coldwell Banker Hulsey
Source: MARIS,MLS#: 25036524
Originating MLS: Mineral Area Board of REALTORS

Travel times
Tour with a buyer’s agent
Tour with a buyer’s agent
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
- 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
- Year built: 2003
Utilities & green energy
- Sewer: Public Sewer
- Water: Public
Community & HOA
Community
- Security: Smoke Detector(s)
- Subdivision: Holiday Park Estates
HOA
- Has HOA: Yes
- HOA name: Holiday Park
Location
- Region: Farmington
Financial & listing details
- Price per square foot: $111/sqft
- Tax assessed value: $323,600
- Annual tax amount: $3,097
- Date on market: 6/5/2025
- Listing terms: Cash,Conventional,FHA,USDA Loan,VA Loan
- Ownership: Private
- Loading
- Loading