Active
MLS# B1710734
$799,900
Price
5
Beds
3
Baths
3,216
Living Area (Sq.Ft.)
2.07
Lot Area (Acres)
$799,900
Price
5
Beds
3
Baths
3,216
Living Area (Sq.Ft.)
2.07
Lot Area (Acres)
This gorgeous custom-built craftsman home, situated on over two acres, located in the Hamburg school district & minutes to the village of Hamburg, combines stunning curb appeal with beautiful landscaping & a welcoming covered front porch, and offers an exceptional blend of rural tranquility and modern suburban convenience. The open-concept interior boasts a chef's kitchen with a double stove, oak cabinets, granite countertops, island and a breakfast bar, and flows seamlessly into a bright great room featuring an 18-foot ceiling, hardwood floors, and a striking stone fireplace. High-end details such as plantation shutters, built-in shelving, and tray ceilings run throughout the property. The first floor includes a primary suite with a full bath and walk-in closet, a second bedroom, a guest full bath, an office, a laundry room, and a versatile bonus room leading to a rear patio. The upper level offers three additional bedrooms, a full bathroom, and a spacious loft area, while the full basement features nine-foot ceilings, a finished bedroom space, furnace, AC, tankless water heater, radon safety unit, and a whole-house air cleaning system. Outside, the park-like backyard provides privacy & ample space for recreation and entertaining, and is complemented by two separate patios & awning, plus a brick outbuilding shed, an attached 3.5-car garage, and an oversized concrete driveway. This home is spectacular and shows in every detail! Private showings start Wed Sep 2.
Status
Active
Property Type
Residential
Property Sub Type
SingleFamilyResidence
Year Built
2006
Parcel Number
144889-195-190-0004-001-000
Unit Number
1
Subdivision Name
Water Vly Preserve-Ph II
Lot Features
Cul De Sac, Irregular Lot, Residential Lot
Levels
Two
Building Area Source
PublicRecords
Lot Size Dimensions
258X351
Stories
2
Bath Rooms Full
3
Main Level Bathrooms
2
Main Level Bedrooms
2
Property Condition
Resale
Elementary School
Union Pleasant Avenue Elementary
Elementary School District
Hamburg
Middle Or Junior School
Hamburg Middle
Middle Or Junior School District
Hamburg
High School
Hamburg High
High School District
Hamburg
Location

Listing Agent
Wende Paas
Listing Office
WNY Metro Roberts Realty
Owner Name
--
Owner Phone
--
Possession
CloseOfEscrow
Special Listing Conditions
Standard
Listing Terms
Cash, Conventional, Usda Loan, Va Loan
Listing Agreement
ExclusiveRightToSell
Listing Contract Date
2026-08-29
Fire Places Total
1
Interior Features
Breakfast Bar, Ceiling Fans, Cathedral Ceilings, Den, Separate Formal Dining Room, Eat In Kitchen, Separate Formal Living Room, Granite Counters, Great Room, Kitchen Island, Kitchen Family Room Combo, Living Dining Room, Pantry, Skylights, Natural Woodwork, Convertible Bedroom, Loft, Bath In Primary Bedroom, Main Level Primary, Primary Suite, Programmable Thermostat
Flooring
Ceramic Tile, Hardwood, Varies
Laundry Features
Accessible Utilities Or Laundry, Main Level
Fire Place
true
Cooling
true
Cooling Features
CentralAir
Heating
true
Heating Features
Gas, Forced Air
Accessibility Features
Low Threshold Shower
Appliances
Double Oven, Dryer, Dishwasher, Exhaust Fan, Gas Cooktop, Disposal, Gas Water Heater, Microwave, Refrigerator, Range Hood, Washer
Security Features
RadonMitigationSystem
Electric
Circuit Breakers
Window Features
LeadedGlass,Skylights,ThermalWindows
Garage
true
Garage Spaces
3
Architectural Style
Colonial, Craftsman, Two Story
Exterior Features
Awnings, Concrete Driveway, Patio, Private Yard, See Remarks
Water Source
Connected, Public
Sewer
SepticTank
Roof
Architectural, Shingle
Other Structures
Sheds,Storage
Utilities
Cable Available, Electricity Connected, High Speed Internet Available, Water Connected
Parking Features
Attached, Electricity, Garage, Heated Garage, Storage, Driveway, Garage Door Opener
Attached Garage
true
Foundation Details
Poured
Basement
Full, Partially Finished, Sump Pump
Construction Materials
Brick, Other, Shake Siding, Vinyl Siding
Patio And Porch Features
Covered, Patio, Porch
Room Type
Room Area
Bedroom1
18.00 x 14.00
Bedroom2
15.00 x 11.00
Bedroom3
16.00 x 12.00
Bedroom4
16.00 x 13.00
Bedroom5
16.00 x 15.00
Other
17.00 x 13.00
Kitchen
19.00 x 14.00
DiningRoom
14.00 x 14.00
LivingRoom
18.00 x 18.00
Den
13.00 x 11.00
Loft
20.00 x 14.00
Laundry
10.00 x 6.00
Other
20.00 x 13.00

Information deemed reliable but not guaranteed. IDX data © 2019 REIS MLS. All rights reserved. The data relating to real estate for sale on this web site comes in part from the Broker Reciprocity Program of the REIS MLS. Real estate listings held by brokerage firms and are marked with the Broker Reciprocity logo or the Broker Reciprocity thumbnail logo (a little black house) and detailed information about them includes the name of the listing brokers. Realoq is not a Multiple Listing Service, nor does it offer MLS access. This website is a service of Realoq, a service company Participant of the REIS MLS. Information deemed reliable but not guaranteed. Data updated daily; data last updated .
Digital Millennium Copyright Act (DMCA) Notice
The Digital Millennium Copyright Act of 1998, 17 U.S.C. § 512 (the "DMCA"), provides recourse for copyright owners who believe that material appearing on the Internet infringes their rights under U.S. copyright law. If you believe in good faith that any content or material made available in connection with our website or services infringes your copyright, you (or your agent) may send us a notice requesting that the content or material be removed, or access to it blocked. Notices and counter-notices should be sent in writing by mail to DMCA Designated Agent.
The DMCA requires that your notice of alleged copyright infringement include the following information: (1) description of the copyrighted work that is the subject of claimed infringement; (2) description of the alleged infringing content and information sufficient to permit us to locate the content; (3) contact information for you, including your address, telephone number and e-mail address; (4) a statement by you that you have a good faith belief that the content in the manner complained of is not authorized by the copyright owner, or its agent, or by the operation of any law; (5) a statement by you, signed under penalty of perjury, that the information in the notification is accurate and that you have the authority to enforce the copyrights that are claimed to be infringed; and (6) a physical or electronic signature of the copyright owner or a person authorized to act on the copyright owner's behalf. Failure to include all of the above information may result in the delay of the processing of your complaint.

Information deemed reliable but not guaranteed. IDX data © 2019 REIS MLS. All rights reserved. The data relating to real estate for sale on this web site comes in part from the Broker Reciprocity Program of the REIS MLS. Real estate listings held by brokerage firms and are marked with the Broker Reciprocity logo or the Broker Reciprocity thumbnail logo (a little black house) and detailed information about them includes the name of the listing brokers. Realoq is not a Multiple Listing Service, nor does it offer MLS access. This website is a service of Realoq, a service company Participant of the REIS MLS. Information deemed reliable but not guaranteed. Data updated daily; data last updated .
Digital Millennium Copyright Act (DMCA) Notice
The Digital Millennium Copyright Act of 1998, 17 U.S.C. § 512 (the "DMCA"), provides recourse for copyright owners who believe that material appearing on the Internet infringes their rights under U.S. copyright law. If you believe in good faith that any content or material made available in connection with our website or services infringes your copyright, you (or your agent) may send us a notice requesting that the content or material be removed, or access to it blocked. Notices and counter-notices should be sent in writing by mail to DMCA Designated Agent.
The DMCA requires that your notice of alleged copyright infringement include the following information: (1) description of the copyrighted work that is the subject of claimed infringement; (2) description of the alleged infringing content and information sufficient to permit us to locate the content; (3) contact information for you, including your address, telephone number and e-mail address; (4) a statement by you that you have a good faith belief that the content in the manner complained of is not authorized by the copyright owner, or its agent, or by the operation of any law; (5) a statement by you, signed under penalty of perjury, that the information in the notification is accurate and that you have the authority to enforce the copyrights that are claimed to be infringed; and (6) a physical or electronic signature of the copyright owner or a person authorized to act on the copyright owner's behalf. Failure to include all of the above information may result in the delay of the processing of your complaint.