{"Id":576235,"ORGTABLE":"RAW_Property","MLSCLASS":"RNT","MLSNUMBER":"NST7097348","MLSAGENTID":"NST502045564","MLSOFFICEID":"NST251939","ADDRESS":"15725 Sycamore Street NW","ACRES":2.18,"AGENTOWNER":true,"AUCTIONYN":false,"BASEMENT":"Block","BATHSTOTAL":3.0,"BEDROOMS":5.0,"CITY":"Andover","CONTINGENCY":"None","COUNTY":"Anoka","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"FORECLOSURE":"No","LASTPRICE":3400.0,"LASTPRICEDATE":"2026-06-23T00:32:06.6","LATITUDE":45.255524,"LENDEROWNED":"No","LISTDATE":"2026-06-22T05:00:00","LISTPRICE":3400.0,"LIVINGAREA":2562.0,"LONGITUDE":-93.288339,"MODIFICATIONTIMESTAMP":"2026-06-23T01:05:06.432","OFFICE_OFFICENAME":"Ashworth Real Estate","PHOTOCOUNT":12,"POSTALCODE":"55304","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"5 bedroom, 3 bath on over 2 acres. Very private but close to highways, and shopping and restaurants.\nOpen concept Kitchen/living room is great for entertaining. Large Primary Bedroom with 3/4 bath. 2 other\nbedrooms on main level. Lower level has 2 more bedrooms, full bath and a kitchen is perfect Mother In Law\nSuite. If you are looking for privacy this is it. Right in the middle of city but you would never know\nit.","ROADBETWEENWATERFRONTANDHOMEYN":false,"SCHOOLDISTRICTNUMBER":"11-Anoka-Hennepin","SCHOOLDISTRICTPHONE":"7635061000","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2026-06-23T00:32:06.6","LASTSTATUS":"Active","STREETDIRSUFFIX":"NW","STREETNAME":"Sycamore","STREETNUMBER":"15725","STREETSUFFIX":"Street","STYLE":"Single Family","TRANSACTIONTYPE":"For Rent","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1978,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2026-06-23T01:05:06.432","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"Kitchen with Granite Counters\"},{\"Order\":2,\"Remarks\":\"Dining Room\"},{\"Order\":3,\"Remarks\":\"Living Room off Kitchen and Dining\"},{\"Order\":4,\"Remarks\":\"Main Floor Bath\"},{\"Order\":5,\"Remarks\":\"Primary Bedroom\"},{\"Order\":6,\"Remarks\":\"Primary Bath\"},{\"Order\":7,\"Remarks\":\"2nd Kitchen\"},{\"Order\":8,\"Remarks\":\"Lower Level Family Room\"},{\"Order\":9,\"Remarks\":\"Bedroom\"},{\"Order\":10,\"Remarks\":\"Lower Level Bedroom\"},{\"Order\":11,\"Remarks\":\"Lower Level Bedroom\"},{\"Order\":12,\"Remarks\":\"Lower Level Full Bath\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12","SOURCE":"MG_NST"}
{"ListingKey":"NST7922978","NST_AboveGradeSqFtTotal":"1456","AboveGradeFinishedArea":"1456","AccessibilityFeatures":"None","AdditionalParcelsYN":"False","NST_AgentOwner":"Yes","NST_AmenitiesUnit":"Deck","NST_ApplicationFee":"50","LivingAreaUnits":"Square Feet","AssociationYN":"False","AssociationFee":"0","AvailabilityDate":"2026-07-01T05:00:00Z","NST_BackgroundCheckReq":"Y","Basement":"Block","BasementYN":"True","BathroomsFull":"2","BathroomsHalf":"0","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"1","BathroomsTotalInteger":"3","BedroomsTotal":"5","NST_BelowGradeSqFtTotal":"1106","BelowGradeFinishedArea":"1106","CumulativeDaysOnMarket":"0","City":"Andover","NewConstructionYN":"False","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Anoka","Directions":"Hansen Blvd. N. to Crosstown(18)or 161st. to Sycamore L to home --behind trees on right-3rd lot N.","DocumentsCount":"0","DaysOnMarket":"0","ExteriorFeatures":"Stucco","FireplaceYN":"True","FireplacesTotal":"2","NST_ForSaleMLNumber":"7073006","FoundationArea":"1456","FoundationDetails":"Block","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","Furnished":"Unfurnished","NST_GarageSquareFeet":"600","GarageSpaces":"2","Heating":"Forced Air","HighSchoolDistrict":"Anoka-Hennepin","NST_ForeclosureStatus":"No","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"True","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","Latitude":"45.255524","LaundryFeatures":"Lower Level","NST_LeasePrice":"3400","NST_LenderOwned":"No","Levels":"Split Entry (Bi-Level)","ListingContractDate":"2026-06-22T05:00:00Z","ListingId":"NST7097348","LivingArea":"2562","Longitude":"-93.288339","LotSizeArea":"2.18","LotSizeDimensions":"185x359","LotSizeUnits":"Acres","NST_MainLevelFinishedArea":"1456","NST_ManufacturedHome":"N","OriginalEntryTimestamp":"2026-06-22T19:26:29Z","OwnerPays":"None","ParcelNumber":"TBD","ParkingFeatures":"Attached Garage","PhotosCount":"12","PhotosChangeTimestamp":"2026-06-23T01:05:06.432Z","PostalCity":"Andover","PostalCode":"55304","NST_PresentUse":"Yearly","PropertyAttachedYN":"False","PropertySubType":"Single Family","PropertyType":"Residential Lease","PublicRemarks":"5 bedroom, 3 bath on over 2 acres. Very private but close to highways, and shopping and restaurants.\nOpen concept Kitchen/living room is great for entertaining. Large Primary Bedroom with 3/4 bath. 2 other\nbedrooms on main level. Lower level has 2 more bedrooms, full bath and a kitchen is perfect Mother In Law\nSuite. If you are looking for privacy this is it. Right in the middle of city but you would never know\nit.","PublicSurveyRange":"24","PublicSurveySection":"14","PublicSurveyTownship":"32","NST_RentSpreeURL":"https://www.rentspree.com/apply/6a39a7b267e6fa7cff04634c?utm_source=northstarmls&utm_medium=applylink&utm_campaign=partner_integration","NST_RentSpreeYN":"Y","NST_RentalLicenseType":"Other","NST_RentalLicenseYN":"Y","NST_SchoolDistrictFullName":"11 - Anoka-Hennepin","NST_SchoolDistrictNumber":"11","NST_SchoolDistrictPhone":"7635061000","NST_SecurityDeposit":"3400","Sewer":"City Sewer/Connected","NST_SmokingPermitted":"N","StandardStatus":"Active","StateOrProvince":"MN","StreetDirSuffix":"NW","StreetName":"Sycamore","StreetNumber":"15725","StreetNumberNumeric":"15725","StreetSuffix":"Street","SubdivisionName":"Cobbs Add To North","TenantPays":"All Utilities","NST_TotalArea":"2562","BuildingAreaTotal":"2562","Township":"Andover","VideosCount":"0","WaterSource":"City Water/Connected","WaterfrontYN":"False","YearBuilt":"1978","ZoningDescription":"Residential-Single Family","ListAgentKey":"NST104892","ListAgentMlsId":"NST502045564","ListOfficeMlsId":"NST251939","ListOfficeName":"Ashworth Real Estate","ListOfficeKey":"NST1000694","ModificationTimestamp":"2026-06-23T01:05:06.432Z","OriginatingSystemName":"northstar","Media":"[{\"Order\":1,\"MediaObjectID\":\"NST1\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7922978/330f52b1-fe19-4e97-8b90-d3dc600138f6.jpeg\",\"LongDescription\":\"Kitchen with Granite Counters\",\"ResourceRecordKey\":\"NST7922978\",\"ImageWidth\":2080,\"ImageHeight\":1566,\"ImageSizeDescription\":\"2080x1566\",\"MediaModificationTimestamp\":\"2026-06-23T00:31:07.853Z\",\"MediaKey\":\"NST123137553\"},{\"Order\":9,\"MediaObjectID\":\"NST9\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7922978/6498474f-cd2a-42b7-804a-7d829ba97c66.jpeg\",\"LongDescription\":\"Bedroom\",\"ResourceRecordKey\":\"NST7922978\",\"ImageWidth\":2080,\"ImageHeight\":1566,\"ImageSizeDescription\":\"2080x1566\",\"MediaModificationTimestamp\":\"2026-06-23T01:04:06.354Z\",\"MediaKey\":\"NST123137596\"},{\"Order\":12,\"MediaObjectID\":\"NST12\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7922978/1e548070-d635-41e8-bdaa-5760870cf910.jpeg\",\"LongDescription\":\"Lower Level Full Bath\",\"ResourceRecordKey\":\"NST7922978\",\"ImageWidth\":1566,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1566x2080\",\"MediaModificationTimestamp\":\"2026-06-23T01:04:06.344Z\",\"MediaKey\":\"NST123137606\"},{\"Order\":8,\"MediaObjectID\":\"NST8\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7922978/922214ad-5730-4e02-83c4-2fbe7d9143af.jpeg\",\"LongDescription\":\"Lower Level Family Room\",\"ResourceRecordKey\":\"NST7922978\",\"ImageWidth\":2080,\"ImageHeight\":1170,\"ImageSizeDescription\":\"2080x1170\",\"MediaModificationTimestamp\":\"2026-06-23T01:04:06.359Z\",\"MediaKey\":\"NST123137597\"},{\"Order\":6,\"MediaObjectID\":\"NST6\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7922978/a37400c9-9aba-42b0-a878-5274fb3e078f.jpeg\",\"LongDescription\":\"Primary Bath\",\"ResourceRecordKey\":\"NST7922978\",\"ImageWidth\":1566,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1566x2080\",\"MediaModificationTimestamp\":\"2026-06-23T01:04:06.359Z\",\"MediaKey\":\"NST123137555\"},{\"Order\":4,\"MediaObjectID\":\"NST4\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7922978/13938b91-fa51-4e29-82e5-652eedbc2fc1.jpeg\",\"LongDescription\":\"Main Floor Bath\",\"ResourceRecordKey\":\"NST7922978\",\"ImageWidth\":1566,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1566x2080\",\"MediaModificationTimestamp\":\"2026-06-23T01:04:06.368Z\",\"MediaKey\":\"NST123137556\"},{\"Order\":11,\"MediaObjectID\":\"NST11\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7922978/763599aa-42e1-4c08-a865-479467242be7.jpeg\",\"LongDescription\":\"Lower Level Bedroom\",\"ResourceRecordKey\":\"NST7922978\",\"ImageWidth\":2080,\"ImageHeight\":1566,\"ImageSizeDescription\":\"2080x1566\",\"MediaModificationTimestamp\":\"2026-06-23T01:04:06.424Z\",\"MediaKey\":\"NST123137594\"},{\"Order\":2,\"MediaObjectID\":\"NST2\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7922978/564b55ec-0d88-488a-b4a0-46f40aa7a7c1.jpeg\",\"LongDescription\":\"Dining Room\",\"ResourceRecordKey\":\"NST7922978\",\"ImageWidth\":2080,\"ImageHeight\":1566,\"ImageSizeDescription\":\"2080x1566\",\"MediaModificationTimestamp\":\"2026-06-23T00:31:07.765Z\",\"MediaKey\":\"NST123137607\"},{\"Order\":7,\"MediaObjectID\":\"NST7\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7922978/4ab223fa-b8cc-4318-b854-6b6df332ba82.jpeg\",\"LongDescription\":\"2nd Kitchen\",\"ResourceRecordKey\":\"NST7922978\",\"ImageWidth\":2080,\"ImageHeight\":1566,\"ImageSizeDescription\":\"2080x1566\",\"MediaModificationTimestamp\":\"2026-06-23T01:04:06.36Z\",\"MediaKey\":\"NST123137598\"},{\"Order\":5,\"MediaObjectID\":\"NST5\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7922978/04ff975d-9ac3-43ef-b35e-352d5a16b716.jpeg\",\"LongDescription\":\"Primary Bedroom\",\"ResourceRecordKey\":\"NST7922978\",\"ImageWidth\":2080,\"ImageHeight\":1566,\"ImageSizeDescription\":\"2080x1566\",\"MediaModificationTimestamp\":\"2026-06-23T01:04:06.383Z\",\"MediaKey\":\"NST123137604\"},{\"Order\":3,\"MediaObjectID\":\"NST3\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7922978/3053edfe-2316-4a07-8060-72307a2076f8.jpeg\",\"LongDescription\":\"Living Room off Kitchen and Dining\",\"ResourceRecordKey\":\"NST7922978\",\"ImageWidth\":2080,\"ImageHeight\":1566,\"ImageSizeDescription\":\"2080x1566\",\"MediaModificationTimestamp\":\"2026-06-23T00:31:07.877Z\",\"MediaKey\":\"NST123137600\"},{\"Order\":10,\"MediaObjectID\":\"NST10\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7922978/14348f0b-ccbc-4196-be8a-bd215c6c5838.jpeg\",\"LongDescription\":\"Lower Level Bedroom\",\"ResourceRecordKey\":\"NST7922978\",\"ImageWidth\":2080,\"ImageHeight\":1566,\"ImageSizeDescription\":\"2080x1566\",\"MediaModificationTimestamp\":\"2026-06-23T01:04:06.484Z\",\"MediaKey\":\"NST123137595\"}]","Media__Order":"1","Media__MediaObjectID":"NST1","Media__MediaURL":"https://s3.amazonaws.com/mlsgrid/images/NST7922978/330f52b1-fe19-4e97-8b90-d3dc600138f6.jpeg","Media__LongDescription":"Kitchen with Granite Counters","Media__ResourceRecordKey":"NST7922978","Media__ImageWidth":"2080","Media__ImageHeight":"1566","Media__ImageSizeDescription":"2080x1566","Media__MediaModificationTimestamp":"6/23/2026 12:31:07 AM","Media__MediaKey":"NST123137553","DocumentsChangeTimestamp":"2026-06-23T00:27:06.653Z","Rooms":"[{\"RoomKey\":\"NST116382211\",\"RoomDimensions\":\"12x12\",\"NST_RoomSortOrder\":2,\"RoomType\":\"Dining Room\",\"RoomLevel\":\"Main\"},{\"RoomKey\":\"NST116382212\",\"RoomDimensions\":\"13x16\",\"NST_RoomSortOrder\":3,\"RoomType\":\"Family Room\",\"RoomLevel\":\"Main\"},{\"RoomKey\":\"NST116382232\",\"RoomDimensions\":\"13x13\",\"NST_RoomSortOrder\":10,\"RoomType\":\"Bedroom 5\",\"RoomLevel\":\"Lower\"},{\"RoomKey\":\"NST116382215\",\"RoomDimensions\":\"10x11\",\"NST_RoomSortOrder\":6,\"RoomType\":\"Bedroom\",\"RoomLevel\":\"Main\"},{\"RoomKey\":\"NST116382231\",\"RoomDimensions\":\"12x14\",\"NST_RoomSortOrder\":9,\"RoomType\":\"Bedroom 4\",\"RoomLevel\":\"Lower\"},{\"RoomKey\":\"NST116382213\",\"RoomDimensions\":\"12x12\",\"NST_RoomSortOrder\":4,\"RoomType\":\"Kitchen\",\"RoomLevel\":\"Main\"},{\"RoomKey\":\"NST116382214\",\"NST_RoomSortOrder\":5,\"RoomType\":\"Kitchen- 2nd\",\"RoomLevel\":\"Lower\"},{\"RoomKey\":\"NST116382210\",\"RoomDimensions\":\"15x20\",\"NST_RoomSortOrder\":1,\"RoomType\":\"Living Room\",\"RoomLevel\":\"Main\"},{\"RoomKey\":\"NST116382216\",\"RoomDimensions\":\"10x11\",\"NST_RoomSortOrder\":7,\"RoomType\":\"Bedroom 2\",\"RoomLevel\":\"Main\"},{\"RoomKey\":\"NST116382230\",\"RoomDimensions\":\"12x15\",\"NST_RoomSortOrder\":8,\"RoomType\":\"Bedroom 3\",\"RoomLevel\":\"Main\"}]","Rooms__RoomKey":"NST116382211","Rooms__RoomDimensions":"12x12","Rooms__NST_RoomSortOrder":"2","Rooms__RoomType":"Dining Room","Rooms__RoomLevel":"Main","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"Kitchen with Granite Counters\"},{\"Order\":2,\"Remarks\":\"Dining Room\"},{\"Order\":3,\"Remarks\":\"Living Room off Kitchen and Dining\"},{\"Order\":4,\"Remarks\":\"Main Floor Bath\"},{\"Order\":5,\"Remarks\":\"Primary Bedroom\"},{\"Order\":6,\"Remarks\":\"Primary Bath\"},{\"Order\":7,\"Remarks\":\"2nd Kitchen\"},{\"Order\":8,\"Remarks\":\"Lower Level Family Room\"},{\"Order\":9,\"Remarks\":\"Bedroom\"},{\"Order\":10,\"Remarks\":\"Lower Level Bedroom\"},{\"Order\":11,\"Remarks\":\"Lower Level Bedroom\"},{\"Order\":12,\"Remarks\":\"Lower Level Full Bath\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12","CustomVTourURL":""}