NOT LISTED FOR SALE

2174 Longfin Dr Windsor, CO 80550

Estimated Value: $539,000 - $579,000

3 Beds
2.5 Baths
2,970 Sq Ft
$189/Sq Ft Est. Value

Last Sold April 25, 2023

Last sale price $532,500 $179 Per Sq Ft

Est. 5% increase in value since last sale

Current estimated payment $3,325/month

9 Days on Market

Highlights

  • Open Floorplan
  • Eat-In Kitchen
  • Brick Veneer
  • 2 Car Attached Garage
  • Double Pane Windows
  • Walk-In Closet

About This Home

As of April 2023

***LOCKED 5.75% 30 YR FIXED INTEREST RATE*** The Seller already bought down the rate for you! Amazing opportunity to own this five year old home in highly desirable Water Valley! LOW annual HOA, LOW annual metro for non-potable water. Charming features like the upgraded flooring, adorable tile, and the cozy gas fireplace will have you falling in love! The antique wood mantel, which came from a local Windsor dairy farm, is included! There will be no snack storage issues with the absolutely massive walk-in pantry in the kitchen. Expand into the full height ceiling basement for additional room, or enjoy the pet-ready fenced backyard. Head upstairs to the primary suite of your dreams, complete with a sitting area, en suite bathroom, and huge walk-in closet. Use the whole house fan to cool your new home on a budget, or crank the central AC! No matter what your needs are, this home will have you saying "this is the one!"

Last Agent to Sell the Property

Liz Crews

eXp Realty - Northern CO Listed on: 03/13/2023

eXp Realty - Northern CO

Last Buyer's Agent

Eric Stashak

Keller Williams-DTC

Keller Williams-DTC

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $3,863

Year Built

  • Built in 2017

Lot Details

  • 6,098 Sq Ft Lot
  • East Facing Home
  • Fenced
  • Sprinkler System

HOA Fees

  • $12 Monthly HOA Fees

Parking

  • 2 Car Attached Garage
  • Garage Door Opener

Home Design

  • Brick Veneer
  • Wood Frame Construction
  • Composition Roof

Interior Spaces

  • 2,970 Sq Ft Home
  • 2-Story Property
  • Open Floorplan
  • Ceiling Fan
  • Gas Fireplace
  • Double Pane Windows
  • Window Treatments
  • Unfinished Basement
  • Partial Basement

Kitchen

  • Eat-In Kitchen
  • Electric Oven or Range
  • Microwave
  • Dishwasher
  • Kitchen Island
  • Disposal

Flooring

  • Carpet
  • Luxury Vinyl Tile

Bedrooms and Bathrooms

  • 3 Bedrooms
  • Walk-In Closet

Laundry

  • Laundry on upper level
  • Dryer
  • Washer

Outdoor Features

  • Patio
  • Exterior Lighting

Location

  • Property is near a golf course

Schools

  • Mountain View Elementary School
  • Windsor Middle School
  • Windsor High School

Utilities

  • Whole House Fan
  • Forced Air Heating and Cooling System
  • High Speed Internet
  • Satellite Dish
  • Cable TV Available

Listing and Financial Details

  • Assessor Parcel Number R6785478

Community Details

Overview

  • Association fees include common amenities, management
  • Water Valley South Subdivision

Recreation

  • Park

Home Details

Home Type

Single Family

Est. Annual Taxes

$3,863

Year Built

Built in 2017

Lot Details

0

HOA Fees

$12 per month

Parking

2

Listing Details

  • Year Built: 2017
  • Property Sub Type: Residential-Detached
  • Prop. Type: Residential
  • Horses: No
  • Lot Size Acres: 0.14
  • Road Frontage Type: City Street
  • Road Surface Type: Paved, Asphalt
  • Subdivision Name: Water Valley South
  • Directions: From I-25, take exit 259 for Crossroads Blvd and continue for approx. 6 miles. Turn right onto Rancho Drive just before Timberline Church, and then an immediate right onto Longfin Drive. The property will be on your right.
  • Above Grade Finished Sq Ft: 2124
  • Garage Yn: Yes
  • Unit Levels: Two
  • New Construction: No
  • Building Stories: 2
  • Kitchen Level: Main
  • IRESDS_HasWaterRights: No
  • IRESDS_Total Sq Ft: 2970
  • Special Features: None
  • Stories: 2

Interior Features

  • Possible Use: Single Family
  • Private Spa: No
  • Appliances: Electric Range/Oven, Dishwasher, Refrigerator, Washer, Dryer, Microwave, Disposal
  • Has Basement: Partial, Unfinished
  • Full Bathrooms: 1
  • Half Bathrooms: 1
  • Three Quarter Bathrooms: 1
  • Total Bedrooms: 3
  • Below Grade Sq Ft: 846
  • Fireplace Features: Gas
  • Fireplace: Yes
  • Interior Amenities: Satellite Avail, High Speed Internet, Eat-in Kitchen, Open Floorplan, Pantry, Walk-In Closet(s), Kitchen Island
  • Living Area: 2124
  • Window Features: Window Coverings, Double Pane Windows
  • Room Bedroom3 Features: Carpet
  • Dining Room Features: Luxury Vinyl Floor
  • IRESDS_HasFamilyRoom: No
  • Living Room Living Room Level: Main
  • Room Bedroom3 Area: 120
  • Master Bedroom Master Bedroom Level: Upper
  • Room Bedroom2 Area: 130
  • Room Bedroom3 Level: Upper
  • Master Bedroom Master Bedroom Width: 14
  • Room Bedroom2 Level: Upper
  • Room Bedroom2 Features: Carpet
  • Master Bedroom Features: Carpet
  • Room Kitchen Features: Luxury Vinyl Floor
  • Room Living Room Area: 224
  • Living Room Features: Luxury Vinyl Floor
  • Room Kitchen Area: 140
  • Dining Room Dining Room Level: Main
  • Room Master Bedroom Area: 350
  • Room Dining Room Area: 135
  • Master Bathroom Features: 3/4 Primary Bath
  • ResoLivingAreaSource: Other

Exterior Features

  • Roof: Composition
  • Fencing: Fenced
  • Lot Features: Curbs, Gutters, Sidewalks, Lawn Sprinkler System, Near Golf Course
  • Waterfront: No
  • Construction Type: Wood/Frame, Brick/Brick Veneer
  • Direction Faces: East
  • Exterior Features: Lighting
  • Patio And Porch Features: Patio
  • Property Condition: Not New, Previously Owned

Garage/Parking

  • Attached Garage: Yes
  • Covered Parking Spaces: 2
  • Garage Spaces: 2
  • Parking Features: Garage Door Opener
  • IRESDS_Garage Sq Ft: 432
  • IRESDS_GarageType: Attached

Utilities

  • Cooling: Central Air, Ceiling Fan(s), Whole House Fan
  • Electric: Electric, PVREA
  • Heating: Forced Air, 2 or more Heat Sources
  • Utilities: Natural Gas Available, Electricity Available, Cable Available
  • Laundry Features: Washer/Dryer Hookups, Upper Level
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Sewer: City Sewer
  • Water Source: City Water, Town of Windsor
  • Gas Company: Natural Gas, Atmos

Condo/Co-op/Association

  • HOA Fee Includes: Common Amenities, Management
  • Community Features: Park
  • Senior Community: No
  • Association Fee: 140
  • Association Fee Frequency: Annually
  • Association: Yes

Association/Amenities

  • IRESDS_HasAssociationReserve: Yes
  • IRESDS_HasAssociationFee: Yes

Schools

  • Elementary School: Mountain View,Tozer
  • HighSchool: Windsor
  • Junior High Dist: Weld RE-4
  • Middle Or Junior School: Windsor

Lot Info

  • Zoning: RES
  • Lot Size Sq Ft: 6098
  • Parcel #: R6785478
  • ResoLotSizeUnits: SquareFeet

Tax Info

  • Tax Year: 2021
  • Tax Annual Amount: 3863

Multi Family

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Mar 13, 2023
Closed on
Apr 25, 2023
Sold by
Hayden-Ugarte Lynn M
Bought by
Carrico Benjamin and Carrico Tiffanie
Seller's Agent
Liz Crews
eXp Realty - Northern CO
Buyer's Agent
Eric Stashak
Keller Williams-DTC
List Price
$540,000
Sold Price
$532,500
Premium/Discount to List
-$7,500
-1.39%
Views
29
Current Estimated Value
$560,142

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$27,642
Avg. Annual Appreciation
0.96%
Original Mortgage
$449,411
Outstanding Balance
$438,307
Interest Rate
6.6%
Mortgage Type
VA
Estimated Equity
$106,652

Purchase Details

Closed on
Jul 13, 2018
Sold by
Melody Homes Inc
Bought by
Hayden Ugarte Lynn M

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$185,000
Interest Rate
4.5%
Mortgage Type
New Conventional
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
Carrico Benjamin $532,500 None Listed On Document
Hayden Ugarte Lynn M $385,000 Heritage Title Co
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Carrico Benjamin $449,411
Previous Owner Hayden Ugarte Lynn M $185,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
04/25/2023 04/25/23 Sold $532,500 -1.4% $179 / Sq Ft
03/26/2023 03/26/23 Pending -- -- --
03/16/2023 03/16/23 For Sale $540,000 -- $182 / Sq Ft
Source: IRES MLS

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 $4,121 $34,500 $8,130 $26,370
2024 $4,121 $34,500 $8,130 $26,370
2023 $3,799 $34,130 $6,290 $27,840
2022 $4,042 $28,820 $5,560 $23,260
2021 $3,863 $29,650 $5,720 $23,930
2020 $3,755 $29,200 $6,290 $22,910
2019 $3,732 $29,200 $6,290 $22,910
2018 $3,385 $25,670 $5,040 $20,630
2017 $2,271 $16,820 $16,820 $0
2016 $638 $4,760 $4,760 $0
2015 $607 $4,760 $4,760 $0
2014 $6 $0 $0 $0
Source: Public Records

Agents Affiliated with this Home

  • Liz Crews

    Seller's Agent in 2023

    Liz Crews

    eXp Realty - Northern CO

    (970) 575-5055

    90 Total Sales

    Liz Crews
    Section Image
  • Eric Stashak

    Buyer's Agent in 2023

    Eric Stashak

    Keller Williams-DTC

    (970) 449-7100

    139 Total Sales

    Eric Stashak
    Section Image
See All Agents

Map

Source: IRES MLS

MLS Number: 983383

IRES MLS

APN: R6785478

Colorado Weld County Windsor 80550

2174 Longfin Dr, Windsor, CO

This home is located at 2174 Longfin Dr, Windsor, CO 80550 since 13 March 2023 and is currently estimated at $560,142, approximately $188 per square foot. This property was built in 2017. 2174 Longfin Dr is a home located in Weld County with nearby schools including Tozer Elementary School, Mountain View Elementary School, and Windsor Middle School.

Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.

IRES MLS Information source: Information and Real Estate Services, LLC. Provided for limited non-commercial use only under IRES Rules © Copyright IRES.

Listing information is provided exclusively for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.

Information deemed reliable but not guaranteed by the MLS.

Nearby Homes