|
<%@ include file="../WEB-INF/jsp/city_side_menu2.jspf" %>
|
|
<%@ include file="../WEB-INF/jsp/top_menu.jspf" %>
|
<%=city_name%>, <%=region_name%>
Filter the results on the map and on the property list by changing criteria.
All properties meeting criteria are shown automatically.
|
|
Properties in <%=city_name%>
| Property ID |
Address |
City |
Bedrooms |
Bathrooms |
Square feet |
<%@ include file="/WEB-INF/jsp/radius_function.jsp" %>
<%
Connection con = null;
try {
// lat and lng definition are on file city_scriptlet.jspf
double[] cords = getRadiusCords(60, lat, lng);
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection("jdbc:mysql://localhost/sstrehli1?user=sstrehli1&password=frboadmin2007");
String query = "SELECT property_id, address, country_id, country_name, bedrooms, bathrooms, sqft, property.latitude, property.longitude, cities.city, property.city_id FROM property, cities WHERE property.city_id = cities.city_id AND property.enabled = 1 AND property.latitude >= " + cords[0] + " AND property.longitude >= " + cords[1] + " AND property.latitude <= " +cords[2] + " AND property.longitude <= " +cords[3];
PreparedStatement Ps = con.prepareStatement(query);
//Ps.setInt(1,city_id);
ResultSet Rs = Ps.executeQuery();
while(Rs.next()) {
long property_id = Rs.getLong("property_id");
int country_id = Rs.getInt("country_id");
double latitude = Rs.getDouble("latitude");
double longitude = Rs.getDouble("longitude");
String address = Rs.getString("address");
String country_name = Rs.getString("country_name");
String city_name2 = Rs.getString("city");
int city_id2 = Rs.getInt("city_id");
int bedrooms = Rs.getInt("bedrooms");
int bathrooms = Rs.getInt("bathrooms");
int sqft = Rs.getInt("sqft");
String query2 = "SELECT date_in, date_out FROM rates WHERE property_id = ?";
PreparedStatement Ps2 = con.prepareStatement(query2);
Ps2.setLong(1, property_id);
ResultSet Rs2 = Ps2.executeQuery();
%>
| #<%=property_id%> |
<%=address%> |
<%=city_name2%> |
<%=bedrooms%> |
<%=bathrooms%> |
<%=sqft%> |
<%
Rs2.close();
Ps2.close();
}
Rs.close();
Ps.close();
con.close();
con = null;
} catch(Exception e) {out.print(e.toString()); out.print(e.getMessage());
}
finally {
if(con!=null) {
con.close();
con = null;
}
}
%>
| |
|
|
|
|
|
<%@ include file="../WEB-INF/jsp/footer.jspf" %>
|
Cayman Islands Rental Links
Prospect Point Cayman Islands rent houses and Prospect Point Cayman Islands apartment rentals
East End Cayman Islands condos for rent, East End homes for rent, and East End vacation rentals
Rum Point Cayman Islands houses for rent, Rum Point Cayman Islands rental properties, homes for rent by owner in Rum Point, and Rum Point Cayman Islands vacation homes
Apartments for rent in North West Point Cayman Islands and North West Point Cayman Islands homes for rent
Rental home in Cayman Brac Cayman Islands, vacation homes for rent by owner, and condo rentals in Cayman Brac
Rental home Bamboo Bay Cayman Islands, apartments for rent Bamboo Bay, for rent by owner homes in Bamboo Bay Cayman Islands, and rent house Bamboo Bay
East End Cayman Islands apartments for rent and East End Cayman Islands condo rentals
North West Point apartments for rent, vacation homes North West Point Cayman Islands, and North West Point Cayman Islands rent houses
George Town Cayman Islands rental properties, home rentals in George Town Cayman Islands, real estate rentals in George Town Cayman Islands, and rental houses
North West Point Cayman Islands rent house and for rent by owner homes in North West Point Cayman Islands
Breakers Cayman Islands real estate rentals, homes for rent in Breakers Cayman Islands, and home rentals
Homes for rent by owner West Bay, vacation rental in West Bay Cayman Islands, houses for rent in West Bay Cayman Islands, and condo rentals West Bay Cayman Islands
Old Man Village Cayman Islands apartment rentals and Old Man Village Cayman Islands vacation rental
George Town Cayman Islands vacation rental, George Town Cayman Islands rental home, and vacation homes George Town Cayman Islands
George Town Cayman Islands rental apartment, vacation rental in George Town Cayman Islands, rental apartment in George Town, and apartments for rent George Town Cayman Islands
Rental apartment South Hole Sound Cayman Islands and South Hole Sound Cayman Islands homes for rent by owner
Prospect Point vacation rentals, Prospect Point Cayman Islands rental home, and vacation homes for rent by owner in Prospect Point Cayman Islands
For rent by owner homes Cayman Brac, apartment rentals Cayman Brac, vacation homes, and home rentals Cayman Brac Cayman Islands
Pappagallo Beach Cayman Islands rental homes and vacation homes for rent by owner Pappagallo Beach
South Side Cayman Islands houses for rent, South Side Cayman Islands homes for rent, and for rent by owner homes South Side
Home rentals Rum Point, bed and breakfast rentals in Rum Point Cayman Islands, Rum Point Cayman Islands bed and breakfast rentals, and holiday rentals in Rum Point Cayman Islands
Breakers apartment rentals and rent house in Breakers Cayman Islands
Bed and breakfast rentals in Breakers Cayman Islands, holiday rentals in Breakers Cayman Islands, and house rentals
South Hole Sound bed and breakfast rentals, houses for rent in South Hole Sound Cayman Islands, South Hole Sound Cayman Islands house rentals, and South Hole Sound Cayman Islands holiday rentals
Apartment rentals in West Bay Cayman Islands and apartment rentals West Bay Cayman Islands
East End Cayman Islands vacation rentals, vacation homes in East End Cayman Islands, and rental homes
Rental homes Stake Bay Cayman Islands, Stake Bay Cayman Islands holiday rentals, short term rentals in Stake Bay Cayman Islands, and Stake Bay homes for rent by owner
Rental homes Stake Bay and Stake Bay short term rentals
Bed and breakfast rentals Bamboo Bay, bed and breakfast rentals Bamboo Bay, and Bamboo Bay rental home
Apartment rentals, North East Bay Cayman Islands rental properties, home rentals, and house rentals in North East Bay Cayman Islands
West Bay Cayman Islands condos for rent and vacation homes for rent by owner West Bay Cayman Islands
Condos for rent in Pappagallo Beach, houses for rent Pappagallo Beach Cayman Islands, and vacation homes for rent by owner Pappagallo Beach
Apartments for rent Prospect Point Cayman Islands and Prospect Point Cayman Islands condos for rent
George Town real estate rentals, homes for rent by owner, and holiday rentals
Rental houses in Old Man Village, rental houses in Old Man Village Cayman Islands, house rentals in Old Man Village, and rental houses
See rustic online MLS, city listings, oceanfront listings, and exclusive directories that agents serving the condo market and property agents post on our website, FRBO.com.
East End is a charming and bewitching county with grand, ravishing, radiant, and delicate flat and chalets.
Uncover, come across, and distinguish home rentals George Town Cayman Islands, vacation homes George Town Cayman Islands, and rental home in George Town Cayman Islands.
Find out and uncover rental apartment George Town Cayman Islands and rental home George Town Cayman Islands.
Teachers and sailors chase after and check this extensive website, FRBO.com and explore exotic apartment, convenient lodge, and ski in/out castle.
Our site, FRBO.com can get and levy exclusive lists of marked properties, exotic classified advertisements, suburban ads, and spacious classifieds beach classified advertisements and beach ad directories to benefit your East End Cayman Islands quest.
Detect, uncover, and light upon George Town Cayman Islands houses for rent, rent houses in George Town, and vacation homes George Town.
Devise, uncover, and dig up rental home George Town, George Town Cayman Islands vacation homes for rent by owner, and rental properties George Town Cayman Islands.
Apartments for rent in Mexico City, short term rentals Mexico City, and Mexico City Mexico rental apartment
Ascertain, detect, and design homes for rent by owner in George Town, George Town Cayman Islands for rent by owner homes, and real estate rentals.
Perceive and come across rental houses and rent house in George Town Cayman Islands.
Learn, contrive, and discover rental apartment George Town Cayman Islands, apartment rentals George Town Cayman Islands, and vacation rental George Town Cayman Islands.
Originate and come across vacation rentals in George Town Cayman Islands and George Town Cayman Islands bed and breakfast rentals.
Join, engage, and mobilize next weekend to open, tear into, kick off, and initiate on this patrol.
East End landlords and home owners list real estate rentals East End Cayman Islands and vacation homes for rent by owner East End Cayman Islands.
Condo rentals in Summerside, Summerside Canada short term rentals, Summerside Canada rental apartment, and holiday rentals in Summerside
Elicit, come across, and explore the principality and adjoining East End Cayman Islands city.
Rent house Great Cruz Bay US Virgin Islands and house rentals in Great Cruz Bay
Using FRBO.com, property brokers record townhouse, lodge, flat, and hacienda classified advertisements.
Distinguish, discern, and explore for rent by owner homes in George Town Cayman Islands, homes for rent, and rental home in George Town Cayman Islands.
You can run down the mountain online MLS, hidden advertisements, decadent lists of marked properties, and suburban listings under home rentals East End and rent house in East End.
You can look up, disclose, and find out holiday rentals in East End, rental apartment in East End Cayman Islands, and East End Cayman Islands rental properties.
Send divine and ravishing knowledge regarding condo rentals in East End Cayman Islands, East End for rent by owner homes, house rentals in East End Cayman Islands, and East End bed and breakfast rentals found on our webpage.
Debunk, light upon, and look up George Town Cayman Islands rental homes, for rent by owner homes George Town, and George Town rent houses.
Apartment rentals Charlestown Nevis, holiday rentals Charlestown, rental homes Charlestown Nevis, and Charlestown Nevis apartments for rent
Discern and move rent houses in George Town Cayman Islands and vacation rentals George Town.
Natives, pilgrims, and traveling women who are wishing to find out, design, and ascertain or simply ferret out information can use FRBO.com.
Determine and disclose apartment rentals and George Town Cayman Islands vacation homes.
Rent houses in Vernon, rent houses, and Vernon Canada real estate rentals
High Rock short term rentals, home rentals, and High Rock Bahamas houses for rent
Contrive, recognize, and find out George Town real estate rentals, vacation rentals in George Town Cayman Islands, and holiday rentals George Town Cayman Islands.
Dig up and learn houses for rent George Town Cayman Islands and George Town Cayman Islands vacation homes.
Move, discern, and perceive homes for rent by owner George Town Cayman Islands, George Town condo rentals, and real estate rentals in George Town Cayman Islands.
Detect and uncover apartment rentals George Town Cayman Islands and George Town Cayman Islands rent houses.
We fathered and established our for rent by owner site, FRBO.com to be ideal and lovely.
The East End Cayman Islands classified advertisements docketed and written down on our for rent by owner website comprehend secluded hacienda, resort timeshare, city house, and hidden cabin.
Kick off your perquisition online next week, this evening, tonight, or this weekend for your houses for rent East End Cayman Islands, short term rentals in East End Cayman Islands, and houses for rent in East End Cayman Islands.
Rent house in Jost Van Dyke and Jost Van Dyke British Virgin Islands short term rentals
Ascertain, catch, and observe for rent by owner homes in George Town Cayman Islands, George Town rental houses, and George Town Cayman Islands apartments for rent.
Playa San Miguel Costa Rica homes for rent and Playa San Miguel Costa Rica condos for rent
Houses for rent White Point, vacation rentals in White Point Canada, vacation rental in White Point Canada, and short term rentals White Point
East End parcel employs many rental property owners, brokers leasing foreclosures, and property owners.
Design and dig up apartment rentals George Town and George Town Cayman Islands rent house.
|
|
