皇冠体育app

Sign In

Close

x
Showing 1 of 0
X
Save
417 Hamlet Court Lake St Louis MO 63367US4 Bed, 4.00 Bath (3 Full Bath , 1 Half Bath), 25005169
417 Hamlet Court Lake St LouisMO63367
1590000.0000 1/1/1900 12:00:00 AM
皇冠体育app Collaborative Executive Office
1242 Main StreetImperialMO63052
000-000-0000

417 Hamlet Court
Lake St Louis MO 63367 US

Save
1 /

Courtesy of: Sarah Nguyen-Bani , RE/MAX Results, sarahsellstl@gmail.com

皇冠体育app Collaborative Executive Office
1242 Main Street
Imperial, MO, US 63052
000-000-0000

Get more info about this property

417 Hamlet Court
Lake St Louis MO 63367 US

$1,590,000

Active Listing ID 25005169
bed icon
4 bed
bath icon
4.00 Bath (3 Full , 1 Half)
lot icon
Lot: 0.34 Acres
home icon
Single Family Residence

$1,590,000

Active Listing ID 25005169
Save
3d icon
Maps

417 Hamlet Court 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鈥檚 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鈥檚 a lifestyle. See features & updates for details!

Collapse all

Property Features

  • Facts
  • Lot Size: 0.34 Acres
  • Property Type: Residential
  • Property Sub-type: Single Family Residence
  • Features
  • Full Bathrooms: 3
  • 1/2 Bathrooms: 1
  • Cooling System: Central Air, Electric
  • Exterior Finish: Pool
  • Floor Covering: Carpet
  • Heating Fuels: Fireplace(s), Forced Air, Natural Gas
  • Additional Features
  • Fireplace
  • Pool

School Information

  • School
  • Prairie View Elem.(Elementary)
  • Frontier Middle(MiddleSchool)
  • Liberty(HighSchool)

Property

  • propertytype: Residential
  • propertysubtype: Single Family Residence
  • listprice: 1590000
  • unparsedaddress: 417 Hamlet Court
  • postalcity: Lake St Louis
  • stateorprovince: MO
  • country: US
  • postalcode: 63367
  • bathroomsfull: 3
  • bathroomshalf: 1
  • bathroomsonequarter: 0
  • bathroomsthreequarter: 0
  • lotsizeacres: 0.3401
  • lotsizeunits: Acres
  • lotsizearea: 0.3401
  • livingarea: 5791
  • livingareaunits: Square Feet
  • latitude: 38.750985
  • longitude: -90.805561
  • listagentfullname: Sarah N Nguyen-Bani
  • listagentemail: sarahbani@stlgoldhomes.com
  • listagentkey: 3yd-MARISMO-SNGUBANI
  • listagentmlsid: SNGUBANI
  • listagentpreferredphone: 3147044282
  • listagentofficephone: 3148948775
  • listofficekey: 3yd-MARISMO-RMXR02
  • listagentstatelicense: 2002004718
  • listofficemlsid: RMXR02
  • disclaimer: Copyright © 2025 MARIS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.
  • sourcesystemid: MARISMO
  • yearbuilt: 2017
  • listagenturl: http://www.homestlouis.com
  • buildername: Lombardo Homes
  • countyorparish: St. Charles
  • parcelnumber: 4-0067-C582-00-0034.0000000
  • elementaryschool: Prairie View Elem.
  • highschool: Liberty
  • elementaryschooldistrict: Wentzville R-IV
  • middleorjuniorschooldistrict: Wentzville R-IV
  • highschooldistrict: Wentzville R-IV
  • appliances: Cooktop, Cooktop - Gas, Dishwasher, Garbage Disposer, Ice Maker, Microwave, Oven - Double, Range, Refrigerator, Washer
  • cooling: Central Air, Electric
  • constructionmaterials: Brick, Brick Veneer, Stone, Stone Veneer
  • flooring: Carpet
  • heating: Fireplace(s), Forced Air, Natural Gas
  • fireplaceyn: True
  • transactiontype: ForSale
  • storiestotal: 2
  • parkingtotal: 5
  • parkingfeatures: Garage, Garage - Attached, Off Street
  • waterfrontyn: False
  • franchiseaffiliation: RE/MAX International
  • interiorfeatures: 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
  • exteriorfeatures: Pool
  • architecturalstyle: Contemporary
  • rooms: Basement, Bathroom 1, Bathroom 2, Bathroom 3, Bathroom 4, Bedroom 1, Bedroom 2, Bedroom 3, Bedroom 4, Bonus Room, Den, Exercise Room, Great Room, Kitchen, Laundry, Media Room, Office, Sauna
  • securityfeatures: Security System, Security System Leased, Smoke Detector(s)
  • dock: False
  • poolprivateyn: True
  • spayn: False
  • internetaddressdisplayyn: True
  • internetautomatedvaluationdisplayyn: True
  • internetconsumercommentyn: True
  • location: -90.80556, 38.750984
  • openhouse: { "AppointmentRequiredYN": false, "ListingKey": "3yd-MARISMO-25005169", "OpenHouseEndTime": "2025-05-17T18:00:00+00:00", "OpenHouseId": "25005169", "OpenHouseRemarks": null, "OpenHouseStartTime": "2025-05-17T16:00:00+00:00", "OpenHouseType": null, "VirtualOpenHouseURL": null }
  • customfields: {"AdditionalInformation":{}, "AlternatePrices":[], "BrokerName":"RE/MAX Results", "BuilderEmail":null, "BuilderFax":null, "BuilderPhone":null, "City":null, "Country":null, "Expenses":[{"ExpenseCategory":"Home Owner Assessments Fee", "ExpenseFrequency":"Annually", "ExpenseValue":1100}], "GeocodeOptions":null, "LeadRoutingEmail":"sarahbani@stlgoldhomes.com", "ListBrokerageCity":"Saint Louis", "ListBrokerageCountry":"US", "ListBrokerageEmail":"info@remax-results.com", "ListBrokerageLogoUrl":"http://brokerlogos.listhub.net/MARISMO/c5ababc31ef9dc7c011efaea0a770284/20120608133256029.png", "ListBrokerageName":"RE/MAX Results", "ListBrokeragePhone":"(314) 781-7777", "ListBrokeragePostalCode":"63131", "ListBrokerageStateOrProvince":"MO", "ListBrokerageUnitNumber":null, "ListBrokerageUnparsedAddress":"11819 Manchester Road", "ListBrokerageWebsiteUrl":"http://www.homestlouis.com", "ListOfficeAddress1":"4850 Lemay Ferry Rd Ste 100", "ListOfficeAddress2":null, "ListOfficeBrokerMlsId":"SANDYH", "ListOfficeCity":"Saint Louis", "ListOfficeCountry":"US", "ListOfficeEmail":"dtownsend@remax-results.com", "ListOfficePostalCode":"63129", "ListOfficeStateOrProvince":"MO", "ListPriceCurrencyType":"USD", "ListingTitle":"Single Family Residence, Contemporary, Traditional - Lake St Louis, MO", "ListingURL":"https://www.realtor.com/realestateandhomes-detail/417-Hamlet-Ct_Lake-St-Louis_MO_63367_M79214-57263?f=listhub&s=MARISMO&m=25005169&c=rexren", "MLSModificationTimestamp":"2025-05-13T13:31:38Z", "Neighborhoods":[{"Description":null, "Name":"417 - Wentzville-Liberty"}], "PostalCode":null, "RawPropertySubType":"Single Family Residence", "RawPropertyType":"Residential", "RoomCount":21, "StateOrProvince":null, "Taxes":[{"TaxAnnualAmount":10893, "TaxDescription":null, "TaxYear":"2024"}], "UnitNumber":null, "UnparsedAddress":null}
Listing Changed: 5/13/2025 8:33:03 PM GMT
Source Updated Date: 5/18/2025 6:48:45 AM GMT

Courtesy of: Sarah Nguyen-Bani , RE/MAX Results, sarahsellstl@gmail.com

Copyright 漏 2025 MARIS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.

Contact