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. Seller reserves the right to set an offer deadline.
Pending
$599,000
6790 Gowanda State Rd, Hamburg, NY 14075
4beds
4,860sqft
Single Family Residence
Built in 1947
1.1 Acres Lot
$-- Zestimate®
$123/sqft
$-- HOA
What's special
First-floor in-law type suiteCharming cape codAttached heated two-car-plus garageGas stovePicturesque one-acre lotOpen floor planLaundry room
- 86 days
- 274
- 6
Zillow last checked:
Listing updated:
Listed by:
HUNT Real Estate ERA 716-648-2300,
Carol Lee Rubeck 716-308-3003
Source: NYSAMLSs,MLS#: B1694473
Originating MLS: Buffalo
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 2
- Full bathrooms: 2
- Main level bathrooms: 2
- Main level bedrooms: 4
Heating
- Gas, Forced Air
Cooling
- Central Air
Appliances
- Included: Dishwasher, Exhaust Fan, Gas Water Heater, Microwave, Range Hood
- Laundry: In Basement, Main Level
Features
- Breakfast Bar, Ceiling Fan(s), Cathedral Ceiling(s), 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
- Basement: Full,Finished
- Attic: Pull Down Stairs
- Number of fireplaces: 1
Interior area
- Total structure area: 4,860
- Total interior livable area: 4,860 sqft
Video & virtual tour
Property
Parking
- Total spaces: 2.5
- Parking features: Attached, Electricity, Garage, Heated Garage, Circular Driveway, Driveway, Garage Door Opener, Other
- Attached garage spaces: 2.5
Accessibility
- Accessibility features: No Stairs, Accessible Approach with Ramp, Accessible Doors
Features
- Patio & porch: Deck
- Exterior features: Blacktop Driveway, Deck, Fence, Private Yard, See Remarks
- Fencing: Partial
Lot
- Size: 1.1 Acres
- Dimensions: 105 x 495
- Features: Agricultural, Rectangular, Rectangular Lot
Details
- Additional structures: Guest House, Other, Shed(s), Storage
- Parcel number: 1448891951900003013000
- Special conditions: Standard
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Cape Cod,Contemporary,Ranch
- Property subtype: Single Family Residence
Materials
- Spray Foam Insulation, Vinyl Siding, Copper Plumbing, PEX Plumbing
- Foundation: Block, Poured
- Roof: Asphalt,Shingle
Condition
- Resale
- Year built: 1947
Utilities & green energy
- Electric: Circuit Breakers
- Sewer: Septic Tank
- Water: Connected, Public
- Utilities for property: Cable Available, High Speed Internet Available, Water Connected
Green energy
- Energy efficient items: Windows
Community & HOA
Community
- Subdivision: Water Valley
Location
- Region: Hamburg
Financial & listing details
- Price per square foot: $123/sqft
- Tax assessed value: $227,600
- Date on market: 7/2/2026
- Cumulative days on market: 68 days
- Listing terms: Cash,Conventional
Estimated market value
Not available
Estimated sales range
Not available
Not available
Price history
| Date | Event | Price |
|---|---|---|
| 8/25/2026 | Pending sale | $599,000$123/sqft |
Source: | ||
| 8/12/2026 | Listed for sale | $599,000$123/sqft |
Source: | ||
| 8/12/2026 | Contingent | $599,000$123/sqft |
Source: | ||
| 7/2/2026 | Listed for sale | $599,000+199.6%$123/sqft |
Source: | ||
| 5/1/2014 | Listing removed | $199,900$41/sqft |
Source: RealtyUSA #441318 Report a problem | ||
| 11/1/2013 | Listed for sale | $199,900$41/sqft |
Source: RealtyUSA #441318 Report a problem | ||
| 9/18/2013 | Listing removed | $199,900$41/sqft |
Source: RealtyUSA #416668 Report a problem | ||
| 8/1/2013 | Price change | $199,900-25.9%$41/sqft |
Source: RealtyUSA #416668 Report a problem | ||
| 7/9/2013 | Price change | $269,900-9.7%$56/sqft |
Source: RealtyUSA #416668 Report a problem | ||
| 6/11/2013 | Price change | $299,000-8%$62/sqft |
Source: RealtyUSA #416668 Report a problem | ||
| 4/22/2013 | Listed for sale | $325,000$67/sqft |
Source: Realty USA #416668 Report a problem | ||
| 7/3/2012 | Listing removed | $325,000$67/sqft |
Source: Realty USA #386507 Report a problem | ||
| 5/25/2011 | Listed for sale | $325,000$67/sqft |
Source: Realty USA #386507 Report a problem | ||
Public tax history
Tax history is unavailable.
Monthly payment
Climate risks
Neighborhood: 14075
Nearby schools
Schools provided by the listing agent
- District: Hamburg
Source: NYSAMLSs. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.




