array:2 [
"RF Cache Key: 7aadc4ca90442711a27b3c2cd1a3eeb2f9ea54d6d2675d910078ef4d55f5d0db" => array:1 [
"RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#4875
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6005
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "20250422192315277707000000"
+"ListingId": "6855547"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-06-08T03:06:32Z"
+"RFModificationTimestamp": "2025-06-08T03:07:29.969532+00:00"
+"ListPrice": 2600000.0
+"BathroomsTotalInteger": 5.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 19260.0
+"LivingArea": 4146.0
+"BuildingAreaTotal": 0
+"City": "Queen Creek"
+"PostalCode": "85142"
+"UnparsedAddress": "19687 E Melissa Place, Queen Creek, Az 85142"
+"Coordinates": array:2 [
0 => -111.658477
1 => 33.22616
]
+"Latitude": 33.22616
+"Longitude": -111.658477
+"YearBuilt": 2022
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Elanor Urquidez"
+"ListOfficeName": "W and Partners, LLC"
+"ListAgentMlsId": "eu019"
+"ListOfficeMlsId": "wandp003"
+"OriginatingSystemName": "ARMLS"
+"PublicRemarks": "Introducing 19687 E Melissa Pl - an opportunity to immerse yourself in a home that has been meticulously upgraded. Standing at an impressive 3,852 in the main home and 447 sq ft in the attached casita, you and your guests will first be impressed by the oversized courtyard and water sculpture. Inside the home, a floor-to-ceiling temperature and humidity-controlled wine wall welcomes you amongst 12-foot ceilings. Find white oak hardwood flooring throughout, numerous custom lighting features and home automation through Control 4. In the heart of the home - the kitchen - enjoy a double island with built-in wine fridge and waterfall quartzsite, twin built-in Sub Zero refrigerators and double wall ovens. If you'd prefer to cook outside, the fully retractable slider leads you to a back yard paradise the current stewards have invested $750,000 into perfecting, and you'll find a custom outdoor kitchen with pergola, pellet smoker, EVO grill, beverage fridge and storage. Entertaining is absolutely effortless with commercial-grade outdoor misters at the covered patio and outdoor kitchen, and outdoor speakers in the front courtyard, back yard and kitchen. The Toll Brothers plan was extended to add an additional 4 feet of space to the kitchen and primary bedroom. Property appraised at $2,680,000 in November 2024."
+"ApprovalStatus": true
+"ArchitecturalStyle": array:1 [
0 => "Contemporary"
]
+"AssociationFee": "405.0"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Other (See Remarks)"
]
+"AssociationPhone": "602-957-9191"
+"AssociationYN": true
+"BathroomsTotalDecimal": 4.5
+"BedroomsPossible": 6
+"BuilderName": "Toll Brothers"
+"BuildingAreaSource": "Assessor"
+"CoListAgentEmail": "[email protected]"
+"CoListAgentFirstName": "Kirsten"
+"CoListAgentFullName": "Kirsten Gemmer"
+"CoListAgentKey": "20250103191615313778000000"
+"CoListAgentLastName": "Gemmer"
+"CoListAgentMlsId": "km797"
+"CoListAgentMobilePhone": "602-931-0327"
+"CoListAgentPreferredPhone": "602-931-0327"
+"CoListOfficeKey": "20220131201537830693000000"
+"CoListOfficeMlsId": "wandp001"
+"CoListOfficeName": "W and Partners, LLC"
+"CommunityFeatures": array:1 [
0 => "Gated"
]
+"ConstructionMaterials": array:2 [
0 => "Stucco"
1 => "Wood Frame"
]
+"ContractStatusChangeDate": "2025-05-01"
+"Cooling": array:1 [
0 => "Central Air"
]
+"CoolingYN": true
+"Country": "US"
+"CountyOrParish": "Maricopa"
+"CoveredSpaces": "3.0"
+"CreationDate": "2025-05-01T07:42:36.117082+00:00"
+"CrossStreet": "Riggs & Hawes"
+"CurrentFinancing": array:1 [
0 => "Conventional"
]
+"Disclosures": array:2 [
0 => "Agency Discl Req"
1 => "Seller Discl Avail"
]
+"DocumentsChangeTimestamp": "2025-05-10T17:50:53Z"
+"ElementarySchool": "Queen Creek Elementary School"
+"ElementarySchoolDistrict": "Queen Creek Unified District"
+"ExteriorFeatures": array:2 [
0 => "Misting System"
1 => "Built-in Barbecue"
]
+"Fencing": array:1 [
0 => "Block"
]
+"FireplaceFeatures": array:1 [
0 => "Family Room"
]
+"FireplaceYN": true
+"Flooring": array:1 [
0 => "Other"
]
+"GarageSpaces": "3.0"
+"Heating": array:1 [
0 => "Natural Gas"
]
+"HeatingYN": true
+"HighSchool": "Crismon High School"
+"HighSchoolDistrict": "Queen Creek Unified District"
+"InteriorFeatures": array:3 [
0 => "Smart Home"
1 => "Full Bth Master Bdrm"
2 => "Separate Shwr & Tub"
]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [
0 => "Wshr/Dry HookUp Only"
]
+"ListAgentAOR": "We SERV"
+"ListAgentFirstName": "Elanor"
+"ListAgentKey": "20210917202250201224000000"
+"ListAgentLastName": "Urquidez"
+"ListAgentPreferredPhone": "480-381-1636"
+"ListAgentURL": "homeshopaz.com"
+"ListOfficeEmail": "[email protected]"
+"ListOfficeKey": "20240815170052041400000000"
+"ListOfficePhone": "520-582-6191"
+"ListingContractDate": "2025-04-22"
+"ListingTerms": array:3 [
0 => "Cash"
1 => "Conventional"
2 => "VA Loan"
]
+"LivingAreaSource": "Assessor"
+"LotFeatures": array:3 [
0 => "Desert Back"
1 => "Desert Front"
2 => "Synthetic Grass Back"
]
+"LotSizeAcres": 0.44
+"LotSizeSource": "Appraiser"
+"LotSizeSquareFeet": 19260.0
+"MiddleOrJuniorSchool": "Newell Barney College Preparatory School"
+"MlsStatus": "Active"
+"Model": "Brooks"
+"OnMarketDate": "2025-05-01"
+"OpenParkingSpaces": "2.0"
+"OriginalEntryTimestamp": "2025-04-23T04:29:18Z"
+"OriginatingSystemID": "M00000048"
+"OriginatingSystemKey": "20250422192315277707000000"
+"OtherStructures": array:1 [
0 => "Separate Guest House"
]
+"ParcelNumber": "314-08-856"
+"PatioAndPorchFeatures": array:2 [
0 => "Covered Patio(s)"
1 => "Patio"
]
+"PhotosChangeTimestamp": "2025-06-08T03:06:17Z"
+"PhotosCount": 70
+"PoolFeatures": array:2 [
0 => "Heated"
1 => "Private"
]
+"PoolPrivateYN": true
+"Possession": array:1 [
0 => "Close Of Escrow"
]
+"PostalCity": "Queen Creek"
+"PostalCodePlus4": "4162"
+"PublicSurveyRange": "7E"
+"PublicSurveySection": "29"
+"Roof": array:1 [
0 => "Other"
]
+"Sewer": array:1 [
0 => "Public Sewer"
]
+"SourceSystemID": "M00000048"
+"SourceSystemKey": "20250422192315277707000000"
+"SourceSystemName": "Arizona Regional Multiple Listing Service (ARMLS)"
+"SpaFeatures": array:1 [
0 => "None"
]
+"SpecialListingConditions": array:1 [
0 => "N/A"
]
+"StateOrProvince": "AZ"
+"StatusChangeTimestamp": "2025-05-01T07:15:51Z"
+"StoriesTotal": "1"
+"StreetDirPrefix": "E"
+"StreetName": "MELISSA"
+"StreetNumber": "19687"
+"StreetNumberNumeric": "19687"
+"StreetSuffix": "Place"
+"SubdivisionName": "Whitewing at Whisper Ranch"
+"TaxAnnualAmount": "6136.0"
+"TaxBookNumber": "314.00"
+"TaxLegalDescription": "LOT 41 SONOQUI CREEK VILLAGE MCR 138043"
+"TaxLot": "41"
+"TaxMapNumber": "8.00"
+"TaxYear": "2024"
+"Township": "2S"
+"VideosChangeTimestamp": "1970-01-01T00:00:00Z"
+"VideosCount": 1
+"WaterSource": array:1 [
0 => "City Water"
]
+"Spa_co_None14": true
+"Utilities_co_SRP": true
+"Fencing_co_Block2": true
+"Flooring_co_Other9": true
+"Roofing_co_Other33": true
+"Legal_sp_Info_co_Range": "7E"
+"[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
+"[email protected]": "None"
+"Cooling_co_Central_sp_Air": true
+"[email protected]": "None"
+"Heating_co_Natural_sp_Gas": true
+"Legal_sp_Info_co_Section2": "29"
+"Lockbox_sp_Type_co_None43": true
+"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"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Pool_sp_Features_co_Heated3": true
+"Technology_co_Smart_sp_Home": true
+"[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"
+"Exterior_sp_Features_co_Patio": true
+"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"
+"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"
+"[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": 405.0
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Location_sp_Tax_sp_Legal_co_Taxes2": 6136.0
+"[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_Name4": "Whitewing Whspr Rnch"
+"[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"
+"Other_sp_Rooms_co_BonusGame_sp_Room": true
+"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"
+"Assoc_sp_RulesInfo_co_Prof_sp_Managed": true
+"[email protected]": "None"
+"Association_sp_Fees_co_HOA_sp_2_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"
+"[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"
+"Disclosures_co_Seller_sp_Discl_sp_Avail": true
+"Existing_sp_1st_sp_Loan_co_Conventional": true
+"Kitchen_sp_Features_co_RangeOven_sp_Gas": true
+"[email protected]": "None"
+"Association_sp_Fees_co_HOA_sp_Telephone4": "602-957-9191"
+"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_Multiple_sp_Ovens": true
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Construction_co_Frame_sp__hyphen__sp_Wood": true
+"Exterior_sp_Features_co_Misting_sp_System": true
+"Landscaping_co_Synthetic_sp_Grass_sp_Back": true
+"[email protected]": "None"
+"[email protected]": "None"
+"General_sp_Property_sp_Description_co_Pool": "Private Only"
+"[email protected]": "None"
+"[email protected]": "None"
+"Association_sp_Fees_co_Other_sp_Fees_sp_HOA": 1215.0
+"[email protected]": "None"
+"General_sp_Property_sp_Description_co_Model": "Brooks"
+"[email protected]": "None"
+"[email protected]": "None"
+"General_sp_Property_sp_Description_co_Horses": "N"
+"[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": 0.0
+"Exterior_sp_Features_co_Built_hyphen_in_sp_BBQ": true
+"Parking_sp_Spaces_co_Slab_sp_Parking_sp_Spaces": 2.0
+"[email protected]": "None"
+"Association_sp_Fees_co_HOA_sp_Paid_sp_Frequency": "Monthly"
+"[email protected]": "None"
+"General_sp_Property_sp_Description_co_PriceSqFt": 627.11
+"Kitchen_sp_Features_co_Walk_hyphen_in_sp_Pantry": true
+"Master_sp_Bathroom_co_Private_sp_Toilet_sp_Room": true
+"Parking_sp_Spaces_co_Total_sp_Covered_sp_Spaces": 3.0
+"Separate_sp_DenOffice_co_Sep_sp_DenOffice_sp_YN": "Y"
+"[email protected]": "None"
+"Association_sp_Fees_co_Disclosure_sp_Fees_sp_HOA": 400.0
+"Location_sp_Tax_sp_Legal_co_Tax_sp_Municipality3": "Queen Creek"
+"Association_sp_Fees_co_Land_sp_Lease_sp_Fee_sp_YN": "N"
+"Association_sp_Fees_co_Rec_sp_Center_sp_Fee_sp_YN": "N"
+"Additional_sp_Bedroom_co_Other_sp_Bedroom_sp_Split": true
+"Exterior_sp_Features_co_Separate_sp_Guest_sp_House": true
+"Fireplace_sp_Features_co_Fireplace_sp_Family_sp_Rm": true
+"Association_sp_Fees_co_Other_sp_Fees_sp_Description": "Reserve Fee"
+"Association_sp_Fees_co_Special_sp_Assessment_sp_HOA": "No"
+"Association_sp_Fees_co_Ttl_sp_Mthly_sp_Fee_sp_Equiv": 405.0
+"Master_sp_Bathroom_co_Full_sp_Bth_sp_Master_sp_Bdrm": true
+"Other_sp_Rooms_co_Guest_sp_Qtrs_hyphen_Sep_sp_Entrn": true
+"General_sp_Property_sp_Description_co_Approx_sp_SQFT": 4146.0
+"General_sp_Property_sp_Description_co_High_sp_School": "Crismon High School"
+"General_sp_Property_sp_Description_co_Builder_sp_Name": "Toll Brothers"
+"Kitchen_sp_Features_co_Non_hyphen_laminate_sp_Counter": true
+"Association_sp_Fees_co_Cap_sp_ImprovementImpact_sp_Fee": 1215.0
+"General_sp_Property_sp_Description_co_Dwelling_sp_Styles": "Detached"
+"General_sp_Property_sp_Description_co_Marketing_sp_Name3": "Whitewing Whisper Ranch"
+"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": "Queen Creek Elementary School"
+"General_sp_Property_sp_Description_co_Jr_sp_High_sp_School": "Newell Barney College Preparatory School"
+"General_sp_Property_sp_Description_co_Approx_sp_Lot_sp_SqFt": 19260.0
+"Association_sp_Fees_co_Prepaid_sp_Association_sp_Fees_sp_HOA": 810.0
+"General_sp_Property_sp_Description_co_Guest_sp_House_sp_SqFt": 447.0
+"General_sp_Property_sp_Description_co_Approx_sp_Lot_sp_Acres2": 0.442
+"General_sp_Property_sp_Description_co_Planned_sp_Comm_sp_Name": "Whitewing at Whisper Ranch"
+"Association_sp_Fees_co_HOA_sp_DisclosureAddendum_sp_Affirmation": "Yes"
+"Location_sp_Tax_sp_Legal_co_Assessor_squote_s_sp_Map_sp__pound_3": 8.0
+"General_sp_Property_sp_Description_co_High_sp_School_sp_District2": "Queen 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": 856.0
+"Association_sp_Fee_sp_Incl_co_Other_sp__lparen_See_sp_Remarks_rparen_5": true
+"General_sp_Property_sp_Description_co_Elementary_sp_School_sp_District2": "Queen Creek Unified District"
+"General_sp_Property_sp_Description_co__pound__sp_of_sp_Interior_sp_Levels": 1
+"Location_sp_Tax_sp_Legal_co_Legal_sp_Description_sp__lparen_Abbrev_rparen_3": "LOT 41 SONOQUI CREEK VILLAGE MCR 138043"
+"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('20250422192315277707000000')"
+"provider_name": "ARMLS"
+"Media": array:70 [
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]
62 => array:16 [ …16]
63 => array:16 [ …16]
64 => array:16 [ …16]
65 => array:16 [ …16]
66 => array:16 [ …16]
67 => array:16 [ …16]
68 => array:16 [ …16]
69 => 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 'Queen Creek'/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 'Queen Creek'&$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 'Queen Creek'/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 'Queen Creek'&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#6028
+items: array:4 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6024
+post_id: "40654"
+post_author: 1
+"ListingKey": "20250502202402963525000000"
+"ListingId": "6861416"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-06-08T06:58:58Z"
+"RFModificationTimestamp": "2025-06-08T07:08:22.417974+00:00"
+"ListPrice": 740000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 12391.0
+"LivingArea": 2931.0
+"BuildingAreaTotal": 0
+"City": "Queen Creek"
+"PostalCode": "85142"
+"UnparsedAddress": "20423 S 186th Street, Queen Creek, Az 85142"
+"Coordinates": array:2 [
0 => -111.681073
1 => 33.264814
]
+"Latitude": 33.264814
+"Longitude": -111.681073
+"YearBuilt": 2004
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Sherry A Gijon"
+"ListOfficeName": "LPT Realty, LLC"
+"ListAgentMlsId": "st462"
+"ListOfficeMlsId": "lptr001"
+"OriginatingSystemName": "ARMLS"
+"PublicRemarks": "Don't miss an opportunity to come see this gorgeous single story home on a huge corner lot in desirable Sossaman Estates neighborhood! Bright and open floor plan with almost 3k sqft of space! 4 bedrooms, 2.5 bathrooms and an additional room could be 5th bedroom or office. Lots of natural light and recent paint for a fresh feel throughout. Carpet recently replaced and kitchen appliances are all like new! Backyard is a sparkling oasis to enjoy all summer long! Come check it out!"
+"Appliances": "Electric Cooktop"
+"ApprovalStatus": true
+"AssociationFee": "150.0"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Maintenance Grounds"
]
+"AssociationPhone": "480-539-1396"
+"AssociationYN": true
+"BathroomsTotalDecimal": 2.5
+"BedroomsPossible": 5
+"BuilderName": "Unknown"
+"BuildingAreaSource": "Assessor"
+"CoListAgentEmail": "[email protected]"
+"CoListAgentFirstName": "Eduardo"
+"CoListAgentFullName": "Eduardo Gijon"
+"CoListAgentKey": "20140521194119732502000000"
+"CoListAgentLastName": "Gijon"
+"CoListAgentMlsId": "eg147"
+"CoListAgentMobilePhone": "602-821-1150"
+"CoListAgentPreferredPhone": "602-821-1150"
+"CoListAgentURL": "Eand Srealty.com"
+"CoListOfficeKey": "20240105142501148599000000"
+"CoListOfficeMlsId": "lptr001"
+"CoListOfficeName": "LPT Realty, LLC"
+"CommunityFeatures": "Playground,Biking/Walking Path"
+"ConstructionMaterials": array:3 [
0 => "Stucco"
1 => "Wood Frame"
2 => "Painted"
]
+"ContractStatusChangeDate": "2025-05-08"
+"Cooling": "Central Air,Ceiling Fan(s)"
+"CoolingYN": true
+"Country": "US"
+"CountyOrParish": "Maricopa"
+"CoveredSpaces": "2.0"
+"CreationDate": "2025-05-08T18:55:23.113955+00:00"
+"CrossStreet": "Queen Creek Rd & Power Rd"
+"CurrentFinancing": array:1 [
0 => "Conventional"
]
+"Disclosures": array:2 [
0 => "Agency Discl Req"
1 => "Seller Discl Avail"
]
+"DocumentsChangeTimestamp": "2025-05-04T22:36:29Z"
+"ElementarySchool": "Cortina Elementary"
+"ElementarySchoolDistrict": "Higley Unified School District"
+"Fencing": array:2 [
0 => "Block"
1 => "Wrought Iron"
]
+"FireplaceFeatures": array:3 [
0 => "1 Fireplace"
1 => "Family Room"
2 => "Gas"
]
+"FireplaceYN": true
+"Flooring": "Carpet,Laminate,Tile"
+"GarageSpaces": "2.0"
+"Heating": "Natural Gas"
+"HeatingYN": true
+"HighSchool": "Higley High School"
+"HighSchoolDistrict": "Higley Unified School District"
+"InteriorFeatures": "High Speed Internet,Granite Counters,Double Vanity,Eat-in Kitchen,Breakfast Bar,Kitchen Island,Full Bth Master Bdrm,Separate Shwr & Tub"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAgentAOR": "We SERV"
+"ListAgentFirstName": "Sherry"
+"ListAgentKey": "20141114205902977348000000"
+"ListAgentLastName": "Gijon"
+"ListAgentPreferredPhone": "602-763-1430"
+"ListOfficeEmail": "[email protected]"
+"ListOfficeKey": "20240105142501148599000000"
+"ListOfficePhone": "877-366-2213"
+"ListingContractDate": "2025-05-03"
+"ListingTerms": "Cash,Conventional,FHA,VA Loan"
+"LivingAreaSource": "Assessor"
+"LotFeatures": array:5 [
0 => "Desert Back"
1 => "Desert Front"
2 => "Grass Back"
3 => "Synthetic Grass Frnt"
4 => "Synthetic Grass Back"
]
+"LotSizeAcres": 0.28
+"LotSizeSource": "Assessor"
+"LotSizeSquareFeet": 12391.0
+"MiddleOrJuniorSchool": "Sossaman Middle School"
+"MlsStatus": "Active"
+"OnMarketDate": "2025-05-08"
+"OriginalEntryTimestamp": "2025-05-05T00:36:28Z"
+"OriginatingSystemID": "M00000048"
+"OriginatingSystemKey": "20250502202402963525000000"
+"ParcelNumber": "304-61-633"
+"ParkingFeatures": "Garage Door Opener,Direct Access,Side Vehicle Entry"
+"PatioAndPorchFeatures": array:2 [
0 => "Covered Patio(s)"
1 => "Patio"
]
+"PhotosChangeTimestamp": "2025-05-08T19:50:16Z"
+"PhotosCount": 54
+"PoolFeatures": "Private"
+"PoolPrivateYN": true
+"Possession": array:1 [
0 => "Close Of Escrow"
]
+"PostalCity": "Queen Creek"
+"PostalCodePlus4": "3515"
+"PublicSurveyRange": "7E"
+"PublicSurveySection": "7"
+"Roof": "Tile"
+"Sewer": "Public Sewer"
+"SourceSystemID": "M00000048"
+"SourceSystemKey": "20250502202402963525000000"
+"SourceSystemName": "Arizona Regional Multiple Listing Service (ARMLS)"
+"SpaFeatures": array:1 [
0 => "None"
]
+"SpecialListingConditions": array:1 [
0 => "N/A"
]
+"StateOrProvince": "AZ"
+"StatusChangeTimestamp": "2025-05-08T18:46:55Z"
+"StoriesTotal": "1"
+"StreetDirPrefix": "S"
+"StreetName": "186TH"
+"StreetNumber": "20423"
+"StreetNumberNumeric": "20423"
+"StreetSuffix": "Street"
+"SubdivisionName": "SOSSAMAN ESTATES PARCEL B"
+"TaxAnnualAmount": "2847.0"
+"TaxBookNumber": "304.00"
+"TaxLegalDescription": "LOT 12 SOSSAMAN ESTATES PARCEL B MCR 062041"
+"TaxLot": "12"
+"TaxMapNumber": "61.00"
+"TaxYear": "2024"
+"Township": "2S"
+"WaterSource": array:1 [
0 => "City Water"
]
+"Spa_co_None14": true
+"Flooring_co_Tile": true
+"Roofing_co_Tile2": true
+"Utilities_co_SRP": true
+"Fencing_co_Block2": true
+"Flooring_co_Carpet": true
+"Laundry_co_Inside2": true
+"Flooring_co_Laminate": true
+"Legal_sp_Info_co_Range": "7E"
+"[email protected]": "None"
+"[email protected]": "None"
+"New_sp_Financing_co_VA5": true
+"Utilities_co_SW_sp_Gas3": true
+"[email protected]": "None"
+"[email protected]": "None"
+"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": "7"
+"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"
+"[email protected]": "None"
+"[email protected]": "None"
+"Landscaping_co_Grass_sp_Back": true
+"[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
+"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 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": "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"
+"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": 150.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": 2847.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": "Sossaman Estates"
+"[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"
+"Assoc_sp_RulesInfo_co_Prof_sp_Managed": true
+"[email protected]": "None"
+"Association_sp_Fees_co_HOA_sp_2_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"
+"Const_sp__hyphen__sp_Finish_co_Painted": true
+"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
+"Existing_sp_1st_sp_Loan_co_Conventional": true
+"Fireplace_sp_Features_co_1_sp_Fireplace": true
+"[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-539-1396"
+"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
+"Kitchen_sp_Features_co_Multiple_sp_Ovens": true
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Construction_co_Frame_sp__hyphen__sp_Wood": true
+"Fireplace_sp_Features_co_Gas_sp_Fireplace": true
+"Landscaping_co_Synthetic_sp_Grass_sp_Back": true
+"Landscaping_co_Synthetic_sp_Grass_sp_Frnt": true
+"[email protected]": "None"
+"[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"
+"Kitchen_sp_Features_co_Electric_sp_Cooktop": true
+"Kitchen_sp_Features_co_Granite_sp_Counters": true
+"[email protected]": "None"
+"[email protected]": "None"
+"Association_sp_Fees_co_Other_sp_Fees_sp_HOA": 0.0
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"General_sp_Property_sp_Description_co_Horses": "N"
+"[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": 1500.0
+"Community_sp_Features_co_BikingWalking_sp_Path": 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"
+"General_sp_Property_sp_Description_co_PriceSqFt": 252.47
+"Kitchen_sp_Features_co_Walk_hyphen_in_sp_Pantry": true
+"Parking_sp_Features_co_Garage_sp_Door_sp_Opener": true
+"Parking_sp_Features_co_Side_sp_Vehicle_sp_Entry": true
+"Parking_sp_Spaces_co_Total_sp_Covered_sp_Spaces": 2.0
+"Separate_sp_DenOffice_co_Sep_sp_DenOffice_sp_YN": "Y"
+"[email protected]": "None"
+"Association_sp_Fees_co_Disclosure_sp_Fees_sp_HOA": 190.0
+"Location_sp_Tax_sp_Legal_co_Tax_sp_Municipality3": "Queen Creek"
+"Association_sp_Fees_co_Land_sp_Lease_sp_Fee_sp_YN": "N"
+"Association_sp_Fees_co_Rec_sp_Center_sp_Fee_sp_YN": "N"
+"Lockbox_sp_Type_co_Supra_sp__lparen_ARMLS_rparen_": true
+"Fireplace_sp_Features_co_Fireplace_sp_Family_sp_Rm": true
+"Association_sp_Fees_co_HOA_sp_Management_sp_Company": "Brown Comm Mgmt"
+"Association_sp_Fees_co_Special_sp_Assessment_sp_HOA": "No"
+"Association_sp_Fees_co_Ttl_sp_Mthly_sp_Fee_sp_Equiv": 150.0
+"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": 2931.0
+"General_sp_Property_sp_Description_co_High_sp_School": "Higley High School"
+"Kitchen_sp_Features_co_Wall_sp_Oven_lparen_s_rparen_": true
+"Property_sp_Description_co_Borders_sp_Common_sp_Area": true
+"General_sp_Property_sp_Description_co_Builder_sp_Name": "Unknown"
+"Association_sp_Fee_sp_Incl_co_Common_sp_Area_sp_Maint3": true
+"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"
+"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": "Cortina Elementary"
+"General_sp_Property_sp_Description_co_Jr_sp_High_sp_School": "Sossaman Middle School"
+"General_sp_Property_sp_Description_co_Approx_sp_Lot_sp_SqFt": 12391.0
+"Association_sp_Fees_co_Prepaid_sp_Association_sp_Fees_sp_HOA": 300.0
+"General_sp_Property_sp_Description_co_Approx_sp_Lot_sp_Acres2": 0.284
+"Association_sp_Fees_co_HOA_sp_DisclosureAddendum_sp_Affirmation": "Yes"
+"Location_sp_Tax_sp_Legal_co_Assessor_squote_s_sp_Map_sp__pound_3": 61.0
+"General_sp_Property_sp_Description_co_High_sp_School_sp_District2": "Higley Unified School 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": 633.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": "Higley Unified School District"
+"General_sp_Property_sp_Description_co__pound__sp_of_sp_Interior_sp_Levels": 1
+"Location_sp_Tax_sp_Legal_co_Legal_sp_Description_sp__lparen_Abbrev_rparen_3": "LOT 12 SOSSAMAN ESTATES PARCEL B MCR 062041"
+"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('20250502202402963525000000')"
+"provider_name": "ARMLS"
+"Media": array:54 [
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]
]
+"ID": "40654"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6116
+post_id: "55936"
+post_author: 1
+"ListingKey": "20250426194314988984000000"
+"ListingId": "6874593"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-06-08T06:58:57Z"
+"RFModificationTimestamp": "2025-06-08T07:08:22.709907+00:00"
+"ListPrice": 482000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 8250.0
+"LivingArea": 1870.0
+"BuildingAreaTotal": 0
+"City": "Queen Creek"
+"PostalCode": "85142"
+"UnparsedAddress": "22986 S 208th Street, Queen Creek, Arizona 85142"
+"Coordinates": array:2 [
0 => -111.630882
1 => 33.239248
]
+"Latitude": 33.239248
+"Longitude": -111.630882
+"YearBuilt": 2003
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "April Mcneil Anderson"
+"ListOfficeName": "Queen Creek Real Estate"
+"ListAgentMlsId": "ag272"
+"ListOfficeMlsId": "queen001"
+"OriginatingSystemName": "ARMLS"
+"PublicRemarks": "LOCATION!! Home backs up to the Queen Creek Wash with plenty of space between you and your neighbors. The 10 foot RV gate allows you to park a car or trailer behind it. Garage has 2 1/2 car spaces, allowing for plenty of storage in addition to the storage shed that conveys with the property! Newer AC, low maintenance backyard, and recently painted exterior means living here will be a breeze! Inside, home features granite countertops, tile backsplash, wood plank vinyl flooring, and upgraded carpet and padding for cozy living! Community offers community pool, sport courts, golf course, restaurant, and is only minutes from all of the shopping, dining, and entertainment that downtown Queen Creek has to offer with more coming soon that will be within walking distance!! Welcome Home!!!"
+"ApprovalStatus": true
+"AssociationFee": "234.0"
+"AssociationFeeFrequency": "Quarterly"
+"AssociationFeeIncludes": array:1 [
0 => "Maintenance Grounds"
]
+"AssociationPhone": "480-422-0888"
+"AssociationYN": true
+"BathroomsTotalDecimal": 2.0
+"BedroomsPossible": 3
+"BuilderName": "unknown"
+"BuildingAreaSource": "Assessor"
+"CommunityFeatures": "Golf,Community Pool,Playground,Biking/Walking Path,Fitness Center"
+"ConstructionMaterials": array:3 [
0 => "Stucco"
1 => "Wood Frame"
2 => "Painted"
]
+"ContractStatusChangeDate": "2025-06-02"
+"Cooling": "Central Air,Ceiling Fan(s),Programmable Thmstat"
+"CoolingYN": true
+"Country": "US"
+"CountyOrParish": "Maricopa"
+"CoveredSpaces": "2.0"
+"CreationDate": "2025-06-02T21:33:34.837936+00:00"
+"CrossStreet": "E Ocotillo Rd & S Ellsworth Rd"
+"CurrentFinancing": array:1 [
0 => "Conventional"
]
+"Directions": "From Old Ellsworth Rd turn East on E Sierra Park Blvd - Right on S 208th St - Home is on the right - There is no sign on property"
+"Disclosures": array:2 [
0 => "Agency Discl Req"
1 => "Seller Discl Avail"
]
+"DocumentsChangeTimestamp": "2025-06-02T21:29:52Z"
+"ElementarySchool": "Frances Brandon-Pickett Elementary"
+"ElementarySchoolDistrict": "Queen Creek Unified District"
+"Fencing": array:2 [
0 => "Block"
1 => "Wrought Iron"
]
+"FireplaceFeatures": array:1 [
0 => "None"
]
+"Flooring": "Carpet,Vinyl"
+"GarageSpaces": "2.0"
+"Heating": "Natural Gas"
+"HeatingYN": true
+"HighSchool": "Crismon High School"
+"HighSchoolDistrict": "Queen Creek Unified District"
+"InteriorFeatures": "High Speed Internet,Eat-in Kitchen,Breakfast Bar,9+ Flat Ceilings,Vaulted Ceiling(s),Kitchen Island,Pantry,Full Bth Master Bdrm"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAgentAOR": "We SERV"
+"ListAgentFirstName": "April"
+"ListAgentKey": "20071208001357648745000000"
+"ListAgentLastName": "Anderson"
+"ListAgentPreferredPhone": "480-272-1977"
+"ListAgentURL": "www.queencreekrealestatesite.com"
+"ListOfficeEmail": "[email protected]"
+"ListOfficeKey": "20241219190513753146000000"
+"ListOfficePhone": "480-272-1977"
+"ListOfficeURL": "http://www.qcazliving.com"
+"ListingContractDate": "2025-06-02"
+"ListingTerms": "Cash,Conventional,FHA,VA Loan"
+"LivingAreaSource": "Assessor"
+"LotFeatures": array:4 [
0 => "Desert Front"
1 => "Natural Desert Back"
2 => "Gravel/Stone Front"
3 => "Gravel/Stone Back"
]
+"LotSizeAcres": 0.19
+"LotSizeSource": "Assessor"
+"LotSizeSquareFeet": 8250.0
+"MiddleOrJuniorSchool": "Newell Barney College Preparatory School"
+"MlsStatus": "Active"
+"OpenParkingSpaces": "2.0"
+"OriginalEntryTimestamp": "2025-06-02T23:29:50Z"
+"OriginatingSystemID": "M00000048"
+"OriginatingSystemKey": "20250426194314988984000000"
+"ParcelNumber": "304-65-891"
+"ParkingFeatures": "RV Gate,Garage Door Opener,Direct Access"
+"PatioAndPorchFeatures": array:1 [
0 => "Covered Patio(s)"
]
+"PhotosChangeTimestamp": "2025-06-02T21:29:52Z"
+"PhotosCount": 37
+"PoolFeatures": "None"
+"Possession": array:1 [
0 => "Close Of Escrow"
]
+"PostalCity": "Queen Creek"
+"PostalCodePlus4": "6962"
+"PublicSurveyRange": "7E"
+"PublicSurveySection": "22"
+"Roof": "Tile"
+"Sewer": "Public Sewer"
+"SourceSystemID": "M00000048"
+"SourceSystemKey": "20250426194314988984000000"
+"SourceSystemName": "Arizona Regional Multiple Listing Service (ARMLS)"
+"SpaFeatures": array:1 [
0 => "None"
]
+"SpecialListingConditions": array:1 [
0 => "N/A"
]
+"StateOrProvince": "AZ"
+"StatusChangeTimestamp": "2025-06-02T21:29:50Z"
+"StoriesTotal": "1"
+"StreetDirPrefix": "S"
+"StreetName": "208TH"
+"StreetNumber": "22986"
+"StreetNumberNumeric": "22986"
+"StreetSuffix": "Street"
+"SubdivisionName": "VILLAGES AT QUEEN CREEK PARCEL 7"
+"TaxAnnualAmount": "1666.0"
+"TaxBookNumber": "304.00"
+"TaxLegalDescription": "LOT 38 VILLAGES AT QUEEN CREEK PARCEL 7 MCR 057822"
+"TaxLot": "38"
+"TaxMapNumber": "65.00"
+"TaxYear": "2024"
+"Township": "2S"
+"WaterSource": array:1 [
0 => "City Water"
]
+"Spa_co_None14": true
+"Roofing_co_Tile2": true
+"Utilities_co_SRP": true
+"Fencing_co_Block2": true
+"Flooring_co_Vinyl": true
+"Flooring_co_Carpet": true
+"Laundry_co_Inside2": true
+"Legal_sp_Info_co_Range": "7E"
+"[email protected]": "None"
+"[email protected]": "None"
+"New_sp_Financing_co_VA5": true
+"Utilities_co_SW_sp_Gas3": true
+"[email protected]": "None"
+"[email protected]": "None"
+"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": "22"
+"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"
+"[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_Golf": true
+"[email protected]": "None"
+"Kitchen_sp_Features_co_Pantry": 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"
+"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"
+"Parking_sp_Features_co_RV_sp_Gate": true
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Association_sp_Fees_co_HOA_sp_Fee2": 234.0
+"[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"
+"Landscaping_co_GravelStone_sp_Back": true
+"Location_sp_Tax_sp_Legal_co_Taxes2": 1666.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": "Villages at QC HOA"
+"[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"
+"Assoc_sp_RulesInfo_co_Prof_sp_Managed": true
+"[email protected]": "None"
+"Association_sp_Fees_co_HOA_sp_2_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"
+"[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"
+"[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
+"Existing_sp_1st_sp_Loan_co_Conventional": true
+"[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-422-0888"
+"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
+"Kitchen_sp_Features_co_RangeOven_sp_Elec": true
+"Landscaping_co_Natural_sp_Desert_sp_Back": true
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Construction_co_Frame_sp__hyphen__sp_Wood": true
+"[email protected]": "None"
+"Plumbing_co_Gas_sp_Hot_sp_Water_sp_Heater": true
+"[email protected]": "None"
+"Community_sp_Features_co_Community_sp_Pool": true
+"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": "Community Only"
+"[email protected]": "None"
+"[email protected]": "None"
+"Showing_sp_Notification_sp_Methods_co_Text": true
+"Association_sp_Fees_co_Other_sp_Fees_sp_HOA": 0.5
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Community_sp_Features_co_Workout_sp_Facility": true
+"General_sp_Property_sp_Description_co_Horses": "N"
+"[email protected]": "None"
+"[email protected]": "None"
+"Association_sp_Fees_co_HOA_sp_Transfer_sp_Fee2": 150.0
+"Community_sp_Features_co_BikingWalking_sp_Path": true
+"Parking_sp_Spaces_co_Slab_sp_Parking_sp_Spaces": 2.0
+"[email protected]": "None"
+"Association_sp_Fees_co_HOA_sp_Paid_sp_Frequency": "Quarterly"
+"[email protected]": "None"
+"Features_co_Vaulted_sp_Ceiling_lparen_s_rparen_": true
+"General_sp_Property_sp_Description_co_PriceSqFt": 257.75
+"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": 250.0
+"Location_sp_Tax_sp_Legal_co_Tax_sp_Municipality3": "Queen Creek"
+"Association_sp_Fees_co_HOA_sp_Management_sp_Phone": "480-422-0888"
+"Association_sp_Fees_co_Land_sp_Lease_sp_Fee_sp_YN": "N"
+"Association_sp_Fees_co_Rec_sp_Center_sp_Fee_sp_YN": "N"
+"Lockbox_sp_Type_co_Supra_sp__lparen_ARMLS_rparen_": true
+"Property_sp_Description_co_NorthSouth_sp_Exposure": true
+"Property_sp_Description_co_Adjacent_sp_to_sp_Wash2": true
+"Association_sp_Fees_co_HOA_sp_Management_sp_Company": "Trestle Mgmt Group"
+"Association_sp_Fees_co_Other_sp_Fees_sp_Description": "Community Enhancement Fee- 0.50% of purchase price"
+"Association_sp_Fees_co_Special_sp_Assessment_sp_HOA": "No"
+"Association_sp_Fees_co_Ttl_sp_Mthly_sp_Fee_sp_Equiv": 78.0
+"Kitchen_sp_Features_co_Built_hyphen_in_sp_Microwave": true
+"Master_sp_Bathroom_co_Full_sp_Bth_sp_Master_sp_Bdrm": true
+"Showing_sp_Notification_sp_Methods_co_Phone_sp_Call": true
+"General_sp_Property_sp_Description_co_Approx_sp_SQFT": 1870.0
+"General_sp_Property_sp_Description_co_High_sp_School": "Crismon 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"
+"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"
+"Community_sp_Features_co_Children_squote_s_sp_Playgrnd": true
+"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": "Frances Brandon-Pickett Elementary"
+"General_sp_Property_sp_Description_co_Jr_sp_High_sp_School": "Newell Barney College Preparatory 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": 8250.0
+"Association_sp_Fees_co_Prepaid_sp_Association_sp_Fees_sp_HOA": 234.0
+"General_sp_Property_sp_Description_co_Approx_sp_Lot_sp_Acres2": 0.189
+"Association_sp_Fees_co_HOA_sp_DisclosureAddendum_sp_Affirmation": "Yes"
+"Location_sp_Tax_sp_Legal_co_Assessor_squote_s_sp_Map_sp__pound_3": 65.0
+"General_sp_Property_sp_Description_co_High_sp_School_sp_District2": "Queen 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": 891.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": "Queen 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 38 VILLAGES AT QUEEN CREEK PARCEL 7 MCR 057822"
+"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('20250426194314988984000000')"
+"provider_name": "ARMLS"
+"Media": array:37 [
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]
]
+"ID": "55936"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5918
+post_id: "39251"
+post_author: 1
+"ListingKey": "20250522180514471648000000"
+"ListingId": "6869973"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-06-08T06:58:55Z"
+"RFModificationTimestamp": "2025-06-08T07:08:24.586415+00:00"
+"ListPrice": 495000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 7402.0
+"LivingArea": 1678.0
+"BuildingAreaTotal": 0
+"City": "Queen Creek"
+"PostalCode": "85142"
+"UnparsedAddress": "20858 E Sonoqui Drive, Queen Creek, Arizona 85142"
+"Coordinates": array:2 [
0 => -111.630908
1 => 33.242824
]
+"Latitude": 33.242824
+"Longitude": -111.630908
+"YearBuilt": 2002
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Sheryl L Del Col"
+"ListOfficeName": "Realty ONE Group"
+"ListAgentMlsId": "sr294"
+"ListOfficeMlsId": "reog02"
+"OriginatingSystemName": "ARMLS"
+"PublicRemarks": "Welcome to your dream home in the highly sought-after Villages at Queen Creek! This home updated with a newly painted exterior, dark wood laminate flooring and neutral interior paint. The kitchen is amazing with quartzite countertops large island and SS appliances. Wait until you see the spectacular remolded primary bath with walking shower and dual vanity. The back yard truly is an oasis with the large heated pebble tec pool and spa surrounded by travertine tile. A large covered patio, extended pergola & artificial turf provide a beautiful area for outside entertaining. Don't forget—you'll also have access to the Community center. Close to everything QC has to offer!"
+"Appliances": "Gas Cooktop,Built-In Gas Oven"
+"ApprovalStatus": true
+"ArchitecturalStyle": "Ranch"
+"AssociationFee": "234.0"
+"AssociationFeeFrequency": "Quarterly"
+"AssociationFeeIncludes": array:1 [
0 => "Maintenance Grounds"
]
+"AssociationPhone": "480-422-0888"
+"AssociationYN": true
+"BathroomsTotalDecimal": 2.0
+"BedroomsPossible": 5
+"BuilderName": "Standard Pacific"
+"BuildingAreaSource": "Assessor"
+"CommunityFeatures": "Community Pool,Playground,Biking/Walking Path"
+"ConstructionMaterials": array:3 [
0 => "Stucco"
1 => "Wood Frame"
2 => "Painted"
]
+"ContractStatusChangeDate": "2025-05-22"
+"Cooling": "Central Air,Ceiling Fan(s),Programmable Thmstat"
+"CoolingYN": true
+"Country": "US"
+"CountyOrParish": "Maricopa"
+"CoveredSpaces": "2.0"
+"CreationDate": "2025-05-22T20:01:26.368851+00:00"
+"CrossStreet": "Ellsworth and Chandler Heights"
+"CurrentFinancing": array:1 [
0 => "Conventional"
]
+"Disclosures": array:2 [
0 => "Agency Discl Req"
1 => "Seller Discl Avail"
]
+"DocumentsChangeTimestamp": "2025-05-22T19:52:47Z"
+"ElementarySchool": "Frances Brandon-Pickett Elementary"
+"ElementarySchoolDistrict": "Queen Creek Unified District"
+"Fencing": array:1 [
0 => "Block"
]
+"FireplaceFeatures": array:1 [
0 => "Other"
]
+"FireplaceYN": true
+"Flooring": "Carpet,Laminate,Tile"
+"GarageSpaces": "2.0"
+"Heating": "Natural Gas"
+"HeatingYN": true
+"HighSchool": "Queen Creek High School"
+"HighSchoolDistrict": "Queen Creek Unified District"
+"InteriorFeatures": "High Speed Internet,Double Vanity,Master Downstairs,Eat-in Kitchen,9+ Flat Ceilings,No Interior Steps,Kitchen Island,3/4 Bath Master Bdrm"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [
0 => "Wshr/Dry HookUp Only"
]
+"ListAgentAOR": "We SERV"
+"ListAgentFirstName": "Sheryl"
+"ListAgentHomePhone": "602-703-6739"
+"ListAgentKey": "20071208002720307382000000"
+"ListAgentLastName": "Del Col"
+"ListAgentPreferredPhone": "602-703-6739"
+"ListOfficeEmail": "[email protected]"
+"ListOfficeKey": "20071206231750942848000000"
+"ListOfficePhone": "480-321-8100"
+"ListingContractDate": "2025-05-22"
+"ListingTerms": "Cash,Conventional,FHA,VA Loan"
+"LivingAreaSource": "Assessor"
+"LotFeatures": array:8 [
0 => "Sprinklers In Rear"
1 => "Sprinklers In Front"
2 => "Corner Lot"
3 => "Desert Back"
4 => "Desert Front"
5 => "Synthetic Grass Back"
6 => "Auto Timer H2O Front"
7 => "Auto Timer H2O Back"
]
+"LotSizeAcres": 0.17
+"LotSizeSource": "Assessor"
+"LotSizeSquareFeet": 7402.0
+"MiddleOrJuniorSchool": "Queen Creek Junior High School"
+"MlsStatus": "Active"
+"OpenParkingSpaces": "2.0"
+"OriginalEntryTimestamp": "2025-05-22T21:52:46Z"
+"OriginatingSystemID": "M00000048"
+"OriginatingSystemKey": "20250522180514471648000000"
+"OtherStructures": array:1 [
0 => "Gazebo"
]
+"ParcelNumber": "304-65-473"
+"ParkingFeatures": "Garage Door Opener,Direct Access,Attch'd Gar Cabinets"
+"PatioAndPorchFeatures": array:2 [
0 => "Covered Patio(s)"
1 => "Patio"
]
+"PhotosChangeTimestamp": "2025-05-22T19:52:47Z"
+"PhotosCount": 44
+"PoolFeatures": "Heated,Private"
+"PoolPrivateYN": true
+"Possession": array:1 [
0 => "Close Of Escrow"
]
+"PossibleUse": array:1 [
0 => "None"
]
+"PostalCity": "Queen Creek"
+"PostalCodePlus4": "6929"
+"PublicSurveyRange": "7E"
+"PublicSurveySection": "22"
+"Roof": "Tile"
+"Sewer": "Public Sewer"
+"SourceSystemID": "M00000048"
+"SourceSystemKey": "20250522180514471648000000"
+"SourceSystemName": "Arizona Regional Multiple Listing Service (ARMLS)"
+"SpaFeatures": array:2 [
0 => "Heated"
1 => "Private"
]
+"SpecialListingConditions": array:1 [
0 => "N/A"
]
+"StateOrProvince": "AZ"
+"StatusChangeTimestamp": "2025-05-22T19:52:46Z"
+"StoriesTotal": "1"
+"StreetDirPrefix": "E"
+"StreetName": "SONOQUI"
+"StreetNumber": "20858"
+"StreetNumberNumeric": "20858"
+"StreetSuffix": "Drive"
+"SubdivisionName": "VILLAGES AT QUEEN CREEK PARCEL 4A"
+"TaxAnnualAmount": "1489.0"
+"TaxBookNumber": "304.00"
+"TaxLegalDescription": "LOT 35 VILLAGES AT QUEEN CREEK PARCEL 4A MCR 057408"
+"TaxLot": "35"
+"TaxMapNumber": "65.00"
+"TaxYear": "2024"
+"Township": "2S"
+"WaterSource": array:1 [
0 => "City Water"
]
+"WindowFeatures": array:2 [
0 => "Solar Screens"
1 => "Dual Pane"
]
+"Spa_co_Heated": true
+"Spa_co_Private": true
+"Flooring_co_Tile": true
+"Roofing_co_Tile2": true
+"Utilities_co_SRP": true
+"Fencing_co_Block2": true
+"Flooring_co_Carpet": true
+"Laundry_co_Inside2": true
+"Flooring_co_Laminate": true
+"Architecture_co_Ranch": true
+"Legal_sp_Info_co_Range": "7E"
+"[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"
+"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": "22"
+"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"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Pool_sp_Features_co_Heated3": true
+"[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"
+"Pool_sp_Features_co_Private2": true
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Exterior_sp_Features_co_Patio": true
+"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"
+"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"
+"Master_sp_Bedroom_co_Downstairs": true
+"Other_sp_Rooms_co_Great_sp_Room": 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": 234.0
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Cooling_co_Programmable_sp_Thmstat": true
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Location_sp_Tax_sp_Legal_co_Taxes2": 1489.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": "Villages at QC"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Features_co_No_sp_Interior_sp_Steps": 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"
+"Exterior_sp_Features_co_GazeboRamada": true
+"[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"
+"Assoc_sp_RulesInfo_co_Prof_sp_Managed": true
+"[email protected]": "None"
+"Association_sp_Fees_co_HOA_sp_2_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"
+"Kitchen_sp_Features_co_Gas_sp_Cooktop": true
+"[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
+"[email protected]": "None"
+"Features_co_Water_sp_Softener_sp_Owned": 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"
+"Disclosures_co_Seller_sp_Discl_sp_Avail": true
+"Existing_sp_1st_sp_Loan_co_Conventional": true
+"[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-422-0888"
+"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": "Partial"
+"Kitchen_sp_Features_co_Kitchen_sp_Island": true
+"[email protected]": "None"
+"Add_squote_l_sp_Property_sp_Use_co_None15": true
+"[email protected]": "None"
+"[email protected]": "None"
+"Construction_co_Frame_sp__hyphen__sp_Wood": true
+"Landscaping_co_Synthetic_sp_Grass_sp_Back": true
+"[email protected]": "None"
+"Plumbing_co_Gas_sp_Hot_sp_Water_sp_Heater": true
+"Property_sp_Description_co_Corner_sp_Lot4": true
+"[email protected]": "None"
+"Community_sp_Features_co_Community_sp_Pool": true
+"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": "Both Private & Community"
+"Items_sp_Updated_co_Floor_sp_Yr_sp_Updated": "2020"
+"[email protected]": "None"
+"[email protected]": "None"
+"Unit_sp_Style_co_All_sp_on_sp_One_sp_Level": true
+"Association_sp_Fees_co_Other_sp_Fees_sp_HOA": 65.0
+"[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"
+"[email protected]": "None"
+"General_sp_Property_sp_Description_co_Horses": "N"
+"Landscaping_co_Auto_sp_Timer_sp_H2O_sp_Front": true
+"Landscaping_co_Yrd_sp_Wtring_sp_Sys_sp_Front": true
+"[email protected]": "None"
+"Community_sp_Features_co_ClubhouseRec_sp_Room": true
+"[email protected]": "None"
+"Association_sp_Fees_co_HOA_sp_Transfer_sp_Fee2": 150.0
+"Community_sp_Features_co_BikingWalking_sp_Path": true
+"Parking_sp_Spaces_co_Slab_sp_Parking_sp_Spaces": 2.0
+"[email protected]": "None"
+"Association_sp_Fees_co_HOA_sp_Paid_sp_Frequency": "Quarterly"
+"Contact_sp_Info_co_List_sp_Agent_sp_Home_sp_Phn": "602-703-6739"
+"[email protected]": "None"
+"General_sp_Property_sp_Description_co_PriceSqFt": 294.99
+"Parking_sp_Features_co_Garage_sp_Door_sp_Opener": true
+"Parking_sp_Spaces_co_Total_sp_Covered_sp_Spaces": 2.0
+"Separate_sp_DenOffice_co_Sep_sp_DenOffice_sp_YN": "Y"
+"[email protected]": "None"
+"Association_sp_Fees_co_Disclosure_sp_Fees_sp_HOA": 400.0
+"Location_sp_Tax_sp_Legal_co_Tax_sp_Municipality3": "Queen Creek"
+"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
+"Master_sp_Bathroom_co_34_sp_Bath_sp_Master_sp_Bdrm": true
+"Association_sp_Fees_co_HOA_sp_Management_sp_Company": "Trestle Management"
+"Association_sp_Fees_co_Other_sp_Fees_sp_Description": "Admin Transfer/Member fee 0.5% sales price"
+"Association_sp_Fees_co_Special_sp_Assessment_sp_HOA": "No"
+"Association_sp_Fees_co_Ttl_sp_Mthly_sp_Fee_sp_Equiv": 78.0
+"Kitchen_sp_Features_co_Built_hyphen_in_sp_Microwave": true
+"General_sp_Property_sp_Description_co_Approx_sp_SQFT": 1678.0
+"General_sp_Property_sp_Description_co_High_sp_School": "Queen Creek High School"
+"General_sp_Property_sp_Description_co_Builder_sp_Name": "Standard Pacific"
+"Kitchen_sp_Features_co_Non_hyphen_laminate_sp_Counter": true
+"Association_sp_Fee_sp_Incl_co_Common_sp_Area_sp_Maint3": true
+"Association_sp_Fees_co_Cap_sp_ImprovementImpact_sp_Fee": 0.0
+"Community_sp_Features_co_Children_squote_s_sp_Playgrnd": true
+"Kitchen_sp_Features_co_Built_hyphen_In_sp_Gas_sp_Oven2": true
+"General_sp_Property_sp_Description_co_Dwelling_sp_Styles": "Detached"
+"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": "Frances Brandon-Pickett Elementary"
+"General_sp_Property_sp_Description_co_Jr_sp_High_sp_School": "Queen Creek Junior High School"
+"Items_sp_Updated_co_Bath_lparen_s_rparen__sp_Yr_sp_Updated": "2025"
+"General_sp_Property_sp_Description_co_Approx_sp_Lot_sp_SqFt": 7402.0
+"Association_sp_Fees_co_Prepaid_sp_Association_sp_Fees_sp_HOA": 234.0
+"General_sp_Property_sp_Description_co_Approx_sp_Lot_sp_Acres2": 0.17
+"General_sp_Property_sp_Description_co_Planned_sp_Comm_sp_Name": "Villages at Queen Creek"
+"Association_sp_Fees_co_HOA_sp_DisclosureAddendum_sp_Affirmation": "Yes"
+"Location_sp_Tax_sp_Legal_co_Assessor_squote_s_sp_Map_sp__pound_3": 65.0
+"General_sp_Property_sp_Description_co_High_sp_School_sp_District2": "Queen Creek Unified District"
+"Fireplace_sp_Features_co_Other_sp__lparen_See_sp_Remarks_rparen_14": true
+"Association_sp_Fees_co_Cap_sp_ImprovementImpact_sp_Fee_sp__percent_": "$"
+"Location_sp_Tax_sp_Legal_co_Assessor_squote_s_sp_Parcel_sp__pound_3": 473.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": "Queen Creek Unified District"
+"General_sp_Property_sp_Description_co__pound__sp_of_sp_Interior_sp_Levels": 1
+"Location_sp_Tax_sp_Legal_co_Legal_sp_Description_sp__lparen_Abbrev_rparen_3": "LOT 35 VILLAGES AT QUEEN CREEK PARCEL 4A MCR 057408"
+"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('20250522180514471648000000')"
+"provider_name": "ARMLS"
+"Media": array:44 [
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]
…20
]
+"ID": "39251"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6118
+post_id: "41318"
+post_author: 1
+"ListingKey": "20250219174737660189000000"
+"ListingId": "6824566"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-06-08T06:58:51Z"
+"RFModificationTimestamp": "2025-06-08T07:08:28.982832+00:00"
+"ListPrice": 1150000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 18077.0
+"LivingArea": 4956.0
+"BuildingAreaTotal": 0
+"City": "Queen Creek"
+"PostalCode": "85142"
+"UnparsedAddress": "20396 E Via Del Rancho Road, Queen Creek, Az 85142"
+"Coordinates": array:2 [ …2]
+"Latitude": 33.239579
+"Longitude": -111.643581
+"YearBuilt": 2006
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Rebecca Kallhoff"
+"ListOfficeName": "RE/MAX Alliance Group"
+"ListAgentMlsId": "rk250"
+"ListOfficeMlsId": "rmal01"
+"OriginatingSystemName": "ARMLS"
+"PublicRemarks": """
Luxury Home with Resort-Style Backyard & Designer Upgrades!\r\n
\r\n
Discover this exceptional home on the largest lot in the community, offering privacy, elegance, and endless amenities. Backing up to a peaceful open area, this property is a true retreat with designer touches throughout.\r\n
\r\n
The resort-style backyard is an entertainer's dream, featuring a heated pool, tranquil koi pond, built-in BBQ, two gazebos, a miniature putt-putt golf course, and a playground with a sandbox—perfect for all ages! The private casita with a kitchenette adds versatility for guests or multi-generational living.\r\n
\r\n
Inside, enjoy a newly remodeled kitchen with high-end finishes, an elevator to the second floor, and an expansive balcony with stunning views. Recent upgrades include a new tile shower in the guest bathroom and a remodeled downstairs half bath.\n
\n
This home is truly one-of-a-kind, with so much more to offer! Don't miss your chance to own this stunning, feature-packed property
"""
+"ApprovalStatus": true
+"ArchitecturalStyle": "Contemporary"
+"AssociationFee": "252.0"
+"AssociationFeeFrequency": "Quarterly"
+"AssociationFeeIncludes": array:1 [ …1]
+"AssociationPhone": "602-437-4777"
+"AssociationYN": true
+"BathroomsTotalDecimal": 3.5
+"BedroomsPossible": 6
+"BuilderName": "NICHOLAS HOMES INC"
+"BuildingAreaSource": "Assessor"
+"CommunityFeatures": "Playground,Biking/Walking Path"
+"ConstructionMaterials": array:4 [ …4]
+"ContractStatusChangeDate": "2025-04-08"
+"Cooling": "Central Air,Ceiling Fan(s),Programmable Thmstat"
+"CoolingYN": true
+"Country": "US"
+"CountyOrParish": "Maricopa"
+"CoveredSpaces": "3.0"
+"CreationDate": "2025-04-08T16:39:38.623172+00:00"
+"CrossStreet": "Ellsworth and Chandler Heights"
+"CurrentFinancing": array:3 [ …3]
+"Directions": "From Ellsworth: Go W on Chandler Heights, S on 203rd St, R on E Camina Buena Vista to home"
+"Disclosures": array:2 [ …2]
+"DocumentsChangeTimestamp": "2025-02-21T22:08:41Z"
+"ElementarySchool": "Desert Mountain Elementary"
+"ElementarySchoolDistrict": "Queen Creek Unified District"
+"ExteriorFeatures": "Balcony,Built-in Barbecue"
+"Fencing": array:1 [ …1]
+"FireplaceFeatures": array:1 [ …1]
+"Flooring": "Carpet,Vinyl,Stone"
+"GarageSpaces": "3.0"
+"Heating": "Natural Gas"
+"HeatingYN": true
+"HighSchool": "Queen Creek High School"
+"HighSchoolDistrict": "Queen Creek Unified District"
+"InteriorFeatures": "High Speed Internet,Granite Counters,Double Vanity,Upstairs,Eat-in Kitchen,Breakfast Bar,Elevator,Vaulted Ceiling(s),Kitchen Island,Full Bth Master Bdrm,Separate Shwr & Tub"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAgentAOR": "We SERV"
+"ListAgentFirstName": "Rebecca"
+"ListAgentKey": "20071208002548758687000000"
+"ListAgentLastName": "Kallhoff"
+"ListAgentPreferredPhone": "480-275-9566"
+"ListAgentURL": "www.kallhoffteam.com"
+"ListOfficeEmail": "[email protected]"
+"ListOfficeFax": "480-813-1111"
+"ListOfficeKey": "20071206231800996089000000"
+"ListOfficePhone": "480-892-5300"
+"ListOfficeURL": "GOLDNATIONAZ.com"
+"ListingContractDate": "2025-02-21"
+"ListingTerms": "Cash,Conventional,1031 Exchange,VA Loan"
+"LivingAreaSource": "Assessor"
+"LotFeatures": array:7 [ …7]
+"LotSizeAcres": 0.42
+"LotSizeSource": "Assessor"
+"LotSizeSquareFeet": 18077.0
+"MiddleOrJuniorSchool": "Desert Mountain Elementary"
+"MlsStatus": "Active"
+"OnMarketDate": "2025-03-23"
+"OpenParkingSpaces": "6.0"
+"OriginalEntryTimestamp": "2025-02-21T23:08:38Z"
+"OriginatingSystemID": "M00000048"
+"OriginatingSystemKey": "20250219174737660189000000"
+"OtherStructures": array:2 [ …2]
+"ParcelNumber": "304-67-553"
+"ParkingFeatures": "Garage Door Opener,Electric Vehicle Charging Station(s)"
+"PatioAndPorchFeatures": array:2 [ …2]
+"PhotosChangeTimestamp": "2025-03-23T07:15:10Z"
+"PhotosCount": 96
+"PoolFeatures": "Play Pool,Variable Speed Pump,Fenced,Heated,Private"
+"PoolPrivateYN": true
+"Possession": array:1 [ …1]
+"PossibleUse": array:1 [ …1]
+"PostalCity": "Queen Creek"
+"PriceChangeTimestamp": "2025-06-04T15:42:30Z"
+"RoadResponsibility": array:1 [ …1]
+"Roof": "Tile"
+"Sewer": "Sewer in & Cnctd,Public Sewer"
+"SourceSystemID": "M00000048"
+"SourceSystemKey": "20250219174737660189000000"
+"SourceSystemName": "Arizona Regional Multiple Listing Service (ARMLS)"
+"SpaFeatures": array:1 [ …1]
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "AZ"
+"StatusChangeTimestamp": "2025-04-08T15:27:30Z"
+"StoriesTotal": "2"
+"StreetDirPrefix": "E"
+"StreetName": "Via Del Rancho"
+"StreetNumber": "20396"
+"StreetNumberNumeric": "20396"
+"StreetSuffix": "Road"
+"SubdivisionName": "MONTELENA"
+"TaxAnnualAmount": "4873.0"
+"TaxBookNumber": "304.00"
+"TaxLot": "284"
+"TaxMapNumber": "67.00"
+"TaxYear": "2004"
+"VideosChangeTimestamp": "2025-02-21T22:08:41Z"
+"VideosCount": 1
+"View": array:1 [ …1]
+"VirtualTourURLUnbranded": "https://www.zillow.com/view-imx/e42cd6fc-652b-41a8-bc62-af72d24f6e10?wl=true&set Attribution=mls&initial View Type=pano"
+"WaterSource": array:1 [ …1]
+"WindowFeatures": array:1 [ …1]
+"Spa_co_None14": true
+"Roofing_co_Tile2": true
+"Utilities_co_SRP": true
+"Fencing_co_Block2": true
+"Flooring_co_Stone": true
+"Flooring_co_Vinyl": true
+"Flooring_co_Carpet": true
+"Features_co_Elevator": true
+"[email protected]": "None"
+"[email protected]": "None"
+"New_sp_Financing_co_VA5": true
+"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"
+"Heating_co_Natural_sp_Gas": true
+"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"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Pool_sp_Features_co_Fenced2": true
+"Pool_sp_Features_co_Heated3": true
+"[email protected]": "None"
+"[email protected]": "None"
+"Architecture_co_Contemporary": true
+"[email protected]": "None"
+"[email protected]": "None"
+"Landscaping_co_Grass_sp_Back": true
+"[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
+"Laundry_co_Dryer_sp_Included2": true
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Master_sp_Bedroom_co_Upstairs": true
+"[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"
+"Existing_sp_1st_sp_Loan_co_FHA": 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"
+"Exterior_sp_Features_co_Balcony": true
+"Kitchen_sp_Features_co_Disposal": true
+"[email protected]": "None"
+"Other_sp_Rooms_co_Media_sp_Room": 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
+"Pool_sp_Features_co_Play_sp_Pool": 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": "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"
+"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": 252.0
+"[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": 4873.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": "Montelena Master Com"
+"[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"
+"Exterior_sp_Features_co_GazeboRamada": true
+"[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": "N"
+"[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"
+"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"
+"[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
+"Kitchen_sp_Features_co_RangeOven_sp_Gas": true
+"[email protected]": "None"
+"Technology_co_High_sp_Speed_sp_Internet": true
+"Association_sp_Fees_co_HOA_sp_Telephone4": "6024374777"
+"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": "Partial"
+"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
+"[email protected]": "None"
+"Plumbing_co_Gas_sp_Hot_sp_Water_sp_Heater": true
+"Property_sp_Description_co_Corner_sp_Lot4": true
+"Technology_co_3_sp_Exist_sp_Tele_sp_Lines": 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": "2023"
+"Items_sp_Updated_co_Kitchen_sp_PartialFull": "Full"
+"Kitchen_sp_Features_co_Granite_sp_Counters": true
+"[email protected]": "None"
+"[email protected]": "None"
+"Association_sp_Fees_co_Other_sp_Fees_sp_HOA": 0.0
+"[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"
+"[email protected]": "None"
+"General_sp_Property_sp_Description_co_Horses": "N"
+"Landscaping_co_Auto_sp_Timer_sp_H2O_sp_Front": true
+"Landscaping_co_Yrd_sp_Wtring_sp_Sys_sp_Front": true
+"Technology_co_Pre_hyphen_Wire_sp_Sat_sp_Dish": true
+"[email protected]": "None"
+"Master_sp_Bathroom_co_Separate_sp_Shwr_sp_Tub": true
+"[email protected]": "None"
+"Pool_sp_Features_co_Variable_sp_Speed_sp_Pump": true
+"Association_sp_Fees_co_HOA_sp_Transfer_sp_Fee2": 2500.0
+"Community_sp_Features_co_BikingWalking_sp_Path": true
+"Exterior_sp_Features_co_Built_hyphen_in_sp_BBQ": true
+"Parking_sp_Spaces_co_Slab_sp_Parking_sp_Spaces": 6.0
+"[email protected]": "None"
+"Association_sp_Fees_co_HOA_sp_Paid_sp_Frequency": "Quarterly"
+"[email protected]": "None"
+"Features_co_Vaulted_sp_Ceiling_lparen_s_rparen_": true
+"General_sp_Property_sp_Description_co_PriceSqFt": 232.04
+"Master_sp_Bathroom_co_Private_sp_Toilet_sp_Room": true
+"Parking_sp_Features_co_Garage_sp_Door_sp_Opener": true
+"Parking_sp_Spaces_co_Total_sp_Covered_sp_Spaces": 3.0
+"Separate_sp_DenOffice_co_Sep_sp_DenOffice_sp_YN": "Y"
+"[email protected]": "None"
+"Association_sp_Fees_co_Disclosure_sp_Fees_sp_HOA": 400.0
+"Location_sp_Tax_sp_Legal_co_Tax_sp_Municipality3": "Queen Creek"
+"Association_sp_Fees_co_Land_sp_Lease_sp_Fee_sp_YN": "N"
+"Association_sp_Fees_co_Rec_sp_Center_sp_Fee_sp_YN": "N"
+"Lockbox_sp_Type_co_Supra_sp__lparen_ARMLS_rparen_": true
+"Property_sp_Description_co_NorthSouth_sp_Exposure": true
+"Additional_sp_Bedroom_co_Other_sp_Bedroom_sp_Split": true
+"Exterior_sp_Features_co_Separate_sp_Guest_sp_House": true
+"Association_sp_Fees_co_Other_sp_Fees_sp_Description": "Reserve Contribution 168.00, New Owner Set up:$168"
+"Association_sp_Fees_co_Special_sp_Assessment_sp_HOA": "No"
+"Association_sp_Fees_co_Ttl_sp_Mthly_sp_Fee_sp_Equiv": 84.0
+"Kitchen_sp_Features_co_Built_hyphen_in_sp_Microwave": true
+"Master_sp_Bathroom_co_Full_sp_Bth_sp_Master_sp_Bdrm": true
+"Other_sp_Rooms_co_Guest_sp_Qtrs_hyphen_Sep_sp_Entrn": true
+"General_sp_Property_sp_Description_co_Approx_sp_SQFT": 4956.0
+"General_sp_Property_sp_Description_co_High_sp_School": "Queen Creek High School"
+"Road_sp_Responsibility_co_City_sp_Maintained_sp_Road": true
+"General_sp_Property_sp_Description_co_Builder_sp_Name": "NICHOLAS HOMES INC"
+"Association_sp_Fee_sp_Incl_co_Common_sp_Area_sp_Maint3": true
+"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"
+"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": "Desert Mountain Elementary"
+"General_sp_Property_sp_Description_co_Jr_sp_High_sp_School": "Desert Mountain Elementary"
+"General_sp_Property_sp_Description_co_Approx_sp_Lot_sp_SqFt": 18077.0
+"Association_sp_Fees_co_Prepaid_sp_Association_sp_Fees_sp_HOA": 0.0
+"General_sp_Property_sp_Description_co_Approx_sp_Lot_sp_Acres2": 0.415
+"Property_sp_Description_co_Mountain_sp_View_lparen_s_rparen_2": true
+"Existing_sp_1st_sp_Ln_sp_Trms_co_Assume_sp__hyphen__sp_Qualify": 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": 67.0
+"General_sp_Property_sp_Description_co_High_sp_School_sp_District2": "Queen Creek Unified District"
+"Association_sp_Fees_co_Cap_sp_ImprovementImpact_sp_Fee_sp__percent_": "$"
+"Existing_sp_1st_sp_Loan_co_Other_sp__lparen_See_sp_Remarks_rparen_3": true
+"Location_sp_Tax_sp_Legal_co_Assessor_squote_s_sp_Parcel_sp__pound_3": 553.0
+"General_sp_Property_sp_Description_co_Elementary_sp_School_sp_District2": "Queen Creek Unified District"
+"General_sp_Property_sp_Description_co__pound__sp_of_sp_Interior_sp_Levels": 2
+"Add_squote_l_sp_Property_sp_Use_co_Other_sp__lparen_See_sp_Remarks_rparen_15": true
+"Parking_sp_Features_co_Electric_sp_Vehicle_sp_Charging_sp_Station_lparen_s_rparen_": true
+"Contract_sp_Information_co_Co_hyphen_Ownership_sp__lparen_Fractional_rparen__sp_Agreement_sp_YN": "No"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('20250219174737660189000000')"
+"provider_name": "ARMLS"
+"Media": array:96 [ …96]
+"ID": "41318"
}
]
+success: true
+page_size: 4
+page_count: 165
+count: 659
+after_key: ""
}
"RF Response Time" => "0.18 seconds"
]
]