{"Id":511248,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST7009936","MLSAGENTID":"NST502021412","MLSOFFICEID":"NST253015","ADDRESS":"3407 Emerald Drive","ACRES":0.209,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Finished","BATHSTOTAL":2.0,"BEDROOMS":3,"CITY":"White Bear Lake","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"FORECLOSURE":"No","LASTPRICE":350000.0,"LASTPRICEDATE":"2026-01-17T03:57:07.037","LATITUDE":45.044742,"LENDEROWNED":"No","LISTDATE":"2026-01-16T06:00:00","LISTPRICE":350000.0,"LIVINGAREA":2128.0,"LONGITUDE":-93.004364,"MODIFICATIONTIMESTAMP":"2026-01-17T12:28:05.254","OFFICE_OFFICENAME":"LPT Realty, LLC","PHOTOCOUNT":2,"POSTALCODE":"55110","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Tucked into a quiet, family-friendly neighborhood in White Bear Lake, this beautifully maintained multi-level home offers exceptional space, flexibility, and value in an outstanding location. The heart of the home is an expansive main-level family room designed for gathering, entertaining, and everyday living, with an open feel that easily accommodates large furniture and active households.\nStep outside to enjoy generous outdoor living with both front and rear decks, creating multiple spaces to relax, host, or enjoy the landscaped yard. The backyard is a true retreat, complete with a jacuzzi that makes it perfect for unwinding year-round.\nThe layout offers incredible versatility, with the potential to add additional bedrooms simply by installing walls, making it ideal for a growing family or those needing extra rooms for work or guests. The attached garage connects directly to the lower level, creating a natural setup for a private mother-in-law suite, guest space, or separate living area.\nThis home is located in a highly desirable area with excellent schools, convenient access to shopping and dining, and an overall setting that blends comfort with practicality. With its flexible floor plan, abundant living space, and hard-to-find price point for the area, this property is a rare opportunity for families looking to settle into a home that can grow with them.","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Age 8 Years or Less","SCHOOLDISTRICTNUMBER":"2099-White Bear Lake","SCHOOLDISTRICTPHONE":"6514077500","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2026-01-17T03:57:07.037","LASTSTATUS":"Active","STREETNAME":"Emerald","STREETNUMBER":"3407","STREETSUFFIX":"Drive","STYLE":"Single Family Residence","TRANSACTIONTYPE":"For","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1962,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2026-01-17T12:28:05.254","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"IMG_20260103_155414718_HDR.jpg\"},{\"Order\":2,\"Remarks\":\"IMG_20260103_155416619_HDR.jpg\"}]","PHOTOORDER":"1,2","SOURCE":"MG_NST"}
{"ListingKey":"NST7843855","NST_AboveGradeSqFtTotal":"1728","AboveGradeFinishedArea":"1728","AccessibilityFeatures":"Wheelchair Ramp(s)","AdditionalParcelsYN":"False","NST_AgentOwner":"No","Appliances":"Microwave,Range,Refrigerator","LivingAreaUnits":"Square Feet","NST_AssessmentPending":"Unknown","AssociationYN":"False","AssociationFee":"0","Basement":"Finished","BasementYN":"True","NST_BathDesc":"3/4 Basement,Upper Level Full Bath","BathroomsFull":"1","BathroomsHalf":"0","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"1","BathroomsTotalInteger":"2","BedroomsTotal":"3","NST_BelowGradeSqFtTotal":"400","BelowGradeFinishedArea":"400","CumulativeDaysOnMarket":"0","City":"White Bear Lake","NewConstructionYN":"False","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Ramsey","NST_DPResource":"Yes","NST_DiningRoomDescription":"Kitchen/Dining Room","Directions":"WHITE BEAR AVE TO ORCHARD LN. E TO EMERALD. N TO HOME.","DocumentsCount":"0","DaysOnMarket":"0","FireplaceYN":"False","FireplacesTotal":"0","FoundationArea":"1392","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","NST_GarageSquareFeet":"400","NST_GarageDimensions":"20x20","GarageSpaces":"1","Heating":"Forced Air","HighSchoolDistrict":"White Bear Lake","NST_ForeclosureStatus":"No","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"True","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","Latitude":"45.044742","NST_LenderOwned":"No","Levels":"Three Level Split","ListPrice":"350000","ListingContractDate":"2026-01-16T06:00:00Z","ListingId":"NST7009936","LivingArea":"2128","LockBoxType":"Combo","Longitude":"-93.004364","LotSizeArea":"0.209","LotSizeDimensions":"114x80","LotSizeUnits":"Acres","NST_MainLevelFinishedArea":"1392","NST_ManufacturedHome":"N","OriginalEntryTimestamp":"2026-01-16T21:56:17Z","ParcelNumber":"363022230056","NST_SchoolDistrictNumber":"2099","ParkingFeatures":"Attached Garage","PhotosCount":"2","PhotosChangeTimestamp":"2026-01-17T12:28:05.254Z","PostalCity":"Saint Paul","PostalCode":"55110","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PropertyAttachedYN":"False","PropertySubType":"Single Family Residence","PropertyType":"Residential","PublicRemarks":"Tucked into a quiet, family-friendly neighborhood in White Bear Lake, this beautifully maintained multi-level home offers exceptional space, flexibility, and value in an outstanding location. The heart of the home is an expansive main-level family room designed for gathering, entertaining, and everyday living, with an open feel that easily accommodates large furniture and active households.\nStep outside to enjoy generous outdoor living with both front and rear decks, creating multiple spaces to relax, host, or enjoy the landscaped yard. The backyard is a true retreat, complete with a jacuzzi that makes it perfect for unwinding year-round.\nThe layout offers incredible versatility, with the potential to add additional bedrooms simply by installing walls, making it ideal for a growing family or those needing extra rooms for work or guests. The attached garage connects directly to the lower level, creating a natural setup for a private mother-in-law suite, guest space, or separate living area.\nThis home is located in a highly desirable area with excellent schools, convenient access to shopping and dining, and an overall setting that blends comfort with practicality. With its flexible floor plan, abundant living space, and hard-to-find price point for the area, this property is a rare opportunity for families looking to settle into a home that can grow with them.","PublicSurveyRange":"22","PublicSurveySection":"36","PublicSurveyTownship":"30","Roof":"Age 8 Years or Less","NST_SchoolDistrictPhone":"6514077500","Sewer":"City Sewer/Connected","StandardStatus":"Active","StateOrProvince":"MN","StreetName":"Emerald","StreetNumber":"3407","StreetNumberNumeric":"3407","StreetSuffix":"Drive","SubdivisionName":"Golf View Heights 2","TaxAnnualAmount":"4598","NST_TaxWithAssessments":"4598","TaxYear":"2025","Township":"White Bear Lake","VideosCount":"0","WaterSource":"City Water/Connected","YearBuilt":"1962","ZoningDescription":"Residential-Single Family","ListAgentKey":"NST61870","ListAgentMlsId":"NST502021412","ListOfficeMlsId":"NST253015","ListOfficeName":"LPT Realty, LLC","ListOfficeKey":"NST1001758","ModificationTimestamp":"2026-01-17T12:28:05.254Z","OriginatingSystemName":"northstar","Media":"[{\"Order\":2,\"MediaObjectID\":\"NST2\",\"ResourceRecordKey\":\"NST7843855\",\"LongDescription\":\"IMG_20260103_155416619_HDR.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7843855/257ec77f-cc85-49ff-9353-edfa82af14b1.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1566,\"ImageSizeDescription\":\"2080x1566\",\"MediaModificationTimestamp\":\"2026-01-17T12:27:28.013Z\",\"MediaKey\":\"NST120177411\"},{\"Order\":1,\"MediaObjectID\":\"NST1\",\"ResourceRecordKey\":\"NST7843855\",\"LongDescription\":\"IMG_20260103_155414718_HDR.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7843855/a01b9c7b-f815-4459-b0f7-d2980a96c5f4.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1566,\"ImageSizeDescription\":\"2080x1566\",\"MediaModificationTimestamp\":\"2026-01-17T12:27:27.981Z\",\"MediaKey\":\"NST120177412\"}]","Media__Order":"2","Media__MediaObjectID":"NST2","Media__ResourceRecordKey":"NST7843855","Media__LongDescription":"IMG_20260103_155416619_HDR.jpg","Media__MediaURL":"https://s3.amazonaws.com/mlsgrid/images/NST7843855/257ec77f-cc85-49ff-9353-edfa82af14b1.jpeg","Media__ImageWidth":"2080","Media__ImageHeight":"1566","Media__ImageSizeDescription":"2080x1566","Media__MediaModificationTimestamp":"1/17/2026 12:27:28 PM","Media__MediaKey":"NST120177411","DocumentsChangeTimestamp":"2026-01-17T03:57:07.037Z","Rooms":"[{\"RoomKey\":\"NST115874775\",\"RoomType\":\"Bathroom\",\"RoomLevel\":\"Upper\",\"NST_RoomSortOrder\":7},{\"RoomKey\":\"NST115874776\",\"RoomType\":\"Bathroom\",\"RoomLevel\":\"Lower\",\"NST_RoomSortOrder\":8},{\"RoomKey\":\"NST115874771\",\"RoomType\":\"Dining Room\",\"RoomDimensions\":\"9x9\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":3},{\"RoomKey\":\"NST115874772\",\"RoomType\":\"Family Room\",\"RoomDimensions\":\"24x18\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":4},{\"RoomKey\":\"NST115874773\",\"RoomType\":\"Bedroom\",\"RoomDimensions\":\"14x21\",\"RoomLevel\":\"Upper\",\"NST_RoomSortOrder\":5},{\"RoomKey\":\"NST115874770\",\"RoomType\":\"Kitchen\",\"RoomDimensions\":\"9x9\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":2},{\"RoomKey\":\"NST115874769\",\"RoomType\":\"Living Room\",\"RoomDimensions\":\"14x18\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":1},{\"RoomKey\":\"NST115874774\",\"RoomType\":\"Bedroom 2\",\"RoomDimensions\":\"10x9\",\"RoomLevel\":\"Upper\",\"NST_RoomSortOrder\":6},{\"RoomKey\":\"NST115874777\",\"RoomType\":\"Bedroom 3\",\"RoomDimensions\":\"14x21\",\"RoomLevel\":\"Lower\",\"NST_RoomSortOrder\":9},{\"RoomKey\":\"NST115874778\",\"RoomType\":\"Utility Room\",\"RoomDimensions\":\"8x10\",\"RoomLevel\":\"Lower\",\"NST_RoomSortOrder\":10}]","Rooms__RoomKey":"NST115874775","Rooms__RoomType":"Bathroom","Rooms__RoomLevel":"Upper","Rooms__NST_RoomSortOrder":"7","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"IMG_20260103_155414718_HDR.jpg\"},{\"Order\":2,\"Remarks\":\"IMG_20260103_155416619_HDR.jpg\"}]","PhotoOrder":"1,2","CustomVTourURL":""}