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":1418222,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST6800211","MLSAGENTID":"NST506069136","MLSOFFICEID":"NST9817","ADDRESS":"873 Geranium Avenue E","ACRES":0.11,"AGENTOWNER":true,"AUCTIONYN":false,"BASEMENT":"Partial","BATHSTOTAL":2.0,"BEDROOMS":4,"CITY":"Saint Paul","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Vinyl Siding","FORECLOSURE":"No","LASTPRICE":180000.0,"LASTPRICEDATE":"2025-10-06T20:14:03.84","LATITUDE":44.97597406,"LENDEROWNED":"No","LISTDATE":"2025-10-06T05:00:00","LISTPRICE":180000.0,"LIVINGAREA":1590.0,"LONGITUDE":-93.06376444,"MODIFICATIONTIMESTAMP":"2025-10-07T10:59:03.342","NEIGHBORHOOD":"Payne-Phalen","OFFICE_OFFICENAME":"Herizon Realty","PHOTOCOUNT":13,"POSTALCODE":"55106","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Here is an investor's special. Please feel free to bring your ideas and plans. New roof in 2024. You can make this shine again. Please bring a light for showing: no water or electricity. Buy AS IS, WHERE IS. Only cash or Rehab loan.","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Age 8 Years or Less,Asphalt","SCHOOLDISTRICTNUMBER":"625-St. Paul","SCHOOLDISTRICTPHONE":"651-767-8100","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2025-10-06T20:14:03.84","LASTSTATUS":"Active","STREETDIRSUFFIX":"E","STREETNAME":"Geranium","STREETNUMBER":"873","STREETSUFFIX":"Avenue","STYLE":"Single Family Residence","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1907,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2025-10-07T10:56:03.359","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"HER01798.jpg\"},{\"Order\":2,\"Remarks\":\"HER01802.jpg\"},{\"Order\":3,\"Remarks\":\"552454640_1881206922754117_642554010056547006_n.jpg\"},{\"Order\":4,\"Remarks\":\"HER01804.jpg\"},{\"Order\":5,\"Remarks\":\"HER01800.jpg\"},{\"Order\":6,\"Remarks\":\"552991736_1352886616837472_4184270217339590541_n.jpg\"},{\"Order\":7,\"Remarks\":\"HER01806.jpg\"},{\"Order\":8,\"Remarks\":\"553197693_1948014592437797_225504586594990521_n.jpg\"},{\"Order\":9,\"Remarks\":\"553264200_3786741361625648_2059892244282093066_n.jpg\"},{\"Order\":10,\"Remarks\":\"554192810_828952383120541_989000183387859711_n.jpg\"},{\"Order\":11,\"Remarks\":\"553078792_808979434854914_5706761186698252347_n.jpg\"},{\"Order\":12,\"Remarks\":\"HER01824.jpg\"},{\"Order\":13,\"Remarks\":\"HER01822.jpg\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13","SOURCE":"MG_NST"}
{"ListingKey":"NST7812197","LotSizeArea":"0.11","NST_AgeOfProperty":"118","NST_AgentOwner":"Yes","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"True","NST_AmenitiesUnit":"Kitchen Window,Porch","Appliances":"None","NST_AssessmentPending":"Unknown","AssociationYN":"False","AssociationFee":"0","PropertyAttachedYN":"False","Basement":"Partial","BasementYN":"True","NST_BathDesc":"Main Floor Full Bath,Upper Level 3/4 Bath","BathroomsOneQuarter":"0","BathroomsFull":"1","BathroomsHalf":"0","BathroomsThreeQuarter":"1","BathroomsTotalInteger":"2","BedroomsTotal":"4","City":"Saint Paul","PropertyType":"Residential","NewConstructionYN":"False","Contingency":"None","Cooling":"None","CountyOrParish":"Ramsey","NST_DPResource":"Y","DaysOnMarket":"1","CumulativeDaysOnMarket":"1","NST_DiningRoomDescription":"Eat In Kitchen,Living/Dining Room","Directions":"South of Maryland 2blks just East of Arcade.","InternetAddressDisplayYN":"True","InternetEntireListingDisplayYN":"True","ConstructionMaterials":"Vinyl Siding","FireplacesTotal":"0","NST_ForeclosureStatus":"No","FoundationArea":"936","NST_FractionalOwnershipYN":"No","RoadFrontageType":"City Street","NST_Fuel":"Natural Gas","ParkingFeatures":"Detached","NST_GarageSquareFeet":"320","AccessibilityFeatures":"None","Heating":"Boiler","OriginalEntryTimestamp":"2025-10-06T20:08:00Z","LandLeaseYN":"False","NST_LastUpdateDate":"2025-10-07","Latitude":"44.9759740638","NST_LenderOwned":"No","ListAgentKey":"NST47562","ListAgentMlsId":"NST506069136","ListingContractDate":"2025-10-06T05:00:00Z","ListOfficeKey":"NST16766","ListOfficeName":"Herizon Realty","ListOfficeMlsId":"NST9817","ListPrice":"180000","LivingArea":"1590","Longitude":"-93.0637644367","LotSizeDimensions":"40x122","LotSizeSquareFeet":"4791.6","LotSizeUnits":"Acres","ListingId":"NST6800211","SourceSystemName":"RMLS","NST_ManufacturedHome":"No","MapCoordinateSource":"King's Street Atlas","AdditionalParcelsYN":"False","NST_NeighborhoodNumber":"Payne-Phalen","NST_OfficeBoard":"SPAAR","ParcelNumber":"282922220133","GarageSpaces":"1","PhotosCount":"13","PostalCity":"Saint Paul","PostalCode":"55106","NST_PotentialShortSale":"No","NST_PowerCompanyName":"Xcel Energy","NST_PresentUse":"Yearly","PublicRemarks":"Here is an investor's special. Please feel free to bring your ideas and plans. New roof in 2024. You can make this shine again. Please bring a light for showing: no water or electricity. Buy AS IS, WHERE IS. Only cash or Rehab loan.","NST_RentalLicenseYN":"No","RoadResponsibility":"Public Maintained Road","Roof":"Age 8 Years or Less,Asphalt","RoomType":"Living Room,Dining Room,Kitchen,Bedroom 1,Bedroom 2,Bedroom 3,Bedroom 4,Office","NST_AboveGradeSqFtTotal":"1590.0000","NST_BelowGradeSqFtTotal":"80.0000","NST_MainLevelFinishedArea":"936.0000","BuildingAreaTotal":"1670","HighSchoolDistrict":"St. Paul","NST_SchoolDistrictNumber":"625","NST_SchoolDistrictPhone":"651-767-8100","Sewer":"City Sewer/Connected","NST_SpecialSearch":"3 BR on One Level","AboveGradeFinishedArea":"1590","BelowGradeFinishedArea":"0","StateOrProvince":"MN","StandardStatus":"Active","Levels":"Two","StreetDirSuffix":"E","StreetName":"Geranium","StreetNumber":"873","StreetNumberNumeric":"873","StreetSuffix":"Avenue","PropertySubType":"Single Family Residence","NST_TaxWithAssessments":"3799.0000","TaxYear":"2025","TaxAnnualAmount":"3392","WaterSource":"City Water/Connected","YearBuilt":"1907","ZoningDescription":"Residential-Single Family","ModificationTimestamp":"2025-10-07T10:59:03.342Z","PhotosChangeTimestamp":"2025-10-07T10:56:03.359Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7812197\",\"Order\":1,\"MediaObjectID\":\"1\",\"LongDescription\":\"HER01798.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1389,\"ImageSizeDescription\":\"2080x1389\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7812197/2f12d316-33d9-4739-bb51-573f697fc4da.jpeg\",\"MediaModificationTimestamp\":\"2025-10-07T10:55:11.161Z\",\"MediaKey\":\"68e4f18f1bb3e6534fc29985\"},{\"ResourceRecordKey\":\"NST7812197\",\"Order\":2,\"MediaObjectID\":\"2\",\"LongDescription\":\"HER01802.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1389,\"ImageSizeDescription\":\"2080x1389\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7812197/dee7d151-c892-40da-8ff0-5bc24f9c5711.jpeg\",\"MediaModificationTimestamp\":\"2025-10-07T10:55:11.437Z\",\"MediaKey\":\"68e4f18f1bb3e6534fc29986\"},{\"ResourceRecordKey\":\"NST7812197\",\"Order\":3,\"MediaObjectID\":\"3\",\"LongDescription\":\"552454640_1881206922754117_642554010056547006_n.jpg\",\"ImageWidth\":1536,\"ImageHeight\":2048,\"ImageSizeDescription\":\"1536x2048\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7812197/cc7d1976-57a8-46d3-87f6-1c902b426abf.jpeg\",\"MediaModificationTimestamp\":\"2025-10-06T20:10:17.601Z\",\"MediaKey\":\"68e42229fd8ceb555c286154\"},{\"ResourceRecordKey\":\"NST7812197\",\"Order\":4,\"MediaObjectID\":\"4\",\"LongDescription\":\"HER01804.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1389,\"ImageSizeDescription\":\"2080x1389\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7812197/d2d0c342-03fa-45fe-a8f2-c59711925797.jpeg\",\"MediaModificationTimestamp\":\"2025-10-07T10:55:11.114Z\",\"MediaKey\":\"68e4f18f1bb3e6534fc29987\"},{\"ResourceRecordKey\":\"NST7812197\",\"Order\":5,\"MediaObjectID\":\"5\",\"LongDescription\":\"HER01800.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1389,\"ImageSizeDescription\":\"2080x1389\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7812197/766e764e-d13e-4f96-b1cc-110df9e84ffd.jpeg\",\"MediaModificationTimestamp\":\"2025-10-07T10:55:11.173Z\",\"MediaKey\":\"68e4f18f1bb3e6534fc29988\"},{\"ResourceRecordKey\":\"NST7812197\",\"Order\":6,\"MediaObjectID\":\"6\",\"LongDescription\":\"552991736_1352886616837472_4184270217339590541_n.jpg\",\"ImageWidth\":2048,\"ImageHeight\":1536,\"ImageSizeDescription\":\"2048x1536\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7812197/18159b4c-6094-4862-a0bd-019b7dc3ccfe.jpeg\",\"MediaModificationTimestamp\":\"2025-10-06T20:10:17.6Z\",\"MediaKey\":\"68e42229fd8ceb555c286155\"},{\"ResourceRecordKey\":\"NST7812197\",\"Order\":7,\"MediaObjectID\":\"7\",\"LongDescription\":\"HER01806.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1389,\"ImageSizeDescription\":\"2080x1389\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7812197/de21dcc9-34ee-40fc-9112-a22ac9152a25.jpeg\",\"MediaModificationTimestamp\":\"2025-10-07T10:55:11.135Z\",\"MediaKey\":\"68e4f18f1bb3e6534fc29989\"},{\"ResourceRecordKey\":\"NST7812197\",\"Order\":8,\"MediaObjectID\":\"8\",\"LongDescription\":\"553197693_1948014592437797_225504586594990521_n.jpg\",\"ImageWidth\":2048,\"ImageHeight\":1536,\"ImageSizeDescription\":\"2048x1536\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7812197/a357c0c4-8694-4c5d-adeb-33260cd2320b.jpeg\",\"MediaModificationTimestamp\":\"2025-10-06T20:10:17.683Z\",\"MediaKey\":\"68e42229fd8ceb555c286156\"},{\"ResourceRecordKey\":\"NST7812197\",\"Order\":9,\"MediaObjectID\":\"9\",\"LongDescription\":\"553264200_3786741361625648_2059892244282093066_n.jpg\",\"ImageWidth\":1536,\"ImageHeight\":2048,\"ImageSizeDescription\":\"1536x2048\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7812197/a9cbbfad-48bb-4b1c-a322-163d8d6b03ae.jpeg\",\"MediaModificationTimestamp\":\"2025-10-06T20:10:17.648Z\",\"MediaKey\":\"68e42229fd8ceb555c286157\"},{\"ResourceRecordKey\":\"NST7812197\",\"Order\":10,\"MediaObjectID\":\"10\",\"LongDescription\":\"554192810_828952383120541_989000183387859711_n.jpg\",\"ImageWidth\":2048,\"ImageHeight\":1536,\"ImageSizeDescription\":\"2048x1536\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7812197/0abf95df-9682-437b-b0cd-93a409ca58ae.jpeg\",\"MediaModificationTimestamp\":\"2025-10-06T20:10:17.662Z\",\"MediaKey\":\"68e42229fd8ceb555c286158\"},{\"ResourceRecordKey\":\"NST7812197\",\"Order\":11,\"MediaObjectID\":\"11\",\"LongDescription\":\"553078792_808979434854914_5706761186698252347_n.jpg\",\"ImageWidth\":2048,\"ImageHeight\":1536,\"ImageSizeDescription\":\"2048x1536\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7812197/cb63ffd2-b02d-41e8-ab72-59bc2ccf0188.jpeg\",\"MediaModificationTimestamp\":\"2025-10-06T20:10:17.718Z\",\"MediaKey\":\"68e42229fd8ceb555c286153\"},{\"ResourceRecordKey\":\"NST7812197\",\"Order\":12,\"MediaObjectID\":\"12\",\"LongDescription\":\"HER01824.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1389,\"ImageSizeDescription\":\"2080x1389\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7812197/dc4611ae-cfc5-48ff-b89f-ef879e45962f.jpeg\",\"MediaModificationTimestamp\":\"2025-10-07T10:55:11.107Z\",\"MediaKey\":\"68e4f18f1bb3e6534fc2998a\"},{\"ResourceRecordKey\":\"NST7812197\",\"Order\":13,\"MediaObjectID\":\"13\",\"LongDescription\":\"HER01822.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1389,\"ImageSizeDescription\":\"2080x1389\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7812197/5f8f97f2-7a85-4e8e-8bf3-e2941b77382d.jpeg\",\"MediaModificationTimestamp\":\"2025-10-07T10:55:11.13Z\",\"MediaKey\":\"68e4f18f1bb3e6534fc2998b\"}]","Rooms":"[{\"RoomKey\":\"NST115677886\",\"RoomType\":\"Living Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"10x12\",\"NST_RoomSortOrder\":\"1\"},{\"RoomKey\":\"NST115677887\",\"RoomType\":\"Dining Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"11x11\",\"NST_RoomSortOrder\":\"2\"},{\"RoomKey\":\"NST115677889\",\"RoomType\":\"Kitchen\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"10x12\",\"NST_RoomSortOrder\":\"3\"},{\"RoomKey\":\"NST115677890\",\"RoomType\":\"Bedroom 1\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"13x12\",\"NST_RoomSortOrder\":\"4\"},{\"RoomKey\":\"NST115677891\",\"RoomType\":\"Bedroom 2\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"11x10\",\"NST_RoomSortOrder\":\"5\"},{\"RoomKey\":\"NST115677892\",\"RoomType\":\"Bedroom 3\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"10x8\",\"NST_RoomSortOrder\":\"6\"},{\"RoomKey\":\"NST115677893\",\"RoomType\":\"Bedroom 4\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"10X8\",\"NST_RoomSortOrder\":\"7\"},{\"RoomKey\":\"NST115677895\",\"RoomType\":\"Office\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"14x13\",\"NST_RoomSortOrder\":\"8\"}]","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"HER01798.jpg\"},{\"Order\":2,\"Remarks\":\"HER01802.jpg\"},{\"Order\":3,\"Remarks\":\"552454640_1881206922754117_642554010056547006_n.jpg\"},{\"Order\":4,\"Remarks\":\"HER01804.jpg\"},{\"Order\":5,\"Remarks\":\"HER01800.jpg\"},{\"Order\":6,\"Remarks\":\"552991736_1352886616837472_4184270217339590541_n.jpg\"},{\"Order\":7,\"Remarks\":\"HER01806.jpg\"},{\"Order\":8,\"Remarks\":\"553197693_1948014592437797_225504586594990521_n.jpg\"},{\"Order\":9,\"Remarks\":\"553264200_3786741361625648_2059892244282093066_n.jpg\"},{\"Order\":10,\"Remarks\":\"554192810_828952383120541_989000183387859711_n.jpg\"},{\"Order\":11,\"Remarks\":\"553078792_808979434854914_5706761186698252347_n.jpg\"},{\"Order\":12,\"Remarks\":\"HER01824.jpg\"},{\"Order\":13,\"Remarks\":\"HER01822.jpg\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13","CustomVTourURL":""}