1480 Upland Ave, Boulder, CO 80304
Property image
Property image
FOR SALE
0.85 ACRES

$4,900,000

  • 6 Beds
  • 5.5 Baths
  • 7,406 sqft (on 0.85 acres)

1480 Upland Ave, Boulder, CO 80304

Crestview
Est. Mortgage $27,016/mo*
Get Pre-Qualified

Home Highlights

Parking
3 Car Garage
Outdoor
Deck
Price/Sqft
$662
Listed
45 days ago
Climate Control
Radiant & Central Air

Local Information

  • Map ViewExplore the area around 1480 Upland Ave.
  • Schools1 Elementary School1 Middle School1 High School
  • Shop & Eat
-- mins to
Commute Destination

About this House

Scale is easy to advertise and hard to execute. Here, it works. Built by a respected local builder as his own residence, this Prairie-inspired home offers the kind of volume, craftsmanship, and setting that would be difficult to recreate today. With 12 foot ceilings and rooms of genuine proportion, this is a home best measured not only in square feet, but in cubic feet.The arrival is memorable: a circular fountain, broad motor court, mature trees, and an oversized attached garage establish privacy and permanence. The yard which is 2 extra large lots, feels more like a private park than a conventional city property, with broad lawns, sandstone terraces, and multiple outdoor entertaining spaces positioned to capture Flatirons views. Inside, coffered and beamed ceilings, travertine floors, custom millwork, and wood-framed French doors bring warmth and natural light to the home's generous scale. The great room is anchored by a hand-carved cast-stone fireplace and connects easily to the dining room and kitchen. A large Italian-marble island, custom cabinetry, abundant workspace, and a bright breakfast area make the kitchen practical for everyday living and a crowd.Six bedrooms and six baths provide flexibility for family, guests, and offices. Several are en suite, with access to balconies or patios. The primary suite is quiet and private. The lower level adds a theater, recreation and game areas, a wet bar, and a kitchenette, creating room for extended stays or multigenerational living. The property may also offer accessory-unit potential, subject to City approval. A tile roof and enduring stone-and-stucco construction complete a home built for the long term. Minutes from downtown and Boulder's trail system, this is a substantial property in a setting increasingly difficult to find. Reintroduced with a clear understanding of today's market, the seller is prepared to engage seriously and respond to a well-structured offer.
Last check for updates: about 2 hours ago
Listing courtesy of Joel Ripmaster, (303) 641-3377
Madison & Company Properties - Boulder

Home Details for 1480 Upland Ave

Interior Features

Interior Details
Basement: Full,Partially Finished,Daylight,Built-In Radon,Radon Test Available,Sump PumpNumber of Rooms: 13Types of Rooms: Primary Bedroom, Bedroom 2, Bedroom 3, Bedroom 4, Bedroom 5, Bedroom 6, Dining Room, Family Room, Kitchen, Laundry, Living Room, Recreation Room, StudyWet Bar
Beds & Baths
Number of Bedrooms: 6Number of Bathrooms: 6Number of Bathrooms (full): 2Number of Bathrooms (three quarters): 3Number of Bathrooms (half): 1Number of Bathrooms (main level): 2
Dimensions and Layout
Living Area: 7406 Square Feet
Appliances & Utilities
Utilities: Natural Gas Available, Electricity Available, Cable Available, High Speed AvailAppliances: Electric Range, Gas Range, Double Oven, Dishwasher, Refrigerator, Bar Fridge, Washer, Dryer, Microwave, Freezer, Gas Bar-B-Q, Water Purifier Owned, DisposalDishwasherDisposalDryerLaundry: Sink,Washer/Dryer HookupMicrowaveRefrigeratorWasher
Heating & Cooling
Heating: RadiantHas CoolingAir Conditioning: Central AirHas HeatingHeating Fuel: Radiant
Fireplace & Spa
Fireplace: Two or More, Gas, Great RoomSpa: HeatedHas a Fireplace
Gas & Electric
Electric: XcelGas: XcelHas Electric on Property
Windows, Doors, Floors & Walls
Window: Skylight(s), Window Coverings, Wood FramesFlooring: Wood
Levels, Entrance, & Accessibility
Stories: 2Levels: TwoAccessibility: Level Lot, Level Drive, Near Bus, Accessible Hallway(s), Main Floor Bath, Accessible Bedroom, Stall Shower, Main Level LaundryFloors: Wood
View
Has a ViewView: Hills
Security
Security: Fire Alarm

Exterior Features

Exterior Home Features
Roof: TilePatio / Porch: DeckExterior: Sprinkler System, BalconyFoundation: SlabSprinkler System
Parking & Garage
Number of Garage Spaces: 3Number of Covered Spaces: 3Other Parking: AttachedNo CarportHas a GarageHas an Attached GarageParking Spaces: 3Parking: Garage Door Opener,RV Access/Parking,Attached,>8' Garage Door,Heated Garage,Oversized
Frontage
Road Frontage: City StreetRoad Surface Type: AsphaltNot on Waterfront
Water & Sewer
Sewer: Public Sewer
Farm & Range
Does Not Include Irrigation Water Rights
Finished Area
Finished Area (above surface): 4584 Square Feet

Days on Market

Days on Market: 45

Property Information

Year Built
Year Built: 1997
Property Type / Style
Property Type: ResidentialProperty Subtype: Single Family ResidenceArchitecture: Contemporary
Building
Construction Materials: StuccoNot a New ConstructionNot Attached Property
Property Information
Not Included in Sale: Seller's Personal PropertyParcel Number: R0513918

Price & Status

Price
List Price: $4,900,000Price Per Sqft: $662

Active Status

MLS Status: Active

Location

Direction & Address
City: BoulderCommunity: Moores
School Information
Elementary School: Crest ViewJr High / Middle School: CentennialHigh School: BoulderHigh School District: Boulder Valley Dist RE2

Agent Information

Listing Agent
Listing ID: 1064231

Building

Building Area
Building Area: 4584 Square Feet

HOA

No HOA

Lot Information

Lot Area: 0.85 acres

Listing Info

Special Conditions: Private Owner

Offer

Listing Terms: Cash, Conventional

Energy

Energy Efficiency Features: Southern Exposure, Windows, Thermostat

Miscellaneous

BasementMls Number: 1064231Attribution Contact: 303-641-3377Above Grade Unfinished Area: 4584Activation Date: Thu Jul 23 2026Showing Service Name: ShowingTime

Around this home

The GreatSchools Rating compares schools on a variety of school quality indicators including test scores, college readiness, equity and more. Learn more.

Neighborhood Overview

Neighborhood stats provided by third party data sources.

Market trends in Boulder

Last updated July 2026
Buyer'sMarketSeller'sMarket
Avg. sale price
$897K
$10.37K
MoM
Sale-to-List Price
98.4%
0.1%
MoM
Price per sq ft
$499
$4
MoM
Available listings
760
19
MoM

Home Value

Trulia Estimate
$4.51M
Since last month
Decreased$218K (-4.6%)
Since last year
Decreased$101K (-2.2%)
Since last sale
Increased$2M (+69.3%)
Learn more about this home's value by checking out its Trulia Estimate, the value of nearby homes, and how much similar homes have sold for.

Trulia Estimate

The of this home's value increased by +42% in the last 10 years
MonthEstimated value
2026
August 2026$4.54M
July 2026$4.75M
June 2026$4.87M
May 2026$4.77M
April 2026$4.71M
March 2026$4.63M
February 2026$4.51M
January 2026$4.41M
2025
2024
2023
2022
2021
2020
2019
2018
2017
2016

Comparable sales

These are recently sold homes that have a similar location or other similar features to this home, like bedrooms, bathrooms, and square footage. Get a sense of the expected prices in the area by viewing these homes.
Address
Distance
Property Type
Sold Price
Sold Date
Bed
Bath
Sqft
0.27
Single-Family Home
$2,800,000
10/28/25
5
4.5
5,179
0.43
Single-Family Home
$3,250,000
02/23/26
5
5
6,515
0.45
Single-Family Home
$2,687,750
06/04/26
6
5
4,853
0.51
Single-Family Home
$5,800,000
05/12/26
7
5.5
7,124
0.46
Single-Family Home
$5,600,000
07/06/26
5
5.5
6,734
0.38
Single-Family Home
$1,680,000
09/22/25
4
4.5
3,512
0.33
Single-Family Home
$4,300,000
02/27/26
5
5
4,959
0.36
Single-Family Home
$2,680,000
05/19/26
5
4
4,051
0.37
Single-Family Home
$2,600,000
06/12/26
4
4
3,456

Nearby home prices

Get a sense of expected prices in the area by checking the value of nearby homes.
Address
Distance
Price
Bed
Bath
Sqft
Status
0.10
$1,990,000
5
3.5
2,854
For Sale
0.05
$3,900,000
4
3.5
4,517
For Sale
0.13
$2,100,000
3
2.5
2,826
For Sale
0.10
$1,392,600
3
2.5
1,482
Off Market
0.16
$3,167,200
5
6
5,111
Off Market
0.19
$1,220,600
4
2
2,000
Off Market
0.19
$1,075,200
3
2
1,952
Off Market
0.19
$1,047,700
3
2
1,434
Off Market
0.12
$2,900,000
-
-
-
For Sale
0.14
$1,223,900
4
2
1,544
Off Market
0.20
$997,200
2
3
1,969
Off Market

Price and Tax history

DateEventPrice
Jul 23, 2026
Source: IRES as distributed by MLS GRID #1064231
Listed For Sale
$4,900,000
Aug 10, 2020
Source: Agent Provided
ListingRemoved
$3,250,000
Mar 4, 2020
Source: Agent Provided
Listed For Sale
$3,250,000
Aug 24, 2019
Source: Agent Provided
ListingRemoved
$3,250,000
Sep 7, 2018
Source: Agent Provided
PriceChange
$3,250,000
Price decreased by 17%

LGBTQ Local Legal Protections

Joel Ripmaster, Madison & Company Properties - Boulder
Agent Phone: (303) 641-3377
Based on information submitted to the MLS GRID as of 2026-08-29 17:28:26 PDT. All data is obtained from various sources and may not have been verified by broker or MLS GRID. Supplied Open House Information is subject to change without notice. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information. Some IDX listings have been excluded from this website. Click here for more information

Similar Homes You May Like

Skip to last item
Skip to first item

New Listings near 1480 Upland Ave

Skip to last item
Skip to first item

Frequently asked questions about 1480 Upland Ave

  • What is the estimated monthly payment for 1480 Upland Ave?
    Based on a $4,900,000 list price with 20% down at today's rates, the estimated monthly payment for 1480 Upland Ave in Boulder, CO is approximately $27,972 (about $25,733 principal & interest, $2,164 property taxes, and $75 homeowner's insurance). This is an estimate. Actual payment depends on your loan terms.
  • How does the list price for 1480 Upland Ave compare to homes in Boulder?
    1480 Upland Ave in Boulder, CO is listed at $4,900,000, about 446% above the $897K median sale price in Boulder.
  • What are the closest schools to 1480 Upland Ave?
    The closest schools to 1480 Upland Ave in Boulder, CO are Boulder High School (rated 9/10), Centennial Middle School (rated 6/10), Crest View Elementary School (rated 9/10).
  • What is 1480 Upland Ave estimated to be worth?
    Trulia's estimated value for 1480 Upland Ave in Boulder, CO is $4,513,300.
  • Does 1480 Upland Ave have air conditioning?
    Yes, 1480 Upland Ave in Boulder, CO has air conditioning.
  • Does 1480 Upland Ave have laundry facilities?
    Yes, 1480 Upland Ave in Boulder, CO has in-unit laundry.
1480 Upland Ave, Boulder, CO 80304 is a 6 bedroom, 6 bathroom, 7,406 sqft single-family home built in 1997. 1480 Upland Ave is located in Crestview, Boulder. This property is currently available for sale and was listed by IRES as distributed by MLS GRID on Jul 15, 2026. The MLS # for this home is MLS# 1064231.