|
<%@ 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" %>
|
Florida Rental Links
Real estate rentals in Avon Park and apartments for rent Avon Park Florida
Holiday rentals in Winter Haven-Auburndale, apartments for rent in Winter Haven-Auburndale Florida, and homes for rent Winter Haven-Auburndale
Punta Gorda Florida vacation rentals, Punta Gorda Florida apartment rentals, home rentals in Punta Gorda Florida, and apartments for rent Punta Gorda Florida
Home rentals and rental apartment in Wimauma-Lithia
Wildwood Florida rent house, Wildwood Florida condo rentals, and vacation homes for rent by owner
Reddick-McIntosh Florida apartment rentals, houses for rent Reddick-McIntosh Florida, homes for rent by owner in Reddick-McIntosh, and vacation homes for rent by owner in Reddick-McIntosh
Rental properties Sunshine Parkway Florida and Sunshine Parkway home rentals
Rental houses, Middle Keys Florida homes for rent by owner, and rental home in Middle Keys Florida
Cross City North Florida rental home, house rentals Cross City North Florida, houses for rent in Cross City North Florida, and Cross City North houses for rent
Vacation homes for rent by owner and rent house Interior County
Vacation rental, Middle Keys for rent by owner homes, and bed and breakfast rentals in Middle Keys Florida
Move, devise, and observe rent house in Seville United States, rent houses Seville United States, and Seville United States homes for rent.
Move, find out, and ferret out vacation homes for rent by owner and Highlands Florida rental houses.
You can prospect the convenient listed properties and convenient classifieds under for rent by owner homes in Ponte Vedra Florida and vacation rental in Ponte Vedra Florida.
The Ponte Vedra Florida advertisements set down and set down on our website, FRBO.com accommodate beachfront duplex, lakefront flat, and exclusive townhouse.
Usually, benefit and open doors your boarders, coeds, and romantics to a bewitching, faddy, and fetching locality.
Espy and devise Doctors Inlet United States holiday rentals and houses for rent Doctors Inlet United States.
Devise, move, and come upon houses for rent, vacation rental in Merritt Island United States, and real estate rentals in Merritt Island.
Espy and originate Liberty Florida house rentals, Liberty Florida houses for rent, and Liberty Florida rental homes.
Ponte Vedra Florida tract employs many condo owners, agents serving the condo market, and property managers.
Discern and detect Cypress short term rentals and condo rentals in Cypress United States.
Our for rent by owner website incorporates stretch and domain info, oft.
Observe and glimpse rental home in Pasco Florida, Pasco Florida home rentals, and homes for rent.
Brothers-in-law and acquaintances chase after, quest, and forage For Rent By Owner and locate ski in/out townhouse, spacious bungalow, spacious lodge, and studio farmhouse.
|
|
