Locations / New London, NH, USA

New London, NH, USA

With elegance and grace the Lake Sunapee Region has become a hub of culture and community in central New Hampshire. This melting pot of remarkable school systems, luring mountain ranges, charming neighbor hoods, and luminous waterbodies is perfect for the first- time homebuyer or the second-home buyer. Enjoy a show in a renovated barn, tee up for a cause, hit the slopes with friends, or savor a cocktail on your sunset dinner boat cruise. We’ve got it all, and it’s waiting for you!

Location Represented By

License #: 012345

11:27pm local time
30 thousand population

Partner Search

Find partners with a map-based search

Related Locations

Richmond, VA, USA

Martha’s Vineyard, MA, USA

Bullhead City, AZ, USA

Greenwich, CT, USA

Greenwich is one of the most prestigious waterfront yet bucolic towns to live.

Related Partners

Amherst Madison Partners

Cell: (208) 573-1619 | Email
License #: 012345

Ascent Real Estate

(619) 325-4100 | Email
License #: 012345

Pam Harrington Exclusives

Office: (843) 768-3635 | Email
License #: 012345

@Home Realty

Direct: (616) 935-9001 | Email
License #: 012345

Recent Property Listings

Boutique State-of-the-Art Condo in the West Village

385 West 12th Street
New York, NY 10014
$5,000,000

Beautiful Mid Century Gem

2544 Greenvalley Road
Los Angeles, CA 90046
$2,450,000

Historic landmark estate in Langham area of Pasadena

1330 Hillcrest Avenue
Pasadena, CA 91106
$6,500,000

Downtown Dupont Luxury

1737 Connecticut Avenue, NW, #502
Washington, DC 20009
$1,575,000

Property Search

Bedrooms

Baths

Minimum Price

Maximum Price

Array
(
)

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

Cake Params
- plugin(null)
- controllerlocations
- actionview
- named(empty)
- pass(array)
  013
  1new-london-nh-usa
- isAjax(false)
Post data

No post data.

Query string

No querystring data.

Cookie
- 0(empty)
Current Route
- keys(array)
  0controller
  1action
- options(array)
  defaultRoute(true)
- defaults(array)
  plugin(null)
- template/:controller/:action/*
====

Sql Log

Sql Logs

default

Total Time: 24 ms
Total Queries: 19 queries

Query	Affected	Num. rows	Took (ms)	Actions
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`, `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`.`assets` AS `Image` ON (`Image`.`model_id` = `Location`.`id` AND `Image`.`model` = 'Location' AND `Image`.`tag` = 'Image') WHERE `Location`.`id` = 13 AND `Location`.`archived` = '0' LIMIT 1	1	1	1
SELECT `Brokerage`.`id`, `Brokerage`.`account_executive_id`, `Brokerage`.`archived`, `Brokerage`.`type`, `Brokerage`.`hide_from_frontend`, `Brokerage`.`agent_brokerage_data_override`, `Brokerage`.`featured_development`, `Brokerage`.`membership_type`, `Brokerage`.`max_properties`, `Brokerage`.`max_homepage_featured_by_member_properties`, `Brokerage`.`featured_properties_sort_method`, `Brokerage`.`lux_feed_mode`, `Brokerage`.`max_luxury_feed_properties`, `Brokerage`.`membership_luxury_feed_properties`, `Brokerage`.`can_participate_in_lux_feed_while_archived`, `Brokerage`.`full_training_video_access`, `Brokerage`.`country_id`, `Brokerage`.`WOEID`, `Brokerage`.`timezone`, `Brokerage`.`luxury_feed_enrollment_mode`, `Brokerage`.`luxury_feed_include_mlsidx_minimum_price`, `Brokerage`.`luxury_feed_include_leverage_minimum_price`, `Brokerage`.`digital_ad_contacts`, `Brokerage`.`add_agents_to_grr_auto_recipients`, `Brokerage`.`mlsidx_id`, `Brokerage`.`mlsidx_lux_autofeed`, `Brokerage`.`mlsidx_lux_autofeed_minimum_price`, `Brokerage`.`mlsidx_logo_url`, `Brokerage`.`mlsidx_disclaimer`, `Brokerage`.`name`, `Brokerage`.`broker_of_record_name`, `Brokerage`.`short_name`, `Brokerage`.`username`, `Brokerage`.`password`, `Brokerage`.`password_reset_hash`, `Brokerage`.`monthly_invoice_amount`, `Brokerage`.`monthly_invoice_start_date`, `Brokerage`.`monthly_invoice_end_date`, `Brokerage`.`contract_filename`, `Brokerage`.`active`, `Brokerage`.`lead_in`, `Brokerage`.`short_description`, `Brokerage`.`description`, `Brokerage`.`communities`, `Brokerage`.`website`, `Brokerage`.`address`, `Brokerage`.`address_2`, `Brokerage`.`city`, `Brokerage`.`state`, `Brokerage`.`full_state`, `Brokerage`.`country`, `Brokerage`.`market`, `Brokerage`.`market_2`, `Brokerage`.`postal_code`, `Brokerage`.`phone`, `Brokerage`.`phone_2`, `Brokerage`.`phone_3`, `Brokerage`.`wide_contact_image`, `Brokerage`.`contact_name`, `Brokerage`.`contact_profile_link`, `Brokerage`.`contact_big_profile_link`, `Brokerage`.`contact_big_profile_link_text`, `Brokerage`.`contact_title`, `Brokerage`.`contact_dre_num`, `Brokerage`.`contact_quote`, `Brokerage`.`contact_email`, `Brokerage`.`contact_facebook`, `Brokerage`.`contact_twitter`, `Brokerage`.`contact_instagram`, `Brokerage`.`contact_pinterest`, `Brokerage`.`contact_linkedin`, `Brokerage`.`contact_youtube`, `Brokerage`.`contact_phone`, `Brokerage`.`contact_email_2`, `Brokerage`.`contact_2_facebook`, `Brokerage`.`contact_2_twitter`, `Brokerage`.`contact_2_instagram`, `Brokerage`.`contact_2_pinterest`, `Brokerage`.`contact_2_linkedin`, `Brokerage`.`contact_2_youtube`, `Brokerage`.`contact_phone_2`, `Brokerage`.`contact_website`, `Brokerage`.`contact_name_2`, `Brokerage`.`contact_profile_link_2`, `Brokerage`.`contact_big_profile_link_2`, `Brokerage`.`contact_big_profile_link_text_2`, `Brokerage`.`contact_title_2`, `Brokerage`.`contact_dre_num_2`, `Brokerage`.`contact_email_3`, `Brokerage`.`contact_name_3`, `Brokerage`.`contact_title_3`, `Brokerage`.`contact_dre_num_3`, `Brokerage`.`contact_phone_3`, `Brokerage`.`contact_3_facebook`, `Brokerage`.`contact_3_twitter`, `Brokerage`.`contact_3_instagram`, `Brokerage`.`contact_3_pinterest`, `Brokerage`.`contact_3_linkedin`, `Brokerage`.`contact_3_youtube`, `Brokerage`.`image_filename`, `Brokerage`.`logo_filename`, `Brokerage`.`contact_image_filename`, `Brokerage`.`all_properties_link_image_filename`, `Brokerage`.`all_properties_link`, `Brokerage`.`video_embed_code`, `Brokerage`.`contact_video_embed_code`, `Brokerage`.`meta_title`, `Brokerage`.`meta_description`, `Brokerage`.`meta_keywords`, `Brokerage`.`login_message_counter`, `Brokerage`.`stats_module_1_type`, `Brokerage`.`stats_module_1_value`, `Brokerage`.`stats_module_2_type`, `Brokerage`.`stats_module_2_value`, `Brokerage`.`stats_module_3_type`, `Brokerage`.`stats_module_3_value`, `Brokerage`.`last_activity_email_sent`, `Brokerage`.`converted`, `Brokerage`.`created`, `Brokerage`.`modified`, `Brokerage`.`dre_num`, `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`, `Logo`.`id`, `Logo`.`model`, `Logo`.`model_id`, `Logo`.`tag`, `Logo`.`name`, `Logo`.`type`, `Logo`.`size`, `Logo`.`uri`, `Logo`.`order`, `Logo`.`created`, `Logo`.`modified`, `MainImage`.`id`, `MainImage`.`model`, `MainImage`.`model_id`, `MainImage`.`tag`, `MainImage`.`name`, `MainImage`.`type`, `MainImage`.`size`, `MainImage`.`uri`, `MainImage`.`order`, `MainImage`.`created`, `MainImage`.`modified`, `ContactImage`.`id`, `ContactImage`.`model`, `ContactImage`.`model_id`, `ContactImage`.`tag`, `ContactImage`.`name`, `ContactImage`.`type`, `ContactImage`.`size`, `ContactImage`.`uri`, `ContactImage`.`order`, `ContactImage`.`created`, `ContactImage`.`modified`, `ContactImage2`.`id`, `ContactImage2`.`model`, `ContactImage2`.`model_id`, `ContactImage2`.`tag`, `ContactImage2`.`name`, `ContactImage2`.`type`, `ContactImage2`.`size`, `ContactImage2`.`uri`, `ContactImage2`.`order`, `ContactImage2`.`created`, `ContactImage2`.`modified`, `ContactImage3`.`id`, `ContactImage3`.`model`, `ContactImage3`.`model_id`, `ContactImage3`.`tag`, `ContactImage3`.`name`, `ContactImage3`.`type`, `ContactImage3`.`size`, `ContactImage3`.`uri`, `ContactImage3`.`order`, `ContactImage3`.`created`, `ContactImage3`.`modified`, `BrokerOfRecordLogo`.`id`, `BrokerOfRecordLogo`.`model`, `BrokerOfRecordLogo`.`model_id`, `BrokerOfRecordLogo`.`tag`, `BrokerOfRecordLogo`.`name`, `BrokerOfRecordLogo`.`type`, `BrokerOfRecordLogo`.`size`, `BrokerOfRecordLogo`.`uri`, `BrokerOfRecordLogo`.`order`, `BrokerOfRecordLogo`.`created`, `BrokerOfRecordLogo`.`modified`, `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`.`brokerages` AS `Brokerage` LEFT JOIN `leveragere_staging2`.`users` AS `AccountExecutive` ON (`Brokerage`.`account_executive_id` = `AccountExecutive`.`id`) LEFT JOIN `leveragere_staging2`.`assets` AS `Logo` ON (`Logo`.`model_id` = `Brokerage`.`id` AND `Logo`.`model` = 'Brokerage' AND `Logo`.`tag` = 'Logo') LEFT JOIN `leveragere_staging2`.`assets` AS `MainImage` ON (`MainImage`.`model_id` = `Brokerage`.`id` AND `MainImage`.`model` = 'Brokerage' AND `MainImage`.`tag` = 'MainImage') LEFT JOIN `leveragere_staging2`.`assets` AS `ContactImage` ON (`ContactImage`.`model_id` = `Brokerage`.`id` AND `ContactImage`.`model` = 'Brokerage' AND `ContactImage`.`tag` = 'ContactImage') LEFT JOIN `leveragere_staging2`.`assets` AS `ContactImage2` ON (`ContactImage2`.`model_id` = `Brokerage`.`id` AND `ContactImage2`.`model` = 'Brokerage' AND `ContactImage2`.`tag` = 'ContactImage2') LEFT JOIN `leveragere_staging2`.`assets` AS `ContactImage3` ON (`ContactImage3`.`model_id` = `Brokerage`.`id` AND `ContactImage3`.`model` = 'Brokerage' AND `ContactImage3`.`tag` = 'ContactImage3') LEFT JOIN `leveragere_staging2`.`assets` AS `BrokerOfRecordLogo` ON (`BrokerOfRecordLogo`.`model_id` = `Brokerage`.`id` AND `BrokerOfRecordLogo`.`model` = 'Brokerage' AND `BrokerOfRecordLogo`.`tag` = 'BrokerOfRecordLogo') LEFT JOIN `leveragere_staging2`.`articles` AS `MainArticle` ON (`MainArticle`.`model_id` = `Brokerage`.`id` AND `MainArticle`.`model` = 'Brokerage') WHERE `Brokerage`.`id` = 91 LIMIT 1	1	1	3	maybe slow
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` = (91) 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` = (91)	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` = (91)	7	7	0
SELECT `Article`.`id`, `Article`.`model`, `Article`.`model_id`, `Article`.`archived`, `Article`.`medium_featured`, `Article`.`large_featured`, `Article`.`title`, `Article`.`author`, `Article`.`date`, `Article`.`lead_in`, `Article`.`body`, `Article`.`vimeo_id`, `Article`.`created`, `Article`.`modified`, `ParentBrokerage`.`id`, `ParentBrokerage`.`account_executive_id`, `ParentBrokerage`.`archived`, `ParentBrokerage`.`type`, `ParentBrokerage`.`hide_from_frontend`, `ParentBrokerage`.`agent_brokerage_data_override`, `ParentBrokerage`.`featured_development`, `ParentBrokerage`.`membership_type`, `ParentBrokerage`.`max_properties`, `ParentBrokerage`.`max_homepage_featured_by_member_properties`, `ParentBrokerage`.`featured_properties_sort_method`, `ParentBrokerage`.`lux_feed_mode`, `ParentBrokerage`.`max_luxury_feed_properties`, `ParentBrokerage`.`membership_luxury_feed_properties`, `ParentBrokerage`.`can_participate_in_lux_feed_while_archived`, `ParentBrokerage`.`full_training_video_access`, `ParentBrokerage`.`country_id`, `ParentBrokerage`.`WOEID`, `ParentBrokerage`.`timezone`, `ParentBrokerage`.`luxury_feed_enrollment_mode`, `ParentBrokerage`.`luxury_feed_include_mlsidx_minimum_price`, `ParentBrokerage`.`luxury_feed_include_leverage_minimum_price`, `ParentBrokerage`.`digital_ad_contacts`, `ParentBrokerage`.`add_agents_to_grr_auto_recipients`, `ParentBrokerage`.`mlsidx_id`, `ParentBrokerage`.`mlsidx_lux_autofeed`, `ParentBrokerage`.`mlsidx_lux_autofeed_minimum_price`, `ParentBrokerage`.`mlsidx_logo_url`, `ParentBrokerage`.`mlsidx_disclaimer`, `ParentBrokerage`.`name`, `ParentBrokerage`.`broker_of_record_name`, `ParentBrokerage`.`short_name`, `ParentBrokerage`.`username`, `ParentBrokerage`.`password`, `ParentBrokerage`.`password_reset_hash`, `ParentBrokerage`.`monthly_invoice_amount`, `ParentBrokerage`.`monthly_invoice_start_date`, `ParentBrokerage`.`monthly_invoice_end_date`, `ParentBrokerage`.`contract_filename`, `ParentBrokerage`.`active`, `ParentBrokerage`.`lead_in`, `ParentBrokerage`.`short_description`, `ParentBrokerage`.`description`, `ParentBrokerage`.`communities`, `ParentBrokerage`.`website`, `ParentBrokerage`.`address`, `ParentBrokerage`.`address_2`, `ParentBrokerage`.`city`, `ParentBrokerage`.`state`, `ParentBrokerage`.`full_state`, `ParentBrokerage`.`country`, `ParentBrokerage`.`market`, `ParentBrokerage`.`market_2`, `ParentBrokerage`.`postal_code`, `ParentBrokerage`.`phone`, `ParentBrokerage`.`phone_2`, `ParentBrokerage`.`phone_3`, `ParentBrokerage`.`wide_contact_image`, `ParentBrokerage`.`contact_name`, `ParentBrokerage`.`contact_profile_link`, `ParentBrokerage`.`contact_big_profile_link`, `ParentBrokerage`.`contact_big_profile_link_text`, `ParentBrokerage`.`contact_title`, `ParentBrokerage`.`contact_dre_num`, `ParentBrokerage`.`contact_quote`, `ParentBrokerage`.`contact_email`, `ParentBrokerage`.`contact_facebook`, `ParentBrokerage`.`contact_twitter`, `ParentBrokerage`.`contact_instagram`, `ParentBrokerage`.`contact_pinterest`, `ParentBrokerage`.`contact_linkedin`, `ParentBrokerage`.`contact_youtube`, `ParentBrokerage`.`contact_phone`, `ParentBrokerage`.`contact_email_2`, `ParentBrokerage`.`contact_2_facebook`, `ParentBrokerage`.`contact_2_twitter`, `ParentBrokerage`.`contact_2_instagram`, `ParentBrokerage`.`contact_2_pinterest`, `ParentBrokerage`.`contact_2_linkedin`, `ParentBrokerage`.`contact_2_youtube`, `ParentBrokerage`.`contact_phone_2`, `ParentBrokerage`.`contact_website`, `ParentBrokerage`.`contact_name_2`, `ParentBrokerage`.`contact_profile_link_2`, `ParentBrokerage`.`contact_big_profile_link_2`, `ParentBrokerage`.`contact_big_profile_link_text_2`, `ParentBrokerage`.`contact_title_2`, `ParentBrokerage`.`contact_dre_num_2`, `ParentBrokerage`.`contact_email_3`, `ParentBrokerage`.`contact_name_3`, `ParentBrokerage`.`contact_title_3`, `ParentBrokerage`.`contact_dre_num_3`, `ParentBrokerage`.`contact_phone_3`, `ParentBrokerage`.`contact_3_facebook`, `ParentBrokerage`.`contact_3_twitter`, `ParentBrokerage`.`contact_3_instagram`, `ParentBrokerage`.`contact_3_pinterest`, `ParentBrokerage`.`contact_3_linkedin`, `ParentBrokerage`.`contact_3_youtube`, `ParentBrokerage`.`image_filename`, `ParentBrokerage`.`logo_filename`, `ParentBrokerage`.`contact_image_filename`, `ParentBrokerage`.`all_properties_link_image_filename`, `ParentBrokerage`.`all_properties_link`, `ParentBrokerage`.`video_embed_code`, `ParentBrokerage`.`contact_video_embed_code`, `ParentBrokerage`.`meta_title`, `ParentBrokerage`.`meta_description`, `ParentBrokerage`.`meta_keywords`, `ParentBrokerage`.`login_message_counter`, `ParentBrokerage`.`stats_module_1_type`, `ParentBrokerage`.`stats_module_1_value`, `ParentBrokerage`.`stats_module_2_type`, `ParentBrokerage`.`stats_module_2_value`, `ParentBrokerage`.`stats_module_3_type`, `ParentBrokerage`.`stats_module_3_value`, `ParentBrokerage`.`last_activity_email_sent`, `ParentBrokerage`.`converted`, `ParentBrokerage`.`created`, `ParentBrokerage`.`modified`, `ParentBrokerage`.`dre_num`, `ParentLocation`.`id`, `ParentLocation`.`parent_id`, `ParentLocation`.`brokerage_id`, `ParentLocation`.`type`, `ParentLocation`.`archived`, `ParentLocation`.`use_as_topic`, `ParentLocation`.`name`, `ParentLocation`.`short_name`, `ParentLocation`.`group_index`, `ParentLocation`.`latitude`, `ParentLocation`.`longitude`, `ParentLocation`.`country_code`, `ParentLocation`.`north`, `ParentLocation`.`south`, `ParentLocation`.`east`, `ParentLocation`.`west`, `ParentLocation`.`zoom`, `ParentLocation`.`short_description`, `ParentLocation`.`long_description`, `ParentLocation`.`created`, `ParentLocation`.`modified`, `ParentLocation`.`timezone`, `ParentLocation`.`population` FROM `leveragere_staging2`.`articles` AS `Article` LEFT JOIN `leveragere_staging2`.`brokerages` AS `ParentBrokerage` ON (`Article`.`model_id` = `ParentBrokerage`.`id` AND `Article`.`model` = 'Brokerage') LEFT JOIN `leveragere_staging2`.`locations` AS `ParentLocation` ON (`Article`.`model_id` = `ParentLocation`.`id` AND `Article`.`model` = 'Location') WHERE `Article`.`model` = 'Location' AND `Article`.`model_id` = 13 LIMIT 1	0	0	1	maybe slow
SELECT `Location`.`id`, `Location`.`name`, `Location`.`parent_id` FROM `leveragere_staging2`.`locations` AS `Location` WHERE `Location`.`id` = 13 AND `Location`.`archived` = '0' LIMIT 1	1	1	0
SELECT `Location`.`id`, `Location`.`name` FROM `leveragere_staging2`.`locations` AS `Location` WHERE `Location`.`parent_id` = 13	0	0	0
SELECT `Location`.`id`, `Location`.`brokerage_id` FROM `leveragere_staging2`.`locations` AS `Location` WHERE `Location`.`brokerage_id` != 0 AND `Location`.`id` IS NULL	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`.`brokerage_id` IS NULL AND `Property`.`incomplete` = '0'	0	0	1	maybe slow
SELECT `Location`.`id`, `Location`.`parent_id`, `Location`.`brokerage_id`, `Location`.`type`, `Location`.`archived`, `Location`.`use_as_topic`, `Location`.`name`, `Location`.`short_name`, `Location`.`group_index`, `Location`.`latitude`, `Location`.`longitude`, `Location`.`country_code`, `Location`.`north`, `Location`.`south`, `Location`.`east`, `Location`.`west`, `Location`.`zoom`, `Location`.`short_description`, `Location`.`long_description`, `Location`.`created`, `Location`.`modified`, `Location`.`timezone`, `Location`.`population`, `Brokerage`.`id`, `Brokerage`.`account_executive_id`, `Brokerage`.`archived`, `Brokerage`.`type`, `Brokerage`.`hide_from_frontend`, `Brokerage`.`agent_brokerage_data_override`, `Brokerage`.`featured_development`, `Brokerage`.`membership_type`, `Brokerage`.`max_properties`, `Brokerage`.`max_homepage_featured_by_member_properties`, `Brokerage`.`featured_properties_sort_method`, `Brokerage`.`lux_feed_mode`, `Brokerage`.`max_luxury_feed_properties`, `Brokerage`.`membership_luxury_feed_properties`, `Brokerage`.`can_participate_in_lux_feed_while_archived`, `Brokerage`.`full_training_video_access`, `Brokerage`.`country_id`, `Brokerage`.`WOEID`, `Brokerage`.`timezone`, `Brokerage`.`luxury_feed_enrollment_mode`, `Brokerage`.`luxury_feed_include_mlsidx_minimum_price`, `Brokerage`.`luxury_feed_include_leverage_minimum_price`, `Brokerage`.`digital_ad_contacts`, `Brokerage`.`add_agents_to_grr_auto_recipients`, `Brokerage`.`mlsidx_id`, `Brokerage`.`mlsidx_lux_autofeed`, `Brokerage`.`mlsidx_lux_autofeed_minimum_price`, `Brokerage`.`mlsidx_logo_url`, `Brokerage`.`mlsidx_disclaimer`, `Brokerage`.`name`, `Brokerage`.`broker_of_record_name`, `Brokerage`.`short_name`, `Brokerage`.`username`, `Brokerage`.`password`, `Brokerage`.`password_reset_hash`, `Brokerage`.`monthly_invoice_amount`, `Brokerage`.`monthly_invoice_start_date`, `Brokerage`.`monthly_invoice_end_date`, `Brokerage`.`contract_filename`, `Brokerage`.`active`, `Brokerage`.`lead_in`, `Brokerage`.`short_description`, `Brokerage`.`description`, `Brokerage`.`communities`, `Brokerage`.`website`, `Brokerage`.`address`, `Brokerage`.`address_2`, `Brokerage`.`city`, `Brokerage`.`state`, `Brokerage`.`full_state`, `Brokerage`.`country`, `Brokerage`.`market`, `Brokerage`.`market_2`, `Brokerage`.`postal_code`, `Brokerage`.`phone`, `Brokerage`.`phone_2`, `Brokerage`.`phone_3`, `Brokerage`.`wide_contact_image`, `Brokerage`.`contact_name`, `Brokerage`.`contact_profile_link`, `Brokerage`.`contact_big_profile_link`, `Brokerage`.`contact_big_profile_link_text`, `Brokerage`.`contact_title`, `Brokerage`.`contact_dre_num`, `Brokerage`.`contact_quote`, `Brokerage`.`contact_email`, `Brokerage`.`contact_facebook`, `Brokerage`.`contact_twitter`, `Brokerage`.`contact_instagram`, `Brokerage`.`contact_pinterest`, `Brokerage`.`contact_linkedin`, `Brokerage`.`contact_youtube`, `Brokerage`.`contact_phone`, `Brokerage`.`contact_email_2`, `Brokerage`.`contact_2_facebook`, `Brokerage`.`contact_2_twitter`, `Brokerage`.`contact_2_instagram`, `Brokerage`.`contact_2_pinterest`, `Brokerage`.`contact_2_linkedin`, `Brokerage`.`contact_2_youtube`, `Brokerage`.`contact_phone_2`, `Brokerage`.`contact_website`, `Brokerage`.`contact_name_2`, `Brokerage`.`contact_profile_link_2`, `Brokerage`.`contact_big_profile_link_2`, `Brokerage`.`contact_big_profile_link_text_2`, `Brokerage`.`contact_title_2`, `Brokerage`.`contact_dre_num_2`, `Brokerage`.`contact_email_3`, `Brokerage`.`contact_name_3`, `Brokerage`.`contact_title_3`, `Brokerage`.`contact_dre_num_3`, `Brokerage`.`contact_phone_3`, `Brokerage`.`contact_3_facebook`, `Brokerage`.`contact_3_twitter`, `Brokerage`.`contact_3_instagram`, `Brokerage`.`contact_3_pinterest`, `Brokerage`.`contact_3_linkedin`, `Brokerage`.`contact_3_youtube`, `Brokerage`.`image_filename`, `Brokerage`.`logo_filename`, `Brokerage`.`contact_image_filename`, `Brokerage`.`all_properties_link_image_filename`, `Brokerage`.`all_properties_link`, `Brokerage`.`video_embed_code`, `Brokerage`.`contact_video_embed_code`, `Brokerage`.`meta_title`, `Brokerage`.`meta_description`, `Brokerage`.`meta_keywords`, `Brokerage`.`login_message_counter`, `Brokerage`.`stats_module_1_type`, `Brokerage`.`stats_module_1_value`, `Brokerage`.`stats_module_2_type`, `Brokerage`.`stats_module_2_value`, `Brokerage`.`stats_module_3_type`, `Brokerage`.`stats_module_3_value`, `Brokerage`.`last_activity_email_sent`, `Brokerage`.`converted`, `Brokerage`.`created`, `Brokerage`.`modified`, `Brokerage`.`dre_num`, `Image`.`id`, `Image`.`model`, `Image`.`model_id`, `Image`.`tag`, `Image`.`name`, `Image`.`type`, `Image`.`size`, `Image`.`uri`, `Image`.`order`, `Image`.`created`, `Image`.`modified` FROM `leveragere_staging2`.`locations` AS `Location` LEFT JOIN `leveragere_staging2`.`brokerages` AS `Brokerage` ON (`Location`.`brokerage_id` = `Brokerage`.`id`) LEFT JOIN `leveragere_staging2`.`assets` AS `Image` ON (`Image`.`model_id` = `Location`.`id` AND `Image`.`model` = 'Location' AND `Image`.`tag` = 'Image') WHERE `Location`.`type` = 'Exclusive' AND `Location`.`archived` = '0' ORDER BY RAND() ASC LIMIT 4	4	4	5	maybe slow
SELECT `Brokerage`.`id`, `Brokerage`.`account_executive_id`, `Brokerage`.`archived`, `Brokerage`.`type`, `Brokerage`.`hide_from_frontend`, `Brokerage`.`agent_brokerage_data_override`, `Brokerage`.`featured_development`, `Brokerage`.`membership_type`, `Brokerage`.`max_properties`, `Brokerage`.`max_homepage_featured_by_member_properties`, `Brokerage`.`featured_properties_sort_method`, `Brokerage`.`lux_feed_mode`, `Brokerage`.`max_luxury_feed_properties`, `Brokerage`.`membership_luxury_feed_properties`, `Brokerage`.`can_participate_in_lux_feed_while_archived`, `Brokerage`.`full_training_video_access`, `Brokerage`.`country_id`, `Brokerage`.`WOEID`, `Brokerage`.`timezone`, `Brokerage`.`luxury_feed_enrollment_mode`, `Brokerage`.`luxury_feed_include_mlsidx_minimum_price`, `Brokerage`.`luxury_feed_include_leverage_minimum_price`, `Brokerage`.`digital_ad_contacts`, `Brokerage`.`add_agents_to_grr_auto_recipients`, `Brokerage`.`mlsidx_id`, `Brokerage`.`mlsidx_lux_autofeed`, `Brokerage`.`mlsidx_lux_autofeed_minimum_price`, `Brokerage`.`mlsidx_logo_url`, `Brokerage`.`mlsidx_disclaimer`, `Brokerage`.`name`, `Brokerage`.`broker_of_record_name`, `Brokerage`.`short_name`, `Brokerage`.`username`, `Brokerage`.`password`, `Brokerage`.`password_reset_hash`, `Brokerage`.`monthly_invoice_amount`, `Brokerage`.`monthly_invoice_start_date`, `Brokerage`.`monthly_invoice_end_date`, `Brokerage`.`contract_filename`, `Brokerage`.`active`, `Brokerage`.`lead_in`, `Brokerage`.`short_description`, `Brokerage`.`description`, `Brokerage`.`communities`, `Brokerage`.`website`, `Brokerage`.`address`, `Brokerage`.`address_2`, `Brokerage`.`city`, `Brokerage`.`state`, `Brokerage`.`full_state`, `Brokerage`.`country`, `Brokerage`.`market`, `Brokerage`.`market_2`, `Brokerage`.`postal_code`, `Brokerage`.`phone`, `Brokerage`.`phone_2`, `Brokerage`.`phone_3`, `Brokerage`.`wide_contact_image`, `Brokerage`.`contact_name`, `Brokerage`.`contact_profile_link`, `Brokerage`.`contact_big_profile_link`, `Brokerage`.`contact_big_profile_link_text`, `Brokerage`.`contact_title`, `Brokerage`.`contact_dre_num`, `Brokerage`.`contact_quote`, `Brokerage`.`contact_email`, `Brokerage`.`contact_facebook`, `Brokerage`.`contact_twitter`, `Brokerage`.`contact_instagram`, `Brokerage`.`contact_pinterest`, `Brokerage`.`contact_linkedin`, `Brokerage`.`contact_youtube`, `Brokerage`.`contact_phone`, `Brokerage`.`contact_email_2`, `Brokerage`.`contact_2_facebook`, `Brokerage`.`contact_2_twitter`, `Brokerage`.`contact_2_instagram`, `Brokerage`.`contact_2_pinterest`, `Brokerage`.`contact_2_linkedin`, `Brokerage`.`contact_2_youtube`, `Brokerage`.`contact_phone_2`, `Brokerage`.`contact_website`, `Brokerage`.`contact_name_2`, `Brokerage`.`contact_profile_link_2`, `Brokerage`.`contact_big_profile_link_2`, `Brokerage`.`contact_big_profile_link_text_2`, `Brokerage`.`contact_title_2`, `Brokerage`.`contact_dre_num_2`, `Brokerage`.`contact_email_3`, `Brokerage`.`contact_name_3`, `Brokerage`.`contact_title_3`, `Brokerage`.`contact_dre_num_3`, `Brokerage`.`contact_phone_3`, `Brokerage`.`contact_3_facebook`, `Brokerage`.`contact_3_twitter`, `Brokerage`.`contact_3_instagram`, `Brokerage`.`contact_3_pinterest`, `Brokerage`.`contact_3_linkedin`, `Brokerage`.`contact_3_youtube`, `Brokerage`.`image_filename`, `Brokerage`.`logo_filename`, `Brokerage`.`contact_image_filename`, `Brokerage`.`all_properties_link_image_filename`, `Brokerage`.`all_properties_link`, `Brokerage`.`video_embed_code`, `Brokerage`.`contact_video_embed_code`, `Brokerage`.`meta_title`, `Brokerage`.`meta_description`, `Brokerage`.`meta_keywords`, `Brokerage`.`login_message_counter`, `Brokerage`.`stats_module_1_type`, `Brokerage`.`stats_module_1_value`, `Brokerage`.`stats_module_2_type`, `Brokerage`.`stats_module_2_value`, `Brokerage`.`stats_module_3_type`, `Brokerage`.`stats_module_3_value`, `Brokerage`.`last_activity_email_sent`, `Brokerage`.`converted`, `Brokerage`.`created`, `Brokerage`.`modified`, `Brokerage`.`dre_num`, `Logo`.`id`, `Logo`.`model`, `Logo`.`model_id`, `Logo`.`tag`, `Logo`.`name`, `Logo`.`type`, `Logo`.`size`, `Logo`.`uri`, `Logo`.`order`, `Logo`.`created`, `Logo`.`modified` FROM `leveragere_staging2`.`brokerages` AS `Brokerage` LEFT JOIN `leveragere_staging2`.`assets` AS `Logo` ON (`Logo`.`model_id` = `Brokerage`.`id` AND `Logo`.`model` = 'Brokerage' AND `Logo`.`tag` = 'Logo') WHERE `Brokerage`.`archived` = '0' ORDER BY RAND() ASC LIMIT 4	4	4	4
SELECT `Property`.`id` FROM `leveragere_staging2`.`properties` AS `Property` WHERE `Property`.`archived` = '0' AND `Property`.`incomplete` = '0' ORDER BY `Property`.`created` DESC LIMIT 50	50	50	3	maybe slow
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` IN (3762, 3761, 3760, 3759, 3758, 3757, 3756, 3755, 3754, 3753, 3752, 3749, 3747, 3745, 3743, 3742, 3741, 3740, 3739, 3738, 3736, 3734, 3733, 3732, 3731, 3730, 3729, 3728, 3727, 3726, 3724, 3723, 3722, 3721, 3719, 3718, 3717, 3716, 3715, 3714, 3713, 3712, 3711, 3710, 3708, 3707, 3706, 3705, 3704, 3703) AND `Property`.`archived` = '0' AND `Brokerage`.`archived` = '0' AND `Property`.`incomplete` = '0' ORDER BY RAND() ASC LIMIT 4	4	4	5	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 (3754, 3711, 3756, 3708) ORDER BY `Image`.`order` ASC	32	32	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 (3754, 3711, 3756, 3708) AND `UsersProperty`.`user_id` = `User`.`id`) ORDER BY `UsersProperty`.`sort_order` ASC	6	6	0
SELECT `SecondaryPropertyCategory`.`id`, `SecondaryPropertyCategory`.`name`, `SecondaryPropertyCategory`.`created`, `SecondaryPropertyCategory`.`modified`, `PropertiesSecondaryPropertyCategory`.`id`, `PropertiesSecondaryPropertyCategory`.`property_id`, `PropertiesSecondaryPropertyCategory`.`property_category_id`, `PropertiesSecondaryPropertyCategory`.`created`, `PropertiesSecondaryPropertyCategory`.`modified` FROM `leveragere_staging2`.`property_categories` AS `SecondaryPropertyCategory` JOIN `leveragere_staging2`.`properties_secondary_property_categories` AS `PropertiesSecondaryPropertyCategory` ON (`PropertiesSecondaryPropertyCategory`.`property_id` IN (3754, 3711, 3756, 3708) 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 (3754, 3711, 3756, 3708) AND `PropertiesPropertyFeature`.`property_feature_id` = `PropertyFeature`.`id`)	3	3	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 (3754, 3711, 3756, 3708) AND `PropertiesTopic`.`topic_id` = `Topic`.`id`)	1	1	0

Query Explain:

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

====

Timer

Memory

Peak Memory Use 10.96 MB

Message	Memory use
Component initialization	2.88 MB
Controller action start	3.80 MB
Controller render start	6.68 MB
View render complete	7.24 MB

Timers

Total Request Time: 229 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	29.24
Event: Controller.initialize	3.89
Event: Controller.startup	1.17
Controller action	68.03
Event: Controller.beforeRender	10.77
» Processing toolbar data	10.68
Rendering View	91.77
» Event: View.beforeRender	0.27
» Rendering APP/View/Locations/view.ctp	2.54
» » Rendering APP/View/Elements/sidebar/brokerage_search.ctp	0.15
» » Rendering APP/View/Elements/sidebar/location_list.ctp	0.15
» » Rendering APP/View/Elements/sidebar/brokerage_list.ctp	0.15
» » Rendering APP/View/Elements/sidebar/property_list.ctp	1.24
» » » Rendering APP/View/Elements/static_property_price.ctp	0.38
» » » 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/static_property_price.ctp #4	0.13
» » Rendering APP/View/Elements/sidebar/property_search.ctp	0.20
» Event: View.afterRender	0.01
» Event: View.beforeLayout	0.01
» Rendering APP/View/Layouts/front.ctp	88.23
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)
 id3754
 brokerage_id16
 created_by_user_id0
 order0
 multi_unit(false)
 agent_1_id0
 agent_2_id0
 agent_3_id0
 nameBoutique State-of-the-Art Condo in the West Village
 incomplete(false)
 archived(false)
 last_archived0000-00-00 00:00:00
 auto_archived_from_mlsidx(false)
 paid_featured(false)
 featured(false)
 homepage_featured(false)
 brokerage_page_featured(false)
 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_time2019-10-29 20:09:29
 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_sent2019-10-31 20:45:16
 digital_ad_summary_price_changed(false)
 wsj_detail_urlhttps://realestate.wsj.com/newyork/2204846-385-west-12th-street-10014?mod=search&pos=7&page=1&
 ft_detail_urlhttps://propertylistings.ft.com/homes/2755194
 nyt_detail_urlhttps://www.nytimes.com/real-estate/usa/ny/new-york/west-village/homes-for-sale/385-west-12th-street/1106-PRCH-2762625
 juwai_detail_urlhttps://www.juwai.com/50318262.htm
 pgl_detail_urlhttps://www.propgoluxury.com/en/homes/2755194
 mg_detail_urlhttps://www.mansionglobal.com/newyork/2204846-385-west-12th-street-10014?mod=search&pos=6&page=1&&region=na,us
 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(false)
 description385 West 12th Street, a boutique and state-of-the-art condominium in the West Village, boasts this magnificent 3-bedroom, 2.5-bathroom apartment. It is meticulously designed to the highest standard and spans 2,711SF. A private elevator landing opens to the heart of the home. Upon entering, the thoughtful layout leads left to the living areas and additional bedrooms, ensuring privacy to the master suite which is to the right. A powder room is cleverly tucked opposite the landing, perfect for guests. The sitting room is anchored by a gas fireplace and leads to the light-filled living room. Separating the living and dining areas is discreet storage. Treetops and the cobblestoned street can be seen through the massive, floor-to-ceiling window that frames the dining room. Overlooking the dining room is an oversized chefâs kitchen; ideal for both large events, and intimate, countertop eating. It boasts custom white lacquered oak cabinetry complimented by the marble countertops and backsplash. Itâs equipped with top-of-the-line Miele and Gaggenau appliances, Franke sinks/faucets and wine fridge. The spacious master suite features a generous terrace, walk-in closet and stunning five-piece bathroom. The bathroom is outfitted in Italian marble with a deep-soaking tub, glass-enclosed shower, and radiant floor heating. A media room, home office, two additional bedrooms, an additional full bathroom and washer/dryer complete the home. Additional features include Control 4- fully integrated home automation. Completed in 2010, 385 West 12th Street is a boutique condominium with only 12 units among 7 stories. Amenities offer the perfect balance of leisure and entertainment and feature a recently renovated and beautifully landscaped rooftop with a 55-foot swimming pool, Jacuzzi, outdoor shower, two gas grills and dining space. Direct views of the Hudson River, the West Village, and Empire State Building, with views to the north crown the rooftop. Additional building amenities include a 24-hour doorman/concierge, millwork club locker in the lobby, bike storage, and cellar storage room.
 address385 West 12th Street
 address_23WEST
 cityNew York
 stateNY
 postal_code10014
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price5000000
 price_20
 price_usd5000000
 price_usd_20
 statusFor Sale
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(false)
 bedrooms0
 bedrooms_20
 bathrooms0
 bathrooms_20
 no_beds_baths(false)
 square_feet0
 square_meters
 acres0
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size0
 icon_1
 icon_2
 icon_3
 icon_4
 icon_5
 icon_6
 website
 meta_title
 meta_description
 meta_keywords
 bathrooms_partial0
 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_num123456
 wsj_property_typecondominium
 nyt_property_type5
 nyt_popular_features
 propgolux_property_type2
 juwai_property_typeApartments/Condo
 juwai_categoryresidential
 propgolux_property_style25
 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
 latitude40.737713
 longitude-74.008759
 invalid_required_fields
 invalid_optional_fields
 went_live_today(false)
 converted(false)
 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)
 modified2019-10-31 20:45:16
 created2019-10-29 20:06:20
 uri/property-detail/3754/385-west-12th-street-3west-new-york-ny-10014-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3754/385-west-12th-street-3west-new-york-ny-10014-usa
 address_concat385 West 12th Street 3WEST New York NY 10014 USA
 google_maps_query_string385+West+12th+Street+3WEST+New+York+NY+10014+USA
 luxury_ad_enrolled_prettyYES
 price_prettyUSD 5,000,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty0
 bathrooms_pretty0
 bathrooms_partial_pretty0
 bathrooms_3_4_pretty0
 feed_full_bathrooms0
 date_listed2019-10-29
 overridden_brokerage_nameCORE
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id16
 account_executive_id235
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties20
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id1
 WOEID12589342
 timezone
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameCORE
 broker_of_record_name
 short_nameCORE
 usernameCORENYC
 password6bbc31e8f00594b7e3433f0a9c0cd7334bff73ae
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date0000-00-00
 monthly_invoice_end_date0000-00-00
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionCORE is the exclusive representative for Leverage Global Partners in New York City, New York, USA. CORE is the leading, full-service, boutique real estate brokerage specializing in the marketing of premiere residential properties. Headquartered in New York City, CORE was founded by CEO Shaun Osher and Jack Cayre, who envisioned a dynamic boutique brokerage based on integrity, informed by expertise and driven by innovation. CORE offers comprehensive real estate solutions for buyers, sellers, landlords, investors and developers. The firm is powered by an integrated team of accomplished professionals with extensive expertise in all aspects of real estate transactions. Thanks to a unique marketing approach, CORE ensures that its clients earn the highest market-driven prices. Our agents educate and shepherd buyers, sellers and landlords through the sales or leasing process. And we partner closely with developers, from the earliest stages of a project through closing; partnerships, which boast a proven, profitable track record. Within the past 8 years, CORE has marketed more than 30 new development properties and is the #1 brokerage in its class.
 communitiesManhattan Chelsea New York City Tribeca Midtown
 websitehttp://corenyc.com/
 address104 Fifth Avenue
 address_2
 cityNew York
 stateNY
 full_stateNew York
 countryUSA
 marketNew York
 market_2
 postal_code10011
 phone(212) 726-0778
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameShaun Osher
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/blog/meet-shaun-osher-founder-and-ceo-of-core/
 contact_big_profile_link_text
 contact_titleFounder and CEO
 contact_dre_num
 contact_quoteI invite you to contact me personally about New York City real estate.
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename16.jpg
 logo_filename16.jpg
 contact_image_filename16.jpg
 all_properties_link_image_filename16.jpg
 all_properties_linkhttp://corenyc.com/listings
 video_embed_code<script type="text/javascript" src="http://videocontent.jloop.com/players/cxxGtpBt-qzxAOUo0.js"></script>
 contact_video_embed_code
 meta_titleNew York City Real Estate | CORE | Leverage Global Partners
 meta_descriptionCORE is Leverage Global Partners' exclusive representative in New York City, NY, USA.
 meta_keywordsnew york city real estate, manhattan real estate, shaun osher, CORE, leverage global partners
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2013-04-01 15:35:47
 modified2019-10-29 20:06:57
 dre_num012345
 uri/brokerage-detail/16/core
 website_shortcorenyc.com
 name_with_locationCORE
 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)
 id23063
 modelProperty
 model_id3754
 tagImage
 namePI-1tfv6b4i17.jpg
 typeimage/jpeg
 size1392149
 uri/assets/23063.jpg
 order0
 created2019-10-29 20:06:00
 modified2019-10-29 20:06:20
 1(array)
 id23071
 modelProperty
 model_id3754
 tagImage
 namePI-1tia0th4t2.jpg
 typeimage/jpeg
 size745950
 uri/assets/23071.jpg
 order1
 created2019-10-29 20:06:02
 modified2019-10-29 20:06:20
 2(array)
 id23061
 modelProperty
 model_id3754
 tagImage
 namePI-1tfv6ad5r0.jpg
 typeimage/jpeg
 size953561
 uri/assets/23061.jpg
 order2
 created2019-10-29 20:06:00
 modified2019-10-29 20:06:20
 3(array)
 id23062
 modelProperty
 model_id3754
 tagImage
 namePI-1tfv5v65vv.jpg
 typeimage/jpeg
 size1120705
 uri/assets/23062.jpg
 order3
 created2019-10-29 20:06:00
 modified2019-10-29 20:06:20
 4(array)
 id23064
 modelProperty
 model_id3754
 tagImage
 namePI-1tfv5ud7qf.jpg
 typeimage/jpeg
 size819805
 uri/assets/23064.jpg
 order4
 created2019-10-29 20:06:00
 modified2019-10-29 20:06:20
 5(array)
 id23065
 modelProperty
 model_id3754
 tagImage
 namePI-1tfv5u6hao.jpg
 typeimage/jpeg
 size1354457
 uri/assets/23065.jpg
 order5
 created2019-10-29 20:06:00
 modified2019-10-29 20:06:20
 6(array)
 id23066
 modelProperty
 model_id3754
 tagImage
 namePI-1tfv6c8c2k.jpg
 typeimage/jpeg
 size667117
 uri/assets/23066.jpg
 order6
 created2019-10-29 20:06:00
 modified2019-10-29 20:06:20
 7(array)
 id23067
 modelProperty
 model_id3754
 tagImage
 namePI-1tfv62hm1n.jpg
 typeimage/jpeg
 size1142542
 uri/assets/23067.jpg
 order7
 created2019-10-29 20:06:01
 modified2019-10-29 20:06:20
 8(array)
 id23068
 modelProperty
 model_id3754
 tagImage
 namePI-1tfv60kn0g.jpg
 typeimage/jpeg
 size900053
 uri/assets/23068.jpg
 order8
 created2019-10-29 20:06:01
 modified2019-10-29 20:06:20
 9(array)
 id23069
 modelProperty
 model_id3754
 tagImage
 namePI-1tia0rna64.jpg
 typeimage/jpeg
 size667255
 uri/assets/23069.jpg
 order9
 created2019-10-29 20:06:01
 modified2019-10-29 20:06:20
 10(array)
 id23070
 modelProperty
 model_id3754
 tagImage
 namePI-1tfv64a3ih.jpg
 typeimage/jpeg
 size1295530
 uri/assets/23070.jpg
 order10
 created2019-10-29 20:06:01
 modified2019-10-29 20:06:20
 11(array)
 id23072
 modelProperty
 model_id3754
 tagImage
 namePI-1tia0uv5i1.jpg
 typeimage/jpeg
 size816357
 uri/assets/23072.jpg
 order11
 created2019-10-29 20:06:02
 modified2019-10-29 20:06:20
 12(array)
 id23073
 modelProperty
 model_id3754
 tagImage
 namePI-1tfv64q2c3.jpg
 typeimage/jpeg
 size1246171
 uri/assets/23073.jpg
 order12
 created2019-10-29 20:06:02
 modified2019-10-29 20:06:20
 13(array)
 id23074
 modelProperty
 model_id3754
 tagImage
 namePI-1tlejtukfi.jpg
 typeimage/jpeg
 size1296375
 uri/assets/23074.jpg
 order13
 created2019-10-29 20:06:02
 modified2019-10-29 20:06:20
 14(array)
 id23075
 modelProperty
 model_id3754
 tagImage
 namePI-1tlek8ckib.jpg
 typeimage/jpeg
 size821336
 uri/assets/23075.jpg
 order14
 created2019-10-29 20:06:02
 modified2019-10-29 20:06:20
 15(array)
 id23076
 modelProperty
 model_id3754
 tagImage
 namePI-1tlek3e9dr.jpg
 typeimage/jpeg
 size1122053
 uri/assets/23076.jpg
 order15
 created2019-10-29 20:06:02
 modified2019-10-29 20:06:20
 16(array)
 id23077
 modelProperty
 model_id3754
 tagImage
 namePI-1tlek0qvrl.jpg
 typeimage/jpeg
 size1277836
 uri/assets/23077.jpg
 order16
 created2019-10-29 20:06:03
 modified2019-10-29 20:06:20
 17(array)
 id23078
 modelProperty
 model_id3754
 tagImage
 namePI-1tlek8f4uk.jpg
 typeimage/jpeg
 size955578
 uri/assets/23078.jpg
 order17
 created2019-10-29 20:06:03
 modified2019-10-29 20:06:20
 18(array)
 id23079
 modelProperty
 model_id3754
 tagImage
 namePI-1tlek8p84e.jpg
 typeimage/jpeg
 size900653
 uri/assets/23079.jpg
 order18
 created2019-10-29 20:06:03
 modified2019-10-29 20:06:20
 19(array)
 id23080
 modelProperty
 model_id3754
 tagImage
 namePI-1tfv5smv25.jpg
 typeimage/jpeg
 size1276220
 uri/assets/23080.jpg
 order19
 created2019-10-29 20:06:10
 modified2019-10-29 20:06:20
 User(empty)
 SecondaryPropertyCategory(empty)
 PropertyFeature(empty)
 Topic(empty)
 1(array)
 Property(array)
 id3711
 brokerage_id142
 created_by_user_id0
 order0
 multi_unit(false)
 agent_1_id1184
 agent_2_id1185
 agent_3_id1227
 nameBeautiful Mid Century Gem
 incomplete(false)
 archived(false)
 last_archived0000-00-00 00:00:00
 auto_archived_from_mlsidx(false)
 paid_featured(false)
 featured(true)
 homepage_featured(false)
 brokerage_page_featured(true)
 requested_homepage_featured_by_member(false)
 homepage_featured_by_member(false)
 dot_luxury_featured(false)
 luxury_feed_featured(false)
 force_luxury_feed_featured(false)
 luxury_autofeed_imported(false)
 luxury_feed_last_added_time0000-00-00 00:00:00
 luxury_feed_agent_user_id0
 luxury_feed_locked_to_subscription_id0
 luxury_feed_agent_purchase_date0000-00-00
 luxury_feed_agent_expiration_date0000-00-00
 digital_ad_summary_email_last_sent0000-00-00 00:00:00
 digital_ad_summary_price_changed(false)
 wsj_detail_url
 ft_detail_url
 nyt_detail_url
 juwai_detail_url
 pgl_detail_url
 mg_detail_url
 mg_c_detail_url
 mg_s_detail_url
 bp_detail_url
 mw_detail_url
 nikkei_detail_url
 wapo_detail_url
 robb_detail_url
 medium_featured(false)
 large_featured(true)
 detail_page(true)
 descriptionBeautiful Mid Century home built by the distinguished Forrest Theriot as his personal residence in 1954, has been featured in numerous publications. Main house offers 3 bed, 3 bath, all with direct access to outdoor space, plus guest house with kitchenette and bath. With gourmet kitchen, floor to ceiling windows, stunning custom floors by artist Russell Metzger and open floor plan creating indoor outdoor flow and tons of natural light, ideal for entertaining! With generous tranquil outdoor space featuring multiple sitting areas and a secluded, quiet salt water pool. The extensive grounds with orange, lemon and avocado trees, and beautiful walking paths. All set off the street and tucked behind a gated entrance. Located in the Wonderland School District on one of the most highly desirable streets and a short distance to the Mulholland Tennis Club. This is a must see home, a true Hollywood Mid Century gem!
 address2544 Greenvalley Road
 address_2
 cityLos Angeles
 stateCA
 postal_code90046
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price2450000
 price_20
 price_usd2450000
 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
 bathrooms3
 bathrooms_20
 no_beds_baths(false)
 square_feet2200
 square_meters
 acres36
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size36
 icon_1sq-ft
 icon_2pool
 icon_3guest-house
 icon_4acreage
 icon_5views
 icon_6
 websitehttp://2544greenvalleyroad.thepartnerstrust.com/
 meta_titleBeautiful Mid Century Gem | Los Angeles Real Estate | Partners Trust Real Estate Brokerage and Acquisitions
 meta_description2544 Greenvalley Road is a property offered for sale in Los Angeles, CA, USA, presented by Partners Trust Real Estate Brokerage and Acquisitions
 meta_keywords
 bathrooms_partial0
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built1954
 virtual_tour
 video_tourhttp://www.onvedeo.com/properties/740299/embed
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num16110470
 wsj_property_typesingle family
 nyt_property_type1
 nyt_popular_features
 propgolux_property_type9
 juwai_property_type
 juwai_category
 propgolux_property_style42
 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
 latitude34.117191
 longitude34.117191
 invalid_required_fields
 invalid_optional_fieldssquare_meters, hectares, virtual_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-07 10:14:23
 uri/property-detail/3711/2544-greenvalley-road-los-angeles-ca-90046-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3711/2544-greenvalley-road-los-angeles-ca-90046-usa
 address_concat2544 Greenvalley Road Los Angeles CA 90046 USA
 google_maps_query_string2544+Greenvalley+Road++Los+Angeles+CA+90046+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 2,450,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty3
 bathrooms_pretty3
 bathrooms_partial_pretty0
 bathrooms_3_4_pretty0
 feed_full_bathrooms3
 date_listed2016-04-07
 overridden_brokerage_namePartners Trust Real Estate Brokerage and Acquisitions
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id142
 account_executive_id236
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties12
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties2
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(true)
 country_id0
 WOEID2444458
 timezoneUS/Pacific
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 namePartners Trust Real Estate Brokerage and Acquisitions
 broker_of_record_name
 short_namePartners Trust Real Estate
 usernamePartnersTrustMalibu
 password8bf407910e1841b6dabffb27fe55be8fe9a8383e
 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
 descriptionPartners Trust is the exclusive representative for Leverage Global Partners in Malibu, California, USA. We are dedicated to being the finest real estate brokerage in Los Angeles. At Partners Trust, our objective is to present our clients with the most professional, successful and ethical real estate associates in the business and to represent our clients with care, confidentiality and the utmost attention to service. We believe we offer our associates and clients a level of service, technology and communication unmatched in today’s real estate market. We begin with a commodity that is hard-earned and easily lost: TRUST. Without the daily demonstration and commitment to uphold principles, a company’s mission statement is simply words on a page and nothing more. Partners Trust has adopted a mission statement that each Associate and staff member must sign to in order to participate with the Company, which articulates the core philosophy and culture of the Company. The Partners Trust founders utilized their extensive experience and resources to create a Company that is both unique and beneficial for those willing to commit to the rigorous standards that have been set forth. The Company’s intention is to empower each member of its sales force each and every step of the way. Partners Trust has additional office locations in <a href="../../brokerage-detail/3/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Los Angeles</a>, <a href="../../brokerage-detail/1/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Beverly Hills</a>, <a href="../../brokerage-detail/4/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Santa Monica</a>, <a href="../../brokerage-detail/5/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Pasadena</a> and <a href="../../../brokerage-detail/186/Partners-Trust-Real-Estate-Brokerage-and-Acquisitions" target="_blank">Shanghai</a>.
 communitiesMalibu
 websitehttp://www.thepartnerstrust.com/home
 address23410 Civic Center Way
 address_2Suite C1
 cityMalibu
 stateCA
 full_stateCalifornia
 countryUSA
 market
 market_2
 postal_code90265
 phoneOffice: (310) 818-5752
 phone_2Cell: (424) 235-0143
 phone_3
 wide_contact_image(false)
 contact_nameSarah Kosasky
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleFounding Partner Malibu and Manager
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 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_filename142.jpg
 logo_filename142.png
 contact_image_filename142.jpeg
 all_properties_link_image_filename142.jpg
 all_properties_linkhttp://www.thepartnerstrust.com/properties
 video_embed_code<script type="text/javascript" src="http://videocontent.jloop.com/players/6DkAAMRK-qzxAOUo0.js"></script>
 contact_video_embed_code
 meta_titleMalibu Real Estate | Partners Trust | Leverage Global Partners
 meta_descriptionPartners Trust is the exclusive representative for Leverage Global Partners in Malibu, CA, USA.
 meta_keywords29138 Pacific Coast Highway, Partners Trust, Leverage Global Partners, Malibu real estate, california 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-07-18 15:34:11
 modified2016-04-08 16:34:15
 dre_num012345
 uri/brokerage-detail/142/partners-trust-real-estate-brokerage-and-acquisitions
 website_shortwww.thepartnerstrust.com/home
 name_with_locationPartners Trust Real Estate Brokerage and Acquisitions
 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)
 id11156
 modelProperty
 model_id3711
 tagImage
 name36026.jpg
 typeimage/jpg
 size614012
 uri/assets/11156.jpg
 order0
 created2016-04-07 16:25:10
 modified2016-04-12 07:51:59
 1(array)
 id11162
 modelProperty
 model_id3711
 tagImage
 name36033.jpg
 typeimage/jpg
 size5981241
 uri/assets/11162.jpg
 order1
 created2016-04-07 16:25:21
 modified2016-04-12 07:51:59
 2(array)
 id11161
 modelProperty
 model_id3711
 tagImage
 name36032.jpg
 typeimage/jpg
 size5742541
 uri/assets/11161.jpg
 order2
 created2016-04-07 16:25:19
 modified2016-04-12 07:51:59
 3(array)
 id11160
 modelProperty
 model_id3711
 tagImage
 name36031.jpg
 typeimage/jpg
 size6435531
 uri/assets/11160.jpg
 order3
 created2016-04-07 16:25:17
 modified2016-04-12 07:51:59
 4(array)
 id11159
 modelProperty
 model_id3711
 tagImage
 name36030.jpg
 typeimage/jpg
 size6299187
 uri/assets/11159.jpg
 order4
 created2016-04-07 16:25:15
 modified2016-04-12 07:51:59
 5(array)
 id11155
 modelProperty
 model_id3711
 tagImage
 name36027.jpg
 typeimage/jpg
 size656497
 uri/assets/11155.jpg
 order5
 created2016-04-07 16:25:10
 modified2016-04-12 07:51:59
 6(array)
 id11157
 modelProperty
 model_id3711
 tagImage
 name36028.jpg
 typeimage/jpg
 size8025557
 uri/assets/11157.jpg
 order6
 created2016-04-07 16:25:10
 modified2016-04-12 07:51:59
 7(array)
 id11164
 modelProperty
 model_id3711
 tagImage
 name36035.jpg
 typeimage/jpg
 size9877587
 uri/assets/11164.jpg
 order7
 created2016-04-07 16:25:25
 modified2016-04-12 07:51:59
 8(array)
 id11158
 modelProperty
 model_id3711
 tagImage
 name36029.jpg
 typeimage/jpg
 size12907528
 uri/assets/11158.jpg
 order8
 created2016-04-07 16:25:12
 modified2016-04-12 07:51:59
 9(array)
 id11163
 modelProperty
 model_id3711
 tagImage
 name36034.jpg
 typeimage/jpg
 size6128168
 uri/assets/11163.jpg
 order9
 created2016-04-07 16:25:23
 modified2016-04-12 07:51:59
 User(array)
 0(array)
 id1247
 typeAgent
 brokerage_id142
 email[email protected]
 passwordd255e1da43b092d387d1974757d05a13a8be3ecf
 recover_hash
 first_nameShirley
 last_nameSherman
 title
 dre_num
 phone310.849.8834
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:24:00
 created2017-08-07 15:24:00
 notified(false)
 full_nameShirley Sherman
 uri/agent-detail/1247/shirley-sherman
 profile_complete(true)
 UsersProperty(array)
 id1074
 user_id1247
 property_id3711
 sort_order0
 1(array)
 id1248
 typeAgent
 brokerage_id142
 email[email protected]
 password9c6607511a21fbc1c19a802a8ce7a3638a01f556
 recover_hash
 first_nameBrittany
 last_nameSherman
 title
 dre_num
 phone310.804.5992
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:24:00
 created2017-08-07 15:24:00
 notified(false)
 full_nameBrittany Sherman
 uri/agent-detail/1248/brittany-sherman
 profile_complete(true)
 UsersProperty(array)
 id1076
 user_id1248
 property_id3711
 sort_order0
 2(array)
 id1270
 typeAgent
 brokerage_id142
 email[email protected]
 passwordd3194a08107ab763927efa6dc9c64c48a2168239
 recover_hash
 first_nameLloyd
 last_nameSherman
 title
 dre_num
 phone310.893.1668
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:24:02
 created2017-08-07 15:24:02
 notified(false)
 full_nameLloyd Sherman
 uri/agent-detail/1270/lloyd-sherman
 profile_complete(true)
 UsersProperty(array)
 id1098
 user_id1270
 property_id3711
 sort_order0
 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)
 id1984
 property_id3711
 property_feature_id12
 1(array)
 id5
 nameGuest House
 additional(false)
 created2016-04-07 14:02:13
 modified2016-04-07 14:02:13
 PropertiesPropertyFeature(array)
 id1985
 property_id3711
 property_feature_id5
 2(array)
 id14
 nameViews
 additional(false)
 created2016-04-07 14:04:55
 modified2016-04-07 14:04:55
 PropertiesPropertyFeature(array)
 id1986
 property_id3711
 property_feature_id14
 Topic(array)
 0(array)
 id12
 nameModern Architecture
 created2016-02-25 11:25:00
 modified2016-02-25 11:33:26
 tile_nameModern Architecture
 PropertiesTopic(array)
 id15
 property_id3711
 topic_id12
 2(array)
 Property(array)
 id3756
 brokerage_id244
 created_by_user_id0
 order0
 multi_unit(false)
 agent_1_id0
 agent_2_id0
 agent_3_id0
 nameHistoric landmark estate in Langham area of Pasadena
 incomplete(false)
 archived(false)
 last_archived0000-00-00 00:00:00
 auto_archived_from_mlsidx(false)
 paid_featured(false)
 featured(false)
 homepage_featured(false)
 brokerage_page_featured(true)
 requested_homepage_featured_by_member(false)
 homepage_featured_by_member(false)
 dot_luxury_featured(false)
 luxury_feed_featured(false)
 force_luxury_feed_featured(false)
 luxury_autofeed_imported(false)
 luxury_feed_last_added_time0000-00-00 00:00:00
 luxury_feed_agent_user_id0
 luxury_feed_locked_to_subscription_id0
 luxury_feed_agent_purchase_date0000-00-00
 luxury_feed_agent_expiration_date0000-00-00
 digital_ad_summary_email_last_sent0000-00-00 00:00:00
 digital_ad_summary_price_changed(true)
 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(false)
 descriptionDesigned by well known Arts and Crafts movement architects Arthur and Alfred Heineman. In addition to the main house there is a 1,000 sq ft guest house and a 1,476 sq ft finished basement. This home is under The Mills Act which offers reduced property tax.
 address1330 Hillcrest Avenue
 address_2
 cityPasadena
 stateCA
 postal_code91106
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price6500000
 price_20
 price_usd6500000
 price_usd_20
 statusFor Sale
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(false)
 bedrooms0
 bedrooms_20
 bathrooms0
 bathrooms_20
 no_beds_baths(false)
 square_feet10764
 square_meters
 acres0.459137
 interior_unitsq_m
 interior_size1000
 lot_unitsq_ft
 lot_size20000
 icon_1
 icon_2
 icon_3
 icon_4
 icon_5
 icon_6
 website
 meta_title
 meta_description
 meta_keywords
 bathrooms_partial0
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built
 virtual_tour
 video_tour
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num
 wsj_property_type
 nyt_property_type
 nyt_popular_features
 propgolux_property_type
 juwai_property_type
 juwai_category
 propgolux_property_style
 wapo_property_type
 robb_property_type
 propgolux_location_id_override
 open_house_1_start0000-00-00 00:00:00
 open_house_1_end_time00:00:00
 latitude34.124477
 longitude-118.131401
 invalid_required_fields
 invalid_optional_fields
 went_live_today(false)
 converted(false)
 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)
 modified2021-10-20 14:10:15
 created2019-10-31 00:14:48
 uri/property-detail/3756/1330-hillcrest-avenue-pasadena-ca-91106-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3756/1330-hillcrest-avenue-pasadena-ca-91106-usa
 address_concat1330 Hillcrest Avenue Pasadena CA 91106 USA
 google_maps_query_string1330+Hillcrest+Avenue++Pasadena+CA+91106+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 6,500,000
 interior_unit_prettySq. M.
 lot_unit_prettySq. Ft.
 bedrooms_pretty0
 bathrooms_pretty0
 bathrooms_partial_pretty0
 bathrooms_3_4_pretty0
 feed_full_bathrooms0
 date_listed2019-10-31
 overridden_brokerage_nameSmith & Berg
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id244
 account_executive_id0
 archived(false)
 typeteam
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typeBasic
 max_properties10
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID(null)
 timezoneAmerica/Los_Angeles
 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
 nameSmith & Berg
 broker_of_record_nameCompass
 short_nameSmith & Berg
 username
 password
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date(null)
 monthly_invoice_end_date(null)
 contract_filename
 active(true)
 lead_inYou've tried the rest, now try the best
 short_description
 descriptionLorem ipsum dolor sit amet, consectetur adipiscing elit. Sed et est ut dui hendrerit auctor sit amet ut lorem. Proin eleifend tristique felis. Curabitur bibendum enim mauris, nec volutpat lectus aliquam a. Vestibulum laoreet tellus ac porta consectetur. Quisque quam tellus, tempus vel sollicitudin id, convallis ut erat. Nullam laoreet aliquet sapien non porttitor. Curabitur eu commodo quam, in pellentesque nibh. Etiam non dolor fermentum velit commodo feugiat a ut augue. Sed faucibus tincidunt vestibulum. Pellentesque tincidunt sed lorem at efficitur. Suspendisse maximus arcu eget fermentum pharetra. Praesent dapibus justo sit amet vestibulum molestie. Nullam eu faucibus nisi, sed lacinia eros. Quisque finibus nec ante eu scelerisque. In hac habitasse platea dictumst. Nam turpis augue, ornare sed odio a, placerat vestibulum augue. Curabitur posuere turpis sed nisl tempus, id feugiat ipsum dictum. Praesent venenatis pharetra nunc at tincidunt. Ut sollicitudin quam sit amet tortor molestie, at bibendum diam cursus. Cras ac metus vitae sapien condimentum consequat sit amet eget metus. Vestibulum et venenatis purus. Donec tincidunt pharetra ex quis tempor. Vivamus non sapien eget elit auctor ultrices at eget turpis. Nulla volutpat ut nibh eget placerat.
 communitiesLos Angeles
 websitehttps://compass.com
 address680 E. Colorado Blvd
 address_2Suite 150
 cityPasadena
 stateCA
 full_stateCalifornia
 countryUSA
 market
 market_2
 postal_code91101
 phone8888888888
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameF. Ron Smith
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titlePrincipal
 contact_dre_num11624555
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone565-135-7745
 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_2878-829-1672
 contact_website
 contact_name_2Chris Stephonovich
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2Associate Realtor
 contact_dre_num_241768321
 contact_email_3[email protected]
 contact_name_3Courtney P. Wolpertinger
 contact_title_3Associate Realtor
 contact_dre_num_384919983
 contact_phone_3158-646-8246
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename
 logo_filename
 contact_image_filename
 all_properties_link_image_filename
 all_properties_link
 video_embed_code
 contact_video_embed_code
 meta_title
 meta_description
 meta_keywords
 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(false)
 created2019-10-31 00:07:13
 modified2021-07-18 10:40:16
 dre_num012345
 uri/team-detail/244/smith-berg
 website_shortcompass.com
 name_with_locationSmith & Berg
 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)
 id23089
 modelProperty
 model_id3756
 tagImage
 name8d7f54a999bc95b7b618e15d75d5f37072fe28cd.jpeg
 typeimage/jpeg
 size460522
 uri/assets/23089.jpeg
 order0
 created2019-10-31 00:14:45
 modified2021-10-20 14:10:05
 User(array)
 0(array)
 id1286
 typeAgent
 brokerage_id244
 email[email protected]
 passwordb04bb448b10ef979db88d5bbb12f5dca893bbf65
 recover_hash
 first_nameSmithberg
 last_nameTester
 title
 dre_num123654
 phone8888888888
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2020-06-09 13:36:25
 created2020-06-09 13:36:25
 notified(false)
 full_nameSmithberg Tester
 uri/agent-detail/1286/smithberg-tester
 profile_complete(true)
 UsersProperty(array)
 id1118
 user_id1286
 property_id3756
 sort_order0
 SecondaryPropertyCategory(empty)
 PropertyFeature(empty)
 Topic(empty)
 3(array)
 Property(array)
 id3708
 brokerage_id80
 created_by_user_id0
 order0
 multi_unit(false)
 agent_1_id1224
 agent_2_id1225
 agent_3_id0
 nameDowntown Dupont Luxury
 incomplete(false)
 archived(false)
 last_archived0000-00-00 00:00:00
 auto_archived_from_mlsidx(false)
 paid_featured(false)
 featured(true)
 homepage_featured(false)
 brokerage_page_featured(true)
 requested_homepage_featured_by_member(false)
 homepage_featured_by_member(false)
 dot_luxury_featured(false)
 luxury_feed_featured(false)
 force_luxury_feed_featured(false)
 luxury_autofeed_imported(false)
 luxury_feed_last_added_time0000-00-00 00:00:00
 luxury_feed_agent_user_id0
 luxury_feed_locked_to_subscription_id0
 luxury_feed_agent_purchase_date0000-00-00
 luxury_feed_agent_expiration_date0000-00-00
 digital_ad_summary_email_last_sent0000-00-00 00:00:00
 digital_ad_summary_price_changed(false)
 wsj_detail_url
 ft_detail_url
 nyt_detail_url
 juwai_detail_url
 pgl_detail_url
 mg_detail_url
 mg_c_detail_url
 mg_s_detail_url
 bp_detail_url
 mw_detail_url
 nikkei_detail_url
 wapo_detail_url
 robb_detail_url
 medium_featured(false)
 large_featured(false)
 detail_page(true)
 descriptionConstructed in 2013, be the first to own this stunning contemporary light-filled duplex. Open living space flanked by floor-to-ceiling windows; balconies, roof deck and finishing details meld beautifully with this historic building's exterior in this prime Dupont location, only two blocks from Metro's Red Line. Main Entrance: Foyer Interior Style: Floor Plan-Open Dining/Kitchen: Gourmet, Kit-Island, Kit-Dining Combo, Liv-Din Combo Appliances: Oven / Range - Gas, Six Burner Stove, Refrigerator, Icemaker, Exhaust Fan, Dishwasher, Disposal, Dryer - Front Loading, Washer - Front Loading, Water Heater - High-Efficiency Amenities: Attached Master Bathroom, Bathroom(s) - Ceramic Tile, Bedroom - Entry Level, Built-in Bookcases, Closet - Master Bedroom Walk-in, Countertop(s) - Granite, Elevator, Vanities - Double, Whirlpool Jets, Wood Floors, Shades / Blinds, Master Bathroom - Separate Shower, High Efficiency Toilet(s), Closet(s) - Walk-in, Tub - Soaking Security: Fire Detect Sys, Main Entrance Lock, Spkler Sys-indoor Windows/Doors: Double Pane Windows, Recessed Lighting, Sliding Glass Door Walls/Ceilings: 9'+ Ceilings, Dry Wall, Plaster Walls
 address1737 Connecticut Avenue, NW, #502
 address_2
 cityWashington
 stateDC
 postal_code20009
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price1575000
 price_20
 price_usd1575000
 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)
 bedrooms2
 bedrooms_20
 bathrooms2
 bathrooms_20
 no_beds_baths(false)
 square_feet0
 square_meters
 acres0
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size0
 icon_1
 icon_2
 icon_3
 icon_4
 icon_5
 icon_6
 websitehttp://www.eversco.com/homes-for-sale-details/1737-CONNECTICUT-AVENUE-NORTHWEST-502-WASHINGTON-DC-20009/DC9599732/30/
 meta_titleDowntown Dupont Luxury | Washington Real Estate | Evers & Co. Real Estate
 meta_description1737 Connecticut Avenue, NW, #502 is a property offered for sale in Washington, DC, USA, presented by Evers & Co. Real Estate
 meta_keywords
 bathrooms_partial1
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built
 virtual_tourhttp://slideshow.mris.com/slideshow/slideshow.htm?ListingKey=300033619913
 video_tour
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num
 wsj_property_type
 nyt_property_type
 nyt_popular_features
 propgolux_property_type
 juwai_property_type
 juwai_category
 propgolux_property_style
 wapo_property_type
 robb_property_type
 propgolux_location_id_override
 open_house_1_start0000-00-00 00:00:00
 open_house_1_end_time00:00:00
 latitude0.000000
 longitude0.000000
 invalid_required_fields
 invalid_optional_fieldssquare_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:03
 created2016-04-06 14:18:15
 uri/property-detail/3708/1737-connecticut-avenue-nw-502-washington-dc-20009-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3708/1737-connecticut-avenue-nw-502-washington-dc-20009-usa
 address_concat1737 Connecticut Avenue, NW, #502 Washington DC 20009 USA
 google_maps_query_string1737+Connecticut+Avenue%2C+NW%2C+%23502++Washington+DC+20009+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 1,575,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty2
 bathrooms_pretty2
 bathrooms_partial_pretty1
 bathrooms_3_4_pretty0
 feed_full_bathrooms2
 date_listed2016-04-06
 overridden_brokerage_nameEvers & Co. Real Estate
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id80
 account_executive_id235
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id1
 WOEID2514815
 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
 nameEvers & Co. Real Estate
 broker_of_record_name
 short_nameEvers & Co. Real Estate
 usernameEversCoRealEstateDC
 password8c94cd238914e1ba6f88d53a1a78f02c47944eeb
 password_reset_hash
 monthly_invoice_amount0.00
 monthly_invoice_start_date0000-00-00
 monthly_invoice_end_date0000-00-00
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionEvers & Co. Real Estate is the exclusive representative for Leverage Global Partners in Washington, DC and <a href="../../../brokerage-detail/81/Evers-&-Co.-Real-Estate">Chevy Chase</a>, MD, USA. We are 100+ salespeople who offer our clients a level of service that is unmatched in today’s real estate marketplace, and we deliver this extraordinary service with courtesy and integrity to everyone involved in each transaction. We are enthusiastic about the neighborhoods where we live and work, from Chevy Chase to Capitol Hill, from Dupont Circle to Arlington, and everywhere in between. The highly visible storefront offices of Evers & Co. in Downtown Washington, Friendship Heights in Upper Northwest, downtown Bethesda-Chevy Chase and in Bluemont in the Virginia Wine Country are bustling with the entrepreneurial energy of agents who have in-depth knowledge of local history, architecture and construction techniques as well as expert skills in marketing and negotiating, all of which adds value to our service and your investment. This spectrum of knowledge and our commitment to serving our clientele and fellow real estate associates with the highest level of integrity has made us the premier independent brokerage in the Metropolitan Washington area. Donna Evers and the agents of Evers & Co. invite you to join our growing community of buyers and sellers, who have been the source of 90% of our business for the past thirty years.
 communitieswashington, DC chevy chase dupont kalorama georgetown american university park cleveland park Palisades logan circle capitol hill forest hills
 websitehttp://www.eversco.com/
 address4400 Jenifer Street, NW
 address_2
 cityWashington, D.C
 state
 full_state
 countryUSA
 marketWashington, D.C
 market_2
 postal_code20015
 phoneOffice: (202) 364-1700
 phone_2Cell: (202) 255-5009
 phone_3
 wide_contact_image(false)
 contact_nameDonna Evers
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titlePresident & Founder
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 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_filename80.jpg
 logo_filename80.jpg
 contact_image_filename80.jpg
 all_properties_link_image_filename80.JPG
 all_properties_linkhttp://eversco.idxre.com/featured/40484?CFID=10711248&CFTOKEN=99152164
 video_embed_code
 contact_video_embed_code
 meta_titleWashington DC Real Estate | Evers & Co. Real Estate | Leverage Global Partners
 meta_descriptionEvers & Co. Real Estate is the exclusive representative for Leverage Global Partners in Washington, DC , Chevy Chase, Dupont, Kalorama, Georgetown, American University Park, Cleveland Park, Palisades, Logan Circle, Capitol Hill, and Forest Hills.
 meta_keywordsWashington DC Real Estate, Evers & Co. Real Estate, Leverage Global Partners, chevy chase real estate, dupont real estate, kalorama real estate, georgetown, american university park real estate, cleveland park real estate, Palisades real estate, logan circle real estate, capitol hill real estate, forest hills 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-01-10 16:30:33
 modified2016-04-08 16:34:01
 dre_num012345
 uri/brokerage-detail/80/evers-co-real-estate
 website_shortwww.eversco.com
 name_with_locationEvers & Co. Real Estate
 StripeSubscription(array)
 id(null)
 brokerage_id(null)
 user_id(null)
 property_id(null)
 type(null)
 stripe_id(null)
 stripe_customer_id(null)
 stripe_checkout_email(null)
 stripe_promotion_code(null)
 stripe_promotion_code_id(null)
 stripe_coupon_code_id(null)
 status(null)
 current_period_end(null)
 cancel_at_period_end(null)
 ended(null)
 last_change(null)
 last_activity_email_sent(null)
 created(null)
 modified(null)
 GlobalReachReport(array)
 id(null)
 property_id(null)
 wsj_desktop(null)
 wsj_mobile(null)
 wsj_expires(null)
 wsj_capture_started(null)
 mg_desktop(null)
 mg_mobile(null)
 mg_expires(null)
 mg_capture_started(null)
 bp_desktop(null)
 bp_mobile(null)
 bp_expires(null)
 gp_capture_started(null)
 mw_desktop(null)
 mw_mobile(null)
 mw_expires(null)
 mw_capture_started(null)
 ft_desktop(null)
 ft_mobile(null)
 ft_expires(null)
 ft_capture_started(null)
 nikkei_desktop(null)
 nikkei_mobile(null)
 nikkei_expires(null)
 nikkei_capture_started(null)
 pgl_desktop(null)
 pgl_mobile(null)
 pgl_expires(null)
 pgl_capture_started(null)
 robb_desktop(null)
 robb_mobile(null)
 robb_expires(null)
 robb_capture_started(null)
 juwai_desktop(null)
 juwai_mobile(null)
 juwai_expires(null)
 juwai_capture_started(null)
 leverage_desktop(null)
 leverage_mobile(null)
 leverage_expires(null)
 leverage_capture_started(null)
 created(null)
 modified(null)
 wsj_available(false)
 wsj_expired(true)
 wsj_desktop_proxy_screenshot(null)
 wsj_mobile_proxy_screenshot(null)
 mg_available(false)
 mg_expired(true)
 mg_desktop_proxy_screenshot(null)
 mg_mobile_proxy_screenshot(null)
 bp_available(false)
 bp_expired(true)
 bp_desktop_proxy_screenshot(null)
 bp_mobile_proxy_screenshot(null)
 mw_available(false)
 mw_expired(true)
 mw_desktop_proxy_screenshot(null)
 mw_mobile_proxy_screenshot(null)
 nikkei_available(false)
 nikkei_expired(true)
 nikkei_desktop_proxy_screenshot(null)
 nikkei_mobile_proxy_screenshot(null)
 pgl_available(false)
 pgl_expired(true)
 pgl_desktop_proxy_screenshot(null)
 pgl_mobile_proxy_screenshot(null)
 robb_available(false)
 robb_expired(true)
 robb_desktop_proxy_screenshot(null)
 robb_mobile_proxy_screenshot(null)
 juwai_available(false)
 juwai_expired(true)
 juwai_desktop_proxy_screenshot(null)
 juwai_mobile_proxy_screenshot(null)
 capture_processing(false)
 capture_error(empty)
 Image(array)
 0(array)
 id20565
 modelProperty
 model_id3708
 tagImage
 name36012.jpg
 typeimage/jpg
 size5032972
 uri/assets/20565.jpg
 order2894
 created2016-04-07 17:34:09
 modified2016-04-07 17:34:09
 User(array)
 0(array)
 id1267
 typeAgent
 brokerage_id80
 email[email protected]
 password64ae12b776051115a6c20b7eb8f0d36df7c5c187
 recover_hash
 first_nameBren
 last_nameLizzio
 title
 dre_num
 phone2026694999
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:24:02
 created2017-08-07 15:24:02
 notified(false)
 full_nameBren Lizzio
 uri/agent-detail/1267/bren-lizzio
 profile_complete(true)
 UsersProperty(array)
 id1096
 user_id1267
 property_id3708
 sort_order0
 1(array)
 id1268
 typeAgent
 brokerage_id80
 email[email protected]
 password72ce72c1db831d3b7e5697bf25ee0217b3739349
 recover_hash
 first_nameAndrea
 last_nameEvers
 title
 dre_num
 phone2025508934
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:24:02
 created2017-08-07 15:24:02
 notified(false)
 full_nameAndrea Evers
 uri/agent-detail/1268/andrea-evers
 profile_complete(true)
 UsersProperty(array)
 id1097
 user_id1268
 property_id3708
 sort_order0
 SecondaryPropertyCategory(empty)
 PropertyFeature(empty)
 Topic(empty)
- sidebar_brokerages(array)
 0(array)
 Brokerage(array)
 id175
 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_modeLegacy
 max_luxury_feed_properties3
 membership_luxury_feed_properties3
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID2366355
 timezone
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameAmherst Madison Partners
 broker_of_record_name
 short_nameAmherst Madison Partners
 usernameAmherstMadisonPartners
 password6d698ab9779b23da643ce61980178e148037cae4
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date(null)
 monthly_invoice_end_date(null)
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionAmherst Madison Partners is the exclusive representative for Leverage Global Partners in all of Canyon & Ada Counties, including Boise, Meridian, Eagle, Caldwell, Nampa, Kuna, and Star, Idaho, USA. Our brokerage has been described as the “pre-eminent luxury brand in Idaho” due to our personalized service, large social network, in-house media department, and intimate knowledge of the local market. We offer our clients a level of care that stands above the rest. While we represent you with the highest levels of service and attention to detail, our true love is the friendships created in the process. Whether you are buying or selling we understand the process can often be challenging and complicated. We focus on reducing any pressure, so clear and intelligent decisions can be made every step of the way. Your unequivocal satisfaction is our primary goal, and we utilize our competence, technology, and “Concierge Approach” to make that happen. For us, marketing a home is an art form. We thrive on perfection, and we showcase this for our Clients through staging, aerial photography, 3-D home tours, high definition media, Ad-Agency content creation, paid social media, search engine optimization, and a cloud based transaction management platform. We know that each buying or selling situation is unique, therefore each approach will to be specifically tailored to your requirements. Every one of our Agents and Staff is vested in making sure you receive the results you are looking for no matter what it takes. Amherst Madison Partners was the first Idaho real estate brokerage featured on HGTV and the first Idaho company to use branded 3-D Home Tours.
 communitiesBoise Meridian Eagle Caldwell Nampa Kuna Star Ada County Canyon County
 websitehttp://www.amherstmadisonpartners.com/
 address410 East State Street
 address_2
 cityEagle
 stateID
 full_stateIdaho
 countryUSA
 marketBoise
 market_2
 postal_code83616
 phoneCell: (208) 573-1619
 phone_2Office: (208) 450-3000
 phone_3
 wide_contact_image(false)
 contact_nameAlei Merrill Gothberg
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/leverage-lifestyle/meet-alei-merrill-gothberg-amherst-madison-partners-boise-id/
 contact_big_profile_link_textMEET ALEI
 contact_titleFounding Partner
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 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_filename175.jpg
 logo_filename175.jpg
 contact_image_filename175.jpg
 all_properties_link_image_filename175.jpg
 all_properties_linkhttp://www.amherstmadisonpartners.com/global-leverage-partners-property-showcase/
 video_embed_code
 contact_video_embed_code
 meta_titleBoise Real Estate⎜Amherst Madison Partners⎜Leverage Global Partners
 meta_descriptionAmherst Madison Partners is the exclusive representative for Leverage Global Partners in Boise, Idaho, USA.
 meta_keywordsAmherst Madison Partners, Boise Real Estate, Idaho Real Estate, Leverage Global Partners, Meridian Real Estate, Eagle Real Estate, Caldwell Real Estate, Nampa Real Estate, Kuna Real Estate, Star Real Estate, Ada County Real Estate, Canyon County Real Estate
 login_message_counter2
 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_sent2019-11-12 19:43:49
 converted(true)
 created2014-11-12 15:56:19
 modified2020-11-20 12:05:11
 dre_num012345
 uri/brokerage-detail/175/amherst-madison-partners
 website_shortwww.amherstmadisonpartners.com
 name_with_locationAmherst Madison Partners
 Logo(array)
 id2776
 modelBrokerage
 model_id175
 tagLogo
 name175.jpg
 typeimage/jpg
 size39921
 uri/assets/2776.jpg
 order0
 created2016-03-30 11:43:53
 modified2019-11-11 19:01:23
 1(array)
 Brokerage(array)
 id116
 account_executive_id236
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties1
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID2487889
 timezoneUS/Pacific
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameAscent Real Estate
 broker_of_record_name
 short_nameAscent Real Estate
 usernameAscentSDCentral
 password847ba57e0102581b0d6aaa7f2a3e234bbcb6e1f9
 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
 descriptionAscent Real Estate is the exclusive representative for Leverage Global Partners in Central Inland, Downtown, Mission Hills, Hillcrest, North Park, Kensington, University Heights, Normal Heights, Talmadge, Golden Hill, South Park, Carmel Valley, Poway, Mira Mesa and Central Inland San Diego, California, USA. At Ascent Real Estate, our Mission is to hire, develop, and retain the real estate industry’s most respected agents; cultivating a work environment that is cutting edge, diverse, ethical, compassionate, and strong in its convictions. Ascent Real Estate, established in 2005, is a privately held company that is owned and operated in San Diego, California. It was founded by Penny Nathan and Ken Pecus, two leading agents in the competitive San Diego marketplace. The partners share a combined experience of over 27 years as agents, and each has a diverse range of entrepreneurial experience. They created Ascent Real Estate to fill the customer service vacuum formed by the multi-national real estate monoliths as they expanded during the favorable market cycle. Ascent Real Estate is comprised of a talented and highly motivated team with extensive training and experience in all phases of real estate transactions. The company maintains excellent relationships with key players across the residential real estate industry including brokers, homebuilders, and financial partners. The Ascent Real Estate team is experienced in property sales and acquisitions ranging from expansive estates to single-family homes and condominiums. Ascent Real Estate embodies an enviable combination of entrepreneurial energy, comprehensive industry experience, and local market knowledge. This mix lets Ascent “out national” its local competition thanks to its exceptional professional team and world-class infrastructure, and “out local” the national competition thanks to its laser-like focus on the specific markets in which it operates. Now, with our alliance with Leverage Global Partners, we are able to connect our local communities with others around the world. Our local area experts welcome you, our global neighbors, to sunny San Diego. In addition Ascent Real Estate also has locations in <a href="../../../brokerage-detail/115/Ascent-Real-Estate">North Inland</a>, <a href="../../../brokerage-detail/117/Ascent-Real-Estate">South/East</a>, and <a href="../../../brokerage-detail/25/Ascent-Real-Estate">Coastal San Diego</a>, CA. 
 communitiesCentral Inland Downtown Mission Hills Hillcrest North Park Kensington University Heights Normal Heights Talmadge Golden Hill South Park Carmel Valley Poway Mira Mesa
 websitehttp://www.ascentrealestate.net/
 address410 Kalmia Street
 address_2
 citySan Diego
 stateCA
 full_stateCalifornia
 countryUSA
 marketSan Diego - Central Inland
 market_2
 postal_code92101
 phone(619) 325-4100
 phone_2
 phone_3
 wide_contact_image(false)
 contact_namePenny Nathan
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/blog/meet-penny-nathan-president-at-ascent-real-estate-san-diego/
 contact_big_profile_link_text
 contact_titlePresident
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 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_filename116.jpg
 logo_filename116.jpg
 contact_image_filename116.jpg
 all_properties_link_image_filename116.jpg
 all_properties_linkhttp://www.ascentrealestate.net/featured-properties
 video_embed_code
 contact_video_embed_code
 meta_titleSan Diego Real Estate | Ascent Real Estate | Leverage Global Partners
 meta_descriptionAscent Real Estate is the exclusive representative for Leverage Global Partners in San Diego, California, USA.
 meta_keywordsascent real estate, san diego real estate, san diego california, penny nathan, leverage global partners
 login_message_counter2
 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-04-28 15:38:06
 modified2016-04-08 16:34:09
 dre_num012345
 uri/brokerage-detail/116/ascent-real-estate
 website_shortwww.ascentrealestate.net
 name_with_locationAscent Real Estate
 Logo(array)
 id2587
 modelBrokerage
 model_id116
 tagLogo
 name116.jpg
 typeimage/jpg
 size170471
 uri/assets/2587.jpg
 order0
 created2016-03-30 11:41:15
 modified2016-03-30 11:41:15
 2(array)
 Brokerage(array)
 id92
 account_executive_id236
 archived(false)
 typedevelopment
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID2432153
 timezone
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 namePam Harrington Exclusives
 broker_of_record_name
 short_namePam Harrington Exclusives
 usernamePamHarringtonExclusives
 passwordd9957a95a4927b3d3325d107e05944a461d55de6
 password_reset_hash
 monthly_invoice_amount0.00
 monthly_invoice_start_date(null)
 monthly_invoice_end_date(null)
 contract_filename92.pdf
 active(true)
 lead_in
 short_description
 descriptionPam Harrington Exclusives is the exclusive representative for Leverage Global Partners in Wadmalaw Island, Seabrook Island, Johns Island, Kiawah Island, South Carolina, USA. In 1987, Pam Harrington Exclusives began as a small, independent firm amid a sea of large, corporate realty companies and developers competing for business on Kiawah and Seabrook Island. The Pam Harrington Exclusives team quickly established relationships with discerning island homeowners who sought to rent their properties during peak season. Those early relationships continued to grow and served as the foundation upon which our small firm blossomed into the renowned full service real estate company we are today. With over 30 years of experience in island realty, we enjoy sharing our surroundings. If you're looking for oceanfront, fairway, deep water or secluded marshlands, we'll find it on the islands of Kiawah, Seabrook, Johns or Wadmalaw. If the city suits your fancy, we are equally at home in Charleston. We’ve had the pleasure of helping families get to know Seabrook and Kiawah Island through our seasonal rentals – and the honor of seeing them fall in love with these islands and helping them become permanent members of our community. As an independent firm, we are free of corporate demands and able to focus on what’s most important – helping our clients find happiness in the beautiful places we are lucky to call home. Distinguished by profound personal attention, Pam Harrington Exclusives has closed over one billion dollars in sales, one transaction at a time. If you're interested in buying or selling a home or property on Kiawah, Seabrook or the adjacent islands, look no further. We’re proud to represent the beloved island communities whose beauty, value and legacy endure
 communitiesWadmalaw Island Seabrook Island Johns Island Kiawah Island
 websitehttp://www.pamharringtonexclusives.com/
 address4343 Betsy Kerrison Pkwy
 address_2
 cityJohns Island
 stateSC
 full_stateSouth Carolina
 countryUSA
 marketKiawah Island
 market_2
 postal_code29455
 phoneOffice: (843) 768-3635
 phone_2
 phone_3
 wide_contact_image(false)
 contact_namePam Harrington
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titlePresident
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 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_filename92.jpg
 logo_filename92.jpg
 contact_image_filename92.jpg
 all_properties_link_image_filename92.JPG
 all_properties_linkhttp://www.pamharringtonexclusives.com/real-estate/kiawah-real-estate
 video_embed_code
 contact_video_embed_code
 meta_titleKiawah Island Real Estate | Pam Harrington Exclusives | Leverage Global Partners
 meta_descriptionPam Harrington Exclusives is the exclusive representative for Leverage Global Partners in Kiawah Island, South Carolina, USA.
 meta_keywordsKiawah Island Real Estate, Pam Harrington Exclusives, Leverage Global Partners, Wadmalaw Island Real Estate, Seabrook Island Real Estate, Johns Island Real Estate
 login_message_counter1
 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-01-31 18:29:33
 modified2019-09-09 11:37:58
 dre_num012345
 uri/development-detail/92/pam-harrington-exclusives
 website_shortwww.pamharringtonexclusives.com
 name_with_locationPam Harrington Exclusives
 Logo(array)
 id2512
 modelBrokerage
 model_id92
 tagLogo
 name92.jpg
 typeimage/jpg
 size73972
 uri/assets/2512.jpg
 order0
 created2016-03-30 11:40:29
 modified2019-09-09 11:37:58
 3(array)
 Brokerage(array)
 id190
 account_executive_id235
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID2412795
 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
 name@Home Realty
 broker_of_record_name
 short_name@Home Realty
 username@HomeGrandHaven
 passworda9f2698410d000d09fe634d4134a4bc02a20eef1
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date(null)
 monthly_invoice_end_date(null)
 contract_filename
 active(true)
 lead_in
 short_description
 description@Home Realty is the exclusive representative for Leverage Global Partners in all of Ottawa, Muskegon and Kent Counties, including Grand Haven, Spring Lake, Norton Shores, Holland, Zeeland, Hudsonville and Greater Grand Rapids. Life is good @Home. We are proud to be a local company. We live here. We work here. We play here. We give here. Our focus on family and community sets us apart in providing a positive, refreshing and expert approach to your real estate needs. We are able to give you unparalleled service because of our partnerships with local companies, our command of the latest technology and marketing strategies, and our real estate industry expertise. Our expertise lies in our years of experience, our confidence gained from that experience and our love of this West Michigan community.
 communitiesMuskegon County Grand Haven Holland Hudsonville Muskegon North Shores Spring Lake Whitehall Zeeland
 websitehttp://www.homewestmichigan.com/
 address510 MILLER DRIVE
 address_2
 cityGrand Haven
 stateMI
 full_stateMichigan
 countryUSA
 market
 market_2
 postal_code
 phoneDirect: (616) 935-9001
 phone_2Cell: (616) 250-1412
 phone_3
 wide_contact_image(false)
 contact_nameJake Hogeboom
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleCEO/Broker
 contact_dre_num
 contact_quoteI invite you to contact me personally about West Michigan real estate
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename190.jpg
 logo_filename190.png
 contact_image_filename190.jpg
 all_properties_link_image_filename190.jpg
 all_properties_linkhttp://search.homewestmichigan.com/idx/featured
 video_embed_code
 contact_video_embed_code
 meta_titleGrand Haven Real Estate⎜@Home Realty⎜Leverage Global Partners
 meta_description@Home Realty is the exclusive representative for Leverage Global Partners in all of Muskegon County, MI, including Grand Haven, Holland, Hudsonville, Muskegon, North Shores, Spring Lake, Whitehall, and Zeeland, MI, USA.
 meta_keywordsGrand Haven Real Estate, @Home Realty, Leverage Global Partners, Michigan Real Estate, Jake Hogeboom, Muskegon County 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)
 created2015-02-09 13:20:35
 modified2016-04-08 16:34:20
 dre_num012345
 uri/brokerage-detail/190/home-realty
 website_shortwww.homewestmichigan.com
 name_with_location@Home Realty
 Logo(array)
 id2806
 modelBrokerage
 model_id190
 tagLogo
 name190.png
 typeimage/png
 size27323
 uri/assets/2806.png
 order0
 created2016-03-30 11:44:11
 modified2016-03-30 11:44:11
- sidebar_locations(array)
 0(array)
 Location(array)
 id166
 parent_id8
 brokerage_id155
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameRichmond, VA, USA
 short_nameRichmond, VA, USA
 group_index
 latitude37.540726
 longitude-77.436050
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_description
 long_descriptionMore information coming soon!
 created2016-04-12 18:22:54
 modified2016-04-12 18:24:08
 timezoneAmerica/New_York
 population0
 uri/locations/view/166/richmond-va-usa
 tile_nameRichmond, VA, USA
 Brokerage(array)
 id155
 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_properties1
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID2480894
 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
 nameSmall & Associates Real Estate
 broker_of_record_name
 short_nameSmall & Associates Real Estate
 usernameSmallAssociatesRealEstate
 passwordd16e623ad2ac5d8c1266af342ea6f1394f860fb3
 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
 descriptionSmall & Associates Real Estate is the exclusive representative for Leverage Global Partners in Richmond, Chesterfield County, Goochland County, Henrico County, Hanover County, Virginia, USA. When Chris Small named his real estate company Small & Associates, it wasn’t because of his surname. It was also because of his vision – a vision for a close-knit “family” of real estate professionals bonded by a commitment to always making the customer’s needs their first priority. Chris soon found that his “quality over quantity” approach was appreciated not only by the company’s elite clientele, but also by many of the best agents Richmond has to offer. One by one they joined Small & Associates, along the way building an unsurpassed reputation for outstanding real estate services. So the next time you’re buying or selling a home or a property, For Big Result, Think Small. When it comes to Richmond real estate, size does matter. At Small & Associates Real Estate, owner and founder Chris Small never desired to create another large, faceless real estate behemoth. Instead he set out to develop a small, tight-knit company that put quality over quantity and took pride in providing an elevated level of personal service to fellow Richmond residents.  That was in 1982. Today, Small & Associates has earned a sterling reputation throughout the region for living up to Chris’s lofty ideals. The company’s strong local connections and independent ownership provide a superior alternative to the franchises and huge, corporate-owned companies.
 communitiesRichmond Chesterfield County Goochland County Henrico County Hanover County
 websitehttp://www.smallrealestate.com/#&panel1-1
 address5413 Patterson Avenue
 address_2Suite 200
 cityRichmond
 stateVA
 full_stateVirginia
 countryUSA
 market
 market_2
 postal_code23226
 phoneOffice: (804) 343-6860
 phone_2Mobile: (804) 350-0879
 phone_3
 wide_contact_image(false)
 contact_nameChris Small
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titlePrincipal Broker
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 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_filename155.jpg
 logo_filename155.jpg
 contact_image_filename155.jpg
 all_properties_link_image_filename155.jpg
 all_properties_linkhttp://smallrealestate.com/main/homes?isfeatured=1&isnew
 video_embed_code
 contact_video_embed_code
 meta_titleRichmond Real Estate | Small & Associates Real Estate | Leverage Global Partners
 meta_descriptionSmall & Associates Real Estate is the exclusive representative for Leverage Global Partners in Richmond, Virginia, USA.
 meta_keywordsSmall & Associates Real Estate, Richmond Real Estate, Chesterfield County Real Estate, Goochland County Real Estate, Henrico County Real Estate, Real Estate Hanover County
 login_message_counter3
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2014-08-26 18:10:55
 modified2016-04-08 16:34:15
 dre_num012345
 uri/brokerage-detail/155/small-associates-real-estate
 website_shortwww.smallrealestate.com/#&panel1-1
 name_with_locationSmall & Associates Real Estate
 Image(array)
 id20728
 modelLocation
 model_id166
 tagImage
 nameScreen Shot 2016-04-12 at 6.23.24 PM.png
 typeimage/png
 size1147166
 uri/assets/20728.png
 order0
 created2016-04-12 18:24:02
 modified2016-04-12 18:24:08
 1(array)
 Location(array)
 id37
 parent_id7
 brokerage_id87
 typeExclusive
 archived(false)
 use_as_topic(true)
 nameMartha’s Vineyard, MA, USA
 short_nameMartha’s Vineyard, MA, USA
 group_index
 latitude41.380497
 longitude-70.645470
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_description
 long_descriptionMore information coming soon!
 created2016-04-04 12:23:59
 modified2016-04-14 10:52:21
 timezoneAmerica/New_York
 population15000
 uri/locations/view/37/martha-s-vineyard-ma-usa
 tile_nameMartha’s Vineyard, MA, USA
 Brokerage(array)
 id87
 account_executive_id235
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id1
 WOEID2397083
 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
 namePoint B Realty, LLC
 broker_of_record_name
 short_namePoint B Realty, LLC
 usernamePointBRealty
 passwordcb1cd4bbd4c20844c6efbbd3c834689884677120
 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
 descriptionPoint B Realty, LLC is the exclusive representative for Leverage Global Partners in Martha’s Vineyard, Edgartown, Vineyard Haven, Oak Bluffs, Chilmark, Aquinnah, and Chappaquiddick Island, Massachusetts, USA. Point B Realty, located in the historic whaling village of Edgartown on Martha’s Vineyard, is a full-service boutique firm known for its personal and professional integrity, exceptional customer service and up-to-the-minute market expertise. Principal broker and owner Wendy Harman, with a strong corporate background in branding, marketing and publishing, founded the firm in 2009 as a client-centric brokerage committed to representing each client’s best interests through transparency and designated agency. The firm has quickly become one of the Vineyard’s top five brokerages for overall performance, and in 2013 Wendy herself was the island’s top-performing real estate broker. Point B’s dedicated team of licensed agents and support staff offer buyers, sellers, renters and homeowners an innovative collaborative approach to the business of real estate. The firm actively seeks out new technology and techniques to improve client communication and marketing. Each agent fulfills twice the state-mandated professional education requirements, and actively supports a wide range of island philanthropic ventures. The benefits of their dynamic approach to client service reach far and wide. “After only five years, our small boutique firm – just six agents – has become one of the island’s top five firms,” Wendy says. “I’m exceptionally proud of our team, and their dedication to excellence inspires me to reach even higher.”
 communitiesMartha’s Vineyard Edgartown Vineyard Haven Oak Bluffs Chilmark Aquinnah Chappaquiddick Island
 websitehttp://pointbrealty.com/
 addressPost Office Box 1097
 address_2
 cityEdgartown
 stateMA
 full_stateMassachusetts
 countryUSA
 marketMartha’s Vineyard
 market_2
 postal_code02539
 phoneOffice: (508) 627-4567
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameWendy Harman
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titlePrincipal Broker/Owner
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 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_filename87.jpg
 logo_filename87.jpg
 contact_image_filename87.jpg
 all_properties_link_image_filename87.jpg
 all_properties_linkhttp://pointbrealty.com/marthas-vineyard-featured-sales.php?id=21
 video_embed_code
 contact_video_embed_code
 meta_titleMartha’s Vineyard Real Estate | Point B Realty, LLC | Leverage Global Partners
 meta_descriptionPoint B Realty, LLC is the exclusive representative for Leverage Global Partners in Martha's Vineyard, Massachusetts, USA.
 meta_keywordsLeverage Global Partners, Point B Realty, LLC, Martha’s Vineyard Real Estate, Edgartown Real Estate, Vineyard Haven Real Estate, Oak Bluffs Real Estate, Chilmark Real Estate, Aquinnah Real Estate, and Chappaquiddick Island Real Estate, Martha's Vineyard Massachusetts
 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-01-28 11:53:17
 modified2016-04-08 16:34:01
 dre_num012345
 uri/brokerage-detail/87/point-b-realty-llc
 website_shortpointbrealty.com
 name_with_locationPoint B Realty, LLC
 Image(array)
 id2966
 modelLocation
 model_id37
 tagImage
 nameMartha's Vineyard.jpg
 typeimage/jpeg
 size130249
 uri/assets/2966.jpg
 order0
 created2016-04-04 12:23:18
 modified2016-04-14 10:52:21
 2(array)
 Location(array)
 id94
 parent_id9
 brokerage_id192
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameBullhead City, AZ, USA
 short_nameBullhead City, AZ, USA
 group_index
 latitude35.135941
 longitude-114.528595
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_description
 long_descriptionMore information coming soon!
 created2016-04-05 11:28:06
 modified2016-04-05 11:28:06
 timezoneAmerica/Phoenix
 population40000
 uri/locations/view/94/bullhead-city-az-usa
 tile_nameBullhead City, AZ, USA
 Brokerage(array)
 id192
 account_executive_id236
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID2371675
 timezoneUS/Mountain
 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
 nameUS Southwest
 broker_of_record_name
 short_nameUS Southwest
 usernameUSSouthwestLLC
 passwordaca3f804a48f1447c4a6fd356b1f302279862050
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date(null)
 monthly_invoice_end_date(null)
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionUS Southwest is the exclusive representative for Leverage Global Partners in Bullhead City, Mohave Valley, Fort Mohave AZ, USA. US Southwest is a boutique real estate company comprised of like minded pro-fessionals whose mission is to provide the best professional service so their clients can make informed decisions to achieve their goals. The talent and depth within the company is unmatched in Mohave County. Several of the key players at US Southwest have managed a business or owned their own busi- ness. The combined talents provide a unique business platform in which diversity, collaboration, team work, and professionalism, foster a business perspective and environment that generates creativity and productivity, and ultimately, successful results for clients. US Southwest has the capability, expertise and area relationships to assist its clients in any type of real estate endeavor. Its founders, Ann L. Pettit and Ray W. Jackson III, have worked in every kind of real estate enterprise for over 30 years in Northwestern Arizona and are perceived as innovative leaders and pioneers of the industry. They have a relationship building philosophy and their motto is - Your Success is Our Success.
 communitiesBullhead City Fort Mohave Mohave Valley
 websitehttp://ussw.net/
 address3767 Highway 95
 address_2
 cityBullhead City
 stateAZ
 full_stateArizona
 countryUSA
 market
 market_2
 postal_code86442
 phone(928) 763-2288
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameAnn Pettit
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleOwner
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 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_filename192.jpg
 logo_filename192.jpg
 contact_image_filename192.png
 all_properties_link_image_filename192.jpg
 all_properties_linkhttp://ussw.net/wolfnet-properties
 video_embed_code
 contact_video_embed_code
 meta_titleBullhead City Real Estate | US Southwest | Leverage Global Partners
 meta_descriptionUS Southwest is the exclusive representative for Leverage Global Partners in Bullhead City, AZ, USA.
 meta_keywordsUS Southwest LLC, Bullhead city real estate, arizona real estate, ann pettit, bullhead city, leverage global partners, Fort Mohave, Mohave Valley
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2015-02-13 10:18:22
 modified2016-04-08 16:34:20
 dre_num012345
 uri/brokerage-detail/192/us-southwest
 website_shortussw.net
 name_with_locationUS Southwest
 Image(array)
 id3028
 modelLocation
 model_id94
 tagImage
 nameBullhead city.jpg
 typeimage/jpeg
 size140053
 uri/assets/3028.jpg
 order0
 created2016-04-05 11:25:58
 modified2016-04-05 11:28:06
 3(array)
 Location(array)
 id20
 parent_id7
 brokerage_id83
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameGreenwich, CT, USA
 short_nameGreenwich, CT, USA
 group_index
 latitude37.090240
 longitude-95.712891
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_descriptionGreenwich is one of the most prestigious waterfront yet bucolic towns to live.
 long_descriptionOne of the most prestigious towns in which to own real estate, Greenwich is graced with over 32 miles of Long Island Sound shoreline, beautiful beaches, rolling hills, hiking and horseback riding trails, meadows and 9 golf courses. Recognized for outstanding schools, recreational programs, cultural institutions, abundant restaurants, low property taxes with close proximity to New York City and 3 major airports. A waterfront community founded in 1640 – Greenwich is proud of its heritage and exceptional, quality of lifestyle it has to offer.
 created2016-04-04 10:51:54
 modified2016-04-04 10:51:54
 timezoneAmerica/New_York
 population62000
 uri/locations/view/20/greenwich-ct-usa
 tile_nameGreenwich, CT, USA
 Brokerage(array)
 id83
 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_properties5
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id1
 WOEID2414657
 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
 nameNew England Land Company
 broker_of_record_name
 short_nameNew England Land Company
 usernameNewEnglandLandCompany
 passwordea51ce08628ef257ebf7ac572ad20aefcc409a41
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date0000-00-00
 monthly_invoice_end_date0000-00-00
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionNew England Land Company is the exclusive representative for Leverage Global Partners in Greenwich, Old Greenwich, Riverside, and Cos Cob, Connecticut, USA. New England Land Company, established in 1971, is Greenwich’s most diversified real estate company and a recognized leader in the residential and commercial real estate industry. Active as owner, developer and agent, the Greenwich-based firm has been instrumental in the success of some of Greenwich’s and New England’s most significant and coveted real estate projects. As Greenwich’s pre-eminent real estate boutique with unparalleled credentials, sterling reputation and intimate knowledge of the area market, New England Land Company has acted as listing or selling agent, as well as creative land developer for a number of Greenwich’s “Great Estates”. Such projects include “Dunellen Hall”, “Reynwood Manor”, “Three Oaks”, “Conyers Farm”, “Cricket Hill”, “Beechcroft”, “The Johnston Estate” and “Fairacres” - a 20-acre estate atop Round Hill Road. In addition, the firm prides itself on servicing all clients from first-time homeowners to executives relocating and long-standing residents. The company continues to maintain its high standards of tradition, excellence and success as evidenced by well over $1 billion of closed transactions. Personable, resourceful and well established, New England Land Company excels at building trusting, long—lasting relationships with clients and the community.
 communitiesGreenwich Old Greenwich Riverside Cos Cob
 websitehttp://www.newenglandland.com/
 address135 East Putnam Avenue
 address_2
 cityGreenwich
 stateCT
 full_stateConnecticut
 countryUSA
 marketGreenwich
 market_2
 postal_code06830
 phoneOffice: (203) 661-6004
 phone_2John McAtee: (203) 912-3787
 phone_3Hillary McAtee: (203) 661-6004
 wide_contact_image(false)
 contact_nameJohn & Hillary McAtee
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleManaging Partners
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2[email protected]
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename83.jpg
 logo_filename83.jpg
 contact_image_filename83.jpg
 all_properties_link_image_filename83.jpg
 all_properties_linkhttp://www.newenglandland.com/residential-properties.php
 video_embed_code
 contact_video_embed_code
 meta_titleGreenwich Real Estate | New England Land Company | Leverage Global Partners
 meta_descriptionNew England Land Company is the exclusive representative for Leverage Global Partners in Greenwich, Old Greenwich, Riverside, Cos Cob Connecticut, USA.
 meta_keywordsNew England Land Company, Greenwich Real Estate, Greenwich Connecticut, Leverage Global Partners, John McAtee, Hillary McAtee, Greenwich, Old Greenwich real estate, Riverside real estate, Cos Cob real estate, Connecticut 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-01-14 12:04:58
 modified2020-11-20 12:05:11
 dre_num012345
 uri/brokerage-detail/83/new-england-land-company
 website_shortwww.newenglandland.com
 name_with_locationNew England Land Company
 Image(array)
 id2947
 modelLocation
 model_id20
 tagImage
 namenew england land company.jpg
 typeimage/jpeg
 size211713
 uri/assets/2947.jpg
 order0
 created2016-04-04 10:51:36
 modified2016-04-04 10:51:54
- location_properties(empty)
- main_article(empty)
- brokerage(array)
 Brokerage(array)
 id91
 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_properties1
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID2458677
 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
 nameCountry Houses Real Estate
 broker_of_record_name
 short_nameCountry Houses Real Estate
 usernameCountryHousesRealEstate
 passwordfa747511f36d752dc37dfe0806a21d7aed3098d6
 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
 descriptionCountry Houses Real Estate is the exclusive representative for Leverage Global Partners in New London, Warner, Grantham, Georges Mills, Sunapee, and Greater Lake Sunapee, New Hampshire, USA. Since 1939, New London, NH based Country Houses Real Estate has been a trusted advisor to thousands of clients in the greater Lake Sunapee Region. With nearly 40 dedicated and knowledgeable agents and brokers in five area offices, Country Houses can provide you with the highly specialized information you need to guide you through the process of buying or selling a home. The Lake Sunapee Region boasts unique communities with village settings, excellent school systems, and many recreational opportunities and is centrally located for an easy commute to both Concord and the Dartmouth Upper Valley Region. Whether it’s a year round home or a vacation destination, families, retirees, craftsman and business people alike enjoy our pristine lakes, mountain activities, locally owned shops, restaurants and beautiful scenery. Our agents are passionate about their communities and will put their knowledge and excellent negotiation skills to work for you. Nothing makes us happier than sharing the Lake Sunapee Region with you.
 communitiesNew London Warner Grantham Georges Mills Sunapee Greater Lake Sunapee
 websitehttp://www.countryhousesre.com/
 address370 Main Street
 address_2
 cityNew London
 stateNH
 full_stateNew Hampshire
 countryUSA
 marketNew London
 market_2
 postal_code03257
 phoneOffice: (603) 526-4020
 phone_2Fax: (603) 526-2070
 phone_3
 wide_contact_image(false)
 contact_nameStefan Timbrell & Joe Burns
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titlePartners
 contact_dre_num
 contact_quoteWe invite you to call us about New London - Lake Sunapee 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_filename91.jpg
 logo_filename91.jpg
 contact_image_filename91.jpg
 all_properties_link_image_filename91.png
 all_properties_linkhttp://www.countryhousesre.com/featured
 video_embed_code
 contact_video_embed_code
 meta_titleNew London Real Estate | Country Houses Real Estate | Leverage Global Partners
 meta_descriptionCountry Houses Real Estate is the exclusive representative for Leverage Global Partners in New London, New Hampshire, USA.
 meta_keywordsCountry Houses Real Estate, Leverage Global Partners, New London Real Estate, New Hampshire, New London New Hampshire, Warner Real Estate, Grantham Real Estate, Georges Mills Real Estate, Sunapee Real Estate, Greater Lake Sunapee 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-01-30 10:36:13
 modified2016-04-08 16:34:01
 dre_num012345
 uri/brokerage-detail/91/country-houses-real-estate
 website_shortwww.countryhousesre.com
 name_with_locationCountry Houses Real Estate - New London, NH, USA
 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)
 id2509
 modelBrokerage
 model_id91
 tagLogo
 name91.jpg
 typeimage/jpg
 size116032
 uri/assets/2509.jpg
 order0
 created2016-03-30 11:40:27
 modified2016-03-30 11:40:27
 MainImage(array)
 id2508
 modelBrokerage
 model_id91
 tagMainImage
 name91.jpg
 typeimage/jpg
 size216734
 uri/assets/2508.jpg
 order0
 created2016-03-30 11:40:27
 modified2016-03-30 11:40:27
 ContactImage(array)
 id2510
 modelBrokerage
 model_id91
 tagContactImage
 name91.jpg
 typeimage/jpg
 size493451
 uri/assets/2510.jpg
 order0
 created2016-03-30 11:40:28
 modified2016-03-30 11:40:28
 ContactImage2(array)
 id(null)
 model(null)
 model_id(null)
 tag(null)
 name(null)
 type(null)
 size(null)
 uri(null)
 order(null)
 created(null)
 modified(null)
 ContactImage3(array)
 id(null)
 model(null)
 model_id(null)
 tag(null)
 name(null)
 type(null)
 size(null)
 uri(null)
 order(null)
 created(null)
 modified(null)
 BrokerOfRecordLogo(array)
 id(null)
 model(null)
 model_id(null)
 tag(null)
 name(null)
 type(null)
 size(null)
 uri(null)
 order(null)
 created(null)
 modified(null)
 MainArticle(array)
 id(null)
 model(null)
 model_id(null)
 archived(null)
 medium_featured(null)
 large_featured(null)
 title(null)
 author(null)
 date(null)
 lead_in(null)
 body(null)
 vimeo_id(null)
 created(null)
 modified(null)
 FeaturedImage(empty)
 Location(array)
 0(array)
 id13
 parent_id7
 brokerage_id91
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameNew London, NH, USA
 short_nameNew London, NH, USA
 group_index
 latitude43.402393
 longitude-71.987556
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_description
 long_descriptionWith elegance and grace the Lake Sunapee Region has become a hub of culture and community in central New Hampshire. This melting pot of remarkable school systems, luring mountain ranges, charming neighbor hoods, and luminous waterbodies is perfect for the first- time homebuyer or the second-home buyer. Enjoy a show in a renovated barn, tee up for a cause, hit the slopes with friends, or savor a cocktail on your sunset dinner boat cruise. We’ve got it all, and it’s waiting for you!
 created2016-04-04 09:51:41
 modified2016-04-04 10:46:45
 timezoneAmerica/New_York
 population30000
 uri/locations/view/13/new-london-nh-usa
 tile_nameNew London, NH, USA
 User(array)
 0(array)
 id117
 typeBrokerageAdmin
 brokerage_id91
 email[email protected]
 passwordfa747511f36d752dc37dfe0806a21d7aed3098d6
 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:26:58
 created2016-04-08 16:34:01
 notified(true)
 full_name
 uri/agent-detail/117/
 profile_complete(false)
 1(array)
 id425
 typeAgent
 brokerage_id91
 email[email protected]
 password152cafb889b1ce216ed82a20b2b75feb4d42125a
 recover_hash
 first_nameCharlie
 last_nameForbes
 title
 dre_num
 phone603-340-2432
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:22:57
 created2017-08-07 15:22:57
 notified(false)
 full_nameCharlie Forbes
 uri/agent-detail/425/charlie-forbes
 profile_complete(true)
 2(array)
 id426
 typeAgent
 brokerage_id91
 email[email protected]
 password69fcc2b02306541ac39c18a4b2b8c40c27e0e5fa
 recover_hash
 first_nameKaren
 last_nameHaskell
 title
 dre_num
 phone603-568-0173
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:22:57
 created2017-08-07 15:22:57
 notified(false)
 full_nameKaren Haskell
 uri/agent-detail/426/karen-haskell
 profile_complete(true)
 3(array)
 id888
 typeAgent
 brokerage_id91
 email[email protected]
 password74280abc551e1ba4a6e57128652678eb0601a8f5
 recover_hash
 first_nameJohn
 last_nameChiarella
 title
 dre_num
 phone603-249-6478
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:43
 created2017-08-07 15:23:43
 notified(false)
 full_nameJohn Chiarella
 uri/agent-detail/888/john-chiarella
 profile_complete(true)
 4(array)
 id889
 typeAgent
 brokerage_id91
 email[email protected]
 password276746b45994da52ac83e571a7ca6b3188e541b0
 recover_hash
 first_nameJohn
 last_nameChiarella
 title
 dre_num
 phone603-249-6478
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:43
 created2017-08-07 15:23:43
 notified(false)
 full_nameJohn Chiarella
 uri/agent-detail/889/john-chiarella
 profile_complete(true)
 5(array)
 id973
 typeAgent
 brokerage_id91
 email[email protected]
 passwordf08f943cdb5564e3d95d5a8142686c7b77193e95
 recover_hash
 first_nameJoe
 last_nameBurns
 title
 dre_num
 phone6037311165
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:46
 created2017-08-07 15:23:46
 notified(false)
 full_nameJoe Burns
 uri/agent-detail/973/joe-burns
 profile_complete(true)
 6(array)
 id1003
 typeAgent
 brokerage_id91
 email[email protected]
 passwordc81fbb973d6d63af5cf45e085076d408d1cbb2e7
 recover_hash
 first_nameStacey
 last_nameViandier
 title
 dre_num
 phone6035264020
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:47
 created2017-08-07 15:23:47
 notified(false)
 full_nameStacey Viandier
 uri/agent-detail/1003/stacey-viandier
 profile_complete(true)
- location(array)
 Location(array)
 id13
 parent_id7
 brokerage_id91
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameNew London, NH, USA
 short_nameNew London, NH, USA
 group_index
 latitude43.402393
 longitude-71.987556
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_description
 long_descriptionWith elegance and grace the Lake Sunapee Region has become a hub of culture and community in central New Hampshire. This melting pot of remarkable school systems, luring mountain ranges, charming neighbor hoods, and luminous waterbodies is perfect for the first- time homebuyer or the second-home buyer. Enjoy a show in a renovated barn, tee up for a cause, hit the slopes with friends, or savor a cocktail on your sunset dinner boat cruise. We’ve got it all, and it’s waiting for you!
 created2016-04-04 09:51:41
 modified2016-04-04 10:46:45
 timezoneAmerica/New_York
 population30000
 uri/locations/view/13/new-london-nh-usa
 tile_nameNew London, NH, USA
 Image(array)
 id2940
 modelLocation
 model_id13
 tagImage
 namecountry houses real estate.jpg
 typeimage/jpeg
 size148372
 uri/assets/2940.jpg
 order0
 created2016-04-04 09:50:03
 modified2016-04-04 10:46:45
- 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)
 Location(empty)
 Image(empty)
 Brokerage(empty)
 AccountExecutive(empty)
 Logo(empty)
 MainImage(empty)
 ContactImage(empty)
 ContactImage2(empty)
 ContactImage3(empty)
 BrokerOfRecordLogo(empty)
 MainArticle(empty)
 Property(empty)
 User(empty)
 PropertyFeature(empty)
 SecondaryPropertyCategory(empty)
 Topic(empty)
 FeaturedImage(empty)
 Article(empty)
 ParentBrokerage(empty)
 ParentLocation(empty)
 ArticlesBrokerage(empty)
 ArticlesLocation(empty)
 ArticlesProperty(empty)
 ArticlesTopic(empty)
 PrimaryPropertyCategory(empty)
 StripeSubscription(empty)
 GlobalReachReport(empty)
 UsersProperty(empty)
 PropertiesSecondaryPropertyCategory(empty)
 PropertiesPropertyFeature(empty)
 PropertiesTopic(empty)
- Loaded Helpers(array)
 0Permission
 1Geography
 2Number
 3SimpleGraph
 4DebugTimer
 5Toolbar
 6Session
 7Text
 8Flash
 9HtmlToolbar
 10Html
 11Form
====

Environment

App Constants

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

CakePHP Constants

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

PHP Environment

Environment Variable	Value
Php Version	7.4.33
User	leveragere
Home	/var/www/vhosts/leveragere.com
Script Name	/index.php
Request Uri	/locations/view/13/new-london-nh-usa
Query String
Request Method	GET
Server Protocol	HTTP/1.1
Gateway Interface	CGI/1.1
Redirect Url	/locations/view/13/new-london-nh-usa
Remote Port	18341
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.41
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	a09d852929cf34fc-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	aiorIPK8CRJnCvkkTtrrzQAAAMA
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	aiorIPK8CRJnCvkkTtrrzQAAAMA
Fcgi Role	RESPONDER
Php Self	/index.php
Request Time Float	1781148448.2842
Request Time	1781148448

====

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

New London, NH, USA

Location Represented By

Related Articles

Share This

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 24 ms Total Queries: 19 queries

Query Explain:

Memory

Timers

Logs

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

Total Time: 24 ms
Total Queries: 19 queries