495 Grandview Farms Drive, Union, MO 63084

• 5 beds |
• 4 baths |
• 5,060 sqft

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.

Listing Status:

Pending

Date Added:

May 13, 2026

Data Last Updated:

July 23, 2026 at 6:19AM

Listing Office:

HD Real Estate, LLC : 573-860-4343

MLS ID:

26027734

Interior

• General: BarBreakfast BarCeiling Fan(s)Custom CabinetryDouble VanityEat-in KitchenEntrance FoyerKitchen IslandOpen FloorplanRecessed LightingSeparate DiningSoaking TubSolid Surface Countertop(s)Vaulted Ceiling(s)Walk-In Closet(s)Walk-In PantryWorkshop/Hobby Area
• Appliances: DishwasherDisposalRangeRefrigeratorElectric Water HeaterWater Softener
• Laundry: Laundry RoomMain Level
• Basement: 9 ft + PourBathroomFinishedFullInterior EntrySleeping AreaStorage SpaceWalk-Out Access
• Flooring: CarpetCeramic TileWood
• A/C: Central Air
• Heating: Forced Air
• Fireplace: Living RoomFireplaceFireplaces: 1

Exterior

• Style: RanchTraditional
• Other Structures: Garage(s)Pool HouseSecond GarageRear PorchScreenedCovered
• Pool: Diving BoardHeatedIn GroundOutdoor PoolPool CoverSalt Water
• Parking: AttachedConcreteDetachedGarageGarage Door OpenerGarage Faces SideHeated Garage

Construction

• Roofing: Architectural Shingle
• General: BrickVinyl SidingTwoConcrete Perimeter

Location

• Road/Access: Private Road
• HOA Amenities: Maintenance Parking/RoadsSnow Removal300.0Annually
• Originating MLS: maris2
• School District: Union R-XI
• County: Franklin

Lot

• Zoning: 18-9-320-0-010-043600
• View: PondPoolTrees/Woods
• Fencing: Back Yard

Utilities

• Utilities: Cable ConnectedElectricity ConnectedPropane OwnedAmeren
• Water: Well
• Sewer: Septic Tank

Financial

• Source: maris2
• Ownership: Private