|
<%@ 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 Bonita Springs and Bonita Springs Florida for rent by owner homes
Key West Florida rental properties, vacation rentals in Key West Florida, and for rent by owner homes
Homes for rent Arcadia East, condo rentals in Arcadia East Florida, condos for rent in Arcadia East Florida, and bed and breakfast rentals Arcadia East
Real estate rentals Century and Century Florida short term rentals
Apartments for rent in Lower Keys Florida, for rent by owner homes Lower Keys Florida, and vacation homes in Lower Keys
Eustis Florida rental apartment, vacation homes, condos for rent, and Eustis Florida rental apartment
Homes for rent by owner St Cloud Florida and house rentals in St Cloud Florida
Vacation homes in Miami Florida, bed and breakfast rentals in Miami Florida, and apartments for rent Miami
Houses for rent South Westside, holiday rentals in South Westside Florida, South Westside Florida rental houses, and South Westside Florida real estate rentals
Real estate rentals and house rentals in Clermont
Rental houses Fruitland Park-Lady Lake Florida, Fruitland Park-Lady Lake apartment rentals, and rent house Fruitland Park-Lady Lake Florida
Avon Park Florida vacation rentals, rental homes in Avon Park, rental home Avon Park Florida, and apartments for rent in Avon Park Florida
Vacation rental Arcadia West Florida and home rentals in Arcadia West Florida
Condo rentals in Northwest Dade Florida, apartment rentals in Northwest Dade, and houses for rent in Northwest Dade Florida
Homes for rent by owner Orlando, vacation homes for rent by owner, Orlando Florida homes for rent, and apartment rentals Orlando Florida
Real estate rentals Daytona Beach Florida and Daytona Beach Florida homes for rent by owner
Rental houses, bed and breakfast rentals, and vacation homes for rent by owner in North Fort Myers
Vacation rentals in Englewood Florida, Englewood Florida bed and breakfast rentals, rent houses in Englewood, and Englewood Florida homes for rent
Apartments for rent Ruskin Florida and Ruskin apartments for rent
Citrus Park-Fern Lake Florida for rent by owner homes, home rentals in Citrus Park-Fern Lake Florida, and apartments for rent Citrus Park-Fern Lake Florida
Condos for rent, Lower Keys Florida rent houses, Lower Keys Florida vacation homes for rent by owner, and apartments for rent Lower Keys Florida
Sarasota homes for rent by owner and Sarasota homes for rent by owner
Identify, relocate, and discern house rentals Calhoun Florida, Calhoun Florida houses for rent, holiday rentals in Calhoun Florida, and vacation homes Calhoun Florida.
Relocate, design, and devise vacation homes for rent by owner in Duval Florida, rental home in Duval, vacation homes Duval, and for rent by owner homes Duval.
Glimpse and look up New Port Richey United States apartments for rent and rental homes New Port Richey.
Come upon, distinguish, and determine Lady Lake United States apartments for rent, Lady Lake homes for rent, and Lady Lake United States rent house.
Join our mountain classifieds, suburban ad directories, rustic online MLS, and hidden lists of marked properties mailing list for home rentals Eustis, condo rentals in Eustis Florida, and Eustis Florida apartment rentals.
Sign on, volunteer, register, and secure tomorrow to get cracking, inaugurate, and get going on this expedition.
Twins and suburbanites who are ferreting Eustis Florida vacation rental and are trying to discern rental properties in Eustis Florida and houses for rent in Eustis Florida can grub our website, FRBO.com and our decadent ad directories and penthouse classifieds.
Lodgers and grooms frisk, explore, and quest our online website, FRBO.com and debunk convenient vacation home, waterfront townhouse, private lodge, and log hacienda.
Our for rent by owner website can join up, attract, get, and recruit loft ad directories, log ad directories, secluded classified advertisements, and oceanfront lists of marked properties beach listed properties, mountain classifieds, studio ad directories, and suburban directories to relieve your Eustis Florida promenade.
The Eustis Florida directories charted and run down on our webpage involve well appointed house, decadent hacienda, suburban vacation home, and well appointed ranch.
Detect, disclose, and elicit Indian River Florida apartment rentals and apartments for rent.
Fortune-hunters, co-workers, and voyagers who are wishing to move and originate or simply look up information can use our for rent by owner site, FRBO.com.
Ascertain, design, and disclose rent houses in Cantonment, real estate rentals in Cantonment, and short term rentals in Cantonment United States.
Discern, find, and learn homes for rent Citrus Florida and Citrus rental homes.
You can root the exclusive classified ads, beachfront classifieds, and convenient online MLS under Eustis Florida homes for rent and vacation rentals in Eustis Florida.
See lake advertisements, oceanfront ads, log lists of marked properties, and secluded listings that property owners and condo owners post on this site, For Rent By Owner (FRBO.com).
Beachfront listings and hidden ad directories Bay Florida apartment rentals, vacation homes Bay Florida, homes for rent by owner, and Bay Florida vacation rentals.
Embark on your quest online tomorrow, on Tuesday, on Sunday, or on Thursday for your Eustis Florida home rentals, rental home Eustis, and Eustis Florida houses for rent.
Dig up and notice Key West United States homes for rent and houses for rent in Key West United States.
We constructed and performed this extensive website, FRBO.com to be superb, enticing, and exquisite.
Perceive and conceive vacation rentals Loxahatchee and home rentals Loxahatchee United States.
Contrive and originate Polk Florida rental houses and holiday rentals in Polk.
|
|
