Furnished Waterfront Rental
For Sale
$849,000
2560 MILLERVILLE RD, Phelps, WI 54554
CommercialSale, Phelps, WI
Property SizeContact for details
Lot Size0.75 Acres
Days on Market100
Property Features for 2560 MILLERVILLE RD
General Information
Property type
Commercial Sale
Property subtype
Other
Bedrooms
6
Bathrooms
4
Full bathrooms
4
Rooms
Bathroom 1, Bathroom 4, Bathroom 2, Bathroom 3, Bedroom 1, Bedroom 6, Bedroom 3, Bedroom 4, Bedroom 5, Bedroom 2
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
Additional Details
Currently Operating
Yes
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
Forced Air, Space Heater, Natural Gas
Cooling system
Central Air
Water source
Public
Water front features
Lake Front
Water front
1
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: Oct 26
Last Checked: Nov 4 at 12:06PM
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.
Ask AI about this property
Review the available facts, identify missing information and prepare questions for the agent.
Investment Insights
Based on property information with market context.
This offering combines three fully furnished waterfront condominium homes conveyed together as one package. The residences provide a total of 6 bedrooms and 4 bathrooms, with each home separately identified by its own tax parcel within a single condominium declaration. Public water and sewer serve the property, while heating includes natural gas, forced air, and space heaters; central air is also installed.
Set on 0.75 acres along 2,788-acre North Twin Lake, the property includes lake frontage, upgraded decks, dock extensions, and a 5,000-lb. power boat lift with solar charging. The public boat landing and Great Escape Bar & Restaurant are steps away, with downtown Phelps minutes from the property. Recent work includes a new furnace, water heater, front door, washer and dryer in the Eagle Nest unit, electrical upgrades, a new ceiling, and central-air ductwork for future expansion.
Set on 0.75 acres along 2,788-acre North Twin Lake, the property includes lake frontage, upgraded decks, dock extensions, and a 5,000-lb. power boat lift with solar charging. The public boat landing and Great Escape Bar & Restaurant are steps away, with downtown Phelps minutes from the property. Recent work includes a new furnace, water heater, front door, washer and dryer in the Eagle Nest unit, electrical upgrades, a new ceiling, and central-air ductwork for future expansion.
Key Highlights
- Three fully furnished waterfront condominium homes offered together
- Combined configuration of 6 bedrooms and 4 bathrooms
- 0.75 acres with frontage on 2,788‑acre North Twin Lake
Property Analytics
Who owns this building?
See the owner, sales and loan history
Open Analytics
Lease Details
3
Residential units
Location Intelligence
Trade Area within ½ mile
32
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
Check the figures for this property
Cap Rate, Value Estimation, Potential NOI and more
View Realmo Analytics
Market
Vacancy Rate% for Multifamily in Midwest region
Frequently Asked Questions
What type of property is this?
Short term rental property - Three furnished condominium homes offer shared lake access, private tax parcels, and flexible short-term rental or retreat 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 $849,000.
What are key features of this property?
This property features: Three fully furnished waterfront condominium homes offered together; Combined configuration of 6 bedrooms and 4 bathrooms; 0.75 acres with frontage on 2,788‑acre North Twin Lake
