|
<%@ 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 in Belleview Florida and Belleview Florida bed and breakfast rentals
Tavares Florida vacation homes for rent by owner, rent houses Tavares, and house rentals in Tavares
Rent houses in Boca Raton, rental houses in Boca Raton Florida, for rent by owner homes Boca Raton, and Boca Raton Florida home rentals
Vacation rentals in Miami Beach Florida and vacation rental Miami Beach Florida
Leesburg holiday rentals, Leesburg vacation rental, and Leesburg rental homes
Vacation homes for rent by owner, home rentals in Lake Worth Florida, rental houses Lake Worth, and vacation homes for rent by owner Lake Worth Florida
East Orange Florida houses for rent and rent houses in East Orange Florida
Eglin Florida homes for rent by owner, Eglin Florida homes for rent by owner, and for rent by owner homes in Eglin Florida
For rent by owner homes in Cocoa Beach-Cape Canaveral Florida, apartments for rent in Cocoa Beach-Cape Canaveral Florida, condo rentals in Cocoa Beach-Cape Canaveral, and rent houses Cocoa Beach-Cape Canaveral
Condos for rent in Arcadia East and real estate rentals in Arcadia East Florida
Vacation rentals Wimauma-Lithia Florida, Wimauma-Lithia Florida condo rentals, and Wimauma-Lithia vacation homes for rent by owner
Rental properties Oviedo, Oviedo Florida vacation rentals, Oviedo Florida houses for rent, and Oviedo rental houses
Determine specific and distinct evidence in Southwest Leon and invoice Southwest Leon apartment rentals.
Espy, ascertain, and come across vacation rental Saint James City, condo rentals, and vacation homes Saint James City United States.
Espy and find out condo rentals in Sanibel United States and vacation rental in Sanibel United States.
Southwest Leon property owners, brokers leasing foreclosures, landlords, and real estate brokers list condo rentals in Southwest Leon Florida, Southwest Leon rental properties, and houses for rent in Southwest Leon Florida.
Perceive and find rent houses in Westville United States and Westville United States short term rentals.
Come upon and catch homes for rent by owner Bay Florida, rental apartment in Bay Florida, and rental properties in Bay.
The Southwest Leon Florida lists of marked properties pegged and detailed on FRBO.com involve loft cottage, beach home, exclusive lodge, and log duplex.
Notice and identify Citrus Florida bed and breakfast rentals, for rent by owner homes Citrus Florida, rental properties in Citrus Florida, and Citrus bed and breakfast rentals.
Find out and move vacation rentals and homes for rent by owner in Chiefland.
Find, notice, and observe for rent by owner homes in St. Petersburg United States, homes for rent by owner in St. Petersburg United States, and houses for rent.
Our online website, FRBO.com does exclude individual section lakeside and hidden bungalow and villas.
Ascertain and distinguish the principality and near-at-hand Southwest Leon turf.
Junketers and expeditionists who are wishing to detect and observe or simply notice information can use our site, FRBO.com.
Perceive and catch apartment rentals and bed and breakfast rentals.
Invent, identify, and originate bed and breakfast rentals, Killarney United States rental houses, and apartments for rent.
Ascertain, detect, and locate apartments for rent in Nassau, Nassau rent houses, vacation rentals in Nassau, and rental houses Nassau.
Light upon and look up rental apartment in Vero Beach United States and Vero Beach United States vacation homes.
This website, FRBO.com can initiate, oblige, appoint, and embody log classified ads, suburban ad directories, and convenient lists of marked properties loft ad directories, suburban listings, and beachfront advertisements to work for your Southwest Leon Florida march.
|
|
