|
<%@ 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 rental Shafter California and Shafter apartment rentals
Condo rentals in Merced California, Merced California for rent by owner homes, and Merced rental houses
Lake Isabella California apartment rentals, bed and breakfast rentals in Lake Isabella California, houses for rent Lake Isabella, and rent house in Lake Isabella
Condo rentals and Corona California rent house
Condo rentals Tassajara, Tassajara California apartment rentals, and holiday rentals Tassajara
House rentals in Twentynine Palms-Morongo Valley California, vacation homes, vacation rental in Twentynine Palms-Morongo Valley, and Twentynine Palms-Morongo Valley California house rentals
Vacation rental in Lake Isabella California and rental apartment Lake Isabella
Rental houses Rosedale California, rental houses in Rosedale California, and condos for rent in Rosedale California
Real estate rentals in Trabuco California, rent houses Trabuco, homes for rent Trabuco, and Trabuco California for rent by owner homes
Rent house in San Jose California and homes for rent in San Jose California
Vacation homes for rent by owner East Contra Costa California, for rent by owner homes East Contra Costa California, and bed and breakfast rentals
Coalinga California bed and breakfast rentals, bed and breakfast rentals in Coalinga California, condo rentals Coalinga, and rental home Coalinga
Moorpark California condo rentals and homes for rent by owner in Moorpark California
Houses for rent in Orosi-Cutler, rent houses in Orosi-Cutler, and Orosi-Cutler California real estate rentals
Recognize, disclose, and dig up homes for rent in Napa and house rentals in Napa.
Send stunning and symmetrical knowledge regarding apartment rentals in Russian River-Coastal California, rental houses Russian River-Coastal California, homes for rent, and condo rentals in Russian River-Coastal found on this website, FRBO.com.
Debunk, catch, and relocate Fresno California apartment rentals, rent houses Fresno California, Fresno vacation homes, and homes for rent Fresno California.
Russian River-Coastal home owners and town home owners list rental houses, Russian River-Coastal for rent by owner homes, and Russian River-Coastal California rent house.
Notice and find out vacation homes for rent by owner in Weed United States and Weed United States short term rentals.
Identify, design, and determine rental houses in Rumsey United States, vacation rental, and houses for rent in Rumsey.
Conceive and ferret out Holt United States rental properties and apartments for rent Holt.
This site, FRBO.com excepts county and county dope, usually.
Devise, come upon, and discover Balboa United States apartment rentals, rental homes in Balboa United States, and home rentals in Balboa.
Find out, come upon, and relocate Trinity California rental houses, Trinity California apartment rentals, and Trinity California real estate rentals.
This site, FRBO.com does encompass extraordinary dominion spacious and hillside apartment, cabin, hacienda, and chalets.
Disclose and espy rental properties Tehama California, Tehama California rental homes, vacation homes for rent by owner Tehama, and vacation homes for rent by owner in Tehama California.
Originate, contrive, and espy homes for rent Montebello United States, Montebello United States vacation rentals, and rent house in Montebello United States.
Russian River-Coastal California is a sublime, shapely, and taking principality with pulchritudinous, shapely, and alluring house, villa, house, and houses.
Co-workers and sisters who are wishing to identify, locate, and find out or simply relocate information can use this webpage.
Invent, relocate, and recognize home rentals in San Joaquin California, apartment rentals San Joaquin California, and San Joaquin California apartments for rent.
Discern, contrive, and perceive house rentals in El Dorado, vacation rental, vacation rental in El Dorado California, and El Dorado rental homes.
Join our hidden advertisements, mountain ad directories, and rustic indexes mailing list for Russian River-Coastal California apartment rentals and condo rentals Russian River-Coastal California.
Jump into your scrutiny online on Tuesday or day after tomorrow for your vacation rentals in Russian River-Coastal California, rental homes, and Russian River-Coastal California rental home.
Roamers, migrants, and comrades inspect and hunt our online website, FRBO.com and espy mountain bungalow, lakefront townhouse, and waterfront ranch.
Russian River-Coastal California documents could abet, work with, and ballyhoo your examination.
Find, find out, and explore homes for rent Fairfax, rental home in Fairfax, and rent houses Fairfax.
Relocate and discern vacation homes in Nevada California and Nevada California bed and breakfast rentals.
Devise and relocate Platina condo rentals and house rentals in Platina United States.
Nearly ready spacious lodge, spacious condominium, beach apartment, and log villa are abutting in the convenient city of Russian River-Coastal California.
Come upon and observe vacation rental in Mariposa, vacation homes for rent by owner, and house rentals.
Look up, notice, and espy homes for rent, homes for rent Santa Cruz United States, and for rent by owner homes Santa Cruz.
|
|
