Skip main navigation
Off market
  • $3,117,100

    15042 Prairie Pl, Broomfield, CO 80023

    6beds
    6,634sqft
    SingleFamily
    Built in 2006
    2.15 Acres Lot
    $3,117,100 Zestimate®
    $470/sqft
    $6,895 Estimated rent

    Home value

    $3,117,100

    $2.87M - $3.40M

    $6,895/mo

    Zestimate® history
    Loading
    Loading...

    Owner options

    List your home for rent

    $6,895/mo

    Rent Zestimate®

    Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.

    Learn more

    $6,895/mo

    Rent Zestimate®

    Refinance and save

    $14,728/mo

    Est. payment

    Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.

    See today's rates

    $14,728/mo

    Est. payment

    Explore your selling options

    Work with a Zillow partner agent

    Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.

    Get started

    List with your own agent

    Get your home in front of millions of buyers by listing it on Zillow.

    Learn how to do it

    Sell it yourself

    Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).

    List your home

    What's special

    This stunning custom home is nestled on a private cul-de-sac within the prestigious Spruce Meadows community. Majestically angled on a breathtaking 2.15-acre homesite, this architecturally magnificent residence offers spectacular, sweeping views of the mountains. In a class by itself, the property offers a 6,634 sq. ft. main house, a 1,645 sq. ft. guest house, private outdoor pool, basketball court, barn and two oversized attached garages with six total parking spaces. Dark hardwood floors guide you through the main level, which consists of a large study with custom built-ins, formal dining room which is adorned with a coffered ceiling and an inviting family room with gas fireplace. The spacious living room with two-sided gas fireplace connects to a sitting room equipped with a wet bar. The perfectly situated gourmet kitchen will impress with granite countertops, stainless steel appliances, five burner gas cook top and sits adjacent to a sun/breakfast room. The upper level consists of the primary suite with gas fireplace, massive walk-in closet and spa-like five-piece bathroom. Three additional bedroom suites, plus two bathrooms & a loft/study with custom built- in shelving and desk round out the second floor. The lower-level walkout basement adds an additional bedroom, bathroom, exercise room, family room, wine cellar, wet bar and a generous recreation room. The separate guest house is an amazing addition that offers a lofted bedroom suite, bathroom, kitchen, family room, recreation room and study. The attached oversized three car garage is every car enthusiast's dream complete with ample work space, epoxy floors, work bench, utility sink and car lifts. The resort-style back yard is an oasis of its own - perfect for relaxing or entertaining - complete with lush landscaping, mature trees, a private deck and patio with fire pit that overlooks the sparkling outdoor pool with breathtaking mountain views. This amazing home absolutely has it all!

    This property is off market, which means it's not currently listed for sale or rent on Zillow. This may be different from what's available on other websites or public sources.

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 6
    • Bathrooms: 6
    • Full bathrooms: 2
    • 3/4 bathrooms: 3
    • 1/2 bathrooms: 1
    Heating
    • Forced air, Gas
    Cooling
    • Central
    Features
    • Basement: Partially finished
    • Has fireplace: Yes
    Interior area
    • Total interior livable area: 6,634 sqft

    Property

    Parking
    • Parking features: Garage - Attached
    Features
    • Exterior features: Stucco
    Lot
    • Size: 2.15 Acres
    Details
    • Parcel number: 157317102064

    Construction

    Type & style
    • Home type: SingleFamily
    Materials
    • Roof: Other
    Condition
    • Year built: 2006

    Community & HOA

    HOA
    • Has HOA: Yes
    • HOA fee: $43 monthly
    Location
    • Region: Broomfield

    Financial & listing details

    • Price per square foot: $470/sqft
    • Tax assessed value: $2,583,180
    • Annual tax amount: $23,865

    Price history

    DateEventPrice
    12/13/2022Sold$2,750,000-8.3%$415/sqft
    Source: Public Record Report a problem
    10/29/2022Pending sale$2,999,000$452/sqft
    Source: RE/MAX International #7293671 Report a problem
    10/3/2022Price change$2,999,000-6.3%$452/sqft
    Source: RE/MAX International #7293671 Report a problem
    8/25/2022Listed for sale$3,200,000+1354.5%$482/sqft
    Source: RE/MAX International #7293671 Report a problem
    7/14/2005Sold$220,000$33/sqft
    Source: Public Record Report a problem

    Public tax history

    YearProperty taxesTax assessment
    2025$23,865 +0.5%$173,080 -7.3%
    2024$23,748 +22.2%$186,630 -3.6%
    2023$19,430 -2.9%$193,580 +37.4%
    2022$20,011 +4.2%$140,920
    2021$19,210 0%$140,920 +6.3%
    2020$19,219 +7.8%$132,620 -0.7%
    2019$17,835 $133,540 +15.2%
    2018$17,835 +2.2%$115,910 -9.6%
    2017$17,450 +4.8%$128,150 +19.8%
    2016$16,656 -0.1%$106,950 +4.6%
    2015$16,669 +1.2%$102,210
    2014$16,475 -4.4%$102,210 -5.1%
    2013$17,241 +0.4%$107,730
    2012$17,165 -2.4%$107,730
    2011$17,591 +27%$107,730 -1.4%
    2010$13,856 +11.1%$109,210 +26.9%
    2009$12,466 $86,080
    Find assessor info on the county website

    Neighborhood: Spruce Meadows

    Nearby schools

    GreatSchools rating
    Get a cash offer in 3 minutes
    Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
    Estimated market value
    $3,117,100
    Get a cash offer in 3 minutes
    Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
    Estimated market value
    $3,117,100