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":1399581,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST6777303","MLSAGENTID":"NST506014183","MLSCOAGENTID":"NST506008306","MLSOFFICEID":"NST26187","ADDRESS":"2175 Acorn Road","ACRES":0.33,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Drain Tiled,Finished,Walkout","BATHSTOTAL":4.0,"BEDROOMS":4,"CITY":"Roseville","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Brick/Stone,Vinyl Siding","FORECLOSURE":"No","LASTPRICE":849000.0,"LASTPRICEDATE":"2025-08-23T14:09:03.853","LATITUDE":45.00650551,"LENDEROWNED":"No","LISTDATE":"2025-08-23T05:00:00","LISTPRICE":849000.0,"LIVINGAREA":3833.0,"LONGITUDE":-93.19098901,"MODIFICATIONTIMESTAMP":"2025-08-23T14:16:03.891","OFFICE_OFFICENAME":"POP Realty MN","PHOTOCOUNT":17,"POSTALCODE":"55113","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Welcome to this custom-built home offering 3,833 sq ft of refined living space. Nestled in one of the best neighborhoods in Roseville, this home has a 2-story vaulted ceiling living room with a beautiful stone fireplace, walnut hardwood flooring and a large, private 3-season porch for relaxing without the worry of mosquitoes. Entertain family and friends in the high-end gourmet kitchen with open dining area. The spacious walkout basement offers endless opportunities and includes a fireplace for cozy, movie and game nights. Conveniently located near Highway 36 and 35W, enjoy easy access to both cities, making this home a haven of both comfort and convenience. This home has tons of storage, a large 3-car garage and pride of ownership shows","ROADBETWEENWATERFRONTANDHOMEYN":false,"SCHOOLDISTRICTNUMBER":"623-Roseville","SCHOOLDISTRICTPHONE":"651-635-1600","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2025-08-23T14:09:03.853","LASTSTATUS":"Active","STREETNAME":"Acorn","STREETNUMBER":"2175","STREETSUFFIX":"Road","STYLE":"Single Family Residence","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":2006,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2025-08-23T14:16:03.891","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17","SOURCE":"MG_NST"}
{"ListingKey":"NST7792488","LotSizeArea":"0.33","NST_AgeOfProperty":"19","NST_AgentOwner":"No","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"False","NST_AmenitiesUnit":"Ceiling Fan(s),Hardwood Floors,Kitchen Center Island,Kitchen Window,Primary Bedroom Walk-In Closet,Natural Woodwork,Patio,Tile Floors,Vaulted Ceiling(s),Wet Bar","Appliances":"Air-To-Air Exchanger,Cooktop,Dishwasher,Disposal,Dryer,Humidifier,Microwave,Refrigerator,Stainless Steel Appliances,Washer","NST_AssessmentPending":"Unknown","AssociationYN":"False","AssociationFee":"0","PropertyAttachedYN":"False","Basement":"Drain Tiled,Finished,Walkout","BasementYN":"True","NST_BathDesc":"3/4 Basement,Full Primary,Private Primary,Main Floor 1/2 Bath,Upper Level Full Bath","BathroomsOneQuarter":"0","BathroomsFull":"3","BathroomsHalf":"1","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"4","BedroomsTotal":"4","City":"Roseville","PropertyType":"Residential","NewConstructionYN":"False","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Ramsey","NST_DiningRoomDescription":"Eat In Kitchen,Separate/Formal Dining Room","Directions":"HWY 36 TO CLEVELAND TO COUNTY RD. B W.","InternetAddressDisplayYN":"True","InternetEntireListingDisplayYN":"True","ConstructionMaterials":"Brick/Stone,Vinyl Siding","FireplaceFeatures":"Family Room,Gas,Living Room","FireplacesTotal":"2","NST_ForeclosureStatus":"No","FoundationArea":"1384","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","ParkingFeatures":"Attached Garage","NST_GarageSquareFeet":"785","AccessibilityFeatures":"None","Heating":"Forced Air","OriginalEntryTimestamp":"2025-08-23T14:06:00Z","LandLeaseYN":"False","NST_LastUpdateDate":"2025-08-23","Latitude":"45.0065055125","NST_LenderOwned":"No","ListAgentKey":"NST107242","ListAgentMlsId":"NST506014183","CoListAgentKey":"NST96971","CoListAgentMlsId":"NST506008306","ListingContractDate":"2025-08-23T05:00:00Z","ListOfficeKey":"NST26187","ListOfficeName":"POP Realty MN","ListOfficeMlsId":"NST26187","ListPrice":"849000","LivingArea":"3833","Longitude":"-93.1909890129","LotSizeDimensions":"182x102x30x41x119x76","LotSizeSquareFeet":"14374.8","LotSizeUnits":"Acres","ListingId":"NST6777303","SourceSystemName":"RMLS","NST_ManufacturedHome":"No","MapCoordinateSource":"King's Street Atlas","AdditionalParcelsYN":"False","NST_OfficeBoard":"SPAAR","ParcelNumber":"08292344042","GarageSpaces":"3","PhotosCount":"17","PostalCity":"Roseville","PostalCode":"55113","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PublicRemarks":"Welcome to this custom-built home offering 3,833 sq ft of refined living space. Nestled in one of the best neighborhoods in Roseville, this home has a 2-story vaulted ceiling living room with a beautiful stone fireplace, walnut hardwood flooring and a large, private 3-season porch for relaxing without the worry of mosquitoes. Entertain family and friends in the high-end gourmet kitchen with open dining area. The spacious walkout basement offers endless opportunities and includes a fireplace for cozy, movie and game nights. Conveniently located near Highway 36 and 35W, enjoy easy access to both cities, making this home a haven of both comfort and convenience. This home has tons of storage, a large 3-car garage and pride of ownership shows","PublicSurveyRange":"23","PublicSurveySection":"08","PublicSurveyTownship":"29","NST_RentalLicenseYN":"No","RoomType":"Living Room,Dining Room,Family Room,Kitchen,Bedroom 1,Bedroom 2,Bedroom 3,Bedroom 4,Screened Porch,Recreation Room","NST_AboveGradeSqFtTotal":"2717.0000","NST_BelowGradeSqFtTotal":"1384.0000","NST_MainLevelFinishedArea":"1384.0000","BuildingAreaTotal":"4101","HighSchoolDistrict":"Roseville","NST_SchoolDistrictNumber":"623","NST_SchoolDistrictPhone":"651-635-1600","Sewer":"City Sewer/Connected","AboveGradeFinishedArea":"2717","BelowGradeFinishedArea":"1116","StateOrProvince":"MN","StandardStatus":"Active","Levels":"Two","StreetName":"Acorn","StreetNumber":"2175","StreetNumberNumeric":"2175","StreetSuffix":"Road","PropertySubType":"Single Family Residence","SubdivisionName":"Section 8 Town 29 Range 23","NST_TaxWithAssessments":"13370.0000","TaxYear":"2025","TaxAnnualAmount":"13370","WaterSource":"City Water/Connected","YearBuilt":"2006","ZoningDescription":"Residential-Single Family","ModificationTimestamp":"2025-08-23T14:16:03.891Z","PhotosChangeTimestamp":"2025-08-23T14:16:03.891Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7792488\",\"Order\":1,\"MediaObjectID\":\"1\",\"ImageWidth\":1022,\"ImageHeight\":676,\"ImageSizeDescription\":\"1022x676\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7792488/ea743d1b-bf9b-445a-a1b8-a6dbdfacee72.png\",\"MediaModificationTimestamp\":\"2025-08-23T14:08:11.663Z\",\"MediaKey\":\"68a9cb4b00bfef0857e2a8cb\"},{\"ResourceRecordKey\":\"NST7792488\",\"Order\":2,\"MediaObjectID\":\"2\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7792488/c6596e89-b99b-4b70-adef-6893d353c808.jpeg\",\"MediaModificationTimestamp\":\"2025-08-23T14:15:26.296Z\",\"MediaKey\":\"68a9ccff71eba26c1761af90\"},{\"ResourceRecordKey\":\"NST7792488\",\"Order\":3,\"MediaObjectID\":\"3\",\"ImageWidth\":1018,\"ImageHeight\":673,\"ImageSizeDescription\":\"1018x673\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7792488/f3f66167-8275-4803-a713-781d39a3a14e.png\",\"MediaModificationTimestamp\":\"2025-08-23T14:15:26.362Z\",\"MediaKey\":\"68a9ccff71eba26c1761af91\"},{\"ResourceRecordKey\":\"NST7792488\",\"Order\":4,\"MediaObjectID\":\"4\",\"ImageWidth\":1019,\"ImageHeight\":675,\"ImageSizeDescription\":\"1019x675\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7792488/6885ef88-6a75-4152-999b-ebc63bf10449.png\",\"MediaModificationTimestamp\":\"2025-08-23T14:15:26.354Z\",\"MediaKey\":\"68a9ccff71eba26c1761af92\"},{\"ResourceRecordKey\":\"NST7792488\",\"Order\":5,\"MediaObjectID\":\"5\",\"ImageWidth\":1015,\"ImageHeight\":674,\"ImageSizeDescription\":\"1015x674\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7792488/f67382fe-6060-4896-91c9-d572afa4dcb0.png\",\"MediaModificationTimestamp\":\"2025-08-23T14:15:26.324Z\",\"MediaKey\":\"68a9ccff71eba26c1761af93\"},{\"ResourceRecordKey\":\"NST7792488\",\"Order\":6,\"MediaObjectID\":\"6\",\"ImageWidth\":1019,\"ImageHeight\":673,\"ImageSizeDescription\":\"1019x673\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7792488/f8de7fd2-a1f3-40ff-8829-3cf3c98290f7.png\",\"MediaModificationTimestamp\":\"2025-08-23T14:15:26.353Z\",\"MediaKey\":\"68a9ccff71eba26c1761af94\"},{\"ResourceRecordKey\":\"NST7792488\",\"Order\":7,\"MediaObjectID\":\"7\",\"ImageWidth\":1019,\"ImageHeight\":673,\"ImageSizeDescription\":\"1019x673\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7792488/833e3ce4-3b40-48ef-b8df-b3d1eb7a6313.png\",\"MediaModificationTimestamp\":\"2025-08-23T14:15:26.336Z\",\"MediaKey\":\"68a9ccff71eba26c1761af95\"},{\"ResourceRecordKey\":\"NST7792488\",\"Order\":8,\"MediaObjectID\":\"8\",\"ImageWidth\":1018,\"ImageHeight\":670,\"ImageSizeDescription\":\"1018x670\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7792488/8f6ca14b-47bd-4d58-84bc-5acd8017b484.png\",\"MediaModificationTimestamp\":\"2025-08-23T14:15:26.338Z\",\"MediaKey\":\"68a9ccff71eba26c1761af96\"},{\"ResourceRecordKey\":\"NST7792488\",\"Order\":9,\"MediaObjectID\":\"9\",\"ImageWidth\":1015,\"ImageHeight\":671,\"ImageSizeDescription\":\"1015x671\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7792488/112bd263-7aa7-465e-8673-888576e834f9.png\",\"MediaModificationTimestamp\":\"2025-08-23T14:15:26.318Z\",\"MediaKey\":\"68a9ccff71eba26c1761af97\"},{\"ResourceRecordKey\":\"NST7792488\",\"Order\":10,\"MediaObjectID\":\"10\",\"ImageWidth\":1017,\"ImageHeight\":674,\"ImageSizeDescription\":\"1017x674\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7792488/cfd7a4f9-8fa9-4062-9ed6-219c504ff79f.png\",\"MediaModificationTimestamp\":\"2025-08-23T14:15:26.348Z\",\"MediaKey\":\"68a9ccff71eba26c1761af98\"},{\"ResourceRecordKey\":\"NST7792488\",\"Order\":11,\"MediaObjectID\":\"11\",\"ImageWidth\":1017,\"ImageHeight\":673,\"ImageSizeDescription\":\"1017x673\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7792488/372651e1-1ede-430f-a14f-f95408bc5603.png\",\"MediaModificationTimestamp\":\"2025-08-23T14:15:27.347Z\",\"MediaKey\":\"68a9ccff71eba26c1761af99\"},{\"ResourceRecordKey\":\"NST7792488\",\"Order\":12,\"MediaObjectID\":\"12\",\"ImageWidth\":1018,\"ImageHeight\":672,\"ImageSizeDescription\":\"1018x672\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7792488/6121aaaa-4ec9-4af8-aa14-2396c6b337d4.png\",\"MediaModificationTimestamp\":\"2025-08-23T14:15:26.361Z\",\"MediaKey\":\"68a9ccff71eba26c1761af9a\"},{\"ResourceRecordKey\":\"NST7792488\",\"Order\":13,\"MediaObjectID\":\"13\",\"ImageWidth\":1017,\"ImageHeight\":675,\"ImageSizeDescription\":\"1017x675\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7792488/035a9b4f-336b-417b-8879-72b7ac319676.png\",\"MediaModificationTimestamp\":\"2025-08-23T14:15:26.403Z\",\"MediaKey\":\"68a9ccff71eba26c1761af9b\"},{\"ResourceRecordKey\":\"NST7792488\",\"Order\":14,\"MediaObjectID\":\"14\",\"ImageWidth\":1017,\"ImageHeight\":673,\"ImageSizeDescription\":\"1017x673\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7792488/692ee69a-b13f-44ce-af41-01e116c25d8d.png\",\"MediaModificationTimestamp\":\"2025-08-23T14:15:26.322Z\",\"MediaKey\":\"68a9ccff71eba26c1761af9c\"},{\"ResourceRecordKey\":\"NST7792488\",\"Order\":15,\"MediaObjectID\":\"15\",\"ImageWidth\":1016,\"ImageHeight\":671,\"ImageSizeDescription\":\"1016x671\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7792488/6d7d50e7-c398-446f-b183-6c049b14ef01.png\",\"MediaModificationTimestamp\":\"2025-08-23T14:15:26.379Z\",\"MediaKey\":\"68a9ccff71eba26c1761af9d\"},{\"ResourceRecordKey\":\"NST7792488\",\"Order\":16,\"MediaObjectID\":\"16\",\"ImageWidth\":1016,\"ImageHeight\":672,\"ImageSizeDescription\":\"1016x672\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7792488/ef664e42-790c-4677-b274-95a40017235e.png\",\"MediaModificationTimestamp\":\"2025-08-23T14:15:26.401Z\",\"MediaKey\":\"68a9ccff71eba26c1761af9e\"},{\"ResourceRecordKey\":\"NST7792488\",\"Order\":17,\"MediaObjectID\":\"17\",\"ImageWidth\":1010,\"ImageHeight\":757,\"ImageSizeDescription\":\"1010x757\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7792488/d551b6aa-6a48-4b62-a545-ae7ab61582c9.png\",\"MediaModificationTimestamp\":\"2025-08-23T14:15:26.295Z\",\"MediaKey\":\"68a9ccff71eba26c1761af9f\"}]","Rooms":"[{\"RoomKey\":\"NST115546075\",\"RoomType\":\"Living Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"19x15\",\"NST_RoomSortOrder\":\"1\"},{\"RoomKey\":\"NST115546076\",\"RoomType\":\"Dining Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"19x16\",\"NST_RoomSortOrder\":\"2\"},{\"RoomKey\":\"NST115546077\",\"RoomType\":\"Family Room\",\"RoomLevel\":\"Basement\",\"RoomDimensions\":\"24x16\",\"NST_RoomSortOrder\":\"3\"},{\"RoomKey\":\"NST115546078\",\"RoomType\":\"Kitchen\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"15x15\",\"NST_RoomSortOrder\":\"4\"},{\"RoomKey\":\"NST115546079\",\"RoomType\":\"Bedroom 1\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"17x15\",\"NST_RoomSortOrder\":\"5\"},{\"RoomKey\":\"NST115546080\",\"RoomType\":\"Bedroom 2\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"13x12\",\"NST_RoomSortOrder\":\"6\"},{\"RoomKey\":\"NST115546081\",\"RoomType\":\"Bedroom 3\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"13x11\",\"NST_RoomSortOrder\":\"7\"},{\"RoomKey\":\"NST115546082\",\"RoomType\":\"Bedroom 4\",\"RoomLevel\":\"Basement\",\"RoomDimensions\":\"14x12\",\"NST_RoomSortOrder\":\"8\"},{\"RoomKey\":\"NST115546083\",\"RoomType\":\"Screened Porch\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"14x13\",\"NST_RoomSortOrder\":\"9\"},{\"RoomKey\":\"NST115546084\",\"RoomType\":\"Recreation Room\",\"RoomLevel\":\"Basement\",\"RoomDimensions\":\"28x15\",\"NST_RoomSortOrder\":\"10\"}]","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17","CustomVTourURL":""}