$LABEL$
$CONTENT$
$LABEL$
$CONTENT$
Coldwell Banker Realty is the brokerage office representing the seller for this listing.
Copyright 2019, Regional Multiple Listing Service of Minnesota, Inc. all rights reserved. Information is deemed reliable but is not guaranteed.
The data relating to real estate for sale on this site comes in part from the broker reciprocity program of the Regional multiple Listing Service of Minnesota, Inc. real estate listings held by brokerage firms other than are marked with the Broker Reciprocity logo or the Broker reciprocity house icon and detailed information about them includes the names(s) of the listing brokers. Nolan Team | Kurilla Real Estate, Ltd. is not a multiple Listing Service (MLS), nor does it offer MLS access. This website is a service of Nolan Team | Kurilla Real Estate, Ltd., a broker Participant of the Regional Multiple Listing Service of Minnesota, Inc.
Copyright 2019, Regional Multiple Listing Service of Minnesota, Inc. all rights reserved. Information is deemed reliable but is not guaranteed.
The data relating to real estate for sale on this site comes in part from the broker reciprocity program of the Regional multiple Listing Service of Minnesota, Inc. real estate listings held by brokerage firms other than are marked with the Broker Reciprocity logo or the Broker reciprocity house icon and detailed information about them includes the names(s) of the listing brokers. Nolan Team | Kurilla Real Estate, Ltd. is not a multiple Listing Service (MLS), nor does it offer MLS access. This website is a service of Nolan Team | Kurilla Real Estate, Ltd., a broker Participant of the Regional Multiple Listing Service of Minnesota, Inc.
Nearby Listings in 10 Miles
{"Id":1432464,"ORGTABLE":"RAW_Property","MLSCLASS":"COM","MLSNUMBER":"NST6443295","MLSAGENTID":"NST506000189","MLSOFFICEID":"NST8237","ADDRESS":"2047 Grand Avenue","ACRES":0.17,"AGENTOWNER":false,"AUCTIONYN":false,"CITY":"Saint Paul","CONTINGENCY":"None","COUNTY":"Ramsey","CURRENTUSE":"Professional Service,Residential","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Other","FORECLOSURE":"No","LASTPRICE":625000.0,"LASTPRICEDATE":"2025-11-17T16:11:04.563","LATITUDE":44.940423,"LENDEROWNED":"No","LISTDATE":"2023-10-04T05:00:00","LISTPRICE":625000.0,"LIVINGAREA":3452.0,"LONGITUDE":-93.186764,"LOTDESCRIPTION":"Public Transit (w/in 6 blks),Many Trees","MODIFICATIONTIMESTAMP":"2025-11-17T16:11:04.562","NEIGHBORHOOD":"Macalester-Groveland","OFFICE_OFFICENAME":"Coldwell Banker Realty","PHOTOCOUNT":9,"POSTALCODE":"55105","POTENTIALSHORTSALE":"No","PUBLICREMARKS":"Fabulous opportunity for owner occupant or investor on St. Paul's Grand Avenue. \"Turn key\" hair salon and 3 rental units - one 3-story, 3 BR with sunroom; one 1 BR, and a lower level efficency. Over sized 2+ car garage with second level off rear of building and eight off street parking spaces. A short walk to the river and a short block to University of St. Thomas.","ROADBETWEENWATERFRONTANDHOMEYN":false,"SALEINCLUDES":"Building,Leases,Rental License","SCHOOLDISTRICTNUMBER":"625-St. Paul","SCHOOLDISTRICTPHONE":"651-767-8100","SEWER":"City Sewer/Connected,City Sewer - In Street","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2025-11-17T16:11:04.563","LASTSTATUS":"Active","STREETNAME":"Grand","STREETNUMBER":"2047","STREETSUFFIX":"Avenue","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected,City Water - In Street","WATERFRONTPRESENT":false,"YEARBUILT":1924,"ZONING":"Business/Commercial,Residential-Multi-Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2024-01-31T05:42:11.266","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"thumbnail_IMG_1093.jpg\"},{\"Order\":2,\"Remarks\":\"thumbnail_IMG_1094.jpg\"},{\"Order\":3,\"Remarks\":\"thumbnail_IMG_1095.jpg\"},{\"Order\":4,\"Remarks\":\"thumbnail_IMG_1105.jpg\"},{\"Order\":5,\"Remarks\":\"thumbnail_IMG_1106.jpg\"},{\"Order\":6,\"Remarks\":\"thumbnail_IMG_1107.jpg\"},{\"Order\":7,\"Remarks\":\"thumbnail_IMG_1118.jpg\"},{\"Order\":8,\"Remarks\":\"thumbnail_IMG_1099.jpg\"},{\"Order\":9,\"Remarks\":\"thumbnail_IMG_1100.jpg\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9","SOURCE":"MG_NST"}
{"ListingKey":"NST7292259","LotSizeArea":"0.17","NST_AgeOfProperty":"101","NST_AgentOwner":"No","InternetAutomatedValuationDisplayYN":"False","InternetConsumerCommentYN":"False","AssociationAmenities":"Deck","NST_AmenitiesUnit":"Deck","Appliances":"Dryer,Gas Water Heater,Range,Refrigerator,Washer","NST_AssessmentPending":"Unknown","NST_AttributionContact":"651-334-3659","NST_AttributionName":"Gary Fabel, GRI","BasementYN":"True","City":"Saint Paul","PropertyType":"Commercial Sale","Contingency":"None","Cooling":"Window Unit(s)","CountyOrParish":"Ramsey","CurrentUse":"Professional Service,Residential","DaysOnMarket":"767","CumulativeDaysOnMarket":"767","Directions":"On Grand Ave just East of Cleveland","InternetAddressDisplayYN":"True","InternetEntireListingDisplayYN":"True","ConstructionMaterials":"Other","NST_ForeclosureStatus":"No","FoundationArea":"1112","NST_FractionalOwnershipYN":"No","RoadFrontageType":"City Street,Curbs,Paved Streets,Sidewalks,Street Lights,Storm Sewer","NST_Fuel":"Natural Gas","ParkingFeatures":"Assigned,Detached,Asphalt,Guest Parking,Parking Garage,Paved,Units Vary","NST_GarageSquareFeet":"576","AccessibilityFeatures":"None","Heating":"Boiler","OriginalEntryTimestamp":"2023-10-04T17:44:05Z","LandLeaseYN":"False","NST_LastUpdateDate":"2025-11-17","Latitude":"44.940423","NST_LenderOwned":"No","ListAgentKey":"NST59695","ListAgentMlsId":"NST506000189","ListingContractDate":"2023-10-04T05:00:00Z","ListOfficeKey":"NST16731","ListOfficeName":"Coldwell Banker Realty","ListOfficeMlsId":"NST8237","ListPrice":"625000","Longitude":"-93.186764","LotFeatures":"Public Transit (w/in 6 blks),Many Trees","LotSizeDimensions":"50x150","LotSizeUnits":"Acres","ListingId":"NST6443295","SourceSystemName":"RMLS","MapCoordinateSource":"King's Street Atlas","AdditionalParcelsYN":"False","NST_NeighborhoodNumber":"Macalester-Groveland","NST_OfficeBoard":"SPAAR","NST_OwnerOccupied":"No","OwnerPays":"Electricity,Fuel,Insurance,Grounds Care,Repairs,Snow Removal,Taxes","ParcelNumber":"042823320021","GarageSpaces":"2","NST_ParkingOpen":"8","NST_PatioPorchType":"Deck","PhotosCount":"9","PostalCity":"Saint Paul","PostalCode":"55105","NST_PotentialShortSale":"No","PublicRemarks":"Fabulous opportunity for owner occupant or investor on St. Paul's Grand Avenue. \"Turn key\" hair salon and 3 rental units - one 3-story, 3 BR with sunroom; one 1 BR, and a lower level efficency. Over sized 2+ car garage with second level off rear of building and eight off street parking spaces. A short walk to the river and a short block to University of St. Thomas.","PublicSurveyRange":"23","PublicSurveySection":"04","PublicSurveyTownship":"28","NST_RangeNum":"Three","NST_RefrigeratorNum":"Three","NST_RentalLicenseType":"Standard,Other","NST_RentalLicenseYN":"Yes","RoadResponsibility":"Public Maintained Road","Inclusions":"Building,Leases,Rental License","HighSchoolDistrict":"St. Paul","NST_SchoolDistrictNumber":"625","NST_SchoolDistrictPhone":"651-767-8100","Sewer":"City Sewer/Connected,City Sewer - In Street","BuildingAreaTotal":"3452","StateOrProvince":"MN","StandardStatus":"Active","Levels":"Three Or More","StreetName":"Grand","StreetNumber":"2047","StreetNumberNumeric":"2047","StreetSuffix":"Avenue","SubdivisionName":"Rosedale Park","NST_TaxWithAssessments":"9886.0000","TaxYear":"2023","TaxAnnualAmount":"9886","TenantPays":"Trash Collection","Topography":"Level","NumberOfUnitsTotal":"4","Utilities":"Electric Separate,Heating Common,Hot Water Common","WaterSource":"City Water/Connected,City Water - In Street","YearBuilt":"1924","ZoningDescription":"Business/Commercial,Residential-Multi-Family","CarportSpaces":"0","ModificationTimestamp":"2025-11-17T16:11:04.562Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7292259\",\"Order\":1,\"MediaObjectID\":\"1\",\"LongDescription\":\"thumbnail_IMG_1093.jpg\",\"ImageWidth\":240,\"ImageHeight\":320,\"ImageSizeDescription\":\"240x320\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7292259/8d3acba9-234c-4eae-ac21-b02ccedcab7d.jpeg\",\"MediaModificationTimestamp\":\"2023-10-06T02:07:49.888Z\",\"MediaKey\":\"651f6bf5f851082cdfa47e2e\"},{\"ResourceRecordKey\":\"NST7292259\",\"Order\":2,\"MediaObjectID\":\"2\",\"LongDescription\":\"thumbnail_IMG_1094.jpg\",\"ImageWidth\":240,\"ImageHeight\":320,\"ImageSizeDescription\":\"240x320\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7292259/997957d4-7a67-40b0-8ba8-3c01a396ba0d.jpeg\",\"MediaModificationTimestamp\":\"2023-10-05T20:21:32.636Z\",\"MediaKey\":\"651f1acc0f6066513c8c8153\"},{\"ResourceRecordKey\":\"NST7292259\",\"Order\":3,\"MediaObjectID\":\"3\",\"LongDescription\":\"thumbnail_IMG_1095.jpg\",\"ImageWidth\":360,\"ImageHeight\":480,\"ImageSizeDescription\":\"360x480\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7292259/1080cb0d-c87d-479b-b9c5-381a266129c9.jpeg\",\"MediaModificationTimestamp\":\"2023-10-06T02:07:49.781Z\",\"MediaKey\":\"651f6bf5f851082cdfa47e2f\"},{\"ResourceRecordKey\":\"NST7292259\",\"Order\":4,\"MediaObjectID\":\"4\",\"LongDescription\":\"thumbnail_IMG_1105.jpg\",\"ImageWidth\":480,\"ImageHeight\":640,\"ImageSizeDescription\":\"480x640\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7292259/895f30e4-d859-417d-8ad0-2c42f1057834.jpeg\",\"MediaModificationTimestamp\":\"2023-10-06T02:07:49.868Z\",\"MediaKey\":\"651f6bf5f851082cdfa47e30\"},{\"ResourceRecordKey\":\"NST7292259\",\"Order\":5,\"MediaObjectID\":\"5\",\"LongDescription\":\"thumbnail_IMG_1106.jpg\",\"ImageWidth\":360,\"ImageHeight\":480,\"ImageSizeDescription\":\"360x480\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7292259/6f048f85-69cd-46ef-b3bc-113e37f761e4.jpeg\",\"MediaModificationTimestamp\":\"2023-10-06T02:07:49.831Z\",\"MediaKey\":\"651f6bf5f851082cdfa47e31\"},{\"ResourceRecordKey\":\"NST7292259\",\"Order\":6,\"MediaObjectID\":\"6\",\"LongDescription\":\"thumbnail_IMG_1107.jpg\",\"ImageWidth\":480,\"ImageHeight\":640,\"ImageSizeDescription\":\"480x640\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7292259/4bd18bf6-5206-4739-aa4a-18251b5fd4d2.jpeg\",\"MediaModificationTimestamp\":\"2023-10-06T02:07:49.878Z\",\"MediaKey\":\"651f6bf5f851082cdfa47e32\"},{\"ResourceRecordKey\":\"NST7292259\",\"Order\":7,\"MediaObjectID\":\"7\",\"LongDescription\":\"thumbnail_IMG_1118.jpg\",\"ImageWidth\":360,\"ImageHeight\":480,\"ImageSizeDescription\":\"360x480\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7292259/789c4883-084d-4792-84b1-3a2b4014edc8.jpeg\",\"MediaModificationTimestamp\":\"2023-10-06T02:07:49.855Z\",\"MediaKey\":\"651f6bf5f851082cdfa47e33\"},{\"ResourceRecordKey\":\"NST7292259\",\"Order\":8,\"MediaObjectID\":\"8\",\"LongDescription\":\"thumbnail_IMG_1099.jpg\",\"ImageWidth\":240,\"ImageHeight\":320,\"ImageSizeDescription\":\"240x320\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7292259/4ee698db-a5a8-4a9f-a7ca-26ce62776b1f.jpeg\",\"MediaModificationTimestamp\":\"2023-10-05T20:21:32.63Z\",\"MediaKey\":\"651f1acc0f6066513c8c8159\"},{\"ResourceRecordKey\":\"NST7292259\",\"Order\":9,\"MediaObjectID\":\"9\",\"LongDescription\":\"thumbnail_IMG_1100.jpg\",\"ImageWidth\":240,\"ImageHeight\":320,\"ImageSizeDescription\":\"240x320\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7292259/728f99ce-981e-4460-8d3e-480c3397ef8d.jpeg\",\"MediaModificationTimestamp\":\"2023-10-05T20:21:32.591Z\",\"MediaKey\":\"651f1acc0f6066513c8c815a\"}]","PhotosChangeTimestamp":"2024-01-31T05:42:11.266Z","UnitTypes":"[{\"UnitTypeKey\":\"NST12625\",\"NST_LeaseExpirationDt\":\"2024-05-31\",\"NST_UnitLevel\":\"MULTI\",\"UnitTypeActualRent\":1695,\"UnitTypeBathsTotal\":0,\"NST_UnitRoomsTotal\":\"3\",\"NST_UnitID\":\"1\",\"NST_UnitNumber\":\"1\",\"NST_UnitIsLeased\":\"1\"},{\"UnitTypeKey\":\"NST12626\",\"NST_LeaseExpirationDt\":\"2024-04-30\",\"NST_UnitLevel\":\"MAIN\",\"UnitTypeActualRent\":1345,\"UnitTypeBathsTotal\":0,\"NST_UnitID\":\"2\",\"NST_UnitNumber\":\"2\",\"NST_UnitIsLeased\":\"1\"},{\"UnitTypeKey\":\"NST12627\",\"UnitTypeActualRent\":990,\"UnitTypeBathsTotal\":0,\"NST_UnitID\":\"3\",\"NST_UnitNumber\":\"3\",\"NST_UnitIsLeased\":\"0\"},{\"UnitTypeKey\":\"NST12628\",\"NST_LeaseExpirationDt\":\"2024-10-31\",\"UnitTypeActualRent\":845,\"UnitTypeBathsTotal\":0,\"NST_UnitID\":\"4\",\"NST_UnitNumber\":\"4\",\"NST_UnitIsLeased\":\"1\"}]","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"thumbnail_IMG_1093.jpg\"},{\"Order\":2,\"Remarks\":\"thumbnail_IMG_1094.jpg\"},{\"Order\":3,\"Remarks\":\"thumbnail_IMG_1095.jpg\"},{\"Order\":4,\"Remarks\":\"thumbnail_IMG_1105.jpg\"},{\"Order\":5,\"Remarks\":\"thumbnail_IMG_1106.jpg\"},{\"Order\":6,\"Remarks\":\"thumbnail_IMG_1107.jpg\"},{\"Order\":7,\"Remarks\":\"thumbnail_IMG_1118.jpg\"},{\"Order\":8,\"Remarks\":\"thumbnail_IMG_1099.jpg\"},{\"Order\":9,\"Remarks\":\"thumbnail_IMG_1100.jpg\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9","CustomVTourURL":""}