NOT LISTED FOR SALE

Estimated Value: $959,000 - $1,106,000

4 Beds
3.5 Baths
4,295 Sq Ft
$242/Sq Ft Est. Value

Last Sold May 31, 2024

Last sale price $1,080,000 $251 Per Sq Ft

Est. 4% decrease in value since last sale

Current estimated payment $6,280/month

7 Days on Market

Highlights

  • On Golf Course
  • Open Floorplan
  • Clubhouse
  • Fall River Elementary School Rated A-
  • Mountain View
  • Contemporary Architecture

About This Home

As of May 2024

Step into a realm of architectural beauty with this custom two-story home in the prestigious Sundance neighborhood. Occupying a prime corner lot that backs onto open space, this residence is framed by stunning mountain views and is a stone's throw from the Ute Creek Golf Course and Jim Hamm Nature Area. Upon entering, you are greeted by a showcase of intricate woodworking and custom appointments, with over $250K in high-end upgrades that are meticulously crafted throughout the home. Soaring ceilings open the space to an airy grandeur, complemented by rich hardwood flooring and sunlight filtering through plantation shutters. The custom stone fireplace in the great room stands as a focal point, promising to turn chilly nights into cozy moments. Adjacent lies the gourmet kitchen, a culinary artist's dream featuring top-of-the-line appliances, a Viking range, granite counters, a pantry, and an inviting island bar with seating. A quaint breakfast nook embraced by bow windows presents breathtaking views of the backyard oasis. Entertain guests in style within the formal dining area or conduct work in the dedicated office with French doors for added privacy. A grand staircase leads upstairs, guiding one to a loft that provides a unique vantage point of the great room below. The upstairs haven consists of four bedrooms, including the spacious primary suite with vaulted ceilings and a seating area that amplify the sense of space, and a spa-like ensuite bathroom with a soaking tub and a walk-in closet. The finished basement is your ultimate recreational zone, with enough space for a lounge area, pool table, wine cellar, and gym. Step outside to the backyard paradise, where mature trees provide a natural canopy over the charming concrete patio and pergola, an idyllic setting for relaxation and outdoor enjoyment. Located within easy access to a wealth of local amenities, this home strikes the perfect balance between nature's tranquility and the convenience of nearby services.

Last Agent to Sell the Property

Rob Kittle

Kittle Real Estate Listed on: 04/10/2024

Co-Listed By

Heide Fralic

Kittle Real Estate

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $5,983

Year Built

  • Built in 2002

Lot Details

  • 10,508 Sq Ft Lot
  • On Golf Course
  • Open Space
  • Partially Fenced Property
  • Corner Lot
  • Sprinkler System
  • Landscaped with Trees
  • Property is zoned R-SF

HOA Fees

  • $110 Monthly HOA Fees

Parking

  • 3 Car Attached Garage

Home Design

  • Contemporary Architecture
  • Wood Frame Construction
  • Composition Roof
  • Stucco
  • Stone

Interior Spaces

  • 4,295 Sq Ft Home
  • 2-Story Property
  • Open Floorplan
  • Crown Molding
  • Cathedral Ceiling
  • Gas Log Fireplace
  • Bay Window
  • Great Room with Fireplace
  • Dining Room
  • Home Office
  • Wood Flooring
  • Mountain Views
  • Basement Fills Entire Space Under The House
  • Fire and Smoke Detector

Kitchen

  • Eat-In Kitchen
  • Gas Oven or Range
  • Microwave
  • Freezer
  • Dishwasher
  • Kitchen Island
  • Trash Compactor

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Split Bedroom Floorplan
  • Walk-In Closet
  • Jack-and-Jill Bathroom

Laundry

  • Laundry on main level
  • Dryer
  • Washer
  • Sink Near Laundry

Outdoor Features

  • Patio
  • Outdoor Gas Grill

Schools

  • Fall River Elementary School
  • Trail Ridge Middle School
  • Skyline High School

Additional Features

  • Energy-Efficient HVAC
  • Property is near a golf course
  • Forced Air Heating and Cooling System

Listing and Financial Details

  • Assessor Parcel Number R0500680

Community Details

Overview

  • Association fees include common amenities, management
  • Sundance Neighborhood HOA, Phone Number (866) 473-2573
  • Sundance, Spring Valley Subdivision

Amenities

  • Clubhouse

Recreation

  • Community Pool
  • Park

Home Details

Home Type

Single Family

Est. Annual Taxes

$5,983

Year Built

Built in 2002

Lot Details

0

HOA Fees

$110 per month

Parking

3

Listing Details

  • Inclusions: Gas Range/Oven,Dishwasher,Refrigerator,Clothes Washer,Clothes Dryer,Microwave,Trash Compactor,Freezer,Laundry Tub,Gas Bar-B-Q,Smoke Alarm(s)
  • Year Built: 2002
  • Property Sub Type: Residential-Detached
  • Prop. Type: Residential
  • Horses: No
  • Lot Size Acres: 0.24
  • Road Frontage Type: City Street
  • Road Surface Type: Concrete
  • Co List Office Mls Id: KTLRE
  • Subdivision Name: Sundance, Spring Valley
  • Above Grade Finished Sq Ft: 3031
  • Architectural Style: Contemporary/Modern
  • Garage Yn: Yes
  • Unit Levels: Two
  • New Construction: No
  • Efficiency: HVAC
  • Building Stories: 2
  • Kitchen Level: Main
  • IRESDS_HasWaterRights: No
  • IRESDS_Total Sq Ft: 4295
  • Special Features: VirtualTour
  • Stories: 2

Interior Features

  • Possible Use: Single Family
  • Private Spa: No
  • Appliances: Gas Range/Oven, Dishwasher, Refrigerator, Washer, Dryer, Microwave, Trash Compactor, Freezer
  • Has Basement: Full, Partially Finished
  • Full Bathrooms: 2
  • Half Bathrooms: 1
  • Three Quarter Bathrooms: 1
  • Total Bedrooms: 4
  • Below Grade Sq Ft: 1264
  • Fireplace Features: Gas, Gas Logs Included, Great Room
  • Fireplace: Yes
  • Flooring: Wood Floors
  • Interior Amenities: Study Area, Eat-in Kitchen, Separate Dining Room, Cathedral/Vaulted Ceilings, Open Floorplan, Pantry, Walk-In Closet(s), Jack & Jill Bathroom, Kitchen Island, 9ft+ Ceilings, Crown Molding, Split Bedroom Floor Plan
  • Living Area: 4295
  • Main Level Bathrooms: 1
  • Window Features: Bay Window(s)
  • Room Bedroom4 Area: 144
  • Room Bedroom3 Features: Carpet
  • Dining Room Features: Hardwood
  • IRESDS_HasFamilyRoom: No
  • Room Bedroom4 Level: Upper
  • Living Room Living Room Level: Main
  • Room Bedroom3 Area: 225
  • Room Bedroom4 Features: Carpet
  • Master Bedroom Master Bedroom Level: Upper
  • Room Bedroom2 Area: 180
  • Room Bedroom3 Level: Upper
  • Master Bedroom Master Bedroom Width: 25
  • Room Bedroom2 Level: Upper
  • Room Bedroom2 Features: Carpet
  • Master Bedroom Features: Hardwood
  • Room Kitchen Features: Hardwood
  • Room Living Room Area: 234
  • Living Room Features: Hardwood
  • Room Kitchen Area: 494
  • Dining Room Dining Room Level: Main
  • Room Master Bedroom Area: 375
  • Room Dining Room Area: 192
  • Master Bathroom Features: Luxury Features Primary Bath, 5 Piece Primary Bath

Exterior Features

  • Roof: Composition
  • Fencing: Partial
  • Lot Features: Lawn Sprinkler System, Corner Lot, On Golf Course, Near Golf Course, Abuts Public Open Space
  • View: Mountain(s), Foothills View
  • View: Yes
  • Waterfront: No
  • Disclosures: Seller's Property Disclosure
  • Home Warranty: No
  • Construction Type: Wood/Frame, Stone, Stucco
  • Exterior Features: Gas Grill
  • Patio And Porch Features: Patio
  • Property Condition: Not New, Previously Owned

Garage/Parking

  • Attached Garage: Yes
  • Covered Parking Spaces: 3
  • Garage Spaces: 3
  • Parking Features: Oversized
  • IRESDS_Garage Sq Ft: 808
  • IRESDS_GarageType: Attached

Utilities

  • Cooling: Central Air
  • Electric: Electric, Longmont City
  • Heating: Forced Air
  • Utilities: Natural Gas Available, Electricity Available
  • Laundry Features: Sink, Washer/Dryer Hookups, Main Level
  • Security: Smoke Detector(s)
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Electricity On Property: No
  • Sewer: City Sewer
  • Water Source: City Water, City of Longmont
  • Gas Company: Natural Gas, Xcel Energy

Condo/Co-op/Association

  • HOA Fee Includes: Common Amenities, Management
  • Community Features: Clubhouse, Pool, Park
  • Senior Community: No
  • Association Fee: 110
  • Association Fee Frequency: Monthly
  • Association Name: Sundance Neighborhood HOA
  • Phone: 866-473-2573
  • Association: Yes

Association/Amenities

  • IRESDS_HasAssociationReserve: Yes
  • IRESDS_HasAssociationFee: Yes

Schools

  • Elementary School: Fall River
  • HighSchool: Skyline
  • Junior High Dist: ST Vrain Dist RE 1J
  • Middle Or Junior School: Trail Ridge

Lot Info

  • Zoning: R-SF
  • Lot Size Sq Ft: 10508
  • Parcel #: R0500680
  • Irrigation Water Rights: No

Tax Info

  • Tax Year: 2023
  • Tax Annual Amount: 5983

Multi Family

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Apr 10, 2024
Closed on
May 31, 2024
Sold by
Cowden John David and Kavanaugh Katherine Jane
Bought by
Bernstein Gary A and Bernstein Claire E
Seller's Agent
Rob Kittle
Kittle Real Estate
List Price
$1,115,000
Sold Price
$1,080,000
Premium/Discount to List
-$35,000
-3.14%
Views
14
Current Estimated Value
$1,039,571

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
-$40,429
Avg. Annual Appreciation
-3.10%
Original Mortgage
$1,080,000
Interest Rate
7.1%
Mortgage Type
Construction

Purchase Details

Listed on
Dec 6, 2017
Closed on
Mar 2, 2018
Sold by
Langreen Donald Richard and Langreen Rebecca Ruth
Bought by
Cowden John David
Seller's Agent
The Mullenberg Team
eXp Realty - Northern CO
Buyer's Agent
Chris Mullenberg
eXp Realty - Northern CO
List Price
$726,000
Sold Price
$715,000
Premium/Discount to List
-$11,000
-1.52%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
6.82%
Original Mortgage
$572,000
Interest Rate
3.62%
Mortgage Type
Adjustable Rate Mortgage/ARM

Purchase Details

Closed on
Jan 30, 2003
Sold by
The Genesee Co Llc
Bought by
Langren Ii Donald Richard

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$322,700
Interest Rate
5.96%

Purchase Details

Closed on
Jan 24, 2002
Sold by
Bosch Land Group Llc
Bought by
The Genesee Company Llc
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
Bernstein Gary A $1,080,000 None Listed On Document
Cowden John David $715,000 Land Title Guarantee
Langren Ii Donald Richard $569,406 --
The Genesee Company Llc $127,000 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Bernstein Gary A $993,995
Closed Bernstein Gary A $1,080,000
Previous Owner Cowden John David $572,000
Previous Owner Cowden Joh David $150,212
Previous Owner Langren Ii Donald Richard $150,000
Previous Owner Langren Ii Donald Richard $375,000
Previous Owner Langren Ii Donald Richard $105,000
Previous Owner Langren Ii Donald Richard $322,700
Previous Owner Langren Ii Donald Richard $125,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
05/31/2024 05/31/24 Sold $1,080,000 -3.1% $251 / Sq Ft
04/11/2024 04/11/24 For Sale $1,115,000 +55.9% $260 / Sq Ft
05/31/2019 05/31/19 Off Market $715,000 -- --
03/02/2018 03/02/18 Sold $715,000 -1.5% $158 / Sq Ft
01/31/2018 01/31/18 Pending -- -- --
12/06/2017 12/06/17 For Sale $726,000 -- $160 / 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 $6,066 $61,650 $9,781 $51,869
2024 $6,066 $61,650 $9,781 $51,869
2023 $5,983 $63,416 $10,707 $56,394
2022 $5,113 $51,667 $7,965 $43,702
2021 $5,179 $53,153 $8,194 $44,959
2020 $4,938 $50,830 $7,651 $43,179
2019 $4,860 $50,830 $7,651 $43,179
2018 $4,532 $47,714 $8,064 $39,650
2017 $4,471 $52,751 $8,915 $43,836
2016 $4,449 $46,543 $10,826 $35,717
2015 $4,239 $39,657 $9,393 $30,264
2014 $3,691 $39,657 $9,393 $30,264
Source: Public Records

Agents Affiliated with this Home

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

Map

Source: IRES MLS

MLS Number: 1006823

IRES MLS

APN: 1205254-10-015