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: pending
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...
Status: active
Listing Office: madison & company properties
Broker Remarks:
Nearly 38 acres of premier equestrian facilities, thoughtfully designed infrastructure, and beautifully remodeled living spaces create a remarkable horse property just ten minutes from Boulder and Longmont. Designed with the dedicated equestrian in mind, this impressive estate combines extensive amenities for the care, training, and enjoyment of horses with the comfort of a private country residence. Both indoor and outdoor riding arenas anchor the equestrian facilities, complemented by extensive stabling (16 stalls), a dedicated office, tack room, laundry hookups, and convenient feeding stati..
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 premier
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:
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: coldwell banker realty-noco
Broker Remarks:
NEW IMPROVED PRICE!!! 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 thoughtfu..
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 enjoys expansive views across an adjoining 62-acre parcel of privately owned space. Mature gardens and trees and the long driveway provide the ultimate privacy. The home was completely renovated and the craftsmanship announces itself before you reach the front door: a ..
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...
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:
Welcome to 7047 Goose Pt, this extraordinary estate offers unobstructed Front Range mountain views and a modern renovation that brings elegance and style to this stunning property. Set on 4.66 acres and surrounded by 60 acres of protected open space, this is a rare opportunity to enjoy your own private sanctuary within 20 minutes of Downtown Boulder. A brand-new pool, hot tub and heated barn elevate the outdoor experience, offering relaxation or the perfect party spot. Sophisticated finishes throughout the home-from designer wallpaper to slab stone surfaces to gorgeous tile hearths. Soaring ce..
more...
Status: active
Listing Office: liv sotheby's intl realty
Broker Remarks:
Rare opportunity to acquire one of Boulder County's premier luxury homesites in coveted Meadow Ridge. Set among exceptional estates with sweeping mountain views, this property offers a unique head start for a future custom residence. Seller previously completed substantial pre-development work including custom home plans, 2023 Boulder County Site Plan Review application (SPR-23-0011), HOA/DRC design approval, septic design engineering, and purchase of Little Thompson Water District water tap. Significant time, planning, and expense have already been invested, creating a valuable foundation for..
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.