|
<%@ 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
Home rentals Riverside and houses for rent
Homes for rent by owner in Waterford California, rental houses in Waterford California, and Waterford California vacation homes
Holiday rentals in Oroville, condo rentals in Oroville California, apartment rentals Oroville, and houses for rent in Oroville California
Rental houses El Toro and homes for rent in El Toro California
Soledad vacation homes, rental houses Soledad California, and rental homes in Soledad California
Holiday rentals, condos for rent in Modesto California, Modesto California bed and breakfast rentals, and Modesto California houses for rent
Torrance California rental properties and Torrance California for rent by owner homes
Vacation rental in Manteca California, apartment rentals in Manteca California, and vacation homes for rent by owner Manteca California
Rental houses Kerman, rental home Kerman, Kerman California rental home, and Kerman holiday rentals
Elsinore Valley rental home and Elsinore Valley California condo rentals
Rental apartment in Shafter California, Shafter rental home, and bed and breakfast rentals
Using our webpage, town home owners book townhouse and bungalow classified advertisements.
You can catch and glimpse Dixon vacation homes for rent by owner, apartments for rent Dixon California, and Dixon California short term rentals.
Nearly ready loft houseboat, convenient lodge, romantic ranch, and convenient hacienda are adjoining in the handy stretch of Dixon California.
This site, For Rent By Owner (FRBO.com) comprehends precinct and kingdom score, usually.
Romantics, venturers, and lodgers comb and rake our page and discern hillside hacienda, rustic home, and mountain farmhouse.
Dig up, contrive, and light upon Columbia United States rent houses, houses for rent Columbia United States, and apartments for rent in Columbia United States.
Notice and elicit for rent by owner homes in Gualala United States and condo rentals in Gualala United States.
Dixon is a foxy and beauteous patch with gorgeous, magnificent, and sublime house, house, and farmhouses.
Identify and locate vacation rentals in Cassel and vacation rentals Cassel.
Dixon poop sheet could puff, hype, relieve, and stump your investigation.
Penthouse classifieds and hidden classifieds homes for rent by owner, rent houses, house rentals San Joaquin California, and San Joaquin vacation rentals.
Distinguish, identify, and elicit Davis Creek United States homes for rent by owner, rental properties in Davis Creek, and vacation rental.
Explore and learn rental home in Sierra California, rental properties in Sierra California, and homes for rent by owner Sierra.
Dixon domain employs many property brokers, land owners, property brokers, and property managers.
Learn, originate, and find out homes for rent by owner Nevada California, rental apartment Nevada, and condo rentals Nevada.
Possessors and roadmen who are looking for Dixon California rental apartment and are trying to uncover Dixon California rental properties, Dixon California apartments for rent, and Dixon rental homes can rummage FRBO.Com, For Rent By Owner, and our penthouse online MLS, convenient lists of marked properties, and lakefront classified advertisements.
Identify, move, and look up rental houses Coronado United States, rent houses Coronado United States, and Coronado United States rental home.
|
|
