Share this with your friends
+16366672313
Main St. Real Estate
495 Grandview Farms Dr, Union, MO 63084
- $805,000
- 5
- BD
- 4
- BA
- 5,060
- SqFt
- Sold Price
- $805,000
- List Price
- $850,000
- Closing Date
- Jul 30, 2026
- Days on Market
- 78
- MLS#
- 26027734
- Status
- CLOSED
- Bedrooms
- 5
- Full baths
- 3
- Half-baths
- 1
- Living Sq. Ft
- 5,060
- Lot Size
- 210,830
- Acres
- 4.84
- Year Built
- 2003
- Subdivision
- Grandview Farms
- Municipality
- Union R-11
- School District
- Union R-XI
- County
- Franklin
- Listing Type
- Single Family Residential
- Property Type
- Ranch, Traditional
- Style Description
- Ranch, Traditional
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.
Additional Information
- Elementary School
- Prairie Dell Elem.
- Jr. High School
- Union Middle
- Sr. High School
- Union High
- Garage Spaces
- 6
- Parking Description
- Attached, Paved, Detached, Garage, Garage Door Opener, Garage Faces Side, Heated Garage
- Basement Description
- Poured, Bathroom, Finished, Full, Interior Entry, Sleeping Area, Storage Space, Walkout
- Lot Description
- Cul-De-Sac, Open Lot, Pond(s), Trees
- Appliances
- Dishwasher, Disposal, Range, Refrigerator, Electric Water Heater, Water Softener Owned
- Amenities
- None
- Cooling
- Central Air
- Sewer
- Septic Tank
- Heating
- Forced Air
- Water
- Well
- Selling Terms
- Cash, Conventional, FHA, USDA Loan, VA Loan
Listing courtesy of Sadie Click. HD Real Estate, LLC
Selling Office: Rooted Real Estate & Auction Co..How much is your home worth?
...get instant property value now!
Mortgage Calculator
Listings courtesy of Mid America Regional Information Systems Internet Data Exchange as distributed by MLS GRID. 
Based on information submitted to the MLS GRID as of . All data is obtained from various sources and may not have been verified by broker of 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. Some listings have been excluded from this website.