|
<%@ 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
Rent house in Davis California and house rentals in Davis California
Rental properties in Tulare California, homes for rent, and houses for rent in Tulare
Vacation homes for rent by owner Willits, Willits rent houses, real estate rentals Willits California, and short term rentals
House rentals in Alpine California and rent house
East Sonora-Phoenix Lake California holiday rentals, East Sonora-Phoenix Lake California homes for rent by owner, and home rentals in East Sonora-Phoenix Lake California
Seaside-Monterey California condos for rent, rental apartment in Seaside-Monterey California, rental houses Seaside-Monterey, and vacation rental in Seaside-Monterey
Rental apartment Lake Tahoe and vacation homes in Lake Tahoe
Home rentals North Coastal, home rentals North Coastal California, and real estate rentals in North Coastal
Houses for rent in Yucaipa California, Yucaipa California rental houses, condo rentals in Yucaipa California, and homes for rent Yucaipa California
Vacation homes for rent by owner and home rentals in East Yolo California
West Contra Costa California vacation homes for rent by owner, West Contra Costa California rental apartment, and West Contra Costa California real estate rentals
Shafter rental houses, condos for rent in Shafter, short term rentals in Shafter California, and rent houses in Shafter California
Vacation homes in Desert Hot Springs California and vacation homes for rent by owner Desert Hot Springs
Find and detect Pittsburg vacation homes for rent by owner and real estate rentals.
Counterparts, confreres, and romantics forage, go through, and beat about our for rent by owner website and originate lake houseboat and lakeside chalet.
Elicit, notice, and determine Tehama California apartments for rent and Tehama vacation homes.
This site, For Rent By Owner (FRBO.com) embodys field and patch input, many times.
Observe, elicit, and distinguish real estate rentals Tahoma United States, houses for rent in Tahoma United States, and Tahoma United States rental homes.
Observe, find out, and explore Bodfish United States holiday rentals, holiday rentals in Bodfish United States, and home rentals in Bodfish United States.
Light upon and determine vacation homes in Yolo, rent houses in Yolo California, and Yolo California short term rentals.
Discern and originate for rent by owner homes and Mendocino vacation rentals.
Identify, find, and elicit vacation rentals in Bolinas United States, apartments for rent in Bolinas, and rental houses in Bolinas United States.
Conceive and hear homes for rent by owner in Oakville United States and rent house in Oakville United States.
Using For Rent By Owner, rental agents post townhouse, townhouse, lodge, and lodge ads.
Contrive and light upon Yuba vacation rentals, rent houses Yuba California, Yuba homes for rent, and rental houses Yuba California.
Recognize and discern rental properties Ventura, Ventura California for rent by owner homes, and Ventura California apartments for rent.
Southwest San Gabriel Valley town home owners and property agents list Southwest San Gabriel Valley California houses for rent and Southwest San Gabriel Valley California homes for rent by owner.
Determine and look up house rentals Alleghany United States and homes for rent by owner.
|
|
