Start of property details
Property Details
Welcome to 28 Arapahoe Ave, a stunning condo nestled on a protected mountain hillside, offering a unique blend of modern design and scenic canyon views. This exceptional property offers a spacious and luxurious living experience, with attention to both aesthetics and sustainability.Step onto the elevated patio and immerse yourself in the tranquility of the surroundings. There is an option to upgrade this property and have an outdoor shower and heated dipping pool for a refreshing oasis, while the rock outcroppings add a touch of natural beauty. Multiple decks and balconies extend the living areas, allowing you to fully embrace the canyon air and enjoy the breathtaking views.Inside, you'll find a thoughtfully designed space that prioritizes comfort and efficiency. The property features an elevator for easy access to all levels. The 1-car garage provides ample storage space and additional room for toys. Furthermore, the property boasts EV charging stations, PV solar panels, and an ultra energy-efficient mechanical system, ensuring both sustainability and cost savings. The superior indoor air quality (IAQ) specifications create a healthy and comfortable living environment.The modern design features expansive glass windows, maximizing natural light and seamlessly integrating the beauty of the outdoors. Cathedral ceilings in the primary bedroom and the rooftop level family room enhance the sense of volume and spaciousness. Located in a serene canyon setting, 28 Arapahoe Ave offers a unique retreat while still providing easy access to urban amenities. Embrace the beauty of nature, go hiking or biking on nearby trails, and savor the peace and privacy this location offers.
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
Heating, Cooling & Utilities
Utilities
Lot
Parking
Homeowner's Association
Payment Calculator
Property History
Similar Properties
{"property_id":"denver_IR1000242","AboveGradeFinishedArea":"2526","AccessibilityFeatures":null,"Appliances":"Dishwasher, Disposal, Dryer, Oven, Refrigerator, Washer","ArchitecturalStyle":"Contemporary","AssociationAmenities":null,"AssociationFee":"400.00","AssociationFeeFrequency":"Monthly","AssociationFeeIncludes":"Reserves, Maintenance Grounds, Snow Removal, Trash","AssociationYN":"1","AttributionContact":"3035433083","Basement":"Unfinished","BasementYN":"1","BathroomsFull":"3","BathroomsHalf":"0","BathroomsOneQuarter":null,"BathroomsThreeQuarter":"0","BelowGradeFinishedArea":"0","BuilderModel":null,"BuilderName":null,"BuyerOfficeName":null,"BuyerFinancing":null,"CapRate":null,"CityRegion":null,"CommonInterest":null,"CommunityFeatures":null,"ComplexName":null,"ConstructionMaterials":"Wood Frame","Contingency":null,"Cooling":"Central Air","CountyOrParish":"Boulder","CoveredSpaces":null,"CurrentFinancing":null,"DevelopmentName":null,"DevelopmentStatus":null,"DirectionFaces":null,"DoorFeatures":null,"Electric":null,"ElementarySchool":"Flatirons","Exclusions":null,"ExteriorFeatures":null,"Fencing":null,"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":"Boulder","HorseAmenities":null,"HorseYN":null,"Inclusions":null,"IndoorFeatures":null,"InteriorFeatures":"Eat-in Kitchen, Five Piece Bath, Jack & Jill Bathroom, Open Floorplan, Vaulted Ceiling(s), Walk-In Closet(s)","InternetAddressDisplayYN":null,"LaundryFeatures":null,"Levels":"Tri-Level","ListAgentFullName":"Daphne Queen","ListAgentEmail":null,"ListingTerms":"Cash, Conventional, FHA, VA Loan","LivingArea":null,"LotFeatures":"Sprinklers In Front","LotSizeArea":null,"LotSizeDimensions":null,"LotSizeSquareFeet":null,"MainLevelBathrooms":"1","MainLevelBedrooms":"2","MiddleOrJuniorSchool":"Manhattan","Model":null,"NewConstructionYN":null,"NumberOfUnitsTotal":null,"OtherParking":null,"Ownership":"Builder","ParkingFeatures":null,"ParkingTotal":"1","PatioAndPorchFeatures":null,"PoolFeatures":null,"PoolYN":null,"PoolPrivateYN":null,"PropertyAttachedYN":"1","PropertyCondition":"Under Construction","PropertySubType":"Condominium","public_remarks":"Welcome to 28 Arapahoe Ave, a stunning condo nestled on a protected mountain hillside, offering a unique blend of modern design and scenic canyon views. This exceptional property offers a spacious and luxurious living experience, with attention to both aesthetics and sustainability.Step onto the elevated patio and immerse yourself in the tranquility of the surroundings. There is an option to upgrade this property and have an outdoor shower and heated dipping pool for a refreshing oasis, while the rock outcroppings add a touch of natural beauty. Multiple decks and balconies extend the living areas, allowing you to fully embrace the canyon air and enjoy the breathtaking views.Inside, you'll find a thoughtfully designed space that prioritizes comfort and efficiency. The property features an elevator for easy access to all levels. The 1-car garage provides ample storage space and additional room for toys. Furthermore, the property boasts EV charging stations, PV solar panels, and an ultra energy-efficient mechanical system, ensuring both sustainability and cost savings. The superior indoor air quality (IAQ) specifications create a healthy and comfortable living environment.The modern design features expansive glass windows, maximizing natural light and seamlessly integrating the beauty of the outdoors. Cathedral ceilings in the primary bedroom and the rooftop level family room enhance the sense of volume and spaciousness. Located in a serene canyon setting, 28 Arapahoe Ave offers a unique retreat while still providing easy access to urban amenities. Embrace the beauty of nature, go hiking or biking on nearby trails, and savor the peace and privacy this location offers.","Roof":"Composition","RoomsTotal":null,"SchoolDistrict":"Boulder Valley RE 2","SecurityFeatures":null,"seller_office_id":null,"SeniorCommunityYN":null,"Sewer":"Public Sewer","SkiFeatures":null,"SpaFeatures":null,"SpaYN":null,"SpecialListingConditions":null,"StandardStatus":null,"StateRegion":null,"StoriesTotal":null,"StructureType":"Duplex","TaxAnnualAmount":"0.00","Utilities":"Electricity Available, Natural Gas Available","View":null,"ViewYN":null,"VirtualTourURLUnbranded":null,"WalkScore":null,"WaterBodyName":null,"WaterSource":"Public","WaterfrontFeatures":null,"WaterfrontYN":null,"WindowFeatures":null,"YearBuilt":"2024","Zoning":"RES","ZoningDescription":null,"property_uid":"REC2036012544","listing_status":"active","mls_status":"Active","mls_id":"denver","listing_num":"IR1000242","acreage":null,"acres":null,"address":null,"address_direction":null,"address_flg":"1","address_num":"28","agent_id":"IRP28683","area":null,"baths_total":"3.00","bedrooms_total":"3","car_spaces":"1","city":"Boulder","coseller_id":null,"coagent_id":"IRP28755","days_on_market":null,"finished_sqft_total":"2526","geocode_address":"28 Arapahoe Avenue","geocode_status":null,"lat":"40.013179","lon":"-105.298839","office_id":"IR8ZRE","office_name":"8z Real Estate","orig_price":"3690000","photo_count":"16","previous_price":"3690000","price":"3415000","prop_img":"\/listing\/photos\/denver\/IR1000242-0.jpeg","property_type":"Residential","sqft_total":"2666","state":"CO","street_type":"Avenue","street_name":"Arapahoe","sub_area":"Saddle Creek","unit":null,"zip_code":"80302","listing_dt":"2023-12-01","undercontract_dt":null,"openhouse_dt":null,"price_change_dt":"2024-03-06","seller_id":null,"sold_dt":null,"sold_price":null,"webapi_update_dt":null,"update_dt":"2024-04-26 00:52:36","create_dt":"2023-12-02 00:01:41","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}