Pending MLS# 26027734

495 Grandview Farms Drive, Union, MO 63084

Subdivision: Grandview Farms

List Price: $850,000

5

Bedrooms

4

Baths

2,530

Area (sq.ft)

$336

Cost/sq.ft

2 Story

Type

15

Days on Market

Call Agent

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 Information

List Price $ 850,000

Original Price $ 850,000

Status Pending

MLS# 26027734

Bedrooms 5

Full baths 3

Half baths 1

Main Floor Full Baths 3

Sq. Ft. Above 2,530

Lot Size

Acres 5

Subdivision Grandview Farms

Municipality None

School District Union R-XI

County Franklin

Property Type Residential

Style 2 Story

Style Description

Transaction Type

Special Conditions Standard

Type

Building Exterior Amenities None

Building Style Ranch,Traditional

Ownership Private

Special Description Standard

Appliances Some Dishwasher,Disposal,Range,Refrigerator,Electric Water Heater,Water Softener

Additional Information

Elementary School Prairie Dell Elem.

Jr. High School Union Middle

Sr. High School Union High

Association Fee $300/Annually

Architecture Ranch,Traditional

Construction Brick,Vinyl Siding

Garage Spaces 6

Carport Spaces 0

Basement Description 9 ft + Pour,Bathroom,Finished,Full,Interior Entry,Sleeping Area,Storage Space,Walk-Out Access

Fireplace Type Living Room

Fireplace Location

Lot Dimensions

Special Areas

Cooling Central Air

Sewer Septic Tank Sewer

Heating Forced Air

Water Well

Heat Source

Kitchen

Appliances Dishwasher,Disposal,Range,Refrigerator,Electric Water Heater,Water Softener

Dining

Interior Decor 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

Property Tax $4,222

Map Location

Directions

Change History

Date	Change Type	Previous	New
May 28, 2026	StandardStatus	Active	Pending
May 13, 2026	StandardStatus	Coming Soon	Active
May 12, 2026	New Listing	Coming Soon	Coming Soon
May 12, 2026	New Listing	850000	850000

MORE REALTORS

Agent

MORE, REALTORS

Tap card for more info

[email protected] 314.414.6000 Visit Website

Contact MORE

Have questions or want better options than what you see online? Share a quick note and I'll get right back to you.

First Name

Last Name

Your Email

Phone

Home Phone

How soon are you looking to buy or sell ?

Comments, Questions, Special Requests ? *All Fields Are Requried

When would you like to view this listing?

By clicking continue or signup, you agree to our Term of Use & Privacy Policy.

First Name

Last Name

Your Email

Phone

Home Phone

Pick Date

Pick Time

Please pick date first

MORE REALTORS

MORE, REALTORS

Call 314.414.6000 [email protected] Visit Website

Listing Courtesy of HD Real Estate, LLC - [email protected]

The Digital Millennium Copyright Act of 1998, 17 U.S.C. § 512 (the "DMCA") provides recourse for copyright owners who believe that material appearing on the Internet infringes their rights under U.S. copyright law. If you believe in good faith that any content or material made available in connection with our website or services infringes your copyright, you (or your agent) may send us a notice requesting that the content or material be removed, or access to it blocked. Notices must be sent in writing by email to [email protected] AND [email protected]/

The DMCA requires that your notice of alleged copyright infringement include the following information:

Description of the copyrighted work that is the subject of claimed infringement.
Description of the alleged infringing content and information sufficient to permit us to locate the content.
Contact information for you, including your address, telephone number and email address.
A statement by you that you have a good faith belief that the content in the manner complained of is not authorized by the copyright owner, or its agent, or by the operation of any law.
A statement by you, signed under penalty of perjury, that the information in the notification is accurate and that you have the authority to enforce the copyrights that are claimed to be infringed.
A physical or electronic signature of the copyright owner or a person authorized to act on the copyright owners behalf. Failure to include all of the above information may result in the delay of the processing of your complaint.

The price homes have sold for is not public information in most counties in Missouri therefore our REALTOR® MLS rules require that before we give you access to the sold information you must agree to the Terms of Use below:

You acknowledge:

That you have reviewed the Missouri Broker Disclosure Form, available by clicking the link below, which describes the various types of representation available to consumers. Furthermore, that you have NOT entered into an exclusive agency relationship with our firm, MORE, REALTORS, therefore, we do not have a client relationship with you at this point nor do you have any financial obligation to us at all and that our relationship at this point is you as a consumer and us as a broker. Furthermore, you have reviewed our privacy policy which is accessed by the link at the bottom of our site.
The information you will gain access to on this site shall only by used by you only and no one else and then only for your personal and non-commercial use.
That your interest in obtaining sold prices and sold listing data is because you have a bona fide interest in the purchase, sale or lease of real estate of the type being displayed on this site.
You agree not to copy, redistribute or retransmit any of the information provided to you on this site except in connection with your consideration of the purchase or sale of an individual property.
You understand and acknowledge that the data displayed on this site comes from a databased that is owned by Mid America Regional Information Systems (MARIS) and is subject to their copyright on the data. In addition, the compilation of the data and display of the data is subject to copyright by MORE, REALTORS.
In order to verify our compliance with rules, MARIS may need to access our database which will include your registration information which you hereby grant permission to us to allow and to MARIS to access for compliance purposes.

By checking this box I affirm that I have read and agree to the above Terms and Conditions.