Refine Search
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

$250,000
4 Beds 2 Baths 1068484 MLS ACTIVE Status
Seller will consider Owner Carry with 30% down. Incredible investment opportunity: tear down and rebuild or fix up and earn sweat equity. This purged manufactured home sits on one of the largest lots in the neighborhood with no HOA and no lot fee. Being sold as-is, it offers tremendous potential for those willing to put in sweat equity for a great return. Featuring 4 non-conforming bedrooms and 2 bathrooms, the home has rental potential once renovated and provides a functional layout ready for your vision. The oversized two car detached garage includes multiple storage rooms. Above is an unfinished apartment/potential ADU with rough-ins for a bathroom, laundry, and a kitchen setup- perfect for additional rental income once completed. If considering tearing down, the utilities are already at the property and by rebuilding with a HUD tagged home, the value of the property can increase substantially. The property sits on one of the largest lots in the neighborhood, backing to a greenbelt, offering privacy, a fruitful peach tree, garden area, greenhouse, and plenty of room for outdoor projects. Priced for buyers seeking a project, this property offers rare investment and income opportunities. *****Due to the age of the home (pre 1976), this sale is cash only, hard money loan (if available), or seller financing.*****

1220 Mackay Ct, Dacono

$599,000
4 Beds 3 Baths 3641297 MLS ACTIVE Status
A wonderful opportunity to enjoy one of Erie's most appealing settings! Freshly updated and ready for its next owner, this home combines privacy, open-space views, direct trail access, and a long list of recent improvements. The location is truly exceptional. Tucked away on a quiet cul-de-sac with just two homes, the property enjoys a rare sense of privacy, with no neighbors directly in front and beautiful views across the open space behind. Relax in the backyard while taking in Colorado sunsets, or step outside and enjoy direct access to the Coal Creek Trail, a scenic 14-mile trail connecting Erie and Superior. For anyone who values open space, trails, views, and privacy, this setting is hard to beat. Inside, the home feels fresh and welcoming with newly painted interiors, new LVP flooring and carpet, beautifully refinished hardwood floors in the kitchen and entry, and new kitchen countertops. Recent improvements also include new smoke alarms and a refurbished sprinkler system. Outside, fresh crushed granite along the walkway and new mulch around the trees enhance the landscaping and curb appeal. With these updates already completed, the home is ready to enjoy. Located within the St. Vrain Valley School District and ideally positioned between Boulder and Denver, Erie offers convenient access to employment centers, recreation, and Denver International Airport. A terrific combination of an exceptional setting, recent updates, privacy, views, and trail access! (This sale will involve a multi-step court approval process. Once an acceptable offer is selected, it will be submitted to the court for approval, which is expected to take about 2-3 weeks. Please use MEC dates in the contract. Property will be conveyed via Receiver's Deed and is being sold strictly "as-is." Any HOA violations must be cured by the new homeowner after Closing.)

658 Jacques Way, Erie

$339,000
3 Beds 2 Baths 1067120 MLS ACTIVE UNDER CONTRACT Status
Offers received, no more showings. Amazing opportunity in Parkview Estates! This 3 bed, 2 bath ranch style home sitting on a great lot surrounded by shaded trees, wisteria and lavender is ready for your vision to come to life. Big ticket items recently updated including roof, exterior paint, garage door, furnace and water heater. RV parking plus 2 car garage top it off! Cosmetic updates needed inside. Open floorplan with vaulted ceilings, gas range, covered front porch and ADA adapted ramps, doors, large en-suite in primary bedroom and added laundry hookups on main floor. Great kitchen footprint with dining area that leads out to backyard patio with pergola. Full unfinished basement for additional space that includes second laundry area plus rough-in for 3rd bathroom. Great location only 20min to Denver, close to schools, parks, golf courses, restaurants and rec center. Home is being sold AS-IS through a personal representative managing the Estate. No HOA, No Metro District.

347 Walnut Dr, Frederick

$465,000
4 Beds 2 Baths 8305813 MLS ACTIVE Status
Welcome to 18 Kodiak Court, a wonderful opportunity to own a spacious 4-bedroom, 2-bathroom home in an established Longmont neighborhood. Offering a functional layout and generous living space, this home is ready for its next owner to make it their own. Featuring mostly original finishes, it's the perfect opportunity to add your personal style, renovate at your own pace. Step outside to a large backyard with plenty of room for entertaining, gardening, or creating the perfect outdoor retreat. The expansive yard also provides an ideal space for pets to run and play, making it a great fit for animal lovers. Conveniently located near neighborhood parks, schools and everyday amenities, this home offers both comfort and convenience in a desirable location. Someone looking for a home with incredible potential, this property presents an exceptional opportunity to create the home you've always envisioned. Don't miss your chance to bring your vision to life and enjoy everything this welcoming Longmont community has to offer! THIS PROPERTY WILL BE SOLD AS IS.

18 Kodiak Ct, Longmont

$459,000
4 Beds 4 Baths 3940277 MLS ACTIVE Status
**CASH OR CONVENTIONAL OFFERS ONLY** Rare chance to own a piece of the American Dream in the coveted Booth Farms Subdivision! Open contemporary layout with full partially finished basement and attached 3-car garage. The open floor plan offers formal living and dining plus a sunny eat-in kitchen space adjoined by a large family room with cozy gas fireplace. All 4 bedrooms on the second floor comes with a connected bathroom. Needs some cosmetic repairs throughout but certainly one of the best deals in all of northern Colorado! Private fenced back yard, mature trees next to walking green belt. Cement patio with room for grilling, entertaining and relaxing. Just minutes to parks, walking trails, restaurants and shopping and top-notch schools. Great location with easy access to Denver and Boulder. Welcome home to Booth Farms! **SELLER WILL NOT ACCEPT OFFERS CONTINGENT UPON THE SALE OF ANOTHER PROPERTY FROM ANY BUYER**

5869 Scenic Ave, Firestone

$1,890,000
5 Beds 7 Baths 1054553 MLS ACTIVE Status
Seller offering $150,000.00 concession to buyer at time of closing with a full price offer!! PRIVACY! Incredible panoramic VIEWS of Pikes Peak. Apple trees on your driveway up! This unique flagstone/concrete solarium home is perched atop of its own hill with 20+ acres to offer in Boulder County. Surrounded by 1200 acres of Wildlife reserve land for the monitoring of bald/golden eagles, and 80 acres of private land. Dramatic West/East Wing layout the home centers a sun warmed solarium living room with 15-foot floor to ceiling windows. Hardwood flooring throughout. French inspired finishes. Marble and tile countertops. Stainless Steel Appliances. Multiple Private living areas. Flagstone floor Wine Cellar doubles as a mother-in-law retreat. Art Studio/Den. Upgraded Fireplace. Expansive reinforced NEW concrete deck that sprawls the entire front of the home. Grapevine-covered patio just off the primary suite. The primary bathroom features dual bathrooms and separate, his-and-hers closets. Private water well and cistern system. LARGE Insulated Drive Through Garage and storage. Rock warming South facing driveway. Spacious Outdoor flat area to build your next shop, garage, or barn. Built in concrete safe room. NO Drive BYS, by Appointment only.

1042 Steamboat Valley Rd, Lyons

$875,000
4 Beds 2 Baths 5869742 MLS ACTIVE Status
Rare opportunity for a visionary buyer to acquire and renovate a one-of-a-kind 1.9-acre property in the coveted Brigadoon Glen neighborhood. This charming retreat in unincorporated Boulder County offers a lower tax rate, no HOA, and endless possibilities for personalization. Bring your architect and imagination to craft your dream home! The property features a large barn with a loft, two silos, a second barn, a large storage building, and a studio. Versatile outbuildings steeped in history, perfect for creative pursuits, equestrian facilities, or flexible storage. Zoned RR (Rural Residential), it permits horses and other animals, a rare find for rural living enthusiasts. *Left-hand water and an unregistered well are located on the property. Surrounded by mature trees, fruit trees, and stunning mountain views, this private oasis provides ample space for gardening, outdoor entertaining, or a tranquil retreat. Enjoy peaceful country living just minutes from Niwot, Boulder, and Longmont, with easy access to HWY 36, Boulder trailheads, cycling routes, Boulder Reservoir, Coot Lake, and Tom Watson Park for endless outdoor adventures. This once-in-a-lifetime property, sold "as is"

5939 Niwot Rd, 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: