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: 7
Limit per Page: 25
Offset: 150
Total Pages: 29

Results:

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

Previous Next

Page 7 of 29

Showing 151 to 175 of 705 results

Place ID	Name	Address	Latitude	Longitude	Distance	Category	Search Term	Types	Links	Phone	Hours	Photos
ChIJ2a8tyxArv1QR_ihuMeVRzHc	Coastal Smash Redmond	639 SW 8th St, Redmond, OR 97756, USA	44.2708060	-121.1767190	301 m		food trucks	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(503) 374-2074	View Hours Monday: Closed Tuesday: 11:30 AM – 7:30 PM Wednesday: 11:30 AM – 7:30 PM Thursday: 11:30 AM – 7:30 PM Friday: 11:30 AM – 8:00 PM Saturday: 11:30 AM – 8:00 PM Sunday: Closed	View Photos (4)
ChIJwdyeMqsmuVQR6O0horlcM9k	Cobble Rock Campground	Crooked River Hwy, Prineville, OR 97754, USA	44.1289460	-120.8106000	33,076 m		campgrounds	campground,establishment,lodging,park,point_of_interest	Page \| 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)
ChIJYTsBKn8rv1QRuyCqCBMOX9U	Coffee Depo	Redmond, OR 97756, USA	44.2726660	-121.1739210	5 m		coffee shops, coffee shops,shopping,coffee shops,shopping, shopping	cafe,establishment,food,point_of_interest,store	Page \| Maps			No photos available
ChIJeSIIASUrv1QRKjBsJaYswgs	Coffee Depot	782 SW Rimrock Way #104, Redmond, OR 97756, USA	44.2697450	-121.1910130	1,398 m		coffee shops	cafe,establishment,food,point_of_interest,store	Page \| Maps		View Hours Monday: 6:00 AM – 5:00 PM Tuesday: 6:00 AM – 5:00 PM Wednesday: 6:00 AM – 5:00 PM Thursday: 6:00 AM – 5:00 PM Friday: 6:00 AM – 5:00 PM Saturday: 7:00 AM – 5:00 PM Sunday: 7:00 AM – 5:00 PM	View Photos (4)
ChIJRQ6Mdbcrv1QRUKRgWcG3HAo	Cognitive Surplus Stationery & Gift Store	436 SW 6th St, Redmond, OR 97756, USA	44.2729650	-121.1739760	39 m		gift shops, gift shops,shopping,gift shops,shopping, shopping	establishment,home_goods_store,point_of_interest,store	Page \| Maps \| Website	(541) 527-2248	View Hours Monday: 10:00 AM – 6:00 PM 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 – 6:00 PM Sunday: 10:00 AM – 5:00 PM	View Photos (4)
ChIJ6cUIobY5v1QRyxfG8DOpTZQ	Cold Spring Campground	McKenzie Hwy, Sisters, OR 97759, USA	44.3091480	-121.6305030	36,567 m		campgrounds	campground,establishment,lodging,point_of_interest	Page \| Maps \| Website	(541) 338-7869		View Photos (4)
ChIJH9qopCsrv1QRN2_dig7ATj4	Cold Stone Creamery	1380 SW Canal Blvd Ste 102, Redmond, OR 97756, USA	44.2642900	-121.1775320	970 m		desserts	establishment,food,point_of_interest,store	Page \| Maps \| Website	(541) 923-9836	View Hours Monday: 12:00 – 8:00 PM Tuesday: 12:00 – 8:00 PM Wednesday: 12:00 – 9:00 PM Thursday: 12:00 – 8:00 PM Friday: 12:00 – 9:00 PM Saturday: 12:00 – 9:00 PM Sunday: 12:00 – 8:00 PM	View Photos (4)
ChIJqRrfSNYqv1QRqLzUVK3gtJk	Copper Sky Massage	2622 SW Glacier Pl #120, Redmond, OR 97756, USA	44.2696380	-121.1985210	1,987 m		massage	establishment,point_of_interest	Page \| Maps \| Website	(541) 280-3626		View Photos (3)
ChIJ_8Ue3Asrv1QRHdo7kpNaJg8	Cora’s Salon	106 SE Evergreen Ave, Redmond, OR 97756, USA	44.2716900	-121.1681890	468 m		spas	beauty_salon,establishment,point_of_interest	Page \| Maps	(541) 548-2468	View Hours Monday: 7:00 AM – 6:00 PM Tuesday: 7:00 AM – 6:00 PM Wednesday: 7:00 AM – 6:00 PM Thursday: 7:00 AM – 6:00 PM Friday: 7:00 AM – 6:00 PM Saturday: 7:00 AM – 4:00 PM Sunday: Closed	View Photos (4)
ChIJE9K9gdsqv1QRQQmSt2mPfcE	Cornucopia Natural Foods	111 NW 6th St, Redmond, OR 97756, USA	44.2767510	-121.1745930	462 m		farmers markets, farmers markets,markets,grocery stores,shopping,farmers markets,markets,grocery stores, grocery stores, markets, shopping	establishment,food,health,point_of_interest,store	Page \| Maps \| Website	(541) 548-5911	View Hours Monday: 9:30 AM – 5:30 PM Tuesday: 9:30 AM – 5:30 PM Wednesday: 9:30 AM – 5:30 PM Thursday: 9:30 AM – 5:30 PM Friday: 9:30 AM – 5:30 PM Saturday: 10:00 AM – 5:00 PM Sunday: Closed	View Photos (4)
ChIJf22mgAYrv1QR7SZmIptW9dY	Cottonwood RV Park (edited)	2956 NW Canal Blvd, Redmond, OR 97756, USA (edited)	44.3035850	-121.1681290	3,474 m	rv-parks-camping (edited)	rv parks (edited)	rv_park,lodging,point_of_interest,establishment (edited)	Page \| Maps \| Website (edited)	(541) 728-4184	View Hours Monday: 7:00 AM – 7:00 PM Tuesday: 7:00 AM – 7:00 PM Wednesday: 7:00 AM – 7:00 PM Thursday: 7:00 AM – 7:00 PM Friday: 7:00 AM – 7:00 PM Saturday: 7:00 AM – 7:00 PM Sunday: 7:00 AM – 7:00 PM	View Photos (4)
ChIJAYZ6RHPVuFQRnfavQaMjR3s	Country Coffee	1836 SW Veterans Way, Redmond, OR 97756, USA	44.2621160	-121.1718050	1,180 m		bars, coffee shops, coffee shops,bars,coffee shops	establishment,point_of_interest	Page \| Maps \| Website	(541) 668-3431	View Hours Monday: 5:00 AM – 4:00 PM Tuesday: 5:00 AM – 4:00 PM Wednesday: 5:00 AM – 4:00 PM Thursday: 5:00 AM – 4:00 PM Friday: 5:00 AM – 4:00 PM Saturday: 6:00 AM – 3:00 PM Sunday: 6:00 AM – 3:00 PM	View Photos (2)
ChIJxXzWB1HYvlQRzv1H7eOJJbA	Coyote’s Den Disc Golf Course (edited)	Ranch House Road, Terrebonne, OR 97760, USA (edited)	44.4337340	-121.2520910	18,963 m	golf, outdoors, recreation (edited)	disc golf (edited)	point_of_interest,establishment (edited)	Page \| Maps	(541) 604-9115		View Photos (4)
ChIJr6bqXQArv1QR-XdxyHcc11w	Crazy Gyros	122 SW 5th St, Redmond, OR 97756, USA	44.2760550	-121.1729860	389 m		food trucks	establishment,food,point_of_interest	Page \| Maps			View Photos (2)
ChIJG5tRukUrv1QRwbY0v29hceE	Creations From the Heart/Longarming,Gifts	appointment only, 2148 NW 11th St, Redmond, OR 97756, USA	44.2961200	-121.1799430	2,657 m		gift shops	establishment,point_of_interest	Page \| Maps	(541) 788-1295		View Photos (4)
ChIJ9xeqHsswv1QRxUC8q0lB4ZU	Creekside Park	649 OR-126, Sisters, OR 97759, USA	44.2887460	-121.5427350	29,415 m		campgrounds	establishment,park,point_of_interest	Page \| Maps		View Hours Monday: 7:30 AM – 4:30 PM Tuesday: 7:30 AM – 4:30 PM Wednesday: 7:30 AM – 4:30 PM Thursday: 7:30 AM – 4:30 PM Friday: 7:30 AM – 12:00 PM Saturday: Closed Sunday: Closed	View Photos (4)
ChIJWUtgagQPx1QRh17ukFOxTC8	Crescent Lake	Crescent Lake, Oregon 97733, USA	43.4747940	-121.9854810	110,008 m	outdoors	point of interest	establishment,natural_feature	Page \| Maps			View Photos (3)
ChIJFT1Qqw7WvlQRolpm-QOAhoA	Crescent Moon Ranch	7566 US-97, Terrebonne, OR 97760, USA	44.3451380	-121.1781310	8,071 m	shopping (edited)	family fun (edited)	establishment,point_of_interest	Page \| Maps \| Website	(541) 923-2285	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: 10:00 AM – 4:00 PM	View Photos (4)
ChIJh0op4tkqv1QR5Z29ZGr-Yl4	Cricket On the Hearth	521 SW 6th St #101, Redmond, OR 97756, USA	44.2720370	-121.1746250	86 m		gift shops	establishment,point_of_interest,store	Page \| Maps	(541) 504-7770	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
ChIJh2CKoykrv1QRuaf8PZH4gI4	Croutons Redmond	974 SW Veterans Way Ste 6, Redmond, OR 97756, USA	44.2671220	-121.1791080	738 m		lunch, lunch,dining, restaurants	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 316-1500	View Hours Monday: 11:00 AM – 7:00 PM Tuesday: 11:00 AM – 7:00 PM Wednesday: 11:00 AM – 7:00 PM Thursday: 11:00 AM – 7:00 PM Friday: 11:00 AM – 7:00 PM Saturday: 11:00 AM – 7:00 PM Sunday: 11:00 AM – 7:00 PM	View Photos (4)
ChIJu3MkWQLWvlQRQMRwYTcltaI	Crown C Farms	2609 NW Odem Ave, Terrebonne, OR 97760, USA	44.3435460	-121.1968180	8,094 m		farms	establishment,point_of_interest	Page \| Maps	(541) 480-9070		No photos available
ChIJx2T1cwDZvlQRrQd6WiUSb2U	CRR RV Park Overlook	Crooked River Ranch, OR 97760, USA	44.4273730	-121.2361230	17,904 m		tourist attraction	establishment,point_of_interest,tourist_attraction	Page \| Maps			No photos available
ChIJ-49RKeHdvlQRchgSVuOkk-k	Culver water park	Culver, OR 97734, USA	44.5241230	-121.2078900	28,096 m		tourist attraction	tourist_attraction,point_of_interest,establishment	Page \| Maps			View Photos (1)
ChIJZ9b-zHrVuFQRMveL-ZnISEg	Cuportunity Coffee Kiosk	3294 S Hwy 97, Redmond, OR 97756, USA	44.2458880	-121.1884060	3,188 m		coffee shops, thrift stores	cafe,establishment,food,point_of_interest,store	Page \| Maps \| Website		View Hours Monday: 9:00 AM – 5:00 PM Tuesday: 9:00 AM – 5:00 PM Wednesday: 9:00 AM – 5:00 PM Thursday: 9:00 AM – 5:00 PM Friday: 9:00 AM – 5:00 PM Saturday: Closed Sunday: Closed	View Photos (2)
ChIJiQuH7j4rv1QRXYH_WzQE1UQ	Cuppa Yo Frozen Yogurt Redmond, OR	446 SW 6th St, Redmond, OR 97756, USA	44.2728200	-121.1739340	22 m		desserts, juice bars	establishment,food,point_of_interest,store	Page \| Maps \| Website	(458) 899-5955	View Hours Monday: 12:00 – 9:00 PM Tuesday: 12:00 – 9:00 PM Wednesday: 12:00 – 9:00 PM Thursday: 12:00 – 9:00 PM Friday: 12:00 – 9:00 PM Saturday: 12:00 – 9:00 PM Sunday: 12:00 – 9:00 PM	View Photos (4)