$LABEL$
$SCONTENT$
MLS# 7047707
1938 Longview Drive New Brighton, MN 55112
Lakes Sotheby's International Realty is the brokerage office representing the seller for this listing.
Copyright 2019, Regional Multiple Listing Service of Minnesota, Inc. all rights reserved. Information is deemed reliable but is not guaranteed.
The data relating to real estate for sale on this site comes in part from the broker reciprocity program of the Regional multiple Listing Service of Minnesota, Inc. real estate listings held by brokerage firms other than are marked with the Broker Reciprocity logo or the Broker reciprocity house icon and detailed information about them includes the names(s) of the listing brokers. Mark Tietjen - Rusty's Up North Realty is not a multiple Listing Service (MLS), nor does it offer MLS access. This website is a service of Mark Tietjen - Rusty's Up North Realty, a broker Participant of the Regional Multiple Listing Service of Minnesota, Inc.
{"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-16T21:38:06.758","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 for everyday living, guests, or a home office. Ideally located near Irondale High School with quick access to major highways, this home blends neighborhood charm with everyday convenience. A refined opportunity to live well in a connected, welcoming community.","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 for everyday living, guests, or a home office. Ideally located near Irondale High School with quick access to major highways, this home blends neighborhood charm with everyday convenience. A refined opportunity to live well in a connected, welcoming community.","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":"4300","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-16T21:38:06.758Z","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":""}
