$1,188,000

404 Split Rock Dr Loveland, CO 80537

Estimated payment $6,940/month

Total Views 110
4 Beds
3.5 Baths
3,803 Sq Ft
$312 Price per Sq Ft

Highlights

  • Lake Front
  • Open Floorplan
  • Recreation Room
  • Two Primary Bedrooms
  • Deck
  • Double Oven

About This Home

Rare lakefront home offering what the sellers describe as "private resort-style, year-round living." This spacious Contemporary Tuscan-style home welcomes you with soaring ceilings, an open floor plan, and stunning lake views. Quality features throughout include 8' solid-core doors, decorative arches and niches, stone accents, a stone fireplace hearth, and radiant floor heating. The main level features a large living area with lakefront balcony access, study/office/craft room, oversized sit-around kitchen island, abundant cabinetry and pantry space, dining area, and powder room. Upstairs, the spacious primary suite includes a fireplace, luxurious 5-piece bath, oversized walk-in closet, walk-in shower with dual shower heads, and a private covered balcony overlooking the lake. A second suite with full bath and laundry complete the upper level. The walk-out lower level offers a third bedroom with nearby full bath, expansive storage/utility space, and a large rec room opening to a covered patio with TV plus an additional open patio area. Just steps away is your private dock for a pontoon, paddleboards, and more. Enjoy breathtaking sunrise views, abundant wildlife, and direct access to the nearby Natural Reserve trail system. As the end home, the property offers added privacy with only one neighboring home plus a private driveway and additional front parking. Conveniently located near grocery shopping and other amenities. This is truly a property best appreciated in person.

Listing Agent

Dave Trujillo

Group Centerra Brokerage Phone: 9702220340 Listed on: 05/14/2026

Group Centerra

Townhouse Details

Home Type

  • Townhome

Est. Annual Taxes

  • $4,131

Year Built

  • Built in 2009

Lot Details

  • 4,792 Sq Ft Lot
  • Lake Front
  • Open Space

HOA Fees

  • $260 Monthly HOA Fees

Parking

  • 2 Car Attached Garage

Property Views

  • Water
  • Mountain

Home Design

  • Half Duplex
  • Tile Roof
  • Stucco
  • Stone

Interior Spaces

  • 3,803 Sq Ft Home
  • 2-Story Property
  • Open Floorplan
  • Gas Fireplace
  • Window Treatments
  • Living Room
  • Dining Room
  • Recreation Room
  • Walk-Out Basement

Kitchen

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

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Double Master Bedroom
  • Walk-In Closet
  • Primary Bathroom is a Full Bathroom

Laundry

  • Laundry Room
  • Dryer
  • Washer

Outdoor Features

  • Access To Lake
  • Balcony
  • Deck
  • Patio

Schools

  • Milner Elementary School
  • Walt Clark Middle School
  • Thompson Valley High School

Utilities

  • Forced Air Heating and Cooling System
  • Radiant Heating System

Listing and Financial Details

  • Assessor Parcel Number R1641706

Community Details

Overview

  • Association fees include common amenities, snow removal, ground maintenance, management
  • The Quarry Residential Assoc. Association
  • The Villas On Quarry Lake Subdivision

Recreation

  • Park

Townhouse Details

Home Type

Townhome

Est. Annual Taxes

$4,131

Year Built

Built in 2009

Lot Details

4,792 Sq Ft Lot

HOA Fees

$260 per month

Parking

2

Listing Details

  • Year Built: 2009
  • Property Sub Type: Duplex
  • Prop. Type: Residential
  • Lot Size Acres: 0.11
  • Subdivision Name: The Villas on Quarry Lake
  • Directions: Take First Street West to Left/South on Taft. First left past Circle K and Carwash. OR take Eisenhower west to Taft, go left/south on Taft to third left past First Street.
  • Unit Levels: Two
  • New Construction: No
  • Property Attached Yn: Yes
  • Structure Type: 1/2 Duplex
  • Attribution Contact: 9702220340
  • Special Features: VirtualTour

Interior Features

  • Appliances: Gas Range, Double Oven, Dishwasher, Refrigerator, Washer, Dryer, Microwave
  • Has Basement: Partially Finished, Walk-Out Access
  • Full Bathrooms: 3
  • Half Bathrooms: 1
  • Total Bedrooms: 4
  • Fireplace Features: Two or More, Gas, Multi-Sided, Family Room, Bedroom
  • Interior Amenities: Eat-in Kitchen, Open Floorplan, Pantry, Walk-In Closet(s), Kitchen Island, Two Primary Suites, High Ceilings
  • Window Features: Window Coverings

Exterior Features

  • Roof: Tile
  • Lot Features: Abuts Pond/Lake, Abuts Public Open Space, Lake Access, Lake Front
  • View: Mountain(s), Water
  • Waterfront: No
  • Disclosures: Seller's Property Disclosure
  • Construction Type: Frame, Stone, Stucco
  • Exterior Features: Sprinkler System, Balcony
  • Patio And Porch Features: Patio, Deck

Garage/Parking

  • Garage Spaces: 2
  • Parking Features: Attached

Utilities

  • Cooling: Central Air
  • Electric: City of Loveland
  • Heating: Forced Air, Radiant
  • Utilities: Natural Gas Available, Electricity Available
  • Sewer: Public Sewer
  • Water Source: City

Condo/Co-op/Association

  • HOA Fee Includes: Common Amenities, Snow Removal, Maintenance Grounds, Management
  • Community Features: Park, Trail(s)
  • Association Fee: 260
  • Association Fee Frequency: Monthly
  • Association Name: The Quarry Residential Assoc.
  • Association: Yes

Schools

  • Elementary School: Milner (Sarah)
  • HighSchool: Thompson Valley
  • Junior High Dist: Thompson R2-J
  • Middle Or Junior School: Walt Clark

Lot Info

  • Zoning: P-96
  • Parcel #: R1641706
  • Irrigation Water Rights: No

Tax Info

  • Tax Year: 2025
  • Tax Annual Amount: 4131

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

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Tax History

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
2025 $3,802 $48,301 $12,188 $36,113
2024 $3,667 $51,329 $13,065 $38,264
2022 $3,159 $39,698 $5,004 $34,694
2021 $3,246 $40,841 $5,148 $35,693
2020 $3,439 $43,258 $5,148 $38,110
2019 $3,381 $43,258 $5,148 $38,110
2018 $3,195 $38,822 $5,184 $33,638
2017 $2,751 $38,822 $5,184 $33,638
2016 $2,540 $34,626 $5,731 $28,895
2015 $2,519 $39,730 $5,730 $34,000
2014 $2,154 $28,650 $5,730 $22,920
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft Prior Sale
05/14/2026 05/14/26 For Sale $1,188,000 +120.0% $312 / Sq Ft
12/17/2019 12/17/19 Off Market $540,000 -- --
09/17/2019 09/17/19 Sold $540,000 -1.8% $145 / Sq Ft View Prior Sale
07/27/2019 07/27/19 Price Changed $550,000 -3.3% $148 / Sq Ft
06/28/2019 06/28/19 For Sale $569,000 +5.4% $153 / Sq Ft
06/17/2019 06/17/19 Off Market $540,000 -- --
06/06/2019 06/06/19 Price Changed $569,000 -1.0% $153 / Sq Ft
04/22/2019 04/22/19 For Sale $575,000 -- $155 / 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
Warranty Deed $540,000 Land Title Guarantee Co
Interfamily Deed Transfer -- None Available
Interfamily Deed Transfer -- None Available
Warranty Deed $325,000 Heritage Title
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 $432,000 New Conventional
Previous Owner $276,000 New Conventional
Previous Owner $327,633 Purchase Money Mortgage
Source: Public Records

Source: IRES MLS

MLS Number: IRE1059041

IRES MLS

APN: 95232-11-001

Your Personal Tour Guide

Ask me questions while you tour the home.