Appointed, pristine, and well-maintained custom-built home situated in a prestigious cul-de-sac. This home offers 4/5 bedrooms and 2.5 bathrooms. Grand and inviting two-story foyer. The main level includes a den with elegant French doors. Open dining room. Family room adorned with stately columns, a convenient closet for games, and a cozy gas fireplace. The custom kitchen is a chef's delight, boasting an oversized island, beautiful cherry cabinets, granite countertops, and refined crown molding. It is finished with ceramic tile flooring and is equipped with a built-in electric oven and microwave, as well as a gas stove with a gas oven. A large eat-in area provides abundant natural light. The kitchen also features a built-in wet bar with a beverage refrigerator, a walk-in pantry, and a first-floor laundry room. Custom cubby/locker system. Bullnose staircase leads to the second floor. Primary bedroom awaits with luxury vinyl flooring, two walk-in closets, and an ensuite bathroom. The ensuite includes a tub, a separate large shower, double sinks, a linen closet, and a private commode. Additionally, there are three generously sized bedrooms with large closets, and a fifth bedroom or bonus room located above the garage. The second full bathroom on this level offers double sinks and an additional makeup counter, complemented by two linen closets in the hall. The property features a two-car attached garage and an additional one-car attached garage. The full basement is finished and includes separate storage rooms. All mechanical systems are original from 2010. The basement also provides a separate walk-out access to the garage. Outdoor amenities include a covered patio perfect for entertaining, a beautifully landscaped private fenced-in yard, and a 2016, 27-foot round above-ground pool with an accompanying deck. This exquisite home was built by Sparks Custom Homes. Tax records indicate 2712 sq ft. Appraisal square footage is 3905 which includes a bonus room above the garage. Sellers request an offer deadline of Thursday, August 7th at 1pm. Highest & best. No escalation clauses.
Pending
$524,900
5 Kingston Cir, Lockport, NY 14094
5beds
3,905sqft
Single Family Residence
Built in 2010
0.55 Acres Lot
$-- Zestimate®
$134/sqft
$-- HOA
What's special
Private commodeCozy gas fireplaceEnsuite bathroomTwo-car attached garageOne-car attached garageCovered patioOversized island
- 11 days
- on Zillow |
- 3,941 |
- 147 |
Zillow last checked: 7 hours ago
Listing updated: August 08, 2025 at 02:57pm
Listing by:
HUNT Real Estate Corporation 716-434-6266,
Kathleen M DiMillo 716-622-0530,
Liliya Dedovets 716-799-3582,
HUNT Real Estate Corporation
Source: NYSAMLSs,MLS#: B1628163
Originating MLS: Buffalo

Travel times
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 5
- Bathrooms: 3
- Full bathrooms: 2
- 1/2 bathrooms: 1
- Main level bathrooms: 1
Bedroom 1
- Level: Second
- Dimensions: 18.00 x 16.00
Bedroom 2
- Level: Second
- Dimensions: 20.00 x 11.00
Bedroom 3
- Level: Second
- Dimensions: 12.00 x 12.00
Bedroom 4
- Level: Second
- Dimensions: 12.00 x 12.00
Bedroom 5
- Level: Second
- Dimensions: 12.00 x 12.00
Den
- Level: First
- Dimensions: 12.00 x 10.00
Dining room
- Level: First
- Dimensions: 12.00 x 12.00
Family room
- Level: First
- Dimensions: 21.00 x 16.00
Kitchen
- Level: First
- Dimensions: 22.00 x 13.00
Laundry
- Level: First
Living room
- Level: First
Other
- Level: First
- Dimensions: 13.00 x 10.00
Heating
- Gas, Forced Air
Cooling
- Central Air
Appliances
- Included: Built-In Range, Built-In Oven, Dishwasher, Electric Oven, Electric Range, Gas Cooktop, Disposal, Gas Oven, Gas Range, Gas Water Heater, Microwave, Refrigerator
- Laundry: Main Level
Features
- Breakfast Bar, Ceiling Fan(s), Central Vacuum, Separate/Formal Dining Room, Entrance Foyer, Eat-in Kitchen, Separate/Formal Living Room, Pantry, Natural Woodwork
- Flooring: Carpet, Ceramic Tile, Hardwood, Laminate, Luxury Vinyl, Varies
- Basement: Full,Sump Pump
- Number of fireplaces: 1
Interior area
- Total structure area: 3,905
- Total interior livable area: 3,905 sqft
Video & virtual tour
Property
Parking
- Total spaces: 3
- Parking features: Attached, Garage, Driveway, Garage Door Opener, Other
- Attached garage spaces: 3
Features
- Levels: Two
- Stories: 2
- Patio & porch: Covered, Patio, Porch
- Exterior features: Concrete Driveway, Fully Fenced, Pool, Patio
- Pool features: Above Ground
- Fencing: Full
Lot
- Size: 0.55 Acres
- Dimensions: 100 x 237
- Features: Cul-De-Sac, Rectangular, Rectangular Lot, Residential Lot
Details
- Parcel number: 2909001230100002006212
- Special conditions: Standard
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Two Story
- Property subtype: Single Family Residence
Materials
- Stone, Vinyl Siding, Copper Plumbing
- Foundation: Poured
- Roof: Asphalt
Condition
- Resale
- Year built: 2010
Details
- Builder model: Sparks Custom Homes
Utilities & green energy
- Electric: Circuit Breakers
- Sewer: Connected
- Water: Connected, Public
- Utilities for property: Cable Available, High Speed Internet Available, Sewer Connected, Water Connected
Community & HOA
Community
- Security: Security System Owned
- Subdivision: Holland Land Companys Lan
Location
- Region: Lockport
Financial & listing details
- Price per square foot: $134/sqft
- Tax assessed value: $407,000
- Annual tax amount: $12,334
- Date on market: 8/5/2025
- Listing terms: Cash,Conventional,FHA,VA Loan
- Loading