$LABEL$
$CONTENT$
$LABEL$
$CONTENT$
Renters Warehouse 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. Chad Schwendeman is not a multiple Listing Service (MLS), nor does it offer MLS access. This website is a service of Chad Schwendeman, a broker Participant of the Regional Multiple Listing Service of Minnesota, Inc.
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. Chad Schwendeman is not a multiple Listing Service (MLS), nor does it offer MLS access. This website is a service of Chad Schwendeman, a broker Participant of the Regional Multiple Listing Service of Minnesota, Inc.
Nearby Listings in 10 Miles
{"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":""}