|
<%@ 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 homes for rent by owner East Contra Costa California
Home rentals in Calabasas California, Calabasas house rentals, and homes for rent by owner
Red Bluff California bed and breakfast rentals, apartment rentals in Red Bluff California, vacation rental in Red Bluff, and short term rentals Red Bluff California
Vacation homes Lodi and for rent by owner homes Lodi
Homes for rent by owner, Newhall houses for rent, and rent houses Newhall
Rental home in Tracy California, Tracy houses for rent, Tracy California holiday rentals, and vacation rentals Tracy
Rental properties in Antioch-Pittsburg California and Antioch-Pittsburg California apartments for rent
Hanford California rental properties, rent houses, and Hanford California home rentals
Vacation rentals Twentynine Palms-Morongo Valley, vacation homes for rent by owner in Twentynine Palms-Morongo Valley California, rental home in Twentynine Palms-Morongo Valley California, and Twentynine Palms-Morongo Valley California real estate rentals
Vacation homes Ripon California and rent house Ripon
Rental homes, Lake Mathews California homes for rent by owner, and Lake Mathews California apartment rentals
Thousand Oaks California rental home, Thousand Oaks California condos for rent, rental properties Thousand Oaks, and for rent by owner homes in Thousand Oaks
Rental apartment in Lompoc Valley California and rental apartment Lompoc Valley California
Homes for rent in Santa Barbara, vacation rental in Santa Barbara, and rental homes in Santa Barbara California
Apartments for rent in Ventura, Ventura short term rentals, apartments for rent in Ventura California, and vacation rental in Ventura California
Vacation rentals in Merced and vacation homes for rent by owner Merced California
Rent houses in Hanford California, rental homes, and rental apartment Hanford
Homes for rent by owner in Stratford California, Stratford California homes for rent by owner, rental houses, and houses for rent Stratford
Garberville California houses for rent and vacation rental
House rentals, bed and breakfast rentals, and Big Bear California apartments for rent
Barstow-Victorville rental home, Barstow-Victorville California condos for rent, Barstow-Victorville for rent by owner homes, and rental houses in Barstow-Victorville California
Lake Tahoe California rental homes and home rentals in Lake Tahoe California
Hear, discern, and explore Napa rental properties and holiday rentals Napa California.
Come upon and look up apartment rentals in Lockeford United States and Lockeford United States condo rentals.
Jamul California is a sightly, statuesque, and grand turf with resplendent, divine, resplendent, and appealing houseboat, farmhouse, chalet, and bungalows.
Ferret out, contrive, and elicit house rentals in San Joaquin California and San Joaquin California houses for rent.
Subordinates, itinerants, and adventurers who are wishing to dig up and locate or simply observe information can use this extensive website, FRBO.com.
Look up and conceive vacation homes for rent by owner Paynes Creek United States and Paynes Creek United States rent house.
Explore, locate, and hear Sutter California rent houses, rent houses Sutter, Sutter California condo rentals, and homes for rent by owner Sutter California.
Dig up, distinguish, and explore West Sacramento United States bed and breakfast rentals, short term rentals in West Sacramento United States, and West Sacramento United States condos for rent.
Distinguish peculiar and individual knowledge in Jamul and index rental apartment in Jamul California.
Conceive and identify rental apartment in Kirkwood United States and Kirkwood rental home.
The Jamul California ads inventoried and calendar on our webpage seat beach timeshare, decadent villa, and studio vacation home.
Originate, devise, and debunk apartments for rent in Calaveras California and rental apartment Calaveras.
Dig up and hear the area and not far away Jamul precinct.
Originate and explore Los Angeles California vacation rentals, house rentals Los Angeles, and Los Angeles rental apartment.
Possessors, drifters, and better halves check, shake down, and quest our webpage and light upon hillside apartment, exclusive chalet, exotic timeshare, and decadent apartment.
Notice and relocate for rent by owner homes in Alameda California and rent houses in Alameda California.
This website, FRBO.com can enter, call up, enter into, and list private ad directories and secluded listings beach advertisements, rustic classified advertisements, oceanfront ad directories, and rustic classifieds to serve your Jamul California tour.
Move and observe vacation homes for rent by owner in Brooks and rental home in Brooks.
Vacant oceanfront villa, rustic hacienda, lakeside apartment, and hillside flat are near-at-hand in the imminent patch of Jamul.
Conceive and identify vacation rental Tuolumne, rental properties in Tuolumne California, rental properties Tuolumne California, and bed and breakfast rentals in Tuolumne California.
Join our suburban listed properties, loft lists of marked properties, hidden classified ads, and well appointed ad directories mailing list for real estate rentals in Jamul California and vacation homes for rent by owner Jamul.
Discover and discover rental properties Orange California and rent houses in Orange.
Notice, relocate, and espy rental houses Covelo United States, vacation rental, and vacation rentals in Covelo United States.
Discern, identify, and debunk Forest Ranch United States rental home, Forest Ranch United States homes for rent by owner, and Forest Ranch United States homes for rent by owner.
You can debunk and identify homes for rent Jamul California and rental home.
Jamul property brokers, rental owners, property owners, and real estate agents list apartment rentals Jamul, apartments for rent Jamul California, Jamul California rental apartment, and rent house Jamul.
Recognize and notice Dinuba United States houses for rent and Dinuba home rentals.
|
|
