Property summary
This exceptional 18,279 square foot mixed-use property, located at 861 Aquidneck Avenue in Middletown, Rhode Island, presents a unique investment opportunity. Built in 1939, this single-story building sits on a sizable lot and offers versatile potential for a variety of uses, including commercial, medical office, executive office, residential, and even farming, thanks to its Limited Business Zone designation. The property has undergone recent significant upgrades, including a new roof,… electrical line and box, a newly installed well water tank and city sewer connection, all-new windows, fresh paint, a modern kitchen, and a modern bathroom, as well as a new hot water boiler. Its prime location on Aquidneck Island provides easy access to Rhode Island's beautiful beaches and vibrant attractions. The property's proximity to Newport's waterfront, historic mansions, breweries, wineries, restaurants, cafes, parks, hiking trails, and downtown Newport adds significant value and appeal. This is an ideal opportunity to combine residential and business ventures in a desirable location. The property is zoned for limited business use, allowing for a blend of residential and commercial activities. While the square footage of the building itself is not specified, the expansive lot size offers ample space for development and expansion. This property is ready for immediate occupancy and offers a rare chance to own a piece of Aquidneck Island's thriving community.
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
