Open House
Active
MLS# B1623939
$259,900
Price
3
Beds
2
Baths
1,368
Living Area (Sq.Ft.)
0.252
Lot Area (Acres)
$259,900
Price
3
Beds
2
Baths
1,368
Living Area (Sq.Ft.)
0.252
Lot Area (Acres)
Wednesday, July 23, 2025
9:00 PM - 11:00 PM
Welcome to 3787 Yale Avenue! <br>Located in the heart of Hamburg, this charming and updated home is perfectly situated near shops, restaurants, and everyday conveniences. Move-in ready and thoughtfully maintained, it offers 3 bedrooms, 1.5 baths, and 1,368 square feet of comfortable living space. <br> <br>Enjoy the flexibility of single-floor living with two spacious bedrooms on the main level, complemented by beautifully refinished hardwood floors that flow through the bright and airy living room and bedrooms. The kitchen, hallway, and full bathroom feature cozy heated tile floors—perfect for keeping warm during the cooler months. <br> <br>Upstairs, you'll find a third bedroom along with a versatile bonus space—ideal for a home office, reading nook or extra closet space. One of the home’s standout features is the fully finished and insulated breezeway connecting the main house to the garage. With French doors leading to the backyard, this unique space can serve as a spacious mudroom or an additional living area. <br> <br>Recent updates include: <br> <br>Drain tile & gutters (2011) <br>Full tear-off roof (2013) <br>Kitchen & 1st-floor bathroom remodel (2015) <br>Breezeway finished & insulated (2015) <br>Electric panel & boiler (2018) <br>Hot water tank & gutter guards (2020) <br>Concrete driveway (2021) <br>Showings begin immediately. Offers due Monday, July 28th at 4:00 PM. Don’t miss the opportunity to make this well-cared-for home your own!
Status
Active
Property Type
Residential
Property Sub Type
SingleFamilyResidence
Year Built
1955
Parcel Number
144889-170-750-0002-003-000
Unit Number
--
Subdivision Name
Holland Land Companys Sur
Lot Features
Near Public Transit, Rectangular, Rectangular Lot, Residential Lot
Building Area Source
PublicRecords
Lot Size Dimensions
93X118
Bath Rooms Full
1
Bath Rooms Half
1
Main Level Bathrooms
1
Main Level Bedrooms
2
Property Condition
Resale
Elementary School
Big Tree Elementary
Elementary School District
Frontier
Middle Or Junior School
Frontier Middle
Middle Or Junior School District
Frontier
High School
Frontier Senior High
High School District
Frontier
Location
Listing Agent
Shannon Sherman
Listing Office
Buffalo Boardwalk Real Estate LLC
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
2025-07-21
Fire Places Total
1
Interior Features
Ceiling Fans, Entrance Foyer, Eat In Kitchen, Separate Formal Living Room, Kitchen Island, Natural Woodwork, Bedroom On Main Level, Programmable Thermostat
Flooring
Carpet, Hardwood, Laminate, Tile, Varies
Laundry Features
In Basement
Fire Place
true
Cooling Features
Zoned
Heating
true
Heating Features
Gas, Zoned, Baseboard, Radiant Floor
Appliances
Dryer, Dishwasher, Gas Oven, Gas Range, Gas Water Heater, Microwave, Refrigerator, Washer
Electric
Circuit Breakers
Garage
true
Garage Spaces
1
Architectural Style
Cape Cod
Exterior Features
Concrete Driveway, Patio
Water Source
Connected, Public
Sewer
Connected
Roof
Asphalt, Shingle
Other Structures
Sheds,Storage
Utilities
Cable Available, Electricity Connected, High Speed Internet Available, Sewer Connected, Water Connected
Parking Features
Attached, Electricity, Garage, Storage, Driveway, Garage Door Opener
Attached Garage
true
Foundation Details
Poured
Basement
Finished, Sump Pump
Construction Materials
Brick, Spray Foam Insulation, Vinyl Siding
Patio And Porch Features
Open, Patio, Porch
No schools found
Room Type
Room Area
Bedroom1
13.00 x 10.00
Bedroom2
9.00 x 10.00
Bedroom3
17.00 x 11.00
Kitchen
18.00 x 11.00
LivingRoom
20.00 x 10.00
Other
9.00 x 20.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 06/27/2025.
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 06/27/2025.
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.