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!
Closed
Listed by: RE/MAX Results • Sarah N Nguyen-Bani • Contact: 314-704-4282
Bought with: Keller Williams Chesterfield
Price Unknown
417 Hamlet Ct, Lake Saint Louis, MO 63367
4beds
5,791sqft
Single Family Residence
Built in 2017
0.34 Acres Lot
$1,424,200 Zestimate®
$--/sqft
$4,056 Estimated rent
Home value
$1,424,200
$1.32M - $1.52M
$4,056/mo
Zestimate® history
Owner options
List your home for rent
$4,056/mo
Rent Zestimate®
Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.
$4,056/mo
Rent Zestimate®
Refinance and save
$1,100/mo
Est. payment
Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.
$1,100/mo
Est. payment
Explore your selling options
Work with a Zillow partner agent
Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.
Get startedList with your own agent
Get your home in front of millions of buyers by listing it on Zillow.
Learn how to do itSell it yourself
Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).
List your homeWhat's special
Zillow last checked:
Listing updated:
Listed by:
Sarah N Nguyen-Bani 314-704-4282,
RE/MAX Results
Bought with:
Tracy Raspberry, 2002029512
Keller Williams Chesterfield
Source: MARIS,MLS#: 25005169
Originating MLS: St. Louis Association of REALTORS
Originating MLS: St. Louis Association of REALTORSFacts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 4
- Full bathrooms: 3
- 1/2 bathrooms: 1
- Main level bathrooms: 1
Primary bedroom
- Features: Floor Covering: Carpeting, Wall Covering: Some
- Level: Main
- Area: 300
- Dimensions: 20 x 15
Other
- Features: Floor Covering: Carpeting, Wall Covering: Some
- Level: Upper
- Area: 195
- Dimensions: 15 x 13
Other
- Features: Floor Covering: Carpeting, Wall Covering: Some
- Level: Upper
- Area: 299
- Dimensions: 23 x 13
Other
- Features: Floor Covering: Luxury Vinyl Plank, Wall Covering: Some
- Level: Lower
- Area: 238
- Dimensions: 17 x 14
Bonus room
- Features: Floor Covering: Luxury Vinyl Plank, Wall Covering: Some
- Level: Main
- Area: 247
- Dimensions: 19 x 13
Breakfast room
- Features: Floor Covering: Luxury Vinyl Plank, Wall Covering: None
- Level: Main
- Area: 135
- Dimensions: 15 x 9
Den
- Features: Floor Covering: Luxury Vinyl Plank, Wall Covering: Some
- Level: Main
- Area: 30
- Dimensions: 6 x 5
Exercise room
- Features: Floor Covering: Other, Wall Covering: Some
- Level: Lower
- Area: 500
- Dimensions: 25 x 20
Great room
- Features: Floor Covering: Luxury Vinyl Plank, Wall Covering: Some
- Level: Main
- Area: 315
- Dimensions: 21 x 15
Kitchen
- Features: Floor Covering: Luxury Vinyl Plank, Wall Covering: Some
- Level: Main
- Area: 240
- Dimensions: 16 x 15
Laundry
- Features: Floor Covering: Luxury Vinyl Plank, Wall Covering: None
- Level: Main
- Area: 56
- Dimensions: 8 x 7
Media room
- Features: Floor Covering: Luxury Vinyl Plank, Wall Covering: Some
- Level: Main
- Area: 238
- Dimensions: 17 x 14
Mud room
- Features: Floor Covering: Luxury Vinyl Plank, Wall Covering: None
- Level: Main
- Area: 70
- Dimensions: 14 x 5
Office
- Features: Floor Covering: Luxury Vinyl Plank, Wall Covering: Some
- Level: Main
- Area: 168
- Dimensions: 14 x 12
Other
- Features: Floor Covering: Other, Wall Covering: None
- Area: 42
- Dimensions: 7 x 6
Recreation room
- Features: Floor Covering: Luxury Vinyl Plank, Wall Covering: Some
- Level: Lower
- Area: 736
- Dimensions: 46 x 16
Storage
- Features: Floor Covering: Concrete, Wall Covering: None
- Level: Lower
Heating
- Dual Fuel/Off Peak, Forced Air, Natural Gas
Cooling
- Central Air, Electric
Appliances
- Included: Dishwasher, Disposal, Double Oven, Gas Cooktop, Ice Maker, Microwave, Range Hood, Refrigerator, Stainless Steel Appliance(s), Oven, Humidifier, Gas Water Heater
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
- Doors: Panel Door(s)
- Basement: Partially Finished,Concrete,Walk-Out Access
- Number of fireplaces: 1
- Fireplace features: Recreation Room
Interior area
- Total structure area: 5,791
- Total interior livable area: 5,791 sqft
- Finished area above ground: 3,991
- Finished area below ground: 1,800
Property
Parking
- Total spaces: 5
- Parking features: Additional Parking, Attached, Detached, Garage, Garage Door Opener, Off Street
- Attached garage spaces: 5
Features
- Levels: Two
- Patio & porch: Deck, Composite, Patio
- Has private pool: Yes
- Pool features: Private, In Ground
Lot
- Size: 0.34 Acres
- Features: Adjoins Common Ground, Sprinklers In Front, Sprinklers In Rear
Details
- Additional structures: Pool House, Second Garage
- Parcel number: 40067C582000034.0000000
- Special conditions: Standard
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Contemporary,Traditional,Other
- Property subtype: Single Family Residence
Materials
- Stone Veneer, Brick Veneer
Condition
- Updated/Remodeled
- New construction: No
- Year built: 2017
Details
- Builder name: Lombardo Homes
Utilities & green energy
- Sewer: Public Sewer
- Water: Public
- Utilities for property: Natural Gas Available
Community & HOA
Community
- Security: Security System Leased, Smoke Detector(s)
- Subdivision: Vlgs At Shady Creek #4
HOA
- Services included: Other
- HOA fee: $1,100 annually
Location
- Region: Lake Saint Louis
Financial & listing details
- Tax assessed value: $875,413
- Annual tax amount: $10,893
- Date on market: 5/8/2025
- Cumulative days on market: 55 days
- Listing terms: Cash,Conventional,FHA,VA Loan
- Ownership: Private
- Road surface type: Aggregate
Price history
| Date | Event | Price |
|---|---|---|
| 7/14/2025 | Sold | -- |
Source:  MARIS #25005169 Report a problem | ||
| 7/2/2025 | Pending sale | $1,570,000$271/sqft |
Source: MARIS #25005169 Report a problem | ||
| 6/11/2025 | Contingent | $1,570,000$271/sqft |
Source: MARIS #25005169 Report a problem | ||
| 5/23/2025 | Price change | $1,570,000-1.3%$271/sqft |
Source: MARIS #25005169 Report a problem | ||
| 5/8/2025 | Listed for sale | $1,590,000$275/sqft |
Source: MARIS #25005169 Report a problem | ||
| 6/7/2018 | Sold | -- |
Source: Public Record Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | $10,999 +1% | $166,328 +3.9% |
| 2024 | $10,893 +37.8% | $160,060 |
| 2023 | $7,902 -43.3% | $160,060 -16.2% |
| 2022 | $13,933 | $191,003 +20.8% |
| 2021 | -- | $158,135 +5.4% |
| 2020 | -- | $150,033 |
| 2019 | $5,940 | $150,033 +1874.1% |
| 2018 | $5,940 | $7,600 |
Find assessor info on the county website
Neighborhood: 63367
Nearby homes
- $986,7004 bd4 ba2.8k sqft413 Hamlet Ct, Lake Saint Louis, MO 63367Off Market
- $832,3004 bd3 ba3.9k sqft409 Hamlet Ct, Lake Saint Louis, MO 63367Off Market
- $788,7003 bd2 ba2.8k sqft412 Hamlet Ct, Lake Saint Louis, MO 63367Off Market
- $636,924-- bd-- ba-- sqftPaul Renaud Blvd, Wentzville, MO 63367Off Market
- $694,1003 bd2 ba2.5k sqft515 Long Creek Dr, Lake Saint Louis, MO 63367Off Market
- $1,013,5004 bd3 ba3.9k sqft405 Hamlet Ct, Lake Saint Louis, MO 63367Off Market
- $780,6003 bd2 ba2.6k sqft511 Long Creek Dr, Lake Saint Louis, MO 63367Off Market
- $830,0003 bd2 ba2.6k sqft519 Long Creek Dr, Lake Saint Louis, MO 63367Off Market
Nearby schools
GreatSchools rating
- 6/10Prairie View Elementary SchoolGrades: K-5Distance: 2.9 mi
- 10/10Frontier Middle SchoolGrades: 6-8Distance: 1 mi
- 9/10Liberty High SchoolGrades: 9-12Distance: 1.1 mi
Schools provided by the listing agent
- Elementary: Prairie View Elem.
- Middle: Frontier Middle
- High: Liberty
Source: MARIS. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$1,424,200
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$1,424,200
- Missouri
- Saint Charles County
- O Fallon
- 63367
- 417 Hamlet Ct
Nearby cities
Nearby zip codes
Other O Fallon Topics
