mike@minnesotarealestatesales.com
Phone: 218-821-4775
- About
- Pelican Lake
- Ossawinnamakee Lake
- Horseshoe Lake
- Advanced Search
- Daily Hotsheets
- Buyers
- Sellers
- Estimate Request
- Popular Listings
- Favorite Listings
- Pelican Lakes Association
- Conservation Club
- DNR Lake Information
Contact me here...
$STITLE$
$SCONTENT$
$LABEL$
$SCONTENT$
Vanrose Realty is the brokerage office representing the seller for this listing.
Copyright 2019, Regional Multiple Listing Service of Minnesota, Inc. all rights reserved. Information is deemed reliable but is not guaranteed.
The data relating to real estate for sale on this site comes in part from the broker reciprocity program of the Regional multiple Listing Service of Minnesota, Inc. real estate listings held by brokerage firms other than are marked with the Broker Reciprocity logo or the Broker reciprocity house icon and detailed information about them includes the names(s) of the listing brokers. Mike Stanwood Realtor/GRI is not a multiple Listing Service (MLS), nor does it offer MLS access. This website is a service of Mike Stanwood Realtor/GRI, a broker Participant of the Regional Multiple Listing Service of Minnesota, Inc.
Copyright 2019, Regional Multiple Listing Service of Minnesota, Inc. all rights reserved. Information is deemed reliable but is not guaranteed.
The data relating to real estate for sale on this site comes in part from the broker reciprocity program of the Regional multiple Listing Service of Minnesota, Inc. real estate listings held by brokerage firms other than are marked with the Broker Reciprocity logo or the Broker reciprocity house icon and detailed information about them includes the names(s) of the listing brokers. Mike Stanwood Realtor/GRI is not a multiple Listing Service (MLS), nor does it offer MLS access. This website is a service of Mike Stanwood Realtor/GRI, a broker Participant of the Regional Multiple Listing Service of Minnesota, Inc.
Nearby Listings in 10 Miles
{"Id":510275,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST7008453","MLSAGENTID":"NST506008837","MLSOFFICEID":"NST80164","ADDRESS":"2531 Mayfair Avenue","ACRES":0.229,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Finished","BATHSTOTAL":2.0,"BEDROOMS":3,"CITY":"White Bear Lake","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"FORECLOSURE":"No","LASTPRICE":424900.0,"LASTPRICEDATE":"2026-01-14T14:53:06.66","LATITUDE":45.053862,"LENDEROWNED":"No","LISTDATE":"2026-01-14T06:00:00","LISTPRICE":424900.0,"LIVINGAREA":2136.0,"LONGITUDE":-92.993626,"MODIFICATIONTIMESTAMP":"2026-01-14T18:09:08.562","OFFICE_OFFICENAME":"Vanrose Realty","PHOTOCOUNT":32,"POSTALCODE":"55110","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"If you've outgrown your place and are looking for more space, this could be your new home. Newly updated 4 bedroom 3 bathroom house near Matoska Elementary School. A couple things that this property has: 2 nice new tiled full bathrooms, a 27'x 17' Great room, new kitchen appliances, hard wood floors, Primary suite, and newly stained deck for entertaining. Agents verify the room measurements.","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Age Over 8 Years","SCHOOLDISTRICTNUMBER":"2099-White Bear Lake","SCHOOLDISTRICTPHONE":"6514077500","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2026-01-14T14:53:06.66","LASTSTATUS":"Active","STREETNAME":"Mayfair","STREETNUMBER":"2531","STREETSUFFIX":"Avenue","STYLE":"Single Family Residence","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1966,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2026-01-14T14:53:06.659","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"2531 Mayfair Ave White Bear-small-001-019-Front-666x444-72dpi - Copy.jpg\"},{\"Order\":2,\"Remarks\":\"2531 Mayfair Ave White Bear-small-002-003-Front-666x445-72dpi - Copy.jpg\"},{\"Order\":3,\"Remarks\":\"2531 Mayfair Ave White Bear-small-003-017-Front-666x444-72dpi - Copy.jpg\"},{\"Order\":4,\"Remarks\":\"2531 Mayfair Ave White Bear-small-004-010-Living Room-666x445-72dpi - Copy.jpg\"},{\"Order\":5,\"Remarks\":\"2531 Mayfair Ave White Bear-small-005-013-Living Room-666x444-72dpi - Copy.jpg\"},{\"Order\":6,\"Remarks\":\"2531 Mayfair Ave White Bear-small-006-025-Kitchen-666x444-72dpi - Copy.jpg\"},{\"Order\":7,\"Remarks\":\"2531 Mayfair Ave White Bear-small-007-006-Kitchen-666x444-72dpi - Copy.jpg\"},{\"Order\":8,\"Remarks\":\"2531 Mayfair Ave White Bear-small-008-009-Kitchen-666x444-72dpi - Copy.jpg\"},{\"Order\":9,\"Remarks\":\"2531 Mayfair Ave White Bear-small-009-032-Dining Room-666x444-72dpi - Copy.jpg\"},{\"Order\":10,\"Remarks\":\"2531 Mayfair Ave White Bear-small-010-004-Dining Room-666x444-72dpi - Copy.jpg\"},{\"Order\":11,\"Remarks\":\"2531 Mayfair Ave White Bear-small-011-029-Dining Room-666x444-72dpi - Copy.jpg\"},{\"Order\":12,\"Remarks\":\"2531 Mayfair Ave White Bear-small-012-007-Family Room-666x444-72dpi - Copy.jpg\"},{\"Order\":13,\"Remarks\":\"2531 Mayfair Ave White Bear-small-013-026-Family Room-666x444-72dpi - Copy.jpg\"},{\"Order\":14,\"Remarks\":\"2531 Mayfair Ave White Bear-small-014-033-Family Room-666x444-72dpi - Copy.jpg\"},{\"Order\":15,\"Remarks\":\"2531 Mayfair Ave White Bear-small-015-023-Entryway-666x444-72dpi - Copy.jpg\"},{\"Order\":16,\"Remarks\":\"2531 Mayfair Ave White Bear-small-016-028-Entryway-666x444-72dpi - Copy.jpg\"},{\"Order\":17,\"Remarks\":\"2531 Mayfair Ave White Bear-small-017-008-Bathroom-666x445-72dpi - Copy.jpg\"},{\"Order\":18,\"Remarks\":\"2531 Mayfair Ave White Bear-small-018-012-Bedroom-666x444-72dpi - Copy.jpg\"},{\"Order\":19,\"Remarks\":\"2531 Mayfair Ave White Bear-small-019-030-Bedroom-666x444-72dpi - Copy.jpg\"},{\"Order\":20,\"Remarks\":\"2531 Mayfair Ave White Bear-small-020-020-Bedroom-666x444-72dpi - Copy.jpg\"},{\"Order\":21,\"Remarks\":\"2531 Mayfair Ave White Bear-small-021-022-Bedroom-666x444-72dpi - Copy.jpg\"},{\"Order\":22,\"Remarks\":\"2531 Mayfair Ave White Bear-small-022-005-Bathroom-666x444-72dpi - Copy.jpg\"},{\"Order\":23,\"Remarks\":\"2531 Mayfair Ave White Bear-small-023-001-Bathroom-666x444-72dpi - Copy.jpg\"},{\"Order\":24,\"Remarks\":\"2531 Mayfair Ave White Bear-small-024-024-Finished Basement-666x444-72dpi - Copy.jpg\"},{\"Order\":25,\"Remarks\":\"2531 Mayfair Ave White Bear-small-025-011-Finished Basement-666x444-72dpi - Copy.jpg\"},{\"Order\":26,\"Remarks\":\"2531 Mayfair Ave White Bear-small-026-016-Bathroom-666x444-72dpi - Copy.jpg\"},{\"Order\":27,\"Remarks\":\"2531 Mayfair Ave White Bear-small-027-015-Bathroom-666x444-72dpi - Copy.jpg\"},{\"Order\":28,\"Remarks\":\"2531 Mayfair Ave White Bear-small-028-027-Laundry Room-666x444-72dpi - Copy.jpg\"},{\"Order\":29,\"Remarks\":\"2531 Mayfair Ave White Bear-small-029-021-Laundry Room-666x444-72dpi - Copy.jpg\"},{\"Order\":30,\"Remarks\":\"2531 Mayfair Ave White Bear-small-030-014-Deck-666x444-72dpi - Copy.jpg\"},{\"Order\":31,\"Remarks\":\"2531 Mayfair Ave White Bear-small-031-002-Deck-666x444-72dpi.jpg\"},{\"Order\":32,\"Remarks\":\"2531 Mayfair Ave White Bear-small-033-018-Back Yard-666x444-72dpi.jpg\"}]","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,29,30,31,32","SOURCE":"MG_NST"}
{"ListingKey":"NST7842562","NST_AboveGradeSqFtTotal":"1736","AboveGradeFinishedArea":"1736","AccessibilityFeatures":"None","AdditionalParcelsYN":"False","NST_AgentOwner":"No","Appliances":"Dishwasher,Dryer,Range,Refrigerator,Stainless Steel Appliances,Washer","LivingAreaUnits":"Square Feet","NST_AssessmentPending":"No","AssociationYN":"False","AssociationFee":"0","Basement":"Finished","BasementYN":"True","BathroomsFull":"1","BathroomsHalf":"1","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"2","BedroomsTotal":"3","NST_BelowGradeSqFtTotal":"528","BelowGradeFinishedArea":"400","CumulativeDaysOnMarket":"155","City":"White Bear Lake","NewConstructionYN":"False","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Ramsey","Directions":"Bellaire to Mayfair east to home","DocumentsCount":"3","DocumentsChangeTimestamp":"2026-01-14T18:06:07.832Z","DaysOnMarket":"0","FireplaceFeatures":"Family Room","FireplaceYN":"True","FireplacesTotal":"1","FoundationArea":"1120","NST_FoundationDimensions":"0","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","NST_GarageSquareFeet":"528","GarageSpaces":"2","Heating":"Forced Air","HighSchoolDistrict":"White Bear Lake","NST_ForeclosureStatus":"No","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"True","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","Latitude":"45.053862","NST_LenderOwned":"No","Levels":"One and One Half","ListPrice":"424900","ListingContractDate":"2026-01-14T06:00:00Z","ListingId":"NST7008453","LivingArea":"2136","Longitude":"-92.993626","LotSizeArea":"0.229","LotSizeDimensions":"80 X 125","LotSizeUnits":"Acres","NST_MainLevelFinishedArea":"1120","NST_ManufacturedHome":"N","OriginalEntryTimestamp":"2026-01-14T08:48:57Z","ParcelNumber":"253022430004","NST_SchoolDistrictNumber":"2099","ParkingFeatures":"Attached Garage","NST_PatioPorchType":"Deck","PhotosCount":"32","PhotosChangeTimestamp":"2026-01-14T14:53:06.659Z","PostalCity":"Saint Paul","PostalCode":"55110","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PropertyAttachedYN":"False","PropertySubType":"Single Family Residence","PropertyType":"Residential","PublicRemarks":"If you've outgrown your place and are looking for more space, this could be your new home. Newly updated 4 bedroom 3 bathroom house near Matoska Elementary School. A couple things that this property has: 2 nice new tiled full bathrooms, a 27'x 17' Great room, new kitchen appliances, hard wood floors, Primary suite, and newly stained deck for entertaining. Agents verify the room measurements.","PublicSurveyRange":"22","PublicSurveySection":"25","PublicSurveyTownship":"30","RoadFrontageType":"City Street","Roof":"Age Over 8 Years","NST_SchoolDistrictPhone":"6514077500","Sewer":"City Sewer/Connected","StandardStatus":"Active","StateOrProvince":"MN","StreetName":"Mayfair","StreetNumber":"2531","StreetNumberNumeric":"2531","StreetSuffix":"Avenue","SubdivisionName":"Bacchus White Bear Hills","TaxAnnualAmount":"4348","NST_TaxWithAssessments":"4348","TaxYear":"2025","Township":"White Bear Lake","VideosCount":"0","WaterSource":"City Water/Connected","YearBuilt":"1966","ZoningDescription":"Residential-Single Family","ListAgentKey":"NST98203","ListAgentMlsId":"NST506008837","ListOfficeMlsId":"NST80164","ListOfficeName":"Vanrose Realty","ListOfficeKey":"NST19439","ModificationTimestamp":"2026-01-14T18:09:08.562Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7842562\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7842562/f80ec03c-7324-404f-a2a6-6a0226b5e1db.jpeg\",\"Order\":6,\"MediaObjectID\":\"NST6\",\"LongDescription\":\"2531 Mayfair Ave White Bear-small-006-025-Kitchen-666x444-72dpi - Copy.jpg\",\"ImageWidth\":666,\"ImageHeight\":444,\"ImageSizeDescription\":\"666x444\",\"MediaModificationTimestamp\":\"2026-01-14T14:52:32.044Z\",\"MediaKey\":\"NST120138642\"},{\"ResourceRecordKey\":\"NST7842562\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7842562/71f041ef-2c35-4bce-9765-db218061da82.jpeg\",\"Order\":10,\"MediaObjectID\":\"NST10\",\"LongDescription\":\"2531 Mayfair Ave White Bear-small-010-004-Dining Room-666x444-72dpi - Copy.jpg\",\"ImageWidth\":666,\"ImageHeight\":444,\"ImageSizeDescription\":\"666x444\",\"MediaModificationTimestamp\":\"2026-01-14T14:52:32.004Z\",\"MediaKey\":\"NST120138638\"},{\"ResourceRecordKey\":\"NST7842562\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7842562/8b0a3c6a-2b43-4b3f-98fe-f0a832f70443.jpeg\",\"Order\":8,\"MediaObjectID\":\"NST8\",\"LongDescription\":\"2531 Mayfair Ave White Bear-small-008-009-Kitchen-666x444-72dpi - Copy.jpg\",\"ImageWidth\":666,\"ImageHeight\":443,\"ImageSizeDescription\":\"666x443\",\"MediaModificationTimestamp\":\"2026-01-14T14:52:32.02Z\",\"MediaKey\":\"NST120138640\"},{\"ResourceRecordKey\":\"NST7842562\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7842562/405de690-6362-4123-bc05-7e51b3954e56.jpeg\",\"Order\":9,\"MediaObjectID\":\"NST9\",\"LongDescription\":\"2531 Mayfair Ave White Bear-small-009-032-Dining Room-666x444-72dpi - Copy.jpg\",\"ImageWidth\":666,\"ImageHeight\":443,\"ImageSizeDescription\":\"666x443\",\"MediaModificationTimestamp\":\"2026-01-14T14:52:31.993Z\",\"MediaKey\":\"NST120138639\"},{\"ResourceRecordKey\":\"NST7842562\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7842562/dfcf477b-b88a-4af8-9ed7-002e06798db5.jpeg\",\"Order\":20,\"MediaObjectID\":\"NST20\",\"LongDescription\":\"2531 Mayfair Ave White Bear-small-020-020-Bedroom-666x444-72dpi - Copy.jpg\",\"ImageWidth\":666,\"ImageHeight\":443,\"ImageSizeDescription\":\"666x443\",\"MediaModificationTimestamp\":\"2026-01-14T14:52:32.007Z\",\"MediaKey\":\"NST120138628\"},{\"ResourceRecordKey\":\"NST7842562\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7842562/5ebc315a-2aad-4e40-b83c-09103bf3cea0.jpeg\",\"Order\":25,\"MediaObjectID\":\"NST25\",\"LongDescription\":\"2531 Mayfair Ave White Bear-small-025-011-Finished Basement-666x444-72dpi - Copy.jpg\",\"ImageWidth\":666,\"ImageHeight\":443,\"ImageSizeDescription\":\"666x443\",\"MediaModificationTimestamp\":\"2026-01-14T14:52:32.021Z\",\"MediaKey\":\"NST120138623\"},{\"ResourceRecordKey\":\"NST7842562\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7842562/d9b56700-d17a-4ab6-ace0-857da766647f.jpeg\",\"Order\":17,\"MediaObjectID\":\"NST17\",\"LongDescription\":\"2531 Mayfair Ave White Bear-small-017-008-Bathroom-666x445-72dpi - Copy.jpg\",\"ImageWidth\":666,\"ImageHeight\":444,\"ImageSizeDescription\":\"666x444\",\"MediaModificationTimestamp\":\"2026-01-14T14:52:32.02Z\",\"MediaKey\":\"NST120138631\"},{\"ResourceRecordKey\":\"NST7842562\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7842562/d9db9887-a942-4be9-b096-3040752d2f28.jpeg\",\"Order\":15,\"MediaObjectID\":\"NST15\",\"LongDescription\":\"2531 Mayfair Ave White Bear-small-015-023-Entryway-666x444-72dpi - Copy.jpg\",\"ImageWidth\":666,\"ImageHeight\":443,\"ImageSizeDescription\":\"666x443\",\"MediaModificationTimestamp\":\"2026-01-14T14:52:32.008Z\",\"MediaKey\":\"NST120138633\"},{\"ResourceRecordKey\":\"NST7842562\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7842562/147b6d73-584b-4ac7-afc9-275d5e12d650.jpeg\",\"Order\":7,\"MediaObjectID\":\"NST7\",\"LongDescription\":\"2531 Mayfair Ave White Bear-small-007-006-Kitchen-666x444-72dpi - Copy.jpg\",\"ImageWidth\":666,\"ImageHeight\":443,\"ImageSizeDescription\":\"666x443\",\"MediaModificationTimestamp\":\"2026-01-14T14:52:32.042Z\",\"MediaKey\":\"NST120138641\"},{\"ResourceRecordKey\":\"NST7842562\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7842562/caee3272-0103-4966-8744-65fb404449f9.jpeg\",\"Order\":29,\"MediaObjectID\":\"NST29\",\"LongDescription\":\"2531 Mayfair Ave White Bear-small-029-021-Laundry Room-666x444-72dpi - Copy.jpg\",\"ImageWidth\":666,\"ImageHeight\":443,\"ImageSizeDescription\":\"666x443\",\"MediaModificationTimestamp\":\"2026-01-14T14:52:32.013Z\",\"MediaKey\":\"NST120138619\"},{\"ResourceRecordKey\":\"NST7842562\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7842562/ec4b7898-26bd-40eb-a6b6-4b6f40a7004e.jpeg\",\"Order\":11,\"MediaObjectID\":\"NST11\",\"LongDescription\":\"2531 Mayfair Ave White Bear-small-011-029-Dining Room-666x444-72dpi - Copy.jpg\",\"ImageWidth\":666,\"ImageHeight\":443,\"ImageSizeDescription\":\"666x443\",\"MediaModificationTimestamp\":\"2026-01-14T14:52:32.003Z\",\"MediaKey\":\"NST120138637\"},{\"ResourceRecordKey\":\"NST7842562\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7842562/47e1aab8-9d11-47fe-b9f5-4b85d27c454a.jpeg\",\"Order\":27,\"MediaObjectID\":\"NST27\",\"LongDescription\":\"2531 Mayfair Ave White Bear-small-027-015-Bathroom-666x444-72dpi - Copy.jpg\",\"ImageWidth\":666,\"ImageHeight\":443,\"ImageSizeDescription\":\"666x443\",\"MediaModificationTimestamp\":\"2026-01-14T14:52:32.002Z\",\"MediaKey\":\"NST120138621\"},{\"ResourceRecordKey\":\"NST7842562\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7842562/4f7f4326-9b73-4822-8207-6ebec66b6f9b.jpeg\",\"Order\":21,\"MediaObjectID\":\"NST21\",\"LongDescription\":\"2531 Mayfair Ave White Bear-small-021-022-Bedroom-666x444-72dpi - Copy.jpg\",\"ImageWidth\":666,\"ImageHeight\":443,\"ImageSizeDescription\":\"666x443\",\"MediaModificationTimestamp\":\"2026-01-14T14:52:32.007Z\",\"MediaKey\":\"NST120138627\"},{\"ResourceRecordKey\":\"NST7842562\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7842562/a541849e-9e8a-47dc-80ef-6cbc3c9fbafd.jpeg\",\"Order\":28,\"MediaObjectID\":\"NST28\",\"LongDescription\":\"2531 Mayfair Ave White Bear-small-028-027-Laundry Room-666x444-72dpi - Copy.jpg\",\"ImageWidth\":666,\"ImageHeight\":443,\"ImageSizeDescription\":\"666x443\",\"MediaModificationTimestamp\":\"2026-01-14T14:52:32.01Z\",\"MediaKey\":\"NST120138620\"},{\"ResourceRecordKey\":\"NST7842562\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7842562/99a7a087-2b43-48ed-8c5c-ab9ef80e533d.jpeg\",\"Order\":18,\"MediaObjectID\":\"NST18\",\"LongDescription\":\"2531 Mayfair Ave White Bear-small-018-012-Bedroom-666x444-72dpi - Copy.jpg\",\"ImageWidth\":666,\"ImageHeight\":444,\"ImageSizeDescription\":\"666x444\",\"MediaModificationTimestamp\":\"2026-01-14T14:52:32.002Z\",\"MediaKey\":\"NST120138630\"},{\"ResourceRecordKey\":\"NST7842562\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7842562/75cd3e93-733a-469c-b25a-5b1ebb90230e.jpeg\",\"Order\":1,\"MediaObjectID\":\"NST1\",\"LongDescription\":\"2531 Mayfair Ave White Bear-small-001-019-Front-666x444-72dpi - Copy.jpg\",\"ImageWidth\":666,\"ImageHeight\":443,\"ImageSizeDescription\":\"666x443\",\"MediaModificationTimestamp\":\"2026-01-14T14:52:32.075Z\",\"MediaKey\":\"NST120138647\"},{\"ResourceRecordKey\":\"NST7842562\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7842562/5c3b4327-81a3-40e9-ac7c-a605eb9bdd66.jpeg\",\"Order\":32,\"MediaObjectID\":\"NST32\",\"LongDescription\":\"2531 Mayfair Ave White Bear-small-033-018-Back Yard-666x444-72dpi.jpg\",\"ImageWidth\":666,\"ImageHeight\":443,\"ImageSizeDescription\":\"666x443\",\"MediaModificationTimestamp\":\"2026-01-14T14:52:32.022Z\",\"MediaKey\":\"NST120138616\"},{\"ResourceRecordKey\":\"NST7842562\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7842562/73f7942a-e9a8-4848-bc76-76c8e1cc7c5f.jpeg\",\"Order\":19,\"MediaObjectID\":\"NST19\",\"LongDescription\":\"2531 Mayfair Ave White Bear-small-019-030-Bedroom-666x444-72dpi - Copy.jpg\",\"ImageWidth\":666,\"ImageHeight\":443,\"ImageSizeDescription\":\"666x443\",\"MediaModificationTimestamp\":\"2026-01-14T14:52:32.001Z\",\"MediaKey\":\"NST120138629\"},{\"ResourceRecordKey\":\"NST7842562\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7842562/1bac839f-35f6-4820-b04e-9924091245a6.jpeg\",\"Order\":5,\"MediaObjectID\":\"NST5\",\"LongDescription\":\"2531 Mayfair Ave White Bear-small-005-013-Living Room-666x444-72dpi - Copy.jpg\",\"ImageWidth\":666,\"ImageHeight\":443,\"ImageSizeDescription\":\"666x443\",\"MediaModificationTimestamp\":\"2026-01-14T14:52:32.037Z\",\"MediaKey\":\"NST120138643\"},{\"ResourceRecordKey\":\"NST7842562\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7842562/e0ef8541-46de-4f07-85a2-348506ec276e.jpeg\",\"Order\":2,\"MediaObjectID\":\"NST2\",\"LongDescription\":\"2531 Mayfair Ave White Bear-small-002-003-Front-666x445-72dpi - Copy.jpg\",\"ImageWidth\":666,\"ImageHeight\":444,\"ImageSizeDescription\":\"666x444\",\"MediaModificationTimestamp\":\"2026-01-14T14:52:32.062Z\",\"MediaKey\":\"NST120138646\"},{\"ResourceRecordKey\":\"NST7842562\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7842562/15e6b62c-dd40-4a65-9471-e9a9df451be9.jpeg\",\"Order\":14,\"MediaObjectID\":\"NST14\",\"LongDescription\":\"2531 Mayfair Ave White Bear-small-014-033-Family Room-666x444-72dpi - Copy.jpg\",\"ImageWidth\":666,\"ImageHeight\":444,\"ImageSizeDescription\":\"666x444\",\"MediaModificationTimestamp\":\"2026-01-14T14:52:32.027Z\",\"MediaKey\":\"NST120138634\"},{\"ResourceRecordKey\":\"NST7842562\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7842562/c7897240-0cc3-45be-8ed1-d170dbd0444c.jpeg\",\"Order\":26,\"MediaObjectID\":\"NST26\",\"LongDescription\":\"2531 Mayfair Ave White Bear-small-026-016-Bathroom-666x444-72dpi - Copy.jpg\",\"ImageWidth\":666,\"ImageHeight\":443,\"ImageSizeDescription\":\"666x443\",\"MediaModificationTimestamp\":\"2026-01-14T14:52:31.99Z\",\"MediaKey\":\"NST120138622\"},{\"ResourceRecordKey\":\"NST7842562\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7842562/3acf44fa-25f9-4abd-a133-1ac9ea0c7b8d.jpeg\",\"Order\":23,\"MediaObjectID\":\"NST23\",\"LongDescription\":\"2531 Mayfair Ave White Bear-small-023-001-Bathroom-666x444-72dpi - Copy.jpg\",\"ImageWidth\":666,\"ImageHeight\":444,\"ImageSizeDescription\":\"666x444\",\"MediaModificationTimestamp\":\"2026-01-14T14:52:32.016Z\",\"MediaKey\":\"NST120138625\"},{\"ResourceRecordKey\":\"NST7842562\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7842562/29e863ae-c064-4aca-b455-536a3a837014.jpeg\",\"Order\":24,\"MediaObjectID\":\"NST24\",\"LongDescription\":\"2531 Mayfair Ave White Bear-small-024-024-Finished Basement-666x444-72dpi - Copy.jpg\",\"ImageWidth\":666,\"ImageHeight\":443,\"ImageSizeDescription\":\"666x443\",\"MediaModificationTimestamp\":\"2026-01-14T14:52:31.999Z\",\"MediaKey\":\"NST120138624\"},{\"ResourceRecordKey\":\"NST7842562\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7842562/04c1f88c-fe23-41f0-9e0d-2d432f4805f8.jpeg\",\"Order\":16,\"MediaObjectID\":\"NST16\",\"LongDescription\":\"2531 Mayfair Ave White Bear-small-016-028-Entryway-666x444-72dpi - Copy.jpg\",\"ImageWidth\":666,\"ImageHeight\":443,\"ImageSizeDescription\":\"666x443\",\"MediaModificationTimestamp\":\"2026-01-14T14:52:31.998Z\",\"MediaKey\":\"NST120138632\"},{\"ResourceRecordKey\":\"NST7842562\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7842562/e08e12a0-812f-47e2-94de-8de4abdd1aee.jpeg\",\"Order\":4,\"MediaObjectID\":\"NST4\",\"LongDescription\":\"2531 Mayfair Ave White Bear-small-004-010-Living Room-666x445-72dpi - Copy.jpg\",\"ImageWidth\":666,\"ImageHeight\":444,\"ImageSizeDescription\":\"666x444\",\"MediaModificationTimestamp\":\"2026-01-14T14:52:32.017Z\",\"MediaKey\":\"NST120138644\"},{\"ResourceRecordKey\":\"NST7842562\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7842562/cc671381-19fa-48c8-a066-fc9b5cc49604.jpeg\",\"Order\":31,\"MediaObjectID\":\"NST31\",\"LongDescription\":\"2531 Mayfair Ave White Bear-small-031-002-Deck-666x444-72dpi.jpg\",\"ImageWidth\":666,\"ImageHeight\":444,\"ImageSizeDescription\":\"666x444\",\"MediaModificationTimestamp\":\"2026-01-14T14:52:32.017Z\",\"MediaKey\":\"NST120138617\"},{\"ResourceRecordKey\":\"NST7842562\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7842562/9688c9a9-d5f2-4042-8188-236271701b64.jpeg\",\"Order\":30,\"MediaObjectID\":\"NST30\",\"LongDescription\":\"2531 Mayfair Ave White Bear-small-030-014-Deck-666x444-72dpi - Copy.jpg\",\"ImageWidth\":666,\"ImageHeight\":443,\"ImageSizeDescription\":\"666x443\",\"MediaModificationTimestamp\":\"2026-01-14T14:52:31.999Z\",\"MediaKey\":\"NST120138618\"},{\"ResourceRecordKey\":\"NST7842562\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7842562/fdb77278-78da-46ae-a8e8-b21cca970fc6.jpeg\",\"Order\":12,\"MediaObjectID\":\"NST12\",\"LongDescription\":\"2531 Mayfair Ave White Bear-small-012-007-Family Room-666x444-72dpi - Copy.jpg\",\"ImageWidth\":666,\"ImageHeight\":443,\"ImageSizeDescription\":\"666x443\",\"MediaModificationTimestamp\":\"2026-01-14T14:52:32.003Z\",\"MediaKey\":\"NST120138636\"},{\"ResourceRecordKey\":\"NST7842562\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7842562/b34a0015-1359-4b34-a3d1-e734ecaf9ff1.jpeg\",\"Order\":3,\"MediaObjectID\":\"NST3\",\"LongDescription\":\"2531 Mayfair Ave White Bear-small-003-017-Front-666x444-72dpi - Copy.jpg\",\"ImageWidth\":666,\"ImageHeight\":444,\"ImageSizeDescription\":\"666x444\",\"MediaModificationTimestamp\":\"2026-01-14T14:52:32.002Z\",\"MediaKey\":\"NST120138645\"},{\"ResourceRecordKey\":\"NST7842562\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7842562/afce5b15-ae93-427b-a704-010e41576c69.jpeg\",\"Order\":22,\"MediaObjectID\":\"NST22\",\"LongDescription\":\"2531 Mayfair Ave White Bear-small-022-005-Bathroom-666x444-72dpi - Copy.jpg\",\"ImageWidth\":666,\"ImageHeight\":443,\"ImageSizeDescription\":\"666x443\",\"MediaModificationTimestamp\":\"2026-01-14T14:52:32.044Z\",\"MediaKey\":\"NST120138626\"},{\"ResourceRecordKey\":\"NST7842562\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7842562/543e2af4-2591-4589-9e8a-2843a25f4cab.jpeg\",\"Order\":13,\"MediaObjectID\":\"NST13\",\"LongDescription\":\"2531 Mayfair Ave White Bear-small-013-026-Family Room-666x444-72dpi - Copy.jpg\",\"ImageWidth\":666,\"ImageHeight\":443,\"ImageSizeDescription\":\"666x443\",\"MediaModificationTimestamp\":\"2026-01-14T14:52:32.001Z\",\"MediaKey\":\"NST120138635\"}]","Media__ResourceRecordKey":"NST7842562","Media__MediaURL":"https://s3.amazonaws.com/mlsgrid/images/NST7842562/f80ec03c-7324-404f-a2a6-6a0226b5e1db.jpeg","Media__Order":"6","Media__MediaObjectID":"NST6","Media__LongDescription":"2531 Mayfair Ave White Bear-small-006-025-Kitchen-666x444-72dpi - Copy.jpg","Media__ImageWidth":"666","Media__ImageHeight":"444","Media__ImageSizeDescription":"666x444","Media__MediaModificationTimestamp":"1/14/2026 2:52:32 PM","Media__MediaKey":"NST120138642","Rooms":"[{\"NST_RoomSortOrder\":8,\"RoomLevel\":\"Main\",\"RoomKey\":\"NST115867542\",\"RoomDimensions\":\"9.5 X 12\",\"RoomType\":\"Breezeway\"},{\"NST_RoomSortOrder\":9,\"RoomLevel\":\"Main\",\"RoomKey\":\"NST115867543\",\"RoomType\":\"Deck\"},{\"NST_RoomSortOrder\":2,\"RoomLevel\":\"Main\",\"RoomKey\":\"NST115867536\",\"RoomDimensions\":\"10 X 8.5\",\"RoomType\":\"Dining Room\"},{\"NST_RoomSortOrder\":3,\"RoomLevel\":\"Main\",\"RoomKey\":\"NST115867537\",\"RoomDimensions\":\"17.5 X 27\",\"RoomType\":\"Family Room\"},{\"NST_RoomSortOrder\":5,\"RoomLevel\":\"Upper\",\"RoomKey\":\"NST115867539\",\"RoomDimensions\":\"9.15 X 12\",\"RoomType\":\"Bedroom\"},{\"NST_RoomSortOrder\":10,\"RoomLevel\":\"Basement\",\"RoomKey\":\"NST115867544\",\"RoomDimensions\":\"14 X 14.5\",\"RoomType\":\"Bedroom 4\"},{\"NST_RoomSortOrder\":4,\"RoomLevel\":\"Main\",\"RoomKey\":\"NST115867538\",\"RoomDimensions\":\"14.5 X 9.5\",\"RoomType\":\"Kitchen\"},{\"NST_RoomSortOrder\":1,\"RoomLevel\":\"Main\",\"RoomKey\":\"NST115867535\",\"RoomDimensions\":\"24X 11\",\"RoomType\":\"Living Room\"},{\"NST_RoomSortOrder\":6,\"RoomLevel\":\"Upper\",\"RoomKey\":\"NST115867540\",\"RoomDimensions\":\"10 X 12\",\"RoomType\":\"Bedroom 2\"},{\"NST_RoomSortOrder\":7,\"RoomLevel\":\"Upper\",\"RoomKey\":\"NST115867541\",\"RoomDimensions\":\"11 X 12\",\"RoomType\":\"Bedroom 3\"}]","Rooms__NST_RoomSortOrder":"8","Rooms__RoomLevel":"Main","Rooms__RoomKey":"NST115867542","Rooms__RoomDimensions":"9.5 X 12","Rooms__RoomType":"Breezeway","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"2531 Mayfair Ave White Bear-small-001-019-Front-666x444-72dpi - Copy.jpg\"},{\"Order\":2,\"Remarks\":\"2531 Mayfair Ave White Bear-small-002-003-Front-666x445-72dpi - Copy.jpg\"},{\"Order\":3,\"Remarks\":\"2531 Mayfair Ave White Bear-small-003-017-Front-666x444-72dpi - Copy.jpg\"},{\"Order\":4,\"Remarks\":\"2531 Mayfair Ave White Bear-small-004-010-Living Room-666x445-72dpi - Copy.jpg\"},{\"Order\":5,\"Remarks\":\"2531 Mayfair Ave White Bear-small-005-013-Living Room-666x444-72dpi - Copy.jpg\"},{\"Order\":6,\"Remarks\":\"2531 Mayfair Ave White Bear-small-006-025-Kitchen-666x444-72dpi - Copy.jpg\"},{\"Order\":7,\"Remarks\":\"2531 Mayfair Ave White Bear-small-007-006-Kitchen-666x444-72dpi - Copy.jpg\"},{\"Order\":8,\"Remarks\":\"2531 Mayfair Ave White Bear-small-008-009-Kitchen-666x444-72dpi - Copy.jpg\"},{\"Order\":9,\"Remarks\":\"2531 Mayfair Ave White Bear-small-009-032-Dining Room-666x444-72dpi - Copy.jpg\"},{\"Order\":10,\"Remarks\":\"2531 Mayfair Ave White Bear-small-010-004-Dining Room-666x444-72dpi - Copy.jpg\"},{\"Order\":11,\"Remarks\":\"2531 Mayfair Ave White Bear-small-011-029-Dining Room-666x444-72dpi - Copy.jpg\"},{\"Order\":12,\"Remarks\":\"2531 Mayfair Ave White Bear-small-012-007-Family Room-666x444-72dpi - Copy.jpg\"},{\"Order\":13,\"Remarks\":\"2531 Mayfair Ave White Bear-small-013-026-Family Room-666x444-72dpi - Copy.jpg\"},{\"Order\":14,\"Remarks\":\"2531 Mayfair Ave White Bear-small-014-033-Family Room-666x444-72dpi - Copy.jpg\"},{\"Order\":15,\"Remarks\":\"2531 Mayfair Ave White Bear-small-015-023-Entryway-666x444-72dpi - Copy.jpg\"},{\"Order\":16,\"Remarks\":\"2531 Mayfair Ave White Bear-small-016-028-Entryway-666x444-72dpi - Copy.jpg\"},{\"Order\":17,\"Remarks\":\"2531 Mayfair Ave White Bear-small-017-008-Bathroom-666x445-72dpi - Copy.jpg\"},{\"Order\":18,\"Remarks\":\"2531 Mayfair Ave White Bear-small-018-012-Bedroom-666x444-72dpi - Copy.jpg\"},{\"Order\":19,\"Remarks\":\"2531 Mayfair Ave White Bear-small-019-030-Bedroom-666x444-72dpi - Copy.jpg\"},{\"Order\":20,\"Remarks\":\"2531 Mayfair Ave White Bear-small-020-020-Bedroom-666x444-72dpi - Copy.jpg\"},{\"Order\":21,\"Remarks\":\"2531 Mayfair Ave White Bear-small-021-022-Bedroom-666x444-72dpi - Copy.jpg\"},{\"Order\":22,\"Remarks\":\"2531 Mayfair Ave White Bear-small-022-005-Bathroom-666x444-72dpi - Copy.jpg\"},{\"Order\":23,\"Remarks\":\"2531 Mayfair Ave White Bear-small-023-001-Bathroom-666x444-72dpi - Copy.jpg\"},{\"Order\":24,\"Remarks\":\"2531 Mayfair Ave White Bear-small-024-024-Finished Basement-666x444-72dpi - Copy.jpg\"},{\"Order\":25,\"Remarks\":\"2531 Mayfair Ave White Bear-small-025-011-Finished Basement-666x444-72dpi - Copy.jpg\"},{\"Order\":26,\"Remarks\":\"2531 Mayfair Ave White Bear-small-026-016-Bathroom-666x444-72dpi - Copy.jpg\"},{\"Order\":27,\"Remarks\":\"2531 Mayfair Ave White Bear-small-027-015-Bathroom-666x444-72dpi - Copy.jpg\"},{\"Order\":28,\"Remarks\":\"2531 Mayfair Ave White Bear-small-028-027-Laundry Room-666x444-72dpi - Copy.jpg\"},{\"Order\":29,\"Remarks\":\"2531 Mayfair Ave White Bear-small-029-021-Laundry Room-666x444-72dpi - Copy.jpg\"},{\"Order\":30,\"Remarks\":\"2531 Mayfair Ave White Bear-small-030-014-Deck-666x444-72dpi - Copy.jpg\"},{\"Order\":31,\"Remarks\":\"2531 Mayfair Ave White Bear-small-031-002-Deck-666x444-72dpi.jpg\"},{\"Order\":32,\"Remarks\":\"2531 Mayfair Ave White Bear-small-033-018-Back Yard-666x444-72dpi.jpg\"}]","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,29,30,31,32","CustomVTourURL":""}
$MLSDESCRIPTION$
2531 Mayfair Avenue White Bear Lake, MN 55110
$LISTPRICE$$HOTDATA$
$STATUS$ | Contingent
$MLSNUMBERSHOW$
$SUMMARY1$
$FULLDATA$
$MLSDESCRIPTION$
2531 Mayfair Avenue White Bear Lake, MN 55110
$LISTPRICE$$HOTDATA$
$STATUS$ | Contingent
$MLSNUMBERSHOW$
$SUMMARY1$
$FULLDATA$