Start of property details
Property Details
BIG PRICE CUT! Extremely motivated seller entertaining all offers! Exquisite Blend of Functionality, Serenity, and Panoramic Views - An Opportunity Not to be Missed! Nestled within a meticulously maintained small farm, this remarkable property offers an exceptional sense of security, privacy, and breathtaking vistas. With multiple living areas on the main level and an expansive recreation room in the basement, this home effortlessly combines comfort and entertainment. As you step into this countryside abode, you are greeted by custom unique finishes throughout, adding an unmistakable touch of Tuscany to every corner. The 1800 sqft custom wood barn stands as a testament to the pinnacle of farm functionality. Boasting three spacious stalls with runs, a finished and insulated loft, a milking stand, and ample space for calving, this barn is an exceptional addition. Multiple outbuildings, including loafing sheds, storage for tack, hay, equipment, or even household goods, and well-designed calving barns, are strategically placed across the property. For those with additional storage needs, there is covered parking available to shelter a boat, trailer, or tractor. The entire perimeter of the property is encircled by wire fencing, complemented by separate pens and alleys thoughtfully designed for your livestock. Don't miss out on this unique opportunity own a farmstead that seamlessly combines functionality, tranquility, and panoramic views. It's time to embrace the charm and possibilities that await you.
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
HOA
Tax
Heating, Cooling & Utilities
Utilities
Lot
Parking
Exterior Features
Homeowner's Association
Payment Calculator
Property History
Similar Properties
{"property_id":"boulder_988645","AboveGradeFinishedArea":"2326","AccessibilityFeatures":null,"Appliances":"Electric Range\/Oven, Dishwasher, Refrigerator, Microwave","ArchitecturalStyle":"Contemporary\/Modern, Ranch","AssociationAmenities":null,"AssociationFee":"500.00","AssociationFeeFrequency":"Annually","AssociationFeeIncludes":null,"AssociationYN":"1","AttributionContact":"9706867620","Basement":"90%+ Finished Basement","BasementYN":null,"BathroomsFull":"4","BathroomsHalf":"0","BathroomsOneQuarter":null,"BathroomsThreeQuarter":"0","BelowGradeFinishedArea":"1548","BuilderModel":null,"BuilderName":null,"BuyerOfficeName":null,"CapRate":null,"CityRegion":null,"CommunityFeatures":null,"ComplexName":null,"ConstructionMaterials":"Wood\/Frame","Contingency":null,"Cooling":null,"CountyOrParish":"Larimer","CoveredSpaces":"4","DevelopmentName":null,"DevelopmentStatus":null,"DirectionFaces":"South","DoorFeatures":null,"Electric":null,"ElementarySchool":"Eyestone","Exclusions":"Sellers Personal Property","ExteriorFeatures":null,"Fencing":"Fenced, Wire","FireplaceFeatures":null,"FireplaceYN":null,"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":"Wellington","HorseAmenities":"Barn with 3+ Stalls, Corral(s), Pasture, Tack Room, Loafing Shed, Hay Storage","HorseYN":"1","Inclusions":null,"IndoorFeatures":null,"InteriorFeatures":"Study Area, Eat-in Kitchen, Loft, Jack & Jill Bathroom, Kitchen Island","InternetAddressDisplayYN":null,"LaundryFeatures":"Main Level","Levels":"One","ListingTerms":"Cash, Conventional, FHA, VA Loan","LivingArea":null,"LotFeatures":"Mineral Rights Excluded, Rolling Slope, Abuts Private Open Space","LotSizeArea":"1524600.00","LotSizeSquareFeet":"1524600.00","MainLevelBedrooms":null,"MiddleOrJuniorSchool":"Wellington","Model":null,"NewConstructionYN":"0","NumberOfUnitsTotal":null,"ListOfficeKey":"4b678a4fe17f93405fc06c3abb84b54f","OfficePhone":"970-686-7620","OtherParking":null,"Ownership":null,"ParkingFeatures":"RV\/Boat Parking, Oversized, Tandem","ParkingTotal":null,"PatioAndPorchFeatures":null,"PoolFeatures":null,"PoolYN":null,"PoolPrivateYN":null,"PropertyCondition":"Not New, Previously Owned","PropertySubType":"Residential-Detached","public_remarks":"BIG PRICE CUT! Extremely motivated seller entertaining all offers! Exquisite Blend of Functionality, Serenity, and Panoramic Views - An Opportunity Not to be Missed! Nestled within a meticulously maintained small farm, this remarkable property offers an exceptional sense of security, privacy, and breathtaking vistas. With multiple living areas on the main level and an expansive recreation room in the basement, this home effortlessly combines comfort and entertainment. As you step into this countryside abode, you are greeted by custom unique finishes throughout, adding an unmistakable touch of Tuscany to every corner. The 1800 sqft custom wood barn stands as a testament to the pinnacle of farm functionality. Boasting three spacious stalls with runs, a finished and insulated loft, a milking stand, and ample space for calving, this barn is an exceptional addition. Multiple outbuildings, including loafing sheds, storage for tack, hay, equipment, or even household goods, and well-designed calving barns, are strategically placed across the property. For those with additional storage needs, there is covered parking available to shelter a boat, trailer, or tractor. The entire perimeter of the property is encircled by wire fencing, complemented by separate pens and alleys thoughtfully designed for your livestock. Don't miss out on this unique opportunity own a farmstead that seamlessly combines functionality, tranquility, and panoramic views. It's time to embrace the charm and possibilities that await you.","Roof":"Composition","RoomsTotal":null,"SchoolDistrict":"Poudre","SecurityFeatures":null,"SeniorCommunityYN":"0","Sewer":"Septic","SpaFeatures":null,"SpaYN":"0","SpecialListingConditions":"Private Owner","StandardStatus":null,"StateRegion":null,"StoriesTotal":null,"StructureType":"House, Manufactured House","TaxAnnualAmount":"4085.26","Utilities":"Propane","View":"Mountain(s), Foothills View, Plains View","ViewYN":null,"VirtualTourURLUnbranded":null,"WalkScore":null,"WaterBodyName":null,"WaterSource":"Well, Well","WaterfrontFeatures":null,"WaterfrontYN":"0","WindowFeatures":"Window Coverings","YearBuilt":"2006","Zoning":"Res Ag","ZoningDescription":null,"headline_txt":null,"description_txt":null,"seller_office_id":null,"property_uid":"8f2b907f5dad079152ccdfd0e78de53a","listing_status":"active","mls_status":"Active\/Backup","mls_id":"boulder","listing_num":"988645","acreage":null,"acres":"35.00","address":null,"address_direction":null,"address_flg":"1","address_num":"17095","agent_id":"P00307","area":"Fort Collins","baths_total":"4.00","bedrooms_total":"5","car_spaces":"4","city":"Wellington","coseller_id":null,"coagent_id":null,"days_on_market":"337","finished_sqft_total":"3874","geocode_address":null,"geocode_status":null,"lat":"40.83243","lon":"-104.9748","office_id":"CBPW1","office_name":"Coldwell Banker Plains-Windsor","orig_price":"749999","photo_count":"39","previous_price":"730000","price":"699999","prop_img":"https:\/\/dvvjkgh94f2v6.cloudfront.net\/8ff91383\/e1bff493f2387089e68457590e68d57b\/83dcefb7.jpeg","property_type":"Residential","sqft_total":"2326","state":"CO","street_type":"Ln","street_name":"Mars Hill","sub_area":"none","unit":null,"zip_code":"80549","listing_dt":"2023-05-26","undercontract_dt":null,"openhouse_dt":null,"price_change_dt":"2024-04-24","seller_id":null,"sold_dt":null,"sold_price":null,"webapi_update_dt":null,"update_dt":"2024-05-02 06:30:20","create_dt":"2023-10-01 16:30:03","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}