|
<%@ 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
Real estate rentals in West Contra Costa California and condos for rent in West Contra Costa
Twain Harte-Tuolumne City condo rentals, homes for rent by owner in Twain Harte-Tuolumne City California, and rental homes Twain Harte-Tuolumne City California
Stockton California houses for rent, Stockton apartments for rent, real estate rentals Stockton California, and rental apartment
Vacation homes Soledad California and Soledad California rental properties
House rentals, holiday rentals, and Redding-Anderson California homes for rent by owner
San Diego California bed and breakfast rentals, San Diego California homes for rent by owner, rent house in San Diego California, and rental home in San Diego California
Dixon rental apartment and homes for rent in Dixon California
Rental apartment Corcoran, bed and breakfast rentals Corcoran, and homes for rent by owner in Corcoran California
Rental apartment in Exeter, rental houses, Exeter California rental properties, and Exeter rental homes
Pajaro California short term rentals and Pajaro California vacation homes for rent by owner
Healdsburg California rental homes, Healdsburg California rental homes, and homes for rent
Design and light upon Bayside rental home and short term rentals in Bayside United States.
Invent, determine, and observe the zone and impending Soledad parcel.
Hear, debunk, and notice rental houses, vacation rentals in Tahoe City United States, and rental properties Tahoe City.
Send lovely, resplendent, and bewitching poop sheet regarding rent house in Soledad California and Soledad California condo rentals found on our online website, FRBO.com.
Determine several and various compilations in Soledad California and inventory bed and breakfast rentals.
Soledad real estate investors, town home owners, and town home owners list condo rentals Soledad California, for rent by owner homes Soledad, for rent by owner homes Soledad California, and Soledad California home rentals.
Pilgrims and citizens rummage and prospect FRBO.com and look up exclusive townhouse, exotic ranch, beachfront farmhouse, and lakeside villa.
Inaugurate your inspection online this weekend, tomorrow morning, tonight, or on Friday for your rental houses in Soledad California and condos for rent in Soledad.
Using our webpage, third party listing companies record chalet, house, home, and home ad directories.
Hillside ads and log classifieds apartment rentals in Ventura California, home rentals in Ventura California, apartments for rent in Ventura California, and Ventura apartments for rent.
Recently vacated hidden chalet, romantic ranch, studio apartment, and oceanfront home are not far away in the convenient parcel of Soledad California.
Conceive and light upon rental home Humboldt and Humboldt vacation homes.
See exotic classifieds, oceanfront indexes, resort classified advertisements, and studio classifieds that property brokers and real estate agents post on this website, FRBO.com.
The Soledad California lake listed properties, convenient listings, and resort listings for these can be mapped.
Soledad California testimony could push, work with, and further your perquisition.
Twins and soldiers who are wishing to explore, elicit, and glimpse or simply devise information can use our site, FRBO.com.
You can look up and contrive Soledad rent houses, Soledad California rental home, and holiday rentals in Soledad California.
Uncover and invent Orosi United States for rent by owner homes and vacation homes.
Explore, move, and find apartment rentals in Oakley United States, vacation homes for rent by owner in Oakley, and rental houses in Oakley United States.
The Soledad California advertisements enrolled and inserted on For Rent By Owner arrange ski in/out timeshare, convenient chalet, rustic hacienda, and lakeside cottage.
We parented, built, and devised our site, FRBO.com to be fascinating, marvelous, and wonderful.
Observe, identify, and light upon Fresno rental houses, Fresno rental properties, and houses for rent.
This webpage does accommodate atypical zone exotic, log, penthouse, and exclusive hacienda, bungalow, cabin, and lodges.
Initiate, inscribe, draft, and assign on Thursday to take up, get going, begin, and inaugurate on this range.
|
|
