NOT LISTED FOR SALE

Estimated Value: $780,000 - $869,717

6 Beds
4 Baths
4,102 Sq Ft
$203/Sq Ft Est. Value

Last Sold September 01, 2023

Last sale price $857,500 $209 Per Sq Ft

Est. 3% decrease in value since last sale

Current estimated payment $5,048/month

22 Days on Market

Highlights

  • Open Floorplan
  • Deck
  • Vaulted Ceiling
  • Flagstone Elementary School Rated A-
  • Contemporary Architecture
  • Wood Flooring

About This Home

As of September 2023

The total gem of Castlewood Ranch. This home has everything you can imagine and no expense spared. New floors, granite countertops with high end chizel cut edges, tons of cabinets and stainless steel appliance. Back deck spans the width of the house with a gas fire pit and separate outside eating area to entertain. Backyard includes a concrete basketball court, but could easily remove basketball goal and make a cool seating area. The main floor includes 3 bedrooms. The amazing master bedroom has a 5 piece bath and walk in closet. If you didn't already love the house, the basement will put you over the edge. This isn't just a basement with a big room and a couple bedrooms. This basement has an extremely elegant full wet bar with area for bar stools and kegerator. Turn those bar stools around and enjoy theater type seating and watch the game or favorite movie on the 100 inch big screen. All A/V equipment included. There is also an included coin op bar size pool table and three additional bedrooms and two bathrooms. This house is truly the most amazing house in Castlewood Ranch. Like I said, no expense spared. Come see for yourself. Once you see it, it's hard to compare any other house to the quality and elegance this house offers.

Last Agent to Sell the Property

Lance Becker

Stix & Stones Fine Colorado Properties LLC License #040024940 Listed on: 07/07/2023

Last Buyer's Agent

Greg Anderson

MB The Anderson Team LLC License #40002788

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $4,107

Year Built

  • Built in 2006 | Remodeled

Lot Details

  • 0.32 Acre Lot
  • Cul-De-Sac
  • East Facing Home
  • Property is Fully Fenced
  • Landscaped
  • Front and Back Yard Sprinklers
  • Private Yard

HOA Fees

  • $76 Monthly HOA Fees

Parking

  • 3 Car Attached Garage

Home Design

  • Contemporary Architecture
  • Frame Construction
  • Composition Roof

Interior Spaces

  • 1-Story Property
  • Open Floorplan
  • Wet Bar
  • Bar Fridge
  • Vaulted Ceiling
  • Ceiling Fan
  • Double Pane Windows
  • Family Room with Fireplace
  • Fire and Smoke Detector

Kitchen

  • Eat-In Kitchen
  • Self-Cleaning Oven
  • Range
  • Microwave
  • Dishwasher
  • Granite Countertops
  • Disposal

Flooring

  • Wood
  • Carpet

Bedrooms and Bathrooms

  • 6 Bedrooms | 3 Main Level Bedrooms
  • Walk-In Closet

Basement

  • Partial Basement
  • Bedroom in Basement
  • 3 Bedrooms in Basement

Eco-Friendly Details

  • Smoke Free Home

Outdoor Features

  • Deck
  • Fire Pit
  • Rain Gutters

Schools

  • Flagstone Elementary School
  • Mesa Middle School
  • Douglas County High School

Utilities

  • Forced Air Heating and Cooling System
  • Natural Gas Connected
  • Gas Water Heater
  • High Speed Internet

Community Details

  • Association fees include snow removal, trash
  • Castlewood Ranch Association, Phone Number (303) 841-8658
  • Castlewood Ranch Subdivision

Listing and Financial Details

  • Exclusions: Washer/Dryer
  • Assessor Parcel Number R0443480

Home Details

Home Type

Single Family

Est. Annual Taxes

$4,107

Year Built

Built in 2006 | Remodeled

Lot Details

0

HOA Fees

$76 per month

Parking

3

Listing Details

  • Property Type: Residential
  • Property Sub Type: Single Family Residence
  • Architectural Style: Contemporary
  • Structure Type: House
  • Levels: One
  • Year Built: 2006
  • Above Grade Finished Sq Ft: 2203
  • Exclusions: Washer/Dryer
  • Living Area: 4102
  • Property Condition: Updated/Remodeled
  • SubdivisionName: Castlewood Ranch
  • Ownership: Individual
  • ResoBuildingAreaSource: PublicRecords
  • REC_BasementLevelBathrooms: 2
  • REC_BasementLevelBedrooms: 3
  • REC_BelowGradeUnfinishedArea: 304.00
  • REC_ExpectedActiveDate: 2023-07-07
  • REC_RVSpaces: 0
  • REC_UpperLevelBathrooms: 0
  • REC_UpperLevelBedrooms: 0
  • REC_WaterIncludedYN: 1
  • Special Features: VirtualTour

Interior Features

  • Appliances: Bar Fridge, Dishwasher, Disposal, Gas Water Heater, Microwave, Range, Refrigerator, Self Cleaning Oven
  • Fireplaces: 1
  • Interior Amenities: Ceiling Fan(s), Eat-in Kitchen, Five Piece Bath, Granite Counters, High Ceilings, High Speed Internet, Open Floorplan, Pantry, Smoke Free, Vaulted Ceiling(s), Walk-In Closet(s), Wet Bar
  • Flooring: Carpet, Wood
  • Fireplace Features: Family Room
  • Full Bathrooms: 2
  • Basement: Partial
  • Basement: Yes
  • Three Quarter Bathrooms: 2
  • Total Bedrooms: 6
  • Below Grade Sq Ft: 1899
  • Main Level Bathrooms: 2
  • Main Level Bedrooms: 3
  • Window Features: Double Pane Windows

Exterior Features

  • Direction Faces: East
  • Roof: Composition
  • Construction Materials: Frame
  • Exterior Features: Fire Pit, Gas Valve, Private Yard, Rain Gutters
  • Patio and Porch Features: Deck
  • Road Frontage Type: Public
  • Road Surface Type: Paved

Garage/Parking

  • Parking Features: Concrete
  • Attached Garage: Yes
  • Garage Spaces: 3
  • Total Parking Spaces: 3
  • REC_ParkingCount: 1

Utilities

  • Utilities: Electricity Connected, Natural Gas Connected
  • Sewer: Public Sewer
  • Cooling: Central Air
  • Heating: Forced Air
  • Water Source: Public
  • Security: Smoke Detector(s)

Condo/Co-op/Association

  • HOA Fee Includes: Snow Removal, Trash
  • Association Name: Castlewood Ranch
  • Association Fee Frequency: Monthly
  • Association Fee: 76
  • Phone: 303-841-8658
  • Association: Yes
  • Senior Community: No

Association/Amenities

  • REC_AssociationFee2Annual: 0.00
  • REC_AssociationFee3Annual: 0.00
  • REC_AssociationFeeAnnual: 912.00
  • REC_AssociationFeeTotalAnnual: 912.00
  • REC_AssociationManagementType: Professionally Managed
  • REC_MultipleAssociationsYN: 0
  • REC_AssociationURL: http://www.castlewoodranch-hoa.com

Schools

  • Middle Or Junior School: Mesa

Lot Info

  • Horses: No
  • Parcel Number: R0443480
  • Lot Size Acres: 0.32
  • Fencing: Full
  • Building Area Total: 4406
  • Lot Features: Cul-De-Sac, Landscaped, Sprinklers In Front, Sprinklers In Rear
  • Lot Size Sq Ft: 13939.2
  • ResoLotSizeUnits: Acres

Tax Info

  • Tax Year: 2022
  • Tax Annual Amount: 4107

MLS Schools

  • Elementary School: Flagstone
  • High School: Douglas County

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jul 7, 2023
Closed on
Sep 1, 2023
Sold by
Mantelli Douglas W and Mantelli Hillary
Bought by
Schumann Spencer and Schumann Sierra
Seller's Agent
Lance Becker
Stix & Stones Fine Colorado Properties LLC
Buyer's Agent
Greg Anderson
MB The Anderson Team LLC
List Price
$869,000
Sold Price
$857,500
Premium/Discount to List
-$11,500
-1.32%
Views
53
Current Estimated Value
$831,179

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
-$26,321
Avg. Annual Appreciation
-1.94%
Original Mortgage
$686,000
Outstanding Balance
$673,604
Interest Rate
6.78%
Mortgage Type
New Conventional
Estimated Equity
$151,574

Purchase Details

Closed on
Aug 31, 2009
Sold by
Oberlin Brenna and Oberlin Nick
Bought by
Mantelli Douglas W and Mantelli Hillary

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$392,755
Interest Rate
5.26%
Mortgage Type
FHA

Purchase Details

Closed on
Oct 29, 2007
Sold by
Ward Brenna and Oberlin Nick
Bought by
Oberlin Brenna and Oberlin Nick

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$175,000
Interest Rate
6.37%
Mortgage Type
New Conventional

Purchase Details

Closed on
Apr 27, 2006
Sold by
Engle Homes Colorado
Bought by
Ward Brenna and Oberlin Nick

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$175,000
Interest Rate
6.32%
Mortgage Type
Fannie Mae Freddie Mac
Source: Public Records

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
Schumann Spencer $857,500 None Listed On Document
Mantelli Douglas W $400,000 Ata
Oberlin Brenna -- Fidelity National Title
Ward Brenna $362,500 None Available
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Schumann Spencer $686,000
Previous Owner Mantelli Douglas W $408,013
Previous Owner Mantelli Douglas W $305,900
Previous Owner Mantelli Hillary $297,000
Previous Owner Mantelli Douglas W $392,755
Previous Owner Oberlin Brenna $175,000
Previous Owner Ward Brenna $175,000
Previous Owner Hover Jason A $185,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
09/01/2023 09/01/23 Sold $857,500 +3.9% $209 / Sq Ft
07/27/2023 07/27/23 Price Changed $825,000 -2.8% $201 / Sq Ft
07/13/2023 07/13/23 Price Changed $849,000 -2.3% $207 / Sq Ft
07/07/2023 07/07/23 For Sale $869,000 -- $212 / 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
2024 $5,316 $57,170 $11,500 $45,670
2023 $5,368 $57,170 $11,500 $45,670
2022 $4,107 $38,380 $8,150 $30,230
2021 $4,263 $38,380 $8,150 $30,230
2020 $4,157 $38,330 $6,730 $31,600
2019 $4,170 $38,330 $6,730 $31,600
2018 $3,853 $34,860 $5,130 $29,730
2017 $3,645 $34,860 $5,130 $29,730
2016 $3,447 $32,430 $4,660 $27,770
2015 $3,508 $32,430 $4,660 $27,770
2014 $3,422 $28,690 $3,180 $25,510
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: REcolorado®

MLS Number: 4041408

REcolorado®

APN: 2507-093-01-015