NOT LISTED FOR SALE

Estimated Value: $844,756 - $951,000

5 Beds
4 Baths
4,571 Sq Ft
$195/Sq Ft Est. Value

Last Sold December 16, 2024

Last sale price $870,000 $190 Per Sq Ft

Est. 2% increase in value since last sale

Current estimated payment $5,227/month

153 Days on Market

Highlights

  • Primary Bedroom Suite
  • Open Floorplan
  • Wood Flooring
  • Fox Hollow Elementary School Rated A-
  • Traditional Architecture
  • Loft

About This Home

As of December 2024

This Gorgeous Modern Manor has space for everyone AND is completely remodeled throughout! Welcome to The Farm at Arapahoe County with everything you've been looking for and a modern retreat nestled in one of the most sought after neighborhoods in Aurora. Walkable parks and schools, shopping, restaurants, retail and Cherry Creek State Park all nearby, only 20 min to DTC, 30 min to DIA, and 40 Min to Downtown. This Modern Manor has all of the luxury finishes within the warmth of an established neighborhood. Walk in to the Grand Foyer, past the curved staircase, into the Family Room, open to the massive Kitchen with 48" Fridge and Bosch Appliances, as well as the entertaining bar, OR to the Formal Living and Dining Spaces with modern fixtures architectural details. Nestled down the main hallway is a generous Main Floor Bedroom & Bathroom, great for a Guest Suite, Home Office, or other easy access private getaway. Upstairs the Private Primary Suite is nothing short of impressive, with separate Walk-In Closets and a completely remodeled luxurious bathroom. Three additional generously sized bedrooms upstairs, as well as the 3rd Living Area in a Casual Upstairs Loft, all with ample closets and direct access to one of 2 Jack and Jill Bathrooms. The Basement is a blank slate with another 1,600+ sqft! And a 3 Car garage stores the toys with room for a lift given the 10ft+ ceilings. This home has been thoroughly updated in the last 12 months including all new: 2 HVAC systems, carpet, paint top to bottom inside & out, dishwasher, gas range, drawer microwave, lighting throughout, master bathroom remodel, kitchen remodel, new hardwood floors installed and refinished existing hardwood floors, LVT flooring in laundry and bathrooms, converted from vinyl siding to Brand New Hardie Board Siding, 10 new windows, even a new lawn in front and backyard. Can't visit in person? Check out the 3D Tour, Video Home Tour, Neighborhood Info, and More at www.16836ECaley.com

Last Agent to Sell the Property

Stacie Duffy

Novella Real Estate Brokerage Email: RealtorStacieDuffy@gmail.com,720-460-1753 License #100054037 Listed on: 06/07/2024

Last Buyer's Agent

Virendra Sharma

HomeSmart Realty License #40018641

HomeSmart Realty

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $5,460

Year Built

  • Built in 2004 | Remodeled

Lot Details

  • 9,148 Sq Ft Lot
  • Cul-De-Sac
  • North Facing Home
  • Xeriscape Landscape
  • Corner Lot
  • Front and Back Yard Sprinklers
  • Private Yard
  • Grass Covered Lot

HOA Fees

  • $52 Monthly HOA Fees

Parking

  • 3 Car Attached Garage
  • Dry Walled Garage

Home Design

  • Traditional Architecture
  • Entry on the 1st floor
  • Frame Construction
  • Concrete Roof
  • Wood Siding
  • Concrete Block And Stucco Construction
  • Concrete Perimeter Foundation

Interior Spaces

  • 2-Story Property
  • Open Floorplan
  • Wet Bar
  • Furnished or left unfurnished upon request
  • Built-In Features
  • High Ceiling
  • Double Pane Windows
  • Bay Window
  • Entrance Foyer
  • Family Room
  • Living Room
  • Dining Room
  • Loft
  • Bonus Room
  • Laundry Room

Kitchen

  • Eat-In Kitchen
  • Double Convection Oven
  • Range with Range Hood
  • Warming Drawer
  • Microwave
  • Dishwasher
  • Kitchen Island
  • Granite Countertops
  • Quartz Countertops
  • Disposal

Flooring

  • Wood
  • Carpet
  • Tile
  • Vinyl

Bedrooms and Bathrooms

  • Primary Bedroom Suite
  • Primary Bathroom is a Full Bathroom
  • Jack-and-Jill Bathroom

Unfinished Basement

  • Partial Basement
  • Sump Pump
  • Crawl Space

Home Security

  • Carbon Monoxide Detectors
  • Fire and Smoke Detector

Outdoor Features

  • Covered Patio or Porch
  • Rain Gutters

Schools

  • Fox Hollow Elementary School
  • Liberty Middle School
  • Grandview High School

Utilities

  • Forced Air Heating and Cooling System
  • Heating System Uses Natural Gas
  • 110 Volts
  • Natural Gas Connected
  • Gas Water Heater
  • High Speed Internet
  • Cable TV Available

Listing and Financial Details

  • Exclusions: Staging Furniture (available to order)
  • Assessor Parcel Number 034131973

Community Details

Overview

  • Association fees include ground maintenance, recycling, snow removal, trash
  • The Farm At Arapahoe County Association, Phone Number (303) 224-0004
  • The Farm Subdivision

Recreation

  • Community Playground
  • Trails

Home Details

Home Type

Single Family

Est. Annual Taxes

$5,460

Year Built

Built in 2004 | Remodeled

Lot Details

0

HOA Fees

$52 per month

Parking

3

Listing Details

  • Property Type: Residential
  • Property Sub Type: Single Family Residence
  • Architectural Style: Traditional
  • Structure Type: House
  • Levels: Two
  • Year Built: 2004
  • Above Grade Finished Sq Ft: 4571
  • Below Grade Sq Ft: 1577
  • Exclusions: Staging Furniture (available to order)
  • Living Area: 4571
  • Pets Allowed: Cats OK, Dogs OK, Yes
  • Property Condition: Updated/Remodeled
  • Directions: From Arapahoe Rd, North on Buckley, West on E Caley Ave, Left around Highridge Park, First Left onto S Ouray St, First Left onto E Caley Place.
  • SubdivisionName: The Farm
  • Ownership: Individual
  • Property Attached Yn: No
  • REC_BasementLevelBedrooms: 0
  • REC_ExpectedActiveDate: 2024-06-07
  • REC_RVSpaces: 0
  • REC_UpperLevelBathrooms: 3
  • REC_UpperLevelBedrooms: 4
  • REC_WaterIncludedYN: 1
  • Ratio Close Price By Original Li: 0.95082
  • Special Features: None

Interior Features

  • Appliances: Convection Oven, Dishwasher, Disposal, Double Oven, Gas Water Heater, Microwave, Oven, Range, Range Hood, Refrigerator, Sump Pump, Warming Drawer
  • Interior Amenities: Built-in Features, Eat-in Kitchen, Entrance Foyer, Five Piece Bath, Granite Counters, High Ceilings, Jack & Jill Bathroom, Kitchen Island, Open Floorplan, Pantry, Primary Suite, Quartz Counters, Wet Bar
  • Flooring: Carpet, Tile, Vinyl, Wood
  • Full Bathrooms: 2
  • Common Walls: No Common Walls
  • Basement: Crawl Space, Partial, Sump Pump, Unfinished
  • Basement: Yes
  • Three Quarter Bathrooms: 2
  • Total Bedrooms: 5
  • Entry Level: 1
  • Main Level Bathrooms: 1
  • Main Level Bedrooms: 1
  • Window Features: Bay Window(s), Double Pane Windows

Exterior Features

  • Direction Faces: North
  • Foundation Details: Concrete Perimeter
  • Roof: Concrete
  • Construction Materials: Concrete, Frame, Stucco, Wood Siding
  • Exterior Features: Private Yard, Rain Gutters
  • Patio and Porch Features: Covered, Front Porch, Patio
  • Road Frontage Type: Public
  • Road Surface Type: Paved

Garage/Parking

  • Parking Features: Concrete, Dry Walled
  • Attached Garage: Yes
  • Garage Spaces: 3
  • Total Parking Spaces: 3

Utilities

  • Utilities: Cable Available, Electricity Connected, Internet Access (Wired), Natural Gas Connected, Phone Connected
  • Sewer: Public Sewer
  • Cooling: Central Air
  • Heating: Forced Air, Natural Gas
  • Water Source: Public
  • Electric: 110V
  • Laundry Features: In Unit
  • Security: Carbon Monoxide Detector(s), Smoke Detector(s)

Condo/Co-op/Association

  • HOA Fee Includes: Maintenance Grounds, Recycling, Snow Removal, Trash
  • Association Name: The Farm at Arapahoe County
  • Association Fee Frequency: Monthly
  • Association Amenities: Playground, Trail(s)
  • Association Fee: 52
  • Phone: 303-224-0004
  • Association: Yes
  • Senior Community: No

Association/Amenities

  • REC_AssociationFee2Annual: 0.00
  • REC_AssociationFee3Annual: 0.00
  • REC_AssociationFeeAnnual: 624.00
  • REC_AssociationFeeTotalAnnual: 624.00
  • REC_AssociationManagementType: Professionally Managed
  • REC_AssociationURL: https://pcms.net/the-farm-at-arapahoe-county-hoa/

Schools

  • Middle Or Junior School: Liberty

Lot Info

  • Horses: No
  • Parcel Number: 034131973
  • Lot Size Acres: 0.21
  • Fencing: None
  • Building Area Total: 6148
  • Lot Features: Corner Lot, Cul-De-Sac, Landscaped, Sprinklers In Front, Sprinklers In Rear
  • Lot Size Sq Ft: 9147.6

Rental Info

  • Furnished: Negotiable

Tax Info

  • Tax Year: 2022
  • Tax Annual Amount: 5460

MLS Schools

  • Elementary School: Fox Hollow
  • High School: Grandview

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jun 7, 2024
Closed on
Dec 11, 2024
Sold by
Al Shaya Bader H
Bought by
Tyagi Alpna and Tyagi Anil Kumar
Seller's Agent
Stacie Duffy
Novella Real Estate
Buyer's Agent
Virendra Sharma
HomeSmart Realty
List Price
$915,000
Sold Price
$870,000
Premium/Discount to List
-$45,000
-4.92%
Views
102
Current Estimated Value
$891,189

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$21,189
Avg. Annual Appreciation
2.25%
Original Mortgage
$530,000
Outstanding Balance
$524,395
Interest Rate
6.79%
Mortgage Type
New Conventional
Estimated Equity
$366,794

Purchase Details

Closed on
Mar 6, 2015
Sold by
Bank Of America Na
Bought by
Omair Firas M

Purchase Details

Closed on
Jan 20, 2005
Sold by
Oakwood Homes Llc
Bought by
Alshaya Bader H
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
Tyagi Alpna $870,000 First American Title
Omair Firas M $185,000 None Available
Alshaya Bader H $523,500 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Tyagi Alpna $530,000
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
12/16/2024 12/16/24 Sold $870,000 -1.0% $190 / Sq Ft
09/09/2024 09/09/24 Price Changed $879,000 -3.9% $192 / Sq Ft
06/07/2024 06/07/24 For Sale $915,000 -- $200 / 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 $6,180 $53,894 -- --
2024 $5,580 $51,195 -- --
2023 $5,580 $51,195 $0 $0
2022 $5,460 $44,744 $0 $0
2021 $5,246 $44,744 $0 $0
2020 $5,730 $47,061 $0 $0
2019 $5,674 $47,061 $0 $0
2018 $4,652 $38,153 $0 $0
2017 $4,775 $38,153 $0 $0
2016 $5,654 $41,495 $0 $0
2015 $5,458 $41,495 $0 $0
2014 -- $34,427 $0 $0
2013 -- $32,820 $0 $0
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: REcolorado®

MLS Number: 2176292

REcolorado®

APN: 2073-21-3-21-009