Data

Debug Info (admin only)

Search Criteria:

Keyword: None
Categories: None
Search Terms: None
Types: None
Show Unpublished: Yes
Sort: place_id
Order: DESC

Pagination:

Current Page: 1
Limit per Page: 25
Offset: 0
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 p.place_id DESC LIMIT 0, 25

Page 1 of 24

Showing 1 to 25 of 583 results

Place ID ↓	Name	Address	Latitude	Longitude	Distance	Category	Search Term	Types	Links	Phone	Hours	Photos
ChIJZwSilLvUuFQRrJpyclLAueA	Super 8 by Wyndham Redmond (edited)	3629 SW 21st Pl, Redmond, OR 97756, USA (edited)	44.2427590	-121.1914310	3,601 m	hotels-motels,rv-parks-camping (edited)	hotels,motels (edited)	lodging,point_of_interest,establishment (edited)	Page \| Maps \| Website (edited)	(541) 548-8881	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)
ChIJzwnYIZbUuFQRGhhc1VIitt8	Buckaroo Breakfast	Management, 3800 SE Airport Way, Redmond, OR 97756, USA	44.2381170	-121.1853420	3,943 m		live music	establishment,point_of_interest	Page \| Maps			No photos available
ChIJZwG7UMorv1QR4waKoN6quq8	Big O Bagels	816 SW 17th St, Redmond, OR 97756, USA	44.2691120	-121.1864300	1,070 m		bakeries, breakfast, coffee shops	bakery,cafe,establishment,food,meal_takeaway,point_of_interest,restaurant,store	Page \| Maps \| Website		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: 7:00 AM – 2:00 PM	View Photos (4)
ChIJZVluKAIrv1QR10_B1RNFw-c	Desert Prairie	404 SW 6th St Suite 100, Redmond, OR 97756, USA	44.2734090	-121.1740130	88 m		boutiques, gift shops, shopping	clothing_store,establishment,point_of_interest,store	Page \| Maps \| Website	(541) 527-1887	View Hours Monday: 10:00 AM – 5:30 PM Tuesday: 10:00 AM – 5:30 PM Wednesday: 10:00 AM – 5:30 PM Thursday: 10:00 AM – 5:30 PM Friday: 10:00 AM – 5:30 PM Saturday: 10:00 AM – 5:30 PM Sunday: 11:00 AM – 4:00 PM	View Photos (4)
ChIJzUapk9wqv1QRZ4BT-v_1j3I	Redmond Burger Company	249 NW 6th St, Redmond, OR 97756, USA	44.2780770	-121.1746090	609 m		bars, brewery, food trucks, lunch, pubs, restaurants	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 316-5262	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)
ChIJZf5BqxwFvFQRWHHAosT_saE	Painted Hills	Painted Hills, Oregon 97750, USA	44.6615220	-120.2730730	83,548 m	outdoors	point-of-interest	establishment,natural_feature	Page \| Maps			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)
ChIJzdJ1BcnUuFQRVx4upj1ZXIE	Best Western Plus Rama Inn	2630 SW 17th Pl, Redmond, OR 97756, USA	44.2515600	-121.1859360	2,530 m		hotels, resorts	establishment,lodging,point_of_interest	Page \| Maps \| Website	(541) 548-8080		View Photos (4)
ChIJzd47LvUqv1QRJqG9EjI_VZM	Quince Park	Redmond, OR 97756, USA	44.2985750	-121.1803660	2,931 m		parks	establishment,park,point_of_interest,tourist_attraction	Page \| Maps \| Website	(541) 504-2000	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)
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)
ChIJZ9UPn7DGuFQRJyuNFsdlgnA	Ladies Of Lead Group Therapy, LLC	905 SW Rimrock Way Suite 101A, Redmond, OR 97756, USA	44.2681180	-121.1930980	1,607 m		shooting ranges	establishment,point_of_interest,store	Page \| Maps \| Website	(541) 788-5858	View Hours Monday: Closed Tuesday: 12:00 – 5:00 PM Wednesday: 12:00 – 5:00 PM Thursday: 12:00 – 5:00 PM Friday: 12:00 – 5:00 PM Saturday: Closed Sunday: Closed	View Photos (4)
ChIJZ9b-zHrVuFQRMveL-ZnISEg	Cuportunity Coffee Kiosk	3294 S Hwy 97, Redmond, OR 97756, USA	44.2458880	-121.1884060	3,188 m		coffee shops	cafe,establishment,food,point_of_interest,store	Page \| Maps \| Website		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: Closed Sunday: Closed	View Photos (2)
ChIJZ3cFVukqv1QRd74wbqRltLQ	Regios Cafe	1154 NW 6th St, Redmond, OR 97756, USA	44.2871880	-121.1735910	1,620 m		breakfast, coffee shops	cafe,establishment,food,point_of_interest,restaurant	Page \| Maps	(541) 504-1374	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: 7:00 AM – 2:00 PM	View Photos (3)
ChIJz2i9ZETXvlQRk9DpTmsg9ZY	Brand 44° N	8060 11th St, Terrebonne, OR 97760, USA	44.3490810	-121.1774310	8,507 m		breakfast, lunch	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 316-3280	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: 7:00 AM – 2:00 PM	View Photos (4)
ChIJZ1h4WgDPuFQRMXmbDnhyUg0	The Landing	1865 NW Hemlock Ave, Redmond, OR 97756, USA	44.2842840	-121.1887990	1,756 m		brewery, food trucks	establishment,food,point_of_interest,restaurant	Page \| Maps		View Hours Monday: 11:00 AM – 9:00 PM Tuesday: Closed Wednesday: 11:00 AM – 9:00 PM Thursday: 11:00 AM – 9:00 PM Friday: 12:00 – 10:00 PM Saturday: 12:00 – 10:00 PM Sunday: 12:00 – 9:30 PM	View Photos (4)
ChIJz_POJMjUuFQRRHQZ43jHcc0	Dollar Tree	2925 S Hwy 97 Suite 106, Redmond, OR 97756, USA	44.2497040	-121.1877570	2,776 m		juice bars, shopping	establishment,point_of_interest,store	Page \| Maps \| Website	(971) 439-0388	View Hours Monday: 8:00 AM – 10:00 PM Tuesday: 8:00 AM – 10:00 PM Wednesday: 8:00 AM – 10:00 PM Thursday: 8:00 AM – 10:00 PM Friday: 8:00 AM – 10:00 PM Saturday: 8:00 AM – 10:00 PM Sunday: 8:00 AM – 10:00 PM	View Photos (4)
ChIJYzJh_4Arv1QRqyATOkn2_pE	Rental Center at The Home Depot	300 NW Quince Ave, Redmond, OR 97756, USA	44.2980340	-121.1705030	2,839 m		car rentals	car_rental,establishment,point_of_interest,store	Page \| Maps \| Website	(541) 516-3990	View Hours Monday: 6:00 AM – 10:00 PM Tuesday: 6:00 AM – 10:00 PM Wednesday: 6:00 AM – 10:00 PM Thursday: 6:00 AM – 10:00 PM Friday: 6:00 AM – 10:00 PM Saturday: 6:00 AM – 10:00 PM Sunday: 7:00 AM – 8:00 PM	View Photos (1)
ChIJYyaNu3zTuFQRnDK7MEcG1VI	Bonta Gelato – Redmond Westmount	3750 SW Badger Ave, Redmond, OR 97756, USA	44.2371930	-121.2125430	4,998 m		desserts	establishment,food,point_of_interest,store	Page \| Maps \| Website	(541) 897-9282	View Hours Monday: Closed Tuesday: Closed Wednesday: Closed Thursday: Closed Friday: 3:00 – 9:00 PM Saturday: 1:00 – 9:00 PM Sunday: 1:00 – 8:00 PM	View Photos (4)
ChIJYW3hHADXvlQRXuymABvPYeY	The Zoo Climbing	9VJP+JQ, Terrebonne, OR 97760, USA	44.3815400	-121.1130800	13,042 m		rock climbing	establishment,point_of_interest	Page \| Maps			View Photos (3)
ChIJyW-9FdQrv1QRPNBLen7kSc4	Swan Song Vintage	627 SW Deschutes Ave, Redmond, OR 97756, USA	44.2737210	-121.1749090	145 m		vintage	clothing_store,establishment,point_of_interest,store	Page \| Maps \| Website	(541) 527-4645	View Hours Monday: 11:00 AM – 5:00 PM Tuesday: Closed 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: 11:00 AM – 4:00 PM	View Photos (4)
ChIJYV1_RM7TuFQRYz15OAxCnFU	Fruition Farm Sporthorses	5707 SW Quarry Ave, Redmond, OR 97756, USA	44.2128500	-121.2364400	8,305 m		farms, horseback rides	establishment,point_of_interest	Page \| Maps \| Website	(541) 815-0211	View Hours Monday: 8:00 AM – 5:00 PM Tuesday: 8:00 AM – 5:00 PM Wednesday: Closed Thursday: 8:00 AM – 5:00 PM Friday: 8:00 AM – 5:00 PM Saturday: 8:00 AM – 5:00 PM Sunday: 8:00 AM – 5:00 PM	View Photos (4)
ChIJyUYfxZgrv1QRobNKc04mWw4	The Sanctuary Event Space	307 NW 6th St, Redmond, OR 97756, USA	44.2784660	-121.1746190	652 m		event venues	establishment,point_of_interest	Page \| Maps \| Website	(541) 526-7979	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 – 10:00 PM Saturday: 11:00 AM – 10:00 PM Sunday: 11:00 AM – 8:00 PM	View Photos (4)
ChIJYTsBKn8rv1QRuyCqCBMOX9U	Coffee Depo	Redmond, OR 97756, USA	44.2726660	-121.1739210	5 m		coffee shops	cafe,establishment,food,point_of_interest,store	Page \| Maps			No photos available
ChIJySTPqbHHuFQR8Hx4-ovu45E	Deschutes Gift Baskets offers hand-delivered and shipped gifts for all occasions.	632 SW 6th St ste 1, Redmond, OR 97756, USA	44.2710780	-121.1739630	171 m		gift shops	establishment,point_of_interest,store	Page \| Maps \| Website	(541) 977-1036	View Hours Monday: 10:00 AM – 4:00 PM Tuesday: 10:00 AM – 4:00 PM Wednesday: 11:00 AM – 4:00 PM Thursday: 10:00 AM – 4:00 PM Friday: Closed Saturday: Closed 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)