Riverfront Paradise

Request History

• Restore to current request
• contacts/ajax_form?brokerage_id=220&property_id=2817
• contacts/ajax_form?brokerage_id=175&property_id=1758
• articles/view/356/meet-alei-merrill-gothberg-amherst-madison-partners-boise-id
• contacts/ajax_form?brokerage_id=192&property_id=3724

Session

• 0(null)

Request

Cake Params

• plugin(null)
• controllerproperties
• actionview
• named(empty)
• pass(array)
  • 03287
  • 11890-ketle-one-ct-needles-ca-92363-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)
      • id3726
      • brokerage_id192
      • created_by_user_id0
      • order0
      • multi_unit(false)
      • agent_1_id0
      • agent_2_id0
      • agent_3_id0
      • nameOver 100 ft of Riverfront with Sandy Beach
      • incomplete(false)
      • archived(false)
      • last_archived0000-00-00 00:00:00
      • auto_archived_from_mlsidx(false)
      • paid_featured(false)
      • featured(false)
      • homepage_featured(false)
      • brokerage_page_featured(true)
      • requested_homepage_featured_by_member(false)
      • homepage_featured_by_member(false)
      • dot_luxury_featured(false)
      • luxury_feed_featured(false)
      • force_luxury_feed_featured(false)
      • luxury_autofeed_imported(false)
      • luxury_feed_last_added_time0000-00-00 00:00:00
      • luxury_feed_agent_user_id0
      • luxury_feed_locked_to_subscription_id0
      • luxury_feed_agent_purchase_date0000-00-00
      • luxury_feed_agent_expiration_date0000-00-00
      • digital_ad_summary_email_last_sent0000-00-00 00:00:00
      • digital_ad_summary_price_changed(false)
      • wsj_detail_url
      • ft_detail_url
      • nyt_detail_url
      • juwai_detail_url
      • pgl_detail_url
      • mg_detail_url
      • mg_c_detail_url
      • mg_s_detail_url
      • bp_detail_url
      • mw_detail_url
      • nikkei_detail_url
      • wapo_detail_url
      • robb_detail_url
      • medium_featured(false)
      • large_featured(false)
      • detail_page(false)
      • 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
      • price1750000
      • price_20
      • price_usd1750000
      • price_usd_20
      • statusFor Sale
      • status_last_changed0000-00-00 00:00:00
      • status_last_changed_price_only0000-00-00 00:00:00
      • lease_period
      • price_upon_request(false)
      • bedrooms7
      • bedrooms_20
      • bathrooms3
      • bathrooms_20
      • no_beds_baths(false)
      • square_feet5249
      • square_meters
      • acres52391
      • interior_unitsq_ft
      • interior_size0
      • lot_unitacres
      • lot_size52391
      • icon_1
      • icon_2
      • icon_3
      • icon_4
      • icon_5
      • icon_6
      • websitehttp://search.ussw.net/listing/912084
      • meta_title
      • meta_description
      • meta_keywords
      • bathrooms_partial4
      • bathrooms_partial_20
      • bathrooms_3_41
      • bathrooms_3_4_20
      • year_built1998
      • virtual_tour
      • video_tour
      • digital_brochure
      • video_tour_embed_code
      • digital_brochure_embed_code
      • mls_num912084
      • wsj_property_type
      • nyt_property_type
      • nyt_popular_features
      • propgolux_property_type
      • juwai_property_type
      • juwai_category
      • propgolux_property_style
      • wapo_property_type
      • robb_property_type
      • propgolux_location_id_override
      • open_house_1_start0000-00-00 00:00:00
      • open_house_1_end_time00:00:00
      • latitude37.090240
      • longitude-95.712891
      • invalid_required_fields
      • invalid_optional_fields
      • went_live_today(false)
      • converted(true)
      • invalid(false)
      • mlsidx_full_address
      • mlsidx_date_listed0000-00-00
      • mls_market
      • primary_property_category_id0
      • realstaq_initial_image_sync(false)
      • digital_ad_listing_urls_automated(null)
      • modified2016-04-18 05:33:03
      • created2016-04-13 10:23:58
      • uri/property-detail/3726/9853-s-dike-rd-mohave-valley-az-86440-usa
      • absolute_urihttps://staging2.leveragere.com/property-detail/3726/9853-s-dike-rd-mohave-valley-az-86440-usa
      • address_concat9853 S Dike Rd Mohave Valley AZ 86440 USA
      • google_maps_query_string9853+S+Dike+Rd++Mohave+Valley+AZ+86440+USA
      • luxury_ad_enrolled_prettyNO
      • price_prettyUSD 1,750,000
      • interior_unit_prettySq. Ft.
      • lot_unit_prettyAcres
      • bedrooms_pretty7
      • bathrooms_pretty3
      • bathrooms_partial_pretty4
      • bathrooms_3_4_pretty1
      • feed_full_bathrooms4
      • date_listed2016-04-13
      • overridden_brokerage_nameUS Southwest
      • overridden_brokerage_logo_uri
      • lux_ad_auto_enrolled(false)
    • PrimaryPropertyCategory(array)
      • id(null)
      • name(null)
      • created(null)
      • modified(null)
    • Brokerage(array)
      • id192
      • account_executive_id236
      • archived(false)
      • typebrokerage
      • hide_from_frontend(false)
      • agent_brokerage_data_override(false)
      • featured_development(false)
      • membership_typePremium
      • max_properties8
      • max_homepage_featured_by_member_properties0
      • featured_properties_sort_methodmanual
      • lux_feed_modeStripeSubscription
      • max_luxury_feed_properties0
      • membership_luxury_feed_properties0
      • can_participate_in_lux_feed_while_archived(false)
      • full_training_video_access(false)
      • country_id0
      • WOEID2371675
      • timezoneUS/Mountain
      • luxury_feed_enrollment_modemanual
      • luxury_feed_include_mlsidx_minimum_price0
      • luxury_feed_include_leverage_minimum_price0
      • digital_ad_contacts
      • add_agents_to_grr_auto_recipients(true)
      • mlsidx_id
      • mlsidx_lux_autofeed(false)
      • mlsidx_lux_autofeed_minimum_price0
      • mlsidx_logo_url
      • mlsidx_disclaimer
      • nameUS Southwest
      • broker_of_record_name
      • short_nameUS Southwest
      • usernameUSSouthwestLLC
      • passwordaca3f804a48f1447c4a6fd356b1f302279862050
      • password_reset_hash
      • monthly_invoice_amount(null)
      • monthly_invoice_start_date(null)
      • monthly_invoice_end_date(null)
      • contract_filename
      • active(true)
      • lead_in
      • short_description
      • 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)
        • id20809
        • modelProperty
        • model_id3726
        • tagImage
        • name9853_Dike (1).jpg
        • typeimage/jpeg
        • size1946014
        • uri/assets/20809.jpg
        • order0
        • created2016-04-13 10:23:45
        • modified2016-04-13 10:23:59
      • 1(array)
        • id20805
        • modelProperty
        • model_id3726
        • tagImage
        • name9853DikeRd_60.jpg
        • typeimage/jpeg
        • size464564
        • uri/assets/20805.jpg
        • order1
        • created2016-04-13 10:23:43
        • modified2016-04-13 10:23:59
      • 2(array)
        • id20806
        • modelProperty
        • model_id3726
        • tagImage
        • name9853DikeRd_19.jpg
        • typeimage/jpeg
        • size270202
        • uri/assets/20806.jpg
        • order2
        • created2016-04-13 10:23:43
        • modified2016-04-13 10:23:59
      • 3(array)
        • id20807
        • modelProperty
        • model_id3726
        • tagImage
        • name9853DikeRd_70.jpg
        • typeimage/jpeg
        • size288097
        • uri/assets/20807.jpg
        • order3
        • created2016-04-13 10:23:44
        • modified2016-04-13 10:23:59
      • 4(array)
        • id20808
        • modelProperty
        • model_id3726
        • tagImage
        • name9853DikeRd_69.jpg
        • typeimage/jpeg
        • size444920
        • uri/assets/20808.jpg
        • order4
        • created2016-04-13 10:23:44
        • modified2016-04-13 10:23:59
      • 5(array)
        • id20810
        • modelProperty
        • model_id3726
        • tagImage
        • name9853DikeRd_76.jpg
        • typeimage/jpeg
        • size404572
        • uri/assets/20810.jpg
        • order5
        • created2016-04-13 10:23:53
        • modified2016-04-13 10:23:59
    • User(empty)
    • SecondaryPropertyCategory(empty)
    • PropertyFeature(array)
      • 0(array)
        • id1
        • nameBalcony/Terrace
        • additional(false)
        • created2016-04-07 14:00:26
        • modified2016-04-07 14:00:26
        • PropertiesPropertyFeature(array)
          • id4387
          • property_id3726
          • property_feature_id1
      • 1(array)
        • id2
        • nameBeach Access
        • additional(false)
        • created2016-04-07 14:00:52
        • modified2016-04-07 14:00:52
        • PropertiesPropertyFeature(array)
          • id4388
          • property_id3726
          • property_feature_id2
      • 2(array)
        • id4
        • nameGarage
        • additional(false)
        • created2016-04-07 14:01:52
        • modified2016-04-07 14:01:52
        • PropertiesPropertyFeature(array)
          • id4389
          • property_id3726
          • property_feature_id4
      • 3(array)
        • id10
        • nameOn The Sand
        • additional(false)
        • created2016-04-07 14:03:36
        • modified2016-04-07 14:03:36
        • PropertiesPropertyFeature(array)
          • id4390
          • property_id3726
          • property_feature_id10
      • 4(array)
        • id11
        • nameSki In/Ski Out
        • additional(false)
        • created2016-04-07 14:03:53
        • modified2016-04-07 14:03:53
        • PropertiesPropertyFeature(array)
          • id4391
          • property_id3726
          • property_feature_id11
      • 5(array)
        • id14
        • nameViews
        • additional(false)
        • created2016-04-07 14:04:55
        • modified2016-04-07 14:04:55
        • PropertiesPropertyFeature(array)
          • id4392
          • property_id3726
          • property_feature_id14
      • 6(array)
        • id17
        • nameWaterfront
        • additional(false)
        • created2016-04-07 14:06:00
        • modified2016-04-07 14:06:00
        • PropertiesPropertyFeature(array)
          • id4393
          • property_id3726
          • property_feature_id17
    • Topic(array)
      • 0(array)
        • id8
        • nameBeach
        • created2016-02-25 11:25:00
        • modified2016-02-25 11:30:26
        • tile_nameBeach
        • PropertiesTopic(array)
          • id23
          • property_id3726
          • topic_id8
      • 1(array)
        • id20
        • nameUltra Lux
        • created2016-02-25 11:25:00
        • modified2016-02-25 11:35:37
        • tile_nameUltra Lux
        • PropertiesTopic(array)
          • id24
          • property_id3726
          • topic_id20
  • 1(array)
    • Property(array)
      • id3640
      • brokerage_id192
      • created_by_user_id0
      • order0
      • multi_unit(false)
      • agent_1_id140
      • agent_2_id0
      • agent_3_id0
      • nameArizona Ranch Located on 3 Acres
      • incomplete(false)
      • archived(false)
      • last_archived0000-00-00 00:00:00
      • auto_archived_from_mlsidx(false)
      • paid_featured(false)
      • featured(true)
      • homepage_featured(false)
      • brokerage_page_featured(true)
      • requested_homepage_featured_by_member(false)
      • homepage_featured_by_member(false)
      • dot_luxury_featured(false)
      • luxury_feed_featured(false)
      • force_luxury_feed_featured(false)
      • luxury_autofeed_imported(false)
      • luxury_feed_last_added_time0000-00-00 00:00:00
      • luxury_feed_agent_user_id0
      • luxury_feed_locked_to_subscription_id0
      • luxury_feed_agent_purchase_date0000-00-00
      • luxury_feed_agent_expiration_date0000-00-00
      • digital_ad_summary_email_last_sent0000-00-00 00:00:00
      • digital_ad_summary_price_changed(false)
      • wsj_detail_url
      • ft_detail_url
      • nyt_detail_url
      • juwai_detail_url
      • pgl_detail_url
      • mg_detail_url
      • mg_c_detail_url
      • mg_s_detail_url
      • bp_detail_url
      • mw_detail_url
      • nikkei_detail_url
      • wapo_detail_url
      • robb_detail_url
      • medium_featured(false)
      • large_featured(false)
      • detail_page(true)
      • description<p>Fully fenced and cross fenced, irrigated, landscaped with lighted arena. Gearheads and equestrians will both be overly pleased with the amenities and attention to detail. Openfloor plan makes entertaining a dream around spacious kitchen. Pantry, island, bar seating, granite located at back of house with views of pool and arena. Living room open to kitchen, stacked stone fireplace, surround sound throughout home, with views to swimming pool and arena. 2 master suites, formal and informal dining areas, trophy rm/pool room too. 3 brdrs 5 baths, tile floors plenty of natural light. Over 7500 sq ft of concrete driveways, 3000 sq ft of pool decking not to mention the covered patios. 4800 sqft detached shop with room for 12 cars, 10,000 lbs car lift, 3 5500 CFM coolers, alarmed, surround sound 200 AMP service dedicated to Shop and Barn, 4 garage doors and benches and storage. 1200 sq ft BarnMaster Barn, 900 sqft BarnMaster Mare Motel, fully fenced, lighted Arena, wash rack, tack area. Property completely sprinkler, alarmed, well water and water company. Additional 3 car attached garage. Includes parcels 225-20-032 and 225-20-033</p>
      • address2303 E Hulet
      • address_2
      • cityMohave Valley
      • stateAZ
      • postal_code86440
      • countryUSA
      • use_lat_lng_for_google_map(false)
      • currencyUSD
      • price1275000
      • price_20
      • price_usd1275000
      • price_usd_20
      • statusFor Sale
      • status_last_changed0000-00-00 00:00:00
      • status_last_changed_price_only0000-00-00 00:00:00
      • lease_period
      • price_upon_request(false)
      • bedrooms3
      • bedrooms_20
      • bathrooms2
      • bathrooms_20
      • no_beds_baths(false)
      • square_feet3850
      • square_meters
      • acres3
      • interior_unitsq_ft
      • interior_size0
      • lot_unitacres
      • lot_size3
      • icon_1acreage
      • icon_2sq-ft
      • icon_3pool
      • icon_4views
      • icon_5
      • icon_6
      • websitehttp://search.ussw.net/listing/912962
      • meta_titleArizona Ranch Located on 3 Acres | Mohave Valley Real Estate | US Southwest
      • meta_description2303 E Hulet is a property offered for sale in Mohave Valley, AZ, USA, presented by US Southwest
      • meta_keywords
      • bathrooms_partial3
      • bathrooms_partial_20
      • bathrooms_3_40
      • bathrooms_3_4_20
      • year_built
      • virtual_tour
      • video_tour
      • digital_brochure
      • video_tour_embed_code
      • digital_brochure_embed_code
      • mls_num
      • wsj_property_type
      • nyt_property_type
      • nyt_popular_features
      • propgolux_property_type
      • juwai_property_type
      • juwai_category
      • propgolux_property_style
      • wapo_property_type
      • robb_property_type
      • propgolux_location_id_override
      • open_house_1_start0000-00-00 00:00:00
      • open_house_1_end_time00:00:00
      • latitude0.000000
      • longitude0.000000
      • invalid_required_fields
      • invalid_optional_fieldsagent_2_id, square_meters, hectares, virtual_tour, video_tour
      • went_live_today(false)
      • converted(true)
      • invalid(false)
      • mlsidx_full_address
      • mlsidx_date_listed0000-00-00
      • mls_market
      • primary_property_category_id0
      • realstaq_initial_image_sync(false)
      • digital_ad_listing_urls_automated(null)
      • modified2016-04-18 05:33:02
      • created2016-03-24 15:02:26
      • uri/property-detail/3640/2303-e-hulet-mohave-valley-az-86440-usa
      • absolute_urihttps://staging2.leveragere.com/property-detail/3640/2303-e-hulet-mohave-valley-az-86440-usa
      • address_concat2303 E Hulet Mohave Valley AZ 86440 USA
      • google_maps_query_string2303+E+Hulet++Mohave+Valley+AZ+86440+USA
      • luxury_ad_enrolled_prettyNO
      • price_prettyUSD 1,275,000
      • interior_unit_prettySq. Ft.
      • lot_unit_prettyAcres
      • bedrooms_pretty3
      • bathrooms_pretty2
      • bathrooms_partial_pretty3
      • bathrooms_3_4_pretty0
      • feed_full_bathrooms2
      • date_listed2016-03-24
      • overridden_brokerage_nameUS Southwest
      • overridden_brokerage_logo_uri
      • lux_ad_auto_enrolled(false)
    • PrimaryPropertyCategory(array)
      • id(null)
      • name(null)
      • created(null)
      • modified(null)
    • Brokerage(array)
      • id192
      • account_executive_id236
      • archived(false)
      • typebrokerage
      • hide_from_frontend(false)
      • agent_brokerage_data_override(false)
      • featured_development(false)
      • membership_typePremium
      • max_properties8
      • max_homepage_featured_by_member_properties0
      • featured_properties_sort_methodmanual
      • lux_feed_modeStripeSubscription
      • max_luxury_feed_properties0
      • membership_luxury_feed_properties0
      • can_participate_in_lux_feed_while_archived(false)
      • full_training_video_access(false)
      • country_id0
      • WOEID2371675
      • timezoneUS/Mountain
      • luxury_feed_enrollment_modemanual
      • luxury_feed_include_mlsidx_minimum_price0
      • luxury_feed_include_leverage_minimum_price0
      • digital_ad_contacts
      • add_agents_to_grr_auto_recipients(true)
      • mlsidx_id
      • mlsidx_lux_autofeed(false)
      • mlsidx_lux_autofeed_minimum_price0
      • mlsidx_logo_url
      • mlsidx_disclaimer
      • nameUS Southwest
      • broker_of_record_name
      • short_nameUS Southwest
      • usernameUSSouthwestLLC
      • passwordaca3f804a48f1447c4a6fd356b1f302279862050
      • password_reset_hash
      • monthly_invoice_amount(null)
      • monthly_invoice_start_date(null)
      • monthly_invoice_end_date(null)
      • contract_filename
      • active(true)
      • lead_in
      • short_description
      • 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)
        • id17255
        • modelProperty
        • model_id3640
        • tagImage
        • name35381.jpg
        • typeimage/jpg
        • size1097084
        • uri/assets/17255.jpg
        • order0
        • created2016-04-07 17:03:04
        • modified2016-04-07 17:03:04
      • 1(array)
        • id17252
        • modelProperty
        • model_id3640
        • tagImage
        • name35378.jpg
        • typeimage/jpg
        • size844882
        • uri/assets/17252.jpg
        • order1
        • created2016-04-07 17:03:03
        • modified2016-04-07 17:03:03
      • 2(array)
        • id17253
        • modelProperty
        • model_id3640
        • tagImage
        • name35379.jpg
        • typeimage/jpg
        • size934313
        • uri/assets/17253.jpg
        • order2
        • created2016-04-07 17:03:03
        • modified2016-04-07 17:03:03
      • 3(array)
        • id17254
        • modelProperty
        • model_id3640
        • tagImage
        • name35380.jpg
        • typeimage/jpg
        • size1045843
        • uri/assets/17254.jpg
        • order3
        • created2016-04-07 17:03:03
        • modified2016-04-07 17:03:04
      • 4(array)
        • id17256
        • modelProperty
        • model_id3640
        • tagImage
        • name35382.jpg
        • typeimage/jpg
        • size1661789
        • uri/assets/17256.jpg
        • order4
        • created2016-04-07 17:03:04
        • modified2016-04-07 17:03:04
      • 5(array)
        • id17257
        • modelProperty
        • model_id3640
        • tagImage
        • name35383.jpg
        • typeimage/jpg
        • size1800409
        • uri/assets/17257.jpg
        • order5
        • created2016-04-07 17:03:04
        • modified2016-04-07 17:03:04
      • 6(array)
        • id17258
        • modelProperty
        • model_id3640
        • tagImage
        • name35384.jpg
        • typeimage/jpg
        • size1662724
        • uri/assets/17258.jpg
        • order6
        • created2016-04-07 17:03:04
        • modified2016-04-07 17:03:04
      • 7(array)
        • id17259
        • modelProperty
        • model_id3640
        • tagImage
        • name35385.jpg
        • typeimage/jpg
        • size930363
        • uri/assets/17259.jpg
        • order7
        • created2016-04-07 17:03:04
        • modified2016-04-07 17:03:04
    • User(empty)
    • SecondaryPropertyCategory(empty)
    • PropertyFeature(array)
      • 0(array)
        • id12
        • nameSwimming Pool
        • additional(false)
        • created2016-04-07 14:04:12
        • modified2016-04-07 14:04:12
        • PropertiesPropertyFeature(array)
          • id3615
          • property_id3640
          • property_feature_id12
      • 1(array)
        • id14
        • nameViews
        • additional(false)
        • created2016-04-07 14:04:55
        • modified2016-04-07 14:04:55
        • PropertiesPropertyFeature(array)
          • id3616
          • property_id3640
          • property_feature_id14
    • Topic(empty)
  • 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)
      • id3154
      • brokerage_id192
      • created_by_user_id0
      • order0
      • multi_unit(false)
      • agent_1_id103
      • agent_2_id0
      • agent_3_id0
      • nameStunning Setting on the Colorado River
      • incomplete(false)
      • archived(false)
      • last_archived0000-00-00 00:00:00
      • auto_archived_from_mlsidx(false)
      • paid_featured(false)
      • featured(true)
      • homepage_featured(true)
      • brokerage_page_featured(true)
      • requested_homepage_featured_by_member(false)
      • homepage_featured_by_member(false)
      • dot_luxury_featured(false)
      • luxury_feed_featured(false)
      • force_luxury_feed_featured(false)
      • luxury_autofeed_imported(false)
      • luxury_feed_last_added_time0000-00-00 00:00:00
      • luxury_feed_agent_user_id0
      • luxury_feed_locked_to_subscription_id0
      • luxury_feed_agent_purchase_date0000-00-00
      • luxury_feed_agent_expiration_date0000-00-00
      • digital_ad_summary_email_last_sent0000-00-00 00:00:00
      • digital_ad_summary_price_changed(false)
      • wsj_detail_url
      • ft_detail_url
      • nyt_detail_url
      • juwai_detail_url
      • pgl_detail_url
      • mg_detail_url
      • mg_c_detail_url
      • mg_s_detail_url
      • bp_detail_url
      • mw_detail_url
      • nikkei_detail_url
      • wapo_detail_url
      • robb_detail_url
      • medium_featured(false)
      • large_featured(false)
      • detail_page(true)
      • description<p>Home boasts its own launch and front beach area. Spacious great room overlooks the river with breathtaking views from patio in all directions. Charming country western theme. Roomy kitchen with island for an easy entertaining lifestyle with all the bells and whistles. Lower level has a fun diner theme so you can come in off of the river, relax, and enjoy refreshments at the counter bar. Hard to find over 1/2 acre on the mighty Colorado. An electric gated entrance adds to the privacy of this very unique property.</p>
      • address2777 Camino Del Rio
      • address_2
      • cityBullhead City
      • stateAZ
      • postal_code86442
      • countryUSA
      • use_lat_lng_for_google_map(false)
      • currencyUSD
      • price1295000
      • price_20
      • price_usd1295000
      • price_usd_20
      • statusFor Sale
      • status_last_changed0000-00-00 00:00:00
      • status_last_changed_price_only0000-00-00 00:00:00
      • lease_period
      • price_upon_request(false)
      • bedrooms5
      • bedrooms_20
      • bathrooms5
      • bathrooms_20
      • no_beds_baths(false)
      • square_feet4925
      • square_meters
      • acres0
      • interior_unitsq_ft
      • interior_size0
      • lot_unitacres
      • lot_size0
      • icon_1waterfront
      • icon_2sq-ft
      • icon_3views
      • icon_4
      • icon_5
      • icon_6
      • website
      • meta_titleStunning Setting on the Colorado River | Bullhead City Real Estate | US Southwest
      • meta_description2777 Camino Del Rio is a property offered for sale in Bullhead City, AZ, USA, presented by US Southwest
      • meta_keywords
      • bathrooms_partial0
      • bathrooms_partial_20
      • bathrooms_3_40
      • bathrooms_3_4_20
      • year_built
      • virtual_tour
      • video_tour
      • digital_brochure
      • video_tour_embed_code
      • digital_brochure_embed_code
      • mls_num
      • wsj_property_type
      • nyt_property_type
      • nyt_popular_features
      • propgolux_property_type
      • juwai_property_type
      • juwai_category
      • propgolux_property_style
      • wapo_property_type
      • robb_property_type
      • propgolux_location_id_override
      • open_house_1_start0000-00-00 00:00:00
      • open_house_1_end_time00:00:00
      • latitude0.000000
      • longitude0.000000
      • invalid_required_fields
      • invalid_optional_fieldsagent_2_id, bathrooms_partial, square_meters, acres, hectares, virtual_tour, video_tour
      • went_live_today(false)
      • converted(true)
      • invalid(false)
      • mlsidx_full_address
      • mlsidx_date_listed0000-00-00
      • mls_market
      • primary_property_category_id0
      • realstaq_initial_image_sync(false)
      • digital_ad_listing_urls_automated(null)
      • modified2016-04-18 05:33:02
      • created2015-11-25 13:37:02
      • uri/property-detail/3154/2777-camino-del-rio-bullhead-city-az-86442-usa
      • absolute_urihttps://staging2.leveragere.com/property-detail/3154/2777-camino-del-rio-bullhead-city-az-86442-usa
      • address_concat2777 Camino Del Rio Bullhead City AZ 86442 USA
      • google_maps_query_string2777+Camino+Del+Rio++Bullhead+City+AZ+86442+USA
      • luxury_ad_enrolled_prettyNO
      • price_prettyUSD 1,295,000
      • interior_unit_prettySq. Ft.
      • lot_unit_prettyAcres
      • bedrooms_pretty5
      • bathrooms_pretty5
      • bathrooms_partial_pretty0
      • bathrooms_3_4_pretty0
      • feed_full_bathrooms5
      • date_listed2015-11-25
      • overridden_brokerage_nameUS Southwest
      • overridden_brokerage_logo_uri
      • lux_ad_auto_enrolled(false)
    • PrimaryPropertyCategory(array)
      • id(null)
      • name(null)
      • created(null)
      • modified(null)
    • Brokerage(array)
      • id192
      • account_executive_id236
      • archived(false)
      • typebrokerage
      • hide_from_frontend(false)
      • agent_brokerage_data_override(false)
      • featured_development(false)
      • membership_typePremium
      • max_properties8
      • max_homepage_featured_by_member_properties0
      • featured_properties_sort_methodmanual
      • lux_feed_modeStripeSubscription
      • max_luxury_feed_properties0
      • membership_luxury_feed_properties0
      • can_participate_in_lux_feed_while_archived(false)
      • full_training_video_access(false)
      • country_id0
      • WOEID2371675
      • timezoneUS/Mountain
      • luxury_feed_enrollment_modemanual
      • luxury_feed_include_mlsidx_minimum_price0
      • luxury_feed_include_leverage_minimum_price0
      • digital_ad_contacts
      • add_agents_to_grr_auto_recipients(true)
      • mlsidx_id
      • mlsidx_lux_autofeed(false)
      • mlsidx_lux_autofeed_minimum_price0
      • mlsidx_logo_url
      • mlsidx_disclaimer
      • nameUS Southwest
      • broker_of_record_name
      • short_nameUS Southwest
      • usernameUSSouthwestLLC
      • passwordaca3f804a48f1447c4a6fd356b1f302279862050
      • password_reset_hash
      • monthly_invoice_amount(null)
      • monthly_invoice_start_date(null)
      • monthly_invoice_end_date(null)
      • contract_filename
      • active(true)
      • lead_in
      • short_description
      • 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)
        • id16839
        • modelProperty
        • model_id3154
        • tagImage
        • name30307.jpg
        • typeimage/jpg
        • size348375
        • uri/assets/16839.jpg
        • order0
        • created2016-04-07 17:00:12
        • modified2016-04-07 17:00:12
      • 1(array)
        • id16835
        • modelProperty
        • model_id3154
        • tagImage
        • name30308.jpg
        • typeimage/jpg
        • size398669
        • uri/assets/16835.jpg
        • order1
        • created2016-04-07 17:00:12
        • modified2016-04-07 17:00:12
      • 2(array)
        • id16834
        • modelProperty
        • model_id3154
        • tagImage
        • name30310.jpg
        • typeimage/jpg
        • size366697
        • uri/assets/16834.jpg
        • order3
        • created2016-04-07 17:00:12
        • modified2016-04-07 17:00:12
      • 3(array)
        • id16838
        • modelProperty
        • model_id3154
        • tagImage
        • name30311.jpg
        • typeimage/jpg
        • size456592
        • uri/assets/16838.jpg
        • order4
        • created2016-04-07 17:00:12
        • modified2016-04-07 17:00:12
      • 4(array)
        • id16833
        • modelProperty
        • model_id3154
        • tagImage
        • name30312.jpg
        • typeimage/jpg
        • size541353
        • uri/assets/16833.jpg
        • order5
        • created2016-04-07 17:00:12
        • modified2016-04-07 17:00:12
      • 5(array)
        • id16837
        • modelProperty
        • model_id3154
        • tagImage
        • name30313.jpg
        • typeimage/jpg
        • size705325
        • uri/assets/16837.jpg
        • order6
        • created2016-04-07 17:00:12
        • modified2016-04-07 17:00:12
      • 6(array)
        • id16832
        • modelProperty
        • model_id3154
        • tagImage
        • name30314.jpg
        • typeimage/jpg
        • size591219
        • uri/assets/16832.jpg
        • order7
        • created2016-04-07 17:00:12
        • modified2016-04-07 17:00:12
      • 7(array)
        • id16836
        • modelProperty
        • model_id3154
        • tagImage
        • name31083.jpg
        • typeimage/jpg
        • size1023241
        • uri/assets/16836.jpg
        • order7
        • created2016-04-07 17:00:12
        • modified2016-04-07 17:00:12
    • User(array)
      • 0(array)
        • id332
        • typeAgent
        • brokerage_id192
        • email[email protected]
        • password379216c1d1f823296a376037feefa9c12b2e3648
        • recover_hash
        • first_nameAnn
        • last_namePettit
        • title
        • dre_num
        • phone(928)234-5555
        • max_luxury_feed_properties0
        • headshot_filename
        • bio
        • brokerage_name_override
        • stripe_customer_id
        • digital_ad_first_free_month_couponineligible
        • modified2017-08-07 15:22:47
        • created2017-08-07 15:22:47
        • notified(false)
        • full_nameAnn Pettit
        • uri/agent-detail/332/ann-pettit
        • profile_complete(true)
        • UsersProperty(array)
          • id117
          • user_id332
          • property_id3154
          • sort_order0
    • SecondaryPropertyCategory(empty)
    • PropertyFeature(array)
      • 0(array)
        • id17
        • nameWaterfront
        • additional(false)
        • created2016-04-07 14:06:00
        • modified2016-04-07 14:06:00
        • PropertiesPropertyFeature(array)
          • id3504
          • property_id3154
          • property_feature_id17
      • 1(array)
        • id14
        • nameViews
        • additional(false)
        • created2016-04-07 14:04:55
        • modified2016-04-07 14:04:55
        • PropertiesPropertyFeature(array)
          • id3505
          • property_id3154
          • property_feature_id14
    • Topic(empty)
• 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)
      • 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
  • 1(array)
    • Property(array)
      • id3640
      • brokerage_id192
      • created_by_user_id0
      • order0
      • multi_unit(false)
      • agent_1_id140
      • agent_2_id0
      • agent_3_id0
      • nameArizona Ranch Located on 3 Acres
      • incomplete(false)
      • archived(false)
      • last_archived0000-00-00 00:00:00
      • auto_archived_from_mlsidx(false)
      • paid_featured(false)
      • featured(true)
      • homepage_featured(false)
      • brokerage_page_featured(true)
      • requested_homepage_featured_by_member(false)
      • homepage_featured_by_member(false)
      • dot_luxury_featured(false)
      • luxury_feed_featured(false)
      • force_luxury_feed_featured(false)
      • luxury_autofeed_imported(false)
      • luxury_feed_last_added_time0000-00-00 00:00:00
      • luxury_feed_agent_user_id0
      • luxury_feed_locked_to_subscription_id0
      • luxury_feed_agent_purchase_date0000-00-00
      • luxury_feed_agent_expiration_date0000-00-00
      • digital_ad_summary_email_last_sent0000-00-00 00:00:00
      • digital_ad_summary_price_changed(false)
      • wsj_detail_url
      • ft_detail_url
      • nyt_detail_url
      • juwai_detail_url
      • pgl_detail_url
      • mg_detail_url
      • mg_c_detail_url
      • mg_s_detail_url
      • bp_detail_url
      • mw_detail_url
      • nikkei_detail_url
      • wapo_detail_url
      • robb_detail_url
      • medium_featured(false)
      • large_featured(false)
      • detail_page(true)
      • description<p>Fully fenced and cross fenced, irrigated, landscaped with lighted arena. Gearheads and equestrians will both be overly pleased with the amenities and attention to detail. Openfloor plan makes entertaining a dream around spacious kitchen. Pantry, island, bar seating, granite located at back of house with views of pool and arena. Living room open to kitchen, stacked stone fireplace, surround sound throughout home, with views to swimming pool and arena. 2 master suites, formal and informal dining areas, trophy rm/pool room too. 3 brdrs 5 baths, tile floors plenty of natural light. Over 7500 sq ft of concrete driveways, 3000 sq ft of pool decking not to mention the covered patios. 4800 sqft detached shop with room for 12 cars, 10,000 lbs car lift, 3 5500 CFM coolers, alarmed, surround sound 200 AMP service dedicated to Shop and Barn, 4 garage doors and benches and storage. 1200 sq ft BarnMaster Barn, 900 sqft BarnMaster Mare Motel, fully fenced, lighted Arena, wash rack, tack area. Property completely sprinkler, alarmed, well water and water company. Additional 3 car attached garage. Includes parcels 225-20-032 and 225-20-033</p>
      • address2303 E Hulet
      • address_2
      • cityMohave Valley
      • stateAZ
      • postal_code86440
      • countryUSA
      • use_lat_lng_for_google_map(false)
      • currencyUSD
      • price1275000
      • price_20
      • price_usd1275000
      • price_usd_20
      • statusFor Sale
      • status_last_changed0000-00-00 00:00:00
      • status_last_changed_price_only0000-00-00 00:00:00
      • lease_period
      • price_upon_request(false)
      • bedrooms3
      • bedrooms_20
      • bathrooms2
      • bathrooms_20
      • no_beds_baths(false)
      • square_feet3850
      • square_meters
      • acres3
      • interior_unitsq_ft
      • interior_size0
      • lot_unitacres
      • lot_size3
      • icon_1acreage
      • icon_2sq-ft
      • icon_3pool
      • icon_4views
      • icon_5
      • icon_6
      • websitehttp://search.ussw.net/listing/912962
      • meta_titleArizona Ranch Located on 3 Acres | Mohave Valley Real Estate | US Southwest
      • meta_description2303 E Hulet is a property offered for sale in Mohave Valley, AZ, USA, presented by US Southwest
      • meta_keywords
      • bathrooms_partial3
      • bathrooms_partial_20
      • bathrooms_3_40
      • bathrooms_3_4_20
      • year_built
      • virtual_tour
      • video_tour
      • digital_brochure
      • video_tour_embed_code
      • digital_brochure_embed_code
      • mls_num
      • wsj_property_type
      • nyt_property_type
      • nyt_popular_features
      • propgolux_property_type
      • juwai_property_type
      • juwai_category
      • propgolux_property_style
      • wapo_property_type
      • robb_property_type
      • propgolux_location_id_override
      • open_house_1_start0000-00-00 00:00:00
      • open_house_1_end_time00:00:00
      • latitude0.000000
      • longitude0.000000
      • invalid_required_fields
      • invalid_optional_fieldsagent_2_id, square_meters, hectares, virtual_tour, video_tour
      • went_live_today(false)
      • converted(true)
      • invalid(false)
      • mlsidx_full_address
      • mlsidx_date_listed0000-00-00
      • mls_market
      • primary_property_category_id0
      • realstaq_initial_image_sync(false)
      • digital_ad_listing_urls_automated(null)
      • modified2016-04-18 05:33:02
      • created2016-03-24 15:02:26
      • uri/property-detail/3640/2303-e-hulet-mohave-valley-az-86440-usa
      • absolute_urihttps://staging2.leveragere.com/property-detail/3640/2303-e-hulet-mohave-valley-az-86440-usa
      • address_concat2303 E Hulet Mohave Valley AZ 86440 USA
      • google_maps_query_string2303+E+Hulet++Mohave+Valley+AZ+86440+USA
      • luxury_ad_enrolled_prettyNO
      • price_prettyUSD 1,275,000
      • interior_unit_prettySq. Ft.
      • lot_unit_prettyAcres
      • bedrooms_pretty3
      • bathrooms_pretty2
      • bathrooms_partial_pretty3
      • bathrooms_3_4_pretty0
      • feed_full_bathrooms2
      • date_listed2016-03-24
      • overridden_brokerage_nameUS Southwest
      • overridden_brokerage_logo_uri
      • lux_ad_auto_enrolled(false)
    • PrimaryPropertyCategory(array)
      • id(null)
      • name(null)
      • created(null)
      • modified(null)
    • Brokerage(array)
      • id192
      • account_executive_id236
      • archived(false)
      • typebrokerage
      • hide_from_frontend(false)
      • agent_brokerage_data_override(false)
      • featured_development(false)
      • membership_typePremium
      • max_properties8
      • max_homepage_featured_by_member_properties0
      • featured_properties_sort_methodmanual
      • lux_feed_modeStripeSubscription
      • max_luxury_feed_properties0
      • membership_luxury_feed_properties0
      • can_participate_in_lux_feed_while_archived(false)
      • full_training_video_access(false)
      • country_id0
      • WOEID2371675
      • timezoneUS/Mountain
      • luxury_feed_enrollment_modemanual
      • luxury_feed_include_mlsidx_minimum_price0
      • luxury_feed_include_leverage_minimum_price0
      • digital_ad_contacts
      • add_agents_to_grr_auto_recipients(true)
      • mlsidx_id
      • mlsidx_lux_autofeed(false)
      • mlsidx_lux_autofeed_minimum_price0
      • mlsidx_logo_url
      • mlsidx_disclaimer
      • nameUS Southwest
      • broker_of_record_name
      • short_nameUS Southwest
      • usernameUSSouthwestLLC
      • passwordaca3f804a48f1447c4a6fd356b1f302279862050
      • password_reset_hash
      • monthly_invoice_amount(null)
      • monthly_invoice_start_date(null)
      • monthly_invoice_end_date(null)
      • contract_filename
      • active(true)
      • lead_in
      • short_description
      • 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)
        • id17255
        • modelProperty
        • model_id3640
        • tagImage
        • name35381.jpg
        • typeimage/jpg
        • size1097084
        • uri/assets/17255.jpg
        • order0
        • created2016-04-07 17:03:04
        • modified2016-04-07 17:03:04
      • 1(array)
        • id17252
        • modelProperty
        • model_id3640
        • tagImage
        • name35378.jpg
        • typeimage/jpg
        • size844882
        • uri/assets/17252.jpg
        • order1
        • created2016-04-07 17:03:03
        • modified2016-04-07 17:03:03
      • 2(array)
        • id17253
        • modelProperty
        • model_id3640
        • tagImage
        • name35379.jpg
        • typeimage/jpg
        • size934313
        • uri/assets/17253.jpg
        • order2
        • created2016-04-07 17:03:03
        • modified2016-04-07 17:03:03
      • 3(array)
        • id17254
        • modelProperty
        • model_id3640
        • tagImage
        • name35380.jpg
        • typeimage/jpg
        • size1045843
        • uri/assets/17254.jpg
        • order3
        • created2016-04-07 17:03:03
        • modified2016-04-07 17:03:04
      • 4(array)
        • id17256
        • modelProperty
        • model_id3640
        • tagImage
        • name35382.jpg
        • typeimage/jpg
        • size1661789
        • uri/assets/17256.jpg
        • order4
        • created2016-04-07 17:03:04
        • modified2016-04-07 17:03:04
      • 5(array)
        • id17257
        • modelProperty
        • model_id3640
        • tagImage
        • name35383.jpg
        • typeimage/jpg
        • size1800409
        • uri/assets/17257.jpg
        • order5
        • created2016-04-07 17:03:04
        • modified2016-04-07 17:03:04
      • 6(array)
        • id17258
        • modelProperty
        • model_id3640
        • tagImage
        • name35384.jpg
        • typeimage/jpg
        • size1662724
        • uri/assets/17258.jpg
        • order6
        • created2016-04-07 17:03:04
        • modified2016-04-07 17:03:04
      • 7(array)
        • id17259
        • modelProperty
        • model_id3640
        • tagImage
        • name35385.jpg
        • typeimage/jpg
        • size930363
        • uri/assets/17259.jpg
        • order7
        • created2016-04-07 17:03:04
        • modified2016-04-07 17:03:04
    • User(empty)
    • SecondaryPropertyCategory(empty)
    • PropertyFeature(array)
      • 0(array)
        • id12
        • nameSwimming Pool
        • additional(false)
        • created2016-04-07 14:04:12
        • modified2016-04-07 14:04:12
        • PropertiesPropertyFeature(array)
          • id3615
          • property_id3640
          • property_feature_id12
      • 1(array)
        • id14
        • nameViews
        • additional(false)
        • created2016-04-07 14:04:55
        • modified2016-04-07 14:04:55
        • PropertiesPropertyFeature(array)
          • id3616
          • property_id3640
          • property_feature_id14
    • Topic(empty)
• custom_ga_event_properties(array)
  • brokerageUS Southwest, Bullhead City
• property(array)
  • Property(array)
    • 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/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)
      • 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
      • 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(empty)
      • BrokerageLogoOverride(empty)
  • 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
      • Icon(array)
        • id3559
        • modelPropertyFeature
        • model_id10
        • tagIcon
        • name138.png
        • typeimage/png
        • size2159
        • uri/assets/3559.png
        • order0
        • created2016-04-07 14:03:34
        • modified2016-04-07 14:03:36
    • 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
      • Icon(array)
        • id3566
        • modelPropertyFeature
        • model_id17
        • tagIcon
        • name145.png
        • typeimage/png
        • size2066
        • uri/assets/3566.png
        • order0
        • created2016-04-07 14:05:58
        • modified2016-04-07 14:06:00
    • 2(array)
      • id3
      • nameDock
      • additional(false)
      • created2016-04-07 14:01:13
      • modified2016-04-07 14:01:13
      • PropertiesPropertyFeature(array)
        • id3973
        • property_id3287
        • 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
  • Topic(empty)
• membership_subscription_temp_allowed_login(null)
• newsletter_member_types(array)
  • Leverage Member: AgentLeverage Member: Agent
  • Leverage Member: Broker or ManagementLeverage Member: Broker or Management
  • Non-MemberNon-Member
• $request->data(empty)
• $this->validationErrors(array)
  • Subscription(empty)
  • Property(empty)
  • User(empty)
  • PropertyFeature(empty)
  • SecondaryPropertyCategory(empty)
  • Topic(empty)
  • PrimaryPropertyCategory(empty)
  • Brokerage(empty)
  • StripeSubscription(empty)
  • GlobalReachReport(empty)
  • AccountExecutive(empty)
  • Logo(empty)
  • MainImage(empty)
  • ContactImage(empty)
  • ContactImage2(empty)
  • ContactImage3(empty)
  • BrokerOfRecordLogo(empty)
  • MainArticle(empty)
  • Location(empty)
  • FeaturedImage(empty)
  • Image(empty)
  • UsersProperty(empty)
  • BrokerageLogoOverride(empty)
  • PropertiesSecondaryPropertyCategory(empty)
  • PropertiesPropertyFeature(empty)
  • Icon(empty)
  • PropertiesTopic(empty)
• Loaded Helpers(array)
  • 0Permission
  • 1Number
  • 2SimpleGraph
  • 3DebugTimer
  • 4Toolbar
  • 5Session
  • 6Text
  • 7Flash
  • 8HtmlToolbar
  • 9Html
  • 10Form