• Active/Pending
  • Clearwater - Recently Sold
  • Clearwater Lake Lots
  • Search MLS #
  • Search other lakes
  • Sign up for automated updates
  • Mortgage calculator
  • Saved Listings
  • Contact Us
  • MENU

    MLS# 7127879 - 5787 Central Avenue NE Fridley, MN 55432

    Neighborhoods

    USA Dream Home Realty Inc is the brokerage office representing the seller for this listing.

    Copyright 2019, Regional Multiple Listing Service of Minnesota, Inc. all rights reserved. Information is deemed reliable but is not guaranteed.

    The data relating to real estate for sale on this site comes in part from the broker reciprocity program of the Regional multiple Listing Service of Minnesota, Inc. real estate listings held by brokerage firms other than are marked with the Broker Reciprocity logo or the Broker reciprocity house icon and detailed information about them includes the names(s) of the listing brokers. Joy+Marci Realty Group is not a multiple Listing Service (MLS), nor does it offer MLS access. This website is a service of Joy+Marci Realty Group, a broker Participant of the Regional Multiple Listing Service of Minnesota, Inc.

    {"Id":600537,"ORGTABLE":"RAW_Property","MLSCLASS":"RNT","MLSNUMBER":"NST7127879","MLSAGENTID":"NST506093398","MLSOFFICEID":"NST40107","ADDRESS":"5787 Central Avenue NE","ACRES":0.232,"AGENTOWNER":true,"AUCTIONYN":false,"BASEMENT":"Finished","BATHSTOTAL":2.0,"BEDROOMS":4.0,"CITY":"Fridley","CONTINGENCY":"None","COUNTY":"Anoka","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"FORECLOSURE":"No","LAKEACRES":0.0,"LAKEDEPTH":"20","LAKEWATERFRONT":"Lake View","LASTPRICE":2300.0,"LASTPRICEDATE":"2026-08-15T03:37:06.287","LATITUDE":45.07260427,"LENDEROWNED":"No","LISTDATE":"2026-08-14T05:00:00","LISTPRICE":2300.0,"LIVINGAREA":1584.0,"LONGITUDE":-93.24471397,"MODIFICATIONTIMESTAMP":"2026-08-15T04:08:06.157","OFFICE_OFFICENAME":"USA Dream Home Realty Inc","PHOTOCOUNT":13,"POSTALCODE":"55432","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","ROADBETWEENWATERFRONTANDHOMEYN":false,"SCHOOLDISTRICTNUMBER":"14-Fridley","SCHOOLDISTRICTPHONE":"7635025001","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2026-08-15T03:37:06.287","LASTSTATUS":"Active","STREETDIRSUFFIX":"NE","STREETNAME":"Central","STREETNUMBER":"5787","STREETSUFFIX":"Avenue","STYLE":"Single Family","TRANSACTIONTYPE":"For Rent","WATER":"City Water/Connected","WATERFRONTNAME":"East Moore","WATERFRONTNUM":"02007501","WATERFRONTPRESENT":false,"WATERFRONTVIEW":"Lake View","YEARBUILT":1956,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2026-08-15T04:02:06.166","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"Front.jpg\"},{\"Order\":2,\"Remarks\":\"20260812_112030.jpg\"},{\"Order\":3,\"Remarks\":\"Back yard.jpg\"},{\"Order\":4,\"Remarks\":\"Living room.jpg\"},{\"Order\":5,\"Remarks\":\"View from Living room.jpg\"},{\"Order\":6,\"Remarks\":\"Dinning room.jpg\"},{\"Order\":7,\"Remarks\":\"Kitchen.jpg\"},{\"Order\":8,\"Remarks\":\"Eat in kitchen.jpg\"},{\"Order\":9,\"Remarks\":\"Bedroom 1.jpg\"},{\"Order\":10,\"Remarks\":\"Bedroom 2.jpg\"},{\"Order\":11,\"Remarks\":\"Bedroom-2.jpg\"},{\"Order\":12,\"Remarks\":\"Full bath upper level.jpg\"},{\"Order\":13,\"Remarks\":\"Bedroom 3.jpg\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13","SOURCE":"MG_NST"}
    {"ListingKey":"NST7951559","NST_AboveGradeSqFtTotal":"1098","AboveGradeFinishedArea":"1098","AccessibilityFeatures":"None","AdditionalParcelsYN":"False","NST_AgentOwner":"Yes","NST_ApplicationFee":"35","LivingAreaUnits":"Square Feet","AssociationYN":"False","AssociationFee":"0","AvailabilityDate":"2026-08-15T05:00:00Z","NST_BackgroundCheckReq":"Y","Basement":"Finished","BasementYN":"True","BathroomsFull":"1","BathroomsHalf":"0","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"1","BathroomsTotalInteger":"2","BedroomsTotal":"4","NST_BelowGradeSqFtTotal":"486","BelowGradeFinishedArea":"486","CumulativeDaysOnMarket":"0","City":"Fridley","NewConstructionYN":"False","Contingency":"None","NST_ForSaleOrLease":"For Sale","Cooling":"Central Air","CountyOrParish":"Anoka","NST_DiningRoomDescription":"Eat In Kitchen,Informal Dining Room","Directions":"I-694 TO CENTRAL(HWY 65) N. TO 1ST LIGHT. TURN RIGHT TO OLD CENTRAL","DocumentsCount":"0","DaysOnMarket":"0","ExteriorFeatures":"Stone,Vinyl","Fencing":"Chain Link","FireplaceYN":"True","FireplacesTotal":"2","FoundationArea":"1098","FoundationDetails":"Brick/Mortar","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","Furnished":"Unfurnished","GarageSpaces":"1","Heating":"Forced Air","HighSchoolDistrict":"Fridley","NST_ForeclosureStatus":"No","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"True","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","Latitude":"45.0726042672","LaundryFeatures":"In Unit","NST_LeasePrice":"2300","NST_LenderOwned":"No","Levels":"One","ListingContractDate":"2026-08-14T05:00:00Z","ListingId":"NST7127879","LivingArea":"1584","Longitude":"-93.2447139663","LotSizeArea":"0.232","LotSizeDimensions":"75x135","LotSizeUnits":"Acres","NST_MainLevelFinishedArea":"1098","NST_ManufacturedHome":"N","OriginalEntryTimestamp":"2026-08-14T22:35:40Z","OwnerPays":"None","ParcelNumber":"243024230020","ParkingFeatures":"Attached Garage","PhotosCount":"13","PhotosChangeTimestamp":"2026-08-15T04:02:06.166Z","PostalCity":"Fridley","PostalCode":"55432","NST_PresentUse":"Yearly","PropertyAttachedYN":"False","PropertySubType":"Single Family","PropertyType":"Residential Lease","NST_RentSpreeYN":"N","NST_RentalLicenseType":"Standard","NST_RentalLicenseYN":"Y","NST_SchoolDistrictFullName":"14 - Fridley","NST_SchoolDistrictNumber":"14","NST_SchoolDistrictPhone":"7635025001","NST_SecurityDeposit":"2300","Sewer":"City Sewer/Connected","NST_SmokingPermitted":"N","StandardStatus":"Active","StateOrProvince":"MN","StreetDirSuffix":"NE","StreetName":"Central","StreetNumber":"5787","StreetNumberNumeric":"5787","StreetSuffix":"Avenue","TenantPays":"All Utilities,Cable TV,Electricity,Gas,Heat,Trash Collection,Water","NST_TotalArea":"1584","BuildingAreaTotal":"1584","Township":"Fridley","VideosCount":"0","WaterSource":"City Water/Connected","WaterfrontFeatures":"Lake View","WaterfrontYN":"False","YearBuilt":"1956","ZoningDescription":"Residential-Single Family","ListAgentKey":"NST81827","ListAgentMlsId":"NST506093398","ListOfficeMlsId":"NST40107","ListOfficeName":"USA Dream Home Realty Inc","ListOfficeKey":"NST18348","ModificationTimestamp":"2026-08-15T04:08:06.157Z","OriginatingSystemName":"northstar","Media":"[{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7951559/e8b174a5-9fa9-4bf0-97fc-a125062ae2e4.jpeg\",\"LongDescription\":\"20260812_112030.jpg\",\"ResourceRecordKey\":\"NST7951559\",\"Order\":2,\"MediaObjectID\":\"NST2\",\"ImageWidth\":2080,\"ImageHeight\":1171,\"ImageSizeDescription\":\"2080x1171\",\"MediaModificationTimestamp\":\"2026-08-15T03:59:14.573Z\",\"MediaKey\":\"NST124279682\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7951559/a2094f74-075d-4be5-8e2a-69038f2258eb.jpeg\",\"LongDescription\":\"Front.jpg\",\"ResourceRecordKey\":\"NST7951559\",\"Order\":1,\"MediaObjectID\":\"NST1\",\"ImageWidth\":2080,\"ImageHeight\":1171,\"ImageSizeDescription\":\"2080x1171\",\"MediaModificationTimestamp\":\"2026-08-15T03:59:14.545Z\",\"MediaKey\":\"NST124279681\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7951559/22377b0a-23b1-4b0a-94ff-f13ea4caf8da.jpeg\",\"LongDescription\":\"Bedroom-2.jpg\",\"ResourceRecordKey\":\"NST7951559\",\"Order\":11,\"MediaObjectID\":\"NST11\",\"ImageWidth\":2080,\"ImageHeight\":1171,\"ImageSizeDescription\":\"2080x1171\",\"MediaModificationTimestamp\":\"2026-08-15T04:01:16.473Z\",\"MediaKey\":\"NST124279691\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7951559/99e59f38-deba-4785-bcbd-053f760ad397.jpeg\",\"LongDescription\":\"Bedroom 2.jpg\",\"ResourceRecordKey\":\"NST7951559\",\"Order\":10,\"MediaObjectID\":\"NST10\",\"ImageWidth\":2080,\"ImageHeight\":1171,\"ImageSizeDescription\":\"2080x1171\",\"MediaModificationTimestamp\":\"2026-08-15T04:00:14.724Z\",\"MediaKey\":\"NST124279690\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7951559/2a0c9407-3950-48e9-b4e8-837e2fe9e716.jpeg\",\"LongDescription\":\"Eat in kitchen.jpg\",\"ResourceRecordKey\":\"NST7951559\",\"Order\":8,\"MediaObjectID\":\"NST8\",\"ImageWidth\":2080,\"ImageHeight\":1171,\"ImageSizeDescription\":\"2080x1171\",\"MediaModificationTimestamp\":\"2026-08-15T04:00:14.721Z\",\"MediaKey\":\"NST124279688\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7951559/a74fa8b6-084b-4cca-8890-e24c6271be67.jpeg\",\"LongDescription\":\"Bedroom 3.jpg\",\"ResourceRecordKey\":\"NST7951559\",\"Order\":13,\"MediaObjectID\":\"NST13\",\"ImageWidth\":2080,\"ImageHeight\":1171,\"ImageSizeDescription\":\"2080x1171\",\"MediaModificationTimestamp\":\"2026-08-15T04:01:16.477Z\",\"MediaKey\":\"NST124279693\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7951559/0cf97790-37a3-455d-9e37-b0f42c4a7d5c.jpeg\",\"LongDescription\":\"Bedroom 1.jpg\",\"ResourceRecordKey\":\"NST7951559\",\"Order\":9,\"MediaObjectID\":\"NST9\",\"ImageWidth\":2080,\"ImageHeight\":1171,\"ImageSizeDescription\":\"2080x1171\",\"MediaModificationTimestamp\":\"2026-08-15T04:00:14.741Z\",\"MediaKey\":\"NST124279689\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7951559/7be79386-6efc-47de-b575-52fd58ae3c61.jpeg\",\"LongDescription\":\"Dinning room.jpg\",\"ResourceRecordKey\":\"NST7951559\",\"Order\":6,\"MediaObjectID\":\"NST6\",\"ImageWidth\":2080,\"ImageHeight\":1171,\"ImageSizeDescription\":\"2080x1171\",\"MediaModificationTimestamp\":\"2026-08-15T03:59:14.545Z\",\"MediaKey\":\"NST124279686\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7951559/5b820079-21b3-4fbb-982d-5b6db5f5f264.jpeg\",\"LongDescription\":\"Kitchen.jpg\",\"ResourceRecordKey\":\"NST7951559\",\"Order\":7,\"MediaObjectID\":\"NST7\",\"ImageWidth\":2080,\"ImageHeight\":1171,\"ImageSizeDescription\":\"2080x1171\",\"MediaModificationTimestamp\":\"2026-08-15T04:00:14.7Z\",\"MediaKey\":\"NST124279687\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7951559/d5980028-8291-46bd-95be-fbee3053b919.jpeg\",\"LongDescription\":\"Living room.jpg\",\"ResourceRecordKey\":\"NST7951559\",\"Order\":4,\"MediaObjectID\":\"NST4\",\"ImageWidth\":2080,\"ImageHeight\":1171,\"ImageSizeDescription\":\"2080x1171\",\"MediaModificationTimestamp\":\"2026-08-15T03:59:14.519Z\",\"MediaKey\":\"NST124279684\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7951559/39dd27b2-70ee-45d5-8482-7ef1e836aad4.jpeg\",\"LongDescription\":\"Back yard.jpg\",\"ResourceRecordKey\":\"NST7951559\",\"Order\":3,\"MediaObjectID\":\"NST3\",\"ImageWidth\":2080,\"ImageHeight\":1171,\"ImageSizeDescription\":\"2080x1171\",\"MediaModificationTimestamp\":\"2026-08-15T03:59:14.529Z\",\"MediaKey\":\"NST124279683\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7951559/1e8717db-960f-4344-b7f5-f1f739534fe3.jpeg\",\"LongDescription\":\"Full bath upper level.jpg\",\"ResourceRecordKey\":\"NST7951559\",\"Order\":12,\"MediaObjectID\":\"NST12\",\"ImageWidth\":2080,\"ImageHeight\":1171,\"ImageSizeDescription\":\"2080x1171\",\"MediaModificationTimestamp\":\"2026-08-15T04:01:16.48Z\",\"MediaKey\":\"NST124279692\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7951559/c9fcbea4-63f2-43ab-87f6-3c76f81baa35.jpeg\",\"LongDescription\":\"View from Living room.jpg\",\"ResourceRecordKey\":\"NST7951559\",\"Order\":5,\"MediaObjectID\":\"NST5\",\"ImageWidth\":2080,\"ImageHeight\":1171,\"ImageSizeDescription\":\"2080x1171\",\"MediaModificationTimestamp\":\"2026-08-15T03:59:14.544Z\",\"MediaKey\":\"NST124279685\"}]","Media__MediaURL":"https://s3.amazonaws.com/mlsgrid/images/NST7951559/e8b174a5-9fa9-4bf0-97fc-a125062ae2e4.jpeg","Media__LongDescription":"20260812_112030.jpg","Media__ResourceRecordKey":"NST7951559","Media__Order":"2","Media__MediaObjectID":"NST2","Media__ImageWidth":"2080","Media__ImageHeight":"1171","Media__ImageSizeDescription":"2080x1171","Media__MediaModificationTimestamp":"8/15/2026 3:59:14 AM","Media__MediaKey":"NST124279682","DocumentsChangeTimestamp":"2026-08-15T03:37:06.288Z","BodyOfWater":"[{\"NST_LakeChain\":\"N\",\"LakeAcres\":0,\"WaterBodyKey\":\"97108\",\"LakeDepth\":20,\"BodyOfWaterNumber\":\"02007501\",\"WaterBodyName\":\"East Moore\",\"NST_LakeClass\":\"Recreational Development\"}]","BodyOfWater__NST_LakeChain":"N","BodyOfWater__LakeAcres":"0","BodyOfWater__WaterBodyKey":"97108","BodyOfWater__LakeDepth":"20","BodyOfWater__BodyOfWaterNumber":"02007501","BodyOfWater__WaterBodyName":"East Moore","BodyOfWater__NST_LakeClass":"Recreational Development","Rooms":"[{\"RoomKey\":\"NST116572062\",\"RoomType\":\"Dining Room\",\"RoomDimensions\":\"9x6\",\"NST_RoomSortOrder\":2,\"RoomLevel\":\"Main\"},{\"RoomKey\":\"NST116572065\",\"RoomType\":\"Bedroom\",\"RoomDimensions\":\"12x11\",\"NST_RoomSortOrder\":4,\"RoomLevel\":\"Main\"},{\"RoomKey\":\"NST116572068\",\"RoomType\":\"Bedroom 4\",\"RoomDimensions\":\"12x24\",\"NST_RoomSortOrder\":7,\"RoomLevel\":\"Lower\"},{\"RoomKey\":\"NST116572064\",\"RoomType\":\"Kitchen\",\"RoomDimensions\":\"10x12\",\"NST_RoomSortOrder\":3,\"RoomLevel\":\"Main\"},{\"RoomKey\":\"NST116572061\",\"RoomType\":\"Living Room\",\"RoomDimensions\":\"15x17\",\"NST_RoomSortOrder\":1,\"RoomLevel\":\"Main\"},{\"RoomKey\":\"NST116572066\",\"RoomType\":\"Bedroom 2\",\"RoomDimensions\":\"12x9\",\"NST_RoomSortOrder\":5,\"RoomLevel\":\"Main\"},{\"RoomKey\":\"NST116572067\",\"RoomType\":\"Bedroom 3\",\"RoomDimensions\":\"10x10\",\"NST_RoomSortOrder\":6,\"RoomLevel\":\"Main\"}]","Rooms__RoomKey":"NST116572062","Rooms__RoomType":"Dining Room","Rooms__RoomDimensions":"9x6","Rooms__NST_RoomSortOrder":"2","Rooms__RoomLevel":"Main","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"Front.jpg\"},{\"Order\":2,\"Remarks\":\"20260812_112030.jpg\"},{\"Order\":3,\"Remarks\":\"Back yard.jpg\"},{\"Order\":4,\"Remarks\":\"Living room.jpg\"},{\"Order\":5,\"Remarks\":\"View from Living room.jpg\"},{\"Order\":6,\"Remarks\":\"Dinning room.jpg\"},{\"Order\":7,\"Remarks\":\"Kitchen.jpg\"},{\"Order\":8,\"Remarks\":\"Eat in kitchen.jpg\"},{\"Order\":9,\"Remarks\":\"Bedroom 1.jpg\"},{\"Order\":10,\"Remarks\":\"Bedroom 2.jpg\"},{\"Order\":11,\"Remarks\":\"Bedroom-2.jpg\"},{\"Order\":12,\"Remarks\":\"Full bath upper level.jpg\"},{\"Order\":13,\"Remarks\":\"Bedroom 3.jpg\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13","CustomVTourURL":""}
    ©2026, All rights reserved. Created with REC by AfterNorth.