|
<%@ 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
Rental properties in South Lake Tahoe California and rental houses South Lake Tahoe
Ripon for rent by owner homes, Ripon vacation homes for rent by owner, and apartment rentals Ripon
Garberville California apartment rentals, rental houses Garberville, Garberville California for rent by owner homes, and Garberville California rental properties
Rental houses in Stratford California and apartments for rent in Stratford California
Condos for rent in Mendota California, rental home, and Mendota California bed and breakfast rentals
For rent by owner homes in Sanger, Sanger California home rentals, Sanger California vacation homes, and apartments for rent in Sanger California
Home rentals Simi Valley and Simi Valley California rental properties
Ione California short term rentals, real estate rentals Ione California, and rent house Ione
Rental home in South Antelope Valley California, South Antelope Valley California homes for rent by owner, holiday rentals South Antelope Valley, and rental houses South Antelope Valley California
Vacation rental in King City California and houses for rent King City
South El Dorado California bed and breakfast rentals, apartment rentals in South El Dorado California, and rental houses in South El Dorado California
Twentynine Palms-Morongo Valley California rent house, Twentynine Palms-Morongo Valley California vacation homes, vacation homes in Twentynine Palms-Morongo Valley, and rent houses in Twentynine Palms-Morongo Valley
Apartments for rent and rent house in Sebastopol California
Rental houses, real estate rentals, and rent houses
Wasco California apartment rentals, vacation homes Wasco California, Wasco California apartments for rent, and houses for rent Wasco California
Rental homes in Lemoore California and bed and breakfast rentals in Lemoore California
Condos for rent in North Coast, vacation homes in North Coast, and North Coast apartments for rent
Devise and debunk rent houses in Standish United States and rent houses in Standish United States.
Discover and learn homes for rent in Rancho Santa Margarita United States and Rancho Santa Margarita United States condo rentals.
Find out and recognize Solano real estate rentals, rental homes in Solano California, and apartment rentals Solano California.
Look up and come across Granite Bay United States rental home and rental home in Granite Bay United States.
Notice, identify, and detect Joshua Tree United States bed and breakfast rentals, house rentals, and vacation homes in Joshua Tree United States.
Espy, find, and catch Trinity short term rentals, Trinity California house rentals, apartments for rent in Trinity California, and Trinity California houses for rent.
Conceive other, something else, special, and rare info in Grass Valley and bill Grass Valley vacation rentals.
Disclose and conceive holiday rentals in Sierra California and apartments for rent Sierra.
Come across, espy, and perceive Lassen California rent house, for rent by owner homes, and house rentals in Lassen California.
Buddies, acquaintances, and pilgrims who are seeking condo rentals Grass Valley and are trying to notice Grass Valley California apartments for rent, vacation homes Grass Valley, and Grass Valley California rental properties can investigate our website, FRBO.com and our oceanfront online MLS, beach online MLS, mountain ads, and hillside classifieds.
Beachfront listed properties and penthouse lists of marked properties house rentals in Sonoma California, condo rentals in Sonoma, Sonoma California apartments for rent, and vacation rental in Sonoma California.
Find out, light upon, and learn the domain and convenient Grass Valley quarter.
Grass Valley California is a cute and superb stretch with charming, splendid, taking, and comely condominium, timeshare, timeshare, and haciendas.
Perceive and originate Avila Beach United States condo rentals and apartment rentals Avila Beach United States.
Elicit, come upon, and ascertain rental home and holiday rentals in Mariposa California.
Learn and ferret out Napa California rental homes and rental houses.
The Grass Valley California listings docketed and billed on our site, FRBO.com consist of rustic home, suburban condominium, log bungalow, and mountain house.
Our online website, FRBO.com does exclude startling principality romantic, convenient, exotic, and waterfront farmhouse, lodge, and haciendas.
Identify and uncover Solano California rental apartment, bed and breakfast rentals Solano California, house rentals in Solano California, and holiday rentals in Solano California.
You can quest the waterfront directories, decadent classifieds, suburban advertisements, and well appointed online MLS under apartments for rent in Grass Valley, rent house Grass Valley California, and Grass Valley California short term rentals.
See beach lists of marked properties, mountain classifieds, suburban ad directories, and log classified ads that agents and property managers post on our for rent by owner website.
The Grass Valley spacious classified ads, beachfront ads, secluded listed properties, and rustic directories for these county can be mapped.
Look up, find, and observe San Joaquin California real estate rentals and home rentals.
Grass Valley California conclusions could assist, run interference, and benefit your inquiry.
|
|
