{"Id":593907,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST7119782","MLSAGENTID":"NST249512635","MLSCOAGENTID":"NST505004210","MLSOFFICEID":"NST26004","ADDRESS":"244 Mainzer Street","ACRES":0.11,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Block","BATHSTOTAL":1.0,"BEDROOMS":3.0,"CITY":"West Saint Paul","CONTINGENCY":"None","COUNTY":"Dakota","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Frame","FORECLOSURE":"No","LASTPRICE":339900.0,"LASTPRICEDATE":"2026-07-31T20:17:08.03","LATITUDE":44.91654902,"LENDEROWNED":"No","LISTDATE":"2026-07-31T05:00:00","LISTPRICE":339900.0,"LIVINGAREA":1520.0,"LONGITUDE":-93.07484221,"LOTDESCRIPTION":"Tree Coverage - Light","MODIFICATIONTIMESTAMP":"2026-08-01T00:04:11.478","OFFICE_OFFICENAME":"RE/MAX Advantage Plus","PHOTOCOUNT":18,"POSTALCODE":"55118","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Beautifully maintained 3-bedroom, 2-story home in a highly desirable West St. Paul neighborhood! This move-in-ready home blends timeless character with thoughtful updates, featuring stunning original woodwork, hardwood floors, and an updated kitchen with newer cabinetry, stone flooring, and a double dishwasher. The spacious bath includes a whirlpool tub and separate shower. Step outside to enjoy the beautifully landscaped backyard and large patio, perfect for entertaining or relaxing. Conveniently located near shopping, restaurants, parks, and major commuter routes. Homes with this combination of charm, updates, and location don't come along often—schedule your showing today!","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Age Over 8 Years","SCHOOLDISTRICTNUMBER":"197-West St. Paul-Mendota Hts.-Eagan","SCHOOLDISTRICTPHONE":"6514037002","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2026-07-31T20:17:08.03","LASTSTATUS":"Active","STREETNAME":"Mainzer","STREETNUMBER":"244","STREETSUFFIX":"Street","STYLE":"Single Family","TRANSACTIONTYPE":"For","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1900,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2026-08-01T00:03:06.466","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"Front view 2.jpeg\"},{\"Order\":2,\"Remarks\":\"Front view.jpeg\"},{\"Order\":3,\"Remarks\":\"Living room 1.jpeg\"},{\"Order\":4,\"Remarks\":\"Living room 2.jpeg\"},{\"Order\":5,\"Remarks\":\"Dining room 1.jpeg\"},{\"Order\":6,\"Remarks\":\"Entry.jpeg\"},{\"Order\":7,\"Remarks\":\"Kitchen 1.jpeg\"},{\"Order\":8,\"Remarks\":\"Kitchen 2.jpeg\"},{\"Order\":9,\"Remarks\":\"Bedroom 1.jpeg\"},{\"Order\":10,\"Remarks\":\"Bedroom 3.jpeg\"},{\"Order\":11,\"Remarks\":\"Bedroom 2.jpeg\"},{\"Order\":12,\"Remarks\":\"Backyard 1.jpeg\"},{\"Order\":13,\"Remarks\":\"Family room.jpeg\"},{\"Order\":14,\"Remarks\":\"Laundry.jpeg\"},{\"Order\":15,\"Remarks\":\"Lead glass piano window.jpeg\"},{\"Order\":16,\"Remarks\":\"Basement storage.jpeg\"},{\"Order\":17,\"Remarks\":\"Patio 1.jpeg\"},{\"Order\":18,\"Remarks\":\"Patio 2.jpeg\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18","SOURCE":"MG_NST"}
{"ListingKey":"NST7944508","NST_AboveGradeSqFtTotal":"1150","AboveGradeFinishedArea":"1150","AccessibilityFeatures":"None","AdditionalParcelsYN":"False","NST_AgentOwner":"No","NST_AmenitiesUnit":"Hardwood Floors,Natural Woodwork,Patio","Appliances":"Dishwasher,Dryer,Gas Water Heater,Microwave,Range,Refrigerator,Washer","LivingAreaUnits":"Square Feet","NST_AssessmentPending":"No","AssociationYN":"False","AssociationFee":"0","Basement":"Block","BasementYN":"True","NST_BathDesc":"Upper Level Full Bath","BathroomsFull":"1","BathroomsHalf":"0","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"1","BedroomsTotal":"3","NST_BelowGradeSqFtTotal":"545","BelowGradeFinishedArea":"370","CumulativeDaysOnMarket":"0","City":"West Saint Paul","ConstructionMaterials":"Frame","NewConstructionYN":"False","Contingency":"None","NST_ForSaleOrLease":"For Sale","Cooling":"Central Air","CountyOrParish":"Dakota","NST_DiningRoomDescription":"Separate/Formal Dining Room","Directions":"Butler West to Oakdale North to Mainzer East to Home","DocumentsCount":"0","DaysOnMarket":"0","Electric":"100 Amp Service","ExteriorFeatures":"Stucco","Fencing":"Privacy,Wood","FireplaceYN":"False","FireplacesTotal":"0","FoundationArea":"575","FoundationDetails":"Block","NST_FoundationDimensions":"23x25","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","NST_GarageSquareFeet":"240","GarageSpaces":"1","Heating":"Forced Air","HighSchoolDistrict":"West St. Paul-Mendota Hts.-Eagan","NST_ForeclosureStatus":"No","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"False","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","Latitude":"44.9165490165","LaundryFeatures":"In Basement","NST_LenderOwned":"No","Levels":"Two","ListPrice":"339900","ListingContractDate":"2026-07-31T05:00:00Z","ListingId":"NST7119782","LivingArea":"1520","LockBoxType":"Supra","Longitude":"-93.074842213","LotFeatures":"Tree Coverage - Light","LotSizeArea":"0.11","LotSizeDimensions":"40x123","LotSizeUnits":"Acres","NST_MainLevelFinishedArea":"575","NST_ManufacturedHome":"N","OriginalEntryTimestamp":"2026-07-31T15:16:58Z","ParcelNumber":"424730002121","ParkingFeatures":"Detached Garage","NST_PatioPorchType":"Patio","PhotosCount":"18","PhotosChangeTimestamp":"2026-08-01T00:03:06.466Z","PostalCity":"West Saint Paul","PostalCode":"55118","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PropertyAttachedYN":"False","PropertySubType":"Single Family","PropertyType":"Residential","PublicRemarks":"Beautifully maintained 3-bedroom, 2-story home in a highly desirable West St. Paul neighborhood! This move-in-ready home blends timeless character with thoughtful updates, featuring stunning original woodwork, hardwood floors, and an updated kitchen with newer cabinetry, stone flooring, and a double dishwasher. The spacious bath includes a whirlpool tub and separate shower. Step outside to enjoy the beautifully landscaped backyard and large patio, perfect for entertaining or relaxing. Conveniently located near shopping, restaurants, parks, and major commuter routes. Homes with this combination of charm, updates, and location don't come along often—schedule your showing today!","PublicSurveyRange":"22","PublicSurveySection":"17","PublicSurveyTownship":"28","RoadFrontageType":"City Street,Paved Streets,Sidewalks","RoadResponsibility":"Public Maintained Road","Roof":"Age Over 8 Years","NST_SchoolDistrictFullName":"197 - West St. Paul-Mendota Hts.-Eagan","NST_SchoolDistrictNumber":"197","NST_SchoolDistrictPhone":"6514037002","Sewer":"City Sewer/Connected","NST_SpecialSearch":"3 BR on One Level","StandardStatus":"Active","StateOrProvince":"MN","StreetName":"Mainzer","StreetNumber":"244","StreetNumberNumeric":"244","StreetSuffix":"Street","SubdivisionName":"Mainzers Add","TaxAnnualAmount":"2874","NST_TaxWithAssessments":"2874","TaxYear":"2026","NST_TotalArea":"1695","BuildingAreaTotal":"1695","Township":"West Saint Paul","VideosCount":"0","WaterSource":"City Water/Connected","WaterfrontYN":"False","YearBuilt":"1900","ZoningDescription":"Residential-Single Family","CoListAgentKey":"NST59094","CoListAgentMlsId":"NST505004210","CoListOfficeName":"RE/MAX Advantage Plus","ListAgentKey":"NST48247","ListAgentMlsId":"NST249512635","ListOfficeMlsId":"NST26004","ListOfficeName":"RE/MAX Advantage Plus","ListOfficeKey":"NST26004","ModificationTimestamp":"2026-08-01T00:04:11.478Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7944508\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7944508/125068fb-bcf8-43a6-a829-40afd58c84f6.jpeg\",\"LongDescription\":\"Bedroom 1.jpeg\",\"Order\":9,\"MediaObjectID\":\"NST9\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-08-01T00:01:06.76Z\",\"MediaKey\":\"NST123981236\"},{\"ResourceRecordKey\":\"NST7944508\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7944508/f3400c00-3b87-4f6d-86ca-679e9041f801.jpeg\",\"LongDescription\":\"Bedroom 3.jpeg\",\"Order\":10,\"MediaObjectID\":\"NST10\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-08-01T00:01:06.728Z\",\"MediaKey\":\"NST123981234\"},{\"ResourceRecordKey\":\"NST7944508\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7944508/ff3ef3de-e45c-41b4-8509-e34707c954f5.jpeg\",\"LongDescription\":\"Living room 2.jpeg\",\"Order\":4,\"MediaObjectID\":\"NST4\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-07-31T23:59:08.629Z\",\"MediaKey\":\"NST123981223\"},{\"ResourceRecordKey\":\"NST7944508\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7944508/bd535e41-c502-4f39-9d17-08d09c39a685.jpeg\",\"LongDescription\":\"Dining room 1.jpeg\",\"Order\":5,\"MediaObjectID\":\"NST5\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-08-01T00:00:06.418Z\",\"MediaKey\":\"NST123981233\"},{\"ResourceRecordKey\":\"NST7944508\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7944508/266a303a-a2b9-4ce3-8c5d-d6d4a09c88b8.jpeg\",\"LongDescription\":\"Laundry.jpeg\",\"Order\":14,\"MediaObjectID\":\"NST14\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-08-01T00:03:05.833Z\",\"MediaKey\":\"NST123981226\"},{\"ResourceRecordKey\":\"NST7944508\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7944508/64874108-8076-4e13-bc36-1506d429992b.jpeg\",\"LongDescription\":\"Family room.jpeg\",\"Order\":13,\"MediaObjectID\":\"NST13\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-08-01T00:03:05.807Z\",\"MediaKey\":\"NST123981231\"},{\"ResourceRecordKey\":\"NST7944508\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7944508/6df8adc5-fb71-4f73-8c3e-00d7cc44c03d.jpeg\",\"LongDescription\":\"Kitchen 2.jpeg\",\"Order\":8,\"MediaObjectID\":\"NST8\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-08-01T00:01:06.73Z\",\"MediaKey\":\"NST123981227\"},{\"ResourceRecordKey\":\"NST7944508\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7944508/5640003e-79ab-4b2d-8c4b-679a3c5b2402.jpeg\",\"LongDescription\":\"Lead glass piano window.jpeg\",\"Order\":15,\"MediaObjectID\":\"NST15\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-08-01T00:03:05.789Z\",\"MediaKey\":\"NST123981225\"},{\"ResourceRecordKey\":\"NST7944508\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7944508/f83ef02b-89c9-4417-8ca6-91cf4b52355c.jpeg\",\"LongDescription\":\"Front view 2.jpeg\",\"Order\":1,\"MediaObjectID\":\"NST1\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-07-31T23:59:08.681Z\",\"MediaKey\":\"NST123981230\"},{\"ResourceRecordKey\":\"NST7944508\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7944508/aa60827a-c31f-4d38-bac9-06fd113d6496.jpeg\",\"LongDescription\":\"Living room 1.jpeg\",\"Order\":3,\"MediaObjectID\":\"NST3\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-07-31T23:59:08.595Z\",\"MediaKey\":\"NST123981224\"},{\"ResourceRecordKey\":\"NST7944508\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7944508/66baadc4-7980-47f2-b8c0-97343eb26c05.jpeg\",\"LongDescription\":\"Kitchen 1.jpeg\",\"Order\":7,\"MediaObjectID\":\"NST7\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-08-01T00:01:06.759Z\",\"MediaKey\":\"NST123981228\"},{\"ResourceRecordKey\":\"NST7944508\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7944508/7bc570d7-7ddd-415f-a1f2-e7bc50608333.jpeg\",\"LongDescription\":\"Patio 1.jpeg\",\"Order\":17,\"MediaObjectID\":\"NST17\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-07-31T23:59:08.683Z\",\"MediaKey\":\"NST123981222\"},{\"ResourceRecordKey\":\"NST7944508\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7944508/b0b842d2-2d55-43d0-ae08-fdf49002b433.jpeg\",\"LongDescription\":\"Basement storage.jpeg\",\"Order\":16,\"MediaObjectID\":\"NST16\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-08-01T00:03:05.809Z\",\"MediaKey\":\"NST123981237\"},{\"ResourceRecordKey\":\"NST7944508\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7944508/8fb59ed9-a63a-4251-a510-107ec373f88d.jpeg\",\"LongDescription\":\"Patio 2.jpeg\",\"Order\":18,\"MediaObjectID\":\"NST18\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-07-31T23:59:08.65Z\",\"MediaKey\":\"NST123981221\"},{\"ResourceRecordKey\":\"NST7944508\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7944508/bdf445b2-df2c-4a31-aa84-81dcca973c17.jpeg\",\"LongDescription\":\"Backyard 1.jpeg\",\"Order\":12,\"MediaObjectID\":\"NST12\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-08-01T00:01:06.761Z\",\"MediaKey\":\"NST123981238\"},{\"ResourceRecordKey\":\"NST7944508\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7944508/55a43006-8442-430f-bed3-e5a6dc2b9925.jpeg\",\"LongDescription\":\"Bedroom 2.jpeg\",\"Order\":11,\"MediaObjectID\":\"NST11\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-08-01T00:01:06.704Z\",\"MediaKey\":\"NST123981235\"},{\"ResourceRecordKey\":\"NST7944508\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7944508/a97d8262-325a-44f1-a015-158c8e453457.jpeg\",\"LongDescription\":\"Entry.jpeg\",\"Order\":6,\"MediaObjectID\":\"NST6\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-08-01T00:01:06.747Z\",\"MediaKey\":\"NST123981232\"},{\"ResourceRecordKey\":\"NST7944508\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7944508/95d78648-c820-4e5e-868c-888db92a7190.jpeg\",\"LongDescription\":\"Front view.jpeg\",\"Order\":2,\"MediaObjectID\":\"NST2\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-07-31T23:59:08.646Z\",\"MediaKey\":\"NST123981229\"}]","Media__ResourceRecordKey":"NST7944508","Media__MediaURL":"https://s3.amazonaws.com/mlsgrid/images/NST7944508/125068fb-bcf8-43a6-a829-40afd58c84f6.jpeg","Media__LongDescription":"Bedroom 1.jpeg","Media__Order":"9","Media__MediaObjectID":"NST9","Media__ImageWidth":"2080","Media__ImageHeight":"1560","Media__ImageSizeDescription":"2080x1560","Media__MediaModificationTimestamp":"8/1/2026 12:01:06 AM","Media__MediaKey":"NST123981236","DocumentsChangeTimestamp":"2026-07-31T20:17:08.031Z","Rooms":"[{\"RoomLevel\":\"Main\",\"RoomKey\":\"NST116521583\",\"NST_RoomSortOrder\":2,\"RoomType\":\"Dining Room\",\"RoomDimensions\":\"13x12\"},{\"RoomLevel\":\"Basement\",\"RoomKey\":\"NST116521585\",\"NST_RoomSortOrder\":4,\"RoomType\":\"Family Room\"},{\"RoomLevel\":\"Upper\",\"RoomKey\":\"NST116521586\",\"NST_RoomSortOrder\":5,\"RoomType\":\"Bedroom\",\"RoomDimensions\":\"13x12\"},{\"RoomLevel\":\"Main\",\"RoomKey\":\"NST116521584\",\"NST_RoomSortOrder\":3,\"RoomType\":\"Kitchen\",\"RoomDimensions\":\"12x9\"},{\"RoomLevel\":\"Main\",\"RoomKey\":\"NST116521582\",\"NST_RoomSortOrder\":1,\"RoomType\":\"Living Room\",\"RoomDimensions\":\"14x12\"},{\"RoomLevel\":\"Main\",\"RoomKey\":\"NST116521635\",\"NST_RoomSortOrder\":8,\"RoomType\":\"Patio\"},{\"RoomLevel\":\"Upper\",\"RoomKey\":\"NST116521587\",\"NST_RoomSortOrder\":6,\"RoomType\":\"Bedroom 2\",\"RoomDimensions\":\"13x9\"},{\"RoomLevel\":\"Upper\",\"RoomKey\":\"NST116521588\",\"NST_RoomSortOrder\":7,\"RoomType\":\"Bedroom 3\",\"RoomDimensions\":\"10x9\"}]","Rooms__RoomLevel":"Main","Rooms__RoomKey":"NST116521583","Rooms__NST_RoomSortOrder":"2","Rooms__RoomType":"Dining Room","Rooms__RoomDimensions":"13x12","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"Front view 2.jpeg\"},{\"Order\":2,\"Remarks\":\"Front view.jpeg\"},{\"Order\":3,\"Remarks\":\"Living room 1.jpeg\"},{\"Order\":4,\"Remarks\":\"Living room 2.jpeg\"},{\"Order\":5,\"Remarks\":\"Dining room 1.jpeg\"},{\"Order\":6,\"Remarks\":\"Entry.jpeg\"},{\"Order\":7,\"Remarks\":\"Kitchen 1.jpeg\"},{\"Order\":8,\"Remarks\":\"Kitchen 2.jpeg\"},{\"Order\":9,\"Remarks\":\"Bedroom 1.jpeg\"},{\"Order\":10,\"Remarks\":\"Bedroom 3.jpeg\"},{\"Order\":11,\"Remarks\":\"Bedroom 2.jpeg\"},{\"Order\":12,\"Remarks\":\"Backyard 1.jpeg\"},{\"Order\":13,\"Remarks\":\"Family room.jpeg\"},{\"Order\":14,\"Remarks\":\"Laundry.jpeg\"},{\"Order\":15,\"Remarks\":\"Lead glass piano window.jpeg\"},{\"Order\":16,\"Remarks\":\"Basement storage.jpeg\"},{\"Order\":17,\"Remarks\":\"Patio 1.jpeg\"},{\"Order\":18,\"Remarks\":\"Patio 2.jpeg\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18","CustomVTourURL":""}