|
<%@ 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
Russian River-Coastal California vacation rental and Russian River-Coastal homes for rent by owner
Real estate rentals, houses for rent in Palo Verde California, and vacation homes for rent by owner Palo Verde
Real estate rentals Mendota, houses for rent in Mendota California, Mendota short term rentals, and Mendota apartments for rent
Home rentals in North Coast California and North Coast California condos for rent
Santa Maria Valley California rent houses, rental homes Santa Maria Valley, and rental home Santa Maria Valley California
Home rentals Reedley California, Reedley California home rentals, Reedley rental home, and Reedley California rental home
Corning California short term rentals and Corning California apartments for rent
Homes for rent by owner, rental apartment in Eureka California, and homes for rent by owner in Eureka
Condo rentals Fremont, Fremont rent houses, apartment rentals in Fremont California, and home rentals
Bed and breakfast rentals in North Antelope Valley California and house rentals North Antelope Valley
Devise and light upon Santa Ynez United States vacation rentals and Santa Ynez United States short term rentals.
Using this site, For Rent By Owner (FRBO.com), real estate investors place villa and farmhouse indexes.
Explore and design for rent by owner homes in Napa, Napa California vacation rental, and rental home in Napa.
Uncover, discover, and ascertain vacation homes for rent by owner in Selma United States, rental houses in Selma United States, and rent house Selma United States.
This site, For Rent By Owner (FRBO.com) can reserve, secure, and reserve log ads, loft lists of marked properties, decadent lists of marked properties, and beachfront ad directories decadent online MLS and suburban directories to aid your Yuba City expedition.
Yuba City land owners, rental owners, real estate agents, and real estate agents list homes for rent by owner in Yuba City California, apartments for rent in Yuba City, Yuba City holiday rentals, and homes for rent in Yuba City.
Suburban lists of marked properties and oceanfront classified advertisements San Luis Obispo California vacation rental, San Luis Obispo vacation homes, house rentals in San Luis Obispo California, and apartments for rent San Luis Obispo.
Appoint, reserve, and get tomorrow evening to jump into, begin, take up, and inaugurate on this crossing.
The Yuba City indexes invoiced and catalogued on our webpage embrace city ranch, loft apartment, waterfront cottage, and decadent condominium.
Identify and conceive the kingdom and not remote Yuba City principality.
Relocate and observe vacation homes for rent by owner in Armona and Armona United States rent houses.
Design, move, and glimpse San Joaquin California rental properties, condos for rent, and San Joaquin California vacation rentals.
Catch, discern, and identify rent houses Fish Camp United States, Fish Camp United States vacation homes, and houses for rent Fish Camp United States.
|
|
