{"Id":605294,"ORGTABLE":"RAW_Property","MLSCLASS":"COM","MLSNUMBER":"NST7133598","MLSAGENTID":"NST502035145","MLSOFFICEID":"NST21487","ADDRESS":"1047 Hudson Road","ACRES":0.122,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Full,Storage Space","BATHSTOTAL":5.0,"BEDROOMS":5.0,"CITY":"Saint Paul","CONTINGENCY":"None","COUNTY":"Ramsey","CURRENTUSE":"Commercial,Residential,Restaurant,Retail,Vacant","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"FORECLOSURE":"No","LASTPRICE":479000.0,"LASTPRICEDATE":"2026-08-27T14:15:07.127","LATITUDE":44.952494,"LENDEROWNED":"No","LISTDATE":"2026-08-27T05:00:00","LISTPRICE":479000.0,"LIVINGAREA":0.0,"LONGITUDE":-93.056235,"MODIFICATIONTIMESTAMP":"2026-08-27T14:27:08.054","NEIGHBORHOOD":"90","OFFICE_OFFICENAME":"Axis Realty and Management, LL","PHOTOCOUNT":0,"POSTALCODE":"55106","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Great opportunity to own a Commercial Mixed-use Property in Dayton's Bluff. Convenient location. Sale includes - 2 upper-level Residential Rentals (3BR/1BA & 2BR/1BA), a Liquor Store, and a commercial kitchen. Monthly rents from the 4 units $4,982/month. Potential to rent basement space for additional income (currently vacant). 3 Designated parking spots in back lot for tenants. Please provide a min. 24-hour notice for all showings.","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Flat","SALEINCLUDES":"Building,Leases","SCHOOLDISTRICTNUMBER":"625-St. Paul","SCHOOLDISTRICTPHONE":"6517678100","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2026-08-27T14:15:07.127","LASTSTATUS":"Active","STREETNAME":"Hudson","STREETNUMBER":"1047","STREETSUFFIX":"Road","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1904,"ZONING":"Business/Commercial,Residential-Multi-Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2026-08-27T14:15:07.125","SOURCE":"MG_NST"}
{"ListingKey":"NST7957499","AccessibilityFeatures":"None","AdditionalParcelsYN":"False","NST_AgentOwner":"No","NST_AmenitiesUnit":"Deck","Appliances":"Cooktop,Range,Refrigerator","LivingAreaUnits":"Square Feet","NST_AssessmentPending":"Unknown","Basement":"Full,Storage Space","BasementYN":"True","BathroomsTotalInteger":"5","BedroomsTotal":"5","CumulativeDaysOnMarket":"61","City":"Saint Paul","PossibleUse":"Office,Other","NST_RefrigeratorNum":"Two","NST_CommercialStyleType":"Apartments and Retail,Common Wall,Low Rise (3- levels),Mixed Use","NewConstructionYN":"False","Contingency":"None","NST_ForSaleOrLease":"For Sale","Cooling":"Window Unit(s)","CountyOrParish":"Ramsey","CurrentUse":"Commercial,Residential,Restaurant,Retail,Vacant","Directions":"Hudson Road 1/2 Block West of Earl Street","DaysOnMarket":"0","ExteriorFeatures":"Stone","Flooring":"Vinyl,Wood","FoundationArea":"7440","FoundationDetails":"Brick/Mortar","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","GarageSpaces":"0","GrossIncome":"59784","Heating":"Boiler","HighSchoolDistrict":"St. Paul","NST_ForeclosureStatus":"No","Inclusions":"Building,Leases","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"True","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","Latitude":"44.952494","NST_LenderOwned":"No","Levels":"Two","ListPrice":"479000","ListingContractDate":"2026-08-27T05:00:00Z","ListingId":"NST7133598","LockBoxType":"Combo","Longitude":"-93.056235","LotSizeArea":"0.122","LotSizeDimensions":"43 x 126","LotSizeUnits":"Acres","NST_NeighborhoodName":"Dayton's Bluff","NST_NeighborhoodNumber":"90","NumberOfUnitsTotal":"5","OriginalEntryTimestamp":"2026-08-27T09:14:25Z","NST_OwnerOccupied":"No","OwnerPays":"Exterior Maintenance,Fuel,Sewer,Snow Removal,Taxes,Trash Collection,Water","ParcelNumber":"332922310234","ParkingFeatures":"Assigned,Asphalt,Shared Driveway,Parking Lot","PostalCity":"Saint Paul","PostalCode":"55106","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PropertyType":"Commercial Sale","PublicRemarks":"Great opportunity to own a Commercial Mixed-use Property in Dayton's Bluff. Convenient location. Sale includes - 2 upper-level Residential Rentals (3BR/1BA & 2BR/1BA), a Liquor Store, and a commercial kitchen. Monthly rents from the 4 units $4,982/month. Potential to rent basement space for additional income (currently vacant). 3 Designated parking spots in back lot for tenants. Please provide a min. 24-hour notice for all showings.","PublicSurveyRange":"22","PublicSurveySection":"33","PublicSurveyTownship":"29","NST_RentalLicenseType":"Standard,Other","NST_RentalLicenseYN":"Y","RoadFrontageType":"City Street","RoadResponsibility":"Public Maintained Road","Roof":"Flat","NST_SchoolDistrictFullName":"625 - St. Paul","NST_SchoolDistrictNumber":"625","NST_SchoolDistrictPhone":"6517678100","Sewer":"City Sewer/Connected","StandardStatus":"Active","StateOrProvince":"MN","StreetName":"Hudson","StreetNumber":"1047","StreetNumberNumeric":"1047","StreetSuffix":"Road","SubdivisionName":"Scottens Sub Of B71 Lyman Day","TaxAnnualAmount":"7466","NST_TaxWithAssessments":"7466","TaxYear":"2026","TenantPays":"Cable TV,Electricity","Township":"Saint Paul","Utilities":"Heating Common","WaterSource":"City Water/Connected","WaterfrontYN":"False","YearBuilt":"1904","ZoningDescription":"Business/Commercial,Residential-Multi-Family","ListAgentKey":"NST85444","ListAgentMlsId":"NST502035145","ListOfficeMlsId":"NST21487","ListOfficeName":"Axis Realty and Management, LL","ListOfficeKey":"NST21487","ModificationTimestamp":"2026-08-27T14:27:08.054Z","OriginatingSystemName":"northstar","PhotosCount":"0","PhotosChangeTimestamp":"2026-08-27T14:15:07.125Z","DocumentsCount":"0","DocumentsChangeTimestamp":"2026-08-27T14:15:07.125Z","UnitTypes":"[{\"NST_UnitLevel\":\"2nd Level\",\"NST_UnitRoomsTotal\":5,\"UnitTypeBedsTotal\":2,\"UnitTypeActualRent\":1000,\"UnitTypeKey\":\"NST22252\",\"UnitTypeBathsTotal\":1,\"NST_LeaseExpirationDt\":\"2025-11-30\",\"NST_UnitBathFull\":1,\"NST_UnitNumber\":\"1\",\"NST_UnitIsLeased\":\"Yes\"},{\"NST_UnitLevel\":\"2nd Level\",\"NST_UnitRoomsTotal\":6,\"UnitTypeBedsTotal\":3,\"UnitTypeActualRent\":1007,\"UnitTypeKey\":\"NST22253\",\"UnitTypeBathsTotal\":1,\"NST_LeaseExpirationDt\":\"2026-06-30\",\"NST_UnitBathFull\":1,\"NST_UnitNumber\":\"2\",\"NST_UnitIsLeased\":\"Yes\"},{\"NST_UnitLevel\":\"Main Level\",\"NST_UnitRoomsTotal\":3,\"UnitTypeBedsTotal\":0,\"UnitTypeActualRent\":975,\"UnitTypeKey\":\"NST22254\",\"UnitTypeBathsTotal\":1,\"NST_LeaseExpirationDt\":\"2027-04-30\",\"NST_UnitNumber\":\"3\",\"NST_UnitBathHalf\":1,\"NST_UnitIsLeased\":\"Yes\"},{\"NST_UnitLevel\":\"Main Level\",\"NST_UnitRoomsTotal\":3,\"UnitTypeBedsTotal\":0,\"UnitTypeActualRent\":2000,\"UnitTypeKey\":\"NST22255\",\"UnitTypeBathsTotal\":1,\"NST_LeaseExpirationDt\":\"2031-01-26\",\"NST_UnitNumber\":\"4\",\"NST_UnitBathHalf\":1,\"NST_UnitIsLeased\":\"Yes\"},{\"NST_UnitLevel\":\"Below Ground\",\"NST_UnitRoomsTotal\":2,\"UnitTypeBedsTotal\":0,\"UnitTypeKey\":\"NST22256\",\"UnitTypeBathsTotal\":1,\"NST_UnitBathHalf\":1,\"NST_UnitIsLeased\":\"No\"}]","UnitTypes__NST_UnitLevel":"2nd Level","UnitTypes__NST_UnitRoomsTotal":"5","UnitTypes__UnitTypeBedsTotal":"2","UnitTypes__UnitTypeActualRent":"1000","UnitTypes__UnitTypeKey":"NST22252","UnitTypes__UnitTypeBathsTotal":"1","UnitTypes__NST_LeaseExpirationDt":"2025-11-30","UnitTypes__NST_UnitBathFull":"1","UnitTypes__NST_UnitNumber":"1","UnitTypes__NST_UnitIsLeased":"Yes","MlgCanView":"True","MlgCanUse":"IDX","CustomVTourURL":""}