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":1402287,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST6780910","MLSAGENTID":"NST506011143","MLSOFFICEID":"NST5116","ADDRESS":"226 Mayfair Road","ACRES":0.15,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"None","BATHSTOTAL":2.0,"BEDROOMS":3,"CITY":"Vadnais Heights","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Aluminum Siding","FORECLOSURE":"No","LASTPRICE":125000.0,"LASTPRICEDATE":"2025-08-30T17:12:03.753","LATITUDE":45.04402965,"LENDEROWNED":"No","LISTDATE":"2025-08-30T05:00:00","LISTPRICE":125000.0,"LIVINGAREA":1200.0,"LONGITUDE":-93.09510534,"MODIFICATIONTIMESTAMP":"2025-08-31T10:03:04.286","OFFICE_OFFICENAME":"Coldwell Banker Realty","PHOTOCOUNT":28,"POSTALCODE":"55127","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Welcome to the beautifully maintained 3-bedroom, 2-bath manufactured home offering 1200 sqft of comfortable, single-level living in the heart of Vadnais Heights. Nestled in a quiet well-kept community, this home is perfect for anyone looking for affordability without sacrificing space or convenience. Step inside to find an open-concept living area filled with natural light, a spacious kitchen with ample cabinetry and counter space, and a cozy dining area ideal for gatherings. The primary suite features a private full bath and generous closet space, while two additional bedrooms provide flexibility for guests or home office. Other highlights include in-unit laundry, central air conditioning, and a private driveway. Outside, enjoy a small yard space- perfect for a garden or patio set- and nearby access to parks, shopping, dining, and major highways. Whether you're a first time buyer, downsizing, or looking for a low-maintenance home in a great location, this one is a must see!","ROADBETWEENWATERFRONTANDHOMEYN":false,"SCHOOLDISTRICTNUMBER":"624-White Bear Lake","SCHOOLDISTRICTPHONE":"651-407-7500","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2025-08-30T17:12:03.753","LASTSTATUS":"Active","STREETNAME":"Mayfair","STREETNUMBER":"226","STREETSUFFIX":"Road","STYLE":"Single Family Residence","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":2010,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2025-08-31T02:53:05.273","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28","SOURCE":"MG_NST"}
{"ListingKey":"NST7795641","LotSizeArea":"0.15","NST_AgeOfProperty":"15","NST_AgentOwner":"No","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"False","NST_AmenitiesUnit":"Main Floor Primary Bedroom","Appliances":"Dishwasher,Dryer,Range,Refrigerator,Washer","NST_AssessmentPending":"No","AssociationFeeIncludes":"Other","AssociationFeeFrequency":"Monthly","AssociationYN":"True","AssociationFee":"800","AssociationName":"Five Star Mobile Estates","AssociationPhone":"651-615-2527","PropertyAttachedYN":"False","NST_AttributionContact":"651-262-3933","NST_AttributionName":"Chauncy Williams-Barefield","Basement":"None","BasementYN":"False","BathroomsOneQuarter":"0","BathroomsFull":"2","BathroomsHalf":"0","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"2","BedroomsTotal":"3","City":"Vadnais Heights","PropertyType":"Residential","NewConstructionYN":"False","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Ramsey","NST_DPResource":"Y","DaysOnMarket":"1","CumulativeDaysOnMarket":"1","Directions":"Twin Lake Blvd to Mayfair Rd., stay on Mayfair Rd to HOME","InternetAddressDisplayYN":"True","InternetEntireListingDisplayYN":"True","ConstructionMaterials":"Aluminum Siding","Fencing":"None","FireplaceYN":"False","FireplacesTotal":"0","NST_ForeclosureStatus":"No","FoundationArea":"1200","NST_FractionalOwnershipYN":"No","RoadFrontageType":"City Street","NST_Fuel":"Natural Gas","ParkingFeatures":"Open","AccessibilityFeatures":"No Stairs External","Heating":"Forced Air","OriginalEntryTimestamp":"2025-08-30T17:08:57Z","NST_InternetOptions":"Cable","LandLeaseYN":"False","NST_LastUpdateDate":"2025-08-31","Latitude":"45.0440296526","NST_LenderOwned":"No","ListAgentKey":"NST100990","ListAgentMlsId":"NST506011143","ListingContractDate":"2025-08-30T05:00:00Z","ListOfficeKey":"NST16638","ListOfficeName":"Coldwell Banker Realty","ListOfficeMlsId":"NST5116","ListPrice":"125000","LivingArea":"1200","Longitude":"-93.0951053386","LotSizeDimensions":"52x128","LotSizeSquareFeet":"6534","LotSizeUnits":"Acres","ListingId":"NST6780910","SourceSystemName":"RMLS","NST_ManufacturedHome":"Yes","MapCoordinateSource":"King's Street Atlas","AdditionalParcelsYN":"False","NST_OfficeBoard":"MAAR","ParcelNumber":"1789M01380","GarageSpaces":"0","PhotosCount":"28","PostalCity":"Vadnais Heights","PostalCode":"55127","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PublicRemarks":"Welcome to the beautifully maintained 3-bedroom, 2-bath manufactured home offering 1200 sqft of comfortable, single-level living in the heart of Vadnais Heights. Nestled in a quiet well-kept community, this home is perfect for anyone looking for affordability without sacrificing space or convenience. Step inside to find an open-concept living area filled with natural light, a spacious kitchen with ample cabinetry and counter space, and a cozy dining area ideal for gatherings. The primary suite features a private full bath and generous closet space, while two additional bedrooms provide flexibility for guests or home office. Other highlights include in-unit laundry, central air conditioning, and a private driveway. Outside, enjoy a small yard space- perfect for a garden or patio set- and nearby access to parks, shopping, dining, and major highways. Whether you're a first time buyer, downsizing, or looking for a low-maintenance home in a great location, this one is a must see!","NST_RentalLicenseYN":"No","NST_AboveGradeSqFtTotal":"1200.0000","NST_BelowGradeSqFtTotal":"0.0000","NST_MainLevelFinishedArea":"1200.0000","BuildingAreaTotal":"1200","HighSchoolDistrict":"White Bear Lake","NST_SchoolDistrictNumber":"624","NST_SchoolDistrictPhone":"651-407-7500","Sewer":"City Sewer/Connected","NST_SpecialSearch":"3 BR on One Level,All Living Facilities on One Level,Main Floor Bedroom,Main Floor Laundry","AboveGradeFinishedArea":"1200","BelowGradeFinishedArea":"0","StateOrProvince":"MN","StandardStatus":"Active","Levels":"One","StreetName":"Mayfair","StreetNumber":"226","StreetNumberNumeric":"226","StreetSuffix":"Road","PropertySubType":"Single Family Residence","NST_TaxWithAssessments":"408.0000","TaxYear":"2025","TaxAnnualAmount":"408","WaterSource":"City Water/Connected","YearBuilt":"2010","ZoningDescription":"Residential-Single Family","ModificationTimestamp":"2025-08-31T10:03:04.286Z","PhotosChangeTimestamp":"2025-08-31T02:53:05.273Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7795641\",\"Order\":1,\"MediaObjectID\":\"1\",\"ImageWidth\":1920,\"ImageHeight\":1278,\"ImageSizeDescription\":\"1920x1278\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7795641/9e753c99-7077-4874-a349-2d4f224db2ad.jpeg\",\"MediaModificationTimestamp\":\"2025-08-31T02:52:30.877Z\",\"MediaKey\":\"68b3b8eee890c416ba03e7a0\"},{\"ResourceRecordKey\":\"NST7795641\",\"Order\":2,\"MediaObjectID\":\"2\",\"ImageWidth\":1920,\"ImageHeight\":1278,\"ImageSizeDescription\":\"1920x1278\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7795641/111bfdf9-da33-43c2-862c-35c53a949768.jpeg\",\"MediaModificationTimestamp\":\"2025-08-31T02:52:30.886Z\",\"MediaKey\":\"68b3b8eee890c416ba03e7a1\"},{\"ResourceRecordKey\":\"NST7795641\",\"Order\":3,\"MediaObjectID\":\"3\",\"ImageWidth\":1920,\"ImageHeight\":1278,\"ImageSizeDescription\":\"1920x1278\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7795641/18166f7e-d333-4330-8fe8-a61c2f345e98.jpeg\",\"MediaModificationTimestamp\":\"2025-08-31T02:52:30.89Z\",\"MediaKey\":\"68b3b8eee890c416ba03e7a2\"},{\"ResourceRecordKey\":\"NST7795641\",\"Order\":4,\"MediaObjectID\":\"4\",\"ImageWidth\":1920,\"ImageHeight\":1278,\"ImageSizeDescription\":\"1920x1278\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7795641/e1359fd2-2771-4607-bbce-9f558b372b47.jpeg\",\"MediaModificationTimestamp\":\"2025-08-31T02:52:30.89Z\",\"MediaKey\":\"68b3b8eee890c416ba03e7a3\"},{\"ResourceRecordKey\":\"NST7795641\",\"Order\":5,\"MediaObjectID\":\"5\",\"ImageWidth\":1920,\"ImageHeight\":1278,\"ImageSizeDescription\":\"1920x1278\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7795641/5f1c6c75-e245-4cd8-870b-37c70648b8fc.jpeg\",\"MediaModificationTimestamp\":\"2025-08-31T02:52:30.823Z\",\"MediaKey\":\"68b3b8eee890c416ba03e7a4\"},{\"ResourceRecordKey\":\"NST7795641\",\"Order\":6,\"MediaObjectID\":\"6\",\"ImageWidth\":1920,\"ImageHeight\":1278,\"ImageSizeDescription\":\"1920x1278\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7795641/201f8916-35e2-4b3c-9ef6-d2a6c3663520.jpeg\",\"MediaModificationTimestamp\":\"2025-08-31T02:52:30.823Z\",\"MediaKey\":\"68b3b8eee890c416ba03e7a5\"},{\"ResourceRecordKey\":\"NST7795641\",\"Order\":7,\"MediaObjectID\":\"7\",\"ImageWidth\":1920,\"ImageHeight\":1278,\"ImageSizeDescription\":\"1920x1278\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7795641/d7a87911-295c-4c80-ab43-762e5ec9ec90.jpeg\",\"MediaModificationTimestamp\":\"2025-08-31T02:52:30.823Z\",\"MediaKey\":\"68b3b8eee890c416ba03e7a6\"},{\"ResourceRecordKey\":\"NST7795641\",\"Order\":8,\"MediaObjectID\":\"8\",\"ImageWidth\":1920,\"ImageHeight\":1278,\"ImageSizeDescription\":\"1920x1278\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7795641/c4a6ea6a-78d3-43a5-8d04-7cbd257dd391.jpeg\",\"MediaModificationTimestamp\":\"2025-08-31T02:52:30.823Z\",\"MediaKey\":\"68b3b8eee890c416ba03e7a7\"},{\"ResourceRecordKey\":\"NST7795641\",\"Order\":9,\"MediaObjectID\":\"9\",\"ImageWidth\":1920,\"ImageHeight\":1278,\"ImageSizeDescription\":\"1920x1278\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7795641/4a9c1af1-1588-47b8-9850-3059f6947360.jpeg\",\"MediaModificationTimestamp\":\"2025-08-31T02:52:30.84Z\",\"MediaKey\":\"68b3b8eee890c416ba03e7a8\"},{\"ResourceRecordKey\":\"NST7795641\",\"Order\":10,\"MediaObjectID\":\"10\",\"ImageWidth\":1920,\"ImageHeight\":1278,\"ImageSizeDescription\":\"1920x1278\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7795641/2b4d41ea-2e4c-4f28-b8ef-92740065a8ad.jpeg\",\"MediaModificationTimestamp\":\"2025-08-31T02:52:30.876Z\",\"MediaKey\":\"68b3b8eee890c416ba03e7a9\"},{\"ResourceRecordKey\":\"NST7795641\",\"Order\":11,\"MediaObjectID\":\"11\",\"ImageWidth\":1920,\"ImageHeight\":1276,\"ImageSizeDescription\":\"1920x1276\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7795641/2cefb653-3116-476a-a328-fe9df049538b.jpeg\",\"MediaModificationTimestamp\":\"2025-08-31T02:52:30.848Z\",\"MediaKey\":\"68b3b8eee890c416ba03e7aa\"},{\"ResourceRecordKey\":\"NST7795641\",\"Order\":12,\"MediaObjectID\":\"12\",\"ImageWidth\":1920,\"ImageHeight\":1278,\"ImageSizeDescription\":\"1920x1278\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7795641/2921aed6-bdf1-43d1-a4a5-48ca83743b82.jpeg\",\"MediaModificationTimestamp\":\"2025-08-31T02:52:30.84Z\",\"MediaKey\":\"68b3b8eee890c416ba03e7ab\"},{\"ResourceRecordKey\":\"NST7795641\",\"Order\":13,\"MediaObjectID\":\"13\",\"ImageWidth\":1920,\"ImageHeight\":1278,\"ImageSizeDescription\":\"1920x1278\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7795641/cce54036-6c40-42a3-8f1d-472447bd11ae.jpeg\",\"MediaModificationTimestamp\":\"2025-08-31T02:52:30.823Z\",\"MediaKey\":\"68b3b8eee890c416ba03e7ac\"},{\"ResourceRecordKey\":\"NST7795641\",\"Order\":14,\"MediaObjectID\":\"14\",\"ImageWidth\":1920,\"ImageHeight\":1278,\"ImageSizeDescription\":\"1920x1278\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7795641/5dcd7ada-77c8-4729-8161-c18334db4072.jpeg\",\"MediaModificationTimestamp\":\"2025-08-31T02:52:30.848Z\",\"MediaKey\":\"68b3b8eee890c416ba03e7ad\"},{\"ResourceRecordKey\":\"NST7795641\",\"Order\":15,\"MediaObjectID\":\"15\",\"ImageWidth\":1920,\"ImageHeight\":1278,\"ImageSizeDescription\":\"1920x1278\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7795641/0ec906f7-9999-4705-9fae-adf6e5e60c46.jpeg\",\"MediaModificationTimestamp\":\"2025-08-31T02:52:30.79Z\",\"MediaKey\":\"68b3b8eee890c416ba03e7ae\"},{\"ResourceRecordKey\":\"NST7795641\",\"Order\":16,\"MediaObjectID\":\"16\",\"ImageWidth\":1920,\"ImageHeight\":1276,\"ImageSizeDescription\":\"1920x1276\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7795641/d104a82d-e03d-46fa-b930-c47774f32d14.jpeg\",\"MediaModificationTimestamp\":\"2025-08-31T02:52:30.84Z\",\"MediaKey\":\"68b3b8eee890c416ba03e7af\"},{\"ResourceRecordKey\":\"NST7795641\",\"Order\":17,\"MediaObjectID\":\"17\",\"ImageWidth\":1920,\"ImageHeight\":1276,\"ImageSizeDescription\":\"1920x1276\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7795641/9403983b-ee9c-43ca-987b-f44a75e23372.jpeg\",\"MediaModificationTimestamp\":\"2025-08-31T02:52:30.84Z\",\"MediaKey\":\"68b3b8eee890c416ba03e7b0\"},{\"ResourceRecordKey\":\"NST7795641\",\"Order\":18,\"MediaObjectID\":\"18\",\"ImageWidth\":1920,\"ImageHeight\":1278,\"ImageSizeDescription\":\"1920x1278\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7795641/0bb4bb11-bd73-45a2-a76f-8a9931057463.jpeg\",\"MediaModificationTimestamp\":\"2025-08-31T02:52:30.79Z\",\"MediaKey\":\"68b3b8eee890c416ba03e7b1\"},{\"ResourceRecordKey\":\"NST7795641\",\"Order\":19,\"MediaObjectID\":\"19\",\"ImageWidth\":1920,\"ImageHeight\":1278,\"ImageSizeDescription\":\"1920x1278\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7795641/edbc37d9-d2d3-45e9-af71-7f4a0d6e424f.jpeg\",\"MediaModificationTimestamp\":\"2025-08-31T02:52:30.84Z\",\"MediaKey\":\"68b3b8eee890c416ba03e7b2\"},{\"ResourceRecordKey\":\"NST7795641\",\"Order\":20,\"MediaObjectID\":\"20\",\"ImageWidth\":1920,\"ImageHeight\":1278,\"ImageSizeDescription\":\"1920x1278\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7795641/17d1cb70-52dc-4507-a69d-e9bd31e0124c.jpeg\",\"MediaModificationTimestamp\":\"2025-08-31T02:52:30.84Z\",\"MediaKey\":\"68b3b8eee890c416ba03e7b3\"},{\"ResourceRecordKey\":\"NST7795641\",\"Order\":21,\"MediaObjectID\":\"21\",\"ImageWidth\":1920,\"ImageHeight\":1278,\"ImageSizeDescription\":\"1920x1278\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7795641/11554f16-150e-4a6a-8132-ffe77c7fd2f5.jpeg\",\"MediaModificationTimestamp\":\"2025-08-31T02:52:30.823Z\",\"MediaKey\":\"68b3b8eee890c416ba03e7b4\"},{\"ResourceRecordKey\":\"NST7795641\",\"Order\":22,\"MediaObjectID\":\"22\",\"ImageWidth\":1920,\"ImageHeight\":1278,\"ImageSizeDescription\":\"1920x1278\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7795641/1aace224-b732-46c8-ba59-78959952dd46.jpeg\",\"MediaModificationTimestamp\":\"2025-08-31T02:52:30.848Z\",\"MediaKey\":\"68b3b8eee890c416ba03e7b5\"},{\"ResourceRecordKey\":\"NST7795641\",\"Order\":23,\"MediaObjectID\":\"23\",\"ImageWidth\":1920,\"ImageHeight\":1276,\"ImageSizeDescription\":\"1920x1276\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7795641/8a5a86bd-8898-4e4e-ae43-d018b0d3a819.jpeg\",\"MediaModificationTimestamp\":\"2025-08-31T02:52:30.823Z\",\"MediaKey\":\"68b3b8eee890c416ba03e7b6\"},{\"ResourceRecordKey\":\"NST7795641\",\"Order\":24,\"MediaObjectID\":\"24\",\"ImageWidth\":1920,\"ImageHeight\":1278,\"ImageSizeDescription\":\"1920x1278\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7795641/64e5483e-f992-4c43-b6bd-67dd660f569b.jpeg\",\"MediaModificationTimestamp\":\"2025-08-31T02:52:30.823Z\",\"MediaKey\":\"68b3b8eee890c416ba03e7b7\"},{\"ResourceRecordKey\":\"NST7795641\",\"Order\":25,\"MediaObjectID\":\"25\",\"ImageWidth\":1920,\"ImageHeight\":1278,\"ImageSizeDescription\":\"1920x1278\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7795641/61db4efd-f6f3-48c5-aa43-9f8b0bc007e5.jpeg\",\"MediaModificationTimestamp\":\"2025-08-31T02:52:30.918Z\",\"MediaKey\":\"68b3b8eee890c416ba03e7b8\"},{\"ResourceRecordKey\":\"NST7795641\",\"Order\":26,\"MediaObjectID\":\"26\",\"ImageWidth\":1920,\"ImageHeight\":1278,\"ImageSizeDescription\":\"1920x1278\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7795641/7938a8a2-dd22-420b-ae17-ee77c17fcec5.jpeg\",\"MediaModificationTimestamp\":\"2025-08-31T02:52:30.89Z\",\"MediaKey\":\"68b3b8eee890c416ba03e7b9\"},{\"ResourceRecordKey\":\"NST7795641\",\"Order\":27,\"MediaObjectID\":\"27\",\"ImageWidth\":1920,\"ImageHeight\":1278,\"ImageSizeDescription\":\"1920x1278\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7795641/ca2161f0-a9ce-4607-a209-bd20b84f4777.jpeg\",\"MediaModificationTimestamp\":\"2025-08-31T02:52:30.907Z\",\"MediaKey\":\"68b3b8eee890c416ba03e7ba\"},{\"ResourceRecordKey\":\"NST7795641\",\"Order\":28,\"MediaObjectID\":\"28\",\"ImageWidth\":1920,\"ImageHeight\":1278,\"ImageSizeDescription\":\"1920x1278\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7795641/6c06ac79-d080-4182-bac7-0426512b0a5c.jpeg\",\"MediaModificationTimestamp\":\"2025-08-31T02:52:30.926Z\",\"MediaKey\":\"68b3b8eee890c416ba03e7bb\"}]","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28","CustomVTourURL":""}