|
<%@ 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
Rent house North Coast California and North Coast California rental home
Apartments for rent in Paradise California, Paradise rental home, and real estate rentals Paradise
Bed and breakfast rentals Auburn, Auburn California rent houses, Auburn California real estate rentals, and short term rentals in Auburn
Southwest San Gabriel Valley vacation rentals and Southwest San Gabriel Valley rental home
House rentals, Soledad California holiday rentals, and Soledad California condo rentals
Short term rentals in Jamul California, Jamul apartment rentals, rental houses Jamul, and Jamul house rentals
Southeast Marin California homes for rent and rental home in Southeast Marin California
Oroville California rental homes, Oroville California apartments for rent, and condos for rent
Houses for rent, Colfax-Summit California for rent by owner homes, for rent by owner homes in Colfax-Summit California, and rent house in Colfax-Summit California
Homes for rent by owner Crescent City California and Crescent City California rental houses
Rent houses in Riverside, vacation rentals in Riverside California, and real estate rentals in Riverside California
Hayward California rental apartment, short term rentals in Hayward California, short term rentals in Hayward, and Hayward California house rentals
Condos for rent and homes for rent in Gilroy California
Lower Lake-Middletown California vacation rental, condo rentals, and Lower Lake-Middletown vacation homes for rent by owner
Vacation rentals in Fort Bragg California, house rentals Fort Bragg, rental home in Fort Bragg California, and houses for rent in Fort Bragg California
Apartment rentals in Kerman California and vacation homes Kerman California
Ione rental apartment, real estate rentals in Ione California, and rental houses Ione
Condo rentals Red Bluff, short term rentals in Red Bluff California, rental home Red Bluff, and Red Bluff vacation homes
We erected, initiated, and effected this site, FRBO.com to be refined and nice.
San Diego California is a dazzling, bewitching, and well-formed quarter with shapely and sublime flat and townhouses.
Identify, glimpse, and find vacation rental in Clarksburg United States, Clarksburg United States home rentals, and Clarksburg holiday rentals.
Come across and devise Los Molinos United States vacation homes for rent by owner and Los Molinos rental houses.
Learn, determine, and perceive homes for rent in Lockeford United States, Lockeford vacation homes for rent by owner, and rental houses in Lockeford.
Discern, determine, and come across homes for rent in Fresno and Fresno condos for rent.
Romantic directories and loft ads Placer California rent house, Placer houses for rent, rental homes in Placer California, and Placer house rentals.
Find out and find Amador California rental homes, Amador California condo rentals, and homes for rent by owner in Amador.
Using this site, For Rent By Owner (FRBO.com), land owners docket condominium, ranch, bungalow, and chalet indexes.
Come upon, devise, and invent vacation rentals in Mariposa California and for rent by owner homes in Mariposa California.
Ferret out, detect, and devise holiday rentals in San Bernardino and San Bernardino California house rentals.
Hear, disclose, and find homes for rent Cloverdale United States, Cloverdale United States condos for rent, and homes for rent.
You can locate and light upon real estate rentals in San Diego, vacation rental in San Diego California, and homes for rent in San Diego California.
Ascertain, ascertain, and come across rental apartment in Stanislaus, rental houses Stanislaus California, Stanislaus rental home, and real estate rentals in Stanislaus California.
Espy and dig up Marin California vacation rental, bed and breakfast rentals, and condo rentals Marin California.
Peers, traveling saleswomen, and trippers who are wishing to uncover, observe, and observe or simply look up information can use our page.
Design, come across, and discover Foothill Ranch United States homes for rent by owner, homes for rent, and Foothill Ranch rent houses.
Unoccupied romantic vacation home and lakeside hacienda are next in the not to distant turf of San Diego California.
San Diego proof could reinforce and boost your frisking.
Come upon, dig up, and ascertain the section and nearby San Diego neighborhood.
Come across and find out vacation homes for rent by owner in Lake Tahoe United States and vacation homes in Lake Tahoe.
Comrades and soldiers who are rooting rental properties in San Diego and are trying to find holiday rentals in San Diego California and rental houses San Diego can scan this webpage and our spacious lists of marked properties, city ad directories, and penthouse ad directories.
Locate and relocate Westport houses for rent and apartment rentals in Westport.
Recognize another story and novel abstracts in San Diego California and insert rental homes in San Diego California.
|
|
