NOT LISTED FOR SALE

Estimated Value: $560,000 - $581,000

3 Beds
2.5 Baths
1,769 Sq Ft
$322/Sq Ft Est. Value

Last Sold March 19, 2024

Last sale price $549,900 $311 Per Sq Ft

Est. 4% increase in value since last sale

Current estimated payment $3,403/month

71 Days on Market

Highlights

  • New Construction
  • Corner Lot
  • Double Oven
  • Primary Bedroom Suite
  • Quartz Countertops
  • Front Porch

About This Home

As of March 2024

**Limited time special financing with builder's affiliated mortgage company - 30 Year Fixed Conv. 2-1 Buydown- First Year Rate of 3.99% (6.25%APR). Terms and conditions apply.**

Move-in ready! This duplex residence presents a contemporary farmhouse façade that radiates both charm and sophistication. Complemented by a two-car garage with extra storage space, an expansive unfinished basement, and an elongated front porch, the property seamlessly blends functionality with style. Step inside to discover a main level featuring an open floor plan, providing abundant space for comfortable living. The dwelling is move-in ready, equipped with double ovens, a gas range, refrigerator, washer and dryer, and window blinds. Venture upstairs to encounter two bedrooms, including a generously sized primary suite. The kitchen is a focal point, adorned with dark, cherry slate cabinetry and elegant white quartz countertops, elevating the overall aesthetic.

Located in the new, Sugar Mill Village neighborhood, just minutes from downtown Longmont and surrounded by miles of trails and open space, plus a neighborhood dog park!

Taxes are TBD and have not been assessed yet for this home. Est. annual taxes are shown at approx. 0.7% of the purchase price.

Last Agent to Sell the Property

Stephanie Graham

Your Castle Realty LLC Brokerage Email: steph@cityliving5280.com License #100027144 Listed on: 12/01/2023

Your Castle Realty LLC

Last Buyer's Agent

Kelly Spencer

Keller Williams DTC License #40035052

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $3,849

Year Built

  • Built in 2023 | New Construction

Lot Details

  • 2,925 Sq Ft Lot
  • Corner Lot

HOA Fees

  • $100 Monthly HOA Fees

Parking

  • 2 Car Attached Garage

Home Design

  • Composition Roof
  • Wood Siding

Interior Spaces

  • 2-Story Property
  • Wired For Data
  • Double Pane Windows
  • Smart Doorbell
  • Unfinished Basement
  • Basement Fills Entire Space Under The House

Kitchen

  • Double Oven
  • Range
  • Microwave
  • Dishwasher
  • Kitchen Island
  • Quartz Countertops
  • Disposal

Bedrooms and Bathrooms

  • 3 Bedrooms
  • Primary Bedroom Suite
  • Walk-In Closet

Laundry

  • Dryer
  • Washer

Home Security

  • Smart Locks
  • Smart Thermostat

Outdoor Features

  • Front Porch

Schools

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

Utilities

  • Forced Air Heating and Cooling System
  • High Speed Internet

Community Details

  • Association fees include ground maintenance
  • Sugar Mill Village: Managed By Associa Colorado As Association, Phone Number (303) 232-9200
  • Built by TRI Pointe Homes
  • Sugar Mill Village Subdivision, Plan 2

Listing and Financial Details

  • Assessor Parcel Number R0615044

Home Details

Home Type

Single Family

Est. Annual Taxes

$3,849

Year Built

Built in 2023 | New Construction

Lot Details

0

HOA Fees

$100 per month

Parking

2

Listing Details

  • Property Type: Residential
  • Property Sub Type: Single Family Residence
  • Structure Type: Duplex
  • Levels: Two
  • Year Built: 2023
  • Above Grade Finished Sq Ft: 1769
  • Exclusions: None
  • Living Area: 1769
  • Pets Allowed: Yes
  • Property Condition: New Construction
  • Directions: Located just south of Hwy 119 & E 3rd Ave. * From I-25 head westbound on Hwy 119 and turn left on 3rd Ave, then make a right on Great Western Drive, the model homes will be on your left * From Hwy 287 head eastbound on Ken Pratt Blvd/Hwy 119 and turn right on Great Western Drive, the model homes will be on your right.
  • SubdivisionName: Sugar Mill Village
  • Ownership: Builder
  • Property Attached Yn: Yes
  • REC_BasementLevelBathrooms: 0
  • REC_BasementLevelBedrooms: 0
  • REC_BelowGradeUnfinishedArea: 727.00
  • REC_RVSpaces: 0
  • REC_UpperLevelBathrooms: 2
  • REC_UpperLevelBedrooms: 3
  • Ratio Close Price By Original Li: 1.00000
  • New Home Current Promotions: **Limited Time Special Financing - 30 Year Fixed Conv. 2-1 Buydown- First Year Rate of 3.99% (6.25%APR)* through Tri Pointe Home’s affiliated mortgage company Tri Pointe Connect. *Terms and conditions apply, for details please visit www.TriPointeHomes.com/BelowMarketRates **
  • Attribution Contact: steph@cityliving5280.com
  • Special Features: NewHome

Interior Features

  • Appliances: Dishwasher, Disposal, Double Oven, Dryer, Microwave, Range, Refrigerator, Washer
  • Interior Amenities: High Speed Internet, Kitchen Island, Primary Suite, Quartz Counters, Smart Thermostat, Walk-In Closet(s), Wired for Data
  • Full Bathrooms: 1
  • Half Bathrooms: 1
  • Common Walls: 1 Common Wall
  • Basement: Full, Unfinished
  • Basement: Yes
  • Three Quarter Bathrooms: 1
  • Total Bedrooms: 3
  • Main Level Bathrooms: 1
  • Window Features: Double Pane Windows

Exterior Features

  • Roof: Composition
  • Construction Materials: Wood Siding
  • Patio and Porch Features: Front Porch

Garage/Parking

  • Attached Garage: Yes
  • Garage Spaces: 2
  • Total Parking Spaces: 2
  • REC_ParkingCount: 1

Utilities

  • Sewer: Public Sewer
  • Cooling: Central Air
  • Heating: Forced Air
  • Water Source: Public
  • Security: Smart Locks, Video Doorbell

Condo/Co-op/Association

  • HOA Fee Includes: Maintenance Grounds
  • Association Name: Sugar Mill Village: Managed by Associa Colorado As
  • Association Fee Frequency: Monthly
  • Association Fee: 100
  • Phone: 303.232.9200
  • 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

Schools

  • Middle Or Junior School: Trail Ridge

Lot Info

  • Parcel Number: R0615044
  • Lot Size Acres: 0.07
  • Building Area Total: 2496
  • Lot Features: Corner Lot
  • Lot Size Sq Ft: 2925
  • ResoLotSizeUnits: SquareFeet

Building Info

  • Builder Name: TRI Pointe Homes

Tax Info

  • Tax Year: 2022
  • Tax Annual Amount: 3849

MLS Schools

  • Elementary School: Rocky Mountain
  • High School: Skyline

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Dec 1, 2023
Closed on
Mar 19, 2024
Sold by
Tri Pointe Homes Inc and Tri Pointe Homes Holdings Inc
Bought by
Crispino Francesca and Crispino Tracy
Seller's Agent
Stephanie Graham
Your Castle Realty LLC
Buyer's Agent
Kelly Spencer
Keller Williams DTC
List Price
$549,900
Sold Price
$549,900
Views
39
Current Estimated Value
$570,402

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$20,502
Avg. Annual Appreciation
2.37%
Original Mortgage
$424,900
Outstanding Balance
$418,017
Interest Rate
6.77%
Mortgage Type
New Conventional
Estimated Equity
$152,385
Source: Public Records

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 Buyer Sale Price Title Company
Crispino Francesca $549,900 First American Title
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Crispino Francesca $424,900
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
03/19/2024 03/19/24 Sold $549,900 0.0% $311 / Sq Ft
02/11/2024 02/11/24 Pending -- -- --
12/01/2023 12/01/23 For Sale $549,900 -- $311 / 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 $3,448 $35,563 $4,894 $30,669
2024 $3,448 $35,563 $4,894 $30,669
2023 $3,793 $36,046 $5,286 $34,445
2022 $1,742 $17,603 $17,603 $0
2021 $249 $0 $0 $0
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: REcolorado®

MLS Number: 3142198

REcolorado®

APN: 1315120-73-017