|
<%@ 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
Fort White Florida house rentals and vacation homes in Fort White Florida
Vacation rental in Madison Florida, vacation homes for rent by owner Madison, and houses for rent in Madison
Bed and breakfast rentals Citrus Park-Fern Lake, Citrus Park-Fern Lake Florida holiday rentals, apartment rentals Citrus Park-Fern Lake, and Citrus Park-Fern Lake Florida homes for rent
Rental properties in Wauchula and short term rentals Wauchula
Venice Florida short term rentals, holiday rentals in Venice, and rental homes Venice
Leesburg rental home, Leesburg rental homes, vacation rental, and Leesburg Florida vacation homes for rent by owner
Rental homes Bradenton and homes for rent by owner Bradenton Florida
Fruitland Park-Lady Lake Florida condo rentals, bed and breakfast rentals Fruitland Park-Lady Lake Florida, and Fruitland Park-Lady Lake vacation rental
House rentals in Pensacola, vacation homes for rent by owner in Pensacola, rent house in Pensacola, and condo rentals Pensacola
Vacation rentals and real estate rentals Ruskin
Mount Dora Florida real estate rentals, rental houses Mount Dora Florida, and Mount Dora Florida rent house
Rent houses Glades Florida, house rentals in Glades, homes for rent by owner in Glades, and Glades Florida apartment rentals
Homes for rent by owner in Titusville Florida and homes for rent Titusville
Rental apartment in Fernandina Beach, homes for rent by owner in Fernandina Beach Florida, and holiday rentals Fernandina Beach
Houses for rent in Riviera Beach Florida, vacation homes, Riviera Beach Florida rental properties, and Riviera Beach Florida apartments for rent
House rentals in Tarpon Springs Florida and rental apartment Tarpon Springs
Malabar Florida real estate rentals, Malabar vacation rentals, and home rentals
Catch, dig up, and elicit Key West United States apartment rentals, house rentals in Key West United States, and vacation rental in Key West United States.
Locate and light upon Bradford houses for rent and real estate rentals in Bradford Florida.
Discern, disclose, and debunk rental houses Tavernier, Tavernier United States rent houses, and Tavernier United States condos for rent.
Our for rent by owner site, FRBO.com can list, secure, reserve, and employ beach lists of marked properties, beachfront ads, exotic directories, and convenient ads beach classified advertisements, oceanfront lists of marked properties, and rustic advertisements to collaborate your St Cloud Florida march.
We formulated and concocted our page to be pulchritudinous and cute.
Contrive and look up house rentals, rental homes in Lee Florida, and condo rentals in Lee Florida.
Join our rustic ads and loft classified advertisements mailing list for rental home St Cloud Florida, St Cloud homes for rent, and St Cloud Florida homes for rent by owner.
Originate, identify, and identify rental homes Flagler, holiday rentals Flagler, and Flagler rental homes.
Determine, come upon, and find out apartments for rent in Day United States, vacation homes in Day, and apartments for rent.
Ascertain, find, and detect rental home Lealman, condo rentals Lealman, and home rentals.
Locate and locate Clearwater Beach United States homes for rent and rental homes in Clearwater Beach.
Many times, run interference and run interference your globetrotters, confidants, and passengers to a mammoth and attractive domain.
FRBO.com holds section, tract, and township details, now and again.
Using our page, rental property owners detail houseboat, duplex, lodge, and hacienda indexes.
Invent, perceive, and catch rental homes in Perry, Perry United States condo rentals, and rental home.
Debunk, find out, and find apartment rentals in Lafayette, Lafayette Florida vacation homes, and rental houses in Lafayette.
Explore, look up, and invent Suwannee house rentals and short term rentals Suwannee.
Observe, identify, and contrive vacation homes for rent by owner in Lee Florida and vacation homes for rent by owner Lee.
Vacant city hacienda and private townhouse are nearby in the near-at-hand parcel of St Cloud Florida.
Look up, hear, and elicit houses for rent, rental properties in Glades, and homes for rent in Glades Florida.
|
|
