$1,075,000
SOLD JUN 13, 2025
6 Beds
4 Baths
4,297 Sq Ft
0.28 Acres

Recently Sold

$250 Per Sq Ft

2% Below List Price

4 Days on Market

Highlights

  • Primary Bedroom Suite
  • Open Floorplan
  • Vaulted Ceiling
  • Aspen Creek K-8 School Rated A
  • Deck
  • Wood Flooring

About This Home

As of June 2025

Welcome to 540 Columbine Avenue in Broomfield’s desirable Country Estates—an exceptional home with thoughtful upgrades and elegant finishes throughout. Inside, you'll find a formal living room with hardwood floors, crown molding, and cased windows, as well as a formal dining room with a tray ceiling. The cozy family room with a gas fireplace opens seamlessly into a chef’s dream kitchen, complete with soft-close cabinetry, quartz countertops, a Sub-Zero refrigerator, walk-in pantry, upgraded range, and a center island. A main-floor bedroom or office and a bathroom add flexibility for guests or work-from-home needs. Upstairs, the vaulted primary suite offers a tranquil retreat with a bay window/sitting area, a spa-like 5-piece bath featuring travertine, marble, a soaking tub, walk-in shower with multiple heads, and a custom walk-in closet. Three additional upstairs bedrooms share another full bath. The finished basement includes a large flex space with surround sound, two bedrooms, and a bathroom—perfect for entertaining or multi-generational living. Situated on a beautifully landscaped -acre lot, enjoy outdoor living with a redwood deck and pergola, firepit/sandpit area, and mature landscaping. Other highlights include attic fan, newer included washer/dryer, and a security system. 3-car garage and a newer garage door opener. All of this with no HOA, close to parks, trails, Hwy 36 & 287. This home truly has it all!

Last Agent to Sell the Property

Pamela Subry

RE/MAX Northwest Inc Brokerage Email: psubry@coloradohomesales.com,303-898-7783 License #040024437 Listed on: 05/08/2025

RE/MAX Northwest Inc

Co-Listed By

The Subry Group

RE/MAX Northwest Inc Brokerage Email: psubry@coloradohomesales.com,303-898-7783 License #100007015

Last Buyer's Agent

Taylor Simmons

Hatch Realty, LLC License #100057468

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $5,740

Year Built

  • Built in 1993 | Remodeled

Lot Details

  • 0.28 Acre Lot
  • Property is Fully Fenced
  • Private Yard
  • Property is zoned R-PUD

Parking

  • 3 Car Attached Garage
  • Parking Storage or Cabinetry
  • Dry Walled Garage
  • Epoxy
  • Exterior Access Door

Home Design

  • Brick Exterior Construction
  • Slab Foundation
  • Frame Construction
  • Composition Roof
  • Concrete Block And Stucco Construction

Interior Spaces

  • 2-Story Property
  • Open Floorplan
  • Vaulted Ceiling
  • Ceiling Fan
  • Gas Fireplace
  • Double Pane Windows
  • Bay Window
  • Mud Room
  • Family Room
  • Living Room
  • Dining Room
  • Home Office
  • Bonus Room
  • Attic Fan
  • Fire and Smoke Detector

Kitchen

  • Eat-In Kitchen
  • Oven
  • Cooktop
  • Microwave
  • Dishwasher
  • Quartz Countertops
  • Disposal

Flooring

  • Wood
  • Carpet
  • Tile

Bedrooms and Bathrooms

  • Primary Bedroom Suite
  • Walk-In Closet

Laundry

  • Laundry Room
  • Dryer
  • Washer

Finished Basement

  • Basement Fills Entire Space Under The House
  • Bedroom in Basement
  • 1 Bedroom in Basement

Outdoor Features

  • Deck
  • Covered patio or porch

Schools

  • Aspen Creek K-8 Elementary And Middle School
  • Broomfield High School

Utilities

  • Forced Air Heating and Cooling System
  • 220 Volts
  • 110 Volts
  • Natural Gas Connected

Community Details

  • No Home Owners Association
  • Country Estates Subdivision

Listing and Financial Details

  • Exclusions: Seller's Personal Property.
  • Assessor Parcel Number R1113816

Home Details

Home Type

Single Family

Est. Annual Taxes

$5,740

Year Built

Built in 1993 | Remodeled

Lot Details

0

Parking

3

Listing Details

  • Property Type: Residential
  • Property Sub Type: Single Family Residence
  • Structure Type: House
  • Levels: Two
  • Year Built: 1993
  • Above Grade Finished Sq Ft: 2830
  • Exclusions: Seller's Personal Property.
  • Living Area: 4297
  • Property Condition: Updated/Remodeled
  • SubdivisionName: Country Estates
  • Co List Office Mls Id: RECREM80
  • Co List Office Phone: 303-457-4800
  • Ownership: Individual
  • Property Attached Yn: No
  • REC_BasementLevelBathrooms: 1
  • REC_BasementLevelBedrooms: 1
  • REC_RVSpaces: 0
  • REC_UpperLevelBathrooms: 2
  • REC_UpperLevelBedrooms: 4
  • REC_WaterIncludedYN: 1
  • Ratio Close Price By Original Li: 0.97727
  • Attribution Contact: psubry@coloradohomesales.com,303-898-7783
  • Special Features: VirtualTour

Interior Features

  • Appliances: Cooktop, Dishwasher, Disposal, Dryer, Microwave, Oven, Refrigerator, Washer
  • Fireplaces: 1
  • Interior Amenities: Breakfast Bar, Ceiling Fan(s), Eat-in Kitchen, Five Piece Bath, High Ceilings, Open Floorplan, Pantry, Primary Suite, Quartz Counters, Vaulted Ceiling(s), Walk-In Closet(s)
  • Flooring: Carpet, Tile, Wood
  • Fireplace Features: Gas
  • Full Bathrooms: 2
  • Basement: Finished, Full
  • Basement: Yes
  • Three Quarter Bathrooms: 2
  • Total Bedrooms: 6
  • Below Grade Sq Ft: 1467
  • Main Level Bathrooms: 1
  • Main Level Bedrooms: 1
  • Window Features: Bay Window(s), Double Pane Windows

Exterior Features

  • Foundation Details: Slab
  • Roof: Composition
  • Construction Materials: Brick, Concrete, Frame
  • Exterior Features: Private Yard
  • Patio and Porch Features: Covered, Deck
  • Road Frontage Type: Public
  • Road Surface Type: Paved

Garage/Parking

  • Parking Features: Dry Walled, Exterior Access Door, Finished Garage, Floor Coating, Storage
  • Attached Garage: Yes
  • Garage Spaces: 3
  • Total Parking Spaces: 3
  • REC_ParkingCount: 1

Utilities

  • Utilities: Electricity Connected, Natural Gas Connected
  • Sewer: Public Sewer
  • Cooling: Attic Fan, Central Air
  • Heating: Forced Air
  • Water Source: Public
  • Electric: 110V, 220 Volts
  • Laundry Features: Sink, In Unit
  • Security: Smoke Detector(s)

Condo/Co-op/Association

  • Association: No
  • Senior Community: No

Association/Amenities

  • REC_AssociationFee2Annual: 0.00
  • REC_AssociationFee3Annual: 0.00
  • REC_AssociationFeeAnnual: 0.00
  • REC_AssociationFeeTotalAnnual: 0.00

Schools

  • Middle Or Junior School: Aspen Creek K-8

Lot Info

  • Parcel Number: R1113816
  • Lot Size Acres: 0.28
  • Fencing: Full
  • Building Area Total: 4297
  • Lot Size Sq Ft: 12371

Tax Info

  • Tax Year: 2024
  • Tax Annual Amount: 5740

MLS Schools

  • Elementary School: Aspen Creek K-8
  • High School: Broomfield

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
May 8, 2025
Closed on
Jun 13, 2025
Sold by
Miller Joshua and Gorham-Miller Carly
Bought by
Hoeppner Jason and Haight Jennifer
Seller's Agent
Pamela Subry
RE/MAX Northwest Inc
Buyer's Agent
Taylor Simmons
Hatch Realty, LLC
List Price
$1,100,000
Sold Price
$1,075,000
Premium/Discount to List
-$25,000
-2.27%
Views
19

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
29.51%
Original Mortgage
$806,000
Outstanding Balance
$806,000
Interest Rate
6.76%
Mortgage Type
New Conventional
Estimated Equity
$311,522

Purchase Details

Listed on
May 30, 2022
Closed on
Jun 29, 2022
Sold by
Wilkerson James W and Wilkerson Regina L
Bought by
Miller Joshua and Gorham-Miller Carly
Seller's Agent
Chad Rennich
Mountain State Realty
Buyer's Agent
Non-IRES Agent
Non-IRES
List Price
$1,075,000
Sold Price
$1,065,000
Premium/Discount to List
-$10,000
-0.93%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
0.31%
Original Mortgage
$837,000
Interest Rate
5.25%
Mortgage Type
Balloon

Purchase Details

Listed on
Oct 25, 2019
Closed on
Dec 2, 2019
Sold by
Diane L Cousins Revocable Trust
Bought by
Wilkerson James W and Wilkerson Regina L
Seller's Agent
Kelly O'brien
Compass-Denver
Buyer's Agent
Kenneth Banwart
Coldwell Banker Realty- Fort Collins
List Price
$750,000
Sold Price
$750,000

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
14.68%
Original Mortgage
$600,000
Interest Rate
3.7%
Mortgage Type
New Conventional

Purchase Details

Closed on
Nov 9, 2017
Sold by
Cousins Diane L
Bought by
Diane L Cousins Revocable Trust

Purchase Details

Closed on
Nov 28, 2016
Sold by
Cousins Thomas and Cousins Diane L
Bought by
Cousins Thomas and Cousins Diane L

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$506,000
Interest Rate
3.52%
Mortgage Type
New Conventional

Purchase Details

Closed on
Aug 12, 2003
Sold by
Cousins Diane L
Bought by
Cousins Diane L and Cousins Thomas

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$395,000
Interest Rate
4.62%
Mortgage Type
Purchase Money Mortgage

Purchase Details

Closed on
Sep 23, 2002
Sold by
Cousins Diane L
Bought by
Cousins Diane L and Cousins Thomas

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$393,000
Interest Rate
5.5%

Purchase Details

Closed on
Dec 3, 1998

Purchase Details

Closed on
Nov 2, 1995

Purchase Details

Closed on
May 6, 1993
Source: Public Records

Similar Homes in the area

  • 1196 Sunset Dr, Broomfield, CO 80020

    $913,888

    • 4 Beds
    • 2.5 Baths
    • 3,244 Sq Ft
    • 1196 Sunset Dr
    • Broomfield, CO

    Heated Driveway, Stunning Updates & a Space That Just Feels Right. At 1196 Sunset Drive, every detail has been considered - from the heated driveway that melts away winter stress to the warm, modern interiors that instantly feel like home. Step inside to soaring ceilings, rich hardwood floors, and an open layout that flows effortlessly between living, dining, and kitchen spaces. The heart of the

    Michelle Clifford Compass - Boulder

    Section Image
  • 1827 W 137th Ln, Broomfield, CO 80023

    $942,500

    • 4 Beds
    • 3.5 Baths
    • 3,227 Sq Ft
    • 1827 W 137th Ln
    • Broomfield, CO

    This is elevated living: Manhattan chic meets Colorado chill. It's city vibes in a quiet setting surrounded by nature and all the convenience and benes of Broomfield.The sprawling main level boasts a foyer, enormous mudroom and powder bath off the garage, and an uncommonly spacious living room open to the kitchen and dining nook. Step outside to the hardscaped, fully fenced, very private yard

    Joy Castillo Compass - Denver

    Section Image
  • 13971 Telluride Dr, Broomfield, CO 80020

    $1,125,000

    • 6 Beds
    • 4 Baths
    • 6,403 Sq Ft
    • 13971 Telluride Dr
    • Broomfield, CO

    Located in desirable Country Estates, this spacious home offers incredible potential for buyers ready to invest in updates. This home has the lowest price per square foot on the market! With over 6,400 sq ft and a 16,000+ sq ft lot, there's plenty of room to create your dream home. The layout features 6 bedrooms, 4 baths. The large primary suite has recently been updated to include LVP flooring,

    Lauren Haug Sweetheart City Living RE

    Section Image
  • 146 Keystone Trail, Broomfield, CO 80020

    $875,000

    • 4 Beds
    • 2.5 Baths
    • 2,467 Sq Ft
    • 146 Keystone Trail
    • Broomfield, CO

    Perfectly positioned on a quiet cul-de-sac, this beautifully cared-for home offers timeless appeal and checks every box for today’s buyer. With 4 bedrooms, 3 baths, a main floor study, plus formal and casual living spaces, it will be easy to settle in and feel right at home. Fresh paint, new carpet, and newly refinished hardwood floors give the home a crisp, updated feel—plus the peace of mind of

    Don and Kelly O'Brien Compass - Denver

    Section Image
  • 14111 Blue Stem St, Westminster, CO 80020

    $1,194,890

    • 4 Beds
    • 3.5 Baths
    • 3,620 Sq Ft
    • 14111 Blue Stem St
    • Westminster, CO

    Welcome to Boulder Creek Neighborhoods Signature line of homes, easyHouse! With thoughtful touches to make this home comfortable at every stage of life, long term livability is at the forefront of the design of our homes. Wider doors, raised outlets, no steps to outdoor living spaces, oversized curb-less showers and more are just the start of what makes an easyHouse. Inside the home you will find

    Seth Williamson WK Real Estate

    Section Image
  • 114 E 14th Ct, Broomfield, CO 80020

    $960,000

    • 6 Beds
    • 4.5 Baths
    • 4,890 Sq Ft
    • 114 E 14th Ct
    • Broomfield, CO

    Custom built in authentic Colorado-style, this updated home features five above-grade bedrooms plus architectural accents not found in production homes. Nestled in a cul de sac siding to the golf course, it is in the Boulder County school district. The wall of windows in the impressive great room overlooks the Eagle Trace golf course. It has fresh paint, new carpet and refinished hardwood

    Cathy Schuster Coldwell Banker Realty 56

    Section Image
  • 5313 Heather Ct, Broomfield, CO 80020

    $960,000

    • 5 Beds
    • 2.5 Baths
    • 2,919 Sq Ft
    • 5313 Heather Ct
    • Broomfield, CO

    Tucked into a quiet cul-de-sac in Broomfield’s coveted Aspen Creek neighborhood, 5313 Heather Court blends elegant design with scenic Colorado living. This spacious 4-bedroom, 3-bath home offers over 4,200 square feet of refined comfort, highlighted by a soaring two-story family room with a dramatic stone fireplace and walls of windows that fill the space with natural light. The gourmet kitchen

    Carol Powers Coldwell Banker Realty 14

    Section Image

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 Type Sale Price Title Company
Warranty Deed $1,075,000 Wfg National Title
Warranty Deed $1,065,000 None Listed On Document
Warranty Deed $750,000 First American
Interfamily Deed Transfer -- None Available
Interfamily Deed Transfer -- Chicago Title
Interfamily Deed Transfer -- North American Title
Interfamily Deed Transfer -- North American Title
Deed $342,500 --
Deed $249,900 --
Deed $207,400 --
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Open $806,000 New Conventional
Previous Owner $837,000 Balloon
Previous Owner $600,000 New Conventional
Previous Owner $506,000 New Conventional
Previous Owner $389,000 New Conventional
Previous Owner $393,000 New Conventional
Previous Owner $391,035 New Conventional
Previous Owner $396,550 Unknown
Previous Owner $396,550 Unknown
Previous Owner $88,000 Stand Alone Second
Previous Owner $82,000 Credit Line Revolving
Previous Owner $395,000 Purchase Money Mortgage
Previous Owner $393,000 No Value Available
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
06/13/2025 06/13/25 Sold $1,075,000 -2.3% $250 / Sq Ft
05/08/2025 05/08/25 For Sale $1,100,000 +3.3% $256 / Sq Ft
06/22/2022 06/22/22 Sold $1,065,000 -0.9% $266 / Sq Ft
06/02/2022 06/02/22 For Sale $1,075,000 +43.3% $268 / Sq Ft
03/01/2020 03/01/20 Off Market $750,000 -- --
12/02/2019 12/02/19 Sold $750,000 0.0% $190 / Sq Ft
10/25/2019 10/25/19 For Sale $750,000 -- $190 / 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 $5,740 $65,400 $15,410 $49,990
2024 $5,740 $61,260 $14,540 $46,720
2023 $5,729 $67,360 $15,990 $51,370
2022 $4,823 $49,890 $11,470 $38,420
2021 $4,798 $51,320 $11,800 $39,520
2020 $3,834 $40,760 $10,370 $30,390
2019 $3,156 $41,040 $10,440 $30,600
2018 $2,796 $36,820 $9,360 $27,460
2017 $2,753 $40,710 $10,350 $30,360
2016 $2,586 $35,380 $9,830 $25,550
2015 $3,221 $33,820 $9,830 $23,990
2014 $3,148 $33,820 $9,830 $23,990
Source: Public Records

Agents Affiliated with this Home

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

Map

Source: REcolorado®

MLS Number: 2074342

REcolorado®

APN: 1575-24-3-12-002