NOT LISTED FOR SALE

Estimated Value: $1,207,000 - $1,226,375

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

Last Sold January 22, 2025

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

Current estimated payment $7,386/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 Listed By

Monica Lieving

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

Guide Real Estate

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
  • Bedroom in 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

0

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_BasementLevelBathrooms: 1
  • 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
  • Attribution Contact: monica@monicalieving.com,309-738-8734
  • 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
  • REC_ParkingCount: 1

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
  • REC_MultipleAssociationsYN: 0

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%
Total Days on Market
116
Views
243
Current Estimated Value
$1,214,844

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$1,194
Avg. Annual Appreciation
0.39%
Original Mortgage
$806,500
Outstanding Balance
$805,066
Interest Rate
6.6%
Mortgage Type
New Conventional
Estimated Equity
$409,778

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

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
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 $200,000
Previous Owner Gerity Chad $545,000
Previous Owner Gerity Chad $535,500
Previous Owner Gerity Chad $70,000
Previous Owner Gerity Chad $466,000
Previous Owner Gerity Chad $466,879
Previous Owner Gerity Chad $90,000
Previous Owner Gerity Chad $391,000
Previous Owner Gerity Chad $60,000
Previous Owner Gerity Chad $383,037
Previous Owner Mcdonald Carolyn A $615,000
Previous Owner Mcdonald Michael L $595,000
Previous Owner Mcdonald Michael L $411,256
Previous Owner Unique Development Inc $27,567
Closed Mcdonald Michael L $102,814
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
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 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 $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

Similar Homes in Littleton, CO

  • 6583 W Gould Dr, Littleton, CO 80123

    $975,000

    • 5 Beds
    • 4 Baths
    • 4,000 Sq Ft
    • 6583 W Gould Dr
    • Littleton, CO

    Welcome home to this spacious Grant Ranch home. Over 4000 finished square feet with 4 beds up and one more in the finished basement. Main floor features a family room, living room, dining room, office and a full bath. The kitchen has newer stainless-steel appliances, Island and raised panel cabinets. The large primary suite has a balcony, walk in closet and 5-piece bathroom with large soaking

    The Alan Smith Team RE/MAX Professionals

    Section Image
  • 6690 S Fenton St, Littleton, CO 80123

    $975,000

    • 4 Beds
    • 4.5 Baths
    • 3,717 Sq Ft
    • 6690 S Fenton St
    • Littleton, CO

    Welcome to this well maintained, move-in ready, two-story home in the coveted Vintage Reserve neighborhood, where modern comfort meets spacious living. The heart of the home features an island kitchen complete with granite counters, stainless steel appliances, a double oven, and a cooktop, perfect for culinary enthusiasts. A conveniently located main floor bedroom that seamlessly doubles as a

    Chad Murphy Compass - Denver

    Section Image
  • 5 Riviera Ct, Littleton, CO 80123

    $1,500,000

    • 5 Beds
    • 3.5 Baths
    • 4,089 Sq Ft
    • 5 Riviera Ct
    • Littleton, CO

    Welcome to this stunning 5-bedroom, 4-bathroom home in the highly sought-after Burning Tree neighborhood of Columbine Valley! With over 4,200 square feet of thoughtfully designed living space, this property offers both luxury and comfort in one of the area's most desirable locations. Step inside to find a spacious layout, perfect for modern living. The large primary suite is a true retreat,

    The Alan Smith Team RE/MAX Professionals

    Section Image
  • 7082 W Morraine Dr, Littleton, CO 80128

    $950,000

    • 5 Beds
    • 3.5 Baths
    • 3,725 Sq Ft
    • 7082 W Morraine Dr
    • Littleton, CO

    Welcome to your next home sweet home! This spacious and well-loved 5-bedroom, 4-bathroom house sits on a generous corner lot in one of the most sought-after neighborhoods around. From the moment you pull up, you’ll notice the charming curb appeal and how much space this property offers, both inside and out. Step through the front door and you’re greeted by an open, airy layout filled with natural

    Bret Weinstein Guide Real Estate

    Section Image
  • 12899 W Aqueduct Ave, Littleton, CO 80127

    $950,000

    • 4 Beds
    • 4.5 Baths
    • 4,016 Sq Ft
    • 12899 W Aqueduct Ave
    • Littleton, CO

    Spectacular Belleview Farms property lovingly cared for by the original owner since 1993! 5 bdrms/5 baths, 4,446 sq.ft, ¼-acre corner lot, located on a quiet cul-de-sac. A garage-lover’s dream! 4-car tandem garage w/ 20’ ceilings, and new overhead garage doors w/quiet-close openers. Other special features include, New interior paint, a dramatic foyer, cathedral ceilings, upper-level bridge and

    Sandy Young RE/MAX Professionals

    Section Image
  • 9595 S Everett Way, Littleton, CO 80127

    $950,000

    • 6 Beds
    • 3.5 Baths
    • 3,566 Sq Ft
    • 9595 S Everett Way
    • Littleton, CO

    Welcome to Trailmark. This is one of Littleton's most sought-after neighborhoods. Easy access to Chatfield reservoir, where you can boat, bike, camp, fish, swim and paddle board. This spacious home has an updated kitchen with quartz countertops, stainless steel appliances and 42" cabinets. The main floor has volume ceilings, formal living room, formal dining room a family room that is just off

    The Alan Smith Team RE/MAX Professionals

    Section Image
  • 8501 Hackamore Rd, Littleton, CO 80125

    $949,950

    • 5 Beds
    • 3.5 Baths
    • 4,299 Sq Ft
    • 8501 Hackamore Rd
    • Littleton, CO

    Stunning location, backing to open space. This move-in ready ranch style home is ready for you. Spacious primary suite with views. Updated primary bath. 2 additional bedrooms on the main floor. Updated kitchen with granite countertops and stainless steel appliances. Formal living, formal dining and amazing family room finish out the main floor. The finished basement has 2 additional bedrooms and

    The Alan Smith Team RE/MAX Professionals

    Section Image
  • 4814 S Upham Ct, Littleton, CO 80123

    $1,275,000

    • 7 Beds
    • 4 Baths
    • 4,302 Sq Ft
    • 4814 S Upham Ct
    • Littleton, CO

    SPECTACULAR "LAKE VIEW" HOME!! Welcome to your private slice of paradise in Twin Shores—where lakeview living meets everyday convenience and every day feels like a retreat. With over 4,300 finished square feet, this one-of-a-kind home offers stunning lake and mountain views from nearly every window. Vaulted ceilings and an abundance of natural light set the tone for a warm and inviting

    Christine Gulley Colorado Home Realty

    Section Image
  • 6296 W Prentice Ave, Littleton, CO 80123

    $1,375,500

    • 6 Beds
    • 4.5 Baths
    • 5,110 Sq Ft
    • 6296 W Prentice Ave
    • Littleton, CO

    Discover the perfect blend of charm, comfort, and scenic beauty in this stunning home, located in the Regatta neighborhood of Grant Ranch. The home's architectural style is Craftsman-inspired contemporary and just steps from the serene lake and offering breathtaking mountain views. The heart of the home is a spacious open-concept kitchen, designed for culinary creativity and effortless

    Julie Reddington Colorado Home Realty

    Section Image

Source: REcolorado®

MLS Number: 4796554

REcolorado®

APN: 59-114-01-009