Stately Georgian Brick built in 1929

265 Olney Street | East Side of Providence, RI 02906, USA | $850,000 | MLS ID: 1090010

5 Beds
3 Baths
1 Half Ba
Garage
Views

Bordering the Moses Brown camputs, this historic home boasts elegant formal rooms and a spacious master suite. There are 5 bedrooms and 3.5 baths. Mechanicals, central air and electircity have all been recently upgraded and inspected. Located in the fine East Side neighborhood.

Represented By: Coleman Realtors

Coleman Realtors

View On Map Property Website Virtual Tour

Highlighted Properties

Private home in East Greenwich

Private home in East Greenwich

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

Alfred Drown Colonial Living

Alfred Drown Colonial Living

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

Represented By

Coleman Realtors

Featured Location

Providence, RI, USA

Providence, RI, USA

Related Property Listings

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

Stately Georgian Brick built in 1929

Stately Georgian Brick built in 1929

265 Olney Street
East Side of Providence, RI 02906
$850,000

Private home in East Greenwich

Private home in East Greenwich

140 Juniper Drive
East Greenwich, RI 02818
$799,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)
  03414
  1265-olney-street-east-side-of-providence-ri-02906-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: 15 ms
Total Queries: 32 queries

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

Message	Memory use
Component initialization	3.07 MB
Controller action start	4.01 MB
Controller render start	6.70 MB
View render complete	7.22 MB

Timers

Total Request Time: 307 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	58.59
Event: Controller.initialize	8.13
Event: Controller.startup	2.67
Controller action	87.28
Event: Controller.beforeRender	9.88
» Processing toolbar data	9.74
Rendering View	96.61
» Event: View.beforeRender	0.43
» Rendering APP/View/Properties/view.ctp	3.29
» » Rendering APP/View/Elements/static_property_price.ctp	0.43
» » Rendering APP/View/Elements/property_features.ctp	0.22
» » Rendering APP/View/Elements/static_property_price.ctp #2	0.15
» » Rendering APP/View/Elements/static_property_price.ctp #3	0.14
» » Rendering APP/View/Elements/sidebar/location_list.ctp	0.17
» » Rendering APP/View/Elements/sidebar/property_list.ctp	1.05
» » » Rendering APP/View/Elements/static_property_price.ctp #4	0.14
» » » Rendering APP/View/Elements/static_property_price.ctp #5	0.13
» » » Rendering APP/View/Elements/static_property_price.ctp #6	0.13
» » » Rendering APP/View/Elements/static_property_price.ctp #7	0.17
» » Rendering APP/View/Elements/sidebar/property_search.ctp	0.19
» Event: View.afterRender	0.01
» Event: View.beforeLayout	0.01
» Rendering APP/View/Layouts/front.ctp	92.07
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)
  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)
  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)
  2(array)
  Property(array)
  id3414
  brokerage_id95
  created_by_user_id0
  order0
  multi_unit(false)
  agent_1_id491
  agent_2_id0
  agent_3_id0
  nameStately Georgian Brick built in 1929
  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>Bordering the Moses Brown camputs, this historic home boasts elegant formal rooms and a spacious master suite. There are 5 bedrooms and 3.5 baths. Mechanicals, central air and electircity have all been recently upgraded and inspected. Located in the fine East Side neighborhood.</p>
  address265 Olney Street
  address_2
  cityEast Side of Providence
  stateRI
  postal_code02906
  countryUSA
  use_lat_lng_for_google_map(false)
  currencyUSD
  price850000
  price_20
  price_usd850000
  price_usd_20
  statusFor Sale
  status_last_changed0000-00-00 00:00:00
  status_last_changed_price_only0000-00-00 00:00:00
  lease_period
  price_upon_request(false)
  bedrooms5
  bedrooms_20
  bathrooms3
  bathrooms_20
  no_beds_baths(false)
  square_feet4325
  square_meters
  acres0
  interior_unitsq_ft
  interior_size0
  lot_unitacres
  lot_size0
  icon_1garage
  icon_2views
  icon_3sq-ft
  icon_4
  icon_5
  icon_6
  websitehttp://www.colemanrealtors.com/real-estate/365-olney-st-east-side-of-prov-ri-02906/1090010/23687130
  meta_titleStately Georgian Brick built in 1929 | East Side of Providence Real Estate | Coleman Realtors
  meta_description265 Olney Street is a property offered for sale in East Side of Providence, RI, USA, presented by Coleman Realtors
  meta_keywords
  bathrooms_partial1
  bathrooms_partial_20
  bathrooms_3_40
  bathrooms_3_4_20
  year_built1929
  virtual_tourhttp://www.seetheproperty.com/presentation_v2/presentation.php?order_id=160565&mode=branded&ws=1&from=http%3A//www.colemanrealtors.com/real-estate/365-olney-st-east-side-of-prov-ri-02906/1090010/23687130&r=t
  video_tour
  digital_brochure
  video_tour_embed_code
  digital_brochure_embed_code
  mls_num1090010
  wsj_property_typesingle family
  nyt_property_type1
  nyt_popular_features
  propgolux_property_type9
  juwai_property_type
  juwai_category
  propgolux_property_style26
  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.839684
  longitude-71.388374
  invalid_required_fields
  invalid_optional_fieldsagent_2_id, 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-02-09 11:13:50
  uri/property-detail/3414/265-olney-street-east-side-of-providence-ri-02906-usa
  absolute_urihttps://staging2.leveragere.com/property-detail/3414/265-olney-street-east-side-of-providence-ri-02906-usa
  address_concat265 Olney Street East Side of Providence RI 02906 USA
  google_maps_query_string265+Olney+Street++East+Side+of+Providence+RI+02906+USA
  luxury_ad_enrolled_prettyNO
  price_prettyUSD 850,000
  interior_unit_prettySq. Ft.
  lot_unit_prettyAcres
  bedrooms_pretty5
  bathrooms_pretty3
  bathrooms_partial_pretty1
  bathrooms_3_4_pretty0
  feed_full_bathrooms3
  date_listed2016-02-09
  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)
  id14279
  modelProperty
  model_id3414
  tagImage
  name33091.jpg
  typeimage/jpg
  size860943
  uri/assets/14279.jpg
  order2642
  created2016-04-07 16:45:05
  modified2016-04-07 16:45:05
  1(array)
  id14280
  modelProperty
  model_id3414
  tagImage
  name33092.jpg
  typeimage/jpg
  size737189
  uri/assets/14280.jpg
  order2643
  created2016-04-07 16:45:05
  modified2016-04-07 16:45:05
  2(array)
  id14281
  modelProperty
  model_id3414
  tagImage
  name33093.jpg
  typeimage/jpg
  size497471
  uri/assets/14281.jpg
  order2644
  created2016-04-07 16:45:05
  modified2016-04-07 16:45:05
  3(array)
  id14282
  modelProperty
  model_id3414
  tagImage
  name33094.jpg
  typeimage/jpg
  size415952
  uri/assets/14282.jpg
  order2645
  created2016-04-07 16:45:05
  modified2016-04-07 16:45:05
  4(array)
  id14283
  modelProperty
  model_id3414
  tagImage
  name33095.jpg
  typeimage/jpg
  size466154
  uri/assets/14283.jpg
  order2646
  created2016-04-07 16:45:05
  modified2016-04-07 16:45:05
  5(array)
  id14284
  modelProperty
  model_id3414
  tagImage
  name33096.jpg
  typeimage/jpg
  size296611
  uri/assets/14284.jpg
  order2647
  created2016-04-07 16:45:05
  modified2016-04-07 16:45:05
  6(array)
  id14285
  modelProperty
  model_id3414
  tagImage
  name33097.jpg
  typeimage/jpg
  size338568
  uri/assets/14285.jpg
  order2648
  created2016-04-07 16:45:05
  modified2016-04-07 16:45:05
  7(array)
  id14286
  modelProperty
  model_id3414
  tagImage
  name33098.jpg
  typeimage/jpg
  size497678
  uri/assets/14286.jpg
  order2649
  created2016-04-07 16:45:05
  modified2016-04-07 16:45:05
  8(array)
  id14287
  modelProperty
  model_id3414
  tagImage
  name33099.jpg
  typeimage/jpg
  size789481
  uri/assets/14287.jpg
  order2650
  created2016-04-07 16:45:05
  modified2016-04-07 16:45:05
  9(array)
  id14288
  modelProperty
  model_id3414
  tagImage
  name33100.jpg
  typeimage/jpg
  size582145
  uri/assets/14288.jpg
  order2651
  created2016-04-07 16:45:05
  modified2016-04-07 16:45:05
  User(empty)
  SecondaryPropertyCategory(empty)
  PropertyFeature(array)
  0(array)
  id4
  nameGarage
  additional(false)
  created2016-04-07 14:01:52
  modified2016-04-07 14:01:52
  PropertiesPropertyFeature(array)
  id2832
  property_id3414
  property_feature_id4
  1(array)
  id14
  nameViews
  additional(false)
  created2016-04-07 14:04:55
  modified2016-04-07 14:04:55
  PropertiesPropertyFeature(array)
  id2833
  property_id3414
  property_feature_id14
  Topic(empty)
  3(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)
- 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)
  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)
  1(array)
  Property(array)
  id3309
  brokerage_id95
  created_by_user_id0
  order0
  multi_unit(false)
  agent_1_id487
  agent_2_id0
  agent_3_id0
  nameAlfred Drown Colonial Living
  incomplete(false)
  archived(false)
  last_archived0000-00-00 00:00:00
  auto_archived_from_mlsidx(false)
  paid_featured(false)
  featured(true)
  homepage_featured(true)
  brokerage_page_featured(true)
  requested_homepage_featured_by_member(false)
  homepage_featured_by_member(false)
  dot_luxury_featured(false)
  luxury_feed_featured(false)
  force_luxury_feed_featured(false)
  luxury_autofeed_imported(false)
  luxury_feed_last_added_time0000-00-00 00:00:00
  luxury_feed_agent_user_id0
  luxury_feed_locked_to_subscription_id0
  luxury_feed_agent_purchase_date0000-00-00
  luxury_feed_agent_expiration_date0000-00-00
  digital_ad_summary_email_last_sent0000-00-00 00:00:00
  digital_ad_summary_price_changed(false)
  wsj_detail_url
  ft_detail_url
  nyt_detail_url
  juwai_detail_url
  pgl_detail_url
  mg_detail_url
  mg_c_detail_url
  mg_s_detail_url
  bp_detail_url
  mw_detail_url
  nikkei_detail_url
  wapo_detail_url
  robb_detail_url
  medium_featured(false)
  large_featured(false)
  detail_page(true)
  description<p>Custom built colonial offering 4,500 square feet of living space. Located in popular Alfred Drown neighborhood. Spacious rooms, high ceilings, open floor, first floor in-law or master with a stone fireplace in the family room. Great room, den and screened in porch sit on 3/4 acre. An oversized garage completes the property.</p>
  address10 Alfred Drown Road
  address_2
  cityBarrington
  stateRI
  postal_code02806
  countryUSA
  use_lat_lng_for_google_map(false)
  currencyUSD
  price889000
  price_20
  price_usd889000
  price_usd_20
  statusFor Sale
  status_last_changed0000-00-00 00:00:00
  status_last_changed_price_only0000-00-00 00:00:00
  lease_period
  price_upon_request(false)
  bedrooms4
  bedrooms_20
  bathrooms3
  bathrooms_20
  no_beds_baths(false)
  square_feet0
  square_meters
  acres0
  interior_unitsq_ft
  interior_size0
  lot_unitacres
  lot_size0
  icon_1garage
  icon_2
  icon_3
  icon_4
  icon_5
  icon_6
  websitehttp://www.colemanrealtors.com/real-estate/10-alfred-drown-rd-barrington-ri-02806/1115412/28205802
  meta_titleAlfred Drown Colonial Living | Barrington Real Estate | Coleman Realtors
  meta_description10 Alfred Drown Road is a property offered for sale in Barrington, RI, USA, presented by Coleman Realtors
  meta_keywords
  bathrooms_partial1
  bathrooms_partial_20
  bathrooms_3_40
  bathrooms_3_4_20
  year_built1990
  virtual_tour
  video_tour
  digital_brochure
  video_tour_embed_code
  digital_brochure_embed_code
  mls_num1115412
  wsj_property_typesingle family
  nyt_property_type1
  nyt_popular_features
  propgolux_property_type9
  juwai_property_type
  juwai_category
  propgolux_property_style10
  wapo_property_type
  robb_property_type
  propgolux_location_id_override
  open_house_1_start0000-00-00 00:00:00
  open_house_1_end_time00:00:00
  latitude41.745773
  longitude-71.342331
  invalid_required_fields
  invalid_optional_fieldsagent_2_id, square_feet, square_meters, acres, hectares, virtual_tour, video_tour
  went_live_today(false)
  converted(true)
  invalid(false)
  mlsidx_full_address
  mlsidx_date_listed0000-00-00
  mls_market
  primary_property_category_id0
  realstaq_initial_image_sync(false)
  digital_ad_listing_urls_automated(null)
  modified2016-04-18 05:33:03
  created2016-01-21 10:39:56
  uri/property-detail/3309/10-alfred-drown-road-barrington-ri-02806-usa
  absolute_urihttps://staging2.leveragere.com/property-detail/3309/10-alfred-drown-road-barrington-ri-02806-usa
  address_concat10 Alfred Drown Road Barrington RI 02806 USA
  google_maps_query_string10+Alfred+Drown+Road++Barrington+RI+02806+USA
  luxury_ad_enrolled_prettyNO
  price_prettyUSD 889,000
  interior_unit_prettySq. Ft.
  lot_unit_prettyAcres
  bedrooms_pretty4
  bathrooms_pretty3
  bathrooms_partial_pretty1
  bathrooms_3_4_pretty0
  feed_full_bathrooms3
  date_listed2016-01-21
  overridden_brokerage_nameColeman Realtors
  overridden_brokerage_logo_uri
  lux_ad_auto_enrolled(false)
  PrimaryPropertyCategory(array)
  id(null)
  name(null)
  created(null)
  modified(null)
  Brokerage(array)
  id95
  account_executive_id235
  archived(false)
  typebrokerage
  hide_from_frontend(false)
  agent_brokerage_data_override(false)
  featured_development(false)
  membership_typePremium
  max_properties8
  max_homepage_featured_by_member_properties0
  featured_properties_sort_methodmanual
  lux_feed_modeStripeSubscription
  max_luxury_feed_properties4
  membership_luxury_feed_properties0
  can_participate_in_lux_feed_while_archived(false)
  full_training_video_access(false)
  country_id0
  WOEID2477058
  timezoneUS/Eastern
  luxury_feed_enrollment_modemanual
  luxury_feed_include_mlsidx_minimum_price0
  luxury_feed_include_leverage_minimum_price0
  digital_ad_contacts
  add_agents_to_grr_auto_recipients(true)
  mlsidx_id
  mlsidx_lux_autofeed(false)
  mlsidx_lux_autofeed_minimum_price0
  mlsidx_logo_url
  mlsidx_disclaimer
  nameColeman Realtors
  broker_of_record_name
  short_nameColeman Realtors
  usernameColemanRealtors
  passwordc19a88afe4dbd7329004555ea008b2340aa6342b
  password_reset_hash
  monthly_invoice_amount0.00
  monthly_invoice_start_date(null)
  monthly_invoice_end_date(null)
  contract_filename
  active(true)
  lead_in
  short_description
  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)
  id18839
  modelProperty
  model_id3309
  tagImage
  name32065.jpg
  typeimage/jpg
  size1878545
  uri/assets/18839.jpg
  order0
  created2016-04-07 17:12:04
  modified2016-04-07 17:12:04
  1(array)
  id18838
  modelProperty
  model_id3309
  tagImage
  name32064.jpg
  typeimage/jpg
  size1917062
  uri/assets/18838.jpg
  order1
  created2016-04-07 17:12:04
  modified2016-04-07 17:12:04
  2(array)
  id18835
  modelProperty
  model_id3309
  tagImage
  name32061.jpg
  typeimage/jpg
  size1290587
  uri/assets/18835.jpg
  order2
  created2016-04-07 17:12:04
  modified2016-04-07 17:12:04
  3(array)
  id18831
  modelProperty
  model_id3309
  tagImage
  name32057.jpg
  typeimage/jpg
  size958312
  uri/assets/18831.jpg
  order3
  created2016-04-07 17:12:04
  modified2016-04-07 17:12:04
  4(array)
  id18832
  modelProperty
  model_id3309
  tagImage
  name32058.jpg
  typeimage/jpg
  size1040393
  uri/assets/18832.jpg
  order4
  created2016-04-07 17:12:04
  modified2016-04-07 17:12:04
  5(array)
  id18833
  modelProperty
  model_id3309
  tagImage
  name32059.jpg
  typeimage/jpg
  size1198943
  uri/assets/18833.jpg
  order5
  created2016-04-07 17:12:04
  modified2016-04-07 17:12:04
  6(array)
  id18834
  modelProperty
  model_id3309
  tagImage
  name32060.jpg
  typeimage/jpg
  size1317594
  uri/assets/18834.jpg
  order6
  created2016-04-07 17:12:04
  modified2016-04-07 17:12:04
  7(array)
  id18830
  modelProperty
  model_id3309
  tagImage
  name32056.jpg
  typeimage/jpg
  size1134123
  uri/assets/18830.jpg
  order7
  created2016-04-07 17:12:04
  modified2016-04-07 17:12:04
  8(array)
  id18836
  modelProperty
  model_id3309
  tagImage
  name32062.jpg
  typeimage/jpg
  size1490161
  uri/assets/18836.jpg
  order8
  created2016-04-07 17:12:04
  modified2016-04-07 17:12:04
  9(array)
  id18837
  modelProperty
  model_id3309
  tagImage
  name32063.jpg
  typeimage/jpg
  size1922702
  uri/assets/18837.jpg
  order9
  created2016-04-07 17:12:04
  modified2016-04-07 17:12:04
  User(empty)
  SecondaryPropertyCategory(empty)
  PropertyFeature(array)
  0(array)
  id4
  nameGarage
  additional(false)
  created2016-04-07 14:01:52
  modified2016-04-07 14:01:52
  PropertiesPropertyFeature(array)
  id3998
  property_id3309
  property_feature_id4
  Topic(empty)
- custom_ga_event_properties(array)
  brokerageColeman Realtors, Providence
- property(array)
  Property(array)
  id3414
  brokerage_id95
  created_by_user_id0
  order0
  multi_unit(false)
  agent_1_id491
  agent_2_id0
  agent_3_id0
  nameStately Georgian Brick built in 1929
  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>Bordering the Moses Brown camputs, this historic home boasts elegant formal rooms and a spacious master suite. There are 5 bedrooms and 3.5 baths. Mechanicals, central air and electircity have all been recently upgraded and inspected. Located in the fine East Side neighborhood.</p>
  address265 Olney Street
  address_2
  cityEast Side of Providence
  stateRI
  postal_code02906
  countryUSA
  use_lat_lng_for_google_map(false)
  currencyUSD
  price850000
  price_20
  price_usd850000
  price_usd_20
  statusFor Sale
  status_last_changed0000-00-00 00:00:00
  status_last_changed_price_only0000-00-00 00:00:00
  lease_period
  price_upon_request(false)
  bedrooms5
  bedrooms_20
  bathrooms3
  bathrooms_20
  no_beds_baths(false)
  square_feet4325
  square_meters
  acres0
  interior_unitsq_ft
  interior_size0
  lot_unitacres
  lot_size0
  icon_1garage
  icon_2views
  icon_3sq-ft
  icon_4
  icon_5
  icon_6
  websitehttp://www.colemanrealtors.com/real-estate/365-olney-st-east-side-of-prov-ri-02906/1090010/23687130
  meta_titleStately Georgian Brick built in 1929 | East Side of Providence Real Estate | Coleman Realtors
  meta_description265 Olney Street is a property offered for sale in East Side of Providence, RI, USA, presented by Coleman Realtors
  meta_keywords
  bathrooms_partial1
  bathrooms_partial_20
  bathrooms_3_40
  bathrooms_3_4_20
  year_built1929
  virtual_tourhttp://www.seetheproperty.com/presentation_v2/presentation.php?order_id=160565&mode=branded&ws=1&from=http%3A//www.colemanrealtors.com/real-estate/365-olney-st-east-side-of-prov-ri-02906/1090010/23687130&r=t
  video_tour
  digital_brochure
  video_tour_embed_code
  digital_brochure_embed_code
  mls_num1090010
  wsj_property_typesingle family
  nyt_property_type1
  nyt_popular_features
  propgolux_property_type9
  juwai_property_type
  juwai_category
  propgolux_property_style26
  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.839684
  longitude-71.388374
  invalid_required_fields
  invalid_optional_fieldsagent_2_id, 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-02-09 11:13:50
  uri/property-detail/3414/265-olney-street-east-side-of-providence-ri-02906-usa
  absolute_urihttps://staging2.leveragere.com/property-detail/3414/265-olney-street-east-side-of-providence-ri-02906-usa
  address_concat265 Olney Street East Side of Providence RI 02906 USA
  google_maps_query_string265+Olney+Street++East+Side+of+Providence+RI+02906+USA
  luxury_ad_enrolled_prettyNO
  price_prettyUSD 850,000
  interior_unit_prettySq. Ft.
  lot_unit_prettyAcres
  bedrooms_pretty5
  bathrooms_pretty3
  bathrooms_partial_pretty1
  bathrooms_3_4_pretty0
  feed_full_bathrooms3
  date_listed2016-02-09
  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)
  id14279
  modelProperty
  model_id3414
  tagImage
  name33091.jpg
  typeimage/jpg
  size860943
  uri/assets/14279.jpg
  order2642
  created2016-04-07 16:45:05
  modified2016-04-07 16:45:05
  1(array)
  id14280
  modelProperty
  model_id3414
  tagImage
  name33092.jpg
  typeimage/jpg
  size737189
  uri/assets/14280.jpg
  order2643
  created2016-04-07 16:45:05
  modified2016-04-07 16:45:05
  2(array)
  id14281
  modelProperty
  model_id3414
  tagImage
  name33093.jpg
  typeimage/jpg
  size497471
  uri/assets/14281.jpg
  order2644
  created2016-04-07 16:45:05
  modified2016-04-07 16:45:05
  3(array)
  id14282
  modelProperty
  model_id3414
  tagImage
  name33094.jpg
  typeimage/jpg
  size415952
  uri/assets/14282.jpg
  order2645
  created2016-04-07 16:45:05
  modified2016-04-07 16:45:05
  4(array)
  id14283
  modelProperty
  model_id3414
  tagImage
  name33095.jpg
  typeimage/jpg
  size466154
  uri/assets/14283.jpg
  order2646
  created2016-04-07 16:45:05
  modified2016-04-07 16:45:05
  5(array)
  id14284
  modelProperty
  model_id3414
  tagImage
  name33096.jpg
  typeimage/jpg
  size296611
  uri/assets/14284.jpg
  order2647
  created2016-04-07 16:45:05
  modified2016-04-07 16:45:05
  6(array)
  id14285
  modelProperty
  model_id3414
  tagImage
  name33097.jpg
  typeimage/jpg
  size338568
  uri/assets/14285.jpg
  order2648
  created2016-04-07 16:45:05
  modified2016-04-07 16:45:05
  7(array)
  id14286
  modelProperty
  model_id3414
  tagImage
  name33098.jpg
  typeimage/jpg
  size497678
  uri/assets/14286.jpg
  order2649
  created2016-04-07 16:45:05
  modified2016-04-07 16:45:05
  8(array)
  id14287
  modelProperty
  model_id3414
  tagImage
  name33099.jpg
  typeimage/jpg
  size789481
  uri/assets/14287.jpg
  order2650
  created2016-04-07 16:45:05
  modified2016-04-07 16:45:05
  9(array)
  id14288
  modelProperty
  model_id3414
  tagImage
  name33100.jpg
  typeimage/jpg
  size582145
  uri/assets/14288.jpg
  order2651
  created2016-04-07 16:45:05
  modified2016-04-07 16:45:05
  User(empty)
  SecondaryPropertyCategory(empty)
  PropertyFeature(array)
  0(array)
  id4
  nameGarage
  additional(false)
  created2016-04-07 14:01:52
  modified2016-04-07 14:01:52
  PropertiesPropertyFeature(array)
  id2832
  property_id3414
  property_feature_id4
  Icon(array)
  id3553
  modelPropertyFeature
  model_id4
  tagIcon
  name132.png
  typeimage/png
  size2141
  uri/assets/3553.png
  order0
  created2016-04-07 14:01:51
  modified2016-04-07 14:01:52
  1(array)
  id14
  nameViews
  additional(false)
  created2016-04-07 14:04:55
  modified2016-04-07 14:04:55
  PropertiesPropertyFeature(array)
  id2833
  property_id3414
  property_feature_id14
  Icon(array)
  id3563
  modelPropertyFeature
  model_id14
  tagIcon
  name142.png
  typeimage/png
  size2192
  uri/assets/3563.png
  order0
  created2016-04-07 14:04:53
  modified2016-04-07 14:04:55
  Topic(empty)
- membership_subscription_temp_allowed_login(null)
- newsletter_member_types(array)
  Leverage Member: AgentLeverage Member: Agent
  Leverage Member: Broker or ManagementLeverage Member: Broker or Management
  Non-MemberNon-Member
- $request->data(empty)
- $this->validationErrors(array)
  Subscription(empty)
  Property(empty)
  User(empty)
  PropertyFeature(empty)
  SecondaryPropertyCategory(empty)
  Topic(empty)
  PrimaryPropertyCategory(empty)
  Brokerage(empty)
  StripeSubscription(empty)
  GlobalReachReport(empty)
  AccountExecutive(empty)
  Logo(empty)
  MainImage(empty)
  ContactImage(empty)
  ContactImage2(empty)
  ContactImage3(empty)
  BrokerOfRecordLogo(empty)
  MainArticle(empty)
  Location(empty)
  FeaturedImage(empty)
  Image(empty)
  UsersProperty(empty)
  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/3414/265-olney-street-east-side-of-providence-ri-02906-usa
Query String
Request Method	GET
Server Protocol	HTTP/1.1
Gateway Interface	CGI/1.1
Redirect Url	/property-detail/3414/265-olney-street-east-side-of-providence-ri-02906-usa
Remote Port	19764
Script Filename	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot/index.php
Server Admin	root@localhost
Context Document Root	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot
Context Prefix
Request Scheme	https
Document Root	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot
Remote Addr	162.159.115.42
Server Port	443
Server Addr	172.24.32.44
Server Name	staging2.leveragere.com
Server Software	Apache
Server Signature
Path	/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin
Http Host	staging2.leveragere.com
Http Connection	Keep-Alive
Http X Forwarded Proto	https
Http Cf Visitor	{"scheme":"https"}
Http Cf Ipcountry	US
Http Cf Connecting Ip	216.73.216.172
Http Cdn Loop	cloudflare; loops=1
Http 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	a09efa90ba83452a-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	aipm3ul-mceWbO-XchEpXgAAABQ
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	aipm3ul-mceWbO-XchEpXgAAABQ
Fcgi Role	RESPONDER
Php Self	/index.php
Request Time Float	1781163742.9329
Request Time	1781163742

====

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