{"Id":1388079,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST6762123","MLSAGENTID":"NST505004870","MLSOFFICEID":"NST26596","ADDRESS":"5750 Freeland Bay N","ACRES":0.5,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Drain Tiled,Finished,Concrete,Sump Pump,Walkout","BATHSTOTAL":3.0,"BEDROOMS":4,"CITY":"Hugo","CONTINGENCY":"None","COUNTY":"Washington","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Fiber Cement","FORECLOSURE":"No","LASTPRICE":975350.0,"LASTPRICEDATE":"2025-07-27T19:11:03.513","LATITUDE":45.14407959,"LENDEROWNED":"No","LISTDATE":"2025-07-27T05:00:00","LISTPRICE":975350.0,"LIVINGAREA":3214.0,"LONGITUDE":-92.98854157,"LOTDESCRIPTION":"Sod Included in Price","MODIFICATIONTIMESTAMP":"2025-07-27T20:39:03.957","OFFICE_OFFICENAME":"Hanson Builders Inc","PHOTOCOUNT":4,"POSTALCODE":"55038","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Hanson Builders popular rambler floor plan, the Richmond! Main floor living at its finest, enjoy the attention to detail from function to construction. Spacious main floor offers oversize windows to capture the beautiful wetlands that sit directly behind, well appointed kitchen, Owner's suit with spa like bath. Finished lower level perfect for entertaining and 2 additional bedrooms. Hanson Builders is a local custom home builder with over 45 years of hands-on building experience, providing our clients with the peace of mind you deserve. The newest Mahtomedi schools community Watercrest of Hugo, offering beautiful spacious homesites with gorgeous views and a private setting!","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Age 8 Years or Less,Asphalt,Pitched","SCHOOLDISTRICTNUMBER":"832-Mahtomedi","SCHOOLDISTRICTPHONE":"651-407-2001","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2025-07-27T19:11:03.513","LASTSTATUS":"Active","STREETDIRSUFFIX":"N","STREETNAME":"Freeland Bay","STREETNUMBER":"5750","STYLE":"Single Family Residence","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":2025,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2025-07-27T20:37:03.665","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"Hanson Builders' Richmond\"}]","PHOTOORDER":"1,2,3,4","SOURCE":"MG_NST"}
{"ListingKey":"NST7779229","LotSizeArea":"0.5","NST_AgeOfProperty":"0","NST_AgentOwner":"No","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"True","NST_AmenitiesUnit":"Kitchen Center Island,Primary Bedroom Walk-In Closet,Main Floor Primary Bedroom,Porch,In-Ground Sprinkler,Vaulted Ceiling(s),Walk-In Closet","Appliances":"Air-To-Air Exchanger,Cooktop,Dishwasher,Disposal,Dryer,Exhaust Fan,Gas Water Heater,Microwave,Refrigerator,Wall Oven,Washer","NST_AssessmentPending":"No","AssociationFeeIncludes":"Professional Mgmt","AssociationFeeFrequency":"Monthly","AssociationYN":"True","AssociationFee":"67","AssociationName":"Sharper Management","AssociationPhone":"952-224-4777","PropertyAttachedYN":"False","Basement":"Drain Tiled,Finished,Concrete,Sump Pump,Walkout","BasementYN":"True","NST_BathDesc":"3/4 Basement,Private Primary,Main Floor Full Bath,Walk-In Shower Stall","BathroomsOneQuarter":"0","BathroomsFull":"2","BathroomsHalf":"0","BathroomsThreeQuarter":"1","BathroomsTotalInteger":"3","BedroomsTotal":"4","NST_BuilderAssociationID":"Builders Association of the Twin Cities","NST_BuilderLicense":"4568","BuilderName":"HANSON BUILDERS INC","CarportSpaces":"0","City":"Hugo","PropertyType":"Residential","NewConstructionYN":"True","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Washington","Directions":"35E N to exit 117 for County Road 96, Continue on 96 east to US-61 N take go east on 137th, right on 135th community on right Freeland Avenue N.","InternetAddressDisplayYN":"True","InternetEntireListingDisplayYN":"True","Electric":"200+ Amp Service","ConstructionMaterials":"Fiber Cement","FireplaceFeatures":"Gas,Living Room","FireplaceYN":"True","FireplacesTotal":"1","NST_ForeclosureStatus":"No","NST_FoundationDimensions":"1416","FoundationArea":"2085","NST_FractionalOwnershipYN":"No","RoadFrontageType":"City Street,Curbs,Paved Streets","NST_Fuel":"Natural Gas","ParkingFeatures":"Attached Garage,Asphalt","NST_GarageDoorHeight":"8","NST_GarageDoorWidth":"16","NST_GarageSquareFeet":"669","NST_GreenCertifiedStatus":"Pending","AccessibilityFeatures":"None","Heating":"Forced Air","OriginalEntryTimestamp":"2025-07-27T19:09:38Z","LandLeaseYN":"False","NST_LastUpdateDate":"2025-07-27","Latitude":"45.1440795917","NST_LenderOwned":"No","ListAgentKey":"NST41508","ListAgentMlsId":"NST505004870","ListingContractDate":"2025-07-27T05:00:00Z","ListOfficeKey":"NST26596","ListOfficeName":"Hanson Builders Inc","ListOfficeMlsId":"NST26596","ListPrice":"975350","LivingArea":"3214","Longitude":"-92.988541573","LotFeatures":"Sod Included in Price","LotSizeDimensions":"50x135x111x117x142","LotSizeSquareFeet":"21780","LotSizeUnits":"Acres","ListingId":"NST6762123","SourceSystemName":"RMLS","NST_ManufacturedHome":"No","MapCoordinateSource":"King's Street Atlas","AdditionalParcelsYN":"False","NST_OfficeBoard":"MAAR","ParcelNumber":"2903121420020","GarageSpaces":"3","PhotosCount":"4","PostalCity":"Hugo","PostalCode":"55038","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PublicRemarks":"Hanson Builders popular rambler floor plan, the Richmond! Main floor living at its finest, enjoy the attention to detail from function to construction. Spacious main floor offers oversize windows to capture the beautiful wetlands that sit directly behind, well appointed kitchen, Owner's suit with spa like bath. Finished lower level perfect for entertaining and 2 additional bedrooms. Hanson Builders is a local custom home builder with over 45 years of hands-on building experience, providing our clients with the peace of mind you deserve. The newest Mahtomedi schools community Watercrest of Hugo, offering beautiful spacious homesites with gorgeous views and a private setting!","NST_RentalLicenseYN":"No","Roof":"Age 8 Years or Less,Asphalt,Pitched","RoomType":"Living Room,Dining Room,Family Room,Kitchen,Bedroom 1,Bedroom 2,Bedroom 3,Bedroom 4,Game Room,Sun Room","NST_AboveGradeSqFtTotal":"1859.0000","NST_BelowGradeSqFtTotal":"1416.0000","NST_MainLevelFinishedArea":"1859.0000","BuildingAreaTotal":"3275","HighSchoolDistrict":"Mahtomedi","NST_SchoolDistrictNumber":"832","NST_SchoolDistrictPhone":"651-407-2001","Sewer":"City Sewer/Connected","NST_SpecialSearch":"All Living Facilities on One Level,Main Floor Bedroom,Main Floor Laundry","AboveGradeFinishedArea":"1859","BelowGradeFinishedArea":"1355","StateOrProvince":"MN","StandardStatus":"Active","Levels":"One","StreetDirSuffix":"N","StreetName":"Freeland Bay","StreetNumber":"5750","StreetNumberNumeric":"5750","PropertySubType":"Single Family Residence","SubdivisionName":"Watercrest of Hugo","NST_TaxWithAssessments":"246.0000","TaxYear":"2025","TaxAnnualAmount":"246","WaterSource":"City Water/Connected","YearBuilt":"2025","ZoningDescription":"Residential-Single Family","ModificationTimestamp":"2025-07-27T20:39:03.957Z","PhotosChangeTimestamp":"2025-07-27T20:37:03.665Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7779229\",\"Order\":1,\"MediaObjectID\":\"1\",\"LongDescription\":\"Hanson Builders' Richmond\",\"ImageWidth\":1280,\"ImageHeight\":960,\"ImageSizeDescription\":\"1280x960\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7779229/797c1543-f9b0-4dd9-b806-d0997847e792.jpeg\",\"MediaModificationTimestamp\":\"2025-07-27T20:36:11.263Z\",\"MediaKey\":\"68868dbb95f792767ea62637\"},{\"ResourceRecordKey\":\"NST7779229\",\"Order\":2,\"MediaObjectID\":\"2\",\"ImageWidth\":698,\"ImageHeight\":368,\"ImageSizeDescription\":\"698x368\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7779229/8a431ad3-b339-495f-b3ea-8ec1c0e467b1.png\",\"MediaModificationTimestamp\":\"2025-07-27T20:36:11.33Z\",\"MediaKey\":\"68868dbb95f792767ea62638\"},{\"ResourceRecordKey\":\"NST7779229\",\"Order\":3,\"MediaObjectID\":\"3\",\"ImageWidth\":1586,\"ImageHeight\":1648,\"ImageSizeDescription\":\"1586x1648\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7779229/b8fb85ba-567d-49c9-a981-9fea47e2d573.png\",\"MediaModificationTimestamp\":\"2025-07-27T19:10:12.896Z\",\"MediaKey\":\"688679940c2ebf7f9e3e9967\"},{\"ResourceRecordKey\":\"NST7779229\",\"Order\":4,\"MediaObjectID\":\"4\",\"ImageWidth\":1492,\"ImageHeight\":1516,\"ImageSizeDescription\":\"1492x1516\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7779229/9c5f2ce6-a2c5-4ce5-afc0-fea9b34a6454.png\",\"MediaModificationTimestamp\":\"2025-07-27T19:10:12.884Z\",\"MediaKey\":\"688679940c2ebf7f9e3e9968\"}]","Rooms":"[{\"RoomKey\":\"NST115458893\",\"RoomType\":\"Living Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"14x17\",\"NST_RoomSortOrder\":\"1\"},{\"RoomKey\":\"NST115458894\",\"RoomType\":\"Dining Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"11x11\",\"NST_RoomSortOrder\":\"2\"},{\"RoomKey\":\"NST115458895\",\"RoomType\":\"Family Room\",\"RoomLevel\":\"Lower\",\"RoomDimensions\":\"27x17\",\"NST_RoomSortOrder\":\"3\"},{\"RoomKey\":\"NST115458896\",\"RoomType\":\"Kitchen\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"16x14\",\"NST_RoomSortOrder\":\"4\"},{\"RoomKey\":\"NST115458897\",\"RoomType\":\"Bedroom 1\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"13x14\",\"NST_RoomSortOrder\":\"5\"},{\"RoomKey\":\"NST115458898\",\"RoomType\":\"Bedroom 2\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"11x12\",\"NST_RoomSortOrder\":\"6\"},{\"RoomKey\":\"NST115458899\",\"RoomType\":\"Bedroom 3\",\"RoomLevel\":\"Lower\",\"RoomDimensions\":\"11x13\",\"NST_RoomSortOrder\":\"7\"},{\"RoomKey\":\"NST115458900\",\"RoomType\":\"Bedroom 4\",\"RoomLevel\":\"Lower\",\"RoomDimensions\":\"10x15\",\"NST_RoomSortOrder\":\"8\"},{\"RoomKey\":\"NST115458901\",\"RoomType\":\"Game Room\",\"RoomLevel\":\"Lower\",\"RoomDimensions\":\"11x11\",\"NST_RoomSortOrder\":\"9\"},{\"RoomKey\":\"NST115458902\",\"RoomType\":\"Sun Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"12x11\",\"NST_RoomSortOrder\":\"10\"}]","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"Hanson Builders' Richmond\"}]","PhotoOrder":"1,2,3,4","CustomVTourURL":""}