SELECT M_TITLE.id, M_TITLE.m_title, M_TITLE.bdisplay, M_TITLE.t_type
FROM M_TITLE
WHERE M_TITLE.id REGEXP '[[:<:]]WAUUlarocheAlbum'
AND M_TITLE.m_title != '
'
AND M_TITLE.bsearch=0
AND M_TITLE.bdisplay=0
GROUP BY M_TITLE.id
ORDER BY M_TITLE.m_title limit 0,12
elapsed time: 0.34867215156555
Blank certificate share form for the Lake Union Improvement Company.
|
Engraved portrait of Luther H. Griffith, ca. 1891.
|
King St. coal wharves of the Oregon Improvement Company, Seattle, Washington, 1891.
|
Letter explaining the history and advantages of investing in the Lake Union Improvement Company.
|
Looking east on Pike St. from near 3rd Ave., Seattle, Washington, ca. 1891.
|
Looking north along the tracks of the Seattle Electric Railway and Power Company, west end of Lake Union, Seattle, Washington, ca. 1891.
|
Looking north from near 5th Ave. and Stewart St. toward Lake Union, Seattle, Washington, ca. 1891.
|
Looking north from near 5th Ave. and Stewart St. toward Lake Union, Seattle, Washington, ca. 1891.
|
Looking north on 1st Ave. from James St., Seattle, Washington, May 1891.
|
Looking north toward the Denny Hotel on 3rd Ave. from near Union St., Seattle, Washington, 1891.
|
Looking northeast on James St. and Yesler Way from Pioneer Square, Seattle, Washington, May 1891.
|
Looking south on 1st Ave. from near Columbia St. toward Pioneer Square, Seattle, Washington, May 1891.
|
1 |2 |3 |
|
|
