Refine Search
Map
Sort by
$1,999,000
5 Beds ⋅ 4 Baths ⋅ 3817469 MLS ⋅ COMING SOON Status
More photos and floor plans coming soon --- This incredible estate is being offered through a transparent, non-distressed luxury live auction --- Bidding to start from $1,999,000! --- Live auction link will be provided shortly --- Live Auction Thursday, October 22nd, 2026 at 1pm MT (No Buyer Premium) --- Set on 10 acres this exceptional 7,840-square-foot estate offers a rare combination of space, privacy and natural beauty. Originally built in 1974 with significant additions completed in 1991, the property features 5 bedrooms, 4 bathrooms, and a flowing floor plan designed to capture abundant natural light through expansive windows that showcase the surrounding views. For those who value a retreat from the "electromagnetic smog" of more densely developed areas, the Table Mountain "Acoustic Quite Zone" creates a distinctive setting for this estate. The grounds offer an idyllic Colorado lifestyle, with an orchard producing apples, pears, plums, and grapes. A large barn is ready for use and providing excellent potential for equestrian pursuits. A recently renovated 700-square-foot cottage adds valuable flexibility and is currently used as a studio. With the appropriate land-use approval, the cottage may also offer potential as an accessory dwelling unit (ADU), making it an appealing option for guests, extended living arrangements, multigenerational living, or additional workspace. Recent improvements include repairs and updates to the stucco, exterior paint, trim, gutters, and leaf-filter system, along with work to the septic tank and sewage main. Parking is plentiful, with a two-car attached garage plus eight additional surface parking spaces. With its stunning views, orchard, versatile outbuildings, renovated cottage, peaceful setting, and thoughtfully updated components, this unique estate presents an extraordinary opportunity to enjoy privacy, space, and a more tranquil Colorado lifestyle while remaining conveniently positioned in the Longmont area.

3800 Plateau Rd, Longmont
$825,000
5 Beds ⋅ 4 Baths ⋅ 1068356 MLS ⋅ COMING SOON Status
Pride of ownership - original owners selling a Richmond Aries model in Longmont's much desired Quail Crossing! Enjoy over 4200 finished sq. feet w/ 6 beds (or 5 beds w/main floor office), 4 baths & 2-car garage. Remodeled kitchen & all baths! Open & bright floor plan & deluxe kitchen w/ black stainless appliances, white cabs, backsplash & granite counters! You'll love the 2 pantries. Four beds & laundry upstairs. Large primary suite w/ bay window & custom walk-in closet. Main floor has living room, dining room w/ wood floors, kitchen, large family room w/ gas fireplace, full bath and 6th bedroom or office. Full finished basement w/ 3/4 bath, bedroom & huge rec. room/great room. Colorado outdoor living at it's finest too with large deck & patio w/ firepit & hot tub included! Large lot fully fenced & beautiful landscaping! Walk to schools, parks, shopping, restaurants, VASA fitness & surround by tons of walking & biking trails! And NO Metro tax! INSIDE PHOTOS BEING TAKEN 9/16 AND THEN GOING ACTIVE ON THE MLS!

1516 Red Mountain Dr, Longmont
$590,000
4 Beds ⋅ 4 Baths ⋅ 1068350 MLS ⋅ COMING SOON Status
A great opportunity in Firestone's Oak Meadows community, offering a spacious, functional floor plan with the added benefit of low-maintenance outdoor living. The main level features an open kitchen and living area with a fireplace, plus a dedicated office for added flexibility. Upstairs, the primary suite is privately positioned with a large walk-in closet and 5-piece bath, while three additional bedrooms share a full bath. The finished basement provides even more usable space with a large rec room, 3/4 bath and dedicated storage room. Outside, gravel landscaping minimizes upkeep, while a dog run, expanded three-car-wide driveway and spacious 3-car tandem garage add everyday functionality. Major updates include a new A/C in 2026, furnace in 2025, and roof and exterior paint in 2023. Conveniently located near parks, trails, shopping, dining and everyday amenities. Close to I-25 for community to Denver, Boulder, or Northern CO.

11279 Ebony St, Firestone
$1,795,000
6 Beds ⋅ 5 Baths ⋅ 1068198 MLS ⋅ COMING SOON Status
Situated on one of the most desired lots in the prestigious Majestic Retreat enclave, this exceptional estate offers a rare blend of tranquility, luxury & breathtaking views. Located in east Boulder County, this stunning home with sweeping & unobstructed mountain views backs to farmland that will never be developed, protected by a neighboring conservation easement. Impeccably designed with high-end finishes throughout, this home pairs exquisite style with thoughtful functionality. Step inside to find a bright, expansive interior flooded with natural light from an abundance of windows, soaring ceilings & mountain views from every floor. A newly renovated kitchen is a culinary enthusiast's dream featuring new quartz counters, new appliances (including induction cooktop), updated cabinets, faucets & large walk-in pantry. The main floor also features a luxurious primary suite with a spa-like five-piece bath with heated floors & walk-in closet. A formal dining room, study with built-in shelving, powder bath and laundry/mud room complete the main level. Upstairs there is a bedroom with ensuite bath and 2 additional bedrooms connect by an updated Jack-N-Jill Bath. The finished basement offers flexibility for multigenerational living with a private walkout entrance, sprawling family room with wet bar, 2 additional bedrooms, remodeled 3/4 bath, media/rec/workout room & a bonus 2nd office with custom built-ins. Outdoor living is just as impressive with low maintenance deck, retractable awning, patio & pergola with built in grill, a large dog run, mature trees - a secluded oasis surrounded by farmland, open space & unending views. Prepare to be enchanted by the serenity of the Majestic Retreat community - expansive acreage lots, country serenity and neighborhood park with meandering trail for walking and unwinding. Minutes to downtown Lyons, Longmont & Boulder. This is truly a rare opportunity to own a private retreat in one of Boulder County's most desirable neighborhoods!

8983 Prairie Knoll Dr, Longmont
The data relating to real estate for sale on this web site comes in part from Information and Real Estate Services, LLC under IRES Rules © Copyright IRES, and is provided for limited non-commercial use. Information is provided exclusively for consumers' personal use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Real estate listings held by other brokerage firms are included in this site and detailed information about them includes the name of the listing brokers. Listing broker has attempted to offer accurate data, but buyers are advised to confirm all items.
Information deemed reliable but not guaranteed by the MLS
Listing data last updated: