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

8 Renwick Street
Tannersville, NY 12485

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $475,000
Beds: 3
Baths: 2
Status: Active
SqFt: 1320
Agency: Dugo Realty

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1918
Notes: Hey there, savvy home seeker! If you've been tirelessly browsing through listings for that idyllic Catskills retreat, well, consider your quest triumphantly concluded. Why settle for the ordinary when you can have the extraordinary, right? This captivating village abode, a stone's throw from Hunter Mountain, is not just a home; it's your year-round sanctuary nestled on a verdant .4 acre plot. Sure, it's a mere five-minute drive to the slopes, but with such proximity, every day feels like a ski getaway. And let's talk about location! Tucked away in the heart of Tannersville, you're moments away from quaint shops, delightful eateries, the Colonial Golf Course, and even the NYC Bus Route. It's almost as if the universe conspired to place everything you could ever wish for right at your doorstep!Now, onto the pice de rsistance - the house itself, a cozy haven where every nook whispers 'welcome home.' This gem is hitting the market Fully Furnished, with updates that cater to the modern family or the most discerning of retreat seekers. With three plush bedrooms designed to cradle you in comfort, the promise of a restful sleep is a guarantee. The living room, anchored by a 50-inch TV and an electric fireplace, offers a sanctuary for those serene evenings in. And for those who blend work with pleasure, a dedicated workspace ensures productivity never skips a beat.Culinary enthusiasts, get ready to fall in love. The kitchen doesn't just serve function; it's a call to adventure with a cute coffee bar and all the tools needed to fuel your gastronomic exploits. Coupled with a dining room that magnetizes family and friends to its heart, mealtime transforms into a celebration of togetherness.Venture outside to bask on the front porch, your new favorite spot for relaxation, complete with a sofa and BBQ grill for those enchanting alfresco evenings. A rear entryway ski rack stands ready to safeguard your equipment after a thrilling day on the slopes.As for activities, let's just say boredom is a word unknown in this locale. From exhilarating ski trips at Hunter Mountain to leisurely strolls in downtown Tannersville or awe-inspiring hikes along the Kaaterskill Falls Trail, adventure beckons from your doorstep.Why just visit when you can own? This isn't merely a home; it's a launchpad for endless adventures and cherished moments. So, why wait? Life is too precious for mundane living spaces. Your extraordinary Tannersville retreat awaits your arrival.
MlsNumber: 152031


Listing Provided By: Dugo Realty, original listing
Name: Dugo Realty
Phone: 719-5926
Office Name: Dugo Realty
Office Phone: 719-5926
Agent Name: Jason Dugo
Disclaimer: Copyright © 2024 Columbia Greene and Northern Dutchess MLS. 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

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 = 1842 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;
Real Estate Expert Photo for Kathleen Maxwell
Kathleen Maxwell
ASCIIKeller Williams Realty Hudson Valley North
Call Today!: (845) 430-1054

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App