select * from ulke_ph ( select ulke,sehir,ilce,ad,y_ad,id,3 as sira,concat(url,"-","en",".html") as link1 from ulke_ph where sehir="ilocos region" and ilce="ilocos norte" order by rand() order by info_var desc ) q order by rand() limit 0,19
Laoag International Airport 1 Hr 58
Patapat Viaduct (15 Min)
Elevated Concrete Bridge Featuring Picturesque Mountain & Sea Views.
Dos Hermanos Island (4 Min)
Casa Consuelo (4 Min)
Blue Lagoon (13 Min)
Tropical, Waterfront Area With A Sandy Beach, Offering Swimming, Surfing, Sunbathing & Picnic Space.
Saud Beach Resort And Hotel (31 Min)
Peaceful Locale With A White Sand Beach, Clear Blue Seas & A Resort With Air-Conditioned Rooms.
Agua Grande (16 Min)
Maira-Ira Resort And Residences (15 Min)
Saud Beach (33 Min)
Uncrowded Tropical Beach With Gentle Waves In Shallow Water & Overlooked By A Few Resort Hotels.
Kabigan Falls (12 Min)
A Rustic Trail Through Tropical Forest Leads Visitors To This Dramatic Natural Waterfall.
Twin Island Beach House (4 Min)
Timmangtang Rock (9 Min)
Blue Lagoon (32 Min)
Bangui Windmills (49 Min)
Oceanfront Wind Farm & Tourist Attraction Featuring 20 Turbines Facing The Sea.
Bantay Abot Cave (7 Min)
Paraiso Ni Anton (17 Min)
Pit Stop Offering A Tiny Shrine & Cascading Spring With Waters Believed To Have Healing Powers.
Paliparang Pandaigdig Ng Laoag 1 Oras 58
Twin Island Beach House (4 Min)
Casa Consuelo (4 Min)
Saud Beach (33 Min)
Agua Grande (16 Min)
Blue Lagoon (13 Min)
Tropical, Tabing-Dagat Na May Mabuhanging Beach, Na Puwedeng Lumangoy, Mag-Surf, Mag-Sunbath At Mag-Picnic.
Timmangtang Rock (9 Min)
Paraiso Ni Anton (17 Min)
Pahingahan Na Nag-Aalok Ng Maliit Na Altar At Dumadaloy Na Tubig Na Pinaniniwalaang Nakakapagpagaling.
Blue Lagoon (32 Min)
Patapat Viaduct (15 Min)
Dos Hermanos Island (4 Min)
Saud Beach Resort And Hotel (31 Min)
Bangui Windmills (49 Min)
Bantay Abot Cave (7 Min)
Maira-Ira Resort And Residences (15 Min)
Kabigan Falls (12 Min)
Rustic Na Trail Sa Tropikal Na Gubat Na Dinaraanan Ng Mga Bisita Papunta Sa Magandang Natural Na Talon.