DON'T MISS A NEW LISTING AGAIN!

Register Now
Already registered? Login

FREE AUTOMATED EMAIL UPDATES
Sign in to take advantage of all this site has to offer. Save your favorite listings and searches – also receive email updates when listings you like come on the market for free!
*Contact Information is NOT Shared*

Don Ralston

Don Ralston
RE/MAX Alliance
Louisville, CO 80027

303-327-6629
Email Me

Quick Search


view all


Any

Any

No Min.

No Max.
Back to Saved Search
Listing 14 out of 188
$3,395,000 Active

300 Pine Needle Road
Boulder, CO 80304

4 beds, 3 full, 2 partial baths | Single Family Home
6,832 sq ft; lot: 1.89 acres - MLS# 8476215
Property Photo
1/35

Description

Absolutely Gorgeous*Pennsylvania Oak Exposed Post & Beam*Cathedral Vaulted Ceilings*Radiant Floor Heating throughout*Hand built Solid Oak Flooring*Scenic Boulder Panoramic Views*Wrap Around Multiple Level Porch/Decks*Professional Custom Designed Master Chef Kitchen*Stainless-Steel Thermador Custom Appliances*Palomino Granite Slab Kitchen*Attached Greenhouse with Velux Solar Skylights*Wood-Burning Fireplace & Electric Fireplaces*Lofted 4th Floor Master Suite with Added 1/2 Bath*Leathered Granite*Jacuzzi Tub, Multiple Steam Showers*Outdoor Salt Water Hot Spring Thermal Tub*Tiered Gardens with Irrigation System*Enclosed Backyard Trampoline*4-Car Oversized Garage*Hi-Speed Internet, Cat5 wiring, ADT Security, DirecTV Satellite*Au Pair Suite with Private Entry*Call for Complete Feature List*Au PairStudio*++MORE!

Features

  • Property Type: Single Family Home
  • Sub Type: Detached Single Family
  • Listing Status: Active
  • County/Area: Boulder County
  • Zip Code: 80304
  • Year Built: 1996
  • Subdivision/Neighborhood: Boulder
  • School District: Boulder Valley Re 2
  • Elementary School: Foothill
  • Middle School: Centennial
  • High School: Boulder
  • Sq.Ft.: 6,832 sq ft
  • Style: Contemporary, 3+ Story
  • Stories: 3+ Story
  • Bedrooms: 4
  • Full Baths: 3
  • Half Baths: 2
  • Basement: Full, Walk-Out
  • Garage: 4
  • # of Parking Spaces: 8
  • Fireplace: Electric,Free-standing,Wood, Living Room,Master Bedroom, 2
  • Lot Size: 1.89 acres
  • Baths: 5
  • View: City View,Mountain View
  • Zoning: RES
  • Architectural Style: Contemporary
  • Association Fee Frequency: Annual
  • Association Fee Primary: 75.00
  • Association Fee Primary Annual: 75.00
  • Association Fee Total Annual: 75.00
  • Association Name Primary: Pine Brook Hills
  • Association Phone Primary: 000-000-0000
  • Basement Finished YN: Y
  • Basement Percent Finished: 90
  • Bathrooms Total Lower: 2
  • Bathrooms Total Main: 2
  • Bathrooms Total Upper: 1
  • Bedrooms Total Lower: 3
  • Bedrooms Total Upper: 1
  • Building Area Source: Floor Plans
  • Construction Materials: Stone, Stucco
  • Construction Methods: Frame
  • Cooling: Ceiling Fan, Evaporative Cooler (Swamp)
  • Countertop Type: Granite
  • Electricity Source: Yes
  • Exterior Features: Balcony, Deck, Hot Tub/Spa, Lighting, Patio, Sprinkler System, Wraparound Porch, Yard
  • Flooring: Carpet, Tile Floor, Wood
  • Gas Source: Yes
  • Gas Type: Natural Gas
  • Has HOAYN: Y
  • Heating: Forced Air, Radiant, Stove
  • Heating Fuel: Gas
  • Interior Features: Breakfast Nook, Cable Available, Double Pane Windows, Eating Space/Kitchen, Exterior Basement Entrance, Five Piece Bath, Foyer/Entry, Heated Basement, Hot Tub/Spa, Interior Basement Entrance, Jack & Jill Bath, Kitchen Island, Master Bath, Master Suite, Open Floor Plan, Pantry, Remodeled, Security System, Smoke Free, Sump Pump, Updated, Utility Sink, Vaulted, Walk-In Closets, Window Coverings, Work Shop (Interior)
  • Kitchen Appliances: Dishwasher, Disposal, Dryer, Microwave Oven, Refrigerator (Kitchen), Refrigerator (Other), Smoke Alarm, Stove/Range/Oven, Washer, Wine Cooler
  • Land Topography: Foothills
  • Laundry Availability: Washer/Dryer Included
  • Lot Size Sq Ft: 82454.00
  • Parking Count: 3
  • Parking Features: Driveway-Asphalt, Oversized Deep, Oversized Wide, Tandem
  • Partial Ownership Type: Not Applicable
  • Price Type: List Price
  • Roofing: Composition Shingles
  • School Of Choice YN: Y
  • Seller Type: Individual
  • Sewer: Septic
  • Site Features: Adjacent To Greenbelt, Adjacent To Open Space, Cul-De-Sac, Secluded
  • Sq Ft Above: 5827
  • Sq Ft Basement: 1642
  • Sq Ft Date Measured: 2019-02-01
  • Sq Ft Finished: 6832
  • Sq Ft Lower: 3272
  • Sq Ft Main: 2300
  • Sq Ft Upper: 255
  • Sqft Total: 7469
  • Structural Style: 3+ Story
  • Tax Amount: 7043.00
  • Tax Year: 2017
  • Total Offstreet Spaces: 3
  • Total RV Spaces: 1
  • Utilities: Cable TV, Internet Access (Wired), Telephone
  • Water Source: Community
Courtesy of Coldwell Banker Residential 14

 



Don Ralston | 303-327-6629 | Email Me
225 S. Boulder Road - Louisville, CO 80027
Copyright © 2017, All Rights Reserved

Real Estate Websites by iHOUSEweb iconiHOUSEweb | Admin Menu