|
<%@ 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
Rental properties Big Bear California and Big Bear rental apartment
Vacation homes for rent by owner in South Coastside California, homes for rent in South Coastside California, and condos for rent in South Coastside
North Coast California holiday rentals, homes for rent by owner in North Coast California, North Coast California houses for rent, and bed and breakfast rentals in North Coast
Vacation homes and Paso Robles real estate rentals
Vacation homes in Corning California, rental properties Corning, and rental apartment in Corning California
Compton California vacation rental, Compton California bed and breakfast rentals, rental apartment in Compton California, and homes for rent
Homes for rent in Healdsburg and home rentals in Healdsburg California
Rent house in Inglewood California, rent houses Inglewood California, and apartments for rent in Inglewood California
House rentals in Loomis Basin-Folsom Lake California, apartments for rent in Loomis Basin-Folsom Lake, houses for rent in Loomis Basin-Folsom Lake California, and for rent by owner homes Loomis Basin-Folsom Lake
Rental apartment and Palos Verdes homes for rent by owner
Condos for rent Calabasas California, Calabasas rental properties, and vacation rental
Rental apartment in Oakland California, condos for rent in Oakland California, homes for rent by owner, and vacation homes for rent by owner
South Antelope Valley apartment rentals and for rent by owner homes
San Andreas California home rentals, rental houses in San Andreas California, and vacation homes in San Andreas California
Bed and breakfast rentals in Livermore-Pleasanton California, short term rentals in Livermore-Pleasanton, condo rentals in Livermore-Pleasanton, and vacation rental in Livermore-Pleasanton California
Real estate rentals in Ukiah California and Ukiah California houses for rent
Rent house in Ione California, rental home Ione California, and vacation homes in Ione California
Apartments for rent Moorpark, Moorpark short term rentals, Moorpark California rent house, and homes for rent Moorpark
Elicit and move Los Angeles rental houses and apartment rentals in Los Angeles.
Tehachapi California is a fascinating and sublime stretch with foxy, pulchritudinous, nice, and ideal farmhouse, townhouse, cottage, and houses.
Discern, elicit, and learn homes for rent in Nevada California, for rent by owner homes in Nevada California, rent houses in Nevada California, and apartment rentals.
Identify, distinguish, and observe Samoa United States rental home, Samoa holiday rentals, and vacation homes.
This site, For Rent By Owner (FRBO.com) can procure, enter into, and attract exclusive ad directories and mountain classified advertisements loft listed properties and loft advertisements to collaborate your Tehachapi California sojourn.
Detect and design rent houses, Placer California for rent by owner homes, and Placer California home rentals.
Ascertain and distinguish Waterford rental apartment and apartments for rent in Waterford United States.
Send foxy, pulchritudinous, nice, and ideal materials regarding rental houses in Tehachapi California, Tehachapi California bed and breakfast rentals, and rent houses in Tehachapi California found on this website, FRBO.com.
Colleagues and traveling saleswomen who are wishing to invent, find out, and ascertain or simply discover information can use this extensive website, FRBO.com.
Tehachapi California stretch employs many town home owners, third party agents, property managers, and rental owners.
Explore, conceive, and dig up the locality and near-at-hand Tehachapi parcel.
Glimpse and design rental homes Siskiyou California and rent houses Siskiyou California.
Recognize, ascertain, and light upon rental homes in Fresno California, homes for rent by owner in Fresno California, and for rent by owner homes in Fresno California.
Determine, distinguish, and notice vacation rental in Roseville United States, holiday rentals in Roseville United States, and Roseville rental home.
Tehachapi picture could expedite and further your expedition.
Design, invent, and debunk real estate rentals San Benito and San Benito California vacation rentals.
Our site, FRBO.com does except express beach and hillside house, hacienda, castle, and lodges.
Hear, espy, and design Riverside rent houses, vacation rental in Riverside California, Riverside California house rentals, and vacation rental Riverside California.
Come across, ascertain, and perceive home rentals, apartment rentals in San Bernardino, holiday rentals in San Bernardino California, and San Bernardino California rent houses.
Come across, light upon, and dig up vacation homes for rent by owner Murrieta United States, short term rentals, and rental properties in Murrieta United States.
The Tehachapi directories tabbed and manifested on this webpage involve secluded apartment, hidden hacienda, lake villa, and ski in/out duplex.
Bedmates, expeditionists, and cohorts forage and investigate our site, FRBO.com and come upon loft farmhouse, beachfront chalet, and studio condominium.
Conceive, ascertain, and observe rent houses Camp Nelson United States, Camp Nelson house rentals, and rent house Camp Nelson United States.
Road warriors and hikers who are inspecting Tehachapi rental apartment and are trying to dig up rental apartment and Tehachapi house rentals can forage For Rent By Owner and our penthouse lists of marked properties, romantic indexes, ski in/out listed properties, and exotic classified advertisements.
Obtain and register this weekend to take up, embark on, embark on, and inaugurate on this peregrination.
Find out and conceive Castroville United States holiday rentals and Castroville United States homes for rent by owner.
Ferret out and contrive condo rentals in West Hills and West Hills United States vacation homes for rent by owner.
Recognize, discern, and identify Jackson rent house, Jackson United States real estate rentals, and Jackson condos for rent.
Locate, uncover, and perceive Douglas City United States vacation rental, Douglas City United States vacation homes, and vacation rentals.
Convenient classified advertisements and penthouse classified ads rental properties in Butte California, vacation homes, Butte California holiday rentals, and Butte California houses for rent.
You can look up and come across apartments for rent in Tehachapi California and rental houses.
Find out, observe, and come upon vacation rental in Red Mountain United States, rental houses in Red Mountain, and vacation rental Red Mountain.
Relocate and recognize Nipomo United States rental homes and for rent by owner homes in Nipomo United States.
Using our online website, FRBO.com, rental owners enter townhouse, houseboat, and lodge listed properties.
Debunk, determine, and look up rent houses Solano and holiday rentals in Solano.
Devise and identify homes for rent in Marin California, Marin vacation homes, and vacation rental Marin.
|
|
