Get in touch

Interested to know more? Come and visit us in person. We’d be delighted to show you around.

Office: (07) 548 1100
Sales: (07) 548 1170 or Free Phone 0508 623 623
Village Manager: Kevin Searle – 021 184 3028
Visit: Cnr Omokoroa Rd and Anderley Ave Omokoroa, Tauranga, New Zealand
Postal: Private Bag 12026, Tauranga 3143

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 20]
SELECT `mc`.`category_id`, `mc`.`name` AS 'category', `mc`.`imported`, `mc`.`deleted` AS 'cat_deleted', `m`.`marker_id`, `m`.`img_binary`, `m`.`width`, `m`.`height`, `m`.`left_offset`, `m`.`top_offset`, `m`.`link`, `m`.`primary_colour`, `m`.`secondary_colour`, `m`.`deleted` FROM `wp_hmapsprem_markers` `m` INNER JOIN `wp_hmapsprem_marker_categories` `mc` ON(`mc`.`category_id` = `m`.`category_id`) WHERE `m`.`marker_id` IN();