Title Page Background
HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 3137 AND i.igate IN ('usahud','azhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'azhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 3137 AND i.igate IN ('usahud','azhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'azhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 3137 AND i.igate IN ('usahud','azhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'azhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

2122 Mcculloch Blvd N
Lake Havasu City, AZ 86403
Tiffani Lambro & Co. with Havasu Realty, original listing - (928) 453-5554

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $6,500,000
Beds: --
Baths: --
Status: Active
SqFt: 2429 Square Feet
Agency: Havasu Realty
Agency Phone: (928) 453-5554

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Commercial Sale-Other
Year Built: 1972
Notes: Great Business Opportunity to Own an Established Bar/Night Club & Tavern Right on Main Street! Same Owners Since 2006, Live Music Venue, Sports Bar, Event Space, Almost 100' Of Main Street Frontage - Enjoy All Local Main Street Events, #6 Liquor License, Largest Outdoor Patio in Town, 2428sqft Indoor Bar Area, Nightly Karaoke- Air Conditioned Booth, Indoor Pool Tables, Outdoor DJ Booth, Large Outdoor Dance Floor, Outdoor Cooling MistIng System, Outdoor Firepit, 19 TV's Outside on the Patio, 15 TV's on the Inside Bar, Blizzard Beer Cooling Tap System - Keeps Beer Cold to 29 Degrees! Coldest Beer in Town! 40 Beers on Tap! Full Food Menu Available Sunday- Thursday 11AM-8PM & Friday-Saturday 11AM-2AM, Aloha POS system, ATM Machine, Vending Machine, Lottery Vending, 40 NVR & DVR Security System, New Large Capacity Ice Machine, Busy Bar Open 6AM to 2AM 7 Days a Week, This Bar Makes Money! Great Bartenders & Staff! <br /> Buyers Must Show Proof of Funds With Offers. Private Tours will be given once Buyers are Qualified. Do Not Disturb the Bartenders Or Staff. | Bar has been Featured On Bravo TV on Vanderpump Rules
MlsNumber: --
ListingId: 1026933


Listing Provided By: Havasu Realty, original listing
Phone: (928) 277-9166
Office Phone: (928) 453-5554
Agent Name: Tiffani Lambro & Co.
Disclaimer: Copyright © 2024 Lake Havasu Association of Realtors. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App