« go back
    • Home
    • Our Agents
    • Our Listings
    • Testimonials
  • Estimate Request
  • Map Search
    • Daily Hotlist
    • Advanced Search
    • Featured Listings
    • Open Houses
    • Our Listings
    • Lost Lake Lodge
    • Good Ol' Days Resort
  • Contact Us
    • Client Login
    • Saved Listings

MLS# NST6443295 - 2047 Grand Avenue Saint Paul, MN 55105

Neighborhoods

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. Lakeshore Properties, LLC is not a multiple Listing Service (MLS), nor does it offer MLS access. This website is a service of Lakeshore Properties, LLC, a broker Participant of the Regional Multiple Listing Service of Minnesota, Inc.

{"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":""}
  • Phone
  • Email
©2025 Lakeshore Properties LLC, all rights reserved. · Privacy ·
Created with REC by Shawn Hyde.