x
Showing 1 of 0
X
Save

14027 247th Street
Rosedale NY 11422 US

$1,595,000

Active Listing ID 1027504
bed icon
6 bed
bath icon
5.00 Bath (5 Full)
lot icon
Lot: 0.11 Acres
home icon
Duplex

$1,595,000

Active Listing ID 1027504
Save

14027 247th Street 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!

Collapse all

Property Features

  • Facts
  • Lot Size: 0.11 Acres
  • Property Type: Residential Multi Family
  • Property Sub-type: Duplex
  • Features
  • Full Bathrooms: 5
  • Cooling System: ENERGY STAR Qualified Equipment
  • Heating Fuels: Energy Star Qualified Equipment (Heating)
  • Additional Features
  • Basement

School Information

  • School
  • Contact Agent(Elementary)
  • Call Listing Agent(MiddleSchool)
  • Contact Agent(HighSchool)

Property

  • propertytype: Residential Multi Family
  • propertysubtype: Duplex
  • listprice: 1595000
  • unparsedaddress: 14027 247th Street
  • postalcity: Rosedale
  • stateorprovince: NY
  • country: US
  • postalcode: 11422
  • bathroomsfull: 5
  • bathroomshalf: 0
  • bathroomsonequarter: 0
  • bathroomsthreequarter: 0
  • lotsizeacres: 0.1148
  • lotsizeunits: Acres
  • lotsizearea: 0.1148
  • livingarea: 0
  • livingareaunits: Square Feet
  • latitude: 40.663155
  • longitude: -73.734751
  • listagentfullname: Gabriel Kashi
  • listagentemail: gabriel@ksrealtyny.com
  • listagentkey: 3yd-MLSLINY-163722
  • listagentmlsid: 163722
  • listagentpreferredphone: 3474195268
  • listofficekey: 3yd-MLSLINY-KEEG02
  • listofficemlsid: KEEG02
  • disclaimer: Copyright © 2026 OneKey MLS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.
  • sourcesystemid: MLSLINY
  • yearbuilt: 2026
  • listingcontractdate: 2026-07-17
  • listagentfax: 6312616210
  • listagenturl: http://www.keystonerealtyusa.com
  • countyorparish: Queens
  • parcelnumber: 13597-0020
  • elementaryschool: Contact Agent
  • highschool: Contact Agent
  • elementaryschooldistrict: Contact Agent
  • middleorjuniorschooldistrict: Contact Agent
  • highschooldistrict: Contact Agent
  • cooling: ENERGY STAR Qualified Equipment
  • constructionmaterials: Brick, Frame
  • heating: Energy Star Qualified Equipment (Heating)
  • numberofunitstotal: 2
  • fireplaceyn: False
  • transactiontype: ForSale
  • storiestotal: 0
  • parkingtotal: 0
  • parkingfeatures: Driveway, Garage
  • waterfrontyn: False
  • franchiseaffiliation: None
  • interiorfeatures: 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: Bedroom 1, Bedroom 4, Bathroom 5, Bedroom 6, Bathroom 4, Bathroom 2, Bathroom 1, Bedroom 2, Bedroom 5, Bathroom 3, Bedroom 3, Basement
  • basement: Finished, Full
  • dock: False
  • poolprivateyn: False
  • spayn: False
  • internetaddressdisplayyn: True
  • internetautomatedvaluationdisplayyn: False
  • internetconsumercommentyn: False
  • location: -73.73475, 40.663155
  • customfields: {"AdditionalInformation":{}, "AlternatePrices":[], "BrokerName":"Keystone Realty USA", "BuilderEmail":null, "BuilderFax":null, "BuilderPhone":null, "City":null, "Country":null, "CustomSourceId":null, "Expenses":[], "GeocodeOptions":null, "LeadRoutingEmail":"gabriel@ksrealtyny.com", "ListBrokerageCity":"E. Northport", "ListBrokerageCountry":"US", "ListBrokerageEmail":"keystonerealty1@aol.com", "ListBrokerageLogoUrl":"http://brokerlogos.listhub.net/MLSLINY/c5ababc31ce7cff2011ce8417bee2786/20081013122954037.bmp", "ListBrokerageName":"Keystone Realty USA", "ListBrokeragePhone":"631-486-1126", "ListBrokeragePostalCode":"11731", "ListBrokerageStateOrProvince":null, "ListBrokerageUnitNumber":null, "ListBrokerageUnparsedAddress":"384 Larkfield Rd Suite 6", "ListBrokerageWebsiteUrl":"http://www.keystonerealtyusa.com", "ListOfficeAddress1":"60 E Main St ", "ListOfficeAddress2":null, "ListOfficeBrokerMlsId":"KEEG02", "ListOfficeCity":"Kings Park", "ListOfficeCountry":"US", "ListOfficeEmail":"keystonerealtydesk@gmail.com", "ListOfficePostalCode":"11754", "ListOfficeStateOrProvince":"NY", "ListPriceCurrencyType":"USD", "ListingTitle":"MULTI_FAMILY - Rosedale, NY", "ListingURL":"https://www.realtor.com/realestateandhomes-detail/14027-247th-St_Rosedale_NY_11422_M48688-31963?f=listhub&s=MLSLINY&m=1027504&c=rexren", "MLSModificationTimestamp":"2026-07-25 11:24:37", "Neighborhoods":[], "PostalCode":null, "RoomCount":null, "StateOrProvince":null, "Taxes":[{"TaxAnnualAmount":7197, "TaxDescription":null, "TaxYear":"2025"}], "UnitNumber":null, "UnparsedAddress":null}
Listing Changed: 7/25/2026 11:44:15 AM GMT
Source Updated Date: 7/26/2026 12:50:39 AM GMT

Courtesy of: Gabriel Kashi, Keystone Realty USA Corp, gabriel@ksrealtyny.com

Copyright © 2026 OneKey MLS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.