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: 29

Results:

Total Available Records: 705
Total After Limits: 705
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 29

Showing 51 to 75 of 705 results

Place ID	Name	Address	Latitude	Longitude	Distance	Category	Search Term	Types	Links	Phone	Hours	Photos
ChIJra09F1LSuFQRgIng1lBLZMY	Bell-Air Motel	8790 S Hwy 97, Redmond, OR 97756, USA	44.1952670	-121.2322210	9,775 m		hotels	establishment,lodging,point_of_interest	Page \| Maps	(541) 382-1885		View Photos (4)
ChIJUWaFWQ68uFQRePaKMIloVxQ	Benham West Trailhead	Sunriver, OR 97707, USA	43.9390140	-121.4139510	41,753 m		hiking, hiking,mountain biking,trailheads,hiking,mountain biking,trailheads, mountain biking, trailheads	establishment,park,point_of_interest,tourist_attraction	Page \| Maps \| Website	(541) 383-5300		View Photos (4)
ChIJeZsDYYwrv1QR1s7A444uJoQ	Bentley’s Coffee	1555 NW 6th St, Redmond, OR 97756, USA	44.2906330	-121.1744750	2,003 m		coffee shops	cafe,establishment,food,point_of_interest,store	Page \| Maps \| Website			View Photos (1)
ChIJT9sehGgrv1QRLT4Ia-lqDfA	Best Moments Bakery	332 SW 5th St, Redmond, OR 97756, USA	44.2740550	-121.1729230	178 m		bakeries, desserts	bakery,establishment,food,point_of_interest,store	Page \| Maps	(541) 977-6433		View Photos (4)
ChIJzdJ1BcnUuFQRVx4upj1ZXIE	Best Western Plus Rama Inn	2630 SW 17th Pl, Redmond, OR 97756, USA	44.2515600	-121.1859360	2,530 m		hotels, hotels,resorts, resorts	establishment,lodging,point_of_interest	Page \| Maps \| Website	(541) 548-8080		View Photos (4)
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,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,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 – 8:30 PM Saturday: 9:00 AM – 8:00 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)
ChIJMWyVzmIqv1QRFBFkpVJlGeQ	Big Country RV Service Center	2872 SW 17th Pl, Redmond, OR 97756, USA	44.2498020	-121.1884760	2,790 m		rv parks	car_repair,establishment,point_of_interest	Page \| Maps	(541) 330-2495	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: Closed	View Photos (4)
ChIJbzV0NgArv1QRYLR7BnIo1NI	Big moj	Redmond, OR 97756, USA	44.2726200	-121.1739210	0 m		point of interest,hiking	establishment,point_of_interest	Page \| Maps			No photos available
ChIJZwG7UMorv1QR4waKoN6quq8	Big O Bagels	816 SW 17th St, Redmond, OR 97756, USA	44.2691220	-121.1864300	1,069 m		bakeries, bars, bars,coffee shops,bakeries,breakfast,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)
ChIJF6_GqdnZvlQR0dGJIID4Uac	Big Sky Balloon Company	2822 NW Canyon Dr, Redmond, OR 97756, USA	44.3022610	-121.1872440	3,462 m		tours	establishment,point_of_interest,travel_agency	Page \| Maps \| Website	(541) 316-0398	View Hours Monday: 6:00 AM – 7:00 PM Tuesday: 6:00 AM – 7:00 PM Wednesday: 6:00 AM – 7:00 PM Thursday: 6:00 AM – 7:00 PM Friday: 6:00 AM – 7:00 PM Saturday: 6:00 AM – 7:00 PM Sunday: 6:00 AM – 7:00 PM	View Photos (4)
ChIJxY69VmYrv1QRviKWcyWF3_E	Birdie’s Brows & Spa	704 SW Forest Ave Ste 103, Redmond, OR 97756, USA	44.2714280	-121.1756590	192 m		massage,spas	beauty_salon,establishment,hair_care,health,point_of_interest,spa	Page \| Maps \| Website		View Hours Monday: 9:00 AM – 4: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 – 5:00 PM Saturday: 9:00 AM – 3:00 PM Sunday: 9:00 AM – 3: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)
ChIJS6YozxErv1QRmVvda1wFdOw	Black Butte Wellness Collective	341 SW Black Butte Blvd, Redmond, OR 97756, USA	44.2756950	-121.1719150	377 m		wellness center	establishment,health,point_of_interest	Page \| Maps	(541) 205-9075	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 – 12:00 PM Sunday: Closed	No photos available
ChIJY1z5gjwrv1QR7MLnZP10X2k	Blackhat Texas BBQ	845 SW 17th St #301, Redmond, OR 97756, USA	44.2690030	-121.1876560	1,165 m		dining, restaurants, smokehouses, 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)