$875,000
SOLD AUG 21, 2025

8839 Shetland Dr Frederick, CO 80504

5 Beds
4.5 Baths
5,001 Sq Ft
0.25 Acres

Recently Sold

$175 Per Sq Ft

5% Below List Price

49 Days on Market

Highlights

  • Media Room
  • Mountain View
  • Cathedral Ceiling
  • Open Floorplan
  • Multiple Fireplaces
  • Wood Flooring

About This Home

As of August 2025

Stunning former model home with beautiful upgrades & design features. Enjoy trails, play golf at Bella Rosa course, walk around lake Milavec. Neighborhood has private pool! A grand staircase greets you as you enter this magnificent home. The huge open kitchen has granite counters, double oven, separate cooktop, dishwasher, refrigerator, microwave (all appliances included) plus expansive counter and cabinet space, walk-in pantry, wrap around bar, and huge separate eat-in area. The kitchen opens to the bright family room w/fireplace, soaring ceilings and lookout to upstairs. Formal dining room off the kitchen w/coffered ceilings. Main level suite with design features, walk-in closet and 3/4 bath. Main level also boasts a large private office w/french doors, and a living room w/vaulted ceiling. The upper level has a large open loft w/built-in desk; roomy bedrooms 2 & 3 with a jack-and-jill full bath/double sinks. The masterpiece of the upper level is the huge primary bedroom with breathtaking views, fireplace, large walk-in closet plus luxury 5 piece bath w/quartz counters and freestanding designer soak tub. The finished basement has a large bedroom w/walk-in closet, 3/4 bath, huge media room - projector & surround system included; fitness area, and three separate storage rooms. The beautiful professionally landscaped backyard looks out to peaceful open space. Huge wrap around patio includes gazebo and landscaped walk to built-in firepit. Oversized garage with finished floor, cabinets, shop vac, EV HOOKUP, TV and shelves included. Home has dual zone heat and AC for added comfort. H2O heater, furnace and roof have all been replaced in last 5 years. Tons of upgrades and designer features throughout this stunner! Current mortgage is Assumable VA loan. Veteran must qualify first to confirm assumption is possible.

Last Agent to Sell the Property

Cindy Campbell

RE/MAX Alliance-Longmont Listed on: 06/04/2025

Last Buyer's Agent

Luz Daniels

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $5,263

Year Built

  • Built in 2008

Lot Details

  • 0.25 Acre Lot
  • Open Space
  • Fenced
  • Corner Lot
  • Sprinkler System
  • Zero Lot Line

HOA Fees

  • $58 Monthly HOA Fees

Parking

  • 3 Car Attached Garage

Home Design

  • Wood Frame Construction
  • Composition Roof

Interior Spaces

  • 5,001 Sq Ft Home
  • 2-Story Property
  • Open Floorplan
  • Cathedral Ceiling
  • Ceiling Fan
  • Multiple Fireplaces
  • Window Treatments
  • French Doors
  • Family Room
  • Dining Room
  • Media Room
  • Home Office
  • Loft
  • Mountain Views

Kitchen

  • Eat-In Kitchen
  • Double Oven
  • Microwave
  • Dishwasher

Flooring

  • Wood
  • Carpet
  • Laminate
  • Tile

Bedrooms and Bathrooms

  • 5 Bedrooms
  • Walk-In Closet
  • Jack-and-Jill Bathroom

Laundry

  • Laundry on main level
  • Dryer
  • Washer

Schools

  • Legacy Elementary School
  • Coal Ridge Middle School
  • Frederick High School

Additional Features

  • Patio
  • Forced Air Heating and Cooling System

Listing and Financial Details

  • Assessor Parcel Number R1993403

Community Details

Overview

  • Association fees include common amenities
  • Moore Farms Association
  • Moore Farm Sub Subdivision

Recreation

  • Community Pool
  • Hiking Trails

Home Details

Home Type

Single Family

Est. Annual Taxes

$5,263

Year Built

Built in 2008

Lot Details

0

HOA Fees

$58 per month

Parking

3

Listing Details

  • Inclusions: Window Coverings,Double Oven,Dishwasher,Refrigerator,Clothes Washer,Clothes Dryer,Microwave
  • Year Built: 2008
  • Property Sub Type: Residential-Detached
  • Prop. Type: Residential
  • Horses: No
  • Lot Size Acres: 0.25
  • Subdivision Name: Moore Farm Sub
  • Garage Yn: Yes
  • Unit Levels: Two
  • New Construction: No
  • Building Stories: 2
  • Kitchen Level: Main
  • IRESDS_HasWaterRights: No
  • IRESDS_Total Sq Ft: 5001
  • Special Features: VirtualTour
  • Stories: 2

Interior Features

  • Possible Use: Single Family
  • Private Spa: No
  • Appliances: Double Oven, Dishwasher, Refrigerator, Washer, Dryer, Microwave
  • Other Equipment: Media Room
  • Has Basement: Partially Finished
  • Full Bathrooms: 2
  • Half Bathrooms: 1
  • Three Quarter Bathrooms: 2
  • Total Bedrooms: 5
  • Door Features: French Doors
  • Fireplace Features: 2+ Fireplaces
  • Fireplace: Yes
  • Flooring: Wood Floors
  • Interior Amenities: Study Area, Eat-in Kitchen, Separate Dining Room, Cathedral/Vaulted Ceilings, Open Floorplan, Pantry, Walk-In Closet(s), Loft, Jack & Jill Bathroom, 9ft+ Ceilings
  • Window Features: Window Coverings
  • Room Bedroom3 Features: Laminate Floor
  • Dining Room Features: Tile Floor
  • IRESDS_HasFamilyRoom: Yes
  • Room Bedroom4 Level: Upper
  • Living Room Living Room Level: Main
  • Room Bedroom4 Features: Laminate Floor
  • Master Bedroom Master Bedroom Level: Upper
  • Room Bedroom3 Level: Upper
  • Room Bedroom2 Level: Main
  • Room Bedroom2 Features: Carpet
  • Master Bedroom Features: Laminate Floor
  • Room Bedroom5 Level: Basement
  • Room Bedroom5 Features: Carpet
  • Room Family Room Level: Main
  • Room Kitchen Features: Hardwood
  • Family Room Features: Tile Floor
  • Living Room Features: Tile Floor
  • Dining Room Dining Room Level: Main
  • Master Bathroom Features: 5 Piece Primary Bath

Exterior Features

  • Roof: Composition
  • Fencing: Fenced
  • Lot Features: Zero Lot Line, Lawn Sprinkler System, Corner Lot, Abuts Public Open Space
  • View: Mountain(s)
  • View: Yes
  • Waterfront: No
  • Disclosures: Seller's Property Disclosure
  • Home Warranty: No
  • Construction Type: Wood/Frame
  • Patio And Porch Features: Patio
  • Property Condition: Not New, Previously Owned

Garage/Parking

  • Attached Garage: Yes
  • Covered Parking Spaces: 3
  • Garage Spaces: 3
  • Parking Features: Oversized
  • IRESDS_GarageType: Attached

Utilities

  • Cooling: Central Air, Ceiling Fan(s)
  • Electric: Electric
  • Heating: Forced Air
  • Utilities: Natural Gas Available, Electricity Available
  • Laundry Features: Main Level
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Electricity On Property: No
  • Water Source: City Water, town of frederick
  • Gas Company: Natural Gas

Condo/Co-op/Association

  • HOA Fee Includes: Common Amenities
  • Community Features: Pool, Hiking/Biking Trails
  • Senior Community: No
  • Association Fee: 693
  • Association Fee Frequency: Annually
  • Association Name: Moore Farms
  • Association: Yes

Association/Amenities

  • IRESDS_HasAssociationReserve: No
  • IRESDS_HasAssociationFee: Yes

Schools

  • Elementary School: Legacy
  • HighSchool: Frederick
  • Junior High Dist: ST Vrain Dist RE 1J
  • Middle Or Junior School: Coal Ridge

Lot Info

  • Zoning: res
  • Lot Size Sq Ft: 10911
  • Parcel #: R1993403
  • Irrigation Water Rights: No

Tax Info

  • Tax Year: 2024
  • Tax Annual Amount: 5263

Multi Family

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jun 4, 2025
Closed on
Aug 21, 2025
Sold by
Jeffers Richard C
Bought by
Gutierrez Cruz Alejandro Ce and Cervantes Tanya Michelle
Seller's Agent
Cindy Campbell
RE/MAX Alliance-Longmont
Buyer's Agent
Luz Daniels
List Price
$924,900
Sold Price
$875,000
Premium/Discount to List
-$49,900
-5.4%
Views
44
Current Estimated Value
$881,488

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$6,488
Avg. Annual Appreciation
1.96%
Original Mortgage
$700,000
Outstanding Balance
$699,397
Interest Rate
6.75%
Mortgage Type
New Conventional
Estimated Equity
$182,091

Purchase Details

Closed on
Apr 24, 2024
Sold by
Burks Allison B
Bought by
Burks Family Trust and Burks

Purchase Details

Closed on
May 2, 2011
Sold by
Msp Corporation
Bought by
Jeffers Richard C

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$448,192
Interest Rate
4.86%
Mortgage Type
VA

Purchase Details

Closed on
Nov 18, 2009
Sold by
Anstine Glen R
Bought by
Msp Corporation

Purchase Details

Closed on
Jan 24, 2008
Sold by
Marquis Homes By Design Inc
Bought by
Marquis Homes Inc

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$323,000
Interest Rate
6.15%
Mortgage Type
Construction

Purchase Details

Closed on
Dec 17, 2007
Sold by
Msp Corp
Bought by
Marquis Homes By Design Inc

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$323,000
Interest Rate
6.15%
Mortgage Type
Construction
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 $875,000 First American Title
Special Warranty Deed -- None Listed On Document
Special Warranty Deed $439,500 North American Title
Deed -- None Available
Quit Claim Deed -- North American Title
Special Warranty Deed $86,000 North American Title
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Open $700,000 New Conventional
Previous Owner $448,192 VA
Previous Owner $323,000 Construction
Previous Owner $86,000 Seller Take Back
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
08/21/2025 08/21/25 Sold $875,000 -4.4% $175 / Sq Ft
07/23/2025 07/23/25 Pending -- -- --
07/11/2025 07/11/25 Price Changed $915,000 -1.1% $183 / Sq Ft
06/04/2025 06/04/25 For Sale $924,900 -- $185 / Sq Ft
Source: IRES MLS

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 $5,263 $50,940 $7,190 $43,750
2024 $5,263 $50,940 $7,190 $43,750
2023 $5,048 $54,750 $9,130 $45,620
2022 $4,178 $40,040 $6,600 $33,440
2021 $4,219 $41,190 $6,790 $34,400
2020 $4,323 $42,550 $6,080 $36,470
2019 $4,387 $42,550 $6,080 $36,470
2018 $4,543 $39,320 $6,120 $33,200
2017 $4,325 $39,320 $6,120 $33,200
2016 $3,883 $37,620 $5,570 $32,050
2015 $3,764 $37,620 $5,570 $32,050
2014 $3,200 $32,020 $5,570 $26,450
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: IRES MLS

MLS Number: 1035769

IRES MLS

APN: R1993403