1480 Upland Ave
Boulder, CO 80304
Crestview- 6 Beds
- 5.5 Baths
- 7,406 sqft (on 0.85 acres)
6 Beds
5.5 Baths
7,406 sqft
(on 0.85 acres)
Local Information
-- mins to
Description
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 large lot 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.
Home Highlights
Parking
3 Car Garage
Outdoor
Deck
A/C
Heating & Cooling
HOA
None
Price/Sqft
$662
Listed
Less than a day ago
Home Details for 1480 Upland Ave
|
|---|
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 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: <1 day on Trulia |
|
|---|
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 List Price: $4,900,000Price Per Sqft: $662 |
|
|---|
MLS Status: Coming Soon |
|
|---|
Direction & Address City: BoulderCommunity: Moores |
School Information Elementary School: Crest ViewJr High / Middle School: CentennialHigh School: BoulderHigh School District: Boulder Valley Dist RE2 |
|
|---|
Listing Agent Listing ID: 1064231 |
|
|---|
Building Area Building Area: 4584 Square Feet |
|
|---|
No HOA |
|
|---|
Lot Area: 0.85 acres |
|
|---|
Special Conditions: Private Owner |
|
|---|
Listing Terms: Cash, Conventional |
|
|---|
Energy Efficiency Features: Southern Exposure, Windows, Thermostat |
|
|---|
BasementMls Number: 1064231Attribution Contact: 303-641-3377Above Grade Unfinished Area: 4584Activation Date: Thu Jul 23 2026Showing Service Name: ShowingTime |
Last check for updates: about 1 hour ago
Listing courtesy of Joel Ripmaster, (303) 641-3377
Madison & Company Properties - Boulder
Source: IRES as distributed by MLS GRID, MLS#1064231

Market trends in Boulder
Last updated June 2026
Avg. sale price
$891K
$60.83KMoM
Sale-to-List Price
98.2%
0.4%MoM
Price per sq ft
$503
$2MoM
Available listings
778
Price History for 1480 Upland Ave
| Date | Price | Event | Source |
|---|---|---|---|
| 08/10/2020 | $3,250,000 | ListingRemoved | Agent Provided |
| 03/04/2020 | $3,250,000 | Listed For Sale | Agent Provided |
| 08/24/2019 | $3,250,000 | ListingRemoved | Agent Provided |
| 09/07/2018 | $3,250,000 | PriceChange | Agent Provided |
| 03/24/2018 | $3,900,000 | PriceChange | Agent Provided |
| 06/09/2017 | $3,480,000 | PriceChange | Agent Provided |
| 01/31/2017 | $3,950,000 | Listed For Sale | Agent Provided |
| 01/31/2017 | $12,000 | ListingRemoved | Agent Provided |
| 01/19/2017 | $12,000 | Listed For Rent | Agent Provided |
| 02/29/2008 | $2,680,000 | Sold | N/A |
Similar Homes You May Like
New Listings near 1480 Upland Ave
Property Tax and Assessment
| Year | 2025 |
|---|---|
| Tax | $23,789 |
| Assessment | $4,086,200 |
Home facts updated by county records
Comparable Sales for 1480 Upland Ave
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 homes
Get a sense of prices in the area by checking nearby homes.Assigned Schools
These are the assigned schools for 1480 Upland Ave.
LGBTQ Local Legal Protections
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-07-15 10:18:10 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
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.

