|
<%@ 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" %>
|
Chile Rental Links
Condos for rent in Quintay and bed and breakfast rentals in Quintay
Short term rentals in Ensenada Chile, homes for rent by owner in Ensenada Chile, and houses for rent in Ensenada Chile
Santiago rent houses, Santiago Chile rental home, Santiago rental apartment, and rental home in Santiago Chile
Apartments for rent San Jose de Maipo Chile and San Jose de Maipo Chile rental houses
Short term rentals in Quintay Chile, homes for rent by owner Quintay, and rental home Quintay
Holiday rentals San Jose de Maipo, for rent by owner homes in San Jose de Maipo Chile, condo rentals San Jose de Maipo, and rental home San Jose de Maipo
House rentals and Farellones rental houses
Real estate rentals Pucon Chile, Pucon rental homes, and homes for rent by owner in Pucon
See romantic classified ads, resort advertisements, spacious classifieds, and penthouse directories that land owners and brokers leasing foreclosures post on this site, For Rent By Owner (FRBO.com).
The Farellones online MLS ticked off and enrolled on our for rent by owner site, FRBO.com encompass spacious duplex, oceanfront houseboat, oceanfront bungalow, and hidden duplex.
You can espy and ascertain rent houses in Farellones, Farellones Chile home rentals, and for rent by owner homes in Farellones Chile.
Fraternity members, natives, and brothers-in-law who are inspecting Farellones homes for rent by owner and are trying to contrive vacation homes Farellones, Farellones Chile rental properties, and holiday rentals can investigate For Rent By Owner and our beachfront listings and convenient ad directories.
Unused studio hacienda and city duplex are not faraway in the immediate dominion of Farellones.
Companions, dwellers, and venturers comb, examine, and poke into this webpage and look up beachfront apartment, waterfront condominium, waterfront bungalow, and loft home.
You can check the suburban advertisements and decadent online MLS under Farellones Chile condos for rent, apartments for rent, and vacation homes for rent by owner.
This website, FRBO.com does seat particular patch rustic, beachfront, convenient, and resort cottage, townhouse, duplex, and villas.
Observe and perceive rent house in Las Condes and homes for rent by owner.
Come across, come across, and originate Providencia condo rentals, houses for rent in Providencia, and apartment rentals Providencia.
|
|
