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: 23
Limit per Page: 25
Offset: 550
Total Pages: 27

Results:

Total Available Records: 659
Total After Limits: 659
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 550, 25

Previous Next

Page 23 of 27

Showing 551 to 575 of 659 results

Place ID	Name	Address	Latitude	Longitude	Distance	Category	Search Term	Types	Links	Phone	Hours	Photos
ChIJO-hUAJUrv1QRm6xAjtwZWXo	Starbucks	1830 NW 6th St, Redmond, OR 97756, USA	44.2935420	-121.1734730	2,327 m		breakfast, coffee shops	cafe,store,restaurant,food,point_of_interest,establishment	Maps	(689) 800-7044	View Hours Monday: 4:30 AM – 7:00 PM Tuesday: 4:30 AM – 7:00 PM Wednesday: 4:30 AM – 7:00 PM Thursday: 4:30 AM – 7:00 PM Friday: 4:30 AM – 7:00 PM Saturday: 5:00 AM – 7:00 PM Sunday: 5:00 AM – 7:00 PM	View Photos (4)
ChIJo91SskXSuFQRPh7s9eU3-8Q	Starbucks (edited)	1705 The Dalles-California Hwy, S Hwy 97, Redmond, OR 97756, USA (edited)	44.2608200	-121.1794240	1,383 m	coffee-treats (edited)	breakfast, coffee shops (edited)	cafe,food,point_of_interest,store,establishment (edited)	Maps \| Website (edited)	(541) 504-4160	View Hours Monday: 6:00 AM – 7:00 PM Tuesday: 6:00 AM – 7:00 PM Wednesday: 6:00 AM – 7:00 PM Thursday: 6:00 AM – 7:00 PM Friday: 6:00 AM – 7:00 PM Saturday: 6:00 AM – 7:00 PM Sunday: 6:00 AM – 7:00 PM	View Photos (2)
ChIJt2IOuSsrv1QRX1uuuvYxrCw	Starbucks	1400 SW Canal Blvd, Redmond, OR 97756, USA	44.2637730	-121.1780040	1,036 m		bars, breakfast, coffee shops	cafe,restaurant,food,point_of_interest,store,establishment	Maps \| Website	(541) 923-4188	View Hours Monday: 4:30 AM – 7:00 PM Tuesday: 4:30 AM – 7:00 PM Wednesday: 4:30 AM – 7:00 PM Thursday: 4:30 AM – 7:00 PM Friday: 4:30 AM – 7:00 PM Saturday: 5:00 AM – 6:30 PM Sunday: 5:00 AM – 6:30 PM	View Photos (4)
ChIJi_uRyIknv1QR0FuGWUeeQGY	Steelhead Falls	Deschutes River, Oregon, Terrebonne, OR 97760, USA	44.4164590	-121.2898970	18,463 m	outdoors	fishing, point-of-interest	park,point_of_interest,establishment	Maps		View Hours Monday: 6:00 AM – 10:00 PM Tuesday: 6:00 AM – 10:00 PM Wednesday: 6:00 AM – 10:00 PM Thursday: 6:00 AM – 10:00 PM Friday: 6:00 AM – 10:00 PM Saturday: 6:00 AM – 10:00 PM Sunday: 6:00 AM – 10:00 PM	View Photos (4)
ChIJ79s0CZ8muVQR5Dc2mXeiD8E	Stillwater Campground	Stillwater Campground Rd, Prineville, OR 97754, USA	44.1450790	-120.8292970	30,913 m		campgrounds	campground,park,lodging,point_of_interest,establishment	Maps \| Website	(541) 416-6700	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)
ChIJ36THt83UuFQRjTogxZuxZIk	Subway	2209 S Hwy 97, Redmond, OR 97756, USA	44.2557130	-121.1823430	1,996 m		lunch	meal_takeaway,restaurant,food,point_of_interest,establishment	Maps \| Website	(541) 923-5814	View Hours Monday: 8:00 AM – 1:00 AM Tuesday: 8:00 AM – 1:00 AM Wednesday: 8:00 AM – 1:00 AM Thursday: 8:00 AM – 1:00 AM Friday: 8:00 AM – 1:00 AM Saturday: 8:00 AM – 1:00 AM Sunday: 8:00 AM – 1:00 AM	View Photos (4)
ChIJ89MmB_Itv1QRnjL8htvqMWU	Summit Crest Neighborhood Park	4892 SW Volcano Ave, Redmond, OR 97756, USA	44.2480920	-121.2262990	4,984 m		parks	park,point_of_interest,establishment	Maps \| Website		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	No photos available
ChIJKR4OuSrXvlQR0fsZ1xzjlnI	Sungrounded Farm	211 NE Wilcox Ave, Terrebonne, OR 97760, USA	44.3568580	-121.1663450	9,386 m		farms	point_of_interest,establishment	Maps \| Website	(970) 409-8331		View Photos (4)
ChIJcW-Sam0rv1QR9ECnVg5Zqlo	Sunshine Wellness	1060 SE Lake Rd, Redmond, OR 97756, USA	44.2663330	-121.1681220	838 m		wellness center	spa,health,point_of_interest,establishment	Maps	(541) 678-2826		No photos available
ChIJZwSilLvUuFQRrJpyclLAueA	Super 8 by Wyndham Redmond (edited)	3629 SW 21st Pl, Redmond, OR 97756, USA (edited)	44.2427590	-121.1914310	3,601 m	hotels-motels,rv-parks-camping (edited)	hotels,motels (edited)	lodging,point_of_interest,establishment (edited)	Maps \| Website (edited)	(541) 548-8881	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)
ChIJo3Pt7_IVv1QRGvAy6B6lC78	Suttle Lake	Suttle Lake, Oregon 97759, USA	44.4250720	-121.7329210	47,572 m	outdoors	hiking, point-of-interest	natural_feature,establishment	Maps			View Photos (4)
ChIJH87OW_ndvlQRFwvcFQzhXG8	SW Jordan Bridge (edited)	SW Jordan Rd, Terrebonne, OR 97760, USA (edited)	44.5288570	-121.2646800	29,390 m		point of interest (edited)	tourist_attraction,point_of_interest,establishment (edited)	Maps		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)
ChIJyW-9FdQrv1QRPNBLen7kSc4	Swan Song Vintage	627 SW Deschutes Ave, Redmond, OR 97756, USA	44.2737210	-121.1749090	145 m		thrift stores, vintage	clothing_store,store,point_of_interest,establishment	Maps \| Website	(541) 527-4645	View Hours Monday: Closed Tuesday: Closed Wednesday: 11:00 AM – 6:00 PM Thursday: 11:00 AM – 6:00 PM Friday: 11:00 AM – 6:00 PM Saturday: 11:00 AM – 6:00 PM Sunday: 11:00 AM – 4:00 PM	View Photos (4)
ChIJw3eUFgIrv1QR1Im-STuPNPk	Sweet and Salty Shoppe	738 SW Highland Ave, Redmond, OR 97756, USA	44.2694640	-121.1762380	397 m		bakeries, desserts	bakery,store,point_of_interest,food,establishment	Maps	(541) 604-1062		View Photos (4)
ChIJVV7i9Nkqv1QRyWHlBp2qjGU	Sweet Oasis Chocolate Shop (edited)	535 SW 6th St, Redmond, OR 97756, USA (edited)	44.2720370	-121.1746250	86 m		desserts, shopping, gift shops (edited)	store,food,point_of_interest,establishment,shopping (edited)	Maps	(541) 408-0821	View Hours Monday: Closed 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 – 8:00 PM Saturday: 11:00 AM – 8:00 PM Sunday: Closed	No photos available
ChIJvywcSRErv1QRSSNO5F2LZAc	Tacos El Poblanito	404 SW Forest Ave, Redmond, OR 97756, USA	44.2713590	-121.1724040	185 m		breakfast, dining, family friendly, food trucks, lunch, restaurants	restaurant,food,point_of_interest,establishment	Maps	(541) 279-3145	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 – 9:00 PM Saturday: 11:00 AM – 9:00 PM Sunday: 11:00 AM – 9:00 PM	View Photos (4)
ChIJebCqymldv1QR2ivpC1qxzWI	Tamolitch Falls (Blue Pool)	National Forest Road 2672-655, McKenzie Bridge, OR 97413, USA	44.3120370	-122.0270490	68,043 m	outdoors	point-of-interest	park,tourist_attraction,point_of_interest,establishment	Maps \| Website	(541) 822-3381	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)
ChIJFVsg_lMrv1QR8B_EHbOFCk4	Teresa Variel LMT	307 NW 7th St, Redmond, OR 97756, USA	44.2785480	-121.1756540	673 m		massage	point_of_interest,establishment	Maps \| Website	(541) 598-5832	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: Closed	No photos available
ChIJWVC5uZErv1QRNibUxGNe-Nk	Terra Kitchen	509 SW 6th St, Redmond, OR 97756, USA	44.2723800	-121.1744230	48 m		cocktails, dining, restaurants	restaurant,food,point_of_interest,establishment	Maps \| Website	(541) 348-8101	View Hours Monday: Closed Tuesday: 4:00 – 8:00 PM Wednesday: 4:00 – 8:00 PM Thursday: 4:00 – 8:00 PM Friday: 4:00 – 8:30 PM Saturday: 4:00 – 8:30 PM Sunday: Closed	View Photos (4)
ChIJESyGgSUrv1QR4Mi5-iXwbUs	Testimony Wine Bar (edited)	307 NW 6th St, Redmond, OR 97756, USA (edited)	44.2784660	-121.1746190	652 m		bars, cocktails, live music, pubs, wine bars, winery (edited)	bar,food,point_of_interest,establishment (edited)	Maps \| Website (edited)	(541) 526-7979	View Hours Monday: 2:00 – 8:00 PM Tuesday: Closed Wednesday: 2:00 – 8:00 PM Thursday: 2:00 – 8:00 PM Friday: 1:00 – 9:00 PM Saturday: 1:00 – 9:00 PM Sunday: 1:00 – 6:00 PM	View Photos (4)
ChIJ-SilCtIrv1QRzRlihM1EB-g	Tetherow Crossing Park (edited)	5810 NW Tetherow Rd, Redmond, OR 97756 (edited)	44.3134750	-121.2382420	6,844 m	recreation (edited)	outdoors, point of interest, recreation (edited)	point_of_interest,recreation (edited)	Maps			No photos available
ChIJ_9vJoykrv1QRrLT-3CM76So	Thai O Restaurant	974 SW Veterans Way, Redmond, OR 97756, USA	44.2668320	-121.1789070	756 m		dining, lunch, restaurants	restaurant,point_of_interest,food,establishment	Maps \| Website	(541) 548-4883	View Hours Monday: 11:00 AM – 3:00 PM, 4:30 – 8:00 PM Tuesday: 11:00 AM – 3:00 PM, 4:30 – 8:00 PM Wednesday: 11:00 AM – 3:00 PM, 4:30 – 8:00 PM Thursday: 11:00 AM – 3:00 PM, 4:30 – 8:00 PM Friday: 11:00 AM – 3:00 PM, 4:30 – 8:00 PM Saturday: 4:30 – 8:00 PM Sunday: Closed	View Photos (4)
ChIJQ8vqdVYrv1QRAvp0OzqM-j0	That Guy’s Bistro	308 SW Evergreen Ave, Redmond, OR 97756, USA	44.2723530	-121.1716650	182 m		bistros, food trucks, lunch, restaurants	restaurant,food,point_of_interest,establishment	Maps \| Website	(541) 521-9170	View Hours Monday: 11:30 AM – 8:00 PM Tuesday: Closed Wednesday: 11:30 AM – 8:00 PM Thursday: 11:30 AM – 8:00 PM Friday: 11:30 AM – 8:00 PM Saturday: 11:30 AM – 8:00 PM Sunday: 11:30 AM – 8:00 PM	View Photos (4)
ChIJU7q3vtgqv1QRx0NS-JiVQKk	The Back Porch and Company	2127 S Hwy 97, Redmond, OR 97756, USA	44.2566580	-121.1821550	1,892 m		antiques, shopping, thrift stores, vintage	home_goods_store,store,point_of_interest,establishment	Maps \| Website	(541) 526-1161	View Hours Monday: 11:00 AM – 5:00 PM Tuesday: 11:00 AM – 5:00 PM 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)
ChIJRelt8Nwqv1QRCZhMlIEOPOA	The Blossom Cottage Tea Room (edited)	307 NW 7th St, Redmond, OR 97756 (edited)	44.2785330	-121.1756440	672 m	coffee-treats (edited)	coffee shops (edited)	coffee shops (edited)	Maps \| Website (edited)	541-279-6652		No photos available