Listed by Vanessa L Trokey, Coldwell Banker Hulsey, (573) 756-5711 . Bought with Coldwell Banker Realty - Gundaker
457 Yellowstone Dr
Farmington, MO 63640
- 3 Beds
- 3 Baths
- 4,092 sqft (on 0.48 acres)
3 Beds
3 Baths
4,092 sqft
(on 0.48 acres)
Local Information
-- mins to
Home Highlights
Property Type
Single-Family Home
Year Built
2003
Lot Size
0.48 acres
Living Area
4,092 sqft
Price/Sqft
$102/sqft
Parking
2 Car Garage
About this House
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!
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!
457 Yellowstone Dr, Farmington, MO 63640 is a 3 bedroom, 4 bathroom, 4,092 sqft single-family home built in 2003. It last sold for $415,500 on Oct 27, 2025 (2% below the $422,000 asking price). It is currently off market. The Trulia Estimate is $413,900, with a rent estimate of $3,068/month.
Home Details for 457 Yellowstone Dr
|
|---|
MLS Status: Closed |
|
|---|
Interior Details Basement: Concrete,Full,Walk-Out AccessNumber of Rooms: 15Types of Rooms: Bedroom, Bedroom 2, Bedroom 3, Bathroom, Bathroom 2, Bathroom 3, Bathroom 4, Breakfast Room, Dining Room, Family Room, Kitchen, Laundry, Living Room, Other, Recreation RoomWet Bar |
Beds & Baths Number of Bedrooms: 3Main Level Bedrooms: 3Number of Bathrooms: 4Number of Bathrooms (full): 2Number of Bathrooms (half): 2Number of Bathrooms (main level): 3 |
Dimensions and Layout Living Area: 4092 Square Feet |
Appliances & Utilities Utilities: Electricity ConnectedAppliances: Dishwasher, Disposal, Microwave, Electric Oven, Water SoftenerDishwasherDisposalLaundry: Laundry Room,Main LevelMicrowave |
Heating & Cooling Heating: Forced Air,Natural GasHas CoolingAir Conditioning: Ceiling Fan(s),Central AirHas HeatingHeating Fuel: Forced Air |
Fireplace & Spa Number of Fireplaces: 2Fireplace: Basement, Gas, Living RoomHas a Fireplace |
Gas & Electric Has Electric on Property |
Levels, Entrance, & Accessibility Levels: One |
Security Security: Smoke Detector(s) |
|
|---|
Exterior Home Features Patio / Porch: Covered |
Parking & Garage Number of Garage Spaces: 2Number of Covered Spaces: 2No CarportHas a GarageHas an Attached GarageParking Spaces: 2Parking: Garage Attached |
Frontage Not on Waterfront |
Water & Sewer Sewer: Public Sewer |
Finished Area Finished Area (above surface): 3286 Square FeetFinished Area (below surface): 806 |
|
|---|
Cumulative Days on Market: 144 |
|
|---|
Year Built Year Built: 2003 |
Property Type / Style Property Type: ResidentialProperty Subtype: Single Family ResidenceArchitecture: Ranch |
Building Not a New ConstructionDoes Not Include Home Warranty |
Property Information Parcel Number: 097025030190001.00 |
|
|---|
Price List Price: $422,000Price Per Sqft: $102/sqft |
Status Change & Dates Off Market Date: Mon Oct 27 2025Possession Timing: Close Of Escrow |
|
|---|
Direction & Address City: FarmingtonCommunity: Holiday Park Estates |
School Information Elementary School: Farmington R-ViiJr High / Middle School: Farmington MiddleHigh School: Farmington Sr. HighHigh School District: Farmington R-VII |
|
|---|
Building Area Building Area: 4092 Square Feet |
|
|---|
Not Senior Community |
|
|---|
HOA Name: Holiday ParkAssociation for this Listing: Mineral Area Board of REALTORSHas an HOA |
|
|---|
Lot Area: 0.48 acres |
|
|---|
Special Conditions: Standard |
|
|---|
Listing Terms: Cash, Conventional, FHA, USDA Loan, VA Loan |
|
|---|
Business Information Ownership: Private |
|
|---|
BasementMls Number: 25036524Above Grade Unfinished Area: 3286Showing Requirements: Appointment Only, Lockbox, Occupied |
Last check for updates: about 4 hours ago
Listed by Vanessa L Trokey, (573) 330-6261
Coldwell Banker Hulsey
Bought with: Liz Mull, (314) 403-4731, Coldwell Banker Realty - Gundaker
Originating MLS: Mineral Area Board of REALTORS
Source: MARIS, MLS#25036524

Price History for 457 Yellowstone Dr
| Date | Price | Event | Source |
|---|---|---|---|
| 10/27/2025 | -- | Sold | MARIS #25036524 |
| 09/14/2025 | $422,000 | Contingent | MARIS #25036524 |
| 08/22/2025 | $422,000 | PriceChange | MARIS #25036524 |
| 07/27/2025 | $432,000 | PriceChange | MARIS #25036524 |
| 07/06/2025 | $440,000 | PriceChange | MARIS #25036524 |
| 06/05/2025 | $455,000 | Listed For Sale | MARIS #25036524 |
| 03/24/2021 | ListingRemoved | N/A | |
| 03/14/2017 | $278,500 | ListingRemoved | N/A |
| 01/23/2017 | $278,500 | Listed For Sale | N/A |
Market trends in Farmington
Last updated June 2026
Avg. sale price
$240K
$13.58KMoM
Sale-to-List Price
—
Price per sq ft
$140
$6MoM
Available listings
83
12MoM
Property Tax and Assessment
| Year | 2025 |
|---|---|
| Tax | $3,553 |
| Assessment | $371,530 |
Home facts updated by county records
Comparable Sales for 457 Yellowstone Dr
Address | Distance | Property Type | Sold Price | Sold Date | Bed | Bath | Sqft |
|---|---|---|---|---|---|---|---|
0.11 | Single-Family Home | - | 03/20/26 | 3 | 3 | 3,314 | |
0.11 | Single-Family Home | - | 12/12/25 | 4 | 2.5 | 2,329 | |
0.29 | Single-Family Home | - | 11/12/25 | 4 | 3 | 3,300 | |
0.30 | Single-Family Home | - | 09/12/25 | 4 | 3 | 3,071 | |
0.19 | Single-Family Home | - | 08/18/25 | 3 | 3.5 | 2,670 | |
0.21 | Single-Family Home | - | 10/17/25 | 3 | 3 | 4,715 | |
0.36 | Single-Family Home | - | 08/05/25 | 4 | 2.5 | 2,512 | |
0.24 | Single-Family Home | - | 10/08/25 | 3 | 2 | 1,791 | |
0.37 | Single-Family Home | - | 06/05/26 | 3 | 2.5 | 1,503 |
Nearby homes
Get a sense of prices in the area by checking nearby homes.Assigned Schools
These are the assigned schools for 457 Yellowstone Dr.
What Locals Say about Farmington
At least 78 Trulia users voted on each feature.
93 % Say parking is easy
88 % Say car is needed
81 % Say it's dog friendly
80 % Say kids play outside
79 % Say yards are well-kept
78 % Say there's holiday spirit
69 % Say people would walk alone at night
58 % Say it's quiet
54 % Say neighbors are friendly
53 % Say streets are well-lit
52 % Say they plan to stay for at least 5 years
46 % Say it's walkable to grocery stores
46 % Say there's wildlife
45 % Say there are sidewalks
32 % Say it's walkable to restaurants
22 % Say there are community events
Sourced by Trulia users. Learn more about our methodology.
LGBTQ Local Legal Protections
LGBTQ Local Legal Protections
Apartments for Rent
Homes for sale near 457 Yellowstone Dr
Off Market Homes Near 457 Yellowstone Dr

IDX information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.
Information is deemed reliable but not guaranteed. Some IDX listings have been excluded from this website. Click here for more information

