$SCONTENT$
$LABEL$
$SCONTENT$
MLS# 6708845 - 209 Quail Street Mahtomedi, MN 55115
Coldwell Banker 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. Joy+Marci Realty Group is not a multiple Listing Service (MLS), nor does it offer MLS access. This website is a service of Joy+Marci Realty Group, a broker Participant of the Regional Multiple Listing Service of Minnesota, Inc.
{"Id":1374351,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST6708845","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,"CITY":"Mahtomedi","CONTINGENCY":"None","COUNTY":"Washington","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Fiber Cement","FORECLOSURE":"No","LASTPRICE":1249500.0,"LASTPRICEDATE":"2025-06-25T04:55:03.377","LATITUDE":45.07827,"LENDEROWNED":"No","LISTDATE":"2025-06-24T05:00:00","LISTPRICE":1249500.0,"LIVINGAREA":3258.0,"LONGITUDE":-92.957784,"LOTDESCRIPTION":"Some Trees","MODIFICATIONTIMESTAMP":"2025-06-25T04:55:03.377","OFFICE_OFFICENAME":"Coldwell Banker Realty","PHOTOCOUNT":22,"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. Taking lot reservations now for a fall completion date.","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Asphalt,Pitched","SCHOOLDISTRICTNUMBER":"832-Mahtomedi","SCHOOLDISTRICTPHONE":"651-407-2001","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2025-06-25T04:55:03.377","LASTSTATUS":"Active","STREETNAME":"Quail","STREETNUMBER":"209","STREETSUFFIX":"Street","STYLE":"Single Family Residence","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":2025,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2025-06-25T04:50:03.364","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"Photos of previously built homes at the Villas on Quail!\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22","SOURCE":"MG_NST"}
{"ListingKey":"NST7732860","LotSizeArea":"0.39","NST_AgeOfProperty":"0","NST_AgentOwner":"No","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"False","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","NST_AssessmentPending":"Unknown","AssociationFeeIncludes":"Lawn Care,Snow Removal","AssociationFeeFrequency":"Monthly","AssociationYN":"True","AssociationFee":"250","AssociationName":"Hagstrom Builder","AssociationPhone":"651-324-4137","PropertyAttachedYN":"False","NST_AttributionContact":"612-247-5106","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","BathroomsOneQuarter":"0","BathroomsFull":"3","BathroomsHalf":"1","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"4","BedroomsTotal":"4","NST_BuilderLicense":"2904","BuilderName":"HAGSTROM BUILDER INC","CarportSpaces":"0","City":"Mahtomedi","PropertyType":"Residential","NST_CommunityName":"Villas on Quail","NST_CompletionDate":"2026-03-27","NewConstructionYN":"True","Contingency":"None","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.","InternetAddressDisplayYN":"True","InternetEntireListingDisplayYN":"True","ConstructionMaterials":"Fiber Cement","FireplaceFeatures":"Living Room","FireplaceYN":"True","FireplacesTotal":"1","NST_ForeclosureStatus":"No","FoundationArea":"1756","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","ParkingFeatures":"Attached Garage","NST_GarageSquareFeet":"830","AccessibilityFeatures":"No Stairs Internal","Heating":"Forced Air","OriginalEntryTimestamp":"2025-06-25T04:48:56Z","LandLeaseYN":"False","NST_LastUpdateDate":"2025-06-24","Latitude":"45.07827","NST_LenderOwned":"No","ListAgentKey":"NST68568","ListAgentMlsId":"NST506097318","CoListAgentKey":"NST105055","CoListAgentMlsId":"NST506013143","ListingContractDate":"2025-06-24T05:00:00Z","ListOfficeKey":"NST16731","ListOfficeName":"Coldwell Banker Realty","ListOfficeMlsId":"NST8237","ListPrice":"1249500","LivingArea":"3258","Longitude":"-92.957784","LotFeatures":"Some Trees","LotSizeDimensions":"88x268","LotSizeSquareFeet":"16988.4","LotSizeUnits":"Acres","ListingId":"NST6708845","SourceSystemName":"RMLS","NST_ManufacturedHome":"No","MapCoordinateSource":"King's Street Atlas","AdditionalParcelsYN":"False","NST_OfficeBoard":"SPAAR","ParcelNumber":"TBD","GarageSpaces":"3","NST_PatioPorchType":"Deck,Patio","PhotosCount":"22","PostalCity":"Mahtomedi","PostalCode":"55115","NST_PotentialShortSale":"No","NST_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. Taking lot reservations now for a fall completion date.","PublicSurveyRange":"21","PublicSurveySection":"20","PublicSurveyTownship":"30","NST_RentalLicenseYN":"No","NST_Restrictions":"Mandatory Owners Assoc","Roof":"Asphalt,Pitched","RoomType":"Living Room,Dining Room,Family Room,Kitchen,Bedroom 1,Bedroom 2,Bedroom 3,Bedroom 4,Laundry,Mud Room","NST_AboveGradeSqFtTotal":"1936.0000","NST_BelowGradeSqFtTotal":"1756.0000","NST_MainLevelFinishedArea":"1756.0000","BuildingAreaTotal":"3692","HighSchoolDistrict":"Mahtomedi","NST_SchoolDistrictNumber":"832","NST_SchoolDistrictPhone":"651-407-2001","Sewer":"City Sewer/Connected","NST_SpecialSearch":"All Living Facilities on One Level,Main Floor Bedroom,Main Floor Laundry","AboveGradeFinishedArea":"1756","BelowGradeFinishedArea":"1502","StateOrProvince":"MN","StandardStatus":"Active","Levels":"One","StreetName":"Quail","StreetNumber":"209","StreetNumberNumeric":"209","StreetSuffix":"Street","PropertySubType":"Single Family Residence","SubdivisionName":"Cic 389","NST_TaxWithAssessments":"4596.0000","TaxYear":"2025","TaxAnnualAmount":"4596","WaterSource":"City Water/Connected","YearBuilt":"2025","ZoningDescription":"Residential-Single Family","ModificationTimestamp":"2025-06-25T04:55:03.377Z","PhotosChangeTimestamp":"2025-06-25T04:50:03.364Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7732860\",\"Order\":1,\"MediaObjectID\":\"1\",\"LongDescription\":\"Photos of previously built homes at the Villas on Quail!\",\"ImageWidth\":2080,\"ImageHeight\":1169,\"ImageSizeDescription\":\"2080x1169\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7732860/e794bdb0-8a9c-45a1-9337-c11fbb9db2f2.jpeg\",\"MediaModificationTimestamp\":\"2025-06-25T04:49:16.883Z\",\"MediaKey\":\"685b7fcc1c698d56af05468c\"},{\"ResourceRecordKey\":\"NST7732860\",\"Order\":2,\"MediaObjectID\":\"2\",\"ImageWidth\":2080,\"ImageHeight\":1168,\"ImageSizeDescription\":\"2080x1168\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7732860/b3edb7d8-ba45-4b60-9e42-2fe80d8f9f6c.jpeg\",\"MediaModificationTimestamp\":\"2025-06-25T04:49:16.846Z\",\"MediaKey\":\"685b7fcc1c698d56af05468d\"},{\"ResourceRecordKey\":\"NST7732860\",\"Order\":3,\"MediaObjectID\":\"3\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7732860/9276c3d1-70ae-4b8e-b4fd-1fc8d66e5b13.jpeg\",\"MediaModificationTimestamp\":\"2025-06-25T04:49:16.907Z\",\"MediaKey\":\"685b7fcc1c698d56af05468e\"},{\"ResourceRecordKey\":\"NST7732860\",\"Order\":4,\"MediaObjectID\":\"4\",\"ImageWidth\":2050,\"ImageHeight\":1367,\"ImageSizeDescription\":\"2050x1367\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7732860/11b9406d-5e25-4d3d-8916-fe329d0d8768.jpeg\",\"MediaModificationTimestamp\":\"2025-06-25T04:49:16.901Z\",\"MediaKey\":\"685b7fcc1c698d56af05468f\"},{\"ResourceRecordKey\":\"NST7732860\",\"Order\":5,\"MediaObjectID\":\"5\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7732860/a24cf9ef-ef77-4d02-ba1c-4c30fda6d715.jpeg\",\"MediaModificationTimestamp\":\"2025-06-25T04:49:16.91Z\",\"MediaKey\":\"685b7fcc1c698d56af054690\"},{\"ResourceRecordKey\":\"NST7732860\",\"Order\":6,\"MediaObjectID\":\"6\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7732860/61c9e1a0-e559-4ac7-b8cf-7f61424aa812.jpeg\",\"MediaModificationTimestamp\":\"2025-06-25T04:49:16.883Z\",\"MediaKey\":\"685b7fcc1c698d56af054691\"},{\"ResourceRecordKey\":\"NST7732860\",\"Order\":7,\"MediaObjectID\":\"7\",\"ImageWidth\":2050,\"ImageHeight\":1367,\"ImageSizeDescription\":\"2050x1367\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7732860/2348afbc-173b-4fe5-ab7e-91414c161f24.jpeg\",\"MediaModificationTimestamp\":\"2025-06-25T04:49:16.869Z\",\"MediaKey\":\"685b7fcc1c698d56af054692\"},{\"ResourceRecordKey\":\"NST7732860\",\"Order\":8,\"MediaObjectID\":\"8\",\"ImageWidth\":2050,\"ImageHeight\":1367,\"ImageSizeDescription\":\"2050x1367\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7732860/4ec4240f-16d7-4d5c-a44a-fa854a138bbc.jpeg\",\"MediaModificationTimestamp\":\"2025-06-25T04:49:16.9Z\",\"MediaKey\":\"685b7fcc1c698d56af054693\"},{\"ResourceRecordKey\":\"NST7732860\",\"Order\":9,\"MediaObjectID\":\"9\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7732860/f708789a-cd87-48d8-a75b-f9aea9eaeaba.jpeg\",\"MediaModificationTimestamp\":\"2025-06-25T04:49:16.87Z\",\"MediaKey\":\"685b7fcc1c698d56af054694\"},{\"ResourceRecordKey\":\"NST7732860\",\"Order\":10,\"MediaObjectID\":\"10\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7732860/25c6d688-ff23-43d5-bc26-5df7fc9384a9.jpeg\",\"MediaModificationTimestamp\":\"2025-06-25T04:49:16.87Z\",\"MediaKey\":\"685b7fcc1c698d56af054695\"},{\"ResourceRecordKey\":\"NST7732860\",\"Order\":11,\"MediaObjectID\":\"11\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7732860/a62decf5-839c-485d-a2c0-444dd4531d98.jpeg\",\"MediaModificationTimestamp\":\"2025-06-25T04:49:16.891Z\",\"MediaKey\":\"685b7fcc1c698d56af054696\"},{\"ResourceRecordKey\":\"NST7732860\",\"Order\":12,\"MediaObjectID\":\"12\",\"ImageWidth\":2050,\"ImageHeight\":1367,\"ImageSizeDescription\":\"2050x1367\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7732860/b04f1919-449d-4d7c-b9af-8a73bd3829c8.jpeg\",\"MediaModificationTimestamp\":\"2025-06-25T04:49:16.904Z\",\"MediaKey\":\"685b7fcc1c698d56af054697\"},{\"ResourceRecordKey\":\"NST7732860\",\"Order\":13,\"MediaObjectID\":\"13\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7732860/e7a55475-bcaa-4fa6-94fd-b38fbd8e7209.jpeg\",\"MediaModificationTimestamp\":\"2025-06-25T04:49:16.873Z\",\"MediaKey\":\"685b7fcc1c698d56af054698\"},{\"ResourceRecordKey\":\"NST7732860\",\"Order\":14,\"MediaObjectID\":\"14\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7732860/b462f4a7-a21b-478d-8205-a84f09667d96.jpeg\",\"MediaModificationTimestamp\":\"2025-06-25T04:49:16.905Z\",\"MediaKey\":\"685b7fcc1c698d56af054699\"},{\"ResourceRecordKey\":\"NST7732860\",\"Order\":15,\"MediaObjectID\":\"15\",\"ImageWidth\":1386,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1386x2080\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7732860/857fca02-ebca-49a4-8c4a-5e9f5ee61bc2.jpeg\",\"MediaModificationTimestamp\":\"2025-06-25T04:49:16.881Z\",\"MediaKey\":\"685b7fcc1c698d56af05469a\"},{\"ResourceRecordKey\":\"NST7732860\",\"Order\":16,\"MediaObjectID\":\"16\",\"ImageWidth\":1920,\"ImageHeight\":1079,\"ImageSizeDescription\":\"1920x1079\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7732860/ad3b612b-9f54-4609-8a05-c33934be6a8f.jpeg\",\"MediaModificationTimestamp\":\"2025-06-25T04:49:16.908Z\",\"MediaKey\":\"685b7fcc1c698d56af05469b\"},{\"ResourceRecordKey\":\"NST7732860\",\"Order\":17,\"MediaObjectID\":\"17\",\"ImageWidth\":1664,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1664x2080\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7732860/93bdb3af-ae52-49f3-b5cb-a1952e0bbee0.jpeg\",\"MediaModificationTimestamp\":\"2025-06-25T04:49:16.84Z\",\"MediaKey\":\"685b7fcc1c698d56af05469c\"},{\"ResourceRecordKey\":\"NST7732860\",\"Order\":18,\"MediaObjectID\":\"18\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7732860/2a75c067-b0c9-4846-b585-15a287d21ca4.jpeg\",\"MediaModificationTimestamp\":\"2025-06-25T04:49:16.87Z\",\"MediaKey\":\"685b7fcc1c698d56af05469d\"},{\"ResourceRecordKey\":\"NST7732860\",\"Order\":19,\"MediaObjectID\":\"19\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7732860/0859c1aa-d4d0-4e1d-81f2-e7a6d45cd87a.jpeg\",\"MediaModificationTimestamp\":\"2025-06-25T04:49:16.894Z\",\"MediaKey\":\"685b7fcc1c698d56af05469e\"},{\"ResourceRecordKey\":\"NST7732860\",\"Order\":20,\"MediaObjectID\":\"20\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7732860/f5cf3d75-1745-4e91-8317-680edc23a3ee.jpeg\",\"MediaModificationTimestamp\":\"2025-06-25T04:49:16.852Z\",\"MediaKey\":\"685b7fcc1c698d56af05469f\"},{\"ResourceRecordKey\":\"NST7732860\",\"Order\":21,\"MediaObjectID\":\"21\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7732860/234bb3e9-06e3-4efd-a183-c7cba73c9e1a.jpeg\",\"MediaModificationTimestamp\":\"2025-06-25T04:49:16.946Z\",\"MediaKey\":\"685b7fcc1c698d56af0546a0\"},{\"ResourceRecordKey\":\"NST7732860\",\"Order\":22,\"MediaObjectID\":\"22\",\"ImageWidth\":2080,\"ImageHeight\":1169,\"ImageSizeDescription\":\"2080x1169\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7732860/8f5506ff-b657-40cd-9450-7f6b3eae95a7.jpeg\",\"MediaModificationTimestamp\":\"2025-06-25T04:49:16.902Z\",\"MediaKey\":\"685b7fcc1c698d56af0546a1\"}]","Rooms":"[{\"RoomKey\":\"NST115137854\",\"RoomType\":\"Living Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"20x25\",\"NST_RoomSortOrder\":\"1\"},{\"RoomKey\":\"NST115137855\",\"RoomType\":\"Dining Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"11x16\",\"NST_RoomSortOrder\":\"2\"},{\"RoomKey\":\"NST115137856\",\"RoomType\":\"Family Room\",\"RoomLevel\":\"Lower\",\"RoomDimensions\":\"32x38\",\"NST_RoomSortOrder\":\"3\"},{\"RoomKey\":\"NST115137857\",\"RoomType\":\"Kitchen\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"16x18\",\"NST_RoomSortOrder\":\"4\"},{\"RoomKey\":\"NST115137858\",\"RoomType\":\"Bedroom 1\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"14x18\",\"NST_RoomSortOrder\":\"5\"},{\"RoomKey\":\"NST115137859\",\"RoomType\":\"Bedroom 2\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"12x13\",\"NST_RoomSortOrder\":\"6\"},{\"RoomKey\":\"NST115137860\",\"RoomType\":\"Bedroom 3\",\"RoomLevel\":\"Lower\",\"RoomDimensions\":\"12x14\",\"NST_RoomSortOrder\":\"7\"},{\"RoomKey\":\"NST115137861\",\"RoomType\":\"Bedroom 4\",\"RoomLevel\":\"Lower\",\"RoomDimensions\":\"12x13\",\"NST_RoomSortOrder\":\"8\"},{\"RoomKey\":\"NST115137870\",\"RoomType\":\"Laundry\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"7x8\",\"NST_RoomSortOrder\":\"9\"},{\"RoomKey\":\"NST115137871\",\"RoomType\":\"Mud Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"5x8\",\"NST_RoomSortOrder\":\"10\"}]","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"Photos of previously built homes at the Villas on Quail!\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22","CustomVTourURL":""}