Main Content
This is luxury defined. Nestled in an exclusive cul-de-sac in Fonthill, this custom built, less than 3 year old bungalow boasts nearly 4,500 square foot of masterfully finished living space (2415 up and another approximately 2000 square feet below), a gourmet custom kitchen with high-end appliances (Dacor), Cambria quartz countertops throughout the house, hardwood floors, open concept living plan, soaring coffered ceilings in the living room & formal dining room
5 bedrooms (3+2), 4 bathrooms (3+1) in total, a fully finished basement, 14 foot ceiling in entry, 12 foot ceiling in living room, 9 foot ceilings and 8 foot custom doors throughout the rest of the home, professionally landscaped yard, oversized double car garage, jaw-dropping curb appeal and SO much more. Life in 'The Hill' is second to none, Lookout Point Country Club is in your 'backyard' and life on this sought after street is exactly what you and your family deserve. Features Interior: Hot Tub
Get Exclusive Access about Featured Listings, Insider Real Estate Market Updates, Behind-the-scenes Interviews, Listing Impossible updates and much more!
object(stdClass)#13691 (4) {
["agent"]=>
object(stdClass)#13720 (24) {
["ID"]=>
int(2313)
["post_author"]=>
string(1) "1"
["post_date"]=>
string(19) "2022-06-17 02:40:35"
["post_date_gmt"]=>
string(19) "2022-06-17 02:40:35"
["post_content"]=>
string(591) "With nearly $1 billion in career sales, Greg Sykes is one of Niagara’s most trusted and accomplished real estate professionals. Based in Niagara-on-the-Lake, Greg specializes in luxury homes, waterfront estates, and exclusive rural retreats across the Niagara Region, extending his expertise to Burlington, Oakville, and beyond. His in-depth local knowledge, refined marketing strategies, and personalized approach have made him the go-to choice for discerning buyers and sellers seeking exceptional results in Ontario’s most prestigious markets."
["post_title"]=>
string(10) "Greg Sykes"
["post_excerpt"]=>
string(0) ""
["post_status"]=>
string(7) "publish"
["comment_status"]=>
string(6) "closed"
["ping_status"]=>
string(6) "closed"
["post_password"]=>
string(0) ""
["post_name"]=>
string(10) "greg-sykes"
["to_ping"]=>
string(0) ""
["pinged"]=>
string(0) ""
["post_modified"]=>
string(19) "2025-10-15 20:16:11"
["post_modified_gmt"]=>
string(19) "2025-10-15 20:16:11"
["post_content_filtered"]=>
string(0) ""
["post_parent"]=>
int(0)
["guid"]=>
string(72) "https://www.therenownedcollection.com/?post_type=aios-agents&p=2313"
["menu_order"]=>
int(13)
["post_type"]=>
string(11) "aios-agents"
["post_mime_type"]=>
string(0) ""
["comment_count"]=>
string(1) "0"
["filter"]=>
string(3) "raw"
}
["meta"]=>
object(stdClass)#13681 (24) {
["_edit_last"]=>
array(1) {
[0]=>
string(1) "2"
}
["_wp_old_date"]=>
array(1) {
[0]=>
string(10) "2024-05-26"
}
["aios_custom_metabox"]=>
array(1) {
[0]=>
string(171) "a:6:{s:17:"used_custom_title";s:0:"";s:10:"main_title";s:0:"";s:9:"sub_title";s:0:"";s:6:"banner";s:0:"";s:23:"banner_alternative_text";s:0:"";s:12:"banner_title";s:0:"";}"
}
["aioscm_used_custom_title"]=>
array(1) {
[0]=>
string(0) ""
}
["aioscm_main_title"]=>
array(1) {
[0]=>
string(0) ""
}
["aioscm_sub_title"]=>
array(1) {
[0]=>
string(0) ""
}
["aioscm_banner"]=>
array(1) {
[0]=>
string(0) ""
}
["aioscm_banner_alternative_text"]=>
array(1) {
[0]=>
string(0) ""
}
["aioscm_banner_title"]=>
array(1) {
[0]=>
string(0) ""
}
["_agent_details"]=>
array(1) {
[0]=>
string(2897) "a:57:{s:13:"agentimage_id";s:5:"39795";s:10:"first_name";s:4:"Greg";s:9:"last_name";s:5:"Sykes";s:8:"position";s:20:"Sales Representative";s:7:"license";s:0:"";s:11:"license_tag";s:0:"";s:13:"email_address";s:22:"gsykes@remaxniagara.ca";s:13:"phone_number1";s:12:"905.687.9600";s:14:"mobile_number1";s:0:"";s:11:"fax_number1";s:0:"";s:18:"phone_number1_code";s:1:"1";s:19:"mobile_number1_code";s:1:"1";s:16:"fax_number1_code";s:1:"1";s:17:"phone_number1_ext";s:0:"";s:18:"mobile_number1_ext";s:0:"";s:15:"fax_number1_ext";s:0:"";s:18:"phone_number1_show";a:0:{}s:19:"mobile_number1_show";a:0:{}s:16:"fax_number1_show";a:0:{}s:13:"phone_number2";s:0:"";s:14:"mobile_number2";s:0:"";s:11:"fax_number2";s:0:"";s:18:"phone_number2_code";s:1:"1";s:19:"mobile_number2_code";s:1:"1";s:16:"fax_number2_code";s:1:"1";s:17:"phone_number2_ext";s:0:"";s:18:"mobile_number2_ext";s:0:"";s:15:"fax_number2_ext";s:0:"";s:18:"phone_number2_show";a:0:{}s:19:"mobile_number2_show";a:0:{}s:16:"fax_number2_show";a:0:{}s:12:"home_address";a:6:{s:21:"address_street_number";s:0:"";s:19:"address_street_name";s:0:"";s:19:"address_unit_number";s:0:"";s:12:"address_city";s:0:"";s:13:"address_state";s:0:"";s:16:"address_zip_code";s:0:"";}s:19:"home_address_concat";s:5:" , ";s:14:"office_address";a:6:{s:21:"address_street_number";s:3:"261";s:19:"address_street_name";s:14:"MARTINDALE AVE";s:19:"address_unit_number";s:3:"14C";s:12:"address_city";s:14:"ST. CATHARINES";s:13:"address_state";s:0:"";s:16:"address_zip_code";s:0:"";}s:21:"office_address_concat";s:41:"261 MARTINDALE AVE, 14C, ST. CATHARINES ";s:16:"languages_spoken";a:1:{i:0;s:7:"English";}s:13:"exclude_agent";s:0:"";s:8:"is_staff";s:0:"";s:11:"description";s:591:"With nearly $1 billion in career sales, Greg Sykes is one of Niagara’s most trusted and accomplished real estate professionals. Based in Niagara-on-the-Lake, Greg specializes in luxury homes, waterfront estates, and exclusive rural retreats across the Niagara Region, extending his expertise to Burlington, Oakville, and beyond. His in-depth local knowledge, refined marketing strategies, and personalized approach have made him the go-to choice for discerning buyers and sellers seeking exceptional results in Ontario’s most prestigious markets.";s:8:"facebook";s:0:"";s:7:"twitter";s:0:"";s:11:"google_plus";N;s:8:"linkedin";s:0:"";s:7:"youtube";s:71:"https://youtube.com/@gregsykesrealestateniagara5718?si=t34aUiMlkAODpwSX";s:9:"instagram";s:64:"https://www.instagram.com/thesykesteam?igsh=MWYzMTY2a2t1N2ZvZA==";s:9:"pinterest";s:0:"";s:6:"trulia";s:0:"";s:6:"zillow";s:0:"";s:5:"houzz";s:0:"";s:7:"blogger";s:0:"";s:4:"yelp";s:0:"";s:5:"skype";s:0:"";s:6:"tumblr";s:0:"";s:5:"yahoo";s:0:"";s:7:"realtor";s:78:"https://www.realtor.ca/a/gOHq/kb#firstname=GREG&lastname=SYKES&page=1&sort=3-A";s:6:"videos";a:0:{}s:15:"additional_info";a:0:{}}"
}
["_agent_properties"]=>
array(1) {
[0]=>
string(147) "a:9:{i:0;s:5:"35992";i:1;s:5:"23776";i:2;s:5:"17869";i:3;s:5:"11695";i:4;s:5:"19313";i:5;s:4:"2791";i:6;s:4:"7246";i:7;s:5:"11884";i:8;s:4:"8432";}"
}
["first_name"]=>
array(1) {
[0]=>
string(4) "Greg"
}
["last_name"]=>
array(1) {
[0]=>
string(5) "Sykes"
}
["full_name"]=>
array(1) {
[0]=>
string(10) "Greg Sykes"
}
["position"]=>
array(1) {
[0]=>
string(20) "Sales Representative"
}
["license"]=>
array(1) {
[0]=>
string(0) ""
}
["email"]=>
array(1) {
[0]=>
string(22) "gsykes@remaxniagara.ca"
}
["_yoast_wpseo_estimated-reading-time-minutes"]=>
array(1) {
[0]=>
string(1) "1"
}
["_yoast_wpseo_wordproof_timestamp"]=>
array(1) {
[0]=>
string(0) ""
}
["_edit_lock"]=>
array(1) {
[0]=>
string(12) "1760559239:2"
}
["_wp_old_slug"]=>
array(1) {
[0]=>
string(19) "cheryl-ohearn-clone"
}
["schema_markup_specific_page"]=>
array(1) {
[0]=>
string(0) ""
}
["_yoast_wpseo_content_score"]=>
array(1) {
[0]=>
string(2) "90"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(5) "39795"
}
}
["pagination"]=>
object(stdClass)#13682 (2) {
["next"]=>
NULL
["previous"]=>
NULL
}
["options"]=>
string(0) ""
}