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. Building size is approximately 20' x 52' (3,120 SF) situated on an exceptionally deep 20' x 258' lot (approximately 5,160 SF). Built in 1970 with annual property taxes of approximately $7,818. Property is equipped with 5 separate electric meters and 3 gas meters. Conveniently located in School District 26, close to the LIRR, Northern Boulevard, Cross Island Parkway, shopping, restaurants, and transportation. Excellent opportunity for investors, owner-users, 1031 exchange buyers, or long-term investment. A Must See.
Active
$1,888,000
42-18 235th St, Little Neck, NY 11363
6beds
3,120sqft
Mixed Use
Built in 1970
-- sqft lot
$1,818,700 Zestimate®
$605/sqft
$-- HOA
What's special
- 37 days
- 369
- 18
Zillow last checked:
Listing updated:
Listed by:
Prime Realty 917-254-0248,
Shirley Chen
Source: StreetEasy,MLS#: S1852413
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 6
- Bathrooms: 4
- Full bathrooms: 4
Features
- Has fireplace: No
Interior area
- Total structure area: 3,120
- Total interior livable area: 3,120 sqft
Property
Details
- Special conditions: Resale
Construction
Type & style
- Home type: SingleFamily
- Property subtype: Mixed Use
Condition
- Year built: 1970
Community & HOA
Community
- Subdivision: Douglaston
Location
- Region: Little Neck
Financial & listing details
- Price per square foot: $605/sqft
- Date on market: 10/9/2026
Estimated market value
$1,818,700
$1.73M - $1.91M
$4,217/mo
Price history
| Date | Event | Price |
|---|---|---|
| 8/8/2026 | Listed for sale | $1,888,000$605/sqft |
Source: | ||
Public tax history
Tax history is unavailable.







