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 #7354857
MLS #967603
Listing photo

Located in the heart of College Point, just minutes from

124-17 and 124-15 18th Ave, College Point, NY 11356
$2,609,000
--Beds
--Baths
--Sqft
0.04Acres

About this property

Located in the heart of College Point, just minutes from Flushing, this two-property portfolio presents a compelling investment opportunity in one of Queens' most strategic and rapidly growing commercial corridors. The portfolio includes a well-maintained industrial warehouse property and a mixed-use commercial and residential building, offering investors a balanced combination of stable income, flexible use, and long-term growth potential. The industrial asset consists of two fully functional warehouse units totaling approximately 3,200 square feet. The first unit, approximately 1,200 square feet, is leased to an established fabric goods distributor, while the second, approximately 2,000 square feet, operates as a refrigerated warehouse and active business facility. Both units feature approximately 11' x 9' garage bay doors, supporting efficient loading and logistics operations. The property currently generates approximately $88,000 in annual rental income with operating expenses of roughly $28,000, providing strong cash flow and reliable performance. The second property is a 5,234-square-foot mixed-use building offering both commercial flexibility and stable residential income. The lower level and ground floor provide approximately 660 to 2,000 square feet of adaptable office space with both front and side entrances, creating an ideal opportunity for an owner-user or additional commercial tenancy. The second and third floors consist of fully occupied multifamily apartment units, delivering steady in-place rental income. Together, these properties provide a diversified investment profile combining industrial, commercial, and residential income streams. Positioned near major transportation routes and the economic hub of Flushing, the portfolio benefits from strong tenant demand, excellent accessibility, and the continued growth of the Queens market. This offering represents a rare opportunity for investors seeking dependable cash flow today with meaningful long-term upside.

Property Features

0 Beds
0 Baths
0 Sqft
Built in 1930
0.04 Acres
Siding: Brick
Natural Gas, Oil
$51,500 / 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

Fatima Smith AHWD

Laffey International Realt Estate

516-668-9154

Location

Map
Listing Agent: Fatima Smith AHWD 516-668-9154
Broker: Laffey International Realt Estate 516-308-0550 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 11, 2026

Photo Gallery

Located in the heart of College Point, just minutes from - photo 1
Located in the heart of College Point, just minutes from - photo 2
Located in the heart of College Point, just minutes from - photo 3
Located in the heart of College Point, just minutes from - photo 4
Located in the heart of College Point, just minutes from - photo 5

$2,609,000

--
Beds
--
Baths
--
Sqft

124-17 and 124-15 18th Ave, College Point, NY 11356

By contacting this agent you agree to these Terms and Conditions.
Home New York College Point
Located in the heart of College Point, just minutes from - photo 1
Located in the heart of College Point, just minutes from - photo 2
Located in the heart of College Point, just minutes from - photo 3
Located in the heart of College Point, just minutes from - photo 4
Located in the heart of College Point, just minutes from - photo 5
MLS# 967603
Lot For Sale

Located in the heart of College Point, just minutes from

$2,609,000

124-17 and 124-15 18th Ave, College Point, NY 11356

--
Beds
--
Baths
--
Sqft
0.04
Acres
$2,609,000
124-17 and 124-15 18th Ave, College Point, NY 11356
-- Beds
-- Baths
-- Sqft
0.04 Acres
Located in the heart of College Point, just minutes from Flushing, this two-property portfolio presents a compelling investment opportunity in one of Queens' most strategic and rapidly growing commercial corridors. The portfolio includes a well-maintained industrial warehouse property and a mixed-use commercial and residential building, offering investors a balanced combination of stable income, flexible use, and long-term growth potential. The industrial asset consists of two fully functional warehouse units totaling approximately 3,200 square feet. The first unit, approximately 1,200 square feet, is leased to an established fabric goods distributor, while the second, approximately 2,000 square feet, operates as a refrigerated warehouse and active business facility. Both units feature approximately 11' x 9' garage bay doors, supporting efficient loading and logistics operations. The property currently generates approximately $88,000 in annual rental income with operating expenses of roughly $28,000, providing strong cash flow and reliable performance. The second property is a 5,234-square-foot mixed-use building offering both commercial flexibility and stable residential income. The lower level and ground floor provide approximately 660 to 2,000 square feet of adaptable office space with both front and side entrances, creating an ideal opportunity for an owner-user or additional commercial tenancy. The second and third floors consist of fully occupied multifamily apartment units, delivering steady in-place rental income. Together, these properties provide a diversified investment profile combining industrial, commercial, and residential income streams. Positioned near major transportation routes and the economic hub of Flushing, the portfolio benefits from strong tenant demand, excellent accessibility, and the continued growth of the Queens market. This offering represents a rare opportunity for investors seeking dependable cash flow today with meaningful long-term upside.
160 days
on BeachHouse.com
160
views
0
saves

Property Details

HOME DETAILS

0 Beds
0 Baths
0 Sqft
Built in 1930
0.04 Acres

EXTERIOR

Siding: Brick

INTERIOR

Natural Gas, Oil

FINANCIAL & COMMUNITY

$51,500 / yr property tax
Queens County
See More Details

Location

Map
Open in Google Maps

Mortgage Calculator

Ad Statistics

Ad Number
7354857
Viewed
160 times
Listing Status
Active
Added
Mar 04, 2026
Last Refreshed
Jul 03, 2026 06:17:28 PM

Listing Information

Data Source
OneKey MLS
Source Property ID
967603
Listing Agent: Fatima Smith AHWD 516-668-9154
Broker: Laffey International Realt Estate 516-308-0550 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
Opportunity Knocks for Investors and developers in the heart of - photo 1
Opportunity Knocks for Investors and developers in the heart of - photo 2
Opportunity Knocks for Investors and developers in the heart of - photo 3
Opportunity Knocks for Investors and developers in the heart of - photo 4
Opportunity Knocks for Investors and developers in the heart of - photo 5
Opportunity Knocks for Investors and developers in the heart of - photo 6
Opportunity Knocks for Investors and developers in the heart of - photo 7
Opportunity Knocks for Investors and developers in the heart of - photo 8
Opportunity Knocks for Investors and developers in the heart of - photo 9
Opportunity Knocks for Investors and developers in the heart of - photo 10
Opportunity Knocks for Investors and developers in the heart of - photo 11

$2,680,000

0.12 Acres | Lot for sale

1831 College Point Blvd, College Point, NY 11356

Opportunity Knocks for Investors and developers in the heart of

Added: 08/20/2025 • Updated: 07/09/2026
For Sale
Exceptional opportunity to acquire a well-maintained, elevator - photo 1
Exceptional opportunity to acquire a well-maintained, elevator - photo 2
Exceptional opportunity to acquire a well-maintained, elevator - photo 3
Exceptional opportunity to acquire a well-maintained, elevator - photo 4
Exceptional opportunity to acquire a well-maintained, elevator - photo 5
Exceptional opportunity to acquire a well-maintained, elevator - photo 6
Exceptional opportunity to acquire a well-maintained, elevator - photo 7
Exceptional opportunity to acquire a well-maintained, elevator - photo 8
Exceptional opportunity to acquire a well-maintained, elevator - photo 9
Exceptional opportunity to acquire a well-maintained, elevator - photo 10
Exceptional opportunity to acquire a well-maintained, elevator - photo 11
Exceptional opportunity to acquire a well-maintained, elevator - photo 12
Exceptional opportunity to acquire a well-maintained, elevator - photo 13
Exceptional opportunity to acquire a well-maintained, elevator - photo 14
Exceptional opportunity to acquire a well-maintained, elevator - photo 15
Exceptional opportunity to acquire a well-maintained, elevator - photo 16
Exceptional opportunity to acquire a well-maintained, elevator - photo 17
Exceptional opportunity to acquire a well-maintained, elevator - photo 18
Exceptional opportunity to acquire a well-maintained, elevator - photo 19
Exceptional opportunity to acquire a well-maintained, elevator - photo 20
Exceptional opportunity to acquire a well-maintained, elevator - photo 21
Exceptional opportunity to acquire a well-maintained, elevator - photo 22
Exceptional opportunity to acquire a well-maintained, elevator - photo 23
Exceptional opportunity to acquire a well-maintained, elevator - photo 24
Exceptional opportunity to acquire a well-maintained, elevator - photo 25
Exceptional opportunity to acquire a well-maintained, elevator - photo 26
Exceptional opportunity to acquire a well-maintained, elevator - photo 27
Exceptional opportunity to acquire a well-maintained, elevator - photo 28
Exceptional opportunity to acquire a well-maintained, elevator - photo 29
Exceptional opportunity to acquire a well-maintained, elevator - photo 30
Exceptional opportunity to acquire a well-maintained, elevator - photo 31
Exceptional opportunity to acquire a well-maintained, elevator - photo 32
Exceptional opportunity to acquire a well-maintained, elevator - photo 33
Exceptional opportunity to acquire a well-maintained, elevator - photo 34
Exceptional opportunity to acquire a well-maintained, elevator - photo 35
Exceptional opportunity to acquire a well-maintained, elevator - photo 36
Exceptional opportunity to acquire a well-maintained, elevator - photo 37
Exceptional opportunity to acquire a well-maintained, elevator - photo 38
Exceptional opportunity to acquire a well-maintained, elevator - photo 39

$2,580,000

0.09 Acres | Lot for sale

14-48 College Point Blvd, College Point, NY 11356

Exceptional opportunity to acquire a well-maintained, elevator

Added: 01/14/2026 • Updated: 05/31/2026
For Sale
Exclusive New Development! Pre-Construction Three-Family Homes - photo 1
Exclusive New Development! Pre-Construction Three-Family Homes - photo 2
Exclusive New Development! Pre-Construction Three-Family Homes - photo 3

$2,350,000

Lot for sale

23-08 College point Blvd, College Point, NY 11356

Exclusive New Development! Pre-Construction Three-Family Homes

Added: 01/08/2026 • Updated: 07/09/2026
For Sale
This well-located mixed-use building features a busy - photo 1
This well-located mixed-use building features a busy - photo 2
This well-located mixed-use building features a busy - photo 3
This well-located mixed-use building features a busy - photo 4
This well-located mixed-use building features a busy - photo 5
This well-located mixed-use building features a busy - photo 6
This well-located mixed-use building features a busy - photo 7
This well-located mixed-use building features a busy - photo 8
This well-located mixed-use building features a busy - photo 9
This well-located mixed-use building features a busy - photo 10
This well-located mixed-use building features a busy - photo 11
This well-located mixed-use building features a busy - photo 12

$2,280,000

0.12 Acres | Lot for sale

21-20 College Point Blvd, College Point, NY 11356

This well-located mixed-use building features a busy

Added: 05/30/2026 • Updated: 06/16/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

College Point

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

College Point Real Estate Agent Info

About College Point

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