{"Id":504083,"ORGTABLE":"RAW_Property","MLSCLASS":"LND","MLSNUMBER":"NST6826116","MLSAGENTID":"NST506022758","MLSOFFICEID":"NST27842","ADDRESS":"866 Clear Avenue","ACRES":0.115,"AGENTOWNER":false,"AUCTIONYN":false,"CITY":"Saint Paul","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"FORECLOSURE":"No","LASTPRICE":49000.0,"LASTPRICEDATE":"2025-12-11T03:06:05.153","LATITUDE":44.981785,"LENDEROWNED":"No","LISTDATE":"2025-12-10T06:00:00","LISTPRICE":49000.0,"LIVINGAREA":0.0,"LONGITUDE":-93.064021,"MODIFICATIONTIMESTAMP":"2025-12-12T19:40:38.988","NEIGHBORHOOD":"98","OFFICE_OFFICENAME":"Beycome Brokerage Realty LLC","PHOTOCOUNT":5,"POSTALCODE":"55106","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"**Unauthorized previous listing. See number below** Beautiful city lot with ornamental plum and crab apple trees and raised bed gardens. Gravel parking area off the alley with water hookup, drain and electricity. Just a couple blocks from Phalen Golf Course and Lake Phalen. Rare opportunity in a quiet neighborhood. Full survey included.","ROADBETWEENWATERFRONTANDHOMEYN":false,"SALEINCLUDES":"Other","SCHOOLDISTRICTNUMBER":"2102-St. Paul","SCHOOLDISTRICTPHONE":"6517678100","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2025-12-11T03:06:05.153","LASTSTATUS":"Active","STREETNAME":"Clear","STREETNUMBER":"866","STREETSUFFIX":"Avenue","TRANSACTIONTYPE":"For Sale","WATERFRONTPRESENT":false,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2025-12-11T14:14:05.25","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"image_1.jpg\"},{\"Order\":2,\"Remarks\":\"image_2.jpg\"},{\"Order\":3,\"Remarks\":\"image_3.jpg\"},{\"Order\":4,\"Remarks\":\"image_4.jpg\"},{\"Order\":5,\"Remarks\":\"image_5.jpg\"}]","PHOTOORDER":"1,2,3,4,5","SOURCE":"MG_NST"}
{"ListingKey":"NST7834587","AdditionalParcelsYN":"False","NST_AgentOwner":"No","LivingAreaUnits":"Square Feet","NST_AssessmentPending":"No","AssociationYN":"False","AssociationFee":"0","BasementYN":"False","CumulativeDaysOnMarket":"0","City":"Saint Paul","Contingency":"None","CountyOrParish":"Ramsey","DevelopmentStatus":"Other","NST_DevelopmentAmenityType":"No","Directions":"Drive north on Arcade St North/US 61. Right to Clear Ave. Property is on the right.","DaysOnMarket":"0","NST_FractionalOwnershipYN":"No","HighSchoolDistrict":"St. Paul","NST_ForeclosureStatus":"No","Inclusions":"Other","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"True","InternetEntireListingDisplayYN":"True","NST_Improvements":"Other","LandLeaseYN":"False","Latitude":"44.981785","NST_LenderOwned":"No","ListPrice":"49000","ListingContractDate":"2025-12-10T06:00:00Z","ListingId":"NST6826116","Longitude":"-93.064021","LotSizeArea":"0.115","LotSizeDimensions":"40x126","LotSizeUnits":"Acres","NST_NeighborhoodNumber":"98","OriginalEntryTimestamp":"2025-12-10T21:03:54Z","ParcelNumber":"212922320155","NST_SchoolDistrictNumber":"2102","PhotosCount":"5","PhotosChangeTimestamp":"2025-12-11T14:14:05.25Z","PostalCity":"Saint Paul","PostalCode":"55106","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","NST_ProgramAcresTotal":"0","PropertyType":"Land","PublicRemarks":"**Unauthorized previous listing. See number below** Beautiful city lot with ornamental plum and crab apple trees and raised bed gardens. Gravel parking area off the alley with water hookup, drain and electricity. Just a couple blocks from Phalen Golf Course and Lake Phalen. Rare opportunity in a quiet neighborhood. Full survey included.","PublicSurveyRange":"22","PublicSurveySection":"21","PublicSurveyTownship":"29","NST_Restrictions":"Open","NST_SchoolDistrictPhone":"6517678100","StandardStatus":"Active","StateOrProvince":"MN","StreetName":"Clear","StreetNumber":"866","StreetNumberNumeric":"866","StreetSuffix":"Avenue","SubdivisionName":"Lanes Phalen Grove Add","TaxAnnualAmount":"1832","NST_TaxWithAssessments":"1832","TaxYear":"2025","Topography":"Other","Township":"Saint Paul","Utilities":"Electricity Connected,Other Available,Sewer Connected,Water Connected","ZoningDescription":"Residential-Single Family","ListAgentKey":"NST506665","ListAgentMlsId":"NST506022758","ListOfficeMlsId":"NST27842","ListOfficeName":"Beycome Brokerage Realty LLC","ListOfficeKey":"NST27842","ModificationTimestamp":"2025-12-12T19:40:38.988Z","OriginatingSystemName":"northstar","Media":"[{\"Order\":2,\"MediaObjectID\":\"NST2\",\"ResourceRecordKey\":\"NST7834587\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7834587/15fdfc3d-5b61-4d51-8e06-cc9dc77a799c.jpeg\",\"LongDescription\":\"image_2.jpg\",\"ImageWidth\":670,\"ImageHeight\":500,\"ImageSizeDescription\":\"670x500\",\"MediaModificationTimestamp\":\"2025-12-11T14:13:10.419Z\",\"MediaKey\":\"NST119896077\"},{\"Order\":3,\"MediaObjectID\":\"NST3\",\"ResourceRecordKey\":\"NST7834587\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7834587/3669a85d-3613-46c7-aac5-55318e99be56.jpeg\",\"LongDescription\":\"image_3.jpg\",\"ImageWidth\":1024,\"ImageHeight\":768,\"ImageSizeDescription\":\"1024x768\",\"MediaModificationTimestamp\":\"2025-12-11T14:13:10.409Z\",\"MediaKey\":\"NST119896076\"},{\"Order\":4,\"MediaObjectID\":\"NST4\",\"ResourceRecordKey\":\"NST7834587\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7834587/0f176ab6-aaeb-4d88-9e3d-d8da751c1769.jpeg\",\"LongDescription\":\"image_4.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2025-12-11T14:13:10.491Z\",\"MediaKey\":\"NST119896075\"},{\"Order\":5,\"MediaObjectID\":\"NST5\",\"ResourceRecordKey\":\"NST7834587\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7834587/e549ebc2-568a-46bc-8a22-25b94d40cbc2.jpeg\",\"LongDescription\":\"image_5.jpg\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaModificationTimestamp\":\"2025-12-11T14:13:10.468Z\",\"MediaKey\":\"NST119896074\"},{\"Order\":1,\"MediaObjectID\":\"NST1\",\"ResourceRecordKey\":\"NST7834587\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7834587/d3f62cbd-2105-4882-b8f3-e5108de0898a.jpeg\",\"LongDescription\":\"image_1.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2025-12-11T14:13:10.547Z\",\"MediaKey\":\"NST119896078\"}]","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"image_1.jpg\"},{\"Order\":2,\"Remarks\":\"image_2.jpg\"},{\"Order\":3,\"Remarks\":\"image_3.jpg\"},{\"Order\":4,\"Remarks\":\"image_4.jpg\"},{\"Order\":5,\"Remarks\":\"image_5.jpg\"}]","PhotoOrder":"1,2,3,4,5","CustomVTourURL":""}