$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. Heartland Real Estate | jaymiann.com is not a multiple Listing Service (MLS), nor does it offer MLS access. This website is a service of Heartland Real Estate | jaymiann.com, 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. Heartland Real Estate | jaymiann.com is not a multiple Listing Service (MLS), nor does it offer MLS access. This website is a service of Heartland Real Estate | jaymiann.com, 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-06-27T03:24:06.28","LATITUDE":44.952502,"LENDEROWNED":"No","LISTDATE":"2026-06-26T05:00:00","LISTPRICE":549000.0,"LIVINGAREA":0.0,"LONGITUDE":-93.056243,"LOTDESCRIPTION":"Tree Coverage - Medium","MODIFICATIONTIMESTAMP":"2026-06-27T03:52:06.228","NEIGHBORHOOD":"90","OFFICE_OFFICENAME":"Axis Realty and Management, LL","PHOTOCOUNT":31,"POSTALCODE":"55106","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Great opportunity to own a commercial Mixed-use Property in Dayton's Bluff. Property is part of the Metro Gold Line BRT (Bus Rapid Transit) project. Sale includes: 2 upper-level Residential Rentals (3BR/1BA & 2BR/1BA), a Liquor Store, and a Restaurant 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 liquor store and restaurant 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-27T03:52:06.228","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"1047 Hudson - Commercial Mixed-Use Investment Opprtunity\"},{\"Order\":2,\"Remarks\":\"1047 Hudson - Back Deck for apt 1 and apt 2\"},{\"Order\":3,\"Remarks\":\"Back Parking Lot - property has 3 designated parking spots\"},{\"Order\":4,\"Remarks\":\"Back Deck - 2 Residential Rental Units Upper-Level (back entrances for the 2 units)\"},{\"Order\":5,\"Remarks\":\"Shared Back Deck - overlooks parking lot\"},{\"Order\":6,\"Remarks\":\"Apt 1 - back entrance walks into kitchen area\"},{\"Order\":7,\"Remarks\":\"Apt 1 - Kitchen\"},{\"Order\":8,\"Remarks\":\"Apt 1 - kitchen walk-in pantry\"},{\"Order\":9,\"Remarks\":\"Apt 1 - Living room/hallway - original re-finished hardwood floors\"},{\"Order\":10,\"Remarks\":\"Apt 1 - living room\"},{\"Order\":11,\"Remarks\":\"Apt 1 - bedroom 1 of 2\"},{\"Order\":12,\"Remarks\":\"Apt 1 - bedroom 1 of 2\"},{\"Order\":13,\"Remarks\":\"Apt 1 - bathroom has clawfoot tub\"},{\"Order\":14,\"Remarks\":\"Apt 1\"},{\"Order\":15,\"Remarks\":\"Apt 1 - bedroom 2 of 2\"},{\"Order\":16,\"Remarks\":\"Apt 1 - bedroom 2 of 2\"},{\"Order\":17,\"Remarks\":\"Apt 1 - hallway in front of bedroom 2\"},{\"Order\":18,\"Remarks\":\"Apt 1 - stairs leading to front door\"},{\"Order\":19,\"Remarks\":\"Main Level - Liquor Store Front\"},{\"Order\":25,\"Remarks\":\"Liquor Store - basement hallway\"},{\"Order\":26,\"Remarks\":\"Liquor Store - basement office space\"},{\"Order\":27,\"Remarks\":\"Liquor Store - basement bathroom\"},{\"Order\":28,\"Remarks\":\"Basement - vacant bonus room (not connected to liquor store portion of basement)\"},{\"Order\":29,\"Remarks\":\"Restaurant Kitchen - main level (view to back entrance)\"},{\"Order\":30,\"Remarks\":\"Restaurant Kitchen - front room\"},{\"Order\":31,\"Remarks\":\"Restaurant Kitchen - bathroom\"}]","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,30,31","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":"549000","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":"31","PhotosChangeTimestamp":"2026-06-27T03:52:06.228Z","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. Property is part of the Metro Gold Line BRT (Bus Rapid Transit) project. Sale includes: 2 upper-level Residential Rentals (3BR/1BA & 2BR/1BA), a Liquor Store, and a Restaurant 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 liquor store and restaurant 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-06-27T03:52:06.228Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7926539\",\"LongDescription\":\"Restaurant Kitchen - bathroom\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7926539/fe766ad5-02c2-4c65-a3e3-e47edcbfd407.jpeg\",\"Order\":31,\"MediaObjectID\":\"NST31\",\"ImageWidth\":1024,\"ImageHeight\":677,\"ImageSizeDescription\":\"1024x677\",\"MediaModificationTimestamp\":\"2026-06-27T03:52:04.72Z\",\"MediaKey\":\"NST123250703\"},{\"ResourceRecordKey\":\"NST7926539\",\"LongDescription\":\"Restaurant Kitchen - front room\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7926539/ae70c725-782a-4490-b7c9-6427d7a1f0a3.jpeg\",\"Order\":30,\"MediaObjectID\":\"NST30\",\"ImageWidth\":1024,\"ImageHeight\":671,\"ImageSizeDescription\":\"1024x671\",\"MediaModificationTimestamp\":\"2026-06-27T03:52:04.68Z\",\"MediaKey\":\"NST123250709\"},{\"ResourceRecordKey\":\"NST7926539\",\"LongDescription\":\"Restaurant Kitchen - main level (view to back entrance)\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7926539/0d7c3e59-b81c-4856-badc-c53dd234feaf.jpeg\",\"Order\":29,\"MediaObjectID\":\"NST29\",\"ImageWidth\":1024,\"ImageHeight\":671,\"ImageSizeDescription\":\"1024x671\",\"MediaModificationTimestamp\":\"2026-06-27T03:52:04.692Z\",\"MediaKey\":\"NST123250705\"},{\"ResourceRecordKey\":\"NST7926539\",\"LongDescription\":\"Basement - vacant bonus room (not connected to liquor store portion of basement)\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7926539/468aa4a1-9e28-47d4-aa37-7a06f65c040c.jpeg\",\"Order\":28,\"MediaObjectID\":\"NST28\",\"ImageWidth\":1024,\"ImageHeight\":679,\"ImageSizeDescription\":\"1024x679\",\"MediaModificationTimestamp\":\"2026-06-27T03:52:04.655Z\",\"MediaKey\":\"NST123250710\"},{\"ResourceRecordKey\":\"NST7926539\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7926539/f7da9eb7-1219-4397-8b3e-e37d4b7fa64e.jpeg\",\"Order\":24,\"MediaObjectID\":\"NST24\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaModificationTimestamp\":\"2026-06-27T03:52:04.694Z\",\"MediaKey\":\"NST123250699\"},{\"ResourceRecordKey\":\"NST7926539\",\"LongDescription\":\"Apt 1 - bedroom 2 of 2\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7926539/21645653-99b2-4857-be5d-d8a0efd69ee2.jpeg\",\"Order\":16,\"MediaObjectID\":\"NST16\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-06-27T03:52:04.677Z\",\"MediaKey\":\"NST123250687\"},{\"ResourceRecordKey\":\"NST7926539\",\"LongDescription\":\"Apt 1 - bathroom has clawfoot tub\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7926539/f8e51502-6b91-47f0-b35c-8e12ab5d1484.jpeg\",\"Order\":13,\"MediaObjectID\":\"NST13\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-06-27T03:52:04.706Z\",\"MediaKey\":\"NST123250717\"},{\"ResourceRecordKey\":\"NST7926539\",\"LongDescription\":\"Liquor Store - basement bathroom\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7926539/d10ac599-2b07-422e-9e3d-b57ef471beee.jpeg\",\"Order\":27,\"MediaObjectID\":\"NST27\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-06-27T03:52:04.716Z\",\"MediaKey\":\"NST123250693\"},{\"ResourceRecordKey\":\"NST7926539\",\"LongDescription\":\"Apt 1 - living room\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7926539/5cfdd17d-4762-4d80-a34c-a42fd6e7b950.jpeg\",\"Order\":10,\"MediaObjectID\":\"NST10\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-06-27T03:52:04.706Z\",\"MediaKey\":\"NST123250712\"},{\"ResourceRecordKey\":\"NST7926539\",\"LongDescription\":\"Apt 1\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7926539/97482eb7-291b-4db6-b41b-1c77da1319cd.jpeg\",\"Order\":14,\"MediaObjectID\":\"NST14\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaModificationTimestamp\":\"2026-06-27T03:52:04.674Z\",\"MediaKey\":\"NST123250714\"},{\"ResourceRecordKey\":\"NST7926539\",\"LongDescription\":\"Back Parking Lot - property has 3 designated parking spots\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7926539/ba9fb395-c821-420f-a42d-af771304f7d6.jpeg\",\"Order\":3,\"MediaObjectID\":\"NST3\",\"ImageWidth\":1024,\"ImageHeight\":623,\"ImageSizeDescription\":\"1024x623\",\"MediaModificationTimestamp\":\"2026-06-27T03:52:04.681Z\",\"MediaKey\":\"NST123250721\"},{\"ResourceRecordKey\":\"NST7926539\",\"LongDescription\":\"Apt 1 - kitchen walk-in pantry\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7926539/6760f0e5-f391-4966-884d-aec7d9e86da6.jpeg\",\"Order\":8,\"MediaObjectID\":\"NST8\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaModificationTimestamp\":\"2026-06-27T03:52:04.682Z\",\"MediaKey\":\"NST123250679\"},{\"ResourceRecordKey\":\"NST7926539\",\"LongDescription\":\"Liquor Store - basement office space\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7926539/2e41f8c8-5756-44e0-beff-9c9d7175a68a.jpeg\",\"Order\":26,\"MediaObjectID\":\"NST26\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-06-27T03:52:04.661Z\",\"MediaKey\":\"NST123250696\"},{\"ResourceRecordKey\":\"NST7926539\",\"LongDescription\":\"Apt 1 - back entrance walks into kitchen area\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7926539/111b620d-0024-46e4-a841-bcbbe6f79b5c.jpeg\",\"Order\":6,\"MediaObjectID\":\"NST6\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaModificationTimestamp\":\"2026-06-27T03:52:04.672Z\",\"MediaKey\":\"NST123250682\"},{\"ResourceRecordKey\":\"NST7926539\",\"LongDescription\":\"Apt 1 - bedroom 2 of 2\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7926539/4bcd8a53-d6b1-49d1-97cf-a2f485bdb2e4.jpeg\",\"Order\":15,\"MediaObjectID\":\"NST15\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-06-27T03:52:04.67Z\",\"MediaKey\":\"NST123250686\"},{\"ResourceRecordKey\":\"NST7926539\",\"LongDescription\":\"Apt 1 - bedroom 1 of 2\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7926539/2a5db4ab-59e3-43a9-96e2-5d462b18f8da.jpeg\",\"Order\":11,\"MediaObjectID\":\"NST11\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-06-27T03:52:04.659Z\",\"MediaKey\":\"NST123250683\"},{\"ResourceRecordKey\":\"NST7926539\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7926539/e06d6232-8d4a-42e4-aa94-0bc24ab16458.jpeg\",\"Order\":21,\"MediaObjectID\":\"NST21\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-06-27T03:52:04.7Z\",\"MediaKey\":\"NST123250697\"},{\"ResourceRecordKey\":\"NST7926539\",\"LongDescription\":\"Apt 1 - Kitchen\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7926539/7be8d240-ef9c-4fbe-bf9a-3f99149a5044.jpeg\",\"Order\":7,\"MediaObjectID\":\"NST7\",\"ImageWidth\":2080,\"ImageHeight\":1666,\"ImageSizeDescription\":\"2080x1666\",\"MediaModificationTimestamp\":\"2026-06-27T03:52:04.651Z\",\"MediaKey\":\"NST123250718\"},{\"ResourceRecordKey\":\"NST7926539\",\"LongDescription\":\"Apt 1 - stairs leading to front door\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7926539/1a09816b-80d3-4729-8f49-24e48165a3fe.jpeg\",\"Order\":18,\"MediaObjectID\":\"NST18\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-06-27T03:52:04.747Z\",\"MediaKey\":\"NST123250684\"},{\"ResourceRecordKey\":\"NST7926539\",\"LongDescription\":\"Apt 1 - Living room/hallway - original re-finished hardwood floors\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7926539/8d9d5d23-34e0-4afa-a0a5-90d710cd7bba.jpeg\",\"Order\":9,\"MediaObjectID\":\"NST9\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-06-27T03:52:04.649Z\",\"MediaKey\":\"NST123250680\"},{\"ResourceRecordKey\":\"NST7926539\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7926539/24c17282-1cbc-464a-9657-1e185e24e49e.jpeg\",\"Order\":23,\"MediaObjectID\":\"NST23\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-06-27T03:52:04.677Z\",\"MediaKey\":\"NST123250690\"},{\"ResourceRecordKey\":\"NST7926539\",\"LongDescription\":\"Apt 1 - hallway in front of bedroom 2\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7926539/583efd56-cb5e-4867-93c0-631e3003779d.jpeg\",\"Order\":17,\"MediaObjectID\":\"NST17\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaModificationTimestamp\":\"2026-06-27T03:52:04.652Z\",\"MediaKey\":\"NST123250713\"},{\"ResourceRecordKey\":\"NST7926539\",\"LongDescription\":\"Liquor Store - basement hallway\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7926539/ee5c704f-a775-443a-9b41-c55c925710cc.jpeg\",\"Order\":25,\"MediaObjectID\":\"NST25\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaModificationTimestamp\":\"2026-06-27T03:52:04.648Z\",\"MediaKey\":\"NST123250689\"},{\"ResourceRecordKey\":\"NST7926539\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7926539/461ad009-37c2-4408-bdc2-a684bbdeb18c.jpeg\",\"Order\":22,\"MediaObjectID\":\"NST22\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-06-27T03:52:04.668Z\",\"MediaKey\":\"NST123250695\"},{\"ResourceRecordKey\":\"NST7926539\",\"LongDescription\":\"1047 Hudson - Commercial Mixed-Use Investment Opprtunity\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7926539/60423c6b-cc37-4f7d-a98e-7783d59eecb2.jpeg\",\"Order\":1,\"MediaObjectID\":\"NST1\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-06-27T03:52:04.714Z\",\"MediaKey\":\"NST123250719\"},{\"ResourceRecordKey\":\"NST7926539\",\"LongDescription\":\"Shared Back Deck - overlooks parking lot\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7926539/ac6b9781-2aa4-4bb9-a2c9-e6b10f52a3de.jpeg\",\"Order\":5,\"MediaObjectID\":\"NST5\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-06-27T03:52:04.697Z\",\"MediaKey\":\"NST123250722\"},{\"ResourceRecordKey\":\"NST7926539\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7926539/b5469434-5ca5-475d-9a8b-d9953606d828.jpeg\",\"Order\":20,\"MediaObjectID\":\"NST20\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-06-27T03:52:04.67Z\",\"MediaKey\":\"NST123250698\"},{\"ResourceRecordKey\":\"NST7926539\",\"LongDescription\":\"Main Level - Liquor Store Front\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7926539/998a100d-74c0-4b5c-af3e-992220950dd8.jpeg\",\"Order\":19,\"MediaObjectID\":\"NST19\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-06-27T03:52:04.764Z\",\"MediaKey\":\"NST123250700\"},{\"ResourceRecordKey\":\"NST7926539\",\"LongDescription\":\"Apt 1 - bedroom 1 of 2\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7926539/4b0264e3-e686-4e5c-b62d-2fcd1aee6230.jpeg\",\"Order\":12,\"MediaObjectID\":\"NST12\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-06-27T03:52:04.672Z\",\"MediaKey\":\"NST123250715\"},{\"ResourceRecordKey\":\"NST7926539\",\"LongDescription\":\"Back Deck - 2 Residential Rental Units Upper-Level (back entrances for the 2 units)\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7926539/3164eb78-ac31-4afa-a911-ade676db1427.jpeg\",\"Order\":4,\"MediaObjectID\":\"NST4\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-06-27T03:52:04.672Z\",\"MediaKey\":\"NST123250711\"},{\"ResourceRecordKey\":\"NST7926539\",\"LongDescription\":\"1047 Hudson - Back Deck for apt 1 and apt 2\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7926539/28da4a21-7275-4ba3-ba94-8eb9d0d93a17.jpeg\",\"Order\":2,\"MediaObjectID\":\"NST2\",\"ImageWidth\":2080,\"ImageHeight\":2006,\"ImageSizeDescription\":\"2080x2006\",\"MediaModificationTimestamp\":\"2026-06-27T03:52:04.684Z\",\"MediaKey\":\"NST123250723\"}]","Media__ResourceRecordKey":"NST7926539","Media__LongDescription":"Restaurant Kitchen - bathroom","Media__MediaURL":"https://s3.amazonaws.com/mlsgrid/images/NST7926539/fe766ad5-02c2-4c65-a3e3-e47edcbfd407.jpeg","Media__Order":"31","Media__MediaObjectID":"NST31","Media__ImageWidth":"1024","Media__ImageHeight":"677","Media__ImageSizeDescription":"1024x677","Media__MediaModificationTimestamp":"6/27/2026 3:52:04 AM","Media__MediaKey":"NST123250703","DocumentsChangeTimestamp":"2026-06-27T03:22:06.507Z","UnitTypes":"[{\"NST_UnitNumber\":\"1\",\"NST_LeaseExpirationDt\":\"2025-11-30\",\"NST_UnitRoomsTotal\":5,\"UnitTypeActualRent\":1000,\"NST_UnitBathFull\":1,\"UnitTypeBathsTotal\":1,\"NST_UnitLevel\":\"2nd Level\",\"NST_UnitIsLeased\":\"Yes\",\"UnitTypeBedsTotal\":2,\"UnitTypeKey\":\"NST21862\"},{\"NST_UnitNumber\":\"2\",\"NST_LeaseExpirationDt\":\"2026-06-30\",\"NST_UnitRoomsTotal\":6,\"UnitTypeActualRent\":1007,\"NST_UnitBathFull\":1,\"UnitTypeBathsTotal\":1,\"NST_UnitLevel\":\"2nd Level\",\"NST_UnitIsLeased\":\"Yes\",\"UnitTypeBedsTotal\":3,\"UnitTypeKey\":\"NST21863\"},{\"NST_UnitNumber\":\"Restaurant Kitc\",\"NST_LeaseExpirationDt\":\"2027-04-30\",\"NST_UnitRoomsTotal\":3,\"UnitTypeActualRent\":975,\"UnitTypeBathsTotal\":1,\"NST_UnitLevel\":\"Main Level\",\"NST_UnitIsLeased\":\"Yes\",\"NST_UnitBathHalf\":1,\"UnitTypeBedsTotal\":0,\"UnitTypeKey\":\"NST21864\"},{\"NST_UnitNumber\":\"Liquor Store\",\"NST_LeaseExpirationDt\":\"2031-01-26\",\"NST_UnitRoomsTotal\":3,\"UnitTypeActualRent\":2000,\"UnitTypeBathsTotal\":1,\"NST_UnitLevel\":\"Main Level\",\"NST_UnitIsLeased\":\"Yes\",\"NST_UnitBathHalf\":1,\"UnitTypeBedsTotal\":0,\"UnitTypeKey\":\"NST21865\"},{\"NST_UnitRoomsTotal\":1,\"UnitTypeBathsTotal\":0,\"NST_UnitLevel\":\"Below Ground\",\"NST_UnitIsLeased\":\"No\",\"UnitTypeBedsTotal\":0,\"UnitTypeKey\":\"NST21868\"}]","UnitTypes__NST_UnitNumber":"1","UnitTypes__NST_LeaseExpirationDt":"2025-11-30","UnitTypes__NST_UnitRoomsTotal":"5","UnitTypes__UnitTypeActualRent":"1000","UnitTypes__NST_UnitBathFull":"1","UnitTypes__UnitTypeBathsTotal":"1","UnitTypes__NST_UnitLevel":"2nd Level","UnitTypes__NST_UnitIsLeased":"Yes","UnitTypes__UnitTypeBedsTotal":"2","UnitTypes__UnitTypeKey":"NST21862","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"1047 Hudson - Commercial Mixed-Use Investment Opprtunity\"},{\"Order\":2,\"Remarks\":\"1047 Hudson - Back Deck for apt 1 and apt 2\"},{\"Order\":3,\"Remarks\":\"Back Parking Lot - property has 3 designated parking spots\"},{\"Order\":4,\"Remarks\":\"Back Deck - 2 Residential Rental Units Upper-Level (back entrances for the 2 units)\"},{\"Order\":5,\"Remarks\":\"Shared Back Deck - overlooks parking lot\"},{\"Order\":6,\"Remarks\":\"Apt 1 - back entrance walks into kitchen area\"},{\"Order\":7,\"Remarks\":\"Apt 1 - Kitchen\"},{\"Order\":8,\"Remarks\":\"Apt 1 - kitchen walk-in pantry\"},{\"Order\":9,\"Remarks\":\"Apt 1 - Living room/hallway - original re-finished hardwood floors\"},{\"Order\":10,\"Remarks\":\"Apt 1 - living room\"},{\"Order\":11,\"Remarks\":\"Apt 1 - bedroom 1 of 2\"},{\"Order\":12,\"Remarks\":\"Apt 1 - bedroom 1 of 2\"},{\"Order\":13,\"Remarks\":\"Apt 1 - bathroom has clawfoot tub\"},{\"Order\":14,\"Remarks\":\"Apt 1\"},{\"Order\":15,\"Remarks\":\"Apt 1 - bedroom 2 of 2\"},{\"Order\":16,\"Remarks\":\"Apt 1 - bedroom 2 of 2\"},{\"Order\":17,\"Remarks\":\"Apt 1 - hallway in front of bedroom 2\"},{\"Order\":18,\"Remarks\":\"Apt 1 - stairs leading to front door\"},{\"Order\":19,\"Remarks\":\"Main Level - Liquor Store Front\"},{\"Order\":25,\"Remarks\":\"Liquor Store - basement hallway\"},{\"Order\":26,\"Remarks\":\"Liquor Store - basement office space\"},{\"Order\":27,\"Remarks\":\"Liquor Store - basement bathroom\"},{\"Order\":28,\"Remarks\":\"Basement - vacant bonus room (not connected to liquor store portion of basement)\"},{\"Order\":29,\"Remarks\":\"Restaurant Kitchen - main level (view to back entrance)\"},{\"Order\":30,\"Remarks\":\"Restaurant Kitchen - front room\"},{\"Order\":31,\"Remarks\":\"Restaurant Kitchen - bathroom\"}]","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,30,31","CustomVTourURL":""}
218 398-4849