{"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-09T01:02:06.076","OFFICE_OFFICENAME":"Partners Realty Inc.","PHOTOCOUNT":1,"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-09T01:02:06.075","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"Front Door Entrance\"}]","PHOTOORDER":"1","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":"1","PhotosChangeTimestamp":"2025-12-09T01:02:06.075Z","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-09T01:02:06.076Z","OriginatingSystemName":"northstar","Media":"[{\"LongDescription\":\"Front Door Entrance\",\"ResourceRecordKey\":\"NST7823500\",\"Order\":1,\"MediaObjectID\":\"NST1\",\"ImageWidth\":1248,\"ImageHeight\":832,\"ImageSizeDescription\":\"1248x832\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7823500/5efd5b8a-24d3-49f2-84ab-136d4d7d7aca.jpeg\",\"MediaModificationTimestamp\":\"2025-11-05T14:13:02.898Z\",\"MediaKey\":\"690b5b6e77669f2e607f9fb2\"}]","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\"}]","PhotoOrder":"1","CustomVTourURL":""}