
Active listing is a short-term rental property that has demonstrated booking activity — such as a confirmed reservation, calendar update, or availability change — within the past 12 months. This classification separates genuinely competitive properties from stale or abandoned listings, giving hosts and investors an accurate measure of true market supply rather than a bloated count of every profile ever created on a platform.
Understanding the distinction is the foundation of accurate market analysis:
| Classification | Definition | Market Impact |
|---|---|---|
| Active listing | Booking or calendar activity within 12 months | Genuine competitor; counts toward true supply |
| Seasonal listing | Active only during certain months | Increases supply during peak periods; eases off-season competition |
| Dormant listing | Published but no activity for 12+ months | Inflates raw platform counts but not actual supply |
| Delisted property | Removed from platform | No longer part of supply; sometimes a leading indicator of host attrition |
Active listing volume varies enormously by market size, regulatory environment, and investment maturity. In AirROI's analysis of more than 59,000 active listings across seven US markets, the range runs from New York's 11,468 to New Orleans' 5,007 — but raw count alone is less informative than count relative to local demand.

In AirROI's analysis of 59,013 active listings across New York, Los Angeles, San Diego, Austin, Miami, Nashville, and New Orleans, New York leads by count (11,468) while New Orleans posts the lowest (5,007) — yet New Orleans hosts achieved a median ADR of $335, higher than New York's $225, illustrating that smaller active supply does not mean weaker pricing power.
The number that matters is not how many listings a platform shows — it is how many hosts are actually competing for guests right now. Active listing count is the answer to that question.
Active listing data drives several core analytical workflows:
Regulation is the most abrupt force acting on active listing counts. In New York City, after Local Law 18 took effect in September 2023, AirROI data shows active listings declined from approximately 26,775 to roughly 10,500 by April 2026 — a drop of more than 60%. Short-stay listings under 30 nights fell by approximately 90% (NYC Mayor's Office). The median minimum-night requirement in New York now sits at 25.8 nights, reflecting a near-complete shift to 30-day-minimum stays.
By contrast, markets with lighter regulatory regimes maintain far more stable active supply. Gatlinburg, TN — classified as a light-regulation market — holds 3,622 active listings with a median occupancy of 47% and median ADR of $377. The regulatory variable deserves as much attention as the raw listing count. Second-tier cities are now replicating New York-style ordinances, compressing active supply in markets that previously looked unconstrained.
| Trend | What It Means | Recommended Action |
|---|---|---|
| Active listings growing faster than demand | Increasing competition | Strengthen differentiation; optimize pricing with dynamic pricing |
| Active listings declining | Hosts exiting the market | Potential opportunity if demand holds stable |
| Seasonal active listing spikes | Part-time hosts entering during peaks | Raise peak-season rates proactively |
| Active listing count stable | Mature, balanced market | Focus on operational excellence and reviews |
For a structured way to apply these metrics, the STR investment analysis guide walks through how to combine active listing counts with revenue and occupancy data in a full underwriting model.
To pull active listings for a specific market into an AI assistant, query active listings from Claude via MCP: AirROI's airroi_market_active_listings tool returns the monthly figures for any market, with up to 60 months of history per request.
Total listing counts include dormant, delisted, or abandoned properties that inflate supply figures. Active listings provide a more accurate picture of the real competitive landscape because they represent properties that are actually competing for bookings in the market.
Look for recent reviews (within the last 3-6 months), updated calendar availability, and current pricing. A market analytics tool like AirROI can filter for active listings automatically, showing you only the properties that are genuinely competing in your market.
When active listing count grows faster than demand, occupancy rates compress and ADR tends to soften as hosts compete for the same pool of guests. Conversely, a declining active supply in a stable-demand market gives remaining hosts pricing leverage and higher occupancy. Tracking the ratio of active listings to demand is the earliest indicator of shifting market dynamics.
Strict regulation can dramatically shrink active supply. In New York City, after Local Law 18 took effect in September 2023, AirROI data shows active listings fell from roughly 26,775 to approximately 10,500 by April 2026 — a drop of more than 60%. Markets with lighter regulatory regimes like Gatlinburg, TN maintain far more stable active supply, which directly supports host revenue.