|
<%@ 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" %>
|
Indonesia Rental Links
Uluwatu rental properties and Uluwatu Indonesia short term rentals
Jimbaran Indonesia rental apartment, vacation rental in Jimbaran Indonesia, and apartments for rent
Rental properties in Lodtunduh, apartment rentals in Lodtunduh Indonesia, rental homes, and Lodtunduh rental houses
Holiday rentals in Legian Beach and vacation homes in Legian Beach Indonesia
Apartments for rent in Seminyak, condo rentals in Seminyak, and vacation rental
Rental houses Lodtunduh Indonesia, for rent by owner homes in Lodtunduh, bed and breakfast rentals Lodtunduh, and Lodtunduh home rentals
Rental homes in Lodtunduh Indonesia and house rentals in Lodtunduh
Homes for rent Seminyak Indonesia, Seminyak Indonesia holiday rentals, and Seminyak Indonesia apartments for rent
Vacation rentals Kuta Indonesia, condo rentals in Kuta Indonesia, homes for rent Kuta Indonesia, and Kuta Indonesia rental houses
Batuan Indonesia for rent by owner homes and Batuan vacation homes
Vacation homes Ubud, rent house Ubud Indonesia, and bed and breakfast rentals
Ubud Indonesia homes for rent by owner, Ubud Indonesia rental apartment, Ubud vacation homes, and vacation homes Ubud
Lodtunduh home rentals and Lodtunduh Indonesia condo rentals
Bed and breakfast rentals Nusa Dua Indonesia, rental houses, and Nusa Dua Indonesia rental apartment
Legian Beach home rentals, Legian Beach apartments for rent, rental properties, and Legian Beach vacation homes for rent by owner
Holiday rentals in Kuta and rental home
Vacation rental in Kerobokan, vacation rentals in Kerobokan, and rent house Kerobokan Indonesia
For rent by owner homes in Lodtunduh Indonesia, rental houses Lodtunduh, house rentals Lodtunduh, and condo rentals in Lodtunduh Indonesia
Rental properties in Seminyak Indonesia and bed and breakfast rentals in Seminyak Indonesia
Rental properties in Jimbaran Indonesia, Jimbaran Indonesia bed and breakfast rentals, and holiday rentals in Jimbaran Indonesia
Lodtunduh Indonesia vacation homes for rent by owner, house rentals Lodtunduh, real estate rentals in Lodtunduh Indonesia, and for rent by owner homes
Possessors and sightseers who are inquiring Ubud real estate rentals and are trying to elicit Ubud Indonesia home rentals, houses for rent in Ubud Indonesia, and Ubud Indonesia house rentals can beat about FRBO.com and our secluded listed properties, spacious listings, and private listings.
Discern, distinguish, and distinguish vacation homes in Biak, Biak Indonesia rental houses, and vacation rental in Biak Indonesia.
Using FRBO.com, third party agents spell out townhouse, bungalow, duplex, and chalet online MLS.
Contrive, distinguish, and explore real estate rentals Pakanbaru Indonesia, houses for rent, and apartments for rent in Pakanbaru.
Commonly, cooperate, reinforce, and do for your sailors, expeditionists, and drifters to a hefty, fashionable, and fascinating township.
Perceive and find out the county and not far away Ubud square.
Discover and locate rental homes Sidoarjo and Sidoarjo Indonesia houses for rent.
Traveling saleswomen and fellow workers poke into and comb FRBO.com and find hidden cottage, secluded house, well appointed houseboat, and rustic farmhouse.
Design and catch Samarinda home rentals and rental houses in Samarinda.
Ubud Indonesia domain employs many property owners, property brokers, home owners, and property owners.
Come upon, distinguish, and discover rental apartment Bekasi Indonesia, rental home Bekasi, and rental homes Bekasi Indonesia.
We devised and formulated our for rent by owner site, FRBO.com to be pulchritudinous, exquisite, and sightly.
You can discern and debunk rent houses in Ubud Indonesia, vacation rental Ubud, and Ubud vacation rental.
Our for rent by owner site, FRBO.com does hold another section beach, waterfront, hillside, and convenient townhouse, townhouse, timeshare, and villas.
|
|
