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":1429864,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST6815247","MLSAGENTID":"NST798549702","MLSCOAGENTID":"NST90099065","MLSOFFICEID":"NST26320","ADDRESS":"2306 Beam Avenue","ACRES":0.2,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Finished","BATHSTOTAL":1.0,"BEDROOMS":3,"CITY":"North Saint Paul","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Vinyl Siding","FORECLOSURE":"No","LASTPRICE":313000.0,"LASTPRICEDATE":"2025-11-07T17:06:04.273","LATITUDE":45.027908,"LENDEROWNED":"No","LISTDATE":"2025-11-07T06:00:00","LISTPRICE":313000.0,"LIVINGAREA":1008.0,"LONGITUDE":-93.00313,"MODIFICATIONTIMESTAMP":"2025-11-08T21:21:03.658","OFFICE_OFFICENAME":"Opendoor Brokerage, LLC","PHOTOCOUNT":15,"POSTALCODE":"55109","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Welcome to this charming property that is sure to captivate you. This outdoor space is perfect for enjoying a morning coffee or an evening under the stars. This property is a true gem, offering a unique blend of indoor comfort and outdoor enjoyment. Don't miss out on the opportunity to make this your new home. This home has been virtually staged to illustrate its potential.. Included 100-Day Home Warranty with buyer activation","ROADBETWEENWATERFRONTANDHOMEYN":false,"SCHOOLDISTRICTNUMBER":"622-North St Paul-Maplewood","SCHOOLDISTRICTPHONE":"651-748-7410","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2025-11-07T17:06:04.273","LASTSTATUS":"Active","STREETNAME":"Beam","STREETNUMBER":"2306","STREETSUFFIX":"Avenue","STYLE":"Single Family Residence","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1959,"ZONING":"Residential-Single Family","PHOTOTIMESTAMP":"2025-11-07T17:10:04.08","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"listing_0.jpg\"},{\"Order\":2,\"Remarks\":\"VIRTUALLY STAGED\"},{\"Order\":3,\"Remarks\":\"listing_2.jpg\"},{\"Order\":4,\"Remarks\":\"VIRTUALLY STAGED\"},{\"Order\":5,\"Remarks\":\"listing_4.jpg\"},{\"Order\":6,\"Remarks\":\"listing_5.jpg\"},{\"Order\":7,\"Remarks\":\"listing_6.jpg\"},{\"Order\":8,\"Remarks\":\"listing_7.jpg\"},{\"Order\":9,\"Remarks\":\"listing_8.jpg\"},{\"Order\":10,\"Remarks\":\"listing_9.jpg\"},{\"Order\":11,\"Remarks\":\"listing_10.jpg\"},{\"Order\":12,\"Remarks\":\"listing_11.jpg\"},{\"Order\":13,\"Remarks\":\"listing_12.jpg\"},{\"Order\":14,\"Remarks\":\"listing_13.jpg\"},{\"Order\":15,\"Remarks\":\"listing_14.jpg\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15","SOURCE":"MG_NST"}
{"ListingKey":"NST7825209","LotSizeArea":"0.2","NST_AgeOfProperty":"66","NST_AgentOwner":"No","InternetAutomatedValuationDisplayYN":"False","InternetConsumerCommentYN":"False","NST_AssessmentPending":"Unknown","AssociationYN":"False","AssociationFee":"0","PropertyAttachedYN":"False","Basement":"Finished","BasementYN":"True","BathroomsOneQuarter":"0","BathroomsFull":"1","BathroomsHalf":"0","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"1","BedroomsTotal":"3","CarportSpaces":"0","City":"North Saint Paul","PropertyType":"Residential","NewConstructionYN":"False","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Ramsey","NST_DPResource":"Y","DaysOnMarket":"1","CumulativeDaysOnMarket":"1","Directions":"Head north on Division St N/Geneva Ave N toward MN-36 W\nTurn left onto 17th Ave E\nTurn right onto Helen St N\nTurn left onto Beam Ave","InternetAddressDisplayYN":"True","InternetEntireListingDisplayYN":"True","ConstructionMaterials":"Vinyl Siding","FireplaceYN":"False","FireplacesTotal":"0","NST_ForeclosureStatus":"No","FoundationArea":"924","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","ParkingFeatures":"Detached","NST_GarageSquareFeet":"528","AccessibilityFeatures":"None","Heating":"Forced Air","OriginalEntryTimestamp":"2025-11-07T17:03:51Z","LandLeaseYN":"False","NST_LastUpdateDate":"2025-11-08","Latitude":"45.027908","NST_LenderOwned":"No","ListAgentKey":"NST225984","ListAgentMlsId":"NST798549702","CoListAgentKey":"NST86971","CoListAgentMlsId":"NST90099065","ListingContractDate":"2025-11-07T06:00:00Z","ListOfficeKey":"NST26320","ListOfficeName":"Opendoor Brokerage, LLC","ListOfficeMlsId":"NST26320","ListPrice":"313000","LivingArea":"1008","Longitude":"-93.00313","LotSizeDimensions":"76*113","LotSizeSquareFeet":"8668.44","LotSizeUnits":"Acres","ListingId":"NST6815247","SourceSystemName":"RMLS","NST_ManufacturedHome":"No","MapCoordinateSource":"King's Street Atlas","AdditionalParcelsYN":"False","NST_OfficeBoard":"MAAR","ParcelNumber":"012922320017","GarageSpaces":"2","PhotosCount":"15","PostalCity":"North Saint Paul","PostalCode":"55109","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PublicRemarks":"Welcome to this charming property that is sure to captivate you. This outdoor space is perfect for enjoying a morning coffee or an evening under the stars. This property is a true gem, offering a unique blend of indoor comfort and outdoor enjoyment. Don't miss out on the opportunity to make this your new home. This home has been virtually staged to illustrate its potential.. Included 100-Day Home Warranty with buyer activation","PublicSurveyRange":"22","PublicSurveySection":"01","PublicSurveyTownship":"29","NST_RentalLicenseYN":"No","NST_AboveGradeSqFtTotal":"1008.0000","NST_BelowGradeSqFtTotal":"924.0000","NST_MainLevelFinishedArea":"1008.0000","BuildingAreaTotal":"1932","HighSchoolDistrict":"North St Paul-Maplewood","NST_SchoolDistrictNumber":"622","NST_SchoolDistrictPhone":"651-748-7410","Sewer":"City Sewer/Connected","AboveGradeFinishedArea":"1008","BelowGradeFinishedArea":"0","StateOrProvince":"MN","StandardStatus":"Active","Levels":"One","StreetName":"Beam","StreetNumber":"2306","StreetNumberNumeric":"2306","StreetSuffix":"Avenue","PropertySubType":"Single Family Residence","SubdivisionName":"Saratoga Hills 2","NST_TaxWithAssessments":"3928.0000","TaxYear":"2025","TaxAnnualAmount":"3928","WaterSource":"City Water/Connected","YearBuilt":"1959","ZoningDescription":"Residential-Single Family","ModificationTimestamp":"2025-11-08T21:21:03.658Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7825209\",\"Order\":1,\"MediaObjectID\":\"1\",\"LongDescription\":\"listing_0.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1558,\"ImageSizeDescription\":\"2080x1558\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7825209/a9ff2267-bf1a-4d7f-8216-c5d18446b910.jpeg\",\"MediaModificationTimestamp\":\"2025-11-07T17:09:04.521Z\",\"MediaKey\":\"690e27b04f94022caa1d250b\"},{\"ResourceRecordKey\":\"NST7825209\",\"Order\":2,\"MediaObjectID\":\"2\",\"LongDescription\":\"VIRTUALLY STAGED\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7825209/a9f1ec44-4cae-4bea-a428-9fb92f7530a1.jpeg\",\"MediaModificationTimestamp\":\"2025-11-07T17:09:04.509Z\",\"MediaKey\":\"690e27b04f94022caa1d250c\"},{\"ResourceRecordKey\":\"NST7825209\",\"Order\":3,\"MediaObjectID\":\"3\",\"LongDescription\":\"listing_2.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7825209/a350ce5f-62a0-4c71-88ee-8ff8043a9020.jpeg\",\"MediaModificationTimestamp\":\"2025-11-07T17:09:04.526Z\",\"MediaKey\":\"690e27b04f94022caa1d250d\"},{\"ResourceRecordKey\":\"NST7825209\",\"Order\":4,\"MediaObjectID\":\"4\",\"LongDescription\":\"VIRTUALLY STAGED\",\"ImageWidth\":2080,\"ImageHeight\":1559,\"ImageSizeDescription\":\"2080x1559\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7825209/af72f5e3-fc62-4bf4-b3a7-bcb25efc4909.jpeg\",\"MediaModificationTimestamp\":\"2025-11-07T17:09:04.529Z\",\"MediaKey\":\"690e27b04f94022caa1d250e\"},{\"ResourceRecordKey\":\"NST7825209\",\"Order\":5,\"MediaObjectID\":\"5\",\"LongDescription\":\"listing_4.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1562,\"ImageSizeDescription\":\"2080x1562\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7825209/ca6daebf-3c79-4000-9d7a-319ded28e273.jpeg\",\"MediaModificationTimestamp\":\"2025-11-07T17:09:04.526Z\",\"MediaKey\":\"690e27b04f94022caa1d250f\"},{\"ResourceRecordKey\":\"NST7825209\",\"Order\":6,\"MediaObjectID\":\"6\",\"LongDescription\":\"listing_5.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1558,\"ImageSizeDescription\":\"2080x1558\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7825209/7d3e7984-4325-457c-978d-f56b6f31bf93.jpeg\",\"MediaModificationTimestamp\":\"2025-11-07T17:09:04.521Z\",\"MediaKey\":\"690e27b04f94022caa1d2510\"},{\"ResourceRecordKey\":\"NST7825209\",\"Order\":7,\"MediaObjectID\":\"7\",\"LongDescription\":\"listing_6.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7825209/d8bab7bd-5cc2-442c-8343-0487d757a8d1.jpeg\",\"MediaModificationTimestamp\":\"2025-11-07T17:09:04.516Z\",\"MediaKey\":\"690e27b04f94022caa1d2511\"},{\"ResourceRecordKey\":\"NST7825209\",\"Order\":8,\"MediaObjectID\":\"8\",\"LongDescription\":\"listing_7.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1568,\"ImageSizeDescription\":\"2080x1568\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7825209/9a67572d-caba-4b42-9f53-a922e6afec6d.jpeg\",\"MediaModificationTimestamp\":\"2025-11-07T17:09:04.593Z\",\"MediaKey\":\"690e27b04f94022caa1d2512\"},{\"ResourceRecordKey\":\"NST7825209\",\"Order\":9,\"MediaObjectID\":\"9\",\"LongDescription\":\"listing_8.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1558,\"ImageSizeDescription\":\"2080x1558\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7825209/0b033607-0303-4917-bf42-2f19a17b9334.jpeg\",\"MediaModificationTimestamp\":\"2025-11-07T17:09:04.505Z\",\"MediaKey\":\"690e27b04f94022caa1d2513\"},{\"ResourceRecordKey\":\"NST7825209\",\"Order\":10,\"MediaObjectID\":\"10\",\"LongDescription\":\"listing_9.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7825209/22548a4a-cb86-4356-b7ba-277c851e5558.jpeg\",\"MediaModificationTimestamp\":\"2025-11-07T17:09:04.503Z\",\"MediaKey\":\"690e27b04f94022caa1d2514\"},{\"ResourceRecordKey\":\"NST7825209\",\"Order\":11,\"MediaObjectID\":\"11\",\"LongDescription\":\"listing_10.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7825209/9a4e4a7d-d2d5-4f30-9c27-66088b9d9e91.jpeg\",\"MediaModificationTimestamp\":\"2025-11-07T17:09:04.527Z\",\"MediaKey\":\"690e27b04f94022caa1d2515\"},{\"ResourceRecordKey\":\"NST7825209\",\"Order\":12,\"MediaObjectID\":\"12\",\"LongDescription\":\"listing_11.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1557,\"ImageSizeDescription\":\"2080x1557\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7825209/b4a3d265-91c5-45a9-ae9f-a95742eee157.jpeg\",\"MediaModificationTimestamp\":\"2025-11-07T17:09:04.499Z\",\"MediaKey\":\"690e27b04f94022caa1d2516\"},{\"ResourceRecordKey\":\"NST7825209\",\"Order\":13,\"MediaObjectID\":\"13\",\"LongDescription\":\"listing_12.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1562,\"ImageSizeDescription\":\"2080x1562\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7825209/b0230008-4a00-4714-aae5-b7c3c2179aa5.jpeg\",\"MediaModificationTimestamp\":\"2025-11-07T17:09:04.521Z\",\"MediaKey\":\"690e27b04f94022caa1d2517\"},{\"ResourceRecordKey\":\"NST7825209\",\"Order\":14,\"MediaObjectID\":\"14\",\"LongDescription\":\"listing_13.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1559,\"ImageSizeDescription\":\"2080x1559\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7825209/44085892-428c-46aa-94f1-e2b03fcc71c4.jpeg\",\"MediaModificationTimestamp\":\"2025-11-07T17:09:04.532Z\",\"MediaKey\":\"690e27b04f94022caa1d2518\"},{\"ResourceRecordKey\":\"NST7825209\",\"Order\":15,\"MediaObjectID\":\"15\",\"LongDescription\":\"listing_14.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7825209/6a3bda43-be8d-4294-9210-1ef62fffde3b.jpeg\",\"MediaModificationTimestamp\":\"2025-11-07T17:09:04.569Z\",\"MediaKey\":\"690e27b04f94022caa1d2519\"}]","PhotosChangeTimestamp":"2025-11-07T17:10:04.08Z","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"listing_0.jpg\"},{\"Order\":2,\"Remarks\":\"VIRTUALLY STAGED\"},{\"Order\":3,\"Remarks\":\"listing_2.jpg\"},{\"Order\":4,\"Remarks\":\"VIRTUALLY STAGED\"},{\"Order\":5,\"Remarks\":\"listing_4.jpg\"},{\"Order\":6,\"Remarks\":\"listing_5.jpg\"},{\"Order\":7,\"Remarks\":\"listing_6.jpg\"},{\"Order\":8,\"Remarks\":\"listing_7.jpg\"},{\"Order\":9,\"Remarks\":\"listing_8.jpg\"},{\"Order\":10,\"Remarks\":\"listing_9.jpg\"},{\"Order\":11,\"Remarks\":\"listing_10.jpg\"},{\"Order\":12,\"Remarks\":\"listing_11.jpg\"},{\"Order\":13,\"Remarks\":\"listing_12.jpg\"},{\"Order\":14,\"Remarks\":\"listing_13.jpg\"},{\"Order\":15,\"Remarks\":\"listing_14.jpg\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15","CustomVTourURL":""}