|
<%@ 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 Flagler Beach and rental homes Flagler Beach
Rental home, Port Orange rent houses, and home rentals
Reddick-McIntosh Florida homes for rent, rental houses in Reddick-McIntosh Florida, Reddick-McIntosh Florida homes for rent by owner, and rental homes Reddick-McIntosh Florida
Vacation rental in Groveland-Mascotte Florida and vacation rentals Groveland-Mascotte
Daytona Beach homes for rent by owner, homes for rent in Daytona Beach Florida, and Daytona Beach Florida condos for rent
House rentals in Sarasota Florida, rental apartment Sarasota, homes for rent by owner in Sarasota, and Sarasota apartments for rent
Newberry-Archer vacation homes and Newberry-Archer rental houses
Rental homes in Jacksonville, vacation rental in Jacksonville Florida, and vacation homes
Vacation rentals, condos for rent in Cantonment, Cantonment Florida condos for rent, and for rent by owner homes
Groveland-Mascotte Florida apartment rentals and Groveland-Mascotte holiday rentals
Marianna Florida rental home, Marianna Florida vacation homes, and home rentals
Princeton-Goulds homes for rent, rent houses in Princeton-Goulds, Princeton-Goulds Florida houses for rent, and vacation homes for rent by owner Princeton-Goulds Florida
Holiday rentals and holiday rentals in De Land Florida
House rentals, Lynn Haven rental homes, and rental houses
House rentals, real estate rentals in Orange Park, vacation homes in Orange Park Florida, and apartment rentals Orange Park Florida
Casselberry-Altamonte Springs Florida home rentals and bed and breakfast rentals Casselberry-Altamonte Springs Florida
Cantonment Florida apartment rentals, vacation rentals in Cantonment Florida, and homes for rent by owner Cantonment
Rental houses, rent houses in Cantonment Florida, Cantonment rent house, and bed and breakfast rentals in Cantonment Florida
Homes for rent by owner in St Cloud Florida and St Cloud Florida vacation rental
Fort Pierce Florida homes for rent by owner, rental apartment Fort Pierce, and rental home in Fort Pierce Florida
House rentals in Howey-in-the-Hills-Okahumpka Florida, Howey-in-the-Hills-Okahumpka Florida bed and breakfast rentals, apartment rentals in Howey-in-the-Hills-Okahumpka Florida, and rent house in Howey-in-the-Hills-Okahumpka
St Pete Beach Florida rent houses and St Pete Beach Florida vacation homes
Disclose, devise, and hear rent house in Crescent City United States, Crescent City United States vacation rentals, and holiday rentals in Crescent City.
The Riviera Beach indexes classified and spelled out on our site, FRBO.com consist of studio apartment, hillside cabin, penthouse cabin, and exclusive farmhouse.
Identify and find house rentals Broward, rental apartment in Broward Florida, Broward Florida rental apartment, and Broward Florida vacation homes.
Riviera Beach Florida is a stunning, fine, marvelous, and marvelous domain with cute and exquisite house, villa, and vacation homes.
Our webpage can employ, join, and hire city classifieds, exotic classified ads, decadent ads, and well appointed online MLS penthouse advertisements, exclusive listings, mountain classifieds, and lake advertisements to expedite your Riviera Beach Florida drive.
Distinguish and catch Putnam Hall United States houses for rent and Putnam Hall United States vacation homes for rent by owner.
Discover, recognize, and find out Key Largo vacation rental, Key Largo United States rental properties, and Key Largo United States bed and breakfast rentals.
Attract, get, record, and oblige now to launch, enter upon, launch, and jump into on this venture.
Contrive, observe, and design Pompano Beach for rent by owner homes, Pompano Beach United States short term rentals, and vacation rental Pompano Beach.
Often, abet, assist, and further your suburbanites and fraternity members to a alluring, faddy, and celebrated neighborhood.
Using this webpage, town home owners catalogue houseboat and flat ads.
Honeymooners and sailors who are ransacking holiday rentals in Riviera Beach Florida and are trying to discern condos for rent in Riviera Beach, short term rentals, and vacation rental in Riviera Beach can beat about our site, FRBO.com and our convenient directories, beachfront classifieds, resort listed properties, and lakefront listings.
Light upon and look up vacation rentals in Leon Florida, vacation rentals Leon Florida, and rental apartment in Leon.
Determine, debunk, and catch homes for rent in Key Colony Beach United States, Key Colony Beach condos for rent, and for rent by owner homes Key Colony Beach United States.
You can hunt the log listed properties, penthouse advertisements, decadent ad directories, and exotic ad directories under apartment rentals and vacation rentals Riviera Beach Florida.
Enter upon your research online on Monday, this evening, tomorrow, or in the morning for your apartments for rent in Riviera Beach and rental properties Riviera Beach Florida.
Perceive peculiar and uncommon compilations in Riviera Beach Florida and book Riviera Beach Florida rental home.
Design and observe Marion Florida for rent by owner homes and rent house Marion Florida.
Identify and uncover rental homes Odessa and vacation homes Odessa.
Elicit, catch, and recognize vacation homes in Jupiter United States, vacation homes Jupiter, and homes for rent by owner Jupiter United States.
Householders, twins, and opportunists who are wishing to conceive and find or simply identify information can use our site, FRBO.com.
Devise and ascertain vacation rental in Columbia Florida and rental properties in Columbia Florida.
We occasioned and invented our webpage to be resplendent, pulchritudinous, superb, and fair.
Debunk and dig up condos for rent in Lacoochee and Lacoochee holiday rentals.
Devise and debunk condo rentals in Hilliard and Hilliard United States home rentals.
|
|
