Vino Sharma
Vino Sharma
Call: (347) 526-5483
Text: (347) 526-5483
MLS#1027504
STATUSActive
PROPERTY TYPEMulti Unit - Multiple
SCHOOLContact Agent
Property Description
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!
Property Features
Property Type: Multi Unit - Multiple
Basement: Finished, Full
Basement: Yes
Cooling: ENERGY STAR Qualified Equipment
Garage: 1
Heating: ENERGY STAR Qualified Equipment
Lot Size: 0.11 Acres
Taxes: $7,197
Year Built: 2026
Amenities
First Floor Bedroom
First Floor Full Bath
Cathedral Ceiling(s)
Chandelier
Chefs Kitchen
Granite Counters
Kitchen Island
Open Kitchen
Primary Bathroom
Master Downstairs
Recessed Lighting
Washer/Dryer Hookup
Feature Descriptions
Days on Site: 1
Exterior: Brick, Frame
GarageY/N: Yes
On Market Date: 2026-07-17
Parcel Number: 13597-0020
Parking Features: Driveway, Garage, Private
Rental Term: Monthly
Sewer: Public Sewer
Units: 2
Utilities: Natural Gas Connected
Water: Public
Local Schools
High School: Contact Agent
Elementary School: Contact Agent
School District: Contact Agent
TOUR THIS HOME
Choose a date and time to see 14027 247th Street , Rosedale, NY 11422.
An agent will get in touch to confirm your request shortly.
Estimate Your Payment
Estimated Payment
$ 4,614.74 per month $3,549.78 Principal & Interest $599.75 Property Tax $465.21 Homeowner's InsuranceChange Payment Information
Listed By / Shown By
Listing By
Agency Name: Keystone Realty USA Corp
Agency Contact: 631-261-2800
Shown By
Agent Name: Vino Sharma
Agent Phone: (347) 526-5483
Agency Title: Laffey Real Estate
14027 247th Street | MLS# 1027504
This multi-family property located at 14027 247th Street , Rosedale, NY 11422 is currently listed for sale with an asking price of $1,595,000. 247th Street is located within the Contact Agent school district. Search Rosedale real estate on vinosharma.laffey.com today.