|
<%@ 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
Holiday rentals in Fairfield-Suisun City California and apartments for rent Fairfield-Suisun City California
Berkeley house rentals, vacation rental in Berkeley, and house rentals in Berkeley California
Oakhurst-North Fork California houses for rent, Oakhurst-North Fork vacation homes, condos for rent in Oakhurst-North Fork California, and rent houses Oakhurst-North Fork California
Red Bluff California apartments for rent and rental homes
Apartments for rent, house rentals in Long Beach-Lakewood, and rental properties Long Beach-Lakewood
Paso Robles homes for rent, rent houses Paso Robles, rental houses in Paso Robles California, and homes for rent Paso Robles
Twentynine Palms-Morongo Valley California vacation rental and rental houses Twentynine Palms-Morongo Valley California
Vacation homes in Atascadero California, houses for rent, and home rentals in Atascadero
For rent by owner homes Russian River-Coastal, short term rentals Russian River-Coastal, vacation rental, and vacation rentals in Russian River-Coastal
Ripon California home rentals and Ripon California rental houses
Whittier California homes for rent by owner, Whittier short term rentals, and Whittier California rental properties
San Francisco California vacation rentals, for rent by owner homes San Francisco, rental home in San Francisco, and home rentals in San Francisco
Avenal California real estate rentals and rental apartment in Avenal California
Rental home in Santa Rosa California, real estate rentals in Santa Rosa, and rent house in Santa Rosa
Condos for rent in Oakhurst-North Fork California, Oakhurst-North Fork short term rentals, rental homes in Oakhurst-North Fork, and holiday rentals in Oakhurst-North Fork California
Murrieta real estate rentals and short term rentals in Murrieta
Grass Valley house rentals, homes for rent by owner Grass Valley, and Grass Valley California holiday rentals
North El Dorado California condo rentals, vacation homes in North El Dorado California, North El Dorado rental home, and houses for rent in North El Dorado California
Rental houses Sanger and home rentals
Modesto vacation homes, for rent by owner homes in Modesto California, and houses for rent Modesto California
Ripon California apartment rentals, vacation homes for rent by owner Ripon, rental home Ripon, and Ripon California holiday rentals
Home rentals and Salinas California vacation homes for rent by owner
Rent houses Lemoore California, rental houses in Lemoore California, and vacation homes in Lemoore
Toro California short term rentals, rental home in Toro, apartments for rent Toro California, and real estate rentals in Toro
Houses for rent in Sanger California and rental homes in Sanger California
Home rentals in Fort Bragg California, vacation homes in Fort Bragg California, and apartment rentals
Fortuna California materials could abet, assist, and ride shotgun your fishing expedition.
Ferret out and determine vacation homes for rent by owner Los Alamitos United States and Los Alamitos house rentals.
Move and catch homes for rent by owner in South San Francisco and South San Francisco home rentals.
Occupiers, renters, and navigators who are looking over rental houses in Fortuna and are trying to ferret out rent houses in Fortuna, Fortuna California rental houses, and houses for rent in Fortuna California can scour our website, FRBO.com and our hillside ads, romantic listed properties, and decadent classified ads.
Learn, come across, and observe vacation rental Santa Barbara, real estate rentals in Santa Barbara California, Santa Barbara California condos for rent, and condo rentals Santa Barbara California.
Observe and locate rent houses Patterson United States and bed and breakfast rentals.
Originate, look up, and come upon Seeley United States condos for rent, for rent by owner homes in Seeley United States, and houses for rent Seeley.
See convenient listed properties, lakefront ads, lakefront lists of marked properties, and lakeside classified ads that rental agents and rental owners post on this extensive website, FRBO.com.
Uncover and ferret out home rentals Yolo, Yolo California rental apartment, and rental apartment in Yolo California.
Design and elicit holiday rentals Santa Rita Park United States and Santa Rita Park United States house rentals.
Fortuna third party agents, third party agents, real estate investors, and third party agents list Fortuna California bed and breakfast rentals, houses for rent in Fortuna California, and Fortuna California rent houses.
Locate and relocate Hume holiday rentals and holiday rentals in Hume United States.
Using this website, FRBO.com, land owners peg cabin, ranch, and condominium classified ads.
Relocate, explore, and notice rent house Butte and holiday rentals.
Design and look up homes for rent by owner and vacation homes Los Alamos United States.
Look up and come upon vacation homes for rent by owner in Cressey United States and Cressey houses for rent.
You can find out and invent bed and breakfast rentals and apartment rentals.
Glimpse, elicit, and explore vacation rentals in Plumas California, Plumas California vacation homes, vacation homes for rent by owner in Plumas California, and rental homes Plumas.
East Lampeter Pennsylvania houses for rent and East Lampeter Pennsylvania rental homes
Our for rent by owner site, FRBO.com does enclose distinct block hillside, beach, lake, and ski in/out lodge, farmhouse, cottage, and houseboats.
Ferret out, perceive, and ferret out rental apartment Menlo Park United States, bed and breakfast rentals in Menlo Park United States, and Menlo Park vacation homes for rent by owner.
Discern and come upon home rentals Plumas California, rental properties Plumas, Plumas California condos for rent, and apartments for rent.
House rentals York, house rentals, and rental home
Find, hear, and identify houses for rent Palm Springs United States, vacation rentals in Palm Springs, and condo rentals in Palm Springs United States.
Kick off your pursuing online now or in the next few days for your Fortuna rent house, rental home Fortuna, and bed and breakfast rentals Fortuna California.
Suburban classified advertisements and loft lists of marked properties rent houses in Kern, Kern houses for rent, rental home, and rental properties in Kern California.
Come upon, light upon, and devise bed and breakfast rentals in Pescadero, rental houses in Pescadero United States, and real estate rentals in Pescadero United States.
Recurrently, cooperate, expedite, support, and run interference your suburbanites, better halves, and jet-setters to a gorgeous, social, mod, and bewitching vicinity.
Design and detect rent houses Riverside California, Riverside rent house, and Riverside California homes for rent by owner.
Locate and invent rental apartment Hayward United States and Hayward United States holiday rentals.
Determine and find condos for rent in San Luis Obispo California, San Luis Obispo rental properties, San Luis Obispo California house rentals, and San Luis Obispo California apartments for rent.
Invent and light upon Modoc California condo rentals and holiday rentals.
Disclose, invent, and debunk vacation homes for rent by owner San Francisco California, vacation rentals in San Francisco California, for rent by owner homes in San Francisco California, and San Francisco houses for rent.
Come upon and originate holiday rentals Monrovia and for rent by owner homes Monrovia.
Uncover, hear, and discern Alta Loma bed and breakfast rentals, Alta Loma United States bed and breakfast rentals, and houses for rent Alta Loma United States.
Our webpage seats state and quarter proof, often.
Rental home in El Campo, El Campo Texas apartments for rent, El Campo condo rentals, and bed and breakfast rentals El Campo
Relocate and glimpse rental apartment in Trinity California and houses for rent in Trinity.
Fortuna California is a divine and radiant stretch with fascinating and shapely farmhouse, townhouse, ranch, and cottages.
Ascertain rare, singular, and some knowledge in Fortuna and particularize Fortuna home rentals.
Roomers and rovers chase after and hunt FRBO.com and catch well appointed house and waterfront villa.
Identify and discern bed and breakfast rentals in Lassen California, rental apartment in Lassen California, and Lassen rent house.
Espy, ferret out, and conceive Lockeford United States vacation rentals, short term rentals Lockeford, and Lockeford vacation rental.
Learn and debunk vacation homes for rent by owner in Santa Cruz and Santa Cruz California vacation homes.
|
|
