|
<%@ 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
Cloverdale-Geyserville rental houses and rental homes in Cloverdale-Geyserville
Gilroy California condos for rent, rental homes in Gilroy California, and rental homes in Gilroy
House rentals Eureka, apartment rentals Eureka California, Eureka homes for rent by owner, and Eureka vacation homes
Calabasas California rent houses and Calabasas California condo rentals
Newhall rent houses, apartments for rent, and rent house in Newhall California
Stockton California rental houses, homes for rent by owner in Stockton California, apartment rentals in Stockton California, and vacation homes for rent by owner Stockton California
Rent house in Sonoma California and houses for rent in Sonoma California
Vacation homes for rent by owner El Centro California, rental properties in El Centro, and El Centro California rental apartment
Susanville California home rentals, condos for rent, homes for rent by owner Susanville California, and Susanville California rental apartment
Westside homes for rent by owner and short term rentals Westside California
Rental homes in Oakhurst-North Fork, bed and breakfast rentals in Oakhurst-North Fork California, and Oakhurst-North Fork California homes for rent by owner
Rental homes in Lindsay, houses for rent in Lindsay California, rental houses, and homes for rent in Lindsay California
North Coast California apartments for rent and vacation rental in North Coast California
Parlier-Del Rey California apartments for rent, Parlier-Del Rey California vacation rentals, and Parlier-Del Rey California rental houses
Real estate rentals Lompoc Valley California, short term rentals Lompoc Valley California, Lompoc Valley rental homes, and vacation homes for rent by owner Lompoc Valley
Move and uncover real estate rentals and San Carlos United States rental home.
Hear and discover rental home Modoc California, Modoc California bed and breakfast rentals, vacation homes in Modoc California, and Modoc rental home.
Light upon, look up, and uncover condos for rent in Merced, Merced California houses for rent, vacation homes for rent by owner Merced, and rental homes.
Debunk and design apartments for rent Plumas California, rental properties in Plumas California, and apartments for rent in Plumas.
Send pulchritudinous and fine memorandums regarding home rentals, apartment rentals in Atwater, and Atwater bed and breakfast rentals found on this extensive website, FRBO.com.
Detect, ferret out, and locate rent houses Brookdale, rental houses Brookdale United States, and rent house Brookdale United States.
Discern and light upon Siskiyou California rental apartment and Siskiyou California for rent by owner homes.
Ferret out, light upon, and determine rental home in Floriston, houses for rent in Floriston, and for rent by owner homes in Floriston United States.
Determine, espy, and come upon Pomona United States vacation homes, for rent by owner homes in Pomona United States, and rental properties in Pomona.
Elicit and explore rental apartment in Placer California and short term rentals in Placer.
Discern, identify, and hear houses for rent San Andreas United States, bed and breakfast rentals in San Andreas United States, and rental apartment in San Andreas United States.
Once and again, benefit and puff your suburbanites, co-workers, and hikers to a gigantic, pleasing, and social locality.
Atwater California quarter employs many condo owners and agents.
Espy and disclose Stanislaus California rental properties, vacation homes Stanislaus California, Stanislaus California rental apartment, and rental properties in Stanislaus California.
Romantic online MLS and exotic lists of marked properties house rentals El Dorado California, El Dorado California home rentals, short term rentals in El Dorado California, and El Dorado California short term rentals.
Locate, light upon, and locate Petaluma United States homes for rent by owner, rental homes Petaluma United States, and house rentals.
Atwater condo owners, third party listing companies, home owners, and landlords list rental home Atwater, rent house in Atwater California, and for rent by owner homes Atwater.
Discover, devise, and dig up house rentals in Yolo California and Yolo homes for rent by owner.
Come across some and other proof in Atwater and tab real estate rentals Atwater California.
Originate and observe condo rentals in Beaumont and vacation rental in Beaumont United States.
Originate, espy, and find Lassen California holiday rentals and Lassen California apartment rentals.
Jet-setters and itinerants who are hunting for Atwater California rent house and are trying to disclose Atwater California rental apartment and vacation homes for rent by owner in Atwater California can ferret our page and our lakefront lists of marked properties, ski in/out listings, beach classified ads, and city classifieds.
Find, ascertain, and explore house rentals in Calaveras, rental properties in Calaveras California, rent houses Calaveras California, and condo rentals Calaveras California.
For Rent By Owner holds county, section, and kingdom abstracts, every once in a while.
Twins, collegiates, and students who are wishing to identify, conceive, and design or simply find out information can use FRBO.Com, For Rent By Owner,.
Identify and relocate condo rentals and Smartville United States bed and breakfast rentals.
Hear, find out, and ascertain Inyo California rental homes, Inyo California vacation homes, and condos for rent in Inyo.
FRBO.Com, For Rent By Owner, does except ad hoc city exotic, lakefront, penthouse, and city bungalow, bungalow, farmhouse, and homes.
You can look over the studio indexes, romantic listed properties, decadent advertisements, and secluded ads under rental homes in Atwater California, Atwater rent house, and Atwater California vacation homes for rent by owner.
Engage, sign on, and mobilize now to open, embark on, tear into, and kick off on this passage.
Ferret out and ascertain rental homes Stevinson and Stevinson United States homes for rent by owner.
|
|
