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

Previous Next

Page 3 of 24

Showing 51 to 75 of 583 results

Place ID	Name	Address	Latitude	Longitude	Distance	Category	Search Term	Types	Links	Phone	Hours	Photos
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 – 7:30 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.2691120	-121.1864300	1,070 m		bakeries, 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)
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 suite 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)
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: Closed Tuesday: Closed Wednesday: Closed Thursday: Closed Friday: 3:00 – 9:00 PM Saturday: 1:00 – 9:00 PM Sunday: 1:00 – 8: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	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)
ChIJdYelR-9IlVQRH51NmVm2NNw	Botanas El Paraiso	308 SW Evergreen Ave, Redmond, OR 97756, USA	44.2723530	-121.1716650	182 m		desserts, 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, 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,park,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)
ChIJz2i9ZETXvlQRk9DpTmsg9ZY	Brand 44° N	8060 11th St, Terrebonne, OR 97760, USA	44.3490810	-121.1774310	8,507 m		breakfast, lunch	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 316-3280	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)
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)
ChIJuZ8YboPHuFQROznIv3AYyno	Brewery Planning	1335 NW 16th Ct, Redmond, OR 97756, USA	44.2883780	-121.1857890	1,991 m		brewery	establishment,point_of_interest	Page \| Maps \| Website	(559) 860-9998	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 – 5:00 PM Saturday: Closed Sunday: Closed	View Photos (4)
ChIJqw1sTPXWvlQRfaqteR3Q9L8	Brian Thomas Complete Horsemanship, LLC	20890A NW Butler Rd, Terrebonne, OR 97760, USA	44.3615150	-121.1148880	10,944 m		horseback rides	establishment,point_of_interest	Page \| Maps \| Website	(208) 709-3175		View Photos (4)
ChIJb6k1H9oqv1QRapN-r9Hap6s	Brickhouse	412 SW 6th St, Redmond, OR 97756, USA	44.2733140	-121.1739980	77 m		bars, cocktails, desserts, dining, nightlife, pubs	bar,establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 526-1782	View Hours Monday: 4:00 – 8:00 PM Tuesday: 4:00 – 9:00 PM Wednesday: 4:00 – 9:00 PM Thursday: 4:00 – 9:00 PM Friday: 4:00 – 9:00 PM Saturday: 4:00 – 9:00 PM Sunday: 4:00 – 8:00 PM	View Photos (4)
ChIJheZMTdPUuFQRX4JCePotlSk	BrightSide Animal Center Thrift Store	838 NW 5th St, Redmond, OR 97756, USA	44.2842020	-121.1727440	1,291 m		thrift stores	establishment,point_of_interest,store	Page \| Maps \| Website	(541) 504-0101	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 – 5:30 PM Saturday: 9:00 AM – 5:30 PM Sunday: 9:00 AM – 5:30 PM	View Photos (4)