{"Id":565036,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST7083594","MLSAGENTID":"NST502006614","MLSOFFICEID":"NST40766","ADDRESS":"1895 Fairview Avenue N","ACRES":0.365,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Block","BATHSTOTAL":2.0,"BEDROOMS":3.0,"CITY":"Falcon Heights","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"FORECLOSURE":"No","LASTPRICE":385000.0,"LASTPRICEDATE":"2026-06-23T14:45:07.28","LATITUDE":44.99823,"LENDEROWNED":"No","LISTDATE":"2026-05-30T05:00:00","LISTPRICE":379000.0,"LIVINGAREA":1358.0,"LONGITUDE":-93.177443,"MODIFICATIONTIMESTAMP":"2026-06-23T14:45:07.281","OFFICE_OFFICENAME":"Latigo Leasing & Sales","PHOTOCOUNT":15,"POSTALCODE":"55113","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Charming brick rambler across from the U of M. Fields, walking distance to St. Paul campus. This home features two wood burning fireplaces, master bath and a beautiful yard.","ROADBETWEENWATERFRONTANDHOMEYN":false,"SCHOOLDISTRICTNUMBER":"623-Roseville","SCHOOLDISTRICTPHONE":"6516351600","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2026-05-30T12:07:06.173","LASTSTATUS":"Active","STREETDIRSUFFIX":"N","STREETNAME":"Fairview","STREETNUMBER":"1895","STREETSUFFIX":"Avenue","STYLE":"Single Family","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1945,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2026-05-30T12:27:06.474","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"fff.jpg\"},{\"Order\":2,\"Remarks\":\"ff.jpg\"},{\"Order\":3,\"Remarks\":\"ffffffffffffff.jpg\"},{\"Order\":4,\"Remarks\":\"fffffffffff.jpg\"},{\"Order\":5,\"Remarks\":\"ffffffffffff.jpg\"},{\"Order\":6,\"Remarks\":\"fffffff.jpg\"},{\"Order\":7,\"Remarks\":\"ffffffff.jpg\"},{\"Order\":8,\"Remarks\":\"fffffffff.jpg\"},{\"Order\":9,\"Remarks\":\"fffffffffffffff.jpg\"},{\"Order\":10,\"Remarks\":\"ffffffffffffffff.jpg\"},{\"Order\":11,\"Remarks\":\"fffffffffffff.jpg\"},{\"Order\":12,\"Remarks\":\"ffff.jpg\"},{\"Order\":13,\"Remarks\":\"fffff.jpg\"},{\"Order\":14,\"Remarks\":\"ffffff.jpg\"},{\"Order\":15,\"Remarks\":\"ffffffffff.jpg\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15","SOURCE":"MG_NST"}
{"ListingKey":"NST7909993","NST_AboveGradeSqFtTotal":"1070","AboveGradeFinishedArea":"1070","AccessibilityFeatures":"None","AdditionalParcelsYN":"False","NST_AgentOwner":"No","LivingAreaUnits":"Square Feet","NST_AssessmentPending":"No","AssociationYN":"False","AssociationFee":"0","Basement":"Block","BasementYN":"True","NST_BathDesc":"Main Floor Full Bath","BathroomsFull":"1","BathroomsHalf":"0","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"1","BathroomsTotalInteger":"2","BedroomsTotal":"3","NST_BelowGradeSqFtTotal":"1070","BelowGradeFinishedArea":"288","CumulativeDaysOnMarket":"0","City":"Falcon Heights","NewConstructionYN":"False","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Ramsey","NST_DPResource":"Yes","Directions":"LARPENTEUR WEST OF SNELLING TO FAIRVIEW-NORTH TO HOME","DocumentsCount":"2","DocumentsChangeTimestamp":"2026-05-30T12:05:06.248Z","DaysOnMarket":"0","ExteriorFeatures":"Stone","FireplaceFeatures":"Wood Burning","FireplaceYN":"True","FireplacesTotal":"2","FoundationArea":"1070","FoundationDetails":"Block","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","NST_GarageSquareFeet":"240","GarageSpaces":"1","Heating":"Forced Air","HighSchoolDistrict":"Roseville","NST_ForeclosureStatus":"No","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"True","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","Latitude":"44.99823","LaundryFeatures":"Lower Level","NST_LenderOwned":"No","Levels":"One","ListPrice":"379000","ListingContractDate":"2026-05-30T05:00:00Z","ListingId":"NST7083594","LivingArea":"1358","LockBoxType":"Combo","Longitude":"-93.177443","LotSizeArea":"0.365","LotSizeDimensions":"102x156","LotSizeUnits":"Acres","NST_MainLevelFinishedArea":"1070","NST_ManufacturedHome":"N","OriginalEntryTimestamp":"2026-05-30T06:55:56Z","ParcelNumber":"162923310011","ParkingFeatures":"Attached Garage","PhotosCount":"15","PhotosChangeTimestamp":"2026-05-30T12:27:06.474Z","PostalCity":"Saint Paul","PostalCode":"55113","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PropertyAttachedYN":"False","PropertySubType":"Single Family","PropertyType":"Residential","PublicRemarks":"Charming brick rambler across from the U of M. Fields, walking distance to St. Paul campus. This home features two wood burning fireplaces, master bath and a beautiful yard.","PublicSurveyRange":"23","PublicSurveySection":"16","PublicSurveyTownship":"29","NST_SchoolDistrictFullName":"623 - Roseville","NST_SchoolDistrictNumber":"623","NST_SchoolDistrictPhone":"6516351600","Sewer":"City Sewer/Connected","StandardStatus":"Active","StateOrProvince":"MN","StreetDirSuffix":"N","StreetName":"Fairview","StreetNumber":"1895","StreetNumberNumeric":"1895","StreetSuffix":"Avenue","SubdivisionName":"Section 16 Town 29 Range 23","TaxAnnualAmount":"5296","NST_TaxWithAssessments":"5296","TaxYear":"2025","NST_TotalArea":"2140","BuildingAreaTotal":"2140","Township":"Falcon Heights","VideosCount":"0","WaterSource":"City Water/Connected","WaterfrontYN":"False","YearBuilt":"1945","ZoningDescription":"Residential-Single Family","ListAgentKey":"NST39276","ListAgentMlsId":"NST502006614","ListOfficeMlsId":"NST40766","ListOfficeName":"Latigo Leasing & Sales","ListOfficeKey":"NST19654","ModificationTimestamp":"2026-06-23T14:45:07.281Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7909993\",\"Order\":13,\"MediaObjectID\":\"NST13\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7909993/ac32d88b-625c-43d5-afad-22ce5aab8917.jpeg\",\"LongDescription\":\"fffff.jpg\",\"ImageWidth\":1200,\"ImageHeight\":800,\"ImageSizeDescription\":\"1200x800\",\"MediaModificationTimestamp\":\"2026-05-30T12:27:06.164Z\",\"MediaKey\":\"NST122596333\"},{\"ResourceRecordKey\":\"NST7909993\",\"Order\":7,\"MediaObjectID\":\"NST7\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7909993/805675a6-d698-49e1-8fc7-6da687bc5eaf.jpeg\",\"LongDescription\":\"ffffffff.jpg\",\"ImageWidth\":1200,\"ImageHeight\":800,\"ImageSizeDescription\":\"1200x800\",\"MediaModificationTimestamp\":\"2026-05-30T12:27:06.181Z\",\"MediaKey\":\"NST122596330\"},{\"ResourceRecordKey\":\"NST7909993\",\"Order\":9,\"MediaObjectID\":\"NST9\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7909993/b3bbdb3e-c1ab-4d43-908d-23aaaca17e9a.jpeg\",\"LongDescription\":\"fffffffffffffff.jpg\",\"ImageWidth\":1200,\"ImageHeight\":800,\"ImageSizeDescription\":\"1200x800\",\"MediaModificationTimestamp\":\"2026-05-30T12:27:06.178Z\",\"MediaKey\":\"NST122596323\"},{\"ResourceRecordKey\":\"NST7909993\",\"Order\":15,\"MediaObjectID\":\"NST15\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7909993/5f111c0c-4cfe-4cb9-af9c-2895535a4d34.jpeg\",\"LongDescription\":\"ffffffffff.jpg\",\"ImageWidth\":1200,\"ImageHeight\":800,\"ImageSizeDescription\":\"1200x800\",\"MediaModificationTimestamp\":\"2026-05-30T12:27:06.16Z\",\"MediaKey\":\"NST122596328\"},{\"ResourceRecordKey\":\"NST7909993\",\"Order\":14,\"MediaObjectID\":\"NST14\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7909993/6a703d17-ab0e-4e68-8673-cf05fb26eb11.jpeg\",\"LongDescription\":\"ffffff.jpg\",\"ImageWidth\":1200,\"ImageHeight\":800,\"ImageSizeDescription\":\"1200x800\",\"MediaModificationTimestamp\":\"2026-05-30T12:27:06.18Z\",\"MediaKey\":\"NST122596332\"},{\"ResourceRecordKey\":\"NST7909993\",\"Order\":10,\"MediaObjectID\":\"NST10\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7909993/60ddcb47-edec-45a7-a47e-9cebe8791724.jpeg\",\"LongDescription\":\"ffffffffffffffff.jpg\",\"ImageWidth\":1200,\"ImageHeight\":800,\"ImageSizeDescription\":\"1200x800\",\"MediaModificationTimestamp\":\"2026-05-30T12:27:06.168Z\",\"MediaKey\":\"NST122596322\"},{\"ResourceRecordKey\":\"NST7909993\",\"Order\":5,\"MediaObjectID\":\"NST5\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7909993/dae6cc79-37ea-4c05-9c82-338cdf903e81.jpeg\",\"LongDescription\":\"ffffffffffff.jpg\",\"ImageWidth\":1200,\"ImageHeight\":800,\"ImageSizeDescription\":\"1200x800\",\"MediaModificationTimestamp\":\"2026-05-30T12:27:06.18Z\",\"MediaKey\":\"NST122596326\"},{\"ResourceRecordKey\":\"NST7909993\",\"Order\":11,\"MediaObjectID\":\"NST11\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7909993/d7a060b4-f00d-4778-bf24-4a8db500c43d.jpeg\",\"LongDescription\":\"fffffffffffff.jpg\",\"ImageWidth\":1200,\"ImageHeight\":800,\"ImageSizeDescription\":\"1200x800\",\"MediaModificationTimestamp\":\"2026-05-30T12:27:06.243Z\",\"MediaKey\":\"NST122596325\"},{\"ResourceRecordKey\":\"NST7909993\",\"Order\":8,\"MediaObjectID\":\"NST8\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7909993/6d02f8bd-4fcb-4cb4-a8d2-19e4fbc76845.jpeg\",\"LongDescription\":\"fffffffff.jpg\",\"ImageWidth\":1200,\"ImageHeight\":800,\"ImageSizeDescription\":\"1200x800\",\"MediaModificationTimestamp\":\"2026-05-30T12:27:06.168Z\",\"MediaKey\":\"NST122596329\"},{\"ResourceRecordKey\":\"NST7909993\",\"Order\":3,\"MediaObjectID\":\"NST3\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7909993/4ffab251-98b8-4c5f-9082-e57951890f44.jpeg\",\"LongDescription\":\"ffffffffffffff.jpg\",\"ImageWidth\":1200,\"ImageHeight\":800,\"ImageSizeDescription\":\"1200x800\",\"MediaModificationTimestamp\":\"2026-05-30T12:27:06.173Z\",\"MediaKey\":\"NST122596324\"},{\"ResourceRecordKey\":\"NST7909993\",\"Order\":6,\"MediaObjectID\":\"NST6\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7909993/c7c7b9d4-f26d-488b-ae46-b91e84b9ee3a.jpeg\",\"LongDescription\":\"fffffff.jpg\",\"ImageWidth\":1200,\"ImageHeight\":800,\"ImageSizeDescription\":\"1200x800\",\"MediaModificationTimestamp\":\"2026-05-30T12:27:06.175Z\",\"MediaKey\":\"NST122596331\"},{\"ResourceRecordKey\":\"NST7909993\",\"Order\":12,\"MediaObjectID\":\"NST12\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7909993/09123ea4-9c93-4b95-8244-08090a16caf9.jpeg\",\"LongDescription\":\"ffff.jpg\",\"ImageWidth\":1200,\"ImageHeight\":800,\"ImageSizeDescription\":\"1200x800\",\"MediaModificationTimestamp\":\"2026-05-30T12:27:06.16Z\",\"MediaKey\":\"NST122596334\"},{\"ResourceRecordKey\":\"NST7909993\",\"Order\":4,\"MediaObjectID\":\"NST4\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7909993/dc8c214d-683d-4fcb-a49a-1d12580b5373.jpeg\",\"LongDescription\":\"fffffffffff.jpg\",\"ImageWidth\":1200,\"ImageHeight\":800,\"ImageSizeDescription\":\"1200x800\",\"MediaModificationTimestamp\":\"2026-05-30T12:27:06.198Z\",\"MediaKey\":\"NST122596327\"},{\"ResourceRecordKey\":\"NST7909993\",\"Order\":1,\"MediaObjectID\":\"NST1\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7909993/b6b58367-78e9-46ef-9240-91c68abb58bb.jpeg\",\"LongDescription\":\"fff.jpg\",\"ImageWidth\":1200,\"ImageHeight\":800,\"ImageSizeDescription\":\"1200x800\",\"MediaModificationTimestamp\":\"2026-05-30T12:27:06.198Z\",\"MediaKey\":\"NST122596335\"},{\"ResourceRecordKey\":\"NST7909993\",\"Order\":2,\"MediaObjectID\":\"NST2\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7909993/a2f67eda-70bc-4be1-b598-b23b98e73c75.jpeg\",\"LongDescription\":\"ff.jpg\",\"ImageWidth\":1200,\"ImageHeight\":800,\"ImageSizeDescription\":\"1200x800\",\"MediaModificationTimestamp\":\"2026-05-30T12:27:06.246Z\",\"MediaKey\":\"NST122596336\"}]","Media__ResourceRecordKey":"NST7909993","Media__Order":"13","Media__MediaObjectID":"NST13","Media__MediaURL":"https://s3.amazonaws.com/mlsgrid/images/NST7909993/ac32d88b-625c-43d5-afad-22ce5aab8917.jpeg","Media__LongDescription":"fffff.jpg","Media__ImageWidth":"1200","Media__ImageHeight":"800","Media__ImageSizeDescription":"1200x800","Media__MediaModificationTimestamp":"5/30/2026 12:27:06 PM","Media__MediaKey":"NST122596333","Rooms":"[{\"RoomType\":\"Family Room\",\"RoomKey\":\"NST116294891\",\"RoomDimensions\":\"12x24\",\"RoomLevel\":\"Lower\",\"NST_RoomSortOrder\":2},{\"RoomType\":\"Bedroom\",\"RoomKey\":\"NST116294892\",\"RoomDimensions\":\"12x16\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":3},{\"RoomType\":\"Living Room\",\"RoomKey\":\"NST116294890\",\"RoomDimensions\":\"12x20\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":1},{\"RoomType\":\"Bedroom 2\",\"RoomKey\":\"NST116294893\",\"RoomDimensions\":\"9x12\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":4}]","Rooms__RoomType":"Family Room","Rooms__RoomKey":"NST116294891","Rooms__RoomDimensions":"12x24","Rooms__RoomLevel":"Lower","Rooms__NST_RoomSortOrder":"2","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"fff.jpg\"},{\"Order\":2,\"Remarks\":\"ff.jpg\"},{\"Order\":3,\"Remarks\":\"ffffffffffffff.jpg\"},{\"Order\":4,\"Remarks\":\"fffffffffff.jpg\"},{\"Order\":5,\"Remarks\":\"ffffffffffff.jpg\"},{\"Order\":6,\"Remarks\":\"fffffff.jpg\"},{\"Order\":7,\"Remarks\":\"ffffffff.jpg\"},{\"Order\":8,\"Remarks\":\"fffffffff.jpg\"},{\"Order\":9,\"Remarks\":\"fffffffffffffff.jpg\"},{\"Order\":10,\"Remarks\":\"ffffffffffffffff.jpg\"},{\"Order\":11,\"Remarks\":\"fffffffffffff.jpg\"},{\"Order\":12,\"Remarks\":\"ffff.jpg\"},{\"Order\":13,\"Remarks\":\"fffff.jpg\"},{\"Order\":14,\"Remarks\":\"ffffff.jpg\"},{\"Order\":15,\"Remarks\":\"ffffffffff.jpg\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15","CustomVTourURL":""}