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: 9
Limit per Page: 25
Offset: 200
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.name, p.name) ASC LIMIT 200, 25

Previous Next

Page 9 of 24

Showing 201 to 225 of 583 results

Place ID	Name	Address	Latitude	Longitude	Distance	Category	Search Term	Types	Links	Phone	Hours	Photos
ChIJOW2XIbPUuFQR08Icq0R1NME	Events By Design, Event Rentals of Oregon	2615 SW 30th St, Redmond, OR 97756, USA	44.2518730	-121.2033700	3,290 m		event venues	establishment,home_goods_store,point_of_interest,store	Page \| Maps \| Website	(541) 903-2139	View Hours Monday: 7:00 AM – 10:00 PM Tuesday: 7:00 AM – 10:00 PM Wednesday: 7:00 AM – 10:00 PM Thursday: 7:00 AM – 10:00 PM Friday: 7:00 AM – 10:00 PM Saturday: 7:00 AM – 10:00 PM Sunday: 7:00 AM – 10:00 PM	View Photos (4)
ChIJfwqxzNsqv1QRIEjigKAaNRM	Every Bloom’n Thing	251 SW 6th St, Redmond, OR 97756, USA	44.2750350	-121.1744570	272 m		gift shops	establishment,florist,point_of_interest,store	Page \| Maps \| Website	(541) 504-9777	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)
ChIJfd4jwJnUuFQRGAPvzIvPFMw	Expo Center RV Park (edited)	4690 SW 19th St, Redmond, OR 97756, USA (edited)	44.2336370	-121.1881630	4,481 m	rv-parks-camping (edited)	rv parks (edited)	rv_park,lodging,point_of_interest,establishment (edited)	Page \| Maps \| Website (edited)	(541) 585-1569	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)
ChIJL8JWIx8rv1QRghnnBa2wimU	Fairhaven City Park	370 NW 23rd St, Redmond, OR 97756, USA	44.2776290	-121.1949680	1,766 m		parks	establishment,park,point_of_interest	Page \| Maps	(541) 548-7275	View Hours Monday: 6:30 AM – 8:00 PM Tuesday: 6:30 AM – 8:00 PM Wednesday: 6:30 AM – 8:00 PM Thursday: 6:30 AM – 8:00 PM Friday: 6:30 AM – 8:00 PM Saturday: 6:30 AM – 8:00 PM Sunday: 6:30 AM – 8:00 PM	View Photos (4)
ChIJbcRszS0vv1QRPJ0woaqPeFw	Faith Hope & Charity Vineyards	70450 NW Lower Valley Dr, Terrebonne, OR 97760, USA	44.3447630	-121.3328980	14,979 m	beer-wine-spirits (edited)	vineyards (edited)	establishment,food,point_of_interest	Page \| Maps \| Website	(541) 526-5075	View Hours Monday: 12:00 – 5:00 PM 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: 12:00 – 5:00 PM Sunday: 12:00 – 5:00 PM	View Photos (4)
ChIJA-zUll8rv1QRnbxgiawxBzA	Famous Footwear	367 NW Oak tree Ln SUITE 170, Redmond, OR 97756, USA	44.2946210	-121.1713260	2,455 m		shopping	establishment,point_of_interest,shoe_store,store	Page \| Maps \| Website	(541) 604-3116	View Hours Monday: 10:00 AM – 8:00 PM Tuesday: 10:00 AM – 8:00 PM Wednesday: 10:00 AM – 8:00 PM Thursday: 10:00 AM – 8:00 PM Friday: 10:00 AM – 8:00 PM Saturday: 10:00 AM – 8:00 PM Sunday: 10:00 AM – 6:00 PM	No photos available
ChIJ872DeEWxuFQRZrbIFmucvng	Farewell Trail	Oregon 97703, USA	44.0385810	-121.5646660	40,607 m		mountain biking	establishment,gym,health,point_of_interest	Page \| Maps \| Website		View Hours Monday: 5:30 AM – 8:00 PM Tuesday: 5:30 AM – 8:00 PM Wednesday: 5:30 AM – 8:00 PM Thursday: 5:30 AM – 8:00 PM Friday: 5:30 AM – 8:00 PM Saturday: 7:00 AM – 7:00 PM Sunday: 7:00 AM – 7:00 PM	View Photos (2)
ChIJv55JZ5jUuFQRNsyaDnusRDE	Farm To Friends Country Markets	2122 SW Deerhound Ave # 5, Redmond, OR 97756, USA	44.2351350	-121.1918150	4,405 m		markets, meat markets	establishment,food,grocery_or_supermarket,health,point_of_interest,store	Page \| Maps	(541) 526-7201		View Photos (4)
ChIJOYjHWdAqv1QRs1kl_odTSZo	Farmers Cooperative Antiques (edited)	106 SE Evergreen Ave # A, Redmond, OR 97756, USA (edited)	44.2724420	-121.1685410	429 m	market-farms, shopping (edited)	antiques,vintage (edited)	home_goods_store,store,point_of_interest,establishment (edited)	Page \| Maps	(541) 548-7975	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: 10:00 AM – 5:00 PM	View Photos (4)
ChIJm6PR1GUrv1QR73Esk_rHfyk	Feast Food Company	546 NW 7th St, Redmond, OR 97756, USA	44.2807790	-121.1750780	912 m		bars, cocktails, dining, food trucks, live music, lunch, pubs, restaurants	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 923-0170	View Hours Monday: 11:00 AM – 8:00 PM Tuesday: Closed Wednesday: Closed Thursday: 11:00 AM – 8:00 PM Friday: 11:00 AM – 8:00 PM Saturday: 11:00 AM – 8:00 PM Sunday: 10:00 AM – 8:00 PM	View Photos (4)
ChIJkRycFiUrv1QRA-wuAFCXR6c	Fiesta Mazatlan Family Mexican Restaurant	905 SW Rimrock Way, Redmond, OR 97756, USA	44.2681180	-121.1930980	1,607 m		lunch	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 548-1595	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 – 9:00 PM Saturday: 11:00 AM – 9:00 PM Sunday: 11:00 AM – 9:00 PM	View Photos (4)
ChIJl9Bm-9kqv1QReqmWHIPzmOQ	Fin & Fire	1604 S Hwy 97, Redmond, OR 97756, USA	44.2602890	-121.1779120	1,408 m		fishing	establishment,point_of_interest,store	Page \| Maps \| Website	(541) 548-1503	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: 9:00 AM – 5:00 PM Sunday: 9:00 AM – 5:00 PM	View Photos (4)
ChIJSfDiLh8pv1QRGaSykdvFp_4	Firefly Fields Northwest	3250 NW Odem Ave, Terrebonne, OR 97760, USA	44.3408040	-121.2059060	7,997 m		farms	establishment,point_of_interest	Page \| Maps \| Website	(541) 604-8330	View Hours Monday: 8:00 AM – 7:00 PM Tuesday: 8:00 AM – 7:00 PM Wednesday: 8:00 AM – 7:00 PM Thursday: 8:00 AM – 7:00 PM Friday: 8:00 AM – 7:00 PM Saturday: 8:00 AM – 7:00 PM Sunday: 8:00 AM – 7:00 PM	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)
ChIJgUThwhnMuFQR6cfTBOP0Ess	Fly Spur Ranch	64460 Research Rd, Tumalo, OR 97703, USA	44.1410890	-121.3366310	19,548 m		horseback rides	establishment,point_of_interest,travel_agency	Page \| Maps \| Website	(541) 389-4995	View Hours Monday: Closed 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 – 7:00 PM Sunday: 8:00 AM – 5:00 PM	View Photos (4)
ChIJ1_-hR9oqv1QRKuTyO-w_f94	Food Fellas	332 SW 5th St, Redmond, OR 97756, USA	44.2737650	-121.1728670	152 m		brewery, food trucks, lunch, restaurants	establishment,food,point_of_interest,restaurant	Page \| Maps		View Hours Monday: 11:30 AM – 9:00 PM Tuesday: Closed Wednesday: Closed Thursday: 11:30 AM – 9:00 PM Friday: 11:30 AM – 9:00 PM Saturday: 11:30 AM – 9:00 PM Sunday: 11:30 AM – 9:00 PM	View Photos (4)
ChIJRT-PiyUrv1QR6okIejN80Lk	Forever Sunshine	215 SW 6th St, Redmond, OR 97756, USA	44.2752350	-121.1744750	294 m		boutiques, shopping	clothing_store,establishment,point_of_interest,store	Page \| Maps \| Website	(541) 233-9450	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: 11:00 AM – 5:00 PM	View Photos (2)
ChIJnzjFzwt1uFQR86h1XRnR7Ow	Fort Rock State Natural Area	Co Road 5-11A, Fort Rock, OR 97735, USA	43.3729120	-121.0661830	100,416 m	outdoors	point-of-interest	establishment,park,point_of_interest,tourist_attraction	Page \| Maps \| Website	(800) 551-6949		View Photos (4)
ChIJh05fk9nUuFQRtAlE_5RSXdY	Franz Bakery Outlet Store	334 SE Timber Ave, Redmond, OR 97756, USA	44.2530980	-121.1655410	2,271 m		bakeries, grocery stores	bakery,establishment,food,point_of_interest,store	Page \| Maps \| Website	(541) 548-5541	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 – 4:00 PM Sunday: Closed	View Photos (3)
ChIJn7Yvw9cqv1QRXO_Q4mkIpSc	Fred Meyer	944 SW Veterans Way, Redmond, OR 97756, USA	44.2674110	-121.1770610	631 m		coffee shops, desserts, grocery stores, juice bars, pool tables, shopping	bakery,establishment,florist,food,grocery_or_supermarket,health,liquor_store,point_of_interest,store	Page \| Maps \| Website	(541) 504-5100	View Hours Monday: 7:00 AM – 10:00 PM Tuesday: 7:00 AM – 10:00 PM Wednesday: 7:00 AM – 10:00 PM Thursday: 7:00 AM – 10:00 PM Friday: 7:00 AM – 10:00 PM Saturday: 7:00 AM – 10:00 PM Sunday: 7:00 AM – 10:00 PM	View Photos (4)
ChIJPUYKk0Irv1QRtWELCVJwXJk	Front Porch Bakery	1818 NW Ivy Ave, Redmond, OR 97756, USA	44.2852110	-121.1881860	1,803 m		bakeries	bakery,establishment,food,point_of_interest,store	Page \| Maps			No photos available
ChIJwbPQJa4rv1QR0SUT3XW5BvA	Frozen- homemade rolled ice cream	NE 8th and, SW Glacier Ave, Redmond, OR 97756, USA	44.2710170	-121.1768200	292 m		bakeries, desserts	establishment,food,point_of_interest,store	Page \| Maps	(541) 604-2444	View Hours Monday: Closed Tuesday: Closed Wednesday: Closed Thursday: 5:00 – 9:00 PM Friday: 5:00 – 9:00 PM Saturday: 5:00 – 9:00 PM Sunday: 5:00 – 7:00 PM	View Photos (4)
ChIJYV1_RM7TuFQRYz15OAxCnFU	Fruition Farm Sporthorses	5707 SW Quarry Ave, Redmond, OR 97756, USA	44.2128500	-121.2364400	8,305 m		farms, horseback rides	establishment,point_of_interest	Page \| Maps \| Website	(541) 815-0211	View Hours Monday: 8:00 AM – 5:00 PM Tuesday: 8:00 AM – 5:00 PM Wednesday: Closed Thursday: 8:00 AM – 5:00 PM Friday: 8:00 AM – 5:00 PM Saturday: 8:00 AM – 5:00 PM Sunday: 8:00 AM – 5:00 PM	View Photos (4)
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)
ChIJm6mHQ3rVvlQRSDW81P6M7OM	Full Circle Farms	2425 NE Upas Ave, Redmond, OR 97756, USA	44.3060590	-121.1397630	4,606 m		farms	establishment,home_goods_store,point_of_interest,store	Page \| Maps \| Website	(541) 548-6340		View Photos (3)