Active
MLS# B1694473
$599,000
Price
4
Beds
2
Baths
4,860
Living Area (Sq.Ft.)
1.1
Lot Area (Acres)
$599,000
Price
4
Beds
2
Baths
4,860
Living Area (Sq.Ft.)
1.1
Lot Area (Acres)
One-of-a-Kind Opportunity! Nestled on a picturesque one-acre lot in Hamburg, this extraordinary property features two separate homes connected by a unique underground tunnel—ideal for today's multi-generational lifestyle. The stunning contemporary ranch features an open floor plan with a dramatic Great Room, vaulted ceiling, gas stove, beautiful kitchen, dining area, walk-in pantry, office, laundry room, three bedrooms, one a primary suite, two full baths, front and rear foyers, and an attached heated two-car-plus garage. Rich in history, this home was once a church. The lower level is now an massive recreation room with additional rooms off of it. There are two additional bathrooms, and a pool table that stays—perfect for entertaining, hobbies, a home business, or fitness. The second residence is an ideal Accessory Dwelling Unit (ADU) for extended family or guests. This charming Cape Cod has three bedrooms and two full baths, including a first-floor in-law type suite. The second floor was completely renovated two years ago with spray foam insulation, new drywall, two bedrooms, and a full bath. Enjoy the beautiful rear deck overlooking the backyard. There is also a fully fenced in section between the two homes. Zoned Residential Agricultural (not a legal two-family), this exceptional property offers incredible flexibility. Circular front driveway, expansive rear parking, and plenty of room for recreation—even a future tennis or pickleball court. A truly rare opportunity with endless possibilities! Front Home is 3100 Sq Ft per Bldr owner, 2nd home, Cape Cod is 1760 sq ft & per Town use is for In-Law, family, ADU use. Not to be rented for income. Tax records show 7898 Sq Ftg counting the two homes and basement in the front (church) that was an assembly hall with classrooms. Currently Tax Exempt. Showings begin 7/6/26 @ 10am. Seller reserves the right to set an offer deadline.
Status
Active
Property Type
Residential
Property Sub Type
SingleFamilyResidence
Year Built
1947
Parcel Number
144889-195-190-0003-013-000
Unit Number
--
Subdivision Name
Water Valley
Lot Features
Agricultural, Rectangular, Rectangular Lot
Building Area Source
SeeRemarks
Lot Size Dimensions
105X495
Bath Rooms Full
2
Main Level Bathrooms
2
Main Level Bedrooms
4
Property Condition
Resale
Elementary School District
Hamburg
Middle Or Junior School District
Hamburg
High School District
Hamburg
Location

Listing Agent
Carol Lee Rubeck
Listing Office
HUNT Real Estate Corporation
Owner Name
--
Owner Phone
--
Possession
CloseOfEscrow
Special Listing Conditions
Standard
Listing Terms
Cash, Conventional
Listing Agreement
ExclusiveRightToSell
Listing Contract Date
2026-07-02
Fire Places Total
1
Interior Features
Breakfast Bar, Ceiling Fans, Cathedral Ceilings, Den, Entrance Foyer, Eat In Kitchen, Great Room, Home Office, Kitchen Island, Kitchen Family Room Combo, Other, Pantry, Pull Down Attic Stairs, See Remarks, Storage, Walk In Pantry, Bedroom On Main Level, In Law Floorplan, Bath In Primary Bedroom, Main Level Primary, Primary Suite
Flooring
Carpet, Ceramic Tile, Laminate, Other, See Remarks, Varies
Laundry Features
In Basement, Main Level
Fire Place
true
Cooling
true
Cooling Features
CentralAir
Heating
true
Heating Features
Gas, Forced Air
Accessibility Features
No Stairs, Accessible Approach With Ramp, Accessible Doors
Appliances
Dishwasher, Exhaust Fan, Gas Water Heater, Microwave, Range Hood
Electric
Circuit Breakers
Garage
true
Garage Spaces
2.5
Architectural Style
Cape Cod, Contemporary, Ranch
Exterior Features
Blacktop Driveway, Deck, Fence, Private Yard, See Remarks
Water Source
Connected, Public
Sewer
SepticTank
Roof
Asphalt, Shingle
Other Structures
GuestHouse,Other,Sheds,Storage
Utilities
Cable Available, High Speed Internet Available, Water Connected
Parking Features
Attached, Electricity, Garage, Heated Garage, Circular Driveway, Driveway, Garage Door Opener, Other
Attached Garage
true
Foundation Details
Block,Poured
Basement
Full, Finished
Construction Materials
Spray Foam Insulation, Vinyl Siding, Copper Plumbing, Pex Plumbing
Fencing
Partial
Patio And Porch Features
Deck

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.