$1,888,000
for sale
3,120 ft²
$605 per ft²
11 rooms
6 beds
4 baths
Mixed-use building
- Douglaston
Resale
Learn more about this home by contacting a buyer’s agent.
Benefits of a buyer’s agent:
Represents your needs
Negotiates the deal
'%3e%3cpath d='M49.1701 7.22253H15.6018C14.5519 7.22253 13.7007 8.07371 13.7007 9.12368V54.0988C13.7007 55.1488 14.5519 56 15.6018 56H49.1701C50.22 56 51.0712 55.1488 51.0712 54.0988V9.12368C51.0712 8.07371 50.22 7.22253 49.1701 7.22253Z' fill='%23F7D6B7'/%3e%3cpath d='M36.9292 44.0455L42.584 39.4989L14.9452 5.12314L9.29039 9.6697L36.9292 44.0455Z' fill='%23FF9400'/%3e%3cpath d='M14.9486 5.10938L9.28507 9.66298L8.13609 8.23394C8.00095 8.06585 7.90023 7.87279 7.83969 7.66577C7.77916 7.45876 7.75999 7.24184 7.78328 7.02742C7.80658 6.813 7.87188 6.60526 7.97545 6.41607C8.07903 6.22689 8.21886 6.05995 8.38695 5.92481L11.4817 3.43654C11.6496 3.29964 11.8429 3.19731 12.0506 3.13544C12.2582 3.07357 12.476 3.05339 12.6914 3.07605C12.9069 3.09871 13.1157 3.16377 13.3059 3.26748C13.4961 3.37119 13.6639 3.5115 13.7996 3.68034L14.9486 5.10938Z' fill='%23002569'/%3e%3cpath d='M11.9045 3.09485L7.95935 6.26686L6.58481 4.55728C6.2923 4.18876 6.15677 3.71983 6.20758 3.25209C6.2584 2.78435 6.49146 2.35546 6.85628 2.05835L8.03107 1.1138C8.39959 0.821285 8.86852 0.685755 9.33626 0.736569C9.80401 0.787382 10.2329 1.02045 10.53 1.38527L11.9045 3.09485Z' fill='%23F7D6B7'/%3e%3cpath d='M42.5441 39.4634L44.344 46.843C44.3696 46.9595 44.3617 47.0808 44.3211 47.1929C44.2805 47.3051 44.2089 47.4034 44.1147 47.4764C44.0204 47.5495 43.9073 47.5943 43.7886 47.6056C43.6699 47.617 43.5504 47.5944 43.444 47.5405L36.8856 44.0081L42.5441 39.4634Z' fill='%23002569'/%3e%3cpath d='M14.4113 22.4988L16.042 21.1877L5.63074 8.23875L4.00006 9.54985L14.4113 22.4988Z' fill='%23FF9400'/%3e%3cpath d='M45.4239 11.9023H33.7358C32.6299 11.9023 31.7334 12.7988 31.7334 13.9047V13.916C31.7334 15.0219 32.6299 15.9184 33.7358 15.9184H45.4239C46.5298 15.9184 47.4263 15.0219 47.4263 13.916V13.9047C47.4263 12.7988 46.5298 11.9023 45.4239 11.9023Z' fill='%23FF9400'/%3e%3cpath d='M45.424 19.2032H37.0544C35.9485 19.2032 35.052 20.0997 35.052 21.2056V21.2169C35.052 22.3228 35.9485 23.2193 37.0544 23.2193H45.424C46.5298 23.2193 47.4263 22.3228 47.4263 21.2169V21.2056C47.4263 20.0997 46.5298 19.2032 45.424 19.2032Z' fill='%23FF9400'/%3e%3cpath d='M37.5494 53.5026C35.0745 53.5026 33.1508 52.3214 31.2497 50.9827C30.7435 50.634 30.271 50.2403 29.8098 49.8578C28.9913 49.0138 27.9621 48.404 26.8287 48.0917C26.3236 48.0636 25.8181 48.14 25.3439 48.3162C24.8697 48.4923 24.4369 48.7644 24.0726 49.1153C23.1231 50.0234 22.3018 51.0566 21.6315 52.1864C21.5133 52.3659 21.3609 52.5204 21.183 52.641C21.0051 52.7616 20.8053 52.846 20.5948 52.8893C20.3843 52.9327 20.1673 52.9341 19.9563 52.8936C19.7452 52.8531 19.5442 52.7715 19.3647 52.6533C19.1852 52.5351 19.0308 52.3827 18.9102 52.2048C18.7896 52.027 18.7052 51.8271 18.6618 51.6166C18.6185 51.4061 18.617 51.1891 18.6575 50.9781C18.698 50.767 18.7797 50.566 18.8979 50.3865C19.7515 48.9981 20.7968 47.737 22.0027 46.6405C22.7137 45.992 23.5521 45.499 24.4645 45.193C25.3768 44.8869 26.3429 44.7746 27.3012 44.8631C29.0576 45.2186 30.6721 46.0787 31.9472 47.3379C32.3746 47.6979 32.7796 48.0242 33.1846 48.3166C35.6707 50.0715 37.0881 50.679 39.4055 49.9253C39.6086 49.8568 39.8232 49.8293 40.037 49.8443C40.2508 49.8593 40.4595 49.9167 40.6509 50.0129C40.8424 50.1092 41.0129 50.2425 41.1525 50.4051C41.2921 50.5677 41.398 50.7564 41.4642 50.9602C41.5992 51.3735 41.565 51.8234 41.3689 52.2114C41.1727 52.5994 40.8308 52.8938 40.418 53.0301C39.4931 53.3396 38.5246 53.4991 37.5494 53.5026Z' fill='%23002569'/%3e%3c/g%3e%3cdefs%3e%3cclipPath id='clip0'%3e%3crect width='56' height='56' fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
Supports the closing process
Listing by Prime Realty, Corporate Broker, 250-02 Northern Boulevard, Little Neck, NY 11362
Listing updated in the last 2 days
Common charges
Not applicable
Estimated payment
$10,561/mo
Legal disclaimerAll calculations are estimates provided by StreetEasy for informational purposes only. Actual amounts or financing terms may vary. Please contact your mortgage provider for specifics.Taxes
No info
Tax abatement
No info
About
Seller’s agent
Description
Excellent Mixed-Use Investment Opportunity in the Heart of Douglaston! This well-maintained three-story mixed-use property features a professional office on the first floor and basement, plus two spacious residential units above. The second floor offers 3 bedrooms and 2 full bathrooms, while the third floor features 3 bedrooms and 1.5 bathrooms.
Policies
Sorry, policy info isn’t available right now. Check back later.
Home features
No info on home features
Building amenities
No info on building amenities
About the building
42-18 235th Street
42-18 235th Street, Little Neck, NY 11363
2 units
3 stories
1970 built
For sale
1 available units for saleFor rent
0 available units for rentDocuments and permits
View documents and permitsProperty history
- Price change: No changes
- Days on market: 2 daysThis is the number of days the listing has been on StreetEasy.
| Date | Price | Event |
|---|---|---|
10/9/2026 | $1,888,000 | Listed by Prime Realty |
Sign in to take a closer look at how this home compares to similar homes.
Explore Douglaston
Transit
| Location | Distance |
|---|---|
LIRRat Douglaston | under 500 feet |
LIRRat Little Neck | 0.66 miles |
LIRRat Bayside | 1.21 miles |
Similar homes
Two-family home in Auburndale
46-47 204th Street #1- 10 beds
- 6.5 baths
- 5,600 ft²
Listing by B Square Realty
previousnextMixed-use building in Auburndale
198-18 32nd Road #3- 10 beds
- 6.5 baths
- 3,672 ft²
Listing by EXP Realty NYC
previousnext
previousnextThree-family home in Flushing
42-10 164th Street- 7 beds
- 5 baths
- 1,875 ft²
Listing by Century Homes Realty Group LLC
previousnextTwo-family home in Bay Terrace
215-44 23rd Road #2- 7 beds
- 5 baths
- 4,616 ft²
Listing by Remax 1st Choice
previousnextThree-family home in Flushing
42-08 164th Street- 7 beds
- 5 baths
- 1,875 ft²
Listing by Century Homes Realty Group LLC
previousnextMixed-use building in Murray Hill
35-26 150th Place- 13 beds
- 7+ baths
- 7,850 ft²
Listing by Prospes Real Estate Corp
previousnextRental unit in Flushing
43-65 156th Street- 12 beds
- 6 baths
- 4,914 ft²
Listing by Winzone Realty Inc
previousnextRental unit in Murray Hill
144-53 38th Avenue #6- 8 beds
- 8 baths
- 6,212 ft²
Listing by E Realty International Corp
