Skip main navigation
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

    List your home for rent

    $2,523/mo

    Rent Zestimate®

    Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.

    Learn more

    $2,523/mo

    Rent Zestimate®

    Refinance and save

    Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.

    See today's rates

    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!

    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#: 25036524MLS LogoOriginating 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