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: 13
Limit per Page: 25
Offset: 300
Total Pages: 26

Results:

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

Previous Next

Page 13 of 26

Showing 301 to 325 of 645 results

Place ID	Name	Address	Latitude	Longitude	Distance	Category	Search Term	Types	Links	Phone	Hours	Photos
ChIJdeZB0MIqv1QRaNRNr61ZvM0	Jersey Boys Pizzeria	527 NW Elm Ave, Redmond, OR 97756, USA	44.2803300	-121.1734660	858 m		bars, bars,live music,bars,live music,pubs,brewery,restaurants,lunch,family friendly, brewery, lunch, pubs, restaurants	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 548-5232	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)
ChIJJ4fAssorv1QRIQhTjN2giFY	Jessica’s Hair Haven	339 SW 6th St Ste 3, Redmond, OR 97756, USA	44.2740100	-121.1745750	163 m		family friendly	establishment,hair_care,point_of_interest	Page \| Maps \| Website	(541) 550-8481	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: 11:00 AM – 6:00 PM Sunday: 11:00 AM – 6:00 PM	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, farmers markets,farms,grocery stores, markets	establishment,food,grocery_or_supermarket,point_of_interest,store	Page \| Maps \| Website	(541) 815-6615	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	View Photos (4)
ChIJU2jFEZArv1QR15K7pxTuIcU	Junction Roastery • Social Club	708 SW Deschutes Ave, Redmond, OR 97756, USA	44.2734010	-121.1756070	160 m		cocktails, cocktails,coffee shops,family friendly,shopping, 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, markets,grocery stores,meat 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)
ChIJI7PqSsg3v1QR0GNoJKIyQMg	Juniper Blu Home, Gift & Style	738 SW Highland Ave, Redmond, OR 97756, USA	44.2694640	-121.1762380	397 m		gift shops,shopping	clothing_store,establishment,food,furniture_store,grocery_or_supermarket,home_goods_store,point_of_interest,store	Page \| Maps \| Website	(541) 279-6652	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: Closed	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	SW Cline Falls Rd, Redmond, OR 97756, USA	44.2445390	-121.2821970	9,171 m		hiking, hiking,mountain biking,trailheads, mountain biking	establishment,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		bars,pubs,juice bars,breakfast, 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: Closed	View Photos (4)
ChIJ89oqiYUrv1QRvt0kvd_hHOk	Justy’s	836 SW 12th St Ste B, Redmond, OR 97756, USA	44.2689880	-121.1804580	659 m		farms	establishment,food,point_of_interest	Page \| Maps \| Website			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	Kauboi Natural Beef	655 SW 7th St, Redmond, OR 97756, USA	44.2707290	-121.1756150	250 m		farms,meat markets, 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 (4)
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, coffee shops,bakeries,desserts, 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)
ChIJBUQjQ2srv1QRayFkvHI_ges	L	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)
ChIJSxhhhpIrv1QRsr6GyJaZqOw	La Birria Republic	122 SW 5th St, Redmond, OR 97756, USA	44.2760920	-121.1729770	393 m		food trucks, food trucks,restaurants,lunch,family friendly, 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)
ChIJ60sQqbYrv1QRjNMwE9a37jE	La Bonita Brunch	958 NW 6th St, Redmond, OR 97756, USA	44.2851670	-121.1729210	1,397 m		bars,breakfast,lunch,dining,family friendly	establishment,food,point_of_interest,restaurant	Page \| Maps	(541) 678-4991	View Hours Monday: 7:00 AM – 2:30 PM Tuesday: 7:00 AM – 2:30 PM Wednesday: 7:00 AM – 2:30 PM Thursday: 7:00 AM – 2:30 PM Friday: 7:00 AM – 2:30 PM Saturday: 7:00 AM – 2:00 PM Sunday: Closed	View Photos (4)