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":1433975,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST6820766","MLSAGENTID":"NST506094338","MLSOFFICEID":"NST10071","ADDRESS":"475 Lawson Avenue W","ACRES":0.1,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Crawl Space,Partial","BATHSTOTAL":1.0,"BEDROOMS":4,"CITY":"Saint Paul","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Metal Siding,Vinyl Siding","FORECLOSURE":"No","LASTPRICE":249900.0,"LASTPRICEDATE":"2025-11-21T18:35:05.717","LATITUDE":44.972229,"LENDEROWNED":"No","LISTDATE":"2025-11-20T06:00:00","LISTPRICE":249900.0,"LIVINGAREA":1170.0,"LONGITUDE":-93.120206,"LOTDESCRIPTION":"Corner Lot,Some Trees","MODIFICATIONTIMESTAMP":"2025-11-22T11:04:05.125","NEIGHBORHOOD":"North End","OFFICE_OFFICENAME":"Keller Williams Integrity Realty","PHOTOCOUNT":16,"POSTALCODE":"55117","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Beautifully updated home situated on a spacious corner lot! This move-in-ready property features fresh\ninterior paint, gleaming hardwood floors, and brand-new carpet on the upper level. Enjoy an extra-large\nkitchen with plenty of space for both cooking and dining—perfect for gatherings.\n\nThe main-floor bathroom has been refreshed with a new vanity and lighting, offering a clean and modern\nfeel. A brand-new furnace installed in 2025 provides comfort and efficiency for years to come.\n\nRelax and unwind on the inviting front porch during warmer months, and take advantage of the additional\nstorage space offered by the backyard shed.","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Asphalt,Pitched","SCHOOLDISTRICTNUMBER":"625-St. Paul","SCHOOLDISTRICTPHONE":"651-767-8100","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2025-11-21T18:35:05.717","LASTSTATUS":"Active","STREETDIRSUFFIX":"W","STREETNAME":"Lawson","STREETNUMBER":"475","STREETSUFFIX":"Avenue","STYLE":"Single Family Residence","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1910,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2025-11-21T20:42:03.99","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"Exterior Front.jpg\"},{\"Order\":2,\"Remarks\":\"Exterior Front.jpg\"},{\"Order\":3,\"Remarks\":\"Living Room.jpg\"},{\"Order\":4,\"Remarks\":\"Living Room.jpg\"},{\"Order\":5,\"Remarks\":\"Kitchen.jpg\"},{\"Order\":6,\"Remarks\":\"Kitchen.jpg\"},{\"Order\":7,\"Remarks\":\"Primary Bathroom.jpg\"},{\"Order\":8,\"Remarks\":\"Bedroom.jpg\"},{\"Order\":9,\"Remarks\":\"Bedroom.jpg\"},{\"Order\":10,\"Remarks\":\"2nd Floor Primary Bedroom.jpg\"},{\"Order\":11,\"Remarks\":\"2nd Floor Primary Bedroom.jpg\"},{\"Order\":12,\"Remarks\":\"2nd Floor Bedroom.jpg\"},{\"Order\":13,\"Remarks\":\"2nd Floor Bedroom.jpg\"},{\"Order\":14,\"Remarks\":\"Laundry Room.jpg\"},{\"Order\":15,\"Remarks\":\"Backyard.jpg\"},{\"Order\":16,\"Remarks\":\"Exterior Rear.jpg\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16","SOURCE":"MG_NST"}
{"ListingKey":"NST7829993","LotSizeArea":"0.1","NST_AgeOfProperty":"115","NST_AgentOwner":"No","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"False","NST_AmenitiesUnit":"Deck,Hardwood Floors,Kitchen Window,Natural Woodwork,Porch,Tile Floors,Washer/Dryer Hookup","NST_AssessmentPending":"No","AssociationYN":"False","AssociationFee":"0","PropertyAttachedYN":"False","Basement":"Crawl Space,Partial","BasementYN":"True","NST_BathDesc":"Main Floor Full Bath","BathroomsOneQuarter":"0","BathroomsFull":"1","BathroomsHalf":"0","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"1","BedroomsTotal":"4","City":"Saint Paul","PropertyType":"Residential","NewConstructionYN":"False","Contingency":"None","Cooling":"None","CountyOrParish":"Ramsey","NST_DPResource":"Y","DaysOnMarket":"2","CumulativeDaysOnMarket":"2","NST_DiningRoomDescription":"Eat In Kitchen,Living/Dining Room","Directions":"35E to Maryland(R) to Norton(L) to Lawson.","InternetAddressDisplayYN":"True","InternetEntireListingDisplayYN":"True","ConstructionMaterials":"Metal Siding,Vinyl Siding","FireplaceYN":"False","FireplacesTotal":"0","NST_ForeclosureStatus":"No","FoundationArea":"836","NST_FractionalOwnershipYN":"No","RoadFrontageType":"City Street,Curbs,Paved Streets,Sidewalks","NST_Fuel":"Natural Gas","ParkingFeatures":"Driveway - Other Surface","AccessibilityFeatures":"None","Heating":"Forced Air","OriginalEntryTimestamp":"2025-11-21T18:22:38Z","LandLeaseYN":"False","NST_LastUpdateDate":"2025-11-22","Latitude":"44.972229","NST_LenderOwned":"No","ListAgentKey":"NST53356","ListAgentMlsId":"NST506094338","ListingContractDate":"2025-11-20T06:00:00Z","ListOfficeKey":"NST16710","ListOfficeName":"Keller Williams Integrity Realty","ListOfficeMlsId":"NST10071","ListPrice":"249900","LivingArea":"1170","Longitude":"-93.120206","LotFeatures":"Corner Lot,Some Trees","LotSizeDimensions":"38x114","LotSizeSquareFeet":"4356","LotSizeUnits":"Acres","ListingId":"NST6820766","SourceSystemName":"RMLS","NST_ManufacturedHome":"No","MapCoordinateSource":"King's Street Atlas","AdditionalParcelsYN":"False","NST_NeighborhoodNumber":"North End","NST_OfficeBoard":"SPAAR","ParcelNumber":"252923240088","GarageSpaces":"0","NST_PatioPorchType":"Deck,Front Porch,Porch","PhotosCount":"16","PostalCity":"Saint Paul","PostalCode":"55117","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PublicRemarks":"Beautifully updated home situated on a spacious corner lot! This move-in-ready property features fresh\ninterior paint, gleaming hardwood floors, and brand-new carpet on the upper level. Enjoy an extra-large\nkitchen with plenty of space for both cooking and dining—perfect for gatherings.\n\nThe main-floor bathroom has been refreshed with a new vanity and lighting, offering a clean and modern\nfeel. A brand-new furnace installed in 2025 provides comfort and efficiency for years to come.\n\nRelax and unwind on the inviting front porch during warmer months, and take advantage of the additional\nstorage space offered by the backyard shed.","PublicSurveyRange":"23","PublicSurveySection":"25","PublicSurveyTownship":"29","NST_RentalLicenseYN":"No","Roof":"Asphalt,Pitched","RoomType":"Living Room,Kitchen,Bedroom 1,Bedroom 2,Bedroom 3,Bedroom 4,Dining Room","NST_AboveGradeSqFtTotal":"1170.0000","NST_BelowGradeSqFtTotal":"836.0000","NST_MainLevelFinishedArea":"836.0000","BuildingAreaTotal":"2006","HighSchoolDistrict":"St. Paul","NST_SchoolDistrictNumber":"625","NST_SchoolDistrictPhone":"651-767-8100","Sewer":"City Sewer/Connected","NST_SpecialSearch":"3 BR on One Level,Main Floor Laundry","AboveGradeFinishedArea":"1170","BelowGradeFinishedArea":"0","StateOrProvince":"MN","StandardStatus":"Active","Levels":"One and One Half","StreetDirSuffix":"W","StreetName":"Lawson","StreetNumber":"475","StreetNumberNumeric":"475","StreetSuffix":"Avenue","PropertySubType":"Single Family Residence","SubdivisionName":"Alabama Add 1, St Pau","NST_TaxWithAssessments":"3380.0000","TaxYear":"2025","TaxAnnualAmount":"3380","WaterSource":"City Water/Connected","YearBuilt":"1910","ZoningDescription":"Residential-Single Family","ModificationTimestamp":"2025-11-22T11:04:05.125Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7829993\",\"Order\":1,\"MediaObjectID\":\"1\",\"LongDescription\":\"Exterior Front.jpg\",\"ImageWidth\":1500,\"ImageHeight\":1000,\"ImageSizeDescription\":\"1500x1000\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7829993/5c45fcc2-a6c1-4b8a-97d2-071f7c945a9c.jpeg\",\"MediaModificationTimestamp\":\"2025-11-21T18:41:51.21Z\",\"MediaKey\":\"6920b26f46a6b711787198f1\"},{\"ResourceRecordKey\":\"NST7829993\",\"Order\":2,\"MediaObjectID\":\"2\",\"LongDescription\":\"Exterior Front.jpg\",\"ImageWidth\":1500,\"ImageHeight\":1000,\"ImageSizeDescription\":\"1500x1000\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7829993/966e8982-931d-49fe-9aab-982b3f7e5b83.jpeg\",\"MediaModificationTimestamp\":\"2025-11-21T18:41:51.151Z\",\"MediaKey\":\"6920b26f46a6b711787198f2\"},{\"ResourceRecordKey\":\"NST7829993\",\"Order\":3,\"MediaObjectID\":\"3\",\"LongDescription\":\"Living Room.jpg\",\"ImageWidth\":1500,\"ImageHeight\":1000,\"ImageSizeDescription\":\"1500x1000\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7829993/5b0d7e70-0397-428d-aa7f-63f33756f277.jpeg\",\"MediaModificationTimestamp\":\"2025-11-21T18:41:51.148Z\",\"MediaKey\":\"6920b26f46a6b711787198f3\"},{\"ResourceRecordKey\":\"NST7829993\",\"Order\":4,\"MediaObjectID\":\"4\",\"LongDescription\":\"Living Room.jpg\",\"ImageWidth\":1500,\"ImageHeight\":1001,\"ImageSizeDescription\":\"1500x1001\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7829993/0f9d04f5-efaf-4837-b533-133bd47ceddb.jpeg\",\"MediaModificationTimestamp\":\"2025-11-21T18:41:51.165Z\",\"MediaKey\":\"6920b26f46a6b711787198f4\"},{\"ResourceRecordKey\":\"NST7829993\",\"Order\":5,\"MediaObjectID\":\"5\",\"LongDescription\":\"Kitchen.jpg\",\"ImageWidth\":1500,\"ImageHeight\":1000,\"ImageSizeDescription\":\"1500x1000\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7829993/34c519d4-3d10-4c5c-a652-ee4238e953a4.jpeg\",\"MediaModificationTimestamp\":\"2025-11-21T18:41:51.148Z\",\"MediaKey\":\"6920b26f46a6b711787198f6\"},{\"ResourceRecordKey\":\"NST7829993\",\"Order\":6,\"MediaObjectID\":\"6\",\"LongDescription\":\"Kitchen.jpg\",\"ImageWidth\":1500,\"ImageHeight\":1000,\"ImageSizeDescription\":\"1500x1000\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7829993/e136b755-3581-4cc7-bdcf-0965de54c065.jpeg\",\"MediaModificationTimestamp\":\"2025-11-21T18:41:51.148Z\",\"MediaKey\":\"6920b26f46a6b711787198f7\"},{\"ResourceRecordKey\":\"NST7829993\",\"Order\":7,\"MediaObjectID\":\"7\",\"LongDescription\":\"Primary Bathroom.jpg\",\"ImageWidth\":1500,\"ImageHeight\":1001,\"ImageSizeDescription\":\"1500x1001\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7829993/54c972a2-e9d2-4649-bbdd-ce84a62cd96b.jpeg\",\"MediaModificationTimestamp\":\"2025-11-21T18:41:51.164Z\",\"MediaKey\":\"6920b26f46a6b711787198f8\"},{\"ResourceRecordKey\":\"NST7829993\",\"Order\":8,\"MediaObjectID\":\"8\",\"LongDescription\":\"Bedroom.jpg\",\"ImageWidth\":1500,\"ImageHeight\":1000,\"ImageSizeDescription\":\"1500x1000\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7829993/641a6f58-7039-4c08-b0a0-43429aa670c1.jpeg\",\"MediaModificationTimestamp\":\"2025-11-21T18:41:51.148Z\",\"MediaKey\":\"6920b26f46a6b711787198f9\"},{\"ResourceRecordKey\":\"NST7829993\",\"Order\":9,\"MediaObjectID\":\"9\",\"LongDescription\":\"Bedroom.jpg\",\"ImageWidth\":1500,\"ImageHeight\":1000,\"ImageSizeDescription\":\"1500x1000\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7829993/606556b2-58d2-41ee-b9fa-12f2ed5e89f9.jpeg\",\"MediaModificationTimestamp\":\"2025-11-21T18:41:51.149Z\",\"MediaKey\":\"6920b26f46a6b711787198fa\"},{\"ResourceRecordKey\":\"NST7829993\",\"Order\":10,\"MediaObjectID\":\"10\",\"LongDescription\":\"2nd Floor Primary Bedroom.jpg\",\"ImageWidth\":1500,\"ImageHeight\":1001,\"ImageSizeDescription\":\"1500x1001\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7829993/182fe1d8-a32f-4d2a-bd79-0075ebe1e6c0.jpeg\",\"MediaModificationTimestamp\":\"2025-11-21T18:41:51.131Z\",\"MediaKey\":\"6920b26f46a6b711787198fb\"},{\"ResourceRecordKey\":\"NST7829993\",\"Order\":11,\"MediaObjectID\":\"11\",\"LongDescription\":\"2nd Floor Primary Bedroom.jpg\",\"ImageWidth\":1500,\"ImageHeight\":1000,\"ImageSizeDescription\":\"1500x1000\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7829993/0228c1aa-af23-401a-961a-54c58a5974ae.jpeg\",\"MediaModificationTimestamp\":\"2025-11-21T18:41:51.148Z\",\"MediaKey\":\"6920b26f46a6b711787198fc\"},{\"ResourceRecordKey\":\"NST7829993\",\"Order\":12,\"MediaObjectID\":\"12\",\"LongDescription\":\"2nd Floor Bedroom.jpg\",\"ImageWidth\":1500,\"ImageHeight\":1000,\"ImageSizeDescription\":\"1500x1000\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7829993/fecab6fa-6211-47bb-bfc0-c8b921b6cd14.jpeg\",\"MediaModificationTimestamp\":\"2025-11-21T18:41:51.158Z\",\"MediaKey\":\"6920b26f46a6b711787198fd\"},{\"ResourceRecordKey\":\"NST7829993\",\"Order\":13,\"MediaObjectID\":\"13\",\"LongDescription\":\"2nd Floor Bedroom.jpg\",\"ImageWidth\":1500,\"ImageHeight\":1000,\"ImageSizeDescription\":\"1500x1000\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7829993/9f12a6e7-4253-404a-bb9c-7b042eda10ee.jpeg\",\"MediaModificationTimestamp\":\"2025-11-21T18:41:51.144Z\",\"MediaKey\":\"6920b26f46a6b711787198fe\"},{\"ResourceRecordKey\":\"NST7829993\",\"Order\":14,\"MediaObjectID\":\"14\",\"LongDescription\":\"Laundry Room.jpg\",\"ImageWidth\":1500,\"ImageHeight\":1000,\"ImageSizeDescription\":\"1500x1000\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7829993/5c9ae0c8-8781-46a0-80dd-fd47ec891288.jpeg\",\"MediaModificationTimestamp\":\"2025-11-21T18:41:51.164Z\",\"MediaKey\":\"6920b26f46a6b711787198ff\"},{\"ResourceRecordKey\":\"NST7829993\",\"Order\":15,\"MediaObjectID\":\"15\",\"LongDescription\":\"Backyard.jpg\",\"ImageWidth\":1500,\"ImageHeight\":1000,\"ImageSizeDescription\":\"1500x1000\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7829993/c0a3eac0-5651-452c-8a08-f4c739cbf192.jpeg\",\"MediaModificationTimestamp\":\"2025-11-21T18:41:51.212Z\",\"MediaKey\":\"6920b26f46a6b71178719900\"},{\"ResourceRecordKey\":\"NST7829993\",\"Order\":16,\"MediaObjectID\":\"16\",\"LongDescription\":\"Exterior Rear.jpg\",\"ImageWidth\":1500,\"ImageHeight\":1001,\"ImageSizeDescription\":\"1500x1001\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7829993/761b9d84-72ce-47f2-99f3-d240a62b1d78.jpeg\",\"MediaModificationTimestamp\":\"2025-11-21T18:41:51.157Z\",\"MediaKey\":\"6920b26f46a6b71178719901\"}]","PhotosChangeTimestamp":"2025-11-21T20:42:03.99Z","Rooms":"[{\"RoomKey\":\"NST115792552\",\"RoomType\":\"Living Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"11x12\",\"NST_RoomSortOrder\":\"1\"},{\"RoomKey\":\"NST115792553\",\"RoomType\":\"Kitchen\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"19x11\",\"NST_RoomSortOrder\":\"2\"},{\"RoomKey\":\"NST115792554\",\"RoomType\":\"Bedroom 1\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"12x9\",\"NST_RoomSortOrder\":\"3\"},{\"RoomKey\":\"NST115792555\",\"RoomType\":\"Bedroom 2\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"14x10\",\"NST_RoomSortOrder\":\"4\"},{\"RoomKey\":\"NST115792556\",\"RoomType\":\"Bedroom 3\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"9x9\",\"NST_RoomSortOrder\":\"5\"},{\"RoomKey\":\"NST115792557\",\"RoomType\":\"Bedroom 4\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"11x8\",\"NST_RoomSortOrder\":\"6\"},{\"RoomKey\":\"NST115792558\",\"RoomType\":\"Dining Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"11x7\",\"NST_RoomSortOrder\":\"7\"}]","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"Exterior Front.jpg\"},{\"Order\":2,\"Remarks\":\"Exterior Front.jpg\"},{\"Order\":3,\"Remarks\":\"Living Room.jpg\"},{\"Order\":4,\"Remarks\":\"Living Room.jpg\"},{\"Order\":5,\"Remarks\":\"Kitchen.jpg\"},{\"Order\":6,\"Remarks\":\"Kitchen.jpg\"},{\"Order\":7,\"Remarks\":\"Primary Bathroom.jpg\"},{\"Order\":8,\"Remarks\":\"Bedroom.jpg\"},{\"Order\":9,\"Remarks\":\"Bedroom.jpg\"},{\"Order\":10,\"Remarks\":\"2nd Floor Primary Bedroom.jpg\"},{\"Order\":11,\"Remarks\":\"2nd Floor Primary Bedroom.jpg\"},{\"Order\":12,\"Remarks\":\"2nd Floor Bedroom.jpg\"},{\"Order\":13,\"Remarks\":\"2nd Floor Bedroom.jpg\"},{\"Order\":14,\"Remarks\":\"Laundry Room.jpg\"},{\"Order\":15,\"Remarks\":\"Backyard.jpg\"},{\"Order\":16,\"Remarks\":\"Exterior Rear.jpg\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16","CustomVTourURL":""}