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: 15
Limit per Page: 25
Offset: 350
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 350, 25

Previous Next

Page 15 of 29

Showing 351 to 375 of 705 results

Place ID	Name	Address	Latitude	Longitude	Distance	Category	Search Term	Types	Links	Phone	Hours	Photos
ChIJhe4W1cMrv1QRFB_XQxeCGjA	Kauboi Natural Beef	655 SW 7th St, Redmond, OR 97756, USA	44.2707290	-121.1756150	250 m		farms, farms,meat markets,markets,farms,meat markets, grocery stores, markets, meat markets	establishment,food,point_of_interest,store	Page \| Maps \| Website	(541) 699-3141	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)
ChIJh637HLjUuFQRTDyVv_Hq2tY	KFC	1719 SW Wickiup Ave, Redmond, OR 97756, USA	44.2476510	-121.1874210	2,977 m		lunch	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 548-8480	View Hours Monday: 10:30 AM – 9:00 PM Tuesday: 10:30 AM – 9:00 PM Wednesday: 10:30 AM – 9:00 PM Thursday: 10:30 AM – 9:00 PM Friday: 10:30 AM – 9:00 PM Saturday: 10:30 AM – 9:00 PM Sunday: 10:30 AM – 9:00 PM	View Photos (3)
ChIJ6_6oTHvNuFQRJww5KCkV_d8	Khalsa Hands Massage	708 SW Deschutes Ave, Redmond, OR 97756, USA	44.2734120	-121.1756510	163 m		massage	establishment,point_of_interest	Page \| Maps	(541) 548-6556	View Hours Monday: 8:00 AM – 6:30 PM Tuesday: 8:00 AM – 6:30 PM Wednesday: 8:00 AM – 6:30 PM Thursday: 8:00 AM – 6:30 PM Friday: 8:00 AM – 6:30 PM Saturday: 8:00 AM – 6:30 PM Sunday: Closed	No photos available
ChIJ1bL8qynVuFQR_lqasnGI4IM	KNS Hot Tubs	535 NE Jackpine Ct Unit 101, Redmond, OR 97756, USA	44.2857720	-121.1632730	1,690 m		spas	establishment,point_of_interest,store	Page \| Maps \| Website	(541) 923-1063	View Hours Monday: Closed Tuesday: 9:00 AM – 4:00 PM Wednesday: 9:00 AM – 4:00 PM Thursday: 9:00 AM – 4:00 PM Friday: 9:00 AM – 4:00 PM Saturday: 9:00 AM – 2:00 PM Sunday: Closed	View Photos (4)
ChIJNaNoydsqv1QRIdhVgJDdxIw	Kobold Brewing The Vault	food trucks (edited)	44.2748000	-121.1745060	247 m	restaurants,beer-wine-spirits (edited)	brewery (edited)	establishment,food,point_of_interest	Page \| Maps \| Website	(541) 504-9373	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 – 10:00 PM Friday: 11:00 AM – 10:00 PM Saturday: 11:00 AM – 10:00 PM Sunday: 11:00 AM – 8:00 PM	View Photos (4)
ChIJ773SkGjHuFQRYTQjK2CjrQ0	Kooki	235 SW 6th St, Redmond, OR 97756, USA	44.2749580	-121.1745550	265 m		bakeries, coffee shops, coffee shops,bakeries,desserts,coffee shops,bakeries,desserts,shopping, desserts	bakery,cafe,establishment,food,point_of_interest,store	Page \| Maps \| Website	(541) 527-4855	View Hours Monday: Closed Tuesday: 9:00 AM – 3:00 PM Wednesday: 8:00 AM – 3:00 PM Thursday: 8:00 AM – 3:00 PM Friday: 8:00 AM – 3:00 PM Saturday: 9:00 AM – 2:00 PM Sunday: Closed	View Photos (4)
ChIJyS5ZBP4rv1QRnVyYthMZvHo	Krispy Krunchy Chicken	401 NW Quince Ave, Redmond, OR 97756, USA	44.2986840	-121.1728290	2,899 m		restaurants	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 923-0669	View Hours Monday: 7:00 AM – 11:00 PM Tuesday: 7:00 AM – 11:00 PM Wednesday: 7:00 AM – 11:00 PM Thursday: 7:00 AM – 11:00 PM Friday: 7:00 AM – 11:00 PM Saturday: 7:00 AM – 11:00 PM Sunday: 7:00 AM – 11:00 PM	View Photos (4)
ChIJBUQjQ2srv1QRayFkvHI_ges	L	lunch (edited)	44.2712790	-121.1767310	269 m	restaurants (edited)	restaurants (edited)	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	dining (edited)	View Hours Monday: Closed 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 – 11:00 PM Saturday: 11:00 AM – 11:00 PM Sunday: 11:00 AM – 9:00 PM	View Photos (4)
ChIJSxhhhpIrv1QRsr6GyJaZqOw	La Birria Republic	122 SW 5th St, Redmond, OR 97756, USA	44.2760920	-121.1729770	393 m		family friendly, food trucks, food trucks,restaurants,lunch,family friendly,food trucks,restaurants,family friendly, lunch, restaurants	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(801) 909-8095	View Hours Monday: Closed Tuesday: 10:30 AM – 8:00 PM Wednesday: 10:30 AM – 8:30 PM Thursday: 10:30 AM – 8:30 PM Friday: 10:30 AM – 8:30 PM Saturday: 10:30 AM – 8:30 PM Sunday: 10:30 AM – 8:30 PM	View Photos (4)
ChIJ60sQqbYrv1QRjNMwE9a37jE	La Bonita Brunch	958 NW 6th St, Redmond, OR 97756, USA	44.2851670	-121.1729210	1,397 m		bars, bars,breakfast,lunch,dining,family friendly,bars,restaurants,breakfast,dining, breakfast, dining, family friendly, lunch	establishment,food,point_of_interest,restaurant	Page \| Maps	(541) 678-4991	View Hours Monday: 7:00 AM – 2:30 PM Tuesday: 7:00 AM – 2:30 PM Wednesday: 7:00 AM – 2:30 PM Thursday: 7:00 AM – 2:30 PM Friday: 7:00 AM – 2:30 PM Saturday: 7:00 AM – 2:00 PM Sunday: Closed	View Photos (4)
ChIJJbfAg87UuFQR-bGTUcYnIB4	La Frontera	2330 S Hwy 97 #8873, Redmond, OR 97756, USA	44.2544620	-121.1821500	2,123 m		breakfast, lunch, restaurants	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 275-6389	View Hours Monday: 7:00 AM – 7:00 PM Tuesday: 7:00 AM – 7:00 PM Wednesday: 7:00 AM – 7:00 PM Thursday: 7:00 AM – 7:00 PM Friday: 7:00 AM – 7:00 PM Saturday: 7:00 AM – 7:00 PM Sunday: Closed	View Photos (4)
ChIJfRfuN9PUuFQRs1P7QLdg5Kc	La Frontera Bakery	1604 S Hwy 97, Redmond, OR 97756, USA	44.2604060	-121.1779640	1,396 m		bakeries, bakeries,desserts,bakeries,desserts, desserts	bakery,establishment,food,point_of_interest,store	Page \| Maps \| Website	(541) 548-8022	View Hours Monday: 8:00 AM – 8:00 PM Tuesday: 8:00 AM – 8:00 PM Wednesday: 8:00 AM – 8:00 PM Thursday: 8:00 AM – 8:00 PM Friday: 8:00 AM – 8:00 PM Saturday: 8:00 AM – 8:00 PM Sunday: 8:00 AM – 8:00 PM	View Photos (4)
ChIJeQv5HCgrv1QRkw7opOoGuuo	La Posada Mexican Grill	1029 SW Highland Ave, Redmond, OR 97756, USA	44.2697460	-121.1789850	515 m		breakfast, restaurants	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 923-7448	View Hours Monday: 7:00 AM – 12:00 AM Tuesday: 7:00 AM – 12:00 AM Wednesday: 7:00 AM – 12:00 AM Thursday: 7:00 AM – 12:00 AM Friday: 7:00 AM – 1:00 AM Saturday: 7:00 AM – 12:00 AM Sunday: 7:00 AM – 12:00 AM	View Photos (4)
ChIJZ9UPn7DGuFQRJyuNFsdlgnA	Ladies Of Lead Group Therapy, LLC	905 SW Rimrock Way Ste 101A, Redmond, OR 97756, USA	44.2681180	-121.1930980	1,607 m		shooting ranges	establishment,point_of_interest,store	Page \| Maps \| Website	(541) 788-5858	View Hours Monday: Closed Tuesday: 12:00 – 5:00 PM Wednesday: 12:00 – 5:00 PM Thursday: 12:00 – 5:00 PM Friday: 12:00 – 5:00 PM Saturday: Closed Sunday: Closed	View Photos (4)
ChIJwx-908Iqv1QRGe04rDL_pt8	Lady Bug Flowers & Gifts	209 SW 5th St, Redmond, OR 97756, USA	44.2754220	-121.1735350	313 m		gift shops	establishment,florist,point_of_interest,store	Page \| Maps \| Website	(541) 548-6188	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 – 2:00 PM Sunday: Closed	View Photos (4)
ChIJOWuwNGorv1QRV_JZNgjJpvg	Larkin Valley Ranch	695 SW Helmholtz Way, Redmond, OR 97756, USA	44.2697340	-121.2204420	3,718 m		farmers markets, farmers markets,markets,farms,meat markets,farmers markets,markets,farms,meat markets, farms, markets, meat markets	establishment,food,point_of_interest,store	Page \| Maps \| Website	(541) 420-0879	View Hours Monday: Closed Tuesday: Closed Wednesday: Closed Thursday: 10:00 AM – 6:00 PM Friday: 10:00 AM – 6:00 PM Saturday: 10:00 AM – 3:00 PM Sunday: Closed	View Photos (4)
ChIJ216Xg87UuFQRPim-k47dpok	Latrontera Mini Market	Redmond, OR 97756, USA	44.2542310	-121.1820710	2,145 m		juice bars	establishment,food,grocery_or_supermarket,point_of_interest,store	Page \| Maps			No photos available
ChIJK4AEqoTHuFQR8miVL66lOW8	Lattanzi Spa	339 SW 6th St, Redmond, OR 97756, USA	44.2740090	-121.1745760	163 m		massage, massage,spas	establishment,point_of_interest,spa	Page \| Maps \| Website	(541) 350-5912	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: Closed Sunday: Closed	View Photos (4)
ChIJI8dU-Nkqv1QRbiwtBFPPSso	Lava Springs Spa Care	Redmond, OR 97756, USA	44.2726580	-121.1739210	4 m		spas	establishment,point_of_interest	Page \| Maps \| Website	(541) 280-4352		No photos available
ChIJiQq70Scrv1QRHz6zY0wbg-s	Lavender Thrift & Gift	724 SW 14th St, Redmond, OR 97756, USA	44.2701030	-121.1826330	748 m		gift shops, shopping, thrift stores, thrift stores,vintage	establishment,point_of_interest,store	Page \| Maps \| Website	(541) 390-1594	View Hours Monday: Closed Tuesday: Closed Wednesday: Closed Thursday: Closed Friday: 12:00 – 4:30 PM Saturday: 12:00 – 4:30 PM Sunday: Closed	View Photos (1)
ChIJg-XAvMIqv1QRteJgcoy2g7Y	Lee Petmecky Massage	636 NW 6th St c, Redmond, OR 97756, USA	44.2815050	-121.1739190	988 m		massage	establishment,health,point_of_interest	Page \| Maps	(541) 815-4011		No photos available
ChIJGS2rrl3N-oYRIMtQgBP0rRw	Liberation Firearms Training	430 SE Evergreen Ave, Redmond, OR 97756, USA	44.2722920	-121.1656100	663 m	outdoors (edited)	hunting (edited)	establishment,point_of_interest,store	Page \| Maps \| Website	(458) 899-5215	View Hours Monday: Closed Tuesday: 10:00 AM – 6:00 PM Wednesday: 10:00 AM – 6:00 PM Thursday: 10:00 AM – 6:00 PM Friday: 10:00 AM – 7:00 PM Saturday: 10:00 AM – 7:00 PM Sunday: Closed	View Photos (4)
ChIJE6w2StQqv1QR_nLbWKXA5og	Lions Lake	Lions Lake, Redmond, OR 97756, USA	44.2666850	-121.1704860	714 m		fishing	establishment,natural_feature	Page \| Maps			View Photos (4)
ChIJL1E4k88rv1QRBOuVBDNeEHM	Little & Luxe	239 SW 6th St, Redmond, OR 97756, USA	44.2749280	-121.1745480	261 m		gift shops, gift shops,shopping,gift shops,shopping, shopping	clothing_store,establishment,point_of_interest,store	Page \| Maps \| Website	(541) 233-6855	View Hours Monday: 11:00 AM – 4: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: Closed	View Photos (4)
ChIJIY4A5uUrv1QRrwJL41M8GwA	Little Bug Play Hub	528 SW 6th St, Redmond, OR 97756, USA	44.2720500	-121.1739590	64 m		family fun, family fun,parks,family fun,parks, parks, playgrounds	establishment,point_of_interest	Page \| Maps \| Website	(541) 238-6701	View Hours Monday: Closed Tuesday: 9:30 AM – 5:00 PM Wednesday: 9:30 AM – 5:00 PM Thursday: 9:30 AM – 5:00 PM Friday: 9:30 AM – 5:00 PM Saturday: 10:00 AM – 5:00 PM Sunday: Closed	View Photos (4)