$LABEL$
$CONTENT$
$LABEL$
$CONTENT$
Kelly's Diamond Realty 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. LongvilleLakes.com is not a multiple Listing Service (MLS), nor does it offer MLS access. This website is a service of LongvilleLakes.com, a broker Participant of the Regional Multiple Listing Service of Minnesota, Inc.
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. LongvilleLakes.com is not a multiple Listing Service (MLS), nor does it offer MLS access. This website is a service of LongvilleLakes.com, a broker Participant of the Regional Multiple Listing Service of Minnesota, Inc.
Nearby Listings in 10 Miles
{"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":""}