Please quote property reference
Chandler Property Hub - 6698857
Please quote property reference
Chandler Property Hub - 6823379
Please quote property reference
Chandler Property Hub - 6851472
Please quote property reference
Chandler Property Hub - 6599088
Please quote property reference
Chandler Property Hub - 6867952
Please quote property reference
Chandler Property Hub - 6839902
Please quote property reference
Chandler Property Hub - 6818726
Please quote property reference
Chandler Property Hub - 6850235
Please quote property reference
Chandler Property Hub - 6134536
Please quote property reference
Chandler Property Hub - 6867695
Compare listings
ComparePlease enter your username or email address. You will receive a link to create a new password via email.
array:2 [ "RF Cache Key: 62e29c88c161cb293a1ccace412476950be3b50561fec02e52eb4065f35bf58e" => array:1 [ "RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#5901 +items: array:10 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6111 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "20240430231629691152000000" +"ListingId": "6698857" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-05-28T04:02:19Z" +"RFModificationTimestamp": "2025-05-28T04:04:15.129404+00:00" +"ListPrice": 2150000.0 +"BathroomsTotalInteger": 5.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 144000.0 +"LivingArea": 4325.0 +"BuildingAreaTotal": 0 +"City": "Queen Creek" +"PostalCode": "85144" +"UnparsedAddress": "0 N Marchant Trace, Queen Creek, Az 85144" +"Coordinates": array:2 [ …2] +"Latitude": 33.2483858 +"Longitude": -111.634158 +"YearBuilt": 2025 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Craig S Binder" +"ListOfficeName": "Jason Mitchell Real Estate" +"ListAgentMlsId": "cb958" +"ListOfficeMlsId": "jmre001" +"OriginatingSystemName": "ARMLS" +"PublicRemarks": "Welcome to Ravenwood! Your future home in SanTan Foothills. This modern farmhouse offers 4 beds, 5 bath, and is situated on a spacious 3.3-acres! Designed with both horse lovers and outdoor enthusiasts in mind, its proximity to San Tan Regional Park ensures endless adventure possibilities. Spanning 4,325 square feet, the home features designer touches including Custom Cabinetry, and wide plank LVP flooring. Guests are greeted by soaring 15 ft ceilings leading seamlessly into the open-concept living area, perfect for both relaxation and entertaining. Located just a short 20-minute drive from Queen Creek shopping and surrounded by scenic mountains and trails is the perfect blend of rural charm and city convenience. Home to be built. Pricing is base price of home." +"Appliances": array:1 [ …1] +"ApprovalStatus": true +"ArchitecturalStyle": array:1 [ …1] +"AssociationFeeIncludes": array:1 [ …1] +"BathroomsTotalDecimal": 5.0 +"BedroomsPossible": 5 +"BuilderName": "Sharp Luxury Homes" +"BuildingAreaSource": "Builder" +"ConstructionMaterials": array:3 [ …3] +"ContractStatusChangeDate": "2024-05-30" +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Pinal" +"CoveredSpaces": "5.0" +"CreationDate": "2025-02-11T11:29:31.116093+00:00" +"CrossStreet": "Judd & Marchant Trace" +"CurrentFinancing": array:1 [ …1] +"Directions": "From Judd and Marchant trace south to property on the east side of the road." +"Disclosures": array:1 [ …1] +"DocumentsChangeTimestamp": "2024-05-01T00:44:39Z" +"ElementarySchool": "San Tan Heights Elementary" +"ElementarySchoolDistrict": "Florence Unified School District" +"Fencing": array:1 [ …1] +"FireplaceFeatures": array:1 [ …1] +"Flooring": array:2 [ …2] +"GarageSpaces": "5.0" +"Heating": array:1 [ …1] +"HeatingYN": true +"HighSchool": "San Tan Foothills High School" +"HighSchoolDistrict": "Florence Unified School District" +"HorseYN": true +"InteriorFeatures": array:4 [ …4] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"ListAgentAOR": "We SERV" +"ListAgentFirstName": "Craig" +"ListAgentKey": "20200309215131863475000000" +"ListAgentLastName": "Binder" +"ListAgentPreferredPhone": "602-524-5320" +"ListAgentURL": "www.homefinderbinder.com" +"ListOfficeEmail": "[email protected]" +"ListOfficeKey": "20191126173013764231000000" +"ListOfficePhone": "480-522-1030" +"ListingContractDate": "2024-04-30" +"ListingTerms": array:3 [ …3] +"LivingAreaSource": "Builder" +"LotFeatures": array:3 [ …3] +"LotSizeAcres": 3.31 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 144000.0 +"MiddleOrJuniorSchool": "San Tan Heights Elementary" +"MlsStatus": "Active" +"OnMarketDate": "2024-05-30" +"OpenParkingSpaces": "4.0" +"OriginalEntryTimestamp": "2024-05-01T02:44:38Z" +"OriginatingSystemID": "M00000048" +"OriginatingSystemKey": "20240430231629691152000000" +"ParcelNumber": "509-20-011-J" +"ParkingFeatures": array:3 [ …3] +"PhotosChangeTimestamp": "2024-08-07T19:26:55Z" +"PhotosCount": 32 +"PoolFeatures": array:1 [ …1] +"Possession": array:1 [ …1] +"PostalCity": "Queen Creek" +"PriceChangeTimestamp": "2025-05-28T04:01:37Z" +"PropertyCondition": array:1 [ …1] +"RoadResponsibility": array:1 [ …1] +"Roof": array:1 [ …1] +"Sewer": array:1 [ …1] +"SourceSystemID": "M00000048" +"SourceSystemKey": "20240430231629691152000000" +"SourceSystemName": "Arizona Regional Multiple Listing Service (ARMLS)" +"SpaFeatures": array:1 [ …1] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "AZ" +"StatusChangeTimestamp": "2024-05-30T07:15:38Z" +"StoriesTotal": "1" +"StreetDirPrefix": "N" +"StreetName": "Marchant Trace" +"StreetNumber": "0" +"StreetSuffix": "--" +"SubdivisionName": "A PORTION OF THE WEST HALF OF PARCEL 1 OF BONANZA" +"TaxAnnualAmount": "3000.0" +"TaxBookNumber": "509.00" +"TaxLot": "1" +"TaxMapNumber": "20.00" +"TaxParcelLetter": "J" +"TaxYear": "2023" +"View": array:1 [ …1] +"WaterSource": array:1 [ …1] +"WindowFeatures": array:2 [ …2] +"Spa_co_None14": true +"Roofing_co_Tile2": true +"Utilities_co_SRP": true +"Fencing_co_Block2": true +"Flooring_co_Carpet": true +"Flooring_co_Other9": true +"Laundry_co_Inside2": true +"Heating_co_Electric": true +"Architecture_co_Ranch": true +"Disclosures_co_None10": true +"[email protected]": "None" +"[email protected]": "None" +"New_sp_Financing_co_VA5": true +"Sewer_co_Septic_sp_Tank": 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" +"[email protected]": "None" +"[email protected]": "None" +"Lockbox_sp_Type_co_None43": true +"[email protected]": "None" +"Basement_co_Basement_sp_YN": "N" +"[email protected]": "None" +"[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" +"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": "N" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"Cooling_co_HVAC_sp_SEER_sp_Rating": 16 +"[email protected]": "None" +"Kitchen_sp_Features_co_Dishwasher": true +"[email protected]": "None" +"New_sp_Financing_co_Conventional5": true +"[email protected]": "None" +"Parking_sp_Features_co_RV_sp_Gate": true +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"Landscaping_co_Irrigation_sp_Front": true +"Location_sp_Tax_sp_Legal_co_Taxes2": 3000.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" +"[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" +"Parking_sp_Features_co_RV_sp_Garage": 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" +"Existing_sp_1st_sp_Loan_co_Private10": true +"[email protected]": "None" +"Laundry_co_WshrDry_sp_HookUp_sp_Only": 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_Siding": true +"Const_sp__hyphen__sp_Finish_co_Stucco": true +"Contract_sp_Information_co_Ownership2": "Fee Simple" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"Master_sp_Bathroom_co_Double_sp_Sinks": true +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"Laundry_co_220_sp_V_sp_Dryer_sp_Hookup2": true +"[email protected]": "None" +"Parking_sp_Features_co_Tandem_sp_Garage": true +"Association_sp_Fee_sp_Incl_co_No_sp_Fees": true +"Association_sp_Fees_co_PAD_sp_Fee_sp_YN2": "N" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"Fireplace_sp_Features_co_No_sp_Fireplace": true +"Kitchen_sp_Features_co_Kitchen_sp_Island": true +"Kitchen_sp_Features_co_RangeOven_sp_Elec": true +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"Construction_co_Frame_sp__hyphen__sp_Wood": true +"Landscaping_co_Synthetic_sp_Grass_sp_Frnt": true +"[email protected]": "None" +"[email protected]": "None" +"General_sp_Property_sp_Description_co_Pool": "None" +"Kitchen_sp_Features_co_Electric_sp_Cooktop": true +"[email protected]": "None" +"[email protected]": "None" +"Showing_sp_Notification_sp_Methods_co_Text": true +"Construction_sp_Status_co_To_sp_Be_sp_Built": true +"[email protected]": "None" +"[email protected]": "None" +"Showing_sp_Notification_sp_Methods_co_Email": true +"[email protected]": "None" +"General_sp_Property_sp_Description_co_Horses": "Y" +"[email protected]": "None" +"Master_sp_Bathroom_co_Separate_sp_Shwr_sp_Tub": true +"[email protected]": "None" +"Parking_sp_Spaces_co_Slab_sp_Parking_sp_Spaces": 4.0 +"[email protected]": "None" +"[email protected]": "None" +"General_sp_Property_sp_Description_co_PriceSqFt": 497.11 +"Master_sp_Bathroom_co_Private_sp_Toilet_sp_Room": true +"Parking_sp_Spaces_co_Total_sp_Covered_sp_Spaces": 5.0 +"Separate_sp_DenOffice_co_Sep_sp_DenOffice_sp_YN": "Y" +"[email protected]": "None" +"Location_sp_Tax_sp_Legal_co_Tax_sp_Municipality3": "Pinal - COUNTY" +"Property_sp_Description_co_EastWest_sp_Exposure2": true +"Association_sp_Fees_co_Land_sp_Lease_sp_Fee_sp_YN": "N" +"Const_sp__hyphen__sp_Finish_co_Brick_sp_TrimVeneer": true +"Association_sp_Fees_co_Ttl_sp_Mthly_sp_Fee_sp_Equiv": 0.0 +"Kitchen_sp_Features_co_Built_hyphen_in_sp_Microwave": true +"Master_sp_Bathroom_co_Full_sp_Bth_sp_Master_sp_Bdrm": true +"General_sp_Property_sp_Description_co_Approx_sp_SQFT": 4325.0 +"General_sp_Property_sp_Description_co_High_sp_School": "San Tan Foothills High School" +"Road_sp_Responsibility_co_City_sp_Maintained_sp_Road": true +"General_sp_Property_sp_Description_co_Builder_sp_Name": "Sharp Luxury Homes" +"Location_sp_Tax_sp_Legal_co_Assessor_sp_Parcel_sp_Ltr3": "J" +"General_sp_Property_sp_Description_co_Dwelling_sp_Styles": "Detached" +"Showing_sp_Notification_sp_Methods_co_Showing_sp_Service": "Aligned Showings" +"General_sp_Property_sp_Description_co_Elementary_sp_School": "San Tan Heights Elementary" +"General_sp_Property_sp_Description_co_Jr_sp_High_sp_School": "San Tan Heights Elementary" +"General_sp_Property_sp_Description_co_Approx_sp_Lot_sp_SqFt": 144000.0 +"General_sp_Property_sp_Description_co_Approx_sp_Lot_sp_Acres2": 3.306 +"Property_sp_Description_co_Mountain_sp_View_lparen_s_rparen_2": true +"Assoc_sp_RulesInfo_co_Pets_sp_OK_sp__lparen_See_sp_Rmrks_rparen_": true +"Location_sp_Tax_sp_Legal_co_Assessor_squote_s_sp_Map_sp__pound_3": 20.0 +"General_sp_Property_sp_Description_co_High_sp_School_sp_District2": "Florence Unified School District" +"Location_sp_Tax_sp_Legal_co_Assessor_squote_s_sp_Parcel_sp__pound_3": 11.0 +"General_sp_Property_sp_Description_co_Elementary_sp_School_sp_District2": "Florence Unified School District" +"General_sp_Property_sp_Description_co__pound__sp_of_sp_Interior_sp_Levels": 1 +"Contract_sp_Information_co_Co_hyphen_Ownership_sp__lparen_Fractional_rparen__sp_Agreement_sp_YN": "No" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('20240430231629691152000000')" +"full_address": "0 N Marchant Trace, Queen Creek, Arizona 85144" +"provider_name": "ARMLS" +"short_address": "Queen Creek, Arizona 85144, US" +"location_extra_data": array:4 [ …4] +"Media": array:32 [ …32] } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6110 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "20250220064054854396000000" +"ListingId": "6823379" +"PropertyType": "Residential" +"PropertySubType": "Townhouse" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-05-27T23:20:36Z" +"RFModificationTimestamp": "2025-05-27T23:21:48.723942+00:00" +"ListPrice": 1349000.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 2178.0 +"LivingArea": 1860.0 +"BuildingAreaTotal": 0 +"City": "Flagstaff" +"PostalCode": "86005" +"UnparsedAddress": "2993 S Tourmaline Drive, 34, Flagstaff, Az 86005" +"Coordinates": array:2 [ …2] +"Latitude": 35.164563 +"Longitude": -111.641633 +"YearBuilt": 2023 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Todd Ninneman" +"ListOfficeName": "RE/MAX Fine Properties" +"ListAgentMlsId": "tn083" +"ListOfficeMlsId": "rmfp15" +"OriginatingSystemName": "ARMLS" +"PublicRemarks": "This MOVE IN READY, highly upgraded, extremely desirable luxury condo offers an open floor plan with no steps, a PRIVATE ENTRY GUEST CASITA just left of the front door, and a spacious walled-in wrap-around patio. Built in 2023, this home is packed with upscale features, including a Sub-Zero side-by-side refrigerator, Wolf oven/range, and built-in microwave. Enjoy Quartz countertops, a 7' kitchen island with bar seating, and a Tongue and Groove ceiling. The custom-built wet bar features a Sub-Zero wine refrigerator. Additional luxuries include glass-fronted cabinets, an extended stone fireplace wall with a linear gas fireplace, and automated window coverings throughout, including blackout shades in the primary bedroom." +"ApprovalStatus": true +"AssociationFee": "1395.0" +"AssociationFee2": "825.0" +"AssociationFee2Frequency": "Quarterly" +"AssociationFeeFrequency": "Quarterly" +"AssociationFeeIncludes": array:5 [ …5] +"AssociationName2": "Pine Canyon Village" +"AssociationPhone": "928-326-9700" +"AssociationPhone2": "928-779-4202" +"AssociationYN": true +"BathroomsTotalDecimal": 3.5 +"BedroomsPossible": 3 +"BuilderName": "Symmetry Homes" +"BuildingAreaSource": "Builder" +"CommonWalls": array:2 [ …2] +"CommunityFeatures": array:3 [ …3] +"ConstructionMaterials": array:2 [ …2] +"ContractStatusChangeDate": "2025-05-27" +"Cooling": array:3 [ …3] +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Coconino" +"CoveredSpaces": "2.0" +"CreationDate": "2025-02-20T06:50:20.955831+00:00" +"CrossStreet": "Clubhouse Cir" +"Directions": "I-17 North to Lake Mary Road exit. Go East to J.W. Powell Blvd. and turn North to Pine Canyon Entrance on East side of Rd." +"Disclosures": array:1 [ …1] +"DocumentsChangeTimestamp": "2025-03-31T05:44:34Z" +"ElementarySchool": "Lura Kinsey Elementary School" +"ElementarySchoolDistrict": "Flagstaff Unified District" +"ExteriorFeatures": array:2 [ …2] +"Fencing": array:1 [ …1] +"FireplaceFeatures": array:4 [ …4] +"FireplaceYN": true +"Flooring": array:4 [ …4] +"GarageSpaces": "2.0" +"Heating": array:1 [ …1] +"HeatingYN": true +"HighSchoolDistrict": "Flagstaff Unified District" +"InteriorFeatures": array:9 [ …9] +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"ListAgentAOR": "Scottsdale" +"ListAgentFax": "623-643-1001" +"ListAgentFirstName": "Todd" +"ListAgentHomePhone": "602-677-4653" +"ListAgentKey": "20071208002802243448000000" +"ListAgentLastName": "Ninneman" +"ListAgentPreferredPhone": "602-677-4653" +"ListOfficeEmail": "[email protected]" +"ListOfficeKey": "20230404160039479024000000" +"ListOfficePhone": "623-850-4755" +"ListingContractDate": "2025-02-19" +"ListingTerms": array:2 [ …2] +"LivingAreaSource": "Builder" +"LotFeatures": array:4 [ …4] +"LotSizeAcres": 0.05 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 2178.0 +"MiddleOrJuniorSchool": "Mount Elden Middle School" +"MlsStatus": "Active" +"Model": "Rees" +"OriginalEntryTimestamp": "2025-02-20T07:49:15Z" +"OriginatingSystemID": "M00000048" +"OriginatingSystemKey": "20250220064054854396000000" +"OtherStructures": array:1 [ …1] +"ParcelNumber": "105-21-034" +"ParkingFeatures": array:1 [ …1] +"PatioAndPorchFeatures": array:2 [ …2] +"PhotosChangeTimestamp": "2025-02-20T06:49:16Z" +"PhotosCount": 29 +"PoolFeatures": array:1 [ …1] +"Possession": array:1 [ …1] +"PostalCity": "Flagstaff" +"PriceChangeTimestamp": "2025-04-15T04:05:34Z" +"PropertyAttachedYN": true +"PropertyCondition": array:1 [ …1] +"Roof": array:1 [ …1] +"SecurityFeatures": array:3 [ …3] +"Sewer": array:1 [ …1] +"SourceSystemID": "M00000048" +"SourceSystemKey": "20250220064054854396000000" +"SourceSystemName": "Arizona Regional Multiple Listing Service (ARMLS)" +"SpaFeatures": array:1 [ …1] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "AZ" +"StatusChangeTimestamp": "2025-05-27T23:20:21Z" +"StoriesTotal": "1" +"StreetDirPrefix": "S" +"StreetName": "Tourmaline" +"StreetNumber": "2993" +"StreetNumberNumeric": "2993" +"StreetSuffix": "Drive" +"SubdivisionName": "Pine Canyon" +"TaxAnnualAmount": "759.0" +"TaxBookNumber": "105.00" +"TaxLot": "34" +"TaxMapNumber": "21.00" +"TaxYear": "2023" +"UnitNumber": "34" +"WaterSource": array:1 [ …1] +"WindowFeatures": array:2 [ …2] +"Spa_co_None14": true +"Cooling_co_Other": true +"Flooring_co_Tile": true +"Flooring_co_Wood": true +"Fencing_co_None11": true +"Flooring_co_Carpet": true +"Flooring_co_Other9": true +"Laundry_co_Inside2": true +"Disclosures_co_None10": true +"[email protected]": "None" +"[email protected]": "None" +"Windows_co_Dual_sp_Pane": true +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"Cooling_co_See_sp_Remarks": true +"[email protected]": "None" +"Heating_co_Natural_sp_Gas": true +"New_sp_Financing_co_Cash2": true +"[email protected]": "None" +"Utilities_co_City_sp_Gas3": true +"Windows_co_Wood_sp_Frames": true +"Basement_co_Basement_sp_YN": "N" +"[email protected]": "None" +"Lockbox_sp_Type_co_Other10": true +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"Roofing_co_Comp_sp_Shingle": true +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"Services_co_City_sp_Services": true +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[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" +"[email protected]": "None" +"[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 +"Utilities_co_City_sp_Electric2": 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" +"Features_co_Fire_sp_Sprinklers3": true +"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 +"Unit_sp_Style_co_Ground_sp_Level": 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 +"Landscaping_co_Irrigation_sp_Back": 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": 1395.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" +"Landscaping_co_Irrigation_sp_Front": true +"Location_sp_Tax_sp_Legal_co_Taxes2": 759.0 +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"Technology_co_Cable_sp_TV_sp_Avail": true +"Unit_sp_Style_co_Neighbor_sp_Above": true +"[email protected]": "None" +"Association_sp_Fees_co_HOA_sp_Name4": "Mountain Vista Condo" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"Features_co_No_sp_Interior_sp_Steps": true +"Kitchen_sp_Features_co_Refrigerator": true +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"Possession_co_Close_sp_of_sp_Escrow": true +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"Laundry_co_WshrDry_sp_HookUp_sp_Only": true +"[email protected]": "None" +"Sewer_co_Sewer_sp__hyphen__sp_Public": true +"[email protected]": "None" +"[email protected]": "None" +"Association_sp_Fees_co_HOA_sp_2_sp_YN": "Y" +"Association_sp_Fees_co_HOA_sp_3_sp_YN": "N" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"Const_sp__hyphen__sp_Finish_co_Siding": true +"Const_sp__hyphen__sp_Finish_co_Stone2": true +"Contract_sp_Information_co_Ownership2": "Fee Simple" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"Master_sp_Bathroom_co_Double_sp_Sinks": true +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"Dining_sp_Area_co_Dining_sp_in_sp_LRGR": true +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"Unit_sp_Style_co_One_sp_Common_sp_Wall": true +"[email protected]": "None" +"[email protected]": "None" +"Association_sp_Fees_co_HOA_sp_2_sp_Name": "Pine Canyon Village" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"Fireplace_sp_Features_co_1_sp_Fireplace": true +"Kitchen_sp_Features_co_RangeOven_sp_Gas": true +"[email protected]": "None" +"Technology_co_High_sp_Speed_sp_Internet": true +"Technology_co_Security_sp_Sys_sp_Leased": true +"Association_sp_Fees_co_HOA_sp_Telephone4": "928-326-9700" +"Association_sp_Fees_co_PAD_sp_Fee_sp_YN2": "N" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"Kitchen_sp_Features_co_Kitchen_sp_Island": true +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"Community_sp_Features_co_Guarded_sp_Entry": true +"Construction_co_Frame_sp__hyphen__sp_Wood": true +"Fireplace_sp_Features_co_Gas_sp_Fireplace": true +"[email protected]": "None" +"Plumbing_co_Gas_sp_Hot_sp_Water_sp_Heater": true +"[email protected]": "None" +"Dining_sp_Area_co_Eat_hyphen_in_sp_Kitchen": true +"General_sp_Property_sp_Description_co_Pool": "None" +"Kitchen_sp_Features_co_Granite_sp_Counters": true +"[email protected]": "None" +"[email protected]": "None" +"Showing_sp_Notification_sp_Methods_co_Text": true +"Unit_sp_Style_co_All_sp_on_sp_One_sp_Level": true +"Association_sp_Fees_co_Other_sp_Fees_sp_HOA": 0.0 +"Construction_sp_Status_co_To_sp_Be_sp_Built": true +"[email protected]": "None" +"General_sp_Property_sp_Description_co_Model": "Rees" +"[email protected]": "None" +"Showing_sp_Notification_sp_Methods_co_Email": true +"Association_sp_Fee_sp_Incl_co_Roof_sp_Repair": true +"Association_sp_Fees_co_HOA_sp_2_sp_Telephone": "928-779-4202" +"[email protected]": "None" +"General_sp_Property_sp_Description_co_Horses": "N" +"Location_sp_Tax_sp_Legal_co_Unit_sp__pound_3": "34" +"Technology_co_Pre_hyphen_Wire_sp_Sat_sp_Dish": true +"Technology_co_Pre_hyphen_Wire_sp_Srnd_sp_Snd": true +"Association_sp_Fee_sp_Incl_co_Street_sp_Maint": true +"[email protected]": "None" +"Master_sp_Bathroom_co_Separate_sp_Shwr_sp_Tub": true +"[email protected]": "None" +"Association_sp_Fees_co_HOA_sp_Transfer_sp_Fee2": 150.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": 0.0 +"[email protected]": "None" +"Assoc_sp_RulesInfo_co_Club_sp_Membership_sp_Opt": true +"Association_sp_Fees_co_HOA_sp_Paid_sp_Frequency": "Quarterly" +"Contact_sp_Info_co_List_sp_Agent_sp_Home_sp_Phn": "602-677-4653" +"[email protected]": "None" +"General_sp_Property_sp_Description_co_PriceSqFt": 725.27 +"Master_sp_Bathroom_co_Private_sp_Toilet_sp_Room": true +"Parking_sp_Features_co_Garage_sp_Door_sp_Opener": true +"Parking_sp_Spaces_co_Total_sp_Covered_sp_Spaces": 2.0 +"Separate_sp_DenOffice_co_Sep_sp_DenOffice_sp_YN": "N" +"[email protected]": "None" +"Additional_sp_Bedroom_co_2_sp_Master_sp_Bedrooms": true +"Association_sp_Fees_co_Disclosure_sp_Fees_sp_HOA": 0.0 +"Community_sp_Features_co_On_hyphen_Site_sp_Guard": true +"Location_sp_Tax_sp_Legal_co_Tax_sp_Municipality3": "Coconino - COUNTY" +"Association_sp_Fees_co_Land_sp_Lease_sp_Fee_sp_YN": "N" +"Association_sp_Fees_co_Rec_sp_Center_sp_Fee_sp_YN": "N" +"Association_sp_Fees_co_HOA_sp_2_sp_Transfer_sp_Fee": 375.0 +"Exterior_sp_Features_co_Separate_sp_Guest_sp_House": true +"Fireplace_sp_Features_co_Fireplace_sp_Living_sp_Rm": true +"Association_sp_Fees_co_Special_sp_Assessment_sp_HOA": "No" +"Association_sp_Fees_co_Ttl_sp_Mthly_sp_Fee_sp_Equiv": 740.0 +"Kitchen_sp_Features_co_Built_hyphen_in_sp_Microwave": true +"Master_sp_Bathroom_co_Full_sp_Bth_sp_Master_sp_Bdrm": true +"Showing_sp_Notification_sp_Methods_co_Phone_sp_Call": true +"Additional_sp_Bedroom_co_Separate_sp_Bedroom_sp_Exit": true +"Association_sp_Fee_sp_Incl_co_Front_sp_Yard_sp_Maint": true +"Association_sp_Fees_co_HOA_sp_Paid_sp_Frequency_sp_2": "Quarterly" +"Existing_sp_1st_sp_Loan_co_Treat_sp_as_sp_FreeClear4": true +"General_sp_Property_sp_Description_co_Approx_sp_SQFT": 1860.0 +"Association_sp_Fees_co_Disclosure_sp_Fees_sp_HOA_sp_2": 0.0 +"General_sp_Property_sp_Description_co_Builder_sp_Name": "Symmetry Homes" +"Association_sp_Fee_sp_Incl_co_Common_sp_Area_sp_Maint3": true +"Association_sp_Fees_co_Cap_sp_ImprovementImpact_sp_Fee": 0.0 +"Association_sp_Fees_co_Rec_sp_Center_sp_Fee_sp_2_sp_YN": "N" +"Community_sp_Features_co_Children_squote_s_sp_Playgrnd": true +"Association_sp_Fees_co_Special_sp_Assessment_sp_HOA_sp_2": "No" +"General_sp_Property_sp_Description_co_Dwelling_sp_Styles": "Stacked" +"General_sp_Property_sp_Description_co_Marketing_sp_Name3": "Pine Canyon" +"Showing_sp_Notification_sp_Methods_co_Showing_sp_Service": "Aligned Showings" +"Exterior_sp_Features_co_Covered_sp_Patio_lparen_s_rparen_": true +"Exterior_sp_Features_co_Private_sp_Street_lparen_s_rparen_": true +"General_sp_Property_sp_Description_co_Elementary_sp_School": "Lura Kinsey Elementary School" +"General_sp_Property_sp_Description_co_Jr_sp_High_sp_School": "Mount Elden Middle School" +"Association_sp_Fee_sp_Incl_co_Exterior_sp_Mnt_sp_of_sp_Unit": true +"Association_sp_Fees_co_Cap_sp_ImprovementImpact_sp_Fee_sp_2": 0.25 +"Dining_sp_Area_co_Other_sp__lparen_See_sp_Remarks_rparen_13": true +"General_sp_Property_sp_Description_co_Approx_sp_Lot_sp_SqFt": 2178.0 +"Association_sp_Fees_co_Prepaid_sp_Association_sp_Fees_sp_HOA": 0.0 +"General_sp_Property_sp_Description_co_Approx_sp_Lot_sp_Acres2": 0.05 +"General_sp_Property_sp_Description_co_Planned_sp_Comm_sp_Name": "Pine Canyon" +"Association_sp_Fees_co_HOA_sp_DisclosureAddendum_sp_Affirmation": "Yes" +"Master_sp_Bathroom_co_Other_sp__lparen_See_sp_Remarks_rparen_12": true +"Assoc_sp_RulesInfo_co_Pets_sp_OK_sp__lparen_See_sp_Rmrks_rparen_": true +"Location_sp_Tax_sp_Legal_co_Assessor_squote_s_sp_Map_sp__pound_3": 21.0 +"Assoc_sp_RulesInfo_co_Rental_sp_OK_sp__lparen_See_sp_Rmks_rparen_": true +"Association_sp_Fees_co_Prepaid_sp_Association_sp_Fees_sp_HOA_sp_2": 0.0 +"General_sp_Property_sp_Description_co_High_sp_School_sp_District2": "Flagstaff Unified District" +"Fireplace_sp_Features_co_Other_sp__lparen_See_sp_Remarks_rparen_14": true +"Association_sp_Fees_co_Cap_sp_ImprovementImpact_sp_Fee_sp__percent_": "$" +"Location_sp_Tax_sp_Legal_co_Assessor_squote_s_sp_Parcel_sp__pound_3": 34.0 +"Assoc_sp_RulesInfo_co_No_sp_Visible_sp_Truck_sp_Trailer_sp_RV_sp_Boat": true +"Additional_sp_Bedroom_co_Master_sp_Bedroom_sp_Walk_hyphen_in_sp_Closet": true +"General_sp_Property_sp_Description_co_Elementary_sp_School_sp_District2": "Flagstaff Unified District" +"Association_sp_Fees_co_Cap_sp_ImprovementImpact_sp_Fee_sp_2_sp__percent_": "%" +"General_sp_Property_sp_Description_co__pound__sp_of_sp_Interior_sp_Levels": 1 +"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('20250220064054854396000000')" +"provider_name": "ARMLS" +"Media": array:29 [ …29] } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6137 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "20250414201726848477000000" +"ListingId": "6851472" +"PropertyType": "Residential" +"PropertySubType": "Apartment" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-05-27T20:29:36Z" +"RFModificationTimestamp": "2025-05-27T20:37:15.694419+00:00" +"ListPrice": 1849900.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 2093.0 +"LivingArea": 2239.0 +"BuildingAreaTotal": 0 +"City": "Paradise Valley" +"PostalCode": "85253" +"UnparsedAddress": "6166 N Scottsdale Road, A1004, Paradise Valley, Az 85253" +"Coordinates": array:2 [ …2] +"Latitude": 33.527196 +"Longitude": -111.927406 +"YearBuilt": 2017 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Pushpit Tandon" +"ListOfficeName": "Real Broker" +"ListAgentMlsId": "tp283" +"ListOfficeMlsId": "realbr010" +"OriginatingSystemName": "ARMLS" +"PublicRemarks": """ This exceptional ground-floor home offers a perfect blend of luxury, space, and convenience. Featuring an open-concept great room that flows seamlessly to an expansive patio and private grass area, the home is designed with soaring 10-foot ceilings, rich dark hardwood flooring, elegant tile in the entry and bathrooms, and plush carpet in the bedrooms. The chef-inspired kitchen is equipped with quartz countertops, off-white wood cabinetry, an oversized island, and high-end Wolf appliances, including a Sub-Zero refrigerator and wine cooler. The floor plan includes a spacious master suite, an en suite guest bedroom for added privacy, and a versatile separate den.\r\n \r\n Located in a highly walkable neighborhood, you're just steps from two grocery stores, an array of restaurants, and boutique shops. The community offers resort-style amenities, including a gated entrance with resident services coordinators, a stylish club room, an outdoor fireplace surrounded by beautifully landscaped gardens, a heated pool and spa, a fully equipped fitness studio, and a convenient dog park. This home effortlessly combines upscale living with everyday practicality in one of the area's most desirable locations. """ +"ApprovalStatus": true +"ArchitecturalStyle": array:1 [ …1] +"AssociationFee": "1514.39" +"AssociationFeeFrequency": "Monthly" +"AssociationFeeIncludes": array:6 [ …6] +"AssociationPhone": "480-568-8720" +"AssociationYN": true +"AttributionContact": "623-385-9451" +"BathroomsTotalDecimal": 2.5 +"BedroomsPossible": 3 +"BuilderName": "Wespac" +"BuildingAreaSource": "Assessor" +"CoListAgentEmail": "[email protected]" +"CoListAgentFirstName": "David" +"CoListAgentFullName": "David Newman" +"CoListAgentKey": "20130327221147709903000000" +"CoListAgentLastName": "Newman" +"CoListAgentMlsId": "dn182" +"CoListAgentMobilePhone": "480-544-3144" +"CoListAgentPreferredPhone": "480-544-3144" +"CoListOfficeKey": "20220921194317652338000000" +"CoListOfficeMlsId": "realbr010" +"CoListOfficeName": "Real Broker" +"CommonWalls": array:3 [ …3] +"CommunityFeatures": array:8 [ …8] +"ConstructionMaterials": array:5 [ …5] +"ContractStatusChangeDate": "2025-04-14" +"Cooling": array:2 [ …2] +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Maricopa" +"CoveredSpaces": "2.0" +"CreationDate": "2025-04-14T22:49:41.162876+00:00" +"CrossStreet": "Scottsdale Rd and Lincoln Dr" +"Directions": "From Scottsdale and Lincoln go South on Scottsdale Rd to Rose Lane (stop light), turn right (West) to the property on the left. Call the front desk from the gate for access to guest parking." +"Disclosures": array:2 [ …2] +"DocumentsChangeTimestamp": "2025-04-15T21:06:34Z" +"ElementarySchool": "Kiva Elementary School" +"ElementarySchoolDistrict": "Scottsdale Unified District" +"ExteriorFeatures": array:1 [ …1] +"Fencing": array:2 [ …2] +"FireplaceFeatures": array:1 [ …1] +"FireplaceYN": true +"Flooring": array:3 [ …3] +"GarageSpaces": "2.0" +"Heating": array:1 [ …1] +"HeatingYN": true +"HighSchool": "Saguaro High School" +"HighSchoolDistrict": "Scottsdale Unified District" +"HomeWarrantyYN": true +"InteriorFeatures": array:10 [ …10] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"ListAgentAOR": "We SERV" +"ListAgentFirstName": "Pushpit" +"ListAgentKey": "20191010172745544064000000" +"ListAgentLastName": "Tandon" +"ListAgentPreferredPhone": "623-385-9451" +"ListOfficeEmail": "Membership@The Real Brokerage.com" +"ListOfficeKey": "20220921194317652338000000" +"ListOfficePhone": "480-442-9868" +"ListOfficeURL": "www.joinreal.com" +"ListingContractDate": "2025-04-14" +"ListingTerms": array:2 [ …2] +"LivingAreaSource": "Assessor" +"LotSizeAcres": 0.05 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 2093.0 +"MiddleOrJuniorSchool": "Mohave Middle School" +"MlsStatus": "Active" +"OriginalEntryTimestamp": "2025-04-14T23:28:29Z" +"OriginatingSystemID": "M00000048" +"OriginatingSystemKey": "20250414201726848477000000" +"ParcelNumber": "174-64-013" +"ParkingFeatures": array:4 [ …4] +"PatioAndPorchFeatures": array:1 [ …1] +"PhotosChangeTimestamp": "2025-04-14T21:28:30Z" +"PhotosCount": 30 +"PoolFeatures": array:1 [ …1] +"Possession": array:1 [ …1] +"PossibleUse": array:1 [ …1] +"PostalCity": "Paradise Valley" +"PostalCodePlus4": "5429" +"PriceChangeTimestamp": "2025-05-27T20:29:23Z" +"PropertyAttachedYN": true +"PropertyCondition": array:2 [ …2] +"PublicSurveyRange": "4E" +"PublicSurveySection": "10" +"Roof": array:2 [ …2] +"SecurityFeatures": array:1 [ …1] +"Sewer": array:1 [ …1] +"SourceSystemID": "M00000048" +"SourceSystemKey": "20250414201726848477000000" +"SourceSystemName": "Arizona Regional Multiple Listing Service (ARMLS)" +"SpaFeatures": array:1 [ …1] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "AZ" +"StatusChangeTimestamp": "2025-04-14T21:28:29Z" +"StoriesTotal": "4" +"StreetDirPrefix": "N" +"StreetName": "SCOTTSDALE" +"StreetNumber": "6166" +"StreetNumberNumeric": "6166" +"StreetSuffix": "Road" +"SubdivisionName": "ENCLAVE AT BORGATA CONDOMINIUM" +"TaxAnnualAmount": "6623.0" +"TaxBookNumber": "174.00" +"TaxLegalDescription": "LOT A1004 ENCLAVE AT BORGATA CONDOMINIUM MCR 122434" +"TaxLot": "A1004" +"TaxMapNumber": "64.00" +"TaxYear": "2024" +"Township": "2N" +"UnitNumber": "A1004" +"View": array:2 [ …2] +"WaterSource": array:1 [ …1] +"WindowFeatures": array:3 [ …3] +"Spa_co_None14": true +"Flooring_co_Tile": true +"Flooring_co_Wood": true +"Utilities_co_APS": true +"Fencing_co_Block2": true +"Roofing_co_Metal2": true +"Flooring_co_Carpet": true +"Laundry_co_Inside2": true +"Heating_co_Electric": true +"Landscaping_co_None46": true +"Legal_sp_Info_co_Range": "4E" +"[email protected]": "None" +"Construction_co_Other28": true +"[email protected]": "None" +"Utilities_co_SW_sp_Gas3": true +"Windows_co_Dual_sp_Pane": true +"Windows_co_Low_hyphen_E": true +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"Cooling_co_Central_sp_Air": true +"[email protected]": "None" +"Legal_sp_Info_co_Section2": "10" +"Lockbox_sp_Type_co_None43": true +"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" +"Roofing_co_Built_hyphen_Up": true +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"Technology_co_Smart_sp_Home": true +"[email protected]": "None" +"[email protected]": "None" +"Windows_co_Solar_sp_Screens": true +"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" +"Services_co_City_sp_Services": 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" +"Parking_sp_Features_co_Gated2": 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" +"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" +"Exterior_sp_Features_co_Balcony": true +"Kitchen_sp_Features_co_Disposal": true +"[email protected]": "None" +"Other_sp_Rooms_co_Great_sp_Room": true +"Pool_sp_Features_co_No_sp_Pool2": true +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"Contract_sp_Information_co_Type3": "Exclusive Right To Sell" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"Special_sp_Listing_sp_Cond_co_NA": true +"Association_sp_Fees_co_HOA_sp_YN2": "Y" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"Building_sp_Style_co_High_sp_Rise": true +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"Features_co_9_sp_Flat_sp_Ceilings": true +"[email protected]": "None" +"Kitchen_sp_Features_co_Dishwasher": true +"[email protected]": "None" +"New_sp_Financing_co_Conventional5": true +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"Association_sp_Fees_co_HOA_sp_Fee2": 1514.39 +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"Cooling_co_Programmable_sp_Thmstat": true +"[email protected]": "None" +"Dining_sp_Area_co_Breakfast_sp_Bar": true +"[email protected]": "None" +"[email protected]": "None" +"Location_sp_Tax_sp_Legal_co_Taxes2": 6623.0 +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"Technology_co_Cable_sp_TV_sp_Avail": true +"Unit_sp_Style_co_Neighbor_sp_Above": true +"Unit_sp_Style_co_Neighbor_sp_Below": true +"[email protected]": "None" +"Association_sp_Fees_co_HOA_sp_Name4": "Enclave at Borgata" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"Features_co_No_sp_Interior_sp_Steps": true +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"Possession_co_Close_sp_of_sp_Escrow": true +"[email protected]": "None" +"[email protected]": "None" +"Association_sp_Fee_sp_Incl_co_Sewer6": true +"Association_sp_Fee_sp_Incl_co_Water6": true +"[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": "Condominium" +"Disclosures_co_Agency_sp_Discl_sp_Req": true +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"Master_sp_Bathroom_co_Double_sp_Sinks": true +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"Const_sp__hyphen__sp_Finish_co_Painted": true +"Dining_sp_Area_co_Dining_sp_in_sp_LRGR": true +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"Pmt_sp_Rate_sp_Info_co_Down_sp_Payment": 0.0 +"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 +"Kitchen_sp_Features_co_RangeOven_sp_Gas": true +"[email protected]": "None" +"Technology_co_High_sp_Speed_sp_Internet": true +"Unit_sp_Style_co_Two_sp_Common_sp_Walls": true +"Association_sp_Fees_co_HOA_sp_Telephone4": "480-568-8720" +"Association_sp_Fees_co_PAD_sp_Fee_sp_YN2": "N" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"Kitchen_sp_Features_co_Kitchen_sp_Island": true +"[email protected]": "None" +"Add_squote_l_sp_Property_sp_Use_co_None15": true +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"Plumbing_co_Electric_sp_Hot_sp_Wtr_sp_Htr": true +"[email protected]": "None" +"Community_sp_Features_co_Community_sp_Pool": true +"Community_sp_Features_co_Community_sp_Spa2": true +"Construction_co_Frame_sp__hyphen__sp_Metal": true +"General_sp_Property_sp_Description_co_Pool": "Community Only" +"Kitchen_sp_Features_co_Granite_sp_Counters": true +"[email protected]": "None" +"[email protected]": "None" +"Parking_sp_Features_co_Assigned_sp_Parking": true +"Unit_sp_Style_co_All_sp_on_sp_One_sp_Level": true +"Water_sp_Source_co_Pvt_sp_Water_sp_Company": true +"Association_sp_Fees_co_Other_sp_Fees_sp_HOA": 300.0 +"Construction_sp_Status_co_To_sp_Be_sp_Built": true +"[email protected]": "None" +"[email protected]": "None" +"Assoc_sp_RulesInfo_co_ClubhouseRec_sp_Center": true +"[email protected]": "None" +"Community_sp_Features_co_Near_sp_Bus_sp_Stop": true +"Community_sp_Features_co_Workout_sp_Facility": true +"General_sp_Property_sp_Description_co_Horses": "N" +"Location_sp_Tax_sp_Legal_co_Unit_sp__pound_3": "A1004" +"Technology_co_Pre_hyphen_Wire_sp_Srnd_sp_Snd": true +"Association_sp_Fee_sp_Incl_co_Street_sp_Maint": true +"[email protected]": "None" +"Community_sp_Features_co_ClubhouseRec_sp_Room": true +"Master_sp_Bathroom_co_Separate_sp_Shwr_sp_Tub": true +"[email protected]": "None" +"Parking_sp_Features_co_Community_sp_Structure": true +"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": 0.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": 826.22 +"Master_sp_Bathroom_co_Private_sp_Toilet_sp_Room": true +"Parking_sp_Spaces_co_Total_sp_Covered_sp_Spaces": 2.0 +"Separate_sp_DenOffice_co_Sep_sp_DenOffice_sp_YN": "Y" +"[email protected]": "None" +"Association_sp_Fees_co_Disclosure_sp_Fees_sp_HOA": 400.0 +"Community_sp_Features_co_Community_sp_Spa_sp_Htd": true +"Location_sp_Tax_sp_Legal_co_Tax_sp_Municipality3": "Scottsdale" +"Parking_sp_Features_co_Separate_sp_Strge_sp_Area": true +"Association_sp_Fees_co_Land_sp_Lease_sp_Fee_sp_YN": "N" +"Association_sp_Fees_co_Rec_sp_Center_sp_Fee_sp_YN": "N" +"Community_sp_Features_co_Community_sp_Pool_sp_Htd": true +"Property_sp_Description_co_NorthSouth_sp_Exposure": true +"Const_sp__hyphen__sp_Finish_co_Brick_sp_TrimVeneer": true +"Association_sp_Fees_co_Other_sp_Fees_sp_Description": "Moe in/start up fee" +"Association_sp_Fees_co_Special_sp_Assessment_sp_HOA": "No" +"Association_sp_Fees_co_Ttl_sp_Mthly_sp_Fee_sp_Equiv": 1514.39 +"Kitchen_sp_Features_co_Built_hyphen_in_sp_Microwave": true +"Master_sp_Bathroom_co_Full_sp_Bth_sp_Master_sp_Bdrm": true +"Association_sp_Fee_sp_Incl_co_Garbage_sp_Collection2": true +"Existing_sp_1st_sp_Loan_co_Treat_sp_as_sp_FreeClear4": true +"General_sp_Property_sp_Description_co_Approx_sp_SQFT": 2239.0 +"General_sp_Property_sp_Description_co_High_sp_School": "Saguaro High School" +"Pmt_sp_Rate_sp_Info_co_Total_sp_Asum_sp_Mnth_sp_Pmts": 0.0 +"General_sp_Property_sp_Description_co_Builder_sp_Name": "Wespac" +"Association_sp_Fee_sp_Incl_co_Blanket_sp_Ins_sp_Policy": true +"Association_sp_Fee_sp_Incl_co_Common_sp_Area_sp_Maint3": true +"Association_sp_Fees_co_Cap_sp_ImprovementImpact_sp_Fee": 9086.34 +"Association_sp_Fees_co_Rec_sp_Center_sp_Fee_sp_2_sp_YN": "N" +"General_sp_Property_sp_Description_co_Dwelling_sp_Styles": "Stacked" +"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": "Kiva Elementary School" +"General_sp_Property_sp_Description_co_Jr_sp_High_sp_School": "Mohave Middle School" +"Association_sp_Fees_co_Cap_sp_ImprovementImpact_sp_Fee_sp_2": 0.0 +"General_sp_Property_sp_Description_co_Approx_sp_Lot_sp_SqFt": 2093.0 +"Association_sp_Fees_co_Prepaid_sp_Association_sp_Fees_sp_HOA": 3028.78 +"General_sp_Property_sp_Description_co_Approx_sp_Lot_sp_Acres2": 0.048 +"Property_sp_Description_co_Mountain_sp_View_lparen_s_rparen_2": true +"Association_sp_Fees_co_HOA_sp_DisclosureAddendum_sp_Affirmation": "Yes" +"Assoc_sp_RulesInfo_co_Pets_sp_OK_sp__lparen_See_sp_Rmrks_rparen_": true +"Location_sp_Tax_sp_Legal_co_Assessor_squote_s_sp_Map_sp__pound_3": 64.0 +"Assoc_sp_RulesInfo_co_Rental_sp_OK_sp__lparen_See_sp_Rmks_rparen_": true +"General_sp_Property_sp_Description_co_High_sp_School_sp_District2": "Scottsdale Unified District" +"Fireplace_sp_Features_co_Other_sp__lparen_See_sp_Remarks_rparen_14": true +"Property_sp_Description_co_City_sp_Light_sp_View_lparen_s_rparen_2": true +"Association_sp_Fees_co_Cap_sp_ImprovementImpact_sp_Fee_sp__percent_": "$" +"Location_sp_Tax_sp_Legal_co_Assessor_squote_s_sp_Parcel_sp__pound_3": 13.0 +"Additional_sp_Bedroom_co_Other_sp_Bedroom_sp_Walk_hyphen_in_sp_Closet": true +"Additional_sp_Bedroom_co_Master_sp_Bedroom_sp_Walk_hyphen_in_sp_Closet": true +"General_sp_Property_sp_Description_co_Elementary_sp_School_sp_District2": "Scottsdale Unified District" +"Association_sp_Fees_co_Cap_sp_ImprovementImpact_sp_Fee_sp_2_sp__percent_": "$" +"General_sp_Property_sp_Description_co__pound__sp_of_sp_Interior_sp_Levels": 1 +"Location_sp_Tax_sp_Legal_co_Legal_sp_Description_sp__lparen_Abbrev_rparen_3": "LOT A1004 ENCLAVE AT BORGATA CONDOMINIUM MCR 122434" +"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('20250414201726848477000000')" +"provider_name": "ARMLS" +"Media": array:30 [ …30] } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6134 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "20230831011327997527000000" +"ListingId": "6599088" +"PropertyType": "Residential" +"PropertySubType": "Apartment" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-05-27T18:32:45Z" +"RFModificationTimestamp": "2025-05-27T18:35:01.772643+00:00" +"ListPrice": 599000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 1496.0 +"LivingArea": 1512.0 +"BuildingAreaTotal": 0 +"City": "Phoenix" +"PostalCode": "85012" +"UnparsedAddress": "3131 N Central Avenue, 4012, Phoenix, Az 85012" +"Coordinates": array:2 [ …2] +"Latitude": 33.485124 +"Longitude": -112.072815 +"YearBuilt": 2024 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "James Cavanaugh" +"ListOfficeName": "The Agency" +"ListAgentMlsId": "jc820" +"ListOfficeMlsId": "agen01" +"OriginatingSystemName": "ARMLS" +"PublicRemarks": "*Construction completed* Introducing Edison Midtown Phase 2 with 60 new construction condominiums. This spacious two bedroom+ den condo is one of the larger two bedroom floor plans and offers ten ft. ceilings, an open floor plan, and large master bedroom with ensuite bathroom. Chefs kitchen offers expansive cabinetry, quartz countertops and stainless steel appliances including a gas range. Spacious balcony to capture the amazing views while outside as well. Edison Midtown features incredible amenities for that perfect Urbanite lifestyle. A beautiful pool and lap pool, 2000 sq. ft. fitness center and lounge, and gated parking garage." +"AccessibilityFeatures": array:1 [ …1] +"Appliances": array:1 [ …1] +"ApprovalStatus": true +"ArchitecturalStyle": array:1 [ …1] +"AssociationFee": "533.41" +"AssociationFeeFrequency": "Monthly" +"AssociationFeeIncludes": array:9 [ …9] +"AssociationPhone": "602-957-9191" +"AssociationYN": true +"BathroomsTotalDecimal": 2.0 +"BedroomsPossible": 3 +"BuilderName": "Tannin Developments" +"BuildingAreaSource": "Appraiser" +"CoListAgentEmail": "[email protected]" +"CoListAgentFax": "480-922-4603" +"CoListAgentFirstName": "Marilyn" +"CoListAgentFullName": "Marilyn Cavanaugh" +"CoListAgentKey": "20071208002357022551000000" +"CoListAgentLastName": "Cavanaugh" +"CoListAgentMlsId": "mp307" +"CoListAgentMobilePhone": "602-859-5999" +"CoListAgentPreferredPhone": "602-859-5999" +"CoListOfficeKey": "20170501225920615372000000" +"CoListOfficeMlsId": "agen01" +"CoListOfficeName": "The Agency" +"CommonWalls": array:1 [ …1] +"CommunityFeatures": array:7 [ …7] +"ConstructionMaterials": array:3 [ …3] +"ContractStatusChangeDate": "2023-08-30" +"Cooling": array:1 [ …1] +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Maricopa" +"CoveredSpaces": "2.0" +"CreationDate": "2025-02-01T20:03:24.926770+00:00" +"CrossStreet": "Central & Osborn" +"CurrentFinancing": array:1 [ …1] +"Directions": "From Central Ave go east on Monterey" +"Disclosures": array:1 [ …1] +"DocumentsChangeTimestamp": "2023-08-31T01:15:35Z" +"ElementarySchool": "Encanto School" +"ElementarySchoolDistrict": "Osborn Elementary District" +"ExteriorFeatures": array:1 [ …1] +"Fencing": array:1 [ …1] +"FireplaceFeatures": array:1 [ …1] +"Flooring": array:1 [ …1] +"GarageSpaces": "2.0" +"Heating": array:1 [ …1] +"HeatingYN": true +"HighSchool": "Central High School" +"HighSchoolDistrict": "Phoenix Union High School District" +"InteriorFeatures": array:3 [ …3] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"ListAgentAOR": "Phoenix REALTORS" +"ListAgentFax": "602-788-3900" +"ListAgentFirstName": "James" +"ListAgentHomePhone": "602-859-3287" +"ListAgentKey": "20090323164128823990000000" +"ListAgentLastName": "Cavanaugh" +"ListAgentPreferredPhone": "602-859-3287" +"ListAgentURL": "theagencyre.com" +"ListOfficeEmail": "[email protected]" +"ListOfficeKey": "20170501225920615372000000" +"ListOfficePhone": "480-878-3000" +"ListingContractDate": "2023-08-30" +"ListingTerms": array:2 [ …2] +"LivingAreaSource": "Appraiser" +"LotFeatures": array:3 [ …3] +"LotSizeAcres": 0.03 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 1496.0 +"MiddleOrJuniorSchool": "Clarendon School" +"MlsStatus": "Active" +"OriginalEntryTimestamp": "2023-08-31T03:14:27Z" +"OriginatingSystemID": "M00000048" +"OriginatingSystemKey": "20230831011327997527000000" +"ParcelNumber": "118-34-564" +"ParkingFeatures": array:3 [ …3] +"PhotosChangeTimestamp": "2024-06-14T21:47:14Z" +"PhotosCount": 45 +"PoolFeatures": array:1 [ …1] +"Possession": array:1 [ …1] +"PostalCity": "Phoenix" +"PostalCodePlus4": "2820" +"PriceChangeTimestamp": "2025-02-11T23:29:27Z" +"PropertyAttachedYN": true +"PropertyCondition": array:2 [ …2] +"PublicSurveyRange": "3E" +"PublicSurveySection": "29" +"Roof": array:2 [ …2] +"SecurityFeatures": array:1 [ …1] +"Sewer": array:1 [ …1] +"SourceSystemID": "M00000048" +"SourceSystemKey": "20230831011327997527000000" +"SourceSystemName": "Arizona Regional Multiple Listing Service (ARMLS)" +"SpaFeatures": array:1 [ …1] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "AZ" +"StatusChangeTimestamp": "2023-08-31T01:14:27Z" +"StoriesTotal": "7" +"StreetDirPrefix": "N" +"StreetName": "CENTRAL" +"StreetNumber": "3131" +"StreetNumberNumeric": "3131" +"StreetSuffix": "Avenue" +"SubdivisionName": "EDISON MIDTOWN CONDOMINIUMS" +"TaxAnnualAmount": "104.0" +"TaxBookNumber": "118.00" +"TaxLegalDescription": "LOT 4012 EDISON MIDTOWN CONDOMINIUMS MCR 125323" +"TaxLot": "4012" +"TaxMapNumber": "34.00" +"TaxYear": "2022" +"Township": "2N" +"UnitNumber": "4012" +"VideosChangeTimestamp": "1970-01-01T00:00:00Z" +"VideosCount": 1 +"View": array:2 [ …2] +"WaterSource": array:1 [ …1] +"WindowFeatures": array:2 [ …2] +"Spa_co_None14": true +"Utilities_co_APS": true +"Fencing_co_None11": true +"Flooring_co_Other9": true +"Laundry_co_Inside2": true +"Heating_co_Electric": true +"Roofing_co_Concrete4": true +"Legal_sp_Info_co_Range": "3E" +"[email protected]": "None" +"[email protected]": "None" +"Utilities_co_SW_sp_Gas3": true +"Windows_co_Dual_sp_Pane": true +"Windows_co_Low_hyphen_E": true +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"Cooling_co_Central_sp_Air": true +"[email protected]": "None" +"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" +"Roofing_co_Built_hyphen_Up": true +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"Architecture_co_Contemporary": true +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"Services_co_City_sp_Services": true +"Unit_sp_Style_co_End_sp_Unit": true +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"Landscaping_co_Desert_sp_Back": true +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"Parking_sp_Features_co_Gated2": 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" +"Exterior_sp_Features_co_Balcony": true +"Features_co_Fire_sp_Sprinklers3": true +"Kitchen_sp_Features_co_Disposal": true +"[email protected]": "None" +"Pool_sp_Features_co_No_sp_Pool2": true +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"Contract_sp_Information_co_Type3": "Exclusive Right To Sell" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"Special_sp_Listing_sp_Cond_co_NA": true +"Water_sp_Source_co_City_sp_Water": true +"Association_sp_Fees_co_HOA_sp_YN2": "Y" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"Features_co_9_sp_Flat_sp_Ceilings": true +"[email protected]": "None" +"Kitchen_sp_Features_co_Dishwasher": true +"[email protected]": "None" +"New_sp_Financing_co_Conventional5": true +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"Association_sp_Fee_sp_Incl_co_Gas6": true +"Association_sp_Fees_co_HOA_sp_Fee2": 533.41 +"[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": 104.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": "Edison Midtown" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"Features_co_No_sp_Interior_sp_Steps": true +"Kitchen_sp_Features_co_Refrigerator": true +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"Possession_co_Close_sp_of_sp_Escrow": true +"[email protected]": "None" +"[email protected]": "None" +"Association_sp_Fee_sp_Incl_co_Sewer6": true +"Association_sp_Fee_sp_Incl_co_Water6": true +"[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": "Condominium" +"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" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"Const_sp__hyphen__sp_Finish_co_Painted": true +"Dining_sp_Area_co_Dining_sp_in_sp_LRGR": true +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"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 +"[email protected]": "None" +"[email protected]": "None" +"Community_sp_Features_co_Community_sp_Pool": true +"Community_sp_Features_co_Community_sp_Spa2": true +"General_sp_Property_sp_Description_co_Pool": "Community Only" +"[email protected]": "None" +"[email protected]": "None" +"Parking_sp_Features_co_Assigned_sp_Parking": true +"Showing_sp_Notification_sp_Methods_co_Text": true +"Unit_sp_Style_co_All_sp_on_sp_One_sp_Level": true +"Association_sp_Fees_co_Other_sp_Fees_sp_HOA": 1600.23 +"Construction_sp_Status_co_To_sp_Be_sp_Built": true +"[email protected]": "None" +"[email protected]": "None" +"Showing_sp_Notification_sp_Methods_co_Email": true +"Association_sp_Fee_sp_Incl_co_Roof_sp_Repair": true +"[email protected]": "None" +"Community_sp_Features_co_Workout_sp_Facility": true +"General_sp_Property_sp_Description_co_Horses": "N" +"Location_sp_Tax_sp_Legal_co_Unit_sp__pound_3": "4012" +"[email protected]": "None" +"[email protected]": "None" +"Parking_sp_Features_co_Community_sp_Structure": true +"Association_sp_Fees_co_HOA_sp_Transfer_sp_Fee2": 100.0 +"Parking_sp_Spaces_co_Slab_sp_Parking_sp_Spaces": 0.0 +"[email protected]": "None" +"Association_sp_Fees_co_HOA_sp_Paid_sp_Frequency": "Monthly" +"Construction_sp_Status_co_Under_sp_Construction": true +"Contact_sp_Info_co_List_sp_Agent_sp_Home_sp_Phn": "602-859-3287" +"[email protected]": "None" +"General_sp_Property_sp_Description_co_PriceSqFt": 396.16 +"Parking_sp_Spaces_co_Total_sp_Covered_sp_Spaces": 2.0 +"Separate_sp_DenOffice_co_Sep_sp_DenOffice_sp_YN": "Y" +"[email protected]": "None" +"Association_sp_Fees_co_Disclosure_sp_Fees_sp_HOA": 400.0 +"Community_sp_Features_co_Community_sp_Spa_sp_Htd": true +"Contact_sp_Info_co_List_sp_Agent_sp_Cell_sp_Phn2": "602-859-5999" +"Location_sp_Tax_sp_Legal_co_Tax_sp_Municipality3": "Phoenix" +"Association_sp_Fee_sp_Incl_co_Roof_sp_Replacement": true +"Association_sp_Fees_co_HOA_sp_Management_sp_Phone": "602-957-9191" +"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 +"Accessibility_sp_Feat_co_Zero_hyphen_Grade_sp_Entry": true +"Association_sp_Fees_co_HOA_sp_Management_sp_Company": "AAM" +"Association_sp_Fees_co_Other_sp_Fees_sp_Description": "Working capital" +"Association_sp_Fees_co_Special_sp_Assessment_sp_HOA": "No" +"Association_sp_Fees_co_Ttl_sp_Mthly_sp_Fee_sp_Equiv": 533.41 +"Contact_sp_Info_co_List_sp_Agent_sp_Hme_sp_Phn_sp_2": "602-859-5999" +"Kitchen_sp_Features_co_Built_hyphen_in_sp_Microwave": true +"Master_sp_Bathroom_co_Full_sp_Bth_sp_Master_sp_Bdrm": true +"Showing_sp_Notification_sp_Methods_co_Phone_sp_Call": true +"Association_sp_Fee_sp_Incl_co_Garbage_sp_Collection2": true +"General_sp_Property_sp_Description_co_Approx_sp_SQFT": 1512.0 +"General_sp_Property_sp_Description_co_High_sp_School": "Central High School" +"Pmt_sp_Rate_sp_Info_co_Total_sp_Asum_sp_Mnth_sp_Pmts": 0.0 +"General_sp_Property_sp_Description_co_Builder_sp_Name": "Tannin Developments" +"Association_sp_Fee_sp_Incl_co_Blanket_sp_Ins_sp_Policy": true +"Association_sp_Fee_sp_Incl_co_Common_sp_Area_sp_Maint3": true +"Association_sp_Fees_co_Cap_sp_ImprovementImpact_sp_Fee": 1600.23 +"Association_sp_Fees_co_Rec_sp_Center_sp_Fee_sp_2_sp_YN": "N" +"Community_sp_Features_co_Near_sp_Light_sp_Rail_sp_Stop": true +"General_sp_Property_sp_Description_co_Dwelling_sp_Styles": "Stacked" +"General_sp_Property_sp_Description_co_Marketing_sp_Name3": "Edison Midtown Phase II" +"Showing_sp_Notification_sp_Methods_co_Showing_sp_Service": "Aligned Showings" +"General_sp_Property_sp_Description_co_Elementary_sp_School": "Encanto School" +"General_sp_Property_sp_Description_co_Jr_sp_High_sp_School": "Clarendon School" +"Association_sp_Fee_sp_Incl_co_Exterior_sp_Mnt_sp_of_sp_Unit": true +"General_sp_Property_sp_Description_co_Approx_sp_Lot_sp_SqFt": 1496.0 +"Association_sp_Fees_co_Prepaid_sp_Association_sp_Fees_sp_HOA": 533.41 +"General_sp_Property_sp_Description_co_Approx_sp_Lot_sp_Acres2": 0.034 +"Property_sp_Description_co_Mountain_sp_View_lparen_s_rparen_2": true +"Association_sp_Fees_co_HOA_sp_DisclosureAddendum_sp_Affirmation": "No" +"Assoc_sp_RulesInfo_co_Pets_sp_OK_sp__lparen_See_sp_Rmrks_rparen_": true +"Location_sp_Tax_sp_Legal_co_Assessor_squote_s_sp_Map_sp__pound_3": 34.0 +"Assoc_sp_RulesInfo_co_Rental_sp_OK_sp__lparen_See_sp_Rmks_rparen_": true +"General_sp_Property_sp_Description_co_High_sp_School_sp_District2": "Phoenix Union High School District" +"Property_sp_Description_co_City_sp_Light_sp_View_lparen_s_rparen_2": 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": 564.0 +"General_sp_Property_sp_Description_co_Elementary_sp_School_sp_District2": "Osborn Elementary 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 4012 EDISON MIDTOWN CONDOMINIUMS MCR 125323" +"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('20230831011327997527000000')" +"provider_name": "ARMLS" +"Media": array:45 [ …45] } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6109 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "20250511033722845820000000" +"ListingId": "6867952" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-05-27T16:56:44Z" +"RFModificationTimestamp": "2025-05-27T16:59:27.018861+00:00" +"ListPrice": 395000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 6890.0 +"LivingArea": 1915.0 +"BuildingAreaTotal": 0 +"City": "Buckeye" +"PostalCode": "85326" +"UnparsedAddress": "25602 W Coles Road, Buckeye, Arizona 85326" +"Coordinates": array:2 [ …2] +"Latitude": 33.369926 +"Longitude": -112.601444 +"YearBuilt": 2018 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Joseph J. Frontauria" +"ListOfficeName": "Citiea" +"ListAgentMlsId": "jf432" +"ListOfficeMlsId": "citi001" +"OriginatingSystemName": "ARMLS" +"PublicRemarks": "Beautiful 4-bedroom 2 bath home plus a den/office. Stainless Steel appliances - smooth top range - microwave - dishwasher - refrigerator - white washer/dryer - blinds on all windows garage door opener. - Espresso Cabinets - Pest Control system - upgraded carpet - Garage Coach lights - 9' high ceilings - nickel hardware - programmable thermostat - front yard landscaping on a timer/drip system." +"Appliances": array:1 [ …1] +"ApprovalStatus": true +"ArchitecturalStyle": array:1 [ …1] +"AssociationFee": "235.0" +"AssociationFeeFrequency": "Monthly" +"AssociationFeeIncludes": array:1 [ …1] +"AssociationPhone": "602-957-9191" +"AssociationYN": true +"BathroomsTotalDecimal": 2.0 +"BedroomsPossible": 5 +"BuilderName": "DR Horton" +"BuildingAreaSource": "Assessor" +"CommunityFeatures": array:1 [ …1] +"ConstructionMaterials": array:2 [ …2] +"ContractStatusChangeDate": "2025-05-19" +"Cooling": array:1 [ …1] +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Maricopa" +"CoveredSpaces": "2.0" +"CreationDate": "2025-05-19T14:39:22.149149+00:00" +"CrossStreet": "W. of Miller and S. of MC 85/aka Monroe" +"CurrentFinancing": array:2 [ …2] +"Directions": "I 10 to Miller Exit 114 go south appx 4 miles to MC85/Monroe turn west to 255th ave. then south. OR I-10 to exit 112 MC 85 then turn east on MC 85 appx 1 mile to 257th ave." +"Disclosures": array:1 [ …1] +"DocumentsChangeTimestamp": "2025-05-27T16:56:31Z" +"ElementarySchool": "Buckeye Elementary School" +"ElementarySchoolDistrict": "Buckeye Elementary District" +"Fencing": array:1 [ …1] +"FireplaceFeatures": array:1 [ …1] +"GarageSpaces": "2.0" +"Heating": array:1 [ …1] +"HeatingYN": true +"HighSchool": "Buckeye Union High School" +"HighSchoolDistrict": "Buckeye Union High School District" +"InteriorFeatures": array:3 [ …3] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ …1] +"ListAgentAOR": "Scottsdale" +"ListAgentFax": "866-703-2194" +"ListAgentFirstName": "Joseph" +"ListAgentKey": "20080508021747757439000000" +"ListAgentLastName": "Frontauria" +"ListAgentPreferredPhone": "602-672-5535" +"ListOfficeEmail": "[email protected]" +"ListOfficeKey": "20240301232157382213000000" +"ListOfficePhone": "480-870-3119" +"ListingContractDate": "2025-05-17" +"ListingTerms": array:4 [ …4] +"LivingAreaSource": "Assessor" +"LotFeatures": array:3 [ …3] +"LotSizeAcres": 0.16 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 6890.0 +"MiddleOrJuniorSchool": "Buckeye Elementary School" +"MlsStatus": "Active" +"Model": "Cardinal A" +"OnMarketDate": "2025-05-19" +"OpenParkingSpaces": "2.0" +"OriginalEntryTimestamp": "2025-05-17T20:59:50Z" +"OriginatingSystemID": "M00000048" +"OriginatingSystemKey": "20250511033722845820000000" +"ParcelNumber": "400-34-699" +"ParkingFeatures": array:1 [ …1] +"PhotosChangeTimestamp": "2025-05-17T19:14:37Z" +"PhotosCount": 14 +"PoolFeatures": array:1 [ …1] +"Possession": array:1 [ …1] +"PossibleUse": array:1 [ …1] +"PostalCity": "Buckeye" +"PostalCodePlus4": "5164" +"PropertyCondition": array:2 [ …2] +"PublicSurveyRange": "3W" +"PublicSurveySection": "6" +"Roof": array:1 [ …1] +"Sewer": array:1 [ …1] +"SourceSystemID": "M00000048" +"SourceSystemKey": "20250511033722845820000000" +"SourceSystemName": "Arizona Regional Multiple Listing Service (ARMLS)" +"SpaFeatures": array:1 [ …1] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "AZ" +"StatusChangeTimestamp": "2025-05-19T14:37:51Z" +"StoriesTotal": "1" +"StreetDirPrefix": "W" +"StreetName": "COLES" +"StreetNumber": "25602" +"StreetNumberNumeric": "25602" +"StreetSuffix": "Road" +"SubdivisionName": "TERRAVISTA PHASE 1 VARIOUS LOTS AND TRACTS REPLAT" +"TaxAnnualAmount": "1773.0" +"TaxBookNumber": "400.00" +"TaxLegalDescription": "LOT 50 TERRAVISTA PHASE 1 VARIOUS LOTS AND TRACTS REPLAT MCR 136512" +"TaxLot": "50" +"TaxMapNumber": "34.00" +"TaxYear": "2024" +"Township": "1S" +"WaterSource": array:1 [ …1] +"WindowFeatures": array:3 [ …3] +"Spa_co_None14": true +"Roofing_co_Tile2": true +"Utilities_co_APS": true +"Fencing_co_Block2": true +"Laundry_co_Inside2": true +"Heating_co_Electric": true +"Legal_sp_Info_co_Range": "3W" +"[email protected]": "None" +"[email protected]": "None" +"New_sp_Financing_co_VA5": true +"Windows_co_Dual_sp_Pane": true +"Windows_co_Low_hyphen_E": 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" +"Legal_sp_Info_co_Section2": "6" +"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" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"Services_co_City_sp_Services": true +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"Existing_sp_1st_sp_Loan_co_VA": true +"Kitchen_sp_Features_co_Pantry": true +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"Landscaping_co_Desert_sp_Front": true +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"Kitchen_sp_Features_co_Disposal": true +"[email protected]": "None" +"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" +"Cooling_co_HVAC_sp_SEER_sp_Rating": 14 +"Features_co_9_sp_Flat_sp_Ceilings": true +"[email protected]": "None" +"Kitchen_sp_Features_co_Dishwasher": true +"[email protected]": "None" +"New_sp_Financing_co_Conventional5": true +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"Association_sp_Fees_co_HOA_sp_Fee2": 235.0 +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"Landscaping_co_GravelStone_sp_Back": true +"Location_sp_Tax_sp_Legal_co_Taxes2": 1773.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": "Terravista Buckeye" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"Kitchen_sp_Features_co_Refrigerator": true +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"Possession_co_Close_sp_of_sp_Escrow": true +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"Sewer_co_Sewer_sp__hyphen__sp_Public": true +"[email protected]": "None" +"Assoc_sp_RulesInfo_co_Prof_sp_Managed": true +"[email protected]": "None" +"Association_sp_Fees_co_HOA_sp_2_sp_YN": "N" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"Const_sp__hyphen__sp_Finish_co_Stucco": true +"Contract_sp_Information_co_Ownership2": "Fee Simple" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"Architecture_co_TerritorialSanta_sp_Fe": 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_LRGR": true +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"Pmt_sp_Rate_sp_Info_co_Down_sp_Payment": 1000.0 +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"Disclosures_co_Seller_sp_Discl_sp_Avail": true +"[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 +"Kitchen_sp_Features_co_Kitchen_sp_Island": true +"Kitchen_sp_Features_co_RangeOven_sp_Elec": true +"[email protected]": "None" +"Add_squote_l_sp_Property_sp_Use_co_None15": true +"[email protected]": "None" +"[email protected]": "None" +"Construction_co_Frame_sp__hyphen__sp_Wood": true +"[email protected]": "None" +"[email protected]": "None" +"General_sp_Property_sp_Description_co_Pool": "None" +"Kitchen_sp_Features_co_Electric_sp_Cooktop": 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": 50.0 +"Construction_sp_Status_co_To_sp_Be_sp_Built": true +"[email protected]": "None" +"General_sp_Property_sp_Description_co_Model": "Cardinal A" +"[email protected]": "None" +"[email protected]": "None" +"General_sp_Property_sp_Description_co_Horses": "N" +"Landscaping_co_Auto_sp_Timer_sp_H2O_sp_Front": true +"Assoc_sp_RulesInfo_co_VA_sp_Approved_sp_Prjct": true +"[email protected]": "None" +"GreenEnergy_sp_Cert_co_Energy_sp_Star_sp_Cert": true +"[email protected]": "None" +"Assoc_sp_RulesInfo_co_FHA_sp_Approved_sp_Prjct": true +"Association_sp_Fees_co_HOA_sp_Transfer_sp_Fee2": 0.0 +"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": 206.27 +"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": 400.0 +"Location_sp_Tax_sp_Legal_co_Tax_sp_Municipality3": "Buckeye" +"Association_sp_Fees_co_Com_sp_Facilities_sp_Distr": "N" +"Association_sp_Fees_co_HOA_sp_Management_sp_Phone": "602-957-9191" +"Association_sp_Fees_co_Land_sp_Lease_sp_Fee_sp_YN": "N" +"Association_sp_Fees_co_Rec_sp_Center_sp_Fee_sp_YN": "N" +"Windows_co_ENERGY_sp_STAR_sp_Qualified_sp_Windows": true +"Association_sp_Fees_co_HOA_sp_Management_sp_Company": "AAM" +"Association_sp_Fees_co_Other_sp_Fees_sp_Description": "hoa" +"Association_sp_Fees_co_Special_sp_Assessment_sp_HOA": "No" +"Association_sp_Fees_co_Ttl_sp_Mthly_sp_Fee_sp_Equiv": 235.0 +"Kitchen_sp_Features_co_Built_hyphen_in_sp_Microwave": true +"General_sp_Property_sp_Description_co_Approx_sp_SQFT": 1915.0 +"General_sp_Property_sp_Description_co_High_sp_School": "Buckeye Union High School" +"Pmt_sp_Rate_sp_Info_co_Total_sp_Asum_sp_Mnth_sp_Pmts": 0.0 +"General_sp_Property_sp_Description_co_Builder_sp_Name": "DR Horton" +"Association_sp_Fee_sp_Incl_co_Common_sp_Area_sp_Maint3": true +"Association_sp_Fees_co_Cap_sp_ImprovementImpact_sp_Fee": 156.67 +"Association_sp_Fees_co_Rec_sp_Center_sp_Fee_sp_2_sp_YN": "N" +"Community_sp_Features_co_Children_squote_s_sp_Playgrnd": true +"General_sp_Property_sp_Description_co_Dwelling_sp_Styles": "Detached" +"General_sp_Property_sp_Description_co_Marketing_sp_Name3": "Terravista" +"Showing_sp_Notification_sp_Methods_co_Showing_sp_Service": "Aligned Showings" +"General_sp_Property_sp_Description_co_Elementary_sp_School": "Buckeye Elementary School" +"General_sp_Property_sp_Description_co_Jr_sp_High_sp_School": "Buckeye Elementary School" +"Association_sp_Fees_co_Cap_sp_ImprovementImpact_sp_Fee_sp_2": 0.0 +"General_sp_Property_sp_Description_co_Approx_sp_Lot_sp_SqFt": 6890.0 +"Association_sp_Fees_co_Prepaid_sp_Association_sp_Fees_sp_HOA": 235.0 +"General_sp_Property_sp_Description_co_Approx_sp_Lot_sp_Acres2": 0.158 +"General_sp_Property_sp_Description_co_Planned_sp_Comm_sp_Name": "Terravista" +"Association_sp_Fees_co_HOA_sp_DisclosureAddendum_sp_Affirmation": "No" +"Assoc_sp_RulesInfo_co_Pets_sp_OK_sp__lparen_See_sp_Rmrks_rparen_": true +"Location_sp_Tax_sp_Legal_co_Assessor_squote_s_sp_Map_sp__pound_3": 34.0 +"General_sp_Property_sp_Description_co_High_sp_School_sp_District2": "Buckeye Union High School District" +"Kitchen_sp_Features_co_Engy_sp_Star_sp__lparen_See_sp_Rmks_rparen_": true +"Association_sp_Fees_co_Cap_sp_ImprovementImpact_sp_Fee_sp__percent_": "$" +"Location_sp_Tax_sp_Legal_co_Assessor_squote_s_sp_Parcel_sp__pound_3": 699.0 +"Existing_sp_1st_sp_Ln_sp_Trms_co_Assume_sp__hyphen__sp_No_sp_Qualify": true +"General_sp_Property_sp_Description_co_Elementary_sp_School_sp_District2": "Buckeye Elementary District" +"Association_sp_Fees_co_Cap_sp_ImprovementImpact_sp_Fee_sp_2_sp__percent_": "$" +"General_sp_Property_sp_Description_co__pound__sp_of_sp_Interior_sp_Levels": 1 +"Location_sp_Tax_sp_Legal_co_Legal_sp_Description_sp__lparen_Abbrev_rparen_3": "LOT 50 TERRAVISTA PHASE 1 VARIOUS LOTS AND TRACTS REPLAT MCR 136512" +"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('20250511033722845820000000')" +"provider_name": "ARMLS" +"Media": array:14 [ …14] } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6108 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "20250322001722190992000000" +"ListingId": "6839902" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-05-27T13:31:26Z" +"RFModificationTimestamp": "2025-05-27T13:37:24.060413+00:00" +"ListPrice": 9999999.0 +"BathroomsTotalInteger": 7.0 +"BathroomsHalf": 0 +"BedroomsTotal": 5.0 +"LotSizeArea": 48838.0 +"LivingArea": 9000.0 +"BuildingAreaTotal": 0 +"City": "Mesa" +"PostalCode": "85207" +"UnparsedAddress": "7646 E Hidden Canyon Street, Mesa, Az 85207" +"Coordinates": array:2 [ …2] +"Latitude": 33.494812 +"Longitude": -111.665825 +"YearBuilt": 2025 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Desirae Wattel" +"ListOfficeName": "Realty ONE Group" +"ListAgentMlsId": "dw657" +"ListOfficeMlsId": "reog01" +"OriginatingSystemName": "ARMLS" +"PublicRemarks": """ Exquisite Modernterranean Estate - A True Masterpiece\r\n \r\n Nestled in the exclusive gated community of Hidden Canyon at Las Sendas, this estate offers unmatched privacy and breathtaking Tonto Forest views. Designed for seamless indoor-outdoor living, the home features soaring glass walls, marble accents, and a striking two-way fireplace.\r\n \r\n With five en suite bedrooms, seven baths, four kitchens, and two laundry rooms, every detail is crafted for luxury. The resort-style backyard boasts a negative-edge pool, spa, and rooftop deck with panoramic mountain views. An air-conditioned garage accommodates 8 vehicles.\r\n \r\n A stunning blend of elegance and innovation, this home redefines modern living. """ +"Appliances": array:2 [ …2] +"ApprovalStatus": true +"ArchitecturalStyle": array:1 [ …1] +"AssociationFee": "442.2" +"AssociationFeeFrequency": "Quarterly" +"AssociationFeeIncludes": array:2 [ …2] +"AssociationPhone": "480-357-8780" +"AssociationYN": true +"BathroomsTotalDecimal": 7.0 +"BedroomsPossible": 6 +"BuilderName": "Micela Properties" +"BuildingAreaSource": "Builder" +"CommunityFeatures": array:9 [ …9] +"ConstructionMaterials": array:3 [ …3] +"ContractStatusChangeDate": "2025-03-23" +"Cooling": array:3 [ …3] +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Maricopa" +"CoveredSpaces": "10.0" +"CreationDate": "2025-03-23T16:04:32.391711+00:00" +"CrossStreet": "Power & Thomas Rd" +"Directions": "(E) on Thomas (Eagle Crest). (L) on Las Sendas Mountain. (L) on Terra Mesa. Through gate. (L) on Copper Canyon. (R) on Deserts Gate. (L) on Hidden Canyon. Home Site on (R)." +"Disclosures": array:1 [ …1] +"DocumentsChangeTimestamp": "2025-03-23T16:00:01Z" +"ElementarySchool": "Las Sendas Elementary School" +"ElementarySchoolDistrict": "Mesa Unified District" +"ExteriorFeatures": array:2 [ …2] +"Fencing": array:1 [ …1] +"FireplaceFeatures": array:3 [ …3] +"FireplaceYN": true +"Flooring": array:2 [ …2] +"GarageSpaces": "10.0" +"GreenEnergyEfficient": array:1 [ …1] +"GreenWaterConservation": array:1 [ …1] +"Heating": array:1 [ …1] +"HeatingYN": true +"HighSchool": "Red Mountain High School" +"HighSchoolDistrict": "Mesa Unified District" +"InteriorFeatures": array:10 [ …10] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAgentAOR": "Scottsdale" +"ListAgentFirstName": "Desirae" +"ListAgentKey": "20250224222509237884000000" +"ListAgentLastName": "Wattel" +"ListAgentPreferredPhone": "480-318-2349" +"ListOfficeEmail": "[email protected]" +"ListOfficeKey": "20071206231750891862000000" +"ListOfficePhone": "480-315-1240" +"ListingContractDate": "2025-03-21" +"ListingTerms": array:2 [ …2] +"LivingAreaSource": "Builder" +"LotFeatures": array:7 [ …7] +"LotSizeAcres": 1.12 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 48838.0 +"MiddleOrJuniorSchool": "Fremont Junior High School" +"MlsStatus": "Active" +"OpenParkingSpaces": "8.0" +"OriginalEntryTimestamp": "2025-03-23T18:00:00Z" +"OriginatingSystemID": "M00000048" +"OriginatingSystemKey": "20250322001722190992000000" +"ParcelNumber": "219-18-824-1" +"ParkingFeatures": array:6 [ …6] +"PatioAndPorchFeatures": array:1 [ …1] +"PhotosChangeTimestamp": "2025-05-27T13:31:09Z" +"PhotosCount": 37 +"PoolFeatures": array:3 [ …3] +"PoolPrivateYN": true +"Possession": array:1 [ …1] +"PossibleUse": array:1 [ …1] +"PostalCity": "Mesa" +"PostalCodePlus4": "7248" +"PropertyCondition": array:2 [ …2] +"PublicSurveyRange": "7E" +"PublicSurveySection": "29" +"RoadResponsibility": array:1 [ …1] +"Roof": array:1 [ …1] +"SecurityFeatures": array:1 [ …1] +"Sewer": array:1 [ …1] +"SourceSystemID": "M00000048" +"SourceSystemKey": "20250322001722190992000000" +"SourceSystemName": "Arizona Regional Multiple Listing Service (ARMLS)" +"SpaFeatures": array:2 [ …2] +"SpecialListingConditions": array:1 [ …1] +"StateOrProvince": "AZ" +"StatusChangeTimestamp": "2025-03-23T16:00:00Z" +"StoriesTotal": "1" +"StreetDirPrefix": "E" +"StreetName": "HIDDEN CANYON" +"StreetNumber": "7646" +"StreetNumberNumeric": "7646" +"StreetSuffix": "Street" +"SubdivisionName": "HIDDEN CANYON AT LAS SENDAS" +"TaxAnnualAmount": "3253.0" +"TaxBookNumber": "219.00" +"TaxLegalDescription": "LOT 18 HIDDEN CANYON AT LAS SENDAS MCR 059333" +"TaxLot": "18" +"TaxMapNumber": "18.00" +"TaxParcelLetter": "1" +"TaxYear": "2024" +"Township": "2N" +"VideosChangeTimestamp": "1970-01-01T00:00:00Z" +"VideosCount": 1 +"View": array:1 [ …1] +"WaterSource": array:1 [ …1] +"WindowFeatures": array:2 [ …2] +"Spa_co_Heated": true +"Spa_co_Private": true +"Flooring_co_Wood": true +"Roofing_co_Tile2": true +"Utilities_co_SRP": true +"Flooring_co_Stone": true +"Laundry_co_Inside2": true +"Legal_sp_Info_co_Range": "7E" +"[email protected]": "None" +"[email protected]": "None" +"Windows_co_Dual_sp_Pane": true +"Windows_co_Low_hyphen_E": 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" +"Utilities_co_City_sp_Gas3": true +"Basement_co_Basement_sp_YN": "N" +"Fencing_co_Wrought_sp_Iron": 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" +"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 +"Services_co_City_sp_Services": true +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"Community_sp_Features_co_Golf": true +"[email protected]": "None" +"Features_co_Water_sp_Purifier": true +"Laundry_co_Dryer_sp_Included2": true +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"Possession_co_By_sp_Agreement": 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" +"Community_sp_Features_co_Gated": true +"Laundry_co_Washer_sp_Included2": true +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"[email protected]": "None" +"Features_co_Fire_sp_Sprinklers3": true +"Kitchen_sp_Features_co_Disposal": true +"[email protected]": "None" +"[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" +"Fireplace_sp_Features_co_Firepit": true +"[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 …222 } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6107 …420} 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6106 …429} 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6105 …397} 9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6104 …464} ] +success: true +page_size: 10 +page_count: 26 +count: 257 +after_key: "" } ] "RF Cache Key: 0582edc7b763a21ea616f035b4a41e06e81c813e12b729a930ee70baa6c82830" => array:1 [ "RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#6012 +items: array:5 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6103 …399} 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6132 …417} 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6044 …428} 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6046 …465} 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#6048 …437} ] +success: true +page_size: 5 +page_count: 598 +count: 2986 +after_key: "" } ] ]