Title Page Background
DEBUG FN args: Array ( [0] => 1842 [1] => [2] => [3] => agent ) BEFORE: Site: 1842 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1842 Igate: njhud LocID: 1842 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 = 1842 AND i.igate IN ('nyhud','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 = 'nyhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1842 [1] => [2] => [3] => lender ) BEFORE: Site: 1842 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1842 Igate: njhud LocID: 1842 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 = 1842 AND i.igate IN ('nyhud','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 = 'nyhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1842 [1] => [2] => [3] => other ) BEFORE: Site: 1842 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1842 Igate: njhud LocID: 1842 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 = 1842 AND i.igate IN ('nyhud','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 = 'nyhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

4930 State Route 81
Greenville, NY 12083
Theresa Donlon with Venture Realty Partners, original listing - (518) 833-6636

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $549,999
Beds: 5
Baths: Full: 2
Status: Active
SqFt: 2590 Square Feet
Agency: Venture Realty Partners
Agency Phone: (518) 833-6636

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1891
Notes: A Regal Queen Anne Victorian Masterpiece on the Historical Registry<br /> <br /> Step into a world of timeless elegance with this Storybook Queen Anne Victorian, a residence proudly listed on the Historical Registry that captures the grandeur, charm, and craftsmanship of a bygone era. Marvel at the meticulous details of the painted medallions, corbels & rounded walls. From the moment you enter the welcoming foyer—featuring exquisite inlaid floors of Mahogany, Walnut, and Oak and a sweeping majestic staircase that anchors the heart of the home, complemented by ornate wood trim and breathtaking stained-glass windows that bathe the space in ethereal light. Enjoy the established perennial gardens & check out the lightning rods on the roof!!! <br /> <br /> The main level offers a wealth of living and entertaining options, including two formal parlors, a grand dining room, a charming country kitchen adorned with a vintage tin ceiling, walk-in pantry, family room/den or office, laundry, and a full bathroom.<br /> <br /> Ascend either of the two staircases to the second floor, where you'll find five bedrooms, a full bathroom, ample closet space in every room, and inviting balconies to explore. A secondary room adds flexibility to the floor plan, ideal for a reading nook, playroom, or studio.<br /> <br /> The third floor is a hidden gem requiring some love and creativity. Additional bedrooms and a plumbed-in bathroom waiting to be transformed into a private retreat, or in-home business. The possibilities here are as boundless as your imagination.<br /> <br /> The Carriage House offers an exciting canvas for your vision—whether it becomes a yoga sanctuary, artist's loft, antiques boutique, farm-to-table café, guest accommodations, or professional offices to name a few, this charming outbuilding is brimming with potential and character. With a bit of TLC, it becomes a space limited only by your creativity.<br /> <br /> A Dream Location in the Hamlet of Greenville<br /> <br /> Nestled in the heart of the sought-after Great Northern Catskills and Hudson Valley, this home offers unparalleled access to lifestyle and leisure. Enjoy nearby 18-hole golf courses, scenic hiking and bike trails, dog parks,horseback riding, pristine swimming holes, skiing, antique shops, craft breweries & The Damon Baehrel Basement Bistro, famous for it's All of this just 30+ minutes from Albany, Hudson, and Saugerties, and approximately 2 +/- hours from New York City.<br /> <br /> This is more than a home—it's an invitation to live a fairytale life, where historic charm meets modern opportunity. Call today to arrange your private showing and discover how the extraordinary can become your everyday.
MlsNumber: --
ListingId: 20251544


Listing Provided By: Venture Realty Partners, original listing
Phone: (518) 819-9578
Office Phone: (518) 833-6636
Agent Name: Theresa Donlon
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.


Local Real Estate Expert

DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => greene [3] => NY [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: greene State: NY Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: greene State: NY 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 = 1842 AND i.igate IN ('nyhud','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 = 'nyhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Real Estate Expert Photo for Eliana Amodio
Eliana Amodio
ASCIIAmodio Real Estate & Prop
Call Today!: (561) 322-8428

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App