Bay Lake Realty
Bruce Johnson
Broker/Owner
Bay Lake Realty is Licensed in the State of Minnesota
15929 Wakeman Rd.
Deerwood, MN 56444
Cell Phone: 218-838-1111
E-mail: bruce@baylakerealty.com
{"Id":1428935,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST6813165","MLSAGENTID":"NST506019187","MLSOFFICEID":"NST26348","ADDRESS":"15086 Farnham Avenue N","ACRES":0.034,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Finished","BATHSTOTAL":3.0,"BEDROOMS":3,"CITY":"Hugo","CONTINGENCY":"None","COUNTY":"Washington","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"FORECLOSURE":"No","LASTPRICE":330000.0,"LASTPRICEDATE":"2025-12-09T01:02:06.077","LATITUDE":45.168472,"LENDEROWNED":"No","LISTDATE":"2025-11-05T06:00:00","LISTPRICE":315000.0,"LIVINGAREA":2404.0,"LONGITUDE":-93.003999,"MODIFICATIONTIMESTAMP":"2025-12-09T10:30:05.912","OFFICE_OFFICENAME":"Partners Realty Inc.","PHOTOCOUNT":20,"POSTALCODE":"55038","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Come see this stunning townhome. It features 3 bedrooms, 3 bathrooms, and a 2-car attached garage. The private primary suite and two additional bedrooms are conveniently located on one level. The main floor offers an inviting open-concept layout with a bright living area, kitchen, balcony, and laundry room. The lower level includes a inviting family room—perfect for relaxing or entertaining. Enjoy all the wonderful community amenities, including a park, playground, fitness center, party room, clubhouse, swimming pool, splash pad, and walking trails. Located close to I-35E for a smooth commute.","ROADBETWEENWATERFRONTANDHOMEYN":false,"SCHOOLDISTRICTNUMBER":"2099-White Bear Lake","SCHOOLDISTRICTPHONE":"6514077500","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2025-11-05T14:17:05.67","LASTSTATUS":"Active","STREETDIRSUFFIX":"N","STREETNAME":"Farnham","STREETNUMBER":"15086","STREETSUFFIX":"Avenue","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":2006,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2025-12-09T10:30:05.912","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"Front Door Entrance\"},{\"Order\":2,\"Remarks\":\"Living Room and Dining Room\"},{\"Order\":3,\"Remarks\":\"Kitchen\"},{\"Order\":4,\"Remarks\":\"Kitchen\"},{\"Order\":5,\"Remarks\":\"Laundry Room\"},{\"Order\":6,\"Remarks\":\"Deck\"},{\"Order\":7,\"Remarks\":\"Deck\"},{\"Order\":8,\"Remarks\":\"Upper Stairs Bathroom\"},{\"Order\":9,\"Remarks\":\"Third Bedroom\"},{\"Order\":10,\"Remarks\":\"Second Bedroom\"},{\"Order\":11,\"Remarks\":\"Upper Stair Hallway to Primary Bedroom\"},{\"Order\":12,\"Remarks\":\"Primary Bedroom\"},{\"Order\":13,\"Remarks\":\"Primary Bathroom\"},{\"Order\":14,\"Remarks\":\"Primary Walk-In Closet\"},{\"Order\":15,\"Remarks\":\"Stairway to Foyer\"},{\"Order\":16,\"Remarks\":\"Lower Level Family Room\"},{\"Order\":17,\"Remarks\":\"Lower Floor Plan\"},{\"Order\":18,\"Remarks\":\"Main Floor Plan\"},{\"Order\":19,\"Remarks\":\"2nd Level Floor Plan\"},{\"Order\":20,\"Remarks\":\"All Floor Plan\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20","SOURCE":"MG_NST"}
{"ListingKey":"NST7823500","Appliances":"Dishwasher,Disposal,Dryer,Microwave,Range,Refrigerator,Stainless Steel Appliances,Washer","AssociationYN":"True","AssociationFee":"355","AssociationName":"Waters Edge Courtyard Home Association","Basement":"Finished","City":"Hugo","Contingency":"None","Directions":"35E north to Frenchman Rd (right). To Everton Ave N (left), to 149th St N (right). To Farnham Ave (left). Home is on the left.","FireplaceYN":"True","NST_Fuel":"Natural Gas","Latitude":"45.168472","ListPrice":"315000","LivingArea":"2404","LockBoxType":"Combo","Longitude":"-93.003999","LotSizeDimensions":"76x20","LotSizeUnits":"Acres","ParcelNumber":"1803121440027","PostalCity":"Hugo","PostalCode":"55038","PublicRemarks":"Come see this stunning townhome. It features 3 bedrooms, 3 bathrooms, and a 2-car attached garage. The private primary suite and two additional bedrooms are conveniently located on one level. The main floor offers an inviting open-concept layout with a bright living area, kitchen, balcony, and laundry room. The lower level includes a inviting family room—perfect for relaxing or entertaining. Enjoy all the wonderful community amenities, including a park, playground, fitness center, party room, clubhouse, swimming pool, splash pad, and walking trails. Located close to I-35E for a smooth commute.","PublicSurveyRange":"21","PublicSurveySection":"18","PublicSurveyTownship":"31","NST_SchoolDistrictPhone":"6514077500","Sewer":"City Sewer/Connected","StateOrProvince":"MN","StreetDirSuffix":"N","StreetName":"Farnham","StreetNumber":"15086","StreetNumberNumeric":"15086","StreetSuffix":"Avenue","TaxYear":"2025","YearBuilt":"2006","NST_AboveGradeSqFtTotal":"1622","AboveGradeFinishedArea":"1622","AccessibilityFeatures":"None","AdditionalParcelsYN":"False","NST_AgentOwner":"No","LivingAreaUnits":"Square Feet","NST_AssessmentPending":"No","AssociationFeeFrequency":"Monthly","AssociationFeeIncludes":"Building Exterior,Hazard Insurance,Lawn Care,Maintenance Grounds,Professional Mgmt,Snow Removal","AssociationPhone":"6514077067","BasementYN":"True","NST_BathDesc":"Full Primary,Private Primary,Main Floor 1/2 Bath,Upper Level Full Bath","BathroomsFull":"2","BathroomsHalf":"1","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"3","BedroomsTotal":"3","NST_BelowGradeSqFtTotal":"360","BelowGradeFinishedArea":"782","CumulativeDaysOnMarket":"0","NewConstructionYN":"False","Cooling":"Central Air","CountyOrParish":"Washington","NST_DPResource":"Yes","NST_DiningRoomDescription":"Informal Dining Room,Kitchen/Dining Room,Living/Dining Room","DaysOnMarket":"0","FireplaceFeatures":"Two Sided,Gas,Living Room","FireplacesTotal":"1","FoundationArea":"782","NST_FractionalOwnershipYN":"No","NST_GarageSquareFeet":"400","GarageSpaces":"2","Heating":"Forced Air","HighSchoolDistrict":"White Bear Lake","NST_ForeclosureStatus":"No","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"True","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","NST_LenderOwned":"No","Levels":"Two","ListingContractDate":"2025-11-05T06:00:00Z","ListingId":"NST6813165","LotSizeArea":"0.034","NST_MainLevelFinishedArea":"782","NST_ManufacturedHome":"N","OriginalEntryTimestamp":"2025-11-05T08:10:07Z","NST_SchoolDistrictNumber":"2099","ParkingFeatures":"Attached Garage,Insulated Garage,Tuckunder Garage","PhotosCount":"20","PhotosChangeTimestamp":"2025-12-09T10:30:05.912Z","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PropertyAttachedYN":"True","PropertyType":"Residential","NST_SharedRooms":"Community Room,Exercise Room,Other","NST_SpecialSearch":"3 BR on One Level,Main Floor Laundry","StandardStatus":"Active","SubdivisionName":"Waters Edge South","TaxAnnualAmount":"3145","NST_TaxWithAssessments":"3148","Township":"Hugo","WaterSource":"City Water/Connected","ZoningDescription":"Residential-Single Family","ListAgentKey":"NST506248","ListAgentMlsId":"NST506019187","ListOfficeMlsId":"NST26348","ListOfficeName":"Partners Realty Inc.","ListOfficeKey":"NST26348","ModificationTimestamp":"2025-12-09T10:30:05.912Z","OriginatingSystemName":"northstar","Media":"[{\"Order\":17,\"MediaObjectID\":\"NST17\",\"ResourceRecordKey\":\"NST7823500\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7823500/5beaf107-2998-46d4-88c1-6454ae790149.jpeg\",\"LongDescription\":\"Lower Floor Plan\",\"ImageWidth\":1024,\"ImageHeight\":768,\"ImageSizeDescription\":\"1024x768\",\"MediaModificationTimestamp\":\"2025-12-09T10:29:26.747Z\",\"MediaKey\":\"NST119508776\"},{\"Order\":18,\"MediaObjectID\":\"NST18\",\"ResourceRecordKey\":\"NST7823500\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7823500/568ad78a-f0ab-4eeb-9e07-0fcf73577d8b.jpeg\",\"LongDescription\":\"Main Floor Plan\",\"ImageWidth\":1024,\"ImageHeight\":768,\"ImageSizeDescription\":\"1024x768\",\"MediaModificationTimestamp\":\"2025-12-09T10:29:26.76Z\",\"MediaKey\":\"NST119508775\"},{\"Order\":20,\"MediaObjectID\":\"NST20\",\"ResourceRecordKey\":\"NST7823500\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7823500/588e5014-7b07-4c12-b746-20bed297e4d0.jpeg\",\"LongDescription\":\"All Floor Plan\",\"ImageWidth\":1024,\"ImageHeight\":768,\"ImageSizeDescription\":\"1024x768\",\"MediaModificationTimestamp\":\"2025-12-09T10:29:26.77Z\",\"MediaKey\":\"NST119508773\"},{\"Order\":9,\"MediaObjectID\":\"NST9\",\"ResourceRecordKey\":\"NST7823500\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7823500/547d0b95-8f8d-4eab-adb9-99436680b553.jpeg\",\"LongDescription\":\"Third Bedroom\",\"ImageWidth\":1248,\"ImageHeight\":832,\"ImageSizeDescription\":\"1248x832\",\"MediaModificationTimestamp\":\"2025-12-09T10:29:26.755Z\",\"MediaKey\":\"NST119508784\"},{\"Order\":13,\"MediaObjectID\":\"NST13\",\"ResourceRecordKey\":\"NST7823500\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7823500/e9873a6c-b535-471a-816b-76f488b125aa.jpeg\",\"LongDescription\":\"Primary Bathroom\",\"ImageWidth\":1248,\"ImageHeight\":832,\"ImageSizeDescription\":\"1248x832\",\"MediaModificationTimestamp\":\"2025-12-09T10:29:26.751Z\",\"MediaKey\":\"NST119508780\"},{\"Order\":8,\"MediaObjectID\":\"NST8\",\"ResourceRecordKey\":\"NST7823500\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7823500/57cff256-9342-4dce-ad99-19af4a3cdc6c.jpeg\",\"LongDescription\":\"Upper Stairs Bathroom\",\"ImageWidth\":1248,\"ImageHeight\":832,\"ImageSizeDescription\":\"1248x832\",\"MediaModificationTimestamp\":\"2025-12-09T10:29:26.763Z\",\"MediaKey\":\"NST119508785\"},{\"Order\":10,\"MediaObjectID\":\"NST10\",\"ResourceRecordKey\":\"NST7823500\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7823500/16685c0a-359c-4de4-96b1-fd205856eea4.jpeg\",\"LongDescription\":\"Second Bedroom\",\"ImageWidth\":1248,\"ImageHeight\":832,\"ImageSizeDescription\":\"1248x832\",\"MediaModificationTimestamp\":\"2025-12-09T10:29:26.76Z\",\"MediaKey\":\"NST119508783\"},{\"Order\":14,\"MediaObjectID\":\"NST14\",\"ResourceRecordKey\":\"NST7823500\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7823500/ece213df-3805-49ba-8ac8-1db5d8ff2584.jpeg\",\"LongDescription\":\"Primary Walk-In Closet\",\"ImageWidth\":1248,\"ImageHeight\":832,\"ImageSizeDescription\":\"1248x832\",\"MediaModificationTimestamp\":\"2025-11-05T14:13:02.863Z\",\"MediaKey\":\"NST119508779\"},{\"Order\":12,\"MediaObjectID\":\"NST12\",\"ResourceRecordKey\":\"NST7823500\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7823500/557a278a-88fc-4e60-80e0-bbd6de4c521e.jpeg\",\"LongDescription\":\"Primary Bedroom\",\"ImageWidth\":1248,\"ImageHeight\":832,\"ImageSizeDescription\":\"1248x832\",\"MediaModificationTimestamp\":\"2025-12-09T10:29:26.748Z\",\"MediaKey\":\"NST119508781\"},{\"Order\":16,\"MediaObjectID\":\"NST16\",\"ResourceRecordKey\":\"NST7823500\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7823500/8b0752db-5e06-4c3d-92b4-5e4aa27ccb0f.jpeg\",\"LongDescription\":\"Lower Level Family Room\",\"ImageWidth\":1248,\"ImageHeight\":832,\"ImageSizeDescription\":\"1248x832\",\"MediaModificationTimestamp\":\"2025-12-09T10:29:26.746Z\",\"MediaKey\":\"NST119508777\"},{\"Order\":1,\"MediaObjectID\":\"NST1\",\"ResourceRecordKey\":\"NST7823500\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7823500/5efd5b8a-24d3-49f2-84ab-136d4d7d7aca.jpeg\",\"LongDescription\":\"Front Door Entrance\",\"ImageWidth\":1248,\"ImageHeight\":832,\"ImageSizeDescription\":\"1248x832\",\"MediaModificationTimestamp\":\"2025-11-05T14:13:02.898Z\",\"MediaKey\":\"NST119508792\"},{\"Order\":19,\"MediaObjectID\":\"NST19\",\"ResourceRecordKey\":\"NST7823500\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7823500/eadd6396-5741-4731-9876-2b8145020249.jpeg\",\"LongDescription\":\"2nd Level Floor Plan\",\"ImageWidth\":1024,\"ImageHeight\":768,\"ImageSizeDescription\":\"1024x768\",\"MediaModificationTimestamp\":\"2025-12-09T10:29:26.735Z\",\"MediaKey\":\"NST119508774\"},{\"Order\":5,\"MediaObjectID\":\"NST5\",\"ResourceRecordKey\":\"NST7823500\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7823500/b8434742-e3ca-4545-839e-e7bc63e96338.jpeg\",\"LongDescription\":\"Laundry Room\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2025-12-09T10:29:26.748Z\",\"MediaKey\":\"NST119508788\"},{\"Order\":3,\"MediaObjectID\":\"NST3\",\"ResourceRecordKey\":\"NST7823500\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7823500/dc5415ff-7e12-40a3-b692-c58109415c5c.jpeg\",\"LongDescription\":\"Kitchen\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2025-12-09T10:29:26.744Z\",\"MediaKey\":\"NST119508790\"},{\"Order\":6,\"MediaObjectID\":\"NST6\",\"ResourceRecordKey\":\"NST7823500\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7823500/9cf9177f-2a33-41d1-8e5c-9fe2f9ba0d75.jpeg\",\"LongDescription\":\"Deck\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2025-12-09T10:29:26.751Z\",\"MediaKey\":\"NST119508787\"},{\"Order\":4,\"MediaObjectID\":\"NST4\",\"ResourceRecordKey\":\"NST7823500\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7823500/951c1749-24a2-4171-8d40-a8c586b2bc18.jpeg\",\"LongDescription\":\"Kitchen\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2025-12-09T10:29:26.765Z\",\"MediaKey\":\"NST119508789\"},{\"Order\":7,\"MediaObjectID\":\"NST7\",\"ResourceRecordKey\":\"NST7823500\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7823500/d7f8c83b-0d4f-4904-ac5f-5575cc5d28ac.jpeg\",\"LongDescription\":\"Deck\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2025-12-09T10:29:26.772Z\",\"MediaKey\":\"NST119508786\"},{\"Order\":11,\"MediaObjectID\":\"NST11\",\"ResourceRecordKey\":\"NST7823500\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7823500/f6b31d09-ee15-43a0-bd3d-3637910710f3.png\",\"LongDescription\":\"Upper Stair Hallway to Primary Bedroom\",\"ImageWidth\":1024,\"ImageHeight\":1024,\"ImageSizeDescription\":\"1024x1024\",\"MediaModificationTimestamp\":\"2025-11-05T14:13:02.902Z\",\"MediaKey\":\"NST119508782\"},{\"Order\":2,\"MediaObjectID\":\"NST2\",\"ResourceRecordKey\":\"NST7823500\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7823500/936ae29f-52de-4596-bb54-b0d5d54083cf.jpeg\",\"LongDescription\":\"Living Room and Dining Room\",\"ImageWidth\":1536,\"ImageHeight\":1024,\"ImageSizeDescription\":\"1536x1024\",\"MediaModificationTimestamp\":\"2025-12-09T10:29:26.819Z\",\"MediaKey\":\"NST119508791\"},{\"Order\":15,\"MediaObjectID\":\"NST15\",\"ResourceRecordKey\":\"NST7823500\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7823500/95124821-ee88-45ba-ab09-a9ef0e37a186.jpeg\",\"LongDescription\":\"Stairway to Foyer\",\"ImageWidth\":1536,\"ImageHeight\":1024,\"ImageSizeDescription\":\"1536x1024\",\"MediaModificationTimestamp\":\"2025-12-09T10:29:26.817Z\",\"MediaKey\":\"NST119508778\"}]","Rooms":"[{\"RoomDimensions\":\"19'11\\\" x 11'3\\\"\",\"RoomKey\":\"NST115751862\",\"RoomType\":\"Bedroom\",\"NST_RoomSortOrder\":1,\"RoomLevel\":\"Second\"},{\"RoomDimensions\":\"9'10\\\" x 12'6\\\"\",\"RoomKey\":\"NST115751863\",\"RoomType\":\"Bedroom 2\",\"NST_RoomSortOrder\":2,\"RoomLevel\":\"Second\"},{\"RoomDimensions\":\"12'3\\\" x 16'6\\\"\",\"RoomKey\":\"NST115751876\",\"RoomType\":\"Family Room\",\"NST_RoomSortOrder\":7,\"RoomLevel\":\"Lower\"},{\"RoomDimensions\":\"15'0\\\" x 8'10\\\"\",\"RoomKey\":\"NST115751866\",\"RoomType\":\"Dining Room\",\"NST_RoomSortOrder\":5,\"RoomLevel\":\"First\"},{\"RoomDimensions\":\"16'1\\\" x 15'8\\\"\",\"RoomKey\":\"NST115751867\",\"RoomType\":\"Kitchen\",\"NST_RoomSortOrder\":6,\"RoomLevel\":\"First\"},{\"RoomDimensions\":\"9'19\\\" x 10'0\\\"\",\"RoomKey\":\"NST115751864\",\"RoomType\":\"Bedroom 3\",\"NST_RoomSortOrder\":3,\"RoomLevel\":\"Second\"},{\"RoomDimensions\":\"16'1\\\" x 13'1\\\"\",\"RoomKey\":\"NST115751865\",\"RoomType\":\"Living Room\",\"NST_RoomSortOrder\":4,\"RoomLevel\":\"First\"}]","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"Front Door Entrance\"},{\"Order\":2,\"Remarks\":\"Living Room and Dining Room\"},{\"Order\":3,\"Remarks\":\"Kitchen\"},{\"Order\":4,\"Remarks\":\"Kitchen\"},{\"Order\":5,\"Remarks\":\"Laundry Room\"},{\"Order\":6,\"Remarks\":\"Deck\"},{\"Order\":7,\"Remarks\":\"Deck\"},{\"Order\":8,\"Remarks\":\"Upper Stairs Bathroom\"},{\"Order\":9,\"Remarks\":\"Third Bedroom\"},{\"Order\":10,\"Remarks\":\"Second Bedroom\"},{\"Order\":11,\"Remarks\":\"Upper Stair Hallway to Primary Bedroom\"},{\"Order\":12,\"Remarks\":\"Primary Bedroom\"},{\"Order\":13,\"Remarks\":\"Primary Bathroom\"},{\"Order\":14,\"Remarks\":\"Primary Walk-In Closet\"},{\"Order\":15,\"Remarks\":\"Stairway to Foyer\"},{\"Order\":16,\"Remarks\":\"Lower Level Family Room\"},{\"Order\":17,\"Remarks\":\"Lower Floor Plan\"},{\"Order\":18,\"Remarks\":\"Main Floor Plan\"},{\"Order\":19,\"Remarks\":\"2nd Level Floor Plan\"},{\"Order\":20,\"Remarks\":\"All Floor Plan\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20","CustomVTourURL":""}