{"Id":1394142,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST6770278","MLSAGENTID":"NST496503916","MLSOFFICEID":"NST6995","ADDRESS":"3275 Coleshire Path","ACRES":0.0,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"None","BATHSTOTAL":3.0,"BEDROOMS":3,"CITY":"Rosemount","CONTINGENCY":"None","COUNTY":"Dakota","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Vinyl Siding","FORECLOSURE":"No","LASTPRICE":275000.0,"LASTPRICEDATE":"2025-08-11T15:25:04.417","LATITUDE":44.751451,"LENDEROWNED":"No","LISTDATE":"2025-08-11T05:00:00","LISTPRICE":275000.0,"LIVINGAREA":1428.0,"LONGITUDE":-93.131489,"MODIFICATIONTIMESTAMP":"2025-08-12T10:05:04.849","OFFICE_OFFICENAME":"Savvy Avenue, LLC","PHOTOCOUNT":24,"POSTALCODE":"55068","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Bright and inviting 3BR/2.5BA townhome in ISD 196! Main level offers an open living/dining area with a cozy gas fireplace, spacious kitchen, and convenient half bath. Upstairs features a primary suite with private full bath, two additional bedrooms, a second full bath, and laundry on the same level. Enjoy the front patio and 2-car attached garage with myQ smart opener. Energy-smart Ecobee thermostat helps keep utilities in check. HOA covers snow removal, lawn care, trash, and water—low-maintenance living just minutes to Rosemount High School and the shops, dining, and events in downtown Rosemount. Built 2004, approx 1,428 sq ft.","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Age 8 Years or Less","SCHOOLDISTRICTNUMBER":"196-Rosemount-Apple Valley-Eagan","SCHOOLDISTRICTPHONE":"651-423-7700","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2025-08-11T15:25:04.417","LASTSTATUS":"Active","STREETNAME":"Coleshire","STREETNUMBER":"3275","STREETSUFFIX":"Path","STYLE":"Townhouse Side x Side","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":2004,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2025-08-11T15:23:04.981","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24","SOURCE":"MG_NST"}
{"ListingKey":"NST7786310","LotSizeArea":"0","NST_AgeOfProperty":"21","NST_AgentOwner":"No","InternetAutomatedValuationDisplayYN":"False","InternetConsumerCommentYN":"False","AssociationAmenities":"In-Ground Sprinkler System","NST_AmenitiesUnit":"Cable,Ethernet Wired,Primary Bedroom Walk-In Closet,Patio,Washer/Dryer Hookup","Appliances":"Dishwasher,Disposal,Dryer,Microwave,Range,Refrigerator,Washer","NST_AssessmentPending":"No","AssociationFeeIncludes":"Lawn Care,Maintenance Grounds,Professional Mgmt,Trash,Sewer","AssociationFeeFrequency":"Monthly","AssociationYN":"True","AssociationFee":"329","AssociationName":"Association One","AssociationPhone":"833-737-8663","PropertyAttachedYN":"True","Basement":"None","BasementYN":"False","NST_BathDesc":"Private Primary,Main Floor 1/2 Bath,Upper Level Full Bath","BathroomsOneQuarter":"0","BathroomsFull":"2","BathroomsHalf":"1","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"3","BedroomsTotal":"3","City":"Rosemount","PropertyType":"Residential","NewConstructionYN":"False","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Dakota","NST_DPResource":"Y","DaysOnMarket":"1","CumulativeDaysOnMarket":"1","NST_DiningRoomDescription":"Living/Dining Room","Directions":"From Eagan: Take highway 3/South Robert Trail southbound. Turn left at Connemara Trail. Continue until you reach Coleshire Path, then take a left. Coleshire Path will continue on the left, eventually coming to a curve. Continue on the curve. House is middle unit in the first building on the right.","InternetAddressDisplayYN":"True","InternetEntireListingDisplayYN":"True","Electric":"Circuit Breakers","ConstructionMaterials":"Vinyl Siding","Fencing":"Vinyl","FireplaceFeatures":"Gas,Living Room","FireplaceYN":"True","FireplacesTotal":"1","NST_ForeclosureStatus":"No","FoundationArea":"578","NST_FractionalOwnershipYN":"No","NST_Fuel":"Electric,Natural Gas","ParkingFeatures":"Attached Garage","NST_GarageSquareFeet":"440","AccessibilityFeatures":"None","Heating":"Forced Air,Fireplace(s)","OriginalEntryTimestamp":"2025-08-11T15:19:43Z","LandLeaseYN":"False","NST_LastUpdateDate":"2025-08-12","Latitude":"44.751451","NST_LenderOwned":"No","ListAgentKey":"NST66700","ListAgentMlsId":"NST496503916","ListingContractDate":"2025-08-11T05:00:00Z","ListOfficeKey":"NST17322","ListOfficeName":"Savvy Avenue, LLC","ListOfficeMlsId":"NST6995","ListPrice":"275000","LivingArea":"1428","Longitude":"-93.131489","LotSizeDimensions":"Common","LotSizeSquareFeet":"0","LotSizeUnits":"Acres","ListingId":"NST6770278","SourceSystemName":"RMLS","NST_ManufacturedHome":"No","MapCoordinateSource":"King's Street Atlas","AdditionalParcelsYN":"False","NST_OfficeBoard":"MAAR","ParcelNumber":"346550005024","GarageSpaces":"2","PhotosCount":"24","PostalCity":"Rosemount","PostalCode":"55068","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PublicRemarks":"Bright and inviting 3BR/2.5BA townhome in ISD 196! Main level offers an open living/dining area with a cozy gas fireplace, spacious kitchen, and convenient half bath. Upstairs features a primary suite with private full bath, two additional bedrooms, a second full bath, and laundry on the same level. Enjoy the front patio and 2-car attached garage with myQ smart opener. Energy-smart Ecobee thermostat helps keep utilities in check. HOA covers snow removal, lawn care, trash, and water—low-maintenance living just minutes to Rosemount High School and the shops, dining, and events in downtown Rosemount. Built 2004, approx 1,428 sq ft.","PublicSurveyRange":"19","PublicSurveySection":"20","PublicSurveyTownship":"115","NST_RentalLicenseYN":"No","NST_Restrictions":"Pets - Cats Allowed,Pets - Dogs Allowed,Pets - Number Limit,Pets - Weight/Height Limit","Roof":"Age 8 Years or Less","NST_AboveGradeSqFtTotal":"1428.0000","NST_BelowGradeSqFtTotal":"0.0000","NST_MainLevelFinishedArea":"555.0000","BuildingAreaTotal":"1428","HighSchoolDistrict":"Rosemount-Apple Valley-Eagan","NST_SchoolDistrictNumber":"196","NST_SchoolDistrictPhone":"651-423-7700","Sewer":"City Sewer/Connected","NST_SpecialSearch":"2nd Floor Laundry,3 BR on One Level","AboveGradeFinishedArea":"1428","BelowGradeFinishedArea":"0","StateOrProvince":"MN","StandardStatus":"Active","Levels":"Two","StreetName":"Coleshire","StreetNumber":"3275","StreetNumberNumeric":"3275","StreetSuffix":"Path","PropertySubType":"Townhouse Side x Side","NST_TaxWithAssessments":"2496.0000","TaxYear":"2025","TaxAnnualAmount":"2496","WaterSource":"City Water/Connected","YearBuilt":"2004","ZoningDescription":"Residential-Single Family","ModificationTimestamp":"2025-08-12T10:05:04.849Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7786310\",\"Order\":1,\"MediaObjectID\":\"1\",\"ImageWidth\":2080,\"ImageHeight\":1170,\"ImageSizeDescription\":\"2080x1170\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7786310/58ce4259-346e-4d97-a1b1-f9dd0f35d345.jpeg\",\"MediaModificationTimestamp\":\"2025-08-11T15:22:40.768Z\",\"MediaKey\":\"689a0ac06c8f653b4dd7dc77\"},{\"ResourceRecordKey\":\"NST7786310\",\"Order\":2,\"MediaObjectID\":\"2\",\"ImageWidth\":2080,\"ImageHeight\":1170,\"ImageSizeDescription\":\"2080x1170\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7786310/0a7bdb16-d0e8-4e00-bada-48d353003bbb.jpeg\",\"MediaModificationTimestamp\":\"2025-08-11T15:22:40.727Z\",\"MediaKey\":\"689a0ac06c8f653b4dd7dc78\"},{\"ResourceRecordKey\":\"NST7786310\",\"Order\":3,\"MediaObjectID\":\"3\",\"ImageWidth\":2080,\"ImageHeight\":1170,\"ImageSizeDescription\":\"2080x1170\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7786310/6eb69b07-1ac2-480d-b6c7-0c209955af4b.jpeg\",\"MediaModificationTimestamp\":\"2025-08-11T15:22:40.703Z\",\"MediaKey\":\"689a0ac06c8f653b4dd7dc79\"},{\"ResourceRecordKey\":\"NST7786310\",\"Order\":4,\"MediaObjectID\":\"4\",\"ImageWidth\":2080,\"ImageHeight\":1170,\"ImageSizeDescription\":\"2080x1170\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7786310/1e440854-5e90-40bd-a30f-7e2331553ec9.jpeg\",\"MediaModificationTimestamp\":\"2025-08-11T15:22:40.713Z\",\"MediaKey\":\"689a0ac06c8f653b4dd7dc7a\"},{\"ResourceRecordKey\":\"NST7786310\",\"Order\":5,\"MediaObjectID\":\"5\",\"ImageWidth\":2080,\"ImageHeight\":1170,\"ImageSizeDescription\":\"2080x1170\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7786310/b9f17015-5a34-4037-b2de-35489ab7b9c1.jpeg\",\"MediaModificationTimestamp\":\"2025-08-11T15:22:40.726Z\",\"MediaKey\":\"689a0ac06c8f653b4dd7dc7b\"},{\"ResourceRecordKey\":\"NST7786310\",\"Order\":6,\"MediaObjectID\":\"6\",\"ImageWidth\":2080,\"ImageHeight\":1170,\"ImageSizeDescription\":\"2080x1170\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7786310/4dc24e65-796f-4a2f-a7b1-4ae7494da9c4.jpeg\",\"MediaModificationTimestamp\":\"2025-08-11T15:22:40.751Z\",\"MediaKey\":\"689a0ac06c8f653b4dd7dc7c\"},{\"ResourceRecordKey\":\"NST7786310\",\"Order\":7,\"MediaObjectID\":\"7\",\"ImageWidth\":2080,\"ImageHeight\":1170,\"ImageSizeDescription\":\"2080x1170\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7786310/64312efb-a79f-47db-a8a6-9ca2069e0141.jpeg\",\"MediaModificationTimestamp\":\"2025-08-11T15:22:40.706Z\",\"MediaKey\":\"689a0ac06c8f653b4dd7dc7d\"},{\"ResourceRecordKey\":\"NST7786310\",\"Order\":8,\"MediaObjectID\":\"8\",\"ImageWidth\":1170,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1170x2080\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7786310/2de06dd4-d57a-49c8-b814-37ca369ebf24.jpeg\",\"MediaModificationTimestamp\":\"2025-08-11T15:22:40.823Z\",\"MediaKey\":\"689a0ac06c8f653b4dd7dc7e\"},{\"ResourceRecordKey\":\"NST7786310\",\"Order\":9,\"MediaObjectID\":\"9\",\"ImageWidth\":1170,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1170x2080\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7786310/b84379dd-f284-4d7a-abd8-fc32824dfc7a.jpeg\",\"MediaModificationTimestamp\":\"2025-08-11T15:22:40.674Z\",\"MediaKey\":\"689a0ac06c8f653b4dd7dc7f\"},{\"ResourceRecordKey\":\"NST7786310\",\"Order\":10,\"MediaObjectID\":\"10\",\"ImageWidth\":1170,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1170x2080\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7786310/2c51559b-021b-4286-90b6-6ea35b88f5cc.jpeg\",\"MediaModificationTimestamp\":\"2025-08-11T15:22:40.758Z\",\"MediaKey\":\"689a0ac06c8f653b4dd7dc80\"},{\"ResourceRecordKey\":\"NST7786310\",\"Order\":11,\"MediaObjectID\":\"11\",\"ImageWidth\":1170,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1170x2080\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7786310/c34dd6ba-7824-4b4d-84a1-346b1d6c281b.jpeg\",\"MediaModificationTimestamp\":\"2025-08-11T15:22:40.738Z\",\"MediaKey\":\"689a0ac06c8f653b4dd7dc81\"},{\"ResourceRecordKey\":\"NST7786310\",\"Order\":12,\"MediaObjectID\":\"12\",\"ImageWidth\":1170,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1170x2080\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7786310/9b56f800-94c7-4ac1-9510-fa011019c07c.jpeg\",\"MediaModificationTimestamp\":\"2025-08-11T15:22:40.744Z\",\"MediaKey\":\"689a0ac06c8f653b4dd7dc82\"},{\"ResourceRecordKey\":\"NST7786310\",\"Order\":13,\"MediaObjectID\":\"13\",\"ImageWidth\":2080,\"ImageHeight\":1170,\"ImageSizeDescription\":\"2080x1170\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7786310/97dd3e11-435b-47f2-aa91-e72d3b451fb2.jpeg\",\"MediaModificationTimestamp\":\"2025-08-11T15:22:40.785Z\",\"MediaKey\":\"689a0ac06c8f653b4dd7dc83\"},{\"ResourceRecordKey\":\"NST7786310\",\"Order\":14,\"MediaObjectID\":\"14\",\"ImageWidth\":2080,\"ImageHeight\":1170,\"ImageSizeDescription\":\"2080x1170\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7786310/74d97b13-23ec-4c38-a7bf-fbe97dcec111.jpeg\",\"MediaModificationTimestamp\":\"2025-08-11T15:22:40.819Z\",\"MediaKey\":\"689a0ac06c8f653b4dd7dc84\"},{\"ResourceRecordKey\":\"NST7786310\",\"Order\":15,\"MediaObjectID\":\"15\",\"ImageWidth\":2080,\"ImageHeight\":1170,\"ImageSizeDescription\":\"2080x1170\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7786310/661a6280-e891-4a37-9b85-48fbe19e4dd6.jpeg\",\"MediaModificationTimestamp\":\"2025-08-11T15:22:40.762Z\",\"MediaKey\":\"689a0ac06c8f653b4dd7dc85\"},{\"ResourceRecordKey\":\"NST7786310\",\"Order\":16,\"MediaObjectID\":\"16\",\"ImageWidth\":1170,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1170x2080\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7786310/77f17ab9-7069-4380-914e-4957cb6cda92.jpeg\",\"MediaModificationTimestamp\":\"2025-08-11T15:22:40.727Z\",\"MediaKey\":\"689a0ac06c8f653b4dd7dc86\"},{\"ResourceRecordKey\":\"NST7786310\",\"Order\":17,\"MediaObjectID\":\"17\",\"ImageWidth\":2080,\"ImageHeight\":1170,\"ImageSizeDescription\":\"2080x1170\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7786310/bfee731a-4b4a-4a5f-8906-c0b1e7d110ac.jpeg\",\"MediaModificationTimestamp\":\"2025-08-11T15:22:40.731Z\",\"MediaKey\":\"689a0ac06c8f653b4dd7dc87\"},{\"ResourceRecordKey\":\"NST7786310\",\"Order\":18,\"MediaObjectID\":\"18\",\"ImageWidth\":1170,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1170x2080\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7786310/e137f41d-e299-481e-9083-23212c9cabdb.jpeg\",\"MediaModificationTimestamp\":\"2025-08-11T15:22:40.686Z\",\"MediaKey\":\"689a0ac06c8f653b4dd7dc88\"},{\"ResourceRecordKey\":\"NST7786310\",\"Order\":19,\"MediaObjectID\":\"19\",\"ImageWidth\":1170,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1170x2080\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7786310/93eb9936-106f-4839-9202-72f20338d3c5.jpeg\",\"MediaModificationTimestamp\":\"2025-08-11T15:22:40.713Z\",\"MediaKey\":\"689a0ac06c8f653b4dd7dc89\"},{\"ResourceRecordKey\":\"NST7786310\",\"Order\":20,\"MediaObjectID\":\"20\",\"ImageWidth\":2080,\"ImageHeight\":1170,\"ImageSizeDescription\":\"2080x1170\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7786310/e06e6773-51eb-4c4b-a492-87e39737c40b.jpeg\",\"MediaModificationTimestamp\":\"2025-08-11T15:22:40.731Z\",\"MediaKey\":\"689a0ac06c8f653b4dd7dc8a\"},{\"ResourceRecordKey\":\"NST7786310\",\"Order\":21,\"MediaObjectID\":\"21\",\"ImageWidth\":2080,\"ImageHeight\":1170,\"ImageSizeDescription\":\"2080x1170\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7786310/cb03e5d4-ad79-4828-a4cd-b3b91eac8f00.jpeg\",\"MediaModificationTimestamp\":\"2025-08-11T15:22:40.754Z\",\"MediaKey\":\"689a0ac06c8f653b4dd7dc8b\"},{\"ResourceRecordKey\":\"NST7786310\",\"Order\":22,\"MediaObjectID\":\"22\",\"ImageWidth\":1170,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1170x2080\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7786310/d25ae311-9f3e-4eb3-9af2-eb96afb842a6.jpeg\",\"MediaModificationTimestamp\":\"2025-08-11T15:22:40.828Z\",\"MediaKey\":\"689a0ac06c8f653b4dd7dc8c\"},{\"ResourceRecordKey\":\"NST7786310\",\"Order\":23,\"MediaObjectID\":\"23\",\"ImageWidth\":2080,\"ImageHeight\":1170,\"ImageSizeDescription\":\"2080x1170\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7786310/d46d5c09-0aff-46d3-992b-92253996555e.jpeg\",\"MediaModificationTimestamp\":\"2025-08-11T15:22:40.682Z\",\"MediaKey\":\"689a0ac06c8f653b4dd7dc8d\"},{\"ResourceRecordKey\":\"NST7786310\",\"Order\":24,\"MediaObjectID\":\"24\",\"ImageWidth\":1170,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1170x2080\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7786310/a396a76c-5cca-4781-b5bf-8fd96decdad1.jpeg\",\"MediaModificationTimestamp\":\"2025-08-11T15:22:40.74Z\",\"MediaKey\":\"689a0ac06c8f653b4dd7dc8e\"}]","PhotosChangeTimestamp":"2025-08-11T15:23:04.981Z","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24","CustomVTourURL":""}