Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#19166 +post_id: "124498" +post_author: 1 +"ListingKey": "20260422181846537149000000" +"ListingId": "7017658" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-04-29T19:50:31Z" +"RFModificationTimestamp": "2026-04-29T20:01:01Z" +"ListPrice": 599900.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 5667.0 +"LivingArea": 2694.0 +"BuildingAreaTotal": 0 +"City": "Phoenix" +"PostalCode": "85048" +"UnparsedAddress": "315 E Glenhaven Drive, Phoenix, Arizona 85048" +"Coordinates": array:2 [ 0 => -112.068646 1 => 33.29401 ] +"Latitude": 33.29401 +"Longitude": -112.068646 +"YearBuilt": 1995 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Jason McNeal" +"ListOfficeName": "Home Smart" +"ListAgentMlsId": "jm1233" +"ListOfficeMlsId": "cril01" +"OriginatingSystemName": "ARMLS" +"PublicRemarks": "Wonderful home in the Foothills! Spacious home with 4 large bedrooms, 3 full bathrooms, and a separate office. Very private backyard oasis with sparkling pool, rock waterfall, outdoor fireplace. Spectacular desert and mountain views from both the front and backyard. Home has a great layout with the master bedroom split from the other bedrooms on the 2nd floor and a full bathroom on the 1st floor. Great schools nearby, easy access to hiking, bike trails, parks, etc. Absolutely beautiful place to call home! Home is priced aggressively to receive multiple offers" +"Appliances": "Dryer,Washer,Reverse Osmosis,Refrigerator,Built-in Microwave,Dishwasher,Disposal,Electric Range,Electric Oven" +"ApprovalStatus": true +"AssociationFee": "210.0" +"AssociationFeeFrequency": "Semi-Annually" +"AssociationFeeIncludes": array:1 [ 0 => "Other (See Remarks)" ] +"AssociationName": "Trestle" +"AssociationPhone": "480-422-0888" +"AssociationYN": true +"BathroomsFull": 3 +"BedroomsPossible": 5 +"BuilderName": "Coventry" +"BuildingAreaSource": "Assessor" +"ConstructionMaterials": array:2 [ 0 => "Stucco" 1 => "Wood Frame" ] +"Cooling": "Central Air" +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Maricopa" +"CoveredSpaces": "2.0" +"CreationDate": "2026-04-22T19:11:30.012210+00:00" +"CrossStreet": "Desert Foothills and Glenhaven Dr" +"CurrentFinancing": array:1 [ 0 => "Other" ] +"Directions": "West on Glenhaven Dr from Desert Foothills, take your first left, home is on the left." +"Disclosures": array:1 [ 0 => "Other (See Remarks)" ] +"DocumentsChangeTimestamp": "2026-04-22T19:05:35Z" +"ElementarySchool": "Kyrene de la Sierra School" +"ElementarySchoolDistrict": "Kyrene Elementary District" +"Fencing": array:2 [ 0 => "Back Yard" 1 => "Block" ] +"FireplaceFeatures": array:2 [ 0 => "Exterior Fireplace" 1 => "Family Room" ] +"FireplaceYN": true +"FireplacesTotal": "2" +"Flooring": "Carpet,Tile" +"FoundationDetails": array:1 [ 0 => "Slab" ] +"GarageSpaces": "2.0" +"Heating": "Heat Pump" +"HeatingYN": true +"HighSchool": "Desert Vista High School" +"HighSchoolDistrict": "Tempe Union High School District" +"InteriorFeatures": "Walk-in Pantry,Granite Counters,Double Vanity,Kitchen Island,Full Bth Master Bdrm" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAgentAOR": "Scottsdale" +"ListAgentFirstName": "Jason" +"ListAgentKey": "20110503212951374475000000" +"ListAgentLastName": "Mc Neal" +"ListAgentPreferredPhone": "480-258-1305" +"ListOfficeEmail": "rlarue@hsmove.com" +"ListOfficeFax": "602-889-2155" +"ListOfficeKey": "20071206231317385095000000" +"ListOfficePhone": "602-230-7600" +"ListingContractDate": "2026-04-22" +"ListingTerms": "Cash,Conventional,VA Loan" +"LivingAreaSource": "Assessor" +"LotFeatures": array:5 [ 0 => "Sprinklers In Rear" 1 => "Sprinklers In Front" 2 => "Desert Back" 3 => "Desert Front" 4 => "Auto Timer H2O Front" ] +"LotSizeAcres": 0.13 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 5667.0 +"MajorChangeTimestamp": "2026-04-29T19:50:14Z" +"MajorChangeType": "Status Change" +"MiddleOrJuniorSchool": "Kyrene Altadena Middle School" +"MlsStatus": "Active" +"OpenParkingSpaces": "2.0" +"OriginalEntryTimestamp": "2026-04-22T19:05:35Z" +"OriginatingSystemID": "M00000048" +"OriginatingSystemKey": "20260422181846537149000000" +"Ownership": "Fee Simple" +"ParcelNumber": "300-95-653" +"PhotosChangeTimestamp": "2026-04-22T19:56:58Z" +"PhotosCount": 17 +"PoolFeatures": "Outdoor,Fenced" +"PoolPrivateYN": true +"Possession": array:1 [ 0 => "Close Of Escrow" ] +"PostalCity": "Phoenix" +"PostalCodePlus4": "2049" +"PublicSurveyRange": "3E" +"PublicSurveySection": "32" +"Roof": "Tile" +"RoomsTotal": "1" +"Sewer": "Sewer in & Cnctd,Public Sewer" +"SourceSystemID": "M00000048" +"SourceSystemKey": "20260422181846537149000000" +"SourceSystemName": "Arizona Regional Multiple Listing Service (ARMLS)" +"SpaFeatures": array:1 [ 0 => "None" ] +"SpecialListingConditions": array:1 [ 0 => "N/A" ] +"StateOrProvince": "AZ" +"StatusChangeTimestamp": "2026-04-29T19:50:11Z" +"StoriesTotal": "2" +"StreetDirPrefix": "E" +"StreetName": "GLENHAVEN" +"StreetNumber": "315" +"StreetNumberNumeric": "315" +"StreetSuffix": "Drive" +"SubdivisionName": "FOOTHILLS PARCELS 12AB C" +"TaxAnnualAmount": "3998.0" +"TaxBookNumber": "300.00" +"TaxLegalDescription": "LOT 166 FOOTHILLS PARCELS 12AB C MCR 037449" +"TaxLot": "166" +"TaxMapNumber": "95.00" +"TaxYear": "2025" +"Township": "1S" +"WaterSource": array:1 [ 0 => "City Water" ] +"Spa_co_None14": true +"Flooring_co_Tile": true +"Roofing_co_Tile2": true +"Utilities_co_APS": true +"Fencing_co_Block2": true +"Flooring_co_Carpet": true +"Legal_sp_Info_co_Range": "3E" +"Skirt@Core.Permissions": "None" +"Fencing_co_Back_sp_Yard": true +"Levels@Core.Permissions": "None" +"New_sp_Financing_co_VA5": true +"Zoning@Core.Permissions": "None" +"CapRate@Core.Permissions": "None" +"Heating_co_Heat_sp_Pump2": true +"Stories@Core.Permissions": "None" +"Cooling_co_Central_sp_Air": true +"GarageYN@Core.Permissions": "None" +"Legal_sp_Info_co_Section2": "32" +"New_sp_Financing_co_Cash2": true +"ParkName@Core.Permissions": "None" +"Basement_co_Basement_sp_YN": "N" +"Furnished@Core.Permissions": "None" +"OwnerName@Core.Permissions": "None" +"OwnerPays@Core.Permissions": "None" +"AccessCode@Core.Permissions": "None" +"CurrentUse@Core.Permissions": "None" +"Disclaimer@Core.Permissions": "None" +"OwnerPhone@Core.Permissions": "None" +"Topography@Core.Permissions": "None" +"Vegetation@Core.Permissions": "None" +"FuelExpense@Core.Permissions": "None" +"GrossIncome@Core.Permissions": "None" +"LeaseAmount@Core.Permissions": "None" +"ListTeamKey@Core.Permissions": "None" +"LockBoxType@Core.Permissions": "None" +"MobileWidth@Core.Permissions": "None" +"PetsAllowed@Core.Permissions": "None" +"Services_co_City_sp_Services": true +"BusinessName@Core.Permissions": "None" +"BusinessType@Core.Permissions": "None" +"BuyerTeamKey@Core.Permissions": "None" +"DaysOnMarket@Core.Permissions": "None" +"Landscaping_co_Desert_sp_Back": true +"Laundry_co_Dryer_sp_Included2": true +"LeasableArea@Core.Permissions": "None" +"ListPriceLow@Core.Permissions": "None" +"ListTeamName@Core.Permissions": "None" +"MLSAreaMajor@Core.Permissions": "None" +"MobileLength@Core.Permissions": "None" +"NumberOfLots@Core.Permissions": "None" +"OccupantType@Core.Permissions": "None" +"OtherExpense@Core.Permissions": "None" +"ParkingTotal@Core.Permissions": "None" +"RentIncludes@Core.Permissions": "None" +"Sewer_co_Sewer_sp_in_sp_Cnctd": true +"SourceMLSURL@Core.Permissions": "None" +"TrashExpense@Core.Permissions": "None" +"UnitTypeType@Core.Permissions": "None" +"BuyerAgentAOR@Core.Permissions": "None" +"BuyerAgentFax@Core.Permissions": "None" +"BuyerAgentURL@Core.Permissions": "None" +"BuyerTeamName@Core.Permissions": "None" +"Foundation_sp_Details_co_Slab2": true +"Landscaping_co_Desert_sp_Front": true +"Laundry_co_Washer_sp_Included2": true +"ListOfficeAOR@Core.Permissions": "None" +"OwnershipType@Core.Permissions": "None" +"StructureType@Core.Permissions": "None" +"Unit_sp_Style_co_Two_sp_Levels": true +"WaterBodyName@Core.Permissions": "None" +"WithdrawnDate@Core.Permissions": "None" +"BuyerFinancing@Core.Permissions": "None" +"BuyerOfficeAOR@Core.Permissions": "None" +"BuyerOfficeFax@Core.Permissions": "None" +"BuyerOfficeURL@Core.Permissions": "None" +"CoListAgentAOR@Core.Permissions": "None" +"DirectionFaces@Core.Permissions": "None" +"ExpirationDate@Core.Permissions": "None" +"Kitchen_sp_Features_co_Disposal": true +"ListAgentEmail@Core.Permissions": "None" +"PrivateRemarks@Core.Permissions": "None" +"BuyerAgentEmail@Core.Permissions": "None" +"BuyerAgentPager@Core.Permissions": "None" +"CancelationDate@Core.Permissions": "None" +"CoListOfficeAOR@Core.Permissions": "None" +"CoListOfficeFax@Core.Permissions": "None" +"CoListOfficeURL@Core.Permissions": "None" +"Contract_sp_Information_co_Type3": "Exclusive Right To Sell" +"CopyrightNotice@Core.Permissions": "None" +"ElectricExpense@Core.Permissions": "None" +"GardenerExpense@Core.Permissions": "None" +"LeaseExpiration@Core.Permissions": "None" +"LivingAreaUnits@Core.Permissions": "None" +"LockBoxLocation@Core.Permissions": "None" +"Special_sp_Listing_sp_Cond_co_NA": true +"Water_sp_Source_co_City_sp_Water": true +"Association_sp_Fees_co_HOA_sp_YN2": "Y" +"AttachedGarageYN@Core.Permissions": "None" +"AvailabilityDate@Core.Permissions": "None" +"BathroomsPartial@Core.Permissions": "None" +"BuildingFeatures@Core.Permissions": "None" +"CoBuyerOfficeAOR@Core.Permissions": "None" +"CoBuyerOfficeFax@Core.Permissions": "None" +"CoBuyerOfficeKey@Core.Permissions": "None" +"CoBuyerOfficeURL@Core.Permissions": "None" +"CoListAgentPager@Core.Permissions": "None" +"InsuranceExpense@Core.Permissions": "None" +"Kitchen_sp_Features_co_Dishwasher": true +"ListingAgreement@Core.Permissions": "None" +"New_sp_Financing_co_Conventional5": true +"OperatingExpense@Core.Permissions": "None" +"PendingTimestamp@Core.Permissions": "None" +"RoadFrontageType@Core.Permissions": "None" +"SignOnPropertyYN@Core.Permissions": "None" +"Association_sp_Fees_co_HOA_sp_Fee2": 210.0 +"CoBuyerOfficeName@Core.Permissions": "None" +"CoListOfficeEmail@Core.Permissions": "None" +"CoListOfficePhone@Core.Permissions": "None" +"DevelopmentStatus@Core.Permissions": "None" +"ExistingLeaseType@Core.Permissions": "None" +"Location_sp_Tax_sp_Legal_co_Taxes2": 3998.0 +"LotSizeDimensions@Core.Permissions": "None" +"NumberOfBuildings@Core.Permissions": "None" +"OnMarketTimestamp@Core.Permissions": "None" +"OriginalListPrice@Core.Permissions": "None" +"PreviousListPrice@Core.Permissions": "None" +"SeniorCommunityYN@Core.Permissions": "None" +"WaterSewerExpense@Core.Permissions": "None" +"Association_sp_Fees_co_HOA_sp_Name4": "Trestle" +"BuyerAgentLastName@Core.Permissions": "None" +"CoBuyerOfficeEmail@Core.Permissions": "None" +"CoBuyerOfficeMlsId@Core.Permissions": "None" +"CoBuyerOfficePhone@Core.Permissions": "None" +"Kitchen_sp_Features_co_Refrigerator": true +"ListAgentVoiceMail@Core.Permissions": "None" +"ListOfficePhoneExt@Core.Permissions": "None" +"MaintenanceExpense@Core.Permissions": "None" +"NetOperatingIncome@Core.Permissions": "None" +"NumberOfUnitsTotal@Core.Permissions": "None" +"OffMarketTimestamp@Core.Permissions": "None" +"Possession_co_Close_sp_of_sp_Escrow": true +"ShowingContactType@Core.Permissions": "None" +"AdditionalParcelsYN@Core.Permissions": "None" +"BathroomsOneQuarter@Core.Permissions": "None" +"BuyerAgentFirstName@Core.Permissions": "None" +"BuyerAgentVoiceMail@Core.Permissions": "None" +"BuyerOfficePhoneExt@Core.Permissions": "None" +"FinancialDataSource@Core.Permissions": "None" +"ListAgentMiddleName@Core.Permissions": "None" +"Sewer_co_Sewer_sp__hyphen__sp_Public": true +"ShowingInstructions@Core.Permissions": "None" +"AssociationAmenities@Core.Permissions": "None" +"Association_sp_Fees_co_HOA_sp_2_sp_YN": "N" +"BuyerAgentMiddleName@Core.Permissions": "None" +"CoListAgentVoiceMail@Core.Permissions": "None" +"CoListOfficePhoneExt@Core.Permissions": "None" +"Const_sp__hyphen__sp_Finish_co_Stucco": true +"Contract_sp_Information_co_Ownership2": "Fee Simple" +"GrossScheduledIncome@Core.Permissions": "None" +"HoursDaysOfOperation@Core.Permissions": "None" +"ListAgentDirectPhone@Core.Permissions": "None" +"ListAgentMobilePhone@Core.Permissions": "None" +"ListAgentOfficePhone@Core.Permissions": "None" +"Master_sp_Bathroom_co_Double_sp_Sinks": true +"PrivateOfficeRemarks@Core.Permissions": "None" +"StreetSuffixModifier@Core.Permissions": "None" +"VacancyAllowanceRate@Core.Permissions": "None" +"BathroomsThreeQuarter@Core.Permissions": "None" +"BathroomsTotalDecimal@Core.Permissions": "None" +"BuyerAgentDirectPhone@Core.Permissions": "None" +"BuyerAgentMobilePhone@Core.Permissions": "None" +"BuyerAgentOfficePhone@Core.Permissions": "None" +"CoBuyerOfficePhoneExt@Core.Permissions": "None" +"CoListAgentMiddleName@Core.Permissions": "None" +"Dining_sp_Area_co_Dining_sp_in_sp_LRGR": true +"DistanceToGasComments@Core.Permissions": "None" +"ListAgentStateLicense@Core.Permissions": "None" +"ListAgentVoiceMailExt@Core.Permissions": "None" +"Private_sp_Pool_sp_Features_co_Fenced2": true +"VideosChangeTimestamp@Core.Permissions": "None" +"VirtualTourURLBranded@Core.Permissions": "None" +"BuyerAgentStateLicense@Core.Permissions": "None" +"BuyerAgentVoiceMailExt@Core.Permissions": "None" +"CoListAgentDirectPhone@Core.Permissions": "None" +"CoListAgentOfficePhone@Core.Permissions": "None" +"CumulativeDaysOnMarket@Core.Permissions": "None" +"Kitchen_sp_Features_co_Electric_sp_Oven": true +"ListAgentTollFreePhone@Core.Permissions": "None" +"Private_sp_Pool_sp_Features_co_Outdoor2": true +"Association_sp_Fees_co_HOA_sp_Telephone4": "480-422-0888" +"Association_sp_Fees_co_PAD_sp_Fee_sp_YN2": "N" +"BuyerAgentTollFreePhone@Core.Permissions": "None" +"CoBuyerAgentMobilePhone@Core.Permissions": "None" +"CoListAgentStateLicense@Core.Permissions": "None" +"CoListAgentVoiceMailExt@Core.Permissions": "None" +"DistanceToSewerComments@Core.Permissions": "None" +"DistanceToWaterComments@Core.Permissions": "None" +"Kitchen_sp_Features_co_Electric_sp_Range": true +"Kitchen_sp_Features_co_Kitchen_sp_Island": true +"ListAgentOfficePhoneExt@Core.Permissions": "None" +"BuyerAgentOfficePhoneExt@Core.Permissions": "None" +"CoListAgentTollFreePhone@Core.Permissions": "None" +"Construction_co_Frame_sp__hyphen__sp_Wood": true +"ContractStatusChangeDate@Core.Permissions": "None" +"Kitchen_sp_Features_co_Reverse_sp_Osmosis": true +"OperatingExpenseIncludes@Core.Permissions": "None" +"Plumbing_co_Electric_sp_Hot_sp_Wtr_sp_Htr": true +"CoListAgentOfficePhoneExt@Core.Permissions": "None" +"Kitchen_sp_Features_co_Granite_sp_Counters": true +"NumberOfFullTimeEmployees@Core.Permissions": "None" +"NumberOfPartTimeEmployees@Core.Permissions": "None" +"Showing_sp_Notification_sp_Methods_co_Text": true +"Association_sp_Fees_co_Other_sp_Fees_sp_HOA": 0.0 +"DistanceToElectricComments@Core.Permissions": "None" +"Landscaping_co_Yrd_sp_Wtring_sp_Sys_sp_Back": true +"ListAgentPreferredPhoneExt@Core.Permissions": "None" +"Showing_sp_Notification_sp_Methods_co_Email": true +"BuyerAgentPreferredPhoneExt@Core.Permissions": "None" +"General_sp_Property_sp_Description_co_Horses": "N" +"Landscaping_co_Auto_sp_Timer_sp_H2O_sp_Front": true +"Landscaping_co_Yrd_sp_Wtring_sp_Sys_sp_Front": true +"CoListAgentPreferredPhoneExt@Core.Permissions": "None" +"General_sp_Property_sp_Description_co_ud_i_07": 2.0 +"MiddleOrJuniorSchoolDistrict@Core.Permissions": "None" +"Association_sp_Fees_co_HOA_sp_Transfer_sp_Fee2": 150.0 +"Fireplace_sp_Features_co_Exterior_sp_Fireplace": true +"Parking_sp_Spaces_co_Slab_sp_Parking_sp_Spaces": 2.0 +"ProfessionalManagementExpense@Core.Permissions": "None" +"Association_sp_Fees_co_HOA_sp_Paid_sp_Frequency": "Semi-Annually" +"DistanceToPhoneServiceComments@Core.Permissions": "None" +"General_sp_Property_sp_Description_co_PriceSqFt": 222.68 +"Kitchen_sp_Features_co_Walk_hyphen_in_sp_Pantry": true +"Parking_sp_Spaces_co_Total_sp_Covered_sp_Spaces": 2.0 +"Separate_sp_DenOffice_co_Sep_sp_DenOffice_sp_YN": "Y" +"TaxOtherAnnualAssessmentAmount@Core.Permissions": "None" +"Association_sp_Fees_co_Disclosure_sp_Fees_sp_HOA": 250.0 +"Location_sp_Tax_sp_Legal_co_Tax_sp_Municipality3": "Phoenix" +"Association_sp_Fees_co_Land_sp_Lease_sp_Fee_sp_YN": "N" +"Association_sp_Fees_co_Rec_sp_Center_sp_Fee_sp_YN": "N" +"Lockbox_sp_Type_co_Supra_sp__lparen_ARMLS_rparen_": true +"Fireplace_sp_Features_co_Fireplace_sp_Family_sp_Rm": true +"Association_sp_Fees_co_Special_sp_Assessment_sp_HOA": "No" +"Association_sp_Fees_co_Ttl_sp_Mthly_sp_Fee_sp_Equiv": 35.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": 2694.0 +"General_sp_Property_sp_Description_co_High_sp_School": "Desert Vista High School" +"General_sp_Property_sp_Description_co_Builder_sp_Name": "Coventry" +"Association_sp_Fees_co_Cap_sp_ImprovementImpact_sp_Fee": 0.0 +"General_sp_Property_sp_Description_co_Fireplace_sp_YN2": "Yes" +"Disclosures_co_Other_sp__lparen_See_sp_Remarks_rparen_2": true +"General_sp_Property_sp_Description_co_Full_sp_Bathroom2": 3 +"General_sp_Property_sp_Description_co_Dwelling_sp_Styles": "Detached" +"General_sp_Property_sp_Description_co_Half_sp_Bathrooms2": 0.0 +"Showing_sp_Notification_sp_Methods_co_Showing_sp_Service": "Aligned Showings" +"General_sp_Property_sp_Description_co_Elementary_sp_School": "Kyrene de la Sierra School" +"General_sp_Property_sp_Description_co_Jr_sp_High_sp_School": "Kyrene Altadena Middle School" +"General_sp_Property_sp_Description_co_Approx_sp_Lot_sp_SqFt": 5667.0 +"Association_sp_Fees_co_Prepaid_sp_Association_sp_Fees_sp_HOA": 0.0 +"General_sp_Property_sp_Description_co_Private_sp_Pool_sp_YN2": "Yes" +"General_sp_Property_sp_Description_co_Approx_sp_Lot_sp_Acres2": 0.13 +"General_sp_Property_sp_Description_co_Planned_sp_Comm_sp_Name": "Foothills Community" +"Assoc_sp_RulesInfo_co_Other_sp__lparen_See_sp_Remarks_rparen_4": true +"General_sp_Property_sp_Description_co_Community_sp_Pool_sp_YN2": "No" +"Association_sp_Fees_co_HOA_sp_DisclosureAddendum_sp_Affirmation": "Yes" +"Location_sp_Tax_sp_Legal_co_Assessor_squote_s_sp_Map_sp__pound_3": 95.0 +"General_sp_Property_sp_Description_co_High_sp_School_sp_District2": "Tempe Union High School District" +"Association_sp_Fees_co_Cap_sp_ImprovementImpact_sp_Fee_sp__percent_": "$" +"Existing_sp_1st_sp_Loan_co_Other_sp__lparen_See_sp_Remarks_rparen_3": true +"Location_sp_Tax_sp_Legal_co_Assessor_squote_s_sp_Parcel_sp__pound_3": 653.0 +"Association_sp_Fee_sp_Incl_co_Other_sp__lparen_See_sp_Remarks_rparen_5": true +"General_sp_Property_sp_Description_co_Elementary_sp_School_sp_District2": "Kyrene Elementary District" +"General_sp_Property_sp_Description_co__pound__sp_of_sp_Interior_sp_Levels": 2 +"Location_sp_Tax_sp_Legal_co_Legal_sp_Description_sp__lparen_Abbrev_rparen_3": "LOT 166 FOOTHILLS PARCELS 12AB C MCR 037449" +"Contract_sp_Information_co_Co_hyphen_Ownership_sp__lparen_Fractional_rparen__sp_Agreement_sp_YN": "No" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('20260422181846537149000000')" +"provider_name": "ARMLS" +"SourceSystemPlatformID": "T00000052" +"SourceSystemPlatformName": "Flexmls" +"OriginatingSystemPlatformID": "T00000052" +"OriginatingSystemPlatformName": "Flexmls" +"Media": array:17 [ 0 => array:16 [ "Order" => 1 "MediaKey" => "20260422195630737277000000" "MediaURL" => "https://cdn.realtyfeed.com/cdn/54/20260422181846537149000000/992504f7792bf611131d6f43daede751.webp" "@odata.id" => "https://replication.sparkapi.com/Version/2/Reso/OData/Property('20260422181846537149000000')/Media('20260422195630737277000000')" "MediaHTML" => null "MediaSize" => 592854 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/54/20260422181846537149000000/thumbnail-992504f7792bf611131d6f43daede751.webp" "Permission" => array:1 [ 0 => "Public" ] "MediaCategory" => "Photo" "LongDescription" => "" "PreferredPhotoYN" => true "ResourceRecordID" => "20260422181846537149000000" "ShortDescription" => "1000008261" "ResourceRecordKey" => "20260422181846537149000000" "OriginatingSystemMediaKey" => "20260422195630737277000000" ] 1 => array:16 [ "Order" => 2 "MediaKey" => "20260422195632355446000000" "MediaURL" => "https://cdn.realtyfeed.com/cdn/54/20260422181846537149000000/b98a2b28ac0d74ad5546f0f7436c7c48.webp" "@odata.id" => "https://replication.sparkapi.com/Version/2/Reso/OData/Property('20260422181846537149000000')/Media('20260422195632355446000000')" "MediaHTML" => null "MediaSize" => 709336 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/54/20260422181846537149000000/thumbnail-b98a2b28ac0d74ad5546f0f7436c7c48.webp" "Permission" => array:1 [ 0 => "Public" ] "MediaCategory" => "Photo" "LongDescription" => "" "PreferredPhotoYN" => false "ResourceRecordID" => "20260422181846537149000000" "ShortDescription" => "1000008258" "ResourceRecordKey" => "20260422181846537149000000" "OriginatingSystemMediaKey" => "20260422195632355446000000" ] 2 => array:16 [ "Order" => 3 "MediaKey" => "20260422195634148043000000" "MediaURL" => "https://cdn.realtyfeed.com/cdn/54/20260422181846537149000000/fce96bb08f5c38a35d1fbf897ae8e21a.webp" "@odata.id" => "https://replication.sparkapi.com/Version/2/Reso/OData/Property('20260422181846537149000000')/Media('20260422195634148043000000')" "MediaHTML" => null "MediaSize" => 542133 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/54/20260422181846537149000000/thumbnail-fce96bb08f5c38a35d1fbf897ae8e21a.webp" "Permission" => array:1 [ 0 => "Public" ] "MediaCategory" => "Photo" "LongDescription" => "" "PreferredPhotoYN" => false "ResourceRecordID" => "20260422181846537149000000" "ShortDescription" => "1000008266" "ResourceRecordKey" => "20260422181846537149000000" "OriginatingSystemMediaKey" => "20260422195634148043000000" ] 3 => array:16 [ "Order" => 4 "MediaKey" => "20260422195636339663000000" "MediaURL" => "https://cdn.realtyfeed.com/cdn/54/20260422181846537149000000/1944ca782e25425afdd8b014c4222399.webp" "@odata.id" => "https://replication.sparkapi.com/Version/2/Reso/OData/Property('20260422181846537149000000')/Media('20260422195636339663000000')" "MediaHTML" => null "MediaSize" => 674988 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/54/20260422181846537149000000/thumbnail-1944ca782e25425afdd8b014c4222399.webp" "Permission" => array:1 [ 0 => "Public" ] "MediaCategory" => "Photo" "LongDescription" => "" "PreferredPhotoYN" => false "ResourceRecordID" => "20260422181846537149000000" "ShortDescription" => "1000008267" "ResourceRecordKey" => "20260422181846537149000000" "OriginatingSystemMediaKey" => "20260422195636339663000000" ] 4 => array:16 [ "Order" => 5 "MediaKey" => "20260422195638029945000000" "MediaURL" => "https://cdn.realtyfeed.com/cdn/54/20260422181846537149000000/e39901a1cf771e33f20db88909a336ef.webp" "@odata.id" => "https://replication.sparkapi.com/Version/2/Reso/OData/Property('20260422181846537149000000')/Media('20260422195638029945000000')" "MediaHTML" => null "MediaSize" => 566649 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/54/20260422181846537149000000/thumbnail-e39901a1cf771e33f20db88909a336ef.webp" "Permission" => array:1 [ 0 => "Public" ] "MediaCategory" => "Photo" "LongDescription" => "" "PreferredPhotoYN" => false "ResourceRecordID" => "20260422181846537149000000" "ShortDescription" => "1000008268" "ResourceRecordKey" => "20260422181846537149000000" "OriginatingSystemMediaKey" => "20260422195638029945000000" ] 5 => array:16 [ "Order" => 6 "MediaKey" => "20260422195639482456000000" "MediaURL" => "https://cdn.realtyfeed.com/cdn/54/20260422181846537149000000/2dcea74be2b6a3c7c1696442f3bcafd6.webp" "@odata.id" => "https://replication.sparkapi.com/Version/2/Reso/OData/Property('20260422181846537149000000')/Media('20260422195639482456000000')" "MediaHTML" => null "MediaSize" => 396869 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/54/20260422181846537149000000/thumbnail-2dcea74be2b6a3c7c1696442f3bcafd6.webp" "Permission" => array:1 [ 0 => "Public" ] "MediaCategory" => "Photo" "LongDescription" => "" "PreferredPhotoYN" => false "ResourceRecordID" => "20260422181846537149000000" "ShortDescription" => "1000008269" "ResourceRecordKey" => "20260422181846537149000000" "OriginatingSystemMediaKey" => "20260422195639482456000000" ] 6 => array:16 [ "Order" => 7 "MediaKey" => "20260422195641134692000000" "MediaURL" => "https://cdn.realtyfeed.com/cdn/54/20260422181846537149000000/07b61cfd9c6047d018bedcc8eafad73f.webp" "@odata.id" => "https://replication.sparkapi.com/Version/2/Reso/OData/Property('20260422181846537149000000')/Media('20260422195641134692000000')" "MediaHTML" => null "MediaSize" => 421583 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/54/20260422181846537149000000/thumbnail-07b61cfd9c6047d018bedcc8eafad73f.webp" "Permission" => array:1 [ 0 => "Public" ] "MediaCategory" => "Photo" "LongDescription" => "" "PreferredPhotoYN" => false "ResourceRecordID" => "20260422181846537149000000" "ShortDescription" => "1000008270" "ResourceRecordKey" => "20260422181846537149000000" "OriginatingSystemMediaKey" => "20260422195641134692000000" ] 7 => array:16 [ "Order" => 8 "MediaKey" => "20260422195642682559000000" "MediaURL" => "https://cdn.realtyfeed.com/cdn/54/20260422181846537149000000/f4f44a9ad0afc7bb7fd3d2b96ae65472.webp" "@odata.id" => "https://replication.sparkapi.com/Version/2/Reso/OData/Property('20260422181846537149000000')/Media('20260422195642682559000000')" "MediaHTML" => null "MediaSize" => 332575 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/54/20260422181846537149000000/thumbnail-f4f44a9ad0afc7bb7fd3d2b96ae65472.webp" "Permission" => array:1 [ 0 => "Public" ] "MediaCategory" => "Photo" "LongDescription" => "" "PreferredPhotoYN" => false "ResourceRecordID" => "20260422181846537149000000" "ShortDescription" => "1000008271" "ResourceRecordKey" => "20260422181846537149000000" "OriginatingSystemMediaKey" => "20260422195642682559000000" ] 8 => array:16 [ "Order" => 9 "MediaKey" => "20260422195644203676000000" "MediaURL" => "https://cdn.realtyfeed.com/cdn/54/20260422181846537149000000/354a550f1705ae83d3befabb6a42a99f.webp" "@odata.id" => "https://replication.sparkapi.com/Version/2/Reso/OData/Property('20260422181846537149000000')/Media('20260422195644203676000000')" "MediaHTML" => null "MediaSize" => 445838 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/54/20260422181846537149000000/thumbnail-354a550f1705ae83d3befabb6a42a99f.webp" "Permission" => array:1 [ 0 => "Public" ] "MediaCategory" => "Photo" "LongDescription" => "" "PreferredPhotoYN" => false "ResourceRecordID" => "20260422181846537149000000" "ShortDescription" => "1000008272" "ResourceRecordKey" => "20260422181846537149000000" "OriginatingSystemMediaKey" => "20260422195644203676000000" ] 9 => array:16 [ "Order" => 10 "MediaKey" => "20260422195645917763000000" "MediaURL" => "https://cdn.realtyfeed.com/cdn/54/20260422181846537149000000/252ea27a78c6df281ce0bb720b079f32.webp" "@odata.id" => "https://replication.sparkapi.com/Version/2/Reso/OData/Property('20260422181846537149000000')/Media('20260422195645917763000000')" "MediaHTML" => null "MediaSize" => 452207 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/54/20260422181846537149000000/thumbnail-252ea27a78c6df281ce0bb720b079f32.webp" "Permission" => array:1 [ 0 => "Public" ] "MediaCategory" => "Photo" "LongDescription" => "" "PreferredPhotoYN" => false "ResourceRecordID" => "20260422181846537149000000" "ShortDescription" => "1000008273" "ResourceRecordKey" => "20260422181846537149000000" "OriginatingSystemMediaKey" => "20260422195645917763000000" ] 10 => array:16 [ "Order" => 11 "MediaKey" => "20260422195647883624000000" "MediaURL" => "https://cdn.realtyfeed.com/cdn/54/20260422181846537149000000/8ee6f4dd6a2d28f5bb539385cdadde4b.webp" "@odata.id" => "https://replication.sparkapi.com/Version/2/Reso/OData/Property('20260422181846537149000000')/Media('20260422195647883624000000')" "MediaHTML" => null "MediaSize" => 434932 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/54/20260422181846537149000000/thumbnail-8ee6f4dd6a2d28f5bb539385cdadde4b.webp" "Permission" => array:1 [ 0 => "Public" ] "MediaCategory" => "Photo" "LongDescription" => "" "PreferredPhotoYN" => false "ResourceRecordID" => "20260422181846537149000000" "ShortDescription" => "1000008274" "ResourceRecordKey" => "20260422181846537149000000" "OriginatingSystemMediaKey" => "20260422195647883624000000" ] 11 => array:16 [ "Order" => 12 "MediaKey" => "20260422195649267039000000" "MediaURL" => "https://cdn.realtyfeed.com/cdn/54/20260422181846537149000000/fa21ed318a14c00d024a03aa0d45d1b7.webp" "@odata.id" => "https://replication.sparkapi.com/Version/2/Reso/OData/Property('20260422181846537149000000')/Media('20260422195649267039000000')" "MediaHTML" => null "MediaSize" => 353204 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/54/20260422181846537149000000/thumbnail-fa21ed318a14c00d024a03aa0d45d1b7.webp" "Permission" => array:1 [ 0 => "Public" ] "MediaCategory" => "Photo" "LongDescription" => "" "PreferredPhotoYN" => false "ResourceRecordID" => "20260422181846537149000000" "ShortDescription" => "1000008275" "ResourceRecordKey" => "20260422181846537149000000" "OriginatingSystemMediaKey" => "20260422195649267039000000" ] 12 => array:16 [ "Order" => 13 "MediaKey" => "20260422195651161046000000" "MediaURL" => "https://cdn.realtyfeed.com/cdn/54/20260422181846537149000000/4949a7ae0487cc079b45599948840f72.webp" "@odata.id" => "https://replication.sparkapi.com/Version/2/Reso/OData/Property('20260422181846537149000000')/Media('20260422195651161046000000')" "MediaHTML" => null "MediaSize" => 709336 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/54/20260422181846537149000000/thumbnail-4949a7ae0487cc079b45599948840f72.webp" "Permission" => array:1 [ 0 => "Public" ] "MediaCategory" => "Photo" "LongDescription" => "" "PreferredPhotoYN" => false "ResourceRecordID" => "20260422181846537149000000" "ShortDescription" => "1000008276" "ResourceRecordKey" => "20260422181846537149000000" "OriginatingSystemMediaKey" => "20260422195651161046000000" ] 13 => array:16 [ "Order" => 14 "MediaKey" => "20260422195652760894000000" "MediaURL" => "https://cdn.realtyfeed.com/cdn/54/20260422181846537149000000/8fcc688d753d044852194dfc418ca788.webp" "@odata.id" => "https://replication.sparkapi.com/Version/2/Reso/OData/Property('20260422181846537149000000')/Media('20260422195652760894000000')" "MediaHTML" => null "MediaSize" => 402551 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/54/20260422181846537149000000/thumbnail-8fcc688d753d044852194dfc418ca788.webp" "Permission" => array:1 [ 0 => "Public" ] "MediaCategory" => "Photo" "LongDescription" => "" "PreferredPhotoYN" => false "ResourceRecordID" => "20260422181846537149000000" "ShortDescription" => "1000008277" "ResourceRecordKey" => "20260422181846537149000000" "OriginatingSystemMediaKey" => "20260422195652760894000000" ] 14 => array:16 [ "Order" => 15 "MediaKey" => "20260422195654368682000000" "MediaURL" => "https://cdn.realtyfeed.com/cdn/54/20260422181846537149000000/cd474cba63c20e906ea56b084f8381a3.webp" "@odata.id" => "https://replication.sparkapi.com/Version/2/Reso/OData/Property('20260422181846537149000000')/Media('20260422195654368682000000')" "MediaHTML" => null "MediaSize" => 443776 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/54/20260422181846537149000000/thumbnail-cd474cba63c20e906ea56b084f8381a3.webp" "Permission" => array:1 [ 0 => "Public" ] "MediaCategory" => "Photo" "LongDescription" => "" "PreferredPhotoYN" => false "ResourceRecordID" => "20260422181846537149000000" "ShortDescription" => "1000008278" "ResourceRecordKey" => "20260422181846537149000000" "OriginatingSystemMediaKey" => "20260422195654368682000000" ] 15 => array:16 [ "Order" => 16 "MediaKey" => "20260422195656123343000000" "MediaURL" => "https://cdn.realtyfeed.com/cdn/54/20260422181846537149000000/68fe9906aa8e0f79ccac7de035e5fb9d.webp" "@odata.id" => "https://replication.sparkapi.com/Version/2/Reso/OData/Property('20260422181846537149000000')/Media('20260422195656123343000000')" "MediaHTML" => null "MediaSize" => 592854 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/54/20260422181846537149000000/thumbnail-68fe9906aa8e0f79ccac7de035e5fb9d.webp" "Permission" => array:1 [ 0 => "Public" ] "MediaCategory" => "Photo" "LongDescription" => "" "PreferredPhotoYN" => false "ResourceRecordID" => "20260422181846537149000000" "ShortDescription" => "1000008279" "ResourceRecordKey" => "20260422181846537149000000" "OriginatingSystemMediaKey" => "20260422195656123343000000" ] 16 => array:16 [ "Order" => 17 "MediaKey" => "20260422195658085594000000" "MediaURL" => "https://cdn.realtyfeed.com/cdn/54/20260422181846537149000000/fb24c85b7745e7cfd6dc5ffbc4910fe9.webp" "@odata.id" => "https://replication.sparkapi.com/Version/2/Reso/OData/Property('20260422181846537149000000')/Media('20260422195658085594000000')" "MediaHTML" => null "MediaSize" => 805237 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/54/20260422181846537149000000/thumbnail-fb24c85b7745e7cfd6dc5ffbc4910fe9.webp" "Permission" => array:1 [ 0 => "Public" ] "MediaCategory" => "Photo" "LongDescription" => "" "PreferredPhotoYN" => false "ResourceRecordID" => "20260422181846537149000000" "ShortDescription" => "1000008280" "ResourceRecordKey" => "20260422181846537149000000" "OriginatingSystemMediaKey" => "20260422195658085594000000" ] ] +"DaysOnMarket": 28 +"ID": "124498" }
Active
315 E GLENHAVEN Drive, Phoenix, AZ 85048
315 E GLENHAVEN Drive, Phoenix, AZ 85048
Description
Wonderful home in the Foothills! Spacious home with 4 large bedrooms, 3 full bathrooms, and a separate office. Very private backyard oasis with sparkling pool, rock waterfall, outdoor fireplace. Spectacular desert and mountain views from both the front and backyard. Home has a great layout with the master bedroom split from the other bedrooms on the 2nd floor and a full bathroom on the 1st floor. Great schools nearby, easy access to hiking, bike trails, parks, etc. Absolutely beautiful place to call home! Home is priced aggressively to receive multiple offers
Address
Open on Google Maps- Address 315 E GLENHAVEN Drive
- City Phoenix
- State/county AZ
- Zip/Postal Code 85048
- Country US
Details
Updated on April 29, 2026 at 7:50 pm- Property ID: 7017658
- Price: $599,900
- Land Area: 0.13 Acres
- Bedrooms: 4
- Room: 1
- Bathrooms: 3
- Garages: 2.0
- Garage Size: x x
- Year Built: 1995
- Property Type: Single Family Residence, Residential
- Property Status: Active
- MLS#: 7017658
Additional details
- Listing Terms: Cash,Conventional,VA Loan
- Association Fee: 210.0
- Roof: Tile
- Sewer: Sewer in & Cnctd,Public Sewer
- Cooling: Central Air
- Heating: Heat Pump
- Flooring: Carpet,Tile
- County: Maricopa
- Property Type: Residential
- Pool: Outdoor,Fenced
- Elementary School: Kyrene de la Sierra School
- Middle School: Kyrene Altadena Middle School
- High School: Desert Vista High School
Mortgage Calculator
Monthly
- Down Payment
- Loan Amount
- Monthly Mortgage Payment
- Property Tax
- Home Insurance
- PMI