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

11545 237th St
Elmont, NY 11003
Michael Rastegar with Re/Max Elite, original listing - (718) 690-3900

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $799,998
Beds: 6
Baths: Full: 3
Status: Active
SqFt: 2087 Square Feet
Agency: Re/Max Elite
Agency Phone: (718) 690-3900

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1941
Notes: Discover this spacious Cape Cod-style home on a quiet, tree-lined street in prime Elmont. Featuring six bedrooms and three modern bathrooms, this beautifully updated residence blends classic charm with modern convenience. A manicured lawn, lined with electrical and solar-powered lighting for excellent evening visibility, leads to a large, partially enclosed brick patio and an inviting front entry. Step inside to a bright and open living and dining area with high ceilings and recessed lighting, offering plenty of space for large furniture. The home is equipped with central heating and air conditioning, ensuring year-round comfort. The chef's kitchen boasts top-quality stainless steel appliances, ample cabinetry, a stylish tile backsplash, and large windows that fill the space with natural light. Down the hall, you'll find a full bathroom and two spacious bedrooms, both with generous closet space. Upstairs, a long hallway leads to another full bathroom and two oversized bedrooms, each offering abundant storage. The high-ceiling basement provides incredible versatility. To the right of the staircase, a large recreation room offers endless possibilities and is often repurposed into additional private spaces. To the left of the staircase, you'll find a full bathroom, a well-sized bedroom, a family room that can also serve as a bedroom, and a utility room. Outside, the expansive backyard is perfect for entertaining, with plenty of space for gatherings, outdoor dining, and relaxation. A long private driveway, lined with solar-powered lights for added visibility and ambiance, accommodates five to six cars and leads to a detached one-car garage. A separate side entrance provides convenient access from the driveway directly into the home. Two sets of solar panels, costing approximately one hundred dollars per month in total, are transferable to the new owner. This is a rare opportunity to own a home that seamlessly blends timeless design with modern upgrades in Elmont! PLEASE READ: All showings are exclusively conducted through open houses; private viewings are NOT an option, so kindly refrain from requesting a private viewing as we are unable to accommodate such request. Open House times will be posted one week prior to the scheduled open house to allow ample planning time. We ask that all interested parties keep it saved online so you can receive notifications about upcoming open house times, and when an upcoming open house time is made available, you'll be notified. Brokers/Agents have the option to send their clients to the open house by texting or emailing buyer information ahead of time if they cannot attend together. Disclaimer: All information provided is deemed reliable, but is not guaranteed and should be independently verified.
MlsNumber: --
ListingId: 11447192


Listing Provided By: Re/Max Elite, original listing
Phone: (718) 690-3900
Office Phone: (718) 690-3900
Agent Name: Michael Rastegar
Disclaimer: Copyright © 2025 My State 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 = 3393 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;
Serimatie Lakhnath
ASCIIeXp Realty
Call Today!: (516) 581-5075

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App