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

Previous Next

Page 4 of 26

Showing 76 to 100 of 645 results

Place ID	Name	Address	Latitude	Longitude	Distance	Category	Search Term	Types	Links	Phone	Hours	Photos
ChIJJYnfUdDXuFQR-nMNxUdxPoM	Brasada Trails	17037 Alfalfa Rd, Powell Butte, OR 97753, USA	44.1486560	-121.0434780	17,265 m		horseback rides	establishment,point_of_interest,travel_agency	Page \| Maps \| Website		View Hours Monday: Closed Tuesday: Closed Wednesday: 8:00 AM – 4:00 PM Thursday: 8:00 AM – 4:00 PM Friday: 8:00 AM – 4:00 PM Saturday: 8:00 AM – 4:00 PM Sunday: 8:00 AM – 4:00 PM	View Photos (4)
ChIJuZ8YboPHuFQROznIv3AYyno	Brewery Planning	1335 NW 16th Ct, Redmond, OR 97756, USA	44.2883780	-121.1857890	1,991 m		brewery, brewery,microbrewery	establishment,point_of_interest	Page \| Maps \| Website	(559) 860-9998	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: Closed Sunday: Closed	View Photos (4)
ChIJqw1sTPXWvlQRfaqteR3Q9L8	Brian Thomas Complete Horsemanship, LLC	20890A NW Butler Rd, Terrebonne, OR 97760, USA	44.3615150	-121.1148880	10,944 m		horseback rides	establishment,point_of_interest	Page \| Maps \| Website	(208) 709-3175		View Photos (4)
ChIJb6k1H9oqv1QRapN-r9Hap6s	Brickhouse	412 SW 6th St, Redmond, OR 97756, USA	44.2733140	-121.1739980	77 m		bars, bars,cocktails,bars,cocktails,nightlife,pubs,restaurants,dining, cocktails, desserts, dining, nightlife, pubs	bar,establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 526-1782	View Hours Monday: 4:00 – 8:00 PM Tuesday: 4:00 – 9:00 PM Wednesday: 4:00 – 9:00 PM Thursday: 4:00 – 9:00 PM Friday: 4:00 – 9:00 PM Saturday: 4:00 – 9:00 PM Sunday: 4:00 – 8:00 PM	View Photos (4)
ChIJN0FwGLwqv1QR7FzFoBRRMOI	BrightSide Animal Center	1355 NE Hemlock Ave, Redmond, OR 97756, USA	44.2841830	-121.1532980	2,085 m		thrift stores	establishment,point_of_interest	Page \| Maps \| Website	(541) 923-0882	View Hours Monday: Closed 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: 10:00 AM – 5:30 PM	View Photos (4)
ChIJheZMTdPUuFQRX4JCePotlSk	BrightSide Animal Center Thrift Store	838 NW 5th St, Redmond, OR 97756, USA	44.2842020	-121.1727440	1,291 m		antiques,thrift stores, thrift stores	establishment,point_of_interest,store	Page \| Maps \| Website	(541) 504-0101	View Hours Monday: Closed Tuesday: 9:00 AM – 5:30 PM Wednesday: 9:00 AM – 5:30 PM Thursday: 9:00 AM – 5:30 PM Friday: 9:00 AM – 5:30 PM Saturday: 9:00 AM – 5:30 PM Sunday: 9:00 AM – 5:30 PM	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
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, bars,cocktails,nightlife,pool tables,bars,cocktails,nightlife,pool tables,pubs, 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)
ChIJHyAWmOEqv1QR5TFPULupyTA	Burton Molly	562 NW 19th Pl, Redmond, OR 97756, USA	44.2813960	-121.1895810	1,583 m		massage	establishment,point_of_interest	Page \| Maps	(541) 923-4706		No photos available
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, hiking,trailheads	establishment,point_of_interest	Page \| Maps			View Photos (4)
ChIJbQ79gMkrv1QRFcQb1PYvwWs	Cares & Whoas Glamour Ranch Décor & Gifts, Redmond	498 SW 6th St Ste 101, Redmond, OR 97756, USA	44.2727240	-121.1739590	12 m		boutiques, boutiques,shopping	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 – 6:00 PM Friday: 10:00 AM – 6:00 PM Saturday: 10:00 AM – 6:00 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)
ChIJ3c6V-t8rv1QRuV2VmGq2AAE	Cascade Alchemy Bowls	308 SW Evergreen Ave, Redmond, OR 97756, USA	44.2722570	-121.1719330	163 m		food trucks, juice bars, juice bars,food trucks,restaurants,breakfast,lunch,dining,family friendly, lunch, restaurants	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website		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 – 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)
ChIJCX__s9cqv1QR1u5PRRinPvI	Cascade Chiropractic & Natural Medicine	716 SW Highland Ave, Redmond, OR 97756, USA	44.2693940	-121.1757970	389 m		massage	establishment,health,point_of_interest	Page \| Maps \| Website	(541) 516-1045	View Hours Monday: 8:00 AM – 5:00 PM Tuesday: 8:00 AM – 5:00 PM Wednesday: 8:00 AM – 5:00 PM Thursday: 8:00 AM – 5:00 PM Friday: Closed Saturday: Closed Sunday: Closed	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, pubs,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, bars,cocktails,nightlife,bars,cocktails,nightlife,pubs,brewery,microbrewery,restaurants,lunch,dining,family friendly, 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 – 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)
ChIJrf19ZDksv1QRoLYRcEXyfCw	Cascade View Trailhead	Eagle Crest Blvd, Redmond, OR 97756, USA	44.2872050	-121.3134920	11,229 m		hiking, hiking,mountain biking,trailheads, mountain biking	establishment,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	(541) 316-5770	View Hours Monday: 6:30 AM – 4:00 PM Tuesday: 6:30 AM – 4:00 PM Wednesday: 6:30 AM – 4:00 PM Thursday: 6:30 AM – 4:00 PM Friday: 6:30 AM – 4:00 PM Saturday: 8:00 AM – 2:00 PM Sunday: 8:00 AM – 2:00 PM	View Photos (4)