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: 14
Limit per Page: 25
Offset: 325
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 325, 25

Previous Next

Page 14 of 29

Showing 326 to 350 of 705 results

Place ID	Name	Address	Latitude	Longitude	Distance	Category	Search Term	Types	Links	Phone	Hours	Photos
ChIJ_ysij0grv1QRbvShDgSXegU	Indian tadka	123 SW 5th St, Redmond, OR 97756, USA	44.2759040	-121.1729080	374 m	food-trucks (edited)	food trucks (edited)	meal_takeaway,restaurant,food,point_of_interest,establishment	Page \| Maps \| Website	(458) 588-9437	View Hours Monday: 11:00 AM – 8:00 PM Tuesday: Closed Wednesday: 11:00 AM – 8:00 PM Thursday: 11:00 AM – 8:00 PM Friday: 11:00 AM – 8:00 PM Saturday: 11:00 AM – 8:00 PM Sunday: 11:00 AM – 8:00 PM	View Photos (4)
ChIJH4FAr-srv1QRAweoCHMgJFg	Indian tadka	122 SW 5th St, Redmond, OR 97756, USA	44.2760920	-121.1729770	393 m		family friendly, restaurants, restaurants,family friendly	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(458) 588-9437	View Hours Monday: 11:00 AM – 7:45 PM Tuesday: Closed Wednesday: 11:00 AM – 7:45 PM Thursday: 11:00 AM – 7:45 PM Friday: 11:00 AM – 7:45 PM Saturday: 11:00 AM – 7:45 PM Sunday: 11:00 AM – 7:45 PM	View Photos (4)
ChIJQbpvDv0rv1QRNw9JdvxktaU	Initiative Brewing (the Hub)	424 NW 5th St, Redmond, OR 97756, USA	44.2799660	-121.1729920	820 m		bars, bars,cocktails,live music,nightlife,bars,cocktails,live music,nightlife,pubs,brewery,microbrewery,restaurants,lunch,dining,family friendly, brewery, cocktails, food trucks, live music, microbrewery, nightlife, pubs	bar,establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 527-4380	View Hours Monday: 11:00 AM – 8:00 PM Tuesday: 11:00 AM – 8:00 PM Wednesday: 11:00 AM – 8:00 PM Thursday: 11:00 AM – 8:00 PM Friday: 11:00 AM – 8:00 PM Saturday: 11:00 AM – 8:00 PM Sunday: 11:00 AM – 8:00 PM	View Photos (4)
ChIJHxdYl8grv1QRHvAKRrvBA24	Inner Balance Therapeutic Massage	621 SW Evergreen Ave, Redmond, OR 97756, USA	44.2727000	-121.1745910	54 m		massage	establishment,point_of_interest	Page \| Maps \| Website	(971) 208-3363	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: Closed Sunday: Closed	View Photos (3)
ChIJOYjHWdAqv1QRrJQoj6YZVDc	J C’s Java & Such	106 SE Evergreen Ave, Redmond, OR 97756, USA	44.2720410	-121.1680790	470 m		coffee shops	cafe,food,point_of_interest,store,establishment	Page \| Maps		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 – 6:00 PM Sunday: Closed	No photos available
ChIJR5dVlsIqv1QRGhMmt4rpcjI	Jamie’s Sun Spa LLC	632 SW 6th St, Redmond, OR 97756, USA	44.2710610	-121.1739250	173 m		massage,spas	establishment,point_of_interest	Page \| Maps \| Website	(541) 419-7128	View Hours Monday: Closed Tuesday: 9:00 AM – 6:00 PM Wednesday: 9:00 AM – 6:00 PM Thursday: 9:00 AM – 6:00 PM Friday: 9:00 AM – 6:00 PM Saturday: Closed Sunday: Closed	View Photos (4)
ChIJodB2iTojuVQRk3VcP4LVq0A	Jasper Point (Prineville Reservoir State Park)	Juniper Canyon Road, Prineville, OR 97754, USA	44.1351530	-120.6957830	41,064 m		campgrounds	establishment,park,point_of_interest	Page \| Maps \| Website	(800) 551-6949		View Photos (4)
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, bars,live music,bars,live music,pubs,brewery,restaurants,lunch,family friendly,bars,live music,pubs,brewery, brewery, family friendly, live music, lunch, pubs, restaurants	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 548-5232	View Hours Monday: 11:00 AM – 8: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 – 8: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 – 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: 11:00 AM – 6:00 PM Sunday: Closed	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,farmers markets,farms,grocery stores, 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,cocktails,coffee shops,family friendly,shopping, coffee shops, family friendly, shopping	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,markets,grocery stores,meat markets, meat markets	establishment,food,point_of_interest,store	Page \| Maps \| Website	(541) 923-7328	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)
ChIJcxujYaMtv1QRHOpR8tG37BM	Juniper and Thread LLC	Redmond, OR 97756, USA	44.2726660	-121.1739210	5 m		markets	establishment,point_of_interest,store	Page \| Maps \| Website	(541) 480-2280	View Hours Monday: 5:00 AM – 5:00 PM Tuesday: 5:00 AM – 5:00 PM Wednesday: 5:00 AM – 5:00 PM Thursday: 5:00 AM – 5:00 PM Friday: 5:00 AM – 5:00 PM Saturday: Closed Sunday: Closed	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, gift shops,shopping,gift shops,shopping, 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)
ChIJCSJl94TWvlQREomJorJy4EM	Juniper Junction	9269 NE Crooked River Dr, Terrebonne, OR 97760, USA	44.3606790	-121.1385610	10,188 m		shopping	establishment,food,point_of_interest,store	Page \| Maps		View Hours Monday: 12:00 – 6:00 PM Tuesday: 12:00 – 6:00 PM Wednesday: 12:00 – 6:00 PM Thursday: 12:00 – 6:00 PM Friday: 12:00 – 6:00 PM Saturday: 12:00 – 6:00 PM Sunday: 12:00 – 6: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,hiking,mountain biking,trailheads, mountain biking, trailheads	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	412 SW Evergreen Ave, Redmond, OR 97756, USA	44.2723180	-121.1724450	122 m		bars, bars,pubs,juice bars,breakfast,juice bars,breakfast, breakfast, juice bars, pubs	establishment,food,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: 9:00 AM – 3:00 PM	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)