{"Id":1389130,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST6647926","MLSAGENTID":"NST506099270","MLSOFFICEID":"NST25792","ADDRESS":"3824 174th Avenue NW","ACRES":0.41,"AGENTOWNER":true,"AUCTIONYN":false,"BASEMENT":"Finished,Full","BATHSTOTAL":2.0,"BEDROOMS":3,"CITY":"Andover","CONTINGENCY":"None","COUNTY":"Anoka","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Wood Siding","FORECLOSURE":"No","LASTPRICE":344900.0,"LASTPRICEDATE":"2025-10-11T12:20:03.407","LATITUDE":45.285951,"LENDEROWNED":"No","LISTDATE":"2025-01-31T06:00:00","LISTPRICE":334900.0,"LIVINGAREA":1742.0,"LONGITUDE":-93.363629,"MODIFICATIONTIMESTAMP":"2025-10-11T12:20:03.408","OFFICE_OFFICENAME":"eXp Realty","OUTBUILDINGS":"Storage Shed","PHOTOCOUNT":11,"POSTALCODE":"55304","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Charming home on a quiet street with a patio door to the large backyard, nice patio, 3 BRs on the main level & 2 dens/offices downstairs that could be additional bedrooms. Mechanic/hobbyist’s dream 3 car 700 sq ft garage. Freshly painted home with your choice of LL flooring & a brand new septic system features a 700 sq ft attached 3 car garage (tandem so appears only 2 door width) on a large lot in a neighborhood of higher priced homes with mostly acre lots. Price includes brand new septic system and at least 1 or 2 egress windows added to make the house a 4 bedroom or 5 bedroom house. Buyer can pick their choice of flooring for the LVP flooring that's missing. Rare opportunity for a house in a nice neighborhood with a bigger lot. Kitchen currently has a portable dishwasher. Buyer may choose new appliance package up to $4,000 for kitchen & laundry if buyer doesn’t like current working appliances. Flooring samples on site to choose new flooring for LL. FHA, VA or assistance programs welcome!","ROADBETWEENWATERFRONTANDHOMEYN":false,"SCHOOLDISTRICTNUMBER":"15-St. Francis","SCHOOLDISTRICTPHONE":"763-753-7040","SEWER":"Private Sewer","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2025-07-30T13:00:03.923","LASTSTATUS":"Active","STREETDIRSUFFIX":"NW","STREETNAME":"174th","STREETNUMBER":"3824","STREETSUFFIX":"Avenue","STYLE":"Single Family Residence","TRANSACTIONTYPE":"For Sale","WATER":"Well","WATERFRONTPRESENT":false,"YEARBUILT":1969,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2025-06-22T02:20:04.077","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"Image20250124170641.jpg\"},{\"Order\":2,\"Remarks\":\"Image20250124170633.jpg\"},{\"Order\":3,\"Remarks\":\"Image20250124170635.jpg\"},{\"Order\":4,\"Remarks\":\"Image20250124170630.jpg\"},{\"Order\":5,\"Remarks\":\"Image20250124170643.jpg\"},{\"Order\":6,\"Remarks\":\"Image20250124170645.jpg\"},{\"Order\":7,\"Remarks\":\"Image20250124170637.jpg\"},{\"Order\":8,\"Remarks\":\"Image20250124170640.jpg\"},{\"Order\":9,\"Remarks\":\"GIS Map 2.png\"},{\"Order\":10,\"Remarks\":\"GIS Map.png\"},{\"Order\":11,\"Remarks\":\"5021995725118091415.jpg\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11","SOURCE":"MG_NST"}
{"ListingKey":"NST7689116","LotSizeArea":"0.41","NST_AgeOfProperty":"56","NST_AgentOwner":"Yes","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"True","NST_AmenitiesUnit":"Kitchen Window,Washer/Dryer Hookup","NST_AssessmentPending":"No","AssociationYN":"False","AssociationFee":"0","PropertyAttachedYN":"False","NST_AttributionContact":"763-221-9397","NST_AttributionName":"Elizabeth Sibet","Basement":"Finished,Full","BasementYN":"True","NST_BathDesc":"3/4 Basement,Main Floor Full Bath","BathroomsOneQuarter":"0","BathroomsFull":"1","BathroomsHalf":"0","BathroomsThreeQuarter":"1","BathroomsTotalInteger":"2","BedroomsTotal":"3","City":"Andover","PropertyType":"Residential","NewConstructionYN":"False","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Anoka","NST_DPResource":"Y","DaysOnMarket":"248","CumulativeDaysOnMarket":"248","NST_DiningRoomDescription":"Informal Dining Room","Directions":"North on Round Lake Blvd NW, left on 173rd Ln NW, right on CR 58, left on 174th Ave NW, cross over Xenia St NW, second house on left","InternetAddressDisplayYN":"True","InternetEntireListingDisplayYN":"True","ConstructionMaterials":"Wood Siding","FireplaceYN":"False","FireplacesTotal":"0","NST_ForeclosureStatus":"No","FoundationArea":"1356","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","ParkingFeatures":"Attached Garage,Garage Door Opener,Tandem","NST_GarageSquareFeet":"700","AccessibilityFeatures":"None","Heating":"Forced Air","OriginalEntryTimestamp":"2025-01-31T23:32:09Z","LandLeaseYN":"False","NST_LastUpdateDate":"2025-10-11","Latitude":"45.285951","NST_LenderOwned":"No","ListAgentKey":"NST76612","ListAgentMlsId":"NST506099270","ListingContractDate":"2025-01-31T06:00:00Z","ListOfficeKey":"NST25792","ListOfficeName":"eXp Realty","ListOfficeMlsId":"NST25792","ListPrice":"334900","LivingArea":"1742","Longitude":"-93.363629","LotSizeDimensions":"100x180","LotSizeSquareFeet":"17859.6","LotSizeUnits":"Acres","ListingId":"NST6647926","SourceSystemName":"RMLS","NST_ManufacturedHome":"No","MapCoordinateSource":"King's Street Atlas","AdditionalParcelsYN":"False","NST_OfficeBoard":"SPAAR","OtherStructures":"Storage Shed","ParcelNumber":"053224330005","GarageSpaces":"3","PhotosCount":"11","PostalCity":"Andover","PostalCode":"55304","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PublicRemarks":"Charming home on a quiet street with a patio door to the large backyard, nice patio, 3 BRs on the main level & 2 dens/offices downstairs that could be additional bedrooms. Mechanic/hobbyist’s dream 3 car 700 sq ft garage. Freshly painted home with your choice of LL flooring & a brand new septic system features a 700 sq ft attached 3 car garage (tandem so appears only 2 door width) on a large lot in a neighborhood of higher priced homes with mostly acre lots. Price includes brand new septic system and at least 1 or 2 egress windows added to make the house a 4 bedroom or 5 bedroom house. Buyer can pick their choice of flooring for the LVP flooring that's missing. Rare opportunity for a house in a nice neighborhood with a bigger lot. Kitchen currently has a portable dishwasher. Buyer may choose new appliance package up to $4,000 for kitchen & laundry if buyer doesn’t like current working appliances. Flooring samples on site to choose new flooring for LL. FHA, VA or assistance programs welcome!","PublicSurveyRange":"24","PublicSurveySection":"05","PublicSurveyTownship":"32","NST_RentalLicenseYN":"No","NST_AboveGradeSqFtTotal":"1176.0000","NST_BelowGradeSqFtTotal":"1176.0000","NST_MainLevelFinishedArea":"1356.0000","BuildingAreaTotal":"2352","HighSchoolDistrict":"St. Francis","NST_SchoolDistrictNumber":"15","NST_SchoolDistrictPhone":"763-753-7040","Sewer":"Private Sewer","NST_SpecialSearch":"3 BR on One Level,Main Floor Bedroom,Rehabbed,Renovated","AboveGradeFinishedArea":"1176","BelowGradeFinishedArea":"566","StateOrProvince":"MN","StandardStatus":"Active","Levels":"One","StreetDirSuffix":"NW","StreetName":"174th","StreetNumber":"3824","StreetNumberNumeric":"3824","StreetSuffix":"Avenue","PropertySubType":"Single Family Residence","SubdivisionName":"Cedar Crest Estates","NST_TaxWithAssessments":"2794.0000","TaxYear":"2024","TaxAnnualAmount":"2794","WaterSource":"Well","YearBuilt":"1969","ZoningDescription":"Residential-Single Family","ModificationTimestamp":"2025-10-11T12:20:03.408Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7689116\",\"Order\":1,\"MediaObjectID\":\"1\",\"LongDescription\":\"Image20250124170641.jpg\",\"ImageWidth\":1024,\"ImageHeight\":768,\"ImageSizeDescription\":\"1024x768\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7689116/0b1eda6d-dbf1-4bdd-9ccb-4ca7490a5b25.jpeg\",\"MediaModificationTimestamp\":\"2025-06-22T02:19:24.222Z\",\"MediaKey\":\"6857682ce3da881c518f643f\"},{\"ResourceRecordKey\":\"NST7689116\",\"Order\":2,\"MediaObjectID\":\"2\",\"LongDescription\":\"Image20250124170633.jpg\",\"ImageWidth\":800,\"ImageHeight\":600,\"ImageSizeDescription\":\"800x600\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7689116/01a5e62b-72b1-4718-8d47-ecaa4f00c294.jpeg\",\"MediaModificationTimestamp\":\"2025-06-22T02:19:24.215Z\",\"MediaKey\":\"6857682ce3da881c518f6440\"},{\"ResourceRecordKey\":\"NST7689116\",\"Order\":3,\"MediaObjectID\":\"3\",\"LongDescription\":\"Image20250124170635.jpg\",\"ImageWidth\":600,\"ImageHeight\":800,\"ImageSizeDescription\":\"600x800\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7689116/5ebc870b-691b-42ee-b3a8-e0f1645cec30.jpeg\",\"MediaModificationTimestamp\":\"2025-06-22T02:19:24.231Z\",\"MediaKey\":\"6857682ce3da881c518f6441\"},{\"ResourceRecordKey\":\"NST7689116\",\"Order\":4,\"MediaObjectID\":\"4\",\"LongDescription\":\"Image20250124170630.jpg\",\"ImageWidth\":1024,\"ImageHeight\":768,\"ImageSizeDescription\":\"1024x768\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7689116/704d94b5-44ee-4b0d-bb77-9415d4ccc625.jpeg\",\"MediaModificationTimestamp\":\"2025-06-22T02:19:24.217Z\",\"MediaKey\":\"6857682ce3da881c518f6442\"},{\"ResourceRecordKey\":\"NST7689116\",\"Order\":5,\"MediaObjectID\":\"5\",\"LongDescription\":\"Image20250124170643.jpg\",\"ImageWidth\":768,\"ImageHeight\":1024,\"ImageSizeDescription\":\"768x1024\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7689116/7932ec89-1073-430b-985c-e662267ab763.jpeg\",\"MediaModificationTimestamp\":\"2025-06-22T02:19:24.216Z\",\"MediaKey\":\"6857682ce3da881c518f6443\"},{\"ResourceRecordKey\":\"NST7689116\",\"Order\":6,\"MediaObjectID\":\"6\",\"LongDescription\":\"Image20250124170645.jpg\",\"ImageWidth\":768,\"ImageHeight\":1024,\"ImageSizeDescription\":\"768x1024\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7689116/64ffcd3a-23ce-4029-83a2-17d67bd92c92.jpeg\",\"MediaModificationTimestamp\":\"2025-06-22T02:19:24.196Z\",\"MediaKey\":\"6857682ce3da881c518f6444\"},{\"ResourceRecordKey\":\"NST7689116\",\"Order\":7,\"MediaObjectID\":\"7\",\"LongDescription\":\"Image20250124170637.jpg\",\"ImageWidth\":768,\"ImageHeight\":1024,\"ImageSizeDescription\":\"768x1024\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7689116/9069dc2e-a226-4193-b49a-a181897dcbd4.jpeg\",\"MediaModificationTimestamp\":\"2025-06-22T02:19:24.21Z\",\"MediaKey\":\"6857682ce3da881c518f6445\"},{\"ResourceRecordKey\":\"NST7689116\",\"Order\":8,\"MediaObjectID\":\"8\",\"LongDescription\":\"Image20250124170640.jpg\",\"ImageWidth\":600,\"ImageHeight\":800,\"ImageSizeDescription\":\"600x800\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7689116/b189b7a2-f666-480b-beeb-a20346a29edc.jpeg\",\"MediaModificationTimestamp\":\"2025-06-22T02:19:24.203Z\",\"MediaKey\":\"6857682ce3da881c518f6446\"},{\"ResourceRecordKey\":\"NST7689116\",\"Order\":9,\"MediaObjectID\":\"9\",\"LongDescription\":\"GIS Map 2.png\",\"ImageWidth\":696,\"ImageHeight\":500,\"ImageSizeDescription\":\"696x500\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7689116/9a9b86b6-d7e4-467a-9c56-707c9baecb6d.png\",\"MediaModificationTimestamp\":\"2025-01-31T23:33:11.796Z\",\"MediaKey\":\"679d5db74057a83044d0f64b\"},{\"ResourceRecordKey\":\"NST7689116\",\"Order\":10,\"MediaObjectID\":\"10\",\"LongDescription\":\"GIS Map.png\",\"ImageWidth\":682,\"ImageHeight\":455,\"ImageSizeDescription\":\"682x455\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7689116/bc943181-5b6b-49a6-84cb-3f622b9767ed.png\",\"MediaModificationTimestamp\":\"2025-01-31T23:33:11.815Z\",\"MediaKey\":\"679d5db74057a83044d0f64c\"},{\"ResourceRecordKey\":\"NST7689116\",\"Order\":11,\"MediaObjectID\":\"11\",\"LongDescription\":\"5021995725118091415.jpg\",\"ImageWidth\":960,\"ImageHeight\":1280,\"ImageSizeDescription\":\"960x1280\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7689116/2ee71111-16a1-41b9-af59-2e3c9ef3793e.jpeg\",\"MediaModificationTimestamp\":\"2025-06-22T02:19:24.247Z\",\"MediaKey\":\"6857682ce3da881c518f6447\"}]","PhotosChangeTimestamp":"2025-06-22T02:20:04.077Z","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"Image20250124170641.jpg\"},{\"Order\":2,\"Remarks\":\"Image20250124170633.jpg\"},{\"Order\":3,\"Remarks\":\"Image20250124170635.jpg\"},{\"Order\":4,\"Remarks\":\"Image20250124170630.jpg\"},{\"Order\":5,\"Remarks\":\"Image20250124170643.jpg\"},{\"Order\":6,\"Remarks\":\"Image20250124170645.jpg\"},{\"Order\":7,\"Remarks\":\"Image20250124170637.jpg\"},{\"Order\":8,\"Remarks\":\"Image20250124170640.jpg\"},{\"Order\":9,\"Remarks\":\"GIS Map 2.png\"},{\"Order\":10,\"Remarks\":\"GIS Map.png\"},{\"Order\":11,\"Remarks\":\"5021995725118091415.jpg\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11","CustomVTourURL":""}