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','vahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'vahud', 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','vahud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'vahud', 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','vahud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'vahud', 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;

43 White Rd
Winthrop, NY 13697
Amanda Fiacco with Fiacco Realty, LLC, original listing - (315) 854-7529

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $369,000
Beds: 4
Baths: Full: 1, ½: 1
Status: Active
SqFt: 1296 Square Feet
Agency: Fiacco Realty, LLC
Agency Phone: (315) 854-7529

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 5 acre(s)
Garage: Garage
Property Type: Residential-Multi Family
Year Built: 2016
Notes: TWO HOMES SITUATED ON A 5 ACRE LOT WITH A POND! If you are looking for a home with room for extended family to have their own space, then this wonderful property is for you! The property has six different variety of apples on 9 apple trees and 8 blueberry bushes. The pond is excellent for fishing as it is stocked with catfish and bass. There are trails to walk or ride on through the woods. There is a privacy fence along the road and a generator that can run both homes. One home was built in 2016 with 4 bedrooms, 1.5 bathrooms, open concept living space, a covered porch overlooking the pond and an attached one stall garage that is handicap accessible. The other home was built in 2010 with 2 bedrooms, 2 full bathroom, open concept living space, a covered, screened in porch overlooking the pond and an attached 3 stall garage. There is a wooden walkway between the two homes for your convenience. As you enter the 4 bedroom home you will see the kitchen and dining area which flow into the spacious living room. Off the living room is the primary bedroom with a half bathroom and the other downstairs bedroom. Also on the first floor is the full bathroom with a washer, gas dryer and on demand gas hot water heater. Upstairs you will find two more bedrooms. Off the living room you will walk out the sliding glass door to the covered porch where you can relax and enjoy the view of the pond. There is also a one stall attached garage. As you enter the 2 bedroom home you will see the kitchen and dining room that flow into the living room with a woodstove. To the right of the woodstove is a hidden closet door for storage. That open concept living space has a cathedral ceiling and a wall full of windows that lead to the screened in covered porch that overlooks the pond. Off the living room is the primary bedroom with a walk-in closet and the washer and gas dryer are in the closet as well. There is also a primary bathroom with an extra wide jet bathtub and shower. Off the kitchen you will find the second bedroom and the main bathroom which has a shower with shower heads at both ends. This home has an a three stall garage with tall ceilings and extra storage space for your convenience. This property has many possibilities for rental income as well. Schedule your showing soon to see these lovely homes!
MlsNumber: --
ListingId: 50530


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.


Local Real Estate Expert

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','vahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'vahud', 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;
Real Estate Expert Photo for Colleen Ayers
Colleen Ayers
ASCIIColdwell Banker Whitbeck Associates
Call Today!: (315) 261-8134

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App