$750,000
UNDER CONTRACT

Estimated payment $4,371/month

Total Views 706
5 Beds
4 Baths
3,064 Sq Ft
$245 Price per Sq Ft

Highlights

  • Primary Bedroom Suite
  • Deck
  • Traditional Architecture
  • Fireplace in Primary Bedroom
  • Vaulted Ceiling
  • Wood Flooring

About This Home

Between the vaulted entrance, natural light, luxurious updates, gleaming floors and outdoor features, its hard to convey how special this home is. No expense was spared in the updates and the design is impressive from both a visual and functional standpoint. The interior is a showcase of smart home innovation. The lighting and blinds are fully integrated and ready to be voice-controlled, allowing you to set the perfect ambiance without lifting a finger. The primary suite is entered through french doors and offers a true spa escape, featuring a luxurious 4 head steam shower and a heated towel rack mounted to a custom stone see-through fireplace. An oversized walk in closet has plenty of room and there is a large en-suite balcony to enjoy added private relaxation. The backyard is an entertainer’s paradise, boasting a gorgeous, modern outdoor kitchen and a massive custom stamped and colored patio. The outdoor gourmet kitchen includeds a 2 head keg tap system, a built in gas grill, a built in side burner and enough countertop seating for the large gatherings. There is a custom stone fireplace as well, perfect for memorable evenings with friends and family. The yard has artificial turf for low-maintenance living and custom lighting sets ambiance in the space. It doesn't end there, the versatile floor plan includes a fully finished basement, providing a private retreat with its own bedroom and bathroom. There are a total of 4 fireplaces on the property, a jack-and-jill bath upstairs and the main level has a full bathtub/shower. There is office space on the main level and 220V is already installed for electric charging in the garage. All of the outlets have plugins for usb ports. The list goes on and on! Perfectly situated near Longmont’s best amenities, you are within 5 minutes of downtown Longmont, Union Reservoir, grocery shopping and Ute Creek Golf Course.

Listing Agent

Wesley Charles

eXp Realty, LLC Brokerage Email: wes@rootandrisere.com,720-712-3887 License #100082819 Listed on: 04/09/2026

eXp Realty, LLC

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $4,563

Year Built

  • Built in 1996 | Remodeled

Lot Details

  • 7,176 Sq Ft Lot
  • Property is Fully Fenced
  • Landscaped
  • Front Yard Sprinklers
  • Private Yard
  • Property is zoned R1

HOA Fees

  • $14 Monthly HOA Fees

Parking

  • 3 Car Attached Garage
  • Electric Vehicle Home Charger
  • Exterior Access Door

Home Design

  • Traditional Architecture
  • Frame Construction
  • Composition Roof
  • Wood Siding
  • Stone Siding

Interior Spaces

  • 2-Story Property
  • Wet Bar
  • Sound System
  • Wired For Data
  • Vaulted Ceiling
  • Gas Log Fireplace
  • Electric Fireplace
  • Double Pane Windows
  • Window Treatments
  • Family Room
  • Living Room with Fireplace
  • 3 Fireplaces
  • Dining Room
  • Den
  • Game Room
  • Utility Room
  • Fire and Smoke Detector

Kitchen

  • Eat-In Kitchen
  • Oven
  • Cooktop
  • Microwave
  • Dishwasher
  • Laminate Countertops

Flooring

  • Wood
  • Carpet
  • Linoleum
  • Tile

Bedrooms and Bathrooms

  • Fireplace in Primary Bedroom
  • Primary Bedroom Suite
  • Walk-In Closet
  • Jack-and-Jill Bathroom
  • Steam Shower

Laundry

  • Laundry Room
  • Dryer
  • Washer
  • Sink Near Laundry

Finished Basement

  • Fireplace in Basement
  • 1 Bedroom in Basement

Eco-Friendly Details

  • Energy-Efficient Thermostat
  • Smart Irrigation

Outdoor Features

  • Balcony
  • Deck
  • Covered Patio or Porch
  • Fire Pit
  • Exterior Lighting
  • Outdoor Gas Grill
  • Rain Gutters

Schools

  • Rocky Mountain Elementary School
  • Trail Ridge Middle School
  • Skyline High School

Utilities

  • Forced Air Heating and Cooling System
  • 220 Volts in Garage

Listing and Financial Details

  • Exclusions: Sellers Personal Property, Staging Items, Swim Spa (negotiable).
  • Assessor Parcel Number R0120561

Community Details

Overview

  • Association fees include reserves
  • Sugarmill Farms HOA, Phone Number (303) 457-1444
  • Sugarmill Subdivision

Recreation

  • Trails

Home Details

Home Type

Single Family

Est. Annual Taxes

$4,563

Year Built

Built in 1996 | Remodeled

Lot Details

7,176 Sq Ft Lot

HOA Fees

$14 per month

Parking

3

Listing Details

  • Property Type: Residential
  • Property Sub Type: Single Family Residence
  • Architectural Style: Traditional
  • Structure Type: House
  • Levels: Two
  • Year Built: 1996
  • Above Grade Finished Sq Ft: 2189
  • Below Grade Sq Ft: 108
  • Exclusions: Sellers Personal Property, Staging Items, Swim Spa (negotiable).
  • Living Area: 3064
  • Property Condition: Updated/Remodeled
  • SubdivisionName: Sugarmill
  • Ownership: Individual
  • Property Attached Yn: No
  • REC_BasementLevelBedrooms: 1
  • REC_RVSpaces: 0
  • REC_UpperLevelBathrooms: 2
  • REC_UpperLevelBedrooms: 3
  • REC_WaterIncludedYN: 1
  • Special Features: 4224

Interior Features

  • Appliances: Cooktop, Dishwasher, Dryer, Microwave, Oven, Refrigerator, Washer
  • Fireplaces: 3
  • Interior Amenities: Eat-in Kitchen, Five Piece Bath, Jack & Jill Bathroom, Laminate Counters, Primary Suite, Sound System, Vaulted Ceiling(s), Walk-In Closet(s), Wet Bar, Wired for Data
  • Flooring: Carpet, Linoleum, Tile, Wood
  • Fireplace Features: Basement, Electric, Gas, Gas Log, Living Room, Primary Bedroom
  • Full Bathrooms: 3
  • Basement: Finished
  • Basement: Yes
  • Three Quarter Bathrooms: 1
  • Total Bedrooms: 5
  • Below Grade Sq Ft: 875
  • Main Level Bathrooms: 1
  • Main Level Bedrooms: 1
  • Window Features: Double Pane Windows, Window Coverings

Exterior Features

  • Roof: Composition
  • Construction Materials: Frame, Stone, Wood Siding
  • Exterior Features: Balcony, Barbecue, Fire Pit, Gas Grill, Lighting, Private Yard, Rain Gutters, Smart Irrigation
  • Patio and Porch Features: Covered, Deck, Front Porch, Patio
  • Road Frontage Type: Public
  • Road Surface Type: Paved

Garage/Parking

  • Parking Features: 220 Volts, Concrete, Exterior Access Door
  • Attached Garage: Yes
  • Garage Spaces: 3
  • Total Parking Spaces: 3

Utilities

  • Sewer: Public Sewer
  • Cooling: Central Air
  • Heating: Forced Air
  • Water Source: Public
  • Laundry Features: Sink, In Unit
  • Security: Smoke Detector(s)

Condo/Co-op/Association

  • HOA Fee Includes: Reserves
  • Association Name: Sugarmill Farms HOA
  • Association Fee Frequency: Annually
  • Association Amenities: Trail(s)
  • Association Fee: 172
  • Phone: 303-457-1444
  • Association: Yes
  • Senior Community: No

Association/Amenities

  • REC_AssociationFee2Annual: 0.00
  • REC_AssociationFee3Annual: 0.00
  • REC_AssociationFeeAnnual: 172.00
  • REC_AssociationFeeTotalAnnual: 172.00
  • REC_AssociationManagementType: Professionally Managed

Schools

  • Middle Or Junior School: Trail Ridge

Lot Info

  • Parcel Number: R0120561
  • Lot Size Acres: 0.16
  • Fencing: Full
  • Building Area Total: 3172
  • Lot Features: Landscaped, Sprinklers In Front
  • Lot Size Sq Ft: 7176

Green Features

  • Green Energy Efficient: Thermostat

Tax Info

  • Tax Year: 2025
  • Tax Annual Amount: 4563

MLS Schools

  • Elementary School: Rocky Mountain
  • High School: Skyline

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 $4,169 $43,463 $10,744 $32,719
2024 $4,169 $43,463 $10,744 $32,719
2023 $4,112 $43,584 $11,745 $35,523
2022 $3,543 $35,800 $8,229 $27,571
2021 $3,589 $36,830 $8,466 $28,364
2020 $3,237 $33,319 $7,436 $25,883
2019 $3,186 $33,319 $7,436 $25,883
2018 $2,752 $28,973 $5,544 $23,429
2017 $2,715 $32,031 $6,129 $25,902
2016 $2,623 $27,438 $7,960 $19,478
2015 $2,499 $22,988 $5,174 $17,814
2014 $2,140 $22,988 $5,174 $17,814
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft Prior Sale
04/09/2026 04/09/26 For Sale $750,000 +88.7% $245 / Sq Ft
01/28/2019 01/28/19 Off Market $397,500 -- --
06/09/2017 06/09/17 Sold $397,500 +1.9% $125 / Sq Ft View Prior Sale
05/04/2017 05/04/17 Pending -- -- --
05/04/2017 05/04/17 For Sale $390,000 -- $123 / Sq Ft
Source: REcolorado®

Purchase History

Date Type Sale Price Title Company
Quit Claim Deed -- None Listed On Document
Quit Claim Deed -- None Available
Warranty Deed -- None Available
Warranty Deed $192,000 --
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Previous Owner $153,600 No Value Available
Source: Public Records

Source: REcolorado®

MLS Number: 6051725

REcolorado®

APN: 1315021-29-008

Your Personal Tour Guide

Ask me questions while you tour the home.