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":1420321,"ORGTABLE":"RAW_Property","MLSCLASS":"COM","MLSNUMBER":"NST6802662","MLSAGENTID":"NST502031715","MLSOFFICEID":"NST80333","ADDRESS":"507 University Avenue W","ACRES":0.1,"AGENTOWNER":false,"AUCTIONYN":false,"CITY":"Saint Paul","CONTINGENCY":"None","COUNTY":"Ramsey","CURRENTUSE":"Commercial,Industrial,Retail","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Brick/Stone","FORECLOSURE":"No","LASTPRICE":4500.0,"LASTPRICEDATE":"2025-10-11T00:33:03.52","LATITUDE":44.95604454,"LENDEROWNED":"No","LISTDATE":"2025-10-10T05:00:00","LISTPRICE":4500.0,"LIVINGAREA":4664.0,"LONGITUDE":-93.12160041,"MODIFICATIONTIMESTAMP":"2025-10-11T02:06:04.968","NEIGHBORHOOD":"Thomas-Dale (Frogtown)","OFFICE_OFFICENAME":"Creative Real Estate, LLC","PHOTOCOUNT":17,"POSTALCODE":"55103","POTENTIALSHORTSALE":"No","PUBLICREMARKS":"Prime opportunity! This dynamic property offers a perfect blend of office, warehouse, and retail space, designed for your business needs. Key Features: * Direct Metro Green Line Access: Unbeatable convenience for employees and customers. * Heated Warehouse: Ideal for light manufacturing operations. * Seamless Transportation: Minutes from I-94 E, I-35 E, and downtown St. Paul. * Flexible Layout: Accommodate your administrative, production, and retail functions under one roof.","ROADBETWEENWATERFRONTANDHOMEYN":false,"SALEINCLUDES":"Leases","SCHOOLDISTRICTNUMBER":"625-St. Paul","SCHOOLDISTRICTPHONE":"651-767-8100","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2025-10-11T00:33:03.52","LASTSTATUS":"Active","STREETDIRSUFFIX":"W","STREETNAME":"University","STREETNUMBER":"507","STREETSUFFIX":"Avenue","TRANSACTIONTYPE":"For Rent","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1900,"ZONING":"Industrial","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2025-10-11T02:06:04.968","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"20250826_125947.jpg\"},{\"Order\":2,\"Remarks\":\"Front.jpg\"},{\"Order\":3,\"Remarks\":\"20250826_130048.jpg\"},{\"Order\":4,\"Remarks\":\"20250826_130115.jpg\"},{\"Order\":5,\"Remarks\":\"20250826_130134.jpg\"},{\"Order\":6,\"Remarks\":\"20250826_130154.jpg\"},{\"Order\":7,\"Remarks\":\"20250826_130202.jpg\"},{\"Order\":8,\"Remarks\":\"20250826_130217.jpg\"},{\"Order\":9,\"Remarks\":\"20250826_130235.jpg\"},{\"Order\":10,\"Remarks\":\"20250826_130300.jpg\"},{\"Order\":11,\"Remarks\":\"20250826_130321.jpg\"},{\"Order\":12,\"Remarks\":\"20250826_130350.jpg\"},{\"Order\":13,\"Remarks\":\"20250826_130409.jpg\"},{\"Order\":14,\"Remarks\":\"20250826_130423.jpg\"},{\"Order\":15,\"Remarks\":\"20250826_130510.jpg\"},{\"Order\":16,\"Remarks\":\"20250826_130548.jpg\"},{\"Order\":17,\"Remarks\":\"20250826_130552.jpg\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17","SOURCE":"MG_NST"}
{"ListingKey":"NST7814313","LotSizeArea":"0.1","NST_AgeOfProperty":"125","NST_AgentOwner":"No","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"True","NST_AssessmentPending":"No","BasementYN":"False","City":"Saint Paul","PropertyType":"Commercial Sale","Contingency":"None","CountyOrParish":"Ramsey","CurrentUse":"Commercial,Industrial,Retail","Directions":"Exit from 94 to Dale St. N. Turn right on University Ave. Turn left on Mackubin St. Property is the 2nd property in on the corner of Mackubin & University Ave.","InternetAddressDisplayYN":"True","InternetEntireListingDisplayYN":"True","ConstructionMaterials":"Brick/Stone","NST_ForeclosureStatus":"No","FoundationArea":"4120","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","ParkingFeatures":"Attached Garage","AccessibilityFeatures":"None","Heating":"Forced Air","OriginalEntryTimestamp":"2025-10-11T00:19:56Z","LandLeaseYN":"False","NST_LastUpdateDate":"2025-10-10","Latitude":"44.9560445427","NST_LeaseAmountType":"Monthly","NST_LeasePrice":"4500.0000","NST_LeaseType":"Gross","NST_LenderOwned":"No","ListAgentKey":"NST84049","ListAgentMlsId":"NST502031715","ListingContractDate":"2025-10-10T05:00:00Z","ListOfficeKey":"NST20736","ListOfficeName":"Creative Real Estate, LLC","ListOfficeMlsId":"NST80333","ListPrice":"4500","Longitude":"-93.1216004108","LotSizeDimensions":"104x40","LotSizeUnits":"Acres","ListingId":"NST6802662","SourceSystemName":"RMLS","MapCoordinateSource":"King's Street Atlas","AdditionalParcelsYN":"False","NST_NeighborhoodNumber":"Thomas-Dale (Frogtown)","NST_OfficeBoard":"SPAAR","NST_OwnerOccupied":"No","ParcelNumber":"362923230117","GarageSpaces":"1","NST_ParkingOpen":"0","PhotosCount":"17","PostalCity":"Saint Paul","PostalCode":"55103","NST_PotentialShortSale":"No","PublicRemarks":"Prime opportunity! This dynamic property offers a perfect blend of office, warehouse, and retail space, designed for your business needs. Key Features: * Direct Metro Green Line Access: Unbeatable convenience for employees and customers. * Heated Warehouse: Ideal for light manufacturing operations. * Seamless Transportation: Minutes from I-94 E, I-35 E, and downtown St. Paul. * Flexible Layout: Accommodate your administrative, production, and retail functions under one roof.","NST_RentalLicenseYN":"No","Inclusions":"Leases","HighSchoolDistrict":"St. Paul","NST_SchoolDistrictNumber":"625","NST_SchoolDistrictPhone":"651-767-8100","Sewer":"City Sewer/Connected","BuildingAreaTotal":"4664","StateOrProvince":"MN","StandardStatus":"Active","Levels":"One","StreetDirSuffix":"W","StreetName":"University","StreetNumber":"507","StreetNumberNumeric":"507","StreetSuffix":"Avenue","NST_TaxWithAssessments":"17922.0000","TaxYear":"2025","TaxAnnualAmount":"17922","NumberOfUnitsTotal":"1","Utilities":"Heating Common","WaterSource":"City Water/Connected","YearBuilt":"1900","ZoningDescription":"Industrial","ModificationTimestamp":"2025-10-11T02:06:04.968Z","PhotosChangeTimestamp":"2025-10-11T02:06:04.968Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7814313\",\"Order\":1,\"MediaObjectID\":\"1\",\"LongDescription\":\"20250826_125947.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1467,\"ImageSizeDescription\":\"2080x1467\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7814313/b31719dc-45bf-4f5b-8fa7-5259129122e6.jpeg\",\"MediaModificationTimestamp\":\"2025-10-11T02:05:25.952Z\",\"MediaKey\":\"68e9bb661600b97c14209498\"},{\"ResourceRecordKey\":\"NST7814313\",\"Order\":2,\"MediaObjectID\":\"2\",\"LongDescription\":\"Front.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7814313/8ce28651-38c3-4786-aab9-dec12a041df2.jpeg\",\"MediaModificationTimestamp\":\"2025-10-11T02:05:26.03Z\",\"MediaKey\":\"68e9bb661600b97c14209499\"},{\"ResourceRecordKey\":\"NST7814313\",\"Order\":3,\"MediaObjectID\":\"3\",\"LongDescription\":\"20250826_130048.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1171,\"ImageSizeDescription\":\"2080x1171\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7814313/3b0d5f9d-41c4-4cf1-9347-00d4a110f921.jpeg\",\"MediaModificationTimestamp\":\"2025-10-11T02:05:25.933Z\",\"MediaKey\":\"68e9bb661600b97c1420949a\"},{\"ResourceRecordKey\":\"NST7814313\",\"Order\":4,\"MediaObjectID\":\"4\",\"LongDescription\":\"20250826_130115.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1171,\"ImageSizeDescription\":\"2080x1171\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7814313/623079b9-3eca-4636-b159-468c0ab7cc17.jpeg\",\"MediaModificationTimestamp\":\"2025-10-11T02:05:25.921Z\",\"MediaKey\":\"68e9bb661600b97c1420949b\"},{\"ResourceRecordKey\":\"NST7814313\",\"Order\":5,\"MediaObjectID\":\"5\",\"LongDescription\":\"20250826_130134.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1171,\"ImageSizeDescription\":\"2080x1171\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7814313/0d5838ab-b3e1-42c9-8edc-c88bd0255f4b.jpeg\",\"MediaModificationTimestamp\":\"2025-10-11T02:05:25.922Z\",\"MediaKey\":\"68e9bb661600b97c1420949c\"},{\"ResourceRecordKey\":\"NST7814313\",\"Order\":6,\"MediaObjectID\":\"6\",\"LongDescription\":\"20250826_130154.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1171,\"ImageSizeDescription\":\"2080x1171\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7814313/b6c9ef53-28a7-4e81-86cc-6d878af1aa60.jpeg\",\"MediaModificationTimestamp\":\"2025-10-11T02:05:25.995Z\",\"MediaKey\":\"68e9bb661600b97c1420949d\"},{\"ResourceRecordKey\":\"NST7814313\",\"Order\":7,\"MediaObjectID\":\"7\",\"LongDescription\":\"20250826_130202.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1171,\"ImageSizeDescription\":\"2080x1171\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7814313/1d70faed-176f-4650-ae23-e56bbe9f1b41.jpeg\",\"MediaModificationTimestamp\":\"2025-10-11T02:05:25.951Z\",\"MediaKey\":\"68e9bb661600b97c1420949e\"},{\"ResourceRecordKey\":\"NST7814313\",\"Order\":8,\"MediaObjectID\":\"8\",\"LongDescription\":\"20250826_130217.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1171,\"ImageSizeDescription\":\"2080x1171\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7814313/9c2334e5-e3e6-409f-ba62-f8d911fdacd6.jpeg\",\"MediaModificationTimestamp\":\"2025-10-11T02:05:25.932Z\",\"MediaKey\":\"68e9bb661600b97c1420949f\"},{\"ResourceRecordKey\":\"NST7814313\",\"Order\":9,\"MediaObjectID\":\"9\",\"LongDescription\":\"20250826_130235.jpg\",\"ImageWidth\":1171,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1171x2080\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7814313/69720ab2-6b71-44a6-b647-b0a7b7c82239.jpeg\",\"MediaModificationTimestamp\":\"2025-10-11T02:05:25.953Z\",\"MediaKey\":\"68e9bb661600b97c142094a0\"},{\"ResourceRecordKey\":\"NST7814313\",\"Order\":10,\"MediaObjectID\":\"10\",\"LongDescription\":\"20250826_130300.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1171,\"ImageSizeDescription\":\"2080x1171\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7814313/31f625fe-3165-4b00-9382-55d3391e06f7.jpeg\",\"MediaModificationTimestamp\":\"2025-10-11T02:05:25.972Z\",\"MediaKey\":\"68e9bb661600b97c142094a1\"},{\"ResourceRecordKey\":\"NST7814313\",\"Order\":11,\"MediaObjectID\":\"11\",\"LongDescription\":\"20250826_130321.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1171,\"ImageSizeDescription\":\"2080x1171\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7814313/58d13cc6-e9ac-4093-865e-deefcc19d998.jpeg\",\"MediaModificationTimestamp\":\"2025-10-11T02:05:25.913Z\",\"MediaKey\":\"68e9bb661600b97c142094a2\"},{\"ResourceRecordKey\":\"NST7814313\",\"Order\":12,\"MediaObjectID\":\"12\",\"LongDescription\":\"20250826_130350.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1171,\"ImageSizeDescription\":\"2080x1171\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7814313/b99f4051-f60b-4e1d-8958-c3cd9dfff866.jpeg\",\"MediaModificationTimestamp\":\"2025-10-11T02:05:25.91Z\",\"MediaKey\":\"68e9bb661600b97c142094a3\"},{\"ResourceRecordKey\":\"NST7814313\",\"Order\":13,\"MediaObjectID\":\"13\",\"LongDescription\":\"20250826_130409.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1171,\"ImageSizeDescription\":\"2080x1171\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7814313/17ea3279-d22f-4e38-a0c9-84fbfb512676.jpeg\",\"MediaModificationTimestamp\":\"2025-10-11T02:05:25.933Z\",\"MediaKey\":\"68e9bb661600b97c142094a4\"},{\"ResourceRecordKey\":\"NST7814313\",\"Order\":14,\"MediaObjectID\":\"14\",\"LongDescription\":\"20250826_130423.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1171,\"ImageSizeDescription\":\"2080x1171\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7814313/0979e076-7046-4d5b-a0c0-ef5a1a798385.jpeg\",\"MediaModificationTimestamp\":\"2025-10-11T02:05:25.92Z\",\"MediaKey\":\"68e9bb661600b97c142094a5\"},{\"ResourceRecordKey\":\"NST7814313\",\"Order\":15,\"MediaObjectID\":\"15\",\"LongDescription\":\"20250826_130510.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1171,\"ImageSizeDescription\":\"2080x1171\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7814313/91a3ae63-27c4-4c80-b6ea-e1bb4c70af98.jpeg\",\"MediaModificationTimestamp\":\"2025-10-11T02:05:25.908Z\",\"MediaKey\":\"68e9bb661600b97c142094a6\"},{\"ResourceRecordKey\":\"NST7814313\",\"Order\":16,\"MediaObjectID\":\"16\",\"LongDescription\":\"20250826_130548.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1171,\"ImageSizeDescription\":\"2080x1171\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7814313/08d425d6-7e84-417a-9760-10a79770b73e.jpeg\",\"MediaModificationTimestamp\":\"2025-10-11T02:05:25.94Z\",\"MediaKey\":\"68e9bb661600b97c142094a7\"},{\"ResourceRecordKey\":\"NST7814313\",\"Order\":17,\"MediaObjectID\":\"17\",\"LongDescription\":\"20250826_130552.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1171,\"ImageSizeDescription\":\"2080x1171\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7814313/1d5adcd9-4044-406c-8d45-d6df191732ba.jpeg\",\"MediaModificationTimestamp\":\"2025-10-11T02:05:25.967Z\",\"MediaKey\":\"68e9bb661600b97c142094a8\"}]","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"20250826_125947.jpg\"},{\"Order\":2,\"Remarks\":\"Front.jpg\"},{\"Order\":3,\"Remarks\":\"20250826_130048.jpg\"},{\"Order\":4,\"Remarks\":\"20250826_130115.jpg\"},{\"Order\":5,\"Remarks\":\"20250826_130134.jpg\"},{\"Order\":6,\"Remarks\":\"20250826_130154.jpg\"},{\"Order\":7,\"Remarks\":\"20250826_130202.jpg\"},{\"Order\":8,\"Remarks\":\"20250826_130217.jpg\"},{\"Order\":9,\"Remarks\":\"20250826_130235.jpg\"},{\"Order\":10,\"Remarks\":\"20250826_130300.jpg\"},{\"Order\":11,\"Remarks\":\"20250826_130321.jpg\"},{\"Order\":12,\"Remarks\":\"20250826_130350.jpg\"},{\"Order\":13,\"Remarks\":\"20250826_130409.jpg\"},{\"Order\":14,\"Remarks\":\"20250826_130423.jpg\"},{\"Order\":15,\"Remarks\":\"20250826_130510.jpg\"},{\"Order\":16,\"Remarks\":\"20250826_130548.jpg\"},{\"Order\":17,\"Remarks\":\"20250826_130552.jpg\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17","CustomVTourURL":""}