|
<%@ 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" %>
|
Hong Kong Rental Links
Short term rentals Hong Kong Island Hong Kong and short term rentals
Rental properties Discovery Bay, vacation rental in Discovery Bay Hong Kong, and condos for rent
Discovery Bay apartment rentals, real estate rentals Discovery Bay Hong Kong, rental houses Discovery Bay Hong Kong, and condos for rent in Discovery Bay
Using this site, FRBO.com, real estate agents catalogue duplex, cottage, ranch, and townhouse classifieds.
Kowloon real estate brokers, agents serving the condo market, home owners, and condo owners list Kowloon rent house, vacation rental, Kowloon Hong Kong homes for rent by owner, and Kowloon house rentals.
Volunteer, obtain, admit, and join up tomorrow evening to inaugurate, tear into, and get going on this trip.
Periodically, back and push your itinerants, transmigrants, and adventurers to a packed and big man principality.
Join our beachfront online MLS, hidden ads, spacious online MLS, and hillside classified ads mailing list for home rentals in Kowloon Hong Kong and vacation homes for rent by owner in Kowloon Hong Kong.
See exclusive listed properties and exotic online MLS that home owners and third party agents post on FRBO.Com, For Rent By Owner,.
Traveling sales representatives and cohorts who are shaking down rental apartment and are trying to come across rental houses, Kowloon Hong Kong vacation rentals, and holiday rentals in Kowloon Hong Kong can scout this site, For Rent By Owner (FRBO.com) and our beach directories, beachfront directories, resort ads, and penthouse classifieds.
|
|
