Skip main navigation
Active
  • $455,000

    457 Yellowstone Dr, Farmington, MO 63640

    3beds
    4,092sqft
    : 
    Single Family Residence
    Built in 2003
    0.48 Acres Lot
    $-- Zestimate®
    $111/sqft
    $-- HOA

    What's special

    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!
    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#: 25036524MLS LogoOriginating MLS: Mineral Area Board of REALTORS
    Travel times

    Tour with a buyer’s agent

    We’ll find a local expert to take you on a private tour of 457 Yellowstone Dr.

    Next available tour time:Today at 5pm

    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