{"Id":561900,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST7073006","MLSAGENTID":"NST502045564","MLSOFFICEID":"NST251939","ADDRESS":"15725 Sycamore Street NW","ACRES":2.18,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Block","BATHSTOTAL":3.0,"BEDROOMS":4.0,"CITY":"Andover","CONTINGENCY":"None","COUNTY":"Anoka","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Frame","FORECLOSURE":"No","LASTPRICE":449900.0,"LASTPRICEDATE":"2026-06-10T01:46:06.69","LATITUDE":45.25553235,"LENDEROWNED":"No","LISTDATE":"2026-05-16T05:00:00","LISTPRICE":445900.0,"LIVINGAREA":2562.0,"LONGITUDE":-93.28834688,"LOTDESCRIPTION":"Tree Coverage - Heavy","MODIFICATIONTIMESTAMP":"2026-06-10T01:46:06.69","OFFICE_OFFICENAME":"Ashworth Real Estate","PHOTOCOUNT":19,"POSTALCODE":"55304","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Back on market. Inspection was done, items that concerned buyers are minor and common. Will be taken care of. Call for details. New Septic added May 2026. 5 bedroom/3 bath home on large 2.5 acre lot in Andover. Open concept Kitchen/living room is great for entertaining. Large Primary Bedroom with 3/4 bath. 2 other bedrooms on main level. Lower level has 2 more bedrooms, full bath and a kitchen is perfect Mother In Law Suite. If you are looking for privacy this is it. Right in the middle of city but you would never know it.","ROADBETWEENWATERFRONTANDHOMEYN":false,"SCHOOLDISTRICTNUMBER":"11-Anoka-Hennepin","SCHOOLDISTRICTPHONE":"7635061000","SEWER":"Septic System Compliant - Yes","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2026-05-23T00:00:07.45","LASTSTATUS":"Active","STREETDIRSUFFIX":"NW","STREETNAME":"Sycamore","STREETNUMBER":"15725","STREETSUFFIX":"Street","STYLE":"Single Family","TRANSACTIONTYPE":"For","WATER":"Private","WATERFRONTPRESENT":false,"YEARBUILT":1978,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2026-05-23T21:11:06.833","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"Open Concept Kitchen\"},{\"Order\":2,\"Remarks\":\"Updated Kitchen and beautiful wood floors\"},{\"Order\":3,\"Remarks\":\"Dining Room\"},{\"Order\":4,\"Remarks\":\"Living Room\"},{\"Order\":5,\"Remarks\":\"Main Floor Full Bath\"},{\"Order\":6,\"Remarks\":\"Primary Bedroom\"},{\"Order\":7,\"Remarks\":\"Primary 3/4 bath\"},{\"Order\":8,\"Remarks\":\"Bedroom\"},{\"Order\":9,\"Remarks\":\"2nd Full Kitchen, can be used as MIL suite\"},{\"Order\":10,\"Remarks\":\"Lower Level Family Room\"},{\"Order\":11,\"Remarks\":\"Bedroom\"},{\"Order\":12,\"Remarks\":\"Lower Bedroom w/walk in closet\"},{\"Order\":13,\"Remarks\":\"Lower Level Bedroom\"},{\"Order\":17,\"Remarks\":\"Over 2 acres of privacy\"},{\"Order\":18,\"Remarks\":\"Nice Fire Pit out back\"},{\"Order\":19,\"Remarks\":\"Nice shed for extra storage! Or was used for the chickens.\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19","SOURCE":"MG_NST"}
{"ListingKey":"NST7900740","NST_AboveGradeSqFtTotal":"1456","AboveGradeFinishedArea":"1456","AccessibilityFeatures":"None","AdditionalParcelsYN":"False","NST_AgentOwner":"No","LivingAreaUnits":"Square Feet","NST_AssessmentPending":"Unknown","AssociationYN":"False","AssociationFee":"0","Basement":"Block","BasementYN":"True","NST_BathDesc":"3/4 Primary,Full Basement,Upper Level Full Bath","BathroomsFull":"2","BathroomsHalf":"0","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"1","BathroomsTotalInteger":"3","BedroomsTotal":"4","NST_BelowGradeSqFtTotal":"1456","BelowGradeFinishedArea":"1106","CumulativeDaysOnMarket":"1","City":"Andover","ConstructionMaterials":"Frame","NewConstructionYN":"False","Contingency":"None","NST_ForSaleOrLease":"For Sale","Cooling":"Central Air","CountyOrParish":"Anoka","CultivatedArea":"0","NST_DPResource":"Yes","NST_DiningRoomDescription":"Eat In Kitchen,Kitchen/Dining Room","Directions":"Hansen Blvd. N. to Crosstown(18)or 161st. to Sycamore L to home --behind trees on right-3rd lot N.","DocumentsCount":"2","DocumentsChangeTimestamp":"2026-06-05T15:05:10.103Z","DaysOnMarket":"1","ExteriorFeatures":"Stucco","Fencing":"None","FireplaceFeatures":"Wood Burning","FireplaceYN":"True","FireplacesTotal":"2","FoundationArea":"1456","FoundationDetails":"Block","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","NST_GarageSquareFeet":"520","NST_GarageDimensions":"23x23","GarageSpaces":"2","Heating":"Forced Air","HighSchoolDistrict":"Anoka-Hennepin","NST_ForeclosureStatus":"No","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"False","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","Latitude":"45.2555323452","LaundryFeatures":"Lower Level","NST_LenderOwned":"No","Levels":"Split Entry (Bi-Level)","ListPrice":"445900","ListingContractDate":"2026-05-16T05:00:00Z","ListingId":"NST7073006","LivingArea":"2562","LockBoxType":"Combo","Longitude":"-93.2883468806","LotFeatures":"Tree Coverage - Heavy","LotSizeArea":"2.18","LotSizeDimensions":"185x359","LotSizeUnits":"Acres","NST_MainLevelFinishedArea":"1456","NST_ManufacturedHome":"N","OriginalEntryTimestamp":"2026-05-16T08:42:23Z","ParcelNumber":"143224440016","ParkingFeatures":"Attached Garage","PastureArea":"0","NST_PatioPorchType":"Deck","PhotosCount":"19","PhotosChangeTimestamp":"2026-05-23T21:11:06.833Z","PostalCity":"Andover","PostalCode":"55304","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PropertyAttachedYN":"False","PropertySubType":"Single Family","PropertyType":"Residential","PublicRemarks":"Back on market. Inspection was done, items that concerned buyers are minor and common. Will be taken care of. Call for details. New Septic added May 2026. 5 bedroom/3 bath home on large 2.5 acre lot in Andover. Open concept Kitchen/living room is great for entertaining. Large Primary Bedroom with 3/4 bath. 2 other bedrooms on main level. Lower level has 2 more bedrooms, full bath and a kitchen is perfect Mother In Law Suite. If you are looking for privacy this is it. Right in the middle of city but you would never know it.","NST_SchoolDistrictFullName":"11 - Anoka-Hennepin","NST_SchoolDistrictNumber":"11","NST_SchoolDistrictPhone":"7635061000","Sewer":"Septic System Compliant - Yes","StandardStatus":"Active","StateOrProvince":"MN","StreetDirSuffix":"NW","StreetName":"Sycamore","StreetNumber":"15725","StreetNumberNumeric":"15725","StreetSuffix":"Street","TaxAnnualAmount":"4437.86","NST_TaxWithAssessments":"4437.86","TaxYear":"2026","NST_TotalArea":"2912","BuildingAreaTotal":"2912","Township":"Andover","VideosCount":"0","WaterSource":"Private","WaterfrontYN":"False","WoodedArea":"2.18","YearBuilt":"1978","ZoningDescription":"Residential-Single Family","ListAgentKey":"NST104892","ListAgentMlsId":"NST502045564","ListOfficeMlsId":"NST251939","ListOfficeName":"Ashworth Real Estate","ListOfficeKey":"NST1000694","ModificationTimestamp":"2026-06-10T01:46:06.69Z","OriginatingSystemName":"northstar","Media":"[{\"Order\":7,\"MediaObjectID\":\"NST7\",\"LongDescription\":\"Primary 3/4 bath\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7900740/765f1995-45b8-4bce-9f0f-c9fa473302d0.jpeg\",\"ResourceRecordKey\":\"NST7900740\",\"ImageWidth\":1566,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1566x2080\",\"MediaModificationTimestamp\":\"2026-05-23T21:10:11.023Z\",\"MediaKey\":\"NST122454250\"},{\"Order\":6,\"MediaObjectID\":\"NST6\",\"LongDescription\":\"Primary Bedroom\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7900740/dd370c8e-157e-4b93-b461-d93c14e5ea0b.jpeg\",\"ResourceRecordKey\":\"NST7900740\",\"ImageWidth\":2080,\"ImageHeight\":1566,\"ImageSizeDescription\":\"2080x1566\",\"MediaModificationTimestamp\":\"2026-05-23T21:10:11.023Z\",\"MediaKey\":\"NST122454249\"},{\"Order\":1,\"MediaObjectID\":\"NST1\",\"LongDescription\":\"Open Concept Kitchen\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7900740/cce1c1e5-a80a-4c0b-a559-31fb013564bf.jpeg\",\"ResourceRecordKey\":\"NST7900740\",\"ImageWidth\":2080,\"ImageHeight\":1566,\"ImageSizeDescription\":\"2080x1566\",\"MediaModificationTimestamp\":\"2026-05-23T21:10:11.05Z\",\"MediaKey\":\"NST122454245\"},{\"Order\":5,\"MediaObjectID\":\"NST5\",\"LongDescription\":\"Main Floor Full Bath\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7900740/8982dfd3-e802-4156-9ace-c654cf2de5c9.jpeg\",\"ResourceRecordKey\":\"NST7900740\",\"ImageWidth\":1566,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1566x2080\",\"MediaModificationTimestamp\":\"2026-05-23T21:10:10.996Z\",\"MediaKey\":\"NST122454251\"},{\"Order\":15,\"MediaObjectID\":\"NST15\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7900740/06f70097-8b16-4db4-aabe-b42e2e31523a.jpeg\",\"ResourceRecordKey\":\"NST7900740\",\"ImageWidth\":2080,\"ImageHeight\":1566,\"ImageSizeDescription\":\"2080x1566\",\"MediaModificationTimestamp\":\"2026-05-23T21:10:11.023Z\",\"MediaKey\":\"NST122454259\"},{\"Order\":13,\"MediaObjectID\":\"NST13\",\"LongDescription\":\"Lower Level Bedroom\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7900740/9915a348-904a-4b83-bdb7-7c7f4b232e18.jpeg\",\"ResourceRecordKey\":\"NST7900740\",\"ImageWidth\":2080,\"ImageHeight\":1566,\"ImageSizeDescription\":\"2080x1566\",\"MediaModificationTimestamp\":\"2026-05-23T21:10:11.023Z\",\"MediaKey\":\"NST122454240\"},{\"Order\":14,\"MediaObjectID\":\"NST14\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7900740/c6e52ee4-ace9-4a5a-983b-05dd02bf1d51.jpeg\",\"ResourceRecordKey\":\"NST7900740\",\"ImageWidth\":2080,\"ImageHeight\":1566,\"ImageSizeDescription\":\"2080x1566\",\"MediaModificationTimestamp\":\"2026-05-23T21:10:11.057Z\",\"MediaKey\":\"NST122454258\"},{\"Order\":11,\"MediaObjectID\":\"NST11\",\"LongDescription\":\"Bedroom\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7900740/41a31ffd-6c61-4fbb-94bb-4fffbbae4af9.jpeg\",\"ResourceRecordKey\":\"NST7900740\",\"ImageWidth\":2080,\"ImageHeight\":1566,\"ImageSizeDescription\":\"2080x1566\",\"MediaModificationTimestamp\":\"2026-05-23T21:10:11.023Z\",\"MediaKey\":\"NST122454242\"},{\"Order\":10,\"MediaObjectID\":\"NST10\",\"LongDescription\":\"Lower Level Family Room\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7900740/43acb839-5f85-4b56-88f8-058025bf8a84.jpeg\",\"ResourceRecordKey\":\"NST7900740\",\"ImageWidth\":2080,\"ImageHeight\":1170,\"ImageSizeDescription\":\"2080x1170\",\"MediaModificationTimestamp\":\"2026-05-23T21:10:11.023Z\",\"MediaKey\":\"NST122454243\"},{\"Order\":2,\"MediaObjectID\":\"NST2\",\"LongDescription\":\"Updated Kitchen and beautiful wood floors\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7900740/501e3c8c-5c8b-4588-bed6-8d996fcf31a4.jpeg\",\"ResourceRecordKey\":\"NST7900740\",\"ImageWidth\":2080,\"ImageHeight\":1566,\"ImageSizeDescription\":\"2080x1566\",\"MediaModificationTimestamp\":\"2026-05-23T21:10:11.106Z\",\"MediaKey\":\"NST122454253\"},{\"Order\":9,\"MediaObjectID\":\"NST9\",\"LongDescription\":\"2nd Full Kitchen, can be used as MIL suite\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7900740/ee11c593-2c88-4a5e-9ccb-8fd930f80623.jpeg\",\"ResourceRecordKey\":\"NST7900740\",\"ImageWidth\":2080,\"ImageHeight\":1566,\"ImageSizeDescription\":\"2080x1566\",\"MediaModificationTimestamp\":\"2026-05-23T21:10:11.023Z\",\"MediaKey\":\"NST122454244\"},{\"Order\":12,\"MediaObjectID\":\"NST12\",\"LongDescription\":\"Lower Bedroom w/walk in closet\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7900740/331caeed-37e9-4112-a59a-f2caa4ec99ed.jpeg\",\"ResourceRecordKey\":\"NST7900740\",\"ImageWidth\":2080,\"ImageHeight\":1566,\"ImageSizeDescription\":\"2080x1566\",\"MediaModificationTimestamp\":\"2026-05-23T21:10:11.06Z\",\"MediaKey\":\"NST122454241\"},{\"Order\":3,\"MediaObjectID\":\"NST3\",\"LongDescription\":\"Dining Room\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7900740/f356ff3b-ae27-4068-b97b-74a14a9aef78.jpeg\",\"ResourceRecordKey\":\"NST7900740\",\"ImageWidth\":2080,\"ImageHeight\":1566,\"ImageSizeDescription\":\"2080x1566\",\"MediaModificationTimestamp\":\"2026-05-23T21:10:11.023Z\",\"MediaKey\":\"NST122454252\"},{\"Order\":19,\"MediaObjectID\":\"NST19\",\"LongDescription\":\"Nice shed for extra storage! Or was used for the chickens.\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7900740/72b71afb-d2c1-40ec-a6fe-61a584345f28.jpeg\",\"ResourceRecordKey\":\"NST7900740\",\"ImageWidth\":2080,\"ImageHeight\":1566,\"ImageSizeDescription\":\"2080x1566\",\"MediaModificationTimestamp\":\"2026-05-23T21:10:11.049Z\",\"MediaKey\":\"NST122454254\"},{\"Order\":18,\"MediaObjectID\":\"NST18\",\"LongDescription\":\"Nice Fire Pit out back\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7900740/17b18e18-9efc-40f0-b240-a8852d05a097.jpeg\",\"ResourceRecordKey\":\"NST7900740\",\"ImageWidth\":2080,\"ImageHeight\":1566,\"ImageSizeDescription\":\"2080x1566\",\"MediaModificationTimestamp\":\"2026-05-23T21:10:11.105Z\",\"MediaKey\":\"NST122454255\"},{\"Order\":17,\"MediaObjectID\":\"NST17\",\"LongDescription\":\"Over 2 acres of privacy\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7900740/59bc3cc9-95d8-4111-9580-faddbbe03d48.jpeg\",\"ResourceRecordKey\":\"NST7900740\",\"ImageWidth\":2080,\"ImageHeight\":1566,\"ImageSizeDescription\":\"2080x1566\",\"MediaModificationTimestamp\":\"2026-05-23T21:10:11.065Z\",\"MediaKey\":\"NST122454256\"},{\"Order\":4,\"MediaObjectID\":\"NST4\",\"LongDescription\":\"Living Room\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7900740/6313c6df-688d-4b01-823b-b968081ae66d.jpeg\",\"ResourceRecordKey\":\"NST7900740\",\"ImageWidth\":2080,\"ImageHeight\":1566,\"ImageSizeDescription\":\"2080x1566\",\"MediaModificationTimestamp\":\"2026-05-23T21:10:11.089Z\",\"MediaKey\":\"NST122454246\"},{\"Order\":16,\"MediaObjectID\":\"NST16\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7900740/5b42419f-e1f6-411f-9bc2-5b9303ad6314.jpeg\",\"ResourceRecordKey\":\"NST7900740\",\"ImageWidth\":2080,\"ImageHeight\":1566,\"ImageSizeDescription\":\"2080x1566\",\"MediaModificationTimestamp\":\"2026-05-23T21:10:11.111Z\",\"MediaKey\":\"NST122454257\"},{\"Order\":8,\"MediaObjectID\":\"NST8\",\"LongDescription\":\"Bedroom\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7900740/a4a063d8-cbc2-41c3-bd2c-3f1f0e2439db.jpeg\",\"ResourceRecordKey\":\"NST7900740\",\"ImageWidth\":2080,\"ImageHeight\":1566,\"ImageSizeDescription\":\"2080x1566\",\"MediaModificationTimestamp\":\"2026-05-23T21:10:11.102Z\",\"MediaKey\":\"NST122454247\"}]","Media__Order":"7","Media__MediaObjectID":"NST7","Media__LongDescription":"Primary 3/4 bath","Media__MediaURL":"https://s3.amazonaws.com/mlsgrid/images/NST7900740/765f1995-45b8-4bce-9f0f-c9fa473302d0.jpeg","Media__ResourceRecordKey":"NST7900740","Media__ImageWidth":"1566","Media__ImageHeight":"2080","Media__ImageSizeDescription":"1566x2080","Media__MediaModificationTimestamp":"5/23/2026 9:10:11 PM","Media__MediaKey":"NST122454250","Rooms":"[{\"NST_RoomSortOrder\":2,\"RoomKey\":\"NST116228911\",\"RoomDimensions\":\"12x12\",\"RoomType\":\"Dining Room\",\"RoomLevel\":\"Upper\"},{\"NST_RoomSortOrder\":3,\"RoomKey\":\"NST116228912\",\"RoomDimensions\":\"16x13\",\"RoomType\":\"Family Room\",\"RoomLevel\":\"Lower\"},{\"NST_RoomSortOrder\":9,\"RoomKey\":\"NST116228918\",\"RoomDimensions\":\"13x13\",\"RoomType\":\"Bedroom 5\",\"RoomLevel\":\"Lower\"},{\"NST_RoomSortOrder\":5,\"RoomKey\":\"NST116228914\",\"RoomDimensions\":\"15x12\",\"RoomType\":\"Bedroom\",\"RoomLevel\":\"Upper\"},{\"NST_RoomSortOrder\":8,\"RoomKey\":\"NST116228917\",\"RoomDimensions\":\"14x12\",\"RoomType\":\"Bedroom 4\",\"RoomLevel\":\"Lower\"},{\"NST_RoomSortOrder\":4,\"RoomKey\":\"NST116228913\",\"RoomDimensions\":\"12x12\",\"RoomType\":\"Kitchen\",\"RoomLevel\":\"Upper\"},{\"NST_RoomSortOrder\":1,\"RoomKey\":\"NST116228910\",\"RoomDimensions\":\"20x15\",\"RoomType\":\"Living Room\",\"RoomLevel\":\"Upper\"},{\"NST_RoomSortOrder\":6,\"RoomKey\":\"NST116228915\",\"RoomDimensions\":\"11x10\",\"RoomType\":\"Bedroom 2\",\"RoomLevel\":\"Upper\"},{\"NST_RoomSortOrder\":7,\"RoomKey\":\"NST116228916\",\"RoomDimensions\":\"11x10\",\"RoomType\":\"Bedroom 3\",\"RoomLevel\":\"Upper\"}]","Rooms__NST_RoomSortOrder":"2","Rooms__RoomKey":"NST116228911","Rooms__RoomDimensions":"12x12","Rooms__RoomType":"Dining Room","Rooms__RoomLevel":"Upper","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"Open Concept Kitchen\"},{\"Order\":2,\"Remarks\":\"Updated Kitchen and beautiful wood floors\"},{\"Order\":3,\"Remarks\":\"Dining Room\"},{\"Order\":4,\"Remarks\":\"Living Room\"},{\"Order\":5,\"Remarks\":\"Main Floor Full Bath\"},{\"Order\":6,\"Remarks\":\"Primary Bedroom\"},{\"Order\":7,\"Remarks\":\"Primary 3/4 bath\"},{\"Order\":8,\"Remarks\":\"Bedroom\"},{\"Order\":9,\"Remarks\":\"2nd Full Kitchen, can be used as MIL suite\"},{\"Order\":10,\"Remarks\":\"Lower Level Family Room\"},{\"Order\":11,\"Remarks\":\"Bedroom\"},{\"Order\":12,\"Remarks\":\"Lower Bedroom w/walk in closet\"},{\"Order\":13,\"Remarks\":\"Lower Level Bedroom\"},{\"Order\":17,\"Remarks\":\"Over 2 acres of privacy\"},{\"Order\":18,\"Remarks\":\"Nice Fire Pit out back\"},{\"Order\":19,\"Remarks\":\"Nice shed for extra storage! Or was used for the chickens.\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19","CustomVTourURL":""}