Title Page Background
HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 1867 AND i.igate IN ('usahud','nyhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nyhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 1867 AND i.igate IN ('usahud','nyhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nyhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 1867 AND i.igate IN ('usahud','nyhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nyhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

36 Brookview Dr
Waddington, NY 13694
Amanda Fiacco with Fiacco Realty, LLC, original listing - (315) 854-7529

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $359,000
Beds: 4
Baths: Full: 2
Status: Active
SqFt: 1752 Square Feet
Agency: Fiacco Realty, LLC
Agency Phone: (315) 854-7529

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1973
Notes: BEAUTIFUL MOVE IN READY HOME IN WADDINGTON! This lovely 4 bedroom, 2 full bathroom home with a newly remodeled kitchen, an in-ground pool, a hot tub, and attached two car garage, beautiful landscaping, a big back deck, a small basketball court area, a paved driveway and a water view is a must see! As you enter the home, you will see the foyer area, either going down or up to the open concept living area with Laminate/Vinyl-Plank flooring. The lovely rustic-style kitchen has hickory cabinets, beautiful countertops, a large island with stools and a small built-in beverage refrigerator, a dishwasher, a stove with a built in microwave/fan, and refrigerator with an ice maker and water dispenser. The kitchen flows into the dining room with a sliding glass door that goes out to the back deck. Then you’ll see the living room with plenty of windows for natural light. On the main floor, you will also find three bedrooms with pine doors and closets and one newly remodeled full bathroom. In the lower level of the home, you will find a large fourth bedroom with a full bathroom and a walk-in closet. This room could also be used as a second living room. On this level, you will also find the laundry room/utility room, including front load HE washer and dryer. The home is heated with a natural gas boiler and recently installed water heater. For air conditioning and supplemental heat there are 3 mini split systems in the home as well. Then you will find the attached, heated two car garage with two recently installed Bluetooth overhead doors with supplemental screened in panels for spring, summer and fall time use. You will enjoy having your own backyard oasis! You will love spending time on the new spacious back deck that was built with Trex decking, for years of maintenance free enjoyment. The deck overlooks the round in-ground heated pool, hot tub area with bushes for privacy, fence for safety, and fenced in garden area and a big, beautiful Apple Tree for baking or snacking on. There’s also a small basketball court in the backyard, a newly built wooden storage shed, and a brick-layered fire pit with plenty of wood for summer or winter time fun! This beautiful, move in ready home is close to the St. Lawrence River, walking distance to the local grocery store, park and restaurants. This is ready for new owners so schedule your showing soon!
MlsNumber: --
ListingId: 50327


Listing Provided By: Fiacco Realty, LLC, original listing
Phone: (315) 261-9809
Office Phone: (315) 854-7529
Agent Name: Amanda Fiacco
Disclaimer: Copyright © 2024 St. Lawrence Board of Realtors. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App