MLS# 6775812
1702 Mayowood Court SW Rochester, MN 55902
Edina Realty, Inc. is the brokerage office representing the seller for this listing.
Copyright 2025, 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. Jim Christensen is not a multiple Listing Service (MLS), nor does it offer MLS access. This website is a service of Jim Christensen, a broker Participant of the Regional Multiple Listing Service of Minnesota, Inc.
$LABEL$
$CONTENT$
$DESC$
{"Id":1398299,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST6775812","MLSAGENTID":"NST503503230","MLSOFFICEID":"NST26797","ADDRESS":"1702 Mayowood Court SW","ACRES":0.28,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Drain Tiled,Concrete,Sump Basket,Sump Pump","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":1222000.0,"LASTPRICEDATE":"2025-08-20T19:26:03.91","LATITUDE":43.99543668,"LENDEROWNED":"No","LISTDATE":"2025-08-14T05:00:00","LISTPRICE":1222000.0,"LIVINGAREA":3032.0,"LONGITUDE":-92.51130258,"LOTDESCRIPTION":"Sod Included in Price,Underground Utilities","MODIFICATIONTIMESTAMP":"2025-08-21T13:35:03.768","OFFICE_OFFICENAME":"Edina Realty, Inc.","PHOTOCOUNT":2,"POSTALCODE":"55902","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Welcome to The Ivy, a sophisticated 4-bedroom, 3-bathroom model home in The Preserve of Mayowood, Rochester’s only private and gated community in a premier southwest location. This exceptional neighborhood showcases winding roadways, private wooded lots, scenic ponds, and access to miles of serene walking trails. Crafted with thoughtful design and timeless finishes, The Ivy features an open-concept layout with gleaming hardwood floors, soaring ceilings, and expansive windows that flood the space with natural light. The chef’s kitchen boasts custom cabinetry, a walk-in pantry, and a large center island perfect for gathering. Retreat to the private, spa-like primary suite, offering luxurious comfort and peaceful views. A spacious 3-car garage, covered porch, and high-quality construction throughout make this home as functional as it is beautiful. All just minutes from the best of SW Rochester. More than a home, The Ivy is an invitation to live with ease, elegance, and exclusivity in one of the city’s most coveted communities.","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-08-20T19:26:03.91","LASTSTATUS":"Active","STREETDIRSUFFIX":"SW","STREETNAME":"Mayowood","STREETNUMBER":"1702","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-08-21T13:35:03.768","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"Front Elevation - Colors to be determined\"},{\"Order\":2,\"Remarks\":\"Zero entry - one level living\"}]","PHOTOORDER":"1,2","SOURCE":"MG_NST"}
{"ListingKey":"NST7791169","LotSizeArea":"0.28","NST_AgeOfProperty":"-1","NST_AgentOwner":"No","InternetAutomatedValuationDisplayYN":"False","InternetConsumerCommentYN":"False","NST_AmenitiesUnit":"Cable,Ceiling Fan(s),Hardwood Floors,Kitchen Center Island,Primary Bedroom Walk-In Closet,Main Floor Primary Bedroom,Paneled Doors,Porch,In-Ground Sprinkler,Tile Floors,Washer/Dryer Hookup,Walk-In Closet","Appliances":"Air-To-Air Exchanger,Cooktop,Dishwasher,Disposal,Dryer,Exhaust Fan,Humidifier,Gas Water Heater,Microwave,Range,Refrigerator,Wall Oven,Washer","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":"Drain Tiled,Concrete,Sump Basket,Sump Pump","BasementYN":"True","NST_BathDesc":"3/4 Primary,Private Primary,Main Floor 3/4 Bath,Main Floor Full Bath","BathroomsOneQuarter":"0","BathroomsFull":"2","BathroomsHalf":"0","BathroomsThreeQuarter":"1","BathroomsTotalInteger":"3","BedroomsTotal":"4","City":"Rochester","PropertyType":"Residential","NST_CompletionDate":"2026-04-14","NewConstructionYN":"True","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Olmsted","DaysOnMarket":"7","CumulativeDaysOnMarket":"7","NST_DiningRoomDescription":"Eat In Kitchen,Kitchen/Dining Room","Directions":"From Hwy 52 south exit 54B to Salem Rd SW, left on Bamber Valley Rd SW, right on Mayowood Rd SW, then right on 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":"3032","NST_FractionalOwnershipYN":"No","RoadFrontageType":"Private Road","NST_Fuel":"Natural Gas","ParkingFeatures":"Attached Garage,Concrete,Floor Drain,Garage Door Opener,Insulated Garage","NST_GarageSquareFeet":"910","AccessibilityFeatures":"Doors 36\"+,No Stairs External,No Stairs Internal","Heating":"Forced Air,Fireplace(s),Humidifier","OriginalEntryTimestamp":"2025-08-20T19:22:09Z","NST_InternetOptions":"Fiber Optic","WaterfrontFeatures":"Pond","LandLeaseYN":"False","NST_LastUpdateDate":"2025-08-21","Latitude":"43.9954366754","NST_LenderOwned":"No","ListAgentKey":"NST87916","ListAgentMlsId":"NST503503230","ListingContractDate":"2025-08-14T05:00:00Z","ListOfficeKey":"NST26797","ListOfficeName":"Edina Realty, Inc.","ListOfficeMlsId":"NST26797","ListPrice":"1222000","LivingArea":"3032","Longitude":"-92.5113025767","LotFeatures":"Sod Included in Price,Underground Utilities","LotSizeDimensions":"Irreg","LotSizeSquareFeet":"12196.8","LotSizeUnits":"Acres","ListingId":"NST6775812","SourceSystemName":"RMLS","NST_ManufacturedHome":"No","MapCoordinateSource":"King's Street Atlas","AdditionalParcelsYN":"False","NST_OfficeBoard":"SEMR","ParcelNumber":"640934088227","GarageSpaces":"3","NST_PatioPorchType":"Covered,Porch","PhotosCount":"2","PoolFeatures":"None","PostalCity":"Rochester","PostalCode":"55902","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PublicRemarks":"Welcome to The Ivy, a sophisticated 4-bedroom, 3-bathroom model home in The Preserve of Mayowood, Rochester’s only private and gated community in a premier southwest location. This exceptional neighborhood showcases winding roadways, private wooded lots, scenic ponds, and access to miles of serene walking trails. Crafted with thoughtful design and timeless finishes, The Ivy features an open-concept layout with gleaming hardwood floors, soaring ceilings, and expansive windows that flood the space with natural light. The chef’s kitchen boasts custom cabinetry, a walk-in pantry, and a large center island perfect for gathering. Retreat to the private, spa-like primary suite, offering luxurious comfort and peaceful views. A spacious 3-car garage, covered porch, and high-quality construction throughout make this home as functional as it is beautiful. All just minutes from the best of SW Rochester. More than a home, The Ivy is an invitation to live with ease, elegance, and exclusivity in one of the city’s most coveted communities.","PublicSurveyRange":"14","PublicSurveySection":"9","PublicSurveyTownship":"106","NST_RentalLicenseYN":"No","NST_Restrictions":"Architecture Committee,Builder Restriction,Mandatory Owners Assoc","RoadResponsibility":"Association Maintained Road","Roof":"Age 8 Years or Less,Asphalt","RoomType":"Dining Room,Great Room,Kitchen,Pantry (Walk-In),Porch,Bedroom 1,Bedroom 2,Bedroom 3,Bedroom 4,Mud Room,Laundry","NST_AboveGradeSqFtTotal":"3032.0000","NST_BelowGradeSqFtTotal":"0.0000","NST_MainLevelFinishedArea":"3032.0000","BuildingAreaTotal":"3032","HighSchoolDistrict":"Rochester","NST_SchoolDistrictNumber":"535","NST_SchoolDistrictPhone":"507-328-3000","ElementarySchool":"Bamber Valley","HighSchool":"Mayo","MiddleOrJuniorSchool":"John Adams","Sewer":"City Sewer/Connected","NST_SpecialSearch":"4 BR on One Level,All Living Facilities on One Level,Main Floor Primary,Main Floor Bedroom,Main Floor Laundry","AboveGradeFinishedArea":"3032","BelowGradeFinishedArea":"0","StateOrProvince":"MN","StandardStatus":"Active","Levels":"One","StreetDirSuffix":"SW","StreetName":"Mayowood","StreetNumber":"1702","StreetNumberNumeric":"1702","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-08-21T13:35:03.768Z","PhotosChangeTimestamp":"2025-08-21T13:35:03.768Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7791169\",\"Order\":1,\"MediaObjectID\":\"1\",\"LongDescription\":\"Front Elevation - Colors to be determined\",\"ImageWidth\":1624,\"ImageHeight\":778,\"ImageSizeDescription\":\"1624x778\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7791169/82ece11d-5a4c-4ebe-9251-177ac8912fbe.png\",\"MediaModificationTimestamp\":\"2025-08-21T13:34:32.794Z\",\"MediaKey\":\"68a7206802bb95230571b1c0\"},{\"ResourceRecordKey\":\"NST7791169\",\"Order\":2,\"MediaObjectID\":\"2\",\"LongDescription\":\"Zero entry - one level living\",\"ImageWidth\":1198,\"ImageHeight\":1364,\"ImageSizeDescription\":\"1198x1364\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7791169/0898840f-b9d4-4c36-b627-4f09cd6320f1.png\",\"MediaModificationTimestamp\":\"2025-08-21T13:34:32.719Z\",\"MediaKey\":\"68a7206802bb95230571b1c1\"}]","Rooms":"[{\"RoomKey\":\"NST115537168\",\"RoomType\":\"Dining Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"14x14\",\"NST_RoomSortOrder\":\"1\"},{\"RoomKey\":\"NST115537169\",\"RoomType\":\"Great Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"21x14\",\"NST_RoomSortOrder\":\"2\"},{\"RoomKey\":\"NST115537170\",\"RoomType\":\"Kitchen\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"19x14\",\"NST_RoomSortOrder\":\"3\"},{\"RoomKey\":\"NST115537171\",\"RoomType\":\"Pantry (Walk-In)\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"7x7\",\"NST_RoomSortOrder\":\"4\"},{\"RoomKey\":\"NST115537172\",\"RoomType\":\"Porch\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"17x20\",\"NST_RoomSortOrder\":\"5\"},{\"RoomKey\":\"NST115537173\",\"RoomType\":\"Bedroom 1\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"20x15\",\"NST_RoomSortOrder\":\"6\"},{\"RoomKey\":\"NST115537174\",\"RoomType\":\"Bedroom 2\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"13x16\",\"NST_RoomSortOrder\":\"7\"},{\"RoomKey\":\"NST115537175\",\"RoomType\":\"Bedroom 3\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"12x18\",\"NST_RoomSortOrder\":\"8\"},{\"RoomKey\":\"NST115537176\",\"RoomType\":\"Bedroom 4\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"14x14\",\"NST_RoomSortOrder\":\"9\"},{\"RoomKey\":\"NST115537177\",\"RoomType\":\"Mud Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"10x7\",\"NST_RoomSortOrder\":\"10\"},{\"RoomKey\":\"NST115537178\",\"RoomType\":\"Laundry\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"7x9\",\"NST_RoomSortOrder\":\"11\"}]","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"Front Elevation - Colors to be determined\"},{\"Order\":2,\"Remarks\":\"Zero entry - one level living\"}]","PhotoOrder":"1,2","CustomVTourURL":""}
