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":505489,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST7001334","MLSAGENTID":"NST502049535","MLSOFFICEID":"NST252736","ADDRESS":"823 3rd Street E","ACRES":0.116,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Unfinished","BATHSTOTAL":2.0,"BEDROOMS":5,"CITY":"Saint Paul","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"FORECLOSURE":"No","LASTPRICE":269900.0,"LASTPRICEDATE":"2025-12-18T21:55:06.037","LATITUDE":44.954498,"LENDEROWNED":"No","LISTDATE":"2025-12-18T06:00:00","LISTPRICE":269900.0,"LIVINGAREA":3294.0,"LONGITUDE":-93.07396214,"MODIFICATIONTIMESTAMP":"2025-12-19T11:03:13.373","NEIGHBORHOOD":"90","OFFICE_OFFICENAME":"AR Realty Group Inc.","PHOTOCOUNT":18,"POSTALCODE":"55106","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"We’re currently in the middle of CAM reconciliations and missed the message earlier, but that’s on us. We’ll make sure communication improves going forward","ROADBETWEENWATERFRONTANDHOMEYN":false,"SCHOOLDISTRICTNUMBER":"2102-St. Paul","SCHOOLDISTRICTPHONE":"6517678100","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2025-12-18T21:55:06.037","LASTSTATUS":"Active","STREETDIRSUFFIX":"E","STREETNAME":"3rd","STREETNUMBER":"823","STREETSUFFIX":"Street","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1900,"ZONING":"Residential-Multi-Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2025-12-18T21:55:06.037","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"House Front.jpeg\"},{\"Order\":2,\"Remarks\":\"Kitchen - 2.jpg\"},{\"Order\":3,\"Remarks\":\"IMG_8758.jpg\"},{\"Order\":4,\"Remarks\":\"IMG_8756.jpg\"},{\"Order\":5,\"Remarks\":\"Family Room #2.jpg\"},{\"Order\":6,\"Remarks\":\"IMG_8754.jpg\"},{\"Order\":7,\"Remarks\":\"IMG_8755.jpg\"},{\"Order\":8,\"Remarks\":\"IMG_8753.jpg\"},{\"Order\":9,\"Remarks\":\"Bedroom 2 2.jpg\"},{\"Order\":10,\"Remarks\":\"Bedroom 2 3.jpg\"},{\"Order\":11,\"Remarks\":\"Kitchen 2.jpg\"},{\"Order\":12,\"Remarks\":\"Kitchen 1.jpg\"},{\"Order\":13,\"Remarks\":\"Bedroom 2 1.jpg\"},{\"Order\":14,\"Remarks\":\"Bedroom 1 1.jpg\"},{\"Order\":15,\"Remarks\":\"Bathroom 1.jpg\"},{\"Order\":16,\"Remarks\":\"Bathroom 2.jpg\"},{\"Order\":17,\"Remarks\":\"Bedroom 1 3.jpg\"},{\"Order\":18,\"Remarks\":\"Bedroom 1 2.jpg\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18","SOURCE":"MG_NST"}
{"ListingKey":"NST7836442","NST_AboveGradeSqFtTotal":"3294","AboveGradeFinishedArea":"3294","AccessibilityFeatures":"None","AdditionalParcelsYN":"False","NST_AgentOwner":"No","LivingAreaUnits":"Square Feet","NST_AssessmentPending":"No","Basement":"Unfinished","BasementYN":"True","BathroomsTotalInteger":"2","BedroomsTotal":"5","NST_BelowGradeSqFtTotal":"1375","BelowGradeFinishedArea":"0","CumulativeDaysOnMarket":"0","City":"Saint Paul","NewConstructionYN":"False","Contingency":"None","CountyOrParish":"Ramsey","NST_DPResource":"Yes","Directions":"823 3rd St E","DocumentsCount":"0","DaysOnMarket":"0","ElectricExpense":"0","FoundationArea":"1375","NST_FoundationDimensions":"45x30","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","FuelExpense":"0","NST_GarageSquareFeet":"400","NST_GarageDimensions":"20x20","GarageSpaces":"2","GrossIncome":"36000","Heating":"Forced Air","HighSchoolDistrict":"St. Paul","NST_ForeclosureStatus":"No","InsuranceExpense":"0","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"True","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","Latitude":"44.9544979993","NST_LenderOwned":"No","Levels":"More Than 2 Stories","ListPrice":"269900","ListingContractDate":"2025-12-18T06:00:00Z","ListingId":"NST7001334","LivingArea":"3294","LockBoxType":"Combo","Longitude":"-93.0739621363","LotSizeArea":"0.116","LotSizeDimensions":"41x124","LotSizeUnits":"Acres","NST_MainLevelFinishedArea":"1440","MaintenanceExpense":"0","ManagerExpense":"0","NST_NeighborhoodNumber":"90","NumberOfUnitsTotal":"2","OperatingExpense":"0","OriginalEntryTimestamp":"2025-12-18T15:53:23Z","OtherExpense":"0","NST_OwnerOccupied":"No","ParcelNumber":"332922230195","NST_SchoolDistrictNumber":"2102","ParkingFeatures":"Detached Garage","PhotosCount":"18","PhotosChangeTimestamp":"2025-12-18T21:55:06.037Z","PostalCity":"Saint Paul","PostalCode":"55106","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PropertyType":"Residential Income","PublicRemarks":"We’re currently in the middle of CAM reconciliations and missed the message earlier, but that’s on us. We’ll make sure communication improves going forward","PublicSurveyRange":"22","PublicSurveySection":"33","PublicSurveyTownship":"29","NST_RentalLicenseType":"Standard","NST_RentalLicenseYN":"Y","NST_SchoolDistrictPhone":"6517678100","Sewer":"City Sewer/Connected","StandardStatus":"Active","StateOrProvince":"MN","StreetDirSuffix":"E","StreetName":"3rd","StreetNumber":"823","StreetNumberNumeric":"823","StreetSuffix":"Street","SubdivisionName":"Walther & Schnittgers Sub B90","TaxAnnualAmount":"5854","NST_TaxWithAssessments":"5854","TaxYear":"2025","Township":"Saint Paul","TrashExpense":"0","VideosCount":"0","WaterSewerExpense":"0","WaterSource":"City Water/Connected","YearBuilt":"1900","ZoningDescription":"Residential-Multi-Family","ListAgentKey":"NST224314","ListAgentMlsId":"NST502049535","ListOfficeMlsId":"NST252736","ListOfficeName":"AR Realty Group Inc.","ListOfficeKey":"NST1001478","ModificationTimestamp":"2025-12-19T11:03:13.373Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7836442\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7836442/014a51bc-65aa-4025-b046-fa6d94ec8370.jpeg\",\"Order\":11,\"MediaObjectID\":\"NST11\",\"LongDescription\":\"Kitchen 2.jpg\",\"ImageWidth\":240,\"ImageHeight\":320,\"ImageSizeDescription\":\"240x320\",\"MediaModificationTimestamp\":\"2025-12-18T21:54:14.473Z\",\"MediaKey\":\"NST119950160\"},{\"ResourceRecordKey\":\"NST7836442\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7836442/9068ad12-2ce4-44dc-92d5-842524472d80.jpeg\",\"Order\":12,\"MediaObjectID\":\"NST12\",\"LongDescription\":\"Kitchen 1.jpg\",\"ImageWidth\":240,\"ImageHeight\":320,\"ImageSizeDescription\":\"240x320\",\"MediaModificationTimestamp\":\"2025-12-18T21:54:14.472Z\",\"MediaKey\":\"NST119950159\"},{\"ResourceRecordKey\":\"NST7836442\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7836442/733cb890-0a7b-482a-ae3f-d79208cfbb83.jpeg\",\"Order\":3,\"MediaObjectID\":\"NST3\",\"LongDescription\":\"IMG_8758.jpg\",\"ImageWidth\":240,\"ImageHeight\":320,\"ImageSizeDescription\":\"240x320\",\"MediaModificationTimestamp\":\"2025-12-18T21:54:14.47Z\",\"MediaKey\":\"NST119950176\"},{\"ResourceRecordKey\":\"NST7836442\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7836442/01948ffc-bed9-4b47-9031-3cb2d45a9b4d.jpeg\",\"Order\":8,\"MediaObjectID\":\"NST8\",\"LongDescription\":\"IMG_8753.jpg\",\"ImageWidth\":240,\"ImageHeight\":320,\"ImageSizeDescription\":\"240x320\",\"MediaModificationTimestamp\":\"2025-12-18T21:54:14.461Z\",\"MediaKey\":\"NST119950170\"},{\"ResourceRecordKey\":\"NST7836442\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7836442/3905697a-d78e-4e57-9cbf-6d6589e5024e.jpeg\",\"Order\":6,\"MediaObjectID\":\"NST6\",\"LongDescription\":\"IMG_8754.jpg\",\"ImageWidth\":240,\"ImageHeight\":320,\"ImageSizeDescription\":\"240x320\",\"MediaModificationTimestamp\":\"2025-12-18T21:54:14.463Z\",\"MediaKey\":\"NST119950173\"},{\"ResourceRecordKey\":\"NST7836442\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7836442/7e95e05d-13c1-4761-9727-b01011434673.jpeg\",\"Order\":4,\"MediaObjectID\":\"NST4\",\"LongDescription\":\"IMG_8756.jpg\",\"ImageWidth\":240,\"ImageHeight\":320,\"ImageSizeDescription\":\"240x320\",\"MediaModificationTimestamp\":\"2025-12-18T21:54:14.46Z\",\"MediaKey\":\"NST119950175\"},{\"ResourceRecordKey\":\"NST7836442\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7836442/32a5d3a3-42f9-453d-a351-b741b0231a6d.jpeg\",\"Order\":7,\"MediaObjectID\":\"NST7\",\"LongDescription\":\"IMG_8755.jpg\",\"ImageWidth\":240,\"ImageHeight\":320,\"ImageSizeDescription\":\"240x320\",\"MediaModificationTimestamp\":\"2025-12-18T21:54:14.49Z\",\"MediaKey\":\"NST119950171\"},{\"ResourceRecordKey\":\"NST7836442\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7836442/28ae6c56-9955-40d0-9fc2-a6ea8350d8de.jpeg\",\"Order\":17,\"MediaObjectID\":\"NST17\",\"LongDescription\":\"Bedroom 1 3.jpg\",\"ImageWidth\":480,\"ImageHeight\":640,\"ImageSizeDescription\":\"480x640\",\"MediaModificationTimestamp\":\"2025-12-18T21:54:14.462Z\",\"MediaKey\":\"NST119950154\"},{\"ResourceRecordKey\":\"NST7836442\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7836442/c1848397-f199-42a9-b06d-c69d3db393a5.jpeg\",\"Order\":1,\"MediaObjectID\":\"NST1\",\"LongDescription\":\"House Front.jpeg\",\"ImageWidth\":296,\"ImageHeight\":640,\"ImageSizeDescription\":\"296x640\",\"MediaModificationTimestamp\":\"2025-12-18T21:54:14.455Z\",\"MediaKey\":\"NST119950180\"},{\"ResourceRecordKey\":\"NST7836442\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7836442/c722dfbd-9faa-4141-86e8-028f2afe6b02.jpeg\",\"Order\":9,\"MediaObjectID\":\"NST9\",\"LongDescription\":\"Bedroom 2 2.jpg\",\"ImageWidth\":480,\"ImageHeight\":640,\"ImageSizeDescription\":\"480x640\",\"MediaModificationTimestamp\":\"2025-12-18T21:54:14.483Z\",\"MediaKey\":\"NST119950167\"},{\"ResourceRecordKey\":\"NST7836442\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7836442/5fff4a77-88ef-4df3-bb1c-699105b507fd.jpeg\",\"Order\":14,\"MediaObjectID\":\"NST14\",\"LongDescription\":\"Bedroom 1 1.jpg\",\"ImageWidth\":480,\"ImageHeight\":640,\"ImageSizeDescription\":\"480x640\",\"MediaModificationTimestamp\":\"2025-12-18T21:54:14.472Z\",\"MediaKey\":\"NST119950157\"},{\"ResourceRecordKey\":\"NST7836442\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7836442/36a9eea5-a6f0-4527-8780-29107d5adb47.jpeg\",\"Order\":10,\"MediaObjectID\":\"NST10\",\"LongDescription\":\"Bedroom 2 3.jpg\",\"ImageWidth\":480,\"ImageHeight\":640,\"ImageSizeDescription\":\"480x640\",\"MediaModificationTimestamp\":\"2025-12-18T21:54:14.454Z\",\"MediaKey\":\"NST119950166\"},{\"ResourceRecordKey\":\"NST7836442\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7836442/7723f655-d4bc-4cda-af96-125bb6ea2cac.jpeg\",\"Order\":2,\"MediaObjectID\":\"NST2\",\"LongDescription\":\"Kitchen - 2.jpg\",\"ImageWidth\":640,\"ImageHeight\":480,\"ImageSizeDescription\":\"640x480\",\"MediaModificationTimestamp\":\"2025-12-18T21:54:14.486Z\",\"MediaKey\":\"NST119950178\"},{\"ResourceRecordKey\":\"NST7836442\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7836442/4d7a4370-f8aa-46a3-864a-1aa0895bab37.jpeg\",\"Order\":13,\"MediaObjectID\":\"NST13\",\"LongDescription\":\"Bedroom 2 1.jpg\",\"ImageWidth\":480,\"ImageHeight\":640,\"ImageSizeDescription\":\"480x640\",\"MediaModificationTimestamp\":\"2025-12-18T21:54:14.456Z\",\"MediaKey\":\"NST119950158\"},{\"ResourceRecordKey\":\"NST7836442\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7836442/d19e7d1b-c29d-4fb6-8368-a189ac68254e.jpeg\",\"Order\":15,\"MediaObjectID\":\"NST15\",\"LongDescription\":\"Bathroom 1.jpg\",\"ImageWidth\":480,\"ImageHeight\":640,\"ImageSizeDescription\":\"480x640\",\"MediaModificationTimestamp\":\"2025-12-18T21:54:14.497Z\",\"MediaKey\":\"NST119950156\"},{\"ResourceRecordKey\":\"NST7836442\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7836442/e68b2456-a72a-4045-9b17-56e9634fe79e.jpeg\",\"Order\":18,\"MediaObjectID\":\"NST18\",\"LongDescription\":\"Bedroom 1 2.jpg\",\"ImageWidth\":480,\"ImageHeight\":640,\"ImageSizeDescription\":\"480x640\",\"MediaModificationTimestamp\":\"2025-12-18T21:54:14.483Z\",\"MediaKey\":\"NST119950153\"},{\"ResourceRecordKey\":\"NST7836442\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7836442/4539d7da-05da-42ae-a96e-a4967aa49869.jpeg\",\"Order\":16,\"MediaObjectID\":\"NST16\",\"LongDescription\":\"Bathroom 2.jpg\",\"ImageWidth\":480,\"ImageHeight\":640,\"ImageSizeDescription\":\"480x640\",\"MediaModificationTimestamp\":\"2025-12-18T21:54:14.475Z\",\"MediaKey\":\"NST119950155\"},{\"ResourceRecordKey\":\"NST7836442\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7836442/616b5ffb-d599-40de-a37f-d48c9a6181b1.jpeg\",\"Order\":5,\"MediaObjectID\":\"NST5\",\"LongDescription\":\"Family Room #2.jpg\",\"ImageWidth\":1512,\"ImageHeight\":2016,\"ImageSizeDescription\":\"1512x2016\",\"MediaModificationTimestamp\":\"2025-12-18T21:54:14.492Z\",\"MediaKey\":\"NST119950174\"}]","Media__ResourceRecordKey":"NST7836442","Media__MediaURL":"https://s3.amazonaws.com/mlsgrid/images/NST7836442/014a51bc-65aa-4025-b046-fa6d94ec8370.jpeg","Media__Order":"11","Media__MediaObjectID":"NST11","Media__LongDescription":"Kitchen 2.jpg","Media__ImageWidth":"240","Media__ImageHeight":"320","Media__ImageSizeDescription":"240x320","Media__MediaModificationTimestamp":"12/18/2025 9:54:14 PM","Media__MediaKey":"NST119950160","DocumentsChangeTimestamp":"2025-12-18T21:54:06.099Z","UnitTypes":"[{\"NST_UnitBathFull\":1,\"NST_UnitLevel\":\"Main Level\",\"UnitTypeTotalRent\":1300,\"NST_UnitRoomsTotal\":4,\"UnitTypeKey\":\"NST157367\",\"NST_UnitID\":1,\"UnitTypeBathsTotal\":1,\"UnitTypeBedsTotal\":3,\"UnitTypeUnitsTotal\":1,\"NST_UnitIsLeased\":\"Y\"},{\"NST_UnitBathFull\":1,\"NST_UnitLevel\":\"2nd Level\",\"UnitTypeTotalRent\":1700,\"NST_UnitRoomsTotal\":4,\"UnitTypeKey\":\"NST157368\",\"NST_LeaseExpirationDt\":\"2026-07-01\",\"NST_UnitID\":2,\"UnitTypeBathsTotal\":1,\"UnitTypeBedsTotal\":2,\"UnitTypeUnitsTotal\":1,\"NST_UnitIsLeased\":\"Y\"}]","UnitTypes__NST_UnitBathFull":"1","UnitTypes__NST_UnitLevel":"Main Level","UnitTypes__UnitTypeTotalRent":"1300","UnitTypes__NST_UnitRoomsTotal":"4","UnitTypes__UnitTypeKey":"NST157367","UnitTypes__NST_UnitID":"1","UnitTypes__UnitTypeBathsTotal":"1","UnitTypes__UnitTypeBedsTotal":"3","UnitTypes__UnitTypeUnitsTotal":"1","UnitTypes__NST_UnitIsLeased":"Y","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"House Front.jpeg\"},{\"Order\":2,\"Remarks\":\"Kitchen - 2.jpg\"},{\"Order\":3,\"Remarks\":\"IMG_8758.jpg\"},{\"Order\":4,\"Remarks\":\"IMG_8756.jpg\"},{\"Order\":5,\"Remarks\":\"Family Room #2.jpg\"},{\"Order\":6,\"Remarks\":\"IMG_8754.jpg\"},{\"Order\":7,\"Remarks\":\"IMG_8755.jpg\"},{\"Order\":8,\"Remarks\":\"IMG_8753.jpg\"},{\"Order\":9,\"Remarks\":\"Bedroom 2 2.jpg\"},{\"Order\":10,\"Remarks\":\"Bedroom 2 3.jpg\"},{\"Order\":11,\"Remarks\":\"Kitchen 2.jpg\"},{\"Order\":12,\"Remarks\":\"Kitchen 1.jpg\"},{\"Order\":13,\"Remarks\":\"Bedroom 2 1.jpg\"},{\"Order\":14,\"Remarks\":\"Bedroom 1 1.jpg\"},{\"Order\":15,\"Remarks\":\"Bathroom 1.jpg\"},{\"Order\":16,\"Remarks\":\"Bathroom 2.jpg\"},{\"Order\":17,\"Remarks\":\"Bedroom 1 3.jpg\"},{\"Order\":18,\"Remarks\":\"Bedroom 1 2.jpg\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18","CustomVTourURL":""}