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.

Property Details of 860 Union Avenue

Property Details

Interior Features

Utilities and Appliances

Community

Listed by Alex Johnson of Atlas Real Estate Group (alex.johnson@realatlas.com,303-521-0187)

Map Location

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 Tracy Brewer 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.

This publication is designed to provide information with regard to the subject matter covered. It is displayed with the understanding that the publisher and authors are not engaged in rendering real estate, legal, accounting, tax, or other professional services and that the publisher and authors are not offering such advice in this publication. If real estate, legal, or other expert assistance is required, the services of a competent, professional person should be sought.

The information contained in this publication is subject to change without notice. METROLIST, INC., DBA RECOLORADO MAKES NO WARRANTY OF ANY KIND WITH REGARD TO THIS MATERIAL, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. METROLIST, INC., DBA RECOLORADO SHALL NOT BE LIABLE FOR ERRORS CONTAINED HEREIN OR FOR ANY DAMAGES IN CONNECTION WITH THE FURNISHING, PERFORMANCE, OR USE OF THIS MATERIAL.

All real estate advertised herein is subject to the Federal Fair Housing Act and the Colorado Fair Housing Act, which Acts make it illegal to make or publish any advertisement that indicates any preference, limitation, or discrimination based on race, color, religion, sex, handicap, familial status, or national origin.

METROLIST, INC., DBA RECOLORADO will not knowingly accept any advertising for real estate that is in violation of the law. All persons are hereby informed that all dwellings advertised are available on an equal opportunity basis.

©2026 METROLIST, INC., DBA RECOLORADO® – All Rights Reserved 6455 S. Yosemite St., Suite 300 Greenwood Village, CO 80111 USA

ALL RIGHTS RESERVED WORLDWIDE. No part of this publication may be reproduced, adapted, translated, stored in a retrieval system or transmitted in any form or by any means, electronic, mechanical, photocopying, recording, or otherwise, without the prior written permission of the publisher. The information contained herein including but not limited to all text, photographs, digital images, virtual tours, may be seeded and monitored for protection and tracking.

Hi there! How can we help you?

Contact us using the form below or give us a call.

Send Us A Message:

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Hi there! How can we help you?

Contact us using the form below or give us a call.

Send Us A Message:

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Hi there! How can we help you?

Contact us using the form below or give us a call.

Send Us A Message:

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

$

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.