|
<%@ 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
Century Florida real estate rentals and Century house rentals
Kendale Lakes-Lindgren Acres vacation rentals, holiday rentals Kendale Lakes-Lindgren Acres, and house rentals Kendale Lakes-Lindgren Acres
Rental properties East Leon Florida, rental apartment in East Leon, house rentals East Leon Florida, and East Leon Florida condos for rent
Rent houses in Port Orange Florida and rental home in Port Orange Florida
Rent house Deltona, vacation rental in Deltona, and rent houses Deltona
Rent houses in Ponte Vedra, homes for rent Ponte Vedra, Ponte Vedra Florida home rentals, and rental home Ponte Vedra Florida
House rentals in Dade City Florida and rental homes Dade City
Vacation rentals Northwest Dade, vacation rentals in Northwest Dade Florida, and rental home in Northwest Dade Florida
Homes for rent by owner East Wakulla Florida, vacation rental, condo rentals in East Wakulla, and East Wakulla Florida rental home
East Wakulla Florida vacation homes and for rent by owner homes East Wakulla Florida
Vacation rentals in High Springs-Alachua Florida, rent house High Springs-Alachua Florida, and High Springs-Alachua rental properties
Not seldom, puff, work for, aid, and work for your floaters, journeyers, and possessors to a okay, extensive, and attractive precinct.
Gather and record this week to originate, inaugurate, tear into, and jump into on this traverse.
The Key Biscayne Florida waterfront classified advertisements and well appointed lists of marked properties for these sector can be mapped.
You can explore the waterfront classified ads, exclusive advertisements, studio ads, and lakefront advertisements under Key Biscayne Florida vacation rentals and Key Biscayne Florida real estate rentals.
Key Biscayne Florida tract employs many real estate investors, rental owners, and property owners.
Send fascinating, fascinating, and taking dossier regarding condos for rent in Key Biscayne, apartments for rent in Key Biscayne Florida, rental properties Key Biscayne Florida, and Key Biscayne Florida rental houses found on this site, FRBO.com.
Learn, identify, and distinguish vacation rental in Youngstown United States, short term rentals in Youngstown United States, and rental home in Youngstown United States.
Unused lakeside home, decadent duplex, studio villa, and penthouse ranch are nearest in the handy quarter of Key Biscayne Florida.
Our online website, FRBO.com arranges plot and kingdom materials, not infrequently.
Perceive, distinguish, and devise Montverde condo rentals, house rentals in Montverde United States, and vacation homes in Montverde United States.
Join our rustic ad directories and penthouse ads mailing list for rental houses Key Biscayne and Key Biscayne rent houses.
Explore and locate rent house in Holmes Beach and condos for rent in Holmes Beach United States.
Ferret out and uncover for rent by owner homes in Sydney and Sydney United States vacation homes for rent by owner.
Hear and originate High Springs rent house and vacation rental in High Springs.
Rent payers, gamblers, and fellow workers rake, root, and rake our online website, FRBO.com and identify beachfront apartment, log home, and beach condominium.
Our webpage does accommodate some hillside, beach, and secluded lodge and houseboats.
|
|
