Data

Debug Info (admin only)

Search Criteria:

Keyword: None
Categories: None
Search Terms: None
Types: None
Show Unpublished: Yes
Sort: redmond_category
Order: ASC

Pagination:

Current Page: 1
Limit per Page: 25
Offset: 0
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.redmond_category, p.redmond_category) ASC LIMIT 0, 25

Page 1 of 24

Showing 1 to 25 of 583 results

Place ID	Name	Address	Latitude	Longitude	Distance	Search Term	Types	Links	Phone	Hours	Photos
ChIJ_5C-g-8rv1QRA40ljJVODHI	Fuji Japanese food truck	332 SW 5th St, Redmond, OR 97756, USA	44.2740550	-121.1729230	178 m	food trucks	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(458) 285-6559	View Hours Monday: 11:00 AM – 10:00 PM Tuesday: 11:00 AM – 10:00 PM Wednesday: 11:00 AM – 10:00 PM Thursday: Closed Friday: Closed Saturday: Closed Sunday: 11:00 AM – 10:00 PM	View Photos (4)
ChIJ_9vJoykrv1QRrLT-3CM76So	Thai O Restaurant	974 SW Veterans Way, Redmond, OR 97756, USA	44.2668320	-121.1789070	756 m	dining, lunch, restaurants	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 548-4883	View Hours Monday: 11:00 AM – 3:00 PM, 4:30 – 8:00 PM Tuesday: 11:00 AM – 3:00 PM, 4:30 – 8:00 PM Wednesday: 11:00 AM – 3:00 PM, 4:30 – 8:00 PM Thursday: 11:00 AM – 3:00 PM, 4:30 – 8:00 PM Friday: 11:00 AM – 3:00 PM, 4:30 – 8:00 PM Saturday: 4:30 – 8:00 PM Sunday: Closed	View Photos (4)
ChIJ_cWbWtYrv1QRP9thHFDfZrA	Thrive Restorative Massage	4110 NW 39th Dr, Redmond, OR 97756, USA	44.3140940	-121.2111450	5,481 m	massage	establishment,point_of_interest	Page \| 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)
ChIJ_QttG9sqv1QRlMOKu0qCRnQ	Human Touch Massage Center	341 SW Black Butte Blvd, Redmond, OR 97756, USA	44.2756950	-121.1718830	378 m	massage	establishment,health,point_of_interest	Page \| Maps	(541) 923-9708		No photos available
ChIJ_S3Y72orv1QRge-gXe5ssw4	Kambry Berg LMT	716 SW 11th St, Redmond, OR 97756, USA	44.2703030	-121.1793770	505 m	massage	establishment,point_of_interest	Page \| Maps \| Website	(541) 852-6770	View Hours Monday: 1:00 – 4:00 PM Tuesday: Closed Wednesday: 9:30 AM – 2:00 PM Thursday: 3:00 – 6:30 PM Friday: 2:30 – 6:30 PM Saturday: 11:30 AM – 4:30 PM Sunday: 11:30 AM – 4:30 PM	View Photos (3)
ChIJ_THn_9kqv1QRWktUgL14nsg	Redmond Antique Mall	106 SE Evergreen Ave Suite M, Redmond, OR 97756, USA	44.2717110	-121.1682150	465 m	antiques, shopping, vintage	establishment,furniture_store,home_goods_store,point_of_interest,store	Page \| Maps \| Website	(541) 548-6208	View Hours Monday: 10:30 AM – 5:30 PM Tuesday: 10:30 AM – 5:30 PM Wednesday: 10:30 AM – 5:30 PM Thursday: 10:30 AM – 5:30 PM Friday: 10:30 AM – 5:30 PM Saturday: 10:30 AM – 5:30 PM Sunday: 11:00 AM – 4:00 PM	View Photos (4)
ChIJ_YHZxDIrv1QR3EdIKd9JPxI	Richard’s Sliders	245 SW 6th St, Redmond, OR 97756, USA	44.2748580	-121.1746800	256 m	food trucks, lunch, restaurants	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 419-8933	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 – 5: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 (4)
ChIJ_zC1uE4rv1QRLARm4GqAxnU	Hayden Park	SW 35th St @, SW Quartz Ave, Redmond, OR 97756, USA	44.2577570	-121.2087230	3,227 m	parks, playgrounds, tourist attraction	establishment,park,point_of_interest,tourist_attraction	Page \| Maps \| Website	(541) 548-7275	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)
ChIJ–OMvOUqv1QRxDA_TpPutb8	Edward Jones – Financial Advisor: Joshua M Werner	655 NW Greenwood Ave #4, Redmond, OR 97756, USA	44.2823990	-121.1749780	1,091 m	markets	establishment,finance,point_of_interest	Page \| Maps \| Website	(541) 923-7773	View Hours Monday: 7:30 AM – 4:00 PM Tuesday: 7:30 AM – 4:00 PM Wednesday: 7:30 AM – 4:00 PM Thursday: 7:30 AM – 4:00 PM Friday: 7:30 AM – 4:00 PM Saturday: Closed Sunday: Closed	View Photos (2)
ChIJ-1q8LQArv1QRVMod9zsK488	A New Tropical	122 SW 5th St, Redmond, OR 97756, USA	44.2760920	-121.1729770	393 m	food trucks	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 647-9068	View Hours Monday: 11:00 AM – 3:00 PM, 4:00 – 8:00 PM Tuesday: 11:00 AM – 3:00 PM, 4:00 – 8:00 PM Wednesday: Closed Thursday: 11:00 AM – 3:00 PM, 4:00 – 8:00 PM Friday: 11:00 AM – 3:00 PM, 4:00 – 8:00 PM Saturday: 4:00 – 8:00 PM Sunday: 11:00 AM – 8:00 PM	View Photos (4)
ChIJ-20J81LVuFQRz9Y0ZoSExhU	Home Storage Center	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 – 11:00 AM Thursday: Closed Friday: Closed Saturday: Closed Sunday: Closed	View Photos (1)
ChIJ-3UW297VuFQRMBODBRjq4uE	Enterprise Rent-A-Car	3113 S Hwy 97 STE 105, Redmond, OR 97756, USA	44.2479830	-121.1885370	2,977 m	car rentals	car_rental,establishment,point_of_interest	Page \| Maps \| Website	(541) 699-3134	View Hours Monday: 8:00 AM – 6:00 PM Tuesday: 8:00 AM – 6:00 PM Wednesday: 8:00 AM – 6:00 PM Thursday: 8:00 AM – 6:00 PM Friday: 8:00 AM – 6:00 PM Saturday: Closed Sunday: Closed	View Photos (4)
ChIJ-49RKeHdvlQRchgSVuOkk-k	Culver water park	Culver, OR 97734, USA	44.5241230	-121.2078900	28,096 m	tourist attraction	tourist_attraction,point_of_interest,establishment	Page \| Maps			View Photos (1)
ChIJ-84vWdcqv1QRvW4ya-5O9RE	Los Brothers Taco Shop	542 SW 6th St, Redmond, OR 97756, USA	44.2719440	-121.1738890	75 m	lunch, restaurants	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 504-7178	View Hours Monday: 9:00 AM – 8:30 PM Tuesday: 9:00 AM – 8:30 PM Wednesday: 9:00 AM – 8:30 PM Thursday: 9:00 AM – 8:30 PM Friday: 9:00 AM – 8:30 PM Saturday: 9:00 AM – 8:30 PM Sunday: Closed	View Photos (4)
ChIJ-T0aQk0rv1QRXl5c2xj4dBs	Five Miles Taphouse	639 SW 8th St, Redmond, OR 97756, USA	44.2708060	-121.1767190	301 m	cocktails	establishment,food,point_of_interest	Page \| Maps	(541) 550-0667	View Hours Monday: Closed Tuesday: Closed Wednesday: 4:30 – 8:00 PM Thursday: 4:30 – 8:00 PM Friday: 3:00 – 8:00 PM Saturday: 12:00 – 8:00 PM Sunday: Closed	View Photos (4)
ChIJ-T9KAozVuFQRAHURKAbiIR4	SOUTH SISTER	3800 SE Airport Way, Redmond, OR 97756, USA	44.2373240	-121.1853160	4,028 m	event venues	establishment,point_of_interest	Page \| Maps			No photos available
ChIJ-WEQJKfVuFQR7aUmMSzyg0U	Alaska Airlines – Redmond	2522 Jesse Butler Cir, Redmond, OR 97756, USA	44.2530250	-121.1608350	2,415 m	airports	airport,establishment,point_of_interest	Page \| Maps \| Website	(800) 225-2752		View Photos (4)
ChIJ-xhWMNPVuFQR_rcUrq2xz4M	Redmond Coffee Company	3716 SW 21st Pl, Redmond, OR 97756, USA	44.2414960	-121.1908090	3,713 m	coffee shops	cafe,establishment,food,point_of_interest,store	Page \| Maps \| Website	(541) 598-4577	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:30 AM – 2:00 PM Sunday: 7:30 AM – 2:00 PM	View Photos (4)
ChIJ-YwJ1WMrv1QRY6ZnNeA-Hq8	The Well Table located in Ola Day Spa	2600 SW Canal Blvd, Redmond, OR 97756, USA	44.2520490	-121.1887500	2,574 m	massage, spas	establishment,point_of_interest	Page \| Maps \| Website	(541) 504-5215	View Hours Monday: 9:00 AM – 5:00 PM Tuesday: 9:00 AM – 5:15 PM Wednesday: 9:00 AM – 5:00 PM Thursday: 9:00 AM – 5:15 PM Friday: 9:00 AM – 2:00 PM Saturday: Closed Sunday: Closed	View Photos (4)
ChIJ-ZJJxf01v1QRtP4XTV7EPjI	Three Creek Lake Campground	NF-16, Sisters, OR 97759, USA	44.0969420	-121.6238110	40,847 m	campgrounds	campground,establishment,lodging,park,point_of_interest	Page \| Maps \| Website	(541) 383-5300		View Photos (4)
ChIJ01L9jMTUuFQRT_0H9QOak8k	The Original Pancake House Redmond	3030 SW 6th St, Redmond, OR 97756, USA	44.2488200	-121.1729740	2,648 m	breakfast, restaurants	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 316-2515	View Hours Monday: 6:00 AM – 2:00 PM Tuesday: 6:00 AM – 2:00 PM Wednesday: 6:00 AM – 2:00 PM Thursday: 6:00 AM – 2:00 PM Friday: 6:00 AM – 2:00 PM Saturday: 6:00 AM – 2:00 PM Sunday: 6:00 AM – 2:00 PM	View Photos (4)
ChIJ06XH5xEquVQRnC_YutzzA9I	Dee Bar Farms	6402 SW Powell Butte Hwy, Powell Butte, OR 97753, USA	44.2452200	-121.0468210	10,570 m	farms	establishment,point_of_interest	Page \| Maps \| Website	(541) 408-6927		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)
ChIJ0bDcnyQrv1QRMLBMPuAVSVs	Highland Grub and Go	1501 SW Highland Ave, Redmond, OR 97756, USA	44.2697810	-121.1853190	961 m	food trucks	establishment,food,point_of_interest,restaurant	Page \| Maps		View Hours Monday: 5:00 AM – 8:00 PM Tuesday: 5:00 AM – 8:00 PM Wednesday: 5:00 AM – 8:00 PM Thursday: 5:00 AM – 8:00 PM Friday: 5:00 AM – 8:00 PM Saturday: 6:00 AM – 9:00 PM Sunday: 6:00 AM – 8:00 PM	View Photos (4)
ChIJ0xxnLtoqv1QRMRpbgyRFMks	The Moontower	329 SW 6th St, Redmond, OR 97756, USA	44.2741020	-121.1745610	172 m	bars, cocktails, live music, nightlife, pool tables, pubs, restaurants	bar,establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 548-3731	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 – 12:00 AM Saturday: 7:00 AM – 12:00 AM Sunday: 7:00 AM – 9:00 PM	View Photos (4)