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: re/max alliance-boulder
Broker Remarks:
A captivating 9.4 acre sanctuary where water, mountain views, and remarkable privacy define the experience. Set discreetly away from the road between a canopy of mature trees, this extraordinary property situated at a dead end opens to panoramic views of Longs Peak and is perfect for biking/walking/horseback riding. Left Hand Creek meanders through the grounds, while a natural irrigation pond and 8 shares of Left Hand Ditch water add versatility to the land. At the heart of the property is an approximately 5,700 square foot ranch, thoughtfully updated with sophisticated finishes while preservi..
more...
Broker Remarks:
Originally built as the model home by a premier luxury builder, this exceptional estate showcases craftsmanship and thoughtful design rarely found. Set on 1.12 private acres in the Portico neighborhood, this 6-bedroom, 7-bath residence offers timeless French-country elegance with modern lifestyle enhancements. At the heart of the home is the sun-filled family room, featuring soaring cathedral ceilings and a dramatic stone hearth and gas fireplace-a warm, inviting space ideal for daily living and entertaining. Refined finishes include skip-trowel textures, Venetian plaster, luxury wall covering..
more...
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...
Status: active
Listing Office: hayden outdoors - windsor
Broker Remarks:
Yellowstone Estate spans 64.71 acres across two adjoining parcels in Boulder County, offering a rare combination of luxury living, exceptional privacy, and agricultural land. The property includes a custom 5,021 SF ranch home situated on a beautifully landscaped 5-acre homesite and an adjoining 59.73 -acre conservation easement parcel that preserves the open landscape while allowing agricultural uses and improvements, subject to Boulder County review. The gated homesite features a concrete driveway, mature landscaping, three water features, and multiple stamped concrete patios. Designed for co..
more...
Broker Remarks:
There is a lake in Longmont that very few people know exists. Private, no-wake, remarkably serene, it sits behind the gates of one of the area's most exclusive communities. Welcome to 9402 Crystal Ln in Longmont.
Set on 5.5 curated acres directly on the water, this lakefront estate is the kind of property that rarely comes up, and rarely comes up at this number. The moment you enter the community, the noise fades. What's left is the lake, the mountains, and a house built to make the most of both.
Step inside and the view takes over. It's framed through every main living space, calming an..
more...
Status: active
Listing Office: madison & company properties - niwot
Broker Remarks:
Welcome to 7401 Deerfield Road, an exceptional retreat in Longmont, Colorado, where refined modern design meets peaceful country living. Set on an expansive lot with breathtaking mountain views, this beautifully remodeled home offers privacy, luxury, and resort-style amenities at every turn. The thoughtfully updated interior showcases an open-concept layout filled with natural light and high-end finishes throughout. The gourmet kitchen is a true centerpiece, featuring Caesarstone Mineral countertops, stainless steel appliances, and two oversized islands perfectly suited for entertaining. Adjac..
more...
Status: pending
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:
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:
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...
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: realty one group apex
Broker Remarks:
EXCEPTIONAL COLORADO EQUESTRIAN RETREAT WITH SWEEPING MOUNTAIN VIEWS ON 6.05 ACRES. Experience an extraordinary combination of refined living, privacy and thoughtfully designed horse amenities, all framed by breathtaking views of Longs Peak, Mt. Meeker and the Flatirons.
Privately gated and extensively renovated by renowned Nassar Development in 2012, this impressive 4-bedroom, 4-bath residence offers a peaceful setting while remaining just minutes from town.
Inside, vaulted ceilings create an open and airy atmosphere complemented by natural stone and beautiful custom woodwork. At the he..
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:
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...
Status: active
Listing Office: coldwell banker realty 56
Broker Remarks:
Properties with private beaches and direct lake access in this location are rarely available. Perfectly positioned along the shoreline of Gaynor Lake, this waterfront home captures unobstructed mountain views while offering a blend of relaxed living, recreation, and Colorado beauty.
Designed to embrace its waterfront setting, the home is filled with natural light and showcases breathtaking lake and mountain views from nearly every room. Expansive windows create a seamless connection between the inviting interiors and the ever-changing landscape, where peaceful mornings and colorful mountain..
more...
Status: active
Listing Office: re/max alliance-lsvl
Broker Remarks:
First time on the market! Situated behind an iron-gated security entrance, this exceptional 36 acre, fully fenced equestrian estate represents a golden opportunity to obtain your slice of paradise right in the heart of unincorporated Boulder County! A 900 foot driveway delivers you to the grand porte-cochere entrance to the home. Ideal for farming or ranching and creating a truly special place to live. Enjoy the essence of Colorado living and mountain charm from inside the home and from over 2,000 square feet of main and upper level decks that capture stunning views of the Front Range, Contine..
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.