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":1418754,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST6801030","MLSAGENTID":"NST502044902","MLSOFFICEID":"NST251886","ADDRESS":"1870 Clarence Street","ACRES":0.25,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Full,Partially Finished","BATHSTOTAL":2.0,"BEDROOMS":3,"CITY":"Maplewood","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Vinyl Siding","FORECLOSURE":"No","LASTPRICE":298900.0,"LASTPRICEDATE":"2025-10-08T03:04:05.2","LATITUDE":44.997568,"LENDEROWNED":"No","LISTDATE":"2025-10-07T05:00:00","LISTPRICE":298900.0,"LIVINGAREA":1405.0,"LONGITUDE":-93.042746,"MODIFICATIONTIMESTAMP":"2025-10-08T10:07:04.993","OFFICE_OFFICENAME":"Inspire Realty","PHOTOCOUNT":20,"POSTALCODE":"55109","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Super cute corner lot in quiet Maplewood neighborhood. This quaint house has charm galore! On the main level there's a nicely appointed kitchen with granite counters, surprising storage and great counter space. The adjoining room can either be a dining room or living room based upon your life style. Continuing on the main level is a huge family room! Two living spaces that can flow together or remain separate. There's a huge bedroom upstairs with loads of storage. The basement already complete with second bathroom and is waiting for your ideas to make it complete! Outside there's a huge back yard with patio, love-seat swing and a storage shed. This quiet, corner lot home has it all at an extremely affordable price!","ROADBETWEENWATERFRONTANDHOMEYN":false,"SCHOOLDISTRICTNUMBER":"622-North St Paul-Maplewood","SCHOOLDISTRICTPHONE":"651-748-7410","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2025-10-08T03:04:05.2","LASTSTATUS":"Active","STREETNAME":"Clarence","STREETNUMBER":"1870","STREETSUFFIX":"Street","STYLE":"Single Family Residence","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1935,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2025-10-08T03:16:03.807","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"Cute, quiet home on a huge corner lot.\"},{\"Order\":3,\"Remarks\":\"View from the front entryway. Notice the natural wood floors, working fireplace. What a cozy space.\"},{\"Order\":4,\"Remarks\":\"View from the kitchen entryway.\"},{\"Order\":5,\"Remarks\":\"View from the family room doorway.\"},{\"Order\":6,\"Remarks\":\"Clever kitchen with surprising storage and counter space!\"},{\"Order\":8,\"Remarks\":\"Newer stainless appliances.\"},{\"Order\":10,\"Remarks\":\"This massive, light-filled family/sun room off the living room is such a great space!\"},{\"Order\":11,\"Remarks\":\"Owner's bedroom.\"},{\"Order\":12,\"Remarks\":\"Nicely appointed main level bathroom.\"},{\"Order\":13,\"Remarks\":\"Second bedroom.\"},{\"Order\":14,\"Remarks\":\"Upstairs bedroom used as an office (and a napping place from overnight shift).\"},{\"Order\":15,\"Remarks\":\"Great storage area or convert to living space!\"},{\"Order\":16,\"Remarks\":\"Lower level 3/4 bath.\"},{\"Order\":17,\"Remarks\":\"Laundry.\"},{\"Order\":18,\"Remarks\":\"HUGE back yard! Swing set is negotiable.\"},{\"Order\":19,\"Remarks\":\"Cute love seat swing.\"},{\"Order\":20,\"Remarks\":\"Huge patio - great for your bar-b-que with family and friends!\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20","SOURCE":"MG_NST"}
{"ListingKey":"NST7812916","LotSizeArea":"0.25","NST_AgeOfProperty":"90","NST_AgentOwner":"No","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"False","NST_AssessmentPending":"No","AssociationYN":"False","AssociationFee":"0","PropertyAttachedYN":"False","Basement":"Full,Partially Finished","BasementYN":"True","BathroomsOneQuarter":"0","BathroomsFull":"1","BathroomsHalf":"0","BathroomsThreeQuarter":"1","BathroomsTotalInteger":"2","BedroomsTotal":"3","City":"Maplewood","PropertyType":"Residential","NewConstructionYN":"False","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Ramsey","NST_DPResource":"Y","DaysOnMarket":"1","CumulativeDaysOnMarket":"47","Directions":"White Bear Ave South Of Hwy 36 to Frost Ave West to Clarence South To Home On Left","InternetAddressDisplayYN":"True","InternetEntireListingDisplayYN":"True","ConstructionMaterials":"Vinyl Siding","FireplaceYN":"True","FireplacesTotal":"1","NST_ForeclosureStatus":"No","NST_FoundationDimensions":"36x24","FoundationArea":"864","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","ParkingFeatures":"Attached Garage","NST_GarageDimensions":"11x20","NST_GarageSquareFeet":"220","AccessibilityFeatures":"None","Heating":"Forced Air","OriginalEntryTimestamp":"2025-10-08T03:02:31Z","LandLeaseYN":"False","NST_LastUpdateDate":"2025-10-08","Latitude":"44.997568","NST_LenderOwned":"No","ListAgentKey":"NST103502","ListAgentMlsId":"NST502044902","ListingContractDate":"2025-10-07T05:00:00Z","ListOfficeKey":"NST1000544","ListOfficeName":"Inspire Realty","ListOfficeMlsId":"NST251886","ListPrice":"298900","LivingArea":"1405","Longitude":"-93.042746","LotSizeDimensions":"80x134","LotSizeSquareFeet":"10715.76","LotSizeUnits":"Acres","ListingId":"NST6801030","SourceSystemName":"RMLS","NST_ManufacturedHome":"No","MapCoordinateSource":"King's Street Atlas","AdditionalParcelsYN":"False","NST_OfficeBoard":"MAAR","ParcelNumber":"152922320033","GarageSpaces":"1","PhotosCount":"20","PostalCity":"Saint Paul","PostalCode":"55109","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PublicRemarks":"Super cute corner lot in quiet Maplewood neighborhood. This quaint house has charm galore! On the main level there's a nicely appointed kitchen with granite counters, surprising storage and great counter space. The adjoining room can either be a dining room or living room based upon your life style. Continuing on the main level is a huge family room! Two living spaces that can flow together or remain separate. There's a huge bedroom upstairs with loads of storage. The basement already complete with second bathroom and is waiting for your ideas to make it complete! Outside there's a huge back yard with patio, love-seat swing and a storage shed. This quiet, corner lot home has it all at an extremely affordable price!","PublicSurveyRange":"22","PublicSurveySection":"15","PublicSurveyTownship":"29","NST_RentalLicenseYN":"No","RoomType":"Living Room,Kitchen,Family Room,Bedroom 1,Bedroom 2,Bedroom 3","NST_AboveGradeSqFtTotal":"1360.0000","NST_BelowGradeSqFtTotal":"846.0000","NST_MainLevelFinishedArea":"1140.0000","BuildingAreaTotal":"2206","HighSchoolDistrict":"North St Paul-Maplewood","NST_SchoolDistrictNumber":"622","NST_SchoolDistrictPhone":"651-748-7410","Sewer":"City Sewer/Connected","AboveGradeFinishedArea":"1360","BelowGradeFinishedArea":"45","StateOrProvince":"MN","StandardStatus":"Active","Levels":"One and One Half","StreetName":"Clarence","StreetNumber":"1870","StreetNumberNumeric":"1870","StreetSuffix":"Street","PropertySubType":"Single Family Residence","SubdivisionName":"Gladstone, Ramsey Co, , Minn","NST_TaxWithAssessments":"4322.0000","TaxYear":"2025","TaxAnnualAmount":"4322","WaterSource":"City Water/Connected","YearBuilt":"1935","ZoningDescription":"Residential-Single Family","ModificationTimestamp":"2025-10-08T10:07:04.993Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7812916\",\"Order\":1,\"MediaObjectID\":\"1\",\"LongDescription\":\"Cute, quiet home on a huge corner lot.\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7812916/0efc0e8d-78ea-4847-9a3e-909774336f5a.jpeg\",\"MediaModificationTimestamp\":\"2025-10-08T03:07:40.298Z\",\"MediaKey\":\"68e5d57d9a093e632c97b8f1\"},{\"ResourceRecordKey\":\"NST7812916\",\"Order\":2,\"MediaObjectID\":\"2\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7812916/0a0ab3c8-602e-4e49-ad67-f7c3b69da17e.jpeg\",\"MediaModificationTimestamp\":\"2025-10-08T03:07:40.281Z\",\"MediaKey\":\"68e5d57d9a093e632c97b8f2\"},{\"ResourceRecordKey\":\"NST7812916\",\"Order\":3,\"MediaObjectID\":\"3\",\"LongDescription\":\"View from the front entryway. Notice the natural wood floors, working fireplace. What a cozy space.\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7812916/d53fd73c-5fdb-4a34-bce8-83b72506a312.jpeg\",\"MediaModificationTimestamp\":\"2025-10-08T03:11:41.845Z\",\"MediaKey\":\"68e5d66d705b603c41086af7\"},{\"ResourceRecordKey\":\"NST7812916\",\"Order\":4,\"MediaObjectID\":\"4\",\"LongDescription\":\"View from the kitchen entryway.\",\"ImageWidth\":2048,\"ImageHeight\":1366,\"ImageSizeDescription\":\"2048x1366\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7812916/42bf76b4-068b-430f-abca-d8685ec74d6d.jpeg\",\"MediaModificationTimestamp\":\"2025-10-08T03:11:41.572Z\",\"MediaKey\":\"68e5d66d705b603c41086af8\"},{\"ResourceRecordKey\":\"NST7812916\",\"Order\":5,\"MediaObjectID\":\"5\",\"LongDescription\":\"View from the family room doorway.\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7812916/86174aeb-47c2-42ff-9706-eafb436084d8.jpeg\",\"MediaModificationTimestamp\":\"2025-10-08T03:11:41.641Z\",\"MediaKey\":\"68e5d66d705b603c41086af9\"},{\"ResourceRecordKey\":\"NST7812916\",\"Order\":6,\"MediaObjectID\":\"6\",\"LongDescription\":\"Clever kitchen with surprising storage and counter space!\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7812916/0f0ef740-3114-446d-99f4-9a5902e9631c.jpeg\",\"MediaModificationTimestamp\":\"2025-10-08T03:11:41.687Z\",\"MediaKey\":\"68e5d66d705b603c41086afa\"},{\"ResourceRecordKey\":\"NST7812916\",\"Order\":7,\"MediaObjectID\":\"7\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7812916/b49b3b11-ab88-43a5-8197-5a431aff0d8d.jpeg\",\"MediaModificationTimestamp\":\"2025-10-08T03:11:41.644Z\",\"MediaKey\":\"68e5d66d705b603c41086afb\"},{\"ResourceRecordKey\":\"NST7812916\",\"Order\":8,\"MediaObjectID\":\"8\",\"LongDescription\":\"Newer stainless appliances.\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7812916/3bab69c2-0c3b-4cce-94ba-2966debd4808.jpeg\",\"MediaModificationTimestamp\":\"2025-10-08T03:11:41.662Z\",\"MediaKey\":\"68e5d66d705b603c41086afc\"},{\"ResourceRecordKey\":\"NST7812916\",\"Order\":9,\"MediaObjectID\":\"9\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7812916/baf6632f-15e5-413e-981d-5fada4d15ba6.jpeg\",\"MediaModificationTimestamp\":\"2025-10-08T03:07:40.305Z\",\"MediaKey\":\"68e5d57d9a093e632c97b8f9\"},{\"ResourceRecordKey\":\"NST7812916\",\"Order\":10,\"MediaObjectID\":\"10\",\"LongDescription\":\"This massive, light-filled family/sun room off the living room is such a great space!\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7812916/f7eff268-1c73-476f-8ca1-dfba817e9671.jpeg\",\"MediaModificationTimestamp\":\"2025-10-08T03:11:41.719Z\",\"MediaKey\":\"68e5d66d705b603c41086afd\"},{\"ResourceRecordKey\":\"NST7812916\",\"Order\":11,\"MediaObjectID\":\"11\",\"LongDescription\":\"Owner's bedroom.\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7812916/f5115da5-c788-42f1-8202-5a31c24581cb.jpeg\",\"MediaModificationTimestamp\":\"2025-10-08T03:07:40.421Z\",\"MediaKey\":\"68e5d57d9a093e632c97b8fb\"},{\"ResourceRecordKey\":\"NST7812916\",\"Order\":12,\"MediaObjectID\":\"12\",\"LongDescription\":\"Nicely appointed main level bathroom.\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7812916/f62cfd19-04f2-4c05-b68d-d91790b85877.jpeg\",\"MediaModificationTimestamp\":\"2025-10-08T03:07:40.237Z\",\"MediaKey\":\"68e5d57d9a093e632c97b8fc\"},{\"ResourceRecordKey\":\"NST7812916\",\"Order\":13,\"MediaObjectID\":\"13\",\"LongDescription\":\"Second bedroom.\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7812916/b1e7f1ef-75a7-4855-a4b6-5cf68ae0b52d.jpeg\",\"MediaModificationTimestamp\":\"2025-10-08T03:07:40.237Z\",\"MediaKey\":\"68e5d57d9a093e632c97b8fd\"},{\"ResourceRecordKey\":\"NST7812916\",\"Order\":14,\"MediaObjectID\":\"14\",\"LongDescription\":\"Upstairs bedroom used as an office (and a napping place from overnight shift).\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7812916/dba59e9a-3fa8-4a04-9d1c-b6fb94b6bcdc.jpeg\",\"MediaModificationTimestamp\":\"2025-10-08T03:07:40.33Z\",\"MediaKey\":\"68e5d57d9a093e632c97b8fe\"},{\"ResourceRecordKey\":\"NST7812916\",\"Order\":15,\"MediaObjectID\":\"15\",\"LongDescription\":\"Great storage area or convert to living space!\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7812916/58d65e69-f898-4f40-b513-1f90fc99aced.jpeg\",\"MediaModificationTimestamp\":\"2025-10-08T03:07:40.251Z\",\"MediaKey\":\"68e5d57d9a093e632c97b8ff\"},{\"ResourceRecordKey\":\"NST7812916\",\"Order\":16,\"MediaObjectID\":\"16\",\"LongDescription\":\"Lower level 3/4 bath.\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7812916/5a1655a3-ce48-4a5e-84bb-33498aee6f77.jpeg\",\"MediaModificationTimestamp\":\"2025-10-08T03:07:40.216Z\",\"MediaKey\":\"68e5d57d9a093e632c97b900\"},{\"ResourceRecordKey\":\"NST7812916\",\"Order\":17,\"MediaObjectID\":\"17\",\"LongDescription\":\"Laundry.\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7812916/b0a4c67f-1f0d-40ed-a661-116e8bfcd236.jpeg\",\"MediaModificationTimestamp\":\"2025-10-08T03:07:40.243Z\",\"MediaKey\":\"68e5d57d9a093e632c97b901\"},{\"ResourceRecordKey\":\"NST7812916\",\"Order\":18,\"MediaObjectID\":\"18\",\"LongDescription\":\"HUGE back yard! Swing set is negotiable.\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7812916/8398d26e-876b-4e69-8ffd-29b420f406c9.jpeg\",\"MediaModificationTimestamp\":\"2025-10-08T03:07:40.315Z\",\"MediaKey\":\"68e5d57d9a093e632c97b902\"},{\"ResourceRecordKey\":\"NST7812916\",\"Order\":19,\"MediaObjectID\":\"19\",\"LongDescription\":\"Cute love seat swing.\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7812916/9ce6f700-4ce4-4b42-a23d-5d9276a639cd.jpeg\",\"MediaModificationTimestamp\":\"2025-10-08T03:07:40.294Z\",\"MediaKey\":\"68e5d57d9a093e632c97b903\"},{\"ResourceRecordKey\":\"NST7812916\",\"Order\":20,\"MediaObjectID\":\"20\",\"LongDescription\":\"Huge patio - great for your bar-b-que with family and friends!\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7812916/cd28cab9-6722-49ca-af0a-0d674649c8b4.jpeg\",\"MediaModificationTimestamp\":\"2025-10-08T03:07:41.35Z\",\"MediaKey\":\"68e5d57d9a093e632c97b904\"}]","PhotosChangeTimestamp":"2025-10-08T03:16:03.807Z","Rooms":"[{\"RoomKey\":\"NST115682902\",\"RoomType\":\"Living Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"14x17\",\"NST_RoomSortOrder\":\"1\"},{\"RoomKey\":\"NST115682903\",\"RoomType\":\"Kitchen\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"10x12\",\"NST_RoomSortOrder\":\"2\"},{\"RoomKey\":\"NST115682904\",\"RoomType\":\"Family Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"14x20\",\"NST_RoomSortOrder\":\"3\"},{\"RoomKey\":\"NST115682905\",\"RoomType\":\"Bedroom 1\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"12x11\",\"NST_RoomSortOrder\":\"4\"},{\"RoomKey\":\"NST115682906\",\"RoomType\":\"Bedroom 2\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"11x11\",\"NST_RoomSortOrder\":\"5\"},{\"RoomKey\":\"NST115682907\",\"RoomType\":\"Bedroom 3\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"18x12\",\"NST_RoomSortOrder\":\"6\"}]","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"Cute, quiet home on a huge corner lot.\"},{\"Order\":3,\"Remarks\":\"View from the front entryway. Notice the natural wood floors, working fireplace. What a cozy space.\"},{\"Order\":4,\"Remarks\":\"View from the kitchen entryway.\"},{\"Order\":5,\"Remarks\":\"View from the family room doorway.\"},{\"Order\":6,\"Remarks\":\"Clever kitchen with surprising storage and counter space!\"},{\"Order\":8,\"Remarks\":\"Newer stainless appliances.\"},{\"Order\":10,\"Remarks\":\"This massive, light-filled family/sun room off the living room is such a great space!\"},{\"Order\":11,\"Remarks\":\"Owner's bedroom.\"},{\"Order\":12,\"Remarks\":\"Nicely appointed main level bathroom.\"},{\"Order\":13,\"Remarks\":\"Second bedroom.\"},{\"Order\":14,\"Remarks\":\"Upstairs bedroom used as an office (and a napping place from overnight shift).\"},{\"Order\":15,\"Remarks\":\"Great storage area or convert to living space!\"},{\"Order\":16,\"Remarks\":\"Lower level 3/4 bath.\"},{\"Order\":17,\"Remarks\":\"Laundry.\"},{\"Order\":18,\"Remarks\":\"HUGE back yard! Swing set is negotiable.\"},{\"Order\":19,\"Remarks\":\"Cute love seat swing.\"},{\"Order\":20,\"Remarks\":\"Huge patio - great for your bar-b-que with family and friends!\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20","CustomVTourURL":""}