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: coldwell banker realty-boulder
Broker Remarks:
Welcome to your serene country retreat, where quiet living meets convenience just minutes from Boulder, Longmont, and Niwot. Framed by sweeping 360-degree views of the Flatirons and foothills that can be enjoyed from your home, barn, and arena, this property offers the ultimate Colorado lifestyle. The land is the true star here: one share of Crocker Ditch water rights, an irrigation well with unlimited water, and new fencing support the expansive pastures. Equestrians will appreciate the brand-new 100x150 arena, an impressive six-stall barn with water and hay storage, a three-stall run-in shed..
more...
Status: active
Listing Office: coldwell banker realty-boulder
Broker Remarks:
A truly exceptional and rare equestrian property on over 5 acres with stunning views. A breathtaking setting that is just a short drive to all that Boulder has to offer, and across from open space. Supreme first impression as you pull up to the home that is surrounded by mature trees with an arena in front. A welcoming front porch greets your arrival & is adorned with a heated dog house. Upon entering, your eyes will be drawn to the wood flooring that extends throughout the main level. The open floor plan guides you to the kitchen, which is outfitted with premium appliances, a prep island, & p..
more...
Broker Remarks:
Welcome to Portico Lane an exclusive enclave of just 40 custom estates where luxury, privacy, and timeless design come together. This French-chateau inspired residence sits on just over an acre with mountain views, offering nearly 7,000 square feet of refined living designed for those who believe space is the ultimate luxury. Brand new carpet install just prior of listing, an incredible lot, and endless space for enjoyment makes this home the best residence in this quiet pocket of Longmont. With 7 bedrooms and 7 bathrooms, the estate blends grandeur with warmth. Inside, 4,142 square feet above..
more...
Status: active
Listing Office: kentwood real estate boulder valley
Broker Remarks:
Welcome to the good life! With stunning mountains as a back-drop, step through grand double glass doors into a striking entry featuring vaulted ceilings, skylight, travertine stone floors, and an impressive chandelier. This residence radiates elegance. The formal dining room continues the refinement with vaulted ceilings, skylight, and stylish chandelier, complemented by service from a well-appointed butler's pantry, wine storage, and high-top dining.The open living room sits just off the chef's kitchen, where beveled granite countertops, top-of-the-line stainless steel appliances, and gas fir..
more...
Status: active
Listing Office: kentwood real estate city properties
Broker Remarks:
Stunning, tastefully updated home in Longmont’s Clover View North community. Enjoy privacy, mountain views and versatile outdoor living on 2.91 acres of Agriculturally zoned property. Step inside to a main level boasting vaulted ceiling, hardwood floors, and a warm color palette with just a hint of Mediterranean style! The kitchen offers slab granite counters and island top and an array of Thermador and Bosch appliances. Nestled adjacent is a spacious butler’s pantry perfect for a cocktail or refreshment and high-top dining. The family room exudes warmth and comfort with fireplace, built-in so..
more...
Status: active
Listing Office: sellstate altitude property group
Broker Remarks:
New price on this unique opportunity! Sitting just south of Longmont, this quiet property has SO much to offer. 20 acre plot on level land, 2 homes, a 1200 sq ft detached garage/shop, silo, along with membership in the Shupe ditch water co-op. The main house features 6 oversized bedrooms, 3 baths, wood floors throughout & partially finished basement adds a bonus room & space to grow. 2 large main floor living, formal dining room, new kitchen appliances. House #2 (11173 Lookout) is a charming farmhouse that, although it needs love is a rare opportunity to have 2 houses/certificates of occupancy..
more...
Status: active
Listing Office: wk real estate longmont
Broker Remarks:
Great development opportunity or buy and hold. Just under 3 acres east of Pace, on the north side of 9th (St. Vrain Rd) across from the north entrance to Fox Hill. Property is currently in Boulder County, zoned Ag. Improvements include 1947 farmhouse, plus 6 outbuildings. One of the few infill development lots in Longmont. Up to 18 units per acres possible. Water rights include 1/4 share of Rough and Ready Ditch, which delivers approximately 14.9 acre-feet of water. According to the City, this would fulfill the raw water requirements for development...
more...
Status: active
Listing Office: home sold realty, llc
Broker Remarks:
Breathtaking views of Colorado landscape and foothills, on a 10 acre parcel. Updated with recent repairs including stucco, exterior paint, trim, gutters, leaf filter system, septic tank and sewage main. 7,840 sq/ft main residence and 700 sq/ft cottage. Lots of natural light through large windows, Lots of spaces, aside from the 4 bedrooms of the main building and 1-2 bedrooms of the cottage.
The unique floorplan offers flexibility and comfort, with new flooring in the upstairs hallway and master bedroom, and an updated master bathroom featuring new flooring and a wall that separates the toilet..
more...
Status: active
Listing Office: key team real estate corp.
Broker Remarks:
Welcome to your slice of heaven. This perfectly carved out 43 acre parcel offers unobstructed views of the Rocky
Mountains making it a dream come true for new owners to reside or homebuilder potential. Positioned in the Town of
Fredericks Comprehensive Plan. This plan indicates a zoning of one dwelling per five acres but wait there's more! You have
the opportunity to secure a density bonus, allowing for one dwelling per two acres, provided that 50% of this pristine land
is preserved. This remarkable property also includes an undivided 1/8 interest in the Delehant Ditch, enhancing its
agri..
more...
Broker Remarks:
Positioned on a premier half-acre homesite backing to the 13th hole of Fox Hill Golf Course, this exceptional custom residence in the coveted Starwood community offers architectural distinction, refined finishes, and effortless indoor-outdoor living. The home’s unique U-shaped design embraces a private courtyard with fountain, creating a striking focal point and seamless connection to the outdoor spaces.
nside, remarkable craftsmanship and thoughtful design are evident throughout. The grand living room features soaring ceilings and an overlooking balcony, while the gourmet kitchen serves as..
more...
Broker Remarks:
A water sport enthusiast's dream! Located in prestigious Pelican Shores gated community & sitting on a 55-acre private water ski lake. Bring your boat because you are going to love all the fun of living on Pelican Shores with a private beach and boat house. The Lake is a water sport lake that has a Slalom course where you can boat, wake board, water ski, wake surf, fish, paddle board & enjoy the exclusive neighborhood trail surrounding the lake. Just beyond your view of the lake is an unobstructed majestic view of the mountains. Enjoy warm days on the boat, lounging on the beach, cool days on ..
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: wk real estate longmont
Broker Remarks:
Live the resort lifestyle in this exquisite European-inspired, Tuscan-Mediterranean home, where timeless architecture meets premier lakefront living. Stone lined bridge over moat leads to a grand portico entry and elegant curved turret create a striking first impression, while the private cul-de-sac setting within the gated Lighthouse Cove community offers both privacy and prestige. The backyard opens directly to the 40 acre lake and features a private boathouse with dock, covered slip, and lift-offering immediate access to boating, water skiing, wakeboarding, wakesurfing, tubing, and paddlebo..
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...
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.