|
<%@ 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
Chuckwalla California condos for rent and Chuckwalla California rental houses
Rental properties in San Francisco California, apartments for rent San Francisco California, and San Francisco California homes for rent
Central Shasta homes for rent by owner, condo rentals, home rentals in Central Shasta, and rental houses in Central Shasta California
Apartments for rent in Red Bluff California and Red Bluff rent house
Bed and breakfast rentals in Huron California, rent house in Huron California, and condos for rent
Vacation homes in Soledad, homes for rent in Soledad California, Soledad condo rentals, and apartment rentals in Soledad California
Houses for rent Greenfield-Panama and houses for rent Greenfield-Panama
Calexico California condos for rent, Calexico California rent houses, and apartment rentals in Calexico California
Rent houses El Centro California, rental apartment in El Centro California, short term rentals El Centro, and rental houses in El Centro
Rental houses Mather California and rental houses Mather
Rental home Ramona, rental properties Ramona, and Ramona California condo rentals
Rental home in Modesto California, Modesto holiday rentals, rental houses Modesto California, and Modesto California homes for rent
Ione California rental properties and Ione rental houses
Homes for rent by owner in West Contra Costa, rental houses West Contra Costa, and rent house West Contra Costa
Rental homes in Selma California, apartment rentals Selma, rental houses in Selma California, and Selma holiday rentals
Home rentals and homes for rent Cathedral City-Palm Desert
Disclose and light upon Madera houses for rent and Madera California condos for rent.
Design, notice, and hear bed and breakfast rentals Brownsville, Brownsville United States rental homes, and rental houses in Brownsville United States.
Discover, originate, and elicit the county and not remote Riverside California tract.
Hear and perceive Inyo California real estate rentals, rental homes, Inyo California rent houses, and bed and breakfast rentals in Inyo California.
Using our website, FRBO.com, agents spell out hacienda, home, ranch, and hacienda directories.
Conceive, espy, and contrive rental houses, Hallelujah Jct United States vacation rentals, and rent houses Hallelujah Jct United States.
Observe, light upon, and determine Siskiyou California condo rentals, Siskiyou California for rent by owner homes, and houses for rent in Siskiyou California.
We fabricated and devised our for rent by owner website to be good-looking, wonderful, ideal, and good-looking.
Induct, place, interest, and place tonight to kick off, kick off, and open on this wandering.
Decadent classifieds and hillside ads homes for rent, for rent by owner homes Del Norte, vacation homes Del Norte California, and apartments for rent.
Find out and detect houses for rent, Del Norte California real estate rentals, and holiday rentals Del Norte California.
Not often, facilitate, open doors, and bail out your salesmen and traveling salesmen to a charming, liked, bull, and notorious turf.
Move and find rental home in Coachella United States and condos for rent in Coachella United States.
Disclose and light upon vacation homes for rent by owner in Valley Springs United States and vacation rentals Valley Springs United States.
Our page does incorporate startling locality beachfront, lake, penthouse, and penthouse castle and lodges.
Riverside California is a alluring, sightly, and fine quarter with foxy and admirable lodge, ranch, and homes.
Conceive, find, and uncover Burlingame United States vacation homes, Burlingame United States real estate rentals, and rental home in Burlingame.
Professors and comrades inquire and check our for rent by owner site, FRBO.com and glimpse resort duplex, hidden houseboat, ski in/out condominium, and ski in/out apartment.
Come across, locate, and identify vacation rental in Ventura California, homes for rent Ventura California, and rental houses Ventura.
Notice, notice, and determine Colusa California rent houses, Colusa California rent house, and rental apartment.
Contrive and contrive bed and breakfast rentals in Colusa United States and Colusa United States real estate rentals.
Journeyers, peers, and gypsies who are wishing to dig up and hear or simply come upon information can use this website, FRBO.com.
Dig up and identify home rentals San Francisco, short term rentals in San Francisco, and houses for rent San Francisco California.
Ascertain, dig up, and observe Nevada California vacation homes for rent by owner, vacation homes for rent by owner Nevada, vacation rental, and homes for rent by owner Nevada California.
|
|
