Bay Lake Realty
Bruce Johnson
Broker/Owner
Bay Lake Realty is Licensed in the State of Minnesota
15929 Wakeman Rd.
Deerwood, MN 56444
Cell Phone: 218-838-1111
E-mail: bruce@baylakerealty.com
{"Id":574811,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST7095104","MLSAGENTID":"NST502012326","MLSOFFICEID":"NST4135","ADDRESS":"7004 139th Avenue NW","ACRES":0.0,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"None","BATHSTOTAL":2.0,"BEDROOMS":2.0,"CITY":"Ramsey","CONTINGENCY":"None","COUNTY":"Anoka","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"FORECLOSURE":"No","LASTPRICE":249900.0,"LASTPRICEDATE":"2026-06-18T22:01:07.587","LATITUDE":45.22152467,"LENDEROWNED":"No","LISTDATE":"2026-06-18T05:00:00","LISTPRICE":249900.0,"LIVINGAREA":1290.0,"LONGITUDE":-93.44457985,"LOTDESCRIPTION":"Irregular Lot","MODIFICATIONTIMESTAMP":"2026-06-19T14:37:07.483","OFFICE_OFFICENAME":"RE/MAX Results","PHOTOCOUNT":21,"POSTALCODE":"55303","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Discover the perfect blend of style and convenience in this inviting 2-bedroom, 2-bathroom townhome. Boasting nearly 1,300 square feet of meticulously updated living space, this move-in-ready gem features an attached 2-car garage and a prime location near top-tier schools,trails, shopping and dining. The interior shines with fresh paint and brand-new flooring throughout, creating a bright and modern atmosphere. Prepare meals with ease in the refreshed kitchen equipped with all new stainless steel appliances. The upper level offers ultimate functionality with a dedicated laundry area featuring a new washer and dryer, along with a spacious primary suite complete with a walk-in closet and a convenient pass-through en suite bath. Plus, enjoy added peace of mind with a brand-new garage door scheduled for installation on June 22, 2026. This stylish and functional townhome is ready for you to call it home!","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Asphalt","SCHOOLDISTRICTNUMBER":"11-Anoka-Hennepin","SCHOOLDISTRICTPHONE":"7635061000","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2026-06-18T22:01:07.587","LASTSTATUS":"Active","STREETDIRSUFFIX":"NW","STREETNAME":"139th","STREETNUMBER":"7004","STREETSUFFIX":"Avenue","STYLE":"(TH) Side x Side","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":2004,"ZONING":"Residential-Single Family","VIRTUALTOUR_URL1":"https://my.matterport.com/show/?m=k1frzQeTRMa&brand=0&mls=1&","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2026-06-18T22:34:06.85","PHOTOORDER":"1,5,6,7,8,10,14,15,20,26,28,31,32,33,34,35,36,37,38,39,40","SOURCE":"MG_NST"}
{"ListingKey":"NST7921011","NST_AboveGradeSqFtTotal":"1330","AboveGradeFinishedArea":"1290","AccessibilityFeatures":"No Stairs External","AdditionalParcelsYN":"False","NST_AgentOwner":"No","NST_AmenitiesUnit":"Cable,Ceiling Fan(s),Primary Bedroom Walk-In Closet,Natural Woodwork,Other,Patio,Washer/Dryer Hookup","Appliances":"None","LivingAreaUnits":"Square Feet","NST_AssessmentPending":"No","AssociationYN":"True","AssociationFee":"303","AssociationFeeFrequency":"Monthly","AssociationFeeIncludes":"Building Exterior,Hazard Insurance,Lawn Care,Other,Maintenance Grounds,Professional Mgmt","AssociationName":"RSP Management","AssociationPhone":"6122083779","Basement":"None","BasementYN":"False","NST_BathDesc":"Main Floor 1/2 Bath","BathroomsFull":"1","BathroomsHalf":"1","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"2","BedroomsTotal":"2","NST_BelowGradeSqFtTotal":"0","BelowGradeFinishedArea":"0","CumulativeDaysOnMarket":"0","City":"Ramsey","NewConstructionYN":"False","Contingency":"None","NST_ForSaleOrLease":"For Sale","Cooling":"Central Air","CountyOrParish":"Anoka","NST_DPResource":"Yes","Directions":"Hwy 10 to Fieldspan St S to 139th Ave L","DocumentsCount":"0","DaysOnMarket":"0","ExteriorFeatures":"Vinyl","FireplaceYN":"False","FireplacesTotal":"0","FoundationArea":"645","FoundationDetails":"Slab","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","NST_GarageSquareFeet":"340","NST_GarageDimensions":"17x20","GarageSpaces":"2","Heating":"Forced Air","HighSchoolDistrict":"Anoka-Hennepin","NST_ForeclosureStatus":"No","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"False","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","Latitude":"45.2215246696","NST_LenderOwned":"No","Levels":"Two","ListPrice":"249900","ListingContractDate":"2026-06-18T05:00:00Z","ListingId":"NST7095104","LivingArea":"1290","LockBoxType":"Combo","Longitude":"-93.4445798524","LotFeatures":"Irregular Lot","LotSizeArea":"0","LotSizeDimensions":"coommon","LotSizeUnits":"Acres","NST_MainLevelFinishedArea":"645","NST_ManufacturedHome":"N","OriginalEntryTimestamp":"2026-06-18T17:00:20Z","ParcelNumber":"343225230064","ParkingFeatures":"Attached Garage","PhotosCount":"21","PhotosChangeTimestamp":"2026-06-18T22:34:06.85Z","PostalCity":"Ramsey","PostalCode":"55303","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PropertyAttachedYN":"True","PropertySubType":"(TH) Side x Side","PropertyType":"Residential","PublicRemarks":"Discover the perfect blend of style and convenience in this inviting 2-bedroom, 2-bathroom townhome. Boasting nearly 1,300 square feet of meticulously updated living space, this move-in-ready gem features an attached 2-car garage and a prime location near top-tier schools,trails, shopping and dining. The interior shines with fresh paint and brand-new flooring throughout, creating a bright and modern atmosphere. Prepare meals with ease in the refreshed kitchen equipped with all new stainless steel appliances. The upper level offers ultimate functionality with a dedicated laundry area featuring a new washer and dryer, along with a spacious primary suite complete with a walk-in closet and a convenient pass-through en suite bath. Plus, enjoy added peace of mind with a brand-new garage door scheduled for installation on June 22, 2026. This stylish and functional townhome is ready for you to call it home!","Roof":"Asphalt","NST_SchoolDistrictFullName":"11 - Anoka-Hennepin","NST_SchoolDistrictNumber":"11","NST_SchoolDistrictPhone":"7635061000","Sewer":"City Sewer/Connected","NST_SingleFamilyTownhouseType":"Multi-Level","NST_SpecialSearch":"Rehabbed,Renovated","StandardStatus":"Active","StateOrProvince":"MN","StreetDirSuffix":"NW","StreetName":"139th","StreetNumber":"7004","StreetNumberNumeric":"7004","StreetSuffix":"Avenue","SubdivisionName":"The Cove at Mississippi West","TaxAnnualAmount":"1943.32","NST_TaxWithAssessments":"1943.32","TaxYear":"2026","NST_TotalArea":"1330","BuildingAreaTotal":"1330","Township":"Ramsey","VideosCount":"3","VideosChangeTimestamp":"2026-06-19T14:34:37Z","WaterSource":"City Water/Connected","WaterfrontYN":"False","YearBuilt":"2004","ZoningDescription":"Residential-Single Family","ListAgentKey":"NST44853","ListAgentMlsId":"NST502012326","ListOfficeMlsId":"NST4135","ListOfficeName":"RE/MAX Results","ListOfficeKey":"NST16716","VirtualTourURLUnbranded":"https://my.matterport.com/show/?m=k1frzQeTRMa&brand=0&mls=1&","NST_VirtualTourURLUnbranded2":"https://media.wonoverimages.com/sites/rjpjmggd/unbranded","ModificationTimestamp":"2026-06-19T14:37:07.483Z","OriginatingSystemName":"northstar","Media":"[{\"Order\":40,\"MediaObjectID\":\"NST40\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7921011/8e23535e-b04d-45ba-b6b1-5fe017d9c88e.jpeg\",\"ResourceRecordKey\":\"NST7921011\",\"ImageWidth\":2048,\"ImageHeight\":1536,\"ImageSizeDescription\":\"2048x1536\",\"MediaModificationTimestamp\":\"2026-06-18T22:31:09.672Z\",\"MediaKey\":\"NST123055287\"},{\"Order\":10,\"MediaObjectID\":\"NST10\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7921011/0056c1f3-571b-4d10-b440-7ee7cb3b7344.jpeg\",\"ResourceRecordKey\":\"NST7921011\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-06-18T22:31:09.714Z\",\"MediaKey\":\"NST123055297\"},{\"Order\":31,\"MediaObjectID\":\"NST31\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7921011/00499a00-32de-41a1-9645-f4ffb37b1345.jpeg\",\"ResourceRecordKey\":\"NST7921011\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-06-18T22:31:09.681Z\",\"MediaKey\":\"NST123055296\"},{\"Order\":38,\"MediaObjectID\":\"NST38\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7921011/5ddd3158-f171-4ac5-9aef-d25c1e5fa3f0.jpeg\",\"ResourceRecordKey\":\"NST7921011\",\"ImageWidth\":2048,\"ImageHeight\":1536,\"ImageSizeDescription\":\"2048x1536\",\"MediaModificationTimestamp\":\"2026-06-18T22:31:09.673Z\",\"MediaKey\":\"NST123055289\"},{\"Order\":35,\"MediaObjectID\":\"NST35\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7921011/71528723-641b-49fc-9127-a88dbfa59d05.jpeg\",\"ResourceRecordKey\":\"NST7921011\",\"ImageWidth\":2048,\"ImageHeight\":1536,\"ImageSizeDescription\":\"2048x1536\",\"MediaModificationTimestamp\":\"2026-06-18T22:31:09.712Z\",\"MediaKey\":\"NST123055292\"},{\"Order\":1,\"MediaObjectID\":\"NST1\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7921011/c55cc5cf-fffc-47d8-bd27-dc9158f3be80.jpeg\",\"ResourceRecordKey\":\"NST7921011\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-06-18T22:33:08.401Z\",\"MediaKey\":\"NST123055333\"},{\"Order\":28,\"MediaObjectID\":\"NST28\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7921011/7d2f9daa-dce4-47e0-a656-e722c58e90b9.jpeg\",\"ResourceRecordKey\":\"NST7921011\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-06-18T22:31:09.667Z\",\"MediaKey\":\"NST123055301\"},{\"Order\":15,\"MediaObjectID\":\"NST15\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7921011/0aff011b-b0f4-4f8c-9fb5-31782d9e3ca7.jpeg\",\"ResourceRecordKey\":\"NST7921011\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-06-18T22:33:08.371Z\",\"MediaKey\":\"NST123055316\"},{\"Order\":6,\"MediaObjectID\":\"NST6\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7921011/13f9bf51-29a3-4545-ab01-b3b45d2903fc.jpeg\",\"ResourceRecordKey\":\"NST7921011\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-06-18T22:33:08.403Z\",\"MediaKey\":\"NST123055319\"},{\"Order\":36,\"MediaObjectID\":\"NST36\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7921011/a0ac8d10-21fd-400e-b2fa-ac2af8701923.jpeg\",\"ResourceRecordKey\":\"NST7921011\",\"ImageWidth\":2048,\"ImageHeight\":1536,\"ImageSizeDescription\":\"2048x1536\",\"MediaModificationTimestamp\":\"2026-06-18T22:31:09.679Z\",\"MediaKey\":\"NST123055291\"},{\"Order\":37,\"MediaObjectID\":\"NST37\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7921011/1c2bb75c-1ea3-4c85-bae3-ceff651640d8.jpeg\",\"ResourceRecordKey\":\"NST7921011\",\"ImageWidth\":2048,\"ImageHeight\":1536,\"ImageSizeDescription\":\"2048x1536\",\"MediaModificationTimestamp\":\"2026-06-18T22:31:09.781Z\",\"MediaKey\":\"NST123055290\"},{\"Order\":33,\"MediaObjectID\":\"NST33\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7921011/639c344e-dfd3-47cb-8475-630e3cb4fc07.jpeg\",\"ResourceRecordKey\":\"NST7921011\",\"ImageWidth\":2048,\"ImageHeight\":1536,\"ImageSizeDescription\":\"2048x1536\",\"MediaModificationTimestamp\":\"2026-06-18T22:31:09.69Z\",\"MediaKey\":\"NST123055294\"},{\"Order\":32,\"MediaObjectID\":\"NST32\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7921011/bda655d2-e476-4317-bbd5-35c26769acc2.jpeg\",\"ResourceRecordKey\":\"NST7921011\",\"ImageWidth\":2048,\"ImageHeight\":1536,\"ImageSizeDescription\":\"2048x1536\",\"MediaModificationTimestamp\":\"2026-06-18T22:31:09.691Z\",\"MediaKey\":\"NST123055295\"},{\"Order\":34,\"MediaObjectID\":\"NST34\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7921011/ba4eadd4-b4ae-42af-b33a-fe521e144deb.jpeg\",\"ResourceRecordKey\":\"NST7921011\",\"ImageWidth\":2048,\"ImageHeight\":1536,\"ImageSizeDescription\":\"2048x1536\",\"MediaModificationTimestamp\":\"2026-06-18T22:31:09.703Z\",\"MediaKey\":\"NST123055293\"},{\"Order\":7,\"MediaObjectID\":\"NST7\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7921011/1343867e-4593-4ec9-828b-975bfafe20fa.jpeg\",\"ResourceRecordKey\":\"NST7921011\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-06-18T22:33:08.402Z\",\"MediaKey\":\"NST123055317\"},{\"Order\":5,\"MediaObjectID\":\"NST5\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7921011/81994fb6-c670-468b-bd88-1e59b67c9873.jpeg\",\"ResourceRecordKey\":\"NST7921011\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-06-18T22:33:08.389Z\",\"MediaKey\":\"NST123055325\"},{\"Order\":14,\"MediaObjectID\":\"NST14\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7921011/117c8a6d-5b9d-4112-9ca8-f3ff0392a122.jpeg\",\"ResourceRecordKey\":\"NST7921011\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-06-18T22:33:08.382Z\",\"MediaKey\":\"NST123055318\"},{\"Order\":26,\"MediaObjectID\":\"NST26\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7921011/5b79346b-b04f-41f2-ae39-c1f42a1d113d.jpeg\",\"ResourceRecordKey\":\"NST7921011\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-06-18T22:31:09.699Z\",\"MediaKey\":\"NST123055303\"},{\"Order\":20,\"MediaObjectID\":\"NST20\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7921011/c535abc5-f686-4840-bbf8-539f6a47d646.jpeg\",\"ResourceRecordKey\":\"NST7921011\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-06-18T22:33:08.391Z\",\"MediaKey\":\"NST123055310\"},{\"Order\":39,\"MediaObjectID\":\"NST39\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7921011/15187526-d932-4b31-bddb-4b7a3a2b6307.jpeg\",\"ResourceRecordKey\":\"NST7921011\",\"ImageWidth\":2048,\"ImageHeight\":1536,\"ImageSizeDescription\":\"2048x1536\",\"MediaModificationTimestamp\":\"2026-06-18T22:31:09.691Z\",\"MediaKey\":\"NST123055288\"},{\"Order\":8,\"MediaObjectID\":\"NST8\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7921011/377b90f3-ab3b-424c-9e46-257a28a7e6b7.jpeg\",\"ResourceRecordKey\":\"NST7921011\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-06-18T22:33:08.428Z\",\"MediaKey\":\"NST123055306\"}]","Media__Order":"40","Media__MediaObjectID":"NST40","Media__MediaURL":"https://s3.amazonaws.com/mlsgrid/images/NST7921011/8e23535e-b04d-45ba-b6b1-5fe017d9c88e.jpeg","Media__ResourceRecordKey":"NST7921011","Media__ImageWidth":"2048","Media__ImageHeight":"1536","Media__ImageSizeDescription":"2048x1536","Media__MediaModificationTimestamp":"6/18/2026 10:31:09 PM","Media__MediaKey":"NST123055287","DocumentsChangeTimestamp":"2026-06-18T22:01:07.588Z","Rooms":"[{\"RoomKey\":\"NST116367934\",\"NST_RoomSortOrder\":2,\"RoomType\":\"Dining Room\",\"RoomLevel\":\"Main\"},{\"RoomKey\":\"NST116367936\",\"RoomDimensions\":\"18x12\",\"NST_RoomSortOrder\":5,\"RoomType\":\"Bedroom\",\"RoomLevel\":\"Upper\"},{\"RoomKey\":\"NST116367935\",\"NST_RoomSortOrder\":4,\"RoomType\":\"Kitchen\",\"RoomLevel\":\"Main\"},{\"RoomKey\":\"NST116370458\",\"RoomDimensions\":\"6x6\",\"NST_RoomSortOrder\":7,\"RoomType\":\"Laundry\",\"RoomLevel\":\"Upper\"},{\"RoomKey\":\"NST116367933\",\"RoomDimensions\":\"19x12\",\"NST_RoomSortOrder\":1,\"RoomType\":\"Living Room\"},{\"RoomKey\":\"NST116367938\",\"RoomDimensions\":\"23x10\",\"NST_RoomSortOrder\":6,\"RoomType\":\"Loft\",\"RoomLevel\":\"Upper\"},{\"RoomKey\":\"NST116367937\",\"RoomDimensions\":\"14x10\",\"NST_RoomSortOrder\":6,\"RoomType\":\"Bedroom 2\",\"RoomLevel\":\"Upper\"}]","Rooms__RoomKey":"NST116367934","Rooms__NST_RoomSortOrder":"2","Rooms__RoomType":"Dining Room","Rooms__RoomLevel":"Main","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"","PhotoOrder":"1,5,6,7,8,10,14,15,20,26,28,31,32,33,34,35,36,37,38,39,40","CustomVTourURL":""}