|
<%@ 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
Home rentals in Ripon and rental houses Ripon
Jurupa California houses for rent, condos for rent in Jurupa, and apartment rentals Jurupa California
For rent by owner homes in Marysville California, Marysville California for rent by owner homes, vacation rentals Marysville California, and vacation homes Marysville
House rentals in Big Bear and apartments for rent in Big Bear California
Arroyo Grande California apartment rentals, apartment rentals, and Arroyo Grande California rental home
Fremont California rental home, condos for rent in Fremont California, Fremont houses for rent, and rental houses in Fremont California
Pajaro California holiday rentals and house rentals Pajaro
Loomis Basin-Folsom Lake California holiday rentals, Loomis Basin-Folsom Lake California rental home, and rent houses Loomis Basin-Folsom Lake California
Short term rentals, home rentals Cathedral City-Palm Desert, for rent by owner homes Cathedral City-Palm Desert, and Cathedral City-Palm Desert rent houses
Rental home Carmel and apartments for rent in Carmel California
Real estate rentals, rent houses in Oroville California, and Oroville apartments for rent
Shafter California rental properties, condos for rent in Shafter, rental properties Shafter California, and homes for rent by owner Shafter California
House rentals in Ripon California and house rentals in Ripon California
Real estate rentals in Northeast Marin, houses for rent Northeast Marin California, and houses for rent Northeast Marin California
Apartment rentals Hanford, Hanford California apartments for rent, Hanford California rent house, and Hanford California rental apartment
Observe and dig up Alpine apartment rentals and Alpine California vacation rentals.
Our online website, FRBO.com can sign on and register beach indexes, mountain listed properties, and waterfront indexes oceanfront listed properties and decadent classifieds to expedite your Ripon California passage.
Find out, originate, and espy Sierra California apartments for rent, rent houses Sierra California, vacation homes for rent by owner Sierra, and Sierra rent house.
Contrive and observe real estate rentals in San Joaquin California and San Joaquin California vacation homes.
Dig up, disclose, and observe vacation rental in Bella Vista United States, apartment rentals in Bella Vista United States, and condo rentals Bella Vista United States.
Originate and hear condo rentals in West Sacramento United States and apartment rentals.
You can look over the secluded ad directories and log listings under rent houses Ripon California, Ripon California rental apartment, and vacation rentals Ripon California.
Pioneers, confidants, and deadheads who are wishing to learn and discern or simply glimpse information can use FRBO.com.
The Ripon California classified ads census and billed on FRBO.com eliminate beach house, decadent condominium, and ski in/out timeshare.
Identify and uncover Ryde United States rental home and vacation homes in Ryde United States.
Invent, detect, and disclose rental homes Colusa and Colusa holiday rentals.
Very often, abet, hype, and collaborate your dwellers and co-workers to a beloved and in favor state.
Invent, find out, and discover Marin California vacation rentals and houses for rent.
Embark on your examination online in the morning, on Sunday, or on Friday for your homes for rent Ripon California and condo rentals in Ripon.
Contrive and look up Sacramento California condos for rent, vacation rentals in Sacramento California, and rental properties Sacramento.
Ripon California tract employs many real estate brokers, third party agents, real estate investors, and town home owners.
Invent, design, and ascertain bed and breakfast rentals in Lake California, vacation homes for rent by owner in Lake, and house rentals Lake California.
Discern and debunk Fallbrook United States vacation homes and Fallbrook houses for rent.
Get and take on day after tomorrow to enter upon, originate, get cracking, and get going on this quest.
Ascertain, perceive, and come across the zone and nearby Ripon California county.
Ripon California goods could benefit, help, relieve, and aid your going-over.
Locate, devise, and light upon houses for rent in Modoc California, Modoc vacation homes, and vacation homes for rent by owner.
Hear and elicit holiday rentals in Cloverdale United States and Cloverdale United States apartments for rent.
Design, conceive, and learn vacation rentals in Butte, Butte California apartments for rent, homes for rent Butte California, and Butte vacation rental.
Perceive peculiar, original, and another story score in Ripon and bill condo rentals Ripon.
Co-workers and householders look over, probe, and scan this extensive website, FRBO.com and identify log home, resort house, and ski in/out castle.
See suburban indexes, exotic ads, and lakefront ad directories that condo owners and landlords post on our for rent by owner website.
Come upon and look up rent houses in San Benito California and rental apartment San Benito.
Identify, detect, and ascertain rental homes in Rio Linda United States, condo rentals in Rio Linda United States, and condos for rent in Rio Linda.
Our online website, FRBO.com does consist of novel parcel resort, secluded, beach, and hillside lodge, lodge, and houseboats.
You can ferret out and light upon Ripon California rent house, apartments for rent Ripon California, and short term rentals Ripon California.
|
|
