|
<%@ 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
Sonora rental apartment and vacation homes
Petaluma for rent by owner homes, rental homes Petaluma California, and Petaluma California rent houses
Rental homes in Mendocino-Anderson California, house rentals in Mendocino-Anderson California, for rent by owner homes, and holiday rentals Mendocino-Anderson California
Angels City California bed and breakfast rentals and vacation rentals in Angels City California
Houses for rent Mariposa, rental houses Mariposa, and Mariposa apartment rentals
Rental homes in Anaheim-Santa Ana-Garden Grove California, Anaheim-Santa Ana-Garden Grove California houses for rent, Anaheim-Santa Ana-Garden Grove condos for rent, and vacation homes in Anaheim-Santa Ana-Garden Grove
House rentals in Central Shasta California and rental houses in Central Shasta
Rent houses, condos for rent, and real estate rentals in West Contra Costa
North Antelope Valley California holiday rentals, North Antelope Valley California rental home, North Antelope Valley California for rent by owner homes, and North Antelope Valley California rent houses
Houses for rent Sonora California and vacation homes for rent by owner in Sonora California
San Andreas California vacation homes, rental apartment San Andreas, and vacation rental in San Andreas California
Houses for rent, West Valley California rent houses, rent house in West Valley, and apartment rentals West Valley California
Central Shasta short term rentals and Central Shasta California apartments for rent
For rent by owner homes, West Valley California house rentals, and West Valley short term rentals
Rental houses, apartment rentals in West Point-Wilseyville California, home rentals, and rental homes West Point-Wilseyville California
Vacation homes for rent by owner in Arcata California and rental homes in Arcata California
Our webpage does subsume another suburban and hillside condominium, lodge, and castles.
Light upon, catch, and ascertain San Diego California rent houses and real estate rentals in San Diego California.
Locate, discern, and observe apartment rentals Tecate, rental apartment Tecate, and Tecate short term rentals.
The West Valley classified ads specified and tabbed on this extensive website, FRBO.com consist of beach timeshare, penthouse castle, spacious castle, and oceanfront hacienda.
Identify and disclose holiday rentals in Napa California, rental properties in Napa California, and Napa California rental home.
Using our website, FRBO.com, land owners post apartment, house, and duplex classified ads.
Locate and uncover rental homes Bridgeport United States and home rentals in Bridgeport.
You can discover, ferret out, and contrive West Valley California condos for rent and real estate rentals West Valley.
Originate, disclose, and debunk holiday rentals Siskiyou and rental apartment in Siskiyou California.
Traveling sales representatives, sailors, and confreres who are ransacking West Valley California houses for rent and are trying to originate rental houses in West Valley California and West Valley condos for rent can run down this site, For Rent By Owner (FRBO.com) and our mountain ad directories and decadent indexes.
West Valley California is a pulchritudinous, statuesque, delicate, and delightful principality with excellent, resplendent, and wonderful cottage, apartment, and homes.
West Valley California results could aid and puff your inquiry.
West Valley third party agents and rental agents list houses for rent in West Valley California, West Valley California condo rentals, vacation rentals West Valley California, and West Valley for rent by owner homes.
Identify and learn rental apartment Trabuco Canyon and rental home.
Discover, come upon, and detect rental home Alameda, rental homes, and for rent by owner homes Alameda.
Invent, come upon, and observe White Water United States homes for rent by owner, apartments for rent in White Water United States, and apartment rentals in White Water.
Find and relocate holiday rentals in Monterey California and Monterey California home rentals.
Uncover, perceive, and discern home rentals Badger United States, vacation homes for rent by owner in Badger United States, and Badger houses for rent.
Learn, conceive, and move Cottonwood United States vacation rentals, Cottonwood United States condo rentals, and Cottonwood vacation rentals.
Distinguish and discover Maxwell United States short term rentals and Maxwell United States apartment rentals.
Detect and elicit condos for rent in Lake Arrowhead and vacation rental in Lake Arrowhead United States.
Vacated well appointed houseboat, lake bungalow, ski in/out cottage, and beach condominium are not remote in the next parcel of West Valley.
We planned, generated, and imagined FRBO.com to be well-formed, taking, and grand.
Distinguish, glimpse, and find out vacation rental in Ventura, houses for rent in Ventura California, Ventura California apartments for rent, and houses for rent in Ventura California.
Locate, dig up, and contrive Ventura houses for rent, vacation homes in Ventura, and Ventura California apartment rentals.
|
|
