Data

Debug Info (admin only)

Search Criteria:

Keyword: None
Categories: None
Search Terms: None
Types: None
Show Unpublished: No
Sort: types
Order: ASC

Pagination:

Current Page: 2
Limit per Page: 25
Offset: 25
Total Pages: 26

Results:

Total Available Records: 642
Total After Limits: 642
Results Loaded: 25

Query:

SELECT p.place_id, COALESCE(NULLIF(e.name, ''), p.name) AS name, IF(e.name IS NOT NULL AND e.name != '', 1, 0) AS has_edit_name, COALESCE(NULLIF(e.address, ''), p.formatted_address) AS formatted_address, IF(e.address IS NOT NULL AND e.address != '', 1, 0) AS has_edit_address, p.lat, p.lng, p.weighted_rating, p.composite_score, p.distance, COALESCE(NULLIF(e.redmond_category, ''), p.redmond_category) AS redmond_category, IF(e.redmond_category IS NOT NULL AND e.redmond_category != '', 1, 0) AS has_edit_redmond_category, COALESCE(NULLIF(e.redmond_search_term, ''), p.redmond_search_term) AS redmond_search_term, IF(e.redmond_search_term IS NOT NULL AND e.redmond_search_term != '', 1, 0) AS has_edit_redmond_search_term, COALESCE(NULLIF(e.types, ''), p.types) AS types, IF(e.types IS NOT NULL AND e.types != '', 1, 0) AS has_edit_types, COALESCE(NULLIF(e.website, ''), p.website) AS website, IF(e.website IS NOT NULL AND e.website != '', 1, 0) AS has_edit_website, COALESCE(NULLIF(e.phone, ''), p.formatted_phone_number) AS formatted_phone_number, IF(e.phone IS NOT NULL AND e.phone != '', 1, 0) AS has_edit_phone, CASE WHEN e.place_id IS NOT NULL THEN 1 ELSE 0 END AS has_edits, e.is_published 
                 FROM wp_redmond_explorer_places p
                 LEFT JOIN wp_redmond_explorer_edits e ON p.place_id = e.place_id
                  WHERE (e.is_published IS NULL OR e.is_published = 1) AND NOT EXISTS (
                SELECT 1 FROM wp_redmond_explorer_edits e2 
                WHERE e2.place_id = p.place_id AND e2.is_published = 0
            ) ORDER BY COALESCE(e.types, p.types) ASC LIMIT 25, 25

Previous Next

Page 2 of 26

Showing 26 to 50 of 642 results

Place ID	Name	Address	Latitude	Longitude	Distance	Category	Search Term	Types ↑	Links	Phone	Hours	Photos
ChIJCYdlAG4rv1QRLobmftuvHic	1/8th Street Food Trucks, Patio & Taphouse	639 SW 8th Street &, SW Glacier Ave, Redmond, OR 97756, USA	44.2708060	-121.1767190	301 m		cocktails, cocktails,nightlife,cocktails,food trucks,family friendly, family friendly, food trucks, nightlife	bar,establishment,food,point_of_interest	Page \| Maps \| Website	(541) 527-1387	View Hours Monday: Closed Tuesday: 11:00 AM – 8:00 PM Wednesday: 11:00 AM – 8:00 PM Thursday: 11:00 AM – 8:00 PM Friday: 11:00 AM – 8:00 PM Saturday: 11:00 AM – 8:00 PM Sunday: Closed	View Photos (4)
ChIJESyGgSUrv1QR4Mi5-iXwbUs	Testimony Wine Bar	307 NW 6th St, Redmond, OR 97756, USA	44.2784660	-121.1746190	652 m		bars, bars,cocktails,live music,bars,cocktails,live music,nightlife,pubs,winery,wine bar, cocktails, live music, nightlife, pubs, vineyards, wine bar, winery	bar,establishment,food,point_of_interest	Page \| Maps \| Website	(541) 400-1556	View Hours Monday: 3:00 – 7:00 PM Tuesday: Closed Wednesday: 2:00 – 8:00 PM Thursday: 1:00 – 8:00 PM Friday: 1:00 – 9:00 PM Saturday: 1:00 – 9:00 PM Sunday: 2:00 – 6:00 PM	View Photos (4)
ChIJVSo4LG4rv1QR8I1wB8iXxMI	Beyond The Vine	427 SW 8th St, Redmond, OR 97756, USA	44.2730720	-121.1766230	221 m		bars, bars,cocktails,nightlife,bars,cocktails,nightlife,pubs,winery,wine bar, cocktails, nightlife, pubs, vineyards, wine bar, winery	bar,establishment,food,point_of_interest	Page \| Maps \| Website	(541) 610-3390	View Hours Monday: Closed Tuesday: 3:00 – 8:00 PM Wednesday: 3:00 – 8:00 PM Thursday: 3:00 – 8:00 PM Friday: 2:00 – 9:00 PM Saturday: 2:00 – 9:00 PM Sunday: Closed	View Photos (4)
ChIJ-Q-cWxErv1QR-aYDNGjdTPE	Wayfarer Club	525 SW 6th St, Redmond, OR 97756, USA	44.2721900	-121.1745760	71 m	bars-nightlife (edited)	bars (edited)	bar,establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 508-7600	View Hours Monday: 3:00 – 9:00 PM Tuesday: 3:00 – 9:00 PM Wednesday: 3:00 – 9:00 PM Thursday: 3:00 – 9:00 PM Friday: 3:00 – 11:00 PM Saturday: 3:00 – 11:00 PM Sunday: 3:00 – 9:00 PM	View Photos (4)
ChIJmdc9yMYrv1QRqWkW-OrnumI	The Rooftop at SCP Redmond	restaurants (edited)	44.2721630	-121.1745910	74 m	bars-nightlife,sestaurants,beer-wine-spirits (edited)	bars (edited)	bar,establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	lunch (edited)	View Hours Monday: Closed Tuesday: 4:00 – 9:00 PM Wednesday: 4:00 – 9:00 PM Thursday: 4:00 – 9:00 PM Friday: 4:00 – 9:00 PM Saturday: 4:00 – 9:00 PM Sunday: Closed	View Photos (4)
ChIJC18JtDArv1QRQs9GRj7LBCw	General Duffy’s Waterhole	404 SW Forest Ave, Redmond, OR 97756, USA	44.2714000	-121.1723500	185 m	food trucks (edited)	food trucks (edited)	bar,establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 527-4345	View Hours Monday: 4:00 – 8:00 PM Tuesday: 11:00 AM – 8:00 PM Wednesday: 11:00 AM – 8:00 PM Thursday: 11:00 AM – 8:00 PM Friday: 11:00 AM – 8:00 PM Saturday: 11:00 AM – 8:00 PM Sunday: 11:00 AM – 8:00 PM	View Photos (4)
ChIJ0xxnLtoqv1QRMRpbgyRFMks	The Moontower	329 SW 6th St, Redmond, OR 97756, USA	44.2741020	-121.1745610	172 m		bars, bars,cocktails,live music,nightlife,pool tables,bars,cocktails,live music,nightlife,pool tables,pubs,restaurants,breakfast,lunch,dining, cocktails, live music, nightlife, pool tables, pubs, restaurants	bar,establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 548-3731	View Hours Monday: 11:00 AM – 10:00 PM Tuesday: 11:00 AM – 10:00 PM Wednesday: 11:00 AM – 10:00 PM Thursday: 11:00 AM – 10:00 PM Friday: 11:00 AM – 12:00 AM Saturday: 7:00 AM – 12:00 AM Sunday: 7:00 AM – 9:00 PM	View Photos (4)
ChIJ69QfC5Esv1QRnRVhLGWGHi0	Niblick & Greene’s	restaurants (edited)	44.2629500	-121.2623320	7,121 m	bars-nightlife,sestaurants,beer-wine-spirits (edited)	bars (edited)	bar,establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	lunch (edited)	View Hours Monday: Closed Tuesday: Closed Wednesday: 4:00 – 9:00 PM Thursday: 4:00 – 9:00 PM Friday: 4:00 – 9:00 PM Saturday: 4:00 – 9:00 PM Sunday: Closed	View Photos (4)
ChIJ6WqrGooqv1QRyegH-EWAEyU	Clock Tower Pub Redmond	2757 NW 7th St # G, Redmond, OR 97756, USA	44.3013990	-121.1755830	3,203 m		bars, bars,cocktails,live music,nightlife,pool tables,bars,cocktails,live music,nightlife,pool tables,pubs,brewery, brewery, cocktails, live music, nightlife, pool tables, pubs	bar,establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 526-1871	View Hours Monday: 11:00 AM – 9:00 PM Tuesday: 11:00 AM – 10:00 PM Wednesday: 11:00 AM – 10:00 PM Thursday: 11:00 AM – 11:00 PM Friday: 11:00 AM – 11:00 PM Saturday: 11:00 AM – 11:00 PM Sunday: 11:00 AM – 9:00 PM	View Photos (4)
ChIJ86CATOwqv1QRxPcOUjaNJGI	Bottoms Up Bar & Grill	1421 NW 6th St, Redmond, OR 97756, USA	44.2895840	-121.1743040	1,887 m		bars, bars,cocktails,live music,nightlife,bars,cocktails,live music,nightlife,pubs,brewery,breakfast, breakfast, brewery, cocktails, live music, lunch, nightlife, pubs, restaurants	bar,establishment,food,point_of_interest,restaurant	Page \| Maps	(541) 548-5663	View Hours Monday: 11:30 AM – 10:00 PM Tuesday: 11:30 AM – 10:00 PM Wednesday: 11:30 AM – 10:00 PM Thursday: 11:30 AM – 10:00 PM Friday: 7:00 AM – 12:00 AM Saturday: 7:00 AM – 12:00 AM Sunday: 7:00 AM – 9:00 PM	View Photos (4)
ChIJb6k1H9oqv1QRapN-r9Hap6s	Brickhouse	412 SW 6th St, Redmond, OR 97756, USA	44.2733140	-121.1739980	77 m		bars, bars,cocktails,bars,cocktails,nightlife,pubs,restaurants,dining, cocktails, desserts, dining, nightlife, pubs	bar,establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 526-1782	View Hours Monday: 4:00 – 8:00 PM Tuesday: 4:00 – 9:00 PM Wednesday: 4:00 – 9:00 PM Thursday: 4:00 – 9:00 PM Friday: 4:00 – 9:00 PM Saturday: 4:00 – 9:00 PM Sunday: 4:00 – 8:00 PM	View Photos (4)
ChIJeWBq8dkqv1QRdcA_f-niRhw	Diego’s Spirited Kitchen	447 SW 6th St, Redmond, OR 97756, USA	44.2728220	-121.1744640	49 m		bars, bars,cocktails,nightlife,bars,cocktails,pubs,restaurants,lunch,dining,family friendly, brewery, cocktails, dining, lunch, nightlife, pubs, restaurants	bar,establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 316-2002	View Hours Monday: 11:00 AM – 10:00 PM Tuesday: 11:00 AM – 10:00 PM Wednesday: 11:00 AM – 10:00 PM Thursday: 11:00 AM – 10:00 PM Friday: 11:00 AM – 10:00 PM Saturday: 11:00 AM – 10:00 PM Sunday: Closed	View Photos (4)
ChIJo4ai9hgrv1QRgtz5-j3Dcuk	Hideaway Redmond	507 SW 8th St, Redmond, OR 97756, USA	44.2723770	-121.1766400	218 m		bars, bars,cocktails,nightlife,bars,cocktails,nightlife,pubs,restaurants,breakfast,lunch,dining,family friendly, breakfast, cocktails, lunch, nightlife, pubs, restaurants	bar,establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 526-5989	View Hours Monday: 11:00 AM – 10:00 PM Tuesday: 11:00 AM – 10:00 PM Wednesday: 11:00 AM – 10:00 PM Thursday: 11:00 AM – 10:00 PM Friday: 11:00 AM – 11:00 PM Saturday: 8:00 AM – 11:00 PM Sunday: 8:00 AM – 9:00 PM	View Photos (4)
ChIJp17jgrzUuFQRmzMHKITf0ZU	Applebee’s Grill + Bar \| IHOP	3807 SW 21st St, Redmond, OR 97756, USA	44.2412720	-121.1921840	3,777 m		bars, bars,pubs, cocktails, lunch, nightlife, pubs, restaurants	bar,establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 923-4777	View Hours Monday: 6:00 AM – 12:00 AM Tuesday: 6:00 AM – 12:00 AM Wednesday: 6:00 AM – 12:00 AM Thursday: 6:00 AM – 12:00 AM Friday: 6:00 AM – 12:00 AM Saturday: 6:00 AM – 12:00 AM Sunday: 6:00 AM – 12:00 AM	View Photos (4)
ChIJQbpvDv0rv1QRNw9JdvxktaU	Initiative Brewing (the Hub)	424 NW 5th St, Redmond, OR 97756, USA	44.2799660	-121.1729920	820 m		bars, bars,cocktails,live music,nightlife,bars,cocktails,live music,nightlife,pubs,brewery,microbrewery,restaurants,lunch,dining,family friendly, brewery, cocktails, food trucks, live music, microbrewery, nightlife, pubs	bar,establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 527-4380	View Hours Monday: 11:00 AM – 8:00 PM Tuesday: 11:00 AM – 8:00 PM Wednesday: 11:00 AM – 8:00 PM Thursday: 11:00 AM – 8:00 PM Friday: 11:00 AM – 8:00 PM Saturday: 11:00 AM – 8:00 PM Sunday: 11:00 AM – 8:00 PM	View Photos (4)
ChIJSReNtm4rv1QRUvPn3v-Ifr0	Annex Sports Bar	413 SW Glacier Ave, Redmond, OR 97756, USA	44.2709410	-121.1724960	218 m		bars, bars,cocktails,live music,nightlife,pool tables,bars,cocktails,live music,nightlife,pool tables,pubs, cocktails, dining, food trucks, live music, nightlife, pool tables, pubs	bar,establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 408-2572	View Hours Monday: 4:00 PM – 2:00 AM Tuesday: 4:00 PM – 2:00 AM Wednesday: 4:00 PM – 2:00 AM Thursday: 4:00 PM – 2:00 AM Friday: 4:00 PM – 2:00 AM Saturday: 4:00 PM – 2:00 AM Sunday: 4:00 PM – 2:00 AM	View Photos (4)
ChIJSV_XNdYqv1QRBozho0XC10k	Cascade Lakes Pub at 7th St	855 SW 7th St, Redmond, OR 97756, USA	44.2687760	-121.1757060	450 m		bars, bars,cocktails,nightlife,bars,cocktails,nightlife,pubs,brewery,microbrewery,restaurants,lunch,dining,family friendly, brewery, cocktails, live music, lunch, microbrewery, nightlife, pubs, restaurants	bar,establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 923-1795	View Hours Monday: 11:00 AM – 9:00 PM Tuesday: 11:00 AM – 9:00 PM Wednesday: 11:00 AM – 9:00 PM Thursday: 11:00 AM – 9:00 PM Friday: 11:00 AM – 10:00 PM Saturday: 11:00 AM – 10:00 PM Sunday: 11:00 AM – 9:00 PM	View Photos (4)
ChIJU9HcRdoqv1QR9T3csxUwSec	E BarGrill	314 SW 5th St, Redmond, OR 97756, USA	44.2742760	-121.1729530	200 m		bars, bars,cocktails,nightlife,bars,cocktails,nightlife,pubs,brewery,desserts,restaurants,breakfast,lunch,dining,family friendly, bistros, breakfast, brewery, cocktails, desserts, dining, lunch, nightlife, pubs, restaurants	bar,establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 316-7050	View Hours Monday: 11:00 AM – 8:30 PM Tuesday: 11:00 AM – 8:30 PM Wednesday: 11:00 AM – 8:30 PM Thursday: 11:00 AM – 8:30 PM Friday: 11:00 AM – 9:00 PM Saturday: 9:00 AM – 9:00 PM Sunday: 9:00 AM – 8:30 PM	View Photos (4)
ChIJVUSFaMLVuFQRD_G8HvGiEXY	Avalon Aeropub	Redmond Municipal Airport, 2522 Jesse Butler Cir, Redmond, OR 97756, USA	44.2530530	-121.1606580	2,419 m		bars, bars,cocktails,nightlife,bars,cocktails,nightlife,pubs,brewery,restaurants,breakfast,dining, brewery, cocktails, nightlife, pubs	bar,establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 516-6380	View Hours Monday: 5:30 AM – 7:30 PM Tuesday: 5:30 AM – 7:30 PM Wednesday: 5:30 AM – 7:30 PM Thursday: 5:30 AM – 7:30 PM Friday: 5:30 AM – 7:30 PM Saturday: 5:30 AM – 7:30 PM Sunday: 5:30 AM – 7:30 PM	View Photos (4)
ChIJzUapk9wqv1QRZ4BT-v_1j3I	Redmond Burger Company	249 NW 6th St, Redmond, OR 97756, USA	44.2780770	-121.1746090	609 m		bars, bars,nightlife,bars,nightlife,pubs,brewery,restaurants,lunch,dining,family friendly, brewery, food trucks, lunch, pubs, restaurants	bar,establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 316-5262	View Hours Monday: 11:00 AM – 9:00 PM Tuesday: 11:00 AM – 9:00 PM Wednesday: 11:00 AM – 9:00 PM Thursday: 11:00 AM – 9:00 PM Friday: 11:00 AM – 9:00 PM Saturday: 11:00 AM – 9:00 PM Sunday: 11:00 AM – 9:00 PM	View Photos (4)
ChIJ69QfC5Esv1QRAQmDauRRwOU	Silverleaf Café	Eagle Crest Resort, 7535 Falcon Crest Dr #300, Redmond, OR 97756, USA	44.2626950	-121.2624850	7,138 m		breakfast	bar,establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 548-7558	View Hours Monday: 8:00 AM – 9:00 PM Tuesday: 8:00 AM – 9:00 PM Wednesday: 8:00 AM – 9:00 PM Thursday: 8:00 AM – 9:00 PM Friday: 8:00 AM – 9:00 PM Saturday: 8:00 AM – 9:00 PM Sunday: 8:00 AM – 9:00 PM	View Photos (4)
ChIJOeKoO2Erv1QR_T4nSgC4ByQ	bacon Bar N Brunch	614 NW Cedar Ave, Redmond, OR 97756, USA	44.2781350	-121.1748600	618 m		bars,cocktails,nightlife,bars,cocktails,nightlife,pubs,restaurants,breakfast,lunch,dining,family friendly	bar,establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 633-3550	View Hours Monday: Closed Tuesday: 7:00 AM – 2:00 PM Wednesday: 7:00 AM – 2:00 PM Thursday: 7:00 AM – 2:00 PM Friday: 7:00 AM – 2:00 PM Saturday: 7:00 AM – 2:00 PM Sunday: 7:00 AM – 2:00 PM	View Photos (4)
ChIJoQqCnRLWvlQRfmshx3JloYU	Pump House Bar & Grill	8320 US-97, Terrebonne, OR 97760, USA	44.3518410	-121.1783370	8,816 m		restaurants	bar,establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(458) 287-4393	View Hours Monday: 11:00 AM – 9:00 PM Tuesday: 11:00 AM – 9:00 PM Wednesday: 11:00 AM – 9:00 PM Thursday: 11:00 AM – 9:00 PM Friday: 11:00 AM – 10:00 PM Saturday: 11:00 AM – 10:00 PM Sunday: 11:00 AM – 8:00 PM	View Photos (4)
ChIJHeJHmNcqv1QREMV8kKzY2yE	American Legion Post 44	704 SW 8th St, Redmond, OR 97756, USA	44.2704380	-121.1760810	297 m		bars, live music,nightlife,live music, nightlife, pubs	bar,establishment,food,point_of_interest,restaurant,store	Page \| Maps \| Website	(541) 548-5688	View Hours Monday: 2:00 – 8:00 PM Tuesday: 2:00 – 8:00 PM Wednesday: 2:00 – 8:00 PM Thursday: 2:00 – 8:00 PM Friday: 2:00 PM – 12:00 AM Saturday: 2:00 – 8:00 PM Sunday: Closed	View Photos (4)
ChIJgR1QaCgrv1QRj4Af08YkfXE	Bunker Bar	704 SW 8th St, Redmond, OR 97756, USA	44.2704570	-121.1761880	301 m		bars, bars,cocktails,nightlife,pool tables,bars,cocktails,nightlife,pool tables,pubs, cocktails, live music, nightlife, pool tables, pubs	bar,establishment,point_of_interest	Page \| Maps	(541) 548-5688	View Hours Monday: 2:00 – 8:00 PM Tuesday: 2:00 – 8:00 PM Wednesday: 2:00 – 8:00 PM Thursday: 2:00 – 8:00 PM Friday: 2:00 – 8:00 PM Saturday: 2:00 – 8:00 PM Sunday: Closed	View Photos (4)