{"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-09-25T19:47:03.453","LATITUDE":45.04402965,"LENDEROWNED":"No","LISTDATE":"2025-08-30T05:00:00","LISTPRICE":120000.0,"LIVINGAREA":1200.0,"LONGITUDE":-93.09510534,"MODIFICATIONTIMESTAMP":"2025-09-25T19:47:03.453","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-09-14T02:32:03.98","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":"765","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":"26","CumulativeDaysOnMarket":"26","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-09-25","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":"120000","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-09-25T19:47:03.453Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7795641\",\"Order\":1,\"MediaObjectID\":\"1\",\"ImageWidth\":1920,\"ImageHeight\":1278,\"ImageSizeDescription\":\"1920x1278\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7795641/f547d748-5ecb-4594-88f6-99ac27b51a6f.jpeg\",\"MediaModificationTimestamp\":\"2025-09-14T02:31:39.372Z\",\"MediaKey\":\"68c6290b32ecd94c5089b8e7\"},{\"ResourceRecordKey\":\"NST7795641\",\"Order\":2,\"MediaObjectID\":\"2\",\"ImageWidth\":1920,\"ImageHeight\":1278,\"ImageSizeDescription\":\"1920x1278\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7795641/7a6d173a-5dc5-4dca-9b9f-986eec6eaf1f.jpeg\",\"MediaModificationTimestamp\":\"2025-09-14T02:31:39.386Z\",\"MediaKey\":\"68c6290b32ecd94c5089b8e8\"},{\"ResourceRecordKey\":\"NST7795641\",\"Order\":3,\"MediaObjectID\":\"3\",\"ImageWidth\":1920,\"ImageHeight\":1278,\"ImageSizeDescription\":\"1920x1278\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7795641/a902a9e5-20dd-49b1-a62e-978d56cd22cd.jpeg\",\"MediaModificationTimestamp\":\"2025-09-14T02:31:39.386Z\",\"MediaKey\":\"68c6290b32ecd94c5089b8e9\"},{\"ResourceRecordKey\":\"NST7795641\",\"Order\":4,\"MediaObjectID\":\"4\",\"ImageWidth\":1920,\"ImageHeight\":1278,\"ImageSizeDescription\":\"1920x1278\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7795641/5cbe17de-4a3c-415e-afec-f79c80a12c43.jpeg\",\"MediaModificationTimestamp\":\"2025-09-14T02:31:39.487Z\",\"MediaKey\":\"68c6290b32ecd94c5089b8ea\"},{\"ResourceRecordKey\":\"NST7795641\",\"Order\":5,\"MediaObjectID\":\"5\",\"ImageWidth\":1920,\"ImageHeight\":1278,\"ImageSizeDescription\":\"1920x1278\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7795641/f31cdec5-66fe-42c6-9364-1f75d524c0ea.jpeg\",\"MediaModificationTimestamp\":\"2025-09-14T02:31:39.447Z\",\"MediaKey\":\"68c6290b32ecd94c5089b8eb\"},{\"ResourceRecordKey\":\"NST7795641\",\"Order\":6,\"MediaObjectID\":\"6\",\"ImageWidth\":1920,\"ImageHeight\":1278,\"ImageSizeDescription\":\"1920x1278\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7795641/187ed3e6-64fe-4a7f-8c24-7316078e71ed.jpeg\",\"MediaModificationTimestamp\":\"2025-09-14T02:31:39.386Z\",\"MediaKey\":\"68c6290b32ecd94c5089b8ec\"},{\"ResourceRecordKey\":\"NST7795641\",\"Order\":7,\"MediaObjectID\":\"7\",\"ImageWidth\":1920,\"ImageHeight\":1278,\"ImageSizeDescription\":\"1920x1278\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7795641/90629ded-8c8a-472b-a40b-dc0f10e7619b.jpeg\",\"MediaModificationTimestamp\":\"2025-09-14T02:31:39.337Z\",\"MediaKey\":\"68c6290b32ecd94c5089b8ed\"},{\"ResourceRecordKey\":\"NST7795641\",\"Order\":8,\"MediaObjectID\":\"8\",\"ImageWidth\":1920,\"ImageHeight\":1278,\"ImageSizeDescription\":\"1920x1278\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7795641/676ad363-9c56-4e1a-96c1-0fc2c3fea3ec.jpeg\",\"MediaModificationTimestamp\":\"2025-09-14T02:31:39.372Z\",\"MediaKey\":\"68c6290b32ecd94c5089b8ee\"},{\"ResourceRecordKey\":\"NST7795641\",\"Order\":9,\"MediaObjectID\":\"9\",\"ImageWidth\":1920,\"ImageHeight\":1278,\"ImageSizeDescription\":\"1920x1278\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7795641/e225b364-ded9-467c-bdb1-940f92f8a0d1.jpeg\",\"MediaModificationTimestamp\":\"2025-09-14T02:31:39.386Z\",\"MediaKey\":\"68c6290b32ecd94c5089b8ef\"},{\"ResourceRecordKey\":\"NST7795641\",\"Order\":10,\"MediaObjectID\":\"10\",\"ImageWidth\":1920,\"ImageHeight\":1278,\"ImageSizeDescription\":\"1920x1278\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7795641/f9a85664-f46e-48af-8cd2-163b4acf32c4.jpeg\",\"MediaModificationTimestamp\":\"2025-09-14T02:31:39.386Z\",\"MediaKey\":\"68c6290b32ecd94c5089b8f0\"},{\"ResourceRecordKey\":\"NST7795641\",\"Order\":11,\"MediaObjectID\":\"11\",\"ImageWidth\":1920,\"ImageHeight\":1276,\"ImageSizeDescription\":\"1920x1276\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7795641/bf0bacac-5bc9-418a-b06e-3ac0afa1e3d0.jpeg\",\"MediaModificationTimestamp\":\"2025-09-14T02:31:39.401Z\",\"MediaKey\":\"68c6290b32ecd94c5089b8f1\"},{\"ResourceRecordKey\":\"NST7795641\",\"Order\":12,\"MediaObjectID\":\"12\",\"ImageWidth\":1920,\"ImageHeight\":1278,\"ImageSizeDescription\":\"1920x1278\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7795641/3a5476ef-2a71-4d76-b5eb-56dd03a18745.jpeg\",\"MediaModificationTimestamp\":\"2025-09-14T02:31:39.372Z\",\"MediaKey\":\"68c6290b32ecd94c5089b8f2\"},{\"ResourceRecordKey\":\"NST7795641\",\"Order\":13,\"MediaObjectID\":\"13\",\"ImageWidth\":1920,\"ImageHeight\":1278,\"ImageSizeDescription\":\"1920x1278\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7795641/0208918f-4d01-481a-9764-5bbba6546cc6.jpeg\",\"MediaModificationTimestamp\":\"2025-09-14T02:31:39.384Z\",\"MediaKey\":\"68c6290b32ecd94c5089b8f3\"},{\"ResourceRecordKey\":\"NST7795641\",\"Order\":14,\"MediaObjectID\":\"14\",\"ImageWidth\":1920,\"ImageHeight\":1278,\"ImageSizeDescription\":\"1920x1278\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7795641/4bbeabb9-0dcc-4fe1-86ef-9814df52fb89.jpeg\",\"MediaModificationTimestamp\":\"2025-09-14T02:31:39.337Z\",\"MediaKey\":\"68c6290b32ecd94c5089b8f4\"},{\"ResourceRecordKey\":\"NST7795641\",\"Order\":15,\"MediaObjectID\":\"15\",\"ImageWidth\":1920,\"ImageHeight\":1278,\"ImageSizeDescription\":\"1920x1278\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7795641/d2ab31d5-509d-4698-8dc1-a425db750f91.jpeg\",\"MediaModificationTimestamp\":\"2025-09-14T02:31:39.342Z\",\"MediaKey\":\"68c6290b32ecd94c5089b8f5\"},{\"ResourceRecordKey\":\"NST7795641\",\"Order\":16,\"MediaObjectID\":\"16\",\"ImageWidth\":1920,\"ImageHeight\":1276,\"ImageSizeDescription\":\"1920x1276\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7795641/abd8bd8b-95e8-4c06-9315-b6015e8d7371.jpeg\",\"MediaModificationTimestamp\":\"2025-09-14T02:31:39.372Z\",\"MediaKey\":\"68c6290b32ecd94c5089b8f6\"},{\"ResourceRecordKey\":\"NST7795641\",\"Order\":17,\"MediaObjectID\":\"17\",\"ImageWidth\":1920,\"ImageHeight\":1276,\"ImageSizeDescription\":\"1920x1276\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7795641/9862fc93-c191-4554-85e1-e661faa011e8.jpeg\",\"MediaModificationTimestamp\":\"2025-09-14T02:31:39.372Z\",\"MediaKey\":\"68c6290b32ecd94c5089b8f7\"},{\"ResourceRecordKey\":\"NST7795641\",\"Order\":18,\"MediaObjectID\":\"18\",\"ImageWidth\":1920,\"ImageHeight\":1278,\"ImageSizeDescription\":\"1920x1278\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7795641/9a075435-85d7-4909-bf6e-68365d2c6650.jpeg\",\"MediaModificationTimestamp\":\"2025-09-14T02:31:39.318Z\",\"MediaKey\":\"68c6290b32ecd94c5089b8f8\"},{\"ResourceRecordKey\":\"NST7795641\",\"Order\":19,\"MediaObjectID\":\"19\",\"ImageWidth\":1920,\"ImageHeight\":1278,\"ImageSizeDescription\":\"1920x1278\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7795641/c44755d4-e1ac-4a8b-9190-f4dffaa4b021.jpeg\",\"MediaModificationTimestamp\":\"2025-09-14T02:31:39.356Z\",\"MediaKey\":\"68c6290b32ecd94c5089b8f9\"},{\"ResourceRecordKey\":\"NST7795641\",\"Order\":20,\"MediaObjectID\":\"20\",\"ImageWidth\":1920,\"ImageHeight\":1278,\"ImageSizeDescription\":\"1920x1278\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7795641/b861db49-e6be-411a-8387-8a2f10cc363f.jpeg\",\"MediaModificationTimestamp\":\"2025-09-14T02:31:39.358Z\",\"MediaKey\":\"68c6290b32ecd94c5089b8fa\"},{\"ResourceRecordKey\":\"NST7795641\",\"Order\":21,\"MediaObjectID\":\"21\",\"ImageWidth\":1920,\"ImageHeight\":1278,\"ImageSizeDescription\":\"1920x1278\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7795641/a32ceb42-e1c8-45e7-89cd-c8d63de56f88.jpeg\",\"MediaModificationTimestamp\":\"2025-09-14T02:31:39.353Z\",\"MediaKey\":\"68c6290b32ecd94c5089b8fb\"},{\"ResourceRecordKey\":\"NST7795641\",\"Order\":22,\"MediaObjectID\":\"22\",\"ImageWidth\":1920,\"ImageHeight\":1278,\"ImageSizeDescription\":\"1920x1278\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7795641/c1bd1b5f-8b2f-4623-b56b-16882c64087a.jpeg\",\"MediaModificationTimestamp\":\"2025-09-14T02:31:39.349Z\",\"MediaKey\":\"68c6290b32ecd94c5089b8fc\"},{\"ResourceRecordKey\":\"NST7795641\",\"Order\":23,\"MediaObjectID\":\"23\",\"ImageWidth\":1920,\"ImageHeight\":1276,\"ImageSizeDescription\":\"1920x1276\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7795641/b2cd303a-a1c9-4103-ba14-34cb22b591ff.jpeg\",\"MediaModificationTimestamp\":\"2025-09-14T02:31:39.327Z\",\"MediaKey\":\"68c6290b32ecd94c5089b8fd\"},{\"ResourceRecordKey\":\"NST7795641\",\"Order\":24,\"MediaObjectID\":\"24\",\"ImageWidth\":1920,\"ImageHeight\":1278,\"ImageSizeDescription\":\"1920x1278\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7795641/0a76a9bf-0c9f-4885-8b4f-30b64cf35a16.jpeg\",\"MediaModificationTimestamp\":\"2025-09-14T02:31:39.337Z\",\"MediaKey\":\"68c6290b32ecd94c5089b8fe\"},{\"ResourceRecordKey\":\"NST7795641\",\"Order\":25,\"MediaObjectID\":\"25\",\"ImageWidth\":1920,\"ImageHeight\":1278,\"ImageSizeDescription\":\"1920x1278\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7795641/e64971fa-eb2b-4349-973d-2f4959cccb0a.jpeg\",\"MediaModificationTimestamp\":\"2025-09-14T02:31:39.386Z\",\"MediaKey\":\"68c6290b32ecd94c5089b8ff\"},{\"ResourceRecordKey\":\"NST7795641\",\"Order\":26,\"MediaObjectID\":\"26\",\"ImageWidth\":1920,\"ImageHeight\":1278,\"ImageSizeDescription\":\"1920x1278\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7795641/0a1f27b3-5d77-4601-b983-74233a2e8e1b.jpeg\",\"MediaModificationTimestamp\":\"2025-09-14T02:31:39.372Z\",\"MediaKey\":\"68c6290b32ecd94c5089b900\"},{\"ResourceRecordKey\":\"NST7795641\",\"Order\":27,\"MediaObjectID\":\"27\",\"ImageWidth\":1920,\"ImageHeight\":1278,\"ImageSizeDescription\":\"1920x1278\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7795641/d93cabe0-4acd-4cca-9454-18a709d9cfb6.jpeg\",\"MediaModificationTimestamp\":\"2025-09-14T02:31:39.403Z\",\"MediaKey\":\"68c6290b32ecd94c5089b901\"},{\"ResourceRecordKey\":\"NST7795641\",\"Order\":28,\"MediaObjectID\":\"28\",\"ImageWidth\":1920,\"ImageHeight\":1278,\"ImageSizeDescription\":\"1920x1278\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7795641/94bafcc8-7006-4c11-acee-c66cbb1760e9.jpeg\",\"MediaModificationTimestamp\":\"2025-09-14T02:31:39.391Z\",\"MediaKey\":\"68c6290b32ecd94c5089b902\"}]","PhotosChangeTimestamp":"2025-09-14T02:32:03.98Z","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":""}