BHS Demo | Brown Harris Stevens

All Areas
New Developments
Home Evaluation

Find a Property
Sell
Agents
Explore
Blog & More

Loading map…

Call us at 212-906-9200

Company

About Us
Office Locations
Ownership
Terra Holdings
Sales Leadership
Marketing
About Brown Harris Stevens Development Marketing
Global Referrals & Relocation
Celebrating 150 Years
Join BHS

Resources

Curate by BHS
Sell Your Home
Referral & Relocation
Partnerships
Explore All Areas
BHS Pride

Media

BHS Now Blog
BHS MORE Network
YouTube
Apple Podcast

Call us at 212-906-9200

Brown Harris Stevens is the trademarked name of the Brown Harris Stevens companies, which are individual licensed real estate companies in New York, Connecticut, New Jersey, and Florida. Brown Harris Stevens’s primary office is at 770 Lexington Avenue, New York, NY 10065. All information on this website is from sources believed reliable but must be verified by the user and no guaranty is given. All rights to content, photographs, and graphics reserved to Brown Harris Stevens. Brown Harris Stevens fully supports the Fair Housing Laws. If you have vision problems, are using a screen reader, and have problems accessing this website, please call us at 212-712-1163, and all phone charges will be reimbursed. Copyright Terra Holdings, LLC . All rights reserved.

All information is from sources deemed reliable but is subject to errors, omissions, changes in price, prior sale or withdrawal without notice. No representation is made as to the accuracy of any description. All measurements and square footages are approximate and all information should be confirmed by customer. All rights to content, photographs and graphics are reserved to Brown Harris Stevens. Customer should consult with its counsel regarding all closing and tax costs. Retransmission, redistribution or copying of listing information without Brown Harris Stevens’s prior consent is strictly prohibited. Information is intended for a user’s personal, non commercial use in consideration of the purchase and/or sale of a property. Brown Harris Stevens strongly supports all Fair Housing laws.

Terms and Conditions of Use|Privacy Policy|California Privacy Policy|Fair Housing Policy|NYS Fair Housing Notice|NYS Standard Operating Procedures|NYS Anti Discrimination Notice|NYS Reasonable Accommodations Notice|Agency Representation Explanation|HIPAA Privacy Update

Copyright © 2026 Terra Holdings. All Rights Reserved.

Powered by Neutrino®

More Filters

Property details

Square Feet

to

Lot Size (acres)

to

Year built

to

Parking Spaces

to

Must have garage

HOA fees per month

Open house and tours

Open HouseVideo3D Tour

Property status

Showing active listings by default. Pending / Under Contract are hidden. Use the toggle below to include them.

New ListingComing SoonInclude Pending / Under ContractSoldFeatured / BHS ExclusiveNew Construction

Amenities

Attended LobbyDoormanConciergeGymPoolOutdoor SpaceViewsPet FriendlyWasher/Dryer

Loading map…

Search Map Area

3homes for sale

Sort By Price High to Low

131-02a 40th Road #6G Photo

Condo | Long Field, NY$858,000

Condo | Long Field, NY$858,000

131-02a 40th Road #6G
Queens, NY 11354

Year Built: 2023

2
1
777

131-02a 40th Road #15J Photo

Condo | Long Field, NY$648,000

Condo | Long Field, NY$648,000

131-02a 40th Road #15J
Queens, NY 11354

1
1
603

131-02b 40th Road #13P Photo

Condo | Long Field, NY$598,000

Condo | Long Field, NY$598,000

131-02b 40th Road #13P
Queens, NY 11354

Year Built: 2023

1
1
522

Courtesy of E Realty International Corp