{"Id":499481,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST6819958","MLSAGENTID":"NST496502584","MLSCOAGENTID":"NST502046590","MLSOFFICEID":"NST41150","ADDRESS":"697 Tuscarora Avenue","ACRES":0.109,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Full","BATHSTOTAL":2.0,"BEDROOMS":4,"CITY":"Saint Paul","CONTINGENCY":"Inspection","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"FORECLOSURE":"No","LASTPRICE":349900.0,"LASTPRICEDATE":"2025-12-11T00:47:05.37","LATITUDE":44.92347,"LENDEROWNED":"No","LISTDATE":"2025-11-19T06:00:00","LISTPRICE":249900.0,"LIVINGAREA":1644.0,"LONGITUDE":-93.129291,"MODIFICATIONTIMESTAMP":"2025-12-12T19:39:24.781","NEIGHBORHOOD":"103","OFFICE_OFFICENAME":"HOMESTEAD ROAD","PHOTOCOUNT":19,"POSTALCODE":"55102","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Classic brick two-story home full of potential on a spacious lot with mature trees. Inside features vintage details, large windows, and ample space ready for your updates. Enjoy a screened porch and large backyard perfect for relaxing or entertaining. Close to parks, schools, and just minutes from downtown St. Paul. Easy to show, quick close possible. This home is being sold AS-IS","ROADBETWEENWATERFRONTANDHOMEYN":false,"SCHOOLDISTRICTNUMBER":"2102-St. Paul","SCHOOLDISTRICTPHONE":"6517678100","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2025-11-19T20:41:03.94","LASTSTATUS":"Active","STREETNAME":"Tuscarora","STREETNUMBER":"697","STREETSUFFIX":"Avenue","STYLE":"Single Family Residence","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1900,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2025-12-09T15:39:05.414","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"1_697 Tuscarora Ave W (29).jpg\"},{\"Order\":2,\"Remarks\":\"10_697 Tuscarora Ave W (12).jpg\"},{\"Order\":3,\"Remarks\":\"9_697 Tuscarora Ave W (11).jpg\"},{\"Order\":4,\"Remarks\":\"4_697 Tuscarora Ave W (8).jpg\"},{\"Order\":5,\"Remarks\":\"5_697 Tuscarora Ave W (4).jpg\"},{\"Order\":6,\"Remarks\":\"8_697 Tuscarora Ave W (13).jpg\"},{\"Order\":7,\"Remarks\":\"11_697 Tuscarora Ave W (21).jpg\"},{\"Order\":8,\"Remarks\":\"12_697 Tuscarora Ave W (15).jpg\"},{\"Order\":9,\"Remarks\":\"14_697 Tuscarora Ave W (9).jpg\"},{\"Order\":10,\"Remarks\":\"15_697 Tuscarora Ave W (14).jpg\"},{\"Order\":11,\"Remarks\":\"19_697 Tuscarora Ave W (24).jpg\"},{\"Order\":12,\"Remarks\":\"20_697 Tuscarora Ave W (10).jpg\"},{\"Order\":13,\"Remarks\":\"22_697 Tuscarora Ave W (22).jpg\"},{\"Order\":14,\"Remarks\":\"29_697 Tuscarora Ave W (25).jpg\"},{\"Order\":15,\"Remarks\":\"31_697 Tuscarora Ave W (28).jpg\"},{\"Order\":16,\"Remarks\":\"1st_floor_697_west_tuscarora_avenue_saint_paul_with_dim.jpg\"},{\"Order\":17,\"Remarks\":\"2nd_floor_697_west_tuscarora_avenue_saint_paul_with_dim.jpg\"},{\"Order\":18,\"Remarks\":\"3rd_floor_697_west_tuscarora_avenue_saint_paul_with_dim.jpg\"},{\"Order\":19,\"Remarks\":\"all_floors_697_west_tuscarora_avenue_saint_paul_with_dim.jpg\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19","SOURCE":"MG_NST"}
{"ListingKey":"NST7829286","AssociationYN":"False","AssociationFee":"0","Basement":"Full","City":"Saint Paul","Contingency":"Inspection","Directions":"Start from 7th St W & Watson Ave, Head southwest on 7th St W/Fort Rd toward Watson Ave, Turn left onto Tuscarora Ave W, Destination will be on the left","FireplaceYN":"False","NST_Fuel":"Natural Gas","Latitude":"44.92347","ListPrice":"249900","LivingArea":"1644","Longitude":"-93.129291","LotSizeDimensions":"115'x10'x33'x124'x38'","LotSizeUnits":"Acres","ParcelNumber":"112823410162","PostalCity":"Saint Paul","PostalCode":"55102","PublicRemarks":"Classic brick two-story home full of potential on a spacious lot with mature trees. Inside features vintage details, large windows, and ample space ready for your updates. Enjoy a screened porch and large backyard perfect for relaxing or entertaining. Close to parks, schools, and just minutes from downtown St. Paul. Easy to show, quick close possible. This home is being sold AS-IS","PublicSurveyRange":"23","PublicSurveySection":"11","PublicSurveyTownship":"28","NST_SchoolDistrictPhone":"6517678100","Sewer":"City Sewer/Connected","StateOrProvince":"MN","StreetName":"Tuscarora","StreetNumber":"697","StreetNumberNumeric":"697","StreetSuffix":"Avenue","TaxYear":"2024","YearBuilt":"1900","NST_AboveGradeSqFtTotal":"1644","AboveGradeFinishedArea":"1644","AccessibilityFeatures":"None","AdditionalParcelsYN":"False","NST_AgentOwner":"No","LivingAreaUnits":"Square Feet","NST_AssessmentPending":"Unknown","BasementYN":"True","BathroomsFull":"1","BathroomsHalf":"1","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"2","BedroomsTotal":"4","NST_BelowGradeSqFtTotal":"0","BelowGradeFinishedArea":"0","CumulativeDaysOnMarket":"131","NewConstructionYN":"False","Cooling":"Central Air","CountyOrParish":"Ramsey","NST_DPResource":"Yes","DaysOnMarket":"0","FireplacesTotal":"0","FoundationArea":"832","NST_FractionalOwnershipYN":"No","NST_GarageSquareFeet":"360","GarageSpaces":"2","Heating":"Forced Air","HighSchoolDistrict":"St. Paul","NST_ForeclosureStatus":"No","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"False","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","NST_LenderOwned":"No","Levels":"Two","ListingContractDate":"2025-11-19T06:00:00Z","ListingId":"NST6819958","LotSizeArea":"0.109","NST_MainLevelFinishedArea":"832","NST_ManufacturedHome":"N","NST_NeighborhoodNumber":"103","OriginalEntryTimestamp":"2025-11-19T14:34:27Z","NST_SchoolDistrictNumber":"2102","ParkingFeatures":"Detached Garage","PhotosCount":"19","PhotosChangeTimestamp":"2025-12-09T15:39:05.414Z","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PropertyAttachedYN":"False","PropertySubType":"Single Family Residence","PropertyType":"Residential","NST_SpecialSearch":"3 BR on One Level,Main Floor Bedroom","StandardStatus":"Active","SubdivisionName":"Finchs Add","TaxAnnualAmount":"4332","NST_TaxWithAssessments":"4332","Township":"Saint Paul","WaterSource":"City Water/Connected","ZoningDescription":"Residential-Single Family","CoListAgentKey":"NST106953","CoListAgentMlsId":"NST502046590","ListAgentKey":"NST49282","ListAgentMlsId":"NST496502584","ListOfficeMlsId":"NST41150","ListOfficeName":"HOMESTEAD ROAD","ListOfficeKey":"NST21187","ModificationTimestamp":"2025-12-12T19:39:24.781Z","OriginatingSystemName":"northstar","Media":"[{\"Order\":12,\"MediaObjectID\":\"NST12\",\"ResourceRecordKey\":\"NST7829286\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7829286/fc333933-0a7c-4f7e-8a6a-beb5dc990e32.jpeg\",\"LongDescription\":\"20_697 Tuscarora Ave W (10).jpg\",\"ImageWidth\":800,\"ImageHeight\":532,\"ImageSizeDescription\":\"800x532\",\"MediaModificationTimestamp\":\"2025-12-09T15:38:12.624Z\",\"MediaKey\":\"NST119714289\"},{\"Order\":5,\"MediaObjectID\":\"NST5\",\"ResourceRecordKey\":\"NST7829286\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7829286/889736ac-dfed-4636-acfa-bdba4ca722d9.jpeg\",\"LongDescription\":\"5_697 Tuscarora Ave W (4).jpg\",\"ImageWidth\":800,\"ImageHeight\":532,\"ImageSizeDescription\":\"800x532\",\"MediaModificationTimestamp\":\"2025-12-09T15:38:12.638Z\",\"MediaKey\":\"NST119714282\"},{\"Order\":7,\"MediaObjectID\":\"NST7\",\"ResourceRecordKey\":\"NST7829286\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7829286/a45cd68b-3884-4ba1-bf09-69892a5ec8e0.jpeg\",\"LongDescription\":\"11_697 Tuscarora Ave W (21).jpg\",\"ImageWidth\":800,\"ImageHeight\":532,\"ImageSizeDescription\":\"800x532\",\"MediaModificationTimestamp\":\"2025-12-09T15:38:12.625Z\",\"MediaKey\":\"NST119714284\"},{\"Order\":9,\"MediaObjectID\":\"NST9\",\"ResourceRecordKey\":\"NST7829286\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7829286/83a317e8-6fdc-4c5b-8d40-91aa54f634bb.jpeg\",\"LongDescription\":\"14_697 Tuscarora Ave W (9).jpg\",\"ImageWidth\":800,\"ImageHeight\":532,\"ImageSizeDescription\":\"800x532\",\"MediaModificationTimestamp\":\"2025-12-09T15:38:12.633Z\",\"MediaKey\":\"NST119714286\"},{\"Order\":10,\"MediaObjectID\":\"NST10\",\"ResourceRecordKey\":\"NST7829286\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7829286/d58fe6ce-5d15-49d7-99e7-c77ba4ac7ef0.jpeg\",\"LongDescription\":\"15_697 Tuscarora Ave W (14).jpg\",\"ImageWidth\":800,\"ImageHeight\":532,\"ImageSizeDescription\":\"800x532\",\"MediaModificationTimestamp\":\"2025-12-09T15:38:12.632Z\",\"MediaKey\":\"NST119714287\"},{\"Order\":2,\"MediaObjectID\":\"NST2\",\"ResourceRecordKey\":\"NST7829286\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7829286/1f46fc96-467b-4d16-ac56-5db72abcf3ae.jpeg\",\"LongDescription\":\"10_697 Tuscarora Ave W (12).jpg\",\"ImageWidth\":800,\"ImageHeight\":532,\"ImageSizeDescription\":\"800x532\",\"MediaModificationTimestamp\":\"2025-12-09T15:38:12.645Z\",\"MediaKey\":\"NST119714279\"},{\"Order\":8,\"MediaObjectID\":\"NST8\",\"ResourceRecordKey\":\"NST7829286\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7829286/749d3b88-9018-4cf9-ac52-e644d7998041.jpeg\",\"LongDescription\":\"12_697 Tuscarora Ave W (15).jpg\",\"ImageWidth\":800,\"ImageHeight\":532,\"ImageSizeDescription\":\"800x532\",\"MediaModificationTimestamp\":\"2025-12-09T15:38:12.618Z\",\"MediaKey\":\"NST119714285\"},{\"Order\":6,\"MediaObjectID\":\"NST6\",\"ResourceRecordKey\":\"NST7829286\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7829286/f44ca48e-1604-40b5-8f9c-316f26285968.jpeg\",\"LongDescription\":\"8_697 Tuscarora Ave W (13).jpg\",\"ImageWidth\":800,\"ImageHeight\":532,\"ImageSizeDescription\":\"800x532\",\"MediaModificationTimestamp\":\"2025-12-09T15:38:12.664Z\",\"MediaKey\":\"NST119714283\"},{\"Order\":1,\"MediaObjectID\":\"NST1\",\"ResourceRecordKey\":\"NST7829286\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7829286/ec7aa5de-a691-4188-8d39-0dda0f38c6cc.jpeg\",\"LongDescription\":\"1_697 Tuscarora Ave W (29).jpg\",\"ImageWidth\":800,\"ImageHeight\":532,\"ImageSizeDescription\":\"800x532\",\"MediaModificationTimestamp\":\"2025-12-09T15:38:12.621Z\",\"MediaKey\":\"NST119714278\"},{\"Order\":3,\"MediaObjectID\":\"NST3\",\"ResourceRecordKey\":\"NST7829286\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7829286/d36ec534-2539-4e62-8572-8bd2c1d69652.jpeg\",\"LongDescription\":\"9_697 Tuscarora Ave W (11).jpg\",\"ImageWidth\":800,\"ImageHeight\":532,\"ImageSizeDescription\":\"800x532\",\"MediaModificationTimestamp\":\"2025-12-09T15:38:12.639Z\",\"MediaKey\":\"NST119714280\"},{\"Order\":15,\"MediaObjectID\":\"NST15\",\"ResourceRecordKey\":\"NST7829286\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7829286/a2f29b07-36ce-4dbf-8360-f6a15a4e2496.jpeg\",\"LongDescription\":\"31_697 Tuscarora Ave W (28).jpg\",\"ImageWidth\":800,\"ImageHeight\":532,\"ImageSizeDescription\":\"800x532\",\"MediaModificationTimestamp\":\"2025-12-09T15:38:12.621Z\",\"MediaKey\":\"NST119714293\"},{\"Order\":17,\"MediaObjectID\":\"NST17\",\"ResourceRecordKey\":\"NST7829286\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7829286/d80becbe-bab6-43e2-8463-4fefa2c81370.jpeg\",\"LongDescription\":\"2nd_floor_697_west_tuscarora_avenue_saint_paul_with_dim.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2025-12-09T15:38:12.622Z\",\"MediaKey\":\"NST119714685\"},{\"Order\":19,\"MediaObjectID\":\"NST19\",\"ResourceRecordKey\":\"NST7829286\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7829286/5d78153c-3cdf-4ede-89b9-2ce1998b72e2.jpeg\",\"LongDescription\":\"all_floors_697_west_tuscarora_avenue_saint_paul_with_dim.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2025-12-09T15:38:12.629Z\",\"MediaKey\":\"NST119714721\"},{\"Order\":11,\"MediaObjectID\":\"NST11\",\"ResourceRecordKey\":\"NST7829286\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7829286/c9a4229c-a788-4089-9524-9f07163ef611.jpeg\",\"LongDescription\":\"19_697 Tuscarora Ave W (24).jpg\",\"ImageWidth\":800,\"ImageHeight\":532,\"ImageSizeDescription\":\"800x532\",\"MediaModificationTimestamp\":\"2025-12-09T15:38:12.65Z\",\"MediaKey\":\"NST119714288\"},{\"Order\":16,\"MediaObjectID\":\"NST16\",\"ResourceRecordKey\":\"NST7829286\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7829286/d9f69d83-902c-426e-af2f-2dd4bf28b5ff.jpeg\",\"LongDescription\":\"1st_floor_697_west_tuscarora_avenue_saint_paul_with_dim.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2025-12-09T15:38:12.646Z\",\"MediaKey\":\"NST119714682\"},{\"Order\":14,\"MediaObjectID\":\"NST14\",\"ResourceRecordKey\":\"NST7829286\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7829286/f26c23e6-fb31-4fcd-9a40-ed2db1314082.jpeg\",\"LongDescription\":\"29_697 Tuscarora Ave W (25).jpg\",\"ImageWidth\":800,\"ImageHeight\":532,\"ImageSizeDescription\":\"800x532\",\"MediaModificationTimestamp\":\"2025-12-09T15:38:12.643Z\",\"MediaKey\":\"NST119714292\"},{\"Order\":13,\"MediaObjectID\":\"NST13\",\"ResourceRecordKey\":\"NST7829286\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7829286/6f8e8ac8-c778-431d-8737-f93af6b60914.jpeg\",\"LongDescription\":\"22_697 Tuscarora Ave W (22).jpg\",\"ImageWidth\":800,\"ImageHeight\":532,\"ImageSizeDescription\":\"800x532\",\"MediaModificationTimestamp\":\"2025-12-09T15:38:12.625Z\",\"MediaKey\":\"NST119714290\"},{\"Order\":18,\"MediaObjectID\":\"NST18\",\"ResourceRecordKey\":\"NST7829286\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7829286/d61315fd-635a-4f74-b0dc-5c4fcfa4b87b.jpeg\",\"LongDescription\":\"3rd_floor_697_west_tuscarora_avenue_saint_paul_with_dim.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2025-12-09T15:38:12.628Z\",\"MediaKey\":\"NST119714689\"},{\"Order\":4,\"MediaObjectID\":\"NST4\",\"ResourceRecordKey\":\"NST7829286\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7829286/03727104-10db-452c-950d-938c35adfb3a.jpeg\",\"LongDescription\":\"4_697 Tuscarora Ave W (8).jpg\",\"ImageWidth\":800,\"ImageHeight\":532,\"ImageSizeDescription\":\"800x532\",\"MediaModificationTimestamp\":\"2025-12-09T15:38:12.614Z\",\"MediaKey\":\"NST119714281\"}]","Rooms":"[{\"RoomDimensions\":\"13x8\",\"RoomKey\":\"NST115788402\",\"RoomType\":\"Bedroom 4\",\"NST_RoomSortOrder\":7,\"RoomLevel\":\"Upper\"},{\"RoomDimensions\":\"10x11\",\"RoomKey\":\"NST115788403\",\"RoomType\":\"Bathroom\",\"NST_RoomSortOrder\":8,\"RoomLevel\":\"Upper\"},{\"RoomDimensions\":\"9x11\",\"RoomKey\":\"NST115788400\",\"RoomType\":\"Bedroom 2\",\"NST_RoomSortOrder\":5,\"RoomLevel\":\"Main\"},{\"RoomDimensions\":\"9x11\",\"RoomKey\":\"NST115788401\",\"RoomType\":\"Bedroom 3\",\"NST_RoomSortOrder\":6,\"RoomLevel\":\"Upper\"},{\"RoomDimensions\":\"15x13\",\"RoomKey\":\"NST115788398\",\"RoomType\":\"Kitchen\",\"NST_RoomSortOrder\":3,\"RoomLevel\":\"Main\"},{\"RoomDimensions\":\"19x13\",\"RoomKey\":\"NST115788399\",\"RoomType\":\"Bedroom\",\"NST_RoomSortOrder\":4,\"RoomLevel\":\"Upper\"},{\"RoomDimensions\":\"9x11\",\"RoomKey\":\"NST115788396\",\"RoomType\":\"Living Room\",\"NST_RoomSortOrder\":1,\"RoomLevel\":\"Main\"},{\"RoomDimensions\":\"13x11\",\"RoomKey\":\"NST115788397\",\"RoomType\":\"Dining Room\",\"NST_RoomSortOrder\":2,\"RoomLevel\":\"Main\"}]","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"1_697 Tuscarora Ave W (29).jpg\"},{\"Order\":2,\"Remarks\":\"10_697 Tuscarora Ave W (12).jpg\"},{\"Order\":3,\"Remarks\":\"9_697 Tuscarora Ave W (11).jpg\"},{\"Order\":4,\"Remarks\":\"4_697 Tuscarora Ave W (8).jpg\"},{\"Order\":5,\"Remarks\":\"5_697 Tuscarora Ave W (4).jpg\"},{\"Order\":6,\"Remarks\":\"8_697 Tuscarora Ave W (13).jpg\"},{\"Order\":7,\"Remarks\":\"11_697 Tuscarora Ave W (21).jpg\"},{\"Order\":8,\"Remarks\":\"12_697 Tuscarora Ave W (15).jpg\"},{\"Order\":9,\"Remarks\":\"14_697 Tuscarora Ave W (9).jpg\"},{\"Order\":10,\"Remarks\":\"15_697 Tuscarora Ave W (14).jpg\"},{\"Order\":11,\"Remarks\":\"19_697 Tuscarora Ave W (24).jpg\"},{\"Order\":12,\"Remarks\":\"20_697 Tuscarora Ave W (10).jpg\"},{\"Order\":13,\"Remarks\":\"22_697 Tuscarora Ave W (22).jpg\"},{\"Order\":14,\"Remarks\":\"29_697 Tuscarora Ave W (25).jpg\"},{\"Order\":15,\"Remarks\":\"31_697 Tuscarora Ave W (28).jpg\"},{\"Order\":16,\"Remarks\":\"1st_floor_697_west_tuscarora_avenue_saint_paul_with_dim.jpg\"},{\"Order\":17,\"Remarks\":\"2nd_floor_697_west_tuscarora_avenue_saint_paul_with_dim.jpg\"},{\"Order\":18,\"Remarks\":\"3rd_floor_697_west_tuscarora_avenue_saint_paul_with_dim.jpg\"},{\"Order\":19,\"Remarks\":\"all_floors_697_west_tuscarora_avenue_saint_paul_with_dim.jpg\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19","CustomVTourURL":""}