Data

Debug Info (admin only)

Search Criteria:

Keyword: None
Categories: None
Search Terms: None
Types: None
Show Unpublished: Yes
Sort: place_id
Order: DESC

Pagination:

Current Page: 2
Limit per Page: 25
Offset: 25
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 p.place_id DESC LIMIT 25, 25

Previous Next

Page 2 of 24

Showing 26 to 50 of 583 results

Place ID ↓	Name	Address	Latitude	Longitude	Distance	Category	Search Term	Types	Links	Phone	Hours	Photos
ChIJyR2EdNoqv1QRRsZZ3yPCE4s	Beyond the Ranch Antiques	339 SW Evergreen Ave, Redmond, OR 97756, USA	44.2727870	-121.1718870	163 m		antiques, 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)
ChIJYfRBprTZvlQRzJOpZP1z9-M	Mom’s Kitchen Catering Co.	528 SW 6th St, Redmond, OR 97756, USA	44.2720480	-121.1740020	64 m		desserts	establishment,food,point_of_interest	Page \| Maps \| Website	(541) 213-9696	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: 11:00 AM – 9:00 PM	View Photos (4)
ChIJYbd4bq4muVQRx-ZgTg9MOv8	Palisades Campground	Palisades Campground, Crooked River Hwy, Prineville, OR 97754, USA	44.1315820	-120.8221660	32,127 m		campgrounds	campground,establishment,lodging,park,point_of_interest	Page \| Maps \| Website	(541) 416-6700	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)
ChIJYaI95M4rv1QRyBBptKy5p9A	Two Gifty Girls	433 SW 6th St, Redmond, OR 97756, USA	44.2730350	-121.1745290	67 m		boutiques, gift shops	clothing_store,establishment,food,grocery_or_supermarket,home_goods_store,point_of_interest,store	Page \| Maps \| Website	(541) 516-1955	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: 11:00 AM – 4:00 PM	View Photos (4)
ChIJY7x3pWcrv1QRH7zW0Ps6WwM	Provisions Market at SCP Redmond	521 SW 6th St, Redmond, OR 97756, USA	44.2722780	-121.1745490	63 m		bakeries, breakfast, coffee shops	cafe,establishment,food,point_of_interest,restaurant,store	Page \| Maps \| Website	(541) 508-7600	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)
ChIJY4EDyf0rv1QRfao4lObgIRw	Centennial Park	446 SW 9th St, Redmond, OR 97756, USA	44.2728110	-121.1772400	265 m		farmers markets, parks	establishment,park,point_of_interest	Page \| Maps \| Website		View Hours Monday: 10:00 AM – 6:00 PM 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 – 6:00 PM Saturday: 10:00 AM – 6:00 PM Sunday: 10:00 AM – 6:00 PM	View Photos (4)
ChIJy1RrCtcqv1QRJcCTGwZQXzI	Aziz Crew Barber Shop	2498 S Hwy 97 Suit C, Redmond, OR 97756, USA	44.2525650	-121.1830280	2,345 m		pool tables	establishment,hair_care,health,point_of_interest	Page \| Maps \| Website	(541) 668-3397	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 – 6:00 PM Saturday: 10:00 AM – 2:00 PM Sunday: Closed	View Photos (4)
ChIJy0D6fH4rv1QRGnOfHmBix98	Smith Rock BMX	1935 NE Maple Ave, Redmond, OR 97756, USA	44.2912600	-121.1455990	3,062 m		mountain biking	establishment,point_of_interest	Page \| Maps \| Website	(541) 316-0005		View Photos (4)
ChIJY-h15QLTuFQRnmWKhW1y2KM	Well Rooted Farms – Redmond Farm Stand	4700 SW 43rd St, Redmond, OR 97756, USA	44.2317990	-121.2190520	5,790 m		farms	establishment,food,point_of_interest,store	Page \| Maps \| Website	(458) 202-9968	View Hours Monday: 7:00 AM – 8:00 PM Tuesday: 7:00 AM – 8:00 PM Wednesday: 7:00 AM – 8:00 PM Thursday: 7:00 AM – 8:00 PM Friday: 7:00 AM – 8:00 PM Saturday: 7:00 AM – 8:00 PM Sunday: 7:00 AM – 8:00 PM	View Photos (1)
ChIJxYoUXJUqv1QR2h-mzXNFo5w	Gompers Distillery and Speakeasy	611 NE Jackpine Ct #8, Redmond, OR 97756, USA	44.2861270	-121.1627710	1,745 m		bars, brewery, cocktails, distillery, farmers markets, nightlife	bar,establishment,point_of_interest,tourist_attraction	Page \| Maps \| Website	(541) 588-2825	View Hours Monday: Closed Tuesday: Closed Wednesday: 3:00 – 8:00 PM Thursday: 3:00 – 8:00 PM Friday: 3:00 – 8:00 PM Saturday: 3:00 – 8:00 PM Sunday: Closed	View Photos (4)
ChIJxXzWB1HYvlQRzv1H7eOJJbA	Coyote’s Den Disc Golf Course (edited)	Ranch House Road, Terrebonne, OR 97760, USA (edited)	44.4337340	-121.2520910	18,963 m	golf, outdoors, recreation (edited)	disc golf (edited)	point_of_interest,establishment (edited)	Page \| Maps	(541) 604-9115		View Photos (4)
ChIJxXHU_fUpv1QR6XZd-7yQqLg	Thordarson Farms Redmond,Oregon	Redmond, OR 97756, USA	44.3189160	-121.2698500	9,208 m		farms	establishment,point_of_interest	Page \| Maps			No photos available
ChIJxRgmxNwqv1QRAvW1K4af86I	City Center Motel	350 NW 6th St, Redmond, OR 97756, USA	44.2788810	-121.1739190	696 m		hotels	establishment,lodging,point_of_interest	Page \| Maps	(541) 548-3447		View Photos (4)
ChIJxQLW4qcmuVQR21i6am9TyU8	Chimney Rock Campground	Chimney Rock Campground, Crooked River Hwy, Prineville, OR 97754, USA	44.1375110	-120.8162650	32,225 m		campgrounds	campground,establishment,lodging,park,point_of_interest	Page \| Maps \| Website	(541) 416-6700		View Photos (4)
ChIJxc72pugrv1QRkz_TL0pGE4U	Art & Music	232 SW 5th St, Redmond, OR 97756, USA	44.2749500	-121.1729040	271 m		live music	art_gallery,establishment,point_of_interest,store	Page \| Maps \| Website	(541) 527-4426	View Hours Monday: 11:00 AM – 5:00 PM Tuesday: 11:00 AM – 6:00 PM Wednesday: 11:00 AM – 6:00 PM Thursday: 11:00 AM – 6:00 PM Friday: 11:00 AM – 6:00 PM Saturday: 12:00 – 4:00 PM Sunday: 12:00 – 4:00 PM	View Photos (4)
ChIJxc5OK-gtv1QRqNEV0UDpCWw	NEK Farm & Pheasants	7117 SW Wickiup Ave, Redmond, OR 97756, USA	44.2490970	-121.2540620	6,897 m		farms	establishment,point_of_interest	Page \| Maps \| Website	(541) 728-7100	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)
ChIJxbIW-HIrv1QRKOA4ppkNBSg	Wild catch foodtruck	332 SW 5th St, Redmond, OR 97756, USA	44.2740610	-121.1729140	179 m		brewery, food trucks, lunch, restaurants	establishment,food,point_of_interest,restaurant	Page \| Maps	(541) 480-1677	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 – 10:00 PM Saturday: 11:00 AM – 10:00 PM Sunday: 11:00 AM – 10:00 PM	View Photos (4)
ChIJXbFHJCUrv1QRLDjb_Nxn8wY	Nolan Town Center	782 SW Rimrock Way, Redmond, OR 97756, USA	44.2685070	-121.1929330	1,581 m		markets, shopping	establishment,point_of_interest,shopping_mall	Page \| Maps		View Hours Monday: 4:00 AM – 7:30 PM Tuesday: 4:00 AM – 7:30 PM Wednesday: 4:00 AM – 7:30 PM Thursday: 4:00 AM – 7:30 PM Friday: 4:00 AM – 7:30 PM Saturday: 4:30 AM – 7:00 PM Sunday: 4:30 AM – 7:00 PM	View Photos (4)
ChIJX81aCKorv1QRi-Sdc9Txutc	Homestead Pump Track	767 NW Canal Blvd, Redmond, OR 97756, USA	44.2834450	-121.1686740	1,274 m	outdoors	mountain biking, parks, point-of-interest	establishment,point_of_interest	Page \| Maps \| Website	(541) 504-2000	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: 7:00 AM – 7: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	establishment,point_of_interest	Page \| Maps	(541) 527-4723		No photos available
ChIJX4VPJiYrv1QR9fzg60yjcvA	Schoolhouse Produce	1430 SW Highland Ave, Redmond, OR 97756, USA	44.2693440	-121.1837840	866 m		farmers markets, grocery stores, markets, meat markets	establishment,food,grocery_or_supermarket,point_of_interest,store	Page \| Maps \| Website	(541) 504-7112	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: 10:00 AM – 4:00 PM Sunday: 12:00 – 4:00 PM	View Photos (4)
ChIJX3lxD9cqv1QRGsRRgN15nUU	JOANN Fabric and Crafts	732 SW 6th St, Redmond, OR 97756, USA	44.2702520	-121.1736000	265 m		shopping	establishment,home_goods_store,point_of_interest,store	Page \| Maps \| Website	(541) 548-8042	View Hours Monday: 9:00 AM – 9:00 PM 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: 10:00 AM – 6:00 PM	View Photos (4)
ChIJX-XSYXcqv1QR4ew3fjPAnyk	Cinder Butte Meat Co.	197 NW Oneil Way, Redmond, OR 97756, USA	44.3138660	-121.1697480	4,598 m		markets, meat markets	establishment,food,point_of_interest,store	Page \| Maps \| Website	(541) 548-6328	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: 9:00 AM – 3:00 PM Sunday: Closed	View Photos (4)
ChIJwzUf4i4rv1QR2gC0jG6ZtCo	Mo’s Egg House	950 SW Veterans Way, Redmond, OR 97756, USA	44.2674830	-121.1788790	694 m		breakfast	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 527-4314	View Hours Monday: 6:30 AM – 2:00 PM Tuesday: 6:30 AM – 2:00 PM Wednesday: 6:30 AM – 2:00 PM Thursday: 6:30 AM – 2:00 PM Friday: 6:30 AM – 2:00 PM Saturday: 7:00 AM – 2:00 PM Sunday: 7:00 AM – 2:00 PM	View Photos (4)
ChIJwYUqt4Arv1QRCWGsJRL38Uw	Helmholtz Farm Stand	2087 SW Helmholtz Way, Redmond, OR 97756, USA	44.2564260	-121.2209910	4,158 m		farmers markets, markets	establishment,food,point_of_interest,store	Page \| Maps \| Website		View Hours Monday: Closed Tuesday: Closed Wednesday: Closed Thursday: Closed Friday: 10:00 AM – 4:00 PM Saturday: 10:00 AM – 4:00 PM Sunday: 10:00 AM – 4:00 PM	View Photos (4)