• Sign Up
  • Log In
(303) 399-9000
ColoradoExpert@gmail.com
  • Home Page
  • Search All Listings
  • New Construction Showcase
  • Explore Denver Area Communities
    • Explore Cities
    • Explore Counties
  • For Buyers
    • Buying Info
    • Featured Listings
    • Search Homes
    • Calculate Payment
  • For Sellers
    • Complimentary Home Valuation
    • Tips for Sellers
    • Surviving the Sale of Your Home
    • The Pros and Cons of Open Houses
    • Negotiating To Sell Your Home
    • Move or Improve?
    • Evaluating an Offer
    • Improvement For Home Sellers
  • New Listing Notification
Hanover Realty
 
  • Facebook
  • Twitter
  • LinkedIn
  • Pinterest
  • Hanover Realty Recently Sold
  • Seller Resources
    • *Seller's FREE Market Analysis
    • *175 Step Sold Fast System
    • *Seller's Prelisting Presentation
    • Seller's Guide to Pricing
    • Seller Steps to a Positive Showing
    • Moving Center
    • *On-Demand
  • Hanover Estate Marketing
  • Buyer Resources
    • Buyer's FREE Listing Search
    • *Buyer's Handbook
    • Inspections for Buyers
    • Mortgage Calculator
    • Preferred Mortgage Lender
    • Schools
    • Moving Center
    • Newsroom
    • A Guide to Swelling Soil
    • Guide to Moisture Management
    • Protect Your Family From Lead
    • A Brief Guide to Mold
    • Radon and Real Estate - Colorado
    • Home Buyer's and Seller's Guide to Radon
    • Colorado Real Estate Buyer Advisory
    • For Your Protection Get a Home Inspection
    • Why am I being asked to sign a written buyer agreement?
    • Open houses and written agreements
    • Realtors’® duty to put client interests above their own
    • What veterans need to know about buying a home
    • Offers of compensation
    • Negotiating written buyer agreements
    • *On-Demand
  • About Hanover
    • Learn More
    • Realtor Designations
    • Meet the Team
    • Our Testimonials
    • Hanover Commercial
    • Career Opportunities
    • Jefferson Office Park
    • EastGlow Partnership
    • Hanover Management
    • Hanover REO
    • Hanover Builder Marketing
  • Hanover Articles
  • Contact Us

Sign Up for More Info

  • (303) 399-9000
  • ColoradoExpert@gmail.com
    Copy Email
  • HANOVER REALTY
    1030 Johnson Road Suite 340
    Golden, Colorado 80401
    (303) 399-9000
    ColoradoExpert@gmail.com

Home

    Account

    • Login
    • Sign Up
    Hanover Realty - Footer Logo


      • Privacy
      • Terms
      • DMCA
      • Accessibility
      • Fair Housing
      © 2025 Hanover Realty. All rights reserved.
      Website built by CloseHack.
      REcolorado
      Based on information submitted to the MLS GRID as of 2025-10-26 10:17:56 UTC. 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.
      • Legal Notice
      • Publisher's Notice
      • Copyright Notice
      • Buyer Agency Compensation
      Information and Real Estate Services, LLC

      Information source: Information and Real Estate Services, LLC. Provided for limited non-commercial use only under IRES Rules. © Copyright IRES. Information deemed reliable but not guaranteed by the MLS. The information being provided is for the consumers personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumer may be interested in purchasing.

      $2,690,000
      For Sale

      700 Yellow Pine Avenue

      Boulder, CO 80304
      4805 sqft | 4 beds | 4 baths | 0.20 acres | #3239968
      • Save
      • Contact
      • Share
      • Price Change Alerts
      Listing OfficeMilehimodern
      Browse 44 photos
      Type:Purchase
      Structure:House
      Zone:Residential

      Description

      Unrivaled mountain vistas and elegant design define this exceptional Northbriar Estates residence, perfectly positioned against open space with unobstructed views of the Flatirons and foothills. Thoughtfully crafted with every luxury in mind, this expansive home offers en-suite privacy in each bedroom and an open layout ideal for entertaining. The gourmet kitchen dazzles with high-end appliances and a seamless flow into the living and dining areas, where expansive windows and a gas fireplace frame breathtaking scenery. Brazilian cherry wood and travertine floors with radiant heat add warmth and sophistication throughout. The finished garden-level basement extends the living space with a rec room, while a dedicated office with built-ins offers a work-from-home haven. Outside, a southwest-facing deck in a sprawling backyard invites sunset gatherings. Sustainable living is built in with a Tesla solar tile roof, two Tesla Powerwalls; and a heated three-car garage with a dedicated workshop.

      • Interior Details
          • InteriorBuilt-in Features, Ceiling Fan(s), Central Vacuum, Eat-in Kitchen, Entrance Foyer, Five Piece Bath, Granite Counters, High Ceili
          • Fireplaces1
        • Beds & Baths
          • Bedrooms4
          • Bathrooms4
          • Full Baths2
          • Half Baths1
          • 3/4 Baths2
      • Property Details
          • Lot DescriptionLandscaped, Near Public Transit, Open Space, Sprinklers In Front, Sprinklers In Rear
          • Exterior MaterialsGas Valve, Lighting, Private Yard, Rain Gutters
          • ViewMountain(s)
        • Measurements
          • Square Feet4805
          • Acres0.2
        • Parking
          • Parking TypeGarage
          • Parking Spaces3
          • Parking Garage Spaces3
      • Construction Details
          • Property TypePurchase
          • BasementFinished
        • Condition
          • Year Built1998
      • Utilities / Energy Details
          • Utility FeaturesElectricity Connected, Internet Access (Wired), Natural Gas Connected, Off Grid, Phone Available
          • Sewer InformationPublic Sewer
          • Utility SourcePublic
      • Community and Neighborhood Details
          • SubdivisionNorthbriar Estates
        • Location
          • School DistrictBoulder Valley RE 2
          • Middle SchoolCentennial
          • Elementary SchoolFoothill
          • High SchoolBoulder
          • CountyBoulder
      • Financial Details
          • Original List Price$2,690,000
          • Taxes Annual$15,332
        • HOA
          • Hoa Fees100
          • Hoa1
      • Other
          • MLS #3239968

      Location

      Legal

      Based on information submitted to the MLS GRID as of 2025-10-26 21:05:26 UTC. 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.

      Last Updated: Today at 4:27 PM. Source: RECOLORADO

      Provided By
      Listing Agent: Molly Stauffer (#REC55045447), Phone: 303-345-1434, Email: molly@milehimodern.com
      Listing Office: Milehimodern (#RECM5432)

      • Legal Notice
      • Publisher's Notice
      • Copyright Notice
      • Buyer Agency Compensation
      Hanover RealtyReal Estate Group
      Facebook
      Google
      OR

      Interested in Purchasing 700 Yellow Pine Avenue?

      Get an estimate on monthly payments on this property.

      Note: The results shown are estimates only and do not include all factors. Speak with a licensed agent or loan provider for exact details. This tool is sourced from CloseHack.

      Estimated Monthly Payment
      $0.00
      Loan Amount
      $0.00
      $
      years

      Down Payment

      $
      %
      10.0%

      Interest Rate

      %
      6.0%

      Tax Rate

      %
      2.6%
      $
      $
      annually
      $
      monthly