{"Id":1376667,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST6747630","MLSAGENTID":"NST506010359","MLSOFFICEID":"NST26395","ADDRESS":"7087 139th Avenue NW","ACRES":0.02,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"None","BATHSTOTAL":2.0,"BEDROOMS":2,"CITY":"Ramsey","CONTINGENCY":"None","COUNTY":"Anoka","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Vinyl Siding","FORECLOSURE":"No","LASTPRICE":216000.0,"LASTPRICEDATE":"2025-07-30T20:51:04.623","LATITUDE":45.222892,"LENDEROWNED":"No","LISTDATE":"2025-06-30T05:00:00","LISTPRICE":209999.0,"LIVINGAREA":1086.0,"LONGITUDE":-93.446497,"MODIFICATIONTIMESTAMP":"2025-07-30T20:51:04.624","OFFICE_OFFICENAME":"Kelly's Diamond Realty LLC","PHOTOCOUNT":10,"POSTALCODE":"55303","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Show this nice sized bedrooms with enough of storage including a large walk in closet. A private patio for enjoying the summer evenings.","ROADBETWEENWATERFRONTANDHOMEYN":false,"SCHOOLDISTRICTNUMBER":"11-Anoka-Hennepin","SCHOOLDISTRICTPHONE":"763-506-1000","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2025-07-03T05:06:06.077","LASTSTATUS":"Coming Soon","STREETDIRSUFFIX":"NW","STREETNAME":"139th","STREETNUMBER":"7087","STREETSUFFIX":"Avenue","STYLE":"Townhouse Side x Side","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":2004,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2025-07-11T01:58:03.439","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10","SOURCE":"MG_NST"}
{"ListingKey":"NST7766608","LotSizeArea":"0.02","NST_AgeOfProperty":"21","NST_AgentOwner":"No","InternetAutomatedValuationDisplayYN":"False","InternetConsumerCommentYN":"False","NST_AmenitiesUnit":"Ceiling Fan(s),Primary Bedroom Walk-In Closet,Patio,Washer/Dryer Hookup","Appliances":"Cooktop,Dishwasher,Refrigerator","NST_AssessmentPending":"Unknown","AssociationFeeIncludes":"Maintenance Structure,Hazard Insurance,Lawn Care,Maintenance Grounds,Professional Mgmt,Trash,Snow Removal","AssociationFeeFrequency":"Monthly","AssociationYN":"True","AssociationFee":"267","AssociationName":"The Cove At Mississippi West Court Homes Assn, INC","AssociationPhone":"612-614-2900","PropertyAttachedYN":"True","Basement":"None","BasementYN":"True","NST_BathDesc":"Main Floor 1/2 Bath,Upper Level Full Bath","BathroomsOneQuarter":"0","BathroomsFull":"1","BathroomsHalf":"1","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"2","BedroomsTotal":"2","City":"Ramsey","PropertyType":"Residential","NewConstructionYN":"False","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Anoka","NST_DPResource":"Y","DaysOnMarket":"27","CumulativeDaysOnMarket":"27","NST_DiningRoomDescription":"Kitchen/Dining Room","Directions":"Take US - 169 North, exit onto Sunfish Lake Blvd NW, Turn right onto Riverdale Dr. NW, Turn left to say on Riverdale Dr. NW, Turn right onto 139th Ln NW, Turn right onto 139th PI NW.","InternetAddressDisplayYN":"True","InternetEntireListingDisplayYN":"True","NST_ExpectedMarketDate":"2025-07-03","ConstructionMaterials":"Vinyl Siding","Fencing":"Privacy","FireplaceYN":"False","FireplacesTotal":"0","NST_ForeclosureStatus":"No","FoundationArea":"639","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","ParkingFeatures":"Attached Garage","NST_GarageSquareFeet":"0","AccessibilityFeatures":"None","Heating":"Forced Air","OriginalEntryTimestamp":"2025-07-03T05:00:05Z","LandLeaseYN":"False","NST_LastUpdateDate":"2025-07-30","Latitude":"45.222892","NST_LenderOwned":"No","ListAgentKey":"NST100354","ListAgentMlsId":"NST506010359","ListingContractDate":"2025-06-30T05:00:00Z","ListOfficeKey":"NST26395","ListOfficeName":"Kelly's Diamond Realty LLC","ListOfficeMlsId":"NST26395","ListPrice":"209999","LivingArea":"1086","Longitude":"-93.446497","LotSizeDimensions":"871","LotSizeSquareFeet":"871.2","LotSizeUnits":"Acres","ListingId":"NST6747630","SourceSystemName":"RMLS","NST_ManufacturedHome":"No","MapCoordinateSource":"King's Street Atlas","AdditionalParcelsYN":"False","NST_OfficeBoard":"MAAR","ParcelNumber":"343225230100","GarageSpaces":"1","PhotosCount":"10","PostalCity":"Anoka","PostalCode":"55303","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PublicRemarks":"Show this nice sized bedrooms with enough of storage including a large walk in closet. A private patio for enjoying the summer evenings.","PublicSurveyRange":"25","PublicSurveySection":"34","PublicSurveyTownship":"32","NST_RentalLicenseYN":"No","NST_Restrictions":"Mandatory Owners Assoc,Pets - Cats Allowed,Rental Restrictions May Apply","RoomType":"Living Room,Dining Room,Kitchen,Bedroom 1,Bedroom 2","NST_AboveGradeSqFtTotal":"0.0000","NST_BelowGradeSqFtTotal":"0.0000","NST_MainLevelFinishedArea":"0.0000","BuildingAreaTotal":"0","HighSchoolDistrict":"Anoka-Hennepin","NST_SchoolDistrictNumber":"11","NST_SchoolDistrictPhone":"763-506-1000","Sewer":"City Sewer/Connected","AboveGradeFinishedArea":"1086","BelowGradeFinishedArea":"0","StateOrProvince":"MN","StandardStatus":"Active","Levels":"One","StreetDirSuffix":"NW","StreetName":"139th","StreetNumber":"7087","StreetNumberNumeric":"7087","StreetSuffix":"Avenue","PropertySubType":"Townhouse Side x Side","SubdivisionName":"Cic 142 Cove Miss W","NST_TaxWithAssessments":"1581.0000","TaxYear":"2025","TaxAnnualAmount":"1581","WaterSource":"City Water/Connected","YearBuilt":"2004","ZoningDescription":"Residential-Single Family","ModificationTimestamp":"2025-07-30T20:51:04.624Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7766608\",\"Order\":1,\"MediaObjectID\":\"1\",\"ImageWidth\":2080,\"ImageHeight\":1172,\"ImageSizeDescription\":\"2080x1172\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7766608/c39d8452-3ad0-4319-a8ec-d01608bd92dd.jpeg\",\"MediaModificationTimestamp\":\"2025-07-11T01:46:24.048Z\",\"MediaKey\":\"68706cf057029110bd904ee5\"},{\"ResourceRecordKey\":\"NST7766608\",\"Order\":2,\"MediaObjectID\":\"2\",\"ImageWidth\":800,\"ImageHeight\":600,\"ImageSizeDescription\":\"800x600\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7766608/9be0aca0-2218-446c-86c2-e08bd876b825.jpeg\",\"MediaModificationTimestamp\":\"2025-07-11T01:46:24.048Z\",\"MediaKey\":\"68706cf057029110bd904ee8\"},{\"ResourceRecordKey\":\"NST7766608\",\"Order\":3,\"MediaObjectID\":\"3\",\"ImageWidth\":2080,\"ImageHeight\":1169,\"ImageSizeDescription\":\"2080x1169\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7766608/b941977e-cf8e-4d9b-91d0-c70e9c7d440b.jpeg\",\"MediaModificationTimestamp\":\"2025-07-11T01:46:24.058Z\",\"MediaKey\":\"68706cf057029110bd904ee6\"},{\"ResourceRecordKey\":\"NST7766608\",\"Order\":4,\"MediaObjectID\":\"4\",\"ImageWidth\":800,\"ImageHeight\":600,\"ImageSizeDescription\":\"800x600\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7766608/7822c789-86b1-4511-a05b-065ccdb6e5e2.jpeg\",\"MediaModificationTimestamp\":\"2025-07-11T01:43:24.773Z\",\"MediaKey\":\"68706c3c6083e14f3906a623\"},{\"ResourceRecordKey\":\"NST7766608\",\"Order\":5,\"MediaObjectID\":\"5\",\"ImageWidth\":800,\"ImageHeight\":600,\"ImageSizeDescription\":\"800x600\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7766608/8619872c-d1d4-458f-909f-64b0f0efb5a2.jpeg\",\"MediaModificationTimestamp\":\"2025-07-11T01:46:24.092Z\",\"MediaKey\":\"68706cf057029110bd904eea\"},{\"ResourceRecordKey\":\"NST7766608\",\"Order\":6,\"MediaObjectID\":\"6\",\"ImageWidth\":2080,\"ImageHeight\":1173,\"ImageSizeDescription\":\"2080x1173\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7766608/55c0681d-4933-4df5-8c87-8d70b393ca26.jpeg\",\"MediaModificationTimestamp\":\"2025-07-11T01:46:24.09Z\",\"MediaKey\":\"68706cf057029110bd904eeb\"},{\"ResourceRecordKey\":\"NST7766608\",\"Order\":7,\"MediaObjectID\":\"7\",\"ImageWidth\":1566,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1566x2080\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7766608/1bebf10a-d6fe-4671-9ae5-b7a7bf373932.jpeg\",\"MediaModificationTimestamp\":\"2025-07-01T01:41:22.489Z\",\"MediaKey\":\"68633cc2f9f963141c5bfd7b\"},{\"ResourceRecordKey\":\"NST7766608\",\"Order\":8,\"MediaObjectID\":\"8\",\"ImageWidth\":2080,\"ImageHeight\":1171,\"ImageSizeDescription\":\"2080x1171\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7766608/dce4acf8-426b-47b3-b3c9-e27fb911e867.jpeg\",\"MediaModificationTimestamp\":\"2025-07-11T01:48:16.868Z\",\"MediaKey\":\"68706d607e2d517a2bfbe891\"},{\"ResourceRecordKey\":\"NST7766608\",\"Order\":9,\"MediaObjectID\":\"9\",\"ImageWidth\":800,\"ImageHeight\":600,\"ImageSizeDescription\":\"800x600\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7766608/acc7967f-f663-4998-a84c-137ae185d567.jpeg\",\"MediaModificationTimestamp\":\"2025-07-11T01:48:16.902Z\",\"MediaKey\":\"68706d607e2d517a2bfbe892\"},{\"ResourceRecordKey\":\"NST7766608\",\"Order\":10,\"MediaObjectID\":\"10\",\"ImageWidth\":800,\"ImageHeight\":600,\"ImageSizeDescription\":\"800x600\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7766608/47d51f8c-5c74-49ba-9d4c-f51d6720dec4.jpeg\",\"MediaModificationTimestamp\":\"2025-07-11T01:48:16.878Z\",\"MediaKey\":\"68706d607e2d517a2bfbe893\"}]","PhotosChangeTimestamp":"2025-07-11T01:58:03.439Z","Rooms":"[{\"RoomKey\":\"NST115373335\",\"RoomType\":\"Living Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"13 x 13\",\"NST_RoomSortOrder\":\"1\"},{\"RoomKey\":\"NST115373336\",\"RoomType\":\"Dining Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"8 x9\",\"NST_RoomSortOrder\":\"2\"},{\"RoomKey\":\"NST115373337\",\"RoomType\":\"Kitchen\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"7 x9\",\"NST_RoomSortOrder\":\"3\"},{\"RoomKey\":\"NST115373338\",\"RoomType\":\"Bedroom 1\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"13 x 14\",\"NST_RoomSortOrder\":\"4\"},{\"RoomKey\":\"NST115373339\",\"RoomType\":\"Bedroom 2\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"11 x 12\",\"NST_RoomSortOrder\":\"5\"}]","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"","PhotoOrder":"1,2,3,4,5,6,7,8,9,10","CustomVTourURL":""}