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":1400033,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST6777959","MLSAGENTID":"NST506096207","MLSOFFICEID":"NST253060","ADDRESS":"816 Edmund Avenue","ACRES":0.11,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Full","CITY":"Saint Paul","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Stucco","FORECLOSURE":"No","LASTPRICE":239900.0,"LASTPRICEDATE":"2025-09-15T18:17:03.627","LATITUDE":44.958176,"LENDEROWNED":"No","LISTDATE":"2025-08-25T05:00:00","LISTPRICE":234900.0,"LIVINGAREA":1876.0,"LONGITUDE":-93.134613,"MODIFICATIONTIMESTAMP":"2025-09-15T18:17:03.628","NEIGHBORHOOD":"Thomas-Dale (Frogtown)","OFFICE_OFFICENAME":"Jeff Hagel","PHOTOCOUNT":11,"POSTALCODE":"55104","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Fantastic investment opportunity! This well-maintained duplex features two spacious units, each offering 2 bedrooms and 1 bathroom. Both units are in good condition and just need a few cosmetic updates, giving you the chance to add your personal touch or increase rental value. Perfect for investors seeking reliable income or for an owner-occupant looking to live in one side while renting out the other.","ROADBETWEENWATERFRONTANDHOMEYN":false,"SCHOOLDISTRICTNUMBER":"625-St. Paul","SCHOOLDISTRICTPHONE":"651-767-8100","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2025-08-25T19:18:03.953","LASTSTATUS":"Active","STREETNAME":"Edmund","STREETNUMBER":"816","STREETSUFFIX":"Avenue","STYLE":"Duplex Up and Down","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1888,"ZONING":"Residential-Multi-Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2025-08-26T02:05:04.69","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"1 Edmund.jpg\"},{\"Order\":2,\"Remarks\":\"2 Edmund.jpg\"},{\"Order\":3,\"Remarks\":\"3 Edmund.jpg\"},{\"Order\":4,\"Remarks\":\"4 Edmund.jpg\"},{\"Order\":5,\"Remarks\":\"5 Edmund.jpg\"},{\"Order\":6,\"Remarks\":\"6 Edmund.jpg\"},{\"Order\":7,\"Remarks\":\"7Edmund.jpg\"},{\"Order\":8,\"Remarks\":\"8Edmund.jpg\"},{\"Order\":9,\"Remarks\":\"9Edmund.jpg\"},{\"Order\":10,\"Remarks\":\"10 Edmund.jpg\"},{\"Order\":11,\"Remarks\":\"11 Edmund.jpg\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11","SOURCE":"MG_NST"}
{"ListingKey":"NST7793062","LotSizeArea":"0.11","NST_AgeOfProperty":"137","NST_AgentOwner":"No","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"True","NST_AssessmentPending":"No","NST_AttributionContact":"jeffrey.hagel@gmail.com","NST_AttributionName":"Jeffrey Hagel","Basement":"Full","BasementYN":"True","City":"Saint Paul","PropertyType":"Residential Income","NewConstructionYN":"False","Contingency":"None","CountyOrParish":"Ramsey","NST_DPResource":"Y","DaysOnMarket":"21","CumulativeDaysOnMarket":"21","Directions":"94 TO LEXINGTON NORTH TO EDMUND EAST TO HOME","InternetAddressDisplayYN":"True","InternetEntireListingDisplayYN":"True","ManagerExpense":"0","ElectricExpense":"0","FuelExpense":"0","InsuranceExpense":"0","MaintenanceExpense":"0","OtherExpense":"0","OperatingExpense":"0","TrashExpense":"0","WaterSewerExpense":"0","NST_Expenses":"0.0000","ConstructionMaterials":"Stucco","NST_ForeclosureStatus":"No","FoundationArea":"938","NST_FractionalOwnershipYN":"No","NST_Fuel":"Electric","ParkingFeatures":"Detached","NST_GarageSquareFeet":"200","GrossIncome":"0","AccessibilityFeatures":"None","Heating":"Hot Water","OriginalEntryTimestamp":"2025-08-25T19:16:20Z","LandLeaseYN":"False","NST_LastUpdateDate":"2025-09-15","Latitude":"44.958176","NST_LenderOwned":"No","ListAgentKey":"NST102072","ListAgentMlsId":"NST506096207","ListingContractDate":"2025-08-25T05:00:00Z","ListOfficeKey":"NST1001803","ListOfficeName":"Jeff Hagel","ListOfficeMlsId":"NST253060","ListPrice":"234900","LivingArea":"1876","Longitude":"-93.134613","LotSizeDimensions":"125X40","LotSizeUnits":"Acres","ListingId":"NST6777959","SourceSystemName":"RMLS","MapCoordinateSource":"King's Street Atlas","AdditionalParcelsYN":"False","NST_NeighborhoodNumber":"Thomas-Dale (Frogtown)","NST_OfficeBoard":"SPAAR","NST_OwnerOccupied":"No","ParcelNumber":"352923130061","GarageSpaces":"1","PhotosCount":"11","PostalCity":"Saint Paul","PostalCode":"55104","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PublicRemarks":"Fantastic investment opportunity! This well-maintained duplex features two spacious units, each offering 2 bedrooms and 1 bathroom. Both units are in good condition and just need a few cosmetic updates, giving you the chance to add your personal touch or increase rental value. Perfect for investors seeking reliable income or for an owner-occupant looking to live in one side while renting out the other.","PublicSurveyRange":"23","PublicSurveySection":"35","PublicSurveyTownship":"29","NST_RentalLicenseYN":"No","NST_AboveGradeSqFtTotal":"1876.0000","NST_BelowGradeSqFtTotal":"938.0000","NST_MainLevelFinishedArea":"938.0000","BuildingAreaTotal":"2814","HighSchoolDistrict":"St. Paul","NST_SchoolDistrictNumber":"625","NST_SchoolDistrictPhone":"651-767-8100","Sewer":"City Sewer/Connected","AboveGradeFinishedArea":"1876","BelowGradeFinishedArea":"0","StateOrProvince":"MN","StandardStatus":"Active","Levels":"Two","StreetName":"Edmund","StreetNumber":"816","StreetNumberNumeric":"816","StreetSuffix":"Avenue","PropertySubType":"Duplex Up and Down","SubdivisionName":"Syndicate 2 Add","NST_TaxWithAssessments":"4398.0000","TaxYear":"2025","TaxAnnualAmount":"4398","NumberOfUnitsTotal":"2","WaterSource":"City Water/Connected","YearBuilt":"1888","ZoningDescription":"Residential-Multi-Family","ModificationTimestamp":"2025-09-15T18:17:03.628Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7793062\",\"Order\":1,\"MediaObjectID\":\"1\",\"LongDescription\":\"1 Edmund.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1388,\"ImageSizeDescription\":\"2080x1388\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7793062/41a2a6f2-ff12-4c90-9ecb-1c9473483d14.jpeg\",\"MediaModificationTimestamp\":\"2025-08-26T02:04:22.457Z\",\"MediaKey\":\"68ad16263945e908fdb10439\"},{\"ResourceRecordKey\":\"NST7793062\",\"Order\":2,\"MediaObjectID\":\"2\",\"LongDescription\":\"2 Edmund.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1388,\"ImageSizeDescription\":\"2080x1388\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7793062/85512d29-a188-46eb-8cfb-5dea0c5b187e.jpeg\",\"MediaModificationTimestamp\":\"2025-08-26T02:04:22.477Z\",\"MediaKey\":\"68ad16263945e908fdb1043a\"},{\"ResourceRecordKey\":\"NST7793062\",\"Order\":3,\"MediaObjectID\":\"3\",\"LongDescription\":\"3 Edmund.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1388,\"ImageSizeDescription\":\"2080x1388\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7793062/dbc11992-1f81-45c0-9837-d1e862314299.jpeg\",\"MediaModificationTimestamp\":\"2025-08-26T02:04:22.456Z\",\"MediaKey\":\"68ad16263945e908fdb1043b\"},{\"ResourceRecordKey\":\"NST7793062\",\"Order\":4,\"MediaObjectID\":\"4\",\"LongDescription\":\"4 Edmund.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1388,\"ImageSizeDescription\":\"2080x1388\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7793062/bc1b86f1-8fb1-4f7a-8aa0-fdcd406bd643.jpeg\",\"MediaModificationTimestamp\":\"2025-08-26T02:04:22.473Z\",\"MediaKey\":\"68ad16263945e908fdb1043c\"},{\"ResourceRecordKey\":\"NST7793062\",\"Order\":5,\"MediaObjectID\":\"5\",\"LongDescription\":\"5 Edmund.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1388,\"ImageSizeDescription\":\"2080x1388\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7793062/e042d9ec-d883-408d-9d16-b67219916c50.jpeg\",\"MediaModificationTimestamp\":\"2025-08-26T02:04:22.462Z\",\"MediaKey\":\"68ad16263945e908fdb1043d\"},{\"ResourceRecordKey\":\"NST7793062\",\"Order\":6,\"MediaObjectID\":\"6\",\"LongDescription\":\"6 Edmund.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1388,\"ImageSizeDescription\":\"2080x1388\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7793062/e0441d9b-5edf-493d-a320-a9d6fa40e893.jpeg\",\"MediaModificationTimestamp\":\"2025-08-26T02:04:22.517Z\",\"MediaKey\":\"68ad16263945e908fdb1043e\"},{\"ResourceRecordKey\":\"NST7793062\",\"Order\":7,\"MediaObjectID\":\"7\",\"LongDescription\":\"7Edmund.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1388,\"ImageSizeDescription\":\"2080x1388\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7793062/7f2f91a9-f8b8-430b-b8d1-c8b5032f7e60.jpeg\",\"MediaModificationTimestamp\":\"2025-08-26T02:04:22.504Z\",\"MediaKey\":\"68ad16263945e908fdb1043f\"},{\"ResourceRecordKey\":\"NST7793062\",\"Order\":8,\"MediaObjectID\":\"8\",\"LongDescription\":\"8Edmund.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1388,\"ImageSizeDescription\":\"2080x1388\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7793062/44392572-776d-44d3-bf20-885a50345ee1.jpeg\",\"MediaModificationTimestamp\":\"2025-08-26T02:04:22.454Z\",\"MediaKey\":\"68ad16263945e908fdb10440\"},{\"ResourceRecordKey\":\"NST7793062\",\"Order\":9,\"MediaObjectID\":\"9\",\"LongDescription\":\"9Edmund.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1389,\"ImageSizeDescription\":\"2080x1389\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7793062/180dbb7d-b544-42ee-a080-d1e6e2c34ca2.jpeg\",\"MediaModificationTimestamp\":\"2025-08-26T02:04:22.463Z\",\"MediaKey\":\"68ad16263945e908fdb10441\"},{\"ResourceRecordKey\":\"NST7793062\",\"Order\":10,\"MediaObjectID\":\"10\",\"LongDescription\":\"10 Edmund.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1397,\"ImageSizeDescription\":\"2080x1397\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7793062/29ba2cb0-54ac-42c9-93ab-d3b2c4b9b8a3.jpeg\",\"MediaModificationTimestamp\":\"2025-08-26T02:04:22.493Z\",\"MediaKey\":\"68ad16263945e908fdb10442\"},{\"ResourceRecordKey\":\"NST7793062\",\"Order\":11,\"MediaObjectID\":\"11\",\"LongDescription\":\"11 Edmund.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1392,\"ImageSizeDescription\":\"2080x1392\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7793062/22f11555-fed5-4be6-8477-34895767ee3d.jpeg\",\"MediaModificationTimestamp\":\"2025-08-26T02:04:22.558Z\",\"MediaKey\":\"68ad16263945e908fdb10443\"}]","PhotosChangeTimestamp":"2025-08-26T02:05:04.69Z","UnitTypes":"[{\"UnitTypeKey\":\"NST155477\",\"UnitTypeTotalRent\":0,\"NST_UnitBath3Qtr\":\"0\",\"NST_UnitBathFull\":\"1\",\"NST_UnitBathHalf\":\"0\",\"NST_UnitBathQtr\":\"0\",\"UnitTypeBathsTotal\":1,\"UnitTypeBedsTotal\":2,\"NST_MonthlyExpenses\":\"0.00\",\"NST_UnitID\":\"1\",\"UnitTypeActualRent\":0,\"UnitTypeUnitsTotal\":2,\"NST_UnitRoomsTotal\":\"6\",\"NST_UnitSqFt\":\"936\"}]","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"1 Edmund.jpg\"},{\"Order\":2,\"Remarks\":\"2 Edmund.jpg\"},{\"Order\":3,\"Remarks\":\"3 Edmund.jpg\"},{\"Order\":4,\"Remarks\":\"4 Edmund.jpg\"},{\"Order\":5,\"Remarks\":\"5 Edmund.jpg\"},{\"Order\":6,\"Remarks\":\"6 Edmund.jpg\"},{\"Order\":7,\"Remarks\":\"7Edmund.jpg\"},{\"Order\":8,\"Remarks\":\"8Edmund.jpg\"},{\"Order\":9,\"Remarks\":\"9Edmund.jpg\"},{\"Order\":10,\"Remarks\":\"10 Edmund.jpg\"},{\"Order\":11,\"Remarks\":\"11 Edmund.jpg\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11","CustomVTourURL":""}