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','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 = 3378 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 = 3378 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;

136 Beach 117th Street
Rockaway Park, NY 11694
Gregory Valvo with Revived Residential, original listing - (929) 379-3750

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $888,000
Beds: 2
Baths: Full: 2
Status: Active
SqFt: 1322 Square Feet
Agency: Revived Residential
Agency Phone: (929) 379-3750

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Property Type: Residential-Condominium
Year Built: 2006
Notes: Ever dream of waking up to breathtaking direct ocean views and living literally from the beach? If so, then welcome to your dream condo located in the Ocean Grande building, in the vibrant Rockaway Park section of the Rockaways! This unit boasts an impressive 1,322 square feet floor plan. Just come into this magnificent well-designed space and be greeted by an airy living room featuring high 8' ceilings, real Bamboo hardwood floors throughout and excellent southern exposures that pours sunlight through the expansive windows and fill each room with a warmth that highlights the stunning ocean view. The modern kitchen is a culinary enthusiast's dream, featuring sleek, new or recently updated stainless appliances, a convenient pass-through with plenty of new cabinetry to handle all your storage needs. Accentuated by a stylish stone countertop and beautiful backsplash your new kitchen comes 100% complete with a dishwasher, wine fridge and a convenient GE dual washer/dryer. On one side of the home, you have the common bathroom, which is well crafted, and is positioned close to the secondary bedroom. Entering in your immediately impressed by the bedrooms size, beautiful Bamboo flooring, dedicated walk-in closet and of course the beautiful unobstructed view of the ocean. The primary suite is located on the other end of the home and is its very own private oasis. With more beautiful Bamboo flooring, another dedicated walk-in closet, an absolutely gorgeous en-suite bathroom which includes a stylish double vanity with a separate bathtub on one side and glass shower stall on the other. Of course, another breathtaking ocean view from the primary is great but the private balcony which is accessed through the living room and quite possibly the perfect place to escape, enjoy the fresh ocean breeze and endless million-dollar views. The cherry on top is that this unit comes with its own parking area which holds 2/3 vehicles plus storage! See you soon!
MlsNumber: --
ListingId: 492431


Listing Provided By: Revived Residential, original listing
Phone: (929) 379-3750
Office Phone: (929) 379-3750
Agent Name: Gregory Valvo
Disclaimer: Copyright © 2025 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