Properties /

7240 Clover Hill Drive, Middleton, WI

7240 Clover Hill Drive | Middleton, WI 53597, USA | $650,000

3 Beds
2 Baths
1 Half Ba
3.00 Acres
Garage
Views

Live in a work of art! This exceptional home, designed by a Taliesin architect, exists in perfect harmony with the stunning land it rests on. Following Frank Lloyd Wright’s philosophy of organic architecture, the home flows beautifully both inside and out with an openness and abundance of natural material giving it an inviting warmth in all seasons. The details of the home inspire, as well: A remodeled kitchen features top-of-the-line appliances and finishes, a stone hearth opens to the living and dining rooms and all the living spaces look out onto the serene, private landscape.

Represented By: Sprinkman Real Estate

sprinkmanrealestate.com | License #: 012345

Shelly Sprinkman
608-220-1453
Email

Main Office: 613 Williamson Street,
Suite 202
Madison, WI 53703
USA

More About Shelly

sprinkmanrealestate.com | License #: 012345

Ryan Brown
608-338-7440
Email

Main Office: 613 Williamson Street,
Suite 202
Madison, WI 53703
USA

More About Ryan

sprinkmanrealestate.com | License #: 012345

Julie Bernauer
608-219-6492
Email

Main Office: 613 Williamson Street,
Suite 202
Madison, WI 53703
USA

More About Julie

View On Map Property Website Virtual Tour

Highlighted Properties

403 Farwell Drive, Madison, WI 53704

403 Farwell Drive | Madison, WI 53704
$2,500,000

3952 Caribou Rd.

3952 Caribou Rd. | Middleton, WI 53593
$1,175,000

Represented By

Agent Contacts: Shelly Sprinkman 608-220-1453 | Email; Ryan Brown 608-338-7440 | Email; Julie Bernauer 608-219-6492 | Email

Featured Location

Madison, WI, USA

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

Related Property Listings

Property Search

Bedrooms

Baths

Minimum Price

Maximum Price

History
+
Request History
4 previous requests available
====
Session
+
Session
- Config(array)
  userAgentcc2d3fd23c5dd98eb73e42c141648c0a
  time1781167863
  countdown10
- Explore(array)
  rejected_tiles(array)
  rejected_topics(empty)
  rejected_locations(empty)
====
Request
+
Request

Cake Params
- plugin(null)
- controllerproperties
- actionview
- named(empty)
- pass(array)
  02585
  17240-clover-hill-drive-middleton-wi-53597-usa
- isAjax(false)
Post data

No post data.

Query string

No querystring data.

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

Sql Log

Sql Logs

default

Total Time: 25 ms
Total Queries: 41 queries

Query	Affected	Num. rows	Took (ms)	Actions
SELECT `Property`.`id`, `Property`.`brokerage_id`, `Property`.`created_by_user_id`, `Property`.`order`, `Property`.`multi_unit`, `Property`.`agent_1_id`, `Property`.`agent_2_id`, `Property`.`agent_3_id`, `Property`.`name`, `Property`.`incomplete`, `Property`.`archived`, `Property`.`last_archived`, `Property`.`auto_archived_from_mlsidx`, `Property`.`paid_featured`, `Property`.`featured`, `Property`.`homepage_featured`, `Property`.`brokerage_page_featured`, `Property`.`requested_homepage_featured_by_member`, `Property`.`homepage_featured_by_member`, `Property`.`dot_luxury_featured`, `Property`.`luxury_feed_featured`, `Property`.`force_luxury_feed_featured`, `Property`.`luxury_autofeed_imported`, `Property`.`luxury_feed_last_added_time`, `Property`.`luxury_feed_agent_user_id`, `Property`.`luxury_feed_locked_to_subscription_id`, `Property`.`luxury_feed_agent_purchase_date`, `Property`.`luxury_feed_agent_expiration_date`, `Property`.`digital_ad_summary_email_last_sent`, `Property`.`digital_ad_summary_price_changed`, `Property`.`wsj_detail_url`, `Property`.`ft_detail_url`, `Property`.`nyt_detail_url`, `Property`.`juwai_detail_url`, `Property`.`pgl_detail_url`, `Property`.`mg_detail_url`, `Property`.`mg_c_detail_url`, `Property`.`mg_s_detail_url`, `Property`.`bp_detail_url`, `Property`.`mw_detail_url`, `Property`.`nikkei_detail_url`, `Property`.`wapo_detail_url`, `Property`.`robb_detail_url`, `Property`.`medium_featured`, `Property`.`large_featured`, `Property`.`detail_page`, `Property`.`description`, `Property`.`address`, `Property`.`address_2`, `Property`.`city`, `Property`.`state`, `Property`.`postal_code`, `Property`.`country`, `Property`.`use_lat_lng_for_google_map`, `Property`.`currency`, `Property`.`price`, `Property`.`price_2`, `Property`.`price_usd`, `Property`.`price_usd_2`, `Property`.`status`, `Property`.`status_last_changed`, `Property`.`status_last_changed_price_only`, `Property`.`lease_period`, `Property`.`price_upon_request`, `Property`.`bedrooms`, `Property`.`bedrooms_2`, `Property`.`bathrooms`, `Property`.`bathrooms_2`, `Property`.`no_beds_baths`, `Property`.`square_feet`, `Property`.`square_meters`, `Property`.`acres`, `Property`.`interior_unit`, `Property`.`interior_size`, `Property`.`lot_unit`, `Property`.`lot_size`, `Property`.`icon_1`, `Property`.`icon_2`, `Property`.`icon_3`, `Property`.`icon_4`, `Property`.`icon_5`, `Property`.`icon_6`, `Property`.`website`, `Property`.`meta_title`, `Property`.`meta_description`, `Property`.`meta_keywords`, `Property`.`bathrooms_partial`, `Property`.`bathrooms_partial_2`, `Property`.`bathrooms_3_4`, `Property`.`bathrooms_3_4_2`, `Property`.`year_built`, `Property`.`virtual_tour`, `Property`.`video_tour`, `Property`.`digital_brochure`, `Property`.`video_tour_embed_code`, `Property`.`digital_brochure_embed_code`, `Property`.`mls_num`, `Property`.`wsj_property_type`, `Property`.`nyt_property_type`, `Property`.`nyt_popular_features`, `Property`.`propgolux_property_type`, `Property`.`juwai_property_type`, `Property`.`juwai_category`, `Property`.`propgolux_property_style`, `Property`.`wapo_property_type`, `Property`.`robb_property_type`, `Property`.`propgolux_location_id_override`, `Property`.`open_house_1_start`, `Property`.`open_house_1_end_time`, `Property`.`latitude`, `Property`.`longitude`, `Property`.`invalid_required_fields`, `Property`.`invalid_optional_fields`, `Property`.`went_live_today`, `Property`.`converted`, `Property`.`invalid`, `Property`.`mlsidx_full_address`, `Property`.`mlsidx_date_listed`, `Property`.`mls_market`, `Property`.`primary_property_category_id`, `Property`.`realstaq_initial_image_sync`, `Property`.`digital_ad_listing_urls_automated`, `Property`.`modified`, `Property`.`created`, `PrimaryPropertyCategory`.`id`, `PrimaryPropertyCategory`.`name`, `PrimaryPropertyCategory`.`created`, `PrimaryPropertyCategory`.`modified`, `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`, `StripeSubscription`.`id`, `StripeSubscription`.`brokerage_id`, `StripeSubscription`.`user_id`, `StripeSubscription`.`property_id`, `StripeSubscription`.`type`, `StripeSubscription`.`stripe_id`, `StripeSubscription`.`stripe_customer_id`, `StripeSubscription`.`stripe_checkout_email`, `StripeSubscription`.`stripe_promotion_code`, `StripeSubscription`.`stripe_promotion_code_id`, `StripeSubscription`.`stripe_coupon_code_id`, `StripeSubscription`.`status`, `StripeSubscription`.`current_period_end`, `StripeSubscription`.`cancel_at_period_end`, `StripeSubscription`.`ended`, `StripeSubscription`.`last_change`, `StripeSubscription`.`last_activity_email_sent`, `StripeSubscription`.`created`, `StripeSubscription`.`modified`, `GlobalReachReport`.`id`, `GlobalReachReport`.`property_id`, `GlobalReachReport`.`wsj_desktop`, `GlobalReachReport`.`wsj_mobile`, `GlobalReachReport`.`wsj_expires`, `GlobalReachReport`.`wsj_capture_started`, `GlobalReachReport`.`mg_desktop`, `GlobalReachReport`.`mg_mobile`, `GlobalReachReport`.`mg_expires`, `GlobalReachReport`.`mg_capture_started`, `GlobalReachReport`.`bp_desktop`, `GlobalReachReport`.`bp_mobile`, `GlobalReachReport`.`bp_expires`, `GlobalReachReport`.`gp_capture_started`, `GlobalReachReport`.`mw_desktop`, `GlobalReachReport`.`mw_mobile`, `GlobalReachReport`.`mw_expires`, `GlobalReachReport`.`mw_capture_started`, `GlobalReachReport`.`ft_desktop`, `GlobalReachReport`.`ft_mobile`, `GlobalReachReport`.`ft_expires`, `GlobalReachReport`.`ft_capture_started`, `GlobalReachReport`.`nikkei_desktop`, `GlobalReachReport`.`nikkei_mobile`, `GlobalReachReport`.`nikkei_expires`, `GlobalReachReport`.`nikkei_capture_started`, `GlobalReachReport`.`pgl_desktop`, `GlobalReachReport`.`pgl_mobile`, `GlobalReachReport`.`pgl_expires`, `GlobalReachReport`.`pgl_capture_started`, `GlobalReachReport`.`robb_desktop`, `GlobalReachReport`.`robb_mobile`, `GlobalReachReport`.`robb_expires`, `GlobalReachReport`.`robb_capture_started`, `GlobalReachReport`.`juwai_desktop`, `GlobalReachReport`.`juwai_mobile`, `GlobalReachReport`.`juwai_expires`, `GlobalReachReport`.`juwai_capture_started`, `GlobalReachReport`.`leverage_desktop`, `GlobalReachReport`.`leverage_mobile`, `GlobalReachReport`.`leverage_expires`, `GlobalReachReport`.`leverage_capture_started`, `GlobalReachReport`.`created`, `GlobalReachReport`.`modified` FROM `leveragere_staging2`.`properties` AS `Property` LEFT JOIN `leveragere_staging2`.`property_categories` AS `PrimaryPropertyCategory` ON (`Property`.`primary_property_category_id` = `PrimaryPropertyCategory`.`id`) LEFT JOIN `leveragere_staging2`.`brokerages` AS `Brokerage` ON (`Property`.`brokerage_id` = `Brokerage`.`id`) LEFT JOIN `leveragere_staging2`.`stripe_subscriptions` AS `StripeSubscription` ON (`StripeSubscription`.`property_id` = `Property`.`id` AND `StripeSubscription`.`status` = 'active') LEFT JOIN `leveragere_staging2`.`global_reach_reports` AS `GlobalReachReport` ON (`GlobalReachReport`.`property_id` = `Property`.`id`) WHERE `Property`.`id` = 2585 AND `Property`.`archived` = '0' AND `Brokerage`.`archived` = '0' AND `Property`.`incomplete` = '0' LIMIT 1	1	1	3	maybe slow
SELECT `AccountExecutive`.`id`, `AccountExecutive`.`type`, `AccountExecutive`.`brokerage_id`, `AccountExecutive`.`email`, `AccountExecutive`.`password`, `AccountExecutive`.`recover_hash`, `AccountExecutive`.`first_name`, `AccountExecutive`.`last_name`, `AccountExecutive`.`title`, `AccountExecutive`.`dre_num`, `AccountExecutive`.`phone`, `AccountExecutive`.`max_luxury_feed_properties`, `AccountExecutive`.`headshot_filename`, `AccountExecutive`.`bio`, `AccountExecutive`.`brokerage_name_override`, `AccountExecutive`.`stripe_customer_id`, `AccountExecutive`.`digital_ad_first_free_month_coupon`, `AccountExecutive`.`modified`, `AccountExecutive`.`created`, `AccountExecutive`.`notified`, (CONCAT(`AccountExecutive`.`first_name`, " ", `AccountExecutive`.`last_name`)) AS `AccountExecutive__full_name` FROM `leveragere_staging2`.`users` AS `AccountExecutive` WHERE `AccountExecutive`.`id` = 0	0	0	0
SELECT `Logo`.`id`, `Logo`.`model`, `Logo`.`model_id`, `Logo`.`tag`, `Logo`.`name`, `Logo`.`type`, `Logo`.`size`, `Logo`.`uri`, `Logo`.`order`, `Logo`.`created`, `Logo`.`modified` FROM `leveragere_staging2`.`assets` AS `Logo` WHERE `Logo`.`model_id` = 198 AND `Logo`.`model` = 'Brokerage' AND `Logo`.`tag` = 'Logo'	1	1	0
SELECT `MainImage`.`id`, `MainImage`.`model`, `MainImage`.`model_id`, `MainImage`.`tag`, `MainImage`.`name`, `MainImage`.`type`, `MainImage`.`size`, `MainImage`.`uri`, `MainImage`.`order`, `MainImage`.`created`, `MainImage`.`modified` FROM `leveragere_staging2`.`assets` AS `MainImage` WHERE `MainImage`.`model_id` = 198 AND `MainImage`.`model` = 'Brokerage' AND `MainImage`.`tag` = 'MainImage'	1	1	0
SELECT `ContactImage`.`id`, `ContactImage`.`model`, `ContactImage`.`model_id`, `ContactImage`.`tag`, `ContactImage`.`name`, `ContactImage`.`type`, `ContactImage`.`size`, `ContactImage`.`uri`, `ContactImage`.`order`, `ContactImage`.`created`, `ContactImage`.`modified` FROM `leveragere_staging2`.`assets` AS `ContactImage` WHERE `ContactImage`.`model_id` = 198 AND `ContactImage`.`model` = 'Brokerage' AND `ContactImage`.`tag` = 'ContactImage'	1	1	0
SELECT `ContactImage2`.`id`, `ContactImage2`.`model`, `ContactImage2`.`model_id`, `ContactImage2`.`tag`, `ContactImage2`.`name`, `ContactImage2`.`type`, `ContactImage2`.`size`, `ContactImage2`.`uri`, `ContactImage2`.`order`, `ContactImage2`.`created`, `ContactImage2`.`modified` FROM `leveragere_staging2`.`assets` AS `ContactImage2` WHERE `ContactImage2`.`model_id` = 198 AND `ContactImage2`.`model` = 'Brokerage' AND `ContactImage2`.`tag` = 'ContactImage2'	0	0	3	maybe slow
SELECT `ContactImage3`.`id`, `ContactImage3`.`model`, `ContactImage3`.`model_id`, `ContactImage3`.`tag`, `ContactImage3`.`name`, `ContactImage3`.`type`, `ContactImage3`.`size`, `ContactImage3`.`uri`, `ContactImage3`.`order`, `ContactImage3`.`created`, `ContactImage3`.`modified` FROM `leveragere_staging2`.`assets` AS `ContactImage3` WHERE `ContactImage3`.`model_id` = 198 AND `ContactImage3`.`model` = 'Brokerage' AND `ContactImage3`.`tag` = 'ContactImage3'	0	0	0
SELECT `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`.`assets` AS `BrokerOfRecordLogo` WHERE `BrokerOfRecordLogo`.`model_id` = 198 AND `BrokerOfRecordLogo`.`model` = 'Brokerage' AND `BrokerOfRecordLogo`.`tag` = 'BrokerOfRecordLogo'	0	0	0
SELECT `MainArticle`.`id`, `MainArticle`.`model`, `MainArticle`.`model_id`, `MainArticle`.`archived`, `MainArticle`.`medium_featured`, `MainArticle`.`large_featured`, `MainArticle`.`title`, `MainArticle`.`author`, `MainArticle`.`date`, `MainArticle`.`lead_in`, `MainArticle`.`body`, `MainArticle`.`vimeo_id`, `MainArticle`.`created`, `MainArticle`.`modified` FROM `leveragere_staging2`.`articles` AS `MainArticle` WHERE `MainArticle`.`model_id` = 198 AND `MainArticle`.`model` = 'Brokerage'	0	0	0
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` FROM `leveragere_staging2`.`locations` AS `Location` WHERE `Location`.`brokerage_id` = (198)	1	1	0
SELECT `User`.`id`, `User`.`type`, `User`.`brokerage_id`, `User`.`email`, `User`.`password`, `User`.`recover_hash`, `User`.`first_name`, `User`.`last_name`, `User`.`title`, `User`.`dre_num`, `User`.`phone`, `User`.`max_luxury_feed_properties`, `User`.`headshot_filename`, `User`.`bio`, `User`.`brokerage_name_override`, `User`.`stripe_customer_id`, `User`.`digital_ad_first_free_month_coupon`, `User`.`modified`, `User`.`created`, `User`.`notified`, (CONCAT(`User`.`first_name`, " ", `User`.`last_name`)) AS `User__full_name` FROM `leveragere_staging2`.`users` AS `User` WHERE `User`.`brokerage_id` = (198)	4	4	0
SELECT `Image`.`id`, `Image`.`model`, `Image`.`model_id`, `Image`.`tag`, `Image`.`name`, `Image`.`type`, `Image`.`size`, `Image`.`uri`, `Image`.`order`, `Image`.`created`, `Image`.`modified` FROM `leveragere_staging2`.`assets` AS `Image` WHERE `Image`.`model` = 'Property' AND `Image`.`tag` = 'Image' AND `Image`.`model_id` = (2585) ORDER BY `Image`.`order` ASC	9	9	4	maybe slow
SELECT `User`.`id`, `User`.`type`, `User`.`brokerage_id`, `User`.`email`, `User`.`password`, `User`.`recover_hash`, `User`.`first_name`, `User`.`last_name`, `User`.`title`, `User`.`dre_num`, `User`.`phone`, `User`.`max_luxury_feed_properties`, `User`.`headshot_filename`, `User`.`bio`, `User`.`brokerage_name_override`, `User`.`stripe_customer_id`, `User`.`digital_ad_first_free_month_coupon`, `User`.`modified`, `User`.`created`, `User`.`notified`, (CONCAT(`User`.`first_name`, " ", `User`.`last_name`)) AS `User__full_name`, `UsersProperty`.`id`, `UsersProperty`.`user_id`, `UsersProperty`.`property_id`, `UsersProperty`.`sort_order` FROM `leveragere_staging2`.`users` AS `User` JOIN `leveragere_staging2`.`users_properties` AS `UsersProperty` ON (`UsersProperty`.`property_id` = 2585 AND `UsersProperty`.`user_id` = `User`.`id`) ORDER BY `UsersProperty`.`sort_order` ASC	3	3	0
SELECT `Brokerage`.`id`, `Brokerage`.`account_executive_id`, `Brokerage`.`archived`, `Brokerage`.`type`, `Brokerage`.`hide_from_frontend`, `Brokerage`.`agent_brokerage_data_override`, `Brokerage`.`featured_development`, `Brokerage`.`membership_type`, `Brokerage`.`max_properties`, `Brokerage`.`max_homepage_featured_by_member_properties`, `Brokerage`.`featured_properties_sort_method`, `Brokerage`.`lux_feed_mode`, `Brokerage`.`max_luxury_feed_properties`, `Brokerage`.`membership_luxury_feed_properties`, `Brokerage`.`can_participate_in_lux_feed_while_archived`, `Brokerage`.`full_training_video_access`, `Brokerage`.`country_id`, `Brokerage`.`WOEID`, `Brokerage`.`timezone`, `Brokerage`.`luxury_feed_enrollment_mode`, `Brokerage`.`luxury_feed_include_mlsidx_minimum_price`, `Brokerage`.`luxury_feed_include_leverage_minimum_price`, `Brokerage`.`digital_ad_contacts`, `Brokerage`.`add_agents_to_grr_auto_recipients`, `Brokerage`.`mlsidx_id`, `Brokerage`.`mlsidx_lux_autofeed`, `Brokerage`.`mlsidx_lux_autofeed_minimum_price`, `Brokerage`.`mlsidx_logo_url`, `Brokerage`.`mlsidx_disclaimer`, `Brokerage`.`name`, `Brokerage`.`broker_of_record_name`, `Brokerage`.`short_name`, `Brokerage`.`username`, `Brokerage`.`password`, `Brokerage`.`password_reset_hash`, `Brokerage`.`monthly_invoice_amount`, `Brokerage`.`monthly_invoice_start_date`, `Brokerage`.`monthly_invoice_end_date`, `Brokerage`.`contract_filename`, `Brokerage`.`active`, `Brokerage`.`lead_in`, `Brokerage`.`short_description`, `Brokerage`.`description`, `Brokerage`.`communities`, `Brokerage`.`website`, `Brokerage`.`address`, `Brokerage`.`address_2`, `Brokerage`.`city`, `Brokerage`.`state`, `Brokerage`.`full_state`, `Brokerage`.`country`, `Brokerage`.`market`, `Brokerage`.`market_2`, `Brokerage`.`postal_code`, `Brokerage`.`phone`, `Brokerage`.`phone_2`, `Brokerage`.`phone_3`, `Brokerage`.`wide_contact_image`, `Brokerage`.`contact_name`, `Brokerage`.`contact_profile_link`, `Brokerage`.`contact_big_profile_link`, `Brokerage`.`contact_big_profile_link_text`, `Brokerage`.`contact_title`, `Brokerage`.`contact_dre_num`, `Brokerage`.`contact_quote`, `Brokerage`.`contact_email`, `Brokerage`.`contact_facebook`, `Brokerage`.`contact_twitter`, `Brokerage`.`contact_instagram`, `Brokerage`.`contact_pinterest`, `Brokerage`.`contact_linkedin`, `Brokerage`.`contact_youtube`, `Brokerage`.`contact_phone`, `Brokerage`.`contact_email_2`, `Brokerage`.`contact_2_facebook`, `Brokerage`.`contact_2_twitter`, `Brokerage`.`contact_2_instagram`, `Brokerage`.`contact_2_pinterest`, `Brokerage`.`contact_2_linkedin`, `Brokerage`.`contact_2_youtube`, `Brokerage`.`contact_phone_2`, `Brokerage`.`contact_website`, `Brokerage`.`contact_name_2`, `Brokerage`.`contact_profile_link_2`, `Brokerage`.`contact_big_profile_link_2`, `Brokerage`.`contact_big_profile_link_text_2`, `Brokerage`.`contact_title_2`, `Brokerage`.`contact_dre_num_2`, `Brokerage`.`contact_email_3`, `Brokerage`.`contact_name_3`, `Brokerage`.`contact_title_3`, `Brokerage`.`contact_dre_num_3`, `Brokerage`.`contact_phone_3`, `Brokerage`.`contact_3_facebook`, `Brokerage`.`contact_3_twitter`, `Brokerage`.`contact_3_instagram`, `Brokerage`.`contact_3_pinterest`, `Brokerage`.`contact_3_linkedin`, `Brokerage`.`contact_3_youtube`, `Brokerage`.`image_filename`, `Brokerage`.`logo_filename`, `Brokerage`.`contact_image_filename`, `Brokerage`.`all_properties_link_image_filename`, `Brokerage`.`all_properties_link`, `Brokerage`.`video_embed_code`, `Brokerage`.`contact_video_embed_code`, `Brokerage`.`meta_title`, `Brokerage`.`meta_description`, `Brokerage`.`meta_keywords`, `Brokerage`.`login_message_counter`, `Brokerage`.`stats_module_1_type`, `Brokerage`.`stats_module_1_value`, `Brokerage`.`stats_module_2_type`, `Brokerage`.`stats_module_2_value`, `Brokerage`.`stats_module_3_type`, `Brokerage`.`stats_module_3_value`, `Brokerage`.`last_activity_email_sent`, `Brokerage`.`converted`, `Brokerage`.`created`, `Brokerage`.`modified`, `Brokerage`.`dre_num` FROM `leveragere_staging2`.`brokerages` AS `Brokerage` WHERE `Brokerage`.`id` = 198	1	1	0
SELECT `Brokerage`.`id`, `Brokerage`.`account_executive_id`, `Brokerage`.`archived`, `Brokerage`.`type`, `Brokerage`.`hide_from_frontend`, `Brokerage`.`agent_brokerage_data_override`, `Brokerage`.`featured_development`, `Brokerage`.`membership_type`, `Brokerage`.`max_properties`, `Brokerage`.`max_homepage_featured_by_member_properties`, `Brokerage`.`featured_properties_sort_method`, `Brokerage`.`lux_feed_mode`, `Brokerage`.`max_luxury_feed_properties`, `Brokerage`.`membership_luxury_feed_properties`, `Brokerage`.`can_participate_in_lux_feed_while_archived`, `Brokerage`.`full_training_video_access`, `Brokerage`.`country_id`, `Brokerage`.`WOEID`, `Brokerage`.`timezone`, `Brokerage`.`luxury_feed_enrollment_mode`, `Brokerage`.`luxury_feed_include_mlsidx_minimum_price`, `Brokerage`.`luxury_feed_include_leverage_minimum_price`, `Brokerage`.`digital_ad_contacts`, `Brokerage`.`add_agents_to_grr_auto_recipients`, `Brokerage`.`mlsidx_id`, `Brokerage`.`mlsidx_lux_autofeed`, `Brokerage`.`mlsidx_lux_autofeed_minimum_price`, `Brokerage`.`mlsidx_logo_url`, `Brokerage`.`mlsidx_disclaimer`, `Brokerage`.`name`, `Brokerage`.`broker_of_record_name`, `Brokerage`.`short_name`, `Brokerage`.`username`, `Brokerage`.`password`, `Brokerage`.`password_reset_hash`, `Brokerage`.`monthly_invoice_amount`, `Brokerage`.`monthly_invoice_start_date`, `Brokerage`.`monthly_invoice_end_date`, `Brokerage`.`contract_filename`, `Brokerage`.`active`, `Brokerage`.`lead_in`, `Brokerage`.`short_description`, `Brokerage`.`description`, `Brokerage`.`communities`, `Brokerage`.`website`, `Brokerage`.`address`, `Brokerage`.`address_2`, `Brokerage`.`city`, `Brokerage`.`state`, `Brokerage`.`full_state`, `Brokerage`.`country`, `Brokerage`.`market`, `Brokerage`.`market_2`, `Brokerage`.`postal_code`, `Brokerage`.`phone`, `Brokerage`.`phone_2`, `Brokerage`.`phone_3`, `Brokerage`.`wide_contact_image`, `Brokerage`.`contact_name`, `Brokerage`.`contact_profile_link`, `Brokerage`.`contact_big_profile_link`, `Brokerage`.`contact_big_profile_link_text`, `Brokerage`.`contact_title`, `Brokerage`.`contact_dre_num`, `Brokerage`.`contact_quote`, `Brokerage`.`contact_email`, `Brokerage`.`contact_facebook`, `Brokerage`.`contact_twitter`, `Brokerage`.`contact_instagram`, `Brokerage`.`contact_pinterest`, `Brokerage`.`contact_linkedin`, `Brokerage`.`contact_youtube`, `Brokerage`.`contact_phone`, `Brokerage`.`contact_email_2`, `Brokerage`.`contact_2_facebook`, `Brokerage`.`contact_2_twitter`, `Brokerage`.`contact_2_instagram`, `Brokerage`.`contact_2_pinterest`, `Brokerage`.`contact_2_linkedin`, `Brokerage`.`contact_2_youtube`, `Brokerage`.`contact_phone_2`, `Brokerage`.`contact_website`, `Brokerage`.`contact_name_2`, `Brokerage`.`contact_profile_link_2`, `Brokerage`.`contact_big_profile_link_2`, `Brokerage`.`contact_big_profile_link_text_2`, `Brokerage`.`contact_title_2`, `Brokerage`.`contact_dre_num_2`, `Brokerage`.`contact_email_3`, `Brokerage`.`contact_name_3`, `Brokerage`.`contact_title_3`, `Brokerage`.`contact_dre_num_3`, `Brokerage`.`contact_phone_3`, `Brokerage`.`contact_3_facebook`, `Brokerage`.`contact_3_twitter`, `Brokerage`.`contact_3_instagram`, `Brokerage`.`contact_3_pinterest`, `Brokerage`.`contact_3_linkedin`, `Brokerage`.`contact_3_youtube`, `Brokerage`.`image_filename`, `Brokerage`.`logo_filename`, `Brokerage`.`contact_image_filename`, `Brokerage`.`all_properties_link_image_filename`, `Brokerage`.`all_properties_link`, `Brokerage`.`video_embed_code`, `Brokerage`.`contact_video_embed_code`, `Brokerage`.`meta_title`, `Brokerage`.`meta_description`, `Brokerage`.`meta_keywords`, `Brokerage`.`login_message_counter`, `Brokerage`.`stats_module_1_type`, `Brokerage`.`stats_module_1_value`, `Brokerage`.`stats_module_2_type`, `Brokerage`.`stats_module_2_value`, `Brokerage`.`stats_module_3_type`, `Brokerage`.`stats_module_3_value`, `Brokerage`.`last_activity_email_sent`, `Brokerage`.`converted`, `Brokerage`.`created`, `Brokerage`.`modified`, `Brokerage`.`dre_num` FROM `leveragere_staging2`.`brokerages` AS `Brokerage` WHERE `Brokerage`.`id` = 198	1	1	0
SELECT `Brokerage`.`id`, `Brokerage`.`account_executive_id`, `Brokerage`.`archived`, `Brokerage`.`type`, `Brokerage`.`hide_from_frontend`, `Brokerage`.`agent_brokerage_data_override`, `Brokerage`.`featured_development`, `Brokerage`.`membership_type`, `Brokerage`.`max_properties`, `Brokerage`.`max_homepage_featured_by_member_properties`, `Brokerage`.`featured_properties_sort_method`, `Brokerage`.`lux_feed_mode`, `Brokerage`.`max_luxury_feed_properties`, `Brokerage`.`membership_luxury_feed_properties`, `Brokerage`.`can_participate_in_lux_feed_while_archived`, `Brokerage`.`full_training_video_access`, `Brokerage`.`country_id`, `Brokerage`.`WOEID`, `Brokerage`.`timezone`, `Brokerage`.`luxury_feed_enrollment_mode`, `Brokerage`.`luxury_feed_include_mlsidx_minimum_price`, `Brokerage`.`luxury_feed_include_leverage_minimum_price`, `Brokerage`.`digital_ad_contacts`, `Brokerage`.`add_agents_to_grr_auto_recipients`, `Brokerage`.`mlsidx_id`, `Brokerage`.`mlsidx_lux_autofeed`, `Brokerage`.`mlsidx_lux_autofeed_minimum_price`, `Brokerage`.`mlsidx_logo_url`, `Brokerage`.`mlsidx_disclaimer`, `Brokerage`.`name`, `Brokerage`.`broker_of_record_name`, `Brokerage`.`short_name`, `Brokerage`.`username`, `Brokerage`.`password`, `Brokerage`.`password_reset_hash`, `Brokerage`.`monthly_invoice_amount`, `Brokerage`.`monthly_invoice_start_date`, `Brokerage`.`monthly_invoice_end_date`, `Brokerage`.`contract_filename`, `Brokerage`.`active`, `Brokerage`.`lead_in`, `Brokerage`.`short_description`, `Brokerage`.`description`, `Brokerage`.`communities`, `Brokerage`.`website`, `Brokerage`.`address`, `Brokerage`.`address_2`, `Brokerage`.`city`, `Brokerage`.`state`, `Brokerage`.`full_state`, `Brokerage`.`country`, `Brokerage`.`market`, `Brokerage`.`market_2`, `Brokerage`.`postal_code`, `Brokerage`.`phone`, `Brokerage`.`phone_2`, `Brokerage`.`phone_3`, `Brokerage`.`wide_contact_image`, `Brokerage`.`contact_name`, `Brokerage`.`contact_profile_link`, `Brokerage`.`contact_big_profile_link`, `Brokerage`.`contact_big_profile_link_text`, `Brokerage`.`contact_title`, `Brokerage`.`contact_dre_num`, `Brokerage`.`contact_quote`, `Brokerage`.`contact_email`, `Brokerage`.`contact_facebook`, `Brokerage`.`contact_twitter`, `Brokerage`.`contact_instagram`, `Brokerage`.`contact_pinterest`, `Brokerage`.`contact_linkedin`, `Brokerage`.`contact_youtube`, `Brokerage`.`contact_phone`, `Brokerage`.`contact_email_2`, `Brokerage`.`contact_2_facebook`, `Brokerage`.`contact_2_twitter`, `Brokerage`.`contact_2_instagram`, `Brokerage`.`contact_2_pinterest`, `Brokerage`.`contact_2_linkedin`, `Brokerage`.`contact_2_youtube`, `Brokerage`.`contact_phone_2`, `Brokerage`.`contact_website`, `Brokerage`.`contact_name_2`, `Brokerage`.`contact_profile_link_2`, `Brokerage`.`contact_big_profile_link_2`, `Brokerage`.`contact_big_profile_link_text_2`, `Brokerage`.`contact_title_2`, `Brokerage`.`contact_dre_num_2`, `Brokerage`.`contact_email_3`, `Brokerage`.`contact_name_3`, `Brokerage`.`contact_title_3`, `Brokerage`.`contact_dre_num_3`, `Brokerage`.`contact_phone_3`, `Brokerage`.`contact_3_facebook`, `Brokerage`.`contact_3_twitter`, `Brokerage`.`contact_3_instagram`, `Brokerage`.`contact_3_pinterest`, `Brokerage`.`contact_3_linkedin`, `Brokerage`.`contact_3_youtube`, `Brokerage`.`image_filename`, `Brokerage`.`logo_filename`, `Brokerage`.`contact_image_filename`, `Brokerage`.`all_properties_link_image_filename`, `Brokerage`.`all_properties_link`, `Brokerage`.`video_embed_code`, `Brokerage`.`contact_video_embed_code`, `Brokerage`.`meta_title`, `Brokerage`.`meta_description`, `Brokerage`.`meta_keywords`, `Brokerage`.`login_message_counter`, `Brokerage`.`stats_module_1_type`, `Brokerage`.`stats_module_1_value`, `Brokerage`.`stats_module_2_type`, `Brokerage`.`stats_module_2_value`, `Brokerage`.`stats_module_3_type`, `Brokerage`.`stats_module_3_value`, `Brokerage`.`last_activity_email_sent`, `Brokerage`.`converted`, `Brokerage`.`created`, `Brokerage`.`modified`, `Brokerage`.`dre_num` FROM `leveragere_staging2`.`brokerages` AS `Brokerage` WHERE `Brokerage`.`id` = 198	1	1	0
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_id` = 635 AND `Image`.`model` = 'User' AND `Image`.`tag` = 'Image'	0	0	0
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_id` = 984 AND `Image`.`model` = 'User' AND `Image`.`tag` = 'Image'	0	0	0
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_id` = 985 AND `Image`.`model` = 'User' AND `Image`.`tag` = 'Image'	0	0	0
SELECT `BrokerageLogoOverride`.`id`, `BrokerageLogoOverride`.`model`, `BrokerageLogoOverride`.`model_id`, `BrokerageLogoOverride`.`tag`, `BrokerageLogoOverride`.`name`, `BrokerageLogoOverride`.`type`, `BrokerageLogoOverride`.`size`, `BrokerageLogoOverride`.`uri`, `BrokerageLogoOverride`.`order`, `BrokerageLogoOverride`.`created`, `BrokerageLogoOverride`.`modified` FROM `leveragere_staging2`.`assets` AS `BrokerageLogoOverride` WHERE `BrokerageLogoOverride`.`model_id` = 635 AND `BrokerageLogoOverride`.`model` = 'User' AND `BrokerageLogoOverride`.`tag` = 'BrokerageLogoOverride'	0	0	0
SELECT `BrokerageLogoOverride`.`id`, `BrokerageLogoOverride`.`model`, `BrokerageLogoOverride`.`model_id`, `BrokerageLogoOverride`.`tag`, `BrokerageLogoOverride`.`name`, `BrokerageLogoOverride`.`type`, `BrokerageLogoOverride`.`size`, `BrokerageLogoOverride`.`uri`, `BrokerageLogoOverride`.`order`, `BrokerageLogoOverride`.`created`, `BrokerageLogoOverride`.`modified` FROM `leveragere_staging2`.`assets` AS `BrokerageLogoOverride` WHERE `BrokerageLogoOverride`.`model_id` = 984 AND `BrokerageLogoOverride`.`model` = 'User' AND `BrokerageLogoOverride`.`tag` = 'BrokerageLogoOverride'	0	0	0
SELECT `BrokerageLogoOverride`.`id`, `BrokerageLogoOverride`.`model`, `BrokerageLogoOverride`.`model_id`, `BrokerageLogoOverride`.`tag`, `BrokerageLogoOverride`.`name`, `BrokerageLogoOverride`.`type`, `BrokerageLogoOverride`.`size`, `BrokerageLogoOverride`.`uri`, `BrokerageLogoOverride`.`order`, `BrokerageLogoOverride`.`created`, `BrokerageLogoOverride`.`modified` FROM `leveragere_staging2`.`assets` AS `BrokerageLogoOverride` WHERE `BrokerageLogoOverride`.`model_id` = 985 AND `BrokerageLogoOverride`.`model` = 'User' AND `BrokerageLogoOverride`.`tag` = 'BrokerageLogoOverride'	0	0	0
SELECT `SecondaryPropertyCategory`.`id`, `SecondaryPropertyCategory`.`name`, `SecondaryPropertyCategory`.`created`, `SecondaryPropertyCategory`.`modified`, `PropertiesSecondaryPropertyCategory`.`id`, `PropertiesSecondaryPropertyCategory`.`property_id`, `PropertiesSecondaryPropertyCategory`.`property_category_id`, `PropertiesSecondaryPropertyCategory`.`created`, `PropertiesSecondaryPropertyCategory`.`modified` FROM `leveragere_staging2`.`property_categories` AS `SecondaryPropertyCategory` JOIN `leveragere_staging2`.`properties_secondary_property_categories` AS `PropertiesSecondaryPropertyCategory` ON (`PropertiesSecondaryPropertyCategory`.`property_id` = 2585 AND `PropertiesSecondaryPropertyCategory`.`property_category_id` = `SecondaryPropertyCategory`.`id`)	0	0	0
SELECT `PropertyFeature`.`id`, `PropertyFeature`.`name`, `PropertyFeature`.`additional`, `PropertyFeature`.`created`, `PropertyFeature`.`modified`, `PropertiesPropertyFeature`.`id`, `PropertiesPropertyFeature`.`property_id`, `PropertiesPropertyFeature`.`property_feature_id` FROM `leveragere_staging2`.`property_features` AS `PropertyFeature` JOIN `leveragere_staging2`.`properties_property_features` AS `PropertiesPropertyFeature` ON (`PropertiesPropertyFeature`.`property_id` = 2585 AND `PropertiesPropertyFeature`.`property_feature_id` = `PropertyFeature`.`id`)	2	2	0
SELECT `Icon`.`id`, `Icon`.`model`, `Icon`.`model_id`, `Icon`.`tag`, `Icon`.`name`, `Icon`.`type`, `Icon`.`size`, `Icon`.`uri`, `Icon`.`order`, `Icon`.`created`, `Icon`.`modified` FROM `leveragere_staging2`.`assets` AS `Icon` WHERE `Icon`.`model_id` = 4 AND `Icon`.`model` = 'PropertyFeature' AND `Icon`.`tag` = 'Icon'	1	1	0
SELECT `Icon`.`id`, `Icon`.`model`, `Icon`.`model_id`, `Icon`.`tag`, `Icon`.`name`, `Icon`.`type`, `Icon`.`size`, `Icon`.`uri`, `Icon`.`order`, `Icon`.`created`, `Icon`.`modified` FROM `leveragere_staging2`.`assets` AS `Icon` WHERE `Icon`.`model_id` = 14 AND `Icon`.`model` = 'PropertyFeature' AND `Icon`.`tag` = 'Icon'	1	1	8	maybe slow
SELECT `Topic`.`id`, `Topic`.`name`, `Topic`.`created`, `Topic`.`modified`, `PropertiesTopic`.`id`, `PropertiesTopic`.`property_id`, `PropertiesTopic`.`topic_id` FROM `leveragere_staging2`.`topics` AS `Topic` JOIN `leveragere_staging2`.`properties_topics` AS `PropertiesTopic` ON (`PropertiesTopic`.`property_id` = 2585 AND `PropertiesTopic`.`topic_id` = `Topic`.`id`)	0	0	0
SELECT `Property`.`id`, `Property`.`brokerage_id`, `Property`.`created_by_user_id`, `Property`.`order`, `Property`.`multi_unit`, `Property`.`agent_1_id`, `Property`.`agent_2_id`, `Property`.`agent_3_id`, `Property`.`name`, `Property`.`incomplete`, `Property`.`archived`, `Property`.`last_archived`, `Property`.`auto_archived_from_mlsidx`, `Property`.`paid_featured`, `Property`.`featured`, `Property`.`homepage_featured`, `Property`.`brokerage_page_featured`, `Property`.`requested_homepage_featured_by_member`, `Property`.`homepage_featured_by_member`, `Property`.`dot_luxury_featured`, `Property`.`luxury_feed_featured`, `Property`.`force_luxury_feed_featured`, `Property`.`luxury_autofeed_imported`, `Property`.`luxury_feed_last_added_time`, `Property`.`luxury_feed_agent_user_id`, `Property`.`luxury_feed_locked_to_subscription_id`, `Property`.`luxury_feed_agent_purchase_date`, `Property`.`luxury_feed_agent_expiration_date`, `Property`.`digital_ad_summary_email_last_sent`, `Property`.`digital_ad_summary_price_changed`, `Property`.`wsj_detail_url`, `Property`.`ft_detail_url`, `Property`.`nyt_detail_url`, `Property`.`juwai_detail_url`, `Property`.`pgl_detail_url`, `Property`.`mg_detail_url`, `Property`.`mg_c_detail_url`, `Property`.`mg_s_detail_url`, `Property`.`bp_detail_url`, `Property`.`mw_detail_url`, `Property`.`nikkei_detail_url`, `Property`.`wapo_detail_url`, `Property`.`robb_detail_url`, `Property`.`medium_featured`, `Property`.`large_featured`, `Property`.`detail_page`, `Property`.`description`, `Property`.`address`, `Property`.`address_2`, `Property`.`city`, `Property`.`state`, `Property`.`postal_code`, `Property`.`country`, `Property`.`use_lat_lng_for_google_map`, `Property`.`currency`, `Property`.`price`, `Property`.`price_2`, `Property`.`price_usd`, `Property`.`price_usd_2`, `Property`.`status`, `Property`.`status_last_changed`, `Property`.`status_last_changed_price_only`, `Property`.`lease_period`, `Property`.`price_upon_request`, `Property`.`bedrooms`, `Property`.`bedrooms_2`, `Property`.`bathrooms`, `Property`.`bathrooms_2`, `Property`.`no_beds_baths`, `Property`.`square_feet`, `Property`.`square_meters`, `Property`.`acres`, `Property`.`interior_unit`, `Property`.`interior_size`, `Property`.`lot_unit`, `Property`.`lot_size`, `Property`.`icon_1`, `Property`.`icon_2`, `Property`.`icon_3`, `Property`.`icon_4`, `Property`.`icon_5`, `Property`.`icon_6`, `Property`.`website`, `Property`.`meta_title`, `Property`.`meta_description`, `Property`.`meta_keywords`, `Property`.`bathrooms_partial`, `Property`.`bathrooms_partial_2`, `Property`.`bathrooms_3_4`, `Property`.`bathrooms_3_4_2`, `Property`.`year_built`, `Property`.`virtual_tour`, `Property`.`video_tour`, `Property`.`digital_brochure`, `Property`.`video_tour_embed_code`, `Property`.`digital_brochure_embed_code`, `Property`.`mls_num`, `Property`.`wsj_property_type`, `Property`.`nyt_property_type`, `Property`.`nyt_popular_features`, `Property`.`propgolux_property_type`, `Property`.`juwai_property_type`, `Property`.`juwai_category`, `Property`.`propgolux_property_style`, `Property`.`wapo_property_type`, `Property`.`robb_property_type`, `Property`.`propgolux_location_id_override`, `Property`.`open_house_1_start`, `Property`.`open_house_1_end_time`, `Property`.`latitude`, `Property`.`longitude`, `Property`.`invalid_required_fields`, `Property`.`invalid_optional_fields`, `Property`.`went_live_today`, `Property`.`converted`, `Property`.`invalid`, `Property`.`mlsidx_full_address`, `Property`.`mlsidx_date_listed`, `Property`.`mls_market`, `Property`.`primary_property_category_id`, `Property`.`realstaq_initial_image_sync`, `Property`.`digital_ad_listing_urls_automated`, `Property`.`modified`, `Property`.`created`, `PrimaryPropertyCategory`.`id`, `PrimaryPropertyCategory`.`name`, `PrimaryPropertyCategory`.`created`, `PrimaryPropertyCategory`.`modified`, `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`, `StripeSubscription`.`id`, `StripeSubscription`.`brokerage_id`, `StripeSubscription`.`user_id`, `StripeSubscription`.`property_id`, `StripeSubscription`.`type`, `StripeSubscription`.`stripe_id`, `StripeSubscription`.`stripe_customer_id`, `StripeSubscription`.`stripe_checkout_email`, `StripeSubscription`.`stripe_promotion_code`, `StripeSubscription`.`stripe_promotion_code_id`, `StripeSubscription`.`stripe_coupon_code_id`, `StripeSubscription`.`status`, `StripeSubscription`.`current_period_end`, `StripeSubscription`.`cancel_at_period_end`, `StripeSubscription`.`ended`, `StripeSubscription`.`last_change`, `StripeSubscription`.`last_activity_email_sent`, `StripeSubscription`.`created`, `StripeSubscription`.`modified`, `GlobalReachReport`.`id`, `GlobalReachReport`.`property_id`, `GlobalReachReport`.`wsj_desktop`, `GlobalReachReport`.`wsj_mobile`, `GlobalReachReport`.`wsj_expires`, `GlobalReachReport`.`wsj_capture_started`, `GlobalReachReport`.`mg_desktop`, `GlobalReachReport`.`mg_mobile`, `GlobalReachReport`.`mg_expires`, `GlobalReachReport`.`mg_capture_started`, `GlobalReachReport`.`bp_desktop`, `GlobalReachReport`.`bp_mobile`, `GlobalReachReport`.`bp_expires`, `GlobalReachReport`.`gp_capture_started`, `GlobalReachReport`.`mw_desktop`, `GlobalReachReport`.`mw_mobile`, `GlobalReachReport`.`mw_expires`, `GlobalReachReport`.`mw_capture_started`, `GlobalReachReport`.`ft_desktop`, `GlobalReachReport`.`ft_mobile`, `GlobalReachReport`.`ft_expires`, `GlobalReachReport`.`ft_capture_started`, `GlobalReachReport`.`nikkei_desktop`, `GlobalReachReport`.`nikkei_mobile`, `GlobalReachReport`.`nikkei_expires`, `GlobalReachReport`.`nikkei_capture_started`, `GlobalReachReport`.`pgl_desktop`, `GlobalReachReport`.`pgl_mobile`, `GlobalReachReport`.`pgl_expires`, `GlobalReachReport`.`pgl_capture_started`, `GlobalReachReport`.`robb_desktop`, `GlobalReachReport`.`robb_mobile`, `GlobalReachReport`.`robb_expires`, `GlobalReachReport`.`robb_capture_started`, `GlobalReachReport`.`juwai_desktop`, `GlobalReachReport`.`juwai_mobile`, `GlobalReachReport`.`juwai_expires`, `GlobalReachReport`.`juwai_capture_started`, `GlobalReachReport`.`leverage_desktop`, `GlobalReachReport`.`leverage_mobile`, `GlobalReachReport`.`leverage_expires`, `GlobalReachReport`.`leverage_capture_started`, `GlobalReachReport`.`created`, `GlobalReachReport`.`modified` FROM `leveragere_staging2`.`properties` AS `Property` LEFT JOIN `leveragere_staging2`.`property_categories` AS `PrimaryPropertyCategory` ON (`Property`.`primary_property_category_id` = `PrimaryPropertyCategory`.`id`) LEFT JOIN `leveragere_staging2`.`brokerages` AS `Brokerage` ON (`Property`.`brokerage_id` = `Brokerage`.`id`) LEFT JOIN `leveragere_staging2`.`stripe_subscriptions` AS `StripeSubscription` ON (`StripeSubscription`.`property_id` = `Property`.`id` AND `StripeSubscription`.`status` = 'active') LEFT JOIN `leveragere_staging2`.`global_reach_reports` AS `GlobalReachReport` ON (`GlobalReachReport`.`property_id` = `Property`.`id`) WHERE `Property`.`archived` = '0' AND `Brokerage`.`archived` = '0' AND `Property`.`id` != 2585 AND `Property`.`brokerage_id` = 198 AND `Property`.`status` != 'Sold' AND `Property`.`incomplete` = '0' ORDER BY RAND() ASC LIMIT 2	2	2	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` = 'Property' AND `Image`.`tag` = 'Image' AND `Image`.`model_id` IN (2713, 3576) ORDER BY `Image`.`order` ASC	20	20	0
SELECT `User`.`id`, `User`.`type`, `User`.`brokerage_id`, `User`.`email`, `User`.`password`, `User`.`recover_hash`, `User`.`first_name`, `User`.`last_name`, `User`.`title`, `User`.`dre_num`, `User`.`phone`, `User`.`max_luxury_feed_properties`, `User`.`headshot_filename`, `User`.`bio`, `User`.`brokerage_name_override`, `User`.`stripe_customer_id`, `User`.`digital_ad_first_free_month_coupon`, `User`.`modified`, `User`.`created`, `User`.`notified`, (CONCAT(`User`.`first_name`, " ", `User`.`last_name`)) AS `User__full_name`, `UsersProperty`.`id`, `UsersProperty`.`user_id`, `UsersProperty`.`property_id`, `UsersProperty`.`sort_order` FROM `leveragere_staging2`.`users` AS `User` JOIN `leveragere_staging2`.`users_properties` AS `UsersProperty` ON (`UsersProperty`.`property_id` IN (2713, 3576) AND `UsersProperty`.`user_id` = `User`.`id`) ORDER BY `UsersProperty`.`sort_order` ASC	2	2	0
SELECT `SecondaryPropertyCategory`.`id`, `SecondaryPropertyCategory`.`name`, `SecondaryPropertyCategory`.`created`, `SecondaryPropertyCategory`.`modified`, `PropertiesSecondaryPropertyCategory`.`id`, `PropertiesSecondaryPropertyCategory`.`property_id`, `PropertiesSecondaryPropertyCategory`.`property_category_id`, `PropertiesSecondaryPropertyCategory`.`created`, `PropertiesSecondaryPropertyCategory`.`modified` FROM `leveragere_staging2`.`property_categories` AS `SecondaryPropertyCategory` JOIN `leveragere_staging2`.`properties_secondary_property_categories` AS `PropertiesSecondaryPropertyCategory` ON (`PropertiesSecondaryPropertyCategory`.`property_id` IN (2713, 3576) AND `PropertiesSecondaryPropertyCategory`.`property_category_id` = `SecondaryPropertyCategory`.`id`)	0	0	0
SELECT `PropertyFeature`.`id`, `PropertyFeature`.`name`, `PropertyFeature`.`additional`, `PropertyFeature`.`created`, `PropertyFeature`.`modified`, `PropertiesPropertyFeature`.`id`, `PropertiesPropertyFeature`.`property_id`, `PropertiesPropertyFeature`.`property_feature_id` FROM `leveragere_staging2`.`property_features` AS `PropertyFeature` JOIN `leveragere_staging2`.`properties_property_features` AS `PropertiesPropertyFeature` ON (`PropertiesPropertyFeature`.`property_id` IN (2713, 3576) AND `PropertiesPropertyFeature`.`property_feature_id` = `PropertyFeature`.`id`)	6	6	0
SELECT `Topic`.`id`, `Topic`.`name`, `Topic`.`created`, `Topic`.`modified`, `PropertiesTopic`.`id`, `PropertiesTopic`.`property_id`, `PropertiesTopic`.`topic_id` FROM `leveragere_staging2`.`topics` AS `Topic` JOIN `leveragere_staging2`.`properties_topics` AS `PropertiesTopic` ON (`PropertiesTopic`.`property_id` IN (2713, 3576) AND `PropertiesTopic`.`topic_id` = `Topic`.`id`)	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`.`archived` = '0' AND `Location`.`brokerage_id` = 198 LIMIT 1	1	1	1
SELECT `Property`.`id`, `Property`.`brokerage_id`, `Property`.`created_by_user_id`, `Property`.`order`, `Property`.`multi_unit`, `Property`.`agent_1_id`, `Property`.`agent_2_id`, `Property`.`agent_3_id`, `Property`.`name`, `Property`.`incomplete`, `Property`.`archived`, `Property`.`last_archived`, `Property`.`auto_archived_from_mlsidx`, `Property`.`paid_featured`, `Property`.`featured`, `Property`.`homepage_featured`, `Property`.`brokerage_page_featured`, `Property`.`requested_homepage_featured_by_member`, `Property`.`homepage_featured_by_member`, `Property`.`dot_luxury_featured`, `Property`.`luxury_feed_featured`, `Property`.`force_luxury_feed_featured`, `Property`.`luxury_autofeed_imported`, `Property`.`luxury_feed_last_added_time`, `Property`.`luxury_feed_agent_user_id`, `Property`.`luxury_feed_locked_to_subscription_id`, `Property`.`luxury_feed_agent_purchase_date`, `Property`.`luxury_feed_agent_expiration_date`, `Property`.`digital_ad_summary_email_last_sent`, `Property`.`digital_ad_summary_price_changed`, `Property`.`wsj_detail_url`, `Property`.`ft_detail_url`, `Property`.`nyt_detail_url`, `Property`.`juwai_detail_url`, `Property`.`pgl_detail_url`, `Property`.`mg_detail_url`, `Property`.`mg_c_detail_url`, `Property`.`mg_s_detail_url`, `Property`.`bp_detail_url`, `Property`.`mw_detail_url`, `Property`.`nikkei_detail_url`, `Property`.`wapo_detail_url`, `Property`.`robb_detail_url`, `Property`.`medium_featured`, `Property`.`large_featured`, `Property`.`detail_page`, `Property`.`description`, `Property`.`address`, `Property`.`address_2`, `Property`.`city`, `Property`.`state`, `Property`.`postal_code`, `Property`.`country`, `Property`.`use_lat_lng_for_google_map`, `Property`.`currency`, `Property`.`price`, `Property`.`price_2`, `Property`.`price_usd`, `Property`.`price_usd_2`, `Property`.`status`, `Property`.`status_last_changed`, `Property`.`status_last_changed_price_only`, `Property`.`lease_period`, `Property`.`price_upon_request`, `Property`.`bedrooms`, `Property`.`bedrooms_2`, `Property`.`bathrooms`, `Property`.`bathrooms_2`, `Property`.`no_beds_baths`, `Property`.`square_feet`, `Property`.`square_meters`, `Property`.`acres`, `Property`.`interior_unit`, `Property`.`interior_size`, `Property`.`lot_unit`, `Property`.`lot_size`, `Property`.`icon_1`, `Property`.`icon_2`, `Property`.`icon_3`, `Property`.`icon_4`, `Property`.`icon_5`, `Property`.`icon_6`, `Property`.`website`, `Property`.`meta_title`, `Property`.`meta_description`, `Property`.`meta_keywords`, `Property`.`bathrooms_partial`, `Property`.`bathrooms_partial_2`, `Property`.`bathrooms_3_4`, `Property`.`bathrooms_3_4_2`, `Property`.`year_built`, `Property`.`virtual_tour`, `Property`.`video_tour`, `Property`.`digital_brochure`, `Property`.`video_tour_embed_code`, `Property`.`digital_brochure_embed_code`, `Property`.`mls_num`, `Property`.`wsj_property_type`, `Property`.`nyt_property_type`, `Property`.`nyt_popular_features`, `Property`.`propgolux_property_type`, `Property`.`juwai_property_type`, `Property`.`juwai_category`, `Property`.`propgolux_property_style`, `Property`.`wapo_property_type`, `Property`.`robb_property_type`, `Property`.`propgolux_location_id_override`, `Property`.`open_house_1_start`, `Property`.`open_house_1_end_time`, `Property`.`latitude`, `Property`.`longitude`, `Property`.`invalid_required_fields`, `Property`.`invalid_optional_fields`, `Property`.`went_live_today`, `Property`.`converted`, `Property`.`invalid`, `Property`.`mlsidx_full_address`, `Property`.`mlsidx_date_listed`, `Property`.`mls_market`, `Property`.`primary_property_category_id`, `Property`.`realstaq_initial_image_sync`, `Property`.`digital_ad_listing_urls_automated`, `Property`.`modified`, `Property`.`created`, `PrimaryPropertyCategory`.`id`, `PrimaryPropertyCategory`.`name`, `PrimaryPropertyCategory`.`created`, `PrimaryPropertyCategory`.`modified`, `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`, `StripeSubscription`.`id`, `StripeSubscription`.`brokerage_id`, `StripeSubscription`.`user_id`, `StripeSubscription`.`property_id`, `StripeSubscription`.`type`, `StripeSubscription`.`stripe_id`, `StripeSubscription`.`stripe_customer_id`, `StripeSubscription`.`stripe_checkout_email`, `StripeSubscription`.`stripe_promotion_code`, `StripeSubscription`.`stripe_promotion_code_id`, `StripeSubscription`.`stripe_coupon_code_id`, `StripeSubscription`.`status`, `StripeSubscription`.`current_period_end`, `StripeSubscription`.`cancel_at_period_end`, `StripeSubscription`.`ended`, `StripeSubscription`.`last_change`, `StripeSubscription`.`last_activity_email_sent`, `StripeSubscription`.`created`, `StripeSubscription`.`modified`, `GlobalReachReport`.`id`, `GlobalReachReport`.`property_id`, `GlobalReachReport`.`wsj_desktop`, `GlobalReachReport`.`wsj_mobile`, `GlobalReachReport`.`wsj_expires`, `GlobalReachReport`.`wsj_capture_started`, `GlobalReachReport`.`mg_desktop`, `GlobalReachReport`.`mg_mobile`, `GlobalReachReport`.`mg_expires`, `GlobalReachReport`.`mg_capture_started`, `GlobalReachReport`.`bp_desktop`, `GlobalReachReport`.`bp_mobile`, `GlobalReachReport`.`bp_expires`, `GlobalReachReport`.`gp_capture_started`, `GlobalReachReport`.`mw_desktop`, `GlobalReachReport`.`mw_mobile`, `GlobalReachReport`.`mw_expires`, `GlobalReachReport`.`mw_capture_started`, `GlobalReachReport`.`ft_desktop`, `GlobalReachReport`.`ft_mobile`, `GlobalReachReport`.`ft_expires`, `GlobalReachReport`.`ft_capture_started`, `GlobalReachReport`.`nikkei_desktop`, `GlobalReachReport`.`nikkei_mobile`, `GlobalReachReport`.`nikkei_expires`, `GlobalReachReport`.`nikkei_capture_started`, `GlobalReachReport`.`pgl_desktop`, `GlobalReachReport`.`pgl_mobile`, `GlobalReachReport`.`pgl_expires`, `GlobalReachReport`.`pgl_capture_started`, `GlobalReachReport`.`robb_desktop`, `GlobalReachReport`.`robb_mobile`, `GlobalReachReport`.`robb_expires`, `GlobalReachReport`.`robb_capture_started`, `GlobalReachReport`.`juwai_desktop`, `GlobalReachReport`.`juwai_mobile`, `GlobalReachReport`.`juwai_expires`, `GlobalReachReport`.`juwai_capture_started`, `GlobalReachReport`.`leverage_desktop`, `GlobalReachReport`.`leverage_mobile`, `GlobalReachReport`.`leverage_expires`, `GlobalReachReport`.`leverage_capture_started`, `GlobalReachReport`.`created`, `GlobalReachReport`.`modified` FROM `leveragere_staging2`.`properties` AS `Property` LEFT JOIN `leveragere_staging2`.`property_categories` AS `PrimaryPropertyCategory` ON (`Property`.`primary_property_category_id` = `PrimaryPropertyCategory`.`id`) LEFT JOIN `leveragere_staging2`.`brokerages` AS `Brokerage` ON (`Property`.`brokerage_id` = `Brokerage`.`id`) LEFT JOIN `leveragere_staging2`.`stripe_subscriptions` AS `StripeSubscription` ON (`StripeSubscription`.`property_id` = `Property`.`id` AND `StripeSubscription`.`status` = 'active') LEFT JOIN `leveragere_staging2`.`global_reach_reports` AS `GlobalReachReport` ON (`GlobalReachReport`.`property_id` = `Property`.`id`) WHERE `Property`.`archived` = '0' AND `Brokerage`.`archived` = '0' AND `Property`.`brokerage_id` = 198 AND `Property`.`incomplete` = '0' ORDER BY RAND() ASC LIMIT 4	4	4	3	maybe slow
SELECT `Image`.`id`, `Image`.`model`, `Image`.`model_id`, `Image`.`tag`, `Image`.`name`, `Image`.`type`, `Image`.`size`, `Image`.`uri`, `Image`.`order`, `Image`.`created`, `Image`.`modified` FROM `leveragere_staging2`.`assets` AS `Image` WHERE `Image`.`model` = 'Property' AND `Image`.`tag` = 'Image' AND `Image`.`model_id` IN (3575, 3573, 2585, 3603) ORDER BY `Image`.`order` ASC	39	39	1
SELECT `User`.`id`, `User`.`type`, `User`.`brokerage_id`, `User`.`email`, `User`.`password`, `User`.`recover_hash`, `User`.`first_name`, `User`.`last_name`, `User`.`title`, `User`.`dre_num`, `User`.`phone`, `User`.`max_luxury_feed_properties`, `User`.`headshot_filename`, `User`.`bio`, `User`.`brokerage_name_override`, `User`.`stripe_customer_id`, `User`.`digital_ad_first_free_month_coupon`, `User`.`modified`, `User`.`created`, `User`.`notified`, (CONCAT(`User`.`first_name`, " ", `User`.`last_name`)) AS `User__full_name`, `UsersProperty`.`id`, `UsersProperty`.`user_id`, `UsersProperty`.`property_id`, `UsersProperty`.`sort_order` FROM `leveragere_staging2`.`users` AS `User` JOIN `leveragere_staging2`.`users_properties` AS `UsersProperty` ON (`UsersProperty`.`property_id` IN (3575, 3573, 2585, 3603) AND `UsersProperty`.`user_id` = `User`.`id`) ORDER BY `UsersProperty`.`sort_order` ASC	6	6	0
SELECT `SecondaryPropertyCategory`.`id`, `SecondaryPropertyCategory`.`name`, `SecondaryPropertyCategory`.`created`, `SecondaryPropertyCategory`.`modified`, `PropertiesSecondaryPropertyCategory`.`id`, `PropertiesSecondaryPropertyCategory`.`property_id`, `PropertiesSecondaryPropertyCategory`.`property_category_id`, `PropertiesSecondaryPropertyCategory`.`created`, `PropertiesSecondaryPropertyCategory`.`modified` FROM `leveragere_staging2`.`property_categories` AS `SecondaryPropertyCategory` JOIN `leveragere_staging2`.`properties_secondary_property_categories` AS `PropertiesSecondaryPropertyCategory` ON (`PropertiesSecondaryPropertyCategory`.`property_id` IN (3575, 3573, 2585, 3603) AND `PropertiesSecondaryPropertyCategory`.`property_category_id` = `SecondaryPropertyCategory`.`id`)	0	0	0
SELECT `PropertyFeature`.`id`, `PropertyFeature`.`name`, `PropertyFeature`.`additional`, `PropertyFeature`.`created`, `PropertyFeature`.`modified`, `PropertiesPropertyFeature`.`id`, `PropertiesPropertyFeature`.`property_id`, `PropertiesPropertyFeature`.`property_feature_id` FROM `leveragere_staging2`.`property_features` AS `PropertyFeature` JOIN `leveragere_staging2`.`properties_property_features` AS `PropertiesPropertyFeature` ON (`PropertiesPropertyFeature`.`property_id` IN (3575, 3573, 2585, 3603) AND `PropertiesPropertyFeature`.`property_feature_id` = `PropertyFeature`.`id`)	2	2	0
SELECT `Topic`.`id`, `Topic`.`name`, `Topic`.`created`, `Topic`.`modified`, `PropertiesTopic`.`id`, `PropertiesTopic`.`property_id`, `PropertiesTopic`.`topic_id` FROM `leveragere_staging2`.`topics` AS `Topic` JOIN `leveragere_staging2`.`properties_topics` AS `PropertiesTopic` ON (`PropertiesTopic`.`property_id` IN (3575, 3573, 2585, 3603) AND `PropertiesTopic`.`topic_id` = `Topic`.`id`)	0	0	0

2 duplicate queries run.

Query Explain:

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

====

Timer

Memory

Peak Memory Use 13.79 MB

Message	Memory use
Component initialization	3.09 MB
Controller action start	4.02 MB
Controller render start	6.97 MB
View render complete	7.50 MB

Timers

Total Request Time: 487 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	275.21
Event: Controller.initialize	3.87
Event: Controller.startup	1.18
Controller action	59.54
Event: Controller.beforeRender	18.13
» Processing toolbar data	18.00
Rendering View	89.06
» Event: View.beforeRender	0.26
» Rendering APP/View/Properties/view.ctp	3.22
» » Rendering APP/View/Elements/static_property_price.ctp	0.38
» » Rendering APP/View/Elements/property_features.ctp	0.23
» » Rendering APP/View/Elements/static_property_price.ctp #2	0.15
» » Rendering APP/View/Elements/static_property_price.ctp #3	0.14
» » Rendering APP/View/Elements/sidebar/location_list.ctp	0.14
» » Rendering APP/View/Elements/sidebar/property_list.ctp	0.99
» » » Rendering APP/View/Elements/static_property_price.ctp #4	0.15
» » » Rendering APP/View/Elements/static_property_price.ctp #5	0.14
» » » Rendering APP/View/Elements/static_property_price.ctp #6	0.13
» » » Rendering APP/View/Elements/static_property_price.ctp #7	0.13
» » Rendering APP/View/Elements/sidebar/property_search.ctp	0.20
» Event: View.afterRender	0.01
» Event: View.beforeLayout	0.01
» Rendering APP/View/Layouts/front.ctp	84.87
Event: View.afterLayout	0.00

====

Log
+

Logs

There were no log entries made this request

====
Variables
+
View Variables
- sidebar_properties(array)
 0(array)
 Property(array)
 id3575
 brokerage_id198
 created_by_user_id0
 order0
 multi_unit(false)
 agent_1_id428
 agent_2_id0
 agent_3_id0
 name5766 Dawley Dr.
 incomplete(false)
 archived(false)
 last_archived0000-00-00 00:00:00
 auto_archived_from_mlsidx(false)
 paid_featured(false)
 featured(true)
 homepage_featured(false)
 brokerage_page_featured(true)
 requested_homepage_featured_by_member(false)
 homepage_featured_by_member(false)
 dot_luxury_featured(false)
 luxury_feed_featured(false)
 force_luxury_feed_featured(false)
 luxury_autofeed_imported(false)
 luxury_feed_last_added_time0000-00-00 00:00:00
 luxury_feed_agent_user_id0
 luxury_feed_locked_to_subscription_id0
 luxury_feed_agent_purchase_date0000-00-00
 luxury_feed_agent_expiration_date0000-00-00
 digital_ad_summary_email_last_sent0000-00-00 00:00:00
 digital_ad_summary_price_changed(false)
 wsj_detail_url
 ft_detail_url
 nyt_detail_url
 juwai_detail_url
 pgl_detail_url
 mg_detail_url
 mg_c_detail_url
 mg_s_detail_url
 bp_detail_url
 mw_detail_url
 nikkei_detail_url
 wapo_detail_url
 robb_detail_url
 medium_featured(false)
 large_featured(false)
 detail_page(true)
 descriptionThis Harlan Hills home has everything: a great location close to downtown, a private fenced backyard with salt water pool and native landscaping that requires minimal maintenance, an open floor plan, a main floor master suite, a main floor office, spacious mudroom off the garage, and a knockout lower level walk out with a large family room that includes a fireplace, built-ins with beverage coolers - perfect for movie night, and 3 additional bedrooms and 2 full baths. Not to be missed!
 address5766 Dawley Dr.
 address_2
 cityFitchburg
 stateWI
 postal_code53711
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price650000
 price_20
 price_usd650000
 price_usd_20
 statusFor Sale
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(false)
 bedrooms5
 bedrooms_20
 bathrooms3
 bathrooms_20
 no_beds_baths(false)
 square_feet0
 square_meters
 acres0
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size0
 icon_1
 icon_2
 icon_3
 icon_4
 icon_5
 icon_6
 websitehttp://madison-homes.sprinkmanrealestate.com/idx/details/listing/a162/1767862/5766-Dawley-Dr-Fitchburg-Wisconsin-53711-1767862
 meta_title5766 Dawley Dr. | Fitchburg Real Estate | Sprinkman Real Estate
 meta_description5766 Dawley Dr. is a property offered for sale in Fitchburg, WI, USA, presented by Sprinkman Real Estate
 meta_keywords
 bathrooms_partial1
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built
 virtual_tourhttp://sprinkmanrealestate.com/3d-model/5766-dawley-drive/
 video_tourhttps://www.youtube.com/watch?v=EWmUwVheiO0
 digital_brochure
 video_tour_embed_code<iframe width="560" height="315" src="https://www.youtube.com/embed/EWmUwVheiO0?controls=0&showinfo=0" frameborder="0" allowfullscreen></iframe>
 digital_brochure_embed_code
 mls_num
 wsj_property_type
 nyt_property_type
 nyt_popular_features
 propgolux_property_type
 juwai_property_type
 juwai_category
 propgolux_property_style
 wapo_property_type
 robb_property_type
 propgolux_location_id_override
 open_house_1_start0000-00-00 00:00:00
 open_house_1_end_time00:00:00
 latitude0.000000
 longitude0.000000
 invalid_required_fieldslatitude, longitude
 invalid_optional_fieldsagent_2_id, square_feet, square_meters, acres, hectares, year_built, wsj_property_type, nyt_property_type, propgolux_property_type, propgolux_property_style
 went_live_today(false)
 converted(true)
 invalid(false)
 mlsidx_full_address
 mlsidx_date_listed0000-00-00
 mls_market
 primary_property_category_id0
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated(null)
 modified2016-04-18 05:33:03
 created2016-03-09 09:21:45
 uri/property-detail/3575/5766-dawley-dr-fitchburg-wi-53711-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3575/5766-dawley-dr-fitchburg-wi-53711-usa
 address_concat5766 Dawley Dr. Fitchburg WI 53711 USA
 google_maps_query_string5766+Dawley+Dr.+++Fitchburg+WI+53711+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 650,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty5
 bathrooms_pretty3
 bathrooms_partial_pretty1
 bathrooms_3_4_pretty0
 feed_full_bathrooms3
 date_listed2016-03-09
 overridden_brokerage_nameSprinkman Real Estate
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 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_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2[email protected]
 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
 StripeSubscription(array)
 id(null)
 brokerage_id(null)
 user_id(null)
 property_id(null)
 type(null)
 stripe_id(null)
 stripe_customer_id(null)
 stripe_checkout_email(null)
 stripe_promotion_code(null)
 stripe_promotion_code_id(null)
 stripe_coupon_code_id(null)
 status(null)
 current_period_end(null)
 cancel_at_period_end(null)
 ended(null)
 last_change(null)
 last_activity_email_sent(null)
 created(null)
 modified(null)
 GlobalReachReport(array)
 id(null)
 property_id(null)
 wsj_desktop(null)
 wsj_mobile(null)
 wsj_expires(null)
 wsj_capture_started(null)
 mg_desktop(null)
 mg_mobile(null)
 mg_expires(null)
 mg_capture_started(null)
 bp_desktop(null)
 bp_mobile(null)
 bp_expires(null)
 gp_capture_started(null)
 mw_desktop(null)
 mw_mobile(null)
 mw_expires(null)
 mw_capture_started(null)
 ft_desktop(null)
 ft_mobile(null)
 ft_expires(null)
 ft_capture_started(null)
 nikkei_desktop(null)
 nikkei_mobile(null)
 nikkei_expires(null)
 nikkei_capture_started(null)
 pgl_desktop(null)
 pgl_mobile(null)
 pgl_expires(null)
 pgl_capture_started(null)
 robb_desktop(null)
 robb_mobile(null)
 robb_expires(null)
 robb_capture_started(null)
 juwai_desktop(null)
 juwai_mobile(null)
 juwai_expires(null)
 juwai_capture_started(null)
 leverage_desktop(null)
 leverage_mobile(null)
 leverage_expires(null)
 leverage_capture_started(null)
 created(null)
 modified(null)
 wsj_available(false)
 wsj_expired(true)
 wsj_desktop_proxy_screenshot(null)
 wsj_mobile_proxy_screenshot(null)
 mg_available(false)
 mg_expired(true)
 mg_desktop_proxy_screenshot(null)
 mg_mobile_proxy_screenshot(null)
 bp_available(false)
 bp_expired(true)
 bp_desktop_proxy_screenshot(null)
 bp_mobile_proxy_screenshot(null)
 mw_available(false)
 mw_expired(true)
 mw_desktop_proxy_screenshot(null)
 mw_mobile_proxy_screenshot(null)
 nikkei_available(false)
 nikkei_expired(true)
 nikkei_desktop_proxy_screenshot(null)
 nikkei_mobile_proxy_screenshot(null)
 pgl_available(false)
 pgl_expired(true)
 pgl_desktop_proxy_screenshot(null)
 pgl_mobile_proxy_screenshot(null)
 robb_available(false)
 robb_expired(true)
 robb_desktop_proxy_screenshot(null)
 robb_mobile_proxy_screenshot(null)
 juwai_available(false)
 juwai_expired(true)
 juwai_desktop_proxy_screenshot(null)
 juwai_mobile_proxy_screenshot(null)
 capture_processing(false)
 capture_error(empty)
 Image(array)
 0(array)
 id19860
 modelProperty
 model_id3575
 tagImage
 name34734.jpg
 typeimage/jpg
 size720372
 uri/assets/19860.jpg
 order0
 created2016-04-07 17:25:12
 modified2016-04-07 17:25:12
 1(array)
 id19851
 modelProperty
 model_id3575
 tagImage
 name34725.jpg
 typeimage/jpg
 size763189
 uri/assets/19851.jpg
 order1
 created2016-04-07 17:25:11
 modified2016-04-07 17:25:12
 2(array)
 id19852
 modelProperty
 model_id3575
 tagImage
 name34726.jpg
 typeimage/jpg
 size332822
 uri/assets/19852.jpg
 order2
 created2016-04-07 17:25:12
 modified2016-04-07 17:25:12
 3(array)
 id19853
 modelProperty
 model_id3575
 tagImage
 name34727.jpg
 typeimage/jpg
 size754555
 uri/assets/19853.jpg
 order3
 created2016-04-07 17:25:12
 modified2016-04-07 17:25:12
 4(array)
 id19854
 modelProperty
 model_id3575
 tagImage
 name34728.jpg
 typeimage/jpg
 size632876
 uri/assets/19854.jpg
 order4
 created2016-04-07 17:25:12
 modified2016-04-07 17:25:12
 5(array)
 id19855
 modelProperty
 model_id3575
 tagImage
 name34729.jpg
 typeimage/jpg
 size632595
 uri/assets/19855.jpg
 order5
 created2016-04-07 17:25:12
 modified2016-04-07 17:25:12
 6(array)
 id19856
 modelProperty
 model_id3575
 tagImage
 name34730.jpg
 typeimage/jpg
 size410694
 uri/assets/19856.jpg
 order6
 created2016-04-07 17:25:12
 modified2016-04-07 17:25:12
 7(array)
 id19857
 modelProperty
 model_id3575
 tagImage
 name34731.jpg
 typeimage/jpg
 size601796
 uri/assets/19857.jpg
 order7
 created2016-04-07 17:25:12
 modified2016-04-07 17:25:12
 8(array)
 id19858
 modelProperty
 model_id3575
 tagImage
 name34732.jpg
 typeimage/jpg
 size660631
 uri/assets/19858.jpg
 order8
 created2016-04-07 17:25:12
 modified2016-04-07 17:25:12
 9(array)
 id19859
 modelProperty
 model_id3575
 tagImage
 name34733.jpg
 typeimage/jpg
 size774829
 uri/assets/19859.jpg
 order9
 created2016-04-07 17:25:12
 modified2016-04-07 17:25:12
 User(array)
 0(array)
 id635
 typeAgent
 brokerage_id198
 email[email protected]
 password1e9087fd209c002c2f47bc09f863dcebbb4b4556
 recover_hash
 first_nameShelly
 last_nameSprinkman
 title
 dre_num
 phone608-220-1453
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:12
 created2017-08-07 15:23:12
 notified(false)
 full_nameShelly Sprinkman
 uri/agent-detail/635/shelly-sprinkman
 profile_complete(true)
 UsersProperty(array)
 id431
 user_id635
 property_id3575
 sort_order0
 SecondaryPropertyCategory(empty)
 PropertyFeature(empty)
 Topic(empty)
 1(array)
 Property(array)
 id3573
 brokerage_id198
 created_by_user_id0
 order0
 multi_unit(false)
 agent_1_id428
 agent_2_id0
 agent_3_id0
 name9201 Bear Claw Way
 incomplete(false)
 archived(false)
 last_archived0000-00-00 00:00:00
 auto_archived_from_mlsidx(false)
 paid_featured(false)
 featured(true)
 homepage_featured(false)
 brokerage_page_featured(true)
 requested_homepage_featured_by_member(false)
 homepage_featured_by_member(false)
 dot_luxury_featured(false)
 luxury_feed_featured(false)
 force_luxury_feed_featured(false)
 luxury_autofeed_imported(false)
 luxury_feed_last_added_time0000-00-00 00:00:00
 luxury_feed_agent_user_id0
 luxury_feed_locked_to_subscription_id0
 luxury_feed_agent_purchase_date0000-00-00
 luxury_feed_agent_expiration_date0000-00-00
 digital_ad_summary_email_last_sent0000-00-00 00:00:00
 digital_ad_summary_price_changed(false)
 wsj_detail_url
 ft_detail_url
 nyt_detail_url
 juwai_detail_url
 pgl_detail_url
 mg_detail_url
 mg_c_detail_url
 mg_s_detail_url
 bp_detail_url
 mw_detail_url
 nikkei_detail_url
 wapo_detail_url
 robb_detail_url
 medium_featured(false)
 large_featured(false)
 detail_page(true)
 descriptionA one-of-a-kind home in Blackhawk! This rustic, modern beauty will steal your heart before you even enter the front door. Once inside youll marvel at the thoughtful details: the custom designed built-ins, the craftsman styled woodwork, the stone fireplace, cherry floors and woodwork throughout, large screened in porch overlooking the landscaped yard, spacious master suite w/walk-in closets and large garage and workshop. Its a must see!
 address9201 Bear Claw Way
 address_2
 cityMadison
 stateWI
 postal_code53717
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price625000
 price_20
 price_usd625000
 price_usd_20
 statusFor Sale
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(false)
 bedrooms4
 bedrooms_20
 bathrooms2
 bathrooms_20
 no_beds_baths(false)
 square_feet0
 square_meters
 acres0
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size0
 icon_1
 icon_2
 icon_3
 icon_4
 icon_5
 icon_6
 websitehttp://madison-homes.sprinkmanrealestate.com/idx/details/listing/a162/1767615/9201-Bear-Claw-Way-Madison-Wisconsin-53717-1767615
 meta_title9201 Bear Claw Way | Madison Real Estate | Sprinkman Real Estate
 meta_description9201 Bear Claw Way is a property offered for sale in Madison, WI, USA, presented by Sprinkman Real Estate
 meta_keywords
 bathrooms_partial1
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built
 virtual_tourhttp://sprinkmanrealestate.com/3d-model/9201-bear-claw-way/
 video_tourhttps://www.youtube.com/watch?v=JW1FxFhkdh8
 digital_brochure
 video_tour_embed_code<iframe width="560" height="315" src="https://www.youtube.com/embed/JW1FxFhkdh8?controls=0&showinfo=0" frameborder="0" allowfullscreen></iframe>
 digital_brochure_embed_code
 mls_num
 wsj_property_type
 nyt_property_type
 nyt_popular_features
 propgolux_property_type
 juwai_property_type
 juwai_category
 propgolux_property_style
 wapo_property_type
 robb_property_type
 propgolux_location_id_override
 open_house_1_start0000-00-00 00:00:00
 open_house_1_end_time00:00:00
 latitude0.000000
 longitude0.000000
 invalid_required_fieldslatitude, longitude
 invalid_optional_fieldsagent_2_id, square_feet, square_meters, acres, hectares, year_built, wsj_property_type, nyt_property_type, propgolux_property_type, propgolux_property_style
 went_live_today(false)
 converted(true)
 invalid(false)
 mlsidx_full_address
 mlsidx_date_listed0000-00-00
 mls_market
 primary_property_category_id0
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated(null)
 modified2016-04-18 05:33:03
 created2016-03-09 09:01:33
 uri/property-detail/3573/9201-bear-claw-way-madison-wi-53717-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3573/9201-bear-claw-way-madison-wi-53717-usa
 address_concat9201 Bear Claw Way Madison WI 53717 USA
 google_maps_query_string9201+Bear+Claw+Way++Madison+WI+53717+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 625,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty4
 bathrooms_pretty2
 bathrooms_partial_pretty1
 bathrooms_3_4_pretty0
 feed_full_bathrooms2
 date_listed2016-03-09
 overridden_brokerage_nameSprinkman Real Estate
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 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_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2[email protected]
 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
 StripeSubscription(array)
 id(null)
 brokerage_id(null)
 user_id(null)
 property_id(null)
 type(null)
 stripe_id(null)
 stripe_customer_id(null)
 stripe_checkout_email(null)
 stripe_promotion_code(null)
 stripe_promotion_code_id(null)
 stripe_coupon_code_id(null)
 status(null)
 current_period_end(null)
 cancel_at_period_end(null)
 ended(null)
 last_change(null)
 last_activity_email_sent(null)
 created(null)
 modified(null)
 GlobalReachReport(array)
 id(null)
 property_id(null)
 wsj_desktop(null)
 wsj_mobile(null)
 wsj_expires(null)
 wsj_capture_started(null)
 mg_desktop(null)
 mg_mobile(null)
 mg_expires(null)
 mg_capture_started(null)
 bp_desktop(null)
 bp_mobile(null)
 bp_expires(null)
 gp_capture_started(null)
 mw_desktop(null)
 mw_mobile(null)
 mw_expires(null)
 mw_capture_started(null)
 ft_desktop(null)
 ft_mobile(null)
 ft_expires(null)
 ft_capture_started(null)
 nikkei_desktop(null)
 nikkei_mobile(null)
 nikkei_expires(null)
 nikkei_capture_started(null)
 pgl_desktop(null)
 pgl_mobile(null)
 pgl_expires(null)
 pgl_capture_started(null)
 robb_desktop(null)
 robb_mobile(null)
 robb_expires(null)
 robb_capture_started(null)
 juwai_desktop(null)
 juwai_mobile(null)
 juwai_expires(null)
 juwai_capture_started(null)
 leverage_desktop(null)
 leverage_mobile(null)
 leverage_expires(null)
 leverage_capture_started(null)
 created(null)
 modified(null)
 wsj_available(false)
 wsj_expired(true)
 wsj_desktop_proxy_screenshot(null)
 wsj_mobile_proxy_screenshot(null)
 mg_available(false)
 mg_expired(true)
 mg_desktop_proxy_screenshot(null)
 mg_mobile_proxy_screenshot(null)
 bp_available(false)
 bp_expired(true)
 bp_desktop_proxy_screenshot(null)
 bp_mobile_proxy_screenshot(null)
 mw_available(false)
 mw_expired(true)
 mw_desktop_proxy_screenshot(null)
 mw_mobile_proxy_screenshot(null)
 nikkei_available(false)
 nikkei_expired(true)
 nikkei_desktop_proxy_screenshot(null)
 nikkei_mobile_proxy_screenshot(null)
 pgl_available(false)
 pgl_expired(true)
 pgl_desktop_proxy_screenshot(null)
 pgl_mobile_proxy_screenshot(null)
 robb_available(false)
 robb_expired(true)
 robb_desktop_proxy_screenshot(null)
 robb_mobile_proxy_screenshot(null)
 juwai_available(false)
 juwai_expired(true)
 juwai_desktop_proxy_screenshot(null)
 juwai_mobile_proxy_screenshot(null)
 capture_processing(false)
 capture_error(empty)
 Image(array)
 0(array)
 id19841
 modelProperty
 model_id3573
 tagImage
 name34705.jpg
 typeimage/jpg
 size967196
 uri/assets/19841.jpg
 order2742
 created2016-04-07 17:25:11
 modified2016-04-07 17:25:11
 1(array)
 id19842
 modelProperty
 model_id3573
 tagImage
 name34706.jpg
 typeimage/jpg
 size516188
 uri/assets/19842.jpg
 order2743
 created2016-04-07 17:25:11
 modified2016-04-07 17:25:11
 2(array)
 id19843
 modelProperty
 model_id3573
 tagImage
 name34707.jpg
 typeimage/jpg
 size720538
 uri/assets/19843.jpg
 order2744
 created2016-04-07 17:25:11
 modified2016-04-07 17:25:11
 3(array)
 id19844
 modelProperty
 model_id3573
 tagImage
 name34708.jpg
 typeimage/jpg
 size720424
 uri/assets/19844.jpg
 order2745
 created2016-04-07 17:25:11
 modified2016-04-07 17:25:11
 4(array)
 id19845
 modelProperty
 model_id3573
 tagImage
 name34709.jpg
 typeimage/jpg
 size660855
 uri/assets/19845.jpg
 order2746
 created2016-04-07 17:25:11
 modified2016-04-07 17:25:11
 5(array)
 id19846
 modelProperty
 model_id3573
 tagImage
 name34710.jpg
 typeimage/jpg
 size723460
 uri/assets/19846.jpg
 order2747
 created2016-04-07 17:25:11
 modified2016-04-07 17:25:11
 6(array)
 id19847
 modelProperty
 model_id3573
 tagImage
 name34711.jpg
 typeimage/jpg
 size722866
 uri/assets/19847.jpg
 order2748
 created2016-04-07 17:25:11
 modified2016-04-07 17:25:11
 7(array)
 id19848
 modelProperty
 model_id3573
 tagImage
 name34712.jpg
 typeimage/jpg
 size797565
 uri/assets/19848.jpg
 order2749
 created2016-04-07 17:25:11
 modified2016-04-07 17:25:11
 8(array)
 id19849
 modelProperty
 model_id3573
 tagImage
 name34713.jpg
 typeimage/jpg
 size645756
 uri/assets/19849.jpg
 order2750
 created2016-04-07 17:25:11
 modified2016-04-07 17:25:11
 9(array)
 id19850
 modelProperty
 model_id3573
 tagImage
 name34714.jpg
 typeimage/jpg
 size414875
 uri/assets/19850.jpg
 order2751
 created2016-04-07 17:25:11
 modified2016-04-07 17:25:11
 User(array)
 0(array)
 id635
 typeAgent
 brokerage_id198
 email[email protected]
 password1e9087fd209c002c2f47bc09f863dcebbb4b4556
 recover_hash
 first_nameShelly
 last_nameSprinkman
 title
 dre_num
 phone608-220-1453
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:12
 created2017-08-07 15:23:12
 notified(false)
 full_nameShelly Sprinkman
 uri/agent-detail/635/shelly-sprinkman
 profile_complete(true)
 UsersProperty(array)
 id430
 user_id635
 property_id3573
 sort_order0
 SecondaryPropertyCategory(empty)
 PropertyFeature(empty)
 Topic(empty)
 2(array)
 Property(array)
 id2585
 brokerage_id198
 created_by_user_id0
 order0
 multi_unit(false)
 agent_1_id428
 agent_2_id795
 agent_3_id796
 name7240 Clover Hill Drive, Middleton, WI
 incomplete(false)
 archived(false)
 last_archived0000-00-00 00:00:00
 auto_archived_from_mlsidx(false)
 paid_featured(false)
 featured(true)
 homepage_featured(true)
 brokerage_page_featured(true)
 requested_homepage_featured_by_member(false)
 homepage_featured_by_member(false)
 dot_luxury_featured(false)
 luxury_feed_featured(false)
 force_luxury_feed_featured(false)
 luxury_autofeed_imported(false)
 luxury_feed_last_added_time0000-00-00 00:00:00
 luxury_feed_agent_user_id0
 luxury_feed_locked_to_subscription_id0
 luxury_feed_agent_purchase_date0000-00-00
 luxury_feed_agent_expiration_date0000-00-00
 digital_ad_summary_email_last_sent0000-00-00 00:00:00
 digital_ad_summary_price_changed(false)
 wsj_detail_url
 ft_detail_url
 nyt_detail_url
 juwai_detail_url
 pgl_detail_url
 mg_detail_url
 mg_c_detail_url
 mg_s_detail_url
 bp_detail_url
 mw_detail_url
 nikkei_detail_url
 wapo_detail_url
 robb_detail_url
 medium_featured(true)
 large_featured(false)
 detail_page(true)
 descriptionLive in a work of art! This exceptional home, designed by a Taliesin architect, exists in perfect harmony with the stunning land it rests on. Following Frank Lloyd Wright’s philosophy of organic architecture, the home flows beautifully both inside and out with an openness and abundance of natural material giving it an inviting warmth in all seasons. The details of the home inspire, as well: A remodeled kitchen features top-of-the-line appliances and finishes, a stone hearth opens to the living and dining rooms and all the living spaces look out onto the serene, private landscape. 
 address7240 Clover Hill Drive
 address_2
 cityMiddleton
 stateWI
 postal_code53597
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price650000
 price_20
 price_usd650000
 price_usd_20
 statusFor Sale
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(false)
 bedrooms3
 bedrooms_20
 bathrooms2
 bathrooms_20
 no_beds_baths(false)
 square_feet0
 square_meters
 acres3
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size3
 icon_1acreage
 icon_2garage
 icon_3views
 icon_4
 icon_5
 icon_6
 websitehttp://madison-homes.sprinkmanrealestate.com/idx/details/listing/a162/1752983/7240-Clover-Hill-Dr-Springfield-Wisconsin-53597-1752983
 meta_title7240 Clover Hill Drive, Middleton, WI | Middleton Real Estate | Sprinkman Real Estate
 meta_description7240 Clover Hill Drive is a property offered for sale in Middleton, WI, USA, presented by Sprinkman Real Estate
 meta_keywords
 bathrooms_partial1
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built
 virtual_tourhttps://my.matterport.com/show/?m=Dqp1Y2G6qBg
 video_tour
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num
 wsj_property_type
 nyt_property_type
 nyt_popular_features
 propgolux_property_type
 juwai_property_type
 juwai_category
 propgolux_property_style
 wapo_property_type
 robb_property_type
 propgolux_location_id_override
 open_house_1_start0000-00-00 00:00:00
 open_house_1_end_time00:00:00
 latitude0.000000
 longitude0.000000
 invalid_required_fieldslatitude, longitude
 invalid_optional_fieldssquare_feet, square_meters, hectares, year_built, video_tour, wsj_property_type, nyt_property_type
 went_live_today(false)
 converted(true)
 invalid(false)
 mlsidx_full_address
 mlsidx_date_listed0000-00-00
 mls_market
 primary_property_category_id0
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated(null)
 modified2016-04-18 05:33:02
 created2015-08-04 11:56:50
 uri/property-detail/2585/7240-clover-hill-drive-middleton-wi-53597-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/2585/7240-clover-hill-drive-middleton-wi-53597-usa
 address_concat7240 Clover Hill Drive Middleton WI 53597 USA
 google_maps_query_string7240+Clover+Hill+Drive++Middleton+WI+53597+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 650,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty3
 bathrooms_pretty2
 bathrooms_partial_pretty1
 bathrooms_3_4_pretty0
 feed_full_bathrooms2
 date_listed2015-08-04
 overridden_brokerage_nameSprinkman Real Estate
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 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_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2[email protected]
 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
 StripeSubscription(array)
 id(null)
 brokerage_id(null)
 user_id(null)
 property_id(null)
 type(null)
 stripe_id(null)
 stripe_customer_id(null)
 stripe_checkout_email(null)
 stripe_promotion_code(null)
 stripe_promotion_code_id(null)
 stripe_coupon_code_id(null)
 status(null)
 current_period_end(null)
 cancel_at_period_end(null)
 ended(null)
 last_change(null)
 last_activity_email_sent(null)
 created(null)
 modified(null)
 GlobalReachReport(array)
 id(null)
 property_id(null)
 wsj_desktop(null)
 wsj_mobile(null)
 wsj_expires(null)
 wsj_capture_started(null)
 mg_desktop(null)
 mg_mobile(null)
 mg_expires(null)
 mg_capture_started(null)
 bp_desktop(null)
 bp_mobile(null)
 bp_expires(null)
 gp_capture_started(null)
 mw_desktop(null)
 mw_mobile(null)
 mw_expires(null)
 mw_capture_started(null)
 ft_desktop(null)
 ft_mobile(null)
 ft_expires(null)
 ft_capture_started(null)
 nikkei_desktop(null)
 nikkei_mobile(null)
 nikkei_expires(null)
 nikkei_capture_started(null)
 pgl_desktop(null)
 pgl_mobile(null)
 pgl_expires(null)
 pgl_capture_started(null)
 robb_desktop(null)
 robb_mobile(null)
 robb_expires(null)
 robb_capture_started(null)
 juwai_desktop(null)
 juwai_mobile(null)
 juwai_expires(null)
 juwai_capture_started(null)
 leverage_desktop(null)
 leverage_mobile(null)
 leverage_expires(null)
 leverage_capture_started(null)
 created(null)
 modified(null)
 wsj_available(false)
 wsj_expired(true)
 wsj_desktop_proxy_screenshot(null)
 wsj_mobile_proxy_screenshot(null)
 mg_available(false)
 mg_expired(true)
 mg_desktop_proxy_screenshot(null)
 mg_mobile_proxy_screenshot(null)
 bp_available(false)
 bp_expired(true)
 bp_desktop_proxy_screenshot(null)
 bp_mobile_proxy_screenshot(null)
 mw_available(false)
 mw_expired(true)
 mw_desktop_proxy_screenshot(null)
 mw_mobile_proxy_screenshot(null)
 nikkei_available(false)
 nikkei_expired(true)
 nikkei_desktop_proxy_screenshot(null)
 nikkei_mobile_proxy_screenshot(null)
 pgl_available(false)
 pgl_expired(true)
 pgl_desktop_proxy_screenshot(null)
 pgl_mobile_proxy_screenshot(null)
 robb_available(false)
 robb_expired(true)
 robb_desktop_proxy_screenshot(null)
 robb_mobile_proxy_screenshot(null)
 juwai_available(false)
 juwai_expired(true)
 juwai_desktop_proxy_screenshot(null)
 juwai_mobile_proxy_screenshot(null)
 capture_processing(false)
 capture_error(empty)
 Image(array)
 0(array)
 id16051
 modelProperty
 model_id2585
 tagImage
 name24158.jpg
 typeimage/jpg
 size1006655
 uri/assets/16051.jpg
 order0
 created2016-04-07 16:56:02
 modified2016-04-07 16:56:02
 1(array)
 id16048
 modelProperty
 model_id2585
 tagImage
 name24155.jpg
 typeimage/jpg
 size945943
 uri/assets/16048.jpg
 order1
 created2016-04-07 16:56:02
 modified2016-04-07 16:56:02
 2(array)
 id16049
 modelProperty
 model_id2585
 tagImage
 name24156.jpg
 typeimage/jpg
 size1554746
 uri/assets/16049.jpg
 order2
 created2016-04-07 16:56:02
 modified2016-04-07 16:56:02
 3(array)
 id16046
 modelProperty
 model_id2585
 tagImage
 name24153.jpg
 typeimage/jpg
 size2031010
 uri/assets/16046.jpg
 order3
 created2016-04-07 16:56:02
 modified2016-04-07 16:56:02
 4(array)
 id16047
 modelProperty
 model_id2585
 tagImage
 name24154.jpg
 typeimage/jpg
 size1445390
 uri/assets/16047.jpg
 order4
 created2016-04-07 16:56:02
 modified2016-04-07 16:56:02
 5(array)
 id16050
 modelProperty
 model_id2585
 tagImage
 name24157.jpg
 typeimage/jpg
 size1627037
 uri/assets/16050.jpg
 order5
 created2016-04-07 16:56:02
 modified2016-04-07 16:56:02
 6(array)
 id16052
 modelProperty
 model_id2585
 tagImage
 name24159.jpg
 typeimage/jpg
 size1201182
 uri/assets/16052.jpg
 order6
 created2016-04-07 16:56:02
 modified2016-04-07 16:56:02
 7(array)
 id16053
 modelProperty
 model_id2585
 tagImage
 name24160.jpg
 typeimage/jpg
 size1347979
 uri/assets/16053.jpg
 order7
 created2016-04-07 16:56:02
 modified2016-04-07 16:56:02
 8(array)
 id16054
 modelProperty
 model_id2585
 tagImage
 name24161.jpg
 typeimage/jpg
 size1915387
 uri/assets/16054.jpg
 order8
 created2016-04-07 16:56:02
 modified2016-04-07 16:56:02
 User(array)
 0(array)
 id635
 typeAgent
 brokerage_id198
 email[email protected]
 password1e9087fd209c002c2f47bc09f863dcebbb4b4556
 recover_hash
 first_nameShelly
 last_nameSprinkman
 title
 dre_num
 phone608-220-1453
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:12
 created2017-08-07 15:23:12
 notified(false)
 full_nameShelly Sprinkman
 uri/agent-detail/635/shelly-sprinkman
 profile_complete(true)
 UsersProperty(array)
 id426
 user_id635
 property_id2585
 sort_order0
 1(array)
 id984
 typeAgent
 brokerage_id198
 email[email protected]
 password062300d71e48409bbb7ad581ecc4166ad25ff6d6
 recover_hash
 first_nameRyan
 last_nameBrown
 title
 dre_num
 phone608-338-7440
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:47
 created2017-08-07 15:23:47
 notified(false)
 full_nameRyan Brown
 uri/agent-detail/984/ryan-brown
 profile_complete(true)
 UsersProperty(array)
 id738
 user_id984
 property_id2585
 sort_order0
 2(array)
 id985
 typeAgent
 brokerage_id198
 email[email protected]
 password457a2e79b260dbd3c9f8e31e12ae757acd8199d0
 recover_hash
 first_nameJulie
 last_nameBernauer
 title
 dre_num
 phone608-219-6492
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:47
 created2017-08-07 15:23:47
 notified(false)
 full_nameJulie Bernauer
 uri/agent-detail/985/julie-bernauer
 profile_complete(true)
 UsersProperty(array)
 id740
 user_id985
 property_id2585
 sort_order0
 SecondaryPropertyCategory(empty)
 PropertyFeature(array)
 0(array)
 id4
 nameGarage
 additional(false)
 created2016-04-07 14:01:52
 modified2016-04-07 14:01:52
 PropertiesPropertyFeature(array)
 id3307
 property_id2585
 property_feature_id4
 1(array)
 id14
 nameViews
 additional(false)
 created2016-04-07 14:04:55
 modified2016-04-07 14:04:55
 PropertiesPropertyFeature(array)
 id3308
 property_id2585
 property_feature_id14
 Topic(empty)
 3(array)
 Property(array)
 id3603
 brokerage_id198
 created_by_user_id0
 order0
 multi_unit(false)
 agent_1_id428
 agent_2_id0
 agent_3_id0
 name432 Farwell Dr. Maple Bluff, WI
 incomplete(false)
 archived(false)
 last_archived0000-00-00 00:00:00
 auto_archived_from_mlsidx(false)
 paid_featured(false)
 featured(true)
 homepage_featured(false)
 brokerage_page_featured(true)
 requested_homepage_featured_by_member(false)
 homepage_featured_by_member(false)
 dot_luxury_featured(false)
 luxury_feed_featured(false)
 force_luxury_feed_featured(false)
 luxury_autofeed_imported(false)
 luxury_feed_last_added_time0000-00-00 00:00:00
 luxury_feed_agent_user_id0
 luxury_feed_locked_to_subscription_id0
 luxury_feed_agent_purchase_date0000-00-00
 luxury_feed_agent_expiration_date0000-00-00
 digital_ad_summary_email_last_sent0000-00-00 00:00:00
 digital_ad_summary_price_changed(false)
 wsj_detail_url
 ft_detail_url
 nyt_detail_url
 juwai_detail_url
 pgl_detail_url
 mg_detail_url
 mg_c_detail_url
 mg_s_detail_url
 bp_detail_url
 mw_detail_url
 nikkei_detail_url
 wapo_detail_url
 robb_detail_url
 medium_featured(false)
 large_featured(false)
 detail_page(true)
 descriptionThis stately French Provincial manor in Maple Bluff welcomes you in with understated formality and elegant details. A formal living room with marble floors and fireplace looks out over the stone patio and large yard and leads into the spacious dining room with its stunning chandelier. The remodeled kitchen w/high end appliances features a breakfast bar that opens to the family room featuring an impressive stone fireplace. A finished lower level with a built in bar is great for family fun + a 3 car garage.
 address432 Farwell Dr
 address_2
 cityMaple Bluff
 stateWI
 postal_code53704
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price850000
 price_20
 price_usd850000
 price_usd_20
 statusFor Sale
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(false)
 bedrooms4
 bedrooms_20
 bathrooms3
 bathrooms_20
 no_beds_baths(false)
 square_feet0
 square_meters
 acres0
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size0
 icon_1
 icon_2
 icon_3
 icon_4
 icon_5
 icon_6
 websitehttp://madison-homes.sprinkmanrealestate.com/idx/details/listing/a162/1769357/432-Farwell-Dr-Maple-Bluff-Wisconsin-53704-1769357
 meta_title432 Farwell Dr. Maple Bluff, WI | Maple Bluff Real Estate | Sprinkman Real Estate
 meta_description432 Farwell Dr is a property offered for sale in Maple Bluff, WI, USA, presented by Sprinkman Real Estate
 meta_keywords
 bathrooms_partial1
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built
 virtual_tour
 video_tourhttps://www.youtube.com/watch?v=d53cDu6UhwA
 digital_brochure
 video_tour_embed_code<iframe width="560" height="315" src="https://www.youtube.com/embed/d53cDu6UhwA?controls=0&showinfo=0" frameborder="0" allowfullscreen></iframe>
 digital_brochure_embed_code
 mls_num
 wsj_property_type
 nyt_property_type
 nyt_popular_features
 propgolux_property_type
 juwai_property_type
 juwai_category
 propgolux_property_style
 wapo_property_type
 robb_property_type
 propgolux_location_id_override
 open_house_1_start0000-00-00 00:00:00
 open_house_1_end_time00:00:00
 latitude0.000000
 longitude0.000000
 invalid_required_fieldslatitude, longitude
 invalid_optional_fieldsagent_2_id, square_feet, square_meters, acres, hectares, year_built, virtual_tour, wsj_property_type, nyt_property_type, propgolux_property_type, propgolux_property_style
 went_live_today(false)
 converted(true)
 invalid(false)
 mlsidx_full_address
 mlsidx_date_listed0000-00-00
 mls_market
 primary_property_category_id0
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated(null)
 modified2016-04-18 05:33:03
 created2016-03-17 07:39:21
 uri/property-detail/3603/432-farwell-dr-maple-bluff-wi-53704-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3603/432-farwell-dr-maple-bluff-wi-53704-usa
 address_concat432 Farwell Dr Maple Bluff WI 53704 USA
 google_maps_query_string432+Farwell+Dr++Maple+Bluff+WI+53704+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 850,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty4
 bathrooms_pretty3
 bathrooms_partial_pretty1
 bathrooms_3_4_pretty0
 feed_full_bathrooms3
 date_listed2016-03-17
 overridden_brokerage_nameSprinkman Real Estate
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 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_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2[email protected]
 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
 StripeSubscription(array)
 id(null)
 brokerage_id(null)
 user_id(null)
 property_id(null)
 type(null)
 stripe_id(null)
 stripe_customer_id(null)
 stripe_checkout_email(null)
 stripe_promotion_code(null)
 stripe_promotion_code_id(null)
 stripe_coupon_code_id(null)
 status(null)
 current_period_end(null)
 cancel_at_period_end(null)
 ended(null)
 last_change(null)
 last_activity_email_sent(null)
 created(null)
 modified(null)
 GlobalReachReport(array)
 id(null)
 property_id(null)
 wsj_desktop(null)
 wsj_mobile(null)
 wsj_expires(null)
 wsj_capture_started(null)
 mg_desktop(null)
 mg_mobile(null)
 mg_expires(null)
 mg_capture_started(null)
 bp_desktop(null)
 bp_mobile(null)
 bp_expires(null)
 gp_capture_started(null)
 mw_desktop(null)
 mw_mobile(null)
 mw_expires(null)
 mw_capture_started(null)
 ft_desktop(null)
 ft_mobile(null)
 ft_expires(null)
 ft_capture_started(null)
 nikkei_desktop(null)
 nikkei_mobile(null)
 nikkei_expires(null)
 nikkei_capture_started(null)
 pgl_desktop(null)
 pgl_mobile(null)
 pgl_expires(null)
 pgl_capture_started(null)
 robb_desktop(null)
 robb_mobile(null)
 robb_expires(null)
 robb_capture_started(null)
 juwai_desktop(null)
 juwai_mobile(null)
 juwai_expires(null)
 juwai_capture_started(null)
 leverage_desktop(null)
 leverage_mobile(null)
 leverage_expires(null)
 leverage_capture_started(null)
 created(null)
 modified(null)
 wsj_available(false)
 wsj_expired(true)
 wsj_desktop_proxy_screenshot(null)
 wsj_mobile_proxy_screenshot(null)
 mg_available(false)
 mg_expired(true)
 mg_desktop_proxy_screenshot(null)
 mg_mobile_proxy_screenshot(null)
 bp_available(false)
 bp_expired(true)
 bp_desktop_proxy_screenshot(null)
 bp_mobile_proxy_screenshot(null)
 mw_available(false)
 mw_expired(true)
 mw_desktop_proxy_screenshot(null)
 mw_mobile_proxy_screenshot(null)
 nikkei_available(false)
 nikkei_expired(true)
 nikkei_desktop_proxy_screenshot(null)
 nikkei_mobile_proxy_screenshot(null)
 pgl_available(false)
 pgl_expired(true)
 pgl_desktop_proxy_screenshot(null)
 pgl_mobile_proxy_screenshot(null)
 robb_available(false)
 robb_expired(true)
 robb_desktop_proxy_screenshot(null)
 robb_mobile_proxy_screenshot(null)
 juwai_available(false)
 juwai_expired(true)
 juwai_desktop_proxy_screenshot(null)
 juwai_mobile_proxy_screenshot(null)
 capture_processing(false)
 capture_error(empty)
 Image(array)
 0(array)
 id19175
 modelProperty
 model_id3603
 tagImage
 name35004.jpg
 typeimage/jpg
 size770464
 uri/assets/19175.jpg
 order2762
 created2016-04-07 17:14:07
 modified2016-04-07 17:14:08
 1(array)
 id19176
 modelProperty
 model_id3603
 tagImage
 name35005.jpg
 typeimage/jpg
 size977786
 uri/assets/19176.jpg
 order2763
 created2016-04-07 17:14:08
 modified2016-04-07 17:14:08
 2(array)
 id19177
 modelProperty
 model_id3603
 tagImage
 name35006.jpg
 typeimage/jpg
 size749812
 uri/assets/19177.jpg
 order2764
 created2016-04-07 17:14:08
 modified2016-04-07 17:14:08
 3(array)
 id19178
 modelProperty
 model_id3603
 tagImage
 name35007.jpg
 typeimage/jpg
 size476229
 uri/assets/19178.jpg
 order2765
 created2016-04-07 17:14:08
 modified2016-04-07 17:14:08
 4(array)
 id19179
 modelProperty
 model_id3603
 tagImage
 name35008.jpg
 typeimage/jpg
 size523084
 uri/assets/19179.jpg
 order2766
 created2016-04-07 17:14:08
 modified2016-04-07 17:14:08
 5(array)
 id19180
 modelProperty
 model_id3603
 tagImage
 name35009.jpg
 typeimage/jpg
 size452955
 uri/assets/19180.jpg
 order2767
 created2016-04-07 17:14:08
 modified2016-04-07 17:14:08
 6(array)
 id19181
 modelProperty
 model_id3603
 tagImage
 name35010.jpg
 typeimage/jpg
 size395050
 uri/assets/19181.jpg
 order2768
 created2016-04-07 17:14:08
 modified2016-04-07 17:14:08
 7(array)
 id19182
 modelProperty
 model_id3603
 tagImage
 name35011.jpg
 typeimage/jpg
 size529892
 uri/assets/19182.jpg
 order2769
 created2016-04-07 17:14:08
 modified2016-04-07 17:14:08
 8(array)
 id19183
 modelProperty
 model_id3603
 tagImage
 name35012.jpg
 typeimage/jpg
 size348123
 uri/assets/19183.jpg
 order2770
 created2016-04-07 17:14:08
 modified2016-04-07 17:14:08
 9(array)
 id19184
 modelProperty
 model_id3603
 tagImage
 name35013.jpg
 typeimage/jpg
 size429478
 uri/assets/19184.jpg
 order2771
 created2016-04-07 17:14:08
 modified2016-04-07 17:14:08
 User(array)
 0(array)
 id635
 typeAgent
 brokerage_id198
 email[email protected]
 password1e9087fd209c002c2f47bc09f863dcebbb4b4556
 recover_hash
 first_nameShelly
 last_nameSprinkman
 title
 dre_num
 phone608-220-1453
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:12
 created2017-08-07 15:23:12
 notified(false)
 full_nameShelly Sprinkman
 uri/agent-detail/635/shelly-sprinkman
 profile_complete(true)
 UsersProperty(array)
 id427
 user_id635
 property_id3603
 sort_order0
 SecondaryPropertyCategory(empty)
 PropertyFeature(empty)
 Topic(empty)
- sidebar_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_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2[email protected]
 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
- highlighted_properties(array)
 0(array)
 Property(array)
 id2713
 brokerage_id198
 created_by_user_id0
 order0
 multi_unit(false)
 agent_1_id428
 agent_2_id796
 agent_3_id0
 name403 Farwell Drive, Madison, WI 53704
 incomplete(false)
 archived(false)
 last_archived0000-00-00 00:00:00
 auto_archived_from_mlsidx(false)
 paid_featured(false)
 featured(true)
 homepage_featured(true)
 brokerage_page_featured(true)
 requested_homepage_featured_by_member(false)
 homepage_featured_by_member(false)
 dot_luxury_featured(false)
 luxury_feed_featured(false)
 force_luxury_feed_featured(false)
 luxury_autofeed_imported(false)
 luxury_feed_last_added_time0000-00-00 00:00:00
 luxury_feed_agent_user_id0
 luxury_feed_locked_to_subscription_id0
 luxury_feed_agent_purchase_date0000-00-00
 luxury_feed_agent_expiration_date0000-00-00
 digital_ad_summary_email_last_sent0000-00-00 00:00:00
 digital_ad_summary_price_changed(false)
 wsj_detail_url
 ft_detail_url
 nyt_detail_url
 juwai_detail_url
 pgl_detail_url
 mg_detail_url
 mg_c_detail_url
 mg_s_detail_url
 bp_detail_url
 mw_detail_url
 nikkei_detail_url
 wapo_detail_url
 robb_detail_url
 medium_featured(false)
 large_featured(false)
 detail_page(true)
 descriptionThis beautiful home makes the most of it’s gorgeous setting on 125’ feet of prime, level lake frontage with a Capitol view. Luxuriate in lake views year-round from the living areas and impressive master suite complete with a private deck, spa bath with sauna and sitting area. The details throughout - coffered ceilings, honed granite, marble fireplaces, pristine woodwork, high-end appliances, home theater and a 4+ car garage with an indoor basketball court will never cease to please. This is the home you deserve!
 address403 Farwell Drive
 address_2
 cityMadison
 stateWI
 postal_code53704
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price2500000
 price_20
 price_usd2500000
 price_usd_20
 statusFor Sale
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(false)
 bedrooms5
 bedrooms_20
 bathrooms4
 bathrooms_20
 no_beds_baths(false)
 square_feet0
 square_meters
 acres0
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size0
 icon_1waterfront
 icon_2office
 icon_3dock
 icon_4views
 icon_5media-room
 icon_6garage
 websitehttp://madison-homes.sprinkmanrealestate.com/idx/details/listing/a162/1755334/403-Farwell-Dr-Maple-Bluff-Wisconsin-53704-1755334
 meta_title403 Farwell Drive, Madison, WI 53704 | Madison Real Estate | Sprinkman Real Estate
 meta_description403 Farwell Drive is a property offered for sale in Madison, WI, USA, presented by Sprinkman Real Estate
 meta_keywords
 bathrooms_partial0
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built1935
 virtual_tourhttp://sprinkmanrealestate.com/3d-model/403-farewell-dr/
 video_tour
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num1755334
 wsj_property_typesingle family
 nyt_property_type1
 nyt_popular_features
 propgolux_property_type9
 juwai_property_type
 juwai_category
 propgolux_property_style20
 wapo_property_type
 robb_property_type
 propgolux_location_id_override
 open_house_1_start0000-00-00 00:00:00
 open_house_1_end_time00:00:00
 latitude43.113411
 longitude-89.374825
 invalid_required_fields
 invalid_optional_fieldsbathrooms_partial, square_feet, square_meters, acres, hectares, video_tour
 went_live_today(false)
 converted(true)
 invalid(false)
 mlsidx_full_address
 mlsidx_date_listed0000-00-00
 mls_market
 primary_property_category_id0
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated(null)
 modified2016-04-18 05:33:02
 created2015-08-31 11:52:16
 uri/property-detail/2713/403-farwell-drive-madison-wi-53704-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/2713/403-farwell-drive-madison-wi-53704-usa
 address_concat403 Farwell Drive Madison WI 53704 USA
 google_maps_query_string403+Farwell+Drive++Madison+WI+53704+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 2,500,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty5
 bathrooms_pretty4
 bathrooms_partial_pretty0
 bathrooms_3_4_pretty0
 feed_full_bathrooms4
 date_listed2015-08-31
 overridden_brokerage_nameSprinkman Real Estate
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 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_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2[email protected]
 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
 StripeSubscription(array)
 id(null)
 brokerage_id(null)
 user_id(null)
 property_id(null)
 type(null)
 stripe_id(null)
 stripe_customer_id(null)
 stripe_checkout_email(null)
 stripe_promotion_code(null)
 stripe_promotion_code_id(null)
 stripe_coupon_code_id(null)
 status(null)
 current_period_end(null)
 cancel_at_period_end(null)
 ended(null)
 last_change(null)
 last_activity_email_sent(null)
 created(null)
 modified(null)
 GlobalReachReport(array)
 id(null)
 property_id(null)
 wsj_desktop(null)
 wsj_mobile(null)
 wsj_expires(null)
 wsj_capture_started(null)
 mg_desktop(null)
 mg_mobile(null)
 mg_expires(null)
 mg_capture_started(null)
 bp_desktop(null)
 bp_mobile(null)
 bp_expires(null)
 gp_capture_started(null)
 mw_desktop(null)
 mw_mobile(null)
 mw_expires(null)
 mw_capture_started(null)
 ft_desktop(null)
 ft_mobile(null)
 ft_expires(null)
 ft_capture_started(null)
 nikkei_desktop(null)
 nikkei_mobile(null)
 nikkei_expires(null)
 nikkei_capture_started(null)
 pgl_desktop(null)
 pgl_mobile(null)
 pgl_expires(null)
 pgl_capture_started(null)
 robb_desktop(null)
 robb_mobile(null)
 robb_expires(null)
 robb_capture_started(null)
 juwai_desktop(null)
 juwai_mobile(null)
 juwai_expires(null)
 juwai_capture_started(null)
 leverage_desktop(null)
 leverage_mobile(null)
 leverage_expires(null)
 leverage_capture_started(null)
 created(null)
 modified(null)
 wsj_available(false)
 wsj_expired(true)
 wsj_desktop_proxy_screenshot(null)
 wsj_mobile_proxy_screenshot(null)
 mg_available(false)
 mg_expired(true)
 mg_desktop_proxy_screenshot(null)
 mg_mobile_proxy_screenshot(null)
 bp_available(false)
 bp_expired(true)
 bp_desktop_proxy_screenshot(null)
 bp_mobile_proxy_screenshot(null)
 mw_available(false)
 mw_expired(true)
 mw_desktop_proxy_screenshot(null)
 mw_mobile_proxy_screenshot(null)
 nikkei_available(false)
 nikkei_expired(true)
 nikkei_desktop_proxy_screenshot(null)
 nikkei_mobile_proxy_screenshot(null)
 pgl_available(false)
 pgl_expired(true)
 pgl_desktop_proxy_screenshot(null)
 pgl_mobile_proxy_screenshot(null)
 robb_available(false)
 robb_expired(true)
 robb_desktop_proxy_screenshot(null)
 robb_mobile_proxy_screenshot(null)
 juwai_available(false)
 juwai_expired(true)
 juwai_desktop_proxy_screenshot(null)
 juwai_mobile_proxy_screenshot(null)
 capture_processing(false)
 capture_error(empty)
 Image(array)
 0(array)
 id14454
 modelProperty
 model_id2713
 tagImage
 name25648.jpg
 typeimage/jpg
 size469082
 uri/assets/14454.jpg
 order0
 created2016-04-07 16:46:02
 modified2016-04-07 16:46:02
 1(array)
 id14456
 modelProperty
 model_id2713
 tagImage
 name25646.jpg
 typeimage/jpg
 size909140
 uri/assets/14456.jpg
 order1
 created2016-04-07 16:46:02
 modified2016-04-07 16:46:02
 2(array)
 id14455
 modelProperty
 model_id2713
 tagImage
 name25647.jpg
 typeimage/jpg
 size822043
 uri/assets/14455.jpg
 order2
 created2016-04-07 16:46:02
 modified2016-04-07 16:46:02
 3(array)
 id14450
 modelProperty
 model_id2713
 tagImage
 name31321.jpg
 typeimage/jpg
 size548708
 uri/assets/14450.jpg
 order3
 created2016-04-07 16:46:02
 modified2016-04-07 16:46:02
 4(array)
 id14451
 modelProperty
 model_id2713
 tagImage
 name25651.jpg
 typeimage/jpg
 size608682
 uri/assets/14451.jpg
 order4
 created2016-04-07 16:46:02
 modified2016-04-07 16:46:02
 5(array)
 id14453
 modelProperty
 model_id2713
 tagImage
 name25649.jpg
 typeimage/jpg
 size375611
 uri/assets/14453.jpg
 order5
 created2016-04-07 16:46:02
 modified2016-04-07 16:46:02
 6(array)
 id14452
 modelProperty
 model_id2713
 tagImage
 name25657.jpg
 typeimage/jpg
 size457165
 uri/assets/14452.jpg
 order6
 created2016-04-07 16:46:02
 modified2016-04-07 16:46:02
 7(array)
 id14449
 modelProperty
 model_id2713
 tagImage
 name25654.jpg
 typeimage/jpg
 size454416
 uri/assets/14449.jpg
 order7
 created2016-04-07 16:46:02
 modified2016-04-07 16:46:02
 8(array)
 id14448
 modelProperty
 model_id2713
 tagImage
 name25655.jpg
 typeimage/jpg
 size378992
 uri/assets/14448.jpg
 order8
 created2016-04-07 16:46:02
 modified2016-04-07 16:46:02
 9(array)
 id14447
 modelProperty
 model_id2713
 tagImage
 name25656.jpg
 typeimage/jpg
 size521227
 uri/assets/14447.jpg
 order9
 created2016-04-07 16:46:02
 modified2016-04-07 16:46:02
 User(array)
 0(array)
 id635
 typeAgent
 brokerage_id198
 email[email protected]
 password1e9087fd209c002c2f47bc09f863dcebbb4b4556
 recover_hash
 first_nameShelly
 last_nameSprinkman
 title
 dre_num
 phone608-220-1453
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:12
 created2017-08-07 15:23:12
 notified(false)
 full_nameShelly Sprinkman
 uri/agent-detail/635/shelly-sprinkman
 profile_complete(true)
 UsersProperty(array)
 id425
 user_id635
 property_id2713
 sort_order0
 1(array)
 id985
 typeAgent
 brokerage_id198
 email[email protected]
 password457a2e79b260dbd3c9f8e31e12ae757acd8199d0
 recover_hash
 first_nameJulie
 last_nameBernauer
 title
 dre_num
 phone608-219-6492
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:47
 created2017-08-07 15:23:47
 notified(false)
 full_nameJulie Bernauer
 uri/agent-detail/985/julie-bernauer
 profile_complete(true)
 UsersProperty(array)
 id739
 user_id985
 property_id2713
 sort_order0
 SecondaryPropertyCategory(empty)
 PropertyFeature(array)
 0(array)
 id17
 nameWaterfront
 additional(false)
 created2016-04-07 14:06:00
 modified2016-04-07 14:06:00
 PropertiesPropertyFeature(array)
 id2868
 property_id2713
 property_feature_id17
 1(array)
 id9
 nameOffice
 additional(false)
 created2016-04-07 14:03:21
 modified2016-04-07 14:03:21
 PropertiesPropertyFeature(array)
 id2869
 property_id2713
 property_feature_id9
 2(array)
 id3
 nameDock
 additional(false)
 created2016-04-07 14:01:13
 modified2016-04-07 14:01:13
 PropertiesPropertyFeature(array)
 id2870
 property_id2713
 property_feature_id3
 3(array)
 id14
 nameViews
 additional(false)
 created2016-04-07 14:04:55
 modified2016-04-07 14:04:55
 PropertiesPropertyFeature(array)
 id2871
 property_id2713
 property_feature_id14
 4(array)
 id8
 nameMedia Room
 additional(false)
 created2016-04-07 14:03:04
 modified2016-04-07 14:03:04
 PropertiesPropertyFeature(array)
 id2872
 property_id2713
 property_feature_id8
 5(array)
 id4
 nameGarage
 additional(false)
 created2016-04-07 14:01:52
 modified2016-04-07 14:01:52
 PropertiesPropertyFeature(array)
 id2873
 property_id2713
 property_feature_id4
 Topic(empty)
 1(array)
 Property(array)
 id3576
 brokerage_id198
 created_by_user_id0
 order0
 multi_unit(false)
 agent_1_id1090
 agent_2_id0
 agent_3_id0
 name 3952 Caribou Rd.
 incomplete(false)
 archived(false)
 last_archived0000-00-00 00:00:00
 auto_archived_from_mlsidx(false)
 paid_featured(false)
 featured(true)
 homepage_featured(false)
 brokerage_page_featured(true)
 requested_homepage_featured_by_member(false)
 homepage_featured_by_member(false)
 dot_luxury_featured(false)
 luxury_feed_featured(true)
 force_luxury_feed_featured(false)
 luxury_autofeed_imported(false)
 luxury_feed_last_added_time0000-00-00 00:00:00
 luxury_feed_agent_user_id0
 luxury_feed_locked_to_subscription_id0
 luxury_feed_agent_purchase_date0000-00-00
 luxury_feed_agent_expiration_date0000-00-00
 digital_ad_summary_email_last_sent0000-00-00 00:00:00
 digital_ad_summary_price_changed(false)
 wsj_detail_url
 ft_detail_url
 nyt_detail_url
 juwai_detail_url
 pgl_detail_url
 mg_detail_url
 mg_c_detail_url
 mg_s_detail_url
 bp_detail_url
 mw_detail_url
 nikkei_detail_url
 wapo_detail_url
 robb_detail_url
 medium_featured(true)
 large_featured(true)
 detail_page(true)
 descriptionClassic beauty. This traditional home does not miss a detail. From its grand setting and views to stunning finishes and open, yet formal design, it is at once welcoming and elegant. Floor to ceiling windows accentuate the view and let the light in, while the kitchen - a chefs dream, the lower level family room which offers casual entertaining space, a gorgeous master suite and main floor office draw the homeowner inside.
 address3952 Caribou Rd.
 address_2
 cityMiddleton
 stateWI
 postal_code53593
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price1175000
 price_20
 price_usd1175000
 price_usd_20
 statusFor Sale
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(false)
 bedrooms6
 bedrooms_20
 bathrooms5
 bathrooms_20
 no_beds_baths(false)
 square_feet0
 square_meters
 acres0
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size0
 icon_1
 icon_2
 icon_3
 icon_4
 icon_5
 icon_6
 websitehttp://madison-homes.sprinkmanrealestate.com/idx/details/listing/a162/1768126/3952-Caribou-Rd-Middleton-Wisconsin-53593-1768126
 meta_title 3952 Caribou Rd. | Middleton Real Estate | Sprinkman Real Estate
 meta_description3952 Caribou Rd. is a property offered for sale in Middleton, WI, USA, presented by Sprinkman Real Estate
 meta_keywords
 bathrooms_partial1
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built2009
 virtual_tourhttps://my.matterport.com/show/?m=Q51JiCMP4e8
 video_tourhttps://www.youtube.com/watch?v=2Ydlz3PK5w8
 digital_brochure
 video_tour_embed_code<iframe width="560" height="315" src="https://www.youtube.com/embed/2Ydlz3PK5w8?controls=0&showinfo=0" frameborder="0" allowfullscreen></iframe>
 digital_brochure_embed_code
 mls_num1768126
 wsj_property_type
 nyt_property_type
 nyt_popular_features
 propgolux_property_type
 juwai_property_type
 juwai_category
 propgolux_property_style
 wapo_property_type
 robb_property_type
 propgolux_location_id_override
 open_house_1_start0000-00-00 00:00:00
 open_house_1_end_time00:00:00
 latitude43.071560
 longitude-89.591606
 invalid_required_fields
 invalid_optional_fieldsagent_2_id, square_feet, square_meters, acres, hectares, wsj_property_type, nyt_property_type, propgolux_property_type, propgolux_property_style
 went_live_today(false)
 converted(true)
 invalid(false)
 mlsidx_full_address
 mlsidx_date_listed0000-00-00
 mls_market
 primary_property_category_id0
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated(null)
 modified2016-04-18 05:33:03
 created2016-03-09 09:29:49
 uri/property-detail/3576/3952-caribou-rd-middleton-wi-53593-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3576/3952-caribou-rd-middleton-wi-53593-usa
 address_concat3952 Caribou Rd. Middleton WI 53593 USA
 google_maps_query_string3952+Caribou+Rd.++Middleton+WI+53593+USA
 luxury_ad_enrolled_prettyYES
 price_prettyUSD 1,175,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty6
 bathrooms_pretty5
 bathrooms_partial_pretty1
 bathrooms_3_4_pretty0
 feed_full_bathrooms5
 date_listed2016-03-09
 overridden_brokerage_nameSprinkman Real Estate
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 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_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2[email protected]
 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
 StripeSubscription(array)
 id(null)
 brokerage_id(null)
 user_id(null)
 property_id(null)
 type(null)
 stripe_id(null)
 stripe_customer_id(null)
 stripe_checkout_email(null)
 stripe_promotion_code(null)
 stripe_promotion_code_id(null)
 stripe_coupon_code_id(null)
 status(null)
 current_period_end(null)
 cancel_at_period_end(null)
 ended(null)
 last_change(null)
 last_activity_email_sent(null)
 created(null)
 modified(null)
 GlobalReachReport(array)
 id(null)
 property_id(null)
 wsj_desktop(null)
 wsj_mobile(null)
 wsj_expires(null)
 wsj_capture_started(null)
 mg_desktop(null)
 mg_mobile(null)
 mg_expires(null)
 mg_capture_started(null)
 bp_desktop(null)
 bp_mobile(null)
 bp_expires(null)
 gp_capture_started(null)
 mw_desktop(null)
 mw_mobile(null)
 mw_expires(null)
 mw_capture_started(null)
 ft_desktop(null)
 ft_mobile(null)
 ft_expires(null)
 ft_capture_started(null)
 nikkei_desktop(null)
 nikkei_mobile(null)
 nikkei_expires(null)
 nikkei_capture_started(null)
 pgl_desktop(null)
 pgl_mobile(null)
 pgl_expires(null)
 pgl_capture_started(null)
 robb_desktop(null)
 robb_mobile(null)
 robb_expires(null)
 robb_capture_started(null)
 juwai_desktop(null)
 juwai_mobile(null)
 juwai_expires(null)
 juwai_capture_started(null)
 leverage_desktop(null)
 leverage_mobile(null)
 leverage_expires(null)
 leverage_capture_started(null)
 created(null)
 modified(null)
 wsj_available(false)
 wsj_expired(true)
 wsj_desktop_proxy_screenshot(null)
 wsj_mobile_proxy_screenshot(null)
 mg_available(false)
 mg_expired(true)
 mg_desktop_proxy_screenshot(null)
 mg_mobile_proxy_screenshot(null)
 bp_available(false)
 bp_expired(true)
 bp_desktop_proxy_screenshot(null)
 bp_mobile_proxy_screenshot(null)
 mw_available(false)
 mw_expired(true)
 mw_desktop_proxy_screenshot(null)
 mw_mobile_proxy_screenshot(null)
 nikkei_available(false)
 nikkei_expired(true)
 nikkei_desktop_proxy_screenshot(null)
 nikkei_mobile_proxy_screenshot(null)
 pgl_available(false)
 pgl_expired(true)
 pgl_desktop_proxy_screenshot(null)
 pgl_mobile_proxy_screenshot(null)
 robb_available(false)
 robb_expired(true)
 robb_desktop_proxy_screenshot(null)
 robb_mobile_proxy_screenshot(null)
 juwai_available(false)
 juwai_expired(true)
 juwai_desktop_proxy_screenshot(null)
 juwai_mobile_proxy_screenshot(null)
 capture_processing(false)
 capture_error(empty)
 Image(array)
 0(array)
 id19864
 modelProperty
 model_id3576
 tagImage
 name34742.jpg
 typeimage/jpg
 size931857
 uri/assets/19864.jpg
 order0
 created2016-04-07 17:25:12
 modified2016-04-07 17:25:12
 1(array)
 id19866
 modelProperty
 model_id3576
 tagImage
 name34744.jpg
 typeimage/jpg
 size559530
 uri/assets/19866.jpg
 order1
 created2016-04-07 17:25:12
 modified2016-04-07 17:25:12
 2(array)
 id19865
 modelProperty
 model_id3576
 tagImage
 name34743.jpg
 typeimage/jpg
 size639942
 uri/assets/19865.jpg
 order2
 created2016-04-07 17:25:12
 modified2016-04-07 17:25:12
 3(array)
 id19870
 modelProperty
 model_id3576
 tagImage
 name34750.jpg
 typeimage/jpg
 size687248
 uri/assets/19870.jpg
 order3
 created2016-04-07 17:25:12
 modified2016-04-07 17:25:12
 4(array)
 id19867
 modelProperty
 model_id3576
 tagImage
 name34745.jpg
 typeimage/jpg
 size581961
 uri/assets/19867.jpg
 order4
 created2016-04-07 17:25:12
 modified2016-04-07 17:25:12
 5(array)
 id19868
 modelProperty
 model_id3576
 tagImage
 name34747.jpg
 typeimage/jpg
 size391278
 uri/assets/19868.jpg
 order5
 created2016-04-07 17:25:12
 modified2016-04-07 17:25:12
 6(array)
 id19869
 modelProperty
 model_id3576
 tagImage
 name34748.jpg
 typeimage/jpg
 size544593
 uri/assets/19869.jpg
 order6
 created2016-04-07 17:25:12
 modified2016-04-07 17:25:12
 7(array)
 id19862
 modelProperty
 model_id3576
 tagImage
 name34740.jpg
 typeimage/jpg
 size449031
 uri/assets/19862.jpg
 order7
 created2016-04-07 17:25:12
 modified2016-04-07 17:25:12
 8(array)
 id19863
 modelProperty
 model_id3576
 tagImage
 name34741.jpg
 typeimage/jpg
 size588660
 uri/assets/19863.jpg
 order8
 created2016-04-07 17:25:12
 modified2016-04-07 17:25:12
 9(array)
 id19861
 modelProperty
 model_id3576
 tagImage
 name34739.jpg
 typeimage/jpg
 size636289
 uri/assets/19861.jpg
 order9
 created2016-04-07 17:25:12
 modified2016-04-07 17:25:12
 User(empty)
 SecondaryPropertyCategory(empty)
 PropertyFeature(empty)
 Topic(empty)
- custom_ga_event_properties(array)
 brokerageSprinkman Real Estate, Madison
- property(array)
 Property(array)
 id2585
 brokerage_id198
 created_by_user_id0
 order0
 multi_unit(false)
 agent_1_id428
 agent_2_id795
 agent_3_id796
 name7240 Clover Hill Drive, Middleton, WI
 incomplete(false)
 archived(false)
 last_archived0000-00-00 00:00:00
 auto_archived_from_mlsidx(false)
 paid_featured(false)
 featured(true)
 homepage_featured(true)
 brokerage_page_featured(true)
 requested_homepage_featured_by_member(false)
 homepage_featured_by_member(false)
 dot_luxury_featured(false)
 luxury_feed_featured(false)
 force_luxury_feed_featured(false)
 luxury_autofeed_imported(false)
 luxury_feed_last_added_time0000-00-00 00:00:00
 luxury_feed_agent_user_id0
 luxury_feed_locked_to_subscription_id0
 luxury_feed_agent_purchase_date0000-00-00
 luxury_feed_agent_expiration_date0000-00-00
 digital_ad_summary_email_last_sent0000-00-00 00:00:00
 digital_ad_summary_price_changed(false)
 wsj_detail_url
 ft_detail_url
 nyt_detail_url
 juwai_detail_url
 pgl_detail_url
 mg_detail_url
 mg_c_detail_url
 mg_s_detail_url
 bp_detail_url
 mw_detail_url
 nikkei_detail_url
 wapo_detail_url
 robb_detail_url
 medium_featured(true)
 large_featured(false)
 detail_page(true)
 descriptionLive in a work of art! This exceptional home, designed by a Taliesin architect, exists in perfect harmony with the stunning land it rests on. Following Frank Lloyd Wright’s philosophy of organic architecture, the home flows beautifully both inside and out with an openness and abundance of natural material giving it an inviting warmth in all seasons. The details of the home inspire, as well: A remodeled kitchen features top-of-the-line appliances and finishes, a stone hearth opens to the living and dining rooms and all the living spaces look out onto the serene, private landscape. 
 address7240 Clover Hill Drive
 address_2
 cityMiddleton
 stateWI
 postal_code53597
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price650000
 price_20
 price_usd650000
 price_usd_20
 statusFor Sale
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(false)
 bedrooms3
 bedrooms_20
 bathrooms2
 bathrooms_20
 no_beds_baths(false)
 square_feet0
 square_meters
 acres3
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size3
 icon_1acreage
 icon_2garage
 icon_3views
 icon_4
 icon_5
 icon_6
 websitehttp://madison-homes.sprinkmanrealestate.com/idx/details/listing/a162/1752983/7240-Clover-Hill-Dr-Springfield-Wisconsin-53597-1752983
 meta_title7240 Clover Hill Drive, Middleton, WI | Middleton Real Estate | Sprinkman Real Estate
 meta_description7240 Clover Hill Drive is a property offered for sale in Middleton, WI, USA, presented by Sprinkman Real Estate
 meta_keywords
 bathrooms_partial1
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built
 virtual_tourhttps://my.matterport.com/show/?m=Dqp1Y2G6qBg
 video_tour
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num
 wsj_property_type
 nyt_property_type
 nyt_popular_features
 propgolux_property_type
 juwai_property_type
 juwai_category
 propgolux_property_style
 wapo_property_type
 robb_property_type
 propgolux_location_id_override
 open_house_1_start0000-00-00 00:00:00
 open_house_1_end_time00:00:00
 latitude0.000000
 longitude0.000000
 invalid_required_fieldslatitude, longitude
 invalid_optional_fieldssquare_feet, square_meters, hectares, year_built, video_tour, wsj_property_type, nyt_property_type
 went_live_today(false)
 converted(true)
 invalid(false)
 mlsidx_full_address
 mlsidx_date_listed0000-00-00
 mls_market
 primary_property_category_id0
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated(null)
 modified2016-04-18 05:33:02
 created2015-08-04 11:56:50
 uri/property-detail/2585/7240-clover-hill-drive-middleton-wi-53597-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/2585/7240-clover-hill-drive-middleton-wi-53597-usa
 address_concat7240 Clover Hill Drive Middleton WI 53597 USA
 google_maps_query_string7240+Clover+Hill+Drive++Middleton+WI+53597+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 650,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty3
 bathrooms_pretty2
 bathrooms_partial_pretty1
 bathrooms_3_4_pretty0
 feed_full_bathrooms2
 date_listed2015-08-04
 overridden_brokerage_nameSprinkman Real Estate
 overridden_brokerage_logo_uri/assets/2824.
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 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_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2[email protected]
 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
 AccountExecutive(empty)
 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(empty)
 ContactImage3(empty)
 BrokerOfRecordLogo(empty)
 MainArticle(empty)
 FeaturedImage(empty)
 Location(array)
 0(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
 User(array)
 0(array)
 id185
 typeBrokerageAdmin
 brokerage_id198
 email[email protected]
 passwordf7266c125872511535dd9cac23b479b8e938602f
 recover_hash
 first_name
 last_name
 title
 dre_num
 phone
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2016-04-12 08:31:23
 created2016-04-08 16:34:26
 notified(true)
 full_name
 uri/agent-detail/185/
 profile_complete(false)
 1(array)
 id635
 typeAgent
 brokerage_id198
 email[email protected]
 password1e9087fd209c002c2f47bc09f863dcebbb4b4556
 recover_hash
 first_nameShelly
 last_nameSprinkman
 title
 dre_num
 phone608-220-1453
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:12
 created2017-08-07 15:23:12
 notified(false)
 full_nameShelly Sprinkman
 uri/agent-detail/635/shelly-sprinkman
 profile_complete(true)
 2(array)
 id984
 typeAgent
 brokerage_id198
 email[email protected]
 password062300d71e48409bbb7ad581ecc4166ad25ff6d6
 recover_hash
 first_nameRyan
 last_nameBrown
 title
 dre_num
 phone608-338-7440
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:47
 created2017-08-07 15:23:47
 notified(false)
 full_nameRyan Brown
 uri/agent-detail/984/ryan-brown
 profile_complete(true)
 3(array)
 id985
 typeAgent
 brokerage_id198
 email[email protected]
 password457a2e79b260dbd3c9f8e31e12ae757acd8199d0
 recover_hash
 first_nameJulie
 last_nameBernauer
 title
 dre_num
 phone608-219-6492
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:47
 created2017-08-07 15:23:47
 notified(false)
 full_nameJulie Bernauer
 uri/agent-detail/985/julie-bernauer
 profile_complete(true)
 uri/brokerage-detail/198/sprinkman-real-estate
 website_shortsprinkmanrealestate.com
 name_with_locationSprinkman Real Estate - Madison, WI, USA
 StripeSubscription(array)
 id(null)
 brokerage_id(null)
 user_id(null)
 property_id(null)
 type(null)
 stripe_id(null)
 stripe_customer_id(null)
 stripe_checkout_email(null)
 stripe_promotion_code(null)
 stripe_promotion_code_id(null)
 stripe_coupon_code_id(null)
 status(null)
 current_period_end(null)
 cancel_at_period_end(null)
 ended(null)
 last_change(null)
 last_activity_email_sent(null)
 created(null)
 modified(null)
 GlobalReachReport(array)
 id(null)
 property_id(null)
 wsj_desktop(null)
 wsj_mobile(null)
 wsj_expires(null)
 wsj_capture_started(null)
 mg_desktop(null)
 mg_mobile(null)
 mg_expires(null)
 mg_capture_started(null)
 bp_desktop(null)
 bp_mobile(null)
 bp_expires(null)
 gp_capture_started(null)
 mw_desktop(null)
 mw_mobile(null)
 mw_expires(null)
 mw_capture_started(null)
 ft_desktop(null)
 ft_mobile(null)
 ft_expires(null)
 ft_capture_started(null)
 nikkei_desktop(null)
 nikkei_mobile(null)
 nikkei_expires(null)
 nikkei_capture_started(null)
 pgl_desktop(null)
 pgl_mobile(null)
 pgl_expires(null)
 pgl_capture_started(null)
 robb_desktop(null)
 robb_mobile(null)
 robb_expires(null)
 robb_capture_started(null)
 juwai_desktop(null)
 juwai_mobile(null)
 juwai_expires(null)
 juwai_capture_started(null)
 leverage_desktop(null)
 leverage_mobile(null)
 leverage_expires(null)
 leverage_capture_started(null)
 created(null)
 modified(null)
 wsj_available(false)
 wsj_expired(true)
 wsj_desktop_proxy_screenshot(null)
 wsj_mobile_proxy_screenshot(null)
 mg_available(false)
 mg_expired(true)
 mg_desktop_proxy_screenshot(null)
 mg_mobile_proxy_screenshot(null)
 bp_available(false)
 bp_expired(true)
 bp_desktop_proxy_screenshot(null)
 bp_mobile_proxy_screenshot(null)
 mw_available(false)
 mw_expired(true)
 mw_desktop_proxy_screenshot(null)
 mw_mobile_proxy_screenshot(null)
 nikkei_available(false)
 nikkei_expired(true)
 nikkei_desktop_proxy_screenshot(null)
 nikkei_mobile_proxy_screenshot(null)
 pgl_available(false)
 pgl_expired(true)
 pgl_desktop_proxy_screenshot(null)
 pgl_mobile_proxy_screenshot(null)
 robb_available(false)
 robb_expired(true)
 robb_desktop_proxy_screenshot(null)
 robb_mobile_proxy_screenshot(null)
 juwai_available(false)
 juwai_expired(true)
 juwai_desktop_proxy_screenshot(null)
 juwai_mobile_proxy_screenshot(null)
 capture_processing(false)
 capture_error(empty)
 Image(array)
 0(array)
 id16051
 modelProperty
 model_id2585
 tagImage
 name24158.jpg
 typeimage/jpg
 size1006655
 uri/assets/16051.jpg
 order0
 created2016-04-07 16:56:02
 modified2016-04-07 16:56:02
 1(array)
 id16048
 modelProperty
 model_id2585
 tagImage
 name24155.jpg
 typeimage/jpg
 size945943
 uri/assets/16048.jpg
 order1
 created2016-04-07 16:56:02
 modified2016-04-07 16:56:02
 2(array)
 id16049
 modelProperty
 model_id2585
 tagImage
 name24156.jpg
 typeimage/jpg
 size1554746
 uri/assets/16049.jpg
 order2
 created2016-04-07 16:56:02
 modified2016-04-07 16:56:02
 3(array)
 id16046
 modelProperty
 model_id2585
 tagImage
 name24153.jpg
 typeimage/jpg
 size2031010
 uri/assets/16046.jpg
 order3
 created2016-04-07 16:56:02
 modified2016-04-07 16:56:02
 4(array)
 id16047
 modelProperty
 model_id2585
 tagImage
 name24154.jpg
 typeimage/jpg
 size1445390
 uri/assets/16047.jpg
 order4
 created2016-04-07 16:56:02
 modified2016-04-07 16:56:02
 5(array)
 id16050
 modelProperty
 model_id2585
 tagImage
 name24157.jpg
 typeimage/jpg
 size1627037
 uri/assets/16050.jpg
 order5
 created2016-04-07 16:56:02
 modified2016-04-07 16:56:02
 6(array)
 id16052
 modelProperty
 model_id2585
 tagImage
 name24159.jpg
 typeimage/jpg
 size1201182
 uri/assets/16052.jpg
 order6
 created2016-04-07 16:56:02
 modified2016-04-07 16:56:02
 7(array)
 id16053
 modelProperty
 model_id2585
 tagImage
 name24160.jpg
 typeimage/jpg
 size1347979
 uri/assets/16053.jpg
 order7
 created2016-04-07 16:56:02
 modified2016-04-07 16:56:02
 8(array)
 id16054
 modelProperty
 model_id2585
 tagImage
 name24161.jpg
 typeimage/jpg
 size1915387
 uri/assets/16054.jpg
 order8
 created2016-04-07 16:56:02
 modified2016-04-07 16:56:02
 User(array)
 0(array)
 id635
 typeAgent
 brokerage_id198
 email[email protected]
 password1e9087fd209c002c2f47bc09f863dcebbb4b4556
 recover_hash
 first_nameShelly
 last_nameSprinkman
 title
 dre_num
 phone608-220-1453
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:12
 created2017-08-07 15:23:12
 notified(false)
 full_nameShelly Sprinkman
 uri/agent-detail/635/shelly-sprinkman
 profile_complete(true)
 UsersProperty(array)
 id426
 user_id635
 property_id2585
 sort_order0
 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_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2[email protected]
 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(empty)
 BrokerageLogoOverride(empty)
 1(array)
 id984
 typeAgent
 brokerage_id198
 email[email protected]
 password062300d71e48409bbb7ad581ecc4166ad25ff6d6
 recover_hash
 first_nameRyan
 last_nameBrown
 title
 dre_num
 phone608-338-7440
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:47
 created2017-08-07 15:23:47
 notified(false)
 full_nameRyan Brown
 uri/agent-detail/984/ryan-brown
 profile_complete(true)
 UsersProperty(array)
 id738
 user_id984
 property_id2585
 sort_order0
 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_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2[email protected]
 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(empty)
 BrokerageLogoOverride(empty)
 2(array)
 id985
 typeAgent
 brokerage_id198
 email[email protected]
 password457a2e79b260dbd3c9f8e31e12ae757acd8199d0
 recover_hash
 first_nameJulie
 last_nameBernauer
 title
 dre_num
 phone608-219-6492
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:47
 created2017-08-07 15:23:47
 notified(false)
 full_nameJulie Bernauer
 uri/agent-detail/985/julie-bernauer
 profile_complete(true)
 UsersProperty(array)
 id740
 user_id985
 property_id2585
 sort_order0
 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_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2[email protected]
 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(empty)
 BrokerageLogoOverride(empty)
 SecondaryPropertyCategory(empty)
 PropertyFeature(array)
 0(array)
 id4
 nameGarage
 additional(false)
 created2016-04-07 14:01:52
 modified2016-04-07 14:01:52
 PropertiesPropertyFeature(array)
 id3307
 property_id2585
 property_feature_id4
 Icon(array)
 id3553
 modelPropertyFeature
 model_id4
 tagIcon
 name132.png
 typeimage/png
 size2141
 uri/assets/3553.png
 order0
 created2016-04-07 14:01:51
 modified2016-04-07 14:01:52
 1(array)
 id14
 nameViews
 additional(false)
 created2016-04-07 14:04:55
 modified2016-04-07 14:04:55
 PropertiesPropertyFeature(array)
 id3308
 property_id2585
 property_feature_id14
 Icon(array)
 id3563
 modelPropertyFeature
 model_id14
 tagIcon
 name142.png
 typeimage/png
 size2192
 uri/assets/3563.png
 order0
 created2016-04-07 14:04:53
 modified2016-04-07 14:04:55
 Topic(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)
 Property(empty)
 User(empty)
 PropertyFeature(empty)
 SecondaryPropertyCategory(empty)
 Topic(empty)
 PrimaryPropertyCategory(empty)
 Brokerage(empty)
 StripeSubscription(empty)
 GlobalReachReport(empty)
 AccountExecutive(empty)
 Logo(empty)
 MainImage(empty)
 ContactImage(empty)
 ContactImage2(empty)
 ContactImage3(empty)
 BrokerOfRecordLogo(empty)
 MainArticle(empty)
 Location(empty)
 FeaturedImage(empty)
 Image(empty)
 UsersProperty(empty)
 BrokerageLogoOverride(empty)
 PropertiesSecondaryPropertyCategory(empty)
 PropertiesPropertyFeature(empty)
 Icon(empty)
 PropertiesTopic(empty)
- Loaded Helpers(array)
 0Permission
 1Number
 2SimpleGraph
 3DebugTimer
 4Toolbar
 5Session
 6Text
 7Flash
 8HtmlToolbar
 9Html
 10Form
====

Environment

App Constants

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

CakePHP Constants

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

PHP Environment

Environment Variable	Value
Php Version	7.4.33
User	leveragere
Home	/var/www/vhosts/leveragere.com
Script Name	/index.php
Request Uri	/property-detail/2585/7240-clover-hill-drive-middleton-wi-53597-usa
Query String
Request Method	GET
Server Protocol	HTTP/1.1
Gateway Interface	CGI/1.1
Redirect Url	/property-detail/2585/7240-clover-hill-drive-middleton-wi-53597-usa
Remote Port	19908
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.114
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 Cf Ray	a09dff9b0d22cf33-CMH
Http Accept Encoding	gzip, br
Http Cookie	CAKEPHP=ad7ejemaqcdrcspo2vp1qdml74
Http Accept	/
Http User Agent	Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; [email protected])
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	aio-t1LEEfcqtnCHo5UssQAAABU
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	aio-t1LEEfcqtnCHo5UssQAAABU
Fcgi Role	RESPONDER
Php Self	/index.php
Request Time Float	1781153463.5492
Request Time	1781153463

====

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/ExploreComponent.php
  2APP/Controller/Component/PropertyEmailComponent.php
  Config(array)
  0APP/Config/core.php
  1APP/Config/bootstrap.php
  2APP/Config/routes.php
  3APP/Config/database.php
  Controller(array)
  0APP/Controller/PropertiesController.php
  1APP/Controller/AppController.php
  Model(array)
  0APP/Model/Subscription.php
  1APP/Model/AppModel.php
  2APP/Model/Property.php
  3APP/Model/User.php
  4APP/Model/PropertyFeature.php
  5APP/Model/PropertyCategory.php
  6APP/Model/Topic.php
  7APP/Model/Brokerage.php
  8APP/Model/StripeSubscription.php
  9APP/Model/GlobalReachReport.php
  10APP/Model/Asset.php
  11APP/Model/Article.php
  12APP/Model/Location.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
====

7240 Clover Hill Drive, Middleton, WI

Represented By: Sprinkman Real Estate

sprinkmanrealestate.com | License #: 012345

sprinkmanrealestate.com | License #: 012345

sprinkmanrealestate.com | License #: 012345

Highlighted Properties

Share This

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 25 ms Total Queries: 41 queries

Query Explain:

Memory

Timers

Logs

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

Total Time: 25 ms
Total Queries: 41 queries