$1,849,000
3 Bed • 3.5 Bath • 2,201 Sq. Ft.
158-31 86th Street
Howard Beach, NY 11414
Listed with Century 21 Amiable Rlty Grp II
$1,555,000
Est. $8,459/moRosedale, NY 11422 · Queens
Know your budget before you tour. Get pre-qualified
Whether you're seeking a sophisticated primary residence with supplemental income or a valuable addition to your investment portfolio, this remarkable property offers the perfect blend of luxury, flexibility, and long-term value. This custom built brand new construction two family will captivate you from the moment you arrive with its warm & welcoming energy. Ideal for buyers looking for space, plus income generating rental property to assist with mortgage payments. Welcome to 140-27-247th Street! Sitting on a 50x100 lot on a beautiful picturesque block of Rosedale! Featuring a wide private driveway, garage, and tons of yard space to enjoy outdoor gatherings. Offering two 3 bedroom 2 bath units over a high ceiling full finished basement with both interior and exterior access. Both units enjoy modern, open concept living/dining areas which provide great space for entertaining. Beautiful chefs granite kitchens equipped with floor to ceiling custom cabinetry, adorned with a full fleet of stainless steel appliances and equipped with island for bar stool seating. Well proportioned bedrooms with ample closet space. The primary suite is your private escape. Featuring a private en suite with spa like finishes. Fully tiled bathrooms that boast state of the art wall & floor tiles. The high ceiling full finished basement can easily be used as a media den, guest quarters, additional recreational space or ADU. This exceptional two family presents a rare opportunity to own a piece of Rosedale while enjoying the space, privacy, and lifestyle the neighborhood has to offer. Conveniently located with close proximity to major transportation which makes commuting a breeze. Just off Francis Lewis Blvd, Memphis Avenue, S Conduit, Belt Parkway. Short blocks to schools, Green Acres Commons, JFK Airport, restaurants, cafes, parks and many other vibrant neighborhood amenities. Do not miss your opportunity to own one of the last houses in the Rosedale market that checks all the boxes for modern day luxury, space, & style!
Listed with Keystone Realty USA Corp · Gabriel Kashi · Source: OneKey MLS
Information provided by One Key MLS, and is deemed reliable but not guaranteed accurate. Data last updated: Sep 18, 2026, 7:07 AM 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
23
Sep 2026
Average Price
Active listings
$880,597
Sep 2026
Average Days on Market
Active listings
137 days
Sep 2026
Computed from 113 active OneKey MLS listings in Rosedale, NY.
$1,849,000
3 Bed • 3.5 Bath • 2,201 Sq. Ft.
158-31 86th Street
Howard Beach, NY 11414
Listed with Century 21 Amiable Rlty Grp II
$1,899,000
7 Bed • 4 Bath
38-04 111th Street
Corona, NY 11368
Listed with City Homes Realty Group LLC
$1,449,900
6 Bed • 3 Bath
7104 67th Place
Ridgewood, NY 11385
Listed with Douglas Elliman Real Estate