Active
29 Haymarket Square, Amherst NY 14051
MLS# B1690727
$450,000
Price
3
Beds
3
Baths
1,841
Living Area (Sq.Ft.)
0.39
Lot Area (Acres)
$450,000
Price
3
Beds
3
Baths
1,841
Living Area (Sq.Ft.)
0.39
Lot Area (Acres)
Value Range Pricing- Owner will consider offers between $450,000-$525,000 or higher. Showings are limited to 3 days. Craftsmanship, luxury finishes, and meticulous attention to detail define this one-of-a-kind ranch home, perfectly positioned on a quiet cul-de-sac within one of the area’s most desirable school districts. Step inside to a foyer accented with imported tile that is also found through the custom gourmet kitchen and beautifully updated bathrooms. The kitchen is a true centerpiece—featuring an oversized granite island, high-end appliances, pot-filler, dedicated wet-bar/coffee area with wine cooler, and layered lighting including under-cabinet, toe-kick, and multiple dimmer zones to set the perfect ambiance. The seating area’s wood-burning fireplace has floor-to-ceiling brick that adds warmth and character. An elegantly modern powder room is finished with crown molding, leaded glass, and a sliding barn door. The open floor plan comprises a full formal dining room. <br>The primary suite offers a peaceful retreat with a custom tile shower, body sprays, cherry cabinetry, granite countertop, and walk-in closet. A second full bathroom with full tub showcases a marble finished shower and granite, while natural light highlights the hardwood floors throughout all three bedrooms. <br>The full basement expands your living possibilities with a partially finished area, second working kitchen, updated laundry zone, custom elevated pet-spa, new interior drainage system, sump pump, upgraded electrical, and an impressive amount of storage. <br>Outside, the private, fully landscaped property offers a serene setting for entertaining—complete with space for dining, lounging, and enjoying evenings around the fire pit under the stars. An attached two-car garage and storage shed complete this move-in-ready property. <br>Showings for pre-qualified buyers from Friday, June 19 through Sunday, June 21, 2026. Offers reviewed at 10:00 AM on 6/22/26.
Status
Active
Property Type
Residential
Property Sub Type
SingleFamilyResidence
Year Built
1975
Parcel Number
142289-042-200-0002-018-000
Unit Number
--
Lot Features
Irregular Lot, Residential Lot
Levels
One
Building Area Source
PublicRecords
Lot Size Dimensions
98X174
Stories
1
Bath Rooms Full
2
Bath Rooms Half
1
Main Level Bathrooms
3
Main Level Bedrooms
3
Property Condition
Resale
Elementary School District
Williamsville
Middle Or Junior School District
Williamsville
High School District
Williamsville
Location
Listing Agent
Joseph A Trifilo
Listing Office
HUNT Real Estate Corporation
Owner Name
--
Owner Phone
--
Possession
CloseOfEscrow
Special Listing Conditions
Standard
Listing Terms
Cash, Conventional, F H A, Va Loan
Listing Agreement
ExclusiveRightToSell
Listing Contract Date
2026-06-15
Fire Places Total
1
Interior Features
Separate Formal Dining Room, Eat In Kitchen, Separate Formal Living Room, Granite Counters, Main Level Primary
Flooring
Carpet, Ceramic Tile, Hardwood, Marble, Varies
Laundry Features
In Basement
Fire Place
true
Cooling
true
Cooling Features
CentralAir
Heating
true
Heating Features
Gas, Forced Air
Accessibility Features
Other
Appliances
Appliances Negotiable, Dryer, Dishwasher, Exhaust Fan, Free Standing Range, Disposal, Gas Oven, Gas Range, Gas Water Heater, Microwave, Oven, Refrigerator, Range Hood, Washer
Security Features
SecuritySystemOwned
Electric
Circuit Breakers
Garage
true
Garage Spaces
2
Architectural Style
Ranch
Exterior Features
Concrete Driveway
Water Source
Connected, Public
Sewer
Connected
Roof
Asphalt
Other Structures
Sheds,Storage
Utilities
Electricity Connected, Sewer Connected, Water Connected
Parking Features
Attached, Garage
Attached Garage
true
Foundation Details
Poured
Basement
Full, Sump Pump
Construction Materials
Brick, Other, Vinyl Siding
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.
Listed By
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.