{"Id":542786,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST7047707","MLSAGENTID":"NST502046800","MLSOFFICEID":"NST40130","ADDRESS":"1938 Longview Drive","ACRES":0.232,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Block,Finished,Full","BATHSTOTAL":1.0,"BEDROOMS":3.0,"CITY":"New Brighton","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Block,Frame","FORECLOSURE":"No","LASTPRICE":230000.0,"LASTPRICEDATE":"2026-04-16T16:42:07.96","LATITUDE":45.089478,"LENDEROWNED":"No","LISTDATE":"2026-04-16T05:00:00","LISTPRICE":230000.0,"LIVINGAREA":1376.0,"LONGITUDE":-93.21296,"LOTDESCRIPTION":"Tree Coverage - Light","MODIFICATIONTIMESTAMP":"2026-04-16T17:12:07.258","OFFICE_OFFICENAME":"Lakes Sotheby's International Realty","PHOTOCOUNT":25,"POSTALCODE":"55112","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Tucked into a quiet pocket of New Brighton, this updated three-bedroom home offers comfort, simplicity, and ease. Inside, natural light fills the refreshed living spaces, highlighted by an updated kitchen and modernized bathroom. Three well-proportioned bedrooms provide flexibility","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Shake,Age Over 8 Years","SCHOOLDISTRICTNUMBER":"2090-Mounds View","SCHOOLDISTRICTPHONE":"6516216001","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2026-04-16T16:42:07.96","LASTSTATUS":"Active","STREETNAME":"Longview","STREETNUMBER":"1938","STREETSUFFIX":"Drive","STYLE":"Single Family","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1957,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2026-04-16T16:42:07.961","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25","SOURCE":"MG_NST"}
{"ListingKey":"NST7878718","NST_AboveGradeSqFtTotal":"926","AboveGradeFinishedArea":"926","AccessibilityFeatures":"None","AdditionalParcelsYN":"False","NST_AgentOwner":"No","NST_AmenitiesUnit":"Kitchen Window,Main Floor Primary Bedroom,Patio","Appliances":"Dishwasher,Disposal,Dryer,Exhaust Fan,Freezer,Gas Water Heater,Microwave,Range,Refrigerator,Stainless Steel Appliances,Washer","LivingAreaUnits":"Square Feet","NST_AssessmentPending":"Yes","AssociationYN":"False","AssociationFee":"0","Basement":"Block,Finished,Full","BasementYN":"True","NST_BathDesc":"Main Floor Full Bath","BathroomsFull":"1","BathroomsHalf":"0","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"1","BedroomsTotal":"3","NST_BelowGradeSqFtTotal":"450","BelowGradeFinishedArea":"450","CumulativeDaysOnMarket":"0","City":"New Brighton","ConstructionMaterials":"Block,Frame","NewConstructionYN":"False","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Ramsey","NST_DiningRoomDescription":"Eat In Kitchen,Kitchen/Dining Room","Directions":"694 East, North on Long Lake Road, Left on Longview Drive, Home on right.","DocumentsCount":"2","DocumentsChangeTimestamp":"2026-04-16T17:12:07.258Z","DaysOnMarket":"0","Electric":"100 Amp Service","Fencing":"None","FireplaceYN":"False","FireplacesTotal":"0","FoundationArea":"926","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","NST_GarageSquareFeet":"484","GarageSpaces":"2","Heating":"Forced Air","HighSchoolDistrict":"Mounds View","NST_ForeclosureStatus":"No","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"False","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","Latitude":"45.089478","LaundryFeatures":"In Basement,Lower Level,Laundry Room","NST_LenderOwned":"No","Levels":"One","ListPrice":"230000","ListingContractDate":"2026-04-16T05:00:00Z","ListingId":"NST7047707","LivingArea":"1376","LockBoxType":"Combo","Longitude":"-93.21296","LotFeatures":"Tree Coverage - Light","LotSizeArea":"0.232","LotSizeDimensions":"135x75","LotSizeUnits":"Acres","NST_MainLevelFinishedArea":"926","NST_ManufacturedHome":"N","OriginalEntryTimestamp":"2026-04-16T11:40:19Z","ParcelNumber":"183023140041","NST_SchoolDistrictNumber":"2090","ParkingFeatures":"Covered,Detached Garage,Asphalt","PhotosCount":"25","PhotosChangeTimestamp":"2026-04-16T16:42:07.961Z","PoolFeatures":"None","PostalCity":"Saint Paul","PostalCode":"55112","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PropertyAttachedYN":"False","PropertySubType":"Single Family","PropertyType":"Residential","PublicRemarks":"Tucked into a quiet pocket of New Brighton, this updated three-bedroom home offers comfort, simplicity, and ease. Inside, natural light fills the refreshed living spaces, highlighted by an updated kitchen and modernized bathroom. Three well-proportioned bedrooms provide flexibility","PublicSurveyRange":"23","PublicSurveySection":"18","PublicSurveyTownship":"30","RoadFrontageType":"City Street","RoadResponsibility":"Public Maintained Road","Roof":"Shake,Age Over 8 Years","NST_SchoolDistrictPhone":"6516216001","Sewer":"City Sewer/Connected","NST_SingleFamilySubType":"Acreage","NST_SpecialSearch":"Main Floor Primary,Main Floor Bedroom","StandardStatus":"Active","StateOrProvince":"MN","StreetName":"Longview","StreetNumber":"1938","StreetNumberNumeric":"1938","StreetSuffix":"Drive","SubdivisionName":"Sunnyside Heights","TaxAnnualAmount":"4165.24","NST_TaxWithAssessments":"4833.38","TaxYear":"2026","BuildingAreaTotal":"1376","Township":"New Brighton","VideosCount":"0","WaterSource":"City Water/Connected","YearBuilt":"1957","ZoningDescription":"Residential-Single Family","ListAgentKey":"NST107364","ListAgentMlsId":"NST502046800","ListOfficeMlsId":"NST40130","ListOfficeName":"Lakes Sotheby's International Realty","ListOfficeKey":"NST18379","ModificationTimestamp":"2026-04-16T17:12:07.258Z","OriginatingSystemName":"northstar","Media":"[{\"Order\":10,\"MediaObjectID\":\"NST10\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7878718/442fb754-ffbb-4140-b01c-1c654fa50644.jpeg\",\"ResourceRecordKey\":\"NST7878718\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaModificationTimestamp\":\"2026-04-16T16:41:20.848Z\",\"MediaKey\":\"NST121568492\"},{\"Order\":7,\"MediaObjectID\":\"NST7\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7878718/df870558-0841-45cc-b4c2-ae747e0cc9b0.jpeg\",\"ResourceRecordKey\":\"NST7878718\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaModificationTimestamp\":\"2026-04-16T16:41:20.859Z\",\"MediaKey\":\"NST121568497\"},{\"Order\":12,\"MediaObjectID\":\"NST12\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7878718/244c74ad-678c-4b57-96e4-de276d071cdb.jpeg\",\"ResourceRecordKey\":\"NST7878718\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaModificationTimestamp\":\"2026-04-16T16:41:20.903Z\",\"MediaKey\":\"NST121568490\"},{\"Order\":14,\"MediaObjectID\":\"NST14\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7878718/8d2ba4a8-87c7-4b8b-af71-65ebaadd368e.jpeg\",\"ResourceRecordKey\":\"NST7878718\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaModificationTimestamp\":\"2026-04-16T16:41:20.859Z\",\"MediaKey\":\"NST121568488\"},{\"Order\":11,\"MediaObjectID\":\"NST11\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7878718/3be5626c-a3db-4820-a093-68b4c6a4770b.jpeg\",\"ResourceRecordKey\":\"NST7878718\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaModificationTimestamp\":\"2026-04-16T16:41:20.852Z\",\"MediaKey\":\"NST121568491\"},{\"Order\":19,\"MediaObjectID\":\"NST19\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7878718/a4120a87-13db-46b1-945f-ec061e90b689.jpeg\",\"ResourceRecordKey\":\"NST7878718\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaModificationTimestamp\":\"2026-04-16T16:41:20.857Z\",\"MediaKey\":\"NST121568480\"},{\"Order\":9,\"MediaObjectID\":\"NST9\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7878718/a852e71f-0e90-49e2-be12-656a20a67985.jpeg\",\"ResourceRecordKey\":\"NST7878718\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaModificationTimestamp\":\"2026-04-16T16:41:20.852Z\",\"MediaKey\":\"NST121568494\"},{\"Order\":13,\"MediaObjectID\":\"NST13\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7878718/603e4737-ceb2-41b8-9b8f-8d9726c911c6.jpeg\",\"ResourceRecordKey\":\"NST7878718\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaModificationTimestamp\":\"2026-04-16T16:41:20.872Z\",\"MediaKey\":\"NST121568489\"},{\"Order\":25,\"MediaObjectID\":\"NST25\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7878718/19d93d5c-0d6c-414d-be6b-442ee361d6aa.jpeg\",\"ResourceRecordKey\":\"NST7878718\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaModificationTimestamp\":\"2026-04-16T16:41:20.89Z\",\"MediaKey\":\"NST121568472\"},{\"Order\":4,\"MediaObjectID\":\"NST4\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7878718/b1e853c1-5a86-4085-a747-9ac934baa229.jpeg\",\"ResourceRecordKey\":\"NST7878718\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaModificationTimestamp\":\"2026-04-16T16:41:20.934Z\",\"MediaKey\":\"NST121568502\"},{\"Order\":18,\"MediaObjectID\":\"NST18\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7878718/d8215a19-d80a-46db-ad34-fedc7f49f6f5.jpeg\",\"ResourceRecordKey\":\"NST7878718\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaModificationTimestamp\":\"2026-04-16T16:41:20.847Z\",\"MediaKey\":\"NST121568481\"},{\"Order\":15,\"MediaObjectID\":\"NST15\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7878718/8b06facf-f5b5-41d4-aa41-e5b8014ed74e.jpeg\",\"ResourceRecordKey\":\"NST7878718\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaModificationTimestamp\":\"2026-04-16T16:41:20.851Z\",\"MediaKey\":\"NST121568486\"},{\"Order\":16,\"MediaObjectID\":\"NST16\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7878718/cb94ddf4-cc85-4130-8794-775122de7b3d.jpeg\",\"ResourceRecordKey\":\"NST7878718\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaModificationTimestamp\":\"2026-04-16T16:41:20.876Z\",\"MediaKey\":\"NST121568484\"},{\"Order\":2,\"MediaObjectID\":\"NST2\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7878718/08236aeb-65f1-40e5-87b5-542087175259.jpeg\",\"ResourceRecordKey\":\"NST7878718\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaModificationTimestamp\":\"2026-04-16T16:41:20.905Z\",\"MediaKey\":\"NST121568504\"},{\"Order\":6,\"MediaObjectID\":\"NST6\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7878718/fbba96b4-6de8-426a-b93b-92828f75c202.jpeg\",\"ResourceRecordKey\":\"NST7878718\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaModificationTimestamp\":\"2026-04-16T16:41:20.848Z\",\"MediaKey\":\"NST121568498\"},{\"Order\":23,\"MediaObjectID\":\"NST23\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7878718/53608eb5-8860-4dce-8a6c-1a67c4c5889f.jpeg\",\"ResourceRecordKey\":\"NST7878718\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaModificationTimestamp\":\"2026-04-16T16:41:20.883Z\",\"MediaKey\":\"NST121568475\"},{\"Order\":22,\"MediaObjectID\":\"NST22\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7878718/7ff8562e-4d17-48d4-a390-bdf31f224a16.jpeg\",\"ResourceRecordKey\":\"NST7878718\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaModificationTimestamp\":\"2026-04-16T16:41:20.923Z\",\"MediaKey\":\"NST121568476\"},{\"Order\":5,\"MediaObjectID\":\"NST5\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7878718/74177788-35fd-483e-b357-15b106ab2794.jpeg\",\"ResourceRecordKey\":\"NST7878718\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaModificationTimestamp\":\"2026-04-16T16:41:20.87Z\",\"MediaKey\":\"NST121568501\"},{\"Order\":3,\"MediaObjectID\":\"NST3\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7878718/dcbae6b2-aa56-4eef-ba19-8f564b34597e.jpeg\",\"ResourceRecordKey\":\"NST7878718\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaModificationTimestamp\":\"2026-04-16T16:41:20.846Z\",\"MediaKey\":\"NST121568503\"},{\"Order\":8,\"MediaObjectID\":\"NST8\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7878718/6743d79b-62ce-401d-be6b-3a384500a62e.jpeg\",\"ResourceRecordKey\":\"NST7878718\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaModificationTimestamp\":\"2026-04-16T16:41:20.852Z\",\"MediaKey\":\"NST121568495\"},{\"Order\":20,\"MediaObjectID\":\"NST20\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7878718/48334422-6a81-4afc-b637-bd068f416d2e.jpeg\",\"ResourceRecordKey\":\"NST7878718\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaModificationTimestamp\":\"2026-04-16T16:41:20.9Z\",\"MediaKey\":\"NST121568479\"},{\"Order\":21,\"MediaObjectID\":\"NST21\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7878718/4186d6ce-5620-4cd5-aacf-513f618c2a8f.jpeg\",\"ResourceRecordKey\":\"NST7878718\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaModificationTimestamp\":\"2026-04-16T16:41:20.905Z\",\"MediaKey\":\"NST121568478\"},{\"Order\":17,\"MediaObjectID\":\"NST17\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7878718/46236f00-b736-4ce1-bdd6-0875a32d725d.jpeg\",\"ResourceRecordKey\":\"NST7878718\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaModificationTimestamp\":\"2026-04-16T16:41:20.908Z\",\"MediaKey\":\"NST121568482\"},{\"Order\":24,\"MediaObjectID\":\"NST24\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7878718/4c2f2411-d4f2-4beb-bc06-4d460d609656.jpeg\",\"ResourceRecordKey\":\"NST7878718\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaModificationTimestamp\":\"2026-04-16T16:41:20.894Z\",\"MediaKey\":\"NST121568473\"},{\"Order\":1,\"MediaObjectID\":\"NST1\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7878718/07e204ca-07c7-4a25-b403-bcb4a810a38f.jpeg\",\"ResourceRecordKey\":\"NST7878718\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaModificationTimestamp\":\"2026-04-16T16:41:20.919Z\",\"MediaKey\":\"NST121569940\"}]","Media__Order":"10","Media__MediaObjectID":"NST10","Media__MediaURL":"https://s3.amazonaws.com/mlsgrid/images/NST7878718/442fb754-ffbb-4140-b01c-1c654fa50644.jpeg","Media__ResourceRecordKey":"NST7878718","Media__ImageWidth":"1920","Media__ImageHeight":"1280","Media__ImageSizeDescription":"1920x1280","Media__MediaModificationTimestamp":"4/16/2026 4:41:20 PM","Media__MediaKey":"NST121568492","Rooms":"[{\"RoomKey\":\"NST116126152\",\"RoomLevel\":\"Main\",\"RoomType\":\"Bedroom\",\"NST_RoomSortOrder\":3,\"RoomDimensions\":\"10x10\"},{\"RoomKey\":\"NST116126151\",\"RoomLevel\":\"Main\",\"RoomType\":\"Kitchen\",\"NST_RoomSortOrder\":2,\"RoomDimensions\":\"13x10\"},{\"RoomKey\":\"NST116126150\",\"RoomLevel\":\"Main\",\"RoomType\":\"Living Room\",\"NST_RoomSortOrder\":1,\"RoomDimensions\":\"16x11\"},{\"RoomKey\":\"NST116126153\",\"RoomLevel\":\"Main\",\"RoomType\":\"Bedroom 2\",\"NST_RoomSortOrder\":4,\"RoomDimensions\":\"12x11\"},{\"RoomKey\":\"NST116126154\",\"RoomLevel\":\"Main\",\"RoomType\":\"Bedroom 3\",\"NST_RoomSortOrder\":5,\"RoomDimensions\":\"12x11\"}]","Rooms__RoomKey":"NST116126152","Rooms__RoomLevel":"Main","Rooms__RoomType":"Bedroom","Rooms__NST_RoomSortOrder":"3","Rooms__RoomDimensions":"10x10","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25","CustomVTourURL":""}