|
<%@ 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
Sonoma California vacation homes for rent by owner and Sonoma California vacation homes
Short term rentals in Angels City California, Angels City California rental homes, and rental apartment Angels City
Rental home East Yolo California, house rentals in East Yolo, East Yolo California homes for rent by owner, and apartments for rent in East Yolo California
Condo rentals East Sonora-Phoenix Lake and rent houses in East Sonora-Phoenix Lake California
Rental properties Fresno California, Fresno houses for rent, and real estate rentals
Apartments for rent in Ramona California, rental home in Ramona California, home rentals, and Ramona vacation homes
Marysville California for rent by owner homes and vacation rentals in Marysville California
Wasco California bed and breakfast rentals, homes for rent in Wasco California, and Wasco California apartments for rent
Pasadena California home rentals, holiday rentals in Pasadena California, vacation homes in Pasadena California, and short term rentals Pasadena
Bed and breakfast rentals in San Francisco California and San Francisco California home rentals
Rental properties in Porterville California, vacation homes for rent by owner Porterville California, and houses for rent Porterville
Folsom California vacation rentals, condos for rent, homes for rent in Folsom California, and short term rentals in Folsom California
South Lake Tahoe California tract employs many real estate investors, condo owners, land owners, and rental agents.
Disclose and come upon Montclair United States rent house and Montclair United States rental properties.
Find out and devise bed and breakfast rentals, home rentals San Francisco California, and San Francisco California vacation homes.
Nearly ready penthouse hacienda and spacious condominium are impending in the adjacent dominion of South Lake Tahoe.
Disclose, discern, and determine the territory and nearest South Lake Tahoe California block.
Conceive, contrive, and discern Arcata United States apartments for rent, rental apartment Arcata, and home rentals Arcata.
Elicit, detect, and design rental homes in Heber United States, rent houses Heber United States, and apartment rentals.
The South Lake Tahoe California lists of marked properties detailed and particularized on For Rent By Owner take in log house and spacious home.
The South Lake Tahoe California beach listed properties, exclusive classified advertisements, lakefront indexes, and penthouse indexes for these territory can be mapped.
Buddies, itinerants, and globetrotters scrutinize, rummage, and scrutinize our page and locate beachfront villa, decadent flat, suburban timeshare, and convenient timeshare.
Look up and distinguish Patton vacation homes and rent houses in Patton.
Determine and relocate homes for rent in Salinas United States and vacation homes Salinas United States.
Notice and dig up Ivanhoe United States rental houses and Ivanhoe condo rentals.
Notice, discern, and hear vacation rentals in Santa Ana, Santa Ana homes for rent, and home rentals Santa Ana.
South Lake Tahoe brokers leasing foreclosures and rental agents list vacation homes for rent by owner South Lake Tahoe California and South Lake Tahoe California for rent by owner homes.
Identify and elicit homes for rent Lake California and Lake California holiday rentals.
Uncover, devise, and relocate Alameda California house rentals and bed and breakfast rentals in Alameda California.
Relocate and recognize condos for rent in Imperial, short term rentals, and vacation rentals in Imperial.
You can observe and espy South Lake Tahoe homes for rent and South Lake Tahoe California short term rentals.
Join our lakefront listings, mountain ad directories, and city directories mailing list for houses for rent in South Lake Tahoe California, rent houses in South Lake Tahoe, and house rentals in South Lake Tahoe California.
Explore and glimpse bed and breakfast rentals Castro Valley and homes for rent by owner in Castro Valley United States.
Conceive, catch, and learn holiday rentals Imperial California, Imperial California apartments for rent, rental homes, and rental houses.
Debunk, recognize, and distinguish home rentals in San Francisco, apartments for rent in San Francisco California, and vacation homes San Francisco California.
Move, originate, and originate Stevenson Ranch United States vacation rental, Stevenson Ranch United States rental apartment, and houses for rent in Stevenson Ranch.
Dig up, originate, and discover Mc Farland United States houses for rent, Mc Farland United States apartments for rent, and Mc Farland United States apartments for rent.
|
|
