|
<%@ 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
Santa Ynez Valley California house rentals and vacation homes for rent by owner Santa Ynez Valley California
Alpine California vacation rentals, condo rentals in Alpine California, and Alpine vacation rentals
Red Bluff vacation homes for rent by owner, Red Bluff house rentals, apartment rentals in Red Bluff, and house rentals in Red Bluff California
South El Dorado rental home and South El Dorado California vacation rentals
Thousand Oaks for rent by owner homes, homes for rent Thousand Oaks California, and real estate rentals in Thousand Oaks
Vacation homes in Waterford California, homes for rent, Waterford California condos for rent, and homes for rent by owner Waterford
Homes for rent in Cathedral City-Palm Desert and rental apartment in Cathedral City-Palm Desert California
San Luis Obispo short term rentals, rental houses in San Luis Obispo California, and vacation homes for rent by owner in San Luis Obispo
Hemet-San Jacinto apartment rentals, houses for rent Hemet-San Jacinto, Hemet-San Jacinto California home rentals, and for rent by owner homes in Hemet-San Jacinto
Holiday rentals in Hayward California and holiday rentals Hayward
Vacation homes, apartment rentals in Greenfield California, and rent house
Davis California bed and breakfast rentals, rental properties in Davis California, Davis California houses for rent, and rental home Davis California
Homes for rent Lemoore California and Lemoore holiday rentals
Rent house in Lemoore, homes for rent by owner in Lemoore California, and Lemoore California rent house
Vacation rentals in Napa California, rent houses Napa California, apartments for rent in Napa, and Napa California vacation homes
Rent house Newhall and Newhall apartments for rent
Homes for rent by owner in Earlimart, homes for rent by owner Earlimart California, and vacation rentals in Earlimart
Take up your inquest online on Monday or on Friday for your short term rentals in Twain Harte-Tuolumne City California and rent house Twain Harte-Tuolumne City California.
Join our exclusive indexes, city indexes, beach lists of marked properties, and exotic classified ads mailing list for vacation rentals in Twain Harte-Tuolumne City California and condo rentals Twain Harte-Tuolumne City.
Using our webpage, agents spell out townhouse, vacation home, cabin, and townhouse online MLS.
Design and locate homes for rent and rental houses in Tranquillity.
Twain Harte-Tuolumne City is a fascinating and ideal principality with marvelous and sublime lodge, vacation home, vacation home, and timeshares.
Recognize, catch, and discover house rentals Fellows, homes for rent by owner Fellows United States, and holiday rentals in Fellows United States.
Twain Harte-Tuolumne City town home owners, property brokers, and agents list holiday rentals and vacation rentals in Twain Harte-Tuolumne City California.
Ferret out and locate homes for rent by owner in Orange, rental properties Orange, Orange condos for rent, and rental houses in Orange California.
This site, For Rent By Owner (FRBO.com) can levy and conscribe well appointed classifieds, ski in/out lists of marked properties, loft listings, and hidden listings spacious advertisements, beach indexes, and private ad directories to push your Twain Harte-Tuolumne City California roaming.
Dig up, distinguish, and distinguish rental properties Glenn California, vacation homes in Glenn California, homes for rent in Glenn California, and home rentals Glenn.
The Twain Harte-Tuolumne City California listed properties billed and ticked off on our online website, FRBO.com arrange convenient lodge and resort bungalow.
Hear, ferret out, and identify North Palm Springs United States vacation rental, North Palm Springs United States short term rentals, and condo rentals.
Coeds and roamers who are investigating apartment rentals in Twain Harte-Tuolumne City California and are trying to elicit Twain Harte-Tuolumne City California condos for rent, Twain Harte-Tuolumne City California apartment rentals, and vacation homes in Twain Harte-Tuolumne City can probe FRBO.com and our decadent ads, rustic directories, resort directories, and lakefront directories.
The Twain Harte-Tuolumne City California exclusive listed properties, exclusive directories, and well appointed directories for these county can be mapped.
Ferret out and catch rental home, homes for rent Los Angeles California, and Los Angeles California apartment rentals.
FRBO.Com, For Rent By Owner, omits precinct, stretch, and principality poop sheet, habitually.
Design, catch, and find out Dixon United States condo rentals, holiday rentals in Dixon, and rental houses in Dixon United States.
Observe, originate, and relocate Soledad United States rental houses, Soledad United States rental homes, and holiday rentals Soledad.
Observe and recognize Amador City United States for rent by owner homes and rental properties in Amador City.
Notice and discern San Luis Obispo bed and breakfast rentals and real estate rentals in San Luis Obispo United States.
Relocate and notice vacation homes Madera, houses for rent in Madera, rent house Madera California, and vacation homes for rent by owner in Madera.
Determine, find out, and come across Alameda California rent houses and home rentals in Alameda California.
Glimpse and originate rental home in Callahan and Callahan United States short term rentals.
FRBO.com does consist of special territory lakeside, ski in/out, spacious, and private cottage, flat, villa, and ranchs.
Notice, distinguish, and learn Orange California houses for rent and rent house Orange California.
Find and locate vacation homes and houses for rent in Foresthill.
Boarders, locals, and cohorts who are wishing to learn, contrive, and elicit or simply move information can use this webpage.
Roommates, tourists, and floaters look for, check, and scrutinize our page and identify exotic flat, romantic hacienda, ski in/out cottage, and exclusive flat.
|
|
