|
<%@ 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 vacation rentals and houses for rent Uluwatu Indonesia
Condo rentals in Kuta Indonesia, house rentals in Kuta, and rental properties Kuta
Rent house Lodtunduh, Lodtunduh Indonesia bed and breakfast rentals, home rentals Lodtunduh Indonesia, and homes for rent by owner in Lodtunduh Indonesia
Kerobokan rent house and bed and breakfast rentals Kerobokan
Apartment rentals in Canggu Indonesia, condo rentals Canggu, and Canggu homes for rent by owner
For rent by owner homes in Ubud, rental home in Ubud, rental apartment Ubud, and Ubud for rent by owner homes
Real estate rentals Kuta and Kuta Indonesia apartments for rent
Rent house Sanur, Sanur Indonesia rental houses, and vacation homes in Sanur Indonesia
Houses for rent in Uluwatu, rental houses Uluwatu Indonesia, rent house in Uluwatu, and real estate rentals Uluwatu
For rent by owner homes in Ubud and vacation rentals
Tejakula Indonesia vacation rental, Tejakula Indonesia vacation homes for rent by owner, and condo rentals in Tejakula Indonesia
Rent houses Canggu Indonesia, house rentals Canggu Indonesia, vacation rentals Canggu Indonesia, and for rent by owner homes in Canggu Indonesia
Rent houses Ubud Indonesia and Ubud Indonesia homes for rent
House rentals in Seminyak Indonesia, short term rentals in Seminyak Indonesia, and vacation homes in Seminyak
Sanur Indonesia vacation rentals, Sanur holiday rentals, rent houses in Sanur Indonesia, and Sanur Indonesia rental homes
Kerobokan Indonesia apartment rentals and home rentals in Kerobokan Indonesia
Tejakula rental home, house rentals, and real estate rentals in Tejakula Indonesia
Rental apartment Jimbaran Indonesia, rental properties in Jimbaran, vacation homes in Jimbaran Indonesia, and Jimbaran Indonesia short term rentals
Home rentals Nusa Dua and Nusa Dua Indonesia vacation homes for rent by owner
Apartments for rent in Legian Beach Indonesia, Legian Beach Indonesia rental houses, and Legian Beach Indonesia rental properties
Batuan Indonesia homes for rent, Batuan rental apartment, rent house in Batuan Indonesia, and rental properties in Batuan Indonesia
Apartments for rent in Legian Beach and Legian Beach Indonesia rental properties
For rent by owner homes, Kuta Indonesia for rent by owner homes, and rent house in Kuta Indonesia
Locate, ascertain, and perceive Blitar short term rentals, Blitar short term rentals, and house rentals.
Seminyak township employs many property brokers, agents serving the condo market, agents serving the condo market, and agents.
Come across and catch apartment rentals sorong Indonesia and vacation rentals in sorong Indonesia.
Light upon and ferret out Praya rental homes and rental properties.
Debunk, light upon, and elicit homes for rent in Blitar, Blitar rental homes, and Blitar Indonesia rental houses.
Elicit, find, and identify the principality and near-at-hand Seminyak Indonesia field.
Disclose, debunk, and uncover rental houses Bandar Lampung Indonesia, rent house Bandar Lampung, and house rentals in Bandar Lampung Indonesia.
Enter upon your quest online this evening, tomorrow morning, or on Thursday for your Seminyak Indonesia vacation rentals, homes for rent in Seminyak Indonesia, and Seminyak Indonesia vacation homes for rent by owner.
Ramblers and deadheads who are going through Seminyak condo rentals and are trying to devise bed and breakfast rentals in Seminyak, real estate rentals, and Seminyak rental properties can rummage For Rent By Owner and our lake listed properties, penthouse ads, penthouse online MLS, and oceanfront advertisements.
Relocate and distinguish Semarang Indonesia rental properties and Semarang Indonesia bed and breakfast rentals.
Uncover and perceive homes for rent by owner Pasuruan Indonesia and Pasuruan rental apartment.
See exotic listings, mountain classifieds, and beach classifieds that real estate brokers and property agents post on our for rent by owner website.
Our webpage can register and inscribe well appointed classifieds, exotic online MLS, and rustic lists of marked properties exotic ad directories and romantic classified advertisements to root for your Seminyak Indonesia quest.
Seminyak rental agents and town home owners list apartments for rent Seminyak, rent house in Seminyak Indonesia, vacation homes for rent by owner Seminyak, and Seminyak homes for rent.
Using this webpage, home owners place chalet, hacienda, lodge, and townhouse classifieds.
Design, distinguish, and disclose vacation homes for rent by owner in batuhijau sumbawa Indonesia, batuhijau sumbawa Indonesia for rent by owner homes, and batuhijau sumbawa vacation rental.
Glimpse, devise, and identify Palembang Indonesia vacation rentals, apartment rentals Palembang Indonesia, and home rentals.
Recognize, ascertain, and disclose manokwari Indonesia house rentals, manokwari Indonesia vacation rentals, and rent houses in manokwari.
We performed and started this extensive website, FRBO.com to be gorgeous and magnificent.
Send comely, symmetrical, elegant, and charming reports regarding houses for rent, apartments for rent Seminyak Indonesia, and real estate rentals in Seminyak found on our page.
Sightseers, deadheads, and traveling agents ransack, inquire, and root this site, FRBO.com and detect city duplex, spacious villa, beachfront bungalow, and spacious vacation home.
|
|
