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: 5
Limit per Page: 25
Offset: 100
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 100, 25

Previous Next

Page 5 of 24

Showing 101 to 125 of 583 results

Place ID	Name	Address	Latitude	Longitude	Distance	Category	Search Term	Types	Links	Phone	Hours	Photos
ChIJAQDQSsUqv1QRMUKfK-szP2U	Central Oregon Mobile Butcher	353 SE Railroad Blvd #2342, Redmond, OR 97756, USA	44.2750680	-121.1680010	544 m		meat markets	establishment,food,point_of_interest,store	Page \| Maps	(541) 610-2468	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
ChIJbVS0ae_SuFQRSy6uZc1HYo0	Central Oregon Ostrich	7600 SW Quarry Ave, Redmond, OR 97756, USA	44.2091130	-121.2605740	9,875 m		farms	establishment,food,general_contractor,point_of_interest	Page \| Maps \| Website	(541) 923-5076		View Photos (3)
ChIJl-KqusIqv1QRO29vbcjwS0I	Chan’s of Redmond	704 South SW 6th St, Redmond, OR 97756, USA	44.2704680	-121.1739980	239 m		dining	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 548-1418	View Hours Monday: Closed Tuesday: 11:30 AM – 9:00 PM Wednesday: 11:30 AM – 9:00 PM Thursday: 11:30 AM – 9:00 PM Friday: 11:30 AM – 9:30 PM Saturday: 11:30 AM – 9:30 PM Sunday: 11:30 AM – 9:00 PM	View Photos (4)
ChIJ1Y53bSYrv1QR4KoKnJAFsG8	Changing Tide Massage	641 SW 14th St, Redmond, OR 97756, USA	44.2708820	-121.1831650	761 m		massage	establishment,point_of_interest	Page \| Maps	(541) 480-0066	View Hours Monday: 8:00 AM – 7:00 PM Tuesday: 8:00 AM – 7:00 PM Wednesday: 8:00 AM – 7:00 PM Thursday: 8:00 AM – 7:00 PM Friday: 8:00 AM – 7:00 PM Saturday: Closed Sunday: Closed	View Photos (1)
ChIJ3xhwJgDVuFQRUcpWy9qWeaI	Chavez Market	2498 S Hwy 97 St B, Redmond, OR 97756, USA	44.2525650	-121.1830280	2,345 m		desserts, grocery stores, juice bars, markets, meat markets, shopping	establishment,food,grocery_or_supermarket,point_of_interest,store	Page \| Maps	(458) 899-5953	View Hours Monday: 8:00 AM – 8:00 PM Tuesday: 8:00 AM – 8:00 PM Wednesday: 8:00 AM – 8:00 PM Thursday: 8:00 AM – 8:00 PM Friday: 8:00 AM – 8:00 PM Saturday: 8:00 AM – 8:00 PM Sunday: 9:00 AM – 7:00 PM	View Photos (4)
ChIJh3fAPiYrv1QRzRMNqa57jhw	Chevron	1501 SW Highland Ave, Redmond, OR 97756, USA	44.2698650	-121.1847740	917 m		breakfast	car_repair,convenience_store,establishment,food,gas_station,point_of_interest,store	Page \| Maps \| Website	(541) 923-8881	View Hours Monday: 5:00 AM – 10:00 PM Tuesday: 5:00 AM – 10:00 PM Wednesday: 5:00 AM – 10:00 PM Thursday: 5:00 AM – 10:00 PM Friday: 5:00 AM – 11:00 PM Saturday: 6:00 AM – 11:00 PM Sunday: 6:00 AM – 10:00 PM	View Photos (4)
ChIJxQLW4qcmuVQR21i6am9TyU8	Chimney Rock Campground	Chimney Rock Campground, Crooked River Hwy, Prineville, OR 97754, USA	44.1375110	-120.8162650	32,225 m		campgrounds	campground,establishment,lodging,park,point_of_interest	Page \| Maps \| Website	(541) 416-6700		View Photos (4)
ChIJUXWUaGYrv1QRCPSXZcqpMGw	Chipotle Mexican Grill	1395 SW Canal Blvd, Redmond, OR 97756, USA	44.2641680	-121.1788380	1,018 m		dining	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(458) 312-3257	View Hours Monday: 10:45 AM – 11:00 PM Tuesday: 10:45 AM – 11:00 PM Wednesday: 10:45 AM – 11:00 PM Thursday: 10:45 AM – 11:00 PM Friday: 10:45 AM – 11:00 PM Saturday: 10:45 AM – 11:00 PM Sunday: 10:45 AM – 11:00 PM	View Photos (4)
ChIJb5eektwqv1QRMnoIT14UdpQ	Christie’s Kitchen	614 NW Cedar Ave, Redmond, OR 97756, USA	44.2781590	-121.1748490	620 m		breakfast, lunch	establishment,food,point_of_interest,restaurant	Page \| Maps	(541) 923-8878	View Hours Monday: Closed Tuesday: 7:00 AM – 2:00 PM Wednesday: 7:00 AM – 2:00 PM Thursday: 7:00 AM – 2:00 PM Friday: 7:00 AM – 2:00 PM Saturday: 7:00 AM – 2:00 PM Sunday: 7:00 AM – 2:00 PM	View Photos (4)
ChIJJ0TZvdNLv1QRZgNE0WppWpc	Chush Falls Trailhead	Blue River, OR 97413, USA	44.1774230	-121.6667700	40,673 m		hiking	establishment,park,point_of_interest	Page \| 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	View Photos (4)
ChIJWSNSHiUrv1QRceuUMBTr5tU	Cibelli’s NY Pizza Redmond	885 SW Rimrock Way Ste 102, Redmond, OR 97756, USA	44.2689750	-121.1925020	1,534 m		restaurants	establishment,food,meal_takeaway,point_of_interest,restaurant	Page \| Maps \| Website	(541) 923-7388	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: Closed	View Photos (4)
ChIJX-XSYXcqv1QR4ew3fjPAnyk	Cinder Butte Meat Co.	197 NW Oneil Way, Redmond, OR 97756, USA	44.3138660	-121.1697480	4,598 m		markets, meat markets	establishment,food,point_of_interest,store	Page \| Maps \| Website	(541) 548-6328	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: 9:00 AM – 3:00 PM Sunday: Closed	View Photos (4)
ChIJ9QceACsrv1QRY6iT7is5iBA	Cindy’s Chinese Garden	1362 S Hwy 97, Redmond, OR 97756, USA	44.2638890	-121.1758330	983 m		dining, lunch, restaurants	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 923-9928	View Hours Monday: 11:30 AM – 8:00 PM Tuesday: 11:30 AM – 8:00 PM Wednesday: 11:30 AM – 8:00 PM Thursday: 11:30 AM – 8:00 PM Friday: 11:30 AM – 9:00 PM Saturday: 11:30 AM – 9:00 PM Sunday: 11:30 AM – 8:00 PM	View Photos (4)
ChIJVyqBfc3UuFQRyF5VqWVf6Wo	Circle K	2005 S Hwy 97, Redmond, OR 97756, USA	44.2576860	-121.1812990	1,761 m		coffee shops, shopping	atm,cafe,convenience_store,establishment,finance,food,gas_station,point_of_interest,store	Page \| Maps \| Website	(541) 548-6337	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)
ChIJxRgmxNwqv1QRAvW1K4af86I	City Center Motel	350 NW 6th St, Redmond, OR 97756, USA	44.2788810	-121.1739190	696 m		hotels	establishment,lodging,point_of_interest	Page \| Maps	(541) 548-3447		View Photos (4)
ChIJM0DalLrVuFQRAF6WKyGa43s	CK BINGO Hall & Event Center	CK BINGO Hall & Event Center, 798 NW 5th St, Redmond, OR 97756, USA	44.2834480	-121.1725940	1,209 m		event venues	establishment,point_of_interest	Page \| Maps \| Website	(541) 526-1948	View Hours Monday: Closed Tuesday: Closed Wednesday: Closed Thursday: Closed Friday: 4:00 – 9:30 PM Saturday: Closed Sunday: Closed	View Photos (4)
ChIJs9KxmVNov1QRuP5g446ZuzU	Clear Lake	Clear Lake, Oregon 97759, USA	44.3686930	-121.9943910	66,139 m	outdoors	point-of-interest	establishment,natural_feature	Page \| Maps			View Photos (4)
ChIJZaT4qhwtv1QRxAJbxt8a63o	Cline Buttes	Cline Buttes, Eagle Crest, OR 97756, USA	44.2528960	-121.3036470	10,561 m		mountain biking	establishment,natural_feature	Page \| Maps			View Photos (4)
ChIJ8w_4c3ksv1QR_O0U6SKjJi8	Cline Falls Mobile Home Park office	7915 OR-126 office, Redmond, OR 97756, USA	44.2792000	-121.2665290	7,409 m		rv parks	establishment,lodging,point_of_interest,rv_park	Page \| Maps	(541) 420-5578		View Photos (4)
ChIJ9Wl0voQsv1QRe6Z3VAlhkkc	Cline Falls State Park	7012 McKenzie Hwy, Redmond, OR 97756, USA	44.2686620	-121.2561080	6,559 m	outdoors	point-of-interest, state parks	establishment,parking,point_of_interest	Page \| Maps			View Photos (4)
ChIJKdLcu4Qsv1QROnJXkSKnQPw	Cline Falls State Scenic Viewpoint	7100 OR-126, Redmond, OR 97756, USA	44.2706410	-121.2562830	6,561 m		state parks	establishment,park,point_of_interest	Page \| Maps \| Website	(800) 551-6949		View Photos (4)
ChIJ6WqrGooqv1QRyegH-EWAEyU	Clock Tower Pub Redmond	2757 NW 7th St # G, Redmond, OR 97756, USA	44.3013990	-121.1755830	3,203 m		bars, brewery, cocktails, live music, nightlife, pool tables, pubs	bar,establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 526-1871	View Hours Monday: 11:00 AM – 9:00 PM Tuesday: 11:00 AM – 10:00 PM Wednesday: 11:00 AM – 10:00 PM Thursday: 11:00 AM – 10:00 PM Friday: 11:00 AM – 11:00 PM Saturday: 9:00 AM – 11:00 PM Sunday: 9:00 AM – 9:00 PM	View Photos (4)
ChIJ5ytqgrfUuFQRQ66zO_xZkhY	Coastal Farm & Ranch	3141 S Hwy 97, Redmond, OR 97756, USA	44.2472840	-121.1900680	3,097 m		farms, grocery stores, shopping	clothing_store,establishment,food,hardware_store,home_goods_store,point_of_interest,store	Page \| Maps \| Website	(541) 548-4095	View Hours Monday: 8:00 AM – 9:00 PM Tuesday: 8:00 AM – 9:00 PM Wednesday: 8:00 AM – 9:00 PM Thursday: 8:00 AM – 9:00 PM Friday: 8:00 AM – 9:00 PM Saturday: 8:00 AM – 9:00 PM Sunday: 9:00 AM – 6:00 PM	View Photos (4)
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)