Property summary
This exceptional mixed-use property at 1870 Harman Street in the desirable Ridgewood neighborhood of Queens, New York, presents a unique investment opportunity. The property consists of three buildings totaling 5,635 square feet on a 5,000-square-foot lot (50ft x 100ft). Currently vacant, this offering includes a three-family residential building (approximately 3,735 sq ft), a commercial building with a workshop and garage (approximately 700 sq ft), and an office space (approximately 1,200 sq… ft). The property is a well-maintained building showcasing historical features, though it is not landmarked. Significant redevelopment potential exists, with 3,000 square feet of unused air rights and a permitted R5B zoning designation allowing for higher-density development, resulting in a total buildable square footage of 6,750. The asking price is $2,400,000. This semi-attached building presents an excellent owner-user opportunity or a prime candidate for significant development and redevelopment. The property's location in Ridgewood, a highly sought-after area, further enhances its investment appeal. Built in 1920, this Class B property offers five units and is currently vacant, providing immediate flexibility for the new owner.
Ownership intelligence
Resolved identity, portfolio, hold profile and investor signals. Included in the full report.
Owner contacts
Skip-traced phones and e-mails of the owner. Included with the full report.
Mortgages
Recorded lenders, amounts and estimated maturities of the owner's loan book — in the full report.
Property tax
No data for this sectionNo tax or assessment record is on file for this parcel in the county feed.
Value estimate
· Sep 2026No data for this sectionNo value estimate could be modeled: the record carries too little market input for this parcel.
Recently sold
No data for this sectionNo cleaned sale $/SF benchmark exists for this use type in this ZIP, submarket or county yet.
Cap rate analysis
No income signal is modeled for this parcel yet — the Cap Rates tab runs the workflow.
Zoning insight
No data for this sectionNo zoning code is on file for this parcel. Coverage grows with every catalog release.
Location intelligence
Demand index: how under-served this business type is around this point — modeled from the LocInt grid (area demand vs. what already operates, adjusted by real visit traffic). Higher means stronger unmet demand.
Location
Every figure names its source: public record, benchmark, or modeled. Coverage varies by property — thin data is stated as missing, never invented.
Comparables
6 recent transactions · within 1.5 miComparable in this City
Similar Nearby for Sale
Similar Nearby for Lease
Instant AI valuation built from comps, income signals, and proprietary benchmarks.A defensible range, not a single guess.
from $99/month
Cap rate calculated from real income and expense signals, benchmarked against sales of similar assets nearby.
from $99/month
The recorded zoning designation, what the district officially allows, and the municipal source it comes from.
No zoning code is on file for this parcel. Zoning coverage grows with every catalog release — check back, or open Location Intelligence for use analysis of this corner.
Phones and e-mails of the people behind this property's owner, traced from licensed contact data.
Owner phones and e-mails come with the full report for this property - traced from licensed contact data, with verification and Do-Not-Call flags on every number.
Unlock the evidence behind ownership: portfolio, transactions, debt and signals that help you decide who to contact next.
Registration is required before any owner information is shown.
The mortgage data is behind the paid report: recorded loans of the owner - lender, amount, rate and the estimated maturity - as part of the Ownership Intelligence workspace.
Registration is required before any owner information is shown.
- Ownership
- Owner Contacts
- Full Property Data
- Historical Records
- Value Estimation
- NOI Potential
- Cap Rate Calculation
- Location Insight
- Alternative use
- Local Zoning Insight
Cancel anytime.
- 30 reports a month
- Ownership
- Owner Contacts
- Full Property Data
- Historical Records
- Value Estimation
- NOI Potential
- Cap Rate Calculation
- Location Insight
- Alternative use
- Local Zoning Insight
- Location Analytics
Cancel anytime.
- 300 reports a month
- Ownership
- Owner Contacts
- Full Property Data
- Historical Records
- Value Estimation
- NOI Potential
- Cap Rate Calculation
- Location Insight
- Alternative use
- Local Zoning Insight
- Location Analytics
and get 1 Light Report
- Full Property Data
- Historical Records
- Value Estimation
- NOI Potential
- Cap Rate Calculation
- Location Insight
- Alternative use
- Local Zoning Insight
