Come see what this amazing property has to offer. all buildings are designed to be maintenance free. steel and cedar sided A year-round contemporary 3-bedroom 1 bath, laminate flooring, spiral staircase, full bath that has separate shower, large 2nd floor family/living room, central air, in floor heating, heat pump, country kitchen with large formal dine, electric fireplace for ambiance, all appliances stay, tongue and groove pine ceilings and walls, 9 feet ceilings, walkout to patio and enjoy the views of Fair Haven Bay, take a walk outside and go enjoy your pool area with shaded overhang or sit in the sun, there is a sperate heated workshop, that has full kitchenette, shower and bathroom near the pool, Or you can go into a different shop building if you are car enthusiast and enjoy this heated garage with a its very own lift. If that is not enough wonder across the driveway to your 3-car garage, with 1/2-bedroom 1 full bath apartment, it is air conditioned and set for year-round living. Balcony overlooking the property and the bay. The main house is currently used as a vacation rental. You can continue renting and live in the apartment or this makes the perfect family get away complex Let's not forget the other 27-foot garage owner uses to store his RV and perfect for boat. It comes with 12-foot ROW to Fair Haven Bay. It has frontage on 2 roads and driveway that goes from road to road on this property. The landscaping is fantastic along with gardens the owners care really shows. property even has solar panels to supplement the electrical. Located minutes to the winery, Lake Ontario, Fair haven Beach state park, Sterling Nature center, renaissance festival, centrally located between Rochester and Syracuse on just off the seaway trial. a few hours to Niagara Falls or the thousand islands. This truly is the most Unique property you will ever find
Active
$750,000
14790 W Bay Rd, Sterling, NY 13156
3beds
1,728sqft
Single Family Residence
Built in 1988
0.88 Acres Lot
$-- Zestimate®
$434/sqft
$-- HOA
What's special
Electric fireplace for ambianceCentral airSpiral staircaseAll appliances stayIn floor heatingHeat pumpLaminate flooring
- 42 days |
- 508 |
- 12 |
Zillow last checked:
Listing updated:
Listed by:
Howard Hanna 315-524-2331,
Thomas J. Collier Sr. 315-524-2331
Source: NYSAMLSs,MLS#: R1682159
Originating MLS: Rochester
Loading...
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 3
- Bathrooms: 1
- Full bathrooms: 1
- Main level bathrooms: 1
- Main level bedrooms: 3
Heating
- Ductless, Heat Pump, Propane, Other, See Remarks, Forced Air, Radiator(s)
Cooling
- Ductless, Heat Pump, Other, See Remarks, Central Air
Appliances
- Included: Dryer, Dishwasher, Gas Oven, Gas Range, Propane Water Heater, Refrigerator, Washer
- Laundry: Main Level
Features
- Ceiling Fan(s), Separate/Formal Dining Room, Eat-in Kitchen, Separate/Formal Living Room, Galley Kitchen, Home Office, Country Kitchen, Other, See Remarks, Bedroom on Main Level, In-Law Floorplan
- Flooring: Hardwood, Laminate, Other, See Remarks, Varies
- Windows: Thermal Windows
- Number of fireplaces: 1
Interior area
- Total structure area: 1,728
- Total interior livable area: 1,728 sqft
Property
Parking
- Total spaces: 8
- Parking features: Detached, Electricity, Garage, Heated Garage, Water Available, Circular Driveway, Driveway
- Garage spaces: 8
Features
- Patio & porch: Balcony, Open, Patio, Porch
- Exterior features: Balcony, Dock, Gravel Driveway, Patio, See Remarks, Propane Tank - Owned
- Waterfront features: Beach Access, Bayfront
- Body of water: Little Sodus Bay
Lot
- Size: 0.88 Acres
- Dimensions: 166 x 230
- Features: Agricultural, Other, Rectangular, Rectangular Lot, See Remarks
Details
- Additional structures: Barn(s), Guest House, Outbuilding, Other, Pool House, Second Garage
- Parcel number: 05568900800700010120000000
- Special conditions: Standard
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Contemporary
- Property subtype: Single Family Residence
Materials
- Aluminum Siding, Attic/Crawl Hatchway(s) Insulated, Cedar, Other
- Foundation: Block, Slab
- Roof: Metal
Condition
- Resale
- Year built: 1988
Utilities & green energy
- Electric: Circuit Breakers
- Sewer: Connected
- Water: Connected, Public
- Utilities for property: Cable Available, Electricity Connected, Sewer Connected, Water Connected
Community & HOA
Location
- Region: Sterling
Financial & listing details
- Price per square foot: $434/sqft
- Tax assessed value: $682,500
- Annual tax amount: $11,725
- Date on market: 5/14/2026
- Cumulative days on market: 25 days
- Listing terms: Conventional
Estimated market value
Not available
Estimated sales range
Not available
Not available
Price history
| Date | Event | Price |
|---|---|---|
| 5/15/2026 | Listed for sale | $750,000+2172.7%$434/sqft |
Source: | ||
| 9/12/2002 | Sold | $33,000$19/sqft |
Source: Agent Provided Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | -- | $682,500 +74.6% |
| 2024 | -- | $391,000 +1.3% |
| 2023 | -- | $386,000 |
| 2022 | -- | $386,000 |
| 2021 | -- | $386,000 |
| 2020 | -- | $386,000 |
| 2019 | -- | $386,000 |
| 2018 | -- | $386,000 |
| 2017 | $4,650 | $386,000 |
| 2016 | -- | $386,000 +2.7% |
| 2015 | -- | $375,700 +1.3% |
| 2014 | -- | $370,700 +4% |
| 2013 | -- | $356,400 |
| 2012 | -- | $356,400 +7.8% |
| 2011 | -- | $330,700 +33.7% |
| 2010 | -- | $247,300 +24.3% |
| 2009 | -- | $198,900 +10.3% |
| 2008 | -- | $180,300 +72% |
| 2007 | -- | $104,800 |
| 2006 | -- | $104,800 |
| 2005 | -- | $104,800 |
| 2004 | -- | $104,800 +25.1% |
| 2003 | -- | $83,800 |
| 2002 | -- | $83,800 |
| 2001 | -- | $83,800 |
Find assessor info on the county website
Monthly payment
Estimated monthly payment$1,822
All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
Mortgage interest rates are dependent on a number of factors, including credit score, down payment, and repayment length. Interest rate data provided by Zillow Group Marketplace, Inc. as of 1/1/1970 from various mortgage lenders with which we have lead or other similar arrangements; the Estimated Payment is an average of those rates.
See how much you could borrow to make a competitive offer.
Climate risks
Neighborhood: 13156
Nearby schools
GreatSchools rating
- 5/10Margaret W Cuyler Elementary SchoolGrades: PK-5Distance: 6.3 mi
- 6/10Red Creek Middle SchoolGrades: 6-8Distance: 6.3 mi
- 4/10Red Creek High SchoolGrades: 9-12Distance: 6.3 mi
Schools provided by the listing agent
- District: Red Creek
Source: NYSAMLSs. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
A local agent can set up tours, give advice and negotiate with sellers.
- New York
- Cayuga County
- Sterling
- 13156
- 14790 W Bay Rd





