River Front Beauty with RV Garage

Request History

• Restore to current request
• property-detail/3036/375-san-mateo-drive-menlo-park-ca-94025-usa
• property-detail/2131/3513-raymond-street-chevy-chase-md-20815-usa
• property-detail/3696/357-lelekepue-place-honolulu-hawaii-96821-usa
• locations/view/114/big-island-of-hawaii-hi-usa

Session

• 0(null)

Request

Cake Params

• plugin(null)
• controllerproperties
• actionview
• named(empty)
• pass(array)
  • 03290
  • 11801-riverfront-bullhead-city-az-86442-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 Logs

Logs

View Variables

• sidebar_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)
      • description<p>Tile 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.</p>
      • 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
      • description<p>US Southwest is the exclusive representative for Leverage Global Partners in Bullhead City, Mohave Valley, Fort Mohave AZ, USA.</p> <p>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.</p> <p>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.</p>
      • 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)
      • 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)
      • description<p>Exquisitely 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.</p>
      • 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
      • description<p>US Southwest is the exclusive representative for Leverage Global Partners in Bullhead City, Mohave Valley, Fort Mohave AZ, USA.</p> <p>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.</p> <p>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.</p>
      • 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
  • 2(array)
    • Property(array)
      • id3287
      • brokerage_id192
      • created_by_user_id0
      • order0
      • multi_unit(false)
      • agent_1_id112
      • agent_2_id0
      • agent_3_id0
      • nameRiverfront Paradise
      • 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)
      • description<p>Riverfront Paradise with over 226’ river frontage on the beautiful and tranquil Colorado River with an extraordinary and expansive sandy beach. Property boasts two launch ramps, back your water toys right into the river from your garage. Entertaining is easy and relaxing with a covered outdoor bbq. Exterior fireplace for evening ambiance and cabanas by the water for shade as you sip on a cool beverage and watch the tranquil water go by. Your own private boat dock to boot. The interior boasts an open concept with soaring ceilings and windows framing panoramic riverfront views in all directions. Gourmet kitchen with designer appliances. Fully appointed wet bar provides an additional seating area for entertaining. 4 large bedrooms all have en suite baths, a casita that overlooks an impressive courtyard entrance to the home adds to the unique design and offers additional entertainment potentials. A great vacation getaway or your own private waterfront oasis. RV parking for 3 RV's with full hook ups. Includes 2 -1 acre parcels APN# 0660-341-02 & 0660-341-01</p>
      • address1890 Ketle One Ct
      • address_2
      • cityNeedles
      • stateCA
      • postal_code92363
      • countryUSA
      • use_lat_lng_for_google_map(false)
      • currencyUSD
      • price1999000
      • price_20
      • price_usd1999000
      • 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_feet3700
      • square_meters
      • acres0
      • interior_unitsq_ft
      • interior_size0
      • lot_unitacres
      • lot_size0
      • icon_1on-the-sand
      • icon_2waterfront
      • icon_3sq-ft
      • icon_4dock
      • icon_5
      • icon_6
      • websitehttps://www.wardexre.com/war/maildoc/genibrel_1452878276-Jan-15-2016-12_17_56pm.html
      • meta_titleRiverfront Paradise | Needles Real Estate | US Southwest
      • meta_description1890 Ketle One Ct is a property offered for sale in Needles, CA, USA, presented by US Southwest
      • meta_keywords
      • bathrooms_partial1
      • bathrooms_partial_20
      • bathrooms_3_40
      • bathrooms_3_4_20
      • year_built
      • virtual_tourhttp://video214.com/play/9wQ0xHX7lCSZMoA7I7Z99w/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, 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 09:57:13
      • uri/property-detail/3287/1890-ketle-one-ct-needles-ca-92363-usa
      • absolute_urihttps://staging2.leveragere.com/property-detail/3287/1890-ketle-one-ct-needles-ca-92363-usa
      • address_concat1890 Ketle One Ct Needles CA 92363 USA
      • google_maps_query_string1890+Ketle+One+Ct++Needles+CA+92363+USA
      • luxury_ad_enrolled_prettyNO
      • price_prettyUSD 1,999,000
      • interior_unit_prettySq. Ft.
      • lot_unit_prettyAcres
      • bedrooms_pretty4
      • bathrooms_pretty4
      • bathrooms_partial_pretty1
      • 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
      • description<p>US Southwest is the exclusive representative for Leverage Global Partners in Bullhead City, Mohave Valley, Fort Mohave AZ, USA.</p> <p>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.</p> <p>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.</p>
      • 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)
        • id18748
        • modelProperty
        • model_id3287
        • tagImage
        • name31795.jpg
        • typeimage/jpg
        • size1719905
        • uri/assets/18748.jpg
        • order0
        • created2016-04-07 17:11:06
        • modified2016-04-07 17:11:06
      • 1(array)
        • id18742
        • modelProperty
        • model_id3287
        • tagImage
        • name31785.jpg
        • typeimage/jpg
        • size1512124
        • uri/assets/18742.jpg
        • order1
        • created2016-04-07 17:11:05
        • modified2016-04-07 17:11:05
      • 2(array)
        • id18743
        • modelProperty
        • model_id3287
        • tagImage
        • name31786.jpg
        • typeimage/jpg
        • size351870
        • uri/assets/18743.jpg
        • order2
        • created2016-04-07 17:11:05
        • modified2016-04-07 17:11:05
      • 3(array)
        • id18744
        • modelProperty
        • model_id3287
        • tagImage
        • name31787.jpg
        • typeimage/jpg
        • size409480
        • uri/assets/18744.jpg
        • order3
        • created2016-04-07 17:11:05
        • modified2016-04-07 17:11:05
      • 4(array)
        • id18745
        • modelProperty
        • model_id3287
        • tagImage
        • name31788.jpg
        • typeimage/jpg
        • size270807
        • uri/assets/18745.jpg
        • order4
        • created2016-04-07 17:11:05
        • modified2016-04-07 17:11:05
      • 5(array)
        • id18746
        • modelProperty
        • model_id3287
        • tagImage
        • name31789.jpg
        • typeimage/jpg
        • size349648
        • uri/assets/18746.jpg
        • order5
        • created2016-04-07 17:11:05
        • modified2016-04-07 17:11:05
      • 6(array)
        • id18747
        • modelProperty
        • model_id3287
        • tagImage
        • name31790.jpg
        • typeimage/jpg
        • size360234
        • uri/assets/18747.jpg
        • order6
        • created2016-04-07 17:11:06
        • modified2016-04-07 17:11:06
    • User(array)
      • 0(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)
        • UsersProperty(array)
          • id127
          • user_id340
          • property_id3287
          • sort_order0
    • SecondaryPropertyCategory(empty)
    • PropertyFeature(array)
      • 0(array)
        • id10
        • nameOn The Sand
        • additional(false)
        • created2016-04-07 14:03:36
        • modified2016-04-07 14:03:36
        • PropertiesPropertyFeature(array)
          • id3971
          • property_id3287
          • property_feature_id10
      • 1(array)
        • id17
        • nameWaterfront
        • additional(false)
        • created2016-04-07 14:06:00
        • modified2016-04-07 14:06:00
        • PropertiesPropertyFeature(array)
          • id3972
          • property_id3287
          • property_feature_id17
      • 2(array)
        • id3
        • nameDock
        • additional(false)
        • created2016-04-07 14:01:13
        • modified2016-04-07 14:01:13
        • PropertiesPropertyFeature(array)
          • id3973
          • property_id3287
          • property_feature_id3
    • Topic(empty)
  • 3(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)
      • description<p>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.</p>
      • 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
      • 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
      • description<p>US Southwest is the exclusive representative for Leverage Global Partners in Bullhead City, Mohave Valley, Fort Mohave AZ, USA.</p> <p>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.</p> <p>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.</p>
      • 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)
        • 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
      • 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
      • 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
    • Topic(empty)
• 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
      • description<p>US Southwest is the exclusive representative for Leverage Global Partners in Bullhead City, Mohave Valley, Fort Mohave AZ, USA.</p> <p>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.</p> <p>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.</p>
      • 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)
      • id3287
      • brokerage_id192
      • created_by_user_id0
      • order0
      • multi_unit(false)
      • agent_1_id112
      • agent_2_id0
      • agent_3_id0
      • nameRiverfront Paradise
      • 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)
      • description<p>Riverfront Paradise with over 226’ river frontage on the beautiful and tranquil Colorado River with an extraordinary and expansive sandy beach. Property boasts two launch ramps, back your water toys right into the river from your garage. Entertaining is easy and relaxing with a covered outdoor bbq. Exterior fireplace for evening ambiance and cabanas by the water for shade as you sip on a cool beverage and watch the tranquil water go by. Your own private boat dock to boot. The interior boasts an open concept with soaring ceilings and windows framing panoramic riverfront views in all directions. Gourmet kitchen with designer appliances. Fully appointed wet bar provides an additional seating area for entertaining. 4 large bedrooms all have en suite baths, a casita that overlooks an impressive courtyard entrance to the home adds to the unique design and offers additional entertainment potentials. A great vacation getaway or your own private waterfront oasis. RV parking for 3 RV's with full hook ups. Includes 2 -1 acre parcels APN# 0660-341-02 & 0660-341-01</p>
      • address1890 Ketle One Ct
      • address_2
      • cityNeedles
      • stateCA
      • postal_code92363
      • countryUSA
      • use_lat_lng_for_google_map(false)
      • currencyUSD
      • price1999000
      • price_20
      • price_usd1999000
      • 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_feet3700
      • square_meters
      • acres0
      • interior_unitsq_ft
      • interior_size0
      • lot_unitacres
      • lot_size0
      • icon_1on-the-sand
      • icon_2waterfront
      • icon_3sq-ft
      • icon_4dock
      • icon_5
      • icon_6
      • websitehttps://www.wardexre.com/war/maildoc/genibrel_1452878276-Jan-15-2016-12_17_56pm.html
      • meta_titleRiverfront Paradise | Needles Real Estate | US Southwest
      • meta_description1890 Ketle One Ct is a property offered for sale in Needles, CA, USA, presented by US Southwest
      • meta_keywords
      • bathrooms_partial1
      • bathrooms_partial_20
      • bathrooms_3_40
      • bathrooms_3_4_20
      • year_built
      • virtual_tourhttp://video214.com/play/9wQ0xHX7lCSZMoA7I7Z99w/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, 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 09:57:13
      • uri/property-detail/3287/1890-ketle-one-ct-needles-ca-92363-usa
      • absolute_urihttps://staging2.leveragere.com/property-detail/3287/1890-ketle-one-ct-needles-ca-92363-usa
      • address_concat1890 Ketle One Ct Needles CA 92363 USA
      • google_maps_query_string1890+Ketle+One+Ct++Needles+CA+92363+USA
      • luxury_ad_enrolled_prettyNO
      • price_prettyUSD 1,999,000
      • interior_unit_prettySq. Ft.
      • lot_unit_prettyAcres
      • bedrooms_pretty4
      • bathrooms_pretty4
      • bathrooms_partial_pretty1
      • 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
      • description<p>US Southwest is the exclusive representative for Leverage Global Partners in Bullhead City, Mohave Valley, Fort Mohave AZ, USA.</p> <p>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.</p> <p>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.</p>
      • 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)
        • id18748
        • modelProperty
        • model_id3287
        • tagImage
        • name31795.jpg
        • typeimage/jpg
        • size1719905
        • uri/assets/18748.jpg
        • order0
        • created2016-04-07 17:11:06
        • modified2016-04-07 17:11:06
      • 1(array)
        • id18742
        • modelProperty
        • model_id3287
        • tagImage
        • name31785.jpg
        • typeimage/jpg
        • size1512124
        • uri/assets/18742.jpg
        • order1
        • created2016-04-07 17:11:05
        • modified2016-04-07 17:11:05
      • 2(array)
        • id18743
        • modelProperty
        • model_id3287
        • tagImage
        • name31786.jpg
        • typeimage/jpg
        • size351870
        • uri/assets/18743.jpg
        • order2
        • created2016-04-07 17:11:05
        • modified2016-04-07 17:11:05
      • 3(array)
        • id18744
        • modelProperty
        • model_id3287
        • tagImage
        • name31787.jpg
        • typeimage/jpg
        • size409480
        • uri/assets/18744.jpg
        • order3
        • created2016-04-07 17:11:05
        • modified2016-04-07 17:11:05
      • 4(array)
        • id18745
        • modelProperty
        • model_id3287
        • tagImage
        • name31788.jpg
        • typeimage/jpg
        • size270807
        • uri/assets/18745.jpg
        • order4
        • created2016-04-07 17:11:05
        • modified2016-04-07 17:11:05
      • 5(array)
        • id18746
        • modelProperty
        • model_id3287
        • tagImage
        • name31789.jpg
        • typeimage/jpg
        • size349648
        • uri/assets/18746.jpg
        • order5
        • created2016-04-07 17:11:05
        • modified2016-04-07 17:11:05
      • 6(array)
        • id18747
        • modelProperty
        • model_id3287
        • tagImage
        • name31790.jpg
        • typeimage/jpg
        • size360234
        • uri/assets/18747.jpg
        • order6
        • created2016-04-07 17:11:06
        • modified2016-04-07 17:11:06
    • User(array)
      • 0(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)
        • UsersProperty(array)
          • id127
          • user_id340
          • property_id3287
          • sort_order0
    • SecondaryPropertyCategory(empty)
    • PropertyFeature(array)
      • 0(array)
        • id10
        • nameOn The Sand
        • additional(false)
        • created2016-04-07 14:03:36
        • modified2016-04-07 14:03:36
        • PropertiesPropertyFeature(array)
          • id3971
          • property_id3287
          • property_feature_id10
      • 1(array)
        • id17
        • nameWaterfront
        • additional(false)
        • created2016-04-07 14:06:00
        • modified2016-04-07 14:06:00
        • PropertiesPropertyFeature(array)
          • id3972
          • property_id3287
          • property_feature_id17
      • 2(array)
        • id3
        • nameDock
        • additional(false)
        • created2016-04-07 14:01:13
        • modified2016-04-07 14:01:13
        • PropertiesPropertyFeature(array)
          • id3973
          • property_id3287
          • property_feature_id3
    • Topic(empty)
  • 1(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)
      • description<p>Enjoy 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.</p>
      • 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
      • description<p>US Southwest is the exclusive representative for Leverage Global Partners in Bullhead City, Mohave Valley, Fort Mohave AZ, USA.</p> <p>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.</p> <p>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.</p>
      • 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)
• custom_ga_event_properties(array)
  • brokerageUS Southwest, Bullhead City
• property(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)
    • description<p>Tile 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.</p>
    • 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/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
    • description<p>US Southwest is the exclusive representative for Leverage Global Partners in Bullhead City, Mohave Valley, Fort Mohave AZ, USA.</p> <p>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.</p> <p>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.</p>
    • 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)
      • 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
      • 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)
      • id14
      • nameViews
      • additional(false)
      • created2016-04-07 14:04:55
      • modified2016-04-07 14:04:55
      • PropertiesPropertyFeature(array)
        • id3930
        • property_id3290
        • property_feature_id14
      • Icon(array)
        • id3563
        • modelPropertyFeature
        • model_id14
        • tagIcon
        • name142.png
        • typeimage/png
        • size2192
        • uri/assets/3563.png
        • order0
        • created2016-04-07 14:04:53
        • modified2016-04-07 14:04:55
    • 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
      • 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
    • 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
      • Icon(array)
        • id3553
        • modelPropertyFeature
        • model_id4
        • tagIcon
        • name132.png
        • typeimage/png
        • size2141
        • uri/assets/3553.png
        • order0
        • created2016-04-07 14:01:51
        • modified2016-04-07 14:01:52
  • 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