Spacious Riverfront Property with Endless Possibilities priced to go.
This rare opportunity is perfect for someone seeking substantial space, versatility, and a beautiful riverfront setting—all in one property.
When I toured this home I pictured a winery in the barn and the serving room taking part in the finished insulated room and a band playing music with the barn doors open as guest sat in a beautiful clean barn setting with original beams. With level entrance for both levels of the barn I can see a wedding venue in the huge yard. I can see the pictures being taken along the river or the landscaped yard. I can see guest enjoying the huge deck that runs the distance of the home. I could see the indoor space being used to cater their guests and look out the room of total window view. Wow it is just so beautiful. What can you envision?
Animal lovers will appreciate the existing barn and additional outdoor space of 15.12 acres. The barn also features a finished area that is insulated and walled that was started for an indoor driving range, offering a unique recreational opportunity.
This home can be a 5 bedroom 3 1/2 baths. The addition on the home was used as a business for years. This space features open floor and a huge room surrounded by windows to enjoy the manicured lawn and river view. The huge kitchen is of open concept with view from every window. Formal dining and entrance room. A bedroom and bath on the first floor of the original home. 4 fireplaces throughout the home.
Situated along the river, the property offers beautiful surroundings and a peaceful setting. The owner went above and beyond to work with FEMA regarding the property's flood designation, and the home has been released from the requirement for flood insurance. According to the owner, floodwater has never reached even near the home.
What a rare opportunity
Active
$470,000
5541 County Route 125, Campbell, NY 14821
5beds
5,840sqft
Single Family Residence
Built in 1870
15.12 Acres Lot
$-- Zestimate®
$80/sqft
$-- HOA
What's special
Riverfront settingExisting barnLandscaped yardEntrance roomHuge yardTotal window view
- 46 days
- 404
- 48
Zillow last checked:
Listing updated:
Listed by:
Warren Real Estate-Corning 607-936-2844,
Nancy Sterling nancysterlingrealestate@gmail.com
Source: NYSAMLSs,MLS#: R1713247
Originating MLS: Elmira Corning Regional Association Of REALTORS
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 5
- Bathrooms: 3
- Full bathrooms: 3
- Main level bathrooms: 1
- Main level bedrooms: 2
Heating
- Gas, Hot Water
Appliances
- Included: Dishwasher, Gas Cooktop, Gas Water Heater, Refrigerator
- Laundry: Upper Level
Features
- Breakfast Bar, Breakfast Area, Separate/Formal Dining Room, Entrance Foyer, Eat-in Kitchen, Great Room, Pantry, Bedroom on Main Level, Convertible Bedroom
- Flooring: Carpet, Varies
- Basement: Partial
- Has fireplace: No
Interior area
- Total structure area: 5,840
- Total interior livable area: 5,840 sqft
Property
Parking
- Parking features: No Garage, Driveway
Features
- Levels: Two
- Stories: 2
- Exterior features: Gravel Driveway
Lot
- Size: 15.12 Acres
- Dimensions: 1388 x 1700
- Features: Agricultural, Rectangular, Rectangular Lot
Details
- Parcel number: 4630002060000003004100
- Special conditions: Standard
- Horses can be raised: Yes
- Horse amenities: Horses Allowed
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Two Story
- Property subtype: Single Family Residence
Materials
- Vinyl Siding
- Foundation: Stone
Condition
- Resale
- Year built: 1870
Utilities & green energy
- Sewer: Septic Tank
- Water: Well
Community & HOA
Location
- Region: Campbell
Financial & listing details
- Price per square foot: $80/sqft
- Tax assessed value: $325,270
- Annual tax amount: $6,065
- Date on market: 9/28/2026
- Cumulative days on market: 14 days
- Listing terms: Cash,Conventional
Estimated market value
Not available
Estimated sales range
Not available
Not available
Price history
| Date | Event | Price |
|---|---|---|
| 9/28/2026 | Listed for sale | $470,000-5.1%$80/sqft |
Source: | ||
| 12/2/2025 | Listing removed | $495,000$85/sqft |
Source: | ||
| 10/14/2025 | Price change | $495,000-1%$85/sqft |
Source: | ||
| 10/1/2025 | Pending sale | $499,900$86/sqft |
Source: | ||
| 7/15/2025 | Listed for sale | $499,900-4.8%$86/sqft |
Source: | ||
| 6/10/2025 | Listing removed | $525,000$90/sqft |
Source: | ||
| 3/25/2025 | Listed for sale | $525,000$90/sqft |
Source: | ||
| 10/7/2024 | Listing removed | $525,000$90/sqft |
Source: | ||
| 7/9/2024 | Listed for sale | $525,000-12.4%$90/sqft |
Source: | ||
| 11/27/2023 | Listing removed | -- |
Source: | ||
| 8/29/2023 | Listed for sale | $599,000-4.2%$103/sqft |
Source: | ||
| 12/1/2021 | Listing removed | -- |
Source: | ||
| 8/12/2021 | Listed for sale | $625,000$107/sqft |
Source: ECMLS #263488 Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | -- | $240,700 |
| 2024 | -- | $240,700 |
| 2023 | -- | $240,700 |
| 2022 | -- | $240,700 |
| 2021 | -- | $240,700 -2% |
| 2020 | -- | $245,600 |
| 2019 | -- | $245,600 |
| 2018 | -- | $245,600 |
| 2017 | $7,046 | $245,600 |
| 2016 | -- | $245,600 |
| 2015 | -- | $245,600 +3383.7% |
| 2014 | -- | $7,050 |
| 2013 | -- | $7,050 +4.4% |
| 2012 | -- | $6,750 |
| 2011 | -- | $6,750 |
| 2010 | -- | $6,750 |
| 2009 | -- | $6,750 -4.9% |
| 2008 | -- | $7,100 |
| 2007 | -- | $7,100 -7.1% |
| 2006 | -- | $7,640 +35.5% |
| 2005 | -- | $5,640 |
| 2004 | -- | $5,640 |
| 2003 | -- | $5,640 |
| 2002 | -- | $5,640 +10.6% |
| 2001 | -- | $5,100 |
| 2000 | -- | $5,100 |
Find assessor info on the county website




