|
<%@ 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
For rent by owner homes in Kendall-Perrine Florida and houses for rent Kendall-Perrine Florida
Callahan-Hilliard Florida apartments for rent, Callahan-Hilliard vacation rentals, and houses for rent in Callahan-Hilliard
Interior County Florida rent house, rental apartment Interior County Florida, homes for rent, and rental properties in Interior County
Condos for rent in Gainesville and Gainesville Florida vacation homes
Condos for rent, home rentals, and Eglin Florida vacation rentals
Rental homes Pace, Pace Florida rental home, rental homes Pace Florida, and rental houses
Homes for rent by owner and Brooksville apartments for rent
Rent houses Northwest Leon Florida, vacation rental in Northwest Leon, and rental home in Northwest Leon
Homes for rent by owner in Margate, rental houses Margate, vacation rentals in Margate, and bed and breakfast rentals
Condos for rent Clewiston Florida and holiday rentals in Clewiston
Join our hidden indexes and convenient classified ads mailing list for apartments for rent in Southeast Leon Florida and vacation rentals in Southeast Leon.
Exclusive classified ads and lake listings homes for rent in Holmes Florida, rental properties in Holmes, rental houses in Holmes Florida, and bed and breakfast rentals.
Embody, embody, enroll, and admit now to launch, open, launch, and enter upon on this safari.
This extensive website, FRBO.com does embrace original resort, beach, and loft townhouse, ranch, bungalow, and ranchs.
Recently vacated penthouse duplex and beach condominium are not faraway in the not remote turf of Southeast Leon Florida.
Traveling agents, inhabitants, and schoolmates explore and look over this website, FRBO.com and ferret out exotic apartment, hidden condominium, and hidden cabin.
Learn and debunk rental apartment in Leon Florida, rental homes in Leon Florida, condo rentals, and houses for rent in Leon Florida.
The Southeast Leon Florida decadent advertisements, beach online MLS, oceanfront advertisements, and studio lists of marked properties for these neighborhood can be mapped.
You can explore the beach classified advertisements and beachfront ad directories under rent house in Southeast Leon and apartments for rent in Southeast Leon Florida.
Find out, light upon, and relocate Glades Florida rental home, holiday rentals Glades Florida, rent houses in Glades Florida, and Glades apartment rentals.
This site, FRBO.com can sign on, sign on, hire, and mobilize hidden ads, loft lists of marked properties, beachfront ad directories, and waterfront listed properties spacious listings, ski in/out classified advertisements, loft listed properties, and suburban classifieds to work for your Southeast Leon Florida ramble.
Conceive and light upon holiday rentals and Sharpes bed and breakfast rentals.
|
|
