970.222.1020
 | 
Login Account
 | 
Sign Up
Home » Real Estate » CO » Broomfield » 80023 » 451 W 152nd Ave, Broomfield, CO, 80023
$1,500,000

451 W 152nd Ave, Broomfield, CO, 80023

5 Beds
5 Baths
3,627 Square Feet
Welcome to your dream ranch-style home set on a fully fenced 2.6 acre oasis, perfect for Colorado living! Step inside to find wide plank white oak interior flooring, custom millwork, hand-hewn Douglas fir beams and vaulted ceilings, all providing a grand, airy atmosphere. The main level features a luxurious primary suite with direct access to a cedar-timbered covered patio, perfect for morning coffee or evening relaxation. The gourmet kitchen is equipped with butler's pantry and custom Alderwood cabinetry. Three additional main level bedrooms include one ensuite, plus an extra full bath. Venture to the basement to find two more bedrooms, full bath, and spacious family room, ideal for entertainment or relaxation. The garage is a dream! Usable as parking and entertainment, it includes zero-maintenance, cedar plank insulated walls, heat/air conditioning, light and bright windows, custom cabinetry, app controlled wall mount garage doors, additional refrigerator, and a 3/4 bath. A phenomenal gathering spot year round! Outdoor or equestrian enthusiasts will love the expansive, fully fenced property and pasture. The incredible 36x48 multi-purpose pole barn was custom built/permitted with 2 large box stalls, tack room, wash bay, garage, 100 bale hay loft, water hydrant, horse waterer, sliding gates, dog door and kennel area, large chicken coop and workshop with dust collection system, cabinetry and additional storage and entertainment areas. Escape to the charming 12x16 cottage-like garden shed, built like a home with 2x6 insulated walls and ceiling, cedar beams, hemlock paneling and skylights. The exterior showcases custom, vertical western red cedar siding, cedar shingles on gable ends, new gutters, and impact-resistant roof shingles (2024). Two concrete patios w/cedar timber-framed covers, new metal roofs and circle sawn ghost wood spruce paneling. Experience the ultimate in luxury, space, and outdoor lifestyle in this one-of-a-kind Colorado home!
Offered By
Jamie Patrick jamie@teampatrick.co,720-443-2887, Compass - Denver

Property Details

Property Type Residential
Status Pending
Bedrooms 5
Bathrooms (Full) 3
Property Sub Type Residential-Detached
Square Feet 3,627
MLS # 3035938
Bathrooms (¾) 2

Market Trends

New Properties On Market
39
144% Increase In New Listings
Average Asking Price
$1,301,748
$289,153 Increase In Avg Asking Price
Average Asking Price / Sq. Ft.
$313
$14 Increase In List Price/Sq. Ft.
Average Days On Market
21
15 Day Decrease In Days On Market
Data as of Apr 21, 2025. Remaining statistics above are calculated on activity within the period from Feb 01, 2025 to Mar 31, 2025.

Mortgage Calculator
The information provided by this calculator is for illustrative purposes only and accuracy is not guaranteed. The values and figures shown are hypothetical and may not be applicable to your individual situation. Be sure to consult a financial professional prior to relying on the results. This calculator does not have the ability to pre-qualify you for any mortgage or loan program. Qualification for mortgages or loans requires additional information such as credit scores and existing debts which is not gathered in this calculator. Information such as interest rates and pricing are subject to change at any time and without notice. All information such as interest rates, taxes, insurance, monthly mortgage payments, etc. are estimates and should be used for comparison only.


Purchase Price
Loan Type
Down Payment
HOA Dues
Interest Rate
Estimated Property Taxes
Homeowner's Insurance
Private Mortgage Insurance

Similar Listings

15955 Humboldt Peak Dr, Broomfield, CO 80023 Listing Photo  1
$1,500,000
15955 Humboldt Peak Dr
Broomfield, CO
5 Beds
|
5 Baths
|
5,315 Square Feet
Offered By John Subry RE/MAX Northwest
15955 Humboldt Peak Dr, Broomfield, CO 80023 Listing Photo  1
$1,500,000
15955 Humboldt Peak Dr
Broomfield, CO
5 Beds
|
5 Baths
|
5,315 Square Feet
Offered By Pamela Subry RE/MAX Northwest Inc
16370 Graham Peak Way, Broomfield, CO 80023 Listing Photo  1
$1,450,000
16370 Graham Peak Way
Broomfield, CO
6 Beds
|
6 Baths
|
6,424 Square Feet
Offered By Marco Randazzo 8z Real Estate
Information deemed reliable but not guaranteed by the MLS. 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. Data Source: Information and Real Estate Services, LLC. Provided for limited non-commercial use only under IRES Rules. © 2025 IRES. Property data was last updated on 4/14/2025 at 9:05 am