{"Id":1387831,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST6761806","MLSAGENTID":"NST506091438","MLSOFFICEID":"NST10185","ADDRESS":"1595 Blair Avenue","ACRES":0.16,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Full,Partially Finished","BATHSTOTAL":2.0,"BEDROOMS":4,"CITY":"Saint Paul","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Engineered Wood","FORECLOSURE":"No","LASTPRICE":334900.0,"LASTPRICEDATE":"2025-07-26T02:59:04.86","LATITUDE":44.96132641,"LENDEROWNED":"Yes","LISTDATE":"2025-07-25T05:00:00","LISTPRICE":334900.0,"LIVINGAREA":2861.0,"LONGITUDE":-93.16786023,"LOTDESCRIPTION":"Public Transit (w/in 6 blks),Many Trees","MODIFICATIONTIMESTAMP":"2025-07-26T22:24:03.593","NEIGHBORHOOD":"Hamline-Midway","OFFICE_OFFICENAME":"RE/MAX Professionals","PHOTOCOUNT":4,"POSTALCODE":"55104","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"warm and welcoming spacious vintage two plus story lovingly maintained - original woodwork. South facing front porch - living room with stone wood burning fireplace for cozy winter evenings. Reading nook (or office space) large dining room with built-ins - bay window and lots of natural light. Updated kitchen with rustic farmhouse feel - two original built-ins - tin ceiling with recessed lighting and on trend pendant lights. Four bedrooms on second level - all good sized - large walk up attic with lots of light - newer windows - perfect for artists studio or office. Lower level family room with convenient three quarter bath. Fenced extra large yard with rare 2016 new built two car 20x20 garage with cement driveway","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Age 8 Years or Less","SCHOOLDISTRICTNUMBER":"625-St. Paul","SCHOOLDISTRICTPHONE":"651-767-8100","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2025-07-26T02:59:04.86","LASTSTATUS":"Active","STREETNAME":"Blair","STREETNUMBER":"1595","STREETSUFFIX":"Avenue","STYLE":"Single Family Residence","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1910,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2025-07-26T03:23:04.56","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"1753125507662.jpg\"},{\"Order\":2,\"Remarks\":\"1753125561547.jpg\"},{\"Order\":3,\"Remarks\":\"1753125568897.jpg\"},{\"Order\":4,\"Remarks\":\"1753125569565.jpg\"}]","PHOTOORDER":"1,2,3,4","SOURCE":"MG_NST"}
{"ListingKey":"NST7778973","LotSizeArea":"0.16","NST_AgeOfProperty":"115","NST_AgentOwner":"No","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"True","NST_AmenitiesUnit":"Balcony,Ceiling Fan(s),Hardwood Floors,Kitchen Window,Natural Woodwork,Patio,Porch,Security System,Tile Floors,Vaulted Ceiling(s),Walk-Up Attic","NST_AssessmentPending":"No","AssociationYN":"False","AssociationFee":"0","PropertyAttachedYN":"False","Basement":"Full,Partially Finished","BasementYN":"True","NST_BathDesc":"3/4 Basement,Upper Level Full Bath","BathroomsOneQuarter":"0","BathroomsFull":"1","BathroomsHalf":"0","BathroomsThreeQuarter":"1","BathroomsTotalInteger":"2","BedroomsTotal":"4","NST_BrokerRedirectLink":"https://broker-redirect.northstarmls.com/broker-redirect/6761806","City":"Saint Paul","PropertyType":"Residential","NewConstructionYN":"False","Contingency":"None","Cooling":"Window Unit(s)","CountyOrParish":"Ramsey","NST_DPResource":"Y","DaysOnMarket":"1","CumulativeDaysOnMarket":"1","NST_DiningRoomDescription":"Eat In Kitchen,Separate/Formal Dining Room","Directions":"Snelling to Blair Avenue - Go west","InternetAddressDisplayYN":"True","InternetEntireListingDisplayYN":"True","Electric":"Circuit Breakers,100 Amp Service","ConstructionMaterials":"Engineered Wood","Fencing":"Chain Link","FireplaceFeatures":"Living Room,Wood Burning","FireplacesTotal":"1","NST_ForeclosureStatus":"No","FoundationArea":"780","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","ParkingFeatures":"Detached,Concrete,Garage Door Opener","NST_GarageDimensions":"20x20","NST_GarageSquareFeet":"400","AccessibilityFeatures":"None","Heating":"Hot Water","OriginalEntryTimestamp":"2025-07-26T02:57:20Z","LandLeaseYN":"False","NST_LastUpdateDate":"2025-07-26","Latitude":"44.961326413","NST_LenderOwned":"Yes","ListAgentKey":"NST49964","ListAgentMlsId":"NST506091438","ListingContractDate":"2025-07-25T05:00:00Z","ListOfficeKey":"NST16539","ListOfficeName":"RE/MAX Professionals","ListOfficeMlsId":"NST10185","ListPrice":"334900","LivingArea":"2861","Longitude":"-93.1678602265","LotFeatures":"Public Transit (w/in 6 blks),Many Trees","LotSizeDimensions":"56 x 143","LotSizeSquareFeet":"6882.48","LotSizeUnits":"Acres","ListingId":"NST6761806","SourceSystemName":"RMLS","NST_ManufacturedHome":"No","MapCoordinateSource":"King's Street Atlas","AdditionalParcelsYN":"False","NST_NeighborhoodNumber":"Hamline-Midway","NST_OfficeBoard":"SPAAR","ParcelNumber":"332923110029","GarageSpaces":"2","PhotosCount":"4","PostalCity":"Saint Paul","PostalCode":"55104","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PublicRemarks":"warm and welcoming spacious vintage two plus story lovingly maintained - original woodwork. South facing front porch - living room with stone wood burning fireplace for cozy winter evenings. Reading nook (or office space) large dining room with built-ins - bay window and lots of natural light. Updated kitchen with rustic farmhouse feel - two original built-ins - tin ceiling with recessed lighting and on trend pendant lights. Four bedrooms on second level - all good sized - large walk up attic with lots of light - newer windows - perfect for artists studio or office. Lower level family room with convenient three quarter bath. Fenced extra large yard with rare 2016 new built two car 20x20 garage with cement driveway","PublicSurveyRange":"23","PublicSurveySection":"33","PublicSurveyTownship":"29","NST_RentalLicenseYN":"No","Roof":"Age 8 Years or Less","RoomType":"Living Room,Dining Room,Kitchen,Bedroom 1,Bedroom 2,Bedroom 3,Bedroom 4,Sitting Room,Foyer,Other Room,Recreation Room,Porch","NST_AboveGradeSqFtTotal":"2383.0000","NST_BelowGradeSqFtTotal":"696.0000","NST_MainLevelFinishedArea":"868.0000","BuildingAreaTotal":"3079","HighSchoolDistrict":"St. Paul","NST_SchoolDistrictNumber":"625","NST_SchoolDistrictPhone":"651-767-8100","Sewer":"City Sewer/Connected","SpecialListingConditions":"Real Estate Owned","NST_SpecialSearch":"4 BR on One Level","AboveGradeFinishedArea":"2383","BelowGradeFinishedArea":"478","StateOrProvince":"MN","StandardStatus":"Active","Levels":"More Than 2 Stories","StreetName":"Blair","StreetNumber":"1595","StreetNumberNumeric":"1595","StreetSuffix":"Avenue","PropertySubType":"Single Family Residence","SubdivisionName":"Hopkins Second Add To, St","NST_TaxWithAssessments":"3646.0000","TaxYear":"2024","TaxAnnualAmount":"3646","WaterSource":"City Water/Connected","YearBuilt":"1910","ZoningDescription":"Residential-Single Family","ModificationTimestamp":"2025-07-26T22:24:03.593Z","PhotosChangeTimestamp":"2025-07-26T03:23:04.56Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7778973\",\"Order\":1,\"MediaObjectID\":\"1\",\"LongDescription\":\"1753125507662.jpg\",\"ImageWidth\":448,\"ImageHeight\":399,\"ImageSizeDescription\":\"448x399\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7778973/267eae0a-63f7-4d44-b4b5-fe41a571eb2e.jpeg\",\"MediaModificationTimestamp\":\"2025-07-26T03:23:03.943Z\",\"MediaKey\":\"68844a17f0e2a241d18c7abe\"},{\"ResourceRecordKey\":\"NST7778973\",\"Order\":2,\"MediaObjectID\":\"2\",\"LongDescription\":\"1753125561547.jpg\",\"ImageWidth\":563,\"ImageHeight\":431,\"ImageSizeDescription\":\"563x431\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7778973/fb654299-1a2c-4db5-bc72-db049701f8f2.jpeg\",\"MediaModificationTimestamp\":\"2025-07-26T03:23:03.92Z\",\"MediaKey\":\"68844a17f0e2a241d18c7abf\"},{\"ResourceRecordKey\":\"NST7778973\",\"Order\":3,\"MediaObjectID\":\"3\",\"LongDescription\":\"1753125568897.jpg\",\"ImageWidth\":640,\"ImageHeight\":480,\"ImageSizeDescription\":\"640x480\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7778973/6fe30850-acff-44e8-bafc-264a4bd4d8f9.jpeg\",\"MediaModificationTimestamp\":\"2025-07-26T03:23:03.931Z\",\"MediaKey\":\"68844a17f0e2a241d18c7ac0\"},{\"ResourceRecordKey\":\"NST7778973\",\"Order\":4,\"MediaObjectID\":\"4\",\"LongDescription\":\"1753125569565.jpg\",\"ImageWidth\":589,\"ImageHeight\":420,\"ImageSizeDescription\":\"589x420\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7778973/2ded98cb-d808-4c30-a960-f1f0ad604704.jpeg\",\"MediaModificationTimestamp\":\"2025-07-26T03:23:03.923Z\",\"MediaKey\":\"68844a17f0e2a241d18c7ac1\"}]","Rooms":"[{\"RoomKey\":\"NST115457326\",\"RoomType\":\"Living Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"13 x 15\",\"NST_RoomSortOrder\":\"1\"},{\"RoomKey\":\"NST115457327\",\"RoomType\":\"Dining Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"13 x 14\",\"NST_RoomSortOrder\":\"2\"},{\"RoomKey\":\"NST115457328\",\"RoomType\":\"Kitchen\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"12 x 18\",\"NST_RoomSortOrder\":\"4\"},{\"RoomKey\":\"NST115457329\",\"RoomType\":\"Bedroom 1\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"13 x 13\",\"NST_RoomSortOrder\":\"5\"},{\"RoomKey\":\"NST115457330\",\"RoomType\":\"Bedroom 2\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"12 x 12\",\"NST_RoomSortOrder\":\"6\"},{\"RoomKey\":\"NST115457331\",\"RoomType\":\"Bedroom 3\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"14 x 10\",\"NST_RoomSortOrder\":\"7\"},{\"RoomKey\":\"NST115457332\",\"RoomType\":\"Bedroom 4\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"11 x 8\",\"NST_RoomSortOrder\":\"8\"},{\"RoomKey\":\"NST115457333\",\"RoomType\":\"Sitting Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"11 x 9\",\"NST_RoomSortOrder\":\"9\"},{\"RoomKey\":\"NST115457334\",\"RoomType\":\"Foyer\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"5 x 4\",\"NST_RoomSortOrder\":\"10\"},{\"RoomKey\":\"NST115457335\",\"RoomType\":\"Other Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"5 x 4\",\"NST_RoomSortOrder\":\"11\"},{\"RoomKey\":\"NST115457336\",\"RoomType\":\"Recreation Room\",\"RoomLevel\":\"Lower\",\"RoomDimensions\":\"10 x 27\",\"NST_RoomSortOrder\":\"12\"},{\"RoomKey\":\"NST115457337\",\"RoomType\":\"Other Room\",\"RoomLevel\":\"Third\",\"RoomDimensions\":\"25 x 29\",\"NST_RoomSortOrder\":\"13\"},{\"RoomKey\":\"NST115457338\",\"RoomType\":\"Porch\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"10 x 20\",\"NST_RoomSortOrder\":\"14\"}]","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"1753125507662.jpg\"},{\"Order\":2,\"Remarks\":\"1753125561547.jpg\"},{\"Order\":3,\"Remarks\":\"1753125568897.jpg\"},{\"Order\":4,\"Remarks\":\"1753125569565.jpg\"}]","PhotoOrder":"1,2,3,4","CustomVTourURL":""}