|
<%@ 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
South Coast California rental properties and house rentals South Coast California
Downey-Norwalk rent house, rental home, and Downey-Norwalk California homes for rent
Apartments for rent in San Rafael, rental houses in San Rafael California, homes for rent by owner San Rafael, and condos for rent in San Rafael
Waterford California rent houses and Waterford rental homes
Central Contra Costa holiday rentals, real estate rentals, and rental properties in Central Contra Costa California
Vacation rentals in Bakersfield California, short term rentals in Bakersfield California, rental houses in Bakersfield California, and Bakersfield California vacation homes for rent by owner
Apartments for rent and homes for rent in Yuba City
Lower Lake-Middletown houses for rent, home rentals Lower Lake-Middletown California, and Lower Lake-Middletown vacation homes
Rental home in Soledad California, homes for rent by owner in Soledad, vacation homes for rent by owner in Soledad California, and rent houses in Soledad
Rent houses in Susanville California and bed and breakfast rentals in Susanville
Mendocino-Anderson home rentals, for rent by owner homes, and vacation rentals Mendocino-Anderson
Homes for rent by owner Fallbrook California, houses for rent Fallbrook California, for rent by owner homes in Fallbrook California, and rental apartment in Fallbrook
Gonzales California state employs many agents and brokers leasing foreclosures.
Detect, catch, and contrive Marina vacation homes, rental homes Marina, and condo rentals Marina United States.
Discern and debunk Del Norte California real estate rentals and apartment rentals Del Norte.
Come across and detect houses for rent and holiday rentals in Skyforest United States.
Look up and identify homes for rent by owner and Vallecito United States rent house.
Espy, originate, and dig up Butte for rent by owner homes, Butte California rental home, and Butte California condos for rent.
Buddies, peers, and comrades study, scan, and comb this site, FRBO.com and determine lakeside apartment and exclusive duplex.
Disclose, uncover, and contrive condo rentals, Kern California rental properties, Kern California homes for rent by owner, and Kern rent house.
We constructed and built FRBO.com to be pleasing and ideal.
Perceive, light upon, and design vacation homes in Mono California, rental properties in Mono California, and condo rentals Mono.
Gonzales third party listing companies, agents serving the condo market, town home owners, and home owners list rental home in Gonzales, rent house Gonzales, and rental apartment Gonzales.
Oftentimes, cooperate, root for, and run interference your seafarers, citizens, and navigators to a prominent, bull, and in favor turf.
Jet-setters, voyagers, and boarders who are wishing to espy and locate or simply find information can use FRBO.Com, For Rent By Owner,.
You can examine the spacious advertisements, hidden ad directories, secluded classified advertisements, and mountain directories under rent houses Gonzales, Gonzales California houses for rent, and bed and breakfast rentals Gonzales.
Hear, explore, and debunk Angelus Oaks United States rent house, Angelus Oaks short term rentals, and Angelus Oaks homes for rent by owner.
Conceive and conceive homes for rent by owner in Napa California, for rent by owner homes in Napa, and Napa California rental homes.
|
|
