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
Price Unknown
417 Hamlet Ct, Lake Saint Louis, MO 63367
4beds
5,791sqft
Single Family Residence
Built in 2017
0.34 Acres Lot
$1,400,200 Zestimate®
$--/sqft
$4,696 Estimated rent
What's special
Zillow last checked: 7 hours ago
Listing updated: July 16, 2025 at 09:59am
Listing Provided 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

Facts & 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
- Year built: 2017
Details
- Builder name: Lombardo Homes
Utilities & green energy
- Sewer: Public Sewer
- Water: Public
- Utilities for property: Natural Gas Available
Community & neighborhood
Security
- Security features: Security System Leased, Smoke Detector(s)
Location
- Region: Lake Saint Louis
- Subdivision: Vlgs At Shady Creek #4
HOA & financial
HOA
- HOA fee: $1,100 annually
- Services included: Other
Other
Other facts
- Listing terms: Cash,Conventional,FHA,VA Loan
- Ownership: Private
- Road surface type: Aggregate
Services availability
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,400,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,400,200