{"Id":592122,"ORGTABLE":"RAW_Property","MLSCLASS":"COM","MLSNUMBER":"NST7117630","MLSAGENTID":"NST505003924","MLSOFFICEID":"NST6582","ADDRESS":"2575 Hamline Avenue N","ACRES":0.037,"AGENTOWNER":false,"AUCTIONYN":false,"CITY":"Roseville","CONTINGENCY":"None","COUNTY":"Ramsey","CURRENTUSE":"Office","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"FORECLOSURE":"No","LASTPRICE":195200.0,"LASTPRICEDATE":"2026-07-28T21:06:07.25","LATITUDE":45.019224,"LENDEROWNED":"No","LISTDATE":"2026-07-28T05:00:00","LISTPRICE":195200.0,"LIVINGAREA":0.0,"LONGITUDE":-93.157369,"MODIFICATIONTIMESTAMP":"2026-07-28T21:06:07.25","OFFICE_OFFICENAME":"Keller Williams Realty Integrity Lakes","PHOTOCOUNT":25,"POSTALCODE":"55113","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Stop paying your Landlord for office space and purchase your own commercial property today!\nProfessionally finished law office, fully built out on the main level and storage in the lower level.\nA light-filled reception area greets you upon entry, along with a private restroom, open workroom and two private\noffices with sliding glass doors leading directly to the private patio, plus interior room.\nLower level is currently unfinished, and is used for storage. Rough-In for a 2nd Restroom, Drain Tiled and Span-crete support.","ROADBETWEENWATERFRONTANDHOMEYN":false,"SALEINCLUDES":"Building","SCHOOLDISTRICTNUMBER":"623-Roseville","SCHOOLDISTRICTPHONE":"6516351600","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2026-07-28T21:06:07.25","LASTSTATUS":"Active","STREETDIRSUFFIX":"N","STREETNAME":"Hamline","STREETNUMBER":"2575","STREETSUFFIX":"Avenue","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1983,"ZONING":"Business/Commercial","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2026-07-28T21:06:07.25","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25","SOURCE":"MG_NST"}
{"ListingKey":"NST7942663","AccessibilityFeatures":"None","AdditionalParcelsYN":"False","NST_AgentOwner":"No","LivingAreaUnits":"Square Feet","NST_AssessmentPending":"No","BasementYN":"True","CumulativeDaysOnMarket":"0","City":"Roseville","NST_CommercialStyleType":"Office","NewConstructionYN":"False","Contingency":"None","NST_ForSaleOrLease":"For Sale","CountyOrParish":"Ramsey","CurrentUse":"Office","Directions":"Building frontage on Hamline Avenue, just south of County Road C","DocumentsCount":"0","DaysOnMarket":"0","ExteriorFeatures":"Brick Veneer","FoundationArea":"1917","FoundationDetails":"Block","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","GarageSpaces":"0","Heating":"Forced Air","HighSchoolDistrict":"Roseville","NST_ForeclosureStatus":"No","Inclusions":"Building","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"False","InternetConsumerCommentYN":"False","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","Latitude":"45.019224","NST_LenderOwned":"No","ListPrice":"195200","ListingContractDate":"2026-07-28T05:00:00Z","ListingId":"NST7117630","Longitude":"-93.157369","LotSizeArea":"0.037","LotSizeDimensions":"Common","LotSizeUnits":"Acres","NumberOfUnitsTotal":"1","OriginalEntryTimestamp":"2026-07-28T16:04:25Z","ParcelNumber":"102923210071","ParkingFeatures":"Parking Lot","PhotosCount":"25","PhotosChangeTimestamp":"2026-07-28T21:06:07.25Z","PostalCity":"Roseville","PostalCode":"55113","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PropertyType":"Commercial Sale","PublicRemarks":"Stop paying your Landlord for office space and purchase your own commercial property today!\nProfessionally finished law office, fully built out on the main level and storage in the lower level.\nA light-filled reception area greets you upon entry, along with a private restroom, open workroom and two private\noffices with sliding glass doors leading directly to the private patio, plus interior room.\nLower level is currently unfinished, and is used for storage. Rough-In for a 2nd Restroom, Drain Tiled and Span-crete support.","PublicSurveyRange":"23","PublicSurveySection":"10","PublicSurveyTownship":"29","NST_SchoolDistrictFullName":"623 - Roseville","NST_SchoolDistrictNumber":"623","NST_SchoolDistrictPhone":"6516351600","Sewer":"City Sewer/Connected","StandardStatus":"Active","StateOrProvince":"MN","StreetDirSuffix":"N","StreetName":"Hamline","StreetNumber":"2575","StreetNumberNumeric":"2575","StreetSuffix":"Avenue","SubdivisionName":"Hamline Townoffice Plaza","TaxAnnualAmount":"4980","NST_TaxWithAssessments":"4980","TaxYear":"2025","Township":"Roseville","UnitNumber":"E","Utilities":"Heating Common","VideosCount":"0","WaterSource":"City Water/Connected","WaterfrontYN":"False","YearBuilt":"1983","ZoningDescription":"Business/Commercial","ListAgentKey":"NST84202","ListAgentMlsId":"NST505003924","ListOfficeMlsId":"NST6582","ListOfficeName":"Keller Williams Realty Integrity Lakes","ListOfficeKey":"NST11236","ModificationTimestamp":"2026-07-28T21:06:07.25Z","OriginatingSystemName":"northstar","Media":"[{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7942663/64f09dca-7031-4972-b6d6-dcc4e0e25e38.jpeg\",\"ResourceRecordKey\":\"NST7942663\",\"Order\":25,\"MediaObjectID\":\"NST25\",\"ImageWidth\":1051,\"ImageHeight\":817,\"ImageSizeDescription\":\"1051x817\",\"MediaModificationTimestamp\":\"2026-07-28T21:05:19.062Z\",\"MediaKey\":\"NST123891392\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7942663/034fd97d-1c03-44ee-b360-5ef23d8af367.jpeg\",\"ResourceRecordKey\":\"NST7942663\",\"Order\":19,\"MediaObjectID\":\"NST19\",\"ImageWidth\":2000,\"ImageHeight\":1331,\"ImageSizeDescription\":\"2000x1331\",\"MediaModificationTimestamp\":\"2026-07-28T21:05:19.071Z\",\"MediaKey\":\"NST123891398\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7942663/25267e68-0561-4543-bc4b-43db42e0e793.jpeg\",\"ResourceRecordKey\":\"NST7942663\",\"Order\":3,\"MediaObjectID\":\"NST3\",\"ImageWidth\":2000,\"ImageHeight\":1331,\"ImageSizeDescription\":\"2000x1331\",\"MediaModificationTimestamp\":\"2026-07-28T21:05:19.085Z\",\"MediaKey\":\"NST123891383\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7942663/67aace02-b4d4-41ed-8295-5583c53de58d.jpeg\",\"ResourceRecordKey\":\"NST7942663\",\"Order\":7,\"MediaObjectID\":\"NST7\",\"ImageWidth\":2000,\"ImageHeight\":1331,\"ImageSizeDescription\":\"2000x1331\",\"MediaModificationTimestamp\":\"2026-07-28T21:05:19.097Z\",\"MediaKey\":\"NST123891410\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7942663/8a1bea27-f7e8-4316-9541-d4fc470f1bb5.jpeg\",\"ResourceRecordKey\":\"NST7942663\",\"Order\":5,\"MediaObjectID\":\"NST5\",\"ImageWidth\":2000,\"ImageHeight\":1331,\"ImageSizeDescription\":\"2000x1331\",\"MediaModificationTimestamp\":\"2026-07-28T21:05:19.074Z\",\"MediaKey\":\"NST123891412\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7942663/9e76dfe2-b5b6-49d2-b351-facf87607c04.jpeg\",\"ResourceRecordKey\":\"NST7942663\",\"Order\":14,\"MediaObjectID\":\"NST14\",\"ImageWidth\":2000,\"ImageHeight\":1331,\"ImageSizeDescription\":\"2000x1331\",\"MediaModificationTimestamp\":\"2026-07-28T21:05:19.071Z\",\"MediaKey\":\"NST123891403\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7942663/665dcd8a-c397-48e6-aec3-63e500c01bc2.jpeg\",\"ResourceRecordKey\":\"NST7942663\",\"Order\":12,\"MediaObjectID\":\"NST12\",\"ImageWidth\":2000,\"ImageHeight\":1331,\"ImageSizeDescription\":\"2000x1331\",\"MediaModificationTimestamp\":\"2026-07-28T21:05:19.044Z\",\"MediaKey\":\"NST123891405\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7942663/6bc9f644-8340-441a-81b8-11ebcf6ef8db.jpeg\",\"ResourceRecordKey\":\"NST7942663\",\"Order\":13,\"MediaObjectID\":\"NST13\",\"ImageWidth\":2000,\"ImageHeight\":1331,\"ImageSizeDescription\":\"2000x1331\",\"MediaModificationTimestamp\":\"2026-07-28T21:05:19.04Z\",\"MediaKey\":\"NST123891404\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7942663/420bc7f1-6be0-4f9a-81bb-8265e6b43165.jpeg\",\"ResourceRecordKey\":\"NST7942663\",\"Order\":18,\"MediaObjectID\":\"NST18\",\"ImageWidth\":2000,\"ImageHeight\":1331,\"ImageSizeDescription\":\"2000x1331\",\"MediaModificationTimestamp\":\"2026-07-28T21:05:19.046Z\",\"MediaKey\":\"NST123891399\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7942663/4b97f2c0-80a6-4e98-a1e9-ae7b05b6d410.jpeg\",\"ResourceRecordKey\":\"NST7942663\",\"Order\":10,\"MediaObjectID\":\"NST10\",\"ImageWidth\":2000,\"ImageHeight\":1331,\"ImageSizeDescription\":\"2000x1331\",\"MediaModificationTimestamp\":\"2026-07-28T21:05:19.269Z\",\"MediaKey\":\"NST123891407\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7942663/a85bf275-1817-4535-9818-b5ba928a1c78.jpeg\",\"ResourceRecordKey\":\"NST7942663\",\"Order\":20,\"MediaObjectID\":\"NST20\",\"ImageWidth\":2000,\"ImageHeight\":1331,\"ImageSizeDescription\":\"2000x1331\",\"MediaModificationTimestamp\":\"2026-07-28T21:05:19.109Z\",\"MediaKey\":\"NST123891397\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7942663/068fc5e6-77b1-4f2d-af67-a0102713e0d6.jpeg\",\"ResourceRecordKey\":\"NST7942663\",\"Order\":9,\"MediaObjectID\":\"NST9\",\"ImageWidth\":2000,\"ImageHeight\":1331,\"ImageSizeDescription\":\"2000x1331\",\"MediaModificationTimestamp\":\"2026-07-28T21:05:19.044Z\",\"MediaKey\":\"NST123891408\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7942663/96c5591d-3f05-4bc1-9fd5-1bb4acd4371e.jpeg\",\"ResourceRecordKey\":\"NST7942663\",\"Order\":17,\"MediaObjectID\":\"NST17\",\"ImageWidth\":2000,\"ImageHeight\":1331,\"ImageSizeDescription\":\"2000x1331\",\"MediaModificationTimestamp\":\"2026-07-28T21:05:19.038Z\",\"MediaKey\":\"NST123891400\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7942663/18620a01-a7ee-4d75-b475-0b7cfdb9d877.jpeg\",\"ResourceRecordKey\":\"NST7942663\",\"Order\":1,\"MediaObjectID\":\"NST1\",\"ImageWidth\":2000,\"ImageHeight\":1331,\"ImageSizeDescription\":\"2000x1331\",\"MediaModificationTimestamp\":\"2026-07-28T21:05:19.047Z\",\"MediaKey\":\"NST123891385\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7942663/39c5e796-d617-4717-826c-d3606f5700c4.jpeg\",\"ResourceRecordKey\":\"NST7942663\",\"Order\":6,\"MediaObjectID\":\"NST6\",\"ImageWidth\":2000,\"ImageHeight\":1331,\"ImageSizeDescription\":\"2000x1331\",\"MediaModificationTimestamp\":\"2026-07-28T21:05:19.056Z\",\"MediaKey\":\"NST123891411\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7942663/ff46163e-ef6a-4d86-bd1f-e4c2bcaca6bb.jpeg\",\"ResourceRecordKey\":\"NST7942663\",\"Order\":4,\"MediaObjectID\":\"NST4\",\"ImageWidth\":2000,\"ImageHeight\":1331,\"ImageSizeDescription\":\"2000x1331\",\"MediaModificationTimestamp\":\"2026-07-28T21:05:19.052Z\",\"MediaKey\":\"NST123891382\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7942663/60177239-ade5-4142-ade9-ab3a283f9820.jpeg\",\"ResourceRecordKey\":\"NST7942663\",\"Order\":21,\"MediaObjectID\":\"NST21\",\"ImageWidth\":2000,\"ImageHeight\":1331,\"ImageSizeDescription\":\"2000x1331\",\"MediaModificationTimestamp\":\"2026-07-28T21:05:19.033Z\",\"MediaKey\":\"NST123891396\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7942663/c041d2f3-fcb9-4c66-b082-ca6566b212d3.jpeg\",\"ResourceRecordKey\":\"NST7942663\",\"Order\":24,\"MediaObjectID\":\"NST24\",\"ImageWidth\":2000,\"ImageHeight\":1331,\"ImageSizeDescription\":\"2000x1331\",\"MediaModificationTimestamp\":\"2026-07-28T21:05:19.058Z\",\"MediaKey\":\"NST123891393\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7942663/6c11349c-b123-40e0-a98a-4e40331bff81.jpeg\",\"ResourceRecordKey\":\"NST7942663\",\"Order\":2,\"MediaObjectID\":\"NST2\",\"ImageWidth\":2000,\"ImageHeight\":1331,\"ImageSizeDescription\":\"2000x1331\",\"MediaModificationTimestamp\":\"2026-07-28T21:05:19.07Z\",\"MediaKey\":\"NST123891384\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7942663/9da2b04d-75f7-41df-a5b7-e2caf2e2536c.jpeg\",\"ResourceRecordKey\":\"NST7942663\",\"Order\":15,\"MediaObjectID\":\"NST15\",\"ImageWidth\":2000,\"ImageHeight\":1331,\"ImageSizeDescription\":\"2000x1331\",\"MediaModificationTimestamp\":\"2026-07-28T21:05:19.038Z\",\"MediaKey\":\"NST123891402\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7942663/a69b9395-1156-4eb5-a3bd-56334bfacfa6.jpeg\",\"ResourceRecordKey\":\"NST7942663\",\"Order\":23,\"MediaObjectID\":\"NST23\",\"ImageWidth\":2000,\"ImageHeight\":1331,\"ImageSizeDescription\":\"2000x1331\",\"MediaModificationTimestamp\":\"2026-07-28T21:05:19.035Z\",\"MediaKey\":\"NST123891394\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7942663/21307108-bfa5-47d6-9c79-9ee9b42cd2c8.jpeg\",\"ResourceRecordKey\":\"NST7942663\",\"Order\":11,\"MediaObjectID\":\"NST11\",\"ImageWidth\":2000,\"ImageHeight\":1331,\"ImageSizeDescription\":\"2000x1331\",\"MediaModificationTimestamp\":\"2026-07-28T21:05:19.07Z\",\"MediaKey\":\"NST123891406\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7942663/f81064ae-08ec-4410-b02c-8172cd1be401.jpeg\",\"ResourceRecordKey\":\"NST7942663\",\"Order\":8,\"MediaObjectID\":\"NST8\",\"ImageWidth\":2000,\"ImageHeight\":1331,\"ImageSizeDescription\":\"2000x1331\",\"MediaModificationTimestamp\":\"2026-07-28T21:05:19.119Z\",\"MediaKey\":\"NST123891409\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7942663/ad9e9627-d67c-467c-b004-54c91824c68b.jpeg\",\"ResourceRecordKey\":\"NST7942663\",\"Order\":22,\"MediaObjectID\":\"NST22\",\"ImageWidth\":2000,\"ImageHeight\":1331,\"ImageSizeDescription\":\"2000x1331\",\"MediaModificationTimestamp\":\"2026-07-28T21:05:19.054Z\",\"MediaKey\":\"NST123891395\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7942663/2ef70ecd-c561-4d48-acf4-36551eb17d92.jpeg\",\"ResourceRecordKey\":\"NST7942663\",\"Order\":16,\"MediaObjectID\":\"NST16\",\"ImageWidth\":2000,\"ImageHeight\":1331,\"ImageSizeDescription\":\"2000x1331\",\"MediaModificationTimestamp\":\"2026-07-28T21:05:19.069Z\",\"MediaKey\":\"NST123891401\"}]","Media__MediaURL":"https://s3.amazonaws.com/mlsgrid/images/NST7942663/64f09dca-7031-4972-b6d6-dcc4e0e25e38.jpeg","Media__ResourceRecordKey":"NST7942663","Media__Order":"25","Media__MediaObjectID":"NST25","Media__ImageWidth":"1051","Media__ImageHeight":"817","Media__ImageSizeDescription":"1051x817","Media__MediaModificationTimestamp":"7/28/2026 9:05:19 PM","Media__MediaKey":"NST123891392","DocumentsChangeTimestamp":"2026-07-28T21:05:08.771Z","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,20,21,22,23,24,25","CustomVTourURL":""}