NOT LISTED FOR SALE

Estimated Value: $1,182,385 - $1,297,000

6 Beds
4 Baths
4,002 Sq Ft
$308/Sq Ft Est. Value

Last Sold January 22, 2025

Last sale price $1,213,650 $303 Per Sq Ft

Est. 2% increase in value since last sale

Current estimated payment $7,198/month

116 Days on Market

Highlights

  • Lake Front
  • Spa
  • Aspen Trees
  • Dakota Ridge Senior High School Rated A-
  • Primary Bedroom Suite
  • Deck

About This Home

As of January 2025

Welcome to 4792 S Upham Court! This home is a very rare find. Located directly on Marston Lake, these lake views are incredibly unique and hard to find in the Denver Metro. This home is a natural oasis, yet you are conveniently located to dozens of restaurants and stores. This home is the definition of Colorado's natural beauty meeting the convenience of living in the foothills. As you walk through the front door, you are greeted by stunning high ceilings, real hardwood floors, and your eyes are immediately drawn to the showstopping view of the lake right in your backyard. The formal dining room, family room, and deck overlooking the lake make this home perfectly fit for entertaining. The large primary bedroom with en-suite primary bathroom and large walk-in closet, also overlooks the lake and has its own private balcony allowing you to take in these picturesque views from the comfort of your bedroom. The rest of the home features 5 additional bedrooms as well as 3 additional bathrooms. This home is not short on space and storage. If you're looking for an incredibly rare and unique home that is also incredibly functional, come take a look and see everything 4792 S Upham Ct has to offer!

Last Agent to Sell the Property

Monica Lieving

Guide Real Estate Brokerage Email: monica@monicalieving.com,309-738-8734 License #100094399 Listed on: 08/02/2024

Guide Real Estate

Last Buyer's Agent

Cindy Mitchell

MB CM Real Estate Inc License #40008956

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $6,000

Year Built

  • Built in 2005

Lot Details

  • 6,029 Sq Ft Lot
  • Lake Front
  • Property is Fully Fenced
  • Landscaped
  • Front and Back Yard Sprinklers
  • Irrigation
  • Aspen Trees
  • Private Yard

HOA Fees

  • $50 Monthly HOA Fees

Parking

  • 2 Car Attached Garage

Home Design

  • Contemporary Architecture
  • Brick Exterior Construction
  • Slab Foundation
  • Frame Construction
  • Composition Roof
  • Vinyl Siding

Interior Spaces

  • Multi-Level Property
  • Built-In Features
  • High Ceiling
  • Ceiling Fan
  • Double Pane Windows
  • Family Room with Fireplace
  • 2 Fireplaces
  • Living Room with Fireplace
  • Dining Room
  • Lake Views
  • Carbon Monoxide Detectors
  • Laundry in unit

Kitchen

  • Double Oven
  • Cooktop
  • Microwave
  • Dishwasher
  • Kitchen Island
  • Granite Countertops
  • Disposal

Flooring

  • Wood
  • Carpet
  • Tile

Bedrooms and Bathrooms

  • 6 Bedrooms
  • Primary Bedroom Suite
  • Walk-In Closet

Finished Basement

  • Walk-Out Basement
  • 2 Bedrooms in Basement

Eco-Friendly Details

  • Solar Heating System

Outdoor Features

  • Spa
  • Balcony
  • Deck
  • Covered Patio or Porch

Schools

  • Blue Heron Elementary School
  • Summit Ridge Middle School
  • Dakota Ridge High School

Utilities

  • Forced Air Heating and Cooling System
  • 220 Volts
  • Natural Gas Connected

Community Details

  • Association fees include ground maintenance, trash
  • Hammersmith Association, Phone Number (303) 980-0700
  • Beers Sisters Farm Dairy Subdivision

Listing and Financial Details

  • Exclusions: Seller's personal property, washer, dryer, and wine fridge.
  • Assessor Parcel Number 425234

Home Details

Home Type

Single Family

Est. Annual Taxes

$6,000

Year Built

Built in 2005

Lot Details

6,029 Sq Ft Lot

HOA Fees

$50 per month

Parking

2

Listing Details

  • Property Type: Residential
  • Property Sub Type: Single Family Residence
  • Architectural Style: Contemporary
  • Structure Type: House
  • Levels: Multi/Split
  • Year Built: 2005
  • Above Grade Finished Sq Ft: 3013
  • Exclusions: Seller's personal property, washer, dryer, and wine fridge.
  • Living Area: 4002
  • Pets Allowed: Cats OK, Dogs OK
  • SubdivisionName: Beers Sisters Farm Dairy
  • Ownership: Individual
  • Property Attached Yn: No
  • ResoBuildingAreaSource: PublicRecords
  • REC_BasementLevelBedrooms: 2
  • REC_BelowGradeUnfinishedArea: 0.00
  • REC_RVSpaces: 0
  • REC_UpperLevelBathrooms: 2
  • REC_UpperLevelBedrooms: 3
  • REC_WaterIncludedYN: 1
  • Ratio Close Price By Original Li: 0.78351
  • Special Features: VirtualTour

Interior Features

  • Appliances: Cooktop, Dishwasher, Disposal, Double Oven, Microwave, Range, Refrigerator
  • Fireplaces: 2
  • Interior Amenities: Built-in Features, Ceiling Fan(s), Five Piece Bath, Granite Counters, High Ceilings, Kitchen Island, Primary Suite, Hot Tub, Walk-In Closet(s)
  • Flooring: Carpet, Tile, Wood
  • Fireplace Features: Family Room, Living Room
  • Full Bathrooms: 3
  • Common Walls: No Common Walls
  • Basement: Finished, Walk-Out Access
  • Basement: Yes
  • Three Quarter Bathrooms: 1
  • Total Bedrooms: 6
  • Below Grade Sq Ft: 989
  • Window Features: Double Pane Windows

Exterior Features

  • Foundation Details: Slab
  • Roof: Composition
  • Construction Materials: Brick, Frame, Vinyl Siding
  • View: Lake
  • Exterior Features: Balcony, Private Yard, Spa/Hot Tub
  • Patio and Porch Features: Covered, Deck, Front Porch, Patio
  • Road Frontage Type: Public
  • Road Surface Type: Paved
  • Waterfront Features: Lake

Garage/Parking

  • Parking Features: Concrete
  • Attached Garage: Yes
  • Garage Spaces: 2
  • Total Parking Spaces: 2

Utilities

  • Utilities: Electricity Connected, Natural Gas Connected
  • Sewer: Public Sewer
  • Cooling: Central Air
  • Heating: Forced Air, Solar
  • Water Source: Public
  • Electric: 220 Volts
  • Laundry Features: In Unit
  • Security: Carbon Monoxide Detector(s)

Condo/Co-op/Association

  • HOA Fee Includes: Maintenance Grounds, Trash
  • Association Name: Hammersmith
  • Association Fee Frequency: Quarterly
  • Association Fee: 150
  • Phone: 303-980-0700
  • Association: Yes
  • Senior Community: No

Association/Amenities

  • REC_AssociationFee2Annual: 0.00
  • REC_AssociationFee3Annual: 0.00
  • REC_AssociationFeeAnnual: 600.00
  • REC_AssociationFeeTotalAnnual: 600.00
  • REC_AssociationManagementType: Professionally Managed

Schools

  • Middle Or Junior School: Summit Ridge

Lot Info

  • Parcel Number: 425234
  • Lot Size Acres: 0.14
  • Fencing: Full
  • Building Area Total: 4002
  • Lot Features: Irrigated, Landscaped, Sprinklers In Front, Sprinklers In Rear
  • Lot Size Sq Ft: 6029
  • ResoLotSizeUnits: SquareFeet

Tax Info

  • Tax Year: 2023
  • Tax Annual Amount: 6000

MLS Schools

  • Elementary School: Blue Heron
  • High School: Dakota Ridge

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Aug 2, 2024
Closed on
Jan 22, 2025
Sold by
Gerity Chad and Gerity Melissa
Bought by
Brown Laura J
Seller's Agent
Monica Lieving
Guide Real Estate
Buyer's Agent
Cindy Mitchell
MB CM Real Estate Inc
List Price
$1,549,000
Sold Price
$1,213,650
Premium/Discount to List
-$335,350
-21.65%
Views
243
Current Estimated Value
$1,233,596

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$19,946
Avg. Annual Appreciation
1.39%
Original Mortgage
$806,500
Outstanding Balance
$800,668
Interest Rate
6.6%
Mortgage Type
New Conventional
Estimated Equity
$432,928

Purchase Details

Closed on
Aug 25, 2011
Sold by
Mcdonald Michael L and Mcdonald Carolyn A
Bought by
Gerity Chad and Gerity Melissa

Home Financials for this Owner

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

Purchase Details

Closed on
Jul 1, 2011
Sold by
The Colorado Home Ownership Llc
Bought by
Mcdonald Michael L and Mcdonald Carolyn A

Home Financials for this Owner

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

Purchase Details

Closed on
Apr 29, 2005
Sold by
Laureate Partners Llc
Bought by
Mcdonald Michael L and Mcdonald Carolyn A

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$411,256
Interest Rate
6.75%
Mortgage Type
Fannie Mae Freddie Mac
Source: Public Records
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
Brown Laura J $1,213,650 None Listed On Document
Gerity Chad $393,000 Fidelity National Title Insu
Mcdonald Michael L -- Fidelity National Title Insu
Mcdonald Michael L $514,071 Land Title Guarantee Company
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Brown Laura J $806,500
Previous Owner Gerity Chad $383,037
Previous Owner Mcdonald Michael L $411,256
Closed Mcdonald Michael L $102,814
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
01/22/2025 01/22/25 Sold $1,213,650 -6.6% $303 / Sq Ft
09/26/2024 09/26/24 Price Changed $1,300,000 -7.1% $325 / Sq Ft
08/20/2024 08/20/24 Price Changed $1,400,000 -9.6% $350 / Sq Ft
08/02/2024 08/02/24 For Sale $1,549,000 -- $387 / Sq Ft
Source: REcolorado®

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 $6,667 $66,881 $14,832 $52,049
2023 $6,667 $66,881 $14,832 $52,049
2022 $5,633 $55,365 $16,623 $38,742
2021 $5,722 $56,958 $17,101 $39,857
2020 $5,322 $53,205 $16,517 $36,688
2019 $5,263 $53,205 $16,517 $36,688
2018 $4,972 $48,690 $13,292 $35,398
2017 $4,426 $48,690 $13,292 $35,398
2016 $4,807 $51,004 $11,801 $39,203
2015 $4,205 $51,004 $11,801 $39,203
2014 $4,205 $40,998 $11,244 $29,754
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: REcolorado®

MLS Number: 4796554

REcolorado®

APN: 59-114-01-009

Your Personal Tour Guide

Ask me questions while you tour the home.