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

Previous Next

Page 3 of 26

Showing 51 to 75 of 645 results

Place ID	Name	Address	Latitude	Longitude	Distance	Category	Search Term	Types	Links	Phone	Hours	Photos
ChIJyR2EdNoqv1QRRsZZ3yPCE4s	Beyond the Ranch Antiques	339 SW Evergreen Ave, Redmond, OR 97756, USA	44.2727870	-121.1718870	163 m		antiques, antiques,shopping,thrift stores,vintage, gift shops, shopping, thrift stores, vintage	clothing_store,establishment,home_goods_store,point_of_interest,shoe_store,store	Page \| Maps	(541) 279-4867	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: 12:00 – 5:00 PM	View Photos (4)
ChIJVSo4LG4rv1QR8I1wB8iXxMI	Beyond The Vine	427 SW 8th St, Redmond, OR 97756, USA	44.2730720	-121.1766230	221 m		bars, bars,cocktails,nightlife,bars,cocktails,nightlife,pubs,winery,wine bar, cocktails, nightlife, pubs, vineyards, wine bar, winery	bar,establishment,food,point_of_interest	Page \| Maps \| Website	(541) 610-3390	View Hours Monday: Closed Tuesday: 3:00 – 8:00 PM Wednesday: 3:00 – 8:00 PM Thursday: 3:00 – 8:00 PM Friday: 2:00 – 9:00 PM Saturday: 2:00 – 9:00 PM Sunday: Closed	View Photos (4)
ChIJNaLtOsjUuFQR3oJUpT0T0S8	Big 5 Sporting Goods	2925 S Hwy 97 #100, Redmond, OR 97756, USA	44.2493670	-121.1877720	2,811 m		pool tables	clothing_store,establishment,point_of_interest,shoe_store,store	Page \| Maps \| Website	(541) 504-0628	View Hours Monday: 10:00 AM – 8:30 PM Tuesday: 10:00 AM – 8:30 PM Wednesday: 10:00 AM – 8:30 PM Thursday: 10:00 AM – 8:30 PM Friday: 9:30 AM – 9:00 PM Saturday: 9:00 AM – 8:30 PM Sunday: 9:30 AM – 8:00 PM	View Photos (4)
ChIJ07dZScjUuFQRviU0XsHYa6s	Big Country RV – Redmond	2795 S Hwy 97, Redmond, OR 97756, USA	44.2503970	-121.1871270	2,686 m		rv parks	car_dealer,car_repair,establishment,point_of_interest,store	Page \| Maps \| Website	(541) 208-3888	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: 10:00 AM – 5:00 PM	View Photos (4)
ChIJZwG7UMorv1QR4waKoN6quq8	Big O Bagels	816 SW 17th St, Redmond, OR 97756, USA	44.2691220	-121.1864300	1,069 m		bakeries, bars,coffee shops,bakeries,breakfast, breakfast, coffee shops	bakery,cafe,establishment,food,meal_takeaway,point_of_interest,restaurant,store	Page \| Maps \| Website		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)
ChIJ3VCFypHVuFQRjrF3WeWB82c	Bishops’ Storehouse	1950 SW Badger Ave STE 109, Redmond, OR 97756, USA	44.2381100	-121.1898640	4,042 m		grocery stores	establishment,food,grocery_or_supermarket,point_of_interest,store,supermarket	Page \| Maps \| Website	(541) 548-6868	View Hours Monday: Closed Tuesday: Closed Wednesday: 9:00 AM – 12:00 PM Thursday: Closed Friday: Closed Saturday: Closed Sunday: Closed	No photos available
ChIJacNUik48v1QRogv1QRP2AXs	Black Butte	Black Butte, Oregon 97730, USA	44.3995610	-121.6344960	39,256 m	outdoors	hiking, point of interest	establishment,natural_feature	Page \| Maps			View Photos (4)
ChIJY1z5gjwrv1QR7MLnZP10X2k	Blackhat Texas BBQ	845 SW 17th St #301, Redmond, OR 97756, USA	44.2690030	-121.1876560	1,165 m		smokehouses,restaurants,dining	establishment,food,point_of_interest,restaurant	Page \| Maps	(936) 676-2928	View Hours Monday: Closed Tuesday: Closed Wednesday: 12:00 – 8:00 PM Thursday: 12:00 – 8:00 PM Friday: 12:00 – 9:00 PM Saturday: 12:00 – 9:00 PM Sunday: 12:00 – 8:00 PM	View Photos (4)
ChIJFRbH1dIrv1QRtU7PKfm7dIE	Blacksmith Public House	308 SW Evergreen Ave, Redmond, OR 97756, USA	44.2723530	-121.1716650	182 m		bars, brewery, cocktails, food trucks, live music, lunch, microbrewery, nightlife, pubs, restaurants, wine bar, winery	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 604-8878	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)
ChIJv55w6YMrv1QR5bxxqbS7puA	Blackstone Pizza and Salad	652 NW 7th St, Redmond, OR 97756, USA	44.2818600	-121.1750010	1,031 m	food-trucks (edited)	food trucks (edited)	establishment,food,point_of_interest,restaurant	Page \| Maps	(541) 350-4987	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: 10:00 AM – 9:00 PM	View Photos (4)
ChIJ2fShEsjUuFQReyj2HRJKS4w	Blue Compass RV Redmond	3000 S Hwy 97, Redmond, OR 97756, USA	44.2483600	-121.1867230	2,884 m		rv parks	car_dealer,car_repair,establishment,point_of_interest,store	Page \| Maps \| Website	(541) 516-8831	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: 11:00 AM – 4:00 PM	View Photos (4)
ChIJI3ZEDgArv1QRUBT1umTeDCo	Bobablastic	122 SW 5th St, Redmond, OR 97756, USA	44.2760920	-121.1729770	393 m		desserts, food trucks	establishment,point_of_interest	Page \| Maps \| Website	(559) 273-8184	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 (3)
ChIJuUcBOSQrv1QR8gE4W_ovW8A	Body and Sole Massage and Foot Spa	585 NW 32nd St, Redmond, OR 97756, USA	44.2805560	-121.2060590	2,707 m		massage, spas	establishment,point_of_interest	Page \| Maps	(541) 815-8159	View Hours Monday: 8:30 AM – 2:30 AM Tuesday: 8:30 AM – 12:00 AM Wednesday: 8:30 AM – 2:30 PM Thursday: 8:30 AM – 2:30 PM Friday: 8:30 AM – 2:30 PM Saturday: Closed Sunday: Closed	No photos available
ChIJt9dsl8Iqv1QRl69ULtAshUs	Body Kneads Massage	755 SW 7th St Ste C-2, Redmond, OR 97756, USA	44.2698260	-121.1757250	342 m		massage	establishment,point_of_interest	Page \| Maps \| Website	(541) 306-7784	View Hours Monday: Closed Tuesday: 8:00 AM – 5:00 PM Wednesday: 10:00 AM – 6:00 PM Thursday: 8:00 AM – 5:00 PM Friday: 8:00 AM – 12:00 PM Saturday: Closed Sunday: Closed	View Photos (1)
ChIJXwWg_9cqv1QRuP22v6nUsFk	Bodywise Chiropractic and Massage	707 SW 9th St, Redmond, OR 97756, USA	44.2704170	-121.1777570	392 m		massage	establishment,health,point_of_interest	Page \| Maps \| Website	(541) 548-5089	View Hours Monday: 9:00 AM – 5:30 PM Tuesday: 8:30 AM – 5:30 PM Wednesday: 8:30 AM – 5:30 PM Thursday: 8:30 AM – 5:30 PM Friday: 8:00 AM – 5:00 PM Saturday: Closed Sunday: Closed	View Photos (4)
ChIJF3_OGOgqv1QRLY4rbPiux98	Bogey’s Burgers (Redmond)	655 NW Greenwood Ave, Redmond, OR 97756, USA	44.2821720	-121.1751370	1,066 m		family friendly, lunch, restaurants	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 316-1786	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 – 9:00 PM Saturday: 11:00 AM – 9:00 PM Sunday: Closed	View Photos (4)
ChIJYyaNu3zTuFQRnDK7MEcG1VI	Bonta Gelato – Redmond Westmount	3750 SW Badger Ave, Redmond, OR 97756, USA	44.2371930	-121.2125430	4,998 m		desserts	establishment,food,point_of_interest,store	Page \| Maps \| Website	(541) 897-9282	View Hours Monday: 1:00 – 9:00 PM Tuesday: 1:00 – 9:00 PM Wednesday: 1:00 – 9:00 PM Thursday: 1:00 – 9:00 PM Friday: 1:00 – 9:00 PM Saturday: 1:00 – 9:00 PM Sunday: 1:00 – 9:00 PM	View Photos (4)
ChIJfTiiU_Yov1QRCknmKrO8Ly4	Borden Beck Wildlife Preserve	9098-9698 NW Lower Bridge Way, Redmond, OR 97756, USA	44.3605520	-121.2925150	13,588 m	outdoors	nature preserve,hiking, point of interest	establishment,park,point_of_interest,tourist_attraction	Page \| Maps \| Website	(541) 548-7275	View Hours Monday: 6:30 AM – 9:00 PM Tuesday: 6:30 AM – 9:00 PM Wednesday: 6:30 AM – 9:00 PM Thursday: 6:30 AM – 9:00 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)
ChIJ9YprwIcrv1QR3qtnrfAtQg4	Born to be Wild	239 SW 6th St, Redmond, OR 97756, USA	44.2749280	-121.1745480	261 m		boutiques,shopping,thrift stores	establishment,point_of_interest,store	Page \| Maps		View Hours Monday: Closed Tuesday: 11:00 AM – 5:00 PM Wednesday: 11:00 AM – 5:00 PM Thursday: 11:00 AM – 5:00 PM Friday: 11:00 AM – 5:00 PM Saturday: 11:00 AM – 5:00 PM Sunday: Closed	View Photos (1)
ChIJdYelR-9IlVQRH51NmVm2NNw	Botanas El Paraiso	308 SW Evergreen Ave, Redmond, OR 97756, USA	44.2723530	-121.1716650	182 m		desserts, desserts,food trucks,restaurants,lunch,family friendly, food trucks, lunch	establishment,food,point_of_interest,restaurant	Page \| Maps	(541) 279-0362	View Hours Monday: 11:30 AM – 7:30 PM Tuesday: 10:00 AM – 8:00 PM Wednesday: Closed Thursday: 10:00 AM – 8:00 PM Friday: 10:00 AM – 8:00 PM Saturday: 10:00 AM – 8:00 PM Sunday: Closed	View Photos (4)
ChIJ86CATOwqv1QRxPcOUjaNJGI	Bottoms Up Bar & Grill	1421 NW 6th St, Redmond, OR 97756, USA	44.2895840	-121.1743040	1,887 m		bars, bars,cocktails,live music,nightlife,bars,cocktails,live music,nightlife,pubs,brewery,breakfast, breakfast, brewery, cocktails, live music, lunch, nightlife, pubs, restaurants	bar,establishment,food,point_of_interest,restaurant	Page \| Maps	(541) 548-5663	View Hours Monday: 11:30 AM – 10:00 PM Tuesday: 11:30 AM – 10:00 PM Wednesday: 11:30 AM – 10:00 PM Thursday: 11:30 AM – 10:00 PM Friday: 7:00 AM – 12:00 AM Saturday: 7:00 AM – 12:00 AM Sunday: 7:00 AM – 9:00 PM	View Photos (4)
ChIJfyHbEFArv1QRG13kh-yFhxM	Bowlby Park	1767 SW Parkway Dr, Redmond, OR 97756, USA	44.2703320	-121.1883020	1,173 m		parks	establishment,point_of_interest	Page \| Maps \| Website	(541) 923-7710		View Photos (1)
ChIJ3cb8CDLAuFQRdWzBCK6gLGY	Boyd Cave	Bend, OR 97702, USA	43.9422140	-121.1983280	36,791 m	outdoors	hiking, point of interest	establishment,point_of_interest,tourist_attraction	Page \| Maps \| Website		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)
ChIJPTSAY3LXuFQRSDF_1U1u_9E	Brasada Canyons	16550 SW Brasada Canyons Dr, Powell Butte, OR 97753, USA	44.1554790	-121.0471570	16,484 m		driving range, golf courses, golf lessons	point_of_interest,establishment	Page \| Maps \| Website	(541) 526-6380	View Hours Monday: 9:00 AM – 5:00 PM Tuesday: 11: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)
ChIJPTSAY3LXuFQRIvBZ1OeG04U	Brasada Ranch	16976 SW Brasada Ranch Rd, Powell Butte, OR 97753, USA	44.1572920	-121.0479990	16,284 m	resorts (edited)	resorts (edited)	establishment,lodging,point_of_interest	Page \| Maps \| Website	(888) 487-3563		View Photos (4)