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: 1
Limit per Page: 25
Offset: 0
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 0, 25

Page 1 of 26

Showing 1 to 25 of 645 results

Place ID	Name	Address	Latitude	Longitude	Distance	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)
ChIJ50h8Hdoqv1QRcz-tvXRNCf0	2Hearts Flower Shop	307 NW 7th St Suite B, Redmond, OR 97756, USA	44.2785190	-121.1756190	670 m	gift shops	bakery,establishment,florist,food,point_of_interest,store	Page \| Maps \| Website	(541) 280-1298	View Hours Monday: 10:00 AM – 4:00 PM Tuesday: 10:00 AM – 4:00 PM Wednesday: 10:00 AM – 4:00 PM Thursday: 10:00 AM – 4:00 PM Friday: 10:00 AM – 4:00 PM Saturday: 10:00 AM – 4:00 PM Sunday: Closed	View Photos (4)
ChIJkXIY8Uorv1QRGG_JvMHB9Ro	3 Peaks Coffee	722 NW 6th St, Redmond, OR 97756, USA	44.2823100	-121.1734580	1,078 m	coffee shops	establishment,point_of_interest	Page \| Maps		View Hours Monday: 6:00 AM – 2:00 PM Tuesday: 6:00 AM – 2:00 PM Wednesday: 6:00 AM – 2:00 PM Thursday: 6:00 AM – 2:00 PM Friday: 6:00 AM – 2:00 PM Saturday: 6:00 AM – 2:00 PM Sunday: 8:00 AM – 1:00 PM	View Photos (3)
ChIJw0TM0twqv1QRYu3Kve2oe4M	5 Below Steakhouse and Breakfast Nook	325 NW 5th St, Redmond, OR 97756, USA	44.2788570	-121.1735210	694 m	bars, bars,cocktails,bars,cocktails,desserts,restaurants,breakfast,lunch,dining,family friendly, breakfast, cocktails, coffee shops, desserts, lunch, restaurants	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 527-1375	View Hours Monday: 7:00 AM – 9:00 PM Tuesday: 7:00 AM – 9:00 PM Wednesday: 7:00 AM – 9:00 PM Thursday: 7:00 AM – 9:00 PM Friday: 7:00 AM – 9:00 PM Saturday: 7:00 AM – 9:00 PM Sunday: 7:00 AM – 9:00 PM	View Photos (4)
ChIJaxh4FKQrv1QRjG-sXSSIRtQ	7 Peaks Candle Co.	106 SE Evergreen Ave Ste i, Redmond, OR 97756, USA	44.2720410	-121.1680790	470 m	gift shops	establishment,home_goods_store,point_of_interest,store	Page \| Maps \| Website	(541) 912-3034	View Hours Monday: Closed Tuesday: Closed Wednesday: Closed Thursday: 9:00 AM – 5:00 PM Friday: 9:00 AM – 5:00 PM Saturday: Closed Sunday: 9:00 AM – 5:00 PM	View Photos (4)
ChIJQSLYC5zVuFQRX-2YIBfSeaw	A-Time-4-U Massage and Spa Therapy	2963 SW Volcano Cir, Redmond, OR 97756, USA	44.2484680	-121.2031920	3,556 m	massage, wellness center	establishment,health,point_of_interest,spa	Page \| Maps \| Website	(541) 504-7108	View Hours Monday: Closed Tuesday: 10:00 AM – 7:00 PM Wednesday: 10:00 AM – 7:00 PM Thursday: 10:00 AM – 7:00 PM Friday: 10:00 AM – 7:00 PM Saturday: 10:00 AM – 7:00 PM Sunday: Closed	View Photos (3)
ChIJg5s4i9LUuFQRc3g8jrCTQoo	Abby’s Legendary Pizza	1938 The Dalles-California Hwy, S Hwy 97, Redmond, OR 97756, USA	44.2581450	-121.1795990	1,672 m	bars, bars,pubs, dining, lunch, pubs	establishment,food,meal_delivery,meal_takeaway,point_of_interest,restaurant	Page \| Maps \| Website	(541) 548-5266	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)
ChIJl8HluHIrv1QRq9QPRmUbiDY	Active Water Sports – Boat Dealership	1598 S Hwy 97, Redmond, OR 97756, USA	44.2608570	-121.1777610	1,343 m	fishing	establishment,point_of_interest,storage,store	Page \| Maps \| Website	(503) 342-7709	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: 9:00 AM – 2:00 PM Sunday: Closed	View Photos (4)
ChIJqbek850rv1QRSieISE9jfCs	Adree Thompson Massage	716 SW 11th St, Redmond, OR 97756, USA	44.2702900	-121.1793730	506 m	massage	establishment,point_of_interest	Page \| Maps \| Website	(541) 325-2513		View Photos (4)
ChIJ31jIkZItv1QR9nMR5Q-6yTI	Aerie Cafe	1522 Cline Falls Rd, Redmond, OR 97756, USA	44.2597390	-121.2627970	7,220 m	breakfast, dining	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 504-3870	View Hours Monday: 7:00 – 10:30 AM Tuesday: 7:00 – 10:30 AM Wednesday: 7:00 – 10:30 AM Thursday: 7:00 – 10:30 AM Friday: 7:00 – 10:30 AM Saturday: 7:00 – 10:30 AM Sunday: 7:00 – 10:30 AM	View Photos (4)
ChIJsYpb_ssrv1QRsqIW79vbHSk	Aiwa Asian Restaurant	150 NW 5th St, Redmond, OR 97756, USA	44.2772060	-121.1730960	514 m	lunch, restaurants	establishment,food,meal_takeaway,point_of_interest,restaurant	Page \| Maps \| Website	(541) 527-1380	View Hours Monday: 11:00 AM – 9:00 PM Tuesday: Closed Wednesday: 11:00 AM – 9:00 PM Thursday: 11:00 AM – 9:00 PM Friday: 11:00 AM – 9:30 PM Saturday: 11:00 AM – 9:30 PM Sunday: 11:00 AM – 9:00 PM	View Photos (4)
ChIJi6ZBhybVuFQRNVz5F5EN1VE	Alamo Rent A Car	2522 Jesse Butler Cir, Redmond, OR 97756, USA	44.2530300	-121.1606490	2,421 m	car rentals	car_rental,establishment,point_of_interest	Page \| Maps \| Website	(844) 370-7398	View Hours Monday: 8:00 AM – 12:30 AM Tuesday: 8:00 AM – 12:30 AM Wednesday: 8:00 AM – 12:30 AM Thursday: 8:00 AM – 12:30 AM Friday: 8:00 AM – 12:30 AM Saturday: 8:00 AM – 12:30 AM Sunday: 8:00 AM – 12:30 AM	View Photos (4)
ChIJ-WEQJKfVuFQR7aUmMSzyg0U	Alaska Airlines – Redmond	2522 Jesse Butler Cir, Redmond, OR 97756, USA	44.2530250	-121.1608350	2,415 m	airports	airport,establishment,point_of_interest	Page \| Maps \| Website	(800) 225-2752		View Photos (4)
ChIJSxInVMsnv1QRQeWs3XKUMNY	Alder Springs Trailhead	CROOKED RIVER, OR 97760, USA	44.4332760	-121.3577690	23,083 m	hiking, hiking,trailheads	establishment,point_of_interest	Page \| Maps \| Website			View Photos (4)
ChIJ5ebHESgrv1QR2xV7RW0YdQM	All About You/Redmond Engraving	725 NW Kingwood Ave, Redmond, OR 97756, USA	44.2875910	-121.1758360	1,672 m	gift shops	establishment,point_of_interest,store	Page \| Maps \| Website	(541) 923-1525	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: Closed Saturday: Closed Sunday: Closed	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)
ChIJ3WPj8pkrv1QRLTmYGaC5XTo	Amy Coville Massage, LMT	614 SW 12th St, Redmond, OR 97756, USA	44.2712730	-121.1804850	544 m	massage	establishment,point_of_interest	Page \| Maps \| Website	(541) 306-8007		View Photos (4)
ChIJjQX4oygrv1QRPwXQ5ZoVmAw	Anderson Julie	654 NW 4th St, Redmond, OR 97756, USA	44.2818720	-121.1718560	1,042 m	massage	establishment,point_of_interest	Page \| Maps	(541) 280-2535		No photos available
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)
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)
ChIJIQ-ybqbhwFQRpoam_WdpYBE	Aranda’s Massage Therapy & Myofascial Bodywork	2518 SW 33rd Ct, Redmond, OR 97756, USA	44.2511830	-121.2067410	3,537 m	massage	establishment,point_of_interest,spa	Page \| Maps \| Website	(541) 788-5732		View Photos (4)
ChIJqQkSc7Qrv1QRymh3Q4k7fhQ	Argelia’s kitchen	122 SW 5th St, Redmond, OR 97756, USA	44.2760870	-121.1729410	393 m	family friendly	establishment,food,point_of_interest,restaurant	Page \| Maps	(458) 315-0211	View Hours Monday: Closed Tuesday: 2:30 – 8:00 PM Wednesday: Closed Thursday: 2:30 – 8:00 PM Friday: 2:30 – 8:00 PM Saturday: 2:30 – 8:00 PM Sunday: 2:30 – 8:00 PM	View Photos (3)
ChIJD0UXA9Irv1QRUK7SsGtis_U	Arome	432 SW 6th St, Redmond, OR 97756, USA	44.2730890	-121.1740260	53 m	grocery stores	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