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: 25
Limit per Page: 25
Offset: 600
Total Pages: 27

Results:

Total Available Records: 659
Total After Limits: 659
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 600, 25

Previous Next

Page 25 of 27

Showing 601 to 625 of 659 results

Place ID	Name	Address	Latitude	Longitude	Distance	Category	Search Term	Types	Links	Phone	Hours	Photos
ChIJxXHU_fUpv1QR6XZd-7yQqLg	Thordarson Farms Redmond,Oregon	Redmond, OR 97756, USA	44.3189160	-121.2698500	9,208 m		farms	point_of_interest,establishment	Maps			No photos available
ChIJNX5fYxSzuFQRM0FghCexq_o	Three Creek Lake	Three Creek Lake, Oregon 97703, USA	44.0990330	-121.6272880	40,980 m	outdoors	hiking, point-of-interest	natural_feature,establishment	Maps			View Photos (4)
ChIJ-ZJJxf01v1QRtP4XTV7EPjI	Three Creek Lake Campground	NF-16, Sisters, OR 97759, USA	44.0969420	-121.6238110	40,847 m		campgrounds	campground,lodging,park,point_of_interest,establishment	Maps \| Website	(541) 383-5300		View Photos (4)
ChIJiU_zE1jVuFQRcZUjv7OPL88	Three Sisters Conference Center	3800 SE Airport Way, Redmond, OR 97756, USA	44.2375890	-121.1853060	3,999 m		event venues	point_of_interest,establishment	Maps \| Website	(541) 585-1569		No photos available
ChIJ_cWbWtYrv1QRP9thHFDfZrA	Thrive Restorative Massage	4110 NW 39th Dr, Redmond, OR 97756, USA	44.3140940	-121.2111450	5,481 m		massage	point_of_interest,establishment	Maps \| Website	(541) 279-6441	View Hours Monday: 10:00 AM – 5:00 PM Tuesday: 10:00 AM – 5:00 PM Wednesday: Closed Thursday: 10:00 AM – 6:00 PM Friday: 10:00 AM – 4:00 PM Saturday: Closed Sunday: Closed	View Photos (1)
ChIJOa0U7LnUuFQRp3ScJLGUrr8	Timber’s Bar & Grill Redmond	3315 S Hwy 97, Redmond, OR 97756, USA	44.2457240	-121.1910630	3,288 m		bars, cocktails, nightlife, pool tables, pubs, restaurants, wine bars	bar,point_of_interest,establishment	Maps	(541) 923-7604	View Hours Monday: 11:00 AM – 10:00 PM Tuesday: 11:00 AM – 10:00 PM Wednesday: 11:00 AM – 10:00 PM Thursday: 11:00 AM – 10:00 PM Friday: 11:00 AM – 10:00 PM Saturday: 11:00 AM – 10:00 PM Sunday: 11:00 AM – 10:00 PM	View Photos (4)
ChIJW2MII8Yrv1QRhr8CvrDAels	Tite Knot Craft Coffee (edited)	706 SW 10th St, Redmond, OR 97756, USA (edited)	44.2704250	-121.1783210	427 m	coffee-treats (edited)	coffee shops, bakeries (edited)	cafe,store,point_of_interest,food,establishment,bakeries (edited)	Maps \| Website (edited)	(541) 526-5568	View Hours Monday: 6:00 AM – 4:00 PM Tuesday: 6:00 AM – 4:00 PM Wednesday: 6:00 AM – 4:00 PM Thursday: 6:00 AM – 4:00 PM Friday: 6:00 AM – 4:00 PM Saturday: 7:00 AM – 4:00 PM Sunday: 7:00 AM – 4:00 PM	No photos available
ChIJm_TKCOkqv1QR2qAobwDEMTM	Tobacco Joe (edited)	909 NW 6th St, Redmond, OR 97756, USA (edited)	44.2849240	-121.1743300	1,368 m		Tobacco, Tobacco shop (edited)	store,point_of_interest,establishment (edited)	Maps	(541) 923-1630	View Hours Monday: 6:00 AM – 8:00 PM Tuesday: 6:00 AM – 8:00 PM Wednesday: 6:00 AM – 8:00 PM Thursday: 6:00 AM – 8:00 PM Friday: 6:00 AM – 8:00 PM Saturday: 8:00 AM – 8:00 PM Sunday: 8:00 AM – 8:00 PM	No photos available
ChIJaeIkvpErv1QRKW9B5FbLfHc	Tompkins Chiropractic – Redmond	210 SW 5th St #4, Redmond, OR 97756, USA	44.2751010	-121.1727940	290 m		massage	health,point_of_interest,establishment	Maps \| Website	(541) 241-2976	View Hours Monday: Closed Tuesday: 9:00 AM – 6:00 PM Wednesday: 9:00 AM – 2:30 PM Thursday: 9:00 AM – 6:00 PM Friday: 9:00 AM – 2:30 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	shopping_mall,point_of_interest,establishment	Maps			No photos available
ChIJIctrja7QvlQRbo-OAy82KgI	Trail Crossing Corrals Trailhead	Terrebonne, OR 97760, USA	44.4245360	-121.1497610	17,001 m		point of interest	tourist_attraction,park,point_of_interest,establishment	Maps \| Website	(541) 416-6640		No photos available
ChIJ8xhuChArv1QRJ6Vpj3LAG_o	Transcendence Therapeutic Massage	813 SW Highland Ave Suite 203, Redmond, OR 97756, USA	44.2698140	-121.1767460	385 m		massage	point_of_interest,establishment	Maps	(541) 815-3897	View Hours Monday: Closed 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 – 1:00 PM Sunday: Closed	View Photos (4)
ChIJQx0aRkrPuFQR8NiBhyiy3ug	Treasure Valley Coffee of Central Oregon	4620 SW 23rd St Building A, Redmond, OR 97756, USA	44.2344340	-121.1937000	4,529 m		coffee shops	point_of_interest,food,store,establishment	Maps \| Website	(541) 527-1595	View Hours Monday: 7:00 AM – 5:00 PM Tuesday: 7:00 AM – 5:00 PM Wednesday: 7:00 AM – 5:00 PM Thursday: 7:00 AM – 5:00 PM Friday: 7:00 AM – 4:00 PM Saturday: Closed Sunday: Closed	View Photos (4)
ChIJS3vg0HMrv1QR_mp-qOBFnnw	Trendy Tots	344 SW 7th St, Redmond, OR 97756, USA	44.2738620	-121.1750820	166 m		thrift stores	clothing_store,store,point_of_interest,establishment	Maps \| Website	(541) 279-4704	View Hours Monday: 11:00 AM – 4:00 PM Tuesday: 11:00 AM – 4:00 PM Wednesday: 11:00 AM – 4:00 PM Thursday: 11:00 AM – 4:00 PM Friday: 11:00 AM – 4:00 PM Saturday: 11:00 AM – 4:00 PM Sunday: Closed	No photos available
ChIJrXiMfigrv1QRFvkk4mnI8Sk	Trinity Bikes (edited)	1730 SW Parkway Dr, Redmond, OR 97756, USA (edited)	44.2697030	-121.1873370	1,116 m	recreation (edited)	mountain biking, shopping (edited)	bicycle_store,point_of_interest,store,establishment,shopping (edited)	Maps \| Website (edited)	(541) 923-5650	View Hours Monday: Closed Tuesday: 10:00 AM – 5:30 PM Wednesday: 10:00 AM – 5:30 PM Thursday: 10:00 AM – 5:30 PM Friday: 10:00 AM – 5:30 PM Saturday: 10:00 AM – 5:00 PM Sunday: Closed	No photos available
ChIJwdNmv68yv1QRT1u_GKjaTDs	Tumalo Canal Trailhead	Oregon 97703, USA	44.2204530	-121.3393490	14,397 m		hiking, mountain biking, trailheads	park,point_of_interest,establishment	Maps	(541) 416-6700	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)
ChIJP81I0g6xuFQRDzFmHl2j-yU	Tumalo Falls	Tumalo Falls, Oregon 97703, USA	44.0339560	-121.5668790	41,074 m	outdoors	point-of-interest	natural_feature,establishment	Maps			View Photos (4)
ChIJf77LbKmxuFQRwbXLms9PoIM	Tumalo Falls Viewpoint	Tumalo Falls, OR 97703, USA	44.0335870	-121.5668450	41,099 m		tourist attraction	tourist_attraction,point_of_interest,establishment	Maps \| Website			View Photos (4)
ChIJjbYtQ6fOuFQRZYlEbF4DpH8	Tumalo State Park	Oregon 97703, USA	44.1284080	-121.3307740	20,334 m	outdoors	hiking, point-of-interest, state parks	park,point_of_interest,establishment	Maps \| Website	(800) 551-6949	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: 8:00 AM – 5:00 PM Sunday: 8:00 AM – 5:00 PM	View Photos (4)
ChIJ94Uf_qXOuFQRG1RDdaNdVmI	Tumalo State Park Campground	64185 O. B. Riley Rd, Tumalo, OR 97703, USA	44.1289110	-121.3310380	20,303 m		campgrounds, koa, rv parks, state parks	campground,lodging,park,point_of_interest,establishment	Maps \| Website	(541) 388-6055		View Photos (4)
ChIJOaWCbtcqv1QR7seOI7qgAyc	Tumble Inn Tavern	631 SW 6th St, Redmond, OR 97756, USA	44.2710760	-121.1745080	178 m		bars, cocktails, live music, nightlife, pool tables, pubs, wine bars	bar,point_of_interest,establishment	Maps \| Website	(541) 548-1917	View Hours Monday: 12:00 PM – 12:00 AM Tuesday: 12:00 PM – 12:00 AM Wednesday: 12:00 PM – 12:00 AM Thursday: 12:00 PM – 12:00 AM Friday: 12:00 PM – 12:00 AM Saturday: 12:00 PM – 12:00 AM Sunday: 12:00 PM – 12:00 AM	View Photos (4)
ChIJYaI95M4rv1QRyBBptKy5p9A	Two Gifty Girls	433 SW 6th St, Redmond, OR 97756, USA	44.2730350	-121.1745290	67 m		boutiques, gift shops	store,point_of_interest,establishment	Maps \| Website	(541) 516-1955	View Hours Monday: Closed 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: Closed	No photos available
ChIJm-96rPPdvlQRKaowyfxq8rk	Upper Deschutes Day Use Area	Culver, OR 97734, USA	44.5354830	-121.2864240	30,565 m		fishing	park,tourist_attraction,point_of_interest,establishment	Maps \| Website	(541) 546-3412	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)
ChIJhVs5FHZLv1QR3qIWvQnwD5Y	Upper Three Creek Sno-Park	NF-16, Sisters, OR 97759, USA	44.1601860	-121.6381260	39,050 m		campgrounds	park,point_of_interest,establishment	Maps \| Website	(541) 647-0465	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)
ChIJnxS6la3LuFQRjYnz8ogu6To	Upper Tumalo Reservoir	Upper Tumalo Reservoir, Oregon 97703, USA	44.1372760	-121.4221380	24,859 m		fishing	natural_feature,establishment	Maps			View Photos (4)