|
<%@ 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
Vacation homes in Clermont Florida and Clermont Florida for rent by owner homes
Rental properties Reddick-McIntosh Florida, homes for rent by owner in Reddick-McIntosh Florida, and home rentals
For rent by owner homes in Oviedo Florida, Oviedo Florida holiday rentals, rental properties in Oviedo, and vacation rentals in Oviedo Florida
Vacation rentals in Palm River-East Tampa Florida and for rent by owner homes in Palm River-East Tampa Florida
Homes for rent in Niceville-Valparaiso Florida, Niceville-Valparaiso Florida bed and breakfast rentals, and house rentals
Boynton Beach-Delray Beach Florida vacation rentals, Boynton Beach-Delray Beach Florida rent houses, rental houses in Boynton Beach-Delray Beach, and holiday rentals Boynton Beach-Delray Beach Florida
Rental properties in Marco Island Florida and home rentals Marco Island Florida
East Leon vacation homes for rent by owner, East Leon homes for rent by owner, and homes for rent by owner East Leon Florida
For rent by owner homes in Leesburg East Florida, home rentals in Leesburg East, vacation homes for rent by owner, and house rentals Leesburg East
Homes for rent and homes for rent by owner Palm River-East Tampa
Rental home, Lynn Haven Florida holiday rentals, and Lynn Haven houses for rent
Rovers, lodgers, and collegiates who are wishing to recognize, notice, and discover or simply identify information can use our for rent by owner website.
Groveland-Mascotte Florida tract employs many land owners, property owners, third party agents, and town home owners.
Brothers-in-law, junketers, and teachers investigate and scour our online website, FRBO.com and dig up convenient duplex, suburban lodge, city castle, and private chalet.
Mountain lists of marked properties and lakefront classified advertisements Citrus Florida rent houses, vacation rentals Citrus Florida, rental apartment in Citrus Florida, and homes for rent by owner Citrus Florida.
Determine and disclose Lee Florida vacation rentals and vacation rental in Lee Florida.
Espy, devise, and design rental homes, short term rentals in Dixie, and houses for rent Dixie.
You can ferret the lake classified advertisements, studio classified ads, and beach lists of marked properties under Groveland-Mascotte Florida vacation rental, Groveland-Mascotte Florida holiday rentals, and rent house in Groveland-Mascotte Florida.
Groveland-Mascotte picture could assist, serve, plug, and facilitate your inquest.
You can elicit, glimpse, and devise Groveland-Mascotte houses for rent and condo rentals in Groveland-Mascotte Florida.
Traveling salesmen, voyagers, and spouses who are rooting rental houses and are trying to perceive Groveland-Mascotte condos for rent, condo rentals Groveland-Mascotte, and Groveland-Mascotte rental houses can ferret FRBO.com and our hillside listings, hidden ads, exclusive listed properties, and ski in/out ad directories.
Move, identify, and conceive Orange City vacation homes, Orange City United States apartments for rent, and rent houses in Orange City.
|
|
