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 = 1833 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 = 1833 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 = 1833 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;

65 Green Street
Hudson, NY 12534

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $515,000
Beds: 4
Baths: 2
Status: Active
SqFt: 1700
Agency: Compass Greater NY, LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1900
Notes: Charming Home in Hudson - Welcome to your own charming oasis in the heart of Hudson! This delightful home offers the perfect blend of character, comfort, and convenience in a sought-after location. Built in the 1900s and situated within walking distance to Warren Street - shops, restaurants, and cafes - or you can simply enjoy the serenity of a private backyard with a hot tub. Step inside to discover a cozy and welcoming well-maintained home highlighted by wood floors and an abundance of natural light. There's a spacious living room, a cute country kitchen that's both functional and stylish, and a separate dining area that offers a perfect setting for enjoying meals or entertaining guests. A bedroom off the kitchen — which could also be an office — plus a half-bath and convenient washer/dryer finish off the ground floor. Upstairs you'll find a full bathroom and three nice-sized bedrooms, each boasting tons of character. Windows fill each room with natural light, providing a sunny and cheerful ambience. Outside, the fenced backyard with a deck is a haven for outdoor living, perfect for grilling and entertaining. The covered front porch adds to the curb appeal and provides a welcoming entrance for guests. Additional features include off-street parking for added convenience and on-demand water for efficiency. Furnishings available for purchase separately. Hudson has become one of the most popular towns in the Hudson Valley with nationally-recognized restaurants, hotels, and numerous artisan shops and boutiques - all within walking distance! Minutes to the Amtrak station, traveling to and from NYC is a breeze. Other nearby towns to explore include Catskill (10 minutes), Red Hook (25 mins), Rhinebeck (35 mins).
MlsNumber: 20240601


Listing Provided By: Compass Greater NY, LLC, original listing
Name: Compass Greater NY, LLC
Phone: (838) 877-8283
Office Name: Compass Greater NY, LLC
Office Phone: (838) 877-8283
Agent Name: Leigh Bokser
Disclaimer: Copyright © 2024 Multiple Listing Service of Ulster County. 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