array:2 [
"RF Cache Key: fa747d68dd3c4b3933357b004e4314a6b6e3412e03c0bb12021fac1b22dc9bde" => array:1 [
"RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#4855
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6005
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "20240124175944766175000000"
+"ListingId": "6655117"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-06-01T07:01:24Z"
+"RFModificationTimestamp": "2025-06-01T07:05:57.852716+00:00"
+"ListPrice": 3395000.0
+"BathroomsTotalInteger": 5.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 10716.0
+"LivingArea": 3290.0
+"BuildingAreaTotal": 0
+"City": "Scottsdale"
+"PostalCode": "85262"
+"UnparsedAddress": "28119 N 109th Way, Scottsdale, Az 85262"
+"Coordinates": array:2 [
0 => -111.844503
1 => 33.739614
]
+"Latitude": 33.739614
+"Longitude": -111.844503
+"YearBuilt": 2025
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Mike Domer"
+"ListOfficeName": "Compass"
+"ListAgentMlsId": "md257"
+"ListOfficeMlsId": "laun005"
+"OriginatingSystemName": "ARMLS"
+"PublicRemarks": "This newly completed Serene Model B has 3,290/sf and has been highly upgraded by EST EST designers with lavish interior finishes including Travertine tiled walls, double sided see through fireplace, double island kitchen, wood flooring throughout, white oak tongue and groove ceiling in the Great room and primary suite, posh primary suite with spa like back and Appliances by Sub-Zero, & Wolf. The backyard includes a stunning pool with a 360 degree negative edge spa, fire pit and BBQ. Also included is a 3 car tandem garage, fully landscaped yard. Serene is Located on the North East side of Pinnacle Peak Mountain in North Scottsdale, Serene is close to shopping, restaurants and over two dozen private and public golf courses. Don't miss your opportunity to take part in the Serene lifestyle"
+"ApprovalStatus": true
+"ArchitecturalStyle": array:1 [
0 => "Contemporary"
]
+"AssociationFee": "250.0"
+"AssociationFee2": "300.0"
+"AssociationFee2Frequency": "Annually"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Maintenance Grounds"
1 => "Street Maint"
]
+"AssociationName2": "Troon North Ass."
+"AssociationPhone": "602-667-3145"
+"AssociationPhone2": "602-336-2700"
+"AssociationYN": true
+"BathroomsTotalDecimal": 4.5
+"BedroomsPossible": 4
+"BuilderName": "Sonora West Development"
+"BuildingAreaSource": "Architect"
+"CommunityFeatures": array:1 [
0 => "Gated"
]
+"ConstructionMaterials": array:3 [
0 => "Spray Foam Insulation"
1 => "Stucco"
2 => "Wood Frame"
]
+"ContractStatusChangeDate": "2024-01-25"
+"Cooling": array:1 [
0 => "Central Air"
]
+"CoolingYN": true
+"Country": "US"
+"CountyOrParish": "Maricopa"
+"CoveredSpaces": "3.0"
+"CreationDate": "2024-08-25T04:34:59.396936+00:00"
+"CrossStreet": "Dynamite and Alma School"
+"Directions": "From Pima Rd go East on Dynamite to Alma School then South (right) to first Street/entrance past plaza to Serene on West side of Rd."
+"Disclosures": array:1 [
0 => "Agency Discl Req"
]
+"DocumentsChangeTimestamp": "2024-01-26T16:02:01Z"
+"DocumentsCount": 2
+"ElementarySchool": "Desert Sun Academy"
+"ElementarySchoolDistrict": "Cave Creek Unified District"
+"Fencing": array:1 [
0 => "Block"
]
+"FireplaceFeatures": array:3 [
0 => "1 Fireplace"
1 => "Two Way Fireplace"
2 => "Gas"
]
+"FireplaceYN": true
+"GarageSpaces": "3.0"
+"Heating": array:1 [
0 => "Natural Gas"
]
+"HeatingYN": true
+"HighSchool": "Cactus Shadows High School"
+"HighSchoolDistrict": "Cave Creek Unified District"
+"InteriorFeatures": array:5 [
0 => "Granite Counters"
1 => "Double Vanity"
2 => "Breakfast Bar"
3 => "Kitchen Island"
4 => "Separate Shwr & Tub"
]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [
0 => "Wshr/Dry HookUp Only"
]
+"ListAgentAOR": "Scottsdale"
+"ListAgentFirstName": "Mike"
+"ListAgentKey": "20071208002318568431000000"
+"ListAgentLastName": "Domer"
+"ListAgentPreferredPhone": "480-861-8883"
+"ListAgentURL": "http://www.mikedomer.com/"
+"ListOfficeEmail": "[email protected]"
+"ListOfficeKey": "20180801182601765478000000"
+"ListOfficePhone": "480-776-1555"
+"ListOfficeURL": "www.azhomes.com"
+"ListingContractDate": "2024-01-25"
+"ListingTerms": array:2 [
0 => "Cash"
1 => "Conventional"
]
+"LivingAreaSource": "Architect"
+"LotFeatures": array:2 [
0 => "Desert Back"
1 => "Desert Front"
]
+"LotSizeAcres": 0.25
+"LotSizeSource": "Assessor"
+"LotSizeSquareFeet": 10716.0
+"MiddleOrJuniorSchool": "Sonoran Trails Middle School"
+"MlsStatus": "Active"
+"Model": "Model B"
+"OriginalEntryTimestamp": "2024-01-25T17:41:07Z"
+"OriginatingSystemID": "M00000048"
+"OriginatingSystemKey": "20240124175944766175000000"
+"ParcelNumber": "216-81-384"
+"ParkingFeatures": array:2 [
0 => "Tandem Garage"
1 => "Garage Door Opener"
]
+"PhotosChangeTimestamp": "2025-01-15T18:43:31Z"
+"PhotosCount": 50
+"PoolFeatures": array:1 [
0 => "Private"
]
+"PoolPrivateYN": true
+"Possession": array:1 [
0 => "Close Of Escrow"
]
+"PostalCity": "Scottsdale"
+"PriceChangeTimestamp": "2025-05-09T23:21:37Z"
+"PropertyCondition": array:1 [
0 => "To Be Built"
]
+"PublicSurveyRange": "5E"
+"PublicSurveySection": "33"
+"Roof": array:1 [
0 => "Built-Up"
]
+"Sewer": array:1 [
0 => "Public Sewer"
]
+"SourceSystemID": "M00000048"
+"SourceSystemKey": "20240124175944766175000000"
+"SourceSystemName": "Arizona Regional Multiple Listing Service (ARMLS)"
+"SpaFeatures": array:1 [
0 => "None"
]
+"SpecialListingConditions": array:1 [
0 => "Owner/Agent"
]
+"StateOrProvince": "AZ"
+"StatusChangeTimestamp": "2024-01-25T16:41:06Z"
+"StoriesTotal": "1"
+"StreetDirPrefix": "N"
+"StreetName": "109TH"
+"StreetNumber": "28119"
+"StreetNumberNumeric": "28119"
+"StreetSuffix": "Way"
+"SubdivisionName": "SERENE aka BELLA SOL AT TROON NORTH"
+"TaxAnnualAmount": "13000.0"
+"TaxBookNumber": "216.00"
+"TaxLegalDescription": "LOT 1 BELLA SOL AT TROON NORTH MCR 099703"
+"TaxLot": "1"
+"TaxMapNumber": "81.00"
+"TaxYear": "2023"
+"Township": "5N"
+"View": array:1 [
0 => "Mountain(s)"
]
+"WaterSource": array:1 [
0 => "City Water"
]
+"Spa_co_None14": true
+"Utilities_co_APS": true
+"Fencing_co_Block2": true
+"Architect_co_Architect": "Swaback & Planners"
+"Legal_sp_Info_co_Range": "5E"
+"[email protected]": "None"
+"[email protected]": "None"
+"Utilities_co_SW_sp_Gas3": true
+"[email protected]": "None"
+"[email protected]": "None"
+"Dining_sp_Area_co_Formal": true
+"[email protected]": "None"
+"Cooling_co_Central_sp_Air": true
+"[email protected]": "None"
+"Heating_co_Natural_sp_Gas": true
+"Legal_sp_Info_co_Section2": "33"
+"Lockbox_sp_Type_co_None43": true
+"New_sp_Financing_co_Cash2": true
+"[email protected]": "None"
+"Basement_co_Basement_sp_YN": "N"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Roofing_co_Built_hyphen_Up": true
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Architecture_co_Contemporary": true
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Pool_sp_Features_co_Private2": true
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Landscaping_co_Desert_sp_Back": true
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Community_sp_Features_co_Gated": true
+"Landscaping_co_Desert_sp_Front": true
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Contract_sp_Information_co_Type3": "Exclusive Right To Sell"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Water_sp_Source_co_City_sp_Water": true
+"Association_sp_Fees_co_HOA_sp_YN2": "Y"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"New_sp_Financing_co_Conventional5": true
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Association_sp_Fees_co_HOA_sp_Fee2": 250.0
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Dining_sp_Area_co_Breakfast_sp_Bar": true
+"[email protected]": "None"
+"[email protected]": "None"
+"Location_sp_Tax_sp_Legal_co_Taxes2": 13000.0
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Association_sp_Fees_co_HOA_sp_Name4": "Serene Property Ass."
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Kitchen_sp_Features_co_Refrigerator": true
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Possession_co_Close_sp_of_sp_Escrow": true
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Laundry_co_WshrDry_sp_HookUp_sp_Only": true
+"[email protected]": "None"
+"Sewer_co_Sewer_sp__hyphen__sp_Public": true
+"[email protected]": "None"
+"[email protected]": "None"
+"Association_sp_Fees_co_HOA_sp_2_sp_YN": "Y"
+"Association_sp_Fees_co_HOA_sp_3_sp_YN": "N"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Const_sp__hyphen__sp_Finish_co_Stucco": true
+"Contract_sp_Information_co_Ownership2": "Fee Simple"
+"Disclosures_co_Agency_sp_Discl_sp_Req": true
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Master_sp_Bathroom_co_Double_sp_Sinks": true
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Association_sp_Fees_co_HOA_sp_2_sp_Name": "Troon North Ass."
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Fireplace_sp_Features_co_1_sp_Fireplace": true
+"Kitchen_sp_Features_co_RangeOven_sp_Gas": true
+"[email protected]": "None"
+"Parking_sp_Features_co_Tandem_sp_Garage": true
+"Association_sp_Fees_co_HOA_sp_Telephone4": "602-667-3145"
+"Association_sp_Fees_co_PAD_sp_Fee_sp_YN2": "N"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Kitchen_sp_Features_co_Kitchen_sp_Island": true
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Construction_co_Frame_sp__hyphen__sp_Wood": true
+"Construction_co_Spray_sp_Foam_sp_Insulatn": true
+"Fireplace_sp_Features_co_Gas_sp_Fireplace": true
+"[email protected]": "None"
+"Special_sp_Listing_sp_Cond_co_OwnerAgent4": true
+"[email protected]": "None"
+"General_sp_Property_sp_Description_co_Pool": "Private Only"
+"Kitchen_sp_Features_co_Granite_sp_Counters": true
+"[email protected]": "None"
+"[email protected]": "None"
+"Showing_sp_Notification_sp_Methods_co_Text": true
+"Association_sp_Fees_co_Other_sp_Fees_sp_HOA": 0.0
+"Construction_sp_Status_co_To_sp_Be_sp_Built": true
+"[email protected]": "None"
+"General_sp_Property_sp_Description_co_Model": "Model B"
+"[email protected]": "None"
+"Association_sp_Fees_co_HOA_sp_2_sp_Telephone": "602-336-2700"
+"[email protected]": "None"
+"General_sp_Property_sp_Description_co_Horses": "N"
+"Association_sp_Fee_sp_Incl_co_Street_sp_Maint": true
+"[email protected]": "None"
+"Master_sp_Bathroom_co_Separate_sp_Shwr_sp_Tub": true
+"[email protected]": "None"
+"Association_sp_Fees_co_HOA_sp_Transfer_sp_Fee2": 1000.0
+"Parking_sp_Spaces_co_Slab_sp_Parking_sp_Spaces": 0.0
+"[email protected]": "None"
+"Association_sp_Fees_co_HOA_sp_Paid_sp_Frequency": "Monthly"
+"[email protected]": "None"
+"General_sp_Property_sp_Description_co_PriceSqFt": 1031.91
+"Kitchen_sp_Features_co_Walk_hyphen_in_sp_Pantry": true
+"Master_sp_Bathroom_co_Private_sp_Toilet_sp_Room": true
+"Parking_sp_Features_co_Garage_sp_Door_sp_Opener": true
+"Parking_sp_Spaces_co_Total_sp_Covered_sp_Spaces": 3.0
+"Separate_sp_DenOffice_co_Sep_sp_DenOffice_sp_YN": "N"
+"[email protected]": "None"
+"Association_sp_Fees_co_Disclosure_sp_Fees_sp_HOA": 400.0
+"Fireplace_sp_Features_co_Two_sp_Way_sp_Fireplace": true
+"Location_sp_Tax_sp_Legal_co_Tax_sp_Municipality3": "Scottsdale"
+"Association_sp_Fees_co_Land_sp_Lease_sp_Fee_sp_YN": "N"
+"Association_sp_Fees_co_Rec_sp_Center_sp_Fee_sp_YN": "N"
+"Association_sp_Fees_co_HOA_sp_2_sp_Transfer_sp_Fee": 155.0
+"Association_sp_Fees_co_Special_sp_Assessment_sp_HOA": "No"
+"Association_sp_Fees_co_Ttl_sp_Mthly_sp_Fee_sp_Equiv": 275.0
+"Kitchen_sp_Features_co_Built_hyphen_in_sp_Microwave": true
+"Association_sp_Fees_co_HOA_sp_Paid_sp_Frequency_sp_2": "Annually"
+"Existing_sp_1st_sp_Loan_co_Treat_sp_as_sp_FreeClear4": true
+"General_sp_Property_sp_Description_co_Approx_sp_SQFT": 3290.0
+"General_sp_Property_sp_Description_co_High_sp_School": "Cactus Shadows High School"
+"Association_sp_Fees_co_Disclosure_sp_Fees_sp_HOA_sp_2": 245.0
+"General_sp_Property_sp_Description_co_Builder_sp_Name": "Sonora West Development"
+"Association_sp_Fee_sp_Incl_co_Common_sp_Area_sp_Maint3": true
+"Association_sp_Fees_co_Cap_sp_ImprovementImpact_sp_Fee": 0.0
+"Association_sp_Fees_co_Rec_sp_Center_sp_Fee_sp_2_sp_YN": "N"
+"Association_sp_Fees_co_Special_sp_Assessment_sp_HOA_sp_2": "No"
+"General_sp_Property_sp_Description_co_Dwelling_sp_Styles": "Detached"
+"General_sp_Property_sp_Description_co_Marketing_sp_Name3": "SERENE"
+"Showing_sp_Notification_sp_Methods_co_Showing_sp_Service": "Aligned Showings"
+"General_sp_Property_sp_Description_co_Elementary_sp_School": "Desert Sun Academy"
+"General_sp_Property_sp_Description_co_Jr_sp_High_sp_School": "Sonoran Trails Middle School"
+"Association_sp_Fees_co_Cap_sp_ImprovementImpact_sp_Fee_sp_2": 0.0
+"General_sp_Property_sp_Description_co_Approx_sp_Lot_sp_SqFt": 10716.0
+"Association_sp_Fees_co_Prepaid_sp_Association_sp_Fees_sp_HOA": 250.0
+"General_sp_Property_sp_Description_co_Approx_sp_Lot_sp_Acres2": 0.246
+"Property_sp_Description_co_Mountain_sp_View_lparen_s_rparen_2": true
+"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": 81.0
+"Association_sp_Fees_co_Prepaid_sp_Association_sp_Fees_sp_HOA_sp_2": 300.0
+"General_sp_Property_sp_Description_co_High_sp_School_sp_District2": "Cave Creek Unified District"
+"Association_sp_Fees_co_Cap_sp_ImprovementImpact_sp_Fee_sp__percent_": "$"
+"Location_sp_Tax_sp_Legal_co_Assessor_squote_s_sp_Parcel_sp__pound_3": 384.0
+"Assoc_sp_RulesInfo_co_No_sp_Visible_sp_Truck_sp_Trailer_sp_RV_sp_Boat": true
+"Additional_sp_Bedroom_co_Master_sp_Bedroom_sp_Walk_hyphen_in_sp_Closet": true
+"General_sp_Property_sp_Description_co_Elementary_sp_School_sp_District2": "Cave Creek Unified District"
+"Association_sp_Fees_co_Cap_sp_ImprovementImpact_sp_Fee_sp_2_sp__percent_": "$"
+"General_sp_Property_sp_Description_co__pound__sp_of_sp_Interior_sp_Levels": 1
+"Location_sp_Tax_sp_Legal_co_Legal_sp_Description_sp__lparen_Abbrev_rparen_3": "LOT 1 BELLA SOL AT TROON NORTH MCR 099703"
+"Contract_sp_Information_co_Co_hyphen_Ownership_sp__lparen_Fractional_rparen__sp_Agreement_sp_YN": "No"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('20240124175944766175000000')"
+"provider_name": "ARMLS"
+"Media": array:50 [
0 => array:16 [ …16]
1 => array:16 [ …16]
2 => array:16 [ …16]
3 => array:16 [ …16]
4 => array:16 [ …16]
5 => array:16 [ …16]
6 => array:16 [ …16]
7 => array:16 [ …16]
8 => array:16 [ …16]
9 => array:16 [ …16]
10 => array:16 [ …16]
11 => array:16 [ …16]
12 => array:16 [ …16]
13 => array:16 [ …16]
14 => array:16 [ …16]
15 => array:16 [ …16]
16 => array:16 [ …16]
17 => array:16 [ …16]
18 => array:16 [ …16]
19 => array:16 [ …16]
20 => array:16 [ …16]
21 => array:16 [ …16]
22 => array:16 [ …16]
23 => array:16 [ …16]
24 => array:16 [ …16]
25 => array:16 [ …16]
26 => array:16 [ …16]
27 => array:16 [ …16]
28 => array:16 [ …16]
29 => array:16 [ …16]
30 => array:16 [ …16]
31 => array:16 [ …16]
32 => array:16 [ …16]
33 => array:16 [ …16]
34 => array:16 [ …16]
35 => array:16 [ …16]
36 => array:16 [ …16]
37 => array:16 [ …16]
38 => array:16 [ …16]
39 => array:16 [ …16]
40 => array:16 [ …16]
41 => array:16 [ …16]
42 => array:16 [ …16]
43 => array:16 [ …16]
44 => array:16 [ …16]
45 => array:16 [ …16]
46 => array:16 [ …16]
47 => array:16 [ …16]
48 => array:16 [ …16]
49 => array:16 [ …16]
]
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
]
"RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp DESC&$top=4&$filter=(StandardStatus eq 'Active') and PropertyType in ('Residential', 'Residential Lease') AND PropertySubType eq 'Single Family Residence' AND City eq 'Scottsdale'/Property?$select=ALL&$orderby=ModificationTimestamp DESC&$top=4&$filter=(StandardStatus eq 'Active') and PropertyType in ('Residential', 'Residential Lease') AND PropertySubType eq 'Single Family Residence' AND City eq 'Scottsdale'&$expand=Media/Property?$select=ALL&$orderby=ModificationTimestamp DESC&$top=4&$filter=(StandardStatus eq 'Active') and PropertyType in ('Residential', 'Residential Lease') AND PropertySubType eq 'Single Family Residence' AND City eq 'Scottsdale'/Property?$select=ALL&$orderby=ModificationTimestamp DESC&$top=4&$filter=(StandardStatus eq 'Active') and PropertyType in ('Residential', 'Residential Lease') AND PropertySubType eq 'Single Family Residence' AND City eq 'Scottsdale'&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#6021
+items: array:4 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6017
+post_id: "28210"
+post_author: 1
+"ListingKey": "20250508205555104730000000"
+"ListingId": "6866534"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-06-08T17:28:08Z"
+"RFModificationTimestamp": "2025-06-08T17:28:45.306254+00:00"
+"ListPrice": 799000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 7433.0
+"LivingArea": 1503.0
+"BuildingAreaTotal": 0
+"City": "Scottsdale"
+"PostalCode": "85251"
+"UnparsedAddress": "6207 E Rose Circle Drive, Scottsdale, Arizona 85251"
+"Coordinates": array:2 [
0 => -111.94798
1 => 33.484505
]
+"Latitude": 33.484505
+"Longitude": -111.94798
+"YearBuilt": 1958
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Amy Kathryn Koch"
+"ListOfficeName": "The Brokery"
+"ListAgentMlsId": "ak145"
+"ListOfficeMlsId": "boll001"
+"OriginatingSystemName": "ARMLS"
+"PublicRemarks": """
Tucked beneath the iconic slopes of Camelback Mountain, this beautifully renovated home in the coveted Arizona Country Club neighborhood blends timeless elegance with modern comfort. Enjoy breathtaking mountain views, lush surroundings, and a prime location just minutes from Scottsdale's best dining, golf, and shopping. A rare opportunity in one of the Valley's most desirable enclaves.\r\n
Huge advantage to a buyer looking for a move in ready home, with low maintenance. All the big-ticket items are New : Roof, AC, Hot water heater, backyard landscaping, Designer touches inside, SS appliances, Quartz counter tops, interior and exterior paint. Rare to have a home with Air-condition unit in the 2-car garage.
"""
+"ApprovalStatus": true
+"AssociationFeeIncludes": array:1 [
0 => "No Fees"
]
+"BathroomsTotalDecimal": 2.0
+"BedroomsPossible": 3
+"BuilderName": "unknown"
+"BuildingAreaSource": "Assessor"
+"CarportSpaces": "2.0"
+"ConstructionMaterials": array:3 [
0 => "Board & Batten Siding"
1 => "Painted"
2 => "Block"
]
+"ContractStatusChangeDate": "2025-05-15"
+"Cooling": "Central Air,Ceiling Fan(s)"
+"CoolingYN": true
+"Country": "US"
+"CountyOrParish": "Maricopa"
+"CoveredSpaces": "4.0"
+"CreationDate": "2025-05-29T23:08:07.140216+00:00"
+"CrossStreet": "INDIAN SCHOOL/64TH ST"
+"Directions": "From 64th street go west on Indian School. Turn south onto Rose Circle to home."
+"Disclosures": array:2 [
0 => "Agency Discl Req"
1 => "Seller Discl Avail"
]
+"DocumentsChangeTimestamp": "2025-05-15T14:30:10Z"
+"ElementarySchool": "Tavan Elementary School"
+"ElementarySchoolDistrict": "Scottsdale Unified District"
+"Fencing": array:1 [
0 => "Block"
]
+"FireplaceFeatures": array:1 [
0 => "None"
]
+"Flooring": "Tile"
+"GarageSpaces": "2.0"
+"Heating": "Natural Gas"
+"HeatingYN": true
+"HighSchool": "Arcadia High School"
+"HighSchoolDistrict": "Scottsdale Unified District"
+"InteriorFeatures": "High Speed Internet,Granite Counters,Breakfast Bar,No Interior Steps,Full Bth Master Bdrm"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [
0 => "Wshr/Dry HookUp Only"
]
+"ListAgentAOR": "Scottsdale"
+"ListAgentFirstName": "Amy"
+"ListAgentKey": "20071208001403060062000000"
+"ListAgentLastName": "Koch"
+"ListAgentPreferredPhone": "602-386-7343"
+"ListAgentURL": "www.amykoch.com"
+"ListOfficeEmail": "[email protected]"
+"ListOfficeFax": "602-892-4444"
+"ListOfficeKey": "20201208182425424639000000"
+"ListOfficeURL": "www.thebrokery.com"
+"ListingContractDate": "2025-05-15"
+"ListingTerms": "Cash,Conventional,1031 Exchange,FHA,VA Loan"
+"LivingAreaSource": "Assessor"
+"LotFeatures": array:3 [
0 => "Alley"
1 => "Desert Front"
2 => "Synthetic Grass Back"
]
+"LotSizeAcres": 0.17
+"LotSizeSource": "Assessor"
+"LotSizeSquareFeet": 7433.0
+"MiddleOrJuniorSchool": "Ingleside Middle School"
+"MlsStatus": "Active"
+"OpenParkingSpaces": "2.0"
+"OriginalEntryTimestamp": "2025-05-15T16:30:10Z"
+"OriginatingSystemID": "M00000048"
+"OriginatingSystemKey": "20250508205555104730000000"
+"ParcelNumber": "128-45-132"
+"ParkingFeatures": "Garage Door Opener,Temp Controlled"
+"PatioAndPorchFeatures": array:1 [
0 => "Patio"
]
+"PhotosChangeTimestamp": "2025-05-15T14:55:33Z"
+"PhotosCount": 22
+"PoolFeatures": "None"
+"Possession": array:1 [
0 => "Close Of Escrow"
]
+"PostalCity": "Scottsdale"
+"PostalCodePlus4": "5452"
+"PriceChangeTimestamp": "2025-05-30T00:46:03Z"
+"PublicSurveyRange": "4E"
+"PublicSurveySection": "28"
+"Roof": "Composition"
+"Sewer": "Sewer in & Cnctd,Public Sewer"
+"SourceSystemID": "M00000048"
+"SourceSystemKey": "20250508205555104730000000"
+"SourceSystemName": "Arizona Regional Multiple Listing Service (ARMLS)"
+"SpaFeatures": array:1 [
0 => "None"
]
+"SpecialListingConditions": array:1 [
0 => "N/A"
]
+"StateOrProvince": "AZ"
+"StatusChangeTimestamp": "2025-05-15T14:30:10Z"
+"StoriesTotal": "1"
+"StreetDirPrefix": "E"
+"StreetName": "ROSE CIRCLE"
+"StreetNumber": "6207"
+"StreetNumberNumeric": "6207"
+"StreetSuffix": "Drive"
+"SubdivisionName": "MELROSE MEADOWS 3 88-93, 102-104, 154-165"
+"TaxAnnualAmount": "1900.0"
+"TaxBookNumber": "128.00"
+"TaxLegalDescription": "LOT 103 MELROSE MEADOWS 3 88-93, 102-104, 154-165 MCR 007427"
+"TaxLot": "103"
+"TaxMapNumber": "45.00"
+"TaxYear": "2024"
+"Township": "2N"
+"View": array:1 [
0 => "Mountain(s)"
]
+"VirtualTourURLUnbranded": "https://tours.arizonarealtours.com/2327535?idx=1"
+"WaterSource": array:1 [
0 => "City Water"
]
+"Spa_co_None14": true
+"Flooring_co_Tile": true
+"Utilities_co_SRP": true
+"Fencing_co_Block2": true
+"Construction_co_Block": true
+"Legal_sp_Info_co_Range": "4E"
+"[email protected]": "None"
+"[email protected]": "None"
+"New_sp_Financing_co_VA5": true
+"Utilities_co_SW_sp_Gas3": true
+"[email protected]": "None"
+"[email protected]": "None"
+"Dining_sp_Area_co_Formal": true
+"New_sp_Financing_co_FHA5": true
+"[email protected]": "None"
+"Cooling_co_Central_sp_Air": true
+"[email protected]": "None"
+"Heating_co_Natural_sp_Gas": true
+"Legal_sp_Info_co_Section2": "28"
+"New_sp_Financing_co_Cash2": true
+"[email protected]": "None"
+"Basement_co_Basement_sp_YN": "N"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Roofing_co_Comp_sp_Shingle": true
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Assoc_sp_RulesInfo_co_None17": true
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Exterior_sp_Features_co_Patio": true
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Sewer_co_Sewer_sp_in_sp_Cnctd": true
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Landscaping_co_Desert_sp_Front": true
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Kitchen_sp_Features_co_Disposal": true
+"[email protected]": "None"
+"Pool_sp_Features_co_No_sp_Pool2": true
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Contract_sp_Information_co_Type3": "Exclusive Right To Sell"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Other_sp_Rooms_co_Family_sp_Room": true
+"[email protected]": "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"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Kitchen_sp_Features_co_Dishwasher": true
+"[email protected]": "None"
+"New_sp_Financing_co_Conventional5": true
+"[email protected]": "None"
+"[email protected]": "None"
+"Property_sp_Description_co_Alley2": true
+"[email protected]": "None"
+"[email protected]": "None"
+"Association_sp_Fees_co_PAD_sp_Fee2": 0.0
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Dining_sp_Area_co_Breakfast_sp_Bar": true
+"[email protected]": "None"
+"[email protected]": "None"
+"Location_sp_Tax_sp_Legal_co_Taxes2": 1900.0
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Technology_co_Cable_sp_TV_sp_Avail": true
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Features_co_No_sp_Interior_sp_Steps": true
+"Kitchen_sp_Features_co_Refrigerator": true
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Possession_co_Close_sp_of_sp_Escrow": true
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Laundry_co_WshrDry_sp_HookUp_sp_Only": true
+"[email protected]": "None"
+"Sewer_co_Sewer_sp__hyphen__sp_Public": true
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Contract_sp_Information_co_Ownership2": "Fee Simple"
+"Disclosures_co_Agency_sp_Discl_sp_Req": true
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"New_sp_Financing_co_1031_sp_Exchange2": true
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Const_sp__hyphen__sp_Finish_co_Painted": true
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Pmt_sp_Rate_sp_Info_co_Down_sp_Payment": 0.0
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Disclosures_co_Seller_sp_Discl_sp_Avail": true
+"Items_sp_Updated_co_Roof_sp_PartialFull": "Full"
+"[email protected]": "None"
+"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"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Fireplace_sp_Features_co_No_sp_Fireplace": true
+"Items_sp_Updated_co_Floor_sp_PartialFull": "Full"
+"Kitchen_sp_Features_co_RangeOven_sp_Elec": true
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Items_sp_Updated_co_HtCool_sp_PartialFull": "Full"
+"Items_sp_Updated_co_Roof_sp_Yr_sp_Updated": "2025"
+"Landscaping_co_Synthetic_sp_Grass_sp_Back": true
+"[email protected]": "None"
+"Parking_sp_Features_co_Temp_sp_Controlled": true
+"Plumbing_co_Electric_sp_Hot_sp_Wtr_sp_Htr": true
+"[email protected]": "None"
+"Cooling_co_Ceiling_sp_Fan_lparen_s_rparen_": true
+"General_sp_Property_sp_Description_co_Pool": "None"
+"Items_sp_Updated_co_Kitchen_sp_PartialFull": "Partial"
+"Kitchen_sp_Features_co_Granite_sp_Counters": true
+"[email protected]": "None"
+"[email protected]": "None"
+"Unit_sp_Style_co_All_sp_on_sp_One_sp_Level": true
+"Association_sp_Fees_co_Land_sp_Lease_sp_Fee": 0.0
+"[email protected]": "None"
+"Items_sp_Updated_co_HtCool_sp_Yr_sp_Updated": "2024"
+"[email protected]": "None"
+"[email protected]": "None"
+"General_sp_Property_sp_Description_co_Horses": "N"
+"Items_sp_Updated_co_Kitchen_sp_Yr_sp_Updated": "2025"
+"[email protected]": "None"
+"[email protected]": "None"
+"Parking_sp_Spaces_co_Slab_sp_Parking_sp_Spaces": 2.0
+"[email protected]": "None"
+"[email protected]": "None"
+"General_sp_Property_sp_Description_co_PriceSqFt": 531.6
+"Parking_sp_Features_co_Garage_sp_Door_sp_Opener": true
+"Parking_sp_Spaces_co_Total_sp_Covered_sp_Spaces": 4.0
+"Separate_sp_DenOffice_co_Sep_sp_DenOffice_sp_YN": "N"
+"[email protected]": "None"
+"Location_sp_Tax_sp_Legal_co_Tax_sp_Municipality3": "Scottsdale"
+"Association_sp_Fees_co_Land_sp_Lease_sp_Fee_sp_YN": "N"
+"Association_sp_Fees_co_Rec_sp_Center_sp_Fee_sp_YN": "N"
+"Lockbox_sp_Type_co_Supra_sp__lparen_ARMLS_rparen_": 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
+"Existing_sp_1st_sp_Loan_co_Treat_sp_as_sp_FreeClear4": true
+"General_sp_Property_sp_Description_co_Approx_sp_SQFT": 1503.0
+"General_sp_Property_sp_Description_co_High_sp_School": "Arcadia High School"
+"Pmt_sp_Rate_sp_Info_co_Total_sp_Asum_sp_Mnth_sp_Pmts": 0.0
+"General_sp_Property_sp_Description_co_Builder_sp_Name": "unknown"
+"Kitchen_sp_Features_co_Non_hyphen_laminate_sp_Counter": true
+"Association_sp_Fees_co_Cap_sp_ImprovementImpact_sp_Fee": 0.0
+"Const_sp__hyphen__sp_Finish_co_Board_sp_Batten_sp_Siding": true
+"General_sp_Property_sp_Description_co_Dwelling_sp_Styles": "Detached"
+"General_sp_Property_sp_Description_co_Marketing_sp_Name3": "Arizona Country Club"
+"Items_sp_Updated_co_Bath_lparen_s_rparen__sp_PartialFull": "Partial"
+"Showing_sp_Notification_sp_Methods_co_Showing_sp_Service": "Aligned Showings"
+"General_sp_Property_sp_Description_co_Elementary_sp_School": "Tavan Elementary School"
+"General_sp_Property_sp_Description_co_Jr_sp_High_sp_School": "Ingleside Middle School"
+"Items_sp_Updated_co_Bath_lparen_s_rparen__sp_Yr_sp_Updated": "2023"
+"General_sp_Property_sp_Description_co_Approx_sp_Lot_sp_SqFt": 7433.0
+"General_sp_Property_sp_Description_co_Approx_sp_Lot_sp_Acres2": 0.171
+"General_sp_Property_sp_Description_co_Planned_sp_Comm_sp_Name": "ACC Neighborhood"
+"Property_sp_Description_co_Mountain_sp_View_lparen_s_rparen_2": true
+"Location_sp_Tax_sp_Legal_co_Assessor_squote_s_sp_Map_sp__pound_3": 45.0
+"General_sp_Property_sp_Description_co_High_sp_School_sp_District2": "Scottsdale Unified District"
+"Association_sp_Fees_co_Cap_sp_ImprovementImpact_sp_Fee_sp__percent_": "%"
+"Location_sp_Tax_sp_Legal_co_Assessor_squote_s_sp_Parcel_sp__pound_3": 132.0
+"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 103 MELROSE MEADOWS 3 88-93, 102-104, 154-165 MCR 007427"
+"Contract_sp_Information_co_Co_hyphen_Ownership_sp__lparen_Fractional_rparen__sp_Agreement_sp_YN": "No"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('20250508205555104730000000')"
+"provider_name": "ARMLS"
+"Media": array:22 [
0 => array:16 [ …16]
1 => array:16 [ …16]
2 => array:16 [ …16]
3 => array:16 [ …16]
4 => array:16 [ …16]
5 => array:16 [ …16]
6 => array:16 [ …16]
7 => array:16 [ …16]
8 => array:16 [ …16]
9 => array:16 [ …16]
10 => array:16 [ …16]
11 => array:16 [ …16]
12 => array:16 [ …16]
13 => array:16 [ …16]
14 => array:16 [ …16]
15 => array:16 [ …16]
16 => array:16 [ …16]
17 => array:16 [ …16]
18 => array:16 [ …16]
19 => array:16 [ …16]
20 => array:16 [ …16]
21 => array:16 [ …16]
]
+"ID": "28210"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6036
+post_id: 63407
+post_author: 1
+"ListingKey": "20250608151133785701000000"
+"ListingId": "6877404"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-06-08T17:26:10Z"
+"RFModificationTimestamp": "2025-06-08T17:29:06.200799+00:00"
+"ListPrice": 550000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 6974.0
+"LivingArea": 1260.0
+"BuildingAreaTotal": 0
+"City": "Scottsdale"
+"PostalCode": "85251"
+"UnparsedAddress": "8713 E Rancho Vista Drive, Scottsdale, Arizona 85251"
+"Coordinates": array:2 [
0 => -111.893443
1 => 33.50752
]
+"Latitude": 33.50752
+"Longitude": -111.893443
+"YearBuilt": 1960
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Susan G Christy"
+"ListOfficeName": "Realty Executives"
+"ListAgentMlsId": "sc017"
+"ListOfficeMlsId": "reax09"
+"OriginatingSystemName": "ARMLS"
+"PublicRemarks": "OPPORTUNITY KNOCKS! Ideally located within a highly desirable neighborhood in close proximity to downtown Scottsdale,101 freeway, & Scottsdale Community College, this home, in need of complete rehabilitation, offers great potential for an investor or end user up to the task!"
+"Appliances": "Electric Cooktop"
+"ApprovalStatus": true
+"ArchitecturalStyle": "Ranch"
+"AssociationFeeIncludes": array:1 [
0 => "No Fees"
]
+"BathroomsTotalDecimal": 1.75
+"BedroomsPossible": 3
+"BuilderName": "Hallcraft"
+"BuildingAreaSource": "Assessor"
+"ConstructionMaterials": array:3 [
0 => "Stucco"
1 => "Stone"
2 => "Brick"
]
+"ContractStatusChangeDate": "2025-06-08"
+"Cooling": "Central Air,Ceiling Fan(s)"
+"CoolingYN": true
+"Country": "US"
+"CountyOrParish": "Maricopa"
+"CoveredSpaces": "1.0"
+"CreationDate": "2025-06-08T17:28:40.143529+00:00"
+"CrossStreet": "HAYDEN & CHAPARRAL"
+"Directions": "E ON CHAPARRAL/S ON 86TH ST TO RANCHO VISTA/E TO PROPERTY"
+"Disclosures": array:2 [
0 => "Agency Discl Req"
1 => "Seller Discl Avail"
]
+"DocumentsChangeTimestamp": "2025-06-08T17:24:08Z"
+"ElementarySchool": "Navajo Elementary School"
+"ElementarySchoolDistrict": "Scottsdale Unified District"
+"Fencing": array:1 [
0 => "Block"
]
+"FireplaceFeatures": array:1 [
0 => "None"
]
+"Flooring": "Tile"
+"GarageSpaces": "1.0"
+"Heating": "Natural Gas"
+"HeatingYN": true
+"HighSchool": "Saguaro High School"
+"HighSchoolDistrict": "Scottsdale Unified District"
+"InteriorFeatures": "High Speed Internet,Breakfast Bar,Kitchen Island,3/4 Bath Master Bdrm"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAgentAOR": "Phoenix REALTORS"
+"ListAgentFirstName": "Susan"
+"ListAgentKey": "20071208002638862341000000"
+"ListAgentLastName": "Christy"
+"ListAgentPreferredPhone": "602-909-4208"
+"ListAgentURL": "www.christyrealty.com"
+"ListOfficeEmail": "[email protected]"
+"ListOfficeFax": "480-991-7161"
+"ListOfficeKey": "20071206231739123494000000"
+"ListOfficePhone": "480-948-9450"
+"ListOfficeURL": "www.realtyexecutives.com"
+"ListingContractDate": "2025-06-06"
+"ListingTerms": "Cash,Conventional"
+"LivingAreaSource": "Assessor"
+"LotFeatures": array:4 [
0 => "Alley"
1 => "Desert Front"
2 => "Gravel/Stone Front"
3 => "Gravel/Stone Back"
]
+"LotSizeAcres": 0.16
+"LotSizeSource": "Assessor"
+"LotSizeSquareFeet": 6974.0
+"MiddleOrJuniorSchool": "Mohave Middle School"
+"MlsStatus": "Active"
+"OriginalEntryTimestamp": "2025-06-08T19:24:07Z"
+"OriginatingSystemID": "M00000048"
+"OriginatingSystemKey": "20250608151133785701000000"
+"ParcelNumber": "173-63-086"
+"ParkingFeatures": "Separate Strge Area"
+"PatioAndPorchFeatures": array:2 [
0 => "Covered Patio(s)"
1 => "Patio"
]
+"PhotosChangeTimestamp": "2025-06-08T17:25:27Z"
+"PhotosCount": 7
+"PoolFeatures": "None"
+"Possession": array:1 [
0 => "Close Of Escrow"
]
+"PostalCity": "Scottsdale"
+"PostalCodePlus4": "1868"
+"PropertyCondition": array:1 [
0 => "Fixer"
]
+"PublicSurveyRange": "4E"
+"PublicSurveySection": "24"
+"Roof": "Composition"
+"Sewer": "Sewer in & Cnctd,Public Sewer"
+"SourceSystemID": "M00000048"
+"SourceSystemKey": "20250608151133785701000000"
+"SourceSystemName": "Arizona Regional Multiple Listing Service (ARMLS)"
+"SpaFeatures": array:1 [
0 => "None"
]
+"SpecialListingConditions": array:1 [
0 => "N/A"
]
+"StateOrProvince": "AZ"
+"StatusChangeTimestamp": "2025-06-08T17:24:07Z"
+"StoriesTotal": "1"
+"StreetDirPrefix": "E"
+"StreetName": "RANCHO VISTA"
+"StreetNumber": "8713"
+"StreetNumberNumeric": "8713"
+"StreetSuffix": "Drive"
+"SubdivisionName": "SCOTTSDALE ESTATES 14 LOTS 1845-1925"
+"TaxAnnualAmount": "1251.0"
+"TaxBookNumber": "173.00"
+"TaxLegalDescription": "LOT 1772 SCOTTSDALE ESTATES 14 LOTS 1845-1925 MCR 008434"
+"TaxLot": "1772"
+"TaxMapNumber": "63.00"
+"TaxYear": "2024"
+"Township": "2N"
+"WaterSource": array:1 [
0 => "City Water"
]
+"Spa_co_None14": true
+"Flooring_co_Tile": true
+"Utilities_co_SRP": true
+"Fencing_co_Block2": true
+"Laundry_co_Inside2": true
+"Architecture_co_Ranch": true
+"Construction_co_Brick": true
+"Legal_sp_Info_co_Range": "4E"
+"[email protected]": "None"
+"[email protected]": "None"
+"Utilities_co_SW_sp_Gas3": true
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Cooling_co_Central_sp_Air": true
+"[email protected]": "None"
+"Heating_co_Natural_sp_Gas": true
+"Legal_sp_Info_co_Section2": "24"
+"New_sp_Financing_co_Cash2": true
+"[email protected]": "None"
+"Basement_co_Basement_sp_YN": "N"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Roofing_co_Comp_sp_Shingle": true
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Assoc_sp_RulesInfo_co_None17": true
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Exterior_sp_Features_co_Patio": true
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Sewer_co_Sewer_sp_in_sp_Cnctd": true
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Landscaping_co_Desert_sp_Front": true
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Kitchen_sp_Features_co_Disposal": true
+"[email protected]": "None"
+"Other_sp_Rooms_co_Great_sp_Room": true
+"Pool_sp_Features_co_No_sp_Pool2": true
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Contract_sp_Information_co_Type3": "Exclusive Right To Sell"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "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"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Kitchen_sp_Features_co_Dishwasher": true
+"[email protected]": "None"
+"Master_sp_Bedroom_co_Not_sp_Split": true
+"New_sp_Financing_co_Conventional5": true
+"[email protected]": "None"
+"[email protected]": "None"
+"Property_sp_Description_co_Alley2": true
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Dining_sp_Area_co_Breakfast_sp_Bar": true
+"[email protected]": "None"
+"[email protected]": "None"
+"Landscaping_co_GravelStone_sp_Back": true
+"Laundry_co_Stacked_sp_WasherDryer2": true
+"Location_sp_Tax_sp_Legal_co_Taxes2": 1251.0
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Technology_co_Cable_sp_TV_sp_Avail": true
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Kitchen_sp_Features_co_Refrigerator": true
+"Landscaping_co_GravelStone_sp_Front": true
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Possession_co_Close_sp_of_sp_Escrow": true
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Sewer_co_Sewer_sp__hyphen__sp_Public": true
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Const_sp__hyphen__sp_Finish_co_Stone2": true
+"Const_sp__hyphen__sp_Finish_co_Stucco": true
+"Contract_sp_Information_co_Ownership2": "Fee Simple"
+"Disclosures_co_Agency_sp_Discl_sp_Req": true
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Dining_sp_Area_co_Dining_sp_in_sp_LRGR": true
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Disclosures_co_Seller_sp_Discl_sp_Avail": true
+"[email protected]": "None"
+"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"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Fireplace_sp_Features_co_No_sp_Fireplace": true
+"Kitchen_sp_Features_co_Kitchen_sp_Island": true
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Plumbing_co_Gas_sp_Hot_sp_Water_sp_Heater": true
+"[email protected]": "None"
+"Cooling_co_Ceiling_sp_Fan_lparen_s_rparen_": true
+"General_sp_Property_sp_Description_co_Pool": "None"
+"Kitchen_sp_Features_co_Electric_sp_Cooktop": true
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Features_co_Fix_hyphen_Up_sp_Needs_sp_Repair": true
+"General_sp_Property_sp_Description_co_Horses": "N"
+"[email protected]": "None"
+"[email protected]": "None"
+"Parking_sp_Spaces_co_Slab_sp_Parking_sp_Spaces": 0.0
+"[email protected]": "None"
+"[email protected]": "None"
+"General_sp_Property_sp_Description_co_PriceSqFt": 436.51
+"Parking_sp_Spaces_co_Total_sp_Covered_sp_Spaces": 1.0
+"Separate_sp_DenOffice_co_Sep_sp_DenOffice_sp_YN": "N"
+"[email protected]": "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"
+"Lockbox_sp_Type_co_Supra_sp__lparen_ARMLS_rparen_": true
+"Master_sp_Bathroom_co_34_sp_Bath_sp_Master_sp_Bdrm": true
+"Status_sp_Update_co_Multiple_sp_Offers_sp_Received": true
+"Association_sp_Fees_co_Ttl_sp_Mthly_sp_Fee_sp_Equiv": 0.0
+"General_sp_Property_sp_Description_co_Flood_sp_Zone": "No"
+"Existing_sp_1st_sp_Loan_co_Treat_sp_as_sp_FreeClear4": true
+"General_sp_Property_sp_Description_co_Approx_sp_SQFT": 1260.0
+"General_sp_Property_sp_Description_co_High_sp_School": "Saguaro High School"
+"General_sp_Property_sp_Description_co_Builder_sp_Name": "Hallcraft"
+"General_sp_Property_sp_Description_co_Dwelling_sp_Styles": "Detached"
+"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": "Navajo Elementary School"
+"General_sp_Property_sp_Description_co_Jr_sp_High_sp_School": "Mohave Middle School"
+"General_sp_Property_sp_Description_co_Approx_sp_Lot_sp_SqFt": 6974.0
+"General_sp_Property_sp_Description_co_Approx_sp_Lot_sp_Acres2": 0.16
+"Residential_sp_Propane_sp_Tank_co_Propane_sp_Underground_sp_YN": "No"
+"Location_sp_Tax_sp_Legal_co_Assessor_squote_s_sp_Map_sp__pound_3": 63.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": 86.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": "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 1772 SCOTTSDALE ESTATES 14 LOTS 1845-1925 MCR 008434"
+"Contract_sp_Information_co_Co_hyphen_Ownership_sp__lparen_Fractional_rparen__sp_Agreement_sp_YN": "No"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('20250608151133785701000000')"
+"provider_name": "ARMLS"
+"short_address": "Scottsdale, Arizona 85251, US"
+"Media": array:7 [
0 => array:16 [ …16]
1 => array:16 [ …16]
2 => array:16 [ …16]
3 => array:16 [ …16]
4 => array:16 [ …16]
5 => array:16 [ …16]
6 => array:16 [ …16]
]
+"ID": 63407
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5993
+post_id: "62559"
+post_author: 1
+"ListingKey": "20250604024211819070000000"
+"ListingId": "6876905"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-06-08T17:24:56Z"
+"RFModificationTimestamp": "2025-06-08T17:29:06.378824+00:00"
+"ListPrice": 1149900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 10456.0
+"LivingArea": 2577.0
+"BuildingAreaTotal": 0
+"City": "Scottsdale"
+"PostalCode": "85254"
+"UnparsedAddress": "6119 E Sandra Terrace, Scottsdale, Arizona 85254"
+"Coordinates": array:2 [
0 => -111.947965
1 => 33.634677
]
+"Latitude": 33.634677
+"Longitude": -111.947965
+"YearBuilt": 1985
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Randall Prosise"
+"ListOfficeName": "America One Luxury Real Estate"
+"ListAgentMlsId": "rp708"
+"ListOfficeMlsId": "aone01"
+"OriginatingSystemName": "ARMLS"
+"PublicRemarks": "Stunning Remodeled Home in Prime Scottsdale LOCATION! This beautifully remodeled Golden Heritage built home is nestled on a spacious corner lot in the highly sought-after North Ranch neighborhood. Just minutes from Kierland shopping and dining, with seamless access to the 101 and 51 freeways, this home blends luxury, convenience, and contemporary style. Step inside to find a bright, open interior showcasing many brand-new upgrades, including paint, polished travertine, luxury carpet, sleek countertops, modern fixtures, new ceiling fans and energy-efficient LED lighting throughout. Other features include garage cabinets, water softener, heated diving pool, Built-in BBQ, fireplace and manicured mature landscaping. A brand new Diamond Seal roof with warranty provides icing on the cake!"
+"ApprovalStatus": true
+"ArchitecturalStyle": "Ranch"
+"AssociationFeeIncludes": array:1 [
0 => "No Fees"
]
+"BathroomsTotalDecimal": 2.0
+"BedroomsPossible": 4
+"BuilderName": "Golden Heritage"
+"BuildingAreaSource": "Assessor"
+"CommunityFeatures": "Playground"
+"ConstructionMaterials": array:3 [
0 => "Stucco"
1 => "Painted"
2 => "Block"
]
+"ContractStatusChangeDate": "2025-06-06"
+"Cooling": "Central Air,Ceiling Fan(s),Programmable Thmstat"
+"CoolingYN": true
+"Country": "US"
+"CountyOrParish": "Maricopa"
+"CoveredSpaces": "2.0"
+"CreationDate": "2025-06-06T22:29:01.864805+00:00"
+"CrossStreet": "64TH STREET AND BELL RD"
+"CurrentFinancing": array:2 [
0 => "Conventional"
1 => "Non Assumable"
]
+"Disclosures": array:2 [
0 => "Agency Discl Req"
1 => "Vicinity of an Airport"
]
+"DocumentsChangeTimestamp": "2025-06-06T22:27:04Z"
+"DocumentsCount": 1
+"ElementarySchool": "North Ranch Elementary School"
+"ElementarySchoolDistrict": "Paradise Valley Unified District"
+"ExteriorFeatures": "Private Yard,Built-in Barbecue"
+"Fencing": array:1 [
0 => "Block"
]
+"FireplaceFeatures": array:2 [
0 => "1 Fireplace"
1 => "Exterior Fireplace"
]
+"FireplaceYN": true
+"Flooring": "Carpet,Stone"
+"GarageSpaces": "2.0"
+"Heating": "Electric"
+"HeatingYN": true
+"HighSchool": "Horizon High School"
+"HighSchoolDistrict": "Paradise Valley Unified District"
+"InteriorFeatures": "High Speed Internet,Granite Counters,Double Vanity,Eat-in Kitchen,Breakfast Bar,Vaulted Ceiling(s),Pantry,Full Bth Master Bdrm,Separate Shwr & Tub"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAgentAOR": "Scottsdale"
+"ListAgentFirstName": "Randall"
+"ListAgentKey": "20210301155028765149000000"
+"ListAgentLastName": "Prosise"
+"ListAgentPreferredPhone": "480-283-7465"
+"ListOfficeEmail": "[email protected]"
+"ListOfficeFax": "480-905-3076"
+"ListOfficeKey": "20071206231149460896000000"
+"ListOfficePhone": "480-905-8115"
+"ListOfficeURL": "http://www.americaonerealtyusa.com/"
+"ListingContractDate": "2025-06-06"
+"ListingTerms": "Cash,Conventional,1031 Exchange"
+"LivingAreaSource": "Assessor"
+"LotFeatures": array:7 [
0 => "Sprinklers In Rear"
1 => "Sprinklers In Front"
2 => "Corner Lot"
3 => "Desert Back"
4 => "Desert Front"
5 => "Auto Timer H2O Front"
6 => "Auto Timer H2O Back"
]
+"LotSizeAcres": 0.24
+"LotSizeSource": "Assessor"
+"LotSizeSquareFeet": 10456.0
+"MiddleOrJuniorSchool": "Sunrise Middle School"
+"MlsStatus": "Active"
+"OpenParkingSpaces": "3.0"
+"OriginalEntryTimestamp": "2025-06-07T00:27:02Z"
+"OriginatingSystemID": "M00000048"
+"OriginatingSystemKey": "20250604024211819070000000"
+"ParcelNumber": "215-80-084"
+"ParkingFeatures": "RV Gate,Garage Door Opener,Direct Access,Attch'd Gar Cabinets"
+"PatioAndPorchFeatures": array:2 [
0 => "Covered Patio(s)"
1 => "Patio"
]
+"PhotosChangeTimestamp": "2025-06-08T17:23:30Z"
+"PhotosCount": 42
+"PoolFeatures": "Diving Pool,Heated,Private"
+"PoolPrivateYN": true
+"Possession": array:1 [
0 => "Close Of Escrow"
]
+"PostalCity": "Scottsdale"
+"PostalCodePlus4": "1364"
+"PublicSurveyRange": "4E"
+"PublicSurveySection": "4"
+"Roof": "Tile,Built-Up"
+"Sewer": "Public Sewer"
+"SourceSystemID": "M00000048"
+"SourceSystemKey": "20250604024211819070000000"
+"SourceSystemName": "Arizona Regional Multiple Listing Service (ARMLS)"
+"SpaFeatures": array:1 [
0 => "None"
]
+"SpecialListingConditions": array:1 [
0 => "Owner/Agent"
]
+"StateOrProvince": "AZ"
+"StatusChangeTimestamp": "2025-06-06T22:27:02Z"
+"StoriesTotal": "1"
+"StreetDirPrefix": "E"
+"StreetName": "SANDRA"
+"StreetNumber": "6119"
+"StreetNumberNumeric": "6119"
+"StreetSuffix": "Terrace"
+"SubdivisionName": "NORTH RANCH UNIT 4 LT 288-339 341-344 364-366"
+"TaxAnnualAmount": "3831.0"
+"TaxBookNumber": "215.00"
+"TaxLegalDescription": "LOT 314 NORTH RANCH UNIT 4 LT 288-339 341-344 364-366 MCR 025919"
+"TaxLot": "314"
+"TaxMapNumber": "80.00"
+"TaxYear": "2024"
+"Township": "3N"
+"WaterSource": array:1 [
0 => "City Water"
]
+"WindowFeatures": array:2 [
0 => "Skylight(s)"
1 => "Dual Pane"
]
+"Spa_co_None14": true
+"Roofing_co_Tile2": true
+"Utilities_co_APS": true
+"Fencing_co_Block2": true
+"Flooring_co_Stone": true
+"Flooring_co_Carpet": true
+"Laundry_co_Inside2": true
+"Heating_co_Electric": true
+"Architecture_co_Ranch": true
+"Construction_co_Block": true
+"Legal_sp_Info_co_Range": "4E"
+"[email protected]": "None"
+"[email protected]": "None"
+"Windows_co_Dual_sp_Pane": true
+"[email protected]": "None"
+"[email protected]": "None"
+"Dining_sp_Area_co_Formal": true
+"[email protected]": "None"
+"Cooling_co_Central_sp_Air": true
+"[email protected]": "None"
+"Legal_sp_Info_co_Section2": "4"
+"New_sp_Financing_co_Cash2": true
+"[email protected]": "None"
+"Basement_co_Basement_sp_YN": "N"
+"[email protected]": "None"
+"Master_sp_Bedroom_co_Split": true
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Roofing_co_Built_hyphen_Up": true
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Pool_sp_Features_co_Heated3": true
+"[email protected]": "None"
+"[email protected]": "None"
+"Assoc_sp_RulesInfo_co_None17": true
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Pool_sp_Features_co_Private2": true
+"Services_co_City_sp_Services": true
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "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
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Landscaping_co_Desert_sp_Front": true
+"Laundry_co_Washer_sp_Included2": true
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Kitchen_sp_Features_co_Disposal": true
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Contract_sp_Information_co_Type3": "Exclusive Agency"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Other_sp_Rooms_co_Family_sp_Room": true
+"[email protected]": "None"
+"Water_sp_Source_co_City_sp_Water": true
+"Association_sp_Fees_co_HOA_sp_YN2": "N"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Kitchen_sp_Features_co_Dishwasher": true
+"[email protected]": "None"
+"New_sp_Financing_co_Conventional5": true
+"[email protected]": "None"
+"Parking_sp_Features_co_RV_sp_Gate": true
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Cooling_co_Programmable_sp_Thmstat": true
+"[email protected]": "None"
+"Dining_sp_Area_co_Breakfast_sp_Bar": true
+"[email protected]": "None"
+"[email protected]": "None"
+"Location_sp_Tax_sp_Legal_co_Taxes2": 3831.0
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Pool_sp_Features_co_Diving_sp_Pool": true
+"[email protected]": "None"
+"[email protected]": "None"
+"Technology_co_Cable_sp_TV_sp_Avail": true
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Kitchen_sp_Features_co_Refrigerator": true
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Possession_co_Close_sp_of_sp_Escrow": true
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Sewer_co_Sewer_sp__hyphen__sp_Public": true
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Const_sp__hyphen__sp_Finish_co_Stucco": true
+"Contract_sp_Information_co_Ownership2": "Fee Simple"
+"Disclosures_co_Agency_sp_Discl_sp_Req": true
+"Features_co_Skylight_lparen_s_rparen_": true
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Master_sp_Bathroom_co_Double_sp_Sinks": true
+"New_sp_Financing_co_1031_sp_Exchange2": true
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Const_sp__hyphen__sp_Finish_co_Painted": true
+"[email protected]": "None"
+"Features_co_Water_sp_Softener_sp_Owned": true
+"[email protected]": "None"
+"[email protected]": "None"
+"Pmt_sp_Rate_sp_Info_co_Down_sp_Payment": 0.0
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Existing_sp_1st_sp_Loan_co_Conventional": true
+"Fireplace_sp_Features_co_1_sp_Fireplace": true
+"Items_sp_Updated_co_Roof_sp_PartialFull": "Full"
+"[email protected]": "None"
+"Parking_sp_Features_co_Direct_sp_Access": 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"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Items_sp_Updated_co_Floor_sp_PartialFull": "Full"
+"Kitchen_sp_Features_co_RangeOven_sp_Elec": true
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Items_sp_Updated_co_Roof_sp_Yr_sp_Updated": "2025"
+"[email protected]": "None"
+"Plumbing_co_Electric_sp_Hot_sp_Wtr_sp_Htr": true
+"Property_sp_Description_co_Corner_sp_Lot4": true
+"Special_sp_Listing_sp_Cond_co_OwnerAgent4": true
+"[email protected]": "None"
+"Cooling_co_Ceiling_sp_Fan_lparen_s_rparen_": true
+"Dining_sp_Area_co_Eat_hyphen_in_sp_Kitchen": true
+"General_sp_Property_sp_Description_co_Pool": "Private Only"
+"Items_sp_Updated_co_Floor_sp_Yr_sp_Updated": "2025"
+"Items_sp_Updated_co_Kitchen_sp_PartialFull": "Partial"
+"Kitchen_sp_Features_co_Granite_sp_Counters": true
+"[email protected]": "None"
+"[email protected]": "None"
+"Showing_sp_Notification_sp_Methods_co_Text": true
+"[email protected]": "None"
+"Landscaping_co_Auto_sp_Timer_sp_H2O_sp_Back": true
+"Landscaping_co_Yrd_sp_Wtring_sp_Sys_sp_Back": true
+"[email protected]": "None"
+"Pmt_sp_Rate_sp_Info_co_Total_sp_Encumbrance": 0.0
+"[email protected]": "None"
+"General_sp_Property_sp_Description_co_Horses": "N"
+"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
+"[email protected]": "None"
+"Master_sp_Bathroom_co_Separate_sp_Shwr_sp_Tub": true
+"[email protected]": "None"
+"Disclosures_co_Vicinity_sp_of_sp_an_sp_Airport": true
+"Exterior_sp_Features_co_Built_hyphen_in_sp_BBQ": true
+"Fireplace_sp_Features_co_Exterior_sp_Fireplace": true
+"Parking_sp_Spaces_co_Slab_sp_Parking_sp_Spaces": 3.0
+"[email protected]": "None"
+"[email protected]": "None"
+"Features_co_Vaulted_sp_Ceiling_lparen_s_rparen_": true
+"General_sp_Property_sp_Description_co_PriceSqFt": 446.22
+"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": "N"
+"[email protected]": "None"
+"Location_sp_Tax_sp_Legal_co_Tax_sp_Municipality3": "Phoenix"
+"Association_sp_Fees_co_Land_sp_Lease_sp_Fee_sp_YN": "N"
+"Existing_sp_1st_sp_Ln_sp_Trms_co_Non_sp_Assumable": true
+"Lockbox_sp_Type_co_Supra_sp__lparen_ARMLS_rparen_": true
+"Association_sp_Fees_co_Ttl_sp_Mthly_sp_Fee_sp_Equiv": 0.0
+"General_sp_Property_sp_Description_co_Flood_sp_Zone": "No"
+"Kitchen_sp_Features_co_Built_hyphen_in_sp_Microwave": true
+"Master_sp_Bathroom_co_Full_sp_Bth_sp_Master_sp_Bdrm": true
+"Additional_sp_Bedroom_co_Separate_sp_Bedroom_sp_Exit": true
+"General_sp_Property_sp_Description_co_Approx_sp_SQFT": 2577.0
+"General_sp_Property_sp_Description_co_High_sp_School": "Horizon High School"
+"Pmt_sp_Rate_sp_Info_co_Total_sp_Asum_sp_Mnth_sp_Pmts": 0.0
+"General_sp_Property_sp_Description_co_Builder_sp_Name": "Golden Heritage"
+"Association_sp_Fees_co_Cap_sp_ImprovementImpact_sp_Fee": 0.0
+"Community_sp_Features_co_Children_squote_s_sp_Playgrnd": true
+"General_sp_Property_sp_Description_co_Dwelling_sp_Styles": "Detached"
+"Items_sp_Updated_co_Bath_lparen_s_rparen__sp_PartialFull": "Partial"
+"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
+"General_sp_Property_sp_Description_co_Elementary_sp_School": "North Ranch Elementary School"
+"General_sp_Property_sp_Description_co_Jr_sp_High_sp_School": "Sunrise Middle School"
+"Items_sp_Updated_co_Bath_lparen_s_rparen__sp_Yr_sp_Updated": "2025"
+"Association_sp_Fees_co_Cap_sp_ImprovementImpact_sp_Fee_sp_2": 0.0
+"General_sp_Property_sp_Description_co_Approx_sp_Lot_sp_SqFt": 10456.0
+"General_sp_Property_sp_Description_co_Approx_sp_Lot_sp_Acres2": 0.24
+"Location_sp_Tax_sp_Legal_co_Assessor_squote_s_sp_Map_sp__pound_3": 80.0
+"General_sp_Property_sp_Description_co_High_sp_School_sp_District2": "Paradise 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": 84.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": "Paradise Valley Unified District"
+"Association_sp_Fees_co_Cap_sp_ImprovementImpact_sp_Fee_sp_2_sp__percent_": "$"
+"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 314 NORTH RANCH UNIT 4 LT 288-339 341-344 364-366 MCR 025919"
+"Contract_sp_Information_co_Co_hyphen_Ownership_sp__lparen_Fractional_rparen__sp_Agreement_sp_YN": "No"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('20250604024211819070000000')"
+"provider_name": "ARMLS"
+"Media": array:42 [
0 => array:16 [ …16]
1 => array:16 [ …16]
2 => array:16 [ …16]
3 => array:16 [ …16]
4 => array:16 [ …16]
5 => array:16 [ …16]
6 => array:16 [ …16]
7 => array:16 [ …16]
8 => array:16 [ …16]
9 => array:16 [ …16]
10 => array:16 [ …16]
11 => array:16 [ …16]
12 => array:16 [ …16]
13 => array:16 [ …16]
14 => array:16 [ …16]
15 => array:16 [ …16]
16 => array:16 [ …16]
17 => array:16 [ …16]
18 => array:16 [ …16]
19 => array:16 [ …16]
20 => array:16 [ …16]
21 => array:16 [ …16]
22 => array:16 [ …16]
23 => array:16 [ …16]
24 => array:16 [ …16]
25 => array:16 [ …16]
26 => array:16 [ …16]
27 => array:16 [ …16]
28 => array:16 [ …16]
29 => array:16 [ …16]
30 => array:16 [ …16]
31 => array:16 [ …16]
32 => array:16 [ …16]
33 => array:16 [ …16]
34 => array:16 [ …16]
35 => array:16 [ …16]
36 => array:16 [ …16]
37 => array:16 [ …16]
38 => array:16 [ …16]
39 => array:16 [ …16]
40 => array:16 [ …16]
41 => array:16 [ …16]
]
+"ID": "62559"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6038
+post_id: "34145"
+post_author: 1
+"ListingKey": "20250318164739694532000000"
+"ListingId": "6846264"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-06-08T17:11:18Z"
+"RFModificationTimestamp": "2025-06-08T17:16:12.538383+00:00"
+"ListPrice": 1300000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 5567.0
+"LivingArea": 1765.0
+"BuildingAreaTotal": 0
+"City": "Scottsdale"
+"PostalCode": "85266"
+"UnparsedAddress": "6936 E Whispering Mesquite Trail, Scottsdale, Az 85266"
+"Coordinates": array:2 [
0 => -111.931103
1 => 33.796916
]
+"Latitude": 33.796916
+"Longitude": -111.931103
+"YearBuilt": 1997
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Robert Lontkowski"
+"ListOfficeName": "Sonoran Properties Associates"
+"ListAgentMlsId": "rl318"
+"ListOfficeMlsId": "spaa01"
+"OriginatingSystemName": "ARMLS"
+"PublicRemarks": "A TERRAVITA EXPANDED NOVUS WITH EXQUISITE DESIGNER UPDATES AND MOUNTAIN VIEWS! Two bedrooms and two bathrooms plus casita with full bathroom. Two car garage. New Windows/AC/Roof. Primary bedroom has expanded area for office/seating area. Light porcelain pavers at entrance and backyard. The entrance has a lovely courtyard area for seating to accommodate the main home and casita. Foyer opens to great room, kitchen and dining area. Windows to patio area and taking in Arizona beauty plus mountain views. Great room has large entertainment wall with stacked stone in center with fireplace and TV and side shelving display units. Dining room has doors to patio area plus dining area with amazing built-in bench and wall cushioned backing plus below drawers for storage. Walking to the club! cabinetry with several glassed uppers and large pantry. Center island with sink, beverage cooler and dishwasher. Backsplash of great stacked mini stones and a hood vent over stove. Built-in microwave. Gorgeous! Primary bedroom has been expanded to include a frosted glass "barn" doored separate area for office/seating and window with incredible mountain views. Bedroom has hallway with both walk-in closet and linear closet - both custom organized. Bathroom is spa-like with designer touches. Double vanity sink, soaking tub and walk-in shower. Second bedroom has ample space, shutters and again an organized closet area. Bathroom has single vanity with walk-in shower and floating vanity with stone counter. Casita is luxury hotel perfection! Spacious bedroom with bathroom containing pedestal sink and tub/shower combination. Laundry is organized for functional ease and has access to garage. Backyard - covered patio with grill area. Multiple seating locations to enjoy the beautiful Arizona mountain views. Too many designer updates to mention here! You have to see this home to totally experience the perfection!"
+"ApprovalStatus": true
+"ArchitecturalStyle": "Ranch"
+"AssociationFee": "316.0"
+"AssociationFee2": "456.0"
+"AssociationFee2Frequency": "Quarterly"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Maintenance Grounds"
1 => "Street Maint"
]
+"AssociationName2": "CCMC"
+"AssociationPhone": "480-488-3456"
+"AssociationPhone2": "480-595-7533"
+"AssociationYN": true
+"BathroomsTotalDecimal": 3.0
+"BedroomsPossible": 3
+"BuilderName": "Del Webb"
+"BuildingAreaSource": "Appraiser"
+"CommunityFeatures": "Golf,Pickleball,Gated,Community Spa Htd,Community Pool Htd,Guarded Entry,Concierge,Tennis Court(s),Biking/Walking Path,Fitness Center"
+"ConstructionMaterials": array:4 [
0 => "Stucco"
1 => "Wood Frame"
2 => "Painted"
3 => "Block"
]
+"ContractStatusChangeDate": "2025-04-07"
+"Cooling": "Central Air,Ceiling Fan(s),Programmable Thmstat"
+"CoolingYN": true
+"Country": "US"
+"CountyOrParish": "Maricopa"
+"CoveredSpaces": "2.0"
+"CreationDate": "2025-04-08T04:27:14.533939+00:00"
+"CrossStreet": "SCOTTSDALE ROAD & TERRAVITA WAY/WESTLAND"
+"Directions": "N. SCOTTSDALE ROAD TO TERRAVITA WAY. WEST THRU GATE TO 71ST SREET MAKE RIGHT TO 2ND CANYON WREN MAKE RIGHT TO WHISPERING MESQUITE LEFT TO PROPERTY ON RIGHT."
+"Disclosures": array:3 [
0 => "Agency Discl Req"
1 => "Seller Discl Avail"
2 => "Vicinity of an Airport"
]
+"DocumentsChangeTimestamp": "2025-05-05T16:48:15Z"
+"DocumentsCount": 1
+"ElementarySchool": "Black Mountain Elementary School"
+"ElementarySchoolDistrict": "Cave Creek Unified District"
+"ExteriorFeatures": "Private Yard,Built-in Barbecue"
+"Fencing": array:2 [
0 => "Block"
1 => "Wrought Iron"
]
+"FireplaceFeatures": array:3 [
0 => "2 Fireplace"
1 => "Exterior Fireplace"
2 => "Gas"
]
+"FireplaceYN": true
+"Flooring": "Carpet,Vinyl"
+"GarageSpaces": "2.0"
+"Heating": "Natural Gas"
+"HeatingYN": true
+"HighSchool": "Cactus Shadows High School"
+"HighSchoolDistrict": "Cave Creek Unified District"
+"InteriorFeatures": "High Speed Internet,Double Vanity,Breakfast Bar,9+ Flat Ceilings,No Interior Steps,Vaulted Ceiling(s),Kitchen Island,Full Bth Master Bdrm,Separate Shwr & Tub"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAgentAOR": "Scottsdale"
+"ListAgentFax": "480-575-6592"
+"ListAgentFirstName": "Robert"
+"ListAgentKey": "20071208002552590548000000"
+"ListAgentLastName": "Lontkowski"
+"ListAgentPreferredPhone": "480-375-1940"
+"ListAgentURL": "http://www.SPArizona.com"
+"ListOfficeEmail": "[email protected]"
+"ListOfficeFax": "480-575-6592"
+"ListOfficeKey": "20120103155627488404000000"
+"ListOfficePhone": "480-437-9100"
+"ListOfficeURL": "www.SPArizona.com"
+"ListingContractDate": "2025-04-04"
+"ListingTerms": "Cash,Conventional,VA Loan"
+"LivingAreaSource": "Appraiser"
+"LotFeatures": array:7 [
0 => "Sprinklers In Rear"
1 => "Sprinklers In Front"
2 => "Desert Back"
3 => "Desert Front"
4 => "Cul-De-Sac"
5 => "Auto Timer H2O Front"
6 => "Auto Timer H2O Back"
]
+"LotSizeAcres": 0.13
+"LotSizeSource": "Assessor"
+"LotSizeSquareFeet": 5567.0
+"MiddleOrJuniorSchool": "Sonoran Trails Middle School"
+"MlsStatus": "Active"
+"Model": "Novus+Casita"
+"OnMarketDate": "2025-04-07"
+"OriginalEntryTimestamp": "2025-04-04T20:02:20Z"
+"OriginatingSystemID": "M00000048"
+"OriginatingSystemKey": "20250318164739694532000000"
+"OtherStructures": array:1 [
0 => "Separate Guest House"
]
+"ParcelNumber": "216-50-656"
+"ParkingFeatures": "Garage Door Opener,Direct Access,Attch'd Gar Cabinets"
+"PatioAndPorchFeatures": array:2 [
0 => "Covered Patio(s)"
1 => "Patio"
]
+"PhotosChangeTimestamp": "2025-05-17T12:23:59Z"
+"PhotosCount": 100
+"PoolFeatures": "None"
+"Possession": array:1 [
0 => "Close Of Escrow"
]
+"PossibleUse": array:1 [
0 => "None"
]
+"PostalCity": "Scottsdale"
+"PostalCodePlus4": "7052"
+"PublicSurveyRange": "4E"
+"PublicSurveySection": "10"
+"RoadResponsibility": array:2 [
0 => "Private Maintained Road"
1 => "Road Maintenance Agreement"
]
+"Roof": "Tile,Concrete"
+"RoomsTotal": "7"
+"SecurityFeatures": array:2 [
0 => "Fire Sprinkler System"
1 => "Security Guard"
]
+"Sewer": "Sewer in & Cnctd,Public Sewer"
+"SourceSystemID": "M00000048"
+"SourceSystemKey": "20250318164739694532000000"
+"SourceSystemName": "Arizona Regional Multiple Listing Service (ARMLS)"
+"SpaFeatures": array:1 [
0 => "None"
]
+"SpecialListingConditions": array:1 [
0 => "N/A"
]
+"StateOrProvince": "AZ"
+"StatusChangeTimestamp": "2025-04-07T22:34:45Z"
+"StoriesTotal": "1"
+"StreetDirPrefix": "E"
+"StreetName": "WHISPERING MESQUITE"
+"StreetNumber": "6936"
+"StreetNumberNumeric": "6936"
+"StreetSuffix": "Trail"
+"SubdivisionName": "Terravita"
+"TaxAnnualAmount": "2262.0"
+"TaxBookNumber": "216.00"
+"TaxLegalDescription": "LOT 3 PARCEL J/V AT TERRAVITA MCR 040617"
+"TaxLot": "3"
+"TaxMapNumber": "50.00"
+"TaxYear": "2024"
+"Township": "5N"
+"View": array:1 [
0 => "Mountain(s)"
]
+"VirtualTourURLUnbranded": "https://fusion.realtourvision.com/idx/267812"
+"WaterSource": array:1 [
0 => "City Water"
]
+"WindowFeatures": array:3 [
0 => "Skylight(s)"
1 => "Solar Screens"
2 => "Dual Pane"
]
+"Spa_co_None14": true
+"Roofing_co_Tile2": true
+"Utilities_co_APS": true
+"Fencing_co_Block2": true
+"Flooring_co_Vinyl": true
+"Flooring_co_Carpet": true
+"Laundry_co_Inside2": true
+"Roofing_co_Concrete4": true
+"Architecture_co_Ranch": true
+"Construction_co_Block": true
+"Legal_sp_Info_co_Range": "4E"
+"[email protected]": "None"
+"[email protected]": "None"
+"New_sp_Financing_co_VA5": true
+"Utilities_co_SW_sp_Gas3": true
+"Windows_co_Dual_sp_Pane": true
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Cooling_co_Central_sp_Air": true
+"[email protected]": "None"
+"Heating_co_Natural_sp_Gas": true
+"Legal_sp_Info_co_Section2": "10"
+"New_sp_Financing_co_Cash2": true
+"[email protected]": "None"
+"Basement_co_Basement_sp_YN": "N"
+"Fencing_co_Wrought_sp_Iron": true
+"[email protected]": "None"
+"Master_sp_Bedroom_co_Split": true
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Windows_co_Solar_sp_Screens": true
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Services_co_City_sp_Services": true
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Community_sp_Features_co_Golf": true
+"[email protected]": "None"
+"Exterior_sp_Features_co_Patio": true
+"Landscaping_co_Desert_sp_Back": true
+"Laundry_co_Dryer_sp_Included2": true
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Sewer_co_Sewer_sp_in_sp_Cnctd": true
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Community_sp_Features_co_Gated": true
+"Landscaping_co_Desert_sp_Front": true
+"Laundry_co_Washer_sp_Included2": true
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Features_co_Fire_sp_Sprinklers3": true
+"Kitchen_sp_Features_co_Disposal": true
+"[email protected]": "None"
+"Other_sp_Rooms_co_Great_sp_Room": true
+"Pool_sp_Features_co_No_sp_Pool2": true
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Contract_sp_Information_co_Type3": "Exclusive Right To Sell"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "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"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Features_co_9_sp_Flat_sp_Ceilings": true
+"[email protected]": "None"
+"Kitchen_sp_Features_co_Dishwasher": true
+"[email protected]": "None"
+"New_sp_Financing_co_Conventional5": true
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Association_sp_Fees_co_HOA_sp_Fee2": 316.0
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Community_sp_Features_co_Concierge": true
+"Cooling_co_Programmable_sp_Thmstat": true
+"[email protected]": "None"
+"Dining_sp_Area_co_Breakfast_sp_Bar": true
+"[email protected]": "None"
+"[email protected]": "None"
+"Location_sp_Tax_sp_Legal_co_Taxes2": 2262.0
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Technology_co_Cable_sp_TV_sp_Avail": true
+"[email protected]": "None"
+"Association_sp_Fees_co_HOA_sp_Name4": "TCC"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Features_co_No_sp_Interior_sp_Steps": true
+"Kitchen_sp_Features_co_Refrigerator": true
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Possession_co_Close_sp_of_sp_Escrow": true
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Sewer_co_Sewer_sp__hyphen__sp_Public": true
+"[email protected]": "None"
+"Assoc_sp_RulesInfo_co_Prof_sp_Managed": true
+"[email protected]": "None"
+"Association_sp_Fees_co_HOA_sp_2_sp_YN": "Y"
+"Association_sp_Fees_co_HOA_sp_3_sp_YN": "N"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Const_sp__hyphen__sp_Finish_co_Stucco": true
+"Contract_sp_Information_co_Ownership2": "Fee Simple"
+"Disclosures_co_Agency_sp_Discl_sp_Req": true
+"Features_co_Skylight_lparen_s_rparen_": true
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Master_sp_Bathroom_co_Double_sp_Sinks": true
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Const_sp__hyphen__sp_Finish_co_Painted": true
+"Dining_sp_Area_co_Dining_sp_in_sp_LRGR": true
+"[email protected]": "None"
+"Features_co_Water_sp_Softener_sp_Owned": true
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Association_sp_Fees_co_HOA_sp_2_sp_Name": "CCMC"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Disclosures_co_Seller_sp_Discl_sp_Avail": true
+"Fireplace_sp_Features_co_2_sp_Fireplace": true
+"Items_sp_Updated_co_Roof_sp_PartialFull": "Full"
+"[email protected]": "None"
+"Parking_sp_Features_co_Direct_sp_Access": true
+"Technology_co_High_sp_Speed_sp_Internet": true
+"Association_sp_Fees_co_HOA_sp_Telephone4": "480-488-3456"
+"Association_sp_Fees_co_PAD_sp_Fee_sp_YN2": "N"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Items_sp_Updated_co_Floor_sp_PartialFull": "Full"
+"Items_sp_Updated_co_Plmbg_sp_PartialFull": "Full"
+"Kitchen_sp_Features_co_Kitchen_sp_Island": true
+"Kitchen_sp_Features_co_RangeOven_sp_Elec": true
+"[email protected]": "None"
+"Add_squote_l_sp_Property_sp_Use_co_None15": true
+"[email protected]": "None"
+"[email protected]": "None"
+"Community_sp_Features_co_Guarded_sp_Entry": true
+"Construction_co_Frame_sp__hyphen__sp_Wood": true
+"Fireplace_sp_Features_co_Gas_sp_Fireplace": true
+"Items_sp_Updated_co_HtCool_sp_PartialFull": "Full"
+"Kitchen_sp_Features_co_Reverse_sp_Osmosis": true
+"[email protected]": "None"
+"Plumbing_co_Gas_sp_Hot_sp_Water_sp_Heater": true
+"[email protected]": "None"
+"Cooling_co_Ceiling_sp_Fan_lparen_s_rparen_": true
+"General_sp_Property_sp_Description_co_Pool": "Community Only"
+"Items_sp_Updated_co_Kitchen_sp_PartialFull": "Full"
+"[email protected]": "None"
+"[email protected]": "None"
+"Showing_sp_Notification_sp_Methods_co_Text": true
+"Association_sp_Fees_co_Other_sp_Fees_sp_HOA": 0.0
+"[email protected]": "None"
+"General_sp_Property_sp_Description_co_Model": "Novus+Casita"
+"Landscaping_co_Auto_sp_Timer_sp_H2O_sp_Back": true
+"Landscaping_co_Yrd_sp_Wtring_sp_Sys_sp_Back": true
+"[email protected]": "None"
+"Showing_sp_Notification_sp_Methods_co_Email": true
+"Assoc_sp_RulesInfo_co_ClubhouseRec_sp_Center": true
+"Association_sp_Fees_co_HOA_sp_2_sp_Telephone": "480-595-7533"
+"[email protected]": "None"
+"Community_sp_Features_co_Workout_sp_Facility": true
+"General_sp_Property_sp_Description_co_Horses": "N"
+"Landscaping_co_Auto_sp_Timer_sp_H2O_sp_Front": true
+"Landscaping_co_Yrd_sp_Wtring_sp_Sys_sp_Front": true
+"Association_sp_Fee_sp_Incl_co_Street_sp_Maint": true
+"[email protected]": "None"
+"Community_sp_Features_co_ClubhouseRec_sp_Room": true
+"Items_sp_Updated_co_Rm_sp_Adtn_sp_PartialFull": "Full"
+"Master_sp_Bathroom_co_Separate_sp_Shwr_sp_Tub": true
+"[email protected]": "None"
+"Association_sp_Fees_co_HOA_sp_Transfer_sp_Fee2": 400.0
+"Community_sp_Features_co_BikingWalking_sp_Path": true
+"Disclosures_co_Vicinity_sp_of_sp_an_sp_Airport": true
+"EnergyGreen_sp_Feature_co_HERS_sp_Rating_sp_YN": "N"
+"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
+"[email protected]": "None"
+"Association_sp_Fees_co_HOA_sp_Paid_sp_Frequency": "Monthly"
+"[email protected]": "None"
+"Features_co_Vaulted_sp_Ceiling_lparen_s_rparen_": true
+"General_sp_Property_sp_Description_co_PriceSqFt": 736.54
+"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": 2.0
+"Separate_sp_DenOffice_co_Sep_sp_DenOffice_sp_YN": "N"
+"[email protected]": "None"
+"Association_sp_Fees_co_Disclosure_sp_Fees_sp_HOA": 0.0
+"Community_sp_Features_co_Community_sp_Spa_sp_Htd": true
+"Community_sp_Features_co_On_hyphen_Site_sp_Guard": true
+"Location_sp_Tax_sp_Legal_co_Tax_sp_Municipality3": "Scottsdale"
+"Association_sp_Fees_co_Land_sp_Lease_sp_Fee_sp_YN": "N"
+"Association_sp_Fees_co_Rec_sp_Center_sp_Fee_sp_YN": "N"
+"Community_sp_Features_co_Community_sp_Pool_sp_Htd": true
+"Lockbox_sp_Type_co_Supra_sp__lparen_ARMLS_rparen_": true
+"Property_sp_Description_co_NorthSouth_sp_Exposure": true
+"Additional_sp_Bedroom_co_Other_sp_Bedroom_sp_Split": true
+"Association_sp_Fees_co_HOA_sp_2_sp_Transfer_sp_Fee": 400.0
+"Exterior_sp_Features_co_Separate_sp_Guest_sp_House": true
+"Association_sp_Fees_co_Special_sp_Assessment_sp_HOA": "No"
+"Association_sp_Fees_co_Ttl_sp_Mthly_sp_Fee_sp_Equiv": 468.0
+"General_sp_Property_sp_Description_co_Flood_sp_Zone": "No"
+"Kitchen_sp_Features_co_Built_hyphen_in_sp_Microwave": true
+"Master_sp_Bathroom_co_Full_sp_Bth_sp_Master_sp_Bdrm": true
+"Other_sp_Rooms_co_Guest_sp_Qtrs_hyphen_Sep_sp_Entrn": true
+"Property_sp_Description_co_Border_sp_PresPub_sp_Lnd": true
+"Showing_sp_Notification_sp_Methods_co_Phone_sp_Call": true
+"Association_sp_Fees_co_HOA_sp_Paid_sp_Frequency_sp_2": "Quarterly"
+"Existing_sp_1st_sp_Loan_co_Treat_sp_as_sp_FreeClear4": true
+"General_sp_Property_sp_Description_co_Approx_sp_SQFT": 1765.0
+"General_sp_Property_sp_Description_co_High_sp_School": "Cactus Shadows High School"
+"Association_sp_Fees_co_Disclosure_sp_Fees_sp_HOA_sp_2": 400.0
+"General_sp_Property_sp_Description_co_Builder_sp_Name": "Del Webb"
+"Legal_sp_Info_co_Cnty_sp_Rcrd_sp_Bk_sp_Pg_sp__pound_2": "040617"
+"Association_sp_Fee_sp_Incl_co_Common_sp_Area_sp_Maint3": true
+"Association_sp_Fees_co_Cap_sp_ImprovementImpact_sp_Fee": 10000.0
+"Association_sp_Fees_co_Rec_sp_Center_sp_Fee_sp_2_sp_YN": "N"
+"Road_sp_Responsibility_co_Private_sp_Maintained_sp_Road": true
+"Association_sp_Fees_co_Special_sp_Assessment_sp_HOA_sp_2": "No"
+"General_sp_Property_sp_Description_co_Dwelling_sp_Styles": "Detached"
+"General_sp_Property_sp_Description_co_Marketing_sp_Name3": "Terravita"
+"Items_sp_Updated_co_Bath_lparen_s_rparen__sp_PartialFull": "Full"
+"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
+"General_sp_Property_sp_Description_co_Elementary_sp_School": "Black Mountain Elementary School"
+"General_sp_Property_sp_Description_co_Jr_sp_High_sp_School": "Sonoran Trails Middle School"
+"Property_sp_Description_co_Cul_hyphen_De_hyphen_Sac_sp_Lot": true
+"Road_sp_Responsibility_co_Road_sp_Maintenance_sp_Agreement": true
+"Association_sp_Fees_co_Cap_sp_ImprovementImpact_sp_Fee_sp_2": 0.0
+"General_sp_Property_sp_Description_co_Approx_sp_Lot_sp_SqFt": 5567.0
+"Association_sp_Fees_co_Prepaid_sp_Association_sp_Fees_sp_HOA": 0.0
+"General_sp_Property_sp_Description_co_Guest_sp_House_sp_SqFt": 245.0
+"Community_sp_Features_co_Pickleball_sp_Court_lparen_s_rparen_": true
+"General_sp_Property_sp_Description_co_Approx_sp_Lot_sp_Acres2": 0.128
+"General_sp_Property_sp_Description_co_Planned_sp_Comm_sp_Name": "Terravita"
+"Property_sp_Description_co_Mountain_sp_View_lparen_s_rparen_2": true
+"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": 50.0
+"Assoc_sp_RulesInfo_co_Rental_sp_OK_sp__lparen_See_sp_Rmks_rparen_": true
+"Association_sp_Fees_co_Prepaid_sp_Association_sp_Fees_sp_HOA_sp_2": 0.0
+"Community_sp_Features_co_Comm_sp_Tennis_sp_Court_lparen_s_rparen_": true
+"General_sp_Property_sp_Description_co_High_sp_School_sp_District2": "Cave Creek Unified District"
+"Association_sp_Fees_co_Cap_sp_ImprovementImpact_sp_Fee_sp__percent_": "$"
+"Location_sp_Tax_sp_Legal_co_Assessor_squote_s_sp_Parcel_sp__pound_3": 656.0
+"Assoc_sp_RulesInfo_co_No_sp_Visible_sp_Truck_sp_Trailer_sp_RV_sp_Boat": true
+"Additional_sp_Bedroom_co_Master_sp_Bedroom_sp_Walk_hyphen_in_sp_Closet": true
+"General_sp_Property_sp_Description_co_Elementary_sp_School_sp_District2": "Cave Creek Unified District"
+"Association_sp_Fees_co_Cap_sp_ImprovementImpact_sp_Fee_sp_2_sp__percent_": "$"
+"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 3 PARCEL J/V AT TERRAVITA MCR 040617"
+"Contract_sp_Information_co_Co_hyphen_Ownership_sp__lparen_Fractional_rparen__sp_Agreement_sp_YN": "No"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('20250318164739694532000000')"
+"provider_name": "ARMLS"
+"Media": array:100 [
0 => array:16 [ …16]
1 => array:16 [ …16]
2 => array:16 [ …16]
3 => array:16 [ …16]
4 => array:16 [ …16]
5 => array:16 [ …16]
6 => array:16 [ …16]
7 => array:16 [ …16]
8 => array:16 [ …16]
9 => array:16 [ …16]
10 => array:16 [ …16]
11 => array:16 [ …16]
12 => array:16 [ …16]
13 => array:16 [ …16]
14 => array:16 [ …16]
15 => array:16 [ …16]
16 => array:16 [ …16]
17 => array:16 [ …16]
18 => array:16 [ …16]
19 => array:16 [ …16]
20 => array:16 [ …16]
21 => array:16 [ …16]
22 => array:16 [ …16]
23 => array:16 [ …16]
24 => array:16 [ …16]
25 => array:16 [ …16]
26 => array:16 [ …16]
27 => array:16 [ …16]
28 => array:16 [ …16]
29 => array:16 [ …16]
30 => array:16 [ …16]
31 => array:16 [ …16]
32 => array:16 [ …16]
33 => array:16 [ …16]
34 => array:16 [ …16]
35 => array:16 [ …16]
36 => array:16 [ …16]
37 => array:16 [ …16]
38 => array:16 [ …16]
39 => array:16 [ …16]
40 => array:16 [ …16]
41 => array:16 [ …16]
42 => array:16 [ …16]
43 => array:16 [ …16]
44 => array:16 [ …16]
45 => array:16 [ …16]
46 => array:16 [ …16]
47 => array:16 [ …16]
48 => array:16 [ …16]
49 => array:16 [ …16]
50 => array:16 [ …16]
51 => array:16 [ …16]
52 => array:16 [ …16]
53 => array:16 [ …16]
54 => array:16 [ …16]
55 => array:16 [ …16]
56 => array:16 [ …16]
57 => array:16 [ …16]
58 => array:16 [ …16]
59 => array:16 [ …16]
60 => array:16 [ …16]
61 => array:16 [ …16]
…38
]
+"ID": "34145"
}
]
+success: true
+page_size: 4
+page_count: 561
+count: 2241
+after_key: ""
}
"RF Response Time" => "0.24 seconds"
]
]
