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: 4
Limit per Page: 25
Offset: 75
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 75, 25

Previous Next

Page 4 of 24

Showing 76 to 100 of 583 results

Place ID	Name	Address	Latitude	Longitude	Distance	Category	Search Term	Types	Links	Phone	Hours	Photos
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
ChIJDzmb9NjUuFQRPjmIHnjQ4IA	Budget Car Rental	2522 Jesse Butler Cir, Redmond, OR 97756, USA	44.2535740	-121.1595690	2,407 m		car rentals	car_rental,establishment,point_of_interest	Page \| Maps \| Website	(541) 923-0699	View Hours Monday: 8:30 AM – 12:30 AM Tuesday: 8:30 AM – 12:30 AM Wednesday: 8:30 AM – 12:30 AM Thursday: 8:30 AM – 12:30 AM Friday: 8:30 AM – 12:30 AM Saturday: 9:00 AM – 12:30 AM Sunday: 9:00 AM – 12:30 AM	View Photos (4)
ChIJgR1QaCgrv1QRj4Af08YkfXE	Bunker Bar	704 SW 8th St, Redmond, OR 97756, USA	44.2704570	-121.1761880	301 m		bars, cocktails, live music, nightlife, pool tables, pubs	bar,establishment,point_of_interest	Page \| Maps	(541) 548-5688	View Hours Monday: 2:00 – 8:00 PM Tuesday: 2:00 – 8:00 PM Wednesday: 2:00 – 8:00 PM Thursday: 2:00 – 8:00 PM Friday: 2:00 – 8:00 PM Saturday: 2:00 – 8:00 PM Sunday: Closed	View Photos (4)
ChIJOTPIFsnUuFQRKZqq6nMZG1Q	Burger King	1512 SW Odem Medo Rd, Redmond, OR 97756, USA	44.2517930	-121.1855050	2,493 m		breakfast	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 548-0328	View Hours Monday: 6:00 AM – 12:00 AM Tuesday: 6:00 AM – 12:00 AM Wednesday: 6:00 AM – 12:00 AM Thursday: 6:00 AM – 12:00 AM Friday: 6:00 AM – 12:00 AM Saturday: 6:00 AM – 12:00 AM Sunday: 7:00 AM – 12:00 AM	View Photos (4)
ChIJC-6sWqErv1QRKfxsJE7BpwQ	Burger Wild	332 SW 5th St Suit 1, Redmond, OR 97756, USA	44.2740610	-121.1729140	179 m		food trucks, live music	establishment,food,point_of_interest,restaurant	Page \| Maps	(541) 678-2388	View Hours Monday: Closed Tuesday: Closed Wednesday: 11:00 AM – 10: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 – 10:00 PM	View Photos (4)
ChIJ2-5bgcrVuFQRDqqYrr1ihD0	buy2 Stores – Redmond	1846 S Hwy 97, Redmond, OR 97756, USA	44.2585430	-121.1792500	1,622 m		desserts, grocery stores, juice bars	convenience_store,establishment,food,point_of_interest,store	Page \| Maps \| Website	(541) 228-9352	View Hours Monday: 6:00 AM – 11:00 PM Tuesday: 6:00 AM – 11:00 PM Wednesday: 6:00 AM – 11:00 PM Thursday: 6:00 AM – 11:00 PM Friday: 6:00 AM – 11:00 PM Saturday: 7:00 AM – 11:00 PM Sunday: 7:00 AM – 10:00 PM	View Photos (4)
ChIJuypAYvYrv1QRz65l5kO6w34	Canyon Ridge Community Park	1397 NW Varnish Ave, Redmond, OR 97756, USA	44.3070350	-121.1835530	3,903 m		parks	establishment,park,point_of_interest	Page \| Maps			View Photos (4)
ChIJ7bibtKHXvlQR3oWFs0yk6Q0	Canyon Trail Trailhead	9930 NE Crooked River Dr, Terrebonne, OR 97760, USA	44.3668140	-121.1362950	10,893 m		hiking	establishment,park,point_of_interest	Page \| Maps			View Photos (4)
ChIJbQ79gMkrv1QRFcQb1PYvwWs	Cares & Whoas Glamour Ranch Décor & Gifts, Redmond	498 SW 6th St Suite 101, Redmond, OR 97756, USA	44.2727240	-121.1739590	12 m		boutiques	clothing_store,establishment,point_of_interest,store	Page \| Maps \| Website	(541) 645-3908	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: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)
ChIJ95ZkFsjUuFQRbWIIrAykI00	Carl’s Jr.	2905 S Hwy 97 STE 100, Redmond, OR 97756, USA	44.2495060	-121.1870070	2,773 m		lunch	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 548-5553	View Hours Monday: 6:00 AM – 12:00 AM Tuesday: 6:00 AM – 12:00 AM Wednesday: 6:00 AM – 12:00 AM Thursday: 6:00 AM – 12:00 AM Friday: 6:00 AM – 12:00 AM Saturday: 6:00 AM – 12:00 AM Sunday: 6:00 AM – 12:00 AM	View Photos (4)
ChIJAXVuQOcrv1QRQTf9OUOBUNw	Carnaval Mexican Grill	343 SW 6th St, Redmond, OR 97756, USA	44.2738830	-121.1745700	150 m		cocktails, restaurants	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 316-6960	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 – 10:00 PM Saturday: 11:00 AM – 10:00 PM Sunday: 11:00 AM – 9:00 PM	View Photos (4)
ChIJP_ygWJjUuFQRCB1sYmwIub0	Caruso Produce Inc. – High Desert	4585 SW 21st St STE 101, Redmond, OR 97756, USA	44.2346950	-121.1918690	4,453 m		farmers markets, grocery stores, markets	establishment,food,point_of_interest,store	Page \| Maps \| Website	(541) 923-3003	View Hours Monday: 6:00 AM – 4:00 PM Tuesday: 6:00 AM – 4:00 PM Wednesday: 6:00 AM – 4:00 PM Thursday: 6:00 AM – 4:00 PM Friday: 6:00 AM – 4:00 PM Saturday: 6:00 AM – 3:00 PM Sunday: Closed	View Photos (1)
ChIJ3c6V-t8rv1QRuV2VmGq2AAE	Cascade Alchemy Bowls	308 SW Evergreen Ave, Redmond, OR 97756, USA	44.2722570	-121.1719330	163 m		food trucks, juice bars, lunch, restaurants	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website		View Hours Monday: 11:00 AM – 6:00 PM Tuesday: 11:00 AM – 8: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 – 8:00 PM Sunday: 11:00 AM – 6:00 PM	View Photos (4)
ChIJIbiYuo0rv1QRxaGV5g9o5Jg	Cascade Hop Farm, LLC	7648 NW Poplar Dr, Redmond, OR 97756, USA	44.2929980	-121.2614930	7,330 m		farms	establishment,point_of_interest	Page \| Maps	(530) 520-2061	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: Closed Sunday: Closed	View Photos (4)
ChIJsaeU5yRYx1QRsk9oajNEs-8	Cascade Lakes	Cascade Lakes, Oregon 97413, USA	43.9000000	-121.8000000	64,940 m	outdoors	point-of-interest	establishment,natural_feature	Page \| Maps			No photos available
ChIJIVMX2dbUuFQRjvs9lAM0rms	Cascade Lakes Brewing Company Production Facility	2141 S 1st St, Redmond, OR 97756, USA	44.2559950	-121.1690650	1,889 m		brewery, microbrewery	establishment,food,point_of_interest	Page \| Maps \| Website	(541) 923-3110	View Hours Monday: 9:00 AM – 3:00 PM Tuesday: 9:00 AM – 3:00 PM Wednesday: 9:00 AM – 3:00 PM Thursday: 9:00 AM – 3:00 PM Friday: 9:00 AM – 3:00 PM Saturday: Closed Sunday: Closed	View Photos (4)
ChIJSV_XNdYqv1QRBozho0XC10k	Cascade Lakes Pub at 7th St	855 SW 7th St, Redmond, OR 97756, USA	44.2687760	-121.1757060	450 m		bars, brewery, cocktails, live music, lunch, microbrewery, nightlife, pubs, restaurants	bar,establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 923-1795	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 – 9:00 PM Saturday: 11:00 AM – 9:00 PM Sunday: 11:00 AM – 8:00 PM	View Photos (4)
ChIJrf19ZDksv1QRoLYRcEXyfCw	Cascade View Trailhead	Eagle Crest Blvd, Redmond, OR 97756, USA	44.2872050	-121.3134920	11,229 m		hiking, mountain biking	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)
ChIJQ46dCckrv1QR5606ebwyuuY	Casee’s Coffee	106 SE Evergreen Ave ste b, Redmond, OR 97756, USA	44.2723610	-121.1680570	468 m		coffee shops	cafe,establishment,food,point_of_interest,store	Page \| Maps		View Hours Monday: 6:30 AM – 2:00 PM Tuesday: 6:30 AM – 2:00 PM Wednesday: 6:30 AM – 2:00 PM Thursday: 6:30 AM – 2:00 PM Friday: 6:30 AM – 2:00 PM Saturday: Closed Sunday: 8:00 AM – 2:00 PM	View Photos (4)
ChIJR71vGUfVuFQRxfoI_oXTxkk	Cassity’s Bar	2498 S Hwy 97, Redmond, OR 97756, USA	44.2525650	-121.1830280	2,345 m		nightlife, pubs	bar,establishment,point_of_interest	Page \| Maps \| Website			No photos available
ChIJaW1j0iskuVQReHJK9ifONIo	Castle Rock Campground	Castle Rock Campground Rd, Prineville, OR 97754, USA	44.1574640	-120.8348010	29,907 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)
ChIJsb5M9Mgrv1QR9yUd0TKcyMI	Centenial Park	433 SW 8th St, Redmond, OR 97756, USA	44.2727520	-121.1759680	164 m		farmers markets, parks	establishment,park,point_of_interest	Page \| Maps			View Photos (4)
ChIJY4EDyf0rv1QRfao4lObgIRw	Centennial Park	446 SW 9th St, Redmond, OR 97756, USA	44.2728110	-121.1772400	265 m		farmers markets, parks	establishment,park,point_of_interest	Page \| Maps \| Website		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: 10:00 AM – 6:00 PM Sunday: 10:00 AM – 6:00 PM	View Photos (4)
ChIJqW0St6TIuFQRRnJ21RfSg1I	Center Fire Gunworks	460 NE Hemlock Ave ste f, Redmond, OR 97756, USA	44.2832700	-121.1641560	1,417 m		shooting ranges	establishment,point_of_interest,store	Page \| Maps	(541) 633-7377	View Hours Monday: 8:00 – 11:00 AM, 12:00 – 5:00 PM Tuesday: 8:00 – 11:00 AM, 12:00 – 5:00 PM Wednesday: 8:00 – 11:00 AM, 12:00 – 5:00 PM Thursday: Closed Friday: Closed Saturday: Closed Sunday: Closed	View Photos (2)
ChIJwb4ESygrv1QRXRPwlPrWDCs	Central Oregon Eyecare – Redmond	1000 SW Indian Ave, Redmond, OR 97756, USA	44.2682840	-121.1791300	636 m		shopping	doctor,establishment,health,point_of_interest,store	Page \| Maps \| Website	(541) 548-2488	View Hours Monday: 8:00 AM – 1:00 PM, 2:00 – 5:00 PM Tuesday: 8:00 AM – 1:00 PM, 2:00 – 5:00 PM Wednesday: 8:00 AM – 1:00 PM, 2:00 – 5:00 PM Thursday: 8:00 AM – 1:00 PM, 2:00 – 5:00 PM Friday: 8:00 AM – 1:00 PM, 2:00 – 5:00 PM Saturday: Closed Sunday: Closed	View Photos (4)