$1,399,000
SOLD JUN 13, 2025

6064 Clearwater Dr Loveland, CO 80538

5 Beds
4.5 Baths
5,166 Sq Ft
0.35 Acres

Recently Sold

$271 Per Sq Ft

2 Days on Market

Highlights

  • Primary Bedroom Suite
  • Pasture Views
  • Deck
  • Open Floorplan
  • Fireplace in Primary Bedroom
  • Contemporary Architecture

About This Home

As of June 2025

Welcome to 6064 Clearwater Drive, a stunning 5-bedroom, 5-bath custom-built ranch home with a walkout basement in Loveland’s exclusive Waterfront North neighborhood. Here, lakeside and luxury living blend beautifully, offering private access to Boyd Lake for boating, fishing, paddleboarding, and relaxing by the water. Inside, an open, airy floor plan greets you with soaring 14' and 12' ceilings, designed for effortless flow—whether entertaining or unwinding on the back patio. The chef’s kitchen is a dream, featuring a spacious island, two dishwashers, two ovens, two sinks, and ample counter space. The newly remodeled primary suite boasts elegant shiplap, a redesigned fireplace, plush carpet, and stylish window treatments. This tranquil retreat includes an en suite bath and two walk-in closets. Step onto the expansive back deck—a private oasis perfect for seamless indoor-outdoor living. Relax under the pergola, surrounded by soft natural light, or entertain guests in this peaceful space overlooking the lush backyard. Ceiling fans and a fireplace provide year-round comfort, while the soothing water feature completes the ambiance. The newly finished lower level offers a luxurious second kitchen with stainless steel appliances, Quartz slab countertops, and an island. This spacious floor includes a family room, a cozy fireplace, two bedrooms, and two bathrooms. The covered patio opens to a manicured lawn, backing to open space and a canal—ideal for enjoying Colorado’s natural beauty. Outdoor enthusiasts will love the private boat launch, recreational dock with beach access, and scenic neighborhood trails, all set against breathtaking mountain, lake, and wildlife views. Living in Waterfront North neighborhood means embracing a vibrant lakeside lifestyle with easy access to Boyd Lake State Park and a short drive to Fort Collins and Denver.

Last Agent to Sell the Property

Nikki Owen

Guide Real Estate Brokerage Email: Nikki.5280Realtor@gmail.com,720-220-8460 License #100049831 Listed on: 05/15/2025

Guide Real Estate

Last Buyer's Agent

Amanda Unrein

Kittle Real Estate License #100075576

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $6,061

Year Built

  • Built in 2007 | Remodeled

Lot Details

  • 0.35 Acre Lot
  • Open Space
  • West Facing Home
  • Property is Fully Fenced
  • Landscaped
  • Level Lot
  • Front and Back Yard Sprinklers
  • Many Trees
  • Private Yard
  • Property is zoned P-61

HOA Fees

  • $100 Monthly HOA Fees

Parking

  • 3 Car Attached Garage
  • Parking Storage or Cabinetry
  • Insulated Garage
  • Dry Walled Garage
  • Epoxy
  • Exterior Access Door

Property Views

  • Pasture
  • Mountain

Home Design

  • Contemporary Architecture
  • Composition Roof
  • Stone Siding
  • Radon Mitigation System
  • Stucco

Interior Spaces

  • 1-Story Property
  • Open Floorplan
  • Wet Bar
  • Vaulted Ceiling
  • Ceiling Fan
  • Gas Fireplace
  • Double Pane Windows
  • Smart Window Coverings
  • Entrance Foyer
  • Smart Doorbell
  • Family Room
  • Living Room with Fireplace
  • 3 Fireplaces
  • Dining Room
  • Bonus Room
  • Laundry Room

Kitchen

  • Eat-In Kitchen
  • Double Self-Cleaning Oven
  • Range with Range Hood
  • Microwave
  • Freezer
  • Dishwasher
  • Kitchen Island
  • Granite Countertops
  • Quartz Countertops
  • Disposal

Flooring

  • Wood
  • Carpet
  • Tile

Bedrooms and Bathrooms

  • 5 Bedrooms | 3 Main Level Bedrooms
  • Fireplace in Primary Bedroom
  • Primary Bedroom Suite
  • Walk-In Closet

Finished Basement

  • Walk-Out Basement
  • Basement Fills Entire Space Under The House
  • Sump Pump
  • Fireplace in Basement
  • Bedroom in Basement
  • 2 Bedrooms in Basement
  • Basement Window Egress

Home Security

  • Home Security System
  • Smart Locks
  • Smart Thermostat
  • Radon Detector
  • Carbon Monoxide Detectors
  • Fire and Smoke Detector

Eco-Friendly Details

  • Smart Irrigation

Outdoor Features

  • Deck
  • Covered Patio or Porch
  • Outdoor Water Feature
  • Outdoor Fireplace
  • Exterior Lighting
  • Outdoor Gas Grill
  • Rain Gutters

Schools

  • High Plains Elementary School
  • Conrad Ball Middle School
  • Mountain View High School

Utilities

  • Forced Air Heating and Cooling System
  • 220 Volts
  • 110 Volts
  • Tankless Water Heater
  • High Speed Internet
  • Phone Available
  • Cable TV Available

Listing and Financial Details

  • Exclusions: Seller Personal Property
  • Assessor Parcel Number R1619305

Community Details

Overview

  • Association fees include reserves
  • Waterfront Association, Phone Number (303) 420-4433
  • Waterfront North Subdivision
  • Greenbelt

Recreation

  • Community Playground
  • Park
  • Trails

Home Details

Home Type

Single Family

Est. Annual Taxes

$6,061

Year Built

Built in 2007 | Remodeled

Lot Details

0

HOA Fees

$100 per month

Parking

3

Listing Details

  • Property Type: Residential
  • Property Sub Type: Single Family Residence
  • Architectural Style: Contemporary
  • Structure Type: House
  • Levels: One
  • Year Built: 2007
  • Above Grade Finished Sq Ft: 2583
  • Exclusions: Seller Personal Property
  • Living Area: 5166
  • Property Condition: Updated/Remodeled
  • Directions: From Eisenhower and Boyd Lake Ave go north on Boyd Lake Ave to Valley Oak. Left on Valley Oak to the round-a-bout and right on Clearwater to the property.
  • SubdivisionName: Waterfront North
  • Ownership: Individual
  • Property Attached Yn: No
  • REC_BasementLevelBathrooms: 2
  • REC_BasementLevelBedrooms: 2
  • REC_RVSpaces: 0
  • REC_UpperLevelBathrooms: 0
  • REC_UpperLevelBedrooms: 0
  • REC_WaterIncludedYN: 1
  • Ratio Close Price By Original Li: 1.00000
  • Attribution Contact: Nikki.5280Realtor@gmail.com,720-220-8460
  • Special Features: VirtualTour

Interior Features

  • Appliances: Dishwasher, Disposal, Double Oven, Electric Water Heater, Freezer, Microwave, Oven, Range, Range Hood, Refrigerator, Self Cleaning Oven, Sump Pump, Tankless Water Heater
  • Fireplaces: 3
  • Interior Amenities: Breakfast Bar, Ceiling Fan(s), Eat-in Kitchen, Entrance Foyer, Five Piece Bath, Granite Counters, High Ceilings, High Speed Internet, Kitchen Island, Open Floorplan, Pantry, Primary Suite, Quartz Counters, Radon Mitigation System, Smart Thermostat, Smart Window Coverings, Vaulted Ceiling(s), Walk-In Closet(s), Wet Bar
  • Flooring: Carpet, Tile, Wood
  • Fireplace Features: Basement, Gas, Living Room, Outside, Primary Bedroom
  • Full Bathrooms: 3
  • Half Bathrooms: 1
  • Basement: Finished, Full, Walk-Out Access
  • Basement: Yes
  • Three Quarter Bathrooms: 1
  • Total Bedrooms: 5
  • Below Grade Sq Ft: 2583
  • Main Level Bathrooms: 3
  • Main Level Bedrooms: 3
  • Spa Features: Bath
  • Window Features: Double Pane Windows, Egress Windows, Window Coverings

Exterior Features

  • Direction Faces: West
  • Roof: Composition
  • Construction Materials: Stone, Stucco
  • View: Mountain(s), Plains
  • Exterior Features: Barbecue, Gas Grill, Gas Valve, Lighting, Private Yard, Rain Gutters, Smart Irrigation, Water Feature
  • Patio and Porch Features: Covered, Deck, Front Porch, Patio

Garage/Parking

  • Parking Features: Concrete, Dry Walled, Exterior Access Door, Floor Coating, Insulated Garage, Oversized, Storage
  • Attached Garage: Yes
  • Garage Spaces: 3
  • Total Parking Spaces: 3
  • REC_ParkingCount: 1

Utilities

  • Utilities: Cable Available, Electricity Available, Electricity Connected, Internet Access (Wired), Natural Gas Available, Natural Gas Connected, Phone Available
  • Sewer: Public Sewer
  • Cooling: Central Air
  • Heating: Forced Air
  • Water Source: Public
  • Electric: 110V, 220 Volts
  • Laundry Features: Sink
  • Security: Carbon Monoxide Detector(s), Radon Detector, Security System, Smart Locks, Smoke Detector(s), Video Doorbell

Condo/Co-op/Association

  • HOA Fee Includes: Reserves
  • Association Name: Waterfront
  • Association Fee Frequency: Quarterly
  • Association Amenities: Park, Playground, Trail(s)
  • Association Fee: 300
  • Phone: (303) 420-4433
  • Association: Yes
  • Senior Community: No

Association/Amenities

  • REC_AssociationFee2Annual: 0.00
  • REC_AssociationFee3Annual: 0.00
  • REC_AssociationFeeAnnual: 1200.00
  • REC_AssociationFeeTotalAnnual: 1200.00
  • REC_AssociationManagementType: Professionally Managed
  • REC_MultipleAssociationsYN: 0
  • REC_AssociationURL: https://engage.goenumerate.com/s/waterfrontnorth/home.php

Schools

  • Middle Or Junior School: Conrad Ball

Lot Info

  • Parcel Number: R1619305
  • Lot Size Acres: 0.35
  • Fencing: Full
  • Building Area Total: 5166
  • Lot Features: Ditch, Greenbelt, Irrigated, Landscaped, Level, Many Trees, Open Space, Sprinklers In Front, Sprinklers In Rear
  • Lot Size Sq Ft: 15103

Multi Family

  • Number Of Units Total: 1

Tax Info

  • Tax Year: 2024
  • Tax Annual Amount: 6061

MLS Schools

  • Elementary School: High Plains
  • High School: Mountain View

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
May 15, 2025
Closed on
Jun 12, 2025
Sold by
Pillatzke David R and Pillatzke Lori L
Bought by
Brinn Nathan A and Brinn Melissa C
Seller's Agent
Nikki Owen
Guide Real Estate
Buyer's Agent
Amanda Unrein
Kittle Real Estate
List Price
$1,399,000
Sold Price
$1,399,000
Views
20

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
-5.36%
Original Mortgage
$806,500
Outstanding Balance
$805,824
Interest Rate
6.89%
Mortgage Type
New Conventional
Estimated Equity
$576,309

Purchase Details

Listed on
Sep 29, 2023
Closed on
Oct 20, 2023
Sold by
Tibbs Daniel J
Bought by
Pillatzke David R and Pillatzke Lod L
Seller's Agent
Todd Jeskulski
C3 Real Estate Solutions LLC
Buyer's Agent
Nikki Owen
Guide Real Estate
List Price
$965,000
Sold Price
$1,000,000
Premium/Discount to List
$35,000
3.63%
Views
180

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
22.72%
Original Mortgage
$850,000
Interest Rate
7.18%
Mortgage Type
New Conventional

Purchase Details

Closed on
Sep 13, 2021
Sold by
Tibbs Daniel Joseph
Bought by
Tibbs Daniel J

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$700,000
Interest Rate
3.01%
Mortgage Type
New Conventional

Purchase Details

Closed on
Jul 20, 2021
Sold by
Tibbs Kristin Hocke
Bought by
Tibbs Daniel Joseph

Purchase Details

Closed on
Oct 2, 2020
Sold by
Burton R Don R and Burton Janet E
Bought by
Tibbs Daniel J and Tibbs Kristin H

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$620,000
Interest Rate
2.9%
Mortgage Type
New Conventional

Purchase Details

Closed on
Aug 3, 2011
Sold by
Farwell Matthew and Farwell Beth
Bought by
Burton R Don and Burton Janet E

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$384,000
Interest Rate
4.43%
Mortgage Type
New Conventional

Purchase Details

Closed on
Dec 30, 2008
Sold by
New Frontier Bank
Bought by
Farwell Matthew and Farwell Beth

Purchase Details

Closed on
Aug 22, 2008
Sold by
Barclay Construction Inc
Bought by
New Frontier Bank

Purchase Details

Closed on
Nov 1, 2006
Sold by
Morales Justin
Bought by
Barclay Construction Inc

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$535,500
Interest Rate
6.37%
Mortgage Type
Construction

Purchase Details

Closed on
Jan 25, 2006
Sold by
Bristol David and Bristol Leanne
Bought by
Morales Justin

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$156,750
Interest Rate
6.22%
Mortgage Type
Purchase Money Mortgage

Purchase Details

Closed on
Oct 22, 2004
Sold by
Lennar Colorado Llc
Bought by
Bristol David and Bristol Leanne
Source: Public Records

Similar Homes in the area

  • 400 Rugged Rock Rd, Loveland, CO 80537

    $1,350,000

    • 5 Beds
    • 6 Baths
    • 4,338 Sq Ft
    • 400 Rugged Rock Rd
    • Loveland, CO

    Offered for the first time by its original owners, this custom-designed 40+ acre estate combines privacy, function, and timeless charm in one of Northern Colorado's most scenic foothill settings. Tucked behind a private gate at the end of Rugged Rock Road, the property offers end-of-road seclusion and sweeping views of the surrounding hillsides between Loveland and Berthoud. The nearly 5,000

    John Feeney C3 Real Estate Solutions LLC

    Section Image
  • 689 Cattle Drive Rd, Loveland, CO 80537

    $1,350,000

    • 3 Beds
    • 2 Baths
    • 1,764 Sq Ft
    • 689 Cattle Drive Rd
    • Loveland, CO

    !!! listed $75,000 below apprised value (instant equity)!!! Exceptional 40-acre equestrian property with stunning Longs Peak views and direct access to Pinewood Reservoir. Watch elk herds migrate through your backyard or enjoy fishing and kayaking steps from your door.Turnkey horse facilities include a 96x40 barn with 10 stalls, 2 foaling stalls, tack room and wash bay. Additional 7-stall barn, 3

    Matthew Fugate The Fugate Property Group

    Section Image
  • 729 Sawmill Rd, Loveland, CO 80537

    $1,295,000

    • 3 Beds
    • 3 Baths
    • 4,372 Sq Ft
    • 729 Sawmill Rd
    • Loveland, CO

    Experience mountain living in this custom-built contemporary home nestled on 35 private acres in the Saddle Notch Ranch area just west of the City of Loveland. Designed for comfort, energy efficiency, and connection to nature, this property offers unmatched views through soaring floor-to-ceiling windows in the expansive great room, showcasing the stunning natural surroundings. Thoughtfully

    John Feeney C3 Real Estate Solutions, LLC

    Section Image
  • 6565 Seaside Dr, Loveland, CO 80538

    $1,200,000

    • 5 Beds
    • 4.5 Baths
    • 4,537 Sq Ft
    • 6565 Seaside Dr
    • Loveland, CO

    Discover luxury living at its finest in this stunning 5-bedroom, 5-bath gorgeous home spanning over 4,500 square feet of meticulously updated space, situated in the highly desirable Waterfront North neighborhood with private access to Boyd Lake. Upon entry guests are welcomed by a dramatic grand staircase, main floor premium engineered hardwood flooring, designer lighting, and fresh contemporary

    Amilyn Stange C3 Real Estate Solutions, LLC

    Section Image
  • 2224 E County Road 30, Fort Collins, CO 80525

    $1,550,000

    • 4 Beds
    • 4 Baths
    • 4,640 Sq Ft
    • 2224 E County Road 30
    • Fort Collins, CO

    ***ACREAGE PROPERTY!*** 14.4 acres - No HOA - No Metro District! 4 bedrooms plus 5th bedroom option, 2 Offices, Gorgeous Den/Parlor with Floor to Ceiling Book Cases and Beautiful Fireplace. Full Hardwood and Tile Floors throughout main level /w Gorgeous Craftmanship trim-work throughout. Formal Dining Room off the open Kitchen with lots of cabinet space, Granite Hard Surfaces plus the daylight

    Stephen Jensen Yellow Dog Group Real Estate

    Section Image
  • 3553 Valley Oak Dr, Loveland, CO 80538

    $1,850,000

    • 6 Beds
    • 3 Baths
    • 3,568 Sq Ft
    • 3553 Valley Oak Dr
    • Loveland, CO

    Welcome to your dream retreat on the shores of Boyd Lake, where everyday living feels like a vacation. Located on one of the best lots on the lake, this rare lakefront brick ranch offers breathtaking views across the water to the mountains, peaceful privacy, and year-round adventure right outside your door. Whether you're watching bald eagles soar above the water, casting a fishing line, or

    The Sledge Team Group Harmony

    Section Image
  • 2625 Boise Ave, Loveland, CO 80538

    $1,425,000

    • 4 Beds
    • 4 Baths
    • 4,003 Sq Ft
    • 2625 Boise Ave
    • Loveland, CO

    Experience the ultimate in lakefront luxury with this beautifully remodeled all-brick ranch, featuring a walkout basement and sitting on the biggest lot on the street. Enjoy direct access to your own private dock, beach area and expansive views of the mountains and Westerdoll Lake. As one of the few homes on the lake with motorized boating rights, this rare opportunity is truly one-of-a-kind-and

    Jamie Kimberlin Tallent Co. Real Estate

    Section Image
  • 1493 Park Dr, Loveland, CO 80538

    $1,599,000

    • 5 Beds
    • 3 Baths
    • 3,527 Sq Ft
    • 1493 Park Dr
    • Loveland, CO

    Summer Dreams Start Here - Live Lakefront on Westerdoll Lake!A Special OFFER! Yamaha speed boat is included with an accepted offer!Wake up to sparkling water views and dive into the ultimate summer lifestyle! This rare lakefront gem on Westerdoll Lake invites you to make every day feel like a vacation-think backyard barbecues, sun-soaked afternoons, and adrenaline-filled wakeboarding and water

    Christopher Rampone RE/MAX Alliance

    Section Image
  • 706 W 29th St, Loveland, CO 80538

    $1,399,000

    • 4 Beds
    • 3 Baths
    • 2,642 Sq Ft
    • 706 W 29th St
    • Loveland, CO

    Live the Ultimate Lake Life on Lake Loveland. $50,000 Price Drop! This stunning home offers resort-style living every day on one of Lake Lovelands largest lots (0.38 acres / 16,500+ sq ft) in a peaceful, wind-protected cove. Mature trees, garden beds, an apple tree, and private boardwalk make outdoor living exceptional, with lake access for fishing, boating, wakeboarding, paddleboarding, and

    Kathryn Ann Shea C3 Real Estate Solutions, LLC

    Section Image

Range of Values:

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

Purchase History

Date Type Sale Price Title Company
Special Warranty Deed $1,399,000 First American Title
Warranty Deed $1,000,000 None Listed On Document
Interfamily Deed Transfer -- None Available
Quit Claim Deed -- None Listed On Document
Warranty Deed $775,000 First American
Warranty Deed $480,000 Heritage Title
Special Warranty Deed $510,000 Unified Title Company
Warranty Deed -- None Available
Warranty Deed $196,037 Stewart Title Of Colorado
Warranty Deed $156,750 Land Title Guarantee Company
Special Warranty Deed $104,000 North American Title
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Open $806,500 New Conventional
Previous Owner $850,000 New Conventional
Previous Owner $700,000 New Conventional
Previous Owner $620,000 New Conventional
Previous Owner $384,000 New Conventional
Previous Owner $365,000 Unknown
Previous Owner $690,000 Unknown
Previous Owner $46,000 Construction
Previous Owner $535,500 Construction
Previous Owner $500,566 Construction
Previous Owner $156,750 Purchase Money Mortgage
Previous Owner $85,500 Unknown
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
06/13/2025 06/13/25 Sold $1,399,000 0.0% $271 / Sq Ft
05/17/2025 05/17/25 Pending -- -- --
05/15/2025 05/15/25 For Sale $1,399,000 +39.9% $271 / Sq Ft
10/25/2023 10/25/23 Sold $1,000,000 +3.6% $387 / Sq Ft
10/01/2023 10/01/23 Pending -- -- --
09/29/2023 09/29/23 For Sale $965,000 -- $374 / Sq Ft
Source: REcolorado®

Tax History Compared to Growth

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 $6,061 $59,630 $13,400 $46,230
2024 $5,905 $59,630 $13,400 $46,230
2022 $5,275 $46,447 $9,244 $37,203
2021 $5,566 $47,784 $9,510 $38,274
2020 $6,208 $52,831 $4,719 $48,112
2019 $6,136 $52,831 $4,719 $48,112
2018 $5,825 $48,024 $4,752 $43,272
2017 $5,324 $48,024 $4,752 $43,272
2016 $5,526 $45,540 $5,254 $40,286
2015 $5,497 $45,540 $5,250 $40,290
2014 $4,633 $37,610 $5,330 $32,280
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
  • Section Image
See All Agents

Map

Source: REcolorado®

MLS Number: 8231009

REcolorado®

APN: 86293-09-007