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

150 Beach 123rd Street
Rockaway Park, NY 11694
Christopher Moriarty with eXp Realty BKNY, original listing - (888) 276-0630

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $579,999
Beds: 2
Baths: Full: 2
Status: Active
SqFt: 1060 Square Feet
Agency: eXp Realty BKNY
Agency Phone: (888) 276-0630

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Property Type: Residential-Condominium
Year Built: 1982
Notes: Gorgeous and spacious 2-bedroom, 2-bathroom, 1st floor condo just minutes to the beach and zoned for PS/MS 114, is just hitting the market in Rockaway Park! There’s a lot of wonderful open space in this home, with the living room and dining room centrally located off the well apportioned and windowed kitchen. Afternoon sunlight is a delight in the front rooms highlighted with an enormous bench seat bay window. Down the long hallway you pass the first full bathroom which is clean and bright and several closets including a big utility closet for storage and also home to the washer and dryer. Further down are the two large bedrooms; one has a huge walk-in closet and the larger of the two has his-and-hers closets and its own full bathroom en-suite. The apartment is in outstanding living condition with sunken studio-lighting, ceiling fan and new ceramic flooring throughout the home except the bedrooms which are carpeted; there’s also 3 brand new high-efficiency air conditioning units for added comfort! This terrific beach-block condo comes with its very own private parking space along with 2 guest parking spots and a common closet for your beach chairs. Recent capital improvements include newly pointed brick and an entirely new roof, all fully paid for. This is currently a self-managed building with low HOA fees and the location is superb; short distance to the A train on 116th and up to 129th Street where outstanding local restaurants and shops have everything you need. Nearby you’ll also find the popular Rockaway Ferry that can whisk you downtown in minutes! 123rd Street is a well-kept and beautiful block, and this lovely home is just minutes away from the star of the show itself, Rockaway Beach! Call for your private showing today!
MlsNumber: --
ListingId: 487672


Listing Provided By: eXp Realty BKNY, original listing
Phone: (888) 276-0630
Office Phone: (888) 276-0630
Agent Name: Christopher Moriarty
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