{"Id":1386645,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST6760415","MLSAGENTID":"NST505007796","MLSOFFICEID":"NST3546","ADDRESS":"300 Wall Street","ACRES":0.03,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"None","BATHSTOTAL":2.0,"BEDROOMS":2,"CITY":"Saint Paul","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"FORECLOSURE":"No","LASTPRICE":375000.0,"LASTPRICEDATE":"2025-12-07T18:04:03.56","LATITUDE":44.948634,"LENDEROWNED":"No","LISTDATE":"2025-07-23T05:00:00","LISTPRICE":360000.0,"LIVINGAREA":1164.0,"LONGITUDE":-93.08421,"LOTDESCRIPTION":"Public Transit (w/in 6 blks),Corner Lot,Tree Coverage - Light","MODIFICATIONTIMESTAMP":"2025-12-08T22:10:25.397","NEIGHBORHOOD":"91","OFFICE_OFFICENAME":"Re/Max Advantage Plus","PHOTOCOUNT":1,"POSTALCODE":"55101","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"No need to worry about parking — this loft includes TWO dedicated off-street parking spaces in a fully covered/semi-enclosed parking ramp that’s secured and located directly across the street, plus BONUS guest parking. In downtown St. Paul, having two assigned stalls and free guest parking is almost unheard of. The covered ramp shields vehicles from the elements, and for weekly grocery runs, most residents simply keep a collapsible wagon in their unit — the same setup used in buildings with underground parking. Urban living made easy — convenience without compromise.\n\nStep inside and immediately feel the character of this exceptional 2BD/2BA Lowertown loft. Historic charm meets thoughtful modern design with soaring 12’ brick barrel ceilings, solid oak hardwood floors, and oversized windows that frame the private courtyard. Natural light fills the open living and dining areas, creating a warm, inviting backdrop for everyday living or entertaining.\n\nThe kitchen blends function and sophistication with soapstone countertops, a new island with custom lower cabinetry, and stainless-steel appliances. Both bathrooms were taken down to the studs and rebuilt in 2024, featuring walk-in tile showers, custom cabinetry, and timeless black-and-white finishes. The primary suite includes custom closet organization and a cleverly concealed washer/dryer. The second bedroom features a custom Murphy bed with integrated shelving — perfect for guests, a home office, or both.\n\n\nBuilding amenities extend your living space with a fitness room, party room, courtyard patio, bike storage, and an additional storage locker. And when you’re ready to venture out, everything is at your doorstep — CHS Field, the Farmers Market, breweries, parks, river trails, and dining. Union Depot also sits just blocks away, offering effortless access to Amtrak, Light Rail, Rapid Transit, and airport connections, along with a full calendar of year-round community events — from winter markets to summer festivals. Here, convenience isn’t an extra. It’s the lifestyle.","ROADBETWEENWATERFRONTANDHOMEYN":false,"SCHOOLDISTRICTNUMBER":"2102-St. Paul","SCHOOLDISTRICTPHONE":"6517678100","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Pending","STATUSDATE":"2025-12-08T22:10:25.397","LASTSTATUS":"Active","STREETNAME":"Wall","STREETNUMBER":"300","STREETSUFFIX":"Street","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1888,"ZONING":"Residential-Multi-Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2025-12-08T22:10:25.397","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"View of the informal Dining Room & Generously sized Kitchen, which has received numerous updates including: New center island, custom lower cabinets, Soap Stone Countertops, & SS appliances (w/ new dishwasher & Range)! (virtually staged image)\"}]","PHOTOORDER":"1","SOURCE":"MG_NST"}
{"ListingKey":"NST7777774","Appliances":"Cooktop,Dishwasher,Disposal,Dryer,Exhaust Fan,Microwave,Range,Refrigerator,Stainless Steel Appliances,Washer","AssociationYN":"True","AssociationFee":"1056.19","AssociationName":"First Service Residential","Basement":"None","City":"Saint Paul","Contingency":"None","Directions":"Kellogg Blvd. East of downtown to Wall Street, North to home.","Electric":"Circuit Breakers","FireplaceYN":"False","NST_Fuel":"Other","Latitude":"44.948634","ListPrice":"360000","LivingArea":"1164","Longitude":"-93.08421","LotSizeDimensions":"HOA","LotSizeUnits":"Acres","ParcelNumber":"322922330295","PostalCity":"Saint Paul","PostalCode":"55101","PublicRemarks":"No need to worry about parking — this loft includes TWO dedicated off-street parking spaces in a fully covered/semi-enclosed parking ramp that’s secured and located directly across the street, plus BONUS guest parking. In downtown St. Paul, having two assigned stalls and free guest parking is almost unheard of. The covered ramp shields vehicles from the elements, and for weekly grocery runs, most residents simply keep a collapsible wagon in their unit — the same setup used in buildings with underground parking. Urban living made easy — convenience without compromise.\n\nStep inside and immediately feel the character of this exceptional 2BD/2BA Lowertown loft. Historic charm meets thoughtful modern design with soaring 12’ brick barrel ceilings, solid oak hardwood floors, and oversized windows that frame the private courtyard. Natural light fills the open living and dining areas, creating a warm, inviting backdrop for everyday living or entertaining.\n\nThe kitchen blends function and sophistication with soapstone countertops, a new island with custom lower cabinetry, and stainless-steel appliances. Both bathrooms were taken down to the studs and rebuilt in 2024, featuring walk-in tile showers, custom cabinetry, and timeless black-and-white finishes. The primary suite includes custom closet organization and a cleverly concealed washer/dryer. The second bedroom features a custom Murphy bed with integrated shelving — perfect for guests, a home office, or both.\n\n\nBuilding amenities extend your living space with a fitness room, party room, courtyard patio, bike storage, and an additional storage locker. And when you’re ready to venture out, everything is at your doorstep — CHS Field, the Farmers Market, breweries, parks, river trails, and dining. Union Depot also sits just blocks away, offering effortless access to Amtrak, Light Rail, Rapid Transit, and airport connections, along with a full calendar of year-round community events — from winter markets to summer festivals. Here, convenience isn’t an extra. It’s the lifestyle.","PublicSurveyRange":"22","PublicSurveySection":"32","PublicSurveyTownship":"29","NST_SchoolDistrictPhone":"6517678100","Sewer":"City Sewer/Connected","StateOrProvince":"MN","StreetName":"Wall","StreetNumber":"300","StreetNumberNumeric":"300","StreetSuffix":"Street","TaxYear":"2025","UnitNumber":"502","YearBuilt":"1888","NST_AboveGradeSqFtTotal":"1164","AboveGradeFinishedArea":"1164","AccessibilityFeatures":"Doors 36\"+,Accessible Elevator Installed,Door Lever Handles,No Stairs Internal","AdditionalParcelsYN":"False","NST_AgentOwner":"No","NST_AmenitiesUnit":"Hardwood Floors,Kitchen Center Island,Primary Bedroom Walk-In Closet,Main Floor Primary Bedroom,Natural Woodwork,Paneled Doors,Tile Floors,Vaulted Ceiling(s),Washer/Dryer Hookup,Walk-In Closet","LivingAreaUnits":"Square Feet","NST_AssessmentPending":"No","AssociationAmenities":"Elevator(s),Fire Sprinkler System,Lobby Entrance,Patio","AssociationFeeFrequency":"Monthly","AssociationFeeIncludes":"Air Conditioning,Building Exterior,Controlled Access,Hazard Insurance,Heating,Lawn Care,Maintenance Grounds,Parking,Professional Mgmt,Sanitation,Security System,Sewer,Shared Amenities,Snow Removal,Water","AssociationPhone":"9522272700","BasementYN":"False","NST_BathDesc":"Full Primary,Main Floor Full Bath","BathroomsFull":"2","BathroomsHalf":"0","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"2","BedroomsTotal":"2","NST_BelowGradeSqFtTotal":"0","BelowGradeFinishedArea":"0","BuyerOfficeName":"Coldwell Banker Realty","CumulativeDaysOnMarket":"186","NewConstructionYN":"False","Cooling":"Central Air,Zoned","CountyOrParish":"Ramsey","NST_DPResource":"Yes","NST_DiningRoomDescription":"Informal Dining Room","DaysOnMarket":"138","Fencing":"None","FireplacesTotal":"0","FoundationArea":"1164","NST_FractionalOwnershipYN":"No","GarageSpaces":"2","Heating":"Forced Air,Hot Water","HighSchoolDistrict":"St. Paul","NST_ForeclosureStatus":"No","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"True","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","LaundryFeatures":"Laundry Closet,Main Level,In Unit,Washer Hookup","NST_LenderOwned":"No","Levels":"One","ListingContractDate":"2025-07-23T05:00:00Z","ListingId":"NST6760415","LotFeatures":"Public Transit (w/in 6 blks),Corner Lot,Tree Coverage - Light","LotSizeArea":"0.03","NST_MainLevelFinishedArea":"1164","NST_ManufacturedHome":"N","NST_NeighborhoodNumber":"91","OffMarketDate":"2025-12-08T06:00:00Z","OriginalEntryTimestamp":"2025-07-23T17:39:04Z","NST_SchoolDistrictNumber":"2102","ParkingFeatures":"Assigned,Detached Garage","PhotosCount":"1","PhotosChangeTimestamp":"2025-12-08T22:10:25.397Z","PoolFeatures":"None","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PropertyAttachedYN":"True","PropertyType":"Residential","RoadFrontageType":"City Street,Curbs,Paved Streets,Sidewalks,Street Lights","RoadResponsibility":"Public Maintained Road","NST_SharedRooms":"Amusement/Party Room,Community Room,Exercise Room","NST_SpecialSearch":"All Living Facilities on One Level,Main Floor Primary,Main Floor Bedroom,Main Floor Laundry","StandardStatus":"Pending","SubdivisionName":"Cic 515 The Great Northern","TaxAnnualAmount":"4511.9","NST_TaxWithAssessments":"4796","Township":"Saint Paul","WaterSource":"City Water/Connected","ZoningDescription":"Residential-Multi-Family","BuyerAgentKey":"NST47596","BuyerAgentMlsId":"NST506069292","BuyerOfficeMlsId":"NST8237","BuyerOfficeKey":"NST16731","ListAgentKey":"NST68920","ListAgentMlsId":"NST505007796","ListOfficeMlsId":"NST3546","ListOfficeName":"Re/Max Advantage Plus","ListOfficeKey":"NST16224","ModificationTimestamp":"2025-12-08T22:10:25.397Z","OriginatingSystemName":"northstar","Media":"[{\"LongDescription\":\"View of the informal Dining Room & Generously sized Kitchen, which has received numerous updates including: New center island, custom lower cabinets, Soap Stone Countertops, & SS appliances (w/ new dishwasher & Range)! (virtually staged image)\",\"ResourceRecordKey\":\"NST7777774\",\"Order\":1,\"MediaObjectID\":\"NST1\",\"ImageWidth\":2047,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2047x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7777774/724c26ff-ef97-47b6-b6e7-18d2c4f060b7.jpeg\",\"MediaModificationTimestamp\":\"2025-07-26T03:05:23.338Z\",\"MediaKey\":\"688445f3b84e111996482b25\"}]","Rooms":"[{\"RoomDimensions\":\"16x12\",\"RoomKey\":\"NST115449387\",\"RoomType\":\"Living Room\",\"NST_RoomSortOrder\":1,\"RoomLevel\":\"Main\"},{\"RoomDimensions\":\"12x8\",\"RoomKey\":\"NST115449389\",\"RoomType\":\"Kitchen\",\"NST_RoomSortOrder\":3,\"RoomLevel\":\"Main\"},{\"RoomDimensions\":\"12x8\",\"RoomKey\":\"NST115449388\",\"RoomType\":\"Dining Room\",\"NST_RoomSortOrder\":2,\"RoomLevel\":\"Main\"},{\"RoomDimensions\":\"12x10\",\"RoomKey\":\"NST115449391\",\"RoomType\":\"Bedroom 2\",\"NST_RoomSortOrder\":5,\"RoomLevel\":\"Main\"},{\"RoomDimensions\":\"14x12\",\"RoomKey\":\"NST115449390\",\"RoomType\":\"Bedroom\",\"NST_RoomSortOrder\":4,\"RoomLevel\":\"Main\"}]","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"View of the informal Dining Room & Generously sized Kitchen, which has received numerous updates including: New center island, custom lower cabinets, Soap Stone Countertops, & SS appliances (w/ new dishwasher & Range)! (virtually staged image)\"}]","PhotoOrder":"1","CustomVTourURL":""}