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: 1
Limit per Page: 25
Offset: 0
Total Pages: 27

Results:

Total Available Records: 659
Total After Limits: 659
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 0, 25

Page 1 of 27

Showing 1 to 25 of 659 results

Place ID	Name	Address	Latitude	Longitude	Distance	Category	Search Term	Types	Links	Phone	Hours	Photos
ChIJCYdlAG4rv1QRLobmftuvHic	1/8th Street Food Trucks, Patio & Taphouse	639 SW 8th Street &, SW Glacier Ave, Redmond, OR 97756, USA	44.2708060	-121.1767190	301 m		cocktails, family friendly, food trucks, nightlife	bar,point_of_interest,food,establishment	Maps \| Website	(541) 527-1387		View Photos (4)
ChIJ50h8Hdoqv1QRcz-tvXRNCf0	2Hearts Flower Shop	307 NW 7th St Suite B, Redmond, OR 97756, USA	44.2785190	-121.1756190	670 m		gift shops	florist,bakery,store,point_of_interest,food,establishment	Maps \| Website	(541) 280-1298	View Hours Monday: 10:00 AM – 4:00 PM Tuesday: 10:00 AM – 4:00 PM Wednesday: 10:00 AM – 4:00 PM Thursday: 10:00 AM – 4:00 PM Friday: 10:00 AM – 4:00 PM Saturday: 10:00 AM – 4:00 PM Sunday: Closed	View Photos (4)
ChIJkXIY8Uorv1QRGG_JvMHB9Ro	3 Peaks Coffee	722 NW 6th St, Redmond, OR 97756, USA	44.2822640	-121.1740690	1,072 m		coffee shops	point_of_interest,establishment	Maps		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: 8:00 AM – 1:00 PM	View Photos (3)
ChIJPb3noe4qv1QRIXAxCYdixhw	4 Wheel Mobil Home Court	1247 NW 6th St, Redmond, OR 97756, USA	44.2880420	-121.1742860	1,715 m		rv parks	rv_park,lodging,point_of_interest,establishment	Maps	(541) 548-5894		View Photos (4)
ChIJw0TM0twqv1QRYu3Kve2oe4M	5 Below Steakhouse and Breakfast Nook (edited)	325 NW 5th St, Redmond, OR 97756, USA (edited)	44.2788570	-121.1735210	694 m		breakfast, desserts,restaurants,breakfast,lunch, desserts, lunch, restaurants (edited)	restaurant,point_of_interest,food,establishment (edited)	Maps \| Website (edited)	(541) 923-2213	View Hours Monday: 7:00 AM – 9:00 PM Tuesday: 7:00 AM – 9:00 PM Wednesday: 7:00 AM – 9:00 PM Thursday: 7:00 AM – 9:00 PM Friday: 7:00 AM – 9:00 PM Saturday: 7:00 AM – 9:00 PM Sunday: 7:00 AM – 9:00 PM	No photos available
ChIJaxh4FKQrv1QRjG-sXSSIRtQ	7 Peaks Candle Co.	106 SE Evergreen Ave suite i, Redmond, OR 97756, USA	44.2720410	-121.1680790	470 m		gift shops	home_goods_store,point_of_interest,store,establishment	Maps \| Website	(541) 912-3034	View Hours Monday: Closed Tuesday: Closed Wednesday: Closed Thursday: 9:00 AM – 5:00 PM Friday: 9:00 AM – 5:00 PM Saturday: Closed Sunday: 9:00 AM – 5:00 PM	View Photos (2)
ChIJ5RDgdCgrv1QR3zCJI-Ilb_o	7-Eleven	1209 SW Highland Ave, Redmond, OR 97756, USA	44.2698430	-121.1811940	656 m		grocery stores, juice bars	convenience_store,liquor_store,cafe,restaurant,food,point_of_interest,store,establishment	Maps \| Website	(541) 548-1381	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-1q8LQArv1QRVMod9zsK488	A New Tropical	122 SW 5th St, Redmond, OR 97756, USA	44.2760920	-121.1729770	393 m		food trucks	restaurant,food,point_of_interest,establishment	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)
ChIJQSLYC5zVuFQRX-2YIBfSeaw	A-Time-4-U Massage and Spa Therapy	2963 SW Volcano Cir, Redmond, OR 97756, USA	44.2484680	-121.2031920	3,556 m		massage, spas, wellness center	spa,health,point_of_interest,establishment	Maps \| Website	(541) 504-7108	View Hours Monday: Closed Tuesday: 10:00 AM – 7:00 PM Wednesday: 10:00 AM – 7:00 PM Thursday: 10:00 AM – 7:00 PM Friday: 10:00 AM – 7:00 PM Saturday: 10:00 AM – 7:00 PM Sunday: Closed	View Photos (3)
ChIJg5s4i9LUuFQRc3g8jrCTQoo	Abby’s Legendary Pizza	1938 The Dalles-California Hwy, S Hwy 97, Redmond, OR 97756, USA	44.2581450	-121.1795990	1,672 m		bars, dining, lunch, pubs, restaurants	meal_takeaway,meal_delivery,restaurant,food,point_of_interest,establishment	Maps \| Website	(541) 548-5266	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)
ChIJ31jIkZItv1QR9nMR5Q-6yTI	Aerie Cafe	1522 Cline Falls Rd, Redmond, OR 97756, USA	44.2597390	-121.2627970	7,220 m		breakfast, dining	restaurant,food,point_of_interest,establishment	Maps \| Website	(541) 504-3870	View Hours Monday: 7:00 – 10:30 AM Tuesday: 7:00 – 10:30 AM Wednesday: 7:00 – 10:30 AM Thursday: 7:00 – 10:30 AM Friday: 7:00 – 10:30 AM Saturday: 7:00 – 10:30 AM Sunday: 7:00 – 10:30 AM	View Photos (4)
ChIJsYpb_ssrv1QRsqIW79vbHSk	Aiwa Asian Restaurant	150 NW 5th St, Redmond, OR 97756, USA	44.2772060	-121.1730960	514 m		lunch, restaurants	meal_takeaway,restaurant,food,point_of_interest,establishment	Maps \| Website	(541) 527-1380	View Hours Monday: 11:00 AM – 9:00 PM Tuesday: Closed Wednesday: 11:00 AM – 9:00 PM Thursday: 11:00 AM – 9:00 PM Friday: 11:00 AM – 9:30 PM Saturday: 11:00 AM – 9:30 PM Sunday: 11:00 AM – 9:00 PM	View Photos (4)
ChIJi6ZBhybVuFQRNVz5F5EN1VE	Alamo Rent A Car	2522 Jesse Butler Cir, Redmond, OR 97756, USA	44.2530300	-121.1606490	2,421 m		car rentals	car_rental,point_of_interest,establishment	Maps \| Website	(844) 370-7398	View Hours Monday: 8:00 AM – 12:30 AM Tuesday: 8:00 AM – 12:30 AM Wednesday: 8:00 AM – 12:30 AM Thursday: 8:00 AM – 12:30 AM Friday: 8:00 AM – 12:30 AM Saturday: 8:00 AM – 12:30 AM Sunday: 8:00 AM – 12:30 AM	View Photos (4)
ChIJ-WEQJKfVuFQR7aUmMSzyg0U	Alaska Airlines – Redmond	2522 Jesse Butler Cir, Redmond, OR 97756, USA	44.2530250	-121.1608350	2,415 m		airports	airport,point_of_interest,establishment	Maps \| Website	(800) 225-2752		View Photos (4)
ChIJSxInVMsnv1QRQeWs3XKUMNY	Alder Springs Trailhead	CROOKED RIVER, OR 97760, USA	44.4332760	-121.3577690	23,083 m		hiking, trailheads	park,point_of_interest,establishment	Maps \| Website			View Photos (4)
ChIJ5ebHESgrv1QR2xV7RW0YdQM	All About You/Redmond Engraving	725 NW Kingwood Ave, Redmond, OR 97756, USA	44.2875910	-121.1758360	1,672 m		gift shops	store,point_of_interest,establishment	Maps \| Website	(541) 923-1525	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: Closed Saturday: Closed Sunday: Closed	View Photos (4)
ChIJw1Nd3C8rv1QRCY456FtXkhw	American Legion Park	850 SW Rimrock Way, Redmond, OR 97756, USA	44.2685900	-121.1911530	1,443 m		parks, playgrounds, rock climbing	park,tourist_attraction,point_of_interest,establishment	Maps \| Website		View Hours Monday: Closed Tuesday: 9:00 AM – 9:00 PM Wednesday: 9:00 AM – 9:00 PM Thursday: 9:00 AM – 9:00 PM Friday: 9:00 AM – 9:00 PM Saturday: 9:00 AM – 9:00 PM Sunday: Closed	View Photos (4)
ChIJHeJHmNcqv1QREMV8kKzY2yE	American Legion Post 44	704 SW 8th St, Redmond, OR 97756, USA	44.2704380	-121.1760810	297 m		live music, nightlife	bar,restaurant,point_of_interest,food,store,establishment	Maps \| Website	(541) 548-5688	View Hours Monday: 2:00 – 8:00 PM Tuesday: 2:00 – 8:00 PM Wednesday: 2:00 – 8:00 PM Thursday: 2:00 – 8:00 PM Friday: 2:00 – 8:00 PM Saturday: 2:00 – 8:00 PM Sunday: Closed	View Photos (4)
ChIJ3WPj8pkrv1QRLTmYGaC5XTo	Amy Coville Massage, LMT	614 SW 12th St, Redmond, OR 97756, USA	44.2712730	-121.1804850	544 m		massage	point_of_interest,establishment	Maps \| Website	(541) 306-8007		View Photos (4)
ChIJjQX4oygrv1QRPwXQ5ZoVmAw	Anderson Julie	654 NW 4th St, Redmond, OR 97756, USA	44.2818720	-121.1718560	1,042 m		massage	point_of_interest,establishment	Maps	(541) 280-2535		No photos available
ChIJSReNtm4rv1QRUvPn3v-Ifr0	Annex Sports Bar	413 SW Glacier Ave, Redmond, OR 97756, USA	44.2709410	-121.1724960	218 m		bars, cocktails, dining, food trucks, live music, nightlife, pool tables	bar,restaurant,food,point_of_interest,establishment	Maps \| Website	(541) 699-1282	View Hours Monday: 4:00 – 10:00 PM Tuesday: 4:00 – 10:00 PM Wednesday: Closed Thursday: 4:00 – 10:00 PM Friday: 4:00 PM – 12:00 AM Saturday: 12:00 PM – 12:00 AM Sunday: 12:00 – 10:00 PM	View Photos (4)
ChIJx6U13IYrv1QR0c6oDv0MVwc	Antiques & Stuff Redmond Oregon	308 SE Franklin Ave, Redmond, OR 97756, USA	44.2743720	-121.1660550	656 m		antiques	point_of_interest,establishment	Maps	(541) 527-4723		No photos available
ChIJp17jgrzUuFQRmzMHKITf0ZU	Applebee’s Grill + Bar	3807 SW 21st St, Redmond, OR 97756, USA	44.2412720	-121.1921840	3,777 m		bars, breakfast, cocktails, lunch, nightlife, pubs, restaurants	restaurant,bar,food,point_of_interest,establishment	Maps \| Website	(541) 923-4777	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 – 11:00 PM Saturday: 11:00 AM – 11:00 PM Sunday: 11:00 AM – 9:00 PM	View Photos (4)
ChIJIQ-ybqbhwFQRpoam_WdpYBE	Aranda’s Massage Therapy & Myofascial Bodywork	716 SW 11th St, Redmond, OR 97756, USA	44.2703250	-121.1793760	504 m		massage	spa,point_of_interest,establishment	Maps \| Website	(541) 788-5732		View Photos (4)
ChIJD0UXA9Irv1QRUK7SsGtis_U	Arome (edited)	432 SW 6th St, Redmond, OR 97756, USA (edited)	44.2730890	-121.1740260	53 m	shopping (edited)	boutiques, grocery stores (edited)	boutiques_grocery_or_supermarket,furniture_store,home_goods_store,store,food,point_of_interest,establishment (edited)	Maps \| Website (edited)	(541) 527-4727	View Hours Monday: 10:00 AM – 5:00 PM Tuesday: 10:00 AM – 5:00 PM Wednesday: 10:00 AM – 6:00 PM Thursday: 10:00 AM – 6:00 PM Friday: 10:00 AM – 6:00 PM Saturday: 10:00 AM – 6:00 PM Sunday: 10:00 AM – 5:00 PM	No photos available