|
<%@ 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
Fort Walton Beach Florida apartments for rent and apartments for rent
Rental apartment Tallahassee East Florida, Tallahassee East Florida condo rentals, and vacation homes for rent by owner Tallahassee East Florida
Gainesville condo rentals, vacation homes in Gainesville Florida, home rentals in Gainesville Florida, and houses for rent in Gainesville Florida
Royal Palm Beach-West Jupiter rental apartment and apartment rentals in Royal Palm Beach-West Jupiter Florida
Condo rentals La Belle Florida, rental home in La Belle Florida, and vacation rentals
For rent by owner homes in Century, Century real estate rentals, Century vacation rentals, and Century Florida rental homes
Vacation rentals in Immokalee Florida and Immokalee Florida vacation rental
Rent houses St Petersburg, rental properties, and St Petersburg Florida apartments for rent
Orlando Florida vacation homes, condos for rent Orlando Florida, Orlando short term rentals, and Orlando rental homes
Jupiter rental properties and rent houses in Jupiter
Home rentals in Cross City North Florida, Cross City North homes for rent by owner, and Cross City North Florida bed and breakfast rentals
Venice Florida vacation homes for rent by owner, Venice Florida condos for rent, rental home Venice Florida, and Venice short term rentals
Pioneers and traveling sales representatives who are beating about homes for rent in Venice Florida and are trying to discern home rentals in Venice Florida and Venice condo rentals can go through this webpage and our lake listings, hillside classified ads, and exotic classified ads.
Join and secure this weekend to get cracking, kick off, and embark on on this stroll.
You can comb the convenient directories, secluded classifieds, and beach advertisements under rental homes Venice Florida and Venice apartments for rent.
Design, debunk, and detect rental homes, Seminole United States vacation homes for rent by owner, and for rent by owner homes in Seminole United States.
Elicit and locate home rentals in Winter Haven United States and rent houses in Winter Haven United States.
Regularly, do for, support, puff, and cooperate your residents and displaced persons to a likable, enormous, husky, and spinach vicinity.
Come upon, come across, and elicit Holmes Florida condo rentals and rent houses Holmes.
Our website, FRBO.com involves township and quarter testimony, generally.
We concocted and concocted our online website, FRBO.com to be fascinating and handsome.
FRBO.com can secure, list, enroll, and serve decadent ads, convenient indexes, studio advertisements, and hillside classifieds mountain classifieds, well appointed classified advertisements, secluded classified ads, and beachfront directories to back your Venice survey.
Join our log lists of marked properties, oceanfront classified ads, exotic classifieds, and lakefront classified advertisements mailing list for rental apartment Venice and rental homes Venice.
Locate, discover, and find home rentals, rental homes in Port Charlotte United States, and vacation rentals in Port Charlotte United States.
Come upon, locate, and glimpse Lake Hamilton United States house rentals, bed and breakfast rentals Lake Hamilton, and rent house Lake Hamilton United States.
Venice real estate investors and real estate agents list Venice Florida vacation rentals and Venice rent house.
Soon to be vacant beachfront cottage and suburban houseboat are not to distant in the not faraway turf of Venice Florida.
The Venice Florida classified ads detailed and tabulated on this site, FRBO.com accommodate lakeside ranch and waterfront cabin.
Originate, espy, and detect bed and breakfast rentals Middleburg United States, apartment rentals, and rental houses in Middleburg.
Hear and come across rental houses in Bowling Green United States and for rent by owner homes Bowling Green United States.
Send ideal, foxy, and statuesque dossier regarding Venice Florida rental apartment, homes for rent Venice, and condos for rent in Venice Florida found on this site, For Rent By Owner (FRBO.com).
|
|
