MLS# 7089242 - 15485 Farnham Avenue N Hugo, MN 55038

Neighborhoods

Edina Realty, Inc. is the brokerage office representing the seller for this listing.

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. Kevin Kruchten is not a multiple Listing Service (MLS), nor does it offer MLS access. This website is a service of Kevin Kruchten, a broker Participant of the Regional Multiple Listing Service of Minnesota, Inc.

{"Id":569756,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST7089242","MLSAGENTID":"NST506004730","MLSOFFICEID":"NST8769","ADDRESS":"15485 Farnham Avenue N","ACRES":0.055,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Daylight/Lookout Windows,Drain Tiled,Full,Storage Space,Sump Pump,Walkout","BATHSTOTAL":3.0,"BEDROOMS":3.0,"CITY":"Hugo","CONTINGENCY":"None","COUNTY":"Washington","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"FORECLOSURE":"No","LAKEWATERFRONT":"Pond","LASTPRICE":299900.0,"LASTPRICEDATE":"2026-06-09T17:03:06.807","LATITUDE":45.174295,"LENDEROWNED":"No","LISTDATE":"2026-06-09T05:00:00","LISTPRICE":299900.0,"LIVINGAREA":1567.0,"LONGITUDE":-93.003036,"LOTDESCRIPTION":"Corner Lot,Tree Coverage - Medium,Underground Utilities","MODIFICATIONTIMESTAMP":"2026-06-09T17:13:10.329","OFFICE_OFFICENAME":"Edina Realty, Inc.","PHOTOCOUNT":39,"POSTALCODE":"55038","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Enjoy this multi-level, end-unit townhome offering a wonderful layout with a private owner’s suite (private bath with separate shower/tub and walk-in closet), spacious second bedroom, and full bath on the upper level.\n\nThe main floor features vaulted ceilings and an open kitchen, dining, and living area that feels connected while still offering comfortable separation between spaces. South and west-facing windows bring in an abundance of natural light, and with no neighboring building to the west, you’ll enjoy peaceful views of the pond, mature trees, and local wildlife. It’s a rare combination of privacy, natural beauty, and maintenance-free living within a community setting.\n\nThe walk-out lower level adds even more living space with a family room, third bedroom (armoire included) or office, convenient half bath, and laundry area. Step outside to the concrete patio below or relax on the upper deck overlooking the serene surroundings.\n\nJust down the road, the community clubhouse offers outstanding amenities included in the affordable HOA dues, including a lap pool, splash pad, fitness center, party room with full kitchen, playground, basketball court, and more. Enjoy the comfort, convenience, and lifestyle this exceptional Waters Edge townhome has to offer.","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Age Over 8 Years,Asphalt","SCHOOLDISTRICTNUMBER":"624-White Bear Lake","SCHOOLDISTRICTPHONE":"6514077500","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2026-06-09T17:03:06.807","LASTSTATUS":"Active","STREETDIRSUFFIX":"N","STREETNAME":"Farnham","STREETNUMBER":"15485","STREETSUFFIX":"Avenue","STYLE":"(TH) Side x Side","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"WATERFRONTVIEW":"Pond","YEARBUILT":2005,"ZONING":"Residential-Single Family","HASOPENHOUSE":true,"PHOTOTIMESTAMP":"2026-06-09T17:01:10.284","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"15485 Farnham Ave N\"},{\"Order\":2,\"Remarks\":\"Open floor plan to kitchen and dining\"},{\"Order\":3,\"Remarks\":\"Spacious light-drenched living room facing south\"},{\"Order\":4,\"Remarks\":\"Open concept with defined spaces\"},{\"Order\":5,\"Remarks\":\"Tasteful kitchen with stainless steel appliances and tile floors\"},{\"Order\":6,\"Remarks\":\"Beautiful primary bedroom with ensuite\"},{\"Order\":7,\"Remarks\":\"Another view showing proximity to private primary ensuite bath\"},{\"Order\":8,\"Remarks\":\"Primary bath has a separate shower and tub\"},{\"Order\":9,\"Remarks\":\"Large, clean walk-in closet\"},{\"Order\":10,\"Remarks\":\"2nd upper bedroom virtually staged\"},{\"Order\":12,\"Remarks\":\"Full bath upper level next to 2nd bedroom\"},{\"Order\":13,\"Remarks\":\"Not your typical multi-level split townhouse - spacious entry, closet and direct access to the garage\"},{\"Order\":15,\"Remarks\":\"Covered entry\"},{\"Order\":16,\"Remarks\":\"Wonder natural light on the main level\"},{\"Order\":17,\"Remarks\":\"Virtually staged deck\"},{\"Order\":18,\"Remarks\":\"This particular end unit faces open space and a pond, really giving it some nice privacy compared to others\"},{\"Order\":19,\"Remarks\":\"virtually staged dining\"},{\"Order\":21,\"Remarks\":\"Counter bar-height overhang for stools\"},{\"Order\":22,\"Remarks\":\"lower half bath\"},{\"Order\":23,\"Remarks\":\"Lower level bath\"},{\"Order\":24,\"Remarks\":\"lower laundry\"},{\"Order\":25,\"Remarks\":\"Virtually staged family room\"},{\"Order\":26,\"Remarks\":\"Walk-out to lower concrete patio and yard\"},{\"Order\":28,\"Remarks\":\"3rd bedroom or home office - armoire stays with the property\"},{\"Order\":32,\"Remarks\":\"Waters Edge offers one of the best clubhouses in the area\"},{\"Order\":33,\"Remarks\":\"Lap pool\"},{\"Order\":34,\"Remarks\":\"Splash pad\"},{\"Order\":35,\"Remarks\":\"Park\"},{\"Order\":36,\"Remarks\":\"Indoor gathering space\"},{\"Order\":37,\"Remarks\":\"Host your holiday parties in the community room\"},{\"Order\":38,\"Remarks\":\"Full kitchen\"}]","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,28,29,30,31,32,33,34,35,36,37,38,39","SOURCE":"MG_NST"}

{"ListingKey":"NST7914955","NST_AboveGradeSqFtTotal":"1087","AboveGradeFinishedArea":"1087","AccessibilityFeatures":"None","AdditionalParcelsYN":"False","NST_AgentOwner":"No","NST_AmenitiesUnit":"Cable,Deck,Exercise Room,French Doors,Hardwood Floors,Primary Bedroom Walk-In Closet,Natural Woodwork,Outdoor Kitchen,Patio,Paneled Doors,In-Ground Sprinkler,Tile Floors,Vaulted Ceiling(s),Washer/Dryer Hookup,Walk-In Closet","Appliances":"Dishwasher,Disposal,Dryer,Exhaust Fan,Freezer,Microwave,Range,Refrigerator,Stainless Steel Appliances,Washer,Water Softener Owned","LivingAreaUnits":"Square Feet","NST_AssessmentPending":"No","AssociationYN":"True","AssociationFee":"350","AssociationFeeFrequency":"Monthly","AssociationFeeIncludes":"Building Exterior,Hazard Insurance,Lawn Care,Other,Maintenance Grounds,Professional Mgmt,Recreation Facility,Shared Amenities,Snow Removal","AssociationName":"HOALiving","AssociationPhone":"6122346464","Basement":"Daylight/Lookout Windows,Drain Tiled,Full,Storage Space,Sump Pump,Walkout","BasementYN":"True","NST_BathDesc":"1/2 Basement,Basement,Bathroom Ensuite,Full Primary,Private Primary,Upper Level Full Bath","BathroomsFull":"2","BathroomsHalf":"1","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"3","BedroomsTotal":"3","NST_BelowGradeSqFtTotal":"537","BelowGradeFinishedArea":"480","CumulativeDaysOnMarket":"8","City":"Hugo","NewConstructionYN":"False","Contingency":"None","NST_ForSaleOrLease":"For Sale","Cooling":"Central Air","CountyOrParish":"Washington","NST_DiningRoomDescription":"Eat In Kitchen,Informal Dining Room,Kitchen/Dining Room","Directions":"From 35E, East on County Road 14, north on Oneka Parkway, right on Farnham, first unit on the right past the pond.","DocumentsCount":"4","DocumentsChangeTimestamp":"2026-06-09T17:01:10.285Z","DaysOnMarket":"0","ExteriorFeatures":"Stone,Vinyl","Fencing":"None","FireplaceYN":"False","FireplacesTotal":"0","FoundationArea":"530","FoundationDetails":"Block","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","NST_GarageSquareFeet":"408","GarageSpaces":"2","Heating":"Forced Air","HighSchoolDistrict":"White Bear Lake","NST_ForeclosureStatus":"No","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"False","InternetConsumerCommentYN":"False","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","Latitude":"45.174295","LaundryFeatures":"Gas Dryer Hookup,Lower Level,In Unit,Washer Hookup","NST_LenderOwned":"No","Levels":"Three Level Split","ListPrice":"299900","ListingContractDate":"2026-06-09T05:00:00Z","ListingId":"NST7089242","LivingArea":"1567","Longitude":"-93.003036","LotFeatures":"Corner Lot,Tree Coverage - Medium,Underground Utilities","LotSizeArea":"0.055","LotSizeDimensions":"67x36x67x36","LotSizeUnits":"Acres","NST_MainLevelFinishedArea":"587","NST_ManufacturedHome":"N","OriginalEntryTimestamp":"2026-06-09T12:00:58Z","ParcelNumber":"1803121410008","ParkingFeatures":"Attached Garage,Asphalt,Finished Garage,Garage Door Opener,Heated Garage,Insulated Garage","NST_PatioPorchType":"Deck","PhotosCount":"39","PhotosChangeTimestamp":"2026-06-09T17:01:10.284Z","PoolFeatures":"Outdoor,Shared","PostalCity":"Hugo","PostalCode":"55038","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PropertyAttachedYN":"True","PropertySubType":"(TH) Side x Side","PropertyType":"Residential","PublicRemarks":"Enjoy this multi-level, end-unit townhome offering a wonderful layout with a private owner’s suite (private bath with separate shower/tub and walk-in closet), spacious second bedroom, and full bath on the upper level.\n\nThe main floor features vaulted ceilings and an open kitchen, dining, and living area that feels connected while still offering comfortable separation between spaces. South and west-facing windows bring in an abundance of natural light, and with no neighboring building to the west, you’ll enjoy peaceful views of the pond, mature trees, and local wildlife. It’s a rare combination of privacy, natural beauty, and maintenance-free living within a community setting.\n\nThe walk-out lower level adds even more living space with a family room, third bedroom (armoire included) or office, convenient half bath, and laundry area. Step outside to the concrete patio below or relax on the upper deck overlooking the serene surroundings.\n\nJust down the road, the community clubhouse offers outstanding amenities included in the affordable HOA dues, including a lap pool, splash pad, fitness center, party room with full kitchen, playground, basketball court, and more. Enjoy the comfort, convenience, and lifestyle this exceptional Waters Edge townhome has to offer.","PublicSurveyRange":"21","PublicSurveySection":"18","PublicSurveyTownship":"31","Roof":"Age Over 8 Years,Asphalt","NST_SchoolDistrictFullName":"624 - White Bear Lake","NST_SchoolDistrictNumber":"624","NST_SchoolDistrictPhone":"6514077500","Sewer":"City Sewer/Connected","NST_SharedRooms":"Amusement/Party Room,Club House,Community Room,Exercise Room,Play Area","NST_SingleFamilyTownhouseType":"End Unit,Multi-Level","NST_SpecialSearch":"Primary Bdr Suite","StandardStatus":"Active","StateOrProvince":"MN","StreetDirSuffix":"N","StreetName":"Farnham","StreetNumber":"15485","StreetNumberNumeric":"15485","StreetSuffix":"Avenue","SubdivisionName":"Waters Edge South Second Add","TaxAnnualAmount":"3230","NST_TaxWithAssessments":"3230","TaxYear":"2026","NST_TotalArea":"1624","BuildingAreaTotal":"1624","Township":"Hugo","VideosCount":"0","WaterSource":"City Water/Connected","WaterfrontFeatures":"Pond","WaterfrontYN":"False","YearBuilt":"2005","ZoningDescription":"Residential-Single Family","ListAgentKey":"NST86661","ListAgentMlsId":"NST506004730","ListOfficeMlsId":"NST8769","ListOfficeName":"Edina Realty, Inc.","ListOfficeKey":"NST16007","ModificationTimestamp":"2026-06-09T17:13:10.329Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7914955\",\"Order\":13,\"MediaObjectID\":\"NST13\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7914955/f9ae462c-8e16-4b81-bdf7-fe6e0b744a16.jpeg\",\"LongDescription\":\"Not your typical multi-level split townhouse - spacious entry, closet and direct access to the garage\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-06-08T23:29:09.137Z\",\"MediaKey\":\"NST122809872\"},{\"ResourceRecordKey\":\"NST7914955\",\"Order\":15,\"MediaObjectID\":\"NST15\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7914955/6cf9aaf0-7e73-4ded-9b38-ce87b4d0b112.jpeg\",\"LongDescription\":\"Covered entry\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-06-08T23:29:09.08Z\",\"MediaKey\":\"NST122809874\"},{\"ResourceRecordKey\":\"NST7914955\",\"Order\":9,\"MediaObjectID\":\"NST9\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7914955/3f0758b7-bed3-4cce-aa4e-c387b6723953.jpeg\",\"LongDescription\":\"Large, clean walk-in closet\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-06-08T23:29:09.059Z\",\"MediaKey\":\"NST122809867\"},{\"ResourceRecordKey\":\"NST7914955\",\"Order\":11,\"MediaObjectID\":\"NST11\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7914955/ead79d8e-d950-49e0-9592-9417b28a2055.jpeg\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-06-08T23:29:09.091Z\",\"MediaKey\":\"NST122809869\"},{\"ResourceRecordKey\":\"NST7914955\",\"Order\":8,\"MediaObjectID\":\"NST8\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7914955/355754ee-6b23-4ea8-85d7-d78afd2a7301.jpeg\",\"LongDescription\":\"Primary bath has a separate shower and tub\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-06-08T23:29:09.131Z\",\"MediaKey\":\"NST122809866\"},{\"ResourceRecordKey\":\"NST7914955\",\"Order\":12,\"MediaObjectID\":\"NST12\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7914955/e851ead8-58b8-42ca-b83d-adc705e11d36.jpeg\",\"LongDescription\":\"Full bath upper level next to 2nd bedroom\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-06-08T23:29:09.09Z\",\"MediaKey\":\"NST122809871\"},{\"ResourceRecordKey\":\"NST7914955\",\"Order\":5,\"MediaObjectID\":\"NST5\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7914955/6b886676-c552-49ba-9758-02886001bec1.jpeg\",\"LongDescription\":\"Tasteful kitchen with stainless steel appliances and tile floors\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-06-09T17:00:18.081Z\",\"MediaKey\":\"NST122809863\"},{\"ResourceRecordKey\":\"NST7914955\",\"Order\":4,\"MediaObjectID\":\"NST4\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7914955/6d72e86d-ba33-4c02-bc02-9eb7def2a217.jpeg\",\"LongDescription\":\"Open concept with defined spaces\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-06-09T17:00:18.022Z\",\"MediaKey\":\"NST122809876\"},{\"ResourceRecordKey\":\"NST7914955\",\"Order\":7,\"MediaObjectID\":\"NST7\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7914955/01567804-614d-46c7-8499-86a8b8a4a816.jpeg\",\"LongDescription\":\"Another view showing proximity to private primary ensuite bath\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-06-08T23:29:09.115Z\",\"MediaKey\":\"NST122809865\"},{\"ResourceRecordKey\":\"NST7914955\",\"Order\":39,\"MediaObjectID\":\"NST39\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7914955/04e291af-13fb-4ded-8c37-c553a5c4bd05.jpeg\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-06-08T23:30:05.173Z\",\"MediaKey\":\"NST122809861\"},{\"ResourceRecordKey\":\"NST7914955\",\"Order\":6,\"MediaObjectID\":\"NST6\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7914955/43bf0aac-35b1-422f-8149-0dc389aef8ab.jpeg\",\"LongDescription\":\"Beautiful primary bedroom with ensuite\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-06-08T23:29:09.126Z\",\"MediaKey\":\"NST122809864\"},{\"ResourceRecordKey\":\"NST7914955\",\"Order\":22,\"MediaObjectID\":\"NST22\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7914955/728bcc7a-41e3-47d1-a7d4-959fa24e73e8.jpeg\",\"LongDescription\":\"lower half bath\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-06-08T23:31:05.892Z\",\"MediaKey\":\"NST122809884\"},{\"ResourceRecordKey\":\"NST7914955\",\"Order\":3,\"MediaObjectID\":\"NST3\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7914955/dfdef9dc-4590-4f96-8ca2-1e080aa1025f.jpeg\",\"LongDescription\":\"Spacious light-drenched living room facing south\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-06-09T17:00:18.015Z\",\"MediaKey\":\"NST122809860\"},{\"ResourceRecordKey\":\"NST7914955\",\"Order\":2,\"MediaObjectID\":\"NST2\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7914955/018c77be-33c6-4981-9244-6493d9cd8f5d.jpeg\",\"LongDescription\":\"Open floor plan to kitchen and dining\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-06-09T17:00:18.034Z\",\"MediaKey\":\"NST122809862\"},{\"ResourceRecordKey\":\"NST7914955\",\"Order\":18,\"MediaObjectID\":\"NST18\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7914955/e89186ef-dce4-4f9e-822e-2de59136b047.jpeg\",\"LongDescription\":\"This particular end unit faces open space and a pond, really giving it some nice privacy compared to others\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-06-08T23:31:05.956Z\",\"MediaKey\":\"NST122809879\"},{\"ResourceRecordKey\":\"NST7914955\",\"Order\":20,\"MediaObjectID\":\"NST20\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7914955/fa68c52f-d474-44ad-b9a3-063642c73bf5.jpeg\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-06-08T23:31:05.927Z\",\"MediaKey\":\"NST122809881\"},{\"ResourceRecordKey\":\"NST7914955\",\"Order\":37,\"MediaObjectID\":\"NST37\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7914955/7a3191c3-ad8c-4248-971c-e40d55ecf1f8.jpeg\",\"LongDescription\":\"Host your holiday parties in the community room\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-06-08T23:31:05.914Z\",\"MediaKey\":\"NST122809901\"},{\"ResourceRecordKey\":\"NST7914955\",\"Order\":14,\"MediaObjectID\":\"NST14\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7914955/44eecc6a-5528-43b2-8902-341e9946e274.jpeg\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-06-08T23:29:09.088Z\",\"MediaKey\":\"NST122809873\"},{\"ResourceRecordKey\":\"NST7914955\",\"Order\":23,\"MediaObjectID\":\"NST23\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7914955/046922ef-8018-4564-b21a-3f7cea04d6e5.jpeg\",\"LongDescription\":\"Lower level bath\",\"ImageWidth\":1024,\"ImageHeight\":1536,\"ImageSizeDescription\":\"1024x1536\",\"MediaModificationTimestamp\":\"2026-06-08T23:31:05.928Z\",\"MediaKey\":\"NST122809883\"},{\"ResourceRecordKey\":\"NST7914955\",\"Order\":32,\"MediaObjectID\":\"NST32\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7914955/1fff0804-a0f3-48f7-bb8f-a61cbeeedbec.jpeg\",\"LongDescription\":\"Waters Edge offers one of the best clubhouses in the area\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-06-08T23:31:05.928Z\",\"MediaKey\":\"NST122809896\"},{\"ResourceRecordKey\":\"NST7914955\",\"Order\":27,\"MediaObjectID\":\"NST27\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7914955/513b8dd4-8931-4dc1-a4dc-be97ac36b241.jpeg\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-06-08T23:31:05.929Z\",\"MediaKey\":\"NST122809889\"},{\"ResourceRecordKey\":\"NST7914955\",\"Order\":26,\"MediaObjectID\":\"NST26\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7914955/8eb5c766-7eca-45d1-9916-afa88f505bf8.jpeg\",\"LongDescription\":\"Walk-out to lower concrete patio and yard\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-06-08T23:30:05.164Z\",\"MediaKey\":\"NST122809888\"},{\"ResourceRecordKey\":\"NST7914955\",\"Order\":29,\"MediaObjectID\":\"NST29\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7914955/8234de16-375a-4b18-a1ca-4061b5829a2f.jpeg\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-06-08T23:31:05.989Z\",\"MediaKey\":\"NST122809893\"},{\"ResourceRecordKey\":\"NST7914955\",\"Order\":31,\"MediaObjectID\":\"NST31\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7914955/e5df8ad7-0e64-435f-a129-074e83ad0b14.jpeg\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-06-08T23:31:05.946Z\",\"MediaKey\":\"NST122809895\"},{\"ResourceRecordKey\":\"NST7914955\",\"Order\":38,\"MediaObjectID\":\"NST38\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7914955/d2bf2d59-e32e-4a6a-99a3-a18ef5c9d068.jpeg\",\"LongDescription\":\"Full kitchen\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-06-08T23:31:05.928Z\",\"MediaKey\":\"NST122809902\"},{\"ResourceRecordKey\":\"NST7914955\",\"Order\":24,\"MediaObjectID\":\"NST24\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7914955/0bf8270b-8316-4bcf-b2cb-5cf7435969cf.jpeg\",\"LongDescription\":\"lower laundry\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-06-08T23:31:05.897Z\",\"MediaKey\":\"NST122809885\"},{\"ResourceRecordKey\":\"NST7914955\",\"Order\":28,\"MediaObjectID\":\"NST28\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7914955/1b3c3d0f-3b22-49f6-a7d0-d7e993d6d209.jpeg\",\"LongDescription\":\"3rd bedroom or home office - armoire stays with the property\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-06-09T17:00:18.048Z\",\"MediaKey\":\"NST122809891\"},{\"ResourceRecordKey\":\"NST7914955\",\"Order\":16,\"MediaObjectID\":\"NST16\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7914955/a784bc4c-75de-4c0f-bb6f-8aa8729cbdce.jpeg\",\"LongDescription\":\"Wonder natural light on the main level\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-06-08T23:29:09.116Z\",\"MediaKey\":\"NST122809877\"},{\"ResourceRecordKey\":\"NST7914955\",\"Order\":21,\"MediaObjectID\":\"NST21\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7914955/715aeb6e-959e-4fc2-a6b3-8f3fc5fed8f8.jpeg\",\"LongDescription\":\"Counter bar-height overhang for stools\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-06-08T23:29:09.089Z\",\"MediaKey\":\"NST122809882\"},{\"ResourceRecordKey\":\"NST7914955\",\"Order\":1,\"MediaObjectID\":\"NST1\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7914955/dc5aa860-94fa-4c47-8b29-7da67b4c3eda.jpeg\",\"LongDescription\":\"15485 Farnham Ave N\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-06-09T17:00:18.092Z\",\"MediaKey\":\"NST122809903\"},{\"ResourceRecordKey\":\"NST7914955\",\"Order\":30,\"MediaObjectID\":\"NST30\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7914955/63c27693-34df-4ac2-92b8-68a5ee3de832.jpeg\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-06-08T23:31:05.969Z\",\"MediaKey\":\"NST122809894\"},{\"ResourceRecordKey\":\"NST7914955\",\"Order\":36,\"MediaObjectID\":\"NST36\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7914955/fa5119ac-9039-4f2c-a528-1a1c3bb12a57.jpeg\",\"LongDescription\":\"Indoor gathering space\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-06-08T23:31:05.884Z\",\"MediaKey\":\"NST122809900\"},{\"ResourceRecordKey\":\"NST7914955\",\"Order\":34,\"MediaObjectID\":\"NST34\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7914955/833e0816-fd89-4f5d-a505-224ce1be44ca.jpeg\",\"LongDescription\":\"Splash pad\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-06-08T23:31:05.954Z\",\"MediaKey\":\"NST122809898\"},{\"ResourceRecordKey\":\"NST7914955\",\"Order\":35,\"MediaObjectID\":\"NST35\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7914955/fc754404-1574-4ae8-bb59-d832852a0aef.jpeg\",\"LongDescription\":\"Park\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-06-08T23:31:05.929Z\",\"MediaKey\":\"NST122809899\"},{\"ResourceRecordKey\":\"NST7914955\",\"Order\":33,\"MediaObjectID\":\"NST33\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7914955/bd41350a-b2b7-40f8-96dc-826d17d00382.jpeg\",\"LongDescription\":\"Lap pool\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-06-08T23:31:05.897Z\",\"MediaKey\":\"NST122809897\"},{\"ResourceRecordKey\":\"NST7914955\",\"Order\":10,\"MediaObjectID\":\"NST10\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7914955/e84ca9ad-ef2b-422a-9f7f-751338d51940.jpeg\",\"LongDescription\":\"2nd upper bedroom virtually staged\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-06-08T23:31:06.113Z\",\"MediaKey\":\"NST122811362\"},{\"ResourceRecordKey\":\"NST7914955\",\"Order\":19,\"MediaObjectID\":\"NST19\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7914955/ecece8b6-3f31-443d-86c1-ce53b90a5997.jpeg\",\"LongDescription\":\"virtually staged dining\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-06-08T23:31:05.972Z\",\"MediaKey\":\"NST122809880\"},{\"ResourceRecordKey\":\"NST7914955\",\"Order\":25,\"MediaObjectID\":\"NST25\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7914955/4fbc2a5a-a72b-4385-abaf-3bb3d34ea188.jpeg\",\"LongDescription\":\"Virtually staged family room\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-06-08T23:30:05.302Z\",\"MediaKey\":\"NST122809887\"},{\"ResourceRecordKey\":\"NST7914955\",\"Order\":17,\"MediaObjectID\":\"NST17\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7914955/a1d0212c-f643-4f3d-b260-df976ca71820.jpeg\",\"LongDescription\":\"Virtually staged deck\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-06-08T23:29:09.15Z\",\"MediaKey\":\"NST122809878\"}]","Media__ResourceRecordKey":"NST7914955","Media__Order":"13","Media__MediaObjectID":"NST13","Media__MediaURL":"https://s3.amazonaws.com/mlsgrid/images/NST7914955/f9ae462c-8e16-4b81-bdf7-fe6e0b744a16.jpeg","Media__LongDescription":"Not your typical multi-level split townhouse - spacious entry, closet and direct access to the garage","Media__ImageWidth":"2048","Media__ImageHeight":"1365","Media__ImageSizeDescription":"2048x1365","Media__MediaModificationTimestamp":"6/8/2026 11:29:09 PM","Media__MediaKey":"NST122809872","Rooms":"[{\"NST_RoomSortOrder\":8,\"RoomKey\":\"NST116329953\",\"RoomDimensions\":\"10x8\",\"RoomType\":\"Bathroom\",\"RoomLevel\":\"Upper\"},{\"NST_RoomSortOrder\":11,\"RoomKey\":\"NST116329956\",\"RoomDimensions\":\"10x10\",\"RoomType\":\"Deck\",\"RoomLevel\":\"Main\"},{\"NST_RoomSortOrder\":3,\"RoomKey\":\"NST116329948\",\"RoomDimensions\":\"11x9\",\"RoomType\":\"Dining Room\",\"RoomLevel\":\"Main\"},{\"NST_RoomSortOrder\":9,\"RoomKey\":\"NST116329954\",\"RoomDimensions\":\"17x14\",\"RoomType\":\"Family Room\",\"RoomLevel\":\"Lower\"},{\"NST_RoomSortOrder\":5,\"RoomKey\":\"NST116329950\",\"RoomDimensions\":\"14x13\",\"RoomType\":\"Bedroom\",\"RoomLevel\":\"Upper\"},{\"NST_RoomSortOrder\":1,\"RoomKey\":\"NST116329946\",\"RoomDimensions\":\"8x5\",\"RoomType\":\"Foyer\",\"RoomLevel\":\"Main\"},{\"NST_RoomSortOrder\":4,\"RoomKey\":\"NST116329949\",\"RoomDimensions\":\"11x10\",\"RoomType\":\"Kitchen\",\"RoomLevel\":\"Main\"},{\"NST_RoomSortOrder\":2,\"RoomKey\":\"NST116329947\",\"RoomDimensions\":\"16x14\",\"RoomType\":\"Living Room\",\"RoomLevel\":\"Main\"},{\"NST_RoomSortOrder\":6,\"RoomKey\":\"NST116329951\",\"RoomDimensions\":\"9x8\",\"RoomType\":\"Primary Bathroom\",\"RoomLevel\":\"Upper\"},{\"NST_RoomSortOrder\":7,\"RoomKey\":\"NST116329952\",\"RoomDimensions\":\"12x11\",\"RoomType\":\"Bedroom 2\",\"RoomLevel\":\"Upper\"},{\"NST_RoomSortOrder\":10,\"RoomKey\":\"NST116329955\",\"RoomDimensions\":\"11x10\",\"RoomType\":\"Bedroom 3\",\"RoomLevel\":\"Lower\"}]","Rooms__NST_RoomSortOrder":"8","Rooms__RoomKey":"NST116329953","Rooms__RoomDimensions":"10x8","Rooms__RoomType":"Bathroom","Rooms__RoomLevel":"Upper","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"15485 Farnham Ave N\"},{\"Order\":2,\"Remarks\":\"Open floor plan to kitchen and dining\"},{\"Order\":3,\"Remarks\":\"Spacious light-drenched living room facing south\"},{\"Order\":4,\"Remarks\":\"Open concept with defined spaces\"},{\"Order\":5,\"Remarks\":\"Tasteful kitchen with stainless steel appliances and tile floors\"},{\"Order\":6,\"Remarks\":\"Beautiful primary bedroom with ensuite\"},{\"Order\":7,\"Remarks\":\"Another view showing proximity to private primary ensuite bath\"},{\"Order\":8,\"Remarks\":\"Primary bath has a separate shower and tub\"},{\"Order\":9,\"Remarks\":\"Large, clean walk-in closet\"},{\"Order\":10,\"Remarks\":\"2nd upper bedroom virtually staged\"},{\"Order\":12,\"Remarks\":\"Full bath upper level next to 2nd bedroom\"},{\"Order\":13,\"Remarks\":\"Not your typical multi-level split townhouse - spacious entry, closet and direct access to the garage\"},{\"Order\":15,\"Remarks\":\"Covered entry\"},{\"Order\":16,\"Remarks\":\"Wonder natural light on the main level\"},{\"Order\":17,\"Remarks\":\"Virtually staged deck\"},{\"Order\":18,\"Remarks\":\"This particular end unit faces open space and a pond, really giving it some nice privacy compared to others\"},{\"Order\":19,\"Remarks\":\"virtually staged dining\"},{\"Order\":21,\"Remarks\":\"Counter bar-height overhang for stools\"},{\"Order\":22,\"Remarks\":\"lower half bath\"},{\"Order\":23,\"Remarks\":\"Lower level bath\"},{\"Order\":24,\"Remarks\":\"lower laundry\"},{\"Order\":25,\"Remarks\":\"Virtually staged family room\"},{\"Order\":26,\"Remarks\":\"Walk-out to lower concrete patio and yard\"},{\"Order\":28,\"Remarks\":\"3rd bedroom or home office - armoire stays with the property\"},{\"Order\":32,\"Remarks\":\"Waters Edge offers one of the best clubhouses in the area\"},{\"Order\":33,\"Remarks\":\"Lap pool\"},{\"Order\":34,\"Remarks\":\"Splash pad\"},{\"Order\":35,\"Remarks\":\"Park\"},{\"Order\":36,\"Remarks\":\"Indoor gathering space\"},{\"Order\":37,\"Remarks\":\"Host your holiday parties in the community room\"},{\"Order\":38,\"Remarks\":\"Full kitchen\"}]","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,28,29,30,31,32,33,34,35,36,37,38,39","CustomVTourURL":""}

MLS# 7089242 - 15485 Farnham Avenue N Hugo, MN 55038

Direct Links

$BTITLE$