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;

369 Newry Lane
Greenville, NY 12083
PattiAnn Mangold Andrejcak with Berkshire Hathaway HomeServices Blake, REALTORS®, original listing - 687-2222

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $530,000
Beds: 3
Baths: Full: 2
Status: Active
SqFt: 1983 Square Feet
Agency: Berkshire Hathaway HomeServices Blake, REALTORS®
Agency Phone: 687-2222

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 3 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1978
Notes: Once Upon A Time there were buyers,they had been looking for yrs for their dream home in the country but the market was very competitive & there was very low inventory.Until One Day they were searching the MLS & they saw this new listing.Could this Be the One, they thought? They immediately picked up the phone & made an apt. to see the home the next day. As they turned onto this lovely country rd. they couldn't help but notice all the well kept homes.Then as they approached the For Sale home,they saw how nicely it was set back from the rd. & how private the setting was.They were delight as they drove up the driveway & saw how bright & lovely the home looked,the large garage& the beautiful yard.The 1,983 sq ft Country Contemporary had been lovingly & professionally remodeled.Outside,they noticed the new siding,new roof,facia,soffits,gutters & new doors,on both the house & the 900 sq ft heated garage.There was a huge 12' x 24' deck off the great room,a new deck & stairs leading to the front entrance & a new 8' x 22' covered side porch & sidewalk that led to the lower level entrance.Inside the home there were cathedral beamed ceilings,beautiful new luxury vinyl floors,tile floors & carpeting. A completely new kitchen with granite counters,an island & new appliances.New paint & new trim work throughout.The new windows in the GR brought in so much light & natural beauty.We loved the new wood stove,chimney & stone work.We could absolutely picture ourselves enjoying our winter evening being warmed by the fire.We were so impressed that there was All new electrical wiring,new outlets,switches & new lighting.We loved that we would be able to Save on heating & cooling costs with the New high efficiency LP gas furnace with central AC for the lower level & main level & high efficiency heat pump for the upper level.New underground electric meant no ugly wires & poles & the plumbing piping was all new as well as a new pressure tank, Wow! The upper level bath was beautifully remodeled, the main level bath was partially remodeled. We loved the family room & game room & could see ourselves spending a lot of fun time there. The garage also had new concrete floors,insulation,doors,paint & heat as well. The covered area behind garage,also had a new concrete floor. We were so excited & didn't hesitate, we put an offer in right away. We knew we would be Getting the Most for Our Money with this home, & it would be the Perfect Place to Hang Our Hat'. Dreams Really Do Come True.
MlsNumber: --
ListingId: 154702


Listing Provided By: Berkshire Hathaway HomeServices Blake, REALTORS®, original listing
Phone: 687-2222
Office Phone: 687-2222
Agent Name: PattiAnn Mangold Andrejcak
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 Lisa Jaeger
Lisa Jaeger
ASCIIColdwell Banker Village Green Realty
Call Today!: (518) 755-2573

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App