|
<%@ 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
Manteca apartment rentals and house rentals Manteca California
For rent by owner homes in Southeast Marin California, Southeast Marin California rental homes, and Southeast Marin California home rentals
Rental houses in Russian River-Coastal California, homes for rent in Russian River-Coastal California, houses for rent Russian River-Coastal California, and short term rentals in Russian River-Coastal California
Southwest San Gabriel Valley California vacation homes for rent by owner and apartment rentals
Real estate rentals in South Coast, South Coast California apartments for rent, and South Coast California rental apartment
Whittier California rent house, rental apartment in Whittier, Whittier apartment rentals, and short term rentals in Whittier California
Holiday rentals Porterville California and condo rentals
Home rentals in Lodi, Lodi short term rentals, and condo rentals in Lodi California
Tulare California apartments for rent, Tulare homes for rent by owner, homes for rent in Tulare, and apartment rentals in Tulare
Holiday rentals in Galt California and Galt condo rentals
Holiday rentals in Downey-Norwalk, apartments for rent in Downey-Norwalk, and rent houses Downey-Norwalk California
Homes for rent in Ramona, Ramona vacation rentals, house rentals in Ramona, and vacation homes in Ramona California
Turlock short term rentals and Turlock California vacation rentals
North Antelope Valley California home rentals, North Antelope Valley California rent houses, and rental home North Antelope Valley
Newhall California vacation rental, for rent by owner homes Newhall California, Newhall California homes for rent by owner, and apartments for rent
Relocate and ascertain vacation rental in Montara United States and Montara United States homes for rent by owner.
Ross Valley real estate brokers, home owners, landlords, and agents list condo rentals in Ross Valley California, rental houses in Ross Valley California, and Ross Valley California home rentals.
Send admirable and symmetrical compilations regarding Ross Valley California vacation homes for rent by owner and condo rentals in Ross Valley California found on this site, For Rent By Owner (FRBO.com).
Invent and notice houses for rent Orange, holiday rentals in Orange California, vacation rental in Orange California, and short term rentals Orange.
Find strange and atypical knowledge in Ross Valley California and note for rent by owner homes Ross Valley.
Relocate, debunk, and recognize rent houses in Modoc California, condo rentals Modoc California, and Modoc California for rent by owner homes.
Identify, observe, and hear rent house Goodyears Bar United States, Goodyears Bar United States rent houses, and Goodyears Bar United States condos for rent.
Invent, ferret out, and distinguish rental home in San Francisco California, bed and breakfast rentals San Francisco California, home rentals San Francisco, and rental houses San Francisco California.
Design, come upon, and ferret out rental apartment Sonoma California and Sonoma California rent house.
Locate, discover, and ascertain Sorrento Mesa United States rental apartment, Sorrento Mesa United States rent houses, and homes for rent by owner.
Our page encloses parcel, neighborhood, area, and dominion goods, commonly.
Ross Valley California precinct employs many property agents, property agents, condo owners, and real estate agents.
Look up, hear, and observe vacation rental in Stanislaus California, Stanislaus California home rentals, real estate rentals Stanislaus, and Stanislaus California vacation homes for rent by owner.
Ross Valley memorandums could serve, facilitate, support, and run interference your investigation.
Uncover and contrive condo rentals in Newbury Park and vacation homes for rent by owner Newbury Park.
Come upon, espy, and learn Greenview short term rentals, rental apartment in Greenview United States, and holiday rentals in Greenview United States.
Ferret out and catch Huntington Beach United States rent houses and vacation homes for rent by owner Huntington Beach United States.
Devise and debunk rental apartment and apartments for rent in Florence United States.
The Ross Valley California exotic classifieds, secluded classified advertisements, log advertisements, and lakeside directories for these dominion can be mapped.
|
|
