{"Id":523934,"ORGTABLE":"RAW_Property","MLSCLASS":"COM","MLSNUMBER":"NST7025153","MLSAGENTID":"NST582502217","MLSOFFICEID":"NST252718","ADDRESS":"41 Center Avenue S","ACRES":0.037,"AGENTOWNER":false,"AUCTIONYN":false,"CITY":"Mayville","CONTINGENCY":"None","COUNTY":"Traill","CURRENTUSE":"Beauty/Barber Shop","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"FORECLOSURE":"No","LASTPRICE":45000.0,"LASTPRICEDATE":"2026-03-02T21:17:06.353","LATITUDE":47.499522,"LENDEROWNED":"No","LISTDATE":"2026-03-02T06:00:00","LISTPRICE":45000.0,"LIVINGAREA":1625.0,"LONGITUDE":-97.326074,"MODIFICATIONTIMESTAMP":"2026-03-03T06:07:05.472","OFFICE_OFFICENAME":"REALTY XPERTS","PHOTOCOUNT":9,"POSTALCODE":"58257","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Commerical Fixer-upper with Apartment Potential - Prime Small-Town Opportunity! \n\nStep into opportunity with this historic commercial building, formerly a barbershop and ready for its next chapter. This property is ideal for investors, entrepreneurs, or DIY renovators looking to restore and customize a unique space with both business and residential potential.\n\nThe main level offers a functional commercial layout with large front windows, excellent visibility, and space suited for a variety of uses including retail, salon, office, or studio. Upstairs presents an exciting opportunity to renovate into a 1-bedroom, 1-bath apartment—perfect for owner-occupancy or additional rental income.\n\nThis property needs renovation and is being sold as-is, making it an excellent value-add project for buyers willing to bring their vision and creativity. With solid bones, historic character, and mixed-use potential, this is your chance to transform a classic building into something special.","ROADBETWEENWATERFRONTANDHOMEYN":false,"SALEINCLUDES":"Building","SCHOOLDISTRICTNUMBER":"1822-May-Port CG","SEWER":"City Sewer/Connected","STATEORPROVINCE":"ND","STATUS":"Active","STATUSDATE":"2026-03-02T21:17:06.353","LASTSTATUS":"Active","STREETDIRSUFFIX":"S","STREETNAME":"Center","STREETNUMBER":"41","STREETSUFFIX":"Avenue","TRANSACTIONTYPE":"For","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1890,"ZONING":"Business/Commercial","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2026-03-03T01:45:05.785","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"1.jpg\"},{\"Order\":2,\"Remarks\":\"2.jpg\"},{\"Order\":3,\"Remarks\":\"3.jpg\"},{\"Order\":4,\"Remarks\":\"4.jpg\"},{\"Order\":5,\"Remarks\":\"5.jpg\"},{\"Order\":6,\"Remarks\":\"6.jpg\"},{\"Order\":7,\"Remarks\":\"7.jpg\"},{\"Order\":8,\"Remarks\":\"8.jpg\"},{\"Order\":9,\"Remarks\":\"9.jpg\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9","SOURCE":"MG_NST"}
{"ListingKey":"NST7856889","AccessibilityFeatures":"None","AdditionalParcelsYN":"False","NST_AgentOwner":"No","LivingAreaUnits":"Square Feet","NST_AssessmentPending":"Unknown","BasementYN":"False","BuildingAreaTotal":"1625","CumulativeDaysOnMarket":"0","City":"Mayville","NewConstructionYN":"False","Contingency":"None","NST_ForSaleOrLease":"For Sale","CountyOrParish":"Traill","CurrentUse":"Beauty/Barber Shop","Directions":"Use Google Maps","DocumentsCount":"1","DocumentsChangeTimestamp":"2026-03-03T01:45:05.785Z","DaysOnMarket":"0","FoundationArea":"600","NST_FoundationDimensions":"20'x30'","NST_FractionalOwnershipYN":"No","NST_Fuel":"Electric","GarageSpaces":"0","Heating":"Forced Air","HighSchoolDistrict":"May-Port CG","NST_ForeclosureStatus":"No","Inclusions":"Building","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"True","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","Latitude":"47.499522","NST_LenderOwned":"No","Levels":"Two","ListPrice":"45000","ListingContractDate":"2026-03-02T06:00:00Z","ListingId":"NST7025153","LockBoxType":"Combo","Longitude":"-97.326074","LotSizeArea":"0.037","LotSizeDimensions":"32 x 51","LotSizeUnits":"Acres","NumberOfUnitsTotal":"1","OriginalEntryTimestamp":"2026-03-02T15:15:01Z","NST_OwnerOccupied":"No","ParcelNumber":"27000206987012","NST_SchoolDistrictNumber":"1822","ParkingFeatures":"On-Street Parking Only","PhotosCount":"9","PhotosChangeTimestamp":"2026-03-03T01:45:05.785Z","PostalCity":"Mayville","PostalCode":"58257","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PropertyType":"Commercial Sale","PublicRemarks":"Commerical Fixer-upper with Apartment Potential - Prime Small-Town Opportunity! \n\nStep into opportunity with this historic commercial building, formerly a barbershop and ready for its next chapter. This property is ideal for investors, entrepreneurs, or DIY renovators looking to restore and customize a unique space with both business and residential potential.\n\nThe main level offers a functional commercial layout with large front windows, excellent visibility, and space suited for a variety of uses including retail, salon, office, or studio. Upstairs presents an exciting opportunity to renovate into a 1-bedroom, 1-bath apartment—perfect for owner-occupancy or additional rental income.\n\nThis property needs renovation and is being sold as-is, making it an excellent value-add project for buyers willing to bring their vision and creativity. With solid bones, historic character, and mixed-use potential, this is your chance to transform a classic building into something special.","Sewer":"City Sewer/Connected","StandardStatus":"Active","StateOrProvince":"ND","StreetDirSuffix":"S","StreetName":"Center","StreetNumber":"41","StreetNumberNumeric":"41","StreetSuffix":"Avenue","SubdivisionName":"Original Townsite","TaxAnnualAmount":"1273","NST_TaxWithAssessments":"1273","TaxYear":"2025","Township":"Mayville","Utilities":"Electric Common","VideosCount":"0","WaterSource":"City Water/Connected","YearBuilt":"1890","ZoningDescription":"Business/Commercial","ListAgentKey":"NST517106","ListAgentMlsId":"NST582502217","ListOfficeMlsId":"NST252718","ListOfficeName":"REALTY XPERTS","ListOfficeKey":"NST1001460","ModificationTimestamp":"2026-03-03T06:07:05.472Z","OriginatingSystemName":"northstar","Media":"[{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7856889/b0626176-7d48-4acf-8035-94d435de6a8a.jpeg\",\"LongDescription\":\"8.jpg\",\"ResourceRecordKey\":\"NST7856889\",\"Order\":8,\"MediaObjectID\":\"NST8\",\"ImageWidth\":2080,\"ImageHeight\":1024,\"ImageSizeDescription\":\"2080x1024\",\"MediaModificationTimestamp\":\"2026-03-03T01:44:40.152Z\",\"MediaKey\":\"NST120715228\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7856889/45ca31ce-f792-4d34-b04d-bece9ba5e008.jpeg\",\"LongDescription\":\"9.jpg\",\"ResourceRecordKey\":\"NST7856889\",\"Order\":9,\"MediaObjectID\":\"NST9\",\"ImageWidth\":2080,\"ImageHeight\":960,\"ImageSizeDescription\":\"2080x960\",\"MediaModificationTimestamp\":\"2026-03-03T01:44:40.146Z\",\"MediaKey\":\"NST120715227\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7856889/bdf4fb03-8827-4e33-a4d9-1132720ef454.jpeg\",\"LongDescription\":\"6.jpg\",\"ResourceRecordKey\":\"NST7856889\",\"Order\":6,\"MediaObjectID\":\"NST6\",\"ImageWidth\":2080,\"ImageHeight\":960,\"ImageSizeDescription\":\"2080x960\",\"MediaModificationTimestamp\":\"2026-03-03T01:44:40.14Z\",\"MediaKey\":\"NST120715230\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7856889/a47b14ef-91d0-4660-8d1d-a7e3d49cdbbb.jpeg\",\"LongDescription\":\"1.jpg\",\"ResourceRecordKey\":\"NST7856889\",\"Order\":1,\"MediaObjectID\":\"NST1\",\"ImageWidth\":1429,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1429x2080\",\"MediaModificationTimestamp\":\"2026-03-03T01:44:40.159Z\",\"MediaKey\":\"NST120715235\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7856889/d0589943-1196-4cd8-a21e-3d2ce18d54d8.jpeg\",\"LongDescription\":\"5.jpg\",\"ResourceRecordKey\":\"NST7856889\",\"Order\":5,\"MediaObjectID\":\"NST5\",\"ImageWidth\":2080,\"ImageHeight\":960,\"ImageSizeDescription\":\"2080x960\",\"MediaModificationTimestamp\":\"2026-03-03T01:44:40.153Z\",\"MediaKey\":\"NST120715231\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7856889/df5020b6-db0d-4fc9-8523-b7c712bf89d3.jpeg\",\"LongDescription\":\"2.jpg\",\"ResourceRecordKey\":\"NST7856889\",\"Order\":2,\"MediaObjectID\":\"NST2\",\"ImageWidth\":2080,\"ImageHeight\":1512,\"ImageSizeDescription\":\"2080x1512\",\"MediaModificationTimestamp\":\"2026-03-03T01:44:40.156Z\",\"MediaKey\":\"NST120715234\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7856889/38408217-db48-4e13-9fc9-c3763e3c85d9.jpeg\",\"LongDescription\":\"7.jpg\",\"ResourceRecordKey\":\"NST7856889\",\"Order\":7,\"MediaObjectID\":\"NST7\",\"ImageWidth\":2080,\"ImageHeight\":960,\"ImageSizeDescription\":\"2080x960\",\"MediaModificationTimestamp\":\"2026-03-03T01:44:40.145Z\",\"MediaKey\":\"NST120715229\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7856889/2975e149-6a29-49b1-9897-b387275bea29.jpeg\",\"LongDescription\":\"4.jpg\",\"ResourceRecordKey\":\"NST7856889\",\"Order\":4,\"MediaObjectID\":\"NST4\",\"ImageWidth\":1848,\"ImageHeight\":1844,\"ImageSizeDescription\":\"1848x1844\",\"MediaModificationTimestamp\":\"2026-03-03T01:44:40.207Z\",\"MediaKey\":\"NST120715232\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7856889/b23ee378-3d06-4eb0-bd1b-4309dfacbb95.jpeg\",\"LongDescription\":\"3.jpg\",\"ResourceRecordKey\":\"NST7856889\",\"Order\":3,\"MediaObjectID\":\"NST3\",\"ImageWidth\":2080,\"ImageHeight\":1604,\"ImageSizeDescription\":\"2080x1604\",\"MediaModificationTimestamp\":\"2026-03-03T01:44:40.171Z\",\"MediaKey\":\"NST120715233\"}]","Media__MediaURL":"https://s3.amazonaws.com/mlsgrid/images/NST7856889/b0626176-7d48-4acf-8035-94d435de6a8a.jpeg","Media__LongDescription":"8.jpg","Media__ResourceRecordKey":"NST7856889","Media__Order":"8","Media__MediaObjectID":"NST8","Media__ImageWidth":"2080","Media__ImageHeight":"1024","Media__ImageSizeDescription":"2080x1024","Media__MediaModificationTimestamp":"3/3/2026 1:44:40 AM","Media__MediaKey":"NST120715228","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"1.jpg\"},{\"Order\":2,\"Remarks\":\"2.jpg\"},{\"Order\":3,\"Remarks\":\"3.jpg\"},{\"Order\":4,\"Remarks\":\"4.jpg\"},{\"Order\":5,\"Remarks\":\"5.jpg\"},{\"Order\":6,\"Remarks\":\"6.jpg\"},{\"Order\":7,\"Remarks\":\"7.jpg\"},{\"Order\":8,\"Remarks\":\"8.jpg\"},{\"Order\":9,\"Remarks\":\"9.jpg\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9","CustomVTourURL":""}