$10,000 Closing Credit¹
#25018863, Listing Office: STL Premier Real Estate
$1,590,000 List price
417 Hamlet Ct Lake St Louis, MO 63367
$10,000
Closing credit¹
4 beds
3 full, 1 partial
7,591 sqft
0.3 acres
$209 / sqft
House
Property details
About 417 Hamlet Ct
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!
Highlights
Home typeResidential
HeatingDual System, Forced Air, Humidity Control
StatusComing Soon
CoolingElectric
Size7,591 sqft
BasementYes
Lot size0.3401 Acres
Year built2017
ParkingAdditional Parking, Attached Garage, Detached, Garage Door Opener, Off Street
MLS #25005169
Attached garage5 spaces
FireplaceGas
Private poolYes
Active DateMay 08, 2025
Summary
- Partial Bathrooms: 1
- Full Bathrooms: 3
- Appliances: Dishwasher, Disposal, Double Oven, Gas Cooktop, Ice Maker, Microwave, Range Hood, Refrigerator, Stainless Steel Appliance(s), Oven
- Basement: Yes
- Interior: Open Floorplan, Carpets, Vaulted Ceiling, Walk-in Closet(s)
- Fireplace: Gas
- Total Bedroom Count: 4
- Garage Space: 5 spaces
- Attached Garage: Yes
- Private Pool: Yes
- Parking: Additional Parking, Attached Garage, Detached, Garage Door Opener, Off Street
- Architectural Style: Contemporary, Traditional, Other
- Heating: Dual System, Forced Air, Humidity Control
- Cooling: Electric
- List Price: $1,590,000
- Price/SqFt: $209
- HOA Amount: $92
- HOA Frequency: Annually
- Lot: Partial Fencing
- Directions: GPS friendly
- Year Built: 2017
- Living Area: 7,591 SqFt
- Lot Size: 0.3401 Acres
- MLS Number: 25005169
- MLS Name: MARIS
- Office Name: RE/MAX Results
Listings courtesy of Mid America Regional Information System as distributed by 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. Properties displayed may be listed or sold by various participants in the MLS.
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.
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.
Listings courtesy of MARIS MLS as distributed by MLS GRID. Copyright © 2025 Mid America Regional Information System (MARIS). All Rights Reserved.
Data displayed may be a portion of, and not a complete set of all listings published in the MLS.
Last updated on: 5/4/2025, 8:23:49 PM Eastern. If you have any questions regarding the accuracy of this data, please contact us at help@rockethomes.com.
Get an agent. Get a mortgage. Save big.¹
$1,590,000
417 Hamlet Ct
$10,000
closing credit¹
Sell your home with Rocket and save even more!
Seller rebate
0.5% sale price²
Price information
Property sales
We're sorry, we currently don't have property sales data for this listing.
Tax history
We're sorry, we currently don't have tax history data for this listing.
Nearby schools
5
Discovery Ridge Elementary School
Public District KG-5
1.1 mi
•2523 Sommers Rd
6
Duello Elementary School
Public District KG-5
2.1 mi
•1814 Duello Rd
6
Green Tree Elementary School
Public District KG-5
2.4 mi
•1000 Ronald Reagan Dr
School ratings are a score out of 10, where 10 is the highest and 1 is the lowest.
Neighborhood
The neighbors living near this home have an average income of $67,783. Most Lake St Louis, MO residents have annual incomes between $35k-100k. Residents typically live in single, no kids family. Most residents in this area have post secondary degree education.
How much money do the neighbors make?
24%
<35k
46%
35k-100k
27%
100k-200k
3%
200k+
What level of education do the neighbors have?
High School Diploma
Post Secondary Degree
Masters Degree
What types of families live nearby?
34%
Single, No Kids
14%
Single, with Kids
23%
Married, No Kids
29%
Married, with Kids
Are the neighbors home owners or renters?
Home Owners
Renters
How old are people in this area?
23%
<11 yrs old
7%
12-17 yrs old
29%
18-34 yrs old
35%
35-64 yrs old
6%
65+ yrs old
What do the neighbors do for fun?
Soccer
College Football
Extreme Sports
Where do the neighbors shop?
Old Navy
Best Buy
Academy Sports & Outdoors
Where do the neighbors go to eat?
Jimmy Johns
Texas Roadhouse
Little Caesars
What do the neighbors drive?
GMC
Ram
Chevrolet
What do the neighbors listen to?
New Country
Contemporary Christian
Country
All data provided by Home Junction and Claritas
Similar homes for sale
$9,797 Closing Credit¹
#25019204, Listing Office: RedKey Realty Leaders
Backup offers
$6,649 Closing Credit¹
#25000365, Listing Office: Fox & Riley Real Estate
Backup offers
$4,036 Closing Credit¹
#25019971, Listing Office: Lou Realty Group
$7,244 Closing Credit¹
#25010028, Listing Office: Compass Realty Group
$4,263 Closing Credit¹
#24077045, Listing Office: Coldwell Banker Realty - Gunda
Backup offers
$4,038 Closing Credit¹
#25015155, Listing Office: St Louis Realty Connections LL
$9,024 Closing Credit¹
#25014792, Listing Office: STL Buy & Sell, LLC
$9,380 Closing Credit¹
#25014876, Listing Office: Platinum Realty of St. Louis
$3,978 Closing Credit¹
#25017150, Listing Office: Coldwell Banker Realty - Gunda
Frequently asked questions
About 417 Hamlet Ct
The listing price of 417 Hamlet Ct property is $1,590,000.
The property 417 Hamlet Ct is a house located in Lake St Louis, Missouri, 63367.
Coming Soon: 417 Hamlet Ct is Coming Soon. This listing has not previously been on the market, but will be on the market soon (no showings are allowed yet). A listing contract has been executed.
The nearby schools for 417 Hamlet Ct are: Discovery Ridge Elementary School (GreatSchools Rating 5/10), Duello Elementary School (GreatSchools Rating 6/10), Green Tree Elementary School (GreatSchools Rating 6/10), Frontier Middle School (GreatSchools Rating 6/10), Wentzville South Middle School (GreatSchools Rating 5/10), Wentzville Middle School (GreatSchools Rating 4/10), Liberty High School (GreatSchools Rating 7/10), Timberland High School (GreatSchools Rating 7/10), Fort Zumwalt West High School (GreatSchools Rating 8/10).
The property at 417 Hamlet Ct has 4 bedrooms and 3 full and 1 half bathrooms.
The property 417 Hamlet Ct is 7,591 SqFt (source: MLS/tax record).
The year of construction for 417 Hamlet Ct is 2017.
This home is located at 417 Hamlet Ct in Lake St Louis, MO and zip code 63367. This 7,591 square foot home, which was built in 2017, sits on a 0.34 acre lot. Features: 4 bedrooms, 4 bathrooms. It has been listed on Rocket Homes since May 1, 2025 and is currently priced at $1,590,000.
While more than 59 listings in Lake St Louis, MO in April 2025 were sold above asking price, there were more than 18 listings sold at asking price, and more than 27 were sold below. In April 2025 in Lake St Louis, MO there were 16.2% more homes for sale than in March. Listings spent 20 days on the market in April 2025, and had a median list price of $354,980 during the same period.
From Rocket Homes Real Estate and based on county public records data.