SELECT tree_node.*, tree_node.last_update as tree_node_last_update, translation_name_fr.content AS name_fr, translation_name_en.content AS name_en, boa_stain.*, boa_stain.last_update as boa_stain_last_update FROM boa_stain INNER JOIN tree_node ON boa_stain.cp = tree_node.cp LEFT JOIN translation as translation_name_fr ON (translation_name_fr.cp = tree_node.name AND translation_name_fr.language = 'fr') LEFT JOIN translation as translation_name_en ON (translation_name_en.cp = tree_node.name AND translation_name_en.language = 'en') WHERE parent != '904c6e5701621a78b00b80a2cd178b46' AND (usable_warranty = 1 OR boa_stain.import_key = '00') ORDER BY name_en ASC
Indicate who was most influential in choosing your floor (select one per answer).
Thanks
Shop now
Muskoka Hardwood Flooring products are discontinued, please visit our other brand, Vintage Hardwood Flooring.
For more information, please submit your request and we will be glad to assist you finding a similar product.