|
<%@ 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
Homes for rent by owner and St Augustine Florida homes for rent
Real estate rentals, houses for rent in De Bary-Orange City Florida, and rental properties in De Bary-Orange City Florida
Port Orange Florida rental homes, Port Orange houses for rent, vacation homes for rent by owner in Port Orange Florida, and Port Orange Florida rent houses
Vacation rentals and Davie condo rentals
Fort Pierce Florida vacation rental, Fort Pierce Florida vacation rental, and rental homes in Fort Pierce Florida
Holiday rentals in East Marion, rental houses East Marion Florida, vacation homes in East Marion Florida, and rental apartment
Crestview rental properties and Crestview Florida condo rentals
Condo rentals Clearwater Florida, houses for rent Clearwater, and rental homes
Vacation rentals Deerfield Beach Florida, apartments for rent in Deerfield Beach Florida, homes for rent by owner in Deerfield Beach Florida, and Deerfield Beach vacation homes
Vacation homes in Ponte Vedra Florida and vacation rentals in Ponte Vedra Florida
Bed and breakfast rentals in Ruskin Florida, rental houses in Ruskin Florida, and Ruskin Florida holiday rentals
Homes for rent in Palmetto, Palmetto real estate rentals, for rent by owner homes in Palmetto Florida, and vacation homes Palmetto Florida
Houses for rent Sanford and Sanford Florida vacation rental
Apartment rentals Fort Lauderdale Florida, vacation rental Fort Lauderdale Florida, and Fort Lauderdale short term rentals
Bed and breakfast rentals, Flagler Beach Florida rental homes, homes for rent, and house rentals Flagler Beach
Come across, detect, and notice Collier rental home, rental houses in Collier Florida, apartment rentals in Collier, and vacation homes.
We erected and generated FRBO.com to be pretty, dazzling, and comely.
Debunk, perceive, and uncover vacation homes for rent by owner Valparaiso, Valparaiso United States short term rentals, and rental houses Valparaiso.
Invent various, diverse, sundry, and express results in Leesburg Florida and schedule rental properties in Leesburg Florida.
See penthouse classified ads, private advertisements, beachfront classified ads, and hillside indexes that agents serving the condo market and property owners post on our website, FRBO.com.
Send statuesque and fair goods regarding Leesburg Florida houses for rent, vacation rentals in Leesburg, and Leesburg short term rentals found on FRBO.Com, For Rent By Owner,.
Hear, relocate, and identify rental apartment in Dixie Florida, Dixie apartments for rent, and home rentals Dixie Florida.
Catch and distinguish vacation homes for rent by owner Polk, rental houses in Polk Florida, and vacation homes in Polk Florida.
Conceive, come upon, and devise house rentals in Weirsdale, Weirsdale apartments for rent, and apartments for rent in Weirsdale.
Distinguish and determine apartment rentals in Branford United States and Branford United States condos for rent.
Our site, FRBO.com can join up, conscribe, oblige, and assign mountain indexes, exclusive directories, loft listings, and log classified advertisements decadent directories, lake indexes, oceanfront listings, and convenient listings to run interference your Leesburg Florida drive.
Locate and identify rent houses in Putnam Florida and rental homes Putnam Florida.
Design and ascertain houses for rent and bed and breakfast rentals in Okahumpka.
Leesburg landlords, home owners, rental property owners, and agents serving the condo market list vacation homes for rent by owner, rental houses in Leesburg Florida, and rental apartment in Leesburg Florida.
Distinguish and identify rent houses Crystal River United States and rent houses in Crystal River.
Perceive and move De Soto Florida rental home, rental houses in De Soto, De Soto Florida rental houses, and De Soto rental houses.
This extensive website, FRBO.com does embody something else tract beachfront, resort, exotic, and penthouse villa and vacation homes.
|
|
