Data Explorer
Query the US Nationwide Parcel Dataset
$1.75 / 1,000 records$100 minimum
38/80
Live SQL
SELECT * FROM "lr_parcel_us" WHERE statefp = '41' AND countyfp = '009'
28,757 matching parcels
Data Preview
parcelid | taxacctnum | statefp | countyfp | parceladdr | parcelcity | parcelstate | parcelzip | ownername | owneraddr | ownercity | ownerstate | ownerzip | countyname | cousubfp | cousubname | tractce | tractname | calcarea | imprvalue | landvalue | agvalue | totalvalue | saleamt | saledate | numbldgs | numunits | yearbuilt | numfloors | bldgsqft | bedrooms | halfbaths | fullbaths | firmid | firmdate | fldzone | zonesubty | staticbfe | elevmin | elevmax | elevavg | usecode | usedesc | zoningcode | zoningdesc | taxacres | ownertype | naicscode | legaldesc | township | section | qtrsection | range | plssdesc | book | page | parceltype | accesstype | iucnclass | placename | placetype | fireplaces | heating | heatfuel | cooling | foundation | roofcover | siding | lrversion | taxyear | taxdistrict | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4N4W 3BC 3000 | 22425 | 41 | 009 | 1130 DOUGLAS ST | VERNONIA | OR | 97064 | ALEXANDER CHRISTIAN J & LADUE M… | 1130 DOUGLAS ST | VERNONIA | OR | 97064 | COLUMBIA | 93332 | VERNONIA | 971100 | 9711 | 924.7981 | 1 | 1 | 10000 | 41009C | 2025-12-17 | AE | 0 | PERSON | GOVT FEDERAL | RESTRICTED | OTHER | NEHALEM RIVER | WILD AND SCENIC RIVER | 2026.2 | |||||||||||||||||||||||||||||||||||||||
| 7N2W16DB13200 | 18250 | 41 | 009 | OR | MCCOLLAM WILLARD E & KATHRYN S | PO BOX 1022 | RAINIER | OR | 97048 | COLUMBIA | 92601 | RAINIER | 970300 | 9703 | 511.0719 | 1 | 1 | 5500 | 41009C | 2025-12-17 | X | AREA OF MINIMAL FLOOD HAZARD | 16.4429 | 18.5894 | 17.3962 | 1020 | TRANSFER ON DEATH DEED RECORDED | 0 | PERSON | 2026.2 | |||||||||||||||||||||||||||||||||||||||||
| 3N1W1700 203 | 5314 | 41 | 009 | 35792 RIVERSIDE LN | SCAPPOOSE | OR | 97056 | LOOS TONY P | 35800 RIVERSIDE LN | SCAPPOOSE | OR | 97056 | COLUMBIA | 92805 | SCAPPOOSE | 970900 | 9709 | 11635.8240 | 1 | 1 | 0 | 41009C | 2025-12-17 | X | AREA WITH REDUCED FLOOD RISK DU… | 012 | FARM POTENTIAL ADDITIONAL TAX L… | 2.8000 | PERSON | 2026.2 | |||||||||||||||||||||||||||||||||||||||||
| 4N1W 7BA 504 | 16819 | 41 | 009 | 58841 WARD DR | ST HELENS | OR | 97051 | EVANS SALLY | 58841 WARD DR | ST HELENS | OR | 97051 | COLUMBIA | 92703 | ST. HELENS | 970600 | 9706 | 4060.6590 | 1 | 1 | 0 | 41009C | 2025-12-17 | X | AREA OF MINIMAL FLOOD HAZARD | 1020 | TRANSFER ON DEATH DEED RECORDED | 1 | PERSON | 2026.2 | |||||||||||||||||||||||||||||||||||||||||
| 5N2W2300 200 | 16139 | 41 | 009 | 32936 SMITH RD | ST HELENS | OR | 97051 | MARTIN MATTHEW | 32936 SMITH RD | ST HELENS | OR | 97051 | COLUMBIA | 92703 | ST. HELENS | 970500 | 9705 | 18386.3817 | 1 | 1 | 0 | 41009C | 2025-12-17 | X | AREA OF MINIMAL FLOOD HAZARD | 014 | FOREST POTENTIAL ADDITIONAL TAX… | 5.0500 | PERSON | 2026.2 | |||||||||||||||||||||||||||||||||||||||||
| 7N3W15B0 2200 | 20773 | 41 | 009 | 75724 PRICE RD | RAINIER | OR | 97048 | DUBOIS ROLAND J & SHIRLEY M | 75724 PRICE RD | RAINIER | OR | 97048 | COLUMBIA | 90544 | CLATSKANIE | 970201 | 9702.0100 | 10640.5364 | 1 | 1 | 0 | 41009C | 2025-12-17 | X | AREA OF MINIMAL FLOOD HAZARD | 099 | FIRE PATROL | 2.5700 | PERSON | 2026.2 | |||||||||||||||||||||||||||||||||||||||||
| 7N2W19B0 700 | 19595 | 41 | 009 | 74570 DOAN RD | RAINIER | OR | 97048 | DYKSTRA LESLIE A & SPOTO SUSAN … | 74570 DOAN RD | RAINIER | OR | 97048 | COLUMBIA | 92601 | RAINIER | 970300 | 9703 | 28551.3752 | 1 | 1 | 0 | 41009C | 2025-12-17 | X | AREA OF MINIMAL FLOOD HAZARD | 014 | FOREST POTENTIAL ADDITIONAL TAX… | 7.0600 | PERSON | 2026.2 | |||||||||||||||||||||||||||||||||||||||||
| 5N2W2000 901 | 16115 | 41 | 009 | 62040 CONIBEAR RD | ST HELENS | OR | 97051 | WILLIAMS TYMITHY & KENNETH & CH… | 8350 SW BARBOR BLVD | PORTLAND | OR | 97219 | COLUMBIA | 92703 | ST. HELENS | 970500 | 9705 | 23297.5906 | 1 | 1 | 0 | 41009C | 2025-12-17 | X | AREA OF MINIMAL FLOOD HAZARD | 012 | FARM POTENTIAL ADDITIONAL TAX L… | 5.4800 | PERSON | 2026.2 | |||||||||||||||||||||||||||||||||||||||||
| 3N2W24B0 600 | 7120 | 41 | 009 | 50988 LAAS DR | SCAPPOOSE | OR | 97056 | REED FAMILY REVOCABLE TRUST | PO BOX 859 | SCAPPOOSE | OR | 97056 | COLUMBIA | 92805 | SCAPPOOSE | 971000 | 9710 | 25107.1964 | 1 | 1 | 0 | 41009C | 2025-12-17 | X | AREA OF MINIMAL FLOOD HAZARD | 012 | FARM POTENTIAL ADDITIONAL TAX L… | 6.2000 | TRUST | 2026.2 | |||||||||||||||||||||||||||||||||||||||||
| 4N2W 400 200 | 15277 | 41 | 009 | 30383 DOWD RD | ST HELENS | OR | 97051 | NOWAK STEPHEN R JR | 30383 DOWD RD | ST HELENS | OR | 97051 | COLUMBIA | 92703 | ST. HELENS | 970500 | 9705 | 53502.0801 | 1 | 1 | 0 | 41009C | 2025-12-17 | X | AREA OF MINIMAL FLOOD HAZARD | 014 | FOREST POTENTIAL ADDITIONAL TAX… | 13.5000 | PERSON | 2026.2 | |||||||||||||||||||||||||||||||||||||||||
| 3N1W18BB 400 | 2891 | 41 | 009 | 51840 SE 9TH ST | SCAPPOOSE | OR | 97056 | SCHMITT BRIAN R & ROBERT & DIANE | 51840 SE 9TH ST | SCAPPOOSE | OR | 97056 | COLUMBIA | 92805 | SCAPPOOSE | 970900 | 9709 | 557.2698 | 1 | 1 | 6000 | 41009C | 2025-12-17 | X | AREA WITH REDUCED FLOOD RISK DU… | 0 | PERSON | 2026.2 | |||||||||||||||||||||||||||||||||||||||||||
| 3N2W12AD 6516 | 28510 | 41 | 009 | 52674 NE PORTER LN | SCAPPOOSE | OR | 97056 | CHAND JOSEPH SURESH & ROHINI | 52674 NE PORTER LN | SCAPPOOSE | OR | 97056 | COLUMBIA | 92805 | SCAPPOOSE | 970900 | 9709 | 557.4896 | 1 | 1 | 6000 | 41009C | 2025-12-17 | X | AREA OF MINIMAL FLOOD HAZARD | 0 | PERSON | 2026.2 | |||||||||||||||||||||||||||||||||||||||||||
| 3N2W24BD13500 | 7389 | 41 | 009 | 50570 ELDER AVE | SCAPPOOSE | OR | 97056 | CORDELL RONALD W JR | 50570 ELDER AVE | SCAPPOOSE | OR | 97056 | COLUMBIA | 92805 | SCAPPOOSE | 971000 | 9710 | 1300.1112 | 1 | 1 | 0 | 41009C | 2025-12-17 | X | AREA OF MINIMAL FLOOD HAZARD | 0.3200 | PERSON | 2026.2 | |||||||||||||||||||||||||||||||||||||||||||
| 8N4W34CC 400 | 28368 | 41 | 009 | 19051 BEAVER FALLS RD | CLATSKANIE | OR | 97016 | HIX (NEWCOMER) JULIE | 155 HOMETOWN DR | KELSO | WA | 98626 | COLUMBIA | 90544 | CLATSKANIE | 970202 | 9702.0200 | 464.5730 | 1 | 1 | 0 | 41009C | 2025-12-17 | X | AREA OF MINIMAL FLOOD HAZARD | 0.1100 | PERSON | 2026.2 | |||||||||||||||||||||||||||||||||||||||||||
| 7N4W17BB 1100 | 26334 | 41 | 009 | 1465 SW CURTIS CT | CLATSKANIE | OR | 97016 | HOWARD KENDRA KAY | 1465 SW CURTIS CT | CLATSKANIE | OR | 97016 | COLUMBIA | 90544 | CLATSKANIE | 970201 | 9702.0100 | 958.3781 | 1 | 1 | 10312 | 41009C | 2025-12-17 | X | AREA OF MINIMAL FLOOD HAZARD | 0 | PERSON | 2026.2 | |||||||||||||||||||||||||||||||||||||||||||
| 4N1W 3BC 4500 | 9635 | 41 | 009 | 355 PARK WAY | ST HELENS | OR | 97051 | DALIA STEPHANIE NICOLE | 355 PARK WAY | ST HELENS | OR | 97051 | COLUMBIA | 92703 | ST. HELENS | 970700 | 9707 | 511.5369 | 1 | 1 | 5220 | 41009C | 2025-12-17 | X | AREA OF MINIMAL FLOOD HAZARD | 0 | PERSON | 2026.2 | |||||||||||||||||||||||||||||||||||||||||||
| 4N1W 8CD 2100 | 17101 | 41 | 009 | 58010 SHADLEY LN | ST HELENS | OR | 97051 | MEHRER TRUST | 35471 MILLARD RD | WARREN | OR | 97053 | COLUMBIA | 92703 | ST. HELENS | 970600 | 9706 | 2864.4100 | 1 | 1 | 0 | 41009C | 2025-12-17 | X | AREA OF MINIMAL FLOOD HAZARD | 0.8100 | TRUST | 2026.2 | |||||||||||||||||||||||||||||||||||||||||||
| 4N1W 8D0 1300 | 15066 | 41 | 009 | 35840 INDUSTRIAL WAY | ST HELENS | OR | 97051 | ANDERSON'S WESTERN SALES & SUPP… | 34040 E KAPPLER RD | ST HELENS | OR | 97051 | COLUMBIA | 92703 | ST. HELENS | 970600 | 9706 | 7151.3120 | 1 | 1 | 0 | 41009C | 2025-12-17 | X | AREA OF MINIMAL FLOOD HAZARD | 1.7700 | BUSINESS | 2026.2 | |||||||||||||||||||||||||||||||||||||||||||
| 3N2W13C0 4200 | 4845 | 41 | 009 | 51266 SW OLD PORTLAND RD | SCAPPOOSE | OR | 97056 | ISENBERG MATTHEW & NICOLE | 51266 SW OLD PORTLAND RD | SCAPPOOSE | OR | 97056 | COLUMBIA | 92805 | SCAPPOOSE | 971000 | 9710 | 1508.7502 | 1 | 1 | 0 | 41009C | 2025-12-17 | X | AREA OF MINIMAL FLOOD HAZARD | 0.3700 | PERSON | 2026.2 | |||||||||||||||||||||||||||||||||||||||||||
| 3N1W 7BC 2300 | 5676 | 41 | 009 | 52669 NORTH RD | SCAPPOOSE | OR | 97056 | MCKEAN PATRICK DENNIS | 52669 NORTH RD | SCAPPOOSE | OR | 97056 | COLUMBIA | 92805 | SCAPPOOSE | 970900 | 9709 | 696.5352 | 1 | 1 | 0 | 41009C | 2025-12-17 | X | AREA OF MINIMAL FLOOD HAZARD | 0.1700 | PERSON | 2026.2 | |||||||||||||||||||||||||||||||||||||||||||
| 4N1W 4DD 4001 | 11279 | 41 | 009 | 624 S 12TH ST | ST HELENS | OR | 97051 | STUTZMAN FREDERIC | 624 S 12TH ST | ST HELENS | OR | 97051 | COLUMBIA | 92703 | ST. HELENS | 970700 | 9707 | 544.6934 | 1 | 1 | 5800 | 41009C | 2025-12-17 | X | AREA OF MINIMAL FLOOD HAZARD | 0 | PERSON | 2026.2 | |||||||||||||||||||||||||||||||||||||||||||
| 8N4W34C0 1201 | 28364 | 41 | 009 | 19276 BEAVER FALLS RD | CLATSKANIE | OR | 97016 | PARMLEY GERALD RAY & PAMELA K | 19276 BEAVER FALLS RD | CLATSKANIE | OR | 97016 | COLUMBIA | 90544 | CLATSKANIE | 970202 | 9702.0200 | 4071.0920 | 1 | 1 | 0 | 41009C | 2025-12-17 | X | AREA OF MINIMAL FLOOD HAZARD | 1 | PERSON | 2026.2 | |||||||||||||||||||||||||||||||||||||||||||
| 4N1W 8CA 1801 | 29250 | 41 | 009 | 35472 E DIVISION RD | ST HELENS | OR | 97051 | KRH RENTALS LLC | 32506 TIDE CREEK RD | DEER ISLAND | OR | 97054 | COLUMBIA | 92703 | ST. HELENS | 970600 | 9706 | 1123.3038 | 1 | 1 | 0 | 41009C | 2025-12-17 | X | AREA OF MINIMAL FLOOD HAZARD | 0.2900 | BUSINESS | 2026.2 | |||||||||||||||||||||||||||||||||||||||||||
| 5N2W35AA 700 | 17526 | 41 | 009 | 60774 GENSMAN RD | ST HELENS | OR | 97051 | WOLVERT SEAN R | 60774 GENSMAN RD | ST HELENS | OR | 97051 | COLUMBIA | 92703 | ST. HELENS | 970500 | 9705 | 8306.1110 | 1 | 1 | 0 | 41009C | 2025-12-17 | X | AREA OF MINIMAL FLOOD HAZARD | 2.0400 | PERSON | 2026.2 | |||||||||||||||||||||||||||||||||||||||||||
| 4N3W2400 200 | 5053 | 41 | 009 | 27973 BUSH LN | SCAPPOOSE | OR | 97056 | STENCIL STANLEY & STENCIL DOUG … | 27973 BUSH LN | SCAPPOOSE | OR | 97056 | COLUMBIA | 92703 | ST. HELENS | 970500 | 9705 | 5268.9726 | 1 | 1 | 0 | 41009C | 2025-12-17 | X | AREA OF MINIMAL FLOOD HAZARD | 1.3000 | PERSON | 2026.2 |