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: 9
Limit per Page: 25
Offset: 200
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 200, 25

Previous Next

Page 9 of 26

Showing 201 to 225 of 645 results

Place ID	Name	Address	Latitude	Longitude	Distance	Category	Search Term	Types	Links	Phone	Hours	Photos
ChIJI_sTxu0tv1QR05vyqwLVLaM	Eagle Crest Resort Ridge Course (edited)	Coopers Hawk Dr, Redmond, OR 97756, USA (edited)	44.2629010	-121.2735520	8,006 m	golf,outdoors,recreation (edited)	golf courses,driving range (edited)	point_of_interest,establishment (edited)	Page \| Maps \| Website (edited)	(541) 923-5002	View Hours Monday: 9:30 AM – 4:00 PM Tuesday: 9:30 AM – 4:00 PM Wednesday: 9:30 AM – 4:00 PM Thursday: 9:30 AM – 4:00 PM Friday: 9:30 AM – 4:00 PM Saturday: 9:30 AM – 4:00 PM Sunday: 9:30 AM – 4:00 PM	View Photos (4)
ChIJj5QTJGopv1QRvjAqvzGZE2s	Eagle Rock	8825 NW 93rd Ln, Terrebonne, OR 97760, USA	44.3602440	-121.2859710	13,206 m		tourist attraction	establishment,point_of_interest,tourist_attraction	Page \| Maps			View Photos (4)
ChIJy8Q_gtAqv1QRVj8E-FG27rA	Eberhards Dairy Products	235 SW Evergreen Ave, Redmond, OR 97756, USA	44.2731770	-121.1707250	262 m		desserts	establishment,food,point_of_interest	Page \| Maps \| Website	(541) 548-5181	View Hours Monday: 8:00 AM – 4:00 PM Tuesday: 8:00 AM – 4:00 PM Wednesday: 8:00 AM – 4:00 PM Thursday: 8:00 AM – 4:00 PM Friday: 8:00 AM – 4:00 PM Saturday: Closed Sunday: Closed	View Photos (4)
ChIJ–OMvOUqv1QRxDA_TpPutb8	Edward Jones – Financial Advisor: Joshua M Werner	655 NW Greenwood Ave #4, Redmond, OR 97756, USA	44.2823990	-121.1749780	1,091 m		markets	establishment,finance,point_of_interest	Page \| Maps \| Website	(541) 923-7773	View Hours Monday: 7:30 AM – 4:00 PM Tuesday: 7:30 AM – 4:00 PM Wednesday: 7:30 AM – 4:00 PM Thursday: 7:30 AM – 4:00 PM Friday: 7:30 AM – 4:00 PM Saturday: Closed Sunday: Closed	View Photos (2)
ChIJH4VhWx0rv1QRAoTZdYKpdZY	El ChangoLeon Mexican food	639 SW 8th St, Redmond, OR 97756, USA	44.2708060	-121.1767190	301 m		food trucks, food trucks,restaurants,lunch,family friendly	establishment,food,point_of_interest,restaurant	Page \| Maps	(541) 699-9930	View Hours Monday: 11:00 AM – 5:00 PM Tuesday: 10:00 AM – 7:00 PM Wednesday: 11:00 AM – 7:30 PM Thursday: 11:00 AM – 7:30 PM Friday: 11:00 AM – 7:30 PM Saturday: 10:30 AM – 7:30 PM Sunday: Closed	View Photos (4)
ChIJdcoUlc4rv1QRI_QYB1G2qbY	El imperio	245 SW 6th St, Redmond, OR 97756, USA	44.2748110	-121.1744290	247 m		food trucks, food trucks,restaurants,lunch,dining,family friendly	establishment,food,point_of_interest,restaurant	Page \| Maps	(541) 325-6415	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 – 9:00 PM Saturday: 11:00 AM – 9:00 PM Sunday: 11:00 AM – 8:00 PM	View Photos (4)
ChIJSUDCDjUrv1QRq1GRLrBr2qg	El Patron Mexican Kitchen	1555 NW 6th St, Redmond, OR 97756, USA	44.2906330	-121.1744750	2,003 m		food trucks, lunch	establishment,food,point_of_interest,restaurant	Page \| Maps	(541) 279-3955	View Hours Monday: 9:00 AM – 7:00 PM Tuesday: 9:00 AM – 7:00 PM Wednesday: 9:00 AM – 7:00 PM Thursday: 9:00 AM – 7:00 PM Friday: 9:00 AM – 7:00 PM Saturday: 9:00 AM – 2:00 PM Sunday: Closed	View Photos (4)
ChIJW3U8vGcrv1QRKpwH0atxfkg	El Tortellini	404 SW Forest Ave, Redmond, OR 97756, USA	44.2714210	-121.1723200	185 m		food trucks, food trucks,restaurants	establishment,food,point_of_interest,restaurant	Page \| Maps	(541) 527-9979	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)
ChIJyUpoEP8rv1QR4b9BGaJHULY	Element Chiropractic	875 SW Rimrock Way Ste 103, Redmond, OR 97756, USA	44.2688360	-121.1920050	1,500 m		massage	establishment,health,point_of_interest	Page \| Maps \| Website	(541) 316-6010	View Hours Monday: 9:00 AM – 6:00 PM 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)
ChIJgycusK8rv1QRQXAnqnplqrc	Elements Market	1857 NW 6th St, Redmond, OR 97756, USA	44.2935100	-121.1745350	2,323 m		dining	establishment,food,point_of_interest,restaurant	Page \| Maps		View Hours Monday: 7:00 AM – 10:00 PM Tuesday: 7:00 AM – 10:00 PM Wednesday: 7:00 AM – 10:00 PM Thursday: 7:00 AM – 10:00 PM Friday: 7:00 AM – 10:00 PM Saturday: 7:00 AM – 10:00 PM Sunday: 7:00 AM – 10:00 PM	View Photos (3)
ChIJcUAD4bQrv1QR4XdfTCThkjE	Elements Public House	lunch (edited)	44.2934270	-121.1744270	2,314 m	restaurants,beer-wine-spirits (edited)	restaurants (edited)	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	dining (edited)	View Hours Monday: 3:00 – 9:00 PM Tuesday: 3:00 – 9:00 PM Wednesday: 3:00 – 9:00 PM Thursday: 3:00 – 9:00 PM Friday: 3:00 – 9:00 PM Saturday: 3:00 – 9:00 PM Sunday: 3:00 – 9:00 PM	View Photos (4)
ChIJ-3UW297VuFQRMBODBRjq4uE	Enterprise Rent-A-Car	3113 S Hwy 97 STE 105, Redmond, OR 97756, USA	44.2479830	-121.1885370	2,977 m		car rentals	car_rental,establishment,point_of_interest	Page \| Maps \| Website	(541) 699-3134	View Hours Monday: 8:00 AM – 6:00 PM Tuesday: 8:00 AM – 6:00 PM Wednesday: 8:00 AM – 6:00 PM Thursday: 8:00 AM – 6:00 PM Friday: 8:00 AM – 6:00 PM Saturday: Closed Sunday: Closed	View Photos (4)
ChIJI8dU-Nkqv1QRk_nFF7gUCeQ	Enterprise Rent-A-Car	2522 Jesse Butler Cir, Redmond, OR 97756, USA	44.2531150	-121.1607320	2,410 m		car rentals	car_rental,establishment,point_of_interest	Page \| Maps \| Website	(833) 827-6502	View Hours Monday: 8:00 AM – 12:30 AM Tuesday: 8:00 AM – 12:30 AM Wednesday: 8:00 AM – 12:30 AM Thursday: 8:00 AM – 12:30 AM Friday: 8:00 AM – 12:30 AM Saturday: 8:00 AM – 12:30 AM Sunday: 8:00 AM – 12:30 AM	View Photos (4)
ChIJOW2XIbPUuFQR08Icq0R1NME	Events By Design, Event Rentals of Oregon	2615 SW 30th St, Redmond, OR 97756, USA	44.2518730	-121.2033700	3,290 m		event venues	establishment,home_goods_store,point_of_interest,store	Page \| Maps \| Website	(541) 903-2139	View Hours Monday: 7:00 AM – 10:00 PM Tuesday: 7:00 AM – 10:00 PM Wednesday: 7:00 AM – 10:00 PM Thursday: 7:00 AM – 10:00 PM Friday: 7:00 AM – 10:00 PM Saturday: 7:00 AM – 10:00 PM Sunday: 7:00 AM – 10:00 PM	View Photos (4)
ChIJfwqxzNsqv1QRIEjigKAaNRM	Every Bloom’n Thing	251 SW 6th St, Redmond, OR 97756, USA	44.2750350	-121.1744570	272 m		gift shops	establishment,florist,point_of_interest,store	Page \| Maps \| Website	(541) 504-9777	View Hours Monday: 10:00 AM – 4:00 PM Tuesday: 10:00 AM – 4:00 PM Wednesday: 10:00 AM – 4:00 PM Thursday: 10:00 AM – 4:00 PM Friday: 10:00 AM – 4:00 PM Saturday: Closed Sunday: Closed	View Photos (4)
ChIJfd4jwJnUuFQRGAPvzIvPFMw	Expo Center RV Park (edited)	4690 SW 19th St, Redmond, OR 97756, USA (edited)	44.2336370	-121.1881630	4,481 m	rv-parks-camping (edited)	rv parks (edited)	rv_park,lodging,point_of_interest,establishment (edited)	Page \| Maps \| Website (edited)	(541) 585-1569	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)
ChIJL8JWIx8rv1QRghnnBa2wimU	Fairhaven City Park	370 NW 23rd St, Redmond, OR 97756, USA	44.2776290	-121.1949680	1,766 m		parks, parks,playgrounds	establishment,park,point_of_interest	Page \| Maps	(541) 548-7275	View Hours Monday: 6:30 AM – 8:00 PM Tuesday: 6:30 AM – 8:00 PM Wednesday: 6:30 AM – 8:00 PM Thursday: 6:30 AM – 8:00 PM Friday: 6:30 AM – 8:00 PM Saturday: 6:30 AM – 8:00 PM Sunday: 6:30 AM – 8:00 PM	View Photos (4)
ChIJbcRszS0vv1QRPJ0woaqPeFw	Faith Hope & Charity Vineyards	70450 NW Lower Valley Dr, Terrebonne, OR 97760, USA	44.3447630	-121.3328980	14,979 m	beer-wine-spirits (edited)	vineyards (edited)	establishment,food,point_of_interest	Page \| Maps \| Website	(541) 526-5075	View Hours Monday: 12:00 – 5:00 PM 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: 12:00 – 5:00 PM Sunday: 12:00 – 5:00 PM	View Photos (4)
ChIJA-zUll8rv1QRnbxgiawxBzA	Famous Footwear	367 NW Oak tree Ln SUITE 170, Redmond, OR 97756, USA	44.2946210	-121.1713260	2,455 m		shopping	establishment,point_of_interest,shoe_store,store	Page \| Maps \| Website	(541) 604-3116	View Hours Monday: 10:00 AM – 8:00 PM Tuesday: 10:00 AM – 8:00 PM Wednesday: 10:00 AM – 8:00 PM Thursday: 10:00 AM – 8:00 PM Friday: 10:00 AM – 8:00 PM Saturday: 10:00 AM – 8:00 PM Sunday: 10:00 AM – 6:00 PM	No photos available
ChIJ872DeEWxuFQRZrbIFmucvng	Farewell Trail	Oregon 97703, USA	44.0385810	-121.5646660	40,607 m		mountain biking	establishment,point_of_interest	Page \| Maps \| Website		View Hours Monday: 5:30 AM – 8:00 PM Tuesday: 5:30 AM – 8:00 PM Wednesday: 5:30 AM – 8:00 PM Thursday: 5:30 AM – 8:00 PM Friday: 5:30 AM – 8:00 PM Saturday: 7:00 AM – 7:00 PM Sunday: 7:00 AM – 7:00 PM	View Photos (2)
ChIJv55JZ5jUuFQRNsyaDnusRDE	Farm To Friends Country Markets	2122 SW Deerhound Ave # 5, Redmond, OR 97756, USA	44.2351350	-121.1918150	4,405 m		markets, meat markets	establishment,food,grocery_or_supermarket,health,point_of_interest,store	Page \| Maps	(541) 526-7201		View Photos (4)
ChIJOYjHWdAqv1QRs1kl_odTSZo	Farmers Cooperative Antiques (edited)	106 SE Evergreen Ave # A, Redmond, OR 97756, USA (edited)	44.2724420	-121.1685410	429 m	market-farms, shopping (edited)	antiques,vintage (edited)	home_goods_store,store,point_of_interest,establishment (edited)	Page \| Maps	(541) 548-7975	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: 10:00 AM – 5:00 PM	View Photos (4)
ChIJm6PR1GUrv1QR73Esk_rHfyk	Feast Food Company	546 NW 7th St, Redmond, OR 97756, USA	44.2807790	-121.1750780	912 m		bars, cocktails, cocktails,live music,cocktails,live music,food trucks,restaurants,lunch,dining,family friendly, dining, food trucks, live music, lunch, pubs, restaurants	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 923-0170	View Hours Monday: 11:00 AM – 8:30 PM Tuesday: Closed Wednesday: Closed Thursday: 11:00 AM – 8:30 PM Friday: 11:00 AM – 8:30 PM Saturday: 11:00 AM – 8:30 PM Sunday: 10:00 AM – 8:30 PM	View Photos (4)
ChIJEbI7pA3WvlQRz4ArcQtS0os	Fergusons Market	8150 US-97, Terrebonne, OR 97760, USA	44.3501890	-121.1782580	8,632 m		markets,grocery stores	convenience_store,establishment,food,liquor_store,point_of_interest,store	Page \| Maps \| Website	(541) 923-0729	View Hours Monday: 5:00 AM – 8:00 PM Tuesday: 5:00 AM – 8:00 PM Wednesday: 5:00 AM – 8:00 PM Thursday: 5:00 AM – 8:00 PM Friday: 5:00 AM – 8:00 PM Saturday: 5:00 AM – 8:00 PM Sunday: 6:00 AM – 7:00 PM	View Photos (4)
ChIJkRycFiUrv1QRA-wuAFCXR6c	Fiesta Mazatlan Family Mexican Restaurant	905 SW Rimrock Way, Redmond, OR 97756, USA	44.2681180	-121.1930980	1,607 m		lunch	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 548-1595	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 – 9:00 PM Saturday: 11:00 AM – 9:00 PM Sunday: 11:00 AM – 9:00 PM	View Photos (4)