How to Query the Price for a Product

I have a custom page on which I would like to display the prices for several products. Instead of just hardcoding the prices for these products, I would prefer to extract their prices from the SQL. Is there a simple or fairly simple way of doing this? Any help would be great!
Thanks

There are a lot of functions in the /includes/functions/functions_prices.php

Peek at some of the other pages such as the listings, product _info and sideboxes to see how the prices are actually pulled ...

This should give you quite a variaty of how these functions are used in the various areas so you can determin a Product Price ...

Example, peek in the /includes/modules/sideboxes/featured.php

Notice how the Product Price is grabbed with the function:

$featured_box_price = zen_get_products_display_price($random_featured_product->fields['products_id']);