NOT LISTED FOR SALE

405 Red Sunset Place Loveland, CO 80538

Estimated Value: $486,632 - $501,000

4 Beds
2 Baths
1,775 Sq Ft
$279/Sq Ft Est. Value

Last Sold November 21, 2024

Last sale price $498,500 $281 Per Sq Ft

Est. 1% decrease in value since last sale

Current estimated payment $2,918/month

27 Days on Market

Highlights

  • Primary Bedroom Suite
  • Deck
  • Vaulted Ceiling
  • Open Floorplan
  • Contemporary Architecture
  • Corner Lot

About This Home

As of November 2024

Welcome to this bright and open ranch style home with four bedrooms and two bathrooms, situated on nearly a quarter acre, corner lot, and ready to call home!  When you step inside the entryway, you can't help but notice the vaulted ceilings that connect the large living space to the very functional and open kitchen. Updated appliances compliment the breakfast nook and ample storage space. The adjacent dining area flows seamlessly to the lush patio and large wrap around yard that is perfect for entertaining and those summer barbeques.  Fire pit and grill included! Upstairs are three bedrooms and a full bathroom all situated next to the primary suite complete with a walk-in closet and en-suite bathroom.  The basement has one finished bedroom with a walk-in closet, and the rest remains unfinished for expansion, storage, or game room!  The most important thing about this listing is NO HOA, NO METRO DISTRICT, and the pull through RV parking on the side of the home! Stop paying for storage and association fees and schedule your showing today!

Last Listed By

Jon Paul Matzke

Blue Yeti Homes Brokerage Email: jonpaulmatzke@gmail.com,970-412-1956 License #100079526 Listed on: 10/04/2024

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $1,903

Year Built

  • Built in 1997

Lot Details

  • 9,246 Sq Ft Lot
  • Cul-De-Sac
  • East Facing Home
  • Dog Run
  • Property is Fully Fenced
  • Landscaped
  • Corner Lot
  • Level Lot
  • Irrigation
  • Garden
  • Property is zoned R1

Parking

  • 2 Car Attached Garage

Home Design

  • Contemporary Architecture
  • Frame Construction
  • Tar and Gravel Roof
  • Composition Roof

Interior Spaces

  • 1-Story Property
  • Open Floorplan
  • Furnished or left unfurnished upon request
  • Vaulted Ceiling
  • Ceiling Fan
  • Window Treatments
  • Smart Doorbell
  • Living Room with Fireplace
  • Dining Room

Kitchen

  • Eat-In Kitchen
  • Oven
  • Range
  • Microwave
  • Dishwasher
  • Laminate Countertops
  • Disposal

Flooring

  • Carpet
  • Laminate
  • Tile

Bedrooms and Bathrooms

  • 4 Bedrooms | 3 Main Level Bedrooms
  • Primary Bedroom Suite
  • Walk-In Closet
  • 2 Full Bathrooms

Laundry

  • Laundry Room
  • Dryer
  • Washer

Finished Basement

  • Partial Basement
  • Bedroom in Basement
  • 1 Bedroom in Basement

Home Security

  • Carbon Monoxide Detectors
  • Fire and Smoke Detector

Eco-Friendly Details

  • Smoke Free Home

Outdoor Features

  • Deck
  • Fire Pit
  • Exterior Lighting
  • Outdoor Gas Grill
  • Rain Gutters
  • Front Porch

Schools

  • Peakview Academy At Conrad Ball Elementary School
  • Conrad Ball Middle School
  • Loveland High School

Utilities

  • Forced Air Heating and Cooling System
  • 220 Volts
  • 110 Volts
  • Natural Gas Connected
  • High Speed Internet

Community Details

  • No Home Owners Association
  • Evergreen Meadows West Subdivision

Listing and Financial Details

  • Exclusions: Seller's Personal Property.
  • Assessor Parcel Number R1485334

Home Details

Home Type

Single Family

Est. Annual Taxes

$1,903

Year Built

Built in 1997

Lot Details

0

Parking

2

Listing Details

  • Property Type: Residential
  • Property Sub Type: Single Family Residence
  • Architectural Style: Contemporary
  • Structure Type: House
  • Levels: One
  • Year Built: 1997
  • Above Grade Finished Sq Ft: 1440
  • Current Use: Live/Work
  • Exclusions: Seller's Personal Property.
  • Living Area: 1775
  • SubdivisionName: Evergreen Meadows West
  • Ownership: Individual
  • Property Attached Yn: No
  • ResoBuildingAreaSource: PublicRecords
  • REC_BasementLevelBathrooms: 0
  • REC_BasementLevelBedrooms: 1
  • REC_BelowGradeUnfinishedArea: 1091.00
  • REC_RVSpaces: 0
  • REC_UpperLevelBathrooms: 0
  • REC_UpperLevelBedrooms: 0
  • REC_WaterIncludedYN: 1
  • Ratio Close Price By Original Li: 1.00000
  • Attribution Contact: jonpaulmatzke@gmail.com,970-412-1956
  • Special Features: None

Interior Features

  • Appliances: Dishwasher, Disposal, Dryer, Microwave, Oven, Range, Refrigerator, Washer
  • Fireplaces: 1
  • Interior Amenities: Ceiling Fan(s), Eat-in Kitchen, Five Piece Bath, High Ceilings, Laminate Counters, Open Floorplan, Pantry, Primary Suite, Smoke Free, Vaulted Ceiling(s), Walk-In Closet(s)
  • Flooring: Carpet, Laminate, Tile
  • Fireplace Features: Living Room
  • Full Bathrooms: 2
  • Basement: Finished, Partial
  • Basement: Yes
  • Total Bedrooms: 4
  • Below Grade Sq Ft: 335
  • Main Level Bathrooms: 2
  • Main Level Bedrooms: 3
  • Window Features: Window Coverings, Window Treatments

Exterior Features

  • Direction Faces: East
  • Roof: Composition, Tar/Gravel
  • Construction Materials: Frame
  • Exterior Features: Dog Run, Fire Pit, Garden, Gas Grill, Lighting, Rain Gutters
  • Patio and Porch Features: Deck, Front Porch
  • Road Frontage Type: Public
  • Road Surface Type: Paved

Garage/Parking

  • Attached Garage: Yes
  • Garage Spaces: 2
  • Total Parking Spaces: 2
  • REC_ParkingCount: 1

Utilities

  • Utilities: Electricity Connected, Internet Access (Wired), Natural Gas Connected, Phone Connected
  • Sewer: Public Sewer
  • Cooling: Central Air
  • Heating: Forced Air
  • Water Source: Public
  • Electric: 110V, 220 Volts
  • Security: Carbon Monoxide Detector(s), Smoke Detector(s), Video Doorbell

Condo/Co-op/Association

  • Association: No
  • Senior Community: No

Association/Amenities

  • REC_AssociationFee2Annual: 0.00
  • REC_AssociationFee3Annual: 0.00
  • REC_AssociationFeeAnnual: 0.00
  • REC_AssociationFeeTotalAnnual: 0.00
  • REC_MultipleAssociationsYN: 0

Schools

  • Middle Or Junior School: Conrad Ball

Lot Info

  • Horses: No
  • Parcel Number: R1485334
  • Lot Size Acres: 0.21
  • Fencing: Full
  • Building Area Total: 2866
  • Lot Features: Corner Lot, Cul-De-Sac, Irrigated, Landscaped, Level
  • Lot Size Sq Ft: 9246
  • ResoLotSizeUnits: SquareFeet

Rental Info

  • Furnished: Negotiable

Multi Family

  • Number Of Units Total: 1

Tax Info

  • Tax Year: 2023
  • Tax Annual Amount: 1903

MLS Schools

  • Elementary School: Peakview Academy at Conrad Ball
  • High School: Loveland

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Oct 4, 2024
Closed on
Nov 21, 2024
Sold by
Matzke Paul E and Matzke Sandra J
Bought by
Heidmann Nick and Heidmann Hollie
Seller's Agent
Jon Paul Matzke
Blue Yeti Homes
Buyer's Agent
Nathaniel Duff
The Group Inc - Harmony
List Price
$498,500
Sold Price
$498,500
Total Days on Market
27
Views
64
Current Estimated Value
$494,408

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
-$4,092
Avg. Annual Appreciation
-1.11%
Original Mortgage
$473,575
Outstanding Balance
$472,238
Interest Rate
6.32%
Mortgage Type
New Conventional
Estimated Equity
$23,928

Purchase Details

Closed on
Aug 23, 2002
Sold by
Branscum Blain N and Branscum Erica S
Bought by
Matzke Paul E and Matzke Sandra J

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$43,200
Interest Rate
6.47%
Mortgage Type
Credit Line Revolving

Purchase Details

Closed on
Mar 7, 1997
Sold by
Wyatt Steven H
Bought by
Branscum Blain N and Branscum Erica S

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$137,250
Interest Rate
7.89%

Range of Values:

Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Purchase History

Date Buyer Sale Price Title Company
Heidmann Nick $498,500 None Listed On Document
Heidmann Nick $498,500 None Listed On Document
Matzke Paul E $216,000 Stewart Title
Branscum Blain N $144,500 Stewart Title
Wyatt Steven H -- Stewart Title
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Heidmann Nick $473,575
Closed Heidmann Nick $473,575
Previous Owner Matzke Paul E $204,225
Previous Owner Matzke Paul E $230,400
Previous Owner Matzke Paul E $43,200
Previous Owner Matzke Paul E $172,800
Previous Owner Branscum Blain N $140,800
Previous Owner Branscum Blain N $137,250
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
11/21/2024 11/21/24 Sold $498,500 0.0% $281 / Sq Ft
10/04/2024 10/04/24 For Sale $498,500 -- $281 / Sq Ft
Source: REcolorado®

Tax History Compared to Growth

Source: Public Records

Tax History

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2025 $1,903 $35,108 $3,216 $31,892
2024 $1,903 $35,108 $3,216 $31,892
2022 $2,055 $25,826 $3,336 $22,490
2021 $2,112 $26,569 $3,432 $23,137
2020 $1,914 $24,074 $3,432 $20,642
2019 $1,882 $24,074 $3,432 $20,642
2018 $1,769 $21,499 $3,456 $18,043
2017 $1,524 $21,499 $3,456 $18,043
2016 $1,555 $21,206 $3,821 $17,385
2015 $1,543 $21,200 $3,820 $17,380
2014 $1,378 $18,320 $3,820 $14,500
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Similar Homes in the area

  • 3106 Marshall Ash Dr, Loveland, CO 80538

    $500,000

    • 4 Beds
    • 3.5 Baths
    • 2,093 Sq Ft
    • 3106 Marshall Ash Dr
    • Loveland, CO

    Check out this 4 bed, 4 bath home nestled in the established Devers Subdivision with No HOA! This wonderful home features a family room, spacious kitchen, separate dinning room, living room, washer and dryer hookups and a half bathroom. Head upstairs and find 2 bedrooms, 1 bathroom and the master suite with a private, newly updated master bathroom! Head downstairs to the finished basement for the

    Jennifer Kelly Keller Williams Realty NoCo

    Section Image
  • 3775 Sheridan Ave, Loveland, CO 80538

    $448,000

    • 3 Beds
    • 1 Bath
    • 1,368 Sq Ft
    • 3775 Sheridan Ave
    • Loveland, CO

    Beyond immaculate! This super cute 3 bedroom, 1 bath home has been lovingly cared for with an enclosed sun porch and an oversized 2 car garage. New roof 2018, updated 2020, new furnace & A/C 2018, radon system 2022, new kitchen with maple cabinets, stainless steel appliances, full tile backsplash, granite sink, newer flooring, updated bath including raised double sinks, new garage doors & opener,

    Stephanie Lane RE/MAX Alliance-Loveland

    Section Image
  • 3906 Ash Ave, Loveland, CO 80538

    $450,000

    • 4 Beds
    • 2 Baths
    • 2,073 Sq Ft
    • 3906 Ash Ave
    • Loveland, CO

    Located in a prime neighborhood with easy access to excellent schools, beautiful parks, and convenient shopping, this exceptional property delivers remarkable value with its generous square footage, versatile layout, and coveted location.Wonderful open floorplan featuring vaulted ceilings, large living room with fireplace, updated kitchen and warm family room. This four bed home is a gardeners

    Matthew Fugate The Fugate Property Group

    Section Image
  • 915 N Jefferson Ave, Loveland, CO 80537

    $609,000

    • 4 Beds
    • 2 Baths
    • 1,680 Sq Ft
    • 915 N Jefferson Ave
    • Loveland, CO

    Step back in time and embrace the allure of this 1926 Old Town Loveland charmer. This captivating residence seamlessly blends historic architectural details with modern conveniences, offering a truly unique living experience. Featuring four bedrooms and two bathrooms, this home boasts an open floor plan perfect for entertaining and everyday living. The gourmet kitchen is a chef's dream,

    Shawna Blair The Colorado RE Group LLC

    Section Image
  • 4675 Dillon Ave, Loveland, CO 80538

    $500,000

    • 3 Beds
    • 2 Baths
    • 1,498 Sq Ft
    • 4675 Dillon Ave
    • Loveland, CO

    Nestled in the desirable Harvest Gold neighborhood of Loveland, Colorado, 4675 Dillon Avenue offers a harmonious blend of comfort and convenience. This inviting ranch-style home features three bedrooms and two bathrooms, providing ample space for families and guests. The open-concept living area boasts high ceilings, creating an airy and spacious atmosphere. The well-appointed kitchen is equipped

    Jimmy Stewart Coldwell Banker Realty-NOCO

    Section Image
  • 2109 Blue Duck Dr, Loveland, CO 80537

    $525,000

    • 5 Beds
    • 3.5 Baths
    • 2,467 Sq Ft
    • 2109 Blue Duck Dr
    • Loveland, CO

    Welcome to 2109 Blue Duck Drive, Don't miss this 5-bedroom, 4-bathroom home nestled in a quiet, family-friendly neighborhood in Loveland, Colorado. With 2,467 square feet of thoughtfully designed living space, this home offers the perfect blend of comfort, functionality, and style. Step inside to discover a bright and open floor plan that flows seamlessly from room to room, ideal for both

    Jimmy Stewart Coldwell Banker Realty-NOCO

    Section Image
  • 3671 Hazelwood Ln, Johnstown, CO 80534

    $475,000

    • 3 Beds
    • 2.5 Baths
    • 1,810 Sq Ft
    • 3671 Hazelwood Ln
    • Johnstown, CO

    Check out this stunning modern home located in the desirable neighborhood of Thompsons River Ranch with easy access to top rated schools, shopping and dining. This breathtaking home is designed for both comfort and sophistication. Boasting three spacious bedrooms and three elegantly designed bathrooms, this property offers a blend of style and functionality. As you enter, you're greeted by an

    Tiffany Osborn Orchard Brokerage LLC

    Section Image
  • 3891 Jefferson Dr, Loveland, CO 80538

    $523,000

    • 4 Beds
    • 3.5 Baths
    • 2,409 Sq Ft
    • 3891 Jefferson Dr
    • Loveland, CO

    Welcome to this spacious and inviting home in a charming Loveland neighborhood!This beautifully maintained 4-bedroom, 3.5-bath home features vaulted ceilings, multiple living areas-including a living room, family room, and recreational room-and a 90% finished basement for added versatility.Outdoor living is just as appealing! Enjoy a generously sized wooden deck, a fully fenced backyard, and open

    Akriti Rai Adhikari Akriti Realty LLC

    Section Image
  • 3005 White Oak Ct, Loveland, CO 80538

    $515,000

    • 3 Beds
    • 2 Baths
    • 1,581 Sq Ft
    • 3005 White Oak Ct
    • Loveland, CO

    They don't build them like they used to! This beautifully maintained 1980 brick ranch blends classic craftsmanship with modern updates, offering both quality and character. Nestled on a quiet cul-de-sac, this home sits on a spacious lot with mature shade trees and includes a backyard shed for additional storage. Recent updates in 2024 include new exterior and interior paint and new hard surface

    The Sall Team C3 Real Estate Solutions, LLC

    Section Image

Source: REcolorado®

MLS Number: 6229840

REcolorado®

APN: 95013-92-001