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 = 3378 AND i.igate IN ('usahud','gahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'gahud', 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 = 3378 AND i.igate IN ('usahud','gahud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'gahud', 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 = 3378 AND i.igate IN ('usahud','gahud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'gahud', 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;

403 137th Street
Rockaway Park, NY 11694

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,249,000
Beds: 4
Baths: 3
Status: Active
SqFt: 2455
Agency: Revived Residential

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 8,000 sqft
Property Type: Residential
Year Built: 1940
Notes: Welcome to your dream home. This is an opportunity of a lifetime to own a 80 x 100ft. property in one of the most sort after beach neighborhoods in New York City, The Rockaways. The main floor features a, formal dining room, living room with wod burning fireplace, eat-in kitchen, sunroom and full bathroom. The second floor has 4 large bedrooms and 2 bathrooms. Master bedroom suite includes master bathroom. The large attic can be easily converted into extra living space. Finished basement with ample storage, laundry room, pantry and dry sauna. Massive rear yard ready for you to design the outdoor oasis of your dreams. Parking for 4 cars plus a 1 car garage. Close proximity to NYC Ferry, A tain, express buses and JFK Airport.<br /> Welcome to your dream home. This is an opportunity of a lifetime to own a 80 x 100ft. property in one of the most sort after beach neighborhoods in New York City, The Rockaways. The main floor features a, formal dining room, living room with wod burning fireplace, eat-in kitchen, sunroom and full bathroom. The second floor has 4 large bedrooms and 2 bathrooms. Master bedroom suite includes master bathroom. The large attic can be easily converted into extra living space. Finished basement with ample storage, laundry room, pantry and dry sauna. Massive rear yard ready for you to design the outdoor oasis of your dreams. Parking for 4 cars plus a 1 car garage. Close proximity to NYC Ferry, A tain, express buses and JFK Airport.
MlsNumber: 480085


Listing Provided By: Revived Residential, original listing
Name: Revived Residential
Phone: (929) 469-5800
Office Name: Revived Residential
Office Phone: (929) 379-3750
Agent Name: Joseph C. Forzano
Disclaimer: Copyright © 2024 Brooklyn New York Multiple Listing Service. 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