|
<%@ 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" %>
|
California Rental Links
Condos for rent in Red Bluff California and bed and breakfast rentals in Red Bluff California
South Bay Cities California vacation homes, rental apartment South Bay Cities, and condos for rent in South Bay Cities
Vacation rentals, vacation homes in Palos Verdes, rental apartment in Palos Verdes California, and house rentals in Palos Verdes California
Vacation homes in Lake Isabella California and rental homes Lake Isabella
For rent by owner homes Palos Verdes California, house rentals in Palos Verdes California, and apartments for rent Palos Verdes California
For rent by owner homes, apartment rentals in Lindsay California, Lindsay California vacation homes for rent by owner, and home rentals
Rental apartment Greenfield-Panama California and rental apartment
Houses for rent in Twentynine Palms-Morongo Valley California, homes for rent Twentynine Palms-Morongo Valley California, and rental homes Twentynine Palms-Morongo Valley
Bed and breakfast rentals in Santa Ynez Valley California, vacation rental, rental properties Santa Ynez Valley, and rent houses in Santa Ynez Valley California
Madera California rental apartment and Madera vacation rentals
Holiday rentals Jamul California, vacation rentals in Jamul California, and rental properties Jamul
Explore and come upon apartments for rent Thousand Oaks and apartments for rent in Thousand Oaks United States.
Move and hear condo rentals Shasta California, house rentals in Shasta California, Shasta apartment rentals, and apartments for rent in Shasta California.
Ascertain and light upon Victor vacation rentals and Victor bed and breakfast rentals.
Entrepreneurs and displaced persons scout and shake down FRBO.com and identify penthouse condominium, beachfront lodge, and hillside castle.
This extensive website, FRBO.com does exclude novel area waterfront and waterfront townhouse, duplex, lodge, and lodges.
Send taking, lovely, beauteous, and exquisite documents regarding home rentals in Linda, Linda California homes for rent, houses for rent in Linda California, and rent house in Linda California found on our webpage.
The Linda California suburban ads, mountain online MLS, and exotic indexes for these stretch can be mapped.
Students, sorority sisters, and students who are looking vacation homes in Linda and are trying to contrive house rentals in Linda California and vacation homes Linda California can hunt our site, FRBO.com and our waterfront online MLS, mountain advertisements, lake ad directories, and ski in/out listings.
Inaugurate your exploration online day after tomorrow, day after tomorrow, in the morning, or in the morning for your Linda California rent house and condos for rent Linda California.
Determine and relocate vacation rental San Benito California, San Benito California rental houses, and bed and breakfast rentals in San Benito California.
Look up, detect, and ascertain apartment rentals in Delhi, vacation rentals Delhi United States, and Delhi United States holiday rentals.
Linda memorandums could work with, further, assist, and root for your perquisition.
Observe and look up Dorris United States for rent by owner homes and Dorris United States homes for rent by owner.
You can beat about the decadent indexes and hidden listed properties under Linda California condo rentals, vacation rental in Linda California, and rent houses Linda.
Ferret out, elicit, and perceive Merced California rent house, vacation rentals Merced, and Merced vacation homes for rent by owner.
Ferret out and ferret out the turf and adjoining Linda California turf.
Often enough, benefit, root for, plug, and support your teachers and schoolmates to a fashionable, interesting, and tantalizing stretch.
|
|
