Data

Debug Info (admin only)

Search Criteria:

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

Pagination:

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

Results:

Total Available Records: 705
Total After Limits: 705
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.name, p.name) ASC LIMIT 25, 25

Previous Next

Page 2 of 29

Showing 26 to 50 of 705 results

Place ID	Name	Address	Latitude	Longitude	Distance	Category	Search Term	Types	Links	Phone	Hours	Photos
ChIJD0UXA9Irv1QRUK7SsGtis_U	Arome	432 SW 6th St, Redmond, OR 97756, USA	44.2730890	-121.1740260	53 m		grocery stores, grocery stores,live music,grocery stores, live music	establishment,food,furniture_store,grocery_or_supermarket,home_goods_store,point_of_interest,store	Page \| Maps \| Website	(541) 527-4727	View Hours Monday: 10:00 AM – 5:00 PM Tuesday: 10:00 AM – 5:00 PM Wednesday: 10:00 AM – 6:00 PM Thursday: 10:00 AM – 6:00 PM Friday: 10:00 AM – 6:00 PM Saturday: 10:00 AM – 6:00 PM Sunday: 10:00 AM – 5:00 PM	View Photos (4)
ChIJxc72pugrv1QRkz_TL0pGE4U	Art & Music	232 SW 5th St, Redmond, OR 97756, USA	44.2749500	-121.1729040	271 m		live music	art_gallery,establishment,point_of_interest,store	Page \| Maps \| Website	(541) 527-4426	View Hours Monday: 11:00 AM – 5:00 PM Tuesday: 11:00 AM – 6:00 PM Wednesday: 11:00 AM – 6:00 PM Thursday: 11:00 AM – 6:00 PM Friday: 11:00 AM – 6:00 PM Saturday: 12:00 – 4:00 PM Sunday: 12:00 – 4:00 PM	View Photos (4)
ChIJM3fGqw3WvlQRTjDZ-7C6evE	ArtzWear	8080 NW 11th St, Terrebonne, OR 97760, USA	44.3498210	-121.1775350	8,589 m		boutiques, vintage	clothing_store,establishment,point_of_interest,store	Page \| Maps \| Website	(541) 420-0687	View Hours Monday: 8:00 AM – 5:00 PM Tuesday: 8:00 AM – 5:00 PM Wednesday: 8:00 AM – 5:00 PM Thursday: 8:00 AM – 5:00 PM Friday: 8:00 AM – 5:00 PM Saturday: Closed Sunday: Closed	No photos available
ChIJF5aY71vXvlQREFMtragTlMk	Asterisk Observatory @ The Spot	10136 NE Crooked River Dr, Terrebonne, OR 97760, USA	44.3680890	-121.1327250	11,110 m		tourist attraction	establishment,point_of_interest,tourist_attraction	Page \| Maps \| Website			View Photos (4)
ChIJA79NDP8rv1QRF0PEgshqtyg	Atomic Bazaar Vintage	617 SW Cascade Ave, Redmond, OR 97756, USA	44.2746450	-121.1747330	234 m		antiques, antiques,boutiques,shopping,thrift stores,vintage,antiques,boutiques,shopping,thrift stores,vintage, boutiques, shopping, thrift stores, vintage	clothing_store,establishment,point_of_interest,store	Page \| Maps	(541) 350-6392	View Hours Monday: Closed Tuesday: Closed Wednesday: 11:00 AM – 5:00 PM Thursday: 11:00 AM – 5:00 PM Friday: 11:00 AM – 5:00 PM Saturday: 11:00 AM – 5:00 PM Sunday: 12:00 – 4:00 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,bars,cocktails,nightlife,pubs,brewery,restaurants,breakfast,dining, breakfast, brewery, cocktails, dining, nightlife, pubs, restaurants	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)
ChIJBW5NWdjUuFQRIfLf2XPNhHA	Avis Car Rental	2522 Jesse Butler Cir Ste 6, Redmond, OR 97756, USA	44.2530800	-121.1611220	2,400 m		car rentals	car_rental,establishment,point_of_interest	Page \| Maps \| Website	(541) 923-3750	View Hours Monday: 8:30 AM – 12:30 AM Tuesday: 8:30 AM – 12:30 AM Wednesday: 8:30 AM – 12:30 AM Thursday: 8:30 AM – 12:30 AM Friday: 8:30 AM – 12:30 AM Saturday: 9:00 AM – 12:30 AM Sunday: 9:00 AM – 12:30 AM	View Photos (4)
ChIJK-VafP8rv1QRZU9F_9vl56E	Axel’s Taco Shop (Redmond)	lunch (edited)	44.2823160	-121.1749250	1,081 m	resorts (edited)	restaurants (edited)	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	dining (edited)	View Hours Monday: 7:00 AM – 12:00 AM Tuesday: 7:00 AM – 12:00 AM Wednesday: 7:00 AM – 12:00 AM Thursday: 7:00 AM – 12:00 AM Friday: 7:00 AM – 12:00 AM Saturday: 7:00 AM – 12:00 AM Sunday: 7:00 AM – 12:00 AM	View Photos (4)
ChIJy1RrCtcqv1QRJcCTGwZQXzI	Aziz Crew Barber Shop	2498 S Hwy 97 Suit C, Redmond, OR 97756, USA	44.2525650	-121.1830280	2,345 m		pool tables	establishment,hair_care,health,point_of_interest	Page \| Maps \| Website	(541) 668-3397	View Hours Monday: Closed Tuesday: 10:00 AM – 6:00 PM Wednesday: 10:00 AM – 6:00 PM Thursday: 10:00 AM – 6:00 PM Friday: 10:00 AM – 6:00 PM Saturday: 10:00 AM – 2:00 PM Sunday: Closed	View Photos (4)
ChIJe9h8f7TTuFQRdwNgWbe5Drg	Backporch Coffee Roasters – Redmond	3750 SW Badger Ave Ste 101, Redmond, OR 97756, USA	44.2370620	-121.2126000	5,012 m		coffee shops	cafe,establishment,food,point_of_interest,store	Page \| Maps \| Website	(541) 923-4347	View Hours Monday: 6:30 AM – 4:30 PM Tuesday: 6:30 AM – 4:30 PM Wednesday: 6:30 AM – 4:30 PM Thursday: 6:30 AM – 4:30 PM Friday: 6:30 AM – 4:30 PM Saturday: 7:00 AM – 4:00 PM Sunday: 7:00 AM – 4: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, bars,cocktails,nightlife,bars,cocktails,nightlife,pubs,restaurants,breakfast,lunch,dining,family friendly,bars,cocktails,pubs, breakfast, cocktails, dining, family friendly, lunch, nightlife, pubs, restaurants	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)
ChIJidDc-KDNuFQRjFBfQ2m0cKw	Bai Tong by Noi Thai	404 SW Forest Ave, Redmond, OR 97756, USA	44.2714000	-121.1723500	185 m		food trucks	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 666-9586	View Hours Monday: 11:00 AM – 9:00 PM Tuesday: 11:00 AM – 8: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)
ChIJVVVViC0rv1QRSrPAl2UQBr4	Baker Park	1546 SW 17th St, Redmond, OR 97756, USA	44.2617490	-121.1858510	1,537 m		parks, parks,playgrounds,parks,playgrounds, playgrounds	establishment,park,point_of_interest	Page \| Maps \| Website			View Photos (4)
ChIJs5X2uikrv1QRncpUC6aIPOE	Baldy’s BBQ	343 NW 6th St, Redmond, OR 97756, USA	44.2790850	-121.1745430	721 m		cocktails, cocktails,restaurants,lunch,dining,family friendly,restaurants,lunch,family friendly, dining, family friendly, lunch, restaurants, smokehouses	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 923-2271	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 – 9:00 PM Saturday: 11:00 AM – 9:00 PM Sunday: 11:00 AM – 8:00 PM	View Photos (4)
ChIJ68FRitQqv1QRw3fS5wfIY3Y	Bar Seven A Co Inc	1060 SE Lake Rd, Redmond, OR 97756, USA	44.2662700	-121.1680300	848 m		bars	establishment,general_contractor,point_of_interest	Page \| Maps \| Website	(541) 548-4747		No photos available
ChIJpQL9-8wrv1QR03VhIhjT12w	Bar-B’s	1116 SW Obsidian Ave, Redmond, OR 97756, USA	44.2619640	-121.1799720	1,279 m		bars,nightlife	bar,establishment,point_of_interest	Page \| Maps	(503) 409-5456		View Photos (2)
ChIJWxf_mwgzuVQRL8IUb7lq_UU	Barnes Butte Reservoir	Barnes Butte Reservoir, Oregon 97754, USA	44.3298420	-120.8248990	28,495 m		mountain biking	establishment,natural_feature	Page \| Maps			View Photos (4)
ChIJK0TVZiwsv1QR5t7zTqPuonc	Barr Road North OHV Staging Area	Barr Rd, Redmond, OR 97756, USA	44.2884330	-121.3337910	12,848 m	outdoors	point of interest	establishment,point_of_interest	Page \| Maps \| Website	(541) 416-6700		View Photos (4)
ChIJBSuElSbGuFQRWAFqyTcfSC4	Be-Bop Biscotti	1950 SW Badger Ave Ste 105, Redmond, OR 97756, USA	44.2379950	-121.1898010	4,053 m		bakeries	establishment,food,point_of_interest	Page \| Maps \| Website	(888) 545-7487		View Photos (4)
ChIJlSbzFbrIuFQRhcfNAXGbfx0	Bear Prints Brand Lab	688 SW Veterans Way, Redmond, OR 97756, USA	44.2605030	-121.1765290	1,363 m		shopping	clothing_store,establishment,point_of_interest,store	Page \| Maps \| Website	(541) 388-1274	View Hours Monday: 8:00 AM – 5:00 PM Tuesday: 8:00 AM – 5:00 PM Wednesday: 8:00 AM – 5:00 PM Thursday: 8:00 AM – 5:00 PM Friday: 8:00 AM – 5:00 PM Saturday: Closed Sunday: Closed	View Photos (4)
ChIJsyV-A43HvCARZqC5cXkL25E	Bear’s Delights	122 SW 5th St, Redmond, OR 97756, USA	44.2760920	-121.1729770	393 m		breakfast, desserts, dining, family friendly, food trucks, food trucks,restaurants,breakfast,lunch,dining,family friendly,food trucks,restaurants,breakfast,lunch,dining,family friendly, lunch, restaurants	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 420-5097	View Hours Monday: Closed Tuesday: 11:30 AM – 8:00 PM Wednesday: Closed Thursday: 9:00 AM – 8:00 PM Friday: 11:30 AM – 8:00 PM Saturday: 11:30 AM – 8:00 PM Sunday: 9:00 AM – 8:00 PM	View Photos (4)
ChIJLyRQDxIrv1QRzQ0EFaqPHcE	Beautique Of Redmond	342 SW 7th St, Redmond, OR 97756, USA	44.2738770	-121.1751470	170 m		boutiques	establishment,hair_care,point_of_interest	Page \| Maps \| Website	(541) 749-0485	View Hours Monday: 9:00 AM – 6:00 PM Tuesday: 9:00 AM – 6:00 PM Wednesday: 9:00 AM – 6:00 PM Thursday: 9:00 AM – 6:00 PM Friday: 9:00 AM – 6:00 PM Saturday: 10:00 AM – 3:00 PM Sunday: Closed	View Photos (4)
ChIJU3hgOHgrv1QRYUVKa1b4bCo	Becerra’s on 6th Bistro	646 SW 6th St, Redmond, OR 97756, USA	44.2709120	-121.1739650	190 m		bistros, desserts	establishment,food,point_of_interest,restaurant	Page \| Maps	(541) 527-4336		View Photos (4)
ChIJraK7Q0Arv1QR3NI0tMHyIFM	Becky Jeanne’s	2556 SW Reindeer Ave, Redmond, OR 97756, USA	44.2563070	-121.1973270	2,601 m		bakeries	bakery,establishment,food,point_of_interest,store	Page \| Maps	(541) 848-7305	View Hours Monday: Closed Tuesday: Closed Wednesday: Closed Thursday: Closed Friday: Closed Saturday: 9:30 AM – 4:00 PM Sunday: 12:00 – 4:00 PM	View Photos (4)
ChIJcRNAVB0rv1QRhfossmTp5WI	Believe In Bodywork	716 SW 11th St, Redmond, OR 97756, USA	44.2703030	-121.1793770	505 m		massage	establishment,point_of_interest	Page \| Maps	(541) 948-7090	View Hours Monday: 8:00 AM – 2:30 PM Tuesday: 8:00 AM – 5:00 PM Wednesday: 8:00 AM – 2:30 PM Thursday: 8:00 AM – 5:00 PM Friday: 8:00 AM – 2:00 PM Saturday: Closed Sunday: Closed	View Photos (3)