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":508412,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST7005678","MLSAGENTID":"NST798549702","MLSCOAGENTID":"NST506008353","MLSOFFICEID":"NST26320","ADDRESS":"1147 Hoyt Avenue W","ACRES":0.142,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Finished","BATHSTOTAL":1.0,"BEDROOMS":2,"CITY":"Saint Paul","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"FORECLOSURE":"No","LASTPRICE":345000.0,"LASTPRICEDATE":"2026-01-07T00:13:05.42","LATITUDE":44.988609,"LENDEROWNED":"No","LISTDATE":"2026-01-06T06:00:00","LISTPRICE":345000.0,"LIVINGAREA":942.0,"LONGITUDE":-93.148301,"MODIFICATIONTIMESTAMP":"2026-01-07T11:06:07.382","NEIGHBORHOOD":"89","OFFICE_OFFICENAME":"Opendoor Brokerage, LLC","PHOTOCOUNT":18,"POSTALCODE":"55108","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Welcome to 1147 Hoyt Ave W, a home that exudes charm and sophistication. The kitchen is a chef's dream, boasting all stainless steel appliances and an accent backsplash that adds a touch of elegance. The living area is warm and inviting, featuring a cozy fireplace that serves as the room's focal point. The entire home has been refreshed with fresh interior paint, creating a bright and airy atmosphere. Partial flooring replacement has been done, enhancing the home's modern appeal. Additionally, new appliances have been installed, ensuring convenience and efficiency. This property offers a unique blend of style and comfort, making it a perfect place to call home. This home has been virtually staged to illustrate its potential.. Included 100-Day Home Warranty with buyer activation","ROADBETWEENWATERFRONTANDHOMEYN":false,"SCHOOLDISTRICTNUMBER":"2102-St. Paul","SCHOOLDISTRICTPHONE":"6517678100","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2026-01-07T00:13:05.42","LASTSTATUS":"Active","STREETDIRSUFFIX":"W","STREETNAME":"Hoyt","STREETNUMBER":"1147","STREETSUFFIX":"Avenue","STYLE":"Single Family Residence","TRANSACTIONTYPE":"For","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1938,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2026-01-07T00:16:06.595","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"photo_01.jpg\"},{\"Order\":2,\"Remarks\":\"photo_02.jpg\"},{\"Order\":3,\"Remarks\":\"photo_03.jpg\"},{\"Order\":4,\"Remarks\":\"photo_04.jpg\"},{\"Order\":5,\"Remarks\":\"photo_05.jpg\"},{\"Order\":6,\"Remarks\":\"photo_06.jpg\"},{\"Order\":7,\"Remarks\":\"photo_07.jpg\"},{\"Order\":8,\"Remarks\":\"photo_08.jpg\"},{\"Order\":9,\"Remarks\":\"photo_09.jpg\"},{\"Order\":10,\"Remarks\":\"photo_10.jpg\"},{\"Order\":11,\"Remarks\":\"photo_11.jpg\"},{\"Order\":12,\"Remarks\":\"photo_12.jpg\"},{\"Order\":13,\"Remarks\":\"photo_13.jpg\"},{\"Order\":14,\"Remarks\":\"photo_14.jpg\"},{\"Order\":15,\"Remarks\":\"photo_15.jpg\"},{\"Order\":16,\"Remarks\":\"photo_16.jpg\"},{\"Order\":17,\"Remarks\":\"photo_17.jpg\"},{\"Order\":18,\"Remarks\":\"Floor plan.jpeg\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18","SOURCE":"MG_NST"}
{"ListingKey":"NST7840123","NST_AboveGradeSqFtTotal":"742","AboveGradeFinishedArea":"742","AccessibilityFeatures":"None","AdditionalParcelsYN":"False","NST_AgentOwner":"No","LivingAreaUnits":"Square Feet","NST_AssessmentPending":"Unknown","AssociationYN":"False","AssociationFee":"0","Basement":"Finished","BasementYN":"True","BathroomsFull":"1","BathroomsHalf":"0","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"1","BedroomsTotal":"2","NST_BelowGradeSqFtTotal":"750","BelowGradeFinishedArea":"200","CumulativeDaysOnMarket":"0","CarportSpaces":"0","City":"Saint Paul","NewConstructionYN":"False","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Ramsey","NST_DPResource":"Yes","Directions":"Head east on Larpenteur Ave W toward Arona St\nTurn right onto Lexington Pkwy N\nTurn right - Destination will be on the left","DocumentsCount":"2","DocumentsChangeTimestamp":"2026-01-07T00:44:06.23Z","DaysOnMarket":"0","FireplaceYN":"True","FireplacesTotal":"1","FoundationArea":"742","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","NST_GarageSquareFeet":"228","GarageSpaces":"3","Heating":"Forced Air","HighSchoolDistrict":"St. Paul","NST_ForeclosureStatus":"No","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"False","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","Latitude":"44.988609","NST_LenderOwned":"No","Levels":"One","ListPrice":"345000","ListingContractDate":"2026-01-06T06:00:00Z","ListingId":"NST7005678","LivingArea":"942","Longitude":"-93.148301","LotSizeArea":"0.142","LotSizeDimensions":"50x124","LotSizeUnits":"Acres","NST_MainLevelFinishedArea":"742","NST_ManufacturedHome":"N","NST_NeighborhoodNumber":"89","OriginalEntryTimestamp":"2026-01-06T18:08:41Z","ParcelNumber":"222923110172","NST_SchoolDistrictNumber":"2102","ParkingFeatures":"Detached Garage","PhotosCount":"18","PhotosChangeTimestamp":"2026-01-07T00:16:06.595Z","PostalCity":"Saint Paul","PostalCode":"55108","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PropertyAttachedYN":"False","PropertySubType":"Single Family Residence","PropertyType":"Residential","PublicRemarks":"Welcome to 1147 Hoyt Ave W, a home that exudes charm and sophistication. The kitchen is a chef's dream, boasting all stainless steel appliances and an accent backsplash that adds a touch of elegance. The living area is warm and inviting, featuring a cozy fireplace that serves as the room's focal point. The entire home has been refreshed with fresh interior paint, creating a bright and airy atmosphere. Partial flooring replacement has been done, enhancing the home's modern appeal. Additionally, new appliances have been installed, ensuring convenience and efficiency. This property offers a unique blend of style and comfort, making it a perfect place to call home. This home has been virtually staged to illustrate its potential.. Included 100-Day Home Warranty with buyer activation","PublicSurveyRange":"23","PublicSurveySection":"22","PublicSurveyTownship":"29","NST_SchoolDistrictPhone":"6517678100","Sewer":"City Sewer/Connected","StandardStatus":"Active","StateOrProvince":"MN","StreetDirSuffix":"W","StreetName":"Hoyt","StreetNumber":"1147","StreetNumberNumeric":"1147","StreetSuffix":"Avenue","SubdivisionName":"Clifton Dale, , Ramsey Co, Minn","TaxAnnualAmount":"4376","NST_TaxWithAssessments":"4376","TaxYear":"2026","Township":"Saint Paul","VideosCount":"0","WaterSource":"City Water/Connected","YearBuilt":"1938","ZoningDescription":"Residential-Single Family","CoListAgentKey":"NST97067","CoListAgentMlsId":"NST506008353","CoListOfficeName":"Opendoor Brokerage, LLC","ListAgentKey":"NST225984","ListAgentMlsId":"NST798549702","ListOfficeMlsId":"NST26320","ListOfficeName":"Opendoor Brokerage, LLC","ListOfficeKey":"NST26320","ModificationTimestamp":"2026-01-07T11:06:07.382Z","OriginatingSystemName":"northstar","Media":"[{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7840123/6eb60631-5a8b-4886-97eb-f8021eabc81c.jpeg\",\"LongDescription\":\"Floor plan.jpeg\",\"Order\":18,\"MediaObjectID\":\"NST18\",\"ResourceRecordKey\":\"NST7840123\",\"ImageWidth\":2080,\"ImageHeight\":1170,\"ImageSizeDescription\":\"2080x1170\",\"MediaModificationTimestamp\":\"2026-01-07T00:15:53.796Z\",\"MediaKey\":\"NST120060651\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7840123/0a517212-3613-4ad8-b9f7-2deea9faae12.jpeg\",\"LongDescription\":\"photo_10.jpg\",\"Order\":10,\"MediaObjectID\":\"NST10\",\"ResourceRecordKey\":\"NST7840123\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-01-07T00:14:14.548Z\",\"MediaKey\":\"NST120060639\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7840123/7fd8a821-07be-48b7-960b-413c5edd3411.jpeg\",\"LongDescription\":\"photo_16.jpg\",\"Order\":16,\"MediaObjectID\":\"NST16\",\"ResourceRecordKey\":\"NST7840123\",\"ImageWidth\":2080,\"ImageHeight\":1559,\"ImageSizeDescription\":\"2080x1559\",\"MediaModificationTimestamp\":\"2026-01-07T00:14:14.523Z\",\"MediaKey\":\"NST120060633\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7840123/8f657726-cfc3-4097-b8d1-240883b73fc8.jpeg\",\"LongDescription\":\"photo_13.jpg\",\"Order\":13,\"MediaObjectID\":\"NST13\",\"ResourceRecordKey\":\"NST7840123\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-01-07T00:14:14.539Z\",\"MediaKey\":\"NST120060636\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7840123/751e1957-7a0b-41f9-8d9e-36d0ef78e191.jpeg\",\"LongDescription\":\"photo_11.jpg\",\"Order\":11,\"MediaObjectID\":\"NST11\",\"ResourceRecordKey\":\"NST7840123\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-01-07T00:14:14.524Z\",\"MediaKey\":\"NST120060638\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7840123/b05a31e2-0592-4808-a3bb-7dd83fada25b.jpeg\",\"LongDescription\":\"photo_05.jpg\",\"Order\":5,\"MediaObjectID\":\"NST5\",\"ResourceRecordKey\":\"NST7840123\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-01-07T00:14:14.558Z\",\"MediaKey\":\"NST120060644\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7840123/aa029fec-8a57-4edb-94ae-bf5180c206b0.jpeg\",\"LongDescription\":\"photo_07.jpg\",\"Order\":7,\"MediaObjectID\":\"NST7\",\"ResourceRecordKey\":\"NST7840123\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-01-07T00:14:14.579Z\",\"MediaKey\":\"NST120060642\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7840123/9b90dc05-283b-40ad-add2-34cb53f056d6.jpeg\",\"LongDescription\":\"photo_04.jpg\",\"Order\":4,\"MediaObjectID\":\"NST4\",\"ResourceRecordKey\":\"NST7840123\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-01-07T00:14:14.568Z\",\"MediaKey\":\"NST120060645\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7840123/e719903e-8713-4cc9-9f37-664cffe42530.jpeg\",\"LongDescription\":\"photo_02.jpg\",\"Order\":2,\"MediaObjectID\":\"NST2\",\"ResourceRecordKey\":\"NST7840123\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-01-07T00:14:14.541Z\",\"MediaKey\":\"NST120060647\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7840123/b6057fc6-381f-4410-8167-6e1d8cb55622.jpeg\",\"LongDescription\":\"photo_17.jpg\",\"Order\":17,\"MediaObjectID\":\"NST17\",\"ResourceRecordKey\":\"NST7840123\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-01-07T00:14:14.53Z\",\"MediaKey\":\"NST120060632\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7840123/164f3012-f326-4c41-a641-41ea14f69a54.jpeg\",\"LongDescription\":\"photo_12.jpg\",\"Order\":12,\"MediaObjectID\":\"NST12\",\"ResourceRecordKey\":\"NST7840123\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-01-07T00:14:14.553Z\",\"MediaKey\":\"NST120060637\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7840123/c7259670-6ca1-488f-b92e-18d1dd1ced19.jpeg\",\"LongDescription\":\"photo_08.jpg\",\"Order\":8,\"MediaObjectID\":\"NST8\",\"ResourceRecordKey\":\"NST7840123\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-01-07T00:14:14.519Z\",\"MediaKey\":\"NST120060641\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7840123/5f9becf4-a6fe-4fe3-9227-84f1e92b3f53.jpeg\",\"LongDescription\":\"photo_15.jpg\",\"Order\":15,\"MediaObjectID\":\"NST15\",\"ResourceRecordKey\":\"NST7840123\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-01-07T00:14:14.518Z\",\"MediaKey\":\"NST120060634\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7840123/13db26bf-fbc1-4d98-b59b-a7366bca7f9d.jpeg\",\"LongDescription\":\"photo_03.jpg\",\"Order\":3,\"MediaObjectID\":\"NST3\",\"ResourceRecordKey\":\"NST7840123\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-01-07T00:14:14.552Z\",\"MediaKey\":\"NST120060646\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7840123/c3fd8c2b-24f6-44e8-98fa-fd91fc420a03.jpeg\",\"LongDescription\":\"photo_09.jpg\",\"Order\":9,\"MediaObjectID\":\"NST9\",\"ResourceRecordKey\":\"NST7840123\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-01-07T00:14:14.541Z\",\"MediaKey\":\"NST120060640\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7840123/6d16992b-64a9-430a-9269-0e9a05379b6e.jpeg\",\"LongDescription\":\"photo_06.jpg\",\"Order\":6,\"MediaObjectID\":\"NST6\",\"ResourceRecordKey\":\"NST7840123\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-01-07T00:14:14.536Z\",\"MediaKey\":\"NST120060643\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7840123/b8896573-0f31-4bfd-a505-23552f9075ef.jpeg\",\"LongDescription\":\"photo_14.jpg\",\"Order\":14,\"MediaObjectID\":\"NST14\",\"ResourceRecordKey\":\"NST7840123\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-01-07T00:14:14.529Z\",\"MediaKey\":\"NST120060635\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7840123/c106b7e1-ad06-4b89-b331-1f3d0ae77f37.jpeg\",\"LongDescription\":\"photo_01.jpg\",\"Order\":1,\"MediaObjectID\":\"NST1\",\"ResourceRecordKey\":\"NST7840123\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-01-07T00:14:14.571Z\",\"MediaKey\":\"NST120060648\"}]","Media__MediaURL":"https://s3.amazonaws.com/mlsgrid/images/NST7840123/6eb60631-5a8b-4886-97eb-f8021eabc81c.jpeg","Media__LongDescription":"Floor plan.jpeg","Media__Order":"18","Media__MediaObjectID":"NST18","Media__ResourceRecordKey":"NST7840123","Media__ImageWidth":"2080","Media__ImageHeight":"1170","Media__ImageSizeDescription":"2080x1170","Media__MediaModificationTimestamp":"1/7/2026 12:15:53 AM","Media__MediaKey":"NST120060651","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"photo_01.jpg\"},{\"Order\":2,\"Remarks\":\"photo_02.jpg\"},{\"Order\":3,\"Remarks\":\"photo_03.jpg\"},{\"Order\":4,\"Remarks\":\"photo_04.jpg\"},{\"Order\":5,\"Remarks\":\"photo_05.jpg\"},{\"Order\":6,\"Remarks\":\"photo_06.jpg\"},{\"Order\":7,\"Remarks\":\"photo_07.jpg\"},{\"Order\":8,\"Remarks\":\"photo_08.jpg\"},{\"Order\":9,\"Remarks\":\"photo_09.jpg\"},{\"Order\":10,\"Remarks\":\"photo_10.jpg\"},{\"Order\":11,\"Remarks\":\"photo_11.jpg\"},{\"Order\":12,\"Remarks\":\"photo_12.jpg\"},{\"Order\":13,\"Remarks\":\"photo_13.jpg\"},{\"Order\":14,\"Remarks\":\"photo_14.jpg\"},{\"Order\":15,\"Remarks\":\"photo_15.jpg\"},{\"Order\":16,\"Remarks\":\"photo_16.jpg\"},{\"Order\":17,\"Remarks\":\"photo_17.jpg\"},{\"Order\":18,\"Remarks\":\"Floor plan.jpeg\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18","CustomVTourURL":""}