Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#19162 +post_id: "45939" +post_author: 1 +"ListingKey": "20250910163636866463000000" +"ListingId": "6919131" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-14T02:01:30Z" +"RFModificationTimestamp": "2026-04-14T02:07:18Z" +"ListPrice": 8999000.0 +"BathroomsTotalInteger": 7.0 +"BathroomsHalf": 1 +"BedroomsTotal": 5.0 +"LotSizeArea": 190009.0 +"LivingArea": 8000.0 +"BuildingAreaTotal": 0 +"City": "Scottsdale" +"PostalCode": "85262" +"UnparsedAddress": "38824 N Charles Blair Macdonald Road, Scottsdale, Arizona 85262" +"Coordinates": array:2 [ 0 => -111.875755 1 => 33.839209 ] +"Latitude": 33.839209 +"Longitude": -111.875755 +"YearBuilt": 2025 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Daniel Wolski" +"ListOfficeName": "Russ Lyon Sotheby's International Realty" +"ListAgentMlsId": "dw419" +"ListOfficeMlsId": "lyon09" +"OriginatingSystemName": "ARMLS" +"PublicRemarks": "Plans underway for this spectacular home designed by Kontexture and to be built by Silvercreek Development. Situated on a ridgetop lot in North Scottsdale guard gated community of Carefree Ranch Estates, this 8,000 square foot home features the latest and greatest in modern desert living with an emphasis on biophilic design. 5 bedrooms including guest house, plus office, and private master bedroom lounge. Spa like dual master bath with free standing tub, oversized shower with views of Desert Mountain Golf course and Pinnacle Peakand dual walk-in closets. HUGE great room with chef's kitchen, butler's pantry, top of line appliances, all spilling to the outdoors via walls of glass for indoor and outdoor entertaining needs. The outdoors includes 2,000+SF elevated terrace with outdoor kitchen," +"Appliances": "Dryer,Washer,Refrigerator,Built-in Microwave,Dishwasher,Disposal,Gas Cooktop" +"ApprovalStatus": true +"ArchitecturalStyle": "Contemporary" +"AssociationFee": "2977.92" +"AssociationFeeFrequency": "Annually" +"AssociationFeeIncludes": array:1 [ 0 => "Maintenance Grounds" ] +"AssociationName": "Preferred Communitie" +"AssociationPhone": "480-488-9420" +"AssociationYN": true +"BathroomsFull": 6 +"BedroomsPossible": 7 +"BuilderName": "SilverCreek Development" +"BuildingAreaSource": "Builder" +"CommunityFeatures": "Gated" +"ConstructionMaterials": array:2 [ 0 => "Wood Frame" 1 => "Block" ] +"Cooling": "Central Air,Ceiling Fan(s)" +"CoolingYN": true +"CountyOrParish": "Maricopa" +"CoveredSpaces": "4.0" +"CreationDate": "2025-09-13T00:52:31.476282+00:00" +"CrossStreet": "Pima Rd / Cave Creek Rd" +"CurrentFinancing": array:1 [ 0 => "Non Assumable" ] +"Directions": "From the intersection of Pima Rd and Cave Creek Rd, head North on Pima Rd to Guard Gate." +"Disclosures": array:1 [ 0 => "Agency Discl Req" ] +"DocumentsChangeTimestamp": "2025-09-13T00:48:13Z" +"ElementarySchool": "Black Mountain Elementary School" +"ElementarySchoolDistrict": "Cave Creek Unified District" +"ExteriorFeatures": "Balcony,Private Street(s),Built-in Barbecue" +"Fencing": array:1 [ 0 => "See Remarks" ] +"FireplaceFeatures": array:2 [ 0 => "Fire Pit" 1 => "Other" ] +"FireplaceYN": true +"FireplacesTotal": "3" +"GarageSpaces": "4.0" +"Heating": "Natural Gas" +"HeatingYN": true +"HighSchool": "Cactus Shadows High School" +"HighSchoolDistrict": "Cave Creek Unified District" +"InteriorFeatures": "Walk-in Pantry,High Speed Internet,Double Vanity,See Remarks,9+ Flat Ceilings,Kitchen Island,Pantry,Full Bth Master Bdrm,Separate Shwr & Tub" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAgentAOR": "Scottsdale" +"ListAgentFax": "480-624-3416" +"ListAgentFirstName": "Daniel" +"ListAgentKey": "20080522003314462987000000" +"ListAgentLastName": "Wolski" +"ListAgentPreferredPhone": "480-266-7557" +"ListAgentURL": "wgoaz.com" +"ListOfficeEmail": "bret.lamberson@russlyon.com" +"ListOfficeFax": "480-437-2900" +"ListOfficeKey": "20071206231602683322000000" +"ListOfficePhone": "480-488-2998" +"ListOfficeURL": "www.russlyon.com" +"ListingContractDate": "2025-09-12" +"ListingTerms": "Cash,Conventional" +"LivingAreaSource": "Builder" +"LotFeatures": array:7 [ 0 => "Hillside Lot" 1 => "Sprinklers In Rear" 2 => "Sprinklers In Front" 3 => "Desert Back" 4 => "Desert Front" 5 => "Auto Timer H2O Front" 6 => "Auto Timer H2O Back" ] +"LotSizeAcres": 4.36 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 190009.0 +"MajorChangeTimestamp": "2025-09-13T00:48:12Z" +"MajorChangeType": "New Listing" +"MiddleOrJuniorSchool": "Sonoran Trails Middle School" +"MlsStatus": "Active" +"OriginalEntryTimestamp": "2025-09-13T02:48:12Z" +"OriginatingSystemID": "M00000048" +"OriginatingSystemKey": "20250910163636866463000000" +"OtherStructures": array:1 [ 0 => "Separate Guest House" ] +"Ownership": "Fee Simple" +"ParcelNumber": "219-11-421" +"ParkingFeatures": "Direct Access,Separate Strge Area" +"PatioAndPorchFeatures": array:2 [ 0 => "Covered Patio(s)" 1 => "Patio" ] +"PhotosChangeTimestamp": "2025-09-13T00:48:13Z" +"PhotosCount": 16 +"PoolFeatures": "Heated" +"PoolPrivateYN": true +"Possession": array:1 [ 0 => "Close Of Escrow" ] +"PostalCity": "Scottsdale" +"PropertyCondition": array:1 [ 0 => "To Be Built" ] +"PublicSurveyRange": "5E" +"PublicSurveySection": "30" +"Roof": "Other,Foam" +"SecurityFeatures": array:1 [ 0 => "Fire Sprinkler System" ] +"Sewer": "Public Sewer" +"SourceSystemID": "M00000048" +"SourceSystemKey": "20250910163636866463000000" +"SourceSystemName": "Arizona Regional Multiple Listing Service (ARMLS)" +"SpaFeatures": array:2 [ 0 => "Heated" 1 => "Private" ] +"SpecialListingConditions": array:1 [ 0 => "Owner/Agent" ] +"StateOrProvince": "AZ" +"StatusChangeTimestamp": "2025-09-13T00:48:12Z" +"StoriesTotal": "2" +"StreetDirPrefix": "N" +"StreetName": "CHARLES BLAIR MACDONALD" +"StreetNumber": "38824" +"StreetNumberNumeric": "38824" +"StreetSuffix": "Road" +"SubdivisionName": "LONE MOUNTAIN" +"TaxAnnualAmount": "1836.0" +"TaxBookNumber": "219.00" +"TaxLegalDescription": "LOT 20 LONE MOUNTAIN MCR 022540" +"TaxLot": "20" +"TaxMapNumber": "11.00" +"TaxYear": "2022" +"Township": "6N" +"View": array:1 [ 0 => "Mountain(s)" ] +"VirtualTourURLUnbranded": "https://www.tourfactory.com/idxr3224847" +"WaterSource": array:1 [ 0 => "City Water" ] +"Spa_co_Heated": true +"Spa_co_Private": true +"Roofing_co_Foam": true +"Utilities_co_APS": true +"Roofing_co_Other33": true +"Construction_co_Block": true +"Architect_co_Architect": "Kontexture" +"Legal_sp_Info_co_Range": "5E" +"Skirt@Core.Permissions": "None" +"Levels@Core.Permissions": "None" +"Utilities_co_SW_sp_Gas3": true +"Zoning@Core.Permissions": "None" +"CapRate@Core.Permissions": "None" +"Country@Core.Permissions": "None" +"Stories@Core.Permissions": "None" +"Cooling_co_Central_sp_Air": true +"GarageYN@Core.Permissions": "None" +"Heating_co_Natural_sp_Gas": true +"Legal_sp_Info_co_Section2": "30" +"Lockbox_sp_Type_co_None43": true +"New_sp_Financing_co_Cash2": true +"ParkName@Core.Permissions": "None" +"Basement_co_Basement_sp_YN": "N" +"Fencing_co_See_sp_Remarks6": true +"Furnished@Core.Permissions": "None" +"OwnerName@Core.Permissions": "None" +"OwnerPays@Core.Permissions": "None" +"AccessCode@Core.Permissions": "None" +"CurrentUse@Core.Permissions": "None" +"Disclaimer@Core.Permissions": "None" +"OwnerPhone@Core.Permissions": "None" +"Topography@Core.Permissions": "None" +"Vegetation@Core.Permissions": "None" +"Architecture_co_Contemporary": true +"FuelExpense@Core.Permissions": "None" +"GrossIncome@Core.Permissions": "None" +"LeaseAmount@Core.Permissions": "None" +"ListTeamKey@Core.Permissions": "None" +"LockBoxType@Core.Permissions": "None" +"MobileWidth@Core.Permissions": "None" +"PetsAllowed@Core.Permissions": "None" +"BusinessName@Core.Permissions": "None" +"BusinessType@Core.Permissions": "None" +"BuyerTeamKey@Core.Permissions": "None" +"DaysOnMarket@Core.Permissions": "None" +"Exterior_sp_Features_co_Patio": true +"Kitchen_sp_Features_co_Pantry": true +"Landscaping_co_Desert_sp_Back": true +"Laundry_co_Dryer_sp_Included2": true +"LeasableArea@Core.Permissions": "None" +"ListPriceLow@Core.Permissions": "None" +"ListTeamName@Core.Permissions": "None" +"MLSAreaMajor@Core.Permissions": "None" +"MobileLength@Core.Permissions": "None" +"NumberOfLots@Core.Permissions": "None" +"OccupantType@Core.Permissions": "None" +"OtherExpense@Core.Permissions": "None" +"ParkingTotal@Core.Permissions": "None" +"RentIncludes@Core.Permissions": "None" +"SourceMLSURL@Core.Permissions": "None" +"TrashExpense@Core.Permissions": "None" +"UnitTypeType@Core.Permissions": "None" +"BuyerAgentAOR@Core.Permissions": "None" +"BuyerAgentFax@Core.Permissions": "None" +"BuyerAgentURL@Core.Permissions": "None" +"BuyerTeamName@Core.Permissions": "None" +"Community_sp_Features_co_Gated": true +"Landscaping_co_Desert_sp_Front": true +"Laundry_co_Washer_sp_Included2": true +"ListOfficeAOR@Core.Permissions": "None" +"OwnershipType@Core.Permissions": "None" +"StructureType@Core.Permissions": "None" +"WaterBodyName@Core.Permissions": "None" +"WithdrawnDate@Core.Permissions": "None" +"BuyerFinancing@Core.Permissions": "None" +"BuyerOfficeAOR@Core.Permissions": "None" +"BuyerOfficeFax@Core.Permissions": "None" +"BuyerOfficeURL@Core.Permissions": "None" +"CoListAgentAOR@Core.Permissions": "None" +"DirectionFaces@Core.Permissions": "None" +"ExpirationDate@Core.Permissions": "None" +"Exterior_sp_Features_co_Balcony": true +"Kitchen_sp_Features_co_Disposal": true +"ListAgentEmail@Core.Permissions": "None" +"PrivateRemarks@Core.Permissions": "None" +"BuyerAgentEmail@Core.Permissions": "None" +"BuyerAgentPager@Core.Permissions": "None" +"CancelationDate@Core.Permissions": "None" +"CoListOfficeAOR@Core.Permissions": "None" +"CoListOfficeFax@Core.Permissions": "None" +"CoListOfficeURL@Core.Permissions": "None" +"Contract_sp_Information_co_Type3": "Exclusive Right To Sell" +"CopyrightNotice@Core.Permissions": "None" +"ElectricExpense@Core.Permissions": "None" +"Fireplace_sp_Features_co_Firepit": true +"GardenerExpense@Core.Permissions": "None" +"LeaseExpiration@Core.Permissions": "None" +"LivingAreaUnits@Core.Permissions": "None" +"LockBoxLocation@Core.Permissions": "None" +"Water_sp_Source_co_City_sp_Water": true +"Association_sp_Fees_co_HOA_sp_YN2": "Y" +"AvailabilityDate@Core.Permissions": "None" +"BathroomsPartial@Core.Permissions": "None" +"BuildingFeatures@Core.Permissions": "None" +"CoBuyerOfficeAOR@Core.Permissions": "None" +"CoBuyerOfficeFax@Core.Permissions": "None" +"CoBuyerOfficeKey@Core.Permissions": "None" +"CoBuyerOfficeURL@Core.Permissions": "None" +"CoListAgentPager@Core.Permissions": "None" +"InsuranceExpense@Core.Permissions": "None" +"Kitchen_sp_Features_co_Dishwasher": true +"ListingAgreement@Core.Permissions": "None" +"New_sp_Financing_co_Conventional5": true +"OperatingExpense@Core.Permissions": "None" +"PendingTimestamp@Core.Permissions": "None" +"RoadFrontageType@Core.Permissions": "None" +"SignOnPropertyYN@Core.Permissions": "None" +"View_co_Mountain_lparen_s_rparen_": true +"Association_sp_Fees_co_HOA_sp_Fee2": 2977.92 +"CoBuyerOfficeName@Core.Permissions": "None" +"CoListOfficeEmail@Core.Permissions": "None" +"CoListOfficePhone@Core.Permissions": "None" +"DevelopmentStatus@Core.Permissions": "None" +"ExistingLeaseType@Core.Permissions": "None" +"Location_sp_Tax_sp_Legal_co_Taxes2": 1836.0 +"LotSizeDimensions@Core.Permissions": "None" +"NumberOfBuildings@Core.Permissions": "None" +"OnMarketTimestamp@Core.Permissions": "None" +"OriginalListPrice@Core.Permissions": "None" +"PreviousListPrice@Core.Permissions": "None" +"SeniorCommunityYN@Core.Permissions": "None" +"Technology_co_Cable_sp_TV_sp_Avail": true +"WaterSewerExpense@Core.Permissions": "None" +"Association_sp_Fees_co_HOA_sp_Name4": "Preferred Communitie" +"BuyerAgentLastName@Core.Permissions": "None" +"CoBuyerOfficeEmail@Core.Permissions": "None" +"CoBuyerOfficeMlsId@Core.Permissions": "None" +"CoBuyerOfficePhone@Core.Permissions": "None" +"Kitchen_sp_Features_co_Refrigerator": true +"ListAgentVoiceMail@Core.Permissions": "None" +"ListOfficePhoneExt@Core.Permissions": "None" +"MaintenanceExpense@Core.Permissions": "None" +"NetOperatingIncome@Core.Permissions": "None" +"NumberOfUnitsTotal@Core.Permissions": "None" +"OffMarketTimestamp@Core.Permissions": "None" +"Other_sp_Rooms_co_BonusGame_sp_Room": true +"Possession_co_Close_sp_of_sp_Escrow": true +"ShowingContactType@Core.Permissions": "None" +"AdditionalParcelsYN@Core.Permissions": "None" +"BathroomsOneQuarter@Core.Permissions": "None" +"BuyerAgentFirstName@Core.Permissions": "None" +"BuyerAgentVoiceMail@Core.Permissions": "None" +"BuyerOfficePhoneExt@Core.Permissions": "None" +"FinancialDataSource@Core.Permissions": "None" +"ListAgentMiddleName@Core.Permissions": "None" +"Sewer_co_Sewer_sp__hyphen__sp_Public": true +"ShowingInstructions@Core.Permissions": "None" +"Assoc_sp_RulesInfo_co_Prof_sp_Managed": true +"AssociationAmenities@Core.Permissions": "None" +"Association_sp_Fees_co_HOA_sp_2_sp_YN": "N" +"BuyerAgentMiddleName@Core.Permissions": "None" +"CoListAgentVoiceMail@Core.Permissions": "None" +"CoListOfficePhoneExt@Core.Permissions": "None" +"Contract_sp_Information_co_Ownership2": "Fee Simple" +"Disclosures_co_Agency_sp_Discl_sp_Req": true +"GrossScheduledIncome@Core.Permissions": "None" +"HoursDaysOfOperation@Core.Permissions": "None" +"Kitchen_sp_Features_co_Gas_sp_Cooktop": true +"ListAgentDirectPhone@Core.Permissions": "None" +"ListAgentMobilePhone@Core.Permissions": "None" +"ListAgentOfficePhone@Core.Permissions": "None" +"Master_sp_Bathroom_co_Double_sp_Sinks": true +"PrivateOfficeRemarks@Core.Permissions": "None" +"StreetSuffixModifier@Core.Permissions": "None" +"VacancyAllowanceRate@Core.Permissions": "None" +"BathroomsThreeQuarter@Core.Permissions": "None" +"BathroomsTotalDecimal@Core.Permissions": "None" +"BuyerAgentDirectPhone@Core.Permissions": "None" +"BuyerAgentMobilePhone@Core.Permissions": "None" +"BuyerAgentOfficePhone@Core.Permissions": "None" +"CoBuyerOfficePhoneExt@Core.Permissions": "None" +"CoListAgentMiddleName@Core.Permissions": "None" +"Dining_sp_Area_co_Dining_sp_in_sp_LRGR": true +"DistanceToGasComments@Core.Permissions": "None" +"ListAgentStateLicense@Core.Permissions": "None" +"ListAgentVoiceMailExt@Core.Permissions": "None" +"Private_sp_Pool_sp_Features_co_Heated3": true +"VideosChangeTimestamp@Core.Permissions": "None" +"VirtualTourURLBranded@Core.Permissions": "None" +"BuyerAgentStateLicense@Core.Permissions": "None" +"BuyerAgentVoiceMailExt@Core.Permissions": "None" +"CoListAgentDirectPhone@Core.Permissions": "None" +"CoListAgentOfficePhone@Core.Permissions": "None" +"CumulativeDaysOnMarket@Core.Permissions": "None" +"Interior_sp_Features_co_See_sp_Remarks2": true +"ListAgentTollFreePhone@Core.Permissions": "None" +"Parking_sp_Features_co_Direct_sp_Access": true +"Technology_co_High_sp_Speed_sp_Internet": true +"Association_sp_Fees_co_HOA_sp_Telephone4": "480-488-9420" +"Association_sp_Fees_co_PAD_sp_Fee_sp_YN2": "N" +"BuyerAgentTollFreePhone@Core.Permissions": "None" +"CoBuyerAgentMobilePhone@Core.Permissions": "None" +"CoListAgentStateLicense@Core.Permissions": "None" +"CoListAgentVoiceMailExt@Core.Permissions": "None" +"DistanceToSewerComments@Core.Permissions": "None" +"DistanceToWaterComments@Core.Permissions": "None" +"Kitchen_sp_Features_co_Kitchen_sp_Island": true +"ListAgentOfficePhoneExt@Core.Permissions": "None" +"BuyerAgentOfficePhoneExt@Core.Permissions": "None" +"CoListAgentTollFreePhone@Core.Permissions": "None" +"Construction_co_Frame_sp__hyphen__sp_Wood": true +"ContractStatusChangeDate@Core.Permissions": "None" +"OperatingExpenseIncludes@Core.Permissions": "None" +"Special_sp_Listing_sp_Cond_co_OwnerAgent4": true +"CoListAgentOfficePhoneExt@Core.Permissions": "None" +"Cooling_co_Ceiling_sp_Fan_lparen_s_rparen_": true +"NumberOfFullTimeEmployees@Core.Permissions": "None" +"NumberOfPartTimeEmployees@Core.Permissions": "None" +"Property_sp_Description_co_Hillside_sp_Lot": true +"Showing_sp_Notification_sp_Methods_co_Text": true +"Association_sp_Fees_co_Other_sp_Fees_sp_HOA": 0.0 +"Construction_sp_Status_co_To_sp_Be_sp_Built": true +"DistanceToElectricComments@Core.Permissions": "None" +"Interior_sp_Features_co_Fire_sp_Sprinklers3": true +"Landscaping_co_Auto_sp_Timer_sp_H2O_sp_Back": true +"Landscaping_co_Yrd_sp_Wtring_sp_Sys_sp_Back": true +"ListAgentPreferredPhoneExt@Core.Permissions": "None" +"Showing_sp_Notification_sp_Methods_co_Email": true +"BuyerAgentPreferredPhoneExt@Core.Permissions": "None" +"General_sp_Property_sp_Description_co_Horses": "N" +"Landscaping_co_Auto_sp_Timer_sp_H2O_sp_Front": true +"Landscaping_co_Yrd_sp_Wtring_sp_Sys_sp_Front": true +"CoListAgentPreferredPhoneExt@Core.Permissions": "None" +"General_sp_Property_sp_Description_co_ud_i_07": 3.0 +"Interior_sp_Features_co_9_sp_Flat_sp_Ceilings": true +"Master_sp_Bathroom_co_Separate_sp_Shwr_sp_Tub": true +"MiddleOrJuniorSchoolDistrict@Core.Permissions": "None" +"Association_sp_Fees_co_HOA_sp_Transfer_sp_Fee2": 400.0 +"Exterior_sp_Features_co_Built_hyphen_in_sp_BBQ": true +"Parking_sp_Spaces_co_Slab_sp_Parking_sp_Spaces": 0.0 +"ProfessionalManagementExpense@Core.Permissions": "None" +"Association_sp_Fees_co_HOA_sp_Paid_sp_Frequency": "Annually" +"DistanceToPhoneServiceComments@Core.Permissions": "None" +"General_sp_Property_sp_Description_co_PriceSqFt": 1124.88 +"Kitchen_sp_Features_co_Walk_hyphen_in_sp_Pantry": true +"Master_sp_Bathroom_co_Private_sp_Toilet_sp_Room": true +"Parking_sp_Spaces_co_Total_sp_Covered_sp_Spaces": 4.0 +"Separate_sp_DenOffice_co_Sep_sp_DenOffice_sp_YN": "Y" +"TaxOtherAnnualAssessmentAmount@Core.Permissions": "None" +"Association_sp_Fees_co_Disclosure_sp_Fees_sp_HOA": 400.0 +"Location_sp_Tax_sp_Legal_co_Tax_sp_Municipality3": "Scottsdale" +"Parking_sp_Features_co_Separate_sp_Strge_sp_Area": true +"Association_sp_Fees_co_Land_sp_Lease_sp_Fee_sp_YN": "N" +"Association_sp_Fees_co_Rec_sp_Center_sp_Fee_sp_YN": "N" +"Exterior_sp_Features_co_Separate_sp_Guest_sp_House": true +"Association_sp_Fees_co_Special_sp_Assessment_sp_HOA": "No" +"Association_sp_Fees_co_Ttl_sp_Mthly_sp_Fee_sp_Equiv": 248.16 +"Kitchen_sp_Features_co_Built_hyphen_in_sp_Microwave": true +"Master_sp_Bathroom_co_Full_sp_Bth_sp_Master_sp_Bdrm": true +"Other_sp_Rooms_co_Guest_sp_Qtrs_hyphen_Sep_sp_Entrn": true +"Showing_sp_Notification_sp_Methods_co_Phone_sp_Call": true +"Existing_sp_1st_sp_Loan_co_Treat_sp_as_sp_FreeClear4": true +"Existing_sp_1st_sp_Loan_sp_Terms_co_Non_sp_Assumable": true +"General_sp_Property_sp_Description_co_Approx_sp_SQFT": 8000.0 +"General_sp_Property_sp_Description_co_High_sp_School": "Cactus Shadows High School" +"General_sp_Property_sp_Description_co_Builder_sp_Name": "SilverCreek Development" +"Association_sp_Fee_sp_Incl_co_Common_sp_Area_sp_Maint3": true +"Association_sp_Fees_co_Cap_sp_ImprovementImpact_sp_Fee": 0.0 +"General_sp_Property_sp_Description_co_Fireplace_sp_YN2": "Yes" +"General_sp_Property_sp_Description_co_Full_sp_Bathroom2": 6 +"General_sp_Property_sp_Description_co_Dwelling_sp_Styles": "Detached" +"General_sp_Property_sp_Description_co_Half_sp_Bathrooms2": 1 +"General_sp_Property_sp_Description_co_Marketing_sp_Name3": "Lone Mountain 20" +"Showing_sp_Notification_sp_Methods_co_Showing_sp_Service": "No Showing Service Used" +"Exterior_sp_Features_co_Covered_sp_Patio_lparen_s_rparen_": true +"Exterior_sp_Features_co_Private_sp_Street_lparen_s_rparen_": true +"General_sp_Property_sp_Description_co_Elementary_sp_School": "Black Mountain Elementary School" +"General_sp_Property_sp_Description_co_Jr_sp_High_sp_School": "Sonoran Trails Middle School" +"Dining_sp_Area_co_Other_sp__lparen_See_sp_Remarks_rparen_13": true +"General_sp_Property_sp_Description_co_Approx_sp_Lot_sp_SqFt": 190009.0 +"Association_sp_Fees_co_Prepaid_sp_Association_sp_Fees_sp_HOA": 2977.92 +"General_sp_Property_sp_Description_co_Private_sp_Pool_sp_YN2": "Yes" +"General_sp_Property_sp_Description_co_Approx_sp_Lot_sp_Acres2": 4.362 +"General_sp_Property_sp_Description_co_Planned_sp_Comm_sp_Name": "Carefree Ranch" +"General_sp_Property_sp_Description_co_Community_sp_Pool_sp_YN2": "No" +"Association_sp_Fees_co_HOA_sp_DisclosureAddendum_sp_Affirmation": "No" +"Location_sp_Tax_sp_Legal_co_Assessor_squote_s_sp_Map_sp__pound_3": 11.0 +"General_sp_Property_sp_Description_co_High_sp_School_sp_District2": "Cave Creek Unified District" +"Fireplace_sp_Features_co_Other_sp__lparen_See_sp_Remarks_rparen_14": true +"Association_sp_Fees_co_Cap_sp_ImprovementImpact_sp_Fee_sp__percent_": "$" +"Location_sp_Tax_sp_Legal_co_Assessor_squote_s_sp_Parcel_sp__pound_3": 421.0 +"Additional_sp_Bedroom_co_Other_sp_Bedroom_sp_Walk_hyphen_in_sp_Closet": true +"Additional_sp_Bedroom_co_Master_sp_Bedroom_sp_Walk_hyphen_in_sp_Closet": true +"General_sp_Property_sp_Description_co_Elementary_sp_School_sp_District2": "Cave Creek Unified District" +"Const_sp__hyphen__sp_Finish_co_Other_sp__lparen_See_sp_Remarks_rparen_55": true +"General_sp_Property_sp_Description_co__pound__sp_of_sp_Interior_sp_Levels": 1 +"Location_sp_Tax_sp_Legal_co_Legal_sp_Description_sp__lparen_Abbrev_rparen_3": "LOT 20 LONE MOUNTAIN MCR 022540" +"Contract_sp_Information_co_Co_hyphen_Ownership_sp__lparen_Fractional_rparen__sp_Agreement_sp_YN": "No" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('20250910163636866463000000')" +"provider_name": "ARMLS" +"SourceSystemPlatformID": "T00000052" +"SourceSystemPlatformName": "Flexmls" +"OriginatingSystemPlatformID": "T00000052" +"OriginatingSystemPlatformName": "Flexmls" +"Media": array:16 [ 0 => array:16 [ "Order" => 1 "MediaKey" => "20250913004502907022000000" "MediaURL" => "https://cdn.realtyfeed.com/cdn/54/20250910163636866463000000/8164a0819f90dc81c192b0dd7bb8adc6.webp" "@odata.id" => "https://replication.sparkapi.com/Version/2/Reso/OData/Property('20250910163636866463000000')/Media('20250913004502907022000000')" "MediaHTML" => null "MediaSize" => 719622 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/54/20250910163636866463000000/thumbnail-8164a0819f90dc81c192b0dd7bb8adc6.webp" "Permission" => array:1 [ 0 => "Public" ] "MediaCategory" => "Photo" "LongDescription" => "" "PreferredPhotoYN" => true "ResourceRecordID" => "20250910163636866463000000" "ShortDescription" => "001_01carefreeexterior" "ResourceRecordKey" => "20250910163636866463000000" "OriginatingSystemMediaKey" => "20250913004502907022000000" ] 1 => array:16 [ "Order" => 2 "MediaKey" => "20250913004505002972000000" "MediaURL" => "https://cdn.realtyfeed.com/cdn/54/20250910163636866463000000/869a8658b33b9382a42261ae15f2b29f.webp" "@odata.id" => "https://replication.sparkapi.com/Version/2/Reso/OData/Property('20250910163636866463000000')/Media('20250913004505002972000000')" "MediaHTML" => null "MediaSize" => 777208 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/54/20250910163636866463000000/thumbnail-869a8658b33b9382a42261ae15f2b29f.webp" "Permission" => array:1 [ 0 => "Public" ] "MediaCategory" => "Photo" "LongDescription" => "" "PreferredPhotoYN" => false "ResourceRecordID" => "20250910163636866463000000" "ShortDescription" => "002_02carefreeexterior02" "ResourceRecordKey" => "20250910163636866463000000" "OriginatingSystemMediaKey" => "20250913004505002972000000" ] 2 => array:16 [ "Order" => 3 "MediaKey" => "20250913004506690140000000" "MediaURL" => "https://cdn.realtyfeed.com/cdn/54/20250910163636866463000000/17188d9cdd3f69d3218b63e6c563f50a.webp" "@odata.id" => "https://replication.sparkapi.com/Version/2/Reso/OData/Property('20250910163636866463000000')/Media('20250913004506690140000000')" "MediaHTML" => null "MediaSize" => 456304 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/54/20250910163636866463000000/thumbnail-17188d9cdd3f69d3218b63e6c563f50a.webp" "Permission" => array:1 [ 0 => "Public" ] "MediaCategory" => "Photo" "LongDescription" => "" "PreferredPhotoYN" => false "ResourceRecordID" => "20250910163636866463000000" "ShortDescription" => "003_03carefreepoolview1" "ResourceRecordKey" => "20250910163636866463000000" "OriginatingSystemMediaKey" => "20250913004506690140000000" ] 3 => array:16 [ "Order" => 4 "MediaKey" => "20250913004509033690000000" "MediaURL" => "https://cdn.realtyfeed.com/cdn/54/20250910163636866463000000/c21bc01ae478e65dcfd9a95530f9d2f9.webp" "@odata.id" => "https://replication.sparkapi.com/Version/2/Reso/OData/Property('20250910163636866463000000')/Media('20250913004509033690000000')" "MediaHTML" => null "MediaSize" => 721785 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/54/20250910163636866463000000/thumbnail-c21bc01ae478e65dcfd9a95530f9d2f9.webp" "Permission" => array:1 [ 0 => "Public" ] "MediaCategory" => "Photo" "LongDescription" => "" "PreferredPhotoYN" => false "ResourceRecordID" => "20250910163636866463000000" "ShortDescription" => "004_04carefreeformalroom01b" "ResourceRecordKey" => "20250910163636866463000000" "OriginatingSystemMediaKey" => "20250913004509033690000000" ] 4 => array:16 [ "Order" => 5 "MediaKey" => "20250913004511359806000000" "MediaURL" => "https://cdn.realtyfeed.com/cdn/54/20250910163636866463000000/746683d3cc5b345bcbb44d27b0e73b12.webp" "@odata.id" => "https://replication.sparkapi.com/Version/2/Reso/OData/Property('20250910163636866463000000')/Media('20250913004511359806000000')" "MediaHTML" => null "MediaSize" => 781595 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/54/20250910163636866463000000/thumbnail-746683d3cc5b345bcbb44d27b0e73b12.webp" "Permission" => array:1 [ 0 => "Public" ] "MediaCategory" => "Photo" "LongDescription" => "" "PreferredPhotoYN" => false "ResourceRecordID" => "20250910163636866463000000" "ShortDescription" => "005_05carefreegreatroom01b" "ResourceRecordKey" => "20250910163636866463000000" "OriginatingSystemMediaKey" => "20250913004511359806000000" ] 5 => array:16 [ "Order" => 6 "MediaKey" => "20250913004513456897000000" "MediaURL" => "https://cdn.realtyfeed.com/cdn/54/20250910163636866463000000/0d3909e739c0c404b66b770aca8b3d02.webp" "@odata.id" => "https://replication.sparkapi.com/Version/2/Reso/OData/Property('20250910163636866463000000')/Media('20250913004513456897000000')" "MediaHTML" => null "MediaSize" => 744839 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/54/20250910163636866463000000/thumbnail-0d3909e739c0c404b66b770aca8b3d02.webp" "Permission" => array:1 [ 0 => "Public" ] "MediaCategory" => "Photo" "LongDescription" => "" "PreferredPhotoYN" => false "ResourceRecordID" => "20250910163636866463000000" "ShortDescription" => "006_05carefreegreatroom02" "ResourceRecordKey" => "20250910163636866463000000" "OriginatingSystemMediaKey" => "20250913004513456897000000" ] 6 => array:16 [ "Order" => 7 "MediaKey" => "20250913004515527533000000" "MediaURL" => "https://cdn.realtyfeed.com/cdn/54/20250910163636866463000000/aa146cf336a353d03a0a52fc7349ebaa.webp" "@odata.id" => "https://replication.sparkapi.com/Version/2/Reso/OData/Property('20250910163636866463000000')/Media('20250913004515527533000000')" "MediaHTML" => null "MediaSize" => 789873 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/54/20250910163636866463000000/thumbnail-aa146cf336a353d03a0a52fc7349ebaa.webp" "Permission" => array:1 [ 0 => "Public" ] "MediaCategory" => "Photo" "LongDescription" => "" "PreferredPhotoYN" => false "ResourceRecordID" => "20250910163636866463000000" "ShortDescription" => "007_06carefreeformalroom02b" "ResourceRecordKey" => "20250910163636866463000000" "OriginatingSystemMediaKey" => "20250913004515527533000000" ] 7 => array:16 [ "Order" => 8 "MediaKey" => "20250913004517671094000000" "MediaURL" => "https://cdn.realtyfeed.com/cdn/54/20250910163636866463000000/7d85af49ae56c9e6771ed4b2faee2ec4.webp" "@odata.id" => "https://replication.sparkapi.com/Version/2/Reso/OData/Property('20250910163636866463000000')/Media('20250913004517671094000000')" "MediaHTML" => null "MediaSize" => 469853 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/54/20250910163636866463000000/thumbnail-7d85af49ae56c9e6771ed4b2faee2ec4.webp" "Permission" => array:1 [ 0 => "Public" ] "MediaCategory" => "Photo" "LongDescription" => "" "PreferredPhotoYN" => false "ResourceRecordID" => "20250910163636866463000000" "ShortDescription" => "008_07carefreehallway" "ResourceRecordKey" => "20250910163636866463000000" "OriginatingSystemMediaKey" => "20250913004517671094000000" ] 8 => array:16 [ "Order" => 9 "MediaKey" => "20250913004519553310000000" "MediaURL" => "https://cdn.realtyfeed.com/cdn/54/20250910163636866463000000/c017723513c3bc949f4c34b311978719.webp" "@odata.id" => "https://replication.sparkapi.com/Version/2/Reso/OData/Property('20250910163636866463000000')/Media('20250913004519553310000000')" "MediaHTML" => null "MediaSize" => 871724 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/54/20250910163636866463000000/thumbnail-c017723513c3bc949f4c34b311978719.webp" "Permission" => array:1 [ 0 => "Public" ] "MediaCategory" => "Photo" "LongDescription" => "" "PreferredPhotoYN" => false "ResourceRecordID" => "20250910163636866463000000" "ShortDescription" => "009_09carefreebackfacade1" "ResourceRecordKey" => "20250910163636866463000000" "OriginatingSystemMediaKey" => "20250913004519553310000000" ] 9 => array:16 [ "Order" => 10 "MediaKey" => "20250913004521964521000000" "MediaURL" => "https://cdn.realtyfeed.com/cdn/54/20250910163636866463000000/4d5b8329c143367c3a68c9b8cac57062.webp" "@odata.id" => "https://replication.sparkapi.com/Version/2/Reso/OData/Property('20250910163636866463000000')/Media('20250913004521964521000000')" "MediaHTML" => null "MediaSize" => 766451 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/54/20250910163636866463000000/thumbnail-4d5b8329c143367c3a68c9b8cac57062.webp" "Permission" => array:1 [ 0 => "Public" ] "MediaCategory" => "Photo" "LongDescription" => "" "PreferredPhotoYN" => false "ResourceRecordID" => "20250910163636866463000000" "ShortDescription" => "010_10carefreeentrance" "ResourceRecordKey" => "20250910163636866463000000" "OriginatingSystemMediaKey" => "20250913004521964521000000" ] 10 => array:16 [ "Order" => 11 "MediaKey" => "20250913004523640574000000" "MediaURL" => "https://cdn.realtyfeed.com/cdn/54/20250910163636866463000000/15b317ebbcb7b87e0c55780e12d0be4c.webp" "@odata.id" => "https://replication.sparkapi.com/Version/2/Reso/OData/Property('20250910163636866463000000')/Media('20250913004523640574000000')" "MediaHTML" => null "MediaSize" => 425390 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/54/20250910163636866463000000/thumbnail-15b317ebbcb7b87e0c55780e12d0be4c.webp" "Permission" => array:1 [ 0 => "Public" ] "MediaCategory" => "Photo" "LongDescription" => "" "PreferredPhotoYN" => false "ResourceRecordID" => "20250910163636866463000000" "ShortDescription" => "011_001_Black Mt Sunset" "ResourceRecordKey" => "20250910163636866463000000" "OriginatingSystemMediaKey" => "20250913004523640574000000" ] 11 => array:16 [ "Order" => 12 "MediaKey" => "20250913004526411882000000" "MediaURL" => "https://cdn.realtyfeed.com/cdn/54/20250910163636866463000000/ced9e55ae9c1ec7e63f91e45f9f00f1a.webp" "@odata.id" => "https://replication.sparkapi.com/Version/2/Reso/OData/Property('20250910163636866463000000')/Media('20250913004526411882000000')" "MediaHTML" => null "MediaSize" => 1144564 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/54/20250910163636866463000000/thumbnail-ced9e55ae9c1ec7e63f91e45f9f00f1a.webp" "Permission" => array:1 [ 0 => "Public" ] "MediaCategory" => "Photo" "LongDescription" => "" "PreferredPhotoYN" => false "ResourceRecordID" => "20250910163636866463000000" "ShortDescription" => "012_002_Black Mountain Valley Views" "ResourceRecordKey" => "20250910163636866463000000" "OriginatingSystemMediaKey" => "20250913004526411882000000" ] 12 => array:16 [ "Order" => 13 "MediaKey" => "20250913004529276731000000" "MediaURL" => "https://cdn.realtyfeed.com/cdn/54/20250910163636866463000000/c9cc1f26d92d232e534a5daefd18926b.webp" "@odata.id" => "https://replication.sparkapi.com/Version/2/Reso/OData/Property('20250910163636866463000000')/Media('20250913004529276731000000')" "MediaHTML" => null "MediaSize" => 981444 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/54/20250910163636866463000000/thumbnail-c9cc1f26d92d232e534a5daefd18926b.webp" "Permission" => array:1 [ 0 => "Public" ] "MediaCategory" => "Photo" "LongDescription" => "" "PreferredPhotoYN" => false "ResourceRecordID" => "20250910163636866463000000" "ShortDescription" => "013_003_Golf Views" "ResourceRecordKey" => "20250910163636866463000000" "OriginatingSystemMediaKey" => "20250913004529276731000000" ] 13 => array:16 [ "Order" => 14 "MediaKey" => "20250913004532254482000000" "MediaURL" => "https://cdn.realtyfeed.com/cdn/54/20250910163636866463000000/d5605053ac1f6c2595111627ddd15ead.webp" "@odata.id" => "https://replication.sparkapi.com/Version/2/Reso/OData/Property('20250910163636866463000000')/Media('20250913004532254482000000')" "MediaHTML" => null "MediaSize" => 759643 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/54/20250910163636866463000000/thumbnail-d5605053ac1f6c2595111627ddd15ead.webp" "Permission" => array:1 [ 0 => "Public" ] "MediaCategory" => "Photo" "LongDescription" => "" "PreferredPhotoYN" => false "ResourceRecordID" => "20250910163636866463000000" "ShortDescription" => "014_005_Sunset Colors Over Valley Fl" "ResourceRecordKey" => "20250910163636866463000000" "OriginatingSystemMediaKey" => "20250913004532254482000000" ] 14 => array:16 [ "Order" => 15 "MediaKey" => "20250913004534547224000000" "MediaURL" => "https://cdn.realtyfeed.com/cdn/54/20250910163636866463000000/ed548c6ce60e029645bc14ecb50c974c.webp" "@odata.id" => "https://replication.sparkapi.com/Version/2/Reso/OData/Property('20250910163636866463000000')/Media('20250913004534547224000000')" "MediaHTML" => null "MediaSize" => 410164 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/54/20250910163636866463000000/thumbnail-ed548c6ce60e029645bc14ecb50c974c.webp" "Permission" => array:1 [ 0 => "Public" ] "MediaCategory" => "Photo" "LongDescription" => "" "PreferredPhotoYN" => false "ResourceRecordID" => "20250910163636866463000000" "ShortDescription" => "015_008_Pinnacle Peak and Golf Views" "ResourceRecordKey" => "20250910163636866463000000" "OriginatingSystemMediaKey" => "20250913004534547224000000" ] 15 => array:16 [ "Order" => 16 "MediaKey" => "20250913004536668400000000" "MediaURL" => "https://cdn.realtyfeed.com/cdn/54/20250910163636866463000000/2dcf9c6e21a58bee347b0a5c408751b8.webp" "@odata.id" => "https://replication.sparkapi.com/Version/2/Reso/OData/Property('20250910163636866463000000')/Media('20250913004536668400000000')" "MediaHTML" => null "MediaSize" => 180700 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/54/20250910163636866463000000/thumbnail-2dcf9c6e21a58bee347b0a5c408751b8.webp" "Permission" => array:1 [ 0 => "Public" ] "MediaCategory" => "Photo" "LongDescription" => "" "PreferredPhotoYN" => false "ResourceRecordID" => "20250910163636866463000000" "ShortDescription" => "016_009_City Lights and Twilight" "ResourceRecordKey" => "20250910163636866463000000" "OriginatingSystemMediaKey" => "20250913004536668400000000" ] ] +"DaysOnMarket": 38 +"ID": "45939" }
38824 N CHARLES BLAIR MACDONALD Road, Scottsdale, AZ 85262
Active
To Be Built
38824 N CHARLES BLAIR MACDONALD Road, Scottsdale, AZ 85262
38824 N CHARLES BLAIR MACDONALD Road, Scottsdale, AZ 85262
Description
Plans underway for this spectacular home designed by Kontexture and to be built by Silvercreek Development. Situated on a ridgetop lot in North Scottsdale guard gated community of Carefree Ranch Estates, this 8,000 square foot home features the latest and greatest in modern desert living with an emphasis on biophilic design. 5 bedrooms including guest house, plus office, and private master bedroom lounge. Spa like dual master bath with free standing tub, oversized shower with views of Desert Mountain Golf course and Pinnacle Peakand dual walk-in closets. HUGE great room with chef’s kitchen, butler’s pantry, top of line appliances, all spilling to the outdoors via walls of glass for indoor and outdoor entertaining needs. The outdoors includes 2,000+SF elevated terrace with outdoor kitchen,
Address
Open on Google Maps- Address 38824 N CHARLES BLAIR MACDONALD Road
- City Scottsdale
- State/county AZ
- Zip/Postal Code 85262
- Area LONE MOUNTAIN
Details
Updated on April 14, 2026 at 2:01 am- Property ID: 6919131
- Price: $8,999,000
- Land Area: 4.36 Acres
- Bedrooms: 5
- Bathrooms: 7
- Garages: 4.0
- Garage Size: x x
- Year Built: 2025
- Property Type: Single Family Residence, Residential
- Property Status: Active
- MLS#: 6919131
Additional details
- Listing Terms: Cash,Conventional
- Association Fee: 2977.92
- Roof: Other,Foam
- Sewer: Public Sewer
- Cooling: Central Air,Ceiling Fan(s)
- Heating: Natural Gas
- County: Maricopa
- Property Type: Residential
- Pool: Heated
- Parking: Direct Access,Separate Strge Area
- Elementary School: Black Mountain Elementary School
- Middle School: Sonoran Trails Middle School
- High School: Cactus Shadows High School
- Community Features: Gated
- Architectural Style: Contemporary
360° Virtual Tour
Mortgage Calculator
Monthly
- Down Payment
- Loan Amount
- Monthly Mortgage Payment
- Property Tax
- Home Insurance
- PMI