Error Querying the Database: Unknown column 'd.dome_id' in 'on clause' Please report this error to the webmaster. Query was:
SELECT d.dome_id AS id, CONCAT(d.dome_diam,'\' dia. ',
d.dome_profile,'-Profile') AS size, FORMAT(d.dome_sqft,0) AS sqft, d.dome_des2 AS des2,
d.dome_des AS des, CONCAT(p.place_city,', ',p.place_state_abbr) AS place,
i.image_file AS image, d.dome_map_link AS map_link,
d.dome_size_des AS size_des, d.dome_size_link AS size_link,
d.dome_sqft_des AS sqft_des, d.dome_sqft_link AS sqft_link,
d.dome_link_des AS link_des, d.dome_link AS link_url, d.dome_link2_des AS link2_des, d.dome_link2 AS link2_url,
COUNT(di.image_id) AS pics, d.dome2_diam AS diam2
FROM domes_const AS d, place AS p
LEFT JOIN const_images AS di ON di.dome_id = d.dome_id
LEFT JOIN images AS i ON i.image_id = d.image_id
WHERE p.place_state = 'Colorado' AND d.place_id = p.place_id AND d.mark = 'construction'
GROUP BY d.dome_id ORDER BY d.featured ASC, p.place_city ASC
These domes are currently being finished or have been completed. The photo on the right shows Elsa and Ted's dome home in Fairfax, Va. To see the rest of their photos, click here.
Contact us if you would like to visit any of these domes. Also, if you have any questions relating to these domes or the dome experience in general, please call us at 1-800-733-7107.
This list of completed Natural Spaces domes is not completed. We will be adding more domes to this list, many with photos. Our main dome database has many more domes. The domes listed here are most of the domes we manufactured or renovated.