|
<%@ 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
Vacation homes for rent by owner and Meiners Oaks-Ojai for rent by owner homes
House rentals, rental home in Cathedral City-Palm Desert, and holiday rentals in Cathedral City-Palm Desert California
Houses for rent in Modesto, holiday rentals Modesto, Modesto real estate rentals, and bed and breakfast rentals Modesto California
Rental houses and Berkeley California bed and breakfast rentals
Upper Lake-Clearlake Oaks California homes for rent, vacation homes for rent by owner in Upper Lake-Clearlake Oaks California, and Upper Lake-Clearlake Oaks California vacation homes
Home rentals in Seaside-Monterey, Seaside-Monterey California holiday rentals, houses for rent in Seaside-Monterey, and Seaside-Monterey California bed and breakfast rentals
Real estate rentals Arroyo Grande and Arroyo Grande California rental apartment
Apartment rentals South Bay Cities, rental homes in South Bay Cities California, and bed and breakfast rentals in South Bay Cities
Vacation homes San Francisco California, San Francisco California homes for rent by owner, rental home in San Francisco California, and rental houses
Rent house Corona and vacation rentals in Corona California
Arroyo Grande vacation rental, bed and breakfast rentals Arroyo Grande, and holiday rentals in Arroyo Grande California
Barstow-Victorville vacation rentals, apartments for rent in Barstow-Victorville California, Barstow-Victorville homes for rent by owner, and house rentals Barstow-Victorville
Fort Bragg California home rentals and vacation homes for rent by owner in Fort Bragg California
Houses for rent in Yuba City California, Yuba City California vacation rentals, and Yuba City vacation rentals
Rent house Santa Ynez Valley, Santa Ynez Valley California rent houses, rent houses, and rent houses in Santa Ynez Valley
Condo rentals in Nevada City California and home rentals in Nevada City
Rental properties in Alpine, home rentals in Alpine California, and bed and breakfast rentals in Alpine California
Inhabitants, venturers, and indwellers beat about and inspect For Rent By Owner and discover log chalet, exclusive home, mountain timeshare, and beach apartment.
Dig up and find rent house in Monterey and rent house Monterey.
We imagined and designed For Rent By Owner to be resplendent, divine, exquisite, and delightful.
Honeymooners and roamers who are wishing to learn and observe or simply espy information can use this website, FRBO.com.
Explore and identify Nevada apartment rentals, apartment rentals Nevada, and Nevada California homes for rent by owner.
Trekkers, fraternity members, and lodgers who are seeking homes for rent Upper Lake-Clearlake Oaks and are trying to discern vacation rental in Upper Lake-Clearlake Oaks and rental properties Upper Lake-Clearlake Oaks California can look for our page and our penthouse classifieds and oceanfront directories.
Hear, ascertain, and disclose real estate rentals in Solano California, real estate rentals in Solano California, and rent houses in Solano.
Glimpse, light upon, and ferret out homes for rent in Korbel, Korbel United States apartments for rent, and Korbel United States vacation rental.
Upper Lake-Clearlake Oaks brokers leasing foreclosures and rental property owners list rental homes in Upper Lake-Clearlake Oaks California, Upper Lake-Clearlake Oaks California apartment rentals, bed and breakfast rentals Upper Lake-Clearlake Oaks California, and apartments for rent in Upper Lake-Clearlake Oaks.
Ferret out and find out for rent by owner homes Traver United States and rental home in Traver United States.
Catch and light upon houses for rent and Fellows rental home.
You can hunt for the penthouse directories, beachfront indexes, exclusive listings, and beach classified advertisements under Upper Lake-Clearlake Oaks apartments for rent and condo rentals Upper Lake-Clearlake Oaks.
Kick off your pursuing online tomorrow afternoon, on Wednesday, on Tuesday, or next week for your condo rentals in Upper Lake-Clearlake Oaks California, rental home, and apartments for rent Upper Lake-Clearlake Oaks.
Glimpse and find Santa Barbara California vacation rental, apartments for rent, apartments for rent in Santa Barbara, and rental houses in Santa Barbara California.
Find, devise, and contrive rent house, rental houses Butte, condo rentals in Butte California, and homes for rent in Butte California.
The Upper Lake-Clearlake Oaks California exotic listed properties, studio classified advertisements, loft lists of marked properties, and oceanfront advertisements for these patch can be mapped.
Light upon and relocate homes for rent by owner Menlo Park and real estate rentals.
Devise, ascertain, and disclose Parker Dam rental houses, house rentals Parker Dam, and condo rentals Parker Dam United States.
Design and observe Tulare rental home and Tulare houses for rent.
Come across, observe, and locate apartment rentals in Palm Springs United States, Palm Springs home rentals, and homes for rent by owner.
Lakefront listed properties and mountain listed properties Napa rental houses, homes for rent by owner Napa, rent houses Napa, and vacation homes for rent by owner in Napa.
Upper Lake-Clearlake Oaks California picture could root for and aid your investigation.
Identify and identify home rentals in Alameda California, apartments for rent in Alameda California, and Alameda rental home.
Come upon, ascertain, and observe house rentals, rent house, and rental properties in Yuba California.
Come upon and debunk holiday rentals in Alpine California and homes for rent in Alpine.
|
|
