Jenn Lawler
REALTOR®
BEDS5
BATHS3 full 1 partial
SQUARE FEET5,060
MLS#26027734
STATUSActive
PROPERTY TYPEResidential - Single Family
SUBDIVISIONGrandview Farms
SCHOOLUnion R-XI
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
Property Type: Residential - Single Family
Basement: 9 ft + Pour, Bathroom, Finished, Full, Interior Entry, Sleeping Area, Storage Space, Walk-Out Access
Basement: Yes
Cooling: Central Air
Garage: 6 car attached
Heating: Forced Air
Home Style: Ranch, Traditional
Lot Size: 4.84 Acres
Roof Type: Architectural Shingle
Taxes: $4,222
Year Built: 2003
Amenities
Bar
Breakfast Bar
Ceiling Fan(s)
Custom Cabinetry
Double Vanity
Eat-in Kitchen
Entrance Foyer
Kitchen Island
Open Floorplan
Recessed Lighting
Separate Dining
Soaking Tub
Solid Surface Countertop(s)
Vaulted Ceiling(s)
Walk-In Closet(s)
Walk-In Pantry
Workshop/Hobby Area
Feature Descriptions
Appliances: Dishwasher, Disposal, Range, Refrigerator, Electric Water Heater, Water Softener
Association Amenities: None
Days on Site: 7
Exterior: Brick, Vinyl Siding
Fireplace: Living Room
HOA Fee: $300/ Annually
Lot: Cul-De-Sac, Open Lot, Pond on Lot, Some Trees
Parcel#: 18-9-320-0-010-043600
Parking: Attached, Concrete, Detached, Garage, Garage Door Opener, Garage Faces Side, Heated Garage
Sewer: Septic Tank
SQFT. Above Grade: 2530
SQFT. Below Grade: 2530
Swimming Pool: Yes
Utilities: Cable Connected, Electricity Connected, Propane Owned
Water: Well
Local Schools
High School: Union High
Middle School: Union Middle
Elementary School: Prairie Dell Elem.
School District: Union R-XI
Listed By / Shown By
Listed By
Agency Name: HD Real Estate, LLC
Shown By
Agent Name: Jenn Lawler
Agent Phone: Cell: 314.225.0280
Agency Title: RedKey Realty Leaders
Estimate Your Payment
Estimated Payment
$ 5,230.67 per month $4,630.92 Principal & Interest $351.83 Property Tax $247.92 Homeowner's InsuranceChange Payment Information
Member Participants (and their affiliated licensees, if applicable) shall indicate on their websites that IDX information is provided exclusively for consumers’ personal non-commercial use, that it may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing, that the data is deemed reliable but is not guaranteed by MLS GRID, and that the use of the MLS GRID Data may be subject to an end user license agreement prescribed by the Member Participant’s applicable MLS if any and as amended from time to time. MLS GRID may, at its discretion, require use of other disclaimers as necessary to protect Member Participant, and/or their MLS from liability.
Based on information submitted to the MLS GRID. 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.
Privacy Policy / DMCA Notice / ADA Accessibility
This site is hosted, designed and copyright
© 1994 - 2026 by
Delta Media Group, Inc. -- Patent Pending --
495 Grandview Farms Drive | MLS# 26027734
This single family home located at 495 Grandview Farms Drive, Union, MO 63084 is currently listed for sale with an asking price of $850,000. This property was built in 2003 and has 5 bedrooms and 3 full and 1 partial baths with 5060 sq. ft. Grandview Farms Drive is located in the Grandview Farms subdivision within the Union R-XI school district. Search Grandview Farms real estate on jennlawler.redkeystlouis.com today.