Browse Airbnbs for Sale
Explore active Airbnbs and STR-ready homes in Charlotte with verified income data.
View PropertiesAs of Apr, 27 2026
Rabbu ROI Score
Columbia shows standout short-term rental potential based on its current revenue, occupancy, and pricing trends.
Columbia, NC is a small but compelling short-term rental market where low home values and waterfront appeal create an unusually favorable revenue-to-price ratio. With an average annual revenue of $23,570 against an average home value of $295,953, and an ROI score of 78 out of 100, the market offers standout potential for investors willing to navigate its modest occupancy levels. The tiny supply of just 16 active listings suggests an uncrowded landscape where well-positioned properties can capture outsized seasonal demand.
According to Rabbu market data, the Columbia short-term rental market shows:
| Metric | Context | Value |
|---|---|---|
| Active Airbnb Listings | As of Apr, 27 2026 | 16 |
| Average Daily Rate (ADR) | vs. $262 state avg. | $132 |
| Average Occupancy Rate | vs. 34% state avg. | 28% |
| RevPAN | ADR * Occupancy Rate | $37 |
| Average Monthly Revenue | Historical 12-month average | $1,964 |
| Average Annual Revenue | Historical 12-month average | $23,570 |
Data sources: Rabbu proprietary analytics as of Apr, 27 2026 and Zillow Home Value Index (ZHVI) as of Apr, 27 2026.
Columbia's strong revenue-to-price ratio, limited competition, and natural waterfront attractions make it an appealing niche market for STR investors seeking high relative yields on affordable properties.
Key investment factors
"Columbia presents a standout opportunity for investors comfortable with a highly seasonal, low-inventory market. The revenue curve swings dramatically—June leads at $5,251 per month while February dips to just $588—so cash-flow planning around off-peak months is essential. With above-average marks in revenue-to-price ratio, market growth, and supply/demand balance, the fundamentals here favor investors who target larger properties and can optimize pricing during the summer surge. The main watchpoint is occupancy stability, which currently sits below average at 28%, making operational efficiency and guest experience key differentiators."
— Rabbu Market Analysis Team
Columbia's revenue is sharply seasonal, peaking at $5,251 in June and bottoming at $588 in February—a nearly 9x spread. Investors should plan for robust summer cash flow balanced against lean winter and early spring months, with November ($2,205) providing a notable secondary bump.
| Month | Trend | Revenue |
|---|---|---|
| January |
|
$1,788 |
| February |
|
$588 |
| March |
|
$792 |
| April |
|
$793 |
| May |
|
$2,067 |
| June |
|
$5,251 |
| July |
|
$3,187 |
| August |
|
$2,332 |
| September |
|
$1,925 |
| October |
|
$1,809 |
| November |
|
$2,205 |
| December |
|
$829 |
Supply is nearly evenly split across 1-bedroom (6 listings), 2-bedroom (5), and 3-bedroom (5) properties, totaling just 16 active listings. The balanced distribution and minimal inventory overall suggest room for new entrants in any size category, though 3-bedroom units may offer the best revenue justification for added investment.
| Size | Trend | Value |
|---|---|---|
| 1 bedroom |
|
6 |
| 2 bedrooms |
|
5 |
| 3 bedrooms |
|
5 |
ADR scales modestly from $114 for 1-bedroom to $116 for 2-bedroom properties, then jumps to $168 for 3-bedroom listings—a 45% premium over the smallest size. The steep rate increase at the 3-bedroom tier suggests guests are willing to pay significantly more for added space, making larger properties the sweet spot for pricing power.
| Size | Trend | Value |
|---|---|---|
| 1 bedroom |
|
$114 |
| 2 bedrooms |
|
$116 |
| 3 bedrooms |
|
$168 |
RevPAN climbs sharply with property size: 1-bedrooms generate just $16 per available night, while 2-bedrooms reach $43 and 3-bedrooms lead at $60. The nearly 4x gap between the smallest and largest sizes reflects both higher rates and much stronger occupancy for bigger units, reinforcing the case for investing in 3-bedroom properties.
| Size | Trend | Value |
|---|---|---|
| 1 bedroom |
|
$16 |
| 2 bedrooms |
|
$43 |
| 3 bedrooms |
|
$60 |
One-bedroom properties struggle at just 14% occupancy, while 2-bedroom (37%) and 3-bedroom (36%) listings perform more than twice as well. For investors prioritizing booking consistency and cash-flow stability, the data strongly favors properties with two or more bedrooms in this market.
| Size | Trend | Value |
|---|---|---|
| 1 bedroom |
|
14% |
| 2 bedrooms |
|
37% |
| 3 bedrooms |
|
36% |
Three-bedroom properties lead with $2,667 in average monthly revenue, outpacing 2-bedrooms ($1,731) by 54% and 1-bedrooms ($1,572) by 70%. The gap between 1- and 2-bedroom earnings is relatively modest, but the jump to 3 bedrooms represents a clear inflection point in monthly income potential.
| Size | Trend | Value |
|---|---|---|
| 1 bedroom |
|
$1,572 |
| 2 bedrooms |
|
$1,731 |
| 3 bedrooms |
|
$2,667 |
Annual revenue ranges from $18,866 for 1-bedroom properties to $32,010 for 3-bedroom units, with 2-bedrooms falling in between at $20,774. The 3-bedroom configuration delivers the strongest return potential, generating nearly 70% more annual revenue than 1-bedroom listings while competing within the same small supply pool.
| Size | Trend | Value |
|---|---|---|
| 1 bedroom |
|
$18,866 |
| 2 bedrooms |
|
$20,774 |
| 3 bedrooms |
|
$32,010 |
Every listing in Columbia offers a kitchen, and 88% include parking—essentials for this rural, drive-to market. Outdoor amenities are a defining feature: BBQ grills, patios, outdoor furniture, and backyards each appear in 63–69% of listings, while waterfront access (56%) and lake access (31%) highlight the nature-oriented guest expectations that investors should meet to stay competitive.
| Amenity | Trend | Value |
|---|---|---|
| Kitchen |
|
100% |
| Parking |
|
88% |
| Self Check-in |
|
75% |
| BBQ Grill |
|
69% |
| Washer |
|
69% |
| Patio or Balcony |
|
69% |
| Outdoor Furniture |
|
69% |
| Workspace |
|
63% |
| Dryer |
|
63% |
| Backyard |
|
63% |
| Waterfront |
|
56% |
| Pets |
|
50% |
| Lake Access |
|
31% |
| Hot Tub |
|
13% |
Rabbu's ROI Score is a proprietary metric that evaluates short-term rental investment potential based on multiple factors.
| Factor | Columbia Performance | Weight |
|---|---|---|
| Revenue-to-Price Ratio | Above average | 40% |
| Occupancy Stability | Below average | 30% |
| Market Growth Trend | Above average | 15% |
| Supply/Demand Balance | Above average | 15% |
Columbia's ROI score of 78 out of 100 places it in the 'Standout Opportunity' tier, driven primarily by an above-average revenue-to-price ratio and favorable supply/demand dynamics. The market also shows above-average growth trends, though occupancy stability is the one factor that lags, reflecting the sharp seasonality typical of nature-focused destinations. Pairing this score with thorough local regulatory research and a summer-weighted cash-flow model will give investors the clearest picture of realistic returns.
Understanding local STR regulations is essential before investing in Columbia. Here's the current regulatory landscape:
Short-term rental operators in Columbia, NC should verify whether Tyrrell County or the state of North Carolina requires specific permits, business licenses, or registration before listing a property. Regulations in smaller North Carolina markets can vary, so contacting local planning and zoning offices is a recommended first step.
Common restrictions that may apply to STR properties in this area include occupancy limits, noise ordinances, parking requirements, and minimum stay periods. Investors should also review any HOA covenants or deed restrictions that could limit short-term rental activity, particularly for waterfront properties.
North Carolina imposes a state sales tax and an occupancy tax on short-term rentals, and Tyrrell County may layer on additional local lodging taxes. Platforms like Airbnb often collect and remit some of these taxes automatically, but hosts should confirm full compliance with both state and county requirements.
Regulations subject to change. Always verify with local authorities before purchasing. A Rabbu partner agent specializing in Columbia can provide current regulatory guidance.
Financing an Airbnb investment in Columbia requires lenders who understand STR income. Rabbu partner lenders offer:
"Over the next 12–18 months, Columbia's STR market is likely to benefit from continued above-average growth trends and a favorable supply/demand balance—active listings grew 72% year over year, signaling rising investor interest and traveler demand alike. Summer months should remain the revenue anchor, with June potentially pushing monthly averages above $5,000, while off-peak periods like February and March may hover in the $600–$800 range. Investors should anticipate occupancy remaining around 25–32% market-wide, though larger properties with 2–3 bedrooms could outperform. ADR may see modest upward pressure in the range of 3–5% as the market matures and amenity standards rise."
— Rabbu Market Analysis Team
Rabbu provides Airbnb and short-term rental market data and statistics across the United States. Our mission is to empower investors with accurate insights and easy-to-use tools, so they can confidently identify and act on the best opportunities in the Airbnb market.
Rabbu proprietary analytics as of Apr, 27 2026 and Zillow Home Value Index (ZHVI) as of Apr, 27 2026. Revenue projections are estimates based on comparable properties and do not guarantee future performance. Data reflects trailing 12-month averages as of April 2026 and may not capture very recent market shifts. Local regulations, tax requirements, and permit rules are subject to change—investors should verify current rules with local authorities before purchasing.
Ready to invest in Columbia's short-term rental market? Take action with these resources:
Explore active Airbnbs and STR-ready homes in Charlotte with verified income data.
View PropertiesWork with specialized agents who've helped investors acquire over $650M in STR properties.
Find an AgentQualify for as low as 15% down on a DSCR loan using the rental property's projected income.
Find a Lender