{"Id":1384349,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST6757456","MLSAGENTID":"NST506001240","MLSOFFICEID":"NST8232","ADDRESS":"4185 Centerville Road","ACRES":0.05,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Daylight/Lookout Windows,Drain Tiled,Egress Window(s),Finished,Full,Concrete,Walkout","BATHSTOTAL":3.0,"BEDROOMS":2,"CITY":"Vadnais Heights","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Brick/Stone,Metal Siding,Vinyl Siding","FORECLOSURE":"No","LASTPRICE":474000.0,"LASTPRICEDATE":"2025-10-06T16:13:03.49","LATITUDE":45.068076,"LENDEROWNED":"No","LISTDATE":"2025-07-18T05:00:00","LISTPRICE":472900.0,"LIVINGAREA":2400.0,"LONGITUDE":-93.056703,"LOTDESCRIPTION":"Public Transit (w/in 6 blks),Many Trees","MODIFICATIONTIMESTAMP":"2025-10-06T16:13:03.49","OFFICE_OFFICENAME":"Coldwell Banker Realty","PHOTOCOUNT":9,"POSTALCODE":"55127","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"This end unit townhome overlooks protected wetlands and wildlife area. High quality finishes throughout - originally was the model home. 18 upgrades since 2017. It has two sets of French Doors and beautiful lighting fixtures. Main level features a gorgeous sun room with the serenity you are looking for. The large primary suite has wonderful finishes. The Lower level has a finished walkout to nature with abundant space.","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Age Over 8 Years,Asphalt","SCHOOLDISTRICTNUMBER":"624-White Bear Lake","SCHOOLDISTRICTPHONE":"651-407-7500","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2025-07-18T15:18:03.743","LASTSTATUS":"Active","STREETNAME":"Centerville","STREETNUMBER":"4185","STREETSUFFIX":"Road","STYLE":"Townhouse Side x Side","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":2006,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2025-07-28T00:05:03.537","PHOTOREMARKS":"[{\"Order\":2,\"Remarks\":\"Kitchen\"},{\"Order\":3,\"Remarks\":\"Living room with fireplace\"},{\"Order\":4,\"Remarks\":\"Living room\"},{\"Order\":5,\"Remarks\":\"Sun porch with deck\"},{\"Order\":6,\"Remarks\":\"Beautiful finishes\"},{\"Order\":7,\"Remarks\":\"Master suite\"},{\"Order\":8,\"Remarks\":\"Lower level family room\"},{\"Order\":9,\"Remarks\":\"Office or extra room\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9","SOURCE":"MG_NST"}
{"ListingKey":"NST7775164","LotSizeArea":"0.05","NST_AgeOfProperty":"19","NST_AgentOwner":"No","InternetAutomatedValuationDisplayYN":"False","InternetConsumerCommentYN":"False","AssociationAmenities":"Fire Sprinkler System,In-Ground Sprinkler System","NST_AmenitiesUnit":"Ceiling Fan(s),Deck,French Doors,Hardwood Floors,Kitchen Center Island,Kitchen Window,Main Floor Primary Bedroom,Natural Woodwork,Patio,Paneled Doors,Porch,Security System,Skylight,In-Ground Sprinkler,Sun Room,Tile Floors,Washer/Dryer Hookup,Wet Bar","Appliances":"Air-To-Air Exchanger,Central Vacuum,Dishwasher,Disposal,Dryer,ENERGY STAR Qualified Appliances,Exhaust Fan,Humidifier,Gas Water Heater,Water Filtration System,Water Osmosis System,Microwave,Range,Refrigerator,Stainless Steel Appliances,Washer","NST_AssessmentPending":"No","AssociationFeeIncludes":"Maintenance Structure,Hazard Insurance,Lawn Care,Maintenance Grounds,Trash,Snow Removal","AssociationFeeFrequency":"Monthly","AssociationYN":"True","AssociationFee":"450","AssociationName":"Association Experts","AssociationPhone":"763-515-2360","PropertyAttachedYN":"True","NST_AttributionContact":"612-865-8064","NST_AttributionName":"Marsha Froehle, GRI, CPS, SHS, RMS","Basement":"Daylight/Lookout Windows,Drain Tiled,Egress Window(s),Finished,Full,Concrete,Walkout","BasementYN":"True","NST_BathDesc":"Full Primary,Full Basement,Main Floor Full Bath,Separate Tub & Shower,Jetted Tub,Walk-In Shower Stall","BathroomsOneQuarter":"0","BathroomsFull":"2","BathroomsHalf":"1","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"3","BedroomsTotal":"2","City":"Vadnais Heights","PropertyType":"Residential","NewConstructionYN":"False","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Ramsey","NST_DPResource":"Y","DaysOnMarket":"80","CumulativeDaysOnMarket":"198","NST_DiningRoomDescription":"Breakfast Bar,Kitchen/Dining Room","Directions":"35 E to Hwy 96, West to Centerville Road, South to home.","InternetAddressDisplayYN":"True","InternetEntireListingDisplayYN":"True","Electric":"Circuit Breakers","ConstructionMaterials":"Brick/Stone,Metal Siding,Vinyl Siding","Fencing":"None","FireplaceFeatures":"Gas,Living Room","FireplacesTotal":"1","NST_ForeclosureStatus":"No","FoundationArea":"1400","NST_FractionalOwnershipYN":"No","RoadFrontageType":"City Street,Curbs,Paved Streets,Sidewalks","NST_Fuel":"Natural Gas","ParkingFeatures":"Attached Garage,Concrete,Garage Door Opener","NST_GarageSquareFeet":"440","AccessibilityFeatures":"Grab Bars In Bathroom","Heating":"Forced Air","OriginalEntryTimestamp":"2025-07-18T15:13:51Z","LandLeaseYN":"False","NST_LastUpdateDate":"2025-10-06","Latitude":"45.068076","NST_LenderOwned":"No","ListAgentKey":"NST47179","ListAgentMlsId":"NST506001240","ListingContractDate":"2025-07-18T05:00:00Z","ListOfficeKey":"NST16732","ListOfficeName":"Coldwell Banker Realty","ListOfficeMlsId":"NST8232","ListPrice":"472900","LivingArea":"2400","NST_LockBoxSource":"SPAAR","LockBoxType":"Supra","Longitude":"-93.056703","LotFeatures":"Public Transit (w/in 6 blks),Many Trees","LotSizeDimensions":"commopn","LotSizeSquareFeet":"2265.12","LotSizeUnits":"Acres","ListingId":"NST6757456","SourceSystemName":"RMLS","NST_ManufacturedHome":"No","MapCoordinateSource":"King's Street Atlas","AdditionalParcelsYN":"False","NST_OfficeBoard":"SPAAR","ParcelNumber":"213022340032","GarageSpaces":"2","NST_PatioPorchType":"Deck,Front Porch","PhotosCount":"9","PoolFeatures":"None","PostalCity":"Vadnais Heights","PostalCode":"55127","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PublicRemarks":"This end unit townhome overlooks protected wetlands and wildlife area. High quality finishes throughout - originally was the model home. 18 upgrades since 2017. It has two sets of French Doors and beautiful lighting fixtures. Main level features a gorgeous sun room with the serenity you are looking for. The large primary suite has wonderful finishes. The Lower level has a finished walkout to nature with abundant space.","PublicSurveyRange":"22","PublicSurveySection":"21","PublicSurveyTownship":"30","NST_RentalLicenseYN":"No","NST_Restrictions":"Rentals not Permitted,Pets - Cats Allowed,Pets - Dogs Allowed,Pets - Number Limit,Pets - Weight/Height Limit","RoadResponsibility":"Association Maintained Road","Roof":"Age Over 8 Years,Asphalt","RoomType":"Living Room,Kitchen,Family Room,Office,Sun Room,Bedroom 1,Bedroom 2,Deck","NST_AboveGradeSqFtTotal":"1400.0000","NST_BelowGradeSqFtTotal":"1400.0000","NST_MainLevelFinishedArea":"1400.0000","BuildingAreaTotal":"2800","HighSchoolDistrict":"White Bear Lake","NST_SchoolDistrictNumber":"624","NST_SchoolDistrictPhone":"651-407-7500","Sewer":"City Sewer/Connected","NST_SpecialSearch":"All Living Facilities on One Level,Main Floor Primary,Main Floor Bedroom,Main Floor Laundry","AboveGradeFinishedArea":"1400","BelowGradeFinishedArea":"1000","StateOrProvince":"MN","StandardStatus":"Active","Levels":"One","StreetName":"Centerville","StreetNumber":"4185","StreetNumberNumeric":"4185","StreetSuffix":"Road","PropertySubType":"Townhouse Side x Side","SubdivisionName":"Cic 512 Wild Flower Meadows","NST_TaxWithAssessments":"6878.0000","TaxYear":"2025","TaxAnnualAmount":"6878","WaterSource":"City Water/Connected","YearBuilt":"2006","ZoningDescription":"Residential-Single Family","ModificationTimestamp":"2025-10-06T16:13:03.49Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7775164\",\"Order\":1,\"MediaObjectID\":\"1\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7775164/1ce5b4a0-3d17-40d8-8285-0aca445d6328.jpeg\",\"MediaModificationTimestamp\":\"2025-07-28T00:04:10.501Z\",\"MediaKey\":\"6886be7a04a76301ff07bc36\"},{\"ResourceRecordKey\":\"NST7775164\",\"Order\":2,\"MediaObjectID\":\"2\",\"LongDescription\":\"Kitchen\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7775164/2367c640-971c-4baa-a496-9a9572194de0.jpeg\",\"MediaModificationTimestamp\":\"2025-07-28T00:04:10.518Z\",\"MediaKey\":\"6886be7a04a76301ff07bc37\"},{\"ResourceRecordKey\":\"NST7775164\",\"Order\":3,\"MediaObjectID\":\"3\",\"LongDescription\":\"Living room with fireplace\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7775164/fbc7ea55-b3a4-498b-8464-60673ca0819d.jpeg\",\"MediaModificationTimestamp\":\"2025-07-28T00:04:10.443Z\",\"MediaKey\":\"6886be7a04a76301ff07bc38\"},{\"ResourceRecordKey\":\"NST7775164\",\"Order\":4,\"MediaObjectID\":\"4\",\"LongDescription\":\"Living room\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7775164/83f754ec-df73-43d1-bbd8-fb6fef6aa6ea.jpeg\",\"MediaModificationTimestamp\":\"2025-07-28T00:04:10.439Z\",\"MediaKey\":\"6886be7a04a76301ff07bc39\"},{\"ResourceRecordKey\":\"NST7775164\",\"Order\":5,\"MediaObjectID\":\"5\",\"LongDescription\":\"Sun porch with deck\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7775164/c664542b-2a98-4ef2-822a-0b477402a940.jpeg\",\"MediaModificationTimestamp\":\"2025-07-28T00:04:10.498Z\",\"MediaKey\":\"6886be7a04a76301ff07bc3a\"},{\"ResourceRecordKey\":\"NST7775164\",\"Order\":6,\"MediaObjectID\":\"6\",\"LongDescription\":\"Beautiful finishes\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7775164/6f543e63-369c-4913-8b2c-27f9727984b5.jpeg\",\"MediaModificationTimestamp\":\"2025-07-28T00:04:10.569Z\",\"MediaKey\":\"6886be7a04a76301ff07bc3b\"},{\"ResourceRecordKey\":\"NST7775164\",\"Order\":7,\"MediaObjectID\":\"7\",\"LongDescription\":\"Master suite\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7775164/d2d16e77-8c36-4da5-8357-a2aedaa28d87.jpeg\",\"MediaModificationTimestamp\":\"2025-07-28T00:04:10.464Z\",\"MediaKey\":\"6886be7a04a76301ff07bc3c\"},{\"ResourceRecordKey\":\"NST7775164\",\"Order\":8,\"MediaObjectID\":\"8\",\"LongDescription\":\"Lower level family room\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7775164/1b072282-7911-4469-8da4-6fc50038720b.jpeg\",\"MediaModificationTimestamp\":\"2025-07-28T00:04:10.468Z\",\"MediaKey\":\"6886be7a04a76301ff07bc3d\"},{\"ResourceRecordKey\":\"NST7775164\",\"Order\":9,\"MediaObjectID\":\"9\",\"LongDescription\":\"Office or extra room\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7775164/48a7f861-f87d-462d-acfb-eee7a1c4dfc2.jpeg\",\"MediaModificationTimestamp\":\"2025-07-28T00:04:10.564Z\",\"MediaKey\":\"6886be7a04a76301ff07bc3e\"}]","PhotosChangeTimestamp":"2025-07-28T00:05:03.537Z","Rooms":"[{\"RoomKey\":\"NST115431471\",\"RoomType\":\"Living Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"16x16\",\"NST_RoomSortOrder\":\"1\"},{\"RoomKey\":\"NST115431472\",\"RoomType\":\"Kitchen\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"13x10\",\"NST_RoomSortOrder\":\"2\"},{\"RoomKey\":\"NST115431473\",\"RoomType\":\"Family Room\",\"RoomLevel\":\"Lower\",\"RoomDimensions\":\"21x20\",\"NST_RoomSortOrder\":\"3\"},{\"RoomKey\":\"NST115431474\",\"RoomType\":\"Office\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"11x9\",\"NST_RoomSortOrder\":\"4\"},{\"RoomKey\":\"NST115431475\",\"RoomType\":\"Sun Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"10x9\",\"NST_RoomSortOrder\":\"5\"},{\"RoomKey\":\"NST115431476\",\"RoomType\":\"Bedroom 1\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"15x13\",\"NST_RoomSortOrder\":\"6\"},{\"RoomKey\":\"NST115431477\",\"RoomType\":\"Bedroom 2\",\"RoomLevel\":\"Lower\",\"RoomDimensions\":\"14x11\",\"NST_RoomSortOrder\":\"7\"},{\"RoomKey\":\"NST115431478\",\"RoomType\":\"Deck\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"10x9\",\"NST_RoomSortOrder\":\"8\"}]","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":2,\"Remarks\":\"Kitchen\"},{\"Order\":3,\"Remarks\":\"Living room with fireplace\"},{\"Order\":4,\"Remarks\":\"Living room\"},{\"Order\":5,\"Remarks\":\"Sun porch with deck\"},{\"Order\":6,\"Remarks\":\"Beautiful finishes\"},{\"Order\":7,\"Remarks\":\"Master suite\"},{\"Order\":8,\"Remarks\":\"Lower level family room\"},{\"Order\":9,\"Remarks\":\"Office or extra room\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9","CustomVTourURL":""}