Start of property details
Property Details
BIG PRICE CUT! Extremely motivated seller entertaining 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
Exterior Features
Parking
Homeowner's Association
Payment Calculator
Property History
Similar Properties
{"property_id":"denver_IR988645","AboveGradeFinishedArea":"2326","AccessibilityFeatures":null,"Appliances":"Dishwasher, Microwave, Oven, Refrigerator","ArchitecturalStyle":"Contemporary","AssociationAmenities":null,"AssociationFee":"500.00","AssociationFeeFrequency":"Annually","AssociationFeeIncludes":null,"AssociationYN":"1","AttributionContact":"9706867620","Basement":null,"BasementYN":"1","BathroomsFull":"4","BathroomsHalf":"0","BathroomsOneQuarter":null,"BathroomsThreeQuarter":"0","BelowGradeFinishedArea":"1548","BuilderModel":null,"BuilderName":null,"BuyerOfficeName":null,"BuyerFinancing":null,"CapRate":null,"CityRegion":null,"CommonInterest":null,"CommunityFeatures":null,"ComplexName":null,"ConstructionMaterials":"Wood Frame","Contingency":null,"Cooling":null,"CountyOrParish":"Larimer","CoveredSpaces":null,"CurrentFinancing":null,"DevelopmentName":null,"DevelopmentStatus":null,"DirectionFaces":"South","DoorFeatures":null,"Electric":null,"ElementarySchool":"Eyestone","Exclusions":"Sellers Personal Property, Mineral Rights Excluded","ExteriorFeatures":null,"Fencing":"Fenced","FireplaceFeatures":null,"FireplaceYN":null,"FireplacesTotal":null,"Flooring":"Vinyl","FoundationDetails":null,"GarageSpaces":null,"GreenBuildingVerificationType":null,"GreenEnergyEfficient":null,"GreenEnergyGeneration":null,"GreenIndoorAirQuality":null,"GreenLocation":null,"GreenSustainability":null,"GreenWaterConservation":null,"Heating":"Forced Air, Propane","HighSchool":"Other","HorseAmenities":"Corral(s), Loafing Shed, Pasture, Tack Room","HorseYN":"1","Inclusions":null,"IndoorFeatures":null,"InteriorFeatures":"Eat-in Kitchen, Jack & Jill Bathroom, Kitchen Island","InternetAddressDisplayYN":null,"LaundryFeatures":null,"Levels":"One","ListAgentFullName":"Jay Escamilla","ListAgentEmail":null,"ListingTerms":"Cash, Conventional, FHA, VA Loan","LivingArea":null,"LotFeatures":"Open Space, Rolling Slope","LotSizeArea":null,"LotSizeDimensions":null,"LotSizeSquareFeet":"1524600.00","MainLevelBathrooms":"3","MainLevelBedrooms":"4","MiddleOrJuniorSchool":"Wellington","Model":null,"NewConstructionYN":null,"NumberOfUnitsTotal":null,"OtherParking":null,"Ownership":"Individual","ParkingFeatures":"Oversized, RV Access\/Parking, Tandem","ParkingTotal":"4","PatioAndPorchFeatures":null,"PoolFeatures":null,"PoolYN":null,"PoolPrivateYN":null,"PropertyAttachedYN":"0","PropertyCondition":null,"PropertySubType":"Single Family Residence","public_remarks":"BIG PRICE CUT! Extremely motivated seller entertaining 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 R-1","SecurityFeatures":null,"seller_office_id":null,"SeniorCommunityYN":null,"Sewer":"Septic Tank","SkiFeatures":null,"SpaFeatures":null,"SpaYN":null,"SpecialListingConditions":null,"StandardStatus":null,"StateRegion":null,"StoriesTotal":null,"StructureType":"Manufactured House","TaxAnnualAmount":"4085.26","Utilities":null,"View":"Mountain(s), Plains","ViewYN":null,"VirtualTourURLUnbranded":null,"WalkScore":null,"WaterBodyName":null,"WaterSource":"Well","WaterfrontFeatures":null,"WaterfrontYN":null,"WindowFeatures":"Window Coverings","YearBuilt":"2006","Zoning":"Res Ag","ZoningDescription":null,"property_uid":"REC2032854039","listing_status":"active","mls_status":"Active","mls_id":"denver","listing_num":"IR988645","acreage":null,"acres":"35.00","address":null,"address_direction":null,"address_flg":"1","address_num":"17095","agent_id":"IRP00307","area":null,"baths_total":"4.00","bedrooms_total":"5","car_spaces":"4","city":"Wellington","coseller_id":null,"coagent_id":null,"days_on_market":null,"finished_sqft_total":"3874","geocode_address":"17095 Mars Hill Lane","geocode_status":null,"lat":"40.83243","lon":"-104.9748","office_id":"IRCBPW1","office_name":"Coldwell Banker Plains-Windsor","orig_price":"799999","photo_count":"39","previous_price":"730000","price":"699999","prop_img":"\/listing\/photos\/denver\/IR988645-0.jpeg","property_type":"Residential","sqft_total":"3874","state":"CO","street_type":"Lane","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-04-24 13:16:45","create_dt":"2023-05-26 19:17:09","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}