Buy
  • Alabama Alaska California 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 (730)
    Mexico Listings (329)
    Central America Listings (620)
    Caribbean Islands Listings (46)
    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 #7786567
MLS #971203
Listing photo

Charming single-family Colonial located in Rosedale, offering 3

24718 137th Ave, Rosedale, NY 11422
$695,000
3Beds
2Baths
1,634Sqft
0.12Acres

About this property

Charming single-family Colonial located in Rosedale, offering 3 bedrooms and 2 full bathrooms on a 50x100 lot. The home features an eat-in kitchen, formal dining room, and multiple living areas across 11 total rooms, providing a flexible and functional layout. A walk-up attic offers significant storage space and potential for future use, while the partial unfinished basement adds additional storage and utility space. Exterior features include a private driveway and detached 2-car garage, providing ample off-street parking and storage options. The backyard offers usable outdoor space for a variety of needs. Conveniently located near the Sunrise Highway retail corridor (approx. 0.3-0.6 mi) with access to shopping, dining, and everyday services. Approximately 0.8 miles to the Rosedale LIRR station with service to Manhattan, and about 1.0 mile to Green Acres Mall, including Starbucks and Stop & Shop. Brookville Park is located approximately 1.2 miles away. Easy access to the Belt Parkway (approx. 0.5-1.0 mi) and JFK Airport (approx. 3.5-4.0 mi). Public water and sewer. Oil heat with steam system. Nearby Amenity List - Rosedale LIRR Station (0.8 mi) - Green Acres Mall (1.0 mi) - Starbucks (1.0 mi) - Stop & Shop (1.0 mi) - Sunrise Highway retail corridor (0.3-0.6 mi) - Brookville Park (1.2 mi) - Belt Parkway access (0.5-1.0 mi) - JFK Airport (3.5-4.0 mi)

Property Features

3 Beds
2 Baths
1,634 Sqft
Built in 1930
0.12 Acres
Siding: Frame
Steam, Oil
$6,144 / yr property tax
Queens County

Additional Photos

Additional listing photo 1
Additional listing photo 2
Additional listing photo 3
Additional listing photo 4

Contact Information

Eric Berman

Compass Greater NY LLC

917-225-8596

Location

Map
Listing Agent: Eric Berman 917-225-8596
Broker: Compass Greater NY LLC 212-913-9058 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 Aug 12, 2026

Photo Gallery

Charming single-family Colonial located in Rosedale, offering 3 - photo 1
Charming single-family Colonial located in Rosedale, offering 3 - photo 2
Charming single-family Colonial located in Rosedale, offering 3 - photo 3
Charming single-family Colonial located in Rosedale, offering 3 - photo 4
Charming single-family Colonial located in Rosedale, offering 3 - photo 5
Charming single-family Colonial located in Rosedale, offering 3 - photo 6
Charming single-family Colonial located in Rosedale, offering 3 - photo 7
Charming single-family Colonial located in Rosedale, offering 3 - photo 8
Charming single-family Colonial located in Rosedale, offering 3 - photo 9
Charming single-family Colonial located in Rosedale, offering 3 - photo 10
Charming single-family Colonial located in Rosedale, offering 3 - photo 11
Charming single-family Colonial located in Rosedale, offering 3 - photo 12
Charming single-family Colonial located in Rosedale, offering 3 - photo 13
Charming single-family Colonial located in Rosedale, offering 3 - photo 14
Charming single-family Colonial located in Rosedale, offering 3 - photo 15
Charming single-family Colonial located in Rosedale, offering 3 - photo 16
Charming single-family Colonial located in Rosedale, offering 3 - photo 17
Charming single-family Colonial located in Rosedale, offering 3 - photo 18
Charming single-family Colonial located in Rosedale, offering 3 - photo 19
Charming single-family Colonial located in Rosedale, offering 3 - photo 20
Charming single-family Colonial located in Rosedale, offering 3 - photo 21
Charming single-family Colonial located in Rosedale, offering 3 - photo 22
Charming single-family Colonial located in Rosedale, offering 3 - photo 23
Charming single-family Colonial located in Rosedale, offering 3 - photo 24
Charming single-family Colonial located in Rosedale, offering 3 - photo 25
Charming single-family Colonial located in Rosedale, offering 3 - photo 26
Charming single-family Colonial located in Rosedale, offering 3 - photo 27
Charming single-family Colonial located in Rosedale, offering 3 - photo 28
Charming single-family Colonial located in Rosedale, offering 3 - photo 29
Charming single-family Colonial located in Rosedale, offering 3 - photo 30
Charming single-family Colonial located in Rosedale, offering 3 - photo 31

$695,000

3
Beds
2
Baths
1,634
Sqft

24718 137th Ave, Rosedale, NY 11422

By contacting this agent you agree to these Terms and Conditions.
Home New York Rosedale
Charming single-family Colonial located in Rosedale, offering 3 - photo 1
Charming single-family Colonial located in Rosedale, offering 3 - photo 2
Charming single-family Colonial located in Rosedale, offering 3 - photo 3
Charming single-family Colonial located in Rosedale, offering 3 - photo 4
Charming single-family Colonial located in Rosedale, offering 3 - photo 5
MLS# 971203
Home Sale Pending

Charming single-family Colonial located in Rosedale, offering 3

$695,000

24718 137th Ave, Rosedale, NY 11422

3
Beds
2
Baths
1,634
Sqft
0.12
Acres
$695,000
24718 137th Ave, Rosedale, NY 11422
3 Beds
2 Baths
1,634 Sqft
0.12 Acres
Charming single-family Colonial located in Rosedale, offering 3 bedrooms and 2 full bathrooms on a 50x100 lot. The home features an eat-in kitchen, formal dining room, and multiple living areas across 11 total rooms, providing a flexible and functional layout. A walk-up attic offers significant storage space and potential for future use, while the partial unfinished basement adds additional storage and utility space. Exterior features include a private driveway and detached 2-car garage, providing ample off-street parking and storage options. The backyard offers usable outdoor space for a variety of needs. Conveniently located near the Sunrise Highway retail corridor (approx. 0.3-0.6 mi) with access to shopping, dining, and everyday services. Approximately 0.8 miles to the Rosedale LIRR station with service to Manhattan, and about 1.0 mile to Green Acres Mall, including Starbucks and Stop & Shop. Brookville Park is located approximately 1.2 miles away. Easy access to the Belt Parkway (approx. 0.5-1.0 mi) and JFK Airport (approx. 3.5-4.0 mi). Public water and sewer. Oil heat with steam system. Nearby Amenity List - Rosedale LIRR Station (0.8 mi) - Green Acres Mall (1.0 mi) - Starbucks (1.0 mi) - Stop & Shop (1.0 mi) - Sunrise Highway retail corridor (0.3-0.6 mi) - Brookville Park (1.2 mi) - Belt Parkway access (0.5-1.0 mi) - JFK Airport (3.5-4.0 mi)
57 days
on BeachHouse.com
0
view
0
saves

Property Details

HOME DETAILS

3 Beds
2 Baths
1,634 Sqft
Built in 1930
0.12 Acres

EXTERIOR

Siding: Frame

INTERIOR

Steam, Oil

FINANCIAL & COMMUNITY

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

Location

Map
Open in Google Maps

Mortgage Calculator

Ad Statistics

Ad Number
7786567
Viewed
0 time
Listing Status
Pending
Added
Jun 15, 2026
Last Refreshed
Jul 03, 2026 06:17:28 PM

Listing Information

Data Source
OneKey MLS
Source Property ID
971203
Listing Agent: Eric Berman 917-225-8596
Broker: Compass Greater NY LLC 212-913-9058 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
Welcome home! This charming 3-bedroom, 1.5-bath attached home - photo 1
Welcome home! This charming 3-bedroom, 1.5-bath attached home - photo 2
Welcome home! This charming 3-bedroom, 1.5-bath attached home - photo 3

$800,000

3 Beds | 1.0 Baths | 1,360 Sqft

13743 233rd St, Rosedale, NY 11422

Welcome home! This charming 3-bedroom, 1.5-bath attached home

Added: 06/27/2026 • Updated: 06/27/2026
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

$799,000

3 Beds | 2.0 Baths | 0 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/09/2026
For Sale
This well maintained split-level home has lots of room. On the - photo 1
This well maintained split-level home has lots of room. On the - photo 2
This well maintained split-level home has lots of room. On the - photo 3
This well maintained split-level home has lots of room. On the - photo 4
This well maintained split-level home has lots of room. On the - photo 5
This well maintained split-level home has lots of room. On the - photo 6
This well maintained split-level home has lots of room. On the - photo 7
This well maintained split-level home has lots of room. On the - photo 8
This well maintained split-level home has lots of room. On the - photo 9
This well maintained split-level home has lots of room. On the - photo 10
This well maintained split-level home has lots of room. On the - photo 11
This well maintained split-level home has lots of room. On the - photo 12
This well maintained split-level home has lots of room. On the - photo 13
This well maintained split-level home has lots of room. On the - photo 14
This well maintained split-level home has lots of room. On the - photo 15
This well maintained split-level home has lots of room. On the - photo 16

$780,000

3 Beds | 2.0 Baths | 1,428 Sqft

137-60 233rd St, Rosedale, NY 11422

This well maintained split-level home has lots of room. On the

Added: 06/27/2026 • Updated: 07/09/2026
For Sale
*Experience refined living in this impeccably maintained - photo 1
*Experience refined living in this impeccably maintained - photo 2
*Experience refined living in this impeccably maintained - photo 3
*Experience refined living in this impeccably maintained - photo 4
*Experience refined living in this impeccably maintained - photo 5
*Experience refined living in this impeccably maintained - photo 6
*Experience refined living in this impeccably maintained - photo 7
*Experience refined living in this impeccably maintained - photo 8
*Experience refined living in this impeccably maintained - photo 9
*Experience refined living in this impeccably maintained - photo 10
*Experience refined living in this impeccably maintained - photo 11
*Experience refined living in this impeccably maintained - photo 12
*Experience refined living in this impeccably maintained - photo 13
*Experience refined living in this impeccably maintained - photo 14
*Experience refined living in this impeccably maintained - photo 15
*Experience refined living in this impeccably maintained - photo 16
*Experience refined living in this impeccably maintained - photo 17
*Experience refined living in this impeccably maintained - photo 18
*Experience refined living in this impeccably maintained - photo 19
*Experience refined living in this impeccably maintained - photo 20
*Experience refined living in this impeccably maintained - photo 21
*Experience refined living in this impeccably maintained - photo 22
*Experience refined living in this impeccably maintained - photo 23
*Experience refined living in this impeccably maintained - photo 24
*Experience refined living in this impeccably maintained - photo 25
*Experience refined living in this impeccably maintained - photo 26
*Experience refined living in this impeccably maintained - photo 27
*Experience refined living in this impeccably maintained - photo 28
*Experience refined living in this impeccably maintained - photo 29
*Experience refined living in this impeccably maintained - photo 30
*Experience refined living in this impeccably maintained - photo 31
*Experience refined living in this impeccably maintained - photo 32
*Experience refined living in this impeccably maintained - photo 33
*Experience refined living in this impeccably maintained - photo 34
*Experience refined living in this impeccably maintained - photo 35
*Experience refined living in this impeccably maintained - photo 36
*Experience refined living in this impeccably maintained - photo 37
*Experience refined living in this impeccably maintained - photo 38
*Experience refined living in this impeccably maintained - photo 39
*Experience refined living in this impeccably maintained - photo 40
*Experience refined living in this impeccably maintained - photo 41

$779,999

3 Beds | 2.0 Baths | 1,440 Sqft

147-19 259th St, Rosedale, NY 11422

*Experience refined living in this impeccably maintained

Added: 07/09/2026 • Updated: 07/09/2026
SEARCH STATES
Alabama Alaska California 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.08.11
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
  • 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 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.08.11
Terms & Policy