NOT LISTED FOR SALE

1821 Celestial Ln Longmont, CO 80504

East Side Neighborhood

Estimated Value: $605,000 - $706,448

4 Beds
3 Baths
3,137 Sq Ft
$212/Sq Ft Est. Value

Sale Details

Date Sold: March 27, 2019

Last sale price $474,900 $151 Per Sq Ft

Est. 40% increase in value since last sale

Current estimated payment $3,936 / mo

6 Days on Market

Highlights

  • Open Floorplan
  • Mountain View
  • Wood Flooring
  • Fall River Elementary School Rated A-
  • Contemporary Architecture
  • 3-minute walk to Stephen Day Park

About This Home

As of March 2019

Great house in coveted Shadow Grass Park! Built with tons of upgrades on premium lot in 2015, this is the one! Features pre-wiring for 5.1 stereo speakers, security system & satellite systems when built. Immaculate main floor wood flooring, quartz countertops, kitchen island, maple chiffron cabinetry, gas fireplace/mantle, "in-law qtrs" on main level, oversized 2 car garage, unfinished basement, SW facing covered, drip lines run throughout back yard. Spec sheet attached for further info.

Last Agent to Sell the Property

Todden Goad

Sellstate Altitude Property Group License #100001700 Listed on: 02/14/2019

Sellstate Altitude Property Group

Last Buyer's Agent

Jennifer Lea

Legacy Real Estate Group License #100066104

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $3,136

Year Built

  • Built in 2015

Lot Details

  • 8,770 Sq Ft Lot
  • Open Space
  • Cul-De-Sac
  • Vinyl Fence
  • Lot Has A Rolling Slope
  • Sprinkler System

HOA Fees

  • $50 Monthly HOA Fees

Parking

  • 2 Car Attached Garage
  • Oversized Parking

Home Design

  • Contemporary Architecture
  • Brick Veneer
  • Wood Frame Construction
  • Composition Roof
  • Composition Shingle

Interior Spaces

  • 3,137 Sq Ft Home
  • 2-Story Property
  • Open Floorplan
  • Gas Fireplace
  • Window Treatments
  • Bay Window
  • Dining Room
  • Mountain Views
  • Radon Detector

Kitchen

  • Gas Oven or Range
  • Microwave
  • Dishwasher
  • Kitchen Island
  • Disposal

Flooring

  • Wood
  • Carpet

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Walk-In Closet
  • Primary Bathroom is a Full Bathroom
  • In-Law or Guest Suite

Laundry

  • Laundry on upper level
  • Dryer
  • Washer

Basement

  • Basement Fills Entire Space Under The House
  • Sump Pump

Outdoor Features

  • Patio
  • Exterior Lighting

Schools

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

Utilities

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

Community Details

  • Association fees include common amenities, trash, snow removal, security, management
  • Built by Ryland
  • Shadow Grass Subdivision

Listing and Financial Details

  • Assessor Parcel Number R0604162

Home Details

Home Type

Single Family

Est. Annual Taxes

$3,136

Year Built

Built in 2015

Lot Details

8,770 Sq Ft Lot

HOA Fees

$50 per month

Parking

2

Listing Details

  • Year Built: 2015
  • Property Sub Type: Residential-Detached
  • Prop. Type: Residential
  • Horses: No
  • Lot Size Acres: 0.2
  • Road Frontage Type: City Street
  • Road Surface Type: Paved, Asphalt
  • Subdivision Name: Shadow Grass
  • Directions: Use GPS app. Property is off of 17th Ave and County Line Rd.
  • Architectural Style: Contemporary/Modern
  • Garage Yn: Yes
  • Unit Levels: Two
  • New Construction: No
  • Building Stories: 2
  • Kitchen Level: Main
  • IRESDS_HasWaterRights: No
  • IRESDS_Total Sq Ft: 3137
  • Special Features: None
  • Stories: 2

Interior Features

  • Possible Use: Single Family
  • Private Spa: No
  • Appliances: Gas Range/Oven, Dishwasher, Washer, Dryer, Microwave, Disposal
  • Has Basement: Full, Built-In Radon, Sump Pump
  • Full Bathrooms: 2
  • Three Quarter Bathrooms: 1
  • Total Bedrooms: 4
  • Fireplace Features: Gas
  • Fireplace: Yes
  • Flooring: Wood Floors
  • Interior Amenities: In-Law Floorplan, Satellite Avail, High Speed Internet, Separate Dining Room, Open Floorplan, Pantry, Walk-In Closet(s), Kitchen Island
  • Window Features: Window Coverings, Bay Window(s)
  • Room Bedroom3 Features: Carpet
  • Dining Room Features: Wood Floor
  • IRESDS_HasFamilyRoom: No
  • Room Bedroom4 Level: Lower
  • Living Room Living Room Level: Main
  • Room Bedroom4 Features: Carpet
  • Master Bedroom Master Bedroom Level: Upper
  • Room Bedroom3 Level: Upper
  • Room Bedroom2 Level: Upper
  • Room Bedroom2 Features: Carpet
  • Master Bedroom Features: Carpet
  • Room Kitchen Features: Wood Floor
  • Living Room Features: Wood Floor
  • Dining Room Dining Room Level: Main
  • Master Bathroom Features: Full Primary Bath, 5 Piece Primary Bath
  • ResoLivingAreaSource: Assessor

Exterior Features

  • Roof: Composition
  • Builder Name: Ryland
  • Fencing: Fenced, Vinyl
  • Lot Features: Curbs, Gutters, Sidewalks, Fire Hydrant within 500 Feet, Lawn Sprinkler System, Cul-De-Sac, Rolling Slope, Abuts Public Open Space, Within City Limits
  • View: Mountain(s), Foothills View
  • Waterfront: No
  • Construction Type: Wood/Frame, Brick/Brick Veneer, Composition Siding
  • 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: Oversized
  • IRESDS_GarageType: Attached

Utilities

  • Cooling: Central Air
  • Electric: Electric
  • Heating: Forced Air
  • Utilities: Natural Gas Available, Electricity Available, Cable Available
  • Laundry Features: Washer/Dryer Hookups, Upper Level
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Water Source: City Water, City of Longmont
  • Gas Company: Natural Gas

Condo/Co-op/Association

  • HOA Fee Includes: Common Amenities, Trash, Snow Removal, Security, Management
  • Senior Community: No
  • Association Fee: 50
  • Association Fee Frequency: Monthly
  • Association: Yes

Association/Amenities

  • IRESDS_HasAssociationReserve: Yes
  • IRESDS_HasAssociationFee: Yes

Schools

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

Lot Info

  • Zoning: SFR
  • Lot Size Sq Ft: 8770
  • Parcel #: R0604162
  • ResoLotSizeUnits: SquareFeet

Tax Info

  • Tax Year: 2017
  • Tax Annual Amount: 3136

Multi Family

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Feb 14, 2019
Closed on
Mar 27, 2019
Sold by
Trahan Christopher C and Trahan Heather J
Bought by
Reyes Ysmael and Vega Gina
Seller's Agent
Todden Goad
Sellstate Altitude Property Group
Buyer's Agent
Jennifer Lea
Legacy Real Estate Group
List Price
$474,900
Sold Price
$474,900
Current Estimated Value
$665,862

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$190,962
Avg. Annual Appreciation
4.88%
Original Mortgage
$250,000
Outstanding Balance
$219,794
Interest Rate
4.3%
Mortgage Type
New Conventional
Estimated Equity
$446,068

Purchase Details

Closed on
Sep 30, 2015
Sold by
The Ryland Group Inc
Bought by
Trahan Christopher

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$348,206
Interest Rate
3.97%
Mortgage Type
New Conventional
Source: Public Records

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

Purchase History

Date Buyer Sale Price Title Company
Reyes Ysmael $474,900 Stewart Title
Trahan Christopher $386,895 Ryland Title
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Reyes Ysmael $250,000
Previous Owner Trahan Christopher $348,206
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
06/24/2020 06/24/20 Off Market $474,900 -- --
03/27/2019 03/27/19 Sold $474,900 0.0% $151 / Sq Ft
02/14/2019 02/14/19 For Sale $474,900 -- $151 / Sq Ft
Source: IRES MLS

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,562 $48,394 $9,156 $39,238
2024 $4,562 $48,394 $9,156 $39,238
2023 $4,500 $47,691 $10,063 $41,312
2022 $3,904 $39,448 $7,534 $31,914
2021 $3,954 $40,584 $7,751 $32,833
2020 $3,407 $35,078 $5,792 $29,286
2019 $3,354 $35,078 $5,792 $29,286
2018 $3,179 $33,466 $5,832 $27,634
2017 $3,136 $36,998 $6,448 $30,550
2016 $2,988 $13,340 $13,340 $0
2015 $1,215 $0 $0 $0
Source: Public Records

Agents Affiliated with this Home

  • Todden Goad

    Seller's Agent in 2019

    Todden Goad

    Sellstate Altitude Property Group

    (303) 506-7357

    1 in this area

    29 Total Sales

    Todden Goad
    Section Image

  • J

    Buyer's Agent in 2019

    Jennifer Lea

    Legacy Real Estate Group

    Section Image
See All Agents

Map

Source: IRES MLS

MLS Number: IRE872326

IRES MLS

APN: 1205361-18-017

Colorado Boulder County Longmont 80504 East Side

1821 Celestial Ln, Longmont, CO

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.
Based on information submitted to the MLS GRID. All data is obtained from various sources and may not have been verified by broker or MLS GRID. Supplied Open House Information is subject to change without notice. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information. Some IDX listings have been excluded from this website. 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.
Based on information submitted to the MLS GRID
Listings courtesy of IRES MLS as distributed by MLS GRID

Nearby Homes
Your Personal Tour Guide

Ask me questions while you tour the home.