Back To Top

Portfolio

SELECT p.*, pt.portfolio_tag_word, pc.portfolio_category_safe_title FROM portfolio AS p LEFT JOIN portfolio_category AS pc ON pc.portfolio_category_id = p.portfolio_category_id LEFT JOIN portfolio_tag AS pt ON pt.portfolio_id = p.portfolio_id WHERE pc.portfolio_category_safe_title = '25-kenmir-ave' AND pc.portfolio_category_active = 1 AND p.portfolio_active = 1 GROUP BY p.portfolio_id ORDER BY p.portfolio_sort_order ASC, p.portfolio_title LIMIT 0, 9

Under constructionnnn. Please check back later!

Associations

Niagara Home Builders AssociationOntario Home Builders AssociationTarionNiagara Construction Association
Ready to take
the next step?

Your dream home is closer than you think.
Book your free consultation with our team today to get started.

Let's Get Started or call 905 262 1887