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=18&$filter=(StandardStatus ne 'Closed') and (ExteriorFeatures eq 'Sport Court(s)' OR InteriorFeatures eq 'Sport Court(s)' OR Appliances eq 'Sport Court(s)')&$expand=Media&$count=true" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#18815 +items: array:9 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#18809 +post_id: "133027" +post_author: 1 +"ListingKey": "20260507132713491695000000" +"ListingId": "7026691" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active Under Contract" +"ModificationTimestamp": "2026-05-20T21:18:23Z" +"RFModificationTimestamp": "2026-05-20T21:38:56Z" +"ListPrice": 1990000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 35578.0 +"LivingArea": 2640.0 +"BuildingAreaTotal": 0 +"City": "Scottsdale" +"PostalCode": "85260" +"UnparsedAddress": "8542 E Sunnyside Drive, Scottsdale, Arizona 85260" +"Coordinates": array:2 [ …2] +"Latitude": 33.595451 +"Longitude": -111.894309 +"YearBuilt": 1974 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Joshua Slepak" +"ListOfficeName": "Realty ONE Group" +"ListAgentMlsId": "js1497" +"ListOfficeMlsId": "reog08" +"OriginatingSystemName": "ARMLS" +"PublicRemarks": "Don't miss out on this amazing property in the Cactus Corridor. Situated on a 35,000 + sq/ft lot you will have plenty of room to reimagine this gorgeous home with a guest house, large addition or even start from scratch. The home has been completely remodeled featuring new kitchen, all new lighting, flooring, window/doors, Master bathroom, front and back landscaping and more. The backyard features a sparkly pool, hot tub, fabulous custom sport court and more. Minutes from Kierland/Quarter and in district for the 3 C's schools this home is in a prime location! Better Hurry!" +"Appliances": "Dryer,Washer,Refrigerator,Built-in Microwave,Dishwasher,Disposal" +"ApprovalStatus": true +"ArchitecturalStyle": "Ranch" +"AssociationFeeIncludes": array:1 [ …1] +"BathroomsFull": 2 +"BedroomsPossible": 5 +"BuilderName": "Unknown" +"BuildingAreaSource": "Assessor" +"ConstructionMaterials": array:4 [ …4] +"Cooling": "HVAC SEER Rating,Central Air" +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Maricopa" +"CoveredSpaces": "2.0" +"CreationDate": "2026-05-11T21:11:36.505205+00:00" +"CrossStreet": "Hayden and Cactus" +"CurrentFinancing": array:1 [ …1] +"Disclosures": array:1 [ …1] +"DocumentsChangeTimestamp": "2026-05-11T21:10:36Z" +"ElementarySchool": "Cochise Elementary School" +"ElementarySchoolDistrict": "Scottsdale Unified District" +"ExteriorFeatures": "Playground,Private Pickleball Court(s),Other,Sport Court(s),Storage" +"Fencing": array:1 [ …1] +"FireplaceFeatures": array:1 [ …1] +"FireplaceYN": true +"FireplacesTotal": "1" +"Flooring": "Vinyl" +"GarageSpaces": "2.0" +"Heating": "Electric" +"HeatingYN": true +"HighSchool": "Chaparral High School" +"HighSchoolDistrict": "Scottsdale Unified District" +"HorseYN": true +"InteriorFeatures": "Non-laminate Counter,High Speed Internet,Double Vanity,Breakfast Bar,Pantry,3/4 Bath Master Bdrm" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAgentAOR": "We SERV" +"ListAgentFirstName": "Joshua" +"ListAgentKey": "20181023000403900718000000" +"ListAgentLastName": "Slepak" +"ListAgentPreferredPhone": "480-747-1624" +"ListOfficeEmail": "ron.copus@realtyonegroup.com" +"ListOfficeKey": "20110829170205794604000000" +"ListOfficePhone": "602-953-4000" +"ListingContractDate": "2026-05-01" +"ListingTerms": "Cash,Conventional,1031 Exchange,VA Loan" +"LivingAreaSource": "Assessor" +"LotFeatures": array:9 [ …9] +"LotSizeAcres": 0.82 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 35578.0 +"MajorChangeTimestamp": "2026-05-20T21:17:52Z" +"MajorChangeType": "Status Change" +"MiddleOrJuniorSchool": "Cocopah Middle School" +"MlsStatus": "UCB (Under Contract-Backups)" +"OpenParkingSpaces": "6.0" +"OriginalEntryTimestamp": "2026-05-11T21:10:35Z" +"OriginatingSystemID": "M00000048" +"OriginatingSystemKey": "20260507132713491695000000" +"Ownership": "Fee Simple" +"ParcelNumber": "175-13-106" +"ParkingFeatures": "RV Access/Parking,RV Gate,Garage Door Opener,Direct Access,Separate Strge Area,Side Vehicle Entry" +"PatioAndPorchFeatures": array:1 [ …1] +"PhotosChangeTimestamp": "2026-05-11T21:10:36Z" +"PhotosCount": 25 +"PoolFeatures": "Outdoor" +"PoolPrivateYN": true +"Possession": array:1 [ …1] +"PostalCity": "Scottsdale" +"PostalCodePlus4": "5723" +"PublicSurveyRange": "4E" +"PublicSurveySection": "24" +"RoadResponsibility": array:1 [ …1] +"Roof": "Tile,Foam" +"Sewer": "Septic Tank" +"SourceSystemID": "M00000048" +"SourceSystemKey": "20260507132713491695000000" +"SourceSystemName": "Arizona Regional Multiple Listing Service (ARMLS)" +"SpaFeatures": array:3 [ …3] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "AZ" +"StatusChangeTimestamp": "2026-05-20T21:17:49Z" +"StoriesTotal": "1" +"StreetDirPrefix": "E" +"StreetName": "SUNNYSIDE" +"StreetNumber": "8542" +"StreetNumberNumeric": "8542" +"StreetSuffix": "Drive" +"SubdivisionName": "DESERT HILLS NORTH" +"TaxAnnualAmount": "3200.0" +"TaxBookNumber": "175.00" +"TaxLegalDescription": "LOT 63 DESERT HILLS NORTH MCR 015414" +"TaxLot": "63" +"TaxMapNumber": "13.00" +"TaxYear": "2025" +"Township": "3N" +"View": array:2 [ …2] +"WaterSource": array:1 [ …1] +"WindowFeatures": array:2 [ …2] +"Spa_co_Heated": true +"Spa_co_Private": true +"View_co_Desert": true +"Roofing_co_Foam": true +"Roofing_co_Tile2": true +"Utilities_co_APS": true +"Fencing_co_Block2": true +"Flooring_co_Vinyl": true +"Heating_co_Electric": true +"Architecture_co_Ranch": true +"Construction_co_Block": true +"Legal_sp_Info_co_Range": "4E" +"Skirt@Core.Permissions": "None" +"Spa_co_Above_sp_Ground": true +"Levels@Core.Permissions": "None" +"New_sp_Financing_co_VA5": true +"Sewer_co_Septic_sp_Tank": 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" +"Legal_sp_Info_co_Section2": "24" +"Lockbox_sp_Type_co_None43": true +"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" +"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_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" +"Exterior_sp_Features_co_Other6": 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_Storage": 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 +"Special_sp_Listing_sp_Cond_co_NA": true +"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": 14 +"InsuranceExpense@Core.Permissions": "None" +"Kitchen_sp_Features_co_Dishwasher": true +"ListingAgreement@Core.Permissions": "None" +"Master_sp_Bedroom_co_Not_sp_Split": true +"New_sp_Financing_co_Conventional5": true +"OperatingExpense@Core.Permissions": "None" +"Parking_sp_Features_co_RV_sp_Gate": true +"PendingTimestamp@Core.Permissions": "None" +"Property_sp_Description_co_Alley2": true +"RoadFrontageType@Core.Permissions": "None" +"SignOnPropertyYN@Core.Permissions": "None" +"View_co_Mountain_lparen_s_rparen_": true +"CoBuyerOfficeName@Core.Permissions": "None" +"CoListOfficeEmail@Core.Permissions": "None" +"CoListOfficePhone@Core.Permissions": "None" +"DevelopmentStatus@Core.Permissions": "None" +"Dining_sp_Area_co_Breakfast_sp_Bar": true +"ExistingLeaseType@Core.Permissions": "None" +"Location_sp_Tax_sp_Legal_co_Taxes2": 3200.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 +"BuyerAgentLastName@Core.Permissions": "None" +"CoBuyerOfficeEmail@Core.Permissions": "None" +"CoBuyerOfficeMlsId@Core.Permissions": "None" +"CoBuyerOfficePhone@Core.Permissions": "None" +"Kitchen_sp_Features_co_Refrigerator": true +"ListAgentVoiceMail@Core.Permissions": "None" +"ListOfficePhoneExt@Core.Permissions": "None" +"MaintenanceExpense@Core.Permissions": "None" +"NetOperatingIncome@Core.Permissions": "None" +"NumberOfUnitsTotal@Core.Permissions": "None" +"OffMarketTimestamp@Core.Permissions": "None" +"Possession_co_Close_sp_of_sp_Escrow": true +"ShowingContactType@Core.Permissions": "None" +"AdditionalParcelsYN@Core.Permissions": "None" +"BathroomsOneQuarter@Core.Permissions": "None" +"BuyerAgentFirstName@Core.Permissions": "None" +"BuyerAgentVoiceMail@Core.Permissions": "None" +"BuyerOfficePhoneExt@Core.Permissions": "None" +"FinancialDataSource@Core.Permissions": "None" +"ListAgentMiddleName@Core.Permissions": "None" +"ShowingInstructions@Core.Permissions": "None" +"AssociationAmenities@Core.Permissions": "None" +"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" +"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" +"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" +"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 +"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_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" +"ListAgentOfficePhoneExt@Core.Permissions": "None" +"BuyerAgentOfficePhoneExt@Core.Permissions": "None" +"CoListAgentTollFreePhone@Core.Permissions": "None" +"Construction_co_Frame_sp__hyphen__sp_Wood": true +"ContractStatusChangeDate@Core.Permissions": "None" +"Landscaping_co_Synthetic_sp_Grass_sp_Back": true +"OperatingExpenseIncludes@Core.Permissions": "None" +"Plumbing_co_Electric_sp_Hot_sp_Wtr_sp_Htr": true +"CoListAgentOfficePhoneExt@Core.Permissions": "None" +"Items_sp_Updated_co_Floor_sp_Yr_sp_Updated": "2022" +"Items_sp_Updated_co_Kitchen_sp_PartialFull": "Full" +"NumberOfFullTimeEmployees@Core.Permissions": "None" +"NumberOfPartTimeEmployees@Core.Permissions": "None" +"Parking_sp_Features_co_RV_sp_AccessParking": true +"Showing_sp_Notification_sp_Methods_co_Text": true +"Unit_sp_Style_co_All_sp_on_sp_One_sp_Level": true +"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" +"BuyerAgentPreferredPhoneExt@Core.Permissions": "None" +"General_sp_Property_sp_Description_co_Horses": "Y" +"Items_sp_Updated_co_Kitchen_sp_Yr_sp_Updated": "2022" +"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": 1.0 +"MiddleOrJuniorSchoolDistrict@Core.Permissions": "None" +"Parking_sp_Spaces_co_Slab_sp_Parking_sp_Spaces": 6.0 +"ProfessionalManagementExpense@Core.Permissions": "None" +"DistanceToPhoneServiceComments@Core.Permissions": "None" +"General_sp_Property_sp_Description_co_PriceSqFt": 753.79 +"Parking_sp_Features_co_Garage_sp_Door_sp_Opener": true +"Parking_sp_Features_co_Side_sp_Vehicle_sp_Entry": true +"Parking_sp_Spaces_co_Total_sp_Covered_sp_Spaces": 2.0 +"Separate_sp_DenOffice_co_Sep_sp_DenOffice_sp_YN": "Y" +"TaxOtherAnnualAssessmentAmount@Core.Permissions": "None" +"Location_sp_Tax_sp_Legal_co_Tax_sp_Municipality3": "Scottsdale" +"Parking_sp_Features_co_Separate_sp_Strge_sp_Area": true +"Association_sp_Fees_co_Land_sp_Lease_sp_Fee_sp_YN": "N" +"Exterior_sp_Features_co_Childrens_sp_Play_sp_Area": true +"Interior_sp_Features_co_Skylight_lparen_s_rparen_": true +"Property_sp_Description_co_NorthSouth_sp_Exposure": true +"Fireplace_sp_Features_co_Fireplace_sp_Family_sp_Rm": true +"Master_sp_Bathroom_co_34_sp_Bath_sp_Master_sp_Bdrm": true +"Association_sp_Fees_co_Ttl_sp_Mthly_sp_Fee_sp_Equiv": 0.0 +"Kitchen_sp_Features_co_Built_hyphen_in_sp_Microwave": true +"Showing_sp_Notification_sp_Methods_co_Phone_sp_Call": true +"General_sp_Property_sp_Description_co_Approx_sp_SQFT": 2640.0 +"General_sp_Property_sp_Description_co_High_sp_School": "Chaparral High School" +"Road_sp_Responsibility_co_City_sp_Maintained_sp_Road": true +"General_sp_Property_sp_Description_co_Builder_sp_Name": "Unknown" +"Kitchen_sp_Features_co_Non_hyphen_laminate_sp_Counter": true +"General_sp_Property_sp_Description_co_Fireplace_sp_YN2": "Yes" +"Exterior_sp_Features_co_Sport_sp_Court_lparen_s_rparen_": true +"General_sp_Property_sp_Description_co_Full_sp_Bathroom2": 2 +"General_sp_Property_sp_Description_co_Dwelling_sp_Styles": "Detached" +"General_sp_Property_sp_Description_co_Half_sp_Bathrooms2": 0.0 +"Items_sp_Updated_co_Bath_lparen_s_rparen__sp_PartialFull": "Full" +"Showing_sp_Notification_sp_Methods_co_Showing_sp_Service": "No Showing Service Used" +"General_sp_Property_sp_Description_co_Elementary_sp_School": "Cochise Elementary School" +"General_sp_Property_sp_Description_co_Jr_sp_High_sp_School": "Cocopah Middle School" +"Items_sp_Updated_co_Bath_lparen_s_rparen__sp_Yr_sp_Updated": "2022" +"General_sp_Property_sp_Description_co_Approx_sp_Lot_sp_SqFt": 35578.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.817 +"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": 13.0 +"General_sp_Property_sp_Description_co_High_sp_School_sp_District2": "Scottsdale Unified District" +"Location_sp_Tax_sp_Legal_co_Assessor_squote_s_sp_Parcel_sp__pound_3": 106.0 +"Additional_sp_Bedroom_co_Other_sp_Bedroom_sp_Walk_hyphen_in_sp_Closet": true +"Exterior_sp_Features_co_Private_sp_Pickleball_sp_Court_lparen_s_rparen_": 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 +"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 63 DESERT HILLS NORTH MCR 015414" +"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('20260507132713491695000000')" +"provider_name": "ARMLS" +"SourceSystemPlatformID": "T00000052" +"SourceSystemPlatformName": "Flexmls" +"OriginatingSystemPlatformID": "T00000052" +"OriginatingSystemPlatformName": "Flexmls" +"Media": array:25 [ …25] +"DaysOnMarket": 0 +"ID": "133027" } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#18811 +post_id: "95464" +post_author: 1 +"ListingKey": "20260202214855740161000000" +"ListingId": "6986712" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-05-20T21:13:03Z" +"RFModificationTimestamp": "2026-05-20T21:16:11Z" +"ListPrice": 749000.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 1 +"BedroomsTotal": 7.0 +"LotSizeArea": 10000.0 +"LivingArea": 4082.0 +"BuildingAreaTotal": 0 +"City": "Phoenix" +"PostalCode": "85083" +"UnparsedAddress": "3121 W Buckhorn Trail, Phoenix, Arizona 85083" +"Coordinates": array:2 [ …2] +"Latitude": 33.732022 +"Longitude": -112.126782 +"YearBuilt": 2001 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Kim Panozzo" +"ListOfficeName": "Home Smart" +"ListAgentMlsId": "kp207" +"ListOfficeMlsId": "cril35" +"OriginatingSystemName": "ARMLS" +"PublicRemarks": "Ultimate Family Home! Beautifully remodeled & thoughtfully designed, this expansive home offers formal living & dining areas that flow into a show-stopping kitchen featuring a massive center island with storage on both sides, breakfast bar seating, dual-tone cabinetry, two dishwashers, double ovens, oversized refrigerator, eat-in kitchen space & a separate wet bar with open shelving--perfect for entertaining. The main level also includes a spacious primary suite with French doors to the backyard & ensuite with soaking tub & separate shower, plus a private den/office & powder bath. Upstairs showcases a huge sun-filled loft with abundant windows, six generously sized secondary bedrooms with ceiling fans, & a full bath with dual vanity & shower/tub combo. Outdoor living shines with a large covered patio featuring three ceiling fans, retractable sun screen, synthetic turf, half-court basketball, open patio space & in-ground trampoline. Additional highlights include leased solar, RV gate, extra slab parking & two A/C units. Community amenities offer green space & playground, with easy access to I-17, Loop 101 & 303, plus nearby shopping, dining & recreation this home truly has it all." +"Appliances": "Dryer,Washer,Refrigerator,Dishwasher,Disposal,Gas Range" +"ApprovalStatus": true +"AssociationFee": "165.0" +"AssociationFeeFrequency": "Quarterly" +"AssociationFeeIncludes": array:1 [ …1] +"AssociationName": "Hillcrest" +"AssociationPhone": "602-957-9191" +"AssociationYN": true +"BathroomsFull": 3 +"BedroomsPossible": 9 +"BuilderName": "KB Homes" +"BuildingAreaSource": "Assessor" +"CoListAgentEmail": "mikail.lane@gmail.com" +"CoListAgentFirstName": "Mikail" +"CoListAgentFullName": "Mikail Patrick Lane" +"CoListAgentKey": "20180925224653099829000000" +"CoListAgentLastName": "Lane" +"CoListAgentMlsId": "ml617" +"CoListAgentMobilePhone": "623-628-3816" +"CoListAgentPreferredPhone": "623-628-3816" +"CoListOfficeKey": "20230713223921809522000000" +"CoListOfficeMlsId": "cril35" +"CoListOfficeName": "Home Smart" +"ConstructionMaterials": array:3 [ …3] +"Cooling": "Central Air,Ceiling Fan(s),Programmable Thmstat" +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Maricopa" +"CoveredSpaces": "2.0" +"CreationDate": "2026-02-19T17:08:14.206859+00:00" +"CrossStreet": "Happy Valley & I-17" +"Directions": "From I-17, travel west on W Happy Valley Rd. Turn right on 35th Ave, after roughly 1.5 miles, turn right onto W Pinnacle Vista Dr. Make the first right turn onto N 32nd Dr, then left onto W Buckhorn Trail. Home located on right side, 2nd to end" +"Disclosures": array:2 [ …2] +"DocumentsChangeTimestamp": "2026-02-19T16:51:06Z" +"ElementarySchool": "Stetson Hills School" +"ElementarySchoolDistrict": "Deer Valley Unified District" +"ExteriorFeatures": "Sport Court(s)" +"Fencing": array:1 [ …1] +"Flooring": "Carpet,Tile,Wood" +"GarageSpaces": "2.0" +"Heating": "Natural Gas" +"HeatingYN": true +"HighSchool": "Sandra Day O'Connor High School" +"HighSchoolDistrict": "Deer Valley Unified District" +"InteriorFeatures": "Quartz Countertops,High Speed Internet,Master Downstairs,Eat-in Kitchen,Breakfast Bar,9+ Flat Ceilings,Wet Bar,Kitchen Island,Pantry,Full Bth Master Bdrm,Separate Shwr & Tub" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"ListAgentAOR": "Scottsdale" +"ListAgentFax": "602-889-2155" +"ListAgentFirstName": "Kim" +"ListAgentKey": "20071208002156733145000000" +"ListAgentLastName": "Panozzo" +"ListAgentPreferredPhone": "480-307-8326" +"ListAgentURL": "http://thepanozzoteam.com" +"ListOfficeEmail": "RLaRue@HomeSmart.com" +"ListOfficeKey": "20230713223921809522000000" +"ListOfficePhone": "480-307-8326" +"ListingContractDate": "2026-02-19" +"ListingTerms": "Cash,Conventional,VA Loan" +"LivingAreaSource": "Assessor" +"LotFeatures": array:7 [ …7] +"LotSizeAcres": 0.23 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 10000.0 +"MajorChangeTimestamp": "2026-02-19T16:51:05Z" +"MajorChangeType": "New Listing" +"MiddleOrJuniorSchool": "Stetson Hills School" +"MlsStatus": "Active" +"OpenParkingSpaces": "4.0" +"OriginalEntryTimestamp": "2026-02-19T16:51:05Z" +"OriginatingSystemID": "M00000048" +"OriginatingSystemKey": "20260202214855740161000000" +"Ownership": "Fee Simple" +"ParcelNumber": "205-03-111" +"ParkingFeatures": "RV Gate,Garage Door Opener,Direct Access" +"PatioAndPorchFeatures": array:2 [ …2] +"PhotosChangeTimestamp": "2026-05-20T21:12:43Z" +"PhotosCount": 36 +"Possession": array:1 [ …1] +"PostalCity": "Phoenix" +"PostalCodePlus4": "5830" +"PublicSurveyRange": "2E" +"PublicSurveySection": "35" +"Roof": "Tile,Concrete" +"SecurityFeatures": array:1 [ …1] +"Sewer": "Public Sewer" +"SourceSystemID": "M00000048" +"SourceSystemKey": "20260202214855740161000000" +"SourceSystemName": "Arizona Regional Multiple Listing Service (ARMLS)" +"SpaFeatures": array:1 [ …1] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "AZ" +"StatusChangeTimestamp": "2026-02-19T16:51:05Z" +"StoriesTotal": "2" +"StreetDirPrefix": "W" +"StreetName": "BUCKHORN" +"StreetNumber": "3121" +"StreetNumberNumeric": "3121" +"StreetSuffix": "Trail" +"SubdivisionName": "ARIZONA HILLCREST" +"TaxAnnualAmount": "3235.0" +"TaxBookNumber": "205.00" +"TaxLegalDescription": "LOT 86 ARIZONA HILLCREST MCR" +"TaxLot": "86" +"TaxMapNumber": "3.00" +"TaxYear": "2025" +"Township": "5N" +"WaterSource": array:1 [ …1] +"WindowFeatures": array:1 [ …1] +"Spa_co_None14": 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 +"Roofing_co_Concrete4": true +"Legal_sp_Info_co_Range": "2E" +"Other_sp_Rooms_co_Loft": true +"Skirt@Core.Permissions": "None" +"Construction_co_Other28": 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 +"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": "35" +"New_sp_Financing_co_Cash2": true +"ParkName@Core.Permissions": "None" +"Basement_co_Basement_sp_YN": "N" +"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 +"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" +"Solar_sp_Panels_co_Ownership3": "Monthly Lease Assumption" +"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" +"Laundry_co_Washer_sp_Included2": true +"ListOfficeAOR@Core.Permissions": "None" +"OwnershipType@Core.Permissions": "None" +"StructureType@Core.Permissions": "None" +"Unit_sp_Style_co_Two_sp_Levels": true +"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" +"Master_sp_Bedroom_co_Downstairs": 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" +"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" +"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" +"Parking_sp_Features_co_RV_sp_Gate": true +"PendingTimestamp@Core.Permissions": "None" +"RoadFrontageType@Core.Permissions": "None" +"SignOnPropertyYN@Core.Permissions": "None" +"Association_sp_Fees_co_HOA_sp_Fee2": 165.0 +"Association_sp_Fees_co_PAD_sp_Fee2": 0.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 +"Location_sp_Tax_sp_Legal_co_Taxes2": 3235.0 +"LotSizeDimensions@Core.Permissions": "None" +"NumberOfBuildings@Core.Permissions": "None" +"OnMarketTimestamp@Core.Permissions": "None" +"OriginalListPrice@Core.Permissions": "None" +"PreviousListPrice@Core.Permissions": "None" +"SeniorCommunityYN@Core.Permissions": "None" +"Technology_co_Cable_sp_TV_sp_Avail": true +"WaterSewerExpense@Core.Permissions": "None" +"Association_sp_Fees_co_HOA_sp_Name4": "Hillcrest" +"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" +"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" +"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" +"Window_sp_Features_co_Solar_sp_Screens": true +"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_Roof_sp_PartialFull": "Full" +"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": "602-957-9191" +"Association_sp_Fees_co_PAD_sp_Fee_sp_YN2": "N" +"BuyerAgentTollFreePhone@Core.Permissions": "None" +"CoBuyerAgentMobilePhone@Core.Permissions": "None" +"CoListAgentStateLicense@Core.Permissions": "None" +"CoListAgentVoiceMailExt@Core.Permissions": "None" +"DistanceToSewerComments@Core.Permissions": "None" +"DistanceToWaterComments@Core.Permissions": "None" +"Kitchen_sp_Features_co_Kitchen_sp_Island": true +"ListAgentOfficePhoneExt@Core.Permissions": "None" +"BuyerAgentOfficePhoneExt@Core.Permissions": "None" +"CoListAgentTollFreePhone@Core.Permissions": "None" +"ContractStatusChangeDate@Core.Permissions": "None" +"Items_sp_Updated_co_Roof_sp_Yr_sp_Updated": "2019" +"Landscaping_co_Synthetic_sp_Grass_sp_Back": true +"Landscaping_co_Synthetic_sp_Grass_sp_Frnt": true +"OperatingExpenseIncludes@Core.Permissions": "None" +"Plumbing_co_Gas_sp_Hot_sp_Water_sp_Heater": 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" +"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" +"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" +"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": 0.0 +"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": 183.49 +"Parking_sp_Features_co_Garage_sp_Door_sp_Opener": true +"Parking_sp_Spaces_co_Total_sp_Covered_sp_Spaces": 2.0 +"Separate_sp_DenOffice_co_Sep_sp_DenOffice_sp_YN": "Y" +"TaxOtherAnnualAssessmentAmount@Core.Permissions": "None" +"Association_sp_Fees_co_Disclosure_sp_Fees_sp_HOA": 400.0 +"Contact_sp_Info_co_List_sp_Agent_sp_Cell_sp_Phn2": "(623) 628-3816" +"Location_sp_Tax_sp_Legal_co_Tax_sp_Municipality3": "Phoenix" +"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 +"Property_sp_Description_co_NorthSouth_sp_Exposure": true +"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": 55.0 +"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": 4082.0 +"General_sp_Property_sp_Description_co_High_sp_School": "Sandra Day O'Connor High School" +"General_sp_Property_sp_Description_co_Builder_sp_Name": "KB Homes" +"Association_sp_Fee_sp_Incl_co_Common_sp_Area_sp_Maint3": true +"Association_sp_Fees_co_Cap_sp_ImprovementImpact_sp_Fee": 110.0 +"General_sp_Property_sp_Description_co_Fireplace_sp_YN2": "No" +"Exterior_sp_Features_co_Sport_sp_Court_lparen_s_rparen_": true +"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": 1 +"General_sp_Property_sp_Description_co_Marketing_sp_Name3": "Arizona Hillcrest" +"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": "Stetson Hills School" +"General_sp_Property_sp_Description_co_Jr_sp_High_sp_School": "Stetson Hills School" +"General_sp_Property_sp_Description_co_Approx_sp_Lot_sp_SqFt": 10000.0 +"Association_sp_Fees_co_Prepaid_sp_Association_sp_Fees_sp_HOA": 165.0 +"General_sp_Property_sp_Description_co_Private_sp_Pool_sp_YN2": "No" +"General_sp_Property_sp_Description_co_Approx_sp_Lot_sp_Acres2": 0.23 +"General_sp_Property_sp_Description_co_Planned_sp_Comm_sp_Name": "Arizona Hillcrest" +"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": 3.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" +"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": 111.0 +"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 86 ARIZONA HILLCREST 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('20260202214855740161000000')" +"provider_name": "ARMLS" +"SourceSystemPlatformID": "T00000052" +"SourceSystemPlatformName": "Flexmls" +"OriginatingSystemPlatformID": "T00000052" +"OriginatingSystemPlatformName": "Flexmls" +"Media": array:36 [ …36] +"DaysOnMarket": 0 +"ID": "95464" } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#18808 +post_id: "126891" +post_author: 1 +"ListingKey": "20260425113924626225000000" +"ListingId": "7019708" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active Under Contract" +"ModificationTimestamp": "2026-05-20T20:54:34Z" +"RFModificationTimestamp": "2026-05-20T20:57:36Z" +"ListPrice": 1295000.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 0 +"BedroomsTotal": 7.0 +"LotSizeArea": 38237.0 +"LivingArea": 3807.0 +"BuildingAreaTotal": 0 +"City": "Mesa" +"PostalCode": "85215" +"UnparsedAddress": "2342 N Lemon Circle, Mesa, Arizona 85215" +"Coordinates": array:2 [ …2] +"Latitude": 33.458255 +"Longitude": -111.750794 +"YearBuilt": 1993 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Eric Lambert" +"ListOfficeName": "Versatile Properties" +"ListAgentMlsId": "el183" +"ListOfficeMlsId": "vers001" +"OriginatingSystemName": "ARMLS" +"PublicRemarks": """ Located within the prestigious Spyglass Estates, this exceptional single-level estate sits on nearly an acre in a quiet cul-de-sac, offering a rare level of privacy. Bordering a vast open grassy area, the property enjoys an expansive, estate-like setting with no immediate intrusion--creating a truly secluded and exclusive atmosphere.\r\n The home features a split floor plan, soaring vaulted ceilings, wood-look flooring, arched passageways, abundant natural light, and built-in speakers throughout. The chef's kitchen is upgraded with high-end appliances, custom cabinetry, granite countertops, tile backsplash, and a spacious island ideal for entertaining.\r\n The backyard is a true resort-style oasis with a resurfaced pool, expansive grass areas, putting green, ramada, and covered patio, all design for ultimate privacy and relaxation. A detached casita provides its own living space, kitchen, and private patio--perfect for guests or multigenerational living. Additional highlights include a 3-car garage, RV storage, new roof on the main home/gazebo, New AC and new water heater in both home and casita. """ +"AccessibilityFeatures": array:2 [ …2] +"Appliances": "Dryer,Washer,Water Softener Owned,Refrigerator,Built-in Microwave,Dishwasher,Disposal,Gas Cooktop" +"ApprovalStatus": true +"ArchitecturalStyle": "Santa Barbara/Tuscan" +"AssociationFee": "586.5" +"AssociationFeeFrequency": "Semi-Annually" +"AssociationFeeIncludes": array:2 [ …2] +"AssociationName": "Spyglass Estates" +"AssociationPhone": "623-691-0567" +"AssociationYN": true +"BathroomsFull": 4 +"BedroomsPossible": 7 +"BuilderName": "CUSTOM" +"BuildingAreaSource": "Assessor" +"CoListAgentEmail": "jeremy@jeremysolem.com" +"CoListAgentFax": "602-492-9410" +"CoListAgentFirstName": "Jeremy" +"CoListAgentFullName": "Jeremy Solem" +"CoListAgentKey": "20090722212147639216000000" +"CoListAgentLastName": "Solem" +"CoListAgentMlsId": "js1094" +"CoListAgentMobilePhone": "602-327-7538" +"CoListAgentPreferredPhone": "602-327-7538" +"CoListAgentURL": "http://www.jeremysolem.com" +"CoListOfficeKey": "20240426181038421308000000" +"CoListOfficeMlsId": "vers001" +"CoListOfficeName": "Versatile Properties" +"ConstructionMaterials": array:3 [ …3] +"Cooling": "Central Air,Ceiling Fan(s)" +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Maricopa" +"CoveredSpaces": "3.0" +"CreationDate": "2026-04-28T07:21:54.213037+00:00" +"CrossStreet": "McKellips Rd & Val Vista Dr" +"Directions": "From AZ-202, head north to Gilbert Rd, turn right at the 1st cross street onto E McDowell Rd, turn right onto N Val Vista Dr, turn left onto E Leland St, turn left onto N Lemon Cir." +"Disclosures": array:1 [ …1] +"DocumentsChangeTimestamp": "2026-04-26T22:23:04Z" +"ElementarySchool": "Ishikawa Elementary School" +"ElementarySchoolDistrict": "Mesa Unified District" +"ExteriorFeatures": "Playground,Private Yard,Sport Court(s),RV Hookup" +"Fencing": array:2 [ …2] +"FireplaceFeatures": array:2 [ …2] +"FireplaceYN": true +"FireplacesTotal": "1" +"Flooring": "Tile,Wood" +"GarageSpaces": "3.0" +"GreenWaterConservation": array:1 [ …1] +"Heating": "Electric,Natural Gas" +"HeatingYN": true +"HighSchool": "Mountain View High School" +"HighSchoolDistrict": "Mesa Unified District" +"InteriorFeatures": "High Speed Internet,Granite Counters,Double Vanity,Eat-in Kitchen,Breakfast Bar,No Interior Steps,Vaulted Ceiling(s),Kitchen Island,Pantry,Full Bth Master Bdrm,Separate Shwr & Tub" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:2 [ …2] +"ListAgentAOR": "Scottsdale" +"ListAgentFirstName": "Eric" +"ListAgentKey": "20180801201442242335000000" +"ListAgentLastName": "Lambert" +"ListAgentPreferredPhone": "480-284-3204" +"ListAgentURL": "Eric Lambert Real Estate.com" +"ListOfficeEmail": "melyssa@thesolemgroup.com" +"ListOfficeKey": "20240426181038421308000000" +"ListOfficePhone": "623-234-0262" +"ListingContractDate": "2026-04-26" +"ListingTerms": "Cash,Conventional" +"LivingAreaSource": "Assessor" +"LotFeatures": array:11 [ …11] +"LotSizeAcres": 0.88 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 38237.0 +"MajorChangeTimestamp": "2026-05-20T20:53:55Z" +"MajorChangeType": "Status Change" +"MiddleOrJuniorSchool": "Stapley Junior High School" +"MlsStatus": "CCBS (Contract Contingent on Buyer Sale)" +"OnMarketDate": "2026-04-28" +"OpenParkingSpaces": "7.0" +"OriginalEntryTimestamp": "2026-04-26T22:23:01Z" +"OriginatingSystemID": "M00000048" +"OriginatingSystemKey": "20260425113924626225000000" +"OtherStructures": array:3 [ …3] +"Ownership": "Fee Simple" +"ParcelNumber": "141-28-021" +"ParkingFeatures": "RV Access/Parking,Garage Door Opener,Extended Length Garage,Direct Access,Attch'd Gar Cabinets,Separate Strge Area" +"PatioAndPorchFeatures": array:2 [ …2] +"PhotosChangeTimestamp": "2026-04-28T07:15:10Z" +"PhotosCount": 77 +"PoolFeatures": "Variable Speed Pump,Fenced,Heated" +"PoolPrivateYN": true +"Possession": array:1 [ …1] +"PossibleUse": array:1 [ …1] +"PostalCity": "Mesa" +"PostalCodePlus4": "2326" +"PublicSurveyRange": "6E" +"PublicSurveySection": "4" +"RoadResponsibility": array:1 [ …1] +"RoadSurfaceType": array:1 [ …1] +"Roof": "Tile" +"Sewer": "Public Sewer" +"SourceSystemID": "M00000048" +"SourceSystemKey": "20260425113924626225000000" +"SourceSystemName": "Arizona Regional Multiple Listing Service (ARMLS)" +"SpaFeatures": array:1 [ …1] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "AZ" +"StatusChangeTimestamp": "2026-05-20T20:53:52Z" +"StoriesTotal": "1" +"StreetDirPrefix": "N" +"StreetName": "LEMON" +"StreetNumber": "2342" +"StreetNumberNumeric": "2342" +"StreetSuffix": "Circle" +"SubdivisionName": "SPYGLASS ESTATES" +"TaxAnnualAmount": "5433.0" +"TaxBookNumber": "141.00" +"TaxLegalDescription": "LOT 1 SPYGLASS ESTATES MCR 028917" +"TaxLot": "1" +"TaxMapNumber": "28.00" +"TaxYear": "2025" +"Township": "1N" +"View": array:1 [ …1] +"WaterSource": array:1 [ …1] +"WindowFeatures": array:1 [ …1] +"Spa_co_None14": true +"Flooring_co_Tile": true +"Flooring_co_Wood": true +"Roofing_co_Tile2": true +"Utilities_co_SRP": true +"Fencing_co_Block2": true +"Laundry_co_Inside2": true +"Heating_co_Electric": true +"Irrigation_co_Flood": true +"Legal_sp_Info_co_Range": "6E" +"Skirt@Core.Permissions": "None" +"Levels@Core.Permissions": "None" +"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": "4" +"New_sp_Financing_co_Cash2": true +"ParkName@Core.Permissions": "None" +"Utilities_co_City_sp_Gas3": true +"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" +"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" +"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 +"Landscaping_co_Grass_sp_Front": 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" +"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" +"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 +"Landscaping_co_Irrigation_sp_Back": 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": 586.5 +"CoBuyerOfficeName@Core.Permissions": "None" +"CoListOfficeEmail@Core.Permissions": "None" +"CoListOfficePhone@Core.Permissions": "None" +"DevelopmentStatus@Core.Permissions": "None" +"Dining_sp_Area_co_Breakfast_sp_Bar": true +"ExistingLeaseType@Core.Permissions": "None" +"Landscaping_co_GravelStone_sp_Back": true +"Laundry_co_Gas_sp_Dryer_sp_Hookup2": true +"Location_sp_Tax_sp_Legal_co_Taxes2": 5433.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": "Spyglass Estates" +"BuyerAgentLastName@Core.Permissions": "None" +"CoBuyerOfficeEmail@Core.Permissions": "None" +"CoBuyerOfficeMlsId@Core.Permissions": "None" +"CoBuyerOfficePhone@Core.Permissions": "None" +"Kitchen_sp_Features_co_Refrigerator": true +"ListAgentVoiceMail@Core.Permissions": "None" +"ListOfficePhoneExt@Core.Permissions": "None" +"MaintenanceExpense@Core.Permissions": "None" +"NetOperatingIncome@Core.Permissions": "None" +"NumberOfUnitsTotal@Core.Permissions": "None" +"OffMarketTimestamp@Core.Permissions": "None" +"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 +"Exterior_sp_Features_co_RV_sp_Hookup": 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_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" +"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" +"Private_sp_Pool_sp_Features_co_Fenced2": true +"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" +"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": "623-691-0567" +"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_Plmbg_sp_PartialFull": "Partial" +"Kitchen_sp_Features_co_Kitchen_sp_Island": true +"ListAgentOfficePhoneExt@Core.Permissions": "None" +"Accessibility_sp_Feat_co_Lever_sp_Handles": 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" +"Fireplace_sp_Features_co_Gas_sp_Fireplace": true +"Items_sp_Updated_co_Pool_sp_Yr_sp_Updated": "2024" +"Items_sp_Updated_co_Roof_sp_Yr_sp_Updated": "2024" +"OperatingExpenseIncludes@Core.Permissions": "None" +"Plumbing_co_Gas_sp_Hot_sp_Water_sp_Heater": true +"Plumbing_co_Tankless_sp_Ht_sp_Wtr_sp_Heat": true +"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 +"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" +"Parking_sp_Features_co_RV_sp_AccessParking": true +"Showing_sp_Notification_sp_Methods_co_Text": true +"Unit_sp_Style_co_All_sp_on_sp_One_sp_Level": true +"Association_sp_Fees_co_Other_sp_Fees_sp_HOA": 0.0 +"DistanceToElectricComments@Core.Permissions": "None" +"Items_sp_Updated_co_HtCool_sp_Yr_sp_Updated": "2024" +"Landscaping_co_Auto_sp_Timer_sp_H2O_sp_Back": true +"ListAgentPreferredPhoneExt@Core.Permissions": "None" +"Showing_sp_Notification_sp_Methods_co_Email": true +"BuyerAgentPreferredPhoneExt@Core.Permissions": "None" +"General_sp_Property_sp_Description_co_Horses": "N" +"Landscaping_co_Auto_sp_Timer_sp_H2O_sp_Front": true +"Association_sp_Fee_sp_Incl_co_Street_sp_Maint": true +"CoListAgentPreferredPhoneExt@Core.Permissions": "None" +"General_sp_Property_sp_Description_co_ud_i_07": 1.0 +"Master_sp_Bathroom_co_Separate_sp_Shwr_sp_Tub": true +"MiddleOrJuniorSchoolDistrict@Core.Permissions": "None" +"Other_sp_Structures_co_Shed_lparen_s_rparen_2": true +"Association_sp_Fees_co_HOA_sp_Transfer_sp_Fee2": 0.0 +"Parking_sp_Spaces_co_Slab_sp_Parking_sp_Spaces": 7.0 +"ProfessionalManagementExpense@Core.Permissions": "None" +"Association_sp_Fees_co_HOA_sp_Paid_sp_Frequency": "Semi-Annually" +"DistanceToPhoneServiceComments@Core.Permissions": "None" +"General_sp_Property_sp_Description_co_PriceSqFt": 340.16 +"Interior_sp_Features_co_No_sp_Interior_sp_Steps": 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": "N" +"TaxOtherAnnualAssessmentAmount@Core.Permissions": "None" +"Association_sp_Fees_co_Disclosure_sp_Fees_sp_HOA": 373.0 +"Location_sp_Tax_sp_Legal_co_Tax_sp_Municipality3": "Mesa" +"Parking_sp_Features_co_Separate_sp_Strge_sp_Area": true +"Accessibility_sp_Feat_co_Bath_sp_Lever_sp_Faucets": true +"Association_sp_Fees_co_Land_sp_Lease_sp_Fee_sp_YN": "N" +"Association_sp_Fees_co_Rec_sp_Center_sp_Fee_sp_YN": "N" +"Exterior_sp_Features_co_Childrens_sp_Play_sp_Area": true +"Lockbox_sp_Type_co_Supra_sp__lparen_ARMLS_rparen_": true +"Property_sp_Description_co_NorthSouth_sp_Exposure": true +"Exterior_sp_Features_co_Separate_sp_Guest_sp_House": 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": "AS&A Property Mgmt" +"Association_sp_Fees_co_Special_sp_Assessment_sp_HOA": "No" +"Association_sp_Fees_co_Ttl_sp_Mthly_sp_Fee_sp_Equiv": 97.75 +"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 +"Showing_sp_Notification_sp_Methods_co_Phone_sp_Call": 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": 3807.0 +"General_sp_Property_sp_Description_co_High_sp_School": "Mountain View High School" +"Property_sp_Description_co_Borders_sp_Common_sp_Area": 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": 0.0 +"General_sp_Property_sp_Description_co_Fireplace_sp_YN2": "Yes" +"Exterior_sp_Features_co_Sport_sp_Court_lparen_s_rparen_": true +"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": 0.0 +"General_sp_Property_sp_Description_co_Marketing_sp_Name3": "Spyglass Estates" +"Parking_sp_Features_co_Attch_squote_d_sp_Gar_sp_Cabinets": true +"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 +"General_sp_Property_sp_Description_co_Elementary_sp_School": "Ishikawa Elementary School" +"General_sp_Property_sp_Description_co_Jr_sp_High_sp_School": "Stapley Junior High School" +"Property_sp_Description_co_Cul_hyphen_De_hyphen_Sac_sp_Lot": true +"General_sp_Property_sp_Description_co_Approx_sp_Lot_sp_SqFt": 38237.0 +"Interior_sp_Features_co_Vaulted_sp_Ceiling_lparen_s_rparen_": true +"Association_sp_Fees_co_Prepaid_sp_Association_sp_Fees_sp_HOA": 0.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.878 +"General_sp_Property_sp_Description_co_Planned_sp_Comm_sp_Name": "Spyglass 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": 28.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": "Mesa 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": 21.0 +"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": "Mesa 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 1 SPYGLASS ESTATES MCR 028917" +"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('20260425113924626225000000')" +"provider_name": "ARMLS" +"SourceSystemPlatformID": "T00000052" +"SourceSystemPlatformName": "Flexmls" +"OriginatingSystemPlatformID": "T00000052" +"OriginatingSystemPlatformName": "Flexmls" +"Media": array:77 [ …77] +"DaysOnMarket": 0 +"ID": "126891" } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#18812 +post_id: "49438" +post_author: 1 +"ListingKey": "20251115223202284661000000" +"ListingId": "6947943" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-05-20T20:36:09Z" +"RFModificationTimestamp": "2026-05-20T20:41:36Z" +"ListPrice": 5595000.0 +"BathroomsTotalInteger": 8.0 +"BathroomsHalf": 1 +"BedroomsTotal": 7.0 +"LotSizeArea": 88426.0 +"LivingArea": 8194.0 +"BuildingAreaTotal": 0 +"City": "Scottsdale" +"PostalCode": "85259" +"UnparsedAddress": "12816 E Turquoise Avenue, Scottsdale, Arizona 85259" +"Coordinates": array:2 [ …2] +"Latitude": 33.577255 +"Longitude": -111.804101 +"YearBuilt": 1997 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Perry Bergelt" +"ListOfficeName": "Arizona Luxury Real Estate" +"ListAgentMlsId": "pb316" +"ListOfficeMlsId": "perr01" +"OriginatingSystemName": "ARMLS" +"PublicRemarks": """ OWNER FINANCING! Hurry! This New Scottsdale Renovated Estate sits on OVER 2 acres and is surrounded by the timeless beauty of the Sonoran Desert. From the moment you arrive, this home reveals itself as a rare blend of modern design and elegance. Inside this full luxury remodel includes: An open space floor plan with vast ceiling heights, 2 sets of expansive glass stacking doors, large format limestone porcelain tile floors & Wood floors throughout, 10' high Iron and Glass Pivot Entry door, Inside out Linear modern gas Fireplace, Programmable LED lighting and Home System, EVERY BEDROOM with its OWN ENSUITE BATH, Mother in Law Suite-Casita w/Full Kitchen and separate entrance. Sophisticated Kitchen and bar area w/2 Tone Custom Cabinetry and Sub Zero-Wolf appliances. Extra Large Chefs Walk in Pantry w/Wet Sink, and ample closed and open storage, Temperature controlled Wine room w/192+ Wine Bottle Storage, Premium Black and White Dalmata Polished Marble Slab Countertops w/Waterfall sides on an extra long 13+' floating kitchen island. \n \n Primary Bath has 55" round free standing tub w/a contemporary 48" LED hanging gold light fixture above, Multi Function Rain Shower system built into ceiling, floor to ceiling and all over Floor Onyx Look Large Format Porcelain Tile, LED Vanity Mirrors, Huge His and Hers Walk in Closets and a Kohler Bidet Toilet. \n \n Laundry Room has 2 Stackable Laundry Stations each containing a Full Size Washer and Dryer, a wet sink with lots of upper and lower cabinetry as well as a wall w/full size storage. \n \n Entertaining and Multipurpose areas are a plus. There is a Great Room off the Foyer for your main entertaining, a large upstairs loft area family room with an amazing view of the backyard oasis that also has a hidden storage area. \n \n Downstairs off the garage there is an area with its own courtyard that can either be a gym, a kids playroom, a Home Theater area or anything else you want it to be - it has a key drop cabinet and a beverage bar area . \n \n Outdoor area - A property of this scale offers opportunities rarely found in Scottsdale. You can do anything that is in your imagination here. Right now there is a Gazebo w/a BBQ area, a firepit, Resort Type Pool, a pool house equipped with a dishwasher, wet sink, ice maker and beverage refrigerator as well as stairs that lead up to a view deck to relax and see the stars and lights at night! \n \n This is more than a remodel; it is a complete reinvention of Scottsdale luxury living, where modern comfort, architectural refinement, and breathtaking mountain views come together on an irreplaceable 2 plus acre canvas.\n Outdoor living is equally spectacular. Expansive patios wrap around the home, leading to an air conditioned retreat off of the play pool, both overlooking the endless desert. With generous space for dining, entertaining, or simply unwinding, the exterior becomes an extension of the home's luxurious ambiance.\n \n A property of this scale offers opportunities rarely found in Scottsdale: room for a guest casita, car collection, sport courts, horses, or simply the peace that comes with owning a private desert retreat.\n \n This is more than a remodel it is a complete reinvention of Scottsdale luxury living, where modern comfort, architectural refinement, and breathtaking mountain views come together on an irreplaceable 2 plus acre canvas. """ +"Appliances": "Stacked Washer/Dryer,Dryer,Washer,Water Softener Owned,Refrigerator,Built-in Microwave,Dishwasher,Disposal,Electric Oven,Gas Cooktop" +"ApprovalStatus": true +"AssociationFeeIncludes": array:1 [ …1] +"BathroomsFull": 7 +"BedroomsPossible": 9 +"BuilderName": "K A M Development" +"BuildingAreaSource": "Owner" +"CoListAgentEmail": "jake@arizonaluxurygroup.com" +"CoListAgentFax": "480-656-3317" +"CoListAgentFirstName": "Jake" +"CoListAgentFullName": "Jake Soule" +"CoListAgentKey": "20130205210908851028000000" +"CoListAgentLastName": "Soule" +"CoListAgentMlsId": "js1217" +"CoListAgentMobilePhone": "480-229-1002" +"CoListAgentPreferredPhone": "480-229-1002" +"CoListAgentURL": "http://www.arizonaluxurygroup.com" +"CoListOfficeKey": "20100302180947802598000000" +"CoListOfficeMlsId": "perr01" +"CoListOfficeName": "Arizona Luxury Real Estate" +"ConstructionMaterials": array:3 [ …3] +"Cooling": "Central Air,Ceiling Fan(s)" +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Maricopa" +"CoveredSpaces": "3.0" +"CreationDate": "2025-11-16T00:44:30.164708+00:00" +"CrossStreet": "Shea & 128th Street" +"Directions": "South on 128th St. Home is on the left at the corner of 128th St and Turquoise Ave. Main driveway and Front door access off of Turquoise." +"Disclosures": array:2 [ …2] +"DocumentsChangeTimestamp": "2025-11-16T00:40:08Z" +"ElementarySchool": "Laguna Elementary School" +"ElementarySchoolDistrict": "Scottsdale Unified District" +"ExteriorFeatures": "Misting System,Private Yard,Sport Court(s),Storage,Built-in Barbecue" +"Fencing": array:1 [ …1] +"FireplaceFeatures": array:4 [ …4] +"FireplaceYN": true +"FireplacesTotal": "1" +"Flooring": "Tile,Wood" +"GarageSpaces": "3.0" +"GreenEnergyEfficient": array:1 [ …1] +"Heating": "Electric,Natural Gas" +"HeatingYN": true +"HighSchool": "Desert Mountain High School" +"HighSchoolDistrict": "Scottsdale Unified District" +"HorseYN": true +"InteriorFeatures": "Walk-in Pantry,High Speed Internet,Granite Counters,Double Vanity,Master Downstairs,Breakfast Bar,9+ Flat Ceilings,Wet Bar,Kitchen Island,Pantry,Full Bth Master Bdrm,Separate Shwr & Tub" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"ListAgentAOR": "Scottsdale" +"ListAgentFax": "480-656-3317" +"ListAgentFirstName": "Perry" +"ListAgentKey": "20100302181458958821000000" +"ListAgentLastName": "Bergelt" +"ListAgentPreferredPhone": "480-272-3000" +"ListAgentURL": "www.Arizona Luxury Group.com" +"ListOfficeEmail": "perry@arizonaluxurygroup.com" +"ListOfficeFax": "480-656-3317" +"ListOfficeKey": "20100302180947802598000000" +"ListOfficePhone": "480-262-3000" +"ListingContractDate": "2025-11-15" +"ListingTerms": "Owner May Carry,Cash,Conventional" +"LivingAreaSource": "Owner" +"LotFeatures": array:9 [ …9] +"LotSizeAcres": 2.03 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 88426.0 +"MajorChangeTimestamp": "2025-11-16T00:40:05Z" +"MajorChangeType": "New Listing" +"MiddleOrJuniorSchool": "Mountainside Middle School" +"MlsStatus": "Active" +"OriginalEntryTimestamp": "2025-11-16T01:40:05Z" +"OriginatingSystemID": "M00000048" +"OriginatingSystemKey": "20251115223202284661000000" +"OtherStructures": array:1 [ …1] +"Ownership": "Fee Simple" +"ParcelNumber": "217-31-038-E" +"ParkingFeatures": "Attached Garage,RV Access/Parking,Gated,RV Gate,Garage Door Opener,Direct Access,Rear Vehicle Entry,Side Vehicle Entry" +"PatioAndPorchFeatures": array:2 [ …2] +"PhotosChangeTimestamp": "2025-11-18T20:41:04Z" +"PhotosCount": 83 +"PoolFeatures": "Outdoor,Play Pool" +"PoolPrivateYN": true +"Possession": array:1 [ …1] +"PostalCity": "Scottsdale" +"PostalCodePlus4": "5300" +"PublicSurveyRange": "5E" +"PublicSurveySection": "25" +"Roof": "Built-Up" +"SecurityFeatures": array:1 [ …1] +"Sewer": "Septic in & Cnctd,Septic Tank" +"SourceSystemID": "M00000048" +"SourceSystemKey": "20251115223202284661000000" +"SourceSystemName": "Arizona Regional Multiple Listing Service (ARMLS)" +"SpaFeatures": array:1 [ …1] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "AZ" +"StatusChangeTimestamp": "2025-11-16T00:40:05Z" +"StoriesTotal": "2" +"StreetDirPrefix": "E" +"StreetName": "TURQUOISE" +"StreetNumber": "12816" +"StreetNumberNumeric": "12816" +"StreetSuffix": "Avenue" +"SubdivisionName": "Meets & Bounds" +"TaxAnnualAmount": "9737.0" +"TaxBookNumber": "217.00" +"TaxLegalDescription": "TH PT LOT 36 OR W2 NW4 SW4 NW4 SEC 25 DAF BEG SW COR OF SD LOT TH N 176.79F TH E 40F TO TPOB TH CONT" +"TaxLot": "36" +"TaxMapNumber": "31.00" +"TaxParcelLetter": "E" +"TaxYear": "2024" +"Township": "3N" +"View": array:1 [ …1] +"WaterSource": array:1 [ …1] +"WindowFeatures": array:1 [ …1] +"Spa_co_None14": true +"Flooring_co_Tile": true +"Flooring_co_Wood": true +"Utilities_co_APS": true +"Fencing_co_Block2": true +"Laundry_co_Inside2": true +"Heating_co_Electric": true +"Legal_sp_Info_co_Range": "5E" +"Other_sp_Rooms_co_Loft": true +"Skirt@Core.Permissions": "None" +"Levels@Core.Permissions": "None" +"Sewer_co_Septic_sp_Tank": true +"Utilities_co_SW_sp_Gas3": true +"Zoning@Core.Permissions": "None" +"CapRate@Core.Permissions": "None" +"Stories@Core.Permissions": "None" +"Cooling_co_Central_sp_Air": true +"GarageYN@Core.Permissions": "None" +"Heating_co_Natural_sp_Gas": true +"Legal_sp_Info_co_Section2": "25" +"Lockbox_sp_Type_co_None43": true +"New_sp_Financing_co_Cash2": true +"ParkName@Core.Permissions": "None" +"Basement_co_Basement_sp_YN": "N" +"Furnished@Core.Permissions": "None" +"Master_sp_Bedroom_co_Split": true +"OwnerName@Core.Permissions": "None" +"OwnerPays@Core.Permissions": "None" +"Roofing_co_Built_hyphen_Up": 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_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" +"Parking_sp_Features_co_Gated2": true +"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 +"Laundry_co_Washer_sp_Included2": true +"ListOfficeAOR@Core.Permissions": "None" +"OwnershipType@Core.Permissions": "None" +"Sewer_co_Septic_sp_in_sp_Cnctd": true +"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" +"Master_sp_Bedroom_co_Downstairs": true +"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" +"Special_sp_Listing_sp_Cond_co_NA": true +"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" +"InsuranceExpense@Core.Permissions": "None" +"Kitchen_sp_Features_co_Dishwasher": true +"ListingAgreement@Core.Permissions": "None" +"New_sp_Financing_co_Conventional5": true +"OperatingExpense@Core.Permissions": "None" +"Parking_sp_Features_co_RV_sp_Gate": true +"PendingTimestamp@Core.Permissions": "None" +"RoadFrontageType@Core.Permissions": "None" +"SignOnPropertyYN@Core.Permissions": "None" +"View_co_Mountain_lparen_s_rparen_": true +"CoBuyerOfficeName@Core.Permissions": "None" +"CoListOfficeEmail@Core.Permissions": "None" +"CoListOfficePhone@Core.Permissions": "None" +"DevelopmentStatus@Core.Permissions": "None" +"Dining_sp_Area_co_Breakfast_sp_Bar": true +"ExistingLeaseType@Core.Permissions": "None" +"Interior_sp_Features_co_Wet_sp_Bar": true +"Laundry_co_Stacked_sp_WasherDryer2": true +"Location_sp_Tax_sp_Legal_co_Taxes2": 9737.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 +"BuyerAgentLastName@Core.Permissions": "None" +"CoBuyerOfficeEmail@Core.Permissions": "None" +"CoBuyerOfficeMlsId@Core.Permissions": "None" +"CoBuyerOfficePhone@Core.Permissions": "None" +"Kitchen_sp_Features_co_Refrigerator": true +"ListAgentVoiceMail@Core.Permissions": "None" +"ListOfficePhoneExt@Core.Permissions": "None" +"MaintenanceExpense@Core.Permissions": "None" +"NetOperatingIncome@Core.Permissions": "None" +"NumberOfUnitsTotal@Core.Permissions": "None" +"OffMarketTimestamp@Core.Permissions": "None" +"Other_sp_Rooms_co_BonusGame_sp_Room": true +"Possession_co_Close_sp_of_sp_Escrow": true +"ShowingContactType@Core.Permissions": "None" +"AdditionalParcelsYN@Core.Permissions": "None" +"BathroomsOneQuarter@Core.Permissions": "None" +"BuyerAgentFirstName@Core.Permissions": "None" +"BuyerAgentVoiceMail@Core.Permissions": "None" +"BuyerOfficePhoneExt@Core.Permissions": "None" +"Exterior_sp_Features_co_GazeboRamada": true +"FinancialDataSource@Core.Permissions": "None" +"ListAgentMiddleName@Core.Permissions": "None" +"ShowingInstructions@Core.Permissions": "None" +"AssociationAmenities@Core.Permissions": "None" +"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" +"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 +"Dining_sp_Area_co_Dining_sp_in_sp_LRGR": true +"DistanceToGasComments@Core.Permissions": "None" +"ListAgentStateLicense@Core.Permissions": "None" +"ListAgentVoiceMailExt@Core.Permissions": "None" +"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_Roof_sp_PartialFull": "Full" +"Kitchen_sp_Features_co_Electric_sp_Oven": true +"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_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": "Partial" +"Kitchen_sp_Features_co_Kitchen_sp_Island": true +"Kitchen_sp_Features_co_Multiple_sp_Ovens": true +"Landscaping_co_Natural_sp_Desert_sp_Back": 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" +"Exterior_sp_Features_co_Misting_sp_System": true +"Fireplace_sp_Features_co_Gas_sp_Fireplace": true +"Items_sp_Updated_co_Roof_sp_Yr_sp_Updated": "2023" +"Items_sp_Updated_co_Wiring_sp_PartialFull": "Partial" +"Landscaping_co_Synthetic_sp_Grass_sp_Back": true +"OperatingExpenseIncludes@Core.Permissions": "None" +"Parking_sp_Features_co_Attached_sp_Garage": true +"Plumbing_co_Electric_sp_Hot_sp_Wtr_sp_Htr": true +"Plumbing_co_Gas_sp_Hot_sp_Water_sp_Heater": true +"Property_sp_Description_co_Corner_sp_Lot4": true +"CoListAgentOfficePhoneExt@Core.Permissions": "None" +"Cooling_co_Ceiling_sp_Fan_lparen_s_rparen_": true +"Items_sp_Updated_co_Floor_sp_Yr_sp_Updated": "2025" +"Items_sp_Updated_co_Plmbg_sp_Yr_sp_Updated": "2025" +"Kitchen_sp_Features_co_Granite_sp_Counters": true +"New_sp_Financing_co_Owner_sp_May_sp_Carry2": true +"NumberOfFullTimeEmployees@Core.Permissions": "None" +"NumberOfPartTimeEmployees@Core.Permissions": "None" +"Parking_sp_Features_co_RV_sp_AccessParking": true +"DistanceToElectricComments@Core.Permissions": "None" +"Interior_sp_Features_co_Fire_sp_Sprinklers3": true +"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" +"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": "Y" +"Items_sp_Updated_co_Kitchen_sp_Yr_sp_Updated": "2025" +"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": 1.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" +"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": 0.0 +"ProfessionalManagementExpense@Core.Permissions": "None" +"DistanceToPhoneServiceComments@Core.Permissions": "None" +"General_sp_Property_sp_Description_co_PriceSqFt": 682.82 +"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_Features_co_Rear_sp_Vehicle_sp_Entry": true +"Parking_sp_Features_co_Side_sp_Vehicle_sp_Entry": 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" +"Location_sp_Tax_sp_Legal_co_Tax_sp_Municipality3": "Scottsdale" +"Association_sp_Fees_co_Land_sp_Lease_sp_Fee_sp_YN": "N" +"Additional_sp_Bedroom_co_Other_sp_Bedroom_sp_Split": 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_Ttl_sp_Mthly_sp_Fee_sp_Equiv": 0.0 +"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 +"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": 8194.0 +"General_sp_Property_sp_Description_co_High_sp_School": "Desert Mountain High School" +"General_sp_Property_sp_Description_co_Builder_sp_Name": "K A M Development" +"General_sp_Property_sp_Description_co_Fireplace_sp_YN2": "Yes" +"Location_sp_Tax_sp_Legal_co_Assessor_sp_Parcel_sp_Ltr3": "E" +"Exterior_sp_Features_co_Sport_sp_Court_lparen_s_rparen_": true +"General_sp_Property_sp_Description_co_Full_sp_Bathroom2": 7 +"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" +"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" +"Items_sp_Updated_co_Bath_lparen_s_rparen__sp_Yr_sp_Updated": "2025" +"General_sp_Property_sp_Description_co_Approx_sp_Lot_sp_SqFt": 88426.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.03 +"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": 31.0 +"General_sp_Property_sp_Description_co_High_sp_School_sp_District2": "Scottsdale Unified District" +"Location_sp_Tax_sp_Legal_co_Assessor_squote_s_sp_Parcel_sp__pound_3": 38.0 +"Additional_sp_Bedroom_co_Other_sp_Bedroom_sp_Walk_hyphen_in_sp_Closet": true +"Additional_sp_Bedroom_co_Master_sp_Bedroom_sp_Walk_hyphen_in_sp_Closet": true +"General_sp_Property_sp_Description_co_Elementary_sp_School_sp_District2": "Scottsdale Unified District" +"General_sp_Property_sp_Description_co__pound__sp_of_sp_Interior_sp_Levels": 2 +"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": "TH PT LOT 36 OR W2 NW4 SW4 NW4 SEC 25 DAF BEG SW COR OF SD LOT TH N 176.79F TH E 40F TO TPOB TH CONT" +"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('20251115223202284661000000')" +"provider_name": "ARMLS" +"SourceSystemPlatformID": "T00000052" +"SourceSystemPlatformName": "Flexmls" +"OriginatingSystemPlatformID": "T00000052" +"OriginatingSystemPlatformName": "Flexmls" +"Media": array:83 [ …83] +"DaysOnMarket": 0 +"ID": "49438" } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#18810 +post_id: "82942" +post_author: 1 +"ListingKey": "20260131172922825232000000" +"ListingId": "6977674" +"PropertyType": "Residential" +"PropertySubType": "Mfg/Mobile Housing" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-05-20T20:27:20Z" +"RFModificationTimestamp": "2026-05-20T20:32:27Z" +"ListPrice": 102000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 1456.0 +"BuildingAreaTotal": 0 +"City": "Buckeye" +"PostalCode": "85326" +"UnparsedAddress": "2000 S Apache Road 337, Buckeye, Arizona 85326" +"Coordinates": array:2 [ …2] +"Latitude": 33.428181 +"Longitude": -112.575987 +"YearBuilt": 2019 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Sunny Hwang" +"ListOfficeName": "eXp Realty" +"ListAgentMlsId": "sh1270" +"ListOfficeMlsId": "xpre01" +"OriginatingSystemName": "ARMLS" +"PublicRemarks": "Back On the Market - Motivated Seller!! Refrigerator included. Well-Maintained 2019 manufactured home in the desirable Buena Vista community in Buckeye. This single-level home offers 3 bedrooms, 2 baths, and approx. 1,456 sq. ft. with a bright, open layout and ample natural light. Recent updates include fresh exterior paint and low-maintenance desert landscaping. Located on a quiet street with desert views and convenient access to local amenities." +"Appliances": "Refrigerator,Built-in Microwave,Disposal,Electric Range,Electric Oven" +"ApprovalStatus": true +"AssociationFeeIncludes": array:1 [ …1] +"BathroomsFull": 2 +"BedroomsPossible": 3 +"BodyType": array:1 [ …1] +"BuilderName": "Clayton" +"BuildingAreaSource": "Assessor" +"CarportSpaces": "2.0" +"CommunityFeatures": "Pool,Gated,Community Spa,Playground,Biking/Walking Path,Fitness Center" +"ConstructionMaterials": array:2 [ …2] +"Cooling": "Ceiling Fan(s)" +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Maricopa" +"CoveredSpaces": "2.0" +"CreationDate": "2026-01-31T19:00:43.492112+00:00" +"CrossStreet": "South Apache Rd and Yuma Rd" +"Directions": "From I-10 W, exit Watson Rd, Left on Watson Rd; Right onto Yuma Rd, left onto S Apache Rd - Community on the right side ''Buena Vista'' to Lot 337" +"Disclosures": array:1 [ …1] +"DocumentsChangeTimestamp": "2026-02-09T23:43:12Z" +"ElementarySchool": "John S McCain III Elementary School" +"ElementarySchoolDistrict": "Buckeye Elementary District" +"ExteriorFeatures": "Playground,Sport Court(s),Storage,Built-in Barbecue" +"Fencing": array:1 [ …1] +"Flooring": "Carpet,Laminate" +"Heating": "Electric" +"HeatingYN": true +"HighSchool": "Buckeye Union High School" +"HighSchoolDistrict": "Buckeye Union High School District" +"InteriorFeatures": "Separate Shwr & Tub" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LandLeaseAmount": "687.0" +"LandLeaseAmountFrequency": "Monthly" +"LandLeaseYN": true +"LaundryFeatures": array:1 [ …1] +"ListAgentAOR": "We SERV" +"ListAgentFirstName": "Sunny" +"ListAgentKey": "20231109232518917751000000" +"ListAgentLastName": "Hwang" +"ListAgentPreferredPhone": "602-540-0636" +"ListAgentURL": "https://www.facebook.com/profile.php?id=61554700066732" +"ListOfficeEmail": "az.broker@exprealty.net" +"ListOfficeKey": "20091109230618809261000000" +"ListOfficePhone": "888-897-7821" +"ListOfficeURL": "http://www.exprealty.com" +"ListingContractDate": "2026-01-31" +"ListingTerms": "Cash,Conventional" +"LivingAreaSource": "Assessor" +"LotFeatures": array:3 [ …3] +"LotSizeSource": "Assessor" +"MajorChangeTimestamp": "2026-05-20T19:20:41Z" +"MajorChangeType": "Price Reduced" +"MiddleOrJuniorSchool": "John S McCain III Elementary School" +"MlsStatus": "Active" +"OriginalEntryTimestamp": "2026-01-31T18:52:27Z" +"OriginatingSystemID": "M00000048" +"OriginatingSystemKey": "20260131172922825232000000" +"Ownership": "Leasehold" +"ParcelNumber": "988-83-175" +"ParkingFeatures": "Attached Carport" +"PatioAndPorchFeatures": array:1 [ …1] +"PhotosChangeTimestamp": "2026-05-20T20:26:52Z" +"PhotosCount": 17 +"Possession": array:1 [ …1] +"PostalCity": "Buckeye" +"PriceChangeTimestamp": "2026-05-20T19:20:41Z" +"RoadSurfaceType": array:1 [ …1] +"Roof": "Composition" +"Sewer": "Public Sewer" +"SourceSystemID": "M00000048" +"SourceSystemKey": "20260131172922825232000000" +"SourceSystemName": "Arizona Regional Multiple Listing Service (ARMLS)" +"SpaFeatures": array:1 [ …1] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "AZ" +"StatusChangeTimestamp": "2026-04-24T14:46:30Z" +"StoriesTotal": "1" +"StreetDirPrefix": "S" +"StreetName": "Apache" +"StreetNumber": "2000" +"StreetNumberNumeric": "2000" +"StreetSuffix": "Road" +"SubdivisionName": "Buena Vista" +"TaxAnnualAmount": "681.13" +"TaxBookNumber": "988.00" +"TaxLot": "337" +"TaxMapNumber": "83.00" +"TaxYear": "2025" +"UnitNumber": "337" +"Utilities": "Phone Available" +"WaterSource": array:1 [ …1] +"WindowFeatures": array:3 [ …3] +"Spa_co_None14": true +"Utilities_co_APS": true +"Fencing_co_None11": true +"Flooring_co_Carpet": true +"Heating_co_Electric": true +"Flooring_co_Laminate": true +"Skirt@Core.Permissions": "None" +"Levels@Core.Permissions": "None" +"Zoning@Core.Permissions": "None" +"CapRate@Core.Permissions": "None" +"Stories@Core.Permissions": "None" +"GarageYN@Core.Permissions": "None" +"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" +"BusinessName@Core.Permissions": "None" +"BusinessType@Core.Permissions": "None" +"BuyerTeamKey@Core.Permissions": "None" +"DaysOnMarket@Core.Permissions": "None" +"Exterior_sp_Features_co_Patio": 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" +"Community_sp_Features_co_Gated": 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" +"PrivateRemarks@Core.Permissions": "None" +"Utilities_co_Phone_sp_Available": true +"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": "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" +"InsuranceExpense@Core.Permissions": "None" +"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" +"DevelopmentStatus@Core.Permissions": "None" +"ExistingLeaseType@Core.Permissions": "None" +"Landscaping_co_GravelStone_sp_Back": true +"Location_sp_Tax_sp_Legal_co_Taxes2": 681.13 +"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" +"Dining_sp_Area_co_Breakfast_sp_Nook": 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" +"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" +"Exterior_sp_Features_co_Open_sp_Deck": true +"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" +"BuyerAgentMiddleName@Core.Permissions": "None" +"CoListAgentVoiceMail@Core.Permissions": "None" +"CoListOfficePhoneExt@Core.Permissions": "None" +"Community_sp_Pool_sp_Features_co_Lap2": true +"Contract_sp_Information_co_Ownership2": "Leasehold" +"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" +"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" +"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" +"Kitchen_sp_Features_co_Electric_sp_Oven": true +"Laundry_co_220_sp_V_sp_Dryer_sp_Hookup2": true +"ListAgentTollFreePhone@Core.Permissions": "None" +"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" +"Community_sp_Pool_sp_Features_co_Fenced5": true +"Community_sp_Pool_sp_Features_co_Outdoor": true +"DistanceToSewerComments@Core.Permissions": "None" +"DistanceToWaterComments@Core.Permissions": "None" +"Kitchen_sp_Features_co_Electric_sp_Range": true +"ListAgentOfficePhoneExt@Core.Permissions": "None" +"BuyerAgentOfficePhoneExt@Core.Permissions": "None" +"CoListAgentTollFreePhone@Core.Permissions": "None" +"Construction_co_Frame_sp__hyphen__sp_Wood": true +"ContractStatusChangeDate@Core.Permissions": "None" +"OperatingExpenseIncludes@Core.Permissions": "None" +"CoListAgentOfficePhoneExt@Core.Permissions": "None" +"Community_sp_Features_co_Community_sp_Spa2": true +"Cooling_co_Ceiling_sp_Fan_lparen_s_rparen_": true +"NumberOfFullTimeEmployees@Core.Permissions": "None" +"NumberOfPartTimeEmployees@Core.Permissions": "None" +"Parking_sp_Features_co_Attached_sp_Carport": true +"Showing_sp_Notification_sp_Methods_co_Text": true +"Association_sp_Fees_co_Land_sp_Lease_sp_Fee": 687.0 +"DistanceToElectricComments@Core.Permissions": "None" +"ListAgentPreferredPhoneExt@Core.Permissions": "None" +"BuyerAgentPreferredPhoneExt@Core.Permissions": "None" +"Community_sp_Features_co_Workout_sp_Facility": true +"General_sp_Property_sp_Description_co_Horses": "N" +"Location_sp_Tax_sp_Legal_co_Unit_sp__pound_3": "337" +"CoListAgentPreferredPhoneExt@Core.Permissions": "None" +"Community_sp_Features_co_ClubhouseRec_sp_Room": true +"Master_sp_Bathroom_co_Separate_sp_Shwr_sp_Tub": true +"MiddleOrJuniorSchoolDistrict@Core.Permissions": "None" +"Community_sp_Features_co_BikingWalking_sp_Path": true +"Exterior_sp_Features_co_Built_hyphen_in_sp_BBQ": true +"Parking_sp_Spaces_co_Slab_sp_Parking_sp_Spaces": 0.0 +"ProfessionalManagementExpense@Core.Permissions": "None" +"DistanceToPhoneServiceComments@Core.Permissions": "None" +"General_sp_Property_sp_Description_co_PriceSqFt": 70.05 +"Parking_sp_Spaces_co_Total_sp_Covered_sp_Spaces": 2.0 +"Separate_sp_DenOffice_co_Sep_sp_DenOffice_sp_YN": "N" +"TaxOtherAnnualAssessmentAmount@Core.Permissions": "None" +"Community_sp_Pool_sp_Features_co_Diving_sp_Pool3": true +"Location_sp_Tax_sp_Legal_co_Tax_sp_Municipality3": "Maricopa - COUNTY" +"Association_sp_Fees_co_Land_sp_Lease_sp_Fee_sp_YN": "Y" +"Exterior_sp_Features_co_Childrens_sp_Play_sp_Area": true +"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 +"Manufactured_sp_Home_sp_Features_co_Double_sp_Wide": true +"Association_sp_Fees_co_Ttl_sp_Mthly_sp_Fee_sp_Equiv": 687.0 +"Kitchen_sp_Features_co_Built_hyphen_in_sp_Microwave": true +"Showing_sp_Notification_sp_Methods_co_Phone_sp_Call": true +"Existing_sp_1st_sp_Loan_co_Treat_sp_as_sp_FreeClear4": true +"General_sp_Property_sp_Description_co_Approx_sp_SQFT": 1456.0 +"General_sp_Property_sp_Description_co_High_sp_School": "Buckeye Union High School" +"General_sp_Property_sp_Description_co_Builder_sp_Name": "Clayton" +"Community_sp_Features_co_Children_squote_s_sp_Playgrnd": true +"General_sp_Property_sp_Description_co_Fireplace_sp_YN2": "No" +"Exterior_sp_Features_co_Sport_sp_Court_lparen_s_rparen_": true +"General_sp_Property_sp_Description_co_Full_sp_Bathroom2": 2 +"General_sp_Property_sp_Description_co_Dwelling_sp_Styles": "Detached" +"General_sp_Property_sp_Description_co_Half_sp_Bathrooms2": 0.0 +"Showing_sp_Notification_sp_Methods_co_Showing_sp_Service": "Aligned Showings" +"General_sp_Property_sp_Description_co_Elementary_sp_School": "John S McCain III Elementary School" +"General_sp_Property_sp_Description_co_Jr_sp_High_sp_School": "John S McCain III Elementary School" +"General_sp_Property_sp_Description_co_Approx_sp_Lot_sp_SqFt": 0.0 +"General_sp_Property_sp_Description_co_Private_sp_Pool_sp_YN2": "No" +"General_sp_Property_sp_Description_co_Approx_sp_Lot_sp_Acres2": 0.0 +"General_sp_Property_sp_Description_co_Planned_sp_Comm_sp_Name": "Buena Vista" +"General_sp_Property_sp_Description_co_Community_sp_Pool_sp_YN2": "Yes" +"Location_sp_Tax_sp_Legal_co_Assessor_squote_s_sp_Map_sp__pound_3": 83.0 +"General_sp_Property_sp_Description_co_High_sp_School_sp_District2": "Buckeye Union High School District" +"Association_sp_Fees_co_Land_sp_Lease_sp_Pd_sp__lparen_Freq_rparen_": "Monthly" +"Location_sp_Tax_sp_Legal_co_Assessor_squote_s_sp_Parcel_sp__pound_3": 175.0 +"General_sp_Property_sp_Description_co_Elementary_sp_School_sp_District2": "Buckeye Elementary District" +"General_sp_Property_sp_Description_co__pound__sp_of_sp_Interior_sp_Levels": 1 +"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('20260131172922825232000000')" +"provider_name": "ARMLS" +"SourceSystemPlatformID": "T00000052" +"SourceSystemPlatformName": "Flexmls" +"OriginatingSystemPlatformID": "T00000052" +"OriginatingSystemPlatformName": "Flexmls" +"Media": array:17 [ …17] +"DaysOnMarket": 0 +"ID": "82942" } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#18807 +post_id: "74661" +post_author: 1 +"ListingKey": "20260116000117993258000000" +"ListingId": "6969312" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-05-20T20:14:14Z" +"RFModificationTimestamp": "2026-05-20T20:29:08Z" +"ListPrice": 5999999.0 +"BathroomsTotalInteger": 6.0 +"BathroomsHalf": 1 +"BedroomsTotal": 6.0 +"LotSizeArea": 43966.0 +"LivingArea": 6893.0 +"BuildingAreaTotal": 0 +"City": "Paradise Valley" +"PostalCode": "85253" +"UnparsedAddress": "6718 E San Juan Avenue, Paradise Valley, Arizona 85253" +"Coordinates": array:2 [ …2] +"Latitude": 33.518054 +"Longitude": -111.934913 +"YearBuilt": 1987 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Michael J. D'Elena" +"ListOfficeName": "RETSY" +"ListAgentMlsId": "md941" +"ListOfficeMlsId": "rets001" +"OriginatingSystemName": "ARMLS" +"PublicRemarks": "Situated in the heart of Paradise Valley, this exceptional estate is the result of a stunning 2-year, $2M rebuild and must be seen to be fully appreciated. Minutes from Fashion Square and surrounded by premier luxury estates, the expansive 6,300sf single level home offers 5 bedrooms, 5.5 baths, plus a den and teen room, along with a detached 570sf guest house. Interior highlights include white oak flooring t/o, soaring ceilings, incredible scale in every room, a wine cellar, smart lighting, pre-wiring for Crestron and Control4, and a chef's kitchen with Wolf and Sub-Zero appliances. Set on a full acre, the resort-style grounds feature a pool, covered patio, sport court, built-in BBQ, lush lawns, owned solar, RV parking, and a 6-car garage—an extraordinary Paradise Valley offering." +"Appliances": "Dryer,Washer,Built In Recycling,Reverse Osmosis,Refrigerator,Built-in Microwave,Dishwasher,Disposal,Gas Cooktop,Built-In Gas Oven" +"ApprovalStatus": true +"ArchitecturalStyle": "Santa Barbara/Tuscan" +"AssociationFeeIncludes": array:1 [ …1] +"BathroomsFull": 5 +"BedroomsPossible": 8 +"BuilderName": "Unknown" +"BuildingAreaSource": "Assessor" +"ConstructionMaterials": array:5 [ …5] +"Cooling": "Central Air,Ceiling Fan(s),Programmable Thmstat" +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Maricopa" +"CoveredSpaces": "6.0" +"CreationDate": "2026-01-16T00:56:17.724738+00:00" +"CrossStreet": "Scottsdale Road & Jackrabbit" +"Directions": "Heading west on Jackrabbit, make a right on N 67th Place. Home is in the right on the corner of 67th Place and San Juan Avenue." +"Disclosures": array:2 [ …2] +"DocumentsChangeTimestamp": "2026-01-16T00:50:55Z" +"ElementarySchool": "Kiva Elementary School" +"ElementarySchoolDistrict": "Scottsdale Unified District" +"ExteriorFeatures": "Playground,Private Street(s),Private Yard,Sport Court(s),Storage,Built-in Barbecue" +"Fencing": array:1 [ …1] +"FireplaceFeatures": array:4 [ …4] +"FireplaceYN": true +"FireplacesTotal": "2" +"Flooring": "Tile,Wood" +"GarageSpaces": "6.0" +"GreenEnergyEfficient": array:2 [ …2] +"GreenWaterConservation": array:1 [ …1] +"Heating": "Electric,Natural Gas" +"HeatingYN": true +"HighSchool": "Saguaro High School" +"HighSchoolDistrict": "Scottsdale Unified District" +"InteriorFeatures": "Walk-in Pantry,Quartz Countertops,High Speed Internet,Smart Home,Double Vanity,Other,Master Downstairs,Eat-in Kitchen,Breakfast Bar,9+ Flat Ceilings,No Interior Steps,Vaulted Ceiling(s),Kitchen Island,Pantry,Full Bth Master Bdrm,Separate Shwr & Tub" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:2 [ …2] +"ListAgentAOR": "We SERV" +"ListAgentFirstName": "Michael" +"ListAgentKey": "20120822224049162293000000" +"ListAgentLastName": "D'Elena" +"ListAgentPreferredPhone": "602-317-4761" +"ListAgentURL": "https://housed.com" +"ListOfficeEmail": "Matthew@Retsy.com" +"ListOfficeKey": "20201002205528843921000000" +"ListOfficePhone": "602-842-0000" +"ListOfficeURL": "www.RETSY.com" +"ListingContractDate": "2026-01-15" +"ListingTerms": "Cash,Conventional,Also for Rent,VA Loan" +"LivingAreaSource": "Assessor" +"LotFeatures": array:14 [ …14] +"LotSizeAcres": 1.01 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 43966.0 +"MajorChangeTimestamp": "2026-05-20T20:13:20Z" +"MajorChangeType": "Price Reduced" +"MiddleOrJuniorSchool": "Mohave Middle School" +"MlsStatus": "Active" +"OpenParkingSpaces": "12.0" +"OriginalEntryTimestamp": "2026-01-16T00:50:53Z" +"OriginatingSystemID": "M00000048" +"OriginatingSystemKey": "20260116000117993258000000" +"OtherStructures": array:1 [ …1] +"Ownership": "Fee Simple" +"ParcelNumber": "173-11-028" +"ParkingFeatures": "Attached Garage,Detached Garage,RV Access/Parking,RV Gate,Garage Door Opener,Direct Access,Circular Driveway,Over Height Garage,Separate Strge Area,Side Vehicle Entry" +"PatioAndPorchFeatures": array:2 [ …2] +"PhotosChangeTimestamp": "2026-05-20T20:13:45Z" +"PhotosCount": 35 +"PoolFeatures": "Variable Speed Pump,Outdoor,Play Pool,Fenced,Heated" +"PoolPrivateYN": true +"Possession": array:1 [ …1] +"PostalCity": "Paradise Valley" +"PostalCodePlus4": "5965" +"PriceChangeTimestamp": "2026-05-20T20:13:20Z" +"PublicSurveyRange": "4E" +"PublicSurveySection": "15" +"RoadResponsibility": array:1 [ …1] +"Roof": "Tile,Concrete,Foam" +"SecurityFeatures": array:2 [ …2] +"Sewer": "Public Sewer" +"SourceSystemID": "M00000048" +"SourceSystemKey": "20260116000117993258000000" +"SourceSystemName": "Arizona Regional Multiple Listing Service (ARMLS)" +"SpaFeatures": array:1 [ …1] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "AZ" +"StatusChangeTimestamp": "2026-01-16T00:50:53Z" +"StoriesTotal": "1" +"StreetDirPrefix": "E" +"StreetName": "SAN JUAN" +"StreetNumber": "6718" +"StreetNumberNumeric": "6718" +"StreetSuffix": "Avenue" +"SubdivisionName": "TIERRA DEL PARAISO" +"TaxAnnualAmount": "10397.0" +"TaxBookNumber": "173.00" +"TaxLegalDescription": "LOT 21 TIERRA DEL PARAISO MCR" +"TaxLot": "21" +"TaxMapNumber": "11.00" +"TaxYear": "2025" +"Township": "2N" +"Utilities": "Propane" +"View": array:1 [ …1] +"WaterSource": array:1 [ …1] +"WindowFeatures": array:5 [ …5] +"Spa_co_None14": true +"Roofing_co_Foam": true +"Flooring_co_Tile": true +"Flooring_co_Wood": true +"Roofing_co_Tile2": true +"Utilities_co_APS": true +"Fencing_co_Block2": true +"Laundry_co_Inside2": true +"Heating_co_Electric": true +"Roofing_co_Concrete4": true +"Construction_co_Block": true +"Legal_sp_Info_co_Range": "4E" +"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" +"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": "15" +"New_sp_Financing_co_Cash2": true +"ParkName@Core.Permissions": "None" +"Basement_co_Basement_sp_YN": "N" +"Furnished@Core.Permissions": "None" +"Master_sp_Bedroom_co_Split": true +"OwnerName@Core.Permissions": "None" +"OwnerPays@Core.Permissions": "None" +"Utilities_co_ButanePropane": true +"AccessCode@Core.Permissions": "None" +"CurrentUse@Core.Permissions": "None" +"Disclaimer@Core.Permissions": "None" +"OwnerPhone@Core.Permissions": "None" +"Technology_co_Smart_sp_Home": true +"Topography@Core.Permissions": "None" +"Vegetation@Core.Permissions": "None" +"Assoc_sp_RulesInfo_co_None17": 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" +"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" +"Solar_sp_Panels_co_Ownership3": "Owned Outright" +"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" +"Interior_sp_Features_co_Other7": true +"Landscaping_co_Desert_sp_Front": true +"Laundry_co_Washer_sp_Included2": true +"ListOfficeAOR@Core.Permissions": "None" +"OwnershipType@Core.Permissions": "None" …290 } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#18700 …453} 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#18813 …494} 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#18814 …368} ] +success: true +page_size: 9 +page_count: 56 +count: 498 +after_key: "" } "RF Response Time" => "0.11 seconds" ] "RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp DESC&$top=9&$skip=18&$filter=(StandardStatus ne 'Closed') and (ExteriorFeatures eq 'Sport Court(s)' OR InteriorFeatures eq 'Sport Court(s)' OR Appliances eq 'Sport Court(s)')&$expand=Media&$count=true" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#21344 +items: array:9 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#21350 …431} 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#21348 …451} 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#21353 …495} 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#21347 …475} 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#21349 …397} 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#21354 …507} 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#21355 …453} 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#21346 …494} 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#21345 …368} ] +success: true +page_size: 9 +page_count: 56 +count: 498 +after_key: "" } "RF Response Time" => "0.12 seconds" ] ]