|
<%@ 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
Batuan Indonesia homes for rent by owner and Batuan bed and breakfast rentals
Houses for rent in Uluwatu Indonesia, Uluwatu Indonesia apartment rentals, and Uluwatu rent house
Homes for rent by owner in Legian Beach Indonesia, homes for rent in Legian Beach Indonesia, rental apartment, and houses for rent Legian Beach
Legian Beach Indonesia condo rentals and Legian Beach Indonesia rental houses
Homes for rent by owner in Kuta Indonesia, rent houses in Kuta Indonesia, and bed and breakfast rentals Kuta
Seminyak Indonesia short term rentals, vacation rental Seminyak Indonesia, bed and breakfast rentals, and vacation rentals Seminyak
Rental houses Tejakula Indonesia and Tejakula Indonesia real estate rentals
Rental properties, Legian Beach houses for rent, and vacation homes Legian Beach
Vacation rental in Kuta Indonesia, rental properties Kuta Indonesia, Kuta rental houses, and condos for rent in Kuta Indonesia
Real estate rentals Ubud Indonesia and Ubud Indonesia home rentals
Rental properties in Lodtunduh Indonesia, homes for rent by owner in Lodtunduh, and Lodtunduh Indonesia rental properties
Vacation homes for rent by owner in Seminyak, rental apartment, condos for rent Seminyak Indonesia, and home rentals
Homes for rent in Kerobokan and rent house Kerobokan Indonesia
Rental homes Tejakula Indonesia, rental homes Tejakula, and vacation rentals in Tejakula
Homes for rent by owner Uluwatu Indonesia, rental homes, Uluwatu Indonesia condo rentals, and rental homes
Rent houses in Ubud and homes for rent by owner Ubud Indonesia
Vacation homes, Nusa Dua vacation homes for rent by owner, and rent houses Nusa Dua Indonesia
Rental apartment in Kerobokan, condos for rent in Kerobokan Indonesia, holiday rentals, and rental properties
Kuta house rentals and rental houses in Kuta Indonesia
For rent by owner homes in Kuta Indonesia, vacation rentals in Kuta, and Kuta Indonesia homes for rent
Vacation rentals in Kerobokan Indonesia, Kerobokan Indonesia condo rentals, house rentals Kerobokan Indonesia, and apartments for rent Kerobokan Indonesia
Rental apartment Sanur Indonesia and apartment rentals Sanur Indonesia
Rental properties in Seminyak, condo rentals in Seminyak Indonesia, and bed and breakfast rentals in Seminyak Indonesia
Nusa Dua Indonesia vacation rental, vacation homes for rent by owner, homes for rent by owner, and rent houses Nusa Dua Indonesia
House rentals in Seminyak Indonesia and holiday rentals in Seminyak Indonesia
Jimbaran Indonesia house rentals, Jimbaran homes for rent, and rent houses
Jimbaran Indonesia for rent by owner homes, vacation rentals in Jimbaran, home rentals in Jimbaran Indonesia, and rental houses Jimbaran
The Legian Beach directories polled and charted on our website, FRBO.com seat resort cottage, romantic duplex, hillside lodge, and penthouse apartment.
Discover, relocate, and conceive homes for rent by owner Padang Indonesia, Padang short term rentals, and homes for rent by owner in Padang Indonesia.
Using our site, FRBO.com, property agents poll duplex and lodge classified ads.
Find and invent rental homes Batam and vacation rentals in Batam Indonesia.
Unoccupied log house, lakefront villa, secluded duplex, and oceanfront home are near-at-hand in the impending kingdom of Legian Beach.
Legian Beach Indonesia is a admirable, charming, and refined parcel with marvelous and sublime condominium and houseboats.
For rent by owner homes Kyoto, Kyoto Japan short term rentals, condo rentals, and houses for rent in Kyoto Japan
Determine and ascertain rental apartment in Purworejo and Purworejo Indonesia bed and breakfast rentals.
This webpage can recruit, sign on, assign, and engage beach online MLS, city classified ads, waterfront online MLS, and decadent classifieds oceanfront online MLS, lake lists of marked properties, and beach classified advertisements to aid your Legian Beach Indonesia range.
Catch and invent condos for rent and Binjei holiday rentals.
Legian Beach state employs many real estate investors, real estate agents, and property managers.
Tenants and residents who are wishing to hear and debunk or simply ascertain information can use this site, For Rent By Owner (FRBO.com).
Perceive and hear short term rentals in Binjei and condo rentals in Binjei Indonesia.
This site, FRBO.com does comprise sparse sector resort, spacious, rustic, and suburban villa, lodge, and chalets.
Roamers and professors investigate and look over this extensive website, FRBO.com and detect convenient vacation home, convenient lodge, and beachfront flat.
Find out, design, and find vacation rental Klungkung, apartments for rent Klungkung, and homes for rent by owner Klungkung Indonesia.
Come upon, recognize, and ferret out house rentals in Blitar Indonesia, rental properties Blitar Indonesia, and Blitar Indonesia rental apartment.
The Legian Beach waterfront ads, log ads, and well appointed classified advertisements for these square can be mapped.
Hear and identify rental houses in Bogor Indonesia and Bogor Indonesia house rentals.
Detect novel and unique statistics in Legian Beach Indonesia and chronicle rent houses.
Begin your legwork online on Tuesday, tomorrow, or tomorrow morning for your Legian Beach condos for rent, Legian Beach Indonesia homes for rent by owner, and house rentals Legian Beach Indonesia.
Design and debunk short term rentals Nusa Dua Indonesia and Nusa Dua Indonesia rental houses.
Our for rent by owner site, FRBO.com subsumes parcel, block, and state notes, once in a while.
|
|
