{"Id":1423090,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST6806498","MLSAGENTID":"NST496500378","MLSOFFICEID":"NST25783","ADDRESS":"2574 County Road H2","ACRES":0.03,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Crawl Space","BATHSTOTAL":3.0,"BEDROOMS":3,"CITY":"Mounds View","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Brick/Stone,Vinyl Siding","FORECLOSURE":"No","LASTPRICE":345000.0,"LASTPRICEDATE":"2025-10-19T22:45:03.573","LATITUDE":45.10043043,"LENDEROWNED":"No","LISTDATE":"2025-10-19T05:00:00","LISTPRICE":345000.0,"LIVINGAREA":2064.0,"LONGITUDE":-93.2105857,"MODIFICATIONTIMESTAMP":"2025-10-20T10:03:05.185","OFFICE_OFFICENAME":"Renters Warehouse","PHOTOCOUNT":15,"POSTALCODE":"55112","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Excellent end-unit townhome with beautiful open living room with fireplace, kitchen with stainless appliances, granite counter tops, beautiful cabinetry, hardwood floors, walkout to patio, 3 bedrooms on one level, 3 baths. Award winning Mounds View school district! The primary bedroom en suite has a vanity with double sinks, a separate shower and soaking tub and a large walk-in closet. Nice patio in the back yard, and an insulated garage with an epoxy finished floor. See this stunning home today!","ROADBETWEENWATERFRONTANDHOMEYN":false,"SCHOOLDISTRICTNUMBER":"621-Mounds View","SCHOOLDISTRICTPHONE":"651-621-6001","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2025-10-19T22:45:03.573","LASTSTATUS":"Active","STREETNAME":"County Road H2","STREETNUMBER":"2574","STYLE":"Townhouse Side x Side","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":2017,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2025-10-20T00:37:03.451","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"Front View-14892750.jpg\"},{\"Order\":2,\"Remarks\":\"Rear View-14892794.jpg\"},{\"Order\":3,\"Remarks\":\"Kitchen-14892759.jpg\"},{\"Order\":4,\"Remarks\":\"Kitchen-14892761.jpg\"},{\"Order\":5,\"Remarks\":\"Kitchen-14892760.jpg\"},{\"Order\":6,\"Remarks\":\"Main Bedroom-14892763.jpg\"},{\"Order\":7,\"Remarks\":\"Main Bedroom-14892764.jpg\"},{\"Order\":8,\"Remarks\":\"Bathroom-14892756.jpg\"},{\"Order\":9,\"Remarks\":\"Main Bathroom-14892765.jpg\"},{\"Order\":10,\"Remarks\":\"Bedroom-14892754.jpg\"},{\"Order\":11,\"Remarks\":\"Bedroom-14892755.jpg\"},{\"Order\":12,\"Remarks\":\"Loft/ family rrom\"},{\"Order\":15,\"Remarks\":\"Bathroom-14892751.jpg\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15","SOURCE":"MG_NST"}
{"ListingKey":"NST7817695","LotSizeArea":"0.03","NST_AgeOfProperty":"8","NST_AgentOwner":"No","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"True","NST_AmenitiesUnit":"Primary Bedroom Walk-In Closet,Patio","Appliances":"Dishwasher,Dryer,Microwave,Range,Refrigerator,Washer","NST_AssessmentPending":"No","AssociationFeeIncludes":"Hazard Insurance,Maintenance Grounds,Trash","AssociationFeeFrequency":"Monthly","AssociationYN":"True","AssociationFee":"349","AssociationName":"Rowcal","AssociationPhone":"651-362-1750","PropertyAttachedYN":"True","Basement":"Crawl Space","BasementYN":"True","NST_BathDesc":"Double Sink,Full Primary,Main Floor 1/2 Bath,Separate Tub & Shower,Upper Level Full Bath","BathroomsOneQuarter":"0","BathroomsFull":"2","BathroomsHalf":"1","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"3","BedroomsTotal":"3","City":"Mounds View","PropertyType":"Residential","NewConstructionYN":"False","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Ramsey","NST_DPResource":"Y","DaysOnMarket":"1","CumulativeDaysOnMarket":"1","NST_DiningRoomDescription":"Informal Dining Room,Kitchen/Dining Room,Living/Dining Room","Directions":"I-694 to US 10W towards Anoka. Merge onto Highway 10. Turn slight left onto County Road H2. Past Long Lake Rd, Destination on the left.","InternetAddressDisplayYN":"True","InternetEntireListingDisplayYN":"True","ConstructionMaterials":"Brick/Stone,Vinyl Siding","FireplaceFeatures":"Living Room","FireplacesTotal":"1","NST_ForeclosureStatus":"No","FoundationArea":"1272","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","ParkingFeatures":"Attached Garage,Asphalt,Insulated Garage","NST_GarageSquareFeet":"418","AccessibilityFeatures":"None","Heating":"Forced Air","OriginalEntryTimestamp":"2025-10-19T22:43:17Z","LandLeaseYN":"False","NST_LastUpdateDate":"2025-10-20","Latitude":"45.1004304347","NST_LenderOwned":"No","ListAgentKey":"NST48867","ListAgentMlsId":"NST496500378","ListingContractDate":"2025-10-19T05:00:00Z","ListOfficeKey":"NST25783","ListOfficeName":"Renters Warehouse","ListOfficeMlsId":"NST25783","ListPrice":"345000","LivingArea":"2064","Longitude":"-93.2105857032","LotSizeDimensions":"Irregular","LotSizeSquareFeet":"1306.8","LotSizeUnits":"Acres","ListingId":"NST6806498","SourceSystemName":"RMLS","NST_ManufacturedHome":"No","MapCoordinateSource":"King's Street Atlas","AdditionalParcelsYN":"False","NST_OfficeBoard":"MAAR","ParcelNumber":"073023410190","GarageSpaces":"2","NST_PatioPorchType":"Patio","PhotosCount":"15","PostalCity":"Mounds View","PostalCode":"55112","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PublicRemarks":"Excellent end-unit townhome with beautiful open living room with fireplace, kitchen with stainless appliances, granite counter tops, beautiful cabinetry, hardwood floors, walkout to patio, 3 bedrooms on one level, 3 baths. Award winning Mounds View school district! The primary bedroom en suite has a vanity with double sinks, a separate shower and soaking tub and a large walk-in closet. Nice patio in the back yard, and an insulated garage with an epoxy finished floor. See this stunning home today!","PublicSurveyRange":"23","PublicSurveySection":"07","PublicSurveyTownship":"30","NST_RentalLicenseType":"Standard","NST_RentalLicenseYN":"Yes","NST_Restrictions":"Other","RoomType":"Living Room,Dining Room,Kitchen,Bedroom 1,Bedroom 2,Bedroom 3,Laundry,Family Room","NST_AboveGradeSqFtTotal":"2064.0000","NST_BelowGradeSqFtTotal":"0.0000","NST_MainLevelFinishedArea":"984.0000","BuildingAreaTotal":"2064","HighSchoolDistrict":"Mounds View","NST_SchoolDistrictNumber":"621","NST_SchoolDistrictPhone":"651-621-6001","Sewer":"City Sewer/Connected","NST_SpecialSearch":"2nd Floor Laundry,3 BR on One Level","AboveGradeFinishedArea":"2064","BelowGradeFinishedArea":"0","StateOrProvince":"MN","StandardStatus":"Active","Levels":"Split Entry (Bi-Level)","StreetName":"County Road H2","StreetNumber":"2574","StreetNumberNumeric":"2574","PropertySubType":"Townhouse Side x Side","SubdivisionName":"Red Oak Estates 3","NST_TaxWithAssessments":"5322.0000","TaxYear":"2025","TaxAnnualAmount":"5322","WaterSource":"City Water/Connected","YearBuilt":"2017","ZoningDescription":"Residential-Single Family","ModificationTimestamp":"2025-10-20T10:03:05.185Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7817695\",\"Order\":1,\"MediaObjectID\":\"1\",\"LongDescription\":\"Front View-14892750.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7817695/811b634d-ccec-4131-955e-dd98af690b56.jpeg\",\"MediaModificationTimestamp\":\"2025-10-20T00:35:12.77Z\",\"MediaKey\":\"68f583c02172cd778db3f6b9\"},{\"ResourceRecordKey\":\"NST7817695\",\"Order\":2,\"MediaObjectID\":\"2\",\"LongDescription\":\"Rear View-14892794.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7817695/4827a212-007c-47b8-8e17-2369027496ac.jpeg\",\"MediaModificationTimestamp\":\"2025-10-20T00:35:12.628Z\",\"MediaKey\":\"68f583c02172cd778db3f6ba\"},{\"ResourceRecordKey\":\"NST7817695\",\"Order\":3,\"MediaObjectID\":\"3\",\"LongDescription\":\"Kitchen-14892759.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7817695/431408fb-91e4-4d96-add7-14079c471d0d.jpeg\",\"MediaModificationTimestamp\":\"2025-10-20T00:35:12.607Z\",\"MediaKey\":\"68f583c02172cd778db3f6bb\"},{\"ResourceRecordKey\":\"NST7817695\",\"Order\":4,\"MediaObjectID\":\"4\",\"LongDescription\":\"Kitchen-14892761.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7817695/1e6a15a0-2f32-4a9a-9e34-cb2d5f86e679.jpeg\",\"MediaModificationTimestamp\":\"2025-10-20T00:35:12.627Z\",\"MediaKey\":\"68f583c02172cd778db3f6bc\"},{\"ResourceRecordKey\":\"NST7817695\",\"Order\":5,\"MediaObjectID\":\"5\",\"LongDescription\":\"Kitchen-14892760.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7817695/7f92ba42-3223-407b-b252-8cf6781833b5.jpeg\",\"MediaModificationTimestamp\":\"2025-10-20T00:35:12.621Z\",\"MediaKey\":\"68f583c02172cd778db3f6bd\"},{\"ResourceRecordKey\":\"NST7817695\",\"Order\":6,\"MediaObjectID\":\"6\",\"LongDescription\":\"Main Bedroom-14892763.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7817695/09f13ad9-21fe-4f22-a0cd-36b0e1a5bfa8.jpeg\",\"MediaModificationTimestamp\":\"2025-10-20T00:35:12.617Z\",\"MediaKey\":\"68f583c02172cd778db3f6be\"},{\"ResourceRecordKey\":\"NST7817695\",\"Order\":7,\"MediaObjectID\":\"7\",\"LongDescription\":\"Main Bedroom-14892764.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7817695/708f419a-533a-4e5e-b7f3-ff791932b6d6.jpeg\",\"MediaModificationTimestamp\":\"2025-10-20T00:35:12.619Z\",\"MediaKey\":\"68f583c02172cd778db3f6c7\"},{\"ResourceRecordKey\":\"NST7817695\",\"Order\":8,\"MediaObjectID\":\"8\",\"LongDescription\":\"Bathroom-14892756.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7817695/1697075a-42d4-4fe5-903d-41333ae5cb1b.jpeg\",\"MediaModificationTimestamp\":\"2025-10-20T00:35:12.591Z\",\"MediaKey\":\"68f583c02172cd778db3f6c0\"},{\"ResourceRecordKey\":\"NST7817695\",\"Order\":9,\"MediaObjectID\":\"9\",\"LongDescription\":\"Main Bathroom-14892765.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7817695/2cab006b-d12f-4afa-8ab4-376bee23308f.jpeg\",\"MediaModificationTimestamp\":\"2025-10-20T00:35:12.596Z\",\"MediaKey\":\"68f583c02172cd778db3f6c1\"},{\"ResourceRecordKey\":\"NST7817695\",\"Order\":10,\"MediaObjectID\":\"10\",\"LongDescription\":\"Bedroom-14892754.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7817695/da043769-09b7-4fe7-b01c-081d738ca2ad.jpeg\",\"MediaModificationTimestamp\":\"2025-10-20T00:35:12.615Z\",\"MediaKey\":\"68f583c02172cd778db3f6c2\"},{\"ResourceRecordKey\":\"NST7817695\",\"Order\":11,\"MediaObjectID\":\"11\",\"LongDescription\":\"Bedroom-14892755.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7817695/4aacb031-e8af-4c6b-a3be-94e2d837f192.jpeg\",\"MediaModificationTimestamp\":\"2025-10-20T00:35:12.645Z\",\"MediaKey\":\"68f583c02172cd778db3f6c3\"},{\"ResourceRecordKey\":\"NST7817695\",\"Order\":12,\"MediaObjectID\":\"12\",\"LongDescription\":\"Loft/ family rrom\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7817695/c42b99f3-ab8a-4021-ac7c-44c9c44b23d2.jpeg\",\"MediaModificationTimestamp\":\"2025-10-20T00:35:12.615Z\",\"MediaKey\":\"68f583c02172cd778db3f6c4\"},{\"ResourceRecordKey\":\"NST7817695\",\"Order\":13,\"MediaObjectID\":\"13\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7817695/d0d474a1-aa36-438a-ac1c-177dea7ca593.jpeg\",\"MediaModificationTimestamp\":\"2025-10-20T00:35:12.601Z\",\"MediaKey\":\"68f583c02172cd778db3f6c5\"},{\"ResourceRecordKey\":\"NST7817695\",\"Order\":14,\"MediaObjectID\":\"14\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7817695/4a27f112-f5c8-489c-ad79-34cb7b65e062.jpeg\",\"MediaModificationTimestamp\":\"2025-10-20T00:35:12.606Z\",\"MediaKey\":\"68f583c02172cd778db3f6c6\"},{\"ResourceRecordKey\":\"NST7817695\",\"Order\":15,\"MediaObjectID\":\"15\",\"LongDescription\":\"Bathroom-14892751.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7817695/ea8088a7-44fd-472b-85fb-865fa000dcb2.jpeg\",\"MediaModificationTimestamp\":\"2025-10-20T00:35:12.634Z\",\"MediaKey\":\"68f583c02172cd778db3f6bf\"}]","PhotosChangeTimestamp":"2025-10-20T00:37:03.451Z","Rooms":"[{\"RoomKey\":\"NST115714320\",\"RoomType\":\"Living Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"11x25\",\"NST_RoomSortOrder\":\"1\"},{\"RoomKey\":\"NST115714321\",\"RoomType\":\"Dining Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"12x14\",\"NST_RoomSortOrder\":\"2\"},{\"RoomKey\":\"NST115714322\",\"RoomType\":\"Kitchen\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"14x13\",\"NST_RoomSortOrder\":\"3\"},{\"RoomKey\":\"NST115714323\",\"RoomType\":\"Bedroom 1\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"11x20\",\"NST_RoomSortOrder\":\"4\"},{\"RoomKey\":\"NST115714324\",\"RoomType\":\"Bedroom 2\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"12x14\",\"NST_RoomSortOrder\":\"5\"},{\"RoomKey\":\"NST115714325\",\"RoomType\":\"Bedroom 3\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"12x14\",\"NST_RoomSortOrder\":\"6\"},{\"RoomKey\":\"NST115714326\",\"RoomType\":\"Laundry\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"9x9\",\"NST_RoomSortOrder\":\"7\"},{\"RoomKey\":\"NST115714362\",\"RoomType\":\"Family Room\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"20x16\",\"NST_RoomSortOrder\":\"8\"}]","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"Front View-14892750.jpg\"},{\"Order\":2,\"Remarks\":\"Rear View-14892794.jpg\"},{\"Order\":3,\"Remarks\":\"Kitchen-14892759.jpg\"},{\"Order\":4,\"Remarks\":\"Kitchen-14892761.jpg\"},{\"Order\":5,\"Remarks\":\"Kitchen-14892760.jpg\"},{\"Order\":6,\"Remarks\":\"Main Bedroom-14892763.jpg\"},{\"Order\":7,\"Remarks\":\"Main Bedroom-14892764.jpg\"},{\"Order\":8,\"Remarks\":\"Bathroom-14892756.jpg\"},{\"Order\":9,\"Remarks\":\"Main Bathroom-14892765.jpg\"},{\"Order\":10,\"Remarks\":\"Bedroom-14892754.jpg\"},{\"Order\":11,\"Remarks\":\"Bedroom-14892755.jpg\"},{\"Order\":12,\"Remarks\":\"Loft/ family rrom\"},{\"Order\":15,\"Remarks\":\"Bathroom-14892751.jpg\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15","CustomVTourURL":""}