Properties /

The Beach Life in San Clemente

42 Via Belleza | San Clemente, CA 92673, USA | $985,000

4 Beds
2 Baths

42 Via Belleza is located in the highly sought after friendly Miraleste neighborhood of Talega with convenient access to the beautiful trails that border the Richard & Donna O'Neill Land Conservancy. This clean and bright home is situated on a generous sized lot with beautiful mature trees in the backyard and front for plenty of privacy and a grassy lot for kids to play. Offering two paved patio areas with water fountain outside that allow for optimal outdoor entertaining, while the home inside features an ideal open concept floor plan with large kitchenfamily room area with surround sound, two fireplaces, four bedroomsincluding a master retreat, making it the perfect place for entertaining and spacious enough for raising a family. The office can easily be converted to a 5th bedroom downstairs suite as it already includes the plumbing for a fourth bathroom. Enjoy the new Outlets at San Clemente, neighborhood parks, community and shopping center, San Clemente Sports Park & Aquatic Center, miles of beach trails and easy access to San Juan Capistrano with the opening of the La Pata extension. Come see this gem before it's gone.

Represented By: The Boutique Real Estate Group

www.theboutiquere.com | License #: 012345

Ryan Klusmeyer
9496122535
Email

Main Office: 3653 E. Coast Hwy
Corona Del Mar, CA
USA

More About Ryan

View On Map Property Website

Highlighted Properties

THE GOOD LIFE IN THE COUNTRY

3015 Steeplechase Lane | Diamond Bar, CA 91765
$2,999,888

Life in Laguna Beach

1000 Flamingo Rd | Laguna Beach, Ca 92651
$19,888,888

Represented By

Agent Contacts: Ryan Klusmeyer 9496122535 | Email

Featured Location

Newport Beach, CA, USA

Celebrated as an alluring destination, Orange County’s beauty is more than skin deep.

Related Property Listings

Property Search

Bedrooms

Baths

Minimum Price

Maximum Price

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

Cake Params
- plugin(null)
- controllerproperties
- actionview
- named(empty)
- pass(array)
  03421
  142-via-belleza-san-clemente-ca-92673-usa
- isAjax(false)
Post data

No post data.

Query string

No querystring data.

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

Sql Log

Sql Logs

default

Total Time: 11 ms
Total Queries: 33 queries

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

Query Explain:

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

====

Timer

Memory

Peak Memory Use 11.42 MB

Message	Memory use
Component initialization	3.07 MB
Controller action start	4.01 MB
Controller render start	6.75 MB
View render complete	7.27 MB

Timers

Total Request Time: 262 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	38.59
Event: Controller.initialize	5.16
Event: Controller.startup	2.60
Controller action	72.29
Event: Controller.beforeRender	9.10
» Processing toolbar data	8.98
Rendering View	107.47
» Event: View.beforeRender	0.41
» Rendering APP/View/Properties/view.ctp	3.17
» » Rendering APP/View/Elements/static_property_price.ctp	0.45
» » Rendering APP/View/Elements/property_features.ctp	0.21
» » Rendering APP/View/Elements/static_property_price.ctp #2	0.15
» » Rendering APP/View/Elements/static_property_price.ctp #3	0.14
» » Rendering APP/View/Elements/sidebar/location_list.ctp	0.14
» » Rendering APP/View/Elements/sidebar/property_list.ctp	0.94
» » » Rendering APP/View/Elements/static_property_price.ctp #4	0.14
» » » Rendering APP/View/Elements/static_property_price.ctp #5	0.13
» » » Rendering APP/View/Elements/static_property_price.ctp #6	0.13
» » » Rendering APP/View/Elements/static_property_price.ctp #7	0.13
» » Rendering APP/View/Elements/sidebar/property_search.ctp	0.19
» Event: View.afterRender	0.01
» Event: View.beforeLayout	0.00
» Rendering APP/View/Layouts/front.ctp	103.16
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)
 id3420
 brokerage_id168
 created_by_user_id0
 order7
 multi_unit(false)
 agent_1_id55
 agent_2_id0
 agent_3_id0
 namePortola Springs Executive Home
 incomplete(false)
 archived(false)
 last_archived0000-00-00 00:00:00
 auto_archived_from_mlsidx(false)
 paid_featured(false)
 featured(true)
 homepage_featured(true)
 brokerage_page_featured(true)
 requested_homepage_featured_by_member(false)
 homepage_featured_by_member(false)
 dot_luxury_featured(false)
 luxury_feed_featured(false)
 force_luxury_feed_featured(false)
 luxury_autofeed_imported(false)
 luxury_feed_last_added_time0000-00-00 00:00:00
 luxury_feed_agent_user_id0
 luxury_feed_locked_to_subscription_id0
 luxury_feed_agent_purchase_date0000-00-00
 luxury_feed_agent_expiration_date0000-00-00
 digital_ad_summary_email_last_sent0000-00-00 00:00:00
 digital_ad_summary_price_changed(false)
 wsj_detail_url
 ft_detail_url
 nyt_detail_url
 juwai_detail_url
 pgl_detail_url
 mg_detail_url
 mg_c_detail_url
 mg_s_detail_url
 bp_detail_url
 mw_detail_url
 nikkei_detail_url
 wapo_detail_url
 robb_detail_url
 medium_featured(true)
 large_featured(false)
 detail_page(true)
 descriptionNew Price. $880,000. 32 Bell Chime is a Fully Upgraded Executive Home in The Portola Springs Community of Bougainvillea in Irvine. This Home Boasts Approximately 2,300 square feet of Living Space with 4 Bedrooms + Office (Optional 4th Bedroom) + Loft (Optional 5th Bedroom) & 3.5 Baths. Gourmet Chefs Kitchen with Granite Slab Countertops & Backsplash, Stainless Steel Appliances, Huge Center Island with Breakfast Bar. Beautiful Artisan Laid Travertine Tile Floors Downstairs with Coordinating Upgraded Carpet & Custom Paint Throughout. Media Niche in Living Room with In-Ceiling Speakers, Fireplace, Ceiling Fan, Custom Window Coverings & Whole Home Intercom. Opulent Master Bedroom with Balcony & Master Bathroom with Dual Vanities, Custom Backsplash, Spa Tub with Custom Tile Surround, Upgraded Tile Floors & Dual Walk-In Closets with Built-Ins. Second Level Office (Optional 4th Bedroom) with In-Ceiling Speakers & Media Center Built-Ins & 3rd Level Loft (Optional 5th Bedroom with Custom Built In Three Person Workstation and Private Bath. Great Entertainers Backyard with BBQ Island, Stainless Steel BBQ & Plenty of Room to Entertain. Two Car Attached Garage with Custom Built-Ins & Overhead Storage. Community Features include Clubhouse, Swimming Pool, Spa, Basketball & Tennis Courts, Playgrounds and Lush Parks. Minutes Away From The Irvine Spectrum, The Great Park, Fabulous Schools, Shopping, Dining, Entertainment & Easy Freeway Access.
 address32 Bell Chime
 address_2
 cityIrvine
 stateCA
 postal_code92618
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price880000
 price_20
 price_usd880000
 price_usd_20
 statusFor Sale
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(false)
 bedrooms5
 bedrooms_20
 bathrooms3
 bathrooms_20
 no_beds_baths(false)
 square_feet2300
 square_meters
 acres0
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size0
 icon_1sq-ft
 icon_2
 icon_3
 icon_4
 icon_5
 icon_6
 website
 meta_titlePortola Springs Executive Home | Irvine Real Estate | The Boutique Real Estate Group
 meta_description32 Bell Chime is a property offered for sale in Irvine, CA, USA, presented by The Boutique Real Estate Group
 meta_keywords
 bathrooms_partial0
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built
 virtual_tourhttps://www.vpix.net/index.php?tour=444203
 video_tourhttps://www.youtube.com/watch?v=g5uQg3O77C4
 digital_brochure
 video_tour_embed_code<iframe width="560" height="315" src="https://www.youtube.com/embed/g5uQg3O77C4?controls=0&showinfo=0" frameborder="0" allowfullscreen></iframe>
 digital_brochure_embed_code
 mls_num
 wsj_property_type
 nyt_property_type
 nyt_popular_features
 propgolux_property_type
 juwai_property_type
 juwai_category
 propgolux_property_style
 wapo_property_type
 robb_property_type
 propgolux_location_id_override
 open_house_1_start0000-00-00 00:00:00
 open_house_1_end_time00:00:00
 latitude0.000000
 longitude0.000000
 invalid_required_fieldslatitude, longitude
 invalid_optional_fieldsagent_2_id, square_meters, acres, hectares, bathrooms_partial, year_built, wsj_property_type, nyt_property_type, propgolux_property_type, propgolux_property_style
 went_live_today(false)
 converted(true)
 invalid(false)
 mlsidx_full_address
 mlsidx_date_listed0000-00-00
 mls_market
 primary_property_category_id0
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated(null)
 modified2016-04-18 05:33:03
 created2016-02-10 20:55:49
 uri/property-detail/3420/32-bell-chime-irvine-ca-92618-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3420/32-bell-chime-irvine-ca-92618-usa
 address_concat32 Bell Chime Irvine CA 92618 USA
 google_maps_query_string32+Bell+Chime++Irvine+CA+92618+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 880,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty5
 bathrooms_pretty3
 bathrooms_partial_pretty0
 bathrooms_3_4_pretty0
 feed_full_bathrooms3
 date_listed2016-02-10
 overridden_brokerage_nameThe Boutique Real Estate Group
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id168
 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
 WOEID23417205
 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
 nameThe Boutique Real Estate Group
 broker_of_record_name
 short_nameThe Boutique Real Estate Group
 usernameTheBoutiqueRealEstate
 password01759fcc62fbf8022ef42c08f544e99731e7b5f6
 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
 descriptionThe Boutique Real Estate Group is the exclusive representative for Leverage Global Partners in Newport Beach, Corona Del Mar, Balboa Island, Newport Coast, Huntington Beach, Sunset Beach, CA, USA. The Boutique Real Estate Group is a boutique real estate brokerage founded in Orange County, CA, that focuses on brilliant design, beautiful marketing & luxury services and will be opening multiple offices throughout the Southern California Luxury Real Estate Market. The Boutique has created a culture that spurs collaboration, technology and social media with a unique marketing approach. Our story goes a little something like this. Beautiful design evokes emotion. Emotion stirs the soul and creates a connection between client, agent and the home buying & selling process. The Boutique Real Estate Group has invested heavily in bringing all aspects of the real estate experience completely in-house. From custom design, professional staging, amazing photography, cinematography & film production, social media to technology, internet optimization & cloud based transaction management. This not only provides The Boutique with complete control of the design, marketing & technology of luxury real estate but also gives us the look & feel of a true boutique marketing agency. This design & tech-forward approach has earned The Boutique Real Estate Group accolades & awards worldwide. 2015 Inman News Innovator Award for Most Innovative Technology | Nominee 2015 Top 33 People Changing The Real Estate Industry 2014 Best Real Estate Video of The Year 2014 Inman News Innovator Award for Most Innovative Real Estate Agent | Nominee 2014 Next Generation Real Estate Brokerage 2014 Top 100 Most Influential Real Estate Leaders in The USA 2013 Top 100 Most Influential Real Estate Leaders in The USA 2013 Top 20 Real Estate Videos in The USA
 communitiesNewport Beach Corona Del Mar Balboa Island Newport Coast Huntington Beach Sunset Beach
 websitehttp://www.theboutiquere.com/
 address3653 E. Coast Hwy
 address_2
 cityCorona Del Mar
 stateCA
 full_stateCalifornia
 countryUSA
 marketNewport Beach
 market_2
 postal_code
 phone(949) 612-2535
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameRaj Qsar
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/leverage-lifestyle/meet-raj-qsar-the-boutique-real-estate-group/
 contact_big_profile_link_textMeet Raj
 contact_titlePrincipal/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_filename168.jpg
 logo_filename168.jpg
 contact_image_filename168.jpg
 all_properties_link_image_filename168.jpg
 all_properties_linkhttp://www.theboutiquere.com/properties
 video_embed_code<script type="text/javascript" src="http://videocontent.jloop.com/players/xQ9ZyzIQ-qzxAOUo0.js"></script>
 contact_video_embed_code
 meta_titleNewport Beach Real Estate⎜The Boutique Real Estate Group⎜Leverage Global Partners
 meta_descriptionThe Boutique Real Estate Group is the exclusive representative for Leverage Global Partners in Newport Beach, CA, USA.
 meta_keywordsThe Boutique Real Estate Group, Raj Qsar, Newport Beach Real Estate, Corona Del Mar Real Estate, Balboa Island Real Estate, Newport Coast Real Estate, Huntington Beach Real Estate, Sunset Beach Real Estate, California Real Estate, 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-10-28 16:37:40
 modified2016-04-08 16:34:15
 dre_num012345
 uri/brokerage-detail/168/the-boutique-real-estate-group
 website_shortwww.theboutiquere.com
 name_with_locationThe Boutique Real Estate Group
 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)
 id18243
 modelProperty
 model_id3420
 tagImage
 name33190.jpg
 typeimage/jpg
 size762403
 uri/assets/18243.jpg
 order0
 created2016-04-07 17:08:10
 modified2016-04-07 17:08:10
 1(array)
 id18242
 modelProperty
 model_id3420
 tagImage
 name33191.jpg
 typeimage/jpg
 size523127
 uri/assets/18242.jpg
 order1
 created2016-04-07 17:08:10
 modified2016-04-07 17:08:10
 2(array)
 id18241
 modelProperty
 model_id3420
 tagImage
 name33192.jpg
 typeimage/jpg
 size634497
 uri/assets/18241.jpg
 order2
 created2016-04-07 17:08:10
 modified2016-04-07 17:08:10
 3(array)
 id18240
 modelProperty
 model_id3420
 tagImage
 name33193.jpg
 typeimage/jpg
 size502152
 uri/assets/18240.jpg
 order3
 created2016-04-07 17:08:10
 modified2016-04-07 17:08:10
 4(array)
 id18239
 modelProperty
 model_id3420
 tagImage
 name33194.jpg
 typeimage/jpg
 size483242
 uri/assets/18239.jpg
 order4
 created2016-04-07 17:08:10
 modified2016-04-07 17:08:10
 5(array)
 id18238
 modelProperty
 model_id3420
 tagImage
 name33195.jpg
 typeimage/jpg
 size524582
 uri/assets/18238.jpg
 order5
 created2016-04-07 17:08:10
 modified2016-04-07 17:08:10
 6(array)
 id18237
 modelProperty
 model_id3420
 tagImage
 name33196.jpg
 typeimage/jpg
 size595376
 uri/assets/18237.jpg
 order6
 created2016-04-07 17:08:10
 modified2016-04-07 17:08:10
 7(array)
 id18244
 modelProperty
 model_id3420
 tagImage
 name33197.jpg
 typeimage/jpg
 size498548
 uri/assets/18244.jpg
 order7
 created2016-04-07 17:08:10
 modified2016-04-07 17:08:10
 8(array)
 id18245
 modelProperty
 model_id3420
 tagImage
 name33198.jpg
 typeimage/jpg
 size448815
 uri/assets/18245.jpg
 order8
 created2016-04-07 17:08:10
 modified2016-04-07 17:08:10
 9(array)
 id18246
 modelProperty
 model_id3420
 tagImage
 name33199.jpg
 typeimage/jpg
 size453721
 uri/assets/18246.jpg
 order9
 created2016-04-07 17:08:10
 modified2016-04-07 17:08:10
 User(empty)
 SecondaryPropertyCategory(empty)
 PropertyFeature(empty)
 Topic(empty)
 1(array)
 Property(array)
 id2628
 brokerage_id168
 created_by_user_id0
 order4
 multi_unit(false)
 agent_1_id55
 agent_2_id64
 agent_3_id0
 nameWe LOVE Yorba Linda... And YOU will too.
 incomplete(false)
 archived(false)
 last_archived0000-00-00 00:00:00
 auto_archived_from_mlsidx(false)
 paid_featured(false)
 featured(true)
 homepage_featured(true)
 brokerage_page_featured(true)
 requested_homepage_featured_by_member(false)
 homepage_featured_by_member(false)
 dot_luxury_featured(false)
 luxury_feed_featured(false)
 force_luxury_feed_featured(false)
 luxury_autofeed_imported(false)
 luxury_feed_last_added_time0000-00-00 00:00:00
 luxury_feed_agent_user_id0
 luxury_feed_locked_to_subscription_id0
 luxury_feed_agent_purchase_date0000-00-00
 luxury_feed_agent_expiration_date0000-00-00
 digital_ad_summary_email_last_sent0000-00-00 00:00:00
 digital_ad_summary_price_changed(false)
 wsj_detail_url
 ft_detail_url
 nyt_detail_url
 juwai_detail_url
 pgl_detail_url
 mg_detail_url
 mg_c_detail_url
 mg_s_detail_url
 bp_detail_url
 mw_detail_url
 nikkei_detail_url
 wapo_detail_url
 robb_detail_url
 medium_featured(false)
 large_featured(false)
 detail_page(true)
 description4116 Temhurst Ct is a Gorgeous Pool Home in The Vista Del Verde Golf Community of Foxfield. Located On A Cul-De-Sac This Estate Spans Approximately 3,608 square feet of Living Space with 5 Bedrooms + Bonus Room with Tech-Center + Library & 4 Full Baths (Bonus Room Could Be 5th Bedroom). Gourmet Chefs Kitchen with Granite Slab Countertops & Full Granite Backsplash, Stainless Steel Appliances & Huge Center Island with Breakfast Bar. Hand Scrapped & Distressed Wood Plank Floors Downstairs with Coordinating Upgraded Carpet & Custom Paint Throughout. Custom Media Niche in Family Room, In-Ceiling Speakers, Plantation Shutters & Audio Pre-Wire Throughout Home. Formal Living Room with Fireplace, Dining Room with Wine Cellar & French Doors Leading to Courtyard. Opulent Master Bedroom with Fireplace, Plantation Shutters & Dual Walk-In Closets. Luxurious Master Bathroom with Dual Vanities with Marble Counters, Jacuzzi Spa Tub with Marble Surround & Travertine Floors. Upstairs Bonus Room with Tech Center (Could Be 5th Bedroom). Great Entertainers Backyard with Custom Designed Salt Water Pool, Spa, Fireplace & Outdoor Kitchen. Three Car Garage with Custom Built-Ins & Overhead Storage. Minutes Away From Black Gold Golf Course, Yorba Linda Country Club and the new Yorba Linda Marketplace. Home to The New Yorba Linda High School. No HOA & No Mello Roos.
 address4116 Temhurst Ct
 address_2
 cityYorba Linda
 stateCA
 postal_code92886
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price1299000
 price_20
 price_usd1299000
 price_usd_20
 statusFor Sale
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(false)
 bedrooms5
 bedrooms_20
 bathrooms4
 bathrooms_20
 no_beds_baths(false)
 square_feet3608
 square_meters
 acres0
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size0
 icon_1pool
 icon_2sq-ft
 icon_3cellar
 icon_4garage
 icon_5
 icon_6
 websitehttp://4116temhurstct.com/
 meta_titleWe LOVE Yorba Linda... And YOU will too. | Yorba Linda Real Estate | The Boutique Real Estate Group
 meta_description4116 Temhurst Ct is a property offered for sale in Yorba Linda, CA, USA, presented by The Boutique Real Estate Group
 meta_keywords
 bathrooms_partial0
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built
 virtual_tourhttp://theboutiquere.com/orange-county-real-estate/4116-temhurst-court-yorba-linda-ca-92886/PW15167732/1369
 video_tourhttp://theboutiquere.com/marketing/real-estate-films
 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
 latitude33.902069
 longitude-117.808800
 invalid_required_fields
 invalid_optional_fieldsbathrooms_partial, square_meters, acres, hectares
 went_live_today(false)
 converted(true)
 invalid(false)
 mlsidx_full_address
 mlsidx_date_listed0000-00-00
 mls_market
 primary_property_category_id0
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated(null)
 modified2016-04-18 05:33:02
 created2015-08-12 18:39:50
 uri/property-detail/2628/4116-temhurst-ct-yorba-linda-ca-92886-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/2628/4116-temhurst-ct-yorba-linda-ca-92886-usa
 address_concat4116 Temhurst Ct Yorba Linda CA 92886 USA
 google_maps_query_string4116+Temhurst+Ct++Yorba+Linda+CA+92886+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 1,299,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty5
 bathrooms_pretty4
 bathrooms_partial_pretty0
 bathrooms_3_4_pretty0
 feed_full_bathrooms4
 date_listed2015-08-12
 overridden_brokerage_nameThe Boutique Real Estate Group
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id168
 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
 WOEID23417205
 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
 nameThe Boutique Real Estate Group
 broker_of_record_name
 short_nameThe Boutique Real Estate Group
 usernameTheBoutiqueRealEstate
 password01759fcc62fbf8022ef42c08f544e99731e7b5f6
 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
 descriptionThe Boutique Real Estate Group is the exclusive representative for Leverage Global Partners in Newport Beach, Corona Del Mar, Balboa Island, Newport Coast, Huntington Beach, Sunset Beach, CA, USA. The Boutique Real Estate Group is a boutique real estate brokerage founded in Orange County, CA, that focuses on brilliant design, beautiful marketing & luxury services and will be opening multiple offices throughout the Southern California Luxury Real Estate Market. The Boutique has created a culture that spurs collaboration, technology and social media with a unique marketing approach. Our story goes a little something like this. Beautiful design evokes emotion. Emotion stirs the soul and creates a connection between client, agent and the home buying & selling process. The Boutique Real Estate Group has invested heavily in bringing all aspects of the real estate experience completely in-house. From custom design, professional staging, amazing photography, cinematography & film production, social media to technology, internet optimization & cloud based transaction management. This not only provides The Boutique with complete control of the design, marketing & technology of luxury real estate but also gives us the look & feel of a true boutique marketing agency. This design & tech-forward approach has earned The Boutique Real Estate Group accolades & awards worldwide. 2015 Inman News Innovator Award for Most Innovative Technology | Nominee 2015 Top 33 People Changing The Real Estate Industry 2014 Best Real Estate Video of The Year 2014 Inman News Innovator Award for Most Innovative Real Estate Agent | Nominee 2014 Next Generation Real Estate Brokerage 2014 Top 100 Most Influential Real Estate Leaders in The USA 2013 Top 100 Most Influential Real Estate Leaders in The USA 2013 Top 20 Real Estate Videos in The USA
 communitiesNewport Beach Corona Del Mar Balboa Island Newport Coast Huntington Beach Sunset Beach
 websitehttp://www.theboutiquere.com/
 address3653 E. Coast Hwy
 address_2
 cityCorona Del Mar
 stateCA
 full_stateCalifornia
 countryUSA
 marketNewport Beach
 market_2
 postal_code
 phone(949) 612-2535
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameRaj Qsar
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/leverage-lifestyle/meet-raj-qsar-the-boutique-real-estate-group/
 contact_big_profile_link_textMeet Raj
 contact_titlePrincipal/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_filename168.jpg
 logo_filename168.jpg
 contact_image_filename168.jpg
 all_properties_link_image_filename168.jpg
 all_properties_linkhttp://www.theboutiquere.com/properties
 video_embed_code<script type="text/javascript" src="http://videocontent.jloop.com/players/xQ9ZyzIQ-qzxAOUo0.js"></script>
 contact_video_embed_code
 meta_titleNewport Beach Real Estate⎜The Boutique Real Estate Group⎜Leverage Global Partners
 meta_descriptionThe Boutique Real Estate Group is the exclusive representative for Leverage Global Partners in Newport Beach, CA, USA.
 meta_keywordsThe Boutique Real Estate Group, Raj Qsar, Newport Beach Real Estate, Corona Del Mar Real Estate, Balboa Island Real Estate, Newport Coast Real Estate, Huntington Beach Real Estate, Sunset Beach Real Estate, California Real Estate, 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-10-28 16:37:40
 modified2016-04-08 16:34:15
 dre_num012345
 uri/brokerage-detail/168/the-boutique-real-estate-group
 website_shortwww.theboutiquere.com
 name_with_locationThe Boutique Real Estate Group
 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)
 id15321
 modelProperty
 model_id2628
 tagImage
 name24660.jpg
 typeimage/jpg
 size473858
 uri/assets/15321.jpg
 order0
 created2016-04-07 16:51:05
 modified2016-04-15 04:22:17
 1(array)
 id15324
 modelProperty
 model_id2628
 tagImage
 name25945.jpg
 typeimage/jpg
 size630727
 uri/assets/15324.jpg
 order1
 created2016-04-07 16:51:05
 modified2016-04-15 04:22:17
 2(array)
 id15315
 modelProperty
 model_id2628
 tagImage
 name24654.jpg
 typeimage/jpg
 size567060
 uri/assets/15315.jpg
 order2
 created2016-04-07 16:51:04
 modified2016-04-15 04:22:17
 3(array)
 id15316
 modelProperty
 model_id2628
 tagImage
 name24655.jpg
 typeimage/jpg
 size450549
 uri/assets/15316.jpg
 order3
 created2016-04-07 16:51:04
 modified2016-04-15 04:22:17
 4(array)
 id15317
 modelProperty
 model_id2628
 tagImage
 name24656.jpg
 typeimage/jpg
 size501070
 uri/assets/15317.jpg
 order4
 created2016-04-07 16:51:05
 modified2016-04-15 04:22:17
 5(array)
 id15318
 modelProperty
 model_id2628
 tagImage
 name24657.jpg
 typeimage/jpg
 size522730
 uri/assets/15318.jpg
 order5
 created2016-04-07 16:51:05
 modified2016-04-15 04:22:17
 6(array)
 id15319
 modelProperty
 model_id2628
 tagImage
 name24658.jpg
 typeimage/jpg
 size409739
 uri/assets/15319.jpg
 order6
 created2016-04-07 16:51:05
 modified2016-04-15 04:22:17
 7(array)
 id15320
 modelProperty
 model_id2628
 tagImage
 name24659.jpg
 typeimage/jpg
 size449143
 uri/assets/15320.jpg
 order7
 created2016-04-07 16:51:05
 modified2016-04-15 04:22:17
 8(array)
 id15322
 modelProperty
 model_id2628
 tagImage
 name24661.jpg
 typeimage/jpg
 size419256
 uri/assets/15322.jpg
 order8
 created2016-04-07 16:51:05
 modified2016-04-15 04:22:17
 9(array)
 id15323
 modelProperty
 model_id2628
 tagImage
 name24662.jpg
 typeimage/jpg
 size430191
 uri/assets/15323.jpg
 order9
 created2016-04-07 16:51:05
 modified2016-04-15 04:22:17
 User(empty)
 SecondaryPropertyCategory(empty)
 PropertyFeature(array)
 0(array)
 id12
 nameSwimming Pool
 additional(false)
 created2016-04-07 14:04:12
 modified2016-04-07 14:04:12
 PropertiesPropertyFeature(array)
 id3122
 property_id2628
 property_feature_id12
 1(array)
 id18
 nameWine Cellar
 additional(false)
 created2016-04-07 14:06:17
 modified2016-04-07 14:06:17
 PropertiesPropertyFeature(array)
 id3123
 property_id2628
 property_feature_id18
 2(array)
 id4
 nameGarage
 additional(false)
 created2016-04-07 14:01:52
 modified2016-04-07 14:01:52
 PropertiesPropertyFeature(array)
 id3124
 property_id2628
 property_feature_id4
 Topic(empty)
 2(array)
 Property(array)
 id3465
 brokerage_id168
 created_by_user_id0
 order3
 multi_unit(false)
 agent_1_id1157
 agent_2_id0
 agent_3_id0
 nameMidcentury Ocean Views from Laguna Beach
 incomplete(false)
 archived(false)
 last_archived0000-00-00 00:00:00
 auto_archived_from_mlsidx(false)
 paid_featured(false)
 featured(true)
 homepage_featured(true)
 brokerage_page_featured(true)
 requested_homepage_featured_by_member(false)
 homepage_featured_by_member(false)
 dot_luxury_featured(false)
 luxury_feed_featured(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)
 descriptionRARE OPPORTUNITY TO OWN THIS WONDERFUL MIDCENTURY OCEAN VIEW PROPERTY! Located on a private street, this single story home offers panoramic views of the Pacific Ocean, Catalina Island, city lights and the picturesque coastline. Great for entertaining with its expansive deck and lovely rear garden. Enter the home to see beautiful floor to ceiling windows, oak floors, open beamed ceilings along with a grand white brick fireplace to enjoy on cooler evenings. Kitchen has Miele and Bosch appliances, lots of storage and a large center island. West facing living room and bedrooms all with fantastic sand and whitewater views. Master bedroom has direct access to the oversized deck with rare views of Laguna Beach. Backyard features a grassy area, fruit trees and a tranquil atrium. Parking is a breeze with an oversized driveway, covered carport for 2 vehicles, oversized storage area and easy access to the home. Located on over 7,700 square feet, this sweeping corner lot property is just minutes away from the heart of the village with shops, fine art galleries, restaurants, resorts and hiking trails! You must see to appreciate the beauty of this property! 
 address1677 Thurston
 address_2
 cityLaguna Beach
 stateCa
 postal_code92651
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price1795000
 price_20
 price_usd1795000
 price_usd_20
 statusFor Sale
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(false)
 bedrooms3
 bedrooms_20
 bathrooms2
 bathrooms_20
 no_beds_baths(false)
 square_feet0
 square_meters
 acres0
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size0
 icon_1views
 icon_2balcony-terrace
 icon_3beach-access
 icon_4
 icon_5
 icon_6
 websitehttp://theboutiquere.com/orange-county-real-estate/1677-thurston-laguna-beach-ca-92651/OC16031707/1495
 meta_titleMidcentury Ocean Views from Laguna Beach | Laguna Beach Real Estate | The Boutique Real Estate Group
 meta_description1677 Thurston is a property offered for sale in Laguna Beach, Ca, USA, presented by The Boutique Real Estate Group
 meta_keywords
 bathrooms_partial0
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built
 virtual_tourhttp://theboutiquere.com/orange-county-real-estate/1677-thurston-laguna-beach-ca-92651/OC16031707/1495
 video_tourhttp://theboutiquere.com/orange-county-real-estate/1677-thurston-laguna-beach-ca-92651/OC16031707/1495
 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
 latitude33.542892
 longitude-117.768982
 invalid_required_fieldslatitude, longitude
 invalid_optional_fieldsagent_2_id, square_feet, square_meters, acres, hectares, bathrooms_partial, year_built, wsj_property_type, nyt_property_type, propgolux_property_type, propgolux_property_style
 went_live_today(false)
 converted(true)
 invalid(false)
 mlsidx_full_address
 mlsidx_date_listed0000-00-00
 mls_market
 primary_property_category_id0
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated(null)
 modified2016-04-18 05:33:02
 created2016-02-21 05:43:58
 uri/property-detail/3465/1677-thurston-laguna-beach-ca-92651-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3465/1677-thurston-laguna-beach-ca-92651-usa
 address_concat1677 Thurston Laguna Beach Ca 92651 USA
 google_maps_query_string1677+Thurston++Laguna+Beach+Ca+92651+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 1,795,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty3
 bathrooms_pretty2
 bathrooms_partial_pretty0
 bathrooms_3_4_pretty0
 feed_full_bathrooms2
 date_listed2016-02-21
 overridden_brokerage_nameThe Boutique Real Estate Group
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id168
 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
 WOEID23417205
 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
 nameThe Boutique Real Estate Group
 broker_of_record_name
 short_nameThe Boutique Real Estate Group
 usernameTheBoutiqueRealEstate
 password01759fcc62fbf8022ef42c08f544e99731e7b5f6
 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
 descriptionThe Boutique Real Estate Group is the exclusive representative for Leverage Global Partners in Newport Beach, Corona Del Mar, Balboa Island, Newport Coast, Huntington Beach, Sunset Beach, CA, USA. The Boutique Real Estate Group is a boutique real estate brokerage founded in Orange County, CA, that focuses on brilliant design, beautiful marketing & luxury services and will be opening multiple offices throughout the Southern California Luxury Real Estate Market. The Boutique has created a culture that spurs collaboration, technology and social media with a unique marketing approach. Our story goes a little something like this. Beautiful design evokes emotion. Emotion stirs the soul and creates a connection between client, agent and the home buying & selling process. The Boutique Real Estate Group has invested heavily in bringing all aspects of the real estate experience completely in-house. From custom design, professional staging, amazing photography, cinematography & film production, social media to technology, internet optimization & cloud based transaction management. This not only provides The Boutique with complete control of the design, marketing & technology of luxury real estate but also gives us the look & feel of a true boutique marketing agency. This design & tech-forward approach has earned The Boutique Real Estate Group accolades & awards worldwide. 2015 Inman News Innovator Award for Most Innovative Technology | Nominee 2015 Top 33 People Changing The Real Estate Industry 2014 Best Real Estate Video of The Year 2014 Inman News Innovator Award for Most Innovative Real Estate Agent | Nominee 2014 Next Generation Real Estate Brokerage 2014 Top 100 Most Influential Real Estate Leaders in The USA 2013 Top 100 Most Influential Real Estate Leaders in The USA 2013 Top 20 Real Estate Videos in The USA
 communitiesNewport Beach Corona Del Mar Balboa Island Newport Coast Huntington Beach Sunset Beach
 websitehttp://www.theboutiquere.com/
 address3653 E. Coast Hwy
 address_2
 cityCorona Del Mar
 stateCA
 full_stateCalifornia
 countryUSA
 marketNewport Beach
 market_2
 postal_code
 phone(949) 612-2535
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameRaj Qsar
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/leverage-lifestyle/meet-raj-qsar-the-boutique-real-estate-group/
 contact_big_profile_link_textMeet Raj
 contact_titlePrincipal/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_filename168.jpg
 logo_filename168.jpg
 contact_image_filename168.jpg
 all_properties_link_image_filename168.jpg
 all_properties_linkhttp://www.theboutiquere.com/properties
 video_embed_code<script type="text/javascript" src="http://videocontent.jloop.com/players/xQ9ZyzIQ-qzxAOUo0.js"></script>
 contact_video_embed_code
 meta_titleNewport Beach Real Estate⎜The Boutique Real Estate Group⎜Leverage Global Partners
 meta_descriptionThe Boutique Real Estate Group is the exclusive representative for Leverage Global Partners in Newport Beach, CA, USA.
 meta_keywordsThe Boutique Real Estate Group, Raj Qsar, Newport Beach Real Estate, Corona Del Mar Real Estate, Balboa Island Real Estate, Newport Coast Real Estate, Huntington Beach Real Estate, Sunset Beach Real Estate, California Real Estate, 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-10-28 16:37:40
 modified2016-04-08 16:34:15
 dre_num012345
 uri/brokerage-detail/168/the-boutique-real-estate-group
 website_shortwww.theboutiquere.com
 name_with_locationThe Boutique Real Estate Group
 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)
 id13827
 modelProperty
 model_id3465
 tagImage
 name33621.jpg
 typeimage/jpg
 size487462
 uri/assets/13827.jpg
 order0
 created2016-04-07 16:42:02
 modified2016-04-15 04:22:02
 1(array)
 id13828
 modelProperty
 model_id3465
 tagImage
 name33622.jpg
 typeimage/jpg
 size337539
 uri/assets/13828.jpg
 order1
 created2016-04-07 16:42:02
 modified2016-04-15 04:22:02
 User(array)
 0(array)
 id1226
 typeAgent
 brokerage_id168
 email[email protected]
 password92e2ebc2bc354f30127ec2f9bb4a54332c4b5a59
 recover_hash
 first_nameTara
 last_nameLewicki
 title
 dre_num
 phone949-421-8668
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:59
 created2017-08-07 15:23:59
 notified(false)
 full_nameTara Lewicki
 uri/agent-detail/1226/tara-lewicki
 profile_complete(true)
 UsersProperty(array)
 id1054
 user_id1226
 property_id3465
 sort_order0
 SecondaryPropertyCategory(empty)
 PropertyFeature(array)
 0(array)
 id14
 nameViews
 additional(false)
 created2016-04-07 14:04:55
 modified2016-04-07 14:04:55
 PropertiesPropertyFeature(array)
 id2727
 property_id3465
 property_feature_id14
 1(array)
 id1
 nameBalcony/Terrace
 additional(false)
 created2016-04-07 14:00:26
 modified2016-04-07 14:00:26
 PropertiesPropertyFeature(array)
 id2728
 property_id3465
 property_feature_id1
 2(array)
 id2
 nameBeach Access
 additional(false)
 created2016-04-07 14:00:52
 modified2016-04-07 14:00:52
 PropertiesPropertyFeature(array)
 id2729
 property_id3465
 property_feature_id2
 Topic(empty)
 3(array)
 Property(array)
 id3236
 brokerage_id168
 created_by_user_id0
 order1
 multi_unit(false)
 agent_1_id1087
 agent_2_id0
 agent_3_id0
 nameLIVING LARGE IN RIVERSIDE
 incomplete(false)
 archived(false)
 last_archived0000-00-00 00:00:00
 auto_archived_from_mlsidx(false)
 paid_featured(false)
 featured(true)
 homepage_featured(true)
 brokerage_page_featured(true)
 requested_homepage_featured_by_member(false)
 homepage_featured_by_member(false)
 dot_luxury_featured(false)
 luxury_feed_featured(false)
 force_luxury_feed_featured(false)
 luxury_autofeed_imported(false)
 luxury_feed_last_added_time0000-00-00 00:00:00
 luxury_feed_agent_user_id0
 luxury_feed_locked_to_subscription_id0
 luxury_feed_agent_purchase_date0000-00-00
 luxury_feed_agent_expiration_date0000-00-00
 digital_ad_summary_email_last_sent0000-00-00 00:00:00
 digital_ad_summary_price_changed(false)
 wsj_detail_url
 ft_detail_url
 nyt_detail_url
 juwai_detail_url
 pgl_detail_url
 mg_detail_url
 mg_c_detail_url
 mg_s_detail_url
 bp_detail_url
 mw_detail_url
 nikkei_detail_url
 wapo_detail_url
 robb_detail_url
 medium_featured(true)
 large_featured(true)
 detail_page(true)
 descriptionTucked Away Deep Within Arlington Heights, Riverside Most Secluded And Prestigious Property Located at 2085 Kitchener St., The Estate Sits on 12.62 Acres of a Working Tropical Fruit Orchards that Harvest Guava, Dragon Fruits, Chinese Apples, and Kaffir Lime Leaves. The Estate Boasted Over 12,000sf of Living Space with 8 Bedrooms + Office + Game/Home Theater, Front and Rear Balcony With Baluster, 9 Bathrooms, Gourmet Chef's Kitchen with Viking Appliances, 6 Burners With Griddle, Double Oven, Extra Wide Refrigerator, Granite Slab Island and Counters. Qualify Wood Cabinets, Breakfast Nook, Formal Dining Room, Dual Master Bedroom, 2nd Floor Master Bedroom + Retreat Area, Dual Fireplace, Glass Standing Shower, Oval Jacuzzi Spa Tub, Marble Countertops, Family Room With Coffered Ceiling and Marble Fireplace, Family Room with 25 feet Ceiling, Travertine Tiles throughout Low Floor, Wood Flooring throughout 2nd Floor, Whole House Audio/Video Wiring, Six Cars Garage, Custom Koi Pond, Roof Top Solar Est. Annual Production Rate 13,548 kWh. Spacious Courtyard And Private Gated Entry. 
 address2085 Kitchener St
 address_2
 cityRiverside
 stateCa
 postal_code92504
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price5500000
 price_20
 price_usd5500000
 price_usd_20
 statusFor Sale
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(false)
 bedrooms6
 bedrooms_20
 bathrooms8
 bathrooms_20
 no_beds_baths(false)
 square_feet0
 square_meters
 acres12
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size12
 icon_1acreage
 icon_2guest-house
 icon_3vineyard
 icon_4media-room
 icon_5library
 icon_6garage
 websitehttp://2085kitchenerst.com/
 meta_titleLIVING LARGE IN RIVERSIDE | Riverside Real Estate | The Boutique Real Estate Group
 meta_description2085 Kitchener St is a property offered for sale in Riverside, Ca, USA, presented by The Boutique Real Estate Group
 meta_keywords
 bathrooms_partial0
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built
 virtual_tourhttp://theboutiquere.com/our-real-estate/2085-kitchener-st-riverside-ca-92504/OC15265291/1471
 video_tour
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num
 wsj_property_type
 nyt_property_type
 nyt_popular_features
 propgolux_property_type
 juwai_property_type
 juwai_category
 propgolux_property_style
 wapo_property_type
 robb_property_type
 propgolux_location_id_override
 open_house_1_start0000-00-00 00:00:00
 open_house_1_end_time00:00:00
 latitude0.000000
 longitude0.000000
 invalid_required_fieldslatitude, longitude
 invalid_optional_fieldsagent_2_id, square_feet, square_meters, hectares, bathrooms_partial, year_built, video_tour, wsj_property_type, nyt_property_type, propgolux_property_type, propgolux_property_style
 went_live_today(false)
 converted(true)
 invalid(false)
 mlsidx_full_address
 mlsidx_date_listed0000-00-00
 mls_market
 primary_property_category_id0
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated(null)
 modified2016-04-18 05:33:02
 created2015-12-27 06:12:12
 uri/property-detail/3236/2085-kitchener-st-riverside-ca-92504-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3236/2085-kitchener-st-riverside-ca-92504-usa
 address_concat2085 Kitchener St Riverside Ca 92504 USA
 google_maps_query_string2085+Kitchener+St++Riverside+Ca+92504+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 5,500,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty6
 bathrooms_pretty8
 bathrooms_partial_pretty0
 bathrooms_3_4_pretty0
 feed_full_bathrooms8
 date_listed2015-12-27
 overridden_brokerage_nameThe Boutique Real Estate Group
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id168
 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
 WOEID23417205
 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
 nameThe Boutique Real Estate Group
 broker_of_record_name
 short_nameThe Boutique Real Estate Group
 usernameTheBoutiqueRealEstate
 password01759fcc62fbf8022ef42c08f544e99731e7b5f6
 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
 descriptionThe Boutique Real Estate Group is the exclusive representative for Leverage Global Partners in Newport Beach, Corona Del Mar, Balboa Island, Newport Coast, Huntington Beach, Sunset Beach, CA, USA. The Boutique Real Estate Group is a boutique real estate brokerage founded in Orange County, CA, that focuses on brilliant design, beautiful marketing & luxury services and will be opening multiple offices throughout the Southern California Luxury Real Estate Market. The Boutique has created a culture that spurs collaboration, technology and social media with a unique marketing approach. Our story goes a little something like this. Beautiful design evokes emotion. Emotion stirs the soul and creates a connection between client, agent and the home buying & selling process. The Boutique Real Estate Group has invested heavily in bringing all aspects of the real estate experience completely in-house. From custom design, professional staging, amazing photography, cinematography & film production, social media to technology, internet optimization & cloud based transaction management. This not only provides The Boutique with complete control of the design, marketing & technology of luxury real estate but also gives us the look & feel of a true boutique marketing agency. This design & tech-forward approach has earned The Boutique Real Estate Group accolades & awards worldwide. 2015 Inman News Innovator Award for Most Innovative Technology | Nominee 2015 Top 33 People Changing The Real Estate Industry 2014 Best Real Estate Video of The Year 2014 Inman News Innovator Award for Most Innovative Real Estate Agent | Nominee 2014 Next Generation Real Estate Brokerage 2014 Top 100 Most Influential Real Estate Leaders in The USA 2013 Top 100 Most Influential Real Estate Leaders in The USA 2013 Top 20 Real Estate Videos in The USA
 communitiesNewport Beach Corona Del Mar Balboa Island Newport Coast Huntington Beach Sunset Beach
 websitehttp://www.theboutiquere.com/
 address3653 E. Coast Hwy
 address_2
 cityCorona Del Mar
 stateCA
 full_stateCalifornia
 countryUSA
 marketNewport Beach
 market_2
 postal_code
 phone(949) 612-2535
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameRaj Qsar
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/leverage-lifestyle/meet-raj-qsar-the-boutique-real-estate-group/
 contact_big_profile_link_textMeet Raj
 contact_titlePrincipal/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_filename168.jpg
 logo_filename168.jpg
 contact_image_filename168.jpg
 all_properties_link_image_filename168.jpg
 all_properties_linkhttp://www.theboutiquere.com/properties
 video_embed_code<script type="text/javascript" src="http://videocontent.jloop.com/players/xQ9ZyzIQ-qzxAOUo0.js"></script>
 contact_video_embed_code
 meta_titleNewport Beach Real Estate⎜The Boutique Real Estate Group⎜Leverage Global Partners
 meta_descriptionThe Boutique Real Estate Group is the exclusive representative for Leverage Global Partners in Newport Beach, CA, USA.
 meta_keywordsThe Boutique Real Estate Group, Raj Qsar, Newport Beach Real Estate, Corona Del Mar Real Estate, Balboa Island Real Estate, Newport Coast Real Estate, Huntington Beach Real Estate, Sunset Beach Real Estate, California Real Estate, 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-10-28 16:37:40
 modified2016-04-08 16:34:15
 dre_num012345
 uri/brokerage-detail/168/the-boutique-real-estate-group
 website_shortwww.theboutiquere.com
 name_with_locationThe Boutique Real Estate Group
 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)
 id17948
 modelProperty
 model_id3236
 tagImage
 name31322.jpg
 typeimage/jpg
 size675145
 uri/assets/17948.jpg
 order0
 created2016-04-07 17:07:04
 modified2016-04-07 17:07:04
 1(array)
 id17947
 modelProperty
 model_id3236
 tagImage
 name31323.jpg
 typeimage/jpg
 size798463
 uri/assets/17947.jpg
 order1
 created2016-04-07 17:07:04
 modified2016-04-07 17:07:04
 2(array)
 id17945
 modelProperty
 model_id3236
 tagImage
 name31324.jpg
 typeimage/jpg
 size713337
 uri/assets/17945.jpg
 order2
 created2016-04-07 17:07:04
 modified2016-04-07 17:07:04
 3(array)
 id17944
 modelProperty
 model_id3236
 tagImage
 name31325.jpg
 typeimage/jpg
 size492258
 uri/assets/17944.jpg
 order3
 created2016-04-07 17:07:04
 modified2016-04-07 17:07:04
 4(array)
 id17943
 modelProperty
 model_id3236
 tagImage
 name31326.jpg
 typeimage/jpg
 size685076
 uri/assets/17943.jpg
 order4
 created2016-04-07 17:07:04
 modified2016-04-07 17:07:04
 5(array)
 id17942
 modelProperty
 model_id3236
 tagImage
 name31327.jpg
 typeimage/jpg
 size501810
 uri/assets/17942.jpg
 order5
 created2016-04-07 17:07:04
 modified2016-04-07 17:07:04
 6(array)
 id17941
 modelProperty
 model_id3236
 tagImage
 name31328.jpg
 typeimage/jpg
 size618940
 uri/assets/17941.jpg
 order6
 created2016-04-07 17:07:04
 modified2016-04-07 17:07:04
 7(array)
 id17946
 modelProperty
 model_id3236
 tagImage
 name31329.jpg
 typeimage/jpg
 size854764
 uri/assets/17946.jpg
 order7
 created2016-04-07 17:07:04
 modified2016-04-07 17:07:04
 User(empty)
 SecondaryPropertyCategory(empty)
 PropertyFeature(array)
 0(array)
 id5
 nameGuest House
 additional(false)
 created2016-04-07 14:02:13
 modified2016-04-07 14:02:13
 PropertiesPropertyFeature(array)
 id3772
 property_id3236
 property_feature_id5
 1(array)
 id15
 nameVineyard
 additional(false)
 created2016-04-07 14:05:15
 modified2016-04-07 14:05:15
 PropertiesPropertyFeature(array)
 id3773
 property_id3236
 property_feature_id15
 2(array)
 id8
 nameMedia Room
 additional(false)
 created2016-04-07 14:03:04
 modified2016-04-07 14:03:04
 PropertiesPropertyFeature(array)
 id3774
 property_id3236
 property_feature_id8
 3(array)
 id4
 nameGarage
 additional(false)
 created2016-04-07 14:01:52
 modified2016-04-07 14:01:52
 PropertiesPropertyFeature(array)
 id3775
 property_id3236
 property_feature_id4
 Topic(empty)
- sidebar_locations(array)
 0(array)
 Location(array)
 id83
 parent_id9
 brokerage_id168
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameNewport Beach, CA, USA
 short_nameNewport Beach, CA, USA
 group_index
 latitude33.599182
 longitude-117.872169
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_descriptionCelebrated as an alluring destination, Orange County’s beauty is more than skin deep.
 long_descriptionFrom sunset bike rides along the beach on a warm, summer evening to a quick winter weekend adventure in the mountains. From the alluring artwork of the hottest artists displayed in Laguna Beach, to the Village of Corona del Mar which offers amazing shopping in their seaside boutiques, to the historical architecture of Old Towne Orange and the history of US Presidents in Yorba Linda. Whether you choose a cozy beach bungalow or a custom estate built for a celebrity, there is a place here for everyone to call home. Known the world over as an alluring travel destination, the locals who are lucky enough to call Orange County “home” know that the beauty here is more than skin deep.
 created2016-04-05 10:17:09
 modified2016-04-18 10:38:04
 timezoneAmerica/Los_Angeles
 population3500000
 uri/locations/view/83/newport-beach-ca-usa
 tile_nameNewport Beach, CA, USA
 Brokerage(array)
 id168
 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
 WOEID23417205
 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
 nameThe Boutique Real Estate Group
 broker_of_record_name
 short_nameThe Boutique Real Estate Group
 usernameTheBoutiqueRealEstate
 password01759fcc62fbf8022ef42c08f544e99731e7b5f6
 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
 descriptionThe Boutique Real Estate Group is the exclusive representative for Leverage Global Partners in Newport Beach, Corona Del Mar, Balboa Island, Newport Coast, Huntington Beach, Sunset Beach, CA, USA. The Boutique Real Estate Group is a boutique real estate brokerage founded in Orange County, CA, that focuses on brilliant design, beautiful marketing & luxury services and will be opening multiple offices throughout the Southern California Luxury Real Estate Market. The Boutique has created a culture that spurs collaboration, technology and social media with a unique marketing approach. Our story goes a little something like this. Beautiful design evokes emotion. Emotion stirs the soul and creates a connection between client, agent and the home buying & selling process. The Boutique Real Estate Group has invested heavily in bringing all aspects of the real estate experience completely in-house. From custom design, professional staging, amazing photography, cinematography & film production, social media to technology, internet optimization & cloud based transaction management. This not only provides The Boutique with complete control of the design, marketing & technology of luxury real estate but also gives us the look & feel of a true boutique marketing agency. This design & tech-forward approach has earned The Boutique Real Estate Group accolades & awards worldwide. 2015 Inman News Innovator Award for Most Innovative Technology | Nominee 2015 Top 33 People Changing The Real Estate Industry 2014 Best Real Estate Video of The Year 2014 Inman News Innovator Award for Most Innovative Real Estate Agent | Nominee 2014 Next Generation Real Estate Brokerage 2014 Top 100 Most Influential Real Estate Leaders in The USA 2013 Top 100 Most Influential Real Estate Leaders in The USA 2013 Top 20 Real Estate Videos in The USA
 communitiesNewport Beach Corona Del Mar Balboa Island Newport Coast Huntington Beach Sunset Beach
 websitehttp://www.theboutiquere.com/
 address3653 E. Coast Hwy
 address_2
 cityCorona Del Mar
 stateCA
 full_stateCalifornia
 countryUSA
 marketNewport Beach
 market_2
 postal_code
 phone(949) 612-2535
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameRaj Qsar
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/leverage-lifestyle/meet-raj-qsar-the-boutique-real-estate-group/
 contact_big_profile_link_textMeet Raj
 contact_titlePrincipal/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_filename168.jpg
 logo_filename168.jpg
 contact_image_filename168.jpg
 all_properties_link_image_filename168.jpg
 all_properties_linkhttp://www.theboutiquere.com/properties
 video_embed_code<script type="text/javascript" src="http://videocontent.jloop.com/players/xQ9ZyzIQ-qzxAOUo0.js"></script>
 contact_video_embed_code
 meta_titleNewport Beach Real Estate⎜The Boutique Real Estate Group⎜Leverage Global Partners
 meta_descriptionThe Boutique Real Estate Group is the exclusive representative for Leverage Global Partners in Newport Beach, CA, USA.
 meta_keywordsThe Boutique Real Estate Group, Raj Qsar, Newport Beach Real Estate, Corona Del Mar Real Estate, Balboa Island Real Estate, Newport Coast Real Estate, Huntington Beach Real Estate, Sunset Beach Real Estate, California Real Estate, 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-10-28 16:37:40
 modified2016-04-08 16:34:15
 dre_num012345
 uri/brokerage-detail/168/the-boutique-real-estate-group
 website_shortwww.theboutiquere.com
 name_with_locationThe Boutique Real Estate Group
 Image(array)
 id3017
 modelLocation
 model_id83
 tagImage
 name39922990_aerial-beach.jpg
 typeimage/jpeg
 size14013480
 uri/assets/3017.jpg
 order0
 created2016-04-05 10:15:06
 modified2016-04-18 10:38:04
- highlighted_properties(array)
 0(array)
 Property(array)
 id3648
 brokerage_id168
 created_by_user_id0
 order2
 multi_unit(false)
 agent_1_id55
 agent_2_id64
 agent_3_id0
 nameTHE GOOD LIFE IN THE COUNTRY
 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)
 descriptionThe estates dotting the hilltops in Europe provided the stimulus for this custom built residence nestled into the hillside of this Southern California guard gated community known as The County in Diamond Bar. 3015 Steeplechase Drive is a thoughtful compilation of horizontal building forms, brick elements and detailed accents which remind you of a quaint European village. This ultra-private 2 acre view lot features a professional lighted tennis court, mini-golf driving range, pool, spa, outdoor BBQ & guest house. Approx 5,000 sq ft of Living Space (main house is approximately 4,200 sq ft and guest house is approximately 800 sq ft), six total bedrooms, 5 total bathrooms & large circular driveway leading to your 3 car attached garage. Gourmet kitchen with granite counters, stainless steel appliances and views overlooking the pool. Downstairs office with its own bathroom easily converts to a downstairs bedroom. Natural light fills the formal living & dining room and showcases massive 20+ foot ceilings and brick laden fireplace. Take advantage of gorgeous sunsets off the back balcony which overlooks the entire estate. The free standing guest house features its own entry, bedroom, full bathroom, family room, kitchen, laundry room & looks out over the backyard.
 address3015 Steeplechase Lane
 address_2
 cityDiamond Bar
 stateCA
 postal_code91765
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price2999888
 price_20
 price_usd2999888
 price_usd_20
 statusFor Sale
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(false)
 bedrooms6
 bedrooms_20
 bathrooms5
 bathrooms_20
 no_beds_baths(false)
 square_feet5000
 square_meters
 acres0
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size0
 icon_1pool
 icon_2sq-ft
 icon_3views
 icon_4guest-house
 icon_5
 icon_6
 websitehttp://theboutiquere.com/los-angeles-real-estate/3015---steeplechase--lane-diamond-bar-ca-91765/PW16063942/1604
 meta_titleTHE GOOD LIFE IN THE COUNTRY | Diamond Bar Real Estate | The Boutique Real Estate Group
 meta_description3015 Steeplechase Lane is a property offered for sale in Diamond Bar, CA, USA, presented by The Boutique Real Estate Group
 meta_keywords
 bathrooms_partial0
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built
 virtual_tourhttp://3015steeplechaseln.com/
 video_tourhttps://youtu.be/AkqDYx9RlUc
 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
 latitude33.970512
 longitude-117.834480
 invalid_required_fields
 invalid_optional_fieldsbathrooms_partial, square_meters, acres, hectares
 went_live_today(false)
 converted(true)
 invalid(false)
 mlsidx_full_address
 mlsidx_date_listed0000-00-00
 mls_market
 primary_property_category_id0
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated(null)
 modified2016-04-18 05:33:03
 created2016-03-29 23:24:29
 uri/property-detail/3648/3015-steeplechase-lane-diamond-bar-ca-91765-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3648/3015-steeplechase-lane-diamond-bar-ca-91765-usa
 address_concat3015 Steeplechase Lane Diamond Bar CA 91765 USA
 google_maps_query_string3015+Steeplechase+Lane++Diamond+Bar+CA+91765+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 2,999,888
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty6
 bathrooms_pretty5
 bathrooms_partial_pretty0
 bathrooms_3_4_pretty0
 feed_full_bathrooms5
 date_listed2016-03-29
 overridden_brokerage_nameThe Boutique Real Estate Group
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id168
 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
 WOEID23417205
 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
 nameThe Boutique Real Estate Group
 broker_of_record_name
 short_nameThe Boutique Real Estate Group
 usernameTheBoutiqueRealEstate
 password01759fcc62fbf8022ef42c08f544e99731e7b5f6
 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
 descriptionThe Boutique Real Estate Group is the exclusive representative for Leverage Global Partners in Newport Beach, Corona Del Mar, Balboa Island, Newport Coast, Huntington Beach, Sunset Beach, CA, USA. The Boutique Real Estate Group is a boutique real estate brokerage founded in Orange County, CA, that focuses on brilliant design, beautiful marketing & luxury services and will be opening multiple offices throughout the Southern California Luxury Real Estate Market. The Boutique has created a culture that spurs collaboration, technology and social media with a unique marketing approach. Our story goes a little something like this. Beautiful design evokes emotion. Emotion stirs the soul and creates a connection between client, agent and the home buying & selling process. The Boutique Real Estate Group has invested heavily in bringing all aspects of the real estate experience completely in-house. From custom design, professional staging, amazing photography, cinematography & film production, social media to technology, internet optimization & cloud based transaction management. This not only provides The Boutique with complete control of the design, marketing & technology of luxury real estate but also gives us the look & feel of a true boutique marketing agency. This design & tech-forward approach has earned The Boutique Real Estate Group accolades & awards worldwide. 2015 Inman News Innovator Award for Most Innovative Technology | Nominee 2015 Top 33 People Changing The Real Estate Industry 2014 Best Real Estate Video of The Year 2014 Inman News Innovator Award for Most Innovative Real Estate Agent | Nominee 2014 Next Generation Real Estate Brokerage 2014 Top 100 Most Influential Real Estate Leaders in The USA 2013 Top 100 Most Influential Real Estate Leaders in The USA 2013 Top 20 Real Estate Videos in The USA
 communitiesNewport Beach Corona Del Mar Balboa Island Newport Coast Huntington Beach Sunset Beach
 websitehttp://www.theboutiquere.com/
 address3653 E. Coast Hwy
 address_2
 cityCorona Del Mar
 stateCA
 full_stateCalifornia
 countryUSA
 marketNewport Beach
 market_2
 postal_code
 phone(949) 612-2535
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameRaj Qsar
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/leverage-lifestyle/meet-raj-qsar-the-boutique-real-estate-group/
 contact_big_profile_link_textMeet Raj
 contact_titlePrincipal/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_filename168.jpg
 logo_filename168.jpg
 contact_image_filename168.jpg
 all_properties_link_image_filename168.jpg
 all_properties_linkhttp://www.theboutiquere.com/properties
 video_embed_code<script type="text/javascript" src="http://videocontent.jloop.com/players/xQ9ZyzIQ-qzxAOUo0.js"></script>
 contact_video_embed_code
 meta_titleNewport Beach Real Estate⎜The Boutique Real Estate Group⎜Leverage Global Partners
 meta_descriptionThe Boutique Real Estate Group is the exclusive representative for Leverage Global Partners in Newport Beach, CA, USA.
 meta_keywordsThe Boutique Real Estate Group, Raj Qsar, Newport Beach Real Estate, Corona Del Mar Real Estate, Balboa Island Real Estate, Newport Coast Real Estate, Huntington Beach Real Estate, Sunset Beach Real Estate, California Real Estate, 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-10-28 16:37:40
 modified2016-04-08 16:34:15
 dre_num012345
 uri/brokerage-detail/168/the-boutique-real-estate-group
 website_shortwww.theboutiquere.com
 name_with_locationThe Boutique Real Estate Group
 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)
 id20280
 modelProperty
 model_id3648
 tagImage
 name35561.jpg
 typeimage/jpg
 size1103248
 uri/assets/20280.jpg
 order0
 created2016-04-07 17:26:56
 modified2016-04-15 04:21:20
 1(array)
 id20277
 modelProperty
 model_id3648
 tagImage
 name35558.jpg
 typeimage/jpg
 size1201040
 uri/assets/20277.jpg
 order1
 created2016-04-07 17:26:56
 modified2016-04-15 04:21:20
 2(array)
 id20281
 modelProperty
 model_id3648
 tagImage
 name35562.jpg
 typeimage/jpg
 size821869
 uri/assets/20281.jpg
 order2
 created2016-04-07 17:26:56
 modified2016-04-15 04:21:20
 3(array)
 id20282
 modelProperty
 model_id3648
 tagImage
 name35563.jpg
 typeimage/jpg
 size699457
 uri/assets/20282.jpg
 order3
 created2016-04-07 17:26:56
 modified2016-04-15 04:21:20
 4(array)
 id20283
 modelProperty
 model_id3648
 tagImage
 name35564.jpg
 typeimage/jpg
 size838355
 uri/assets/20283.jpg
 order4
 created2016-04-07 17:26:56
 modified2016-04-15 04:21:20
 5(array)
 id20284
 modelProperty
 model_id3648
 tagImage
 name35565.jpg
 typeimage/jpg
 size669052
 uri/assets/20284.jpg
 order5
 created2016-04-07 17:26:56
 modified2016-04-15 04:21:20
 6(array)
 id20279
 modelProperty
 model_id3648
 tagImage
 name35560.jpg
 typeimage/jpg
 size802258
 uri/assets/20279.jpg
 order6
 created2016-04-07 17:26:56
 modified2016-04-15 04:21:20
 7(array)
 id20278
 modelProperty
 model_id3648
 tagImage
 name35559.jpg
 typeimage/jpg
 size1000013
 uri/assets/20278.jpg
 order7
 created2016-04-07 17:26:56
 modified2016-04-15 04:21:20
 User(empty)
 SecondaryPropertyCategory(empty)
 PropertyFeature(array)
 0(array)
 id12
 nameSwimming Pool
 additional(false)
 created2016-04-07 14:04:12
 modified2016-04-07 14:04:12
 PropertiesPropertyFeature(array)
 id4294
 property_id3648
 property_feature_id12
 1(array)
 id14
 nameViews
 additional(false)
 created2016-04-07 14:04:55
 modified2016-04-07 14:04:55
 PropertiesPropertyFeature(array)
 id4295
 property_id3648
 property_feature_id14
 2(array)
 id5
 nameGuest House
 additional(false)
 created2016-04-07 14:02:13
 modified2016-04-07 14:02:13
 PropertiesPropertyFeature(array)
 id4296
 property_id3648
 property_feature_id5
 Topic(empty)
 1(array)
 Property(array)
 id3403
 brokerage_id168
 created_by_user_id0
 order0
 multi_unit(false)
 agent_1_id908
 agent_2_id1146
 agent_3_id0
 nameLife in Laguna Beach
 incomplete(false)
 archived(false)
 last_archived0000-00-00 00:00:00
 auto_archived_from_mlsidx(false)
 paid_featured(false)
 featured(true)
 homepage_featured(true)
 brokerage_page_featured(true)
 requested_homepage_featured_by_member(false)
 homepage_featured_by_member(false)
 dot_luxury_featured(false)
 luxury_feed_featured(false)
 force_luxury_feed_featured(false)
 luxury_autofeed_imported(false)
 luxury_feed_last_added_time0000-00-00 00:00:00
 luxury_feed_agent_user_id0
 luxury_feed_locked_to_subscription_id0
 luxury_feed_agent_purchase_date0000-00-00
 luxury_feed_agent_expiration_date0000-00-00
 digital_ad_summary_email_last_sent0000-00-00 00:00:00
 digital_ad_summary_price_changed(false)
 wsj_detail_url
 ft_detail_url
 nyt_detail_url
 juwai_detail_url
 pgl_detail_url
 mg_detail_url
 mg_c_detail_url
 mg_s_detail_url
 bp_detail_url
 mw_detail_url
 nikkei_detail_url
 wapo_detail_url
 robb_detail_url
 medium_featured(true)
 large_featured(true)
 detail_page(true)
 descriptionSoaring over Laguna Beach on its own promontory, this contemporary estate encompasses approximately 10,200 square feet of living space and sits on nearly one acre. Inspired by luxury 5-star island resorts, thistruly magnificent home offers an indoor-outdoor open floor plan, amazing kitchen + caterer's kitchen, professional recording studio, wine room, tasting room, and unrivaled panoramic ocean and canyon views from virtually every room. The entire home is showcased with custom designer details including light fixtures, imported European oak, walnut and stone. The serene, tropical resort ambiance transitions seamlessly to the outdoors with amenities including a custom saline pool with swim-up bar, 10-person spa, large entertaining cabana, two kitchens, and pool house with shower/steam room, making this the ultimate entertaining compound. The private, gated entry and driveway leads to the 7-car garage with turn around to accommodate 8 additional vehicles.
 address1000 Flamingo Rd
 address_2
 cityLaguna Beach
 stateCa
 postal_code92651
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price19888888
 price_20
 price_usd19888888
 price_usd_20
 statusFor Sale
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(false)
 bedrooms5
 bedrooms_20
 bathrooms2
 bathrooms_20
 no_beds_baths(false)
 square_feet0
 square_meters
 acres0
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size0
 icon_1pool
 icon_2gym
 icon_3views
 icon_4cellar
 icon_5
 icon_6
 websitehttp://theboutiquere.com/orange-county-real-estate/1000-flamingo-rd-laguna-beach-ca-92651/1488
 meta_titleLife in Laguna Beach | Laguna Beach Real Estate | The Boutique Real Estate Group
 meta_description1000 Flamingo Rd is a property offered for sale in Laguna Beach, Ca, USA, presented by The Boutique Real Estate Group
 meta_keywords
 bathrooms_partial3
 bathrooms_partial_20
 bathrooms_3_44
 bathrooms_3_4_20
 year_built
 virtual_tourhttp://theboutiquere.com/orange-county-real-estate/1000-flamingo-rd-laguna-beach-ca-92651/1488
 video_tourhttps://youtu.be/e1LuDqy_Ddo
 digital_brochure
 video_tour_embed_codehttps://www.youtube.com/embed/e1LuDqy_Ddo
 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
 latitude33.538269
 longitude-117.766342
 invalid_required_fieldslatitude, longitude
 invalid_optional_fieldssquare_feet, square_meters, acres, hectares, year_built, wsj_property_type, nyt_property_type, propgolux_property_type, propgolux_property_style
 went_live_today(false)
 converted(true)
 invalid(false)
 mlsidx_full_address
 mlsidx_date_listed0000-00-00
 mls_market
 primary_property_category_id0
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated(null)
 modified2016-04-18 05:33:03
 created2016-02-06 19:20:38
 uri/property-detail/3403/1000-flamingo-rd-laguna-beach-ca-92651-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3403/1000-flamingo-rd-laguna-beach-ca-92651-usa
 address_concat1000 Flamingo Rd Laguna Beach Ca 92651 USA
 google_maps_query_string1000+Flamingo+Rd++Laguna+Beach+Ca+92651+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 19,888,888
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty5
 bathrooms_pretty2
 bathrooms_partial_pretty3
 bathrooms_3_4_pretty4
 feed_full_bathrooms6
 date_listed2016-02-06
 overridden_brokerage_nameThe Boutique Real Estate Group
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id168
 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
 WOEID23417205
 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
 nameThe Boutique Real Estate Group
 broker_of_record_name
 short_nameThe Boutique Real Estate Group
 usernameTheBoutiqueRealEstate
 password01759fcc62fbf8022ef42c08f544e99731e7b5f6
 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
 descriptionThe Boutique Real Estate Group is the exclusive representative for Leverage Global Partners in Newport Beach, Corona Del Mar, Balboa Island, Newport Coast, Huntington Beach, Sunset Beach, CA, USA. The Boutique Real Estate Group is a boutique real estate brokerage founded in Orange County, CA, that focuses on brilliant design, beautiful marketing & luxury services and will be opening multiple offices throughout the Southern California Luxury Real Estate Market. The Boutique has created a culture that spurs collaboration, technology and social media with a unique marketing approach. Our story goes a little something like this. Beautiful design evokes emotion. Emotion stirs the soul and creates a connection between client, agent and the home buying & selling process. The Boutique Real Estate Group has invested heavily in bringing all aspects of the real estate experience completely in-house. From custom design, professional staging, amazing photography, cinematography & film production, social media to technology, internet optimization & cloud based transaction management. This not only provides The Boutique with complete control of the design, marketing & technology of luxury real estate but also gives us the look & feel of a true boutique marketing agency. This design & tech-forward approach has earned The Boutique Real Estate Group accolades & awards worldwide. 2015 Inman News Innovator Award for Most Innovative Technology | Nominee 2015 Top 33 People Changing The Real Estate Industry 2014 Best Real Estate Video of The Year 2014 Inman News Innovator Award for Most Innovative Real Estate Agent | Nominee 2014 Next Generation Real Estate Brokerage 2014 Top 100 Most Influential Real Estate Leaders in The USA 2013 Top 100 Most Influential Real Estate Leaders in The USA 2013 Top 20 Real Estate Videos in The USA
 communitiesNewport Beach Corona Del Mar Balboa Island Newport Coast Huntington Beach Sunset Beach
 websitehttp://www.theboutiquere.com/
 address3653 E. Coast Hwy
 address_2
 cityCorona Del Mar
 stateCA
 full_stateCalifornia
 countryUSA
 marketNewport Beach
 market_2
 postal_code
 phone(949) 612-2535
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameRaj Qsar
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/leverage-lifestyle/meet-raj-qsar-the-boutique-real-estate-group/
 contact_big_profile_link_textMeet Raj
 contact_titlePrincipal/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_filename168.jpg
 logo_filename168.jpg
 contact_image_filename168.jpg
 all_properties_link_image_filename168.jpg
 all_properties_linkhttp://www.theboutiquere.com/properties
 video_embed_code<script type="text/javascript" src="http://videocontent.jloop.com/players/xQ9ZyzIQ-qzxAOUo0.js"></script>
 contact_video_embed_code
 meta_titleNewport Beach Real Estate⎜The Boutique Real Estate Group⎜Leverage Global Partners
 meta_descriptionThe Boutique Real Estate Group is the exclusive representative for Leverage Global Partners in Newport Beach, CA, USA.
 meta_keywordsThe Boutique Real Estate Group, Raj Qsar, Newport Beach Real Estate, Corona Del Mar Real Estate, Balboa Island Real Estate, Newport Coast Real Estate, Huntington Beach Real Estate, Sunset Beach Real Estate, California Real Estate, 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-10-28 16:37:40
 modified2016-04-08 16:34:15
 dre_num012345
 uri/brokerage-detail/168/the-boutique-real-estate-group
 website_shortwww.theboutiquere.com
 name_with_locationThe Boutique Real Estate Group
 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)
 id19164
 modelProperty
 model_id3403
 tagImage
 name33594.png
 typeimage/png
 size3489588
 uri/assets/19164.png
 order0
 created2016-04-07 17:14:04
 modified2016-04-15 04:21:34
 1(array)
 id19158
 modelProperty
 model_id3403
 tagImage
 name33628.jpg
 typeimage/jpg
 size457170
 uri/assets/19158.jpg
 order1
 created2016-04-07 17:14:04
 modified2016-04-15 04:21:34
 2(array)
 id19159
 modelProperty
 model_id3403
 tagImage
 name33627.jpg
 typeimage/jpg
 size400752
 uri/assets/19159.jpg
 order2
 created2016-04-07 17:14:04
 modified2016-04-15 04:21:34
 3(array)
 id19161
 modelProperty
 model_id3403
 tagImage
 name33625.jpg
 typeimage/jpg
 size427955
 uri/assets/19161.jpg
 order3
 created2016-04-07 17:14:04
 modified2016-04-15 04:21:34
 4(array)
 id19162
 modelProperty
 model_id3403
 tagImage
 name33624.jpg
 typeimage/jpg
 size419721
 uri/assets/19162.jpg
 order4
 created2016-04-07 17:14:04
 modified2016-04-15 04:21:34
 5(array)
 id19163
 modelProperty
 model_id3403
 tagImage
 name33623.jpg
 typeimage/jpg
 size498254
 uri/assets/19163.jpg
 order5
 created2016-04-07 17:14:04
 modified2016-04-15 04:21:34
 6(array)
 id19160
 modelProperty
 model_id3403
 tagImage
 name33626.jpg
 typeimage/jpg
 size435412
 uri/assets/19160.jpg
 order6
 created2016-04-07 17:14:04
 modified2016-04-15 04:21:34
 7(array)
 id19157
 modelProperty
 model_id3403
 tagImage
 name33629.jpg
 typeimage/jpg
 size548511
 uri/assets/19157.jpg
 order7
 created2016-04-07 17:14:04
 modified2016-04-15 04:21:34
 User(array)
 0(array)
 id1080
 typeAgent
 brokerage_id168
 email[email protected]
 password898a1e2eb462d8b3a4d7f8efc251c09ba09d32b7
 recover_hash
 first_nameTracy
 last_nameGlass
 title
 dre_num
 phone949-424-6363
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:52
 created2017-08-07 15:23:52
 notified(false)
 full_nameTracy Glass
 uri/agent-detail/1080/tracy-glass
 profile_complete(true)
 UsersProperty(array)
 id837
 user_id1080
 property_id3403
 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)
 id4081
 property_id3403
 property_feature_id12
 1(array)
 id6
 nameGym
 additional(false)
 created2016-04-07 14:02:29
 modified2016-04-07 14:02:29
 PropertiesPropertyFeature(array)
 id4082
 property_id3403
 property_feature_id6
 2(array)
 id14
 nameViews
 additional(false)
 created2016-04-07 14:04:55
 modified2016-04-07 14:04:55
 PropertiesPropertyFeature(array)
 id4083
 property_id3403
 property_feature_id14
 3(array)
 id18
 nameWine Cellar
 additional(false)
 created2016-04-07 14:06:17
 modified2016-04-07 14:06:17
 PropertiesPropertyFeature(array)
 id4084
 property_id3403
 property_feature_id18
 Topic(array)
 0(array)
 id4
 nameKiller Views
 created2016-02-25 11:25:00
 modified2016-02-25 11:33:10
 tile_nameKiller Views
 PropertiesTopic(array)
 id28
 property_id3403
 topic_id4
 1(array)
 id8
 nameBeach
 created2016-02-25 11:25:00
 modified2016-02-25 11:30:26
 tile_nameBeach
 PropertiesTopic(array)
 id29
 property_id3403
 topic_id8
 2(array)
 id12
 nameModern Architecture
 created2016-02-25 11:25:00
 modified2016-02-25 11:33:26
 tile_nameModern Architecture
 PropertiesTopic(array)
 id30
 property_id3403
 topic_id12
 3(array)
 id16
 nameInterior Design
 created2016-02-25 11:25:00
 modified2016-02-25 11:32:53
 tile_nameInterior Design
 PropertiesTopic(array)
 id31
 property_id3403
 topic_id16
- custom_ga_event_properties(array)
 brokerageThe Boutique Real Estate Group, Corona Del Mar
- property(array)
 Property(array)
 id3421
 brokerage_id168
 created_by_user_id0
 order6
 multi_unit(false)
 agent_1_id56
 agent_2_id0
 agent_3_id0
 nameThe Beach Life in San Clemente
 incomplete(false)
 archived(false)
 last_archived0000-00-00 00:00:00
 auto_archived_from_mlsidx(false)
 paid_featured(false)
 featured(true)
 homepage_featured(true)
 brokerage_page_featured(true)
 requested_homepage_featured_by_member(false)
 homepage_featured_by_member(false)
 dot_luxury_featured(false)
 luxury_feed_featured(false)
 force_luxury_feed_featured(false)
 luxury_autofeed_imported(false)
 luxury_feed_last_added_time0000-00-00 00:00:00
 luxury_feed_agent_user_id0
 luxury_feed_locked_to_subscription_id0
 luxury_feed_agent_purchase_date0000-00-00
 luxury_feed_agent_expiration_date0000-00-00
 digital_ad_summary_email_last_sent0000-00-00 00:00:00
 digital_ad_summary_price_changed(false)
 wsj_detail_url
 ft_detail_url
 nyt_detail_url
 juwai_detail_url
 pgl_detail_url
 mg_detail_url
 mg_c_detail_url
 mg_s_detail_url
 bp_detail_url
 mw_detail_url
 nikkei_detail_url
 wapo_detail_url
 robb_detail_url
 medium_featured(false)
 large_featured(false)
 detail_page(true)
 description42 Via Belleza is located in the highly sought after friendly Miraleste neighborhood of Talega with convenient access to the beautiful trails that border the Richard & Donna O'Neill Land Conservancy. This clean and bright home is situated on a generous sized lot with beautiful mature trees in the backyard and front for plenty of privacy and a grassy lot for kids to play. Offering two paved patio areas with water fountain outside that allow for optimal outdoor entertaining, while the home inside features an ideal open concept floor plan with large kitchenfamily room area with surround sound, two fireplaces, four bedroomsincluding a master retreat, making it the perfect place for entertaining and spacious enough for raising a family. The office can easily be converted to a 5th bedroom downstairs suite as it already includes the plumbing for a fourth bathroom. Enjoy the new Outlets at San Clemente, neighborhood parks, community and shopping center, San Clemente Sports Park & Aquatic Center, miles of beach trails and easy access to San Juan Capistrano with the opening of the La Pata extension. Come see this gem before it's gone. 
 address42 Via Belleza
 address_2
 citySan Clemente
 stateCA
 postal_code92673
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price985000
 price_20
 price_usd985000
 price_usd_20
 statusFor Sale
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(false)
 bedrooms4
 bedrooms_20
 bathrooms2
 bathrooms_20
 no_beds_baths(false)
 square_feet0
 square_meters
 acres0
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size0
 icon_1
 icon_2
 icon_3
 icon_4
 icon_5
 icon_6
 websitehttp://42viabelleza.com/
 meta_titleThe Beach Life in San Clemente | San Clemente Real Estate | The Boutique Real Estate Group
 meta_description42 Via Belleza is a property offered for sale in San Clemente, CA, USA, presented by The Boutique Real Estate Group
 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
 latitude0.000000
 longitude0.000000
 invalid_required_fieldslatitude, longitude
 invalid_optional_fieldsagent_2_id, square_feet, square_meters, acres, hectares, bathrooms_partial, year_built, virtual_tour, video_tour, wsj_property_type, nyt_property_type, propgolux_property_type, propgolux_property_style
 went_live_today(false)
 converted(true)
 invalid(false)
 mlsidx_full_address
 mlsidx_date_listed0000-00-00
 mls_market
 primary_property_category_id0
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated(null)
 modified2016-04-18 05:33:03
 created2016-02-10 21:08:38
 uri/property-detail/3421/42-via-belleza-san-clemente-ca-92673-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3421/42-via-belleza-san-clemente-ca-92673-usa
 address_concat42 Via Belleza San Clemente CA 92673 USA
 google_maps_query_string42+Via+Belleza++San+Clemente+CA+92673+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 985,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty4
 bathrooms_pretty2
 bathrooms_partial_pretty0
 bathrooms_3_4_pretty0
 feed_full_bathrooms2
 date_listed2016-02-10
 overridden_brokerage_nameThe Boutique Real Estate Group
 overridden_brokerage_logo_uri/assets/2734.jpg
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id168
 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
 WOEID23417205
 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
 nameThe Boutique Real Estate Group
 broker_of_record_name
 short_nameThe Boutique Real Estate Group
 usernameTheBoutiqueRealEstate
 password01759fcc62fbf8022ef42c08f544e99731e7b5f6
 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
 descriptionThe Boutique Real Estate Group is the exclusive representative for Leverage Global Partners in Newport Beach, Corona Del Mar, Balboa Island, Newport Coast, Huntington Beach, Sunset Beach, CA, USA. The Boutique Real Estate Group is a boutique real estate brokerage founded in Orange County, CA, that focuses on brilliant design, beautiful marketing & luxury services and will be opening multiple offices throughout the Southern California Luxury Real Estate Market. The Boutique has created a culture that spurs collaboration, technology and social media with a unique marketing approach. Our story goes a little something like this. Beautiful design evokes emotion. Emotion stirs the soul and creates a connection between client, agent and the home buying & selling process. The Boutique Real Estate Group has invested heavily in bringing all aspects of the real estate experience completely in-house. From custom design, professional staging, amazing photography, cinematography & film production, social media to technology, internet optimization & cloud based transaction management. This not only provides The Boutique with complete control of the design, marketing & technology of luxury real estate but also gives us the look & feel of a true boutique marketing agency. This design & tech-forward approach has earned The Boutique Real Estate Group accolades & awards worldwide. 2015 Inman News Innovator Award for Most Innovative Technology | Nominee 2015 Top 33 People Changing The Real Estate Industry 2014 Best Real Estate Video of The Year 2014 Inman News Innovator Award for Most Innovative Real Estate Agent | Nominee 2014 Next Generation Real Estate Brokerage 2014 Top 100 Most Influential Real Estate Leaders in The USA 2013 Top 100 Most Influential Real Estate Leaders in The USA 2013 Top 20 Real Estate Videos in The USA
 communitiesNewport Beach Corona Del Mar Balboa Island Newport Coast Huntington Beach Sunset Beach
 websitehttp://www.theboutiquere.com/
 address3653 E. Coast Hwy
 address_2
 cityCorona Del Mar
 stateCA
 full_stateCalifornia
 countryUSA
 marketNewport Beach
 market_2
 postal_code
 phone(949) 612-2535
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameRaj Qsar
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/leverage-lifestyle/meet-raj-qsar-the-boutique-real-estate-group/
 contact_big_profile_link_textMeet Raj
 contact_titlePrincipal/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_filename168.jpg
 logo_filename168.jpg
 contact_image_filename168.jpg
 all_properties_link_image_filename168.jpg
 all_properties_linkhttp://www.theboutiquere.com/properties
 video_embed_code<script type="text/javascript" src="http://videocontent.jloop.com/players/xQ9ZyzIQ-qzxAOUo0.js"></script>
 contact_video_embed_code
 meta_titleNewport Beach Real Estate⎜The Boutique Real Estate Group⎜Leverage Global Partners
 meta_descriptionThe Boutique Real Estate Group is the exclusive representative for Leverage Global Partners in Newport Beach, CA, USA.
 meta_keywordsThe Boutique Real Estate Group, Raj Qsar, Newport Beach Real Estate, Corona Del Mar Real Estate, Balboa Island Real Estate, Newport Coast Real Estate, Huntington Beach Real Estate, Sunset Beach Real Estate, California Real Estate, 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-10-28 16:37:40
 modified2016-04-08 16:34:15
 dre_num012345
 AccountExecutive(array)
 id236
 typeAccountExecutive
 brokerage_id0
 email[email protected]
 passworde5cc5a96287695cf8b7cace1463b1699895dcf92
 recover_hash
 first_nameLauren
 last_namePena
 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:16
 created2016-04-14 15:43:52
 notified(false)
 full_nameLauren Pena
 uri/agent-detail/236/lauren-pena
 profile_complete(true)
 Logo(array)
 id2734
 modelBrokerage
 model_id168
 tagLogo
 name168.jpg
 typeimage/jpg
 size596689
 uri/assets/2734.jpg
 order0
 created2016-03-30 11:43:18
 modified2016-03-30 11:43:18
 MainImage(array)
 id2733
 modelBrokerage
 model_id168
 tagMainImage
 name168.jpg
 typeimage/jpg
 size1969783
 uri/assets/2733.jpg
 order0
 created2016-03-30 11:43:18
 modified2016-03-30 11:43:18
 ContactImage(array)
 id2735
 modelBrokerage
 model_id168
 tagContactImage
 name168.jpg
 typeimage/jpg
 size205910
 uri/assets/2735.jpg
 order0
 created2016-03-30 11:43:18
 modified2016-03-30 11:43:18
 ContactImage2(empty)
 ContactImage3(empty)
 BrokerOfRecordLogo(empty)
 MainArticle(array)
 id286
 modelBrokerage
 model_id168
 archived(false)
 medium_featured(true)
 large_featured(true)
 titleMeet The Boutique Real Estate Group
 authorLeverageRE
 date2014-11-18
 lead_inWatch this video and get to know The Boutique Real Estate Group, the exclusive representative for Leverage Global Partners in Newport Beach, Corona Del Mar, Balboa Island, Newport Coast, Huntington Beach, and Sunset Beach, California, USA.
 body<figure><script src="http://videocontent.jloop.com/players/W2Fz5rh4-qzxAOUo0.js"></script></figure> 
 vimeo_id
 created2016-02-25 14:12:06
 modified2016-04-15 14:47:39
 uri/articles/view/286/meet-the-boutique-real-estate-group
 FeaturedImage(empty)
 Location(array)
 0(array)
 id83
 parent_id9
 brokerage_id168
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameNewport Beach, CA, USA
 short_nameNewport Beach, CA, USA
 group_index
 latitude33.599182
 longitude-117.872169
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_descriptionCelebrated as an alluring destination, Orange County’s beauty is more than skin deep.
 long_descriptionFrom sunset bike rides along the beach on a warm, summer evening to a quick winter weekend adventure in the mountains. From the alluring artwork of the hottest artists displayed in Laguna Beach, to the Village of Corona del Mar which offers amazing shopping in their seaside boutiques, to the historical architecture of Old Towne Orange and the history of US Presidents in Yorba Linda. Whether you choose a cozy beach bungalow or a custom estate built for a celebrity, there is a place here for everyone to call home. Known the world over as an alluring travel destination, the locals who are lucky enough to call Orange County “home” know that the beauty here is more than skin deep.
 created2016-04-05 10:17:09
 modified2016-04-18 10:38:04
 timezoneAmerica/Los_Angeles
 population3500000
 uri/locations/view/83/newport-beach-ca-usa
 tile_nameNewport Beach, CA, USA
 User(array)
 0(array)
 id160
 typeBrokerageAdmin
 brokerage_id168
 email[email protected]
 password01759fcc62fbf8022ef42c08f544e99731e7b5f6
 recover_hash
 first_nameRaj
 last_nameQsar
 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:29:24
 created2016-04-08 16:34:15
 notified(true)
 full_nameRaj Qsar
 uri/agent-detail/160/raj-qsar
 profile_complete(true)
 1(array)
 id287
 typeAgent
 brokerage_id168
 email[email protected]
 password3dc28e4de887e7e6b9e81cf064ce402cbb35b005
 recover_hash
 first_nameTom
 last_nameSchick
 title
 dre_num
 phone9496122535
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:22:41
 created2017-08-07 15:22:41
 notified(false)
 full_nameTom Schick
 uri/agent-detail/287/tom-schick
 profile_complete(true)
 2(array)
 id290
 typeAgent
 brokerage_id168
 email[email protected]
 passworda03511144e8ffa227e568a12989e267bacf5b299
 recover_hash
 first_nameRyan
 last_nameKlusmeyer
 title
 dre_num
 phone9496122535
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:22:41
 created2017-08-07 15:22:41
 notified(false)
 full_nameRyan Klusmeyer
 uri/agent-detail/290/ryan-klusmeyer
 profile_complete(true)
 3(array)
 id291
 typeAgent
 brokerage_id168
 email[email protected]
 passworddb3bcea93336a7e086816ddd39022f58f044ce18
 recover_hash
 first_nameLinda
 last_nameGinex
 title
 dre_num
 phone9496122535
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:22:41
 created2017-08-07 15:22:41
 notified(false)
 full_nameLinda Ginex
 uri/agent-detail/291/linda-ginex
 profile_complete(true)
 4(array)
 id857
 typeAgent
 brokerage_id168
 email[email protected]
 passwordc485c078d276743d32d7ea24df5c853d54d7c772
 recover_hash
 first_nameSarah
 last_nameTrent Miranda
 title
 dre_num
 phone6263742156
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:41
 created2017-08-07 15:23:41
 notified(false)
 full_nameSarah Trent Miranda
 uri/agent-detail/857/sarah-trent-miranda
 profile_complete(true)
 5(array)
 id1010
 typeAgent
 brokerage_id168
 email[email protected]
 password4111f1cd77ba4b5d1f89b1958ec1609b031b1b9c
 recover_hash
 first_nameChris
 last_namePak
 title
 dre_num
 phone714.882.9380
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:48
 created2017-08-07 15:23:48
 notified(false)
 full_nameChris Pak
 uri/agent-detail/1010/chris-pak
 profile_complete(true)
 6(array)
 id1015
 typeAgent
 brokerage_id168
 email[email protected]
 password0c34dbe2952bd83e7c93cca57398abdb4470140e
 recover_hash
 first_nameChristopher
 last_namePak
 title
 dre_num
 phone714.882.9380
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:48
 created2017-08-07 15:23:48
 notified(false)
 full_nameChristopher Pak
 uri/agent-detail/1015/christopher-pak
 profile_complete(true)
 7(array)
 id1060
 typeAgent
 brokerage_id168
 email[email protected]
 passwordbfbc9bf71739246329a29b567b65ea94223d1993
 recover_hash
 first_nameMarea
 last_nameSanhueza
 title
 dre_num
 phone951.712.8648
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:51
 created2017-08-07 15:23:51
 notified(false)
 full_nameMarea Sanhueza
 uri/agent-detail/1060/marea-sanhueza
 profile_complete(true)
 8(array)
 id1080
 typeAgent
 brokerage_id168
 email[email protected]
 password898a1e2eb462d8b3a4d7f8efc251c09ba09d32b7
 recover_hash
 first_nameTracy
 last_nameGlass
 title
 dre_num
 phone949-424-6363
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:52
 created2017-08-07 15:23:52
 notified(false)
 full_nameTracy Glass
 uri/agent-detail/1080/tracy-glass
 profile_complete(true)
 9(array)
 id1226
 typeAgent
 brokerage_id168
 email[email protected]
 password92e2ebc2bc354f30127ec2f9bb4a54332c4b5a59
 recover_hash
 first_nameTara
 last_nameLewicki
 title
 dre_num
 phone949-421-8668
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:59
 created2017-08-07 15:23:59
 notified(false)
 full_nameTara Lewicki
 uri/agent-detail/1226/tara-lewicki
 profile_complete(true)
 uri/brokerage-detail/168/the-boutique-real-estate-group
 website_shortwww.theboutiquere.com
 name_with_locationThe Boutique Real Estate Group - Newport Beach, CA, USA
 StripeSubscription(array)
 id(null)
 brokerage_id(null)
 user_id(null)
 property_id(null)
 type(null)
 stripe_id(null)
 stripe_customer_id(null)
 stripe_checkout_email(null)
 stripe_promotion_code(null)
 stripe_promotion_code_id(null)
 stripe_coupon_code_id(null)
 status(null)
 current_period_end(null)
 cancel_at_period_end(null)
 ended(null)
 last_change(null)
 last_activity_email_sent(null)
 created(null)
 modified(null)
 GlobalReachReport(array)
 id(null)
 property_id(null)
 wsj_desktop(null)
 wsj_mobile(null)
 wsj_expires(null)
 wsj_capture_started(null)
 mg_desktop(null)
 mg_mobile(null)
 mg_expires(null)
 mg_capture_started(null)
 bp_desktop(null)
 bp_mobile(null)
 bp_expires(null)
 gp_capture_started(null)
 mw_desktop(null)
 mw_mobile(null)
 mw_expires(null)
 mw_capture_started(null)
 ft_desktop(null)
 ft_mobile(null)
 ft_expires(null)
 ft_capture_started(null)
 nikkei_desktop(null)
 nikkei_mobile(null)
 nikkei_expires(null)
 nikkei_capture_started(null)
 pgl_desktop(null)
 pgl_mobile(null)
 pgl_expires(null)
 pgl_capture_started(null)
 robb_desktop(null)
 robb_mobile(null)
 robb_expires(null)
 robb_capture_started(null)
 juwai_desktop(null)
 juwai_mobile(null)
 juwai_expires(null)
 juwai_capture_started(null)
 leverage_desktop(null)
 leverage_mobile(null)
 leverage_expires(null)
 leverage_capture_started(null)
 created(null)
 modified(null)
 wsj_available(false)
 wsj_expired(true)
 wsj_desktop_proxy_screenshot(null)
 wsj_mobile_proxy_screenshot(null)
 mg_available(false)
 mg_expired(true)
 mg_desktop_proxy_screenshot(null)
 mg_mobile_proxy_screenshot(null)
 bp_available(false)
 bp_expired(true)
 bp_desktop_proxy_screenshot(null)
 bp_mobile_proxy_screenshot(null)
 mw_available(false)
 mw_expired(true)
 mw_desktop_proxy_screenshot(null)
 mw_mobile_proxy_screenshot(null)
 nikkei_available(false)
 nikkei_expired(true)
 nikkei_desktop_proxy_screenshot(null)
 nikkei_mobile_proxy_screenshot(null)
 pgl_available(false)
 pgl_expired(true)
 pgl_desktop_proxy_screenshot(null)
 pgl_mobile_proxy_screenshot(null)
 robb_available(false)
 robb_expired(true)
 robb_desktop_proxy_screenshot(null)
 robb_mobile_proxy_screenshot(null)
 juwai_available(false)
 juwai_expired(true)
 juwai_desktop_proxy_screenshot(null)
 juwai_mobile_proxy_screenshot(null)
 capture_processing(false)
 capture_error(empty)
 Image(array)
 0(array)
 id19276
 modelProperty
 model_id3421
 tagImage
 name33301.jpg
 typeimage/jpg
 size584608
 uri/assets/19276.jpg
 order0
 created2016-04-07 17:14:15
 modified2016-04-07 17:14:15
 1(array)
 id19275
 modelProperty
 model_id3421
 tagImage
 name33300.jpg
 typeimage/jpg
 size539861
 uri/assets/19275.jpg
 order1
 created2016-04-07 17:14:15
 modified2016-04-07 17:14:15
 2(array)
 id19277
 modelProperty
 model_id3421
 tagImage
 name33302.jpg
 typeimage/jpg
 size533979
 uri/assets/19277.jpg
 order2
 created2016-04-07 17:14:15
 modified2016-04-07 17:14:15
 3(array)
 id19278
 modelProperty
 model_id3421
 tagImage
 name33303.jpg
 typeimage/jpg
 size508936
 uri/assets/19278.jpg
 order3
 created2016-04-07 17:14:15
 modified2016-04-07 17:14:15
 4(array)
 id19279
 modelProperty
 model_id3421
 tagImage
 name33304.jpg
 typeimage/jpg
 size511106
 uri/assets/19279.jpg
 order4
 created2016-04-07 17:14:15
 modified2016-04-07 17:14:15
 5(array)
 id19280
 modelProperty
 model_id3421
 tagImage
 name33305.jpg
 typeimage/jpg
 size489425
 uri/assets/19280.jpg
 order5
 created2016-04-07 17:14:15
 modified2016-04-07 17:14:15
 6(array)
 id19281
 modelProperty
 model_id3421
 tagImage
 name33306.jpg
 typeimage/jpg
 size499115
 uri/assets/19281.jpg
 order6
 created2016-04-07 17:14:15
 modified2016-04-07 17:14:15
 7(array)
 id19282
 modelProperty
 model_id3421
 tagImage
 name33307.jpg
 typeimage/jpg
 size462319
 uri/assets/19282.jpg
 order7
 created2016-04-07 17:14:15
 modified2016-04-07 17:14:15
 8(array)
 id19283
 modelProperty
 model_id3421
 tagImage
 name33308.jpg
 typeimage/jpg
 size569114
 uri/assets/19283.jpg
 order8
 created2016-04-07 17:14:15
 modified2016-04-07 17:14:15
 9(array)
 id19284
 modelProperty
 model_id3421
 tagImage
 name33309.jpg
 typeimage/jpg
 size575818
 uri/assets/19284.jpg
 order9
 created2016-04-07 17:14:15
 modified2016-04-07 17:14:15
 User(array)
 0(array)
 id290
 typeAgent
 brokerage_id168
 email[email protected]
 passworda03511144e8ffa227e568a12989e267bacf5b299
 recover_hash
 first_nameRyan
 last_nameKlusmeyer
 title
 dre_num
 phone9496122535
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:22:41
 created2017-08-07 15:22:41
 notified(false)
 full_nameRyan Klusmeyer
 uri/agent-detail/290/ryan-klusmeyer
 profile_complete(true)
 UsersProperty(array)
 id66
 user_id290
 property_id3421
 sort_order0
 Brokerage(array)
 id168
 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
 WOEID23417205
 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
 nameThe Boutique Real Estate Group
 broker_of_record_name
 short_nameThe Boutique Real Estate Group
 usernameTheBoutiqueRealEstate
 password01759fcc62fbf8022ef42c08f544e99731e7b5f6
 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
 descriptionThe Boutique Real Estate Group is the exclusive representative for Leverage Global Partners in Newport Beach, Corona Del Mar, Balboa Island, Newport Coast, Huntington Beach, Sunset Beach, CA, USA. The Boutique Real Estate Group is a boutique real estate brokerage founded in Orange County, CA, that focuses on brilliant design, beautiful marketing & luxury services and will be opening multiple offices throughout the Southern California Luxury Real Estate Market. The Boutique has created a culture that spurs collaboration, technology and social media with a unique marketing approach. Our story goes a little something like this. Beautiful design evokes emotion. Emotion stirs the soul and creates a connection between client, agent and the home buying & selling process. The Boutique Real Estate Group has invested heavily in bringing all aspects of the real estate experience completely in-house. From custom design, professional staging, amazing photography, cinematography & film production, social media to technology, internet optimization & cloud based transaction management. This not only provides The Boutique with complete control of the design, marketing & technology of luxury real estate but also gives us the look & feel of a true boutique marketing agency. This design & tech-forward approach has earned The Boutique Real Estate Group accolades & awards worldwide. 2015 Inman News Innovator Award for Most Innovative Technology | Nominee 2015 Top 33 People Changing The Real Estate Industry 2014 Best Real Estate Video of The Year 2014 Inman News Innovator Award for Most Innovative Real Estate Agent | Nominee 2014 Next Generation Real Estate Brokerage 2014 Top 100 Most Influential Real Estate Leaders in The USA 2013 Top 100 Most Influential Real Estate Leaders in The USA 2013 Top 20 Real Estate Videos in The USA
 communitiesNewport Beach Corona Del Mar Balboa Island Newport Coast Huntington Beach Sunset Beach
 websitehttp://www.theboutiquere.com/
 address3653 E. Coast Hwy
 address_2
 cityCorona Del Mar
 stateCA
 full_stateCalifornia
 countryUSA
 marketNewport Beach
 market_2
 postal_code
 phone(949) 612-2535
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameRaj Qsar
 contact_profile_link
 contact_big_profile_linkhttp://www.leveragere.com/leverage-lifestyle/meet-raj-qsar-the-boutique-real-estate-group/
 contact_big_profile_link_textMeet Raj
 contact_titlePrincipal/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_filename168.jpg
 logo_filename168.jpg
 contact_image_filename168.jpg
 all_properties_link_image_filename168.jpg
 all_properties_linkhttp://www.theboutiquere.com/properties
 video_embed_code<script type="text/javascript" src="http://videocontent.jloop.com/players/xQ9ZyzIQ-qzxAOUo0.js"></script>
 contact_video_embed_code
 meta_titleNewport Beach Real Estate⎜The Boutique Real Estate Group⎜Leverage Global Partners
 meta_descriptionThe Boutique Real Estate Group is the exclusive representative for Leverage Global Partners in Newport Beach, CA, USA.
 meta_keywordsThe Boutique Real Estate Group, Raj Qsar, Newport Beach Real Estate, Corona Del Mar Real Estate, Balboa Island Real Estate, Newport Coast Real Estate, Huntington Beach Real Estate, Sunset Beach Real Estate, California Real Estate, 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-10-28 16:37:40
 modified2016-04-08 16:34:15
 dre_num012345
 uri/brokerage-detail/168/the-boutique-real-estate-group
 website_shortwww.theboutiquere.com
 name_with_locationThe Boutique Real Estate Group
 Image(empty)
 BrokerageLogoOverride(empty)
 SecondaryPropertyCategory(empty)
 PropertyFeature(empty)
 Topic(empty)
- membership_subscription_temp_allowed_login(null)
- newsletter_member_types(array)
 Leverage Member: AgentLeverage Member: Agent
 Leverage Member: Broker or ManagementLeverage Member: Broker or Management
 Non-MemberNon-Member
- $request->data(empty)
- $this->validationErrors(array)
 Subscription(empty)
 Property(empty)
 User(empty)
 PropertyFeature(empty)
 SecondaryPropertyCategory(empty)
 Topic(empty)
 PrimaryPropertyCategory(empty)
 Brokerage(empty)
 StripeSubscription(empty)
 GlobalReachReport(empty)
 AccountExecutive(empty)
 Logo(empty)
 MainImage(empty)
 ContactImage(empty)
 ContactImage2(empty)
 ContactImage3(empty)
 BrokerOfRecordLogo(empty)
 MainArticle(empty)
 Location(empty)
 FeaturedImage(empty)
 Image(empty)
 UsersProperty(empty)
 BrokerageLogoOverride(empty)
 PropertiesSecondaryPropertyCategory(empty)
 PropertiesPropertyFeature(empty)
 PropertiesTopic(empty)
- Loaded Helpers(array)
 0Permission
 1Number
 2SimpleGraph
 3DebugTimer
 4Toolbar
 5Session
 6Text
 7Flash
 8HtmlToolbar
 9Html
 10Form
====

Environment

App Constants

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

CakePHP Constants

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

PHP Environment

Environment Variable	Value
Php Version	7.4.33
User	leveragere
Home	/var/www/vhosts/leveragere.com
Script Name	/index.php
Request Uri	/property-detail/3421/42-via-belleza-san-clemente-ca-92673-usa
Query String
Request Method	GET
Server Protocol	HTTP/1.1
Gateway Interface	CGI/1.1
Redirect Url	/property-detail/3421/42-via-belleza-san-clemente-ca-92673-usa
Remote Port	18152
Script Filename	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot/index.php
Server Admin	root@localhost
Context Document Root	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot
Context Prefix
Request Scheme	https
Document Root	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot
Remote Addr	104.23.197.114
Server Port	443
Server Addr	172.24.32.44
Server Name	staging2.leveragere.com
Server Software	Apache
Server Signature
Path	/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin
Http Host	staging2.leveragere.com
Http Connection	Keep-Alive
Http X Forwarded Proto	https
Http Cf Visitor	{"scheme":"https"}
Http Cf Ipcountry	US
Http Cf Connecting Ip	216.73.216.172
Http Cdn Loop	cloudflare; loops=1
Http User Agent	Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; [email protected])
Http Accept Encoding	gzip, br
Http Accept	/
Http Cf Ray	a09d8c5d3e0064c2-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	aiosR3aNZNqjH1UE7fm6JQAAABA
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	aiosR3aNZNqjH1UE7fm6JQAAABA
Fcgi Role	RESPONDER
Php Self	/index.php
Request Time Float	1781148743.3356
Request Time	1781148743

====

Include
+
Included Files

Include Paths
- 0/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/lib
- 2/opt/plesk/php/7.4/share/pear
- 3-> /var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/lib/Cake/
Included Files
- core(array)
  Behavior(array)
  0CORE/Model/Behavior/ContainableBehavior.php
  Cache(array)
  0CORE/Cache/Cache.php
  1CORE/Cache/Engine/FileEngine.php
  2CORE/Cache/CacheEngine.php
  Component(array)
  0CORE/Controller/Component/AuthComponent.php
  1CORE/Controller/Component/SessionComponent.php
  2CORE/Controller/Component/CookieComponent.php
  3CORE/Controller/Component/RequestHandlerComponent.php
  4CORE/Controller/Component/Auth/FormAuthenticate.php
  5CORE/Controller/Component/Auth/BaseAuthenticate.php
  Config(array)
  0CORE/Config/routes.php
  1CORE/Config/config.php
  Controller(array)
  0CORE/Controller/Controller.php
  1CORE/Controller/ComponentCollection.php
  2CORE/Controller/Component.php
  Datasource(array)
  0CORE/Model/Datasource/CakeSession.php
  1CORE/Model/Datasource/Database/Mysql.php
  2CORE/Model/Datasource/DboSource.php
  3CORE/Model/Datasource/DataSource.php
  Error(array)
  0CORE/Error/exceptions.php
  1CORE/Error/ErrorHandler.php
  I18n(array)
  0CORE/I18n/I18n.php
  1CORE/I18n/L10n.php
  Log(array)
  0CORE/Log/CakeLog.php
  1CORE/Log/LogEngineCollection.php
  2CORE/Log/Engine/FileLog.php
  3CORE/Log/Engine/BaseLog.php
  4CORE/Log/CakeLogInterface.php
  Model(array)
  0CORE/Model/Model.php
  1CORE/Model/BehaviorCollection.php
  2CORE/Model/ModelBehavior.php
  3CORE/Model/ConnectionManager.php
  Network(array)
  0CORE/Network/CakeRequest.php
  1CORE/Network/CakeResponse.php
  Other(array)
  0CORE/bootstrap.php
  1CORE/basics.php
  2CORE/Core/App.php
  3CORE/Core/Configure.php
  4CORE/Core/CakePlugin.php
  5CORE/Event/CakeEventListener.php
  6CORE/Event/CakeEvent.php
  7CORE/Event/CakeEventManager.php
  8CORE/Core/CakeObject.php
  Routing(array)
  0CORE/Routing/Dispatcher.php
  1CORE/Routing/Filter/AssetDispatcher.php
  2CORE/Routing/DispatcherFilter.php
  3CORE/Routing/Filter/CacheDispatcher.php
  4CORE/Routing/Router.php
  5CORE/Routing/Route/CakeRoute.php
  6CORE/Routing/Route/RedirectRoute.php
  7CORE/Routing/Route/PluginShortRoute.php
  Utility(array)
  0CORE/Utility/Hash.php
  1CORE/Utility/Inflector.php
  2CORE/Utility/ObjectCollection.php
  3CORE/Utility/Debugger.php
  4CORE/Utility/CakeText.php
  5CORE/Utility/ClassRegistry.php
  View(array)
  0CORE/View/HelperCollection.php
- app(array)
  Component(array)
  0APP/Controller/Component/PermissionComponent.php
  1APP/Controller/Component/ExploreComponent.php
  2APP/Controller/Component/PropertyEmailComponent.php
  Config(array)
  0APP/Config/core.php
  1APP/Config/bootstrap.php
  2APP/Config/routes.php
  3APP/Config/database.php
  Controller(array)
  0APP/Controller/PropertiesController.php
  1APP/Controller/AppController.php
  Model(array)
  0APP/Model/Subscription.php
  1APP/Model/AppModel.php
  2APP/Model/Property.php
  3APP/Model/User.php
  4APP/Model/PropertyFeature.php
  5APP/Model/PropertyCategory.php
  6APP/Model/Topic.php
  7APP/Model/Brokerage.php
  8APP/Model/StripeSubscription.php
  9APP/Model/GlobalReachReport.php
  10APP/Model/Asset.php
  11APP/Model/Article.php
  12APP/Model/Location.php
  Other(array)
  0APP/webroot/index.php
  1APP/Vendor/permissions.php
- plugins(array)
  DebugKit(array)
  Component(array)
  0DebugKit/Controller/Component/ToolbarComponent.php
  Plugin(array)
  0DebugKit/Lib/DebugMemory.php
  1DebugKit/Lib/Panel/HistoryPanel.php
  2DebugKit/Lib/DebugPanel.php
  3DebugKit/Lib/Panel/SessionPanel.php
  4DebugKit/Lib/Panel/RequestPanel.php
  5DebugKit/Lib/Panel/SqlLogPanel.php
  6DebugKit/Lib/Panel/TimerPanel.php
  7DebugKit/Lib/Panel/LogPanel.php
  8DebugKit/Lib/Log/Engine/DebugKitLog.php
  9DebugKit/Lib/Panel/VariablesPanel.php
  10DebugKit/Lib/Panel/EnvironmentPanel.php
  11DebugKit/Lib/Panel/IncludePanel.php
  12DebugKit/Lib/DebugTimer.php
====

The Beach Life in San Clemente

Represented By: The Boutique Real Estate Group

www.theboutiquere.com | License #: 012345

Highlighted Properties

Share This

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 11 ms Total Queries: 33 queries

Query Explain:

Memory

Timers

Logs

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

Total Time: 11 ms
Total Queries: 33 queries