• Active/Pending
  • Clearwater - Recently Sold
  • Clearwater Lake Lots
  • Search MLS #
  • Search other lakes
  • Sign up for automated updates
  • Mortgage calculator
  • Favorites
  • Contact Us
  • MENU

    MLS# 6737476 - 15895 Ethan Trail N Hugo, MN 55038

    Neighborhoods

    Keller Williams Classic Realty is the brokerage office representing the seller for this listing.

    Copyright 2019, 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. Joy+Marci Realty Group is not a multiple Listing Service (MLS), nor does it offer MLS access. This website is a service of Joy+Marci Realty Group, a broker Participant of the Regional Multiple Listing Service of Minnesota, Inc.

    {"Id":1369282,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST6737476","MLSAGENTID":"NST502018244","MLSCOAGENTID":"NST506008857","MLSOFFICEID":"NST1865","ADDRESS":"15895 Ethan Trail N","ACRES":0.3,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Daylight/Lookout Windows,Full,Concrete,Sump Basket,Sump Pump","BATHSTOTAL":3.0,"BEDROOMS":4,"CITY":"Hugo","CONTINGENCY":"None","COUNTY":"Washington","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Brick/Stone,Fiber Cement,Vinyl Siding","FORECLOSURE":"No","LASTPRICE":750000.0,"LASTPRICEDATE":"2025-06-12T22:37:03.67","LATITUDE":45.183038,"LENDEROWNED":"No","LISTDATE":"2025-06-12T05:00:00","LISTPRICE":750000.0,"LIVINGAREA":2967.0,"LONGITUDE":-93.013117,"LOTDESCRIPTION":"Some Trees","MODIFICATIONTIMESTAMP":"2025-06-13T10:08:10.414","OFFICE_OFFICENAME":"Keller Williams Classic Realty","PHOTOCOUNT":7,"POSTALCODE":"55038","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Your future dream home awaits! This new construction home will feature 4 bedrooms, 3 bathrooms, and an open-concept living and dining area—perfect for modern living. More lots & plans to choose to from!","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Age 8 Years or Less,Asphalt","SCHOOLDISTRICTNUMBER":"831-Forest Lake","SCHOOLDISTRICTPHONE":"651-982-8103","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2025-06-12T22:37:03.67","LASTSTATUS":"Active","STREETDIRSUFFIX":"N","STREETNAME":"Ethan","STREETNUMBER":"15895","STREETSUFFIX":"Trail","STYLE":"Single Family Residence","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":2025,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2025-06-12T22:43:03.539","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"Norway E.png\"},{\"Order\":2,\"Remarks\":\"Norway LL1.png\"},{\"Order\":3,\"Remarks\":\"Norway LL2.png\"},{\"Order\":4,\"Remarks\":\"Norway ML1.png\"},{\"Order\":5,\"Remarks\":\"Norway ML2.png\"},{\"Order\":6,\"Remarks\":\"Norway UL1.png\"},{\"Order\":7,\"Remarks\":\"Norway UL2.png\"}]","PHOTOORDER":"1,2,3,4,5,6,7","SOURCE":"MG_NST"}
    {"ListingKey":"NST7757820","LotSizeArea":"0.3","NST_AgeOfProperty":"0","NST_AgentOwner":"No","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"False","NST_AmenitiesUnit":"Hardwood Floors,Kitchen Center Island,Sun Room,Walk-In Closet","Appliances":"Dishwasher,Microwave,Other,Refrigerator,Stainless Steel Appliances","NST_AssessmentPending":"Unknown","AssociationFeeIncludes":"Professional Mgmt","AssociationFeeFrequency":"Annually","AssociationYN":"True","AssociationFee":"180","AssociationName":"Prarie Village HOA","AssociationPhone":"612-238-4400","PropertyAttachedYN":"False","Basement":"Daylight/Lookout Windows,Full,Concrete,Sump Basket,Sump Pump","BasementYN":"True","NST_BathDesc":"Double Sink,Full Primary,Private Primary,Main Floor 1/2 Bath,Upper Level 3/4 Bath,Upper Level Full Bath","BathroomsOneQuarter":"0","BathroomsFull":"1","BathroomsHalf":"1","BathroomsThreeQuarter":"1","BathroomsTotalInteger":"3","BedroomsTotal":"4","NST_BuilderLicense":"356604","BuilderName":"SHARPER HOMES INC","City":"Hugo","PropertyType":"Residential","NST_CommunityName":"Prarie Village","NewConstructionYN":"True","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Washington","NST_DPResource":"Y","DaysOnMarket":"1","CumulativeDaysOnMarket":"1","NST_DiningRoomDescription":"Informal Dining Room","Directions":"Main St/Frenchmen Rd to Oneka Pkwy, North to Ethan Trl","InternetAddressDisplayYN":"True","InternetEntireListingDisplayYN":"True","ConstructionMaterials":"Brick/Stone,Fiber Cement,Vinyl Siding","FireplaceFeatures":"Family Room,Gas","FireplaceYN":"True","FireplacesTotal":"1","NST_ForeclosureStatus":"No","FoundationArea":"1352","NST_FractionalOwnershipYN":"No","RoadFrontageType":"City Street,Paved Streets","NST_Fuel":"Natural Gas","ParkingFeatures":"Attached Garage,Asphalt","NST_GarageSquareFeet":"1006","AccessibilityFeatures":"None","Heating":"Forced Air","OriginalEntryTimestamp":"2025-06-12T22:34:55Z","LandLeaseYN":"False","NST_LastUpdateDate":"2025-06-13","Latitude":"45.183038","NST_LenderOwned":"No","ListAgentKey":"NST49646","ListAgentMlsId":"NST502018244","CoListAgentKey":"NST98256","CoListAgentMlsId":"NST506008857","ListingContractDate":"2025-06-12T05:00:00Z","ListOfficeKey":"NST14003","ListOfficeName":"Keller Williams Classic Realty","ListOfficeMlsId":"NST1865","ListPrice":"750000","LivingArea":"2967","NST_LockBoxSource":"SPAAR","Longitude":"-93.013117","LotFeatures":"Some Trees","LotSizeDimensions":"88x130x87x125","LotSizeSquareFeet":"13068","LotSizeUnits":"Acres","ListingId":"NST6737476","SourceSystemName":"RMLS","NST_ManufacturedHome":"No","MapCoordinateSource":"King's Street Atlas","AdditionalParcelsYN":"False","NST_OfficeBoard":"SPAAR","ParcelNumber":"1803121210080","GarageSpaces":"4","PhotosCount":"7","PostalCity":"Hugo","PostalCode":"55038","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PublicRemarks":"Your future dream home awaits! This new construction home will feature 4 bedrooms, 3 bathrooms, and an open-concept living and dining area—perfect for modern living. More lots & plans to choose to from!","PublicSurveyRange":"21","PublicSurveySection":"7","PublicSurveyTownship":"31","NST_RentalLicenseYN":"No","Roof":"Age 8 Years or Less,Asphalt","RoomType":"Great Room,Kitchen,Dining Room,Sun Room,Bedroom 1,Bedroom 2,Bedroom 3,Bedroom 4,Loft","NST_AboveGradeSqFtTotal":"2967.0000","NST_BelowGradeSqFtTotal":"1353.0000","NST_MainLevelFinishedArea":"1352.0000","BuildingAreaTotal":"4320","HighSchoolDistrict":"Forest Lake","NST_SchoolDistrictNumber":"831","NST_SchoolDistrictPhone":"651-982-8103","Sewer":"City Sewer/Connected","NST_SpecialSearch":"4 BR on One Level,Main Floor Laundry","AboveGradeFinishedArea":"2967","BelowGradeFinishedArea":"0","StateOrProvince":"MN","StandardStatus":"Active","Levels":"Two","StreetDirSuffix":"N","StreetName":"Ethan","StreetNumber":"15895","StreetNumberNumeric":"15895","StreetSuffix":"Trail","PropertySubType":"Single Family Residence","SubdivisionName":"Prairie Village 4th Addn","NST_TaxWithAssessments":"1574.0000","TaxYear":"2024","TaxAnnualAmount":"1574","WaterSource":"City Water/Connected","YearBuilt":"2025","ZoningDescription":"Residential-Single Family","ModificationTimestamp":"2025-06-13T10:08:10.414Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7757820\",\"Order\":1,\"MediaObjectID\":\"1\",\"LongDescription\":\"Norway E.png\",\"ImageWidth\":1920,\"ImageHeight\":1080,\"ImageSizeDescription\":\"1920x1080\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7757820/278ae2ed-e30b-4edc-8b80-b3f9279e93e4.png\",\"MediaModificationTimestamp\":\"2025-06-12T22:42:32.167Z\",\"MediaKey\":\"684b57d8d9274f77702ffbca\"},{\"ResourceRecordKey\":\"NST7757820\",\"Order\":2,\"MediaObjectID\":\"2\",\"LongDescription\":\"Norway LL1.png\",\"ImageWidth\":1600,\"ImageHeight\":1200,\"ImageSizeDescription\":\"1600x1200\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7757820/4cb0088a-08fb-4fea-a3e6-5f95a3093fcc.png\",\"MediaModificationTimestamp\":\"2025-06-12T22:42:32.114Z\",\"MediaKey\":\"684b57d8d9274f77702ffbcb\"},{\"ResourceRecordKey\":\"NST7757820\",\"Order\":3,\"MediaObjectID\":\"3\",\"LongDescription\":\"Norway LL2.png\",\"ImageWidth\":1600,\"ImageHeight\":1200,\"ImageSizeDescription\":\"1600x1200\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7757820/624ed79f-a3f1-4642-9ad7-6c86e34045f0.png\",\"MediaModificationTimestamp\":\"2025-06-12T22:42:32.091Z\",\"MediaKey\":\"684b57d8d9274f77702ffbcc\"},{\"ResourceRecordKey\":\"NST7757820\",\"Order\":4,\"MediaObjectID\":\"4\",\"LongDescription\":\"Norway ML1.png\",\"ImageWidth\":1600,\"ImageHeight\":1200,\"ImageSizeDescription\":\"1600x1200\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7757820/8ca46dbb-ac4b-4bee-8b8a-c81917dba3c3.png\",\"MediaModificationTimestamp\":\"2025-06-12T22:42:32.175Z\",\"MediaKey\":\"684b57d8d9274f77702ffbcd\"},{\"ResourceRecordKey\":\"NST7757820\",\"Order\":5,\"MediaObjectID\":\"5\",\"LongDescription\":\"Norway ML2.png\",\"ImageWidth\":1600,\"ImageHeight\":1200,\"ImageSizeDescription\":\"1600x1200\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7757820/f084f438-7af0-4381-a8ae-e11560928576.png\",\"MediaModificationTimestamp\":\"2025-06-12T22:42:32.156Z\",\"MediaKey\":\"684b57d8d9274f77702ffbce\"},{\"ResourceRecordKey\":\"NST7757820\",\"Order\":6,\"MediaObjectID\":\"6\",\"LongDescription\":\"Norway UL1.png\",\"ImageWidth\":1600,\"ImageHeight\":1200,\"ImageSizeDescription\":\"1600x1200\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7757820/835c177f-8507-4d8b-84c7-19919807778a.png\",\"MediaModificationTimestamp\":\"2025-06-12T22:42:32.074Z\",\"MediaKey\":\"684b57d8d9274f77702ffbcf\"},{\"ResourceRecordKey\":\"NST7757820\",\"Order\":7,\"MediaObjectID\":\"7\",\"LongDescription\":\"Norway UL2.png\",\"ImageWidth\":1600,\"ImageHeight\":1200,\"ImageSizeDescription\":\"1600x1200\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7757820/ab1e7f3f-a2f2-4796-88aa-42311e006a61.png\",\"MediaModificationTimestamp\":\"2025-06-12T22:42:32.148Z\",\"MediaKey\":\"684b57d8d9274f77702ffbd0\"}]","PhotosChangeTimestamp":"2025-06-12T22:43:03.539Z","Rooms":"[{\"RoomKey\":\"NST115312415\",\"RoomType\":\"Great Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"17x16\",\"NST_RoomSortOrder\":\"1\"},{\"RoomKey\":\"NST115312416\",\"RoomType\":\"Kitchen\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"15x13\",\"NST_RoomSortOrder\":\"2\"},{\"RoomKey\":\"NST115312417\",\"RoomType\":\"Dining Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"14x12\",\"NST_RoomSortOrder\":\"3\"},{\"RoomKey\":\"NST115312418\",\"RoomType\":\"Sun Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"14x12\",\"NST_RoomSortOrder\":\"4\"},{\"RoomKey\":\"NST115312419\",\"RoomType\":\"Bedroom 1\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"16x15\",\"NST_RoomSortOrder\":\"5\"},{\"RoomKey\":\"NST115312420\",\"RoomType\":\"Bedroom 2\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"12x11\",\"NST_RoomSortOrder\":\"6\"},{\"RoomKey\":\"NST115312421\",\"RoomType\":\"Bedroom 3\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"13x12\",\"NST_RoomSortOrder\":\"7\"},{\"RoomKey\":\"NST115312422\",\"RoomType\":\"Bedroom 4\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"13x12\",\"NST_RoomSortOrder\":\"8\"},{\"RoomKey\":\"NST115316690\",\"RoomType\":\"Loft\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"11x6\",\"NST_RoomSortOrder\":\"9\"}]","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"Norway E.png\"},{\"Order\":2,\"Remarks\":\"Norway LL1.png\"},{\"Order\":3,\"Remarks\":\"Norway LL2.png\"},{\"Order\":4,\"Remarks\":\"Norway ML1.png\"},{\"Order\":5,\"Remarks\":\"Norway ML2.png\"},{\"Order\":6,\"Remarks\":\"Norway UL1.png\"},{\"Order\":7,\"Remarks\":\"Norway UL2.png\"}]","PhotoOrder":"1,2,3,4,5,6,7","CustomVTourURL":""}
    ©2025, All rights reserved. Created with REC by AfterNorth.