Property summary
This exceptional commercial redevelopment opportunity encompasses three contiguous parcels totaling 0.29 acres at 234 Sunset Ave, Herkimer, NY. Currently featuring a commercial repair shop and two single-family dwellings, the seller requires the sale of all three parcels together, "as is," for redevelopment purposes. This prime location sits on a major four-corner intersection boasting an impressive 20,000 vehicles passing daily, ensuring high visibility and accessibility for any new venture.… The property's strategic positioning offers unparalleled exposure, situated within sight of a Walmart main entrance and adjacent to established fast-food giants such as KFC, Taco Bell, and McDonald's. This high-traffic area presents an ideal setting for a variety of commercial uses, including but not limited to a coffee shop or small retail establishment. The existing structures provide a solid foundation for redevelopment, allowing for creative adaptation or complete demolition to suit a new development plan. The combined acreage and high daily traffic count make this a rare and compelling investment opportunity in a thriving commercial zone. The asking price for this unique redevelopment project is $550,000. Serious inquiries only.
Ownership intelligence
Owner of record from public deeds, plus portfolio, hold profile and investor signals where the data supports them. 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
2 recorded salesInstant AI valuation built from comps, income signals, and proprietary benchmarks.A defensible range, not a single guess.
from $99/month
- Lot area
- 0.29 ac
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 any signals we can model, to 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
- Location Analytics
- Everything in the Light report
- Full Property Data
- Historical Records
- Value Estimation
- NOI Potential
- Cap Rate Calculation
- Location Insight
- Alternative use
- Local Zoning Insight
Cancel anytime.
- 300 reports a month
- Ownership
- Owner Contacts
- Location Analytics
- Everything in the Light report
- Full Property Data
- Historical Records
- Value Estimation
- NOI Potential
- Cap Rate Calculation
- Location Insight
- Alternative use
- Local Zoning Insight
and get 1 Light Report
- Full Property Data
- Historical Records
- Value Estimation
- NOI Potential
- Cap Rate Calculation
- Location Insight
- Alternative use
- Local Zoning Insight
The PDF can’t be displayed here
Use Download PDF or Open in new tab above to view the sample report.
