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

265 Main Street
Delhi, NY 13753
Peter Kleeman with Jewett and Jewett LLC, original listing - (802) 578-0731

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $535,000
Beds: 3
Baths: Full: 1, ½: 1
Status: Active
SqFt: 2924 Square Feet
Agency: Jewett and Jewett LLC
Agency Phone: (802) 578-0731

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Garage: Garage
Property Type: Residential-Single Family Attached
Year Built: 1936
Notes: A unique opportunity to own a Delhi Village residential/commercial property with an attached vintage Lord and Burnham glass greenhouse awaits your creativity. Situated on 1.4 acres along Delhi’s main street on the edge of the village, the home has been tastefully updated with a new craftsman-style kitchen and full bath. There are limitless live & work opportunities with this property. There is also a small barn, root cellar, and chicken coop in the backyard. There are 4 greenhouses in total: two are fully functional year-round, and two are seasonal. The stunning 1936 Lord & Burnham glass greenhouse measures 76 by 25 feet and is home to a very old grape vine that produces delicious fruit annually! There is a second, smaller Lord & Burnham greenhouse, plus additional modern hoop-style growing spaces, and numerous outdoor garden beds, including water-lily pools. This property has a terrific layout and has been a successful local business for decades. The main floor of the 2-story building, previously used as a retail space, contains workshops, a private office & a half bath. A newer extension has glass walls on 2 sides and a classic woodstove, making a great office, studio, showroom, or cafe. The 2nd floor is a modern renovation, 3-bed, 1-bath apartment with an attic that could be finished and used as extra living or workspace. There is parking for 5+ cars and is a short drive to the village center, with many restaurants, cafes, and shops. Bring your great business ideas or invest in a lucrative rental, live-work opportunities abound!
MlsNumber: --
ListingId: R1597193


Listing Provided By: Jewett and Jewett LLC, original listing
Phone: (802) 578-0731
Office Phone: (802) 578-0731
Agent Name: Peter Kleeman
Disclaimer: Copyright © 2025 New York State Alliance of MLSs, LLC. 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