417 Hamlet Court
Lake St Louis, MO 63367
- 4 beds
- 4 baths
- 5,791 sqft
- 14,815 sqft lot
- $274 per sqft
- 2017 build
- – on site
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!
Last checked:
As a licensed real estate brokerage, Estately has access to the same database professional Realtors use: the Multiple Listing Service (or MLS). That means we can display all the properties listed by other member brokerages of the local Association of Realtors—unless the seller has requested that the listing not be published or marketed online.
The MLS is widely considered to be the most authoritative, up-to-date, accurate, and complete source of real estate for-sale in the USA.
Estately updates this data as quickly as possible and shares as much information with our users as allowed by local rules. Estately can also email you updates when new homes come on the market that match your search, change price, or go under contract.
Checking…
•
Last updated May 13, 2025
•
MLS# 25005169 —
The Building
-
Year Built:2017
-
Builder Name:Lombardo Homes
-
Construction Materials:Stone Veneer, Brick Veneer
-
Architectural Style:Contemporary, Traditional, Other
-
Door Features:Panel Door(s)
-
Patio And Porch Features:Deck, Composite, Patio
-
Security Features:Security System Leased, Smoke Detector(s)
-
Basement:9 ft + Pour, Bathroom, Partially Finished, Concrete, Walk-Out Access
-
Basement:true
-
Above Grade Finished Area:3,991 Sqft
-
Below Grade Finished Area:1800
-
Below Grade Finished Area Units:Square Feet
Interior
-
Interior Features:Sauna, Separate Dining, Open Floorplan, Vaulted Ceiling(s), Walk-In Closet(s), Breakfast Room, Kitchen Island, Solid Surface Countertop(s), Walk-In Pantry, Double Vanity, Separate Shower
-
Flooring:Carpet
-
Levels:Two
-
Rooms Total:21
-
Fireplace:true
-
Fireplace Features:Recreation Room
-
Fireplaces Total:1
-
Living Area Source:Assessor
-
Living Area:5791
-
Living Area Units:Square Feet
Financial & Terms
-
Possession:Negotiable
-
Ownership Type:Private
-
Listing Terms:Cash, Conventional, FHA, VA Loan
Location
-
Longitude:-90.805546
-
Latitude:38.750983
The Property
-
Property Condition:Updated/Remodeled
-
Property Sub Type:Single Family Residence
-
Property Type:Residential
-
Parcel Number:4-0067-C582-00-0034.0000000
-
Lot Features:Adjoins Common Ground, Sprinklers In Front, Sprinklers In Rear
-
Lot Size Acres:0.3401
-
Lot Size Area:0.34
-
Lot Size Units:Acres
-
Lot Size Square Feet:14,815 Sqft
-
Lot Size Dimensions:see Realist
-
Lot Size Source:Public Records
-
Waterfront:false
-
Pool Features:Private, In Ground
-
Other Structures:Pool House, Second Garage
-
Road Surface Type:Aggregate
Listing Agent
- Contact info:
- Agent phone:
- (314) 894-8775
- Office phone:
- (314) 894-8775
Taxes
-
Tax Year:2024
-
Tax Annual Amount:$10,893
Beds
-
Lower Level Bedrooms:1
-
Upper Level Bedrooms:3
-
Bedrooms Total:4
Baths
-
Bathrooms Full:3
-
Lower Level Bathrooms Full:1
-
Bathrooms Half:1
-
Main Level Bathrooms Half:1
-
Bathrooms Total:4
-
Upper Level Bathrooms Full:2
The Listing
-
Virtual Tour URL Unbranded:
Heating & Cooling
-
Cooling:Central Air, Electric
-
Heating:Dual Fuel/Off Peak, Forced Air, Natural Gas
Utilities
-
Sewer:Public Sewer
-
Utilities:Natural Gas Available
-
Water Source:Public
Appliances
-
Appliances:Dishwasher, Disposal, Double Oven, Gas Cooktop, Ice Maker, Microwave, Range Hood, Refrigerator, Stainless Steel Appliance(s), Wall Oven, Humidifier, Gas Water Heater
Schools
-
Elementary School:Prairie View Elem.
-
Middle School:Frontier Middle
-
High School:Liberty
-
High School District:Wentzville R Iv
The Community
-
Subdivision Name:Vlgs At Shady Creek #4
-
Association Fee:1100
-
Association Fee Includes:Other
-
Association Fee Frequency:Annually
-
Pool Private:true
-
Pool:Yes
Parking
-
Parking Features:Additional Parking, Attached, Detached, Garage, Garage Door Opener, Off Street
-
Parking Total:5
-
Garage Spaces:5
-
Garage:true
-
Attached Garage:true
-
Carport:false
Monthly cost estimate

Asking price
$1,590,000
Expense | Monthly cost |
---|---|
Mortgage
This calculator is intended for planning and education purposes only. It relies on assumptions and information provided by you regarding your goals, expectations and financial situation, and should not be used as your sole source of information. The output of the tool is not a loan offer or solicitation, nor is it financial or legal advice. |
$8,513
|
Taxes | $907 |
Insurance | $437 |
HOA fees | $92 |
Utilities | $180 See report |
Total | $10,129/mo.* |
*This is an estimate |
Walk Score®
Provided by WalkScore® Inc.
Walk Score is the most well-known measure of walkability for any address. It is based on the distance to a variety of nearby services and pedestrian friendliness. Walk Scores range from 0 (Car-Dependent) to 100 (Walker’s Paradise).
Bike Score®
Provided by WalkScore® Inc.
Bike Score evaluates a location's bikeability. It is calculated by measuring bike infrastructure, hills, destinations and road connectivity, and the number of bike commuters. Bike Scores range from 0 (Somewhat Bikeable) to 100 (Biker’s Paradise).
Soundscore™
Provided by HowLoud
Soundscore is an overall score that accounts for traffic, airport activity, and local sources. A Soundscore rating is a number between 50 (very loud) and 100 (very quiet).
Air Pollution Index
Provided by ClearlyEnergy
The air pollution index is calculated by county or urban area using the past three years data. The index ranks the county or urban area on a scale of 0 (best) - 100 (worst) across the United Sates.
Sale history
Date | Event | Source | Price | % Change |
---|---|---|---|---|
5/7/25
May 7, 2025
|
Listed / Active | MARIS | $1,590,000 | |
5/2/25
May 2, 2025
|
Coming Soon | MARIS | $1,590,000 |