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: 10
Limit per Page: 25
Offset: 225
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 225, 25

Previous Next

Page 10 of 29

Showing 226 to 250 of 705 results

Place ID	Name	Address	Latitude	Longitude	Distance	Category	Search Term	Types	Links	Phone	Hours	Photos
ChIJH4VhWx0rv1QRAoTZdYKpdZY	El ChangoLeon Mexican food	639 SW 8th St, Redmond, OR 97756, USA	44.2708060	-121.1767190	301 m		family friendly, food trucks, food trucks,restaurants,lunch,family friendly,food trucks, lunch, restaurants	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		dining, family friendly, food trucks, food trucks,restaurants,lunch,dining,family friendly,food trucks,restaurants,lunch,dining,family friendly, lunch, restaurants	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,restaurants, 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 (4)
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: 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)
ChIJ-3UW297VuFQRMBODBRjq4uE	Enterprise Rent-A-Car	3113 S Hwy 97 #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)
ChIJ3VvtEyTHuFQR_APw-xfb2AY	Epic Towing	430 SE Evergreen Ave, Redmond, OR 97756, USA	44.2722920	-121.1656100	663 m		vintage	establishment,locksmith,point_of_interest	Page \| Maps	(541) 306-9831	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)
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,parks,playgrounds, 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)
ChIJkwbEKdkqv1QREK61PdoA9aI	Family-Friendly Redmond Getaway: Walk to Dtwn	Redmond, OR 97756, USA	44.2747960	-121.1804730	575 m		family friendly	establishment,lodging,point_of_interest	Page \| Maps \| Website			No photos available
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,cocktails,live music,pubs,desserts,food trucks, dining, family friendly, 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:00 PM Tuesday: Closed Wednesday: Closed Thursday: 11:00 AM – 8:00 PM Friday: 11:00 AM – 8:00 PM Saturday: 11:00 AM – 8:00 PM Sunday: 10:00 AM – 8:00 PM	View Photos (4)
ChIJEbI7pA3WvlQRz4ArcQtS0os	Fergusons Market	8150 US-97, Terrebonne, OR 97760, USA	44.3501890	-121.1782580	8,632 m		grocery stores, markets, markets,grocery stores,desserts,juice bars,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)
ChIJ3fE9cB_dvlQRT8uZzKhRRqQ	Fin Reapers Bowfishing	305 E Sage Ln, Culver, OR 97734, USA	44.5220270	-121.2070470	27,857 m		fishing	establishment,point_of_interest	Page \| Maps \| Website	(541) 948-7099	View Hours Monday: 7:00 AM – 7:00 PM Tuesday: 7:00 AM – 7:00 PM Wednesday: 7:00 AM – 7:00 PM Thursday: 7:00 AM – 7:00 PM Friday: 7:00 AM – 7:00 PM Saturday: 7:00 AM – 7:00 PM Sunday: 7:00 AM – 7:00 PM	View Photos (4)
ChIJSfDiLh8pv1QRGaSykdvFp_4	Firefly Fields Northwest	3250 NW Odem Ave, Terrebonne, OR 97760, USA	44.3408040	-121.2059060	7,997 m		farms	establishment,point_of_interest	Page \| Maps \| Website	(541) 604-8330	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)