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 Market37
Property Features for 2560 MILLERVILLE RD
General Information
Property type
Commercial Sale
Property subtype
Other
Bedrooms
6
Bathrooms
4
Full bathrooms
4
Rooms
Bedroom 4, Bedroom 3, Bathroom 4, Bedroom 5, Bedroom 6, Bedroom 2, Bathroom 1, Bathroom 3, Bedroom 1, Bathroom 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
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
Shingle, Composition
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 25
Last Checked: Sep 2 at 5: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.
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
Property Profile
Current Use
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
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 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
