|
<%@ 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
Apartments for rent Crescent City and apartment rentals Crescent City
Condos for rent, rent house, and house rentals in Lake Wales
Brandon apartment rentals, house rentals in Brandon, Brandon Florida homes for rent by owner, and rental properties Brandon
Vacation homes for rent by owner Crestview Florida and Crestview house rentals
Immokalee Florida vacation rentals, house rentals in Immokalee, and short term rentals in Immokalee
Yulee Florida for rent by owner homes, condos for rent Yulee Florida, Yulee Florida vacation homes for rent by owner, and houses for rent in Yulee
Condo rentals in Sanford Florida and homes for rent by owner in Sanford Florida
South Peninsula rental homes, vacation rentals South Peninsula Florida, and rent house in South Peninsula
Royal Palm Beach-West Jupiter Florida vacation homes for rent by owner, rental homes in Royal Palm Beach-West Jupiter Florida, Royal Palm Beach-West Jupiter vacation rental, and rental houses Royal Palm Beach-West Jupiter Florida
Rental properties in Haines City and Haines City Florida vacation rentals
Rental homes in Deerfield Beach, Deerfield Beach rental houses, and condo rentals in Deerfield Beach
Rent house in Tallahassee Southwest, rent houses in Tallahassee Southwest Florida, real estate rentals in Tallahassee Southwest Florida, and Tallahassee Southwest Florida short term rentals
Vacation homes for rent by owner in Zephyrhills and Zephyrhills Florida houses for rent
Very often, help, abet, and hype your natives and occupiers to a charming, massive, now, and lovable state.
For Rent By Owner take ins township, turf, and territory experiments, recurrently.
Glimpse and catch Minneola vacation homes for rent by owner and real estate rentals Minneola.
Fortune-hunters and locals who are frisking Northwest Leon Florida rental homes and are trying to conceive short term rentals Northwest Leon Florida and rental houses can poke into our site, FRBO.com and our city classified ads, penthouse classified ads, and waterfront lists of marked properties.
Look up and hear holiday rentals in Polk Florida, vacation rentals Polk, rental apartment in Polk Florida, and holiday rentals Polk.
Our webpage does accommodate individual beach, exclusive, spacious, and hillside ranch and ranchs.
Notice, distinguish, and discern apartments for rent Hollister United States, rental apartment in Hollister, and bed and breakfast rentals in Hollister United States.
Originate, determine, and observe rental homes Washington, Washington Florida homes for rent, and short term rentals Washington Florida.
We hatched and concocted this site, FRBO.com to be angelic, dazzling, and pretty.
Send cute and graceful input regarding Northwest Leon Florida rental homes and rent houses Northwest Leon Florida found on For Rent By Owner.
See decadent indexes, loft ad directories, mountain classified ads, and beach advertisements that agents and property owners post on this extensive website, FRBO.com.
Northwest Leon Florida is a fair, charming, and comely tract with marvelous and lovely house and lodges.
Northwest Leon third party agents and property agents list Northwest Leon Florida home rentals, Northwest Leon home rentals, and condos for rent Northwest Leon Florida.
|
|
