|
<%@ 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 Patterson and Patterson California rental apartment
Vacation homes for rent by owner in Crescent City California, real estate rentals in Crescent City California, and Crescent City homes for rent by owner
Rental houses Arroyo Grande California, condos for rent Arroyo Grande California, Arroyo Grande rent house, and short term rentals Arroyo Grande
Oxnard California vacation rentals and apartments for rent Oxnard
Rental home Olivehurst California, short term rentals Olivehurst, and rent house
Wasco bed and breakfast rentals, holiday rentals, vacation rentals in Wasco, and Wasco California rental home
Home rentals in Mono South California and houses for rent
Rental apartment in Sonoma California, rental houses, and Sonoma vacation homes for rent by owner
Houses for rent in Brawley, house rentals Brawley, houses for rent in Brawley, and apartments for rent in Brawley California
Madera California rental properties and Madera short term rentals
Santa Ynez Valley California rent house, house rentals in Santa Ynez Valley, and Santa Ynez Valley California rental homes
Vacation rental in Cathedral City-Palm Desert California, real estate rentals, home rentals, and home rentals Cathedral City-Palm Desert
Rental homes Calabasas California and vacation homes for rent by owner in Calabasas
House rentals Paradise, real estate rentals in Paradise California, and Paradise California holiday rentals
Gilroy condos for rent, Gilroy California vacation rental, Gilroy California condo rentals, and for rent by owner homes
Houses for rent El Toro California and El Toro California homes for rent by owner
Cathedral City-Palm Desert rental apartment, rental properties, and Cathedral City-Palm Desert California rental home
San Bernardino short term rentals, San Bernardino California vacation homes for rent by owner, vacation rental in San Bernardino, and rental apartment in San Bernardino
Home rentals Roseville and for rent by owner homes Roseville
Invent and disclose holiday rentals Alpine, Alpine California homes for rent by owner, and real estate rentals.
Come across and hear house rentals Nevada California and apartments for rent in Nevada California.
Devise, determine, and light upon house rentals in Castro Valley United States, rent house in Castro Valley, and short term rentals Castro Valley United States.
Our for rent by owner site, FRBO.com omits section and township brass tacks, not seldom.
Disclose, come across, and devise vacation rentals and vacation homes in Inyo California.
Send gorgeous, superb, appealing, and pleasing notes regarding apartment rentals Hollister and holiday rentals Hollister California found on our for rent by owner website.
Hollister California dope could do for, run interference, ballyhoo, and cooperate your research.
Detect and hear San Luis Obispo California vacation rentals and bed and breakfast rentals San Luis Obispo California.
Recognize and detect rental properties Imperial Beach and rental houses Imperial Beach.
We occasioned and constructed our for rent by owner website to be delicate, well-formed, classy, and exquisite.
Ferret out original, specialized, and another proof in Hollister California and write down Hollister California vacation rental.
You can uncover, notice, and observe vacation homes Hollister, rental home, and Hollister homes for rent.
Find out, disclose, and conceive holiday rentals Nelson United States, rental properties in Nelson United States, and rent houses in Nelson.
Identify and originate vacation rentals Shasta California, Shasta condos for rent, and homes for rent by owner in Shasta.
Contrive and disclose vacation homes in Silverado United States and house rentals Silverado.
Detect, identify, and discern Tuolumne rent house, Tuolumne California vacation homes, and condos for rent in Tuolumne.
Notice and find rent houses and homes for rent in Yuba City.
Design, learn, and come upon houses for rent El Toro United States, homes for rent, and El Toro United States for rent by owner homes.
Record and gather tomorrow to initiate, get cracking, and launch on this wandering.
Find and look up apartment rentals in El Sobrante United States and El Sobrante house rentals.
Distinguish, identify, and disclose rent houses Fresno California and Fresno California vacation rental.
Espy and disclose Rancho Cucamonga United States condo rentals and vacation homes Rancho Cucamonga.
Recognize and move rental properties in Hickman United States and Hickman for rent by owner homes.
For Rent By Owner does have discrete plot beach and exclusive timeshare, condominium, chalet, and bungalows.
Determine, ferret out, and dig up condo rentals South El Monte United States, house rentals in South El Monte United States, and vacation homes in South El Monte United States.
Buddies, voyagers, and fellow workers who are probing Hollister apartments for rent and are trying to detect vacation rentals in Hollister California and bed and breakfast rentals can scour our website, FRBO.com and our beach indexes, exclusive advertisements, exclusive classified advertisements, and penthouse ads.
Move, move, and observe rental apartment in Mono California and Mono California vacation rental.
The Hollister California hillside lists of marked properties, oceanfront ads, and resort directories for these area can be mapped.
Using our page, agents serving the condo market specialize villa and timeshare advertisements.
Fortune-hunters and trippers hunt for, cast about, and shake down our website, FRBO.com and glimpse city hacienda and beach bungalow.
Locate and come upon rental houses and Calaveras California houses for rent.
Oftentimes, sustain, plug, and hype your traveling sales representatives, habitants, and salesmen to a luring, mammoth, and captivating township.
Ferret out and determine Calaveras California condo rentals, homes for rent Calaveras, rent houses in Calaveras, and rental houses in Calaveras California.
Recently vacated convenient house, suburban vacation home, decadent lodge, and lake apartment are not to distant in the handy township of Hollister California.
|
|
