Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#19163 +post_id: "77935" +post_author: 1 +"ListingKey": "20260111200109029792000000" +"ListingId": "6971874" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Pending" +"ModificationTimestamp": "2026-05-07T16:17:04Z" +"RFModificationTimestamp": "2026-05-07T16:32:31Z" +"ListPrice": 549999.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 1 +"BedroomsTotal": 4.0 +"LotSizeArea": 7718.0 +"LivingArea": 2686.0 +"BuildingAreaTotal": 0 +"City": "Surprise" +"PostalCode": "85387" +"UnparsedAddress": "28810 N 174th Lane, Surprise, Arizona 85387" +"Coordinates": array:2 [ 0 => -112.438124 1 => 33.744112 ] +"Latitude": 33.744112 +"Longitude": -112.438124 +"YearBuilt": 2025 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Tisha Ferguson" +"ListOfficeName": "Mattamy Arizona, LLC" +"ListAgentMlsId": "tf142" +"ListOfficeMlsId": "mtmy01" +"OriginatingSystemName": "ARMLS" +"PublicRemarks": "The Currant Plan is over 2600 square feet of well used space. You have 4 Bedrooms and a flex room at the front of the home for work out room, library, den or office. What is unique is this home has so much storage and all the options that you could possibly want, Gourmet kitchen, 8' doors, garage service door, soft water loop and a gas stub so you can have a very entertaining backyard." +"Appliances": "Built-in Microwave,Dishwasher,Disposal,Gas Cooktop" +"ApprovalStatus": true +"ArchitecturalStyle": "Ranch" +"AssociationFee": "110.0" +"AssociationFeeFrequency": "Monthly" +"AssociationFeeIncludes": array:1 [ 0 => "Maintenance Grounds" ] +"AssociationName": "Tierra Vistoso HOA" +"AssociationPhone": "602-957-9191" +"AssociationYN": true +"BathroomsFull": 3 +"BedroomsPossible": 5 +"BuilderName": "Mattamy Homes" +"BuildingAreaSource": "Builder" +"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-21T16:07:29.430595+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-21T16:00:20Z" +"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-12" +"ListingTerms": "Cash,Conventional,1031 Exchange,FHA,VA Loan" +"LivingAreaSource": "Builder" +"LotFeatures": array:4 [ 0 => "North/South Exposure" 1 => "Sprinklers In Front" 2 => "Desert Front" 3 => "Dirt Back" ] +"LotSizeAcres": 0.18 +"LotSizeSource": "Builder" +"LotSizeSquareFeet": 7718.0 +"MajorChangeTimestamp": "2026-04-13T22:21:48Z" +"MajorChangeType": "Status Change" +"MiddleOrJuniorSchool": "Desert Oasis Elementary School" +"MlsStatus": "Pending" +"Model": "Currant" +"OffMarketDate": "2026-04-13" +"OpenParkingSpaces": "2.0" +"OriginalEntryTimestamp": "2026-01-21T16:00:20Z" +"OriginatingSystemID": "M00000048" +"OriginatingSystemKey": "20260111200109029792000000" +"Ownership": "Fee Simple" +"ParcelNumber": "503-63-782" +"ParkingFeatures": "Tandem Garage,Garage Door Opener,Direct Access" +"PhotosChangeTimestamp": "2026-01-30T21:24:45Z" +"PhotosCount": 16 +"Possession": array:1 [ 0 => "Close Of Escrow" ] +"PostalCity": "Surprise" +"PriceChangeTimestamp": "2026-03-31T22:31:50Z" +"PropertyCondition": array:1 [ 0 => "Complete Spec Home" ] +"PublicSurveyRange": "2W" +"PublicSurveySection": "26" +"PurchaseContractDate": "2026-04-11" +"Roof": "Tile,Concrete" +"Sewer": "Public Sewer" +"SourceSystemID": "M00000048" +"SourceSystemKey": "20260111200109029792000000" +"SourceSystemName": "Arizona Regional Multiple Listing Service (ARMLS)" +"SpaFeatures": array:1 [ 0 => "None" ] +"SpecialListingConditions": array:1 [ 0 => "N/A" ] +"StateOrProvince": "AZ" +"StatusChangeTimestamp": "2026-04-13T22:21:46Z" +"StoriesTotal": "1" +"StreetDirPrefix": "N" +"StreetName": "174th" +"StreetNumber": "28810" +"StreetNumberNumeric": "28810" +"StreetSuffix": "Lane" +"SubdivisionName": "Tierra Vistoso - 2070" +"TaxBookNumber": "503.00" +"TaxLegalDescription": "LOT 78 TIERRA RICO PARCEL B MCR 162835" +"TaxLot": "2070" +"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 +"Architecture_co_Ranch": 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": "Currant" +"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": 204.77 +"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 G" +"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": 2686.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": 3 +"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" +"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": 7718.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.177 +"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": 782.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 78 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('20260111200109029792000000')" +"provider_name": "ARMLS" +"SourceSystemPlatformID": "T00000052" +"SourceSystemPlatformName": "Flexmls" +"OriginatingSystemPlatformID": "T00000052" +"OriginatingSystemPlatformName": "Flexmls" +"Media": array:16 [ 0 => array:16 [ "Order" => 1 "MediaKey" => "20260130212406510022000000" "MediaURL" => "https://cdn.realtyfeed.com/cdn/54/20260111200109029792000000/7e833f132fc89744484098f80a0acb56.webp" "@odata.id" => "https://replication.sparkapi.com/Version/2/Reso/OData/Property('20260111200109029792000000')/Media('20260130212406510022000000')" "MediaHTML" => null "MediaSize" => 338094 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/54/20260111200109029792000000/thumbnail-7e833f132fc89744484098f80a0acb56.webp" "Permission" => array:1 [ 0 => "Public" ] "MediaCategory" => "Photo" "LongDescription" => "" "PreferredPhotoYN" => true "ResourceRecordID" => "20260111200109029792000000" "ShortDescription" => "2070" "ResourceRecordKey" => "20260111200109029792000000" "OriginatingSystemMediaKey" => "20260130212406510022000000" ] 1 => array:16 [ "Order" => 2 "MediaKey" => "20260130212407247562000000" "MediaURL" => "https://cdn.realtyfeed.com/cdn/54/20260111200109029792000000/e4e0f4f8e15374480881a8d1613d230b.webp" "@odata.id" => "https://replication.sparkapi.com/Version/2/Reso/OData/Property('20260111200109029792000000')/Media('20260130212407247562000000')" "MediaHTML" => null "MediaSize" => 133279 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/54/20260111200109029792000000/thumbnail-e4e0f4f8e15374480881a8d1613d230b.webp" "Permission" => array:1 [ 0 => "Public" ] "MediaCategory" => "Photo" "LongDescription" => "" "PreferredPhotoYN" => false "ResourceRecordID" => "20260111200109029792000000" "ShortDescription" => "PHX_Tierra Vistoso_Lot 2070_Currant_2881" "ResourceRecordKey" => "20260111200109029792000000" "OriginatingSystemMediaKey" => "20260130212407247562000000" ] 2 => array:16 [ "Order" => 3 "MediaKey" => "20260130212407894146000000" "MediaURL" => "https://cdn.realtyfeed.com/cdn/54/20260111200109029792000000/3fae5b12dc45159667dfd5aabc64b816.webp" "@odata.id" => "https://replication.sparkapi.com/Version/2/Reso/OData/Property('20260111200109029792000000')/Media('20260130212407894146000000')" "MediaHTML" => null "MediaSize" => 162385 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/54/20260111200109029792000000/thumbnail-3fae5b12dc45159667dfd5aabc64b816.webp" "Permission" => array:1 [ 0 => "Public" ] "MediaCategory" => "Photo" "LongDescription" => "" "PreferredPhotoYN" => false "ResourceRecordID" => "20260111200109029792000000" "ShortDescription" => "PHX_Tierra Vistoso_Lot 2070_Currant_2881" "ResourceRecordKey" => "20260111200109029792000000" "OriginatingSystemMediaKey" => "20260130212407894146000000" ] 3 => array:16 [ "Order" => 4 "MediaKey" => "20260130212411054569000000" "MediaURL" => "https://cdn.realtyfeed.com/cdn/54/20260111200109029792000000/d3f3a9f0b9f9f1268c74144b7be57fba.webp" "@odata.id" => "https://replication.sparkapi.com/Version/2/Reso/OData/Property('20260111200109029792000000')/Media('20260130212411054569000000')" "MediaHTML" => null "MediaSize" => 148526 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/54/20260111200109029792000000/thumbnail-d3f3a9f0b9f9f1268c74144b7be57fba.webp" "Permission" => array:1 [ 0 => "Public" ] "MediaCategory" => "Photo" "LongDescription" => "" "PreferredPhotoYN" => false "ResourceRecordID" => "20260111200109029792000000" "ShortDescription" => "PHX_Tierra Vistoso_Lot 2070_Currant_2881" "ResourceRecordKey" => "20260111200109029792000000" "OriginatingSystemMediaKey" => "20260130212411054569000000" ] 4 => array:16 [ "Order" => 5 "MediaKey" => "20260130212409262673000000" "MediaURL" => "https://cdn.realtyfeed.com/cdn/54/20260111200109029792000000/c47b10cfa58c03f65d04e56a97c9bdc6.webp" "@odata.id" => "https://replication.sparkapi.com/Version/2/Reso/OData/Property('20260111200109029792000000')/Media('20260130212409262673000000')" "MediaHTML" => null "MediaSize" => 150140 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/54/20260111200109029792000000/thumbnail-c47b10cfa58c03f65d04e56a97c9bdc6.webp" "Permission" => array:1 [ 0 => "Public" ] "MediaCategory" => "Photo" "LongDescription" => "" "PreferredPhotoYN" => false "ResourceRecordID" => "20260111200109029792000000" "ShortDescription" => "PHX_Tierra Vistoso_Lot 2070_Currant_2881" "ResourceRecordKey" => "20260111200109029792000000" "OriginatingSystemMediaKey" => "20260130212409262673000000" ] 5 => array:16 [ "Order" => 6 "MediaKey" => "20260130212408609505000000" "MediaURL" => "https://cdn.realtyfeed.com/cdn/54/20260111200109029792000000/0ea84a3e9cbb43e09ba2e9771f21a143.webp" "@odata.id" => "https://replication.sparkapi.com/Version/2/Reso/OData/Property('20260111200109029792000000')/Media('20260130212408609505000000')" "MediaHTML" => null "MediaSize" => 160379 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/54/20260111200109029792000000/thumbnail-0ea84a3e9cbb43e09ba2e9771f21a143.webp" "Permission" => array:1 [ 0 => "Public" ] "MediaCategory" => "Photo" "LongDescription" => "" "PreferredPhotoYN" => false "ResourceRecordID" => "20260111200109029792000000" "ShortDescription" => "PHX_Tierra Vistoso_Lot 2070_Currant_2881" "ResourceRecordKey" => "20260111200109029792000000" "OriginatingSystemMediaKey" => "20260130212408609505000000" ] 6 => array:16 [ "Order" => 7 "MediaKey" => "20260130212409830100000000" "MediaURL" => "https://cdn.realtyfeed.com/cdn/54/20260111200109029792000000/23e18700c27041083a9e467acf046c69.webp" "@odata.id" => "https://replication.sparkapi.com/Version/2/Reso/OData/Property('20260111200109029792000000')/Media('20260130212409830100000000')" "MediaHTML" => null "MediaSize" => 132653 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/54/20260111200109029792000000/thumbnail-23e18700c27041083a9e467acf046c69.webp" "Permission" => array:1 [ 0 => "Public" ] "MediaCategory" => "Photo" "LongDescription" => "" "PreferredPhotoYN" => false "ResourceRecordID" => "20260111200109029792000000" "ShortDescription" => "PHX_Tierra Vistoso_Lot 2070_Currant_2881" "ResourceRecordKey" => "20260111200109029792000000" "OriginatingSystemMediaKey" => "20260130212409830100000000" ] 7 => array:16 [ "Order" => 8 "MediaKey" => "20260130212410494977000000" "MediaURL" => "https://cdn.realtyfeed.com/cdn/54/20260111200109029792000000/7e4c01c1311e47b1c4658cce87badf58.webp" "@odata.id" => "https://replication.sparkapi.com/Version/2/Reso/OData/Property('20260111200109029792000000')/Media('20260130212410494977000000')" "MediaHTML" => null "MediaSize" => 138584 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/54/20260111200109029792000000/thumbnail-7e4c01c1311e47b1c4658cce87badf58.webp" "Permission" => array:1 [ 0 => "Public" ] "MediaCategory" => "Photo" "LongDescription" => "" "PreferredPhotoYN" => false "ResourceRecordID" => "20260111200109029792000000" "ShortDescription" => "PHX_Tierra Vistoso_Lot 2070_Currant_2881" "ResourceRecordKey" => "20260111200109029792000000" "OriginatingSystemMediaKey" => "20260130212410494977000000" ] 8 => array:16 [ "Order" => 9 "MediaKey" => "20260130212403347263000000" "MediaURL" => "https://cdn.realtyfeed.com/cdn/54/20260111200109029792000000/080d537dc03ce9aefa2b31945ca64d8a.webp" "@odata.id" => "https://replication.sparkapi.com/Version/2/Reso/OData/Property('20260111200109029792000000')/Media('20260130212403347263000000')" "MediaHTML" => null "MediaSize" => 106101 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/54/20260111200109029792000000/thumbnail-080d537dc03ce9aefa2b31945ca64d8a.webp" "Permission" => array:1 [ 0 => "Public" ] "MediaCategory" => "Photo" "LongDescription" => "" "PreferredPhotoYN" => false "ResourceRecordID" => "20260111200109029792000000" "ShortDescription" => "PHX_Tierra Vistoso_Lot 2070_Currant_2881" "ResourceRecordKey" => "20260111200109029792000000" "OriginatingSystemMediaKey" => "20260130212403347263000000" ] 9 => array:16 [ "Order" => 10 "MediaKey" => "20260130212403993875000000" "MediaURL" => "https://cdn.realtyfeed.com/cdn/54/20260111200109029792000000/991e9eec479b3654ed47ae0b262ebc3b.webp" "@odata.id" => "https://replication.sparkapi.com/Version/2/Reso/OData/Property('20260111200109029792000000')/Media('20260130212403993875000000')" "MediaHTML" => null "MediaSize" => 115212 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/54/20260111200109029792000000/thumbnail-991e9eec479b3654ed47ae0b262ebc3b.webp" "Permission" => array:1 [ 0 => "Public" ] "MediaCategory" => "Photo" "LongDescription" => "" "PreferredPhotoYN" => false "ResourceRecordID" => "20260111200109029792000000" "ShortDescription" => "PHX_Tierra Vistoso_Lot 2070_Currant_2881" "ResourceRecordKey" => "20260111200109029792000000" "OriginatingSystemMediaKey" => "20260130212403993875000000" ] 10 => array:16 [ "Order" => 11 "MediaKey" => "20260130212404652116000000" "MediaURL" => "https://cdn.realtyfeed.com/cdn/54/20260111200109029792000000/2ce693ed2808e33ea558dc4ea95d10aa.webp" "@odata.id" => "https://replication.sparkapi.com/Version/2/Reso/OData/Property('20260111200109029792000000')/Media('20260130212404652116000000')" "MediaHTML" => null "MediaSize" => 171340 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/54/20260111200109029792000000/thumbnail-2ce693ed2808e33ea558dc4ea95d10aa.webp" "Permission" => array:1 [ 0 => "Public" ] "MediaCategory" => "Photo" "LongDescription" => "" "PreferredPhotoYN" => false "ResourceRecordID" => "20260111200109029792000000" "ShortDescription" => "PHX_Tierra Vistoso_Lot 2070_Currant_2881" "ResourceRecordKey" => "20260111200109029792000000" "OriginatingSystemMediaKey" => "20260130212404652116000000" ] 11 => array:16 [ "Order" => 12 "MediaKey" => "20260130212405232647000000" "MediaURL" => "https://cdn.realtyfeed.com/cdn/54/20260111200109029792000000/7ac5d034828fbcdac41334ff1fcbfa29.webp" "@odata.id" => "https://replication.sparkapi.com/Version/2/Reso/OData/Property('20260111200109029792000000')/Media('20260130212405232647000000')" "MediaHTML" => null "MediaSize" => 159877 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/54/20260111200109029792000000/thumbnail-7ac5d034828fbcdac41334ff1fcbfa29.webp" "Permission" => array:1 [ 0 => "Public" ] "MediaCategory" => "Photo" "LongDescription" => "" "PreferredPhotoYN" => false "ResourceRecordID" => "20260111200109029792000000" "ShortDescription" => "PHX_Tierra Vistoso_Lot 2070_Currant_2881" "ResourceRecordKey" => "20260111200109029792000000" "OriginatingSystemMediaKey" => "20260130212405232647000000" ] 12 => array:16 [ "Order" => 13 "MediaKey" => "20260130212405842763000000" "MediaURL" => "https://cdn.realtyfeed.com/cdn/54/20260111200109029792000000/5faee05b0f1748968f27edfb2a2b0d6e.webp" "@odata.id" => "https://replication.sparkapi.com/Version/2/Reso/OData/Property('20260111200109029792000000')/Media('20260130212405842763000000')" "MediaHTML" => null "MediaSize" => 160084 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/54/20260111200109029792000000/thumbnail-5faee05b0f1748968f27edfb2a2b0d6e.webp" "Permission" => array:1 [ 0 => "Public" ] "MediaCategory" => "Photo" "LongDescription" => "" "PreferredPhotoYN" => false "ResourceRecordID" => "20260111200109029792000000" "ShortDescription" => "PHX_Tierra Vistoso_Lot 2070_Currant_2881" "ResourceRecordKey" => "20260111200109029792000000" "OriginatingSystemMediaKey" => "20260130212405842763000000" ] 13 => array:16 [ "Order" => 14 "MediaKey" => "20260130212412229271000000" "MediaURL" => "https://cdn.realtyfeed.com/cdn/54/20260111200109029792000000/e338848e519d73fedd0b2261c4154786.webp" "@odata.id" => "https://replication.sparkapi.com/Version/2/Reso/OData/Property('20260111200109029792000000')/Media('20260130212412229271000000')" "MediaHTML" => null "MediaSize" => 170893 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/54/20260111200109029792000000/thumbnail-e338848e519d73fedd0b2261c4154786.webp" "Permission" => array:1 [ 0 => "Public" ] "MediaCategory" => "Photo" "LongDescription" => "" "PreferredPhotoYN" => false "ResourceRecordID" => "20260111200109029792000000" "ShortDescription" => "PHX_Tierra Vistoso_Lot 2070_Currant_2881" "ResourceRecordKey" => "20260111200109029792000000" "OriginatingSystemMediaKey" => "20260130212412229271000000" ] 14 => array:16 [ "Order" => 15 "MediaKey" => "20260130212411619234000000" "MediaURL" => "https://cdn.realtyfeed.com/cdn/54/20260111200109029792000000/dba81bcc2ed7b1e6c16422309e078a6e.webp" "@odata.id" => "https://replication.sparkapi.com/Version/2/Reso/OData/Property('20260111200109029792000000')/Media('20260130212411619234000000')" "MediaHTML" => null "MediaSize" => 163665 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/54/20260111200109029792000000/thumbnail-dba81bcc2ed7b1e6c16422309e078a6e.webp" "Permission" => array:1 [ 0 => "Public" ] "MediaCategory" => "Photo" "LongDescription" => "" "PreferredPhotoYN" => false "ResourceRecordID" => "20260111200109029792000000" "ShortDescription" => "PHX_Tierra Vistoso_Lot 2070_Currant_2881" "ResourceRecordKey" => "20260111200109029792000000" "OriginatingSystemMediaKey" => "20260130212411619234000000" ] 15 => array:16 [ "Order" => 16 "MediaKey" => "20260130212412783632000000" "MediaURL" => "https://cdn.realtyfeed.com/cdn/54/20260111200109029792000000/844903e16486aaa8dcea606ac4a519f3.webp" "@odata.id" => "https://replication.sparkapi.com/Version/2/Reso/OData/Property('20260111200109029792000000')/Media('20260130212412783632000000')" "MediaHTML" => null "MediaSize" => 147903 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/54/20260111200109029792000000/thumbnail-844903e16486aaa8dcea606ac4a519f3.webp" "Permission" => array:1 [ 0 => "Public" ] "MediaCategory" => "Photo" "LongDescription" => "" "PreferredPhotoYN" => false "ResourceRecordID" => "20260111200109029792000000" "ShortDescription" => "PHX_Tierra Vistoso_Lot 2070_Currant_2881" "ResourceRecordKey" => "20260111200109029792000000" "OriginatingSystemMediaKey" => "20260130212412783632000000" ] ] +"DaysOnMarket": null +"ID": "77935" }
28810 N 174th Lane, Surprise, AZ 85387
Pending
Complete Spec Home
28810 N 174th Lane, Surprise, AZ 85387
28810 N 174th Lane, Surprise, AZ 85387
Description
The Currant Plan is over 2600 square feet of well used space. You have 4 Bedrooms and a flex room at the front of the home for work out room, library, den or office. What is unique is this home has so much storage and all the options that you could possibly want, Gourmet kitchen, 8′ doors, garage service door, soft water loop and a gas stub so you can have a very entertaining backyard.
Address
Open on Google Maps- Address 28810 N 174th Lane
- City Surprise
- State/county AZ
- Zip/Postal Code 85387
- Country US
Details
Updated on May 7, 2026 at 4:17 pm- Property ID: 6971874
- Price: $549,999
- Land Area: 0.18 Acres
- Bedrooms: 4
- Bathrooms: 4
- Garages: 3.0
- Garage Size: x x
- Year Built: 2025
- Property Type: Single Family Residence, Residential
- Property Status: Pending
- MLS#: 6971874
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: Ranch
Mortgage Calculator
Monthly
- Down Payment
- Loan Amount
- Monthly Mortgage Payment
- Property Tax
- Home Insurance
- PMI