{"Id":575634,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST7096208","MLSAGENTID":"NST505005074","MLSOFFICEID":"NST12202","ADDRESS":"6201 Riverview Terrace NE","ACRES":0.38,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Finished,Full,Sump Pump","BATHSTOTAL":2.0,"BEDROOMS":3.0,"CITY":"Fridley","CONTINGENCY":"None","COUNTY":"Anoka","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"FORECLOSURE":"No","LASTPRICE":309900.0,"LASTPRICEDATE":"2026-08-22T15:12:07.333","LATITUDE":45.081273,"LENDEROWNED":"No","LISTDATE":"2026-06-20T05:00:00","LISTPRICE":299900.0,"LIVINGAREA":1582.0,"LONGITUDE":-93.2763328,"LOTDESCRIPTION":"Public Transit (w/in 6 blks),Irregular Lot,Tree Coverage - Medium","MODIFICATIONTIMESTAMP":"2026-08-22T15:12:07.334","OFFICE_OFFICENAME":"PCH Realty LLC","OUTBUILDINGS":"Storage Shed","PHOTOCOUNT":14,"POSTALCODE":"55432","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Price drop!! Nestled in a desirable river-area neighborhood, this 3-bedroom, 2-bath home offers comfortable living on an expansive lot. Enjoy spacious outdoor areas, mature surroundings, and convenient access to parks, schools, shopping, and major commuter routes. A fantastic opportunity to personalize and build equity in a sought-after Fridley location. \"Professional pictures coming soon","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Age Over 8 Years,Asphalt","SCHOOLDISTRICTNUMBER":"14-Fridley","SCHOOLDISTRICTPHONE":"7635025001","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2026-06-26T05:03:19.137","LASTSTATUS":"Coming Soon","STREETDIRSUFFIX":"NE","STREETNAME":"Riverview","STREETNUMBER":"6201","STREETSUFFIX":"Terrace","STYLE":"Single Family","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1959,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2026-06-29T13:56:07.387","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"Front\"},{\"Order\":2,\"Remarks\":\"shade\"},{\"Order\":3,\"Remarks\":\"Riverview_High-Res-6.jpg\"},{\"Order\":4,\"Remarks\":\"Riverview_High-Res-7.jpg\"},{\"Order\":5,\"Remarks\":\"Riverview_High-Res-10.jpg\"},{\"Order\":6,\"Remarks\":\"Riverview_High-Res-11.jpg\"},{\"Order\":7,\"Remarks\":\"Riverview_High-Res-12.jpg\"},{\"Order\":8,\"Remarks\":\"Riverview_High-Res-13.jpg\"},{\"Order\":9,\"Remarks\":\"Riverview_High-Res-14.jpg\"},{\"Order\":10,\"Remarks\":\"Riverview_High-Res-17.jpg\"},{\"Order\":11,\"Remarks\":\"Riverview_High-Res-18.jpg\"},{\"Order\":12,\"Remarks\":\"Riverview_High-Res-22.jpg\"},{\"Order\":13,\"Remarks\":\"Riverview_High-Res-24 (1).jpg\"},{\"Order\":14,\"Remarks\":\"Riverview_High-Res-25.jpg\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13,14","SOURCE":"MG_NST"}
{"ListingKey":"NST7921992","NST_AboveGradeSqFtTotal":"989","AboveGradeFinishedArea":"989","AccessibilityFeatures":"None","AdditionalParcelsYN":"False","NST_AgentOwner":"No","NST_AmenitiesUnit":"Hardwood Floors,Kitchen Window,Washer/Dryer Hookup","Appliances":"Dishwasher,Dryer,Microwave,Range,Refrigerator,Washer,Water Softener Owned","LivingAreaUnits":"Square Feet","NST_AssessmentPending":"No","AssociationYN":"False","AssociationFee":"0","Basement":"Finished,Full,Sump Pump","BasementYN":"True","NST_BathDesc":"3/4 Basement,Main Floor Full Bath","BathroomsFull":"1","BathroomsHalf":"0","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"1","BathroomsTotalInteger":"2","BedroomsTotal":"3","NST_BelowGradeSqFtTotal":"593","BelowGradeFinishedArea":"593","CumulativeDaysOnMarket":"0","City":"Fridley","NewConstructionYN":"False","Contingency":"None","NST_ForSaleOrLease":"For Sale","Cooling":"Central Air","CountyOrParish":"Anoka","NST_DPResource":"Yes","NST_DiningRoomDescription":"Kitchen/Dining Room","Directions":"I-694 to North, East River Road. Turn Left on 62nd Way NE.","DocumentsCount":"0","DaysOnMarket":"0","NST_ExpectedMarketDate":"2026-06-26","ExteriorFeatures":"Metal","Fencing":"None","FireplaceYN":"False","FireplacesTotal":"0","FoundationArea":"924","FoundationDetails":"Other","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","NST_GarageSquareFeet":"336","GarageSpaces":"1","Heating":"Forced Air","HighSchoolDistrict":"Fridley","NST_ForeclosureStatus":"No","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"True","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","Latitude":"45.0812729961","NST_LenderOwned":"No","Levels":"One","ListPrice":"299900","ListingContractDate":"2026-06-20T05:00:00Z","ListingId":"NST7096208","LivingArea":"1582","Longitude":"-93.2763327953","LotFeatures":"Public Transit (w/in 6 blks),Irregular Lot,Tree Coverage - Medium","LotSizeArea":"0.38","LotSizeDimensions":"Irregular","LotSizeUnits":"Acres","NST_MainLevelFinishedArea":"924","NST_ManufacturedHome":"N","OriginalEntryTimestamp":"2026-06-26T00:00:26Z","OtherStructures":"Storage Shed","ParcelNumber":"153024430035","ParkingFeatures":"Attached Garage","PhotosCount":"14","PhotosChangeTimestamp":"2026-06-29T13:56:07.387Z","PostalCity":"Fridley","PostalCode":"55432","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PropertyAttachedYN":"False","PropertySubType":"Single Family","PropertyType":"Residential","PublicRemarks":"Price drop!! Nestled in a desirable river-area neighborhood, this 3-bedroom, 2-bath home offers comfortable living on an expansive lot. Enjoy spacious outdoor areas, mature surroundings, and convenient access to parks, schools, shopping, and major commuter routes. A fantastic opportunity to personalize and build equity in a sought-after Fridley location. \"Professional pictures coming soon","RoadFrontageType":"City Street,Paved Streets","Roof":"Age Over 8 Years,Asphalt","NST_SchoolDistrictFullName":"14 - Fridley","NST_SchoolDistrictNumber":"14","NST_SchoolDistrictPhone":"7635025001","Sewer":"City Sewer/Connected","NST_SpecialSearch":"3 BR on One Level,Main Floor Bedroom","StandardStatus":"Active","StateOrProvince":"MN","StreetDirSuffix":"NE","StreetName":"Riverview","StreetNumber":"6201","StreetNumberNumeric":"6201","StreetSuffix":"Terrace","TaxAnnualAmount":"4076.08","NST_TaxWithAssessments":"4076.08","TaxYear":"2026","NST_TotalArea":"1582","BuildingAreaTotal":"1582","Township":"Fridley","VideosCount":"0","WaterSource":"City Water/Connected","WaterfrontYN":"False","YearBuilt":"1959","ZoningDescription":"Residential-Single Family","ListAgentKey":"NST42422","ListAgentMlsId":"NST505005074","ListOfficeMlsId":"NST12202","ListOfficeName":"PCH Realty LLC","ListOfficeKey":"NST17315","ModificationTimestamp":"2026-08-22T15:12:07.334Z","OriginatingSystemName":"northstar","Media":"[{\"Order\":8,\"MediaObjectID\":\"NST8\",\"ResourceRecordKey\":\"NST7921992\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7921992/96d8c3be-587a-490c-90bf-f434557d15d2.jpeg\",\"LongDescription\":\"Riverview_High-Res-13.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-06-29T13:56:06.367Z\",\"MediaKey\":\"NST123269757\"},{\"Order\":6,\"MediaObjectID\":\"NST6\",\"ResourceRecordKey\":\"NST7921992\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7921992/a949c93a-47ab-4e80-9816-ec2b223f7527.jpeg\",\"LongDescription\":\"Riverview_High-Res-11.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-06-29T13:56:06.313Z\",\"MediaKey\":\"NST123269759\"},{\"Order\":2,\"MediaObjectID\":\"NST2\",\"ResourceRecordKey\":\"NST7921992\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7921992/9269375c-fb0a-4816-b92f-1fde6dbf2e66.jpeg\",\"LongDescription\":\"shade\",\"ImageWidth\":2080,\"ImageHeight\":1328,\"ImageSizeDescription\":\"2080x1328\",\"MediaModificationTimestamp\":\"2026-06-20T23:41:05.522Z\",\"MediaKey\":\"NST123107958\"},{\"Order\":7,\"MediaObjectID\":\"NST7\",\"ResourceRecordKey\":\"NST7921992\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7921992/17df594d-85f2-47c0-b59f-b95a75635140.jpeg\",\"LongDescription\":\"Riverview_High-Res-12.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-06-29T13:56:06.377Z\",\"MediaKey\":\"NST123269758\"},{\"Order\":10,\"MediaObjectID\":\"NST10\",\"ResourceRecordKey\":\"NST7921992\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7921992/bc41dcac-bbce-4e56-ab57-abd3a86df8fb.jpeg\",\"LongDescription\":\"Riverview_High-Res-17.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-06-29T13:56:06.304Z\",\"MediaKey\":\"NST123269755\"},{\"Order\":13,\"MediaObjectID\":\"NST13\",\"ResourceRecordKey\":\"NST7921992\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7921992/3bb0cf89-25f1-4652-ad1b-44d7b8a07bc7.jpeg\",\"LongDescription\":\"Riverview_High-Res-24 (1).jpg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-06-29T13:56:06.33Z\",\"MediaKey\":\"NST123269752\"},{\"Order\":11,\"MediaObjectID\":\"NST11\",\"ResourceRecordKey\":\"NST7921992\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7921992/5c3caa43-19e5-44db-8f6e-0aec9e8c1f61.jpeg\",\"LongDescription\":\"Riverview_High-Res-18.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-06-29T13:56:06.326Z\",\"MediaKey\":\"NST123269754\"},{\"Order\":14,\"MediaObjectID\":\"NST14\",\"ResourceRecordKey\":\"NST7921992\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7921992/66475d6b-5258-49d4-b6a7-9b3f890cb011.jpeg\",\"LongDescription\":\"Riverview_High-Res-25.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-06-29T13:56:06.339Z\",\"MediaKey\":\"NST123269751\"},{\"Order\":9,\"MediaObjectID\":\"NST9\",\"ResourceRecordKey\":\"NST7921992\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7921992/c028ce27-e4d3-46e1-9b6c-22b3d6932bfa.jpeg\",\"LongDescription\":\"Riverview_High-Res-14.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-06-29T13:56:06.317Z\",\"MediaKey\":\"NST123269756\"},{\"Order\":12,\"MediaObjectID\":\"NST12\",\"ResourceRecordKey\":\"NST7921992\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7921992/5bfc86eb-b8cb-44cc-9b6e-ced6a8af43f3.jpeg\",\"LongDescription\":\"Riverview_High-Res-22.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-06-29T13:56:06.319Z\",\"MediaKey\":\"NST123269753\"},{\"Order\":5,\"MediaObjectID\":\"NST5\",\"ResourceRecordKey\":\"NST7921992\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7921992/f718fe59-5828-407d-acf3-d75d899859ed.jpeg\",\"LongDescription\":\"Riverview_High-Res-10.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-06-29T13:56:06.333Z\",\"MediaKey\":\"NST123269760\"},{\"Order\":4,\"MediaObjectID\":\"NST4\",\"ResourceRecordKey\":\"NST7921992\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7921992/067efa0a-c325-43c7-88b6-da26aed99e57.jpeg\",\"LongDescription\":\"Riverview_High-Res-7.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-06-29T13:55:08.971Z\",\"MediaKey\":\"NST123269744\"},{\"Order\":1,\"MediaObjectID\":\"NST1\",\"ResourceRecordKey\":\"NST7921992\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7921992/8702a192-3eff-4461-9cb0-b0d4a995556c.jpeg\",\"LongDescription\":\"Front\",\"ImageWidth\":2080,\"ImageHeight\":1413,\"ImageSizeDescription\":\"2080x1413\",\"MediaModificationTimestamp\":\"2026-06-20T23:41:05.588Z\",\"MediaKey\":\"NST123107955\"},{\"Order\":3,\"MediaObjectID\":\"NST3\",\"ResourceRecordKey\":\"NST7921992\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7921992/5ca1bbcd-d517-4654-b1c2-c39f61d9db93.jpeg\",\"LongDescription\":\"Riverview_High-Res-6.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-06-29T13:55:08.97Z\",\"MediaKey\":\"NST123269745\"}]","Media__Order":"8","Media__MediaObjectID":"NST8","Media__ResourceRecordKey":"NST7921992","Media__MediaURL":"https://s3.amazonaws.com/mlsgrid/images/NST7921992/96d8c3be-587a-490c-90bf-f434557d15d2.jpeg","Media__LongDescription":"Riverview_High-Res-13.jpg","Media__ImageWidth":"2080","Media__ImageHeight":"1386","Media__ImageSizeDescription":"2080x1386","Media__MediaModificationTimestamp":"6/29/2026 1:56:06 PM","Media__MediaKey":"NST123269757","DocumentsChangeTimestamp":"2026-06-20T23:38:06.204Z","Rooms":"[{\"RoomType\":\"Bar/Wet Bar Room\",\"NST_RoomSortOrder\":9,\"RoomLevel\":\"Lower\",\"RoomDimensions\":\"9x11\",\"RoomKey\":\"NST116375324\"},{\"RoomType\":\"Dining Room\",\"NST_RoomSortOrder\":2,\"RoomLevel\":\"Main\",\"RoomDimensions\":\"9x8\",\"RoomKey\":\"NST116375318\"},{\"RoomType\":\"Family Room\",\"NST_RoomSortOrder\":3,\"RoomLevel\":\"Lower\",\"RoomDimensions\":\"42x11\",\"RoomKey\":\"NST116375319\"},{\"RoomType\":\"Bedroom\",\"NST_RoomSortOrder\":5,\"RoomLevel\":\"Main\",\"RoomDimensions\":\"12x12\",\"RoomKey\":\"NST116375321\"},{\"RoomType\":\"Kitchen\",\"NST_RoomSortOrder\":4,\"RoomLevel\":\"Main\",\"RoomDimensions\":\"13x10\",\"RoomKey\":\"NST116375320\"},{\"RoomType\":\"Living Room\",\"NST_RoomSortOrder\":1,\"RoomLevel\":\"Main\",\"RoomDimensions\":\"19x13\",\"RoomKey\":\"NST116375317\"},{\"RoomType\":\"Other\",\"NST_RoomSortOrder\":10,\"RoomLevel\":\"Lower\",\"RoomDimensions\":\"8x4\",\"RoomKey\":\"NST116375325\"},{\"RoomType\":\"Bedroom 2\",\"NST_RoomSortOrder\":6,\"RoomLevel\":\"Main\",\"RoomDimensions\":\"12x11\",\"RoomKey\":\"NST116375322\"},{\"RoomType\":\"Bedroom 3\",\"NST_RoomSortOrder\":7,\"RoomLevel\":\"Main\",\"RoomDimensions\":\"11x10\",\"RoomKey\":\"NST116375323\"}]","Rooms__RoomType":"Bar/Wet Bar Room","Rooms__NST_RoomSortOrder":"9","Rooms__RoomLevel":"Lower","Rooms__RoomDimensions":"9x11","Rooms__RoomKey":"NST116375324","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"Front\"},{\"Order\":2,\"Remarks\":\"shade\"},{\"Order\":3,\"Remarks\":\"Riverview_High-Res-6.jpg\"},{\"Order\":4,\"Remarks\":\"Riverview_High-Res-7.jpg\"},{\"Order\":5,\"Remarks\":\"Riverview_High-Res-10.jpg\"},{\"Order\":6,\"Remarks\":\"Riverview_High-Res-11.jpg\"},{\"Order\":7,\"Remarks\":\"Riverview_High-Res-12.jpg\"},{\"Order\":8,\"Remarks\":\"Riverview_High-Res-13.jpg\"},{\"Order\":9,\"Remarks\":\"Riverview_High-Res-14.jpg\"},{\"Order\":10,\"Remarks\":\"Riverview_High-Res-17.jpg\"},{\"Order\":11,\"Remarks\":\"Riverview_High-Res-18.jpg\"},{\"Order\":12,\"Remarks\":\"Riverview_High-Res-22.jpg\"},{\"Order\":13,\"Remarks\":\"Riverview_High-Res-24 (1).jpg\"},{\"Order\":14,\"Remarks\":\"Riverview_High-Res-25.jpg\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13,14","CustomVTourURL":""}