• Home
  • Hot Listings
  • Notifications
  • Favorites
  • Blog

MLS# 7097203 - 5317 140th Avenue NW Ramsey, MN 55303

Neighborhoods

Opendoor Brokerage, LLC 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. Mark Tietjen - Rusty's Up North Realty is not a multiple Listing Service (MLS), nor does it offer MLS access. This website is a service of Mark Tietjen - Rusty's Up North Realty, a broker Participant of the Regional Multiple Listing Service of Minnesota, Inc.

{"Id":576486,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST7097203","MLSAGENTID":"NST798549702","MLSCOAGENTID":"NST506008353","MLSOFFICEID":"NST26320","ADDRESS":"5317 140th Avenue NW","ACRES":0.05,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Finished","BATHSTOTAL":2.0,"BEDROOMS":2.0,"CITY":"Ramsey","CONTINGENCY":"None","COUNTY":"Anoka","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"FORECLOSURE":"No","LASTPRICE":295000.0,"LASTPRICEDATE":"2026-06-23T16:37:07.59","LATITUDE":45.224986,"LENDEROWNED":"No","LISTDATE":"2026-06-23T05:00:00","LISTPRICE":295000.0,"LIVINGAREA":1588.0,"LONGITUDE":-93.40161,"MODIFICATIONTIMESTAMP":"2026-06-24T09:19:10.966","OFFICE_OFFICENAME":"Opendoor Brokerage, LLC","PHOTOCOUNT":18,"POSTALCODE":"55303","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Experience 5317 140th Ave NW, a thoughtfully refreshed residence that now features fresh interior paint, creating a bright and inviting atmosphere, alongside a partial flooring replacement in key areas, which collectively enhances the home's contemporary appeal and ensures a streamlined transition for its occupants into a well-maintained living space. Discover this updated home, blending fresh style and effortless comfort. Included 100-Day Home Warranty with buyer activation","ROADBETWEENWATERFRONTANDHOMEYN":false,"SCHOOLDISTRICTNUMBER":"11-Anoka-Hennepin","SCHOOLDISTRICTPHONE":"7635061000","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2026-06-23T16:37:07.59","LASTSTATUS":"Active","STREETDIRSUFFIX":"NW","STREETNAME":"140th","STREETNUMBER":"5317","STREETSUFFIX":"Avenue","STYLE":"(TH) Side x Side","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":2001,"ZONING":"Residential-Single Family","HASOPENHOUSE":true,"PHOTOTIMESTAMP":"2026-06-23T17:07:07.576","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"photo_01.jpg\"},{\"Order\":2,\"Remarks\":\"photo_02.jpg\"},{\"Order\":3,\"Remarks\":\"photo_03.jpg\"},{\"Order\":4,\"Remarks\":\"photo_04.jpg\"},{\"Order\":5,\"Remarks\":\"photo_05.jpg\"},{\"Order\":6,\"Remarks\":\"photo_06.jpg\"},{\"Order\":7,\"Remarks\":\"photo_07.jpg\"},{\"Order\":8,\"Remarks\":\"photo_08.jpg\"},{\"Order\":9,\"Remarks\":\"photo_09.jpg\"},{\"Order\":10,\"Remarks\":\"photo_10.jpg\"},{\"Order\":11,\"Remarks\":\"photo_11.jpg\"},{\"Order\":12,\"Remarks\":\"photo_12.jpg\"},{\"Order\":13,\"Remarks\":\"photo_13.jpg\"},{\"Order\":14,\"Remarks\":\"photo_14.jpg\"},{\"Order\":15,\"Remarks\":\"photo_15.jpg\"},{\"Order\":16,\"Remarks\":\"photo_16.jpg\"},{\"Order\":17,\"Remarks\":\"photo_17.jpg\"},{\"Order\":18,\"Remarks\":\"5317 140th Ave NW.jpg\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18","SOURCE":"MG_NST"}
{"ListingKey":"NST7922847","NST_AboveGradeSqFtTotal":"826","AboveGradeFinishedArea":"881","AccessibilityFeatures":"None","AdditionalParcelsYN":"False","NST_AgentOwner":"No","LivingAreaUnits":"Square Feet","NST_AssessmentPending":"Unknown","AssociationYN":"True","AssociationFee":"262","AssociationFeeFrequency":"Monthly","AssociationFeeIncludes":"Maintenance Grounds","AssociationName":"Bullseye Property Management","AssociationPhone":"7632956566","Basement":"Finished","BasementYN":"True","BathroomsFull":"2","BathroomsHalf":"0","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"2","BedroomsTotal":"2","NST_BelowGradeSqFtTotal":"865","BelowGradeFinishedArea":"707","CumulativeDaysOnMarket":"0","CarportSpaces":"0","City":"Ramsey","NewConstructionYN":"False","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Anoka","NST_DPResource":"Yes","Directions":"Head toward St Francis Blvd NW\nTurn right onto Dysprosium St NW\nTurn right onto 140th Ln NW\nTurn right onto 140th Ave NW","DocumentsCount":"1","DocumentsChangeTimestamp":"2026-06-23T16:34:08.71Z","DaysOnMarket":"0","ExteriorFeatures":"Vinyl","FireplaceYN":"False","FireplacesTotal":"0","FoundationArea":"865","FoundationDetails":"Other","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","NST_GarageSquareFeet":"414","GarageSpaces":"2","Heating":"Forced Air","HighSchoolDistrict":"Anoka-Hennepin","NST_ForeclosureStatus":"No","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"False","InternetConsumerCommentYN":"False","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","Latitude":"45.224986","NST_LenderOwned":"No","Levels":"Split Entry (Bi-Level)","ListPrice":"295000","ListingContractDate":"2026-06-23T05:00:00Z","ListingId":"NST7097203","LivingArea":"1588","Longitude":"-93.40161","LotSizeArea":"0.05","LotSizeDimensions":"0","LotSizeUnits":"Acres","NST_MainLevelFinishedArea":"881","NST_ManufacturedHome":"N","OriginalEntryTimestamp":"2026-06-23T11:33:45Z","ParcelNumber":"363225210168","ParkingFeatures":"Tuckunder Garage","PhotosCount":"18","PhotosChangeTimestamp":"2026-06-23T17:07:07.576Z","PostalCity":"Ramsey","PostalCode":"55303","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PropertyAttachedYN":"True","PropertySubType":"(TH) Side x Side","PropertyType":"Residential","PublicRemarks":"Experience 5317 140th Ave NW, a thoughtfully refreshed residence that now features fresh interior paint, creating a bright and inviting atmosphere, alongside a partial flooring replacement in key areas, which collectively enhances the home's contemporary appeal and ensures a streamlined transition for its occupants into a well-maintained living space. Discover this updated home, blending fresh style and effortless comfort. Included 100-Day Home Warranty with buyer activation","PublicSurveyRange":"25","PublicSurveySection":"36","PublicSurveyTownship":"32","NST_SchoolDistrictFullName":"11 - Anoka-Hennepin","NST_SchoolDistrictNumber":"11","NST_SchoolDistrictPhone":"7635061000","Sewer":"City Sewer/Connected","NST_SingleFamilyTownhouseType":"End Unit","StandardStatus":"Active","StateOrProvince":"MN","StreetDirSuffix":"NW","StreetName":"140th","StreetNumber":"5317","StreetNumberNumeric":"5317","StreetSuffix":"Avenue","SubdivisionName":"Cic 81 Mallard Ponds","TaxAnnualAmount":"2574","NST_TaxWithAssessments":"2574","TaxYear":"2026","NST_TotalArea":"1691","BuildingAreaTotal":"1691","Township":"Ramsey","VideosCount":"0","WaterSource":"City Water/Connected","WaterfrontYN":"False","YearBuilt":"2001","ZoningDescription":"Residential-Single Family","CoListAgentKey":"NST97067","CoListAgentMlsId":"NST506008353","CoListOfficeName":"Opendoor Brokerage, LLC","ListAgentKey":"NST225984","ListAgentMlsId":"NST798549702","ListOfficeMlsId":"NST26320","ListOfficeName":"Opendoor Brokerage, LLC","ListOfficeKey":"NST26320","ModificationTimestamp":"2026-06-24T09:19:10.966Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7922847\",\"Order\":16,\"MediaObjectID\":\"NST16\",\"LongDescription\":\"photo_16.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7922847/747f2741-e9cd-4ba5-8db0-a1c1507aebb5.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1553,\"ImageSizeDescription\":\"2080x1553\",\"MediaModificationTimestamp\":\"2026-06-23T17:06:10.623Z\",\"MediaKey\":\"NST123150871\"},{\"ResourceRecordKey\":\"NST7922847\",\"Order\":12,\"MediaObjectID\":\"NST12\",\"LongDescription\":\"photo_12.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7922847/2845730a-c89b-4552-a9cd-001ff3f3bbc1.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1553,\"ImageSizeDescription\":\"2080x1553\",\"MediaModificationTimestamp\":\"2026-06-23T17:06:10.592Z\",\"MediaKey\":\"NST123150875\"},{\"ResourceRecordKey\":\"NST7922847\",\"Order\":10,\"MediaObjectID\":\"NST10\",\"LongDescription\":\"photo_10.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7922847/1a1cce31-59ff-4eab-9a3a-3f6c0dff5f11.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1553,\"ImageSizeDescription\":\"2080x1553\",\"MediaModificationTimestamp\":\"2026-06-23T17:06:10.638Z\",\"MediaKey\":\"NST123150877\"},{\"ResourceRecordKey\":\"NST7922847\",\"Order\":2,\"MediaObjectID\":\"NST2\",\"LongDescription\":\"photo_02.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7922847/c79df6d4-bea5-4aa5-becc-f295304efeb9.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1553,\"ImageSizeDescription\":\"2080x1553\",\"MediaModificationTimestamp\":\"2026-06-23T17:06:10.583Z\",\"MediaKey\":\"NST123150885\"},{\"ResourceRecordKey\":\"NST7922847\",\"Order\":17,\"MediaObjectID\":\"NST17\",\"LongDescription\":\"photo_17.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7922847/06abcd12-92c5-4e4c-b9f3-c859fa8b8fc1.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1553,\"ImageSizeDescription\":\"2080x1553\",\"MediaModificationTimestamp\":\"2026-06-23T17:06:10.631Z\",\"MediaKey\":\"NST123150870\"},{\"ResourceRecordKey\":\"NST7922847\",\"Order\":4,\"MediaObjectID\":\"NST4\",\"LongDescription\":\"photo_04.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7922847/4ae015ed-8626-4105-895c-a3ad1275d810.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1553,\"ImageSizeDescription\":\"2080x1553\",\"MediaModificationTimestamp\":\"2026-06-23T17:06:10.586Z\",\"MediaKey\":\"NST123150883\"},{\"ResourceRecordKey\":\"NST7922847\",\"Order\":13,\"MediaObjectID\":\"NST13\",\"LongDescription\":\"photo_13.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7922847/07488cc0-e248-40d1-8474-d042eb48b287.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1553,\"ImageSizeDescription\":\"2080x1553\",\"MediaModificationTimestamp\":\"2026-06-23T17:06:10.583Z\",\"MediaKey\":\"NST123150874\"},{\"ResourceRecordKey\":\"NST7922847\",\"Order\":11,\"MediaObjectID\":\"NST11\",\"LongDescription\":\"photo_11.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7922847/7e76530f-44c5-4a9b-9af3-800bbce53dde.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1553,\"ImageSizeDescription\":\"2080x1553\",\"MediaModificationTimestamp\":\"2026-06-23T17:06:10.583Z\",\"MediaKey\":\"NST123150876\"},{\"ResourceRecordKey\":\"NST7922847\",\"Order\":9,\"MediaObjectID\":\"NST9\",\"LongDescription\":\"photo_09.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7922847/605f8cfc-ef2a-47f2-a8ff-cf72f9f41375.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1553,\"ImageSizeDescription\":\"2080x1553\",\"MediaModificationTimestamp\":\"2026-06-23T17:06:10.621Z\",\"MediaKey\":\"NST123150878\"},{\"ResourceRecordKey\":\"NST7922847\",\"Order\":15,\"MediaObjectID\":\"NST15\",\"LongDescription\":\"photo_15.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7922847/66f1beae-62e1-4468-b5fe-432abc9a7b29.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1553,\"ImageSizeDescription\":\"2080x1553\",\"MediaModificationTimestamp\":\"2026-06-23T17:06:10.675Z\",\"MediaKey\":\"NST123150872\"},{\"ResourceRecordKey\":\"NST7922847\",\"Order\":18,\"MediaObjectID\":\"NST18\",\"LongDescription\":\"5317 140th Ave NW.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7922847/ee598f47-f613-4f58-a686-ea67bafde901.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1170,\"ImageSizeDescription\":\"2080x1170\",\"MediaModificationTimestamp\":\"2026-06-23T17:06:10.582Z\",\"MediaKey\":\"NST123150963\"},{\"ResourceRecordKey\":\"NST7922847\",\"Order\":5,\"MediaObjectID\":\"NST5\",\"LongDescription\":\"photo_05.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7922847/906fe2a6-22c2-4927-b2a9-79f1a021a304.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1553,\"ImageSizeDescription\":\"2080x1553\",\"MediaModificationTimestamp\":\"2026-06-23T17:06:10.583Z\",\"MediaKey\":\"NST123150882\"},{\"ResourceRecordKey\":\"NST7922847\",\"Order\":14,\"MediaObjectID\":\"NST14\",\"LongDescription\":\"photo_14.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7922847/a3338967-0597-4faf-ad58-e91ecde98b03.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1553,\"ImageSizeDescription\":\"2080x1553\",\"MediaModificationTimestamp\":\"2026-06-23T17:06:10.584Z\",\"MediaKey\":\"NST123150873\"},{\"ResourceRecordKey\":\"NST7922847\",\"Order\":3,\"MediaObjectID\":\"NST3\",\"LongDescription\":\"photo_03.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7922847/c2e650fc-bbbe-42c0-99f2-f232bfd4ac60.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1553,\"ImageSizeDescription\":\"2080x1553\",\"MediaModificationTimestamp\":\"2026-06-23T17:06:10.655Z\",\"MediaKey\":\"NST123150884\"},{\"ResourceRecordKey\":\"NST7922847\",\"Order\":6,\"MediaObjectID\":\"NST6\",\"LongDescription\":\"photo_06.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7922847/6b2a1320-3900-437c-9d3d-a443cd307564.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1553,\"ImageSizeDescription\":\"2080x1553\",\"MediaModificationTimestamp\":\"2026-06-23T17:06:10.557Z\",\"MediaKey\":\"NST123150881\"},{\"ResourceRecordKey\":\"NST7922847\",\"Order\":8,\"MediaObjectID\":\"NST8\",\"LongDescription\":\"photo_08.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7922847/27024ae7-a05c-42d2-8266-211387fc0304.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1553,\"ImageSizeDescription\":\"2080x1553\",\"MediaModificationTimestamp\":\"2026-06-23T17:06:10.653Z\",\"MediaKey\":\"NST123150879\"},{\"ResourceRecordKey\":\"NST7922847\",\"Order\":7,\"MediaObjectID\":\"NST7\",\"LongDescription\":\"photo_07.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7922847/e08eebdb-6223-495c-927e-2d5ff7d8e7a3.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1553,\"ImageSizeDescription\":\"2080x1553\",\"MediaModificationTimestamp\":\"2026-06-23T17:06:10.646Z\",\"MediaKey\":\"NST123150880\"},{\"ResourceRecordKey\":\"NST7922847\",\"Order\":1,\"MediaObjectID\":\"NST1\",\"LongDescription\":\"photo_01.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7922847/44ac5376-9ab6-4e76-90d4-1ee1534d6195.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1553,\"ImageSizeDescription\":\"2080x1553\",\"MediaModificationTimestamp\":\"2026-06-23T17:06:10.621Z\",\"MediaKey\":\"NST123150886\"}]","Media__ResourceRecordKey":"NST7922847","Media__Order":"16","Media__MediaObjectID":"NST16","Media__LongDescription":"photo_16.jpg","Media__MediaURL":"https://s3.amazonaws.com/mlsgrid/images/NST7922847/747f2741-e9cd-4ba5-8db0-a1c1507aebb5.jpeg","Media__ImageWidth":"2080","Media__ImageHeight":"1553","Media__ImageSizeDescription":"2080x1553","Media__MediaModificationTimestamp":"6/23/2026 5:06:10 PM","Media__MediaKey":"NST123150871","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"photo_01.jpg\"},{\"Order\":2,\"Remarks\":\"photo_02.jpg\"},{\"Order\":3,\"Remarks\":\"photo_03.jpg\"},{\"Order\":4,\"Remarks\":\"photo_04.jpg\"},{\"Order\":5,\"Remarks\":\"photo_05.jpg\"},{\"Order\":6,\"Remarks\":\"photo_06.jpg\"},{\"Order\":7,\"Remarks\":\"photo_07.jpg\"},{\"Order\":8,\"Remarks\":\"photo_08.jpg\"},{\"Order\":9,\"Remarks\":\"photo_09.jpg\"},{\"Order\":10,\"Remarks\":\"photo_10.jpg\"},{\"Order\":11,\"Remarks\":\"photo_11.jpg\"},{\"Order\":12,\"Remarks\":\"photo_12.jpg\"},{\"Order\":13,\"Remarks\":\"photo_13.jpg\"},{\"Order\":14,\"Remarks\":\"photo_14.jpg\"},{\"Order\":15,\"Remarks\":\"photo_15.jpg\"},{\"Order\":16,\"Remarks\":\"photo_16.jpg\"},{\"Order\":17,\"Remarks\":\"photo_17.jpg\"},{\"Order\":18,\"Remarks\":\"5317 140th Ave NW.jpg\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18","CustomVTourURL":""}