- 4 beds
- 4 baths
- 5,291 sqft
- 10,890 sqft lot
- $107 per sqft
- 2005 build
- – on site
Experience luxury living at its finest in this spectacular executive-style residence, perfectly nestled on a premium lot overlooking a tranquil pond with fountain and picturesque wooded backdrop! This expansive and impeccably maintained home exudes sophistication from the moment you arrive. The heart of the home is a chef's dream kitchen, featuring 42-inch rich cherry cabinetry, gleaming granite countertops, custom tile backsplash, stainless steel appliances, pantry, and a spacious breakfast area that opens to a massive maintenance-free composite deck-the perfect spot to enjoy serene water views and breathtaking sunsets. The inviting family room offers warmth and elegance with its cozy gas-log fireplace, while the formal living and dining rooms provide the ideal setting for entertaining. A rare main-level office or fifth bedroom, paired with a full bathroom, offers the perfect setup for related living or a private guest retreat. The upper level showcases an oversized loft space, ideal for a second family room, home office, or study area. The luxurious primary suite features double-door entry, a custom walk-in closet, and a spa-like bath with soaker tub, separate shower, dual vanities, and private water closet. Bedrooms two and three share a Jack-and-Jill bath, and the spacious fourth bedroom includes a walk-in closet. The walk-out basement is a true showstopper-fully finished with a recreation room, custom bar with beverage fridge, dedicated workout area, playroom (or potential additional bedrooms), and a full bathroom. Step outside to your resort-style outdoor living space oasis, complete with a covered brick paver patio, outdoor island with built-in grills, ceiling fans, TV mount, gas fire pit, and exquisite landscaping that makes every day feel like a getaway. Additional highlights include six-panel doors throughout, a main-level laundry room with utility sink, 3-car attached garage with extra storage, and an unbeatable location near scenic park and popular downtown Lockport. An extraordinary home with unmatched living and entertaining spaces both inside and out-this is the one you've been waiting for!
Last checked:
As a licensed real estate brokerage, Estately has access to the same database professional Realtors use: the Multiple Listing Service (or MLS). That means we can display all the properties listed by other member brokerages of the local Association of Realtors—unless the seller has requested that the listing not be published or marketed online.
The MLS is widely considered to be the most authoritative, up-to-date, accurate, and complete source of real estate for-sale in the USA.
Estately updates this data as quickly as possible and shares as much information with our users as allowed by local rules. Estately can also email you updates when new homes come on the market that match your search, change price, or go under contract.
Checking…
•
Last updated Jun 29, 2025
•
MLS# 12397738 —
The Building
-
Year Built:2005
-
Rebuilt:No
-
New Construction:false
-
Construction Materials:Vinyl Siding, Brick
-
Model:LINCOLN II
-
Roof:Asphalt
-
Basement:Finished, Full, Walk-Out Access
-
Foundation Details:Concrete Perimeter
-
Exterior Features:Outdoor Grill, Fire Pit
-
Patio And Porch Features:Deck, Patio
-
Disability Access:No
-
Other Equipment:Water-Softener Owned, TV-Cable, Ceiling Fan(s)
-
Total SqFt:3778
-
Total SqFt:5291
-
Main SqFt:1632
-
Upper SqFt:2146
-
Basement SqFt:1513
-
Living Area Source:Builder
-
Window Features:Screens
Interior
-
Room Type:Office, Loft, Recreation Room, Play Room, Exercise Room
-
Rooms Total:13
-
Interior Features:Dry Bar, 1st Floor Bedroom, In-Law Floorplan, 1st Floor Full Bath, Walk-In Closet(s)
-
Fireplaces Total:1
-
Fireplace Features:Gas Log, Gas Starter
-
Fireplace Location:Family Room
-
Laundry Features:Main Level, Sink
Room Dimensions
-
Living Area:5291
Location
-
Directions:Briggs 2 Neuberry 2 Auburn Ridge 2 Quail Ridge 2 Sterling to Wilker
-
Location:28881
The Property
-
Parcel Number:1104264290510000
-
Property Type:Residential
-
Location:A
-
Lot Features:Cul-De-Sac, Landscaped, Wooded, Backs to Trees/Woods, Views
-
Lot Size Dimensions:135X96X125X77
-
Lot Size Acres:0.25
-
Waterfront:true
-
Additional Parcels:false
-
View:Water
-
Waterfront Features:Lake Front, Pond, Waterfront
Listing Agent
- Contact info:
- Agent phone:
- (708) 516-3050
- Office phone:
- (708) 516-3050
Taxes
-
Tax Year:2023
-
Tax Annual Amount:13035
Beds
-
Bedrooms Total:4
-
Bedrooms Possible:4
Baths
-
Baths:4
-
Full Baths:4
The Listing
-
Special Listing Conditions:None
Heating & Cooling
-
Heating:Natural Gas, Forced Air, Sep Heating Systems - 2+, Indv Controls, Zoned
-
Cooling:Central Air, Zoned
Utilities
-
Sewer:Public Sewer
-
Electric:Circuit Breakers
-
Water Source:Public
Appliances
-
Appliances:Range, Microwave, Dishwasher, Refrigerator, Washer, Dryer, Disposal, Stainless Steel Appliance(s), Humidifier
Schools
-
Elementary School District:90
-
Middle Or Junior School District:90
-
High School:Lockport Township High School
-
High School District:205
The Community
-
Community Features:Park, Pool, Tennis Court(s), Lake, Curbs, Sidewalks, Street Lights, Street Paved
-
Association Fee:500
-
Association Fee Includes:Other
-
Association Fee Frequency:Annually
-
Master Assoc Fee Frequency:Not Required
Parking
-
Parking Total:3
-
Parking Features:Garage Door Opener, On Site, Garage Owned, Attached, Garage
-
Garage Spaces:3
Monthly cost estimate

Asking price
$568,000
Expense | Monthly cost |
---|---|
Mortgage
This calculator is intended for planning and education purposes only. It relies on assumptions and information provided by you regarding your goals, expectations and financial situation, and should not be used as your sole source of information. The output of the tool is not a loan offer or solicitation, nor is it financial or legal advice. |
$3,041
|
Taxes | $1,086 |
Insurance | $156 |
HOA fees | $42 |
Utilities | $234 See report |
Total | $4,559/mo.* |
*This is an estimate |
Walk Score®
Provided by WalkScore® Inc.
Walk Score is the most well-known measure of walkability for any address. It is based on the distance to a variety of nearby services and pedestrian friendliness. Walk Scores range from 0 (Car-Dependent) to 100 (Walker’s Paradise).
Bike Score®
Provided by WalkScore® Inc.
Bike Score evaluates a location's bikeability. It is calculated by measuring bike infrastructure, hills, destinations and road connectivity, and the number of bike commuters. Bike Scores range from 0 (Somewhat Bikeable) to 100 (Biker’s Paradise).
Soundscore™
Provided by HowLoud
Soundscore is an overall score that accounts for traffic, airport activity, and local sources. A Soundscore rating is a number between 50 (very loud) and 100 (very quiet).
Air Pollution Index
Provided by ClearlyEnergy
The air pollution index is calculated by county or urban area using the past three years data. The index ranks the county or urban area on a scale of 0 (best) - 100 (worst) across the United Sates.
Sale history
Date | Event | Source | Price | % Change |
---|---|---|---|---|
6/28/25
Jun 28, 2025
|
Listed / Active | MRED | $568,000 | 60.0% (8.2% / YR) |
3/12/18
Mar 12, 2018
|
MRED | $355,000 |