{"Id":1428404,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST6804143","MLSAGENTID":"NST502041462","MLSCOAGENTID":"NST506018614","MLSOFFICEID":"NST26146","ADDRESS":"1830 Mechanic Avenue","ACRES":0.22,"AGENTOWNER":true,"AUCTIONYN":false,"BASEMENT":"Finished,Full","BATHSTOTAL":2.0,"BEDROOMS":5,"CITY":"Saint Paul","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Fiber Board","FORECLOSURE":"No","LASTPRICE":309900.0,"LASTPRICEDATE":"2025-11-04T02:57:03.95","LATITUDE":44.972746,"LENDEROWNED":"No","LISTDATE":"2025-11-03T06:00:00","LISTPRICE":309900.0,"LIVINGAREA":1989.0,"LONGITUDE":-93.023268,"MODIFICATIONTIMESTAMP":"2025-11-04T14:28:04.118","NEIGHBORHOOD":"Greater East Side","OFFICE_OFFICENAME":"eXp Realty","PHOTOCOUNT":23,"POSTALCODE":"55119","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Welcome to this newly updated 4BR, 2BA home with all bedrooms on one level! Features include a refreshed kitchen with new appliances, fully remodeled bath, restored hardwoods, fresh paint, new fixtures, and LVP flooring. Basement with new carpet, updated electrical panel and water heater. Exterior updates include full paint, new garage opener, chimney liner, and landscaping. Move-in ready!","ROADBETWEENWATERFRONTANDHOMEYN":false,"SCHOOLDISTRICTNUMBER":"625-St. Paul","SCHOOLDISTRICTPHONE":"651-767-8100","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2025-11-04T02:57:03.95","LASTSTATUS":"Active","STREETNAME":"Mechanic","STREETNUMBER":"1830","STREETSUFFIX":"Avenue","STYLE":"Single Family Residence","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1964,"ZONING":"Residential-Single Family","VIRTUALTOUR_URL1":"https://my.matterport.com/show/?m=May33RkkXDa&brand=0&mls=1&","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2025-11-04T02:57:03.95","PHOTOREMARKS":"[{\"Order\":21,\"Remarks\":\"Main floor floor plan\"},{\"Order\":22,\"Remarks\":\"Upper level floor plan\"},{\"Order\":23,\"Remarks\":\"Basement floor plan\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23","SOURCE":"MG_NST"}
{"ListingKey":"NST7815607","LotSizeArea":"0.22","NST_AgeOfProperty":"61","NST_AgentOwner":"Yes","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"False","NST_AmenitiesUnit":"Hardwood Floors,Patio,Washer/Dryer Hookup","Appliances":"Dishwasher,Microwave,Range,Refrigerator","NST_AssessmentPending":"No","AssociationYN":"False","AssociationFee":"0","PropertyAttachedYN":"False","NST_AttributionContact":"612-445-6069","NST_AttributionName":"Renae Browley","Basement":"Finished,Full","BasementYN":"True","NST_BathDesc":"Main Floor 1/2 Bath,Upper Level Full Bath","BathroomsOneQuarter":"0","BathroomsFull":"1","BathroomsHalf":"1","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"2","BedroomsTotal":"5","City":"Saint Paul","PropertyType":"Residential","NewConstructionYN":"False","Contingency":"None","Cooling":"None","CountyOrParish":"Ramsey","NST_DPResource":"Y","DaysOnMarket":"1","CumulativeDaysOnMarket":"1","NST_DiningRoomDescription":"Informal Dining Room","Directions":"Maryland to White Bear S to Ames E to VanDyke N to Mechanic W to home","InternetAddressDisplayYN":"True","InternetEntireListingDisplayYN":"True","Electric":"Circuit Breakers,200+ Amp Service","ConstructionMaterials":"Fiber Board","Fencing":"Chain Link,Full","FireplaceFeatures":"Brick,Wood Burning","FireplaceYN":"True","FireplacesTotal":"2","NST_ForeclosureStatus":"No","FoundationArea":"777","NST_FractionalOwnershipYN":"No","RoadFrontageType":"City Street","NST_Fuel":"Natural Gas","ParkingFeatures":"Detached","NST_GarageSquareFeet":"528","AccessibilityFeatures":"None","Heating":"Boiler","OriginalEntryTimestamp":"2025-11-04T02:52:56Z","LandLeaseYN":"False","NST_LastUpdateDate":"2025-11-04","Latitude":"44.972746","NST_LenderOwned":"No","ListAgentKey":"NST96795","ListAgentMlsId":"NST502041462","CoListAgentKey":"NST503551","CoListAgentMlsId":"NST506018614","ListingContractDate":"2025-11-03T06:00:00Z","ListOfficeKey":"NST26146","ListOfficeName":"eXp Realty","ListOfficeMlsId":"NST26146","ListPrice":"309900","LivingArea":"1989","LockBoxType":"Combo","Longitude":"-93.023268","LotSizeDimensions":"76x124","LotSizeSquareFeet":"9408.96","LotSizeUnits":"Acres","ListingId":"NST6804143","SourceSystemName":"RMLS","NST_ManufacturedHome":"No","MapCoordinateSource":"King's Street Atlas","AdditionalParcelsYN":"False","NST_NeighborhoodNumber":"Greater East Side","NST_OfficeBoard":"MAAR","ParcelNumber":"262922230101","GarageSpaces":"1","NST_PatioPorchType":"Patio","PhotosCount":"23","PoolFeatures":"None","PostalCity":"Saint Paul","PostalCode":"55119","NST_PotentialShortSale":"No","NST_PowerCompanyName":"Xcel Energy","NST_PresentUse":"Yearly","PublicRemarks":"Welcome to this newly updated 4BR, 2BA home with all bedrooms on one level! Features include a refreshed kitchen with new appliances, fully remodeled bath, restored hardwoods, fresh paint, new fixtures, and LVP flooring. Basement with new carpet, updated electrical panel and water heater. Exterior updates include full paint, new garage opener, chimney liner, and landscaping. Move-in ready!","PublicSurveyRange":"22","PublicSurveySection":"26","PublicSurveyTownship":"29","NST_RentalLicenseYN":"No","RoadResponsibility":"Public Maintained Road","RoomType":"Living Room,Dining Room,Kitchen,Family Room,Bedroom 1,Bedroom 2,Bedroom 3,Bedroom 4,Bedroom 5,Laundry","NST_AboveGradeSqFtTotal":"1515.0000","NST_BelowGradeSqFtTotal":"684.0000","NST_MainLevelFinishedArea":"738.0000","BuildingAreaTotal":"2199","HighSchoolDistrict":"St. Paul","NST_SchoolDistrictNumber":"625","NST_SchoolDistrictPhone":"651-767-8100","Sewer":"City Sewer/Connected","NST_SpecialSearch":"4 BR on One Level","AboveGradeFinishedArea":"1515","BelowGradeFinishedArea":"474","StateOrProvince":"MN","StandardStatus":"Active","Levels":"Two","StreetName":"Mechanic","StreetNumber":"1830","StreetNumberNumeric":"1830","StreetSuffix":"Avenue","PropertySubType":"Single Family Residence","SubdivisionName":"Hazel Park B","NST_TaxWithAssessments":"4120.0000","TaxYear":"2025","TaxAnnualAmount":"4120","VirtualTourURLUnbranded":"https://my.matterport.com/show/?m=May33RkkXDa&brand=0&mls=1&","WaterSource":"City Water/Connected","YearBuilt":"1964","ZoningDescription":"Residential-Single Family","ModificationTimestamp":"2025-11-04T14:28:04.118Z","PhotosChangeTimestamp":"2025-11-04T02:57:03.95Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7815607\",\"Order\":1,\"MediaObjectID\":\"1\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7815607/671cfad1-8999-4a9e-94d9-ed2c00b6f9b1.jpeg\",\"MediaModificationTimestamp\":\"2025-11-04T02:56:11.615Z\",\"MediaKey\":\"69096b4b93ffea0af06277f0\"},{\"ResourceRecordKey\":\"NST7815607\",\"Order\":2,\"MediaObjectID\":\"2\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7815607/e7d19e6d-2469-42fa-82ea-12274132ee1e.jpeg\",\"MediaModificationTimestamp\":\"2025-11-04T02:56:11.493Z\",\"MediaKey\":\"69096b4b93ffea0af06277f1\"},{\"ResourceRecordKey\":\"NST7815607\",\"Order\":3,\"MediaObjectID\":\"3\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7815607/40cf4451-87db-40a9-bc84-db96da64b9a2.jpeg\",\"MediaModificationTimestamp\":\"2025-11-04T02:56:11.523Z\",\"MediaKey\":\"69096b4b93ffea0af06277f2\"},{\"ResourceRecordKey\":\"NST7815607\",\"Order\":4,\"MediaObjectID\":\"4\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7815607/b1cd083b-1280-4552-b871-a0ed5055d5cc.jpeg\",\"MediaModificationTimestamp\":\"2025-11-04T02:56:11.52Z\",\"MediaKey\":\"69096b4b93ffea0af06277f3\"},{\"ResourceRecordKey\":\"NST7815607\",\"Order\":5,\"MediaObjectID\":\"5\",\"ImageWidth\":2048,\"ImageHeight\":1364,\"ImageSizeDescription\":\"2048x1364\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7815607/e097a14e-7ec5-4a2b-b142-bc35ab1ed4e2.jpeg\",\"MediaModificationTimestamp\":\"2025-11-04T02:56:11.53Z\",\"MediaKey\":\"69096b4b93ffea0af06277f4\"},{\"ResourceRecordKey\":\"NST7815607\",\"Order\":6,\"MediaObjectID\":\"6\",\"ImageWidth\":2048,\"ImageHeight\":1366,\"ImageSizeDescription\":\"2048x1366\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7815607/2110047b-11bc-4290-accd-21cbd5e6c1be.jpeg\",\"MediaModificationTimestamp\":\"2025-11-04T02:56:11.493Z\",\"MediaKey\":\"69096b4b93ffea0af06277f5\"},{\"ResourceRecordKey\":\"NST7815607\",\"Order\":7,\"MediaObjectID\":\"7\",\"ImageWidth\":2048,\"ImageHeight\":1366,\"ImageSizeDescription\":\"2048x1366\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7815607/3e41d193-0b14-4022-beeb-b2643819e158.jpeg\",\"MediaModificationTimestamp\":\"2025-11-04T02:56:11.503Z\",\"MediaKey\":\"69096b4b93ffea0af06277f6\"},{\"ResourceRecordKey\":\"NST7815607\",\"Order\":8,\"MediaObjectID\":\"8\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7815607/91b09388-acfe-4420-b26c-d1774ae57f55.jpeg\",\"MediaModificationTimestamp\":\"2025-11-04T02:56:11.55Z\",\"MediaKey\":\"69096b4b93ffea0af06277f7\"},{\"ResourceRecordKey\":\"NST7815607\",\"Order\":9,\"MediaObjectID\":\"9\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7815607/f35a038c-fa79-4767-9c84-ff56ea491941.jpeg\",\"MediaModificationTimestamp\":\"2025-11-04T02:56:11.51Z\",\"MediaKey\":\"69096b4b93ffea0af06277f8\"},{\"ResourceRecordKey\":\"NST7815607\",\"Order\":10,\"MediaObjectID\":\"10\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7815607/4341bde6-5b08-4e87-aed1-f34e6682a859.jpeg\",\"MediaModificationTimestamp\":\"2025-11-04T02:56:11.472Z\",\"MediaKey\":\"69096b4b93ffea0af06277f9\"},{\"ResourceRecordKey\":\"NST7815607\",\"Order\":11,\"MediaObjectID\":\"11\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7815607/13ef35cf-cce8-4c66-9a8b-4c68e11e8548.jpeg\",\"MediaModificationTimestamp\":\"2025-11-04T02:56:11.51Z\",\"MediaKey\":\"69096b4b93ffea0af06277fa\"},{\"ResourceRecordKey\":\"NST7815607\",\"Order\":12,\"MediaObjectID\":\"12\",\"ImageWidth\":2048,\"ImageHeight\":1364,\"ImageSizeDescription\":\"2048x1364\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7815607/1a3b09e1-3976-4224-998b-21efd08edd75.jpeg\",\"MediaModificationTimestamp\":\"2025-11-04T02:56:11.472Z\",\"MediaKey\":\"69096b4b93ffea0af06277fb\"},{\"ResourceRecordKey\":\"NST7815607\",\"Order\":13,\"MediaObjectID\":\"13\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7815607/4782363c-e975-4182-ae44-e39603490ebf.jpeg\",\"MediaModificationTimestamp\":\"2025-11-04T02:56:11.472Z\",\"MediaKey\":\"69096b4b93ffea0af06277fc\"},{\"ResourceRecordKey\":\"NST7815607\",\"Order\":14,\"MediaObjectID\":\"14\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7815607/6c9761dd-0eb7-486f-8506-6375f3b16826.jpeg\",\"MediaModificationTimestamp\":\"2025-11-04T02:56:11.472Z\",\"MediaKey\":\"69096b4b93ffea0af06277fd\"},{\"ResourceRecordKey\":\"NST7815607\",\"Order\":15,\"MediaObjectID\":\"15\",\"ImageWidth\":2048,\"ImageHeight\":1366,\"ImageSizeDescription\":\"2048x1366\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7815607/3b7c05c0-1e3d-4596-8399-c90d16326ec7.jpeg\",\"MediaModificationTimestamp\":\"2025-11-04T02:56:11.493Z\",\"MediaKey\":\"69096b4b93ffea0af06277fe\"},{\"ResourceRecordKey\":\"NST7815607\",\"Order\":16,\"MediaObjectID\":\"16\",\"ImageWidth\":2048,\"ImageHeight\":1366,\"ImageSizeDescription\":\"2048x1366\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7815607/29a1506a-05c0-41b2-9047-adb18c13cad1.jpeg\",\"MediaModificationTimestamp\":\"2025-11-04T02:56:11.489Z\",\"MediaKey\":\"69096b4b93ffea0af06277ff\"},{\"ResourceRecordKey\":\"NST7815607\",\"Order\":17,\"MediaObjectID\":\"17\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7815607/967a0541-797a-4fbf-b1ef-fdef33d8a905.jpeg\",\"MediaModificationTimestamp\":\"2025-11-04T02:56:11.48Z\",\"MediaKey\":\"69096b4b93ffea0af0627800\"},{\"ResourceRecordKey\":\"NST7815607\",\"Order\":18,\"MediaObjectID\":\"18\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7815607/d67642d3-42af-4f15-8c12-1eb73a1a2650.jpeg\",\"MediaModificationTimestamp\":\"2025-11-04T02:56:11.558Z\",\"MediaKey\":\"69096b4b93ffea0af0627801\"},{\"ResourceRecordKey\":\"NST7815607\",\"Order\":19,\"MediaObjectID\":\"19\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7815607/466b8ee7-1360-412e-a494-04f1e3a95b1a.jpeg\",\"MediaModificationTimestamp\":\"2025-11-04T02:56:11.595Z\",\"MediaKey\":\"69096b4b93ffea0af0627802\"},{\"ResourceRecordKey\":\"NST7815607\",\"Order\":20,\"MediaObjectID\":\"20\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7815607/6eee063b-1546-4895-b987-cdc132a2bcb6.jpeg\",\"MediaModificationTimestamp\":\"2025-11-04T02:56:11.568Z\",\"MediaKey\":\"69096b4b93ffea0af0627803\"},{\"ResourceRecordKey\":\"NST7815607\",\"Order\":21,\"MediaObjectID\":\"21\",\"LongDescription\":\"Main floor floor plan\",\"ImageWidth\":2080,\"ImageHeight\":1470,\"ImageSizeDescription\":\"2080x1470\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7815607/2cb57bc7-2fc2-4375-9948-acf4496dedd8.png\",\"MediaModificationTimestamp\":\"2025-11-04T02:56:11.548Z\",\"MediaKey\":\"69096b4b93ffea0af0627804\"},{\"ResourceRecordKey\":\"NST7815607\",\"Order\":22,\"MediaObjectID\":\"22\",\"LongDescription\":\"Upper level floor plan\",\"ImageWidth\":2080,\"ImageHeight\":1470,\"ImageSizeDescription\":\"2080x1470\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7815607/42f51264-2ae0-4ebd-bc14-4cab08be1115.png\",\"MediaModificationTimestamp\":\"2025-11-04T02:56:11.51Z\",\"MediaKey\":\"69096b4b93ffea0af0627805\"},{\"ResourceRecordKey\":\"NST7815607\",\"Order\":23,\"MediaObjectID\":\"23\",\"LongDescription\":\"Basement floor plan\",\"ImageWidth\":2080,\"ImageHeight\":1470,\"ImageSizeDescription\":\"2080x1470\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7815607/2a658aff-5aa4-4bf0-adb9-0182c9338ebd.png\",\"MediaModificationTimestamp\":\"2025-11-04T02:56:11.521Z\",\"MediaKey\":\"69096b4b93ffea0af0627806\"}]","Rooms":"[{\"RoomKey\":\"NST115699607\",\"RoomType\":\"Living Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"13x19\",\"NST_RoomSortOrder\":\"1\"},{\"RoomKey\":\"NST115699608\",\"RoomType\":\"Dining Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"9x11\",\"NST_RoomSortOrder\":\"2\"},{\"RoomKey\":\"NST115699609\",\"RoomType\":\"Kitchen\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"20x11\",\"NST_RoomSortOrder\":\"3\"},{\"RoomKey\":\"NST115699610\",\"RoomType\":\"Family Room\",\"RoomLevel\":\"Lower\",\"RoomDimensions\":\"27x11\",\"NST_RoomSortOrder\":\"4\"},{\"RoomKey\":\"NST115699612\",\"RoomType\":\"Bedroom 1\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"10x9\",\"NST_RoomSortOrder\":\"5\"},{\"RoomKey\":\"NST115699613\",\"RoomType\":\"Bedroom 2\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"11x10\",\"NST_RoomSortOrder\":\"6\"},{\"RoomKey\":\"NST115699614\",\"RoomType\":\"Bedroom 3\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"14x11\",\"NST_RoomSortOrder\":\"7\"},{\"RoomKey\":\"NST115699615\",\"RoomType\":\"Bedroom 4\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"10x13\",\"NST_RoomSortOrder\":\"8\"},{\"RoomKey\":\"NST115731485\",\"RoomType\":\"Bedroom 5\",\"RoomLevel\":\"Basement\",\"RoomDimensions\":\"11x11\",\"NST_RoomSortOrder\":\"9\"},{\"RoomKey\":\"NST115749741\",\"RoomType\":\"Laundry\",\"RoomLevel\":\"Basement\",\"RoomDimensions\":\"21x10\",\"NST_RoomSortOrder\":\"10\"}]","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":21,\"Remarks\":\"Main floor floor plan\"},{\"Order\":22,\"Remarks\":\"Upper level floor plan\"},{\"Order\":23,\"Remarks\":\"Basement floor plan\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23","CustomVTourURL":""}