Properties /

497 Kailua Road Unit: 2102

497 Kailua Road Unit: 2102 | Kailua, HI 96734, USA | $1,175,000 | MLS ID: 202216808

3 Beds
2 Baths
1,594 Sq. Ft.

Enjoy life in this beautifully maintained 3 bed, 2 bath condo here at Ka Malanai at Kailua, one of the most highly desirable complexes in Kailua. This first-floor, 1,433 square foot condo has a fantastic floor plan with a beautifully designed flow. You’ll love and appreciate the central AC and gorgeous plumeria trees surrounding both lanais (living lanai & primary bedroom lanai); this is Hawaii living at its best. The primary bedroom features a dressing area and a walk in closet! The generous sized bathrooms have modern fixtures and double sinks! Indoor laundry and ample storage throughout is a plus! In addition to living in a quiet, beautifully designed condo, you are right in the heart of Kailua where you can walk to all the restaurants, Target, Surf shops and boutiques. The beach is also just a short bike ride away! If you just want to lay low at Ka Malanai and relax, you can enjoy the community areas with BBQ and picnic tables, gorgeous landscaped green areas, and don’t forget to store your surf boards in the community storage! Welcome home, you found the most wonderful home for easy breezy island style life!

^HI_HBR

Represented By: LUVA Real Estate

View On Map

Highlighted Properties

350 Aoloa Street Unit: C107

350 Aoloa Street Unit: C107 | Kailua, HI 96734
$450,000

4176 Keanu Street Unit: 1

4176 Keanu Street Unit: 1 | Honolulu, HI 96816
$685,000

Represented By

Featured Location

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)
  0155
  1497-kailua-road-unit-2102-kailua-hi-96734-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: 26 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`.`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_auto_import_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`.`country_id`, `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_dev2`.`properties` AS `Property` LEFT JOIN `leveragere_dev2`.`property_categories` AS `PrimaryPropertyCategory` ON (`Property`.`primary_property_category_id` = `PrimaryPropertyCategory`.`id`) LEFT JOIN `leveragere_dev2`.`brokerages` AS `Brokerage` ON (`Property`.`brokerage_id` = `Brokerage`.`id`) LEFT JOIN `leveragere_dev2`.`stripe_subscriptions` AS `StripeSubscription` ON (`StripeSubscription`.`property_id` = `Property`.`id` AND `StripeSubscription`.`status` = 'active') LEFT JOIN `leveragere_dev2`.`global_reach_reports` AS `GlobalReachReport` ON (`GlobalReachReport`.`property_id` = `Property`.`id`) WHERE `Property`.`id` = 155 AND `Property`.`archived` = '0' AND `Brokerage`.`archived` = '0' AND `Property`.`incomplete` = '0' LIMIT 1	1	1	1
SELECT `AccountExecutive`.`id`, `AccountExecutive`.`type`, `AccountExecutive`.`brokerage_id`, `AccountExecutive`.`email`, `AccountExecutive`.`password`, `AccountExecutive`.`recover_hash`, `AccountExecutive`.`first_name`, `AccountExecutive`.`last_name`, `AccountExecutive`.`title`, `AccountExecutive`.`dre_num`, `AccountExecutive`.`phone`, `AccountExecutive`.`max_luxury_feed_properties`, `AccountExecutive`.`headshot_filename`, `AccountExecutive`.`bio`, `AccountExecutive`.`brokerage_name_override`, `AccountExecutive`.`stripe_customer_id`, `AccountExecutive`.`digital_ad_first_free_month_coupon`, `AccountExecutive`.`modified`, `AccountExecutive`.`created`, `AccountExecutive`.`notified`, (CONCAT(`AccountExecutive`.`first_name`, " ", `AccountExecutive`.`last_name`)) AS `AccountExecutive__full_name` FROM `leveragere_dev2`.`users` AS `AccountExecutive` WHERE `AccountExecutive`.`id` = 0	0	0	3	maybe slow
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_dev2`.`assets` AS `Logo` WHERE `Logo`.`model_id` = 103 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_dev2`.`assets` AS `MainImage` WHERE `MainImage`.`model_id` = 103 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_dev2`.`assets` AS `ContactImage` WHERE `ContactImage`.`model_id` = 103 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_dev2`.`assets` AS `ContactImage2` WHERE `ContactImage2`.`model_id` = 103 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_dev2`.`assets` AS `ContactImage3` WHERE `ContactImage3`.`model_id` = 103 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_dev2`.`assets` AS `BrokerOfRecordLogo` WHERE `BrokerOfRecordLogo`.`model_id` = 103 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_dev2`.`articles` AS `MainArticle` WHERE `MainArticle`.`model_id` = 103 AND `MainArticle`.`model` = 'Brokerage'	0	0	0
SELECT `FeaturedImage`.`id`, `FeaturedImage`.`model`, `FeaturedImage`.`model_id`, `FeaturedImage`.`tag`, `FeaturedImage`.`name`, `FeaturedImage`.`type`, `FeaturedImage`.`size`, `FeaturedImage`.`uri`, `FeaturedImage`.`order`, `FeaturedImage`.`created`, `FeaturedImage`.`modified` FROM `leveragere_dev2`.`assets` AS `FeaturedImage` WHERE `FeaturedImage`.`model` = 'Brokerage' AND `FeaturedImage`.`tag` = 'FeaturedImage' AND `FeaturedImage`.`model_id` = (103) 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`.`short_description`, `Location`.`long_description`, `Location`.`created`, `Location`.`modified`, `Location`.`timezone`, `Location`.`population` FROM `leveragere_dev2`.`locations` AS `Location` WHERE `Location`.`brokerage_id` = (103)	0	0	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_dev2`.`users` AS `User` WHERE `User`.`brokerage_id` = (103)	0	0	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_dev2`.`assets` AS `Image` WHERE `Image`.`model` = 'Property' AND `Image`.`tag` = 'Image' AND `Image`.`model_id` = (155) ORDER BY `Image`.`order` ASC	23	23	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_dev2`.`users` AS `User` JOIN `leveragere_dev2`.`users_properties` AS `UsersProperty` ON (`UsersProperty`.`property_id` = 155 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_dev2`.`property_categories` AS `SecondaryPropertyCategory` JOIN `leveragere_dev2`.`properties_secondary_property_categories` AS `PropertiesSecondaryPropertyCategory` ON (`PropertiesSecondaryPropertyCategory`.`property_id` = 155 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_dev2`.`property_features` AS `PropertyFeature` JOIN `leveragere_dev2`.`properties_property_features` AS `PropertiesPropertyFeature` ON (`PropertiesPropertyFeature`.`property_id` = 155 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_dev2`.`topics` AS `Topic` JOIN `leveragere_dev2`.`properties_topics` AS `PropertiesTopic` ON (`PropertiesTopic`.`property_id` = 155 AND `PropertiesTopic`.`topic_id` = `Topic`.`id`)	0	0	13	maybe slow
SELECT `Property`.`id`, `Property`.`brokerage_id`, `Property`.`created_by_user_id`, `Property`.`order`, `Property`.`multi_unit`, `Property`.`agent_1_id`, `Property`.`agent_2_id`, `Property`.`agent_3_id`, `Property`.`name`, `Property`.`incomplete`, `Property`.`archived`, `Property`.`last_archived`, `Property`.`auto_archived_from_mlsidx`, `Property`.`paid_featured`, `Property`.`featured`, `Property`.`homepage_featured`, `Property`.`brokerage_page_featured`, `Property`.`requested_homepage_featured_by_member`, `Property`.`homepage_featured_by_member`, `Property`.`dot_luxury_featured`, `Property`.`luxury_feed_featured`, `Property`.`force_luxury_feed_featured`, `Property`.`luxury_autofeed_imported`, `Property`.`luxury_feed_last_added_time`, `Property`.`luxury_feed_agent_user_id`, `Property`.`luxury_feed_locked_to_subscription_id`, `Property`.`luxury_feed_agent_purchase_date`, `Property`.`luxury_feed_agent_expiration_date`, `Property`.`digital_ad_summary_email_last_sent`, `Property`.`digital_ad_summary_price_changed`, `Property`.`wsj_detail_url`, `Property`.`ft_detail_url`, `Property`.`nyt_detail_url`, `Property`.`juwai_detail_url`, `Property`.`pgl_detail_url`, `Property`.`mg_detail_url`, `Property`.`mg_c_detail_url`, `Property`.`mg_s_detail_url`, `Property`.`bp_detail_url`, `Property`.`mw_detail_url`, `Property`.`nikkei_detail_url`, `Property`.`wapo_detail_url`, `Property`.`robb_detail_url`, `Property`.`medium_featured`, `Property`.`large_featured`, `Property`.`detail_page`, `Property`.`description`, `Property`.`address`, `Property`.`address_2`, `Property`.`city`, `Property`.`state`, `Property`.`postal_code`, `Property`.`country`, `Property`.`use_lat_lng_for_google_map`, `Property`.`currency`, `Property`.`price`, `Property`.`price_2`, `Property`.`price_usd`, `Property`.`price_usd_2`, `Property`.`status`, `Property`.`status_last_changed`, `Property`.`status_last_changed_price_only`, `Property`.`lease_period`, `Property`.`price_upon_request`, `Property`.`bedrooms`, `Property`.`bedrooms_2`, `Property`.`bathrooms`, `Property`.`bathrooms_2`, `Property`.`no_beds_baths`, `Property`.`square_feet`, `Property`.`square_meters`, `Property`.`acres`, `Property`.`interior_unit`, `Property`.`interior_size`, `Property`.`lot_unit`, `Property`.`lot_size`, `Property`.`icon_1`, `Property`.`icon_2`, `Property`.`icon_3`, `Property`.`icon_4`, `Property`.`icon_5`, `Property`.`icon_6`, `Property`.`website`, `Property`.`meta_title`, `Property`.`meta_description`, `Property`.`meta_keywords`, `Property`.`bathrooms_partial`, `Property`.`bathrooms_partial_2`, `Property`.`bathrooms_3_4`, `Property`.`bathrooms_3_4_2`, `Property`.`year_built`, `Property`.`virtual_tour`, `Property`.`video_tour`, `Property`.`digital_brochure`, `Property`.`video_tour_embed_code`, `Property`.`digital_brochure_embed_code`, `Property`.`mls_num`, `Property`.`wsj_property_type`, `Property`.`nyt_property_type`, `Property`.`nyt_popular_features`, `Property`.`propgolux_property_type`, `Property`.`juwai_property_type`, `Property`.`juwai_category`, `Property`.`propgolux_property_style`, `Property`.`wapo_property_type`, `Property`.`robb_property_type`, `Property`.`propgolux_location_id_override`, `Property`.`open_house_1_start`, `Property`.`open_house_1_end_time`, `Property`.`latitude`, `Property`.`longitude`, `Property`.`invalid_required_fields`, `Property`.`invalid_optional_fields`, `Property`.`went_live_today`, `Property`.`converted`, `Property`.`invalid`, `Property`.`mlsidx_full_address`, `Property`.`mlsidx_date_listed`, `Property`.`mls_market`, `Property`.`primary_property_category_id`, `Property`.`realstaq_initial_image_sync`, `Property`.`digital_ad_listing_urls_automated`, `Property`.`modified`, `Property`.`created`, `PrimaryPropertyCategory`.`id`, `PrimaryPropertyCategory`.`name`, `PrimaryPropertyCategory`.`created`, `PrimaryPropertyCategory`.`modified`, `Brokerage`.`id`, `Brokerage`.`account_executive_id`, `Brokerage`.`archived`, `Brokerage`.`type`, `Brokerage`.`hide_from_frontend`, `Brokerage`.`agent_brokerage_data_override`, `Brokerage`.`featured_development`, `Brokerage`.`membership_type`, `Brokerage`.`max_properties`, `Brokerage`.`max_homepage_featured_by_member_properties`, `Brokerage`.`featured_properties_sort_method`, `Brokerage`.`lux_feed_mode`, `Brokerage`.`max_luxury_feed_properties`, `Brokerage`.`membership_luxury_feed_properties`, `Brokerage`.`can_participate_in_lux_feed_while_archived`, `Brokerage`.`full_training_video_access`, `Brokerage`.`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_auto_import_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`.`country_id`, `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_dev2`.`properties` AS `Property` LEFT JOIN `leveragere_dev2`.`property_categories` AS `PrimaryPropertyCategory` ON (`Property`.`primary_property_category_id` = `PrimaryPropertyCategory`.`id`) LEFT JOIN `leveragere_dev2`.`brokerages` AS `Brokerage` ON (`Property`.`brokerage_id` = `Brokerage`.`id`) LEFT JOIN `leveragere_dev2`.`stripe_subscriptions` AS `StripeSubscription` ON (`StripeSubscription`.`property_id` = `Property`.`id` AND `StripeSubscription`.`status` = 'active') LEFT JOIN `leveragere_dev2`.`global_reach_reports` AS `GlobalReachReport` ON (`GlobalReachReport`.`property_id` = `Property`.`id`) WHERE `Property`.`archived` = '0' AND `Brokerage`.`archived` = '0' AND `Property`.`id` != 155 AND `Property`.`brokerage_id` = 103 AND `Property`.`status` != 'Sold' AND `Property`.`incomplete` = '0' ORDER BY RAND() ASC LIMIT 2	2	2	3	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_dev2`.`assets` AS `Image` WHERE `Image`.`model` = 'Property' AND `Image`.`tag` = 'Image' AND `Image`.`model_id` IN (157, 154) ORDER BY `Image`.`order` ASC	24	24	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_dev2`.`users` AS `User` JOIN `leveragere_dev2`.`users_properties` AS `UsersProperty` ON (`UsersProperty`.`property_id` IN (157, 154) 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_dev2`.`property_categories` AS `SecondaryPropertyCategory` JOIN `leveragere_dev2`.`properties_secondary_property_categories` AS `PropertiesSecondaryPropertyCategory` ON (`PropertiesSecondaryPropertyCategory`.`property_id` IN (157, 154) 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_dev2`.`property_features` AS `PropertyFeature` JOIN `leveragere_dev2`.`properties_property_features` AS `PropertiesPropertyFeature` ON (`PropertiesPropertyFeature`.`property_id` IN (157, 154) 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_dev2`.`topics` AS `Topic` JOIN `leveragere_dev2`.`properties_topics` AS `PropertiesTopic` ON (`PropertiesTopic`.`property_id` IN (157, 154) 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`.`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`.`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_auto_import_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`.`country_id`, `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_dev2`.`locations` AS `Location` LEFT JOIN `leveragere_dev2`.`brokerages` AS `Brokerage` ON (`Location`.`brokerage_id` = `Brokerage`.`id`) LEFT JOIN `leveragere_dev2`.`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` = 103 LIMIT 1	0	0	1	maybe slow
SELECT `Property`.`id`, `Property`.`brokerage_id`, `Property`.`created_by_user_id`, `Property`.`order`, `Property`.`multi_unit`, `Property`.`agent_1_id`, `Property`.`agent_2_id`, `Property`.`agent_3_id`, `Property`.`name`, `Property`.`incomplete`, `Property`.`archived`, `Property`.`last_archived`, `Property`.`auto_archived_from_mlsidx`, `Property`.`paid_featured`, `Property`.`featured`, `Property`.`homepage_featured`, `Property`.`brokerage_page_featured`, `Property`.`requested_homepage_featured_by_member`, `Property`.`homepage_featured_by_member`, `Property`.`dot_luxury_featured`, `Property`.`luxury_feed_featured`, `Property`.`force_luxury_feed_featured`, `Property`.`luxury_autofeed_imported`, `Property`.`luxury_feed_last_added_time`, `Property`.`luxury_feed_agent_user_id`, `Property`.`luxury_feed_locked_to_subscription_id`, `Property`.`luxury_feed_agent_purchase_date`, `Property`.`luxury_feed_agent_expiration_date`, `Property`.`digital_ad_summary_email_last_sent`, `Property`.`digital_ad_summary_price_changed`, `Property`.`wsj_detail_url`, `Property`.`ft_detail_url`, `Property`.`nyt_detail_url`, `Property`.`juwai_detail_url`, `Property`.`pgl_detail_url`, `Property`.`mg_detail_url`, `Property`.`mg_c_detail_url`, `Property`.`mg_s_detail_url`, `Property`.`bp_detail_url`, `Property`.`mw_detail_url`, `Property`.`nikkei_detail_url`, `Property`.`wapo_detail_url`, `Property`.`robb_detail_url`, `Property`.`medium_featured`, `Property`.`large_featured`, `Property`.`detail_page`, `Property`.`description`, `Property`.`address`, `Property`.`address_2`, `Property`.`city`, `Property`.`state`, `Property`.`postal_code`, `Property`.`country`, `Property`.`use_lat_lng_for_google_map`, `Property`.`currency`, `Property`.`price`, `Property`.`price_2`, `Property`.`price_usd`, `Property`.`price_usd_2`, `Property`.`status`, `Property`.`status_last_changed`, `Property`.`status_last_changed_price_only`, `Property`.`lease_period`, `Property`.`price_upon_request`, `Property`.`bedrooms`, `Property`.`bedrooms_2`, `Property`.`bathrooms`, `Property`.`bathrooms_2`, `Property`.`no_beds_baths`, `Property`.`square_feet`, `Property`.`square_meters`, `Property`.`acres`, `Property`.`interior_unit`, `Property`.`interior_size`, `Property`.`lot_unit`, `Property`.`lot_size`, `Property`.`icon_1`, `Property`.`icon_2`, `Property`.`icon_3`, `Property`.`icon_4`, `Property`.`icon_5`, `Property`.`icon_6`, `Property`.`website`, `Property`.`meta_title`, `Property`.`meta_description`, `Property`.`meta_keywords`, `Property`.`bathrooms_partial`, `Property`.`bathrooms_partial_2`, `Property`.`bathrooms_3_4`, `Property`.`bathrooms_3_4_2`, `Property`.`year_built`, `Property`.`virtual_tour`, `Property`.`video_tour`, `Property`.`digital_brochure`, `Property`.`video_tour_embed_code`, `Property`.`digital_brochure_embed_code`, `Property`.`mls_num`, `Property`.`wsj_property_type`, `Property`.`nyt_property_type`, `Property`.`nyt_popular_features`, `Property`.`propgolux_property_type`, `Property`.`juwai_property_type`, `Property`.`juwai_category`, `Property`.`propgolux_property_style`, `Property`.`wapo_property_type`, `Property`.`robb_property_type`, `Property`.`propgolux_location_id_override`, `Property`.`open_house_1_start`, `Property`.`open_house_1_end_time`, `Property`.`latitude`, `Property`.`longitude`, `Property`.`invalid_required_fields`, `Property`.`invalid_optional_fields`, `Property`.`went_live_today`, `Property`.`converted`, `Property`.`invalid`, `Property`.`mlsidx_full_address`, `Property`.`mlsidx_date_listed`, `Property`.`mls_market`, `Property`.`primary_property_category_id`, `Property`.`realstaq_initial_image_sync`, `Property`.`digital_ad_listing_urls_automated`, `Property`.`modified`, `Property`.`created`, `PrimaryPropertyCategory`.`id`, `PrimaryPropertyCategory`.`name`, `PrimaryPropertyCategory`.`created`, `PrimaryPropertyCategory`.`modified`, `Brokerage`.`id`, `Brokerage`.`account_executive_id`, `Brokerage`.`archived`, `Brokerage`.`type`, `Brokerage`.`hide_from_frontend`, `Brokerage`.`agent_brokerage_data_override`, `Brokerage`.`featured_development`, `Brokerage`.`membership_type`, `Brokerage`.`max_properties`, `Brokerage`.`max_homepage_featured_by_member_properties`, `Brokerage`.`featured_properties_sort_method`, `Brokerage`.`lux_feed_mode`, `Brokerage`.`max_luxury_feed_properties`, `Brokerage`.`membership_luxury_feed_properties`, `Brokerage`.`can_participate_in_lux_feed_while_archived`, `Brokerage`.`full_training_video_access`, `Brokerage`.`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_auto_import_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`.`country_id`, `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_dev2`.`properties` AS `Property` LEFT JOIN `leveragere_dev2`.`property_categories` AS `PrimaryPropertyCategory` ON (`Property`.`primary_property_category_id` = `PrimaryPropertyCategory`.`id`) LEFT JOIN `leveragere_dev2`.`brokerages` AS `Brokerage` ON (`Property`.`brokerage_id` = `Brokerage`.`id`) LEFT JOIN `leveragere_dev2`.`stripe_subscriptions` AS `StripeSubscription` ON (`StripeSubscription`.`property_id` = `Property`.`id` AND `StripeSubscription`.`status` = 'active') LEFT JOIN `leveragere_dev2`.`global_reach_reports` AS `GlobalReachReport` ON (`GlobalReachReport`.`property_id` = `Property`.`id`) WHERE `Property`.`archived` = '0' AND `Brokerage`.`archived` = '0' AND `Property`.`brokerage_id` = 103 AND `Property`.`incomplete` = '0' ORDER BY RAND() ASC LIMIT 4	4	4	3	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_dev2`.`assets` AS `Image` WHERE `Image`.`model` = 'Property' AND `Image`.`tag` = 'Image' AND `Image`.`model_id` IN (153, 154, 156, 157) ORDER BY `Image`.`order` ASC	53	53	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_dev2`.`users` AS `User` JOIN `leveragere_dev2`.`users_properties` AS `UsersProperty` ON (`UsersProperty`.`property_id` IN (153, 154, 156, 157) 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_dev2`.`property_categories` AS `SecondaryPropertyCategory` JOIN `leveragere_dev2`.`properties_secondary_property_categories` AS `PropertiesSecondaryPropertyCategory` ON (`PropertiesSecondaryPropertyCategory`.`property_id` IN (153, 154, 156, 157) 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_dev2`.`property_features` AS `PropertyFeature` JOIN `leveragere_dev2`.`properties_property_features` AS `PropertiesPropertyFeature` ON (`PropertiesPropertyFeature`.`property_id` IN (153, 154, 156, 157) 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_dev2`.`topics` AS `Topic` JOIN `leveragere_dev2`.`properties_topics` AS `PropertiesTopic` ON (`PropertiesTopic`.`property_id` IN (153, 154, 156, 157) AND `PropertiesTopic`.`topic_id` = `Topic`.`id`)	0	0	0

Query Explain:

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

====

Timer

Memory

Peak Memory Use 10.57 MB

Message	Memory use
Component initialization	3.03 MB
Controller action start	3.96 MB
Controller render start	6.58 MB
View render complete	7.10 MB

Timers

Total Request Time: 309 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	48.66
Event: Controller.initialize	10.52
Event: Controller.startup	4.02
Controller action	116.20
Event: Controller.beforeRender	7.68
» Processing toolbar data	7.58
Rendering View	91.97
» Event: View.beforeRender	0.40
» Rendering APP/View/Properties/view.ctp	3.15
» » Rendering APP/View/Elements/static_property_price.ctp	0.41
» » Rendering APP/View/Elements/property_features.ctp	0.21
» » Rendering APP/View/Elements/static_property_price.ctp #2	0.16
» » Rendering APP/View/Elements/static_property_price.ctp #3	0.14
» » Rendering APP/View/Elements/sidebar/location_list.ctp	0.14
» » Rendering APP/View/Elements/sidebar/property_list.ctp	0.95
» » » Rendering APP/View/Elements/static_property_price.ctp #4	0.14
» » » Rendering APP/View/Elements/static_property_price.ctp #5	0.15
» » » Rendering APP/View/Elements/static_property_price.ctp #6	0.13
» » » Rendering APP/View/Elements/static_property_price.ctp #7	0.13
» » Rendering APP/View/Elements/sidebar/property_search.ctp	0.19
» Event: View.afterRender	0.01
» Event: View.beforeLayout	0.01
» Rendering APP/View/Layouts/front.ctp	87.62
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)
 id153
 brokerage_id103
 created_by_user_id0
 order0
 multi_unit(false)
 agent_1_id0
 agent_2_id0
 agent_3_id0
 name210 Kaelepulu Drive
 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(true)
 force_luxury_feed_featured(false)
 luxury_autofeed_imported(true)
 luxury_feed_last_added_time2023-02-07 16:53:33
 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_urlhttps://www.juwai.com/75932064.htm
 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)
 descriptionINVESTORS! 3 units just one block from the famous Lanikai beach and Mokulua islands, this multi-generational property is ideal for entertaining and indoor/outdoor island living. The property is located on the corner leading up to the popular Pillbox hiking trail and Mid-Pac Country Club and a short walk to the beach. 2 electronic gates allow for lots of space for kids to safely play in the yard around the property. This home has 3 separate entrances and includes 2 beds 1 bath upstairs with view of the ocean from the living area, 3 beds 1 bath downstairs plus a large studio with its own electronic gate and driveway. There are 2 outdoor showers for rinsing off after the beach, added 200 amps of power, lots of storage and beautiful landscaping. This property has so much to offer and its location is prime for easy access in and out of Lanikai. Close to restaurants, shops and schools and so much more!
 address210 Kaelepulu Drive
 address_2
 cityKailua
 stateHI
 postal_code96734
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price2500000
 price_20
 price_usd2500000
 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_feet2326
 square_meters
 acres0
 interior_unitsq_ft
 interior_size2326
 lot_unitacres
 lot_size0
 icon_1
 icon_2
 icon_3
 icon_4
 icon_5
 icon_6
 website
 meta_title
 meta_description
 meta_keywords
 bathrooms_partial0
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built
 virtual_tour
 video_tour
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num202210691
 wsj_property_typesingle family
 nyt_property_type1
 nyt_popular_features
 propgolux_property_type9
 juwai_property_typeSingle Family
 juwai_categoryresidential
 propgolux_property_style21
 wapo_property_typeSingleFamily Home
 robb_property_typeSingle Family Home
 propgolux_location_id_override
 open_house_1_start0000-00-00 00:00:00
 open_house_1_end_time00:00:00
 latitude21.391964
 longitude-157.718781
 invalid_required_fields
 invalid_optional_fields
 went_live_today(false)
 converted(false)
 invalid(false)
 mlsidx_full_address210 Kaelepulu Drive Kailua HI
 mlsidx_date_listed2022-06-04
 mls_marketHI_HBR
 primary_property_category_id0
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated2025-01-27 16:02:52
 modified2025-01-27 16:02:52
 created2025-01-27 01:53:33
 uri/property-detail/153/210-kaelepulu-drive-kailua-hi-96734-usa
 absolute_urihttps://dev2.leveragere.com/property-detail/153/210-kaelepulu-drive-kailua-hi-96734-usa
 address_concat210 Kaelepulu Drive Kailua HI 96734 USA
 google_maps_query_string210+Kaelepulu+Drive++Kailua+HI+96734+USA
 luxury_ad_enrolled_prettyAUTO
 price_prettyUSD 2,500,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty6
 bathrooms_pretty3
 bathrooms_partial_pretty0
 bathrooms_3_4_pretty0
 feed_full_bathrooms3
 date_listed2022-06-04
 overridden_brokerage_nameLUVA Real Estate
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(true)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id103
 account_executive_id0
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typeBasic
 max_properties100
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeLegacy
 max_luxury_feed_properties-1
 membership_luxury_feed_properties-1
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 WOEID(null)
 timezonePacific/Honolulu
 luxury_feed_enrollment_modeauto
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id18,27
 mlsidx_auto_import_minimum_price0
 mlsidx_logo_url/img/logo-mls-listings.png
 mlsidx_disclaimerBased on information from the MLSListings MLS) as of {{date}} (date the MLS data was obtained). All data, including all measurements and calculations of area, is obtained from various sources and has not been, and will not be, verified by broker or MLS. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information.
 nameLUVA Real Estate
 broker_of_record_name
 short_nameLUVA Real Estate
 username
 password
 password_reset_hash
 monthly_invoice_amount0.00
 monthly_invoice_start_date(null)
 monthly_invoice_end_date(null)
 contract_filename
 active(true)
 lead_inLUVA Real Estate is the exclusive representative for Leverage Global Partners on the Island of Oahu including; Honolulu, HI, USA.
 short_description
 descriptionOUR STORY LUVA Real Estate was founded in 2012 as a lifestyle focused company bringing together like - minded individuals from the Real Estate, Entertainment and Start up Business sectors. Borne from the idea that there is no one-size-fits-all approach to its customers, LUVA prides itself on being a progressive, boutique-style, technologically savvy brokerage. LUVA has expanded their presence with the launch of it's Oahu office in 2018. WHO WE ARE: We are people. Adventurers, dog lovers, surfers, activists, Netflix bingers, paddlers, caffeine addicts, parents & partners. We are relational, not just transactional. The process of buying & selling real estate is an emotional, financial and mental journey. We partner with our clients through the ups & downs to achieve goals. WHAT WE DO: We tell stories. Selling a home is more complex than graphs & stats. We creatively convey the home’s story to align with a buyer’s hopes and dreams - making it a tangible thing. A physical place to create life & lifestyle. We provide solutions. We are professionals. We are solution driven. We are a mix plate - local hybrid combining all the best things - of information, technology, social media, collaboration and team work culture. Our goal is simple - “Connecting humans with homes.” Wish you were here? We can help you with that.
 communitiesHonolulu
 websitehttps://www.luvarealestate.com/
 address970 N. Kalaheo Ave
 address_2Suite A110
 cityKailua
 stateHI
 full_stateHawaii
 countryUSA
 market
 market_2
 postal_code96734
 phone808-262-5882
 phone_2
 phone_3
 wide_contact_image(true)
 contact_nameBrian Collins
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titlePartner
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebookhttps://www.facebook.com/LuvaRealEstate/
 contact_twitterhttps://twitter.com/luvarealestate?lang=en
 contact_instagramhttps://www.instagram.com/luva_real_estate/
 contact_pinterest
 contact_linkedinhttps://www.linkedin.com/company/luva-real-estate
 contact_youtube
 contact_phone818-898-8585
 contact_email_2[email protected]
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2989-929-9393
 contact_website
 contact_name_2Kimi Correa
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2Broker-in-Charge
 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_filename
 logo_filename
 contact_image_filename
 all_properties_link_image_filename
 all_properties_link
 video_embed_code
 contact_video_embed_code
 meta_title
 meta_description
 meta_keywords
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(false)
 created2019-12-03 19:18:48
 modified2023-02-07 16:55:06
 country_id0
 dre_num012345
 uri/brokerage-detail/103/luva-real-estate
 website_shortwww.luvarealestate.com
 name_with_locationLUVA Real Estate
 mlsidx_id_array(array)
 018
 127
 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)
 id2705
 modelProperty
 model_id153
 tagImage
 name202210691_fa5d9fdb2fcc2bdf721cc75fb135f2af.jpg
 typeimage/jpeg
 size45629
 uri/assets/2705.jpg
 order0
 created2023-02-07 16:53:34
 modified2023-02-07 16:53:34
 1(array)
 id2706
 modelProperty
 model_id153
 tagImage
 name202210691_31d58f8701d7c908a98a6971be28d240.jpg
 typeimage/jpeg
 size48536
 uri/assets/2706.jpg
 order1
 created2023-02-07 16:53:34
 modified2023-02-07 16:53:34
 2(array)
 id2707
 modelProperty
 model_id153
 tagImage
 name202210691_a5838c56efdb02eb256cdf1766e389f5.jpg
 typeimage/jpeg
 size53048
 uri/assets/2707.jpg
 order2
 created2023-02-07 16:53:34
 modified2023-02-07 16:53:34
 3(array)
 id2708
 modelProperty
 model_id153
 tagImage
 name202210691_6a0161986677fe5fb073bcf2bad2d1fa.jpg
 typeimage/jpeg
 size44102
 uri/assets/2708.jpg
 order3
 created2023-02-07 16:53:34
 modified2023-02-07 16:53:34
 4(array)
 id2709
 modelProperty
 model_id153
 tagImage
 name202210691_2bf88b317d3d37cc77753ac5844c4999.jpg
 typeimage/jpeg
 size60473
 uri/assets/2709.jpg
 order4
 created2023-02-07 16:53:34
 modified2023-02-07 16:53:34
 5(array)
 id2710
 modelProperty
 model_id153
 tagImage
 name202210691_0344e09a22ec253244b053107b11016b.jpg
 typeimage/jpeg
 size44575
 uri/assets/2710.jpg
 order5
 created2023-02-07 16:53:34
 modified2023-02-07 16:53:34
 6(array)
 id2711
 modelProperty
 model_id153
 tagImage
 name202210691_2fa2253233ebcae1a5696ea6cb011278.jpg
 typeimage/jpeg
 size46952
 uri/assets/2711.jpg
 order6
 created2023-02-07 16:53:34
 modified2023-02-07 16:53:34
 7(array)
 id2712
 modelProperty
 model_id153
 tagImage
 name202210691_5257fe78f689e11ea7e953c23aa0b958.jpg
 typeimage/jpeg
 size44107
 uri/assets/2712.jpg
 order7
 created2023-02-07 16:53:34
 modified2023-02-07 16:53:34
 8(array)
 id2713
 modelProperty
 model_id153
 tagImage
 name202210691_f850cdf591c31f355ff0d6b0c4ba6d47.jpg
 typeimage/jpeg
 size77152
 uri/assets/2713.jpg
 order8
 created2023-02-07 16:53:34
 modified2023-02-07 16:53:34
 9(array)
 id2714
 modelProperty
 model_id153
 tagImage
 name202210691_ac16adc2afc0e9fd6bbf0a72be723eed.jpg
 typeimage/jpeg
 size60127
 uri/assets/2714.jpg
 order9
 created2023-02-07 16:53:35
 modified2023-02-07 16:53:35
 10(array)
 id2715
 modelProperty
 model_id153
 tagImage
 name202210691_e88b83dd59acf44e740b00bedf611864.jpg
 typeimage/jpeg
 size65235
 uri/assets/2715.jpg
 order10
 created2023-02-07 16:53:35
 modified2023-02-07 16:53:35
 11(array)
 id2716
 modelProperty
 model_id153
 tagImage
 name202210691_c7f5a6406d3f4e6b2b15196551c6b64e.jpg
 typeimage/jpeg
 size74462
 uri/assets/2716.jpg
 order11
 created2023-02-07 16:53:35
 modified2023-02-07 16:53:35
 12(array)
 id2717
 modelProperty
 model_id153
 tagImage
 name202210691_f14afe927c6545546f9a04f78aaa9d1a.jpg
 typeimage/jpeg
 size58623
 uri/assets/2717.jpg
 order12
 created2023-02-07 16:53:35
 modified2023-02-07 16:53:35
 13(array)
 id2718
 modelProperty
 model_id153
 tagImage
 name202210691_72eecaa9e54a1d44a8f932c1fa2f69c9.jpg
 typeimage/jpeg
 size55207
 uri/assets/2718.jpg
 order13
 created2023-02-07 16:53:35
 modified2023-02-07 16:53:35
 14(array)
 id2719
 modelProperty
 model_id153
 tagImage
 name202210691_e69e1be5992aea6571cacb74ea229509.jpg
 typeimage/jpeg
 size55797
 uri/assets/2719.jpg
 order14
 created2023-02-07 16:53:35
 modified2023-02-07 16:53:35
 15(array)
 id2720
 modelProperty
 model_id153
 tagImage
 name202210691_dc7d8e4cf3e8ddf57dcde3ac07746446.jpg
 typeimage/jpeg
 size65399
 uri/assets/2720.jpg
 order15
 created2023-02-07 16:53:35
 modified2023-02-07 16:53:35
 16(array)
 id2721
 modelProperty
 model_id153
 tagImage
 name202210691_69dc41696c3812370d9ccc3393d34feb.jpg
 typeimage/jpeg
 size71851
 uri/assets/2721.jpg
 order16
 created2023-02-07 16:53:36
 modified2023-02-07 16:53:36
 17(array)
 id2722
 modelProperty
 model_id153
 tagImage
 name202210691_43ab4cee5dfb48a202c36166a6e664dc.jpg
 typeimage/jpeg
 size65516
 uri/assets/2722.jpg
 order17
 created2023-02-07 16:53:36
 modified2023-02-07 16:53:36
 18(array)
 id2723
 modelProperty
 model_id153
 tagImage
 name202210691_b52fbd73980386e2b2a64993cbab5d8c.jpg
 typeimage/jpeg
 size53228
 uri/assets/2723.jpg
 order18
 created2023-02-07 16:53:36
 modified2023-02-07 16:53:36
 19(array)
 id2724
 modelProperty
 model_id153
 tagImage
 name202210691_8583c8b5db12f860e0c0d8accb7a28e0.jpg
 typeimage/jpeg
 size55225
 uri/assets/2724.jpg
 order19
 created2023-02-07 16:53:36
 modified2023-02-07 16:53:36
 20(array)
 id2725
 modelProperty
 model_id153
 tagImage
 name202210691_460f2ac0d607b4c4139cfdf7b4a14b0e.jpg
 typeimage/jpeg
 size56865
 uri/assets/2725.jpg
 order20
 created2023-02-07 16:53:36
 modified2023-02-07 16:53:36
 21(array)
 id2726
 modelProperty
 model_id153
 tagImage
 name202210691_9a726158767b60cd524a58b67c418063.jpg
 typeimage/jpeg
 size41833
 uri/assets/2726.jpg
 order21
 created2023-02-07 16:53:36
 modified2023-02-07 16:53:36
 22(array)
 id2727
 modelProperty
 model_id153
 tagImage
 name202210691_4fa929b0621b001205ff85282f563833.jpg
 typeimage/jpeg
 size63906
 uri/assets/2727.jpg
 order22
 created2023-02-07 16:53:36
 modified2023-02-07 16:53:36
 23(array)
 id2728
 modelProperty
 model_id153
 tagImage
 name202210691_9f0716949beb90b71bd65c39cf1cf6a4.jpg
 typeimage/jpeg
 size65949
 uri/assets/2728.jpg
 order23
 created2023-02-07 16:53:36
 modified2023-02-07 16:53:36
 24(array)
 id2729
 modelProperty
 model_id153
 tagImage
 name202210691_d0af964d9b1445c5cfc1e94c8e104c8e.jpg
 typeimage/jpeg
 size98568
 uri/assets/2729.jpg
 order24
 created2023-02-07 16:53:37
 modified2023-02-07 16:53:37
 User(empty)
 SecondaryPropertyCategory(empty)
 PropertyFeature(empty)
 Topic(empty)
 1(array)
 Property(array)
 id154
 brokerage_id103
 created_by_user_id0
 order0
 multi_unit(false)
 agent_1_id0
 agent_2_id0
 agent_3_id0
 name4176 Keanu Street Unit: 1
 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(true)
 force_luxury_feed_featured(false)
 luxury_autofeed_imported(true)
 luxury_feed_last_added_time2023-02-07 16:55:13
 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 beautiful end unit boasts pride of ownership and includes stainless steel appliances, newer refrigerator, granite kitchen counters, washer/dryer hidden in a custom-built cabinet, full size bath downstairs and upstairs, tiling throughout including storage closet for additional pantry or utility storage, plus a drop-down ladder to the attic storage. Warm wood cabinetry in kitchen and accents throughout. Lots of natural lighting from the windows in every room. Living room has split a/c, ceiling fan in one bedroom and window a/c in 2nd bedroom. This unit comes complete with all of the features you need for comfort style living. The desirable Tropic Gardens is a very peaceful residential community conveniently located close to Kahala Mall, schools, restaurants, walking distance to the new Kuono Marktplace at Kahala and just minutes from Waikiki, golf spots, beaches and so much more!
 address4176 Keanu Street Unit: 1
 address_2
 cityHonolulu
 stateHI
 postal_code96816
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price685000
 price_20
 price_usd685000
 price_usd_20
 statusFor Sale
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(false)
 bedrooms2
 bedrooms_20
 bathrooms2
 bathrooms_20
 no_beds_baths(false)
 square_feet1032
 square_meters
 acres0
 interior_unitsq_ft
 interior_size1032
 lot_unitacres
 lot_size0
 icon_1
 icon_2
 icon_3
 icon_4
 icon_5
 icon_6
 website
 meta_title
 meta_description
 meta_keywords
 bathrooms_partial0
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built
 virtual_tour
 video_tour
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num202219457
 wsj_property_typecondo
 nyt_property_type5
 nyt_popular_features
 propgolux_property_type2
 juwai_property_typeApartments/Condo
 juwai_categoryresidential
 propgolux_property_style21
 wapo_property_typeCondominium
 robb_property_typeCondo
 propgolux_location_id_override
 open_house_1_start0000-00-00 00:00:00
 open_house_1_end_time00:00:00
 latitude21.280785
 longitude-157.786285
 invalid_required_fields
 invalid_optional_fields
 went_live_today(false)
 converted(false)
 invalid(false)
 mlsidx_full_address4176 Keanu Street Unit: 1 Honolulu HI
 mlsidx_date_listed2022-09-14
 mls_marketHI_HBR
 primary_property_category_id0
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated(null)
 modified2023-12-18 18:33:01
 created2023-02-07 16:55:13
 uri/property-detail/154/4176-keanu-street-unit-1-honolulu-hi-96816-usa
 absolute_urihttps://dev2.leveragere.com/property-detail/154/4176-keanu-street-unit-1-honolulu-hi-96816-usa
 address_concat4176 Keanu Street Unit: 1 Honolulu HI 96816 USA
 google_maps_query_string4176+Keanu+Street+Unit%3A+1++Honolulu+HI+96816+USA
 luxury_ad_enrolled_prettyAUTO
 price_prettyUSD 685,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty2
 bathrooms_pretty2
 bathrooms_partial_pretty0
 bathrooms_3_4_pretty0
 feed_full_bathrooms2
 date_listed2022-09-14
 overridden_brokerage_nameLUVA Real Estate
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(true)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id103
 account_executive_id0
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typeBasic
 max_properties100
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeLegacy
 max_luxury_feed_properties-1
 membership_luxury_feed_properties-1
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 WOEID(null)
 timezonePacific/Honolulu
 luxury_feed_enrollment_modeauto
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id18,27
 mlsidx_auto_import_minimum_price0
 mlsidx_logo_url/img/logo-mls-listings.png
 mlsidx_disclaimerBased on information from the MLSListings MLS) as of {{date}} (date the MLS data was obtained). All data, including all measurements and calculations of area, is obtained from various sources and has not been, and will not be, verified by broker or MLS. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information.
 nameLUVA Real Estate
 broker_of_record_name
 short_nameLUVA Real Estate
 username
 password
 password_reset_hash
 monthly_invoice_amount0.00
 monthly_invoice_start_date(null)
 monthly_invoice_end_date(null)
 contract_filename
 active(true)
 lead_inLUVA Real Estate is the exclusive representative for Leverage Global Partners on the Island of Oahu including; Honolulu, HI, USA.
 short_description
 descriptionOUR STORY LUVA Real Estate was founded in 2012 as a lifestyle focused company bringing together like - minded individuals from the Real Estate, Entertainment and Start up Business sectors. Borne from the idea that there is no one-size-fits-all approach to its customers, LUVA prides itself on being a progressive, boutique-style, technologically savvy brokerage. LUVA has expanded their presence with the launch of it's Oahu office in 2018. WHO WE ARE: We are people. Adventurers, dog lovers, surfers, activists, Netflix bingers, paddlers, caffeine addicts, parents & partners. We are relational, not just transactional. The process of buying & selling real estate is an emotional, financial and mental journey. We partner with our clients through the ups & downs to achieve goals. WHAT WE DO: We tell stories. Selling a home is more complex than graphs & stats. We creatively convey the home’s story to align with a buyer’s hopes and dreams - making it a tangible thing. A physical place to create life & lifestyle. We provide solutions. We are professionals. We are solution driven. We are a mix plate - local hybrid combining all the best things - of information, technology, social media, collaboration and team work culture. Our goal is simple - “Connecting humans with homes.” Wish you were here? We can help you with that.
 communitiesHonolulu
 websitehttps://www.luvarealestate.com/
 address970 N. Kalaheo Ave
 address_2Suite A110
 cityKailua
 stateHI
 full_stateHawaii
 countryUSA
 market
 market_2
 postal_code96734
 phone808-262-5882
 phone_2
 phone_3
 wide_contact_image(true)
 contact_nameBrian Collins
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titlePartner
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebookhttps://www.facebook.com/LuvaRealEstate/
 contact_twitterhttps://twitter.com/luvarealestate?lang=en
 contact_instagramhttps://www.instagram.com/luva_real_estate/
 contact_pinterest
 contact_linkedinhttps://www.linkedin.com/company/luva-real-estate
 contact_youtube
 contact_phone818-898-8585
 contact_email_2[email protected]
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2989-929-9393
 contact_website
 contact_name_2Kimi Correa
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2Broker-in-Charge
 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_filename
 logo_filename
 contact_image_filename
 all_properties_link_image_filename
 all_properties_link
 video_embed_code
 contact_video_embed_code
 meta_title
 meta_description
 meta_keywords
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(false)
 created2019-12-03 19:18:48
 modified2023-02-07 16:55:06
 country_id0
 dre_num012345
 uri/brokerage-detail/103/luva-real-estate
 website_shortwww.luvarealestate.com
 name_with_locationLUVA Real Estate
 mlsidx_id_array(array)
 018
 127
 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)
 id2730
 modelProperty
 model_id154
 tagImage
 name202219457_c5604e505cde1d0d0d9a5897fc76c31a.jpg
 typeimage/jpeg
 size46882
 uri/assets/2730.jpg
 order0
 created2023-02-07 16:55:14
 modified2023-02-07 16:55:14
 1(array)
 id2731
 modelProperty
 model_id154
 tagImage
 name202219457_6554f7da27d0df03fdc32555117b826a.jpg
 typeimage/jpeg
 size48329
 uri/assets/2731.jpg
 order1
 created2023-02-07 16:55:14
 modified2023-02-07 16:55:14
 2(array)
 id2732
 modelProperty
 model_id154
 tagImage
 name202219457_8f9b2e08281d685dc95ca40626a52d17.jpg
 typeimage/jpeg
 size48448
 uri/assets/2732.jpg
 order2
 created2023-02-07 16:55:14
 modified2023-02-07 16:55:14
 3(array)
 id2733
 modelProperty
 model_id154
 tagImage
 name202219457_7c8c6ac13d7d75f85e12c131bb744ee6.jpg
 typeimage/jpeg
 size45353
 uri/assets/2733.jpg
 order3
 created2023-02-07 16:55:14
 modified2023-02-07 16:55:14
 4(array)
 id2734
 modelProperty
 model_id154
 tagImage
 name202219457_32cb8db464bc2fed9990be6e6c061e44.jpg
 typeimage/jpeg
 size55198
 uri/assets/2734.jpg
 order4
 created2023-02-07 16:55:14
 modified2023-02-07 16:55:14
 5(array)
 id2735
 modelProperty
 model_id154
 tagImage
 name202219457_86ca498d8cecfc21e742556d4f0cdfa2.jpg
 typeimage/jpeg
 size53569
 uri/assets/2735.jpg
 order5
 created2023-02-07 16:55:14
 modified2023-02-07 16:55:14
 6(array)
 id2736
 modelProperty
 model_id154
 tagImage
 name202219457_3f987b09cdc4e80f230de8eb14a28f24.jpg
 typeimage/jpeg
 size47028
 uri/assets/2736.jpg
 order6
 created2023-02-07 16:55:14
 modified2023-02-07 16:55:14
 7(array)
 id2737
 modelProperty
 model_id154
 tagImage
 name202219457_2854f2574f1cf2f5e7550c49c637ccd0.jpg
 typeimage/jpeg
 size73666
 uri/assets/2737.jpg
 order7
 created2023-02-07 16:55:15
 modified2023-02-07 16:55:15
 8(array)
 id2738
 modelProperty
 model_id154
 tagImage
 name202219457_e8d7b25920bcf1c4045327135d67b5f4.jpg
 typeimage/jpeg
 size48004
 uri/assets/2738.jpg
 order8
 created2023-02-07 16:55:15
 modified2023-02-07 16:55:15
 9(array)
 id2739
 modelProperty
 model_id154
 tagImage
 name202219457_06269f619bffb92b6de62b1cbcd85d98.jpg
 typeimage/jpeg
 size51459
 uri/assets/2739.jpg
 order9
 created2023-02-07 16:55:15
 modified2023-02-07 16:55:15
 10(array)
 id2740
 modelProperty
 model_id154
 tagImage
 name202219457_a0084ddd3b599a3e55b9d7e5d1fa6bbb.jpg
 typeimage/jpeg
 size51259
 uri/assets/2740.jpg
 order10
 created2023-02-07 16:55:15
 modified2023-02-07 16:55:15
 11(array)
 id2741
 modelProperty
 model_id154
 tagImage
 name202219457_cc1f64822027bf3a1479ea9a3dd8e018.jpg
 typeimage/jpeg
 size40970
 uri/assets/2741.jpg
 order11
 created2023-02-07 16:55:15
 modified2023-02-07 16:55:15
 12(array)
 id2742
 modelProperty
 model_id154
 tagImage
 name202219457_69cdd976ecb507863463563de2bfc37b.jpg
 typeimage/jpeg
 size91529
 uri/assets/2742.jpg
 order12
 created2023-02-07 16:55:15
 modified2023-02-07 16:55:15
 User(empty)
 SecondaryPropertyCategory(empty)
 PropertyFeature(empty)
 Topic(empty)
 2(array)
 Property(array)
 id156
 brokerage_id103
 created_by_user_id0
 order0
 multi_unit(false)
 agent_1_id0
 agent_2_id0
 agent_3_id0
 name85-148 Ala Walua Street Unit: A
 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(true)
 force_luxury_feed_featured(false)
 luxury_autofeed_imported(true)
 luxury_feed_last_added_time2023-02-07 16:55:18
 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_urlhttps://www.juwai.com/67818325.htm
 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_urlhttps://robbreport.com/listing/85-157-waianae-valley-rd-waianae-hi-96792/
 medium_featured(false)
 large_featured(false)
 detail_page(false)
 descriptionLeasehold townhome with lots of potential. Land lease is loan driven - should lender need extension of the land lease a request can be made and an extension to 2055 may be granted. All bedrooms are upstairs, generous fenced in back yard, fenced in front court yard with storage closets. Two uncovered parking spots, storage shed in the back yard. Home is in need of some repairs and updating. Electricity and water turned off to the unit. Bring your ideas - lots of potential !
 address85-148 Ala Walua Street Unit: A
 address_2
 cityWaianae
 stateHI
 postal_code96792
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price165000
 price_20
 price_usd165000
 price_usd_20
 statusSold
 status_last_changed2024-07-24 13:44:07
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(false)
 bedrooms3
 bedrooms_20
 bathrooms1
 bathrooms_20
 no_beds_baths(false)
 square_feet951
 square_meters
 acres0
 interior_unitsq_ft
 interior_size951
 lot_unitacres
 lot_size0
 icon_1
 icon_2
 icon_3
 icon_4
 icon_5
 icon_6
 website
 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_num202209262
 wsj_property_typesingle family
 nyt_property_type1
 nyt_popular_features
 propgolux_property_type9
 juwai_property_typeSingle Family
 juwai_categoryresidential
 propgolux_property_style21
 wapo_property_typeSingleFamily Home
 robb_property_typeSingle Family Home
 propgolux_location_id_override
 open_house_1_start0000-00-00 00:00:00
 open_house_1_end_time00:00:00
 latitude21.455042
 longitude-158.194717
 invalid_required_fields
 invalid_optional_fields
 went_live_today(false)
 converted(false)
 invalid(false)
 mlsidx_full_address85-148 Ala Walua Street Unit: A Waianae HI
 mlsidx_date_listed2022-05-13
 mls_marketHI_HBR
 primary_property_category_id0
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated2025-01-27 12:25:20
 modified2025-01-27 12:25:20
 created2023-02-07 16:55:18
 uri/property-detail/156/85-148-ala-walua-street-unit-a-waianae-hi-96792-usa
 absolute_urihttps://dev2.leveragere.com/property-detail/156/85-148-ala-walua-street-unit-a-waianae-hi-96792-usa
 address_concat85-148 Ala Walua Street Unit: A Waianae HI 96792 USA
 google_maps_query_string85-148+Ala+Walua+Street+Unit%3A+A++Waianae+HI+96792+USA
 luxury_ad_enrolled_prettyAUTO
 price_prettyUSD 165,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty3
 bathrooms_pretty1
 bathrooms_partial_pretty1
 bathrooms_3_4_pretty0
 feed_full_bathrooms1
 date_listed2022-05-13
 overridden_brokerage_nameLUVA Real Estate
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(true)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id103
 account_executive_id0
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typeBasic
 max_properties100
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeLegacy
 max_luxury_feed_properties-1
 membership_luxury_feed_properties-1
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 WOEID(null)
 timezonePacific/Honolulu
 luxury_feed_enrollment_modeauto
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id18,27
 mlsidx_auto_import_minimum_price0
 mlsidx_logo_url/img/logo-mls-listings.png
 mlsidx_disclaimerBased on information from the MLSListings MLS) as of {{date}} (date the MLS data was obtained). All data, including all measurements and calculations of area, is obtained from various sources and has not been, and will not be, verified by broker or MLS. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information.
 nameLUVA Real Estate
 broker_of_record_name
 short_nameLUVA Real Estate
 username
 password
 password_reset_hash
 monthly_invoice_amount0.00
 monthly_invoice_start_date(null)
 monthly_invoice_end_date(null)
 contract_filename
 active(true)
 lead_inLUVA Real Estate is the exclusive representative for Leverage Global Partners on the Island of Oahu including; Honolulu, HI, USA.
 short_description
 descriptionOUR STORY LUVA Real Estate was founded in 2012 as a lifestyle focused company bringing together like - minded individuals from the Real Estate, Entertainment and Start up Business sectors. Borne from the idea that there is no one-size-fits-all approach to its customers, LUVA prides itself on being a progressive, boutique-style, technologically savvy brokerage. LUVA has expanded their presence with the launch of it's Oahu office in 2018. WHO WE ARE: We are people. Adventurers, dog lovers, surfers, activists, Netflix bingers, paddlers, caffeine addicts, parents & partners. We are relational, not just transactional. The process of buying & selling real estate is an emotional, financial and mental journey. We partner with our clients through the ups & downs to achieve goals. WHAT WE DO: We tell stories. Selling a home is more complex than graphs & stats. We creatively convey the home’s story to align with a buyer’s hopes and dreams - making it a tangible thing. A physical place to create life & lifestyle. We provide solutions. We are professionals. We are solution driven. We are a mix plate - local hybrid combining all the best things - of information, technology, social media, collaboration and team work culture. Our goal is simple - “Connecting humans with homes.” Wish you were here? We can help you with that.
 communitiesHonolulu
 websitehttps://www.luvarealestate.com/
 address970 N. Kalaheo Ave
 address_2Suite A110
 cityKailua
 stateHI
 full_stateHawaii
 countryUSA
 market
 market_2
 postal_code96734
 phone808-262-5882
 phone_2
 phone_3
 wide_contact_image(true)
 contact_nameBrian Collins
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titlePartner
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebookhttps://www.facebook.com/LuvaRealEstate/
 contact_twitterhttps://twitter.com/luvarealestate?lang=en
 contact_instagramhttps://www.instagram.com/luva_real_estate/
 contact_pinterest
 contact_linkedinhttps://www.linkedin.com/company/luva-real-estate
 contact_youtube
 contact_phone818-898-8585
 contact_email_2[email protected]
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2989-929-9393
 contact_website
 contact_name_2Kimi Correa
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2Broker-in-Charge
 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_filename
 logo_filename
 contact_image_filename
 all_properties_link_image_filename
 all_properties_link
 video_embed_code
 contact_video_embed_code
 meta_title
 meta_description
 meta_keywords
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(false)
 created2019-12-03 19:18:48
 modified2023-02-07 16:55:06
 country_id0
 dre_num012345
 uri/brokerage-detail/103/luva-real-estate
 website_shortwww.luvarealestate.com
 name_with_locationLUVA Real Estate
 mlsidx_id_array(array)
 018
 127
 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)
 id2766
 modelProperty
 model_id156
 tagImage
 name202209262_23ee081f5288e8fcaf43ab187b191167.jpg
 typeimage/jpeg
 size95337
 uri/assets/2766.jpg
 order0
 created2023-02-07 16:55:18
 modified2025-01-13 10:37:00
 1(array)
 id2767
 modelProperty
 model_id156
 tagImage
 name202209262_01420f8f41d7e23799b5869184997c6a.jpg
 typeimage/jpeg
 size72140
 uri/assets/2767.jpg
 order1
 created2023-02-07 16:55:18
 modified2025-01-13 10:37:00
 2(array)
 id2789
 modelProperty
 model_id156
 tagImage
 namefpo_large.jpg
 typeimage/jpeg
 size71316
 uri/assets/2789.jpg
 order2
 created2025-01-08 10:25:08
 modified2025-01-13 10:37:00
 3(array)
 id2790
 modelProperty
 model_id156
 tagImage
 namesplash-test.png
 typeimage/png
 size10681
 uri/assets/2790.png
 order3
 created2025-01-13 10:36:48
 modified2025-01-13 10:37:00
 User(empty)
 SecondaryPropertyCategory(empty)
 PropertyFeature(empty)
 Topic(empty)
 3(array)
 Property(array)
 id157
 brokerage_id103
 created_by_user_id0
 order0
 multi_unit(false)
 agent_1_id0
 agent_2_id0
 agent_3_id0
 name350 Aoloa Street Unit: C107
 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(true)
 force_luxury_feed_featured(false)
 luxury_autofeed_imported(true)
 luxury_feed_last_added_time2023-02-07 16:55:18
 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_urlhttps://www.juwai.com/74465582.htm
 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)
 descriptionIn the heart of Kailua you will find this one bedroom, one bath, one parking with a storage unit condo waiting for its new owner. New flooring, freshly painted, new ceiling fans and washer/dryer in the unit. New appliances ( refrigerator on order and will be delivered in Oct.) Single level condo on the first floor ( elevated above the parking area ). One assigned covered parking stall, on site resident manager, landscaped grounds and a playground next to the BBQ area. Close to shopping and a bike ride to the beach. Super cute home waiting for its new owner.
 address350 Aoloa Street Unit: C107
 address_2
 cityKailua
 stateHI
 postal_code96734
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price450000
 price_20
 price_usd450000
 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)
 bedrooms1
 bedrooms_20
 bathrooms1
 bathrooms_20
 no_beds_baths(false)
 square_feet587
 square_meters
 acres0
 interior_unitsq_ft
 interior_size587
 lot_unitacres
 lot_size0
 icon_1
 icon_2
 icon_3
 icon_4
 icon_5
 icon_6
 website
 meta_title
 meta_description
 meta_keywords
 bathrooms_partial0
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built
 virtual_tour
 video_tour
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num202220295
 wsj_property_typecondo
 nyt_property_type5
 nyt_popular_features
 propgolux_property_type2
 juwai_property_typeApartments/Condo
 juwai_categoryresidential
 propgolux_property_style21
 wapo_property_typeCondominium
 robb_property_typeCondo
 propgolux_location_id_override
 open_house_1_start0000-00-00 00:00:00
 open_house_1_end_time00:00:00
 latitude21.390614
 longitude-157.738190
 invalid_required_fields
 invalid_optional_fields
 went_live_today(false)
 converted(false)
 invalid(false)
 mlsidx_full_address350 Aoloa Street Unit: C107 Kailua HI
 mlsidx_date_listed2022-09-28
 mls_marketHI_HBR
 primary_property_category_id0
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated2025-01-27 12:27:31
 modified2025-01-27 12:27:31
 created2023-02-07 16:55:18
 uri/property-detail/157/350-aoloa-street-unit-c107-kailua-hi-96734-usa
 absolute_urihttps://dev2.leveragere.com/property-detail/157/350-aoloa-street-unit-c107-kailua-hi-96734-usa
 address_concat350 Aoloa Street Unit: C107 Kailua HI 96734 USA
 google_maps_query_string350+Aoloa+Street+Unit%3A+C107++Kailua+HI+96734+USA
 luxury_ad_enrolled_prettyAUTO
 price_prettyUSD 450,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty1
 bathrooms_pretty1
 bathrooms_partial_pretty0
 bathrooms_3_4_pretty0
 feed_full_bathrooms1
 date_listed2022-09-28
 overridden_brokerage_nameLUVA Real Estate
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(true)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id103
 account_executive_id0
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typeBasic
 max_properties100
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeLegacy
 max_luxury_feed_properties-1
 membership_luxury_feed_properties-1
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 WOEID(null)
 timezonePacific/Honolulu
 luxury_feed_enrollment_modeauto
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id18,27
 mlsidx_auto_import_minimum_price0
 mlsidx_logo_url/img/logo-mls-listings.png
 mlsidx_disclaimerBased on information from the MLSListings MLS) as of {{date}} (date the MLS data was obtained). All data, including all measurements and calculations of area, is obtained from various sources and has not been, and will not be, verified by broker or MLS. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information.
 nameLUVA Real Estate
 broker_of_record_name
 short_nameLUVA Real Estate
 username
 password
 password_reset_hash
 monthly_invoice_amount0.00
 monthly_invoice_start_date(null)
 monthly_invoice_end_date(null)
 contract_filename
 active(true)
 lead_inLUVA Real Estate is the exclusive representative for Leverage Global Partners on the Island of Oahu including; Honolulu, HI, USA.
 short_description
 descriptionOUR STORY LUVA Real Estate was founded in 2012 as a lifestyle focused company bringing together like - minded individuals from the Real Estate, Entertainment and Start up Business sectors. Borne from the idea that there is no one-size-fits-all approach to its customers, LUVA prides itself on being a progressive, boutique-style, technologically savvy brokerage. LUVA has expanded their presence with the launch of it's Oahu office in 2018. WHO WE ARE: We are people. Adventurers, dog lovers, surfers, activists, Netflix bingers, paddlers, caffeine addicts, parents & partners. We are relational, not just transactional. The process of buying & selling real estate is an emotional, financial and mental journey. We partner with our clients through the ups & downs to achieve goals. WHAT WE DO: We tell stories. Selling a home is more complex than graphs & stats. We creatively convey the home’s story to align with a buyer’s hopes and dreams - making it a tangible thing. A physical place to create life & lifestyle. We provide solutions. We are professionals. We are solution driven. We are a mix plate - local hybrid combining all the best things - of information, technology, social media, collaboration and team work culture. Our goal is simple - “Connecting humans with homes.” Wish you were here? We can help you with that.
 communitiesHonolulu
 websitehttps://www.luvarealestate.com/
 address970 N. Kalaheo Ave
 address_2Suite A110
 cityKailua
 stateHI
 full_stateHawaii
 countryUSA
 market
 market_2
 postal_code96734
 phone808-262-5882
 phone_2
 phone_3
 wide_contact_image(true)
 contact_nameBrian Collins
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titlePartner
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebookhttps://www.facebook.com/LuvaRealEstate/
 contact_twitterhttps://twitter.com/luvarealestate?lang=en
 contact_instagramhttps://www.instagram.com/luva_real_estate/
 contact_pinterest
 contact_linkedinhttps://www.linkedin.com/company/luva-real-estate
 contact_youtube
 contact_phone818-898-8585
 contact_email_2[email protected]
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2989-929-9393
 contact_website
 contact_name_2Kimi Correa
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2Broker-in-Charge
 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_filename
 logo_filename
 contact_image_filename
 all_properties_link_image_filename
 all_properties_link
 video_embed_code
 contact_video_embed_code
 meta_title
 meta_description
 meta_keywords
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(false)
 created2019-12-03 19:18:48
 modified2023-02-07 16:55:06
 country_id0
 dre_num012345
 uri/brokerage-detail/103/luva-real-estate
 website_shortwww.luvarealestate.com
 name_with_locationLUVA Real Estate
 mlsidx_id_array(array)
 018
 127
 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)
 id2768
 modelProperty
 model_id157
 tagImage
 name202220295_4a430671f71aeb42c186e63444a854b8.jpg
 typeimage/jpeg
 size41343
 uri/assets/2768.jpg
 order0
 created2023-02-07 16:55:18
 modified2023-02-07 16:55:18
 1(array)
 id2769
 modelProperty
 model_id157
 tagImage
 name202220295_d06cb5bca867711bd3a9367facba964c.jpg
 typeimage/jpeg
 size40078
 uri/assets/2769.jpg
 order1
 created2023-02-07 16:55:19
 modified2023-02-07 16:55:19
 2(array)
 id2770
 modelProperty
 model_id157
 tagImage
 name202220295_b4d4049584d817b1b56a69a67841b728.jpg
 typeimage/jpeg
 size39865
 uri/assets/2770.jpg
 order2
 created2023-02-07 16:55:19
 modified2023-02-07 16:55:19
 3(array)
 id2771
 modelProperty
 model_id157
 tagImage
 name202220295_b8f7d0a5724d38ccbb320b59418882c2.jpg
 typeimage/jpeg
 size38948
 uri/assets/2771.jpg
 order3
 created2023-02-07 16:55:19
 modified2023-02-07 16:55:19
 4(array)
 id2772
 modelProperty
 model_id157
 tagImage
 name202220295_3502cc813ae7996415efcaa49fcd7fbf.jpg
 typeimage/jpeg
 size38331
 uri/assets/2772.jpg
 order4
 created2023-02-07 16:55:19
 modified2023-02-07 16:55:19
 5(array)
 id2773
 modelProperty
 model_id157
 tagImage
 name202220295_a31994368d6101b1b7af2eed5d96a25d.jpg
 typeimage/jpeg
 size41641
 uri/assets/2773.jpg
 order5
 created2023-02-07 16:55:19
 modified2023-02-07 16:55:19
 6(array)
 id2774
 modelProperty
 model_id157
 tagImage
 name202220295_1317fc6ac8c21965122b35107a86c87d.jpg
 typeimage/jpeg
 size35458
 uri/assets/2774.jpg
 order6
 created2023-02-07 16:55:19
 modified2023-02-07 16:55:19
 7(array)
 id2775
 modelProperty
 model_id157
 tagImage
 name202220295_d4e4f379d40dbe10ea2c8a771573ec1d.jpg
 typeimage/jpeg
 size27122
 uri/assets/2775.jpg
 order7
 created2023-02-07 16:55:19
 modified2023-02-07 16:55:19
 8(array)
 id2776
 modelProperty
 model_id157
 tagImage
 name202220295_16b10aabf3036373c0fa145be16bfcc2.jpg
 typeimage/jpeg
 size35893
 uri/assets/2776.jpg
 order8
 created2023-02-07 16:55:19
 modified2023-02-07 16:55:19
 9(array)
 id2777
 modelProperty
 model_id157
 tagImage
 name202220295_6aa4bddcd2496e65812e9c208980810f.jpg
 typeimage/jpeg
 size25068
 uri/assets/2777.jpg
 order9
 created2023-02-07 16:55:20
 modified2023-02-07 16:55:20
 10(array)
 id2778
 modelProperty
 model_id157
 tagImage
 name202220295_c28b19de389cd4126d0114cc976cdb56.jpg
 typeimage/jpeg
 size50251
 uri/assets/2778.jpg
 order10
 created2023-02-07 16:55:20
 modified2023-02-07 16:55:20
 User(empty)
 SecondaryPropertyCategory(empty)
 PropertyFeature(empty)
 Topic(empty)
- sidebar_locations(empty)
- highlighted_properties(array)
 0(array)
 Property(array)
 id157
 brokerage_id103
 created_by_user_id0
 order0
 multi_unit(false)
 agent_1_id0
 agent_2_id0
 agent_3_id0
 name350 Aoloa Street Unit: C107
 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(true)
 force_luxury_feed_featured(false)
 luxury_autofeed_imported(true)
 luxury_feed_last_added_time2023-02-07 16:55:18
 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_urlhttps://www.juwai.com/74465582.htm
 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)
 descriptionIn the heart of Kailua you will find this one bedroom, one bath, one parking with a storage unit condo waiting for its new owner. New flooring, freshly painted, new ceiling fans and washer/dryer in the unit. New appliances ( refrigerator on order and will be delivered in Oct.) Single level condo on the first floor ( elevated above the parking area ). One assigned covered parking stall, on site resident manager, landscaped grounds and a playground next to the BBQ area. Close to shopping and a bike ride to the beach. Super cute home waiting for its new owner.
 address350 Aoloa Street Unit: C107
 address_2
 cityKailua
 stateHI
 postal_code96734
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price450000
 price_20
 price_usd450000
 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)
 bedrooms1
 bedrooms_20
 bathrooms1
 bathrooms_20
 no_beds_baths(false)
 square_feet587
 square_meters
 acres0
 interior_unitsq_ft
 interior_size587
 lot_unitacres
 lot_size0
 icon_1
 icon_2
 icon_3
 icon_4
 icon_5
 icon_6
 website
 meta_title
 meta_description
 meta_keywords
 bathrooms_partial0
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built
 virtual_tour
 video_tour
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num202220295
 wsj_property_typecondo
 nyt_property_type5
 nyt_popular_features
 propgolux_property_type2
 juwai_property_typeApartments/Condo
 juwai_categoryresidential
 propgolux_property_style21
 wapo_property_typeCondominium
 robb_property_typeCondo
 propgolux_location_id_override
 open_house_1_start0000-00-00 00:00:00
 open_house_1_end_time00:00:00
 latitude21.390614
 longitude-157.738190
 invalid_required_fields
 invalid_optional_fields
 went_live_today(false)
 converted(false)
 invalid(false)
 mlsidx_full_address350 Aoloa Street Unit: C107 Kailua HI
 mlsidx_date_listed2022-09-28
 mls_marketHI_HBR
 primary_property_category_id0
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated2025-01-27 12:27:31
 modified2025-01-27 12:27:31
 created2023-02-07 16:55:18
 uri/property-detail/157/350-aoloa-street-unit-c107-kailua-hi-96734-usa
 absolute_urihttps://dev2.leveragere.com/property-detail/157/350-aoloa-street-unit-c107-kailua-hi-96734-usa
 address_concat350 Aoloa Street Unit: C107 Kailua HI 96734 USA
 google_maps_query_string350+Aoloa+Street+Unit%3A+C107++Kailua+HI+96734+USA
 luxury_ad_enrolled_prettyAUTO
 price_prettyUSD 450,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty1
 bathrooms_pretty1
 bathrooms_partial_pretty0
 bathrooms_3_4_pretty0
 feed_full_bathrooms1
 date_listed2022-09-28
 overridden_brokerage_nameLUVA Real Estate
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(true)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id103
 account_executive_id0
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typeBasic
 max_properties100
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeLegacy
 max_luxury_feed_properties-1
 membership_luxury_feed_properties-1
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 WOEID(null)
 timezonePacific/Honolulu
 luxury_feed_enrollment_modeauto
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id18,27
 mlsidx_auto_import_minimum_price0
 mlsidx_logo_url/img/logo-mls-listings.png
 mlsidx_disclaimerBased on information from the MLSListings MLS) as of {{date}} (date the MLS data was obtained). All data, including all measurements and calculations of area, is obtained from various sources and has not been, and will not be, verified by broker or MLS. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information.
 nameLUVA Real Estate
 broker_of_record_name
 short_nameLUVA Real Estate
 username
 password
 password_reset_hash
 monthly_invoice_amount0.00
 monthly_invoice_start_date(null)
 monthly_invoice_end_date(null)
 contract_filename
 active(true)
 lead_inLUVA Real Estate is the exclusive representative for Leverage Global Partners on the Island of Oahu including; Honolulu, HI, USA.
 short_description
 descriptionOUR STORY LUVA Real Estate was founded in 2012 as a lifestyle focused company bringing together like - minded individuals from the Real Estate, Entertainment and Start up Business sectors. Borne from the idea that there is no one-size-fits-all approach to its customers, LUVA prides itself on being a progressive, boutique-style, technologically savvy brokerage. LUVA has expanded their presence with the launch of it's Oahu office in 2018. WHO WE ARE: We are people. Adventurers, dog lovers, surfers, activists, Netflix bingers, paddlers, caffeine addicts, parents & partners. We are relational, not just transactional. The process of buying & selling real estate is an emotional, financial and mental journey. We partner with our clients through the ups & downs to achieve goals. WHAT WE DO: We tell stories. Selling a home is more complex than graphs & stats. We creatively convey the home’s story to align with a buyer’s hopes and dreams - making it a tangible thing. A physical place to create life & lifestyle. We provide solutions. We are professionals. We are solution driven. We are a mix plate - local hybrid combining all the best things - of information, technology, social media, collaboration and team work culture. Our goal is simple - “Connecting humans with homes.” Wish you were here? We can help you with that.
 communitiesHonolulu
 websitehttps://www.luvarealestate.com/
 address970 N. Kalaheo Ave
 address_2Suite A110
 cityKailua
 stateHI
 full_stateHawaii
 countryUSA
 market
 market_2
 postal_code96734
 phone808-262-5882
 phone_2
 phone_3
 wide_contact_image(true)
 contact_nameBrian Collins
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titlePartner
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebookhttps://www.facebook.com/LuvaRealEstate/
 contact_twitterhttps://twitter.com/luvarealestate?lang=en
 contact_instagramhttps://www.instagram.com/luva_real_estate/
 contact_pinterest
 contact_linkedinhttps://www.linkedin.com/company/luva-real-estate
 contact_youtube
 contact_phone818-898-8585
 contact_email_2[email protected]
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2989-929-9393
 contact_website
 contact_name_2Kimi Correa
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2Broker-in-Charge
 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_filename
 logo_filename
 contact_image_filename
 all_properties_link_image_filename
 all_properties_link
 video_embed_code
 contact_video_embed_code
 meta_title
 meta_description
 meta_keywords
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(false)
 created2019-12-03 19:18:48
 modified2023-02-07 16:55:06
 country_id0
 dre_num012345
 uri/brokerage-detail/103/luva-real-estate
 website_shortwww.luvarealestate.com
 name_with_locationLUVA Real Estate
 mlsidx_id_array(array)
 018
 127
 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)
 id2768
 modelProperty
 model_id157
 tagImage
 name202220295_4a430671f71aeb42c186e63444a854b8.jpg
 typeimage/jpeg
 size41343
 uri/assets/2768.jpg
 order0
 created2023-02-07 16:55:18
 modified2023-02-07 16:55:18
 1(array)
 id2769
 modelProperty
 model_id157
 tagImage
 name202220295_d06cb5bca867711bd3a9367facba964c.jpg
 typeimage/jpeg
 size40078
 uri/assets/2769.jpg
 order1
 created2023-02-07 16:55:19
 modified2023-02-07 16:55:19
 2(array)
 id2770
 modelProperty
 model_id157
 tagImage
 name202220295_b4d4049584d817b1b56a69a67841b728.jpg
 typeimage/jpeg
 size39865
 uri/assets/2770.jpg
 order2
 created2023-02-07 16:55:19
 modified2023-02-07 16:55:19
 3(array)
 id2771
 modelProperty
 model_id157
 tagImage
 name202220295_b8f7d0a5724d38ccbb320b59418882c2.jpg
 typeimage/jpeg
 size38948
 uri/assets/2771.jpg
 order3
 created2023-02-07 16:55:19
 modified2023-02-07 16:55:19
 4(array)
 id2772
 modelProperty
 model_id157
 tagImage
 name202220295_3502cc813ae7996415efcaa49fcd7fbf.jpg
 typeimage/jpeg
 size38331
 uri/assets/2772.jpg
 order4
 created2023-02-07 16:55:19
 modified2023-02-07 16:55:19
 5(array)
 id2773
 modelProperty
 model_id157
 tagImage
 name202220295_a31994368d6101b1b7af2eed5d96a25d.jpg
 typeimage/jpeg
 size41641
 uri/assets/2773.jpg
 order5
 created2023-02-07 16:55:19
 modified2023-02-07 16:55:19
 6(array)
 id2774
 modelProperty
 model_id157
 tagImage
 name202220295_1317fc6ac8c21965122b35107a86c87d.jpg
 typeimage/jpeg
 size35458
 uri/assets/2774.jpg
 order6
 created2023-02-07 16:55:19
 modified2023-02-07 16:55:19
 7(array)
 id2775
 modelProperty
 model_id157
 tagImage
 name202220295_d4e4f379d40dbe10ea2c8a771573ec1d.jpg
 typeimage/jpeg
 size27122
 uri/assets/2775.jpg
 order7
 created2023-02-07 16:55:19
 modified2023-02-07 16:55:19
 8(array)
 id2776
 modelProperty
 model_id157
 tagImage
 name202220295_16b10aabf3036373c0fa145be16bfcc2.jpg
 typeimage/jpeg
 size35893
 uri/assets/2776.jpg
 order8
 created2023-02-07 16:55:19
 modified2023-02-07 16:55:19
 9(array)
 id2777
 modelProperty
 model_id157
 tagImage
 name202220295_6aa4bddcd2496e65812e9c208980810f.jpg
 typeimage/jpeg
 size25068
 uri/assets/2777.jpg
 order9
 created2023-02-07 16:55:20
 modified2023-02-07 16:55:20
 10(array)
 id2778
 modelProperty
 model_id157
 tagImage
 name202220295_c28b19de389cd4126d0114cc976cdb56.jpg
 typeimage/jpeg
 size50251
 uri/assets/2778.jpg
 order10
 created2023-02-07 16:55:20
 modified2023-02-07 16:55:20
 User(empty)
 SecondaryPropertyCategory(empty)
 PropertyFeature(empty)
 Topic(empty)
 1(array)
 Property(array)
 id154
 brokerage_id103
 created_by_user_id0
 order0
 multi_unit(false)
 agent_1_id0
 agent_2_id0
 agent_3_id0
 name4176 Keanu Street Unit: 1
 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(true)
 force_luxury_feed_featured(false)
 luxury_autofeed_imported(true)
 luxury_feed_last_added_time2023-02-07 16:55:13
 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 beautiful end unit boasts pride of ownership and includes stainless steel appliances, newer refrigerator, granite kitchen counters, washer/dryer hidden in a custom-built cabinet, full size bath downstairs and upstairs, tiling throughout including storage closet for additional pantry or utility storage, plus a drop-down ladder to the attic storage. Warm wood cabinetry in kitchen and accents throughout. Lots of natural lighting from the windows in every room. Living room has split a/c, ceiling fan in one bedroom and window a/c in 2nd bedroom. This unit comes complete with all of the features you need for comfort style living. The desirable Tropic Gardens is a very peaceful residential community conveniently located close to Kahala Mall, schools, restaurants, walking distance to the new Kuono Marktplace at Kahala and just minutes from Waikiki, golf spots, beaches and so much more!
 address4176 Keanu Street Unit: 1
 address_2
 cityHonolulu
 stateHI
 postal_code96816
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price685000
 price_20
 price_usd685000
 price_usd_20
 statusFor Sale
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(false)
 bedrooms2
 bedrooms_20
 bathrooms2
 bathrooms_20
 no_beds_baths(false)
 square_feet1032
 square_meters
 acres0
 interior_unitsq_ft
 interior_size1032
 lot_unitacres
 lot_size0
 icon_1
 icon_2
 icon_3
 icon_4
 icon_5
 icon_6
 website
 meta_title
 meta_description
 meta_keywords
 bathrooms_partial0
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built
 virtual_tour
 video_tour
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num202219457
 wsj_property_typecondo
 nyt_property_type5
 nyt_popular_features
 propgolux_property_type2
 juwai_property_typeApartments/Condo
 juwai_categoryresidential
 propgolux_property_style21
 wapo_property_typeCondominium
 robb_property_typeCondo
 propgolux_location_id_override
 open_house_1_start0000-00-00 00:00:00
 open_house_1_end_time00:00:00
 latitude21.280785
 longitude-157.786285
 invalid_required_fields
 invalid_optional_fields
 went_live_today(false)
 converted(false)
 invalid(false)
 mlsidx_full_address4176 Keanu Street Unit: 1 Honolulu HI
 mlsidx_date_listed2022-09-14
 mls_marketHI_HBR
 primary_property_category_id0
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated(null)
 modified2023-12-18 18:33:01
 created2023-02-07 16:55:13
 uri/property-detail/154/4176-keanu-street-unit-1-honolulu-hi-96816-usa
 absolute_urihttps://dev2.leveragere.com/property-detail/154/4176-keanu-street-unit-1-honolulu-hi-96816-usa
 address_concat4176 Keanu Street Unit: 1 Honolulu HI 96816 USA
 google_maps_query_string4176+Keanu+Street+Unit%3A+1++Honolulu+HI+96816+USA
 luxury_ad_enrolled_prettyAUTO
 price_prettyUSD 685,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty2
 bathrooms_pretty2
 bathrooms_partial_pretty0
 bathrooms_3_4_pretty0
 feed_full_bathrooms2
 date_listed2022-09-14
 overridden_brokerage_nameLUVA Real Estate
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(true)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id103
 account_executive_id0
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typeBasic
 max_properties100
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeLegacy
 max_luxury_feed_properties-1
 membership_luxury_feed_properties-1
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 WOEID(null)
 timezonePacific/Honolulu
 luxury_feed_enrollment_modeauto
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id18,27
 mlsidx_auto_import_minimum_price0
 mlsidx_logo_url/img/logo-mls-listings.png
 mlsidx_disclaimerBased on information from the MLSListings MLS) as of {{date}} (date the MLS data was obtained). All data, including all measurements and calculations of area, is obtained from various sources and has not been, and will not be, verified by broker or MLS. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information.
 nameLUVA Real Estate
 broker_of_record_name
 short_nameLUVA Real Estate
 username
 password
 password_reset_hash
 monthly_invoice_amount0.00
 monthly_invoice_start_date(null)
 monthly_invoice_end_date(null)
 contract_filename
 active(true)
 lead_inLUVA Real Estate is the exclusive representative for Leverage Global Partners on the Island of Oahu including; Honolulu, HI, USA.
 short_description
 descriptionOUR STORY LUVA Real Estate was founded in 2012 as a lifestyle focused company bringing together like - minded individuals from the Real Estate, Entertainment and Start up Business sectors. Borne from the idea that there is no one-size-fits-all approach to its customers, LUVA prides itself on being a progressive, boutique-style, technologically savvy brokerage. LUVA has expanded their presence with the launch of it's Oahu office in 2018. WHO WE ARE: We are people. Adventurers, dog lovers, surfers, activists, Netflix bingers, paddlers, caffeine addicts, parents & partners. We are relational, not just transactional. The process of buying & selling real estate is an emotional, financial and mental journey. We partner with our clients through the ups & downs to achieve goals. WHAT WE DO: We tell stories. Selling a home is more complex than graphs & stats. We creatively convey the home’s story to align with a buyer’s hopes and dreams - making it a tangible thing. A physical place to create life & lifestyle. We provide solutions. We are professionals. We are solution driven. We are a mix plate - local hybrid combining all the best things - of information, technology, social media, collaboration and team work culture. Our goal is simple - “Connecting humans with homes.” Wish you were here? We can help you with that.
 communitiesHonolulu
 websitehttps://www.luvarealestate.com/
 address970 N. Kalaheo Ave
 address_2Suite A110
 cityKailua
 stateHI
 full_stateHawaii
 countryUSA
 market
 market_2
 postal_code96734
 phone808-262-5882
 phone_2
 phone_3
 wide_contact_image(true)
 contact_nameBrian Collins
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titlePartner
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebookhttps://www.facebook.com/LuvaRealEstate/
 contact_twitterhttps://twitter.com/luvarealestate?lang=en
 contact_instagramhttps://www.instagram.com/luva_real_estate/
 contact_pinterest
 contact_linkedinhttps://www.linkedin.com/company/luva-real-estate
 contact_youtube
 contact_phone818-898-8585
 contact_email_2[email protected]
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2989-929-9393
 contact_website
 contact_name_2Kimi Correa
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2Broker-in-Charge
 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_filename
 logo_filename
 contact_image_filename
 all_properties_link_image_filename
 all_properties_link
 video_embed_code
 contact_video_embed_code
 meta_title
 meta_description
 meta_keywords
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(false)
 created2019-12-03 19:18:48
 modified2023-02-07 16:55:06
 country_id0
 dre_num012345
 uri/brokerage-detail/103/luva-real-estate
 website_shortwww.luvarealestate.com
 name_with_locationLUVA Real Estate
 mlsidx_id_array(array)
 018
 127
 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)
 id2730
 modelProperty
 model_id154
 tagImage
 name202219457_c5604e505cde1d0d0d9a5897fc76c31a.jpg
 typeimage/jpeg
 size46882
 uri/assets/2730.jpg
 order0
 created2023-02-07 16:55:14
 modified2023-02-07 16:55:14
 1(array)
 id2731
 modelProperty
 model_id154
 tagImage
 name202219457_6554f7da27d0df03fdc32555117b826a.jpg
 typeimage/jpeg
 size48329
 uri/assets/2731.jpg
 order1
 created2023-02-07 16:55:14
 modified2023-02-07 16:55:14
 2(array)
 id2732
 modelProperty
 model_id154
 tagImage
 name202219457_8f9b2e08281d685dc95ca40626a52d17.jpg
 typeimage/jpeg
 size48448
 uri/assets/2732.jpg
 order2
 created2023-02-07 16:55:14
 modified2023-02-07 16:55:14
 3(array)
 id2733
 modelProperty
 model_id154
 tagImage
 name202219457_7c8c6ac13d7d75f85e12c131bb744ee6.jpg
 typeimage/jpeg
 size45353
 uri/assets/2733.jpg
 order3
 created2023-02-07 16:55:14
 modified2023-02-07 16:55:14
 4(array)
 id2734
 modelProperty
 model_id154
 tagImage
 name202219457_32cb8db464bc2fed9990be6e6c061e44.jpg
 typeimage/jpeg
 size55198
 uri/assets/2734.jpg
 order4
 created2023-02-07 16:55:14
 modified2023-02-07 16:55:14
 5(array)
 id2735
 modelProperty
 model_id154
 tagImage
 name202219457_86ca498d8cecfc21e742556d4f0cdfa2.jpg
 typeimage/jpeg
 size53569
 uri/assets/2735.jpg
 order5
 created2023-02-07 16:55:14
 modified2023-02-07 16:55:14
 6(array)
 id2736
 modelProperty
 model_id154
 tagImage
 name202219457_3f987b09cdc4e80f230de8eb14a28f24.jpg
 typeimage/jpeg
 size47028
 uri/assets/2736.jpg
 order6
 created2023-02-07 16:55:14
 modified2023-02-07 16:55:14
 7(array)
 id2737
 modelProperty
 model_id154
 tagImage
 name202219457_2854f2574f1cf2f5e7550c49c637ccd0.jpg
 typeimage/jpeg
 size73666
 uri/assets/2737.jpg
 order7
 created2023-02-07 16:55:15
 modified2023-02-07 16:55:15
 8(array)
 id2738
 modelProperty
 model_id154
 tagImage
 name202219457_e8d7b25920bcf1c4045327135d67b5f4.jpg
 typeimage/jpeg
 size48004
 uri/assets/2738.jpg
 order8
 created2023-02-07 16:55:15
 modified2023-02-07 16:55:15
 9(array)
 id2739
 modelProperty
 model_id154
 tagImage
 name202219457_06269f619bffb92b6de62b1cbcd85d98.jpg
 typeimage/jpeg
 size51459
 uri/assets/2739.jpg
 order9
 created2023-02-07 16:55:15
 modified2023-02-07 16:55:15
 10(array)
 id2740
 modelProperty
 model_id154
 tagImage
 name202219457_a0084ddd3b599a3e55b9d7e5d1fa6bbb.jpg
 typeimage/jpeg
 size51259
 uri/assets/2740.jpg
 order10
 created2023-02-07 16:55:15
 modified2023-02-07 16:55:15
 11(array)
 id2741
 modelProperty
 model_id154
 tagImage
 name202219457_cc1f64822027bf3a1479ea9a3dd8e018.jpg
 typeimage/jpeg
 size40970
 uri/assets/2741.jpg
 order11
 created2023-02-07 16:55:15
 modified2023-02-07 16:55:15
 12(array)
 id2742
 modelProperty
 model_id154
 tagImage
 name202219457_69cdd976ecb507863463563de2bfc37b.jpg
 typeimage/jpeg
 size91529
 uri/assets/2742.jpg
 order12
 created2023-02-07 16:55:15
 modified2023-02-07 16:55:15
 User(empty)
 SecondaryPropertyCategory(empty)
 PropertyFeature(empty)
 Topic(empty)
- custom_ga_event_properties(array)
 brokerageLUVA Real Estate, Kailua
- property(array)
 Property(array)
 id155
 brokerage_id103
 created_by_user_id0
 order0
 multi_unit(false)
 agent_1_id0
 agent_2_id0
 agent_3_id0
 name497 Kailua Road Unit: 2102
 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(true)
 force_luxury_feed_featured(false)
 luxury_autofeed_imported(true)
 luxury_feed_last_added_time2023-02-07 16:55:15
 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)
 descriptionEnjoy life in this beautifully maintained 3 bed, 2 bath condo here at Ka Malanai at Kailua, one of the most highly desirable complexes in Kailua. This first-floor, 1,433 square foot condo has a fantastic floor plan with a beautifully designed flow. You’ll love and appreciate the central AC and gorgeous plumeria trees surrounding both lanais (living lanai & primary bedroom lanai); this is Hawaii living at its best. The primary bedroom features a dressing area and a walk in closet! The generous sized bathrooms have modern fixtures and double sinks! Indoor laundry and ample storage throughout is a plus! In addition to living in a quiet, beautifully designed condo, you are right in the heart of Kailua where you can walk to all the restaurants, Target, Surf shops and boutiques. The beach is also just a short bike ride away! If you just want to lay low at Ka Malanai and relax, you can enjoy the community areas with BBQ and picnic tables, gorgeous landscaped green areas, and don’t forget to store your surf boards in the community storage! Welcome home, you found the most wonderful home for easy breezy island style life!
 address497 Kailua Road Unit: 2102
 address_2
 cityKailua
 stateHI
 postal_code96734
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price1175000
 price_20
 price_usd1175000
 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_feet1594
 square_meters
 acres0
 interior_unitsq_ft
 interior_size1594
 lot_unitacres
 lot_size0
 icon_1
 icon_2
 icon_3
 icon_4
 icon_5
 icon_6
 website
 meta_title
 meta_description
 meta_keywords
 bathrooms_partial0
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built
 virtual_tour
 video_tour
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num202216808
 wsj_property_typecondo
 nyt_property_type5
 nyt_popular_features
 propgolux_property_type2
 juwai_property_typeApartments/Condo
 juwai_categoryresidential
 propgolux_property_style21
 wapo_property_typeCondominium
 robb_property_typeCondo
 propgolux_location_id_override
 open_house_1_start0000-00-00 00:00:00
 open_house_1_end_time00:00:00
 latitude21.393122
 longitude-157.739578
 invalid_required_fields
 invalid_optional_fields
 went_live_today(false)
 converted(false)
 invalid(false)
 mlsidx_full_address497 Kailua Road Unit: 2102 Kailua HI
 mlsidx_date_listed2022-08-17
 mls_marketHI_HBR
 primary_property_category_id0
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated2025-01-24 16:04:07
 modified2025-01-24 16:04:07
 created2023-02-07 16:55:15
 uri/property-detail/155/497-kailua-road-unit-2102-kailua-hi-96734-usa
 absolute_urihttps://dev2.leveragere.com/property-detail/155/497-kailua-road-unit-2102-kailua-hi-96734-usa
 address_concat497 Kailua Road Unit: 2102 Kailua HI 96734 USA
 google_maps_query_string497+Kailua+Road+Unit%3A+2102++Kailua+HI+96734+USA
 luxury_ad_enrolled_prettyAUTO
 price_prettyUSD 1,175,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty3
 bathrooms_pretty2
 bathrooms_partial_pretty0
 bathrooms_3_4_pretty0
 feed_full_bathrooms2
 date_listed2022-08-17
 overridden_brokerage_nameLUVA Real Estate
 overridden_brokerage_logo_uri/assets/1777.jpg
 lux_ad_auto_enrolled(true)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id103
 account_executive_id0
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typeBasic
 max_properties100
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeLegacy
 max_luxury_feed_properties-1
 membership_luxury_feed_properties-1
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 WOEID(null)
 timezonePacific/Honolulu
 luxury_feed_enrollment_modeauto
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id18,27
 mlsidx_auto_import_minimum_price0
 mlsidx_logo_url/img/logo-mls-listings.png
 mlsidx_disclaimerBased on information from the MLSListings MLS) as of {{date}} (date the MLS data was obtained). All data, including all measurements and calculations of area, is obtained from various sources and has not been, and will not be, verified by broker or MLS. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information.
 nameLUVA Real Estate
 broker_of_record_name
 short_nameLUVA Real Estate
 username
 password
 password_reset_hash
 monthly_invoice_amount0.00
 monthly_invoice_start_date(null)
 monthly_invoice_end_date(null)
 contract_filename
 active(true)
 lead_inLUVA Real Estate is the exclusive representative for Leverage Global Partners on the Island of Oahu including; Honolulu, HI, USA.
 short_description
 descriptionOUR STORY LUVA Real Estate was founded in 2012 as a lifestyle focused company bringing together like - minded individuals from the Real Estate, Entertainment and Start up Business sectors. Borne from the idea that there is no one-size-fits-all approach to its customers, LUVA prides itself on being a progressive, boutique-style, technologically savvy brokerage. LUVA has expanded their presence with the launch of it's Oahu office in 2018. WHO WE ARE: We are people. Adventurers, dog lovers, surfers, activists, Netflix bingers, paddlers, caffeine addicts, parents & partners. We are relational, not just transactional. The process of buying & selling real estate is an emotional, financial and mental journey. We partner with our clients through the ups & downs to achieve goals. WHAT WE DO: We tell stories. Selling a home is more complex than graphs & stats. We creatively convey the home’s story to align with a buyer’s hopes and dreams - making it a tangible thing. A physical place to create life & lifestyle. We provide solutions. We are professionals. We are solution driven. We are a mix plate - local hybrid combining all the best things - of information, technology, social media, collaboration and team work culture. Our goal is simple - “Connecting humans with homes.” Wish you were here? We can help you with that.
 communitiesHonolulu
 websitehttps://www.luvarealestate.com/
 address970 N. Kalaheo Ave
 address_2Suite A110
 cityKailua
 stateHI
 full_stateHawaii
 countryUSA
 market
 market_2
 postal_code96734
 phone808-262-5882
 phone_2
 phone_3
 wide_contact_image(true)
 contact_nameBrian Collins
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titlePartner
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebookhttps://www.facebook.com/LuvaRealEstate/
 contact_twitterhttps://twitter.com/luvarealestate?lang=en
 contact_instagramhttps://www.instagram.com/luva_real_estate/
 contact_pinterest
 contact_linkedinhttps://www.linkedin.com/company/luva-real-estate
 contact_youtube
 contact_phone818-898-8585
 contact_email_2[email protected]
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2989-929-9393
 contact_website
 contact_name_2Kimi Correa
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2Broker-in-Charge
 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_filename
 logo_filename
 contact_image_filename
 all_properties_link_image_filename
 all_properties_link
 video_embed_code
 contact_video_embed_code
 meta_title
 meta_description
 meta_keywords
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(false)
 created2019-12-03 19:18:48
 modified2023-02-07 16:55:06
 country_id0
 dre_num012345
 AccountExecutive(empty)
 Logo(array)
 id1777
 modelBrokerage
 model_id103
 tagLogo
 name94725.jpg
 typeimage/jpeg
 size16291
 uri/assets/1777.jpg
 order0
 created2019-12-03 19:17:35
 modified2023-02-07 16:55:06
 MainImage(array)
 id1776
 modelBrokerage
 model_id103
 tagMainImage
 name94727.jpg
 typeimage/jpeg
 size102913
 uri/assets/1776.jpg
 order0
 created2019-12-03 19:17:15
 modified2023-02-07 16:55:06
 ContactImage(array)
 id1778
 modelBrokerage
 model_id103
 tagContactImage
 name94725.jpg
 typeimage/jpeg
 size16291
 uri/assets/1778.jpg
 order0
 created2019-12-03 19:18:21
 modified2023-02-07 16:55:06
 ContactImage2(empty)
 ContactImage3(empty)
 BrokerOfRecordLogo(empty)
 MainArticle(empty)
 FeaturedImage(empty)
 Location(empty)
 User(empty)
 uri/brokerage-detail/103/luva-real-estate
 website_shortwww.luvarealestate.com
 name_with_locationLUVA Real Estate
 mlsidx_id_array(array)
 018
 127
 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)
 id2743
 modelProperty
 model_id155
 tagImage
 name202216808_5a567766f3af310a17f5358c4448bb50.jpg
 typeimage/jpeg
 size52031
 uri/assets/2743.jpg
 order0
 created2023-02-07 16:55:15
 modified2023-02-07 16:55:15
 1(array)
 id2744
 modelProperty
 model_id155
 tagImage
 name202216808_11f6ea8a8e494fb040f06906efd008c6.jpg
 typeimage/jpeg
 size87159
 uri/assets/2744.jpg
 order1
 created2023-02-07 16:55:16
 modified2023-02-07 16:55:16
 2(array)
 id2745
 modelProperty
 model_id155
 tagImage
 name202216808_fe0047cfd43d9b7c5d267da93364c1a4.jpg
 typeimage/jpeg
 size47766
 uri/assets/2745.jpg
 order2
 created2023-02-07 16:55:16
 modified2023-02-07 16:55:16
 3(array)
 id2746
 modelProperty
 model_id155
 tagImage
 name202216808_247c4a017424e90ebf06b70727618624.jpg
 typeimage/jpeg
 size43569
 uri/assets/2746.jpg
 order3
 created2023-02-07 16:55:16
 modified2023-02-07 16:55:16
 4(array)
 id2747
 modelProperty
 model_id155
 tagImage
 name202216808_20dc44e4188578e1d12214fcd5caf45b.jpg
 typeimage/jpeg
 size53089
 uri/assets/2747.jpg
 order4
 created2023-02-07 16:55:16
 modified2023-02-07 16:55:16
 5(array)
 id2748
 modelProperty
 model_id155
 tagImage
 name202216808_39db995e7e07154b146952599753a2c1.jpg
 typeimage/jpeg
 size58714
 uri/assets/2748.jpg
 order5
 created2023-02-07 16:55:16
 modified2023-02-07 16:55:16
 6(array)
 id2749
 modelProperty
 model_id155
 tagImage
 name202216808_6ad9a9fc96c541dfaa267fefe3db66f0.jpg
 typeimage/jpeg
 size83746
 uri/assets/2749.jpg
 order6
 created2023-02-07 16:55:16
 modified2023-02-07 16:55:16
 7(array)
 id2750
 modelProperty
 model_id155
 tagImage
 name202216808_c5346828d972bb4fdc29e2f83434eed1.jpg
 typeimage/jpeg
 size54196
 uri/assets/2750.jpg
 order7
 created2023-02-07 16:55:16
 modified2023-02-07 16:55:16
 8(array)
 id2751
 modelProperty
 model_id155
 tagImage
 name202216808_14c8b6d19f8b10865eb74952f8887098.jpg
 typeimage/jpeg
 size56866
 uri/assets/2751.jpg
 order8
 created2023-02-07 16:55:16
 modified2023-02-07 16:55:16
 9(array)
 id2752
 modelProperty
 model_id155
 tagImage
 name202216808_756039c1ca7856f6a6bfc3dc13890f8a.jpg
 typeimage/jpeg
 size50713
 uri/assets/2752.jpg
 order9
 created2023-02-07 16:55:16
 modified2023-02-07 16:55:16
 10(array)
 id2753
 modelProperty
 model_id155
 tagImage
 name202216808_e159e81c677c1ea0cc539d6bebb36ca1.jpg
 typeimage/jpeg
 size67309
 uri/assets/2753.jpg
 order10
 created2023-02-07 16:55:16
 modified2023-02-07 16:55:16
 11(array)
 id2754
 modelProperty
 model_id155
 tagImage
 name202216808_5425840e13ded88e0b71f2159d96b419.jpg
 typeimage/jpeg
 size53863
 uri/assets/2754.jpg
 order11
 created2023-02-07 16:55:17
 modified2023-02-07 16:55:17
 12(array)
 id2755
 modelProperty
 model_id155
 tagImage
 name202216808_eeac6c0c9fa2b7dff8648bcb43a42ec1.jpg
 typeimage/jpeg
 size91695
 uri/assets/2755.jpg
 order12
 created2023-02-07 16:55:17
 modified2023-02-07 16:55:17
 13(array)
 id2756
 modelProperty
 model_id155
 tagImage
 name202216808_e073aaf6f381719b65bc4d386994781f.jpg
 typeimage/jpeg
 size38622
 uri/assets/2756.jpg
 order13
 created2023-02-07 16:55:17
 modified2023-02-07 16:55:17
 14(array)
 id2757
 modelProperty
 model_id155
 tagImage
 name202216808_de0a84ace7b60ec0659ac9a03388ed3f.jpg
 typeimage/jpeg
 size52999
 uri/assets/2757.jpg
 order14
 created2023-02-07 16:55:17
 modified2023-02-07 16:55:17
 15(array)
 id2758
 modelProperty
 model_id155
 tagImage
 name202216808_d581fa1b0bf4efcf3ea7c9286bcdb267.jpg
 typeimage/jpeg
 size50078
 uri/assets/2758.jpg
 order15
 created2023-02-07 16:55:17
 modified2023-02-07 16:55:17
 16(array)
 id2759
 modelProperty
 model_id155
 tagImage
 name202216808_88a7723e1af85c9278a01c5fdcace268.jpg
 typeimage/jpeg
 size45557
 uri/assets/2759.jpg
 order16
 created2023-02-07 16:55:17
 modified2023-02-07 16:55:17
 17(array)
 id2760
 modelProperty
 model_id155
 tagImage
 name202216808_f4bf19bfe1a3f0ad2ad46ea20fe366bc.jpg
 typeimage/jpeg
 size72467
 uri/assets/2760.jpg
 order17
 created2023-02-07 16:55:17
 modified2023-02-07 16:55:17
 18(array)
 id2761
 modelProperty
 model_id155
 tagImage
 name202216808_c839e6423b6f11b05785f964dec9dc89.jpg
 typeimage/jpeg
 size94414
 uri/assets/2761.jpg
 order18
 created2023-02-07 16:55:17
 modified2023-02-07 16:55:17
 19(array)
 id2762
 modelProperty
 model_id155
 tagImage
 name202216808_70c4537537a8fc7ca56e3cfbf9b19538.jpg
 typeimage/jpeg
 size94079
 uri/assets/2762.jpg
 order19
 created2023-02-07 16:55:17
 modified2023-02-07 16:55:17
 20(array)
 id2763
 modelProperty
 model_id155
 tagImage
 name202216808_fc9ca598239a48d065c001b175e7f482.jpg
 typeimage/jpeg
 size110539
 uri/assets/2763.jpg
 order20
 created2023-02-07 16:55:17
 modified2023-02-07 16:55:17
 21(array)
 id2764
 modelProperty
 model_id155
 tagImage
 name202216808_672b08e90c9963a6b0e0a50e1c92eef1.jpg
 typeimage/jpeg
 size125263
 uri/assets/2764.jpg
 order21
 created2023-02-07 16:55:18
 modified2023-02-07 16:55:18
 22(array)
 id2765
 modelProperty
 model_id155
 tagImage
 name202216808_df3d16719cb834424983c436439cd5d6.jpg
 typeimage/jpeg
 size59459
 uri/assets/2765.jpg
 order22
 created2023-02-07 16:55:18
 modified2023-02-07 16:55:18
 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/dev2/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	dev2
WEB_BASE_URL	https://dev2.leveragere.com
PROP_EMAIL_RECIPIENT	[email protected]
STRIPE_ISSUES_EMAIL_RECIPIENT	[email protected]
MEMBER_HELP_EMAIL_RECIPIENT	[email protected]
FEED_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/dev2/httpdocs/app/Console/cake.php

CakePHP Constants

Constant	Value
APP	/var/www/vhosts/leveragere.com/subdomains/dev2/httpdocs/app/
APP_DIR	app
APPLIBS	/var/www/vhosts/leveragere.com/subdomains/dev2/httpdocs/app/Lib/
CACHE	/var/www/vhosts/leveragere.com/subdomains/dev2/httpdocs/app/tmp/cache/
CAKE	/var/www/vhosts/leveragere.com/subdomains/dev2/httpdocs/lib/Cake/
CAKE_CORE_INCLUDE_PATH	/var/www/vhosts/leveragere.com/subdomains/dev2/httpdocs/lib
CORE_PATH	/var/www/vhosts/leveragere.com/subdomains/dev2/httpdocs/lib/
CAKE_VERSION	2.10.19
CSS	/var/www/vhosts/leveragere.com/subdomains/dev2/httpdocs/app/webroot/css/
CSS_URL	css/
DS	/
FULL_BASE_URL	https://dev2.leveragere.com
IMAGES	/var/www/vhosts/leveragere.com/subdomains/dev2/httpdocs/app/webroot/img/
IMAGES_URL	img/
JS	/var/www/vhosts/leveragere.com/subdomains/dev2/httpdocs/app/webroot/js/
JS_URL	js/
LOGS	/var/www/vhosts/leveragere.com/subdomains/dev2/httpdocs/app/tmp/logs/
ROOT	/var/www/vhosts/leveragere.com/subdomains/dev2/httpdocs
TESTS	/var/www/vhosts/leveragere.com/subdomains/dev2/httpdocs/app/Test/
TMP	/var/www/vhosts/leveragere.com/subdomains/dev2/httpdocs/app/tmp/
VENDORS	/var/www/vhosts/leveragere.com/subdomains/dev2/httpdocs/vendors/
WEBROOT_DIR	webroot
WWW_ROOT	/var/www/vhosts/leveragere.com/subdomains/dev2/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/155/497-kailua-road-unit-2102-kailua-hi-96734-usa
Query String
Request Method	GET
Server Protocol	HTTP/1.1
Gateway Interface	CGI/1.1
Redirect Url	/property-detail/155/497-kailua-road-unit-2102-kailua-hi-96734-usa
Remote Port	20716
Script Filename	/var/www/vhosts/leveragere.com/subdomains/dev2/httpdocs/app/webroot/index.php
Server Admin	root@localhost
Context Document Root	/var/www/vhosts/leveragere.com/subdomains/dev2/httpdocs/app/webroot
Context Prefix
Request Scheme	https
Document Root	/var/www/vhosts/leveragere.com/subdomains/dev2/httpdocs/app/webroot
Remote Addr	104.23.243.124
Server Port	443
Server Addr	172.24.32.44
Server Name	dev2.leveragere.com
Server Software	Apache
Server Signature
Path	/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin
Http Host	dev2.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.217.63
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	a07305965c97c892-CMH
Http X Forwarded For	216.73.217.63
Proxy-nokeepalive	1
Ssl Tls Sni	dev2.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	aiNeZJ6KG2zmvSDhGn62sAAAABA
Redirect Status	200
Redirect Ssl Tls Sni	dev2.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	aiNeZJ6KG2zmvSDhGn62sAAAABA
Fcgi Role	RESPONDER
Php Self	/index.php
Request Time Float	1780702820.9819
Request Time	1780702820

====

Include
+
Included Files

Include Paths
- 0/var/www/vhosts/leveragere.com/subdomains/dev2/httpdocs/lib
- 2/opt/plesk/php/7.4/share/pear
- 3-> /var/www/vhosts/leveragere.com/subdomains/dev2/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
====

497 Kailua Road Unit: 2102

Represented By: LUVA Real Estate

Highlighted Properties

350 Aoloa Street Unit: C107

4176 Keanu Street Unit: 1

Share This

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 26 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: 26 ms
Total Queries: 30 queries