No photo available
$1,595,000 Just Listed
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!
Full Property Details
Full Property Details for 140-27 247th St
General
- Price: $1,595,000
- Taxes: $7,197
- Status: Active
- Type: Multi-Family
- Source: Long_Island
- MLS ID: 1027504
- Updated: Today (7/17/2026)
- Added to Site: Today
Interior
- Interior Features: 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
Rooms
Bathrooms
- Total Bathrooms: 5
- Full Bathrooms: 5
Bedrooms
- Total Bedrooms: 6
Parking
- Garage: Yes
- Garage Spaces: 1
- Parking Features: Driveway, Garage, Private
Location
- County: Queens
School Information
- High School District: Contact Agent
- Elementary School: Contact Agent
- Middle School: Call Listing Agent
- High School: Contact Agent
Heating & Cooling
- Cooling Type: ENERGY STAR Qualified Equipment
- Heating Type: ENERGY STAR Qualified Equipment
Utilities
- Sewer: Public Sewer
- Water: Public
- Utility Description: Natural Gas Connected
Structural Information
- Detached/Attached: Detached
- Construction: Brick, Frame
- Basement: Yes
- Basement Desc.: Finished, Full Basement
- Year Built: 2026
Lot Features
- Lot Size (Acres): 0.1148
- Lot Size (Sq. Ft.): 5,000
Financial Considerations
- Tax Amount: $7,197
Disclosures and Reports
- Special Conditions: None
- Property ID: 13597-0020
Listed by Keystone Realty USA Corp
Get Pre-Approved Today
Schools
Schools serving 140-27 247th St
School District:New York City Geographic School District 29
| Name | Grades | Distance |
|---|---|---|
P.S. / M.S. 138 Sunrise 251-11 Weller Ave, Queens, NY 11422 | K-8 | 0.2 mi |
Community Voices Middle School 145-00 Springfield Blvd, Queens, NY 11413 | 6-8 | 1.3 mi |
Collaborative Arts Middle School 145-00 Springfield Blvd, Queens, NY 11413 | 6-8 | 1.3 mi |
Disclaimer:
School attendance boundaries provided by ATTOM Data Solutions and are for reference only. Contact the school directly to verify enrollment eligibility.
Price & Sales History for 140-27 247th St
Date
Details
Price
Change
Source
7/17/2026
Listed
$1,595,000
135.95%
MLS
12/04/2025
Sold
$676,000
—
Public Record
Disclaimer: Historical sales information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.
Tax History
Tax History for 140-27 247th St
Year
Property Taxes
Change
Tax Assessment
Change
2025
$7,365
—
$38,179
—
2025
$7,365
—
$38,090
-14%
2024
$7,330
10%
$44,040
27%
2023
$6,681
5%
$34,664
-4%
2022
$6,345
2%
$36,120
13%
2021
$6,197
—
$31,920
4%
2020
$6,219
1%
$30,780
-4%
2019
$6,185
18%
$32,100
11%
2017
$5,256
—
$28,887
6%
2017
$5,256
9%
$27,253
6%
2016
$4,830
2%
$25,712
—
2015
$4,719
3%
$25,712
1%
2015
$4,583
19%
$25,516
6%
2013
$3,842
—
$24,073
—
Disclaimer: Historical tax information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.
Estimate the Cost
Estimate the Cost for 140-27 247th St
14027 247th Street, Rosedale, NY 11422 (MLS# 1027504) is a Multi-Family property with 2 units containing 6 bedrooms and 5 full bathrooms. 14027 247th Street is currently listed for $1,595,000 and was received on July 17, 2026. Want to learn more about 14027 247th Street? Do you have questions about finding other Multi-Family real estate for sale in Rosedale? You can browse all Rosedale real estate or contact a Coldwell Banker agent to request more information.
