Fryrealestate.net Search Results

5 listings

Refine Search

Sort by

242 E 42nd St, Loveland

Fantastic End-Unit Location Across from the Neighborhood Park!Discover an incredible opportunity to enjoy comfort, convenience, and exceptional value in a desirable Loveland location! This inviting end-unit home offers the added appeal of its desirable position within the community, directly across the street from the neighborhood park. Enjoy open green space just steps from your front door, along with the welcoming atmosphere of a neighborhood known for its great sense of community.If location is important to you, this property delivers! Conveniently situated near North Garfield Avenue and Highway 287, you'll enjoy easy access to everyday essentials, including King Soopers, Orchards Shopping Center, Loveland Marketplace, restaurants, coffee shops, and additional retail options. Outdoor enthusiasts will appreciate the proximity to Benson Sculpture Garden, North Lake Park, Boyd Lake State Park, and numerous recreational opportunities throughout Loveland.Whether you're looking for a place to call home or a smart investment opportunity, this property offers an excellent combination of location, convenience, and affordability. With its end-unit setting, neighborhood park just across the street, friendly neighbors, and easy access to shopping, dining, and recreation, this is a fantastic value in Northern Colorado. Don't miss your opportunity to make it yours!

2 Beds ⋅ 2 Baths ⋅ 5366364 MLS ⋅ ACTIVE Status

Fantastic End-Unit Location Across from the Neighborhood Park!Discover an incredible opportunity to enjoy comfort, convenience, and exceptional value in a desirable Loveland location! This inviting end-unit home offers the added appeal of its desirable position within the community, directly across the street from the neighborhood park. Enjoy open green space just steps from your front door, along with the welcoming atmosphere of a neighborhood known for its great sense of community.If location is important to you, this property delivers! Conveniently situated near North Garfield Avenue and Highway 287, you'll enjoy easy access to everyday essentials, including King Soopers, Orchards Shopping Center, Loveland Marketplace, restaurants, coffee shops, and additional retail options. Outdoor enthusiasts will appreciate the proximity to Benson Sculpture Garden, North Lake Park, Boyd Lake State Park, and numerous recreational opportunities throughout Loveland.Whether you're looking for a place to call home or a smart investment opportunity, this property offers an excellent combination of location, convenience, and affordability. With its end-unit setting, neighborhood park just across the street, friendly neighbors, and easy access to shopping, dining, and recreation, this is a fantastic value in Northern Colorado. Don't miss your opportunity to make it yours!

242 E 42nd St, Loveland

470 Weaver Dr, Boulder

Welcome to Palacio Celestial, a truly one-of-a-kind Legacy Estate nestled at the base of the Colorado Rocky Mountains, just 10 min from Boulder-the future home of the Sundance Film Festival. Encompassing 5 lots & 230 acres, this extraordinary property borders Betasso Preserve for over 1 mile, offering direct access to world-class hiking & biking trails while overlooking Boulder w/stunning city & mountain views. 4 of the 5 lots are buildable & 1 is a conservation easement. 470 Weaver features an 8,400 sq ft log home w/3-car garage, 44' pool & horse stable, square footage that would not be permitted today. 1327 Weaver hosts a beautifully remodeled original log home w/ garage & studio apt above. 49 Weaver & 1344 Weaver are vacant & buildable. See attached map for details.Assembled over 20 years & offered for the first time since its original acquisition in 1978, this is a once-in-a-generation opportunity. Ideal for a multigenerational estate, equestrian retreat, biker's paradise, or refined mountain compound. Located minutes from Boulder, Nederland & Eldora Ski Resort, w/ easy access to Denver & Denver Int'l Airport, this private sanctuary offers unmatched year-round recreation, breathtaking vistas, abundant wildlife & endless possibilities. Palacio Celestial awaits its next chapter, bring your vision & make it a reality!

5 Beds ⋅ 7 Baths ⋅ 1070662 MLS ⋅ ACTIVE Status

Welcome to Palacio Celestial, a truly one-of-a-kind Legacy Estate nestled at the base of the Colorado Rocky Mountains, just 10 min from Boulder-the future home of the Sundance Film Festival. Encompassing 5 lots & 230 acres, this extraordinary property borders Betasso Preserve for over 1 mile, offering direct access to world-class hiking & biking trails while overlooking Boulder w/stunning city & mountain views. 4 of the 5 lots are buildable & 1 is a conservation easement. 470 Weaver features an 8,400 sq ft log home w/3-car garage, 44' pool & horse stable, square footage that would not be permitted today. 1327 Weaver hosts a beautifully remodeled original log home w/ garage & studio apt above. 49 Weaver & 1344 Weaver are vacant & buildable. See attached map for details.Assembled over 20 years & offered for the first time since its original acquisition in 1978, this is a once-in-a-generation opportunity. Ideal for a multigenerational estate, equestrian retreat, biker's paradise, or refined mountain compound. Located minutes from Boulder, Nederland & Eldora Ski Resort, w/ easy access to Denver & Denver Int'l Airport, this private sanctuary offers unmatched year-round recreation, breathtaking vistas, abundant wildlife & endless possibilities. Palacio Celestial awaits its next chapter, bring your vision & make it a reality!

470 Weaver Dr, Boulder

1344 Weaver Dr Unit & 470, Boulder

Welcome to Palacio Celestial! A Legacy Mountain Estate Bordering Betasso Preserve. Set on over 77 acres across 2 legal lots, just 10 minutes from downtown Boulder and the future home of the Sundance Film Festival, this irreplaceable estate offers unparalled city and mountain views & directly borders Betasso Preserve for approx. 1/4 mile, delivering unmatched privacy & direct, private access to some of Colorado's best Biking and hiking trails on protected open space. The main residence is a gated 8,626 sq ft log estate with grandfathered status, an improvement of this scale that cannot be replicated under current regulations. Renovate, reimagine, or expand within its existing footprint, but the foundation of this legacy home is finite and protected. The property includes 2 parcels, with the 2nd lot unbuilt & offering potential for a guest house, second residence, or future development vision (subject to approval). Private access connects directly into one of the Front Range's most celebrated trail systems, no trailhead parking, no crowds, just your land meeting wilderness. Features include a 44' pool, four-stall horse barn, waterfall, detached three-car garage with hay storage, and 19kW photovoltaic solar system. Expansive views span from Boulder city lights to dramatic mountain ridgelines. Wildlife moves freely through the land, reinforcing a true sense of mountain immersion. 3 Additional adjoining parcels are available, offering the incredible opportunity for approximately 229 contiguous acres. See 79 Weaver Dr. and 1327 & 1433 Weaver Dr. See map in Photos

4 Beds ⋅ 6 Baths ⋅ 1070660 MLS ⋅ ACTIVE Status

Welcome to Palacio Celestial! A Legacy Mountain Estate Bordering Betasso Preserve. Set on over 77 acres across 2 legal lots, just 10 minutes from downtown Boulder and the future home of the Sundance Film Festival, this irreplaceable estate offers unparalled city and mountain views & directly borders Betasso Preserve for approx. 1/4 mile, delivering unmatched privacy & direct, private access to some of Colorado's best Biking and hiking trails on protected open space. The main residence is a gated 8,626 sq ft log estate with grandfathered status, an improvement of this scale that cannot be replicated under current regulations. Renovate, reimagine, or expand within its existing footprint, but the foundation of this legacy home is finite and protected. The property includes 2 parcels, with the 2nd lot unbuilt & offering potential for a guest house, second residence, or future development vision (subject to approval). Private access connects directly into one of the Front Range's most celebrated trail systems, no trailhead parking, no crowds, just your land meeting wilderness. Features include a 44' pool, four-stall horse barn, waterfall, detached three-car garage with hay storage, and 19kW photovoltaic solar system. Expansive views span from Boulder city lights to dramatic mountain ridgelines. Wildlife moves freely through the land, reinforcing a true sense of mountain immersion. 3 Additional adjoining parcels are available, offering the incredible opportunity for approximately 229 contiguous acres. See 79 Weaver Dr. and 1327 & 1433 Weaver Dr. See map in Photos

1344 Weaver Dr Unit & 470, Boulder

307 Labelle Rd, Boulder

A private world of its own just 15 minutes above Boulder, 307 Labelle unfolds across over 14 acres with panoramic city views, exceptional craftsmanship and a sense of privacy increasingly hard to find this close to town. Mornings begin with coffee on the patio off the primary suite, afternoons are spent in the open air, and evenings end watching the lights of Boulder twinkle below. Inside, the home is warm, substantial and beautifully detailed, with hand-hewn beams and stone, copper-clad windows and doors, clear Sugar Pine trim, reclaimed oak, flagstone and travertine flooring, and 8-foot doorways that give the rooms drama and scale. A wood-burning fireplace with its own bread oven anchors the living space, while the gorgeous kitchen is equipped with Wolf, Sub-Zero, and Cove appliances, a commercial sink and polished granite countertops.The primary suite feels like its own retreat, with a separate entrance and easy outdoor access. Downstairs, a dedicated workout area and recreation space add flexibility and a little unexpected fun. Radiant in-floor heat, forced-air heating and air conditioning, two Buderus boilers, whole-house water filtration, HEPA filtration, Lutron lighting and heated bathroom floors make mountain living effortless year-round. Outside, covered patios, a cobblestone courtyard and radiant-heated stone terraces create beautiful places to gather, dine and take in the views. There is room to roam, garden and entertain, with forestry zoning allowing for up to four horses. A Generac generator, private well, oversized two-car garage, remote-controlled gate and stone outbuilding complete the property.What makes 307 Labelle so special is the combination: a true private estate surrounded by nature, yet close enough to Boulder that everyday life remains easy. Distinctive, beautifully built and deeply connected to its setting, this is mountain living at its best. Private road to home. Please do not drive up without appointment. LIVE BOLDER. LOVE BOULDER!

4 Beds ⋅ 5 Baths ⋅ 1069478 MLS ⋅ ACTIVE Status

A private world of its own just 15 minutes above Boulder, 307 Labelle unfolds across over 14 acres with panoramic city views, exceptional craftsmanship and a sense of privacy increasingly hard to find this close to town. Mornings begin with coffee on the patio off the primary suite, afternoons are spent in the open air, and evenings end watching the lights of Boulder twinkle below. Inside, the home is warm, substantial and beautifully detailed, with hand-hewn beams and stone, copper-clad windows and doors, clear Sugar Pine trim, reclaimed oak, flagstone and travertine flooring, and 8-foot doorways that give the rooms drama and scale. A wood-burning fireplace with its own bread oven anchors the living space, while the gorgeous kitchen is equipped with Wolf, Sub-Zero, and Cove appliances, a commercial sink and polished granite countertops.The primary suite feels like its own retreat, with a separate entrance and easy outdoor access. Downstairs, a dedicated workout area and recreation space add flexibility and a little unexpected fun. Radiant in-floor heat, forced-air heating and air conditioning, two Buderus boilers, whole-house water filtration, HEPA filtration, Lutron lighting and heated bathroom floors make mountain living effortless year-round. Outside, covered patios, a cobblestone courtyard and radiant-heated stone terraces create beautiful places to gather, dine and take in the views. There is room to roam, garden and entertain, with forestry zoning allowing for up to four horses. A Generac generator, private well, oversized two-car garage, remote-controlled gate and stone outbuilding complete the property.What makes 307 Labelle so special is the combination: a true private estate surrounded by nature, yet close enough to Boulder that everyday life remains easy. Distinctive, beautifully built and deeply connected to its setting, this is mountain living at its best. Private road to home. Please do not drive up without appointment. LIVE BOLDER. LOVE BOULDER!

307 Labelle Rd, Boulder

487 Millionaire Dr, Boulder

Spectacular, breathtaking VIEWS from one of the best lots on Sugarloaf, just 15 minutes from downtown Boulder! Enjoy epic sunsets from the private deck or through the living room's tall S-facing windows. This foothills retreat offers 3 bedrooms plus a bonus 3rd floor loft with bath - ideal for a home office/4th bedroom. The finished lower level features a family room with fireplace, theater room, large bedroom, and adjoining year-round sunroom and sauna to enjoy the views. Thoughtful upgrades include upgraded baths, 3 mini-splits for year-round comfort, Tesla solar panels with battery backup ( super LOW utility bills!) Tesla car charger, refreshed flooring, updated decks, smart-home features, and fiber-optic gigabit internet availability. Nestled within Roosevelt Nat'l Forest, the property offers exceptional access to hiking, biking, trail running, and winter recreation, with a nearby 2-mile singletrack loop and Betasso Preserve, Switzerland Trail, Sugarloaf Mountain, and Mountain Meadows/Tiger Gulch just minutes away. 2026 Wildfire Partners Certified, with HOA-covered road grading and snow removal. The best of foothills living-outdoor adventure, Boulder just minutes away, and views that never get old!

3 Beds ⋅ 3 Baths ⋅ 5187606 MLS ⋅ ACTIVE Status

Spectacular, breathtaking VIEWS from one of the best lots on Sugarloaf, just 15 minutes from downtown Boulder! Enjoy epic sunsets from the private deck or through the living room's tall S-facing windows. This foothills retreat offers 3 bedrooms plus a bonus 3rd floor loft with bath - ideal for a home office/4th bedroom. The finished lower level features a family room with fireplace, theater room, large bedroom, and adjoining year-round sunroom and sauna to enjoy the views. Thoughtful upgrades include upgraded baths, 3 mini-splits for year-round comfort, Tesla solar panels with battery backup ( super LOW utility bills!) Tesla car charger, refreshed flooring, updated decks, smart-home features, and fiber-optic gigabit internet availability. Nestled within Roosevelt Nat'l Forest, the property offers exceptional access to hiking, biking, trail running, and winter recreation, with a nearby 2-mile singletrack loop and Betasso Preserve, Switzerland Trail, Sugarloaf Mountain, and Mountain Meadows/Tiger Gulch just minutes away. 2026 Wildfire Partners Certified, with HOA-covered road grading and snow removal. The best of foothills living-outdoor adventure, Boulder just minutes away, and views that never get old!

487 Millionaire Dr, Boulder

Listings courtesy of Information and Real Estate Services, LLC as distributed by MLS GRID.

Based on information submitted to the MLS GRID as of . All data is obtained from various sources and may not have been verified by broker of MLS GRID. Supplied Open House Information is subject to change without notice. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information. Some listings have been excluded from this website.

How much is your home worth?

Get instant property value now!