Buy
  • Alabama Alaska California Colorado Connecticut Delaware Florida Georgia Hawaii Louisiana Maine Maryland Mississippi New Hampshire New Jersey New York North Carolina Oregon Pennsylvania Rhode Island South Carolina Texas Virginia Washington
    Canada Listings (752)
    Mexico Listings (331)
    Central America Listings (627)
    Caribbean Islands Listings (44)
    Asia Listings (20) Europe Listings (9)
    Advanced Search
Sell Find an Agent
BeachHouse.com BeachHouse.com
My Account
  • Login
  • Manage My Real Estate Ads
  • Manage My Search Profile / Auto Notify
  • My Account Info
  • Manage My Favorites
Advertise Join
  • Buy
  • Sell
  • Find an Agent
  • My Account
    • Login
    • Manage My Real Estate Ads
    • Manage My Search Profile / Auto Notify
    • My Account Info
    • Manage My Favorites
  • Advertise
  • Join
Back to Search Back to Listing BeachHouse.com logo
Share
BeachHouse.com logo
Ad #7877944
MLS #968520
Listing photo

*** DO NOT DISTURB OCCUPANTS *** *** WILL BE DELIVERED OCCUPIED

13723 249th St, Rosedale, New York, 11422
$595,000
4Beds
2Baths
--Sqft
0.057Acres

About this property

*** DO NOT DISTURB OCCUPANTS *** *** WILL BE DELIVERED OCCUPIED *** Location truly doesn't get better than this. This legal 2-family home offers unbeatable convenience and exceptional potential. Just steps from Sunrise Highway and literally next to Green Acres Mall, everything you need is right at your doorstep - groceries, restaurants, retail shopping, banks, pharmacies, and everyday essentialsmuters will appreciate the easy access to major transportation routes and public transit, making travel throughout Queens, Brooklyn, and Long Island effortless. Despite being next to everything, the home sits on a quiet dead-end block, providing a peaceful residential setting with minimal traffic. The property also features a private driveway, adding valuable convenience and off-street parking. This property checks every box for investors and end-users alike. With a legal two-family layout, it presents an excellent opportunity for rental income, multi-generational living, or a strong long-term investment in a high-demand neighborhood. The home is being SOLD AS-IS, ALL CASH and is DRIVE-BY ONLY. Priced for a very quick sale.

Property Features

4 Beds
2 Baths
0 Sqft
Built in 1925
0.057 Acres
Driveway
Siding: Vinyl Siding
Natural Gas
$6,165 / yr property tax
Queens County

Contact Information

Hassan Z. Shah

Keller Williams Realty of Greater Nassau

929-261-6754

Location

Map
Listing Agent: Hassan Z. Shah 929-261-6754
Broker: Keller Williams Realty of Greater Nassau 516-873-7100 Listing Site
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.
BeachHouse.com
Printed Jul 24, 2026

Photo Gallery

*** DO NOT DISTURB OCCUPANTS *** *** WILL BE DELIVERED OCCUPIED - photo 1

$595,000

4
Beds
2
Baths
--
Sqft

13723 249th St, Rosedale, New York, 11422

By contacting this agent you agree to these Terms and Conditions.
Home New York Rosedale
*** DO NOT DISTURB OCCUPANTS *** *** WILL BE DELIVERED OCCUPIED - photo 1
MLS# 968520
Townhome/Townhouse For Sale

*** DO NOT DISTURB OCCUPANTS *** *** WILL BE DELIVERED OCCUPIED

$595,000

13723 249th St, Rosedale, New York, 11422

4
Beds
2
Baths
--
Sqft
0.057
Acres
$595,000
13723 249th St, Rosedale, New York, 11422
4 Beds
2 Baths
-- Sqft
0.057 Acres
*** DO NOT DISTURB OCCUPANTS *** *** WILL BE DELIVERED OCCUPIED *** Location truly doesn't get better than this. This legal 2-family home offers unbeatable convenience and exceptional potential. Just steps from Sunrise Highway and literally next to Green Acres Mall, everything you need is right at your doorstep - groceries, restaurants, retail shopping, banks, pharmacies, and everyday essentialsmuters will appreciate the easy access to major transportation routes and public transit, making travel throughout Queens, Brooklyn, and Long Island effortless. Despite being next to everything, the home sits on a quiet dead-end block, providing a peaceful residential setting with minimal traffic. The property also features a private driveway, adding valuable convenience and off-street parking. This property checks every box for investors and end-users alike. With a legal two-family layout, it presents an excellent opportunity for rental income, multi-generational living, or a strong long-term investment in a high-demand neighborhood. The home is being SOLD AS-IS, ALL CASH and is DRIVE-BY ONLY. Priced for a very quick sale.
17 days
on BeachHouse.com
35
views
0
saves

Property Details

HOME DETAILS

4 Beds
2 Baths
0 Sqft
Built in 1925
0.057 Acres

EXTERIOR

Driveway
Siding: Vinyl Siding

INTERIOR

Natural Gas

FINANCIAL & COMMUNITY

$6,165 / yr property tax
Queens County
See More Details

Location

Map
Open in Google Maps

Mortgage Calculator

Ad Statistics

Ad Number
7877944
Viewed
35 times
Listing Status
Active
Added
Jul 06, 2026
Last Refresh
Jul 24, 2026 04:01:17 PM

Listing Information

Data Source
OneKey MLS
Source Property ID
968520
Listing Agent: Hassan Z. Shah 929-261-6754
Broker: Keller Williams Realty of Greater Nassau 516-873-7100 Listing Site
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.

Request Information

By proceeding, you authorize Dream Home Network Inc., its service providers (including real estate professionals such as Brokers, Listing Agents, Buyers Agents, and local referral partners), its affiliates, and other real estate professionals that may not be associated with Dream Home Network, to contact you using the contact details you provided, via email, phone call, and text (SMS), including using automated dialing technology and prerecorded and artificial voice, for marketing or advertising purposes, including contacting you about your inquiry and other home-related matters. You understand that your consent to the foregoing is not a condition of any purchase. Message and data rates may apply. This consent applies even if you are on a corporate, state or national Do Not Call list. Dream Home Network Inc. may share information about your recent and future site activity with its affiliates and service providers (including real estate professionals such as Brokers, Listing Agents, Buyers Agents, and local referral partners) to help them better understand what you are looking for in a property. To opt-out at any time you can reply "STOP" or contact Dream Home Network Inc. at csv@dreamhomenetwork.com.

Start advertising today

Explore options for real estate agents and homeowners advertising on BeachHouse.com
Sell Your Home

Explore Similar Properties

For Sale
Two Family Detached House with Detached Garage. 1 1/2 Over 1 - photo 1
Two Family Detached House with Detached Garage. 1 1/2 Over 1 - photo 2
Two Family Detached House with Detached Garage. 1 1/2 Over 1 - photo 3
Two Family Detached House with Detached Garage. 1 1/2 Over 1 - photo 4
Two Family Detached House with Detached Garage. 1 1/2 Over 1 - photo 5
Two Family Detached House with Detached Garage. 1 1/2 Over 1 - photo 6
Two Family Detached House with Detached Garage. 1 1/2 Over 1 - photo 7
Two Family Detached House with Detached Garage. 1 1/2 Over 1 - photo 8
Two Family Detached House with Detached Garage. 1 1/2 Over 1 - photo 9
Two Family Detached House with Detached Garage. 1 1/2 Over 1 - photo 10
Two Family Detached House with Detached Garage. 1 1/2 Over 1 - photo 11
Two Family Detached House with Detached Garage. 1 1/2 Over 1 - photo 12
Two Family Detached House with Detached Garage. 1 1/2 Over 1 - photo 13
Two Family Detached House with Detached Garage. 1 1/2 Over 1 - photo 14
Two Family Detached House with Detached Garage. 1 1/2 Over 1 - photo 15
Two Family Detached House with Detached Garage. 1 1/2 Over 1 - photo 16
Two Family Detached House with Detached Garage. 1 1/2 Over 1 - photo 17
Two Family Detached House with Detached Garage. 1 1/2 Over 1 - photo 18
Two Family Detached House with Detached Garage. 1 1/2 Over 1 - photo 19
Two Family Detached House with Detached Garage. 1 1/2 Over 1 - photo 20
Two Family Detached House with Detached Garage. 1 1/2 Over 1 - photo 21
Two Family Detached House with Detached Garage. 1 1/2 Over 1 - photo 22
Two Family Detached House with Detached Garage. 1 1/2 Over 1 - photo 23

$700,000

3 Beds | 2.0 Baths | 1,592 Sqft

241-08 Newhall Ave, Rosedale, NY, 11422

Two Family Detached House with Detached Garage. 1 1/2 Over 1

Added: 07/02/2026 • Updated: 07/16/2026
For Sale
Detached property opportunity in Rosedale, Queens, offering - photo 1
Detached property opportunity in Rosedale, Queens, offering - photo 2
Detached property opportunity in Rosedale, Queens, offering - photo 3
Detached property opportunity in Rosedale, Queens, offering - photo 4
Detached property opportunity in Rosedale, Queens, offering - photo 5
Detached property opportunity in Rosedale, Queens, offering - photo 6
Detached property opportunity in Rosedale, Queens, offering - photo 7
Detached property opportunity in Rosedale, Queens, offering - photo 8
Detached property opportunity in Rosedale, Queens, offering - photo 9
Detached property opportunity in Rosedale, Queens, offering - photo 10
Detached property opportunity in Rosedale, Queens, offering - photo 11
Detached property opportunity in Rosedale, Queens, offering - photo 12
Detached property opportunity in Rosedale, Queens, offering - photo 13
Detached property opportunity in Rosedale, Queens, offering - photo 14
Detached property opportunity in Rosedale, Queens, offering - photo 15
Detached property opportunity in Rosedale, Queens, offering - photo 16
Detached property opportunity in Rosedale, Queens, offering - photo 17
Detached property opportunity in Rosedale, Queens, offering - photo 18
Detached property opportunity in Rosedale, Queens, offering - photo 19
Detached property opportunity in Rosedale, Queens, offering - photo 20

$675,000

3 Beds | 3.0 Baths | 1,304 Sqft

137-11 234th St, Rosedale, NY, 11422

Detached property opportunity in Rosedale, Queens, offering

Added: 07/18/2026 • Updated: 07/18/2026
For Sale
New On The Market. Priced To Sell. Needs TLC - As Is. 6 Bedrooms - photo 1

$650,000

4 Beds | 2.0 Baths | 1,405 Sqft

242-02 136th Ave, Rosedale, NY, 11422

New On The Market. Priced To Sell. Needs TLC - As Is. 6 Bedrooms

Added: 07/14/2026 • Updated: 07/15/2026
For Sale
Opportunity and potential come together at this classic attached - photo 1
Opportunity and potential come together at this classic attached - photo 2
Opportunity and potential come together at this classic attached - photo 3
Opportunity and potential come together at this classic attached - photo 4
Opportunity and potential come together at this classic attached - photo 5
Opportunity and potential come together at this classic attached - photo 6
Opportunity and potential come together at this classic attached - photo 7
Opportunity and potential come together at this classic attached - photo 8
Opportunity and potential come together at this classic attached - photo 9
Opportunity and potential come together at this classic attached - photo 10
Opportunity and potential come together at this classic attached - photo 11
Opportunity and potential come together at this classic attached - photo 12
Opportunity and potential come together at this classic attached - photo 13
Opportunity and potential come together at this classic attached - photo 14
Opportunity and potential come together at this classic attached - photo 15
Opportunity and potential come together at this classic attached - photo 16
Opportunity and potential come together at this classic attached - photo 17
Opportunity and potential come together at this classic attached - photo 18
Opportunity and potential come together at this classic attached - photo 19
Opportunity and potential come together at this classic attached - photo 20
Opportunity and potential come together at this classic attached - photo 21
Opportunity and potential come together at this classic attached - photo 22

$650,000

3 Beds | 2.0 Baths | 1,831 Sqft

147-25 Brookville Blvd, Rosedale, NY, 11422

Opportunity and potential come together at this classic attached

Added: 07/09/2026 • Updated: 07/09/2026
View more View More
SEARCH STATES
Alabama Alaska California Colorado Connecticut Delaware Florida Georgia Hawaii Louisiana Maine Maryland Mississippi New Hampshire New Jersey New York North Carolina Oregon Pennsylvania Rhode Island South Carolina Texas Virginia Washington
SERVICES
Buy Buy Advertise
COMPANY
Testimonials About Us Office Locations
SUPPORT
Help Contact Us
ADDITIONAL MARKETS
LakeHouse.com MountainHomes.com GolfHomes.com BarrierFreeHome.com
SUBSCRIBE
Receive notifications for new listings
Subscribe
X Facebook Instagram YouTube

Dream Home Network Inc.

is committed to ensuring digital accessibility and property listings for individuals with disabilities. All information provided is deemed reliable but is not guaranteed and should be independently verified. We are continuously working to improve the accessibility of our web experience for everyone, and we welcome feedback and accommodation requests. If you wish to report an issue or seek an accommodation, please let us know.

Dream Home Network Inc. Sells leads to DHN Realty Inc. who holds real estate brokerage licenses in Alabama. Listing agents will be sent notification copy of leads on their listings where Dream Home Network Inc. is provided listings via our Feed Provider as required.

© 1997 - 2026 BeachHouse.com
Part of Dream Home Network, Inc.
Last updated on 2026.07.24
Terms & Policy

Search Filters
Price
-
0
$100,000
$100,000+
$200,000
$200,000+
$300,000
$300,000+
$400,000
$400,000+
$500,000
$500,000+
$600,000
$600,000+
$700,000
$700,000+
$800,000
$800,000+
$900,000
Any Price
Any Price
Beds & Baths
-
-
Property Type
Sale Status
More Filters
-
-
-
-
Advanced Search

Rosedale

Read more
Sort By: Featured
  • Featured
  • Newest
  • Price - Low To High
  • Price - High To Low
  • Sqft - Low To High
  • Sqft - High To Low

Rosedale Real Estate Agent Info

About Rosedale

Click to activate
Request Information
By proceeding you authorize Dream Home Network Inc., its service providers (including real estate professionals such as Brokers, Listing Agents, Buyers Agents, and local referral partners), and its affiliates, to contact me using the contact details you provided, via phone call or text (SMS) using automated dialing technology for marketing or advertising purposes, including contacting me about my inquiry and other home-related matters. Not a condition for purchase. Message and data rates may apply.
This consent applies even if you are on a corporate, state or national Do Not Call list. Dream Home Network Inc. may share information about your recent and future site activity with its affiliates and service providers (including real estate professionals such as Brokers, Listing Agents, Buyers Agents, and local referral partners) to help them better understand what I am looking for in a property. To opt-out at any time you can reply "STOP" or contact Dream Home Network Inc. at  csv@dreamhomenetwork.com.
Contact Agent
By contacting this agent you agree to these Terms and Conditions.
Share this Ad
Link copied
Video/Virtual Tour
Loading...
SEARCH STATES
Alabama Alaska California Colorado Connecticut Delaware Florida Georgia Hawaii Louisiana Maine Maryland Mississippi New Hampshire New Jersey New York North Carolina Oregon Pennsylvania Rhode Island South Carolina Texas Virginia Washington
SERVICES
Buy Buy Advertise
COMPANY
Testimonials About Us Office Locations
SUPPORT
Help Contact Us
ADDITIONAL MARKETS
LakeHouse.com MountainHomes.com GolfHomes.com BarrierFreeHome.com
SUBSCRIBE
Receive notifications for new listings
Subscribe
X Facebook Instagram YouTube

Dream Home Network Inc.

is committed to ensuring digital accessibility and property listings for individuals with disabilities. All information provided is deemed reliable but is not guaranteed and should be independently verified. We are continuously working to improve the accessibility of our web experience for everyone, and we welcome feedback and accommodation requests. If you wish to report an issue or seek an accommodation, please let us know.

Dream Home Network Inc. Sells leads to DHN Realty Inc. who holds real estate brokerage licenses in Alabama. Listing agents will be sent notification copy of leads on their listings where Dream Home Network Inc. is provided listings via our Feed Provider as required.

© 1997 - 2026 BeachHouse.com
Part of Dream Home Network, Inc.
Last updated on 2026.07.24
Terms & Policy