Featured Properties

Some or all of the listings below are provided by the North Metro office.
$2,500,000 (USD)
Active

Boulder Equestrian Center Area Single Family Home

Active

8778 Arapahoe Road Boulder, CO 80303

3 Bed
2 Baths
2741 sqft
MLS# 4495115
Virtual Tour
Incredible opportunity with great new price!
SPECIAL USE PERMIT ALLOWING UP TO 45 HORSES ON ~10 ACRES (grandfathered with the property)! A rare opportunity to own a fully operational equestrian facility with excellent income producing potential in unincorporated Boulder County. Well-suited for horse boarding, training, riding lessons, equine therapy, clinics, camps, events, pony parties, polo programs, farming, or private use, with additional permitted uses possibly available.
Designed to get your business up and running quickly, the facility features a NEW 150'x90' insulated indoor riding arena with rubber-sand footing and professional lighting for year-round riding and training. Three outdoor arenas—a 150'x150' lighted arena, a 65'x90' training arena, and a regulation dressage arena—provide space for lessons, clinics, competitions, and daily operations.
Five barns offer flexible layouts with up to 45 horse stalls, automatic waterers, tack rooms, and feed storage. A covered hay barn stores approximately 6,720 small bales, and a 600-square-foot shop offers additional space for equipment and maintenance.
The office building/clubhouse, featuring a NEW roof, overlooks the indoor arena and includes office and meeting space for business operations, instruction, or client use.
A 3-bedroom, 2-bath home suits an owner, trainer, caretaker, or rental, and can be expanded or relocated to build a larger residence.
Adjacent to Teller Farm Open Space Trail and just 6 miles from Downtown Boulder, the property offers convenient access while maintaining privacy and open Front Range views.
Operating costs stay low with Left Hand Water District public water, a domestic well serving approximately one acre, two septic systems, and affordable utilities.
A rare combination of location, functionality, and opportunity—whether expanding an equestrian operation, starting a new business, or enjoying the property for private use. Sold AS IS.
Listed By: Alexis Papadakis-Greenberg, Coldwell Banker Realty
$875,000 (USD)
Sold

Compass Area Single Family Home

Sold

1849 Marquette Drive Erie, CO 80516

5 Bed
4 Baths
4580 sqft
Welcome home to this spacious and thoughtfully designed 5 BDRM, 4 BATH home in the highly sought-after Compass neighborhood of Erie. Step inside to find a welcoming entry and formal dining room that lead into a chef’s kitchen, complete with an oversized island and open flow into the stunning two-story family room with a cozy gas fireplace.The main floor offers a versatile bedroom and full bath, ideal for guests or a home office. Upstairs, you’ll find a large loft with its own bathroom, plus a luxurious primary suite featuring a five-piece bath and a walk-in closet with custom built-ins that conveniently connects to the laundry room. Two additional bedrooms share a well-appointed Jack-and-Jill bath. The finished basement expands your living space with a large recreation room, wet bar, and an additional bedroom. It’s plumbed and ready for a future bathroom, perfect for growing families or entertaining guests. Enjoy Colorado living at its best from the welcoming front porch, an ideal spot to relax with coffee and watch Erie’s famous hot air balloons drift by. The backyard offers even more outdoor living with a covered deck featuring custom shades for privacy, plus an extended stamped-concrete patio perfect for gatherings. The oversized three-car garage is finished with epoxy floors, and additional updates include new flooring, two furnaces, and a radon mitigation system. Located in one of Erie’s most desirable communities—just minutes from parks, trails, top-rated schools, and charming downtown Erie—this home perfectly blends luxury, comfort, and small-town charm.
Listed By: Jennifer Kiss, Coldwell Banker Realty
$980,000 (USD)
Sold

Sunset Village Area Single Family Home

Sold

1361 Morning Side Drive Erie, CO 80516

5 Bed
4 Baths
4266 sqft
**Available with rates as low as 3.75 % when using builder’s preferred lender – terms and conditions apply – ask for details****Contact builder today about Special Financing for this home - terms and conditions apply**
Luxury Living Backing to Open Space
Perfectly positioned on a premier lot backing to open space, this stunning Aspen floor plan blends modern luxury with everyday comfort. Sunlight fills the open main level, highlighting elegant EVP flooring and a dramatic two-story great room. A convenient main-level bedroom and full bath offer flexibility for guests or multigenerational living. The gourmet kitchen is a true showpiece—featuring quartz countertops, double ovens, a gas cooktop, a spacious eat-in island, and a charming breakfast nook that opens to the covered rear deck—perfect for relaxing or entertaining. Upstairs, the primary suite serves as a serene retreat with a spa-inspired en-suite bath. A versatile loft provides additional living space, while bedrooms three and four share a Jack-and-Jill bath, and bedroom two enjoys its own private full bath for added comfort. The unfinished walkout basement invites your personal touch. Additional highlights include a 2+1 garage and energy-efficient solar power. Nestled in the heart of Erie, residents enjoy a welcoming small-town atmosphere with breathtaking mountain views, a 63,000 sq. ft. community center, a 20,000 sq. ft. library, and easy access to shopping, dining, parks, and scenic trails. Experience the perfect balance of sophistication, space, and setting.
Listed By: Kris Ceretto, Coldwell Banker Realty
$602,000 (USD)
Sold

Johnson Farms Area Single Family Home

Sold

5474 Wetlands Drive Frederick, CO 80504

5 Bed
3 Baths
2907 sqft
Welcome to your dream home in the heart of Johnson Farm, where timeless design meets modern comfort. This beautifully maintained two-story features a finished basement, thoughtful upgrades, and undeniable curb appeal. From the moment you arrive, you’ll appreciate the lush landscaping, fresh exterior paint in a sophisticated palette, and a new roof (2023).
Inside, a spacious foyer greets you with a custom feature wall and a main-floor office framed by elegant French doors. The open-concept layout flows effortlessly between the inviting living room, dining area, and upgraded kitchen—perfect for both everyday living and entertaining. The kitchen showcases 42 cabinetry with under-cabinet lighting, stainless steel appliances including an LG refrigerator and built-in microwave, a pantry, and generous workspace.
Upstairs, the primary suite offers a peaceful retreat with a 5-piece bath featuring dual sinks, a soaking tub, and a walk-in closet. Three additional bedrooms, a full bath, a versatile loft, and a large laundry room with built-in shelving complete the upper level.
The finished basement expands your living space with a spacious recreation room, wet bar, guest bedroom, and ¾ bath—ideal for relaxation or entertaining.
Step outside to your private backyard oasis featuring an expansive patio, gorgeous pergola, double garden beds, two playsets, and a dedicated dog run. The beautifully fenced yard shows true pride of ownership and offers space for everyone to enjoy.
Additional highlights include a three-car garage with a service door, storage shed, Ecobee smart thermostat, B-Hyve WiFi sprinkler controller, Ring doorbell and brand new permanent holiday (Jellyfish) lights!
Meticulously maintained, move-in ready, and loaded with thoughtful upgrades—this Johnson Farm gem truly has it all
Listed By: Dylan Lario, Coldwell Banker Realty