Columbia, MO
Unlock the data for all Markets
Overview
Annual Rev
$30.8k
12 mo avg
↑5%
from prior 12 mo
Occupancy rate
30%
12 mo avg
↓4%
from prior 12 mo
Avg daily rate
$210
12 mo avg
↑17%
from prior 12 mo
Lead time
35 days
12 mo avg
↓5 days
from prior 12 mo
Revpar
$63
12 mo avg
↓7%
from prior 12 mo
Methodology note: Figures reflect Columbia market data as of September 2026. Data covers Airbnb, VRBO, and Booking.com listings. Values are seasonally influenced; rounding applied for readability.
Revenue per listing by bedroom
Bedroom count:
0
1
2
3
4+
Short-term rental supply growth
Performance metrics by bedroom
Bedrooms
Annual Rev
Avg. Zestimate
Gross yield
Supply
Amenity revenue impact
| Amenity | Est. revenue impact |
|---|---|
| Hot Tub | +19% $5,852/yr |
| Barbecue | 🔒 +7% · $••••/yr Revenue lift and listing count available in Markets |
| EV Charger | 🔒 +7% · $••••/yr Revenue lift and listing count available in Markets |
| Heating | 🔒 +7% · $••••/yr Revenue lift and listing count available in Markets |
| Lake Access | 🔒 +7% · $••••/yr Revenue lift and listing count available in Markets |
| Pool | 🔒 +6% · $••••/yr Revenue lift and listing count available in Markets |
| Sauna | 🔒 +6% · $••••/yr Revenue lift and listing count available in Markets |
| Gym | 🔒 +4% · $••••/yr Revenue lift and listing count available in Markets |
| Bicycles | 🔒 +3% · $•••/yr Revenue lift and listing count available in Markets |
| TV | 🔒 +1% · $•••/yr Revenue lift and listing count available in Markets |
Nightly rate by day of week
Occupancy rate by day of week
Listings by channel
Listings by rental type
Listings by amenities
Listings by size
4+ bedrooms (0%)
Listings by availability
Length of stay by bedroom
1 bedroom (5.1 nights)
2 bedrooms (4.4 nights)
3 bedrooms (4.4 nights)
4+ bedrooms (4.0 nights)
Cleaning fee by bedroom
4+ bedrooms ($135)
3 bedrooms ($90)
2 bedrooms ($65)
1 bedroom ($56)
Professional host share
Professionally managed (60%)
Independent hosts (40%)
Housing market signals
See how home prices, supply, and buyer competition are changing before you invest.
Are home values in Columbia going up or down?
Unlock five years of home value changes and Zillow's next-year forecast.
Which home type gives you the most space for the price?
Over the 12 months ending August 2026, the Columbia market averaged 952 active Airbnb and VRBO listings, down 2% from a year earlier and up 104% over two years.
An average Columbia listing earns $28K/year. High-performing listings earn $59K, while low-performing listings earn $12K.
Median Columbia home prices by size are 1-bedroom $155K, 2-bedroom $189K, 3-bedroom $271K, and 4+ bedroom $366K.
Average gross yield is 10%, reaching 21% for high-performing listings. Gross yield excludes financing and operating costs, so net profitability varies by property.
Average occupancy in Columbia is 30%, producing RevPAR of $59 per available night.
3-bedroom listings have the highest average gross yield at 13%. They average $36K/year in revenue against a $271K median purchase price.
Rules vary across Columbia. Columbia: Moderate. Business license required, zoning restrictions in some neighborhoods, 2-person per bedroom occupancy limits. Moderate enforcement through complaints. Jefferson City: Lenient. No specific STR regulations, standard business license may apply. Minimal enforcement, operates under general lodging rules. Lake of the Ozarks: Lenient. Unincorporated areas have minimal county oversight, village regulations vary but generally permissive. Light enforcement, tourism-friendly market. Verify requirements for the property's jurisdiction.
The Columbia Airbnb and VRBO market appears broadly balanced. Supply has declined 2% year-over-year, while RevPAR has increased 0%, showing no clear supply-demand imbalance.
RevPAR is highest in July and June; it is lowest in January and February.
The most common amenities are Air Conditioning (99%), Internet (97%), Heating (97%). The strongest positive revenue associations are Washing Machine (+14%), Bbq (+10%), TV (+9%).
Average daily rate in Columbia is $239, up 19% year-over-year. Rates peak in November and are lowest in February.
Guests in Columbia book an average of 35 days in advance, down 6% from last year. Booking windows range from 33 days for 3-bedroom listings to 38 days for 4+ bedroom listings.
Booking demand is highest on Saturday and lowest on Monday. Nightly rates peak on Saturday and are lowest on Tuesday. Weekend occupancy is 86% higher than weekday occupancy.