{"Id":547756,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST7061591","MLSAGENTID":"NST506097318","MLSCOAGENTID":"NST506013143","MLSOFFICEID":"NST8237","ADDRESS":"209 Quail Street","ACRES":0.39,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Daylight/Lookout Windows,Egress Window(s),Finished,Full","BATHSTOTAL":4.0,"BEDROOMS":4.0,"CITY":"Mahtomedi","CONTINGENCY":"None","COUNTY":"Washington","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"FORECLOSURE":"No","LASTPRICE":1249500.0,"LASTPRICEDATE":"2026-04-27T13:36:06.037","LATITUDE":45.07827,"LENDEROWNED":"No","LISTDATE":"2026-04-26T05:00:00","LISTPRICE":1249500.0,"LIVINGAREA":3258.0,"LONGITUDE":-92.957784,"LOTDESCRIPTION":"Tree Coverage - Light","MODIFICATIONTIMESTAMP":"2026-04-27T16:30:07.108","OFFICE_OFFICENAME":"Coldwell Banker Realty","PHOTOCOUNT":0,"POSTALCODE":"55115","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Welcome home to a unique opportunity in the heart of Mahtomedi. Award-Winning Hagstrom Builder is offering custom built villas, each secluded on nearly half an acre with private views. Experience main floor living at its best with the option of 2 bedrooms on the main floor, a finished lower level and 3 car garage. Within minutes of White Bear Lake and miles of bike trails.","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Asphalt,Pitched","SCHOOLDISTRICTNUMBER":"832-Mahtomedi","SCHOOLDISTRICTPHONE":"6514072001","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2026-04-27T13:36:06.037","LASTSTATUS":"Active","STREETNAME":"Quail","STREETNUMBER":"209","STREETSUFFIX":"Street","STYLE":"Single Family","TRANSACTIONTYPE":"For","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":2026,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2026-04-27T16:30:07.108","SOURCE":"MG_NST"}
{"ListingKey":"NST7890737","NST_AboveGradeSqFtTotal":"1936","AboveGradeFinishedArea":"1756","AccessibilityFeatures":"No Stairs Internal","AdditionalParcelsYN":"False","NST_AgentOwner":"No","NST_AmenitiesUnit":"Hardwood Floors,Kitchen Center Island,Kitchen Window,Primary Bedroom Walk-In Closet,Main Floor Primary Bedroom,Natural Woodwork,Patio,Paneled Doors,Tile Floors,Washer/Dryer Hookup,Walk-In Closet","Appliances":"Air-To-Air Exchanger,Dishwasher,Dryer,Microwave,Range,Refrigerator,Washer","LivingAreaUnits":"Square Feet","NST_AssessmentPending":"Unknown","AssociationYN":"True","AssociationFee":"250","AssociationFeeFrequency":"Monthly","AssociationFeeIncludes":"Lawn Care,Snow Removal","AssociationName":"Hagstrom Builder","AssociationPhone":"6513244137","AttributionContact":"6122475106","NST_AttributionName":"Krista J. Wolter","Basement":"Daylight/Lookout Windows,Egress Window(s),Finished,Full","BasementYN":"True","NST_BathDesc":"Full Primary,Full Basement,Private Primary,Main Floor 1/2 Bath,Main Floor Full Bath","BathroomsFull":"3","BathroomsHalf":"1","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"4","BedroomsTotal":"4","NST_BelowGradeSqFtTotal":"1756","BelowGradeFinishedArea":"1502","NST_BuilderLicense":"2904","BuilderName":"HAGSTROM BUILDER INC","CumulativeDaysOnMarket":"1","CarportSpaces":"0","City":"Mahtomedi","NST_CommunityName":"Villas on Quail","NewConstructionYN":"False","Contingency":"None","NST_ForSaleOrLease":"For Sale","Cooling":"Central Air","CountyOrParish":"Washington","NST_DiningRoomDescription":"Breakfast Bar,Eat In Kitchen,Separate/Formal Dining Room","Directions":"From Briarwood Avenue, go northeast on Quail Street to lots on left.","DaysOnMarket":"1","FireplaceFeatures":"Living Room","FireplaceYN":"True","FireplacesTotal":"1","FoundationArea":"1756","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","NST_GarageSquareFeet":"830","GarageSpaces":"3","Heating":"Forced Air","HighSchoolDistrict":"Mahtomedi","NST_ForeclosureStatus":"No","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"False","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","Latitude":"45.07827","LaundryFeatures":"Main Level","NST_LenderOwned":"No","Levels":"One","ListPrice":"1249500","ListingContractDate":"2026-04-26T05:00:00Z","ListingId":"NST7061591","LivingArea":"3258","Longitude":"-92.957784","LotFeatures":"Tree Coverage - Light","LotSizeArea":"0.39","LotSizeDimensions":"88x268","LotSizeUnits":"Acres","NST_MainLevelFinishedArea":"1756","NST_ManufacturedHome":"N","OriginalEntryTimestamp":"2026-04-27T08:35:35Z","ParcelNumber":"TBD","ParkingFeatures":"Attached Garage","NST_PatioPorchType":"Deck,Patio","PostalCity":"Mahtomedi","PostalCode":"55115","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PropertyAttachedYN":"False","PropertySubType":"Single Family","PropertyType":"Residential","PublicRemarks":"Welcome home to a unique opportunity in the heart of Mahtomedi. Award-Winning Hagstrom Builder is offering custom built villas, each secluded on nearly half an acre with private views. Experience main floor living at its best with the option of 2 bedrooms on the main floor, a finished lower level and 3 car garage. Within minutes of White Bear Lake and miles of bike trails.","PublicSurveyRange":"21","PublicSurveySection":"20","PublicSurveyTownship":"30","Roof":"Asphalt,Pitched","NST_SchoolDistrictNumber":"832","NST_SchoolDistrictPhone":"6514072001","Sewer":"City Sewer/Connected","NST_SpecialSearch":"All Living Facilities on One Level,Main Floor Bedroom,Main Floor Laundry","StandardStatus":"Active","StateOrProvince":"MN","StreetName":"Quail","StreetNumber":"209","StreetNumberNumeric":"209","StreetSuffix":"Street","SubdivisionName":"Cic 389","TaxAnnualAmount":"4596","NST_TaxWithAssessments":"4596","TaxYear":"2026","BuildingAreaTotal":"3692","Township":"Mahtomedi","WaterSource":"City Water/Connected","YearBuilt":"2026","ZoningDescription":"Residential-Single Family","CoListAgentKey":"NST105055","CoListAgentMlsId":"NST506013143","CoListOfficeName":"Coldwell Banker Realty","ListAgentKey":"NST68568","ListAgentMlsId":"NST506097318","ListOfficeMlsId":"NST8237","ListOfficeName":"Coldwell Banker Realty","ListOfficeKey":"NST16731","ModificationTimestamp":"2026-04-27T16:30:07.108Z","PhotosChangeTimestamp":"2026-04-27T16:30:07.108Z","OriginatingSystemName":"northstar","PhotosCount":"0","DocumentsCount":"0","DocumentsChangeTimestamp":"2026-04-27T13:36:06.035Z","Rooms":"[{\"RoomLevel\":\"Main\",\"RoomType\":\"Dining Room\",\"NST_RoomSortOrder\":2,\"RoomKey\":\"NST116156900\",\"RoomDimensions\":\"11x16\"},{\"RoomLevel\":\"Lower\",\"RoomType\":\"Family Room\",\"NST_RoomSortOrder\":3,\"RoomKey\":\"NST116156901\",\"RoomDimensions\":\"32x38\"},{\"RoomLevel\":\"Main\",\"RoomType\":\"Bedroom\",\"NST_RoomSortOrder\":5,\"RoomKey\":\"NST116156903\",\"RoomDimensions\":\"14x18\"},{\"RoomLevel\":\"Lower\",\"RoomType\":\"Bedroom 4\",\"NST_RoomSortOrder\":8,\"RoomKey\":\"NST116156906\",\"RoomDimensions\":\"12x13\"},{\"RoomLevel\":\"Main\",\"RoomType\":\"Kitchen\",\"NST_RoomSortOrder\":4,\"RoomKey\":\"NST116156902\",\"RoomDimensions\":\"16x18\"},{\"RoomLevel\":\"Main\",\"RoomType\":\"Laundry\",\"NST_RoomSortOrder\":9,\"RoomKey\":\"NST116156907\",\"RoomDimensions\":\"7x8\"},{\"RoomLevel\":\"Main\",\"RoomType\":\"Living Room\",\"NST_RoomSortOrder\":1,\"RoomKey\":\"NST116156899\",\"RoomDimensions\":\"20x25\"},{\"RoomLevel\":\"Main\",\"RoomType\":\"Mud Room\",\"NST_RoomSortOrder\":10,\"RoomKey\":\"NST116156908\",\"RoomDimensions\":\"5x8\"},{\"RoomLevel\":\"Main\",\"RoomType\":\"Bedroom 2\",\"NST_RoomSortOrder\":6,\"RoomKey\":\"NST116156904\",\"RoomDimensions\":\"12x13\"},{\"RoomLevel\":\"Lower\",\"RoomType\":\"Bedroom 3\",\"NST_RoomSortOrder\":7,\"RoomKey\":\"NST116156905\",\"RoomDimensions\":\"12x14\"}]","Rooms__RoomLevel":"Main","Rooms__RoomType":"Dining Room","Rooms__NST_RoomSortOrder":"2","Rooms__RoomKey":"NST116156900","Rooms__RoomDimensions":"11x16","MlgCanView":"True","MlgCanUse":"IDX","CustomVTourURL":""}