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;

128 Norman Street
New Hyde Park, NY 11040
Ivan Mijalkovic with Corcoran, original listing - (929) 487-3500

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,100,000
Beds: 5
Baths: Full: 2
Status: Pending
SqFt: --
Agency: Corcoran
Agency Phone: (929) 487-3500

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Property Type: Residential-Single Family Residence
Year Built: 1943
Notes: Welcome to 128 Norman Street, a beautifully renovated home situated in the Herricks School District. This property is located on a 50x100-foot lot and features five bedrooms, two full bathrooms, a long private driveway with a garage, and a spacious backyard. As you enter this home through the charming front porch, you are greeted by stunning finishes illuminated by sunlight streaming in from four exposures. The living room boasts four large windows and sliding doors that lead out to a back deck, providing access to the expansive backyard. The kitchen is a highlight, featuring elegant quartz countertops and stainless steel appliances, including a dishwasher, double oven, double-door refrigerator and freezer, and a wine fridge. Ample cabinetry provides plenty of storage, and the large center island offers additional seating. There is also a door off the kitchen that leads directly to the driveway, making grocery unloading effortless. The kitchen seamlessly flows into the formal dining area, which is enhanced by beautiful bay windows overlooking the front yard. An extension has been added, creating a generous bonus room equipped with two double closets and access to a full bathroom. This space can serve as a fifth bedroom or a den. The second floor of the home includes four bedrooms, another full bathroom, and plenty of closet space. The basement features a washer and dryer, along with mechanicals, and was formerly used as a TV room but is currently utilized for storage. The inviting exterior of this home will charm you from the moment you walk down the block. There is access to the backyard from both sides of the property, a long private driveway, and a large garage located at the back. The spacious backyard offers plenty of privacy and serves as the perfect retreat after a long day. Renovated in 2018, this home is completely move-in ready and awaiting your personal touch., Additional information: Interior Features:Lr/Dr
MlsNumber: --
ListingId: L3592504


Listing Provided By: Corcoran, original listing
Phone: (347) 653-8010
Office Phone: (929) 487-3500
Agent Name: Ivan Mijalkovic
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