Start of property details
Property Details
Nestled at the base of the foothills, this custom home is more than just a residence; it's a lifestyle retreat. Wake up to the sight of golden sunrises and retire to the glow of vibrant sunsets. With unobstructed views stretching as far as the eye can see, every moment becomes a captivating tableau of natural beauty. This home boasts generous living spaces designed to accommodate the needs of a modern family. From the welcoming foyer to the sunlit living rooms, every room exudes warmth and comfort. The heart of the home, the kitchen, has been thoughtfully updated to meet the demands of today's lifestyle. Featuring a large island, stainless steel appliances, and ample storage, it offers both style and functionality for culinary enthusiasts. The lower level of the home features a one-bedroom apartment, providing flexibility for multigenerational living, guest accommodations, or other potential. With its own entrance, kitchen, laundry, and bathroom, it offers privacy and convenience for residents and visitors alike. Step outside to discover a private backyard retreat, where lush landscaping, and mature trees create a serene backdrop for outdoor entertaining and recreation.Whether you're an avid rider or simply appreciate the serenity of outdoor living, the property offers a wealth of outdoor amenities. For the horse enthusiasts, the property features a 4 stall barn equipped with automatic waters, attached runs, fenced paddocks, a tack room and an outdoor riding arena. Whether you're a horse enthusiast, nature lover, or simply seeking a retreat from the ordinary, this property is a MUST SEE!
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_1007823","AboveGradeFinishedArea":"4774","AccessibilityFeatures":"Main Floor Bath","Appliances":"Electric Range\/Oven, Gas Range\/Oven, Dishwasher, Refrigerator, Bar Fridge, Washer, Dryer, Microwave, Disposal","ArchitecturalStyle":null,"AssociationAmenities":null,"AssociationFee":null,"AssociationFeeFrequency":null,"AssociationFeeIncludes":null,"AssociationYN":"0","AttributionContact":"3032897009","Basement":"Full, 90%+ Finished Basement","BasementYN":null,"BathroomsFull":"4","BathroomsHalf":"0","BathroomsOneQuarter":null,"BathroomsThreeQuarter":"1","BelowGradeFinishedArea":"1183","BuilderModel":null,"BuilderName":null,"BuyerOfficeName":null,"CapRate":null,"CityRegion":null,"CommunityFeatures":null,"ComplexName":null,"ConstructionMaterials":"Wood\/Frame","Contingency":null,"Cooling":"Central Air","CountyOrParish":"Boulder","CoveredSpaces":"3","DevelopmentName":null,"DevelopmentStatus":null,"DirectionFaces":null,"DoorFeatures":null,"Electric":"Electric, Xcel","ElementarySchool":"Blue Mountain","Exclusions":"Sellers personal property and staged items","ExteriorFeatures":"Gas Grill, Balcony","Fencing":"Partial","FireplaceFeatures":"2+ Fireplaces, Gas, Living Room, Family\/Recreation Room Fireplace, Great Room","FireplaceYN":"1","FireplacesTotal":null,"Flooring":null,"FoundationDetails":null,"GarageSpaces":null,"GreenBuildingVerificationType":null,"GreenEnergyEfficient":null,"GreenEnergyGeneration":null,"GreenIndoorAirQuality":null,"GreenLocation":null,"GreenSustainability":null,"GreenWaterConservation":null,"Heating":"Forced Air","HighSchool":"Silver Creek","HorseAmenities":"Barn with 3+ Stalls, Pasture, Arena, Tack Room, Riding Trail","HorseYN":"1","Inclusions":null,"IndoorFeatures":null,"InteriorFeatures":"Study Area, Satellite Avail, High Speed Internet, Eat-in Kitchen, Separate Dining Room, Cathedral\/Vaulted Ceilings, Open Floorplan, Pantry, Walk-In Closet(s), Wet Bar, Kitchen Island","InternetAddressDisplayYN":null,"LaundryFeatures":"Upper Level","Levels":"Two","ListingTerms":"Cash, Conventional, FHA, VA Loan","LivingArea":null,"LotFeatures":"Lawn Sprinkler System, Cul-De-Sac, Abuts Farm Land","LotSizeArea":"206039.00","LotSizeSquareFeet":"206039.00","MainLevelBedrooms":null,"MiddleOrJuniorSchool":"Altona","Model":null,"NewConstructionYN":"0","NumberOfUnitsTotal":null,"ListOfficeKey":"16963b4432be7d792482dfa83f2c2e22","OfficePhone":"303-289-7009","OtherParking":null,"Ownership":null,"ParkingFeatures":"Heated Garage","ParkingTotal":null,"PatioAndPorchFeatures":"Patio, Deck","PoolFeatures":null,"PoolYN":null,"PoolPrivateYN":null,"PropertyCondition":"Not New, Previously Owned","PropertySubType":"Residential-Detached","public_remarks":"Nestled at the base of the foothills, this custom home is more than just a residence; it's a lifestyle retreat. Wake up to the sight of golden sunrises and retire to the glow of vibrant sunsets. With unobstructed views stretching as far as the eye can see, every moment becomes a captivating tableau of natural beauty. This home boasts generous living spaces designed to accommodate the needs of a modern family. From the welcoming foyer to the sunlit living rooms, every room exudes warmth and comfort. The heart of the home, the kitchen, has been thoughtfully updated to meet the demands of today's lifestyle. Featuring a large island, stainless steel appliances, and ample storage, it offers both style and functionality for culinary enthusiasts. The lower level of the home features a one-bedroom apartment, providing flexibility for multigenerational living, guest accommodations, or other potential. With its own entrance, kitchen, laundry, and bathroom, it offers privacy and convenience for residents and visitors alike. Step outside to discover a private backyard retreat, where lush landscaping, and mature trees create a serene backdrop for outdoor entertaining and recreation.Whether you're an avid rider or simply appreciate the serenity of outdoor living, the property offers a wealth of outdoor amenities. For the horse enthusiasts, the property features a 4 stall barn equipped with automatic waters, attached runs, fenced paddocks, a tack room and an outdoor riding arena. Whether you're a horse enthusiast, nature lover, or simply seeking a retreat from the ordinary, this property is a MUST SEE!","Roof":"Composition","RoomsTotal":null,"SchoolDistrict":"ST Vrain Dist RE 1J","SecurityFeatures":null,"SeniorCommunityYN":"0","Sewer":"Septic","SpaFeatures":null,"SpaYN":"0","SpecialListingConditions":"Private Owner","StandardStatus":null,"StateRegion":null,"StoriesTotal":null,"StructureType":null,"TaxAnnualAmount":"13836.00","Utilities":"Natural Gas Available, Electricity Available, Cable Available","View":"Foothills View, Plains View","ViewYN":null,"VirtualTourURLUnbranded":null,"WalkScore":null,"WaterBodyName":null,"WaterSource":"City Water, Left Hand Water","WaterfrontFeatures":null,"WaterfrontYN":"0","WindowFeatures":null,"YearBuilt":"1990","Zoning":"Ag","ZoningDescription":null,"headline_txt":null,"description_txt":null,"seller_office_id":null,"property_uid":"8453283be81850c4f53eadf51a92b9c0","listing_status":"active","mls_status":"Active","mls_id":"boulder","listing_num":"1007823","acreage":null,"acres":"4.73","address":null,"address_direction":null,"address_flg":"1","address_num":"3185","agent_id":"P00775","area":"Suburban Plains","baths_total":"5.00","bedrooms_total":"5","car_spaces":"3","city":"Longmont","coseller_id":null,"coagent_id":null,"days_on_market":"330","finished_sqft_total":"5857","geocode_address":null,"geocode_status":null,"lat":"40.147934","lon":"-105.275132","office_id":"IREBR","office_name":"BHHS Colorado RE Brighton","orig_price":"2295000","photo_count":"39","previous_price":null,"price":"2295000","prop_img":"https:\/\/dvvjkgh94f2v6.cloudfront.net\/8ff91383\/cc73a1b8eee22dc0b235c536edda1eb1\/83dcefb7.jpeg","property_type":"Residential","sqft_total":"4774","state":"CO","street_type":"Rd","street_name":"Nelson","sub_area":"L'HEUREUX COUNTRY ESTATES","unit":null,"zip_code":"80503","listing_dt":"2024-04-23","undercontract_dt":null,"openhouse_dt":"2024-04-28 17:00:00","price_change_dt":null,"seller_id":null,"sold_dt":null,"sold_price":null,"webapi_update_dt":null,"update_dt":"2024-05-05 21:33:41","create_dt":"2024-04-23 23:33:22","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}