Welcome to this magnificent colonial situated in the desirable neighborhood of The Pastures. Offering over 3,900 square feet of above-grade living space and an additional 1,900 finished square feet in the basement, this home combines luxury, comfort, and unmatched versatility, featuring both a first-floor and second-floor primary suite.
You'll arrive and the first thing you'll notice is the striking stampcrete walkway, complemented by extensive professional landscaping, custom retaining walls, and outdoor lighting. Step inside a dramatic two-story foyer showcasing an elegant open front staircase. Designed for effortless entertaining, the brand-new kitchen boasts custom white cabinetry, a gas cooktop, double ovens, and a massive quartz center island.
Flow seamlessly from the kitchen into a breathtaking two-story family room anchored by a floor-to-ceiling stone wall, a gas fireplace, and abundant natural light. These spaces connect to a light and bright sunroom featuring a wall of windows dressed with stylish plantation shutters, providing convenient access to the first-floor laundry and a secondary staircase.
The main level offers a primary suite with coffered ceilings, a huge walk-in closet, and a spa-like bath featuring new custom cabinetry with pull-outs, a makeup vanity, and quartz countertops. Additionally, a private home office with cathedral ceilings and rich hardwood floors is tucked away at the back of the house for ultimate remote-working privacy.
The second floor offers three additional generously sized bedrooms alongside a second primary suite. The finished lower level is a true entertainment showstopper, featuring a custom cherry wood wet bar equipped with a dishwasher and refrigerator, a spacious recreation area, a gym, a full bathroom, and matching custom cherry woodwork throughout.
Pending
$875,000
8290 Codys Cors, Cicero, NY 13039
5beds
3,906sqft
Single Family Residence
Built in 2004
0.38 Acres Lot
$-- Zestimate®
$224/sqft
$-- HOA
What's special
Gas fireplaceAbundant natural lightOutdoor lightingCustom retaining wallsFloor-to-ceiling stone wallHuge walk-in closetRich hardwood floors
- 22 days
- 424
- 12
Zillow last checked:
Listing updated:
Listed by:
Coldwell Banker Prime Prop,Inc 315-752-0320,
Renee Douglas Asterino 315-752-0320
Source: NYSAMLSs,MLS#: S1716535
Originating MLS: Syracuse
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 5
- Bathrooms: 5
- Full bathrooms: 4
- 1/2 bathrooms: 1
- Main level bathrooms: 2
- Main level bedrooms: 1
Heating
- Gas, Zoned, Forced Air
Cooling
- Zoned
Appliances
- Included: Double Oven, Dryer, Dishwasher, Gas Cooktop, Disposal, Gas Water Heater, Microwave, Refrigerator, Washer
- Laundry: Main Level
Features
- Breakfast Bar, Ceiling Fan(s), Cathedral Ceiling(s), Den, Separate/Formal Dining Room, Entrance Foyer, Eat-in Kitchen, Guest Accommodations, Home Office, Kitchen Island, Pantry, Sliding Glass Door(s), Bar, Bedroom on Main Level, Bath in Primary Bedroom, Main Level Primary, Primary Suite, Programmable Thermostat
- Flooring: Carpet, Ceramic Tile, Hardwood, Varies
- Doors: Sliding Doors
- Basement: Full,Finished,Sump Pump
- Number of fireplaces: 1
Interior area
- Total structure area: 3,906
- Total interior livable area: 3,906 sqft
Property
Parking
- Total spaces: 3
- Parking features: Attached, Electricity, Garage, Garage Door Opener
- Attached garage spaces: 3
Features
- Levels: Two
- Stories: 2
- Patio & porch: Patio
- Exterior features: Blacktop Driveway, Barbecue, Patio
Lot
- Size: 0.38 Acres
- Dimensions: 79 x 180
- Features: Rectangular, Rectangular Lot, Residential Lot
Details
- Parcel number: 31228905100400040550000000
- Special conditions: Standard
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Colonial,Two Story
- Property subtype: Single Family Residence
Materials
- Blown-In Insulation, Stone, Vinyl Siding
- Foundation: Block
- Roof: Architectural,Shingle
Condition
- Resale
- Year built: 2004
Utilities & green energy
- Electric: Circuit Breakers
- Sewer: Connected
- Water: Connected, Public
- Utilities for property: Sewer Connected, Water Connected
Community & HOA
Community
- Subdivision: Pastures Sec 3
HOA
- Amenities included: None
Location
- Region: Cicero
Financial & listing details
- Price per square foot: $224/sqft
- Tax assessed value: $420,000
- Annual tax amount: $18,363
- Date on market: 9/20/2026
- Cumulative days on market: 23 days
- Listing terms: Cash,Conventional
Estimated market value
Not available
Estimated sales range
Not available
Not available
Price history
| Date | Event | Price |
|---|---|---|
| 9/22/2026 | Pending sale | $875,000$224/sqft |
Source: | ||
| 9/22/2026 | Listed for sale | $875,000+134.9%$224/sqft |
Source: | ||
| 10/18/2004 | Sold | $372,500+132.8%$95/sqft |
Source: Public Record Report a problem | ||
| 1/20/2004 | Sold | $160,000$41/sqft |
Source: Public Record Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | -- | $420,000 |
| 2024 | -- | $420,000 |
| 2023 | -- | $420,000 |
| 2022 | -- | $420,000 |
| 2021 | -- | $420,000 |
| 2020 | -- | $420,000 |
| 2019 | -- | $420,000 |
| 2018 | -- | $420,000 |
| 2017 | $15,213 +177.8% | $420,000 |
| 2016 | $5,477 | $420,000 |
| 2015 | -- | $420,000 |
| 2014 | -- | $420,000 |
| 2013 | -- | $420,000 |
| 2012 | -- | $420,000 |
| 2011 | -- | $420,000 +2227.8% |
| 2010 | -- | $18,043 |
| 2009 | -- | $18,043 |
| 2008 | -- | $18,043 |
| 2007 | -- | $18,043 -15% |
| 2006 | -- | $21,232 |
| 2005 | -- | $21,232 +1504.8% |
| 2004 | -- | $1,323 |
Find assessor info on the county website
Monthly payment
Climate risks
Neighborhood: 13039
Nearby schools
Schools provided by the listing agent
- District: North Syracuse
Source: NYSAMLSs. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.




