$575,000
SOLD MAR 12, 2025

17851 E Harvard Place Aurora, CO 80013

Lakeshore Neighborhood
5 Beds
3.5 Baths
2,465 Sq Ft
5,227 Sq Ft Lot

Recently Sold

$233 Per Sq Ft

2 Days on Market

Highlights

  • Primary Bedroom Suite
  • Deck
  • Granite Countertops
  • Open Floorplan
  • Vaulted Ceiling
  • Private Yard

About This Home

As of March 2025

Welcome to Your Fully Updated Dream Home in the Coveted Lakeshore Community! This thoughtfully redesigned residence offers 5 spacious bedrooms, with 4 conveniently on one level, and a versatile 5th in the finished basement that's ideal for a mother-in-law suite, teen retreat, or guest space. Step inside to soaring ceilings and large picture windows that flood the home with natural light. At the front, formal living and dining rooms feature luxury LVP flooring and are perfect for hosting holidays and gatherings. The professionally designed chef's kitchen is a true showpiece, boasting custom two-tone cabinetry with elegant hardware, a butcher block island with seating, granite counters, custom backsplash, gas range, French door refrigerator, and an expanded window that brightens the space. With all appliances included, this home is move-in ready. The family room is warm and inviting, centered around a brick gas fireplace with a hearth and easy access to the backyard. The primary suite offers vaulted ceilings and a spa-like en-suite bath with a quartz vanity, framed mirror, designer lighting, and a walk-in shower with a bench, custom tile work, tiled Schluter shower pan, and frameless glass door. A built-in coffee bar or extra storage adds convenience. Three additional bedrooms share a beautifully updated bath with a custom vanity and designer finishes. The finished basement provides a second family room, playroom, home office, or home theater, plus a spacious bedroom and private full bath. Across the street from the neighborhood pool, enjoy a swim, return home for a snack, and head right back! Spend sunny Colorado days on the expanded deck and in the backyard with space for a garden. Lakeshore offers a private lake, top-rated schools within walking distance, and scenic trails. Don’t miss this exceptional home!

Last Agent to Sell the Property

Lindsay Mann

The Creed Group Brokerage Email: results@thecreedgroup.com,720-365-7174 License #100029867 Listed on: 02/13/2025

Last Buyer's Agent

Kirsten Walsh

Berkshire Hathaway HomeServices Colorado, LLC - Highlands Ranch Real Estate License #40036950

Berkshire Hathaway HomeServices Colorado, LLC - Highlands Ranch Real Estate

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $3,274

Year Built

  • Built in 1986 | Remodeled

Lot Details

  • 5,227 Sq Ft Lot
  • Property is Fully Fenced
  • Front and Back Yard Sprinklers
  • Private Yard
  • Garden

HOA Fees

  • $174 Monthly HOA Fees

Parking

  • 2 Car Attached Garage

Home Design

  • Frame Construction
  • Composition Roof

Interior Spaces

  • Multi-Level Property
  • Open Floorplan
  • Vaulted Ceiling
  • Ceiling Fan
  • Gas Fireplace
  • Window Treatments
  • Family Room with Fireplace
  • Living Room
  • Dining Room
  • Finished Basement
  • 1 Bedroom in Basement

Kitchen

  • Breakfast Area or Nook
  • Eat-In Kitchen
  • Convection Oven
  • Range
  • Microwave
  • Dishwasher
  • Kitchen Island
  • Granite Countertops
  • Butcher Block Countertops
  • Disposal

Flooring

  • Carpet
  • Laminate
  • Tile

Bedrooms and Bathrooms

  • 5 Bedrooms
  • Primary Bedroom Suite
  • Walk-In Closet
  • In-Law or Guest Suite

Laundry

  • Laundry Room
  • Dryer
  • Washer

Outdoor Features

  • Deck

Schools

  • Vassar Elementary School
  • Columbia Middle School
  • Rangeview High School

Utilities

  • Forced Air Heating and Cooling System
  • Humidifier
  • Gas Water Heater

Community Details

  • Lakeshore Hoa, Hammersmith Association, Phone Number (303) 980-0700
  • Lakeshore Subdivision

Listing and Financial Details

  • Exclusions: Garage fridge/freezer. All detached shelving. TV mounts TBD.
  • Assessor Parcel Number 032611677

Home Details

Home Type

Single Family

Est. Annual Taxes

$3,274

Year Built

Built in 1986 | Remodeled

Lot Details

0

HOA Fees

$174 per month

Parking

2

Listing Details

  • Property Type: Residential
  • Property Sub Type: Single Family Residence
  • Structure Type: House
  • Levels: Multi/Split
  • Year Built: 1986
  • Above Grade Finished Sq Ft: 1990
  • Exclusions: Garage fridge/freezer. All detached shelving. TV mounts TBD.
  • Living Area: 2465
  • Property Condition: Updated/Remodeled
  • Directions: MapQuest/GPS
  • SubdivisionName: Lakeshore
  • Co List Office Mls Id: RECCREED
  • Ownership: Individual
  • Property Attached Yn: No
  • ResoBuildingAreaSource: PublicRecords
  • REC_BasementLevelBedrooms: 1
  • REC_BelowGradeUnfinishedArea: 123.00
  • REC_RVSpaces: 0
  • REC_UpperLevelBathrooms: 2
  • REC_UpperLevelBedrooms: 4
  • REC_WaterIncludedYN: 1
  • Ratio Close Price By Original Li: 1.00000
  • Special Features: VirtualTour

Interior Features

  • Appliances: Convection Oven, Dishwasher, Disposal, Dryer, Gas Water Heater, Humidifier, Microwave, Oven, Range, Refrigerator, Washer
  • Fireplaces: 1
  • Interior Amenities: Breakfast Nook, Butcher Counters, Ceiling Fan(s), Eat-in Kitchen, Granite Counters, High Ceilings, In-Law Floor Plan, Kitchen Island, Open Floorplan, Pantry, Primary Suite, Vaulted Ceiling(s), Walk-In Closet(s)
  • Flooring: Carpet, Laminate, Tile
  • Fireplace Features: Family Room, Gas
  • Full Bathrooms: 3
  • Half Bathrooms: 1
  • Basement: Finished
  • Basement: Yes
  • Total Bedrooms: 5
  • Below Grade Sq Ft: 475
  • Window Features: Window Coverings

Exterior Features

  • Roof: Composition
  • Construction Materials: Frame
  • Exterior Features: Garden, Private Yard
  • Patio and Porch Features: Deck

Garage/Parking

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

Utilities

  • Sewer: Public Sewer
  • Cooling: Central Air
  • Heating: Forced Air
  • Water Source: Public
  • Laundry Features: In Unit

Condo/Co-op/Association

  • Association Name: Lakeshore HOA, Hammersmith
  • Association Fee Frequency: Monthly
  • Association Fee: 174.34
  • Phone: 303-980-0700
  • Association: Yes
  • Senior Community: No

Association/Amenities

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

Schools

  • Middle Or Junior School: Columbia

Lot Info

  • Parcel Number: 032611677
  • Lot Size Acres: 0.12
  • Fencing: Full
  • Building Area Total: 2588
  • Lot Features: Sprinklers In Front, Sprinklers In Rear
  • Lot Size Sq Ft: 5227.2
  • ResoLotSizeUnits: Acres

Tax Info

  • Tax Year: 2023
  • Tax Annual Amount: 3274

MLS Schools

  • Elementary School: Vassar
  • High School: Rangeview

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Feb 13, 2025
Closed on
Mar 12, 2025
Sold by
Radden Andrew J and Radden Joslyn N
Bought by
Lowder Michael R and Lowder Elizabeth A
Seller's Agent
Lindsay Mann
The Creed Group
Buyer's Agent
Kirsten Walsh
Berkshire Hathaway HomeServices Colorado, LLC - Highlands Ranch Real Estate
List Price
$575,000
Sold Price
$575,000
Views
23
Current Estimated Value
$567,221

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
-$7,779
Avg. Annual Appreciation
-1.69%
Original Mortgage
$460,000
Outstanding Balance
$330,267
Interest Rate
6.95%
Mortgage Type
New Conventional
Estimated Equity
$236,954

Purchase Details

Closed on
Nov 17, 2022
Sold by
Radden Joslyn Noelle and Radden Andrew Joseph
Bought by
Radden Joslyn Noelle and Radden Andrew Joseph

Purchase Details

Closed on
Jul 6, 2012
Sold by
Hummel Robert Allen and Hummel Brenda P
Bought by
Radden Andrew J and Radden Joslyn N

Home Financials for this Owner

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

Purchase Details

Closed on
May 18, 2011
Sold by
Hummel Robert A and Hummel Brenda P
Bought by
Hummel Robert Allen and Hummel Brenda P

Home Financials for this Owner

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

Purchase Details

Closed on
Mar 7, 2006
Sold by
Hummel Robert A and Hummel Brenda F
Bought by
Hummel Robert A and Hummel Brenda F

Home Financials for this Owner

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

Purchase Details

Closed on
Nov 16, 2005
Sold by
Hummel Robert A and Hummel Brenda F
Bought by
Hummel Robert A and Hummel Brenda F

Home Financials for this Owner

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

Purchase Details

Closed on
Jan 9, 1998
Sold by
Hummel Robert A and Hummel Brenda F
Bought by
The Robert A & Brenda F Hummel Trust

Purchase Details

Closed on
Sep 27, 1989
Sold by
Dokter Evelyn M Dokter Luvern D
Bought by
Hummel Brenda F Hummel Robert A

Purchase Details

Closed on
Nov 26, 1986
Sold by
Conversion Arapco
Bought by
Dokter Evelyn M Dokter Luvern D

Purchase Details

Closed on
Mar 18, 1986
Bought by
Conversion Arapco
Source: Public Records

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
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 Type Sale Price Title Company
Warranty Deed $575,000 Chicago Title
Warranty Deed $575,000 Chicago Title
Deed -- None Listed On Document
Warranty Deed $225,000 Land Title Guarantee Company
Interfamily Deed Transfer -- Capital Title
Interfamily Deed Transfer -- None Available
Interfamily Deed Transfer -- Title Source Inc
Interfamily Deed Transfer -- Title Source Inc
Interfamily Deed Transfer -- --
Deed -- --
Deed -- --
Deed -- --
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Open $460,000 New Conventional
Closed $460,000 New Conventional
Previous Owner $213,750 New Conventional
Previous Owner $205,030 FHA
Previous Owner $34,000 Credit Line Revolving
Previous Owner $190,000 Credit Line Revolving
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
03/12/2025 03/12/25 Sold $575,000 0.0% $233 / Sq Ft
02/13/2025 02/13/25 For Sale $575,000 -- $233 / 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 $3,376 $31,900 -- --
2024 $3,274 $35,229 -- --
2023 $3,274 $35,229 $0 $0
2022 $2,955 $29,433 $0 $0
2021 $3,051 $29,433 $0 $0
2020 $2,848 $27,349 $0 $0
2019 $2,832 $27,349 $0 $0
2018 $2,462 $23,285 $0 $0
2017 $2,142 $23,285 $0 $0
2016 $1,899 $20,210 $0 $0
2015 $1,833 $20,210 $0 $0
2014 $1,334 $14,161 $0 $0
2013 -- $16,330 $0 $0
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: REcolorado®

MLS Number: 3416634

REcolorado®

APN: 1975-28-4-16-003