$1,570,000
SOLD JUL 14, 2025
Last list price

417 Hamlet Ct Lake Saint Louis, MO 63367

4 Beds
3.5 Baths
5,791 Sq Ft
0.34 Acres

Recently Sold

$271 Per Sq Ft

55 Days on Market

Highlights

  • Pool House
  • Second Garage
  • Open Floorplan
  • Frontier Middle School Rated A-
  • Sauna
  • Deck

About This Home

As of July 2025

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 Agent to Sell the Property

Sarah Nguyen-Bani

RE/MAX Results License #2002004718 Listed on: 05/08/2025

RE/MAX Results

Last Buyer's Agent

Tracy Raspberry

Keller Williams Chesterfield License #2002029512

Keller Williams Chesterfield

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $10,893

Year Built

  • Built in 2017 | Remodeled

Lot Details

  • 0.34 Acre Lot
  • Front and Back Yard Sprinklers

HOA Fees

  • $92 Monthly HOA Fees

Parking

  • 5 Car Garage
  • Second Garage
  • Garage Door Opener
  • Additional Parking
  • Off-Street Parking

Home Design

  • Contemporary Architecture
  • Traditional Architecture
  • Brick Veneer

Interior Spaces

  • 2-Story Property
  • Open Floorplan
  • Vaulted Ceiling
  • Window Treatments
  • Panel Doors
  • Mud Room
  • Great Room
  • Breakfast Room
  • Formal Dining Room
  • Home Office
  • Recreation Room with Fireplace
  • Bonus Room
  • Storage Room
  • Laundry Room
  • Sauna
  • Home Gym

Kitchen

  • Walk-In Pantry
  • Built-In Double Oven
  • Gas Cooktop
  • Range Hood
  • Microwave
  • Ice Maker
  • Dishwasher
  • Stainless Steel Appliances
  • Kitchen Island
  • Solid Surface Countertops
  • Disposal

Flooring

  • Carpet
  • Concrete
  • Luxury Vinyl Plank Tile

Bedrooms and Bathrooms

  • Walk-In Closet
  • Double Vanity
  • Separate Shower

Partially Finished Basement

  • Walk-Out Basement
  • 9 Foot Basement Ceiling Height
  • Finished Basement Bathroom

Home Security

  • Security System Leased
  • Fire and Smoke Detector

Pool

  • Pool House
  • In Ground Pool

Outdoor Features

  • Deck
  • Patio

Schools

  • Prairie View Elem. Elementary School
  • Frontier Middle School
  • Liberty High School

Utilities

  • Humidifier
  • Forced Air Heating and Cooling System
  • Dual Heating Fuel
  • Heating System Uses Natural Gas
  • Gas Water Heater

Community Details

  • Built by Lombardo Homes

Listing and Financial Details

  • Assessor Parcel Number 4-0067-C582-00-0034.0000000

Home Details

Home Type

Single Family

Est. Annual Taxes

$10,893

Year Built

Built in 2017 | Remodeled

Lot Details

0

HOA Fees

$92 per month

Parking

5

Listing Details

  • Property Type: Residential
  • Year Built: 2017
  • Directions: GPS friendly
  • Property Sub-Type: Single Family Residence
  • ResoLotFeatures: Adjoins Common Ground, Sprinklers In Front, Sprinklers In Rear
  • Lot Size Acres: 0.3401
  • Road Surface Type: Aggregate
  • ResoSecurityFeatures: Security System Leased, Smoke Detector(s)
  • Co List Office Phone: 314-8948775
  • MLS Status: Closed
  • Subdivision Name: Vlgs At Shady Creek #4
  • Above Grade Finished Sq Ft: 3991
  • Architectural Style: Contemporary, Traditional, Other
  • Carport Y N: No
  • Reso Fireplace Features: Recreation Room
  • Unit Levels: Two
  • New Construction: No
  • ResoPropertyCondition: Updated/Remodeled
  • MIS_RoomFlooring: Luxury Vinyl Plank
  • MIS_AboveGradeFinishedAreaSrchSqFt: 3991.00
  • MIS_RoomFlooring: Luxury Vinyl Plank
  • MIS_RoomFlooring: Luxury Vinyl Plank
  • MIS_RoomFlooring: Luxury Vinyl Plank
  • MIS_RoomFlooring: Luxury Vinyl Plank
  • MIS_SellerConsiderConcessionYN: 0
  • MIS_RoomWindowCoverings: Some
  • MIS_RoomWindowCoverings: Some
  • MIS_RoomWindowCoverings: Some
  • MIS_RoomWindowCoverings: Some
  • MIS_RoomWindowCoverings: None
  • MIS_RoomFlooring: Luxury Vinyl Plank
  • MIS_RoomWindowCoverings: Some
  • MIS_RoomFlooring: Luxury Vinyl Plank
  • MIS_RoomWindowCoverings: Some
  • MIS_RoomFlooring: Luxury Vinyl Plank
  • MIS_RoomWindowCoverings: None
  • MIS_RoomFlooring: Luxury Vinyl Plank
  • MIS_RoomWindowCoverings: None
  • MIS_PoolYN: 1
  • MIS_UnitCount: 0
  • MIS_BelowGradeFinishedAreaSrchSqFt: 1800.00
  • MIS_RoomFlooring: Carpeting
  • MIS_RoomWindowCoverings: Some
  • MIS_RoomFlooring: Carpeting
  • MIS_RoomWindowCoverings: Some
  • MIS_RoomWindowCoverings: Some
  • MIS_RoomFlooring: Carpeting
  • MIS_RoomFlooring: Luxury Vinyl Plank
  • MIS_RoomFlooring: Luxury Vinyl Plank
  • MIS_RoomWindowCoverings: Some
  • MIS_RoomWindowCoverings: Some
  • MIS_RoomFlooring: Concrete
  • MIS_RoomFlooring: Other
  • MIS_RoomFlooring: Other
  • MIS_RoomWindowCoverings: None
  • MIS_RoomWindowCoverings: Some
  • MIS_RoomWindowCoverings: None
  • Special Features: VirtualTour
  • Property Sub Type: Detached

Interior Features

  • Basement: 9 ft + Pour, Bathroom, Partially Finished, Concrete, Walk-Out Access
  • Interior Amenities: 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
  • Appliances: Dishwasher, Disposal, Double Oven, Gas Cooktop, Ice Maker, Microwave, Range Hood, Refrigerator, Stainless Steel Appliance(s), Wall Oven, Humidifier, Gas Water Heater
  • Basement YN: Yes
  • Full Bathrooms: 3
  • Half Bathrooms: 1
  • Total Bedrooms: 4
  • Below Grade Sq Ft: 1800
  • Door Features: Panel Door(s)
  • Fireplaces: 1
  • Fireplace: Yes
  • Flooring: Carpet
  • MIS_LowerLevelBathroomsFull: 1
  • MIS_LowerLevelBathroomsHalf: 0
  • MIS_LowerLevelBedrooms: 1
  • MIS_MainLevelBathroomsFull: 0
  • MIS_MainLevelBathroomsHalf: 1
  • MIS_UpperLevelBathroomsFull: 2
  • MIS_UpperLevelBathroomsHalf: 0
  • MIS_UpperLevelBedrooms: 3

Exterior Features

  • Pool Features: Private, In Ground
  • Pool Private: Yes
  • Waterfront: No
  • Disclosures: Unknown, Flood Plain No
  • Builder Name: Lombardo Homes
  • Construction Type: Stone Veneer, Brick Veneer
  • Other Structures: Pool House, Second Garage
  • Patio And Porch Features: Deck, Composite, Patio

Garage/Parking

  • Garage Spaces: 5
  • Attached Garage: Yes
  • Attached Garage: Yes
  • Parking Features: Additional Parking, Attached, Detached, Garage, Garage Door Opener, Off Street
  • Total Parking Spaces: 5

Utilities

  • Sewer: Public Sewer
  • Cooling: Central Air, Electric
  • Heating: Dual Fuel/Off Peak, Forced Air, Natural Gas
  • Utilities: Natural Gas Available
  • Water Source: Public

Condo/Co-op/Association

  • Association Fee: 1100
  • Association Fee Frequency: Annually

Fee Information

  • Association Fee Includes: Other

Schools

  • Elementary School: Prairie View Elem.
  • Junior High Dist: Wentzville R-IV
  • High School: Liberty
  • Middle Or Junior School: Frontier Middle

Lot Info

  • Lot Dimensions: see Realist
  • Lot Size Sq Ft: 14815
  • ResoLotSizeUnits: Acres
  • Parcel Number: 4-0067-C582-00-0034.0000000

Tax Info

  • Tax Year: 2024
  • Tax Annual Amount: 10893

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
May 8, 2025
Closed on
Jul 9, 2025
Sold by
Badolato Sharon M and Badolato Randy B
Bought by
Ijioma Ndubuisi and Ijioma Chika
Seller's Agent
Sarah Nguyen-Bani
RE/MAX Results
Buyer's Agent
Tracy Raspberry
Keller Williams Chesterfield
List Price
$1,590,000
Views
153

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
68.89%
Original Mortgage
$1,115,000
Outstanding Balance
$1,114,051
Interest Rate
6.81%
Mortgage Type
New Conventional
Estimated Equity
$416,406

Purchase Details

Closed on
Jun 7, 2018
Sold by
Lombardo Homes Of St Louis Llc
Bought by
Badolato Randy B and Badolato Sharon M

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$505,571
Interest Rate
4.5%
Mortgage Type
Adjustable Rate Mortgage/ARM
Source: Public Records

Range of Values:

Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Purchase History

Date Type Sale Price Title Company
Warranty Deed -- Freedom Title
Warranty Deed $789,648 Synergy Title
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Open $1,115,000 New Conventional
Previous Owner $200,000 Credit Line Revolving
Previous Owner $600,000 Credit Line Revolving
Previous Owner $393,000 New Conventional
Previous Owner $400,000 New Conventional
Previous Owner $505,571 Adjustable Rate Mortgage/ARM
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
07/14/2025 07/14/25 Sold -- -- --
07/02/2025 07/02/25 Pending -- -- --
05/23/2025 05/23/25 Price Changed $1,570,000 -1.3% $271 / Sq Ft
05/08/2025 05/08/25 For Sale $1,590,000 -- $275 / Sq Ft
01/31/2025 01/31/25 Off Market -- -- --
Source: MARIS MLS

Tax History Compared to Growth

Source: Public Records

Tax History

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2025 $10,893 $166,328 -- --
2023 $10,902 $160,060 $0 $0
2022 $13,933 $191,003 $0 $0
2021 $11,569 $158,135 $0 $0
2020 $11,440 $150,033 $0 $0
2019 $10,735 $150,033 $0 $0
2018 $5,940 $7,600 $0 $0
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: MARIS MLS

MLS Number: MIS25005169

MARIS MLS

APN: T182000132