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

20 Church Lane
Middle Island, NY 11953
Laura Kraker with Exit Realty Achieve, original listing - (631) 543-2009

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $529,999
Beds: 2
Baths: Full: 1
Status: Pending
SqFt: 1379 Square Feet
Agency: Exit Realty Achieve
Agency Phone: (631) 543-2009

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Property Type: Residential-Single Family Residence
Year Built: 1945
Notes: Welcome to 20 Church Ln. in Middle Island, a truly special ranch stlye home nestled on a 2-acre level lot offering endless possibilities. Whether you're a horse enthusiast seeking an equestrian retreat or envision a property ideal for agriculture and gardening, this home provides the perfect canvas, including space for an inground pool, entertaining areas, or even exploring the potential for a subdivision. As you step onto the covered front porch, you're welcomed into a charming and updated ranch featuring a spacious living room, a newly updated wood kitchen (2021) with quartz countertops and black stainless steel appliances (2017), including a propane gas stove, a formal dining room, and a huge primary bedroom. The full bathroom, beautifully updated in 2023, and the second bedroom complete the main level, which also features wood Anderson windows (2019) throughout most of the house and wood floors adding warmth and character. Storage abounds with a full basement that spans the entire footprint of the 1,379-square-foot main level, offering indoor and outdoor access, as well as a full attic. An oversized driveway leads to a two-car detached garage. The screened-in back patio opens to the expansive yard that is perfect for enjoying peaceful evenings in your private oasis. Located across from a 10-acre nature preserve, this home offers exceptional privacy and serenity, making it an ideal retreat while still being close to modern conveniences. This property is more than a home-it's an opportunity to create the lifestyle you've been dreaming of!
MlsNumber: --
ListingId: L3593100


Listing Provided By: Exit Realty Achieve, original listing
Phone: (516) 220-2385
Office Phone: (631) 543-2009
Agent Name: Laura Kraker
Disclaimer: Copyright © 2024 OneKey MLS. 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