$2,300,000
5 Bed • 3 Bath • 2,918 Sq. Ft.5 bd · 3 ba · 2,918 sqft
154-90 Riverside Drive
Beechhurst, NY 11357
Listed with BH&G R E Realty Connect
$2,199,777
Est. $12,606/moRidgewood, NY 11385 · Queens
Know your budget before you tour. Get pre-qualified
PRIME RIDGEWOOD MIXED-USE INVESTMENT OPPORTUNITY 568 Grandview Avenue, Ridgewood, NY 11385 3 Residential Apartments | 1 Commercial Storefront | 4-Car Garage | 4,508 Sq. Ft. LOCATION. INCOME. POTENTIAL. An exceptional opportunity to acquire a substantial brick mixed-use property in the heart of vibrant Ridgewood, Queens! Situated along a bustling neighborhood corridor, this versatile property offers an attractive combination of residential and commercial income potential, generous space, and outstanding accessibility. Featuring three residential apartments and one commercial storefront, the building offers a functional layout designed for flexibility and independent access. The first floor features a street-facing retail storefront and a rear one-bedroom apartment with a living room, kitchen, and full bathroom. The second floor offers a spacious two-bedroom apartment with a living room, kitchen, and full bathroom. The third floor features an expansive four-bedroom apartment with a living room, kitchen, and full bathroom. Additional highlights include a four-car attached garage with independent access, a full basement extending approximately 95 feet in depth, gas heating and hot water, and separately metered gas and electric service for each unit. Boasting approximately 4,508 square feet of building area, this solid brick property is ideally positioned near neighborhood shops, restaurants, entertainment, laundromats, houses of worship, and everyday conveniences. Excellent access to buses, subway transportation, major highways, and area airports provides connectivity throughout Queens, Brooklyn, Manhattan, and beyond. Enjoy the added appeal of city views and the convenience of urban living. A RARE OPPORTUNITY IN A HIGHLY DESIRABLE LOCATION! Whether you're an investor seeking a multi-income asset or an owner-user looking to establish a business while benefiting from residential rental income, 568 Grandview Avenue presents a compelling opportunity to secure a versatile property in one of Queens' established neighborhoods. Prime Location. Multiple Income Streams. Exceptional Potential. Alternative MLS # 1071885
As reported by the listing office; verify enrollment with the district.
Listed with Keller Williams Realty Liberty · Chatter Singh · Source: OneKey MLS
Information provided by One Key MLS, and is deemed reliable but not guaranteed accurate. Data last updated: Nov 19, 2026, 4:07 PM ET. ©2026 One Key MLS.
Estimate your mortgage payment, including the principal and interest, taxes, insurance, HOA, and private mortgage insurance.
Estimated monthly payment
Representative rates
Representative rates only, indicative for comparison. Edit the interest rate for your own quote; your lender’s numbers vary with credit, points, and insurance.
Be the first to know when a Queens home hits the market.
Market insights
Current listings
New in the last 30 days
15
Nov 2026
Average price
Active listings
$1,495,466
Nov 2026
Average days on market
Active listings
179 days
Nov 2026
Computed from 106 active OneKey MLS listings in Ridgewood, NY.
$2,300,000
5 Bed • 3 Bath • 2,918 Sq. Ft.5 bd · 3 ba · 2,918 sqft
154-90 Riverside Drive
Beechhurst, NY 11357
Listed with BH&G R E Realty Connect
$2,580,000
6 Bed • 6.5 Bath • 3,194 Sq. Ft.6 bd · 6.5 ba · 3,194 sqft
5803 218th Street
Oakland Gardens, NY 11364
Listed with B Square Realty
$1,600,000
8 Bed • 6 Bath8 bd · 6 ba
16323 Sayres Avenue
Jamaica, NY 11433
Listed with EXIT Realty Central