Recently Listed Open House 7/19 1pm - 3pm
14027 247th Street
Rosedale, NY, 11422 $ 1,595,000
Bedrooms6 Baths5.0 Sq 5,000 Monthly Estimate*
$ 10,071
for $1,595,000 with 6 bedrooms and 5 full baths. This 5,000 square foot home was built in 2026 on a lot size of 0.1148.
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!
See more
Open House
7/19/2026 1:00 PM - 3:00 PM
14027 247th Street Rosedale, NY
* Some states or local ordinances may prohibit Open Houses at this time, please confirm with your Weichert agent or local rep to confirm
FeaturesInteriorInterior 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
Basement Finished Full
Basement Features Finished Full
Basement (Y/N) Y
Total Bedrooms 6
Total Baths 5
See more
GeneralSewer Public Sewer
Heating ENERGY STAR Qualified Equipment
Cooling ENERGY STAR Qualified Equipment
Utilities Natural Gas Connected
Garage Spaces 1
Construction Materials Brick Frame
Year Built 2026
Property Subtype Duplex
Tax Year 2025
Parcel Number 13597-0020
County Queens
Property Type Residential Income
Garage Y/N Y
Full Baths 5
High School Contact Agent
City New York
Senior Community Y/N N
High School District Contact Agent
Number Of Units Total 2
Carport Y/N N
Elementary School Contact Agent
Property Attached Y/N N
Tax Annual Amount 7197
Middle/Junior High School Call Listing Agent
Building Area Units Square Feet
Standard Status Active
Middle/Junior School District Contact Agent
Elementary School District Contact Agent
Tax Assessed Value 56040
See more
ExteriorParking Features Driveway Garage Private Driveway Garage Private
Water Source Public
Waterfront Y/N N
See more
* Excluded FeaturesList ByGabriel KashiListing Agent
Keystone Realty Usa CorpBroker
Affordability Calculator
- Monthly Principal & Interest
- $10,071
- Monthly Property Taxes
- $600
- Monthly Home Insurance
- --
Default based on a 30-year fixed rate of 6.49% with 20% down. The estimated payment is offered for convenience and is not an offer of credit. Due to market fluctuations, interest rates are subject to change at any time and without notice. Your individual rate may vary. Rates may differ for FHA, VA or jumbo loans.
Learn more about how to save NearbyMulti-family listings in Rosedale, NY
Average List Price $1,057,497
Percent of Sale Price 34%
About Rosedale, NY 31,714 Population
3% Since 2002
$ 84,261 Median Income
38.25 Median Age
33% Households with Children
Trends Information provided by ATTOM Data Solutions.
4892219 Elementary School
5162815 Middle School
Contact Agent High School High School
Pricing History| Date | Price | Price Change | Description |
|---|
| 7/17/2026 | $1,595,000 | | Listed Price |