457 Yellowstone Dr, Farmington, MO 63640
Property image
Property image
SOLD
OCT 27, 2025
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

  • Map ViewExplore the area around 457 Yellowstone Dr.
  • Schools1 Preschool School5 Elementary Schools1 Middle School1 High School
  • Shop & Eat
-- mins to
Commute Destination

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!
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

Active Status

MLS Status: Closed

Interior Features

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 Features

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

Days on Market

Cumulative Days on Market: 144

Property Information

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 & Status

Price
List Price: $422,000Price Per Sqft: $102/sqft
Status Change & Dates
Off Market Date: Mon Oct 27 2025Possession Timing: Close Of Escrow

Location

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

Building Area
Building Area: 4092 Square Feet

Community

Not Senior Community

HOA

HOA Name: Holiday ParkAssociation for this Listing: Mineral Area Board of REALTORSHas an HOA

Lot Information

Lot Area: 0.48 acres

Listing Info

Special Conditions: Standard

Offer

Listing Terms: Cash, Conventional, FHA, USDA Loan, VA Loan

Business

Business Information
Ownership: Private

Miscellaneous

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

DatePriceEventSource
10/27/2025--Sold
MARIS #25036524
09/14/2025$422,000ContingentMARIS #25036524
08/22/2025$422,000PriceChange
MARIS #25036524
07/27/2025$432,000PriceChange
MARIS #25036524
07/06/2025$440,000PriceChange
MARIS #25036524
06/05/2025$455,000Listed For SaleMARIS #25036524
03/24/2021ListingRemovedN/A
03/14/2017$278,500ListingRemovedN/A
01/23/2017$278,500Listed For SaleN/A

Market trends in Farmington

Last updated June 2026
Buyer'sMarketSeller'sMarket
Avg. sale price
$240K
$13.58K
MoM
Sale-to-List Price
—
Price per sq ft
$140
$6
MoM
Available listings
83
12
MoM
Skip to last item
  • Results are loading
Skip to first item

Property Tax and Assessment

Year2025
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.
Skip to last item
Skip to first item

Assigned Schools

These are the assigned schools for 457 Yellowstone Dr.
The GreatSchools Rating compares schools on a variety of school quality indicators including test scores, college readiness, equity and more. Learn more.

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.
  • Henry M.
    "Good schools, great eating, clicky high school type adults. Fun parks, water parks, recreation, and fishing/hiking/atv/camping."
  • Angela G.
    "I've lived up here since 2010. I've raised 2 kids here and I love the school district they are amazing. Great place to live."
  • Capipkin1s
    "Great low traffic area where people are friendly and kids can play outside with pets. Dogs are usually on leashes and there’s a walking path to a dog friendly park. "
  • Katie G.
    "The neighbors love dogs and if yours gets out of the backyard they will help you get your pup back! Very nice and welcoming about dogs no matter the breed or size "
  • Brianedwards386
    "I've lived here for 3 years and I feel very safe. It is a great place to live and everyone is very friendly."
  • Daniel A.
    "I love living in this expanding town. friendly neighbors and small town feel is great. Updates are abound around town which gives it a great feel. "
  • Blbusenbark
    "My commute is only 1.5 mile. It’s pretty easy and I’m usually there in under 10 minutes. Although I do see other cars on the road are usually moving pretty fast"
  • Teelee26foxxygirl
    "Vehicles fly up and down r road and I would hate for my dog to get ran over.. theirs other dogs that roam around the yards and I have had me and my dog has been attacked..."
  • J&l
    "Despite the increase in population and retail over the past 15 years, Farmington remains family-friendly ."
  • Tifany G.
    "I've lived in this neighborhood for over a year and I love how quiet it is. we've got three small children and are within walking distance of the library. "
  • Allidanielle
    "I love the location! I’m close to everything I need in Fenton Arnold or south county! I’m a short 5 mike drive from either interstate! "
  • Edbfree21
    "small town living, very quaint and hospitable, yet there's plenty of employment with good paying jobs."
  • Jsheets
    "Just moved here 5 months ago and love my friendly neighbors. We walk all the time and love visiting with our folks. "

LGBTQ Local Legal Protections

Explore by feature - Pet Friendly

Explore by feature - Air Conditioning

Explore by feature - Washer/dryer

Homes for sale near 457 Yellowstone Dr

Skip to last item
Skip to first item

Off Market Homes Near 457 Yellowstone Dr

Skip to last item
Skip to first item
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