{"Id":1413699,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST6793020","MLSAGENTID":"NST503503230","MLSOFFICEID":"NST26797","ADDRESS":"1658 Mayowood Court SW","ACRES":0.28,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"None","BATHSTOTAL":3.0,"BEDROOMS":4,"CITY":"Rochester","CONTINGENCY":"None","COUNTY":"Olmsted","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Brick/Stone,Engineered Wood","FORECLOSURE":"No","LAKEWATERFRONT":"Pond","LASTPRICE":1276000.0,"LASTPRICEDATE":"2025-09-26T13:58:03.487","LATITUDE":43.99463675,"LENDEROWNED":"No","LISTDATE":"2025-09-26T05:00:00","LISTPRICE":1276000.0,"LIVINGAREA":3168.0,"LONGITUDE":-92.51149975,"LOTDESCRIPTION":"Sod Included in Price,Underground Utilities","MODIFICATIONTIMESTAMP":"2025-09-26T15:30:04.447","OFFICE_OFFICENAME":"Edina Realty, Inc.","PHOTOCOUNT":1,"POSTALCODE":"55902","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Welcome to the Preserve of Mayowood, Rochester’s only private and gated community in a premier southwest location. This meticulously planned subdivision features serpentine roadways, private wooded lots, ponds, open space and access to miles of walking trails. Presenting a luxurious 4-bedroom, 3 bath two-story model home with an additional family room on the upper level. Discover gleaming hardwoods, custom-designed cabinetry, professionally selected interiors, the convenience of a butler’s pantry, and the charm of high-end finishes with premier construction. The private spa-like primary suite with a soaking tub, open concept design, and 10ft ceilings on the main floor with floor to ceiling windows enhance the living experience. Beyond the home, enjoy breathtaking pond views from your back covered porch and a southeast facing backyard! As part of this exceptional community, homeowners benefit from HOA covered amenities, including lawn care, snow removal, and rubbish removal-ensuring a hassle-free lifestyle. Relish in proximity to all things SW Rochester. This is more than a residence; it’s an invitation to a lifestyle tailored for the discerning homeowner. Live harmoniously in this premier community, where every detail is designed to exceed your expectations. Your exceptional living experience awaits.","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Age 8 Years or Less,Asphalt","SCHOOLDISTRICTNUMBER":"535-Rochester","SCHOOLDISTRICTPHONE":"507-328-3000","SCHOOLELEMENTARY":"Bamber Valley","SCHOOLHIGH":"Mayo","SCHOOLMIDDLE":"John Adams","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2025-09-26T13:58:03.487","LASTSTATUS":"Active","STREETDIRSUFFIX":"SW","STREETNAME":"Mayowood","STREETNUMBER":"1658","STREETSUFFIX":"Court","STYLE":"Single Family Residence","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"WATERFRONTVIEW":"Pond","YEARBUILT":2026,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2025-09-26T15:30:04.447","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"The Harmon Two Story Model\"}]","PHOTOORDER":"1","SOURCE":"MG_NST"}
{"ListingKey":"NST7806094","LotSizeArea":"0.28","NST_AgeOfProperty":"-1","NST_AgentOwner":"No","InternetAutomatedValuationDisplayYN":"False","InternetConsumerCommentYN":"False","NST_AmenitiesUnit":"Cable,Ceiling Fan(s),Hardwood Floors,Kitchen Center Island,Main Floor Primary Bedroom,Paneled Doors,Porch,In-Ground Sprinkler,Tile Floors,Washer/Dryer Hookup,Walk-In Closet","Appliances":"Air-To-Air Exchanger,Dishwasher,Disposal,Dryer,Exhaust Fan,Humidifier,Gas Water Heater,Microwave,Range,Refrigerator,Washer,Water Softener Owned","NST_AssessmentPending":"No","AssociationFeeIncludes":"Controlled Access,Lawn Care,Other,Trash,Shared Amenities,Snow Removal","AssociationFeeFrequency":"Monthly","AssociationYN":"True","AssociationFee":"400","AssociationName":"Preserve of Mayowood Homeowners Association","AssociationPhone":"507-281-9800","PropertyAttachedYN":"False","Basement":"None","BasementYN":"False","NST_BathDesc":"Double Sink,Full Primary,Private Primary,Main Floor 3/4 Bath,Separate Tub & Shower,Upper Level Full Bath,Walk-In Shower Stall","BathroomsOneQuarter":"0","BathroomsFull":"1","BathroomsHalf":"0","BathroomsThreeQuarter":"2","BathroomsTotalInteger":"3","BedroomsTotal":"4","City":"Rochester","PropertyType":"Residential","NST_CompletionDate":"2026-08-04","NewConstructionYN":"True","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Olmsted","NST_DiningRoomDescription":"Eat In Kitchen,Kitchen/Dining Room","Directions":"Bamber Valley Rd SW to Mayowood Rd SW, right on to Mayowood Ct SW.","InternetAddressDisplayYN":"True","InternetEntireListingDisplayYN":"True","Electric":"Circuit Breakers,200+ Amp Service","ConstructionMaterials":"Brick/Stone,Engineered Wood","FireplaceFeatures":"Family Room,Gas","FireplaceYN":"True","FireplacesTotal":"1","NST_ForeclosureStatus":"No","FoundationArea":"2200","NST_FractionalOwnershipYN":"No","RoadFrontageType":"Private Road","NST_Fuel":"Natural Gas","ParkingFeatures":"Attached Garage,Concrete,Floor Drain,Garage Door Opener,Insulated Garage","NST_GarageSquareFeet":"982","AccessibilityFeatures":"Doors 36\"+","Heating":"Forced Air,Fireplace(s)","OriginalEntryTimestamp":"2025-09-26T13:56:26Z","NST_InternetOptions":"Cable,Fiber Optic","WaterfrontFeatures":"Pond","LandLeaseYN":"False","NST_LastUpdateDate":"2025-09-26","Latitude":"43.9946367463","NST_LenderOwned":"No","ListAgentKey":"NST87916","ListAgentMlsId":"NST503503230","ListingContractDate":"2025-09-26T05:00:00Z","ListOfficeKey":"NST26797","ListOfficeName":"Edina Realty, Inc.","ListOfficeMlsId":"NST26797","ListPrice":"1276000","LivingArea":"3168","Longitude":"-92.5114997546","LotFeatures":"Sod Included in Price,Underground Utilities","LotSizeDimensions":"Irreg","LotSizeSquareFeet":"12196.8","LotSizeUnits":"Acres","ListingId":"NST6793020","SourceSystemName":"RMLS","NST_ManufacturedHome":"No","MapCoordinateSource":"King's Street Atlas","AdditionalParcelsYN":"False","NST_OfficeBoard":"SEMR","ParcelNumber":"640934088224","GarageSpaces":"3","NST_PatioPorchType":"Porch,Screened","PhotosCount":"1","PostalCity":"Rochester","PostalCode":"55902","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PublicRemarks":"Welcome to the Preserve of Mayowood, Rochester’s only private and gated community in a premier southwest location. This meticulously planned subdivision features serpentine roadways, private wooded lots, ponds, open space and access to miles of walking trails. Presenting a luxurious 4-bedroom, 3 bath two-story model home with an additional family room on the upper level. Discover gleaming hardwoods, custom-designed cabinetry, professionally selected interiors, the convenience of a butler’s pantry, and the charm of high-end finishes with premier construction. The private spa-like primary suite with a soaking tub, open concept design, and 10ft ceilings on the main floor with floor to ceiling windows enhance the living experience. Beyond the home, enjoy breathtaking pond views from your back covered porch and a southeast facing backyard! As part of this exceptional community, homeowners benefit from HOA covered amenities, including lawn care, snow removal, and rubbish removal-ensuring a hassle-free lifestyle. Relish in proximity to all things SW Rochester. This is more than a residence; it’s an invitation to a lifestyle tailored for the discerning homeowner. Live harmoniously in this premier community, where every detail is designed to exceed your expectations. Your exceptional living experience awaits.","PublicSurveyRange":"14","PublicSurveySection":"9","PublicSurveyTownship":"106","NST_RentalLicenseYN":"No","NST_Restrictions":"Architecture Committee,Builder Restriction,Mandatory Owners Assoc,Other Covenants,Pets - Cats Allowed,Pets - Dogs Allowed","RoadResponsibility":"Association Maintained Road","Roof":"Age 8 Years or Less,Asphalt","RoomType":"Dining Room,Great Room,Kitchen,Pantry (Walk-In),Screened Porch,Bedroom 1,Bedroom 2,Bedroom 3,Bedroom 4,Mud Room,Laundry,Walk In Closet,Loft,Panic Room","NST_AboveGradeSqFtTotal":"3168.0000","NST_BelowGradeSqFtTotal":"0.0000","NST_MainLevelFinishedArea":"2200.0000","BuildingAreaTotal":"3168","HighSchoolDistrict":"Rochester","NST_SchoolDistrictNumber":"535","NST_SchoolDistrictPhone":"507-328-3000","ElementarySchool":"Bamber Valley","HighSchool":"Mayo","MiddleOrJuniorSchool":"John Adams","Sewer":"City Sewer/Connected","NST_SpecialSearch":"All Living Facilities on One Level,Main Floor Primary,Main Floor Laundry,Primary Bdr Suite","AboveGradeFinishedArea":"3168","BelowGradeFinishedArea":"0","StateOrProvince":"MN","StandardStatus":"Active","Levels":"Two","StreetDirSuffix":"SW","StreetName":"Mayowood","StreetNumber":"1658","StreetNumberNumeric":"1658","StreetSuffix":"Court","PropertySubType":"Single Family Residence","SubdivisionName":"Preserve Of Mayowood","NST_TaxWithAssessments":"506.0000","TaxYear":"2025","TaxAnnualAmount":"506","WaterSource":"City Water/Connected","WaterfrontYN":"False","YearBuilt":"2026","ZoningDescription":"Residential-Single Family","ModificationTimestamp":"2025-09-26T15:30:04.447Z","PhotosChangeTimestamp":"2025-09-26T15:30:04.447Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7806094\",\"Order\":1,\"MediaObjectID\":\"1\",\"LongDescription\":\"The Harmon Two Story Model\",\"ImageWidth\":1920,\"ImageHeight\":1228,\"ImageSizeDescription\":\"1920x1228\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7806094/8c21c231-d49c-4825-8f1b-cf6296e67bc2.jpeg\",\"MediaModificationTimestamp\":\"2025-09-26T15:29:43.355Z\",\"MediaKey\":\"68d6b167d70f773b48ce8f58\"}]","Rooms":"[{\"RoomKey\":\"NST115637621\",\"RoomType\":\"Dining Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"14x13\",\"NST_RoomSortOrder\":\"1\"},{\"RoomKey\":\"NST115637622\",\"RoomType\":\"Great Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"16x20\",\"NST_RoomSortOrder\":\"2\"},{\"RoomKey\":\"NST115637623\",\"RoomType\":\"Kitchen\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"16x12\",\"NST_RoomSortOrder\":\"3\"},{\"RoomKey\":\"NST115637624\",\"RoomType\":\"Pantry (Walk-In)\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"11x9\",\"NST_RoomSortOrder\":\"4\"},{\"RoomKey\":\"NST115637625\",\"RoomType\":\"Screened Porch\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"16x14\",\"NST_RoomSortOrder\":\"5\"},{\"RoomKey\":\"NST115637626\",\"RoomType\":\"Bedroom 1\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"16x15\",\"NST_RoomSortOrder\":\"6\"},{\"RoomKey\":\"NST115637627\",\"RoomType\":\"Bedroom 2\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"13x11\",\"NST_RoomSortOrder\":\"7\"},{\"RoomKey\":\"NST115637628\",\"RoomType\":\"Bedroom 3\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"13x15\",\"NST_RoomSortOrder\":\"8\"},{\"RoomKey\":\"NST115637629\",\"RoomType\":\"Bedroom 4\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"15x12\",\"NST_RoomSortOrder\":\"9\"},{\"RoomKey\":\"NST115637630\",\"RoomType\":\"Mud Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"11x6\",\"NST_RoomSortOrder\":\"10\"},{\"RoomKey\":\"NST115637631\",\"RoomType\":\"Laundry\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"7x9\",\"NST_RoomSortOrder\":\"11\"},{\"RoomKey\":\"NST115637632\",\"RoomType\":\"Walk In Closet\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":\"12\"},{\"RoomKey\":\"NST115637633\",\"RoomType\":\"Loft\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"15x20\",\"NST_RoomSortOrder\":\"13\"},{\"RoomKey\":\"NST115637634\",\"RoomType\":\"Panic Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"7x6\",\"NST_RoomSortOrder\":\"14\"}]","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"The Harmon Two Story Model\"}]","PhotoOrder":"1","CustomVTourURL":""}