Title Page Background
DEBUG FN args: Array ( [0] => 1833 [1] => [2] => [3] => agent ) BEFORE: Site: 1833 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1833 Igate: njhud LocID: 1833 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 ('cahud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1833 [1] => [2] => [3] => lender ) BEFORE: Site: 1833 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1833 Igate: njhud LocID: 1833 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 ('cahud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1833 [1] => [2] => [3] => other ) BEFORE: Site: 1833 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1833 Igate: njhud LocID: 1833 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 ('cahud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

11 Cold Water Street
Hillsdale, NY 12529
Matthew Carey with Rouse + Co Real Estate, LLC, original listing - (845) 750-0196

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,395,000
Beds: 4
Baths: Full: 3, ½: 1
Status: Active
SqFt: 2834 Square Feet
Agency: Rouse + Co Real Estate, LLC
Agency Phone: (845) 750-0196

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1848
Notes: This stately Greek Revival sits proudly on a generous village lot in the historic Hamlet of Hillsdale. Dating back to c.1848, the home boasts beautiful architectural proportions and details. Pilasters accent the exterior corners of the house and a front- and side-gabled roof add additional grandeur. Arrive via a front porch — running the full width of the façade — framed with Doric columns. The front door, surrounded by two glass sidelights and topped by a transom window, leads into a center-hall / foyer. To the left, a front parlor flows into a generously sized dining room. Elegant moldings encase the windows and doorways. Beyond the dining room, a commodious kitchen with large Viking gas range and double-bowl farmhouse sink entices any gourmand. Two walls of windows allow light to flood the space, and a wood-burning stove adds extra warmth and air of coziness. A large pantry offers ample space for storage and organization. Off the kitchen a four-season sunroom drenched in light contains a gas-burning fireplace and access to the yard. A wet bar, found off the dining room, features a charming booth overlooking a stone patio. A full-length parlor occupies the western side of the house. It features an electric fireplace as well as a fully enclosed nook with another wood-burning stove. A powder room is found tucked behind the parlor's interior wall. Upstairs five bedrooms and two full baths surround the second-floor landing. The primary bedroom opens to an office space with a third full bath. Outside a large barn contains a hot tub, workshop and abundant storage. The yard is fully fenced and spacious, perfect for letting pets off-leash as well as outdoor entertaining. The home strikes a balance between historic and contemporary, with plenty of room to spread out. Walk to shops, restaurants and grocers located in the Hamlet of Hillsdale. Located 20 minutes to Hudson, 15 minutes to Great Barrington and just minutes to skiing and summer recreation at Catamount Resort, this home is ideally situated for exploring the upstate lifestyle.
MlsNumber: --
ListingId: 20251291


Listing Provided By: Rouse + Co Real Estate, LLC, original listing
Phone: (203) 763-9599
Office Phone: (845) 750-0196
Agent Name: Matthew Carey
Disclaimer: Copyright © 2025 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