array:2 [
"RF Cache Key: d87e7822f4bb00f281b52ae1c5bb5b8b3b857f28511997e1f582ef43860ac645" => array:1 [
"RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#4809
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5901
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "20250424164914378523000000"
+"ListingId": "6856355"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-06-08T01:21:11Z"
+"RFModificationTimestamp": "2025-06-08T01:23:30.905695+00:00"
+"ListPrice": 762474.0
+"BathroomsTotalInteger": 5.0
+"BathroomsHalf": 0
+"BedroomsTotal": 6.0
+"LotSizeArea": 6875.0
+"LivingArea": 3601.0
+"BuildingAreaTotal": 0
+"City": "Queen Creek"
+"PostalCode": "85142"
+"UnparsedAddress": "20637 E Via Del Jardin, Queen Creek, Az 85142"
+"Coordinates": array:2 [
0 => -111.637218
1 => 33.239603
]
+"Latitude": 33.239603
+"Longitude": -111.637218
+"YearBuilt": 2025
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Tara M Talley"
+"ListOfficeName": "Taylor Morrison (MLS Only)"
+"ListAgentMlsId": "tt126"
+"ListOfficeMlsId": "lewk01"
+"OriginatingSystemName": "ARMLS"
+"PublicRemarks": "MLS#6856355 New Construction - Ready Now! The Lewiston at Ellsworth Ranch Landmark is a thoughtfully designed two-story floor plan with plenty of space to gather, relax, and recharge. Off the foyer, you'll find a private study and formal dining room, leading into the open-concept living area. The gourmet kitchen shines with quartz countertops, a spacious center island, and views into the gathering room and casual dining space. A secondary bedroom with private en-suite sits just off the gathering room, while the covered outdoor living area invites year-round enjoyment and a mountain view. Upstairs offers four secondary bedrooms—including one with a private en-suite—a shared full bath, a loft, and a convenient laundry room. The spacious primary suite features a spa-like bathroom with dual sinks, a built-in vanity, and a generous walk-in closet. Structural options added include: Gourmet kitchen, secondary bedroom and full bathroom in place of tandem garage, shower at two secondary baths."
+"Appliances": array:1 [
0 => "Gas Cooktop"
]
+"ApprovalStatus": true
+"ArchitecturalStyle": array:1 [
0 => "Santa Barbara/Tuscan"
]
+"AssociationFee": "153.0"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Maintenance Grounds"
]
+"AssociationPhone": "602-957-9191"
+"AssociationYN": true
+"BathroomsTotalDecimal": 4.5
+"BedroomsPossible": 8
+"BuilderName": "Taylor Morrison"
+"BuildingAreaSource": "Builder"
+"CommunityFeatures": array:4 [
0 => "Pickleball"
1 => "Community Pool"
2 => "Biking/Walking Path"
3 => "Fitness Center"
]
+"ConstructionMaterials": array:4 [
0 => "Stucco"
1 => "Wood Frame"
2 => "Painted"
3 => "Stone"
]
+"ContractStatusChangeDate": "2025-04-24"
+"Cooling": array:2 [
0 => "Central Air"
1 => "Programmable Thmstat"
]
+"CoolingYN": true
+"Country": "US"
+"CountyOrParish": "Maricopa"
+"CoveredSpaces": "2.0"
+"CreationDate": "2025-04-24T17:13:32.255513+00:00"
+"CrossStreet": "Ellsworth Loop and Chandler Heights"
+"Directions": "From Loop 202: Take AZ-24/Gateway Freeway, then right (south) on Ellsworth Rd, continue for about 4.5 miles straight through Ocotillo Rd, after passing Ocotillo, community is on the right-hand side"
+"Disclosures": array:1 [
0 => "None"
]
+"DocumentsChangeTimestamp": "2025-04-24T16:57:19Z"
+"ElementarySchool": "Queen Creek Elementary School"
+"ElementarySchoolDistrict": "Queen Creek Unified District"
+"Fencing": array:1 [
0 => "Block"
]
+"FireplaceFeatures": array:1 [
0 => "None"
]
+"Flooring": array:2 [
0 => "Carpet"
1 => "Tile"
]
+"GarageSpaces": "2.0"
+"Heating": array:1 [
0 => "Electric"
]
+"HeatingYN": true
+"HighSchool": "Crismon High School"
+"HighSchoolDistrict": "Queen Creek Unified District"
+"InteriorFeatures": array:7 [
0 => "Double Vanity"
1 => "Upstairs"
2 => "Eat-in Kitchen"
3 => "Breakfast Bar"
4 => "Kitchen Island"
5 => "Full Bth Master Bdrm"
6 => "Separate Shwr & Tub"
]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [
0 => "Wshr/Dry HookUp Only"
]
+"ListAgentAOR": "Scottsdale"
+"ListAgentFirstName": "Tara"
+"ListAgentKey": "20071208002813615902000000"
+"ListAgentLastName": "Talley"
+"ListAgentPreferredPhone": "480-346-1738"
+"ListOfficeEmail": "[email protected]"
+"ListOfficeFax": "480-646-3158"
+"ListOfficeKey": "20080404035124865021000000"
+"ListOfficePhone": "480-346-1738"
+"ListOfficeURL": "www.taylormorrison.com"
+"ListingContractDate": "2025-04-24"
+"ListingTerms": array:4 [
0 => "Cash"
1 => "Conventional"
2 => "FHA"
3 => "VA Loan"
]
+"LivingAreaSource": "Builder"
+"LotFeatures": array:3 [
0 => "Desert Front"
1 => "Dirt Back"
2 => "Irrigation Front"
]
+"LotSizeAcres": 0.16
+"LotSizeSource": "Assessor"
+"LotSizeSquareFeet": 6875.0
+"MiddleOrJuniorSchool": "Newell Barney College Preparatory School"
+"MlsStatus": "Active"
+"Model": "Lewiston"
+"OpenParkingSpaces": "2.0"
+"OriginalEntryTimestamp": "2025-04-24T18:57:18Z"
+"OriginatingSystemID": "M00000048"
+"OriginatingSystemKey": "20250424164914378523000000"
+"ParcelNumber": "314-16-274"
+"ParkingFeatures": array:3 [
0 => "Tandem Garage"
1 => "Garage Door Opener"
2 => "Direct Access"
]
+"PatioAndPorchFeatures": array:1 [
0 => "Covered Patio(s)"
]
+"PhotosChangeTimestamp": "2025-06-02T13:52:19Z"
+"PhotosCount": 4
+"PoolFeatures": array:1 [
0 => "None"
]
+"Possession": array:1 [
0 => "Close Of Escrow"
]
+"PostalCity": "Queen Creek"
+"PostalCodePlus4": "0234"
+"PriceChangeTimestamp": "2025-06-08T01:20:58Z"
+"PropertyCondition": array:1 [
0 => "Under Construction"
]
+"PublicSurveyRange": "7E"
+"PublicSurveySection": "21"
+"Roof": array:1 [
0 => "Tile"
]
+"RoomsTotal": "9"
+"Sewer": array:1 [
0 => "Public Sewer"
]
+"SourceSystemID": "M00000048"
+"SourceSystemKey": "20250424164914378523000000"
+"SourceSystemName": "Arizona Regional Multiple Listing Service (ARMLS)"
+"SpaFeatures": array:1 [
0 => "None"
]
+"SpecialListingConditions": array:1 [
0 => "N/A"
]
+"StateOrProvince": "AZ"
+"StatusChangeTimestamp": "2025-04-24T16:57:18Z"
+"StoriesTotal": "2"
+"StreetDirPrefix": "E"
+"StreetName": "VIA DEL JARDIN"
+"StreetNumber": "20637"
+"StreetNumberNumeric": "20637"
+"StreetSuffix": "--"
+"SubdivisionName": "ELLSWORTH RANCH PARCEL E"
+"TaxAnnualAmount": "4100.0"
+"TaxBookNumber": "314.00"
+"TaxLegalDescription": "LOT 116 ELLSWORTH RANCH PARCEL E MCR 165126"
+"TaxLot": "116"
+"TaxMapNumber": "16.00"
+"TaxYear": "2024"
+"Township": "2S"
+"View": array:1 [
0 => "Mountain(s)"
]
+"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
+"Heating_co_Electric": true
+"Disclosures_co_None10": true
+"Legal_sp_Info_co_Range": "7E"
+"Other_sp_Rooms_co_Loft": true
+"[email protected]": "None"
+"[email protected]": "None"
+"New_sp_Financing_co_VA5": true
+"[email protected]": "None"
+"[email protected]": "None"
+"Dining_sp_Area_co_Formal": true
+"New_sp_Financing_co_FHA5": true
+"[email protected]": "None"
+"Cooling_co_Central_sp_Air": true
+"[email protected]": "None"
+"Legal_sp_Info_co_Section2": "21"
+"Lockbox_sp_Type_co_None43": true
+"New_sp_Financing_co_Cash2": true
+"[email protected]": "None"
+"Basement_co_Basement_sp_YN": "N"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Landscaping_co_Dirt_sp_Back": true
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Assoc_sp_RulesInfo_co_None17": true
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[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"
+"[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"
+"Unit_sp_Style_co_Two_sp_Levels": 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"
+"Kitchen_sp_Features_co_Disposal": true
+"Laundry_co_Upstairs_sp_Laundry2": true
+"[email protected]": "None"
+"Other_sp_Rooms_co_Great_sp_Room": true
+"Pool_sp_Features_co_No_sp_Pool2": true
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Contract_sp_Information_co_Type3": "Exclusive Right To Sell"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Special_sp_Listing_sp_Cond_co_NA": true
+"Water_sp_Source_co_City_sp_Water": true
+"Association_sp_Fees_co_HOA_sp_YN2": "Y"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[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": 153.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_Irrigation_sp_Front": true
+"Location_sp_Tax_sp_Legal_co_Taxes2": 4100.0
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Association_sp_Fees_co_HOA_sp_Name4": "AAM"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Dining_sp_Area_co_Breakfast_sp_Room": 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"
+"Dining_sp_Area_co_Dining_sp_in_sp_FR": 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"
+"[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"
+"[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"
+"Architecture_co_Santa_sp_BarbaraTuscan": true
+"[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"
+"[email protected]": "None"
+"[email protected]": "None"
+"Parking_sp_Features_co_Direct_sp_Access": true
+"Parking_sp_Features_co_Tandem_sp_Garage": true
+"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"
+"Fireplace_sp_Features_co_No_sp_Fireplace": true
+"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
+"[email protected]": "None"
+"[email protected]": "None"
+"Community_sp_Features_co_Community_sp_Pool": 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"
+"Association_sp_Fees_co_Other_sp_Fees_sp_HOA": 0.0
+"[email protected]": "None"
+"General_sp_Property_sp_Description_co_Model": "Lewiston"
+"[email protected]": "None"
+"Showing_sp_Notification_sp_Methods_co_Email": true
+"[email protected]": "None"
+"Community_sp_Features_co_Workout_sp_Facility": true
+"General_sp_Property_sp_Description_co_Horses": "N"
+"[email protected]": "None"
+"Community_sp_Features_co_ClubhouseRec_sp_Room": true
+"Master_sp_Bathroom_co_Separate_sp_Shwr_sp_Tub": true
+"[email protected]": "None"
+"Association_sp_Fees_co_HOA_sp_Transfer_sp_Fee2": 100.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": "Monthly"
+"Construction_sp_Status_co_Under_sp_Construction": true
+"[email protected]": "None"
+"General_sp_Property_sp_Description_co_PriceSqFt": 211.74
+"Kitchen_sp_Features_co_Built_sp_In_sp_Recycling": true
+"Kitchen_sp_Features_co_Walk_hyphen_in_sp_Pantry": true
+"Master_sp_Bathroom_co_Private_sp_Toilet_sp_Room": true
+"Parking_sp_Features_co_Garage_sp_Door_sp_Opener": true
+"Parking_sp_Spaces_co_Total_sp_Covered_sp_Spaces": 2.0
+"Separate_sp_DenOffice_co_Sep_sp_DenOffice_sp_YN": "Y"
+"[email protected]": "None"
+"Association_sp_Fees_co_Disclosure_sp_Fees_sp_HOA": 0.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"
+"Property_sp_Description_co_NorthSouth_sp_Exposure": true
+"Kitchen_sp_Features_co_Gas_sp_Stub_sp_for_sp_Range": true
+"Association_sp_Fees_co_Special_sp_Assessment_sp_HOA": "No"
+"Association_sp_Fees_co_Ttl_sp_Mthly_sp_Fee_sp_Equiv": 153.0
+"Kitchen_sp_Features_co_Built_hyphen_in_sp_Microwave": true
+"Master_sp_Bathroom_co_Full_sp_Bth_sp_Master_sp_Bdrm": true
+"Existing_sp_1st_sp_Loan_co_Treat_sp_as_sp_FreeClear4": true
+"General_sp_Property_sp_Description_co_Approx_sp_SQFT": 3601.0
+"General_sp_Property_sp_Description_co_High_sp_School": "Crismon High School"
+"Kitchen_sp_Features_co_Wall_sp_Oven_lparen_s_rparen_": true
+"General_sp_Property_sp_Description_co_Builder_sp_Name": "Taylor Morrison"
+"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": 450.0
+"Additional_sp_Bedroom_co_Other_sp_Bedroom_sp_Downstairs": true
+"General_sp_Property_sp_Description_co_Dwelling_sp_Styles": "Detached"
+"General_sp_Property_sp_Description_co_Marketing_sp_Name3": "Ellsworth Ranch Landmark"
+"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": 6875.0
+"Association_sp_Fees_co_Prepaid_sp_Association_sp_Fees_sp_HOA": 300.0
+"Community_sp_Features_co_Pickleball_sp_Court_lparen_s_rparen_": true
+"General_sp_Property_sp_Description_co_Approx_sp_Lot_sp_Acres2": 0.158
+"General_sp_Property_sp_Description_co_Planned_sp_Comm_sp_Name": "Ellsworth Ranch Landmark"
+"Property_sp_Description_co_Mountain_sp_View_lparen_s_rparen_2": true
+"Association_sp_Fees_co_HOA_sp_DisclosureAddendum_sp_Affirmation": "No"
+"Location_sp_Tax_sp_Legal_co_Assessor_squote_s_sp_Map_sp__pound_3": 16.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": 274.0
+"Additional_sp_Bedroom_co_Other_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": 2
+"Location_sp_Tax_sp_Legal_co_Legal_sp_Description_sp__lparen_Abbrev_rparen_3": "LOT 116 ELLSWORTH RANCH PARCEL E MCR 165126"
+"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('20250424164914378523000000')"
+"provider_name": "ARMLS"
+"Media": array:4 [
0 => array:16 [ …16]
1 => array:16 [ …16]
2 => array:16 [ …16]
3 => 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 {#5773
+items: array:4 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5777
+post_id: "63125"
+post_author: 1
+"ListingKey": "20250607192549571710000000"
+"ListingId": "6877248"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-06-08T04:55:03Z"
+"RFModificationTimestamp": "2025-06-08T04:58:26.537284+00:00"
+"ListPrice": 659900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 6821.0
+"LivingArea": 2124.0
+"BuildingAreaTotal": 0
+"City": "Queen Creek"
+"PostalCode": "85140"
+"UnparsedAddress": "562 E Vesper Trail, Queen Creek, Arizona 85140"
+"Coordinates": array:2 [
0 => -111.55896
1 => 33.219503
]
+"Latitude": 33.219503
+"Longitude": -111.55896
+"YearBuilt": 2014
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Brad Daumke"
+"ListOfficeName": "Got Rentals"
+"ListAgentMlsId": "bd175"
+"ListOfficeMlsId": "gotr001"
+"OriginatingSystemName": "ARMLS"
+"PublicRemarks": "Quite possibly the most upgraded home in the Trilogy 55+ area of Encanterra. With over 2, 100 sq. ft., this 2-bedroom + den, 2.5 bath home features 10ft ceilings, solid-core doors, ceiling trim, paved driveway/walkway, custom 60/40 shutters, and upgraded tile create a warm and inviting space. Kitchen features all Jenn-Air appliances: built-in frig plus island wine frig, wall ovens, granite counter and backsplash, The spacious laundry room doubles as a convenient home office with built-in cabinetry. Private backyard retreat with travertine pavers, a BBQ island with sink, an Alfresco BBQ/refrigerator/hood, and a fountain with 2 fire pot features. 3rd car garage for your golf cart or toys. Solar city solar system owned, typical bill is under $50/month. Too many upgrades to list."
+"Appliances": "Gas Cooktop"
+"ApprovalStatus": true
+"AssociationFee": "493.83"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Maintenance Grounds"
]
+"AssociationPhone": "602-957-9191"
+"AssociationYN": true
+"BathroomsTotalDecimal": 2.5
+"BedroomsPossible": 3
+"BuilderName": "Shea Homes"
+"BuildingAreaSource": "Assessor"
+"CommunityFeatures": "Golf,Pickleball,Lake,Gated,Community Spa,Community Spa Htd,Community Pool Htd,Community Pool,Community Media Room,Guarded Entry,Tennis Court(s),Playground,Biking/Walking Path,Fitness Center"
+"ConstructionMaterials": array:3 [
0 => "Stucco"
1 => "Wood Frame"
2 => "Painted"
]
+"ContractStatusChangeDate": "2025-06-07"
+"Cooling": "Central Air"
+"CoolingYN": true
+"Country": "US"
+"CountyOrParish": "Maricopa"
+"CoveredSpaces": "3.0"
+"CreationDate": "2025-06-07T19:57:13.946182+00:00"
+"CrossStreet": "Combs and Gantzel"
+"CurrentFinancing": array:1 [
0 => "Other"
]
+"Directions": "East on Combs. South on Encanterra Dr. Go left to the guard gate. Give them the address and that you are showing the home for sale. First right after the gate, right again to Vesper Trial."
+"Disclosures": array:1 [
0 => "Seller Discl Avail"
]
+"DocumentsChangeTimestamp": "2025-06-07T19:54:25Z"
+"ElementarySchool": "Adult"
+"ElementarySchoolDistrict": "Adult"
+"ExteriorFeatures": "Private Yard,Built-in Barbecue"
+"Fencing": array:2 [
0 => "Block"
1 => "Wrought Iron"
]
+"FireplaceFeatures": array:2 [
0 => "1 Fireplace"
1 => "Gas"
]
+"FireplaceYN": true
+"Flooring": "Tile"
+"GarageSpaces": "3.0"
+"Heating": "Natural Gas"
+"HeatingYN": true
+"HighSchool": "Adult"
+"HighSchoolDistrict": "Adult"
+"InteriorFeatures": "High Speed Internet,Granite Counters,Double Vanity,Eat-in Kitchen,Breakfast Bar,No Interior Steps,Kitchen Island,Pantry,Full Bth Master Bdrm"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [
0 => "Engy Star (See Rmks)"
]
+"ListAgentAOR": "We SERV"
+"ListAgentFirstName": "Brad"
+"ListAgentKey": "20071208001439853728000000"
+"ListAgentLastName": "Daumke"
+"ListAgentPreferredPhone": "480-209-5858"
+"ListAgentURL": "www.gotrentals.com"
+"ListOfficeEmail": "[email protected]"
+"ListOfficeKey": "20230106180428986737000000"
+"ListingContractDate": "2025-06-07"
+"ListingTerms": "Cash,Conventional,FHA,VA Loan"
+"LivingAreaSource": "Assessor"
+"LotFeatures": array:6 [
0 => "Desert Back"
1 => "Desert Front"
2 => "Gravel/Stone Front"
3 => "Gravel/Stone Back"
4 => "Auto Timer H2O Front"
5 => "Auto Timer H2O Back"
]
+"LotSizeAcres": 0.16
+"LotSizeSource": "Assessor"
+"LotSizeSquareFeet": 6821.0
+"MiddleOrJuniorSchool": "Adult"
+"MlsStatus": "Active"
+"OpenParkingSpaces": "2.0"
+"OriginalEntryTimestamp": "2025-06-07T21:54:25Z"
+"OriginatingSystemID": "M00000048"
+"OriginatingSystemKey": "20250607192549571710000000"
+"ParcelNumber": "109-53-408"
+"ParkingFeatures": "Garage Door Opener,Golf Cart Garage"
+"PatioAndPorchFeatures": array:2 [
0 => "Covered Patio(s)"
1 => "Patio"
]
+"PhotosChangeTimestamp": "2025-06-07T20:32:14Z"
+"PhotosCount": 62
+"PoolFeatures": "None"
+"Possession": array:1 [
0 => "By Agreement"
]
+"PostalCity": "Queen Creek"
+"PostalCodePlus4": "5274"
+"PublicSurveyRange": "08E"
+"PublicSurveySection": "32"
+"Roof": "Tile"
+"SecurityFeatures": array:2 [
0 => "Security System Owned"
1 => "Security Guard"
]
+"Sewer": "Public Sewer"
+"SourceSystemID": "M00000048"
+"SourceSystemKey": "20250607192549571710000000"
+"SourceSystemName": "Arizona Regional Multiple Listing Service (ARMLS)"
+"SpaFeatures": array:1 [
0 => "None"
]
+"SpecialListingConditions": array:2 [
0 => "Age Restricted (See Remarks)"
1 => "N/A"
]
+"StateOrProvince": "AZ"
+"StatusChangeTimestamp": "2025-06-07T19:54:25Z"
+"StoriesTotal": "1"
+"StreetDirPrefix": "E"
+"StreetName": "VESPER"
+"StreetNumber": "562"
+"StreetNumberNumeric": "562"
+"StreetSuffix": "Trail"
+"SubdivisionName": "Encanterra Trilogy"
+"TaxAnnualAmount": "3668.0"
+"TaxBookNumber": "109.00"
+"TaxLegalDescription": "LOT 1961 SHEA HOMES AT JOHNSON FARMS, NEIGHBORHOOD 7A 20121"
+"TaxLot": "1961"
+"TaxMapNumber": "53.00"
+"TaxYear": "2024"
+"Township": "02S"
+"WaterSource": array:1 [
0 => "City Water"
]
+"WindowFeatures": array:1 [
0 => "Dual Pane"
]
+"Spa_co_None14": true
+"Flooring_co_Tile": true
+"Roofing_co_Tile2": true
+"Utilities_co_SRP": true
+"Fencing_co_Block2": true
+"Laundry_co_Inside2": true
+"Legal_sp_Info_co_Range": "08E"
+"[email protected]": "None"
+"[email protected]": "None"
+"New_sp_Financing_co_VA5": true
+"Solar_sp_Panels_co_Grid": "On"
+"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": "32"
+"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
+"Community_sp_Features_co_Lake": true
+"[email protected]": "None"
+"Exterior_sp_Features_co_Patio": true
+"Kitchen_sp_Features_co_Pantry": 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"
+"Possession_co_By_sp_Agreement": true
+"[email protected]": "None"
+"Solar_sp_Panels_co_Ownership3": "Owned Outright"
+"[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"
+"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"
+"[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": 493.83
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Dining_sp_Area_co_Breakfast_sp_Bar": true
+"[email protected]": "None"
+"[email protected]": "None"
+"Landscaping_co_GravelStone_sp_Back": true
+"Laundry_co_Gas_sp_Dryer_sp_Hookup2": true
+"Location_sp_Tax_sp_Legal_co_Taxes2": 3668.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": "Encanterra"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Features_co_No_sp_Interior_sp_Steps": true
+"Kitchen_sp_Features_co_Refrigerator": true
+"Landscaping_co_GravelStone_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"
+"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"
+"[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
+"Dining_sp_Area_co_Dining_sp_in_sp_LRGR": true
+"[email protected]": "None"
+"Features_co_Water_sp_Softener_sp_Owned": true
+"[email protected]": "None"
+"[email protected]": "None"
+"Technology_co_Security_sp_Sys_sp_Owned": true
+"[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
+"Fireplace_sp_Features_co_1_sp_Fireplace": true
+"Laundry_co_220_sp_V_sp_Dryer_sp_Hookup2": true
+"[email protected]": "None"
+"Technology_co_High_sp_Speed_sp_Internet": true
+"Association_sp_Fees_co_HOA_sp_Telephone4": "602.957.9191"
+"Association_sp_Fees_co_PAD_sp_Fee_sp_YN2": "N"
+"[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
+"Kitchen_sp_Features_co_RangeOven_sp_Elec": true
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Community_sp_Features_co_Guarded_sp_Entry": true
+"Construction_co_Frame_sp__hyphen__sp_Wood": true
+"Fireplace_sp_Features_co_Gas_sp_Fireplace": true
+"Kitchen_sp_Features_co_Reverse_sp_Osmosis": 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
+"Community_sp_Features_co_Community_sp_Spa2": true
+"Dining_sp_Area_co_Eat_hyphen_in_sp_Kitchen": true
+"General_sp_Property_sp_Description_co_Pool": "Community Only"
+"Kitchen_sp_Features_co_Granite_sp_Counters": true
+"[email protected]": "None"
+"[email protected]": "None"
+"Unit_sp_Style_co_All_sp_on_sp_One_sp_Level": true
+"Association_sp_Fees_co_Other_sp_Fees_sp_HOA": 8500.0
+"[email protected]": "None"
+"Landscaping_co_Auto_sp_Timer_sp_H2O_sp_Back": true
+"[email protected]": "None"
+"[email protected]": "None"
+"Community_sp_Features_co_Workout_sp_Facility": true
+"General_sp_Property_sp_Description_co_Horses": "N"
+"Landscaping_co_Auto_sp_Timer_sp_H2O_sp_Front": true
+"Technology_co_Pre_hyphen_Wire_sp_Srnd_sp_Snd": true
+"[email protected]": "None"
+"Community_sp_Features_co_ClubhouseRec_sp_Room": true
+"[email protected]": "None"
+"Parking_sp_Features_co_Golf_sp_Cart_sp_Garage": true
+"Association_sp_Fees_co_HOA_sp_Transfer_sp_Fee2": 0.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": 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": 310.69
+"Kitchen_sp_Features_co_Walk_hyphen_in_sp_Pantry": true
+"Master_sp_Bathroom_co_Private_sp_Toilet_sp_Room": true
+"Parking_sp_Features_co_Garage_sp_Door_sp_Opener": true
+"Parking_sp_Spaces_co_Total_sp_Covered_sp_Spaces": 3.0
+"Separate_sp_DenOffice_co_Sep_sp_DenOffice_sp_YN": "Y"
+"[email protected]": "None"
+"Additional_sp_Bedroom_co_2_sp_Master_sp_Bedrooms": true
+"Association_sp_Fees_co_Disclosure_sp_Fees_sp_HOA": 400.0
+"Community_sp_Features_co_Community_sp_Spa_sp_Htd": true
+"Community_sp_Features_co_On_hyphen_Site_sp_Guard": true
+"Location_sp_Tax_sp_Legal_co_Tax_sp_Municipality3": "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"
+"Community_sp_Features_co_Community_sp_Pool_sp_Htd": true
+"Lockbox_sp_Type_co_Supra_sp__lparen_ARMLS_rparen_": true
+"Property_sp_Description_co_NorthSouth_sp_Exposure": true
+"Association_sp_Fees_co_HOA_sp_Management_sp_Company": "AAM, LLC ."
+"Association_sp_Fees_co_Other_sp_Fees_sp_Description": "one time social fee (80% refundable)"
+"Association_sp_Fees_co_Special_sp_Assessment_sp_HOA": "No"
+"Association_sp_Fees_co_Ttl_sp_Mthly_sp_Fee_sp_Equiv": 493.83
+"Community_sp_Features_co_Community_sp_Media_sp_Room": true
+"Kitchen_sp_Features_co_Built_hyphen_in_sp_Microwave": true
+"Master_sp_Bathroom_co_Full_sp_Bth_sp_Master_sp_Bdrm": true
+"General_sp_Property_sp_Description_co_Approx_sp_SQFT": 2124.0
+"General_sp_Property_sp_Description_co_High_sp_School": "Adult"
+"General_sp_Property_sp_Description_co_Builder_sp_Name": "Shea Homes"
+"Association_sp_Fee_sp_Incl_co_Common_sp_Area_sp_Maint3": true
+"Association_sp_Fees_co_Cap_sp_ImprovementImpact_sp_Fee": 1680.0
+"Community_sp_Features_co_Children_squote_s_sp_Playgrnd": true
+"General_sp_Property_sp_Description_co_Dwelling_sp_Styles": "Detached"
+"General_sp_Property_sp_Description_co_Marketing_sp_Name3": "Encanterra Trilogy"
+"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": "Adult"
+"General_sp_Property_sp_Description_co_Jr_sp_High_sp_School": "Adult"
+"General_sp_Property_sp_Description_co_Approx_sp_Lot_sp_SqFt": 6821.0
+"Association_sp_Fees_co_Prepaid_sp_Association_sp_Fees_sp_HOA": 1481.49
+"Community_sp_Features_co_Pickleball_sp_Court_lparen_s_rparen_": true
+"General_sp_Property_sp_Description_co_Approx_sp_Lot_sp_Acres2": 0.157
+"General_sp_Property_sp_Description_co_Planned_sp_Comm_sp_Name": "Encanterra Trilogy"
+"Association_sp_Fees_co_HOA_sp_DisclosureAddendum_sp_Affirmation": "Yes"
+"Location_sp_Tax_sp_Legal_co_Assessor_squote_s_sp_Map_sp__pound_3": 53.0
+"Community_sp_Features_co_Comm_sp_Tennis_sp_Court_lparen_s_rparen_": true
+"General_sp_Property_sp_Description_co_High_sp_School_sp_District2": "Adult"
+"Kitchen_sp_Features_co_Engy_sp_Star_sp__lparen_See_sp_Rmks_rparen_": true
+"Association_sp_Fees_co_Cap_sp_ImprovementImpact_sp_Fee_sp__percent_": "$"
+"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": 408.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": "Adult"
+"General_sp_Property_sp_Description_co__pound__sp_of_sp_Interior_sp_Levels": 1
+"Exterior_sp_Features_co_Pvt_sp_Yrd_lparen_s_rparen_Crtyrd_lparen_s_rparen_": true
+"Location_sp_Tax_sp_Legal_co_Legal_sp_Description_sp__lparen_Abbrev_rparen_3": "LOT 1961 SHEA HOMES AT JOHNSON FARMS, NEIGHBORHOOD 7A 20121"
+"Special_sp_Listing_sp_Cond_co_Age_sp_Restricted_sp__lparen_See_sp_Remarks_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('20250607192549571710000000')"
+"provider_name": "ARMLS"
+"Media": array:62 [
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]
]
+"ID": "63125"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5758
+post_id: "38021"
+post_author: 1
+"ListingKey": "20250502040834207757000000"
+"ListingId": "6860526"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-06-08T04:34:55Z"
+"RFModificationTimestamp": "2025-06-08T04:39:31.600813+00:00"
+"ListPrice": 899000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 10076.0
+"LivingArea": 3150.0
+"BuildingAreaTotal": 0
+"City": "Queen Creek"
+"PostalCode": "85142"
+"UnparsedAddress": "22728 E Camacho Road, Queen Creek, Az 85142"
+"Coordinates": array:2 [
0 => -111.593165
1 => 33.255587
]
+"Latitude": 33.255587
+"Longitude": -111.593165
+"YearBuilt": 2021
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Russell Mills"
+"ListOfficeName": "Close Pros"
+"ListAgentMlsId": "rm486"
+"ListOfficeMlsId": "close001"
+"OriginatingSystemName": "ARMLS"
+"PublicRemarks": """
***Don't miss walkthrough Video*** Welcome to Equestrian at Spur Cross - a wonderful gated enclave within the sought-after Spur Cross community! This exceptional Ashton Woods home features a modern, open-concept floor plan with soaring 10-foot ceilings and thoughtful design throughout. A versatile front living room offers the perfect opportunity for a home office or study. Two spacious secondary bedrooms share a dedicated teen room—ideal for a playroom, homework space, or casual hangout. Entertain in style in the formal dining area adjacent to the chef-inspired kitchen, complete with white cabinetry, a large quartz island, extensive backsplash, and stainless appliances including a wall oven, microwave, and gas cooktop. A convenient butler's pantry with additional cabinetry enhances both storage and functionality. The great room boasts a custom shiplap-wrapped built-in entertainment center and integrated surround sound\x14perfect for cozy nights in or entertaining guests. Retreat to the luxurious master suite featuring a spa-like bathroom with a deep soaking tub, oversized tiled shower, dual vanities with a makeup station, and a massive walk-in closet. This home is filled with charm and character, thanks to thoughtfully curated trim and custom finishes throughout. You'll find plantation shutters, board and batten detailing in the hallway, shiplap accents in the breakfast nook, and elegant framed wall trim that enhances the formal dining space. The kitchen features updated light fixtures that add a modern touch.\n
\n
Enjoy low-maintenance living with artificial turf in both the front and backyards. The expansive 10,000+ sq ft lot includes a spacious backyard with a sunken trampoline\x14perfect for play and entertaining. Additional pavers in front of the RV gate provide extra parking options, and a 3-car tandem garage offers ample storage and flexibility. Don't miss this rare opportunity to own a thoughtfully designed home in one of the most desirable gated communities and experience all that Equestrian at Spur Cross has to offer!
"""
+"Appliances": "Gas Cooktop"
+"ApprovalStatus": true
+"AssociationFee": "157.0"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Maintenance Grounds"
]
+"AssociationPhone": "602-957-9191"
+"AssociationYN": true
+"BathroomsTotalDecimal": 3.0
+"BedroomsPossible": 6
+"BuilderName": "Ashton Woods"
+"BuildingAreaSource": "Assessor"
+"CommunityFeatures": "Gated,Community Pool,Playground,Biking/Walking Path"
+"ConstructionMaterials": array:4 [
0 => "Stucco"
1 => "Lap Siding"
2 => "Wood Frame"
3 => "Stone"
]
+"ContractStatusChangeDate": "2025-05-02"
+"Cooling": "Central Air,Ceiling Fan(s)"
+"CoolingYN": true
+"Country": "US"
+"CountyOrParish": "Maricopa"
+"CoveredSpaces": "3.0"
+"CreationDate": "2025-05-02T17:58:06.199010+00:00"
+"CrossStreet": "Ocotillo and Signal Butte"
+"CurrentFinancing": array:1 [
0 => "Conventional"
]
+"Disclosures": array:1 [
0 => "Seller Discl Avail"
]
+"DocumentsChangeTimestamp": "2025-06-08T04:34:41Z"
+"ElementarySchool": "Katherine Mecham Barney Elementary"
+"ElementarySchoolDistrict": "Queen Creek Unified District"
+"Fencing": array:1 [
0 => "Block"
]
+"FireplaceFeatures": array:1 [
0 => "None"
]
+"Flooring": "Carpet,Tile"
+"GarageSpaces": "3.0"
+"Heating": "Natural Gas"
+"HeatingYN": true
+"HighSchool": "Queen Creek High School"
+"HighSchoolDistrict": "Queen Creek Unified District"
+"InteriorFeatures": "Double Vanity,Eat-in Kitchen,Breakfast Bar,9+ Flat Ceilings,No Interior Steps,Full Bth Master Bdrm,Separate Shwr & Tub"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [
0 => "Wshr/Dry HookUp Only"
]
+"ListAgentAOR": "We SERV"
+"ListAgentFirstName": "Russell"
+"ListAgentKey": "20071208002601585455000000"
+"ListAgentLastName": "Mills"
+"ListAgentPreferredPhone": "480-205-9855"
+"ListOfficeEmail": "[email protected]"
+"ListOfficeFax": "801-757-0820"
+"ListOfficeKey": "20200702201747819474000000"
+"ListOfficePhone": "480-828-2136"
+"ListingContractDate": "2025-05-01"
+"ListingTerms": "Cash,Conventional,FHA,VA Loan"
+"LivingAreaSource": "Assessor"
+"LotFeatures": array:4 [
0 => "Sprinklers In Rear"
1 => "Sprinklers In Front"
2 => "Synthetic Grass Frnt"
3 => "Synthetic Grass Back"
]
+"LotSizeAcres": 0.23
+"LotSizeSource": "Assessor"
+"LotSizeSquareFeet": 10076.0
+"MiddleOrJuniorSchool": "Queen Creek Junior High School"
+"MlsStatus": "Active"
+"OpenParkingSpaces": "3.0"
+"OriginalEntryTimestamp": "2025-05-02T19:26:06Z"
+"OriginatingSystemID": "M00000048"
+"OriginatingSystemKey": "20250502040834207757000000"
+"ParcelNumber": "314-13-233"
+"ParkingFeatures": "RV Gate,Garage Door Opener"
+"PatioAndPorchFeatures": array:1 [
0 => "Covered Patio(s)"
]
+"PhotosChangeTimestamp": "2025-05-03T16:18:36Z"
+"PhotosCount": 41
+"PoolFeatures": "None"
+"Possession": array:1 [
0 => "Close Of Escrow"
]
+"PostalCity": "Queen Creek"
+"PostalCodePlus4": "2829"
+"PublicSurveyRange": "7E"
+"PublicSurveySection": "13"
+"Roof": "Tile"
+"Sewer": "Public Sewer"
+"SourceSystemID": "M00000048"
+"SourceSystemKey": "20250502040834207757000000"
+"SourceSystemName": "Arizona Regional Multiple Listing Service (ARMLS)"
+"SpaFeatures": array:1 [
0 => "None"
]
+"SpecialListingConditions": array:1 [
0 => "N/A"
]
+"StateOrProvince": "AZ"
+"StatusChangeTimestamp": "2025-05-02T17:26:06Z"
+"StoriesTotal": "1"
+"StreetDirPrefix": "E"
+"StreetName": "CAMACHO"
+"StreetNumber": "22728"
+"StreetNumberNumeric": "22728"
+"StreetSuffix": "Road"
+"SubdivisionName": "SPUR CROSS PHASE 2 PARCEL 7"
+"TaxAnnualAmount": "3178.0"
+"TaxBookNumber": "314.00"
+"TaxLegalDescription": "LOT 338 SPUR CROSS PHASE 2 PARCEL 7 MCR 139836"
+"TaxLot": "338"
+"TaxMapNumber": "13.00"
+"TaxYear": "2024"
+"Township": "2S"
+"VideosChangeTimestamp": "1970-01-01T00:00:00Z"
+"VideosCount": 1
+"WaterSource": array:1 [
0 => "City Water"
]
+"WindowFeatures": array:2 [
0 => "Low-Emissivity Windows"
1 => "Dual Pane"
]
+"Spa_co_None14": true
+"Flooring_co_Tile": true
+"Roofing_co_Tile2": true
+"Utilities_co_SRP": true
+"Fencing_co_Block2": true
+"Flooring_co_Carpet": 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
+"Windows_co_Low_hyphen_E": true
+"[email protected]": "None"
+"[email protected]": "None"
+"Dining_sp_Area_co_Formal": true
+"New_sp_Financing_co_FHA5": true
+"[email protected]": "None"
+"Cooling_co_Central_sp_Air": true
+"[email protected]": "None"
+"Heating_co_Natural_sp_Gas": true
+"Legal_sp_Info_co_Section2": "13"
+"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"
+"[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"
+"[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
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Kitchen_sp_Features_co_Disposal": true
+"[email protected]": "None"
+"Other_sp_Rooms_co_Great_sp_Room": true
+"Pool_sp_Features_co_No_sp_Pool2": true
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Contract_sp_Information_co_Type3": "Exclusive Right To Sell"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Special_sp_Listing_sp_Cond_co_NA": true
+"Water_sp_Source_co_City_sp_Water": true
+"Association_sp_Fees_co_HOA_sp_YN2": "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"
+"[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": 157.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": 3178.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": "Equestrian at Spur C"
+"[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"
+"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_Stone2": true
+"Const_sp__hyphen__sp_Finish_co_Stucco": true
+"Contract_sp_Information_co_Ownership2": "Fee Simple"
+"[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"
+"[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"
+"Disclosures_co_Seller_sp_Discl_sp_Avail": true
+"Existing_sp_1st_sp_Loan_co_Conventional": 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"
+"Fireplace_sp_Features_co_No_sp_Fireplace": true
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Construction_co_Frame_sp__hyphen__sp_Wood": true
+"Landscaping_co_Synthetic_sp_Grass_sp_Back": true
+"Landscaping_co_Synthetic_sp_Grass_sp_Frnt": true
+"[email protected]": "None"
+"[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"
+"Association_sp_Fees_co_Other_sp_Fees_sp_HOA": 236.0
+"[email protected]": "None"
+"Landscaping_co_Yrd_sp_Wtring_sp_Sys_sp_Back": true
+"[email protected]": "None"
+"[email protected]": "None"
+"Const_sp__hyphen__sp_Finish_co_Lap_sp_Siding": true
+"General_sp_Property_sp_Description_co_Horses": "N"
+"Landscaping_co_Yrd_sp_Wtring_sp_Sys_sp_Front": true
+"[email protected]": "None"
+"Master_sp_Bathroom_co_Separate_sp_Shwr_sp_Tub": true
+"[email protected]": "None"
+"Association_sp_Fees_co_HOA_sp_Transfer_sp_Fee2": 0.0
+"Community_sp_Features_co_BikingWalking_sp_Path": true
+"Parking_sp_Spaces_co_Slab_sp_Parking_sp_Spaces": 3.0
+"[email protected]": "None"
+"Association_sp_Fees_co_HOA_sp_Paid_sp_Frequency": "Monthly"
+"[email protected]": "None"
+"General_sp_Property_sp_Description_co_PriceSqFt": 285.4
+"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
+"Association_sp_Fees_co_Other_sp_Fees_sp_Description": "Reserve Contribution"
+"Association_sp_Fees_co_Special_sp_Assessment_sp_HOA": "No"
+"Association_sp_Fees_co_Ttl_sp_Mthly_sp_Fee_sp_Equiv": 157.0
+"Kitchen_sp_Features_co_Built_hyphen_in_sp_Microwave": true
+"Master_sp_Bathroom_co_Full_sp_Bth_sp_Master_sp_Bdrm": true
+"General_sp_Property_sp_Description_co_Approx_sp_SQFT": 3150.0
+"General_sp_Property_sp_Description_co_High_sp_School": "Queen Creek High School"
+"Kitchen_sp_Features_co_Wall_sp_Oven_lparen_s_rparen_": true
+"General_sp_Property_sp_Description_co_Builder_sp_Name": "Ashton Woods"
+"Association_sp_Fee_sp_Incl_co_Common_sp_Area_sp_Maint3": true
+"Association_sp_Fees_co_Cap_sp_ImprovementImpact_sp_Fee": 236.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": "Katherine Mecham Barney Elementary"
+"General_sp_Property_sp_Description_co_Jr_sp_High_sp_School": "Queen Creek Junior High School"
+"General_sp_Property_sp_Description_co_Approx_sp_Lot_sp_SqFt": 10076.0
+"Association_sp_Fees_co_Prepaid_sp_Association_sp_Fees_sp_HOA": 314.0
+"General_sp_Property_sp_Description_co_Approx_sp_Lot_sp_Acres2": 0.231
+"Association_sp_Fees_co_HOA_sp_DisclosureAddendum_sp_Affirmation": "Yes"
+"Location_sp_Tax_sp_Legal_co_Assessor_squote_s_sp_Map_sp__pound_3": 13.0
+"General_sp_Property_sp_Description_co_High_sp_School_sp_District2": "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": 233.0
+"Additional_sp_Bedroom_co_Other_sp_Bedroom_sp_Walk_hyphen_in_sp_Closet": true
+"Additional_sp_Bedroom_co_Master_sp_Bedroom_sp_Walk_hyphen_in_sp_Closet": true
+"General_sp_Property_sp_Description_co_Elementary_sp_School_sp_District2": "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 338 SPUR CROSS PHASE 2 PARCEL 7 MCR 139836"
+"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('20250502040834207757000000')"
+"provider_name": "ARMLS"
+"Media": array:41 [
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]
]
+"ID": "38021"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5728
+post_id: "30571"
+post_author: 1
+"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": "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": "Gated"
+"ConstructionMaterials": array:2 [
0 => "Stucco"
1 => "Wood Frame"
]
+"ContractStatusChangeDate": "2025-05-01"
+"Cooling": "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": "Misting System,Built-in Barbecue"
+"Fencing": array:1 [
0 => "Block"
]
+"FireplaceFeatures": array:1 [
0 => "Family Room"
]
+"FireplaceYN": true
+"Flooring": "Other"
+"GarageSpaces": "3.0"
+"Heating": "Natural Gas"
+"HeatingYN": true
+"HighSchool": "Crismon High School"
+"HighSchoolDistrict": "Queen Creek Unified District"
+"InteriorFeatures": "Smart Home,Full Bth Master Bdrm,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": "Cash,Conventional,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": "Heated,Private"
+"PoolPrivateYN": true
+"Possession": array:1 [
0 => "Close Of Escrow"
]
+"PostalCity": "Queen Creek"
+"PostalCodePlus4": "4162"
+"PublicSurveyRange": "7E"
+"PublicSurveySection": "29"
+"Roof": "Other"
+"Sewer": "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]
]
+"ID": "30571"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5756
+post_id: "52930"
+post_author: 1
+"ListingKey": "20250427012935132734000000"
+"ListingId": "6857816"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-06-08T03:06:10Z"
+"RFModificationTimestamp": "2025-06-08T03:07:51.054151+00:00"
+"ListPrice": 799990.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 10639.0
+"LivingArea": 2771.0
+"BuildingAreaTotal": 0
+"City": "Queen Creek"
+"PostalCode": "85142"
+"UnparsedAddress": "22825 E Mewes Road, Queen Creek, Arizona 85142"
+"Coordinates": array:2 [
0 => -111.591505
1 => 33.215956
]
+"Latitude": 33.215956
+"Longitude": -111.591505
+"YearBuilt": 2021
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Elanor Urquidez"
+"ListOfficeName": "W and Partners, LLC"
+"ListAgentMlsId": "eu019"
+"ListOfficeMlsId": "wandp003"
+"OriginatingSystemName": "ARMLS"
+"PublicRemarks": """
Truly a icon of organic modern design perfectly complimented by the functional flow of this popular David Weekley floor plan. Wood-look tile throughout all common areas, statement-worthy kitchen island, extended cabinetry and newly-added modern media center. Three bedrooms PLUS den and flex room. \r\n
\r\n
Life in the community of Harvest, Queen Creek offers residents the ideal blend of rural and suburban living - with a community lake with catch & release fishing, two heated community pools, playgrounds, splash pad and more - you'll enjoy exceptional amenities right at home.\r\n
\r\n
Located just across the street is Schnepf Farms & Queen Creek Olive Mill. Schnepf is a 4th generation working family farm, and Arizona's largest organic peach grower with a U-Pick Garden, country store, bakery, petting zoo, play yards, train rides and seasonal events. Queen Creek Olive Mill is a unique agri-tourism experience, restaurant and marketplace, and produces Arizona's only extra virgin olive oil.
"""
+"Appliances": "Gas Cooktop"
+"ApprovalStatus": true
+"AssociationFee": "125.0"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Maintenance Grounds"
]
+"AssociationPhone": "602-957-9191"
+"AssociationYN": true
+"BathroomsTotalDecimal": 2.5
+"BedroomsPossible": 5
+"BuilderName": "David Weekley"
+"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": "Lake,Community Pool Htd,Community Pool,Playground,Biking/Walking Path"
+"ConstructionMaterials": array:2 [
0 => "Stucco"
1 => "Wood Frame"
]
+"ContractStatusChangeDate": "2025-05-19"
+"Cooling": "Central Air,Ceiling Fan(s),Programmable Thmstat"
+"CoolingYN": true
+"Country": "US"
+"CountyOrParish": "Maricopa"
+"CoveredSpaces": "3.0"
+"CreationDate": "2025-05-19T16:26:36.386574+00:00"
+"CrossStreet": "Riggs & Rittenhouse"
+"CurrentFinancing": array:1 [
0 => "Conventional"
]
+"Disclosures": array:2 [
0 => "Agency Discl Req"
1 => "Seller Discl Avail"
]
+"DocumentsChangeTimestamp": "2025-05-10T03:42:38Z"
+"ElementarySchool": "Schnepf Elementary School"
+"ElementarySchoolDistrict": "Queen Creek Unified District"
+"Fencing": array:1 [
0 => "Block"
]
+"FireplaceFeatures": array:1 [
0 => "None"
]
+"Flooring": "Carpet,Tile"
+"GarageSpaces": "3.0"
+"Heating": "Natural Gas"
+"HeatingYN": true
+"HighSchool": "Crismon High School"
+"HighSchoolDistrict": "Queen Creek Unified District"
+"InteriorFeatures": "Double Vanity,Soft Water Loop,Pantry,3/4 Bath Master Bdrm"
+"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-26"
+"ListingTerms": "Cash,Conventional,1031 Exchange,VA Loan"
+"LivingAreaSource": "Assessor"
+"LotFeatures": array:2 [
0 => "Desert Back"
1 => "Desert Front"
]
+"LotSizeAcres": 0.24
+"LotSizeSource": "Assessor"
+"LotSizeSquareFeet": 10639.0
+"MiddleOrJuniorSchool": "Newell Barney College Preparatory School"
+"MlsStatus": "Active"
+"Model": "Azalea"
+"OnMarketDate": "2025-05-19"
+"OpenParkingSpaces": "2.0"
+"OriginalEntryTimestamp": "2025-04-27T03:51:57Z"
+"OriginatingSystemID": "M00000048"
+"OriginatingSystemKey": "20250427012935132734000000"
+"ParcelNumber": "313-30-140"
+"PhotosChangeTimestamp": "2025-06-08T03:05:43Z"
+"PhotosCount": 47
+"PoolFeatures": "None"
+"Possession": array:1 [
0 => "Close Of Escrow"
]
+"PostalCity": "Queen Creek"
+"PostalCodePlus4": "2190"
+"PublicSurveyRange": "7E"
+"PublicSurveySection": "36"
+"Roof": "Tile"
+"Sewer": "Public Sewer"
+"SourceSystemID": "M00000048"
+"SourceSystemKey": "20250427012935132734000000"
+"SourceSystemName": "Arizona Regional Multiple Listing Service (ARMLS)"
+"SpaFeatures": array:1 [
0 => "None"
]
+"SpecialListingConditions": array:1 [
0 => "N/A"
]
+"StateOrProvince": "AZ"
+"StatusChangeTimestamp": "2025-05-19T16:18:53Z"
+"StoriesTotal": "1"
+"StreetDirPrefix": "E"
+"StreetName": "MEWES"
+"StreetNumber": "22825"
+"StreetNumberNumeric": "22825"
+"StreetSuffix": "Road"
+"SubdivisionName": "HARVEST QUEEN CREEK PARCEL 1-3"
+"TaxAnnualAmount": "2669.0"
+"TaxBookNumber": "313.00"
+"TaxLegalDescription": "LOT 6 HARVEST QUEEN CREEK PARCEL 1-3 MCR 144423"
+"TaxLot": "6"
+"TaxMapNumber": "30.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
+"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": "36"
+"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"
+"[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_Lake": true
+"[email protected]": "None"
+"Kitchen_sp_Features_co_Pantry": 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"
+"[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"
+"[email protected]": "None"
+"Features_co_Soft_sp_Water_sp_Loop": 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": 125.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": 2669.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": "Harvest Queen Creek"
+"[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"
+"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"
+"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
+"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"
+"[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"
+"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"
+"Fireplace_sp_Features_co_No_sp_Fireplace": true
+"[email protected]": "None"
+"[email protected]": "None"
+"[email protected]": "None"
+"Construction_co_Frame_sp__hyphen__sp_Wood": true
+"Kitchen_sp_Features_co_Reverse_sp_Osmosis": true
+"[email protected]": "None"
+"[email protected]": "None"
+"Community_sp_Features_co_Community_sp_Pool": true
+"Cooling_co_Ceiling_sp_Fan_lparen_s_rparen_": true
+"General_sp_Property_sp_Description_co_Pool": "Community Only"
+"[email protected]": "None"
+"[email protected]": "None"
+"Association_sp_Fees_co_Other_sp_Fees_sp_HOA": 500.0
+"[email protected]": "None"
+"General_sp_Property_sp_Description_co_Model": "Azalea"
+"[email protected]": "None"
+"[email protected]": "None"
+"General_sp_Property_sp_Description_co_Horses": "N"
+"[email protected]": "None"
+"[email protected]": "None"
+"Association_sp_Fees_co_HOA_sp_Transfer_sp_Fee2": 0.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": "Monthly"
+"[email protected]": "None"
+"General_sp_Property_sp_Description_co_PriceSqFt": 288.7
+"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"
+"Community_sp_Features_co_Community_sp_Pool_sp_Htd": true
+"Lockbox_sp_Type_co_Supra_sp__lparen_ARMLS_rparen_": true
+"Additional_sp_Bedroom_co_Other_sp_Bedroom_sp_Split": true
+"Master_sp_Bathroom_co_34_sp_Bath_sp_Master_sp_Bdrm": true
+"Association_sp_Fees_co_HOA_sp_Management_sp_Company": "AAM, LLC"
+"Association_sp_Fees_co_Other_sp_Fees_sp_Description": "Reserve fund fee"
+"Association_sp_Fees_co_Special_sp_Assessment_sp_HOA": "No"
+"Association_sp_Fees_co_Ttl_sp_Mthly_sp_Fee_sp_Equiv": 125.0
+"Kitchen_sp_Features_co_Built_hyphen_in_sp_Microwave": true
+"General_sp_Property_sp_Description_co_Approx_sp_SQFT": 2771.0
+"General_sp_Property_sp_Description_co_High_sp_School": "Crismon High School"
+"Kitchen_sp_Features_co_Wall_sp_Oven_lparen_s_rparen_": true
+"General_sp_Property_sp_Description_co_Builder_sp_Name": "David Weekley"
+"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": 500.0
+"Community_sp_Features_co_Children_squote_s_sp_Playgrnd": true
+"General_sp_Property_sp_Description_co_Dwelling_sp_Styles": "Detached"
+"General_sp_Property_sp_Description_co_Marketing_sp_Name3": "Harvest Queen Creek"
+"Showing_sp_Notification_sp_Methods_co_Showing_sp_Service": "Aligned Showings"
+"General_sp_Property_sp_Description_co_Elementary_sp_School": "Schnepf 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": 10639.0
+"Association_sp_Fees_co_Prepaid_sp_Association_sp_Fees_sp_HOA": 250.0
+"General_sp_Property_sp_Description_co_Approx_sp_Lot_sp_Acres2": 0.244
+"General_sp_Property_sp_Description_co_Planned_sp_Comm_sp_Name": "Harvest 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": 30.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": 140.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 6 HARVEST QUEEN CREEK PARCEL 1-3 MCR 144423"
+"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('20250427012935132734000000')"
+"provider_name": "ARMLS"
+"Media": array:47 [
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]
…29
]
+"ID": "52930"
}
]
+success: true
+page_size: 4
+page_count: 165
+count: 659
+after_key: ""
}
"RF Response Time" => "0.29 seconds"
]
]