|
<%@ 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" %>
|
Louisiana Rental Links
Vacation rentals and New Orleans Louisiana rental properties
New Orleans Louisiana is a good-looking, dazzling, and good-looking locality with pleasing and sightly condominium, townhouse, vacation home, and houseboats.
This extensive website, FRBO.com can levy and draft spacious classified advertisements, oceanfront indexes, and log classified ads spacious directories, lakeside classified advertisements, and hidden lists of marked properties to abet your New Orleans Louisiana jaunt.
Indwellers and possessors who are wishing to contrive, come upon, and devise or simply identify information can use this extensive website, FRBO.com.
You can recognize, observe, and devise vacation rental New Orleans, New Orleans Louisiana bed and breakfast rentals, and rental houses in New Orleans Louisiana.
Suburban classifieds and penthouse classified advertisements vacation rental, Lafayette Louisiana short term rentals, Lafayette rental properties, and real estate rentals in Lafayette Louisiana.
Our page incorporates area, area, and zone reports, generally.
Companions and pilgrims who are searching vacation homes for rent by owner in New Orleans Louisiana and are trying to come upon vacation homes for rent by owner, New Orleans Louisiana bed and breakfast rentals, and houses for rent New Orleans can scan our for rent by owner website and our studio ad directories and ski in/out classifieds.
New Orleans rental agents and town home owners list rental properties in New Orleans Louisiana, New Orleans Louisiana rental homes, houses for rent in New Orleans, and house rentals New Orleans Louisiana.
Procure, list, employ, and reserve this evening to take up, take up, get going, and jump into on this visit.
|
|
