If you have been hoping to find a truly unique home in Longmont, the wait is over. The inspiration begins as you walk up the stamped concrete driveway to this European Manor style home with mature trees and landscaping, located near Union Reservoir in the Sugarmill Farms subdivision. Inside, you will find plenty of space for everything you want to do, with a spacious living room, formal dining room, breakfast nook, open kitchen, and multiple flex spaces for home office or hobbies, all before you even leave the main floor. Head upstairs to find the primary suite with a five-piece bathroom and walk-in closet, plus two more bedrooms and additional flex room for your maker space, reading room, yoga retreat, or meditation sanctuary. Downstairs is an additional living space with a recreation room and three more bedrooms, perfect for guests or anyone else that needs their own space. Every level has its own outdoor patio or deck, with peek-a-boo views towards the mountains. Once you step inside, this home just keeps going, so take your time to explore and envision all your hobbies and interests having their own space. The only limit to what you can do here is your own imagination.
Lot FeaturesEvergreen Trees, Deciduous Trees, Sloping Lot, House Faces East, City Limits, Paved, Curbs, Gutters, Sidewalks, Street Light
Garage spaces2
ViewHills
CITYLongmont
SUBDIVISIONRider Ridge Farm Filing 3
COUNTYBoulder
AREALongmont
STATECO
HOA1
TAX AMOUNT5691.0
HOA FEE43.0
HOA FREQUENCYQuarterly
LATEST UPDATE2026-05-18T09:21:52.992Z
DAYS ON MARKET6
PRICE CHANGE(S)
$860,000 May 17, 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.