$LABEL$
$SCONTENT$
MLS# 6799464
19197 Colonial Trail Farmington, MN 55024
Legion Properties 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. Mark Tietjen - Rusty's Up North Realty is not a multiple Listing Service (MLS), nor does it offer MLS access. This website is a service of Mark Tietjen - Rusty's Up North Realty, a broker Participant of the Regional Multiple Listing Service of Minnesota, Inc.
{"Id":1417738,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST6799464","MLSAGENTID":"NST506017978","MLSCOAGENTID":"NST506004157","MLSOFFICEID":"NST252824","ADDRESS":"19197 Colonial Trail","ACRES":0.28,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Drain Tiled,Drainage System,Concrete","BATHSTOTAL":3.0,"BEDROOMS":4,"CITY":"Farmington","CONTINGENCY":"None","COUNTY":"Dakota","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Brick/Stone,Metal Siding,Vinyl Siding","FORECLOSURE":"No","LASTPRICE":497000.0,"LASTPRICEDATE":"2025-10-04T18:49:03.877","LATITUDE":44.671844,"LENDEROWNED":"No","LISTDATE":"2025-10-04T05:00:00","LISTPRICE":497000.0,"LIVINGAREA":3221.0,"LONGITUDE":-93.139977,"LOTDESCRIPTION":"Corner Lot","MODIFICATIONTIMESTAMP":"2025-10-05T10:03:05.277","OFFICE_OFFICENAME":"Legion Properties","PHOTOCOUNT":1,"POSTALCODE":"55024","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Don't miss out on this brand new Dean Johnson Split-Level, 4-Bedroom/3 Bathroom masterpiece. Located on a premier corner lot with unobstructed views, this home has it all: An open floor plan living room and kitchen ideal for entertaining. the future owner will enjoy an owners suite complete with a private walk-in closet and bathroom. The kitchen impresses with a walk in pantry and GE Profile appliances and a center kitchen island. Durable luxury vinyl plank flooring is featured in all bathrooms and the kitchen area, while bedrooms and living areas are ifnished with lush carpeting. This dream home is currently under construction with an stimated finish date of December 2025. Contact us today to secure this one-of-a-kind home.","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Age 8 Years or Less","SCHOOLDISTRICTNUMBER":"192-Farmington","SCHOOLDISTRICTPHONE":"651-463-5000","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2025-10-04T18:49:03.877","LASTSTATUS":"Active","STREETNAME":"Colonial","STREETNUMBER":"19197","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-10-04T19:06:03.507","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"Front of Home Rendering.png\"}]","PHOTOORDER":"1","SOURCE":"MG_NST"}
{"ListingKey":"NST7811589","LotSizeArea":"0.28","NST_AgeOfProperty":"0","NST_AgentOwner":"No","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"False","NST_AmenitiesUnit":"Kitchen Center Island,Primary Bedroom Walk-In Closet","Appliances":"Dishwasher,Electric Water Heater,Microwave,Range,Refrigerator,Stainless Steel Appliances","NST_AssessmentPending":"No","AssociationYN":"False","AssociationFee":"0","AssociationName":"North Creek Master Association Inc","PropertyAttachedYN":"False","NST_AttributionContact":"nino@legionprops.com","NST_AttributionName":"Nino Dreger","Basement":"Drain Tiled,Drainage System,Concrete","BasementYN":"True","NST_BathDesc":"3/4 Basement,3/4 Primary,Double Sink,Main Floor Full Bath","BathroomsOneQuarter":"0","BathroomsFull":"1","BathroomsHalf":"0","BathroomsThreeQuarter":"2","BathroomsTotalInteger":"3","BedroomsTotal":"4","NST_BuilderLicense":"639439","BuilderName":"DEAN JOHNSON HOMES","City":"Farmington","PropertyType":"Residential","NST_CompletionDate":"2025-12-31","NST_ConstructionMaterialsDesc":"Concrete,Frame","NewConstructionYN":"True","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Dakota","NST_DPResource":"Y","DaysOnMarket":"1","CumulativeDaysOnMarket":"1","NST_DiningRoomDescription":"Kitchen/Dining Room","Directions":"195th Street to Colonial Trail, Go South into Development. Home will be 1 block on right hand side.","InternetAddressDisplayYN":"True","InternetEntireListingDisplayYN":"True","Electric":"Circuit Breakers","ConstructionMaterials":"Brick/Stone,Metal Siding,Vinyl Siding","Fencing":"None","FireplaceYN":"False","FireplacesTotal":"0","NST_ForeclosureStatus":"No","FoundationArea":"1104","NST_FractionalOwnershipYN":"No","RoadFrontageType":"City Street","NST_Fuel":"Natural Gas","ParkingFeatures":"Attached Garage,Asphalt","NST_GarageDimensions":"32 x 21-4","NST_GarageDoorHeight":"7","NST_GarageDoorWidth":"16","NST_GarageSquareFeet":"678","AccessibilityFeatures":"None","Heating":"Forced Air","OriginalEntryTimestamp":"2025-10-04T18:47:51Z","LandLeaseYN":"False","NST_LastUpdateDate":"2025-10-05","Latitude":"44.671844","NST_LenderOwned":"No","ListAgentKey":"NST229192","ListAgentMlsId":"NST506017978","CoListAgentKey":"NST84733","CoListAgentMlsId":"NST506004157","ListingContractDate":"2025-10-04T05:00:00Z","ListOfficeKey":"NST1001566","ListOfficeName":"Legion Properties","ListOfficeMlsId":"NST252824","ListPrice":"497000","LivingArea":"3221","LockBoxType":"None","Longitude":"-93.139977","LotFeatures":"Corner Lot","LotSizeDimensions":"150 x 108 x 151 x 53","LotSizeSquareFeet":"12109.68","LotSizeUnits":"Acres","ListingId":"NST6799464","SourceSystemName":"RMLS","NST_ManufacturedHome":"No","MapCoordinateSource":"King's Street Atlas","AdditionalParcelsYN":"False","NST_OfficeBoard":"SPAAR","ParcelNumber":"142560501090","GarageSpaces":"3","PhotosCount":"1","PostalCity":"Farmington","PostalCode":"55024","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PublicRemarks":"Don't miss out on this brand new Dean Johnson Split-Level, 4-Bedroom/3 Bathroom masterpiece. Located on a premier corner lot with unobstructed views, this home has it all: An open floor plan living room and kitchen ideal for entertaining. the future owner will enjoy an owners suite complete with a private walk-in closet and bathroom. The kitchen impresses with a walk in pantry and GE Profile appliances and a center kitchen island. Durable luxury vinyl plank flooring is featured in all bathrooms and the kitchen area, while bedrooms and living areas are ifnished with lush carpeting. This dream home is currently under construction with an stimated finish date of December 2025. Contact us today to secure this one-of-a-kind home.","NST_RentalLicenseYN":"No","RoadResponsibility":"Public Maintained Road","Roof":"Age 8 Years or Less","RoomType":"Bedroom 1,Bedroom 2,Bedroom 3,Bedroom 4,Bathroom,Living Room,Walk In Closet,Laundry,Office,Dining Room,Family Room,Kitchen","NST_AboveGradeSqFtTotal":"2217.0000","NST_BelowGradeSqFtTotal":"1104.0000","NST_MainLevelFinishedArea":"1213.0000","BuildingAreaTotal":"3321","HighSchoolDistrict":"Farmington","NST_SchoolDistrictNumber":"192","NST_SchoolDistrictPhone":"651-463-5000","Sewer":"City Sewer/Connected","NST_SpecialSearch":"Primary Bdr Suite","AboveGradeFinishedArea":"2217","BelowGradeFinishedArea":"1004","StateOrProvince":"MN","StandardStatus":"Active","Levels":"Split Entry (Bi-Level)","StreetName":"Colonial","StreetNumber":"19197","StreetNumberNumeric":"19197","StreetSuffix":"Trail","PropertySubType":"Single Family Residence","SubdivisionName":"Fairhill Estate At North Creek","NST_TaxWithAssessments":"1778.0000","TaxYear":"2025","TaxAnnualAmount":"1778","NST_TotalUnitsSold":"0","WaterSource":"City Water/Connected","YearBuilt":"2025","ZoningDescription":"Residential-Single Family","ModificationTimestamp":"2025-10-05T10:03:05.277Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7811589\",\"Order\":1,\"MediaObjectID\":\"1\",\"LongDescription\":\"Front of Home Rendering.png\",\"ImageWidth\":1291,\"ImageHeight\":529,\"ImageSizeDescription\":\"1291x529\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7811589/b773eec3-898e-4f1e-91e3-e10b3c0bfb56.png\",\"MediaModificationTimestamp\":\"2025-10-04T19:05:19.277Z\",\"MediaKey\":\"68e16fefe566fc6eb05ca7b9\"}]","PhotosChangeTimestamp":"2025-10-04T19:06:03.507Z","Rooms":"[{\"RoomKey\":\"NST115674539\",\"RoomType\":\"Bedroom 1\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"14 x 12\",\"NST_RoomSortOrder\":\"1\"},{\"RoomKey\":\"NST115674540\",\"RoomType\":\"Bedroom 2\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"11 x 11\",\"NST_RoomSortOrder\":\"2\"},{\"RoomKey\":\"NST115674541\",\"RoomType\":\"Bedroom 3\",\"RoomLevel\":\"Lower\",\"RoomDimensions\":\"11 x 10\",\"NST_RoomSortOrder\":\"3\"},{\"RoomKey\":\"NST115674542\",\"RoomType\":\"Bedroom 4\",\"RoomLevel\":\"Lower\",\"RoomDimensions\":\"11 x 11\",\"NST_RoomSortOrder\":\"4\"},{\"RoomKey\":\"NST115674543\",\"RoomType\":\"Bathroom\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"7 x 7\",\"NST_RoomSortOrder\":\"5\"},{\"RoomKey\":\"NST115674544\",\"RoomType\":\"Bathroom\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"9 x 5\",\"NST_RoomSortOrder\":\"6\"},{\"RoomKey\":\"NST115674545\",\"RoomType\":\"Living Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"18 x 12\",\"NST_RoomSortOrder\":\"7\"},{\"RoomKey\":\"NST115674546\",\"RoomType\":\"Walk In Closet\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"7 x 4\",\"NST_RoomSortOrder\":\"8\"},{\"RoomKey\":\"NST115674547\",\"RoomType\":\"Laundry\",\"RoomLevel\":\"Lower\",\"RoomDimensions\":\"8 x 6\",\"NST_RoomSortOrder\":\"9\"},{\"RoomKey\":\"NST115674548\",\"RoomType\":\"Office\",\"RoomLevel\":\"Lower\",\"RoomDimensions\":\"10 x 11\",\"NST_RoomSortOrder\":\"10\"},{\"RoomKey\":\"NST115674549\",\"RoomType\":\"Dining Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"12 x 10\",\"NST_RoomSortOrder\":\"11\"},{\"RoomKey\":\"NST115674550\",\"RoomType\":\"Bathroom\",\"RoomLevel\":\"Lower\",\"RoomDimensions\":\"8 x 5\",\"NST_RoomSortOrder\":\"12\"},{\"RoomKey\":\"NST115674551\",\"RoomType\":\"Family Room\",\"RoomLevel\":\"Lower\",\"RoomDimensions\":\"24 x 22\",\"NST_RoomSortOrder\":\"13\"},{\"RoomKey\":\"NST115674552\",\"RoomType\":\"Kitchen\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"16 x 12\",\"NST_RoomSortOrder\":\"14\"}]","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"Front of Home Rendering.png\"}]","PhotoOrder":"1","CustomVTourURL":""}
