Properties /

Over 100' of Pristine Colorado River

9853 S Dike Rd | Mohave Valley, AZ 86440, USA | $1,795,000

7 Beds
3 Baths
1 Half Ba
4 3/4 Ba
Dock
Waterfront
On The Sand

Main house includes 6 BDR and 7 Baths. Master suite located on main floor with jet tub, walk in shower and sweeping views of the Colorado River. 2 additional bdr suites on main floor as well. Dramatic entry with dynamic views of the river from 2 story entry faced with wall of windows. Plenty of room for sit down dinner or quick snack at the breakfast bar. Dream kitchen with granite counters, Dacon appliances, Sub Zero Refrigerator, gas cook top and views to the river. Upstairs you'll find spacious family room with 1/2 bath and closet with access to sundeck and 2 bedroom suites. Guests feel special in the mini master complete with private deck and views of the river. Catwalk connects family room and bedrooms with gorgeous views of the river, sandy beach and front yard compound. Short walk to guest house with over 750 sq ft. Over 100 ft of riverfront with sandy beach, private boat launch and dock. Electric gate entry, fully fenced acreage makes living on the river a true private vacation destination. Outdoor kitchen and covered patios! Sand between the toes and a bit of shade under the palapa as living on the river doesn't get any better than this.

Represented By: US Southwest

View On Map Property Website

Highlighted Properties

River Front Beauty with RV Garage

1801 Riverfront | Bullhead City, AZ 86442
$675,000

Arizona Ranch Located on 3 Acres

2303 E Hulet | Mohave Valley, AZ 86440
$1,275,000

Represented By

Featured Location

Bullhead City, AZ, USA

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)
  03466
  19853-s-dike-rd-mohave-valley-az-86440-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: 13 ms
Total Queries: 33 queries

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

Query Explain:

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

====

Timer

Memory

Peak Memory Use 14.42 MB

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

Timers

Total Request Time: 225 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	27.63
Event: Controller.initialize	5.10
Event: Controller.startup	1.35
Controller action	51.09
Event: Controller.beforeRender	13.97
» Processing toolbar data	13.87
Rendering View	86.78
» Event: View.beforeRender	0.40
» Rendering APP/View/Properties/view.ctp	3.21
» » Rendering APP/View/Elements/static_property_price.ctp	0.37
» » Rendering APP/View/Elements/property_features.ctp	0.23
» » Rendering APP/View/Elements/static_property_price.ctp #2	0.15
» » Rendering APP/View/Elements/static_property_price.ctp #3	0.14
» » Rendering APP/View/Elements/sidebar/location_list.ctp	0.14
» » Rendering APP/View/Elements/sidebar/property_list.ctp	1.01
» » » Rendering APP/View/Elements/static_property_price.ctp #4	0.14
» » » Rendering APP/View/Elements/static_property_price.ctp #5	0.14
» » » Rendering APP/View/Elements/static_property_price.ctp #6	0.14
» » » Rendering APP/View/Elements/static_property_price.ctp #7	0.15
» » Rendering APP/View/Elements/sidebar/property_search.ctp	0.20
» Event: View.afterRender	0.01
» Event: View.beforeLayout	0.01
» Rendering APP/View/Layouts/front.ctp	82.45
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)
 id3289
 brokerage_id192
 created_by_user_id0
 order0
 multi_unit(false)
 agent_1_id1099
 agent_2_id0
 agent_3_id0
 nameLuxurious Entertainment on the Colorado
 incomplete(false)
 archived(false)
 last_archived0000-00-00 00:00:00
 auto_archived_from_mlsidx(false)
 paid_featured(false)
 featured(true)
 homepage_featured(true)
 brokerage_page_featured(true)
 requested_homepage_featured_by_member(false)
 homepage_featured_by_member(false)
 dot_luxury_featured(false)
 luxury_feed_featured(false)
 force_luxury_feed_featured(false)
 luxury_autofeed_imported(false)
 luxury_feed_last_added_time0000-00-00 00:00:00
 luxury_feed_agent_user_id0
 luxury_feed_locked_to_subscription_id0
 luxury_feed_agent_purchase_date0000-00-00
 luxury_feed_agent_expiration_date0000-00-00
 digital_ad_summary_email_last_sent0000-00-00 00:00:00
 digital_ad_summary_price_changed(false)
 wsj_detail_url
 ft_detail_url
 nyt_detail_url
 juwai_detail_url
 pgl_detail_url
 mg_detail_url
 mg_c_detail_url
 mg_s_detail_url
 bp_detail_url
 mw_detail_url
 nikkei_detail_url
 wapo_detail_url
 robb_detail_url
 medium_featured(false)
 large_featured(false)
 detail_page(true)
 descriptionEnjoy the huge game room on the lower level with bath and walk out to your own boat dock. Relax in luxury in the upstairs Master Suite with separate Sitting Room with fireplace and enjoy spectacular panoramic river and mountain views from the balcony. The main floor boasts an impressive kitchen open to the living room with cozy fireplace. Enjoy river views from the kitchen and living room. Two large guest bedrooms and large utility room off of kitchen. Beautiful wood flooring as you enter in entry the front door. Relax by a beautiful atrium with water feature between the Casita and the main home. Huge garage with extra boat deep bay. Lots of room to store many toys. This home built with the highest quality of construction.
 address2961 Camino Del Rio
 address_2
 cityBullhead City
 stateAZ
 postal_code86442
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price1199900
 price_20
 price_usd1199900
 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(true)
 bedrooms4
 bedrooms_20
 bathrooms4
 bathrooms_20
 no_beds_baths(false)
 square_feet3265
 square_meters
 acres0
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size0
 icon_1dock
 icon_2balcony-terrace
 icon_3views
 icon_4waterfront
 icon_5sq-ft
 icon_6garage
 website
 meta_titleLuxurious Entertainment on the Colorado | Bullhead City Real Estate | US Southwest
 meta_description2961 Camino Del Rio is a property offered for sale in Bullhead City, AZ, USA, presented by US Southwest
 meta_keywords
 bathrooms_partial0
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built
 virtual_tourhttp://video214.com/play/1MZwyeb7rWZPmt7e5rq17w/s/dark
 video_tour
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num
 wsj_property_type
 nyt_property_type
 nyt_popular_features
 propgolux_property_type
 juwai_property_type
 juwai_category
 propgolux_property_style
 wapo_property_type
 robb_property_type
 propgolux_location_id_override
 open_house_1_start0000-00-00 00:00:00
 open_house_1_end_time00:00:00
 latitude0.000000
 longitude0.000000
 invalid_required_fieldslatitude, longitude
 invalid_optional_fieldsagent_2_id, square_meters, acres, hectares, bathrooms_partial, year_built, video_tour, wsj_property_type, nyt_property_type, propgolux_property_type, propgolux_property_style
 went_live_today(false)
 converted(true)
 invalid(false)
 mlsidx_full_address
 mlsidx_date_listed0000-00-00
 mls_market
 primary_property_category_id0
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated(null)
 modified2016-04-18 05:33:03
 created2016-01-15 12:25:37
 uri/property-detail/3289/2961-camino-del-rio-bullhead-city-az-86442-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3289/2961-camino-del-rio-bullhead-city-az-86442-usa
 address_concat2961 Camino Del Rio Bullhead City AZ 86442 USA
 google_maps_query_string2961+Camino+Del+Rio++Bullhead+City+AZ+86442+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 1,199,900
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty4
 bathrooms_pretty4
 bathrooms_partial_pretty0
 bathrooms_3_4_pretty0
 feed_full_bathrooms4
 date_listed2016-01-15
 overridden_brokerage_nameUS Southwest
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id192
 account_executive_id236
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID2371675
 timezoneUS/Mountain
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameUS Southwest
 broker_of_record_name
 short_nameUS Southwest
 usernameUSSouthwestLLC
 passwordaca3f804a48f1447c4a6fd356b1f302279862050
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date(null)
 monthly_invoice_end_date(null)
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionUS Southwest is the exclusive representative for Leverage Global Partners in Bullhead City, Mohave Valley, Fort Mohave AZ, USA. US Southwest is a boutique real estate company comprised of like minded pro-fessionals whose mission is to provide the best professional service so their clients can make informed decisions to achieve their goals. The talent and depth within the company is unmatched in Mohave County. Several of the key players at US Southwest have managed a business or owned their own busi- ness. The combined talents provide a unique business platform in which diversity, collaboration, team work, and professionalism, foster a business perspective and environment that generates creativity and productivity, and ultimately, successful results for clients. US Southwest has the capability, expertise and area relationships to assist its clients in any type of real estate endeavor. Its founders, Ann L. Pettit and Ray W. Jackson III, have worked in every kind of real estate enterprise for over 30 years in Northwestern Arizona and are perceived as innovative leaders and pioneers of the industry. They have a relationship building philosophy and their motto is - Your Success is Our Success.
 communitiesBullhead City Fort Mohave Mohave Valley
 websitehttp://ussw.net/
 address3767 Highway 95
 address_2
 cityBullhead City
 stateAZ
 full_stateArizona
 countryUSA
 market
 market_2
 postal_code86442
 phone(928) 763-2288
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameAnn Pettit
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleOwner
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename192.jpg
 logo_filename192.jpg
 contact_image_filename192.png
 all_properties_link_image_filename192.jpg
 all_properties_linkhttp://ussw.net/wolfnet-properties
 video_embed_code
 contact_video_embed_code
 meta_titleBullhead City Real Estate | US Southwest | Leverage Global Partners
 meta_descriptionUS Southwest is the exclusive representative for Leverage Global Partners in Bullhead City, AZ, USA.
 meta_keywordsUS Southwest LLC, Bullhead city real estate, arizona real estate, ann pettit, bullhead city, leverage global partners, Fort Mohave, Mohave Valley
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2015-02-13 10:18:22
 modified2016-04-08 16:34:20
 dre_num012345
 uri/brokerage-detail/192/us-southwest
 website_shortussw.net
 name_with_locationUS Southwest
 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)
 id18762
 modelProperty
 model_id3289
 tagImage
 name31796.jpg
 typeimage/jpg
 size1654279
 uri/assets/18762.jpg
 order0
 created2016-04-07 17:12:02
 modified2016-04-07 17:12:02
 1(array)
 id18766
 modelProperty
 model_id3289
 tagImage
 name31801.jpg
 typeimage/jpg
 size1927680
 uri/assets/18766.jpg
 order1
 created2016-04-07 17:12:02
 modified2016-04-07 17:12:02
 2(array)
 id18763
 modelProperty
 model_id3289
 tagImage
 name31798.jpg
 typeimage/jpg
 size1268763
 uri/assets/18763.jpg
 order2
 created2016-04-07 17:12:02
 modified2016-04-07 17:12:02
 3(array)
 id18764
 modelProperty
 model_id3289
 tagImage
 name31799.jpg
 typeimage/jpg
 size1064375
 uri/assets/18764.jpg
 order3
 created2016-04-07 17:12:02
 modified2016-04-07 17:12:02
 4(array)
 id18765
 modelProperty
 model_id3289
 tagImage
 name31800.jpg
 typeimage/jpg
 size1274906
 uri/assets/18765.jpg
 order4
 created2016-04-07 17:12:02
 modified2016-04-07 17:12:02
 5(array)
 id18761
 modelProperty
 model_id3289
 tagImage
 name31797.jpg
 typeimage/jpg
 size1174544
 uri/assets/18761.jpg
 order5
 created2016-04-07 17:12:02
 modified2016-04-07 17:12:02
 6(array)
 id18767
 modelProperty
 model_id3289
 tagImage
 name31802.jpg
 typeimage/jpg
 size847345
 uri/assets/18767.jpg
 order6
 created2016-04-07 17:12:02
 modified2016-04-07 17:12:02
 User(empty)
 SecondaryPropertyCategory(empty)
 PropertyFeature(array)
 0(array)
 id3
 nameDock
 additional(false)
 created2016-04-07 14:01:13
 modified2016-04-07 14:01:13
 PropertiesPropertyFeature(array)
 id3981
 property_id3289
 property_feature_id3
 1(array)
 id1
 nameBalcony/Terrace
 additional(false)
 created2016-04-07 14:00:26
 modified2016-04-07 14:00:26
 PropertiesPropertyFeature(array)
 id3982
 property_id3289
 property_feature_id1
 2(array)
 id14
 nameViews
 additional(false)
 created2016-04-07 14:04:55
 modified2016-04-07 14:04:55
 PropertiesPropertyFeature(array)
 id3983
 property_id3289
 property_feature_id14
 3(array)
 id17
 nameWaterfront
 additional(false)
 created2016-04-07 14:06:00
 modified2016-04-07 14:06:00
 PropertiesPropertyFeature(array)
 id3984
 property_id3289
 property_feature_id17
 4(array)
 id4
 nameGarage
 additional(false)
 created2016-04-07 14:01:52
 modified2016-04-07 14:01:52
 PropertiesPropertyFeature(array)
 id3985
 property_id3289
 property_feature_id4
 Topic(empty)
 1(array)
 Property(array)
 id3726
 brokerage_id192
 created_by_user_id0
 order0
 multi_unit(false)
 agent_1_id0
 agent_2_id0
 agent_3_id0
 nameOver 100 ft of Riverfront with Sandy Beach
 incomplete(false)
 archived(false)
 last_archived0000-00-00 00:00:00
 auto_archived_from_mlsidx(false)
 paid_featured(false)
 featured(false)
 homepage_featured(false)
 brokerage_page_featured(true)
 requested_homepage_featured_by_member(false)
 homepage_featured_by_member(false)
 dot_luxury_featured(false)
 luxury_feed_featured(false)
 force_luxury_feed_featured(false)
 luxury_autofeed_imported(false)
 luxury_feed_last_added_time0000-00-00 00:00:00
 luxury_feed_agent_user_id0
 luxury_feed_locked_to_subscription_id0
 luxury_feed_agent_purchase_date0000-00-00
 luxury_feed_agent_expiration_date0000-00-00
 digital_ad_summary_email_last_sent0000-00-00 00:00:00
 digital_ad_summary_price_changed(false)
 wsj_detail_url
 ft_detail_url
 nyt_detail_url
 juwai_detail_url
 pgl_detail_url
 mg_detail_url
 mg_c_detail_url
 mg_s_detail_url
 bp_detail_url
 mw_detail_url
 nikkei_detail_url
 wapo_detail_url
 robb_detail_url
 medium_featured(false)
 large_featured(false)
 detail_page(false)
 descriptionMain house includes 6 BDR and 7 Baths. Master suite located on main floor with jet tub, walk in shower and sweeping views of the Colorado River. 2 additional bdr suites on main floor as well. Dramatic entry with dynamic views of the river from 2 story entry faced with wall of windows. Plenty of room for sit down dinner or quick snack at the breakfast bar. Dream kitchen with granite counters, Dacon appliances, Sub Zero Refrigerator, gas cook top and views to the river. Upstairs you'll find spacious family room with 1/2 bath and closet with access to sundeck and 2 bedroom suites. Guests feel special in the mini master complete with private deck and views of the river. Catwalk connects family room and bedrooms with gorgeous views of the river, sandy beach and front yard compound. Short walk to guest house with over 750 sq ft. Over 100 ft of riverfront with sandy beach, private boat launch and dock. Electric gate entry, fully fenced acreage makes living on the river a true private vacation destination. Outdoor kitchen and covered patios! Sand between the toes and a bit of shade under the palapa as living on the river doesn't get any better than this.
 address9853 S Dike Rd
 address_2
 cityMohave Valley
 stateAZ
 postal_code86440
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price1750000
 price_20
 price_usd1750000
 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)
 bedrooms7
 bedrooms_20
 bathrooms3
 bathrooms_20
 no_beds_baths(false)
 square_feet5249
 square_meters
 acres52391
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size52391
 icon_1
 icon_2
 icon_3
 icon_4
 icon_5
 icon_6
 websitehttp://search.ussw.net/listing/912084
 meta_title
 meta_description
 meta_keywords
 bathrooms_partial4
 bathrooms_partial_20
 bathrooms_3_41
 bathrooms_3_4_20
 year_built1998
 virtual_tour
 video_tour
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num912084
 wsj_property_type
 nyt_property_type
 nyt_popular_features
 propgolux_property_type
 juwai_property_type
 juwai_category
 propgolux_property_style
 wapo_property_type
 robb_property_type
 propgolux_location_id_override
 open_house_1_start0000-00-00 00:00:00
 open_house_1_end_time00:00:00
 latitude37.090240
 longitude-95.712891
 invalid_required_fields
 invalid_optional_fields
 went_live_today(false)
 converted(true)
 invalid(false)
 mlsidx_full_address
 mlsidx_date_listed0000-00-00
 mls_market
 primary_property_category_id0
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated(null)
 modified2016-04-18 05:33:03
 created2016-04-13 10:23:58
 uri/property-detail/3726/9853-s-dike-rd-mohave-valley-az-86440-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3726/9853-s-dike-rd-mohave-valley-az-86440-usa
 address_concat9853 S Dike Rd Mohave Valley AZ 86440 USA
 google_maps_query_string9853+S+Dike+Rd++Mohave+Valley+AZ+86440+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 1,750,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty7
 bathrooms_pretty3
 bathrooms_partial_pretty4
 bathrooms_3_4_pretty1
 feed_full_bathrooms4
 date_listed2016-04-13
 overridden_brokerage_nameUS Southwest
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id192
 account_executive_id236
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID2371675
 timezoneUS/Mountain
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameUS Southwest
 broker_of_record_name
 short_nameUS Southwest
 usernameUSSouthwestLLC
 passwordaca3f804a48f1447c4a6fd356b1f302279862050
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date(null)
 monthly_invoice_end_date(null)
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionUS Southwest is the exclusive representative for Leverage Global Partners in Bullhead City, Mohave Valley, Fort Mohave AZ, USA. US Southwest is a boutique real estate company comprised of like minded pro-fessionals whose mission is to provide the best professional service so their clients can make informed decisions to achieve their goals. The talent and depth within the company is unmatched in Mohave County. Several of the key players at US Southwest have managed a business or owned their own busi- ness. The combined talents provide a unique business platform in which diversity, collaboration, team work, and professionalism, foster a business perspective and environment that generates creativity and productivity, and ultimately, successful results for clients. US Southwest has the capability, expertise and area relationships to assist its clients in any type of real estate endeavor. Its founders, Ann L. Pettit and Ray W. Jackson III, have worked in every kind of real estate enterprise for over 30 years in Northwestern Arizona and are perceived as innovative leaders and pioneers of the industry. They have a relationship building philosophy and their motto is - Your Success is Our Success.
 communitiesBullhead City Fort Mohave Mohave Valley
 websitehttp://ussw.net/
 address3767 Highway 95
 address_2
 cityBullhead City
 stateAZ
 full_stateArizona
 countryUSA
 market
 market_2
 postal_code86442
 phone(928) 763-2288
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameAnn Pettit
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleOwner
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename192.jpg
 logo_filename192.jpg
 contact_image_filename192.png
 all_properties_link_image_filename192.jpg
 all_properties_linkhttp://ussw.net/wolfnet-properties
 video_embed_code
 contact_video_embed_code
 meta_titleBullhead City Real Estate | US Southwest | Leverage Global Partners
 meta_descriptionUS Southwest is the exclusive representative for Leverage Global Partners in Bullhead City, AZ, USA.
 meta_keywordsUS Southwest LLC, Bullhead city real estate, arizona real estate, ann pettit, bullhead city, leverage global partners, Fort Mohave, Mohave Valley
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2015-02-13 10:18:22
 modified2016-04-08 16:34:20
 dre_num012345
 uri/brokerage-detail/192/us-southwest
 website_shortussw.net
 name_with_locationUS Southwest
 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)
 id20809
 modelProperty
 model_id3726
 tagImage
 name9853_Dike (1).jpg
 typeimage/jpeg
 size1946014
 uri/assets/20809.jpg
 order0
 created2016-04-13 10:23:45
 modified2016-04-13 10:23:59
 1(array)
 id20805
 modelProperty
 model_id3726
 tagImage
 name9853DikeRd_60.jpg
 typeimage/jpeg
 size464564
 uri/assets/20805.jpg
 order1
 created2016-04-13 10:23:43
 modified2016-04-13 10:23:59
 2(array)
 id20806
 modelProperty
 model_id3726
 tagImage
 name9853DikeRd_19.jpg
 typeimage/jpeg
 size270202
 uri/assets/20806.jpg
 order2
 created2016-04-13 10:23:43
 modified2016-04-13 10:23:59
 3(array)
 id20807
 modelProperty
 model_id3726
 tagImage
 name9853DikeRd_70.jpg
 typeimage/jpeg
 size288097
 uri/assets/20807.jpg
 order3
 created2016-04-13 10:23:44
 modified2016-04-13 10:23:59
 4(array)
 id20808
 modelProperty
 model_id3726
 tagImage
 name9853DikeRd_69.jpg
 typeimage/jpeg
 size444920
 uri/assets/20808.jpg
 order4
 created2016-04-13 10:23:44
 modified2016-04-13 10:23:59
 5(array)
 id20810
 modelProperty
 model_id3726
 tagImage
 name9853DikeRd_76.jpg
 typeimage/jpeg
 size404572
 uri/assets/20810.jpg
 order5
 created2016-04-13 10:23:53
 modified2016-04-13 10:23:59
 User(empty)
 SecondaryPropertyCategory(empty)
 PropertyFeature(array)
 0(array)
 id1
 nameBalcony/Terrace
 additional(false)
 created2016-04-07 14:00:26
 modified2016-04-07 14:00:26
 PropertiesPropertyFeature(array)
 id4387
 property_id3726
 property_feature_id1
 1(array)
 id2
 nameBeach Access
 additional(false)
 created2016-04-07 14:00:52
 modified2016-04-07 14:00:52
 PropertiesPropertyFeature(array)
 id4388
 property_id3726
 property_feature_id2
 2(array)
 id4
 nameGarage
 additional(false)
 created2016-04-07 14:01:52
 modified2016-04-07 14:01:52
 PropertiesPropertyFeature(array)
 id4389
 property_id3726
 property_feature_id4
 3(array)
 id10
 nameOn The Sand
 additional(false)
 created2016-04-07 14:03:36
 modified2016-04-07 14:03:36
 PropertiesPropertyFeature(array)
 id4390
 property_id3726
 property_feature_id10
 4(array)
 id11
 nameSki In/Ski Out
 additional(false)
 created2016-04-07 14:03:53
 modified2016-04-07 14:03:53
 PropertiesPropertyFeature(array)
 id4391
 property_id3726
 property_feature_id11
 5(array)
 id14
 nameViews
 additional(false)
 created2016-04-07 14:04:55
 modified2016-04-07 14:04:55
 PropertiesPropertyFeature(array)
 id4392
 property_id3726
 property_feature_id14
 6(array)
 id17
 nameWaterfront
 additional(false)
 created2016-04-07 14:06:00
 modified2016-04-07 14:06:00
 PropertiesPropertyFeature(array)
 id4393
 property_id3726
 property_feature_id17
 Topic(array)
 0(array)
 id8
 nameBeach
 created2016-02-25 11:25:00
 modified2016-02-25 11:30:26
 tile_nameBeach
 PropertiesTopic(array)
 id23
 property_id3726
 topic_id8
 1(array)
 id20
 nameUltra Lux
 created2016-02-25 11:25:00
 modified2016-02-25 11:35:37
 tile_nameUltra Lux
 PropertiesTopic(array)
 id24
 property_id3726
 topic_id20
 2(array)
 Property(array)
 id3154
 brokerage_id192
 created_by_user_id0
 order0
 multi_unit(false)
 agent_1_id103
 agent_2_id0
 agent_3_id0
 nameStunning Setting on the Colorado River
 incomplete(false)
 archived(false)
 last_archived0000-00-00 00:00:00
 auto_archived_from_mlsidx(false)
 paid_featured(false)
 featured(true)
 homepage_featured(true)
 brokerage_page_featured(true)
 requested_homepage_featured_by_member(false)
 homepage_featured_by_member(false)
 dot_luxury_featured(false)
 luxury_feed_featured(false)
 force_luxury_feed_featured(false)
 luxury_autofeed_imported(false)
 luxury_feed_last_added_time0000-00-00 00:00:00
 luxury_feed_agent_user_id0
 luxury_feed_locked_to_subscription_id0
 luxury_feed_agent_purchase_date0000-00-00
 luxury_feed_agent_expiration_date0000-00-00
 digital_ad_summary_email_last_sent0000-00-00 00:00:00
 digital_ad_summary_price_changed(false)
 wsj_detail_url
 ft_detail_url
 nyt_detail_url
 juwai_detail_url
 pgl_detail_url
 mg_detail_url
 mg_c_detail_url
 mg_s_detail_url
 bp_detail_url
 mw_detail_url
 nikkei_detail_url
 wapo_detail_url
 robb_detail_url
 medium_featured(false)
 large_featured(false)
 detail_page(true)
 descriptionHome boasts its own launch and front beach area. Spacious great room overlooks the river with breathtaking views from patio in all directions. Charming country western theme. Roomy kitchen with island for an easy entertaining lifestyle with all the bells and whistles. Lower level has a fun diner theme so you can come in off of the river, relax, and enjoy refreshments at the counter bar. Hard to find over 1/2 acre on the mighty Colorado. An electric gated entrance adds to the privacy of this very unique property.
 address2777 Camino Del Rio
 address_2
 cityBullhead City
 stateAZ
 postal_code86442
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price1295000
 price_20
 price_usd1295000
 price_usd_20
 statusFor Sale
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(false)
 bedrooms5
 bedrooms_20
 bathrooms5
 bathrooms_20
 no_beds_baths(false)
 square_feet4925
 square_meters
 acres0
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size0
 icon_1waterfront
 icon_2sq-ft
 icon_3views
 icon_4
 icon_5
 icon_6
 website
 meta_titleStunning Setting on the Colorado River | Bullhead City Real Estate | US Southwest
 meta_description2777 Camino Del Rio is a property offered for sale in Bullhead City, AZ, USA, presented by US Southwest
 meta_keywords
 bathrooms_partial0
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built
 virtual_tour
 video_tour
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num
 wsj_property_type
 nyt_property_type
 nyt_popular_features
 propgolux_property_type
 juwai_property_type
 juwai_category
 propgolux_property_style
 wapo_property_type
 robb_property_type
 propgolux_location_id_override
 open_house_1_start0000-00-00 00:00:00
 open_house_1_end_time00:00:00
 latitude0.000000
 longitude0.000000
 invalid_required_fields
 invalid_optional_fieldsagent_2_id, bathrooms_partial, square_meters, acres, hectares, virtual_tour, video_tour
 went_live_today(false)
 converted(true)
 invalid(false)
 mlsidx_full_address
 mlsidx_date_listed0000-00-00
 mls_market
 primary_property_category_id0
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated(null)
 modified2016-04-18 05:33:02
 created2015-11-25 13:37:02
 uri/property-detail/3154/2777-camino-del-rio-bullhead-city-az-86442-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3154/2777-camino-del-rio-bullhead-city-az-86442-usa
 address_concat2777 Camino Del Rio Bullhead City AZ 86442 USA
 google_maps_query_string2777+Camino+Del+Rio++Bullhead+City+AZ+86442+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 1,295,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty5
 bathrooms_pretty5
 bathrooms_partial_pretty0
 bathrooms_3_4_pretty0
 feed_full_bathrooms5
 date_listed2015-11-25
 overridden_brokerage_nameUS Southwest
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id192
 account_executive_id236
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID2371675
 timezoneUS/Mountain
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameUS Southwest
 broker_of_record_name
 short_nameUS Southwest
 usernameUSSouthwestLLC
 passwordaca3f804a48f1447c4a6fd356b1f302279862050
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date(null)
 monthly_invoice_end_date(null)
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionUS Southwest is the exclusive representative for Leverage Global Partners in Bullhead City, Mohave Valley, Fort Mohave AZ, USA. US Southwest is a boutique real estate company comprised of like minded pro-fessionals whose mission is to provide the best professional service so their clients can make informed decisions to achieve their goals. The talent and depth within the company is unmatched in Mohave County. Several of the key players at US Southwest have managed a business or owned their own busi- ness. The combined talents provide a unique business platform in which diversity, collaboration, team work, and professionalism, foster a business perspective and environment that generates creativity and productivity, and ultimately, successful results for clients. US Southwest has the capability, expertise and area relationships to assist its clients in any type of real estate endeavor. Its founders, Ann L. Pettit and Ray W. Jackson III, have worked in every kind of real estate enterprise for over 30 years in Northwestern Arizona and are perceived as innovative leaders and pioneers of the industry. They have a relationship building philosophy and their motto is - Your Success is Our Success.
 communitiesBullhead City Fort Mohave Mohave Valley
 websitehttp://ussw.net/
 address3767 Highway 95
 address_2
 cityBullhead City
 stateAZ
 full_stateArizona
 countryUSA
 market
 market_2
 postal_code86442
 phone(928) 763-2288
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameAnn Pettit
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleOwner
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename192.jpg
 logo_filename192.jpg
 contact_image_filename192.png
 all_properties_link_image_filename192.jpg
 all_properties_linkhttp://ussw.net/wolfnet-properties
 video_embed_code
 contact_video_embed_code
 meta_titleBullhead City Real Estate | US Southwest | Leverage Global Partners
 meta_descriptionUS Southwest is the exclusive representative for Leverage Global Partners in Bullhead City, AZ, USA.
 meta_keywordsUS Southwest LLC, Bullhead city real estate, arizona real estate, ann pettit, bullhead city, leverage global partners, Fort Mohave, Mohave Valley
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2015-02-13 10:18:22
 modified2016-04-08 16:34:20
 dre_num012345
 uri/brokerage-detail/192/us-southwest
 website_shortussw.net
 name_with_locationUS Southwest
 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)
 id16839
 modelProperty
 model_id3154
 tagImage
 name30307.jpg
 typeimage/jpg
 size348375
 uri/assets/16839.jpg
 order0
 created2016-04-07 17:00:12
 modified2016-04-07 17:00:12
 1(array)
 id16835
 modelProperty
 model_id3154
 tagImage
 name30308.jpg
 typeimage/jpg
 size398669
 uri/assets/16835.jpg
 order1
 created2016-04-07 17:00:12
 modified2016-04-07 17:00:12
 2(array)
 id16834
 modelProperty
 model_id3154
 tagImage
 name30310.jpg
 typeimage/jpg
 size366697
 uri/assets/16834.jpg
 order3
 created2016-04-07 17:00:12
 modified2016-04-07 17:00:12
 3(array)
 id16838
 modelProperty
 model_id3154
 tagImage
 name30311.jpg
 typeimage/jpg
 size456592
 uri/assets/16838.jpg
 order4
 created2016-04-07 17:00:12
 modified2016-04-07 17:00:12
 4(array)
 id16833
 modelProperty
 model_id3154
 tagImage
 name30312.jpg
 typeimage/jpg
 size541353
 uri/assets/16833.jpg
 order5
 created2016-04-07 17:00:12
 modified2016-04-07 17:00:12
 5(array)
 id16837
 modelProperty
 model_id3154
 tagImage
 name30313.jpg
 typeimage/jpg
 size705325
 uri/assets/16837.jpg
 order6
 created2016-04-07 17:00:12
 modified2016-04-07 17:00:12
 6(array)
 id16832
 modelProperty
 model_id3154
 tagImage
 name30314.jpg
 typeimage/jpg
 size591219
 uri/assets/16832.jpg
 order7
 created2016-04-07 17:00:12
 modified2016-04-07 17:00:12
 7(array)
 id16836
 modelProperty
 model_id3154
 tagImage
 name31083.jpg
 typeimage/jpg
 size1023241
 uri/assets/16836.jpg
 order7
 created2016-04-07 17:00:12
 modified2016-04-07 17:00:12
 User(array)
 0(array)
 id332
 typeAgent
 brokerage_id192
 email[email protected]
 password379216c1d1f823296a376037feefa9c12b2e3648
 recover_hash
 first_nameAnn
 last_namePettit
 title
 dre_num
 phone(928)234-5555
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:22:47
 created2017-08-07 15:22:47
 notified(false)
 full_nameAnn Pettit
 uri/agent-detail/332/ann-pettit
 profile_complete(true)
 UsersProperty(array)
 id117
 user_id332
 property_id3154
 sort_order0
 SecondaryPropertyCategory(empty)
 PropertyFeature(array)
 0(array)
 id17
 nameWaterfront
 additional(false)
 created2016-04-07 14:06:00
 modified2016-04-07 14:06:00
 PropertiesPropertyFeature(array)
 id3504
 property_id3154
 property_feature_id17
 1(array)
 id14
 nameViews
 additional(false)
 created2016-04-07 14:04:55
 modified2016-04-07 14:04:55
 PropertiesPropertyFeature(array)
 id3505
 property_id3154
 property_feature_id14
 Topic(empty)
 3(array)
 Property(array)
 id3724
 brokerage_id192
 created_by_user_id0
 order0
 multi_unit(false)
 agent_1_id0
 agent_2_id0
 agent_3_id0
 nameExquisite Home in Laughlin Ranch - Hacienda Style & Inspiration
 incomplete(false)
 archived(false)
 last_archived0000-00-00 00:00:00
 auto_archived_from_mlsidx(false)
 paid_featured(false)
 featured(false)
 homepage_featured(false)
 brokerage_page_featured(false)
 requested_homepage_featured_by_member(false)
 homepage_featured_by_member(false)
 dot_luxury_featured(false)
 luxury_feed_featured(false)
 force_luxury_feed_featured(false)
 luxury_autofeed_imported(false)
 luxury_feed_last_added_time0000-00-00 00:00:00
 luxury_feed_agent_user_id0
 luxury_feed_locked_to_subscription_id0
 luxury_feed_agent_purchase_date0000-00-00
 luxury_feed_agent_expiration_date0000-00-00
 digital_ad_summary_email_last_sent0000-00-00 00:00:00
 digital_ad_summary_price_changed(false)
 wsj_detail_url
 ft_detail_url
 nyt_detail_url
 juwai_detail_url
 pgl_detail_url
 mg_detail_url
 mg_c_detail_url
 mg_s_detail_url
 bp_detail_url
 mw_detail_url
 nikkei_detail_url
 wapo_detail_url
 robb_detail_url
 medium_featured(false)
 large_featured(false)
 detail_page(false)
 descriptionExquisitely detailed with inspirations of Santa Fe & Hacienda design, located in the prestigious community of Laughlin Ranch. Situated on a cul-de-sac overlooking panoramic views of the golf course, Laughlin Casinos, with breathtaking mountain vistas and sunsets, this distinctive custom home boasts a gourmet chef's kitchen with an open concept living space, travertine, granite and stone features throughout, 4 large bedrooms including a Master suite plus 3 en-suite bedrooms, approx. 5000 sf of elegant living space. One guest suite has a private courtyard access. Ideal for entertaining inside with game room that transitions to outdoor luxury. Pebble tech pool and spa, water features, a fireside patio, stone walkways meandering through lush landscaping creating many intimate outdoor spaces, and to top it off, a viewing deck. Conveniently located to Lake Mohave, the Colorado River, Laughin/Bullhead international airport, great dining, hiking, off roading and all kinds of desert recreation.
 address1378 Pioneer Trail
 address_2
 cityBullhead City
 stateAZ
 postal_code86442
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price1190000
 price_20
 price_usd1190000
 price_usd_20
 statusFor Sale
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(false)
 bedrooms4
 bedrooms_20
 bathrooms4
 bathrooms_20
 no_beds_baths(false)
 square_feet4934
 square_meters
 acres17860
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size17860
 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_built2006
 virtual_tourhttp://video214.com/play/FUQUqDK9MdVJc65cZDV4ig/s/dark
 video_tour
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num913887
 wsj_property_typesingle family
 nyt_property_type1
 nyt_popular_features
 propgolux_property_type9
 juwai_property_type
 juwai_category
 propgolux_property_style
 wapo_property_type
 robb_property_type
 propgolux_location_id_override
 open_house_1_start0000-00-00 00:00:00
 open_house_1_end_time00:00:00
 latitude37.090240
 longitude37.090240
 invalid_required_fields
 invalid_optional_fields
 went_live_today(false)
 converted(true)
 invalid(false)
 mlsidx_full_address
 mlsidx_date_listed0000-00-00
 mls_market
 primary_property_category_id2
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated(null)
 modified2019-08-22 10:13:28
 created2016-04-13 09:58:24
 uri/property-detail/3724/1378-pioneer-trail-bullhead-city-az-86442-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3724/1378-pioneer-trail-bullhead-city-az-86442-usa
 address_concat1378 Pioneer Trail Bullhead City AZ 86442 USA
 google_maps_query_string1378+Pioneer+Trail++Bullhead+City+AZ+86442+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 1,190,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty4
 bathrooms_pretty4
 bathrooms_partial_pretty1
 bathrooms_3_4_pretty0
 feed_full_bathrooms4
 date_listed2016-04-13
 overridden_brokerage_nameUS Southwest
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id2
 nameVacation Homes
 created2019-08-22 10:07:58
 modified2019-08-29 09:59:17
 uri/category-detail/2/vacation-homes
 Brokerage(array)
 id192
 account_executive_id236
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID2371675
 timezoneUS/Mountain
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameUS Southwest
 broker_of_record_name
 short_nameUS Southwest
 usernameUSSouthwestLLC
 passwordaca3f804a48f1447c4a6fd356b1f302279862050
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date(null)
 monthly_invoice_end_date(null)
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionUS Southwest is the exclusive representative for Leverage Global Partners in Bullhead City, Mohave Valley, Fort Mohave AZ, USA. US Southwest is a boutique real estate company comprised of like minded pro-fessionals whose mission is to provide the best professional service so their clients can make informed decisions to achieve their goals. The talent and depth within the company is unmatched in Mohave County. Several of the key players at US Southwest have managed a business or owned their own busi- ness. The combined talents provide a unique business platform in which diversity, collaboration, team work, and professionalism, foster a business perspective and environment that generates creativity and productivity, and ultimately, successful results for clients. US Southwest has the capability, expertise and area relationships to assist its clients in any type of real estate endeavor. Its founders, Ann L. Pettit and Ray W. Jackson III, have worked in every kind of real estate enterprise for over 30 years in Northwestern Arizona and are perceived as innovative leaders and pioneers of the industry. They have a relationship building philosophy and their motto is - Your Success is Our Success.
 communitiesBullhead City Fort Mohave Mohave Valley
 websitehttp://ussw.net/
 address3767 Highway 95
 address_2
 cityBullhead City
 stateAZ
 full_stateArizona
 countryUSA
 market
 market_2
 postal_code86442
 phone(928) 763-2288
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameAnn Pettit
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleOwner
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename192.jpg
 logo_filename192.jpg
 contact_image_filename192.png
 all_properties_link_image_filename192.jpg
 all_properties_linkhttp://ussw.net/wolfnet-properties
 video_embed_code
 contact_video_embed_code
 meta_titleBullhead City Real Estate | US Southwest | Leverage Global Partners
 meta_descriptionUS Southwest is the exclusive representative for Leverage Global Partners in Bullhead City, AZ, USA.
 meta_keywordsUS Southwest LLC, Bullhead city real estate, arizona real estate, ann pettit, bullhead city, leverage global partners, Fort Mohave, Mohave Valley
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2015-02-13 10:18:22
 modified2016-04-08 16:34:20
 dre_num012345
 uri/brokerage-detail/192/us-southwest
 website_shortussw.net
 name_with_locationUS Southwest
 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)
 id20792
 modelProperty
 model_id3724
 tagImage
 name1378PioneerTrailEvening_05.jpg
 typeimage/jpeg
 size849441
 uri/assets/20792.jpg
 order0
 created2016-04-13 10:06:34
 modified2016-04-13 10:09:37
 1(array)
 id20799
 modelProperty
 model_id3724
 tagImage
 name1378PioneerTrailEvening_07.jpg
 typeimage/jpeg
 size617654
 uri/assets/20799.jpg
 order1
 created2016-04-13 10:06:37
 modified2016-04-13 10:09:37
 2(array)
 id20801
 modelProperty
 model_id3724
 tagImage
 name1378PioneerTrailEvening_10.jpg
 typeimage/jpeg
 size681670
 uri/assets/20801.jpg
 order2
 created2016-04-13 10:07:44
 modified2016-04-13 10:09:37
 3(array)
 id20794
 modelProperty
 model_id3724
 tagImage
 name1378PioneerTrailEvening_06.jpg
 typeimage/jpeg
 size666175
 uri/assets/20794.jpg
 order3
 created2016-04-13 10:06:35
 modified2016-04-13 10:09:37
 4(array)
 id20804
 modelProperty
 model_id3724
 tagImage
 name1378PioneerTrailEvening_11.jpg
 typeimage/jpeg
 size732590
 uri/assets/20804.jpg
 order4
 created2016-04-13 10:09:26
 modified2016-04-13 10:09:37
 5(array)
 id20793
 modelProperty
 model_id3724
 tagImage
 name1378PioneerTrailEvening_14.jpg
 typeimage/jpeg
 size746093
 uri/assets/20793.jpg
 order5
 created2016-04-13 10:06:34
 modified2016-04-13 10:09:37
 6(array)
 id20796
 modelProperty
 model_id3724
 tagImage
 name1378PioneerTrailEvening_17.jpg
 typeimage/jpeg
 size490317
 uri/assets/20796.jpg
 order6
 created2016-04-13 10:06:35
 modified2016-04-13 10:09:37
 7(array)
 id20800
 modelProperty
 model_id3724
 tagImage
 name1378PioneerTrailEvening_26.jpg
 typeimage/jpeg
 size748348
 uri/assets/20800.jpg
 order7
 created2016-04-13 10:06:37
 modified2016-04-13 10:09:37
 8(array)
 id20802
 modelProperty
 model_id3724
 tagImage
 name1378PioneerTrailEvening_21.jpg
 typeimage/jpeg
 size703236
 uri/assets/20802.jpg
 order8
 created2016-04-13 10:08:09
 modified2016-04-13 10:09:37
 9(array)
 id20803
 modelProperty
 model_id3724
 tagImage
 name1378PioneerTrailEvening_24.jpg
 typeimage/jpeg
 size704820
 uri/assets/20803.jpg
 order9
 created2016-04-13 10:08:24
 modified2016-04-13 10:09:37
 User(array)
 0(array)
 id332
 typeAgent
 brokerage_id192
 email[email protected]
 password379216c1d1f823296a376037feefa9c12b2e3648
 recover_hash
 first_nameAnn
 last_namePettit
 title
 dre_num
 phone(928)234-5555
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:22:47
 created2017-08-07 15:22:47
 notified(false)
 full_nameAnn Pettit
 uri/agent-detail/332/ann-pettit
 profile_complete(true)
 UsersProperty(array)
 id118
 user_id332
 property_id3724
 sort_order0
 SecondaryPropertyCategory(empty)
 PropertyFeature(array)
 0(array)
 id1
 nameBalcony/Terrace
 additional(false)
 created2016-04-07 14:00:26
 modified2016-04-07 14:00:26
 PropertiesPropertyFeature(array)
 id4383
 property_id3724
 property_feature_id1
 1(array)
 id4
 nameGarage
 additional(false)
 created2016-04-07 14:01:52
 modified2016-04-07 14:01:52
 PropertiesPropertyFeature(array)
 id4384
 property_id3724
 property_feature_id4
 2(array)
 id12
 nameSwimming Pool
 additional(false)
 created2016-04-07 14:04:12
 modified2016-04-07 14:04:12
 PropertiesPropertyFeature(array)
 id4385
 property_id3724
 property_feature_id12
 3(array)
 id14
 nameViews
 additional(false)
 created2016-04-07 14:04:55
 modified2016-04-07 14:04:55
 PropertiesPropertyFeature(array)
 id4386
 property_id3724
 property_feature_id14
 Topic(array)
 0(array)
 id20
 nameUltra Lux
 created2016-02-25 11:25:00
 modified2016-02-25 11:35:37
 tile_nameUltra Lux
 PropertiesTopic(array)
 id54
 property_id3724
 topic_id20
 1(array)
 id14
 nameSpanish Architecture
 created2016-02-25 11:25:00
 modified2016-02-25 11:34:03
 tile_nameSpanish Architecture
 PropertiesTopic(array)
 id53
 property_id3724
 topic_id14
 2(array)
 id4
 nameKiller Views
 created2016-02-25 11:25:00
 modified2016-02-25 11:33:10
 tile_nameKiller Views
 PropertiesTopic(array)
 id52
 property_id3724
 topic_id4
- sidebar_locations(array)
 0(array)
 Location(array)
 id94
 parent_id9
 brokerage_id192
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameBullhead City, AZ, USA
 short_nameBullhead City, AZ, USA
 group_index
 latitude35.135941
 longitude-114.528595
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_description
 long_descriptionMore information coming soon!
 created2016-04-05 11:28:06
 modified2016-04-05 11:28:06
 timezoneAmerica/Phoenix
 population40000
 uri/locations/view/94/bullhead-city-az-usa
 tile_nameBullhead City, AZ, USA
 Brokerage(array)
 id192
 account_executive_id236
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID2371675
 timezoneUS/Mountain
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameUS Southwest
 broker_of_record_name
 short_nameUS Southwest
 usernameUSSouthwestLLC
 passwordaca3f804a48f1447c4a6fd356b1f302279862050
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date(null)
 monthly_invoice_end_date(null)
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionUS Southwest is the exclusive representative for Leverage Global Partners in Bullhead City, Mohave Valley, Fort Mohave AZ, USA. US Southwest is a boutique real estate company comprised of like minded pro-fessionals whose mission is to provide the best professional service so their clients can make informed decisions to achieve their goals. The talent and depth within the company is unmatched in Mohave County. Several of the key players at US Southwest have managed a business or owned their own busi- ness. The combined talents provide a unique business platform in which diversity, collaboration, team work, and professionalism, foster a business perspective and environment that generates creativity and productivity, and ultimately, successful results for clients. US Southwest has the capability, expertise and area relationships to assist its clients in any type of real estate endeavor. Its founders, Ann L. Pettit and Ray W. Jackson III, have worked in every kind of real estate enterprise for over 30 years in Northwestern Arizona and are perceived as innovative leaders and pioneers of the industry. They have a relationship building philosophy and their motto is - Your Success is Our Success.
 communitiesBullhead City Fort Mohave Mohave Valley
 websitehttp://ussw.net/
 address3767 Highway 95
 address_2
 cityBullhead City
 stateAZ
 full_stateArizona
 countryUSA
 market
 market_2
 postal_code86442
 phone(928) 763-2288
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameAnn Pettit
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleOwner
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename192.jpg
 logo_filename192.jpg
 contact_image_filename192.png
 all_properties_link_image_filename192.jpg
 all_properties_linkhttp://ussw.net/wolfnet-properties
 video_embed_code
 contact_video_embed_code
 meta_titleBullhead City Real Estate | US Southwest | Leverage Global Partners
 meta_descriptionUS Southwest is the exclusive representative for Leverage Global Partners in Bullhead City, AZ, USA.
 meta_keywordsUS Southwest LLC, Bullhead city real estate, arizona real estate, ann pettit, bullhead city, leverage global partners, Fort Mohave, Mohave Valley
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2015-02-13 10:18:22
 modified2016-04-08 16:34:20
 dre_num012345
 uri/brokerage-detail/192/us-southwest
 website_shortussw.net
 name_with_locationUS Southwest
 Image(array)
 id3028
 modelLocation
 model_id94
 tagImage
 nameBullhead city.jpg
 typeimage/jpeg
 size140053
 uri/assets/3028.jpg
 order0
 created2016-04-05 11:25:58
 modified2016-04-05 11:28:06
- highlighted_properties(array)
 0(array)
 Property(array)
 id3290
 brokerage_id192
 created_by_user_id0
 order0
 multi_unit(false)
 agent_1_id140
 agent_2_id0
 agent_3_id0
 nameRiver Front Beauty with RV Garage
 incomplete(false)
 archived(false)
 last_archived0000-00-00 00:00:00
 auto_archived_from_mlsidx(false)
 paid_featured(false)
 featured(true)
 homepage_featured(true)
 brokerage_page_featured(true)
 requested_homepage_featured_by_member(false)
 homepage_featured_by_member(false)
 dot_luxury_featured(false)
 luxury_feed_featured(false)
 force_luxury_feed_featured(false)
 luxury_autofeed_imported(false)
 luxury_feed_last_added_time0000-00-00 00:00:00
 luxury_feed_agent_user_id0
 luxury_feed_locked_to_subscription_id0
 luxury_feed_agent_purchase_date0000-00-00
 luxury_feed_agent_expiration_date0000-00-00
 digital_ad_summary_email_last_sent0000-00-00 00:00:00
 digital_ad_summary_price_changed(false)
 wsj_detail_url
 ft_detail_url
 nyt_detail_url
 juwai_detail_url
 pgl_detail_url
 mg_detail_url
 mg_c_detail_url
 mg_s_detail_url
 bp_detail_url
 mw_detail_url
 nikkei_detail_url
 wapo_detail_url
 robb_detail_url
 medium_featured(false)
 large_featured(false)
 detail_page(true)
 descriptionTile floors, granite counters through the home, stone vessel sinks in each bath. Master bedroom with sitting area offers sweeping views of the Colorado River, private balcony and spacious master bath complete with jet tub, walk in shower, tile floors with granite accents. Spacious kitchen is open to living area with great views of the river. Soft close cabinets, stone backsplash, granite counters, convection stove and microwave.
 address1801 Riverfront
 address_2
 cityBullhead City
 stateAZ
 postal_code86442
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price675000
 price_20
 price_usd675000
 price_usd_20
 statusFor Sale
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(false)
 bedrooms3
 bedrooms_20
 bathrooms3
 bathrooms_20
 no_beds_baths(false)
 square_feet2500
 square_meters
 acres0
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size0
 icon_1dock
 icon_2views
 icon_3sq-ft
 icon_4waterfront
 icon_5garage
 icon_6
 website
 meta_titleRiver Front Beauty with RV Garage | Bullhead City Real Estate | US Southwest
 meta_description1801 Riverfront is a property offered for sale in Bullhead City, AZ, USA, presented by US Southwest
 meta_keywords
 bathrooms_partial0
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built
 virtual_tourhttp://video214.com/play/ySu4vAXwisenp6r9yjX9lw/s/dark
 video_tour
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num
 wsj_property_type
 nyt_property_type
 nyt_popular_features
 propgolux_property_type
 juwai_property_type
 juwai_category
 propgolux_property_style
 wapo_property_type
 robb_property_type
 propgolux_location_id_override
 open_house_1_start0000-00-00 00:00:00
 open_house_1_end_time00:00:00
 latitude0.000000
 longitude0.000000
 invalid_required_fieldslatitude, longitude
 invalid_optional_fieldsagent_2_id, square_meters, acres, hectares, bathrooms_partial, year_built, video_tour, wsj_property_type, nyt_property_type, propgolux_property_type, propgolux_property_style
 went_live_today(false)
 converted(true)
 invalid(false)
 mlsidx_full_address
 mlsidx_date_listed0000-00-00
 mls_market
 primary_property_category_id0
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated(null)
 modified2016-04-18 05:33:03
 created2016-01-15 13:55:57
 uri/property-detail/3290/1801-riverfront-bullhead-city-az-86442-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3290/1801-riverfront-bullhead-city-az-86442-usa
 address_concat1801 Riverfront Bullhead City AZ 86442 USA
 google_maps_query_string1801+Riverfront++Bullhead+City+AZ+86442+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 675,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty3
 bathrooms_pretty3
 bathrooms_partial_pretty0
 bathrooms_3_4_pretty0
 feed_full_bathrooms3
 date_listed2016-01-15
 overridden_brokerage_nameUS Southwest
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id192
 account_executive_id236
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID2371675
 timezoneUS/Mountain
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameUS Southwest
 broker_of_record_name
 short_nameUS Southwest
 usernameUSSouthwestLLC
 passwordaca3f804a48f1447c4a6fd356b1f302279862050
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date(null)
 monthly_invoice_end_date(null)
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionUS Southwest is the exclusive representative for Leverage Global Partners in Bullhead City, Mohave Valley, Fort Mohave AZ, USA. US Southwest is a boutique real estate company comprised of like minded pro-fessionals whose mission is to provide the best professional service so their clients can make informed decisions to achieve their goals. The talent and depth within the company is unmatched in Mohave County. Several of the key players at US Southwest have managed a business or owned their own busi- ness. The combined talents provide a unique business platform in which diversity, collaboration, team work, and professionalism, foster a business perspective and environment that generates creativity and productivity, and ultimately, successful results for clients. US Southwest has the capability, expertise and area relationships to assist its clients in any type of real estate endeavor. Its founders, Ann L. Pettit and Ray W. Jackson III, have worked in every kind of real estate enterprise for over 30 years in Northwestern Arizona and are perceived as innovative leaders and pioneers of the industry. They have a relationship building philosophy and their motto is - Your Success is Our Success.
 communitiesBullhead City Fort Mohave Mohave Valley
 websitehttp://ussw.net/
 address3767 Highway 95
 address_2
 cityBullhead City
 stateAZ
 full_stateArizona
 countryUSA
 market
 market_2
 postal_code86442
 phone(928) 763-2288
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameAnn Pettit
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleOwner
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename192.jpg
 logo_filename192.jpg
 contact_image_filename192.png
 all_properties_link_image_filename192.jpg
 all_properties_linkhttp://ussw.net/wolfnet-properties
 video_embed_code
 contact_video_embed_code
 meta_titleBullhead City Real Estate | US Southwest | Leverage Global Partners
 meta_descriptionUS Southwest is the exclusive representative for Leverage Global Partners in Bullhead City, AZ, USA.
 meta_keywordsUS Southwest LLC, Bullhead city real estate, arizona real estate, ann pettit, bullhead city, leverage global partners, Fort Mohave, Mohave Valley
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2015-02-13 10:18:22
 modified2016-04-08 16:34:20
 dre_num012345
 uri/brokerage-detail/192/us-southwest
 website_shortussw.net
 name_with_locationUS Southwest
 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)
 id18604
 modelProperty
 model_id3290
 tagImage
 name31809.jpg
 typeimage/jpg
 size1211879
 uri/assets/18604.jpg
 order0
 created2016-04-07 17:11:02
 modified2016-04-07 17:11:02
 1(array)
 id18598
 modelProperty
 model_id3290
 tagImage
 name31803.jpg
 typeimage/jpg
 size932146
 uri/assets/18598.jpg
 order1
 created2016-04-07 17:11:02
 modified2016-04-07 17:11:02
 2(array)
 id18599
 modelProperty
 model_id3290
 tagImage
 name31804.jpg
 typeimage/jpg
 size928662
 uri/assets/18599.jpg
 order2
 created2016-04-07 17:11:02
 modified2016-04-07 17:11:02
 3(array)
 id18600
 modelProperty
 model_id3290
 tagImage
 name31805.jpg
 typeimage/jpg
 size832635
 uri/assets/18600.jpg
 order3
 created2016-04-07 17:11:02
 modified2016-04-07 17:11:02
 4(array)
 id18601
 modelProperty
 model_id3290
 tagImage
 name31806.jpg
 typeimage/jpg
 size829684
 uri/assets/18601.jpg
 order4
 created2016-04-07 17:11:02
 modified2016-04-07 17:11:02
 5(array)
 id18602
 modelProperty
 model_id3290
 tagImage
 name31807.jpg
 typeimage/jpg
 size913023
 uri/assets/18602.jpg
 order5
 created2016-04-07 17:11:02
 modified2016-04-07 17:11:02
 6(array)
 id18603
 modelProperty
 model_id3290
 tagImage
 name31808.jpg
 typeimage/jpg
 size807051
 uri/assets/18603.jpg
 order6
 created2016-04-07 17:11:02
 modified2016-04-07 17:11:02
 User(empty)
 SecondaryPropertyCategory(empty)
 PropertyFeature(array)
 0(array)
 id3
 nameDock
 additional(false)
 created2016-04-07 14:01:13
 modified2016-04-07 14:01:13
 PropertiesPropertyFeature(array)
 id3929
 property_id3290
 property_feature_id3
 1(array)
 id14
 nameViews
 additional(false)
 created2016-04-07 14:04:55
 modified2016-04-07 14:04:55
 PropertiesPropertyFeature(array)
 id3930
 property_id3290
 property_feature_id14
 2(array)
 id17
 nameWaterfront
 additional(false)
 created2016-04-07 14:06:00
 modified2016-04-07 14:06:00
 PropertiesPropertyFeature(array)
 id3931
 property_id3290
 property_feature_id17
 3(array)
 id4
 nameGarage
 additional(false)
 created2016-04-07 14:01:52
 modified2016-04-07 14:01:52
 PropertiesPropertyFeature(array)
 id3932
 property_id3290
 property_feature_id4
 Topic(empty)
 1(array)
 Property(array)
 id3640
 brokerage_id192
 created_by_user_id0
 order0
 multi_unit(false)
 agent_1_id140
 agent_2_id0
 agent_3_id0
 nameArizona Ranch Located on 3 Acres
 incomplete(false)
 archived(false)
 last_archived0000-00-00 00:00:00
 auto_archived_from_mlsidx(false)
 paid_featured(false)
 featured(true)
 homepage_featured(false)
 brokerage_page_featured(true)
 requested_homepage_featured_by_member(false)
 homepage_featured_by_member(false)
 dot_luxury_featured(false)
 luxury_feed_featured(false)
 force_luxury_feed_featured(false)
 luxury_autofeed_imported(false)
 luxury_feed_last_added_time0000-00-00 00:00:00
 luxury_feed_agent_user_id0
 luxury_feed_locked_to_subscription_id0
 luxury_feed_agent_purchase_date0000-00-00
 luxury_feed_agent_expiration_date0000-00-00
 digital_ad_summary_email_last_sent0000-00-00 00:00:00
 digital_ad_summary_price_changed(false)
 wsj_detail_url
 ft_detail_url
 nyt_detail_url
 juwai_detail_url
 pgl_detail_url
 mg_detail_url
 mg_c_detail_url
 mg_s_detail_url
 bp_detail_url
 mw_detail_url
 nikkei_detail_url
 wapo_detail_url
 robb_detail_url
 medium_featured(false)
 large_featured(false)
 detail_page(true)
 descriptionFully fenced and cross fenced, irrigated, landscaped with lighted arena. Gearheads and equestrians will both be overly pleased with the amenities and attention to detail. Openfloor plan makes entertaining a dream around spacious kitchen. Pantry, island, bar seating, granite located at back of house with views of pool and arena. Living room open to kitchen, stacked stone fireplace, surround sound throughout home, with views to swimming pool and arena. 2 master suites, formal and informal dining areas, trophy rm/pool room too. 3 brdrs 5 baths, tile floors plenty of natural light. Over 7500 sq ft of concrete driveways, 3000 sq ft of pool decking not to mention the covered patios. 4800 sqft detached shop with room for 12 cars, 10,000 lbs car lift, 3 5500 CFM coolers, alarmed, surround sound 200 AMP service dedicated to Shop and Barn, 4 garage doors and benches and storage. 1200 sq ft BarnMaster Barn, 900 sqft BarnMaster Mare Motel, fully fenced, lighted Arena, wash rack, tack area. Property completely sprinkler, alarmed, well water and water company. Additional 3 car attached garage. Includes parcels 225-20-032 and 225-20-033
 address2303 E Hulet
 address_2
 cityMohave Valley
 stateAZ
 postal_code86440
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price1275000
 price_20
 price_usd1275000
 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_feet3850
 square_meters
 acres3
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size3
 icon_1acreage
 icon_2sq-ft
 icon_3pool
 icon_4views
 icon_5
 icon_6
 websitehttp://search.ussw.net/listing/912962
 meta_titleArizona Ranch Located on 3 Acres | Mohave Valley Real Estate | US Southwest
 meta_description2303 E Hulet is a property offered for sale in Mohave Valley, AZ, USA, presented by US Southwest
 meta_keywords
 bathrooms_partial3
 bathrooms_partial_20
 bathrooms_3_40
 bathrooms_3_4_20
 year_built
 virtual_tour
 video_tour
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num
 wsj_property_type
 nyt_property_type
 nyt_popular_features
 propgolux_property_type
 juwai_property_type
 juwai_category
 propgolux_property_style
 wapo_property_type
 robb_property_type
 propgolux_location_id_override
 open_house_1_start0000-00-00 00:00:00
 open_house_1_end_time00:00:00
 latitude0.000000
 longitude0.000000
 invalid_required_fields
 invalid_optional_fieldsagent_2_id, square_meters, hectares, virtual_tour, video_tour
 went_live_today(false)
 converted(true)
 invalid(false)
 mlsidx_full_address
 mlsidx_date_listed0000-00-00
 mls_market
 primary_property_category_id0
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated(null)
 modified2016-04-18 05:33:02
 created2016-03-24 15:02:26
 uri/property-detail/3640/2303-e-hulet-mohave-valley-az-86440-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3640/2303-e-hulet-mohave-valley-az-86440-usa
 address_concat2303 E Hulet Mohave Valley AZ 86440 USA
 google_maps_query_string2303+E+Hulet++Mohave+Valley+AZ+86440+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 1,275,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty3
 bathrooms_pretty2
 bathrooms_partial_pretty3
 bathrooms_3_4_pretty0
 feed_full_bathrooms2
 date_listed2016-03-24
 overridden_brokerage_nameUS Southwest
 overridden_brokerage_logo_uri
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id192
 account_executive_id236
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID2371675
 timezoneUS/Mountain
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameUS Southwest
 broker_of_record_name
 short_nameUS Southwest
 usernameUSSouthwestLLC
 passwordaca3f804a48f1447c4a6fd356b1f302279862050
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date(null)
 monthly_invoice_end_date(null)
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionUS Southwest is the exclusive representative for Leverage Global Partners in Bullhead City, Mohave Valley, Fort Mohave AZ, USA. US Southwest is a boutique real estate company comprised of like minded pro-fessionals whose mission is to provide the best professional service so their clients can make informed decisions to achieve their goals. The talent and depth within the company is unmatched in Mohave County. Several of the key players at US Southwest have managed a business or owned their own busi- ness. The combined talents provide a unique business platform in which diversity, collaboration, team work, and professionalism, foster a business perspective and environment that generates creativity and productivity, and ultimately, successful results for clients. US Southwest has the capability, expertise and area relationships to assist its clients in any type of real estate endeavor. Its founders, Ann L. Pettit and Ray W. Jackson III, have worked in every kind of real estate enterprise for over 30 years in Northwestern Arizona and are perceived as innovative leaders and pioneers of the industry. They have a relationship building philosophy and their motto is - Your Success is Our Success.
 communitiesBullhead City Fort Mohave Mohave Valley
 websitehttp://ussw.net/
 address3767 Highway 95
 address_2
 cityBullhead City
 stateAZ
 full_stateArizona
 countryUSA
 market
 market_2
 postal_code86442
 phone(928) 763-2288
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameAnn Pettit
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleOwner
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename192.jpg
 logo_filename192.jpg
 contact_image_filename192.png
 all_properties_link_image_filename192.jpg
 all_properties_linkhttp://ussw.net/wolfnet-properties
 video_embed_code
 contact_video_embed_code
 meta_titleBullhead City Real Estate | US Southwest | Leverage Global Partners
 meta_descriptionUS Southwest is the exclusive representative for Leverage Global Partners in Bullhead City, AZ, USA.
 meta_keywordsUS Southwest LLC, Bullhead city real estate, arizona real estate, ann pettit, bullhead city, leverage global partners, Fort Mohave, Mohave Valley
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2015-02-13 10:18:22
 modified2016-04-08 16:34:20
 dre_num012345
 uri/brokerage-detail/192/us-southwest
 website_shortussw.net
 name_with_locationUS Southwest
 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)
 id17255
 modelProperty
 model_id3640
 tagImage
 name35381.jpg
 typeimage/jpg
 size1097084
 uri/assets/17255.jpg
 order0
 created2016-04-07 17:03:04
 modified2016-04-07 17:03:04
 1(array)
 id17252
 modelProperty
 model_id3640
 tagImage
 name35378.jpg
 typeimage/jpg
 size844882
 uri/assets/17252.jpg
 order1
 created2016-04-07 17:03:03
 modified2016-04-07 17:03:03
 2(array)
 id17253
 modelProperty
 model_id3640
 tagImage
 name35379.jpg
 typeimage/jpg
 size934313
 uri/assets/17253.jpg
 order2
 created2016-04-07 17:03:03
 modified2016-04-07 17:03:03
 3(array)
 id17254
 modelProperty
 model_id3640
 tagImage
 name35380.jpg
 typeimage/jpg
 size1045843
 uri/assets/17254.jpg
 order3
 created2016-04-07 17:03:03
 modified2016-04-07 17:03:04
 4(array)
 id17256
 modelProperty
 model_id3640
 tagImage
 name35382.jpg
 typeimage/jpg
 size1661789
 uri/assets/17256.jpg
 order4
 created2016-04-07 17:03:04
 modified2016-04-07 17:03:04
 5(array)
 id17257
 modelProperty
 model_id3640
 tagImage
 name35383.jpg
 typeimage/jpg
 size1800409
 uri/assets/17257.jpg
 order5
 created2016-04-07 17:03:04
 modified2016-04-07 17:03:04
 6(array)
 id17258
 modelProperty
 model_id3640
 tagImage
 name35384.jpg
 typeimage/jpg
 size1662724
 uri/assets/17258.jpg
 order6
 created2016-04-07 17:03:04
 modified2016-04-07 17:03:04
 7(array)
 id17259
 modelProperty
 model_id3640
 tagImage
 name35385.jpg
 typeimage/jpg
 size930363
 uri/assets/17259.jpg
 order7
 created2016-04-07 17:03:04
 modified2016-04-07 17:03:04
 User(empty)
 SecondaryPropertyCategory(empty)
 PropertyFeature(array)
 0(array)
 id12
 nameSwimming Pool
 additional(false)
 created2016-04-07 14:04:12
 modified2016-04-07 14:04:12
 PropertiesPropertyFeature(array)
 id3615
 property_id3640
 property_feature_id12
 1(array)
 id14
 nameViews
 additional(false)
 created2016-04-07 14:04:55
 modified2016-04-07 14:04:55
 PropertiesPropertyFeature(array)
 id3616
 property_id3640
 property_feature_id14
 Topic(empty)
- custom_ga_event_properties(array)
 brokerageUS Southwest, Bullhead City
- property(array)
 Property(array)
 id3466
 brokerage_id192
 created_by_user_id0
 order0
 multi_unit(false)
 agent_1_id140
 agent_2_id0
 agent_3_id0
 nameOver 100' of Pristine Colorado River
 incomplete(false)
 archived(false)
 last_archived0000-00-00 00:00:00
 auto_archived_from_mlsidx(false)
 paid_featured(false)
 featured(true)
 homepage_featured(true)
 brokerage_page_featured(true)
 requested_homepage_featured_by_member(false)
 homepage_featured_by_member(false)
 dot_luxury_featured(false)
 luxury_feed_featured(false)
 force_luxury_feed_featured(false)
 luxury_autofeed_imported(false)
 luxury_feed_last_added_time0000-00-00 00:00:00
 luxury_feed_agent_user_id0
 luxury_feed_locked_to_subscription_id0
 luxury_feed_agent_purchase_date0000-00-00
 luxury_feed_agent_expiration_date0000-00-00
 digital_ad_summary_email_last_sent0000-00-00 00:00:00
 digital_ad_summary_price_changed(false)
 wsj_detail_url
 ft_detail_url
 nyt_detail_url
 juwai_detail_url
 pgl_detail_url
 mg_detail_url
 mg_c_detail_url
 mg_s_detail_url
 bp_detail_url
 mw_detail_url
 nikkei_detail_url
 wapo_detail_url
 robb_detail_url
 medium_featured(false)
 large_featured(false)
 detail_page(true)
 descriptionMain house includes 6 BDR and 7 Baths. Master suite located on main floor with jet tub, walk in shower and sweeping views of the Colorado River. 2 additional bdr suites on main floor as well. Dramatic entry with dynamic views of the river from 2 story entry faced with wall of windows. Plenty of room for sit down dinner or quick snack at the breakfast bar. Dream kitchen with granite counters, Dacon appliances, Sub Zero Refrigerator, gas cook top and views to the river. Upstairs you'll find spacious family room with 1/2 bath and closet with access to sundeck and 2 bedroom suites. Guests feel special in the mini master complete with private deck and views of the river. Catwalk connects family room and bedrooms with gorgeous views of the river, sandy beach and front yard compound. Short walk to guest house with over 750 sq ft. Over 100 ft of riverfront with sandy beach, private boat launch and dock. Electric gate entry, fully fenced acreage makes living on the river a true private vacation destination. Outdoor kitchen and covered patios! Sand between the toes and a bit of shade under the palapa as living on the river doesn't get any better than this.
 address9853 S Dike Rd
 address_2
 cityMohave Valley
 stateAZ
 postal_code86440
 countryUSA
 use_lat_lng_for_google_map(false)
 currencyUSD
 price1795000
 price_20
 price_usd1795000
 price_usd_20
 statusFor Sale
 status_last_changed0000-00-00 00:00:00
 status_last_changed_price_only0000-00-00 00:00:00
 lease_period
 price_upon_request(false)
 bedrooms7
 bedrooms_20
 bathrooms3
 bathrooms_20
 no_beds_baths(false)
 square_feet5249
 square_meters
 acres0
 interior_unitsq_ft
 interior_size0
 lot_unitacres
 lot_size0
 icon_1dock
 icon_2waterfront
 icon_3on-the-sand
 icon_4sq-ft
 icon_5
 icon_6
 websitehttp://search.ussw.net/listing/912084
 meta_titleOver 100' of Pristine Colorado River | Mohave Valley Real Estate | US Southwest
 meta_description9853 S Dike Rd is a property offered for sale in Mohave Valley, AZ, USA, presented by US Southwest
 meta_keywords
 bathrooms_partial1
 bathrooms_partial_20
 bathrooms_3_44
 bathrooms_3_4_20
 year_built
 virtual_tour
 video_tour
 digital_brochure
 video_tour_embed_code
 digital_brochure_embed_code
 mls_num
 wsj_property_type
 nyt_property_type
 nyt_popular_features
 propgolux_property_type
 juwai_property_type
 juwai_category
 propgolux_property_style
 wapo_property_type
 robb_property_type
 propgolux_location_id_override
 open_house_1_start0000-00-00 00:00:00
 open_house_1_end_time00:00:00
 latitude0.000000
 longitude0.000000
 invalid_required_fieldslatitude, longitude
 invalid_optional_fieldsagent_2_id, square_meters, acres, hectares, year_built, virtual_tour, video_tour, wsj_property_type, nyt_property_type, propgolux_property_type, propgolux_property_style
 went_live_today(false)
 converted(true)
 invalid(false)
 mlsidx_full_address
 mlsidx_date_listed0000-00-00
 mls_market
 primary_property_category_id0
 realstaq_initial_image_sync(false)
 digital_ad_listing_urls_automated(null)
 modified2016-04-18 05:33:02
 created2016-02-22 08:28:08
 uri/property-detail/3466/9853-s-dike-rd-mohave-valley-az-86440-usa
 absolute_urihttps://staging2.leveragere.com/property-detail/3466/9853-s-dike-rd-mohave-valley-az-86440-usa
 address_concat9853 S Dike Rd Mohave Valley AZ 86440 USA
 google_maps_query_string9853+S+Dike+Rd++Mohave+Valley+AZ+86440+USA
 luxury_ad_enrolled_prettyNO
 price_prettyUSD 1,795,000
 interior_unit_prettySq. Ft.
 lot_unit_prettyAcres
 bedrooms_pretty7
 bathrooms_pretty3
 bathrooms_partial_pretty1
 bathrooms_3_4_pretty4
 feed_full_bathrooms7
 date_listed2016-02-22
 overridden_brokerage_nameUS Southwest
 overridden_brokerage_logo_uri/assets/2797.jpg
 lux_ad_auto_enrolled(false)
 PrimaryPropertyCategory(array)
 id(null)
 name(null)
 created(null)
 modified(null)
 Brokerage(array)
 id192
 account_executive_id236
 archived(false)
 typebrokerage
 hide_from_frontend(false)
 agent_brokerage_data_override(false)
 featured_development(false)
 membership_typePremium
 max_properties8
 max_homepage_featured_by_member_properties0
 featured_properties_sort_methodmanual
 lux_feed_modeStripeSubscription
 max_luxury_feed_properties0
 membership_luxury_feed_properties0
 can_participate_in_lux_feed_while_archived(false)
 full_training_video_access(false)
 country_id0
 WOEID2371675
 timezoneUS/Mountain
 luxury_feed_enrollment_modemanual
 luxury_feed_include_mlsidx_minimum_price0
 luxury_feed_include_leverage_minimum_price0
 digital_ad_contacts
 add_agents_to_grr_auto_recipients(true)
 mlsidx_id
 mlsidx_lux_autofeed(false)
 mlsidx_lux_autofeed_minimum_price0
 mlsidx_logo_url
 mlsidx_disclaimer
 nameUS Southwest
 broker_of_record_name
 short_nameUS Southwest
 usernameUSSouthwestLLC
 passwordaca3f804a48f1447c4a6fd356b1f302279862050
 password_reset_hash
 monthly_invoice_amount(null)
 monthly_invoice_start_date(null)
 monthly_invoice_end_date(null)
 contract_filename
 active(true)
 lead_in
 short_description
 descriptionUS Southwest is the exclusive representative for Leverage Global Partners in Bullhead City, Mohave Valley, Fort Mohave AZ, USA. US Southwest is a boutique real estate company comprised of like minded pro-fessionals whose mission is to provide the best professional service so their clients can make informed decisions to achieve their goals. The talent and depth within the company is unmatched in Mohave County. Several of the key players at US Southwest have managed a business or owned their own busi- ness. The combined talents provide a unique business platform in which diversity, collaboration, team work, and professionalism, foster a business perspective and environment that generates creativity and productivity, and ultimately, successful results for clients. US Southwest has the capability, expertise and area relationships to assist its clients in any type of real estate endeavor. Its founders, Ann L. Pettit and Ray W. Jackson III, have worked in every kind of real estate enterprise for over 30 years in Northwestern Arizona and are perceived as innovative leaders and pioneers of the industry. They have a relationship building philosophy and their motto is - Your Success is Our Success.
 communitiesBullhead City Fort Mohave Mohave Valley
 websitehttp://ussw.net/
 address3767 Highway 95
 address_2
 cityBullhead City
 stateAZ
 full_stateArizona
 countryUSA
 market
 market_2
 postal_code86442
 phone(928) 763-2288
 phone_2
 phone_3
 wide_contact_image(false)
 contact_nameAnn Pettit
 contact_profile_link
 contact_big_profile_link
 contact_big_profile_link_text
 contact_titleOwner
 contact_dre_num
 contact_quote
 contact_email[email protected]
 contact_facebook
 contact_twitter
 contact_instagram
 contact_pinterest
 contact_linkedin
 contact_youtube
 contact_phone
 contact_email_2
 contact_2_facebook
 contact_2_twitter
 contact_2_instagram
 contact_2_pinterest
 contact_2_linkedin
 contact_2_youtube
 contact_phone_2
 contact_website
 contact_name_2
 contact_profile_link_2
 contact_big_profile_link_2
 contact_big_profile_link_text_2
 contact_title_2
 contact_dre_num_2
 contact_email_3
 contact_name_3
 contact_title_3
 contact_dre_num_3
 contact_phone_3
 contact_3_facebook
 contact_3_twitter
 contact_3_instagram
 contact_3_pinterest
 contact_3_linkedin
 contact_3_youtube
 image_filename192.jpg
 logo_filename192.jpg
 contact_image_filename192.png
 all_properties_link_image_filename192.jpg
 all_properties_linkhttp://ussw.net/wolfnet-properties
 video_embed_code
 contact_video_embed_code
 meta_titleBullhead City Real Estate | US Southwest | Leverage Global Partners
 meta_descriptionUS Southwest is the exclusive representative for Leverage Global Partners in Bullhead City, AZ, USA.
 meta_keywordsUS Southwest LLC, Bullhead city real estate, arizona real estate, ann pettit, bullhead city, leverage global partners, Fort Mohave, Mohave Valley
 login_message_counter0
 stats_module_1_type
 stats_module_1_value
 stats_module_2_type
 stats_module_2_value
 stats_module_3_type
 stats_module_3_value
 last_activity_email_sent0000-00-00 00:00:00
 converted(true)
 created2015-02-13 10:18:22
 modified2016-04-08 16:34:20
 dre_num012345
 AccountExecutive(array)
 id236
 typeAccountExecutive
 brokerage_id0
 email[email protected]
 passworde5cc5a96287695cf8b7cace1463b1699895dcf92
 recover_hash
 first_nameLauren
 last_namePena
 title
 dre_num
 phone
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2020-12-23 09:21:16
 created2016-04-14 15:43:52
 notified(false)
 full_nameLauren Pena
 uri/agent-detail/236/lauren-pena
 profile_complete(true)
 Logo(array)
 id2797
 modelBrokerage
 model_id192
 tagLogo
 name192.jpg
 typeimage/jpg
 size122098
 uri/assets/2797.jpg
 order0
 created2016-03-30 11:44:06
 modified2016-03-30 11:44:06
 MainImage(array)
 id2796
 modelBrokerage
 model_id192
 tagMainImage
 name192.jpg
 typeimage/jpg
 size320905
 uri/assets/2796.jpg
 order0
 created2016-03-30 11:44:05
 modified2016-03-30 11:44:05
 ContactImage(array)
 id2798
 modelBrokerage
 model_id192
 tagContactImage
 name192.png
 typeimage/png
 size289854
 uri/assets/2798.png
 order0
 created2016-03-30 11:44:06
 modified2016-03-30 11:44:06
 ContactImage2(empty)
 ContactImage3(empty)
 BrokerOfRecordLogo(empty)
 MainArticle(empty)
 FeaturedImage(empty)
 Location(array)
 0(array)
 id94
 parent_id9
 brokerage_id192
 typeExclusive
 archived(false)
 use_as_topic(false)
 nameBullhead City, AZ, USA
 short_nameBullhead City, AZ, USA
 group_index
 latitude35.135941
 longitude-114.528595
 country_code
 north53.700001
 south19.700001
 east-52.599998
 west-146.600006
 zoom0
 short_description
 long_descriptionMore information coming soon!
 created2016-04-05 11:28:06
 modified2016-04-05 11:28:06
 timezoneAmerica/Phoenix
 population40000
 uri/locations/view/94/bullhead-city-az-usa
 tile_nameBullhead City, AZ, USA
 User(array)
 0(array)
 id177
 typeBrokerageAdmin
 brokerage_id192
 email[email protected]
 passwordaca3f804a48f1447c4a6fd356b1f302279862050
 recover_hash
 first_nameAnn
 last_namePettit
 title
 dre_num
 phone
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2016-04-12 08:30:17
 created2016-04-08 16:34:20
 notified(true)
 full_nameAnn Pettit
 uri/agent-detail/177/ann-pettit
 profile_complete(true)
 1(array)
 id332
 typeAgent
 brokerage_id192
 email[email protected]
 password379216c1d1f823296a376037feefa9c12b2e3648
 recover_hash
 first_nameAnn
 last_namePettit
 title
 dre_num
 phone(928)234-5555
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:22:47
 created2017-08-07 15:22:47
 notified(false)
 full_nameAnn Pettit
 uri/agent-detail/332/ann-pettit
 profile_complete(true)
 2(array)
 id340
 typeAgent
 brokerage_id192
 email[email protected]
 passwordc09c37097bf31f9b17cabd29206768e73f9b9284
 recover_hash
 first_nameLaura
 last_nameWest
 title
 dre_num
 phone928-234-3950
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:22:47
 created2017-08-07 15:22:47
 notified(false)
 full_nameLaura West
 uri/agent-detail/340/laura-west
 profile_complete(true)
 3(array)
 id363
 typeAgent
 brokerage_id192
 email[email protected]
 password6a2350f9aa44e30a1bcbf6050e96ab9c1a829d73
 recover_hash
 first_nameJohn
 last_nameStaynar
 title
 dre_num
 phone(928)716-1111
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:22:48
 created2017-08-07 15:22:48
 notified(false)
 full_nameJohn Staynar
 uri/agent-detail/363/john-staynar
 profile_complete(true)
 4(array)
 id420
 typeAgent
 brokerage_id192
 email[email protected]
 password44adde5ead9baf35492be2a423e832d87f00ef0e
 recover_hash
 first_nameTiffany
 last_nameRussell
 title
 dre_num
 phone(928)542-3250
 max_luxury_feed_properties0
 headshot_filename
 bio
 brokerage_name_override
 stripe_customer_id
 digital_ad_first_free_month_couponineligible
 modified2017-08-07 15:22:56
 created2017-08-07 15:22:56
 notified(false)
 full_nameTiffany Russell
 uri/agent-detail/420/tiffany-russell
 profile_complete(true)
 uri/brokerage-detail/192/us-southwest
 website_shortussw.net
 name_with_locationUS Southwest - Bullhead City, AZ, USA
 StripeSubscription(array)
 id(null)
 brokerage_id(null)
 user_id(null)
 property_id(null)
 type(null)
 stripe_id(null)
 stripe_customer_id(null)
 stripe_checkout_email(null)
 stripe_promotion_code(null)
 stripe_promotion_code_id(null)
 stripe_coupon_code_id(null)
 status(null)
 current_period_end(null)
 cancel_at_period_end(null)
 ended(null)
 last_change(null)
 last_activity_email_sent(null)
 created(null)
 modified(null)
 GlobalReachReport(array)
 id(null)
 property_id(null)
 wsj_desktop(null)
 wsj_mobile(null)
 wsj_expires(null)
 wsj_capture_started(null)
 mg_desktop(null)
 mg_mobile(null)
 mg_expires(null)
 mg_capture_started(null)
 bp_desktop(null)
 bp_mobile(null)
 bp_expires(null)
 gp_capture_started(null)
 mw_desktop(null)
 mw_mobile(null)
 mw_expires(null)
 mw_capture_started(null)
 ft_desktop(null)
 ft_mobile(null)
 ft_expires(null)
 ft_capture_started(null)
 nikkei_desktop(null)
 nikkei_mobile(null)
 nikkei_expires(null)
 nikkei_capture_started(null)
 pgl_desktop(null)
 pgl_mobile(null)
 pgl_expires(null)
 pgl_capture_started(null)
 robb_desktop(null)
 robb_mobile(null)
 robb_expires(null)
 robb_capture_started(null)
 juwai_desktop(null)
 juwai_mobile(null)
 juwai_expires(null)
 juwai_capture_started(null)
 leverage_desktop(null)
 leverage_mobile(null)
 leverage_expires(null)
 leverage_capture_started(null)
 created(null)
 modified(null)
 wsj_available(false)
 wsj_expired(true)
 wsj_desktop_proxy_screenshot(null)
 wsj_mobile_proxy_screenshot(null)
 mg_available(false)
 mg_expired(true)
 mg_desktop_proxy_screenshot(null)
 mg_mobile_proxy_screenshot(null)
 bp_available(false)
 bp_expired(true)
 bp_desktop_proxy_screenshot(null)
 bp_mobile_proxy_screenshot(null)
 mw_available(false)
 mw_expired(true)
 mw_desktop_proxy_screenshot(null)
 mw_mobile_proxy_screenshot(null)
 nikkei_available(false)
 nikkei_expired(true)
 nikkei_desktop_proxy_screenshot(null)
 nikkei_mobile_proxy_screenshot(null)
 pgl_available(false)
 pgl_expired(true)
 pgl_desktop_proxy_screenshot(null)
 pgl_mobile_proxy_screenshot(null)
 robb_available(false)
 robb_expired(true)
 robb_desktop_proxy_screenshot(null)
 robb_mobile_proxy_screenshot(null)
 juwai_available(false)
 juwai_expired(true)
 juwai_desktop_proxy_screenshot(null)
 juwai_mobile_proxy_screenshot(null)
 capture_processing(false)
 capture_error(empty)
 Image(array)
 0(array)
 id13736
 modelProperty
 model_id3466
 tagImage
 name33632.jpg
 typeimage/jpg
 size568441
 uri/assets/13736.jpg
 order0
 created2016-04-07 16:41:03
 modified2016-04-07 16:41:03
 1(array)
 id13735
 modelProperty
 model_id3466
 tagImage
 name33633.jpg
 typeimage/jpg
 size269329
 uri/assets/13735.jpg
 order1
 created2016-04-07 16:41:03
 modified2016-04-07 16:41:03
 2(array)
 id13738
 modelProperty
 model_id3466
 tagImage
 name33638.jpg
 typeimage/jpg
 size243255
 uri/assets/13738.jpg
 order2
 created2016-04-07 16:41:03
 modified2016-04-07 16:41:03
 3(array)
 id13733
 modelProperty
 model_id3466
 tagImage
 name33635.jpg
 typeimage/jpg
 size211659
 uri/assets/13733.jpg
 order3
 created2016-04-07 16:41:03
 modified2016-04-07 16:41:03
 4(array)
 id13739
 modelProperty
 model_id3466
 tagImage
 name33637.jpg
 typeimage/jpg
 size400020
 uri/assets/13739.jpg
 order4
 created2016-04-07 16:41:03
 modified2016-04-07 16:41:03
 5(array)
 id13734
 modelProperty
 model_id3466
 tagImage
 name33634.jpg
 typeimage/jpg
 size336790
 uri/assets/13734.jpg
 order5
 created2016-04-07 16:41:03
 modified2016-04-07 16:41:03
 6(array)
 id13732
 modelProperty
 model_id3466
 tagImage
 name33636.jpg
 typeimage/jpg
 size367116
 uri/assets/13732.jpg
 order6
 created2016-04-07 16:41:03
 modified2016-04-07 16:41:03
 7(array)
 id13737
 modelProperty
 model_id3466
 tagImage
 name33639.jpg
 typeimage/jpg
 size328135
 uri/assets/13737.jpg
 order7
 created2016-04-07 16:41:03
 modified2016-04-07 16:41:03
 User(empty)
 SecondaryPropertyCategory(empty)
 PropertyFeature(array)
 0(array)
 id3
 nameDock
 additional(false)
 created2016-04-07 14:01:13
 modified2016-04-07 14:01:13
 PropertiesPropertyFeature(array)
 id2695
 property_id3466
 property_feature_id3
 Icon(array)
 id3552
 modelPropertyFeature
 model_id3
 tagIcon
 name131.png
 typeimage/png
 size1818
 uri/assets/3552.png
 order0
 created2016-04-07 14:01:09
 modified2016-04-07 14:01:13
 1(array)
 id17
 nameWaterfront
 additional(false)
 created2016-04-07 14:06:00
 modified2016-04-07 14:06:00
 PropertiesPropertyFeature(array)
 id2696
 property_id3466
 property_feature_id17
 Icon(array)
 id3566
 modelPropertyFeature
 model_id17
 tagIcon
 name145.png
 typeimage/png
 size2066
 uri/assets/3566.png
 order0
 created2016-04-07 14:05:58
 modified2016-04-07 14:06:00
 2(array)
 id10
 nameOn The Sand
 additional(false)
 created2016-04-07 14:03:36
 modified2016-04-07 14:03:36
 PropertiesPropertyFeature(array)
 id2697
 property_id3466
 property_feature_id10
 Icon(array)
 id3559
 modelPropertyFeature
 model_id10
 tagIcon
 name138.png
 typeimage/png
 size2159
 uri/assets/3559.png
 order0
 created2016-04-07 14:03:34
 modified2016-04-07 14:03:36
 Topic(empty)
- membership_subscription_temp_allowed_login(null)
- newsletter_member_types(array)
 Leverage Member: AgentLeverage Member: Agent
 Leverage Member: Broker or ManagementLeverage Member: Broker or Management
 Non-MemberNon-Member
- $request->data(empty)
- $this->validationErrors(array)
 Subscription(empty)
 Property(empty)
 User(empty)
 PropertyFeature(empty)
 SecondaryPropertyCategory(empty)
 Topic(empty)
 PrimaryPropertyCategory(empty)
 Brokerage(empty)
 StripeSubscription(empty)
 GlobalReachReport(empty)
 AccountExecutive(empty)
 Logo(empty)
 MainImage(empty)
 ContactImage(empty)
 ContactImage2(empty)
 ContactImage3(empty)
 BrokerOfRecordLogo(empty)
 MainArticle(empty)
 Location(empty)
 FeaturedImage(empty)
 Image(empty)
 UsersProperty(empty)
 PropertiesSecondaryPropertyCategory(empty)
 PropertiesPropertyFeature(empty)
 Icon(empty)
 PropertiesTopic(empty)
- Loaded Helpers(array)
 0Permission
 1Number
 2SimpleGraph
 3DebugTimer
 4Toolbar
 5Session
 6Text
 7Flash
 8HtmlToolbar
 9Html
 10Form
====

Environment

App Constants

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

CakePHP Constants

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

PHP Environment

Environment Variable	Value
Php Version	7.4.33
User	leveragere
Home	/var/www/vhosts/leveragere.com
Script Name	/index.php
Request Uri	/property-detail/3466/9853-s-dike-rd-mohave-valley-az-86440-usa
Query String
Request Method	GET
Server Protocol	HTTP/1.1
Gateway Interface	CGI/1.1
Redirect Url	/property-detail/3466/9853-s-dike-rd-mohave-valley-az-86440-usa
Remote Port	21090
Script Filename	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot/index.php
Server Admin	root@localhost
Context Document Root	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot
Context Prefix
Request Scheme	https
Document Root	/var/www/vhosts/leveragere.com/subdomains/staging2/httpdocs/app/webroot
Remote Addr	104.23.197.115
Server Port	443
Server Addr	172.24.32.44
Server Name	staging2.leveragere.com
Server Software	Apache
Server Signature
Path	/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin
Http Host	staging2.leveragere.com
Http Connection	Keep-Alive
Http X Forwarded Proto	https
Http Cf Visitor	{"scheme":"https"}
Http Cf Ipcountry	US
Http Cf Connecting Ip	216.73.216.172
Http Cdn Loop	cloudflare; loops=1
Http User Agent	Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; [email protected])
Http Accept Encoding	gzip, br
Http Accept	/
Http Cf Ray	a09e11368c585751-CMH
Http X Forwarded For	216.73.216.172
Proxy-nokeepalive	1
Ssl Tls Sni	staging2.leveragere.com
Https	on
Passenger Download Native Support Binary	0
Passenger Compile Native Support Binary	0
Perl5lib	/usr/share/awstats/lib:/usr/share/awstats/plugins
Unique Id	aipBiOA5qMDEbJhuePk4eAAAAZg
Redirect Status	200
Redirect Ssl Tls Sni	staging2.leveragere.com
Redirect Https	on
Redirect Passenger Download Native Support Binary	0
Redirect Passenger Compile Native Support Binary	0
Redirect Perl5lib	/usr/share/awstats/lib:/usr/share/awstats/plugins
Redirect Unique Id	aipBiOA5qMDEbJhuePk4eAAAAZg
Fcgi Role	RESPONDER
Php Self	/index.php
Request Time Float	1781154184.7419
Request Time	1781154184

====

Include
+
Included Files

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

Over 100' of Pristine Colorado River

Represented By: US Southwest

Highlighted Properties

Share This

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 13 ms Total Queries: 33 queries

Query Explain:

Memory

Timers

Logs

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

Total Time: 13 ms
Total Queries: 33 queries