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":1417680,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST6799408","MLSAGENTID":"NST506014111","MLSCOAGENTID":"NST506095956","MLSOFFICEID":"NST10956","ADDRESS":"405 Brooks Avenue W","ACRES":0.28,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Egress Window(s),Full","BATHSTOTAL":2.0,"BEDROOMS":5,"CITY":"Roseville","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Brick/Stone,Vinyl Siding","FORECLOSURE":"No","LASTPRICE":389900.0,"LASTPRICEDATE":"2025-10-04T15:13:03.55","LATITUDE":45.01561985,"LENDEROWNED":"No","LISTDATE":"2025-10-04T05:00:00","LISTPRICE":389900.0,"LIVINGAREA":2208.0,"LONGITUDE":-93.12776298,"LOTDESCRIPTION":"Public Transit (w/in 6 blks),Irregular Lot","MODIFICATIONTIMESTAMP":"2025-10-05T02:51:05.135","OFFICE_OFFICENAME":"Creative Results","PHOTOCOUNT":16,"POSTALCODE":"55113","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"4-level split with 5 beds, 2 baths, 2 car garage, sitting on .28 acres in Roseville, MN. Original wood work, hardwood floors, chain fence, backyard patio and porch. New roof and siding in 2022/2023. Move-in ready.","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Asphalt,Pitched","SCHOOLDISTRICTNUMBER":"623-Roseville","SCHOOLDISTRICTPHONE":"651-635-1600","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2025-10-04T15:13:03.55","LASTSTATUS":"Active","STREETDIRSUFFIX":"W","STREETNAME":"Brooks","STREETNUMBER":"405","STREETSUFFIX":"Avenue","STYLE":"Single Family Residence","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1966,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2025-10-05T02:51:05.135","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"1.jpg\"},{\"Order\":2,\"Remarks\":\"2.jpg\"},{\"Order\":3,\"Remarks\":\"3.jpg\"},{\"Order\":4,\"Remarks\":\"4.jpg\"},{\"Order\":5,\"Remarks\":\"5.jpg\"},{\"Order\":6,\"Remarks\":\"6.jpg\"},{\"Order\":7,\"Remarks\":\"7.jpg\"},{\"Order\":8,\"Remarks\":\"8.jpg\"},{\"Order\":9,\"Remarks\":\"9.jpg\"},{\"Order\":10,\"Remarks\":\"10.jpg\"},{\"Order\":11,\"Remarks\":\"11.jpg\"},{\"Order\":12,\"Remarks\":\"13.jpg\"},{\"Order\":13,\"Remarks\":\"14.jpg\"},{\"Order\":14,\"Remarks\":\"15.jpg\"},{\"Order\":15,\"Remarks\":\"16.jpg\"},{\"Order\":16,\"Remarks\":\"17.jpg\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16","SOURCE":"MG_NST"}
{"ListingKey":"NST7811544","LotSizeArea":"0.28","NST_AgeOfProperty":"59","NST_AgentOwner":"No","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"True","NST_AmenitiesUnit":"Hardwood Floors,Kitchen Window,Multiple Phone Lines,Patio,Sun Room,Tile Floors,Washer/Dryer Hookup","Appliances":"Cooktop,Microwave,Range,Refrigerator","NST_AssessmentPending":"No","AssociationYN":"False","AssociationFee":"0","PropertyAttachedYN":"False","Basement":"Egress Window(s),Full","BasementYN":"True","NST_BathDesc":"Full Basement,Main Floor Full Bath","BathroomsOneQuarter":"0","BathroomsFull":"2","BathroomsHalf":"0","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"2","BedroomsTotal":"5","City":"Roseville","PropertyType":"Residential","NST_ConstructionMaterialsDesc":"Block","NewConstructionYN":"False","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Ramsey","NST_DiningRoomDescription":"Eat In Kitchen","Directions":"Hwy 36 to Dale St, N to Cty B2 (right) East to Cohannsey, left (N) to Brooks, right to home","InternetAddressDisplayYN":"True","InternetEntireListingDisplayYN":"True","Electric":"Circuit Breakers","ConstructionMaterials":"Brick/Stone,Vinyl Siding","Fencing":"Chain Link","FireplaceFeatures":"Family Room,Wood Burning","FireplaceYN":"True","FireplacesTotal":"1","NST_ForeclosureStatus":"No","FoundationArea":"1294","NST_FractionalOwnershipYN":"No","RoadFrontageType":"City Street,Curbs,Paved Streets","NST_Fuel":"Natural Gas","ParkingFeatures":"Attached Garage,Concrete","NST_GarageSquareFeet":"0","AccessibilityFeatures":"None","Heating":"Hot Water","OriginalEntryTimestamp":"2025-10-04T15:08:28Z","NST_InternetOptions":"Cable","LandLeaseYN":"False","NST_LastUpdateDate":"2025-10-04","Latitude":"45.0156198506","NST_LenderOwned":"No","ListAgentKey":"NST107083","ListAgentMlsId":"NST506014111","CoListAgentKey":"NST62343","CoListAgentMlsId":"NST506095956","ListingContractDate":"2025-10-04T05:00:00Z","ListOfficeKey":"NST18608","ListOfficeName":"Creative Results","ListOfficeMlsId":"NST10956","ListPrice":"389900","LivingArea":"2208","Longitude":"-93.1277629754","LotFeatures":"Public Transit (w/in 6 blks),Irregular Lot","LotSizeDimensions":"88x138","LotSizeSquareFeet":"12196.8","LotSizeUnits":"Acres","ListingId":"NST6799408","SourceSystemName":"RMLS","NST_ManufacturedHome":"No","MapCoordinateSource":"King's Street Atlas","AdditionalParcelsYN":"False","NST_OfficeBoard":"SPAAR","ParcelNumber":"122923240003","GarageSpaces":"2","NST_PatioPorchType":"Patio","PhotosCount":"16","PostalCity":"Roseville","PostalCode":"55113","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PublicRemarks":"4-level split with 5 beds, 2 baths, 2 car garage, sitting on .28 acres in Roseville, MN. Original wood work, hardwood floors, chain fence, backyard patio and porch. New roof and siding in 2022/2023. Move-in ready.","NST_RentalLicenseYN":"No","RoadResponsibility":"Public Maintained Road","Roof":"Asphalt,Pitched","RoomType":"Living Room,Family Room,Kitchen,Bedroom 1,Bedroom 2,Bedroom 3,Bedroom 4,Bedroom 5,Three Season Porch,Foyer","NST_AboveGradeSqFtTotal":"1608.0000","NST_BelowGradeSqFtTotal":"600.0000","NST_MainLevelFinishedArea":"0.0000","BuildingAreaTotal":"2208","HighSchoolDistrict":"Roseville","NST_SchoolDistrictNumber":"623","NST_SchoolDistrictPhone":"651-635-1600","Sewer":"City Sewer/Connected","NST_SpecialSearch":"3 BR on One Level","AboveGradeFinishedArea":"1608","BelowGradeFinishedArea":"600","StateOrProvince":"MN","StandardStatus":"Active","Levels":"Four or More Level Split","StreetDirSuffix":"W","StreetName":"Brooks","StreetNumber":"405","StreetNumberNumeric":"405","StreetSuffix":"Avenue","PropertySubType":"Single Family Residence","NST_TaxWithAssessments":"5244.0000","TaxYear":"2025","TaxAnnualAmount":"5244","WaterSource":"City Water/Connected","YearBuilt":"1966","ZoningDescription":"Residential-Single Family","ModificationTimestamp":"2025-10-05T02:51:05.135Z","PhotosChangeTimestamp":"2025-10-05T02:51:05.135Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7811544\",\"Order\":1,\"MediaObjectID\":\"1\",\"LongDescription\":\"1.jpg\",\"ImageWidth\":1024,\"ImageHeight\":579,\"ImageSizeDescription\":\"1024x579\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7811544/3931f9fe-4cea-4347-90ce-292be9ec47f2.jpeg\",\"MediaModificationTimestamp\":\"2025-10-05T02:51:03.924Z\",\"MediaKey\":\"68e1dd173ad0e813aeefb2e6\"},{\"ResourceRecordKey\":\"NST7811544\",\"Order\":2,\"MediaObjectID\":\"2\",\"LongDescription\":\"2.jpg\",\"ImageWidth\":1024,\"ImageHeight\":630,\"ImageSizeDescription\":\"1024x630\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7811544/9aa6b8d0-9e64-4a74-a7a3-e53f9abd3d62.jpeg\",\"MediaModificationTimestamp\":\"2025-10-05T02:51:03.879Z\",\"MediaKey\":\"68e1dd173ad0e813aeefb2e7\"},{\"ResourceRecordKey\":\"NST7811544\",\"Order\":3,\"MediaObjectID\":\"3\",\"LongDescription\":\"3.jpg\",\"ImageWidth\":1024,\"ImageHeight\":666,\"ImageSizeDescription\":\"1024x666\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7811544/5a7b902d-142e-404e-9edc-3585e22789ce.jpeg\",\"MediaModificationTimestamp\":\"2025-10-05T02:51:03.894Z\",\"MediaKey\":\"68e1dd173ad0e813aeefb2e8\"},{\"ResourceRecordKey\":\"NST7811544\",\"Order\":4,\"MediaObjectID\":\"4\",\"LongDescription\":\"4.jpg\",\"ImageWidth\":1024,\"ImageHeight\":672,\"ImageSizeDescription\":\"1024x672\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7811544/65293e20-594d-4bb7-b1ee-7a82c7431bac.jpeg\",\"MediaModificationTimestamp\":\"2025-10-05T02:51:03.892Z\",\"MediaKey\":\"68e1dd173ad0e813aeefb2e9\"},{\"ResourceRecordKey\":\"NST7811544\",\"Order\":5,\"MediaObjectID\":\"5\",\"LongDescription\":\"5.jpg\",\"ImageWidth\":1024,\"ImageHeight\":732,\"ImageSizeDescription\":\"1024x732\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7811544/cdccbf76-608d-4d2b-9213-f43d7c497ceb.jpeg\",\"MediaModificationTimestamp\":\"2025-10-05T02:51:03.884Z\",\"MediaKey\":\"68e1dd173ad0e813aeefb2ea\"},{\"ResourceRecordKey\":\"NST7811544\",\"Order\":6,\"MediaObjectID\":\"6\",\"LongDescription\":\"6.jpg\",\"ImageWidth\":1024,\"ImageHeight\":657,\"ImageSizeDescription\":\"1024x657\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7811544/3e1a452e-a89e-4f52-a408-5c060ffea605.jpeg\",\"MediaModificationTimestamp\":\"2025-10-05T02:51:03.939Z\",\"MediaKey\":\"68e1dd173ad0e813aeefb2eb\"},{\"ResourceRecordKey\":\"NST7811544\",\"Order\":7,\"MediaObjectID\":\"7\",\"LongDescription\":\"7.jpg\",\"ImageWidth\":1024,\"ImageHeight\":675,\"ImageSizeDescription\":\"1024x675\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7811544/2bd77f7d-36f3-4581-988c-5cc98e6a899a.jpeg\",\"MediaModificationTimestamp\":\"2025-10-05T02:51:03.897Z\",\"MediaKey\":\"68e1dd173ad0e813aeefb2ec\"},{\"ResourceRecordKey\":\"NST7811544\",\"Order\":8,\"MediaObjectID\":\"8\",\"LongDescription\":\"8.jpg\",\"ImageWidth\":1024,\"ImageHeight\":675,\"ImageSizeDescription\":\"1024x675\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7811544/f28d156c-f972-443c-83b3-af92de777426.jpeg\",\"MediaModificationTimestamp\":\"2025-10-05T02:51:03.876Z\",\"MediaKey\":\"68e1dd173ad0e813aeefb2ed\"},{\"ResourceRecordKey\":\"NST7811544\",\"Order\":9,\"MediaObjectID\":\"9\",\"LongDescription\":\"9.jpg\",\"ImageWidth\":1024,\"ImageHeight\":669,\"ImageSizeDescription\":\"1024x669\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7811544/6c2cea4f-3189-4d0e-8636-d10e12140e7f.jpeg\",\"MediaModificationTimestamp\":\"2025-10-05T02:51:03.884Z\",\"MediaKey\":\"68e1dd173ad0e813aeefb2ee\"},{\"ResourceRecordKey\":\"NST7811544\",\"Order\":10,\"MediaObjectID\":\"10\",\"LongDescription\":\"10.jpg\",\"ImageWidth\":1024,\"ImageHeight\":684,\"ImageSizeDescription\":\"1024x684\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7811544/71138ca5-a446-45bf-b4de-b8d2783aa281.jpeg\",\"MediaModificationTimestamp\":\"2025-10-05T02:51:03.881Z\",\"MediaKey\":\"68e1dd173ad0e813aeefb2ef\"},{\"ResourceRecordKey\":\"NST7811544\",\"Order\":11,\"MediaObjectID\":\"11\",\"LongDescription\":\"11.jpg\",\"ImageWidth\":502,\"ImageHeight\":768,\"ImageSizeDescription\":\"502x768\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7811544/3b7b91e0-0e88-4653-bbb4-caec18a9c7bb.jpeg\",\"MediaModificationTimestamp\":\"2025-10-05T02:51:03.898Z\",\"MediaKey\":\"68e1dd173ad0e813aeefb2f0\"},{\"ResourceRecordKey\":\"NST7811544\",\"Order\":12,\"MediaObjectID\":\"12\",\"LongDescription\":\"13.jpg\",\"ImageWidth\":1024,\"ImageHeight\":678,\"ImageSizeDescription\":\"1024x678\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7811544/3836665c-e526-4595-a014-7707691f8d3c.jpeg\",\"MediaModificationTimestamp\":\"2025-10-05T02:51:03.923Z\",\"MediaKey\":\"68e1dd173ad0e813aeefb2f1\"},{\"ResourceRecordKey\":\"NST7811544\",\"Order\":13,\"MediaObjectID\":\"13\",\"LongDescription\":\"14.jpg\",\"ImageWidth\":1024,\"ImageHeight\":669,\"ImageSizeDescription\":\"1024x669\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7811544/ae42fd2a-66e1-46be-828e-dca466ba2fd0.jpeg\",\"MediaModificationTimestamp\":\"2025-10-05T02:51:03.884Z\",\"MediaKey\":\"68e1dd173ad0e813aeefb2f2\"},{\"ResourceRecordKey\":\"NST7811544\",\"Order\":14,\"MediaObjectID\":\"14\",\"LongDescription\":\"15.jpg\",\"ImageWidth\":502,\"ImageHeight\":768,\"ImageSizeDescription\":\"502x768\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7811544/99c82136-20a0-41a3-92d0-1a649fe4ac3a.jpeg\",\"MediaModificationTimestamp\":\"2025-10-05T02:51:03.902Z\",\"MediaKey\":\"68e1dd173ad0e813aeefb2f3\"},{\"ResourceRecordKey\":\"NST7811544\",\"Order\":15,\"MediaObjectID\":\"15\",\"LongDescription\":\"16.jpg\",\"ImageWidth\":1024,\"ImageHeight\":672,\"ImageSizeDescription\":\"1024x672\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7811544/f2555457-732f-4516-9222-44c2d2b110dc.jpeg\",\"MediaModificationTimestamp\":\"2025-10-05T02:51:03.946Z\",\"MediaKey\":\"68e1dd173ad0e813aeefb2f4\"},{\"ResourceRecordKey\":\"NST7811544\",\"Order\":16,\"MediaObjectID\":\"16\",\"LongDescription\":\"17.jpg\",\"ImageWidth\":1024,\"ImageHeight\":663,\"ImageSizeDescription\":\"1024x663\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7811544/fb36f28d-506d-4b8b-b842-c5d6c72288f0.jpeg\",\"MediaModificationTimestamp\":\"2025-10-05T02:51:03.928Z\",\"MediaKey\":\"68e1dd173ad0e813aeefb2f5\"}]","Rooms":"[{\"RoomKey\":\"NST115674219\",\"RoomType\":\"Living Room\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"17x13\",\"NST_RoomSortOrder\":\"1\"},{\"RoomKey\":\"NST115674220\",\"RoomType\":\"Family Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"14x12\",\"NST_RoomSortOrder\":\"3\"},{\"RoomKey\":\"NST115674221\",\"RoomType\":\"Kitchen\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"15x9\",\"NST_RoomSortOrder\":\"4\"},{\"RoomKey\":\"NST115674222\",\"RoomType\":\"Bedroom 1\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"11x11\",\"NST_RoomSortOrder\":\"5\"},{\"RoomKey\":\"NST115674223\",\"RoomType\":\"Bedroom 2\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"11x10\",\"NST_RoomSortOrder\":\"6\"},{\"RoomKey\":\"NST115674224\",\"RoomType\":\"Bedroom 3\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"10x11\",\"NST_RoomSortOrder\":\"7\"},{\"RoomKey\":\"NST115674225\",\"RoomType\":\"Bedroom 4\",\"RoomLevel\":\"Lower\",\"RoomDimensions\":\"14x10\",\"NST_RoomSortOrder\":\"8\"},{\"RoomKey\":\"NST115674226\",\"RoomType\":\"Bedroom 5\",\"RoomLevel\":\"Lower\",\"RoomDimensions\":\"10x10\",\"NST_RoomSortOrder\":\"9\"},{\"RoomKey\":\"NST115674227\",\"RoomType\":\"Family Room\",\"RoomLevel\":\"Lower\",\"RoomDimensions\":\"25x12\",\"NST_RoomSortOrder\":\"10\"},{\"RoomKey\":\"NST115674228\",\"RoomType\":\"Three Season Porch\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"16x12\",\"NST_RoomSortOrder\":\"11\"},{\"RoomKey\":\"NST115674229\",\"RoomType\":\"Foyer\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"14x12\",\"NST_RoomSortOrder\":\"12\"}]","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"1.jpg\"},{\"Order\":2,\"Remarks\":\"2.jpg\"},{\"Order\":3,\"Remarks\":\"3.jpg\"},{\"Order\":4,\"Remarks\":\"4.jpg\"},{\"Order\":5,\"Remarks\":\"5.jpg\"},{\"Order\":6,\"Remarks\":\"6.jpg\"},{\"Order\":7,\"Remarks\":\"7.jpg\"},{\"Order\":8,\"Remarks\":\"8.jpg\"},{\"Order\":9,\"Remarks\":\"9.jpg\"},{\"Order\":10,\"Remarks\":\"10.jpg\"},{\"Order\":11,\"Remarks\":\"11.jpg\"},{\"Order\":12,\"Remarks\":\"13.jpg\"},{\"Order\":13,\"Remarks\":\"14.jpg\"},{\"Order\":14,\"Remarks\":\"15.jpg\"},{\"Order\":15,\"Remarks\":\"16.jpg\"},{\"Order\":16,\"Remarks\":\"17.jpg\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16","CustomVTourURL":""}