Exceptional craftsmanship defines every detail of this 5-bedroom, 6-bath estate on over two acres with sweeping views of the mountains and Continental Divide. The gourmet kitchen features a butler's pantry with sink, wine cooler, and warming drawer-ideal for entertaining. A basement wine cellar with tasting area completes the experience. The primary suite offers a private deck, expansive walk-in closet, and six-piece luxury bath with steam shower, jetted tub, and bidet. Outdoors, the professionally landscaped grounds include an outdoor kitchen and fireplace, swim spa, gazebo, and small barn. Mature fruit trees and extensive plantings are irrigated by a groundwater catchment system. Horses welcome (2 permitted). A bonus room above the heated four-car garage provides flexible space for a home office, gym, or studio. Minutes to Niwot, Longmont, Boulder Country Club, and Boulder.
Gas Range, Down Draft, Double Oven, Dishwasher, Refrigerator, Bar Fridge, Washer, Dryer, Microwave, Freezer, Disposal, Fire Alarm
BATH FEATURES
Bath
FIREPLACE FEATURES
Gas, Great Room
Heating
Zoned, 2 or more Heat Sources, Humidity Control, 2 or more H20 Heaters
Cooling
Central Air
Utility Features
Natural Gas Available, Electricity Available, Cable Available, Satellite Avail, High Speed Avail, Underground Utilities
SEWER
Septic Tank
WATER SOURCE
District
Year Built
2000
Builder Name
Phillips Custom Construct
Basement
Full, Unfinished, Sump Pump
FINISHED BASEMENT SIZE
2522.0
ARCHITECTURAL STYLE
Contemporary/Modern
Roof
Tile
EXTERIOR FEATURES
Sprinkler System, Balcony, Hot Tub, Heated Garage, Oversized Garage
Parking Features
Garage Door Opener, RV Access/Parking, Attached
Fence
Partial, Wood
Lot Features
Level, Abuts Ditch, Outbuildings, House Faces West, Unincorporated, Paved, Fire Hydrant within 500 Feet
Garage spaces
4
Other Structures
Storage
View
Mountain(s), Hills
CITY
Longmont
SUBDIVISION
Ranch At Clover Basin Nupud
COUNTY
Boulder
AREA
Suburban Plains
STATE
CO
HOA
1
TAX AMOUNT
19091.0
HOA FEE
300.0
HOA FREQUENCY
Annually
LATEST UPDATE
2026-03-24T22:02:17.565Z
PRICE CHANGE(S)
$2,500,000 Mar 24, 2026
Property Details
Property TypeResidential
StatusComing Soon
Bedrooms5
Bathrooms (Full)4
Property Sub TypeMixed Use
Square Feet8,072
MLS #1054590
Bathrooms (Half)2
FlooringWood
AppliancesGas Range, Down Draft, Double Oven, Dishwasher, Refrigerator, Bar Fridge, Washer, Dryer, Microwave, Freezer, Disposal, Fire Alarm
BATH FEATURESBath
FIREPLACE FEATURESGas, Great Room
HeatingZoned, 2 or more Heat Sources, Humidity Control, 2 or more H20 Heaters
CoolingCentral Air
Utility FeaturesNatural Gas Available, Electricity Available, Cable Available, Satellite Avail, High Speed Avail, Underground Utilities
SEWERSeptic Tank
WATER SOURCEDistrict
Year Built2000
Builder NamePhillips Custom Construct
BasementFull, Unfinished, Sump Pump
FINISHED BASEMENT SIZE2522.0
ARCHITECTURAL STYLEContemporary/Modern
RoofTile
EXTERIOR FEATURESSprinkler System, Balcony, Hot Tub, Heated Garage, Oversized Garage
Parking FeaturesGarage Door Opener, RV Access/Parking, Attached
FencePartial, Wood
Lot FeaturesLevel, Abuts Ditch, Outbuildings, House Faces West, Unincorporated, Paved, Fire Hydrant within 500 Feet
Garage spaces4
Other StructuresStorage
ViewMountain(s), Hills
CITYLongmont
SUBDIVISIONRanch At Clover Basin Nupud
COUNTYBoulder
AREASuburban Plains
STATECO
HOA1
TAX AMOUNT19091.0
HOA FEE300.0
HOA FREQUENCYAnnually
LATEST UPDATE2026-03-24T22:02:17.565Z
PRICE CHANGE(S)
$2,500,000 Mar 24, 2026
Market Trends
New Properties On Market
54
69%
Increase In New Listings
Average Asking Price
$1,202,691
$177,884 Increase In Avg Asking Price
Average Asking Price / Sq. Ft.
$383
$26 Increase In List Price/Sq. Ft.
Average Days On Market
19
32 Day
Decrease In Days On Market
Data as of Mar 25, 2026.
Remaining statistics above are calculated on activity within the period from Jan 01, 2026 to Feb 28, 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.