$2,850,000

Estimated payment $16,430/month

Total Views 54,485
4 Beds
2.5 Baths
3,537 Sq Ft
$806 Price per Sq Ft

Highlights

  • Marina
  • Barn
  • RV Access or Parking
  • Lake Front
  • Horses Allowed On Property
  • 30 Acre Lot

About This Home

Are you searching for a property that offers unrivaled water activities on your own private lake? Are you seeking a lucrative business opportunity? Madison Lake has everything you need! Property at a Glance: Madison Lake is a gated 30-acre estate containing a serene, 18-acre lake that can be used for many water activities like Jet Skiing, Wake Surfing, Water Skiing, Kayaking, Canoeing, Waterfowl Hunting, fishing & more. It has a concrete observation tower w/ a public bathroom near the large dock on the South side of the lake. This lake has a surveyed slalom course. It was featured in WaterSki magazine & has hosted regional competitions twice. Many waterski & wakeboard professionals have held clinics at the lake & have a high opinion about it. Not only is Madison Lake a recreational haven for any homeowner, but it is also a business investment. The estate operates as a Lake Membership Business, bringing in over $100K annually. Members can purchase seasonal or annual passes to use the lake or park their RVs alongside it to enjoy days, weeks, & months of lakeside camping. Some of these RV parking spots have access to electricity & have water/sewer hookups. Additional information will be made available on request. At the heart of this property lies a 3,537-square-foot Victorian-styled custom home. After a long day at the lake, family and friends can relax in this four-bedroom, three-bath home. The kitchen has been remodeled. It is functional & large-a perfect place to entertain guests! And if one is looking for income opportunities, the home can be rented out for an estimated $4,000 each month. Furthermore, the estate includes a three-stall outbuilding w/ garage doors. There is also a concrete-floored carport w/ over 10' of clearance for boats, tractors, or whatever else you need to store. Finally, the building has a tack room, hay storage loft & horse stall. Too many features to list, Private Lake Only Purchase Option Available. E-mail for more information.

Listing Agent

Steve Baumgaertner

C3 Real Estate Solutions, LLC Brokerage Phone: 9709888725 License #100083912 Listed on: 09/23/2025

C3 Real Estate Solutions, LLC

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $8,824

Year Built

  • Built in 1983

Lot Details

  • 30 Acre Lot
  • Lake Front
  • Property fronts an easement
  • Open Space
  • Cul-De-Sac
  • West Facing Home
  • Corner Lot
  • Paved or Partially Paved Lot
  • Level Lot
  • Sprinkler System
  • Wooded Lot
  • Landscaped with Trees
  • Property is zoned SFR Comm

Parking

  • 7 Car Attached Garage
  • Garage Door Opener
  • RV Access or Parking

Property Views

  • Water
  • Mountain
  • Hills

Home Design

  • Contemporary Architecture
  • Victorian Architecture
  • Mixed Use
  • Composition Roof

Interior Spaces

  • 3,537 Sq Ft Home
  • 2-Story Property
  • Open Floorplan
  • Woodwork
  • Crown Molding
  • Cathedral Ceiling
  • Ceiling Fan
  • Skylights
  • Gas Log Fireplace
  • Window Treatments
  • Bay Window
  • Six Panel Doors
  • Family Room with Fireplace
  • Great Room with Fireplace
  • Living Room with Fireplace
  • Dining Room
  • Loft
  • Sun or Florida Room
  • Wood Flooring
  • Fire and Smoke Detector

Kitchen

  • Eat-In Kitchen
  • Double Oven
  • Electric Range
  • Microwave
  • Dishwasher
  • Kitchen Island

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Walk-In Closet

Laundry

  • Laundry Room
  • Dryer
  • Washer
  • Sink Near Laundry

Eco-Friendly Details

  • Energy-Efficient Windows
  • Energy-Efficient Doors

Outdoor Features

  • Access To Lake
  • Pond
  • Balcony
  • Deck
  • Enclosed Patio or Porch
  • Outdoor Storage
  • Outbuilding

Location

  • Mineral Rights
  • Near Farm

Schools

  • Bella Romero Elementary School
  • Heath Middle School
  • Greeley Central High School

Farming

  • Barn
  • Pasture

Horse Facilities and Amenities

  • Horses Allowed On Property
  • Tack Room
  • Hay Storage
  • Riding Trail

Utilities

  • Central Air
  • Cooling System Mounted To A Wall/Window
  • Baseboard Heating
  • Hot Water Heating System
  • Water Rights
  • Cable TV Available

Listing and Financial Details

  • Assessor Parcel Number R3457605

Community Details

Overview

  • No Home Owners Association
  • Greeley Subdivision

Amenities

  • Clubhouse

Recreation

  • Marina
  • Park
  • Trails

Home Details

Home Type

Single Family

Est. Annual Taxes

$8,824

Year Built

Built in 1983

Lot Details

30 Acres

Parking

7

Listing Details

  • Year Built: 1983
  • Property Sub Type: Mixed Use
  • Prop. Type: Residential
  • Lot Size Acres: 30
  • Road Frontage Type: Priv Rd up to County Standards, Easement, Privately Maintained, Security Gate
  • Road Surface Type: Gravel, Asphalt
  • Subdivision Name: Greeley
  • Architectural Style: Victorian, Contemporary
  • Unit Levels: Two
  • New Construction: No
  • Efficiency: Windows, Doors
  • Property Attached Yn: No
  • Attribution Contact: 9709888725
  • RoomType: Bedroom 4
  • RoomType: Dining Room
  • RoomType: Family Room
  • RoomType: Kitchen
  • RoomType: Laundry
  • RoomType: Living Room
  • RoomFeatures: 3/4 Primary Bath, Luxury Features Primary Bath
  • IRE_HasWaterRights: No
  • IRE_TotalSqFt: 3537
  • IRE_NewConstructionStatus: Not New, Previously Owned
  • RoomType: Primary Bedroom
  • RoomType: Study
  • IRE_HasFamilyRoom: 1
  • Special Features: None

Interior Features

  • Possible Use: Single Family, Farm, Business, Commercial, Industrial
  • Appliances: Electric Range, Double Oven, Dishwasher, Refrigerator, Washer, Dryer, Microwave, Fire Alarm
  • Has Basement: None
  • Full Bathrooms: 1
  • Half Bathrooms: 1
  • Three Quarter Bathrooms: 1
  • Total Bedrooms: 4
  • Fireplace Features: Gas, Gas Log, Living Room, Family Room, Great Room
  • Flooring: Wood
  • Interior Amenities: Eat-in Kitchen, Separate Dining Room, Cathedral Ceiling(s), Open Floorplan, Wood Windows, Bay or Bow Window, Natural Woodwork, Walk-In Closet(s), Washer/Dryer Hookup, Skylights, Kitchen Island, 6-Panel Doors, High Ceilings, Crown Molding, Sun Room
  • Dining Room Type: Loft
  • Window Features: Skylight(s), Window Coverings

Exterior Features

  • Roof: Composition
  • Lot Features: Cul-De-Sac, Corner Lot, Wooded, Evergreen Trees, Deciduous Trees, Native Grass, Level, Rolling Lot, Abuts Pond/Lake, Abuts Farm Land, Abuts Public Open Space, Abuts Private Open Space, Outbuildings, House Faces West, City Limits, Lake Access, Lake Front, Marina in Community, Waterfront, Pond(s), Paved, Water Rights Included, Mineral Rights Included
  • View: Mountain(s), Hills, Water
  • Waterfront: No
  • Disclosures: Seller's Property Disclosure
  • Construction Type: Frame, Brick
  • Exterior Features: Sprinkler System, Balcony, >8' Garage Door, Oversized Garage
  • Other Structures: Storage
  • Patio And Porch Features: Patio, Deck, Enclosed

Garage/Parking

  • Garage Spaces: 7
  • Parking Features: Garage Door Opener, RV Access/Parking, Attached
  • IRE_GarageType: Attached

Utilities

  • Cooling: Central Air, Wall/Window Unit(s), Ceiling Fan(s)
  • Electric: Xcel
  • Heating: Hot Water, Baseboard
  • Utilities: Natural Gas Available, Electricity Available, Cable Available, Satellite Avail, High Speed Avail
  • Laundry Features: Sink
  • Sewer: Public Sewer
  • Water Source: Well

Condo/Co-op/Association

  • Community Features: Clubhouse, Park, Trail(s)
  • Association: No

Schools

  • Elementary School: Bella Romero
  • HighSchool: Greeley Central
  • Junior High Dist: Greeley 6
  • Middle Or Junior School: Heath

Lot Info

  • Zoning: SFR Comm
  • Horse Amenities: Horse(s) Allowed, Zoning Appropriate for 4+ Horses, Barn, Pasture, Tack Room, Hay Storage, Riding Trail
  • Parcel #: R3457605
  • Irrigation Water Rights: No

Tax Info

  • Tax Year: 2024
  • Tax Annual Amount: 8824

Map

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Tax History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2026 $10,505 $110,540 $52,280 $58,260
2025 $8,824 $117,120 $56,120 $61,000
2024 $8,824 $117,120 $56,120 $61,000
2023 $8,392 $113,500 $58,100 $55,400
2022 $9,356 $104,130 $45,510 $58,620
2021 $9,601 $105,460 $45,650 $59,810
2020 $8,650 $95,600 $36,230 $59,370
2019 $8,696 $95,600 $36,230 $59,370
2018 $6,257 $71,830 $36,260 $35,570
2017 $6,208 $71,830 $36,260 $35,570
2016 $4,537 $58,490 $27,520 $30,970
2015 $4,475 $58,490 $27,520 $30,970
2014 $4,421 $56,250 $27,520 $28,730
Source: Public Records

Property History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Event Price List to Sale Price per Sq Ft
09/23/2025 09/23/25 For Sale $2,850,000 -- $806 / Sq Ft
Source: IRES MLS

Purchase History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Type Sale Price Title Company
Quit Claim Deed -- --
Special Warranty Deed -- Stewart Title
Quit Claim Deed $150 --
Warranty Deed $650,000 --
Interfamily Deed Transfer -- --
Warranty Deed -- --
Source: Public Records

Mortgage History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Status Loan Amount Loan Type
Open $400,000 No Value Available
Previous Owner $400,000 Credit Line Revolving
Previous Owner $500,000,000 New Conventional
Previous Owner $810,000 New Conventional
Previous Owner $715,000 Commercial
Previous Owner $61,843 Commercial
Previous Owner $200,000 Credit Line Revolving
Previous Owner $200,000 Credit Line Revolving
Previous Owner $200,000 Credit Line Revolving
Previous Owner $100,000 Credit Line Revolving
Previous Owner $688,000 Unknown
Previous Owner $500,000 Unknown
Previous Owner $172,690 Unknown
Previous Owner $261,375 No Value Available
Source: Public Records

About the Listing Agent

Steve Baumgaertner

C3 Real Estate Solutions, LLC

(970) 610-1405

Section Image

Steve Baumgaertner

Built to serve. Trained to lead. Committed to results.

Steve Baumgaertner is a former U.S. Army Ranger who served within the elite Special Operations community of the 75th Ranger Regiment—a place where precision, discipline, and leadership weren’t just expected, they were non-negotiable. Today, Steve brings that same mindset to real estate, where he’s built a reputation for results-driven service rooted in integrity, tenacity, and grace under

Steve's Other Listings

  • 400 N Overland Trail Unit 6, Fort Collins, CO 80521

    $41,950

    • 2 Beds
    • 1 Bath
    • 922 Sq Ft
    • 400 N Overland Trail
    • Unit 6
    • Fort Collins, CO

    Fully remodeled 2BR/1BA (approx. 924 sq ft) in Aspen MHC, Fort Collins. Updates include fresh interior/exterior paint, all-new vinyl windows (incl. bay window), and a new front deck with rear stoop. The kitchen features new cabinets and countertops, a full-height tile backsplash, a butcher-block bar with tongue-and-groove ceiling accent, new appliances, a deep chef's sink, and tile flooring. New

    Steve Baumgaertner C3 Real Estate Solutions, LLC

    Section Image
  • 968 Turkey Roost Dr, Livermore, CO 80536

    $275,000

    • Land
    • 3.65 Acres
    • $75,342 per Acre
    • 968 Turkey Roost Dr
    • Livermore, CO

    Raven's Nest - The Premier View Lot in LivermoreWelcome to the best view lot in Livermore! This stunning 3.65-acre parcel features gently sloping grass meadows and is perfectly ready for your custom dream home.The site has already been excavated to create two large, beautiful flat building pads - one ideal for a spacious shop to store all your toys, and the other offering a gently sloping area

    Steve Baumgaertner C3 Real Estate Solutions, LLC

    Section Image
  • 602 Sante fe Trail Unit 4, Ault, CO 80610

    $299,900 Sold Sep 30, 2025

    • 2 Beds
    • 2.5 Baths
    • 1,122 Sq Ft
    • 602 Sante fe Trail
    • Unit 4
    • Ault, CO

    HUGE price drop! This home is priced to move. Enjoy outdoor living on the covered patio and fenced area-perfect for grilling and gathering with neighbors. Inside, an open-concept main level features 9' ceilings and durable LVP flooring, with plenty of space for media and seating. The kitchen offers soft-close cabinetry with upgraded 48" uppers, stainless appliances, and a center island with

    Steve Baumgaertner C3 Real Estate Solutions, LLC

  • 634 Del Carmen Dr, Fort Collins, CO 80524

    $690,000 Sold Jul 29, 2026

    • 4 Beds
    • 3.5 Baths
    • 3,812 Sq Ft
    • 634 Del Carmen Dr
    • Fort Collins, CO

    Experience why Fort Collins, Colorado is consistently ranked among America's top places to live and retire. Minutes from CSU, shopping, dining, breweries, entertainment, parks, trails, and endless outdoor recreation, with Old Town Fort Collins only a short drive away. E-mail brokers for a detailed list of features, floor plan or to show. NO Metro Tax, LOW HOA, and built in 2013. This ranch style

    Steve Baumgaertner C3 Real Estate Solutions, LLC

  • 2457 Nyssa Dr, Loveland, CO 80538

    $490,000 Sold Aug 15, 2025

    • 4 Beds
    • 2 Baths
    • 2,395 Sq Ft
    • 2457 Nyssa Dr
    • Loveland, CO

    See video: Tucked into a quiet, well-established community just a few hundred feet from Silver Glen Park, this beautifully maintained home offers the perfect balance of privacy, convenience, and functionality. Just minutes from all the amenities Loveland has to offer, you'll enjoy a tranquil, park-like setting without sacrificing proximity to shopping, schools, and dining. Step outside and

    Steve Baumgaertner C3 Real Estate Solutions, LLC

  • 2500 E Harmony Rd Unit 456, Fort Collins, CO 80528

    $55,000 Sold Apr 09, 2026

    • 2 Beds
    • 1 Bath
    • 924 Sq Ft
    • 2500 E Harmony Rd
    • Unit 456
    • Fort Collins, CO

    Clean, Comfortable & Move-In Ready Home with plenty of Garden Space! Welcome to this beautifully maintained home featuring a freshly painted exterior. Plenty of space around the home for pets, children, or your dream garden! Enjoy the charm of an apple tree, blooming irises, and a private concrete patio ideal for morning coffee or evening relaxation. A new covered front stoop, new back stoop with

    Steve Baumgaertner C3 Real Estate Solutions, LLC

  • 2211 W Mulberry St Unit 52, Fort Collins, CO 80521

    $84,000 Sold Aug 20, 2025

    • 3 Beds
    • 2 Baths
    • 920 Sq Ft
    • 2211 W Mulberry St
    • Unit 52
    • Fort Collins, CO

    Clean, Cozy, and Full of Charm in a Premier 55+ Community. Key Features Include: Spacious Carport: Accommodates 2-3 vehicles with ease! Whether for parking or outdoor living, this versatile space is perfect for cars, patio furniture, or both. A shade cover and mounting hooks are already in place for a potential outdoor sitting area. Workshop-Ready Shed: A large shed with both 120V and 220V

    Steve Baumgaertner C3 Real Estate Solutions, LLC

  • 1268 Ohana Way, Bellvue, CO 80512

    $1,600,000 Sold Sep 26, 2025

    • 4 Beds
    • 4 Baths
    • 4,482 Sq Ft
    • 1268 Ohana Way
    • Bellvue, CO

    TWO HOMES ON TWO LOTS - 50 ACRES TOTAL. Experience breathtaking mountain views with this unique property featuring two 3-bedroom homes and a 1-bedroom ADU on 50 acres. The main home (3 bd/2 ba) on 35 acres includes a den, wood floors, vaulted ceilings, 3-car garage, Trex deck, generator, and new solar water heater. The second 3 bd/1 ba home on 15 acres offers new appliances, roof, windows, and

    Steve Baumgaertner C3 Real Estate Solutions, LLC

  • 60 Horn Peak Dr, Livermore, CO 80536

    $525,000 Sold Feb 02, 2026

    • 3 Beds
    • 1.5 Baths
    • 1,616 Sq Ft
    • 60 Horn Peak Dr
    • Livermore, CO

    Colorado Freedom House - 1776. That's right, 1776 sq ft of pure Colorado freedom! Your front door opens to 45 acres of National Forest - hike wild, unmarked Manhead Mountain with zero trespassing. Friendly neighbors just over the fence, yet you'll feel a world away. Built California-earthquake strong with 2X6 walls, this south-facing retreat drinks sunlight through vinyl double-pane windows and

    Steve Baumgaertner C3 Real Estate Solutions, LLC

Source: IRES MLS

MLS Number: IRE1044217

IRES MLS

APN: R3457605

Your Personal Tour Guide

Ask me questions while you tour the home.