Joining to queries into one

[eWish]

I am not sure that I am taking the proper approach or even have the best design for what I am doing.

I have a table that I am storing attributes the for a real estate property listing. Each property could have one or several (many to many) attributes. Then I am storing the non-redundant data in the listing table. Instead of using two queries to get the listing and attribute data I would like to be able to do it in one without having duplicate data. I have tried a UNION but the SELECT statements have a different number of columns.

SELECT  listing.mlsID AS 'MLS Number',
        listing.propertyAddress AS 'Property Address',
        listing.description AS 'Property Description',
        listing.city AS 'City',
        listing.county AS 'County',
        listing.state AS 'State',
        listing.zipcode AS 'Zipcode',
        listing.listPrice AS 'List Price',
        IFNULL(listing.heatedFT, 'N/A') AS 'Heated SqFt.',
        IFNULL(listing.totalFT, 'N/A') AS 'Total SqFt.',
        IFNULL(listing.acres, 'N/A') AS 'Acres',
        IFNULL(listing.lotSize, 'N/A') AS 'Lot Size',
        IFNULL(listing.lotDescription, 'N/A') AS 'Lot Description',
        IFNULL(listing.lotDimensions, 'N/A') AS 'Lot Dimensions',
        IFNULL(listing.yearBuilt, 'N/A') AS 'Year Built',
        listing.imageDIR AS 'Image Directory',
        IFNULL(listing.directions, 'N/A') AS 'Directions',
        IFNULL(listing.virtualTourUrl, 'N/A') AS 'Virtual Tour URL'
FROM re_listings AS listing
WHERE listing.mlsID = 555
ORDER BY listing.mlsID, listing.city ASC

SELECT  category.name AS 'Category Name', 
        attribute.name AS 'Attribute Name'
FROM re_attributeCategory AS category
INNER JOIN re_attribute AS attribute ON attribute.categoryID = category.id
INNER JOIN re_attributeID AS id ON id.attributeID = attribute.id
WHERE id.mlsID = 555
ORDER BY category.name ASC

Any suggestions would be appreciated.