Nestled in coveted North Boulder on Riverside Ave's most gracious lot, this custom built modern farmhouse offers features and amenities that most can only dream of. With direct access to Wonderland Lake, you can live everyday as if you were on an extended vacation. This architectural masterpiece generously offers functional living and entertaining space for the most discerning buyer. The magnitude of the home is accentuated by soaring ceilings, a gourmet kitchen fit for a chef and a primary suite sure to impress.
Natural Gas Available, Electricity Available, Cable Available, Satellite Avail, High Speed Avail
SEWER
Public Sewer
WATER SOURCE
City
Year Built
2021
Basement
Full, Partially Finished
FINISHED BASEMENT SIZE
1764.0
NEW CONSTRUCTION
1
ACCESSIBILITY FEATURES
1
Roof
Metal
EXTERIOR FEATURES
Sprinkler System
Fence
Fenced, Wood
Lot Features
Level
Garage spaces
2
CITY
Boulder
SUBDIVISION
Moores
COUNTY
Boulder
AREA
Boulder
STATE
CO
TAX AMOUNT
4924.0
LATEST UPDATE
2026-01-23T14:23:36.278Z
PRICE CHANGE(S)
$2,750,000 Oct 21, 2025
Property Details
Property TypeResidential
StatusClosed
Bedrooms5
Bathrooms (Full)2
Property Sub TypeSingle Family Residence
Square Feet4,771
MLS #950599
Bathrooms (¾)3
Bathrooms (Half)2
FlooringWood
AppliancesGas Range, Dishwasher, Refrigerator
FIREPLACE FEATURESLiving Room
HeatingForced Air
Utility FeaturesNatural Gas Available, Electricity Available, Cable Available, Satellite Avail, High Speed Avail
SEWERPublic Sewer
WATER SOURCECity
Year Built2021
BasementFull, Partially Finished
FINISHED BASEMENT SIZE1764.0
NEW CONSTRUCTION1
ACCESSIBILITY FEATURES1
RoofMetal
EXTERIOR FEATURESSprinkler System
FenceFenced, Wood
Lot FeaturesLevel
Garage spaces2
CITYBoulder
SUBDIVISIONMoores
COUNTYBoulder
AREABoulder
STATECO
TAX AMOUNT4924.0
LATEST UPDATE2026-01-23T14:23:36.278Z
PRICE CHANGE(S)
$2,750,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.