Properties by Hanssen

Using query: select resname, propmain.address, city, statecd, architect from propmain, architect,county where propmain.refnum = county.refnum and propmain.refnum = architect.refnum and architect like '%Hanssen%' and certcd = 'LI' order by resname;

[[Buffalo High School]], 326 E 4th St. [[Buffalo, IA]] Hanssen, Gustav
[[Oak Lane Historic District]], Oak Lane between High and Locust Sts. [[Davenport, IA]] Hanssen,Gustav
[[John C. Schricker House]], 1446 Clay St. [[Davenport, IA]] Hanssen,Gustav
[[E. A. Shaw House]], 1102 College Ave. [[Davenport, IA]] Hanssen,Gustave A.
[[Yuma County Courthouse]], 168 S. 2nd Ave. [[Yuma, AZ]] Swearingen,Ralph & Hanssen,G.A.

Note: The National Register database lists the last name first, and there may not always be a space between names. It's best to use lastname%firstname for searches.

Enter an architect to search for:


Database version: 2014 2010
Output in Wiki markup: