$1,899,900

Estimated payment $11,066/month

Total Views 233
6 Beds
6 Baths
7,451 Sq Ft
$255 Price per Sq Ft

Highlights

  • Open Floorplan
  • Mountain View
  • Cathedral Ceiling
  • McGraw Elementary School Rated A-
  • Deck
  • Wood Flooring

About This Home

Nestled within the lush, mature landscape of The Orchards at Clarendon Hills, this exquisite residence at 5100 Abbey Road is an award-winning architectural triumph. The striking exterior, crafted from over 60,000 meticulously laid bricks, is a testament to extraordinary craftsmanship and a work of art in its own right. Upon entering the nearly 7,500-square-foot home, you'll be greeted by a sense of grandeur. The two-story entry is defined by a breathtaking grand staircase, with sophisticated living and dining rooms on either side. Beyond, a gourmet kitchen awaits, a culinary space designed for the most discerning chef. It features a professional-grade 48-inch Wolf range, a Sub-Zero refrigerator, and an array of high-end appliances, all complemented by classic granite countertops and a travertine backsplash. The upper level is home to a tranquil primary suite, a private sanctuary with beautiful built-in cabinetry and a recently remodeled ensuite bath. The luxurious bathroom is an oasis of calm, with a window-framed soaking tub and an elegant palette of high-end materials. The upstairs also offers three additional bedrooms and a spacious bonus room provide exceptional flexibility. The walk-out basement is an entertainer's dream, ready to host with a spacious family room, a recreation area, and an impressive, full-size indoor wet bar, and a bonus patio bar. The magnificent wine cellar and dedicated gym add to the home's incredible amenities. Two large bedrooms on this level offer privacy and comfort for guests. With an oversized four-car garage and a prime location, this home truly embodies a rare blend of sophistication and function.

Listing Agent

Michael Campana

TRX, Inc Listed on: 08/27/2025

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $8,106

Year Built

  • Built in 1992

Lot Details

  • 0.43 Acre Lot
  • Wood Fence
  • Corner Lot
  • Sloped Lot
  • Sprinkler System
  • Landscaped with Trees
  • Property is zoned RL

HOA Fees

  • $58 Monthly HOA Fees

Parking

  • 4 Car Attached Garage
  • Heated Garage
  • Garage Door Opener

Home Design

  • Brick Veneer
  • Wood Frame Construction
  • Slate Roof

Interior Spaces

  • 7,451 Sq Ft Home
  • 2-Story Property
  • Open Floorplan
  • Wet Bar
  • Central Vacuum
  • Bar Fridge
  • Crown Molding
  • Cathedral Ceiling
  • Gas Log Fireplace
  • Window Treatments
  • Bay Window
  • Wood Frame Window
  • Family Room
  • Dining Room
  • Home Office
  • Mountain Views
  • Basement Fills Entire Space Under The House

Kitchen

  • Eat-In Kitchen
  • Double Oven
  • Gas Oven or Range
  • Microwave
  • Dishwasher
  • Kitchen Island
  • Disposal

Flooring

  • Wood
  • Carpet
  • Tile

Bedrooms and Bathrooms

  • 6 Bedrooms
  • Walk-In Closet
  • Jack-and-Jill Bathroom
  • Primary bathroom on main floor

Laundry

  • Laundry on main level
  • Dryer
  • Washer

Home Security

  • Security System Owned
  • Fire and Smoke Detector

Outdoor Features

  • Deck
  • Patio
  • Exterior Lighting
  • Outdoor Storage

Schools

  • Mcgraw Elementary School
  • Webber Middle School
  • Rocky Mountain High School

Utilities

  • Forced Air Heating and Cooling System
  • High Speed Internet
  • Cable TV Available

Listing and Financial Details

  • Assessor Parcel Number R1314530

Community Details

Overview

  • Clarendon Hills Association
  • Orchards At Clarendon Hills Subdivision

Recreation

  • Park

Home Details

Home Type

Single Family

Est. Annual Taxes

$8,106

Year Built

Built in 1992

Lot Details

0

HOA Fees

$58 per month

Parking

4

Listing Details

  • Inclusions: Window Coverings,Gas Range/Oven,Double Oven,Dishwasher,Refrigerator,Bar Refrigerator,Clothes Washer,Clothes Dryer,Microwave,Central Vacuum,Security System Owned,Garage Door Opener,Disposal,Smoke Alarm(s)
  • Year Built: 1992
  • Property Sub Type: Residential-Detached
  • Prop. Type: Residential
  • Horses: No
  • Lot Size Acres: 0.43
  • Road Frontage Type: City Street
  • Road Surface Type: Paved, Asphalt
  • Subdivision Name: Orchards At Clarendon Hills
  • Above Grade Finished Sq Ft: 4982
  • Garage Yn: Yes
  • Unit Levels: Two
  • New Construction: No
  • Building Stories: 2
  • Kitchen Level: Main
  • IRESDS_HasWaterRights: No
  • IRESDS_Total Sq Ft: 7451
  • Special Features: VirtualTour
  • Stories: 2

Interior Features

  • Possible Use: Single Family
  • Private Spa: No
  • Appliances: Gas Range/Oven, Double Oven, Dishwasher, Refrigerator, Bar Fridge, Washer, Dryer, Microwave, Disposal
  • Accessibility Features: Main Floor Bath, Main Level Laundry
  • Has Basement: Full, Partially Finished
  • Full Bathrooms: 2
  • Half Bathrooms: 2
  • Three Quarter Bathrooms: 2
  • Total Bedrooms: 6
  • Below Grade Sq Ft: 2469
  • Fireplace Features: Gas, Gas Logs Included
  • Fireplace: Yes
  • Flooring: Wood Floors
  • Interior Amenities: Study Area, High Speed Internet, Central Vacuum, Eat-in Kitchen, Separate Dining Room, Cathedral/Vaulted Ceilings, Open Floorplan, Pantry, Stain/Natural Trim, Walk-In Closet(s), Wet Bar, Jack & Jill Bathroom, Kitchen Island, 9ft+ Ceilings, Crown Molding
  • Living Area: 7451
  • Main Level Bathrooms: 2
  • Window Features: Window Coverings, Wood Frames, Bay Window(s)
  • Bedroom Features: Carpet
  • Room Bedroom4 Area: 154
  • Room Bedroom3 Features: Carpet
  • Dining Room Features: Carpet
  • IRESDS_HasFamilyRoom: Yes
  • Room Bedroom4 Level: Upper
  • Living Room Living Room Level: Main
  • Room Bedroom3 Area: 169
  • Room Bedroom4 Features: Carpet
  • Master Bedroom Master Bedroom Level: Upper
  • Room Bedroom2 Area: 165
  • Room Bedroom3 Level: Upper
  • Master Bedroom Master Bedroom Width: 18
  • Room Family Room Area: 357
  • Room Bedroom2 Level: Upper
  • Room Bedroom2 Features: Carpet
  • Master Bedroom Features: Carpet
  • Room Bedroom5 Level: Lower
  • Room Bedroom5 Features: Carpet
  • Room Family Room Level: Basement
  • Room Bedroom5 Area: 195
  • Room Kitchen Features: Tile Floor
  • Room Living Room Area: 272
  • Family Room Features: Carpet
  • Living Room Features: Carpet
  • Room Kitchen Area: 315
  • Dining Room Dining Room Level: Main
  • Room Master Bedroom Area: 360
  • Room Dining Room Area: 208
  • Master Bathroom Features: Luxury Features Primary Bath, 5 Piece Primary Bath

Exterior Features

  • Roof: Slate
  • Fencing: Fenced, Wood
  • Lot Features: Curbs, Gutters, Sidewalks, Lawn Sprinkler System, Corner Lot, Sloped
  • View: Mountain(s), Foothills View
  • View: Yes
  • Waterfront: No
  • Disclosures: Seller's Property Disclosure
  • Home Warranty: No
  • Construction Type: Wood/Frame, Brick/Brick Veneer
  • Exterior Features: Lighting
  • Other Structures: Storage
  • Patio And Porch Features: Patio, Deck
  • Property Condition: Not New, Previously Owned

Garage/Parking

  • Attached Garage: Yes
  • Covered Parking Spaces: 4
  • Garage Spaces: 4
  • Parking Features: Garage Door Opener, Heated Garage, Oversized
  • IRESDS_Garage Sq Ft: 1096
  • IRESDS_GarageType: Attached

Utilities

  • Cooling: Central Air
  • Electric: Electric, FTC
  • Heating: Forced Air
  • Utilities: Natural Gas Available, Electricity Available, Cable Available
  • Laundry Features: Washer/Dryer Hookups, Main Level
  • Security: Security System Owned, Smoke Detector(s)
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Electricity On Property: No
  • Sewer: City Sewer
  • Water Source: City Water, FTC/LVD
  • Gas Company: Natural Gas, Xcel

Condo/Co-op/Association

  • Community Features: Park
  • Senior Community: No
  • Association Fee: 700
  • Association Fee Frequency: Annually
  • Association Name: Clarendon Hills
  • Association: Yes

Association/Amenities

  • IRESDS_HasAssociationReserve: Yes
  • IRESDS_HasAssociationFee: Yes

Schools

  • Elementary School: Mcgraw
  • HighSchool: Rocky Mountain
  • Junior High Dist: Poudre
  • Middle Or Junior School: Webber

Lot Info

  • Zoning: RL
  • Lot Size Sq Ft: 18882
  • Parcel #: R1314530
  • Irrigation Water Rights: No

Tax Info

  • Tax Year: 2024
  • Tax Annual Amount: 8106

Multi Family

Map

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

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 $8,106 $86,986 $14,070 $72,916
2024 $7,715 $86,986 $14,070 $72,916
2022 $5,613 $58,519 $10,842 $47,677
2021 $5,674 $60,203 $11,154 $49,049
2020 $7,397 $77,813 $11,154 $66,659
2019 $7,429 $77,813 $11,154 $66,659
2018 $6,973 $75,269 $7,920 $67,349
2017 $6,949 $75,269 $7,920 $67,349
2016 $6,119 $65,949 $8,756 $57,193
2015 $6,076 $65,950 $8,760 $57,190
2014 $6,569 $70,850 $6,370 $64,480
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
08/27/2025 08/27/25 For Sale $1,899,900 -- $255 / Sq Ft
Source: IRES MLS

Purchase History

Date Type Sale Price Title Company
Quit Claim Deed -- --
Quit Claim Deed -- --
Warranty Deed $60,000 --
Source: Public Records

Similar Homes in Fort Collins, CO

  • 4918 Hinsdale Dr, Fort Collins, CO 80526

    $1,700,000

    • 4 Beds
    • 3.5 Baths
    • 5,657 Sq Ft
    • 4918 Hinsdale Dr
    • Fort Collins, CO

    Step into a masterpiece of form & function at 4918 Hinsdale Drive, Fort Collins, a custom-designed residence paying homage to Frank Lloyd Wright's craftsman style. This 5,657 square foot home sits on a generous 0.32-acre lot, embodying beauty & efficiency. With 4 bedrooms & 4 bathrooms, this property seamlessly blends comfort & luxury, backing to private open space. The home's design focuses on

    Kelly McBartlett Compass - Boulder

    Section Image
  • 5213 Castle Ridge Place, Fort Collins, CO 80525

    $2,100,000

    • 4 Beds
    • 5 Baths
    • 5,871 Sq Ft
    • 5213 Castle Ridge Place
    • Fort Collins, CO

    Discover this spectacular Miramont residence, perfectly positioned on a private cul-de-sac with stunning mountain views and direct access to neighborhood green space. Designed with both comfort and sophistication in mind, this home offers a spacious open floor plan filled with natural light, soaring ceilings, and high-end finishes throughout. The main floor features a luxurious primary retreat,

    Eric Hansen Group Mulberry

    Section Image
  • 1030 Harbor Walk Ct, Fort Collins, CO 80525

    $2,399,000

    • 5 Beds
    • 6 Baths
    • 5,760 Sq Ft
    • 1030 Harbor Walk Ct
    • Fort Collins, CO

    A rare chance at lakeside luxury-now at a REMARKABLE NEW PRICE! Discover one of Fort Collins' most coveted addresses on the exclusive, private Warren Lake-where only a handful of homes enjoy this level of unobstructed lake and mountain views. Perfectly positioned in a quiet cul-de-sac on a 12,000+ sq ft lot framed by mature trees, this sprawling ranch offers nearly 3,000 sq ft of main-level

    Lani Carwin RE/MAX Alliance-Loveland

    Section Image
  • 3014 Broadwing Rd, Fort Collins, CO 80526

    $2,500,000

    • 5 Beds
    • 4 Baths
    • 5,245 Sq Ft
    • 3014 Broadwing Rd
    • Fort Collins, CO

    Exquisite Living. Revel in the seamless blend of modern design and comfort! Uncompromising quality, modern designer finishes, sublime outdoor entertainment areas, and an impressive unobstructed view of Horsetooth make this newer home on a .45-acre premium lot on the west side of town a remarkable find and a sight to behold! Designed by renowned local architect David Hueter, built by Archer Homes

    Jaione Osborne Group Harmony

    Section Image
  • 7507 Blue Water Ct, Fort Collins, CO 80525

    $1,599,000

    • 5 Beds
    • 5 Baths
    • 6,960 Sq Ft
    • 7507 Blue Water Ct
    • Fort Collins, CO

    An opportunity seen infrequently in South Fort Collins, an acreage property for those who seek space, privacy, and an unbeatable location. Curated for hobbyist, car enthusiasts, and equestrians alike. 7507 Blue Water Ct boasts an impressive, near 7,000 total SF. Dual staircases, a feature few will oppose, sets the tone with a beautiful grand entry, and quick access to living areas above. A formal

    Gus Bergs RE/MAX Alliance-Loveland

    Section Image
  • 1909 Pawnee Dr, Fort Collins, CO 80525

    $1,825,000

    • 5 Beds
    • 4.5 Baths
    • 4,080 Sq Ft
    • 1909 Pawnee Dr
    • Fort Collins, CO

    A rare opportunity to own a home created by renowned designer & builder Rucker Hill. The aesthetic value of this home is difficult to describe. The material selections & finish quality are virtually impossible to find in the FC market and rarely if ever offered in Indian Hills. An oversized covered front porch & fluted white oak doors, white oak millwork & wide plank Malibu oak floors. Main floor

    Ryan Jenkins Grey Rock Realty

    Section Image
  • 6309 Meadow Grass Ct, Fort Collins, CO 80528

    $1,575,000

    • 5 Beds
    • 5.5 Baths
    • 5,852 Sq Ft
    • 6309 Meadow Grass Ct
    • Fort Collins, CO

    Welcome to this pristine, upgraded, and expanded Orion model in the sought-after Kechter Farm community-perfectly situated on a premium cul-de-sac lot with breathtaking mountain views. From the moment you enter, you'll be greeted by an elegant foyer, dramatic curved staircase, and soaring 19-ft ceilings that create an open, light-filled ambiance. This meticulously maintained 5-bed, 6-bath home

    Pamela Bantham Group Harmony

    Section Image
  • 1000 W Prospect Rd, Fort Collins, CO 80526

    $1,600,000

    • 4 Beds
    • 2 Baths
    • 4,416 Sq Ft
    • 1000 W Prospect Rd
    • Fort Collins, CO

    Come experience the Honorable Claude C. Coffin mansion, a District Judge and a Pioneer family in Northern Colorado! Also an amateur archaeologist, you must see the rock wall that was constructed from fossil rocks collected by the family which stands tall guarding these incredible landscaped courtyards and tree filled grounds. (So quiet and tucked in you almost don't even know you are on Prospect)

    Michael Jensen Fort Collins Real Estate, LLC

    Section Image
  • 3300 Continental Cir, Fort Collins, CO 80526

    $1,895,000

    • 5 Beds
    • 4 Baths
    • 3,969 Sq Ft
    • 3300 Continental Cir
    • Fort Collins, CO

    Foothills Luxury with Sweeping Reservoir Views. Where elegance, privacy, and panoramic beauty converge. Welcome to your Rocky Mountain sanctuary-an extraordinary 5-bedroom, 4-bathroom retreat that blends refined architectural design with nature's most breathtaking canvas. Perched atop the foothills, this elevated home with recent custom updates throughout, offers uninterrupted 360-degree

    Koa Schumann LIV Sotheby's Intl Realty

    Section Image

Source: IRES MLS

MLS Number: 1042288

IRES MLS

APN: 96023-11-027