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: 20
Limit per Page: 25
Offset: 475
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 475, 25

Previous Next

Page 20 of 26

Showing 476 to 500 of 645 results

Place ID	Name	Address	Latitude	Longitude	Distance	Search Term	Types	Links	Phone	Hours	Photos
ChIJ1Y53bSYrv1QROOjkSB0ukyY	Redmond Wellness and Chiropractic	1655 SW Highland Ave #6, Redmond, OR 97756, USA	44.2698830	-121.1860610	1,013 m	massage, 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)
ChIJ54wXcg3WvlQRvDYF5YFLG5w	Redpoint Climbing, Coffee & Taps	8222 US-97 #101, Terrebonne, OR 97760, USA	44.3510400	-121.1783170	8,727 m	rock climbing	cafe,establishment,food,liquor_store,point_of_interest,restaurant,store	Page \| Maps \| Website	(541) 604-2115	View Hours Monday: 8:00 AM – 8:00 PM Tuesday: 8:00 AM – 8:00 PM Wednesday: 8:00 AM – 8:00 PM Thursday: 8:00 AM – 8:00 PM Friday: 8:00 AM – 9:00 PM Saturday: 7:00 AM – 9:00 PM Sunday: 7:00 AM – 8:00 PM	View Photos (4)
ChIJZ3cFVukqv1QRd74wbqRltLQ	Regios Cafe	1154 NW 6th St, Redmond, OR 97756, USA	44.2871880	-121.1735910	1,620 m	breakfast, breakfast,lunch,family friendly, 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 (4)
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
ChIJ_YHZxDIrv1QR3EdIKd9JPxI	Richard’s Sliders	245 SW 6th St, Redmond, OR 97756, USA	44.2748580	-121.1746800	256 m	food trucks, food trucks,restaurants,breakfast,lunch,dining,family friendly, 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 – 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)
ChIJg6w6b9sqv1QR2VUYpIPX3Uc	Rigoberto’s Taco Shop	433 W Antler Ave, Redmond, OR 97756, USA	44.2767630	-121.1728610	468 m	breakfast, 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, bars,cocktails,live music,nightlife,bars,cocktails,live music,nightlife,pubs,brewery,microbrewery, brewery, cocktails, live music, microbrewery, nightlife, pubs, wine bar, winery	bar,establishment,point_of_interest	Page \| Maps \| Website	(541) 923-4200	View Hours Monday: 2: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 (4)
ChIJRw2vlg0rv1QRloYN5KHRyLc	Rincón Ázteca A Family Mexican Cuisine	526 SW 6th St, Redmond, OR 97756, USA	44.2721350	-121.1739750	54 m	cocktails, cocktails,restaurants,lunch,dining,family friendly, 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)
ChIJac6N8_Mrv1QRAFnA_wwgPlM	RINCONCITO VERACRUZANO LLC	high desert music hall, 639 SW 8th St trailer #4, Redmond, OR 97756, USA	44.2708060	-121.1767190	301 m	lunch	establishment,food,point_of_interest,restaurant	Page \| Maps			No photos available
ChIJCaZ8PO8rv1QREyUXML-RQYo	Ripple Effect Massage Co.	716 SW 11th St, Redmond, OR 97756, USA	44.2702900	-121.1793730	506 m	massage	establishment,point_of_interest	Page \| Maps \| Website	(503) 289-7229	View Hours Monday: 9:00 AM – 3:00 PM Tuesday: 9:00 AM – 5:00 PM Wednesday: 9:00 AM – 3:00 PM Thursday: 9:00 AM – 3:00 PM Friday: 9:00 AM – 5:00 PM Saturday: 9:00 AM – 3:00 PM Sunday: 9:00 AM – 4:00 PM	View Photos (4)
ChIJ9U43ktnUuFQRNyqGzqNgwdw	Risse Racing Technology, Inc.	2237 SW 2nd Ct Ste C, Redmond, OR 97756, USA	44.2550200	-121.1716250	1,966 m	mountain biking	establishment,point_of_interest	Page \| Maps \| Website	(541) 526-7242	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: 8:00 AM – 5:00 PM Saturday: Closed Sunday: Closed	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)
ChIJT2KkoqIsv1QRjVkXc02NT30	Riverfront Parks and Trails at Eagle Crest Resort	1620 Blue Heron Dr, Redmond, OR 97756, USA	44.2594200	-121.2489100	6,149 m	hiking,trailheads	establishment,point_of_interest	Page \| Maps		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)
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, coffee shops,family friendly	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	markets,grocery stores,meat markets, 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)
ChIJjXJhYwArv1QRHlcAK1gWdy8	Rosie Nails & Spa	427 SW 6th St, Redmond, OR 97756, USA	44.2731080	-121.1745500	74 m	massage	beauty_salon,establishment,point_of_interest	Page \| Maps	(541) 548-3428	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: 9:00 AM – 6:00 PM Sunday: Closed	View Photos (4)
ChIJPW6bz0vVuFQRxv7b6MYKgQY	Ross Dress for Less	1629 SW Odem Medo Rd, Redmond, OR 97756, USA	44.2537490	-121.1856800	2,298 m	shopping	clothing_store,department_store,establishment,point_of_interest,shoe_store,store	Page \| Maps \| Website	(541) 548-5008	View Hours Monday: 9:30 AM – 9:30 PM Tuesday: 9:30 AM – 9:30 PM Wednesday: 9:30 AM – 9:30 PM Thursday: 9:30 AM – 9:30 PM Friday: 9:00 AM – 10:00 PM Saturday: 9:00 AM – 10:00 PM Sunday: 9:00 AM – 9:00 PM	View Photos (4)