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

12 A & B Willow Street
Potsdam, NY 13676

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $249,900
Beds: 6
Baths: 2
Status: Active
SqFt: 2288
Agency: Plumley Real Estate LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: MultiFamily
Year Built: 1986
Notes: INVESTMENT OPPORTUNITY – NEW TO THE MARKET – Well maintained 3-bedroom 1 bath (each unit) Townhouse duplex built in 1986, this duplex with its beautiful wood beam ceilings, was designed with energy efficiency in mind with its electric baseboard heat with multiple different zones, and circulating air fans in each unit. Additionally, this duplex is built on a slab with no basement to care for and has a private driveway leading to a large private parking lot.12 A has washer/dryer hookup, 12B has washer hook up. The property is located in downtown Potsdam and in the Downtown Revitalization Initiative (DRI) development zone. Potsdam is the center for arts, education, culture and a bustling food scene in Northern New York with access to museums, downtown grocery and specialty food stores, a farmer’s market and higher education institutions. Each 1122 sq. ft apartment rents for $1,100.00 with the tenants paying all the utilities. 12 months utilities: Water/sewer/trash- 12-month Est cost- $1200 (split/half between both sides) Electrical:12-month Est cost-$1600 (includes heat cost) Recent upgrades include: new kitchen appliances, carpet, flooring, white interior doors and handles, interior and exterior painting, updated bathrooms, LED wall sconces and overhead lights, new thermostats, smoke alarms with 10-year battery detectors, replacement of electric baseboard heaters, and stone installation in the driveway/parking lot. This duplex has no natural gas hook up and there for has no carbon monoxide detectors. All information is deemed reliable but not guaranteed.
MlsNumber: 49676


Listing Provided By: Plumley Real Estate LLC, original listing
Name: Plumley Real Estate LLC
Phone: (315) 265-6720
Office Name: Plumley Real Estate LLC
Office Phone: (315) 265-6720
Agent Name: Beth Reasoner
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