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;

5 Ethan Allen
Ridge, NY 11961
Michael Mendicino GRI CRS CBR CRB with Millennium Homes, original listing - (631) 206-0722

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,250,000
Beds: 2
Baths: Full: 1, ½: 1
Status: Active
SqFt: 966 Square Feet
Agency: Millennium Homes
Agency Phone: (631) 206-0722

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Property Type: Residential-Townhouse
Year Built: 1972
Notes: This is a Package of 4 Properties that must be sold together.. 5 D Ethan Allen Ct 2 Story 1 1/2 Baths Vacant Taxes $3856 .. 1 C Ticonderoga Ct 2 Story 1 1/2 Bathrooms . Will Be Vacant Taxes $3,856 .. 1 A James Town Ct 1 Story 1 Bath Vacant Taxes $3,414. 3 A Valley Forge Ct 2 Story 1 1/2 Baths Vacant Taxes $3,856.. all have Same Common Charges of $220. Monthly.. These are PUDS Planned Unit Development. They Look Like Town Houses or Condos in Strathmore Ridge... Taxes are stated for 2025 as per Brookhaven.. All have been Brookhaven town and Section 8 inspected with current up to date Rental Permits... These are or will be Vacant, No Need for Rent or Tenant Questions. Charge Market Rent to the Tenants of your Choice... Excellent Reoccurring Low expenses, Low Taxes and Low Common Charges.. For all Complex Information.. Bylaws, Prospectus ETC ... See Strathmore Ridge Website .. Strathmoreconnect.com.. This is a Nice way to pick up 4 Doors at one time... Good Luck Everyone
MlsNumber: --
ListingId: 809110


Listing Provided By: Millennium Homes, original listing
Phone: (631) 206-0722
Office Phone: (631) 206-0722
Agent Name: Michael Mendicino GRI CRS CBR CRB
Disclaimer: Copyright © 2025 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