Start of property details
Property Details
Open House Saturday May 4th 11-2! Its like getting 2 homes for the price of 1. Step into luxurious living with this expansive 4500 Finished Sq FT Next- Gen Style, 4-bedroom, 4-bath home Located In The Pool Community of Moore Farm * Low Taxes -NON Metro District * Quick Move In Ready, New Carpet, Paint and Refinished Hardwood Floors, 2 Primary Suites, 2 Full Kitchens, 2 Laundry Rooms, 2 Fireplaces, 4 Beds, 4 Baths, Office, Great Room, Excercise Room, Media Room, Bar, Dinning Room, Play Room, Oversized 2.5 Car Garage, Extended Lentgh Driveway, Corner Lot, Full Patio, Custom Pergola and Gas Rough In For Outdoor Kitchn and More. This amazing home, combines modern elegance with family-friendly comfort. The interior features a grand entryway that leads into a bright and open floor plan, connecting a sophisticated living room, formal dining area, and 2 state-of-the-art kitchens, equipped with sleek granite countertops, and a large island that makes cooking and entertaining a delight. Located Next To Bella Rosa Golf Course and Milavec Lake and community paths just out the door, you will Love The Quick Access To Trails, pool and Milavec Lake and Extra Parking On This Corner Lot and The Highly Desirable Moore Farms Community and Pool. Ask About The Town Of Frederick Plans For Milavec Lake Receration Expansion. Outside, the property boasts a meticulously landscaped backyard complete with a charming patio area, ideal for outdoor gatherings and enjoying serene views. The front of the home is equally impressive with its inviting curb appeal. This home is situated in a peaceful, family-oriented neighborhood, with easy access to local parks, hiking trails, and recreational facilities, promoting an active and engaged lifestyle. The community is known for its safety, cleanliness, and friendly atmosphere. Agent Owned
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_4149269","AboveGradeFinishedArea":"2288","AccessibilityFeatures":null,"Appliances":"Bar Fridge, Dishwasher, Disposal, Double Oven","ArchitecturalStyle":null,"AssociationAmenities":"Playground, Pool, Trail(s)","AssociationFee":"173.25","AssociationFeeFrequency":"Quarterly","AssociationFeeIncludes":"Maintenance Grounds","AssociationYN":"1","AttributionContact":"contracts@yourhomesourceteam.com, 720-545-3135","Basement":"Finished, Full, Sump Pump","BasementYN":"1","BathroomsFull":"3","BathroomsHalf":"0","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"1","BelowGradeFinishedArea":"2228","BuilderModel":null,"BuilderName":"D.R. Horton, Inc","BuyerOfficeName":null,"BuyerFinancing":null,"CapRate":null,"CityRegion":null,"CommonInterest":null,"CommunityFeatures":null,"ComplexName":null,"ConstructionMaterials":"Cement Siding","Contingency":null,"Cooling":"Central Air","CountyOrParish":"Weld","CoveredSpaces":null,"CurrentFinancing":null,"DevelopmentName":null,"DevelopmentStatus":null,"DirectionFaces":null,"DoorFeatures":null,"Electric":null,"ElementarySchool":"Legacy","Exclusions":"Washers, Dryers, Freezer, Wall Mounted TVs, Refrigerator In Basement Kitchen","ExteriorFeatures":null,"Fencing":"Partial","FireplaceFeatures":"Basement, Great Room","FireplaceYN":null,"FireplacesTotal":null,"Flooring":"Carpet, Tile, Wood","FoundationDetails":"Concrete Perimeter","GarageSpaces":null,"GreenBuildingVerificationType":null,"GreenEnergyEfficient":null,"GreenEnergyGeneration":null,"GreenIndoorAirQuality":null,"GreenLocation":null,"GreenSustainability":null,"GreenWaterConservation":null,"Heating":"Forced Air","HighSchool":"Frederick","HorseAmenities":null,"HorseYN":null,"Inclusions":null,"IndoorFeatures":null,"InteriorFeatures":"Built-in Features, Ceiling Fan(s), Corian Counters, Eat-in Kitchen, Entrance Foyer, Five Piece Bath, Granite Counters, High Ceilings, In-Law Floor Plan, Kitchen Island, Open Floorplan, Pantry, Primary Suite, Radon Mitigation System, Smoke Free, Solid Surface Counters, Vaulted Ceiling(s), Walk-In Closet(s), Wet Bar","InternetAddressDisplayYN":null,"LaundryFeatures":null,"Levels":"One","ListAgentFullName":"Robert Oakley","ListAgentEmail":null,"ListingTerms":"Cash, Conventional, FHA","LivingArea":null,"LotFeatures":null,"LotSizeArea":"8248.00","LotSizeDimensions":null,"LotSizeSquareFeet":"8248.00","MainLevelBathrooms":"2","MainLevelBedrooms":"3","MiddleOrJuniorSchool":"Thunder Valley","Model":null,"NewConstructionYN":null,"NumberOfUnitsTotal":null,"OtherParking":null,"Ownership":"Agent Owner","ParkingFeatures":null,"ParkingTotal":"2","PatioAndPorchFeatures":"Covered, Deck, Front Porch, Patio","PoolFeatures":null,"PoolYN":null,"PoolPrivateYN":null,"PropertyAttachedYN":"0","PropertyCondition":null,"PropertySubType":"Single Family Residence","public_remarks":"Open House Saturday May 4th 11-2! Its like getting 2 homes for the price of 1. Step into luxurious living with this expansive 4500 Finished Sq FT Next- Gen Style, 4-bedroom, 4-bath home Located In The Pool Community of Moore Farm *Low Taxes -NON Metro District*Quick Move In Ready, New Carpet, Paint & Refinished Hardwood Floors, 2 Primary Suites, 2 Full Kitchens, 2 Laundry Rooms, 2 Fireplaces, 4 Beds, 4 Baths, Office, Great Room, Excercise Room, Media Room, Bar, Dinning Room, Play Room, Oversized 2.5 Car Garage, Extended Lentgh Driveway, Corner Lot, Full Patio, Custom Pergola & Gas Rough In For Outdoor Kitchn & More. This amazing home, combines modern elegance with family-friendly comfort. The interior features a grand entryway that leads into a bright and open floor plan, connecting a sophisticated living room, formal dining area, and 2 state-of-the-art kitchens, equipped with sleek granite countertops, and a large island that makes cooking and entertaining a delight. Located Next To Bella Rosa Golf Course & Milavec Lake and community paths just out the door, you will Love The Quick Access To Trails, pool & Milavec Lake & Extra Parking On This Corner Lot & The Highly Desirable Moore Farms Community & Pool. Ask About The Town Of Frederick Plans For Milavec Lake Receration Expansion. Outside, the property boasts a meticulously landscaped backyard complete with a charming patio area, ideal for outdoor gatherings and enjoying serene views. The front of the home is equally impressive with its inviting curb appeal. This home is situated in a peaceful, family-oriented neighborhood, with easy access to local parks, hiking trails, and recreational facilities, promoting an active and engaged lifestyle. The community is known for its safety, cleanliness, and friendly atmosphere. Agent Owned","Roof":"Architecural Shingle","RoomsTotal":null,"SchoolDistrict":"St. Vrain Valley RE-1J","SecurityFeatures":"Carbon Monoxide Detector(s), Smoke Detector(s), Video Doorbell","seller_office_id":null,"SeniorCommunityYN":"0","Sewer":"Public Sewer","SkiFeatures":null,"SpaFeatures":null,"SpaYN":null,"SpecialListingConditions":"None","StandardStatus":null,"StateRegion":null,"StoriesTotal":null,"StructureType":"House","TaxAnnualAmount":"4446.00","Utilities":null,"View":null,"ViewYN":null,"VirtualTourURLUnbranded":"https:\/\/www.youtube.com\/watch?v=0eKz24zaz88","WalkScore":null,"WaterBodyName":null,"WaterSource":"Public","WaterfrontFeatures":null,"WaterfrontYN":null,"WindowFeatures":"Double Pane Windows, Window Coverings","YearBuilt":"2015","Zoning":null,"ZoningDescription":null,"property_uid":"REC2038178899","listing_status":"active","mls_status":"Active","mls_id":"denver","listing_num":"4149269","acreage":null,"acres":"0.19","address":null,"address_direction":null,"address_flg":"1","address_num":"5501","agent_id":"55042719","area":null,"baths_total":"4.00","bedrooms_total":"4","car_spaces":"2","city":"Frederick","coseller_id":null,"coagent_id":null,"days_on_market":null,"finished_sqft_total":"4516","geocode_address":"5501 Mustang Drive","geocode_status":null,"lat":"40.12958138","lon":"-104.95138016","office_id":"1HOME","office_name":"HomeSmart","orig_price":"739995","photo_count":"50","previous_price":null,"price":"739995","prop_img":"\/listing\/photos\/denver\/4149269-0.jpeg","property_type":"Residential","sqft_total":"4560","state":"CO","street_type":"Drive","street_name":"Mustang","sub_area":"Moore Farm","unit":null,"zip_code":"80504","listing_dt":"2024-04-26","undercontract_dt":null,"openhouse_dt":null,"price_change_dt":null,"seller_id":null,"sold_dt":null,"sold_price":null,"webapi_update_dt":null,"update_dt":"2024-05-05 18:03:24","create_dt":"2024-04-22 17:47:28","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}