Save
Ask
Tour
Hide
Share
$850,000
24 Days On Site

495 Grandview Farms Drive
Union, MO 63084

Single Family Residence|Pending
5
Beds
4
Total Baths
3
Full Baths
1
Partial Bath
5,060
SqFt
$168
/SqFt
2003
Built
Subdivision:
Grandview Farms
County:
Franklin

Due to the health concerns created by Coronavirus we are offering personal 1-1 online video walkthough tours where possible.

495 Grandview Farms Drive495 Grandview Farms Drive495 Grandview Farms Drive495 Grandview Farms Drive
Save
Ask
Tour
Hide
Share

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.

Save
Ask
Tour
Hide
Share
Listing Snapshot
Price 
$850,000
Days On Site 
24 Days
Bedrooms 
5
Inside Area (SqFt) 
5,060 sqft
Total Baths 
4
Full Baths 
3
Partial Baths 
1
Lot Size 
4.84 Acres
Year Built 
2003
MLS® Number 
26027734
Status 
Pending
Property Tax 
$4,222
HOA/Condo/Coop Fees 
$25 monthly
Sq Ft Source 
Estimated
Friends & Family
Recent Activity
a week agoStatus changed to Pending
a week agoListing updated with changes from the MLS®
4 weeks agoListing first seen on site
General Features
Acres 
4.84
Attached Garage 
Yes
Building Features 
BasementHot TubPatioPool
Disclosures 
OtherSee Seller's DisclosureSeptic Disclosure
Foundation 
Concrete Perimeter
Garage 
Yes
Garage Spaces 
6
Levels 
Two
Parking 
AttachedConcreteDetachedGarageGarage Door OpenerGarage Faces SideHeated Garage
Property Sub Type 
Single Family Residence
Security 
Carbon Monoxide Detector(s)Security System
Sewer 
Septic Tank
Special Circumstances 
Standard
SqFt Above 
2530
SqFt Below 
2530
Style 
RanchTraditional
Utilities 
Cable ConnectedElectricity ConnectedPropane
Water Source 
PrivateWell
Interior Features
Appliances 
DishwasherDisposalRangeRefrigeratorElectric Water HeaterWater Softener
Basement 
FinishedFullInterior EntryStorage SpaceWalk-Out AccessBath/Stubbed
Cooling 
Central Air
Fireplace 
Yes
Fireplace Features 
Living Room
Fireplaces 
1
Flooring 
CarpetCeramic TileWood
Heating 
Forced Air
Interior 
BarBreakfast BarCeiling Fan(s)Double VanityEat-in KitchenEntrance FoyerKitchen IslandOpen FloorplanRecessed LightingSoaking TubVaulted Ceiling(s)Walk-In Closet(s)Pantry
Laundry Features 
Laundry RoomMain Level
Main Level Bedrooms 
3
Save
Ask
Tour
Hide
Share
Exterior Features
Construction Details 
BrickVinyl Siding
Fencing 
Back Yard
Lot Features 
Cul-De-SacOpen LotWaterfront
Other Structures 
Garage(s)Pool HouseSecond GarageWorkshop
Patio And Porch 
CoveredRear PorchScreened
Pool Features 
Diving BoardHeatedIn GroundOutdoor PoolPool CoverSalt Water
Private Pool 
Yes
Road Frontage 
Private Road
View 
PondPoolTrees/Woods
Waterfront 
Yes
Waterfront Features 
Pond
Waterview 
PondPoolTrees/Woods
Community Features
Accessibility Features 
Central Living Area
Association Amenities 
None
Association Dues 
300
Financing Terms Available 
CashConventionalFHAVA Loan
HOA Fee Frequency 
Annually
MLS Area 
362 - Union R-11
Roads 
Paved
School District 
Union R-XI
Township 
None
Schools
School District
Union R-XI
Elementary School
Prairie Dell Elem.
Middle School
Union Middle
High School
Union High
Listing courtesy of HD Real Estate, LLC


Based on information submitted to the MLS GRID as of 2026-06-06 12:05 PM UTC. 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.

Neighborhood & Commute
Source: Walkscore
Save
Ask
Tour
Hide
Share