Redefining the modern ranch, this down-to-the-studs transformation in the Farm at Creekside offers a rare level of architectural precision. Set on a quiet, low-traffic street, this fully reimagined home features a reconfigured layout and elevated finishes that stand apart. Inside, museum-quality Level 5 smooth walls and 8-inch wide-plank white oak floors create a refined foundation. Interior door openings have been raised to 8 feet and paired with 9-foot ceilings, enhancing light, flow, and overall scale. Andersen casement windows and atrium doors seamlessly connect indoor and outdoor living, opening to beautifully landscaped grounds, a custom paver deck, and covered porches. The outside delivers a private oasis complete with a hot tub. The main living area centers around a stunning vaulted living room with a stone fireplace, flowing effortlessly into a showpiece chef's kitchen with Caesarstone quartz countertops and premium Bosch appliances. The primary suite offers a true retreat with a spa-inspired curbless shower. The expansive finished basement mirrors the quality above, with polished concrete floors, 9-foot ceilings, a second primary suite with ensuite bath, and a versatile space ideal for a high-end home gym or recreation area. The 3 car oversized garage features an epoxy floor. Ideally located with direct access to the LoBo Trail and close to highly rated Niwot High School. This is the lifestyle you've been waiting for-a rare combination of custom ranch character and modern architectural excellence. Schedule your private tour today.
Electric Range, Double Oven, Dishwasher, Microwave, Disposal, Fire Alarm
FIREPLACE FEATURES
Insert, Gas, Living Room
Heating
Forced Air
Cooling
Central Air, Ceiling Fan(s)
Utility Features
Natural Gas Available, Electricity Available
SEWER
Public Sewer
WATER SOURCE
City
Year Built
1995
Basement
Full, Partially Finished
FINISHED BASEMENT SIZE
1202.0
ARCHITECTURAL STYLE
Contemporary/Modern
Roof
Composition
EXTERIOR FEATURES
Sprinkler System, Balcony, Hot Tub
Parking Features
Garage Door Opener, Attached
Fence
Partial, Wood
Lot Features
House/Lot Faces NE, Paved, Curbs, Sidewalks
Garage spaces
3
CITY
Longmont
SUBDIVISION
Creekside II 2nd Flg
COUNTY
Boulder
AREA
Longmont
STATE
CO
COMMUNITY FEATURES
Park
HOA
1
TAX AMOUNT
5439.0
HOA FEE
100.0
HOA FREQUENCY
Annually
LATEST UPDATE
2026-05-08T19:11:27.612Z
DAYS ON MARKET
3
PRICE CHANGE(S)
$950,000 May 5, 2026
Property Details
Property TypeResidential
StatusActive Under Contract
Bedrooms4
Bathrooms (Full)2
Property Sub TypeSingle Family Residence
Square Feet3,150
MLS #1058212
Bathrooms (¾)1
AppliancesElectric Range, Double Oven, Dishwasher, Microwave, Disposal, Fire Alarm
FIREPLACE FEATURESInsert, Gas, Living Room
HeatingForced Air
CoolingCentral Air, Ceiling Fan(s)
Utility FeaturesNatural Gas Available, Electricity Available
SEWERPublic Sewer
WATER SOURCECity
Year Built1995
BasementFull, Partially Finished
FINISHED BASEMENT SIZE1202.0
ARCHITECTURAL STYLEContemporary/Modern
RoofComposition
EXTERIOR FEATURESSprinkler System, Balcony, Hot Tub
Parking FeaturesGarage Door Opener, Attached
FencePartial, Wood
Lot FeaturesHouse/Lot Faces NE, Paved, Curbs, Sidewalks
Garage spaces3
CITYLongmont
SUBDIVISIONCreekside II 2nd Flg
COUNTYBoulder
AREALongmont
STATECO
COMMUNITY FEATURESPark
HOA1
TAX AMOUNT5439.0
HOA FEE100.0
HOA FREQUENCYAnnually
LATEST UPDATE2026-05-08T19:11:27.612Z
DAYS ON MARKET3
PRICE CHANGE(S)
$950,000 May 5, 2026
Market Trends
New Properties On Market
124
48%
Increase In New Listings
Average Asking Price
$688,599
$62,996 Decrease In Avg Asking Price
Average Asking Price / Sq. Ft.
$251
$14 Increase In List Price/Sq. Ft.
Average Days On Market
8
22 Day
Decrease In Days On Market
Data as of Jun 03, 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.