Home » Real Estate » CO » Loveland » 80538 »
$6,175,000
1518 E 57th St, Loveland, CO, 80538
4
Beds
8
Baths
6,109
Square Feet
Move into your own lakefront resort! This rare, one-of-a-kind compound is now available for showings. Ideally situated on the north shore of Horseshoe Lake, this magnificent property features two homes, a lake house, and a large garage. The main house, with its extraordinary water and mountain views, features a full gourmet kitchen with large pantry, large open family room, a separate den area, and main floor primary bedroom. The second home, with its chic farmhouse esthetic, is so fun and delightfully done. Recreational amenities include a large swimming pool and hot tub, sport turf field, beach frontage, a boat dock with private boat ramp, and multiple storage areas for large vehicles such as RVS or boats. This property is truly a delight in every way. Please reach out for more information.
Offered By
Jeff Clough, NOCO Modern Real Estate
Property Details
Property Type
Residential
Status
Closed
Bedrooms
4
Bathrooms (Full)
2
Property Sub Type
Single Family Residence
Square Feet
6,109
MLS #
1024804
Bathrooms (¾)
3
Bathrooms (Half)
3
Flooring
Wood
Appliances
Gas Range, Dishwasher, Refrigerator, Microwave
Heating
Forced Air
Utility Features
Natural Gas Available, Electricity Available
SEWER
Septic Tank
WATER SOURCE
District
Year Built
1873
Basement
Partial, Crawl Space
FINISHED BASEMENT SIZE
0.0
ARCHITECTURAL STYLE
Contemporary/Modern
Roof
Composition
EXTERIOR FEATURES
Tennis Court(s), Oversized Garage, Carriage House
Parking Features
RV Access/Parking
Lot Features
Evergreen Trees, Deciduous Trees, Native Grass, Sloping Lot, Abuts Pond/Lake, Abuts Farm Land, Paved
Garage spaces
3
Other Structures
Storage
View
Mountain(s), Hills, Water
CITY
Loveland
SUBDIVISION
Ezinga Boundary Line
COUNTY
Larimer
AREA
Loveland/Berthoud
STATE
CO
COMMUNITY FEATURES
Park
TAX AMOUNT
13364.0
LATEST UPDATE
2026-01-22T23:05:08.230Z
PRICE CHANGE(S)
$6,500,000 Oct 21, 2025
Property Details
Property Type
Residential
Status
Closed
Bedrooms
4
Bathrooms (Full)
2
Property Sub Type
Single Family Residence
Square Feet
6,109
MLS #
1024804
Bathrooms (¾)
3
Bathrooms (Half)
3
New Properties On Market
122
42%
Increase In New Listings
Average Asking Price
$736,390
$177,810 Increase In Avg Asking Price
Average Asking Price / Sq. Ft.
$260
$30 Increase In List Price/Sq. Ft.
Average Days On Market
9
24 Day
Decrease In Days On Market
Data as of Apr 06, 2026.
Remaining statistics above are calculated on activity within the period from Feb 01, 2026 to Mar 31, 2026.
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.
Purchase Price
Loan Type
Down Payment
HOA Dues
Interest Rate
Estimated Property Taxes
Homeowner's Insurance
Private Mortgage Insurance