{"Id":1413018,"ORGTABLE":"RAW_Property","MLSCLASS":"COM","MLSNUMBER":"NST6794343","MLSAGENTID":"NST502050061","MLSCOAGENTID":"NST502212089","MLSOFFICEID":"NST5478","ADDRESS":"1033 Grand Avenue","ACRES":0.19,"AGENTOWNER":false,"AUCTIONYN":false,"CITY":"Saint Paul","CONTINGENCY":"None","COUNTY":"Ramsey","CURRENTUSE":"Professional/Office,Commercial,Office,Professional Service","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Wood Siding","FORECLOSURE":"No","LASTPRICE":866000.0,"LASTPRICEDATE":"2025-09-24T20:51:03.777","LATITUDE":44.940301,"LENDEROWNED":"No","LISTDATE":"2025-09-24T05:00:00","LISTPRICE":866000.0,"LIVINGAREA":3146.0,"LONGITUDE":-93.143659,"MODIFICATIONTIMESTAMP":"2025-09-25T02:07:05.522","NEIGHBORHOOD":"Summit Hill","OFFICE_OFFICENAME":"Coldwell Banker Realty","PHOTOCOUNT":1,"POSTALCODE":"55105","POTENTIALSHORTSALE":"No","PUBLICREMARKS":"High Visibility Grand Avenue Office. Stunning historic mansion at 1904 Grand Avenue offering a rare opportunity in one of the city's most coveted commercial corridors. Currently utilized as a medical office, this impressive 3,146 sq ft property spans four finished levels including a walkout basement, and is ideally positioned in a high-traffic, high visibilitiy location. The flexible layout features 6+ private office, multiple storage areas, dedicated meeting rooms and generous common spaces, making it a well-suited for professional offices, medical practices, or creative commercial uses. Don't miss out on this one. Call our listed agents today to schedule a property tour","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Asphalt","SALEINCLUDES":"Building,Land","SCHOOLDISTRICTNUMBER":"625-St. Paul","SCHOOLDISTRICTPHONE":"651-767-8100","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2025-09-24T20:51:03.777","LASTSTATUS":"Active","STREETNAME":"Grand","STREETNUMBER":"1033","STREETSUFFIX":"Avenue","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1904,"ZONING":"Business/Commercial","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2025-09-25T02:07:05.522","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"1033 Grand Ave Commercial For Sale thumbnail_IMG_2547.jpg\"}]","PHOTOORDER":"1","SOURCE":"MG_NST"}
{"ListingKey":"NST7807237","LotSizeArea":"0.19","NST_AgeOfProperty":"121","NST_AgentOwner":"No","InternetAutomatedValuationDisplayYN":"False","InternetConsumerCommentYN":"False","NST_AssessmentPending":"No","NST_AttributionContact":"651-341-8196","NST_AttributionName":"Allan Zolin","BasementYN":"True","City":"Saint Paul","PropertyType":"Commercial Sale","Contingency":"None","CountyOrParish":"Ramsey","CurrentUse":"Professional/Office,Commercial,Office,Professional Service","Directions":"1 Block East of Lexington on North side of Grand Avenue","InternetAddressDisplayYN":"True","InternetEntireListingDisplayYN":"True","ConstructionMaterials":"Wood Siding","NST_ForeclosureStatus":"No","NST_FoundationDimensions":"1000","FoundationArea":"1000","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","ParkingFeatures":"Paved","NST_GarageSquareFeet":"0","AccessibilityFeatures":"None","Heating":"Forced Air,Hot Water","OriginalEntryTimestamp":"2025-09-24T20:47:45Z","LandLeaseYN":"False","NST_LastUpdateDate":"2025-09-24","Latitude":"44.940301","NST_LenderOwned":"No","ListAgentKey":"NST226544","ListAgentMlsId":"NST502050061","CoListAgentKey":"NST213381","CoListAgentMlsId":"NST502212089","ListingContractDate":"2025-09-24T05:00:00Z","ListOfficeKey":"NST16056","ListOfficeName":"Coldwell Banker Realty","ListOfficeMlsId":"NST5478","ListPrice":"866000","LockBoxType":"None","Longitude":"-93.143659","LotSizeDimensions":"55x150","LotSizeUnits":"Square Feet","ListingId":"NST6794343","SourceSystemName":"RMLS","MapCoordinateSource":"King's Street Atlas","AdditionalParcelsYN":"False","NST_NeighborhoodNumber":"Summit Hill","NST_OfficeBoard":"SCAAR","ParcelNumber":"022823320007","GarageSpaces":"0","NST_ParkingOpen":"3","PhotosCount":"1","PostalCity":"Saint Paul","PostalCode":"55105","NST_PotentialShortSale":"No","PossibleUse":"Office,Professional Service,Retail,Medical","PublicRemarks":"High Visibility Grand Avenue Office. Stunning historic mansion at 1904 Grand Avenue offering a rare opportunity in one of the city's most coveted commercial corridors. Currently utilized as a medical office, this impressive 3,146 sq ft property spans four finished levels including a walkout basement, and is ideally positioned in a high-traffic, high visibilitiy location. The flexible layout features 6+ private office, multiple storage areas, dedicated meeting rooms and generous common spaces, making it a well-suited for professional offices, medical practices, or creative commercial uses. Don't miss out on this one. Call our listed agents today to schedule a property tour","PublicSurveyRange":"23","PublicSurveySection":"02","PublicSurveyTownship":"28","NST_RentalLicenseYN":"No","Roof":"Asphalt","Inclusions":"Building,Land","HighSchoolDistrict":"St. Paul","NST_SchoolDistrictNumber":"625","NST_SchoolDistrictPhone":"651-767-8100","Sewer":"City Sewer/Connected","BuildingAreaTotal":"3146","StateOrProvince":"MN","StandardStatus":"Active","Levels":"Three Or More","StreetName":"Grand","StreetNumber":"1033","StreetNumberNumeric":"1033","StreetSuffix":"Avenue","NST_TaxWithAssessments":"28158.0000","TaxYear":"2025","TaxAnnualAmount":"28158","NumberOfUnitsTotal":"1","Utilities":"Electric Common","WaterSource":"City Water/Connected","YearBuilt":"1904","ZoningDescription":"Business/Commercial","ModificationTimestamp":"2025-09-25T02:07:05.522Z","PhotosChangeTimestamp":"2025-09-25T02:07:05.522Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7807237\",\"Order\":1,\"MediaObjectID\":\"1\",\"LongDescription\":\"1033 Grand Ave Commercial For Sale thumbnail_IMG_2547.jpg\",\"ImageWidth\":1920,\"ImageHeight\":1440,\"ImageSizeDescription\":\"1920x1440\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7807237/cd4a7d57-e585-4278-8845-557541922f63.jpeg\",\"MediaModificationTimestamp\":\"2025-09-25T02:06:27.762Z\",\"MediaKey\":\"68d4a3a3f18973609c53d69c\"}]","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"1033 Grand Ave Commercial For Sale thumbnail_IMG_2547.jpg\"}]","PhotoOrder":"1","CustomVTourURL":""}