Data

Debug Info (admin only)

Search Criteria:

Keyword: None
Categories: None
Search Terms: None
Types: None
Show Unpublished: Yes
Sort: formatted_address
Order: ASC

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 COALESCE(e.address, p.formatted_address) ASC 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
ChIJBUQjQ2srv1QRayFkvHI_ges	LA CHOZA LATIN CUISINE	lunch (edited)	44.2712790	-121.1767310	269 m	restaurants (edited)	restaurants (edited)	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	dining (edited)	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 – 11:00 PM Saturday: 11:00 AM – 11:00 PM Sunday: 11:00 AM – 9:00 PM	View Photos (4)
ChIJMfJSB_0rv1QR2XGtF_6DoLs	Goody’s Ice Cream Food Cart	@ General Duffy’s Waterhole, 404 SW Forest Ave, Redmond, OR 97756, USA	44.2714210	-121.1723200	185 m		desserts	establishment,food,point_of_interest,store	Page \| Maps \| Website	(541) 385-7085	View Hours Monday: 3:30 – 8:00 PM Tuesday: 3:30 – 8:00 PM Wednesday: 3:30 – 8:00 PM Thursday: 3:30 – 8:00 PM Friday: 3:30 – 8:00 PM Saturday: 12:30 – 8:00 PM Sunday: 12:30 – 8:00 PM	No photos available
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)
ChIJJel20Skrv1QRrn0MaqlJ9aA	Towne Center	101 SW Indian Ave, Redmond, OR 97756, USA	44.2679930	-121.1780970	613 m		shopping	establishment,point_of_interest,shopping_mall	Page \| Maps			No photos available
ChIJ23fwBZ_XvlQRMoyyETobSoY	Lower Gorge (West)	10100 NE Crooked River Dr, Terrebonne, OR 97760, USA	44.3673270	-121.1306470	11,079 m		rock climbing	establishment,point_of_interest	Page \| Maps			No photos available
ChIJF5aY71vXvlQREFMtragTlMk	Asterisk Observatory @ The Spot	10136 NE Crooked River Dr, Terrebonne, OR 97760, USA	44.3680890	-121.1327250	11,110 m		tourist attraction	establishment,point_of_interest,tourist_attraction	Page \| Maps \| Website			View Photos (4)
ChIJ2duG4fEqv1QRuOdOz8cwD8I	Paul Hathaway Memorial Park	1021 NW Rockcrest Ct, Redmond, OR 97756, USA	44.2906730	-121.1800210	2,065 m	outdoors	parks, point-of-interest	establishment,park,point_of_interest	Page \| Maps		View Hours Monday: 6:30 AM – 9:00 PM Tuesday: 6:30 AM – 9:00 PM Wednesday: 6:30 AM – 9:00 PM Thursday: 7:00 AM – 9:30 PM Friday: 6:30 AM – 9:00 PM Saturday: 6:30 AM – 9:00 PM Sunday: 6:30 AM – 9:00 PM	View Photos (4)
ChIJeQv5HCgrv1QRkw7opOoGuuo	La Posada Mexican Grill	1029 SW Highland Ave, Redmond, OR 97756, USA	44.2697460	-121.1789850	515 m		breakfast, restaurants	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 923-7448	View Hours Monday: 7:00 AM – 12:00 AM Tuesday: 7:00 AM – 12:00 AM Wednesday: 7:00 AM – 12:00 AM Thursday: 7:00 AM – 12:00 AM Friday: 7:00 AM – 1:00 AM Saturday: 7:00 AM – 12:00 AM Sunday: 7:00 AM – 12:00 AM	View Photos (4)
ChIJq4LmROkqv1QRlXojK1yuw7w	Sno-Cap Drive In Redmond	1053 NW 6th St, Redmond, OR 97756, USA	44.2863570	-121.1743480	1,528 m		bars, desserts, food trucks, lunch, pubs, restaurants	establishment,food,point_of_interest,restaurant,store	Page \| Maps \| Website	(541) 548-2343	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)
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)
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)
ChIJKxby4dkqv1QRgXSRB6Ahtdc	Geek Geek Nerd Nerd	106 SE Evergreen Ave Suite J, Redmond, OR 97756, USA	44.2716900	-121.1679500	487 m		shopping	book_store,establishment,point_of_interest,store	Page \| Maps	(541) 527-4987	View Hours Monday: 11:00 AM – 7:00 PM Tuesday: 11:00 AM – 7:00 PM Wednesday: 11:00 AM – 7:00 PM Thursday: 11:00 AM – 7:00 PM Friday: 11:00 AM – 7:00 PM Saturday: 11:00 AM – 7:00 PM Sunday: 11:00 AM – 7:00 PM	View Photos (4)
ChIJ_THn_9kqv1QRWktUgL14nsg	Redmond Antique Mall	106 SE Evergreen Ave Suite M, Redmond, OR 97756, USA	44.2717110	-121.1682150	465 m		antiques, shopping, vintage	establishment,furniture_store,home_goods_store,point_of_interest,store	Page \| Maps \| Website	(541) 548-6208	View Hours Monday: 10:30 AM – 5:30 PM Tuesday: 10:30 AM – 5:30 PM Wednesday: 10:30 AM – 5:30 PM Thursday: 10:30 AM – 5:30 PM Friday: 10:30 AM – 5:30 PM Saturday: 10:30 AM – 5:30 PM Sunday: 11:00 AM – 4:00 PM	View Photos (4)
ChIJOYjHWdAqv1QRrJQoj6YZVDc	J C’s Java & Such	106 SE Evergreen Ave, Redmond, OR 97756, USA	44.2720410	-121.1680790	470 m		coffee shops	cafe,food,point_of_interest,store,establishment	Page \| Maps		View Hours Monday: 7:00 AM – 6:00 PM Tuesday: 7:00 AM – 6:00 PM Wednesday: 7:00 AM – 6:00 PM Thursday: 7:00 AM – 6:00 PM Friday: 7:00 AM – 6:00 PM Saturday: 7:00 AM – 6:00 PM Sunday: Closed	No photos available
ChIJcW-Sam0rv1QR9ECnVg5Zqlo	Sunshine Wellness	1060 SE Lake Rd, Redmond, OR 97756, USA	44.2663330	-121.1681220	838 m		wellness center	establishment,health,point_of_interest,spa	Page \| Maps	(541) 678-2826		No photos available
ChIJfxr-X9Qqv1QR_Tu1SzmVBMU	Renew Esthetics & Med Spa	1060 SE Lake Rd, Redmond, OR 97756, USA	44.2666660	-121.1682430	802 m		spas	establishment,health,point_of_interest,spa	Page \| Maps \| Website	(541) 548-4720	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)
ChIJod7ssvIsv1QRq_2BxehEP6Y	Eagle Crest Putting Course	1100 Red Wing Loop, Redmond, OR 97756, USA	44.2628250	-121.2739640	8,040 m		driving range, golf lessons	establishment,point_of_interest	Page \| Maps \| Website	(541) 923-5002	View Hours Monday: 8:00 AM – 6:30 PM Tuesday: 8:00 AM – 6:30 PM Wednesday: 8:00 AM – 6:30 PM Thursday: 8:00 AM – 6:30 PM Friday: 8:00 AM – 6:30 PM Saturday: 8:00 AM – 6:30 PM Sunday: 8:00 AM – 6:30 PM	View Photos (4)
ChIJ7yQIS9Qqv1QRUn8Lz5jV6gk	1100 SE Lake Rd	1100 SE Lake Rd, Redmond, OR 97756, USA	44.2670920	-121.1707110	666 m	outdoors (edited)	fishing (edited)	premise,street_address	Page \| Maps			View Photos (4)
ChIJrXpiFPDWvlQRG-3o3C_xDZc	Ranch at the Canyons	11050 Vineyard Way, Terrebonne, OR 97760, USA	44.3671610	-121.1576830	10,592 m	beer-wine-spirits (edited)	wine bar (edited)	establishment,point_of_interest	Page \| Maps \| Website	(541) 923-6020	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)
ChIJ8QthECgrv1QRCEBuWDpd6-U	Loco Place	1106 SW Highland Ave, Redmond, OR 97756, USA	44.2693550	-121.1797660	590 m		desserts, food trucks	establishment,food,meal_takeaway,point_of_interest,restaurant,store	Page \| Maps	(541) 527-1238	View Hours Monday: Closed 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 – 8:00 PM	View Photos (4)
ChIJE9K9gdsqv1QRQQmSt2mPfcE	Cornucopia Natural Foods	111 NW 6th St, Redmond, OR 97756, USA	44.2767510	-121.1745930	462 m		farmers markets, grocery stores, markets, shopping	establishment,food,health,point_of_interest,store	Page \| Maps \| Website	(541) 548-5911	View Hours Monday: 9:30 AM – 5:30 PM Tuesday: 9:30 AM – 5:30 PM Wednesday: 9:30 AM – 5:30 PM Thursday: 9:30 AM – 5:30 PM Friday: 9:30 AM – 5:30 PM Saturday: 10:00 AM – 5:00 PM Sunday: Closed	View Photos (4)
ChIJfcCSV-kqv1QR6Aju_KN3Fw0	Hub Motel	1128 NW 6th St, 1154 NW 6th St, Redmond, OR 97756, USA	44.2868200	-121.1736330	1,579 m		hotels	establishment,lodging,point_of_interest	Page \| Maps \| Website	(800) 784-3482		View Photos (4)
ChIJd05pv-krv1QRBoxRKH3-XKs	Desert Sky Massage Therapy	1129 SW 12th St, Redmond, OR 97756, USA	44.2661270	-121.1810280	917 m		massage	establishment,point_of_interest	Page \| Maps \| Website	(541) 699-1441		View Photos (4)
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)
ChIJCaAUkZM2uVQR3X4w_RRLZJ0	Ochoco Lake County Campgrounds	11700 N E Ochoco Hwy, Prineville, OR 97754, USA	44.3059710	-120.7010510	37,821 m		campgrounds, koa	campground,establishment,lodging,park,point_of_interest	Page \| Maps \| Website	(541) 447-2599		View Photos (4)