Sources: FBI, Uniform Crime Reports, prepared by the National Archive of Criminal Justice Data
The Brian Petrelli Team is your , Lafayette home specialist.
Our team of local Lafayette 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: real broker, llc dba real
Broker Remarks:
BACK ON THE MARKET - NOW PRICED $40,000 below the appraised value!!! Close with instant equity!!! Welcome to 1715 Pioneer Circle - a stunning home built in 2017 that perfectly blends spacious living, prime location, and exceptional amenities. This elegant residence offers four bedrooms (upstairs loft currently being converted into a bedroom with a closet), four bathrooms, and a three-car garage. The open floor plan features a chef’s gourmet kitchen equipped with stainless steel appliances and a large kitchen island, ideal for both everyday living and entertaining. Step inside to discover hig..
more...
Status: active
Listing Office: re/max of boulder, inc
Broker Remarks:
Rare gem in the heart of lively downtown Lafayette with anything one could desire within walking distance. The 1,100 square foot, 3 room/2 bathroom/Full Kitchen, classic yet modern building is nestled on a fanciful and immaculate 6,500sf corner lot along South Public Rd. Long-term local ownership pivoted to a successful VRBO after a wine bar concept backed out. Past uses include Retail, Office, Health/Wellness, and a Creative Gallery. Truly versatile...
more...
Broker Remarks:
This spacious and inviting home offers both comfort and potential in a quiet, desirable neighborhood. As you enter, you’ll be greeted by hardwood floors that flow throughout the main level, creating a warm atmosphere. A main floor office with French glass doors provides an ideal space for work or study, offering both privacy and natural light. The kitchen is a chef’s dream, featuring granite countertops, a gas cooktop, an island with counter seating, and a built-in desk perfect for organizing your day. The charming breakfast nook offers a sunny spot to enjoy your morning coffee.
Step inside t..
more...
Status: pending
Listing Office: resident realty south metro
Broker Remarks:
Welcome to this beautiful home in the highly desirable Trails at Coal Creek neighborhood. Situated on a large, premier lot, backing to open space, this inviting home features plenty of builder upgrades. As you enter the home, you’ll be greeted by a home office and half bath, before getting to the heart of the home. The kitchen, with large eat-in island opens seamlessly to the dining/great room with ample room to entertain. Upstairs features a generous primary suite with peek-a-boo views of Longs Peak, and two secondary bedrooms connected by a Jack-and-Jill bathroom. Down to the finished baseme..
more...
Status: active
Listing Office: re/max of boulder, inc
Broker Remarks:
Tucked away in a peaceful cul-de-sac within Waneka Landing, this stunning two-story home offers a perfect retreat for summer outdoor entertainment. Backing onto open space and connected to the neighborhood's scenic trail system, it invites you to enjoy tranquil evening meals on the spacious custom deck with pergola cover or unwind in one of the charming flagstone patio sitting areas. Venturing along the trail just a short distance, Waneka Lake Park awaits, offering a 1.2-mile fitness trail, a Boathouse with watercraft rentals, seasonal festivals, and a rich wildlife refuge. Impeccably maintain..
more...
Status: active
Listing Office: estate professionals
Broker Remarks:
Spacious ranch in highly sought-after Blue Heron Estates patio homes. This custom stucco and stone home backs to a serene greenway on a manicured .29-acre lot at the end of the cul-de-sac. Fabulous chefs kitchen with custom hood! HOA includes front lawn care and snow removal. Main floor features a luxurious primary suite with a 6' soaking tub, dual-head rain shower, double sinks, plus a convenient main-floor laundry. Expansive windows, soaring ceilings, and stunning new flooring enhance the open layout. High-end designer fixtures and hardware throughout. Curated outdoor spaces offer ultimate p..
more...
Broker Remarks:
Nestled just a block from picturesque Linear Park and two blocks from the inviting neighborhood pool, this stunning two-story home offers an unparalleled lifestyle of comfort, convenience & efficiency. Paid off solar system! From the moment you arrive, you'll be captivated by the beautifully landscaped yard and welcoming front patio-perfect for morning coffee in the sun or a shaded afternoon retreat. Step inside where sunlight streams through generous windows, illuminating an open floor plan designed for both relaxation and entertaining. The heart of the home is a chef's dream kitchen, where s..
more...
Status: active
Listing Office: re/max alliance-lsvl
Broker Remarks:
Nestled just a block from picturesque Linear Park and two blocks from the inviting neighborhood pool, this stunning two-story home offers an unparalleled lifestyle of comfort, convenience & efficiency. Paid off solar system! From the moment you arrive, you'll be captivated by the beautifully landscaped yard and welcoming front patio-perfect for morning coffee in the sun or a shaded afternoon retreat. Step inside where sunlight streams through generous windows, illuminating an open floor plan designed for both relaxation and entertaining. The heart of the home is a chef's dream kitchen, where s..
more...
Broker Remarks:
Outstanding location backing up to the Indian Peaks Golf course with sweeping westerly views across the course. Situated adjacent to a beautiful stretch of open space to the south providing the owner of this well-maintained South facing 2 story home seclusion and privacy. Quality- built by McStain in 2001. Hardwood floors grace most of the sun-drenched main floor. Main Level study ideal for the home office . The kitchen has granite-tile counters, stainless appliances, maple cabinets, pantry, a bright breakfast bar as well as an island eat-in counter. Large formal Dining with a butler pantry. H..
more...
Broker Remarks:
NEW PRICE! Come see this stunning property. Perched on a premium lot at the highest point in Eagles Landing, this stunning property demands attention. With golf course to 3 sides and mountain views to the rear, this McStain Redhawk model is a rare find. Soaring windows let in beautiful light in the 2-story great room. The fully updated Kitchen includes, a Wolf gas cooktop, premium stainless steel appliances, quartz counters, pendant lighting and more. Four bedrooms upstairs including a large primary suite with ensuite 5-piece luxury bath including free-standing soaking tub, separate shower and..
more...
Broker Remarks:
Welcome to this stunning ranch style home ideally located in the fantastic neighborhood of Trails at Coal Creek. The location offers access to the Coal Creek trail system, surrounding parks, and nearby dining, shopping, and events in the charming downtowns of Louisville and Lafayette. Upon walking in you are greeted with a wow factor of high ceilings showing off the expansive and open layout of the home. The double sided fireplace is a center piece of the home between the living room and the dining/flex space. The living room is completely open to a gourmet kitchen featuring an extensive amoun..
more...
Status: active
Listing Office: re/max of boulder, inc
Broker Remarks:
Stunning remodeled ranch home on Waneka Lake Trail, offering breathtaking mountain views and a walk-out lower level with an additional kitchen. The custom kitchen, renovated in 2021, features quartz countertops, stainless steel appliances, a sleek design, breakfast bar, and sliding glass doors leading to a large deck with snow-capped mountain vistas. Gleaming hardwood floors, freshly painted trim and doors, and new hardware enhance the home's modern appeal. The open eat-in kitchen area includes custom built-ins and a stylish double-sided fireplace, shared with the airy great room, which boasts..
more...
Broker Remarks:
Stunning remodeled ranch home on Waneka Lake Trail, offering breathtaking mountain views and a walk-out lower level with an additional kitchen. The custom kitchen, renovated in 2021, features quartz countertops, stainless steel appliances, a sleek design, breakfast bar, and sliding glass doors leading to a large deck with snow-capped mountain vistas. Gleaming hardwood floors, freshly painted trim and doors, and new hardware enhance the home's modern appeal. The open eat-in kitchen area includes custom built-ins and a stylish double-sided fireplace, shared with the airy great room, which boasts..
more...
Broker Remarks:
Incredible 5-bedroom, 4-bathroom home nestled on a premium cul-de-sac lot backing to the renowned twelfth fairway of Indian Peaks golf course. This home boasts a grand entrance, soaring ceilings, and an abundance of natural light. The kitchen features stainless steel appliances and ample counter space to prepare meals while enjoying the great views. The master suite is a private retreat with great views and ample light. Enjoy outdoor living at its finest on the expansive deck, perfect for al fresco dining and enjoying the serene golf course views. A finished lower level adds to the usable spac..
more...
Status: active
Listing Office: re/max alliance-boulder
Broker Remarks:
Incredible 5-bedroom, 4-bathroom home nestled on a premium cul-de-sac lot backing to the renowned twelfth fairway of Indian Peaks golf course. This home boasts a grand entrance, soaring ceilings, and an abundance of natural light. The kitchen features stainless steel appliances and ample counter space to prepare meals while enjoying the great views. The master suite is a private retreat with great views and ample light. Enjoy outdoor living at its finest on the expansive deck, perfect for al fresco dining and enjoying the serene golf course views. A finished lower level adds to the usable spac..
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.