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":1406528,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST6786561","MLSAGENTID":"NST506008649","MLSOFFICEID":"NST6582","ADDRESS":"1236 Hubbard Avenue","ACRES":0.11,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Block","BATHSTOTAL":1.0,"BEDROOMS":2,"CITY":"Saint Paul","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Shake Siding","FORECLOSURE":"No","LASTPRICE":242999.0,"LASTPRICEDATE":"2025-09-10T14:54:03.767","LATITUDE":44.965419,"LENDEROWNED":"Not disclosed","LISTDATE":"2025-09-10T05:00:00","LISTPRICE":242999.0,"LIVINGAREA":934.0,"LONGITUDE":-93.152528,"MODIFICATIONTIMESTAMP":"2025-09-10T15:22:04.588","NEIGHBORHOOD":"Hamline-Midway","OFFICE_OFFICENAME":"Keller Williams Realty Integrity Lakes","PHOTOCOUNT":16,"POSTALCODE":"55104","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Perfect starter home located in Hamline-Midway neighborhood of St Paul! Ready to move in with hardwood floors though out! Two car garage! Come check out this cozy home with amazing potential!","ROADBETWEENWATERFRONTANDHOMEYN":false,"SCHOOLDISTRICTNUMBER":"625-St. Paul","SCHOOLDISTRICTPHONE":"651-767-8100","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2025-09-10T14:54:03.767","LASTSTATUS":"Active","STREETNAME":"Hubbard","STREETNUMBER":"1236","STREETSUFFIX":"Avenue","STYLE":"Single Family Residence","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1919,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2025-09-10T14:54:03.766","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"IMG_2024.jpg\"},{\"Order\":2,\"Remarks\":\"IMG_2026.jpg\"},{\"Order\":3,\"Remarks\":\"IMG_2027.jpg\"},{\"Order\":4,\"Remarks\":\"IMG_2029.jpg\"},{\"Order\":5,\"Remarks\":\"IMG_2030.jpg\"},{\"Order\":6,\"Remarks\":\"IMG_2031.jpg\"},{\"Order\":7,\"Remarks\":\"IMG_2032.jpg\"},{\"Order\":8,\"Remarks\":\"IMG_2033.jpg\"},{\"Order\":9,\"Remarks\":\"IMG_2034.jpg\"},{\"Order\":10,\"Remarks\":\"IMG_2039.jpg\"},{\"Order\":11,\"Remarks\":\"IMG_2035.jpg\"},{\"Order\":12,\"Remarks\":\"IMG_2036.jpg\"},{\"Order\":13,\"Remarks\":\"IMG_5213.jpg\"},{\"Order\":14,\"Remarks\":\"IMG_5214.jpg\"},{\"Order\":15,\"Remarks\":\"IMG_2037.jpg\"},{\"Order\":16,\"Remarks\":\"IMG_2038.jpg\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16","SOURCE":"MG_NST"}
{"ListingKey":"NST7800539","LotSizeArea":"0.11","NST_AgeOfProperty":"106","NST_AgentOwner":"No","InternetAutomatedValuationDisplayYN":"False","InternetConsumerCommentYN":"False","Appliances":"Dishwasher,Dryer,Gas Water Heater,Range,Refrigerator,Washer","NST_AssessmentPending":"No","AssociationYN":"False","AssociationFee":"0","PropertyAttachedYN":"False","Basement":"Block","BasementYN":"True","NST_BathDesc":"Main Floor Full Bath","BathroomsOneQuarter":"0","BathroomsFull":"1","BathroomsHalf":"0","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"1","BedroomsTotal":"2","City":"Saint Paul","PropertyType":"Residential","NST_ConstructionMaterialsDesc":"Block,Brick,Frame","NewConstructionYN":"False","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Ramsey","NST_DiningRoomDescription":"Informal Dining Room","Directions":"Lexington to Hubbard west to home","InternetAddressDisplayYN":"True","InternetEntireListingDisplayYN":"True","Electric":"Circuit Breakers","ConstructionMaterials":"Shake Siding","Fencing":"Wood","FireplacesTotal":"0","NST_ForeclosureStatus":"No","FoundationArea":"700","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","ParkingFeatures":"Detached","NST_GarageSquareFeet":"380","AccessibilityFeatures":"None","Heating":"Forced Air","OriginalEntryTimestamp":"2025-09-10T14:49:51Z","LandLeaseYN":"False","NST_LastUpdateDate":"2025-09-10","Latitude":"44.965419","NST_LenderOwned":"Not disclosed","ListAgentKey":"NST97722","ListAgentMlsId":"NST506008649","ListingContractDate":"2025-09-10T05:00:00Z","ListOfficeKey":"NST11236","ListOfficeName":"Keller Williams Realty Integrity Lakes","ListOfficeMlsId":"NST6582","ListPrice":"242999","LivingArea":"934","Longitude":"-93.152528","LotSizeDimensions":"40x124","LotSizeSquareFeet":"4922.28","LotSizeUnits":"Acres","ListingId":"NST6786561","SourceSystemName":"RMLS","NST_ManufacturedHome":"No","MapCoordinateSource":"King's Street Atlas","AdditionalParcelsYN":"False","NST_NeighborhoodNumber":"Hamline-Midway","NST_OfficeBoard":"MAAR","ParcelNumber":"272923430032","GarageSpaces":"2","PhotosCount":"16","PostalCity":"Saint Paul","PostalCode":"55104","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PublicRemarks":"Perfect starter home located in Hamline-Midway neighborhood of St Paul! Ready to move in with hardwood floors though out! Two car garage! Come check out this cozy home with amazing potential!","PublicSurveyRange":"23","PublicSurveySection":"27","PublicSurveyTownship":"29","NST_RentalLicenseYN":"No","RoomType":"Living Room,Bedroom 1,Bedroom 2,Kitchen","NST_AboveGradeSqFtTotal":"650.0000","NST_BelowGradeSqFtTotal":"284.0000","NST_MainLevelFinishedArea":"650.0000","BuildingAreaTotal":"934","HighSchoolDistrict":"St. Paul","NST_SchoolDistrictNumber":"625","NST_SchoolDistrictPhone":"651-767-8100","Sewer":"City Sewer/Connected","AboveGradeFinishedArea":"650","BelowGradeFinishedArea":"284","StateOrProvince":"MN","StandardStatus":"Active","Levels":"One","StreetName":"Hubbard","StreetNumber":"1236","StreetNumberNumeric":"1236","StreetSuffix":"Avenue","PropertySubType":"Single Family Residence","SubdivisionName":"Hersey Woolsey Add","NST_TaxWithAssessments":"3686.0000","TaxYear":"2024","TaxAnnualAmount":"3686","WaterSource":"City Water/Connected","YearBuilt":"1919","ZoningDescription":"Residential-Single Family","ModificationTimestamp":"2025-09-10T15:22:04.588Z","PhotosChangeTimestamp":"2025-09-10T14:54:03.766Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7800539\",\"Order\":1,\"MediaObjectID\":\"1\",\"LongDescription\":\"IMG_2024.jpg\",\"ImageWidth\":640,\"ImageHeight\":480,\"ImageSizeDescription\":\"640x480\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7800539/8a2291bb-069b-40f4-a159-d5733562ccdf.jpeg\",\"MediaModificationTimestamp\":\"2025-09-10T14:53:05.265Z\",\"MediaKey\":\"68c190d19ad474293f85665f\"},{\"ResourceRecordKey\":\"NST7800539\",\"Order\":2,\"MediaObjectID\":\"2\",\"LongDescription\":\"IMG_2026.jpg\",\"ImageWidth\":640,\"ImageHeight\":480,\"ImageSizeDescription\":\"640x480\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7800539/a30e8749-332e-4928-b34f-3bbd31bbe685.jpeg\",\"MediaModificationTimestamp\":\"2025-09-10T14:53:05.254Z\",\"MediaKey\":\"68c190d19ad474293f856660\"},{\"ResourceRecordKey\":\"NST7800539\",\"Order\":3,\"MediaObjectID\":\"3\",\"LongDescription\":\"IMG_2027.jpg\",\"ImageWidth\":640,\"ImageHeight\":480,\"ImageSizeDescription\":\"640x480\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7800539/f1661eb0-d1c6-43c5-8870-2cf12e2a2884.jpeg\",\"MediaModificationTimestamp\":\"2025-09-10T14:53:05.257Z\",\"MediaKey\":\"68c190d19ad474293f856661\"},{\"ResourceRecordKey\":\"NST7800539\",\"Order\":4,\"MediaObjectID\":\"4\",\"LongDescription\":\"IMG_2029.jpg\",\"ImageWidth\":640,\"ImageHeight\":480,\"ImageSizeDescription\":\"640x480\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7800539/f53211cc-ca74-4ab2-ab90-b175855d01f8.jpeg\",\"MediaModificationTimestamp\":\"2025-09-10T14:53:05.263Z\",\"MediaKey\":\"68c190d19ad474293f856662\"},{\"ResourceRecordKey\":\"NST7800539\",\"Order\":5,\"MediaObjectID\":\"5\",\"LongDescription\":\"IMG_2030.jpg\",\"ImageWidth\":640,\"ImageHeight\":480,\"ImageSizeDescription\":\"640x480\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7800539/bde235ee-bff2-4c7d-9a19-f1c5fcf73845.jpeg\",\"MediaModificationTimestamp\":\"2025-09-10T14:53:05.258Z\",\"MediaKey\":\"68c190d19ad474293f856663\"},{\"ResourceRecordKey\":\"NST7800539\",\"Order\":6,\"MediaObjectID\":\"6\",\"LongDescription\":\"IMG_2031.jpg\",\"ImageWidth\":640,\"ImageHeight\":480,\"ImageSizeDescription\":\"640x480\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7800539/508a4c8a-308e-45c8-8d44-fe9fd6cf49b6.jpeg\",\"MediaModificationTimestamp\":\"2025-09-10T14:53:05.257Z\",\"MediaKey\":\"68c190d19ad474293f856664\"},{\"ResourceRecordKey\":\"NST7800539\",\"Order\":7,\"MediaObjectID\":\"7\",\"LongDescription\":\"IMG_2032.jpg\",\"ImageWidth\":640,\"ImageHeight\":480,\"ImageSizeDescription\":\"640x480\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7800539/ba156727-8f14-40bb-b6d8-81843b95e355.jpeg\",\"MediaModificationTimestamp\":\"2025-09-10T14:53:05.235Z\",\"MediaKey\":\"68c190d19ad474293f856665\"},{\"ResourceRecordKey\":\"NST7800539\",\"Order\":8,\"MediaObjectID\":\"8\",\"LongDescription\":\"IMG_2033.jpg\",\"ImageWidth\":640,\"ImageHeight\":480,\"ImageSizeDescription\":\"640x480\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7800539/6cdf0176-54d0-4b6a-a3ad-cc8fc7aba1f2.jpeg\",\"MediaModificationTimestamp\":\"2025-09-10T14:53:05.245Z\",\"MediaKey\":\"68c190d19ad474293f856666\"},{\"ResourceRecordKey\":\"NST7800539\",\"Order\":9,\"MediaObjectID\":\"9\",\"LongDescription\":\"IMG_2034.jpg\",\"ImageWidth\":640,\"ImageHeight\":480,\"ImageSizeDescription\":\"640x480\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7800539/6fd1cc0a-ac70-4d2f-819b-7feed1568a72.jpeg\",\"MediaModificationTimestamp\":\"2025-09-10T14:53:05.326Z\",\"MediaKey\":\"68c190d19ad474293f856667\"},{\"ResourceRecordKey\":\"NST7800539\",\"Order\":10,\"MediaObjectID\":\"10\",\"LongDescription\":\"IMG_2039.jpg\",\"ImageWidth\":640,\"ImageHeight\":480,\"ImageSizeDescription\":\"640x480\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7800539/accf1c27-bcb8-42df-8421-8ac38edf0819.jpeg\",\"MediaModificationTimestamp\":\"2025-09-10T14:53:05.281Z\",\"MediaKey\":\"68c190d19ad474293f856668\"},{\"ResourceRecordKey\":\"NST7800539\",\"Order\":11,\"MediaObjectID\":\"11\",\"LongDescription\":\"IMG_2035.jpg\",\"ImageWidth\":640,\"ImageHeight\":480,\"ImageSizeDescription\":\"640x480\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7800539/6bf652aa-3e3d-4ad0-bc6c-6676382c5c82.jpeg\",\"MediaModificationTimestamp\":\"2025-09-10T14:53:05.26Z\",\"MediaKey\":\"68c190d19ad474293f856669\"},{\"ResourceRecordKey\":\"NST7800539\",\"Order\":12,\"MediaObjectID\":\"12\",\"LongDescription\":\"IMG_2036.jpg\",\"ImageWidth\":640,\"ImageHeight\":480,\"ImageSizeDescription\":\"640x480\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7800539/fbbe032f-bc1e-4e1e-91d2-526d2942cc07.jpeg\",\"MediaModificationTimestamp\":\"2025-09-10T14:53:05.229Z\",\"MediaKey\":\"68c190d19ad474293f85666a\"},{\"ResourceRecordKey\":\"NST7800539\",\"Order\":13,\"MediaObjectID\":\"13\",\"LongDescription\":\"IMG_5213.jpg\",\"ImageWidth\":480,\"ImageHeight\":640,\"ImageSizeDescription\":\"480x640\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7800539/c6e0c155-ade5-4a14-8699-47e30dcd9fda.jpeg\",\"MediaModificationTimestamp\":\"2025-09-10T14:53:05.24Z\",\"MediaKey\":\"68c190d19ad474293f85666b\"},{\"ResourceRecordKey\":\"NST7800539\",\"Order\":14,\"MediaObjectID\":\"14\",\"LongDescription\":\"IMG_5214.jpg\",\"ImageWidth\":480,\"ImageHeight\":640,\"ImageSizeDescription\":\"480x640\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7800539/b5fe87ca-b7ba-4637-8430-5d13a4234c04.jpeg\",\"MediaModificationTimestamp\":\"2025-09-10T14:53:05.273Z\",\"MediaKey\":\"68c190d19ad474293f85666c\"},{\"ResourceRecordKey\":\"NST7800539\",\"Order\":15,\"MediaObjectID\":\"15\",\"LongDescription\":\"IMG_2037.jpg\",\"ImageWidth\":640,\"ImageHeight\":480,\"ImageSizeDescription\":\"640x480\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7800539/06d00c67-4f1a-42dd-8ce3-b7cf9e2783bd.jpeg\",\"MediaModificationTimestamp\":\"2025-09-10T14:53:05.244Z\",\"MediaKey\":\"68c190d19ad474293f85666d\"},{\"ResourceRecordKey\":\"NST7800539\",\"Order\":16,\"MediaObjectID\":\"16\",\"LongDescription\":\"IMG_2038.jpg\",\"ImageWidth\":640,\"ImageHeight\":480,\"ImageSizeDescription\":\"640x480\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7800539/d5ec048a-7b11-4f57-badb-564989a36d3f.jpeg\",\"MediaModificationTimestamp\":\"2025-09-10T14:53:05.265Z\",\"MediaKey\":\"68c190d19ad474293f85666e\"}]","Rooms":"[{\"RoomKey\":\"NST115600031\",\"RoomType\":\"Living Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"15x12\",\"NST_RoomSortOrder\":\"1\"},{\"RoomKey\":\"NST115600032\",\"RoomType\":\"Bedroom 1\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"12x9\",\"NST_RoomSortOrder\":\"2\"},{\"RoomKey\":\"NST115600033\",\"RoomType\":\"Bedroom 2\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"12x9\",\"NST_RoomSortOrder\":\"3\"},{\"RoomKey\":\"NST115600034\",\"RoomType\":\"Kitchen\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"12x8\",\"NST_RoomSortOrder\":\"4\"}]","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"IMG_2024.jpg\"},{\"Order\":2,\"Remarks\":\"IMG_2026.jpg\"},{\"Order\":3,\"Remarks\":\"IMG_2027.jpg\"},{\"Order\":4,\"Remarks\":\"IMG_2029.jpg\"},{\"Order\":5,\"Remarks\":\"IMG_2030.jpg\"},{\"Order\":6,\"Remarks\":\"IMG_2031.jpg\"},{\"Order\":7,\"Remarks\":\"IMG_2032.jpg\"},{\"Order\":8,\"Remarks\":\"IMG_2033.jpg\"},{\"Order\":9,\"Remarks\":\"IMG_2034.jpg\"},{\"Order\":10,\"Remarks\":\"IMG_2039.jpg\"},{\"Order\":11,\"Remarks\":\"IMG_2035.jpg\"},{\"Order\":12,\"Remarks\":\"IMG_2036.jpg\"},{\"Order\":13,\"Remarks\":\"IMG_5213.jpg\"},{\"Order\":14,\"Remarks\":\"IMG_5214.jpg\"},{\"Order\":15,\"Remarks\":\"IMG_2037.jpg\"},{\"Order\":16,\"Remarks\":\"IMG_2038.jpg\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16","CustomVTourURL":""}