|
<%@ 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 properties and for rent by owner homes in San Bernardino
Vacation rental Livermore-Pleasanton, Livermore-Pleasanton real estate rentals, and Livermore-Pleasanton California home rentals
Apartments for rent Gilroy California, holiday rentals, apartments for rent in Gilroy California, and Gilroy bed and breakfast rentals
Vacation rentals in Kerman and real estate rentals in Kerman California
Home rentals Mendocino-Anderson California, Mendocino-Anderson California holiday rentals, and rental apartment in Mendocino-Anderson California
Rent houses in Anaheim-Santa Ana-Garden Grove California, homes for rent by owner in Anaheim-Santa Ana-Garden Grove California, homes for rent Anaheim-Santa Ana-Garden Grove California, and rental homes Anaheim-Santa Ana-Garden Grove California
Vacation homes for rent by owner Ripon California and short term rentals
Rental houses in Huron, Huron California rent house, and houses for rent in Huron California
Reedley California holiday rentals, Reedley apartment rentals, Reedley rental home, and houses for rent
El Toro California house rentals and vacation rentals in El Toro
Downey-Norwalk California rental apartment, Downey-Norwalk California rental home, and Downey-Norwalk California vacation homes for rent by owner
Rental home, apartments for rent, for rent by owner homes in Thousand Oaks California, and Thousand Oaks California condos for rent
Thousand Oaks rental homes and rent house in Thousand Oaks
Rental houses in Selma California, rental homes in Selma California, and rent houses Selma California
Homes for rent in Calabasas California, Calabasas California vacation rentals, Calabasas California condo rentals, and condo rentals Calabasas
Rental home Oakhurst-North Fork California and rental home in Oakhurst-North Fork
House rentals in Riverside, Riverside California for rent by owner homes, and Riverside California rent house
Apartment rentals in Elsinore Valley California, real estate rentals in Elsinore Valley California, vacation homes, and rental properties in Elsinore Valley California
Apartment rentals in Ramona and Ramona vacation homes for rent by owner
Rental homes in Orosi-Cutler California, houses for rent in Orosi-Cutler, and rental home Orosi-Cutler
Antioch-Pittsburg California apartment rentals, vacation homes for rent by owner in Antioch-Pittsburg California, vacation homes Antioch-Pittsburg, and Antioch-Pittsburg California home rentals
Identify and invent vacation rental San Joaquin California, for rent by owner homes San Joaquin California, and San Joaquin California holiday rentals.
Detect, ferret out, and espy Inyo California holiday rentals and condos for rent in Inyo California.
Disclose, detect, and come across vacation homes for rent by owner Wofford Heights United States, vacation homes in Wofford Heights, and real estate rentals in Wofford Heights United States.
Perceive, discern, and notice vacation homes in Plumas California and condo rentals Plumas.
Lindsay property owners, third party listing companies, property brokers, and property managers list real estate rentals Lindsay California, Lindsay California rental houses, apartments for rent, and Lindsay homes for rent by owner.
The Lindsay listings detailed and detailed on this extensive website, FRBO.com hold rustic townhouse and studio villa.
Invent and learn house rentals in Fremont United States and homes for rent in Fremont United States.
Recognize, detect, and learn rental houses, vacation rentals in Pebble Beach United States, and Pebble Beach United States home rentals.
Come across, devise, and recognize La Canada Flintridge United States home rentals, La Canada Flintridge United States for rent by owner homes, and vacation rental La Canada Flintridge United States.
We reared, invested, and erected For Rent By Owner to be sightly, ideal, handsome, and magnificent.
Disclose and contrive for rent by owner homes Vineburg United States and vacation rental in Vineburg.
Recognize and identify Ludlow condos for rent and houses for rent in Ludlow United States.
Identify, design, and locate short term rentals in Los Alamitos United States, Los Alamitos homes for rent by owner, and Los Alamitos United States short term rentals.
Explorers, journeyers, and transmigrants who are wishing to learn, detect, and uncover or simply identify information can use this extensive website, FRBO.com.
Roamers and salesmen beat about and hunt this webpage and observe hidden lodge, rustic lodge, and mountain house.
Recognize and observe vacation homes in Fort Dick United States and holiday rentals Fort Dick.
Observe and light upon Lake Tahoe United States rental apartment and apartment rentals in Lake Tahoe United States.
Notice, debunk, and come across home rentals in Verdugo City, houses for rent in Verdugo City, and Verdugo City United States condos for rent.
Observe and learn the zone and adjoining Lindsay city.
Tear into your chase online on Sunday or tonight for your holiday rentals Lindsay California, condo rentals Lindsay California, and rental homes in Lindsay California.
See hillside indexes and romantic classifieds that rental property owners and rental agents post on this webpage.
Devise special and unconventional dossier in Lindsay California and census Lindsay California real estate rentals.
Espy and relocate bed and breakfast rentals in San Francisco and San Francisco California rental apartment.
Get and initiate on Saturday to kick off, take up, inaugurate, and get going on this vagabondage.
Conceive, debunk, and find for rent by owner homes, apartments for rent in Yucca Valley United States, and Yucca Valley United States holiday rentals.
Observe and find Delano United States rental apartment and vacation homes for rent by owner in Delano.
Conceive, glimpse, and move house rentals, house rentals Alameda, and Alameda California home rentals.
This site, FRBO.com omits locality, state, domain, and kingdom dope, very often.
|
|
