Absolutely Stunning Transitional Colonial nestled on a 1.8 acre lot in Constantia boasts four spacious bedrooms, one and a half baths, large country kitchen with custom oak cabinets, new countertops, sink and faucet, electric oven/range, refrigerator, formal diningroom with sliding glass door to deck, livingroom, 18' x 21' three season breezeway with new flooring between kitchen and attached 20' x 30' two car garage, separate 4 car garage, shed, washer and dryer, all new Comfort windows and doors throughout and major upgrades as follows: 2002 New 1000 gallon concrete septic tank, 2012 New Comfort Windows on west side of home, 2014 New hot water tank, well pump, upstairs toilet, Comfort vinyl windows and storm doors in breezeway, 2015 Metal roof on home and garage, 2016 New Comfort Windows on east side of home, New Comfort Windows front entrance with door, new Comfort Windows front porch deck, 2020 New vinyl siding on home and breezeway, resurfaced driveway (sealed every other year - last sealed 2024, 2021 New 15' x 24' storage shed, 2022 New wood pellet stove in livingroom, 2024 New furnace with central air and electric pump, 2024 New water line from well to home - well is 90' deep and electric outlets replaced in home, 2025 Electric outlets replaced in garage, Blue tooth speakers in breezeway, attic fan is set on automatic and when temperature reaches 90 degrees, it automatically turns on, generator and installed hookup in garage to cover lights, refrigerator and stove in case of power outage and low taxes! Don't hesitate...Highest and Best Offer due by 1:00pm on Tuesday June 10, 2025.
Closed
$317,000
1004 County Route 23, Constantia, NY 13044
4beds
1,904sqft
Single Family Residence
Built in 1979
1.18 Acres Lot
$317,200 Zestimate®
$166/sqft
$2,593 Estimated rent
What's special
Zillow last checked: 7 hours ago
Listing updated: August 14, 2025 at 08:01am
Listed by:
Joan Rayo Adams 315-682-7197,
Hunt Real Estate ERA
Bought with:
Carol Jones, 40JO1162970
Howard Hanna Real Estate
Source: NYSAMLSs,MLS#: S1612056
Originating MLS: Syracuse

Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 2
- Full bathrooms: 1
- 1/2 bathrooms: 1
- Main level bathrooms: 1
Heating
- Electric, Heat Pump, Wood, Forced Air
Cooling
- Heat Pump, Attic Fan, Central Air
Appliances
- Included: Dryer, Electric Cooktop, Electric Oven, Electric Range, Electric Water Heater, Free-Standing Range, Oven, Refrigerator, Washer
- Laundry: In Basement
Features
- Ceiling Fan(s), Separate/Formal Dining Room, Entrance Foyer, Eat-in Kitchen, Separate/Formal Living Room, Sliding Glass Door(s), Natural Woodwork
- Flooring: Carpet, Hardwood, Tile, Varies
- Doors: Sliding Doors
- Windows: Thermal Windows
- Basement: Exterior Entry,Full,Partially Finished,Walk-Up Access
- Number of fireplaces: 1
Interior area
- Total structure area: 1,904
- Total interior livable area: 1,904 sqft
Property
Parking
- Total spaces: 2
- Parking features: Attached, Electricity, Garage, Storage
- Attached garage spaces: 2
Features
- Levels: Two
- Stories: 2
- Patio & porch: Deck, Open, Porch
- Exterior features: Blacktop Driveway, Deck, Private Yard, See Remarks
Lot
- Size: 1.18 Acres
- Dimensions: 189 x 293
- Features: Irregular Lot, Residential Lot, Rural Lot
Details
- Additional structures: Barn(s), Outbuilding, Shed(s), Storage, Second Garage
- Parcel number: 35268926200000040050000000
- Special conditions: Standard
- Other equipment: Generator
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Colonial,Transitional
- Property subtype: Single Family Residence
Materials
- Frame, Vinyl Siding, Copper Plumbing
- Foundation: Block
- Roof: Metal
Condition
- Resale
- Year built: 1979
Utilities & green energy
- Electric: Circuit Breakers
- Sewer: Septic Tank
- Water: Well
- Utilities for property: Cable Available
Community & neighborhood
Location
- Region: Constantia
- Subdivision: Great Tr #1
Other
Other facts
- Listing terms: Cash,Conventional,FHA,VA Loan