|
<%@ 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
Chico California vacation rental and homes for rent by owner in Chico California
House rentals in Redding-Anderson, homes for rent in Redding-Anderson California, and vacation rental in Redding-Anderson
Russian River-Coastal California rent houses, real estate rentals in Russian River-Coastal California, Russian River-Coastal California rental properties, and vacation rentals in Russian River-Coastal California
Real estate rentals and vacation homes for rent by owner in Manteca California
Holiday rentals in Wasco California, holiday rentals Wasco California, and short term rentals in Wasco California
Houses for rent in Watsonville, Watsonville rental apartment, rental houses in Watsonville California, and Watsonville California apartment rentals
Vacation rentals and North El Dorado California rental apartment
Rent houses in Corona, Corona California apartments for rent, and rent house in Corona California
Homes for rent in Redding-Anderson California, holiday rentals Redding-Anderson, home rentals in Redding-Anderson, and for rent by owner homes in Redding-Anderson California
Placerville vacation homes and rent houses in Placerville California
Apartments for rent, apartment rentals Galt California, and home rentals in Galt California
Apartment rentals in Barstow-Victorville California, Barstow-Victorville rental apartment, Barstow-Victorville California rental apartment, and vacation rentals in Barstow-Victorville
Vacation rental Lake Isabella California and for rent by owner homes in Lake Isabella California
Vacation rentals Northeast Marin, for rent by owner homes Northeast Marin California, and short term rentals in Northeast Marin California
East Kern California rental home, vacation homes for rent by owner East Kern California, home rentals in East Kern California, and bed and breakfast rentals in East Kern California
Rental properties in Mather California and house rentals Mather California
Home rentals, rental homes in Ventura, and rental properties
Lemoore California vacation rental, Lemoore California home rentals, Lemoore apartments for rent, and rental home
Rental home in Vallejo and Vallejo California rent houses
Apartment rentals in Southeast California, real estate rentals Southeast California, and Southeast California vacation rental
Rental apartment in Redwood-Potter California, apartments for rent Redwood-Potter California, house rentals Redwood-Potter, and homes for rent in Redwood-Potter California
North Antelope Valley California homes for rent by owner and rent houses North Antelope Valley
Central Coast apartment rentals, condo rentals in Central Coast California, and for rent by owner homes
Los Angeles condos for rent, Los Angeles California homes for rent by owner, vacation homes Los Angeles, and rental properties in Los Angeles California
Homes for rent by owner in Atwater California and home rentals Atwater
For rent by owner homes in Arcata, short term rentals in Arcata, and Arcata houses for rent
Holiday rentals Upper San Gabriel Valley, Upper San Gabriel Valley California rent house, Upper San Gabriel Valley California bed and breakfast rentals, and house rentals in Upper San Gabriel Valley
Find, elicit, and detect Lincoln Acres United States vacation homes, vacation homes for rent by owner in Lincoln Acres United States, and rental apartment Lincoln Acres United States.
Come across, recognize, and determine short term rentals Mendocino, apartment rentals in Mendocino, Mendocino California vacation homes, and rental properties.
Espy and relocate condo rentals Imperial, vacation rental in Imperial California, homes for rent in Imperial, and Imperial California rental home.
Recognize and perceive Tuolumne rental houses, rental properties Tuolumne California, and Tuolumne rental apartment.
Identify, disclose, and notice homes for rent, home rentals in Terra Bella United States, and Terra Bella United States for rent by owner homes.
Dig up, move, and detect Groveland United States rent house, Groveland United States vacation homes, and homes for rent by owner in Groveland.
Camarillo property agents and property agents list Camarillo California rental home and homes for rent Camarillo.
Recurrently, ride shotgun, ballyhoo, and run interference your roommates and hikers to a hunk and adorable area.
Notice, invent, and find rental homes in Mountain Ranch, Mountain Ranch United States bed and breakfast rentals, and Mountain Ranch United States holiday rentals.
Ypsilanti Michigan apartment rentals, for rent by owner homes Ypsilanti Michigan, rental properties in Ypsilanti Michigan, and homes for rent Ypsilanti Michigan
Beach classified advertisements and well appointed classifieds houses for rent in Del Norte California, rental houses in Del Norte California, Del Norte California for rent by owner homes, and real estate rentals in Del Norte.
Design special, specialized, and other circumstances in Camarillo California and specialize Camarillo rental apartment.
Notice and identify Tulare homes for rent and Tulare California vacation homes for rent by owner.
Lead off your fishing expedition online on Thursday or this evening for your condos for rent in Camarillo, bed and breakfast rentals, and Camarillo California rental houses.
Floaters and lodgers who are wishing to explore and determine or simply uncover information can use FRBO.Com, For Rent By Owner,.
Come across, find out, and relocate vacation homes in Fresno California, condo rentals in Fresno, and Fresno California homes for rent by owner.
Ascertain and look up rent houses in San Luis Obispo California, San Luis Obispo California short term rentals, and apartments for rent.
Devise and invent vacation homes for rent by owner in Port Costa and Port Costa United States rent house.
Camarillo figures could work for, plug, help, and help your research.
Notice, notice, and discover houses for rent and rental homes in San Francisco California.
Our webpage excludes square, territory, area, and turf documents, periodically.
Disclose and espy Mariposa California home rentals and rental homes Mariposa.
Light upon and learn short term rentals in Wildomar United States and vacation homes for rent by owner in Wildomar.
Originate and identify house rentals Lake, vacation homes for rent by owner in Lake California, and Lake rental houses.
Husbands and roommates who are inspecting Camarillo rental houses and are trying to look up Camarillo California rent houses and vacation rental Camarillo California can ransack this site, For Rent By Owner (FRBO.com) and our secluded listings and resort lists of marked properties.
Discern and find Hanford United States for rent by owner homes and Hanford house rentals.
Espy and recognize Clipper Mills United States rental home and homes for rent in Clipper Mills United States.
Glimpse and perceive Squaw Valley rental houses and houses for rent.
Observe, identify, and ferret out rental houses in La Mesa United States, vacation homes La Mesa United States, and rental properties in La Mesa United States.
The Camarillo ad directories itemized and numerated on FRBO.Com, For Rent By Owner, involve romantic villa, ski in/out cabin, and private houseboat.
You can espy and come across Camarillo vacation homes for rent by owner, for rent by owner homes in Camarillo California, and house rentals Camarillo.
Apartment rentals Auburn California and Auburn California rent houses
Learn and relocate San Francisco California home rentals, San Francisco house rentals, San Francisco California holiday rentals, and San Francisco vacation homes for rent by owner.
|
|
