Sign up to get new listings emailed daily! JOIN SIGN IN
The Clark/Rotella Team
Licensed Associate Real Estate Brokers
(315) 391-4732 Brice
Facebook Icon Zillow Icon 
New - 5 Hours Ago
View Full Photo Gallery

Property Description

Opportunities like this don't come along every day! Offering an exceptional combination of space, location, and endless entertaining possibilities, this impressive 7 bedroom, 5 bathroom home is a rare find in this neighborhood. With room for everyone and spaces designed for gathering, relaxing, and making memories, this home offers a lifestyle that's hard to beat. Host formal dinner parties in the dining room and living room, enjoy cozy evenings in the family room with gas fireplace, or head downstairs to the rec room, complete with a pool table-perfect for game nights and friendly competition. When the weather warms up, take the fun outdoors to the pool, creating your own backyard retreat for summer gatherings.The covered deck area can be a cozy lounge space, outdoor bar or can support a hot tub. With so many versatile spaces, the entertaining doesn't stop when the seasons change! Inside the home, the 1st floor offers a formal living room, formal dining room, beautiful kitchen with walk in pantry, informal dining, family room, 2 large bedrooms and a full bath. The larger bedroom with solid wood pocket doors was being used as a home office. Upstairs, you'll find a loft area with a full bath, a primary suite over the garage, a 2nd primary suite with a balcony overlooking the backyard and 3 additional bedrooms. The basement is finished with a family room, rec area with pool/pingpong table, additional multi purpose room and laundry/storage area. There is an additional storage area with bulkhead doors leading to the backyard. Some of the numerous updates inlcude flooring, some appliances, some new siding and exterior painted, bathrooms updated, fireplaces cleaned and inspected, new deck, water heater, front door and more! This is a must see!

304 Fern Road | MLS# S1718370

This single family home located at 304 Fern Road, Syracuse, NY 13219 is currently listed for sale with an asking price of $474,900. This property was built in 1954 and has 6 bedrooms and 5 full and 1 partial baths with 2926 sq. ft. Fern Road is located in the Fairfield subdivision within the Westhill school district. Search Fairfield real estate on theclarkrotellateam.coldwellbankerprime.com today.

Upcoming Open Houses

Open House Sunday October 18th, 1:00pm - 3:00pm

Gallery

Property Features

Property Type: Residential - Single Family
Basement: ExteriorEntry, Full, Finished, WalkUpAccess
Cooling: CentralAir, WallUnits
Fireplaces: 3
Garage: 1 car attached
Heating: Electric, Gas, Baseboard, ForcedAir
Home Style: Colonial, TwoStory
Lot Size: 0.28 Acres
Roof Type: Asphalt
Stories: 2.0
Taxes: $12,636
Year Built: 1954

Amenities

BreakfastBar
CedarClosets
CeilingFans
CathedralCeilings
Den
SeparateFormalDiningRoom
SeparateFormalLivingRoom
GuestAccommodations
GraniteCounters
KitchenFamilyRoomCombo
Pantry
SlidingGlassDoors
Skylights
BedroomOnMainLevel
Loft
BathInPrimaryBedroom
BlacktopDriveway
Deck
Fence
Pool
Patio

Feature Descriptions

Appliances: Dryer, Dishwasher, Disposal, GasOven, GasRange, GasWaterHeater, Microwave, Refrigerator, Washer
Door Features: SlidingDoors
Exterior: Cedar
Fencing: Partial
Flooring: Carpet, Hardwood, Tile, Varies, Vinyl
Laundry: InBasement
Lot: NearPublicTransit, Rectangular, RectangularLot, ResidentialLot
Lot Dimensions: 65X185
Parcel#: 313289-046-000-0011-016-000-0000
Parking: Attached, Garage, Driveway, GarageDoorOpener
Parking Notes: Attached, Garage, Driveway, GarageDoorOpener
Patio/Porch: Covered, Deck, Patio, Porch
Pool: InGround
Security: RadonMitigationSystem
Sewer: Connected
Swimming Pool: Yes
Utilities: CableAvailable, ElectricityConnected, HighSpeedInternetAvailable, SewerConnected, WaterConnected
Water: Connected, Public
Window: Skylights

Local Schools

School District: Westhill

Estimate Your Payment

Estimated Payment

$ 2,248.43 per month $1,056.92 Principal & Interest $1,053.00 Property Tax $138.51 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: eXp Realty
Agency Contact: 888-276-0630

Shown By

Agent Name: The Clark/Rotella Team
Agent Phone: (315) 391-4732 Brice
Agency Title: Coldwell Banker Prime Properties

IDX logo

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 10/16/2026. The listing information on this page last changed on 10/16/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 Fri 10/16/2026 12:01:07 AM EST) or Global MLS (last updated Thu 10/15/2026 11:52:59 PM EST) or New York State Alliance MLS (last updated Thu 10/15/2026 11:59:06 PM EST) or Hudson Valley Catskill Region MLS (last updated Thu 10/15/2026 11:51:22 PM EST) or Berkshire MLS (last updated Thu 10/15/2026 8:13:58 PM EST) or OneKey MLS (last updated Thu 10/15/2026 11:55:30 PM 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