Data

Debug Info (admin only)

Search Criteria:

Keyword: None
Categories: None
Search Terms: None
Types: None
Show Unpublished: No
Sort: distance
Order: ASC

Pagination:

Current Page: 1
Limit per Page: 25
Offset: 0
Total Pages: 26

Results:

Total Available Records: 642
Total After Limits: 642
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 ISNULL(p.distance) ASC, p.distance ASC LIMIT 0, 25

Page 1 of 26

Showing 1 to 25 of 642 results

Place ID	Name	Address	Latitude	Longitude	Distance ↑	Category	Search Term	Types	Links	Phone	Hours	Photos
ChIJI8dU-Nkqv1QRzkhUMKKZY6Q	Public Information Verification, LLC	Redmond, OR 97756, USA	44.2726580	-121.1739210	4 m		point of interest	establishment,point_of_interest	Page \| Maps	(877) 605-7710		No photos available
ChIJYTsBKn8rv1QRuyCqCBMOX9U	Coffee Depo	Redmond, OR 97756, USA	44.2726660	-121.1739210	5 m		coffee shops, coffee shops,shopping	cafe,establishment,food,point_of_interest,store	Page \| Maps			No photos available
ChIJOYjHWdAqv1QRZbzXuJ6MdlU	Smith Rock Coffee Roasters	Redmond, OR 97756, USA	44.2726660	-121.1739210	5 m		coffee shops	establishment,food,point_of_interest	Page \| Maps \| Website	(541) 699-1964		View Photos (4)
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	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)
ChIJiQuH7j4rv1QRXYH_WzQE1UQ	Cuppa Yo Frozen Yogurt Redmond, OR	446 SW 6th St, Redmond, OR 97756, USA	44.2728200	-121.1739340	22 m		desserts, juice bars	establishment,food,point_of_interest,store	Page \| Maps \| Website	(458) 899-5955	View Hours Monday: 12:00 – 9:00 PM Tuesday: 12:00 – 9:00 PM Wednesday: 12:00 – 9:00 PM Thursday: 12:00 – 9:00 PM Friday: 12:00 – 9:00 PM Saturday: 12:00 – 9:00 PM Sunday: 12:00 – 9:00 PM	View Photos (4)
ChIJ5500E-wqv1QRdmzDvEbPKNg	Trend Kill Body Piercing	508 SW 6th St, Redmond, OR 97756, USA	44.2724010	-121.1739790	25 m		shopping	establishment,jewelry_store,point_of_interest,store	Page \| Maps \| Website	(541) 504-0406	View Hours Monday: 11:00 AM – 7:00 PM Tuesday: 11:00 AM – 7:00 PM Wednesday: 11:00 AM – 7:00 PM Thursday: 11:00 AM – 7:00 PM Friday: 11:00 AM – 7:00 PM Saturday: 11:00 AM – 7:00 PM Sunday: 11:00 AM – 7:00 PM	View Photos (4)
ChIJRQ6Mdbcrv1QRUKRgWcG3HAo	Cognitive Surplus Stationery & Gift Store	436 SW 6th St, Redmond, OR 97756, USA	44.2729650	-121.1739760	39 m		gift shops,shopping, shopping	establishment,home_goods_store,point_of_interest,store	Page \| Maps \| Website	(541) 527-2248	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 – 5:00 PM	View Photos (4)
ChIJo_N7si4rv1QRRIwX-feuOJY	Morning story	457 SW 6th St, Redmond, OR 97756, USA	44.2726900	-121.1744030	39 m		bakeries, bars,coffee shops,bakeries,desserts,grocery stores,breakfast,shopping, breakfast, coffee shops, desserts, lunch	cafe,establishment,food,point_of_interest,restaurant,store	Page \| Maps	(541) 604-4551	View Hours Monday: 9:00 AM – 4:00 PM 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 – 4:00 PM Sunday: Closed	View Photos (4)
ChIJWVC5uZErv1QRNibUxGNe-Nk	Terra Kitchen	509 SW 6th St, Redmond, OR 97756, USA	44.2723800	-121.1744230	48 m		cocktails, cocktails,restaurants,lunch,dining, desserts, dining, restaurants	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 348-8101	View Hours Monday: Closed Tuesday: 4:00 – 8:00 PM Wednesday: 11:30 AM – 2:00 PM, 4:00 – 8:00 PM Thursday: 11:30 AM – 2:00 PM, 4:00 – 8:00 PM Friday: 11:30 AM – 2:00 PM, 4:00 – 8:30 PM Saturday: 11:30 AM – 2:00 PM, 4:00 – 8:30 PM Sunday: Closed	View Photos (4)
ChIJeWBq8dkqv1QRdcA_f-niRhw	Diego’s Spirited Kitchen	447 SW 6th St, Redmond, OR 97756, USA	44.2728220	-121.1744640	49 m		bars, bars,cocktails,nightlife,bars,cocktails,pubs,restaurants,lunch,dining,family friendly, brewery, cocktails, dining, lunch, nightlife, pubs, restaurants	bar,establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 316-2002	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: Closed	View Photos (4)
ChIJo8UA8Nkqv1QRy-3yeNGt2dE	Salon Bliss	621 SW Evergreen Ave, Redmond, OR 97756, USA	44.2726920	-121.1745380	50 m		massage	establishment,hair_care,point_of_interest	Page \| Maps \| Website	(541) 604-5593	View Hours Monday: 9:00 AM – 7:00 PM Tuesday: 9: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: 9:00 AM – 5:00 PM Sunday: Closed	View Photos (4)
ChIJD0UXA9Irv1QRUK7SsGtis_U	Arome	432 SW 6th St, Redmond, OR 97756, USA	44.2730890	-121.1740260	53 m		grocery stores	establishment,food,furniture_store,grocery_or_supermarket,home_goods_store,point_of_interest,store	Page \| Maps \| Website	(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	View Photos (4)
ChIJHxdYl8grv1QRHvAKRrvBA24	Inner Balance Therapeutic Massage	621 SW Evergreen Ave, Redmond, OR 97756, USA	44.2727000	-121.1745910	54 m		massage	establishment,point_of_interest	Page \| Maps \| Website	(971) 208-3363	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: Closed Sunday: Closed	View Photos (3)
ChIJRw2vlg0rv1QRloYN5KHRyLc	Rincón Ázteca A Family Mexican Cuisine	526 SW 6th St, Redmond, OR 97756, USA	44.2721350	-121.1739750	54 m		cocktails, cocktails,restaurants,lunch,dining,family friendly, lunch, restaurants	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 548-4084	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)
ChIJPdBp-tkqv1QR2NREwgiIowk	Oishi	511 SW 6th St, Redmond, OR 97756, USA	44.2724710	-121.1745770	55 m		restaurants,lunch,dining,family friendly	establishment,food,point_of_interest,restaurant	Page \| Maps \| Website	(541) 548-3035	View Hours Monday: Closed Tuesday: 11:30 AM – 3:00 PM, 4:00 – 8:30 PM Wednesday: 11:30 AM – 3:00 PM, 4:00 – 8:30 PM Thursday: 11:30 AM – 3:00 PM, 4:00 – 8:30 PM Friday: 11:30 AM – 3:00 PM, 4:00 – 8:30 PM Saturday: 11:30 AM – 3:00 PM, 4:00 – 8:30 PM Sunday: Closed	View Photos (4)
ChIJeRO2t9cqv1QRbg6I-B-a7bI	Ida’s Cupcake Cafe, Redmond	445 SW 6th St, Redmond, OR 97756, USA	44.2729040	-121.1745710	61 m		bakeries, bakeries,desserts, coffee shops, desserts	bakery,establishment,food,point_of_interest,store	Page \| Maps \| Website	(541) 923-6077	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 – 6:00 PM Saturday: 10:00 AM – 6:00 PM Sunday: Closed	View Photos (4)
ChIJIcsYuMsrv1QR4N1YCgkb4Aw	Mickey’s Adventures	422 SW 6th St, Redmond, OR 97756, USA	44.2731790	-121.1739860	62 m		bookstores	book_store,establishment,point_of_interest,store	Page \| Maps	(206) 228-3155	View Hours Monday: 9:30 AM – 5:00 PM 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: Closed Sunday: Closed	No photos available
ChIJbeu6H9oqv1QRIi46_pG0Z0o	Herringbone Books	422 SW 6th St, Redmond, OR 97756, USA	44.2731790	-121.1739860	62 m		bookstores, shopping	book_store,establishment,point_of_interest,store	Page \| Maps \| Website	(541) 526-1491	View Hours Monday: 9:30 AM – 6:00 PM Tuesday: 9:30 AM – 6:00 PM Wednesday: 9:30 AM – 6:00 PM Thursday: 9:30 AM – 6:00 PM Friday: 9:30 AM – 6:00 PM Saturday: 9:30 AM – 6:00 PM Sunday: Closed	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, coffee shops,restaurants,breakfast,lunch,dining,family friendly,gift shops,shopping	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)
ChIJvZA_fkMrv1QRZXuft3Gmi40	SCP Redmond Hotel (edited)	521 SW 6th St Ste 100, Redmond, OR 97756, USA (edited)	44.2722780	-121.1745490	63 m	hotels-motels (edited)	hotels (edited)	lodging,point_of_interest,establishment (edited)	Page \| Maps \| Website (edited)	(866) 627-8345	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)
ChIJIY4A5uUrv1QRrwJL41M8GwA	Little Bug Play Hub	528 SW 6th St, Redmond, OR 97756, USA	44.2720500	-121.1739590	64 m		family fun,parks, playgrounds	establishment,point_of_interest	Page \| Maps \| Website	(541) 238-6701	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 – 5:00 PM Sunday: 10:00 AM – 3:00 PM	View Photos (4)
ChIJE1ngFPYrv1QRMcpC-gwtLZk	Monarch Coffee Co	528 SW 6th St, Redmond, OR 97756, USA	44.2720500	-121.1739590	64 m		coffee shops,shopping	cafe,establishment,food,point_of_interest,store	Page \| Maps	(541) 238-6703	View Hours Monday: 8:00 AM – 4:00 PM Tuesday: 8:00 AM – 4:00 PM Wednesday: 8:00 AM – 4:00 PM Thursday: 8:00 AM – 4:00 PM Friday: 8:00 AM – 4:00 PM Saturday: 8:00 AM – 2:00 PM Sunday: Closed	View Photos (4)
ChIJSw_tV9cqv1QRLNc53CS77VA	Double J Saloon	528 SW 6th St, Redmond, OR 97756, USA	44.2720500	-121.1739590	64 m		bars, pool tables, pubs	bar,point_of_interest,establishment	Page \| Maps	(541) 923-1868		View Photos (4)
ChIJYaI95M4rv1QRyBBptKy5p9A	Two Gifty Girls	433 SW 6th St, Redmond, OR 97756, USA	44.2730350	-121.1745290	67 m		boutiques, boutiques,gift shops,shopping, 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: Closed 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)
ChIJW8noIy4rv1QRTNvI2z_O02E	Desert Lily Bodywork	418 SW 6th St, Redmond, OR 97756, USA	44.2732420	-121.1739680	69 m		massage	establishment,point_of_interest	Page \| Maps \| Website	(833) 481-3895	View Hours Monday: Closed Tuesday: Closed Wednesday: Closed Thursday: 12:00 – 4:30 PM Friday: 12:00 – 5:00 PM Saturday: 10:30 AM – 3:00 PM Sunday: Closed	View Photos (2)