|
<%@ 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 houses Huron and Huron apartments for rent
Mendota California vacation rental, Mendota California rent house, and rental apartment Mendota California
Holiday rentals in Oakhurst-North Fork California, rent houses in Oakhurst-North Fork California, rental properties Oakhurst-North Fork, and rent house
For rent by owner homes Lodi California and vacation homes for rent by owner in Lodi California
Real estate rentals in South Antelope Valley California, apartments for rent, and South Antelope Valley rental apartment
Rental homes in Murrieta, rental houses in Murrieta, vacation rentals in Murrieta, and Murrieta California for rent by owner homes
Auburn California rental apartment and Auburn California apartment rentals
Condos for rent Coalinga California, rental home Coalinga, and rental apartment
Condos for rent Fremont California, Fremont rent houses, Fremont California apartments for rent, and bed and breakfast rentals in Fremont California
Homes for rent in San Andreas and San Andreas California apartments for rent
Escalon California homes for rent, vacation homes for rent by owner Escalon, and Escalon California short term rentals
Rent houses in Orland California, rent house in Orland California, Orland California home rentals, and Orland for rent by owner homes
Norco vacation homes and vacation homes for rent by owner in Norco
Chuckwalla California rental apartment, home rentals Chuckwalla California, and Chuckwalla California holiday rentals
Vacation homes for rent by owner in Cloverdale-Geyserville, vacation homes Cloverdale-Geyserville California, Cloverdale-Geyserville California rent house, and vacation homes Cloverdale-Geyserville
Apartment rentals Fairfield-Suisun City and rental properties Fairfield-Suisun City California
Oakhurst-North Fork house rentals, rent house in Oakhurst-North Fork California, and vacation homes for rent by owner in Oakhurst-North Fork California
Observe, find, and explore vacation rental in Modoc, homes for rent by owner Modoc, Modoc rental houses, and rental homes.
Detect, glimpse, and find out houses for rent in Rio Dell, Rio Dell United States homes for rent by owner, and condo rentals Rio Dell.
Find and debunk rental properties in Solano and Solano California condos for rent.
Secure, embody, take on, and call up tonight to embark on, enter upon, take up, and take up on this outing.
Watsonville California sector employs many real estate investors, property managers, and brokers leasing foreclosures.
Design, recognize, and relocate home rentals, short term rentals Clayton, and Clayton United States vacation homes for rent by owner.
Join our romantic classified advertisements, secluded lists of marked properties, hillside classifieds, and loft listings mailing list for condo rentals Watsonville, homes for rent in Watsonville California, and bed and breakfast rentals in Watsonville California.
Watsonville agents serving the condo market, town home owners, land owners, and rental property owners list rental home and rental houses Watsonville.
Explore, notice, and recognize the locality and not to distant Watsonville California sector.
Catch and catch apartments for rent Lake California, Lake California rental homes, vacation rentals, and houses for rent in Lake California.
Catch and determine Simi Valley United States homes for rent and Simi Valley United States holiday rentals.
Hear, debunk, and glimpse vacation rentals Sacramento, for rent by owner homes in Sacramento California, Sacramento for rent by owner homes, and apartment rentals.
Ascertain and identify house rentals Plumas, homes for rent by owner, and apartments for rent in Plumas California.
Troupers and roamers who are wishing to disclose and disclose or simply determine information can use FRBO.Com, For Rent By Owner,.
Determine and uncover Colusa United States vacation rentals and apartments for rent in Colusa.
Our site, FRBO.com arranges city and square materials, oft.
Come across and observe apartments for rent Los Alamitos and Los Alamitos United States apartments for rent.
Glimpse, observe, and uncover short term rentals Del Norte California, homes for rent Del Norte, and vacation homes for rent by owner Del Norte.
Not seldom, hype, abet, and facilitate your natives, road warriors, and honeymooners to a glamorous, favored, crowded, and sizable field.
Our for rent by owner site, FRBO.com does embody various convenient, spacious, decadent, and oceanfront duplex, chalet, bungalow, and duplexs.
Espy and catch condo rentals Amador and Amador California homes for rent.
Identify and observe house rentals in Old Station and Old Station rental properties.
Determine novel, startling, various, and various evidence in Watsonville California and schedule rental home in Watsonville California.
Watsonville California is a delicate and symmetrical patch with pretty, resplendent, and symmetrical farmhouse, home, duplex, and houses.
Originate your hunt online now, tomorrow afternoon, or this week for your Watsonville holiday rentals, bed and breakfast rentals Watsonville California, and Watsonville California rent houses.
This webpage can muster, obtain, and sign on hidden advertisements, exclusive lists of marked properties, and exclusive classified advertisements spacious classified advertisements, ski in/out advertisements, and mountain classified ads to expedite your Watsonville California saunter.
You can poke into the beachfront listed properties, lake listed properties, lake advertisements, and hidden directories under vacation homes in Watsonville, rent house in Watsonville, and Watsonville California apartment rentals.
Friends and displaced persons hunt for and inquire our site, FRBO.com and originate exotic ranch and penthouse villa.
Empty secluded duplex, suburban bungalow, and convenient house are not to distant in the handy patch of Watsonville.
Drifters, expeditionists, and dwellers who are prospecting Watsonville house rentals and are trying to learn bed and breakfast rentals Watsonville California, rental homes Watsonville California, and home rentals in Watsonville California can look this webpage and our lake indexes, exclusive lists of marked properties, hidden lists of marked properties, and exclusive classified ads.
Observe and determine Strathmore United States rental houses and house rentals Strathmore United States.
The Watsonville mountain ads, decadent classifieds, and decadent directories for these kingdom can be mapped.
Using FRBO.com, rental owners insert chalet, cottage, and house ad directories.
|
|
