Prevu by reAlpha
BuySellBlogBrowse Listings

1480 Upland AvenueBoulder, CO 80304

For Sale

$4,900,000

Smart Buyer Rebate $49,000

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.

Listed by Joel Ripmaster

·

License #IRP12286

·

Madison & Company Properties - Boulder

·

303-641-3377

Last updated July 23, 2026

·

Source: REcolorado #IR1064231

Listing Facts

  • TypeSingle-family
  • NeighborhoodCrestview
  • Bedrooms6
  • Bathrooms6
  • Days on Prevu16
  • Taxes$23,755/year
  • Size7,124 sqft
  • Price per sqft$688

Amenities

  • Dishwasher
  • Private Outdoor Space
  • Washer/Dryer
  • Air Conditioning
  • Parking

Location

Mortgage Calculator

Listing History

07/23/2026
Status changed to Active
$4,900,000
07/15/2026
Listed by Madison & Company Properties - Boulder
$4,900,000

Property Details for 1480 Upland Avenue

Exterior

Construction

  • Roof: Concrete
  • Structure Type: House
  • Window Features: Double Pane Windows, Skylight(s), Window Coverings
  • Year Built: 1997
  • Architectural Style: Contemporary
  • Construction Materials: Stucco
  • Exterior Features: Balcony, Gas Grill, Spa/Hot Tub

Features

  • Direction Faces: North
  • Patio And Porch Features: Deck
  • Road Frontage Type: Public
  • View: Mountain(s)

Measurements

  • Building Area Total: 7,406
  • Lot Features: Flood Zone, Level, Sprinklers In Front
  • Lot Size Acres: 0.85
  • Lot Size Square Feet: 37,026

Financial

Taxes

  • Parcel Number: R0513918
  • Tax Annual Amount: $23,755.00
  • Tax Year: 2025

Interior

Features

  • Appliances: Bar Fridge, Dishwasher, Disposal, Double Oven, Dryer, Freezer, Microwave, Oven, Refrigerator, Washer
  • Fireplace Features: Gas, Great Room
  • Flooring: Tile, Wood
  • Interior Features: Central Vacuum, Eat-in Kitchen, Kitchen Island, Open Floorplan, Pantry, Radon Mitigation System, Smart Thermostat, Vaulted Ceiling(s), Walk-In Closet(s), Wet Bar

Measurements

  • Living Area: 7,124

Rooms

  • Basement: Daylight, Full, Sump Pump
  • Has Basement: Yes
  • Bathrooms Full: 2
  • Bathrooms Half: 1
  • Bathrooms Three Quarter: 3
  • Bathrooms Total Integer: 6
  • Bedrooms Total: 6
  • Main Level Bathrooms: 2
  • Main Level Bedrooms: 1

Other

General

  • Exclusions: Seller's Personal Property

Location

  • Subdivision Name: Moores

Parking

Parking

  • Attached Garage: Yes
  • Garage Spaces: 3
  • Parking Features: Heated Garage, Oversized, Oversized Door, RV Access/Parking
  • Parking Total: 3

Schools

Elementary School

  • Elementary School: Crest View
  • Elementary School District: Boulder Valley RE 2

High School

  • High School: Boulder
  • High School District: Boulder Valley RE 2

Middle or Junior School

  • Middle Or Junior School: Centennial

Utilities

Equipment

  • Cooling: Central Air
  • Heating: Radiant
  • Laundry Features: In Unit
  • Sewer: Public Sewer
  • Utilities: Cable Available, Electricity Available, Internet Access (Wired), Natural Gas Available
  • Water Source: Public

Frequently Asked Questions

How many bedrooms and bathrooms does this single-family home have?

There are 6 bedrooms and 6 bathrooms in this single-family home at 1480 Upland Avenue.

What schools are nearby to 1480 Upland Avenue?

Nearby schools include the Crest View Elementary School, Centennial Middle School, and Boulder High School.

Does this single-family home have parking?

Yes, there are 3 parking spaces available for 1480 Upland Avenue.

What are the annual taxes for 1480 Upland Avenue?

Annual taxes for this single-family home are estimated at $23,755.

How does 1480 Upland Avenue compare to other single-family homes in Crestview?

This single-family home is listed 14% above the average price for single-family homes in Crestview and has been on the market for 46 less days than the typical home in this area.

What is the square footage on this single-family home?

According to the MLS, this listing is 7,124 sqft.

1480 Upland Avenue is a 6-bedroom, 6-bath single-family home for sale in Boulder CO 80304. Available on Prevu for 16 days at $4,900,000. This residence features 7,124 square feet of living space, located in Crestview. The median listing price for single-family homes in this area is $4,750,000. Nearby schools include Crest View Elementary School, Centennial Middle School, and Boulder High School. Property amenities include private outdoor space, dishwasher, air conditioning, parking, and washer/dryer. View other single-family home listings in Boulder.

The content relating to real estate for sale in this Web site comes in part from the Internet Data eXchange ("IDX") program of METROLIST, INC., DBA RECOLORADO® Real estate listings held by brokers other than Prevu are marked with the IDX Logo. This information is being provided for the consumers' personal, non-commercial use and may not be used for any other purpose. All information subject to change and should be independently verified.

Full MLS Disclaimers

Rebate estimate is indicative only and based on listing price and estimated buyer's agent commission paid by owner, if applicable. Final rebates are subject to Terms of Use and may vary due to final negotiated transaction terms.