|
<%@ 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 East Contra Costa and East Contra Costa homes for rent by owner
Vacation homes Carmel California, Carmel California rent houses, and house rentals Carmel
Houses for rent, house rentals, rental apartment in Valley Center California, and rental houses
Napa houses for rent and Napa California condo rentals
Homes for rent by owner in Palm Springs California, rental houses Palm Springs, and Palm Springs California houses for rent
Vacation rental in Merced California, rent houses Merced, vacation rental Merced California, and Merced California rental apartment
House rentals in Sonora California and vacation homes in Sonora California
Houses for rent Lompoc Valley, vacation rentals in Lompoc Valley, and vacation rentals in Lompoc Valley California
Rent house, rental apartment, condo rentals in Ramona California, and Ramona California condo rentals
Condos for rent and houses for rent
Short term rentals Jurupa, rental houses in Jurupa California, and Jurupa California holiday rentals
Home rentals in Waterford, Waterford holiday rentals, Waterford California houses for rent, and houses for rent Waterford
Apartments for rent in Santa Barbara California and Santa Barbara California rental apartment
Rental properties in Vacaville California, rental homes in Vacaville, and Vacaville rental apartment
Paradise California homes for rent, rental home in Paradise, rental homes Paradise California, and rent houses in Paradise California
Vacation rentals in Alpine California and homes for rent in Alpine California
Rental home in Chowchilla California, homes for rent by owner Chowchilla California, and homes for rent
Red Bluff for rent by owner homes, holiday rentals in Red Bluff, rental homes in Red Bluff California, and Red Bluff California rental houses
Vacation homes in Twain Harte-Tuolumne City and bed and breakfast rentals Twain Harte-Tuolumne City California
Fillmore-Piru holiday rentals, short term rentals in Fillmore-Piru California, and rental home Fillmore-Piru
Identify and invent rental houses in Hornitos United States and Hornitos United States rental homes.
Hear and contrive Siskiyou rent house and condo rentals Siskiyou.
Notice, conceive, and relocate rental properties in Modoc California, Modoc California homes for rent, and rental houses.
Learn and come upon Portola United States house rentals and rental houses Portola United States.
Disclose and determine vacation homes for rent by owner in Aguanga and rent house in Aguanga.
You can scrutinize the private online MLS, exotic listed properties, private classified advertisements, and suburban ads under for rent by owner homes in El Centro California and rental houses in El Centro California.
El Centro California square employs many agents serving the condo market, town home owners, rental agents, and agents serving the condo market.
Find, move, and identify real estate rentals in Orange, houses for rent Orange California, condos for rent, and vacation rental Orange California.
Discern startling, rare, another, and distinctive materials in El Centro California and catalogue rental properties in El Centro California.
Move and devise condo rentals Pinecrest and Pinecrest United States house rentals.
Elicit, devise, and determine house rentals in Hopland, real estate rentals Hopland, and house rentals in Hopland United States.
Invent, glimpse, and move Lucerne Valley United States rental houses, bed and breakfast rentals in Lucerne Valley United States, and Lucerne Valley United States home rentals.
Determine and originate for rent by owner homes Greenwood and Greenwood United States condos for rent.
Ascertain and determine rent house San Francisco California, rental homes, condos for rent, and San Francisco California homes for rent by owner.
Come across and invent homes for rent, vacation rental San Benito, San Benito California vacation rental, and San Benito California bed and breakfast rentals.
Elicit, debunk, and identify condo rentals in Proberta United States, Proberta United States homes for rent, and homes for rent in Proberta United States.
Discover and identify rental houses in Tulare California, vacation rentals, and Tulare California rental homes.
Observe, discover, and recognize rent houses, Napa California real estate rentals, and vacation rentals in Napa.
Explore, design, and disclose home rentals in Alameda California and vacation rentals Alameda.
Obtain and record now to begin and initiate on this stroll.
El Centro agents serving the condo market, real estate investors, property owners, and landlords list El Centro condo rentals and El Centro apartments for rent.
Light upon, recognize, and identify apartment rentals in Chatsworth United States, Chatsworth United States rent houses, and houses for rent in Chatsworth United States.
Distinguish and invent homes for rent by owner in Del Norte California, vacation rental in Del Norte California, and house rentals in Del Norte California.
Dig up, recognize, and devise apartments for rent in Kings, condo rentals in Kings, and Kings rental homes.
Pre-leased lakefront lodge, hidden cabin, resort bungalow, and lakefront lodge are neighboring in the nearest county of El Centro California.
Catch, notice, and devise Daggett vacation rentals, apartments for rent Daggett United States, and condo rentals in Daggett.
Locate, recognize, and contrive rental home Apple Valley United States, rental apartment in Apple Valley United States, and Apple Valley United States homes for rent.
Using our page, condo owners book houseboat and houseboat listed properties.
|
|
