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 '%lavalle%' and certcd = 'LI' order by resname;
[[Amory House]], Off Old Troy Rd. [[Dublin, NH]] Lavalle,JohnNote: 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: