Julie Leins
Keller Williams Advantage Realty LLC
(720) 902-8558
274 Total Sales
4 in Table Mesa
$1,143,000 Price Range
2790 Juilliard St Boulder, CO 80305
Table Mesa NeighborhoodEstimated Value: $2,364,000 - $2,550,000
4
Beds
3.5
Baths
3,722
Sq Ft
$663/Sq Ft
Est. Value
Highlights
- Media Room
- Sauna
- City View
- Mesa Elementary School Rated A
- Two Primary Bedrooms
- 0.45 Acre Lot
About This Home
As of June 2025Perched on a bluff in South Boulder's coveted Rolling Hills neighborhood, this stunning Mountain Modern Alpine Chalet offers breathtaking Flatiron views, elegant design, and true Colorado lifestyle. Thoughtfully designed by David Waugh and Niwot Associates, the home exudes warmth and sophistication with an open, light and airy contemporary floorplan, Brazilian cherry floors, alder trim, and four custom gas fireplaces. The gourmet kitchen is the heart of the home, featuring slab granite counters, a Sub-Zero fridge, and a Dacor gas cooktop-perfect for gathering around the fire or enjoying conversation in the open layout. Walls of windows invite the outdoors in, framing sunsets over the foothills and filling the home with natural light. The upper level primary suite is a private retreat with a five-piece luxury bath and balcony overlooking city lights and Baseline Reservoir. A second main floor primary suite with walk-in closet and five-piece bath, and two additional bedrooms in the lower level offer flexible living space for family, work, guests, or multi-generational living. Nearly half an acre of beautifully landscaped grounds includes extensive outdoor living areas with stone patios, garden areas, and a west-facing Trex deck ideal for morning coffee or evening wine while soaking in the views of the Flatirons. Just steps from some of the highest rated k-12 schools in the state. This home provides Colorado living at its finest with privacy, convenience, and easy access to trails, parks, and South Boulder favorites like Southern Sun Brew Pub, South Side Walnut Cafe, Boxcar Coffee, Sweet Cow and Whole Foods.
Last Agent to Sell the Property
8z Real Estate License #971395 Listed on: 06/02/2025
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area
Home Details
Home Type
- Single Family
Est. Annual Taxes
- $13,514
Year Built
- Built in 1967
Lot Details
- 19,615 Sq Ft Lot
- Southern Exposure
- Partially Fenced Property
- Sloped Lot
- Sprinkler System
- Landscaped with Trees
Parking
- 3 Car Attached Garage
- Garage Door Opener
Home Design
- Chalet
- Contemporary Architecture
- Wood Frame Construction
- Composition Roof
- Composition Shingle
- Stucco
- Stone
Interior Spaces
- 3,722 Sq Ft Home
- 4-Story Property
- Open Floorplan
- Cathedral Ceiling
- Skylights
- Multiple Fireplaces
- Gas Fireplace
- Double Pane Windows
- Window Treatments
- Family Room
- Living Room with Fireplace
- Media Room
- Recreation Room with Fireplace
- Sauna
- City Views
Kitchen
- Double Oven
- Gas Oven or Range
- Microwave
- Kitchen Island
Flooring
- Wood
- Carpet
- Tile
Bedrooms and Bathrooms
- 4 Bedrooms
- Fireplace in Primary Bedroom
- Double Master Bedroom
- Walk-In Closet
Laundry
- Laundry on lower level
- Dryer
- Washer
Outdoor Features
- Balcony
- Deck
- Patio
- Separate Outdoor Workshop
Schools
- Mesa Elementary School
- Southern Hills Middle School
- Fairview High School
Utilities
- Forced Air Heating and Cooling System
Community Details
- No Home Owners Association
- Rolling Hills Subdivision
Listing and Financial Details
- Assessor Parcel Number R0011458
Ownership History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
Date
Name
Owned For
Owner Type
Purchase Details
Listed on
Jun 2, 2025
Closed on
Jun 27, 2025
Sold by
Zellers Gordon B and Zellers Anne L
Bought by
Seller's Agent
Steve Altermatt
8z Real Estate
Buyer's Agent
Stella Frossard
Coldwell Banker Realty-Boulder
List Price
$2,600,000
Sold Price
$2,500,000
Premium/Discount to List
-$100,000
-3.85%
Views
31
Current Estimated Value
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
-$33,287
Avg. Annual Appreciation
-1.13%
Purchase Details
Closed on
May 13, 2009
Sold by
Buchholz William E
Bought by
Niwot Associates Llc
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$755,000
Interest Rate
4.77%
Mortgage Type
Purchase Money Mortgage
Purchase Details
Closed on
Sep 29, 2006
Sold by
Buchholz William E
Bought by
Niwot Associates Llc
Purchase Details
Closed on
Mar 3, 2006
Sold by
Spines Katherine
Bought by
Buchholz William E
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$490,000
Interest Rate
6.75%
Mortgage Type
Fannie Mae Freddie Mac
Purchase Details
Closed on
Jul 13, 1990
Bought by
Zellers Gordon B and Zellers Anne L
Purchase Details
Closed on
Feb 9, 1981
Bought by
Zellers Gordon B and Zellers Anne L
Home Values in the Area
Average Home Value in this Area
Agents Specializing in Table Mesa, CO
-
Julie Leins
-
Taylor Wilson
Taylor Wilson
Compass - Denver
(720) 575-2311
152 Total Sales
1 in Table Mesa
$855,000 Price
-
Maureen McCarthy
Maureen McCarthy
RE/MAX of Boulder
(877) 845-9815
103 Total Sales
2 in Table Mesa
$1.2M - $1.3M Price Range
-
Brett Sawyer
Brett Sawyer
Kentwood Real Estate Boulder Valley
(720) 706-6686
66 Total Sales
5 in Table Mesa
$1.3M - $1.5M Price Range
-
Leslie Hazan
Leslie Hazan
Compass - Denver
(720) 780-7158
55 Total Sales
1 in Table Mesa
$810,000 Price
-
Jim Loveridge
Jim Loveridge
Serhant Colorado LLC
(720) 575-0873
201 Total Sales
1 in Table Mesa
$1,475,000 Price
Purchase History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Buyer | Sale Price | Title Company |
|---|---|---|---|
| $2,500,000 | None Listed On Document | ||
| Niwot Associates Llc | -- | First Colorado Title | |
| Zellers Gordon B | $1,120,000 | First Colorado Title | |
| Niwot Associates Llc | -- | None Available | |
| Buchholz William E | $699,500 | First Colorado Title | |
| Zellers Gordon B | $220,000 | -- | |
| Zellers Gordon B | $144,500 | -- |
Source: Public Records
Mortgage History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Status | Borrower | Loan Amount |
|---|---|---|---|
| Previous Owner | $755,000 | ||
| Previous Owner | Buchholz William E | $490,000 |
Source: Public Records
Property History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Event | Price | List to Sale | Price per Sq Ft |
|---|---|---|---|---|
| 06/27/2025 06/27/25 | Sold | $2,500,000 | -3.8% | $672 / Sq Ft |
| 04/22/2025 04/22/25 | For Sale | $2,600,000 | -- | $699 / Sq Ft |
Source: IRES MLS
Tax History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Year | Tax Paid | Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. | Land | Improvement |
|---|---|---|---|---|
| 2026 | $13,735 | $156,727 | $81,301 | $75,426 |
| 2025 | $13,735 | $156,727 | $81,301 | $75,426 |
| 2024 | $13,514 | $144,050 | $74,725 | $69,325 |
| 2023 | $13,280 | $153,772 | $86,417 | $71,040 |
| 2022 | $14,896 | $160,406 | $82,295 | $78,111 |
| 2021 | $14,204 | $165,022 | $84,663 | $80,359 |
| 2020 | $11,248 | $129,222 | $75,719 | $53,503 |
| 2019 | $11,076 | $129,222 | $75,719 | $53,503 |
| 2018 | $11,577 | $133,524 | $78,624 | $54,900 |
| 2017 | $11,214 | $147,618 | $86,923 | $60,695 |
| 2016 | $10,531 | $121,652 | $69,968 | $51,684 |
| 2015 | $9,972 | $101,148 | $42,188 | $58,960 |
| 2014 | $8,505 | $101,148 | $42,188 | $58,960 |
Source: Public Records
Agents Affiliated with this Home
-
Steve Altermatt
Seller's Agent in 2025
Steve Altermatt
8z Real Estate
(303) 441-5669
39 in this area
116 Total Sales
-
Stella Frossard
Buyer's Agent in 2025
Stella Frossard
Coldwell Banker Realty-Boulder
(720) 280-7232
1 in this area
4 Total Sales
Map
Source: IRES MLS
MLS Number: IRE1031677
APN: 1577172-05-012
Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.
Information source: Information and Real Estate Services, LLC. Provided for limited non-commercial use only under IRES Rules © Copyright IRES.
Based on information submitted to the MLS GRID. 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. Listing information is provided exclusively for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.
Information deemed reliable but not guaranteed by the MLS.
Based on information submitted to the MLS GRID
Listings courtesy of IRES MLS as distributed by MLS GRID
Nearby Homes
- 2920 Lafayette Dr
- 3310 Heidelberg Dr
- 3006 Redstone Ln Unit E1
- 3061 Redstone Ln Unit A3
- 3343 Cripple Creek Trail Unit H12
- 3420 Cripple Creek Square Unit G20
- 3347 Cripple Creek Trail Unit G12
- 3296 Cripple Creek Trail Unit 5D
- 3620 Silver Plume Ln
- 3760 Silver Plume Ln
- 1365 Georgetown Rd
- 3605 Endicott Dr
- 1360 Lehigh St
- 3772 Telluride Ln
- 3735 Emerson Ave
- 1449 Rockmont Cir
- 3290 Darley Ave
- 1145 Claremont Dr
- 4204 Greenbriar Blvd Unit 45
- 1095 Edinboro Dr
- 2810 Juilliard St
- 2780 Juilliard St
- 2760 Juilliard St
- 2820 Juilliard St
- 2850 Juilliard St
- 2785 Juilliard St
- 2915 Lafayette Dr
- 2750 Juilliard St
- 2895 Lafayette Dr
- 2945 Lafayette Dr
- 1780 Ithaca Dr
- 2765 Juilliard St
- 2825 Juilliard St
- 2860 Juilliard St
- 2855 Lafayette Dr
- 2755 Juilliard St
- 2975 Lafayette Dr
- 1765 Ithaca Dr
- 2845 Juilliard St
- 2740 Juilliard St
Your Personal Tour Guide
Ask me questions while you tour the home.