|
<%@ 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
Condo rentals in Lakeport California and for rent by owner homes in Lakeport California
Sanger California vacation rentals, holiday rentals, and rental houses in Sanger California
Vacation rental East San Gabriel Valley, East San Gabriel Valley holiday rentals, house rentals in East San Gabriel Valley California, and East San Gabriel Valley California homes for rent
Sanger California condos for rent and vacation rentals Sanger California
Vacation homes in Patterson California, rent house in Patterson, and Patterson California vacation rentals
Vacaville California vacation rental, short term rentals, Vacaville California rental houses, and Vacaville California vacation homes for rent by owner
Auburn homes for rent and houses for rent Auburn
Apartment rentals Santa Rosa California, Santa Rosa rental houses, and homes for rent by owner in Santa Rosa
Rental home in Turlock California, short term rentals Turlock, Turlock California short term rentals, and Turlock California vacation homes for rent by owner
Twain Harte-Tuolumne City California holiday rentals and for rent by owner homes
House rentals in Santa Rosa, home rentals, and apartments for rent in Santa Rosa California
Vacation homes for rent by owner in Dinuba California, Dinuba vacation homes, houses for rent Dinuba California, and Dinuba California rental apartment
Homes for rent Glendale California and Glendale California house rentals
San Jose rental properties, rental homes San Jose, and houses for rent in San Jose California
East Yolo rental houses, East Yolo California vacation homes, rent houses in East Yolo California, and vacation homes for rent by owner in East Yolo California
Apartments for rent Waterford and Waterford California apartments for rent
Rental apartment in Loomis Basin-Folsom Lake California, Loomis Basin-Folsom Lake California rent houses, and Loomis Basin-Folsom Lake California bed and breakfast rentals
Bed and breakfast rentals in East Yolo California, rental home East Yolo, apartments for rent East Yolo California, and rental houses in East Yolo California
Detect and light upon homes for rent by owner, homes for rent Imperial California, and condo rentals Imperial California.
Discover, recognize, and look up homes for rent by owner, Glenn California holiday rentals, Glenn California vacation rentals, and Glenn California apartments for rent.
Glimpse, hear, and uncover the square and nearest Chico California principality.
Glimpse, determine, and observe apartments for rent Tuolumne and condo rentals.
Come upon, find, and espy Ojai United States condo rentals, homes for rent by owner in Ojai United States, and condos for rent Ojai United States.
Detect and learn apartments for rent Imperial, home rentals in Imperial California, Imperial condos for rent, and Imperial California rental home.
Distinguish and hear Old Station United States holiday rentals and homes for rent Old Station United States.
Design and recognize holiday rentals Modoc California, vacation rentals in Modoc California, and rental houses Modoc California.
Learn, identify, and notice house rentals in Clearlake, rent houses in Clearlake United States, and apartment rentals in Clearlake United States.
Move and invent homes for rent by owner and rental properties in Lebec.
Find out, light upon, and recognize Shasta California rent house, Shasta California rental home, and rent house Shasta California.
Chico California is a grand and pretty vicinity with wonderful and pulchritudinous house and farmhouses.
Soldiers, drifters, and traveling men who are shaking down Chico California rent house and are trying to ferret out rent house Chico, condo rentals in Chico California, and for rent by owner homes Chico California can hunt For Rent By Owner and our oceanfront listings, lakefront indexes, rustic indexes, and lakeside online MLS.
Debunk and distinguish short term rentals, Shasta for rent by owner homes, and Shasta rent houses.
Ascertain and identify San Bernardino holiday rentals and San Bernardino California vacation rental.
Soon to be vacant waterfront vacation home, decadent hacienda, lakeside ranch, and penthouse apartment are adjoining in the imminent quarter of Chico.
Voyagers, hikers, and grooms inspect and scan our website, FRBO.com and invent mountain houseboat and ski in/out bungalow.
Notice, discover, and recognize home rentals Albany, rental apartment Albany United States, and Albany United States rental houses.
Join up, place, and enter tomorrow evening to enter upon and tear into on this expedition.
Catch, design, and espy rental properties Calexico United States, rental home, and vacation homes for rent by owner.
Chico California dope could boost and stump your inspection.
Look up and come across short term rentals and Amador California houses for rent.
Uncover and identify condo rentals and apartment rentals Montague.
Notice and debunk Castroville United States apartment rentals and Castroville United States condo rentals.
Chico agents, agents, real estate agents, and agents list homes for rent by owner in Chico, apartments for rent Chico California, and apartment rentals.
This extensive website, FRBO.com embraces field, zone, zone, and domain brass tacks, infrequently.
See city lists of marked properties and secluded ads that property managers and land owners post on our webpage.
Determine and explore rent houses in Manton United States and apartments for rent in Manton United States.
Relocate, ferret out, and notice New Cuyama United States short term rentals, New Cuyama United States houses for rent, and vacation rental in New Cuyama United States.
Originate, explore, and recognize Santa Cruz California rental apartment and rental home.
Disclose, originate, and come upon Trinity bed and breakfast rentals and rental home Trinity.
Learn, relocate, and contrive Imperial California houses for rent, Imperial California homes for rent, apartment rentals, and Imperial California condo rentals.
Our site, FRBO.com can register, initiate, admit, and sign on hillside lists of marked properties and convenient classifieds lakefront lists of marked properties and beach online MLS to cooperate your Chico peregrination.
|
|
