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

Previous Next

Page 25 of 26

Showing 601 to 625 of 645 results

Place ID	Name	Address	Latitude	Longitude	Distance	Category	Search Term	Types	Links	Phone	Hours	Photos
ChIJvZxchNwrv1QRTUiDPY6tuJ4	Tite Knot Craft Coffee	1865 NW Hemlock Ave, Redmond, OR 97756, USA	44.2842840	-121.1887990	1,756 m		coffee shops	cafe,establishment,food,point_of_interest,store	Page \| Maps \| Website	(541) 526-5568	View Hours Monday: 6:00 AM – 1:00 PM Tuesday: 6:00 AM – 1:00 PM Wednesday: 6:00 AM – 1:00 PM Thursday: 6:00 AM – 1:00 PM Friday: 6:00 AM – 1:00 PM Saturday: 7:00 AM – 1:00 PM Sunday: 7:00 AM – 1:00 PM	View Photos (4)
ChIJ4agFB04rv1QR7F1pEK5Ffoo	Tite Knot Craft Coffee – Central Bakery	950 SW Veterans Way, Redmond, OR 97756, USA	44.2674300	-121.1790250	706 m		coffee shops, coffee shops,bakeries	cafe,establishment,food,point_of_interest,store	Page \| Maps \| Website	(541) 527-1353	View Hours Monday: 6:00 AM – 1:00 PM Tuesday: 6:00 AM – 1:00 PM Wednesday: 6:00 AM – 1:00 PM Thursday: 6:00 AM – 1:00 PM Friday: 6:00 AM – 1:00 PM Saturday: 7:00 AM – 1:00 PM Sunday: 7:00 AM – 1:00 PM	View Photos (4)
ChIJx6FDWADTuFQRVTixNKQFjtI	Tite Knot Craft Coffee – South	4297 SW Canal Blvd, Redmond, OR 97756, USA	44.2382250	-121.2133240	4,947 m		coffee shops	cafe,establishment,food,point_of_interest,store	Page \| Maps	(541) 749-7672	View Hours Monday: 6:00 AM – 1:00 PM Tuesday: 6:00 AM – 1:00 PM Wednesday: 6:00 AM – 1:00 PM Thursday: 6:00 AM – 1:00 PM Friday: 6:00 AM – 1:00 PM Saturday: 7:00 AM – 1:00 PM Sunday: 7:00 AM – 1:00 PM	View Photos (3)
ChIJm_TKCOkqv1QR2qAobwDEMTM	Tobacco Joe	909 NW 6th St, Redmond, OR 97756, USA	44.2849240	-121.1743300	1,368 m		coffee shops	establishment,point_of_interest,store	Page \| 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: 7:00 AM – 8:00 PM Sunday: 7:00 AM – 8:00 PM	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
ChIJIctrja7QvlQRbo-OAy82KgI	Trail Crossing Corrals Trailhead	Terrebonne, OR 97760, USA	44.4245360	-121.1497610	17,001 m		trailheads	establishment,point_of_interest,tourist_attraction	Page \| Maps \| Website	(541) 416-6640		No photos available
ChIJ8xhuChArv1QRJ6Vpj3LAG_o	Transcendence Therapeutic Massage	813 SW Highland Ave Ste 203, Redmond, OR 97756, USA	44.2698140	-121.1767460	385 m		massage	establishment,point_of_interest	Page \| Maps \| Website	(541) 815-3897	View Hours Monday: Closed 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 – 1:00 PM Sunday: Closed	View Photos (4)
ChIJQx0aRkrPuFQR8NiBhyiy3ug	Treasure Valley Coffee of Central Oregon	4620 SW 23rd St Bldg A, Redmond, OR 97756, USA	44.2344340	-121.1937000	4,529 m		coffee shops	establishment,food,point_of_interest,store	Page \| 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)
ChIJ5500E-wqv1QRdmzDvEbPKNg	Trend Kill Body Piercing	508 SW 6th St, Redmond, OR 97756, USA	44.2724010	-121.1739790	25 m		shopping	establishment,jewelry_store,point_of_interest,store	Page \| Maps \| Website	(541) 504-0406	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)
ChIJS3vg0HMrv1QR_mp-qOBFnnw	Trendy Tots	344 SW 7th St, Redmond, OR 97756, USA	44.2738500	-121.1750820	165 m		thrift stores	clothing_store,establishment,point_of_interest,store	Page \| 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	1730 SW Parkway Dr, Redmond, OR 97756, USA	44.2697030	-121.1873370	1,116 m	outdoors (edited)	mountain biking (edited)	bicycle_store,establishment,point_of_interest,store	Page \| Maps \| Website	(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	View Photos (4)
ChIJwdNmv68yv1QRT1u_GKjaTDs	Tumalo Canal Trailhead	Oregon 97703, USA	44.2204530	-121.3393490	14,397 m		hiking, hiking,mountain biking,trailheads, mountain biking	establishment,point_of_interest	Page \| 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	establishment,natural_feature	Page \| Maps			View Photos (4)
ChIJf77LbKmxuFQRwbXLms9PoIM	Tumalo Falls Viewpoint	Tumalo Falls, OR 97703, USA	44.0335870	-121.5668450	41,099 m		tourist attraction	establishment,point_of_interest,tourist_attraction	Page \| 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, state parks,hiking	establishment,park,point_of_interest	Page \| 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)
ChIJOaWCbtcqv1QR7seOI7qgAyc	Tumble Inn Tavern	631 SW 6th St, Redmond, OR 97756, USA	44.2710760	-121.1745080	178 m		bars, bars,cocktails,live music,nightlife,pool tables,bars,cocktails,live music,nightlife,pool tables,pubs, cocktails, live music, nightlife, pool tables, pubs	bar,establishment,point_of_interest	Page \| 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, boutiques,gift shops,shopping, gift shops	clothing_store,establishment,food,grocery_or_supermarket,home_goods_store,point_of_interest,store	Page \| 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	View Photos (4)
ChIJ40Diq0Mrv1QRyRIT0oTBa4U	Urban Homestead Company	722 SW Highland Ave, Redmond, OR 97756, USA	44.2693320	-121.1761010	405 m		boutiques,gift shops,shopping, shopping	establishment,home_goods_store,point_of_interest,store	Page \| Maps \| Website	(541) 604-1062	View Hours Monday: 10:30 AM – 4:30 PM Tuesday: 10:30 AM – 4:30 PM Wednesday: 10:30 AM – 4:30 PM Thursday: 10:30 AM – 4:30 PM Friday: 10:30 AM – 4:30 PM Saturday: 10:30 AM – 4:30 PM Sunday: Closed	View Photos (4)
ChIJNc8VHKDIuFQRgw1Abi3Obss	USDA Forest Service	3160 NE 3rd St, Prineville, OR 97754, USA	44.3025670	-120.8092430	29,218 m		campgrounds	campground,establishment,lodging,park,point_of_interest	Page \| Maps \| Website	(541) 416-6500		View Photos (4)
ChIJ92Npl9sqv1QRt6F8lqOpNHg	Venetian Esthetique Day Spa	135 SW 6th St, Redmond, OR 97756, USA	44.2759520	-121.1745820	374 m		spas	establishment,point_of_interest,spa	Page \| Maps	(541) 504-0260		No photos available
ChIJFXDUCfFslVQRdF6uv_osPDI	Vertical Wall Headache and Migraine Specialist	4361 SW 36th St, Redmond, OR 97756, USA	44.2358470	-121.2100490	5,000 m		wellness center	establishment,health,physiotherapist,point_of_interest	Page \| Maps \| Website	(541) 515-7208	View Hours Monday: 5:00 AM – 5:00 PM Tuesday: 5:00 AM – 5:00 PM Wednesday: 5:00 AM – 5:00 PM Thursday: 5:00 AM – 5:00 PM Friday: 5:00 AM – 5:00 PM Saturday: 12:00 – 3:30 PM Sunday: Closed	View Photos (4)
ChIJNzFa8Nkqv1QRfwa83G_nxKM	Victoria Johnson LMT	BodyWise Chiropractic, 707 SW 9th St, Redmond, OR 97756, USA	44.2704140	-121.1777060	389 m		massage	establishment,point_of_interest	Page \| Maps \| Website	(541) 390-2999	View Hours Monday: 10:00 AM – 5:00 PM Tuesday: 9:30 AM – 6:00 PM Wednesday: 10:00 AM – 5:00 PM Thursday: 9:00 AM – 5:00 PM Friday: 10:00 AM – 4:00 PM Saturday: Closed Sunday: Closed	View Photos (4)
ChIJF84mCAApv1QRuXbXrHpvjx8	View Point	9698-9098 NW Lower Bridge Way, Redmond, OR 97756, USA	44.3621310	-121.2874890	13,442 m		historic landmarks, point of interest	establishment,point_of_interest	Page \| Maps			View Photos (1)
ChIJvwn-JeLVuFQRwKZwm9v3Qn8	Warehouse Cognitive Surplus Fulfillment & Corporate Offices	725 SW Umatilla Ave, Redmond, OR 97756, USA	44.2516110	-121.1756260	2,340 m		gift shops	establishment,point_of_interest,storage	Page \| Maps \| Website	(971) 901-7521		View Photos (4)
ChIJ-Q-cWxErv1QR-aYDNGjdTPE	Wayfarer Club	525 SW 6th St, Redmond, OR 97756, USA	44.2721900	-121.1745760	71 m	bars-nightlife (edited)	bars (edited)	bar,establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 508-7600	View Hours Monday: 3:00 – 9:00 PM Tuesday: 3:00 – 9:00 PM Wednesday: 3:00 – 9:00 PM Thursday: 3:00 – 9:00 PM Friday: 3:00 – 11:00 PM Saturday: 3:00 – 11:00 PM Sunday: 3:00 – 9:00 PM	View Photos (4)