NOT LISTED FOR SALE

Estimated Value: $5,399,347 - $5,593,000

2 Beds
2.5 Baths
2,586 Sq Ft
$2,116/Sq Ft Est. Value

Last Sold October 01, 2024

Last sale price $5,600,000 $2,166 Per Sq Ft

Est. 2% decrease in value since last sale

Current estimated payment $31,933/month

139 Days on Market

Highlights

  • Private Pool
  • 1.03 Acre Lot
  • Mountain View
  • Foothill Elementary School Rated A
  • Open Floorplan
  • Stream or River on Lot

About This Home

As of October 2024

Your Boulder paradise awaits at 870 Juniper Avenue. This expansive property stretches over an acre and boasts southern exposure, flatiron views and water rights. Nestled right in the heart of the city, this rare find beckons to be your very own private retreat. Give the existing home your personal touch, or craft a new bespoke masterpiece on this gorgeous property. Take in the views of the iconic Flatirons, the soothing ambiance of Two Mile Creek through your backyard, and Silver Creek Ditch in the front of the lot, providing the owner their own source of irrigation. In addition to the beautiful views and tranquil water, the new owners will inherit an orchard-like backyard with established plants and trees, lending aesthetic allure and undeniable charm. You'll see in no time why Juniper Avenue is one of Boulder's most desirable and sought-after streets. Just down the road you'll find beloved local Boulder gems like Ideal Market and Lucky's. You'll also enjoy immediate access to Boulder's most iconic trails, seamlessly transitioning from urban living to our boundless wilderness. Bask in the harmonious balance of nature's tranquility and Boulder's vitality at this idyllic retreat.

Last Listed By

Lucy Conklin

Compass - Boulder Listed on: 05/15/2024

Compass - Boulder

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $16,721

Year Built

  • Built in 1963

Lot Details

  • 1.03 Acre Lot
  • South Facing Home
  • Fenced
  • Level Lot
  • Sprinkler System
  • Wooded Lot

Parking

  • 2 Car Garage
  • Carport

Home Design

  • Brick Veneer
  • Wood Frame Construction
  • Composition Roof

Interior Spaces

  • 2,586 Sq Ft Home
  • 1-Story Property
  • Open Floorplan
  • Cathedral Ceiling
  • Window Treatments
  • Dining Room
  • Recreation Room with Fireplace
  • Sun or Florida Room
  • Mountain Views
  • Washer and Dryer Hookup

Flooring

  • Wood
  • Carpet

Bedrooms and Bathrooms

  • 2 Bedrooms
  • Walk-In Closet
  • Primary Bathroom is a Full Bathroom

Pool

  • Private Pool
  • Spa

Outdoor Features

  • Stream or River on Lot
  • Exterior Lighting

Schools

  • Foothill Elementary School
  • Centennial Middle School
  • Boulder High School

Utilities

  • Forced Air Heating System
  • High Speed Internet
  • Satellite Dish
  • Cable TV Available

Community Details

  • No Home Owners Association
  • Foothills Subdivision

Listing and Financial Details

  • Assessor Parcel Number R0003198

Home Details

Home Type

Single Family

Est. Annual Taxes

$16,721

Year Built

Built in 1963

Lot Details

0

Parking

2

Listing Details

  • Year Built: 1963
  • Property Sub Type: Residential-Detached
  • Prop. Type: Residential
  • Horses: No
  • Lot Size Acres: 1.03
  • Road Frontage Type: City Street
  • Road Surface Type: Paved, Asphalt
  • Subdivision Name: Foothills
  • Directions: From Broadway, west on Juniper Ave, home is on the south side of the street.
  • Above Grade Finished Sq Ft: 2586
  • Architectural Style: Ranch
  • Garage Yn: Yes
  • Unit Levels: One
  • New Construction: No
  • Building Stories: 1
  • Kitchen Level: Main
  • Special Features: VirtualTour
  • Stories: 1

Interior Features

  • Possible Use: Single Family
  • Private Spa: Yes
  • Has Basement: None
  • Full Bathrooms: 1
  • Half Bathrooms: 1
  • Three Quarter Bathrooms: 1
  • Total Bedrooms: 2
  • Fireplace Features: Family/Recreation Room Fireplace
  • Fireplace: Yes
  • Flooring: Wood Floors
  • Interior Amenities: Satellite Avail, High Speed Internet, Separate Dining Room, Cathedral/Vaulted Ceilings, Open Floorplan, Walk-In Closet(s), Sunroom
  • Living Area: 2586
  • Window Features: Window Coverings, Sunroom
  • Dining Room Features: Carpet
  • Living Room Living Room Level: Main
  • Master Bedroom Master Bedroom Level: Main
  • Room Bedroom2 Area: 1
  • Master Bedroom Master Bedroom Width: 1
  • Room Bedroom2 Level: Main
  • Room Bedroom2 Features: Other Floor
  • Master Bedroom Features: Other Floor
  • Room Kitchen Features: Carpet
  • Room Living Room Area: 1
  • Living Room Features: Carpet
  • Room Kitchen Area: 1
  • Dining Room Dining Room Level: Main
  • Room Master Bedroom Area: 1
  • Room Dining Room Area: 1
  • Master Bathroom Features: Full Primary Bath
  • ResoLivingAreaSource: Assessor

Exterior Features

  • Roof: Composition
  • Fencing: Fenced
  • Lot Features: Curbs, Gutters, Fire Hydrant within 500 Feet, Lawn Sprinkler System, Wooded, Level, Abuts Ditch, Within City Limits, Stream
  • Pool Features: Private
  • Pool Private: Yes
  • View: Mountain(s), Foothills View
  • Waterfront: No
  • Construction Type: Wood/Frame, Brick/Brick Veneer
  • Direction Faces: South
  • Exterior Features: Lighting
  • Property Condition: Not New, Previously Owned

Garage/Parking

  • Attached Garage: No
  • Covered Parking Spaces: 2
  • Garage Spaces: 2
  • IRESDS_GarageType: Carport

Utilities

  • Electric: Electric, Xcel Energy
  • Heating: Forced Air
  • Utilities: Natural Gas Available, Electricity Available, Cable Available
  • Laundry Features: Washer/Dryer Hookups
  • Heating Yn: Yes
  • Sewer: City Sewer
  • Water Source: City Water, City of Boulder
  • Gas Company: Natural Gas, Xcel Energy

Condo/Co-op/Association

  • Senior Community: No
  • Association: No

Association/Amenities

  • IRESDS_HasAssociation2Reserve: No
  • IRESDS_HasAssociation2Fee: No
  • IRESDS_HasAssociationReserve: No
  • IRESDS_HasAssociationFee: No

Schools

  • Elementary School: Foothill
  • HighSchool: Boulder
  • Junior High Dist: Boulder Valley Dist RE2
  • Middle Or Junior School: Centennial

Lot Info

  • Zoning: RES
  • Lot Size Sq Ft: 44862
  • Parcel #: R0003198
  • ResoLotSizeUnits: SquareFeet

Tax Info

  • Tax Year: 2023
  • Tax Annual Amount: 16721

Multi Family

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
May 15, 2024
Closed on
Oct 1, 2024
Sold by
Elizabeth C Greenlee Revocable Trust and Greenlee Stephen C
Bought by
Juniper Home Llc
Seller's Agent
Lucy Conklin
Compass - Boulder
Buyer's Agent
Laura Morningstar
Compass - Boulder
List Price
$5,950,000
Sold Price
$5,600,000
Premium/Discount to List
-$350,000
-5.88%
Total Days on Market
139
Views
10
Current Estimated Value
$5,471,782

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
-$128,218
Avg. Annual Appreciation
-12.86%
Original Mortgage
$3,850,000
Outstanding Balance
$3,839,420
Interest Rate
6.46%
Mortgage Type
New Conventional
Estimated Equity
$1,338,008

Purchase Details

Closed on
Mar 17, 2015
Sold by
Max R Greenlee Jr Revocable Trust
Bought by
Elizabeth C Greenlee Revocable Trust

Purchase Details

Closed on
Jan 20, 2015
Sold by
Greenlee Max R and Greenlee Elizabeth C
Bought by
Elizabeth C Greenlee Revocable Trust

Purchase Details

Closed on
Apr 30, 1991
Bought by
Greenlee Elizabeth C Revocable Trust

Purchase Details

Closed on
Apr 10, 1991
Bought by
Greenlee Elizabeth C Revocable Trust

Purchase Details

Closed on
Feb 12, 1990
Bought by
Greenlee Elizabeth C Revocable Trust

Purchase Details

Closed on
Jul 6, 1982
Bought by
Greenlee Elizabeth C Revocable Trust

Range of Values:

Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
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 Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Purchase History

Date Buyer Sale Price Title Company
Juniper Home Llc $5,600,000 None Listed On Document
Elizabeth C Greenlee Revocable Trust -- None Available
Elizabeth C Greenlee Revocable Trust -- None Available
Greenlee Elizabeth C Revocable Trust $67,400 --
Greenlee Elizabeth C Revocable Trust -- --
Greenlee Elizabeth C Revocable Trust -- --
Greenlee Elizabeth C Revocable Trust -- --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Juniper Home Llc $3,850,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
10/01/2024 10/01/24 Sold $5,600,000 -5.9% $2,166 / Sq Ft
08/20/2024 08/20/24 For Sale $5,950,000 0.0% $2,301 / Sq Ft
08/18/2024 08/18/24 Off Market $5,950,000 -- --
05/15/2024 05/15/24 For Sale $5,950,000 -- $2,301 / Sq Ft
Source: IRES MLS

Tax History Compared to Growth

Source: Public Records

Tax History

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
2024 $16,721 $199,459 $179,145 $20,314
2023 $16,721 $199,459 $182,830 $20,314
2022 $14,652 $164,729 $148,256 $16,473
2021 $13,972 $169,469 $152,522 $16,947
2020 $13,277 $159,681 $127,270 $32,411
2019 $13,074 $159,681 $127,270 $32,411
2018 $9,774 $119,938 $95,472 $24,466
2017 $9,469 $132,598 $105,550 $27,048
2016 $9,591 $118,755 $94,485 $24,270
2015 $9,082 $94,222 $54,446 $39,776
2014 $7,253 $94,222 $54,446 $39,776
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Similar Homes in Boulder, CO

  • 1445 Moss Rock Place, Boulder, CO 80304

    $5,495,000

    • 4 Beds
    • 3.5 Baths
    • 4,189 Sq Ft
    • 1445 Moss Rock Place
    • Boulder, CO

    Contemporary Luxury with more than just architectural allure; it's a commitment to sustainability. A symphony of innovative systems converges for efficiency. Passive solar design, high-efficiency HVAC, "Tuned" Energy Star windows, foam insulation, and LED illumination. Elevate your lifestyle in a world where innovation meets luxury, where panoramic vistas and intimate moments coexist. Welcome to

    David Scott Slifer Smith & Frampton-Bldr

    Section Image
  • 563 Arapahoe Ave, Boulder, CO 80302

    $4,375,000

    • 4 Beds
    • 4.5 Baths
    • 4,274 Sq Ft
    • 563 Arapahoe Ave
    • Boulder, CO

    Riverfront Retreat in the Heart of Boulder. Welcome to a rare opportunity to own a front-row seat to Boulder Creek in one of Downtown Boulder's most sought-after neighborhoods. Tucked away in the historic Highland Lawn enclave of West Arapahoe, this beautifully restored four-bedroom, five-bathroom Victorian is a serene oasis designed for entertaining and easy living. With Boulder Creek flowing

    Kimberly (Kiki) Kidder Compass - Boulder

    Section Image
  • 3633 Broadway, Boulder, CO 80304

    $4,400,000

    • 3 Beds
    • 3.5 Baths
    • 3,130 Sq Ft
    • 3633 Broadway
    • Boulder, CO

    A rare opportunity to own a home that stands as a true testament to modern green design & sustainable building practices. Few homes in Colorado can boast such an impressive array of accolades, including Best Custom Home under 5,000 sq. ft. in Colorado (2019), the AIA Colorado Award of Merit in Sustainable Design (2022), and Bronze at the International Design Awards (2023). In fact, it has the

    Wesley Hobson The Hobson Group

    Section Image
  • 1525 Jennine Place, Boulder, CO 80304

    $4,300,000

    • 4 Beds
    • 4.5 Baths
    • 5,338 Sq Ft
    • 1525 Jennine Place
    • Boulder, CO

    Peaceful seclusion, jaw-dropping views and Central Boulder accessibility meet in this stunning 4BD/5BA featuring an open indoor-outdoor layout and an oversized lot nestled on a tranquil Melody Heights cul-de-sac. Built in 2017, the home boasts refinished hardwood floors, fresh paint, soaring ceilings, and walls of windows framing glorious natural light. A gracious foyer with a powder room ushers

    Patrick Brown Compass - Boulder

    Section Image
  • 643 Mapleton Ave, Boulder, CO 80304

    $5,800,000

    • 4 Beds
    • 3 Baths
    • 3,926 Sq Ft
    • 643 Mapleton Ave
    • Boulder, CO

    Seller Financing Available. The beautifully preserved past meets the exciting present in this carefully updated and diligently maintained historic Mapleton Hill home. This fine Boulder 4BD/3BA landmark awaits its next generation of lucky residents with an expansive modernized layout, a wealth of original and period-appropriate architectural details, and phenomenal poolside outdoor space. Built in

    Patrick Brown Compass - Boulder

    Section Image
  • 1575 Linden Dr, Boulder, CO 80304

    $4,495,000

    • 4 Beds
    • 3.5 Baths
    • 4,131 Sq Ft
    • 1575 Linden Dr
    • Boulder, CO

    A masterfully modern foothills lifestyle awaits in this spectacular new-construction Pine Brook Hills showpiece designed by architect Nick Fiore of Flower Architecture. Featuring exquisite contemporary design and breathtaking views, this new construction home is a refined sanctuary just minutes from Boulder, Colorado amenities. Inside, a soothing palette of warm materials is accompanied by

    Zachary Zeldner Compass - Boulder

    Section Image
  • 1145 Timber Ln Unit 3, Boulder, CO 80304

    $6,350,000

    • 4 Beds
    • 4.5 Baths
    • 4,021 Sq Ft
    • 1145 Timber Ln
    • Unit 3
    • Boulder, CO

    Perched atop a rocky prominence in the exclusive Pine Brook Hills, lies this one of a kind offering. With 360 degree views, this private residence is an architectural triumph that redefines luxury living. Upon entering you will be WOW'd by the voluminous atmosphere, wide plank wood flooring, and abundance of natural light that floods the home. A two sided fireplace welcomes you into the Great

    The Bernardi Group Coldwell Banker Realty-Boulder

    Section Image
  • 7155 Rustic Trail, Boulder, CO 80301

    $4,299,500

    • 4 Beds
    • 3.5 Baths
    • 7,744 Sq Ft
    • 7155 Rustic Trail
    • Boulder, CO

    Discover this stunning Boulder Country Club home with breathtaking views of Longs Peak and the foothills, backing to the golf course. Enjoy the tranquility of a tropical waterfalls and a peaceful reflecting pool. With 5,300 square feet of refreshed interior main-floor living, high ceilings, and abundant natural light, this home offers the perfect blend of comfort and style. The great room with a

    Ashley Stringer Slifer Smith & Frampton-Bldr

    Section Image
  • 2994 75th St, Boulder, CO 80301

    $5,500,000

    • 3 Beds
    • 3.5 Baths
    • 3,857 Sq Ft
    • 2994 75th St
    • Boulder, CO

    Welcome to The White Farm where you will enjoy the ultimate in privacy, serenity, and breathtaking views of the Boulder Foothills and back range snow capped mountains! A beautiful and timeless Farmhouse style home, designed by accomplished architect, John Mink, is overflowing with charm and character. You will love this peaceful, country setting and the unobstructed and endless views from every

    Linda Nehls RE/MAX of Boulder, Inc

    Section Image

Source: IRES MLS

MLS Number: 1009543

IRES MLS

APN: 1461241-00-100