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":509403,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST7005797","MLSAGENTID":"NST496504175","MLSOFFICEID":"NST11004","ADDRESS":"2718 16th Avenue E","ACRES":0.229,"AGENTOWNER":true,"AUCTIONYN":false,"BASEMENT":"Block,Drain Tiled,Egress Window(s),Finished,Full,Sump Pump,Walkout","BATHSTOTAL":3.0,"BEDROOMS":6,"CITY":"North Saint Paul","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Frame","FORECLOSURE":"No","LASTPRICE":459000.0,"LASTPRICEDATE":"2026-01-09T22:46:05.99","LATITUDE":45.020044,"LENDEROWNED":"No","LISTDATE":"2026-01-09T06:00:00","LISTPRICE":459000.0,"LIVINGAREA":2468.0,"LONGITUDE":-92.985664,"LOTDESCRIPTION":"Tree Coverage - Light","MODIFICATIONTIMESTAMP":"2026-01-11T00:24:05.542","OFFICE_OFFICENAME":"Wallin Residential Properties","PHOTOCOUNT":8,"POSTALCODE":"55109","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"This 2026 newly finished six-bedroom home offers a combination of high-capacity living and upgraded architectural features designed for modern functionality. \nKey Property Features: The home includes six bedrooms, a rare high-occupancy feature often designed to maximize resale value or accommodate large families.\nThe house has three bathrooms, the home utilizes a common 2:1 bedroom-to-bathroom ratio, making these three primary facilities essential high-use areas. The kitchen designed with panel cabinets, granite countertops, and a granite covered center island. The garage is oversized (24' Deep, 8' High Door): This specific depth allows for parking full-size crew cab pickups with room to walk around the vehicle. The 8-foot door height is a significant upgrade over the standard 7-foot door, accommodating taller SUVs, roof racks, and improving vertical storage options. There is also an entrance through the garage to the laundry room. A highly sought after feature that is seldom built into houses. The lower level & outdoor space provides a walk-out basement that provides direct access to a large patio, which is a top 2026 trend for seamless indoor-outdoor living. Additional details for the property include oversized sidewalks and a large driveway, enhancing curb appeal and accommodating multiple vehicles or guests.","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Age 8 Years or Less,Asphalt,Pitched","SCHOOLDISTRICTNUMBER":"2093-North St Paul-Maplewood","SCHOOLDISTRICTPHONE":"6517487410","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Pending","STATUSDATE":"2026-01-11T00:24:05.543","LASTSTATUS":"Active","STREETDIRSUFFIX":"E","STREETNAME":"16th","STREETNUMBER":"2718","STREETSUFFIX":"Avenue","STYLE":"Single Family Residence","TRANSACTIONTYPE":"For","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":2026,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2026-01-09T22:40:06.074","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"over sized sidewalk, gutter around house\"},{\"Order\":2,\"Remarks\":\"Parking space along side garage, 20 feet long\"},{\"Order\":3,\"Remarks\":\"Smuge proof Stainless appliances and granite counter tops\"},{\"Order\":4,\"Remarks\":\"Granite counter tops in bathrooms\"},{\"Order\":5,\"Remarks\":\"Vaulted Ceiling, luxury vynil in walkways\"},{\"Order\":6,\"Remarks\":\"Lofted entry\"},{\"Order\":7,\"Remarks\":\"Yard is established\"},{\"Order\":8,\"Remarks\":\"back yard, walk out with nice size patio\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8","MLSBUYERAGENTID":"NST502018332","SOURCE":"MG_NST"}
{"ListingKey":"NST7840221","NST_AboveGradeSqFtTotal":"1234","AboveGradeFinishedArea":"1234","AccessibilityFeatures":"None","AdditionalParcelsYN":"False","NST_AgentOwner":"Yes","Appliances":"Air-To-Air Exchanger,Dishwasher,Microwave,Range,Refrigerator,Stainless Steel Appliances,Water Softener Owned","LivingAreaUnits":"Square Feet","NST_AssessmentPending":"No","AssociationYN":"False","AssociationFee":"0","Basement":"Block,Drain Tiled,Egress Window(s),Finished,Full,Sump Pump,Walkout","BasementYN":"True","NST_BathDesc":"Full Primary,Full Basement,Private Primary,Main Floor 3/4 Bath,Main Floor Full Bath,Walk-In Shower Stall","BathroomsFull":"2","BathroomsHalf":"0","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"1","BathroomsTotalInteger":"3","BedroomsTotal":"6","NST_BelowGradeSqFtTotal":"1234","BelowGradeFinishedArea":"1234","BuyerOfficeName":"RES Realty","CumulativeDaysOnMarket":"1","CarportSpaces":"0","City":"North Saint Paul","NST_CompletionDate":"2026-01-19","ConstructionMaterials":"Frame","NewConstructionYN":"True","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Ramsey","NST_DPResource":"Yes","NST_DiningRoomDescription":"Breakfast Bar,Kitchen/Dining Room,Living/Dining Room","Directions":"Next to Dairy Queen on 16th Ave East","DocumentsCount":"5","DocumentsChangeTimestamp":"2026-01-09T22:42:05.673Z","DaysOnMarket":"1","Electric":"Circuit Breakers,150 Amp Service","Fencing":"Other","FireplaceYN":"False","FireplacesTotal":"0","FoundationArea":"1234","NST_FoundationDimensions":"48x26","NST_FractionalOwnershipYN":"No","NST_Fuel":"Electric,Natural Gas","NST_GarageSquareFeet":"610","NST_GarageDimensions":"24'4x24","NST_GarageDoorHeight":"8","NST_GarageDoorWidth":"16","GarageSpaces":"2","Heating":"Forced Air","HighSchoolDistrict":"North St Paul-Maplewood","NST_ForeclosureStatus":"No","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"False","InternetConsumerCommentYN":"False","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","Latitude":"45.020044","LaundryFeatures":"In Basement,Gas Dryer Hookup,Lower Level,Washer Hookup","NST_LenderOwned":"No","Levels":"Split Entry (Bi-Level)","ListPrice":"459000","ListingContractDate":"2026-01-09T06:00:00Z","ListingId":"NST7005797","LivingArea":"2468","LockBoxType":"Combo","Longitude":"-92.985664","LotFeatures":"Tree Coverage - Light","LotSizeArea":"0.229","LotSizeDimensions":"125x80","LotSizeUnits":"Acres","NST_MainLevelFinishedArea":"1234","NST_ManufacturedHome":"N","OffMarketDate":"2026-01-10T06:00:00Z","OriginalEntryTimestamp":"2026-01-09T16:37:46Z","ParcelNumber":"122922110019","NST_SchoolDistrictNumber":"2093","ParkingFeatures":"Attached Garage,Asphalt,Electric,Insulated Garage","PendingTimestamp":"2026-01-10T18:23:24Z","PhotosCount":"8","PhotosChangeTimestamp":"2026-01-09T22:40:06.074Z","PostalCity":"Saint Paul","PostalCode":"55109","NST_PotentialShortSale":"No","NST_PowerCompanyName":"Xcel Energy","NST_PresentUse":"Yearly","PropertyAttachedYN":"False","PropertySubType":"Single Family Residence","PropertyType":"Residential","PublicRemarks":"This 2026 newly finished six-bedroom home offers a combination of high-capacity living and upgraded architectural features designed for modern functionality. \nKey Property Features: The home includes six bedrooms, a rare high-occupancy feature often designed to maximize resale value or accommodate large families.\nThe house has three bathrooms, the home utilizes a common 2:1 bedroom-to-bathroom ratio, making these three primary facilities essential high-use areas. The kitchen designed with panel cabinets, granite countertops, and a granite covered center island. The garage is oversized (24' Deep, 8' High Door): This specific depth allows for parking full-size crew cab pickups with room to walk around the vehicle. The 8-foot door height is a significant upgrade over the standard 7-foot door, accommodating taller SUVs, roof racks, and improving vertical storage options. There is also an entrance through the garage to the laundry room. A highly sought after feature that is seldom built into houses. The lower level & outdoor space provides a walk-out basement that provides direct access to a large patio, which is a top 2026 trend for seamless indoor-outdoor living. Additional details for the property include oversized sidewalks and a large driveway, enhancing curb appeal and accommodating multiple vehicles or guests.","PublicSurveyRange":"22","PublicSurveySection":"12","PublicSurveyTownship":"29","Roof":"Age 8 Years or Less,Asphalt,Pitched","NST_SchoolDistrictPhone":"6517487410","Sewer":"City Sewer/Connected","StandardStatus":"Pending","StateOrProvince":"MN","StreetDirSuffix":"E","StreetName":"16th","StreetNumber":"2718","StreetNumberNumeric":"2718","StreetSuffix":"Avenue","SubdivisionName":"Third Add To North, St Pa","TaxAnnualAmount":"558","NST_TaxWithAssessments":"558","TaxYear":"2025","Township":"North Saint Paul","VideosCount":"0","WaterSource":"City Water/Connected","YearBuilt":"2026","ZoningDescription":"Residential-Single Family","BuyerAgentKey":"NST73140","BuyerAgentMlsId":"NST502018332","BuyerOfficeMlsId":"NST12127","BuyerOfficeKey":"NST17084","ListAgentKey":"NST87742","ListAgentMlsId":"NST496504175","ListOfficeMlsId":"NST11004","ListOfficeName":"Wallin Residential Properties","ListOfficeKey":"NST14722","ModificationTimestamp":"2026-01-11T00:24:05.542Z","OriginatingSystemName":"northstar","Media":"[{\"Order\":4,\"MediaObjectID\":\"NST4\",\"ResourceRecordKey\":\"NST7840221\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7840221/4603dca4-e0ac-43c8-b31a-423e50095b43.jpeg\",\"LongDescription\":\"Granite counter tops in bathrooms\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaModificationTimestamp\":\"2026-01-09T22:39:37.657Z\",\"MediaKey\":\"NST120099731\"},{\"Order\":1,\"MediaObjectID\":\"NST1\",\"ResourceRecordKey\":\"NST7840221\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7840221/ac253467-15b1-4538-917a-145f02c44af4.jpeg\",\"LongDescription\":\"over sized sidewalk, gutter around house\",\"ImageWidth\":2080,\"ImageHeight\":1148,\"ImageSizeDescription\":\"2080x1148\",\"MediaModificationTimestamp\":\"2026-01-09T22:39:37.657Z\",\"MediaKey\":\"NST120099739\"},{\"Order\":3,\"MediaObjectID\":\"NST3\",\"ResourceRecordKey\":\"NST7840221\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7840221/83126139-f47d-4fda-a67e-aa6d8e42b6ed.jpeg\",\"LongDescription\":\"Smuge proof Stainless appliances and granite counter tops\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-01-09T22:39:37.656Z\",\"MediaKey\":\"NST120099718\"},{\"Order\":5,\"MediaObjectID\":\"NST5\",\"ResourceRecordKey\":\"NST7840221\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7840221/bbf54b1d-6a5f-450b-92a9-dca05adb4ca7.jpeg\",\"LongDescription\":\"Vaulted Ceiling, luxury vynil in walkways\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-01-09T22:39:37.656Z\",\"MediaKey\":\"NST120099722\"},{\"Order\":8,\"MediaObjectID\":\"NST8\",\"ResourceRecordKey\":\"NST7840221\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7840221/2ac05af3-662a-4978-b8df-b52893b7aab6.jpeg\",\"LongDescription\":\"back yard, walk out with nice size patio\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-01-09T22:39:37.846Z\",\"MediaKey\":\"NST120060146\"},{\"Order\":2,\"MediaObjectID\":\"NST2\",\"ResourceRecordKey\":\"NST7840221\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7840221/c8e81503-525f-46dd-a07a-408d65ab3a67.jpeg\",\"LongDescription\":\"Parking space along side garage, 20 feet long\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-01-09T22:39:37.727Z\",\"MediaKey\":\"NST120099738\"},{\"Order\":6,\"MediaObjectID\":\"NST6\",\"ResourceRecordKey\":\"NST7840221\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7840221/0d0ad7d0-7a7d-4940-b863-9b4e99f9162b.jpeg\",\"LongDescription\":\"Lofted entry\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaModificationTimestamp\":\"2026-01-09T22:39:37.697Z\",\"MediaKey\":\"NST120099726\"},{\"Order\":7,\"MediaObjectID\":\"NST7\",\"ResourceRecordKey\":\"NST7840221\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7840221/959a660a-cc9c-4198-9bfc-4148c4f8d9bb.jpeg\",\"LongDescription\":\"Yard is established\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-01-09T22:39:37.754Z\",\"MediaKey\":\"NST120060147\"}]","Media__Order":"4","Media__MediaObjectID":"NST4","Media__ResourceRecordKey":"NST7840221","Media__MediaURL":"https://s3.amazonaws.com/mlsgrid/images/NST7840221/4603dca4-e0ac-43c8-b31a-423e50095b43.jpeg","Media__LongDescription":"Granite counter tops in bathrooms","Media__ImageWidth":"1560","Media__ImageHeight":"2080","Media__ImageSizeDescription":"1560x2080","Media__MediaModificationTimestamp":"1/9/2026 10:39:37 PM","Media__MediaKey":"NST120099731","Rooms":"[{\"RoomKey\":\"NST115853303\",\"RoomLevel\":\"Lower\",\"NST_RoomSortOrder\":12,\"RoomDimensions\":\"12'5x10'9\",\"RoomType\":\"Bathroom\"},{\"RoomKey\":\"NST115853304\",\"RoomLevel\":\"Upper\",\"NST_RoomSortOrder\":13,\"RoomDimensions\":\"8'2x7\",\"RoomType\":\"Bathroom\"},{\"RoomKey\":\"NST115853305\",\"RoomLevel\":\"Upper\",\"NST_RoomSortOrder\":14,\"RoomDimensions\":\"9'8x7\",\"RoomType\":\"Bathroom\"},{\"RoomKey\":\"NST115853293\",\"RoomLevel\":\"Upper\",\"NST_RoomSortOrder\":2,\"RoomDimensions\":\"10x10'6\",\"RoomType\":\"Dining Room\"},{\"RoomKey\":\"NST115853302\",\"RoomLevel\":\"Lower\",\"NST_RoomSortOrder\":11,\"RoomDimensions\":\"15'11x17'8\",\"RoomType\":\"Family Room\"},{\"RoomKey\":\"NST115853300\",\"RoomLevel\":\"Lower\",\"NST_RoomSortOrder\":9,\"RoomDimensions\":\"13x9'8\",\"RoomType\":\"Bedroom 5\"},{\"RoomKey\":\"NST115853295\",\"RoomLevel\":\"Upper\",\"NST_RoomSortOrder\":4,\"RoomDimensions\":\"12x11\",\"RoomType\":\"Bedroom\"},{\"RoomKey\":\"NST115853299\",\"RoomLevel\":\"Lower\",\"NST_RoomSortOrder\":8,\"RoomDimensions\":\"13x9'8\",\"RoomType\":\"Bedroom 4\"},{\"RoomKey\":\"NST115853298\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":7,\"RoomDimensions\":\"7x10\",\"RoomType\":\"Foyer\"},{\"RoomKey\":\"NST115853292\",\"RoomLevel\":\"Upper\",\"NST_RoomSortOrder\":1,\"RoomDimensions\":\"10x10'6\",\"RoomType\":\"Kitchen\"},{\"RoomKey\":\"NST115853294\",\"RoomLevel\":\"Upper\",\"NST_RoomSortOrder\":3,\"RoomDimensions\":\"13'8x15'8\",\"RoomType\":\"Living Room\"},{\"RoomKey\":\"NST115853296\",\"RoomLevel\":\"Upper\",\"NST_RoomSortOrder\":5,\"RoomDimensions\":\"10x10\",\"RoomType\":\"Bedroom 2\"},{\"RoomKey\":\"NST115853301\",\"RoomLevel\":\"Lower\",\"NST_RoomSortOrder\":10,\"RoomDimensions\":\"12'5x10'9\",\"RoomType\":\"Bedroom 6\"},{\"RoomKey\":\"NST115853297\",\"RoomLevel\":\"Upper\",\"NST_RoomSortOrder\":6,\"RoomDimensions\":\"10x10\",\"RoomType\":\"Bedroom 3\"}]","Rooms__RoomKey":"NST115853303","Rooms__RoomLevel":"Lower","Rooms__NST_RoomSortOrder":"12","Rooms__RoomDimensions":"12'5x10'9","Rooms__RoomType":"Bathroom","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"over sized sidewalk, gutter around house\"},{\"Order\":2,\"Remarks\":\"Parking space along side garage, 20 feet long\"},{\"Order\":3,\"Remarks\":\"Smuge proof Stainless appliances and granite counter tops\"},{\"Order\":4,\"Remarks\":\"Granite counter tops in bathrooms\"},{\"Order\":5,\"Remarks\":\"Vaulted Ceiling, luxury vynil in walkways\"},{\"Order\":6,\"Remarks\":\"Lofted entry\"},{\"Order\":7,\"Remarks\":\"Yard is established\"},{\"Order\":8,\"Remarks\":\"back yard, walk out with nice size patio\"}]","PhotoOrder":"1,2,3,4,5,6,7,8","CustomVTourURL":""}