A TRADITION OF TRUST & SERVICE
$LABEL$
$CONTENT$
$LABEL$
$CONTENT$
Mortgage Calculator
Northstar Real Estate Associates 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. Joy+Marci Realty Group is not a multiple Listing Service (MLS), nor does it offer MLS access. This website is a service of Joy+Marci Realty Group, a broker Participant of the Regional Multiple Listing Service of Minnesota, Inc.
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. Joy+Marci Realty Group is not a multiple Listing Service (MLS), nor does it offer MLS access. This website is a service of Joy+Marci Realty Group, a broker Participant of the Regional Multiple Listing Service of Minnesota, Inc.
Nearby Listings in 10 Miles
{"Id":1352072,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST6729089","MLSAGENTID":"NST502001467","MLSOFFICEID":"NST9990","ADDRESS":"1939 Long Lake Road","ACRES":0.23,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Finished,Full","BATHSTOTAL":2.0,"BEDROOMS":4,"CITY":"New Brighton","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Fiber Board","FORECLOSURE":"No","LASTPRICE":305000.0,"LASTPRICEDATE":"2025-05-29T15:30:04.78","LATITUDE":45.081681,"LENDEROWNED":"No","LISTDATE":"2025-05-29T05:00:00","LISTPRICE":305000.0,"LIVINGAREA":1911.0,"LONGITUDE":-93.210855,"MODIFICATIONTIMESTAMP":"2025-05-30T10:08:08.011","OFFICE_OFFICENAME":"Northstar Real Estate Associates","PHOTOCOUNT":10,"POSTALCODE":"55112","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"This unique property features an open great room with fireplace. Lake views from the large backyard deck and adjoining family room . Lots of storage with an additional storage shed on the back of the lot. Work room space in the heated garage. Conveniently located near freeway access.\n\nHandyman's Special.","ROADBETWEENWATERFRONTANDHOMEYN":false,"SCHOOLDISTRICTNUMBER":"621-Mounds View","SCHOOLDISTRICTPHONE":"651-621-6001","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2025-05-29T15:30:04.78","LASTSTATUS":"Active","STREETNAME":"Long Lake","STREETNUMBER":"1939","STREETSUFFIX":"Road","STYLE":"Single Family Residence","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1980,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2025-05-29T23:54:03.561","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"downstairs great room.jpeg\"},{\"Order\":2,\"Remarks\":\"hutch with built in fish tank.jpeg\"},{\"Order\":3,\"Remarks\":\"kitchen and dining room.jpeg\"},{\"Order\":4,\"Remarks\":\"large deck.jpeg\"},{\"Order\":5,\"Remarks\":\"sitting room.jpeg\"},{\"Order\":6,\"Remarks\":\"view down from walkway.jpeg\"},{\"Order\":7,\"Remarks\":\"view of yard from deck.jpeg\"},{\"Order\":8,\"Remarks\":\"walkway.jpeg\"},{\"Order\":9,\"Remarks\":\"wall mural.jpeg\"},{\"Order\":10,\"Remarks\":\"yard shed.jpeg\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10","SOURCE":"MG_NST"}
{"ListingKey":"NST7750478","LotSizeArea":"0.23","NST_AgeOfProperty":"45","NST_AgentOwner":"No","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"True","NST_AssessmentPending":"No","AssociationYN":"False","AssociationFee":"0","PropertyAttachedYN":"False","Basement":"Finished,Full","BasementYN":"True","BathroomsOneQuarter":"0","BathroomsFull":"2","BathroomsHalf":"0","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"2","BedroomsTotal":"4","City":"New Brighton","PropertyType":"Residential","NewConstructionYN":"False","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Ramsey","NST_DPResource":"Y","DaysOnMarket":"1","CumulativeDaysOnMarket":"1","Directions":"694 to Silver Lake Rd, north on Silver Lake to Rice Creek Rd, east on Rice Creek to Long Lake, south to home","InternetAddressDisplayYN":"True","InternetEntireListingDisplayYN":"True","ConstructionMaterials":"Fiber Board","FireplaceYN":"True","FireplacesTotal":"1","NST_ForeclosureStatus":"No","FoundationArea":"1208","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","ParkingFeatures":"Attached Garage","NST_GarageSquareFeet":"484","AccessibilityFeatures":"None","Heating":"Forced Air","OriginalEntryTimestamp":"2025-05-29T15:27:00Z","LandLeaseYN":"False","NST_LastUpdateDate":"2025-05-30","Latitude":"45.081681","NST_LenderOwned":"No","ListAgentKey":"NST44158","ListAgentMlsId":"NST502001467","ListingContractDate":"2025-05-29T05:00:00Z","ListOfficeKey":"NST15562","ListOfficeName":"Northstar Real Estate Associates","ListOfficeMlsId":"NST9990","ListPrice":"305000","LivingArea":"1911","Longitude":"-93.210855","LotSizeDimensions":"77x130","LotSizeSquareFeet":"9975.24","LotSizeUnits":"Acres","ListingId":"NST6729089","SourceSystemName":"RMLS","NST_ManufacturedHome":"No","MapCoordinateSource":"King's Street Atlas","AdditionalParcelsYN":"False","NST_OfficeBoard":"SPAAR","ParcelNumber":"183023440011","GarageSpaces":"2","PhotosCount":"10","PostalCity":"Saint Paul","PostalCode":"55112","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PublicRemarks":"This unique property features an open great room with fireplace. Lake views from the large backyard deck and adjoining family room . Lots of storage with an additional storage shed on the back of the lot. Work room space in the heated garage. Conveniently located near freeway access.\n\nHandyman's Special.","PublicSurveyRange":"23","PublicSurveySection":"18","PublicSurveyTownship":"30","NST_RentalLicenseYN":"No","RoomType":"Dining Room,Kitchen,Bedroom 1,Bedroom 2,Bedroom 3,Bedroom 4,Living Room,Family Room,Sun Room","NST_AboveGradeSqFtTotal":"1208.0000","NST_BelowGradeSqFtTotal":"1208.0000","NST_MainLevelFinishedArea":"1208.0000","BuildingAreaTotal":"2416","HighSchoolDistrict":"Mounds View","NST_SchoolDistrictNumber":"621","NST_SchoolDistrictPhone":"651-621-6001","Sewer":"City Sewer/Connected","AboveGradeFinishedArea":"1208","BelowGradeFinishedArea":"703","StateOrProvince":"MN","StandardStatus":"Active","Levels":"One","StreetName":"Long Lake","StreetNumber":"1939","StreetNumberNumeric":"1939","StreetSuffix":"Road","PropertySubType":"Single Family Residence","SubdivisionName":"Long Lake Estates","NST_TaxWithAssessments":"4082.0000","TaxYear":"2024","TaxAnnualAmount":"4082","WaterSource":"City Water/Connected","YearBuilt":"1980","ZoningDescription":"Residential-Single Family","ModificationTimestamp":"2025-05-30T10:08:08.011Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7750478\",\"Order\":1,\"MediaObjectID\":\"1\",\"LongDescription\":\"downstairs great room.jpeg\",\"ImageWidth\":1505,\"ImageHeight\":1554,\"ImageSizeDescription\":\"1505x1554\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7750478/2faaadf6-c9e1-4120-b571-6d373661658b.jpeg\",\"MediaModificationTimestamp\":\"2025-05-29T23:53:34.178Z\",\"MediaKey\":\"6838f37ea701c341b45383ea\"},{\"ResourceRecordKey\":\"NST7750478\",\"Order\":2,\"MediaObjectID\":\"2\",\"LongDescription\":\"hutch with built in fish tank.jpeg\",\"ImageWidth\":1599,\"ImageHeight\":899,\"ImageSizeDescription\":\"1599x899\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7750478/5cbd0246-f52a-46ec-bb6d-443181cffca2.jpeg\",\"MediaModificationTimestamp\":\"2025-05-29T23:53:34.161Z\",\"MediaKey\":\"6838f37ea701c341b45383eb\"},{\"ResourceRecordKey\":\"NST7750478\",\"Order\":3,\"MediaObjectID\":\"3\",\"LongDescription\":\"kitchen and dining room.jpeg\",\"ImageWidth\":1599,\"ImageHeight\":899,\"ImageSizeDescription\":\"1599x899\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7750478/e8907a3d-d15c-4a5c-97c7-fee2ba708d12.jpeg\",\"MediaModificationTimestamp\":\"2025-05-29T23:53:34.149Z\",\"MediaKey\":\"6838f37ea701c341b45383ec\"},{\"ResourceRecordKey\":\"NST7750478\",\"Order\":4,\"MediaObjectID\":\"4\",\"LongDescription\":\"large deck.jpeg\",\"ImageWidth\":1599,\"ImageHeight\":899,\"ImageSizeDescription\":\"1599x899\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7750478/26091a9b-5dc9-41bd-8dc1-4e9cdf9c5c79.jpeg\",\"MediaModificationTimestamp\":\"2025-05-29T23:53:34.142Z\",\"MediaKey\":\"6838f37ea701c341b45383ed\"},{\"ResourceRecordKey\":\"NST7750478\",\"Order\":5,\"MediaObjectID\":\"5\",\"LongDescription\":\"sitting room.jpeg\",\"ImageWidth\":1599,\"ImageHeight\":899,\"ImageSizeDescription\":\"1599x899\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7750478/9c231920-6340-417c-bac2-66a8ef09a87c.jpeg\",\"MediaModificationTimestamp\":\"2025-05-29T23:53:34.146Z\",\"MediaKey\":\"6838f37ea701c341b45383ee\"},{\"ResourceRecordKey\":\"NST7750478\",\"Order\":6,\"MediaObjectID\":\"6\",\"LongDescription\":\"view down from walkway.jpeg\",\"ImageWidth\":899,\"ImageHeight\":1599,\"ImageSizeDescription\":\"899x1599\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7750478/7d8cbd5d-28f2-43d7-8425-791019927037.jpeg\",\"MediaModificationTimestamp\":\"2025-05-29T23:53:34.123Z\",\"MediaKey\":\"6838f37ea701c341b45383ef\"},{\"ResourceRecordKey\":\"NST7750478\",\"Order\":7,\"MediaObjectID\":\"7\",\"LongDescription\":\"view of yard from deck.jpeg\",\"ImageWidth\":1599,\"ImageHeight\":899,\"ImageSizeDescription\":\"1599x899\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7750478/0c33a445-916c-4031-9f07-09494e09581b.jpeg\",\"MediaModificationTimestamp\":\"2025-05-29T23:53:34.165Z\",\"MediaKey\":\"6838f37ea701c341b45383f0\"},{\"ResourceRecordKey\":\"NST7750478\",\"Order\":8,\"MediaObjectID\":\"8\",\"LongDescription\":\"walkway.jpeg\",\"ImageWidth\":1599,\"ImageHeight\":899,\"ImageSizeDescription\":\"1599x899\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7750478/825aa8ce-ce09-41ec-8642-e34f734a559a.jpeg\",\"MediaModificationTimestamp\":\"2025-05-29T23:53:34.109Z\",\"MediaKey\":\"6838f37ea701c341b45383f1\"},{\"ResourceRecordKey\":\"NST7750478\",\"Order\":9,\"MediaObjectID\":\"9\",\"LongDescription\":\"wall mural.jpeg\",\"ImageWidth\":1599,\"ImageHeight\":899,\"ImageSizeDescription\":\"1599x899\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7750478/e4573640-fb94-4a56-ac37-fefa5c82d69e.jpeg\",\"MediaModificationTimestamp\":\"2025-05-29T23:53:34.199Z\",\"MediaKey\":\"6838f37ea701c341b45383f2\"},{\"ResourceRecordKey\":\"NST7750478\",\"Order\":10,\"MediaObjectID\":\"10\",\"LongDescription\":\"yard shed.jpeg\",\"ImageWidth\":1599,\"ImageHeight\":899,\"ImageSizeDescription\":\"1599x899\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7750478/7ea509cb-04de-482a-be6e-b4cc3f3b84a6.jpeg\",\"MediaModificationTimestamp\":\"2025-05-29T23:53:34.18Z\",\"MediaKey\":\"6838f37ea701c341b45383f3\"}]","PhotosChangeTimestamp":"2025-05-29T23:54:03.561Z","Rooms":"[{\"RoomKey\":\"NST115261412\",\"RoomType\":\"Dining Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"11.5x10\",\"NST_RoomSortOrder\":\"1\"},{\"RoomKey\":\"NST115261413\",\"RoomType\":\"Kitchen\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"8.5x10\",\"NST_RoomSortOrder\":\"2\"},{\"RoomKey\":\"NST115261414\",\"RoomType\":\"Bedroom 1\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"10x11\",\"NST_RoomSortOrder\":\"3\"},{\"RoomKey\":\"NST115261415\",\"RoomType\":\"Bedroom 2\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"10x11\",\"NST_RoomSortOrder\":\"4\"},{\"RoomKey\":\"NST115261416\",\"RoomType\":\"Bedroom 3\",\"RoomLevel\":\"Lower\",\"RoomDimensions\":\"10x11\",\"NST_RoomSortOrder\":\"5\"},{\"RoomKey\":\"NST115261417\",\"RoomType\":\"Bedroom 4\",\"RoomLevel\":\"Lower\",\"RoomDimensions\":\"10x11\",\"NST_RoomSortOrder\":\"6\"},{\"RoomKey\":\"NST115261418\",\"RoomType\":\"Living Room\",\"RoomLevel\":\"Lower\",\"RoomDimensions\":\"15x14\",\"NST_RoomSortOrder\":\"7\"},{\"RoomKey\":\"NST115261419\",\"RoomType\":\"Family Room\",\"RoomLevel\":\"Lower\",\"RoomDimensions\":\"21x13\",\"NST_RoomSortOrder\":\"8\"},{\"RoomKey\":\"NST115261420\",\"RoomType\":\"Sun Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"13x17\",\"NST_RoomSortOrder\":\"9\"}]","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"downstairs great room.jpeg\"},{\"Order\":2,\"Remarks\":\"hutch with built in fish tank.jpeg\"},{\"Order\":3,\"Remarks\":\"kitchen and dining room.jpeg\"},{\"Order\":4,\"Remarks\":\"large deck.jpeg\"},{\"Order\":5,\"Remarks\":\"sitting room.jpeg\"},{\"Order\":6,\"Remarks\":\"view down from walkway.jpeg\"},{\"Order\":7,\"Remarks\":\"view of yard from deck.jpeg\"},{\"Order\":8,\"Remarks\":\"walkway.jpeg\"},{\"Order\":9,\"Remarks\":\"wall mural.jpeg\"},{\"Order\":10,\"Remarks\":\"yard shed.jpeg\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10","CustomVTourURL":""}