Compare listings
ComparePlease enter your username or email address. You will receive a link to create a new password via email.
array:2 [ "RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=9&$skip=45&$filter=(StandardStatus ne 'Closed') and (ExteriorFeatures eq 'Built-in Barbecue' OR InteriorFeatures eq 'Built-in Barbecue' OR Appliances eq 'Built-in Barbecue')&$expand=Media&$count=true" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#19162 +items: array:9 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#19156 +post_id: "57519" +post_author: 1 +"ListingKey": "20251031175928231696000000" +"ListingId": "6941205" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-05-21T06:33:13Z" +"RFModificationTimestamp": "2026-05-21T06:35:05Z" +"ListPrice": 1999995.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 1 +"BedroomsTotal": 5.0 +"LotSizeArea": 11304.0 +"LivingArea": 3341.0 +"BuildingAreaTotal": 0 +"City": "Phoenix" +"PostalCode": "85014" +"UnparsedAddress": "1413 E San Miguel Avenue, Phoenix, Arizona 85014" +"Coordinates": array:2 [ …2] +"Latitude": 33.519394 +"Longitude": -112.051079 +"YearBuilt": 1954 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Traci Tartaglio" +"ListOfficeName": "Home Smart" +"ListAgentMlsId": "tt248" +"ListOfficeMlsId": "cril12" +"OriginatingSystemName": "ARMLS" +"PublicRemarks": "Luxury meets comfort in this gorgeous Uptown Phoenix FULLY remodeled and enlarged custom residence with NO HOA on highly desired San Miguel Avenue. Just one mile west of the legendary Biltmore, this 1954 classic sits on an irrigated .25+ acre in one of Uptown's most lush enclaves. The home has been lovingly expanded to include an all NEW Casita guest house, primary retreat with its own beverage center & a chef's gourmet kitchen with a stunning island and six burner gas stove. Special features include an amphitheater style covered patio, natural gas firepit, SONOS sound entertainment and active Starlink internet. This extensive remodel includes all new HVAC, siding, windows, plumbing, roof, electrical system, cabinetry, surfaces, & landscape. Nearby are some of the best education in the state including Xavier and Brophy College Preps and Madison schools. Minutes to downtown Phoenix, Sky Harbor and an easy walk to restaurants, shops, & boutiques. Did we mention, NO HOA!" +"AccessibilityFeatures": array:9 [ …9] +"Appliances": "Refrigerator,Built-in Microwave,Dishwasher,Disposal,Gas Range,Gas Oven" +"ApprovalStatus": true +"ArchitecturalStyle": "Mid-Century Modern,Ranch" +"AssociationFeeIncludes": array:1 [ …1] +"BathroomsFull": 3 +"BedroomsPossible": 5 +"BuilderName": "Schott Development" +"BuildingAreaSource": "Architect" +"CommonWalls": array:1 [ …1] +"CommunityFeatures": "Near Bus Stop" +"ConstructionMaterials": array:6 [ …6] +"Cooling": "HVAC SEER Rating,Gas,Central Air,Ceiling Fan(s),ENERGY STAR Qualified Equipment,Programmable Thmstat" +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Maricopa" +"CoveredSpaces": "3.0" +"CreationDate": "2026-01-27T01:19:28.838639+00:00" +"CrossStreet": "16th Street / Missouri" +"CurrentFinancing": array:2 [ …2] +"Disclosures": array:2 [ …2] +"DocumentsChangeTimestamp": "2026-03-16T02:09:41Z" +"DocumentsCount": 1 +"ElementarySchool": "Madison Rose Lane School" +"ElementarySchoolDistrict": "Madison Elementary District" +"ExteriorFeatures": "Rain Gutters,Storage,Built-in Barbecue" +"Fencing": array:2 [ …2] +"Flooring": "Carpet,Vinyl,Tile,Wood" +"FoundationDetails": array:2 [ …2] +"GarageSpaces": "3.0" +"Heating": "Forced Air,ENERGY STAR Qualified Equipment,Natural Gas,Ceiling" +"HeatingYN": true +"HighSchool": "North High School" +"HighSchoolDistrict": "Phoenix Union High School District" +"InteriorFeatures": "Non-laminate Counter,Quartz Countertops,High Speed Internet,Granite Counters,Double Vanity,Eat-in Kitchen,No Interior Steps,Vaulted Ceiling(s),Kitchen Island,Pantry,Full Bth Master Bdrm" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:3 [ …3] +"ListAgentAOR": "Phoenix REALTORS" +"ListAgentFirstName": "Traci" +"ListAgentKey": "20150115201206851408000000" +"ListAgentLastName": "Tartaglio" +"ListAgentPreferredPhone": "480-206-5372" +"ListOfficeEmail": "rlarue@hsmove.com" +"ListOfficeKey": "20110225185116727686000000" +"ListOfficePhone": "602-230-7600" +"ListOfficeURL": "http://www.homesmartmove.com" +"ListingContractDate": "2025-10-31" +"ListingTerms": "Cash,Conventional,FHA,VA Loan" +"LivingAreaSource": "Architect" +"LotFeatures": array:9 [ …9] +"LotSizeAcres": 0.26 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 11304.0 +"MajorChangeTimestamp": "2026-04-30T23:48:55Z" +"MajorChangeType": "Price Reduced" +"MiddleOrJuniorSchool": "Madison #1 Elementary School" +"MlsStatus": "Active" +"OnMarketDate": "2025-11-30" +"OpenParkingSpaces": "2.0" +"OriginalEntryTimestamp": "2025-10-31T20:55:37Z" +"OriginatingSystemID": "M00000048" +"OriginatingSystemKey": "20251031175928231696000000" +"OtherStructures": array:2 [ …2] +"Ownership": "Fee Simple" +"ParcelNumber": "162-02-040" +"ParkingFeatures": "Attached Garage,Tandem Garage,Garage Door Opener,Extended Length Garage,Electric Vehicle Charging Station(s)" +"PatioAndPorchFeatures": array:2 [ …2] +"PhotosChangeTimestamp": "2026-05-17T18:48:24Z" +"PhotosCount": 43 +"Possession": array:1 [ …1] +"PossibleUse": array:1 [ …1] +"PostalCity": "Phoenix" +"PostalCodePlus4": "2423" +"PriceChangeTimestamp": "2026-04-30T23:48:55Z" +"PublicSurveyRange": "3E" +"PublicSurveySection": "16" +"RoadResponsibility": array:1 [ …1] +"RoadSurfaceType": array:1 [ …1] +"Roof": "Composition" +"Sewer": "Public Sewer" +"SourceSystemID": "M00000048" +"SourceSystemKey": "20251031175928231696000000" +"SourceSystemName": "Arizona Regional Multiple Listing Service (ARMLS)" +"SpaFeatures": array:1 [ …1] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "AZ" +"StatusChangeTimestamp": "2026-01-27T01:15:01Z" +"StoriesTotal": "1" +"StreetDirPrefix": "E" +"StreetName": "SAN MIGUEL" +"StreetNumber": "1413" +"StreetNumberNumeric": "1413" +"StreetSuffix": "Avenue" +"SubdivisionName": "NIXON SQUARE 2" +"TaxAnnualAmount": "4383.0" +"TaxBookNumber": "162.00" +"TaxLegalDescription": "LOT 18 NIXON SQUARE 2 MCR 005512" +"TaxLot": "18" +"TaxMapNumber": "2.00" +"TaxYear": "2024" +"Township": "2N" +"Utilities": "Natural Gas Connected" +"WaterSource": array:1 [ …1] +"WindowFeatures": array:5 [ …5] +"Spa_co_None14": true +"Cooling_co_Gas7": true +"Flooring_co_Tile": true +"Flooring_co_Wood": true +"Utilities_co_APS": true +"Fencing_co_Block2": true +"Flooring_co_Vinyl": true +"Flooring_co_Carpet": true +"Heating_co_Ceiling": true +"Laundry_co_Inside2": true +"Irrigation_co_Flood": true +"Architecture_co_Ranch": true +"Construction_co_Block": true +"Architect_co_Architect": "Adam Rainwater" +"Legal_sp_Info_co_Range": "3E" +"Skirt@Core.Permissions": "None" +"Fencing_co_Back_sp_Yard": true +"Irrigation_co_Sprinkler": true +"Levels@Core.Permissions": "None" +"New_sp_Financing_co_VA5": true +"Utilities_co_SW_sp_Gas3": true +"Zoning@Core.Permissions": "None" +"CapRate@Core.Permissions": "None" +"Dining_sp_Area_co_Formal": true +"Heating_co_Forced_sp_Air": true +"New_sp_Financing_co_FHA5": true +"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": "16" +"New_sp_Financing_co_Cash2": true +"ParkName@Core.Permissions": "None" +"Basement_co_Basement_sp_YN": "N" +"Furnished@Core.Permissions": "None" +"OwnerName@Core.Permissions": "None" +"OwnerPays@Core.Permissions": "None" +"Roofing_co_Comp_sp_Shingle": true +"AccessCode@Core.Permissions": "None" +"CurrentUse@Core.Permissions": "None" +"Disclaimer@Core.Permissions": "None" +"OwnerPhone@Core.Permissions": "None" +"Topography@Core.Permissions": "None" +"Vegetation@Core.Permissions": "None" +"Assoc_sp_RulesInfo_co_None17": 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" +"Services_co_City_sp_Services": true +"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_Grass_sp_Front": 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" +"Window_sp_Features_co_Screens": true +"BuyerAgentAOR@Core.Permissions": "None" +"BuyerAgentFax@Core.Permissions": "None" +"BuyerAgentURL@Core.Permissions": "None" +"BuyerTeamName@Core.Permissions": "None" +"Foundation_sp_Details_co_Slab2": 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_Storage": true +"Kitchen_sp_Features_co_Disposal": true +"ListAgentEmail@Core.Permissions": "None" +"Other_sp_Rooms_co_Great_sp_Room": true +"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 Agency" +"CopyrightNotice@Core.Permissions": "None" +"ElectricExpense@Core.Permissions": "None" +"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": "N" +"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" +"Cooling_co_HVAC_sp_SEER_sp_Rating": 18 +"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" +"CoBuyerOfficeName@Core.Permissions": "None" +"CoListOfficeEmail@Core.Permissions": "None" +"CoListOfficePhone@Core.Permissions": "None" +"Construction_co_Blown_sp_Cellulose": true +"Cooling_co_Programmable_sp_Thmstat": true +"DevelopmentStatus@Core.Permissions": "None" +"ExistingLeaseType@Core.Permissions": "None" +"Foundation_sp_Details_co_Permanent": true +"Kitchen_sp_Features_co_Gas_sp_Oven": true +"Landscaping_co_GravelStone_sp_Back": true +"Landscaping_co_Irrigation_sp_Front": true +"Location_sp_Tax_sp_Legal_co_Taxes2": 4383.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" +"WaterSewerExpense@Core.Permissions": "None" +"Window_sp_Features_co_Dual_sp_Pane": true +"BuyerAgentLastName@Core.Permissions": "None" +"CoBuyerOfficeEmail@Core.Permissions": "None" +"CoBuyerOfficeMlsId@Core.Permissions": "None" +"CoBuyerOfficePhone@Core.Permissions": "None" +"Kitchen_sp_Features_co_Gas_sp_Range": true +"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" +"Possession_co_Close_sp_of_sp_Escrow": true +"Road_sp_Surface_sp_Type_co_Asphalt2": 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" +"Laundry_co_WshrDry_sp_HookUp_sp_Only": true +"ListAgentMiddleName@Core.Permissions": "None" +"Sewer_co_Sewer_sp__hyphen__sp_Public": true +"ShowingInstructions@Core.Permissions": "None" +"Window_sp_Features_co_Vinyl_sp_Frame": true +"AssociationAmenities@Core.Permissions": "None" +"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" +"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" +"DistanceToGasComments@Core.Permissions": "None" +"ListAgentStateLicense@Core.Permissions": "None" +"ListAgentVoiceMailExt@Core.Permissions": "None" +"Technology_co_Sat_sp_Dish_sp_TV_sp_Lsd": true +"Unit_sp_Style_co_No_sp_Common_sp_Walls": 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" +"Disclosures_co_Seller_sp_Discl_sp_Avail": true +"Existing_sp_1st_sp_Loan_co_Conventional": true +"Exterior_sp_Features_co_Rain_sp_Gutters": true +"Items_sp_Updated_co_Roof_sp_PartialFull": "Full" +"Laundry_co_220_sp_V_sp_Dryer_sp_Hookup2": true +"ListAgentTollFreePhone@Core.Permissions": "None" +"Parking_sp_Features_co_Tandem_sp_Garage": true +"Technology_co_High_sp_Speed_sp_Internet": true +"Association_sp_Fee_sp_Incl_co_No_sp_Fees": true +"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" +"Items_sp_Updated_co_Floor_sp_PartialFull": "Full" +"Items_sp_Updated_co_Plmbg_sp_PartialFull": "Full" +"Kitchen_sp_Features_co_Kitchen_sp_Island": true +"ListAgentOfficePhoneExt@Core.Permissions": "None" +"Road_sp_Access_sp_Type_co_City_sp_Street": true +"Utilities_co_Natural_sp_Gas_sp_Connected": true +"Add_squote_l_sp_Property_sp_Use_co_None15": true +"BuyerAgentOfficePhoneExt@Core.Permissions": "None" +"CoListAgentTollFreePhone@Core.Permissions": "None" +"Construction_co_Frame_sp__hyphen__sp_Wood": true +"ContractStatusChangeDate@Core.Permissions": "None" +"Items_sp_Updated_co_HtCool_sp_PartialFull": "Full" +"Items_sp_Updated_co_Roof_sp_Yr_sp_Updated": "2025" +"Items_sp_Updated_co_Wiring_sp_PartialFull": "Full" +"Landscaping_co_Synthetic_sp_Grass_sp_Back": true +"OperatingExpenseIncludes@Core.Permissions": "None" +"Parking_sp_Features_co_Attached_sp_Garage": true +"Plumbing_co_Gas_sp_Hot_sp_Water_sp_Heater": true +"Special_sp_Listing_sp_Cond_co_OwnerAgent4": true +"CoListAgentOfficePhoneExt@Core.Permissions": "None" +"Cooling_co_Ceiling_sp_Fan_lparen_s_rparen_": true +"Dining_sp_Area_co_Eat_hyphen_in_sp_Kitchen": true +"Items_sp_Updated_co_Floor_sp_Yr_sp_Updated": "2025" +"Items_sp_Updated_co_Kitchen_sp_PartialFull": "Full" +"Items_sp_Updated_co_Plmbg_sp_Yr_sp_Updated": "2025" +"Kitchen_sp_Features_co_Granite_sp_Counters": true +"NumberOfFullTimeEmployees@Core.Permissions": "None" +"NumberOfPartTimeEmployees@Core.Permissions": "None" +"Showing_sp_Notification_sp_Methods_co_Text": true +"Technology_co_Sat_sp_Dish_sp_Intrnt_sp_Lsd": true +"Unit_sp_Style_co_All_sp_on_sp_One_sp_Level": true +"DistanceToElectricComments@Core.Permissions": "None" +"Items_sp_Updated_co_HtCool_sp_Yr_sp_Updated": "2025" +"Items_sp_Updated_co_Wiring_sp_Yr_sp_Updated": "2025" +"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 +"Architecture_co_Mid_hyphen_Century_sp_Modern": true +"BuyerAgentPreferredPhoneExt@Core.Permissions": "None" +"Community_sp_Features_co_Near_sp_Bus_sp_Stop": true +"General_sp_Property_sp_Description_co_Horses": "N" +"Items_sp_Updated_co_Kitchen_sp_Yr_sp_Updated": "2025" +"Kitchen_sp_Features_co_Quartz_sp_Countertops": true +"Landscaping_co_Auto_sp_Timer_sp_H2O_sp_Front": true +"Landscaping_co_Yrd_sp_Wtring_sp_Sys_sp_Front": true +"Plumbing_co_Engy_sp_Star_sp_Ht_sp_Wtr_sp_Htr": true +"CoListAgentPreferredPhoneExt@Core.Permissions": "None" +"Items_sp_Updated_co_Rm_sp_Adtn_sp_PartialFull": "Full" +"MiddleOrJuniorSchoolDistrict@Core.Permissions": "None" +"Other_sp_Structures_co_Shed_lparen_s_rparen_2": true +"Accessibility_sp_Feat_co_Mltpl_sp_EntriesExits": true +"Exterior_sp_Features_co_Built_hyphen_in_sp_BBQ": true +"Parking_sp_Spaces_co_Slab_sp_Parking_sp_Spaces": 2.0 +"ProfessionalManagementExpense@Core.Permissions": "None" +"DistanceToPhoneServiceComments@Core.Permissions": "None" +"General_sp_Property_sp_Description_co_PriceSqFt": 598.62 +"Interior_sp_Features_co_No_sp_Interior_sp_Steps": true +"Items_sp_Updated_co_Rm_sp_Adtn_sp_Yr_sp_Updated": "2025" +"Master_sp_Bathroom_co_Private_sp_Toilet_sp_Room": true +"Parking_sp_Features_co_Garage_sp_Door_sp_Opener": true +"Parking_sp_Spaces_co_Total_sp_Covered_sp_Spaces": 3.0 +"Separate_sp_DenOffice_co_Sep_sp_DenOffice_sp_YN": "N" +"TaxOtherAnnualAssessmentAmount@Core.Permissions": "None" +"Additional_sp_Bedroom_co_2_sp_Master_sp_Bedrooms": true +"Location_sp_Tax_sp_Legal_co_Tax_sp_Municipality3": "Phoenix" +"Accessibility_sp_Feat_co_Bath_sp_Lever_sp_Faucets": true +"Accessibility_sp_Feat_co_Bath_sp_Raised_sp_Toilet": true +"Accessibility_sp_Feat_co_Hallways_sp_36in_sp_Wide": true +"Accessibility_sp_Feat_co_HardLow_sp_Nap_sp_Floors": true +"Association_sp_Fees_co_Land_sp_Lease_sp_Fee_sp_YN": "N" +"Interior_sp_Features_co_Skylight_lparen_s_rparen_": true +"Lockbox_sp_Type_co_Supra_sp__lparen_ARMLS_rparen_": true +"Plumbing_co_Gas_sp_Hot_sp_Wtr_sp__2013__sp_Tnklss": true +"Property_sp_Description_co_NorthSouth_sp_Exposure": true +"Const_sp__hyphen__sp_Finish_co_Low_sp_VOC_sp_Paint": true +"Exterior_sp_Features_co_Separate_sp_Guest_sp_House": true +"Accessibility_sp_Feat_co_Bath_sp_Insulated_sp_Pipes": true +"Association_sp_Fees_co_Ttl_sp_Mthly_sp_Fee_sp_Equiv": 0.0 +"Cooling_co_ENERGY_sp_STAR_sp_Qualified_sp_Equipment": true +"General_sp_Property_sp_Description_co_Flood_sp_Zone": "No" +"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 +"Parking_sp_Features_co_Extended_sp_Length_sp_Garage": true +"Additional_sp_Bedroom_co_Separate_sp_Bedroom_sp_Exit": true +"Existing_sp_1st_sp_Loan_sp_Terms_co_Non_sp_Assumable": true +"General_sp_Property_sp_Description_co_Approx_sp_SQFT": 3341.0 +"General_sp_Property_sp_Description_co_High_sp_School": "North High School" +"Heating_co_ENERGY_sp_STAR_sp_Qualified_sp_Equipment2": true +"Road_sp_Responsibility_co_City_sp_Maintained_sp_Road": true +"Accessibility_sp_Feat_co_Bath_sp_Scald_sp_Ctrl_sp_Fct": true +"General_sp_Property_sp_Description_co_Builder_sp_Name": "Schott Development" +"Kitchen_sp_Features_co_Non_hyphen_laminate_sp_Counter": true +"General_sp_Property_sp_Description_co_Fireplace_sp_YN2": "No" +"General_sp_Property_sp_Description_co_Full_sp_Bathroom2": 3 +"Const_sp__hyphen__sp_Finish_co_Board_sp_Batten_sp_Siding": true +"General_sp_Property_sp_Description_co_Dwelling_sp_Styles": "Detached" +"General_sp_Property_sp_Description_co_Half_sp_Bathrooms2": 1 +"Items_sp_Updated_co_Bath_lparen_s_rparen__sp_PartialFull": "Full" +"Showing_sp_Notification_sp_Methods_co_Showing_sp_Service": "Aligned Showings" +"Accessibility_sp_Feat_co_Bath_sp_Roll_hyphen_In_sp_Shower": true +"Exterior_sp_Features_co_Covered_sp_Patio_lparen_s_rparen_": true +"General_sp_Property_sp_Description_co_Elementary_sp_School": "Madison Rose Lane School" +"General_sp_Property_sp_Description_co_Jr_sp_High_sp_School": "Madison #1 Elementary School" +"Items_sp_Updated_co_Bath_lparen_s_rparen__sp_Yr_sp_Updated": "2025" +"General_sp_Property_sp_Description_co_Approx_sp_Lot_sp_SqFt": 11304.0 +"Interior_sp_Features_co_Vaulted_sp_Ceiling_lparen_s_rparen_": true +"Construction_co_Ducts_sp_Professionally_sp_Air_hyphen_Sealed": true +"General_sp_Property_sp_Description_co_Guest_sp_House_sp_SqFt": 787.0 +"General_sp_Property_sp_Description_co_Private_sp_Pool_sp_YN2": "No" +"Window_sp_Features_co_ENERGY_sp_STAR_sp_Qualified_sp_Windows": true +"General_sp_Property_sp_Description_co_Approx_sp_Lot_sp_Acres2": 0.26 +"General_sp_Property_sp_Description_co_Community_sp_Pool_sp_YN2": "No" +"Location_sp_Tax_sp_Legal_co_Assessor_squote_s_sp_Map_sp__pound_3": 2.0 +"General_sp_Property_sp_Description_co_High_sp_School_sp_District2": "Phoenix Union High School District" +"Kitchen_sp_Features_co_Engy_sp_Star_sp__lparen_See_sp_Rmks_rparen_": true +"Location_sp_Tax_sp_Legal_co_Assessor_squote_s_sp_Parcel_sp__pound_3": 40.0 +"Accessibility_sp_Feat_co_Accessible_sp_Door_sp__2013__sp_32in_sp_Wide": true +"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": "Madison Elementary District" +"General_sp_Property_sp_Description_co__pound__sp_of_sp_Interior_sp_Levels": 1 +"General_sp_Property_sp_Description_co_Lead_sp_Based_sp_Hazard_sp_Disclosure": "Yes" +"Location_sp_Tax_sp_Legal_co_Legal_sp_Description_sp__lparen_Abbrev_rparen_3": "LOT 18 NIXON SQUARE 2 MCR 005512" +"Parking_sp_Features_co_Electric_sp_Vehicle_sp_Charging_sp_Station_lparen_s_rparen_": true +"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('20251031175928231696000000')" +"provider_name": "ARMLS" +"SourceSystemPlatformID": "T00000052" +"SourceSystemPlatformName": "Flexmls" +"FloorPlansChangeTimestamp": "2025-11-06T22:32:40Z" +"OriginatingSystemPlatformID": "T00000052" +"OriginatingSystemPlatformName": "Flexmls" +"Media": array:43 [ …43] +"DaysOnMarket": 0 +"ID": "57519" } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#19158 +post_id: "82711" +post_author: 1 +"ListingKey": "20260115221906734765000000" +"ListingId": "6973083" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-05-21T06:32:59Z" +"RFModificationTimestamp": "2026-05-21T06:35:05Z" +"ListPrice": 3995000.0 +"BathroomsTotalInteger": 5.0 +"BathroomsHalf": 1 +"BedroomsTotal": 4.0 +"LotSizeArea": 109782.0 +"LivingArea": 4876.0 +"BuildingAreaTotal": 0 +"City": "Scottsdale" +"PostalCode": "85255" +"UnparsedAddress": "11704 E Diamond Cholla Drive, Scottsdale, Arizona 85255" +"Coordinates": array:2 [ …2] +"Latitude": 33.726198 +"Longitude": -111.828181 +"YearBuilt": 2017 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Andrew Ricks" +"ListOfficeName": "eXp Realty" +"ListAgentMlsId": "ar36089" +"ListOfficeMlsId": "xpre18" +"OriginatingSystemName": "ARMLS" +"PublicRemarks": """ Your approach begins through a private gated courtyard where Pinnacle Peak commands the horizon. The grand entrance—marked by a bubbling water feature and French limestone appointments—leads to a custom 10-foot entry door that signals what lies beyond.\r\n \r\n Step inside to discover a great room defined by exposed timber architecture and refined contemporary finishes. But it's the view that captures you immediately. Floor-to-ceiling glass pocket doors dissolve the boundary between interior and exterior, framing Pinnacle Peak and Troon Mountain against a backdrop of mature desert landscaping that ensures complete privacy.\r\n \r\n The kitchen serves as the home's culinary centerpiece. Wolf appliances meet an oversized island designed for both the serious cook and the gracious host. A thoughtfully positioned wet bar connects kitchen, great room, and patio complete with dual wine refrigeration for your collection.\n \n The primary suite offers the space and privacy of a dedicated wing. Wake to mountain vistas. Breathe in the generous proportions. Two additional guest suites, each with en-suite baths and covered patios, provide your visitors with their own mountain views and private outdoor spaces. The detached casita elevates the guest experience further a complete residence unto itself with full living area, bedroom, bath, and patio. True separation. True hospitality.\n \n Set on 2.52 acres within the exclusive 12-home enclave of Collina E Vista, the location speaks for itself. Troon Country Club, Troon North, Estancia Country Club, Scottsdale National, and Desert Highlands are all within immediate reach. The three-car garage and private courtyard will satisfy the most discerning automotive enthusiast.\n \n Designed by Smith Design Associates and executed by Pat Brady Construction, this residence represents turn-key luxury at the highest level.\n \n This is move-in ready refinement in North Scottsdale's most coveted address. """ +"Appliances": "Reverse Osmosis,Refrigerator,Built-in Microwave,Dishwasher,Gas Range,Gas Cooktop,Built-In Electric Oven" +"ApprovalStatus": true +"AssociationFee": "1050.0" +"AssociationFeeFrequency": "Quarterly" +"AssociationFeeIncludes": array:1 [ …1] +"AssociationName": "Collina Vista HOA" +"AssociationPhone": "480-585-7587" +"AssociationYN": true +"BathroomsFull": 4 +"BedroomsPossible": 5 +"BuilderName": "Pat Brady Construction" +"BuildingAreaSource": "Assessor" +"ConstructionMaterials": array:4 [ …4] +"Cooling": "Central Air,Ceiling Fan(s),Programmable Thmstat" +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Maricopa" +"CoveredSpaces": "3.0" +"CreationDate": "2026-01-30T08:50:02.632324+00:00" +"CrossStreet": "Alma School and Jomax Rd" +"Directions": "North on Alma School from Happy Valley Road, East on Jomax, South on 116th Street, Second left to Collina Vista Gate." +"Disclosures": array:2 [ …2] +"DocumentsChangeTimestamp": "2026-01-23T03:39:37Z" +"ElementarySchool": "Desert Sun Academy" +"ElementarySchoolDistrict": "Cave Creek Unified District" +"ExteriorFeatures": "Built-in Barbecue" +"Fencing": array:3 [ …3] +"FireplaceYN": true +"FireplacesTotal": "2" +"GarageSpaces": "3.0" +"Heating": "Natural Gas" +"HeatingYN": true +"HighSchool": "Cactus Shadows High School" +"HighSchoolDistrict": "Cave Creek Unified District" +"InteriorFeatures": "Walk-in Pantry,Granite Counters,Double Vanity,Eat-in Kitchen,Breakfast Bar,Full Bth Master Bdrm,Separate Shwr & Tub,Tub with Jets" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:2 [ …2] +"ListAgentAOR": "We SERV" +"ListAgentFirstName": "Andrew" +"ListAgentKey": "20240118163816776479000000" +"ListAgentLastName": "Ricks" +"ListAgentPreferredPhone": "404-824-0697" +"ListAgentURL": "www.soldbyricks.com" +"ListOfficeEmail": "AZ.broker@exprealty.net" +"ListOfficeKey": "20200309140011713761000000" +"ListOfficePhone": "888-897-7821" +"ListingContractDate": "2026-01-22" +"ListingTerms": "Cash,Conventional,VA Loan" +"LivingAreaSource": "Assessor" +"LotFeatures": array:6 [ …6] +"LotSizeAcres": 2.52 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 109782.0 +"MajorChangeTimestamp": "2026-04-24T16:10:44Z" +"MajorChangeType": "Price Reduced" +"MiddleOrJuniorSchool": "Sonoran Trails Middle School" +"MlsStatus": "Active" +"OnMarketDate": "2026-01-30" +"OpenParkingSpaces": "4.0" +"OriginalEntryTimestamp": "2026-01-23T03:39:36Z" +"OriginatingSystemID": "M00000048" +"OriginatingSystemKey": "20260115221906734765000000" +"Ownership": "Fee Simple" +"ParcelNumber": "217-04-507" +"PhotosChangeTimestamp": "2026-01-30T08:15:19Z" +"PhotosCount": 39 +"PoolFeatures": "Outdoor,Play Pool,Heated" +"PoolPrivateYN": true +"Possession": array:1 [ …1] +"PostalCity": "Scottsdale" +"PostalCodePlus4": "6378" +"PriceChangeTimestamp": "2026-04-24T16:10:44Z" +"PublicSurveyRange": "5E" +"PublicSurveySection": "3" +"RoadResponsibility": array:1 [ …1] +"RoadSurfaceType": array:1 [ …1] +"Roof": "Tile" +"Sewer": "Public Sewer" +"SourceSystemID": "M00000048" +"SourceSystemKey": "20260115221906734765000000" +"SourceSystemName": "Arizona Regional Multiple Listing Service (ARMLS)" +"SpaFeatures": array:2 [ …2] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "AZ" +"StatusChangeTimestamp": "2026-01-30T08:15:19Z" +"StoriesTotal": "1" +"StreetDirPrefix": "E" +"StreetName": "DIAMOND CHOLLA" +"StreetNumber": "11704" +"StreetNumberNumeric": "11704" +"StreetSuffix": "Drive" +"SubdivisionName": "COLLINA E VISTA" +"TaxAnnualAmount": "8796.0" +"TaxBookNumber": "217.00" +"TaxLegalDescription": "LOT 3 COLLINA E VISTA MCR" +"TaxLot": "3" +"TaxMapNumber": "4.00" +"TaxYear": "2025" +"Township": "4N" +"WaterSource": array:1 [ …1] +"Spa_co_Heated": true +"Spa_co_Private": true +"Roofing_co_Tile2": true +"Utilities_co_APS": true +"Fencing_co_Block2": true +"Fencing_co_Perimeter": true +"Legal_sp_Info_co_Range": "5E" +"Skirt@Core.Permissions": "None" +"Levels@Core.Permissions": "None" +"New_sp_Financing_co_VA5": true +"Utilities_co_SW_sp_Gas3": true +"Zoning@Core.Permissions": "None" +"CapRate@Core.Permissions": "None" +"Dining_sp_Area_co_Formal": true +"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": "3" +"New_sp_Financing_co_Cash2": true +"ParkName@Core.Permissions": "None" +"Basement_co_Basement_sp_YN": "N" +"Fencing_co_Wrought_sp_Iron": 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" +"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" +"Landscaping_co_Desert_sp_Back": 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" +"Landscaping_co_Desert_sp_Front": 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" +"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" +"GardenerExpense@Core.Permissions": "None" +"LeaseExpiration@Core.Permissions": "None" +"LivingAreaUnits@Core.Permissions": "None" +"LockBoxLocation@Core.Permissions": "None" +"Special_sp_Listing_sp_Cond_co_NA": true +"Water_sp_Source_co_City_sp_Water": true +"Association_sp_Fees_co_HOA_sp_YN2": "Y" +"AttachedGarageYN@Core.Permissions": "None" +"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" +"Road_sp_Surface_sp_Type_co_Paved3": true +"SignOnPropertyYN@Core.Permissions": "None" +"Association_sp_Fees_co_HOA_sp_Fee2": 1050.0 +"CoBuyerOfficeName@Core.Permissions": "None" +"CoListOfficeEmail@Core.Permissions": "None" +"CoListOfficePhone@Core.Permissions": "None" +"Cooling_co_Programmable_sp_Thmstat": true +"DevelopmentStatus@Core.Permissions": "None" +"Dining_sp_Area_co_Breakfast_sp_Bar": true +"ExistingLeaseType@Core.Permissions": "None" +"Laundry_co_Gas_sp_Dryer_sp_Hookup2": true +"Location_sp_Tax_sp_Legal_co_Taxes2": 8796.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" +"WaterSewerExpense@Core.Permissions": "None" +"Association_sp_Fees_co_HOA_sp_Name4": "Collina Vista HOA" +"BuyerAgentLastName@Core.Permissions": "None" +"CoBuyerOfficeEmail@Core.Permissions": "None" +"CoBuyerOfficeMlsId@Core.Permissions": "None" +"CoBuyerOfficePhone@Core.Permissions": "None" +"Kitchen_sp_Features_co_Gas_sp_Range": true +"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" +"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" +"Laundry_co_WshrDry_sp_HookUp_sp_Only": true +"ListAgentMiddleName@Core.Permissions": "None" +"Sewer_co_Sewer_sp__hyphen__sp_Public": true +"ShowingInstructions@Core.Permissions": "None" +"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" +"Const_sp__hyphen__sp_Finish_co_Stone2": true +"Const_sp__hyphen__sp_Finish_co_Stucco": true +"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" +"Const_sp__hyphen__sp_Finish_co_Painted": 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" +"Disclosures_co_Seller_sp_Discl_sp_Avail": true +"ListAgentTollFreePhone@Core.Permissions": "None" +"Private_sp_Pool_sp_Features_co_Outdoor2": true +"Association_sp_Fees_co_HOA_sp_Telephone4": "480-585-7587" +"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_Multiple_sp_Ovens": 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" +"Kitchen_sp_Features_co_Reverse_sp_Osmosis": true +"Master_sp_Bathroom_co_Tub_sp_with_sp_Jets": true +"OperatingExpenseIncludes@Core.Permissions": "None" +"Road_sp_Access_sp_Type_co_Private_sp_Road": true +"CoListAgentOfficePhoneExt@Core.Permissions": "None" +"Cooling_co_Ceiling_sp_Fan_lparen_s_rparen_": true +"Dining_sp_Area_co_Eat_hyphen_in_sp_Kitchen": true +"Kitchen_sp_Features_co_Granite_sp_Counters": true +"NumberOfFullTimeEmployees@Core.Permissions": "None" +"NumberOfPartTimeEmployees@Core.Permissions": "None" +"Association_sp_Fees_co_Other_sp_Fees_sp_HOA": 0.0 +"DistanceToElectricComments@Core.Permissions": "None" +"Landscaping_co_Auto_sp_Timer_sp_H2O_sp_Back": true +"Landscaping_co_Yrd_sp_Wtring_sp_Sys_sp_Back": true +"ListAgentPreferredPhoneExt@Core.Permissions": "None" +"Private_sp_Pool_sp_Features_co_Play_sp_Pool": 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 +"Lockbox_sp_Type_co_See_sp_Private_sp_Remarks": true +"CoListAgentPreferredPhoneExt@Core.Permissions": "None" +"General_sp_Property_sp_Description_co_ud_i_07": 2.0 +"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": 4.0 +"ProfessionalManagementExpense@Core.Permissions": "None" +"Association_sp_Fees_co_HOA_sp_Paid_sp_Frequency": "Quarterly" +"DistanceToPhoneServiceComments@Core.Permissions": "None" +"General_sp_Property_sp_Description_co_PriceSqFt": 819.32 +"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": 3.0 +"Separate_sp_DenOffice_co_Sep_sp_DenOffice_sp_YN": "Y" +"TaxOtherAnnualAssessmentAmount@Core.Permissions": "None" +"Association_sp_Fees_co_Disclosure_sp_Fees_sp_HOA": 0.0 +"Location_sp_Tax_sp_Legal_co_Tax_sp_Municipality3": "Scottsdale" +"Association_sp_Fees_co_Land_sp_Lease_sp_Fee_sp_YN": "N" +"Association_sp_Fees_co_Rec_sp_Center_sp_Fee_sp_YN": "N" +"Association_sp_Fees_co_HOA_sp_Management_sp_Company": "AAM" +"Association_sp_Fees_co_Special_sp_Assessment_sp_HOA": "No" +"Association_sp_Fees_co_Ttl_sp_Mthly_sp_Fee_sp_Equiv": 350.0 +"Kitchen_sp_Features_co_Built_hyphen_in_sp_Microwave": true +"Master_sp_Bathroom_co_Full_sp_Bth_sp_Master_sp_Bdrm": true +"Existing_sp_1st_sp_Loan_co_Treat_sp_as_sp_FreeClear4": true +"General_sp_Property_sp_Description_co_Approx_sp_SQFT": 4876.0 +"General_sp_Property_sp_Description_co_High_sp_School": "Cactus Shadows High School" +"General_sp_Property_sp_Description_co_Builder_sp_Name": "Pat Brady Construction" +"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": 4 +"Road_sp_Responsibility_co_Private_sp_Maintained_sp_Road": true +"General_sp_Property_sp_Description_co_Dwelling_sp_Styles": "Detached" +"General_sp_Property_sp_Description_co_Half_sp_Bathrooms2": 1 +"Showing_sp_Notification_sp_Methods_co_Showing_sp_Service": "Aligned Showings" +"General_sp_Property_sp_Description_co_Elementary_sp_School": "Desert Sun Academy" +"General_sp_Property_sp_Description_co_Jr_sp_High_sp_School": "Sonoran Trails Middle School" +"General_sp_Property_sp_Description_co_Approx_sp_Lot_sp_SqFt": 109782.0 +"Kitchen_sp_Features_co_Built_hyphen_In_sp_Electric_sp_Oven2": true +"Association_sp_Fees_co_Prepaid_sp_Association_sp_Fees_sp_HOA": 1050.0 +"General_sp_Property_sp_Description_co_Private_sp_Pool_sp_YN2": "Yes" +"General_sp_Property_sp_Description_co_Approx_sp_Lot_sp_Acres2": 2.52 +"General_sp_Property_sp_Description_co_Community_sp_Pool_sp_YN2": "No" +"Association_sp_Fees_co_HOA_sp_DisclosureAddendum_sp_Affirmation": "Yes" +"Assoc_sp_RulesInfo_co_Pets_sp_OK_sp__lparen_See_sp_Rmrks_rparen_": true +"Location_sp_Tax_sp_Legal_co_Assessor_squote_s_sp_Map_sp__pound_3": 4.0 +"General_sp_Property_sp_Description_co_High_sp_School_sp_District2": "Cave Creek Unified District" +"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": 507.0 +"Association_sp_Fee_sp_Incl_co_Other_sp__lparen_See_sp_Remarks_rparen_5": true +"General_sp_Property_sp_Description_co_Elementary_sp_School_sp_District2": "Cave Creek Unified District" +"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 3 COLLINA E VISTA MCR" +"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('20260115221906734765000000')" +"provider_name": "ARMLS" +"SourceSystemPlatformID": "T00000052" +"SourceSystemPlatformName": "Flexmls" +"OriginatingSystemPlatformID": "T00000052" +"OriginatingSystemPlatformName": "Flexmls" +"Media": array:39 [ …39] +"DaysOnMarket": 0 +"ID": "82711" } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#19155 +post_id: "127864" +post_author: 1 +"ListingKey": "20260425155745547132000000" +"ListingId": "7021738" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-05-21T06:32:50Z" +"RFModificationTimestamp": "2026-05-21T06:35:05Z" +"ListPrice": 1025000.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 1 +"BedroomsTotal": 4.0 +"LotSizeArea": 8174.0 +"LivingArea": 3886.0 +"BuildingAreaTotal": 0 +"City": "Glendale" +"PostalCode": "85308" +"UnparsedAddress": "5812 W Del Lago Circle, Glendale, Arizona 85308" +"Coordinates": array:2 [ …2] +"Latitude": 33.675424 +"Longitude": -112.183369 +"YearBuilt": 1989 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Tammy Brockman" +"ListOfficeName": "Russ Lyon Sotheby's International Realty" +"ListAgentMlsId": "tb315" +"ListOfficeMlsId": "lyon05" +"OriginatingSystemName": "ARMLS" +"PublicRemarks": "Experience luxury waterfront living in the exclusive community of Del Lago Circle. Ideally located just north of Loop 101, it offers convenient access to I-17, premier shopping, dining, entertainment, and is in close proximity to the expanding TSMC development. This spectacular remodeled custom home is priced at current appraised value and offers an exceptional opportunity in one of the area's most desirable locations. This elegant waterfront residence blends timeless architecture with extensive modern upgrades including Low-E energy lighting and extensive recessed LED lighting. A scenic lakefront entry welcomes you into a private, relaxing setting with breathtaking lake and mountain views. The thoughtfully designed floorplan offers exceptional flexibility with dual primary suites--one on the main level and an expansive upstairs retreat--connected by a dramatic custom wrought iron staircase and catwalk overlooking the grand living spaces below. Upstairs, two oversized guest bedrooms share a Jack & Jill bath; one bedroom features a private balcony and walk-in closet. The extensively updated kitchen showcases granite countertops, a full tile backsplash, wall-to-wall custom cabinetry, a buffet bar with additional storage, a GE Monogram 48 in. Built-In Side-by-Side Refrigerator, and spacious eat-in counter seating. The remodeled laundry room offers abundant cabinetry, granite countertops, tile backsplash, and a deep soaking sink. Additional upgrades include remodeled bathrooms, refinished cabinetry throughout with updated hardware and soft-close hinges, elegant updated lighting, and fresh interior paint. The luxurious upstairs primary retreat features dual walk-in closets with custom built-ins, a private balcony, a spa-inspired bath with a freestanding soaking tub, a walk-in rain shower, and a private water closet. Additional features include: Pella doors and windows throughout, a great room with soaring cathedral ceilings, a wet bar in the formal living room, two wood-burning fireplaces, a formal dining room, a private den/TV room, tile, carpet, and wood flooring, a cedar-lined linen closet, a central vacuum system, an extended-height 3-car garage, a relaxing inground spa, North/South exposure, and two covered walk-out patios overlooking the lake. Extensive 2026 updates include: a refinished custom wrought iron staircase, an elegant crystal foyer chandelier, new recessed LED lighting throughout, refinished cabinetry throughout the home, updated hardware and soft-close hinges, new carpet and baseboards downstairs, updated ceiling fans and vanity lighting, refreshed spa edge paint, and an updated drip irrigation system and irrigation lines. This rare waterfront opportunity combines luxury, privacy, location, and extensive upgrades in one exceptional property. Don't miss your opportunity to own this stunning custom home in Del Lago Circle" +"AccessibilityFeatures": array:2 [ …2] +"Appliances": "Dryer,Washer,Refrigerator,Built-in Microwave,Dishwasher,Disposal,Induction Cooktop,Electric Oven,Electric Cooktop,Built-In Electric Oven" +"ApprovalStatus": true +"ArchitecturalStyle": "Contemporary" +"AssociationFee": "150.0" +"AssociationFeeFrequency": "Monthly" +"AssociationFeeIncludes": array:1 [ …1] +"AssociationName": "Del Lago Circle" +"AssociationPhone": "623-977-3860" +"AssociationYN": true +"BathroomsFull": 3 +"BedroomsPossible": 5 +"BuilderName": "Custom" +"BuildingAreaSource": "Appraiser" +"CoListAgentEmail": "patrick.touhey@russlyon.com" +"CoListAgentFirstName": "Patrick" +"CoListAgentFullName": "Patrick Touhey" +"CoListAgentKey": "20250107232337037973000000" +"CoListAgentLastName": "Touhey" +"CoListAgentMlsId": "pt151" +"CoListAgentMobilePhone": "623-910-6788" +"CoListAgentPreferredPhone": "623-910-6788" +"CoListOfficeKey": "20071206231602530318000000" +"CoListOfficeMlsId": "lyon05" +"CoListOfficeName": "Russ Lyon Sotheby's International Realty" +"CommunityFeatures": "Golf,Lake" +"ConstructionMaterials": array:3 [ …3] +"Cooling": "Central Air,Ceiling Fan(s),ENERGY STAR Qualified Equipment,Programmable Thmstat" +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Maricopa" +"CoveredSpaces": "3.0" +"CreationDate": "2026-05-01T02:52:08.729987+00:00" +"CrossStreet": "59th Ave & loop 101 (Beardsley Road)" +"CurrentFinancing": array:2 [ …2] +"Directions": "From loop 101, north on 59th Ave, east (right) on Del Lago Circle (at the guard house) turn right at the spectacular Waterfall and follow the street around, home is on the left." +"Disclosures": array:3 [ …3] +"DocumentsChangeTimestamp": "2026-05-12T17:16:49Z" +"Electric": array:1 [ …1] +"ElementarySchool": "Legend Springs Elementary" +"ElementarySchoolDistrict": "Deer Valley Unified District" +"ExteriorFeatures": "Balcony,Built-in Barbecue" +"Fencing": array:3 [ …3] +"FireplaceFeatures": array:3 [ …3] +"FireplaceYN": true +"FireplacesTotal": "2" +"Flooring": "Carpet,Tile,Wood" +"FoundationDetails": array:1 [ …1] +"GarageSpaces": "3.0" +"GreenEnergyEfficient": array:2 [ …2] +"Heating": "Forced Air,ENERGY STAR Qualified Equipment,Electric" +"HeatingYN": true +"HighSchool": "Mountain Ridge High School" +"HighSchoolDistrict": "Deer Valley Unified District" +"InteriorFeatures": "High Speed Internet,Granite Counters,Double Vanity,Upstairs,Eat-in Kitchen,Breakfast Bar,9+ Flat Ceilings,Central Vacuum,Vaulted Ceiling(s),Wet Bar,Kitchen Island,Pantry,Full Bth Master Bdrm,Separate Shwr & Tub" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:3 [ …3] +"ListAgentAOR": "We SERV" +"ListAgentFirstName": "Tammy" +"ListAgentKey": "20100504194435633592000000" +"ListAgentLastName": "Brockman" +"ListAgentPreferredPhone": "602-758-8888" +"ListAgentURL": "tammybrockman.com" +"ListOfficeEmail": "bret.lamberson@russlyon.com" +"ListOfficeFax": "480-488-9530" +"ListOfficeKey": "20071206231602530318000000" +"ListOfficePhone": "480-488-2400" +"ListOfficeURL": "www.russlyon.com" +"ListingContractDate": "2026-04-30" +"ListingTerms": "Cash,Conventional,VA Loan" +"LivingAreaSource": "Appraiser" +"LotFeatures": array:13 [ …13] +"LotSizeAcres": 0.19 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 8174.0 +"MajorChangeTimestamp": "2026-05-01T02:45:35Z" +"MajorChangeType": "New Listing" +"MiddleOrJuniorSchool": "Hillcrest Middle School" +"MlsStatus": "Active" +"Model": "Custom" +"OpenParkingSpaces": "3.0" +"OriginalEntryTimestamp": "2026-05-01T02:45:34Z" +"OriginatingSystemID": "M00000048" +"OriginatingSystemKey": "20260425155745547132000000" +"Ownership": "Fee Simple" +"ParcelNumber": "200-23-072" +"ParkingFeatures": "Attached Garage,Garage Door Opener,Extended Length Garage,Direct Access,Over Height Garage" +"PatioAndPorchFeatures": array:2 [ …2] +"PhotosChangeTimestamp": "2026-05-01T18:16:04Z" +"PhotosCount": 88 +"Possession": array:1 [ …1] +"PossibleUse": array:1 [ …1] +"PostalCity": "Glendale" +"PostalCodePlus4": "6210" +"PublicSurveyRange": "2E" +"PublicSurveySection": "20" +"RoadResponsibility": array:1 [ …1] +"RoadSurfaceType": array:1 [ …1] +"Roof": "Tile" +"SecurityFeatures": array:1 [ …1] +"Sewer": "Public Sewer" +"SourceSystemID": "M00000048" +"SourceSystemKey": "20260425155745547132000000" +"SourceSystemName": "Arizona Regional Multiple Listing Service (ARMLS)" +"SpaFeatures": array:1 [ …1] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "AZ" +"StatusChangeTimestamp": "2026-05-01T02:45:34Z" +"StoriesTotal": "2" +"StreetDirPrefix": "W" +"StreetName": "DEL LAGO" +"StreetNumber": "5812" +"StreetNumberNumeric": "5812" +"StreetSuffix": "Circle" +"SubdivisionName": "HAMILTON ARROWHEAD RANCH" +"TaxAnnualAmount": "4477.0" +"TaxBookNumber": "200.00" +"TaxLegalDescription": "LOT 55 HAMILTON ARROWHEAD RANCH MCR 028050" +"TaxLot": "55" +"TaxMapNumber": "23.00" +"TaxYear": "2025" +"Township": "4N" +"View": array:2 [ …2] +"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=Ce9AFbF66YG&brand=0" +"WaterSource": array:1 [ …1] +"WaterfrontYN": true +"WindowFeatures": array:6 [ …6] +"View_co_Lake2": true +"Spa_co_Private": true +"Flooring_co_Tile": true +"Flooring_co_Wood": true +"Roofing_co_Tile2": true +"Utilities_co_APS": true +"Fencing_co_Block2": true +"Flooring_co_Carpet": true +"Laundry_co_Inside2": true +"Heating_co_Electric": true +"Legal_sp_Info_co_Range": "2E" +"Skirt@Core.Permissions": "None" +"Fencing_co_Back_sp_Yard": true +"Levels@Core.Permissions": "None" +"New_sp_Financing_co_VA5": true +"Zoning@Core.Permissions": "None" +"CapRate@Core.Permissions": "None" +"Dining_sp_Area_co_Formal": true +"Heating_co_Forced_sp_Air": true +"Stories@Core.Permissions": "None" +"Cooling_co_Central_sp_Air": true +"GarageYN@Core.Permissions": "None" +"Legal_sp_Info_co_Section2": "20" +"New_sp_Financing_co_Cash2": true +"ParkName@Core.Permissions": "None" +"Basement_co_Basement_sp_YN": "N" +"Fencing_co_Wrought_sp_Iron": true +"Furnished@Core.Permissions": "None" +"Master_sp_Bedroom_co_Split": true +"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" +"Landscaping_co_Grass_sp_Back": true +"LeaseAmount@Core.Permissions": "None" +"ListTeamKey@Core.Permissions": "None" +"LockBoxType@Core.Permissions": "None" +"MobileWidth@Core.Permissions": "None" +"PetsAllowed@Core.Permissions": "None" +"Services_co_City_sp_Services": true +"BusinessName@Core.Permissions": "None" +"BusinessType@Core.Permissions": "None" +"BuyerTeamKey@Core.Permissions": "None" +"Community_sp_Features_co_Golf": true +"Community_sp_Features_co_Lake": true +"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" +"Master_sp_Bedroom_co_Upstairs": true +"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" +"Window_sp_Features_co_Screens": true +"BuyerAgentAOR@Core.Permissions": "None" +"BuyerAgentFax@Core.Permissions": "None" +"BuyerAgentURL@Core.Permissions": "None" +"BuyerTeamName@Core.Permissions": "None" +"Foundation_sp_Details_co_Slab2": 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" +"GardenerExpense@Core.Permissions": "None" +"LeaseExpiration@Core.Permissions": "None" +"LivingAreaUnits@Core.Permissions": "None" +"LockBoxLocation@Core.Permissions": "None" +"Other_sp_Rooms_co_Family_sp_Room": true +"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": 150.0 +"CoBuyerOfficeName@Core.Permissions": "None" +"CoListOfficeEmail@Core.Permissions": "None" +"CoListOfficePhone@Core.Permissions": "None" +"Cooling_co_Programmable_sp_Thmstat": true +"DevelopmentStatus@Core.Permissions": "None" +"Dining_sp_Area_co_Breakfast_sp_Bar": true +"ExistingLeaseType@Core.Permissions": "None" +"Interior_sp_Features_co_Wet_sp_Bar": true +"Landscaping_co_GravelStone_sp_Back": true +"Location_sp_Tax_sp_Legal_co_Taxes2": 4477.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" +"Window_sp_Features_co_Dual_sp_Pane": true +"Window_sp_Features_co_Low_hyphen_E": true +"Association_sp_Fees_co_HOA_sp_Name4": "Del Lago Circle" +"BuyerAgentLastName@Core.Permissions": "None" +"CoBuyerOfficeEmail@Core.Permissions": "None" +"CoBuyerOfficeMlsId@Core.Permissions": "None" +"CoBuyerOfficePhone@Core.Permissions": "None" +"Dining_sp_Area_co_Breakfast_sp_Room": true +"Kitchen_sp_Features_co_Refrigerator": true +"Landscaping_co_GravelStone_sp_Front": 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 +"Road_sp_Surface_sp_Type_co_Asphalt2": 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" +"Laundry_co_WshrDry_sp_HookUp_sp_Only": true +"ListAgentMiddleName@Core.Permissions": "None" +"Sewer_co_Sewer_sp__hyphen__sp_Public": true +"ShowingInstructions@Core.Permissions": "None" +"Window_sp_Features_co_Vinyl_sp_Frame": true +"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" +"Const_sp__hyphen__sp_Finish_co_Stucco": true +"Contract_sp_Information_co_Ownership2": "Fee Simple" +"Disclosures_co_Agency_sp_Discl_sp_Req": true +"GrossScheduledIncome@Core.Permissions": "None" +"HoursDaysOfOperation@Core.Permissions": "None" +"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" +"Const_sp__hyphen__sp_Finish_co_Painted": true +"DistanceToGasComments@Core.Permissions": "None" +"ListAgentStateLicense@Core.Permissions": "None" +"ListAgentVoiceMailExt@Core.Permissions": "None" +"Technology_co_Security_sp_Sys_sp_Owned": 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" +"Disclosures_co_Seller_sp_Discl_sp_Avail": true +"Existing_sp_1st_sp_Loan_co_Conventional": true +"Kitchen_sp_Features_co_Electric_sp_Oven": true +"Laundry_co_220_sp_V_sp_Dryer_sp_Hookup2": true +"ListAgentTollFreePhone@Core.Permissions": "None" +"New_sp_Financing_co_Cash_sp_to_sp_Loan2": true +"Parking_sp_Features_co_Direct_sp_Access": true +"Technology_co_High_sp_Speed_sp_Internet": true +"Association_sp_Fees_co_HOA_sp_Telephone4": "623.977.3860" +"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" +"Fireplace_sp_Features_co_Wood_sp_Burning": true +"Items_sp_Updated_co_Floor_sp_PartialFull": "Partial" +"Items_sp_Updated_co_Plmbg_sp_PartialFull": "Partial" +"Kitchen_sp_Features_co_Kitchen_sp_Island": true +"Kitchen_sp_Features_co_Multiple_sp_Ovens": true +"ListAgentOfficePhoneExt@Core.Permissions": "None" +"Road_sp_Access_sp_Type_co_City_sp_Street": true +"Add_squote_l_sp_Property_sp_Use_co_None15": true +"BuyerAgentOfficePhoneExt@Core.Permissions": "None" +"CoListAgentTollFreePhone@Core.Permissions": "None" +"Construction_co_Frame_sp__hyphen__sp_Wood": true +"ContractStatusChangeDate@Core.Permissions": "None" +"Interior_sp_Features_co_Central_sp_Vacuum": true +"Items_sp_Updated_co_HtCool_sp_PartialFull": "Partial" +"OperatingExpenseIncludes@Core.Permissions": "None" +"Parking_sp_Features_co_Attached_sp_Garage": true +"Plumbing_co_Electric_sp_Hot_sp_Wtr_sp_Htr": true +"Special_sp_Listing_sp_Cond_co_OwnerAgent4": true +"CoListAgentOfficePhoneExt@Core.Permissions": "None" +"Cooling_co_Ceiling_sp_Fan_lparen_s_rparen_": true +"Dining_sp_Area_co_Eat_hyphen_in_sp_Kitchen": true +"Items_sp_Updated_co_Floor_sp_Yr_sp_Updated": "2026" +"Items_sp_Updated_co_Kitchen_sp_PartialFull": "Full" +"Items_sp_Updated_co_Plmbg_sp_Yr_sp_Updated": "2026" +"Kitchen_sp_Features_co_Electric_sp_Cooktop": true +"Kitchen_sp_Features_co_Granite_sp_Counters": true +"NumberOfFullTimeEmployees@Core.Permissions": "None" +"NumberOfPartTimeEmployees@Core.Permissions": "None" +"Association_sp_Fees_co_Other_sp_Fees_sp_HOA": 39.0 +"DistanceToElectricComments@Core.Permissions": "None" +"General_sp_Property_sp_Description_co_Model": "Custom" +"Items_sp_Updated_co_HtCool_sp_Yr_sp_Updated": "2024" +"Kitchen_sp_Features_co_Induction_sp_Cooktop": 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" +"BuyerAgentPreferredPhoneExt@Core.Permissions": "None" +"EnergyGreen_sp_Feature_co_Multi_hyphen_Zones": true +"General_sp_Property_sp_Description_co_Horses": "N" +"Items_sp_Updated_co_Kitchen_sp_Yr_sp_Updated": "2026" +"Landscaping_co_Auto_sp_Timer_sp_H2O_sp_Front": true +"Landscaping_co_Yrd_sp_Wtring_sp_Sys_sp_Front": true +"Plumbing_co_Engy_sp_Star_sp_Ht_sp_Wtr_sp_Htr": true +"Property_sp_Description_co_Waterfront_sp_Lot": true +"CoListAgentPreferredPhoneExt@Core.Permissions": "None" +"General_sp_Property_sp_Description_co_ud_i_07": 2.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": 179.0 +"Disclosures_co_Vicinity_sp_of_sp_an_sp_Airport": true +"Exterior_sp_Features_co_Built_hyphen_in_sp_BBQ": true +"Interior_sp_Features_co_Soft_sp_Water_sp_Loop2": true +"Parking_sp_Spaces_co_Slab_sp_Parking_sp_Spaces": 3.0 +"ProfessionalManagementExpense@Core.Permissions": "None" +"Association_sp_Fees_co_HOA_sp_Paid_sp_Frequency": "Monthly" +"DistanceToPhoneServiceComments@Core.Permissions": "None" +"General_sp_Property_sp_Description_co_PriceSqFt": 263.77 +"Master_sp_Bathroom_co_Private_sp_Toilet_sp_Room": true +"Parking_sp_Features_co_Garage_sp_Door_sp_Opener": true +"Parking_sp_Features_co_Over_sp_Height_sp_Garage": true +"Parking_sp_Spaces_co_Total_sp_Covered_sp_Spaces": 3.0 +"Separate_sp_DenOffice_co_Sep_sp_DenOffice_sp_YN": "N" +"TaxOtherAnnualAssessmentAmount@Core.Permissions": "None" +"Additional_sp_Bedroom_co_2_sp_Master_sp_Bedrooms": true +"Association_sp_Fees_co_Disclosure_sp_Fees_sp_HOA": 182.0 +"Contact_sp_Info_co_List_sp_Agent_sp_Cell_sp_Phn2": "623.910.6788" +"Location_sp_Tax_sp_Legal_co_Tax_sp_Municipality3": "Glendale" +"Accessibility_sp_Feat_co_Hallways_sp_36in_sp_Wide": true +"Association_sp_Fees_co_Com_sp_Facilities_sp_Distr": "N" +"Association_sp_Fees_co_HOA_sp_Management_sp_Phone": "623.977.3860" +"Association_sp_Fees_co_Land_sp_Lease_sp_Fee_sp_YN": "N" +"Association_sp_Fees_co_Rec_sp_Center_sp_Fee_sp_YN": "N" +"Interior_sp_Features_co_Skylight_lparen_s_rparen_": true +"Lockbox_sp_Type_co_Supra_sp__lparen_ARMLS_rparen_": true +"Property_sp_Description_co_NorthSouth_sp_Exposure": true +"Additional_sp_Bedroom_co_Other_sp_Bedroom_sp_Split": true +"Fireplace_sp_Features_co_Fireplace_sp_Living_sp_Rm": true +"Association_sp_Fees_co_HOA_sp_Management_sp_Company": "Colby Management" +"Association_sp_Fees_co_Other_sp_Fees_sp_Description": "Community Archives Fee" +"Association_sp_Fees_co_Special_sp_Assessment_sp_HOA": "No" +"Association_sp_Fees_co_Ttl_sp_Mthly_sp_Fee_sp_Equiv": 150.0 +"Cooling_co_ENERGY_sp_STAR_sp_Qualified_sp_Equipment": true +"Fireplace_sp_Features_co_Fireplace_sp_Master_sp_Bdr": true +"General_sp_Property_sp_Description_co_Flood_sp_Zone": "No" +"Kitchen_sp_Features_co_Built_hyphen_in_sp_Microwave": true +"Master_sp_Bathroom_co_Full_sp_Bth_sp_Master_sp_Bdrm": true +"Parking_sp_Features_co_Extended_sp_Length_sp_Garage": true +"Additional_sp_Bedroom_co_Separate_sp_Bedroom_sp_Exit": true +"Existing_sp_1st_sp_Loan_sp_Terms_co_Non_sp_Assumable": true +"General_sp_Property_sp_Description_co_Approx_sp_SQFT": 3886.0 +"General_sp_Property_sp_Description_co_High_sp_School": "Mountain Ridge High School" +"Heating_co_ENERGY_sp_STAR_sp_Qualified_sp_Equipment2": true +"Kitchen_sp_Features_co_220_sp_Volts_sp_in_sp_Kitchen": true +"Property_sp_Description_co_Borders_sp_Common_sp_Area": true +"Road_sp_Responsibility_co_City_sp_Maintained_sp_Road": true +"General_sp_Property_sp_Description_co_Builder_sp_Name": "Custom" +"Association_sp_Fee_sp_Incl_co_Common_sp_Area_sp_Maint3": true +"Association_sp_Fees_co_Cap_sp_ImprovementImpact_sp_Fee": 450.0 +"General_sp_Property_sp_Description_co_Fireplace_sp_YN2": "Yes" +"Additional_sp_Bedroom_co_Other_sp_Bedroom_sp_Downstairs": true +"General_sp_Property_sp_Description_co_Full_sp_Bathroom2": 3 +"Laundry_co_Engy_sp_Star_sp__lparen_See_sp_Rmks_rparen_3": true +"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": "Del Lago Circle" +"Items_sp_Updated_co_Bath_lparen_s_rparen__sp_PartialFull": "Partial" +"Showing_sp_Notification_sp_Methods_co_Showing_sp_Service": "Aligned Showings" +"Exterior_sp_Features_co_Covered_sp_Patio_lparen_s_rparen_": true +"General_sp_Property_sp_Description_co_Elementary_sp_School": "Legend Springs Elementary" +"General_sp_Property_sp_Description_co_Jr_sp_High_sp_School": "Hillcrest Middle School" +"Items_sp_Updated_co_Bath_lparen_s_rparen__sp_Yr_sp_Updated": "2026" +"Property_sp_Description_co_Cul_hyphen_De_hyphen_Sac_sp_Lot": true +"General_sp_Property_sp_Description_co_Approx_sp_Lot_sp_SqFt": 8174.0 +"Interior_sp_Features_co_Vaulted_sp_Ceiling_lparen_s_rparen_": true +"Kitchen_sp_Features_co_Built_hyphen_In_sp_Electric_sp_Oven2": true +"Association_sp_Fees_co_Prepaid_sp_Association_sp_Fees_sp_HOA": 300.0 +"EnergyGreen_sp_Feature_co_ENERGY_sp_STAR_sp_Light_sp_Fixture": true +"General_sp_Property_sp_Description_co_Private_sp_Pool_sp_YN2": "No" +"Window_sp_Features_co_ENERGY_sp_STAR_sp_Qualified_sp_Windows": true +"Additional_sp_Bedroom_co_Master_sp_Bedroom_sp_Sitting_sp_Room": true +"General_sp_Property_sp_Description_co_Approx_sp_Lot_sp_Acres2": 0.188 +"General_sp_Property_sp_Description_co_Planned_sp_Comm_sp_Name": "Hamilton Arrowhead Ranch" +"General_sp_Property_sp_Description_co_Community_sp_Pool_sp_YN2": "No" +"Association_sp_Fees_co_HOA_sp_DisclosureAddendum_sp_Affirmation": "Yes" +"Assoc_sp_RulesInfo_co_Pets_sp_OK_sp__lparen_See_sp_Rmrks_rparen_": true +"Location_sp_Tax_sp_Legal_co_Assessor_squote_s_sp_Map_sp__pound_3": 23.0 +"Assoc_sp_RulesInfo_co_Rental_sp_OK_sp__lparen_See_sp_Rmks_rparen_": true +"General_sp_Property_sp_Description_co_High_sp_School_sp_District2": "Deer Valley Unified District" +"Kitchen_sp_Features_co_Engy_sp_Star_sp__lparen_See_sp_Rmks_rparen_": 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": 72.0 +"Accessibility_sp_Feat_co_Accessible_sp_Door_sp__2013__sp_32in_sp_Wide": true +"Additional_sp_Bedroom_co_Other_sp_Bedroom_sp_Walk_hyphen_in_sp_Closet": true +"Assoc_sp_RulesInfo_co_No_sp_Visible_sp_Truck_sp_Trailer_sp_RV_sp_Boat": 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": "Deer Valley Unified District" +"General_sp_Property_sp_Description_co__pound__sp_of_sp_Interior_sp_Levels": 2 +"Location_sp_Tax_sp_Legal_co_Legal_sp_Description_sp__lparen_Abbrev_rparen_3": "LOT 55 HAMILTON ARROWHEAD RANCH MCR 028050" +"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('20260425155745547132000000')" +"provider_name": "ARMLS" +"SourceSystemPlatformID": "T00000052" +"SourceSystemPlatformName": "Flexmls" +"OriginatingSystemPlatformID": "T00000052" +"OriginatingSystemPlatformName": "Flexmls" +"Media": array:88 [ …88] +"DaysOnMarket": 0 +"ID": "127864" } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#19159 +post_id: "121276" +post_author: 1 +"ListingKey": "20260212205735202430000000" +"ListingId": "7015257" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-05-21T05:54:24Z" +"RFModificationTimestamp": "2026-05-21T05:56:38Z" +"ListPrice": 2995000.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 1 +"BedroomsTotal": 3.0 +"LotSizeArea": 38036.0 +"LivingArea": 4097.0 +"BuildingAreaTotal": 0 +"City": "Scottsdale" +"PostalCode": "85266" +"UnparsedAddress": "8555 E Eagle Claw Drive, Scottsdale, Arizona 85266" +"Coordinates": array:2 [ …2] +"Latitude": 33.807731 +"Longitude": -111.895789 +"YearBuilt": 2020 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Tami Henderson" +"ListOfficeName": "Russ Lyon Sotheby's International Realty" +"ListAgentMlsId": "th348" +"ListOfficeMlsId": "lyon09" +"OriginatingSystemName": "ARMLS" +"PublicRemarks": """ Located in coveted North Scottsdale, this 2020-built masterpiece sits on a premier cul-de-sac within the exclusive gates of Rosewood Ranch Estates. Sprawling across nearly an acre, this estate offers a rare sense of privacy and scale, delivering over 4,000 square feet of contemporary perfection. From the moment you arrive, the clean lines, manicured curb appeal, and spacious three-car garage signal that you've reached a home where no detail has been overlooked. Step inside to a world of unrivaled scale. The soaring ceilings and contemporary tile plank floors create a sense of airy sophistication that flows seamlessly from room to room.\r\n At the heart of the home lies a study in culinary excellence. This gourmet kitchen is a chef's dream, featuring Wolf and Sub-Zero appliances, an expansive social island, and undercounter beverage coolers. Organization is seamless here, with abundant cabinetry and a spacious pantry ensuring everything has its place. It's the ultimate hub for everything from your morning coffee to evening cocktails.\n \n Adjacent to the kitchen, the dining room offers a refined space for hosting, with private access doors that open directly onto the deep covered patio--perfect for transitioning from an intimate dinner to an evening under the stars.\n \n Just off the main entry, you'll discover a flexible den. Positioned away from the energy of the great room, this versatile space is perfect for a quiet home office or a dedicated studio--offering the privacy you need without sacrificing the home's open, modern feel.\n The luxury extends into the private quarters. Each oversized bedroom is designed as a personal retreat, paired with ensuite, spa-inspired baths that offer a serene escape from the everyday. \n While the interior is stunning, the backyard is where this estate truly shines. Designed for the ultimate Arizona lifestyle, the deep covered patio is an extension of the home, featuring a dedicated lounge with a large television and space for social seating.\n \n Lush turf creates a cool emerald escape framing, the crown jewel: a sparkling pool with cascading water features and a 360-degree zero-edge spa.\n \n After a long day on the golf course, gather around the tranquil firepit for conversation and dazzling Arizona sunsets. It is a setting for pure, unparalleled relaxation. \n \n For the entertainer, the poolside ramada is a destination of its own. Offering plenty of space for al fresco dining, and equipped with a built-in grill and a second outdoor media area to area to keep you connected to the game. \n \n Modern style, boutique privacy, and an entertainer's soul. \n 8555 East Eagle Claw Drive isn't just a place to live--it's a place to thrive. Come see for yourself. Your desert oasis is waiting. """ +"AccessibilityFeatures": array:3 [ …3] +"Appliances": "Dryer,Washer,Built In Recycling,Reverse Osmosis,Refrigerator,Built-in Microwave,Dishwasher,Disposal,Gas Range,Electric Oven,Gas Cooktop,Built-In Electric Oven,Water Purifier" +"ApprovalStatus": true +"ArchitecturalStyle": "Contemporary,Ranch" +"AssociationFee": "242.0" +"AssociationFeeFrequency": "Monthly" +"AssociationFeeIncludes": array:1 [ …1] +"AssociationName": "Rosewood Ranch Estat" +"AssociationPhone": "480-345-046x55523" +"AssociationYN": true +"BathroomsFull": 3 +"BedroomsPossible": 4 +"BuilderName": "Rosewood Homes" +"BuildingAreaSource": "Assessor" +"CoListAgentEmail": "laurie.tucker@russlyon.com" +"CoListAgentFirstName": "Laurie" +"CoListAgentFullName": "Laurie Tucker" +"CoListAgentKey": "20171115192614313892000000" +"CoListAgentLastName": "Tucker" +"CoListAgentMlsId": "lt192" +"CoListAgentMobilePhone": "303-229-2297" +"CoListAgentPreferredPhone": "303-229-2297" +"CoListOfficeKey": "20071206231602530318000000" +"CoListOfficeMlsId": "lyon05" +"CoListOfficeName": "Russ Lyon Sotheby's International Realty" +"CommunityFeatures": "Gated" +"ConstructionMaterials": array:4 [ …4] +"Cooling": "Central Air,Ceiling Fan(s),Programmable Thmstat" +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Maricopa" +"CoveredSpaces": "3.0" +"CreationDate": "2026-04-17T05:36:58.347790+00:00" +"CrossStreet": "Pima Road & E Hawknest Road" +"Directions": "Hwy 101 to Pima/Princess exit. North on Pima Rd to E Hawknest Rd. Turn west/left onto E Hawknest. Gate to Rosewood Ranch Estates is on your right (before you cross Windmill Rd). Through gate, turn right onto Eagle Claw. Home is 2nd on your right." +"Disclosures": array:1 [ …1] +"DocumentsChangeTimestamp": "2026-04-17T03:08:02Z" +"ElementarySchool": "Black Mountain Elementary School" +"ElementarySchoolDistrict": "Cave Creek Unified District" +"ExteriorFeatures": "Private Street(s),Private Yard,Built-in Barbecue" +"Fencing": array:2 [ …2] +"FireplaceFeatures": array:3 [ …3] +"FireplaceYN": true +"FireplacesTotal": "2" +"Flooring": "Carpet,Tile" +"FoundationDetails": array:1 [ …1] +"GarageSpaces": "3.0" +"GreenEnergyEfficient": array:1 [ …1] +"GreenWaterConservation": array:1 [ …1] +"Heating": "Natural Gas" +"HeatingYN": true +"HighSchool": "Cactus Shadows High School" +"HighSchoolDistrict": "Cave Creek Unified District" +"InteriorFeatures": "Walk-in Pantry,High Speed Internet,Granite Counters,Double Vanity,Eat-in Kitchen,Breakfast Bar,9+ Flat Ceilings,No Interior Steps,Kitchen Island,Pantry,Full Bth Master Bdrm,Separate Shwr & Tub" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"ListAgentAOR": "Scottsdale" +"ListAgentFirstName": "Tami" +"ListAgentKey": "20130731202005498371000000" +"ListAgentLastName": "Henderson" +"ListAgentPreferredPhone": "480-341-2815" +"ListAgentURL": "www.Desert Mountain Dream Home.com" +"ListOfficeEmail": "bret.lamberson@russlyon.com" +"ListOfficeFax": "480-437-2900" +"ListOfficeKey": "20071206231602683322000000" +"ListOfficePhone": "480-488-2998" +"ListOfficeURL": "www.russlyon.com" +"ListingContractDate": "2026-04-16" +"ListingTerms": "Cash,Conventional" +"LivingAreaSource": "Assessor" +"LotFeatures": array:8 [ …8] +"LotSizeAcres": 0.87 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 38036.0 +"MajorChangeTimestamp": "2026-04-17T03:08:00Z" +"MajorChangeType": "New Listing" +"MiddleOrJuniorSchool": "Sonoran Trails Middle School" +"MlsStatus": "Active" +"OpenParkingSpaces": "3.0" +"OriginalEntryTimestamp": "2026-04-17T03:08:00Z" +"OriginatingSystemID": "M00000048" +"OriginatingSystemKey": "20260212205735202430000000" +"OtherStructures": array:1 [ …1] +"Ownership": "Fee Simple" +"ParcelNumber": "216-34-410" +"ParkingFeatures": "Garage Door Opener,Direct Access" +"PatioAndPorchFeatures": array:2 [ …2] +"PhotosChangeTimestamp": "2026-04-17T03:08:02Z" +"PhotosCount": 63 +"PoolFeatures": "Variable Speed Pump,Heated" +"PoolPrivateYN": true +"Possession": array:1 [ …1] +"PostalCity": "Scottsdale" +"PostalCodePlus4": "1139" +"PublicSurveyRange": "4E" +"PublicSurveySection": "1" +"Roof": "See Remarks,Foam" +"SecurityFeatures": array:1 [ …1] +"Sewer": "Public Sewer" +"SourceSystemID": "M00000048" +"SourceSystemKey": "20260212205735202430000000" +"SourceSystemName": "Arizona Regional Multiple Listing Service (ARMLS)" +"SpaFeatures": array:2 [ …2] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "AZ" +"StatusChangeTimestamp": "2026-04-17T03:08:00Z" +"StoriesTotal": "1" +"StreetDirPrefix": "E" +"StreetName": "EAGLE CLAW" +"StreetNumber": "8555" +"StreetNumberNumeric": "8555" +"StreetSuffix": "Drive" +"SubdivisionName": "ROSEWOOD RANCH ESTATES" +"TaxAnnualAmount": "5542.0" +"TaxBookNumber": "216.00" +"TaxLegalDescription": "LOT 6 ROSEWOOD RANCH ESTATES MCR" +"TaxLot": "6" +"TaxMapNumber": "34.00" +"TaxYear": "2025" +"Township": "5N" +"VideosChangeTimestamp": "2026-05-16T02:28:31Z" +"VideosCount": 1 +"View": array:1 [ …1] +"VirtualTourURLUnbranded": "https://www.tourfactory.com/idxr3236050" +"WaterSource": array:1 [ …1] +"WindowFeatures": array:2 [ …2] +"Spa_co_Heated": true +"Spa_co_Private": true +"Roofing_co_Foam": true +"Flooring_co_Tile": true +"Utilities_co_APS": true +"Fencing_co_Block2": true +"Flooring_co_Carpet": true +"Laundry_co_Inside2": true +"Architecture_co_Ranch": true +"Legal_sp_Info_co_Range": "4E" +"Skirt@Core.Permissions": "None" +"Levels@Core.Permissions": "None" +"Utilities_co_SW_sp_Gas3": true +"Zoning@Core.Permissions": "None" +"CapRate@Core.Permissions": "None" +"Dining_sp_Area_co_Formal": true +"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": "1" +"Lockbox_sp_Type_co_None43": true +"New_sp_Financing_co_Cash2": true +"ParkName@Core.Permissions": "None" +"Basement_co_Basement_sp_YN": "N" +"Fencing_co_Wrought_sp_Iron": true +"Furnished@Core.Permissions": "None" +"Master_sp_Bedroom_co_Split": true +"OwnerName@Core.Permissions": "None" +"OwnerPays@Core.Permissions": "None" +"AccessCode@Core.Permissions": "None" +"CurrentUse@Core.Permissions": "None" +"Disclaimer@Core.Permissions": "None" +"OwnerPhone@Core.Permissions": "None" +"Roofing_co_See_sp_Remarks29": true +"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" +"Services_co_City_sp_Services": true +"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 +"Foundation_sp_Details_co_Slab2": 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" +"Kitchen_sp_Features_co_Disposal": true +"ListAgentEmail@Core.Permissions": "None" +"Other_sp_Rooms_co_Great_sp_Room": true +"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" +"Other_sp_Rooms_co_Family_sp_Room": true +"Special_sp_Listing_sp_Cond_co_NA": true +"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": 242.0 +"CoBuyerOfficeName@Core.Permissions": "None" +"CoListOfficeEmail@Core.Permissions": "None" +"CoListOfficePhone@Core.Permissions": "None" +"Cooling_co_Programmable_sp_Thmstat": true +"DevelopmentStatus@Core.Permissions": "None" +"Dining_sp_Area_co_Breakfast_sp_Bar": true +"ExistingLeaseType@Core.Permissions": "None" +"Location_sp_Tax_sp_Legal_co_Taxes2": 5542.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" +"Window_sp_Features_co_Dual_sp_Pane": true +"Association_sp_Fees_co_HOA_sp_Name4": "Rosewood Ranch Estat" +"BuyerAgentLastName@Core.Permissions": "None" +"CoBuyerOfficeEmail@Core.Permissions": "None" +"CoBuyerOfficeMlsId@Core.Permissions": "None" +"CoBuyerOfficePhone@Core.Permissions": "None" +"Kitchen_sp_Features_co_Gas_sp_Range": true +"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" +"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" +"Exterior_sp_Features_co_GazeboRamada": true +"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" +"Const_sp__hyphen__sp_Finish_co_Stone2": true +"Const_sp__hyphen__sp_Finish_co_Stucco": true +"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" +"Const_sp__hyphen__sp_Finish_co_Painted": true +"DistanceToGasComments@Core.Permissions": "None" +"ListAgentStateLicense@Core.Permissions": "None" +"ListAgentVoiceMailExt@Core.Permissions": "None" +"Private_sp_Pool_sp_Features_co_Heated3": true +"VirtualTourURLBranded@Core.Permissions": "None" +"BuyerAgentStateLicense@Core.Permissions": "None" +"BuyerAgentVoiceMailExt@Core.Permissions": "None" +"CoListAgentDirectPhone@Core.Permissions": "None" +"CoListAgentOfficePhone@Core.Permissions": "None" +"CumulativeDaysOnMarket@Core.Permissions": "None" +"Kitchen_sp_Features_co_Electric_sp_Oven": 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-345-046x55523" +"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 +"Kitchen_sp_Features_co_Multiple_sp_Ovens": 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" +"Fireplace_sp_Features_co_Gas_sp_Fireplace": true +"Interior_sp_Features_co_Water_sp_Purifier": true +"Kitchen_sp_Features_co_Reverse_sp_Osmosis": true +"Landscaping_co_Synthetic_sp_Grass_sp_Back": true +"OperatingExpenseIncludes@Core.Permissions": "None" +"Plumbing_co_Tankless_sp_Ht_sp_Wtr_sp_Heat": true +"CoListAgentOfficePhoneExt@Core.Permissions": "None" +"Cooling_co_Ceiling_sp_Fan_lparen_s_rparen_": true +"Dining_sp_Area_co_Eat_hyphen_in_sp_Kitchen": true +"Kitchen_sp_Features_co_Granite_sp_Counters": true +"NumberOfFullTimeEmployees@Core.Permissions": "None" +"NumberOfPartTimeEmployees@Core.Permissions": "None" +"Showing_sp_Notification_sp_Methods_co_Text": true +"Association_sp_Fees_co_Other_sp_Fees_sp_HOA": 75.0 +"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" +"BuyerAgentPreferredPhoneExt@Core.Permissions": "None" +"EnergyGreen_sp_Feature_co_Multi_hyphen_Zones": true +"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": 2.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" +"Accessibility_sp_Feat_co_Mltpl_sp_EntriesExits": true +"Association_sp_Fees_co_HOA_sp_Transfer_sp_Fee2": 0.0 +"Exterior_sp_Features_co_Built_hyphen_in_sp_BBQ": true +"Parking_sp_Spaces_co_Slab_sp_Parking_sp_Spaces": 3.0 +"ProfessionalManagementExpense@Core.Permissions": "None" +"Association_sp_Fees_co_HOA_sp_Paid_sp_Frequency": "Monthly" +"DistanceToPhoneServiceComments@Core.Permissions": "None" +"General_sp_Property_sp_Description_co_PriceSqFt": 731.02 +"Interior_sp_Features_co_No_sp_Interior_sp_Steps": true +"Kitchen_sp_Features_co_Built_sp_In_sp_Recycling": true +"Kitchen_sp_Features_co_Walk_hyphen_in_sp_Pantry": true +"Master_sp_Bathroom_co_Private_sp_Toilet_sp_Room": true +"Parking_sp_Features_co_Garage_sp_Door_sp_Opener": true +"Parking_sp_Spaces_co_Total_sp_Covered_sp_Spaces": 3.0 +"Separate_sp_DenOffice_co_Sep_sp_DenOffice_sp_YN": "Y" +"TaxOtherAnnualAssessmentAmount@Core.Permissions": "None" +"Window_sp_Features_co_Mechanical_sp_Sun_sp_Shds": true +"Association_sp_Fees_co_Disclosure_sp_Fees_sp_HOA": 400.0 +"Location_sp_Tax_sp_Legal_co_Tax_sp_Municipality3": "Scottsdale" +"Accessibility_sp_Feat_co_HardLow_sp_Nap_sp_Floors": true +"Association_sp_Fees_co_HOA_sp_Management_sp_Phone": "480-345-0046" +"Association_sp_Fees_co_Land_sp_Lease_sp_Fee_sp_YN": "N" +"Association_sp_Fees_co_Rec_sp_Center_sp_Fee_sp_YN": "N" +"Plumbing_co_Gas_sp_Hot_sp_Wtr_sp__2013__sp_Tnklss": true +"Fireplace_sp_Features_co_Fireplace_sp_Living_sp_Rm": true +"Accessibility_sp_Feat_co_Zero_hyphen_Grade_sp_Entry": true +"Association_sp_Fees_co_HOA_sp_Management_sp_Company": "Sentry Management" +"Association_sp_Fees_co_Other_sp_Fees_sp_Description": "HOA Admin Fee" +"Association_sp_Fees_co_Special_sp_Assessment_sp_HOA": "No" +"Association_sp_Fees_co_Ttl_sp_Mthly_sp_Fee_sp_Equiv": 242.0 +"General_sp_Property_sp_Description_co_Flood_sp_Zone": "TBD" +"Kitchen_sp_Features_co_Built_hyphen_in_sp_Microwave": true +"Master_sp_Bathroom_co_Full_sp_Bth_sp_Master_sp_Bdrm": true +"Additional_sp_Bedroom_co_Separate_sp_Bedroom_sp_Exit": true +"Existing_sp_1st_sp_Loan_co_Treat_sp_as_sp_FreeClear4": true +"General_sp_Property_sp_Description_co_Approx_sp_SQFT": 4097.0 +"General_sp_Property_sp_Description_co_High_sp_School": "Cactus Shadows High School" +"General_sp_Property_sp_Description_co_Builder_sp_Name": "Rosewood Homes" +"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": 3 +"Laundry_co_Engy_sp_Star_sp__lparen_See_sp_Rmks_rparen_3": true +"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": "Rosewood Ranch Estates" +"Showing_sp_Notification_sp_Methods_co_Showing_sp_Service": "Aligned Showings" +"Exterior_sp_Features_co_Covered_sp_Patio_lparen_s_rparen_": true +"Private_sp_Pool_sp_Features_co_Variable_sp_Speed_sp_Pump2": 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" +"Property_sp_Description_co_Cul_hyphen_De_hyphen_Sac_sp_Lot": true +"General_sp_Property_sp_Description_co_Approx_sp_Lot_sp_SqFt": 38036.0 +"Kitchen_sp_Features_co_Built_hyphen_In_sp_Electric_sp_Oven2": true +"Association_sp_Fees_co_Prepaid_sp_Association_sp_Fees_sp_HOA": 484.0 +"General_sp_Property_sp_Description_co_Private_sp_Pool_sp_YN2": "Yes" +"General_sp_Property_sp_Description_co_Approx_sp_Lot_sp_Acres2": 0.873 +"General_sp_Property_sp_Description_co_Planned_sp_Comm_sp_Name": "Rosewood Ranch Estates" +"General_sp_Property_sp_Description_co_Community_sp_Pool_sp_YN2": "No" +"Association_sp_Fees_co_HOA_sp_DisclosureAddendum_sp_Affirmation": "Yes" +"Location_sp_Tax_sp_Legal_co_Assessor_squote_s_sp_Map_sp__pound_3": 34.0 +"General_sp_Property_sp_Description_co_High_sp_School_sp_District2": "Cave Creek Unified District" +"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": 410.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 +"Association_sp_Fee_sp_Incl_co_Other_sp__lparen_See_sp_Remarks_rparen_5": true +"General_sp_Property_sp_Description_co_Elementary_sp_School_sp_District2": "Cave Creek Unified District" +"General_sp_Property_sp_Description_co__pound__sp_of_sp_Interior_sp_Levels": 1 +"Exterior_sp_Features_co_Pvt_sp_Yrd_lparen_s_rparen_Crtyrd_lparen_s_rparen_": true +"Location_sp_Tax_sp_Legal_co_Legal_sp_Description_sp__lparen_Abbrev_rparen_3": "LOT 6 ROSEWOOD RANCH ESTATES MCR" +"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('20260212205735202430000000')" +"provider_name": "ARMLS" +"SourceSystemPlatformID": "T00000052" +"SourceSystemPlatformName": "Flexmls" +"OriginatingSystemPlatformID": "T00000052" +"OriginatingSystemPlatformName": "Flexmls" +"Media": array:63 [ …63] +"DaysOnMarket": 0 +"ID": "121276" } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#19157 +post_id: "134427" +post_author: 1 +"ListingKey": "20260302033713121960000000" +"ListingId": "7028081" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-05-21T05:15:21Z" +"RFModificationTimestamp": "2026-05-21T05:20:22Z" +"ListPrice": 1595000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 10325.0 +"LivingArea": 2854.0 +"BuildingAreaTotal": 0 +"City": "Scottsdale" +"PostalCode": "85259" +"UnparsedAddress": "10033 N 135th Place, Scottsdale, Arizona 85259" +"Coordinates": array:2 [ …2] +"Latitude": 33.577221 +"Longitude": -111.788877 +"YearBuilt": 1996 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Lisa K Jones" +"ListOfficeName": "Fathom Realty Elite" +"ListAgentMlsId": "lj078" +"ListOfficeMlsId": "fraz006" +"OriginatingSystemName": "ARMLS" +"PublicRemarks": "La Colina~Incredible neighborhood on border of Scottsdale & Fountain Hills. 4 bedroom, 3 bath, single level home features a premium lot with view fencing, eastern views of Saddleback Mountain, desert preserve & sunrises! The gorgeous entertaining backyard includes a Pebble-Tec pool & spa with rock waterfall, gas BBQ, fireplace & citrus trees. Kitchen offers quartz counters, upgraded cabinets, gas Bertonelli range, pantry, built-in desk/charging station & filtered water at sink & plumbed to refrigerator, which is included. Spacious primary suite features walk-in shower, soaking tub, dual sinks and walk-in closet. Home has 12-ft ceilings, tankless water heater. water softener and 2023 Exterior Paint. Popular split floor plan has rounded walls, arched doorways, lighted niches & gas fireplace." +"Appliances": "Water Softener Owned,Reverse Osmosis,Refrigerator,Built-in Microwave,Dishwasher,Disposal,Gas Range" +"ApprovalStatus": true +"ArchitecturalStyle": "Santa Barbara/Tuscan" +"AssociationFee": "450.0" +"AssociationFeeFrequency": "Annually" +"AssociationFeeIncludes": array:1 [ …1] +"AssociationName": "La Colina" +"AssociationPhone": "480-759-4945" +"AssociationYN": true +"BathroomsFull": 3 +"BedroomsPossible": 4 +"BuilderName": "Shea Homes" +"BuildingAreaSource": "Appraiser" +"CoListAgentEmail": "Dennis@DLJonesHomes.com" +"CoListAgentFirstName": "Dennis" +"CoListAgentFullName": "Dennis Jones" +"CoListAgentKey": "20071208001658390242000000" +"CoListAgentLastName": "Jones" +"CoListAgentMlsId": "dj106" +"CoListAgentMobilePhone": "602-909-2845" +"CoListAgentPreferredPhone": "602-909-2845" +"CoListAgentURL": "http://DLJonesHomes.com" +"CoListOfficeKey": "20250828184438264123000000" +"CoListOfficeMlsId": "fraz006" +"CoListOfficeName": "Fathom Realty Elite" +"CommunityFeatures": "Biking/Walking Path" +"ConstructionMaterials": array:3 [ …3] +"Cooling": "Central Air,Ceiling Fan(s)" +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Maricopa" +"CoveredSpaces": "3.0" +"CreationDate": "2026-05-14T17:14:23.555921+00:00" +"CrossStreet": "Shea & 136th St" +"Directions": "Shea to South on 136th St to Gold Dust, W to Bayview, S to 135th Pl, Right to property on Left/E side of street." +"Disclosures": array:2 [ …2] +"DocumentsChangeTimestamp": "2026-05-14T17:03:25Z" +"ElementarySchool": "Laguna Elementary School" +"ElementarySchoolDistrict": "Scottsdale Unified District" +"ExteriorFeatures": "Built-in Barbecue" +"Fencing": array:2 [ …2] +"FireplaceFeatures": array:3 [ …3] +"FireplaceYN": true +"FireplacesTotal": "2" +"Flooring": "Stone,Wood" +"FoundationDetails": array:1 [ …1] +"GarageSpaces": "3.0" +"GreenEnergyEfficient": array:1 [ …1] +"GreenWaterConservation": array:1 [ …1] +"Heating": "Natural Gas" +"HeatingYN": true +"HighSchool": "Desert Mountain High School" +"HighSchoolDistrict": "Scottsdale Unified District" +"InteriorFeatures": "Non-laminate Counter,Quartz Countertops,High Speed Internet,Double Vanity,Eat-in Kitchen,9+ Flat Ceilings,Kitchen Island,Pantry,Full Bth Master Bdrm,Separate Shwr & Tub" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:3 [ …3] +"ListAgentAOR": "Phoenix REALTORS" +"ListAgentFax": "888-959-1177" +"ListAgentFirstName": "Lisa" +"ListAgentKey": "20071208002227905668000000" +"ListAgentLastName": "Jones" +"ListAgentPreferredPhone": "602-677-4130" +"ListAgentURL": "http://DLJonesHomes.com" +"ListOfficeEmail": "dpatricklewis@gmail.com" +"ListOfficeKey": "20250828184438264123000000" +"ListOfficePhone": "602-677-4130" +"ListingContractDate": "2026-05-14" +"ListingTerms": "Cash,Conventional,1031 Exchange" +"LivingAreaSource": "Appraiser" +"LotFeatures": array:9 [ …9] +"LotSizeAcres": 0.24 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 10325.0 +"MajorChangeTimestamp": "2026-05-14T17:03:23Z" +"MajorChangeType": "New Listing" +"MiddleOrJuniorSchool": "Mountainside Middle School" +"MlsStatus": "Active" +"Model": "Ironwood-Split" +"OpenParkingSpaces": "3.0" +"OriginalEntryTimestamp": "2026-05-14T17:03:23Z" +"OriginatingSystemID": "M00000048" +"OriginatingSystemKey": "20260302033713121960000000" +"Ownership": "Fee Simple" +"ParcelNumber": "217-31-252" +"ParkingFeatures": "Attached Garage,Garage Door Opener,Direct Access" +"PatioAndPorchFeatures": array:2 [ …2] +"PhotosChangeTimestamp": "2026-05-21T05:15:10Z" +"PhotosCount": 63 +"PoolFeatures": "Outdoor,Play Pool,Heated" +"PoolPrivateYN": true +"Possession": array:1 [ …1] +"PostalCity": "Scottsdale" +"PostalCodePlus4": "5420" +"PublicSurveyRange": "5E" +"PublicSurveySection": "25" +"RoadResponsibility": array:1 [ …1] +"RoadSurfaceType": array:2 [ …2] +"Roof": "Tile" +"RoomsTotal": "9" +"SecurityFeatures": array:1 [ …1] +"Sewer": "Public Sewer" +"SourceSystemID": "M00000048" +"SourceSystemKey": "20260302033713121960000000" +"SourceSystemName": "Arizona Regional Multiple Listing Service (ARMLS)" +"SpaFeatures": array:2 [ …2] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "AZ" +"StatusChangeTimestamp": "2026-05-14T17:03:23Z" +"StoriesTotal": "1" +"StreetDirPrefix": "N" +"StreetName": "135TH" +"StreetNumber": "10033" +"StreetNumberNumeric": "10033" +"StreetSuffix": "Place" +"SubdivisionName": "LA COLINA BY SHEA HOMES" +"TaxAnnualAmount": "3872.0" +"TaxBookNumber": "217.00" +"TaxLegalDescription": "LOT 49 LA COLINA BY SHEA HOMES MCR" +"TaxLot": "49" +"TaxMapNumber": "31.00" +"TaxYear": "2025" +"Township": "3N" +"View": array:2 [ …2] +"WaterSource": array:1 [ …1] +"WindowFeatures": array:1 [ …1] +"Spa_co_Heated": true +"Spa_co_Private": true +"View_co_Desert": true +"Flooring_co_Wood": true +"Roofing_co_Tile2": true +"Utilities_co_APS": true +"Fencing_co_Block2": true +"Flooring_co_Stone": true +"Laundry_co_Inside2": true +"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" +"Dining_sp_Area_co_Formal": true +"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": "25" +"New_sp_Financing_co_Cash2": true +"ParkName@Core.Permissions": "None" +"Basement_co_Basement_sp_YN": "N" +"Fencing_co_Wrought_sp_Iron": true +"Furnished@Core.Permissions": "None" +"Master_sp_Bedroom_co_Split": true +"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" +"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" +"Services_co_City_sp_Services": true +"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 +"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" +"Foundation_sp_Details_co_Slab2": true +"Landscaping_co_Desert_sp_Front": 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" +"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" +"GardenerExpense@Core.Permissions": "None" +"LeaseExpiration@Core.Permissions": "None" +"LivingAreaUnits@Core.Permissions": "None" +"LockBoxLocation@Core.Permissions": "None" +"Other_sp_Rooms_co_Family_sp_Room": true +"Special_sp_Listing_sp_Cond_co_NA": true +"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" +"Road_sp_Surface_sp_Type_co_Paved3": true +"SignOnPropertyYN@Core.Permissions": "None" +"View_co_Mountain_lparen_s_rparen_": true +"Association_sp_Fees_co_HOA_sp_Fee2": 450.0 +"CoBuyerOfficeName@Core.Permissions": "None" +"CoListOfficeEmail@Core.Permissions": "None" +"CoListOfficePhone@Core.Permissions": "None" +"DevelopmentStatus@Core.Permissions": "None" +"ExistingLeaseType@Core.Permissions": "None" +"Laundry_co_Gas_sp_Dryer_sp_Hookup2": true +"Location_sp_Tax_sp_Legal_co_Taxes2": 3872.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" +"Window_sp_Features_co_Dual_sp_Pane": true +"Association_sp_Fees_co_HOA_sp_Name4": "La Colina" +"BuyerAgentLastName@Core.Permissions": "None" +"CoBuyerOfficeEmail@Core.Permissions": "None" +"CoBuyerOfficeMlsId@Core.Permissions": "None" +"CoBuyerOfficePhone@Core.Permissions": "None" +"Kitchen_sp_Features_co_Gas_sp_Range": true +"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" +"Possession_co_Close_sp_of_sp_Escrow": true +"Road_sp_Surface_sp_Type_co_Asphalt2": 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" +"Laundry_co_WshrDry_sp_HookUp_sp_Only": true +"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" +"Const_sp__hyphen__sp_Finish_co_Stucco": true +"Contract_sp_Information_co_Ownership2": "Fee Simple" +"Disclosures_co_Agency_sp_Discl_sp_Req": true +"GrossScheduledIncome@Core.Permissions": "None" +"HoursDaysOfOperation@Core.Permissions": "None" +"ListAgentDirectPhone@Core.Permissions": "None" +"ListAgentMobilePhone@Core.Permissions": "None" +"ListAgentOfficePhone@Core.Permissions": "None" +"Master_sp_Bathroom_co_Double_sp_Sinks": true +"New_sp_Financing_co_1031_sp_Exchange2": true +"PrivateOfficeRemarks@Core.Permissions": "None" +"StreetSuffixModifier@Core.Permissions": "None" +"VacancyAllowanceRate@Core.Permissions": "None" +"Architecture_co_Santa_sp_BarbaraTuscan": true +"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" +"Const_sp__hyphen__sp_Finish_co_Painted": true +"Dining_sp_Area_co_Dining_sp_in_sp_LRGR": true +"DistanceToGasComments@Core.Permissions": "None" +"ListAgentStateLicense@Core.Permissions": "None" +"ListAgentVoiceMailExt@Core.Permissions": "None" +"Pmt_sp_Rate_sp_Info_co_Down_sp_Payment": 0.0 +"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" +"Disclosures_co_Seller_sp_Discl_sp_Avail": true +"Items_sp_Updated_co_Pool_sp_PartialFull": "Full" +"ListAgentTollFreePhone@Core.Permissions": "None" +"Parking_sp_Features_co_Direct_sp_Access": true +"Private_sp_Pool_sp_Features_co_Outdoor2": true +"Technology_co_High_sp_Speed_sp_Internet": true +"Association_sp_Fees_co_HOA_sp_Telephone4": "480-759-4945" +"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" +"Road_sp_Access_sp_Type_co_City_sp_Street": true +"BuyerAgentOfficePhoneExt@Core.Permissions": "None" +"CoListAgentTollFreePhone@Core.Permissions": "None" +"Construction_co_Frame_sp__hyphen__sp_Wood": true +"ContractStatusChangeDate@Core.Permissions": "None" +"Fireplace_sp_Features_co_Gas_sp_Fireplace": true +"Items_sp_Updated_co_HtCool_sp_PartialFull": "Partial" +"Kitchen_sp_Features_co_Reverse_sp_Osmosis": true +"OperatingExpenseIncludes@Core.Permissions": "None" +"Parking_sp_Features_co_Attached_sp_Garage": true +"Plumbing_co_Tankless_sp_Ht_sp_Wtr_sp_Heat": true +"CoListAgentOfficePhoneExt@Core.Permissions": "None" +"Cooling_co_Ceiling_sp_Fan_lparen_s_rparen_": true +"Dining_sp_Area_co_Eat_hyphen_in_sp_Kitchen": true +"NumberOfFullTimeEmployees@Core.Permissions": "None" +"NumberOfPartTimeEmployees@Core.Permissions": "None" +"Association_sp_Fees_co_Other_sp_Fees_sp_HOA": 0.0 +"DistanceToElectricComments@Core.Permissions": "None" +"General_sp_Property_sp_Description_co_Model": "Ironwood-Split" +"Interior_sp_Features_co_Fire_sp_Sprinklers3": true +"Items_sp_Updated_co_HtCool_sp_Yr_sp_Updated": "2024" +"Landscaping_co_Auto_sp_Timer_sp_H2O_sp_Back": true +"Landscaping_co_Yrd_sp_Wtring_sp_Sys_sp_Back": true +"ListAgentPreferredPhoneExt@Core.Permissions": "None" +"Pmt_sp_Rate_sp_Info_co_Total_sp_Encumbrance": 0.0 +"Private_sp_Pool_sp_Features_co_Play_sp_Pool": true +"BuyerAgentPreferredPhoneExt@Core.Permissions": "None" +"EnergyGreen_sp_Feature_co_Multi_hyphen_Zones": true +"General_sp_Property_sp_Description_co_Horses": "N" +"Kitchen_sp_Features_co_Quartz_sp_Countertops": true +"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": 2.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 +"Community_sp_Features_co_BikingWalking_sp_Path": true +"Exterior_sp_Features_co_Built_hyphen_in_sp_BBQ": true +"Fireplace_sp_Features_co_Exterior_sp_Fireplace": true +"Parking_sp_Spaces_co_Slab_sp_Parking_sp_Spaces": 3.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": 558.86 +"Master_sp_Bathroom_co_Private_sp_Toilet_sp_Room": true +"Parking_sp_Features_co_Garage_sp_Door_sp_Opener": true +"Parking_sp_Spaces_co_Total_sp_Covered_sp_Spaces": 3.0 +"Separate_sp_DenOffice_co_Sep_sp_DenOffice_sp_YN": "N" +"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" +"Property_sp_Description_co_EastWest_sp_Exposure2": 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" +"Lockbox_sp_Type_co_Supra_sp__lparen_ARMLS_rparen_": true +"Fireplace_sp_Features_co_Fireplace_sp_Family_sp_Rm": true +"Interior_sp_Features_co_Water_sp_Softener_sp_Owned": true +"Association_sp_Fees_co_HOA_sp_Management_sp_Company": "Vision Comm Mgmt" +"Association_sp_Fees_co_Special_sp_Assessment_sp_HOA": "No" +"Association_sp_Fees_co_Ttl_sp_Mthly_sp_Fee_sp_Equiv": 37.5 +"General_sp_Property_sp_Description_co_Flood_sp_Zone": "No" +"Kitchen_sp_Features_co_Built_hyphen_in_sp_Microwave": true +"Master_sp_Bathroom_co_Full_sp_Bth_sp_Master_sp_Bdrm": true +"Property_sp_Description_co_Border_sp_PresPub_sp_Lnd": true +"Additional_sp_Bedroom_co_Separate_sp_Bedroom_sp_Exit": true +"Existing_sp_1st_sp_Loan_co_Treat_sp_as_sp_FreeClear4": true +"General_sp_Property_sp_Description_co_Approx_sp_SQFT": 2854.0 +"General_sp_Property_sp_Description_co_High_sp_School": "Desert Mountain High School" +"Pmt_sp_Rate_sp_Info_co_Total_sp_Asum_sp_Mnth_sp_Pmts": 0.0 +"Property_sp_Description_co_Borders_sp_Common_sp_Area": true +"Road_sp_Responsibility_co_City_sp_Maintained_sp_Road": true +"General_sp_Property_sp_Description_co_Builder_sp_Name": "Shea Homes" +"Kitchen_sp_Features_co_Non_hyphen_laminate_sp_Counter": true +"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": 3 +"General_sp_Property_sp_Description_co_Dwelling_sp_Styles": "Detached" +"General_sp_Property_sp_Description_co_Half_sp_Bathrooms2": 0.0 +"General_sp_Property_sp_Description_co_Marketing_sp_Name3": "La Colina by Shea Homes" +"Showing_sp_Notification_sp_Methods_co_Showing_sp_Service": "Aligned Showings" +"Exterior_sp_Features_co_Covered_sp_Patio_lparen_s_rparen_": true +"General_sp_Property_sp_Description_co_Elementary_sp_School": "Laguna Elementary School" +"General_sp_Property_sp_Description_co_Jr_sp_High_sp_School": "Mountainside Middle School" +"General_sp_Property_sp_Description_co_Approx_sp_Lot_sp_SqFt": 10325.0 +"Association_sp_Fees_co_Prepaid_sp_Association_sp_Fees_sp_HOA": 450.0 +"General_sp_Property_sp_Description_co_Private_sp_Pool_sp_YN2": "Yes" +"General_sp_Property_sp_Description_co_Approx_sp_Lot_sp_Acres2": 0.237 +"General_sp_Property_sp_Description_co_Planned_sp_Comm_sp_Name": "La Colina" +"General_sp_Property_sp_Description_co_Community_sp_Pool_sp_YN2": "No" +"Association_sp_Fees_co_HOA_sp_DisclosureAddendum_sp_Affirmation": "Yes" +"Assoc_sp_RulesInfo_co_Pets_sp_OK_sp__lparen_See_sp_Rmrks_rparen_": true +"Location_sp_Tax_sp_Legal_co_Assessor_squote_s_sp_Map_sp__pound_3": 31.0 +"Assoc_sp_RulesInfo_co_Rental_sp_OK_sp__lparen_See_sp_Rmks_rparen_": true +"General_sp_Property_sp_Description_co_High_sp_School_sp_District2": "Scottsdale Unified District" +"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": 252.0 +"Assoc_sp_RulesInfo_co_No_sp_Visible_sp_Truck_sp_Trailer_sp_RV_sp_Boat": 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": "Scottsdale Unified District" +"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 49 LA COLINA BY SHEA HOMES MCR" +"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('20260302033713121960000000')" +"provider_name": "ARMLS" +"SourceSystemPlatformID": "T00000052" +"SourceSystemPlatformName": "Flexmls" +"OriginatingSystemPlatformID": "T00000052" +"OriginatingSystemPlatformName": "Flexmls" +"Media": array:63 [ …63] +"DaysOnMarket": 0 +"ID": "134427" } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#19154 +post_id: "132875" +post_author: 1 +"ListingKey": "20260507200603571852000000" +"ListingId": "7025194" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Pending" +"ModificationTimestamp": "2026-05-21T05:13:17Z" +"RFModificationTimestamp": "2026-05-21T05:15:56Z" +"ListPrice": 460000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 6138.0 +"LivingArea": 1386.0 +"BuildingAreaTotal": 0 +"City": "Peoria" +"PostalCode": "85383" +"UnparsedAddress": "13068 W Plum Road, Peoria, Arizona 85383" +"Coordinates": array:2 [ …2] +"Latitude": 33.735839 +"Longitude": -112.342073 …464 } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#19047 …464} 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#19160 …452} 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#19161 …442} ] +success: true +page_size: 9 +page_count: 522 +count: 4691 +after_key: "" } "RF Response Time" => "0.11 seconds" ] "RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp DESC&$top=9&$skip=45&$filter=(StandardStatus ne 'Closed') and (ExteriorFeatures eq 'Built-in Barbecue' OR InteriorFeatures eq 'Built-in Barbecue' OR Appliances eq 'Built-in Barbecue')&$expand=Media&$count=true" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#21777 +items: array:9 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#21783 …497} 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#21781 …424} 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#21786 …539} 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#21780 …494} 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#21782 …490} 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#21787 …486} 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#21788 …464} 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#21779 …452} 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#21778 …442} ] +success: true +page_size: 9 +page_count: 522 +count: 4691 +after_key: "" } "RF Response Time" => "0.1 seconds" ] ]