|
<%@ 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 apartment in Sebastopol California and vacation rentals in Sebastopol
Mather bed and breakfast rentals, apartment rentals in Mather California, and Mather California apartments for rent
Houses for rent in Camarillo, rental homes in Camarillo, Camarillo California rental home, and Camarillo short term rentals
South Lake Tahoe homes for rent and rental home in South Lake Tahoe
Condo rentals Anaheim-Santa Ana-Garden Grove, Anaheim-Santa Ana-Garden Grove California home rentals, and Anaheim-Santa Ana-Garden Grove vacation rental
Houses for rent Salida, Salida California apartments for rent, Salida California apartments for rent, and rental homes Salida
House rentals in Paradise and holiday rentals in Paradise California
Condo rentals in Lower Lake-Middletown California, for rent by owner homes Lower Lake-Middletown California, and Lower Lake-Middletown apartments for rent
Apartment rentals, Sierra vacation rental, house rentals in Sierra, and condos for rent in Sierra California
Rental apartment Ripon California and rental apartment in Ripon California
Lemoore houses for rent, apartments for rent Lemoore, and Lemoore California holiday rentals
Rental home Upper San Gabriel Valley California, houses for rent, condos for rent in Upper San Gabriel Valley California, and vacation rental Upper San Gabriel Valley California
Rental home in South Lake Tahoe California and South Lake Tahoe California homes for rent by owner
Rental apartment South Coast, homes for rent by owner South Coast California, and South Coast California house rentals
Woodland California condo rentals, Woodland California short term rentals, holiday rentals in Woodland California, and vacation homes
Real estate rentals in Petaluma California and Petaluma California homes for rent by owner
Rent houses in Wasco California, Wasco homes for rent, and Wasco California homes for rent
Rosedale California rental homes, rent house in Rosedale California, for rent by owner homes, and Rosedale homes for rent by owner
Marysville California for rent by owner homes and houses for rent in Marysville California
Homes for rent in Orland California, for rent by owner homes Orland, and real estate rentals Orland
We dreamed up and established our for rent by owner website to be radiant and classy.
Ferret out, learn, and perceive houses for rent in San Joaquin California, real estate rentals in San Joaquin California, San Joaquin California vacation rental, and rental apartment in San Joaquin California.
Espy, explore, and ferret out Wishon home rentals, vacation homes in Wishon United States, and rent houses Wishon United States.
Vallejo area employs many brokers leasing foreclosures, real estate agents, land owners, and property brokers.
Contrive, devise, and disclose rent houses in Mono California, Mono California apartments for rent, and real estate rentals in Mono.
Discern and distinguish vacation homes Mendocino, vacation homes for rent by owner Mendocino California, and homes for rent by owner Mendocino.
Dig up, locate, and learn Solano California rent houses, Solano short term rentals, and Solano California condo rentals.
Vallejo California is a well-formed and divine tract with sublime, appealing, fascinating, and excellent bungalow, vacation home, and bungalows.
Catch and design vacation rental Wildomar United States and rent houses in Wildomar United States.
Our for rent by owner website does accommodate novel plot waterfront, beach, and private vacation home and haciendas.
Discover and ferret out vacation homes Sierra California, Sierra California apartments for rent, bed and breakfast rentals Sierra California, and apartments for rent Sierra.
Uncover, elicit, and devise Burlingame rental properties, holiday rentals, and condo rentals in Burlingame United States.
Learn and hear Soledad United States bed and breakfast rentals and Soledad vacation homes for rent by owner.
Discern, elicit, and notice vacation homes in Covina United States, short term rentals Covina United States, and rent house in Covina United States.
Invent and learn apartment rentals in Lancaster United States and holiday rentals in Lancaster United States.
Contrive, identify, and recognize vacation homes for rent by owner in Harbor City United States, condo rentals in Harbor City United States, and for rent by owner homes Harbor City.
Notice and conceive short term rentals in Monterey California and Monterey home rentals.
You can go through the decadent ads and resort listings under holiday rentals Vallejo California and homes for rent in Vallejo.
Catch and disclose Sonoma condo rentals and homes for rent Sonoma.
Professors, voyagers, and sightseers who are wishing to distinguish and light upon or simply discern information can use For Rent By Owner.
Induct and employ on Thursday to initiate, kick off, initiate, and lead off on this jaunt.
Look up and find out Dobbins United States rental properties and rental properties in Dobbins United States.
Distinguish and ferret out the principality and not to distant Vallejo California locality.
Discover, find, and learn vacation rental in Monterey and house rentals in Monterey California.
Distinguish and come upon short term rentals in Yuba, vacation rentals in Yuba California, Yuba California vacation homes for rent by owner, and rent houses in Yuba California.
Originate, disclose, and ferret out San Rafael United States bed and breakfast rentals, rental apartment San Rafael, and San Rafael United States homes for rent by owner.
|
|
