Properties /

Rumstick Point Custom Built Home

294 Rumstick Road | Barrington, RI 02806, USA | $2,350,000 | MLS ID: 1115599

5 Beds
4 Baths
3 Half Ba
Guest House
Gym

Stunning Rumstick Point home. Private grounds with a guest house! Chef's kitchen, high ceilings. 5 bedrooms, 4 full baths, home gym and au pair suite. The basement includes a full sports bar with billiard room, wine cellar and playroom.

Represented By: Coleman Realtors

View On Map Property Website Virtual Tour

Highlighted Properties

Alfred Drown Colonial Living

10 Alfred Drown Road | Barrington, RI 02806
$889,000

State of the art theater in Cranston

848 Park Avenue | Cranston, RI 02910
$7,500,000

Represented By

Featured Location

Providence, RI, USA

Related Property Listings

Rumstick Point Custom Built Home

294 Rumstick Road
Barrington, RI 02806
$2,350,000

Private home in East Greenwich

140 Juniper Drive
East Greenwich, RI 02818
$799,000

Elegant home just steps from the beach

132 Nayatt Road
Barrington, RI 02806
$1,850,000

Spacious Custom Colonial

77 Rumstick Road
Barrington, RI 02806
$1,975,000

Property Search

Bedrooms

Baths

Minimum Price

Maximum Price

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

Cake Params
- plugin(null)
- controllerproperties
- actionview
- named(empty)
- pass(array)
  03275
  1294-rumstick-road-barrington-ri-02806-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: 8 ms
Total Queries: 32 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` = 3275 AND `Property`.`archived` = '0' AND `Brokerage`.`archived` = '0' AND `Property`.`incomplete` = '0' LIMIT 1	1	1	2	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` = 235	1	1	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` = 95 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` = 95 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` = 95 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` = 95 AND `ContactImage2`.`model` = 'Brokerage' AND `ContactImage2`.`tag` = 'ContactImage2'	0	0	0
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` = 95 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` = 95 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` = 95 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` = (95) 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` = (95)	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` = (95)	5	5	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` = (3275) ORDER BY `Image`.`order` ASC	10	10	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` = 3275 AND `UsersProperty`.`user_id` = `User`.`id`) ORDER BY `UsersProperty`.`sort_order` ASC	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` = 3275 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` = 3275 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` = 5 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` = 6 AND `Icon`.`model` = 'PropertyFeature' AND `Icon`.`tag` = 'Icon'	1	1	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` = 3275 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` != 3275 AND `Property`.`brokerage_id` = 95 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 (3309, 3304) 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 (3309, 3304) AND `UsersProperty`.`user_id` = `User`.`id`) ORDER BY `UsersProperty`.`sort_order` ASC	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` IN (3309, 3304) 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 (3309, 3304) AND `PropertiesPropertyFeature`.`property_feature_id` = `PropertyFeature`.`id`)	1	1	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 (3309, 3304) 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` = 95 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` = 95 AND `Property`.`incomplete` = '0' ORDER BY RAND() ASC LIMIT 4	4	4	2	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 (3275, 3302, 2828, 2008) ORDER BY `Image`.`order` ASC	38	38	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 (3275, 3302, 2828, 2008) AND `UsersProperty`.`user_id` = `User`.`id`) ORDER BY `UsersProperty`.`sort_order` ASC	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` IN (3275, 3302, 2828, 2008) 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 (3275, 3302, 2828, 2008) AND `PropertiesPropertyFeature`.`property_feature_id` = `PropertyFeature`.`id`)	5	5	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 (3275, 3302, 2828, 2008) AND `PropertiesTopic`.`topic_id` = `Topic`.`id`)	0	0	0

Query Explain:

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

====

Timer

Memory

Peak Memory Use 13.12 MB

Message	Memory use
Component initialization	3.09 MB
Controller action start	4.02 MB
Controller render start	6.75 MB
View render complete	7.27 MB

Timers

Total Request Time: 481 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	302.50
Event: Controller.initialize	3.80
Event: Controller.startup	1.23
Controller action	37.34
Event: Controller.beforeRender	11.86
» Processing toolbar data	11.76
Rendering View	93.34
» Event: View.beforeRender	0.26
» Rendering APP/View/Properties/view.ctp	3.11
» » Rendering APP/View/Elements/static_property_price.ctp	0.37
» » Rendering APP/View/Elements/property_features.ctp	0.22
» » 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.15
» » Rendering APP/View/Elements/sidebar/property_list.ctp	0.96
» » » Rendering APP/View/Elements/static_property_price.ctp #4	0.14
» » » 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	89.30
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)
 id3275
 brokerage_id95
 created_by_user_id0
 order0
 multi_unit(false)
 agent_1_id822
 agent_2_id0
 agent_3_id0
 nameRumstick Point Custom Built Home
 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(true)
 force_luxury_feed_featured(false)
 luxury_autofeed_imported(false)
 luxury_feed_last_added_time0000-00-00 00:00:00
 luxury_feed_agent_user_id0
 luxury_feed_locked_to_subscription_id0
 luxury_feed_agent_purchase_date0000-00-00
 luxury_feed_agent_expiration_date0000-00-00
 digital_ad_summary_email_last_sent0000-00-00 00:00:00
 digital_ad_summary_price_changed(false)
 wsj_detail_url
 ft_detail_url
 nyt_detail_url
 juwai_detail_url
 pgl_detail_url
 mg_detail_url
 mg_c_detail_url
 mg_s_detail_url
 bp_detail_url
 mw_detail_url
 nikkei_detail_url
 wapo_detail_url
 robb_detail_url
 medium_featured(false)
 large_featured(false)
 detail_page(true)
 descriptionStunning Rumstick Point home. Private grounds with a guest house! Chef's kitchen, high ceilings. 5 bedrooms, 4 full baths, home gym and au pair suite. The basement includes a full sports bar with billiard room, wine cellar and playroom.
 address294 Rumstick Road
 address_2
 cityBarrington
 stateRI
 postal_code02806
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price2350000
 price_20
 price_usd2350000
 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_1guest-house
 icon_2gym
 icon_3
 icon_4
 icon_5
 icon_6
 websitehttp://www.colemanrealtors.com/real-estate/294-rumstick-rd-barrington-ri-02806/1115599/28225430
 meta_titleRumstick Point Custom Built Home | Barrington Real Estate | Coleman Realtors
 meta_description294 Rumstick Road is a property offered for sale in Barrington, RI, USA, presented by Coleman Realtors
 meta_keywords
 bathrooms_partial3
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built1995
 virtual_tourhttp://www.planomatic.com/24795
 video_tour
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num1115599
 wsj_property_typesingle family
 nyt_property_type1
 nyt_popular_features
 propgolux_property_type9
 juwai_property_type
 juwai_category
 propgolux_property_style10
 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
 latitude41.717262
 longitude-71.302582
 invalid_required_fields
 invalid_optional_fieldsagent_2_id, 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
 created2016-01-13 09:02:08
 uri/property-detail/3275/294-rumstick-road-barrington-ri-02806-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3275/294-rumstick-road-barrington-ri-02806-usa
 address_concat294 Rumstick Road Barrington RI 02806 USA
 google_maps_query_string294+Rumstick+Road++Barrington+RI+02806+USA
 luxury_ad_enrolled_prettyYES
 price_prettyUSD 2,350,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty5
 bathrooms_pretty4
 bathrooms_partial_pretty3
 bathrooms_3_4_pretty0
 feed_full_bathrooms4
 date_listed2016-01-13
 overridden_brokerage_nameColeman Realtors
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id95
 account_executive_id235
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties4
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID2477058
 timezoneUS/Eastern
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameColeman Realtors
 broker_of_record_name
 short_nameColeman Realtors
 usernameColemanRealtors
 passwordc19a88afe4dbd7329004555ea008b2340aa6342b
 password_reset_hash
 monthly_invoice_amount0.00
 monthly_invoice_start_date(null)
 monthly_invoice_end_date(null)
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionColeman Realtors is the exclusive representative for Leverage Global Partners in Rhode Island, USA to include Barrington, East Greenwich, Providence, and Watch Hill. Local knowledge, world-class expertise. Rhode Islanders pride themselves on their independence. So do we: we're an independent, third-generation residential real estate company, not a franchise. That means we're totally focused on you and your needs. We've helped thousands of clients buy, sell, and rent since we opened our doors in 1929. Today our clients rely on our team of over 100 experienced professionals for our local knowledge and expertise: we know the neighborhoods, the towns and the people. With offices in Barrington, East Greenwich, Providence and Watch Hill, we're nearby too. So no matter your challenge, we'll bring you a wealth of experience, ideas and relationships - all geared toward producing results.
 communitiesBarrington, RI Providence, RI Watch Hill, RI Newport, RI Jamestown, RI Bristol, RI Charlestown, RI Narragansett, RI South Kingstown, RI East Greenwich, RI
 websitehttp://www.colemanrealtors.com/
 address135 Elmgrove Avenue
 address_2
 cityProvidence
 stateRI
 full_stateRhode Island
 countryUSA
 marketProvidence
 market_2
 postal_code02906
 phoneDavid Coleman: (401) 245-3050
 phone_2Michael Young: (401) 274-3636
 phone_3
 wide_contact_image(false)
 contact_nameDavid Coleman & Michael Young
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleCo-Owners
 contact_dre_num
 contact_quoteWe invite you to contact us personally about Providence real estate.
 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_filename95.jpg
 logo_filename95.png
 contact_image_filename95.jpg
 all_properties_link_image_filename95.jpg
 all_properties_linkhttp://www.colemanrealtors.com/featured
 video_embed_code
 contact_video_embed_code
 meta_titleProvidence Real Estate | Coleman Realtors | Leverage Global Partners
 meta_descriptionColeman Realtors is the exclusive representative for Leverage Global Partners in Providence, Rhode Island, USA.
 meta_keywordsColeman Realtors, Providence Real Estate, Leverage Global Partners, Providence Rhode Island Real Estate, Barrington Real Estate, East Greenwich Real Estate, Providence Real Estate, Watch Hill Real Estate
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2014-02-11 18:09:34
 modified2016-04-08 16:34:01
 dre_num012345
 uri/brokerage-detail/95/coleman-realtors
 website_shortwww.colemanrealtors.com
 name_with_locationColeman Realtors
 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)
 id16015
 modelProperty
 model_id3275
 tagImage
 name31636.jpg
 typeimage/jpg
 size1024765
 uri/assets/16015.jpg
 order2416
 created2016-04-07 16:56:01
 modified2016-04-07 16:56:01
 1(array)
 id16016
 modelProperty
 model_id3275
 tagImage
 name31637.jpg
 typeimage/jpg
 size957727
 uri/assets/16016.jpg
 order2417
 created2016-04-07 16:56:01
 modified2016-04-07 16:56:01
 2(array)
 id16017
 modelProperty
 model_id3275
 tagImage
 name31638.jpg
 typeimage/jpg
 size845232
 uri/assets/16017.jpg
 order2418
 created2016-04-07 16:56:01
 modified2016-04-07 16:56:01
 3(array)
 id16018
 modelProperty
 model_id3275
 tagImage
 name31639.jpg
 typeimage/jpg
 size858784
 uri/assets/16018.jpg
 order2419
 created2016-04-07 16:56:01
 modified2016-04-07 16:56:01
 4(array)
 id16019
 modelProperty
 model_id3275
 tagImage
 name31640.jpg
 typeimage/jpg
 size890139
 uri/assets/16019.jpg
 order2420
 created2016-04-07 16:56:01
 modified2016-04-07 16:56:01
 5(array)
 id16020
 modelProperty
 model_id3275
 tagImage
 name31641.jpg
 typeimage/jpg
 size659534
 uri/assets/16020.jpg
 order2421
 created2016-04-07 16:56:01
 modified2016-04-07 16:56:01
 6(array)
 id16021
 modelProperty
 model_id3275
 tagImage
 name31642.jpg
 typeimage/jpg
 size990947
 uri/assets/16021.jpg
 order2422
 created2016-04-07 16:56:01
 modified2016-04-07 16:56:01
 7(array)
 id16022
 modelProperty
 model_id3275
 tagImage
 name31643.jpg
 typeimage/jpg
 size660220
 uri/assets/16022.jpg
 order2423
 created2016-04-07 16:56:01
 modified2016-04-07 16:56:01
 8(array)
 id16023
 modelProperty
 model_id3275
 tagImage
 name31644.jpg
 typeimage/jpg
 size663922
 uri/assets/16023.jpg
 order2424
 created2016-04-07 16:56:01
 modified2016-04-07 16:56:01
 9(array)
 id16024
 modelProperty
 model_id3275
 tagImage
 name31645.jpg
 typeimage/jpg
 size651017
 uri/assets/16024.jpg
 order2425
 created2016-04-07 16:56:01
 modified2016-04-07 16:56:01
 User(empty)
 SecondaryPropertyCategory(empty)
 PropertyFeature(array)
 0(array)
 id5
 nameGuest House
 additional(false)
 created2016-04-07 14:02:13
 modified2016-04-07 14:02:13
 PropertiesPropertyFeature(array)
 id3300
 property_id3275
 property_feature_id5
 1(array)
 id6
 nameGym
 additional(false)
 created2016-04-07 14:02:29
 modified2016-04-07 14:02:29
 PropertiesPropertyFeature(array)
 id3301
 property_id3275
 property_feature_id6
 Topic(empty)
 1(array)
 Property(array)
 id3302
 brokerage_id95
 created_by_user_id0
 order0
 multi_unit(false)
 agent_1_id488
 agent_2_id0
 agent_3_id0
 namePrivate home in East Greenwich
 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)
 descriptionCustom designed home located on 2.7 acres of total privacy. First floor master suite and renovated kitchen and family room with cathedral ceilings. Walkout finished basement includes a bedroom, full bath, rec room and living room. Parklike backyard includes a heated pool and hot tub.
 address140 Juniper Drive
 address_2
 cityEast Greenwich
 stateRI
 postal_code02818
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price799000
 price_20
 price_usd799000
 price_usd_20
 statusFor Sale
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(false)
 bedrooms4
 bedrooms_20
 bathrooms4
 bathrooms_20
 no_beds_baths(false)
 square_feet0
 square_meters
 acres2
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size2
 icon_1acreage
 icon_2pool
 icon_3
 icon_4
 icon_5
 icon_6
 websitehttp://www.colemanrealtors.com/real-estate/140-juniper-dr-east-greenwich-ri-02818/1105585/25891369
 meta_titlePrivate home in East Greenwich | East Greenwich Real Estate | Coleman Realtors
 meta_description140 Juniper Drive is a property offered for sale in East Greenwich, RI, USA, presented by Coleman Realtors
 meta_keywords
 bathrooms_partial1
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built1995
 virtual_tourhttp://www.seetheproperty.com/presentation_v2/presentation.php?order_id=176871&mode=branded&ws=1&from=http%3A//stwmls.fusionmls.com/&r=t
 video_tour
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num1105585
 wsj_property_typesingle family
 nyt_property_type1
 nyt_popular_features
 propgolux_property_type9
 juwai_property_type
 juwai_category
 propgolux_property_style17
 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
 latitude41.615955
 longitude-71.520767
 invalid_required_fields
 invalid_optional_fieldsagent_2_id, square_feet, square_meters, hectares, video_tour
 went_live_today(false)
 converted(true)
 invalid(false)
 mlsidx_full_address
 mlsidx_date_listed0000-00-00
 mls_market
 primary_property_category_id0
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated(null)
 modified2016-04-18 05:33:03
 created2016-01-20 08:12:37
 uri/property-detail/3302/140-juniper-drive-east-greenwich-ri-02818-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3302/140-juniper-drive-east-greenwich-ri-02818-usa
 address_concat140 Juniper Drive East Greenwich RI 02818 USA
 google_maps_query_string140+Juniper+Drive++East+Greenwich+RI+02818+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 799,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty4
 bathrooms_pretty4
 bathrooms_partial_pretty1
 bathrooms_3_4_pretty0
 feed_full_bathrooms4
 date_listed2016-01-20
 overridden_brokerage_nameColeman Realtors
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id95
 account_executive_id235
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties4
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID2477058
 timezoneUS/Eastern
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameColeman Realtors
 broker_of_record_name
 short_nameColeman Realtors
 usernameColemanRealtors
 passwordc19a88afe4dbd7329004555ea008b2340aa6342b
 password_reset_hash
 monthly_invoice_amount0.00
 monthly_invoice_start_date(null)
 monthly_invoice_end_date(null)
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionColeman Realtors is the exclusive representative for Leverage Global Partners in Rhode Island, USA to include Barrington, East Greenwich, Providence, and Watch Hill. Local knowledge, world-class expertise. Rhode Islanders pride themselves on their independence. So do we: we're an independent, third-generation residential real estate company, not a franchise. That means we're totally focused on you and your needs. We've helped thousands of clients buy, sell, and rent since we opened our doors in 1929. Today our clients rely on our team of over 100 experienced professionals for our local knowledge and expertise: we know the neighborhoods, the towns and the people. With offices in Barrington, East Greenwich, Providence and Watch Hill, we're nearby too. So no matter your challenge, we'll bring you a wealth of experience, ideas and relationships - all geared toward producing results.
 communitiesBarrington, RI Providence, RI Watch Hill, RI Newport, RI Jamestown, RI Bristol, RI Charlestown, RI Narragansett, RI South Kingstown, RI East Greenwich, RI
 websitehttp://www.colemanrealtors.com/
 address135 Elmgrove Avenue
 address_2
 cityProvidence
 stateRI
 full_stateRhode Island
 countryUSA
 marketProvidence
 market_2
 postal_code02906
 phoneDavid Coleman: (401) 245-3050
 phone_2Michael Young: (401) 274-3636
 phone_3
 wide_contact_image(false)
 contact_nameDavid Coleman & Michael Young
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleCo-Owners
 contact_dre_num
 contact_quoteWe invite you to contact us personally about Providence real estate.
 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_filename95.jpg
 logo_filename95.png
 contact_image_filename95.jpg
 all_properties_link_image_filename95.jpg
 all_properties_linkhttp://www.colemanrealtors.com/featured
 video_embed_code
 contact_video_embed_code
 meta_titleProvidence Real Estate | Coleman Realtors | Leverage Global Partners
 meta_descriptionColeman Realtors is the exclusive representative for Leverage Global Partners in Providence, Rhode Island, USA.
 meta_keywordsColeman Realtors, Providence Real Estate, Leverage Global Partners, Providence Rhode Island Real Estate, Barrington Real Estate, East Greenwich Real Estate, Providence Real Estate, Watch Hill Real Estate
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2014-02-11 18:09:34
 modified2016-04-08 16:34:01
 dre_num012345
 uri/brokerage-detail/95/coleman-realtors
 website_shortwww.colemanrealtors.com
 name_with_locationColeman Realtors
 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)
 id18784
 modelProperty
 model_id3302
 tagImage
 name32014.jpg
 typeimage/jpg
 size653464
 uri/assets/18784.jpg
 order2504
 created2016-04-07 17:12:03
 modified2016-04-07 17:12:03
 1(array)
 id18785
 modelProperty
 model_id3302
 tagImage
 name32015.jpg
 typeimage/jpg
 size776451
 uri/assets/18785.jpg
 order2505
 created2016-04-07 17:12:03
 modified2016-04-07 17:12:03
 2(array)
 id18786
 modelProperty
 model_id3302
 tagImage
 name32016.jpg
 typeimage/jpg
 size440765
 uri/assets/18786.jpg
 order2506
 created2016-04-07 17:12:03
 modified2016-04-07 17:12:03
 3(array)
 id18787
 modelProperty
 model_id3302
 tagImage
 name32017.jpg
 typeimage/jpg
 size726376
 uri/assets/18787.jpg
 order2507
 created2016-04-07 17:12:03
 modified2016-04-07 17:12:03
 4(array)
 id18788
 modelProperty
 model_id3302
 tagImage
 name32018.jpg
 typeimage/jpg
 size627843
 uri/assets/18788.jpg
 order2508
 created2016-04-07 17:12:03
 modified2016-04-07 17:12:03
 5(array)
 id18789
 modelProperty
 model_id3302
 tagImage
 name32019.jpg
 typeimage/jpg
 size643587
 uri/assets/18789.jpg
 order2509
 created2016-04-07 17:12:03
 modified2016-04-07 17:12:03
 6(array)
 id18790
 modelProperty
 model_id3302
 tagImage
 name32020.jpg
 typeimage/jpg
 size227627
 uri/assets/18790.jpg
 order2510
 created2016-04-07 17:12:03
 modified2016-04-07 17:12:03
 7(array)
 id18791
 modelProperty
 model_id3302
 tagImage
 name32021.jpg
 typeimage/jpg
 size313334
 uri/assets/18791.jpg
 order2511
 created2016-04-07 17:12:03
 modified2016-04-07 17:12:03
 8(array)
 id18792
 modelProperty
 model_id3302
 tagImage
 name32022.jpg
 typeimage/jpg
 size261188
 uri/assets/18792.jpg
 order2512
 created2016-04-07 17:12:03
 modified2016-04-07 17:12:03
 9(array)
 id18793
 modelProperty
 model_id3302
 tagImage
 name32023.jpg
 typeimage/jpg
 size275488
 uri/assets/18793.jpg
 order2513
 created2016-04-07 17:12:03
 modified2016-04-07 17:12:03
 User(empty)
 SecondaryPropertyCategory(empty)
 PropertyFeature(array)
 0(array)
 id12
 nameSwimming Pool
 additional(false)
 created2016-04-07 14:04:12
 modified2016-04-07 14:04:12
 PropertiesPropertyFeature(array)
 id3990
 property_id3302
 property_feature_id12
 Topic(empty)
 2(array)
 Property(array)
 id2828
 brokerage_id95
 created_by_user_id0
 order0
 multi_unit(false)
 agent_1_id822
 agent_2_id0
 agent_3_id0
 nameElegant home just steps from the beach
 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(true)
 force_luxury_feed_featured(false)
 luxury_autofeed_imported(false)
 luxury_feed_last_added_time0000-00-00 00:00:00
 luxury_feed_agent_user_id0
 luxury_feed_locked_to_subscription_id0
 luxury_feed_agent_purchase_date0000-00-00
 luxury_feed_agent_expiration_date0000-00-00
 digital_ad_summary_email_last_sent0000-00-00 00:00:00
 digital_ad_summary_price_changed(false)
 wsj_detail_url
 ft_detail_url
 nyt_detail_url
 juwai_detail_url
 pgl_detail_url
 mg_detail_url
 mg_c_detail_url
 mg_s_detail_url
 bp_detail_url
 mw_detail_url
 nikkei_detail_url
 wapo_detail_url
 robb_detail_url
 medium_featured(false)
 large_featured(false)
 detail_page(true)
 descriptionGorgeous Nayatt Point home on 1.6 acres overlooking RI Country Club golf course and tennis courts. This home boasts 6 large bedrooms, 3.5 bathrooms, magnificent interior detail, large finished basement and 3 plus garage. This home is just steps from the beach...live like you're on a resort!
 address132 Nayatt Road
 address_2
 cityBarrington
 stateRI
 postal_code02806
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price1850000
 price_20
 price_usd1850000
 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
 bathrooms3
 bathrooms_20
 no_beds_baths(false)
 square_feet0
 square_meters
 acres0
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size0
 icon_1beach-access
 icon_2views
 icon_3
 icon_4
 icon_5
 icon_6
 websitehttp://www.colemanrealtors.com/real-estate/132-nayatt-rd-barrington-ri-02806/1099591/24986907
 meta_titleElegant home just steps from the beach | Barrington Real Estate | Coleman Realtors
 meta_description132 Nayatt Road is a property offered for sale in Barrington, RI, USA, presented by Coleman Realtors
 meta_keywords
 bathrooms_partial1
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built1920
 virtual_tourhttp://www.seetheproperty.com/presentation_v2/presentation.php?order_id=171083&mode=branded&ws=1&from=http%3A//stwmls.fusionmls.com/&r=t
 video_tour
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num1099591
 wsj_property_typesingle family
 nyt_property_type1
 nyt_popular_features
 propgolux_property_type9
 juwai_property_type
 juwai_category
 propgolux_property_style11
 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
 latitude41.728027
 longitude-71.331795
 invalid_required_fields
 invalid_optional_fieldsagent_2_id, 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-09-29 07:41:32
 uri/property-detail/2828/132-nayatt-road-barrington-ri-02806-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/2828/132-nayatt-road-barrington-ri-02806-usa
 address_concat132 Nayatt Road Barrington RI 02806 USA
 google_maps_query_string132+Nayatt+Road++Barrington+RI+02806+USA
 luxury_ad_enrolled_prettyYES
 price_prettyUSD 1,850,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty6
 bathrooms_pretty3
 bathrooms_partial_pretty1
 bathrooms_3_4_pretty0
 feed_full_bathrooms3
 date_listed2015-09-29
 overridden_brokerage_nameColeman Realtors
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id95
 account_executive_id235
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties4
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID2477058
 timezoneUS/Eastern
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameColeman Realtors
 broker_of_record_name
 short_nameColeman Realtors
 usernameColemanRealtors
 passwordc19a88afe4dbd7329004555ea008b2340aa6342b
 password_reset_hash
 monthly_invoice_amount0.00
 monthly_invoice_start_date(null)
 monthly_invoice_end_date(null)
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionColeman Realtors is the exclusive representative for Leverage Global Partners in Rhode Island, USA to include Barrington, East Greenwich, Providence, and Watch Hill. Local knowledge, world-class expertise. Rhode Islanders pride themselves on their independence. So do we: we're an independent, third-generation residential real estate company, not a franchise. That means we're totally focused on you and your needs. We've helped thousands of clients buy, sell, and rent since we opened our doors in 1929. Today our clients rely on our team of over 100 experienced professionals for our local knowledge and expertise: we know the neighborhoods, the towns and the people. With offices in Barrington, East Greenwich, Providence and Watch Hill, we're nearby too. So no matter your challenge, we'll bring you a wealth of experience, ideas and relationships - all geared toward producing results.
 communitiesBarrington, RI Providence, RI Watch Hill, RI Newport, RI Jamestown, RI Bristol, RI Charlestown, RI Narragansett, RI South Kingstown, RI East Greenwich, RI
 websitehttp://www.colemanrealtors.com/
 address135 Elmgrove Avenue
 address_2
 cityProvidence
 stateRI
 full_stateRhode Island
 countryUSA
 marketProvidence
 market_2
 postal_code02906
 phoneDavid Coleman: (401) 245-3050
 phone_2Michael Young: (401) 274-3636
 phone_3
 wide_contact_image(false)
 contact_nameDavid Coleman & Michael Young
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleCo-Owners
 contact_dre_num
 contact_quoteWe invite you to contact us personally about Providence real estate.
 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_filename95.jpg
 logo_filename95.png
 contact_image_filename95.jpg
 all_properties_link_image_filename95.jpg
 all_properties_linkhttp://www.colemanrealtors.com/featured
 video_embed_code
 contact_video_embed_code
 meta_titleProvidence Real Estate | Coleman Realtors | Leverage Global Partners
 meta_descriptionColeman Realtors is the exclusive representative for Leverage Global Partners in Providence, Rhode Island, USA.
 meta_keywordsColeman Realtors, Providence Real Estate, Leverage Global Partners, Providence Rhode Island Real Estate, Barrington Real Estate, East Greenwich Real Estate, Providence Real Estate, Watch Hill Real Estate
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2014-02-11 18:09:34
 modified2016-04-08 16:34:01
 dre_num012345
 uri/brokerage-detail/95/coleman-realtors
 website_shortwww.colemanrealtors.com
 name_with_locationColeman Realtors
 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)
 id16990
 modelProperty
 model_id2828
 tagImage
 name26964.jpg
 typeimage/jpg
 size670115
 uri/assets/16990.jpg
 order0
 created2016-04-07 17:01:06
 modified2016-04-07 17:01:06
 1(array)
 id16983
 modelProperty
 model_id2828
 tagImage
 name26957.jpg
 typeimage/jpg
 size291950
 uri/assets/16983.jpg
 order1
 created2016-04-07 17:01:05
 modified2016-04-07 17:01:05
 2(array)
 id16984
 modelProperty
 model_id2828
 tagImage
 name26958.jpg
 typeimage/jpg
 size394532
 uri/assets/16984.jpg
 order2
 created2016-04-07 17:01:05
 modified2016-04-07 17:01:05
 3(array)
 id16985
 modelProperty
 model_id2828
 tagImage
 name26959.jpg
 typeimage/jpg
 size385370
 uri/assets/16985.jpg
 order3
 created2016-04-07 17:01:05
 modified2016-04-07 17:01:05
 4(array)
 id16986
 modelProperty
 model_id2828
 tagImage
 name26960.jpg
 typeimage/jpg
 size411209
 uri/assets/16986.jpg
 order4
 created2016-04-07 17:01:05
 modified2016-04-07 17:01:06
 5(array)
 id16987
 modelProperty
 model_id2828
 tagImage
 name26961.jpg
 typeimage/jpg
 size455011
 uri/assets/16987.jpg
 order5
 created2016-04-07 17:01:06
 modified2016-04-07 17:01:06
 6(array)
 id16988
 modelProperty
 model_id2828
 tagImage
 name26962.jpg
 typeimage/jpg
 size416629
 uri/assets/16988.jpg
 order6
 created2016-04-07 17:01:06
 modified2016-04-07 17:01:06
 7(array)
 id16989
 modelProperty
 model_id2828
 tagImage
 name26963.jpg
 typeimage/jpg
 size831798
 uri/assets/16989.jpg
 order7
 created2016-04-07 17:01:06
 modified2016-04-07 17:01:06
 User(empty)
 SecondaryPropertyCategory(empty)
 PropertyFeature(array)
 0(array)
 id2
 nameBeach Access
 additional(false)
 created2016-04-07 14:00:52
 modified2016-04-07 14:00:52
 PropertiesPropertyFeature(array)
 id3538
 property_id2828
 property_feature_id2
 1(array)
 id14
 nameViews
 additional(false)
 created2016-04-07 14:04:55
 modified2016-04-07 14:04:55
 PropertiesPropertyFeature(array)
 id3539
 property_id2828
 property_feature_id14
 Topic(empty)
 3(array)
 Property(array)
 id2008
 brokerage_id95
 created_by_user_id0
 order0
 multi_unit(false)
 agent_1_id489
 agent_2_id0
 agent_3_id0
 nameSpacious Custom Colonial
 incomplete(false)
 archived(false)
 last_archived0000-00-00 00:00:00
 auto_archived_from_mlsidx(false)
 paid_featured(false)
 featured(true)
 homepage_featured(false)
 brokerage_page_featured(true)
 requested_homepage_featured_by_member(false)
 homepage_featured_by_member(false)
 dot_luxury_featured(false)
 luxury_feed_featured(true)
 force_luxury_feed_featured(false)
 luxury_autofeed_imported(false)
 luxury_feed_last_added_time0000-00-00 00:00:00
 luxury_feed_agent_user_id0
 luxury_feed_locked_to_subscription_id0
 luxury_feed_agent_purchase_date0000-00-00
 luxury_feed_agent_expiration_date0000-00-00
 digital_ad_summary_email_last_sent0000-00-00 00:00:00
 digital_ad_summary_price_changed(false)
 wsj_detail_url
 ft_detail_url
 nyt_detail_url
 juwai_detail_url
 pgl_detail_url
 mg_detail_url
 mg_c_detail_url
 mg_s_detail_url
 bp_detail_url
 mw_detail_url
 nikkei_detail_url
 wapo_detail_url
 robb_detail_url
 medium_featured(false)
 large_featured(false)
 detail_page(true)
 descriptionSPARKLING PRIVATE ESTATE TUCKED BACK FROM ROAD & SET ON NEARLY 2 PASTORAL ACRES!...DESIGNED & BUILT FOR A PRO GOLFER WITH EVERY AMENITY! NANTUCKET STYLE COMPLETELY UPDATED WITH GOURMET KITCHEN, AU PAIR STE, GENERATOR...WALK TO TOWN CENTER & WATER!
 address77 Rumstick Road
 address_2
 cityBarrington
 stateRI
 postal_code02806
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price1975000
 price_20
 price_usd1975000
 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://www.colemanrealtors.com/real-estate/77-rumstick-rd-barrington-ri-02806/1121860/30567973
 meta_titleSpacious Custom Colonial | Barrington Real Estate | Coleman Realtors
 meta_description77 Rumstick Road is a property offered for sale in Barrington, RI, USA, presented by Coleman Realtors
 meta_keywords
 bathrooms_partial2
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built1994
 virtual_tourhttp://www.planomatic.com/11315
 video_tour
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num1121860
 wsj_property_typesingle family
 nyt_property_type1
 nyt_popular_features
 propgolux_property_type9
 juwai_property_type
 juwai_category
 propgolux_property_style10
 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
 latitude41.730820
 longitude-71.304810
 invalid_required_fields
 invalid_optional_fieldsagent_2_id, 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-04-21 11:39:04
 uri/property-detail/2008/77-rumstick-road-barrington-ri-02806-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/2008/77-rumstick-road-barrington-ri-02806-usa
 address_concat77 Rumstick Road Barrington RI 02806 USA
 google_maps_query_string77+Rumstick+Road++Barrington+RI+02806+USA
 luxury_ad_enrolled_prettyYES
 price_prettyUSD 1,975,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty6
 bathrooms_pretty5
 bathrooms_partial_pretty2
 bathrooms_3_4_pretty0
 feed_full_bathrooms5
 date_listed2015-04-21
 overridden_brokerage_nameColeman Realtors
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id95
 account_executive_id235
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties4
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID2477058
 timezoneUS/Eastern
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameColeman Realtors
 broker_of_record_name
 short_nameColeman Realtors
 usernameColemanRealtors
 passwordc19a88afe4dbd7329004555ea008b2340aa6342b
 password_reset_hash
 monthly_invoice_amount0.00
 monthly_invoice_start_date(null)
 monthly_invoice_end_date(null)
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionColeman Realtors is the exclusive representative for Leverage Global Partners in Rhode Island, USA to include Barrington, East Greenwich, Providence, and Watch Hill. Local knowledge, world-class expertise. Rhode Islanders pride themselves on their independence. So do we: we're an independent, third-generation residential real estate company, not a franchise. That means we're totally focused on you and your needs. We've helped thousands of clients buy, sell, and rent since we opened our doors in 1929. Today our clients rely on our team of over 100 experienced professionals for our local knowledge and expertise: we know the neighborhoods, the towns and the people. With offices in Barrington, East Greenwich, Providence and Watch Hill, we're nearby too. So no matter your challenge, we'll bring you a wealth of experience, ideas and relationships - all geared toward producing results.
 communitiesBarrington, RI Providence, RI Watch Hill, RI Newport, RI Jamestown, RI Bristol, RI Charlestown, RI Narragansett, RI South Kingstown, RI East Greenwich, RI
 websitehttp://www.colemanrealtors.com/
 address135 Elmgrove Avenue
 address_2
 cityProvidence
 stateRI
 full_stateRhode Island
 countryUSA
 marketProvidence
 market_2
 postal_code02906
 phoneDavid Coleman: (401) 245-3050
 phone_2Michael Young: (401) 274-3636
 phone_3
 wide_contact_image(false)
 contact_nameDavid Coleman & Michael Young
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleCo-Owners
 contact_dre_num
 contact_quoteWe invite you to contact us personally about Providence real estate.
 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_filename95.jpg
 logo_filename95.png
 contact_image_filename95.jpg
 all_properties_link_image_filename95.jpg
 all_properties_linkhttp://www.colemanrealtors.com/featured
 video_embed_code
 contact_video_embed_code
 meta_titleProvidence Real Estate | Coleman Realtors | Leverage Global Partners
 meta_descriptionColeman Realtors is the exclusive representative for Leverage Global Partners in Providence, Rhode Island, USA.
 meta_keywordsColeman Realtors, Providence Real Estate, Leverage Global Partners, Providence Rhode Island Real Estate, Barrington Real Estate, East Greenwich Real Estate, Providence Real Estate, Watch Hill Real Estate
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2014-02-11 18:09:34
 modified2016-04-08 16:34:01
 dre_num012345
 uri/brokerage-detail/95/coleman-realtors
 website_shortwww.colemanrealtors.com
 name_with_locationColeman Realtors
 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)
 id14333
 modelProperty
 model_id2008
 tagImage
 name35986.jpg
 typeimage/jpg
 size571789
 uri/assets/14333.jpg
 order0
 created2016-04-07 16:45:07
 modified2016-04-07 16:45:07
 1(array)
 id14324
 modelProperty
 model_id2008
 tagImage
 name18236.jpg
 typeimage/jpg
 size317414
 uri/assets/14324.jpg
 order1
 created2016-04-07 16:45:07
 modified2016-04-07 16:45:07
 2(array)
 id14326
 modelProperty
 model_id2008
 tagImage
 name18238.jpg
 typeimage/jpg
 size127987
 uri/assets/14326.jpg
 order2
 created2016-04-07 16:45:07
 modified2016-04-07 16:45:07
 3(array)
 id14327
 modelProperty
 model_id2008
 tagImage
 name18239.jpg
 typeimage/jpg
 size155836
 uri/assets/14327.jpg
 order3
 created2016-04-07 16:45:07
 modified2016-04-07 16:45:07
 4(array)
 id14328
 modelProperty
 model_id2008
 tagImage
 name18240.jpg
 typeimage/jpg
 size139710
 uri/assets/14328.jpg
 order4
 created2016-04-07 16:45:07
 modified2016-04-07 16:45:07
 5(array)
 id14329
 modelProperty
 model_id2008
 tagImage
 name18241.jpg
 typeimage/jpg
 size148682
 uri/assets/14329.jpg
 order5
 created2016-04-07 16:45:07
 modified2016-04-07 16:45:07
 6(array)
 id14330
 modelProperty
 model_id2008
 tagImage
 name18242.jpg
 typeimage/jpg
 size143076
 uri/assets/14330.jpg
 order6
 created2016-04-07 16:45:07
 modified2016-04-07 16:45:07
 7(array)
 id14331
 modelProperty
 model_id2008
 tagImage
 name18243.jpg
 typeimage/jpg
 size281348
 uri/assets/14331.jpg
 order7
 created2016-04-07 16:45:07
 modified2016-04-07 16:45:07
 8(array)
 id14332
 modelProperty
 model_id2008
 tagImage
 name18244.jpg
 typeimage/jpg
 size253842
 uri/assets/14332.jpg
 order8
 created2016-04-07 16:45:07
 modified2016-04-07 16:45:07
 9(array)
 id14325
 modelProperty
 model_id2008
 tagImage
 name18237.jpg
 typeimage/jpg
 size237571
 uri/assets/14325.jpg
 order9
 created2016-04-07 16:45:07
 modified2016-04-07 16:45:07
 User(empty)
 SecondaryPropertyCategory(empty)
 PropertyFeature(empty)
 Topic(empty)
- sidebar_locations(array)
 0(array)
 Location(array)
 id23
 parent_id7
 brokerage_id95
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameProvidence, RI, USA
 short_nameProvidence, RI, USA
 group_index
 latitude41.823990
 longitude-71.412834
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_description
 long_descriptionMore information coming soon!
 created2016-04-04 11:12:00
 modified2016-04-04 11:12:00
 timezoneAmerica/New_York
 population178000
 uri/locations/view/23/providence-ri-usa
 tile_nameProvidence, RI, USA
 Brokerage(array)
 id95
 account_executive_id235
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties4
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID2477058
 timezoneUS/Eastern
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameColeman Realtors
 broker_of_record_name
 short_nameColeman Realtors
 usernameColemanRealtors
 passwordc19a88afe4dbd7329004555ea008b2340aa6342b
 password_reset_hash
 monthly_invoice_amount0.00
 monthly_invoice_start_date(null)
 monthly_invoice_end_date(null)
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionColeman Realtors is the exclusive representative for Leverage Global Partners in Rhode Island, USA to include Barrington, East Greenwich, Providence, and Watch Hill. Local knowledge, world-class expertise. Rhode Islanders pride themselves on their independence. So do we: we're an independent, third-generation residential real estate company, not a franchise. That means we're totally focused on you and your needs. We've helped thousands of clients buy, sell, and rent since we opened our doors in 1929. Today our clients rely on our team of over 100 experienced professionals for our local knowledge and expertise: we know the neighborhoods, the towns and the people. With offices in Barrington, East Greenwich, Providence and Watch Hill, we're nearby too. So no matter your challenge, we'll bring you a wealth of experience, ideas and relationships - all geared toward producing results.
 communitiesBarrington, RI Providence, RI Watch Hill, RI Newport, RI Jamestown, RI Bristol, RI Charlestown, RI Narragansett, RI South Kingstown, RI East Greenwich, RI
 websitehttp://www.colemanrealtors.com/
 address135 Elmgrove Avenue
 address_2
 cityProvidence
 stateRI
 full_stateRhode Island
 countryUSA
 marketProvidence
 market_2
 postal_code02906
 phoneDavid Coleman: (401) 245-3050
 phone_2Michael Young: (401) 274-3636
 phone_3
 wide_contact_image(false)
 contact_nameDavid Coleman & Michael Young
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleCo-Owners
 contact_dre_num
 contact_quoteWe invite you to contact us personally about Providence real estate.
 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_filename95.jpg
 logo_filename95.png
 contact_image_filename95.jpg
 all_properties_link_image_filename95.jpg
 all_properties_linkhttp://www.colemanrealtors.com/featured
 video_embed_code
 contact_video_embed_code
 meta_titleProvidence Real Estate | Coleman Realtors | Leverage Global Partners
 meta_descriptionColeman Realtors is the exclusive representative for Leverage Global Partners in Providence, Rhode Island, USA.
 meta_keywordsColeman Realtors, Providence Real Estate, Leverage Global Partners, Providence Rhode Island Real Estate, Barrington Real Estate, East Greenwich Real Estate, Providence Real Estate, Watch Hill Real Estate
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2014-02-11 18:09:34
 modified2016-04-08 16:34:01
 dre_num012345
 uri/brokerage-detail/95/coleman-realtors
 website_shortwww.colemanrealtors.com
 name_with_locationColeman Realtors
 Image(array)
 id2950
 modelLocation
 model_id23
 tagImage
 nameColeman.jpg
 typeimage/jpeg
 size181216
 uri/assets/2950.jpg
 order0
 created2016-04-04 11:10:18
 modified2016-04-04 11:12:00
- highlighted_properties(array)
 0(array)
 Property(array)
 id3309
 brokerage_id95
 created_by_user_id0
 order0
 multi_unit(false)
 agent_1_id487
 agent_2_id0
 agent_3_id0
 nameAlfred Drown Colonial Living
 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)
 descriptionCustom built colonial offering 4,500 square feet of living space. Located in popular Alfred Drown neighborhood. Spacious rooms, high ceilings, open floor, first floor in-law or master with a stone fireplace in the family room. Great room, den and screened in porch sit on 3/4 acre. An oversized garage completes the property.
 address10 Alfred Drown Road
 address_2
 cityBarrington
 stateRI
 postal_code02806
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price889000
 price_20
 price_usd889000
 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_1garage
 icon_2
 icon_3
 icon_4
 icon_5
 icon_6
 websitehttp://www.colemanrealtors.com/real-estate/10-alfred-drown-rd-barrington-ri-02806/1115412/28205802
 meta_titleAlfred Drown Colonial Living | Barrington Real Estate | Coleman Realtors
 meta_description10 Alfred Drown Road is a property offered for sale in Barrington, RI, USA, presented by Coleman Realtors
 meta_keywords
 bathrooms_partial1
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built1990
 virtual_tour
 video_tour
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num1115412
 wsj_property_typesingle family
 nyt_property_type1
 nyt_popular_features
 propgolux_property_type9
 juwai_property_type
 juwai_category
 propgolux_property_style10
 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
 latitude41.745773
 longitude-71.342331
 invalid_required_fields
 invalid_optional_fieldsagent_2_id, square_feet, square_meters, acres, hectares, virtual_tour, video_tour
 went_live_today(false)
 converted(true)
 invalid(false)
 mlsidx_full_address
 mlsidx_date_listed0000-00-00
 mls_market
 primary_property_category_id0
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated(null)
 modified2016-04-18 05:33:03
 created2016-01-21 10:39:56
 uri/property-detail/3309/10-alfred-drown-road-barrington-ri-02806-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3309/10-alfred-drown-road-barrington-ri-02806-usa
 address_concat10 Alfred Drown Road Barrington RI 02806 USA
 google_maps_query_string10+Alfred+Drown+Road++Barrington+RI+02806+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 889,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty4
 bathrooms_pretty3
 bathrooms_partial_pretty1
 bathrooms_3_4_pretty0
 feed_full_bathrooms3
 date_listed2016-01-21
 overridden_brokerage_nameColeman Realtors
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id95
 account_executive_id235
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties4
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID2477058
 timezoneUS/Eastern
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameColeman Realtors
 broker_of_record_name
 short_nameColeman Realtors
 usernameColemanRealtors
 passwordc19a88afe4dbd7329004555ea008b2340aa6342b
 password_reset_hash
 monthly_invoice_amount0.00
 monthly_invoice_start_date(null)
 monthly_invoice_end_date(null)
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionColeman Realtors is the exclusive representative for Leverage Global Partners in Rhode Island, USA to include Barrington, East Greenwich, Providence, and Watch Hill. Local knowledge, world-class expertise. Rhode Islanders pride themselves on their independence. So do we: we're an independent, third-generation residential real estate company, not a franchise. That means we're totally focused on you and your needs. We've helped thousands of clients buy, sell, and rent since we opened our doors in 1929. Today our clients rely on our team of over 100 experienced professionals for our local knowledge and expertise: we know the neighborhoods, the towns and the people. With offices in Barrington, East Greenwich, Providence and Watch Hill, we're nearby too. So no matter your challenge, we'll bring you a wealth of experience, ideas and relationships - all geared toward producing results.
 communitiesBarrington, RI Providence, RI Watch Hill, RI Newport, RI Jamestown, RI Bristol, RI Charlestown, RI Narragansett, RI South Kingstown, RI East Greenwich, RI
 websitehttp://www.colemanrealtors.com/
 address135 Elmgrove Avenue
 address_2
 cityProvidence
 stateRI
 full_stateRhode Island
 countryUSA
 marketProvidence
 market_2
 postal_code02906
 phoneDavid Coleman: (401) 245-3050
 phone_2Michael Young: (401) 274-3636
 phone_3
 wide_contact_image(false)
 contact_nameDavid Coleman & Michael Young
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleCo-Owners
 contact_dre_num
 contact_quoteWe invite you to contact us personally about Providence real estate.
 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_filename95.jpg
 logo_filename95.png
 contact_image_filename95.jpg
 all_properties_link_image_filename95.jpg
 all_properties_linkhttp://www.colemanrealtors.com/featured
 video_embed_code
 contact_video_embed_code
 meta_titleProvidence Real Estate | Coleman Realtors | Leverage Global Partners
 meta_descriptionColeman Realtors is the exclusive representative for Leverage Global Partners in Providence, Rhode Island, USA.
 meta_keywordsColeman Realtors, Providence Real Estate, Leverage Global Partners, Providence Rhode Island Real Estate, Barrington Real Estate, East Greenwich Real Estate, Providence Real Estate, Watch Hill Real Estate
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2014-02-11 18:09:34
 modified2016-04-08 16:34:01
 dre_num012345
 uri/brokerage-detail/95/coleman-realtors
 website_shortwww.colemanrealtors.com
 name_with_locationColeman Realtors
 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)
 id18839
 modelProperty
 model_id3309
 tagImage
 name32065.jpg
 typeimage/jpg
 size1878545
 uri/assets/18839.jpg
 order0
 created2016-04-07 17:12:04
 modified2016-04-07 17:12:04
 1(array)
 id18838
 modelProperty
 model_id3309
 tagImage
 name32064.jpg
 typeimage/jpg
 size1917062
 uri/assets/18838.jpg
 order1
 created2016-04-07 17:12:04
 modified2016-04-07 17:12:04
 2(array)
 id18835
 modelProperty
 model_id3309
 tagImage
 name32061.jpg
 typeimage/jpg
 size1290587
 uri/assets/18835.jpg
 order2
 created2016-04-07 17:12:04
 modified2016-04-07 17:12:04
 3(array)
 id18831
 modelProperty
 model_id3309
 tagImage
 name32057.jpg
 typeimage/jpg
 size958312
 uri/assets/18831.jpg
 order3
 created2016-04-07 17:12:04
 modified2016-04-07 17:12:04
 4(array)
 id18832
 modelProperty
 model_id3309
 tagImage
 name32058.jpg
 typeimage/jpg
 size1040393
 uri/assets/18832.jpg
 order4
 created2016-04-07 17:12:04
 modified2016-04-07 17:12:04
 5(array)
 id18833
 modelProperty
 model_id3309
 tagImage
 name32059.jpg
 typeimage/jpg
 size1198943
 uri/assets/18833.jpg
 order5
 created2016-04-07 17:12:04
 modified2016-04-07 17:12:04
 6(array)
 id18834
 modelProperty
 model_id3309
 tagImage
 name32060.jpg
 typeimage/jpg
 size1317594
 uri/assets/18834.jpg
 order6
 created2016-04-07 17:12:04
 modified2016-04-07 17:12:04
 7(array)
 id18830
 modelProperty
 model_id3309
 tagImage
 name32056.jpg
 typeimage/jpg
 size1134123
 uri/assets/18830.jpg
 order7
 created2016-04-07 17:12:04
 modified2016-04-07 17:12:04
 8(array)
 id18836
 modelProperty
 model_id3309
 tagImage
 name32062.jpg
 typeimage/jpg
 size1490161
 uri/assets/18836.jpg
 order8
 created2016-04-07 17:12:04
 modified2016-04-07 17:12:04
 9(array)
 id18837
 modelProperty
 model_id3309
 tagImage
 name32063.jpg
 typeimage/jpg
 size1922702
 uri/assets/18837.jpg
 order9
 created2016-04-07 17:12:04
 modified2016-04-07 17:12:04
 User(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)
 id3998
 property_id3309
 property_feature_id4
 Topic(empty)
 1(array)
 Property(array)
 id3304
 brokerage_id95
 created_by_user_id0
 order0
 multi_unit(false)
 agent_1_id1103
 agent_2_id0
 agent_3_id0
 nameState of the art theater in Cranston
 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)
 descriptionCompletely renovated 900+ seat historic theater and restaurant, banquet space, catering and entertainment center. The legendary "Beach Boys," "Tower of Power" love to set up here. Eleven POS stations, 6 granite bars and SOLD OUT performances. 400 parking spaces.
 address848 Park Avenue
 address_2
 cityCranston
 stateRI
 postal_code02910
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price7500000
 price_20
 price_usd7500000
 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)
 bedrooms0
 bedrooms_20
 bathrooms0
 bathrooms_20
 no_beds_baths(true)
 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://www.colemanrealtors.com/real-estate/848-park-av-cranston-ri-02910/1115970/28273422
 meta_titleState of the art theater in Cranston | Cranston Real Estate | Coleman Realtors
 meta_description848 Park Avenue is a property offered for sale in Cranston, RI, USA, presented by Coleman Realtors
 meta_keywords
 bathrooms_partial0
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built1923
 virtual_tourhttp://www.propertypanorama.com/instaview-tour/ris/1115970
 video_tour
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num1115932
 wsj_property_typecommercial
 nyt_property_type16
 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
 latitude41.778912
 longitude-71.436371
 invalid_required_fieldsbedrooms, bathrooms
 invalid_optional_fieldsagent_2_id, bathrooms_partial, square_feet, square_meters, acres, hectares, video_tour, 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-01-20 08:48:39
 uri/property-detail/3304/848-park-avenue-cranston-ri-02910-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3304/848-park-avenue-cranston-ri-02910-usa
 address_concat848 Park Avenue Cranston RI 02910 USA
 google_maps_query_string848+Park+Avenue++Cranston+RI+02910+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 7,500,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty0
 bathrooms_pretty0
 bathrooms_partial_pretty0
 bathrooms_3_4_pretty0
 feed_full_bathrooms0
 date_listed2016-01-20
 overridden_brokerage_nameColeman Realtors
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id95
 account_executive_id235
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties4
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID2477058
 timezoneUS/Eastern
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameColeman Realtors
 broker_of_record_name
 short_nameColeman Realtors
 usernameColemanRealtors
 passwordc19a88afe4dbd7329004555ea008b2340aa6342b
 password_reset_hash
 monthly_invoice_amount0.00
 monthly_invoice_start_date(null)
 monthly_invoice_end_date(null)
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionColeman Realtors is the exclusive representative for Leverage Global Partners in Rhode Island, USA to include Barrington, East Greenwich, Providence, and Watch Hill. Local knowledge, world-class expertise. Rhode Islanders pride themselves on their independence. So do we: we're an independent, third-generation residential real estate company, not a franchise. That means we're totally focused on you and your needs. We've helped thousands of clients buy, sell, and rent since we opened our doors in 1929. Today our clients rely on our team of over 100 experienced professionals for our local knowledge and expertise: we know the neighborhoods, the towns and the people. With offices in Barrington, East Greenwich, Providence and Watch Hill, we're nearby too. So no matter your challenge, we'll bring you a wealth of experience, ideas and relationships - all geared toward producing results.
 communitiesBarrington, RI Providence, RI Watch Hill, RI Newport, RI Jamestown, RI Bristol, RI Charlestown, RI Narragansett, RI South Kingstown, RI East Greenwich, RI
 websitehttp://www.colemanrealtors.com/
 address135 Elmgrove Avenue
 address_2
 cityProvidence
 stateRI
 full_stateRhode Island
 countryUSA
 marketProvidence
 market_2
 postal_code02906
 phoneDavid Coleman: (401) 245-3050
 phone_2Michael Young: (401) 274-3636
 phone_3
 wide_contact_image(false)
 contact_nameDavid Coleman & Michael Young
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleCo-Owners
 contact_dre_num
 contact_quoteWe invite you to contact us personally about Providence real estate.
 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_filename95.jpg
 logo_filename95.png
 contact_image_filename95.jpg
 all_properties_link_image_filename95.jpg
 all_properties_linkhttp://www.colemanrealtors.com/featured
 video_embed_code
 contact_video_embed_code
 meta_titleProvidence Real Estate | Coleman Realtors | Leverage Global Partners
 meta_descriptionColeman Realtors is the exclusive representative for Leverage Global Partners in Providence, Rhode Island, USA.
 meta_keywordsColeman Realtors, Providence Real Estate, Leverage Global Partners, Providence Rhode Island Real Estate, Barrington Real Estate, East Greenwich Real Estate, Providence Real Estate, Watch Hill Real Estate
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2014-02-11 18:09:34
 modified2016-04-08 16:34:01
 dre_num012345
 uri/brokerage-detail/95/coleman-realtors
 website_shortwww.colemanrealtors.com
 name_with_locationColeman Realtors
 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)
 id18813
 modelProperty
 model_id3304
 tagImage
 name32033.jpg
 typeimage/jpg
 size494180
 uri/assets/18813.jpg
 order0
 created2016-04-07 17:12:03
 modified2016-04-07 17:12:03
 1(array)
 id18804
 modelProperty
 model_id3304
 tagImage
 name32024.jpg
 typeimage/jpg
 size470344
 uri/assets/18804.jpg
 order1
 created2016-04-07 17:12:03
 modified2016-04-07 17:12:03
 2(array)
 id18805
 modelProperty
 model_id3304
 tagImage
 name32025.jpg
 typeimage/jpg
 size459508
 uri/assets/18805.jpg
 order2
 created2016-04-07 17:12:03
 modified2016-04-07 17:12:03
 3(array)
 id18806
 modelProperty
 model_id3304
 tagImage
 name32026.jpg
 typeimage/jpg
 size386029
 uri/assets/18806.jpg
 order3
 created2016-04-07 17:12:03
 modified2016-04-07 17:12:03
 4(array)
 id18807
 modelProperty
 model_id3304
 tagImage
 name32027.jpg
 typeimage/jpg
 size406767
 uri/assets/18807.jpg
 order4
 created2016-04-07 17:12:03
 modified2016-04-07 17:12:03
 5(array)
 id18808
 modelProperty
 model_id3304
 tagImage
 name32028.jpg
 typeimage/jpg
 size378887
 uri/assets/18808.jpg
 order5
 created2016-04-07 17:12:03
 modified2016-04-07 17:12:03
 6(array)
 id18809
 modelProperty
 model_id3304
 tagImage
 name32029.jpg
 typeimage/jpg
 size479869
 uri/assets/18809.jpg
 order6
 created2016-04-07 17:12:03
 modified2016-04-07 17:12:03
 7(array)
 id18810
 modelProperty
 model_id3304
 tagImage
 name32030.jpg
 typeimage/jpg
 size404056
 uri/assets/18810.jpg
 order7
 created2016-04-07 17:12:03
 modified2016-04-07 17:12:03
 8(array)
 id18811
 modelProperty
 model_id3304
 tagImage
 name32031.jpg
 typeimage/jpg
 size391500
 uri/assets/18811.jpg
 order8
 created2016-04-07 17:12:03
 modified2016-04-07 17:12:03
 9(array)
 id18812
 modelProperty
 model_id3304
 tagImage
 name32032.jpg
 typeimage/jpg
 size462333
 uri/assets/18812.jpg
 order9
 created2016-04-07 17:12:03
 modified2016-04-07 17:12:03
 User(empty)
 SecondaryPropertyCategory(empty)
 PropertyFeature(empty)
 Topic(empty)
- custom_ga_event_properties(array)
 brokerageColeman Realtors, Providence
- property(array)
 Property(array)
 id3275
 brokerage_id95
 created_by_user_id0
 order0
 multi_unit(false)
 agent_1_id822
 agent_2_id0
 agent_3_id0
 nameRumstick Point Custom Built Home
 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(true)
 force_luxury_feed_featured(false)
 luxury_autofeed_imported(false)
 luxury_feed_last_added_time0000-00-00 00:00:00
 luxury_feed_agent_user_id0
 luxury_feed_locked_to_subscription_id0
 luxury_feed_agent_purchase_date0000-00-00
 luxury_feed_agent_expiration_date0000-00-00
 digital_ad_summary_email_last_sent0000-00-00 00:00:00
 digital_ad_summary_price_changed(false)
 wsj_detail_url
 ft_detail_url
 nyt_detail_url
 juwai_detail_url
 pgl_detail_url
 mg_detail_url
 mg_c_detail_url
 mg_s_detail_url
 bp_detail_url
 mw_detail_url
 nikkei_detail_url
 wapo_detail_url
 robb_detail_url
 medium_featured(false)
 large_featured(false)
 detail_page(true)
 descriptionStunning Rumstick Point home. Private grounds with a guest house! Chef's kitchen, high ceilings. 5 bedrooms, 4 full baths, home gym and au pair suite. The basement includes a full sports bar with billiard room, wine cellar and playroom.
 address294 Rumstick Road
 address_2
 cityBarrington
 stateRI
 postal_code02806
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price2350000
 price_20
 price_usd2350000
 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_1guest-house
 icon_2gym
 icon_3
 icon_4
 icon_5
 icon_6
 websitehttp://www.colemanrealtors.com/real-estate/294-rumstick-rd-barrington-ri-02806/1115599/28225430
 meta_titleRumstick Point Custom Built Home | Barrington Real Estate | Coleman Realtors
 meta_description294 Rumstick Road is a property offered for sale in Barrington, RI, USA, presented by Coleman Realtors
 meta_keywords
 bathrooms_partial3
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built1995
 virtual_tourhttp://www.planomatic.com/24795
 video_tour
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num1115599
 wsj_property_typesingle family
 nyt_property_type1
 nyt_popular_features
 propgolux_property_type9
 juwai_property_type
 juwai_category
 propgolux_property_style10
 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
 latitude41.717262
 longitude-71.302582
 invalid_required_fields
 invalid_optional_fieldsagent_2_id, 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
 created2016-01-13 09:02:08
 uri/property-detail/3275/294-rumstick-road-barrington-ri-02806-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3275/294-rumstick-road-barrington-ri-02806-usa
 address_concat294 Rumstick Road Barrington RI 02806 USA
 google_maps_query_string294+Rumstick+Road++Barrington+RI+02806+USA
 luxury_ad_enrolled_prettyYES
 price_prettyUSD 2,350,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty5
 bathrooms_pretty4
 bathrooms_partial_pretty3
 bathrooms_3_4_pretty0
 feed_full_bathrooms4
 date_listed2016-01-13
 overridden_brokerage_nameColeman Realtors
 overridden_brokerage_logo_uri/assets/2521.png
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id95
 account_executive_id235
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties4
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID2477058
 timezoneUS/Eastern
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameColeman Realtors
 broker_of_record_name
 short_nameColeman Realtors
 usernameColemanRealtors
 passwordc19a88afe4dbd7329004555ea008b2340aa6342b
 password_reset_hash
 monthly_invoice_amount0.00
 monthly_invoice_start_date(null)
 monthly_invoice_end_date(null)
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionColeman Realtors is the exclusive representative for Leverage Global Partners in Rhode Island, USA to include Barrington, East Greenwich, Providence, and Watch Hill. Local knowledge, world-class expertise. Rhode Islanders pride themselves on their independence. So do we: we're an independent, third-generation residential real estate company, not a franchise. That means we're totally focused on you and your needs. We've helped thousands of clients buy, sell, and rent since we opened our doors in 1929. Today our clients rely on our team of over 100 experienced professionals for our local knowledge and expertise: we know the neighborhoods, the towns and the people. With offices in Barrington, East Greenwich, Providence and Watch Hill, we're nearby too. So no matter your challenge, we'll bring you a wealth of experience, ideas and relationships - all geared toward producing results.
 communitiesBarrington, RI Providence, RI Watch Hill, RI Newport, RI Jamestown, RI Bristol, RI Charlestown, RI Narragansett, RI South Kingstown, RI East Greenwich, RI
 websitehttp://www.colemanrealtors.com/
 address135 Elmgrove Avenue
 address_2
 cityProvidence
 stateRI
 full_stateRhode Island
 countryUSA
 marketProvidence
 market_2
 postal_code02906
 phoneDavid Coleman: (401) 245-3050
 phone_2Michael Young: (401) 274-3636
 phone_3
 wide_contact_image(false)
 contact_nameDavid Coleman & Michael Young
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleCo-Owners
 contact_dre_num
 contact_quoteWe invite you to contact us personally about Providence real estate.
 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_filename95.jpg
 logo_filename95.png
 contact_image_filename95.jpg
 all_properties_link_image_filename95.jpg
 all_properties_linkhttp://www.colemanrealtors.com/featured
 video_embed_code
 contact_video_embed_code
 meta_titleProvidence Real Estate | Coleman Realtors | Leverage Global Partners
 meta_descriptionColeman Realtors is the exclusive representative for Leverage Global Partners in Providence, Rhode Island, USA.
 meta_keywordsColeman Realtors, Providence Real Estate, Leverage Global Partners, Providence Rhode Island Real Estate, Barrington Real Estate, East Greenwich Real Estate, Providence Real Estate, Watch Hill Real Estate
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2014-02-11 18:09:34
 modified2016-04-08 16:34:01
 dre_num012345
 AccountExecutive(array)
 id235
 typeAccountExecutive
 brokerage_id0
 email[email protected]
 passworde5cc5a96287695cf8b7cace1463b1699895dcf92
 recover_hash
 first_nameAlec
 last_nameMegerdichian
 title
 dre_num
 phone
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2020-12-23 09:21:42
 created2016-04-14 15:40:35
 notified(false)
 full_nameAlec Megerdichian
 uri/agent-detail/235/alec-megerdichian
 profile_complete(true)
 Logo(array)
 id2521
 modelBrokerage
 model_id95
 tagLogo
 name95.png
 typeimage/png
 size12692
 uri/assets/2521.png
 order0
 created2016-03-30 11:40:34
 modified2016-03-30 11:40:34
 MainImage(array)
 id2520
 modelBrokerage
 model_id95
 tagMainImage
 name95.jpg
 typeimage/jpg
 size630270
 uri/assets/2520.jpg
 order0
 created2016-03-30 11:40:33
 modified2016-03-30 11:40:33
 ContactImage(array)
 id2522
 modelBrokerage
 model_id95
 tagContactImage
 name95.jpg
 typeimage/jpg
 size3451252
 uri/assets/2522.jpg
 order0
 created2016-03-30 11:40:34
 modified2016-03-30 11:40:34
 ContactImage2(empty)
 ContactImage3(empty)
 BrokerOfRecordLogo(empty)
 MainArticle(empty)
 FeaturedImage(empty)
 Location(array)
 0(array)
 id23
 parent_id7
 brokerage_id95
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameProvidence, RI, USA
 short_nameProvidence, RI, USA
 group_index
 latitude41.823990
 longitude-71.412834
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_description
 long_descriptionMore information coming soon!
 created2016-04-04 11:12:00
 modified2016-04-04 11:12:00
 timezoneAmerica/New_York
 population178000
 uri/locations/view/23/providence-ri-usa
 tile_nameProvidence, RI, USA
 User(array)
 0(array)
 id119
 typeBrokerageAdmin
 brokerage_id95
 email[email protected]
 passwordc19a88afe4dbd7329004555ea008b2340aa6342b
 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:27:00
 created2016-04-08 16:34:01
 notified(true)
 full_name
 uri/agent-detail/119/
 profile_complete(false)
 1(array)
 id693
 typeAgent
 brokerage_id95
 email[email protected]
 passworda98a48001bd3531c2742fd59a22116744843a6e7
 recover_hash
 first_nameJan
 last_nameLyle Malcolm
 title
 dre_num
 phone401-245-3050
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:16
 created2017-08-07 15:23:16
 notified(false)
 full_nameJan Lyle Malcolm
 uri/agent-detail/693/jan-lyle-malcolm
 profile_complete(true)
 2(array)
 id694
 typeAgent
 brokerage_id95
 email[email protected]
 passworde858b69cb62dcd67c4fb38e0c3ea5403f4f585bd
 recover_hash
 first_nameLinda
 last_nameMittleman
 title
 dre_num
 phone401-524-9999
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:16
 created2017-08-07 15:23:16
 notified(false)
 full_nameLinda Mittleman
 uri/agent-detail/694/linda-mittleman
 profile_complete(true)
 3(array)
 id695
 typeAgent
 brokerage_id95
 email[email protected]
 password2d9fc40217fb6b01711ddacdc0db19b24c0fab2d
 recover_hash
 first_nameChris
 last_nameHealy
 title
 dre_num
 phone401-258-8534
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:16
 created2017-08-07 15:23:16
 notified(false)
 full_nameChris Healy
 uri/agent-detail/695/chris-healy
 profile_complete(true)
 4(array)
 id815
 typeAgent
 brokerage_id95
 email[email protected]
 password17a51d532ce32901e293c841882c8a954f05a99f
 recover_hash
 first_nameKathryn
 last_nameLawrence
 title
 dre_num
 phone401-241-8425
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:24
 created2017-08-07 15:23:24
 notified(false)
 full_nameKathryn Lawrence
 uri/agent-detail/815/kathryn-lawrence
 profile_complete(true)
 uri/brokerage-detail/95/coleman-realtors
 website_shortwww.colemanrealtors.com
 name_with_locationColeman Realtors - Providence, RI, 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)
 id16015
 modelProperty
 model_id3275
 tagImage
 name31636.jpg
 typeimage/jpg
 size1024765
 uri/assets/16015.jpg
 order2416
 created2016-04-07 16:56:01
 modified2016-04-07 16:56:01
 1(array)
 id16016
 modelProperty
 model_id3275
 tagImage
 name31637.jpg
 typeimage/jpg
 size957727
 uri/assets/16016.jpg
 order2417
 created2016-04-07 16:56:01
 modified2016-04-07 16:56:01
 2(array)
 id16017
 modelProperty
 model_id3275
 tagImage
 name31638.jpg
 typeimage/jpg
 size845232
 uri/assets/16017.jpg
 order2418
 created2016-04-07 16:56:01
 modified2016-04-07 16:56:01
 3(array)
 id16018
 modelProperty
 model_id3275
 tagImage
 name31639.jpg
 typeimage/jpg
 size858784
 uri/assets/16018.jpg
 order2419
 created2016-04-07 16:56:01
 modified2016-04-07 16:56:01
 4(array)
 id16019
 modelProperty
 model_id3275
 tagImage
 name31640.jpg
 typeimage/jpg
 size890139
 uri/assets/16019.jpg
 order2420
 created2016-04-07 16:56:01
 modified2016-04-07 16:56:01
 5(array)
 id16020
 modelProperty
 model_id3275
 tagImage
 name31641.jpg
 typeimage/jpg
 size659534
 uri/assets/16020.jpg
 order2421
 created2016-04-07 16:56:01
 modified2016-04-07 16:56:01
 6(array)
 id16021
 modelProperty
 model_id3275
 tagImage
 name31642.jpg
 typeimage/jpg
 size990947
 uri/assets/16021.jpg
 order2422
 created2016-04-07 16:56:01
 modified2016-04-07 16:56:01
 7(array)
 id16022
 modelProperty
 model_id3275
 tagImage
 name31643.jpg
 typeimage/jpg
 size660220
 uri/assets/16022.jpg
 order2423
 created2016-04-07 16:56:01
 modified2016-04-07 16:56:01
 8(array)
 id16023
 modelProperty
 model_id3275
 tagImage
 name31644.jpg
 typeimage/jpg
 size663922
 uri/assets/16023.jpg
 order2424
 created2016-04-07 16:56:01
 modified2016-04-07 16:56:01
 9(array)
 id16024
 modelProperty
 model_id3275
 tagImage
 name31645.jpg
 typeimage/jpg
 size651017
 uri/assets/16024.jpg
 order2425
 created2016-04-07 16:56:01
 modified2016-04-07 16:56:01
 User(empty)
 SecondaryPropertyCategory(empty)
 PropertyFeature(array)
 0(array)
 id5
 nameGuest House
 additional(false)
 created2016-04-07 14:02:13
 modified2016-04-07 14:02:13
 PropertiesPropertyFeature(array)
 id3300
 property_id3275
 property_feature_id5
 Icon(array)
 id3554
 modelPropertyFeature
 model_id5
 tagIcon
 name133.png
 typeimage/png
 size1953
 uri/assets/3554.png
 order0
 created2016-04-07 14:02:11
 modified2016-04-07 14:02:13
 1(array)
 id6
 nameGym
 additional(false)
 created2016-04-07 14:02:29
 modified2016-04-07 14:02:29
 PropertiesPropertyFeature(array)
 id3301
 property_id3275
 property_feature_id6
 Icon(array)
 id3555
 modelPropertyFeature
 model_id6
 tagIcon
 name134.png
 typeimage/png
 size2249
 uri/assets/3555.png
 order0
 created2016-04-07 14:02:28
 modified2016-04-07 14:02:29
 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)
 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/3275/294-rumstick-road-barrington-ri-02806-usa
Query String
Request Method	GET
Server Protocol	HTTP/1.1
Gateway Interface	CGI/1.1
Redirect Url	/property-detail/3275/294-rumstick-road-barrington-ri-02806-usa
Remote Port	17364
Script Filename	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot/index.php
Server Admin	root@localhost
Context Document Root	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot
Context Prefix
Request Scheme	https
Document Root	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot
Remote Addr	162.159.115.42
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	a09e8163bb23962d-CMH
Http Accept Encoding	gzip, br
Http Cookie	CAKEPHP=rd9t52d759idamu3lpqevsgsjc
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	aipTezpysHdOfAmunoyG3QAAAFM
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	aipTezpysHdOfAmunoyG3QAAAFM
Fcgi Role	RESPONDER
Php Self	/index.php
Request Time Float	1781158779.4913
Request Time	1781158779

====

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
====

Rumstick Point Custom Built Home

Represented By: Coleman Realtors

Highlighted Properties

Share This

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 8 ms Total Queries: 32 queries

Query Explain:

Memory

Timers

Logs

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

Total Time: 8 ms
Total Queries: 32 queries