Sources: FBI, Uniform Crime Reports, prepared by the National Archive of Criminal Justice Data
The Brian Petrelli Team is your , Longmont home specialist.
Our team of local Longmont experts have over 200 years of combined expertise in the Colorado Real Estate market. Give us a call today to put
our knowledge and experience to work for you as you buy or sell your next home.
Don't see what you're looking for here? Contact our team for a free, custom search.
Status: active
Listing Office: equity colorado real estate
Broker Remarks:
Welcome to your dream home, where luxury meets the serenity of lakefront living. This exclusive property offers direct access to a private lake, perfect for all your favorite water activities. Whether you're into water skiing, surfing, wakeboarding, or fishing, this home is your year-round waterfront retreat. And yes—bring your boat! Step inside and be captivated by the elegance throughout. The gourmet kitchen is a chef's dream, featuring top-of-the-line appliances, exquisite finishes, and plenty of space for culinary creations. As the day winds down, bask in the breathtaking mountain sunsets ..
more...
Broker Remarks:
Nearly 40 acres in the heart of rural Boulder County! "The Creek", currently an equestrian facility. Take on existing biz for 30++ horses OR bring your 4H projects OR make it your dream estate. Property offers 2 barns with 13 stalls, loafing sheds for the rest. Indoor arena, outdoor arena, hay barn, outdoor round pen. Stalls have auto waters (Nelson) and most of the loafing sheds (Ritchie's) do as well. 2 RV hook-ups, 2 septic systems - one for barn lounge bathroom, other for the home. Home offers 4 bdrms, 3 baths; lovely kitchen with newer SS appl, granite counters, home has been set up on ..
more...
Broker Remarks:
A once-in-a-lifetime opportunity to own one of the Front Range’s most extraordinary lakefront properties. Some homes simply check boxes. Others redefine the way you live.
Tucked behind the gates of one of Longmont’s most private communities, this extraordinary lakefront estate is positioned directly on the water. Set on 5.5 curated acres, the experience begins long before you step inside. As you enter the community the noise fades.
Inside, the home immediately centers around its most defining feature: the view. Framed through the main living spaces, the lake becomes a constant presence, calm..
more...
Broker Remarks:
NEW PRICE + $400,000 in mechanical improvements - new tile roof, heating and cooling systems. Welcome to a truly one-of-a-kind property, inside and out. Upon entrance through the gate, a tree-lined drive sets the tone—its canopy lush and vibrant in both summer and fall. The circular driveway makes the arrival all the more elegant. As you approach, you’ll also notice the fantastic mountain vistas and serenity this property offers. Sitting on just over five acres, this custom-built home, designed by renowned architect Kyle Callahan, is truly elegant, with an emphasis on nature. Expansive windows..
more...
Broker Remarks:
This stunning equestrian estate is newly remodeled and completely updated! On over 11 acres of breathtaking Colorado acreage, this stunning home sits along the St. Vrain River with expansive Front Range Mountain Views. This premier estate offers an unparalleled blend of sophisticated comfort and equestrian amenities while still being close to conveniences and community.
The 8,655 sq ft residence features 5 bedrooms, each with a mountain-view balcony, 4 bathrooms, and expansive living spaces. The gourmet kitchen is a chef’s dream with professional-quality stainless steel appliances, custom ra..
more...
Status: active
Listing Office: the agency - boulder
Broker Remarks:
Welcome to a rare fusion of modern European elegance and Colorado farmland serenity. Set on 22 sweeping acres with 10 Class A Shares of Boulder White Rock Ditch, this 2023-built estate delivers a lifestyle as dynamic as it is luxurious. Every detail has been crafted for impact-from the dramatic Austin white stone wall with its now-iconic mantel to the soaring great room where 24-foot panoramic glass doors dissolve into a horizon-wide view of the Rockies. Inside, the home strikes a perfect balance of sophistication and comfort. Four spacious bedrooms, six spa-inspired baths, and playful built-i..
more...
Broker Remarks:
Perched at the highest point in Niwot Hills, 6689 Asher Court was designed around one idea: that where you live should feel like the best decision you've ever made. Every morning, Longs Peak fills your windows. Every evening, the Northern Front Range turns gold. The circular driveway and natural stone facade are just the beginning. Inside, 7,566 square feet unfold with the kind of quiet confidence that doesn't need to announce itself. Five ensuite bedrooms. Soaring 12-foot ceilings. A vaulted great room with oversized nano doors that dissolve the line between inside and out, opening to over 2,..
more...
Broker Remarks:
Escape from it all on this peaceful 38-acre Boulder County property featuring a four-bedroom, three-bathroom home, incredible views, lush scenery, a spring-fed pond, 30 shares of Left Hand Ditch, and multiple outbuildings ready to accommodate a variety of uses. Located just 20 minutes from Longmont amenities and Boulder attractions, this is the perfect farm getaway. The sunny 2,924-square-foot residence welcomes relaxing living and entertaining with kitchens and living areas on both levels. On the main floor, an inviting covered porch opens to a spacious open living and dining room wrapped in ..
more...
Broker Remarks:
Experience the perfect blend of rustic charm and modern luxury in this stunning farmhouse-style estate, situated on just over 9 acres of picturesque land. Located just a 10-minute drive from the heart of Boulder, this property offers a rare opportunity to enjoy country living with convenient city access. Each bedroom in this 5BD, 5BA home has its own bathroom, and the renovated walk-out lower level is designed for entertaining with a wet bar and spacious rec area. The main level is anchored by a cozy wood-burning fireplace, while the resort-style backyard is unmatched-featuring a saltwater poo..
more...
Broker Remarks:
Original Owners of this magnificent 35-acre irrigated property with custom built home are now selling for the first time. The moment you approach the entrance to the property you are greeted by an iron security gate and a 900-foot-long driveway with large trees to the right while drawing your attention to the picturesque brick home with the foothills behind. The setting is magical with a majestic backdrop of Longs Peak, the foothills and the surrounding well cared for properties. With a slight breeze the hay fields wave like water while growing up to 4 feet creating a living landscape. So much..
more...
Broker Remarks:
Seeking your dream ranch property with close-to-town access, extensive water rights and room for animals? Look no further than this expansive 28.6-acre Boulder County, Colorado, property just 15 minutes from Downtown Boulder. Surrounded by huge foothills views, this special ranch destination invites you to move right in and enjoy the existing brick single-level home, featuring an open layout, spacious living and dining room, nicely appointed kitchen, three oversized bedrooms and an attached garage. Or, plan your ideal farmhouse showplace in this beautifully located, completely flat lot. Curren..
more...
Status: active
Listing Office: coldwell banker realty 56
Broker Remarks:
A rare opportunity to embrace the lakefront lifestyle on the coveted shores of Gaynor Lake. Surrounded by breathtaking natural beauty and framed by unobstructed views of Longs Peak and Mount Meeker, this remarkable waterfront retreat offers a setting where every day feels like a getaway.
Designed to celebrate its extraordinary surroundings, the 6-bedroom, 7-bathroom residence is filled with natural light and captures stunning lake and mountain vistas from nearly every room. Expansive windows create a seamless connection between the indoors and the ever-changing beauty beyond, whether it's a..
more...
Status: active
Listing Office: coldwell banker realty-noco
Broker Remarks:
Set on 56 acres, this exceptional property is being offered for sale for the first time ever-a rare five-generation farmstead rich in history, productivity, and opportunity. Nestled near the foothills, the land boasts beautiful mountain views, irrigated and highly productive hay ground, and well-maintained pasture, making it ideal for a wide range of agricultural or livestock operations. The property includes 1.75 shares of Palmerton Water, a 2.5-acre lake, and No Conservation Easement, offering valuable flexibility for future use. Improvements are extensive and thoughtfully laid out, featurin..
more...
Status: active
Listing Office: coldwell banker realty-boulder
Broker Remarks:
Experience the pinnacle of luxury ranch and tranquility in this completely private mountain view home on over 35 acres, backing to open space. Nestled at the end of a long, circular drive this sanctuary ensures maximum privacy and amenities galore. Enjoy pickleball in your recently installed private court. The sparkling saltwater pool is heated. A welcoming wraparound porch greets your arrival. The sophisticated home offers skylights for an abundance of natural light. French doors lead to a secluded home office. The open floor plan guides you to the kitchen and living area, boasting stunning 3..
more...
Broker Remarks:
A gated, Chanticleer pear tree-lined driveway opens onto 10 acres sustained by decreed water rights in Gifford Gulch (with a perennial stream flow), feeding a private 1/4-acre pond, 500 mature trees, and over 7 acres of irrigated lawn. All irrigation is managed by a professional-grade app-controlled Rainbird system. The property abuts 60 acres of private open space, and mature gardens and trees including a small apple orchard, keep the home largely screened from the road - a rare quality at any price point in Boulder County. The home was completely renovated, and the craftsmanship announces it..
more...
The content relating to real estate for sale in this web site comes
in part from the Internet Data eXchange ("IDX") program of
METROLIST, INC., DBA RECOLORADO® Real estate listings held by brokers other
than The Brian Petrelli Team are marked with the IDX Logo.
This information is being provided for the consumers' personal, non-commercial use and may not be used for any other purpose. All information subject to change and should be independently verified.