Discover Leverage Developments

From Second Homes and Resort Communities to Condominiums

NIX Realty Company

San Antonio, TX, USA

NIX Realty Company is the exclusive representative for Leverage Global Partners in San Antonio, TX, including Bexar County, Texas Hill County, Alamo Heights, Terrel Hills, Olmos Park, Boerne, TX, USA. Nix Realty Company, a residential real estate brokerage firm, was founded in 2007 by Kate Coiner Park and Marnie Tate Simpson. They saw a need for a boutique company that could specialize its services to each client’s specific needs. Their main focus is to provide excellent customer service and up to date knowledge and…

View this Development

Featured Offerings

121 West Brandon Drive, Bel Meade

This incredible estate property is located in desirable Bel Meade subdivision. Rarely offered, it is one of 6…

114 Brittany Olmos Park

This classic Olmos Park home has beautiful space and light. This Thorman property has 4 large bedrooms with…

Alex MacWilliam Inc.

Vero Beach, FL, USA

Alex MacWilliam Inc. is the exclusive representative for Leverage Global Partners in Vero Beach, FL, USA. Alex MacWilliam Real Estate has long been the company buyers and sellers have turned to for Vero Beach, FL real estate. The MacWilliam family has a deep-rooted history in Vero Beach, beginning in the 1920s when Alex MacWilliam Sr. moved to oversee the construction of what is now Riomar and later served as mayor for a 20-year tenure. Alex MacWilliam Real Estate opened for business in 1949 by Alex MacWilliam, Jr. as one of only…

View this Development

Featured Offerings

Fabulous Oceanfront Condo

Oceanfront Colonial, West Indies style condo. Furnished 4BR/4.5BA with over 4,300 Sq. feet. Features include…

TROPICAL PARADISE

Sleek sophistication is the principal motif throughout this 3,150 SF Ocean Ridge residence with incredible…

Pam Harrington Exclusives

Johns Island, SC, USA

Pam Harrington Exclusives is the exclusive representative for Leverage Global Partners in Wadmalaw Island, Seabrook Island, Johns Island, Kiawah Island, South Carolina, USA. In 1987, Pam Harrington Exclusives began as a small, independent firm amid a sea of large, corporate realty…

View this Development

Featured Offerings

3120 Privateer Creek

This beautiful and impeccably maintained home with desirable southern exposure is situated with panoramic views…

Exclusive Auction Opportunity

Gracious, five bedroom Low Country custom home with deep-water dock on the Stono River, part of the…

DeSell & Co. Realty Group - Equine Specialist

Southern Pines, NC, USA

DeSell & Co. Realty Group is the exclusive equine representative for Leverage Global Partners in Southern Pines, Aberdeen, Carthage, Vass, and Cameron, North Carolina, USA. In 2007, after Jo-an DeSell had been in real estate sales for about seven years, she decided that it was time…

View this Development

Featured Offerings

21 Acre Farm With Barn and Apartment

Wonderful 21 acre farm with everything that any buyer could want or need....as well as impeccably maintained!…

Quail Glen

Remarkable beauty, privacy and location all describe this 43+ acre horse farm which is conveniently located 3…

Joyce Realty

Pearl River, NY, USA

Joyce Realty is the exclusive representative for Leverage Global Partners in Rockland County, including the cities of Airmont, Bardonia, Blauvelt, Central Nyack, Chestnut Ridge, Clarkstown, Congers, Garnerville, Grand View, Haverstraw, Hillburn, Hillcrest, Monsey, Montebello, Nanuet, New…

View this Development

The Marchant Company, Inc.

Greenville, SC, USA

The Marchant Company, Inc. is the exclusive representative for Leverage Global Partners in the Greater Greenville Area, Taylors, Mauldin, Travelers Rest, Greer, Fountain Inn, Easley, and Simpsonville, South Carolina, USA. Makings of the Marchant Company After working in the Greenville…

View this Development

Featured Offerings

AUTHENTIC TUDOR HOME ON PENINSULA

Once in a lifetime offering, to own your own peninsula including 55 acres of the ultimate in privacy, 1000 feet…

Amazing Historic Home on 9.83 Acres

Amazing 6700+ square foot historic home on 9.83 acres with incredible updates! This home is approximately 9…

History
+
Request History
3 previous requests available
====
Session
+
Session
- 0(null)
====
Request
+
Request

Cake Params
- plugin(null)
- controllerbrokerages
- actiondevelopments_index
- named(empty)
- pass(empty)
- isAjax(false)
Post data

No post data.

Query string

No querystring data.

Cookie
- 0(empty)
Current Route
- keys(empty)
- options(empty)
- defaults(array)
  controllerbrokerages
  actiondevelopments_index
  plugin(null)
- template/developments
====

Sql Log

Sql Logs

default

Total Time: 34 ms
Total Queries: 15 queries

Query	Affected	Num. rows	Took (ms)	Actions
SELECT `Brokerage`.`id`, `Brokerage`.`account_executive_id`, `Brokerage`.`archived`, `Brokerage`.`type`, `Brokerage`.`hide_from_frontend`, `Brokerage`.`agent_brokerage_data_override`, `Brokerage`.`featured_development`, `Brokerage`.`membership_type`, `Brokerage`.`max_properties`, `Brokerage`.`max_homepage_featured_by_member_properties`, `Brokerage`.`featured_properties_sort_method`, `Brokerage`.`lux_feed_mode`, `Brokerage`.`max_luxury_feed_properties`, `Brokerage`.`membership_luxury_feed_properties`, `Brokerage`.`can_participate_in_lux_feed_while_archived`, `Brokerage`.`full_training_video_access`, `Brokerage`.`country_id`, `Brokerage`.`WOEID`, `Brokerage`.`timezone`, `Brokerage`.`luxury_feed_enrollment_mode`, `Brokerage`.`luxury_feed_include_mlsidx_minimum_price`, `Brokerage`.`luxury_feed_include_leverage_minimum_price`, `Brokerage`.`digital_ad_contacts`, `Brokerage`.`add_agents_to_grr_auto_recipients`, `Brokerage`.`mlsidx_id`, `Brokerage`.`mlsidx_lux_autofeed`, `Brokerage`.`mlsidx_lux_autofeed_minimum_price`, `Brokerage`.`mlsidx_logo_url`, `Brokerage`.`mlsidx_disclaimer`, `Brokerage`.`name`, `Brokerage`.`broker_of_record_name`, `Brokerage`.`short_name`, `Brokerage`.`username`, `Brokerage`.`password`, `Brokerage`.`password_reset_hash`, `Brokerage`.`monthly_invoice_amount`, `Brokerage`.`monthly_invoice_start_date`, `Brokerage`.`monthly_invoice_end_date`, `Brokerage`.`contract_filename`, `Brokerage`.`active`, `Brokerage`.`lead_in`, `Brokerage`.`short_description`, `Brokerage`.`description`, `Brokerage`.`communities`, `Brokerage`.`website`, `Brokerage`.`address`, `Brokerage`.`address_2`, `Brokerage`.`city`, `Brokerage`.`state`, `Brokerage`.`full_state`, `Brokerage`.`country`, `Brokerage`.`market`, `Brokerage`.`market_2`, `Brokerage`.`postal_code`, `Brokerage`.`phone`, `Brokerage`.`phone_2`, `Brokerage`.`phone_3`, `Brokerage`.`wide_contact_image`, `Brokerage`.`contact_name`, `Brokerage`.`contact_profile_link`, `Brokerage`.`contact_big_profile_link`, `Brokerage`.`contact_big_profile_link_text`, `Brokerage`.`contact_title`, `Brokerage`.`contact_dre_num`, `Brokerage`.`contact_quote`, `Brokerage`.`contact_email`, `Brokerage`.`contact_facebook`, `Brokerage`.`contact_twitter`, `Brokerage`.`contact_instagram`, `Brokerage`.`contact_pinterest`, `Brokerage`.`contact_linkedin`, `Brokerage`.`contact_youtube`, `Brokerage`.`contact_phone`, `Brokerage`.`contact_email_2`, `Brokerage`.`contact_2_facebook`, `Brokerage`.`contact_2_twitter`, `Brokerage`.`contact_2_instagram`, `Brokerage`.`contact_2_pinterest`, `Brokerage`.`contact_2_linkedin`, `Brokerage`.`contact_2_youtube`, `Brokerage`.`contact_phone_2`, `Brokerage`.`contact_website`, `Brokerage`.`contact_name_2`, `Brokerage`.`contact_profile_link_2`, `Brokerage`.`contact_big_profile_link_2`, `Brokerage`.`contact_big_profile_link_text_2`, `Brokerage`.`contact_title_2`, `Brokerage`.`contact_dre_num_2`, `Brokerage`.`contact_email_3`, `Brokerage`.`contact_name_3`, `Brokerage`.`contact_title_3`, `Brokerage`.`contact_dre_num_3`, `Brokerage`.`contact_phone_3`, `Brokerage`.`contact_3_facebook`, `Brokerage`.`contact_3_twitter`, `Brokerage`.`contact_3_instagram`, `Brokerage`.`contact_3_pinterest`, `Brokerage`.`contact_3_linkedin`, `Brokerage`.`contact_3_youtube`, `Brokerage`.`image_filename`, `Brokerage`.`logo_filename`, `Brokerage`.`contact_image_filename`, `Brokerage`.`all_properties_link_image_filename`, `Brokerage`.`all_properties_link`, `Brokerage`.`video_embed_code`, `Brokerage`.`contact_video_embed_code`, `Brokerage`.`meta_title`, `Brokerage`.`meta_description`, `Brokerage`.`meta_keywords`, `Brokerage`.`login_message_counter`, `Brokerage`.`stats_module_1_type`, `Brokerage`.`stats_module_1_value`, `Brokerage`.`stats_module_2_type`, `Brokerage`.`stats_module_2_value`, `Brokerage`.`stats_module_3_type`, `Brokerage`.`stats_module_3_value`, `Brokerage`.`last_activity_email_sent`, `Brokerage`.`converted`, `Brokerage`.`created`, `Brokerage`.`modified`, `Brokerage`.`dre_num` FROM `leveragere_staging2`.`brokerages` AS `Brokerage` WHERE `Brokerage`.`archived` = '0' AND `Brokerage`.`type` = 'development' AND `Brokerage`.`featured_development` = '1' ORDER BY RAND() ASC LIMIT 2	2	2	2
SELECT `FeaturedImage`.`id`, `FeaturedImage`.`model`, `FeaturedImage`.`model_id`, `FeaturedImage`.`tag`, `FeaturedImage`.`name`, `FeaturedImage`.`type`, `FeaturedImage`.`size`, `FeaturedImage`.`uri`, `FeaturedImage`.`order`, `FeaturedImage`.`created`, `FeaturedImage`.`modified` FROM `leveragere_staging2`.`assets` AS `FeaturedImage` WHERE `FeaturedImage`.`model` = 'Brokerage' AND `FeaturedImage`.`tag` = 'FeaturedImage' AND `FeaturedImage`.`model_id` IN (191, 147) ORDER BY `FeaturedImage`.`order` ASC	13	13	1	maybe slow
SELECT `Property`.`id`, `Property`.`brokerage_id`, `Property`.`created_by_user_id`, `Property`.`order`, `Property`.`multi_unit`, `Property`.`agent_1_id`, `Property`.`agent_2_id`, `Property`.`agent_3_id`, `Property`.`name`, `Property`.`incomplete`, `Property`.`archived`, `Property`.`last_archived`, `Property`.`auto_archived_from_mlsidx`, `Property`.`paid_featured`, `Property`.`featured`, `Property`.`homepage_featured`, `Property`.`brokerage_page_featured`, `Property`.`requested_homepage_featured_by_member`, `Property`.`homepage_featured_by_member`, `Property`.`dot_luxury_featured`, `Property`.`luxury_feed_featured`, `Property`.`force_luxury_feed_featured`, `Property`.`luxury_autofeed_imported`, `Property`.`luxury_feed_last_added_time`, `Property`.`luxury_feed_agent_user_id`, `Property`.`luxury_feed_locked_to_subscription_id`, `Property`.`luxury_feed_agent_purchase_date`, `Property`.`luxury_feed_agent_expiration_date`, `Property`.`digital_ad_summary_email_last_sent`, `Property`.`digital_ad_summary_price_changed`, `Property`.`wsj_detail_url`, `Property`.`ft_detail_url`, `Property`.`nyt_detail_url`, `Property`.`juwai_detail_url`, `Property`.`pgl_detail_url`, `Property`.`mg_detail_url`, `Property`.`mg_c_detail_url`, `Property`.`mg_s_detail_url`, `Property`.`bp_detail_url`, `Property`.`mw_detail_url`, `Property`.`nikkei_detail_url`, `Property`.`wapo_detail_url`, `Property`.`robb_detail_url`, `Property`.`medium_featured`, `Property`.`large_featured`, `Property`.`detail_page`, `Property`.`description`, `Property`.`address`, `Property`.`address_2`, `Property`.`city`, `Property`.`state`, `Property`.`postal_code`, `Property`.`country`, `Property`.`use_lat_lng_for_google_map`, `Property`.`currency`, `Property`.`price`, `Property`.`price_2`, `Property`.`price_usd`, `Property`.`price_usd_2`, `Property`.`status`, `Property`.`status_last_changed`, `Property`.`status_last_changed_price_only`, `Property`.`lease_period`, `Property`.`price_upon_request`, `Property`.`bedrooms`, `Property`.`bedrooms_2`, `Property`.`bathrooms`, `Property`.`bathrooms_2`, `Property`.`no_beds_baths`, `Property`.`square_feet`, `Property`.`square_meters`, `Property`.`acres`, `Property`.`interior_unit`, `Property`.`interior_size`, `Property`.`lot_unit`, `Property`.`lot_size`, `Property`.`icon_1`, `Property`.`icon_2`, `Property`.`icon_3`, `Property`.`icon_4`, `Property`.`icon_5`, `Property`.`icon_6`, `Property`.`website`, `Property`.`meta_title`, `Property`.`meta_description`, `Property`.`meta_keywords`, `Property`.`bathrooms_partial`, `Property`.`bathrooms_partial_2`, `Property`.`bathrooms_3_4`, `Property`.`bathrooms_3_4_2`, `Property`.`year_built`, `Property`.`virtual_tour`, `Property`.`video_tour`, `Property`.`digital_brochure`, `Property`.`video_tour_embed_code`, `Property`.`digital_brochure_embed_code`, `Property`.`mls_num`, `Property`.`wsj_property_type`, `Property`.`nyt_property_type`, `Property`.`nyt_popular_features`, `Property`.`propgolux_property_type`, `Property`.`juwai_property_type`, `Property`.`juwai_category`, `Property`.`propgolux_property_style`, `Property`.`wapo_property_type`, `Property`.`robb_property_type`, `Property`.`propgolux_location_id_override`, `Property`.`open_house_1_start`, `Property`.`open_house_1_end_time`, `Property`.`latitude`, `Property`.`longitude`, `Property`.`invalid_required_fields`, `Property`.`invalid_optional_fields`, `Property`.`went_live_today`, `Property`.`converted`, `Property`.`invalid`, `Property`.`mlsidx_full_address`, `Property`.`mlsidx_date_listed`, `Property`.`mls_market`, `Property`.`primary_property_category_id`, `Property`.`realstaq_initial_image_sync`, `Property`.`digital_ad_listing_urls_automated`, `Property`.`modified`, `Property`.`created` FROM `leveragere_staging2`.`properties` AS `Property` WHERE `Property`.`archived` = '0' AND `Property`.`brokerage_id` = (191) ORDER BY RAND() ASC LIMIT 2	2	2	12	maybe slow
SELECT `Image`.`id`, `Image`.`model`, `Image`.`model_id`, `Image`.`tag`, `Image`.`name`, `Image`.`type`, `Image`.`size`, `Image`.`uri`, `Image`.`order`, `Image`.`created`, `Image`.`modified` FROM `leveragere_staging2`.`assets` AS `Image` WHERE `Image`.`model` = 'Property' AND `Image`.`tag` = 'Image' AND `Image`.`model_id` IN (3685, 2743) ORDER BY `Image`.`order` ASC	16	16	2	maybe slow
SELECT `Property`.`id`, `Property`.`brokerage_id`, `Property`.`created_by_user_id`, `Property`.`order`, `Property`.`multi_unit`, `Property`.`agent_1_id`, `Property`.`agent_2_id`, `Property`.`agent_3_id`, `Property`.`name`, `Property`.`incomplete`, `Property`.`archived`, `Property`.`last_archived`, `Property`.`auto_archived_from_mlsidx`, `Property`.`paid_featured`, `Property`.`featured`, `Property`.`homepage_featured`, `Property`.`brokerage_page_featured`, `Property`.`requested_homepage_featured_by_member`, `Property`.`homepage_featured_by_member`, `Property`.`dot_luxury_featured`, `Property`.`luxury_feed_featured`, `Property`.`force_luxury_feed_featured`, `Property`.`luxury_autofeed_imported`, `Property`.`luxury_feed_last_added_time`, `Property`.`luxury_feed_agent_user_id`, `Property`.`luxury_feed_locked_to_subscription_id`, `Property`.`luxury_feed_agent_purchase_date`, `Property`.`luxury_feed_agent_expiration_date`, `Property`.`digital_ad_summary_email_last_sent`, `Property`.`digital_ad_summary_price_changed`, `Property`.`wsj_detail_url`, `Property`.`ft_detail_url`, `Property`.`nyt_detail_url`, `Property`.`juwai_detail_url`, `Property`.`pgl_detail_url`, `Property`.`mg_detail_url`, `Property`.`mg_c_detail_url`, `Property`.`mg_s_detail_url`, `Property`.`bp_detail_url`, `Property`.`mw_detail_url`, `Property`.`nikkei_detail_url`, `Property`.`wapo_detail_url`, `Property`.`robb_detail_url`, `Property`.`medium_featured`, `Property`.`large_featured`, `Property`.`detail_page`, `Property`.`description`, `Property`.`address`, `Property`.`address_2`, `Property`.`city`, `Property`.`state`, `Property`.`postal_code`, `Property`.`country`, `Property`.`use_lat_lng_for_google_map`, `Property`.`currency`, `Property`.`price`, `Property`.`price_2`, `Property`.`price_usd`, `Property`.`price_usd_2`, `Property`.`status`, `Property`.`status_last_changed`, `Property`.`status_last_changed_price_only`, `Property`.`lease_period`, `Property`.`price_upon_request`, `Property`.`bedrooms`, `Property`.`bedrooms_2`, `Property`.`bathrooms`, `Property`.`bathrooms_2`, `Property`.`no_beds_baths`, `Property`.`square_feet`, `Property`.`square_meters`, `Property`.`acres`, `Property`.`interior_unit`, `Property`.`interior_size`, `Property`.`lot_unit`, `Property`.`lot_size`, `Property`.`icon_1`, `Property`.`icon_2`, `Property`.`icon_3`, `Property`.`icon_4`, `Property`.`icon_5`, `Property`.`icon_6`, `Property`.`website`, `Property`.`meta_title`, `Property`.`meta_description`, `Property`.`meta_keywords`, `Property`.`bathrooms_partial`, `Property`.`bathrooms_partial_2`, `Property`.`bathrooms_3_4`, `Property`.`bathrooms_3_4_2`, `Property`.`year_built`, `Property`.`virtual_tour`, `Property`.`video_tour`, `Property`.`digital_brochure`, `Property`.`video_tour_embed_code`, `Property`.`digital_brochure_embed_code`, `Property`.`mls_num`, `Property`.`wsj_property_type`, `Property`.`nyt_property_type`, `Property`.`nyt_popular_features`, `Property`.`propgolux_property_type`, `Property`.`juwai_property_type`, `Property`.`juwai_category`, `Property`.`propgolux_property_style`, `Property`.`wapo_property_type`, `Property`.`robb_property_type`, `Property`.`propgolux_location_id_override`, `Property`.`open_house_1_start`, `Property`.`open_house_1_end_time`, `Property`.`latitude`, `Property`.`longitude`, `Property`.`invalid_required_fields`, `Property`.`invalid_optional_fields`, `Property`.`went_live_today`, `Property`.`converted`, `Property`.`invalid`, `Property`.`mlsidx_full_address`, `Property`.`mlsidx_date_listed`, `Property`.`mls_market`, `Property`.`primary_property_category_id`, `Property`.`realstaq_initial_image_sync`, `Property`.`digital_ad_listing_urls_automated`, `Property`.`modified`, `Property`.`created` FROM `leveragere_staging2`.`properties` AS `Property` WHERE `Property`.`archived` = '0' AND `Property`.`brokerage_id` = (147) ORDER BY RAND() ASC LIMIT 2	2	2	3	maybe slow
SELECT `Image`.`id`, `Image`.`model`, `Image`.`model_id`, `Image`.`tag`, `Image`.`name`, `Image`.`type`, `Image`.`size`, `Image`.`uri`, `Image`.`order`, `Image`.`created`, `Image`.`modified` FROM `leveragere_staging2`.`assets` AS `Image` WHERE `Image`.`model` = 'Property' AND `Image`.`tag` = 'Image' AND `Image`.`model_id` IN (972, 2696) ORDER BY `Image`.`order` ASC	20	20	2	maybe slow
SELECT `Brokerage`.`id`, `Brokerage`.`account_executive_id`, `Brokerage`.`archived`, `Brokerage`.`type`, `Brokerage`.`hide_from_frontend`, `Brokerage`.`agent_brokerage_data_override`, `Brokerage`.`featured_development`, `Brokerage`.`membership_type`, `Brokerage`.`max_properties`, `Brokerage`.`max_homepage_featured_by_member_properties`, `Brokerage`.`featured_properties_sort_method`, `Brokerage`.`lux_feed_mode`, `Brokerage`.`max_luxury_feed_properties`, `Brokerage`.`membership_luxury_feed_properties`, `Brokerage`.`can_participate_in_lux_feed_while_archived`, `Brokerage`.`full_training_video_access`, `Brokerage`.`country_id`, `Brokerage`.`WOEID`, `Brokerage`.`timezone`, `Brokerage`.`luxury_feed_enrollment_mode`, `Brokerage`.`luxury_feed_include_mlsidx_minimum_price`, `Brokerage`.`luxury_feed_include_leverage_minimum_price`, `Brokerage`.`digital_ad_contacts`, `Brokerage`.`add_agents_to_grr_auto_recipients`, `Brokerage`.`mlsidx_id`, `Brokerage`.`mlsidx_lux_autofeed`, `Brokerage`.`mlsidx_lux_autofeed_minimum_price`, `Brokerage`.`mlsidx_logo_url`, `Brokerage`.`mlsidx_disclaimer`, `Brokerage`.`name`, `Brokerage`.`broker_of_record_name`, `Brokerage`.`short_name`, `Brokerage`.`username`, `Brokerage`.`password`, `Brokerage`.`password_reset_hash`, `Brokerage`.`monthly_invoice_amount`, `Brokerage`.`monthly_invoice_start_date`, `Brokerage`.`monthly_invoice_end_date`, `Brokerage`.`contract_filename`, `Brokerage`.`active`, `Brokerage`.`lead_in`, `Brokerage`.`short_description`, `Brokerage`.`description`, `Brokerage`.`communities`, `Brokerage`.`website`, `Brokerage`.`address`, `Brokerage`.`address_2`, `Brokerage`.`city`, `Brokerage`.`state`, `Brokerage`.`full_state`, `Brokerage`.`country`, `Brokerage`.`market`, `Brokerage`.`market_2`, `Brokerage`.`postal_code`, `Brokerage`.`phone`, `Brokerage`.`phone_2`, `Brokerage`.`phone_3`, `Brokerage`.`wide_contact_image`, `Brokerage`.`contact_name`, `Brokerage`.`contact_profile_link`, `Brokerage`.`contact_big_profile_link`, `Brokerage`.`contact_big_profile_link_text`, `Brokerage`.`contact_title`, `Brokerage`.`contact_dre_num`, `Brokerage`.`contact_quote`, `Brokerage`.`contact_email`, `Brokerage`.`contact_facebook`, `Brokerage`.`contact_twitter`, `Brokerage`.`contact_instagram`, `Brokerage`.`contact_pinterest`, `Brokerage`.`contact_linkedin`, `Brokerage`.`contact_youtube`, `Brokerage`.`contact_phone`, `Brokerage`.`contact_email_2`, `Brokerage`.`contact_2_facebook`, `Brokerage`.`contact_2_twitter`, `Brokerage`.`contact_2_instagram`, `Brokerage`.`contact_2_pinterest`, `Brokerage`.`contact_2_linkedin`, `Brokerage`.`contact_2_youtube`, `Brokerage`.`contact_phone_2`, `Brokerage`.`contact_website`, `Brokerage`.`contact_name_2`, `Brokerage`.`contact_profile_link_2`, `Brokerage`.`contact_big_profile_link_2`, `Brokerage`.`contact_big_profile_link_text_2`, `Brokerage`.`contact_title_2`, `Brokerage`.`contact_dre_num_2`, `Brokerage`.`contact_email_3`, `Brokerage`.`contact_name_3`, `Brokerage`.`contact_title_3`, `Brokerage`.`contact_dre_num_3`, `Brokerage`.`contact_phone_3`, `Brokerage`.`contact_3_facebook`, `Brokerage`.`contact_3_twitter`, `Brokerage`.`contact_3_instagram`, `Brokerage`.`contact_3_pinterest`, `Brokerage`.`contact_3_linkedin`, `Brokerage`.`contact_3_youtube`, `Brokerage`.`image_filename`, `Brokerage`.`logo_filename`, `Brokerage`.`contact_image_filename`, `Brokerage`.`all_properties_link_image_filename`, `Brokerage`.`all_properties_link`, `Brokerage`.`video_embed_code`, `Brokerage`.`contact_video_embed_code`, `Brokerage`.`meta_title`, `Brokerage`.`meta_description`, `Brokerage`.`meta_keywords`, `Brokerage`.`login_message_counter`, `Brokerage`.`stats_module_1_type`, `Brokerage`.`stats_module_1_value`, `Brokerage`.`stats_module_2_type`, `Brokerage`.`stats_module_2_value`, `Brokerage`.`stats_module_3_type`, `Brokerage`.`stats_module_3_value`, `Brokerage`.`last_activity_email_sent`, `Brokerage`.`converted`, `Brokerage`.`created`, `Brokerage`.`modified`, `Brokerage`.`dre_num` FROM `leveragere_staging2`.`brokerages` AS `Brokerage` WHERE `Brokerage`.`archived` = '0' AND `Brokerage`.`type` = 'development' AND `Brokerage`.`featured_development` = '0' ORDER BY RAND() ASC LIMIT 4	4	4	2	maybe slow
SELECT `FeaturedImage`.`id`, `FeaturedImage`.`model`, `FeaturedImage`.`model_id`, `FeaturedImage`.`tag`, `FeaturedImage`.`name`, `FeaturedImage`.`type`, `FeaturedImage`.`size`, `FeaturedImage`.`uri`, `FeaturedImage`.`order`, `FeaturedImage`.`created`, `FeaturedImage`.`modified` FROM `leveragere_staging2`.`assets` AS `FeaturedImage` WHERE `FeaturedImage`.`model` = 'Brokerage' AND `FeaturedImage`.`tag` = 'FeaturedImage' AND `FeaturedImage`.`model_id` IN (92, 217, 230, 137) ORDER BY `FeaturedImage`.`order` ASC	40	40	1
SELECT `Property`.`id`, `Property`.`brokerage_id`, `Property`.`created_by_user_id`, `Property`.`order`, `Property`.`multi_unit`, `Property`.`agent_1_id`, `Property`.`agent_2_id`, `Property`.`agent_3_id`, `Property`.`name`, `Property`.`incomplete`, `Property`.`archived`, `Property`.`last_archived`, `Property`.`auto_archived_from_mlsidx`, `Property`.`paid_featured`, `Property`.`featured`, `Property`.`homepage_featured`, `Property`.`brokerage_page_featured`, `Property`.`requested_homepage_featured_by_member`, `Property`.`homepage_featured_by_member`, `Property`.`dot_luxury_featured`, `Property`.`luxury_feed_featured`, `Property`.`force_luxury_feed_featured`, `Property`.`luxury_autofeed_imported`, `Property`.`luxury_feed_last_added_time`, `Property`.`luxury_feed_agent_user_id`, `Property`.`luxury_feed_locked_to_subscription_id`, `Property`.`luxury_feed_agent_purchase_date`, `Property`.`luxury_feed_agent_expiration_date`, `Property`.`digital_ad_summary_email_last_sent`, `Property`.`digital_ad_summary_price_changed`, `Property`.`wsj_detail_url`, `Property`.`ft_detail_url`, `Property`.`nyt_detail_url`, `Property`.`juwai_detail_url`, `Property`.`pgl_detail_url`, `Property`.`mg_detail_url`, `Property`.`mg_c_detail_url`, `Property`.`mg_s_detail_url`, `Property`.`bp_detail_url`, `Property`.`mw_detail_url`, `Property`.`nikkei_detail_url`, `Property`.`wapo_detail_url`, `Property`.`robb_detail_url`, `Property`.`medium_featured`, `Property`.`large_featured`, `Property`.`detail_page`, `Property`.`description`, `Property`.`address`, `Property`.`address_2`, `Property`.`city`, `Property`.`state`, `Property`.`postal_code`, `Property`.`country`, `Property`.`use_lat_lng_for_google_map`, `Property`.`currency`, `Property`.`price`, `Property`.`price_2`, `Property`.`price_usd`, `Property`.`price_usd_2`, `Property`.`status`, `Property`.`status_last_changed`, `Property`.`status_last_changed_price_only`, `Property`.`lease_period`, `Property`.`price_upon_request`, `Property`.`bedrooms`, `Property`.`bedrooms_2`, `Property`.`bathrooms`, `Property`.`bathrooms_2`, `Property`.`no_beds_baths`, `Property`.`square_feet`, `Property`.`square_meters`, `Property`.`acres`, `Property`.`interior_unit`, `Property`.`interior_size`, `Property`.`lot_unit`, `Property`.`lot_size`, `Property`.`icon_1`, `Property`.`icon_2`, `Property`.`icon_3`, `Property`.`icon_4`, `Property`.`icon_5`, `Property`.`icon_6`, `Property`.`website`, `Property`.`meta_title`, `Property`.`meta_description`, `Property`.`meta_keywords`, `Property`.`bathrooms_partial`, `Property`.`bathrooms_partial_2`, `Property`.`bathrooms_3_4`, `Property`.`bathrooms_3_4_2`, `Property`.`year_built`, `Property`.`virtual_tour`, `Property`.`video_tour`, `Property`.`digital_brochure`, `Property`.`video_tour_embed_code`, `Property`.`digital_brochure_embed_code`, `Property`.`mls_num`, `Property`.`wsj_property_type`, `Property`.`nyt_property_type`, `Property`.`nyt_popular_features`, `Property`.`propgolux_property_type`, `Property`.`juwai_property_type`, `Property`.`juwai_category`, `Property`.`propgolux_property_style`, `Property`.`wapo_property_type`, `Property`.`robb_property_type`, `Property`.`propgolux_location_id_override`, `Property`.`open_house_1_start`, `Property`.`open_house_1_end_time`, `Property`.`latitude`, `Property`.`longitude`, `Property`.`invalid_required_fields`, `Property`.`invalid_optional_fields`, `Property`.`went_live_today`, `Property`.`converted`, `Property`.`invalid`, `Property`.`mlsidx_full_address`, `Property`.`mlsidx_date_listed`, `Property`.`mls_market`, `Property`.`primary_property_category_id`, `Property`.`realstaq_initial_image_sync`, `Property`.`digital_ad_listing_urls_automated`, `Property`.`modified`, `Property`.`created` FROM `leveragere_staging2`.`properties` AS `Property` WHERE `Property`.`archived` = '0' AND `Property`.`brokerage_id` = (92) ORDER BY RAND() ASC LIMIT 2	2	2	1	maybe slow
SELECT `Image`.`id`, `Image`.`model`, `Image`.`model_id`, `Image`.`tag`, `Image`.`name`, `Image`.`type`, `Image`.`size`, `Image`.`uri`, `Image`.`order`, `Image`.`created`, `Image`.`modified` FROM `leveragere_staging2`.`assets` AS `Image` WHERE `Image`.`model` = 'Property' AND `Image`.`tag` = 'Image' AND `Image`.`model_id` IN (3616, 3618) ORDER BY `Image`.`order` ASC	20	20	2	maybe slow
SELECT `Property`.`id`, `Property`.`brokerage_id`, `Property`.`created_by_user_id`, `Property`.`order`, `Property`.`multi_unit`, `Property`.`agent_1_id`, `Property`.`agent_2_id`, `Property`.`agent_3_id`, `Property`.`name`, `Property`.`incomplete`, `Property`.`archived`, `Property`.`last_archived`, `Property`.`auto_archived_from_mlsidx`, `Property`.`paid_featured`, `Property`.`featured`, `Property`.`homepage_featured`, `Property`.`brokerage_page_featured`, `Property`.`requested_homepage_featured_by_member`, `Property`.`homepage_featured_by_member`, `Property`.`dot_luxury_featured`, `Property`.`luxury_feed_featured`, `Property`.`force_luxury_feed_featured`, `Property`.`luxury_autofeed_imported`, `Property`.`luxury_feed_last_added_time`, `Property`.`luxury_feed_agent_user_id`, `Property`.`luxury_feed_locked_to_subscription_id`, `Property`.`luxury_feed_agent_purchase_date`, `Property`.`luxury_feed_agent_expiration_date`, `Property`.`digital_ad_summary_email_last_sent`, `Property`.`digital_ad_summary_price_changed`, `Property`.`wsj_detail_url`, `Property`.`ft_detail_url`, `Property`.`nyt_detail_url`, `Property`.`juwai_detail_url`, `Property`.`pgl_detail_url`, `Property`.`mg_detail_url`, `Property`.`mg_c_detail_url`, `Property`.`mg_s_detail_url`, `Property`.`bp_detail_url`, `Property`.`mw_detail_url`, `Property`.`nikkei_detail_url`, `Property`.`wapo_detail_url`, `Property`.`robb_detail_url`, `Property`.`medium_featured`, `Property`.`large_featured`, `Property`.`detail_page`, `Property`.`description`, `Property`.`address`, `Property`.`address_2`, `Property`.`city`, `Property`.`state`, `Property`.`postal_code`, `Property`.`country`, `Property`.`use_lat_lng_for_google_map`, `Property`.`currency`, `Property`.`price`, `Property`.`price_2`, `Property`.`price_usd`, `Property`.`price_usd_2`, `Property`.`status`, `Property`.`status_last_changed`, `Property`.`status_last_changed_price_only`, `Property`.`lease_period`, `Property`.`price_upon_request`, `Property`.`bedrooms`, `Property`.`bedrooms_2`, `Property`.`bathrooms`, `Property`.`bathrooms_2`, `Property`.`no_beds_baths`, `Property`.`square_feet`, `Property`.`square_meters`, `Property`.`acres`, `Property`.`interior_unit`, `Property`.`interior_size`, `Property`.`lot_unit`, `Property`.`lot_size`, `Property`.`icon_1`, `Property`.`icon_2`, `Property`.`icon_3`, `Property`.`icon_4`, `Property`.`icon_5`, `Property`.`icon_6`, `Property`.`website`, `Property`.`meta_title`, `Property`.`meta_description`, `Property`.`meta_keywords`, `Property`.`bathrooms_partial`, `Property`.`bathrooms_partial_2`, `Property`.`bathrooms_3_4`, `Property`.`bathrooms_3_4_2`, `Property`.`year_built`, `Property`.`virtual_tour`, `Property`.`video_tour`, `Property`.`digital_brochure`, `Property`.`video_tour_embed_code`, `Property`.`digital_brochure_embed_code`, `Property`.`mls_num`, `Property`.`wsj_property_type`, `Property`.`nyt_property_type`, `Property`.`nyt_popular_features`, `Property`.`propgolux_property_type`, `Property`.`juwai_property_type`, `Property`.`juwai_category`, `Property`.`propgolux_property_style`, `Property`.`wapo_property_type`, `Property`.`robb_property_type`, `Property`.`propgolux_location_id_override`, `Property`.`open_house_1_start`, `Property`.`open_house_1_end_time`, `Property`.`latitude`, `Property`.`longitude`, `Property`.`invalid_required_fields`, `Property`.`invalid_optional_fields`, `Property`.`went_live_today`, `Property`.`converted`, `Property`.`invalid`, `Property`.`mlsidx_full_address`, `Property`.`mlsidx_date_listed`, `Property`.`mls_market`, `Property`.`primary_property_category_id`, `Property`.`realstaq_initial_image_sync`, `Property`.`digital_ad_listing_urls_automated`, `Property`.`modified`, `Property`.`created` FROM `leveragere_staging2`.`properties` AS `Property` WHERE `Property`.`archived` = '0' AND `Property`.`brokerage_id` = (217) ORDER BY RAND() ASC LIMIT 2	2	2	1	maybe slow
SELECT `Image`.`id`, `Image`.`model`, `Image`.`model_id`, `Image`.`tag`, `Image`.`name`, `Image`.`type`, `Image`.`size`, `Image`.`uri`, `Image`.`order`, `Image`.`created`, `Image`.`modified` FROM `leveragere_staging2`.`assets` AS `Image` WHERE `Image`.`model` = 'Property' AND `Image`.`tag` = 'Image' AND `Image`.`model_id` IN (3484, 2633) ORDER BY `Image`.`order` ASC	18	18	2	maybe slow
SELECT `Property`.`id`, `Property`.`brokerage_id`, `Property`.`created_by_user_id`, `Property`.`order`, `Property`.`multi_unit`, `Property`.`agent_1_id`, `Property`.`agent_2_id`, `Property`.`agent_3_id`, `Property`.`name`, `Property`.`incomplete`, `Property`.`archived`, `Property`.`last_archived`, `Property`.`auto_archived_from_mlsidx`, `Property`.`paid_featured`, `Property`.`featured`, `Property`.`homepage_featured`, `Property`.`brokerage_page_featured`, `Property`.`requested_homepage_featured_by_member`, `Property`.`homepage_featured_by_member`, `Property`.`dot_luxury_featured`, `Property`.`luxury_feed_featured`, `Property`.`force_luxury_feed_featured`, `Property`.`luxury_autofeed_imported`, `Property`.`luxury_feed_last_added_time`, `Property`.`luxury_feed_agent_user_id`, `Property`.`luxury_feed_locked_to_subscription_id`, `Property`.`luxury_feed_agent_purchase_date`, `Property`.`luxury_feed_agent_expiration_date`, `Property`.`digital_ad_summary_email_last_sent`, `Property`.`digital_ad_summary_price_changed`, `Property`.`wsj_detail_url`, `Property`.`ft_detail_url`, `Property`.`nyt_detail_url`, `Property`.`juwai_detail_url`, `Property`.`pgl_detail_url`, `Property`.`mg_detail_url`, `Property`.`mg_c_detail_url`, `Property`.`mg_s_detail_url`, `Property`.`bp_detail_url`, `Property`.`mw_detail_url`, `Property`.`nikkei_detail_url`, `Property`.`wapo_detail_url`, `Property`.`robb_detail_url`, `Property`.`medium_featured`, `Property`.`large_featured`, `Property`.`detail_page`, `Property`.`description`, `Property`.`address`, `Property`.`address_2`, `Property`.`city`, `Property`.`state`, `Property`.`postal_code`, `Property`.`country`, `Property`.`use_lat_lng_for_google_map`, `Property`.`currency`, `Property`.`price`, `Property`.`price_2`, `Property`.`price_usd`, `Property`.`price_usd_2`, `Property`.`status`, `Property`.`status_last_changed`, `Property`.`status_last_changed_price_only`, `Property`.`lease_period`, `Property`.`price_upon_request`, `Property`.`bedrooms`, `Property`.`bedrooms_2`, `Property`.`bathrooms`, `Property`.`bathrooms_2`, `Property`.`no_beds_baths`, `Property`.`square_feet`, `Property`.`square_meters`, `Property`.`acres`, `Property`.`interior_unit`, `Property`.`interior_size`, `Property`.`lot_unit`, `Property`.`lot_size`, `Property`.`icon_1`, `Property`.`icon_2`, `Property`.`icon_3`, `Property`.`icon_4`, `Property`.`icon_5`, `Property`.`icon_6`, `Property`.`website`, `Property`.`meta_title`, `Property`.`meta_description`, `Property`.`meta_keywords`, `Property`.`bathrooms_partial`, `Property`.`bathrooms_partial_2`, `Property`.`bathrooms_3_4`, `Property`.`bathrooms_3_4_2`, `Property`.`year_built`, `Property`.`virtual_tour`, `Property`.`video_tour`, `Property`.`digital_brochure`, `Property`.`video_tour_embed_code`, `Property`.`digital_brochure_embed_code`, `Property`.`mls_num`, `Property`.`wsj_property_type`, `Property`.`nyt_property_type`, `Property`.`nyt_popular_features`, `Property`.`propgolux_property_type`, `Property`.`juwai_property_type`, `Property`.`juwai_category`, `Property`.`propgolux_property_style`, `Property`.`wapo_property_type`, `Property`.`robb_property_type`, `Property`.`propgolux_location_id_override`, `Property`.`open_house_1_start`, `Property`.`open_house_1_end_time`, `Property`.`latitude`, `Property`.`longitude`, `Property`.`invalid_required_fields`, `Property`.`invalid_optional_fields`, `Property`.`went_live_today`, `Property`.`converted`, `Property`.`invalid`, `Property`.`mlsidx_full_address`, `Property`.`mlsidx_date_listed`, `Property`.`mls_market`, `Property`.`primary_property_category_id`, `Property`.`realstaq_initial_image_sync`, `Property`.`digital_ad_listing_urls_automated`, `Property`.`modified`, `Property`.`created` FROM `leveragere_staging2`.`properties` AS `Property` WHERE `Property`.`archived` = '0' AND `Property`.`brokerage_id` = (230) ORDER BY RAND() ASC LIMIT 2	0	0	1	maybe slow
SELECT `Property`.`id`, `Property`.`brokerage_id`, `Property`.`created_by_user_id`, `Property`.`order`, `Property`.`multi_unit`, `Property`.`agent_1_id`, `Property`.`agent_2_id`, `Property`.`agent_3_id`, `Property`.`name`, `Property`.`incomplete`, `Property`.`archived`, `Property`.`last_archived`, `Property`.`auto_archived_from_mlsidx`, `Property`.`paid_featured`, `Property`.`featured`, `Property`.`homepage_featured`, `Property`.`brokerage_page_featured`, `Property`.`requested_homepage_featured_by_member`, `Property`.`homepage_featured_by_member`, `Property`.`dot_luxury_featured`, `Property`.`luxury_feed_featured`, `Property`.`force_luxury_feed_featured`, `Property`.`luxury_autofeed_imported`, `Property`.`luxury_feed_last_added_time`, `Property`.`luxury_feed_agent_user_id`, `Property`.`luxury_feed_locked_to_subscription_id`, `Property`.`luxury_feed_agent_purchase_date`, `Property`.`luxury_feed_agent_expiration_date`, `Property`.`digital_ad_summary_email_last_sent`, `Property`.`digital_ad_summary_price_changed`, `Property`.`wsj_detail_url`, `Property`.`ft_detail_url`, `Property`.`nyt_detail_url`, `Property`.`juwai_detail_url`, `Property`.`pgl_detail_url`, `Property`.`mg_detail_url`, `Property`.`mg_c_detail_url`, `Property`.`mg_s_detail_url`, `Property`.`bp_detail_url`, `Property`.`mw_detail_url`, `Property`.`nikkei_detail_url`, `Property`.`wapo_detail_url`, `Property`.`robb_detail_url`, `Property`.`medium_featured`, `Property`.`large_featured`, `Property`.`detail_page`, `Property`.`description`, `Property`.`address`, `Property`.`address_2`, `Property`.`city`, `Property`.`state`, `Property`.`postal_code`, `Property`.`country`, `Property`.`use_lat_lng_for_google_map`, `Property`.`currency`, `Property`.`price`, `Property`.`price_2`, `Property`.`price_usd`, `Property`.`price_usd_2`, `Property`.`status`, `Property`.`status_last_changed`, `Property`.`status_last_changed_price_only`, `Property`.`lease_period`, `Property`.`price_upon_request`, `Property`.`bedrooms`, `Property`.`bedrooms_2`, `Property`.`bathrooms`, `Property`.`bathrooms_2`, `Property`.`no_beds_baths`, `Property`.`square_feet`, `Property`.`square_meters`, `Property`.`acres`, `Property`.`interior_unit`, `Property`.`interior_size`, `Property`.`lot_unit`, `Property`.`lot_size`, `Property`.`icon_1`, `Property`.`icon_2`, `Property`.`icon_3`, `Property`.`icon_4`, `Property`.`icon_5`, `Property`.`icon_6`, `Property`.`website`, `Property`.`meta_title`, `Property`.`meta_description`, `Property`.`meta_keywords`, `Property`.`bathrooms_partial`, `Property`.`bathrooms_partial_2`, `Property`.`bathrooms_3_4`, `Property`.`bathrooms_3_4_2`, `Property`.`year_built`, `Property`.`virtual_tour`, `Property`.`video_tour`, `Property`.`digital_brochure`, `Property`.`video_tour_embed_code`, `Property`.`digital_brochure_embed_code`, `Property`.`mls_num`, `Property`.`wsj_property_type`, `Property`.`nyt_property_type`, `Property`.`nyt_popular_features`, `Property`.`propgolux_property_type`, `Property`.`juwai_property_type`, `Property`.`juwai_category`, `Property`.`propgolux_property_style`, `Property`.`wapo_property_type`, `Property`.`robb_property_type`, `Property`.`propgolux_location_id_override`, `Property`.`open_house_1_start`, `Property`.`open_house_1_end_time`, `Property`.`latitude`, `Property`.`longitude`, `Property`.`invalid_required_fields`, `Property`.`invalid_optional_fields`, `Property`.`went_live_today`, `Property`.`converted`, `Property`.`invalid`, `Property`.`mlsidx_full_address`, `Property`.`mlsidx_date_listed`, `Property`.`mls_market`, `Property`.`primary_property_category_id`, `Property`.`realstaq_initial_image_sync`, `Property`.`digital_ad_listing_urls_automated`, `Property`.`modified`, `Property`.`created` FROM `leveragere_staging2`.`properties` AS `Property` WHERE `Property`.`archived` = '0' AND `Property`.`brokerage_id` = (137) ORDER BY RAND() ASC LIMIT 2	2	2	1	maybe slow
SELECT `Image`.`id`, `Image`.`model`, `Image`.`model_id`, `Image`.`tag`, `Image`.`name`, `Image`.`type`, `Image`.`size`, `Image`.`uri`, `Image`.`order`, `Image`.`created`, `Image`.`modified` FROM `leveragere_staging2`.`assets` AS `Image` WHERE `Image`.`model` = 'Property' AND `Image`.`tag` = 'Image' AND `Image`.`model_id` IN (2469, 903) ORDER BY `Image`.`order` ASC	20	20	1	maybe slow

Query Explain:

Click an "Explain" link above, to see the query explanation.

====

Timer

Memory

Peak Memory Use 21.24 MB

Message	Memory use
Component initialization	2.93 MB
Controller action start	3.86 MB
Controller render start	6.02 MB
View render complete	6.58 MB

Timers

Total Request Time: 350 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	48.89
Event: Controller.initialize	5.13
Event: Controller.startup	2.52
Controller action	58.80
Event: Controller.beforeRender	38.59
» Processing toolbar data	38.50
Rendering View	136.92
» Event: View.beforeRender	0.42
» Rendering APP/View/Brokerages/developments_index.ctp	7.81
» Event: View.afterRender	0.02
» Event: View.beforeLayout	0.01
» Rendering APP/View/Layouts/front.ctp	127.86
Event: View.afterLayout	0.00

====

Log
+

Logs

There were no log entries made this request

====
Variables
+
View Variables
- regular_developments(array)
 0(array)
 Brokerage(array)
 id92
 account_executive_id236
 archived(false)
 typedevelopment
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID2432153
 timezone
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 namePam Harrington Exclusives
 broker_of_record_name
 short_namePam Harrington Exclusives
 usernamePamHarringtonExclusives
 passwordd9957a95a4927b3d3325d107e05944a461d55de6
 password_reset_hash
 monthly_invoice_amount0.00
 monthly_invoice_start_date(null)
 monthly_invoice_end_date(null)
 contract_filename92.pdf
 active(true)
 lead_in
 short_description
 descriptionPam Harrington Exclusives is the exclusive representative for Leverage Global Partners in Wadmalaw Island, Seabrook Island, Johns Island, Kiawah Island, South Carolina, USA. In 1987, Pam Harrington Exclusives began as a small, independent firm amid a sea of large, corporate realty companies and developers competing for business on Kiawah and Seabrook Island. The Pam Harrington Exclusives team quickly established relationships with discerning island homeowners who sought to rent their properties during peak season. Those early relationships continued to grow and served as the foundation upon which our small firm blossomed into the renowned full service real estate company we are today. With over 30 years of experience in island realty, we enjoy sharing our surroundings. If you're looking for oceanfront, fairway, deep water or secluded marshlands, we'll find it on the islands of Kiawah, Seabrook, Johns or Wadmalaw. If the city suits your fancy, we are equally at home in Charleston. We’ve had the pleasure of helping families get to know Seabrook and Kiawah Island through our seasonal rentals – and the honor of seeing them fall in love with these islands and helping them become permanent members of our community. As an independent firm, we are free of corporate demands and able to focus on what’s most important – helping our clients find happiness in the beautiful places we are lucky to call home. Distinguished by profound personal attention, Pam Harrington Exclusives has closed over one billion dollars in sales, one transaction at a time. If you're interested in buying or selling a home or property on Kiawah, Seabrook or the adjacent islands, look no further. We’re proud to represent the beloved island communities whose beauty, value and legacy endure
 communitiesWadmalaw Island Seabrook Island Johns Island Kiawah Island
 websitehttp://www.pamharringtonexclusives.com/
 address4343 Betsy Kerrison Pkwy
 address_2
 cityJohns Island
 stateSC
 full_stateSouth Carolina
 countryUSA
 marketKiawah Island
 market_2
 postal_code29455
 phoneOffice: (843) 768-3635
 phone_2
 phone_3
 wide_contact_image(false)
 contact_namePam Harrington
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titlePresident
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename92.jpg
 logo_filename92.jpg
 contact_image_filename92.jpg
 all_properties_link_image_filename92.JPG
 all_properties_linkhttp://www.pamharringtonexclusives.com/real-estate/kiawah-real-estate
 video_embed_code
 contact_video_embed_code
 meta_titleKiawah Island Real Estate | Pam Harrington Exclusives | Leverage Global Partners
 meta_descriptionPam Harrington Exclusives is the exclusive representative for Leverage Global Partners in Kiawah Island, South Carolina, USA.
 meta_keywordsKiawah Island Real Estate, Pam Harrington Exclusives, Leverage Global Partners, Wadmalaw Island Real Estate, Seabrook Island Real Estate, Johns Island Real Estate
 login_message_counter1
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2014-01-31 18:29:33
 modified2019-09-09 11:37:58
 dre_num012345
 uri/development-detail/92/pam-harrington-exclusives
 website_shortwww.pamharringtonexclusives.com
 name_with_locationPam Harrington Exclusives
 FeaturedImage(array)
 0(array)
 id23030
 modelBrokerage
 model_id92
 tagFeaturedImage
 namebackyard-lights-mansion-32870.jpg
 typeimage/jpeg
 size353456
 uri/assets/23030.jpg
 order0
 created2019-09-09 11:37:38
 modified2019-09-09 11:37:58
 1(array)
 id23039
 modelBrokerage
 model_id92
 tagFeaturedImage
 namearchitecture-bird-s-eye-view-buildings-1587947.jpg
 typeimage/jpeg
 size980979
 uri/assets/23039.jpg
 order1
 created2019-09-09 11:37:40
 modified2019-09-09 11:37:58
 2(array)
 id23036
 modelBrokerage
 model_id92
 tagFeaturedImage
 nameappartment-building-appartments-architecture-87223.jpg
 typeimage/jpeg
 size309517
 uri/assets/23036.jpg
 order2
 created2019-09-09 11:37:40
 modified2019-09-09 11:37:58
 3(array)
 id23035
 modelBrokerage
 model_id92
 tagFeaturedImage
 namearchitectural-design-architecture-blue-sky-1838640.jpg
 typeimage/jpeg
 size895148
 uri/assets/23035.jpg
 order3
 created2019-09-09 11:37:39
 modified2019-09-09 11:37:58
 4(array)
 id23031
 modelBrokerage
 model_id92
 tagFeaturedImage
 nameapartment-architectural-design-architecture-323780.jpg
 typeimage/jpeg
 size332829
 uri/assets/23031.jpg
 order4
 created2019-09-09 11:37:38
 modified2019-09-09 11:37:58
 5(array)
 id23038
 modelBrokerage
 model_id92
 tagFeaturedImage
 namearchitectural-design-architecture-blue-sky-462358.jpg
 typeimage/jpeg
 size382238
 uri/assets/23038.jpg
 order5
 created2019-09-09 11:37:40
 modified2019-09-09 11:37:58
 6(array)
 id23033
 modelBrokerage
 model_id92
 tagFeaturedImage
 namearchitectural-design-architecture-clouds-1732414.jpg
 typeimage/jpeg
 size363725
 uri/assets/23033.jpg
 order6
 created2019-09-09 11:37:39
 modified2019-09-09 11:37:58
 7(array)
 id23034
 modelBrokerage
 model_id92
 tagFeaturedImage
 nameaerial-aerial-shot-architecture-1642125.jpg
 typeimage/jpeg
 size743664
 uri/assets/23034.jpg
 order7
 created2019-09-09 11:37:39
 modified2019-09-09 11:37:58
 8(array)
 id23037
 modelBrokerage
 model_id92
 tagFeaturedImage
 nameaerial-photography-architecture-building-1546168.jpg
 typeimage/jpeg
 size356213
 uri/assets/23037.jpg
 order8
 created2019-09-09 11:37:40
 modified2019-09-09 11:37:58
 9(array)
 id23032
 modelBrokerage
 model_id92
 tagFeaturedImage
 nameapartment-architectural-design-architecture-1436190.jpg
 typeimage/jpeg
 size818644
 uri/assets/23032.jpg
 order9
 created2019-09-09 11:37:38
 modified2019-09-09 11:37:58
 Property(array)
 0(array)
 id3616
 brokerage_id92
 created_by_user_id0
 order0
 multi_unit(false)
 agent_1_id904
 agent_2_id0
 agent_3_id0
 name3120 Privateer Creek
 incomplete(false)
 archived(false)
 last_archived0000-00-00 00:00:00
 auto_archived_from_mlsidx(false)
 paid_featured(false)
 featured(true)
 homepage_featured(false)
 brokerage_page_featured(true)
 requested_homepage_featured_by_member(false)
 homepage_featured_by_member(false)
 dot_luxury_featured(false)
 luxury_feed_featured(false)
 force_luxury_feed_featured(false)
 luxury_autofeed_imported(false)
 luxury_feed_last_added_time0000-00-00 00:00:00
 luxury_feed_agent_user_id0
 luxury_feed_locked_to_subscription_id0
 luxury_feed_agent_purchase_date0000-00-00
 luxury_feed_agent_expiration_date0000-00-00
 digital_ad_summary_email_last_sent0000-00-00 00:00:00
 digital_ad_summary_price_changed(false)
 wsj_detail_url
 ft_detail_url
 nyt_detail_url
 juwai_detail_url
 pgl_detail_url
 mg_detail_url
 mg_c_detail_url
 mg_s_detail_url
 bp_detail_url
 mw_detail_url
 nikkei_detail_url
 wapo_detail_url
 robb_detail_url
 medium_featured(false)
 large_featured(false)
 detail_page(true)
 descriptionThis beautiful and impeccably maintained home with desirable southern exposure is situated with panoramic views of Crooked Oak’s prettiest Par 3 hole. It takes advantage of soft ocean breezes which come down the fairway. Completely renovated through the years since 2007, this spacious home is a distinct Seabrook Island find. Notable features include wide plank walnut stained hardwood floors, high vaulted ceilings with crown molding, built- in cabinets, tons of storage space, several elegant bay windows, and extensive trim work. A covered entry porch gives way to a floor plan perfect for entertaining. The foyer seamlessly flows from the formal dining room to the spacious and bright great room with floor to ceiling windows, and then either to the custom kitchen or to the deck and generous screened porch, which then circles back to the kitchen. A chef's delight, the kitchen features custom cabinetry, a floor to ceiling pantry with pull out drawers, granite countertops, a butcher block center island, high end Viking and Dacor appliances, five burner gas range with commercial vent, two wall ovens, warming drawer, knife and spice drawers, and huge single basin stainless sink. The eat-in kitchen area and breakfast bar offer additional space for quick and casual meals. The oversized master suite on first level features separate seating area nestled into a bay window. A sliding door offers access to the deck. Master bath includes his and her vanities, separate water closet, relaxing oversized jetted soaking tub, and big walk in marble shower. A huge closet is a thoughtfully designed space by California Closets and offers shelving, drawers, hidden laundry bins, a hidden ironing board with recess housing, and lots of hanging areas. There is a second walk in closet for linens, medicines and more. Two other bedrooms, a private study, and a half bath are also located on this level. All bedrooms and FROG offer wall-to-wall carpeting and ceiling fans. The enormous FROG with vaulted ceiling, three sets of windows and skylight, has a full bath and walk in closet, is currently used as a second living area, but could easily be used as a second master, grandparents' suite, media room, playroom, exercise room and more. A private bath and large closet make this private space perfect for any of the above. Don't miss the enormous attic storage. All of this is situated within the beautiful surroundings of Seabrook Island. Tranquil and timeless, Seabrook Island is a private, gated community and a hidden world of natural wonder, adventure and ease. The sandy beaches on the Atlantic provide beautiful sunsets, dolphin watching, and lots of activities. There is are two 18 hole golf courses, a workout center, outdoor pools, an indoor pool, tennis facility, equestrian center, crabbing dock, and restaurants overlooking the ocean. A Kids' Club runs all summer. All of this is just thirty minutes from the bustling energy of historic Charleston. Don't miss this home!
 address3120 Privateer Creek Road
 address_2
 citySeabrook Island
 stateSC
 postal_code29455
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price989000
 price_20
 price_usd989000
 price_usd_20
 statusFor Sale
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(false)
 bedrooms4
 bedrooms_20
 bathrooms3
 bathrooms_20
 no_beds_baths(false)
 square_feet3912
 square_meters
 acres0
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size0
 icon_1sq-ft
 icon_2beach-access
 icon_3views
 icon_4pool
 icon_5tennis
 icon_6
 websitehttp://www.pamharringtonexclusives.com/real-estate/seabrook-island/seabrook-island/3120-privateer-creek-road
 meta_title3120 Privateer Creek | Seabrook Island Real Estate | Pam Harrington Exclusives
 meta_description3120 Privateer Creek Road is a property offered for sale in Seabrook Island, SC, USA, presented by Pam Harrington Exclusives
 meta_keywords
 bathrooms_partial1
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built
 virtual_tour
 video_tourhttps://www.youtube.com/watch?v=fgef6SLJCdY
 digital_brochure
 video_tour_embed_code<iframe width="560" height="315" src="https://www.youtube.com/embed/fgef6SLJCdY?controls=0&showinfo=0" frameborder="0" allowfullscreen></iframe>
 digital_brochure_embed_code
 mls_num
 wsj_property_type
 nyt_property_type
 nyt_popular_features
 propgolux_property_type
 juwai_property_type
 juwai_category
 propgolux_property_style
 wapo_property_type
 robb_property_type
 propgolux_location_id_override
 open_house_1_start0000-00-00 00:00:00
 open_house_1_end_time00:00:00
 latitude0.000000
 longitude0.000000
 invalid_required_fieldslatitude, longitude
 invalid_optional_fieldsagent_2_id, square_meters, acres, hectares, year_built, virtual_tour, wsj_property_type, nyt_property_type, propgolux_property_type, propgolux_property_style
 went_live_today(false)
 converted(true)
 invalid(false)
 mlsidx_full_address
 mlsidx_date_listed0000-00-00
 mls_market
 primary_property_category_id0
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated(null)
 modified2016-04-18 05:33:03
 created2016-03-18 12:24:46
 uri/property-detail/3616/3120-privateer-creek-road-seabrook-island-sc-29455-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3616/3120-privateer-creek-road-seabrook-island-sc-29455-usa
 address_concat3120 Privateer Creek Road Seabrook Island SC 29455 USA
 google_maps_query_string3120+Privateer+Creek+Road++Seabrook+Island+SC+29455+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 989,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty4
 bathrooms_pretty3
 bathrooms_partial_pretty1
 bathrooms_3_4_pretty0
 feed_full_bathrooms3
 date_listed2016-03-18
 overridden_brokerage_name
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 Image(array)
 0(array)
 id20096
 modelProperty
 model_id3616
 tagImage
 name35141.jpg
 typeimage/jpg
 size799621
 uri/assets/20096.jpg
 order0
 created2016-04-07 17:25:39
 modified2016-04-07 17:25:39
 1(array)
 id20098
 modelProperty
 model_id3616
 tagImage
 name35143.jpg
 typeimage/jpg
 size356925
 uri/assets/20098.jpg
 order2
 created2016-04-07 17:25:39
 modified2016-04-07 17:25:39
 2(array)
 id20090
 modelProperty
 model_id3616
 tagImage
 name35135.jpg
 typeimage/jpg
 size450367
 uri/assets/20090.jpg
 order3
 created2016-04-07 17:25:38
 modified2016-04-07 17:25:38
 3(array)
 id20092
 modelProperty
 model_id3616
 tagImage
 name35137.jpg
 typeimage/jpg
 size398323
 uri/assets/20092.jpg
 order4
 created2016-04-07 17:25:38
 modified2016-04-07 17:25:38
 4(array)
 id20089
 modelProperty
 model_id3616
 tagImage
 name35136.jpg
 typeimage/jpg
 size382071
 uri/assets/20089.jpg
 order5
 created2016-04-07 17:25:38
 modified2016-04-07 17:25:38
 5(array)
 id20093
 modelProperty
 model_id3616
 tagImage
 name35138.jpg
 typeimage/jpg
 size460365
 uri/assets/20093.jpg
 order6
 created2016-04-07 17:25:38
 modified2016-04-07 17:25:38
 6(array)
 id20094
 modelProperty
 model_id3616
 tagImage
 name35139.jpg
 typeimage/jpg
 size349545
 uri/assets/20094.jpg
 order7
 created2016-04-07 17:25:38
 modified2016-04-07 17:25:38
 7(array)
 id20095
 modelProperty
 model_id3616
 tagImage
 name35140.jpg
 typeimage/jpg
 size455370
 uri/assets/20095.jpg
 order8
 created2016-04-07 17:25:38
 modified2016-04-07 17:25:39
 8(array)
 id20091
 modelProperty
 model_id3616
 tagImage
 name35166.jpg
 typeimage/jpg
 size459938
 uri/assets/20091.jpg
 order9
 created2016-04-07 17:25:38
 modified2016-04-07 17:25:38
 9(array)
 id20097
 modelProperty
 model_id3616
 tagImage
 name35142.jpg
 typeimage/jpg
 size351244
 uri/assets/20097.jpg
 order9
 created2016-04-07 17:25:39
 modified2016-04-07 17:25:39
 1(array)
 id3618
 brokerage_id92
 created_by_user_id0
 order0
 multi_unit(false)
 agent_1_id902
 agent_2_id0
 agent_3_id0
 nameExclusive Auction Opportunity
 incomplete(false)
 archived(false)
 last_archived0000-00-00 00:00:00
 auto_archived_from_mlsidx(false)
 paid_featured(false)
 featured(true)
 homepage_featured(false)
 brokerage_page_featured(true)
 requested_homepage_featured_by_member(false)
 homepage_featured_by_member(false)
 dot_luxury_featured(false)
 luxury_feed_featured(false)
 force_luxury_feed_featured(false)
 luxury_autofeed_imported(false)
 luxury_feed_last_added_time0000-00-00 00:00:00
 luxury_feed_agent_user_id0
 luxury_feed_locked_to_subscription_id0
 luxury_feed_agent_purchase_date0000-00-00
 luxury_feed_agent_expiration_date0000-00-00
 digital_ad_summary_email_last_sent0000-00-00 00:00:00
 digital_ad_summary_price_changed(false)
 wsj_detail_url
 ft_detail_url
 nyt_detail_url
 juwai_detail_url
 pgl_detail_url
 mg_detail_url
 mg_c_detail_url
 mg_s_detail_url
 bp_detail_url
 mw_detail_url
 nikkei_detail_url
 wapo_detail_url
 robb_detail_url
 medium_featured(false)
 large_featured(false)
 detail_page(true)
 descriptionGracious, five bedroom Low Country custom home with deep-water dock on the Stono River, part of the Intracoastal waterways, located within a small waterfront community just 10 miles from historic downtown Charleston. Many architectural details throughout including wide baseboard & crown molding, wainscoting, columns, tray ceiling, archways, picture windows, pocket doors, ceiling fans, in-ceiling speakers, recessed lighting & elevator shaft. Wall-to-wall windows and French doors, upper & lower decks provide panoramic water vistas. Living room with cozy gas log fireplace, wall-to-wall windows & French doors, centered around Chef's kitchen provide ample room for family anand guests to gather, all the while enjoying fabulous water vistas. A formal dining room and sunny breakfast area provide additional dining options. Master suite on main floor with sitting/sun room provides plenty of light and panoramic water views - luxury bath features oversize European style walk-in shower with wall jets, overhead & hand-held spray nozzle, jetted tub, bidet, spacious walk-in closet and heated stone flooring. Three additional bedrooms with two full baths, plus media/family room on second level offer plenty of room for family or guests. Mother-in-law suite with separate entrance has living/dining room, bedroom, full kitchen and bathroom. Boaters paradise with deep-water dock with water & electricity, pier head, floating dock and 6,000 lb boat lift. Purchase also includes lot across the road TMS285-13-00-029 .37 acre. Agent is not engaging in auctioneering activities. Seller offering property via online auction. Bid online beginning Monday, May 23rd, with a starting bid of $750,000. Open house preview schedule: Friday, May 20th, 11am – 2pm Saturday, May 21st, 11am – 3pm Sunday, May 22nd, 1-4pm Contact Interluxe.com for full terms and conditions of the sale, details of registration or to schedule an appointment to preview the home. 
 address5678 Captain Kidd Road
 address_2
 cityHollywood
 stateSC
 postal_code29449
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price0
 price_20
 price_usd0
 price_usd_20
 statusFor Sale
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(true)
 bedrooms5
 bedrooms_20
 bathrooms5
 bathrooms_20
 no_beds_baths(false)
 square_feet5338
 square_meters
 acres0
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size0
 icon_1sq-ft
 icon_2balcony-terrace
 icon_3views
 icon_4waterfront
 icon_5dock
 icon_6
 websitehttp://www.pamharringtonexclusives.com/real-estate/hollywood/royal-harbor/5678-captain-kidd-road
 meta_titleExclusive Auction Opportunity | Hollywood Real Estate | Pam Harrington Exclusives
 meta_description5678 Captain Kidd Road is a property offered for sale in Hollywood, SC, USA, presented by Pam Harrington Exclusives
 meta_keywords
 bathrooms_partial1
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built
 virtual_tour
 video_tour
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num
 wsj_property_type
 nyt_property_type
 nyt_popular_features
 propgolux_property_type
 juwai_property_type
 juwai_category
 propgolux_property_style
 wapo_property_type
 robb_property_type
 propgolux_location_id_override
 open_house_1_start0000-00-00 00:00:00
 open_house_1_end_time00:00:00
 latitude0.000000
 longitude0.000000
 invalid_required_fieldsprice
 invalid_optional_fieldsagent_2_id, square_meters, acres, hectares, virtual_tour, video_tour
 went_live_today(false)
 converted(true)
 invalid(false)
 mlsidx_full_address
 mlsidx_date_listed0000-00-00
 mls_market
 primary_property_category_id0
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated(null)
 modified2016-04-07 17:25:39
 created2016-03-18 12:51:03
 uri/property-detail/3618/5678-captain-kidd-road-hollywood-sc-29449-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3618/5678-captain-kidd-road-hollywood-sc-29449-usa
 address_concat5678 Captain Kidd Road Hollywood SC 29449 USA
 google_maps_query_string5678+Captain+Kidd+Road++Hollywood+SC+29449+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 0
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty5
 bathrooms_pretty5
 bathrooms_partial_pretty1
 bathrooms_3_4_pretty0
 feed_full_bathrooms5
 date_listed2016-03-18
 overridden_brokerage_name
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 Image(array)
 0(array)
 id20099
 modelProperty
 model_id3618
 tagImage
 name35154.jpg
 typeimage/jpg
 size813324
 uri/assets/20099.jpg
 order0
 created2016-04-07 17:25:39
 modified2016-04-07 17:25:39
 1(array)
 id20103
 modelProperty
 model_id3618
 tagImage
 name35158.jpg
 typeimage/jpg
 size684438
 uri/assets/20103.jpg
 order1
 created2016-04-07 17:25:39
 modified2016-04-07 17:25:39
 2(array)
 id20101
 modelProperty
 model_id3618
 tagImage
 name35156.jpg
 typeimage/jpg
 size450358
 uri/assets/20101.jpg
 order2
 created2016-04-07 17:25:39
 modified2016-04-07 17:25:39
 3(array)
 id20100
 modelProperty
 model_id3618
 tagImage
 name35155.jpg
 typeimage/jpg
 size450975
 uri/assets/20100.jpg
 order3
 created2016-04-07 17:25:39
 modified2016-04-07 17:25:39
 4(array)
 id20102
 modelProperty
 model_id3618
 tagImage
 name35157.jpg
 typeimage/jpg
 size904937
 uri/assets/20102.jpg
 order4
 created2016-04-07 17:25:39
 modified2016-04-07 17:25:39
 5(array)
 id20105
 modelProperty
 model_id3618
 tagImage
 name35160.jpg
 typeimage/jpg
 size547431
 uri/assets/20105.jpg
 order5
 created2016-04-07 17:25:39
 modified2016-04-07 17:25:39
 6(array)
 id20104
 modelProperty
 model_id3618
 tagImage
 name35159.jpg
 typeimage/jpg
 size556942
 uri/assets/20104.jpg
 order6
 created2016-04-07 17:25:39
 modified2016-04-07 17:25:39
 7(array)
 id20106
 modelProperty
 model_id3618
 tagImage
 name35161.jpg
 typeimage/jpg
 size573355
 uri/assets/20106.jpg
 order7
 created2016-04-07 17:25:39
 modified2016-04-07 17:25:39
 8(array)
 id20107
 modelProperty
 model_id3618
 tagImage
 name35162.jpg
 typeimage/jpg
 size966803
 uri/assets/20107.jpg
 order8
 created2016-04-07 17:25:39
 modified2016-04-07 17:25:39
 9(array)
 id20108
 modelProperty
 model_id3618
 tagImage
 name35163.jpg
 typeimage/jpg
 size659844
 uri/assets/20108.jpg
 order9
 created2016-04-07 17:25:39
 modified2016-04-07 17:25:39
 1(array)
 Brokerage(array)
 id217
 account_executive_id236
 archived(false)
 typedevelopment
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID2347592
 timezone
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameDeSell & Co. Realty Group - Equine Specialist
 broker_of_record_name
 short_nameDeSell & Co. Realty Group - Equine Specialist
 usernameDeSell&Co
 password6f2de2ecbf41c5f96a6c97aefe21779219980a88
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date(null)
 monthly_invoice_end_date(null)
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionDeSell & Co. Realty Group is the exclusive equine representative for Leverage Global Partners in Southern Pines, Aberdeen, Carthage, Vass, and Cameron, North Carolina, USA. In 2007, after Jo-an DeSell had been in real estate sales for about seven years, she decided that it was time to brand herself as a horse farm specialist because of her long standing career as a professional horsewoman. It made perfect sense to have an equestrian specialist in an area with several hundred horse farms flanking over 4,000 acres of preserve land known as the Walthour-Moss Foundation. The Foundation is dedicated to protecting and improving wildlife habitat, along with providing a place for equestrian purposes…foxhunting, trail riding and carriage driving. This is the largest privately owned preserve in the United States with trails, firelanes and cross country fences for all riders and drivers to enjoy. In 2010, Jo-an saw a need for an additional broker and called on Audrey Wiggins to join her because of her equestrian background, along with her real estate knowledge, which she felt would enhance the team. Audrey and Jo-an worked closely together to create a team dedicated to exceptional customer service. They both began their real estate careers at about the same time and had the same strong work ethic and desire to provide the best buyer and seller experience in the marketplace. Knowing that every firm needs solid administration and marketing, they hired Julie Pressley. With her business degree, prior real estate experience and having owned and operated her own business, she was a perfect fit for the DeSell team. Jo-an’s and Audrey’s sales production continues to climb and they have consistently ranked in the top 10 percent in sales in their MLS. As the local market improves, DeSell is well positioned to provide superior service to all of its clients, and its success continues to be measured by their happiness and loyalty.
 communitiesSouthern Pines Aberdeen Carthage Vass Cameron
 websitehttp://www.searchsouthernpinesareahomes.com/
 address730 S Bennett St Ste A
 address_2
 citySouthern Pines
 stateNC
 full_stateNorth Carolina
 countryUSA
 market
 market_2
 postal_code28387
 phone(910) 692-0770
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameJo-an DeSell
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleBroker/Owner
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename217.JPG
 logo_filename217.jpg
 contact_image_filename217.jpg
 all_properties_link_image_filename217.JPG
 all_properties_linkhttp://www.searchsouthernpinesareahomes.com/results/?UserID=all
 video_embed_code
 contact_video_embed_code
 meta_titleSouthern Pines Equine Real Estate | DeSell & Co. Realty Group | Leverage Global Partners
 meta_descriptionDeSell & Co. Realty Group is the exclusive equine representative for Leverage Global Partners in Southern Pines, Aberdeen, Carthage, Vass, and Cameron, North Carolina, USA.
 meta_keywordsDeSell & Co. Realty Group, Southern Pines real estate, Aberdeen real estate, Carthage real estate, Vass real estate, Cameron real estate, North Carolina real estate
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2015-08-11 10:43:27
 modified2019-09-09 11:33:11
 dre_num012345
 uri/development-detail/217/desell-co-realty-group-equine-specialist
 website_shortwww.searchsouthernpinesareahomes.com
 name_with_locationDeSell & Co. Realty Group - Equine Specialist
 FeaturedImage(array)
 0(array)
 id23029
 modelBrokerage
 model_id217
 tagFeaturedImage
 namearchitectural-design-architecture-clouds-1732414.jpg
 typeimage/jpeg
 size363725
 uri/assets/23029.jpg
 order0
 created2019-09-09 11:33:01
 modified2019-09-09 11:33:12
 1(array)
 id23024
 modelBrokerage
 model_id217
 tagFeaturedImage
 namearchitecture-bird-s-eye-view-buildings-1587947.jpg
 typeimage/jpeg
 size980979
 uri/assets/23024.jpg
 order1
 created2019-09-09 11:33:00
 modified2019-09-09 11:33:12
 2(array)
 id23022
 modelBrokerage
 model_id217
 tagFeaturedImage
 nameapartment-architectural-design-architecture-1436190.jpg
 typeimage/jpeg
 size818644
 uri/assets/23022.jpg
 order2
 created2019-09-09 11:32:59
 modified2019-09-09 11:33:12
 3(array)
 id23021
 modelBrokerage
 model_id217
 tagFeaturedImage
 nameapartment-architectural-design-architecture-323780.jpg
 typeimage/jpeg
 size332829
 uri/assets/23021.jpg
 order3
 created2019-09-09 11:32:59
 modified2019-09-09 11:33:12
 4(array)
 id23023
 modelBrokerage
 model_id217
 tagFeaturedImage
 namebackyard-lights-mansion-32870.jpg
 typeimage/jpeg
 size353456
 uri/assets/23023.jpg
 order4
 created2019-09-09 11:33:00
 modified2019-09-09 11:33:12
 5(array)
 id23025
 modelBrokerage
 model_id217
 tagFeaturedImage
 nameaerial-photography-architecture-building-1546168.jpg
 typeimage/jpeg
 size356213
 uri/assets/23025.jpg
 order5
 created2019-09-09 11:33:00
 modified2019-09-09 11:33:12
 6(array)
 id23026
 modelBrokerage
 model_id217
 tagFeaturedImage
 nameaerial-aerial-shot-architecture-1642125.jpg
 typeimage/jpeg
 size743664
 uri/assets/23026.jpg
 order6
 created2019-09-09 11:33:00
 modified2019-09-09 11:33:12
 7(array)
 id23027
 modelBrokerage
 model_id217
 tagFeaturedImage
 nameappartment-building-appartments-architecture-87223.jpg
 typeimage/jpeg
 size309517
 uri/assets/23027.jpg
 order7
 created2019-09-09 11:33:00
 modified2019-09-09 11:33:12
 8(array)
 id23028
 modelBrokerage
 model_id217
 tagFeaturedImage
 namearchitectural-design-architecture-blue-sky-1838640.jpg
 typeimage/jpeg
 size895148
 uri/assets/23028.jpg
 order8
 created2019-09-09 11:33:00
 modified2019-09-09 11:33:12
 9(array)
 id23020
 modelBrokerage
 model_id217
 tagFeaturedImage
 namearchitectural-design-architecture-blue-sky-462358.jpg
 typeimage/jpeg
 size382238
 uri/assets/23020.jpg
 order9
 created2019-09-09 11:32:58
 modified2019-09-09 11:33:12
 Property(array)
 0(array)
 id3484
 brokerage_id217
 created_by_user_id0
 order0
 multi_unit(false)
 agent_1_id826
 agent_2_id0
 agent_3_id0
 name21 Acre Farm With Barn and Apartment
 incomplete(false)
 archived(false)
 last_archived0000-00-00 00:00:00
 auto_archived_from_mlsidx(false)
 paid_featured(false)
 featured(true)
 homepage_featured(true)
 brokerage_page_featured(true)
 requested_homepage_featured_by_member(false)
 homepage_featured_by_member(false)
 dot_luxury_featured(false)
 luxury_feed_featured(false)
 force_luxury_feed_featured(false)
 luxury_autofeed_imported(false)
 luxury_feed_last_added_time0000-00-00 00:00:00
 luxury_feed_agent_user_id0
 luxury_feed_locked_to_subscription_id0
 luxury_feed_agent_purchase_date0000-00-00
 luxury_feed_agent_expiration_date0000-00-00
 digital_ad_summary_email_last_sent0000-00-00 00:00:00
 digital_ad_summary_price_changed(false)
 wsj_detail_url
 ft_detail_url
 nyt_detail_url
 juwai_detail_url
 pgl_detail_url
 mg_detail_url
 mg_c_detail_url
 mg_s_detail_url
 bp_detail_url
 mw_detail_url
 nikkei_detail_url
 wapo_detail_url
 robb_detail_url
 medium_featured(false)
 large_featured(false)
 detail_page(true)
 descriptionWonderful 21 acre farm with everything that any buyer could want or need....as well as impeccably maintained! In addition to main residence, is a 2 bedroom/1 bath apartment with open floor plan and vistas from every window of the pastures, countryside and 4 acre adjoining lake. The block 6 stall barn also includes, feed room, tack room, fly system and so much more. 
 address301 Hollybrook Farm Lane
 address_2
 cityVass
 stateNC
 postal_code28394
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price1100000
 price_20
 price_usd1100000
 price_usd_20
 statusFor Sale
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(false)
 bedrooms3
 bedrooms_20
 bathrooms2
 bathrooms_20
 no_beds_baths(false)
 square_feet0
 square_meters
 acres21
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size21
 icon_1acreage
 icon_2guest-house
 icon_3views
 icon_4
 icon_5
 icon_6
 websitehttp://www.flexmls.com/share/POFU/301HollybrookFarmLaneLaneVassNC28394
 meta_title21 Acre Farm With Barn and Apartment | Vass Real Estate | DeSell & Co. Realty Group - Equine Specialist
 meta_description301 Hollybrook Farm Lane is a property offered for sale in Vass, NC, USA, presented by DeSell & Co. Realty Group - Equine Specialist
 meta_keywords
 bathrooms_partial1
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built
 virtual_tourhttp://www.seetheproperty.com/189143
 video_tour
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num
 wsj_property_type
 nyt_property_type
 nyt_popular_features
 propgolux_property_type
 juwai_property_type
 juwai_category
 propgolux_property_style
 wapo_property_type
 robb_property_type
 propgolux_location_id_override
 open_house_1_start0000-00-00 00:00:00
 open_house_1_end_time00:00:00
 latitude0.000000
 longitude0.000000
 invalid_required_fieldslatitude, longitude
 invalid_optional_fieldsagent_2_id, square_feet, square_meters, hectares, year_built, video_tour, wsj_property_type, nyt_property_type, propgolux_property_type, propgolux_property_style
 went_live_today(false)
 converted(true)
 invalid(false)
 mlsidx_full_address
 mlsidx_date_listed0000-00-00
 mls_market
 primary_property_category_id0
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated(null)
 modified2016-04-18 05:33:03
 created2016-02-24 07:22:12
 uri/property-detail/3484/301-hollybrook-farm-lane-vass-nc-28394-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3484/301-hollybrook-farm-lane-vass-nc-28394-usa
 address_concat301 Hollybrook Farm Lane Vass NC 28394 USA
 google_maps_query_string301+Hollybrook+Farm+Lane++Vass+NC+28394+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 1,100,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty3
 bathrooms_pretty2
 bathrooms_partial_pretty1
 bathrooms_3_4_pretty0
 feed_full_bathrooms2
 date_listed2016-02-24
 overridden_brokerage_name
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 Image(array)
 0(array)
 id19556
 modelProperty
 model_id3484
 tagImage
 name33908.jpg
 typeimage/jpg
 size308300
 uri/assets/19556.jpg
 order0
 created2016-04-07 17:24:14
 modified2016-04-07 17:24:14
 1(array)
 id19555
 modelProperty
 model_id3484
 tagImage
 name33909.jpg
 typeimage/jpg
 size512818
 uri/assets/19555.jpg
 order1
 created2016-04-07 17:24:14
 modified2016-04-07 17:24:14
 2(array)
 id19554
 modelProperty
 model_id3484
 tagImage
 name33910.jpg
 typeimage/jpg
 size560284
 uri/assets/19554.jpg
 order2
 created2016-04-07 17:24:14
 modified2016-04-07 17:24:14
 3(array)
 id19553
 modelProperty
 model_id3484
 tagImage
 name33911.jpg
 typeimage/jpg
 size714427
 uri/assets/19553.jpg
 order3
 created2016-04-07 17:24:14
 modified2016-04-07 17:24:14
 4(array)
 id19552
 modelProperty
 model_id3484
 tagImage
 name33912.jpg
 typeimage/jpg
 size446536
 uri/assets/19552.jpg
 order4
 created2016-04-07 17:24:14
 modified2016-04-07 17:24:14
 5(array)
 id19551
 modelProperty
 model_id3484
 tagImage
 name33913.jpg
 typeimage/jpg
 size578918
 uri/assets/19551.jpg
 order5
 created2016-04-07 17:24:14
 modified2016-04-07 17:24:14
 6(array)
 id19550
 modelProperty
 model_id3484
 tagImage
 name33914.jpg
 typeimage/jpg
 size643285
 uri/assets/19550.jpg
 order6
 created2016-04-07 17:24:14
 modified2016-04-07 17:24:14
 7(array)
 id19557
 modelProperty
 model_id3484
 tagImage
 name33915.jpg
 typeimage/jpg
 size382037
 uri/assets/19557.jpg
 order7
 created2016-04-07 17:24:14
 modified2016-04-07 17:24:14
 1(array)
 id2633
 brokerage_id217
 created_by_user_id0
 order6
 multi_unit(false)
 agent_1_id826
 agent_2_id0
 agent_3_id0
 nameQuail Glen
 incomplete(false)
 archived(false)
 last_archived0000-00-00 00:00:00
 auto_archived_from_mlsidx(false)
 paid_featured(false)
 featured(true)
 homepage_featured(false)
 brokerage_page_featured(true)
 requested_homepage_featured_by_member(false)
 homepage_featured_by_member(false)
 dot_luxury_featured(false)
 luxury_feed_featured(false)
 force_luxury_feed_featured(false)
 luxury_autofeed_imported(false)
 luxury_feed_last_added_time0000-00-00 00:00:00
 luxury_feed_agent_user_id0
 luxury_feed_locked_to_subscription_id0
 luxury_feed_agent_purchase_date0000-00-00
 luxury_feed_agent_expiration_date0000-00-00
 digital_ad_summary_email_last_sent0000-00-00 00:00:00
 digital_ad_summary_price_changed(false)
 wsj_detail_url
 ft_detail_url
 nyt_detail_url
 juwai_detail_url
 pgl_detail_url
 mg_detail_url
 mg_c_detail_url
 mg_s_detail_url
 bp_detail_url
 mw_detail_url
 nikkei_detail_url
 wapo_detail_url
 robb_detail_url
 medium_featured(false)
 large_featured(false)
 detail_page(true)
 descriptionRemarkable beauty, privacy and location all describe this 43+ acre horse farm which is conveniently located 3 miles from downtown Southern Pines and a mere two minute hack to the Walthour-Moss Foundation preserve. The 4 bedroom/4 bath main brick home has large rooms, abundant closets, hardwood floors and a 16'x54' deck. A 3br/2ba guest home could also double as a care-taker cottage being easily accessible from the entrance to the property. Between the two homes is the 8 stall barn with apartment above + five 4 board double fenced paddocks - three with run-ins, riding ring, additional pasture, three car garage w/workshop and kennel attached. This beautiful property is not only in the heart of ''Horse Country''........but adjacent to the Hunter Trial course/grounds that these sellers do... the Walthour-Moss Foundation Preserve. Consequently, more privacy and ''no'' neighbors on a good portion of the property. A magnificent farm, rarely offered for sale!
 address251 Quail Glen Lane
 address_2
 citySouthern Pines
 stateNC
 postal_code28387
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price1700000
 price_20
 price_usd1700000
 price_usd_20
 statusFor Sale
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(false)
 bedrooms4
 bedrooms_20
 bathrooms4
 bathrooms_20
 no_beds_baths(false)
 square_feet2887
 square_meters
 acres43
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size43
 icon_1acreage
 icon_2guest-house
 icon_3sq-ft
 icon_4
 icon_5
 icon_6
 websitehttp://www.flexmls.com/share/QmPC/251QuailGlenLaneSouthernPinesNC28387
 meta_titleQuail Glen | Southern Pines Real Estate | DeSell & Co. Realty Group - Equine Specialist
 meta_description251 Quail Glen Lane is a property offered for sale in Southern Pines, NC, USA, presented by DeSell & Co. Realty Group - Equine Specialist
 meta_keywords
 bathrooms_partial0
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built
 virtual_tourhttp://www.seetheproperty.com/148908
 video_tour
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num
 wsj_property_type
 nyt_property_type
 nyt_popular_features
 propgolux_property_type
 juwai_property_type
 juwai_category
 propgolux_property_style
 wapo_property_type
 robb_property_type
 propgolux_location_id_override
 open_house_1_start0000-00-00 00:00:00
 open_house_1_end_time00:00:00
 latitude0.000000
 longitude0.000000
 invalid_required_fields
 invalid_optional_fieldsagent_2_id, bathrooms_partial, square_meters, hectares, video_tour
 went_live_today(false)
 converted(true)
 invalid(false)
 mlsidx_full_address
 mlsidx_date_listed0000-00-00
 mls_market
 primary_property_category_id0
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated(null)
 modified2016-04-18 05:33:02
 created2015-08-13 13:30:03
 uri/property-detail/2633/251-quail-glen-lane-southern-pines-nc-28387-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/2633/251-quail-glen-lane-southern-pines-nc-28387-usa
 address_concat251 Quail Glen Lane Southern Pines NC 28387 USA
 google_maps_query_string251+Quail+Glen+Lane++Southern+Pines+NC+28387+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 1,700,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty4
 bathrooms_pretty4
 bathrooms_partial_pretty0
 bathrooms_3_4_pretty0
 feed_full_bathrooms4
 date_listed2015-08-13
 overridden_brokerage_name
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 Image(array)
 0(array)
 id16266
 modelProperty
 model_id2633
 tagImage
 name25946.jpg
 typeimage/jpg
 size817996
 uri/assets/16266.jpg
 order0
 created2016-04-07 16:57:11
 modified2016-04-07 16:57:11
 1(array)
 id16260
 modelProperty
 model_id2633
 tagImage
 name24718.jpg
 typeimage/jpg
 size388990
 uri/assets/16260.jpg
 order1
 created2016-04-07 16:57:11
 modified2016-04-07 16:57:11
 2(array)
 id16259
 modelProperty
 model_id2633
 tagImage
 name25947.jpg
 typeimage/jpg
 size856525
 uri/assets/16259.jpg
 order2
 created2016-04-07 16:57:10
 modified2016-04-07 16:57:11
 3(array)
 id16267
 modelProperty
 model_id2633
 tagImage
 name25774.jpg
 typeimage/jpg
 size864111
 uri/assets/16267.jpg
 order3
 created2016-04-07 16:57:11
 modified2016-04-07 16:57:11
 4(array)
 id16265
 modelProperty
 model_id2633
 tagImage
 name25773.jpg
 typeimage/jpg
 size758190
 uri/assets/16265.jpg
 order4
 created2016-04-07 16:57:11
 modified2016-04-07 16:57:11
 5(array)
 id16268
 modelProperty
 model_id2633
 tagImage
 name24726.jpg
 typeimage/jpg
 size414511
 uri/assets/16268.jpg
 order5
 created2016-04-07 16:57:11
 modified2016-04-07 16:57:11
 6(array)
 id16261
 modelProperty
 model_id2633
 tagImage
 name24719.jpg
 typeimage/jpg
 size1638953
 uri/assets/16261.jpg
 order6
 created2016-04-07 16:57:11
 modified2016-04-07 16:57:11
 7(array)
 id16262
 modelProperty
 model_id2633
 tagImage
 name24720.jpg
 typeimage/jpg
 size1685589
 uri/assets/16262.jpg
 order7
 created2016-04-07 16:57:11
 modified2016-04-07 16:57:11
 8(array)
 id16263
 modelProperty
 model_id2633
 tagImage
 name24721.jpg
 typeimage/jpg
 size1675838
 uri/assets/16263.jpg
 order8
 created2016-04-07 16:57:11
 modified2016-04-07 16:57:11
 9(array)
 id16264
 modelProperty
 model_id2633
 tagImage
 name24722.jpg
 typeimage/jpg
 size1561128
 uri/assets/16264.jpg
 order9
 created2016-04-07 16:57:11
 modified2016-04-07 16:57:11
 2(array)
 Brokerage(array)
 id230
 account_executive_id235
 archived(false)
 typedevelopment
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typeBasic
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(true)
 country_id0
 WOEID2462584
 timezone
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameJoyce Realty
 broker_of_record_name
 short_nameJoyce Realty
 usernameJoyceRealty
 passwordff5520901517b0592d6f40cb349374807f5a6dc0
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date(null)
 monthly_invoice_end_date(null)
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionJoyce Realty is the exclusive representative for Leverage Global Partners in Rockland County, including the cities of Airmont, Bardonia, Blauvelt, Central Nyack, Chestnut Ridge, Clarkstown, Congers, Garnerville, Grand View, Haverstraw, Hillburn, Hillcrest, Monsey, Montebello, Nanuet, New City, New Square, Nyack, Orangeburg, Orangetown, Palisades, Pearl River, Piermont, Pomona, Ramapo, Sloatsburg, Snedens Landing, South Nyack, South Spring Valley, Sparkill, Spring Valley, Stony Point, Suffern, Tallman, Tappan, Thiells, Tomkins Cove, Upper Grandview, Upper Nyack, Valley Cottage, Wesley Hills, West Haverstraw, and West Nyack, NY, USA. A message from our President: A commitment to investing in people, not just real estate, has always been Kevin Joyce’s driving force. As the principal broker at Joyce Realty, Kevin has spent years running the number one independent real estate office serving the northern suburbs of the New York Hudson Valley and Northern New Jersey markets. Though his first love was the theater, an elective real estate course during college convinced both he (and his broker/agent mother- Mary Ellen Joyce) that he had a penchant for, and promising future in, real estate. Alongside his mother, Kevin established Joyce Realty in 1994, and soon developed it into a strong regional brand, with core values dedicated to the clients and the agents working with him. A self-proclaimed “hands-on guy,” Kevin continues to develop Joyce’s brand and service to their clients with a strong, cutting-edge media presence not offered by other firms. Joyce Realty’s goal is a seamless transaction, whether your goal is buying, selling, or relocating. As a full- service real estate provider with local to global relocation expertise, they proudly serve several of the world’s Fortune 500 companies. Joyce Realty is a proud exclusive affiliate for the New York Metro Area for Leverage Global Partners. Joyce Realty is raising the bar of excellence for real estate: Strong, trusted, growing...That’s Joyce. Licensed Real Estate Brokerage New York and New Jersey
 communitiesRockland County Airmont Bardonia Blauvelt Central Nyack Chestnut Ridge Clarkstown Congers Garnerville Grand View Haverstraw Hillburn Hillcrest Monsey Montebello Nanuet New City New Square Nyack Orangeburg Orangetown Palisades Pearl River Piermont Pomona Ramapo Sloatsburg Snedens Landing South Nyack South Spring Valley Sparkill Spring Valley Stony Point Suffern Tallman Tappan Thiells Tomkins Cove Upper Grandview Upper Nyack Valley Cottage Wesley Hills West Haverstraw West Nyack Nyack Blauvelt Palisades
 websitehttp://www.joycerealty.com/
 address21 N Williams Street
 address_2
 cityPearl River
 stateNY
 full_stateNew York
 countryUSA
 marketRockland County
 market_2
 postal_code10965
 phoneCell: (914) 393-0100
 phone_2Office: (800) 275-5692
 phone_3
 wide_contact_image(false)
 contact_nameKevin Joyce
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titlePresident/Broker
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename230.jpg
 logo_filename230.jpg
 contact_image_filename230.jpg
 all_properties_link_image_filename230.jpg
 all_properties_linkhttp://www.joycerealty.com/
 video_embed_code
 contact_video_embed_code
 meta_titleRockland County Real Estate | Joyce Realty | Leverage Global Partners
 meta_descriptionJoyce Realty is the exclusive representative for Leverage Global Partners in Rockland County, including the cities of Airmont, Bardonia, Blauvelt, Central Nyack, Chestnut Ridge, Clarkstown, Congers, Garnerville, Grand View, Haverstraw, Hillburn, Hillcrest, Monsey, Montebello, Nanuet, New City, New Square, Nyack, Orangeburg, Orangetown, Palisades, Pearl River, Piermont, Pomona, Ramapo, Sloatsburg, Snedens Landing, South Nyack, South Spring Valley, Sparkill, Spring Valley, Stony Point, Suffern, Tallman, Tappan, Thiells, Tomkins Cove, Upper Grandview, Upper Nyack, Valley Cottage, Wesley Hills, West Haverstraw, and West Nyack, NY, USA.
 meta_keywordsJoyce Realty, Leverage Global Partners, Rockland County real estate, Airmont real estate, Bardonia real estate, Blauvelt real estate, Central Nyack real estate, Chestnut Ridge real estate, Clarkstown real estate, Congers real estate, Garnerville real estate, Grand View real estate, Haverstraw real estate, Hillburn real estate, Hillcrest real estate, Monsey real estate, Montebello real estate, Nanuet real estate, New City real estate, New Square real estate, Nyack real estate, Orangeburg real estate, Orangetown real estate, Palisades real estate, Pearl River real estate, Piermont real estate, Pomona real estate, Ramapo real estate, Sloatsburg real estate, Snedens Landing real estate, South Nyack real estate, South Spring Valley real estate, Sparkill real estate, Spring Valley real estate, Stony Point real estate, Suffern real estate, Tallman real estate, Tappan real estate, Thiells real estate, Tomkins Cove real estate, Upper Grandview real estate, Upper Nyack real estate, Valley Cottage real estate, Wesley Hills real estate, West Haverstraw real estate, West Nyack real estate
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2015-10-21 10:28:46
 modified2019-09-09 11:39:50
 dre_num012345
 uri/development-detail/230/joyce-realty
 website_shortwww.joycerealty.com
 name_with_locationJoyce Realty
 FeaturedImage(array)
 0(array)
 id23052
 modelBrokerage
 model_id230
 tagFeaturedImage
 nameaerial-photography-architecture-building-1546168.jpg
 typeimage/jpeg
 size356213
 uri/assets/23052.jpg
 order0
 created2019-09-09 11:39:35
 modified2019-09-09 11:39:50
 1(array)
 id23055
 modelBrokerage
 model_id230
 tagFeaturedImage
 namearchitectural-design-architecture-clouds-1732414.jpg
 typeimage/jpeg
 size363725
 uri/assets/23055.jpg
 order1
 created2019-09-09 11:39:36
 modified2019-09-09 11:39:50
 2(array)
 id23050
 modelBrokerage
 model_id230
 tagFeaturedImage
 nameappartment-building-appartments-architecture-87223.jpg
 typeimage/jpeg
 size309517
 uri/assets/23050.jpg
 order2
 created2019-09-09 11:39:35
 modified2019-09-09 11:39:50
 3(array)
 id23051
 modelBrokerage
 model_id230
 tagFeaturedImage
 namearchitectural-design-architecture-blue-sky-462358.jpg
 typeimage/jpeg
 size382238
 uri/assets/23051.jpg
 order3
 created2019-09-09 11:39:35
 modified2019-09-09 11:39:50
 4(array)
 id23054
 modelBrokerage
 model_id230
 tagFeaturedImage
 nameapartment-architectural-design-architecture-1436190.jpg
 typeimage/jpeg
 size818644
 uri/assets/23054.jpg
 order4
 created2019-09-09 11:39:36
 modified2019-09-09 11:39:50
 5(array)
 id23056
 modelBrokerage
 model_id230
 tagFeaturedImage
 nameaerial-aerial-shot-architecture-1642125.jpg
 typeimage/jpeg
 size743664
 uri/assets/23056.jpg
 order5
 created2019-09-09 11:39:37
 modified2019-09-09 11:39:50
 6(array)
 id23057
 modelBrokerage
 model_id230
 tagFeaturedImage
 namearchitectural-design-architecture-blue-sky-1838640.jpg
 typeimage/jpeg
 size895148
 uri/assets/23057.jpg
 order6
 created2019-09-09 11:39:37
 modified2019-09-09 11:39:50
 7(array)
 id23058
 modelBrokerage
 model_id230
 tagFeaturedImage
 namebackyard-lights-mansion-32870.jpg
 typeimage/jpeg
 size353456
 uri/assets/23058.jpg
 order7
 created2019-09-09 11:39:38
 modified2019-09-09 11:39:50
 8(array)
 id23059
 modelBrokerage
 model_id230
 tagFeaturedImage
 namearchitecture-bird-s-eye-view-buildings-1587947.jpg
 typeimage/jpeg
 size980979
 uri/assets/23059.jpg
 order8
 created2019-09-09 11:39:38
 modified2019-09-09 11:39:50
 9(array)
 id23053
 modelBrokerage
 model_id230
 tagFeaturedImage
 nameapartment-architectural-design-architecture-323780.jpg
 typeimage/jpeg
 size332829
 uri/assets/23053.jpg
 order9
 created2019-09-09 11:39:36
 modified2019-09-09 11:39:50
 Property(empty)
 3(array)
 Brokerage(array)
 id137
 account_executive_id236
 archived(false)
 typedevelopment
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties1
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID2414583
 timezone
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameThe Marchant Company, Inc.
 broker_of_record_name
 short_nameThe Marchant Company, Inc.
 usernameMarchantCompany
 password6b21dd1cd4314d8aa44643c451d87aa74a809a21
 password_reset_hash
 monthly_invoice_amount0.00
 monthly_invoice_start_date(null)
 monthly_invoice_end_date(null)
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionThe Marchant Company, Inc. is the exclusive representative for Leverage Global Partners in the Greater Greenville Area, Taylors, Mauldin, Travelers Rest, Greer, Fountain Inn, Easley, and Simpsonville, South Carolina, USA. Makings of the Marchant Company After working in the Greenville real estate market for twenty-five years, Seabrook Marchant founded the Marchant Company in 1993 as a new home sales and subdivision development company. After two years of exclusively representing builders and new home communities, the Marchant Company entered the general real estate and property management business. Beginning with one client, two employees and an in-home office, the Marchant Company has grown to twenty-four agents with two office locations in the Upstate. Celebrating 20 Years of History Over its twenty year history, the Marchant Company has been recognized as the Small Business of the Month and nominated for Small Business of the Year in 2002 by the Greenville Chamber of Commerce. Other accomplishments include being named the exclusive marketing company for Montebello luxury subdivision in 1997, receiving a license to do business in North Carolina in 2004 and forming Marchant Property Management, LLC in 2009 to provide tenants, homeowners and investors across the Upstate a variety of property management services. In the same year, the Marchant Company founder, Seabrook Marchant, was awarded “Realtor Emeritus” status by the National Association of Realtors honoring his 40 plus years of work as a Realtor. Family Foundations Seabrook Marchant graduated from Clemson University in 1964 with a Bachelor of Science Degree. He is a Certified Real Estate Brokerage Manager (CRB), a Graduate of the REALTOR® Institute (GRI), and a Certified New Home Marketing Professional (CMP). He works alongside three of his family members at the Marchant Company and is a dedicated Greenville community volunteer. He serves as chairman of Faith Memorial Chapel, Board of Trustees in Cedar Mountain, NC, is a Meals on Wheels volunteer and a board member of Greenville Home Builders Association and Secretary of Connector 2000 Association (Southern Connector). He previously served as President of both the Greater Greenville Association of Realtors and the Greenville Multiple Listings Service. Decades of Trust. Confidence in the Future. The Marchant Company covers a broad range of real estate to meet the demands of the everchanging market: • Residential Real Estate • Commercial Real Estate • New Home Communities • Property Management (currently managing approx. 400 properties) • Foreclosed & Distressed Properties • Land & Acreage – Mountain Properties 
 communitiesGreater Greenville Area Taylors Mauldin Travelers Rest Greer Fountain Inn Easley Simpsonville
 websitehttp://www.marchantco.com/
 address100 West Stone Avenue
 address_2
 cityGreenville
 stateSC
 full_stateSouth Carolina
 countryUSA
 market
 market_2
 postal_code29609
 phone(864) 467-0085
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameSeabrook Marchant
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/leverage-lifestyle/meet-seabrook-marchant/
 contact_big_profile_link_text
 contact_titlePresident / Broker in Charge
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename137.jpg
 logo_filename137.png
 contact_image_filename137.JPG
 all_properties_link_image_filename137.jpg
 all_properties_linkhttp://www.marchantco.com/view-our-properties/residential-real-estate/
 video_embed_code
 contact_video_embed_code
 meta_titleGreenville Real Estate | The Marchant Company, Inc. | Leverage Global Partners
 meta_descriptionThe Marchant Company, Inc. is the exclusive representative for Leverage Global Partners in Greenville, South Carolina, USA.
 meta_keywordsThe Marchant Company, Inc., Greenville Real Estate, Seabrook Marchant, Greater Greenville Area Real Estate, Taylors Real Estate, Mauldin Real Estate, Travelers Rest Real Estate, Greer Real Estate, Fountain Inn Real Estate, Easley Real Estate, Simpsonville Real Estate, South Carolina, Leverage Global Partners
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2014-06-30 16:39:09
 modified2019-09-09 11:38:32
 dre_num012345
 uri/development-detail/137/the-marchant-company-inc
 website_shortwww.marchantco.com
 name_with_locationThe Marchant Company, Inc.
 FeaturedImage(array)
 0(array)
 id23044
 modelBrokerage
 model_id137
 tagFeaturedImage
 nameapartment-architectural-design-architecture-1436190.jpg
 typeimage/jpeg
 size818644
 uri/assets/23044.jpg
 order0
 created2019-09-09 11:38:18
 modified2019-09-09 11:38:32
 1(array)
 id23048
 modelBrokerage
 model_id137
 tagFeaturedImage
 namebackyard-lights-mansion-32870.jpg
 typeimage/jpeg
 size353456
 uri/assets/23048.jpg
 order1
 created2019-09-09 11:38:19
 modified2019-09-09 11:38:32
 2(array)
 id23042
 modelBrokerage
 model_id137
 tagFeaturedImage
 nameapartment-architectural-design-architecture-323780.jpg
 typeimage/jpeg
 size332829
 uri/assets/23042.jpg
 order2
 created2019-09-09 11:38:18
 modified2019-09-09 11:38:32
 3(array)
 id23043
 modelBrokerage
 model_id137
 tagFeaturedImage
 namearchitectural-design-architecture-blue-sky-462358.jpg
 typeimage/jpeg
 size382238
 uri/assets/23043.jpg
 order3
 created2019-09-09 11:38:18
 modified2019-09-09 11:38:32
 4(array)
 id23045
 modelBrokerage
 model_id137
 tagFeaturedImage
 nameaerial-aerial-shot-architecture-1642125.jpg
 typeimage/jpeg
 size743664
 uri/assets/23045.jpg
 order4
 created2019-09-09 11:38:19
 modified2019-09-09 11:38:32
 5(array)
 id23040
 modelBrokerage
 model_id137
 tagFeaturedImage
 nameaerial-photography-architecture-building-1546168.jpg
 typeimage/jpeg
 size356213
 uri/assets/23040.jpg
 order5
 created2019-09-09 11:38:17
 modified2019-09-09 11:38:32
 6(array)
 id23046
 modelBrokerage
 model_id137
 tagFeaturedImage
 namearchitectural-design-architecture-clouds-1732414.jpg
 typeimage/jpeg
 size363725
 uri/assets/23046.jpg
 order6
 created2019-09-09 11:38:19
 modified2019-09-09 11:38:32
 7(array)
 id23047
 modelBrokerage
 model_id137
 tagFeaturedImage
 namearchitecture-bird-s-eye-view-buildings-1587947.jpg
 typeimage/jpeg
 size980979
 uri/assets/23047.jpg
 order7
 created2019-09-09 11:38:19
 modified2019-09-09 11:38:32
 8(array)
 id23049
 modelBrokerage
 model_id137
 tagFeaturedImage
 namearchitectural-design-architecture-blue-sky-1838640.jpg
 typeimage/jpeg
 size895148
 uri/assets/23049.jpg
 order8
 created2019-09-09 11:38:19
 modified2019-09-09 11:38:32
 9(array)
 id23041
 modelBrokerage
 model_id137
 tagFeaturedImage
 nameappartment-building-appartments-architecture-87223.jpg
 typeimage/jpeg
 size309517
 uri/assets/23041.jpg
 order9
 created2019-09-09 11:38:17
 modified2019-09-09 11:38:32
 Property(array)
 0(array)
 id2469
 brokerage_id137
 created_by_user_id0
 order0
 multi_unit(false)
 agent_1_id11
 agent_2_id0
 agent_3_id0
 nameAUTHENTIC TUDOR HOME ON PENINSULA
 incomplete(false)
 archived(false)
 last_archived0000-00-00 00:00:00
 auto_archived_from_mlsidx(false)
 paid_featured(false)
 featured(true)
 homepage_featured(false)
 brokerage_page_featured(true)
 requested_homepage_featured_by_member(false)
 homepage_featured_by_member(false)
 dot_luxury_featured(false)
 luxury_feed_featured(true)
 force_luxury_feed_featured(false)
 luxury_autofeed_imported(false)
 luxury_feed_last_added_time0000-00-00 00:00:00
 luxury_feed_agent_user_id0
 luxury_feed_locked_to_subscription_id0
 luxury_feed_agent_purchase_date0000-00-00
 luxury_feed_agent_expiration_date0000-00-00
 digital_ad_summary_email_last_sent0000-00-00 00:00:00
 digital_ad_summary_price_changed(false)
 wsj_detail_url
 ft_detail_url
 nyt_detail_url
 juwai_detail_url
 pgl_detail_url
 mg_detail_url
 mg_c_detail_url
 mg_s_detail_url
 bp_detail_url
 mw_detail_url
 nikkei_detail_url
 wapo_detail_url
 robb_detail_url
 medium_featured(false)
 large_featured(false)
 detail_page(true)
 descriptionOnce in a lifetime offering, to own your own peninsula including 55 acres of the ultimate in privacy, 1000 feet of lake frontage and a stunning, architecturally authentic English Tudor home custom designed and built by the owners. This estate is surrounded by lushly landscaped gardens, mature trees, and open garden space. A covered boat dock, four car garage, a separate workshop, and additional outbuildings that once were home to peacocks who graced the grounds for over 20 years, complete this very special property. No question, this is an iconic property that can not be replicated on this large parcel of land located at the most convenient location on Lake Greenwood. After the long, private, and peaceful drive onto the Woodbine estate you arrive at the gated entrance to this amazing home built on the point of the peninsula. Built originally in 1974, a major renovation was completed in 2005 making the effective age of this property only 15 years. The home, although 5400+s/f, feels warm, comfortable, and elegant. The windows, replaced during the renovation, have been designed to enjoy all of the gorgeous views of the gardens and the lake. There are four bedrooms, 4 and 1/2 baths with an additional bedroom with full bath, office, separate den with fireplace for in-laws or guests on the terrace level. Throughout this home you will discover the beautiful millwork, 3 fireplaces, handcrafted front doors, hardwood floors, and architecturally stunning master bedroom wing addition, the gourmet kitchen wing addition with custom cabinetry and high-end appliances. You will enjoy the open floor plan master living area that overlooks the gardens and lake. If you are seeking a lake estate for your primary residence or a second home recreation property this is an investment opportunity not to be missed.
 address100 Woodbine Rd.
 address_2
 cityWaterloo
 stateSC
 postal_code29384
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price998000
 price_20
 price_usd998000
 price_usd_20
 statusFor Sale
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(false)
 bedrooms4
 bedrooms_20
 bathrooms4
 bathrooms_20
 no_beds_baths(false)
 square_feet5400
 square_meters
 acres54
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size54
 icon_1waterfront
 icon_2dock
 icon_3acreage
 icon_4sq-ft
 icon_5garage
 icon_6
 website
 meta_titleAUTHENTIC TUDOR HOME ON PENINSULA | Waterloo Real Estate | The Marchant Company, Inc.
 meta_description100 Woodbine Rd. is a property offered for sale in Waterloo, SC, USA, presented by The Marchant Company, Inc.
 meta_keywords
 bathrooms_partial1
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built
 virtual_tour
 video_tourhttp://www.lakegreenwoodestate.com/video-tour/
 digital_brochure
 video_tour_embed_code<iframe width="560" height="315" src="https://www.youtube.com/embed/VpVU6ulh5F8?controls=0&showinfo=0" frameborder="0" allowfullscreen></iframe>
 digital_brochure_embed_code
 mls_num1304750
 wsj_property_typesingle family
 nyt_property_type1
 nyt_popular_features
 propgolux_property_type9
 juwai_property_type
 juwai_category
 propgolux_property_style43
 wapo_property_type
 robb_property_type
 propgolux_location_id_override
 open_house_1_start0000-00-00 00:00:00
 open_house_1_end_time00:00:00
 latitude34.272156
 longitude-82.030212
 invalid_required_fields
 invalid_optional_fieldsagent_2_id, square_meters, hectares, virtual_tour, year_built
 went_live_today(false)
 converted(true)
 invalid(false)
 mlsidx_full_address
 mlsidx_date_listed0000-00-00
 mls_market
 primary_property_category_id0
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated(null)
 modified2016-04-18 05:33:02
 created2015-07-16 06:38:57
 uri/property-detail/2469/100-woodbine-rd-waterloo-sc-29384-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/2469/100-woodbine-rd-waterloo-sc-29384-usa
 address_concat100 Woodbine Rd. Waterloo SC 29384 USA
 google_maps_query_string100+Woodbine+Rd.++Waterloo+SC+29384+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 998,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty4
 bathrooms_pretty4
 bathrooms_partial_pretty1
 bathrooms_3_4_pretty0
 feed_full_bathrooms4
 date_listed2015-07-16
 overridden_brokerage_name
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 Image(array)
 0(array)
 id12749
 modelProperty
 model_id2469
 tagImage
 name23194.jpg
 typeimage/jpg
 size462462
 uri/assets/12749.jpg
 order0
 created2016-04-07 16:35:05
 modified2016-04-07 16:35:05
 1(array)
 id12750
 modelProperty
 model_id2469
 tagImage
 name23195.jpg
 typeimage/jpg
 size748813
 uri/assets/12750.jpg
 order1
 created2016-04-07 16:35:05
 modified2016-04-07 16:35:05
 2(array)
 id12754
 modelProperty
 model_id2469
 tagImage
 name23199.jpg
 typeimage/jpg
 size917478
 uri/assets/12754.jpg
 order2
 created2016-04-07 16:35:05
 modified2016-04-07 16:35:05
 3(array)
 id12751
 modelProperty
 model_id2469
 tagImage
 name23196.jpg
 typeimage/jpg
 size613348
 uri/assets/12751.jpg
 order3
 created2016-04-07 16:35:05
 modified2016-04-07 16:35:05
 4(array)
 id12752
 modelProperty
 model_id2469
 tagImage
 name23197.jpg
 typeimage/jpg
 size432965
 uri/assets/12752.jpg
 order4
 created2016-04-07 16:35:05
 modified2016-04-07 16:35:05
 5(array)
 id12755
 modelProperty
 model_id2469
 tagImage
 name23190.jpg
 typeimage/jpg
 size500753
 uri/assets/12755.jpg
 order5
 created2016-04-07 16:35:05
 modified2016-04-07 16:35:05
 6(array)
 id12753
 modelProperty
 model_id2469
 tagImage
 name23198.jpg
 typeimage/jpg
 size414681
 uri/assets/12753.jpg
 order6
 created2016-04-07 16:35:05
 modified2016-04-07 16:35:05
 7(array)
 id12756
 modelProperty
 model_id2469
 tagImage
 name23191.jpg
 typeimage/jpg
 size590983
 uri/assets/12756.jpg
 order7
 created2016-04-07 16:35:05
 modified2016-04-07 16:35:05
 8(array)
 id12757
 modelProperty
 model_id2469
 tagImage
 name23192.jpg
 typeimage/jpg
 size497137
 uri/assets/12757.jpg
 order8
 created2016-04-07 16:35:05
 modified2016-04-07 16:35:05
 9(array)
 id12758
 modelProperty
 model_id2469
 tagImage
 name23193.jpg
 typeimage/jpg
 size324285
 uri/assets/12758.jpg
 order9
 created2016-04-07 16:35:05
 modified2016-04-07 16:35:05
 1(array)
 id903
 brokerage_id137
 created_by_user_id0
 order1
 multi_unit(false)
 agent_1_id9
 agent_2_id0
 agent_3_id0
 nameAmazing Historic Home on 9.83 Acres
 incomplete(false)
 archived(false)
 last_archived0000-00-00 00:00:00
 auto_archived_from_mlsidx(false)
 paid_featured(false)
 featured(true)
 homepage_featured(false)
 brokerage_page_featured(true)
 requested_homepage_featured_by_member(false)
 homepage_featured_by_member(false)
 dot_luxury_featured(false)
 luxury_feed_featured(false)
 force_luxury_feed_featured(false)
 luxury_autofeed_imported(false)
 luxury_feed_last_added_time0000-00-00 00:00:00
 luxury_feed_agent_user_id0
 luxury_feed_locked_to_subscription_id0
 luxury_feed_agent_purchase_date0000-00-00
 luxury_feed_agent_expiration_date0000-00-00
 digital_ad_summary_email_last_sent0000-00-00 00:00:00
 digital_ad_summary_price_changed(false)
 wsj_detail_url
 ft_detail_url
 nyt_detail_url
 juwai_detail_url
 pgl_detail_url
 mg_detail_url
 mg_c_detail_url
 mg_s_detail_url
 bp_detail_url
 mw_detail_url
 nikkei_detail_url
 wapo_detail_url
 robb_detail_url
 medium_featured(false)
 large_featured(false)
 detail_page(true)
 descriptionAmazing 6700+ square foot historic home on 9.83 acres with incredible updates! This home is approximately 9 minutes from downtown main street. This large home is great for both family and entertaining, and has been remodeled with in the last 1-5 years. This home is amazing with never ending features: 4 car garage with office, work-out room, bedroom, bathroom and entertaining bonus area; additional lower level entertainment area, bar and wine room, all floored in tile or wood with stone wall adornments, with French doors opening out to the large rock garden with fish pond and waterfall; 122 foot long deck with beautiful stone fireplace and fire pit; custom pool and cabana with grilling station, full bath and entertainment area. This must see unique home includes updates from new lighting, to plumbing fixtures, refinished hardwoods, tile flooring, new carpet, new paint, updated kitchen and baths to the new 4 car garage and it doesn't feel a day over 20! You must see to believe!
 address538 Crestwood Drive
 address_2
 cityGreenville
 stateSC
 postal_code29609
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price899900
 price_20
 price_usd899900
 price_usd_20
 statusFor Sale
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(false)
 bedrooms5
 bedrooms_20
 bathrooms4
 bathrooms_20
 no_beds_baths(false)
 square_feet6600
 square_meters
 acres9
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size9
 icon_1sq-ft
 icon_2gym
 icon_3pool
 icon_4acreage
 icon_5
 icon_6
 website
 meta_titleAmazing Historic Home on 9.83 Acres | Greenville Real Estate | The Marchant Company, Inc.
 meta_description538 Crestwood Drive is a property offered for sale in Greenville, SC, USA, presented by The Marchant Company, Inc.
 meta_keywords538 Crestwood Drive, Amazing Historic Home with Countless Features, Leverage Global Partners, Greenville Real Estate, South Carolina Real Estate, The Marchant Company, Inc.
 bathrooms_partial3
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built
 virtual_tourhttp://clients.stephenvitosky.com/538CrestwoodDrive.wmv
 video_tour
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num
 wsj_property_type
 nyt_property_type
 nyt_popular_features
 propgolux_property_type
 juwai_property_type
 juwai_category
 propgolux_property_style
 wapo_property_type
 robb_property_type
 propgolux_location_id_override
 open_house_1_start0000-00-00 00:00:00
 open_house_1_end_time00:00:00
 latitude0.000000
 longitude0.000000
 invalid_required_fieldslatitude, longitude
 invalid_optional_fieldsagent_2_id, bathrooms_partial, square_meters, hectares, video_tour, year_built, wsj_property_type, nyt_property_type, propgolux_property_type, propgolux_property_style
 went_live_today(false)
 converted(true)
 invalid(false)
 mlsidx_full_address
 mlsidx_date_listed0000-00-00
 mls_market
 primary_property_category_id0
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated(null)
 modified2016-04-18 05:33:02
 created2014-07-18 09:52:33
 uri/property-detail/903/538-crestwood-drive-greenville-sc-29609-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/903/538-crestwood-drive-greenville-sc-29609-usa
 address_concat538 Crestwood Drive Greenville SC 29609 USA
 google_maps_query_string538+Crestwood+Drive++Greenville+SC+29609+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 899,900
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty5
 bathrooms_pretty4
 bathrooms_partial_pretty3
 bathrooms_3_4_pretty0
 feed_full_bathrooms4
 date_listed2014-07-18
 overridden_brokerage_name
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 Image(array)
 0(array)
 id10410
 modelProperty
 model_id903
 tagImage
 name7630.jpg
 typeimage/jpg
 size2054580
 uri/assets/10410.jpg
 order0
 created2016-04-07 16:21:04
 modified2016-04-07 16:21:04
 1(array)
 id10412
 modelProperty
 model_id903
 tagImage
 name7631.jpg
 typeimage/jpg
 size1417174
 uri/assets/10412.jpg
 order1
 created2016-04-07 16:21:04
 modified2016-04-07 16:21:04
 2(array)
 id10403
 modelProperty
 model_id903
 tagImage
 name7628.jpg
 typeimage/jpg
 size1612270
 uri/assets/10403.jpg
 order2
 created2016-04-07 16:21:03
 modified2016-04-07 16:21:04
 3(array)
 id10411
 modelProperty
 model_id903
 tagImage
 name7629.jpg
 typeimage/jpg
 size1520391
 uri/assets/10411.jpg
 order3
 created2016-04-07 16:21:04
 modified2016-04-07 16:21:04
 4(array)
 id10404
 modelProperty
 model_id903
 tagImage
 name7627.jpg
 typeimage/jpg
 size1845349
 uri/assets/10404.jpg
 order4
 created2016-04-07 16:21:04
 modified2016-04-07 16:21:04
 5(array)
 id10409
 modelProperty
 model_id903
 tagImage
 name7626.jpg
 typeimage/jpg
 size1489578
 uri/assets/10409.jpg
 order5
 created2016-04-07 16:21:04
 modified2016-04-07 16:21:04
 6(array)
 id10406
 modelProperty
 model_id903
 tagImage
 name7625.jpg
 typeimage/jpg
 size574567
 uri/assets/10406.jpg
 order6
 created2016-04-07 16:21:04
 modified2016-04-07 16:21:04
 7(array)
 id10408
 modelProperty
 model_id903
 tagImage
 name7624.jpg
 typeimage/jpg
 size614703
 uri/assets/10408.jpg
 order7
 created2016-04-07 16:21:04
 modified2016-04-07 16:21:04
 8(array)
 id10407
 modelProperty
 model_id903
 tagImage
 name7623.jpg
 typeimage/jpg
 size2050361
 uri/assets/10407.jpg
 order8
 created2016-04-07 16:21:04
 modified2016-04-07 16:21:04
 9(array)
 id10405
 modelProperty
 model_id903
 tagImage
 name7621.jpg
 typeimage/jpg
 size817186
 uri/assets/10405.jpg
 order9
 created2016-04-07 16:21:04
 modified2016-04-07 16:21:04
- featured_developments(array)
 0(array)
 Brokerage(array)
 id191
 account_executive_id236
 archived(false)
 typedevelopment
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(true)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID2487796
 timezone
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameNIX Realty Company
 broker_of_record_name
 short_nameNIX Realty Company
 usernameNIXRealtyCompany
 password8cdefc75e1cc80987ef5f25f14119ae502ff4e35
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date(null)
 monthly_invoice_end_date(null)
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionNIX Realty Company is the exclusive representative for Leverage Global Partners in San Antonio, TX, including Bexar County, Texas Hill County, Alamo Heights, Terrel Hills, Olmos Park, Boerne, TX, USA. Nix Realty Company, a residential real estate brokerage firm, was founded in 2007 by Kate Coiner Park and Marnie Tate Simpson. They saw a need for a boutique company that could specialize its services to each client’s specific needs. Their main focus is to provide excellent customer service and up to date knowledge and advice. Kate and Marnie’s families have been in San Antonio a long time, with roots reaching back to the Alamo itself, and some of downtown’s landmarks, including the Nix Hospital and the current Emily Morgan Hotel, both built by J.M. and Birdie Nix, Kate’s ancestors, and real estate developers. Nix Realty Company is named after them. Nix Realty Company has a “family” atmosphere, with about twenty agents at the firm. Agents range from over thirty years in the business, to just a few years, but all have the common goal of teamwork, professionalism, and providing their clients with exceptional service. Every year since 2010, Nix has been ranked in the top four firms in the San Antonio Business Journal for its average sales price. Thank you for your interest in Nix Realty Company, and please let us know how we can assist you.
 communitiesBexar County Texas Hill County Alamo Heights Terrel Hills Olmos Park Boerne
 websitehttp://nixrealtycompany.com/
 address120 West Olmos Drive
 address_2
 citySan Antonio
 stateTX
 full_stateTexas
 countryUSA
 market
 market_2
 postal_code78212
 phone Cell: 210-364-4703
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameKate Park
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleCo-Owner/Broker
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename191.jpg
 logo_filename191.jpg
 contact_image_filename191.jpg
 all_properties_link_image_filename191.jpg
 all_properties_linkhttp://nixrealtycompany.com/category/listings/
 video_embed_code
 contact_video_embed_code
 meta_titleSan Antonio, TX⎜NIX Realty Company⎜Leverage Global Partners
 meta_descriptionNIX Realty Company is the exclusive representative for Leverage Global Partners in San Antonio, TX, including Bexar County, Texas Hill County, Alamo Heights, Terrel Hills, Olmos Park, Boerne, TX, USA.
 meta_keywordsNIX Realty Company, Leverage Global Partners, San Antonio Real Estate, Texas Real Estate, Bexar County, Texas Hill County, Alamo Heights, Terrel Hills, Olmos Park, Boerne, Texas
 login_message_counter2
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2015-02-12 10:28:46
 modified2019-09-09 11:33:38
 dre_num012345
 uri/development-detail/191/nix-realty-company
 website_shortnixrealtycompany.com
 name_with_locationNIX Realty Company
 FeaturedImage(array)
 0(array)
 id23010
 modelBrokerage
 model_id191
 tagFeaturedImage
 nameapartment-architectural-design-architecture-323780.jpg
 typeimage/jpeg
 size332829
 uri/assets/23010.jpg
 order0
 created2019-09-09 11:30:04
 modified2019-09-09 11:33:38
 1(array)
 id23011
 modelBrokerage
 model_id191
 tagFeaturedImage
 namearchitectural-design-architecture-blue-sky-462358.jpg
 typeimage/jpeg
 size382238
 uri/assets/23011.jpg
 order1
 created2019-09-09 11:30:05
 modified2019-09-09 11:33:38
 2(array)
 id23012
 modelBrokerage
 model_id191
 tagFeaturedImage
 nameaerial-photography-architecture-building-1546168.jpg
 typeimage/jpeg
 size356213
 uri/assets/23012.jpg
 order2
 created2019-09-09 11:30:05
 modified2019-09-09 11:33:38
 3(array)
 id23013
 modelBrokerage
 model_id191
 tagFeaturedImage
 nameaerial-aerial-shot-architecture-1642125.jpg
 typeimage/jpeg
 size743664
 uri/assets/23013.jpg
 order3
 created2019-09-09 11:30:05
 modified2019-09-09 11:33:38
 4(array)
 id23014
 modelBrokerage
 model_id191
 tagFeaturedImage
 nameappartment-building-appartments-architecture-87223.jpg
 typeimage/jpeg
 size309517
 uri/assets/23014.jpg
 order4
 created2019-09-09 11:30:05
 modified2019-09-09 11:33:38
 5(array)
 id23015
 modelBrokerage
 model_id191
 tagFeaturedImage
 namearchitectural-design-architecture-blue-sky-1838640.jpg
 typeimage/jpeg
 size895148
 uri/assets/23015.jpg
 order5
 created2019-09-09 11:30:05
 modified2019-09-09 11:33:38
 6(array)
 id23016
 modelBrokerage
 model_id191
 tagFeaturedImage
 namearchitecture-bird-s-eye-view-buildings-1587947.jpg
 typeimage/jpeg
 size980979
 uri/assets/23016.jpg
 order6
 created2019-09-09 11:30:06
 modified2019-09-09 11:33:38
 7(array)
 id23017
 modelBrokerage
 model_id191
 tagFeaturedImage
 namebackyard-lights-mansion-32870.jpg
 typeimage/jpeg
 size353456
 uri/assets/23017.jpg
 order7
 created2019-09-09 11:30:06
 modified2019-09-09 11:33:38
 8(array)
 id23018
 modelBrokerage
 model_id191
 tagFeaturedImage
 namearchitectural-design-architecture-clouds-1732414.jpg
 typeimage/jpeg
 size363725
 uri/assets/23018.jpg
 order8
 created2019-09-09 11:30:06
 modified2019-09-09 11:33:38
 9(array)
 id23019
 modelBrokerage
 model_id191
 tagFeaturedImage
 nameapartment-architectural-design-architecture-1436190.jpg
 typeimage/jpeg
 size818644
 uri/assets/23019.jpg
 order9
 created2019-09-09 11:30:06
 modified2019-09-09 11:33:38
 Property(array)
 0(array)
 id3685
 brokerage_id191
 created_by_user_id0
 order0
 multi_unit(false)
 agent_1_id30
 agent_2_id0
 agent_3_id0
 name121 West Brandon Drive, Bel Meade
 incomplete(false)
 archived(false)
 last_archived0000-00-00 00:00:00
 auto_archived_from_mlsidx(false)
 paid_featured(false)
 featured(true)
 homepage_featured(false)
 brokerage_page_featured(true)
 requested_homepage_featured_by_member(false)
 homepage_featured_by_member(false)
 dot_luxury_featured(false)
 luxury_feed_featured(false)
 force_luxury_feed_featured(false)
 luxury_autofeed_imported(false)
 luxury_feed_last_added_time0000-00-00 00:00:00
 luxury_feed_agent_user_id0
 luxury_feed_locked_to_subscription_id0
 luxury_feed_agent_purchase_date0000-00-00
 luxury_feed_agent_expiration_date0000-00-00
 digital_ad_summary_email_last_sent0000-00-00 00:00:00
 digital_ad_summary_price_changed(false)
 wsj_detail_url
 ft_detail_url
 nyt_detail_url
 juwai_detail_url
 pgl_detail_url
 mg_detail_url
 mg_c_detail_url
 mg_s_detail_url
 bp_detail_url
 mw_detail_url
 nikkei_detail_url
 wapo_detail_url
 robb_detail_url
 medium_featured(false)
 large_featured(false)
 detail_page(true)
 descriptionThis incredible estate property is located in desirable Bel Meade subdivision. Rarely offered, it is one of 6 estate lot properties in Bel Meade, and has been completely remodeled. In addition to the main house, this 1.3 acre lot has a pool, updated guest room/full bath off the garage, and a 1300+/- s/ft pool house with bedroom, two baths, kitchen, and large entertaining area with fireplace, and covered patio. Plenty of yard, tree house, sport court. Private, and surrounded by incredible homes, this is a wonderful opportunity to own a well located, gorgeous home on a large lot, in a quiet area. A truly stunning renovation that captures the home's classic features, but redone for modern living. 
 address121 West Brandon Drive
 address_2
 citySan Antonio
 stateTx
 postal_code78209
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price1545000
 price_20
 price_usd1545000
 price_usd_20
 statusFor Sale
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(false)
 bedrooms4
 bedrooms_20
 bathrooms3
 bathrooms_20
 no_beds_baths(false)
 square_feet0
 square_meters
 acres1
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size1
 icon_1acreage
 icon_2garage
 icon_3guest-house
 icon_4pool
 icon_5
 icon_6
 websitehttp://nixrealtycompany.com/listing/121-west-brandon-drive-bel-meade/
 meta_title121 West Brandon Drive, Bel Meade | San Antonio Real Estate | NIX Realty Company
 meta_description121 West Brandon Drive is a property offered for sale in San Antonio, Tx, USA, presented by NIX Realty Company
 meta_keywords
 bathrooms_partial1
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built
 virtual_tour
 video_tour
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num
 wsj_property_type
 nyt_property_type
 nyt_popular_features
 propgolux_property_type
 juwai_property_type
 juwai_category
 propgolux_property_style
 wapo_property_type
 robb_property_type
 propgolux_location_id_override
 open_house_1_start0000-00-00 00:00:00
 open_house_1_end_time00:00:00
 latitude0.000000
 longitude0.000000
 invalid_required_fields
 invalid_optional_fieldsagent_2_id, square_feet, square_meters, hectares, virtual_tour, video_tour
 went_live_today(false)
 converted(true)
 invalid(false)
 mlsidx_full_address
 mlsidx_date_listed0000-00-00
 mls_market
 primary_property_category_id0
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated(null)
 modified2016-04-18 05:33:02
 created2016-04-02 05:34:03
 uri/property-detail/3685/121-west-brandon-drive-san-antonio-tx-78209-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3685/121-west-brandon-drive-san-antonio-tx-78209-usa
 address_concat121 West Brandon Drive San Antonio Tx 78209 USA
 google_maps_query_string121+West+Brandon+Drive++San+Antonio+Tx+78209+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 1,545,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty4
 bathrooms_pretty3
 bathrooms_partial_pretty1
 bathrooms_3_4_pretty0
 feed_full_bathrooms3
 date_listed2016-04-02
 overridden_brokerage_name
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 Image(array)
 0(array)
 id11687
 modelProperty
 model_id3685
 tagImage
 name35847.jpg
 typeimage/jpg
 size955978
 uri/assets/11687.jpg
 order0
 created2016-04-07 16:28:27
 modified2016-04-07 16:28:27
 1(array)
 id11693
 modelProperty
 model_id3685
 tagImage
 name35841.jpg
 typeimage/jpg
 size398453
 uri/assets/11693.jpg
 order1
 created2016-04-07 16:28:27
 modified2016-04-07 16:28:27
 2(array)
 id11692
 modelProperty
 model_id3685
 tagImage
 name35842.jpg
 typeimage/jpg
 size349624
 uri/assets/11692.jpg
 order2
 created2016-04-07 16:28:27
 modified2016-04-07 16:28:27
 3(array)
 id11691
 modelProperty
 model_id3685
 tagImage
 name35843.jpg
 typeimage/jpg
 size480234
 uri/assets/11691.jpg
 order3
 created2016-04-07 16:28:27
 modified2016-04-07 16:28:27
 4(array)
 id11690
 modelProperty
 model_id3685
 tagImage
 name35844.jpg
 typeimage/jpg
 size326164
 uri/assets/11690.jpg
 order4
 created2016-04-07 16:28:27
 modified2016-04-07 16:28:27
 5(array)
 id11689
 modelProperty
 model_id3685
 tagImage
 name35845.jpg
 typeimage/jpg
 size262493
 uri/assets/11689.jpg
 order5
 created2016-04-07 16:28:27
 modified2016-04-07 16:28:27
 6(array)
 id11686
 modelProperty
 model_id3685
 tagImage
 name35848.jpg
 typeimage/jpg
 size684952
 uri/assets/11686.jpg
 order7
 created2016-04-07 16:28:27
 modified2016-04-07 16:28:27
 7(array)
 id11688
 modelProperty
 model_id3685
 tagImage
 name35849.jpg
 typeimage/jpg
 size382749
 uri/assets/11688.jpg
 order7
 created2016-04-07 16:28:27
 modified2016-04-07 16:28:27
 1(array)
 id2743
 brokerage_id191
 created_by_user_id0
 order6
 multi_unit(false)
 agent_1_id885
 agent_2_id0
 agent_3_id0
 name114 Brittany Olmos Park
 incomplete(false)
 archived(false)
 last_archived0000-00-00 00:00:00
 auto_archived_from_mlsidx(false)
 paid_featured(false)
 featured(true)
 homepage_featured(true)
 brokerage_page_featured(true)
 requested_homepage_featured_by_member(false)
 homepage_featured_by_member(false)
 dot_luxury_featured(false)
 luxury_feed_featured(false)
 force_luxury_feed_featured(false)
 luxury_autofeed_imported(false)
 luxury_feed_last_added_time0000-00-00 00:00:00
 luxury_feed_agent_user_id0
 luxury_feed_locked_to_subscription_id0
 luxury_feed_agent_purchase_date0000-00-00
 luxury_feed_agent_expiration_date0000-00-00
 digital_ad_summary_email_last_sent0000-00-00 00:00:00
 digital_ad_summary_price_changed(false)
 wsj_detail_url
 ft_detail_url
 nyt_detail_url
 juwai_detail_url
 pgl_detail_url
 mg_detail_url
 mg_c_detail_url
 mg_s_detail_url
 bp_detail_url
 mw_detail_url
 nikkei_detail_url
 wapo_detail_url
 robb_detail_url
 medium_featured(false)
 large_featured(false)
 detail_page(true)
 descriptionThis classic Olmos Park home has beautiful space and light. This Thorman property has 4 large bedrooms with many original features and sits on a charming street. The home has two living areas, two dining areas, and a 5th bedroom option upstairs that could also be a sitting area, or converted to a large closet. Do not miss the additional quarters with bath attached to the garage.
 address114 Brittany
 address_2
 citySan Antonio
 stateTX
 postal_code78212
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price825000
 price_20
 price_usd825000
 price_usd_20
 statusFor Sale
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(true)
 bedrooms4
 bedrooms_20
 bathrooms2
 bathrooms_20
 no_beds_baths(false)
 square_feet3701
 square_meters
 acres26
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size26
 icon_1acreage
 icon_2garage
 icon_3sq-ft
 icon_4
 icon_5
 icon_6
 websitehttp://nixrealtycompany.com/listing/114-brittany-olmos-park/
 meta_title114 Brittany Olmos Park | San Antonio Real Estate | NIX Realty Company
 meta_description114 Brittany is a property offered for sale in San Antonio, TX, USA, presented by NIX Realty Company
 meta_keywords
 bathrooms_partial1
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built
 virtual_tour
 video_tour
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num
 wsj_property_type
 nyt_property_type
 nyt_popular_features
 propgolux_property_type
 juwai_property_type
 juwai_category
 propgolux_property_style
 wapo_property_type
 robb_property_type
 propgolux_location_id_override
 open_house_1_start0000-00-00 00:00:00
 open_house_1_end_time00:00:00
 latitude0.000000
 longitude0.000000
 invalid_required_fields
 invalid_optional_fieldsagent_2_id, square_meters, hectares, virtual_tour, video_tour
 went_live_today(false)
 converted(true)
 invalid(false)
 mlsidx_full_address
 mlsidx_date_listed0000-00-00
 mls_market
 primary_property_category_id0
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated(null)
 modified2016-04-18 05:33:02
 created2015-09-08 18:47:52
 uri/property-detail/2743/114-brittany-san-antonio-tx-78212-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/2743/114-brittany-san-antonio-tx-78212-usa
 address_concat114 Brittany San Antonio TX 78212 USA
 google_maps_query_string114+Brittany++San+Antonio+TX+78212+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 825,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty4
 bathrooms_pretty2
 bathrooms_partial_pretty1
 bathrooms_3_4_pretty0
 feed_full_bathrooms2
 date_listed2015-09-08
 overridden_brokerage_name
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 Image(array)
 0(array)
 id15609
 modelProperty
 model_id2743
 tagImage
 name26015.jpg
 typeimage/jpg
 size769001
 uri/assets/15609.jpg
 order0
 created2016-04-07 16:53:08
 modified2016-04-07 16:53:08
 1(array)
 id15610
 modelProperty
 model_id2743
 tagImage
 name26016.jpg
 typeimage/jpg
 size293481
 uri/assets/15610.jpg
 order1
 created2016-04-07 16:53:08
 modified2016-04-07 16:53:08
 2(array)
 id15611
 modelProperty
 model_id2743
 tagImage
 name26017.jpg
 typeimage/jpg
 size278959
 uri/assets/15611.jpg
 order2
 created2016-04-07 16:53:08
 modified2016-04-07 16:53:08
 3(array)
 id15612
 modelProperty
 model_id2743
 tagImage
 name26018.jpg
 typeimage/jpg
 size470632
 uri/assets/15612.jpg
 order3
 created2016-04-07 16:53:08
 modified2016-04-07 16:53:08
 4(array)
 id15613
 modelProperty
 model_id2743
 tagImage
 name26019.jpg
 typeimage/jpg
 size370942
 uri/assets/15613.jpg
 order4
 created2016-04-07 16:53:08
 modified2016-04-07 16:53:08
 5(array)
 id15614
 modelProperty
 model_id2743
 tagImage
 name26020.jpg
 typeimage/jpg
 size308901
 uri/assets/15614.jpg
 order5
 created2016-04-07 16:53:08
 modified2016-04-07 16:53:08
 6(array)
 id15616
 modelProperty
 model_id2743
 tagImage
 name26022.jpg
 typeimage/jpg
 size329942
 uri/assets/15616.jpg
 order6
 created2016-04-07 16:53:08
 modified2016-04-07 16:53:08
 7(array)
 id15615
 modelProperty
 model_id2743
 tagImage
 name26021.jpg
 typeimage/jpg
 size343097
 uri/assets/15615.jpg
 order7
 created2016-04-07 16:53:08
 modified2016-04-07 16:53:08
 1(array)
 Brokerage(array)
 id147
 account_executive_id236
 archived(false)
 typedevelopment
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(true)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties4
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID2511861
 timezone
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameAlex MacWilliam Inc.
 broker_of_record_name
 short_nameAlex MacWilliam Inc.
 usernameAlexMacWilliamInc
 password7e31636eaac82d1fe8959758b47b74f6a28aab9c
 password_reset_hash
 monthly_invoice_amount0.00
 monthly_invoice_start_date(null)
 monthly_invoice_end_date(null)
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionAlex MacWilliam Inc. is the exclusive representative for Leverage Global Partners in Vero Beach, FL, USA. Alex MacWilliam Real Estate has long been the company buyers and sellers have turned to for Vero Beach, FL real estate. The MacWilliam family has a deep-rooted history in Vero Beach, beginning in the 1920s when Alex MacWilliam Sr. moved to oversee the construction of what is now Riomar and later served as mayor for a 20-year tenure. Alex MacWilliam Real Estate opened for business in 1949 by Alex MacWilliam, Jr. as one of only four realty firms in all of Indian River County. This long history gives the company a unique perspective and expertise on the local real estate market. They are proud to have been recognized as one of the top real estate companies in Vero Beach and Indian River County, Florida. At Alex MacWilliam Real Estate, the mission has always been to provide only the finest service with a philosophy based on integrity and respect for their clients. Alex MacWilliam Real Estate has been able to maintain their small, family business feel while consistently expanding and keeping up with new technology and trends. Now under the leadership of Alex “Buzz” MacWilliam III and brother-in-law Joe Beasock, Alex MacWilliam Real Estate has grown to over 70 agents and has recently opened a branch office to better serve the Grand Harbor and Oak Harbor communities. Although, Alex MacWilliam Real Estate is known for specializing in the sale of single family homes and condominiums, the experienced real estate agents sell in all facets of the marketplace. Whether it is lifestyle communities, oceanfront, riverfront or golf course properties, affordable homes or foreclosures and short sales, the professionals at Alex MacWilliam Real Estate can do it all, while upholding Alex MacWilliam Real Estate’s reputation of integrity, service, professionalism and results.
 communitiesVero Beach
 websitehttp://alexmacwilliam.com/
 address2901 Ocean Drive
 address_2
 cityVero Beach
 stateFL
 full_stateFlorida
 countryUSA
 market
 market_2
 postal_code32963
 phone(772) 231-6509
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameBuzz MacWilliam
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/leverage-lifestyle/meet-buzz-macwilliam/
 contact_big_profile_link_text
 contact_titleCo-Founder
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename147.jpg
 logo_filename147.jpg
 contact_image_filename147.jpg
 all_properties_link_image_filename147.jpg
 all_properties_link
 video_embed_code
 contact_video_embed_code
 meta_titleVero Beach Real Estate | Alex MacWilliam Inc. | Leverage Global Partners
 meta_descriptionAlex MacWilliam Inc. is the exclusive representative for Leverage Global Partners in Vero Beach, FL, USA.
 meta_keywordsAlex MacWilliam Inc., Vero Beach real estate, Alex MacWilliam, Buzz MacWilliam, Florida Real Estate, Leverage Global Partners
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2014-07-28 09:04:02
 modified2021-07-18 10:42:36
 dre_num012345
 uri/development-detail/147/alex-macwilliam-inc
 website_shortalexmacwilliam.com
 name_with_locationAlex MacWilliam Inc.
 FeaturedImage(array)
 0(array)
 id23004
 modelBrokerage
 model_id147
 tagFeaturedImage
 nameP1020018.jpg
 typeimage/jpeg
 size1225515
 uri/assets/23004.jpg
 order0
 created2019-08-29 09:50:19
 modified2021-07-18 10:42:36
 1(array)
 id23005
 modelBrokerage
 model_id147
 tagFeaturedImage
 nameP1010976.jpg
 typeimage/jpeg
 size2106472
 uri/assets/23005.jpg
 order1
 created2019-08-29 09:50:33
 modified2021-07-18 10:42:36
 2(array)
 id23006
 modelBrokerage
 model_id147
 tagFeaturedImage
 nameIMG_2216.JPG
 typeimage/jpeg
 size1623860
 uri/assets/23006.JPG
 order2
 created2019-08-29 09:51:52
 modified2021-07-18 10:42:36
 Property(array)
 0(array)
 id972
 brokerage_id147
 created_by_user_id0
 order6
 multi_unit(false)
 agent_1_id388
 agent_2_id509
 agent_3_id0
 nameFabulous Oceanfront Condo
 incomplete(false)
 archived(false)
 last_archived0000-00-00 00:00:00
 auto_archived_from_mlsidx(false)
 paid_featured(false)
 featured(true)
 homepage_featured(false)
 brokerage_page_featured(true)
 requested_homepage_featured_by_member(false)
 homepage_featured_by_member(false)
 dot_luxury_featured(false)
 luxury_feed_featured(true)
 force_luxury_feed_featured(false)
 luxury_autofeed_imported(false)
 luxury_feed_last_added_time0000-00-00 00:00:00
 luxury_feed_agent_user_id0
 luxury_feed_locked_to_subscription_id0
 luxury_feed_agent_purchase_date0000-00-00
 luxury_feed_agent_expiration_date0000-00-00
 digital_ad_summary_email_last_sent0000-00-00 00:00:00
 digital_ad_summary_price_changed(false)
 wsj_detail_url
 ft_detail_url
 nyt_detail_url
 juwai_detail_url
 pgl_detail_url
 mg_detail_url
 mg_c_detail_url
 mg_s_detail_url
 bp_detail_url
 mw_detail_url
 nikkei_detail_url
 wapo_detail_url
 robb_detail_url
 medium_featured(false)
 large_featured(false)
 detail_page(true)
 descriptionOceanfront Colonial, West Indies style condo. Furnished 4BR/4.5BA with over 4,300 Sq. feet. Features include spacious living room with fireplace, chef's kitchen with gas cooktop, double oven, ice maker, sub zero refrigerator/freezer with breakfast area overlooking the ocean. Manager on site, 24 hour guard gated security, clubhouse with entertaining room, fitness center, 3 guest suites, heated pool and tennis court.
 address300 Beachview Drive
 address_2
 cityVero Beach
 stateFL
 postal_code32963
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price2500000
 price_20
 price_usd2500000
 price_usd_20
 statusFor Sale
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(false)
 bedrooms4
 bedrooms_20
 bathrooms4
 bathrooms_20
 no_beds_baths(false)
 square_feet4300
 square_meters
 acres0
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size0
 icon_1waterfront
 icon_2views
 icon_3sq-ft
 icon_4pool
 icon_5tennis
 icon_6
 website
 meta_titleFabulous Oceanfront Condo | Vero Beach Real Estate | Alex MacWilliam Inc.
 meta_description300 Beachview Drive is a property offered for sale in Vero Beach, FL, USA, presented by Alex MacWilliam Inc.
 meta_keywords300 Beachview Drive, Fabulous Oceanfront Condo, Leverage Global Partners, Vero Beach Real Estate, Florida Real Estate, Alex MacWilliam Inc.
 bathrooms_partial1
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built2001
 virtual_tour
 video_tour
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num143351
 wsj_property_typecondominium
 nyt_property_type5
 nyt_popular_features
 propgolux_property_type2
 juwai_property_type
 juwai_category
 propgolux_property_style16
 wapo_property_type
 robb_property_type
 propgolux_location_id_override
 open_house_1_start0000-00-00 00:00:00
 open_house_1_end_time00:00:00
 latitude27.735558
 longitude-80.382462
 invalid_required_fields
 invalid_optional_fieldssquare_meters, acres, hectares, virtual_tour, video_tour
 went_live_today(false)
 converted(true)
 invalid(false)
 mlsidx_full_address
 mlsidx_date_listed0000-00-00
 mls_market
 primary_property_category_id0
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated(null)
 modified2016-04-18 05:33:02
 created2014-08-07 09:46:21
 uri/property-detail/972/300-beachview-drive-vero-beach-fl-32963-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/972/300-beachview-drive-vero-beach-fl-32963-usa
 address_concat300 Beachview Drive Vero Beach FL 32963 USA
 google_maps_query_string300+Beachview+Drive++Vero+Beach+FL+32963+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 2,500,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty4
 bathrooms_pretty4
 bathrooms_partial_pretty1
 bathrooms_3_4_pretty0
 feed_full_bathrooms4
 date_listed2014-08-07
 overridden_brokerage_name
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 Image(array)
 0(array)
 id10849
 modelProperty
 model_id972
 tagImage
 name8253.jpg
 typeimage/jpg
 size425646
 uri/assets/10849.jpg
 order0
 created2016-04-07 16:23:07
 modified2016-04-07 16:23:07
 1(array)
 id10850
 modelProperty
 model_id972
 tagImage
 name8254.jpg
 typeimage/jpg
 size408538
 uri/assets/10850.jpg
 order1
 created2016-04-07 16:23:07
 modified2016-04-07 16:23:07
 2(array)
 id10851
 modelProperty
 model_id972
 tagImage
 name8255.jpg
 typeimage/jpg
 size434642
 uri/assets/10851.jpg
 order2
 created2016-04-07 16:23:07
 modified2016-04-07 16:23:07
 3(array)
 id10852
 modelProperty
 model_id972
 tagImage
 name18271.jpg
 typeimage/jpg
 size470990
 uri/assets/10852.jpg
 order3
 created2016-04-07 16:23:07
 modified2016-04-07 16:23:07
 4(array)
 id10857
 modelProperty
 model_id972
 tagImage
 name18268.jpg
 typeimage/jpg
 size360320
 uri/assets/10857.jpg
 order4
 created2016-04-07 16:23:07
 modified2016-04-07 16:23:07
 5(array)
 id10855
 modelProperty
 model_id972
 tagImage
 name18266.jpg
 typeimage/jpg
 size437666
 uri/assets/10855.jpg
 order5
 created2016-04-07 16:23:07
 modified2016-04-07 16:23:07
 6(array)
 id10854
 modelProperty
 model_id972
 tagImage
 name18267.jpg
 typeimage/jpg
 size551222
 uri/assets/10854.jpg
 order6
 created2016-04-07 16:23:07
 modified2016-04-07 16:23:07
 7(array)
 id10853
 modelProperty
 model_id972
 tagImage
 name18269.jpg
 typeimage/jpg
 size643860
 uri/assets/10853.jpg
 order7
 created2016-04-07 16:23:07
 modified2016-04-07 16:23:07
 8(array)
 id10858
 modelProperty
 model_id972
 tagImage
 name8261.jpg
 typeimage/jpg
 size650369
 uri/assets/10858.jpg
 order8
 created2016-04-07 16:23:07
 modified2016-04-07 16:23:07
 9(array)
 id10856
 modelProperty
 model_id972
 tagImage
 name18270.jpg
 typeimage/jpg
 size938891
 uri/assets/10856.jpg
 order9
 created2016-04-07 16:23:07
 modified2016-04-07 16:23:07
 1(array)
 id2696
 brokerage_id147
 created_by_user_id0
 order4
 multi_unit(false)
 agent_1_id859
 agent_2_id0
 agent_3_id0
 nameTROPICAL PARADISE
 incomplete(false)
 archived(false)
 last_archived0000-00-00 00:00:00
 auto_archived_from_mlsidx(false)
 paid_featured(false)
 featured(true)
 homepage_featured(true)
 brokerage_page_featured(true)
 requested_homepage_featured_by_member(false)
 homepage_featured_by_member(false)
 dot_luxury_featured(false)
 luxury_feed_featured(false)
 force_luxury_feed_featured(false)
 luxury_autofeed_imported(false)
 luxury_feed_last_added_time0000-00-00 00:00:00
 luxury_feed_agent_user_id0
 luxury_feed_locked_to_subscription_id0
 luxury_feed_agent_purchase_date0000-00-00
 luxury_feed_agent_expiration_date0000-00-00
 digital_ad_summary_email_last_sent0000-00-00 00:00:00
 digital_ad_summary_price_changed(false)
 wsj_detail_url
 ft_detail_url
 nyt_detail_url
 juwai_detail_url
 pgl_detail_url
 mg_detail_url
 mg_c_detail_url
 mg_s_detail_url
 bp_detail_url
 mw_detail_url
 nikkei_detail_url
 wapo_detail_url
 robb_detail_url
 medium_featured(false)
 large_featured(false)
 detail_page(true)
 descriptionSleek sophistication is the principal motif throughout this 3,150 SF Ocean Ridge residence with incredible ocean views from nearly every room. From the moment you enter you are awash in light and tropical views from two banks of sliding glass doors and a wall of clerestory windows flanking the centerpiece floor-to-ceiling Coralstone fireplace. Dining options are many from formal to casual to alfresco and all options are adjacent to the chefs kitchen with quartz counters. The first of three ensuite master bedrooms, each with their own balconies, is downstairs and features a seaglass bath with double bowl floating sinks, a mosiac tile shower floor, and a garden Jaccuzzi tub. Masters number two and three, upstairs, provide family or guests luscious retreats with dazzling views of the Atlantic Ocean. For convenience, each floor has its own laundry. Beautifully updated bamboo floors, crown moulding, tray and vaulted ceilings, custom built-ins, and a loft overlook are but a few of the interior architectural details. Tropical flora surrounds the home and the 42-foot free form pool offers easy gated entry to the Ocean Ridge deeded beach access with tiki hut, and cool azure seas and breezes. 
 address1960 Ocean Ridge Circle
 address_2
 cityVero Beach
 stateFL
 postal_code32963
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price1625000
 price_20
 price_usd1625000
 price_usd_20
 statusFor Sale
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(false)
 bedrooms3
 bedrooms_20
 bathrooms3
 bathrooms_20
 no_beds_baths(false)
 square_feet3150
 square_meters
 acres0
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size0
 icon_1beach-access
 icon_2views
 icon_3pool
 icon_4balcony-terrace
 icon_5sq-ft
 icon_6
 website
 meta_titleTROPICAL PARADISE | Vero Beach Real Estate | Alex MacWilliam Inc.
 meta_description1960 Ocean Ridge Circle is a property offered for sale in Vero Beach, FL, USA, presented by Alex MacWilliam Inc.
 meta_keywords
 bathrooms_partial1
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built1987
 virtual_tour
 video_tour
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num161660
 wsj_property_typesingle family
 nyt_property_type1
 nyt_popular_features
 propgolux_property_type9
 juwai_property_type
 juwai_category
 propgolux_property_style21
 wapo_property_type
 robb_property_type
 propgolux_location_id_override
 open_house_1_start0000-00-00 00:00:00
 open_house_1_end_time00:00:00
 latitude27.600609
 longitude-80.333527
 invalid_required_fields
 invalid_optional_fieldsagent_2_id, square_meters, acres, hectares, virtual_tour, video_tour
 went_live_today(false)
 converted(true)
 invalid(false)
 mlsidx_full_address
 mlsidx_date_listed0000-00-00
 mls_market
 primary_property_category_id0
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated(null)
 modified2019-03-07 16:24:27
 created2015-08-27 10:47:53
 uri/property-detail/2696/1960-ocean-ridge-circle-vero-beach-fl-32963-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/2696/1960-ocean-ridge-circle-vero-beach-fl-32963-usa
 address_concat1960 Ocean Ridge Circle Vero Beach FL 32963 USA
 google_maps_query_string1960+Ocean+Ridge+Circle++Vero+Beach+FL+32963+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 1,625,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty3
 bathrooms_pretty3
 bathrooms_partial_pretty1
 bathrooms_3_4_pretty0
 feed_full_bathrooms3
 date_listed2015-08-27
 overridden_brokerage_name
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 Image(array)
 0(array)
 id16496
 modelProperty
 model_id2696
 tagImage
 name25424.jpg
 typeimage/jpg
 size558575
 uri/assets/16496.jpg
 order1516
 created2016-04-07 16:58:06
 modified2016-04-07 16:58:06
 1(array)
 id16497
 modelProperty
 model_id2696
 tagImage
 name25425.jpg
 typeimage/jpg
 size537851
 uri/assets/16497.jpg
 order1517
 created2016-04-07 16:58:06
 modified2016-04-07 16:58:06
 2(array)
 id16498
 modelProperty
 model_id2696
 tagImage
 name25426.jpg
 typeimage/jpg
 size428509
 uri/assets/16498.jpg
 order1518
 created2016-04-07 16:58:06
 modified2016-04-07 16:58:06
 3(array)
 id16499
 modelProperty
 model_id2696
 tagImage
 name25427.jpg
 typeimage/jpg
 size419652
 uri/assets/16499.jpg
 order1519
 created2016-04-07 16:58:06
 modified2016-04-07 16:58:06
 4(array)
 id16500
 modelProperty
 model_id2696
 tagImage
 name25428.jpg
 typeimage/jpg
 size295274
 uri/assets/16500.jpg
 order1520
 created2016-04-07 16:58:06
 modified2016-04-07 16:58:06
 5(array)
 id16501
 modelProperty
 model_id2696
 tagImage
 name25429.jpg
 typeimage/jpg
 size296040
 uri/assets/16501.jpg
 order1521
 created2016-04-07 16:58:06
 modified2016-04-07 16:58:06
 6(array)
 id16502
 modelProperty
 model_id2696
 tagImage
 name25430.jpg
 typeimage/jpg
 size444470
 uri/assets/16502.jpg
 order1522
 created2016-04-07 16:58:06
 modified2016-04-07 16:58:06
 7(array)
 id16503
 modelProperty
 model_id2696
 tagImage
 name25431.jpg
 typeimage/jpg
 size734963
 uri/assets/16503.jpg
 order1523
 created2016-04-07 16:58:06
 modified2016-04-07 16:58:06
 8(array)
 id16504
 modelProperty
 model_id2696
 tagImage
 name25432.jpg
 typeimage/jpg
 size609688
 uri/assets/16504.jpg
 order1524
 created2016-04-07 16:58:06
 modified2016-04-07 16:58:06
 9(array)
 id16505
 modelProperty
 model_id2696
 tagImage
 name25433.jpg
 typeimage/jpg
 size774079
 uri/assets/16505.jpg
 order1525
 created2016-04-07 16:58:06
 modified2016-04-07 16:58:06
- membership_subscription_temp_allowed_login(null)
- newsletter_member_types(array)
 Leverage Member: AgentLeverage Member: Agent
 Leverage Member: Broker or ManagementLeverage Member: Broker or Management
 Non-MemberNon-Member
- $request->data(empty)
- $this->validationErrors(array)
 Subscription(empty)
 Brokerage(empty)
 FeaturedImage(empty)
 Property(empty)
 User(empty)
 PropertyFeature(empty)
 SecondaryPropertyCategory(empty)
 Topic(empty)
 Image(empty)
- Loaded Helpers(array)
 0Permission
 1Number
 2SimpleGraph
 3DebugTimer
 4Toolbar
 5Session
 6Text
 7Flash
 8HtmlToolbar
 9Html
 10Form
====

Environment

App Constants

Constant	Value
CONFIG	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/Config/
GOOGLE_MAPS_PUBLIC_API_KEY	AIzaSyCD2zmgSzOEN-7tNHYSmGXL0MyWtMlHND4
GOOGLE_MAPS_PRIVATE_API_KEY	AIzaSyCIXpqYsaZp4_suK7IWeqUTIEbS_hMkoXs
RECAPTCHA_V2_SITE_KEY	6Lfs_EoUAAAAAKe8XSwR8p7AEMOLWB96veSLjRDv
RECAPTCHA_V2_SECRET_KEY	6Lfs_EoUAAAAAIo2vzNYILL-YwBaRxvTpjuemmKZ
PROTOCOL	https://
WEB_ENV	staging2
WEB_BASE_URL	https://staging2.leveragere.com
PROP_EMAIL_RECIPIENT	[email protected]
STRIPE_ISSUES_EMAIL_RECIPIENT	[email protected]
STRIPE_ENV	test
STRIPE_PK	pk_test_fIc7eHMfMVAhnrld2Vk2DDpG
STRIPE_SK	sk_test_D4NvWbVo5Fe04IJM0AItMKIR
SHELL_LAUNCHER	/opt/plesk/php/7.4/bin/php /var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/Console/cake.php

CakePHP Constants

Constant	Value
APP	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/
APP_DIR	app
APPLIBS	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/Lib/
CACHE	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/tmp/cache/
CAKE	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/lib/Cake/
CAKE_CORE_INCLUDE_PATH	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/lib
CORE_PATH	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/lib/
CAKE_VERSION	2.10.19
CSS	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot/css/
CSS_URL	css/
DS	/
FULL_BASE_URL	https://staging2.leveragere.com
IMAGES	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot/img/
IMAGES_URL	img/
JS	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot/js/
JS_URL	js/
LOGS	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/tmp/logs/
ROOT	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs
TESTS	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/Test/
TMP	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/tmp/
VENDORS	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/vendors/
WEBROOT_DIR	webroot
WWW_ROOT	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot/

PHP Environment

Environment Variable	Value
Php Version	7.4.33
User	leveragere
Home	/var/www/vhosts/leveragere.com
Script Name	/index.php
Request Uri	/developments
Query String
Request Method	GET
Server Protocol	HTTP/1.1
Gateway Interface	CGI/1.1
Redirect Url	/developments
Remote Port	17674
Script Filename	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot/index.php
Server Admin	root@localhost
Context Document Root	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot
Context Prefix
Request Scheme	https
Document Root	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot
Remote Addr	162.159.115.41
Server Port	443
Server Addr	172.24.32.44
Server Name	staging2.leveragere.com
Server Software	Apache
Server Signature
Path	/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin
Http Host	staging2.leveragere.com
Http Connection	Keep-Alive
Http X Forwarded Proto	https
Http Cf Visitor	{"scheme":"https"}
Http Cf Ipcountry	US
Http Cf Connecting Ip	216.73.216.172
Http Cdn Loop	cloudflare; loops=1
Http User Agent	Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; [email protected])
Http Accept Encoding	gzip, br
Http Accept	/
Http Cf Ray	a09cb40bea503191-CMH
Http X Forwarded For	216.73.216.172
Proxy-nokeepalive	1
Ssl Tls Sni	staging2.leveragere.com
Https	on
Passenger Download Native Support Binary	0
Passenger Compile Native Support Binary	0
Perl5lib	/usr/share/awstats/lib:/usr/share/awstats/plugins
Unique Id	aioJqiieIsN216dqNcqB5AAAARU
Redirect Status	200
Redirect Ssl Tls Sni	staging2.leveragere.com
Redirect Https	on
Redirect Passenger Download Native Support Binary	0
Redirect Passenger Compile Native Support Binary	0
Redirect Perl5lib	/usr/share/awstats/lib:/usr/share/awstats/plugins
Redirect Unique Id	aioJqiieIsN216dqNcqB5AAAARU
Fcgi Role	RESPONDER
Php Self	/index.php
Request Time Float	1781139882.9582
Request Time	1781139882

====

Include
+
Included Files

Include Paths
- 0/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/lib
- 2/opt/plesk/php/7.4/share/pear
- 3-> /var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/lib/Cake/
Included Files
- core(array)
  Behavior(array)
  0CORE/Model/Behavior/ContainableBehavior.php
  Cache(array)
  0CORE/Cache/Cache.php
  1CORE/Cache/Engine/FileEngine.php
  2CORE/Cache/CacheEngine.php
  Component(array)
  0CORE/Controller/Component/AuthComponent.php
  1CORE/Controller/Component/SessionComponent.php
  2CORE/Controller/Component/CookieComponent.php
  3CORE/Controller/Component/RequestHandlerComponent.php
  4CORE/Controller/Component/Auth/FormAuthenticate.php
  5CORE/Controller/Component/Auth/BaseAuthenticate.php
  Config(array)
  0CORE/Config/routes.php
  1CORE/Config/config.php
  Controller(array)
  0CORE/Controller/Controller.php
  1CORE/Controller/ComponentCollection.php
  2CORE/Controller/Component.php
  Datasource(array)
  0CORE/Model/Datasource/CakeSession.php
  1CORE/Model/Datasource/Database/Mysql.php
  2CORE/Model/Datasource/DboSource.php
  3CORE/Model/Datasource/DataSource.php
  Error(array)
  0CORE/Error/exceptions.php
  1CORE/Error/ErrorHandler.php
  I18n(array)
  0CORE/I18n/I18n.php
  1CORE/I18n/L10n.php
  Log(array)
  0CORE/Log/CakeLog.php
  1CORE/Log/LogEngineCollection.php
  2CORE/Log/Engine/FileLog.php
  3CORE/Log/Engine/BaseLog.php
  4CORE/Log/CakeLogInterface.php
  Model(array)
  0CORE/Model/Model.php
  1CORE/Model/BehaviorCollection.php
  2CORE/Model/ModelBehavior.php
  3CORE/Model/ConnectionManager.php
  Network(array)
  0CORE/Network/CakeRequest.php
  1CORE/Network/CakeResponse.php
  Other(array)
  0CORE/bootstrap.php
  1CORE/basics.php
  2CORE/Core/App.php
  3CORE/Core/Configure.php
  4CORE/Core/CakePlugin.php
  5CORE/Event/CakeEventListener.php
  6CORE/Event/CakeEvent.php
  7CORE/Event/CakeEventManager.php
  8CORE/Core/CakeObject.php
  Routing(array)
  0CORE/Routing/Dispatcher.php
  1CORE/Routing/Filter/AssetDispatcher.php
  2CORE/Routing/DispatcherFilter.php
  3CORE/Routing/Filter/CacheDispatcher.php
  4CORE/Routing/Router.php
  5CORE/Routing/Route/CakeRoute.php
  6CORE/Routing/Route/RedirectRoute.php
  7CORE/Routing/Route/PluginShortRoute.php
  Utility(array)
  0CORE/Utility/Hash.php
  1CORE/Utility/Inflector.php
  2CORE/Utility/ObjectCollection.php
  3CORE/Utility/Debugger.php
  4CORE/Utility/CakeText.php
  5CORE/Utility/ClassRegistry.php
  View(array)
  0CORE/View/HelperCollection.php
- app(array)
  Component(array)
  0APP/Controller/Component/PermissionComponent.php
  1APP/Controller/Component/LocationSearchComponent.php
  Config(array)
  0APP/Config/core.php
  1APP/Config/bootstrap.php
  2APP/Config/routes.php
  3APP/Config/database.php
  Controller(array)
  0APP/Controller/BrokeragesController.php
  1APP/Controller/AppController.php
  Model(array)
  0APP/Model/Subscription.php
  1APP/Model/AppModel.php
  2APP/Model/Brokerage.php
  3APP/Model/Asset.php
  4APP/Model/Property.php
  5APP/Model/User.php
  6APP/Model/PropertyFeature.php
  7APP/Model/PropertyCategory.php
  8APP/Model/Topic.php
  Other(array)
  0APP/webroot/index.php
  1APP/Vendor/permissions.php
- plugins(array)
  DebugKit(array)
  Component(array)
  0DebugKit/Controller/Component/ToolbarComponent.php
  Plugin(array)
  0DebugKit/Lib/DebugMemory.php
  1DebugKit/Lib/Panel/HistoryPanel.php
  2DebugKit/Lib/DebugPanel.php
  3DebugKit/Lib/Panel/SessionPanel.php
  4DebugKit/Lib/Panel/RequestPanel.php
  5DebugKit/Lib/Panel/SqlLogPanel.php
  6DebugKit/Lib/Panel/TimerPanel.php
  7DebugKit/Lib/Panel/LogPanel.php
  8DebugKit/Lib/Log/Engine/DebugKitLog.php
  9DebugKit/Lib/Panel/VariablesPanel.php
  10DebugKit/Lib/Panel/EnvironmentPanel.php
  11DebugKit/Lib/Panel/IncludePanel.php
  12DebugKit/Lib/DebugTimer.php
====

Discover Leverage Developments

NIX Realty Company

Featured Offerings

121 West Brandon Drive, Bel Meade

114 Brittany Olmos Park

Alex MacWilliam Inc.

Featured Offerings

Fabulous Oceanfront Condo

TROPICAL PARADISE

Pam Harrington Exclusives

Featured Offerings

3120 Privateer Creek

Exclusive Auction Opportunity

DeSell & Co. Realty Group - Equine Specialist

Featured Offerings

21 Acre Farm With Barn and Apartment

Quail Glen

Joyce Realty

The Marchant Company, Inc.

Featured Offerings

AUTHENTIC TUDOR HOME ON PENINSULA

Amazing Historic Home on 9.83 Acres

Share This

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 34 ms Total Queries: 15 queries

Query Explain:

Memory

Timers

Logs

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

Total Time: 34 ms
Total Queries: 15 queries