NOT LISTED FOR SALE

154 Sugar Beet Cir Longmont, CO 80501

Quail Neighborhood

Estimated Value: $836,000 - $876,000

5 Beds
3.5 Baths
3,640 Sq Ft
$235/Sq Ft Est. Value

Last Sold February 27, 2020

Last sale price $599,950 $165 Per Sq Ft

Est. 43% increase in value since last sale

Current estimated payment $5,221/month

83 Days on Market

Highlights

  • Under Construction
  • Open Floorplan
  • Loft
  • Niwot High School Rated A
  • Wood Flooring
  • Double Oven

About This Home

As of February 2020

The gourmet kitchen features a center island, quartz countertops, a walk-in pantry and stainless-steel appliances, including a double oven and gas cooktop. Upstairs, you'll find a central loft, three inviting bedrooms with a shared bath and an elegant master suite with a private bath and expansive walk-in closet. The finished basement adds another bedroom and bathroom, along with a generous rec room. The home also boasts a sunroom, covered patio, 3-car garage and professional landscaping.

Last Agent to Sell the Property

Todd Baker

Richmond Realty Inc Listed on: 10/30/2019

Last Buyer's Agent

Non-IRES Agent

Non-IRES

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $5,122

Year Built

  • Built in 2019 | Under Construction

Lot Details

  • 9,058 Sq Ft Lot

HOA Fees

  • $41 Monthly HOA Fees

Parking

  • 3 Car Attached Garage

Home Design

  • Wood Roof
  • Stone

Interior Spaces

  • 3,640 Sq Ft Home
  • 2-Story Property
  • Open Floorplan
  • Gas Log Fireplace
  • Great Room with Fireplace
  • Loft
  • Basement Fills Entire Space Under The House

Kitchen

  • Eat-In Kitchen
  • Double Oven
  • Microwave
  • Dishwasher
  • Kitchen Island
  • Disposal

Flooring

  • Wood
  • Carpet

Bedrooms and Bathrooms

  • 5 Bedrooms
  • Walk-In Closet
  • Primary Bathroom is a Full Bathroom

Laundry

  • Laundry on upper level
  • Washer and Dryer Hookup

Schools

  • Niwot Elementary School
  • Sunset Middle School
  • Niwot High School

Utilities

  • Forced Air Heating and Cooling System
  • Water Rights Not Included

Community Details

  • Built by Richmond American Homes
  • Harvest Junction Village Subdivision

Listing and Financial Details

  • Assessor Parcel Number R0605941

Home Details

Home Type

Single Family

Est. Annual Taxes

$5,122

Year Built

Built in 2019 | Under Construction

Lot Details

0

HOA Fees

$41 per month

Parking

3

Listing Details

  • Year Built: 2019
  • Property Sub Type: Residential-Detached
  • Prop. Type: Residential
  • Horses: No
  • Lot Size Acres: 0.21
  • Subdivision Name: Harvest Junction Village
  • Above Grade Finished Sq Ft: 2715
  • Garage Yn: Yes
  • Unit Levels: Two
  • New Construction: Yes
  • Building Stories: 2
  • Kitchen Level: Main
  • IRESDS_HasWaterRights: No
  • IRESDS_Total Sq Ft: 3640
  • Special Features: NewHome
  • Stories: 2

Interior Features

  • Possible Use: Single Family
  • Private Spa: No
  • Appliances: Double Oven, Dishwasher, Refrigerator, Microwave, Disposal
  • Has Basement: Full
  • Full Bathrooms: 3
  • Half Bathrooms: 1
  • Total Bedrooms: 5
  • Below Grade Sq Ft: 925
  • Fireplace Features: Gas, Gas Logs Included, Great Room
  • Fireplace: Yes
  • Interior Amenities: Eat-in Kitchen, Open Floorplan, Pantry, Walk-In Closet(s), Loft, Kitchen Island
  • Living Area: 3640
  • IRESDS_HasFamilyRoom: No
  • Master Bedroom Master Bedroom Level: Upper
  • Master Bedroom Master Bedroom Width: 15
  • Master Bedroom Features: Carpet
  • Room Kitchen Features: Wood Floor
  • Room Kitchen Area: 176
  • Room Master Bedroom Area: 240
  • Master Bathroom Features: Full Primary Bath
  • ResoLivingAreaSource: Plans

Exterior Features

  • Roof: Wood
  • Builder Name: Richmond American Homes
  • Lot Features: Gutters, Water Rights Excluded
  • Waterfront: No
  • Construction Type: Stone
  • Property Condition: Under Construction

Garage/Parking

  • Attached Garage: Yes
  • Covered Parking Spaces: 3
  • Garage Spaces: 3
  • IRESDS_GarageType: Attached

Utilities

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

Condo/Co-op/Association

  • Senior Community: No
  • Association Fee: 41
  • Association Fee Frequency: Monthly
  • Association: Yes

Association/Amenities

  • IRESDS_HasAssociationReserve: No
  • IRESDS_HasAssociationFee: Yes

Schools

  • Elementary School: Niwot
  • HighSchool: Niwot
  • Junior High Dist: ST Vrain Dist RE 1J
  • Middle Or Junior School: Sunset Middle

Lot Info

  • Zoning: Res
  • Lot Size Sq Ft: 9058
  • Parcel #: R0605941
  • ResoLotSizeUnits: SquareFeet

Tax Info

  • Tax Year: 2019
  • Tax Annual Amount: 1

Multi Family

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Oct 30, 2019
Closed on
Feb 26, 2020
Sold by
Richmond American Homes Of Colorado Inc
Bought by
Krebs Erik Michael and Krebs Lisa Rose
Seller's Agent
Todd Baker
Richmond Realty Inc
Buyer's Agent
Non-IRES Agent
Non-IRES
List Price
$642,258
Sold Price
$599,950
Premium/Discount to List
-$42,308
-6.59%
Total Days on Market
83
Current Estimated Value
$856,371

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$256,421
Avg. Annual Appreciation
6.90%
Original Mortgage
$598,401
Interest Rate
3.6%
Mortgage Type
VA
Source: Public Records

Similar Homes in Longmont, CO

  • 708 Teal Cir, Longmont, CO 80503

    $898,900

    • 6 Beds
    • 4.5 Baths
    • 3,724 Sq Ft
    • 708 Teal Cir
    • Longmont, CO

    Elegant 6-Bedroom Home in Golden Pond Estates – Backing to Greenbelt & Nature Trails Offering the best of Longmont living, this beautifully appointed 6-bedroom, 5-bathroom home is nestled in the highly desirable Golden Pond Estates. Step inside to a bright, airy, open floor plan filled with natural light. The main level features formal living and dining rooms, a private office, and a spacious

    Patrice Winans Coldwell Banker Realty - NoCo

    Section Image
  • 286 Western Sky Cir, Longmont, CO 80501

    $845,000

    • 5 Beds
    • 3.5 Baths
    • 4,268 Sq Ft
    • 286 Western Sky Cir
    • Longmont, CO

    Beautiful 5-bedroom, 4-bath home on a premium corner lot in Harvest Junction! Built in 2019, this move-in-ready gem features an open layout with hardwood floors, vaulted ceilings, and sun-filled spaces. The gourmet kitchen includes quartz counters, maple cabinets, GE fridge/freezer, gas cooktop, double ovens, and a large center island. Sunroom-style dining area flows off the kitchen for a light

    Deborah Fowler Slifer Smith & Frampton-Niwot

    Section Image
  • 1016 Katy Ln, Longmont, CO 80504

    $850,000

    • 3 Beds
    • 3.5 Baths
    • 2,160 Sq Ft
    • 1016 Katy Ln
    • Longmont, CO

    Nestled in the heart of highly desirable Prospect New Town, this stunning home is surrounded by tree-lined streets, parks, and a vibrant mix of restaurants, cafes, and boutiques. Known for its welcoming atmosphere and unique charm, this neighborhood offers an unparalleled blend of community and convenience.From the moment you arrive, you'll be captivated by the home's inviting pergola and

    Zana Leiferman Real Realty Colorado

    Section Image
  • 517 Rider Ridge Dr, Longmont, CO 80504

    $650,000

    • 3 Beds
    • 3.5 Baths
    • 3,020 Sq Ft
    • 517 Rider Ridge Dr
    • Longmont, CO

    This spacious Longmont home in the lovely Rider Ridge neighborhood offers perfect one level living. Step into the large, open living room, featuring a cozy fireplace and expansive windows that flood the space with natural light. The kitchen is outfitted with stainless steel appliances, granite counters and includes a charming breakfast nook, while the formal dining room provides an ideal setting

    Carly Mayer Compass Colorado, LLC - Boulder

    Section Image
  • 4236 Frederick Cir, Longmont, CO 80503

    $939,900

    • 5 Beds
    • 4 Baths
    • 3,636 Sq Ft
    • 4236 Frederick Cir
    • Longmont, CO

    OPEN HOUSE Sun 6/1 2-4 pm Stunning 2-Story Home in Prime Longmont Location - Backing to Green Space! Welcome to this beautifully maintained and thoughtfully upgraded 2-story home, ideally located on a corner lot backing to peaceful green space-just minutes from Longmont's top-rated schools, shopping, dining, and entertainment.Step inside to discover a warm and inviting main level featuring

    April Neuhaus Neuhaus Real Estate Inc

    Section Image
  • 5017 Bella Vista Dr, Longmont, CO 80503

    $895,000

    • 5 Beds
    • 3.5 Baths
    • 4,332 Sq Ft
    • 5017 Bella Vista Dr
    • Longmont, CO

    Welcome to this beautifully maintained home nestled in the sought-after Renaissance neighborhood of southwest Longmont. From the moment you step into the grand foyer, you'll be impressed by the sweeping staircase and gleaming cherry hardwood floors that flow into the heart of the home. The spacious kitchen is a chef’s dream, offering abundant cherry cabinetry, generous counter space, and natural

    Carly Mayer Compass Colorado, LLC - Boulder

    Section Image
  • 1321 Ruby Way, Longmont, CO 80504

    $1,050,000

    • 5 Beds
    • 4.5 Baths
    • 4,455 Sq Ft
    • 1321 Ruby Way
    • Longmont, CO

    This is the kind of home that takes your breath away the moment you arrive. The driveway curves gently through vibrant landscaping and beneath a canopy of towering trees—offering a sense of calm before you even step inside. Warmth and welcome define every corner. From the grand entry to the soft glow of the fireplace, this home invites you to slow down and savor the everyday moments—morning

    Charles Odenz Keller Williams DTC

    Section Image
  • 2240 Summitview Dr, Longmont, CO 80504

    $1,030,000

    • 5 Beds
    • 3.5 Baths
    • 4,008 Sq Ft
    • 2240 Summitview Dr
    • Longmont, CO

    Welcome to 2240 Summitview Drive, a one-owner gem nestled in Longmont’s sought-after Creekside neighborhood. This spacious 5-bedroom, 4-bathroom home offers over 4,000 square feet of living space, including a finished basement and a versatile layout ideal for everyday living and entertaining. The main floor features vaulted ceilings, hardwood floors, a cozy fireplace, a bright, open kitchen with

    Danielle Lambert Engel & Volkers Denver

    Section Image
  • 2215 Parkview Dr, Longmont, CO 80504

    $1,030,000

    • 4 Beds
    • 3.5 Baths
    • 3,371 Sq Ft
    • 2215 Parkview Dr
    • Longmont, CO

    Rare Opportunity in Sought-After Creekside Neighborhood!Welcome to this exceptional one-owner home nestled on a generous -acre lot in the highly desirable Creekside Neighborhood. This is the largest model built by Genessee Homes, a respected semi-custom home builder known for quality and thoughtful design.Located in the prestigious Niwot High School district, offering access to the renowned

    Chris Martinez RE/MAX Alliance-Longmont

    Section Image
See All Homes in Longmont

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
Krebs Erik Michael $585,000 None Available
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Krebs Erik Michael $600,055
Closed Krebs Erik Michael $598,401
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
06/02/2020 06/02/20 Off Market $599,950 -- --
02/27/2020 02/27/20 Sold $599,950 +2.6% $165 / Sq Ft
01/17/2020 01/17/20 Price Changed $584,950 -14.9% $161 / Sq Ft
01/14/2020 01/14/20 Price Changed $687,173 +0.1% $189 / Sq Ft
12/20/2019 12/20/19 Price Changed $686,707 +0.7% $189 / Sq Ft
12/16/2019 12/16/19 Price Changed $682,157 -0.1% $187 / Sq Ft
12/10/2019 12/10/19 Price Changed $682,956 0.0% $188 / Sq Ft
12/06/2019 12/06/19 Price Changed $682,809 -0.1% $188 / Sq Ft
12/03/2019 12/03/19 Price Changed $683,408 -0.1% $188 / Sq Ft
11/01/2019 11/01/19 Price Changed $683,867 +6.5% $188 / Sq Ft
10/30/2019 10/30/19 For Sale $642,258 -- $176 / 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 $5,122 $53,200 $8,575 $44,625
2024 $5,122 $53,200 $8,575 $44,625
2023 $5,052 $53,546 $9,434 $47,798
2022 $4,449 $44,959 $7,304 $37,655
2021 $4,507 $46,254 $7,515 $38,739
2020 $3,953 $40,691 $6,078 $34,613
2019 $1,774 $18,560 $18,560 $0
2018 $647 $6,815 $6,815 $0
2017 $598 $6,380 $6,380 $0
2016 $721 $0 $0 $0
Source: Public Records

Agents Affiliated with this Home

  • T

    Seller's Agent in 2020

    Todd Baker

    Richmond Realty Inc

    (970) 360-6449

    5 in this area

    2,484 Total Sales

    Section Image

  • N

    Buyer's Agent in 2020

    Non-IRES Agent

    CO_IRES

See All Agents

Map

Source: IRES MLS

MLS Number: 897947

IRES MLS

APN: 1315113-07-001

Colorado Boulder County Longmont 80501 Quail

154 Sugar Beet Cir, Longmont, CO

This home is located at 154 Sugar Beet Cir, Longmont, CO 80501 since 30 October 2019 and is currently estimated at $856,371, approximately $235 per square foot. This property was built in 2019. 154 Sugar Beet Cir is a home located in Boulder County with nearby schools including Burlington Elementary School, Sunset Middle School, and Niwot High 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