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: 18
Limit per Page: 25
Offset: 425
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 425, 25

Previous Next

Page 18 of 24

Showing 426 to 450 of 583 results

Place ID	Name	Address	Latitude	Longitude	Distance	Search Term	Types	Links	Phone	Hours	Photos
ChIJjxhSGAArv1QRkdSMLRO0_S4	Redmond Travel center	401 NW Quince Ave, Redmond, OR 97756, USA	44.2986680	-121.1728760	2,898 m	shopping	convenience_store,establishment,food,gas_station,point_of_interest,store	Page \| Maps	(541) 923-0669	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)
ChIJ1Y53bSYrv1QROOjkSB0ukyY	Redmond Wellness and Chiropractic	1655 SW Highland Ave Ste. #6, Redmond, OR 97756, USA	44.2698830	-121.1860610	1,013 m	wellness center	establishment,health,point_of_interest	Page \| Maps \| Website	(541) 923-2019	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 – 4:00 PM Saturday: Closed Sunday: Closed	View Photos (4)
ChIJb8ixGkHSuFQRgPr4q_vF-yM	Redmond–Bend Juniper State Scenic Corridor	Redmond School District 02j, Redmond, OR 97756, USA	44.1842200	-121.2407080	11,178 m	nature preserve	establishment,park,point_of_interest	Page \| Maps			No photos available
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)
ChIJjeBtyuYqv1QRgTDH_-DDLHY	Remington Arms	1515 NW Fir Ave unit 51, Redmond, OR 97756, USA	44.2816150	-121.1863380	1,406 m	rv parks	establishment,lodging,point_of_interest,rv_park	Page \| Maps \| Website	(541) 548-3601	View Hours Monday: 10:00 AM – 4:30 PM Tuesday: 10:00 AM – 4:30 PM Wednesday: 10:00 AM – 4:30 PM Thursday: 10:00 AM – 4:30 PM Friday: 10:00 AM – 4:30 PM Saturday: Closed Sunday: Closed	View Photos (4)
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)
ChIJAQBcwe0qv1QR1L36KxJB07k	Renew Repair Relax	1508 NW 8th St, Redmond, OR 97756, USA	44.2901810	-121.1761640	1,961 m	massage	establishment,point_of_interest	Page \| Maps \| Website	(541) 280-6461		No photos available
ChIJYzJh_4Arv1QRqyATOkn2_pE	Rental Center at The Home Depot	300 NW Quince Ave, Redmond, OR 97756, USA	44.2980340	-121.1705030	2,839 m	car rentals	car_rental,establishment,point_of_interest,store	Page \| Maps \| Website	(541) 516-3990	View Hours Monday: 6:00 AM – 10:00 PM Tuesday: 6:00 AM – 10:00 PM Wednesday: 6:00 AM – 10:00 PM Thursday: 6:00 AM – 10:00 PM Friday: 6:00 AM – 10:00 PM Saturday: 6:00 AM – 10:00 PM Sunday: 7:00 AM – 8:00 PM	View Photos (1)
ChIJ_YHZxDIrv1QR3EdIKd9JPxI	Richard’s Sliders	245 SW 6th St, Redmond, OR 97756, USA	44.2748580	-121.1746800	256 m	food trucks, lunch, restaurants	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 419-8933	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 – 5: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)
ChIJg6w6b9sqv1QR2VUYpIPX3Uc	Rigoberto’s Taco Shop	433 W Antler Ave, Redmond, OR 97756, USA	44.2767630	-121.1728610	468 m	restaurants	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 923-1305	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 – 2:00 AM Saturday: 6:00 AM – 1:00 AM Sunday: 6:00 AM – 12:00 AM	View Photos (4)
ChIJD1NwB_PXuFQR7gyhXzIZx3A	Rim Rock Riders	17037 Alfalfa Rd, Powell Butte, OR 97753, USA	44.1518100	-121.0450210	16,912 m	horseback rides	establishment,point_of_interest	Page \| Maps \| Website	(541) 238-8866	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: 9:00 AM – 5:00 PM Sunday: 9:00 AM – 5:00 PM	View Photos (4)
ChIJO9bp6CUrv1QRFVLllXuFzcU	Rimrock Taphouse	845 SW 17th St #301, Redmond, OR 97756, USA	44.2690360	-121.1877580	1,172 m	bars, brewery, cocktails, live music, microbrewery, nightlife, pubs, wine bar, winery	bar,establishment,point_of_interest	Page \| Maps \| Website	(541) 923-4200	View Hours Monday: 4:00 – 9:00 PM Tuesday: 11:30 AM – 9:00 PM Wednesday: 11:30 AM – 9:00 PM Thursday: 11:30 AM – 9:00 PM Friday: 11:30 AM – 10:00 PM Saturday: 11:30 AM – 10:00 PM Sunday: 11:30 AM – 9:00 PM	View Photos (3)
ChIJRw2vlg0rv1QRloYN5KHRyLc	Rincón Azteca A Family Mexican Cuisine	526 SW 6th St, Redmond, OR 97756, USA	44.2721350	-121.1739750	54 m	cocktails, lunch, restaurants	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 548-4084	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)
ChIJ50R7asnUuFQRASnSRNfcsnM	Rite Aid	1514 SW Highland Ave, Redmond, OR 97756, USA	44.2690540	-121.1849860	966 m	coffee shops	convenience_store,drugstore,establishment,food,health,point_of_interest,store	Page \| Maps \| Website	(541) 548-6041	View Hours Monday: 8:00 AM – 9:00 PM Tuesday: 8:00 AM – 9:00 PM Wednesday: 8:00 AM – 9:00 PM Thursday: 8:00 AM – 9:00 PM Friday: 8:00 AM – 9:00 PM Saturday: 8:00 AM – 9:00 PM Sunday: 9:00 AM – 8:00 PM	View Photos (4)
ChIJg_3xktIrv1QR7iHCwWkWMB0	River and Trail Wellness and Massage/ Melissa Goray LMT	339 SW 6th St, Redmond, OR 97756, USA	44.2740090	-121.1745760	163 m	massage	establishment,point_of_interest	Page \| Maps \| Website	(541) 312-4059	View Hours Monday: Closed Tuesday: Closed Wednesday: 8:30 AM – 8:00 PM Thursday: Closed Friday: 8:30 AM – 8:00 PM Saturday: 8:30 AM – 8:00 PM Sunday: 10:00 AM – 5:00 PM	View Photos (4)
ChIJ41tFB4kXv1QRiVae7AA9LZg	Riverside Campground	12500 SW River Rd, Camp Sherman, OR 97730, USA	44.4414740	-121.6335990	41,087 m	campgrounds	campground,establishment,lodging,park,point_of_interest	Page \| Maps \| Website			View Photos (3)
ChIJi_PjurErv1QR2VOOcxupoC8	Riverview Farm \| Lavender & Wildflower Farm	6145 NW Kingwood Ave, Redmond, OR 97756, USA	44.2887220	-121.2435480	5,825 m	farms	establishment,point_of_interest	Page \| Maps \| Website	(541) 444-0089		View Photos (1)
ChIJ1Y53bSYrv1QRaLsl31PGYBU	Robin E. Meyer, LMT, CA	1655 SW Highland Ave Suite 1, Redmond, OR 97756, USA	44.2698320	-121.1864260	1,043 m	massage	doctor,establishment,health,point_of_interest	Page \| Maps	(541) 923-2019	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:30 AM – 12:00 PM Saturday: Closed Sunday: Closed	No photos available
ChIJbR7994TWvlQRQpVVgo2nlx0	Rockhard	9297 NE Crooked River Dr, Terrebonne, OR 97760, USA	44.3606920	-121.1385530	10,189 m	shopping	establishment,food,point_of_interest,store	Page \| Maps	(541) 788-6225	View Hours Monday: 12:00 – 6:00 PM Tuesday: 12:00 – 6:00 PM Wednesday: 12:00 – 6:00 PM Thursday: 12:00 – 6:00 PM Friday: 12:00 – 6:00 PM Saturday: 12:00 – 6:00 PM Sunday: 12:00 – 6:00 PM	View Photos (4)
ChIJHS-Sc48rv1QRKmMuwNSdYqw	Rockin’ Roasters	122 SW 5th St, Redmond, OR 97756, USA	44.2760710	-121.1729900	391 m	coffee shops	cafe,establishment,food,point_of_interest,store	Page \| Maps \| Website		View Hours Monday: Closed Tuesday: 7:00 AM – 3:00 PM Wednesday: 7:00 AM – 3:00 PM Thursday: 7:00 AM – 3:00 PM Friday: 7:00 AM – 3:00 PM Saturday: 7:00 AM – 3:00 PM Sunday: 7:00 AM – 3:00 PM	View Photos (4)
ChIJk3fm8YIrv1QRSgYR27_MrI0	Rod’s Quality Meats	323 NW 6th St, Redmond, OR 97756, USA	44.2786440	-121.1745120	671 m	meat markets	establishment,food,point_of_interest,store	Page \| Maps \| Website	(541) 516-0733	View Hours Monday: Closed 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 – 5:00 PM Sunday: Closed	View Photos (4)
ChIJWTsCWK4rv1QRNy9lrY7mVhM	ROUX	404 SW Forest Ave, Redmond, OR 97756, USA	44.2714150	-121.1723010	186 m	food trucks	restaurant,food,point_of_interest,establishment	Page \| Maps \| Website	(541) 213-5237	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:30 PM Saturday: 11:00 AM – 8:30 PM Sunday: 11:00 AM – 8:30 PM	View Photos (4)
ChIJ9UgBpofYvlQR33onOd6SDmM	Ryan’s Produce	451 NW 5th St, Redmond, OR 97756, USA	44.2796900	-121.1734850	787 m	grocery stores	establishment,food,grocery_or_supermarket,point_of_interest,store	Page \| Maps	(541) 923-2081	View Hours Monday: Closed 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: Closed	No photos available
ChIJSxaI0ywrv1QR4Jkdxy6TfMI	Safeway	1705 S Hwy 97, Redmond, OR 97756, USA	44.2607570	-121.1796260	1,395 m	coffee shops, desserts, grocery stores, juice bars, meat markets, pool tables, shopping	bakery,establishment,florist,food,grocery_or_supermarket,point_of_interest,store,supermarket	Page \| Maps \| Website	(541) 504-4160	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)
ChIJR2YSzywrv1QRFMFpi__40e4	Safeway Bakery	1705 S Hwy 97, Redmond, OR 97756, USA	44.2608850	-121.1794290	1,377 m	bakeries, desserts	bakery,establishment,food,point_of_interest,store	Page \| Maps \| Website	(541) 504-4160		View Photos (4)