How to load Product from nid

How Can I load a Product from the db based on the nid?

$product = db_fetch_object(db_query("SELECT * FROM {uc_products} WHERE nid = '%s'", *nid here*));

print_r($product);