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":490210,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST6807836","MLSAGENTID":"NST506000564","MLSOFFICEID":"NST8230","ADDRESS":"592X Hodgson Road","ACRES":0.413,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Drain Tiled,Egress Window(s),Full,Concrete,Sump Basket,Sump Pump,Unfinished","BATHSTOTAL":3.0,"BEDROOMS":4.0,"CITY":"Shoreview","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"FORECLOSURE":"No","LASTPRICE":768900.0,"LASTPRICEDATE":"2026-03-05T14:40:06.337","LATITUDE":45.12030489,"LENDEROWNED":"No","LISTDATE":"2025-10-22T05:00:00","LISTPRICE":753900.0,"LIVINGAREA":2200.0,"LONGITUDE":-93.12695308,"LOTDESCRIPTION":"Tree Coverage - Medium","MODIFICATIONTIMESTAMP":"2026-03-05T14:40:06.335","OFFICE_OFFICENAME":"Coldwell Banker Realty","PHOTOCOUNT":1,"POSTALCODE":"55126","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Beautiful setting for this wonderful \"To Be Built \" Custom 4+ Bedroom, 3+ bath, Two story with an L shaped 3 car garage. This Custom built home can have a standard front load three or four car garage or an L Shaped load. Beautiful finishes throughout. Buyer has ability to change the plan or modify any aspect of a plan. Big wooded lot in the 621 Moundsview School district.\nBuilder has 14 pages of references.","ROADBETWEENWATERFRONTANDHOMEYN":false,"SCHOOLDISTRICTNUMBER":"2090-Mounds View","SCHOOLDISTRICTPHONE":"6516216001","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2025-10-22T14:51:03.667","LASTSTATUS":"Active","STREETNAME":"Hodgson","STREETNUMBER":"592X","STREETSUFFIX":"Road","STYLE":"Single Family Residence","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":2026,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2025-11-07T22:57:03.975","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"592x Hodgson Rd\"}]","PHOTOORDER":"1","SOURCE":"MG_NST"}
{"NST_AboveGradeSqFtTotal":"2200","AboveGradeFinishedArea":"2200","AccessibilityFeatures":"Other","AdditionalParcelsYN":"False","NST_AgentOwner":"No","NST_AmenitiesUnit":"Kitchen Center Island,Kitchen Window,Tile Floors,Washer/Dryer Hookup,Walk-In Closet","Appliances":"Air-To-Air Exchanger,Dishwasher,Disposal,Exhaust Fan,Gas Water Heater,Microwave,Range,Refrigerator","LivingAreaUnits":"Square Feet","NST_AssessmentPending":"No","AssociationYN":"False","AssociationFee":"0","AttributionContact":"6513871314","NST_AttributionName":"Richard D. Kotoski","Basement":"Drain Tiled,Egress Window(s),Full,Concrete,Sump Basket,Sump Pump,Unfinished","BasementYN":"True","NST_BathDesc":"3/4 Primary,Basement,Double Sink,Private Primary,Main Floor 1/2 Bath,Rough In,Upper Level Full Bath","BathroomsFull":"1","BathroomsHalf":"1","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"1","BathroomsTotalInteger":"3","BedroomsTotal":"4","NST_BelowGradeSqFtTotal":"1014","BelowGradeFinishedArea":"0","NST_BuilderLicense":"335373","BuilderName":"LEE HOMES INC","CumulativeDaysOnMarket":"0","City":"Shoreview","NewConstructionYN":"False","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Ramsey","NST_DPResource":"Yes","NST_DiningRoomDescription":"Kitchen/Dining Room","Directions":"Hwy 96, North on Hodgson Road.","DocumentsCount":"0","DaysOnMarket":"0","FireplaceFeatures":"Gas","FireplaceYN":"True","FireplacesTotal":"1","FoundationArea":"1014","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","NST_GarageSquareFeet":"884","GarageSpaces":"3","Heating":"Forced Air","HighSchoolDistrict":"Mounds View","NST_ForeclosureStatus":"No","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"False","InternetConsumerCommentYN":"False","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","Latitude":"45.1203048925","LaundryFeatures":"Laundry Room,Upper Level","NST_LenderOwned":"No","Levels":"Two","ListPrice":"753900","ListingContractDate":"2025-10-22T05:00:00Z","ListingId":"NST6807836","ListingKey":"NST7818855","LivingArea":"2200","Longitude":"-93.1269530809","LotFeatures":"Tree Coverage - Medium","LotSizeArea":"0.413","LotSizeDimensions":"100x180","LotSizeUnits":"Acres","NST_MainLevelFinishedArea":"1014","NST_ManufacturedHome":"N","OriginalEntryTimestamp":"2025-10-22T09:49:41Z","ParcelNumber":"TBD","NST_SchoolDistrictNumber":"2090","ParkingFeatures":"Attached Garage","PhotosCount":"1","PhotosChangeTimestamp":"2025-11-07T22:57:03.975Z","PostalCity":"Shoreview","PostalCode":"55126","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PropertyAttachedYN":"False","PropertySubType":"Single Family Residence","PropertyType":"Residential","PublicRemarks":"Beautiful setting for this wonderful \"To Be Built \" Custom 4+ Bedroom, 3+ bath, Two story with an L shaped 3 car garage. This Custom built home can have a standard front load three or four car garage or an L Shaped load. Beautiful finishes throughout. Buyer has ability to change the plan or modify any aspect of a plan. Big wooded lot in the 621 Moundsview School district.\nBuilder has 14 pages of references.","RoadFrontageType":"County Road","NST_SchoolDistrictPhone":"6516216001","Sewer":"City Sewer/Connected","NST_SpecialSearch":"2nd Floor Laundry,3 BR on One Level,4 BR on One Level","StandardStatus":"Active","StateOrProvince":"MN","StreetName":"Hodgson","StreetNumber":"592X","StreetNumberNumeric":"592","StreetSuffix":"Road","TaxAnnualAmount":"1614","NST_TaxWithAssessments":"1614","TaxYear":"2025","BuildingAreaTotal":"3214","Township":"Shoreview","VideosCount":"0","WaterSource":"City Water/Connected","YearBuilt":"2026","ZoningDescription":"Residential-Single Family","ListAgentKey":"NST47084","ListAgentMlsId":"NST506000564","ListOfficeMlsId":"NST8230","ListOfficeName":"Coldwell Banker Realty","ListOfficeKey":"NST16459","ModificationTimestamp":"2026-03-05T14:40:06.335Z","OriginatingSystemName":"northstar","Media":"[{\"LongDescription\":\"592x Hodgson Rd\",\"ResourceRecordKey\":\"NST7818855\",\"Order\":1,\"MediaObjectID\":\"NST1\",\"ImageWidth\":1920,\"ImageHeight\":1440,\"ImageSizeDescription\":\"1920x1440\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7818855/b62586fd-9dc6-46c1-a335-c3ca665421de.jpeg\",\"MediaModificationTimestamp\":\"2025-11-07T20:50:19.23Z\",\"MediaKey\":\"690e5b8b4999357d637ad589\"}]","Media__LongDescription":"592x Hodgson Rd","Media__ResourceRecordKey":"NST7818855","Media__Order":"1","Media__MediaObjectID":"NST1","Media__ImageWidth":"1920","Media__ImageHeight":"1440","Media__ImageSizeDescription":"1920x1440","Media__MediaURL":"https://s3.amazonaws.com/mlsgrid/images/NST7818855/b62586fd-9dc6-46c1-a335-c3ca665421de.jpeg","Media__MediaModificationTimestamp":"11/7/2025 8:50:19 PM","Media__MediaKey":"690e5b8b4999357d637ad589","DocumentsChangeTimestamp":"2025-10-22T14:51:03.667Z","Rooms":"[{\"RoomKey\":\"NST115721793\",\"NST_RoomSortOrder\":2,\"RoomDimensions\":\"18x19\",\"RoomType\":\"Dining Room\",\"RoomLevel\":\"Main\"},{\"RoomKey\":\"NST115721796\",\"NST_RoomSortOrder\":5,\"RoomDimensions\":\"16x13\",\"RoomType\":\"Bedroom\",\"RoomLevel\":\"Upper\"},{\"RoomKey\":\"NST115721799\",\"NST_RoomSortOrder\":8,\"RoomDimensions\":\"12x11\",\"RoomType\":\"Bedroom 4\",\"RoomLevel\":\"Upper\"},{\"RoomKey\":\"NST115721802\",\"NST_RoomSortOrder\":11,\"RoomDimensions\":\"7x8\",\"RoomType\":\"Foyer\",\"RoomLevel\":\"Main\"},{\"RoomKey\":\"NST115721792\",\"NST_RoomSortOrder\":1,\"RoomDimensions\":\"15x16\",\"RoomType\":\"Great Room\",\"RoomLevel\":\"Main\"},{\"RoomKey\":\"NST115721794\",\"NST_RoomSortOrder\":3,\"RoomDimensions\":\"16x11\",\"RoomType\":\"Kitchen\",\"RoomLevel\":\"Main\"},{\"RoomKey\":\"NST115721801\",\"NST_RoomSortOrder\":10,\"RoomDimensions\":\"8x7\",\"RoomType\":\"Laundry\",\"RoomLevel\":\"Upper\"},{\"RoomKey\":\"NST115721800\",\"NST_RoomSortOrder\":9,\"RoomDimensions\":\"9x8\",\"RoomType\":\"Mud Room\",\"RoomLevel\":\"Main\"},{\"RoomKey\":\"NST115721795\",\"NST_RoomSortOrder\":4,\"RoomDimensions\":\"8x9\",\"RoomType\":\"Office\",\"RoomLevel\":\"Main\"},{\"RoomKey\":\"NST115721797\",\"NST_RoomSortOrder\":6,\"RoomDimensions\":\"12x11\",\"RoomType\":\"Bedroom 2\",\"RoomLevel\":\"Upper\"},{\"RoomKey\":\"NST115721798\",\"NST_RoomSortOrder\":7,\"RoomDimensions\":\"14x11\",\"RoomType\":\"Bedroom 3\",\"RoomLevel\":\"Upper\"}]","Rooms__RoomKey":"NST115721793","Rooms__NST_RoomSortOrder":"2","Rooms__RoomDimensions":"18x19","Rooms__RoomType":"Dining Room","Rooms__RoomLevel":"Main","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"592x Hodgson Rd\"}]","PhotoOrder":"1","CustomVTourURL":""}