{"Id":1396222,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST6754043","MLSAGENTID":"NST502042365","MLSOFFICEID":"NST3075","ADDRESS":"3467 Trails End Road","ACRES":0.08,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Finished,Walkout","BATHSTOTAL":2.0,"BEDROOMS":2,"CITY":"Eagan","CONTINGENCY":"None","COUNTY":"Dakota","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Engineered Wood","FORECLOSURE":"No","LASTPRICE":310000.0,"LASTPRICEDATE":"2025-08-15T14:12:04.243","LATITUDE":44.831937,"LENDEROWNED":"No","LISTDATE":"2025-08-15T05:00:00","LISTPRICE":310000.0,"LIVINGAREA":1680.0,"LONGITUDE":-93.130017,"LOTDESCRIPTION":"Zero Lot Line","MODIFICATIONTIMESTAMP":"2025-08-16T10:31:05.993","OFFICE_OFFICENAME":"Edina Realty, Inc.","PHOTOCOUNT":18,"POSTALCODE":"55123","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Tons of natural light, nice deck. Updated appliances / HVAC, Roof newer,The upper level features two spacious bedrooms, a large primary with a walk-in closet. The walkout lower level includes a large family room with a gas fireplace, updated 3/4 bath. The tuckunder 2-car garage provides plenty of storage. 196 school district. Conveniently located near shopping, dining, major highways and public transit.","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Age 8 Years or Less,Asphalt","SCHOOLDISTRICTNUMBER":"196-Rosemount-Apple Valley-Eagan","SCHOOLDISTRICTPHONE":"651-423-7700","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2025-08-15T14:12:04.243","LASTSTATUS":"Active","STREETNAME":"Trails End","STREETNUMBER":"3467","STREETSUFFIX":"Road","STYLE":"Townhouse Side x Side","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1991,"ZONING":"Residential-Single Family","HASOPENHOUSE":true,"PHOTOTIMESTAMP":"2025-08-15T14:12:04.244","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"Welcome Home!\"},{\"Order\":2,\"Remarks\":\"Open Floor plan\"},{\"Order\":3,\"Remarks\":\"Vaulted Ceilings\"},{\"Order\":4,\"Remarks\":\"Main Floor Living Room\"},{\"Order\":5,\"Remarks\":\"Dining Room\"},{\"Order\":6,\"Remarks\":\"Updated Stainless Appliances\"},{\"Order\":7,\"Remarks\":\"Kitchen\"},{\"Order\":8,\"Remarks\":\"Primary Bedroom\"},{\"Order\":9,\"Remarks\":\"Primary Bedroom w/Walk in\"},{\"Order\":10,\"Remarks\":\"Upper Level Full Bath\"},{\"Order\":11,\"Remarks\":\"Separate Tub in Full Bath\"},{\"Order\":12,\"Remarks\":\"2nd Bedroom\"},{\"Order\":13,\"Remarks\":\"Lower Level Family Room\"},{\"Order\":14,\"Remarks\":\"Lower Level Walk Out\"},{\"Order\":15,\"Remarks\":\"Lower Level 3/4 Bath & Laundry\"},{\"Order\":16,\"Remarks\":\"Low Maintenance Deck\"},{\"Order\":17,\"Remarks\":\"Lower Level Patio Area\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18","SOURCE":"MG_NST"}
{"ListingKey":"NST7772151","LotSizeArea":"0.08","NST_AgeOfProperty":"34","NST_AgentOwner":"No","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"True","AssociationAmenities":"None","NST_AmenitiesUnit":"Ceiling Fan(s),Deck,Kitchen Window,Patio,In-Ground Sprinkler,Vaulted Ceiling(s),Washer/Dryer Hookup,Walk-In Closet","Appliances":"Dishwasher,Dryer,Microwave,Range,Refrigerator,Stainless Steel Appliances,Washer,Water Softener Owned","NST_AssessmentPending":"No","AssociationFeeIncludes":"Lawn Care,Maintenance Grounds,Professional Mgmt,Trash,Snow Removal","AssociationFeeFrequency":"Monthly","AssociationYN":"True","AssociationFee":"385","AssociationName":"Sharper Touch Management","AssociationPhone":"952-224-4777","PropertyAttachedYN":"True","Basement":"Finished,Walkout","BasementYN":"True","NST_BathDesc":"3/4 Basement,Separate Tub & Shower,Upper Level Full Bath","BathroomsOneQuarter":"0","BathroomsFull":"1","BathroomsHalf":"0","BathroomsThreeQuarter":"1","BathroomsTotalInteger":"2","BedroomsTotal":"2","City":"Eagan","PropertyType":"Residential","NST_ConstructionMaterialsDesc":"Block","NewConstructionYN":"False","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Dakota","NST_DPResource":"Y","DaysOnMarket":"1","CumulativeDaysOnMarket":"1","NST_DiningRoomDescription":"Kitchen/Dining Room","Directions":"35E to Yankee Doodle Rd, east to Ivy, east to Trails End on left.","InternetAddressDisplayYN":"True","InternetEntireListingDisplayYN":"True","Electric":"100 Amp Service","ConstructionMaterials":"Engineered Wood","Fencing":"None","FireplaceFeatures":"Two Sided,Gas","FireplaceYN":"True","FireplacesTotal":"1","NST_ForeclosureStatus":"No","NST_FoundationDimensions":"30x24","FoundationArea":"1240","NST_FractionalOwnershipYN":"No","RoadFrontageType":"City Street","NST_Fuel":"Natural Gas","ParkingFeatures":"Attached Garage,Asphalt,Shared Driveway,Garage Door Opener,Insulated Garage,Tuckunder Garage","NST_GarageDimensions":"24x20","NST_GarageDoorHeight":"9","NST_GarageDoorWidth":"16","NST_GarageSquareFeet":"450","AccessibilityFeatures":"None","Heating":"Forced Air","OriginalEntryTimestamp":"2025-08-15T14:08:09Z","NST_InternetOptions":"Cable,Satellite","LandLeaseYN":"False","NST_LastUpdateDate":"2025-08-16","Latitude":"44.831937","NST_LenderOwned":"No","ListAgentKey":"NST98339","ListAgentMlsId":"NST502042365","ListingContractDate":"2025-08-15T05:00:00Z","ListOfficeKey":"NST16488","ListOfficeName":"Edina Realty, Inc.","ListOfficeMlsId":"NST3075","ListPrice":"310000","LivingArea":"1680","NST_LockBoxSource":"SPAAR","LockBoxType":"Supra","Longitude":"-93.130017","LotFeatures":"Zero Lot Line","LotSizeDimensions":"97x66","LotSizeSquareFeet":"3484.8","LotSizeUnits":"Acres","ListingId":"NST6754043","SourceSystemName":"RMLS","NST_ManufacturedHome":"No","MapCoordinateSource":"King's Street Atlas","AdditionalParcelsYN":"False","NST_OfficeBoard":"SPAAR","ParcelNumber":"108373002060","GarageSpaces":"2","NST_PatioPorchType":"Composite Decking,Deck","PhotosCount":"18","PoolFeatures":"None","PostalCity":"Saint Paul","PostalCode":"55123","NST_PotentialShortSale":"No","NST_PowerCompanyName":"Dakota Electric Association","NST_PresentUse":"Yearly","PublicRemarks":"Tons of natural light, nice deck. Updated appliances / HVAC, Roof newer,The upper level features two spacious bedrooms, a large primary with a walk-in closet. The walkout lower level includes a large family room with a gas fireplace, updated 3/4 bath. The tuckunder 2-car garage provides plenty of storage. 196 school district. Conveniently located near shopping, dining, major highways and public transit.","PublicSurveyRange":"23","PublicSurveySection":"14","PublicSurveyTownship":"27","NST_RentalLicenseYN":"No","NST_Restrictions":"Mandatory Owners Assoc,Pets - Cats Allowed,Pets - Dogs Allowed,Pets - Number Limit,Pets - Weight/Height Limit,Rental Restrictions May Apply","RoadResponsibility":"Public Maintained Road","Roof":"Age 8 Years or Less,Asphalt","RoomType":"Living Room,Dining Room,Family Room,Kitchen,Bedroom 1,Bedroom 2","NST_AboveGradeSqFtTotal":"1680.0000","NST_BelowGradeSqFtTotal":"440.0000","NST_MainLevelFinishedArea":"1240.0000","BuildingAreaTotal":"2120","HighSchoolDistrict":"Rosemount-Apple Valley-Eagan","NST_SchoolDistrictNumber":"196","NST_SchoolDistrictPhone":"651-423-7700","Sewer":"City Sewer/Connected","AboveGradeFinishedArea":"1240","BelowGradeFinishedArea":"440","StateOrProvince":"MN","StandardStatus":"Active","Levels":"Two","StreetName":"Trails End","StreetNumber":"3467","StreetNumberNumeric":"3467","StreetSuffix":"Road","PropertySubType":"Townhouse Side x Side","SubdivisionName":"Wescott Square","NST_TaxWithAssessments":"2682.0000","TaxYear":"2025","TaxAnnualAmount":"2682","WaterSource":"City Water/Connected","YearBuilt":"1991","ZoningDescription":"Residential-Single Family","ModificationTimestamp":"2025-08-16T10:31:05.993Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7772151\",\"Order\":1,\"MediaObjectID\":\"1\",\"LongDescription\":\"Welcome Home!\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7772151/ae81fd90-ce0c-4123-a585-71fa9aff5878.jpeg\",\"MediaModificationTimestamp\":\"2025-08-15T14:11:30.718Z\",\"MediaKey\":\"689f401217889016543cf7f2\"},{\"ResourceRecordKey\":\"NST7772151\",\"Order\":2,\"MediaObjectID\":\"2\",\"LongDescription\":\"Open Floor plan\",\"ImageWidth\":2080,\"ImageHeight\":1384,\"ImageSizeDescription\":\"2080x1384\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7772151/96ff17a5-310d-4c4f-97a5-73655919098b.jpeg\",\"MediaModificationTimestamp\":\"2025-08-15T14:11:30.646Z\",\"MediaKey\":\"689f401217889016543cf7f3\"},{\"ResourceRecordKey\":\"NST7772151\",\"Order\":3,\"MediaObjectID\":\"3\",\"LongDescription\":\"Vaulted Ceilings\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7772151/4a672ea8-d2a7-46b6-896c-1bcb7f0197f1.jpeg\",\"MediaModificationTimestamp\":\"2025-08-15T14:11:30.686Z\",\"MediaKey\":\"689f401217889016543cf7f4\"},{\"ResourceRecordKey\":\"NST7772151\",\"Order\":4,\"MediaObjectID\":\"4\",\"LongDescription\":\"Main Floor Living Room\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7772151/06f3106b-eed6-4938-a46c-7796d5c07ece.jpeg\",\"MediaModificationTimestamp\":\"2025-08-15T14:11:30.685Z\",\"MediaKey\":\"689f401217889016543cf7f5\"},{\"ResourceRecordKey\":\"NST7772151\",\"Order\":5,\"MediaObjectID\":\"5\",\"LongDescription\":\"Dining Room\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7772151/d5ccb3c0-8040-4e49-8499-86b00f08b6e9.jpeg\",\"MediaModificationTimestamp\":\"2025-08-15T14:11:30.69Z\",\"MediaKey\":\"689f401217889016543cf7f6\"},{\"ResourceRecordKey\":\"NST7772151\",\"Order\":6,\"MediaObjectID\":\"6\",\"LongDescription\":\"Updated Stainless Appliances\",\"ImageWidth\":2080,\"ImageHeight\":1382,\"ImageSizeDescription\":\"2080x1382\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7772151/c7f6e34f-0c45-49d8-9e21-ec6b0c191648.jpeg\",\"MediaModificationTimestamp\":\"2025-08-15T14:11:30.705Z\",\"MediaKey\":\"689f401217889016543cf7f7\"},{\"ResourceRecordKey\":\"NST7772151\",\"Order\":7,\"MediaObjectID\":\"7\",\"LongDescription\":\"Kitchen\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7772151/a80615df-ae7e-48d7-8913-d525927ea2b1.jpeg\",\"MediaModificationTimestamp\":\"2025-08-15T14:11:30.728Z\",\"MediaKey\":\"689f401217889016543cf7f8\"},{\"ResourceRecordKey\":\"NST7772151\",\"Order\":8,\"MediaObjectID\":\"8\",\"LongDescription\":\"Primary Bedroom\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7772151/b7c84a42-cbee-4dfc-8361-5385bf451b4f.jpeg\",\"MediaModificationTimestamp\":\"2025-08-15T14:11:30.675Z\",\"MediaKey\":\"689f401217889016543cf7f9\"},{\"ResourceRecordKey\":\"NST7772151\",\"Order\":9,\"MediaObjectID\":\"9\",\"LongDescription\":\"Primary Bedroom w/Walk in\",\"ImageWidth\":2080,\"ImageHeight\":1372,\"ImageSizeDescription\":\"2080x1372\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7772151/f415ff86-cd43-4047-bbfd-522edc791e1a.jpeg\",\"MediaModificationTimestamp\":\"2025-08-15T14:11:30.646Z\",\"MediaKey\":\"689f401217889016543cf7fa\"},{\"ResourceRecordKey\":\"NST7772151\",\"Order\":10,\"MediaObjectID\":\"10\",\"LongDescription\":\"Upper Level Full Bath\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7772151/82d1c61a-72ad-4e70-80bb-4658a9cf1c83.jpeg\",\"MediaModificationTimestamp\":\"2025-08-15T14:11:30.684Z\",\"MediaKey\":\"689f401217889016543cf7fb\"},{\"ResourceRecordKey\":\"NST7772151\",\"Order\":11,\"MediaObjectID\":\"11\",\"LongDescription\":\"Separate Tub in Full Bath\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7772151/b530d3d8-0927-4e58-a883-bdc65bdefa9e.jpeg\",\"MediaModificationTimestamp\":\"2025-08-15T14:11:30.679Z\",\"MediaKey\":\"689f401217889016543cf7fc\"},{\"ResourceRecordKey\":\"NST7772151\",\"Order\":12,\"MediaObjectID\":\"12\",\"LongDescription\":\"2nd Bedroom\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7772151/eed402a3-baff-4581-92b3-b2ac69544bb6.jpeg\",\"MediaModificationTimestamp\":\"2025-08-15T14:11:30.633Z\",\"MediaKey\":\"689f401217889016543cf7fd\"},{\"ResourceRecordKey\":\"NST7772151\",\"Order\":13,\"MediaObjectID\":\"13\",\"LongDescription\":\"Lower Level Family Room\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7772151/435747d8-980a-4192-9452-461f38f07343.jpeg\",\"MediaModificationTimestamp\":\"2025-08-15T14:11:30.646Z\",\"MediaKey\":\"689f401217889016543cf7fe\"},{\"ResourceRecordKey\":\"NST7772151\",\"Order\":14,\"MediaObjectID\":\"14\",\"LongDescription\":\"Lower Level Walk Out\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7772151/f3dfbc78-058c-4f44-aab2-856d2dc21670.jpeg\",\"MediaModificationTimestamp\":\"2025-08-15T14:11:30.647Z\",\"MediaKey\":\"689f401217889016543cf7ff\"},{\"ResourceRecordKey\":\"NST7772151\",\"Order\":15,\"MediaObjectID\":\"15\",\"LongDescription\":\"Lower Level 3/4 Bath & Laundry\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7772151/3412c5c2-2799-4f13-b235-9cf617df4678.jpeg\",\"MediaModificationTimestamp\":\"2025-08-15T14:11:30.693Z\",\"MediaKey\":\"689f401217889016543cf800\"},{\"ResourceRecordKey\":\"NST7772151\",\"Order\":16,\"MediaObjectID\":\"16\",\"LongDescription\":\"Low Maintenance Deck\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7772151/22f1af79-ae82-40ee-a4c1-060a5095d220.jpeg\",\"MediaModificationTimestamp\":\"2025-08-15T14:11:30.669Z\",\"MediaKey\":\"689f401217889016543cf801\"},{\"ResourceRecordKey\":\"NST7772151\",\"Order\":17,\"MediaObjectID\":\"17\",\"LongDescription\":\"Lower Level Patio Area\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7772151/80a27171-67c3-4805-8b16-18dd2d04fe71.jpeg\",\"MediaModificationTimestamp\":\"2025-08-15T14:11:30.718Z\",\"MediaKey\":\"689f401217889016543cf802\"},{\"ResourceRecordKey\":\"NST7772151\",\"Order\":18,\"MediaObjectID\":\"18\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7772151/d23e5a97-832b-4ec6-8432-678a6f57c646.jpeg\",\"MediaModificationTimestamp\":\"2025-08-15T14:11:30.739Z\",\"MediaKey\":\"689f401217889016543cf803\"}]","PhotosChangeTimestamp":"2025-08-15T14:12:04.244Z","Rooms":"[{\"RoomKey\":\"NST115518488\",\"RoomType\":\"Living Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"19x18\",\"NST_RoomSortOrder\":\"1\"},{\"RoomKey\":\"NST115518489\",\"RoomType\":\"Dining Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"10x9\",\"NST_RoomSortOrder\":\"2\"},{\"RoomKey\":\"NST115518490\",\"RoomType\":\"Family Room\",\"RoomLevel\":\"Lower\",\"RoomDimensions\":\"20x18\",\"NST_RoomSortOrder\":\"3\"},{\"RoomKey\":\"NST115518491\",\"RoomType\":\"Kitchen\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"12x10\",\"NST_RoomSortOrder\":\"4\"},{\"RoomKey\":\"NST115518492\",\"RoomType\":\"Bedroom 1\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"18x11\",\"NST_RoomSortOrder\":\"5\"},{\"RoomKey\":\"NST115518493\",\"RoomType\":\"Bedroom 2\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"12x10\",\"NST_RoomSortOrder\":\"6\"}]","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"Welcome Home!\"},{\"Order\":2,\"Remarks\":\"Open Floor plan\"},{\"Order\":3,\"Remarks\":\"Vaulted Ceilings\"},{\"Order\":4,\"Remarks\":\"Main Floor Living Room\"},{\"Order\":5,\"Remarks\":\"Dining Room\"},{\"Order\":6,\"Remarks\":\"Updated Stainless Appliances\"},{\"Order\":7,\"Remarks\":\"Kitchen\"},{\"Order\":8,\"Remarks\":\"Primary Bedroom\"},{\"Order\":9,\"Remarks\":\"Primary Bedroom w/Walk in\"},{\"Order\":10,\"Remarks\":\"Upper Level Full Bath\"},{\"Order\":11,\"Remarks\":\"Separate Tub in Full Bath\"},{\"Order\":12,\"Remarks\":\"2nd Bedroom\"},{\"Order\":13,\"Remarks\":\"Lower Level Family Room\"},{\"Order\":14,\"Remarks\":\"Lower Level Walk Out\"},{\"Order\":15,\"Remarks\":\"Lower Level 3/4 Bath & Laundry\"},{\"Order\":16,\"Remarks\":\"Low Maintenance Deck\"},{\"Order\":17,\"Remarks\":\"Lower Level Patio Area\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18","CustomVTourURL":""}