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: 5
Limit per Page: 25
Offset: 100
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 100, 25

Previous Next

Page 5 of 29

Showing 101 to 125 of 705 results

Place ID	Name	Address	Latitude	Longitude	Distance	Category	Search Term	Types	Links	Phone	Hours	Photos
ChIJbQ79gMkrv1QRFcQb1PYvwWs	Cares & Whoas Glamour Ranch Décor & Gifts, Redmond	498 SW 6th St Ste 101, Redmond, OR 97756, USA	44.2727240	-121.1739590	12 m		boutiques, boutiques,shopping,boutiques,shopping, shopping	clothing_store,establishment,point_of_interest,store	Page \| Maps \| Website	(541) 645-3908	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 – 6:00 PM Friday: 10:00 AM – 6:00 PM Saturday: 10:00 AM – 6:00 PM Sunday: 11:00 AM – 4:00 PM	View Photos (4)
ChIJ95ZkFsjUuFQRbWIIrAykI00	Carl’s Jr.	2905 S Hwy 97 STE 100, Redmond, OR 97756, USA	44.2495060	-121.1870070	2,773 m		lunch	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 548-5553	View Hours Monday: 6:00 AM – 12:00 AM Tuesday: 6:00 AM – 12:00 AM Wednesday: 6:00 AM – 12:00 AM Thursday: 6:00 AM – 12:00 AM Friday: 6:00 AM – 12:00 AM Saturday: 6:00 AM – 12:00 AM Sunday: 6:00 AM – 12:00 AM	View Photos (4)
ChIJAXVuQOcrv1QRQTf9OUOBUNw	Carnaval Mexican Grill	343 SW 6th St, Redmond, OR 97756, USA	44.2738830	-121.1745700	150 m		cocktails, restaurants	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 316-6960	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)
ChIJ3c6V-t8rv1QRuV2VmGq2AAE	Cascade Alchemy Bowls	308 SW Evergreen Ave, Redmond, OR 97756, USA	44.2722570	-121.1719330	163 m		breakfast, dining, family friendly, food trucks, juice bars, juice bars,food trucks,restaurants,breakfast,lunch,dining,family friendly,food trucks,breakfast,lunch,family friendly, lunch, restaurants	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website		View Hours Monday: 11:00 AM – 6:00 PM Tuesday: 11:00 AM – 8:00 PM Wednesday: 11:00 AM – 8: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)
ChIJCX__s9cqv1QR1u5PRRinPvI	Cascade Chiropractic & Natural Medicine	716 SW Highland Ave, Redmond, OR 97756, USA	44.2693940	-121.1757970	389 m		massage	establishment,health,point_of_interest	Page \| Maps \| Website	(541) 516-1045	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: Closed Saturday: Closed Sunday: Closed	View Photos (4)
ChIJIbiYuo0rv1QRxaGV5g9o5Jg	Cascade Hop Farm, LLC	7648 NW Poplar Dr, Redmond, OR 97756, USA	44.2929980	-121.2614930	7,330 m		farms	establishment,point_of_interest	Page \| Maps	(530) 520-2061	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: Closed Sunday: Closed	View Photos (4)
ChIJsaeU5yRYx1QRsk9oajNEs-8	Cascade Lakes	Cascade Lakes, Oregon 97413, USA	43.9000000	-121.8000000	64,940 m	outdoors	point of interest	establishment,natural_feature	Page \| Maps			No photos available
ChIJIVMX2dbUuFQRjvs9lAM0rms	Cascade Lakes Brewing Company Production Facility	2141 S 1st St, Redmond, OR 97756, USA	44.2559950	-121.1690650	1,889 m		brewery, microbrewery, pubs, pubs,brewery,microbrewery,brewery,microbrewery	establishment,food,point_of_interest	Page \| Maps \| Website	(541) 923-3110	View Hours Monday: 9:00 AM – 3:00 PM Tuesday: 9:00 AM – 3:00 PM Wednesday: 9:00 AM – 3:00 PM Thursday: 9:00 AM – 3:00 PM Friday: 9:00 AM – 3:00 PM Saturday: Closed Sunday: Closed	View Photos (4)
ChIJSV_XNdYqv1QRBozho0XC10k	Cascade Lakes Pub at 7th St	855 SW 7th St, Redmond, OR 97756, USA	44.2687760	-121.1757060	450 m		bars, bars,cocktails,nightlife,bars,cocktails,nightlife,pubs,brewery,microbrewery,restaurants,lunch,dining,family friendly, brewery, cocktails, dining, family friendly, live music, lunch, microbrewery, nightlife, pubs, restaurants	bar,establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 923-1795	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 – 9:00 PM Saturday: 11:00 AM – 9:00 PM Sunday: 11:00 AM – 8:00 PM	View Photos (4)
ChIJrf19ZDksv1QRoLYRcEXyfCw	Cascade View Trailhead	Eagle Crest Blvd, Redmond, OR 97756, USA	44.2872050	-121.3134920	11,229 m		hiking, hiking,mountain biking,trailheads,hiking,mountain biking,trailheads, mountain biking, trailheads	establishment,point_of_interest	Page \| Maps \| Website		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)
ChIJQ46dCckrv1QR5606ebwyuuY	Casee’s Coffee	106 SE Evergreen Ave Ste b, Redmond, OR 97756, USA	44.2723610	-121.1680570	468 m		coffee shops, coffee shops,lunch	cafe,establishment,food,point_of_interest,store	Page \| Maps	(541) 316-5770	View Hours Monday: 6:30 AM – 4:00 PM Tuesday: 6:30 AM – 4:00 PM Wednesday: 6:30 AM – 4:00 PM Thursday: 6:30 AM – 4:00 PM Friday: 6:30 AM – 4:00 PM Saturday: 8:00 AM – 2:00 PM Sunday: 8:00 AM – 2:00 PM	View Photos (4)
ChIJGfOnCm3VuFQRPGo7EPCbVvo	Casee’s Coffee	3294 S Hwy 97 Ste 2, Redmond, OR 97756, USA	44.2456300	-121.1891960	3,238 m		coffee shops	cafe,establishment,food,point_of_interest,store	Page \| Maps \| Website	(541) 419-9039	View Hours Monday: 7:00 AM – 12:00 AM Tuesday: 7:00 AM – 1:00 PM Wednesday: 7:00 AM – 1:00 PM Thursday: 7:00 AM – 1:00 PM Friday: 7:00 AM – 1:00 PM Saturday: Closed Sunday: Closed	View Photos (4)
ChIJJUmrfdsqv1QRf6qgLozqdNU	Cash Connection Redmond – Pawn Shop	132 NW 6th St, Redmond, OR 97756, USA	44.2770780	-121.1739090	496 m		antiques	establishment,finance,jewelry_store,point_of_interest,store	Page \| Maps \| Website	(541) 923-6501	View Hours Monday: 9:00 AM – 5:30 PM Tuesday: 9:00 AM – 5:30 PM Wednesday: 9:00 AM – 5:30 PM Thursday: 9:00 AM – 5:30 PM Friday: 9:00 AM – 5:30 PM Saturday: 10:00 AM – 5:30 PM Sunday: Closed	View Photos (2)
ChIJR71vGUfVuFQRxfoI_oXTxkk	Cassity’s Bar	2498 S Hwy 97, Redmond, OR 97756, USA	44.2525650	-121.1830280	2,345 m		nightlife, nightlife,pubs, pubs	bar,establishment,point_of_interest	Page \| Maps \| Website			No photos available
ChIJaW1j0iskuVQReHJK9ifONIo	Castle Rock Campground	Castle Rock Campground Rd, Prineville, OR 97754, USA	44.1574640	-120.8348010	29,907 m		campgrounds	campground,establishment,lodging,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)
ChIJ5a50EZfVuFQRdUa7_9Yk2q8	CCS Community Theatre 24-25	2731 SW Airport Wy, Redmond, OR 97756, USA	44.2500750	-121.1707590	2,520 m		theatres	establishment,point_of_interest	Page \| Maps	(541) 699-1799		No photos available
ChIJsb5M9Mgrv1QR9yUd0TKcyMI	Centennial Park	433 SW 8th St, Redmond, OR 97756, USA	44.2727520	-121.1759680	164 m		family friendly, farmers markets, farmers markets,family friendly,parks,farmers markets,family friendly,parks, parks	establishment,park,point_of_interest	Page \| Maps			View Photos (4)
ChIJY4EDyf0rv1QRfao4lObgIRw	Centennial Park	446 SW 9th St, Redmond, OR 97756, USA	44.2728110	-121.1772400	265 m		family friendly, farmers markets, farmers markets,family friendly,parks,family friendly,parks, 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)
ChIJqW0St6TIuFQRRnJ21RfSg1I	Center Fire Gunworks	460 NE Hemlock Ave Ste f, Redmond, OR 97756, USA	44.2832700	-121.1641560	1,417 m		shooting ranges	establishment,point_of_interest,store	Page \| Maps	(541) 633-7377	View Hours Monday: 8:00 – 11:00 AM, 12:00 – 5:00 PM Tuesday: 8:00 – 11:00 AM, 12:00 – 5:00 PM Wednesday: 8:00 – 11:00 AM, 12:00 – 5:00 PM Thursday: Closed Friday: Closed Saturday: Closed Sunday: Closed	View Photos (2)
ChIJn4klliIxhUcRQtHt0Jk-ko8	Central Oregon Barbecue Company	404 SW Forest Ave, Redmond, OR 97756, USA	44.2714210	-121.1723200	185 m		food trucks	establishment,food,point_of_interest	Page \| Maps \| Website	(541) 870-0982	View Hours Monday: Closed Tuesday: 12:00 – 7:00 PM Wednesday: 12:00 – 7:00 PM Thursday: 12:00 – 7:00 PM Friday: 12:00 – 7:00 PM Saturday: 12:00 – 7:00 PM Sunday: Closed	View Photos (4)
ChIJG30K8EzXvlQRy_JvRkBXnYE	Central Oregon Bungee Adventures	12597 US-97, Terrebonne, OR 97760, Located in: Peter Skene Ogden State Scenic Viewpoint, Culver, OR 97734, USA	44.3926680	-121.1936470	13,441 m		tourist attraction	establishment,point_of_interest,tourist_attraction	Page \| Maps \| Website	(541) 668-5867	View Hours Monday: Closed Tuesday: Closed Wednesday: Closed Thursday: Closed Friday: Closed Saturday: 10:00 AM – 4:00 PM Sunday: 10:00 AM – 4:00 PM	View Photos (4)
ChIJVXzeSsUqv1QR0kbaK7Q9lRE	Central Oregon Custom Meats – Redmond Smokehouse	353 SE Railroad Blvd, Redmond, OR 97756, USA	44.2750270	-121.1679330	547 m		farms, grocery stores, markets, markets,grocery stores,meat markets,smokehouses,markets,farms,meat markets,smokehouses, meat markets, smokehouses	establishment,food,point_of_interest,store	Page \| Maps \| Website	(541) 548-5575	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: 9:00 AM – 3:00 PM Sunday: Closed	View Photos (4)
ChIJwb4ESygrv1QRXRPwlPrWDCs	Central Oregon Eyecare – Redmond	1000 SW Indian Ave, Redmond, OR 97756, USA	44.2682840	-121.1791300	636 m		shopping	doctor,establishment,health,point_of_interest,store	Page \| Maps \| Website	(541) 548-2488	View Hours Monday: 8:00 AM – 1:00 PM, 2:00 – 5:00 PM Tuesday: 8:00 AM – 1:00 PM, 2:00 – 5:00 PM Wednesday: 8:00 AM – 1:00 PM, 2:00 – 5:00 PM Thursday: 8:00 AM – 1:00 PM, 2:00 – 5:00 PM Friday: 8:00 AM – 1:00 PM, 2:00 – 5:00 PM Saturday: Closed Sunday: Closed	View Photos (4)
ChIJAQDQSsUqv1QRMUKfK-szP2U	Central Oregon Mobile Butcher	353 SE Railroad Blvd #2342, Redmond, OR 97756, USA	44.2750680	-121.1680010	544 m		meat markets	establishment,food,point_of_interest,store	Page \| Maps	(541) 610-2468	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: Closed Sunday: Closed	No photos available
ChIJbVS0ae_SuFQRSy6uZc1HYo0	Central Oregon Ostrich	7600 SW Quarry Ave, Redmond, OR 97756, USA	44.2091130	-121.2605740	9,875 m		farms	establishment,food,general_contractor,point_of_interest	Page \| Maps \| Website	(541) 923-5076		View Photos (3)