Search
Gated Lake Community Resort
For Sale
Contact for pricing

980 County Road W, Fremont, NE 68025

For sale gated lake community with private roads, on-site security, and access to two lakes and multiple amenities.

Property Size6,029 SF
Price / SF$199.04
Days on Market109

Property Features for 980 County Road W

General Information

Standard status Active
Size 6,029 SF
Property subtype Retail
Zoning 03 - Commercial
Occupancy 100%
Investment Type Owner/User

Building Details

Year Built 1970
Year Renovated 2023
Units 2
Tenancy Multi
Listing Agency: NAI NP Dodge
Listed By: Brian Thomas · License #20210472
Source: Crexi
Added: May 5 Changed: Aug 14 Last Checked: Aug 20 at 8:17PM

Displayed information is deemed reliable but is not guaranteed and should be independently verified. All listing content including descriptions, pricing, images are the copyrighted material of NAI NP Dodge

Investment Insights

Based on property information with market context.

For sale: a gated lake community resort with private roads and on-site security, offering access to two distinct lakes. Lake Ski Di provides skiing and wakeboarding, while Lake Tirawa is designated for no-wake fishing. The community includes a convenience store, a community-owned activity center, and multiple restaurants and bars.

On-site recreation features a sandy bottom “party cove” with a waterslide and splash pad. Additional amenities include playgrounds, pickleball and basketball courts, and the ability to host live entertainment and organized tournaments. Gas access is available by both land and water within the community.

The property is located at 980 County Road W in Fremont, Nebraska.

Key Highlights

  • Gated lake community with private roads and on‑site security
  • Access to two lakes: Lake Ski Di and no‑wake Lake Tirawa
  • Lake Ski Di offers skiing and wakeboarding; Lake Tirawa is for peaceful fishing

Financial Insights

Estimated NOI and Cap Rate

NOI = area × lease_rate × (100 − vacancy) / 100 × (1 − expense_ratio). Net Operating Income — what the owner takes home each year before mortgage payments and income tax. Effective rent (asking rent minus vacancy losses) minus operating costs (taxes, insurance, maintenance, management).
NOI / Yr
$79,366
Cap rate = NOI / list price × 100. Capitalization rate — annual return on a fully cash purchase, before financing. NOI divided by price. Higher means more income per dollar invested, but usually also more risk or older condition. 5–8% is typical for stabilized commercial property; double digits often signal distressed deals.
Cap Rate
6.61%
Suggested Prices Based on Cap Rates Cap rates vary significantly by property type, market, and asset quality. Typical U.S. stable-market ranges: Multifamily — 4.5% to 6.5% (Class A in primary markets often sub-5%; Class C in secondary markets 6%+) Industrial / Logistics — 5.0% to 7.0% (compressed heavily in recent years due to e-commerce demand) Office — 6.5% to 9%+ (wide spread post-2020; CBD Class A vs. suburban Class B varies dramatically) Retail — 5.5% to 8.5% (grocery-anchored on the low end, unanchored strip centers higher) Hospitality / Hotels — 7.5% to 10%+ (higher due to operational risk) Self-Storage — 5.5% to 7.5% Medical Office — 6.0% to 7.5% Net Lease (single tenant, credit) — 5.0% to 7.0% depending on tenant credit and lease term Rules of thumb: Primary markets (NYC, SF, LA, Boston, DC) trade at lower cap rates than secondary/tertiary markets, often by 100–200 bps (bps, aka basis points; 1 bp = 0.01%). Class A assets trade ~50–150 bps tighter than Class B, and Class B tighter than Class C. Cap rates move inversely with price — a lower cap rate means a higher price for the same NOI. Spread to the 10-year Treasury is a common benchmark; historically 200–400 bps over the 10-year.
Cap Rate 5%
$1,587,320 $1.6M
Cap Rate 7%
$1,133,800 $1.1M
Cap Rate 9%
$881,844 $881.8K
Market Conditions
NOI Build-Up for 6,029 SF Vacancy — income lost from leasable area expected to sit empty during the year, subtracted from gross rent. EGI (Effective Gross Income) — gross rent minus vacancy losses, the realistic income before paying operating costs. OpEx (Operating Expenses) — recurring costs to operate the property (property tax, insurance, utilities, maintenance, management); excludes financing and capital improvements. NOI (Net Operating Income) — income a property generates after operating costs but before financing and taxes.
Gross rent
$110.7K $18.36/SF
− Vacancy
−$4.9K −$0.81/SF
EGI
$105.8K $17.55/SF
− OpEx
−$26.5K −$4.39/SF
NOI
$79.4K $13.16/SF
Area
Dodge County, NE
Vacancy
4.40%
Lease Rate
$18.36 /SF/Yr
Expense Ratio
25.00%
Simulate Cap Rate and NOI
Suggested Prices Based on Cap Rates Cap rates vary significantly by property type, market, and asset quality. Typical U.S. stable-market ranges: Multifamily — 4.5% to 6.5% (Class A in primary markets often sub-5%; Class C in secondary markets 6%+) Industrial / Logistics — 5.0% to 7.0% (compressed heavily in recent years due to e-commerce demand) Office — 6.5% to 9%+ (wide spread post-2020; CBD Class A vs. suburban Class B varies dramatically) Retail — 5.5% to 8.5% (grocery-anchored on the low end, unanchored strip centers higher) Hospitality / Hotels — 7.5% to 10%+ (higher due to operational risk) Self-Storage — 5.5% to 7.5% Medical Office — 6.0% to 7.5% Net Lease (single tenant, credit) — 5.0% to 7.0% depending on tenant credit and lease term Rules of thumb: Primary markets (NYC, SF, LA, Boston, DC) trade at lower cap rates than secondary/tertiary markets, often by 100–200 bps (bps, aka basis points; 1 bp = 0.01%). Class A assets trade ~50–150 bps tighter than Class B, and Class B tighter than Class C. Cap rates move inversely with price — a lower cap rate means a higher price for the same NOI. Spread to the 10-year Treasury is a common benchmark; historically 200–400 bps over the 10-year.
Cap Rate 5%
$1,587,320
Cap Rate 7%
$1,133,800
Cap Rate 9%
$881,844

Alternative Uses

Best Use
Specialty Retail
$1.13M
$992.1K – $1.32M (±1% cap)
NOI $79,366 @ 7.0% cap · market cap 6.61%
Second Best
Retail
$1.06M
$925.9K – $1.23M (±1% cap)
NOI $74,075 @ 7.0% cap · market cap 6.17%
Theoretical Best
Office A
$1.62M
$1.42M – $1.89M (±1% cap)
NOI $113,254 @ 7.0% cap · market cap 9.44%
Zoning and permitted uses should be independently verified with authorities.

Property Analytics

Current Use

Woodcliff Community Center Hotel & Motel Clinton Werner Physician Bo’s Beach Sifting Landscaping Pops Pizza and Wings Bar & Pub The Woodcliff Restaurant Restaurant

Suggested Use

Top Pick Parking Lot & Garage HVAC Service (Bike/Boat/Book/etc) Store Garden Center Locksmith Catering Service

Score = modeled unmet demand for each use within ~1 mi (higher = bigger opportunity). Zoning and permitted uses should be independently verified with local authorities.

Location Intelligence

Trade Area within ½ mile

819
Businesses Nearby
14k
Monthly Visits Nearby

Foot Traffic Nearby

Dining 72% Shops & Services 22% Home Improvements & Furnishings 6%
Runza Dining
7,367 visits/mo 0.2 miles
Pinnacle Bank Shops & Services
3,081 visits/mo 0.2 miles
SUBWAY Dining
1,625 visits/mo 0.2 miles
Zesto Dining
896 visits/mo 0.2 miles
Sherwin-Williams Paint Store Home Improvements & Furnishings
776 visits/mo 0.4 miles

Demographics for 68025, NE

31,301
Population
14,017
Households
2.2
Avg Household Size
38
Median Age
22%
College-Educated
89%
High-School Grad
124.0 sq mi
ZIP Area
252
Density / Sq Mi
$69,467
Median Household Income
$41,546
Median Earnings
$1,005
Median Rent
$201,900
Median Home Value

Market

Vacancy Rate% for Retail in Midwest region

8% 2020
7.3% 2021
6.5% 2022
6% 2023
5.7% 2024
6.3% 2025
Rey
Questions? Ask Rey
Realmo’s AI knows this listing — price, zoning, demand, history. Ask anything.

Frequently Asked Questions

What type of property is this?
Campground - For sale gated lake community with private roads, on-site security, and access to two lakes and multiple amenities.
Where is this campground located?
The property is located at 980 County Road W Fremont, NE.
What is the asking price?
The asking price for this property is $1,200,000.
What are key features of this property?
This property features: Gated lake community with private roads and on‑site security; Access to two lakes: Lake Ski Di and no‑wake Lake Tirawa; Lake Ski Di offers skiing and wakeboarding; Lake Tirawa is for peaceful fishing
(402) 255-6060 Call to check price and availability
More about this property
Thanks! Your message was sent.
Error! Your message wasn't sent.
Please enter your name
Please enter email
Please enter the email in the correct format
Please enter phone
Please enter the number in the correct format
Please enter message