{"Id":527889,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST7035283","MLSAGENTID":"NST502048052","MLSOFFICEID":"NST26401","ADDRESS":"235 Mainzer Street","ACRES":0.113,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Drain Tiled,Egress Window(s),Finished","BATHSTOTAL":2.0,"BEDROOMS":4.0,"CITY":"West Saint Paul","CONTINGENCY":"None","COUNTY":"Dakota","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"FORECLOSURE":"No","LASTPRICE":330000.0,"LASTPRICEDATE":"2026-03-12T14:50:06.867","LATITUDE":44.917119,"LENDEROWNED":"No","LISTDATE":"2026-03-12T05:00:00","LISTPRICE":330000.0,"LIVINGAREA":1233.0,"LONGITUDE":-93.075153,"MODIFICATIONTIMESTAMP":"2026-03-13T10:05:16.985","OFFICE_OFFICENAME":"Lakes Sotheby's International Realty","PHOTOCOUNT":19,"POSTALCODE":"55118","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Thoughtfully updated four-bedroom, two-bath home that is truly move-in ready. The bright, flowing open-concept layout offers great space for everyday living. Enjoy the newly updated kitchen with stone countertops, newly tiled bathrooms, and a basement living area that provide the home with both style and comfort. New paint and new flooring throughout the house create the perfect blank slate to make it your own. Brand new central air unit, newer mechanicals, a drain tile system installed 10 years ago and a newer roof mean there’s nothing left to do but move in.","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Age 8 Years or Less,Architectural Shingle","SCHOOLDISTRICTNUMBER":"951-West St. Paul-Mendota Hts.-Eagan","SCHOOLDISTRICTPHONE":"6514037002","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2026-03-12T14:50:06.867","LASTSTATUS":"Active","STREETNAME":"Mainzer","STREETNUMBER":"235","STREETSUFFIX":"Street","STYLE":"Single Family Residence","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1946,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2026-03-12T15:26:06.232","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19","SOURCE":"MG_NST"}
{"ListingKey":"NST7867172","NST_AboveGradeSqFtTotal":"1003","AboveGradeFinishedArea":"1003","AccessibilityFeatures":"None","AdditionalParcelsYN":"False","NST_AgentOwner":"No","NST_AmenitiesUnit":"Ceiling Fan(s),Hardwood Floors,Kitchen Window,Paneled Doors,Tile Floors,Washer/Dryer Hookup","Appliances":"Dishwasher,Dryer,Freezer,Gas Water Heater,Microwave,Range,Refrigerator,Stainless Steel Appliances,Washer","LivingAreaUnits":"Square Feet","NST_AssessmentPending":"No","AssociationYN":"False","AssociationFee":"0","Basement":"Drain Tiled,Egress Window(s),Finished","BasementYN":"True","NST_BathDesc":"Main Floor Full Bath,Upper Level 3/4 Bath","BathroomsFull":"1","BathroomsHalf":"0","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"1","BathroomsTotalInteger":"2","BedroomsTotal":"4","NST_BelowGradeSqFtTotal":"808","BelowGradeFinishedArea":"230","CumulativeDaysOnMarket":"0","City":"West Saint Paul","NewConstructionYN":"False","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Dakota","NST_DPResource":"Yes","NST_DiningRoomDescription":"Breakfast Bar,Eat In Kitchen,Informal Dining Room,Kitchen/Dining Room","Directions":"Robert Street to Mainzer, East to home.","DocumentsCount":"3","DocumentsChangeTimestamp":"2026-03-12T14:49:09.583Z","DaysOnMarket":"0","Fencing":"Chain Link,Full","FireplaceYN":"False","FireplacesTotal":"0","FoundationArea":"808","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","NST_GarageSquareFeet":"437","GarageSpaces":"2","Heating":"Forced Air","HighSchoolDistrict":"West St. Paul-Mendota Hts.-Eagan","NST_ForeclosureStatus":"No","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"False","InternetConsumerCommentYN":"False","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","Latitude":"44.917119","LaundryFeatures":"In Basement,Sink,Washer Hookup","NST_LenderOwned":"No","Levels":"One and One Half","ListPrice":"330000","ListingContractDate":"2026-03-12T05:00:00Z","ListingId":"NST7035283","LivingArea":"1233","Longitude":"-93.075153","LotSizeArea":"0.113","LotSizeDimensions":"40x123","LotSizeUnits":"Acres","NST_MainLevelFinishedArea":"808","NST_ManufacturedHome":"N","OriginalEntryTimestamp":"2026-03-12T09:48:52Z","ParcelNumber":"424730001220","NST_SchoolDistrictNumber":"951","ParkingFeatures":"Detached Garage","PhotosCount":"19","PhotosChangeTimestamp":"2026-03-12T15:26:06.232Z","PoolFeatures":"None","PostalCity":"Saint Paul","PostalCode":"55118","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PropertyAttachedYN":"False","PropertySubType":"Single Family Residence","PropertyType":"Residential","PublicRemarks":"Thoughtfully updated four-bedroom, two-bath home that is truly move-in ready. The bright, flowing open-concept layout offers great space for everyday living. Enjoy the newly updated kitchen with stone countertops, newly tiled bathrooms, and a basement living area that provide the home with both style and comfort. New paint and new flooring throughout the house create the perfect blank slate to make it your own. Brand new central air unit, newer mechanicals, a drain tile system installed 10 years ago and a newer roof mean there’s nothing left to do but move in.","PublicSurveyRange":"22","PublicSurveySection":"17","PublicSurveyTownship":"28","RoadFrontageType":"City Street,Curbs,Sidewalks","RoadResponsibility":"Public Maintained Road","Roof":"Age 8 Years or Less,Architectural Shingle","NST_SchoolDistrictPhone":"6514037002","Sewer":"City Sewer/Connected","NST_SpecialSearch":"Divided Bdr Flr Plan,Main Floor Primary,Main Floor Bedroom","StandardStatus":"Active","StateOrProvince":"MN","StreetName":"Mainzer","StreetNumber":"235","StreetNumberNumeric":"235","StreetSuffix":"Street","SubdivisionName":"Mainzers Add","TaxAnnualAmount":"2914","NST_TaxWithAssessments":"2914","TaxYear":"2025","BuildingAreaTotal":"1811","Township":"West Saint Paul","VideosCount":"0","WaterSource":"City Water/Connected","YearBuilt":"1946","ZoningDescription":"Residential-Single Family","ListAgentKey":"NST109879","ListAgentMlsId":"NST502048052","ListOfficeMlsId":"NST26401","ListOfficeName":"Lakes Sotheby's International Realty","ListOfficeKey":"NST26401","ModificationTimestamp":"2026-03-13T10:05:16.985Z","OriginatingSystemName":"northstar","Media":"[{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7867172/a5762253-1638-4fcf-b671-52defd75bdc9.jpeg\",\"ResourceRecordKey\":\"NST7867172\",\"Order\":6,\"MediaObjectID\":\"NST6\",\"ImageWidth\":1800,\"ImageHeight\":1200,\"ImageSizeDescription\":\"1800x1200\",\"MediaModificationTimestamp\":\"2026-03-12T15:25:09.455Z\",\"MediaKey\":\"NST120890967\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7867172/a7afac45-dbb5-45db-9e97-12c80bb9c0a8.jpeg\",\"ResourceRecordKey\":\"NST7867172\",\"Order\":8,\"MediaObjectID\":\"NST8\",\"ImageWidth\":1800,\"ImageHeight\":1200,\"ImageSizeDescription\":\"1800x1200\",\"MediaModificationTimestamp\":\"2026-03-12T15:25:09.457Z\",\"MediaKey\":\"NST120890965\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7867172/5548f739-751b-4913-9b7d-6c6e0936fecc.jpeg\",\"ResourceRecordKey\":\"NST7867172\",\"Order\":18,\"MediaObjectID\":\"NST18\",\"ImageWidth\":1800,\"ImageHeight\":1200,\"ImageSizeDescription\":\"1800x1200\",\"MediaModificationTimestamp\":\"2026-03-12T15:25:09.454Z\",\"MediaKey\":\"NST120890955\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7867172/fe5d32ba-4b63-472a-8d0c-74ec37281556.jpeg\",\"ResourceRecordKey\":\"NST7867172\",\"Order\":4,\"MediaObjectID\":\"NST4\",\"ImageWidth\":1800,\"ImageHeight\":1200,\"ImageSizeDescription\":\"1800x1200\",\"MediaModificationTimestamp\":\"2026-03-12T15:25:09.496Z\",\"MediaKey\":\"NST120890969\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7867172/469455b8-00ab-46a1-af13-e4e70bde0072.jpeg\",\"ResourceRecordKey\":\"NST7867172\",\"Order\":12,\"MediaObjectID\":\"NST12\",\"ImageWidth\":1800,\"ImageHeight\":1200,\"ImageSizeDescription\":\"1800x1200\",\"MediaModificationTimestamp\":\"2026-03-12T15:25:09.475Z\",\"MediaKey\":\"NST120890961\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7867172/c3e942a2-3fa8-486c-9313-492a8a7613ca.jpeg\",\"ResourceRecordKey\":\"NST7867172\",\"Order\":16,\"MediaObjectID\":\"NST16\",\"ImageWidth\":1800,\"ImageHeight\":1200,\"ImageSizeDescription\":\"1800x1200\",\"MediaModificationTimestamp\":\"2026-03-12T15:25:09.483Z\",\"MediaKey\":\"NST120890957\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7867172/245e4cc5-2bc0-407a-b213-5470b4849bce.jpeg\",\"ResourceRecordKey\":\"NST7867172\",\"Order\":3,\"MediaObjectID\":\"NST3\",\"ImageWidth\":1800,\"ImageHeight\":1200,\"ImageSizeDescription\":\"1800x1200\",\"MediaModificationTimestamp\":\"2026-03-12T15:25:09.481Z\",\"MediaKey\":\"NST120890970\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7867172/adb576f5-455c-476f-90a1-335bae6ffbf8.jpeg\",\"ResourceRecordKey\":\"NST7867172\",\"Order\":10,\"MediaObjectID\":\"NST10\",\"ImageWidth\":1800,\"ImageHeight\":1200,\"ImageSizeDescription\":\"1800x1200\",\"MediaModificationTimestamp\":\"2026-03-12T15:25:09.452Z\",\"MediaKey\":\"NST120890963\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7867172/06779d27-b832-45e2-84e5-6eb189d615ae.jpeg\",\"ResourceRecordKey\":\"NST7867172\",\"Order\":2,\"MediaObjectID\":\"NST2\",\"ImageWidth\":1800,\"ImageHeight\":1200,\"ImageSizeDescription\":\"1800x1200\",\"MediaModificationTimestamp\":\"2026-03-12T15:25:09.459Z\",\"MediaKey\":\"NST120890971\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7867172/7083eacb-ebec-4edb-bb3c-f8e1d4da3f86.jpeg\",\"ResourceRecordKey\":\"NST7867172\",\"Order\":9,\"MediaObjectID\":\"NST9\",\"ImageWidth\":1800,\"ImageHeight\":1200,\"ImageSizeDescription\":\"1800x1200\",\"MediaModificationTimestamp\":\"2026-03-12T15:25:09.486Z\",\"MediaKey\":\"NST120890964\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7867172/c02143ba-16f3-4c3a-9c07-9056cbdf1ba7.jpeg\",\"ResourceRecordKey\":\"NST7867172\",\"Order\":11,\"MediaObjectID\":\"NST11\",\"ImageWidth\":1800,\"ImageHeight\":1200,\"ImageSizeDescription\":\"1800x1200\",\"MediaModificationTimestamp\":\"2026-03-12T15:25:09.462Z\",\"MediaKey\":\"NST120890962\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7867172/126643bc-50e2-4e81-89db-3e4631268df4.jpeg\",\"ResourceRecordKey\":\"NST7867172\",\"Order\":17,\"MediaObjectID\":\"NST17\",\"ImageWidth\":1800,\"ImageHeight\":1200,\"ImageSizeDescription\":\"1800x1200\",\"MediaModificationTimestamp\":\"2026-03-12T15:25:09.453Z\",\"MediaKey\":\"NST120890956\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7867172/c23d3277-3a03-455c-93b5-95124af9f0d2.jpeg\",\"ResourceRecordKey\":\"NST7867172\",\"Order\":7,\"MediaObjectID\":\"NST7\",\"ImageWidth\":1800,\"ImageHeight\":1200,\"ImageSizeDescription\":\"1800x1200\",\"MediaModificationTimestamp\":\"2026-03-12T15:25:09.452Z\",\"MediaKey\":\"NST120890966\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7867172/48feafca-4c88-4415-9853-e79960152feb.jpeg\",\"ResourceRecordKey\":\"NST7867172\",\"Order\":14,\"MediaObjectID\":\"NST14\",\"ImageWidth\":1800,\"ImageHeight\":1200,\"ImageSizeDescription\":\"1800x1200\",\"MediaModificationTimestamp\":\"2026-03-12T15:25:09.457Z\",\"MediaKey\":\"NST120890959\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7867172/09d7266d-094f-477b-9edb-eba362a3a8b4.jpeg\",\"ResourceRecordKey\":\"NST7867172\",\"Order\":15,\"MediaObjectID\":\"NST15\",\"ImageWidth\":1800,\"ImageHeight\":1200,\"ImageSizeDescription\":\"1800x1200\",\"MediaModificationTimestamp\":\"2026-03-12T15:25:09.475Z\",\"MediaKey\":\"NST120890958\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7867172/63be4d0a-032a-46c9-a2e3-83729ad7f2d0.jpeg\",\"ResourceRecordKey\":\"NST7867172\",\"Order\":19,\"MediaObjectID\":\"NST19\",\"ImageWidth\":1800,\"ImageHeight\":1200,\"ImageSizeDescription\":\"1800x1200\",\"MediaModificationTimestamp\":\"2026-03-12T15:25:09.503Z\",\"MediaKey\":\"NST120890953\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7867172/6c8777f3-fcea-492f-bf41-74aaff742903.jpeg\",\"ResourceRecordKey\":\"NST7867172\",\"Order\":5,\"MediaObjectID\":\"NST5\",\"ImageWidth\":1800,\"ImageHeight\":1200,\"ImageSizeDescription\":\"1800x1200\",\"MediaModificationTimestamp\":\"2026-03-12T15:25:09.453Z\",\"MediaKey\":\"NST120890968\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7867172/60e64a51-b92f-4b1c-86c2-b4cd7eef9cc0.jpeg\",\"ResourceRecordKey\":\"NST7867172\",\"Order\":1,\"MediaObjectID\":\"NST1\",\"ImageWidth\":1800,\"ImageHeight\":1200,\"ImageSizeDescription\":\"1800x1200\",\"MediaModificationTimestamp\":\"2026-03-12T15:25:09.497Z\",\"MediaKey\":\"NST120890972\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7867172/52c34fa7-8673-4133-9357-45728b96a529.jpeg\",\"ResourceRecordKey\":\"NST7867172\",\"Order\":13,\"MediaObjectID\":\"NST13\",\"ImageWidth\":1800,\"ImageHeight\":1200,\"ImageSizeDescription\":\"1800x1200\",\"MediaModificationTimestamp\":\"2026-03-12T15:25:09.449Z\",\"MediaKey\":\"NST120890960\"}]","Media__MediaURL":"https://s3.amazonaws.com/mlsgrid/images/NST7867172/a5762253-1638-4fcf-b671-52defd75bdc9.jpeg","Media__ResourceRecordKey":"NST7867172","Media__Order":"6","Media__MediaObjectID":"NST6","Media__ImageWidth":"1800","Media__ImageHeight":"1200","Media__ImageSizeDescription":"1800x1200","Media__MediaModificationTimestamp":"3/12/2026 3:25:09 PM","Media__MediaKey":"NST120890967","Rooms":"[{\"RoomLevel\":\"Lower\",\"NST_RoomSortOrder\":8,\"RoomKey\":\"NST116007222\",\"RoomDimensions\":\"10x10\",\"RoomType\":\"Den\"},{\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":2,\"RoomKey\":\"NST116007216\",\"RoomDimensions\":\"12x12\",\"RoomType\":\"Dining Room\"},{\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":4,\"RoomKey\":\"NST116007218\",\"RoomDimensions\":\"11x10\",\"RoomType\":\"Bedroom\"},{\"RoomLevel\":\"Lower\",\"NST_RoomSortOrder\":7,\"RoomKey\":\"NST116007221\",\"RoomDimensions\":\"12x09\",\"RoomType\":\"Bedroom 4\"},{\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":3,\"RoomKey\":\"NST116007217\",\"RoomDimensions\":\"10x10\",\"RoomType\":\"Kitchen\"},{\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":1,\"RoomKey\":\"NST116007215\",\"RoomDimensions\":\"17x13\",\"RoomType\":\"Living Room\"},{\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":5,\"RoomKey\":\"NST116007219\",\"RoomDimensions\":\"10x10\",\"RoomType\":\"Bedroom 2\"},{\"RoomLevel\":\"Upper\",\"NST_RoomSortOrder\":6,\"RoomKey\":\"NST116007220\",\"RoomDimensions\":\"14x12\",\"RoomType\":\"Bedroom 3\"}]","Rooms__RoomLevel":"Lower","Rooms__NST_RoomSortOrder":"8","Rooms__RoomKey":"NST116007222","Rooms__RoomDimensions":"10x10","Rooms__RoomType":"Den","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","CustomVTourURL":""}