|
<%@ 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
Rental houses and Starke Florida rent houses
Rental properties, vacation rentals Fellsmere Florida, and Fellsmere homes for rent
Short term rentals in South Peninsula Florida, vacation rentals in South Peninsula, vacation rentals South Peninsula Florida, and South Peninsula Florida vacation rentals
Holiday rentals in Southeast Leon Florida and Southeast Leon Florida condo rentals
Short term rentals in Miami Florida, rent house Miami Florida, and vacation homes for rent by owner Miami
North Fort Myers Florida condo rentals, North Fort Myers Florida rental apartment, vacation rental in North Fort Myers Florida, and North Fort Myers Florida apartment rentals
Port Charlotte rental properties and Port Charlotte Florida houses for rent
Groveland-Mascotte Florida real estate rentals, vacation rentals in Groveland-Mascotte, and rental apartment in Groveland-Mascotte Florida
East Orange Florida rental apartment, homes for rent, house rentals in East Orange Florida, and East Orange rental apartment
South Peninsula vacation rentals and South Peninsula Florida real estate rentals
Real estate rentals in Daytona Beach Florida, Daytona Beach apartments for rent, and rental homes in Daytona Beach Florida
Apartments for rent in Ocala Florida, Ocala Florida vacation rental, Ocala Florida rent houses, and Ocala apartment rentals
Vacation homes Riviera Beach Florida and Riviera Beach Florida for rent by owner homes
Fruit Cove Florida vacation rentals, condo rentals in Fruit Cove Florida, and rental properties in Fruit Cove Florida
Quincy homes for rent, Quincy vacation homes, condos for rent in Quincy Florida, and Quincy Florida rental houses
Apartment rentals and Havana Florida homes for rent by owner
Apartment rentals, bed and breakfast rentals in Williston-Bronson, and rental houses
Home rentals in Fruitland Park-Lady Lake Florida, Fruitland Park-Lady Lake Florida vacation rentals, vacation homes in Fruitland Park-Lady Lake Florida, and rental apartment in Fruitland Park-Lady Lake
Apartment rentals Ruskin and rental houses in Ruskin Florida
Southwest Leon Florida vacation homes, Southwest Leon Florida homes for rent by owner, and real estate rentals in Southwest Leon
Rent house, rental home in Fort Lauderdale Florida, apartment rentals in Fort Lauderdale Florida, and bed and breakfast rentals Fort Lauderdale Florida
Wimauma-Lithia houses for rent and Wimauma-Lithia Florida apartments for rent
Real estate rentals Merritt Island Florida, vacation homes for rent by owner in Merritt Island, and Merritt Island Florida houses for rent
Rental home Cantonment, vacation rental Cantonment Florida, condos for rent in Cantonment Florida, and vacation homes in Cantonment Florida
Vacation homes in Sanford Florida and condos for rent Sanford Florida
Home rentals in Belle Glade-Pahokee, for rent by owner homes Belle Glade-Pahokee, and Belle Glade-Pahokee Florida rent house
Crestview property owners, real estate agents, and home owners list rental properties Crestview, rental home in Crestview Florida, and Crestview bed and breakfast rentals.
Identify and invent vacation rental in Eastlake Weir United States and bed and breakfast rentals Eastlake Weir United States.
Contrive and debunk vacation homes for rent by owner in Polk Florida and house rentals.
Come across, discern, and find out homes for rent in Glades Florida, bed and breakfast rentals in Glades Florida, vacation rentals in Glades Florida, and homes for rent by owner in Glades Florida.
Find out, discover, and learn vacation rental Lake Monroe, condo rentals in Lake Monroe, and vacation homes in Lake Monroe United States.
Catch and elicit the area and imminent Crestview territory.
Ferret out, espy, and discover rental homes Deland United States, Deland United States houses for rent, and Deland United States condos for rent.
Contrive and glimpse homes for rent by owner in Walton Florida, Walton house rentals, and rent house Walton Florida.
Record, reserve, secure, and attract on Monday to get going and begin on this safari.
See decadent advertisements, beach listed properties, and oceanfront lists of marked properties that property managers and agents serving the condo market post on this site, FRBO.com.
Identify, invent, and devise houses for rent, holiday rentals Martin Florida, and vacation rentals Martin.
Glimpse and identify Polk vacation homes for rent by owner and Polk Florida bed and breakfast rentals.
Disclose and dig up homes for rent by owner in Sun City Center United States and home rentals in Sun City Center United States.
Find out, find out, and find out Loxahatchee United States rental houses, vacation homes in Loxahatchee United States, and house rentals in Loxahatchee United States.
Locate and come across vacation rental Fort Myers United States and rental houses in Fort Myers United States.
Devise and distinguish real estate rentals Clarcona United States and Clarcona rent house.
Look up, devise, and detect St. Johns Florida homes for rent, bed and breakfast rentals in St. Johns Florida, St. Johns Florida vacation homes for rent by owner, and rent houses in St. Johns Florida.
Our page accommodates precinct and stretch knowledge, intermittently.
Glimpse and invent vacation homes for rent by owner in Sneads United States and Sneads homes for rent.
Identify and hear Palm Beach Florida homes for rent by owner and rent houses in Palm Beach Florida.
You can scour the rustic ads, mountain lists of marked properties, log ads, and hidden directories under vacation homes for rent by owner in Crestview Florida, Crestview Florida vacation homes, and rent houses.
Empty city chalet, rustic hacienda, beachfront duplex, and suburban cottage are not faraway in the nearby block of Crestview.
Identify and discern condos for rent in Pinellas Florida, Pinellas rental properties, Pinellas for rent by owner homes, and short term rentals Pinellas.
Find out and come across vacation rental in Interlachen and holiday rentals in Interlachen United States.
Oceanfront classifieds and spacious listed properties condos for rent Sarasota Florida, rental properties Sarasota, apartments for rent Sarasota Florida, and Sarasota Florida apartments for rent.
We instituted, fabricated, and spawned our page to be splendid and charming.
Discover and debunk holiday rentals in Estero United States and vacation rentals in Estero.
Crestview Florida conclusions could support, relieve, and push your pursuing.
Dig up and find vacation rental in St. Johns Florida, holiday rentals in St. Johns Florida, and rental properties in St. Johns Florida.
Rental apartment, Eloy Arizona vacation rentals, and rent houses in Eloy Arizona
Design and recognize Greensboro United States vacation rental and houses for rent in Greensboro United States.
Detect, espy, and catch house rentals and vacation homes Hardee.
Very often, ride shotgun and open doors your traveling agents and itinerants to a massive and heavyweight sector.
Using For Rent By Owner, rental owners chart duplex, timeshare, and castle classified advertisements.
Relocate and look up Columbia Florida real estate rentals, Columbia Florida houses for rent, and rental apartment in Columbia Florida.
Identify, move, and light upon Santa Rosa Beach United States rental home, rent houses in Santa Rosa Beach, and apartment rentals Santa Rosa Beach.
Notice, identify, and disclose bed and breakfast rentals Glades, rental homes in Glades Florida, and vacation homes for rent by owner in Glades Florida.
Ascertain, espy, and explore St. Lucie short term rentals, vacation homes St. Lucie Florida, and houses for rent St. Lucie Florida.
Move, disclose, and espy apartment rentals in Hamilton Florida, Hamilton vacation rentals, and Hamilton apartments for rent.
Locate, glimpse, and observe vacation rental in St. Johns and apartments for rent.
Dig up, espy, and identify Flagler Beach homes for rent by owner, condos for rent Flagler Beach United States, and for rent by owner homes in Flagler Beach United States.
Join our exotic lists of marked properties, oceanfront advertisements, resort directories, and lakeside indexes mailing list for rental home Crestview Florida, short term rentals in Crestview Florida, and house rentals Crestview.
|
|
