Rock Island Realty

Ranch, Traditional

495 Grandview Farms Drive

Union, MO 63084

MLS#: 26027734

$850,000

Status: Active
Listing number: 26027734
Listing provided by: HD Real Estate, LLC
Listing agent phone: None
Last update: 10 days ago
On site: 13 days ago
Browse Properties
Grandview Farms - Residential

Property

Beds

5

Full Baths

3

1/2 Baths

1

Year Built

2003

Sq.Footage

5,060

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.

Features & Amenities

Interior

  • Other Interior Features

    Bar, Breakfast Bar, Ceiling Fan(s), Double Vanity, Eat-in Kitchen, Entrance Foyer, Kitchen Island, Open Floorplan, Recessed Lighting, Soaking Tub, Vaulted Ceiling(s), Walk-In Closet(s), Pantry

  • Total Bedrooms

    5

  • Bathrooms

    3

  • 1/2 Bathrooms

    1

  • Above Grade Finished Area

    2530.0

  • Basement YN

    YES

  • Cooling YN

    YES

  • Cooling

    Central Air

  • Fireplace YN

    YES

  • Heating YN

    YES

  • Heating

    Forced Air

  • Main Level Bedrooms

    3

  • Pet friendly

    N/A

Exterior

  • Garage

    Yes

  • Garage spaces

    6

  • Construction Materials

    Brick, Vinyl Siding

  • Parking

    Attached, Concrete, Detached, Garage, Garage Door Opener, Garage Faces Side, Heated Garage

  • Patio and Porch Features

    Covered, Rear Porch, Screened

  • Pool

    Yes

  • Pool Features

    Diving Board, Heated, In Ground, Outdoor Pool, Pool Cover, Salt Water

  • Waterfront YN

    YES

  • View

    Pond, Pool, Trees/Woods

Area & Lot

  • Lot Features

    Cul-De-Sac, Open Lot, Waterfront

  • Lot Size(acres)

    4.84

  • Lot Size(square feet)

    210830.4

  • Property Type

    Residential

  • Property Sub Type

    Single Family Residence

  • Architectural Style

    Ranch, Traditional

Price

  • Sales Price

    $850,000

  • Tax Amount

    $4,222

  • Sq. Footage

    5, 060

  • Price/SqFt

    $167

HOA

  • Association

    Yes

  • Association Fee

    $300

  • Association Fee Frequency

    Annually

  • Association Fee Includes

    N/A

School District

  • Elementary School

    Prairie Dell Elem.

  • Middle School

    Union Middle

  • High School

    Union High

Property Features

  • New Construction

    NO

  • Accessibility Features

    Central Living Area

  • Association Amenities

    None

  • Foundation Details

    Concrete Perimeter

  • Ownership

    Private

  • Senior Community YN

    NO

  • Sewer

    Septic Tank

  • Water Source

    Private, Well

Schedule a Showing

Showing scheduled successfully.

<
>
IN PERSON
VIA CHAT

What is 3 + 4 ?


Change time

Mortgage calculator

Estimate your monthly mortgage payment, including the principal and interest, property taxes, and HOA. Adjust the values to generate a more accurate rate.

Your payment

Principal and Interest:

$

Property taxes:

$

HOA fees:

$

Total loan payment:

$

Total interest amount:

$

Location

County

Franklin

Elementary School

Prairie Dell Elem.

Middle School

Union Middle

High School

Union High

Listing Courtesy of Sadie Click , HD Real Estate, LLC

RealHub Information is provided exclusively for consumers' personal, non-commercial use, and it may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. All information deemed reliable but not guaranteed and should be independently verified. All properties are subject to prior sale, change or withdrawal. RealHub website owner shall not be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless.

Agent Colleen Brown

FOUNDER

Colleen Brown

Call Colleen today to schedule a private showing.

(573) 480-8130

colleen@homeatthelake.com


* Listings on this website come from the FMLS IDX Compilation and may be held by brokerage firms other than the owner of this website. The listing brokerage is identified in any listing details. Information is deemed reliable but is not guaranteed. If you believe any FMLS listing contains material that infringes your copyrighted work please click here to review our DMCA policy and learn how to submit a takedown request.© 2024 FMLS.
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.

495 Grandview Farms Drive

Message successfully sent.

What would you like to know?

What is 3 + 4 ?

I agree to receive email communication and understand I can unsubscribe at any time.

I agree to be contacted by Colleen Brown via call, email, and text for real estate services. To opt out, you can reply 'stop' at any time or reply 'help' for assistance. You can also click the unsubscribe link in the emails. Message and data rates may apply. Message frequency may vary. Privacy Policy

Related Properties

* CHARMING 2-STORY HOME ON NEARLY 5 ACRES! * Spacious and inviting 3-bedroom, 3.5 bath home located in a small private subdivision just outside of town. This beautifully refreshed property features newly refinished wood floors on the main level and brand-new carpeting. Enjoy abundant natural light from stunning two-story windows and stone gas fireplace for cozy winters in the living area. The spacious family-style layout includes a bonus family room upstairs to a partially finished walkout basement with family/rec room area and sleeping area plus plenty of storage area as well. Oversized 3 car garage and plenty of parking adds to your package as well as take a step outside to a custom 12 x 14 lighted and landscaped pergola courtyard with built-in fireplace and large Oklahoma Joe gas/wood/smoker/grill barbeque system-perfect for entertaining, Relax on the composite deck overlooking a mix of open & wooded land, with access from the living room and primary bedroom---ideal for morning coffee! Additional highlights include lighted front landscaping and 4.82 acres of scenic privacy. A rare blend of comfort, space, and charm -- schedule your showing today! * Please note - Bar and bar hutch in lower level rec room are not attached & DO NOT stay *
#26025805

Union

327 Hickory Spring Lane

3 Beds

3 Baths

3,776 Sq.Ft.

$725,000

MLS#: 26025805

Situated on OVER 2+ acres and NEW ROOF on it's way! 5 bedrooms, 4 bathrooms, 3 fireplaces, 2 stories, 1 finished basement & the WOW factor at every turn! This beautiful Colonial Revival’s grand, estate-like presence offers unmatched views and total privacy. Picturesque columns line the covered porch, & gleaming wood floors pull you into the foyer where a sitting & living room await you. A family room leads to the eat-in kitchen with a breakfast nook & built-in curio; a dining room follows, and a full bath & laundry room complete the main floor. Upstairs, the massive primary suite has a unique bathroom with a laundry shoot, and a Juliette balcony to soak in the stunning vista. 2 bedrooms & a full bath with a lavish tub are down the hall. The remarkable LL hosts a family & rec room, office, 2 bedrooms– including another master with ensuite bath– eat-in kitchen & sunroom– a hospitable home of its own. Exquisitely maintained grounds with a 15-zone toro irrigation system and underground utilities with curbed/concrete streets surround the property, painting a storybook-like setting to admire. On Birch Creek Golf Club with a lighted concrete golf cart path that takes you right to the course & countless other amenities, you’ll want for nothing as you bask in the beauty of this perfectly-placed home– 2 minutes from interstate 44, and a 15-minute drive to the charming shopping and entertainment options in Washington. The location offers both the advantages of county living (close proximity to schools, emergency services, amenities) with the space and seclusion of a rural escape. Bonus: Exterior siding is James Hardie smooth plank fiber cement, and 580 Fairway Drive (1.28 acre neighboring property) & a 2026 individual weekday membership to the Birch Creek Golf Club are also included in the sale!
#25029272

Union

590 Fairway Drive

5 Beds

4 Baths

6,664 Sq.Ft.

$830,000

MLS#: 25029272

- property

Send a message

Message successfully sent.

Your message

What is 3 + 4 ?

Reason for contacting?

I agree to receive email communication and understand I can unsubscribe at any time.

I agree to be contacted by Colleen Brown via call, email, and text for real estate services. To opt out, you can reply 'stop' at any time or reply 'help' for assistance. You can also click the unsubscribe link in the emails. Message and data rates may apply. Message frequency may vary. Privacy Policy

Sign Out

Virtual Assistant

Would you like to take the next step with this property? We can help you schedule a showing or virtual tour, or send you more details.

Yes, I would like more information.

Thank You for Your Reply, One of Our Agents will contact you as soon as possible

No, maybe later.

Thank you, you can always contact me via email, phone number or through the contact form.

Realhub AI

Lucy - Your AI-Powered Realtor

Update Your Temporary Password

Personalize your search

Enter your email and we'll notify you immediately when new listings match what you're looking for.

or enter email address

Already have an account ? Login here

Continue your home search

I agree to receive communications and understand I can unsubscribe at any time.

I agree to be contacted by Colleen Brown via call, email, and text for real estate services. To opt out, you can reply 'stop' at any time or reply 'help' for assistance. You can also click the unsubscribe link in the emails. Message and data rates may apply. Message frequency may vary. Privacy Policy

Already have an account ? Login here

We use cookies

We use cookies primarily for analytics to enhance your experience. By accepting, you agree to our use of these cookies. You can manage your preferences or learn more about our cookies policy.

Privacy Policy Terms of Service