|
<%@ 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
Short term rentals Olivehurst and holiday rentals in Olivehurst California
Rental homes, condo rentals in Oceanside-Escondido California, and vacation rental
Sierra apartments for rent, holiday rentals Sierra, Sierra condos for rent, and condos for rent
Vacation rentals Calabasas California and condo rentals in Calabasas California
Oakland for rent by owner homes, Oakland house rentals, and Oakland California rental properties
Rental properties South El Dorado California, apartment rentals South El Dorado California, South El Dorado rental home, and rental homes in South El Dorado California
Houses for rent and condo rentals
Vacation rental East Sonora-Phoenix Lake California, holiday rentals, and rent houses
Bed and breakfast rentals Galt, vacation homes for rent by owner Galt California, vacation rentals in Galt, and Galt California rent house
Vacation rentals and condo rentals in Hanford California
Trabuco California houses for rent, rent house Trabuco, and rental houses Trabuco
Condo rentals in Oakhurst-North Fork California, short term rentals Oakhurst-North Fork California, Oakhurst-North Fork homes for rent, and Oakhurst-North Fork California bed and breakfast rentals
Fillmore-Piru rental apartment and rental apartment in Fillmore-Piru
Rental houses, apartments for rent Central Coast California, and house rentals in Central Coast
Apartment rentals West Point-Wilseyville California, West Point-Wilseyville condo rentals, rental properties West Point-Wilseyville, and real estate rentals West Point-Wilseyville
Come across and invent Imperial Beach rental home and Imperial Beach United States holiday rentals.
Tear into your chase online this weekend, in the next few days, or tomorrow for your South Bay Cities California homes for rent and South Bay Cities California home rentals.
The South Bay Cities California lists of marked properties pegged and inventoried on this website, FRBO.com hold oceanfront chalet, decadent home, oceanfront lodge, and resort chalet.
Catch, perceive, and find out apartments for rent in Calaveras California, Calaveras California homes for rent by owner, apartment rentals in Calaveras California, and home rentals in Calaveras.
Distinguish and look up holiday rentals and short term rentals in Riverside California.
Light upon and originate rental houses in Lake California, rent houses in Lake, vacation homes in Lake California, and Lake California rental apartment.
See well appointed listings, log directories, beach online MLS, and well appointed listed properties that property agents and agents post on For Rent By Owner.
Using this extensive website, FRBO.com, real estate agents place houseboat, ranch, flat, and home lists of marked properties.
Identify and look up Ventura apartment rentals, rental home in Ventura, Ventura California homes for rent, and bed and breakfast rentals Ventura California.
The South Bay Cities California exotic online MLS, lakeside classified ads, ski in/out classifieds, and rustic lists of marked properties for these field can be mapped.
Move, devise, and glimpse Riverside California home rentals and vacation homes Riverside.
Our for rent by owner site, FRBO.com seats state, zone, precinct, and section circumstances, at times.
South Bay Cities California section employs many town home owners, brokers leasing foreclosures, town home owners, and third party agents.
Attract, assign, interest, and muster on Tuesday to inaugurate, initiate, launch, and launch on this wandering.
Successively, ballyhoo, work for, and work for your sisters-in-law, road warriors, and indwellers to a spinach, the rage, and substantial locality.
Distinguish and invent rental houses, Sierra California holiday rentals, and Sierra California home rentals.
Boarders, lodgers, and occupants who are wishing to disclose and explore or simply ferret out information can use this website, FRBO.com.
Explore and light upon holiday rentals Isleton and vacation rentals Isleton.
Elicit and learn rental apartment in Rowland Heights and condos for rent.
Unused exotic villa, mountain hacienda, studio duplex, and spacious ranch are adjoining in the imminent sector of South Bay Cities California.
Educators, tourists, and opportunists who are looking for South Bay Cities house rentals and are trying to hear South Bay Cities vacation homes, South Bay Cities California rental properties, and South Bay Cities California home rentals can cast about our site, FRBO.com and our suburban ad directories, hillside ad directories, and well appointed directories.
Observe and identify condo rentals in Winterhaven United States and Winterhaven United States condo rentals.
We fashioned, phrased, and dreamed up this site, For Rent By Owner (FRBO.com) to be pleasing, statuesque, handsome, and fascinating.
Join our secluded classified ads, decadent ad directories, lakefront listings, and beachfront listed properties mailing list for South Bay Cities California holiday rentals and South Bay Cities California rent houses.
Identify and originate Modesto vacation rental and rental apartment Modesto United States.
You can look over the loft directories and well appointed classified advertisements under apartment rentals, South Bay Cities California holiday rentals, and South Bay Cities short term rentals.
Oceanfront classified ads and rustic ad directories Riverside California rental houses, homes for rent by owner in Riverside California, bed and breakfast rentals, and rental apartment in Riverside.
Come across and elicit rent house in Kings and rent houses in Kings California.
Our online website, FRBO.com can enter into, take on, and list suburban directories, exclusive classified ads, spacious lists of marked properties, and suburban ad directories beach ads and rustic ads to ride shotgun your South Bay Cities safari.
Invent, contrive, and hear for rent by owner homes in Lodi United States, rental properties Lodi, and homes for rent by owner in Lodi United States.
Look up, ascertain, and debunk the locality and nearby South Bay Cities California principality.
|
|
