30 photos
Prospect analysis
210 N Joliet AVENUE
Asking$774,900
Sturgeon Bay · Joliet, WI · 4 bd · 3 ba · 1,934 sq ft · Built 1941
Underwritten as a short-term rental
Waterfront 4-bedroom property in Sturgeon Bay with recent renovations and strong short-term rental income projections.
This property offers direct water access, a sandy beach, and proximity to downtown Sturgeon Bay, positioning it as a high-appeal STR asset. Underwriting metrics indicate robust projected cash flow and returns, though performance is sensitive to occupancy and nightly rate assumptions.
Est. ADR
$560
Est. occupancy
68%
Gross rev / mo
$11,583
Cash-on-cash
37.2%
Airfolio market estimates · 20% down · detail in the underwriting panel.
Investment thesis
This Sturgeon Bay waterfront property stands out for its rare shoreline access, updated main level, and walkability to local amenities, making it well-suited for short-term rental investors targeting vacationers. The high-confidence underwriting projects strong cash flow and a compelling cash-on-cash return, supported by a premium nightly rate assumption and solid occupancy. The primary caveat is that the investment thesis relies on maintaining high STR demand and premium pricing, which should be validated against local competition and regulatory environment. This opportunity is best suited for investors seeking a turnkey, high-yield asset in a desirable Door County location.
Highlights
- Direct waterfront access with sandy beach
- 4 bedrooms and 3 bathrooms
- Recent renovations: main level remodel (2016/2017), new windows, siding, doors, roof, and decks (2016)
- 1,934 sqft living area on a 6,098 sqft lot
- Listed at $774,900, in line with recent comparable sale
- High-confidence valuation consensus across sources
- Projected monthly STR income of $11,583 and cash flow of $4,809
- Expected cash-on-cash return of 37.2% (high-confidence underwriting)
Risks
STR permitting: verify local ordinance and zoning allow short-term rental at this address before offering. Not verified.
STR regulations and local ordinances should be verified for Door County
Returns are sensitive to occupancy and ADR assumptions; premium pricing must be sustained
Older property (1941) may require ongoing maintenance despite recent updates
Seasonal demand fluctuations typical for waterfront vacation markets
Higher price point narrows the buyer pool for future resale
Market
Sturgeon Bay, in Door County, WI, is a well-known vacation destination with strong seasonal demand for waterfront rentals. The property type—a renovated, mid-century waterfront home—caters to families and groups seeking premium short-term accommodations. The market supports premium ADRs, but performance is contingent on continued tourism demand and regulatory stability. Underwriting is supported by high-confidence valuation and rental estimates, though investors should monitor local STR competition and policy changes.
Neighborhood
The property’s location offers direct water access and walkability to downtown Sturgeon Bay, enhancing guest appeal for both leisure and convenience. The area is characterized by a mix of residential and vacation properties, with amenities such as restaurants, marinas, and parks nearby. While detailed neighborhood demand signals are limited, the combination of waterfront setting and proximity to attractions suggests strong guest appeal at moderate-to-high confidence.
Underwriting notes
At a $774,900 purchase price, underwriting projects a monthly STR income of $11,583 and cash flow of $4,809, assuming a $560 ADR, 68% occupancy, and a 25% expense ratio. The expected cash-on-cash return is 37.2%, driven by premium nightly rates and solid occupancy assumptions. These projections are high-confidence but sensitive to market conditions and STR demand; investors should validate the sustainability of these assumptions during diligence.
Value context
Airfolio est.Modeled value
$760,000
Modeled range
$710,600–$785,400
Asking
$774,900
Asking sits within the modeled range.
Solid: value history · Dashed: 24-month projection with confidence band. Airfolio estimates, not appraisals.
As of Sep 2, 2026 · Modeled from record, listing, and market data. An estimate, not an appraisal.
Tax history
| Year | Assessed value | Taxes |
|---|---|---|
| 1970 | $629,000 | $8,669 |
Sign up free to adjust these assumptions and save your own underwriting.