Rock Island Realty

Contemporary, Traditional, Other

417 Hamlet Court

Lake St Louis, MO 63367

MLS#: 25005169

$1,570,000

Status: Closed
Listing number: 25005169
Listing provided by: RE/MAX Results
Listing agent phone: None
Last update: 8 months ago
On site: 11 months ago
Browse Properties
Vlgs At Shady Creek #4 - Residential

Property

Beds

4

Full Baths

3

1/2 Baths

1

Year Built

2017

Sq.Footage

5,791

Live the resort lifestyle in this luxurious custom estate! Perfect for entertaining/relaxing, this upgraded 2-story home offers 4 BRs, 3.5 baths, a finished walkout LL & 5-car gar. The chef’s kitchen boasts marble/granite countertops, pro-grade appliances, DBL ovens, gas cooktop w/ pot filler & oversized island. Main floor features a theater rm w/ kitchen bar, game room & spa-like primary suite w/ Jacuzzi tub. Expansive windows & motorized shades frame backyard views. The three spacious BRs include WI closets. LL offers large entertainment area, add'l BR, cedar sauna, $10K steam shower dr & ample storage. Step outside to a paradise: saltwater pool w/ grotto waterfall, spa w/ infinity spillover, fire features, sun shelves & lush landscaping by a tranquil pond. Bonus highlights: a gym & finished gar w/ epoxy floors. Whether relaxing poolside, enjoying sunsets, or hosting unforgettable gatherings, this home delivers everyday luxury. It’s a lifestyle. See features & updates for details!

Features & Amenities

Interior

  • Other Interior Features

    Sauna, Open Floorplan, Vaulted Ceiling(s), Walk-In Closet(s), Kitchen Island, Double Vanity, Pantry

  • Total Bedrooms

    4

  • Bathrooms

    3

  • 1/2 Bathrooms

    1

  • Above Grade Finished Area

    3991.0

  • Basement YN

    YES

  • Cooling YN

    YES

  • Cooling

    Central Air, Electric

  • Fireplace YN

    YES

  • Heating YN

    YES

  • Heating

    Forced Air, Natural Gas

  • Pet friendly

    N/A

Exterior

  • Garage

    Yes

  • Garage spaces

    5

  • Construction Materials

    Stone Veneer, Brick Veneer

  • Parking

    Additional Parking, Attached, Detached, Garage, Garage Door Opener, Off Street

  • Patio and Porch Features

    Deck, Patio

  • Pool

    Yes

  • Pool Features

    Private, In Ground

  • Waterfront YN

    NO

Area & Lot

  • Lot Features

    Sprinklers In Front, Sprinklers In Rear

  • Lot Size(acres)

    0.3401

  • Property Type

    Residential

  • Property Sub Type

    Single Family Residence

  • Architectural Style

    Contemporary, Traditional, Other

Price

  • Sales Price

    $1,570,000

  • Tax Amount

    $10,893

  • Sq. Footage

    5, 791

  • Price/SqFt

    $271

HOA

  • Association

    Yes

  • Association Fee

    $1,100

  • Association Fee Frequency

    Annually

  • Association Fee Includes

    N/A

School District

  • Elementary School

    Prairie View Elem.

  • Middle School

    Frontier Middle

  • High School

    Liberty

Property Features

  • Ownership

    Private

  • Sewer

    Public Sewer

  • Water Source

    Public

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

St. Charles

Elementary School

Prairie View Elem.

Middle School

Frontier Middle

High School

Liberty

Listing Courtesy of Sarah Nguyen-Bani , RE/MAX Results

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.
Live the resort lifestyle in this luxurious custom estate! Perfect for entertaining/relaxing, this upgraded 2-story home offers 4 BRs, 3.5 baths, a finished walkout LL & 5-car gar. The chef’s kitchen boasts marble/granite countertops, pro-grade appliances, DBL ovens, gas cooktop w/ pot filler & oversized island. Main floor features a theater rm w/ kitchen bar, game room & spa-like primary suite w/ Jacuzzi tub. Expansive windows & motorized shades frame backyard views. The three spacious BRs include WI closets. LL offers large entertainment area, add'l BR, cedar sauna, $10K steam shower dr & ample storage. Step outside to a paradise: saltwater pool w/ grotto waterfall, spa w/ infinity spillover, fire features, sun shelves & lush landscaping by a tranquil pond. Bonus highlights: a gym & finished gar w/ epoxy floors. Whether relaxing poolside, enjoying sunsets, or hosting unforgettable gatherings, this home delivers everyday luxury. It’s a lifestyle. See features & updates for details!

417 Hamlet Court

Message successfully sent.

What would you like to know?

What is 3 + 4 ?

Related Properties

Waterfront Living at its Finest! Updated Waterfront on Lake Saint Louis boasts a Two-Story Grand Entry Foyer with breathtaking entry door and gorgeous staircase. All new engineered wood flooring throughout the entire main level and all new LVP flooring in the entire deep pour atrium walkout lower level. Main floor primary suite with zero entry custom tiled shower and a heated whirlpool tub, double bowl vanity, private water closet, and a large custom walk-in closet. The primary bedroom also has an atrium door to a private waterfront maintenance free deck! Great room with atrium windows with its lake views and balcony over the two-story spaciousness of the center of the home has a gas fireplace and a wet bar. Chef's kitchen with not one, but two Sub-Zero Built-In Refrigerators and a beverage center, Wolf Appliances with a six-burner gas stove with pot filler, double ovens, and a large center island breakfast bar defines the kitchen and kitchen dining space with a turret ceiling. The main floor also features a library or home office with French doors, a main floor laundry off the three-car garage, a formal dining room with ambiance lighting in the tray ceiling. There is a screened porch off of the kitchen and it extends to all of the maintenance free decks adorning the home. The finished walkout atrium lower level is a deep pour foundation ranging in ceiling heights from 9 feet to 11 feet with plenty of natural light pouring in from the windows. You'll find an entertainer's dream with large rec rooms and another wet bar with plenty of seating. The backyard requires no grass cutting, which allows for more time to enjoy the lake life! Deep Water No Wake Cove, but not far from the main channel, and a Concrete dock with boat lift is included, as well as an updated seawall, two updated HVAC systems, and the architectural roof is only 6 years old. Move-In Ready to start enjoying your Lake Life! Boat to The Dam Bar and Concerts on the Lake. Showings begin April 10, 2026. Open Saturday, 4/11/2026 from 11 am to 1 pm and Sunday, 4/12/2026 from 1 pm - 3 pm.
#26018148

Lake St Louis

11 Regatta Bay Court

4 Beds

3 Baths

5,271 Sq.Ft.

$1,295,000

MLS#: 26018148

- property

Send a message

Message successfully sent.

Your message

What is 3 + 4 ?

Reason for contacting?

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

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