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: 26

Results:

Total Available Records: 645
Total After Limits: 645
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 26

Showing 26 to 50 of 645 results

Place ID	Name	Address	Latitude	Longitude	Distance	Category	Search Term	Types	Links	Phone	Hours	Photos
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, 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, 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)
ChIJBW5NWdjUuFQRIfLf2XPNhHA	Avis Car Rental	2522 Jesse Butler Cir Suite 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,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)
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,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,restaurants,lunch,dining,family friendly, family friendly, 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)
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		desserts, food trucks, food trucks,restaurants,breakfast,lunch,dining,family friendly	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)
ChIJra09F1LSuFQRgIng1lBLZMY	Bell-Air Motel	8790 S Hwy 97, Redmond, OR 97756, USA	44.1952670	-121.2322210	9,775 m		hotels	establishment,lodging,point_of_interest	Page \| Maps	(541) 382-1885		View Photos (4)
ChIJUWaFWQ68uFQRePaKMIloVxQ	Benham West Trailhead	Sunriver, OR 97707, USA	43.9390140	-121.4139510	41,753 m		hiking,mountain biking,trailheads	establishment,park,point_of_interest,tourist_attraction	Page \| Maps \| Website	(541) 383-5300		View Photos (4)
ChIJeZsDYYwrv1QR1s7A444uJoQ	Bentley’s Coffee	1555 NW 6th St, Redmond, OR 97756, USA	44.2906330	-121.1744750	2,003 m		coffee shops	cafe,establishment,food,point_of_interest,store	Page \| Maps \| Website			View Photos (1)
ChIJT9sehGgrv1QRLT4Ia-lqDfA	Best Moments Bakery	332 SW 5th St, Redmond, OR 97756, USA	44.2740550	-121.1729230	178 m		bakeries, desserts	bakery,establishment,food,point_of_interest,store	Page \| Maps	(541) 977-6433		View Photos (4)
ChIJzdJ1BcnUuFQRVx4upj1ZXIE	Best Western Plus Rama Inn	2630 SW 17th Pl, Redmond, OR 97756, USA	44.2515600	-121.1859360	2,530 m		hotels, resorts	establishment,lodging,point_of_interest	Page \| Maps \| Website	(541) 548-8080		View Photos (4)