Data

Debug Info (admin only)

Search Criteria:

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

Pagination:

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

Results:

Total Available Records: 583
Total After Limits: 583
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 1=1 ORDER BY COALESCE(e.name, p.name) ASC LIMIT 25, 25

Previous Next

Page 2 of 24

Showing 26 to 50 of 583 results

Place ID	Name	Address	Latitude	Longitude	Distance	Category	Search Term	Types	Links	Phone	Hours	Photos
ChIJM3fGqw3WvlQRTjDZ-7C6evE	ArtzWear	8080 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, shopping, thrift stores, vintage	clothing_store,establishment,point_of_interest,store	Page \| Maps	(541) 350-6392	View Hours Monday: Closed Tuesday: Closed Wednesday: Closed Thursday: Closed 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, 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: 6:00 AM – 11:30 PM Tuesday: 6:00 AM – 11:30 PM Wednesday: 6:00 AM – 11:30 PM Thursday: 6:00 AM – 11:30 PM Friday: 6:00 AM – 2:00 AM Saturday: 6:00 AM – 2:00 AM Sunday: 6:00 AM – 11:30 PM	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	3750 SW Badger Ave Suite 101, Redmond, OR 97756, USA	44.2370650	-121.2124080	5,003 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)
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)
ChIJs5X2uikrv1QRncpUC6aIPOE	Baldy’s BBQ	343 NW 6th St, Redmond, OR 97756, USA	44.2790850	-121.1745430	721 m		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)
ChIJ79Inuosrv1QRgVCck7bm4cI	Bangers & Brews – Redmond, OR	lunch (edited)	44.2690550	-121.1756600	420 m	restaurants,beer-wine-spirits (edited)	restaurants (edited)	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	dining (edited)	View Hours Monday: 11:00 AM – 8:00 PM Tuesday: Closed Wednesday: Closed 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 – 7: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	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 420-5097	View Hours Monday: 11:30 AM – 7:30 PM Tuesday: 11:30 AM – 7:30 PM Wednesday: Closed Thursday: 9:00 AM – 7:30 PM Friday: 11:30 AM – 7:30 PM Saturday: 11:30 AM – 7:30 PM Sunday: 9:00 AM – 7:30 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)
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)
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)
ChIJyR2EdNoqv1QRRsZZ3yPCE4s	Beyond the Ranch Antiques	339 SW Evergreen Ave, Redmond, OR 97756, USA	44.2727870	-121.1718870	163 m		antiques, gift shops, shopping, thrift stores, vintage	clothing_store,establishment,home_goods_store,point_of_interest,shoe_store,store	Page \| Maps	(541) 279-4867	View Hours Monday: 10:00 AM – 5:00 PM Tuesday: 10:00 AM – 5:00 PM Wednesday: 10:00 AM – 5:00 PM Thursday: 10:00 AM – 5:00 PM Friday: 10:00 AM – 5:00 PM Saturday: 10:00 AM – 5:00 PM Sunday: 12:00 – 5:00 PM	View Photos (4)
ChIJVSo4LG4rv1QR8I1wB8iXxMI	Beyond The Vine	427 SW 8th St, Redmond, OR 97756, USA	44.2730720	-121.1766230	221 m		bars, 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)
ChIJvw5ge8nUuFQRK2xAcTM3MhI	Bi-Mart Membership Discount Stores	1727 SW Odem Medo Rd, Redmond, OR 97756, USA	44.2527750	-121.1874590	2,456 m		grocery stores, shopping	establishment,point_of_interest,store	Page \| Maps \| Website	(541) 923-7220	View Hours Monday: 9:00 AM – 8:00 PM Tuesday: 9:00 AM – 8:00 PM Wednesday: 9:00 AM – 8:00 PM Thursday: 9:00 AM – 8:00 PM Friday: 9:00 AM – 8:00 PM Saturday: 9:00 AM – 6:00 PM Sunday: 9:00 AM – 6:00 PM	View Photos (4)