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

Page 1 of 24

Showing 1 to 25 of 583 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, 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)
ChIJ7yQIS9Qqv1QRUn8Lz5jV6gk	1100 SE Lake Rd	1100 SE Lake Rd, Redmond, OR 97756, USA	44.2670920	-121.1707110	666 m	outdoors (edited)	fishing (edited)	premise,street_address	Page \| Maps			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)
ChIJPb3noe4qv1QRIXAxCYdixhw	4 Wheel Mobil Home Court	1247 NW 6th St, Redmond, OR 97756, USA	44.2880420	-121.1742860	1,715 m		rv parks	establishment,lodging,point_of_interest,rv_park	Page \| Maps	(541) 548-5894		View Photos (4)
ChIJw0TM0twqv1QRYu3Kve2oe4M	5 Below Steakhouse and Breakfast Nook	325 NW 5th St, Redmond, OR 97756, USA	44.2788570	-121.1735210	694 m		bars, breakfast, cocktails, coffee shops, desserts, lunch, restaurants	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 923-2213	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)
ChIJ5RDgdCgrv1QR3zCJI-Ilb_o	7-Eleven	1209 SW Highland Ave, Redmond, OR 97756, USA	44.2698430	-121.1811940	656 m		coffee shops, desserts, grocery stores, juice bars	cafe,convenience_store,establishment,food,liquor_store,point_of_interest,restaurant,store	Page \| Maps \| Website	(541) 548-1381	View Hours Monday: Open 24 hours Tuesday: Open 24 hours Wednesday: Open 24 hours Thursday: Open 24 hours Friday: Open 24 hours Saturday: Open 24 hours Sunday: Open 24 hours	View Photos (4)
ChIJ-1q8LQArv1QRVMod9zsK488	A New Tropical	122 SW 5th St, Redmond, OR 97756, USA	44.2760920	-121.1729770	393 m		food trucks	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 647-9068	View Hours Monday: 11:00 AM – 3:00 PM, 4:00 – 8:00 PM Tuesday: 11:00 AM – 3:00 PM, 4:00 – 8:00 PM Wednesday: Closed Thursday: 11:00 AM – 3:00 PM, 4:00 – 8:00 PM Friday: 11:00 AM – 3:00 PM, 4:00 – 8:00 PM Saturday: 4:00 – 8:00 PM Sunday: 11:00 AM – 8: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, 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)
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	establishment,park,point_of_interest	Page \| Maps \| Website			View Photos (4)
ChIJw1Nd3C8rv1QRCY456FtXkhw	American Legion Park	850 SW Rimrock Way, Redmond, OR 97756, USA	44.2685900	-121.1911530	1,443 m		live music, parks	establishment,park,point_of_interest,tourist_attraction	Page \| Maps \| Website		View Hours Monday: Closed Tuesday: 9:00 AM – 9:00 PM Wednesday: 9:00 AM – 9:00 PM Thursday: 9:00 AM – 9:00 PM Friday: 9:00 AM – 9:00 PM Saturday: 9:00 AM – 9:00 PM 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, 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, cocktails, dining, food trucks, live music, nightlife, pool tables, pubs	bar,establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 699-1282	View Hours Monday: 4:00 – 10:00 PM Tuesday: 4:00 – 10:00 PM Wednesday: 4:00 – 10:00 PM Thursday: 4:00 – 10:00 PM Friday: 4:00 PM – 2:00 AM Saturday: 10:00 AM – 2:00 AM Sunday: 10:00 AM – 9:00 PM	View Photos (4)
ChIJx6U13IYrv1QR0c6oDv0MVwc	Antiques & Stuff Redmond Oregon	308 SE Franklin Ave, Redmond, OR 97756, USA	44.2743720	-121.1660550	656 m		antiques	establishment,point_of_interest	Page \| Maps	(541) 527-4723		No photos available
ChIJp17jgrzUuFQRmzMHKITf0ZU	Applebee’s Grill + Bar \| IHOP	3807 SW 21st St, Redmond, OR 97756, USA	44.2412720	-121.1921840	3,777 m		bars, 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	716 SW 11th St, Redmond, OR 97756, USA	44.2703250	-121.1793760	504 m		massage	establishment,point_of_interest,spa	Page \| Maps \| Website	(541) 788-5732		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)