Welcome home to this exceptional 5-bedroom, 4-bath ranch-style home with a massive 4-car garage in the gated community of Overlook at Mariana, ideally situated on a quiet cul-de-sac where true Colorado living takes center stage. Inside, the thoughtfully designed open-concept layout features soaring ceilings, expansive windows, and abundant natural light that showcase sweeping Rocky Mountain views. The living room is anchored by a striking floor-to-ceiling fireplace, while oversized windows flood the space with light and frame the surrounding scenery. The spacious living area flows seamlessly into a well-appointed gourmet kitchen featuring granite countertops, a large pantry, and a convection range with gas connection behind should you choose to switch back. Ample counter space and a convenient breakfast bar make the space ideal for both everyday living and entertaining. A covered deck extends the living space outdoors, offering the perfect setting for relaxed morning coffee or alfresco dining while enjoying the wildlife that frequently visits the area. The landscaping has been thoughtfully designed with future privacy in mind, with strategic plantings that will mature into natural screening over time. An expansive 4-car garage provides exceptional space for vehicles, storage, and all your gear. Enjoy unmatched access to Mariana Butte Golf Course, nearby trails, and Boedecker Lake, offering year-round opportunities for recreation and relaxation. This is a prime opportunity to own in one of Loveland's premier gated communities, combining privacy, views, and the best of Foothills living.
Sold for $922,450
$922,450
5602 Red Thunder Ct, Loveland, CO 80537
5beds
4,092sqft
Single Family Residence
Built in 2018
0.28 Acres Lot
$922,400 Zestimate®
$225/sqft
$3,904 Estimated rent
Home value
$922,400
$876,000 - $969,000
$3,904/mo
Zestimate® history
Owner options
List your home for rent
$3,904/mo
Rent Zestimate®
Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.
$3,904/mo
Rent Zestimate®
Refinance and save
$4,450/mo
Est. payment
Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.
$4,450/mo
Est. payment
Explore your selling options
Work with a Zillow partner agent
Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.
Get startedList with your own agent
Get your home in front of millions of buyers by listing it on Zillow.
Learn how to do itSell it yourself
Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).
List your homeWhat's special
Sweeping rocky mountain viewsLarge pantryGranite countertopsThoughtfully designed open-concept layoutExpansive windowsAbundant natural lightAmple counter space
Zillow last checked:
Listing updated:
Listed by:
Aimee Helminiak 970-617-5042,
Coldwell Banker Realty- Fort Collins
Bought with:
Aimee Helminiak, 100110862
Coldwell Banker Realty- Fort Collins
Source: IRES as distributed by MLS GRID,MLS#: 1055567
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 5
- Bathrooms: 4
- Full bathrooms: 3
- 1/2 bathrooms: 1
- Main level bathrooms: 3
Primary bedroom
- Description: Wood
- Features: Full Primary Bath
- Level: Main
- Area: 294 Square Feet
- Dimensions: 21 x 14
Bedroom 2
- Description: Wood
- Level: Main
- Area: 192 Square Feet
- Dimensions: 16 x 12
Bedroom 3
- Description: Wood
- Level: Main
- Area: 143 Square Feet
- Dimensions: 13 x 11
Bedroom 4
- Description: Carpet
- Level: Basement
- Area: 169 Square Feet
- Dimensions: 13 x 13
Bedroom 5
- Description: Carpet
- Level: Basement
- Area: 196 Square Feet
- Dimensions: 14 x 14
Dining room
- Description: Wood
- Level: Main
- Area: 156 Square Feet
- Dimensions: 12 x 13
Kitchen
- Description: Wood
- Level: Main
- Area: 169 Square Feet
- Dimensions: 13 x 13
Laundry
- Description: Luxury Vinyl
- Level: Main
- Area: 77 Square Feet
- Dimensions: 7 x 11
Living room
- Description: Wood
- Level: Main
- Area: 374 Square Feet
- Dimensions: 22 x 17
Recreation room
- Description: Carpet
- Area: 609 Square Feet
- Dimensions: 21 x 29
Heating
- Forced Air
Cooling
- Central Air, Ceiling Fan(s)
Appliances
- Included: Electric Range, Dishwasher, Refrigerator, Microwave, Disposal
- Laundry: Washer/Dryer Hookup
Features
- Eat-in Kitchen, Separate Dining Room, Cathedral Ceiling(s), Open Floorplan, Pantry, Walk-In Closet(s), Kitchen Island, High Ceilings
- Doors: French Doors
- Windows: Window Coverings
- Basement: Partially Finished
- Has fireplace: Yes
- Fireplace features: Gas, Gas Log, Living Room
Interior area
- Total structure area: 2,046
- Total interior livable area: 4,092 sqft
- Finished area above ground: 2,046
Property
Parking
- Total spaces: 4
- Parking features: Garage Door Opener, Attached, Oversized, Tandem
- Attached garage spaces: 4
- Details: Attached
Accessibility
- Accessibility features: Main Floor Bath, Accessible Bedroom, Main Level Laundry
Features
- Levels: One
- Stories: 1
- Patio & porch: Patio, Deck
- Exterior features: Sprinkler System
- Fencing: Partial,Metal
- Has view: Yes
- View description: Hills
Lot
- Size: 0.28 Acres
- Features: Cul-De-Sac, Paved, Curbs, Street Light, Fire Hydrant within 500 Feet
Details
- Parcel number: R1644207
- Zoning: R1
- Special conditions: Private Owner
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Contemporary
- Property subtype: Single Family Residence
Materials
- Frame, Stone, Stucco
- Roof: Composition
Condition
- New construction: No
- Year built: 2018
Details
- Builder name: Custom On-Site Builders
Utilities & green energy
- Electric: City of Loveland
- Gas: Xcel Energy
- Sewer: Public Sewer
- Water: City
- Utilities for property: Natural Gas Available, Electricity Available, High Speed Avail
Green energy
- Energy efficient items: Southern Exposure, Windows
Community & HOA
Community
- Features: Trail(s), Gated
- Security: Fire Alarm
- Subdivision: Overlook At Mariana 1st Sub Lov
HOA
- Has HOA: Yes
- Services included: Common Amenities, Utilities
- HOA fee: $150 monthly
Location
- Region: Loveland
Financial & listing details
- Price per square foot: $225/sqft
- Tax assessed value: $979,600
- Annual tax amount: $4,702
- Date on market: 4/3/2026
- Listing terms: Cash,Conventional
- Exclusions: Seller's Personal Property
- Electric utility on property: Yes
- Road surface type: Asphalt
Price history
| Date | Event | Price |
|---|---|---|
| 7/24/2026 | Sold | $922,450-2.8%$225/sqft |
Source:  IRES as distributed by MLS GRID #1055567 Report a problem | ||
| 6/15/2026 | Pending sale | $949,500$232/sqft |
Source:  REcolorado as distributed by MLS GRID #IR1055567 Report a problem | ||
| 6/4/2026 | Price change | $949,500-1.9%$232/sqft |
Source: IRES as distributed by MLS GRID #1055567 Report a problem | ||
| 5/16/2026 | Price change | $968,000-0.2%$237/sqft |
Source: IRES as distributed by MLS GRID #1055567 Report a problem | ||
| 4/13/2026 | Pending sale | $970,000$237/sqft |
Source: REcolorado as distributed by MLS GRID #IR1055567 Report a problem | ||
| 4/3/2026 | Listed for sale | $970,000+19%$237/sqft |
Source: IRES as distributed by MLS GRID #1055567 Report a problem | ||
| 8/11/2023 | Sold | $815,000-3%$199/sqft |
Source: IRES as distributed by MLS GRID #983125 Report a problem | ||
| 6/24/2023 | Price change | $839,950-1.2%$205/sqft |
Source: IRES as distributed by MLS GRID #983125 Report a problem | ||
| 4/24/2023 | Listed for sale | $849,900$208/sqft |
Source: IRES as distributed by MLS GRID #983125 Report a problem | ||
| 4/15/2023 | Pending sale | $849,900$208/sqft |
Source: IRES as distributed by MLS GRID #983125 Report a problem | ||
| 4/10/2023 | Price change | $849,900-5.6%$208/sqft |
Source: IRES as distributed by MLS GRID #983125 Report a problem | ||
| 3/10/2023 | Listed for sale | $900,000+20.2%$220/sqft |
Source: IRES as distributed by MLS GRID #983125 Report a problem | ||
| 9/13/2020 | Listing removed | $749,000$183/sqft |
Source: Keller Williams 1st Realty #6948382 Report a problem | ||
| 7/29/2020 | Price change | $749,000-3.4%$183/sqft |
Source: Keller Williams 1st Realty #918839 Report a problem | ||
| 7/28/2020 | Price change | $775,000-3%$189/sqft |
Source: Keller Williams 1st Realty #918839 Report a problem | ||
| 7/21/2020 | Listed for sale | $799,000+16.2%$195/sqft |
Source: Keller Williams 1st Realty #918839 Report a problem | ||
| 9/24/2018 | Sold | $687,500+6.7%$168/sqft |
Source: Public Record Report a problem | ||
| 5/2/2018 | Listed for sale | $644,365$157/sqft |
Source: RE/MAX Alliance-FTC South #848739 Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | $4,702 +15.7% | $61,225 +12.1% |
| 2024 | $4,064 +3.9% | $54,605 -13.5% |
| 2023 | $3,910 -2.7% | $63,118 +28.5% |
| 2022 | $4,018 +4.8% | $49,137 -5.7% |
| 2021 | $3,832 +1.7% | $52,131 +8.2% |
| 2020 | $3,768 +1.8% | $48,198 -15.2% |
| 2019 | $3,699 | $56,844 +26.5% |
| 2018 | $3,699 | $44,950 |
| 2017 | $3,699 +16.1% | $44,950 +144.5% |
| 2016 | $3,186 +138.2% | $18,386 0% |
| 2015 | $1,337 +16.6% | $18,390 +20.6% |
| 2014 | $1,147 | $15,250 +111.2% |
| 2013 | -- | $7,220 +97.8% |
| 2012 | -- | $3,650 |
| 2011 | -- | $3,650 -64.6% |
| 2010 | -- | $10,320 |
| 2009 | -- | $10,320 +0.8% |
| 2008 | -- | $10,240 |
Find assessor info on the county website
Neighborhood: 80537
Nearby homes
- $961,5003 bd2 ba2.1k sqft5601 Red Thunder Ct, Loveland, CO 80537Off Market
- $835,0002 bd3 ba3.8k sqft5626 Red Thunder Ct, Loveland, CO 80537Sold
- $1,096,9003 bd3 ba4.5k sqft5625 Red Thunder Ct, Loveland, CO 80537Off Market
- $960,0004 bd4 ba3.8k sqft5649 Red Thunder Ct, Loveland, CO 80537Sold
- $945,3005 bd1 ba3.8k sqft5650 Red Thunder Ct, Loveland, CO 80537Off Market
- $1,017,2004 bd3 ba3.6k sqft145 N Cove Dr, Loveland, CO 80537Off Market
- $1,014,0004 bd2 ba2k sqft207 N Cove Dr, Loveland, CO 80537Off Market
- $773,3005 bd4 ba3.8k sqft5586 Stone Church Ct, Loveland, CO 80537Off Market
Nearby schools
GreatSchools rating
- 4/10Namaqua Elementary SchoolGrades: K-5Distance: 1.4 mi
- 5/10Walt Clark Middle SchoolGrades: 6-8Distance: 2.2 mi
- 6/10Thompson Valley High SchoolGrades: 9-12Distance: 2.8 mi
Schools provided by the listing agent
- Elementary: Namaqua
- Middle: Walt Clark
- High: Thompson Valley
Source: IRES as distributed by MLS GRID. 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
$922,400
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
$922,400
- Colorado
- Larimer County
- Loveland
- 80537
- 5602 Red Thunder Ct
Nearby cities
Nearby zip codes
Other Loveland Topics
