Properties /

PRIME LOCATION!

243 Portlock Road | Honolulu, HI 96825, USA | $2,650,000

6 Beds
3 Baths

Prime location! Great value! Best price per square foot of beachside Portlock, one lot in from beautiful Maunalua Bay. Steps from a sandy beach where you can enjoy ocean, sunset and Diamond Head views. Easy ocean access for water sports. Spacious two story, contemporary-style home. Features versatile floorplan, marble & hardwood flooring, gourmet kitchen, laundry room, vaulted ceilings and covered lanai. Private second floor master suite opens to a large roof deck. Lush tropical landscaping on a large level lot. Room for a pool and/or tennis court.

Represented By: East Oahu Realty, RB-16090

View On Map

Highlighted Properties

Portlocks Newest Spec Home...

271 Makaweli Place | Honolulu, HI 96825
$4,200,000

Spectacular Views - Completely Remodeled

357 Lelekepue Place | Honolulu, Hawaii 96821
$2,485,000

Represented By

Featured Location

Honolulu, Oahu, HI, USA

Honolulu, Oahu: Paradise has been found and it's calling your name!

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)
  03142
  1243-portlock-road-honolulu-hi-96825-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: 12 ms
Total Queries: 30 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` = 3142 AND `Property`.`archived` = '0' AND `Brokerage`.`archived` = '0' AND `Property`.`incomplete` = '0' LIMIT 1	1	1	2	maybe slow
SELECT `AccountExecutive`.`id`, `AccountExecutive`.`type`, `AccountExecutive`.`brokerage_id`, `AccountExecutive`.`email`, `AccountExecutive`.`password`, `AccountExecutive`.`recover_hash`, `AccountExecutive`.`first_name`, `AccountExecutive`.`last_name`, `AccountExecutive`.`title`, `AccountExecutive`.`dre_num`, `AccountExecutive`.`phone`, `AccountExecutive`.`max_luxury_feed_properties`, `AccountExecutive`.`headshot_filename`, `AccountExecutive`.`bio`, `AccountExecutive`.`brokerage_name_override`, `AccountExecutive`.`stripe_customer_id`, `AccountExecutive`.`digital_ad_first_free_month_coupon`, `AccountExecutive`.`modified`, `AccountExecutive`.`created`, `AccountExecutive`.`notified`, (CONCAT(`AccountExecutive`.`first_name`, " ", `AccountExecutive`.`last_name`)) AS `AccountExecutive__full_name` FROM `leveragere_staging2`.`users` AS `AccountExecutive` WHERE `AccountExecutive`.`id` = 236	1	1	0
SELECT `Logo`.`id`, `Logo`.`model`, `Logo`.`model_id`, `Logo`.`tag`, `Logo`.`name`, `Logo`.`type`, `Logo`.`size`, `Logo`.`uri`, `Logo`.`order`, `Logo`.`created`, `Logo`.`modified` FROM `leveragere_staging2`.`assets` AS `Logo` WHERE `Logo`.`model_id` = 28 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` = 28 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` = 28 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` = 28 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` = 28 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` = 28 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` = 28 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` = (28) 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` = (28)	1	1	0
SELECT `User`.`id`, `User`.`type`, `User`.`brokerage_id`, `User`.`email`, `User`.`password`, `User`.`recover_hash`, `User`.`first_name`, `User`.`last_name`, `User`.`title`, `User`.`dre_num`, `User`.`phone`, `User`.`max_luxury_feed_properties`, `User`.`headshot_filename`, `User`.`bio`, `User`.`brokerage_name_override`, `User`.`stripe_customer_id`, `User`.`digital_ad_first_free_month_coupon`, `User`.`modified`, `User`.`created`, `User`.`notified`, (CONCAT(`User`.`first_name`, " ", `User`.`last_name`)) AS `User__full_name` FROM `leveragere_staging2`.`users` AS `User` WHERE `User`.`brokerage_id` = (28)	9	9	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` = (3142) ORDER BY `Image`.`order` ASC	7	7	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` = 3142 AND `UsersProperty`.`user_id` = `User`.`id`) ORDER BY `UsersProperty`.`sort_order` ASC	0	0	0
SELECT `SecondaryPropertyCategory`.`id`, `SecondaryPropertyCategory`.`name`, `SecondaryPropertyCategory`.`created`, `SecondaryPropertyCategory`.`modified`, `PropertiesSecondaryPropertyCategory`.`id`, `PropertiesSecondaryPropertyCategory`.`property_id`, `PropertiesSecondaryPropertyCategory`.`property_category_id`, `PropertiesSecondaryPropertyCategory`.`created`, `PropertiesSecondaryPropertyCategory`.`modified` FROM `leveragere_staging2`.`property_categories` AS `SecondaryPropertyCategory` JOIN `leveragere_staging2`.`properties_secondary_property_categories` AS `PropertiesSecondaryPropertyCategory` ON (`PropertiesSecondaryPropertyCategory`.`property_id` = 3142 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` = 3142 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` = 3142 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` != 3142 AND `Property`.`brokerage_id` = 28 AND `Property`.`status` != 'Sold' AND `Property`.`incomplete` = '0' ORDER BY RAND() ASC LIMIT 2	2	2	6	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 (2467, 3696) ORDER BY `Image`.`order` ASC	13	13	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 (2467, 3696) 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 (2467, 3696) 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 (2467, 3696) AND `PropertiesPropertyFeature`.`property_feature_id` = `PropertyFeature`.`id`)	3	3	0
SELECT `Topic`.`id`, `Topic`.`name`, `Topic`.`created`, `Topic`.`modified`, `PropertiesTopic`.`id`, `PropertiesTopic`.`property_id`, `PropertiesTopic`.`topic_id` FROM `leveragere_staging2`.`topics` AS `Topic` JOIN `leveragere_staging2`.`properties_topics` AS `PropertiesTopic` ON (`PropertiesTopic`.`property_id` IN (2467, 3696) AND `PropertiesTopic`.`topic_id` = `Topic`.`id`)	0	0	0
SELECT `Location`.`id`, `Location`.`parent_id`, `Location`.`brokerage_id`, `Location`.`type`, `Location`.`archived`, `Location`.`use_as_topic`, `Location`.`name`, `Location`.`short_name`, `Location`.`group_index`, `Location`.`latitude`, `Location`.`longitude`, `Location`.`country_code`, `Location`.`north`, `Location`.`south`, `Location`.`east`, `Location`.`west`, `Location`.`zoom`, `Location`.`short_description`, `Location`.`long_description`, `Location`.`created`, `Location`.`modified`, `Location`.`timezone`, `Location`.`population`, `Brokerage`.`id`, `Brokerage`.`account_executive_id`, `Brokerage`.`archived`, `Brokerage`.`type`, `Brokerage`.`hide_from_frontend`, `Brokerage`.`agent_brokerage_data_override`, `Brokerage`.`featured_development`, `Brokerage`.`membership_type`, `Brokerage`.`max_properties`, `Brokerage`.`max_homepage_featured_by_member_properties`, `Brokerage`.`featured_properties_sort_method`, `Brokerage`.`lux_feed_mode`, `Brokerage`.`max_luxury_feed_properties`, `Brokerage`.`membership_luxury_feed_properties`, `Brokerage`.`can_participate_in_lux_feed_while_archived`, `Brokerage`.`full_training_video_access`, `Brokerage`.`country_id`, `Brokerage`.`WOEID`, `Brokerage`.`timezone`, `Brokerage`.`luxury_feed_enrollment_mode`, `Brokerage`.`luxury_feed_include_mlsidx_minimum_price`, `Brokerage`.`luxury_feed_include_leverage_minimum_price`, `Brokerage`.`digital_ad_contacts`, `Brokerage`.`add_agents_to_grr_auto_recipients`, `Brokerage`.`mlsidx_id`, `Brokerage`.`mlsidx_lux_autofeed`, `Brokerage`.`mlsidx_lux_autofeed_minimum_price`, `Brokerage`.`mlsidx_logo_url`, `Brokerage`.`mlsidx_disclaimer`, `Brokerage`.`name`, `Brokerage`.`broker_of_record_name`, `Brokerage`.`short_name`, `Brokerage`.`username`, `Brokerage`.`password`, `Brokerage`.`password_reset_hash`, `Brokerage`.`monthly_invoice_amount`, `Brokerage`.`monthly_invoice_start_date`, `Brokerage`.`monthly_invoice_end_date`, `Brokerage`.`contract_filename`, `Brokerage`.`active`, `Brokerage`.`lead_in`, `Brokerage`.`short_description`, `Brokerage`.`description`, `Brokerage`.`communities`, `Brokerage`.`website`, `Brokerage`.`address`, `Brokerage`.`address_2`, `Brokerage`.`city`, `Brokerage`.`state`, `Brokerage`.`full_state`, `Brokerage`.`country`, `Brokerage`.`market`, `Brokerage`.`market_2`, `Brokerage`.`postal_code`, `Brokerage`.`phone`, `Brokerage`.`phone_2`, `Brokerage`.`phone_3`, `Brokerage`.`wide_contact_image`, `Brokerage`.`contact_name`, `Brokerage`.`contact_profile_link`, `Brokerage`.`contact_big_profile_link`, `Brokerage`.`contact_big_profile_link_text`, `Brokerage`.`contact_title`, `Brokerage`.`contact_dre_num`, `Brokerage`.`contact_quote`, `Brokerage`.`contact_email`, `Brokerage`.`contact_facebook`, `Brokerage`.`contact_twitter`, `Brokerage`.`contact_instagram`, `Brokerage`.`contact_pinterest`, `Brokerage`.`contact_linkedin`, `Brokerage`.`contact_youtube`, `Brokerage`.`contact_phone`, `Brokerage`.`contact_email_2`, `Brokerage`.`contact_2_facebook`, `Brokerage`.`contact_2_twitter`, `Brokerage`.`contact_2_instagram`, `Brokerage`.`contact_2_pinterest`, `Brokerage`.`contact_2_linkedin`, `Brokerage`.`contact_2_youtube`, `Brokerage`.`contact_phone_2`, `Brokerage`.`contact_website`, `Brokerage`.`contact_name_2`, `Brokerage`.`contact_profile_link_2`, `Brokerage`.`contact_big_profile_link_2`, `Brokerage`.`contact_big_profile_link_text_2`, `Brokerage`.`contact_title_2`, `Brokerage`.`contact_dre_num_2`, `Brokerage`.`contact_email_3`, `Brokerage`.`contact_name_3`, `Brokerage`.`contact_title_3`, `Brokerage`.`contact_dre_num_3`, `Brokerage`.`contact_phone_3`, `Brokerage`.`contact_3_facebook`, `Brokerage`.`contact_3_twitter`, `Brokerage`.`contact_3_instagram`, `Brokerage`.`contact_3_pinterest`, `Brokerage`.`contact_3_linkedin`, `Brokerage`.`contact_3_youtube`, `Brokerage`.`image_filename`, `Brokerage`.`logo_filename`, `Brokerage`.`contact_image_filename`, `Brokerage`.`all_properties_link_image_filename`, `Brokerage`.`all_properties_link`, `Brokerage`.`video_embed_code`, `Brokerage`.`contact_video_embed_code`, `Brokerage`.`meta_title`, `Brokerage`.`meta_description`, `Brokerage`.`meta_keywords`, `Brokerage`.`login_message_counter`, `Brokerage`.`stats_module_1_type`, `Brokerage`.`stats_module_1_value`, `Brokerage`.`stats_module_2_type`, `Brokerage`.`stats_module_2_value`, `Brokerage`.`stats_module_3_type`, `Brokerage`.`stats_module_3_value`, `Brokerage`.`last_activity_email_sent`, `Brokerage`.`converted`, `Brokerage`.`created`, `Brokerage`.`modified`, `Brokerage`.`dre_num`, `Image`.`id`, `Image`.`model`, `Image`.`model_id`, `Image`.`tag`, `Image`.`name`, `Image`.`type`, `Image`.`size`, `Image`.`uri`, `Image`.`order`, `Image`.`created`, `Image`.`modified` FROM `leveragere_staging2`.`locations` AS `Location` LEFT JOIN `leveragere_staging2`.`brokerages` AS `Brokerage` ON (`Location`.`brokerage_id` = `Brokerage`.`id`) LEFT JOIN `leveragere_staging2`.`assets` AS `Image` ON (`Image`.`model_id` = `Location`.`id` AND `Image`.`model` = 'Location' AND `Image`.`tag` = 'Image') WHERE `Location`.`archived` = '0' AND `Location`.`brokerage_id` = 28 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` = 28 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 (3732, 3142, 3506, 3602) ORDER BY `Image`.`order` ASC	34	34	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 (3732, 3142, 3506, 3602) 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 (3732, 3142, 3506, 3602) 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 (3732, 3142, 3506, 3602) AND `PropertiesPropertyFeature`.`property_feature_id` = `PropertyFeature`.`id`)	5	5	0
SELECT `Topic`.`id`, `Topic`.`name`, `Topic`.`created`, `Topic`.`modified`, `PropertiesTopic`.`id`, `PropertiesTopic`.`property_id`, `PropertiesTopic`.`topic_id` FROM `leveragere_staging2`.`topics` AS `Topic` JOIN `leveragere_staging2`.`properties_topics` AS `PropertiesTopic` ON (`PropertiesTopic`.`property_id` IN (3732, 3142, 3506, 3602) AND `PropertiesTopic`.`topic_id` = `Topic`.`id`)	1	1	0

Query Explain:

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

====

Timer

Memory

Peak Memory Use 14.42 MB

Message	Memory use
Component initialization	3.09 MB
Controller action start	4.02 MB
Controller render start	6.77 MB
View render complete	7.28 MB

Timers

Total Request Time: 258 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	27.73
Event: Controller.initialize	4.06
Event: Controller.startup	1.19
Controller action	47.51
Event: Controller.beforeRender	25.75
» Processing toolbar data	25.65
Rendering View	103.40
» Event: View.beforeRender	0.42
» Rendering APP/View/Properties/view.ctp	3.67
» » Rendering APP/View/Elements/static_property_price.ctp	0.40
» » Rendering APP/View/Elements/property_features.ctp	0.23
» » Rendering APP/View/Elements/static_property_price.ctp #2	0.17
» » 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	1.04
» » » Rendering APP/View/Elements/static_property_price.ctp #4	0.15
» » » Rendering APP/View/Elements/static_property_price.ctp #5	0.15
» » » Rendering APP/View/Elements/static_property_price.ctp #6	0.14
» » » Rendering APP/View/Elements/static_property_price.ctp #7	0.14
» » Rendering APP/View/Elements/sidebar/property_search.ctp	0.23
» Event: View.afterRender	0.01
» Event: View.beforeLayout	0.01
» Rendering APP/View/Layouts/front.ctp	90.44
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)
 id3732
 brokerage_id28
 created_by_user_id0
 order0
 multi_unit(false)
 agent_1_id0
 agent_2_id0
 agent_3_id0
 nameModern and Contemporary Private Oasis
 incomplete(false)
 archived(false)
 last_archived0000-00-00 00:00:00
 auto_archived_from_mlsidx(false)
 paid_featured(false)
 featured(false)
 homepage_featured(false)
 brokerage_page_featured(true)
 requested_homepage_featured_by_member(false)
 homepage_featured_by_member(false)
 dot_luxury_featured(false)
 luxury_feed_featured(false)
 force_luxury_feed_featured(false)
 luxury_autofeed_imported(false)
 luxury_feed_last_added_time0000-00-00 00:00:00
 luxury_feed_agent_user_id0
 luxury_feed_locked_to_subscription_id0
 luxury_feed_agent_purchase_date0000-00-00
 luxury_feed_agent_expiration_date0000-00-00
 digital_ad_summary_email_last_sent0000-00-00 00:00:00
 digital_ad_summary_price_changed(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(false)
 descriptionThis contemporary home impresses at every turn. With Koko Crater views, it is quiet, private and feels like you are on a retreat! Designed for entertaining and relaxation, with seamless transition to bring the outdoors in and create a chic, integrated living experience. This modern Masterpiece by architect Jim Schmidt offers a luxurious floor plan that boasts a Zen rock garden, spacious kitchen with huge granite island, full size walk-in pantry, Subzero refrigerator and a spacious family room. Ample laundry room w/sink, front load washer/dryer, granite counter top and new cabinets for storage. Main level master en suite with free standing tub and a generous sized shower. Big walk-in closet with a custom shoe cabinet! Loft and guestroom suite on upper level. Newly finished yoga studio/guest/maid quarters with a kitchenette/half bath with a separate entrance. Every corner of this luxurious home has been carefully designed. A place for your soul to recharge. An oasis for peace and energy!
 address7938 Hawaii Kai Drive
 address_2
 cityHonolulu
 stateHawaii
 postal_code96825
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price2150000
 price_20
 price_usd2150000
 price_usd_20
 statusFor Sale
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(false)
 bedrooms4
 bedrooms_20
 bathrooms4
 bathrooms_20
 no_beds_baths(false)
 square_feet3958
 square_meters
 acres0
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size0
 icon_1
 icon_2
 icon_3
 icon_4
 icon_5
 icon_6
 websitehttp://www.eastoahu.com/listing/141232635-150082085/7938-hawaii-kai-drive-honolulu-hi-96825/
 meta_title
 meta_description
 meta_keywords
 bathrooms_partial1
 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
 latitude21.293854
 longitude21.293854
 invalid_required_fields
 invalid_optional_fields
 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 00:33:02
 created2016-04-15 16:17:51
 uri/property-detail/3732/7938-hawaii-kai-drive-honolulu-hawaii-96825-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3732/7938-hawaii-kai-drive-honolulu-hawaii-96825-usa
 address_concat7938 Hawaii Kai Drive Honolulu Hawaii 96825 USA
 google_maps_query_string7938+Hawaii+Kai+Drive++Honolulu+Hawaii+96825+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 2,150,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty4
 bathrooms_pretty4
 bathrooms_partial_pretty1
 bathrooms_3_4_pretty0
 feed_full_bathrooms4
 date_listed2016-04-15
 overridden_brokerage_nameEast Oahu Realty, RB-16090
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id28
 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_id1
 WOEID12485533
 timezoneUS/Hawaii
 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
 nameEast Oahu Realty, RB-16090
 broker_of_record_name
 short_nameEast Oahu Realty
 usernameEastOahu
 password184254dea91b6c8586489ec50b8219bece099e54
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date0000-00-00
 monthly_invoice_end_date0000-00-00
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionEast Oahu Realty is the exclusive representative for Leverage Global Partners in Honolulu, Oahu, Hawaii, USA. In 1992, Jack Leslein, President & Founder of East Oahu Realty, Inc., ventured forward with his dream of creating a real estate company of Realtors that would make a difference. Our mission is to be a pacesetter in real estate services by sharing our knowledge and skillfully guiding our clients beyond their expectations. Specializing in helping clients achieve their real estate objectives and focusing on personalized service and attention, East Oahu Realty became the home of trained and experienced Realtors, state of the art technology and dedicated support staff. East Oahu Realty is able to provide the utmost in professional real estate service. As a locally owned, Kama’aina company, we respect and value our island heritage. We are committed to enhancing the lives of those who reside here by providing the utmost in service and community support. We know our market as well as the economic and social factors that shape it. Our knowledge, combined with our broad base of experience, assures you have the information you need to make an informed decision. We are committed to your success, and we are leaders in our industry and our community. We take an active role in shaping the future of both. We are committed to maintaining our reputation of integrity and honesty. We represent our clients enthusiastically and fairly and have done so since 1992. Choosing can make all the difference. What Our Clients Can Expect: <ul> <li>Premier Market Presence</li> <li>Select Team of Successful Real Estate Professionals</li> <li>Global Networking and Exposure</li> <li>Comprehensive Market Analysis & Plans</li> <li>Member of Luxury Real Estate</li> <li>State of the Art Technology</li> <li>Multi-Lingual Realtors</li> <li>Mortgage Services On-Site</li> </ul>
 communitiesHonolulu Hawaii HI USA Oahu Hawaii HI USA
 websitehttp://www.eastoahu.com/
 address6600 Kalanianaole Hwy # 114
 address_2
 cityHonolulu, Oahu
 stateHI
 full_stateHawaii
 countryUSA
 market
 market_2
 postal_code96825
 phone(808) 791-2216
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameCherie Tsukamoto
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titlePrincipal Broker, RB - 14911
 contact_dre_num
 contact_quoteI invite you to contact me personally regarding East Oahu Realty.
 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_filename28.jpg
 logo_filename28.jpg
 contact_image_filename28.jpg
 all_properties_link_image_filename28.jpg
 all_properties_linkhttp://www.eastoahu.com/search/FeaturedListings.aspx
 video_embed_code<script type="text/javascript" src="http://videocontent.jloop.com/players/4U1wTm0Z-qzxAOUo0.js"></script>
 contact_video_embed_code
 meta_titleHonolulu, Oahu Real Estate | East Oahu Realty | Leverage Global Partners
 meta_descriptionEast Oahu Realty is the exclusive representative for Leverage Global Partners in Oahu, Hawaii, USA.
 meta_keywordseast oahu realty, oahu real estate, honolulu real estate, oahu hawaii, jack leslein, leverage global partners
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2013-05-10 18:19:12
 modified2016-04-08 16:33:22
 dre_num012345
 uri/brokerage-detail/28/east-oahu-realty-rb-16090
 website_shortwww.eastoahu.com
 name_with_locationEast Oahu Realty, RB-16090
 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)
 id20884
 modelProperty
 model_id3732
 tagImage
 nameleverage 1.jpg
 typeimage/jpeg
 size52421
 uri/assets/20884.jpg
 order0
 created2016-04-15 16:47:48
 modified2016-04-15 16:47:53
 1(array)
 id20885
 modelProperty
 model_id3732
 tagImage
 nameleverage 2.jpg
 typeimage/jpeg
 size50981
 uri/assets/20885.jpg
 order1
 created2016-04-15 16:47:48
 modified2016-04-15 16:47:53
 2(array)
 id20886
 modelProperty
 model_id3732
 tagImage
 nameleverage 3.jpg
 typeimage/jpeg
 size59263
 uri/assets/20886.jpg
 order2
 created2016-04-15 16:47:48
 modified2016-04-15 16:47:53
 3(array)
 id20887
 modelProperty
 model_id3732
 tagImage
 nameleverage 5.jpg
 typeimage/jpeg
 size59957
 uri/assets/20887.jpg
 order3
 created2016-04-15 16:47:48
 modified2016-04-15 16:47:53
 4(array)
 id20888
 modelProperty
 model_id3732
 tagImage
 nameleverage 6.jpg
 typeimage/jpeg
 size51221
 uri/assets/20888.jpg
 order4
 created2016-04-15 16:47:48
 modified2016-04-15 16:47:53
 5(array)
 id20889
 modelProperty
 model_id3732
 tagImage
 nameleverage 4.jpg
 typeimage/jpeg
 size72224
 uri/assets/20889.jpg
 order5
 created2016-04-15 16:47:48
 modified2016-04-15 16:47:53
 6(array)
 id20891
 modelProperty
 model_id3732
 tagImage
 nameleverage 8.jpg
 typeimage/jpeg
 size72084
 uri/assets/20891.jpg
 order6
 created2016-04-15 16:47:49
 modified2016-04-15 16:47:53
 7(array)
 id20892
 modelProperty
 model_id3732
 tagImage
 nameleverage 9.jpg
 typeimage/jpeg
 size54571
 uri/assets/20892.jpg
 order7
 created2016-04-15 16:47:49
 modified2016-04-15 16:47:53
 8(array)
 id20893
 modelProperty
 model_id3732
 tagImage
 nameleverage 7.jpg
 typeimage/jpeg
 size63051
 uri/assets/20893.jpg
 order8
 created2016-04-15 16:47:50
 modified2016-04-15 16:47:53
 User(array)
 0(array)
 id1276
 typeAgent
 brokerage_id28
 email[email protected]
 passworda992f8ca84fdd6442933402b26af8813256403e7
 recover_hash
 first_nameSakina
 last_nameClaytor
 title
 dre_num
 phone808-594-9044
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:24:02
 created2017-08-07 15:24:02
 notified(false)
 full_nameSakina Claytor
 uri/agent-detail/1276/sakina-claytor
 profile_complete(true)
 UsersProperty(array)
 id1102
 user_id1276
 property_id3732
 sort_order0
 SecondaryPropertyCategory(empty)
 PropertyFeature(array)
 0(array)
 id4
 nameGarage
 additional(false)
 created2016-04-07 14:01:52
 modified2016-04-07 14:01:52
 PropertiesPropertyFeature(array)
 id4401
 property_id3732
 property_feature_id4
 Topic(array)
 0(array)
 id12
 nameModern Architecture
 created2016-02-25 11:25:00
 modified2016-02-25 11:33:26
 tile_nameModern Architecture
 PropertiesTopic(array)
 id39
 property_id3732
 topic_id12
 1(array)
 Property(array)
 id3142
 brokerage_id28
 created_by_user_id0
 order3
 multi_unit(false)
 agent_1_id1049
 agent_2_id0
 agent_3_id0
 namePRIME LOCATION!
 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)
 descriptionPrime location! Great value! Best price per square foot of beachside Portlock, one lot in from beautiful Maunalua Bay. Steps from a sandy beach where you can enjoy ocean, sunset and Diamond Head views. Easy ocean access for water sports. Spacious two story, contemporary-style home. Features versatile floorplan, marble & hardwood flooring, gourmet kitchen, laundry room, vaulted ceilings and covered lanai. Private second floor master suite opens to a large roof deck. Lush tropical landscaping on a large level lot. Room for a pool and/or tennis court.
 address243 Portlock Road
 address_2
 cityHonolulu
 stateHI
 postal_code96825
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price2650000
 price_20
 price_usd2650000
 price_usd_20
 statusFor Sale
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(false)
 bedrooms6
 bedrooms_20
 bathrooms3
 bathrooms_20
 no_beds_baths(false)
 square_feet0
 square_meters
 acres0
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size0
 icon_1
 icon_2
 icon_3
 icon_4
 icon_5
 icon_6
 website
 meta_titlePRIME LOCATION! | Honolulu Real Estate | East Oahu Realty, RB-16090
 meta_description243 Portlock Road is a property offered for sale in Honolulu, HI, USA, presented by East Oahu Realty, RB-16090
 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_fields
 invalid_optional_fieldsagent_2_id, bathrooms_partial, square_feet, square_meters, acres, hectares, virtual_tour, video_tour
 went_live_today(false)
 converted(true)
 invalid(false)
 mlsidx_full_address
 mlsidx_date_listed0000-00-00
 mls_market
 primary_property_category_id0
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated(null)
 modified2016-04-18 05:33:02
 created2015-11-23 15:52:28
 uri/property-detail/3142/243-portlock-road-honolulu-hi-96825-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3142/243-portlock-road-honolulu-hi-96825-usa
 address_concat243 Portlock Road Honolulu HI 96825 USA
 google_maps_query_string243+Portlock+Road++Honolulu+HI+96825+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 2,650,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty6
 bathrooms_pretty3
 bathrooms_partial_pretty0
 bathrooms_3_4_pretty0
 feed_full_bathrooms3
 date_listed2015-11-23
 overridden_brokerage_nameEast Oahu Realty, RB-16090
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id28
 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_id1
 WOEID12485533
 timezoneUS/Hawaii
 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
 nameEast Oahu Realty, RB-16090
 broker_of_record_name
 short_nameEast Oahu Realty
 usernameEastOahu
 password184254dea91b6c8586489ec50b8219bece099e54
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date0000-00-00
 monthly_invoice_end_date0000-00-00
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionEast Oahu Realty is the exclusive representative for Leverage Global Partners in Honolulu, Oahu, Hawaii, USA. In 1992, Jack Leslein, President & Founder of East Oahu Realty, Inc., ventured forward with his dream of creating a real estate company of Realtors that would make a difference. Our mission is to be a pacesetter in real estate services by sharing our knowledge and skillfully guiding our clients beyond their expectations. Specializing in helping clients achieve their real estate objectives and focusing on personalized service and attention, East Oahu Realty became the home of trained and experienced Realtors, state of the art technology and dedicated support staff. East Oahu Realty is able to provide the utmost in professional real estate service. As a locally owned, Kama’aina company, we respect and value our island heritage. We are committed to enhancing the lives of those who reside here by providing the utmost in service and community support. We know our market as well as the economic and social factors that shape it. Our knowledge, combined with our broad base of experience, assures you have the information you need to make an informed decision. We are committed to your success, and we are leaders in our industry and our community. We take an active role in shaping the future of both. We are committed to maintaining our reputation of integrity and honesty. We represent our clients enthusiastically and fairly and have done so since 1992. Choosing can make all the difference. What Our Clients Can Expect: <ul> <li>Premier Market Presence</li> <li>Select Team of Successful Real Estate Professionals</li> <li>Global Networking and Exposure</li> <li>Comprehensive Market Analysis & Plans</li> <li>Member of Luxury Real Estate</li> <li>State of the Art Technology</li> <li>Multi-Lingual Realtors</li> <li>Mortgage Services On-Site</li> </ul>
 communitiesHonolulu Hawaii HI USA Oahu Hawaii HI USA
 websitehttp://www.eastoahu.com/
 address6600 Kalanianaole Hwy # 114
 address_2
 cityHonolulu, Oahu
 stateHI
 full_stateHawaii
 countryUSA
 market
 market_2
 postal_code96825
 phone(808) 791-2216
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameCherie Tsukamoto
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titlePrincipal Broker, RB - 14911
 contact_dre_num
 contact_quoteI invite you to contact me personally regarding East Oahu Realty.
 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_filename28.jpg
 logo_filename28.jpg
 contact_image_filename28.jpg
 all_properties_link_image_filename28.jpg
 all_properties_linkhttp://www.eastoahu.com/search/FeaturedListings.aspx
 video_embed_code<script type="text/javascript" src="http://videocontent.jloop.com/players/4U1wTm0Z-qzxAOUo0.js"></script>
 contact_video_embed_code
 meta_titleHonolulu, Oahu Real Estate | East Oahu Realty | Leverage Global Partners
 meta_descriptionEast Oahu Realty is the exclusive representative for Leverage Global Partners in Oahu, Hawaii, USA.
 meta_keywordseast oahu realty, oahu real estate, honolulu real estate, oahu hawaii, jack leslein, leverage global partners
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2013-05-10 18:19:12
 modified2016-04-08 16:33:22
 dre_num012345
 uri/brokerage-detail/28/east-oahu-realty-rb-16090
 website_shortwww.eastoahu.com
 name_with_locationEast Oahu Realty, RB-16090
 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)
 id16760
 modelProperty
 model_id3142
 tagImage
 name30159.jpg
 typeimage/jpg
 size482238
 uri/assets/16760.jpg
 order0
 created2016-04-07 17:00:07
 modified2016-04-07 17:00:07
 1(array)
 id16754
 modelProperty
 model_id3142
 tagImage
 name30165.jpg
 typeimage/jpg
 size654393
 uri/assets/16754.jpg
 order1
 created2016-04-07 17:00:07
 modified2016-04-07 17:00:07
 2(array)
 id16759
 modelProperty
 model_id3142
 tagImage
 name30160.jpg
 typeimage/jpg
 size311558
 uri/assets/16759.jpg
 order2
 created2016-04-07 17:00:07
 modified2016-04-07 17:00:07
 3(array)
 id16758
 modelProperty
 model_id3142
 tagImage
 name30161.jpg
 typeimage/jpg
 size234504
 uri/assets/16758.jpg
 order3
 created2016-04-07 17:00:07
 modified2016-04-07 17:00:07
 4(array)
 id16757
 modelProperty
 model_id3142
 tagImage
 name30162.jpg
 typeimage/jpg
 size237996
 uri/assets/16757.jpg
 order4
 created2016-04-07 17:00:07
 modified2016-04-07 17:00:07
 5(array)
 id16756
 modelProperty
 model_id3142
 tagImage
 name30163.jpg
 typeimage/jpg
 size373736
 uri/assets/16756.jpg
 order5
 created2016-04-07 17:00:07
 modified2016-04-07 17:00:07
 6(array)
 id16755
 modelProperty
 model_id3142
 tagImage
 name30164.jpg
 typeimage/jpg
 size404837
 uri/assets/16755.jpg
 order6
 created2016-04-07 17:00:07
 modified2016-04-07 17:00:07
 User(empty)
 SecondaryPropertyCategory(empty)
 PropertyFeature(empty)
 Topic(empty)
 2(array)
 Property(array)
 id3506
 brokerage_id28
 created_by_user_id0
 order2
 multi_unit(false)
 agent_1_id1049
 agent_2_id1053
 agent_3_id0
 nameTantalus - Uninterrupted Ocean Views
 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)
 descriptionGorgeous, uninterrupted ocean, city and sunset views are captured from this Artisan-designed, island residence. This privately-gated property is exquisitely renovated and reflects attention to detail thru-out! Tasteful appointments include Mahogany and Mango cabinetry, granite Counter tops, Italian stone surfaces and exotic hard wood flooring. Enjoy gourmet kitchen, spacious master suite, two wood-burning fireplaces, private study and large lanai! Gorgeous lawns with over 50 varieties of plants and fruit trees! This one-of-a-kind residence offers the utmost in comfort and serenity! Perfect for indoor/outdoor island living! It also has 41 panels of PV, plus a catchment system - almost self-sustained! Perfect for the most discriminating buyer! Land area reflects consolidation of lots. Tax office records may differ.
 address221 Forest Ridge Way
 address_2
 cityHonolulu
 stateHI
 postal_code96822
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price3288000
 price_20
 price_usd3288000
 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_1
 icon_2
 icon_3
 icon_4
 icon_5
 icon_6
 websitehttp://www.eastoahu.com/listing/136534960-150082085/221-forest-ridge-way-honolulu-hi-96822/
 meta_titleTantalus - Uninterrupted Ocean Views | Honolulu Real Estate | East Oahu Realty, RB-16090
 meta_description221 Forest Ridge Way is a property offered for sale in Honolulu, HI, USA, presented by East Oahu Realty, RB-16090
 meta_keywords
 bathrooms_partial1
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built
 virtual_tourhttp://tour.circlepix.com/tour/blaze/?tourId=3345908#.VtT3g_krKUk
 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_fieldssquare_feet, square_meters, acres, hectares, 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
 created2016-02-25 19:50:03
 uri/property-detail/3506/221-forest-ridge-way-honolulu-hi-96822-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3506/221-forest-ridge-way-honolulu-hi-96822-usa
 address_concat221 Forest Ridge Way Honolulu HI 96822 USA
 google_maps_query_string221+Forest+Ridge+Way++Honolulu+HI+96822+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 3,288,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty3
 bathrooms_pretty2
 bathrooms_partial_pretty1
 bathrooms_3_4_pretty0
 feed_full_bathrooms2
 date_listed2016-02-25
 overridden_brokerage_nameEast Oahu Realty, RB-16090
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id28
 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_id1
 WOEID12485533
 timezoneUS/Hawaii
 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
 nameEast Oahu Realty, RB-16090
 broker_of_record_name
 short_nameEast Oahu Realty
 usernameEastOahu
 password184254dea91b6c8586489ec50b8219bece099e54
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date0000-00-00
 monthly_invoice_end_date0000-00-00
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionEast Oahu Realty is the exclusive representative for Leverage Global Partners in Honolulu, Oahu, Hawaii, USA. In 1992, Jack Leslein, President & Founder of East Oahu Realty, Inc., ventured forward with his dream of creating a real estate company of Realtors that would make a difference. Our mission is to be a pacesetter in real estate services by sharing our knowledge and skillfully guiding our clients beyond their expectations. Specializing in helping clients achieve their real estate objectives and focusing on personalized service and attention, East Oahu Realty became the home of trained and experienced Realtors, state of the art technology and dedicated support staff. East Oahu Realty is able to provide the utmost in professional real estate service. As a locally owned, Kama’aina company, we respect and value our island heritage. We are committed to enhancing the lives of those who reside here by providing the utmost in service and community support. We know our market as well as the economic and social factors that shape it. Our knowledge, combined with our broad base of experience, assures you have the information you need to make an informed decision. We are committed to your success, and we are leaders in our industry and our community. We take an active role in shaping the future of both. We are committed to maintaining our reputation of integrity and honesty. We represent our clients enthusiastically and fairly and have done so since 1992. Choosing can make all the difference. What Our Clients Can Expect: <ul> <li>Premier Market Presence</li> <li>Select Team of Successful Real Estate Professionals</li> <li>Global Networking and Exposure</li> <li>Comprehensive Market Analysis & Plans</li> <li>Member of Luxury Real Estate</li> <li>State of the Art Technology</li> <li>Multi-Lingual Realtors</li> <li>Mortgage Services On-Site</li> </ul>
 communitiesHonolulu Hawaii HI USA Oahu Hawaii HI USA
 websitehttp://www.eastoahu.com/
 address6600 Kalanianaole Hwy # 114
 address_2
 cityHonolulu, Oahu
 stateHI
 full_stateHawaii
 countryUSA
 market
 market_2
 postal_code96825
 phone(808) 791-2216
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameCherie Tsukamoto
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titlePrincipal Broker, RB - 14911
 contact_dre_num
 contact_quoteI invite you to contact me personally regarding East Oahu Realty.
 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_filename28.jpg
 logo_filename28.jpg
 contact_image_filename28.jpg
 all_properties_link_image_filename28.jpg
 all_properties_linkhttp://www.eastoahu.com/search/FeaturedListings.aspx
 video_embed_code<script type="text/javascript" src="http://videocontent.jloop.com/players/4U1wTm0Z-qzxAOUo0.js"></script>
 contact_video_embed_code
 meta_titleHonolulu, Oahu Real Estate | East Oahu Realty | Leverage Global Partners
 meta_descriptionEast Oahu Realty is the exclusive representative for Leverage Global Partners in Oahu, Hawaii, USA.
 meta_keywordseast oahu realty, oahu real estate, honolulu real estate, oahu hawaii, jack leslein, leverage global partners
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2013-05-10 18:19:12
 modified2016-04-08 16:33:22
 dre_num012345
 uri/brokerage-detail/28/east-oahu-realty-rb-16090
 website_shortwww.eastoahu.com
 name_with_locationEast Oahu Realty, RB-16090
 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)
 id17381
 modelProperty
 model_id3506
 tagImage
 name34117.jpg
 typeimage/jpg
 size305038
 uri/assets/17381.jpg
 order0
 created2016-04-07 17:03:09
 modified2016-04-07 17:03:09
 1(array)
 id17389
 modelProperty
 model_id3506
 tagImage
 name34125.jpg
 typeimage/jpg
 size308628
 uri/assets/17389.jpg
 order1
 created2016-04-07 17:03:10
 modified2016-04-07 17:03:10
 2(array)
 id17382
 modelProperty
 model_id3506
 tagImage
 name34118.jpg
 typeimage/jpg
 size331802
 uri/assets/17382.jpg
 order2
 created2016-04-07 17:03:09
 modified2016-04-07 17:03:09
 3(array)
 id17388
 modelProperty
 model_id3506
 tagImage
 name34124.jpg
 typeimage/jpg
 size387339
 uri/assets/17388.jpg
 order3
 created2016-04-07 17:03:10
 modified2016-04-07 17:03:10
 4(array)
 id17383
 modelProperty
 model_id3506
 tagImage
 name34119.jpg
 typeimage/jpg
 size408131
 uri/assets/17383.jpg
 order4
 created2016-04-07 17:03:09
 modified2016-04-07 17:03:09
 5(array)
 id17384
 modelProperty
 model_id3506
 tagImage
 name34120.jpg
 typeimage/jpg
 size325200
 uri/assets/17384.jpg
 order5
 created2016-04-07 17:03:09
 modified2016-04-07 17:03:09
 6(array)
 id17385
 modelProperty
 model_id3506
 tagImage
 name34121.jpg
 typeimage/jpg
 size242225
 uri/assets/17385.jpg
 order6
 created2016-04-07 17:03:09
 modified2016-04-07 17:03:09
 7(array)
 id17387
 modelProperty
 model_id3506
 tagImage
 name34123.jpg
 typeimage/jpg
 size434183
 uri/assets/17387.jpg
 order7
 created2016-04-07 17:03:09
 modified2016-04-07 17:03:10
 8(array)
 id17386
 modelProperty
 model_id3506
 tagImage
 name34122.jpg
 typeimage/jpg
 size617069
 uri/assets/17386.jpg
 order8
 created2016-04-07 17:03:09
 modified2016-04-07 17:03:09
 9(array)
 id17390
 modelProperty
 model_id3506
 tagImage
 name34126.jpg
 typeimage/jpg
 size627718
 uri/assets/17390.jpg
 order9
 created2016-04-07 17:03:10
 modified2016-04-07 17:03:10
 User(empty)
 SecondaryPropertyCategory(empty)
 PropertyFeature(empty)
 Topic(empty)
 3(array)
 Property(array)
 id3602
 brokerage_id28
 created_by_user_id0
 order0
 multi_unit(false)
 agent_1_id1192
 agent_2_id0
 agent_3_id0
 nameResort Style, Oceanfront Luxury Estate!
 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)
 descriptionUndisputed island living at its finest. This Hawaiian style oceanfront home is perched right above sea level, giving you the best perspective of the deep blue Pacific. It's located in one of the breeziest and sunniest locales on the island of O'ahu yet tucked away from the hustle and bustle of Waikiki for those seeking privacy and serenity. Convenient while remaining as far out into the ocean as possible and simply a stunning and relaxing place to be. Along side the property is a large private tropical jungle ravine with banana, coconut, and papaya trees to add a touch of country. Access to ocean is down a private meandering grass path that opens to a hidden cove covered with olivine sand. Absorb the incredible mountain views, endless ocean, whales, and dolphins gliding through the swells with the picturesque sunsets behind Diamond Head. <ul> <li>4 Large Bedrooms, each with their own Bathroom, Fans and TV's. </li> <li>The Master Bedroom has Air-Conditioning, Private Lanai, Bath with direct ocean and ravine views, Bath Tub, enclosed Toilet and Bidet.</li> <li>The Guest Suite has a private and separate entrance by a ramp in the event a traveler needs wheelchair access. The Suite can also be accessed from the house. It has an outdoor private seating area in garden setting and its own kitchenette, and tub/shower combination. </li> <li>The 2 additional bedrooms are quiet, comfortably sized and also have garden/ravine views.</li> <li> Add'l beds not in bedrooms; Queen size day-bed (pune'e) can be used for sleeping, reading or resting on and is located on the lanai off the living room with pool/ocean view. The office also has a single sized day pune'e and is next to a powder room with sink and toilet.</li> </ul>
 address18 Poipu Place
 address_2
 cityHonolulu
 stateHI
 postal_code96825
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price6250000
 price_20
 price_usd6250000
 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
 bathrooms5
 bathrooms_20
 no_beds_baths(false)
 square_feet0
 square_meters
 acres0
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size0
 icon_1beach-access
 icon_2pool
 icon_3views
 icon_4waterfront
 icon_5
 icon_6
 websitehttp://www.bluehawaiikai.com/#intro
 meta_titleResort Style, Oceanfront Luxury Estate! | Honolulu Real Estate | East Oahu Realty, RB-16090
 meta_description18 Poipu Place is a property offered for sale in Honolulu, HI, USA, presented by East Oahu Realty, RB-16090
 meta_keywords
 bathrooms_partial0
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built
 virtual_tour
 video_tourhttp://www.bluehawaiikai.com/video/
 digital_brochure
 video_tour_embed_code<iframe width="560" height="315" src="https://www.youtube.com/embed/75CphhnGdEM?list=PLBnV-eYImEvcrgRWzRpqQ6XK9iuhfm8H_<iframe width="560" height="315" src="https://www.youtube.com/embed/75CphhnGdEM?list=PLBnV-eY" 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, bathrooms_partial, square_feet, square_meters, acres, hectares, year_built, virtual_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-03-16 14:15:24
 uri/property-detail/3602/18-poipu-place-honolulu-hi-96825-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3602/18-poipu-place-honolulu-hi-96825-usa
 address_concat18 Poipu Place Honolulu HI 96825 USA
 google_maps_query_string18+Poipu+Place++Honolulu+HI+96825+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 6,250,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty4
 bathrooms_pretty5
 bathrooms_partial_pretty0
 bathrooms_3_4_pretty0
 feed_full_bathrooms5
 date_listed2016-03-16
 overridden_brokerage_nameEast Oahu Realty, RB-16090
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id28
 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_id1
 WOEID12485533
 timezoneUS/Hawaii
 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
 nameEast Oahu Realty, RB-16090
 broker_of_record_name
 short_nameEast Oahu Realty
 usernameEastOahu
 password184254dea91b6c8586489ec50b8219bece099e54
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date0000-00-00
 monthly_invoice_end_date0000-00-00
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionEast Oahu Realty is the exclusive representative for Leverage Global Partners in Honolulu, Oahu, Hawaii, USA. In 1992, Jack Leslein, President & Founder of East Oahu Realty, Inc., ventured forward with his dream of creating a real estate company of Realtors that would make a difference. Our mission is to be a pacesetter in real estate services by sharing our knowledge and skillfully guiding our clients beyond their expectations. Specializing in helping clients achieve their real estate objectives and focusing on personalized service and attention, East Oahu Realty became the home of trained and experienced Realtors, state of the art technology and dedicated support staff. East Oahu Realty is able to provide the utmost in professional real estate service. As a locally owned, Kama’aina company, we respect and value our island heritage. We are committed to enhancing the lives of those who reside here by providing the utmost in service and community support. We know our market as well as the economic and social factors that shape it. Our knowledge, combined with our broad base of experience, assures you have the information you need to make an informed decision. We are committed to your success, and we are leaders in our industry and our community. We take an active role in shaping the future of both. We are committed to maintaining our reputation of integrity and honesty. We represent our clients enthusiastically and fairly and have done so since 1992. Choosing can make all the difference. What Our Clients Can Expect: <ul> <li>Premier Market Presence</li> <li>Select Team of Successful Real Estate Professionals</li> <li>Global Networking and Exposure</li> <li>Comprehensive Market Analysis & Plans</li> <li>Member of Luxury Real Estate</li> <li>State of the Art Technology</li> <li>Multi-Lingual Realtors</li> <li>Mortgage Services On-Site</li> </ul>
 communitiesHonolulu Hawaii HI USA Oahu Hawaii HI USA
 websitehttp://www.eastoahu.com/
 address6600 Kalanianaole Hwy # 114
 address_2
 cityHonolulu, Oahu
 stateHI
 full_stateHawaii
 countryUSA
 market
 market_2
 postal_code96825
 phone(808) 791-2216
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameCherie Tsukamoto
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titlePrincipal Broker, RB - 14911
 contact_dre_num
 contact_quoteI invite you to contact me personally regarding East Oahu Realty.
 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_filename28.jpg
 logo_filename28.jpg
 contact_image_filename28.jpg
 all_properties_link_image_filename28.jpg
 all_properties_linkhttp://www.eastoahu.com/search/FeaturedListings.aspx
 video_embed_code<script type="text/javascript" src="http://videocontent.jloop.com/players/4U1wTm0Z-qzxAOUo0.js"></script>
 contact_video_embed_code
 meta_titleHonolulu, Oahu Real Estate | East Oahu Realty | Leverage Global Partners
 meta_descriptionEast Oahu Realty is the exclusive representative for Leverage Global Partners in Oahu, Hawaii, USA.
 meta_keywordseast oahu realty, oahu real estate, honolulu real estate, oahu hawaii, jack leslein, leverage global partners
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2013-05-10 18:19:12
 modified2016-04-08 16:33:22
 dre_num012345
 uri/brokerage-detail/28/east-oahu-realty-rb-16090
 website_shortwww.eastoahu.com
 name_with_locationEast Oahu Realty, RB-16090
 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)
 id20010
 modelProperty
 model_id3602
 tagImage
 name35001.jpg
 typeimage/jpg
 size1116919
 uri/assets/20010.jpg
 order0
 created2016-04-07 17:25:23
 modified2016-04-07 17:25:23
 1(array)
 id20009
 modelProperty
 model_id3602
 tagImage
 name35000.jpg
 typeimage/jpg
 size431779
 uri/assets/20009.jpg
 order1
 created2016-04-07 17:25:23
 modified2016-04-07 17:25:23
 2(array)
 id20008
 modelProperty
 model_id3602
 tagImage
 name35003.jpg
 typeimage/jpg
 size453470
 uri/assets/20008.jpg
 order2
 created2016-04-07 17:25:23
 modified2016-04-07 17:25:23
 3(array)
 id20005
 modelProperty
 model_id3602
 tagImage
 name34996.jpg
 typeimage/jpg
 size635160
 uri/assets/20005.jpg
 order3
 created2016-04-07 17:25:23
 modified2016-04-07 17:25:23
 4(array)
 id20011
 modelProperty
 model_id3602
 tagImage
 name35002.jpg
 typeimage/jpg
 size498020
 uri/assets/20011.jpg
 order4
 created2016-04-07 17:25:23
 modified2016-04-07 17:25:23
 5(array)
 id20006
 modelProperty
 model_id3602
 tagImage
 name34997.jpg
 typeimage/jpg
 size1056272
 uri/assets/20006.jpg
 order5
 created2016-04-07 17:25:23
 modified2016-04-07 17:25:23
 6(array)
 id20007
 modelProperty
 model_id3602
 tagImage
 name34998.jpg
 typeimage/jpg
 size557977
 uri/assets/20007.jpg
 order6
 created2016-04-07 17:25:23
 modified2016-04-07 17:25:23
 7(array)
 id20004
 modelProperty
 model_id3602
 tagImage
 name34995.jpg
 typeimage/jpg
 size587824
 uri/assets/20004.jpg
 order7
 created2016-04-07 17:25:23
 modified2016-04-07 17:25:23
 User(empty)
 SecondaryPropertyCategory(empty)
 PropertyFeature(array)
 0(array)
 id2
 nameBeach Access
 additional(false)
 created2016-04-07 14:00:52
 modified2016-04-07 14:00:52
 PropertiesPropertyFeature(array)
 id4232
 property_id3602
 property_feature_id2
 1(array)
 id12
 nameSwimming Pool
 additional(false)
 created2016-04-07 14:04:12
 modified2016-04-07 14:04:12
 PropertiesPropertyFeature(array)
 id4233
 property_id3602
 property_feature_id12
 2(array)
 id14
 nameViews
 additional(false)
 created2016-04-07 14:04:55
 modified2016-04-07 14:04:55
 PropertiesPropertyFeature(array)
 id4234
 property_id3602
 property_feature_id14
 3(array)
 id17
 nameWaterfront
 additional(false)
 created2016-04-07 14:06:00
 modified2016-04-07 14:06:00
 PropertiesPropertyFeature(array)
 id4235
 property_id3602
 property_feature_id17
 Topic(empty)
- sidebar_locations(array)
 0(array)
 Location(array)
 id32
 parent_id9
 brokerage_id28
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameHonolulu, Oahu, HI, USA
 short_nameHonolulu, Oahu, HI, USA
 group_index
 latitude21.296232
 longitude-157.701981
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_descriptionHonolulu, Oahu: Paradise has been found and it's calling your name!
 long_descriptionWhether you’re a sun-seeker, metropolitan maven, or adventure addict, Honolulu is the place to be! Located on beautiful Oahu, also known as the “The Gathering Place”, Hawaii’s most populous city is an alluring melting pot of cultures and cuisines. The relaxed lifestyle and ‘Aloha’ spirit will keep your mind at ease while our stunning mountains and pristine beaches keep you young and active. From famous historical sites to secluded natural treasures, residents here enjoy a boundless supply of scenic beauty and rejuvenating adventure. Also boasting world-class shopping, commerce and entertainment, you are sure to find your place in the sun!
 created2016-04-04 12:01:25
 modified2016-04-04 12:03:35
 timezonePacific/Honolulu
 population953000
 uri/locations/view/32/honolulu-oahu-hi-usa
 tile_nameHonolulu, Oahu, HI, USA
 Brokerage(array)
 id28
 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_id1
 WOEID12485533
 timezoneUS/Hawaii
 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
 nameEast Oahu Realty, RB-16090
 broker_of_record_name
 short_nameEast Oahu Realty
 usernameEastOahu
 password184254dea91b6c8586489ec50b8219bece099e54
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date0000-00-00
 monthly_invoice_end_date0000-00-00
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionEast Oahu Realty is the exclusive representative for Leverage Global Partners in Honolulu, Oahu, Hawaii, USA. In 1992, Jack Leslein, President & Founder of East Oahu Realty, Inc., ventured forward with his dream of creating a real estate company of Realtors that would make a difference. Our mission is to be a pacesetter in real estate services by sharing our knowledge and skillfully guiding our clients beyond their expectations. Specializing in helping clients achieve their real estate objectives and focusing on personalized service and attention, East Oahu Realty became the home of trained and experienced Realtors, state of the art technology and dedicated support staff. East Oahu Realty is able to provide the utmost in professional real estate service. As a locally owned, Kama’aina company, we respect and value our island heritage. We are committed to enhancing the lives of those who reside here by providing the utmost in service and community support. We know our market as well as the economic and social factors that shape it. Our knowledge, combined with our broad base of experience, assures you have the information you need to make an informed decision. We are committed to your success, and we are leaders in our industry and our community. We take an active role in shaping the future of both. We are committed to maintaining our reputation of integrity and honesty. We represent our clients enthusiastically and fairly and have done so since 1992. Choosing can make all the difference. What Our Clients Can Expect: <ul> <li>Premier Market Presence</li> <li>Select Team of Successful Real Estate Professionals</li> <li>Global Networking and Exposure</li> <li>Comprehensive Market Analysis & Plans</li> <li>Member of Luxury Real Estate</li> <li>State of the Art Technology</li> <li>Multi-Lingual Realtors</li> <li>Mortgage Services On-Site</li> </ul>
 communitiesHonolulu Hawaii HI USA Oahu Hawaii HI USA
 websitehttp://www.eastoahu.com/
 address6600 Kalanianaole Hwy # 114
 address_2
 cityHonolulu, Oahu
 stateHI
 full_stateHawaii
 countryUSA
 market
 market_2
 postal_code96825
 phone(808) 791-2216
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameCherie Tsukamoto
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titlePrincipal Broker, RB - 14911
 contact_dre_num
 contact_quoteI invite you to contact me personally regarding East Oahu Realty.
 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_filename28.jpg
 logo_filename28.jpg
 contact_image_filename28.jpg
 all_properties_link_image_filename28.jpg
 all_properties_linkhttp://www.eastoahu.com/search/FeaturedListings.aspx
 video_embed_code<script type="text/javascript" src="http://videocontent.jloop.com/players/4U1wTm0Z-qzxAOUo0.js"></script>
 contact_video_embed_code
 meta_titleHonolulu, Oahu Real Estate | East Oahu Realty | Leverage Global Partners
 meta_descriptionEast Oahu Realty is the exclusive representative for Leverage Global Partners in Oahu, Hawaii, USA.
 meta_keywordseast oahu realty, oahu real estate, honolulu real estate, oahu hawaii, jack leslein, leverage global partners
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2013-05-10 18:19:12
 modified2016-04-08 16:33:22
 dre_num012345
 uri/brokerage-detail/28/east-oahu-realty-rb-16090
 website_shortwww.eastoahu.com
 name_with_locationEast Oahu Realty, RB-16090
 Image(array)
 id2956
 modelLocation
 model_id32
 tagImage
 nameeast oahu realty.jpg
 typeimage/jpeg
 size148264
 uri/assets/2956.jpg
 order0
 created2016-04-04 11:41:09
 modified2016-04-04 12:03:35
- highlighted_properties(array)
 0(array)
 Property(array)
 id2467
 brokerage_id28
 created_by_user_id0
 order1
 multi_unit(false)
 agent_1_id666
 agent_2_id0
 agent_3_id0
 namePortlocks Newest Spec Home...
 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)
 descriptionNALU VUE, Portlock's Newest Spec Home to be built, w/180 degree views of Diamond Head and Ocean, Top of Cul-de-sac, very private, infinity pool (to be completed), contemporary design, and Buyers can choose finishes and cabinetry! Buyers can view the lot by appointment. Building plans are underway and are subject to approval by the Architectural Review Committee for the Neighborhood Community Assn. and the Building Dept. prior to commencement of construction.
 address271 Makaweli Place
 address_2
 cityHonolulu
 stateHI
 postal_code96825
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price4200000
 price_20
 price_usd4200000
 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
 bathrooms5
 bathrooms_20
 no_beds_baths(false)
 square_feet0
 square_meters
 acres0
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size0
 icon_1
 icon_2
 icon_3
 icon_4
 icon_5
 icon_6
 website
 meta_titlePortlocks Newest Spec Home... | Honolulu Real Estate | East Oahu Realty, RB-16090
 meta_description271 Makaweli Place is a property offered for sale in Honolulu, HI, USA, presented by East Oahu Realty, RB-16090
 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_fields
 invalid_optional_fieldsagent_2_id, bathrooms_partial, square_feet, square_meters, acres, hectares, virtual_tour, video_tour
 went_live_today(false)
 converted(true)
 invalid(false)
 mlsidx_full_address
 mlsidx_date_listed0000-00-00
 mls_market
 primary_property_category_id0
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated(null)
 modified2016-04-18 05:33:02
 created2015-07-15 15:40:58
 uri/property-detail/2467/271-makaweli-place-honolulu-hi-96825-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/2467/271-makaweli-place-honolulu-hi-96825-usa
 address_concat271 Makaweli Place Honolulu HI 96825 USA
 google_maps_query_string271+Makaweli+Place++Honolulu+HI+96825+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 4,200,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty4
 bathrooms_pretty5
 bathrooms_partial_pretty0
 bathrooms_3_4_pretty0
 feed_full_bathrooms5
 date_listed2015-07-15
 overridden_brokerage_nameEast Oahu Realty, RB-16090
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id28
 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_id1
 WOEID12485533
 timezoneUS/Hawaii
 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
 nameEast Oahu Realty, RB-16090
 broker_of_record_name
 short_nameEast Oahu Realty
 usernameEastOahu
 password184254dea91b6c8586489ec50b8219bece099e54
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date0000-00-00
 monthly_invoice_end_date0000-00-00
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionEast Oahu Realty is the exclusive representative for Leverage Global Partners in Honolulu, Oahu, Hawaii, USA. In 1992, Jack Leslein, President & Founder of East Oahu Realty, Inc., ventured forward with his dream of creating a real estate company of Realtors that would make a difference. Our mission is to be a pacesetter in real estate services by sharing our knowledge and skillfully guiding our clients beyond their expectations. Specializing in helping clients achieve their real estate objectives and focusing on personalized service and attention, East Oahu Realty became the home of trained and experienced Realtors, state of the art technology and dedicated support staff. East Oahu Realty is able to provide the utmost in professional real estate service. As a locally owned, Kama’aina company, we respect and value our island heritage. We are committed to enhancing the lives of those who reside here by providing the utmost in service and community support. We know our market as well as the economic and social factors that shape it. Our knowledge, combined with our broad base of experience, assures you have the information you need to make an informed decision. We are committed to your success, and we are leaders in our industry and our community. We take an active role in shaping the future of both. We are committed to maintaining our reputation of integrity and honesty. We represent our clients enthusiastically and fairly and have done so since 1992. Choosing can make all the difference. What Our Clients Can Expect: <ul> <li>Premier Market Presence</li> <li>Select Team of Successful Real Estate Professionals</li> <li>Global Networking and Exposure</li> <li>Comprehensive Market Analysis & Plans</li> <li>Member of Luxury Real Estate</li> <li>State of the Art Technology</li> <li>Multi-Lingual Realtors</li> <li>Mortgage Services On-Site</li> </ul>
 communitiesHonolulu Hawaii HI USA Oahu Hawaii HI USA
 websitehttp://www.eastoahu.com/
 address6600 Kalanianaole Hwy # 114
 address_2
 cityHonolulu, Oahu
 stateHI
 full_stateHawaii
 countryUSA
 market
 market_2
 postal_code96825
 phone(808) 791-2216
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameCherie Tsukamoto
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titlePrincipal Broker, RB - 14911
 contact_dre_num
 contact_quoteI invite you to contact me personally regarding East Oahu Realty.
 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_filename28.jpg
 logo_filename28.jpg
 contact_image_filename28.jpg
 all_properties_link_image_filename28.jpg
 all_properties_linkhttp://www.eastoahu.com/search/FeaturedListings.aspx
 video_embed_code<script type="text/javascript" src="http://videocontent.jloop.com/players/4U1wTm0Z-qzxAOUo0.js"></script>
 contact_video_embed_code
 meta_titleHonolulu, Oahu Real Estate | East Oahu Realty | Leverage Global Partners
 meta_descriptionEast Oahu Realty is the exclusive representative for Leverage Global Partners in Oahu, Hawaii, USA.
 meta_keywordseast oahu realty, oahu real estate, honolulu real estate, oahu hawaii, jack leslein, leverage global partners
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2013-05-10 18:19:12
 modified2016-04-08 16:33:22
 dre_num012345
 uri/brokerage-detail/28/east-oahu-realty-rb-16090
 website_shortwww.eastoahu.com
 name_with_locationEast Oahu Realty, RB-16090
 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)
 id15775
 modelProperty
 model_id2467
 tagImage
 name23171.jpg
 typeimage/jpg
 size422153
 uri/assets/15775.jpg
 order0
 created2016-04-07 16:54:04
 modified2016-04-07 16:54:04
 1(array)
 id15779
 modelProperty
 model_id2467
 tagImage
 name23175.jpg
 typeimage/jpg
 size207006
 uri/assets/15779.jpg
 order1
 created2016-04-07 16:54:04
 modified2016-04-07 16:54:04
 2(array)
 id15773
 modelProperty
 model_id2467
 tagImage
 name23169.jpg
 typeimage/jpg
 size111981
 uri/assets/15773.jpg
 order2
 created2016-04-07 16:54:04
 modified2016-04-07 16:54:04
 3(array)
 id15776
 modelProperty
 model_id2467
 tagImage
 name23172.jpg
 typeimage/jpg
 size419982
 uri/assets/15776.jpg
 order3
 created2016-04-07 16:54:04
 modified2016-04-07 16:54:04
 4(array)
 id15774
 modelProperty
 model_id2467
 tagImage
 name23170.jpg
 typeimage/jpg
 size520101
 uri/assets/15774.jpg
 order4
 created2016-04-07 16:54:04
 modified2016-04-07 16:54:04
 5(array)
 id15777
 modelProperty
 model_id2467
 tagImage
 name23173.jpg
 typeimage/jpg
 size256224
 uri/assets/15777.jpg
 order5
 created2016-04-07 16:54:04
 modified2016-04-07 16:54:04
 6(array)
 id15778
 modelProperty
 model_id2467
 tagImage
 name23174.jpg
 typeimage/jpg
 size449446
 uri/assets/15778.jpg
 order6
 created2016-04-07 16:54:04
 modified2016-04-07 16:54:04
 User(array)
 0(array)
 id863
 typeAgent
 brokerage_id28
 email[email protected]
 passworddc19fdc8e842b5f31166915169eabffd6ddda1a7
 recover_hash
 first_nameDouglas
 last_nameSmith
 title
 dre_num
 phone808-330-3673
 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_nameDouglas Smith
 uri/agent-detail/863/douglas-smith
 profile_complete(true)
 UsersProperty(array)
 id614
 user_id863
 property_id2467
 sort_order0
 SecondaryPropertyCategory(empty)
 PropertyFeature(empty)
 Topic(empty)
 1(array)
 Property(array)
 id3696
 brokerage_id28
 created_by_user_id0
 order4
 multi_unit(false)
 agent_1_id1219
 agent_2_id0
 agent_3_id0
 nameSpectacular Views - Completely Remodeled
 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)
 descriptionEvery square foot of this spectacular architect remodel is designed for both use and beauty. With gorgeous views and brand new high-end finishes, this home shines above all others. Designer features include Viaterra LG quartz island with waterfall edges,U-line wine cooler, 7 ft Bosch refrigerator, Vigo sinks and faucets, Schuler custom cabinetry, walk-in pantry, fossilized bamboo flooring (janka 5000 +), all new plumbing windows and electric (LED lighting), a private en suite for guests, a master bedroom and bath you will want to lounge in and so much more. Kitchen <ul> <li>LG Quartz Viaterra 9-foot island with waterfall edges</li> <li>U–Line wine/beverage refrigerator</li> <li>Vigo stainless steel under mount sink with disposal</li> <li>Bosch range with warming drawer</li> <li>Bosch range hood with rear exhaust</li> <li>7-foot Bosch built-in refrigerator</li> <li>Schuler solid wood custom soft close cabinets</li> <li>Bosch built-in microwave</li> <li>Carrera marble, glass, & granite back splash</li> <li>Exhibit gallery with down lighting</li> <li>Many built-ins with room for trays and silverware</li> <li>Walk-in pantry</li> </ul> Great Room <ul> <li>70-inch flat screen television wall hung</li> <li>Windows all new double pane filled with super argon – nearly zero heat transmittal from outside to inside!</li> <li>Ocean views</li> <li>Comfortable dining</li> <li>Beautiful glass railings</li> <li>Built-in yet discreet storage</li> </ul> Large Lanai Flooring <ul> <li>Fossilized hardwood bamboo (Janka 5000+) with satin finish</li> <li>Porcelain tile in baths and laundry</li> </ul> All New <ul> <li>Windows- double pane outside to inside</li> <li>Plumbing and electric with nearly all LED lighting</li> <li>Wood shake roof</li> </ul> Master Bedroom <ul> <li>14 foot in height walk in closet with skylight, window and built-ins</li> <li>Picture perfect view of Diamond Head</li> </ul> Master Bath <ul> <li>Pebble tile wall next to soaking tub</li> <li>Double sink, vigo faucets, inset mirror with sconce lighting</li> <li>Shower with fixed jets and custom treated glass</li> </ul> Entry <ul> <li>Custom Koa door restored and with carved insets</li> <li>Art alcove with lighting</li> </ul> Laundry Room <ul> <li>Tiled</li> <li>Utility sink with granite counters</li> <li>Hanging area for delicates</li> <li>New Samsung Washer and Dryer</li> </ul> Guest Room 1 <ul> <li>Soffit Lighting</li> <li>Ocean View</li> </ul> Guest Bath <ul> <li>Custom glass oversized shower</li> <li>Gracious porcelain tile on floor and walls</li> </ul> Guest Room 2 <ul> <li>En suite with lovely bath</li> <li>Skylight in bath</li> <li>Ovesized tiled shower</li> <li>Closet with built-ins</li> </ul> Garage <ul> <li>New door and remotes</li> <li>Concrete floor with rubberized matting</li> <li>Garage refrigerator</li> <li>Skylight</li> <li>Lots of storage</li> </ul> 
 address357 Lelekepue Place
 address_2
 cityHonolulu
 stateHawaii
 postal_code96821
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price2485000
 price_20
 price_usd2485000
 price_usd_20
 statusFor Sale
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(false)
 bedrooms4
 bedrooms_20
 bathrooms4
 bathrooms_20
 no_beds_baths(false)
 square_feet0
 square_meters
 acres0
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size0
 icon_1pool
 icon_2views
 icon_3balcony-terrace
 icon_4
 icon_5
 icon_6
 websitehttp://www.eastoahu.com/listing/140036438-150082085/357-lelekepue-place-honolulu-hi-96821/
 meta_titleSpectacular Views - Completely Remodeled | Honolulu Real Estate | East Oahu Realty, RB-16090
 meta_description357 Lelekepue Place is a property offered for sale in Honolulu, Hawaii, USA, presented by East Oahu Realty, RB-16090
 meta_keywords
 bathrooms_partial0
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built
 virtual_tour
 video_tourhttp://tour.circlepix.com/tour/blaze/?tourId=3476873&version=unbranded
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num
 wsj_property_type
 nyt_property_type
 nyt_popular_features
 propgolux_property_type
 juwai_property_type
 juwai_category
 propgolux_property_style
 wapo_property_type
 robb_property_type
 propgolux_location_id_override
 open_house_1_start0000-00-00 00:00:00
 open_house_1_end_time00:00:00
 latitude0.000000
 longitude0.000000
 invalid_required_fields
 invalid_optional_fieldsagent_2_id, bathrooms_partial, square_feet, square_meters, acres, hectares, virtual_tour
 went_live_today(false)
 converted(true)
 invalid(false)
 mlsidx_full_address
 mlsidx_date_listed0000-00-00
 mls_market
 primary_property_category_id0
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated(null)
 modified2016-04-18 05:33:03
 created2016-04-04 13:55:03
 uri/property-detail/3696/357-lelekepue-place-honolulu-hawaii-96821-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3696/357-lelekepue-place-honolulu-hawaii-96821-usa
 address_concat357 Lelekepue Place Honolulu Hawaii 96821 USA
 google_maps_query_string357+Lelekepue+Place++Honolulu+Hawaii+96821+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 2,485,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty4
 bathrooms_pretty4
 bathrooms_partial_pretty0
 bathrooms_3_4_pretty0
 feed_full_bathrooms4
 date_listed2016-04-04
 overridden_brokerage_nameEast Oahu Realty, RB-16090
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id28
 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_id1
 WOEID12485533
 timezoneUS/Hawaii
 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
 nameEast Oahu Realty, RB-16090
 broker_of_record_name
 short_nameEast Oahu Realty
 usernameEastOahu
 password184254dea91b6c8586489ec50b8219bece099e54
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date0000-00-00
 monthly_invoice_end_date0000-00-00
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionEast Oahu Realty is the exclusive representative for Leverage Global Partners in Honolulu, Oahu, Hawaii, USA. In 1992, Jack Leslein, President & Founder of East Oahu Realty, Inc., ventured forward with his dream of creating a real estate company of Realtors that would make a difference. Our mission is to be a pacesetter in real estate services by sharing our knowledge and skillfully guiding our clients beyond their expectations. Specializing in helping clients achieve their real estate objectives and focusing on personalized service and attention, East Oahu Realty became the home of trained and experienced Realtors, state of the art technology and dedicated support staff. East Oahu Realty is able to provide the utmost in professional real estate service. As a locally owned, Kama’aina company, we respect and value our island heritage. We are committed to enhancing the lives of those who reside here by providing the utmost in service and community support. We know our market as well as the economic and social factors that shape it. Our knowledge, combined with our broad base of experience, assures you have the information you need to make an informed decision. We are committed to your success, and we are leaders in our industry and our community. We take an active role in shaping the future of both. We are committed to maintaining our reputation of integrity and honesty. We represent our clients enthusiastically and fairly and have done so since 1992. Choosing can make all the difference. What Our Clients Can Expect: <ul> <li>Premier Market Presence</li> <li>Select Team of Successful Real Estate Professionals</li> <li>Global Networking and Exposure</li> <li>Comprehensive Market Analysis & Plans</li> <li>Member of Luxury Real Estate</li> <li>State of the Art Technology</li> <li>Multi-Lingual Realtors</li> <li>Mortgage Services On-Site</li> </ul>
 communitiesHonolulu Hawaii HI USA Oahu Hawaii HI USA
 websitehttp://www.eastoahu.com/
 address6600 Kalanianaole Hwy # 114
 address_2
 cityHonolulu, Oahu
 stateHI
 full_stateHawaii
 countryUSA
 market
 market_2
 postal_code96825
 phone(808) 791-2216
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameCherie Tsukamoto
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titlePrincipal Broker, RB - 14911
 contact_dre_num
 contact_quoteI invite you to contact me personally regarding East Oahu Realty.
 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_filename28.jpg
 logo_filename28.jpg
 contact_image_filename28.jpg
 all_properties_link_image_filename28.jpg
 all_properties_linkhttp://www.eastoahu.com/search/FeaturedListings.aspx
 video_embed_code<script type="text/javascript" src="http://videocontent.jloop.com/players/4U1wTm0Z-qzxAOUo0.js"></script>
 contact_video_embed_code
 meta_titleHonolulu, Oahu Real Estate | East Oahu Realty | Leverage Global Partners
 meta_descriptionEast Oahu Realty is the exclusive representative for Leverage Global Partners in Oahu, Hawaii, USA.
 meta_keywordseast oahu realty, oahu real estate, honolulu real estate, oahu hawaii, jack leslein, leverage global partners
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2013-05-10 18:19:12
 modified2016-04-08 16:33:22
 dre_num012345
 uri/brokerage-detail/28/east-oahu-realty-rb-16090
 website_shortwww.eastoahu.com
 name_with_locationEast Oahu Realty, RB-16090
 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)
 id20546
 modelProperty
 model_id3696
 tagImage
 name35941.jpg
 typeimage/jpg
 size1076687
 uri/assets/20546.jpg
 order0
 created2016-04-07 17:33:54
 modified2016-04-07 17:33:54
 1(array)
 id20548
 modelProperty
 model_id3696
 tagImage
 name35943.jpg
 typeimage/jpg
 size1031168
 uri/assets/20548.jpg
 order1
 created2016-04-07 17:33:54
 modified2016-04-07 17:33:54
 2(array)
 id20547
 modelProperty
 model_id3696
 tagImage
 name35942.jpg
 typeimage/jpg
 size1115161
 uri/assets/20547.jpg
 order2
 created2016-04-07 17:33:54
 modified2016-04-07 17:33:54
 3(array)
 id20549
 modelProperty
 model_id3696
 tagImage
 name35944.jpg
 typeimage/jpg
 size1038905
 uri/assets/20549.jpg
 order3
 created2016-04-07 17:33:54
 modified2016-04-07 17:33:54
 4(array)
 id20551
 modelProperty
 model_id3696
 tagImage
 name35947.jpg
 typeimage/jpg
 size1101363
 uri/assets/20551.jpg
 order4
 created2016-04-07 17:33:54
 modified2016-04-07 17:33:55
 5(array)
 id20550
 modelProperty
 model_id3696
 tagImage
 name35945.jpg
 typeimage/jpg
 size977516
 uri/assets/20550.jpg
 order5
 created2016-04-07 17:33:54
 modified2016-04-07 17:33:54
 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)
 id4349
 property_id3696
 property_feature_id12
 1(array)
 id14
 nameViews
 additional(false)
 created2016-04-07 14:04:55
 modified2016-04-07 14:04:55
 PropertiesPropertyFeature(array)
 id4350
 property_id3696
 property_feature_id14
 2(array)
 id1
 nameBalcony/Terrace
 additional(false)
 created2016-04-07 14:00:26
 modified2016-04-07 14:00:26
 PropertiesPropertyFeature(array)
 id4351
 property_id3696
 property_feature_id1
 Topic(empty)
- custom_ga_event_properties(array)
 brokerageEast Oahu Realty, RB-16090, Honolulu, Oahu
- property(array)
 Property(array)
 id3142
 brokerage_id28
 created_by_user_id0
 order3
 multi_unit(false)
 agent_1_id1049
 agent_2_id0
 agent_3_id0
 namePRIME LOCATION!
 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)
 descriptionPrime location! Great value! Best price per square foot of beachside Portlock, one lot in from beautiful Maunalua Bay. Steps from a sandy beach where you can enjoy ocean, sunset and Diamond Head views. Easy ocean access for water sports. Spacious two story, contemporary-style home. Features versatile floorplan, marble & hardwood flooring, gourmet kitchen, laundry room, vaulted ceilings and covered lanai. Private second floor master suite opens to a large roof deck. Lush tropical landscaping on a large level lot. Room for a pool and/or tennis court.
 address243 Portlock Road
 address_2
 cityHonolulu
 stateHI
 postal_code96825
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price2650000
 price_20
 price_usd2650000
 price_usd_20
 statusFor Sale
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(false)
 bedrooms6
 bedrooms_20
 bathrooms3
 bathrooms_20
 no_beds_baths(false)
 square_feet0
 square_meters
 acres0
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size0
 icon_1
 icon_2
 icon_3
 icon_4
 icon_5
 icon_6
 website
 meta_titlePRIME LOCATION! | Honolulu Real Estate | East Oahu Realty, RB-16090
 meta_description243 Portlock Road is a property offered for sale in Honolulu, HI, USA, presented by East Oahu Realty, RB-16090
 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_fields
 invalid_optional_fieldsagent_2_id, bathrooms_partial, square_feet, square_meters, acres, hectares, virtual_tour, video_tour
 went_live_today(false)
 converted(true)
 invalid(false)
 mlsidx_full_address
 mlsidx_date_listed0000-00-00
 mls_market
 primary_property_category_id0
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated(null)
 modified2016-04-18 05:33:02
 created2015-11-23 15:52:28
 uri/property-detail/3142/243-portlock-road-honolulu-hi-96825-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3142/243-portlock-road-honolulu-hi-96825-usa
 address_concat243 Portlock Road Honolulu HI 96825 USA
 google_maps_query_string243+Portlock+Road++Honolulu+HI+96825+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 2,650,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty6
 bathrooms_pretty3
 bathrooms_partial_pretty0
 bathrooms_3_4_pretty0
 feed_full_bathrooms3
 date_listed2015-11-23
 overridden_brokerage_nameEast Oahu Realty, RB-16090
 overridden_brokerage_logo_uri/assets/2314.jpg
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id28
 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_id1
 WOEID12485533
 timezoneUS/Hawaii
 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
 nameEast Oahu Realty, RB-16090
 broker_of_record_name
 short_nameEast Oahu Realty
 usernameEastOahu
 password184254dea91b6c8586489ec50b8219bece099e54
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date0000-00-00
 monthly_invoice_end_date0000-00-00
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionEast Oahu Realty is the exclusive representative for Leverage Global Partners in Honolulu, Oahu, Hawaii, USA. In 1992, Jack Leslein, President & Founder of East Oahu Realty, Inc., ventured forward with his dream of creating a real estate company of Realtors that would make a difference. Our mission is to be a pacesetter in real estate services by sharing our knowledge and skillfully guiding our clients beyond their expectations. Specializing in helping clients achieve their real estate objectives and focusing on personalized service and attention, East Oahu Realty became the home of trained and experienced Realtors, state of the art technology and dedicated support staff. East Oahu Realty is able to provide the utmost in professional real estate service. As a locally owned, Kama’aina company, we respect and value our island heritage. We are committed to enhancing the lives of those who reside here by providing the utmost in service and community support. We know our market as well as the economic and social factors that shape it. Our knowledge, combined with our broad base of experience, assures you have the information you need to make an informed decision. We are committed to your success, and we are leaders in our industry and our community. We take an active role in shaping the future of both. We are committed to maintaining our reputation of integrity and honesty. We represent our clients enthusiastically and fairly and have done so since 1992. Choosing can make all the difference. What Our Clients Can Expect: <ul> <li>Premier Market Presence</li> <li>Select Team of Successful Real Estate Professionals</li> <li>Global Networking and Exposure</li> <li>Comprehensive Market Analysis & Plans</li> <li>Member of Luxury Real Estate</li> <li>State of the Art Technology</li> <li>Multi-Lingual Realtors</li> <li>Mortgage Services On-Site</li> </ul>
 communitiesHonolulu Hawaii HI USA Oahu Hawaii HI USA
 websitehttp://www.eastoahu.com/
 address6600 Kalanianaole Hwy # 114
 address_2
 cityHonolulu, Oahu
 stateHI
 full_stateHawaii
 countryUSA
 market
 market_2
 postal_code96825
 phone(808) 791-2216
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameCherie Tsukamoto
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titlePrincipal Broker, RB - 14911
 contact_dre_num
 contact_quoteI invite you to contact me personally regarding East Oahu Realty.
 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_filename28.jpg
 logo_filename28.jpg
 contact_image_filename28.jpg
 all_properties_link_image_filename28.jpg
 all_properties_linkhttp://www.eastoahu.com/search/FeaturedListings.aspx
 video_embed_code<script type="text/javascript" src="http://videocontent.jloop.com/players/4U1wTm0Z-qzxAOUo0.js"></script>
 contact_video_embed_code
 meta_titleHonolulu, Oahu Real Estate | East Oahu Realty | Leverage Global Partners
 meta_descriptionEast Oahu Realty is the exclusive representative for Leverage Global Partners in Oahu, Hawaii, USA.
 meta_keywordseast oahu realty, oahu real estate, honolulu real estate, oahu hawaii, jack leslein, leverage global partners
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2013-05-10 18:19:12
 modified2016-04-08 16:33:22
 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)
 id2314
 modelBrokerage
 model_id28
 tagLogo
 name28.jpg
 typeimage/jpg
 size1014629
 uri/assets/2314.jpg
 order0
 created2016-03-30 11:37:31
 modified2016-03-30 11:37:31
 MainImage(array)
 id2313
 modelBrokerage
 model_id28
 tagMainImage
 name28.jpg
 typeimage/jpg
 size1247835
 uri/assets/2313.jpg
 order0
 created2016-03-30 11:37:30
 modified2016-03-30 11:37:30
 ContactImage(array)
 id2315
 modelBrokerage
 model_id28
 tagContactImage
 name28.jpg
 typeimage/jpg
 size1553010
 uri/assets/2315.jpg
 order0
 created2016-03-30 11:37:31
 modified2016-03-30 11:37:31
 ContactImage2(empty)
 ContactImage3(empty)
 BrokerOfRecordLogo(empty)
 MainArticle(array)
 id58
 modelBrokerage
 model_id28
 archived(false)
 medium_featured(false)
 large_featured(false)
 titleMeet Jack Leslein: Owner of East Oahu Realty, Oahu
 authorLeverageRE
 date2013-07-06
 lead_inIn 1992, Jack Leslein, Owner of East Oahu Realty, ventured forward with his dream of creating a company of agents that would make a difference, not only in the lives of their customers, but in the community at large. To that end, he recruited experienced, highly successful Realtors who shared both his core values and principles. Jack’s key principle of servant leadership shaped the foundation of the company and continues to permeate every aspect of the company's decision-making today.
 body In order to forge ahead with his dream of building a customer-centric company, Jack sold his own home to raise capital. His willingness to give up his home is just one example of the selflessness that Jack has exhibited at East Oahu Realty throughout the years. He remains a leader with a servant’s heart and continues to exemplify the importance of putting others first. <img class="wp-image-1083 pure-img float-right" src="/assets/154.jpg" alt="Jack Leslein" width="351" height="491" srcset="http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/Jack-Leslein-585x819.jpg 585w, http://www.leveragere.com/leverage-lifestyle/wp-content/uploads/Jack-Leslein.jpg 1500w" sizes="(max-width: 351px) 100vw, 351px">Jack is very pleased with the difference East Oahu Realty (EOR) has made within the lives of both its clients and its agents. With a focus on high touch and personalized service, clients have come to count on East Oahu Realty and its agents, knowing that no matter the challenge, they will be met with genuine care and concern. Agents have come to know East Oahu Realty as home. The solid principles that built the company continue to be a driving force, providing the necessary support for each individual member of the team to succeed. Together, the East Oahu Realty team has made a difference in countless lives and in the community at large. Raising funds for handicapped children, cleaning the highway, supporting local schools, adopting a deployed squadron, walking for life, and contributing to the Rotary Club and various organizations are just a few of the ways East Oahu Realty has made a difference. Of course, the biggest differences occur as relationships are built, trust is established, and lifetime bonds are formed. Living and working on the island of Oahu provide reasons to give thanks daily. Their aina (land) is blessed with spectacular beauty and weather, but what Jack and the team love most about Oahu is its people. The diversity of cultures, the sense of ohana (family), and the "Spirit of Aloha" that defines their island combine to create a community unlike any other. Jack's family has played an integral role in East Oahu Realty, as well. He started the company with his wife, Shirley, by his side, and they continue to partner in the decisions that drive the company. Jack’s daughter, Kim Leslein-Soares, is the Executive Vice-President of the company, and she shares both Jack’s vision and his management philosophy. Jack is an entertainer at heart. Before adventuring into real estate, he worked in theatre and still loves to dance. He has also worked in the hotel and banquet business, as well as had an earlier stint in the automotive and the appliance industries. Real estate came later in Jack’s life, but his dream of serving people through making a difference in their lives was forged in his younger years and is in large part a result of his value-centered upbringing. Jack’s turning point occurred when he worked for a real estate company whose philosophy did not match his own. He knew without a doubt that he could do a better job by creating a company that focused on what mattered – customer service and care. He also knew that he could provide agents with an environment that fostered support and encouraged them to achieve their own individual dreams. Technology has its place at East Oahu Realty, as well, as it has implemented new technologies that provide agents with all of the necessary tools to meet their clients’ needs. Social media is an integral part of their communication, along with their paperless philosophy and Internet capabilities, but there is still no substitute for strong personal bonds forged over the years. Jack’s number one outside interest is his family, especially his seven adorable grandchildren. If he isn’t attending one of their sports events, dance recitals or canoe races, he can probably be spotted watching a Red Wings hockey game or a tennis match. Colleagues, friends and clients all describe Jack the same way – he is diplomatic, fair, kind, and generous. He is a lover of people and they love him in return. He is known to be a great diffuser and he has the ability to listen objectively and to solve issues readily. These character qualities combine to make him a great leader and an even better team player. Leverage Global Partners is pleased to have Jack Leslein and East Oahu Realty on board. Header photo courtesy of <a href="http://www.flickr.com/photos/42202689@N00/6797282918/in/photolist-bmDRp5-bzyHPR-bmDRkC-bmDRrG-bmDQRw-bmDRiW-bzyJ28-bzyHVx-bzyJ3M-bzyJdc-bzyJ5n-bzyHTz-bzyHXt-bzyHER-bmDRxh-bmDR2w-bzyJ12-bzyJ76-bmDRuy-bmDQUd-bmDRhy-8kyqCb-8kxBd2-8kxKc9-8kzQnY-8kwzEz-8kxGVg-8kxCQc-8kAWHQ-84LTG8-8kxEKc-8kyCV9-8kyGGU-8kytA9-8kyw9C-8kRgav-8kyzDy-8kydHq-8kuW2n-8kxUBb-8kuQGe-8kygsU-8kyaDG-8ky5Dq-8kuAHR-8kuLEe-8kuEaH-8dQfcV-8kThe1-8kTdPs-8kPTjD" target="_blank">Temur Madjderey’s Flickr</a>
 vimeo_id
 created2016-02-25 14:08:38
 modified2016-04-05 14:41:06
 uri/articles/view/58/meet-jack-leslein-owner-of-east-oahu-realty-oahu
 FeaturedImage(empty)
 Location(array)
 0(array)
 id32
 parent_id9
 brokerage_id28
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameHonolulu, Oahu, HI, USA
 short_nameHonolulu, Oahu, HI, USA
 group_index
 latitude21.296232
 longitude-157.701981
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_descriptionHonolulu, Oahu: Paradise has been found and it's calling your name!
 long_descriptionWhether you’re a sun-seeker, metropolitan maven, or adventure addict, Honolulu is the place to be! Located on beautiful Oahu, also known as the “The Gathering Place”, Hawaii’s most populous city is an alluring melting pot of cultures and cuisines. The relaxed lifestyle and ‘Aloha’ spirit will keep your mind at ease while our stunning mountains and pristine beaches keep you young and active. From famous historical sites to secluded natural treasures, residents here enjoy a boundless supply of scenic beauty and rejuvenating adventure. Also boasting world-class shopping, commerce and entertainment, you are sure to find your place in the sun!
 created2016-04-04 12:01:25
 modified2016-04-04 12:03:35
 timezonePacific/Honolulu
 population953000
 uri/locations/view/32/honolulu-oahu-hi-usa
 tile_nameHonolulu, Oahu, HI, USA
 User(array)
 0(array)
 id79
 typeBrokerageAdmin
 brokerage_id28
 email[email protected]
 password184254dea91b6c8586489ec50b8219bece099e54
 recover_hash
 first_nameCherie
 last_nameTsukamoto
 title
 dre_num
 phone
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2016-04-12 08:26:08
 created2016-04-08 16:33:22
 notified(true)
 full_nameCherie Tsukamoto
 uri/agent-detail/79/cherie-tsukamoto
 profile_complete(true)
 1(array)
 id862
 typeAgent
 brokerage_id28
 email[email protected]
 password9f9c78a0846c951e32c57f03f3ca25b40061c580
 recover_hash
 first_nameSharon
 last_nameChai
 title
 dre_num
 phone808-396-2000
 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_nameSharon Chai
 uri/agent-detail/862/sharon-chai
 profile_complete(true)
 2(array)
 id863
 typeAgent
 brokerage_id28
 email[email protected]
 passworddc19fdc8e842b5f31166915169eabffd6ddda1a7
 recover_hash
 first_nameDouglas
 last_nameSmith
 title
 dre_num
 phone808-330-3673
 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_nameDouglas Smith
 uri/agent-detail/863/douglas-smith
 profile_complete(true)
 3(array)
 id864
 typeAgent
 brokerage_id28
 email[email protected]
 passwordab336aeaf5c31097093f9695dacb71bd8ed4458d
 recover_hash
 first_nameAgen
 last_nameTwo
 title
 dre_num
 phone808-396-2000
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:42
 created2017-08-07 15:23:42
 notified(false)
 full_nameAgen Two
 uri/agent-detail/864/agen-two
 profile_complete(true)
 4(array)
 id865
 typeAgent
 brokerage_id28
 email[email protected]
 password7208bb849fbe9c54831879897bbdd9016bdb709e
 recover_hash
 first_nameAaron P.
 last_nameTeves
 title
 dre_num
 phone8083962000
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:42
 created2017-08-07 15:23:42
 notified(false)
 full_nameAaron P. Teves
 uri/agent-detail/865/aaron-p-teves
 profile_complete(true)
 5(array)
 id866
 typeAgent
 brokerage_id28
 email[email protected]
 passwordb7172455999adc677fb13e8b629e8394add6f34b
 recover_hash
 first_nameKimberly
 last_nameSoares
 title
 dre_num
 phone808-396-2000
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:42
 created2017-08-07 15:23:42
 notified(false)
 full_nameKimberly Soares
 uri/agent-detail/866/kimberly-soares
 profile_complete(true)
 6(array)
 id1110
 typeAgent
 brokerage_id28
 email[email protected]
 passwordea9fad05586fcbe555729c8060985522a5247b3b
 recover_hash
 first_nameDan
 last_nameMadden
 title
 dre_num
 phone808-384-9933
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:54
 created2017-08-07 15:23:54
 notified(false)
 full_nameDan Madden
 uri/agent-detail/1110/dan-madden
 profile_complete(true)
 7(array)
 id1113
 typeAgent
 brokerage_id28
 email[email protected]
 password4a88ec85a1cd9683068317e0a535705bcbc8f34f
 recover_hash
 first_nameConstance K
 last_nameCarr
 title
 dre_num
 phone808-286-5409
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:23:54
 created2017-08-07 15:23:54
 notified(false)
 full_nameConstance K Carr
 uri/agent-detail/1113/constance-k-carr
 profile_complete(true)
 8(array)
 id1276
 typeAgent
 brokerage_id28
 email[email protected]
 passworda992f8ca84fdd6442933402b26af8813256403e7
 recover_hash
 first_nameSakina
 last_nameClaytor
 title
 dre_num
 phone808-594-9044
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:24:02
 created2017-08-07 15:24:02
 notified(false)
 full_nameSakina Claytor
 uri/agent-detail/1276/sakina-claytor
 profile_complete(true)
 uri/brokerage-detail/28/east-oahu-realty-rb-16090
 website_shortwww.eastoahu.com
 name_with_locationEast Oahu Realty, RB-16090 - Honolulu, Oahu, HI, 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)
 id16760
 modelProperty
 model_id3142
 tagImage
 name30159.jpg
 typeimage/jpg
 size482238
 uri/assets/16760.jpg
 order0
 created2016-04-07 17:00:07
 modified2016-04-07 17:00:07
 1(array)
 id16754
 modelProperty
 model_id3142
 tagImage
 name30165.jpg
 typeimage/jpg
 size654393
 uri/assets/16754.jpg
 order1
 created2016-04-07 17:00:07
 modified2016-04-07 17:00:07
 2(array)
 id16759
 modelProperty
 model_id3142
 tagImage
 name30160.jpg
 typeimage/jpg
 size311558
 uri/assets/16759.jpg
 order2
 created2016-04-07 17:00:07
 modified2016-04-07 17:00:07
 3(array)
 id16758
 modelProperty
 model_id3142
 tagImage
 name30161.jpg
 typeimage/jpg
 size234504
 uri/assets/16758.jpg
 order3
 created2016-04-07 17:00:07
 modified2016-04-07 17:00:07
 4(array)
 id16757
 modelProperty
 model_id3142
 tagImage
 name30162.jpg
 typeimage/jpg
 size237996
 uri/assets/16757.jpg
 order4
 created2016-04-07 17:00:07
 modified2016-04-07 17:00:07
 5(array)
 id16756
 modelProperty
 model_id3142
 tagImage
 name30163.jpg
 typeimage/jpg
 size373736
 uri/assets/16756.jpg
 order5
 created2016-04-07 17:00:07
 modified2016-04-07 17:00:07
 6(array)
 id16755
 modelProperty
 model_id3142
 tagImage
 name30164.jpg
 typeimage/jpg
 size404837
 uri/assets/16755.jpg
 order6
 created2016-04-07 17:00:07
 modified2016-04-07 17:00:07
 User(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)
 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/3142/243-portlock-road-honolulu-hi-96825-usa
Query String
Request Method	GET
Server Protocol	HTTP/1.1
Gateway Interface	CGI/1.1
Redirect Url	/property-detail/3142/243-portlock-road-honolulu-hi-96825-usa
Remote Port	16859
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	a09e11383ed95751-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	aipBiVLEEfcqtnCHo5U6QwAAABg
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	aipBiVLEEfcqtnCHo5U6QwAAABg
Fcgi Role	RESPONDER
Php Self	/index.php
Request Time Float	1781154185.0162
Request Time	1781154185

====

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

PRIME LOCATION!

Represented By: East Oahu Realty, RB-16090

Highlighted Properties

Share This

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 12 ms Total Queries: 30 queries

Query Explain:

Memory

Timers

Logs

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

Total Time: 12 ms
Total Queries: 30 queries