MO
Franklin
Union
63084
495 Grandview Farms Drive
495 Grandview Farms Drive, Union, MO 63084
Share Listing
Listing Type
Single Family
Listing Status
Pending
79
$850,000
Home Details for 495 Grandview Farms Drive
Price
$850,000
Type
Residential
Bedrooms
5
Total Bathrooms
4
Full Bathrooms
3
Half Bathrooms
1
Square feet
5060
Year built
2003
Lot size acres
4.84
County
Franklin
Total rooms
10
Garage
6
Basement
Finished, Full, Interior Entry, Storage Space, Walk-Out Access, Bath/Stubbed
Days on site
72
MLS Listing#
26027734
Hoa
300
Property Description
Set on 4.84+/- picturesque acres with a stunning shared pond, this exceptional estate offers 5,000+/- square feet of beautifully finished living space designed for both everyday comfort and unforgettable entertaining. From the moment you arrive, you’ll appreciate the privacy, space, and resort-style amenities that make this property truly one of a kind. The outdoor living experience is unmatched, featuring a massive in-ground saltwater pool and an impressive pool house complete with a kitchenette and full bath. It's the perfect setup for hosting summer gatherings, weekend guests, or simply enjoying your own private retreat. Inside, the thoughtfully designed main residence offers 5 spacious bedrooms and 3.5 baths, blending functionality with upscale finishes throughout. The recently updated kitchen is a standout feature, showcasing solid surface countertops, custom cabinetry, and stainless steel appliances. Expansive living and entertaining areas provide plenty of room for family and guests alike. The fully finished basement adds incredible versatility with a large bar area, a full bath, and two oversized bedrooms or bonus spaces ideal for a home theater, gym, game room, office, or guest suites. Car enthusiasts, hobbyists, and those needing extra storage will love the attached 3-car garage along with the heated detached 3-car garage featuring its own half bath — offering endless possibilities for workshop space, recreational vehicles, or additional entertaining. A rare combination of luxury, space, and lifestyle amenities, this remarkable property delivers the perfect blend of country serenity and modern convenience.
Property Features
House Interior
- Bar
- Breakfast Bar
- Ceiling Fan(s)
- Double Vanity
- Eat-in Kitchen
- Entrance Foyer
- Kitchen Island
- Open Floorplan
- Recessed Lighting
- Soaking Tub
- Vaulted Ceiling(s)
- Walk-In Closet(s)
- Pantry
Parking
- Attached
- Concrete
- Detached
- Garage
- Garage Door Opener
- Garage Faces Side
- Heated Garage
Basement
- Finished
- Full
- Interior Entry
- Storage Space
- Walk-Out Access
- Bath/Stubbed
Utilities
- Cable Connected
- Electricity Connected
- Propane
Water Features
- Private
- Well
Waterfront and Water Access
- Pond
Cooling Information
- Central Air
Heating Information
- Forced Air
Garage
- 1
Fire Place
- Living Room
School Information
School Information for 495 Grandview Farms Drive, Union, MO 63084
Elementary School
Prairie Dell Elem.
Middle School
Union Middle
High School
Union High
Listing Courtesy: HD Real Estate, LLC - 573-860-4343
Presented by: Sadie Click
Based on information submitted to the MLS GRID as of 2026-05-28 13:59:21 . All data is obtained from various sources and may not have been verified by broker or MLS GRID. Supplied Open House Information is subject to change without notice. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information.Transportation
Check the walk, transit, and bike score for
Neighborhood Market Statistics
See average values in the proximity of this property
Median Listing Price
Median Days on Site
Median Square Feet
Market statistics compiled from data from Mid America Regional Information Systems.
EXIT ELITE REALTY
630 Jeffco Blvd, Arnold, MO 63010Office
636 464 3222
Request more details
Code: