Notice (8): Undefined index: mlsidx_id_array [APP/Controller/BrokeragesController.php, line 537]Code Context        $mls_compliance_data = $this->MlsComplianceData->find('all', [
            'conditions' => [
                'MlsComplianceData.mlsidx_brokerage_id' => $brokerage['Brokerage']['mlsidx_id_array']
$id = '198'
$brokerage = array(
	'Brokerage' => array(
		'password' => '*****',
		'id' => '198',
		'account_executive_id' => '0',
		'archived' => false,
		'type' => 'brokerage',
		'hide_from_frontend' => false,
		'agent_brokerage_data_override' => false,
		'featured_development' => false,
		'membership_type' => 'Premium',
		'max_properties' => '8',
		'max_homepage_featured_by_member_properties' => '0',
		'featured_properties_sort_method' => 'manual',
		'lux_feed_mode' => 'StripeSubscription',
		'max_luxury_feed_properties' => '1',
		'membership_luxury_feed_properties' => '0',
		'can_participate_in_lux_feed_while_archived' => false,
		'full_training_video_access' => false,
		'country_id' => '0',
		'WOEID' => '2443945',
		'timezone' => '',
		'luxury_feed_enrollment_mode' => 'manual',
		'luxury_feed_include_mlsidx_minimum_price' => '0',
		'luxury_feed_include_leverage_minimum_price' => '0',
		'digital_ad_contacts' => '',
		'add_agents_to_grr_auto_recipients' => true,
		'mlsidx_id' => '',
		'mlsidx_lux_autofeed' => false,
		'mlsidx_lux_autofeed_minimum_price' => '0',
		'mlsidx_logo_url' => '',
		'mlsidx_disclaimer' => '',
		'name' => 'Sprinkman Real Estate',
		'broker_of_record_name' => '',
		'short_name' => 'Sprinkman Real Estate',
		'username' => 'SprinkmanRealEstate',
		'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' => '',
		'description' => '<p>Sprinkman Real Estate is the exclusive representative for Leverage Global Partners in all of Dane County including Madison, Maple Bluff, Shorewood Hills, Middleton and surrounding communities.</p>

<p>Sprinkman Real Estate is an independent boutique brokerage in Madison, Wisconsin. With over 20 years of experience in the Madison market, the team includes top-producing agents who know and love Madison and it&rsquo;s many unique neighborhoods and surrounding communities ranging from urban, walkable, downtown areas to lake properties to unique rural properties. Our agents listen intently to their clients&rsquo; needs and expertly guide them to the neighborhood and home that perfectly suits their lifestyle.</p>

<p>Our exclusive support team includes an experienced, professional stager who offers comprehensive staging services and complementary post-move in interior design consultations, a photographer who specializes in architectural photography, a marketing staff that is attuned to cutting-edge resources and a transaction manager to cross all the i&rsquo;s and dot all the t&rsquo;s.</p>

<p>We bring together our unique talents and years of expertise, as well as our individual strengths and passions, in order to expertly guide you through the process all the while providing extraordinary, highly personalized service and a paperless process using customized technology.</p>
',
		'communities' => 'Dane county
Madison
Maple Bluff
Dun
Shorewood Hills
Springfield
Westport',
		'website' => 'http://sprinkmanrealestate.com/',
		'address' => '613 Williamson Street',
		'address_2' => 'Suite 202',
		'city' => 'Madison',
		'state' => 'WI',
		'full_state' => 'Wisconsin',
		'country' => 'USA',
		'market' => '',
		'market_2' => '',
		'postal_code' => '53703',
		'phone' => 'Shelly: (608) 220-1453',
		'phone_2' => 'Julie: (608) 219-6492',
		'phone_3' => '',
		'wide_contact_image' => true,
		'contact_name' => 'Shelly Sprinkman, Julie Bernauer',
		'contact_profile_link' => '',
		'contact_big_profile_link' => '',
		'contact_big_profile_link_text' => '',
		'contact_title' => 'Broker/Owner, Broker',
		'contact_dre_num' => '',
		'contact_quote' => '',
		'contact_email' => 'shelly@sprinkmanrealestate.com',
		'contact_facebook' => '',
		'contact_twitter' => '',
		'contact_instagram' => '',
		'contact_pinterest' => '',
		'contact_linkedin' => '',
		'contact_youtube' => '',
		'contact_phone' => '',
		'contact_email_2' => 'Julie@sprinkmanrealestate.com',
		'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_filename' => '198.jpg',
		'logo_filename' => '198.',
		'contact_image_filename' => '198.jpg',
		'all_properties_link_image_filename' => '198.jpg',
		'all_properties_link' => 'http://sprinkmanrealestate.com/featured-listings',
		'video_embed_code' => '',
		'contact_video_embed_code' => '',
		'meta_title' => 'Madison Real Estate | Sprinkman Real Estate | Leverage Global Partners',
		'meta_description' => 'Sprinkman Real Estate is the exclusive representative for Leverage Global Partners in all of Dane county including Madison, Maple Bluff, Dun, Shorewood Hills, Springfield, and Westport, WI.',
		'meta_keywords' => 'Sprinkman Real Estate, Leverage Global Partners, Dane county Real Estate, Madison Real Estate, Maple Bluff Real Estate, Dun Real Estate, Shorewood Hills Real Estate, Springfield Real Estate, Westport Real Estate, Wisconsin Real Estate, Shelly Sprinkman',
		'login_message_counter' => '0',
		'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_sent' => '0000-00-00 00:00:00',
		'converted' => true,
		'created' => '2015-03-20 14:25:30',
		'modified' => '2016-04-18 13:13:12',
		'dre_num' => '012345',
		'uri' => '/brokerage-detail/198/sprinkman-real-estate',
		'website_short' => 'sprinkmanrealestate.com',
		'name_with_location' => 'Sprinkman Real Estate'
	),
	'Logo' => array(
		'id' => '2824',
		'model' => 'Brokerage',
		'model_id' => '198',
		'tag' => 'Logo',
		'name' => '198.',
		'type' => 'image/',
		'size' => '32988',
		'uri' => '/assets/2824.',
		'order' => '0',
		'created' => '2016-03-30 11:44:36',
		'modified' => '2016-04-18 13:13:12'
	),
	'MainImage' => array(
		'id' => '2823',
		'model' => 'Brokerage',
		'model_id' => '198',
		'tag' => 'MainImage',
		'name' => '198.jpg',
		'type' => 'image/jpg',
		'size' => '114342',
		'uri' => '/assets/2823.jpg',
		'order' => '0',
		'created' => '2016-03-30 11:44:36',
		'modified' => '2016-04-18 13:13:12'
	),
	'ContactImage' => array(
		'id' => '21029',
		'model' => 'Brokerage',
		'model_id' => '198',
		'tag' => 'ContactImage',
		'name' => 'combined sprinkman headshots.jpg',
		'type' => 'image/jpeg',
		'size' => '809390',
		'uri' => '/assets/21029.jpg',
		'order' => '0',
		'created' => '2016-04-18 13:13:09',
		'modified' => '2016-04-18 13:13:12'
	),
	'ContactImage2' => array(
		'id' => null,
		'model' => null,
		'model_id' => null,
		'tag' => null,
		'name' => null,
		'type' => null,
		'size' => null,
		'uri' => null,
		'order' => null,
		'created' => null,
		'modified' => null
	),
	'ContactImage3' => array(
		'id' => null,
		'model' => null,
		'model_id' => null,
		'tag' => null,
		'name' => null,
		'type' => null,
		'size' => null,
		'uri' => null,
		'order' => null,
		'created' => null,
		'modified' => null
	),
	'BrokerOfRecordLogo' => array(
		'id' => null,
		'model' => null,
		'model_id' => null,
		'tag' => null,
		'name' => null,
		'type' => null,
		'size' => null,
		'uri' => null,
		'order' => null,
		'created' => null,
		'modified' => null
	),
	'FeaturedImage' => array()
)
BrokeragesController::view() - APP/Controller/BrokeragesController.php, line 537
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 499
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 110

Leverage Brokerage | Sprinkman Real Estate

Properties / Sprinkman Real Estate

Sprinkman Real Estate

Broker/Owner, Broker: Shelly Sprinkman, Julie Bernauer
Shelly: (608) 220-1453

License #: 012345

Visit Website

Madison is on all the "best of" lists for a reason - it's a great place to live!

Sprinkman Real Estate is the exclusive representative for Leverage Global Partners in all of Dane County including Madison, Maple Bluff, Shorewood Hills, Middleton and surrounding communities.

Sprinkman Real Estate is an independent boutique brokerage in Madison, Wisconsin. With over 20 years of experience in the Madison market, the team includes top-producing agents who know and love Madison and it’s many unique neighborhoods and surrounding communities ranging from urban, walkable, downtown areas to lake properties to unique rural properties. Our agents listen intently to their clients’ needs and expertly guide them to the neighborhood and home that perfectly suits their lifestyle.

Our exclusive support team includes an experienced, professional stager who offers comprehensive staging services and complementary post-move in interior design consultations, a photographer who specializes in architectural photography, a marketing staff that is attuned to cutting-edge resources and a transaction manager to cross all the i’s and dot all the t’s.

We bring together our unique talents and years of expertise, as well as our individual strengths and passions, in order to expertly guide you through the process all the while providing extraordinary, highly personalized service and a paperless process using customized technology.

Connect With Us

sprinkmanrealestate.com

Sprinkman Real Estate Featured Properties

Property Search

Bedrooms

Baths

Minimum Price

Maximum Price

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

Cake Params
- plugin(null)
- controllerbrokerages
- actionview
- named(empty)
- pass(array)
  0198
  1sprinkman-real-estate
- isAjax(false)
Post data

No post data.

Query string

No querystring data.

Cookie
- 0(empty)
Current Route
- keys(empty)
- options(empty)
- defaults(array)
  controllerbrokerages
  actionview
  plugin(null)
- template/brokerage-detail/*
====

Sql Log

Sql Logs

default

Total Time: 11 ms
Total Queries: 10 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`, `Logo`.`id`, `Logo`.`model`, `Logo`.`model_id`, `Logo`.`tag`, `Logo`.`name`, `Logo`.`type`, `Logo`.`size`, `Logo`.`uri`, `Logo`.`order`, `Logo`.`created`, `Logo`.`modified`, `MainImage`.`id`, `MainImage`.`model`, `MainImage`.`model_id`, `MainImage`.`tag`, `MainImage`.`name`, `MainImage`.`type`, `MainImage`.`size`, `MainImage`.`uri`, `MainImage`.`order`, `MainImage`.`created`, `MainImage`.`modified`, `ContactImage`.`id`, `ContactImage`.`model`, `ContactImage`.`model_id`, `ContactImage`.`tag`, `ContactImage`.`name`, `ContactImage`.`type`, `ContactImage`.`size`, `ContactImage`.`uri`, `ContactImage`.`order`, `ContactImage`.`created`, `ContactImage`.`modified`, `ContactImage2`.`id`, `ContactImage2`.`model`, `ContactImage2`.`model_id`, `ContactImage2`.`tag`, `ContactImage2`.`name`, `ContactImage2`.`type`, `ContactImage2`.`size`, `ContactImage2`.`uri`, `ContactImage2`.`order`, `ContactImage2`.`created`, `ContactImage2`.`modified`, `ContactImage3`.`id`, `ContactImage3`.`model`, `ContactImage3`.`model_id`, `ContactImage3`.`tag`, `ContactImage3`.`name`, `ContactImage3`.`type`, `ContactImage3`.`size`, `ContactImage3`.`uri`, `ContactImage3`.`order`, `ContactImage3`.`created`, `ContactImage3`.`modified`, `BrokerOfRecordLogo`.`id`, `BrokerOfRecordLogo`.`model`, `BrokerOfRecordLogo`.`model_id`, `BrokerOfRecordLogo`.`tag`, `BrokerOfRecordLogo`.`name`, `BrokerOfRecordLogo`.`type`, `BrokerOfRecordLogo`.`size`, `BrokerOfRecordLogo`.`uri`, `BrokerOfRecordLogo`.`order`, `BrokerOfRecordLogo`.`created`, `BrokerOfRecordLogo`.`modified` FROM `leveragere_staging2`.`brokerages` AS `Brokerage` LEFT JOIN `leveragere_staging2`.`assets` AS `Logo` ON (`Logo`.`model_id` = `Brokerage`.`id` AND `Logo`.`model` = 'Brokerage' AND `Logo`.`tag` = 'Logo') LEFT JOIN `leveragere_staging2`.`assets` AS `MainImage` ON (`MainImage`.`model_id` = `Brokerage`.`id` AND `MainImage`.`model` = 'Brokerage' AND `MainImage`.`tag` = 'MainImage') LEFT JOIN `leveragere_staging2`.`assets` AS `ContactImage` ON (`ContactImage`.`model_id` = `Brokerage`.`id` AND `ContactImage`.`model` = 'Brokerage' AND `ContactImage`.`tag` = 'ContactImage') LEFT JOIN `leveragere_staging2`.`assets` AS `ContactImage2` ON (`ContactImage2`.`model_id` = `Brokerage`.`id` AND `ContactImage2`.`model` = 'Brokerage' AND `ContactImage2`.`tag` = 'ContactImage2') LEFT JOIN `leveragere_staging2`.`assets` AS `ContactImage3` ON (`ContactImage3`.`model_id` = `Brokerage`.`id` AND `ContactImage3`.`model` = 'Brokerage' AND `ContactImage3`.`tag` = 'ContactImage3') LEFT JOIN `leveragere_staging2`.`assets` AS `BrokerOfRecordLogo` ON (`BrokerOfRecordLogo`.`model_id` = `Brokerage`.`id` AND `BrokerOfRecordLogo`.`model` = 'Brokerage' AND `BrokerOfRecordLogo`.`tag` = 'BrokerOfRecordLogo') WHERE `Brokerage`.`id` = 198 AND `Brokerage`.`archived` = '0' AND `Brokerage`.`hide_from_frontend` = '0' LIMIT 1	1	1	1
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` = (198) ORDER BY `FeaturedImage`.`order` ASC	0	0	0
SELECT `Location`.`id`, `Location`.`parent_id`, `Location`.`brokerage_id`, `Location`.`type`, `Location`.`archived`, `Location`.`use_as_topic`, `Location`.`name`, `Location`.`short_name`, `Location`.`group_index`, `Location`.`latitude`, `Location`.`longitude`, `Location`.`country_code`, `Location`.`north`, `Location`.`south`, `Location`.`east`, `Location`.`west`, `Location`.`zoom`, `Location`.`short_description`, `Location`.`long_description`, `Location`.`created`, `Location`.`modified`, `Location`.`timezone`, `Location`.`population`, `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`, `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`.`locations` AS `Location` LEFT JOIN `leveragere_staging2`.`brokerages` AS `Brokerage` ON (`Location`.`brokerage_id` = `Brokerage`.`id`) LEFT JOIN `leveragere_staging2`.`assets` AS `Image` ON (`Image`.`model_id` = `Location`.`id` AND `Image`.`model` = 'Location' AND `Image`.`tag` = 'Image') WHERE `Location`.`brokerage_id` = 198 AND `Location`.`archived` = '0'	1	1	1
SELECT `Article`.`id`, `Article`.`model`, `Article`.`model_id`, `Article`.`archived`, `Article`.`medium_featured`, `Article`.`large_featured`, `Article`.`title`, `Article`.`author`, `Article`.`date`, `Article`.`lead_in`, `Article`.`body`, `Article`.`vimeo_id`, `Article`.`created`, `Article`.`modified`, `ParentBrokerage`.`id`, `ParentBrokerage`.`account_executive_id`, `ParentBrokerage`.`archived`, `ParentBrokerage`.`type`, `ParentBrokerage`.`hide_from_frontend`, `ParentBrokerage`.`agent_brokerage_data_override`, `ParentBrokerage`.`featured_development`, `ParentBrokerage`.`membership_type`, `ParentBrokerage`.`max_properties`, `ParentBrokerage`.`max_homepage_featured_by_member_properties`, `ParentBrokerage`.`featured_properties_sort_method`, `ParentBrokerage`.`lux_feed_mode`, `ParentBrokerage`.`max_luxury_feed_properties`, `ParentBrokerage`.`membership_luxury_feed_properties`, `ParentBrokerage`.`can_participate_in_lux_feed_while_archived`, `ParentBrokerage`.`full_training_video_access`, `ParentBrokerage`.`country_id`, `ParentBrokerage`.`WOEID`, `ParentBrokerage`.`timezone`, `ParentBrokerage`.`luxury_feed_enrollment_mode`, `ParentBrokerage`.`luxury_feed_include_mlsidx_minimum_price`, `ParentBrokerage`.`luxury_feed_include_leverage_minimum_price`, `ParentBrokerage`.`digital_ad_contacts`, `ParentBrokerage`.`add_agents_to_grr_auto_recipients`, `ParentBrokerage`.`mlsidx_id`, `ParentBrokerage`.`mlsidx_lux_autofeed`, `ParentBrokerage`.`mlsidx_lux_autofeed_minimum_price`, `ParentBrokerage`.`mlsidx_logo_url`, `ParentBrokerage`.`mlsidx_disclaimer`, `ParentBrokerage`.`name`, `ParentBrokerage`.`broker_of_record_name`, `ParentBrokerage`.`short_name`, `ParentBrokerage`.`username`, `ParentBrokerage`.`password`, `ParentBrokerage`.`password_reset_hash`, `ParentBrokerage`.`monthly_invoice_amount`, `ParentBrokerage`.`monthly_invoice_start_date`, `ParentBrokerage`.`monthly_invoice_end_date`, `ParentBrokerage`.`contract_filename`, `ParentBrokerage`.`active`, `ParentBrokerage`.`lead_in`, `ParentBrokerage`.`short_description`, `ParentBrokerage`.`description`, `ParentBrokerage`.`communities`, `ParentBrokerage`.`website`, `ParentBrokerage`.`address`, `ParentBrokerage`.`address_2`, `ParentBrokerage`.`city`, `ParentBrokerage`.`state`, `ParentBrokerage`.`full_state`, `ParentBrokerage`.`country`, `ParentBrokerage`.`market`, `ParentBrokerage`.`market_2`, `ParentBrokerage`.`postal_code`, `ParentBrokerage`.`phone`, `ParentBrokerage`.`phone_2`, `ParentBrokerage`.`phone_3`, `ParentBrokerage`.`wide_contact_image`, `ParentBrokerage`.`contact_name`, `ParentBrokerage`.`contact_profile_link`, `ParentBrokerage`.`contact_big_profile_link`, `ParentBrokerage`.`contact_big_profile_link_text`, `ParentBrokerage`.`contact_title`, `ParentBrokerage`.`contact_dre_num`, `ParentBrokerage`.`contact_quote`, `ParentBrokerage`.`contact_email`, `ParentBrokerage`.`contact_facebook`, `ParentBrokerage`.`contact_twitter`, `ParentBrokerage`.`contact_instagram`, `ParentBrokerage`.`contact_pinterest`, `ParentBrokerage`.`contact_linkedin`, `ParentBrokerage`.`contact_youtube`, `ParentBrokerage`.`contact_phone`, `ParentBrokerage`.`contact_email_2`, `ParentBrokerage`.`contact_2_facebook`, `ParentBrokerage`.`contact_2_twitter`, `ParentBrokerage`.`contact_2_instagram`, `ParentBrokerage`.`contact_2_pinterest`, `ParentBrokerage`.`contact_2_linkedin`, `ParentBrokerage`.`contact_2_youtube`, `ParentBrokerage`.`contact_phone_2`, `ParentBrokerage`.`contact_website`, `ParentBrokerage`.`contact_name_2`, `ParentBrokerage`.`contact_profile_link_2`, `ParentBrokerage`.`contact_big_profile_link_2`, `ParentBrokerage`.`contact_big_profile_link_text_2`, `ParentBrokerage`.`contact_title_2`, `ParentBrokerage`.`contact_dre_num_2`, `ParentBrokerage`.`contact_email_3`, `ParentBrokerage`.`contact_name_3`, `ParentBrokerage`.`contact_title_3`, `ParentBrokerage`.`contact_dre_num_3`, `ParentBrokerage`.`contact_phone_3`, `ParentBrokerage`.`contact_3_facebook`, `ParentBrokerage`.`contact_3_twitter`, `ParentBrokerage`.`contact_3_instagram`, `ParentBrokerage`.`contact_3_pinterest`, `ParentBrokerage`.`contact_3_linkedin`, `ParentBrokerage`.`contact_3_youtube`, `ParentBrokerage`.`image_filename`, `ParentBrokerage`.`logo_filename`, `ParentBrokerage`.`contact_image_filename`, `ParentBrokerage`.`all_properties_link_image_filename`, `ParentBrokerage`.`all_properties_link`, `ParentBrokerage`.`video_embed_code`, `ParentBrokerage`.`contact_video_embed_code`, `ParentBrokerage`.`meta_title`, `ParentBrokerage`.`meta_description`, `ParentBrokerage`.`meta_keywords`, `ParentBrokerage`.`login_message_counter`, `ParentBrokerage`.`stats_module_1_type`, `ParentBrokerage`.`stats_module_1_value`, `ParentBrokerage`.`stats_module_2_type`, `ParentBrokerage`.`stats_module_2_value`, `ParentBrokerage`.`stats_module_3_type`, `ParentBrokerage`.`stats_module_3_value`, `ParentBrokerage`.`last_activity_email_sent`, `ParentBrokerage`.`converted`, `ParentBrokerage`.`created`, `ParentBrokerage`.`modified`, `ParentBrokerage`.`dre_num`, `ParentLocation`.`id`, `ParentLocation`.`parent_id`, `ParentLocation`.`brokerage_id`, `ParentLocation`.`type`, `ParentLocation`.`archived`, `ParentLocation`.`use_as_topic`, `ParentLocation`.`name`, `ParentLocation`.`short_name`, `ParentLocation`.`group_index`, `ParentLocation`.`latitude`, `ParentLocation`.`longitude`, `ParentLocation`.`country_code`, `ParentLocation`.`north`, `ParentLocation`.`south`, `ParentLocation`.`east`, `ParentLocation`.`west`, `ParentLocation`.`zoom`, `ParentLocation`.`short_description`, `ParentLocation`.`long_description`, `ParentLocation`.`created`, `ParentLocation`.`modified`, `ParentLocation`.`timezone`, `ParentLocation`.`population` FROM `leveragere_staging2`.`articles` AS `Article` LEFT JOIN `leveragere_staging2`.`brokerages` AS `ParentBrokerage` ON (`Article`.`model_id` = `ParentBrokerage`.`id` AND `Article`.`model` = 'Brokerage') LEFT JOIN `leveragere_staging2`.`locations` AS `ParentLocation` ON (`Article`.`model_id` = `ParentLocation`.`id` AND `Article`.`model` = 'Location') WHERE `Article`.`model` = 'Brokerage' AND `Article`.`model_id` = 198 LIMIT 1	0	0	1	maybe slow
SELECT `Article`.`id` FROM `leveragere_staging2`.`articles` AS `Article` WHERE `Article`.`archived` = '0' AND NOT (`Article`.`model` = ('News')) ORDER BY `Article`.`created` DESC LIMIT 50	50	50	2
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` = 'Article' AND `Image`.`tag` = 'Image' AND `Image`.`model_id` IN (499, 498, 497, 495, 494, 493, 492, 491, 490, 487, 488, 486, 484, 485, 483, 482, 481, 480, 479, 478, 477, 476, 475, 473, 472, 470, 471, 468, 467, 466, 465, 464, 463, 462, 461, 459, 460, 458, 457, 456, 455, 454, 452, 453, 451, 450, 449, 448, 447, 446) ORDER BY `Image`.`order` ASC	50	50	1
SELECT `Article`.`id`, `Article`.`model`, `Article`.`model_id`, `Article`.`archived`, `Article`.`medium_featured`, `Article`.`large_featured`, `Article`.`title`, `Article`.`author`, `Article`.`date`, `Article`.`lead_in`, `Article`.`body`, `Article`.`vimeo_id`, `Article`.`created`, `Article`.`modified` FROM `leveragere_staging2`.`articles` AS `Article` WHERE `Article`.`id` IN (499, 498, 497, 495, 494, 493, 492, 491, 490, 487, 488, 486, 484, 485, 483, 482, 481, 480, 479, 478, 477, 476, 475, 473, 472, 470, 471, 468, 467, 466, 465, 464, 463, 462, 461, 459, 460, 458, 457, 456, 455, 454, 452, 453, 451, 450, 449, 448, 447, 446) ORDER BY RAND() ASC LIMIT 4	4	4	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` = 'Article' AND `Image`.`tag` = 'Image' AND `Image`.`model_id` IN (481, 455, 497, 453) ORDER BY `Image`.`order` ASC	4	4	0
SELECT `Location`.`id`, `Location`.`parent_id`, `Location`.`brokerage_id`, `Location`.`type`, `Location`.`archived`, `Location`.`use_as_topic`, `Location`.`name`, `Location`.`short_name`, `Location`.`group_index`, `Location`.`latitude`, `Location`.`longitude`, `Location`.`country_code`, `Location`.`north`, `Location`.`south`, `Location`.`east`, `Location`.`west`, `Location`.`zoom`, `Location`.`short_description`, `Location`.`long_description`, `Location`.`created`, `Location`.`modified`, `Location`.`timezone`, `Location`.`population`, `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`, `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`.`locations` AS `Location` LEFT JOIN `leveragere_staging2`.`brokerages` AS `Brokerage` ON (`Location`.`brokerage_id` = `Brokerage`.`id`) LEFT JOIN `leveragere_staging2`.`assets` AS `Image` ON (`Image`.`model_id` = `Location`.`id` AND `Image`.`model` = 'Location' AND `Image`.`tag` = 'Image') WHERE `Location`.`type` = 'Exclusive' AND `Location`.`archived` = '0' ORDER BY RAND() ASC LIMIT 4	4	4	4
SELECT `MlsComplianceData`.`id`, `MlsComplianceData`.`mlsidx_brokerage_id`, `MlsComplianceData`.`mlsidx_logo_url`, `MlsComplianceData`.`mlsidx_disclaimer`, `MlsComplianceData`.`created`, `MlsComplianceData`.`modified` FROM `leveragere_staging2`.`mls_compliance_data` AS `MlsComplianceData` WHERE `MlsComplianceData`.`mlsidx_brokerage_id` IS NULL	0	0	0

Query Explain:

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

====

Timer

Memory

Peak Memory Use 10.04 MB

Message	Memory use
Component initialization	2.93 MB
Controller action start	3.86 MB
Controller render start	6.09 MB
View render complete	6.59 MB

Timers

Total Request Time: 209 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	35.40
Event: Controller.initialize	5.04
Event: Controller.startup	2.49
Controller action	55.96
Event: Controller.beforeRender	7.63
» Processing toolbar data	7.53
Rendering View	81.58
» Event: View.beforeRender	0.42
» Rendering APP/View/Brokerages/view.ctp	0.74
» » Rendering APP/View/Elements/sidebar/property_search.ctp	0.23
» Event: View.afterRender	0.01
» Event: View.beforeLayout	0.01
» Rendering APP/View/Layouts/front.ctp	79.62
Event: View.afterLayout	0.00

====

Log
+

Logs

There were no log entries made this request

====
Variables
+
View Variables
- mls_compliance_data(empty)
- sidebar_locations(array)
 0(array)
 Location(array)
 id62
 parent_id8
 brokerage_id101
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameSavannah, GA, USA
 short_nameSavannah, GA, USA
 group_index
 latitude32.081261
 longitude-81.080986
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_descriptionHistoric Homes, Live Oaks draped in Moss, Oceanfront, Marshfront, Savannah has it all!
 long_descriptionSavannah has so much to offer…from the beaches at Tybee Island, the interior islands with miles of marsh and spectacular views of the intracoastal, to the The National Historic Landmark District, the largest National Historic Landmark District in the United States. Its cobblestone streets, manicured gardens and live oak-shaded squares make it one of the most beautiful cities in the world! It is a very walkable city, thanks to the urban plan laid by General Oglethorpe - you can even take your cocktails to go as you stroll through the neighborhood and visit the shops, cafes, art galleries and museums! You will find a good mix of historic homes in need of a little TLC, fully restored homes and new construction in the in the form of town homes and condominiums.
 created2016-04-04 16:41:48
 modified2016-04-04 16:41:48
 timezoneAmerica/New_York
 population375000
 uri/locations/view/62/savannah-ga-usa
 tile_nameSavannah, GA, USA
 Brokerage(array)
 id101
 account_executive_id236
 archived(false)
 typebrokerage
 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
 WOEID2489314
 timezoneUS/Eastern
 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
 nameThree Oaks Realty Co.
 broker_of_record_name
 short_nameThree Oaks Realty Co.
 usernameThreeOaksRealty
 password2e25ea6416fb35cb0184a531b476e7a8d1233cf9
 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
 descriptionThree Oaks Realty Co. is the exclusive representative for Leverage Global Partners in Historic Savannah, Tybee Island, Wilmington Island, Whitemarsh Island, Isle of Hope, Skidaway Island, Pooler, Rincon, Richmond Hill, Garden City, Hutchinson Island and Savannah, Georgia, USA. We founded Three Oaks Realty Company on the idea that you should love what you do, do it better than anyone else, and attract others that appreciate those two principles. Our company culture is not only extraordinarily customer centric, but it is built on a foundation of mutual respect for one another, our colleagues and vendors. This bond transcends everything we do. We’re also really fun people, so if you’re ever in the neighborhood- stop by and say hi. Why Three Oaks? At Three Oaks Realty, we have a vast amount of experience selling Savannah and the Low Country. We decided to start our company because we believe in a different approach to real estate, and we are eager to share our experience and our approach with you. We believe that you should be the center of everything we do. Not a fancy brand or a complex process. Life is busy, we get that, and our goal is to make your transaction smooth, efficient, satisfying and above all, enjoyable. We chose our name, Three Oaks Realty Company, not only because the oak tree stands as one of our area’s most distinctive landmarks, but because its unique stature embodies everything we love about living and working in the low country. The enchanting, understated, natural beauty captures the unique allure that makes Savannah the perfect place to call home. Part of what makes our Southern Live Oak trees so iconic is the presence of Spanish moss- a bit like a natural partnership. We believe that real estate should embody this same principal. It should be collaborative- between realtors, clients, vendors and community partners. When all of these things are working together- it has the power to turn real estate dreams into reality. No two oaks are the same, but they are unified in their strong roots and the foundation from which they grow. That mirrors how we feel about our partnership at Three Oaks Realty Company. We all bring different perspectives and different strengths to the table, but we have the same core beliefs. It’s these beliefs that represent the roots of this company and everything we do. Simply, love what you do, and do it better than anyone else.
 communitiesSkidaway Island Isle of Hope Tybee Island Pooler, Rincon Richmond Hill Garden City Whitemarsh Island Wilmington Island Hutchinson Island Historic district Historic Savannah
 websitehttp://www.threeoaksrealtycompany.com/
 address509 Barnard Street
 address_2
 citySavannah
 stateGA
 full_stateGeorgia
 countryUSA
 marketSavannah
 market_2
 postal_code
 phoneOffice: (912) 777-4560
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameCliff Murse, Stephanie Wilson-Evans, Tommy Reese
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titlePartners
 contact_dre_num
 contact_quoteWe invite you to contact us personally about Savannah real estate.
 contact_emailcliff@threeoaksrealtycompany.com
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2stephanie@threeoaksrealtycompany.com
 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_3tommy@threeoaksrealtycompany.com
 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_filename101.jpg
 logo_filename101.jpeg
 contact_image_filename101.jpeg
 all_properties_link_image_filename101.jpg
 all_properties_linkhttp://www.threeoaksrealtycompany.com/category/featured-property/
 video_embed_code
 contact_video_embed_code
 meta_titleSavannah Real Estate | Three Oaks Realty Co. | Leverage Global Partners
 meta_descriptionThree Oaks Realty Co. is the exclusive representative for Leverage Global Partners in Savannah, Georgia, USA.
 meta_keywordsSavannah Real Estate, Three Oaks Realty Co., Leverage Global Partners, Cliff Murse, Historic District, Historic Savannah
 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-02-27 16:38:01
 modified2016-04-08 16:34:01
 dre_num012345
 uri/brokerage-detail/101/three-oaks-realty-co
 website_shortwww.threeoaksrealtycompany.com
 name_with_locationThree Oaks Realty Co.
 Image(array)
 id2994
 modelLocation
 model_id62
 tagImage
 name39922990_savannah_ga.jpg
 typeimage/jpeg
 size5427412
 uri/assets/2994.jpg
 order0
 created2016-04-04 16:38:34
 modified2016-04-04 16:41:48
 1(array)
 Location(array)
 id121
 parent_id9
 brokerage_id56
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameWalnut Creek, CA, USA
 short_nameWalnut Creek, CA, USA
 group_index
 latitude37.910076
 longitude-122.065186
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_description
 long_descriptionMore information coming soon!
 created2016-04-05 17:59:30
 modified2016-04-14 14:56:55
 timezoneAmerica/Los_Angeles
 population67000
 uri/locations/view/121/walnut-creek-ca-usa
 tile_nameWalnut Creek, CA, USA
 Brokerage(array)
 id56
 account_executive_id235
 archived(false)
 typebrokerage
 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_id1
 WOEID2513768
 timezoneUS/Pacific
 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
 nameJ. Rockcliff Realtors
 broker_of_record_name
 short_nameJ Rockcliff Realtors
 usernameJRockcliffWC
 password14a01d92dcd7b0cd5ad6f01dca84a3e626414a24
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date0000-00-00
 monthly_invoice_end_date0000-00-00
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionJ. Rockcliff Realtors is the exclusive representative for Leverage Global Partners in Walnut Creek, Concord, Pleasant Hill, Martinez, Alamo, Diablo and Clayton, California. J. Rockcliff Realtors is one of the fastest growing real estate companies in California and has distinguished itself as The East Bay’s Premier Real Estate Company. With offices located in <a href="../../../brokerage-detail/55/J.-Rockcliff-Realtors">LaMorinda</a> (Lafayette, Moraga, Orinda), <a href="../../../brokerage-detail/56/J.-Rockcliff-Realtors">Walnut Creek</a>, <a href="../../../brokerage-detail/58/J.-Rockcliff-Realtors">Danville</a>, <a href="../../../brokerage-detail/58/J.-Rockcliff-Realtors">Blackhawk</a>, and <a href="../../../brokerage-detail/57/J.-Rockcliff-Realtors">Pleasanton/Dublin/Livermore</a>, experienced Realtors can assist with your home buying or home selling needs in any real estate market. Looking for bank owned properties? We can help. J. Rockcliff Realtors’ Relocation Department provides home buying or home selling assistance around the corner or around the world. As members of Worldwide ERC (Employee Relocation Council), J. Rockcliff handles many corporate relocation moves as well. When listing or selling your home, you can rest assured that J. Rockcliff Realtors can provide the best real estate agents (Realtors) to help you buy or sell your home using the most innovative tools available, including; the finest marketing, the most advanced technology and resources unmatched by any other firm. J. Rockcliff Realtors is strategically positioned to be the company of choice now and in the future. J. Rockcliff Realtors is proudly licensed with the California Bureau of Real Estate - License #01793729. J.Rockcliff also has offices in <a href="../../../brokerage-detail/55/J.-Rockcliff-Realtors">Lafayette</a>, <a href="../../../brokerage-detail/58/J.-Rockcliff-Realtors">Danville</a>, and <a href="../../../brokerage-detail/57/J.-Rockcliff-Realtors">Pleasanton</a>.
 communitiesWalnut Creek Concord Pleasant Hill Martinez Clayton Alamo Diablo
 websitehttp://www.rockcliff.com/
 address1700 N. Main Street
 address_2
 cityWalnut Creek
 stateCA
 full_stateCalifornia
 countryUSA
 marketWalnut Creek
 market_2
 postal_code94596
 phone(925) 280-8500
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameJeff Sposito
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titlePresident
 contact_dre_num
 contact_quote
 contact_emailjsposito@rockcliff.com
 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_filename56.jpg
 logo_filename56.jpg
 contact_image_filename56.jpg
 all_properties_link_image_filename56.jpg
 all_properties_linkhttp://www.rockcliff.com/Rockcliff-Listings#g=2a4505b8-af60-49e2-b0c4-b980136a5da0
 video_embed_code
 contact_video_embed_code
 meta_titleWalnut Creek Real Estate | J. Rockcliff Realtors | Leverage Global Partners
 meta_descriptionJ. Rockcliff Realtors is the exclusive representative for Leverage Global Partners in Walnut Creek, CA, USA.
 meta_keywordsJ. Rockcliff Realtors, Walnut Creek Real Estate, Leverage Global Partners, Jeff Sposito
 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)
 created2013-09-26 14:52:34
 modified2016-04-08 16:33:30
 dre_num012345
 uri/brokerage-detail/56/j-rockcliff-realtors
 website_shortwww.rockcliff.com
 name_with_locationJ. Rockcliff Realtors
 Image(array)
 id3384
 modelLocation
 model_id121
 tagImage
 namewalnut creek.jpg
 typeimage/jpeg
 size159277
 uri/assets/3384.jpg
 order0
 created2016-04-05 17:58:38
 modified2016-04-14 14:56:55
 2(array)
 Location(array)
 id24
 parent_id7
 brokerage_id166
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameUpper Cape Cod, MA, USA
 short_nameUpper Cape Cod, MA, USA
 group_index
 latitude41.896446
 longitude-70.552040
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_description
 long_descriptionMore information coming soon!
 created2016-04-04 11:21:07
 modified2016-04-04 11:21:07
 timezoneAmerica/New_York
 population0
 uri/locations/view/24/upper-cape-cod-ma-usa
 tile_nameUpper Cape Cod, MA, USA
 Brokerage(array)
 id166
 account_executive_id235
 archived(false)
 typebrokerage
 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
 WOEID23511751
 timezoneUS/Eastern
 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
 nameReal Estate Associates
 broker_of_record_name
 short_nameReal Estate Associates
 usernameRealEstateAssociates
 password348ba8892d60aa5fae48db2e4569b307d30c88c6
 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
 descriptionReal Estate Associates is the exclusive representative for Leverage Global Partners on the Upper Cape, Cape Cod; Bourne and the villages of Pocasset, Cataumet, Monument Beach, Bourne, Gray Gables, Buzzards Bay, Bournedale, Sagamore, Sagamore Beach, Sagamore Highlands. Mashpee and the villages of New Seabury, South Mashpee, Popponesset. Falmouth and the villages of Megansett, Silver Beach, North Falmouth, Hatchville, Falmouth, East Falmouth, West Falmouth, Waquoit, Sippewissett, Quissett, Woods Hole, Falmouth Heights, Maravista, Teaticket, Davisville, Massachusetts, USA. Real Estate Associates of Cape Cod is the Upper Cape's premier real estate agency for the high-end buyer. Proudly listing fine waterfront homes and estates in the towns of Falmouth, Bourne, and Mashpee, Real Estate Associates has a 40 year tradition of excellence representing buyers and sellers. Employing only the leading experts in the Cape Cod lifestyle, our agents match discerning homebuyers with the right home in the right neighborhood at the right price. Whether your buyer is looking for a deep water dock to pursue their boating passion, or quiet home overlooking a private beach and blazing sunsets, we have the home for your buyer and the knowledge to ensure a smooth sale. For those seeking to build their dream home, our agents can help them navigate the Cape's construction processes, even from a distance. With our combination of knowledgable agents, expert marketing techniques and investments in the latest real estate technology, Real Estate Associates provides the highest level of service imaginable.
 communitiesUpper Cape Cod Bourne Pocasset Cataumet Monument Beach Bourne Gray Gables Buzzards Bay Bournedale Sagamore Sagamore Beach Sagamore Highlands Mashpee New Seabury South Mashpee Popponesset Falmouth Megansett Silver Beach North Falmouth Hatchville Falmouth East Falmouth West Falmouth Waquoit Sippewissett Quissett Woods Hole Falmouth Heights Maravista Teaticket Davisville
 websitehttp://www.capecodhouses.com/
 address563 N. Falmouth Highway
 address_2
 cityNorth Falmouth
 stateMA
 full_stateMassachusetts
 countryUSA
 marketUpper Cape Cod
 market_2
 postal_code02556
 phoneOffice: (508) 563-7173
 phone_2Cell: (508) 264-1952
 phone_3
 wide_contact_image(false)
 contact_nameLynette Helms
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/leverage-lifestyle/meet-real-estate-associates/
 contact_big_profile_link_textMeet Real Estate Associates
 contact_titleCEO
 contact_dre_num
 contact_quote
 contact_emaillhelms@capecodhouses.com
 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_filename166.jpg
 logo_filename166.jpg
 contact_image_filename166.jpg
 all_properties_link_image_filename166.jpg
 all_properties_linkhttp://www.capecodhouses.com/app/snapshot/terabitzShare.php?key=VjMEYVEyWDVWYw==
 video_embed_code
 contact_video_embed_code
 meta_titleUpper Cape Cod Real Estate⎜Real Estate Associates⎜Leverage Global Partners
 meta_descriptionReal Estate Associates is the exclusive representative for Leverage Global Partners in Upper Cape Cod, MA, USA
 meta_keywordsReal Estate Associates, Upper Cape Cod Real Estate, Lynette Helms, Upper Cape Cod Real Estate, Bourne Real Estate, Pocasset Real Estate, Cataumet Real Estate, Monument Beach Real Estate, Bourne Real Estate, Gray Gables Real Estate, Buzzards Bay Real Estate, Bournedale Real Estate, Sagamore Real Estate, Sagamore Beach Real Estate, Sagamore Highlands Real Estate, Mashpee Real Estate, New Seabury Real Estate, South Mashpee Real Estate, Popponesset Real Estate, Falmouth Real Estate, Megansett Real Estate, Silver Beach Real Estate, North Falmouth Real Estate, Hatchville Real Estate, Falmouth Real Estate, East Falmouth Real Estate, West Falmouth Real Estate, Waquoit Real Estate, Sippewissett Real Estate, Quissett Real Estate, Woods Hole Real Estate, Falmouth Heights Real Estate, Maravista Real Estate, Teaticket Real Estate, Davisville Real Estate, Massachusetts, Leverage Global Partners
 login_message_counter3
 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-10-03 09:21:53
 modified2016-04-08 16:34:15
 dre_num012345
 uri/brokerage-detail/166/real-estate-associates
 website_shortwww.capecodhouses.com
 name_with_locationReal Estate Associates
 Image(array)
 id2951
 modelLocation
 model_id24
 tagImage
 nameUpper Cape Cod.jpg
 typeimage/jpeg
 size178475
 uri/assets/2951.jpg
 order0
 created2016-04-04 11:19:04
 modified2016-04-04 11:21:07
 3(array)
 Location(array)
 id154
 parent_id7
 brokerage_id16
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameNew York, NY, USA
 short_nameNew York, NY, USA
 group_index
 latitude40.712784
 longitude-74.005943
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_description
 long_descriptionMore information coming soon!
 created2016-04-12 15:32:31
 modified2016-04-12 15:35:21
 timezoneAmerica/New_York
 population8400000
 uri/locations/view/154/new-york-ny-usa
 tile_nameNew York, NY, USA
 Brokerage(array)
 id16
 account_executive_id235
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties20
 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_id1
 WOEID12589342
 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
 nameCORE
 broker_of_record_name
 short_nameCORE
 usernameCORENYC
 password6bbc31e8f00594b7e3433f0a9c0cd7334bff73ae
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date0000-00-00
 monthly_invoice_end_date0000-00-00
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionCORE is the exclusive representative for Leverage Global Partners in New York City, New York, USA. CORE is the leading, full-service, boutique real estate brokerage specializing in the marketing of premiere residential properties. Headquartered in New York City, CORE was founded by CEO Shaun Osher and Jack Cayre, who envisioned a dynamic boutique brokerage based on integrity, informed by expertise and driven by innovation. CORE offers comprehensive real estate solutions for buyers, sellers, landlords, investors and developers. The firm is powered by an integrated team of accomplished professionals with extensive expertise in all aspects of real estate transactions. Thanks to a unique marketing approach, CORE ensures that its clients earn the highest market-driven prices. Our agents educate and shepherd buyers, sellers and landlords through the sales or leasing process. And we partner closely with developers, from the earliest stages of a project through closing; partnerships, which boast a proven, profitable track record. Within the past 8 years, CORE has marketed more than 30 new development properties and is the #1 brokerage in its class.
 communitiesManhattan Chelsea New York City Tribeca Midtown
 websitehttp://corenyc.com/
 address104 Fifth Avenue
 address_2
 cityNew York
 stateNY
 full_stateNew York
 countryUSA
 marketNew York
 market_2
 postal_code10011
 phone(212) 726-0778
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameShaun Osher
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/blog/meet-shaun-osher-founder-and-ceo-of-core/
 contact_big_profile_link_text
 contact_titleFounder and CEO
 contact_dre_num
 contact_quoteI invite you to contact me personally about New York City real estate.
 contact_emailsosher@corenyc.com
 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_filename16.jpg
 logo_filename16.jpg
 contact_image_filename16.jpg
 all_properties_link_image_filename16.jpg
 all_properties_linkhttp://corenyc.com/listings
 video_embed_code<script type="text/javascript" src="http://videocontent.jloop.com/players/cxxGtpBt-qzxAOUo0.js"></script>
 contact_video_embed_code
 meta_titleNew York City Real Estate | CORE | Leverage Global Partners
 meta_descriptionCORE is Leverage Global Partners' exclusive representative in New York City, NY, USA.
 meta_keywordsnew york city real estate, manhattan real estate, shaun osher, CORE, 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)
 created2013-04-01 15:35:47
 modified2019-10-29 20:06:57
 dre_num012345
 uri/brokerage-detail/16/core
 website_shortcorenyc.com
 name_with_locationCORE
 Image(array)
 id20711
 modelLocation
 model_id154
 tagImage
 nameScreen Shot 2016-04-12 at 3.34.19 PM.png
 typeimage/png
 size660485
 uri/assets/20711.png
 order0
 created2016-04-12 15:35:16
 modified2016-04-12 15:35:21
- sidebar_articles(array)
 0(array)
 Article(array)
 id481
 modelArticle
 model_id0
 archived(false)
 medium_featured(true)
 large_featured(true)
 titleCelebrity Spotlight: Meridith Baer
 authorLeverageRE
 date2016-03-29
 lead_inA creative storage solution for her plants was all Meridith Baer was looking for when she undertook her first home staging project. The former screenwriter and star of HGTV's Staged to Perfection had 250 potted plants in her rental home in Los Angeles when the landlord said he was ready to sell the property. So she called a friend and convinced him to let her bring the plants and a few pieces of her furniture into the vacant home he was trying to sell. And just like that, it sold- in a bidding war, no less. Now, when celebrities are ready to sell their homes for top dollar, they call Baer.
 body<img class="aligncenter wp-image-12988 pure-img" src="/assets/3312.png" /> As founder and CEO of Meridith Baer Home (MBH), she blends luxury with a refined sensibility to help sell homes for top dollar. With a celebrity clientele including Beyoncé, Brad Pitt, and Elon Musk (just to name a few), Baer is now expanding the MBH brand to include a San Francisco office and her own furniture line. <img class="aligncenter wp-image-12985 pure-img" src="/assets/3313.png" /> <h4>How has your vision of the MBH brand expanded from when you first started?</h4> In the beginning I decorated homes for people to help them get top dollar. I did it because it was fun. I never believed I would have a business doing this, let alone a brand. Now we've expanded into seven cities and even staged internationally. <h4>At what point did you realized the growth potential (and your potential) in the staging business?</h4> After about six months, my phone started ringing off the hook and I started to hire anyone I bumped into that could speak full sentences or had the brawn to lift heavy furniture. <img class="aligncenter wp-image-12984 pure-img" src="/assets/3314.png" /> <h4>What are some of your current projects to diversify within the industry? </h4> Currently we have over 500 homes installed in Southern California, Northern California, Florida, Manhattan, the Hamptons, and Connecticut. We are installing about 400 projects a quarter. Besides staging, we are working on everything from resort condominiums in Cabo, to hotels, luxury rental furnishings for clients to live with (not staging), multi-million-dollar interior design projects, furniture, and accessory manufacturing. We are working on charity projects to give back in 2015. <img class="aligncenter wp-image-12982 pure-img" src="/assets/3315.png" /> <h4>What goes into developing a furniture line? How did you identify that need in the market? </h4> We got into manufacturing because we couldn't find all of the new and exciting pieces we were looking for. Joe Asher and Heide Zeiker from our company said, "Let's just make them ourselves!" We aim to keep our look basic but fresh and exciting by staying ahead of the trends and introducing unique new pieces. We get our inspiration from history, our travels, and everything we see and do. <h4>Where do you see MBH in the next five years? </h4> Given the brilliant and talented group we have become, I don't know where we will end up in the next five years. Mars? I am certain Martians want to live beautifully, too. Kidding aside, I believe we will expand to other key cities, including Houston, Washington, D.C., Atlanta, Las Vegas, and resort communities like Aspen and Sun Valley. Maybe even London and Paris. I'd also like to see our manufacturing double or triple, since designing the furniture line has been a highlight of mine this year. <img class="aligncenter wp-image-12986 pure-img" src="/assets/3316.png" /> <h4>What are you excited about right now outside of business? </h4> Life outside of business . . . what's that? I have not had much of a personal life in the last 18 years, and would love to do something about that. As always, I am excited by design and designers all over the world. Everyone in our group wants to find ways to give back to the communities we work in. We are currently working with this amazing charity, A Sense of Home, that I'm thrilled about. Their organization changes the lives of foster youth who've "aged out" of the foster care system by creating homes for them. Using furniture and housewares from our collection, we're working with their team of volunteers to help these youth start their life with a place to call home and help them achieve self-sufficiency. It's been a heartwarming and uplifting experience. <img class="aligncenter wp-image-12981 pure-img" src="/assets/3317.png" /> <h2>TIPS FROM MERIDITH</h2> My philosophy is, start with a very quiet palette and bring the personality and color onto that palette, as if the furniture were a blank canvas. What brings the luxury to the room are things like rugs, cashmere throws, and beautiful décor pillows. To [make it feel lived in], we have little vignettes around the home that show where the kids would probably play, where you put your glasses beside the bed, a cookbook open in the kitchen, hints of clothing in the closet, and tons of fluffy white towels in the bathroom-different things that are attractive, but still tell the story. When it comes to staging a home, the key is showing prospective buyers the ideal lifestyle that they can have in the space. We sort of make it easy for them. We really show them what their home could look like if they buy it. <img class="aligncenter wp-image-12987 pure-img" src="/assets/3318.png" /> <h6>Photos courtesy of <a href="http://meridithbaer.com/" target="_blank">Meridith Baer Home</a></h6>
 vimeo_id
 created2016-04-05 14:35:01
 modified2016-04-11 16:56:53
 uri/articles/view/481/celebrity-spotlight-meridith-baer
 Image(array)
 0(array)
 id3319
 modelArticle
 model_id481
 tagImage
 nameScreen-Shot-2016-03-29-at-1.54.46-PM.png
 typeimage/png
 size1184066
 uri/assets/3319.png
 order0
 created2016-04-05 14:35:04
 modified2016-04-11 16:56:53
 1(array)
 Article(array)
 id455
 modelLocation
 model_id114
 archived(false)
 medium_featured(true)
 large_featured(true)
 titleLocation: Hawaii
 authorLeverageRE
 date2016-03-23
 lead_inThe country's youngest state (which joined the Union only in 1959) is something of an anomaly. It's the only one of the United States with a tropical rain forest and a royal palace, but it's also the only state that is made up entirely of islands-eight of them: Niihau, Kauai, Oahu, Maui, Molokai, Lanai, Kahoolawe, and the Big Island. Leverage Partners Mauna Kea Realty (Big Island), The Wailea Group (Maui), and East Oahu Realty (Oahu) can attest that each island has its own unique characteristics. But needless to say, wherever you are, you'll find an airy, summertime vibe year-round, with plenty of flower leis, luaus, and beach scenes.
 bodyEach of the Hawaiian islands has a distinct cultural relevance. The Big Island, for instance, which is as big as all the others combined, encompasses about 4,000 square miles. It's a trove of hidden beaches, volcanic national parks, rain forests, otherworldly waterfalls, and lush vegetation. <img class="aligncenter wp-image-12718 pure-img" src="/assets/3150.png" /> On Oahu, you'll find markers of both American history-Pearl Harbor, the USS Arizona Memorial-and Hawaiian history-the Iolani Palace and the Byodo-In Temple. It's also the location of the capital city, Honolulu, which is the biggest city in Hawaii. The island of Maui boasts pristine beaches and shimmering shores, but it also is home to the Road to Hana, one of the most traveled trails in the state. Here, we explore destinations on the three islands in greater depth and share all the places to get out and enjoy before you say, "Aloha." Located on Waikiki Beach, <a href="http://www.halekulani.com/" target="_blank">Halekulani</a> welcomes travelers to an oasis of sophisticated luxury, and is recognized as one of the world's finest and most acclaimed independent luxury hotels since its inception in 1984. <img class="aligncenter size-full wp-image-12711 pure-img" src="/assets/3151.png" /> Chef Peter Merriman had a vision for the growth of local agriculture and the potential of Hawaii's rich volcanic soils. He, along with twelve other prominent chefs, encouraged farmers to grow local fruits and vegetables, raise meats locally, and start a healthier more sustainable Hawaii. Showcasing locally sourced menus of fresh line caught fish, grass fed meats, and Hawaii grown produce, the authentic flavors of Hawaii await at <a href="https://www.merrimanshawaii.com/fish-house/" target="_blank">Merriman's</a>. <img class="aligncenter wp-image-12710 pure-img" src="/assets/3152.png" /> <h3>ZIPLINE AT UMAUMA FALLS</h3> Catch the view from the top on this outdoor adventure, which boasts two miles of ziplines and family-friendly fun. <img class="aligncenter wp-image-12709 pure-img" src="/assets/3153.png" /> <h3>DOLPHIN SNORKEL SWIM, KAILUA-KONA</h3> Swim with the dolphins in Hawaii's crystal-clear waters. The same company also offers whale watching. <img class="aligncenter wp-image-12712 pure-img" src="/assets/3154.png" /> <h3>WAIPIO VALLEY</h3> The waterfalls in Waipio Valley, on the Big Island, are some of the most exquisite in the state. For a rustic adventure, see them from horseback. <img class="aligncenter wp-image-12719 pure-img" src="/assets/3155.png" /> <h3>DIAMOND HEAD</h3> This crater was created by a giant eruption 300,000 years ago. Today, it's a landmark on Oahu, and a hiking trail (0.8 mile) winds through it. <img class="aligncenter wp-image-12716 pure-img" src="/assets/3156.png" /> <h3>HANAUMA BAY</h3> When you imagine waters so blue that they'd be perfect for a postcard, this is the image that comes to mind. Sign up to snorkel to see angelfish, butterflyfish, and yellow tangs galore. <img class="aligncenter wp-image-12714 pure-img" src="/assets/3157.png" /> <h3>THE HIGHWAY HANA</h3> Wind through approximately 600 curves on this Maui road to see the lush green countryside. <img class="aligncenter wp-image-12708 pure-img" src="/assets/3158.png" /> <h3>SNORKELING AT MOLOKINI</h3> Swim with the turtles and fish at this Maui gem. For those who like to stay a bit drier, the yacht that takes you out is the perfect place to get a tan. <img class="aligncenter wp-image-12715 pure-img" src="/assets/3159.png" />
 vimeo_id
 created2016-04-05 14:30:50
 modified2016-04-08 09:46:02
 uri/articles/view/455/location-hawaii
 Image(array)
 0(array)
 id3160
 modelArticle
 model_id455
 tagImage
 nameScreen-Shot-2016-03-23-at-3.51.26-PM.png
 typeimage/png
 size2749979
 uri/assets/3160.png
 order0
 created2016-04-05 14:30:54
 modified2016-04-08 09:46:03
 2(array)
 Article(array)
 id497
 modelArticle
 model_id0
 archived(false)
 medium_featured(false)
 large_featured(false)
 titleWebinar Recap // Instagram 2.0: Marketing Worth a Thousand Words
 authorLeverageRE
 date2016-02-25
 lead_inLeverage Global Partners and social media expert Katie Lance recently teamed up for the February 2016 event of our webinar series. In this installment, Instagram 2.0, Marketing Worth a Thousand Words, Katie discussed how real estate professionals can utilize Instagram to enhance their overall marketing and branding strategy.
 body <img class="aligncenter wp-image-12203 pure-img" src="/assets/22795.png" alt="Screen Shot 2016-02-25 at 2.19.39 PM" width="703" height="504" sizes="(max-width: 703px) 100vw, 703px">Instagram in the News: In a recent user survey, 60% of respondents said they learn about products and services on Instagram, and 75% said they take action after seeing by an Instagram post. The Nuts and Bolts of Instagram <ul> <li>Photo editing app and a social network</li> <li>Upload, edit and interact 100% using your mobile device</li> <li>Having an updated profile photo and bio are key</li> </ul> 7 Steps to getting started with Instagram <ol> <li>Download the app</li> <li>Create your account</li> <li>Add a profile photo</li> <li>Add your bio and website link</li> <li>Post 5-10 photos</li> <li>Connect with Facebook friends and/or your phone contacts to begin following people.</li> <li>Search to see if your current or recent past clients are on Instagram. Follow, like and comment on any recent photos</li> </ol> <img class="aligncenter wp-image-12210 pure-img" src="/assets/22796.png" alt="Screen Shot 2016-02-25 at 3.23.20 PM" width="658" height="445" sizes="(max-width: 658px) 100vw, 658px"> Hashtag Your way to success! <ul> <li>Search in Instagram what category you are trying to target</li> <li>What hashtags would our clients (not Realtors) use?</li> </ul> How to increase engagement… <ul> <li>Tag, tag,tag – but do so strategically</li> <li>Ask people to tag their friends – bring them into the conversation</li> </ul> Pro tip #1 <ul> <li>Put your phone in Airplane mode to take pictures and filter</li> <li>They will save to your phone not Instagram</li> </ul> Pro tip #2 <ul> <li>You can post from Instagram to Facebook OR you can post to Instagram and then wait to post to FB</li> <li>Benefit – when you wait you can change the caption!</li> </ul> Pro tip #3 <ul> <li>Create Instagram ads using Facebook’s Ad Manager</li> <li>Facebook.com/ads</li> </ul> Do’s and Don’ts <ul> <li>Don’t convert your flyer to a JPEG and then put it on Instagram (hard to read!). <ul> <li> Do create 3-5 graphics that highlight the features of a listing with links back to the property website</li> </ul> </li> <li>Don’t syndicate the same photo and content everywhere <ul> <li>Do get creative and re-purpose your content</li> </ul> </li> <li>Don’t just post front of the house photo <ul> <li>Do think beyond the listing photo</li> </ul> </li> </ul> <div> <div dir="ltr"> For all of the great takeaways, view the full webinar video below! </div> </div> <h3 style="text-align: center;"><a href="http://www.leveragere.com/videos/O3Gsqp2j" target="_blank">WATCH THE WEBINAR VIDEO // Instagram 2.o</a></h3> <a href="http://www.leveragere.com/videos/O3Gsqp2j" target="_blank"><img class="aligncenter wp-image-12216 pure-img" src="/assets/22797.jpg" alt="Instagram 2.0 thumb" width="594" height="346" sizes="(max-width: 594px) 100vw, 594px"></a> <div id="main" class="clearfix"> <article id="post-10962" class="clearfix post-10962 post type-post status-publish format-standard has-post-thumbnail hentry category-broadcast-news"><section class="entry-content clearfix"><h3 style="text-align: center;">Ready to get your Instagram strategy in check? Download Katie Lance's <a href="http://getsocialsmart.com/instaguide" target="_blank">Instaguide to Instagram for Real Estate</a>!</h3> </section></article> </div> <a href="http://getsocialsmart.com/instaguide" target="_blank"><img class="aligncenter wp-image-12212 pure-img" src="/assets/22798.png" alt="Screen Shot 2016-02-25 at 3.25.33 PM" width="691" height="455" sizes="(max-width: 691px) 100vw, 691px"></a>
 vimeo_id
 created2016-05-18 16:28:33
 modified2016-05-18 16:29:48
 uri/articles/view/497/webinar-recap-instagram-2-0-marketing-worth-a-thousand-words
 Image(array)
 0(array)
 id22799
 modelArticle
 model_id497
 tagImage
 nameKatie-Lance-Feb-2016-copy.jpg
 typeimage/jpg
 size63849
 uri/assets/22799.jpg
 order0
 created2016-05-18 16:28:34
 modified2016-05-18 16:28:34
 3(array)
 Article(array)
 id453
 modelArticle
 model_id0
 archived(false)
 medium_featured(false)
 large_featured(false)
 titleShop The Store: Holly Hunt
 authorLeverageRE
 date2016-03-24
 lead_inSince its opening in 1984 in Chicago's Merchandise Mart, Holly Hunt has been delivering well-crafted, modern-designed furniture for every room of the home. In the 30 years since, the company has expanded to showrooms in 26 locations, including New York, Los Angeles, and even London and São Paolo. In addition to offering their own designs, the showroom offers pieces from established designers such as Christian Astuguevielle as well as newcomers like lighting designer Alison Berger and furniture designer Paul Mathieu. For statement lighting, eye- catching tables, or a timeless sofa, Holly Hunt is sure to please, no matter the style or aesthetic of a home.
 body<a href="https://www.hollyhunt.com/ShowProduct.aspx?ProductID=8573&ManufacturerID=33" target="_blank">Sea Urchin Pendant</a> Designer Stefan Gulassa created this pendant light, whose LED lights shine through bubble-inflected glass to create a unique glow. $5,580 <img class="aligncenter wp-image-12742 pure-img" src="/assets/3139.png" /> <a href="https://www.hollyhunt.com/ShowProduct.aspx?ProductID=4940&ManufacturerID=24" target="_blank">Reve Occasional Chair</a> Low-slung and with a generous width, this chair takes cues from Hollywood Regency pieces, but updates them with a slim silhouette. $7,800 <img class="aligncenter wp-image-12743 pure-img" src="/assets/3140.png" /> <a href="https://www.hollyhunt.com/ShowProduct.aspx?ProductID=4748&ManufacturerID=1" target="_blank">São Paolo Sofa</a> The perfect transitional-style sectional, the piece is available in a range of fabrics, from linen to leather. $12,600 as shown <img class="aligncenter size-full wp-image-12746 pure-img" src="/assets/3141.png" /> <a href="https://www.hollyhunt.com/ShowProduct.aspx?ProductID=8559&ManufacturerID=1" target="_blank">Fortis Bed</a> A fabric- wrapped base and headboard combine with a wooden back and matching wing panels in this sleek bed. $17,520 <img class="aligncenter wp-image-12745 pure-img" src="/assets/3142.png" /> <a href="https://www.hollyhunt.com/" target="_blank">Convex Mirror</a> Part wall art, part functional mirror, this piece offers a Mondrian-like wooden frame around a convex mirror to add intrigue to any wall. $5,470 <img class="aligncenter wp-image-12744 pure-img" src="/assets/3143.png" />
 vimeo_id
 created2016-04-05 14:30:48
 modified2016-04-08 09:43:54
 uri/articles/view/453/shop-the-store-holly-hunt
 Image(array)
 0(array)
 id3144
 modelArticle
 model_id453
 tagImage
 nameHolly-Hunt.jpg
 typeimage/jpg
 size2187512
 uri/assets/3144.jpg
 order0
 created2016-04-05 14:30:49
 modified2016-04-08 09:43:54
- main_article(empty)
- locations(array)
 0(array)
 Location(array)
 id22
 parent_id9
 brokerage_id198
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameMadison, WI, USA
 short_nameMadison, WI, USA
 group_index
 latitude43.083321
 longitude-89.372475
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_descriptionMadison is on all the "best of" lists for a reason - it's a great place to live!
 long_descriptionSitting proudly on an isthmus, surrounded by the natural beauty of our many lakes and parks and home to a world-class university and the state capitol, Madison is a city rich in culture and pride. Continuously voted "best city" to live, bike, eat and learn in, as well as to be old in, to be young in, to be green in, to retire to, and voted best for high tech, arts, working women, young entrepreneurs, etc., it's also one of the happiest places in the US thanks to low unemployment, good schools and hospitals and beautiful neighborhoods with both historic and modern homes.
 created2016-04-04 11:09:32
 modified2016-04-18 10:38:23
 timezoneAmerica/North_Dakota/Center
 population600000
 uri/locations/view/22/madison-wi-usa
 tile_nameMadison, WI, USA
 Brokerage(array)
 id198
 account_executive_id0
 archived(false)
 typebrokerage
 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
 WOEID2443945
 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
 nameSprinkman Real Estate
 broker_of_record_name
 short_nameSprinkman Real Estate
 usernameSprinkmanRealEstate
 passwordf7266c125872511535dd9cac23b479b8e938602f
 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
 descriptionSprinkman Real Estate is the exclusive representative for Leverage Global Partners in all of Dane County including Madison, Maple Bluff, Shorewood Hills, Middleton and surrounding communities. Sprinkman Real Estate is an independent boutique brokerage in Madison, Wisconsin. With over 20 years of experience in the Madison market, the team includes top-producing agents who know and love Madison and it’s many unique neighborhoods and surrounding communities ranging from urban, walkable, downtown areas to lake properties to unique rural properties. Our agents listen intently to their clients’ needs and expertly guide them to the neighborhood and home that perfectly suits their lifestyle. Our exclusive support team includes an experienced, professional stager who offers comprehensive staging services and complementary post-move in interior design consultations, a photographer who specializes in architectural photography, a marketing staff that is attuned to cutting-edge resources and a transaction manager to cross all the i’s and dot all the t’s. We bring together our unique talents and years of expertise, as well as our individual strengths and passions, in order to expertly guide you through the process all the while providing extraordinary, highly personalized service and a paperless process using customized technology.
 communitiesDane county Madison Maple Bluff Dun Shorewood Hills Springfield Westport
 websitehttp://sprinkmanrealestate.com/
 address613 Williamson Street
 address_2Suite 202
 cityMadison
 stateWI
 full_stateWisconsin
 countryUSA
 market
 market_2
 postal_code53703
 phoneShelly: (608) 220-1453
 phone_2Julie: (608) 219-6492
 phone_3
 wide_contact_image(true)
 contact_nameShelly Sprinkman, Julie Bernauer
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleBroker/Owner, Broker
 contact_dre_num
 contact_quote
 contact_emailshelly@sprinkmanrealestate.com
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2Julie@sprinkmanrealestate.com
 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_filename198.jpg
 logo_filename198.
 contact_image_filename198.jpg
 all_properties_link_image_filename198.jpg
 all_properties_linkhttp://sprinkmanrealestate.com/featured-listings
 video_embed_code
 contact_video_embed_code
 meta_titleMadison Real Estate | Sprinkman Real Estate | Leverage Global Partners
 meta_descriptionSprinkman Real Estate is the exclusive representative for Leverage Global Partners in all of Dane county including Madison, Maple Bluff, Dun, Shorewood Hills, Springfield, and Westport, WI.
 meta_keywordsSprinkman Real Estate, Leverage Global Partners, Dane county Real Estate, Madison Real Estate, Maple Bluff Real Estate, Dun Real Estate, Shorewood Hills Real Estate, Springfield Real Estate, Westport Real Estate, Wisconsin Real Estate, Shelly Sprinkman
 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-03-20 14:25:30
 modified2016-04-18 13:13:12
 dre_num012345
 uri/brokerage-detail/198/sprinkman-real-estate
 website_shortsprinkmanrealestate.com
 name_with_locationSprinkman Real Estate
 Image(array)
 id2949
 modelLocation
 model_id22
 tagImage
 namesprinkman real estate.jpg
 typeimage/jpeg
 size81584
 uri/assets/2949.jpg
 order0
 created2016-04-04 11:09:26
 modified2016-04-18 10:38:23
- stats_modules(array)
 None
 agentsagents ready to help
 years_in_serviceyears in service
 office_locationsoffice locations
 markets_servedmarkets served
 listingsproperties listed
- custom_ga_event_properties(array)
 brokerageSprinkman Real Estate, Madison
- brokerage(array)
 Brokerage(array)
 id198
 account_executive_id0
 archived(false)
 typebrokerage
 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
 WOEID2443945
 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
 nameSprinkman Real Estate
 broker_of_record_name
 short_nameSprinkman Real Estate
 usernameSprinkmanRealEstate
 passwordf7266c125872511535dd9cac23b479b8e938602f
 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
 descriptionSprinkman Real Estate is the exclusive representative for Leverage Global Partners in all of Dane County including Madison, Maple Bluff, Shorewood Hills, Middleton and surrounding communities. Sprinkman Real Estate is an independent boutique brokerage in Madison, Wisconsin. With over 20 years of experience in the Madison market, the team includes top-producing agents who know and love Madison and it’s many unique neighborhoods and surrounding communities ranging from urban, walkable, downtown areas to lake properties to unique rural properties. Our agents listen intently to their clients’ needs and expertly guide them to the neighborhood and home that perfectly suits their lifestyle. Our exclusive support team includes an experienced, professional stager who offers comprehensive staging services and complementary post-move in interior design consultations, a photographer who specializes in architectural photography, a marketing staff that is attuned to cutting-edge resources and a transaction manager to cross all the i’s and dot all the t’s. We bring together our unique talents and years of expertise, as well as our individual strengths and passions, in order to expertly guide you through the process all the while providing extraordinary, highly personalized service and a paperless process using customized technology.
 communitiesDane county Madison Maple Bluff Dun Shorewood Hills Springfield Westport
 websitehttp://sprinkmanrealestate.com/
 address613 Williamson Street
 address_2Suite 202
 cityMadison
 stateWI
 full_stateWisconsin
 countryUSA
 market
 market_2
 postal_code53703
 phoneShelly: (608) 220-1453
 phone_2Julie: (608) 219-6492
 phone_3
 wide_contact_image(true)
 contact_nameShelly Sprinkman, Julie Bernauer
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleBroker/Owner, Broker
 contact_dre_num
 contact_quote
 contact_emailshelly@sprinkmanrealestate.com
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2Julie@sprinkmanrealestate.com
 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_filename198.jpg
 logo_filename198.
 contact_image_filename198.jpg
 all_properties_link_image_filename198.jpg
 all_properties_linkhttp://sprinkmanrealestate.com/featured-listings
 video_embed_code
 contact_video_embed_code
 meta_titleMadison Real Estate | Sprinkman Real Estate | Leverage Global Partners
 meta_descriptionSprinkman Real Estate is the exclusive representative for Leverage Global Partners in all of Dane county including Madison, Maple Bluff, Dun, Shorewood Hills, Springfield, and Westport, WI.
 meta_keywordsSprinkman Real Estate, Leverage Global Partners, Dane county Real Estate, Madison Real Estate, Maple Bluff Real Estate, Dun Real Estate, Shorewood Hills Real Estate, Springfield Real Estate, Westport Real Estate, Wisconsin Real Estate, Shelly Sprinkman
 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-03-20 14:25:30
 modified2016-04-18 13:13:12
 dre_num012345
 uri/brokerage-detail/198/sprinkman-real-estate
 website_shortsprinkmanrealestate.com
 name_with_locationSprinkman Real Estate
 Logo(array)
 id2824
 modelBrokerage
 model_id198
 tagLogo
 name198.
 typeimage/
 size32988
 uri/assets/2824.
 order0
 created2016-03-30 11:44:36
 modified2016-04-18 13:13:12
 MainImage(array)
 id2823
 modelBrokerage
 model_id198
 tagMainImage
 name198.jpg
 typeimage/jpg
 size114342
 uri/assets/2823.jpg
 order0
 created2016-03-30 11:44:36
 modified2016-04-18 13:13:12
 ContactImage(array)
 id21029
 modelBrokerage
 model_id198
 tagContactImage
 namecombined sprinkman headshots.jpg
 typeimage/jpeg
 size809390
 uri/assets/21029.jpg
 order0
 created2016-04-18 13:13:09
 modified2016-04-18 13:13:12
 ContactImage2(array)
 id(null)
 model(null)
 model_id(null)
 tag(null)
 name(null)
 type(null)
 size(null)
 uri(null)
 order(null)
 created(null)
 modified(null)
 ContactImage3(array)
 id(null)
 model(null)
 model_id(null)
 tag(null)
 name(null)
 type(null)
 size(null)
 uri(null)
 order(null)
 created(null)
 modified(null)
 BrokerOfRecordLogo(array)
 id(null)
 model(null)
 model_id(null)
 tag(null)
 name(null)
 type(null)
 size(null)
 uri(null)
 order(null)
 created(null)
 modified(null)
 FeaturedImage(empty)
- 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)
 Logo(empty)
 BrokerOfRecordLogo(empty)
 MainImage(empty)
 FeaturedImage(empty)
 ContactImage(empty)
 ContactImage2(empty)
 ContactImage3(empty)
 Location(empty)
 Image(empty)
 Article(empty)
 Property(empty)
 User(empty)
 PropertyFeature(empty)
 SecondaryPropertyCategory(empty)
 Topic(empty)
 ParentBrokerage(empty)
 ParentLocation(empty)
 ArticlesBrokerage(empty)
 ArticlesLocation(empty)
 ArticlesProperty(empty)
 ArticlesTopic(empty)
 MlsComplianceData(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	chris@jloop.com
STRIPE_ISSUES_EMAIL_RECIPIENT	chris@jloop.com
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	/brokerage-detail/198/sprinkman-real-estate
Query String
Request Method	GET
Server Protocol	HTTP/1.1
Gateway Interface	CGI/1.1
Redirect Url	/brokerage-detail/198/sprinkman-real-estate
Remote Port	19755
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	104.23.197.115
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; +claudebot@anthropic.com)
Http Accept Encoding	gzip, br
Http Accept	/
Http Cf Ray	a09d1f17eaf37089-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	aioay6gWUmgYuyi40B7wLAAAAUI
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	aioay6gWUmgYuyi40B7wLAAAAUI
Fcgi Role	RESPONDER
Php Self	/index.php
Request Time Float	1781144267.6067
Request Time	1781144267

====

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/Location.php
  5APP/Model/Article.php
  6APP/Model/Property.php
  7APP/Model/User.php
  8APP/Model/PropertyFeature.php
  9APP/Model/PropertyCategory.php
  10APP/Model/Topic.php
  11APP/Model/MlsComplianceData.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
====

Sprinkman Real Estate

Connect With Us

Sprinkman Real Estate Featured Properties

Share This

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 11 ms Total Queries: 10 queries

Query Explain:

Memory

Timers

Logs

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

Total Time: 11 ms
Total Queries: 10 queries