Live the lifestyle you've always imagined in this stunning custom lakefront two-story home with a finished walkout basement, nestled on 2.2 acres with panoramic views of the Rocky Mountains, listed below appraised value! Situated on private Horseshoe Lake, this property offers the ultimate in luxury waterfront living. Enjoy an active and serene lifestyle with direct access to all your favorite water sports-start your mornings paddleboarding in calm waters, spend the day waterskiing or surfing, and cap it off with a peaceful pontoon cruise while fishing. Relax with ease: soak up the sun on your private dock, or play on your own sandy beach. Outdoor entertaining is a breeze with a built-in BBQ, lakeside gazebo and captivating views in every direction. Inside, the home boasts 5 bedrooms, 7 bathrooms, a dedicated study, two full kitchens, three fireplaces, and a wraparound deck perfect for soaking in the views. The gourmet kitchen is a chef's dream, featuring Quartz countertops, a spacious island, oversized pantry, and high-end Sub-Zero, Wolf, and Asko appliances. Take in breathtaking sunsets through floor-to-ceiling windows or unwind in the expansive owner's suite, complete with a private balcony, fireplace, and a luxurious jetted tub. Host movie nights in the theater room or gather with friends in the great room, recreation room, or on the enclosed patio. Additional features include a 10-car garage, radiant in-floor heating throughout, central vacuum system, and numerous high-end upgrades. This extraordinary, one-of-a-kind custom home is a must-see-where luxury meets lifestyle on the water.
Offered By
Stefanie Erion 9703001985, Kentwood RE Northern Prop Llc
FIREPLACE FEATURES2+ Fireplaces, Gas, Living Room, Primary Bedroom, Great Room, Masonry
HeatingZoned, Radiant, 2 or more Heat Sources
CoolingCentral Air, Ceiling Fan(s), Whole House Fan
Utility FeaturesNatural Gas Available, Electricity Available, Cable Available, Underground Utilities
SEWERCity Sewer
WATER SOURCECity Water, City of Loveland
Year Built2001
BasementFull, Partially Finished, Walk-Out Access, Retrofit for Radon, Sump Pump
FINISHED BASEMENT SIZE2508.0
ARCHITECTURAL STYLEContemporary/Modern
RoofComposition
EXTERIOR FEATURESGas Grill, Balcony
Parking FeaturesGarage Door Opener, RV/Boat Parking, Heated Garage, Oversized, Tandem
Lot FeaturesFire Hydrant within 500 Feet, Lawn Sprinkler System, Within City Limits, Lake Access, Lake Front, Waterfront
Garage spaces10
ViewMountain(s), Foothills View, Water
CITYLoveland
SUBDIVISIONHorseshoe Lake First
COUNTYLarimer
AREALoveland/Berthoud
STATECO
SENIOR COMMUNITYNo
COMMUNITY FEATURESPark, Hiking/Biking Trails
HOA1
TAX AMOUNT15999.0
HOA FEE285.0
HOA 2 FEE300.0
HOA FREQUENCYQuarterly
HOA 2 FREQUENCYAnnually
LATEST UPDATE2025-07-08T23:09:58.646Z
DAYS ON MARKET1
PRICE CHANGE(S)
$3,999,999 Jul 8, 2025
CUMULATIVE DAYS ON MARKET1
Market Trends
New Properties On Market
134
63%
Increase In New Listings
Average Asking Price
$667,432
$123,108 Decrease In Avg Asking Price
Average Asking Price / Sq. Ft.
$246
$33 Decrease In List Price/Sq. Ft.
Average Days On Market
13
26 Day
Decrease In Days On Market
Data as of Jul 09, 2025.
Remaining statistics above are calculated on activity within the period from May 01, 2025 to Jun 30, 2025.
Mortgage Calculator
The information provided by this calculator is for illustrative purposes only and accuracy is not guaranteed. The values and figures shown are hypothetical and may not be applicable to your individual situation. Be sure to consult a financial professional prior to relying on the results. This calculator does not have the ability to pre-qualify you for any mortgage or loan program. Qualification for mortgages or loans requires additional information such as credit scores and existing debts which is not gathered in this calculator. Information such as interest rates and pricing are subject to change at any time and without notice. All information such as interest rates, taxes, insurance, monthly mortgage payments, etc. are estimates and should be used for comparison only.