Furnished Waterfront Short-Term Rental
For Sale
$950,000
2560 MILLERVILLE RD, Phelps, WI 54554
COMMERCIAL - Phelps, WI
Property SizeContact for details
Lot Size0.75 Acres
Days on Market10
Property Features for 2560 MILLERVILLE RD
General Information
Property type
Commercial Sale
Property subtype
Other
Bedrooms
6
Bathrooms
4
Full bathrooms
4
Rooms
Bedroom 2, Bedroom 4, Bathroom 3, Bathroom 1, Bedroom 3, Bathroom 4, Bedroom 1, Bathroom 2, Bedroom 6, Bedroom 5
Parking features
Garage
Lot features
Dead End, Lake Front, Level, Views, Wooded
View
Water
Directions
Hwy 70 east and turn left onto Hwy 45 north. Turn left onto Hwy 17 north and at Millerville Road turn left to 2560,2554 and 2556 Millerville Rd. Sign on property.
Standard status
Active
APN
18-369-31
Lot size
0.75 Acres
Taxes and HOA fees
Tax Year
2025
Tax Description
UNIT 1 NORTH TWIN LAKE VIEW CONDO & 33.33% INT CE UNIT 2 NORTH TWIN LAKE VIEW CONDO & 33.34% INT CE UNIT 3 NORTH TWIN LAKE VIEW CONDO & 33.33% INT CE UNIT 4 NORTH TWIN LAKE VIEW CONDO PROPOSED GARAGE UNIT UNIT 5 NORTH TWIN LAKE VIEW CONDO GARAGE UNIT UNIT 6 NORTH TWIN LAKE VIEW CONDO GARAGE UNIT
Tax Annual Amount
2006
Legal Description
UNIT 1 NORTH TWIN LAKE VIEW CONDO & 33.33% INT CE UNIT 2 NORTH TWIN LAKE VIEW CONDO & 33.34% INT CE UNIT 3 NORTH TWIN LAKE VIEW CONDO & 33.33% INT CE UNIT 4 NORTH TWIN LAKE VIEW CONDO PROPOSED GARAGE UNIT UNIT 5 NORTH TWIN LAKE VIEW CONDO GARAGE UNIT UNIT 6 NORTH TWIN LAKE VIEW CONDO GARAGE UNIT
Utilities
Sewer type
Public Sewer
Heating system
Natural Gas, Forced Air, Space Heater
Cooling system
Central Air
Water source
Public
Water front features
Lake Front
Water front
1
Amenities
boat lift
dock
decks
Building Details
Roof type
Composition, Shingle
Listing Agency:
RE/MAX PROPERTY PROS · RE/MAX International
(715) 480-4333
Listed By:
KAY REIL · License #51999 - 90
(715) 891-1094
Added: Jul 28
Changed: Aug 4
Last Checked: Aug 6 at 4:06AM
MLS# 218865
Copyright © 2026 Greater Northwoods MLS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.
Investment Insights
Based on property information with market context.
This offering combines three furnished waterfront condominium homes into one short-term rental portfolio on North Twin Lake. Together, the residences provide 6 bedrooms and 4 bathrooms, with each home assigned its own tax parcel under a shared condominium declaration. The 0.75-acre property includes a garage, public water, public sewer, natural gas, forced-air heat, space heating, and central air.
The lakefront setting is on 2,788-acre North Twin Lake, with access to boating, fishing, swimming, and year-round recreation. A public boat landing and Great Escape Bar & Restaurant are located steps from the property, while downtown Phelps is minutes away. Recent improvements include a new furnace and water heater, updated electrical work, upgraded decks, a 5,000-lb. power boat lift with solar charger, two additional dock sections, a new ceiling in the Eagle Nest unit, and central-air ductwork prepared for future expansion. Furnishings are included.
The lakefront setting is on 2,788-acre North Twin Lake, with access to boating, fishing, swimming, and year-round recreation. A public boat landing and Great Escape Bar & Restaurant are located steps from the property, while downtown Phelps is minutes away. Recent improvements include a new furnace and water heater, updated electrical work, upgraded decks, a 5,000-lb. power boat lift with solar charger, two additional dock sections, a new ceiling in the Eagle Nest unit, and central-air ductwork prepared for future expansion. Furnishings are included.
Key Highlights
- Three furnished condominium homes sold together as one portfolio
- Combined 6 bedrooms and 4 bathrooms across the three residences
- Waterfront property on 2,788‑acre North Twin Lake
Property Analytics
Property Profile
Current Use
Location Intelligence
Trade Area within ½ mile
1
Businesses Nearby
Explore this area
Business Placement
Demographics for 54554, WI
1,042
Population
1,279
Households
0.8
Avg Household Size
60
Median Age
17%
College-Educated
98%
High-School Grad
80.9 sq mi
ZIP Area
13
Density / Sq Mi
$58,478
Median Household Income
$41,080
Median Earnings
$730
Median Rent
$222,600
Median Home Value
Market
Vacancy Rate% for Multifamily in Midwest region
Questions? Ask Rey
Realmo’s AI knows this listing — price, zoning, demand, history. Ask anything.
Frequently Asked Questions
What type of property is this?
Short term rental property - Three condominium residences offer six bedrooms, four bathrooms, and turnkey furnishings for continued vacation rental use.
Where is this short term rental property located?
The property is located at 2560 MILLERVILLE RD Phelps, WI.
What is the asking price?
The asking price for this property is $950,000.
What are key features of this property?
This property features: Three furnished condominium homes sold together as one portfolio; Combined 6 bedrooms and 4 bathrooms across the three residences; Waterfront property on 2,788‑acre North Twin Lake
