746 Saint Andrews Street, Farmington, MO 63640 (MLS # 25080711)
Twitter
Facebook
Email
|
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.
| DAYS ON MARKET | 5 | LAST UPDATED | 12/10/2025 |
|---|---|---|---|
| TRACT | Greenbriar Hills Ph One | YEAR BUILT | 2004 |
| COMMUNITY | 700 - Farmington | GARAGE SPACES | 8.0 |
| COUNTY | St. Francois | STATUS | Active |
| PROPERTY TYPE(S) | Single Family |
| Elementary School | Farmington R-VII |
|---|---|
| Jr. High School | Farmington Middle |
| High School | Farmington Sr. High |
| ADDITIONAL DETAILS | |
| AIR | Ceiling Fan(s), Central Air |
|---|---|
| AIR CONDITIONING | Yes |
| APPLIANCES | Dishwasher, Disposal, Electric Oven, Electric Water Heater, Range, Range Hood, Water Softener |
| AREA | 700 - Farmington |
| BASEMENT | Bath/Stubbed, Partially Finished, Yes |
| CONSTRUCTION | Brick, Stone |
| EXTERIOR | Basketball Court |
| FIREPLACE | Yes |
| GARAGE | Yes |
| HEAT | Electric |
| HOA DUES | 300|Annually |
| INTERIOR | Breakfast Bar, Cathedral Ceiling(s), Ceiling Fan(s), Eat-In Kitchen, Entrance Foyer, Kitchen Island, Walk-in Closet(s), Wet Bar |
| LOT | 1 acre(s) |
| LOT DESCRIPTION | Back Yard, Front Yard, Landscaped, Near Golf Course |
| LOT DIMENSIONS | irr |
| PARKING | Additional Parking, Attached, Driveway, Garage, Garage Door Opener, Garage Faces Side, Inside Entrance, Kitchen Level, Oversized |
| POOL | Yes |
| POOL DESCRIPTION | Fenced, In Ground, Pool Cover |
| SEWER | Public Sewer |
| STORIES | 3+ |
| STYLE | Traditional |
| SUBDIVISION | Greenbriar Hills Ph One |
| TAXES | 6469 |
| UTILITIES | Electricity Connected, Propane, Sewer Connected, Water Connected |
| WATER | Public |
MORTGAGE CALCULATOR
TOTAL MONTHLY PAYMENT
0
P
I
*Estimate only
| SATELLITE VIEW |
| / | |
We respect your online privacy and will never spam you. By submitting this form with your telephone number
you are consenting for Robeck
Realty to contact you even if your name is on a Federal or State
"Do not call List".
Listing provided by Premier Farm Realty Group LLC
Listings displaying the MARIS logo are courtesy of the participants of Mid America Regional Information Systems Internet Data Exchange.
Disclaimer: Information From Third Parties, Deemed Reliable But Not Verified.
Any use of search facilities of data on this site, other than by a consumer looking to purchase real estate, is prohibited. No part of this search utility may be reproduced, adapted, translated, stored in a retrieval system or transmitted in any form or by any means, electronic, mechanical, photocopying, recording, or otherwise.
This IDX solution is (c) Diverse Solutions 2025.