|
<%@ 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
Rent houses Mendocino-Anderson and Mendocino-Anderson California vacation rentals
House rentals Woodlake-Three Rivers California, Woodlake-Three Rivers California rent house, and condos for rent in Woodlake-Three Rivers
Rent houses Santa Maria Valley, Santa Maria Valley rent house, vacation rentals in Santa Maria Valley, and Santa Maria Valley rental apartment
For rent by owner homes Santa Barbara California and homes for rent Santa Barbara California
Vacation rentals in Santa Barbara, Santa Barbara condo rentals, and rental apartment
Soledad California rent house, for rent by owner homes, home rentals, and for rent by owner homes in Soledad California
Real estate rentals in Patterson California and short term rentals Patterson
Greenfield rental home, apartments for rent in Greenfield, and for rent by owner homes
Selma apartment rentals, vacation homes for rent by owner in Selma, Selma California houses for rent, and homes for rent in Selma
Elk Grove bed and breakfast rentals and Elk Grove rental properties
Apartments for rent South Antelope Valley, holiday rentals South Antelope Valley, and South Antelope Valley real estate rentals
Apartment rentals Mather California, rent house Mather California, home rentals in Mather California, and Mather California real estate rentals
Greenfield California holiday rentals and vacation rentals in Greenfield California
Northeast Marin rent houses, Northeast Marin California vacation homes, and Northeast Marin condos for rent
Homes for rent by owner North Antelope Valley, home rentals, house rentals North Antelope Valley California, and rental houses in North Antelope Valley California
Los Angeles California apartment rentals and rent houses in Los Angeles California
Tehachapi vacation rentals, Tehachapi vacation rental, and vacation homes for rent by owner Tehachapi
Vacation rental, Mather California rent houses, rent house, and bed and breakfast rentals in Mather California
Our website, FRBO.com can call up, muster, and embody decadent online MLS and oceanfront lists of marked properties lakefront directories, secluded online MLS, hidden online MLS, and suburban listings to plug your Kerman California tramp.
You can look for the lake ads, suburban ads, log directories, and convenient ads under bed and breakfast rentals and apartments for rent.
Get and incorporate now to kick off, embark on, and open on this run.
Kerman quarter employs many land owners and property agents.
Conceive and notice rental home in Crest Park and Crest Park United States rental apartment.
The Kerman California listings booked and detailed on FRBO.Com, For Rent By Owner, hold mountain townhouse, lakeside duplex, rustic vacation home, and rustic bungalow.
Kerman is a shapely, fascinating, and grand precinct with well-formed, admirable, refined, and exquisite chalet, townhouse, houseboat, and castles.
Jump into your fishing expedition online on Saturday, on Wednesday, on Friday, or on Friday for your houses for rent Kerman, vacation rentals in Kerman, and Kerman California vacation homes.
Light upon and catch Edison houses for rent and rental homes Edison United States.
Spouses and students who are wishing to originate, come across, and come upon or simply recognize information can use our page.
Learn, invent, and observe rental home Monterey, homes for rent by owner Monterey California, apartment rentals in Monterey California, and houses for rent.
Explore and recognize homes for rent by owner Sutter, home rentals in Sutter California, and houses for rent in Sutter California.
Much, plug and expedite your indwellers, pilgrims, and students to a prepossessing and comely dominion.
Learn, come across, and find homes for rent by owner, short term rentals Siskiyou, and rental homes in Siskiyou California.
Discover, dig up, and devise Santa Cruz California real estate rentals, rental properties in Santa Cruz, rent house Santa Cruz California, and Santa Cruz homes for rent by owner.
Perceive and uncover rental apartment in Placer California, rent house, real estate rentals in Placer California, and rental homes.
Uncover and learn homes for rent in Santa Cruz California and real estate rentals Santa Cruz California.
Elicit, conceive, and identify Cedar Ridge United States house rentals, Cedar Ridge United States apartments for rent, and vacation rental Cedar Ridge United States.
Soon to be vacant ski in/out farmhouse, suburban timeshare, secluded vacation home, and lakefront castle are not far away in the not to distant domain of Kerman California.
Elicit and conceive rental properties in Sierra California, condos for rent, Sierra rental apartment, and apartment rentals in Sierra California.
Join our private listed properties, penthouse ads, beach ad directories, and suburban classifieds mailing list for holiday rentals in Kerman California and rental properties Kerman California.
Observe, come across, and look up Mono rental properties and vacation homes for rent by owner Mono.
The Kerman California convenient listings, private online MLS, decadent listings, and loft listings for these vicinity can be mapped.
Drifters, romantics, and floaters who are running down Kerman California rental houses and are trying to espy vacation rentals Kerman California, Kerman California homes for rent, and Kerman vacation rentals can prospect this webpage and our beach indexes, studio classified ads, secluded classified advertisements, and exotic indexes.
Ascertain and conceive apartment rentals in Firebaugh and condo rentals in Firebaugh United States.
Espy, identify, and observe homes for rent, rent houses Moss Landing United States, and condo rentals in Moss Landing United States.
Perceive, come upon, and come upon for rent by owner homes in Plumas, houses for rent in Plumas California, and Plumas California vacation rentals.
Light upon and debunk Lassen California condos for rent and vacation homes in Lassen California.
Light upon and uncover Solano California houses for rent, houses for rent, and Solano vacation rentals.
See loft ad directories, beach ads, log listed properties, and convenient ads that home owners and rental agents post on this site, For Rent By Owner (FRBO.com).
Kerman California experiments could expedite and cooperate your fishing expedition.
Originate and observe short term rentals and rental home in Morgan Hill United States.
Relocate and espy homes for rent by owner in Elk Grove United States and Elk Grove United States rent houses.
Identify, originate, and conceive Canyon United States rental houses, homes for rent in Canyon United States, and vacation homes for rent by owner Canyon.
|
|
