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: 12
Limit per Page: 25
Offset: 275
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 275, 25

Previous Next

Page 12 of 24

Showing 276 to 300 of 583 results

Place ID	Name	Address	Latitude	Longitude	Distance	Category	Search Term	Types	Links	Phone	Hours	Photos
ChIJWW_oVLfdvlQRui_hg2lwa6E	Jericho Lane Farmhouse	3999-3301 SW Jericho Ln, Culver, OR 97734, USA	44.5020890	-121.1969430	25,581 m		tourist attraction	establishment,point_of_interest,tourist_attraction	Page \| Maps			View Photos (4)
ChIJdeZB0MIqv1QRaNRNr61ZvM0	Jersey Boys Pizzeria	527 NW Elm Ave, Redmond, OR 97756, USA	44.2803300	-121.1734660	858 m		bars, brewery, lunch, pubs, restaurants	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 548-5232		View Photos (4)
ChIJX3lxD9cqv1QRGsRRgN15nUU	JOANN Fabric and Crafts	732 SW 6th St, Redmond, OR 97756, USA	44.2702520	-121.1736000	265 m		shopping	establishment,home_goods_store,point_of_interest,store	Page \| Maps \| Website	(541) 548-8042	View Hours Monday: 9:00 AM – 9:00 PM 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: 10:00 AM – 6:00 PM	View Photos (4)
ChIJzexWqxwFvFQRLCu7qYXCj8k	John Day Fossil Beds National Monument – Painted Hills Unit	37375 Bear Creek Rd, Mitchell, OR 97750, USA	44.6599170	-120.2585340	84,447 m	outdoors	point-of-interest	establishment,park,point_of_interest	Page \| Maps \| Website	(541) 987-2333	View Hours Monday: Closed Tuesday: 10:00 AM – 4:00 PM Wednesday: 10:00 AM – 4:00 PM Thursday: 10:00 AM – 4:00 PM Friday: Open 24 hours Saturday: Open 24 hours Sunday: Open 24 hours	View Photos (4)
ChIJu-tHfqLVuFQRtHJLnZvBss0	Jonny’s Joint	2605 S 1st St, Redmond, OR 97756, USA	44.2526370	-121.1695980	2,249 m	food-trucks (edited)	food trucks (edited)	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 420-0949	View Hours Monday: 7:00 AM – 2:00 PM 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: Closed	View Photos (4)
ChIJtbkJBcIrv1QRQn71HDQmJUg	Jordan’s Fruit Stand	531 W Antler Ave, Redmond, OR 97756, USA	44.2767490	-121.1739440	459 m		farmers markets, markets	establishment,food,grocery_or_supermarket,point_of_interest,store	Page \| Maps \| Website	(541) 815-6615		View Photos (4)
ChIJU2jFEZArv1QR15K7pxTuIcU	Junction Roastery • Social Club	708 SW Deschutes Ave, Redmond, OR 97756, USA	44.2734010	-121.1756070	160 m		cocktails, coffee shops	bakery,cafe,establishment,food,point_of_interest,store	Page \| Maps \| Website		View Hours Monday: 7:00 AM – 4:00 PM Tuesday: 7:00 AM – 4:00 PM Wednesday: 7:00 AM – 4:00 PM Thursday: 7:00 AM – 4:00 PM Friday: 7:00 AM – 4:00 PM Saturday: 7:00 AM – 4:00 PM Sunday: 7:00 AM – 4:00 PM	View Photos (4)
ChIJrapzMCUrv1QRb0WCm8Tv3AE	Junior’s Meat Market	915 SW Rimrock Way, Redmond, OR 97756, USA	44.2681870	-121.1929410	1,593 m		grocery stores, markets, meat markets	establishment,food,point_of_interest,store	Page \| Maps \| Website		View Hours Monday: Closed Tuesday: 9:30 AM – 8:00 PM Wednesday: 9:30 AM – 8:00 PM Thursday: 9:30 AM – 8:00 PM Friday: 9:30 AM – 8:00 PM Saturday: 9:30 AM – 8:00 PM Sunday: 9:30 AM – 8:00 PM	View Photos (4)
ChIJ91-r3J3UuFQRXH2sm39w0WM	Juniper Golf Course (edited)	1938 SW Elkhorn Ave, Redmond, OR 97756, USA (edited)	44.2291120	-121.1950260	5,122 m	golf,outdoors,recreation (edited)	golf courses,driving range (edited)	point_of_interest,establishment (edited)	Page \| Maps \| Website (edited)	(541) 548-3121	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: 8:00 AM – 7:00 PM Sunday: 8:00 AM – 7:00 PM	View Photos (4)
ChIJta74Md8sv1QRGaKbPq7ZA5k	Juniper Trailhead	Cline Falls Rd, Redmond, OR 97756, USA	44.2445390	-121.2821970	9,171 m		hiking, mountain biking	establishment,park,point_of_interest	Page \| Maps	(541) 416-6700	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: 8:00 AM – 8:00 PM	View Photos (4)
ChIJ1_TWqNAqv1QRr9QTKRGor9Y	Just Cut Organic Juice Bar and Fitness	412 SW Evergreen Ave, Redmond, OR 97756, USA	44.2723180	-121.1724450	122 m		juice bars, pubs	establishment,food,gym,health,point_of_interest,restaurant	Page \| Maps \| Website	(541) 771-2161	View Hours Monday: 7:00 AM – 5:00 PM Tuesday: 7:00 AM – 5:00 PM Wednesday: 7:00 AM – 5:00 PM Thursday: 7:00 AM – 5:00 PM Friday: 7:00 AM – 5:00 PM Saturday: 9:00 AM – 4:00 PM Sunday: 10:00 AM – 3:00 PM	View Photos (4)
ChIJPx6vk9wqv1QRGx1IpSkAB48	Ka Nui Salon	249 NW 6th St UNIT 2, Redmond, OR 97756, USA	44.2780720	-121.1745930	609 m		massage	beauty_salon,establishment,hair_care,point_of_interest,spa	Page \| Maps \| Website	(541) 504-4544	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: 9:00 AM – 3:00 PM Sunday: Closed	View Photos (4)
ChIJ_S3Y72orv1QRge-gXe5ssw4	Kambry Berg LMT	716 SW 11th St, Redmond, OR 97756, USA	44.2703030	-121.1793770	505 m		massage	establishment,point_of_interest	Page \| Maps \| Website	(541) 852-6770	View Hours Monday: 1:00 – 4:00 PM Tuesday: Closed Wednesday: 9:30 AM – 2:00 PM Thursday: 3:00 – 6:30 PM Friday: 2:30 – 6:30 PM Saturday: 11:30 AM – 4:30 PM Sunday: 11:30 AM – 4:30 PM	View Photos (3)
ChIJhe4W1cMrv1QRFB_XQxeCGjA	Keystone Natural Beef	655 SW 7th St, Redmond, OR 97756, USA	44.2707290	-121.1756150	250 m		grocery stores, markets, meat markets	establishment,food,grocery_or_supermarket,point_of_interest,store	Page \| Maps \| Website	(541) 699-3141	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 (2)
ChIJh637HLjUuFQRTDyVv_Hq2tY	KFC	1719 SW Wickiup Ave, Redmond, OR 97756, USA	44.2476510	-121.1874210	2,977 m		lunch	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 548-8480	View Hours Monday: 10:30 AM – 9:00 PM Tuesday: 10:30 AM – 9:00 PM Wednesday: 10:30 AM – 9:00 PM Thursday: 10:30 AM – 9:00 PM Friday: 10:30 AM – 9:00 PM Saturday: 10:30 AM – 9:00 PM Sunday: 10:30 AM – 9:00 PM	View Photos (3)
ChIJ6_6oTHvNuFQRJww5KCkV_d8	Khalsa Hands Massage	708 SW Deschutes Ave, Redmond, OR 97756, USA	44.2734120	-121.1756510	163 m		massage	establishment,point_of_interest	Page \| Maps	(541) 548-6556	View Hours Monday: 8:00 AM – 6:30 PM Tuesday: 8:00 AM – 6:30 PM Wednesday: 8:00 AM – 6:30 PM Thursday: 8:00 AM – 6:30 PM Friday: 8:00 AM – 6:30 PM Saturday: 8:00 AM – 6:30 PM Sunday: Closed	No photos available
ChIJ1bL8qynVuFQR_lqasnGI4IM	KNS Hot Tubs	535 NE Jackpine Ct Unit 101, Redmond, OR 97756, USA	44.2857720	-121.1632730	1,690 m		spas	establishment,point_of_interest,store	Page \| Maps \| Website	(541) 923-1063	View Hours Monday: Closed Tuesday: 9:00 AM – 4:00 PM Wednesday: 9:00 AM – 4:00 PM Thursday: 9:00 AM – 4:00 PM Friday: 9:00 AM – 4:00 PM Saturday: 9:00 AM – 2:00 PM Sunday: Closed	View Photos (4)
ChIJNaNoydsqv1QRIdhVgJDdxIw	Kobold Brewing The Vault	food trucks (edited)	44.2748000	-121.1745060	247 m	restaurants,beer-wine-spirits (edited)	brewery (edited)	establishment,food,point_of_interest	Page \| Maps \| Website	(541) 504-9373	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 – 10:00 PM Friday: 11:00 AM – 10:00 PM Saturday: 11:00 AM – 10:00 PM Sunday: 11:00 AM – 8:00 PM	View Photos (4)
ChIJ773SkGjHuFQRYTQjK2CjrQ0	Kooki	235 SW 6th St, Redmond, OR 97756, USA	44.2749580	-121.1745550	265 m		bakeries, coffee shops, desserts	bakery,cafe,establishment,food,point_of_interest,store	Page \| Maps \| Website	(541) 527-4855	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: Closed	View Photos (4)
ChIJyS5ZBP4rv1QRnVyYthMZvHo	Krispy Krunchy Chicken	401 NW Quince Ave, Redmond, OR 97756, USA	44.2986840	-121.1728290	2,899 m		restaurants	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 923-0669	View Hours Monday: 7:00 AM – 11:00 PM Tuesday: 7:00 AM – 11:00 PM Wednesday: 7:00 AM – 11:00 PM Thursday: 7:00 AM – 11:00 PM Friday: 7:00 AM – 11:00 PM Saturday: 7:00 AM – 11:00 PM Sunday: 7:00 AM – 11:00 PM	View Photos (4)
ChIJSxhhhpIrv1QRsr6GyJaZqOw	La Birria Republic	122 SW 5th St, Redmond, OR 97756, USA	44.2760920	-121.1729770	393 m		food trucks, lunch, restaurants	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(801) 909-8095	View Hours Monday: Closed Tuesday: 10:30 AM – 8:00 PM Wednesday: 10:30 AM – 8:30 PM Thursday: 10:30 AM – 8:30 PM Friday: 10:30 AM – 8:30 PM Saturday: 10:30 AM – 8:30 PM Sunday: 10:30 AM – 8:30 PM	View Photos (4)
ChIJBUQjQ2srv1QRayFkvHI_ges	LA CHOZA LATIN CUISINE	lunch (edited)	44.2712790	-121.1767310	269 m	restaurants (edited)	restaurants (edited)	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	dining (edited)	View Hours Monday: Closed 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 – 11:00 PM Saturday: 11:00 AM – 11:00 PM Sunday: 11:00 AM – 9:00 PM	View Photos (4)
ChIJJbfAg87UuFQR-bGTUcYnIB4	La Frontera	2330 S Hwy 97 #8873, Redmond, OR 97756, USA	44.2544620	-121.1821500	2,123 m		lunch, restaurants	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 275-6389	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 – 4:00 PM	View Photos (4)
ChIJfRfuN9PUuFQRs1P7QLdg5Kc	La Frontera Bakery	1604 S Hwy 97, Redmond, OR 97756, USA	44.2604060	-121.1779640	1,396 m		bakeries, desserts	bakery,establishment,food,point_of_interest,store	Page \| Maps \| Website	(541) 548-8022	View Hours Monday: 6:00 AM – 9:00 PM Tuesday: 6:00 AM – 9:00 PM Wednesday: 6:00 AM – 9:00 PM Thursday: 6:00 AM – 9:00 PM Friday: 6:00 AM – 9:00 PM Saturday: 6:00 AM – 9:00 PM Sunday: 6:00 AM – 9:00 PM	View Photos (4)
ChIJeQv5HCgrv1QRkw7opOoGuuo	La Posada Mexican Grill	1029 SW Highland Ave, Redmond, OR 97756, USA	44.2697460	-121.1789850	515 m		breakfast, restaurants	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 923-7448	View Hours Monday: 7:00 AM – 12:00 AM Tuesday: 7:00 AM – 12:00 AM Wednesday: 7:00 AM – 12:00 AM Thursday: 7:00 AM – 12:00 AM Friday: 7:00 AM – 1:00 AM Saturday: 7:00 AM – 12:00 AM Sunday: 7:00 AM – 12:00 AM	View Photos (4)