{"Id":509720,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST7005920","MLSAGENTID":"NST506069109","MLSOFFICEID":"NST9995","ADDRESS":"4656 2nd Avenue","ACRES":0.154,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Block,Full,Unfinished","BATHSTOTAL":1.0,"BEDROOMS":3,"CITY":"White Bear Lake","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"FORECLOSURE":"No","LASTPRICE":300000.0,"LASTPRICEDATE":"2026-01-13T00:05:05.747","LATITUDE":45.08174278,"LENDEROWNED":"No","LISTDATE":"2026-01-12T06:00:00","LISTPRICE":300000.0,"LIVINGAREA":1189.0,"LONGITUDE":-93.01906965,"LOTDESCRIPTION":"Corner Lot","MODIFICATIONTIMESTAMP":"2026-01-13T11:04:13.671","OFFICE_OFFICENAME":"Keller Williams Premier Realty","PHOTOCOUNT":15,"POSTALCODE":"55110","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Location, Location, Location! Walk to downtown White Bear or the lake! Make a few improvements, finish the basement to your liking to build instant equity! Corner lot. Hardwood floors throughout the main level. Coved ceilings. Newer windows & patio door through the main level. Roof replaced in 2019. Furnace and water heater replaced in 2017. Concrete steps & deck replaced in 2022.","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Age 8 Years or Less,Asphalt","SCHOOLDISTRICTNUMBER":"2099-White Bear Lake","SCHOOLDISTRICTPHONE":"6514077500","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2026-01-13T00:05:05.747","LASTSTATUS":"Active","STREETNAME":"2nd","STREETNUMBER":"4656","STREETSUFFIX":"Avenue","STYLE":"Single Family Residence","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1951,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2026-01-13T00:03:07.461","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15","SOURCE":"MG_NST"}
{"ListingKey":"NST7840333","NST_AboveGradeSqFtTotal":"1189","AboveGradeFinishedArea":"1189","AccessibilityFeatures":"None","AdditionalParcelsYN":"False","NST_AgentOwner":"No","NST_AmenitiesUnit":"Hardwood Floors,Kitchen Window","Appliances":"Dryer,Gas Water Heater,Range,Refrigerator,Washer","LivingAreaUnits":"Square Feet","NST_AssessmentPending":"Yes","AssociationYN":"False","AssociationFee":"0","Basement":"Block,Full,Unfinished","BasementYN":"True","NST_BathDesc":"Main Floor Full Bath","BathroomsFull":"1","BathroomsHalf":"0","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"1","BedroomsTotal":"3","NST_BelowGradeSqFtTotal":"870","BelowGradeFinishedArea":"0","CumulativeDaysOnMarket":"0","City":"White Bear Lake","NewConstructionYN":"False","Contingency":"None","NST_ForSaleOrLease":"For Sale","Cooling":"Central Air","CountyOrParish":"Ramsey","NST_DPResource":"Yes","NST_DiningRoomDescription":"Informal Dining Room,Kitchen/Dining Room,Living/Dining Room","Directions":"Hwy 96 to 2nd Avenue, North on 2nd Avenue to home.","DocumentsCount":"9","DocumentsChangeTimestamp":"2026-01-13T00:05:05.746Z","DaysOnMarket":"0","FireplaceYN":"False","FireplacesTotal":"0","FoundationArea":"870","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","NST_GarageSquareFeet":"280","NST_GarageDimensions":"20 x 14","GarageSpaces":"1","Heating":"Forced Air","HighSchoolDistrict":"White Bear Lake","NST_ForeclosureStatus":"No","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"False","InternetConsumerCommentYN":"False","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","Latitude":"45.0817427752","LaundryFeatures":"In Basement","NST_LenderOwned":"No","Levels":"One and One Half","ListPrice":"300000","ListingContractDate":"2026-01-12T06:00:00Z","ListingId":"NST7005920","LivingArea":"1189","LockBoxType":"Supra","Longitude":"-93.0190696489","LotFeatures":"Corner Lot","LotSizeArea":"0.154","LotSizeDimensions":"68 x 101","LotSizeUnits":"Acres","NST_MainLevelFinishedArea":"870","NST_ManufacturedHome":"N","OriginalEntryTimestamp":"2026-01-12T13:31:21Z","ParcelNumber":"143022340054","NST_SchoolDistrictNumber":"2099","ParkingFeatures":"Detached Garage","NST_PatioPorchType":"Deck","PhotosCount":"15","PhotosChangeTimestamp":"2026-01-13T00:03:07.461Z","PostalCity":"White Bear Lake","PostalCode":"55110","NST_PotentialShortSale":"No","NST_PowerCompanyName":"Xcel Energy","NST_PresentUse":"Yearly","PropertyAttachedYN":"False","PropertySubType":"Single Family Residence","PropertyType":"Residential","PublicRemarks":"Location, Location, Location! Walk to downtown White Bear or the lake! Make a few improvements, finish the basement to your liking to build instant equity! Corner lot. Hardwood floors throughout the main level. Coved ceilings. Newer windows & patio door through the main level. Roof replaced in 2019. Furnace and water heater replaced in 2017. Concrete steps & deck replaced in 2022.","PublicSurveyRange":"22","PublicSurveySection":"14","PublicSurveyTownship":"30","RoadResponsibility":"Public Maintained Road","Roof":"Age 8 Years or Less,Asphalt","NST_SchoolDistrictPhone":"6514077500","Sewer":"City Sewer/Connected","NST_SpecialSearch":"Main Floor Bedroom","StandardStatus":"Active","StateOrProvince":"MN","StreetName":"2nd","StreetNumber":"4656","StreetNumberNumeric":"4656","StreetSuffix":"Avenue","SubdivisionName":"Ramaleys Park","TaxAnnualAmount":"2880","NST_TaxWithAssessments":"5980","TaxYear":"2025","Township":"White Bear Lake","VideosCount":"0","WaterSource":"City Water/Connected","YearBuilt":"1951","ZoningDescription":"Residential-Single Family","ListAgentKey":"NST47557","ListAgentMlsId":"NST506069109","ListOfficeMlsId":"NST9995","ListOfficeName":"Keller Williams Premier Realty","ListOfficeKey":"NST16762","ModificationTimestamp":"2026-01-13T11:04:13.671Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7840333\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7840333/549dbee3-e3ed-436f-a99c-3cef14ee37b7.jpeg\",\"Order\":7,\"MediaObjectID\":\"NST7\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaModificationTimestamp\":\"2026-01-13T00:02:48.042Z\",\"MediaKey\":\"NST120114245\"},{\"ResourceRecordKey\":\"NST7840333\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7840333/42761565-f689-416c-826f-b599d233f6b9.jpeg\",\"Order\":10,\"MediaObjectID\":\"NST10\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-01-13T00:02:48.044Z\",\"MediaKey\":\"NST120114237\"},{\"ResourceRecordKey\":\"NST7840333\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7840333/1c5f7f80-0064-4698-a5fa-8c41909b6099.jpeg\",\"Order\":8,\"MediaObjectID\":\"NST8\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaModificationTimestamp\":\"2026-01-13T00:02:48.034Z\",\"MediaKey\":\"NST120114242\"},{\"ResourceRecordKey\":\"NST7840333\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7840333/66a8ac2b-eb3a-4025-be2f-36f1a6880445.jpeg\",\"Order\":2,\"MediaObjectID\":\"NST2\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-01-13T00:02:48.074Z\",\"MediaKey\":\"NST120114251\"},{\"ResourceRecordKey\":\"NST7840333\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7840333/8b6437b9-5123-4ff4-9195-4c7732ce80e3.jpeg\",\"Order\":6,\"MediaObjectID\":\"NST6\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-01-13T00:02:48.051Z\",\"MediaKey\":\"NST120114247\"},{\"ResourceRecordKey\":\"NST7840333\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7840333/90ef0a15-8401-4563-b85f-0fc128f2903a.jpeg\",\"Order\":11,\"MediaObjectID\":\"NST11\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaModificationTimestamp\":\"2026-01-13T00:02:48.07Z\",\"MediaKey\":\"NST120114236\"},{\"ResourceRecordKey\":\"NST7840333\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7840333/bd6d2f64-307c-4ec2-a4cf-7508980694ce.jpeg\",\"Order\":3,\"MediaObjectID\":\"NST3\",\"ImageWidth\":1917,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1917x1280\",\"MediaModificationTimestamp\":\"2026-01-13T00:02:48.034Z\",\"MediaKey\":\"NST120064313\"},{\"ResourceRecordKey\":\"NST7840333\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7840333/83edb8b5-935b-41ee-b475-32427ce1b683.jpeg\",\"Order\":9,\"MediaObjectID\":\"NST9\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaModificationTimestamp\":\"2026-01-13T00:02:48.031Z\",\"MediaKey\":\"NST120114239\"},{\"ResourceRecordKey\":\"NST7840333\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7840333/84f10e07-85d0-4347-bed4-415fbfcb4ac1.jpeg\",\"Order\":14,\"MediaObjectID\":\"NST14\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-01-13T00:02:48.044Z\",\"MediaKey\":\"NST120114231\"},{\"ResourceRecordKey\":\"NST7840333\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7840333/0655ad5a-971c-47e7-bbc7-809977853fd0.jpeg\",\"Order\":4,\"MediaObjectID\":\"NST4\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-01-13T00:02:48.07Z\",\"MediaKey\":\"NST120114258\"},{\"ResourceRecordKey\":\"NST7840333\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7840333/4413a890-8046-45d3-8ac5-68271ede6158.jpeg\",\"Order\":12,\"MediaObjectID\":\"NST12\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-01-13T00:02:48.044Z\",\"MediaKey\":\"NST120114234\"},{\"ResourceRecordKey\":\"NST7840333\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7840333/ee99f1f2-0742-462d-ae47-9df3d7f76acb.jpeg\",\"Order\":15,\"MediaObjectID\":\"NST15\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaModificationTimestamp\":\"2026-01-13T00:02:48.045Z\",\"MediaKey\":\"NST120114229\"},{\"ResourceRecordKey\":\"NST7840333\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7840333/27a3769b-6028-40cb-97ec-bd73fe57f2d4.jpeg\",\"Order\":1,\"MediaObjectID\":\"NST1\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-01-13T00:02:48.097Z\",\"MediaKey\":\"NST120114249\"},{\"ResourceRecordKey\":\"NST7840333\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7840333/045fe616-8498-4160-99e3-2e7284be0597.jpeg\",\"Order\":5,\"MediaObjectID\":\"NST5\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-01-13T00:02:48.107Z\",\"MediaKey\":\"NST120114255\"},{\"ResourceRecordKey\":\"NST7840333\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7840333/fb0ec395-94c1-434f-9d12-5c25748661b2.jpeg\",\"Order\":13,\"MediaObjectID\":\"NST13\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-01-13T00:02:48.05Z\",\"MediaKey\":\"NST120114233\"}]","Media__ResourceRecordKey":"NST7840333","Media__MediaURL":"https://s3.amazonaws.com/mlsgrid/images/NST7840333/549dbee3-e3ed-436f-a99c-3cef14ee37b7.jpeg","Media__Order":"7","Media__MediaObjectID":"NST7","Media__ImageWidth":"1560","Media__ImageHeight":"2080","Media__ImageSizeDescription":"1560x2080","Media__MediaModificationTimestamp":"1/13/2026 12:02:48 AM","Media__MediaKey":"NST120114245","Rooms":"[{\"RoomKey\":\"NST115853978\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":7,\"RoomDimensions\":\"16 x 7\",\"RoomType\":\"Deck\"},{\"RoomKey\":\"NST115853973\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":2,\"RoomDimensions\":\"13 x 7\",\"RoomType\":\"Dining Room\"},{\"RoomKey\":\"NST115853975\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":4,\"RoomDimensions\":\"11 x 11\",\"RoomType\":\"Bedroom\"},{\"RoomKey\":\"NST115853974\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":3,\"RoomDimensions\":\"12 x 10\",\"RoomType\":\"Kitchen\"},{\"RoomKey\":\"NST115853972\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":1,\"RoomDimensions\":\"18 x10\",\"RoomType\":\"Living Room\"},{\"RoomKey\":\"NST115853976\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":5,\"RoomDimensions\":\"10 x 9\",\"RoomType\":\"Bedroom 2\"},{\"RoomKey\":\"NST115853977\",\"RoomLevel\":\"Upper\",\"NST_RoomSortOrder\":6,\"RoomDimensions\":\"29 x 11\",\"RoomType\":\"Bedroom 3\"}]","Rooms__RoomKey":"NST115853978","Rooms__RoomLevel":"Main","Rooms__NST_RoomSortOrder":"7","Rooms__RoomDimensions":"16 x 7","Rooms__RoomType":"Deck","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15","CustomVTourURL":""}