Bay Lake Realty
Bruce Johnson
Broker/Owner
Bay Lake Realty is Licensed in the State of Minnesota
15929 Wakeman Rd.
Deerwood, MN 56444
Cell Phone: 218-838-1111
E-mail: bruce@baylakerealty.com
{"Id":535415,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST6789952","MLSAGENTID":"NST506096544","MLSOFFICEID":"NST26401","ADDRESS":"500 Robert Street N","ACRES":0.0,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"None","BATHSTOTAL":1.0,"BEDROOMS":0.0,"CITY":"Saint Paul","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"FORECLOSURE":"No","LASTPRICE":195000.0,"LASTPRICEDATE":"2026-03-31T21:40:05.83","LATITUDE":44.951142,"LENDEROWNED":"No","LISTDATE":"2025-09-19T05:00:00","LISTPRICE":195000.0,"LIVINGAREA":951.0,"LONGITUDE":-93.094138,"MODIFICATIONTIMESTAMP":"2026-03-31T21:40:05.829","NEIGHBORHOOD":"91","OFFICE_OFFICENAME":"Lakes Sotheby's International Realty","PHOTOCOUNT":1,"POSTALCODE":"55101","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Experience authentic downtown St. Paul loft living at the historic Rossmor Building, directly across from Pedro Park. This 951 sq ft industrial-style condo blends the character of a 1916 warehouse conversion with the comfort of modern design — 12-foot ceilings, exposed brick, polished concrete floors, and dramatic southwest-facing windows that fill the space with natural light and skyline views.\n\nThe flexible open layout includes a built-in sleeping loft with storage, a full bath, walk in closet, and spacious living and dining areas perfect for relaxing or entertaining. Contract parking is available, and residents enjoy free laundry on every floor plus a shared outdoor patio with grill area for gatherings.\n\nWalk to the Farmers Market, light rail, Saints Stadium, Rice Park, and local cafés. Just minutes to Regions Hospital (0.5 mi), Children’s Minnesota (0.6 mi), United Hospital (1 mi), Government buildings, and the Capitol Grounds — ideal for professionals seeking a walkable, low-maintenance urban lifestyle.\n\nThe Rossmor Building, known for its vibrant community of artists and professionals, offers the perfect blend of industrial charm and downtown accessibility. Located in the heart of St. Paul’s cultural district, residents are steps from local dining, coffee shops, and green spaces while enjoying easy access to major highways, transit, and government buildings.","ROADBETWEENWATERFRONTANDHOMEYN":false,"SCHOOLDISTRICTNUMBER":"2102-St. Paul","SCHOOLDISTRICTPHONE":"6517678100","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2026-03-31T21:40:05.83","LASTSTATUS":"Active","STREETDIRSUFFIX":"N","STREETNAME":"Robert","STREETNUMBER":"500","STREETSUFFIX":"Street","STYLE":"(CC) High Rise (4+ Levels)","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1916,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2025-10-05T02:27:03.843","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"Loft style living Down Town St. paul\"}]","PHOTOORDER":"1","SOURCE":"MG_NST"}
{"NST_AboveGradeSqFtTotal":"951","AboveGradeFinishedArea":"951","AccessibilityFeatures":"None","AdditionalParcelsYN":"False","NST_AgentOwner":"No","NST_AmenitiesUnit":"City View","Appliances":"Cooktop,Dishwasher,Exhaust Fan,Microwave,Range,Refrigerator","LivingAreaUnits":"Square Feet","NST_AssessmentPending":"Yes","AssociationYN":"True","AssociationAmenities":"Laundry,Patio","AssociationFee":"459.72","AssociationFeeFrequency":"Monthly","AssociationFeeIncludes":"Building Exterior,Hazard Insurance,Lawn Care,Maintenance Grounds,Professional Mgmt,Sanitation,Shared Amenities,Snow Removal,Water","AssociationName":"First Residential","AssociationPhone":"9522772700","Basement":"None","BasementYN":"False","NST_BathDesc":"Main Floor Full Bath","BathroomsFull":"1","BathroomsHalf":"0","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"1","BedroomsTotal":"0","NST_BelowGradeSqFtTotal":"0","BelowGradeFinishedArea":"0","CumulativeDaysOnMarket":"53","City":"Saint Paul","NewConstructionYN":"False","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Ramsey","NST_DPResource":"Yes","Directions":"Robert street N between 9th and 10th Streets. Use 10th Street entrance.","DocumentsCount":"3","DocumentsChangeTimestamp":"2025-11-11T22:18:03.97Z","DaysOnMarket":"53","Fencing":"None","FireplaceYN":"False","FireplacesTotal":"0","FoundationArea":"951","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","NST_GarageSquareFeet":"0","GarageSpaces":"0","Heating":"Forced Air","HighSchoolDistrict":"St. Paul","NST_ForeclosureStatus":"No","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"False","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","Latitude":"44.951142","NST_LenderOwned":"No","Levels":"One","ListPrice":"195000","ListingContractDate":"2025-09-19T05:00:00Z","ListingId":"NST6789952","ListingKey":"NST7803489","LivingArea":"951","Longitude":"-93.094138","LotSizeArea":"0","LotSizeDimensions":"common","LotSizeUnits":"Acres","NST_MainLevelFinishedArea":"951","NST_ManufacturedHome":"N","NST_NeighborhoodNumber":"91","OriginalEntryTimestamp":"2025-09-19T11:37:01Z","ParcelNumber":"312922431434","NST_SchoolDistrictNumber":"2102","ParkingFeatures":"Contract Pkg Required,Parking Lot,More Parking Onsite for Fee","PhotosCount":"1","PhotosChangeTimestamp":"2025-10-05T02:27:03.843Z","PoolFeatures":"None","PostalCity":"Saint Paul","PostalCode":"55101","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PropertyAttachedYN":"True","PropertySubType":"(CC) High Rise (4+ Levels)","PropertyType":"Residential","PublicRemarks":"Experience authentic downtown St. Paul loft living at the historic Rossmor Building, directly across from Pedro Park. This 951 sq ft industrial-style condo blends the character of a 1916 warehouse conversion with the comfort of modern design — 12-foot ceilings, exposed brick, polished concrete floors, and dramatic southwest-facing windows that fill the space with natural light and skyline views.\n\nThe flexible open layout includes a built-in sleeping loft with storage, a full bath, walk in closet, and spacious living and dining areas perfect for relaxing or entertaining. Contract parking is available, and residents enjoy free laundry on every floor plus a shared outdoor patio with grill area for gatherings.\n\nWalk to the Farmers Market, light rail, Saints Stadium, Rice Park, and local cafés. Just minutes to Regions Hospital (0.5 mi), Children’s Minnesota (0.6 mi), United Hospital (1 mi), Government buildings, and the Capitol Grounds — ideal for professionals seeking a walkable, low-maintenance urban lifestyle.\n\nThe Rossmor Building, known for its vibrant community of artists and professionals, offers the perfect blend of industrial charm and downtown accessibility. Located in the heart of St. Paul’s cultural district, residents are steps from local dining, coffee shops, and green spaces while enjoying easy access to major highways, transit, and government buildings.","PublicSurveyRange":"22","PublicSurveySection":"31","PublicSurveyTownship":"29","RoadFrontageType":"City Street,Curbs,Paved Streets,Sidewalks,Street Lights","RoadResponsibility":"Public Maintained Road","NST_SchoolDistrictPhone":"6517678100","Sewer":"City Sewer/Connected","StandardStatus":"Active","StateOrProvince":"MN","StreetDirSuffix":"N","StreetName":"Robert","StreetNumber":"500","StreetNumberNumeric":"500","StreetSuffix":"Street","SubdivisionName":"Cic 535 Rossmor","TaxAnnualAmount":"2963.8","NST_TaxWithAssessments":"3286","TaxYear":"2025","BuildingAreaTotal":"951","Township":"Saint Paul","UnitNumber":"608","VideosCount":"0","WaterSource":"City Water/Connected","YearBuilt":"1916","ZoningDescription":"Residential-Single Family","ListAgentKey":"NST65165","ListAgentMlsId":"NST506096544","ListOfficeMlsId":"NST26401","ListOfficeName":"Lakes Sotheby's International Realty","ListOfficeKey":"NST26401","ModificationTimestamp":"2026-03-31T21:40:05.829Z","OriginatingSystemName":"northstar","Media":"[{\"LongDescription\":\"Loft style living Down Town St. paul\",\"ResourceRecordKey\":\"NST7803489\",\"Order\":1,\"MediaObjectID\":\"NST1\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7803489/d5c74aa6-3ea0-4e5e-9714-ffa2a66810a3.jpeg\",\"MediaModificationTimestamp\":\"2025-10-05T02:26:57.491Z\",\"MediaKey\":\"68e1d771e566fc6eb05ccdde\"}]","Media__LongDescription":"Loft style living Down Town St. paul","Media__ResourceRecordKey":"NST7803489","Media__Order":"1","Media__MediaObjectID":"NST1","Media__ImageWidth":"1920","Media__ImageHeight":"1280","Media__ImageSizeDescription":"1920x1280","Media__MediaURL":"https://s3.amazonaws.com/mlsgrid/images/NST7803489/d5c74aa6-3ea0-4e5e-9714-ffa2a66810a3.jpeg","Media__MediaModificationTimestamp":"10/5/2025 2:26:57 AM","Media__MediaKey":"68e1d771e566fc6eb05ccdde","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"Loft style living Down Town St. paul\"}]","PhotoOrder":"1","CustomVTourURL":""}