Get new listings emailed daily! JOIN SIGN IN
Eric Frasier
Licensed Real Estate Salesperson
REALTOR®, Accredited Buyer Representative, Pricing Strategy Advisor
(518) 774-2345 Cell
Facebook Icon VCard Icon 

8290 Cody's Corners, Cicero, NY 13039

New - 30 Hours Ago
Pending
View Full Photo Gallery

Property Description

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.

8290 Cody's Corners | MLS# S1716535

This single family home located at 8290 Cody's Corners, Cicero, NY 13039 is currently listed for sale by Coldwell Banker Prime Properties, with an asking price of $875,000. This property was built in 2004 and has 5 bedrooms and 4 full and 1 partial baths with 3906 sq. ft. Cody's Corners is located in the Pastures Sec 3 subdivision within the North Syracuse school district. Search Pastures Sec 3 real estate on eric-frasier.coldwellbankerprime.com today.

Gallery

Property Features

Property Type: Residential - Single Family
Basement: Full, Finished, Sump Pump
Cooling: Zoned
Fireplaces: 1
Garage: 3 car attached
Heating: Gas, Zoned, Forced Air
Home Style: Colonial, Two Story
Lot Size: 0.38 Acres
Roof Type: Architectural, Shingle
Stories: 2.0
Taxes: $18,363
Year Built: 2004

Amenities

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
Blacktop Driveway
Barbecue
Patio

Feature Descriptions

Appliances: Double Oven, Dryer, Dishwasher, Gas Cooktop, Disposal, Gas Water Heater, Microwave, Refrigerator, Washer
Association Amenities: None
Days on Site: 1
Door Features: Sliding Doors
Exterior: Blown-In Insulation, Stone, Vinyl Siding
Flooring: Carpet, Ceramic Tile, Hardwood, Varies
Laundry: Main Level
Lot: Rectangular, Rectangular Lot, Residential Lot
Lot Dimensions: 79X180
Parcel#: 312289-051-004-0004-055-000-0000
Parking: Attached, Electricity, Garage, Garage Door Opener
Parking Notes: Attached, Electricity, Garage, Garage Door Opener
Patio/Porch: Patio
Sewer: Connected
Utilities: Sewer Connected, Water Connected
Water: Connected, Public

Local Schools

School District: North Syracuse

Estimate Your Payment

Estimated Payment

$ 3,732.83 per month $1,947.37 Principal & Interest $1,530.25 Property Tax $255.21 Homeowner's Insurance

Change Payment Information

%
years/fixed
yearly
yearly (est.)
(Payments are an estimate and may vary by lender)

Demographics

Listed By / Shown By

Listing By

Agency Name: Coldwell Banker Prime Properties

agent picture

Shown By

Agent Name: Eric Frasier
Agent Phone: (518) 774-2345 Cell

Disclaimer: All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumers personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information on this site was last updated 09/23/2026. The listing information on this page last changed on 09/23/2026. The data relating to real estate for sale on this website comes in part from the Internet Data Exchange program of Delta Media Group MLS (last updated Wed 09/23/2026 3:29:39 AM EST) or Global MLS (last updated Wed 09/23/2026 1:22:22 AM EST) or New York State Alliance MLS (last updated Wed 09/23/2026 2:34:53 AM EST) or Hudson Valley Catskill Region MLS (last updated Wed 09/23/2026 12:11:14 AM EST) or Berkshire MLS (last updated Tue 09/22/2026 8:14:01 PM EST) or OneKey MLS (last updated Wed 09/23/2026 1:45:19 AM EST). Real estate listings held by brokerage firms other than Coldwell Banker Prime Properties may be marked with the Internet Data Exchange logo and detailed information about those properties will include the name of the listing broker(s) when required by the MLS. All rights reserved.

C.B. Prime Properties, Inc. fully supports the principles of the Fair Housing Act and the Equal Opportunity Act. Each franchise is independently owned and operated.

Homestead Funding Corp. Company NMLS# 3232. Equal Housing Lender. State Licensing Information

Coldwell BankerĀ®. All rights reserved. The Coldwell Banker System is comprised of company owned offices which are owned by a subsidiary of Anywhere Advisors LLC and franchised offices. Coldwell Banker Real Estate LLC, fully supports the principles of the Fair Housing Act and the Equal Opportunity Act. Any services or products provided by independently owned and operated franchisees are not provided by, affiliated with, or related to Coldwell Banker Real Estate LLC nor any of its affiliated companies.


Privacy Policy / DMCA Notice / ADA Accessibility

Login to My Homefinder