Stunning Rebuilt Modern Foothill Retreat with a complete custom rebuild in 2022. Significant short term Rental Income Opportunity w/ADU! Nestled behind the iconic Devil's Backbone in Loveland on a private half acre, you can enjoy tranquil, expansive views just minutes from Loveland, 10 min to Fort Collins/Horsetooth & 30 min to Estes Park. Enjoy peace of mind with every major component replaced in 2022 - including a Class 4 shingle roof, windows, decks, concrete, A/C, Furnace, water heater, etc. The interior was completely rebuilt from the studs; with top grade construction and high quality modern features - including new floors, cabinets, countertops, bathrooms, appliances, and more. The property has been permitted by Larimer County for short-term rental use; providing a rare opportunity for income potential - both as a bed&breakfast personal residence; or a full STR investment property. 3 car detached garage & an additional detached12x18 finished studio unit. The lower level walkout basement offers a complete separate 2 bed living space w/a kitchenette; perfect for guest accommodations. Ideal location near Sweetheart Winery, Centerra shopping, hiking and access to the canyon and mountains. Upstairs you'll find 2 more bedrooms, sunroom, open floor plan living room & kitchen. Tons of windows flood the home with natural sunlight. City water, no well, NO HOA or Metro, septic & propane. Other highlights include Red Oak Wood flooring, a gorgeous high-efficient wood burning stove, custom white cabinetry, quartz countertops, expansive TREX deck. Backyard with new enclosed fence; and another turf yard. Additional privacy and seclusion from a long driveway, and room to park your boat & other toys.
Sold for $838,500
$838,500
3064 Wildes Road, Loveland, CO 80538
4beds
2,376sqft
Single Family Residence
Built in 1974
0.5 Acres Lot
$834,600 Zestimate®
$353/sqft
$2,595 Estimated rent
Home value
$834,600
$793,000 - $876,000
$2,595/mo
Zestimate® history
Loading...
Owner options
Explore your selling options
What's special
Zillow last checked: 8 hours ago
Listing updated: January 07, 2026 at 10:55am
Listed by:
Cassie Purdy 303-548-7896 cassiepurdyhomes@gmail.com,
eXp Realty, LLC
Bought with:
Christie Duggar, 100037781
Group Harmony
Source: REcolorado,MLS#: 3428438
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 2
- Full bathrooms: 2
- Main level bathrooms: 1
- Main level bedrooms: 1
Bedroom
- Level: Upper
Bedroom
- Description: 2nd Bedroom Main Floor
- Features: Primary Suite
- Level: Main
Bedroom
- Level: Basement
Bedroom
- Features: Primary Suite
- Level: Basement
Bathroom
- Description: Full Bathroom With Shower Main Level
- Features: Primary Suite
- Level: Main
Bathroom
- Level: Basement
Great room
- Level: Basement
Kitchen
- Level: Main
Kitchen
- Description: Kitchenette Minus Stove In Basement
Laundry
- Level: Basement
Living room
- Level: Main
Utility room
- Level: Basement
Heating
- Forced Air, Propane
Cooling
- Central Air
Appliances
- Included: Dishwasher, Disposal, Dryer, Gas Water Heater, Microwave, Oven, Range, Range Hood, Refrigerator, Washer
- Laundry: In Unit
Features
- Ceiling Fan(s), Eat-in Kitchen, Entrance Foyer, High Ceilings, Kitchen Island, Open Floorplan, Quartz Counters, Radon Mitigation System, Smoke Free, Stone Counters, Vaulted Ceiling(s), Walk-In Closet(s), Wet Bar
- Flooring: Carpet, Tile, Wood
- Windows: Double Pane Windows, Window Coverings
- Basement: Finished,Full,Walk-Out Access
- Number of fireplaces: 1
- Fireplace features: Living Room, Wood Burning
Interior area
- Total structure area: 2,376
- Total interior livable area: 2,376 sqft
- Finished area above ground: 1,296
- Finished area below ground: 1,080
Property
Parking
- Total spaces: 2
- Parking features: Garage
- Garage spaces: 2
Features
- Levels: Two
- Stories: 2
- Patio & porch: Covered, Deck, Patio, Wrap Around
- Exterior features: Balcony, Garden, Private Yard
- Fencing: Full
- Has view: Yes
- View description: Meadow, Mountain(s), Valley
Lot
- Size: 0.50 Acres
- Features: Foothills, Irrigated, Landscaped, Level, Meadow, Sprinklers In Front, Sprinklers In Rear
Details
- Parcel number: R0423084
- Zoning: FA1
- Special conditions: Standard
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Contemporary
- Property subtype: Single Family Residence
Materials
- Concrete, Frame, Wood Siding
- Foundation: Block, Structural
- Roof: Composition
Condition
- Updated/Remodeled
- Year built: 1974
Utilities & green energy
- Electric: 220 Volts
- Water: Public
- Utilities for property: Cable Available, Electricity Connected, Internet Access (Wired), Propane
Community & neighborhood
Security
- Security features: Carbon Monoxide Detector(s), Smoke Detector(s)
Location
- Region: Loveland
- Subdivision: Outside City Limits
Other
Other facts
- Listing terms: Cash,Conventional,FHA,Jumbo,Other,USDA Loan,VA Loan
- Ownership: Individual
Price history
| Date | Event | Price |
|---|---|---|
| 1/5/2026 | Sold | $838,500-1.4%$353/sqft |
Source:  REcolorado #3428438 Report a problem | ||
| 12/23/2025 | Pending sale | $850,000$358/sqft |
Source: eXp Realty #3428438 Report a problem | ||
| 12/16/2025 | Contingent | $850,000$358/sqft |
Source: eXp Realty #3428438 Report a problem | ||
| 12/8/2025 | Pending sale | $850,000$358/sqft |
Source: REcolorado #3428438 Report a problem | ||
| 11/13/2025 | Price change | $850,000-2.9%$358/sqft |
Source: REcolorado #3428438 Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2024 | $3,138 +22.4% | $43,617 -1% |
| 2023 | $2,565 +14.3% | $44,041 +35.4% |
| 2022 | $2,243 +42.7% | $32,527 +14% |
Find assessor info on the county website
Neighborhood: 80538
Nearby schools
GreatSchools rating
- 7/10Big Thompson Elementary SchoolGrades: K-5Distance: 0.5 mi
- 5/10Walt Clark Middle SchoolGrades: 6-8Distance: 4.6 mi
- 6/10Thompson Valley High SchoolGrades: 9-12Distance: 4.9 mi
Schools provided by the listing agent
- Elementary: Big Thompson
- Middle: Walt Clark
- High: Thompson Valley
- District: Thompson R2-J
Source: REcolorado. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value$834,600
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$834,600