Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#19162 +post_id: "82275" +post_author: 1 +"ListingKey": "20260111194820183491000000" +"ListingId": "6977259" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-05-24T18:13:11Z" +"RFModificationTimestamp": "2026-05-24T18:15:05Z" +"ListPrice": 489999.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 3.0 +"LotSizeArea": 8190.0 +"LivingArea": 2236.0 +"BuildingAreaTotal": 0 +"City": "Surprise" +"PostalCode": "85387" +"UnparsedAddress": "28788 N 174th Lane, Surprise, Arizona 85387" +"Coordinates": array:2 [ 0 => -112.438125 1 => 33.743939 ] +"Latitude": 33.743939 +"Longitude": -112.438125 +"YearBuilt": 2026 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Tisha Ferguson" +"ListOfficeName": "Mattamy Arizona, LLC" +"ListAgentMlsId": "tf142" +"ListOfficeMlsId": "mtmy01" +"OriginatingSystemName": "ARMLS" +"PublicRemarks": "This gorgeous Desert Modern home is on an end, so only 1 neighbor, none behind you and open space on one side with a single level next to you, the entire community is single level. This 2200 + Has a beautify gourmet kitchen with tile back splash, mud set owners shower, 8' interior doors throughout, soft water loop and gas stub at backyard. Come see this remarkable home plan." +"Appliances": "Built In Recycling,Built-in Microwave,Dishwasher,Disposal,Gas Cooktop" +"ApprovalStatus": true +"ArchitecturalStyle": "Other" +"AssociationFee": "110.0" +"AssociationFeeFrequency": "Monthly" +"AssociationFeeIncludes": array:1 [ 0 => "Maintenance Grounds" ] +"AssociationName": "Tierra Vistoso HOA" +"AssociationPhone": "602-957-9191" +"AssociationYN": true +"BathroomsFull": 2 +"BedroomsPossible": 4 +"BuilderName": "Mattamy Homes" +"BuildingAreaSource": "Assessor" +"CommunityFeatures": "Playground,Biking/Walking Path" +"ConstructionMaterials": array:4 [ 0 => "Stucco" 1 => "Wood Frame" 2 => "Low VOC Paint" 3 => "Painted" ] +"Cooling": "Central Air,ENERGY STAR Qualified Equipment,Programmable Thmstat" +"CoolingYN": true +"Country": "US" +"CountyOrParish": "Maricopa" +"CoveredSpaces": "3.0" +"CreationDate": "2026-01-30T21:28:38.789013+00:00" +"CrossStreet": "Jomax & 171st Ave." +"Directions": "From US-60, head North on 163rd Avenue. Turn Left onto Jomax Rd. Turn Right onto 171st Ave. Turn Left onto Dale Ln, Turn Right into the community on N 172nd Dr." +"Disclosures": array:1 [ 0 => "Agency Discl Req" ] +"DocumentsChangeTimestamp": "2026-01-30T21:22:49Z" +"ElementarySchool": "Desert Oasis Elementary School" +"ElementarySchoolDistrict": "Nadaburg Unified School District" +"Fencing": array:1 [ 0 => "Block" ] +"Flooring": "Carpet,Tile" +"GarageSpaces": "3.0" +"GreenEnergyEfficient": array:2 [ 0 => "Energy Audit" 1 => "ENERGY STAR Light Fixture" ] +"Heating": "ENERGY STAR Qualified Equipment,Natural Gas" +"HeatingYN": true +"HighSchool": "Mountainside High School" +"HighSchoolDistrict": "Nadaburg Unified School District" +"InteriorFeatures": "Walk-in Pantry,Non-laminate Counter,Double Vanity,Eat-in Kitchen,Breakfast Bar,9+ Flat Ceilings,Kitchen Island,Pantry,3/4 Bath Master Bdrm" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:3 [ 0 => "Inside" 1 => "Engy Star (See Rmks)" 2 => "Wshr/Dry HookUp Only" ] +"ListAgentAOR": "Phoenix REALTORS" +"ListAgentFirstName": "Tisha" +"ListAgentHomePhone": "480-771-8329" +"ListAgentKey": "20100608194428595283000000" +"ListAgentLastName": "Ferguson" +"ListOfficeEmail": "tisha.ferguson@mattamycorp.com" +"ListOfficeFax": "480-302-6076" +"ListOfficeKey": "20071206231639297231000000" +"ListOfficePhone": "480-302-6080" +"ListOfficeURL": "http://www.mattamyhomes.com" +"ListingContractDate": "2026-01-30" +"ListingTerms": "Cash,Conventional,1031 Exchange,FHA,VA Loan" +"LivingAreaSource": "Assessor" +"LotFeatures": array:4 [ 0 => "North/South Exposure" 1 => "Sprinklers In Front" 2 => "Desert Front" 3 => "Dirt Back" ] +"LotSizeAcres": 0.19 +"LotSizeSource": "Assessor" +"LotSizeSquareFeet": 8190.0 +"MajorChangeTimestamp": "2026-04-28T01:04:41Z" +"MajorChangeType": "Price Reduced" +"MiddleOrJuniorSchool": "Desert Oasis Elementary School" +"MlsStatus": "Active" +"Model": "Apple" +"OpenParkingSpaces": "2.0" +"OriginalEntryTimestamp": "2026-01-30T21:22:48Z" +"OriginatingSystemID": "M00000048" +"OriginatingSystemKey": "20260111194820183491000000" +"Ownership": "Fee Simple" +"ParcelNumber": "503-63-781" +"ParkingFeatures": "Tandem Garage,Garage Door Opener,Direct Access" +"PhotosChangeTimestamp": "2026-01-30T21:22:49Z" +"PhotosCount": 15 +"Possession": array:1 [ 0 => "Close Of Escrow" ] +"PostalCity": "Surprise" +"PostalCodePlus4": "2441" +"PriceChangeTimestamp": "2026-04-28T01:04:41Z" +"PropertyCondition": array:1 [ 0 => "Complete Spec Home" ] +"PublicSurveyRange": "2W" +"PublicSurveySection": "26" +"Roof": "Tile,Concrete" +"Sewer": "Public Sewer" +"SourceSystemID": "M00000048" +"SourceSystemKey": "20260111194820183491000000" +"SourceSystemName": "Arizona Regional Multiple Listing Service (ARMLS)" +"SpaFeatures": array:1 [ 0 => "None" ] +"SpecialListingConditions": array:1 [ 0 => "N/A" ] +"StateOrProvince": "AZ" +"StatusChangeTimestamp": "2026-01-30T21:22:48Z" +"StoriesTotal": "1" +"StreetDirPrefix": "N" +"StreetName": "174TH" +"StreetNumber": "28788" +"StreetNumberNumeric": "28788" +"StreetSuffix": "Lane" +"SubdivisionName": "Tierra Vistoso - 2069" +"TaxBookNumber": "503.00" +"TaxLegalDescription": "LOT 72 TIERRA RICO PARCEL B MCR 162835" +"TaxLot": "2069" +"TaxMapNumber": "63.00" +"TaxYear": "2026" +"Township": "5N" +"WaterSource": array:1 [ 0 => "City Water" ] +"WindowFeatures": array:4 [ 0 => "Low-Emissivity Windows" 1 => "Dual Pane" 2 => "ENERGY STAR Qualified Windows" 3 => "Vinyl Frame" ] +"Spa_co_None14": true +"Flooring_co_Tile": true +"Roofing_co_Tile2": true +"Utilities_co_APS": true +"Fencing_co_Block2": true +"Flooring_co_Carpet": true +"Laundry_co_Inside2": true +"Roofing_co_Concrete4": true +"Legal_sp_Info_co_Range": "2W" +"Skirt@Core.Permissions": "None" +"Levels@Core.Permissions": "None" +"New_sp_Financing_co_VA5": true +"Utilities_co_SW_sp_Gas3": true +"Zoning@Core.Permissions": "None" +"CapRate@Core.Permissions": "None" +"New_sp_Financing_co_FHA5": true +"Stories@Core.Permissions": "None" +"Cooling_co_Central_sp_Air": true +"GarageYN@Core.Permissions": "None" +"Heating_co_Natural_sp_Gas": true +"Legal_sp_Info_co_Section2": "26" +"Lockbox_sp_Type_co_None43": true +"New_sp_Financing_co_Cash2": true +"ParkName@Core.Permissions": "None" +"Basement_co_Basement_sp_YN": "N" +"Furnished@Core.Permissions": "None" +"Master_sp_Bedroom_co_Split": true +"OwnerName@Core.Permissions": "None" +"OwnerPays@Core.Permissions": "None" +"AccessCode@Core.Permissions": "None" +"CurrentUse@Core.Permissions": "None" +"Disclaimer@Core.Permissions": "None" +"Landscaping_co_Dirt_sp_Back": true +"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" +"Kitchen_sp_Features_co_Pantry": 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" +"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" +"Landscaping_co_Desert_sp_Front": true +"ListOfficeAOR@Core.Permissions": "None" +"OwnershipType@Core.Permissions": "None" +"StructureType@Core.Permissions": "None" +"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" +"Other_sp_Rooms_co_Great_sp_Room": true +"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" +"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": 110.0 +"CoBuyerOfficeName@Core.Permissions": "None" +"CoListOfficeEmail@Core.Permissions": "None" +"CoListOfficePhone@Core.Permissions": "None" +"Cooling_co_Programmable_sp_Thmstat": true +"DevelopmentStatus@Core.Permissions": "None" +"Dining_sp_Area_co_Breakfast_sp_Bar": true +"ExistingLeaseType@Core.Permissions": "None" +"Location_sp_Tax_sp_Legal_co_Taxes2": 0.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" +"Window_sp_Features_co_Dual_sp_Pane": true +"Window_sp_Features_co_Low_hyphen_E": true +"Association_sp_Fees_co_HOA_sp_Name4": "Tierra Vistoso HOA" +"BuyerAgentLastName@Core.Permissions": "None" +"CoBuyerOfficeEmail@Core.Permissions": "None" +"CoBuyerOfficeMlsId@Core.Permissions": "None" +"CoBuyerOfficePhone@Core.Permissions": "None" +"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" +"Laundry_co_WshrDry_sp_HookUp_sp_Only": true +"ListAgentMiddleName@Core.Permissions": "None" +"Sewer_co_Sewer_sp__hyphen__sp_Public": true +"ShowingInstructions@Core.Permissions": "None" +"Window_sp_Features_co_Vinyl_sp_Frame": true +"Assoc_sp_RulesInfo_co_Prof_sp_Managed": true +"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" +"Disclosures_co_Agency_sp_Discl_sp_Req": true +"GrossScheduledIncome@Core.Permissions": "None" +"HoursDaysOfOperation@Core.Permissions": "None" +"Kitchen_sp_Features_co_Gas_sp_Cooktop": true +"ListAgentDirectPhone@Core.Permissions": "None" +"ListAgentMobilePhone@Core.Permissions": "None" +"ListAgentOfficePhone@Core.Permissions": "None" +"Master_sp_Bathroom_co_Double_sp_Sinks": true +"New_sp_Financing_co_1031_sp_Exchange2": 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" +"Const_sp__hyphen__sp_Finish_co_Painted": true +"Dining_sp_Area_co_Dining_sp_in_sp_LRGR": true +"DistanceToGasComments@Core.Permissions": "None" +"ListAgentStateLicense@Core.Permissions": "None" +"ListAgentVoiceMailExt@Core.Permissions": "None" +"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" +"ListAgentTollFreePhone@Core.Permissions": "None" +"Parking_sp_Features_co_Direct_sp_Access": true +"Parking_sp_Features_co_Tandem_sp_Garage": true +"Association_sp_Fees_co_HOA_sp_Telephone4": "602-957-9191" +"Association_sp_Fees_co_PAD_sp_Fee_sp_YN2": "N" +"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_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" +"EnergyGreen_sp_Feature_co_Energy_sp_Audit": true +"OperatingExpenseIncludes@Core.Permissions": "None" +"CoListAgentOfficePhoneExt@Core.Permissions": "None" +"Dining_sp_Area_co_Eat_hyphen_in_sp_Kitchen": true +"NumberOfFullTimeEmployees@Core.Permissions": "None" +"NumberOfPartTimeEmployees@Core.Permissions": "None" +"Unit_sp_Style_co_All_sp_on_sp_One_sp_Level": true +"Association_sp_Fees_co_Other_sp_Fees_sp_HOA": 100.0 +"DistanceToElectricComments@Core.Permissions": "None" +"General_sp_Property_sp_Description_co_Model": "Apple" +"ListAgentPreferredPhoneExt@Core.Permissions": "None" +"BuyerAgentPreferredPhoneExt@Core.Permissions": "None" +"General_sp_Property_sp_Description_co_Horses": "N" +"Landscaping_co_Yrd_sp_Wtring_sp_Sys_sp_Front": true +"Lockbox_sp_Type_co_See_sp_Private_sp_Remarks": true +"Assoc_sp_RulesInfo_co_VA_sp_Approved_sp_Prjct": true +"CoListAgentPreferredPhoneExt@Core.Permissions": "None" +"GreenEnergy_sp_Cert_co_Energy_sp_Star_sp_Cert": true +"Interior_sp_Features_co_9_sp_Flat_sp_Ceilings": true +"MiddleOrJuniorSchoolDistrict@Core.Permissions": "None" +"Assoc_sp_RulesInfo_co_FHA_sp_Approved_sp_Prjct": true +"Association_sp_Fees_co_HOA_sp_Transfer_sp_Fee2": 100.0 +"Community_sp_Features_co_BikingWalking_sp_Path": true +"Parking_sp_Spaces_co_Slab_sp_Parking_sp_Spaces": 2.0 +"ProfessionalManagementExpense@Core.Permissions": "None" +"Association_sp_Fees_co_HOA_sp_Paid_sp_Frequency": "Monthly" +"Contact_sp_Info_co_List_sp_Agent_sp_Home_sp_Phn": "480-771-8329" +"DistanceToPhoneServiceComments@Core.Permissions": "None" +"General_sp_Property_sp_Description_co_PriceSqFt": 219.14 +"Kitchen_sp_Features_co_Built_sp_In_sp_Recycling": true +"Kitchen_sp_Features_co_Walk_hyphen_in_sp_Pantry": true +"Master_sp_Bathroom_co_Private_sp_Toilet_sp_Room": true +"Parking_sp_Features_co_Garage_sp_Door_sp_Opener": true +"Parking_sp_Spaces_co_Total_sp_Covered_sp_Spaces": 3.0 +"Separate_sp_DenOffice_co_Sep_sp_DenOffice_sp_YN": "Y" +"TaxOtherAnnualAssessmentAmount@Core.Permissions": "None" +"Association_sp_Fees_co_Disclosure_sp_Fees_sp_HOA": 220.0 +"Location_sp_Tax_sp_Legal_co_Tax_sp_Municipality3": "Surprise" +"Association_sp_Fees_co_HOA_sp_Management_sp_Phone": "480-422-0888" +"Association_sp_Fees_co_Land_sp_Lease_sp_Fee_sp_YN": "N" +"Association_sp_Fees_co_Rec_sp_Center_sp_Fee_sp_YN": "N" +"Property_sp_Description_co_NorthSouth_sp_Exposure": true +"Const_sp__hyphen__sp_Finish_co_Low_sp_VOC_sp_Paint": true +"Construction_sp_Status_co_Complete_sp_Spec_sp_Home": true +"Master_sp_Bathroom_co_34_sp_Bath_sp_Master_sp_Bdrm": true +"Association_sp_Fees_co_HOA_sp_Management_sp_Company": "Trestle Management" +"Association_sp_Fees_co_Other_sp_Fees_sp_Description": "New Home Administration Fee" +"Association_sp_Fees_co_Special_sp_Assessment_sp_HOA": "No" +"Association_sp_Fees_co_Ttl_sp_Mthly_sp_Fee_sp_Equiv": 110.0 +"Cooling_co_ENERGY_sp_STAR_sp_Qualified_sp_Equipment": true +"General_sp_Property_sp_Description_co_Flood_sp_Zone": "No" +"Kitchen_sp_Features_co_Built_hyphen_in_sp_Microwave": true +"Existing_sp_1st_sp_Loan_co_Treat_sp_as_sp_FreeClear4": true +"General_sp_Property_sp_Description_co_Approx_sp_SQFT": 2236.0 +"General_sp_Property_sp_Description_co_High_sp_School": "Mountainside High School" +"Heating_co_ENERGY_sp_STAR_sp_Qualified_sp_Equipment2": true +"General_sp_Property_sp_Description_co_Builder_sp_Name": "Mattamy Homes" +"Kitchen_sp_Features_co_Non_hyphen_laminate_sp_Counter": true +"Association_sp_Fee_sp_Incl_co_Common_sp_Area_sp_Maint3": true +"Association_sp_Fees_co_Cap_sp_ImprovementImpact_sp_Fee": 220.0 +"Community_sp_Features_co_Children_squote_s_sp_Playgrnd": true +"General_sp_Property_sp_Description_co_Fireplace_sp_YN2": "No" +"GreenEngy_sp_Cert_sp_Year_co_GreenEngy_sp_Cert_sp_Year": 2024 +"General_sp_Property_sp_Description_co_Full_sp_Bathroom2": 2 +"General_sp_Property_sp_Description_co_Dwelling_sp_Styles": "Detached" +"General_sp_Property_sp_Description_co_Half_sp_Bathrooms2": 1 +"General_sp_Property_sp_Description_co_Marketing_sp_Name3": "Tierra Vistoso" +"Showing_sp_Notification_sp_Methods_co_Showing_sp_Service": "Non-MLS Showing Service - See Private Remarks" +"Architecture_co_Other_sp__lparen_See_sp_Remarks_rparen_11": true +"General_sp_Property_sp_Description_co_Elementary_sp_School": "Desert Oasis Elementary School" +"General_sp_Property_sp_Description_co_Jr_sp_High_sp_School": "Desert Oasis Elementary School" +"General_sp_Property_sp_Description_co_Approx_sp_Lot_sp_SqFt": 8190.0 +"Association_sp_Fees_co_Prepaid_sp_Association_sp_Fees_sp_HOA": 220.0 +"EnergyGreen_sp_Feature_co_ENERGY_sp_STAR_sp_Light_sp_Fixture": true +"General_sp_Property_sp_Description_co_Private_sp_Pool_sp_YN2": "No" +"Window_sp_Features_co_ENERGY_sp_STAR_sp_Qualified_sp_Windows": true +"General_sp_Property_sp_Description_co_Approx_sp_Lot_sp_Acres2": 0.188 +"General_sp_Property_sp_Description_co_Planned_sp_Comm_sp_Name": "Tierra Vistoso" +"General_sp_Property_sp_Description_co_Community_sp_Pool_sp_YN2": "No" +"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": 63.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": "Nadaburg Unified 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": 781.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": "Nadaburg Unified School District" +"General_sp_Property_sp_Description_co__pound__sp_of_sp_Interior_sp_Levels": 1 +"Location_sp_Tax_sp_Legal_co_Legal_sp_Description_sp__lparen_Abbrev_rparen_3": "LOT 72 TIERRA RICO PARCEL B MCR 162835" +"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('20260111194820183491000000')" +"provider_name": "ARMLS" +"SourceSystemPlatformID": "T00000052" +"SourceSystemPlatformName": "Flexmls" +"OriginatingSystemPlatformID": "T00000052" +"OriginatingSystemPlatformName": "Flexmls" +"Media": array:15 [ 0 => array:16 [ "Order" => 1 "MediaKey" => "20260130212100768592000000" "MediaURL" => "https://cdn.realtyfeed.com/cdn/54/20260111194820183491000000/bc9c9f8b3c1ac1de53aac39e2d0bc8e6.webp" "@odata.id" => "https://replication.sparkapi.com/Version/2/Reso/OData/Property('20260111194820183491000000')/Media('20260130212100768592000000')" "MediaHTML" => null "MediaSize" => 414517 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/54/20260111194820183491000000/thumbnail-bc9c9f8b3c1ac1de53aac39e2d0bc8e6.webp" "Permission" => array:1 [ 0 => "Public" ] "MediaCategory" => "Photo" "LongDescription" => "" "PreferredPhotoYN" => true "ResourceRecordID" => "20260111194820183491000000" "ShortDescription" => "2069" "ResourceRecordKey" => "20260111194820183491000000" "OriginatingSystemMediaKey" => "20260130212100768592000000" ] 1 => array:16 [ "Order" => 2 "MediaKey" => "20260130212100189858000000" "MediaURL" => "https://cdn.realtyfeed.com/cdn/54/20260111194820183491000000/6361b051268770add09ab8f4074fa34c.webp" "@odata.id" => "https://replication.sparkapi.com/Version/2/Reso/OData/Property('20260111194820183491000000')/Media('20260130212100189858000000')" "MediaHTML" => null "MediaSize" => 123396 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/54/20260111194820183491000000/thumbnail-6361b051268770add09ab8f4074fa34c.webp" "Permission" => array:1 [ 0 => "Public" ] "MediaCategory" => "Photo" "LongDescription" => "" "PreferredPhotoYN" => false "ResourceRecordID" => "20260111194820183491000000" "ShortDescription" => "PHX_Tierra Vistoso_Lot 2069_Apple_28788_" "ResourceRecordKey" => "20260111194820183491000000" "OriginatingSystemMediaKey" => "20260130212100189858000000" ] 2 => array:16 [ "Order" => 3 "MediaKey" => "20260130212101449396000000" "MediaURL" => "https://cdn.realtyfeed.com/cdn/54/20260111194820183491000000/13a599b3acd7d45169ce224c822d4edb.webp" "@odata.id" => "https://replication.sparkapi.com/Version/2/Reso/OData/Property('20260111194820183491000000')/Media('20260130212101449396000000')" "MediaHTML" => null "MediaSize" => 121969 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/54/20260111194820183491000000/thumbnail-13a599b3acd7d45169ce224c822d4edb.webp" "Permission" => array:1 [ 0 => "Public" ] "MediaCategory" => "Photo" "LongDescription" => "" "PreferredPhotoYN" => false "ResourceRecordID" => "20260111194820183491000000" "ShortDescription" => "PHX_Tierra Vistoso_Lot 2069_Apple_28788_" "ResourceRecordKey" => "20260111194820183491000000" "OriginatingSystemMediaKey" => "20260130212101449396000000" ] 3 => array:16 [ "Order" => 4 "MediaKey" => "20260130212101974175000000" "MediaURL" => "https://cdn.realtyfeed.com/cdn/54/20260111194820183491000000/6ffde22550f137445bf4f4ec37ad5c96.webp" "@odata.id" => "https://replication.sparkapi.com/Version/2/Reso/OData/Property('20260111194820183491000000')/Media('20260130212101974175000000')" "MediaHTML" => null "MediaSize" => 117566 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/54/20260111194820183491000000/thumbnail-6ffde22550f137445bf4f4ec37ad5c96.webp" "Permission" => array:1 [ 0 => "Public" ] "MediaCategory" => "Photo" "LongDescription" => "" "PreferredPhotoYN" => false "ResourceRecordID" => "20260111194820183491000000" "ShortDescription" => "PHX_Tierra Vistoso_Lot 2069_Apple_28788_" "ResourceRecordKey" => "20260111194820183491000000" "OriginatingSystemMediaKey" => "20260130212101974175000000" ] 4 => array:16 [ "Order" => 5 "MediaKey" => "20260130212102684509000000" "MediaURL" => "https://cdn.realtyfeed.com/cdn/54/20260111194820183491000000/f1728cc5b7aeaa25b061de35f7acaa91.webp" "@odata.id" => "https://replication.sparkapi.com/Version/2/Reso/OData/Property('20260111194820183491000000')/Media('20260130212102684509000000')" "MediaHTML" => null "MediaSize" => 138257 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/54/20260111194820183491000000/thumbnail-f1728cc5b7aeaa25b061de35f7acaa91.webp" "Permission" => array:1 [ 0 => "Public" ] "MediaCategory" => "Photo" "LongDescription" => "" "PreferredPhotoYN" => false "ResourceRecordID" => "20260111194820183491000000" "ShortDescription" => "PHX_Tierra Vistoso_Lot 2069_Apple_28788_" "ResourceRecordKey" => "20260111194820183491000000" "OriginatingSystemMediaKey" => "20260130212102684509000000" ] 5 => array:16 [ "Order" => 6 "MediaKey" => "20260130212103202777000000" "MediaURL" => "https://cdn.realtyfeed.com/cdn/54/20260111194820183491000000/880d0fdb872ee5c74e845325316d5501.webp" "@odata.id" => "https://replication.sparkapi.com/Version/2/Reso/OData/Property('20260111194820183491000000')/Media('20260130212103202777000000')" "MediaHTML" => null "MediaSize" => 149885 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/54/20260111194820183491000000/thumbnail-880d0fdb872ee5c74e845325316d5501.webp" "Permission" => array:1 [ 0 => "Public" ] "MediaCategory" => "Photo" "LongDescription" => "" "PreferredPhotoYN" => false "ResourceRecordID" => "20260111194820183491000000" "ShortDescription" => "PHX_Tierra Vistoso_Lot 2069_Apple_28788_" "ResourceRecordKey" => "20260111194820183491000000" "OriginatingSystemMediaKey" => "20260130212103202777000000" ] 6 => array:16 [ "Order" => 7 "MediaKey" => "20260130212103848171000000" "MediaURL" => "https://cdn.realtyfeed.com/cdn/54/20260111194820183491000000/5f48fd3aa10991468c838c67c02a93ac.webp" "@odata.id" => "https://replication.sparkapi.com/Version/2/Reso/OData/Property('20260111194820183491000000')/Media('20260130212103848171000000')" "MediaHTML" => null "MediaSize" => 156975 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/54/20260111194820183491000000/thumbnail-5f48fd3aa10991468c838c67c02a93ac.webp" "Permission" => array:1 [ 0 => "Public" ] "MediaCategory" => "Photo" "LongDescription" => "" "PreferredPhotoYN" => false "ResourceRecordID" => "20260111194820183491000000" "ShortDescription" => "PHX_Tierra Vistoso_Lot 2069_Apple_28788_" "ResourceRecordKey" => "20260111194820183491000000" "OriginatingSystemMediaKey" => "20260130212103848171000000" ] 7 => array:16 [ "Order" => 8 "MediaKey" => "20260130212105093607000000" "MediaURL" => "https://cdn.realtyfeed.com/cdn/54/20260111194820183491000000/54f3e0d685354c95568f92c3aef5edb0.webp" "@odata.id" => "https://replication.sparkapi.com/Version/2/Reso/OData/Property('20260111194820183491000000')/Media('20260130212105093607000000')" "MediaHTML" => null "MediaSize" => 154861 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/54/20260111194820183491000000/thumbnail-54f3e0d685354c95568f92c3aef5edb0.webp" "Permission" => array:1 [ 0 => "Public" ] "MediaCategory" => "Photo" "LongDescription" => "" "PreferredPhotoYN" => false "ResourceRecordID" => "20260111194820183491000000" "ShortDescription" => "PHX_Tierra Vistoso_Lot 2069_Apple_28788_" "ResourceRecordKey" => "20260111194820183491000000" "OriginatingSystemMediaKey" => "20260130212105093607000000" ] 8 => array:16 [ "Order" => 9 "MediaKey" => "20260130212104450635000000" "MediaURL" => "https://cdn.realtyfeed.com/cdn/54/20260111194820183491000000/703657363ea1b84ca3c8dfb89aa035b2.webp" "@odata.id" => "https://replication.sparkapi.com/Version/2/Reso/OData/Property('20260111194820183491000000')/Media('20260130212104450635000000')" "MediaHTML" => null "MediaSize" => 141120 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/54/20260111194820183491000000/thumbnail-703657363ea1b84ca3c8dfb89aa035b2.webp" "Permission" => array:1 [ 0 => "Public" ] "MediaCategory" => "Photo" "LongDescription" => "" "PreferredPhotoYN" => false "ResourceRecordID" => "20260111194820183491000000" "ShortDescription" => "PHX_Tierra Vistoso_Lot 2069_Apple_28788_" "ResourceRecordKey" => "20260111194820183491000000" "OriginatingSystemMediaKey" => "20260130212104450635000000" ] 9 => array:16 [ "Order" => 10 "MediaKey" => "20260130212106852343000000" "MediaURL" => "https://cdn.realtyfeed.com/cdn/54/20260111194820183491000000/407d3a43860dd1b27403aa56b5d8ddab.webp" "@odata.id" => "https://replication.sparkapi.com/Version/2/Reso/OData/Property('20260111194820183491000000')/Media('20260130212106852343000000')" "MediaHTML" => null "MediaSize" => 206723 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/54/20260111194820183491000000/thumbnail-407d3a43860dd1b27403aa56b5d8ddab.webp" "Permission" => array:1 [ 0 => "Public" ] "MediaCategory" => "Photo" "LongDescription" => "" "PreferredPhotoYN" => false "ResourceRecordID" => "20260111194820183491000000" "ShortDescription" => "PHX_Tierra Vistoso_Lot 2069_Apple_28788_" "ResourceRecordKey" => "20260111194820183491000000" "OriginatingSystemMediaKey" => "20260130212106852343000000" ] 10 => array:16 [ "Order" => 11 "MediaKey" => "20260130212106328890000000" "MediaURL" => "https://cdn.realtyfeed.com/cdn/54/20260111194820183491000000/9a66c3fe711e1f483bcdf74e92e2fbf2.webp" "@odata.id" => "https://replication.sparkapi.com/Version/2/Reso/OData/Property('20260111194820183491000000')/Media('20260130212106328890000000')" "MediaHTML" => null "MediaSize" => 206651 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/54/20260111194820183491000000/thumbnail-9a66c3fe711e1f483bcdf74e92e2fbf2.webp" "Permission" => array:1 [ 0 => "Public" ] "MediaCategory" => "Photo" "LongDescription" => "" "PreferredPhotoYN" => false "ResourceRecordID" => "20260111194820183491000000" "ShortDescription" => "PHX_Tierra Vistoso_Lot 2069_Apple_28788_" "ResourceRecordKey" => "20260111194820183491000000" "OriginatingSystemMediaKey" => "20260130212106328890000000" ] 11 => array:16 [ "Order" => 12 "MediaKey" => "20260130212105764261000000" "MediaURL" => "https://cdn.realtyfeed.com/cdn/54/20260111194820183491000000/dcd8fc4feabbd6a296f8fb92af682281.webp" "@odata.id" => "https://replication.sparkapi.com/Version/2/Reso/OData/Property('20260111194820183491000000')/Media('20260130212105764261000000')" "MediaHTML" => null "MediaSize" => 157583 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/54/20260111194820183491000000/thumbnail-dcd8fc4feabbd6a296f8fb92af682281.webp" "Permission" => array:1 [ 0 => "Public" ] "MediaCategory" => "Photo" "LongDescription" => "" "PreferredPhotoYN" => false "ResourceRecordID" => "20260111194820183491000000" "ShortDescription" => "PHX_Tierra Vistoso_Lot 2069_Apple_28788_" "ResourceRecordKey" => "20260111194820183491000000" "OriginatingSystemMediaKey" => "20260130212105764261000000" ] 12 => array:16 [ "Order" => 13 "MediaKey" => "20260130212059011403000000" "MediaURL" => "https://cdn.realtyfeed.com/cdn/54/20260111194820183491000000/88b845c67f14435efe062f000c4d0a01.webp" "@odata.id" => "https://replication.sparkapi.com/Version/2/Reso/OData/Property('20260111194820183491000000')/Media('20260130212059011403000000')" "MediaHTML" => null "MediaSize" => 170309 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/54/20260111194820183491000000/thumbnail-88b845c67f14435efe062f000c4d0a01.webp" "Permission" => array:1 [ 0 => "Public" ] "MediaCategory" => "Photo" "LongDescription" => "" "PreferredPhotoYN" => false "ResourceRecordID" => "20260111194820183491000000" "ShortDescription" => "PHX_Tierra Vistoso_Lot 2069_Apple_28788_" "ResourceRecordKey" => "20260111194820183491000000" "OriginatingSystemMediaKey" => "20260130212059011403000000" ] 13 => array:16 [ "Order" => 14 "MediaKey" => "20260130212058374781000000" "MediaURL" => "https://cdn.realtyfeed.com/cdn/54/20260111194820183491000000/9fa91b8f095878392ecd50d16c330365.webp" "@odata.id" => "https://replication.sparkapi.com/Version/2/Reso/OData/Property('20260111194820183491000000')/Media('20260130212058374781000000')" "MediaHTML" => null "MediaSize" => 120747 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/54/20260111194820183491000000/thumbnail-9fa91b8f095878392ecd50d16c330365.webp" "Permission" => array:1 [ 0 => "Public" ] "MediaCategory" => "Photo" "LongDescription" => "" "PreferredPhotoYN" => false "ResourceRecordID" => "20260111194820183491000000" "ShortDescription" => "PHX_Tierra Vistoso_Lot 2069_Apple_28788_" "ResourceRecordKey" => "20260111194820183491000000" "OriginatingSystemMediaKey" => "20260130212058374781000000" ] 14 => array:16 [ "Order" => 15 "MediaKey" => "20260130212059619641000000" "MediaURL" => "https://cdn.realtyfeed.com/cdn/54/20260111194820183491000000/08818d0fcad5c548ffe0268150244105.webp" "@odata.id" => "https://replication.sparkapi.com/Version/2/Reso/OData/Property('20260111194820183491000000')/Media('20260130212059619641000000')" "MediaHTML" => null "MediaSize" => 179002 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/54/20260111194820183491000000/thumbnail-08818d0fcad5c548ffe0268150244105.webp" "Permission" => array:1 [ 0 => "Public" ] "MediaCategory" => "Photo" "LongDescription" => "" "PreferredPhotoYN" => false "ResourceRecordID" => "20260111194820183491000000" "ShortDescription" => "PHX_Tierra Vistoso_Lot 2069_Apple_28788_" "ResourceRecordKey" => "20260111194820183491000000" "OriginatingSystemMediaKey" => "20260130212059619641000000" ] ] +"DaysOnMarket": 0 +"ID": "82275" }
28788 N 174TH Lane, Surprise, AZ 85387
Active
Complete Spec Home
28788 N 174TH Lane, Surprise, AZ 85387
28788 N 174TH Lane, Surprise, AZ 85387
Description
This gorgeous Desert Modern home is on an end, so only 1 neighbor, none behind you and open space on one side with a single level next to you, the entire community is single level. This 2200 + Has a beautify gourmet kitchen with tile back splash, mud set owners shower, 8′ interior doors throughout, soft water loop and gas stub at backyard. Come see this remarkable home plan.
Address
Open on Google Maps- Address 28788 N 174TH Lane
- City Surprise
- State/county AZ
- Zip/Postal Code 85387
- Country US
Details
Updated on May 24, 2026 at 6:13 pm- Property ID: 6977259
- Price: $489,999
- Land Area: 0.19 Acres
- Bedrooms: 3
- Bathrooms: 3
- Garages: 3.0
- Garage Size: x x
- Year Built: 2026
- Property Type: Single Family Residence, Residential
- Property Status: Active
- MLS#: 6977259
Additional details
- Listing Terms: Cash,Conventional,1031 Exchange,FHA,VA Loan
- Association Fee: 110.0
- Roof: Tile,Concrete
- Sewer: Public Sewer
- Cooling: Central Air,ENERGY STAR Qualified Equipment,Programmable Thmstat
- Heating: ENERGY STAR Qualified Equipment,Natural Gas
- Flooring: Carpet,Tile
- County: Maricopa
- Property Type: Residential
- Parking: Tandem Garage,Garage Door Opener,Direct Access
- Elementary School: Desert Oasis Elementary School
- Middle School: Desert Oasis Elementary School
- High School: Mountainside High School
- Community Features: Playground,Biking/Walking Path
- Architectural Style: Other
Mortgage Calculator
Monthly
- Down Payment
- Loan Amount
- Monthly Mortgage Payment
- Property Tax
- Home Insurance
- PMI