$LABEL$
$CONTENT$
$LABEL$
$CONTENT$
Keller Williams Classic Realty is the brokerage office representing the seller for this listing.
Copyright ©2026, 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. Gallery of Homes Group is not a multiple Listing Service (MLS), nor does it offer MLS access. This website is a service of Gallery of Homes Group, a broker Participant of the Regional Multiple Listing Service of Minnesota, Inc.
Copyright ©2026, 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. Gallery of Homes Group is not a multiple Listing Service (MLS), nor does it offer MLS access. This website is a service of Gallery of Homes Group, a broker Participant of the Regional Multiple Listing Service of Minnesota, Inc.
Nearby Listings in 10 Miles
{"Id":595974,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST7063354","MLSAGENTID":"NST502033130","MLSOFFICEID":"NST1865","ADDRESS":"2427 Mayflower Avenue","ACRES":0.78,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Block,Daylight/Lookout Windows,Finished,Walkout","BATHSTOTAL":4.0,"BEDROOMS":4.0,"CITY":"Hopkins","CONTINGENCY":"None","COUNTY":"Hennepin","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Block,Frame","FORECLOSURE":"No","LASTPRICE":725000.0,"LASTPRICEDATE":"2026-08-05T20:22:06.867","LATITUDE":44.956978,"LENDEROWNED":"No","LISTDATE":"2026-08-05T05:00:00","LISTPRICE":725000.0,"LIVINGAREA":3134.0,"LONGITUDE":-93.430732,"LOTDESCRIPTION":"Public Transit (w/in 6 blks),Tree Coverage - Medium","MODIFICATIONTIMESTAMP":"2026-08-06T10:18:08.973","OFFICE_OFFICENAME":"Keller Williams Classic Realty","PHOTOCOUNT":27,"POSTALCODE":"55305","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Anything but ordinary, this enchanting custom home is filled with character, versatility and unexpected spaces around every corner. Tucked away on nearly an acre of wooded privacy in an upscale neighborhood, this custom-built 4-bedroom, 4-bathroom, 2-car home offers a rare blend of space, character and versatility. Soaring wood-plank vaulted ceilings, dramatic architectural lines and expansive windows bring the outdoors in, creating warm and inviting spaces for everyday living and entertaining.\n\nThe kitchen features white cabinetry, stainless steel appliances, a center island and an adjoining dining area, while the impressive living room is anchored by a striking brick fireplace. A sun-filled four-season porch offers panoramic wooded views and direct access to the private backyard.\n\nFlexible room options allow the home to adapt beautifully to your lifestyle. The main-level office with custom built-ins could also serve as a bedroom, study or creative space. Upstairs, a charming secondary bedroom with cozy angles and wood ceilings could become a dream dollhouse room, tree-fort retreat or nursery. The spacious primary suite includes an updated bathroom, walls of storage and a private vanity area that could even accommodate a morning coffee bar overlooking the backyard. Additional secondary bedroom on this upper level. \n\nThe lower level provides even more room to enjoy with an amusement area, full bar, fireplace and versatile flex space ideal for recreation, hobbies, a playroom or home gym and another spacious bedroom. Generous sized bedrooms throughout, beautifully finished bathrooms and multiple gathering spaces make this home as functional as it is memorable. See it today before it is gone!","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Age Over 8 Years,Pitched","SCHOOLDISTRICTNUMBER":"270-Hopkins","SCHOOLDISTRICTPHONE":"9529884000","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2026-08-06T05:03:08.877","LASTSTATUS":"Coming Soon","STREETNAME":"Mayflower","STREETNUMBER":"2427","STREETSUFFIX":"Avenue","STYLE":"Single Family","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1977,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2026-08-06T02:54:06.235","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"Custom walkout two-story tucked into nearly an acre of peaceful, wooded privacy. A truly special setting with beautiful outdoor spaces for relaxing, entertaining and enjoying nature.\"},{\"Order\":2,\"Remarks\":\"Dramatic rear elevation showcasing the home’s custom architecture and expansive walkout design. Surrounded by mature trees, this private wooded setting feels peaceful, secluded and truly one-of-a-kind.\"},{\"Order\":3,\"Remarks\":\"Bright, functional kitchen featuring crisp white cabinetry, stainless steel appliances and a spacious center island. Abundant storage and generous workspace make meal preparation and everyday living effortless.\"},{\"Order\":4,\"Remarks\":\"Open-concept kitchen and dining area offering plenty of room for casual meals, homework or gathering with family and friends. Warm wood floors, abundant cabinetry and flexible seating create a bright, comfortable everyday space.\"},{\"Order\":5,\"Remarks\":\"Spacious center island provides additional prep space, storage and a natural gathering place in the heart of the home. A distinctive hanging pot rack adds both function and character above the warm butcher-block surface.\"},{\"Order\":6,\"Remarks\":\"Elegant formal dining room offering generous space to comfortably seat eight for holidays, celebrations and everyday gatherings.\"},{\"Order\":7,\"Remarks\":\"The exposed brick wall creates a striking architectural connection between the formal dining room and adjoining living spaces. An open, inviting layout makes entertaining effortless while preserving warmth, character and defined gathering areas.\"},{\"Order\":8,\"Remarks\":\"Soaring wood-plank ceilings and dramatic windows create an unforgettable living room filled with natural light and wooded views.\\nA spacious gathering area with room to relax, entertain and enjoy the home’s distinctive architectural character.\"},{\"Order\":10,\"Remarks\":\"Virtually staged this versatile main-level office or flex room featuring custom built-ins and abundant natural light. This adaptable space could also serve beautifully as a main-level bedroom.\"},{\"Order\":11,\"Remarks\":\"Sun-filled four-season porch surrounded by expansive windows showcasing peaceful, panoramic wooded views. A serene retreat for morning coffee, reading or simply enjoying nature in every season.\"},{\"Order\":12,\"Remarks\":\"Convenient access from the four-season porch leads directly to the private backyard and wooded surroundings. A bright, versatile space that beautifully connects indoor comfort with peaceful outdoor living.\"},{\"Order\":13,\"Remarks\":\"Spacious primary bedroom offering a peaceful retreat with room for a king-sized bed and additional furnishings. Dual closets and and generous floor space provide comfort, storage and everyday functionality.\"},{\"Order\":14,\"Remarks\":\"Currently staged as a charming nursery, this storybook space could become a dream dollhouse bedroom or imaginative tree-fort retreat. Warm wood ceilings, cozy angles and whimsical character make it a bedroom you will never forget.\"},{\"Order\":15,\"Remarks\":\"Secondary bedroom virtually staged.\"},{\"Order\":16,\"Remarks\":\"Secondary bedroom virtually staged.\"},{\"Order\":17,\"Remarks\":\"The lower-level amusement room featuring a full bar, dramatic brick fireplace and warm wood-plank ceiling. Designed for entertaining, with virtual staged gathering areas for game nights, movie nights and relaxed evenings at home.\"},{\"Order\":18,\"Remarks\":\"Virtually staged lower-level flex space offering generous room for recreation, hobbies, play or additional everyday living ready to adapt to a variety of needs.\"},{\"Order\":19,\"Remarks\":\"Beautifully updated bathroom featuring a sleek vanity, stylish finishes and a spacious glass-enclosed shower. A fresh, modern space designed for comfort, convenience and everyday functionality.\"},{\"Order\":20,\"Remarks\":\"Frameless glass shower doors, recessed shelving and recessed lighting create a sleek, beautifully updated bathing space. Walls of storage and a vanity area with natural light overlook the private backyard provides the perfect way to start your day.\"},{\"Order\":21,\"Remarks\":\"Walls of custom storage and generous counter space provide exceptional organization and everyday convenience. This charming area could also become a private morning retreat with a coffee bar overlooking the peaceful backyard.\"},{\"Order\":22,\"Remarks\":\"Upper level full bathroom with updated vanity and fixtures.\"},{\"Order\":23,\"Remarks\":\"Main level guest bathroom with updated vanity and fixtures.\"},{\"Order\":24,\"Remarks\":\"Spacious laundry room with front load washer and dryer. Convenient utility sink and plenty of cabinetry makes laundry day a breeze!\"},{\"Order\":25,\"Remarks\":\"Large mudroom with space for everything and everything in its place. Durable tile flooring throughout. Direct access to the outside.\"},{\"Order\":26,\"Remarks\":\"Spacious stone patio welcomes your guests to your front door.\"},{\"Order\":27,\"Remarks\":\"Convenient side loading two-car heated garage.\"}]","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","SOURCE":"MG_NST"}
{"ListingKey":"NST7892301","NST_AboveGradeSqFtTotal":"2239","AboveGradeFinishedArea":"2239","AccessibilityFeatures":"None","AdditionalParcelsYN":"False","NST_AgentOwner":"No","Appliances":"Chandelier,Dishwasher,Dryer,Microwave,Range,Refrigerator,Stainless Steel Appliances,Washer","LivingAreaUnits":"Square Feet","NST_AssessmentPending":"No","AssociationYN":"False","AssociationFee":"0","Basement":"Block,Daylight/Lookout Windows,Finished,Walkout","BasementYN":"True","NST_BathDesc":"3/4 Primary,Full Basement,His and Her Closets ,Main Floor 1/2 Bath,Other,Upper Level Full Bath","BathroomsFull":"2","BathroomsHalf":"1","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"1","BathroomsTotalInteger":"4","BedroomsTotal":"4","NST_BelowGradeSqFtTotal":"1116","BelowGradeFinishedArea":"895","CumulativeDaysOnMarket":"0","City":"Hopkins","ConstructionMaterials":"Block,Frame","NewConstructionYN":"False","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Hennepin","NST_DPResource":"Yes","Directions":"Cedar Lake Rd to Mayflower Ave N to home.","DocumentsCount":"1","DocumentsChangeTimestamp":"2026-08-05T20:22:06.865Z","DaysOnMarket":"0","Electric":"Circuit Breakers","NST_ExpectedMarketDate":"2026-08-06","ExteriorFeatures":"Cedar","FireplaceFeatures":"Family Room,Living Room,Wood Burning","FireplaceYN":"True","FireplacesTotal":"2","FoundationArea":"1947","FoundationDetails":"Block","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","NST_GarageSquareFeet":"528","GarageSpaces":"2","Heating":"Forced Air","HighSchoolDistrict":"Hopkins","NST_ForeclosureStatus":"No","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"False","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","Latitude":"44.956978","LaundryFeatures":"Gas Dryer Hookup,Lower Level,Main Level,Sink,Washer Hookup","NST_LenderOwned":"No","Levels":"Two","ListPrice":"725000","ListingContractDate":"2026-08-05T05:00:00Z","ListingId":"NST7063354","LivingArea":"3134","LockBoxType":"Supra","Longitude":"-93.430732","LotFeatures":"Public Transit (w/in 6 blks),Tree Coverage - Medium","LotSizeArea":"0.78","LotSizeDimensions":"100X302","LotSizeUnits":"Acres","NST_MainLevelFinishedArea":"1369","NST_ManufacturedHome":"N","OriginalEntryTimestamp":"2026-08-06T00:00:15Z","ParcelNumber":"1111722130039","ParkingFeatures":"Attached Garage,Asphalt,Garage Door Opener,Heated Garage","NST_PatioPorchType":"Patio,Rear Porch","PhotosCount":"27","PhotosChangeTimestamp":"2026-08-06T02:54:06.235Z","PostalCity":"Hopkins","PostalCode":"55305","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PropertyAttachedYN":"False","PropertySubType":"Single Family","PropertyType":"Residential","PublicRemarks":"Anything but ordinary, this enchanting custom home is filled with character, versatility and unexpected spaces around every corner. Tucked away on nearly an acre of wooded privacy in an upscale neighborhood, this custom-built 4-bedroom, 4-bathroom, 2-car home offers a rare blend of space, character and versatility. Soaring wood-plank vaulted ceilings, dramatic architectural lines and expansive windows bring the outdoors in, creating warm and inviting spaces for everyday living and entertaining.\n\nThe kitchen features white cabinetry, stainless steel appliances, a center island and an adjoining dining area, while the impressive living room is anchored by a striking brick fireplace. A sun-filled four-season porch offers panoramic wooded views and direct access to the private backyard.\n\nFlexible room options allow the home to adapt beautifully to your lifestyle. The main-level office with custom built-ins could also serve as a bedroom, study or creative space. Upstairs, a charming secondary bedroom with cozy angles and wood ceilings could become a dream dollhouse room, tree-fort retreat or nursery. The spacious primary suite includes an updated bathroom, walls of storage and a private vanity area that could even accommodate a morning coffee bar overlooking the backyard. Additional secondary bedroom on this upper level. \n\nThe lower level provides even more room to enjoy with an amusement area, full bar, fireplace and versatile flex space ideal for recreation, hobbies, a playroom or home gym and another spacious bedroom. Generous sized bedrooms throughout, beautifully finished bathrooms and multiple gathering spaces make this home as functional as it is memorable. See it today before it is gone!","PublicSurveyRange":"22","PublicSurveySection":"11","PublicSurveyTownship":"117","RoadFrontageType":"City Street,Paved Streets","RoadResponsibility":"Public Maintained Road","Roof":"Age Over 8 Years,Pitched","NST_SchoolDistrictFullName":"270 - Hopkins","NST_SchoolDistrictNumber":"270","NST_SchoolDistrictPhone":"9529884000","Sewer":"City Sewer/Connected","NST_SpecialSearch":"3 BR on One Level,Main Floor Laundry,Primary Bdr Suite","StandardStatus":"Active","StateOrProvince":"MN","StreetName":"Mayflower","StreetNumber":"2427","StreetNumberNumeric":"2427","StreetSuffix":"Avenue","SubdivisionName":"Sherwood Oaks","TaxAnnualAmount":"8340","NST_TaxWithAssessments":"8340","TaxYear":"2025","NST_TotalArea":"3355","BuildingAreaTotal":"3355","Township":"Minnetonka","VideosCount":"0","WaterSource":"City Water/Connected","WaterfrontYN":"False","YearBuilt":"1977","ZoningDescription":"Residential-Single Family","ListAgentKey":"NST80909","ListAgentMlsId":"NST502033130","ListOfficeMlsId":"NST1865","ListOfficeName":"Keller Williams Classic Realty","ListOfficeKey":"NST14003","ModificationTimestamp":"2026-08-06T10:18:08.973Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7892301\",\"LongDescription\":\"Beautifully updated bathroom featuring a sleek vanity, stylish finishes and a spacious glass-enclosed shower. A fresh, modern space designed for comfort, convenience and everyday functionality.\",\"Order\":19,\"MediaObjectID\":\"NST19\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7892301/7ec78a5a-727a-4adf-8412-5a359a4a6b03.jpeg\",\"ImageWidth\":1024,\"ImageHeight\":683,\"ImageSizeDescription\":\"1024x683\",\"MediaModificationTimestamp\":\"2026-08-06T02:53:06.557Z\",\"MediaKey\":\"NST124074363\"},{\"ResourceRecordKey\":\"NST7892301\",\"LongDescription\":\"Large mudroom with space for everything and everything in its place. Durable tile flooring throughout. Direct access to the outside.\",\"Order\":25,\"MediaObjectID\":\"NST25\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7892301/09619c45-0403-4770-9a2c-b02195004435.jpeg\",\"ImageWidth\":2038,\"ImageHeight\":1361,\"ImageSizeDescription\":\"2038x1361\",\"MediaModificationTimestamp\":\"2026-08-06T02:53:06.567Z\",\"MediaKey\":\"NST124079250\"},{\"ResourceRecordKey\":\"NST7892301\",\"LongDescription\":\"Upper level full bathroom with updated vanity and fixtures.\",\"Order\":22,\"MediaObjectID\":\"NST22\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7892301/c6734fbe-f414-48dc-8622-8017d4dcb9d1.jpeg\",\"ImageWidth\":2038,\"ImageHeight\":1361,\"ImageSizeDescription\":\"2038x1361\",\"MediaModificationTimestamp\":\"2026-08-06T02:53:06.598Z\",\"MediaKey\":\"NST124024778\"},{\"ResourceRecordKey\":\"NST7892301\",\"LongDescription\":\"Walls of custom storage and generous counter space provide exceptional organization and everyday convenience. This charming area could also become a private morning retreat with a coffee bar overlooking the peaceful backyard.\",\"Order\":21,\"MediaObjectID\":\"NST21\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7892301/ddfe7ee8-9d98-46c2-afc1-51a7c5b6c213.jpeg\",\"ImageWidth\":1024,\"ImageHeight\":683,\"ImageSizeDescription\":\"1024x683\",\"MediaModificationTimestamp\":\"2026-08-06T02:53:06.545Z\",\"MediaKey\":\"NST124049486\"},{\"ResourceRecordKey\":\"NST7892301\",\"LongDescription\":\"Main level guest bathroom with updated vanity and fixtures.\",\"Order\":23,\"MediaObjectID\":\"NST23\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7892301/86f5d3c3-fa40-4160-a5ad-3bd90308dee3.jpeg\",\"ImageWidth\":2038,\"ImageHeight\":1361,\"ImageSizeDescription\":\"2038x1361\",\"MediaModificationTimestamp\":\"2026-08-06T02:53:06.59Z\",\"MediaKey\":\"NST124079251\"},{\"ResourceRecordKey\":\"NST7892301\",\"LongDescription\":\"Sun-filled four-season porch surrounded by expansive windows showcasing peaceful, panoramic wooded views. A serene retreat for morning coffee, reading or simply enjoying nature in every season.\",\"Order\":11,\"MediaObjectID\":\"NST11\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7892301/0af13427-051e-4841-aba3-af5c103d883c.jpeg\",\"ImageWidth\":2038,\"ImageHeight\":1361,\"ImageSizeDescription\":\"2038x1361\",\"MediaModificationTimestamp\":\"2026-08-06T02:53:06.567Z\",\"MediaKey\":\"NST124024785\"},{\"ResourceRecordKey\":\"NST7892301\",\"LongDescription\":\"Frameless glass shower doors, recessed shelving and recessed lighting create a sleek, beautifully updated bathing space. Walls of storage and a vanity area with natural light overlook the private backyard provides the perfect way to start your day.\",\"Order\":20,\"MediaObjectID\":\"NST20\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7892301/aa1d776b-e883-4d48-896f-dff4e057723e.jpeg\",\"ImageWidth\":2038,\"ImageHeight\":1361,\"ImageSizeDescription\":\"2038x1361\",\"MediaModificationTimestamp\":\"2026-08-06T02:53:06.589Z\",\"MediaKey\":\"NST124024798\"},{\"ResourceRecordKey\":\"NST7892301\",\"LongDescription\":\"Dramatic rear elevation showcasing the home’s custom architecture and expansive walkout design. Surrounded by mature trees, this private wooded setting feels peaceful, secluded and truly one-of-a-kind.\",\"Order\":2,\"MediaObjectID\":\"NST2\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7892301/e13b3b43-32fb-4ab3-a8d9-272e7b5316c5.jpeg\",\"ImageWidth\":2038,\"ImageHeight\":1529,\"ImageSizeDescription\":\"2038x1529\",\"MediaModificationTimestamp\":\"2026-08-05T05:11:06.102Z\",\"MediaKey\":\"NST124024799\"},{\"ResourceRecordKey\":\"NST7892301\",\"LongDescription\":\"Spacious stone patio welcomes your guests to your front door.\",\"Order\":26,\"MediaObjectID\":\"NST26\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7892301/ba3e29ca-c393-4e62-b9fa-e5712541c815.jpeg\",\"ImageWidth\":2038,\"ImageHeight\":1361,\"ImageSizeDescription\":\"2038x1361\",\"MediaModificationTimestamp\":\"2026-08-06T02:53:06.575Z\",\"MediaKey\":\"NST124024810\"},{\"ResourceRecordKey\":\"NST7892301\",\"LongDescription\":\"Convenient side loading two-car heated garage.\",\"Order\":27,\"MediaObjectID\":\"NST27\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7892301/0c0dd5b5-06f9-4baf-b7af-2e393bf2bb93.jpeg\",\"ImageWidth\":2038,\"ImageHeight\":1361,\"ImageSizeDescription\":\"2038x1361\",\"MediaModificationTimestamp\":\"2026-08-06T02:53:06.601Z\",\"MediaKey\":\"NST124024767\"},{\"ResourceRecordKey\":\"NST7892301\",\"LongDescription\":\"Spacious center island provides additional prep space, storage and a natural gathering place in the heart of the home. A distinctive hanging pot rack adds both function and character above the warm butcher-block surface.\",\"Order\":5,\"MediaObjectID\":\"NST5\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7892301/7b00da54-209e-43b2-ba84-ecdb3f1d6086.jpeg\",\"ImageWidth\":2038,\"ImageHeight\":1361,\"ImageSizeDescription\":\"2038x1361\",\"MediaModificationTimestamp\":\"2026-08-06T02:53:06.562Z\",\"MediaKey\":\"NST124079252\"},{\"ResourceRecordKey\":\"NST7892301\",\"LongDescription\":\"Custom walkout two-story tucked into nearly an acre of peaceful, wooded privacy. A truly special setting with beautiful outdoor spaces for relaxing, entertaining and enjoying nature.\",\"Order\":1,\"MediaObjectID\":\"NST1\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7892301/9de4b133-6ca6-4753-95a5-b5dbaebf8a86.jpeg\",\"ImageWidth\":2038,\"ImageHeight\":1361,\"ImageSizeDescription\":\"2038x1361\",\"MediaModificationTimestamp\":\"2026-08-05T05:11:06.077Z\",\"MediaKey\":\"NST124024781\"},{\"ResourceRecordKey\":\"NST7892301\",\"LongDescription\":\"Convenient access from the four-season porch leads directly to the private backyard and wooded surroundings. A bright, versatile space that beautifully connects indoor comfort with peaceful outdoor living.\",\"Order\":12,\"MediaObjectID\":\"NST12\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7892301/18ea8cc0-b392-4f9d-9f3f-db70e4cbc39a.jpeg\",\"ImageWidth\":2038,\"ImageHeight\":1361,\"ImageSizeDescription\":\"2038x1361\",\"MediaModificationTimestamp\":\"2026-08-06T02:53:06.59Z\",\"MediaKey\":\"NST124079254\"},{\"ResourceRecordKey\":\"NST7892301\",\"LongDescription\":\"Spacious laundry room with front load washer and dryer. Convenient utility sink and plenty of cabinetry makes laundry day a breeze!\",\"Order\":24,\"MediaObjectID\":\"NST24\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7892301/fbdb78b2-55f9-407d-af00-41b3bb0049a2.jpeg\",\"ImageWidth\":2038,\"ImageHeight\":1361,\"ImageSizeDescription\":\"2038x1361\",\"MediaModificationTimestamp\":\"2026-08-06T02:53:06.568Z\",\"MediaKey\":\"NST124079397\"},{\"ResourceRecordKey\":\"NST7892301\",\"LongDescription\":\"Bright, functional kitchen featuring crisp white cabinetry, stainless steel appliances and a spacious center island. Abundant storage and generous workspace make meal preparation and everyday living effortless.\",\"Order\":3,\"MediaObjectID\":\"NST3\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7892301/f9232ea5-2dd2-445a-917f-88fd7b3d77f0.jpeg\",\"ImageWidth\":2038,\"ImageHeight\":1361,\"ImageSizeDescription\":\"2038x1361\",\"MediaModificationTimestamp\":\"2026-08-06T02:53:06.548Z\",\"MediaKey\":\"NST124079399\"},{\"ResourceRecordKey\":\"NST7892301\",\"LongDescription\":\"Secondary bedroom virtually staged.\",\"Order\":16,\"MediaObjectID\":\"NST16\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7892301/fccc0702-bed5-42af-beab-b1daef5555ae.jpeg\",\"ImageWidth\":1448,\"ImageHeight\":1086,\"ImageSizeDescription\":\"1448x1086\",\"MediaModificationTimestamp\":\"2026-08-06T02:53:06.718Z\",\"MediaKey\":\"NST124049458\"},{\"ResourceRecordKey\":\"NST7892301\",\"LongDescription\":\"Virtually staged lower-level flex space offering generous room for recreation, hobbies, play or additional everyday living ready to adapt to a variety of needs.\",\"Order\":18,\"MediaObjectID\":\"NST18\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7892301/42bd3e06-75ce-43b0-8c86-c62b290c0647.jpeg\",\"ImageWidth\":1448,\"ImageHeight\":1086,\"ImageSizeDescription\":\"1448x1086\",\"MediaModificationTimestamp\":\"2026-08-06T02:53:06.72Z\",\"MediaKey\":\"NST124049494\"},{\"ResourceRecordKey\":\"NST7892301\",\"LongDescription\":\"The lower-level amusement room featuring a full bar, dramatic brick fireplace and warm wood-plank ceiling. Designed for entertaining, with virtual staged gathering areas for game nights, movie nights and relaxed evenings at home.\",\"Order\":17,\"MediaObjectID\":\"NST17\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7892301/89d81434-d242-4370-8fb4-d818251be4a2.jpeg\",\"ImageWidth\":1448,\"ImageHeight\":1086,\"ImageSizeDescription\":\"1448x1086\",\"MediaModificationTimestamp\":\"2026-08-06T02:53:06.77Z\",\"MediaKey\":\"NST124049462\"},{\"ResourceRecordKey\":\"NST7892301\",\"LongDescription\":\"Elegant formal dining room offering generous space to comfortably seat eight for holidays, celebrations and everyday gatherings.\",\"Order\":6,\"MediaObjectID\":\"NST6\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7892301/dcc025b9-8cfd-49ae-831b-da07928baa5b.jpeg\",\"ImageWidth\":1535,\"ImageHeight\":1024,\"ImageSizeDescription\":\"1535x1024\",\"MediaModificationTimestamp\":\"2026-08-06T02:53:06.709Z\",\"MediaKey\":\"NST124049469\"},{\"ResourceRecordKey\":\"NST7892301\",\"LongDescription\":\"Virtually staged this versatile main-level office or flex room featuring custom built-ins and abundant natural light. This adaptable space could also serve beautifully as a main-level bedroom.\",\"Order\":10,\"MediaObjectID\":\"NST10\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7892301/f2d3b81d-3059-4fcb-88c0-42d5b4228082.jpeg\",\"ImageWidth\":1254,\"ImageHeight\":1254,\"ImageSizeDescription\":\"1254x1254\",\"MediaModificationTimestamp\":\"2026-08-06T02:53:06.738Z\",\"MediaKey\":\"NST124049461\"},{\"ResourceRecordKey\":\"NST7892301\",\"LongDescription\":\"Secondary bedroom virtually staged.\",\"Order\":15,\"MediaObjectID\":\"NST15\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7892301/56ed5143-c9d1-41af-bbb6-f3ed345cfc4d.jpeg\",\"ImageWidth\":1448,\"ImageHeight\":1086,\"ImageSizeDescription\":\"1448x1086\",\"MediaModificationTimestamp\":\"2026-08-06T02:53:06.645Z\",\"MediaKey\":\"NST124049460\"},{\"ResourceRecordKey\":\"NST7892301\",\"LongDescription\":\"Currently staged as a charming nursery, this storybook space could become a dream dollhouse bedroom or imaginative tree-fort retreat. Warm wood ceilings, cozy angles and whimsical character make it a bedroom you will never forget.\",\"Order\":14,\"MediaObjectID\":\"NST14\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7892301/2b002e7d-4b73-4d52-b090-5738a626e17b.jpeg\",\"ImageWidth\":1448,\"ImageHeight\":1086,\"ImageSizeDescription\":\"1448x1086\",\"MediaModificationTimestamp\":\"2026-08-06T02:53:06.688Z\",\"MediaKey\":\"NST124049467\"},{\"ResourceRecordKey\":\"NST7892301\",\"LongDescription\":\"Open-concept kitchen and dining area offering plenty of room for casual meals, homework or gathering with family and friends. Warm wood floors, abundant cabinetry and flexible seating create a bright, comfortable everyday space.\",\"Order\":4,\"MediaObjectID\":\"NST4\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7892301/59a4e32c-d425-410a-9a4e-5b8c6345ed6e.jpeg\",\"ImageWidth\":1535,\"ImageHeight\":1024,\"ImageSizeDescription\":\"1535x1024\",\"MediaModificationTimestamp\":\"2026-08-06T02:53:06.691Z\",\"MediaKey\":\"NST124049464\"},{\"ResourceRecordKey\":\"NST7892301\",\"LongDescription\":\"The exposed brick wall creates a striking architectural connection between the formal dining room and adjoining living spaces. An open, inviting layout makes entertaining effortless while preserving warmth, character and defined gathering areas.\",\"Order\":7,\"MediaObjectID\":\"NST7\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7892301/167d9ded-66d1-4095-ac6e-57444fd46cfd.jpeg\",\"ImageWidth\":1535,\"ImageHeight\":1024,\"ImageSizeDescription\":\"1535x1024\",\"MediaModificationTimestamp\":\"2026-08-06T02:53:06.692Z\",\"MediaKey\":\"NST124049468\"},{\"ResourceRecordKey\":\"NST7892301\",\"Order\":9,\"MediaObjectID\":\"NST9\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7892301/169c7ba8-7e47-47c0-a577-2f54b52eb53c.jpeg\",\"ImageWidth\":1448,\"ImageHeight\":1086,\"ImageSizeDescription\":\"1448x1086\",\"MediaModificationTimestamp\":\"2026-08-06T02:53:06.674Z\",\"MediaKey\":\"NST124049493\"},{\"ResourceRecordKey\":\"NST7892301\",\"LongDescription\":\"Spacious primary bedroom offering a peaceful retreat with room for a king-sized bed and additional furnishings. Dual closets and and generous floor space provide comfort, storage and everyday functionality.\",\"Order\":13,\"MediaObjectID\":\"NST13\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7892301/6aff4dc4-2ad8-4594-9736-c3fd583d06ad.jpeg\",\"ImageWidth\":1448,\"ImageHeight\":1086,\"ImageSizeDescription\":\"1448x1086\",\"MediaModificationTimestamp\":\"2026-08-06T02:53:06.692Z\",\"MediaKey\":\"NST124049466\"},{\"ResourceRecordKey\":\"NST7892301\",\"LongDescription\":\"Soaring wood-plank ceilings and dramatic windows create an unforgettable living room filled with natural light and wooded views.\\nA spacious gathering area with room to relax, entertain and enjoy the home’s distinctive architectural character.\",\"Order\":8,\"MediaObjectID\":\"NST8\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7892301/0fb7fe66-75ab-4234-840f-dfd66f2fbcb8.jpeg\",\"ImageWidth\":1448,\"ImageHeight\":1086,\"ImageSizeDescription\":\"1448x1086\",\"MediaModificationTimestamp\":\"2026-08-06T02:53:06.69Z\",\"MediaKey\":\"NST124049706\"}]","Media__ResourceRecordKey":"NST7892301","Media__LongDescription":"Beautifully updated bathroom featuring a sleek vanity, stylish finishes and a spacious glass-enclosed shower. A fresh, modern space designed for comfort, convenience and everyday functionality.","Media__Order":"19","Media__MediaObjectID":"NST19","Media__MediaURL":"https://s3.amazonaws.com/mlsgrid/images/NST7892301/7ec78a5a-727a-4adf-8412-5a359a4a6b03.jpeg","Media__ImageWidth":"1024","Media__ImageHeight":"683","Media__ImageSizeDescription":"1024x683","Media__MediaModificationTimestamp":"8/6/2026 2:53:06 AM","Media__MediaKey":"NST124074363","Rooms":"[{\"RoomLevel\":\"Lower\",\"RoomDimensions\":\"19.11X14.6\",\"NST_RoomSortOrder\":5,\"RoomType\":\"Amusement Room\",\"RoomKey\":\"NST116537241\"},{\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"7.1X7.4\",\"NST_RoomSortOrder\":15,\"RoomType\":\"Bathroom\",\"RoomKey\":\"NST116537251\"},{\"RoomLevel\":\"Main\",\"RoomDimensions\":\"5.1X4.11\",\"NST_RoomSortOrder\":16,\"RoomType\":\"Bathroom\",\"RoomKey\":\"NST116537460\"},{\"RoomLevel\":\"Lower\",\"RoomDimensions\":\"5.2X7.4\",\"NST_RoomSortOrder\":17,\"RoomType\":\"Bathroom\",\"RoomKey\":\"NST116537461\"},{\"RoomLevel\":\"Main\",\"RoomDimensions\":\"18.6X11.11\",\"NST_RoomSortOrder\":4,\"RoomType\":\"Dining Room\",\"RoomKey\":\"NST116537240\"},{\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"11.9X16.8\",\"NST_RoomSortOrder\":6,\"RoomType\":\"Bedroom\",\"RoomKey\":\"NST116537242\"},{\"RoomLevel\":\"Lower\",\"RoomDimensions\":\"20.8X15.9\",\"NST_RoomSortOrder\":12,\"RoomType\":\"Flex Room\",\"RoomKey\":\"NST116537248\"},{\"RoomLevel\":\"Main\",\"RoomDimensions\":\"16.7X11.12\",\"NST_RoomSortOrder\":11,\"RoomType\":\"Four Season Porch\",\"RoomKey\":\"NST116537247\"},{\"RoomLevel\":\"Lower\",\"RoomDimensions\":\"13.11X9.10\",\"NST_RoomSortOrder\":9,\"RoomType\":\"Bedroom 4\",\"RoomKey\":\"NST116537245\"},{\"RoomLevel\":\"Main\",\"RoomDimensions\":\"16.1X10.9\",\"NST_RoomSortOrder\":13,\"RoomType\":\"Foyer\",\"RoomKey\":\"NST116537249\"},{\"RoomLevel\":\"Main\",\"RoomDimensions\":\"8.3X14.1\",\"NST_RoomSortOrder\":3,\"RoomType\":\"Informal Dining Room\",\"RoomKey\":\"NST116537239\"},{\"RoomLevel\":\"Main\",\"RoomDimensions\":\"10.9X14.1\",\"NST_RoomSortOrder\":2,\"RoomType\":\"Kitchen\",\"RoomKey\":\"NST116537238\"},{\"RoomLevel\":\"Main\",\"RoomDimensions\":\"7.5X11.8\",\"NST_RoomSortOrder\":19,\"RoomType\":\"Laundry\",\"RoomKey\":\"NST116537463\"},{\"RoomLevel\":\"Main\",\"RoomDimensions\":\"18.6X14.6\",\"NST_RoomSortOrder\":1,\"RoomType\":\"Living Room\",\"RoomKey\":\"NST116537237\"},{\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"7.1X7.4\",\"NST_RoomSortOrder\":14,\"RoomType\":\"Primary Bathroom\",\"RoomKey\":\"NST116537250\"},{\"RoomLevel\":\"Main\",\"RoomDimensions\":\"5.9X7.10\",\"NST_RoomSortOrder\":20,\"RoomType\":\"Mud Room\",\"RoomKey\":\"NST116537464\"},{\"RoomLevel\":\"Main\",\"RoomDimensions\":\"12.12X16.3\",\"NST_RoomSortOrder\":10,\"RoomType\":\"Office\",\"RoomKey\":\"NST116537246\"},{\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"16.8X15.2\",\"NST_RoomSortOrder\":7,\"RoomType\":\"Bedroom 2\",\"RoomKey\":\"NST116537243\"},{\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"11.6X12.8\",\"NST_RoomSortOrder\":8,\"RoomType\":\"Bedroom 3\",\"RoomKey\":\"NST116537244\"},{\"RoomLevel\":\"Lower\",\"RoomDimensions\":\"5.2X10.6\",\"NST_RoomSortOrder\":21,\"RoomType\":\"Utility Room\",\"RoomKey\":\"NST116537465\"},{\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"7.2X9.10\",\"NST_RoomSortOrder\":18,\"RoomType\":\"Walk-In Closet\",\"RoomKey\":\"NST116537462\"}]","Rooms__RoomLevel":"Lower","Rooms__RoomDimensions":"19.11X14.6","Rooms__NST_RoomSortOrder":"5","Rooms__RoomType":"Amusement Room","Rooms__RoomKey":"NST116537241","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"Custom walkout two-story tucked into nearly an acre of peaceful, wooded privacy. A truly special setting with beautiful outdoor spaces for relaxing, entertaining and enjoying nature.\"},{\"Order\":2,\"Remarks\":\"Dramatic rear elevation showcasing the home’s custom architecture and expansive walkout design. Surrounded by mature trees, this private wooded setting feels peaceful, secluded and truly one-of-a-kind.\"},{\"Order\":3,\"Remarks\":\"Bright, functional kitchen featuring crisp white cabinetry, stainless steel appliances and a spacious center island. Abundant storage and generous workspace make meal preparation and everyday living effortless.\"},{\"Order\":4,\"Remarks\":\"Open-concept kitchen and dining area offering plenty of room for casual meals, homework or gathering with family and friends. Warm wood floors, abundant cabinetry and flexible seating create a bright, comfortable everyday space.\"},{\"Order\":5,\"Remarks\":\"Spacious center island provides additional prep space, storage and a natural gathering place in the heart of the home. A distinctive hanging pot rack adds both function and character above the warm butcher-block surface.\"},{\"Order\":6,\"Remarks\":\"Elegant formal dining room offering generous space to comfortably seat eight for holidays, celebrations and everyday gatherings.\"},{\"Order\":7,\"Remarks\":\"The exposed brick wall creates a striking architectural connection between the formal dining room and adjoining living spaces. An open, inviting layout makes entertaining effortless while preserving warmth, character and defined gathering areas.\"},{\"Order\":8,\"Remarks\":\"Soaring wood-plank ceilings and dramatic windows create an unforgettable living room filled with natural light and wooded views.\\nA spacious gathering area with room to relax, entertain and enjoy the home’s distinctive architectural character.\"},{\"Order\":10,\"Remarks\":\"Virtually staged this versatile main-level office or flex room featuring custom built-ins and abundant natural light. This adaptable space could also serve beautifully as a main-level bedroom.\"},{\"Order\":11,\"Remarks\":\"Sun-filled four-season porch surrounded by expansive windows showcasing peaceful, panoramic wooded views. A serene retreat for morning coffee, reading or simply enjoying nature in every season.\"},{\"Order\":12,\"Remarks\":\"Convenient access from the four-season porch leads directly to the private backyard and wooded surroundings. A bright, versatile space that beautifully connects indoor comfort with peaceful outdoor living.\"},{\"Order\":13,\"Remarks\":\"Spacious primary bedroom offering a peaceful retreat with room for a king-sized bed and additional furnishings. Dual closets and and generous floor space provide comfort, storage and everyday functionality.\"},{\"Order\":14,\"Remarks\":\"Currently staged as a charming nursery, this storybook space could become a dream dollhouse bedroom or imaginative tree-fort retreat. Warm wood ceilings, cozy angles and whimsical character make it a bedroom you will never forget.\"},{\"Order\":15,\"Remarks\":\"Secondary bedroom virtually staged.\"},{\"Order\":16,\"Remarks\":\"Secondary bedroom virtually staged.\"},{\"Order\":17,\"Remarks\":\"The lower-level amusement room featuring a full bar, dramatic brick fireplace and warm wood-plank ceiling. Designed for entertaining, with virtual staged gathering areas for game nights, movie nights and relaxed evenings at home.\"},{\"Order\":18,\"Remarks\":\"Virtually staged lower-level flex space offering generous room for recreation, hobbies, play or additional everyday living ready to adapt to a variety of needs.\"},{\"Order\":19,\"Remarks\":\"Beautifully updated bathroom featuring a sleek vanity, stylish finishes and a spacious glass-enclosed shower. A fresh, modern space designed for comfort, convenience and everyday functionality.\"},{\"Order\":20,\"Remarks\":\"Frameless glass shower doors, recessed shelving and recessed lighting create a sleek, beautifully updated bathing space. Walls of storage and a vanity area with natural light overlook the private backyard provides the perfect way to start your day.\"},{\"Order\":21,\"Remarks\":\"Walls of custom storage and generous counter space provide exceptional organization and everyday convenience. This charming area could also become a private morning retreat with a coffee bar overlooking the peaceful backyard.\"},{\"Order\":22,\"Remarks\":\"Upper level full bathroom with updated vanity and fixtures.\"},{\"Order\":23,\"Remarks\":\"Main level guest bathroom with updated vanity and fixtures.\"},{\"Order\":24,\"Remarks\":\"Spacious laundry room with front load washer and dryer. Convenient utility sink and plenty of cabinetry makes laundry day a breeze!\"},{\"Order\":25,\"Remarks\":\"Large mudroom with space for everything and everything in its place. Durable tile flooring throughout. Direct access to the outside.\"},{\"Order\":26,\"Remarks\":\"Spacious stone patio welcomes your guests to your front door.\"},{\"Order\":27,\"Remarks\":\"Convenient side loading two-car heated garage.\"}]","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","CustomVTourURL":""}
$MLSDESCRIPTION$
2427 Mayflower Avenue Hopkins, MN 55305
$WATERFRONT$
$LISTPRICE$$HOTDATA$
$STATUS$ | Contingent
$MLSNUMBERSHOW$
$SUMMARY1$
$FULLDATA$
$MLSDESCRIPTION$
2427 Mayflower Avenue Hopkins, MN 55305
$WATERFRONT$
$LISTPRICE$$HOTDATA$
$STATUS$ | Contingent
$MLSNUMBERSHOW$
$SUMMARY1$
$FULLDATA$
$MLSDESCRIPTION$
2427 Mayflower Avenue Hopkins, MN 55305
$WATERFRONT$
$LISTPRICE$$HOTDATA$
$STATUS$ | Contingent
$MLSNUMBERSHOW$
$SUMMARY1$
$FULLDATA$
$MLSDESCRIPTION$
2427 Mayflower Avenue Hopkins, MN 55305
$WATERFRONT$
$LISTPRICE$$HOTDATA$
$STATUS$
$MLSNUMBERSHOW$
$SUMMARY1$
$FULLDATA$





