Step into this pristine self-built raised ranch in the heart of Frewsburg. The home features 2 bedrooms with the potential for a third, offering ample space for a family or guests. Situated on just over 5 acres, this property provides breathtaking views. Approximately 4 acres of the land is wooded, making it ideal for outdoor adventurers. Impeccable drainage surrounds the home, ensuring the land remains pristine and well-maintained. For added convenience, the garage is located under the home, making it easy to access in all weather conditions. An outstanding feature of this property is the finished basement, offering over 500 square feet of additional living space. This area includes: large family room, bonus room could be tailored to a bedroom or office and a laundry room equipped with a half bath, 2-year gas hot water boiler and 2011 boiler mate ensuring efficient and reliable service. Leading to the first level, you are welcomed into a stunning living room boasting cathedral tongue-and-groove knotty pine ceilings, this room is flooded with natural light from custom windows and skylights. The kitchen and dining room combo offer a cottage feel, perfect for intimate meals and entertaining friends. Extra closet space down the hall with two well-sized bedrooms and full bath. This home, filled with love and care, is truly turnkey for the next lucky owner.
For sale
$259,900
123 Water St, Frewsburg, NY 14738
2beds
952sqft
Single Family Residence
Built in 1992
5.17 Acres Lot
$-- Zestimate®
$273/sqft
$-- HOA
What's special
- 7 days
- on Zillow |
- 732 |
- 28 |
Zillow last checked: 7 hours ago
Listing updated: July 15, 2025 at 02:56pm
Listing by:
Real Estate Advantage 716-484-2020,
Alecia Spontaneo 716-450-9227
Source: NYSAMLSs,MLS#: R1621818
Originating MLS: Chautauqua-Cattaraugus

Travel times
Tour with a buyer's agent
Tour with a buyer's agent
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 2
- Bathrooms: 2
- Full bathrooms: 1
- 1/2 bathrooms: 1
- Main level bathrooms: 1
- Main level bedrooms: 2
Bedroom 1
- Level: First
- Dimensions: 12.00 x 10.00
Bedroom 2
- Level: First
- Dimensions: 12.00 x 9.00
Den
- Level: Basement
- Dimensions: 12.00 x 10.00
Family room
- Level: Basement
- Dimensions: 21.00 x 12.00
Kitchen
- Level: First
- Dimensions: 17.00 x 8.00
Laundry
- Level: Basement
- Dimensions: 13.00 x 9.00
Living room
- Level: First
- Dimensions: 22.00 x 17.00
Workshop
- Level: Basement
- Dimensions: 22.00 x 13.00
Heating
- Gas, Forced Air
Appliances
- Included: Dryer, Dishwasher, Gas Oven, Gas Range, Gas Water Heater, Microwave, Refrigerator, Washer
- Laundry: In Basement
Features
- Ceiling Fan(s), Cathedral Ceiling(s), Eat-in Kitchen, Living/Dining Room, Sliding Glass Door(s), Solid Surface Counters, Skylights, Window Treatments, Bedroom on Main Level, Workshop
- Flooring: Carpet, Tile, Varies
- Doors: Sliding Doors
- Windows: Drapes, Skylight(s), Thermal Windows
- Basement: Finished,Walk-Out Access
- Number of fireplaces: 1
Interior area
- Total structure area: 952
- Total interior livable area: 952 sqft
Video & virtual tour
Property
Parking
- Total spaces: 1
- Parking features: Underground, Electricity, Garage Door Opener
- Garage spaces: 1
Features
- Levels: One
- Stories: 1
- Patio & porch: Balcony, Covered, Porch
- Exterior features: Balcony, Gravel Driveway
Lot
- Size: 5.17 Acres
- Dimensions: 125 x 288
- Features: Agricultural, Irregular Lot, Rural Lot
Details
- Additional structures: Shed(s), Storage
- Additional parcels included: 062400423.00225
- Parcel number: 0624004230000002026000
- Special conditions: Standard
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Raised Ranch
- Property subtype: Single Family Residence
Materials
- Brick, Vinyl Siding, PEX Plumbing
- Foundation: Poured
- Roof: Asphalt
Condition
- Resale
- Year built: 1992
Utilities & green energy
- Electric: Circuit Breakers
- Sewer: Septic Tank
- Water: Connected, Public
- Utilities for property: High Speed Internet Available, Water Connected
Community & HOA
Location
- Region: Frewsburg
Financial & listing details
- Price per square foot: $273/sqft
- Tax assessed value: $90,000
- Annual tax amount: $3,972
- Date on market: 7/15/2025
- Listing terms: Cash,Conventional,FHA,VA Loan
- Loading
- Loading