Start of property details
Property Details
Sitting on the ridge overlooking Spanish Hills, lovely French Country custom home boasts the most expansive views in Boulder County; from the Flatirons to Mount Meeker and Longs Peak; the back range mountains, to Baseline Reservoir, and the city lights below, the sights are breathtaking. Across from Harper Lake and a 2-minute walk to the Louisville dog park / open space trails, this location thrills. Approach this beautiful red-brick home via a long 2-ac drive past 8 apple trees, a veg garden, to a circular drive at the front door where several brick patios and a delightful bridge enhance the front of the home. The lot is approx 4.2 acres; zoned for horses, chickens, with plenty of room to build a barn, coop, pool / tennis ct. Inside the home are 7 bedrooms including a guest suite over gar. The country kitchen is spacious with SS appl, a 5'x11' walk-in pantry, and breakfast nook. Beside thekitchenis a large dining room, a laundry room with washer / dryer included, and a hobby or sewing room. Living room has an attractive brick-walled gas fp and a sitting area. The West door of the living room opens to the 38'x29' multi-level trex deck that overlooks the spectacular views and approx. 2-ac backyard. The large den with an indoor 2-story greenhouse with 18' cathedral windows and a spiral staircase. (New glass on order). Small main-floor bedroom and office in the hall. Upstairs is an approx. 24'x16' primary bedroom with sitting area, large 5-pc bathroom, bidet, and oversized walk-in closet. 3 other bedrooms on the 2nd floor share an additional full bath. Up on the 3rd floor is another suite 35'x12' with Murphy bed, wood built-ins, walk-in closet, and 3 / 4 bath. The walk-out level has a wood wine cellar. A rec rm with custom window well, a 1 / 2 ba, another big pantry, and the utility rm with a walk-out door that leads to the backyard. Plenty of storage! Tandem 4-car garage with cabs and workbench. New roof, carpet, all fresh paint and new garage floor coating! Come and see today!
Property Highlights
Location
Property Details
Building
Community
Local Schools
Interior Features
Bedrooms and Bathrooms
Rooms and Basement
Area and Spaces
Appliances
Interior Features
Heating and Cooling
Building Details
Construction
Materials
Terms
Terms
Taxes
Tax
Heating, Cooling & Utilities
Utilities
Lot
Parking
Exterior Features
Payment Calculator
Property History
Similar Properties
{"property_id":"boulder_1008652","AboveGradeFinishedArea":"5093","AccessibilityFeatures":"Level Lot, Main Floor Bath, Main Level Bedroom, Main Level Laundry","Appliances":"Electric Range\/Oven, Dishwasher, Refrigerator, Washer, Dryer, Microwave, Disposal","ArchitecturalStyle":"Tudor","AssociationAmenities":null,"AssociationFee":null,"AssociationFeeFrequency":null,"AssociationFeeIncludes":null,"AssociationYN":"0","AttributionContact":"3036666500","Basement":"Walk-Out Access","BasementYN":null,"BathroomsFull":"2","BathroomsHalf":"2","BathroomsOneQuarter":null,"BathroomsThreeQuarter":"2","BelowGradeFinishedArea":"1403","BuilderModel":null,"BuilderName":null,"BuyerOfficeName":null,"CapRate":null,"CityRegion":null,"CommunityFeatures":null,"ComplexName":null,"ConstructionMaterials":"Brick\/Brick Veneer","Contingency":null,"Cooling":"Room Air Conditioner","CountyOrParish":"Boulder","CoveredSpaces":"4","DevelopmentName":null,"DevelopmentStatus":null,"DirectionFaces":"Southeast","DoorFeatures":"French Doors","Electric":"Electric, Xcel","ElementarySchool":"Douglass","Exclusions":"None","ExteriorFeatures":null,"Fencing":"Partial","FireplaceFeatures":"Gas, Living Room","FireplaceYN":"1","FireplacesTotal":null,"Flooring":"Wood Floors","FoundationDetails":"Slab","GarageSpaces":null,"GreenBuildingVerificationType":null,"GreenEnergyEfficient":null,"GreenEnergyGeneration":null,"GreenIndoorAirQuality":null,"GreenLocation":null,"GreenSustainability":null,"GreenWaterConservation":null,"Heating":"Hot Water","HighSchool":"Fairview","HorseAmenities":"Pasture","HorseYN":"1","Inclusions":null,"IndoorFeatures":null,"InteriorFeatures":"Study Area, In-Law Floorplan, Central Vacuum, Eat-in Kitchen, Separate Dining Room, Pantry, Stain\/Natural Trim, Walk-In Closet(s), Sunroom","InternetAddressDisplayYN":null,"LaundryFeatures":"Washer\/Dryer Hookups, Main Level","Levels":"Three Or More","ListingTerms":"Cash, Conventional, FHA, VA Loan","LivingArea":null,"LotFeatures":"Lawn Sprinkler System, Mineral Rights Excluded, Level, Sloped, Within City Limits","LotSizeArea":"190385.00","LotSizeSquareFeet":"190385.00","MainLevelBedrooms":null,"MiddleOrJuniorSchool":"Platt","Model":null,"NewConstructionYN":"0","NumberOfUnitsTotal":null,"ListOfficeKey":"452a10c50aa95c1ce2831fa7292968f6","OfficePhone":"303-666-6500","OtherParking":null,"Ownership":null,"ParkingFeatures":"Garage Door Opener, RV\/Boat Parking, Oversized, Tandem","ParkingTotal":null,"PatioAndPorchFeatures":"Deck","PoolFeatures":null,"PoolYN":null,"PoolPrivateYN":null,"PropertyCondition":"Not New, Previously Owned","PropertySubType":"Residential-Detached","public_remarks":"Sitting on the ridge overlooking Spanish Hills, lovely French Country custom home boasts the most expansive views in Boulder County; from the Flatirons to Mount Meeker and Longs Peak; the back range mountains, to Baseline Reservoir, and the city lights below, the sights are breathtaking. Across from Harper Lake and a 2-minute walk to the Louisville dog park\/ open space trails, this location thrills. Approach this beautiful red-brick home via a long 2-ac drive past 8 apple trees, a veg garden, to a circular drive at the front door where several brick patios and a delightful bridge enhance the front of the home. The lot is approx 4.2 acres; zoned for horses, chickens, w\/ plenty of room to build a barn, coop, pool\/tennis ct. Inside the home are 7 bedrooms including a guest suite over gar. The country kitchen is spacious with SS appl, a 5'x11' walk-in pantry, and breakfast nook. Beside the kit is a large dining room, a laundry room with washer\/dryer included, and a hobby or sewing room. Living room has an attractive brick-walled gas fp and a sitting area. The West door of the living room opens to the 38'x29' multi-level trex deck that overlooks the spectacular views and approx. 2-ac backyard. The large den w\/ an indoor 2-story greenhouse w\/ 18' cathedral windows and a spiral staircase. (New glass on order). Small main-floor bedroom and office in the hall. Upstairs is an approx. 24'x16' primary bedroom w\/ sitting area, large 5-pc bathroom, bidet, and oversized walk-in closet. 3 other bedrooms on the 2nd floor share an additional full bath. Up on the 3rd floor is another suite 35'x12' with Murphy bed, wood built-ins, walk-in closet, and 3\/4 bath. The walk-out level has a wood wine cellar. A rec rm with custom window well, a 1\/2 ba, another big pantry, and the utility rm with a walk-out door that leads to the backyard. Plenty of storage! Tandem 4-car garage with cabs & workbench. New roof, carpet, all fresh paint and new garage floor coating! Come and see today!","Roof":"Composition","RoomsTotal":null,"SchoolDistrict":"Boulder Valley Dist RE2","SecurityFeatures":null,"SeniorCommunityYN":"0","Sewer":"Septic","SpaFeatures":null,"SpaYN":"0","SpecialListingConditions":"Other Owner","StandardStatus":null,"StateRegion":null,"StoriesTotal":null,"StructureType":"Includes Rental Unit","TaxAnnualAmount":"16115.00","Utilities":"Natural Gas Available, Electricity Available","View":"Mountain(s), Foothills View, Plains View, City, Water","ViewYN":null,"VirtualTourURLUnbranded":null,"WalkScore":null,"WaterBodyName":null,"WaterSource":"City Water, City","WaterfrontFeatures":null,"WaterfrontYN":"0","WindowFeatures":"Wood Frames, Skylight(s), Sunroom","YearBuilt":"1985","Zoning":"RRR","ZoningDescription":null,"headline_txt":null,"description_txt":null,"seller_office_id":null,"property_uid":"96e58bdaae89634be436fe1018d8eb9f","listing_status":"active","mls_status":"Active","mls_id":"boulder","listing_num":"1008652","acreage":null,"acres":"4.37","address":null,"address_direction":null,"address_flg":"1","address_num":"375","agent_id":"P28786","area":"Louisville","baths_total":"6.00","bedrooms_total":"7","car_spaces":"4","city":"Boulder","coseller_id":null,"coagent_id":"P08967","days_on_market":"6","finished_sqft_total":"5628","geocode_address":null,"geocode_status":null,"lat":"39.9802","lon":"-105.16832","office_id":"RXAD","office_name":"RE\/MAX Alliance-Lsvl","orig_price":"4000000","photo_count":"40","previous_price":null,"price":"4000000","prop_img":"https:\/\/dvvjkgh94f2v6.cloudfront.net\/8ff91383\/8f589d33f35afd9e8360a9d4b1cbe795\/83dcefb7.jpeg","property_type":"Residential","sqft_total":"5093","state":"CO","street_type":"Dr","street_name":"Majestic View","sub_area":"South Central","unit":null,"zip_code":"80303","listing_dt":"2024-05-02","undercontract_dt":null,"openhouse_dt":null,"price_change_dt":null,"seller_id":null,"sold_dt":null,"sold_price":null,"webapi_update_dt":null,"update_dt":"2024-05-14 19:30:33","create_dt":"2024-05-02 23:30:11","marketing_headline_txt":null,"use_marketing_description_txt":null,"marketing_description_txt":null,"showcase_layout":null,"mortgage_calculator":null,"property_history":null,"marketing_account_id":null}