Prevu by reAlpha
BuySellBlogBrowse Listings

860 Union AvenueBoulder, CO 80304

For Sale

$2,595,000

Smart Buyer Rebate $25,950

A striking architectural residence in one of North Boulder’s most desirable pockets, perfectly positioned between Wonderland Lake and Foothills Community Park offering immediate access to miles of trails, open space, and some of North Boulder’s most coveted outdoor amenities. This 5-bedroom, 4-bath masterpiece offers over 4,000 square feet of thoughtfully designed living. Masterfully designed by architect JV DeSousa, the home is defined by clean lines, abundant natural light, soaring ceilings and a sense of volume and ease throughout. The open-concept main level is both refined and highly livable, anchored by custom artistic elements by local artist Osbourne Sculpture, including a statement fireplace, sculptural railing, and bespoke kitchen island. The flexible layout offers true versatility, featuring a spacious main-level office that easily converts to a guest suite with a built-in Murphy bed and access to an ensuite full bath. Function is seamlessly integrated with walk-in closets, built-in dressers, generous shelving, and a well-appointed laundry/mudroom with utility sink and custom cubbies. An oversized garage adds storage and convenience, while recent system upgrades, including two new furnaces, A/C systems, and solar panels producing energy beyond current usage, enhance efficiency and long-term value. Thoughtful capital improvements have been made throughout, including an extension of the outdoor living experience with a composite deck, wood fencing, a premium pergola, and low-water landscaping creating a private, low-maintenance setting designed for both relaxation and entertaining. The fully finished lower level expands the living space with a versatile layout, complete with built-in Murphy bunk beds, ideal for guests, media, or play. Fresh, intentionally minimal and architecturally distinct, this home offers a refined backdrop and a rare opportunity to own a truly enduring piece of North Boulder.

Listed by Alex Johnson

·

License #55043941

·

Atlas Real Estate Group

·

303-521-0187

Last updated April 02, 2026

·

Source: REcolorado #2663653

Listing Facts

  • TypeSingle-family
  • NeighborhoodNorth Wonderland
  • Bedrooms5
  • Bathrooms4
  • Days on Prevu28
  • Taxes$13,552/year
  • Size3,840 sqft
  • Price per sqft$676

Amenities

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

Location

Mortgage Calculator

Listing History

04/02/2026
Listed by Atlas Real Estate Group
$2,595,000

Property Details for 860 Union Avenue

Exterior

Construction

  • Roof: Composition
  • Structure Type: House
  • Year Built: 2001
  • Architectural Style: Contemporary
  • Construction Materials: Frame, Stone, Stucco
  • Exterior Features: Garden, Lighting, Private Yard

Features

  • Fencing: Full
  • Patio And Porch Features: Covered

Measurements

  • Building Area Total: 4,318
  • Lot Features: Landscaped, Many Trees, Sprinklers In Front, Sprinklers In Rear
  • Lot Size Acres: 0.15
  • Lot Size Area: 6,412
  • Lot Size Square Feet: 6,412
  • Lot Size Units: Square Feet

Financial

Taxes

  • Parcel Number: R0034008
  • Tax Annual Amount: $13,552.00
  • Tax Year: 2025

Interior

Features

  • Appliances: Convection Oven, Cooktop, Dishwasher, Disposal, Dryer, Microwave, Refrigerator, Sump Pump, Washer
  • Fireplace Features: Gas
  • Fireplaces Total: 1
  • Flooring: Carpet, Laminate, Wood
  • Interior Features: Entrance Foyer, Granite Counters, High Speed Internet, Kitchen Island, Open Floorplan, Radon Mitigation System, Smart Thermostat, Vaulted Ceiling(s), Walk-In Closet(s)

Measurements

  • Living Area: 3,840

Rooms

  • Basement: Finished
  • Has Basement: Yes
  • Bathrooms Full: 4
  • Bathrooms Total Integer: 4
  • Bedrooms Total: 5
  • Main Level Bathrooms: 1
  • Main Level Bedrooms: 1

Other

General

  • Exclusions: All personal Property with the exception of Murphy Beds.

Location

  • Subdivision Name: Makena Taylor

Parking

Parking

  • Attached Garage: Yes
  • Garage Spaces: 2
  • Parking Total: 2

Schools

Elementary School

  • Elementary School: Foothill
  • 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
  • Middle Or Junior School District: Boulder Valley RE 2

Utilities

Equipment

  • Cooling: Central Air
  • Heating: Forced Air
  • Laundry Features: In Unit
  • Sewer: Public Sewer
  • Utilities: Cable Available, Electricity Connected

Frequently Asked Questions

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

There are 5 bedrooms and 4 bathrooms in this single-family home at 860 Union Avenue.

What schools are nearby to 860 Union Avenue?

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

Does this single-family home have parking?

Yes, there are 2 parking spaces available for 860 Union Avenue.

What are the annual taxes for 860 Union Avenue?

Annual taxes for this single-family home are estimated at $13,552.

How does 860 Union Avenue compare to other single-family homes in North Wonderland?

This single-family home is listed 53% above the average price for single-family homes in North Wonderland and has been on the market for 17 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 3,840 sqft.

860 Union Avenue is a 5-bedroom, 4-bath single-family home for sale in Boulder CO 80304. On Prevu for 28 days at $2,595,000. This property features 3,840 square feet of living space, located in North Wonderland. The median listing price for single-family homes in this area is $1,674,903. Nearby schools include Foothill Elementary School, Centennial Middle School, and Boulder High School. Additional 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.