Custom modern farmhouse on coveted Juniper Avenue in North Boulder. Oversized, professionally landscaped lot equal distance to Ideal Market Plaza and Wonderland Lake/Lucky's Market. Home features an open floor plan with a gourmet kitchen, luxury master suite, 4 bedrooms up, covered patio and fully finished basement. Great for entertaining with a thoughtful indoor/outdoor design and just steps to Mt. Sanitas and Boulder Open Space trails.
Utility FeaturesNatural Gas Available, Electricity Available
SEWERPublic Sewer
WATER SOURCECity
Year Built2017
BasementPartially Finished
FINISHED BASEMENT SIZE1999.0
ARCHITECTURAL STYLEContemporary/Modern
RoofComposition
EXTERIOR FEATURESSprinkler System
FenceFenced
Garage spaces2
ViewHills
CITYBoulder
SUBDIVISIONFoothills
COUNTYBoulder
AREABoulder
STATECO
TAX AMOUNT13154.0
LATEST UPDATE2026-01-23T13:55:37.568Z
PRICE CHANGE(S)
$3,700,000 Oct 21, 2025
Market Trends
New Properties On Market
58
13%
Decrease In New Listings
Average Asking Price
$2,477,756
$120,643 Decrease In Avg Asking Price
Average Asking Price / Sq. Ft.
$939
$178 Increase In List Price/Sq. Ft.
Average Days On Market
7
25 Day
Decrease In Days On Market
Data as of Jun 04, 2026.
Remaining statistics above are calculated on activity within the period from Apr 01, 2026 to May 31, 2026.
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.