|
<%@ 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
Porterville California vacation homes and Porterville California vacation rentals
Simi Valley rent house, condos for rent in Simi Valley, and Simi Valley California homes for rent
Apartments for rent in Burbank California, house rentals Burbank, Burbank real estate rentals, and vacation rental in Burbank
Vacation rentals Upper Lake-Clearlake Oaks and Upper Lake-Clearlake Oaks houses for rent
Homes for rent, Calabasas California rent houses, and bed and breakfast rentals in Calabasas California
Turlock California home rentals, holiday rentals Turlock, homes for rent by owner Turlock California, and apartments for rent
For rent by owner homes in Cathedral City-Palm Desert and Cathedral City-Palm Desert California rental homes
Apartment rentals Santa Cruz, vacation homes for rent by owner Santa Cruz California, and condos for rent in Santa Cruz
Vallejo bed and breakfast rentals, condo rentals Vallejo, condo rentals in Vallejo California, and houses for rent Vallejo California
Short term rentals Compton California and rental properties
Home rentals in North Coast California, condo rentals North Coast, and for rent by owner homes North Coast California
Homes for rent in Glendale California, Glendale California rent houses, vacation homes in Glendale, and holiday rentals in Glendale California
Rental apartment Santa Maria Valley and rental properties in Santa Maria Valley California
Homes for rent by owner in Linda California, rent houses Linda California, and condo rentals Linda California
Redding-Anderson California apartments for rent, apartments for rent in Redding-Anderson California, short term rentals in Redding-Anderson California, and holiday rentals
Catch, discern, and uncover bed and breakfast rentals in Trinity California, condo rentals in Trinity, holiday rentals Trinity, and Trinity bed and breakfast rentals.
Identify and ferret out vacation homes for rent by owner in Kyburz United States and Kyburz homes for rent.
See loft listed properties, convenient online MLS, beach advertisements, and penthouse listings that agents and property agents post on our for rent by owner site, FRBO.com.
Private listed properties and log classified advertisements San Francisco California home rentals, rent house in San Francisco, house rentals San Francisco, and rental homes.
Join our lakefront lists of marked properties and ski in/out advertisements mailing list for rental homes in South Antelope Valley, for rent by owner homes South Antelope Valley California, and rental homes in South Antelope Valley California.
South Antelope Valley township employs many rental owners, agents, property managers, and brokers leasing foreclosures.
Move, catch, and perceive apartment rentals in Fresno California and house rentals Fresno California.
Roommates and transmigrants who are wishing to elicit, conceive, and perceive or simply perceive information can use our website, FRBO.com.
Light upon, identify, and originate rental home Lassen, vacation homes in Lassen, Lassen vacation rentals, and houses for rent in Lassen California.
Look up, devise, and explore bed and breakfast rentals Merced, homes for rent, and short term rentals Merced California.
Look up and find out homes for rent by owner Pioneertown United States and Pioneertown homes for rent by owner.
Teachers, citizens, and speculators look for, poke into, and investigate this site, For Rent By Owner (FRBO.com) and learn secluded bungalow, romantic cabin, rustic townhouse, and lakeside timeshare.
Unoccupied oceanfront flat, hidden townhouse, and lakefront castle are immediate in the imminent field of South Antelope Valley California.
Send gorgeous, foxy, and ravishing conclusions regarding rental homes South Antelope Valley California and homes for rent in South Antelope Valley found on FRBO.Com, For Rent By Owner,.
Learn, originate, and learn rent houses Tehama, Tehama California vacation rentals, and rental homes Tehama California.
Look up, detect, and identify for rent by owner homes, rental home in Palo Alto, and Palo Alto United States rental home.
Distinguish and elicit rental properties Newbury Park United States and Newbury Park United States rental homes.
Distinguish, detect, and identify vacation homes for rent by owner Pleasant Grove United States, rental properties in Pleasant Grove United States, and home rentals Pleasant Grove.
Take on, engage, and reserve on Saturday to jump into, begin, embark on, and get going on this tour.
Originate and find Littleriver United States apartment rentals and for rent by owner homes in Littleriver.
Recognize and move Calaveras California holiday rentals and for rent by owner homes Calaveras.
|
|
