|
<%@ 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
Rental home Cloverdale-Geyserville and rental home Cloverdale-Geyserville
Rent houses in San Rafael California, San Rafael rental properties, and apartment rentals
Vacation rentals in Lompoc Valley, condos for rent Lompoc Valley California, vacation rentals Lompoc Valley California, and house rentals in Lompoc Valley California
Vacation rental Olivehurst and rental properties in Olivehurst California
Real estate rentals in Fremont, Fremont California vacation rentals, and rental houses in Fremont California
Real estate rentals, rental apartment in Galt California, rent houses in Galt California, and vacation homes for rent by owner
Rental houses Chuckwalla and Chuckwalla California vacation rentals
Colfax-Summit California homes for rent, vacation homes for rent by owner in Colfax-Summit California, and rental properties Colfax-Summit California
Rental apartment in San Jose California, condo rentals in San Jose California, apartment rentals in San Jose California, and condo rentals in San Jose California
Vacation homes Chuckwalla California and Chuckwalla California rental properties
Apartment rentals Berkeley California, vacation rentals Berkeley California, and Berkeley California condos for rent
San Andreas California apartment rentals, San Andreas vacation homes for rent by owner, San Andreas California for rent by owner homes, and San Andreas California homes for rent
Rental properties in Paso Robles and Paso Robles California houses for rent
Desert Hot Springs California apartments for rent, apartments for rent in Desert Hot Springs, and vacation rentals Desert Hot Springs California
Homes for rent by owner in Dinuba California, condo rentals, vacation homes for rent by owner in Dinuba California, and Dinuba California rental homes
Livingston-Delhi California rent houses and rent houses Livingston-Delhi
Home rentals in Loomis Basin-Folsom Lake California, apartment rentals in Loomis Basin-Folsom Lake California, and bed and breakfast rentals
San Bernardino California real estate rentals, rental homes San Bernardino, condo rentals, and San Bernardino house rentals
Glimpse, come upon, and discern vacation rental in Riverside California, for rent by owner homes Riverside, vacation homes, and real estate rentals in Riverside.
Light upon and uncover Phelan United States holiday rentals and rental homes in Phelan.
Discover and explore Talmage rental apartment and rental houses Talmage.
The West Contra Costa ad directories buttoned down and buttoned down on this site, For Rent By Owner (FRBO.com) involve beach townhouse, hidden hacienda, beach home, and beachfront farmhouse.
Using FRBO.Com, For Rent By Owner,, real estate agents insert flat, cottage, lodge, and chalet listed properties.
Notice and find out rental homes Glenn, Glenn California apartments for rent, holiday rentals Glenn, and condo rentals in Glenn.
Invent, come across, and disclose rental houses in San Mateo California, San Mateo house rentals, rent houses, and vacation homes for rent by owner in San Mateo California.
Hear and come across for rent by owner homes in Lake California and Lake apartment rentals.
Private online MLS and penthouse online MLS El Dorado California apartment rentals, rental houses in El Dorado California, El Dorado California houses for rent, and rental homes in El Dorado California.
You can discern and hear West Contra Costa California rental home and rental properties.
Ascertain, invent, and come upon Glendale house rentals, rent house, and rental houses Glendale.
Notice and learn Del Norte California vacation homes and real estate rentals Del Norte California.
Perceive, identify, and observe apartments for rent Santa Clara and rental home Santa Clara California.
You can prospect the lakeside directories and exotic listed properties under West Contra Costa rental houses, condo rentals in West Contra Costa California, and rent house in West Contra Costa California.
Peers and habitants forage and scout our site, FRBO.com and discover studio flat and spacious townhouse.
Determine and locate home rentals in Modoc California, vacation homes for rent by owner in Modoc California, and home rentals Modoc.
Send splendid, beauteous, and dazzling measurements regarding rent houses West Contra Costa, home rentals in West Contra Costa, and West Contra Costa rental homes found on our for rent by owner site, FRBO.com.
This site, For Rent By Owner (FRBO.com) does enclose another quarter hillside, suburban, and ski in/out house, vacation home, condominium, and chalets.
Dig up and devise holiday rentals Modoc, for rent by owner homes in Modoc California, and house rentals in Modoc.
Relocate, locate, and locate apartments for rent in Del Norte California and Del Norte California for rent by owner homes.
Locate, move, and ascertain Glenn California short term rentals, rental houses, and homes for rent by owner in Glenn California.
Find out, espy, and come upon rental homes, Lake California rental apartment, and Lake California house rentals.
Travelers, jet-setters, and habitants who are wishing to discern, ferret out, and contrive or simply come upon information can use FRBO.com.
|
|
