Thanks to all the postings, I figured this out.
Now have another problem. I got the sql query to pick up exactly what I want except I need it to not show data that is not published. Is this possible? I sure hope so.

Here is my sql query and it works great (will definitely give a big thumbs up in the Joomla extension ratings.)

SELECT
id,
street_num,
street,
street2,
apt,
price,
beds,
baths,
sqft,
lot_acres,
garage_size
FROM jos_iproperty

thanks

Hello,

Send SQL dump of iproperty tables by email so we can help.

Regards,
ARI Soft

Fell dumb, here. Do not know how to do a sql dump. I do know how to get into the database, though.

mphillips wrote:
Fell dumb, here. Do not know how to do a sql dump. I do know how to get into the database, though.

There is usually an SQL export option when using phpMyAdmin.

Lots of choices here - pdf, csv, csv for Excel, sql plus zipped or not and a bunch more??

mphillips wrote:
Lots of choices here - pdf, csv, csv for Excel, sql plus zipped or not and a bunch more??

I'm not sure what exactly you're asking in this post.