Skip main navigation
Closed
  • Listing Provided by: Rooted Real Estate & Auction Co.
    Bought with: KBH Realty Group
    Price Unknown

    746 Saint Andrews St, Farmington, MO 63640

    7beds
    7,160sqft
    Single Family Residence
    Built in 2004
    1 Acres Lot
    $850,500 Zestimate®
    $--/sqft
    $4,454 Estimated rent

    Home value

    $850,500

    $655,000 - $1.11M

    $4,454/mo

    Zestimate® history
    Loading
    Loading...

    Owner options

    List your home for rent

    $4,454/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

    $4,454/mo

    Rent Zestimate®

    Refinance and save

    $300/mo

    Est. payment

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

    See today's rates

    $300/mo

    Est. payment

    Explore your selling options

    Work with a Zillow partner agent

    Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.

    Get started

    List with your own agent

    Get your home in front of millions of buyers by listing it on Zillow.

    Learn how to do it

    Sell it yourself

    Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).

    List your home

    What's special

    Beautiful gas fireplaceInground poolLarge private sleeping areaSolid surface counter topsGorgeous one acre lotPrivate basketball shooting areaGorgeous sunroom
    Exquisite Executive home just in time for the New Year! Nestled on a gorgeous one acre lot, this home features over 7,000 sq ft living space with private in-law apartment too! This gorgeous home is wrapped in brick and stone- this home is a lifestyle. A place where luxury and comfort finally meet. Enter the home with large 2 story entry- gorgeous open living room with beautiful gas fireplace and hardwood flooring-to the right is the family room with gas fireplace, built in bar and full bathroom. The gourmet cook's kitchen is the heart of this home. Wrapped in custom cabinetry, solid surface counter tops, and a stunning center island bar that invites family, conversation, and unforgettable meals! Steps away you have the separate dining area and the gorgeous sunroom creating a warm and welcoming flow you'll fall in love with. The primary suite feels like you have stepped into a luxury resort with its own sitting room and fireplace perfect for t slow mornings or those peaceful evenings -a large private sleeping area- large ensuite featuring a deep jetted, soaking tub-separate shower- individual vanities and a large boutique walk in closet. Nice sized bedroom is off the primary suite- could be the nursery, a home office or gym! Upstairs you find another large family space, 3 bedrooms and 2 full bathrooms. Lower level brings you the entertaining and recreation room with another full bedroom and bathroom this level is made for memories: movie nights, game nights, laughter and connection! What about the outside? Come on out to your large, covered patio entertaining area, inground pool, hot tub- custom fireplace, built in bar/kitchen/grilling area- private basketball shooting area- so much space plus a great back yard! Did we talk about the garages yet? WOW! The attached, side entry garage can hold 5-6 vehicles tandem parked-has large storage area too. The detached garage is also the private in law quarters boasting a 3-car garage and over 900 sq foot apartment with open living room/kitchen a nice sized bedroom and full bathroom too-- so much to see here-- must be pre-qualified and have agency agreement prior to viewing approval.

    Zillow last checked:

    Listing updated:

    Listing Provided by:

    Jennifer R Jones 314-952-3994,

    Rooted Real Estate & Auction Co.

    Bought with:

    Kimberly E Briese, 2015042066

    KBH Realty Group

    Source: MARIS,MLS#: 25080711MLS LogoOriginating MLS: Southern Gateway Association of REALTORS

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 7
    • Bathrooms: 7
    • Full bathrooms: 6
    • 1/2 bathrooms: 1
    • Main level bathrooms: 4
    • Main level bedrooms: 3
    Heating
    • Electric
    Cooling
    • Ceiling Fan(s), Central Air
    Appliances
    • Included: Dishwasher, Disposal, Electric Oven, Range, Range Hood, Electric Water Heater, Water Softener
    Features
    • Breakfast Bar, Cathedral Ceiling(s), Ceiling Fan(s), Custom Cabinetry, Eat-in Kitchen, Kitchen Island, Solid Surface Countertop(s), Two Story Entrance Foyer, Walk-In Closet(s), Wet Bar
    • Flooring: Carpet, Ceramic Tile
    • Basement: Partially Finished,Sleeping Area
    • Number of fireplaces: 1
    • Fireplace features: Gas, Living Room
    Interior area
    • Total structure area: 7,160
    • Total interior livable area: 7,160 sqft
    • Finished area above ground: 5,360
    • Finished area below ground: 1,800

    Property

    Parking
    • Total spaces: 8
    • Parking features: Additional Parking, Attached, Driveway, Garage, Garage Door Opener, Garage Faces Side, Inside Entrance, Kitchen Level, Oversized
    • Garage spaces: 8
    • Has uncovered spaces: Yes
    Features
    • Levels: Three Or More
    • Exterior features: Basketball Court
    • Has private pool: Yes
    • Pool features: Fenced, In Ground, Pool Cover
    • Fencing: Back Yard
    Lot
    • Size: 1 Acres
    • Features: Back Yard, Front Yard, Landscaped, Near Golf Course
    Details
    • Parcel number: 096024000000005.30
    • Special conditions: Standard

    Construction

    Type & style
    • Home type: SingleFamily
    • Architectural style: Traditional
    • Property subtype: Single Family Residence
    Materials
    • Brick, Stone
    Condition
    • Year built: 2004

    Utilities & green energy

    • Electric: 220 Volts
    • Sewer: Public Sewer
    • Water: Public
    • Utilities for property: Electricity Connected, Propane, Sewer Connected, Water Connected

    Community & neighborhood

    Location
    • Region: Farmington
    • Subdivision: Greenbriar Hills Ph One

    HOA & financial

    HOA
    • Has HOA: Yes
    • HOA fee: $300 annually
    • Amenities included: None
    • Services included: Common Area Maintenance
    • Association name: Greenbriar

    Other

    Other facts
    • Listing terms: Cash,Conventional,VA Loan
    • Ownership: Private

    Price history

    DateEventPrice
    3/20/2026Sold--
    Source: MARIS #25080711 Report a problem
    2/5/2026Pending sale$850,000-5%$119/sqft
    Source: REALSTACK #98209 Report a problem
    1/30/2026Contingent$895,000$125/sqft
    Source: MARIS #25080711 Report a problem
    12/11/2025Listed for sale$895,000+23.4%$125/sqft
    Source: MARIS #25080711 Report a problem
    1/30/2020Sold--
    Source: MARIS #19060227 Report a problem
    11/4/2019Pending sale$725,000$101/sqft
    Source: Barry Upchurch Realty #19060227 Report a problem
    10/17/2019Price change$725,000-3.3%$101/sqft
    Source: Barry Upchurch Realty #19060227 Report a problem
    9/19/2019Price change$749,900-6.1%$105/sqft
    Source: Barry Upchurch Realty #19060227 Report a problem
    8/14/2019Listed for sale$799,000-11.1%$112/sqft
    Source: Barry Upchurch Realty #19060227 Report a problem
    5/6/2019Listing removed$899,000$126/sqft
    Source: Coldwell Banker Hulsey Real Estate #18062994 Report a problem
    9/20/2018Price change$899,000-9.1%$126/sqft
    Source: Coldwell Banker Hulsey Real Estate #18062994 Report a problem
    8/3/2018Listed for sale$989,000$138/sqft
    Source: Coldwell Banker Hulsey Real Estate #18062994 Report a problem

    Public tax history

    YearProperty taxesTax assessment
    2025$6,469 +7.4%$128,520 +7.5%
    2024$6,021 -0.2%$119,540
    2023$6,030 -0.2%$119,540
    2022$6,040 +13%$119,540 +12.7%
    2021$5,343 -0.6%$106,050
    2020$5,377 0%$106,050
    2019$5,377 $106,050 +14.7%
    2018-- $92,450
    2017-- $92,450
    2016-- $92,450 +4.2%
    2015-- $88,710
    2014-- $88,710
    2013-- $88,710
    2012-- $88,710
    2011-- $88,710
    2010-- $88,710

    Find assessor info on the county website

    Neighborhood: 63640

    Nearby schools

    GreatSchools rating
    Schools provided by the listing agent
    • Elementary: Farmington R-Vii
    • Middle: Farmington Middle
    • High: Farmington Sr. High

    Source: MARIS. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.