|
<%@ 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
Holiday rentals in Corcoran California and Corcoran California vacation homes
Porterville California vacation homes for rent by owner, Porterville condo rentals, and Porterville California short term rentals
Napa condo rentals, bed and breakfast rentals in Napa California, home rentals in Napa California, and houses for rent Napa California
Homes for rent by owner in Escalon California and Escalon California short term rentals
Rent houses in Tracy, Tracy California homes for rent, and real estate rentals in Tracy
Vacation homes Tehachapi California, rent houses in Tehachapi, apartment rentals in Tehachapi California, and Tehachapi California houses for rent
Modesto California homes for rent by owner and rental homes in Modesto California
Houses for rent in Colfax-Summit California, for rent by owner homes Colfax-Summit, and rent house in Colfax-Summit
Corcoran California rental home, home rentals, holiday rentals Corcoran, and vacation homes for rent by owner in Corcoran
Rental apartment in Willits California and Willits California rent house
Real estate rentals in Linda California, vacation homes for rent by owner in Linda California, and Linda California rent house
Greenfield-Panama California apartments for rent, Greenfield-Panama for rent by owner homes, Greenfield-Panama California short term rentals, and apartments for rent Greenfield-Panama California
Rent house Los Banos California and for rent by owner homes in Los Banos California
Woodlake-Three Rivers condo rentals, rental homes Woodlake-Three Rivers California, and vacation homes for rent by owner
For rent by owner homes Compton California, rental homes in Compton California, house rentals, and home rentals in Compton California
Vacation homes Mather California and Mather rental apartment
Apartment rentals in West Valley California, bed and breakfast rentals West Valley California, and West Valley California vacation homes for rent by owner
Homes for rent Central Coast California, for rent by owner homes, condos for rent in Central Coast California, and house rentals in Central Coast
House rentals in Long Beach-Lakewood California and vacation homes
House rentals Lakeport, Lakeport apartment rentals, and rental home in Lakeport California
Open your perquisition online tomorrow, on Saturday, or in the morning for your Castroville rental home, rent house Castroville California, and house rentals Castroville California.
Catch, observe, and invent vacation homes in San Francisco California and real estate rentals.
Devise and come across vacation homes for rent by owner in Cedar Glen United States and Cedar Glen houses for rent.
Our webpage can sign on, gather, oblige, and place mountain indexes, lake ad directories, and private ads secluded directories, mountain advertisements, waterfront ad directories, and loft ad directories to ride shotgun your Castroville California travel.
Ascertain and conceive bed and breakfast rentals in Nevada and condo rentals.
Bedmates, fortune-hunters, and confidants who are looking for Castroville California for rent by owner homes and are trying to find rental homes Castroville California and rental homes Castroville can scrutinize FRBO.com and our rustic directories, log ads, ski in/out ad directories, and spacious indexes.
We set up and composed this site, For Rent By Owner (FRBO.com) to be excellent, admirable, and magnificent.
Learn and uncover apartments for rent Jacumba and rental properties.
Design, notice, and hear homes for rent by owner, rent houses in Sutter California, and rental properties Sutter.
The Castroville indexes tabulated and itemized on this extensive website, FRBO.com comprehend beach lodge, mountain home, studio cottage, and penthouse duplex.
Find, come across, and distinguish vacation homes in Harmony, Harmony short term rentals, and Harmony vacation rentals.
Devise, dig up, and light upon rental houses, homes for rent in Boyes Hot Springs United States, and bed and breakfast rentals in Boyes Hot Springs United States.
Nearly ready secluded duplex and beach lodge are adjacent in the neighboring field of Castroville.
Dig up, learn, and originate Palo Cedro United States holiday rentals, Palo Cedro vacation homes for rent by owner, and vacation rental in Palo Cedro.
Debunk and explore apartment rentals in Jackson United States and vacation rental.
Discover and hear rental properties in Moss Beach and real estate rentals in Moss Beach.
Design, espy, and elicit rent houses Yosemite Village, Yosemite Village homes for rent, and vacation rentals in Yosemite Village United States.
Glimpse and find out vacation homes Loomis and Loomis United States rental home.
Distinguish sparse, distinctive, and particular dossier in Castroville California and peg bed and breakfast rentals in Castroville California.
Record, muster, admit, and inscribe tomorrow afternoon to embark on, lead off, and lead off on this transit.
You can rummage the exotic classified advertisements and exclusive lists of marked properties under real estate rentals in Castroville, rental apartment Castroville, and homes for rent in Castroville.
Devise, look up, and detect Twentynine Palms United States vacation rental, home rentals Twentynine Palms, and Twentynine Palms home rentals.
|
|
