Start of property details
Property Details
Located in highly-desirable Northern Colorado! On the Peninsula of Horseshoe Lake, quiet, isolated, with expansive mountain and water views. This private community is a 1.3 mile loop that encompasses 91 acres of Conservation Open Area that can't be developed. Walking distance to Boyd Lake State Park with many paved biking paths connecting to Fort Collins. Only a 30 min drive up the canyon to Rocky Mountain National Park! This home has transformed into an open-layout, modern, light-infused clubhouse haven. In the Kitchen, the island is wrapped in Taj Mahal quartzite with waterfall ends and hidden walnut cabinetry. An integrated refrigerator blends seamlessly with the Thomasville cabinetry and Monogram Minimalist appliances. The kitchen's focal wall is built with subtle Texas limestone accented by a rich walnut hood, shelves with plenty sunlight. Solid oak hardwood flooring refinished in 2023. The living space has vaulted ceilings, wood beams, fireplace, hand-painted tiles, and views of the Front Range. The outdoor living area, including Colorado Buff boulders, pavers and split stone planting beds, are new! There's a fountain that sits beneath the shade of a flowering pear tree. Back inside, a hand-made railing guides you past the laundry room with Samsung appliances, built-in shelves, counter, and retractable folding table. The 2nd bedroom has ample closet space and natural sunlight. The 2nd bathroom walls and floor are wrapped in Carrara marble with new fixtures and lighting. The primary bedroom features a vaulted ceiling, cedar beams, and mountain views. The ensuite bathroom features marble walls floor to ceiling, exclusive Schleuter heated floor, floating European toilet, hand-made walnut vanity with linear mirrors, a curbless waterfall shower with Grohe fixtures, and a custom-built-in closet with a large mirror, modern hardware, and storage. You will not find another home comparable, completely transformed with this many amenities, and in this priceless location!
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_1007945","AboveGradeFinishedArea":"1720","AccessibilityFeatures":null,"Appliances":"Down Draft, Double Oven, Dishwasher, Refrigerator, Microwave, Disposal","ArchitecturalStyle":"Patio Home, Ranch","AssociationAmenities":null,"AssociationFee":"131.00","AssociationFeeFrequency":"Monthly","AssociationFeeIncludes":"Trash, Snow Removal, Management, Maintenance Structure","AssociationYN":"1","AttributionContact":"3037797979","Basement":"Partial","BasementYN":null,"BathroomsFull":"0","BathroomsHalf":"0","BathroomsOneQuarter":null,"BathroomsThreeQuarter":"0","BelowGradeFinishedArea":"1080","BuilderModel":null,"BuilderName":null,"BuyerOfficeName":null,"CapRate":null,"CityRegion":null,"CommunityFeatures":null,"ComplexName":null,"ConstructionMaterials":"Wood\/Frame, Stone, Stucco","Contingency":null,"Cooling":"Central Air","CountyOrParish":"Larimer","CoveredSpaces":"2","DevelopmentName":null,"DevelopmentStatus":null,"DirectionFaces":null,"DoorFeatures":null,"Electric":"Electric, City Loveland","ElementarySchool":"Blair (Mary)","Exclusions":"Pantry in dining room is excluded. Washer and dryer negotiable.","ExteriorFeatures":null,"Fencing":"Partial, Wood","FireplaceFeatures":"Gas, Family\/Recreation Room Fireplace","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":"Mountain View","HorseAmenities":null,"HorseYN":"0","Inclusions":null,"IndoorFeatures":null,"InteriorFeatures":"Eat-in Kitchen, Separate Dining Room, Open Floorplan","InternetAddressDisplayYN":null,"LaundryFeatures":"Main Level","Levels":"One","ListingTerms":"Cash, Conventional, FHA, VA Loan","LivingArea":null,"LotFeatures":"Gutters, Sidewalks, Lawn Sprinkler System, Water Rights Excluded, Corner Lot, Level","LotSizeArea":"6098.00","LotSizeSquareFeet":"6098.00","MainLevelBedrooms":null,"MiddleOrJuniorSchool":"Ball (Conrad)","Model":null,"NewConstructionYN":"0","NumberOfUnitsTotal":null,"ListOfficeKey":"d00fffbe652c1bfc4156e57ce05bb434","OfficePhone":"303-779-7979","OtherParking":null,"Ownership":null,"ParkingFeatures":null,"ParkingTotal":null,"PatioAndPorchFeatures":"Patio","PoolFeatures":null,"PoolYN":null,"PoolPrivateYN":null,"PropertyCondition":"Not New, Previously Owned","PropertySubType":"Residential-Detached","public_remarks":"Located in highly-desirable Northern Colorado! On the Peninsula of Horseshoe Lake, quiet, isolated, with expansive mountain and water views. This private community is a 1.3 mile loop that encompasses 91 acres of Conservation Open Area that can't be developed. Walking distance to Boyd Lake State Park with many paved biking paths connecting to Fort Collins. Only a 30 min drive up the canyon to Rocky Mountain National Park! This home has transformed into an open-layout, modern, light-infused clubhouse haven. In the Kitchen, the island is wrapped in Taj Mahal quartzite with waterfall ends and hidden walnut cabinetry. An integrated refrigerator blends seamlessly with the Thomasville cabinetry and Monogram Minimalist appliances. The kitchen's focal wall is built with subtle Texas limestone accented by a rich walnut hood, shelves with plenty sunlight. Solid oak hardwood flooring refinished in 2023. The living space has vaulted ceilings, wood beams, fireplace, hand-painted tiles, and views of the Front Range. The outdoor living area, including Colorado Buff boulders, pavers and split stone planting beds, are new! There's a fountain that sits beneath the shade of a flowering pear tree. Back inside, a hand-made railing guides you past the laundry room with Samsung appliances, built-in shelves, counter, and retractable folding table. The 2nd bedroom has ample closet space and natural sunlight. The 2nd bathroom walls and floor are wrapped in Carrara marble with new fixtures and lighting. The primary bedroom features a vaulted ceiling, cedar beams, and mountain views. The ensuite bathroom features marble walls floor to ceiling, exclusive Schleuter heated floor, floating European toilet, hand-made walnut vanity with linear mirrors, a curbless waterfall shower with Grohe fixtures, and a custom-built-in closet with a large mirror, modern hardware, and storage. You will not find another home comparable, completely transformed with this many amenities, and in this priceless location!","Roof":"Composition","RoomsTotal":null,"SchoolDistrict":"Thompson R2-J","SecurityFeatures":null,"SeniorCommunityYN":"0","Sewer":"City Sewer","SpaFeatures":null,"SpaYN":"0","SpecialListingConditions":"Private Owner","StandardStatus":null,"StateRegion":null,"StoriesTotal":null,"StructureType":null,"TaxAnnualAmount":"2132.00","Utilities":"Natural Gas Available, Electricity Available","View":"Mountain(s)","ViewYN":null,"VirtualTourURLUnbranded":"https:\/\/www.zillow.com\/view-3d-home\/1b29cfe6-cca6-442c-be29-9d19dcfee5a0?setAttribution=mls&wl=true&utm_source=dashboard","WalkScore":null,"WaterBodyName":null,"WaterSource":"City Water, City of Loveland","WaterfrontFeatures":null,"WaterfrontYN":"0","WindowFeatures":"Window Coverings, Double Pane Windows","YearBuilt":"2001","Zoning":"RES","ZoningDescription":null,"headline_txt":null,"description_txt":null,"seller_office_id":null,"property_uid":"c08432dfb7e636983be9f0fe00515ac0","listing_status":"under-contract","mls_status":"Pending","mls_id":"boulder","listing_num":"1007945","acreage":null,"acres":"0.14","address":null,"address_direction":null,"address_flg":"1","address_num":"3799","agent_id":"P16461","area":"Loveland\/Berthoud","baths_total":"2.00","bedrooms_total":"2","car_spaces":"2","city":"Loveland","coseller_id":null,"coagent_id":null,"days_on_market":"5","finished_sqft_total":"1720","geocode_address":null,"geocode_status":null,"lat":"40.43032","lon":"-105.05353","office_id":"LLIBE","office_name":"Liberty Associates, LLC","orig_price":"625000","photo_count":"33","previous_price":null,"price":"649900","prop_img":"https:\/\/dvvjkgh94f2v6.cloudfront.net\/8ff91383\/0b6678506dc65486164448d8ec3078d0\/83dcefb7.jpeg","property_type":"Residential","sqft_total":"1720","state":"CO","street_type":"Ave","street_name":"Flagler","sub_area":"Horseshoe Lake","unit":null,"zip_code":"80538","listing_dt":"2024-04-23","undercontract_dt":null,"openhouse_dt":"2024-04-27 18:01:00","price_change_dt":null,"seller_id":null,"sold_dt":null,"sold_price":null,"webapi_update_dt":null,"update_dt":"2024-05-11 12:33:34","create_dt":"2024-04-25 02:30:13","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}