A TRADITION OF TRUST & SERVICE
$LABEL$
$CONTENT$
$LABEL$
$CONTENT$
Mortgage Calculator

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. Joy+Marci Realty Group is not a multiple Listing Service (MLS), nor does it offer MLS access. This website is a service of Joy+Marci Realty Group, 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. Joy+Marci Realty Group is not a multiple Listing Service (MLS), nor does it offer MLS access. This website is a service of Joy+Marci Realty Group, a broker Participant of the Regional Multiple Listing Service of Minnesota, Inc.
Nearby Listings in 10 Miles
{"Id":1383219,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST6756085","MLSAGENTID":"NST506000189","MLSOFFICEID":"NST8237","ADDRESS":"2047 Grand Avenue","ACRES":0.17,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Daylight/Lookout Windows,Egress Window(s),Finished,Full,Storage/Locker,Storage Space","CITY":"Saint Paul","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Other","FORECLOSURE":"No","LASTPRICE":625000.0,"LASTPRICEDATE":"2025-07-16T15:37:04.293","LATITUDE":44.940423,"LENDEROWNED":"No","LISTDATE":"2025-07-16T05:00:00","LISTPRICE":625000.0,"LIVINGAREA":3920.0,"LONGITUDE":-93.186764,"LOTDESCRIPTION":"Public Transit (w/in 6 blks),Many Trees","MODIFICATIONTIMESTAMP":"2025-07-17T10:06:06.316","NEIGHBORHOOD":"Macalester-Groveland","OFFICE_OFFICENAME":"Coldwell Banker Realty","PHOTOCOUNT":9,"POSTALCODE":"55105","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","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 2-story, 1 BR; and a lower-level efficiency. Oversized 2+ car garage with upper/loft level offers extra possibilities. Eight (8) off-street parking spaces features newly asphalted. A short walk to the river, Davanni’s, Grandview Theater, and only a block to the University of St. Thomas.","ROADBETWEENWATERFRONTANDHOMEYN":false,"SCHOOLDISTRICTNUMBER":"625-St. Paul","SCHOOLDISTRICTPHONE":"651-767-8100","SEWER":"City Sewer/Connected,City Sewer - In Street","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2025-07-16T15:37:04.293","LASTSTATUS":"Active","STREETNAME":"Grand Avenue","STREETNUMBER":"2047","STYLE":"Quadruplex","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected,City Water - In Street","WATERFRONTPRESENT":false,"YEARBUILT":1924,"ZONING":"Residential-Multi-Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2025-07-17T02:05:04.336","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":"NST7773930","LotSizeArea":"0.17","NST_AgeOfProperty":"101","NST_AgentOwner":"No","InternetAutomatedValuationDisplayYN":"False","InternetConsumerCommentYN":"False","AssociationAmenities":"Laundry,Deck","NST_AssessmentPending":"Unknown","NST_AttributionContact":"651-334-3659","NST_AttributionName":"Gary Fabel, GRI","Basement":"Daylight/Lookout Windows,Egress Window(s),Finished,Full,Storage/Locker,Storage Space","BasementYN":"True","CarportSpaces":"8","City":"Saint Paul","PropertyType":"Residential Income","NST_ConstructionMaterialsDesc":"Block","NewConstructionYN":"False","Contingency":"None","CountyOrParish":"Ramsey","NST_DPResource":"Y","DaysOnMarket":"1","CumulativeDaysOnMarket":"1","Directions":"On Grand Avenue, east of Cleveland Avenue","InternetAddressDisplayYN":"True","InternetEntireListingDisplayYN":"True","ManagerExpense":"0","ElectricExpense":"0","FuelExpense":"0","InsuranceExpense":"0","MaintenanceExpense":"0","OtherExpense":"0","OperatingExpense":"0","TrashExpense":"0","WaterSewerExpense":"0","NST_Expenses":"0.0000","ConstructionMaterials":"Other","NST_ForeclosureStatus":"No","FoundationArea":"1112","NST_FractionalOwnershipYN":"No","RoadFrontageType":"City Street,Curbs,Paved Streets,Sidewalks,Street Lights","NST_Fuel":"Natural Gas","ParkingFeatures":"Assigned,Detached,Asphalt,Guest Parking,Paved,Units Vary","NST_GarageSquareFeet":"576","GrossIncome":"0","AccessibilityFeatures":"Grab Bars In Bathroom","Heating":"Boiler","OriginalEntryTimestamp":"2025-07-16T15:35:20Z","LandLeaseYN":"False","NST_LastUpdateDate":"2025-07-17","Latitude":"44.940423","NST_LenderOwned":"No","ListAgentKey":"NST59695","ListAgentMlsId":"NST506000189","ListingContractDate":"2025-07-16T05:00:00Z","ListOfficeKey":"NST16731","ListOfficeName":"Coldwell Banker Realty","ListOfficeMlsId":"NST8237","ListPrice":"625000","LivingArea":"3920","Longitude":"-93.186764","LotFeatures":"Public Transit (w/in 6 blks),Many Trees","LotSizeDimensions":"50x150","LotSizeUnits":"Acres","ListingId":"NST6756085","SourceSystemName":"RMLS","MapCoordinateSource":"King's Street Atlas","AdditionalParcelsYN":"False","NST_NeighborhoodNumber":"Macalester-Groveland","NST_OfficeBoard":"SPAAR","NST_OwnerOccupied":"No","OwnerPays":"Fuel,Insurance,Repairs,Taxes","ParcelNumber":"TBD","GarageSpaces":"2","PhotosCount":"9","PostalCity":"Saint Paul","PostalCode":"55105","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","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 2-story, 1 BR; and a lower-level efficiency. Oversized 2+ car garage with upper/loft level offers extra possibilities. Eight (8) off-street parking spaces features newly asphalted. A short walk to the river, Davanni’s, Grandview Theater, and only a block to the University of St. Thomas.","PublicSurveyRange":"23","PublicSurveySection":"04","PublicSurveyTownship":"28","NST_RangeNum":"Three","NST_RefrigeratorNum":"Three","NST_RentalLicenseType":"Other","NST_RentalLicenseYN":"Yes","RoadResponsibility":"Public Maintained Road","NST_AboveGradeSqFtTotal":"3452.0000","NST_BelowGradeSqFtTotal":"1112.0000","NST_MainLevelFinishedArea":"1112.0000","BuildingAreaTotal":"4564","HighSchoolDistrict":"St. Paul","NST_SchoolDistrictNumber":"625","NST_SchoolDistrictPhone":"651-767-8100","Sewer":"City Sewer/Connected,City Sewer - In Street","AboveGradeFinishedArea":"3452","BelowGradeFinishedArea":"468","StateOrProvince":"MN","StandardStatus":"Active","Levels":"More Than 2 Stories","StreetName":"Grand Avenue","StreetNumber":"2047","StreetNumberNumeric":"2047","PropertySubType":"Quadruplex","SubdivisionName":"Rosedale Park","NST_TaxWithAssessments":"9554.0000","TaxYear":"2023","TaxAnnualAmount":"9554","TenantPays":"Electricity,Trash Collection","Topography":"Level","NumberOfUnitsTotal":"4","WaterSource":"City Water/Connected,City Water - In Street","YearBuilt":"1924","ZoningDescription":"Residential-Multi-Family","ModificationTimestamp":"2025-07-17T10:06:06.316Z","PhotosChangeTimestamp":"2025-07-17T02:05:04.336Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7773930\",\"Order\":1,\"MediaObjectID\":\"1\",\"LongDescription\":\"thumbnail_IMG_1093.jpg\",\"ImageWidth\":240,\"ImageHeight\":320,\"ImageSizeDescription\":\"240x320\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7773930/ddae5d58-43cb-4f51-981f-3f19a71caff0.jpeg\",\"MediaModificationTimestamp\":\"2025-07-16T15:36:26.621Z\",\"MediaKey\":\"6877c6fad2a6b67db83f839e\"},{\"ResourceRecordKey\":\"NST7773930\",\"Order\":2,\"MediaObjectID\":\"2\",\"LongDescription\":\"thumbnail_IMG_1094.jpg\",\"ImageWidth\":240,\"ImageHeight\":320,\"ImageSizeDescription\":\"240x320\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7773930/427917e0-b66f-4332-90b5-e22ad2cc2de9.jpeg\",\"MediaModificationTimestamp\":\"2025-07-16T15:36:26.646Z\",\"MediaKey\":\"6877c6fad2a6b67db83f839f\"},{\"ResourceRecordKey\":\"NST7773930\",\"Order\":3,\"MediaObjectID\":\"3\",\"LongDescription\":\"thumbnail_IMG_1095.jpg\",\"ImageWidth\":360,\"ImageHeight\":480,\"ImageSizeDescription\":\"360x480\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7773930/d57ba92f-f9b2-4ce2-85b1-5c8bb4e4df14.jpeg\",\"MediaModificationTimestamp\":\"2025-07-17T02:04:17.77Z\",\"MediaKey\":\"68785a2118bfd959b665e8f7\"},{\"ResourceRecordKey\":\"NST7773930\",\"Order\":4,\"MediaObjectID\":\"4\",\"LongDescription\":\"thumbnail_IMG_1105.jpg\",\"ImageWidth\":480,\"ImageHeight\":640,\"ImageSizeDescription\":\"480x640\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7773930/74540dab-1c6e-4fc5-bcc8-4c837d070c78.jpeg\",\"MediaModificationTimestamp\":\"2025-07-16T15:36:26.68Z\",\"MediaKey\":\"6877c6fad2a6b67db83f83a1\"},{\"ResourceRecordKey\":\"NST7773930\",\"Order\":5,\"MediaObjectID\":\"5\",\"LongDescription\":\"thumbnail_IMG_1106.jpg\",\"ImageWidth\":360,\"ImageHeight\":480,\"ImageSizeDescription\":\"360x480\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7773930/7dc07ed6-727e-4cd9-b689-6937f03e289b.jpeg\",\"MediaModificationTimestamp\":\"2025-07-17T02:04:17.758Z\",\"MediaKey\":\"68785a2118bfd959b665e8f8\"},{\"ResourceRecordKey\":\"NST7773930\",\"Order\":6,\"MediaObjectID\":\"6\",\"LongDescription\":\"thumbnail_IMG_1107.jpg\",\"ImageWidth\":480,\"ImageHeight\":640,\"ImageSizeDescription\":\"480x640\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7773930/c0f16156-d04c-46f1-8b2d-dfbc93e73fc8.jpeg\",\"MediaModificationTimestamp\":\"2025-07-17T02:04:17.771Z\",\"MediaKey\":\"68785a2118bfd959b665e8f9\"},{\"ResourceRecordKey\":\"NST7773930\",\"Order\":7,\"MediaObjectID\":\"7\",\"LongDescription\":\"thumbnail_IMG_1118.jpg\",\"ImageWidth\":360,\"ImageHeight\":480,\"ImageSizeDescription\":\"360x480\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7773930/c47007d6-82bb-44b0-81d3-ce85dcbadc6d.jpeg\",\"MediaModificationTimestamp\":\"2025-07-17T02:04:17.763Z\",\"MediaKey\":\"68785a2118bfd959b665e8fa\"},{\"ResourceRecordKey\":\"NST7773930\",\"Order\":8,\"MediaObjectID\":\"8\",\"LongDescription\":\"thumbnail_IMG_1099.jpg\",\"ImageWidth\":240,\"ImageHeight\":320,\"ImageSizeDescription\":\"240x320\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7773930/5b81ac28-3624-4406-b77b-aee1008d3329.jpeg\",\"MediaModificationTimestamp\":\"2025-07-16T15:36:26.648Z\",\"MediaKey\":\"6877c6fad2a6b67db83f83a5\"},{\"ResourceRecordKey\":\"NST7773930\",\"Order\":9,\"MediaObjectID\":\"9\",\"LongDescription\":\"thumbnail_IMG_1100.jpg\",\"ImageWidth\":240,\"ImageHeight\":320,\"ImageSizeDescription\":\"240x320\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7773930/e5692196-4c7a-4c02-b2ed-343574d697a4.jpeg\",\"MediaModificationTimestamp\":\"2025-07-16T15:36:26.683Z\",\"MediaKey\":\"6877c6fad2a6b67db83f83a6\"}]","UnitTypes":"[{\"UnitTypeKey\":\"NST154814\",\"NST_UnitAmenities\":\"Deck\",\"UnitTypeTotalRent\":20340,\"NST_UnitAppl\":\"Range\",\"NST_Bedroom1RoomLevel\":\"Main (Ground)\",\"NST_Bedroom2RoomLevel\":\"Main (Ground)\",\"NST_Bedroom3RoomLevel\":\"Main (Ground)\",\"NST_Bedroom4RoomLevel\":\"Upper\",\"NST_UnitBath3Qtr\":\"0\",\"NST_BathDescription\":\"Upper Level Full Bath\",\"NST_UnitBathFull\":\"1\",\"NST_UnitBathHalf\":\"0\",\"NST_UnitBathQtr\":\"0\",\"UnitTypeBathsTotal\":1,\"UnitTypeBedsTotal\":3,\"NST_DiningRoomRoomLevel\":\"Third\",\"NST_MonthlyExpenses\":\"0.00\",\"NST_FamilyRoomRoomLevel\":\"Main (Ground)\",\"NST_UnitFireplaceLocation\":\"Decorative\",\"NST_UnitFireplaceNum\":\"1\",\"NST_UnitID\":\"1\",\"NST_KitchenRoomLevel\":\"Upper\",\"NST_LeaseExpirationDt\":\"2024-05-31\",\"UnitTypeActualRent\":0,\"UnitTypeUnitsTotal\":1,\"NST_UnitRoomsTotal\":\"8\",\"NST_UnitSqFt\":\"1800\"},{\"UnitTypeKey\":\"NST154815\",\"NST_UnitAmenities\":\"Deck\",\"UnitTypeTotalRent\":15600,\"NST_UnitAppl\":\"Range\",\"NST_UnitBath3Qtr\":\"0\",\"NST_BathDescription\":\"Main Floor 1/2 Bath\",\"NST_UnitBathFull\":\"0\",\"NST_UnitBathHalf\":\"1\",\"NST_UnitBathQtr\":\"0\",\"UnitTypeBathsTotal\":1,\"UnitTypeBedsTotal\":0,\"NST_MonthlyExpenses\":\"0.00\",\"NST_UnitFireplaceLocation\":\"Decorative\",\"NST_UnitFireplaceNum\":\"1\",\"NST_UnitID\":\"2\",\"NST_LeaseExpirationDt\":\"2024-04-30\",\"UnitTypeActualRent\":0,\"UnitTypeUnitsTotal\":1,\"NST_UnitParking\":\"3\",\"NST_UnitRoomsTotal\":\"5\",\"NST_UnitSqFt\":\"655\"},{\"UnitTypeKey\":\"NST154816\",\"UnitTypeTotalRent\":11328,\"NST_UnitAppl\":\"Range\",\"NST_Bedroom1RoomLevel\":\"Main (Ground)\",\"NST_Bedroom2RoomLevel\":\"Main (Ground)\",\"NST_Bedroom3RoomLevel\":\"Upper\",\"NST_UnitBath3Qtr\":\"0\",\"NST_BathDescription\":\"Upper Level Full Bath\",\"NST_UnitBathFull\":\"1\",\"NST_UnitBathHalf\":\"0\",\"NST_UnitBathQtr\":\"0\",\"UnitTypeBathsTotal\":1,\"UnitTypeBedsTotal\":1,\"NST_MonthlyExpenses\":\"0.00\",\"NST_UnitID\":\"3\",\"UnitTypeActualRent\":0,\"UnitTypeUnitsTotal\":1,\"NST_UnitRoomsTotal\":\"4\",\"NST_UnitSqFt\":\"900\"},{\"UnitTypeKey\":\"NST154817\",\"UnitTypeTotalRent\":10440,\"NST_UnitAppl\":\"Range\",\"NST_UnitBath3Qtr\":\"0\",\"NST_UnitBathFull\":\"1\",\"NST_UnitBathHalf\":\"0\",\"NST_UnitBathQtr\":\"0\",\"UnitTypeBathsTotal\":1,\"UnitTypeBedsTotal\":0,\"NST_MonthlyExpenses\":\"0.00\",\"NST_UnitID\":\"4\",\"UnitTypeActualRent\":0,\"UnitTypeUnitsTotal\":1,\"NST_UnitRoomsTotal\":\"3\",\"NST_UnitSqFt\":\"450\"}]","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":""}