$LABEL$
$CONTENT$
$LABEL$
$CONTENT$
Axis Realty and Management, LL 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. Edge of the Wilderness Lakes & Homes Realty is not a multiple Listing Service (MLS), nor does it offer MLS access. This website is a service of Edge of the Wilderness Lakes & Homes Realty, 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. Edge of the Wilderness Lakes & Homes Realty is not a multiple Listing Service (MLS), nor does it offer MLS access. This website is a service of Edge of the Wilderness Lakes & Homes Realty, a broker Participant of the Regional Multiple Listing Service of Minnesota, Inc.
Nearby Listings in 10 Miles
{"Id":578645,"ORGTABLE":"RAW_Property","MLSCLASS":"COM","MLSNUMBER":"NST7100284","MLSAGENTID":"NST502035145","MLSOFFICEID":"NST21487","ADDRESS":"1047 Hudson Road","ACRES":0.122,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Finished,Full,Storage Space","BATHSTOTAL":4.0,"BEDROOMS":5.0,"CITY":"Saint Paul","CONTINGENCY":"None","COUNTY":"Ramsey","CURRENTUSE":"Commercial,Event Space,Office,Other,Professional Service,Residential,Retail,Vacant","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"FORECLOSURE":"No","LASTPRICE":549000.0,"LASTPRICEDATE":"2026-07-21T03:22:05.983","LATITUDE":44.952502,"LENDEROWNED":"No","LISTDATE":"2026-06-26T05:00:00","LISTPRICE":499000.0,"LIVINGAREA":0.0,"LONGITUDE":-93.056243,"LOTDESCRIPTION":"Tree Coverage - Medium","MODIFICATIONTIMESTAMP":"2026-07-21T03:22:05.983","NEIGHBORHOOD":"90","OFFICE_OFFICENAME":"Axis Realty and Management, LL","PHOTOCOUNT":29,"POSTALCODE":"55106","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Great opportunity to own a Commercial Mixed-use Property in Dayton's Bluff. Convenient location. Metro Gold Line Bus Rapid Transit right on Hudson Road. Sale includes: 2 upper-level Residential Rentals (3BR/1BA & 2BR/1BA), a Liquor Store, and a Commercial Kitchen (currently prepares food for the establishment next door). Monthly rents from the 4 units is $4,982/month. Potential to rent basement event space for additional income (currently vacant). There are 3 designated parking spots in back lot for tenants. Due to being tenant occupied - please provide a min. 24-hour notice for all showings. Showings for the liquor store and commercial kitchen should be during their business hours (see agent remarks).","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Flat,Rubber","SALEINCLUDES":"Building,Leases","SCHOOLDISTRICTNUMBER":"625-St. Paul","SCHOOLDISTRICTPHONE":"6517678100","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2026-06-27T03:24:06.28","LASTSTATUS":"Active","STREETNAME":"Hudson","STREETNUMBER":"1047","STREETSUFFIX":"Road","TRANSACTIONTYPE":"For","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1904,"ZONING":"Business/Commercial,Residential-Multi-Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2026-06-28T03:43:06.048","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"1047 Hudson Road - Commercial Mixed-Use Property\"},{\"Order\":2,\"Remarks\":\"Liquor Store is at front of building\"},{\"Order\":6,\"Remarks\":\"Storage Area\"},{\"Order\":7,\"Remarks\":\"1047 Hudson - back of building\"},{\"Order\":8,\"Remarks\":\"Commercial Kitchen entrance is at back of building\"},{\"Order\":9,\"Remarks\":\"Commercial Kitchen - front room\"},{\"Order\":10,\"Remarks\":\"Commercial Kitchen - bathroom\"},{\"Order\":11,\"Remarks\":\"Back Parking Lot - property has 3 designated parking spots\"},{\"Order\":12,\"Remarks\":\"Back Deck - Leads to back entrances for the 2 rental units (above liquor stove and restaurant kitchen)\"},{\"Order\":13,\"Remarks\":\"Shared Back Deck - overlooks parking lot\"},{\"Order\":14,\"Remarks\":\"Apt 1 - back entrance walks into kitchen area\"},{\"Order\":15,\"Remarks\":\"Apt 1 - Kitchen\"},{\"Order\":16,\"Remarks\":\"Apt 1 - kitchen walk-in pantry\"},{\"Order\":17,\"Remarks\":\"Apt 1 - Living room/hallway - original re-finished hardwood floors\"},{\"Order\":18,\"Remarks\":\"Apt 1 - living room\"},{\"Order\":19,\"Remarks\":\"Apt 1 - bedroom 1 of 2\"},{\"Order\":20,\"Remarks\":\"Apt 1 - bedroom 1 of 2\"},{\"Order\":21,\"Remarks\":\"Apt 1 - bathroom has clawfoot tub\"},{\"Order\":22,\"Remarks\":\"Apt 1\"},{\"Order\":23,\"Remarks\":\"Apt 1 - bedroom 2 of 2\"},{\"Order\":24,\"Remarks\":\"Apt 1 - bedroom 2 of 2\"},{\"Order\":25,\"Remarks\":\"Apt 1 - hallway in front of bedroom 2\"},{\"Order\":26,\"Remarks\":\"Apt 1 - stairs leading to front door\"},{\"Order\":27,\"Remarks\":\"Liquor Store - basement office space\"},{\"Order\":28,\"Remarks\":\"Liquor Store - basement bathroom\"},{\"Order\":29,\"Remarks\":\"Basement - vacant bonus room (not connected to liquor store portion of basement)\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29","SOURCE":"MG_NST"}
{"ListingKey":"NST7926539","AccessibilityFeatures":"None","AdditionalParcelsYN":"False","NST_AgentOwner":"No","Appliances":"Cooktop,Refrigerator","LivingAreaUnits":"Square Feet","NST_AssessmentPending":"Unknown","Basement":"Finished,Full,Storage Space","BasementYN":"True","BathroomsTotalInteger":"4","BedroomsTotal":"5","CumulativeDaysOnMarket":"0","City":"Saint Paul","NST_RefrigeratorNum":"Two","NST_CommercialStyleType":"Apartments and Retail,Common Wall,Mixed Use","NewConstructionYN":"False","Contingency":"None","NST_ForSaleOrLease":"For Sale","Cooling":"Window Unit(s)","CountyOrParish":"Ramsey","CurrentUse":"Commercial,Event Space,Office,Other,Professional Service,Residential,Retail,Vacant","Directions":"Hudson Road 1/2 Block West of Earl Street","DocumentsCount":"0","DaysOnMarket":"0","ExteriorFeatures":"Stone","Flooring":"Vinyl,Wood","FoundationArea":"2480","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.952502","NST_LenderOwned":"No","Levels":"Two","ListPrice":"499000","ListingContractDate":"2026-06-26T05:00:00Z","ListingId":"NST7100284","LockBoxType":"Combo","Longitude":"-93.056243","LotFeatures":"Tree Coverage - Medium","LotSizeArea":"0.122","LotSizeDimensions":"43 x 126","LotSizeUnits":"Acres","NST_NeighborhoodName":"Dayton's Bluff","NST_NeighborhoodNumber":"90","NumberOfUnitsTotal":"5","OriginalEntryTimestamp":"2026-06-26T22:21:38Z","NST_OwnerOccupied":"No","OwnerPays":"Fuel,Repairs,Sewer,Snow Removal,Taxes,Trash Collection,Water","ParcelNumber":"332922310234","ParkingFeatures":"Assigned,Asphalt,Parking Lot","NST_PatioPorchType":"Deck","PhotosCount":"29","PhotosChangeTimestamp":"2026-06-28T03:43:06.048Z","PoolFeatures":"None","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. Metro Gold Line Bus Rapid Transit right on Hudson Road. Sale includes: 2 upper-level Residential Rentals (3BR/1BA & 2BR/1BA), a Liquor Store, and a Commercial Kitchen (currently prepares food for the establishment next door). Monthly rents from the 4 units is $4,982/month. Potential to rent basement event space for additional income (currently vacant). There are 3 designated parking spots in back lot for tenants. Due to being tenant occupied - please provide a min. 24-hour notice for all showings. Showings for the liquor store and commercial kitchen should be during their business hours (see agent remarks).","PublicSurveyRange":"22","PublicSurveySection":"33","PublicSurveyTownship":"29","NST_RentalLicenseType":"Standard,Other","NST_RentalLicenseYN":"Y","RoadFrontageType":"City Street","RoadResponsibility":"Public Maintained Road","Roof":"Flat,Rubber","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":"7394","NST_TaxWithAssessments":"7394","TaxYear":"2025","TenantPays":"Electricity","Township":"Saint Paul","Utilities":"Heating Separate","VideosCount":"0","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-07-21T03:22:05.983Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7926539\",\"LongDescription\":\"Commercial Kitchen - bathroom\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7926539/128ae843-9df0-4fd3-9711-ed1c16e6d1c8.jpeg\",\"Order\":10,\"MediaObjectID\":\"NST10\",\"ImageWidth\":1024,\"ImageHeight\":677,\"ImageSizeDescription\":\"1024x677\",\"MediaModificationTimestamp\":\"2026-06-28T03:43:03.897Z\",\"MediaKey\":\"NST123250703\"},{\"ResourceRecordKey\":\"NST7926539\",\"LongDescription\":\"Apt 1 - kitchen walk-in pantry\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7926539/85631d03-b68f-4178-9346-d94795c29197.jpeg\",\"Order\":16,\"MediaObjectID\":\"NST16\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaModificationTimestamp\":\"2026-06-27T18:04:08.108Z\",\"MediaKey\":\"NST123250679\"},{\"ResourceRecordKey\":\"NST7926539\",\"LongDescription\":\"Apt 1 - back entrance walks into kitchen area\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7926539/249a7046-6262-4e3b-8c99-1677ab5f4807.jpeg\",\"Order\":14,\"MediaObjectID\":\"NST14\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaModificationTimestamp\":\"2026-06-27T18:04:08.139Z\",\"MediaKey\":\"NST123250682\"},{\"ResourceRecordKey\":\"NST7926539\",\"LongDescription\":\"Apt 1 - Living room/hallway - original re-finished hardwood floors\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7926539/bee65bbf-cc5d-4229-bbc1-37dd6cc68ba2.jpeg\",\"Order\":17,\"MediaObjectID\":\"NST17\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-06-27T18:04:08.139Z\",\"MediaKey\":\"NST123250680\"},{\"ResourceRecordKey\":\"NST7926539\",\"LongDescription\":\"Commercial Kitchen entrance is at back of building\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7926539/48000db3-d356-466f-ad16-08e50b6f1e09.jpeg\",\"Order\":8,\"MediaObjectID\":\"NST8\",\"ImageWidth\":1024,\"ImageHeight\":671,\"ImageSizeDescription\":\"1024x671\",\"MediaModificationTimestamp\":\"2026-06-28T03:43:03.886Z\",\"MediaKey\":\"NST123250705\"},{\"ResourceRecordKey\":\"NST7926539\",\"LongDescription\":\"Storage Area\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7926539/aacc660e-ac27-454f-be69-114e879acaa7.jpeg\",\"Order\":6,\"MediaObjectID\":\"NST6\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaModificationTimestamp\":\"2026-06-27T18:03:05.785Z\",\"MediaKey\":\"NST123250699\"},{\"ResourceRecordKey\":\"NST7926539\",\"LongDescription\":\"1047 Hudson Road - Commercial Mixed-Use Property\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7926539/fb16e618-690b-4ad5-a024-4ba24232219c.jpeg\",\"Order\":1,\"MediaObjectID\":\"NST1\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-06-27T18:42:09.857Z\",\"MediaKey\":\"NST123250690\"},{\"ResourceRecordKey\":\"NST7926539\",\"LongDescription\":\"Apt 1 - bedroom 1 of 2\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7926539/5c0e9725-eb34-475a-9866-4dd103e34cd2.jpeg\",\"Order\":19,\"MediaObjectID\":\"NST19\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-06-27T18:04:08.144Z\",\"MediaKey\":\"NST123250683\"},{\"ResourceRecordKey\":\"NST7926539\",\"LongDescription\":\"Liquor Store - basement bathroom\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7926539/dfb3f3ed-77df-426a-bfa7-51a624fbfdc7.jpeg\",\"Order\":28,\"MediaObjectID\":\"NST28\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-06-27T18:04:08.119Z\",\"MediaKey\":\"NST123250693\"},{\"ResourceRecordKey\":\"NST7926539\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7926539/97de536e-ad83-4f6e-bdbc-d187582ffe2c.jpeg\",\"Order\":5,\"MediaObjectID\":\"NST5\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-06-27T18:42:09.888Z\",\"MediaKey\":\"NST123250698\"},{\"ResourceRecordKey\":\"NST7926539\",\"LongDescription\":\"Apt 1 - stairs leading to front door\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7926539/675a27b0-c919-4bfe-97f1-002592bf58dd.jpeg\",\"Order\":26,\"MediaObjectID\":\"NST26\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-06-27T18:04:08.099Z\",\"MediaKey\":\"NST123250684\"},{\"ResourceRecordKey\":\"NST7926539\",\"LongDescription\":\"Apt 1 - bedroom 2 of 2\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7926539/fa2fa233-0300-4022-9aaa-534368550a7f.jpeg\",\"Order\":24,\"MediaObjectID\":\"NST24\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-06-27T18:04:08.147Z\",\"MediaKey\":\"NST123250687\"},{\"ResourceRecordKey\":\"NST7926539\",\"LongDescription\":\"Liquor Store - basement office space\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7926539/db1a28f7-4f02-45a1-87a6-861659aeb980.jpeg\",\"Order\":27,\"MediaObjectID\":\"NST27\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-06-27T18:04:08.112Z\",\"MediaKey\":\"NST123250696\"},{\"ResourceRecordKey\":\"NST7926539\",\"LongDescription\":\"Apt 1 - bedroom 2 of 2\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7926539/2fe538ca-9b76-4b47-b4bb-c4784b2606d5.jpeg\",\"Order\":23,\"MediaObjectID\":\"NST23\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-06-27T18:04:08.142Z\",\"MediaKey\":\"NST123250686\"},{\"ResourceRecordKey\":\"NST7926539\",\"LongDescription\":\"Commercial Kitchen - front room\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7926539/52bdfcef-3ea6-45e4-ab2f-622c4eb9b4a0.jpeg\",\"Order\":9,\"MediaObjectID\":\"NST9\",\"ImageWidth\":1024,\"ImageHeight\":671,\"ImageSizeDescription\":\"1024x671\",\"MediaModificationTimestamp\":\"2026-06-28T03:43:03.891Z\",\"MediaKey\":\"NST123250709\"},{\"ResourceRecordKey\":\"NST7926539\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7926539/14dec090-2ba0-4829-a7ac-eb6fffcba81b.jpeg\",\"Order\":4,\"MediaObjectID\":\"NST4\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-06-27T18:42:09.901Z\",\"MediaKey\":\"NST123250695\"},{\"ResourceRecordKey\":\"NST7926539\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7926539/a2c52233-a64d-400a-8f56-0e19209340cc.jpeg\",\"Order\":3,\"MediaObjectID\":\"NST3\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-06-27T18:42:09.852Z\",\"MediaKey\":\"NST123250697\"},{\"ResourceRecordKey\":\"NST7926539\",\"LongDescription\":\"Apt 1 - living room\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7926539/4086f095-0827-48e8-84b6-0d6c6e2c3e7c.jpeg\",\"Order\":18,\"MediaObjectID\":\"NST18\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-06-27T18:04:08.172Z\",\"MediaKey\":\"NST123250712\"},{\"ResourceRecordKey\":\"NST7926539\",\"LongDescription\":\"Basement - vacant bonus room (not connected to liquor store portion of basement)\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7926539/9b0b7415-033e-485c-9f6d-5e2e3d838443.jpeg\",\"Order\":29,\"MediaObjectID\":\"NST29\",\"ImageWidth\":1024,\"ImageHeight\":679,\"ImageSizeDescription\":\"1024x679\",\"MediaModificationTimestamp\":\"2026-06-27T18:04:08.12Z\",\"MediaKey\":\"NST123250710\"},{\"ResourceRecordKey\":\"NST7926539\",\"LongDescription\":\"Back Parking Lot - property has 3 designated parking spots\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7926539/520256f9-6eac-449e-bd18-dd2f427c7d1a.jpeg\",\"Order\":11,\"MediaObjectID\":\"NST11\",\"ImageWidth\":1024,\"ImageHeight\":623,\"ImageSizeDescription\":\"1024x623\",\"MediaModificationTimestamp\":\"2026-06-27T18:09:06.035Z\",\"MediaKey\":\"NST123250721\"},{\"ResourceRecordKey\":\"NST7926539\",\"LongDescription\":\"Apt 1 - bedroom 1 of 2\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7926539/1ef4540b-efd2-4e9e-bc5e-20178907075d.jpeg\",\"Order\":20,\"MediaObjectID\":\"NST20\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-06-27T18:04:08.118Z\",\"MediaKey\":\"NST123250715\"},{\"ResourceRecordKey\":\"NST7926539\",\"LongDescription\":\"Apt 1 - bathroom has clawfoot tub\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7926539/1098f4a5-4852-4c1d-8eed-e6cee90ed16f.jpeg\",\"Order\":21,\"MediaObjectID\":\"NST21\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-06-27T18:04:08.114Z\",\"MediaKey\":\"NST123250717\"},{\"ResourceRecordKey\":\"NST7926539\",\"LongDescription\":\"Apt 1\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7926539/93a461f6-1a54-4f37-b8b9-0a3405555883.jpeg\",\"Order\":22,\"MediaObjectID\":\"NST22\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaModificationTimestamp\":\"2026-06-27T18:04:08.105Z\",\"MediaKey\":\"NST123250714\"},{\"ResourceRecordKey\":\"NST7926539\",\"LongDescription\":\"Back Deck - Leads to back entrances for the 2 rental units (above liquor stove and restaurant kitchen)\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7926539/7387051a-1e6e-4a71-bce9-9c06fe186006.jpeg\",\"Order\":12,\"MediaObjectID\":\"NST12\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-06-27T18:11:10.579Z\",\"MediaKey\":\"NST123250711\"},{\"ResourceRecordKey\":\"NST7926539\",\"LongDescription\":\"Apt 1 - hallway in front of bedroom 2\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7926539/def0049b-ee9e-4c54-b8ad-90d8d709c16f.jpeg\",\"Order\":25,\"MediaObjectID\":\"NST25\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaModificationTimestamp\":\"2026-06-27T18:04:08.119Z\",\"MediaKey\":\"NST123250713\"},{\"ResourceRecordKey\":\"NST7926539\",\"LongDescription\":\"Apt 1 - Kitchen\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7926539/5cf36358-5b68-4452-b017-de5e78ec9e64.jpeg\",\"Order\":15,\"MediaObjectID\":\"NST15\",\"ImageWidth\":2080,\"ImageHeight\":1666,\"ImageSizeDescription\":\"2080x1666\",\"MediaModificationTimestamp\":\"2026-06-27T18:04:08.084Z\",\"MediaKey\":\"NST123250718\"},{\"ResourceRecordKey\":\"NST7926539\",\"LongDescription\":\"Shared Back Deck - overlooks parking lot\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7926539/ded80294-8772-46bf-9863-93488c6194d9.jpeg\",\"Order\":13,\"MediaObjectID\":\"NST13\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-06-27T18:04:08.09Z\",\"MediaKey\":\"NST123250722\"},{\"ResourceRecordKey\":\"NST7926539\",\"LongDescription\":\"1047 Hudson - back of building\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7926539/dc692435-9eb0-40c2-a506-0b9a59d2b655.jpeg\",\"Order\":7,\"MediaObjectID\":\"NST7\",\"ImageWidth\":2080,\"ImageHeight\":2006,\"ImageSizeDescription\":\"2080x2006\",\"MediaModificationTimestamp\":\"2026-06-27T18:09:06.093Z\",\"MediaKey\":\"NST123250723\"},{\"ResourceRecordKey\":\"NST7926539\",\"LongDescription\":\"Liquor Store is at front of building\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7926539/9a32cacd-85a9-472e-98b8-c35552b0bbb3.jpeg\",\"Order\":2,\"MediaObjectID\":\"NST2\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-06-27T18:42:09.875Z\",\"MediaKey\":\"NST123250719\"}]","Media__ResourceRecordKey":"NST7926539","Media__LongDescription":"Commercial Kitchen - bathroom","Media__MediaURL":"https://s3.amazonaws.com/mlsgrid/images/NST7926539/128ae843-9df0-4fd3-9711-ed1c16e6d1c8.jpeg","Media__Order":"10","Media__MediaObjectID":"NST10","Media__ImageWidth":"1024","Media__ImageHeight":"677","Media__ImageSizeDescription":"1024x677","Media__MediaModificationTimestamp":"6/28/2026 3:43:03 AM","Media__MediaKey":"NST123250703","DocumentsChangeTimestamp":"2026-06-27T03:22:06.507Z","UnitTypes":"[{\"NST_UnitLevel\":\"2nd Level\",\"NST_UnitNumber\":\"1\",\"NST_UnitBathFull\":1,\"UnitTypeBathsTotal\":1,\"NST_LeaseExpirationDt\":\"2025-11-30\",\"UnitTypeBedsTotal\":2,\"UnitTypeActualRent\":1000,\"UnitTypeKey\":\"NST21862\",\"NST_UnitRoomsTotal\":5,\"NST_UnitIsLeased\":\"Yes\"},{\"NST_UnitLevel\":\"2nd Level\",\"NST_UnitNumber\":\"2\",\"NST_UnitBathFull\":1,\"UnitTypeBathsTotal\":1,\"NST_LeaseExpirationDt\":\"2026-06-30\",\"UnitTypeBedsTotal\":3,\"UnitTypeActualRent\":1007,\"UnitTypeKey\":\"NST21863\",\"NST_UnitRoomsTotal\":6,\"NST_UnitIsLeased\":\"Yes\"},{\"NST_UnitLevel\":\"Main Level\",\"NST_UnitNumber\":\"Restaurant Kitc\",\"UnitTypeBathsTotal\":1,\"NST_LeaseExpirationDt\":\"2027-04-30\",\"NST_UnitBathHalf\":1,\"UnitTypeBedsTotal\":0,\"UnitTypeActualRent\":975,\"UnitTypeKey\":\"NST21864\",\"NST_UnitRoomsTotal\":3,\"NST_UnitIsLeased\":\"Yes\"},{\"NST_UnitLevel\":\"Main Level\",\"NST_UnitNumber\":\"Liquor Store\",\"UnitTypeBathsTotal\":1,\"NST_LeaseExpirationDt\":\"2031-01-26\",\"NST_UnitBathHalf\":1,\"UnitTypeBedsTotal\":0,\"UnitTypeActualRent\":2000,\"UnitTypeKey\":\"NST21865\",\"NST_UnitRoomsTotal\":3,\"NST_UnitIsLeased\":\"Yes\"},{\"NST_UnitLevel\":\"Below Ground\",\"UnitTypeBathsTotal\":0,\"UnitTypeBedsTotal\":0,\"UnitTypeKey\":\"NST21868\",\"NST_UnitRoomsTotal\":1,\"NST_UnitIsLeased\":\"No\"}]","UnitTypes__NST_UnitLevel":"2nd Level","UnitTypes__NST_UnitNumber":"1","UnitTypes__NST_UnitBathFull":"1","UnitTypes__UnitTypeBathsTotal":"1","UnitTypes__NST_LeaseExpirationDt":"2025-11-30","UnitTypes__UnitTypeBedsTotal":"2","UnitTypes__UnitTypeActualRent":"1000","UnitTypes__UnitTypeKey":"NST21862","UnitTypes__NST_UnitRoomsTotal":"5","UnitTypes__NST_UnitIsLeased":"Yes","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"1047 Hudson Road - Commercial Mixed-Use Property\"},{\"Order\":2,\"Remarks\":\"Liquor Store is at front of building\"},{\"Order\":6,\"Remarks\":\"Storage Area\"},{\"Order\":7,\"Remarks\":\"1047 Hudson - back of building\"},{\"Order\":8,\"Remarks\":\"Commercial Kitchen entrance is at back of building\"},{\"Order\":9,\"Remarks\":\"Commercial Kitchen - front room\"},{\"Order\":10,\"Remarks\":\"Commercial Kitchen - bathroom\"},{\"Order\":11,\"Remarks\":\"Back Parking Lot - property has 3 designated parking spots\"},{\"Order\":12,\"Remarks\":\"Back Deck - Leads to back entrances for the 2 rental units (above liquor stove and restaurant kitchen)\"},{\"Order\":13,\"Remarks\":\"Shared Back Deck - overlooks parking lot\"},{\"Order\":14,\"Remarks\":\"Apt 1 - back entrance walks into kitchen area\"},{\"Order\":15,\"Remarks\":\"Apt 1 - Kitchen\"},{\"Order\":16,\"Remarks\":\"Apt 1 - kitchen walk-in pantry\"},{\"Order\":17,\"Remarks\":\"Apt 1 - Living room/hallway - original re-finished hardwood floors\"},{\"Order\":18,\"Remarks\":\"Apt 1 - living room\"},{\"Order\":19,\"Remarks\":\"Apt 1 - bedroom 1 of 2\"},{\"Order\":20,\"Remarks\":\"Apt 1 - bedroom 1 of 2\"},{\"Order\":21,\"Remarks\":\"Apt 1 - bathroom has clawfoot tub\"},{\"Order\":22,\"Remarks\":\"Apt 1\"},{\"Order\":23,\"Remarks\":\"Apt 1 - bedroom 2 of 2\"},{\"Order\":24,\"Remarks\":\"Apt 1 - bedroom 2 of 2\"},{\"Order\":25,\"Remarks\":\"Apt 1 - hallway in front of bedroom 2\"},{\"Order\":26,\"Remarks\":\"Apt 1 - stairs leading to front door\"},{\"Order\":27,\"Remarks\":\"Liquor Store - basement office space\"},{\"Order\":28,\"Remarks\":\"Liquor Store - basement bathroom\"},{\"Order\":29,\"Remarks\":\"Basement - vacant bonus room (not connected to liquor store portion of basement)\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29","CustomVTourURL":""}
$MLSDESCRIPTION$
1047 Hudson Road Saint Paul, MN 55106
$LISTPRICE$$HOTDATA$
$STATUS$ | Contingent
$MLSNUMBERSHOW$
$SUMMARY1$
$FULLDATA$
$MLSDESCRIPTION$
1047 Hudson Road Saint Paul, MN 55106
$LISTPRICE$$HOTDATA$
$STATUS$ | Contingent
$MLSNUMBERSHOW$
$SUMMARY1$
$FULLDATA$
$MLSDESCRIPTION$
1047 Hudson Road Saint Paul, MN 55106
$LISTPRICE$$HOTDATA$
$STATUS$ | Contingent
$MLSNUMBERSHOW$
$SUMMARY1$
$FULLDATA$
$MLSDESCRIPTION$
1047 Hudson Road Saint Paul, MN 55106
$LISTPRICE$$HOTDATA$
$STATUS$ | Contingent
$MLSNUMBERSHOW$
$SUMMARY1$
$FULLDATA$