Beautiful Colonial in Legacy Woods

15 Shadowbrook Crossing | East Greenwich, RI 02818, USA | $1,300,000 | MLS ID: 1118980

3 Beds
4 Baths
1 Half Ba
Swimming Pool
Media Room
Garage

Beautiful Colonial in sought after neighborhood, Gourmet kitchen, Huge master bed room with master bath,finished basement great for entertaining. Gorgeous inground pool with outdoor hot tub and beautiful stone patio. A must see!!

Represented By: Coleman Realtors

Coleman Realtors

View On Map

Highlighted Properties

Elegant home just steps from the beach

Elegant home just steps from the beach

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

Spacious Custom Colonial

Spacious Custom Colonial

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

Represented By

Coleman Realtors

Featured Location

Providence, RI, USA

Providence, RI, USA

Related Property Listings

Rumstick Point Custom Built Home

Rumstick Point Custom Built Home

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

Private home in East Greenwich

Private home in East Greenwich

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

Elegant home just steps from the beach

Elegant home just steps from the beach

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

Beautiful Colonial in Legacy Woods

Beautiful Colonial in Legacy Woods

15 Shadowbrook Crossing
East Greenwich, RI 02818
$1,300,000

Property Search

Bedrooms

Baths

Minimum Price

Maximum Price

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

Cake Params
- plugin(null)
- controllerproperties
- actionview
- named(empty)
- pass(array)
  03703
  115-shadowbrook-crossing-east-greenwich-ri-02818-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: 33 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` = 3703 AND `Property`.`archived` = '0' AND `Brokerage`.`archived` = '0' AND `Property`.`incomplete` = '0' LIMIT 1	1	1	1
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` = (3703) 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` = 3703 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` = 3703 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` = 3703 AND `PropertiesPropertyFeature`.`property_feature_id` = `PropertyFeature`.`id`)	3	3	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` = 12 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` = 8 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` = 4 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` = 3703 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` != 3703 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 (2828, 2008) ORDER BY `Image`.`order` ASC	18	18	1	maybe slow
SELECT `User`.`id`, `User`.`type`, `User`.`brokerage_id`, `User`.`email`, `User`.`password`, `User`.`recover_hash`, `User`.`first_name`, `User`.`last_name`, `User`.`title`, `User`.`dre_num`, `User`.`phone`, `User`.`max_luxury_feed_properties`, `User`.`headshot_filename`, `User`.`bio`, `User`.`brokerage_name_override`, `User`.`stripe_customer_id`, `User`.`digital_ad_first_free_month_coupon`, `User`.`modified`, `User`.`created`, `User`.`notified`, (CONCAT(`User`.`first_name`, " ", `User`.`last_name`)) AS `User__full_name`, `UsersProperty`.`id`, `UsersProperty`.`user_id`, `UsersProperty`.`property_id`, `UsersProperty`.`sort_order` FROM `leveragere_staging2`.`users` AS `User` JOIN `leveragere_staging2`.`users_properties` AS `UsersProperty` ON (`UsersProperty`.`property_id` IN (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 (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 (2828, 2008) AND `PropertiesPropertyFeature`.`property_feature_id` = `PropertyFeature`.`id`)	2	2	0
SELECT `Topic`.`id`, `Topic`.`name`, `Topic`.`created`, `Topic`.`modified`, `PropertiesTopic`.`id`, `PropertiesTopic`.`property_id`, `PropertiesTopic`.`topic_id` FROM `leveragere_staging2`.`topics` AS `Topic` JOIN `leveragere_staging2`.`properties_topics` AS `PropertiesTopic` ON (`PropertiesTopic`.`property_id` IN (2828, 2008) 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, 3703) 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, 3703) 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, 3703) 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, 3703) AND `PropertiesPropertyFeature`.`property_feature_id` = `PropertyFeature`.`id`)	8	8	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, 3703) 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.18 MB

Message	Memory use
Component initialization	3.07 MB
Controller action start	4.01 MB
Controller render start	6.71 MB
View render complete	7.23 MB

Timers

Total Request Time: 270 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	48.41
Event: Controller.initialize	8.57
Event: Controller.startup	2.81
Controller action	58.48
Event: Controller.beforeRender	27.10
» Processing toolbar data	27.00
Rendering View	84.93
» Event: View.beforeRender	0.44
» Rendering APP/View/Properties/view.ctp	3.53
» » Rendering APP/View/Elements/static_property_price.ctp	0.45
» » Rendering APP/View/Elements/property_features.ctp	0.27
» » Rendering APP/View/Elements/static_property_price.ctp #2	0.17
» » Rendering APP/View/Elements/static_property_price.ctp #3	0.15
» » Rendering APP/View/Elements/sidebar/location_list.ctp	0.15
» » Rendering APP/View/Elements/sidebar/property_list.ctp	1.10
» » » Rendering APP/View/Elements/static_property_price.ctp #4	0.15
» » » Rendering APP/View/Elements/static_property_price.ctp #5	0.15
» » » Rendering APP/View/Elements/static_property_price.ctp #6	0.15
» » » Rendering APP/View/Elements/static_property_price.ctp #7	0.16
» » 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	80.06
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)
  description<p>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.</p>
  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
  description<p>Coleman Realtors is the exclusive representative for Leverage Global Partners in Rhode Island, USA to include Barrington, East Greenwich, Providence, and Watch Hill.</p> <p>Local knowledge, world-class expertise.</p> <p>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.</p>
  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)
  description<p>Custom 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.</p>
  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
  description<p>Coleman Realtors is the exclusive representative for Leverage Global Partners in Rhode Island, USA to include Barrington, East Greenwich, Providence, and Watch Hill.</p> <p>Local knowledge, world-class expertise.</p> <p>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.</p>
  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)
  description<p>Gorgeous 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!</p>
  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
  description<p>Coleman Realtors is the exclusive representative for Leverage Global Partners in Rhode Island, USA to include Barrington, East Greenwich, Providence, and Watch Hill.</p> <p>Local knowledge, world-class expertise.</p> <p>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.</p>
  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)
  id3703
  brokerage_id95
  created_by_user_id0
  order0
  multi_unit(false)
  agent_1_id1223
  agent_2_id0
  agent_3_id0
  nameBeautiful Colonial in Legacy Woods
  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)
  description<p>Beautiful Colonial in sought after neighborhood, Gourmet kitchen, Huge master bed room with master bath,finished basement great for entertaining. Gorgeous inground pool with outdoor hot tub and beautiful stone patio. A must see!!</p>
  address15 Shadowbrook Crossing
  address_2
  cityEast Greenwich
  stateRI
  postal_code02818
  countryUSA
  use_lat_lng_for_google_map(false)
  currencyUSD
  price1300000
  price_20
  price_usd1300000
  price_usd_20
  statusFor Sale
  status_last_changed0000-00-00 00:00:00
  status_last_changed_price_only0000-00-00 00:00:00
  lease_period
  price_upon_request(false)
  bedrooms3
  bedrooms_20
  bathrooms4
  bathrooms_20
  no_beds_baths(false)
  square_feet0
  square_meters
  acres0
  interior_unitsq_ft
  interior_size0
  lot_unitacres
  lot_size0
  icon_1pool
  icon_2media-room
  icon_3garage
  icon_4
  icon_5
  icon_6
  website
  meta_titleBeautiful Colonial in Legacy Woods | East Greenwich Real Estate | Coleman Realtors
  meta_description15 Shadowbrook Crossing 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_built2004
  virtual_tour
  video_tour
  digital_brochure
  video_tour_embed_code
  digital_brochure_embed_code
  mls_num1118980
  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.648308
  longitude-71.524071
  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:02
  created2016-04-06 07:17:36
  uri/property-detail/3703/15-shadowbrook-crossing-east-greenwich-ri-02818-usa
  absolute_urihttps://staging2.leveragere.com/property-detail/3703/15-shadowbrook-crossing-east-greenwich-ri-02818-usa
  address_concat15 Shadowbrook Crossing East Greenwich RI 02818 USA
  google_maps_query_string15+Shadowbrook+Crossing++East+Greenwich+RI+02818+USA
  luxury_ad_enrolled_prettyYES
  price_prettyUSD 1,300,000
  interior_unit_prettySq. Ft.
  lot_unit_prettyAcres
  bedrooms_pretty3
  bathrooms_pretty4
  bathrooms_partial_pretty1
  bathrooms_3_4_pretty0
  feed_full_bathrooms4
  date_listed2016-04-06
  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
  description<p>Coleman Realtors is the exclusive representative for Leverage Global Partners in Rhode Island, USA to include Barrington, East Greenwich, Providence, and Watch Hill.</p> <p>Local knowledge, world-class expertise.</p> <p>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.</p>
  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)
  id8805
  modelProperty
  model_id3703
  tagImage
  name36006.jpg
  typeimage/jpg
  size3406385
  uri/assets/8805.jpg
  order0
  created2016-04-07 16:11:05
  modified2016-04-07 16:11:05
  1(array)
  id8802
  modelProperty
  model_id3703
  tagImage
  name35998.jpg
  typeimage/jpg
  size1515170
  uri/assets/8802.jpg
  order1
  created2016-04-07 16:11:04
  modified2016-04-07 16:11:04
  2(array)
  id8801
  modelProperty
  model_id3703
  tagImage
  name35999.jpg
  typeimage/jpg
  size1752454
  uri/assets/8801.jpg
  order2
  created2016-04-07 16:11:04
  modified2016-04-07 16:11:04
  3(array)
  id8800
  modelProperty
  model_id3703
  tagImage
  name36000.jpg
  typeimage/jpg
  size1477593
  uri/assets/8800.jpg
  order3
  created2016-04-07 16:11:04
  modified2016-04-07 16:11:04
  4(array)
  id8799
  modelProperty
  model_id3703
  tagImage
  name36001.jpg
  typeimage/jpg
  size1673188
  uri/assets/8799.jpg
  order4
  created2016-04-07 16:11:04
  modified2016-04-07 16:11:04
  5(array)
  id8798
  modelProperty
  model_id3703
  tagImage
  name36002.jpg
  typeimage/jpg
  size1470683
  uri/assets/8798.jpg
  order5
  created2016-04-07 16:11:03
  modified2016-04-07 16:11:04
  6(array)
  id8797
  modelProperty
  model_id3703
  tagImage
  name36003.jpg
  typeimage/jpg
  size1828645
  uri/assets/8797.jpg
  order6
  created2016-04-07 16:11:03
  modified2016-04-07 16:11:03
  7(array)
  id8803
  modelProperty
  model_id3703
  tagImage
  name36004.jpg
  typeimage/jpg
  size1765406
  uri/assets/8803.jpg
  order7
  created2016-04-07 16:11:04
  modified2016-04-07 16:11:04
  8(array)
  id8804
  modelProperty
  model_id3703
  tagImage
  name36005.jpg
  typeimage/jpg
  size3513723
  uri/assets/8804.jpg
  order8
  created2016-04-07 16:11:04
  modified2016-04-07 16:11:04
  9(array)
  id8806
  modelProperty
  model_id3703
  tagImage
  name36007.jpg
  typeimage/jpg
  size3107628
  uri/assets/8806.jpg
  order9
  created2016-04-07 16:11:05
  modified2016-04-07 16:11:06
  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)
  id1418
  property_id3703
  property_feature_id12
  1(array)
  id8
  nameMedia Room
  additional(false)
  created2016-04-07 14:03:04
  modified2016-04-07 14:03:04
  PropertiesPropertyFeature(array)
  id1419
  property_id3703
  property_feature_id8
  2(array)
  id4
  nameGarage
  additional(false)
  created2016-04-07 14:01:52
  modified2016-04-07 14:01:52
  PropertiesPropertyFeature(array)
  id1420
  property_id3703
  property_feature_id4
  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
  description<p>Coleman Realtors is the exclusive representative for Leverage Global Partners in Rhode Island, USA to include Barrington, East Greenwich, Providence, and Watch Hill.</p> <p>Local knowledge, world-class expertise.</p> <p>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.</p>
  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)
  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)
  description<p>Gorgeous 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!</p>
  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
  description<p>Coleman Realtors is the exclusive representative for Leverage Global Partners in Rhode Island, USA to include Barrington, East Greenwich, Providence, and Watch Hill.</p> <p>Local knowledge, world-class expertise.</p> <p>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.</p>
  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)
  1(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)
  description<p>SPARKLING 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!</p>
  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
  description<p>Coleman Realtors is the exclusive representative for Leverage Global Partners in Rhode Island, USA to include Barrington, East Greenwich, Providence, and Watch Hill.</p> <p>Local knowledge, world-class expertise.</p> <p>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.</p>
  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)
- custom_ga_event_properties(array)
  brokerageColeman Realtors, Providence
- property(array)
  Property(array)
  id3703
  brokerage_id95
  created_by_user_id0
  order0
  multi_unit(false)
  agent_1_id1223
  agent_2_id0
  agent_3_id0
  nameBeautiful Colonial in Legacy Woods
  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)
  description<p>Beautiful Colonial in sought after neighborhood, Gourmet kitchen, Huge master bed room with master bath,finished basement great for entertaining. Gorgeous inground pool with outdoor hot tub and beautiful stone patio. A must see!!</p>
  address15 Shadowbrook Crossing
  address_2
  cityEast Greenwich
  stateRI
  postal_code02818
  countryUSA
  use_lat_lng_for_google_map(false)
  currencyUSD
  price1300000
  price_20
  price_usd1300000
  price_usd_20
  statusFor Sale
  status_last_changed0000-00-00 00:00:00
  status_last_changed_price_only0000-00-00 00:00:00
  lease_period
  price_upon_request(false)
  bedrooms3
  bedrooms_20
  bathrooms4
  bathrooms_20
  no_beds_baths(false)
  square_feet0
  square_meters
  acres0
  interior_unitsq_ft
  interior_size0
  lot_unitacres
  lot_size0
  icon_1pool
  icon_2media-room
  icon_3garage
  icon_4
  icon_5
  icon_6
  website
  meta_titleBeautiful Colonial in Legacy Woods | East Greenwich Real Estate | Coleman Realtors
  meta_description15 Shadowbrook Crossing 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_built2004
  virtual_tour
  video_tour
  digital_brochure
  video_tour_embed_code
  digital_brochure_embed_code
  mls_num1118980
  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.648308
  longitude-71.524071
  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:02
  created2016-04-06 07:17:36
  uri/property-detail/3703/15-shadowbrook-crossing-east-greenwich-ri-02818-usa
  absolute_urihttps://staging2.leveragere.com/property-detail/3703/15-shadowbrook-crossing-east-greenwich-ri-02818-usa
  address_concat15 Shadowbrook Crossing East Greenwich RI 02818 USA
  google_maps_query_string15+Shadowbrook+Crossing++East+Greenwich+RI+02818+USA
  luxury_ad_enrolled_prettyYES
  price_prettyUSD 1,300,000
  interior_unit_prettySq. Ft.
  lot_unit_prettyAcres
  bedrooms_pretty3
  bathrooms_pretty4
  bathrooms_partial_pretty1
  bathrooms_3_4_pretty0
  feed_full_bathrooms4
  date_listed2016-04-06
  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
  description<p>Coleman Realtors is the exclusive representative for Leverage Global Partners in Rhode Island, USA to include Barrington, East Greenwich, Providence, and Watch Hill.</p> <p>Local knowledge, world-class expertise.</p> <p>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.</p>
  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)
  id8805
  modelProperty
  model_id3703
  tagImage
  name36006.jpg
  typeimage/jpg
  size3406385
  uri/assets/8805.jpg
  order0
  created2016-04-07 16:11:05
  modified2016-04-07 16:11:05
  1(array)
  id8802
  modelProperty
  model_id3703
  tagImage
  name35998.jpg
  typeimage/jpg
  size1515170
  uri/assets/8802.jpg
  order1
  created2016-04-07 16:11:04
  modified2016-04-07 16:11:04
  2(array)
  id8801
  modelProperty
  model_id3703
  tagImage
  name35999.jpg
  typeimage/jpg
  size1752454
  uri/assets/8801.jpg
  order2
  created2016-04-07 16:11:04
  modified2016-04-07 16:11:04
  3(array)
  id8800
  modelProperty
  model_id3703
  tagImage
  name36000.jpg
  typeimage/jpg
  size1477593
  uri/assets/8800.jpg
  order3
  created2016-04-07 16:11:04
  modified2016-04-07 16:11:04
  4(array)
  id8799
  modelProperty
  model_id3703
  tagImage
  name36001.jpg
  typeimage/jpg
  size1673188
  uri/assets/8799.jpg
  order4
  created2016-04-07 16:11:04
  modified2016-04-07 16:11:04
  5(array)
  id8798
  modelProperty
  model_id3703
  tagImage
  name36002.jpg
  typeimage/jpg
  size1470683
  uri/assets/8798.jpg
  order5
  created2016-04-07 16:11:03
  modified2016-04-07 16:11:04
  6(array)
  id8797
  modelProperty
  model_id3703
  tagImage
  name36003.jpg
  typeimage/jpg
  size1828645
  uri/assets/8797.jpg
  order6
  created2016-04-07 16:11:03
  modified2016-04-07 16:11:03
  7(array)
  id8803
  modelProperty
  model_id3703
  tagImage
  name36004.jpg
  typeimage/jpg
  size1765406
  uri/assets/8803.jpg
  order7
  created2016-04-07 16:11:04
  modified2016-04-07 16:11:04
  8(array)
  id8804
  modelProperty
  model_id3703
  tagImage
  name36005.jpg
  typeimage/jpg
  size3513723
  uri/assets/8804.jpg
  order8
  created2016-04-07 16:11:04
  modified2016-04-07 16:11:04
  9(array)
  id8806
  modelProperty
  model_id3703
  tagImage
  name36007.jpg
  typeimage/jpg
  size3107628
  uri/assets/8806.jpg
  order9
  created2016-04-07 16:11:05
  modified2016-04-07 16:11:06
  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)
  id1418
  property_id3703
  property_feature_id12
  Icon(array)
  id3561
  modelPropertyFeature
  model_id12
  tagIcon
  name140.png
  typeimage/png
  size1464
  uri/assets/3561.png
  order0
  created2016-04-07 14:04:11
  modified2016-04-07 14:04:12
  1(array)
  id8
  nameMedia Room
  additional(false)
  created2016-04-07 14:03:04
  modified2016-04-07 14:03:04
  PropertiesPropertyFeature(array)
  id1419
  property_id3703
  property_feature_id8
  Icon(array)
  id3557
  modelPropertyFeature
  model_id8
  tagIcon
  name136.png
  typeimage/png
  size3481
  uri/assets/3557.png
  order0
  created2016-04-07 14:03:03
  modified2016-04-07 14:03:04
  2(array)
  id4
  nameGarage
  additional(false)
  created2016-04-07 14:01:52
  modified2016-04-07 14:01:52
  PropertiesPropertyFeature(array)
  id1420
  property_id3703
  property_feature_id4
  Icon(array)
  id3553
  modelPropertyFeature
  model_id4
  tagIcon
  name132.png
  typeimage/png
  size2141
  uri/assets/3553.png
  order0
  created2016-04-07 14:01:51
  modified2016-04-07 14:01:52
  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
====

+

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/3703/15-shadowbrook-crossing-east-greenwich-ri-02818-usa
Query String
Request Method	GET
Server Protocol	HTTP/1.1
Gateway Interface	CGI/1.1
Redirect Url	/property-detail/3703/15-shadowbrook-crossing-east-greenwich-ri-02818-usa
Remote Port	19901
Script Filename	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot/index.php
Server Admin	root@localhost
Context Document Root	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot
Context Prefix
Request Scheme	https
Document Root	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot
Remote Addr	104.23.197.114
Server Port	443
Server Addr	172.24.32.44
Server Name	staging2.leveragere.com
Server Software	Apache
Server Signature
Path	/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin
Http Host	staging2.leveragere.com
Http Connection	Keep-Alive
Http X Forwarded Proto	https
Http Cf Visitor	{"scheme":"https"}
Http Cf Ipcountry	US
Http Cf Connecting Ip	216.73.216.172
Http Cdn Loop	cloudflare; loops=1
Http User Agent	Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; [email protected])
Http Accept Encoding	gzip, br
Http Accept	/
Http Cf Ray	a09dff94da30cf33-CMH
Http X Forwarded For	216.73.216.172
Proxy-nokeepalive	1
Ssl Tls Sni	staging2.leveragere.com
Https	on
Passenger Download Native Support Binary	0
Passenger Compile Native Support Binary	0
Perl5lib	/usr/share/awstats/lib:/usr/share/awstats/plugins
Unique Id	aio-tlLEEfcqtnCHo5UsqAAAABA
Redirect Status	200
Redirect Ssl Tls Sni	staging2.leveragere.com
Redirect Https	on
Redirect Passenger Download Native Support Binary	0
Redirect Passenger Compile Native Support Binary	0
Redirect Perl5lib	/usr/share/awstats/lib:/usr/share/awstats/plugins
Redirect Unique Id	aio-tlLEEfcqtnCHo5UsqAAAABA
Fcgi Role	RESPONDER
Php Self	/index.php
Request Time Float	1781153462.6503
Request Time	1781153462

====

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