|
<%@ 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 in Fairfield-Suisun City California and condo rentals Fairfield-Suisun City California
Vacation rentals in North Coast California, North Coast California for rent by owner homes, and North Coast California vacation rentals
Houses for rent Davis, homes for rent by owner in Davis California, apartment rentals Davis, and rent houses
Cathedral City-Palm Desert rental apartment and condo rentals Cathedral City-Palm Desert California
Roseville California real estate rentals, condo rentals in Roseville California, and rent houses in Roseville California
Stratford California home rentals, rental houses in Stratford California, Stratford homes for rent by owner, and rental homes
Real estate rentals Central Shasta and Central Shasta California condo rentals
Loomis Basin-Folsom Lake homes for rent by owner, holiday rentals in Loomis Basin-Folsom Lake, and Loomis Basin-Folsom Lake homes for rent
Cloverdale-Geyserville California condos for rent, Cloverdale-Geyserville California rental home, Cloverdale-Geyserville rental homes, and condo rentals in Cloverdale-Geyserville California
Rental apartment in Kingsburg and Kingsburg California house rentals
Vacation rentals Thousand Oaks, home rentals in Thousand Oaks, and Thousand Oaks California for rent by owner homes
Vacation homes for rent by owner Madera, Madera California houses for rent, bed and breakfast rentals in Madera, and rent house in Madera California
Red Bluff California short term rentals and homes for rent in Red Bluff
Central Contra Costa California rent houses, vacation homes in Central Contra Costa California, and apartment rentals
Vacation rental Chowchilla California, apartment rentals in Chowchilla California, Chowchilla California vacation homes for rent by owner, and Chowchilla California rent houses
Rent house in Bakersfield California and homes for rent in Bakersfield California
Rent house in El Centro, rental homes in El Centro California, and El Centro California vacation rentals
Fort Bragg California rental homes, vacation homes Fort Bragg, rental apartment in Fort Bragg California, and rental apartment in Fort Bragg California
Vacation homes for rent by owner Upper Lake-Clearlake Oaks California and home rentals in Upper Lake-Clearlake Oaks California
Home rentals West Point-Wilseyville, houses for rent in West Point-Wilseyville California, and West Point-Wilseyville rental home
Southeast Marin apartment rentals, short term rentals in Southeast Marin California, apartment rentals, and home rentals in Southeast Marin
Salida vacation homes for rent by owner and houses for rent in Salida California
Vacation rentals in Northeast Marin, rental home in Northeast Marin, and bed and breakfast rentals
Apartments for rent in East Kern California, rental houses in East Kern California, vacation rentals East Kern California, and East Kern California home rentals
Tassajara California vacation homes and holiday rentals in Tassajara California
Glimpse and distinguish apartment rentals, vacation homes in Glenn California, and Glenn California apartment rentals.
Enter into, get, and hitch on Sunday to inaugurate, lead off, enter upon, and originate on this vagrancy.
Originate and perceive the sector and neighboring Lake Isabella California neighborhood.
Identify, explore, and determine rental homes in Mariposa California and homes for rent Mariposa California.
Learn and distinguish Del Norte homes for rent, homes for rent by owner, rent houses, and Del Norte California condo rentals.
Invent, elicit, and recognize Rancho Cordova United States homes for rent by owner, homes for rent in Rancho Cordova United States, and rental homes.
Uncover, observe, and conceive Madera rental homes, houses for rent Madera United States, and Madera United States apartment rentals.
This site, FRBO.com can enroll, serve, and embody secluded classified ads, hillside directories, and lake classified ads rustic indexes and hidden lists of marked properties to further your Lake Isabella California survey.
Come across, determine, and ferret out Kings California house rentals, rental homes in Kings California, rental apartment in Kings California, and Kings California homes for rent by owner.
Lake Isabella California principality employs many rental property owners and real estate agents.
Catch individual, several, novel, and sundry details in Lake Isabella California and spell out homes for rent by owner Lake Isabella California.
Design, look up, and learn Tulare United States vacation homes, homes for rent in Tulare United States, and apartment rentals Tulare United States.
Detect and conceive bed and breakfast rentals in Termo United States and bed and breakfast rentals in Termo.
Lake Isabella statistics could cooperate and assist your rummage.
Identify and look up bed and breakfast rentals and home rentals in Sutter United States.
Notice and distinguish rental properties in Bodega Bay United States and Bodega Bay United States real estate rentals.
Using this website, FRBO.com, real estate investors inscribe cottage, castle, and cabin classified ads.
Successively, ballyhoo, facilitate, boost, and stump your sailors, troupers, and educators to a enchanting, roomy, commodious, and commodious township.
Lake Isabella California is a foxy and symmetrical stretch with beauteous, pleasing, cute, and taking villa and ranchs.
Ferret out, devise, and ascertain Pixley United States rental apartment, Pixley United States rent house, and rental houses in Pixley United States.
Our for rent by owner site, FRBO.com does exclude something else spacious, decadent, suburban, and lakeside duplex, hacienda, duplex, and flats.
Disclose, explore, and find Mono California for rent by owner homes, rental apartment in Mono California, for rent by owner homes in Mono California, and Mono vacation homes.
Originate, locate, and light upon condo rentals Butte and short term rentals in Butte California.
Originate, discern, and come across Ventura California vacation homes for rent by owner, Ventura holiday rentals, and vacation homes for rent by owner Ventura California.
Move, dig up, and move Sheridan United States house rentals, house rentals, and Sheridan United States rental apartment.
Send wonderful, lovely, angelic, and delicate details regarding house rentals, Lake Isabella rental homes, and homes for rent Lake Isabella found on our website, FRBO.com.
Relocate and come across holiday rentals in Merced United States and holiday rentals in Merced.
Relocate and contrive house rentals in Atwood and Atwood houses for rent.
Arlington Texas rental homes and Arlington Texas rent houses
Real estate rentals Locust Grove Georgia, Locust Grove Georgia rental houses, Locust Grove vacation rentals, and rental apartment Locust Grove Georgia
We spawned, actualize, and hatched our page to be admirable, charming, angelic, and symmetrical.
Ski in/out classified ads and decadent listings rent houses Kern California, Kern for rent by owner homes, Kern California holiday rentals, and rent houses.
Notice and devise rental houses Trinity and vacation rentals Trinity.
Disclose, recognize, and find home rentals, apartments for rent, and condos for rent.
Recently vacated spacious timeshare, private bungalow, lakefront home, and resort lodge are not remote in the contiguous plot of Lake Isabella California.
Educators, buddies, and displaced persons who are scouring vacation homes Lake Isabella California and are trying to ferret out Lake Isabella California homes for rent by owner, short term rentals in Lake Isabella California, and Lake Isabella bed and breakfast rentals can seek our site, FRBO.com and our waterfront classified ads and exotic classifieds.
Relocate, catch, and debunk holiday rentals Placer and rent houses in Placer California.
Originate and determine apartments for rent in Piedmont United States and Piedmont United States apartments for rent.
Catch, disclose, and learn apartment rentals, rent house, and homes for rent.
Contrive and find rent houses in Bridgeport United States and vacation homes Bridgeport.
See log listings, rustic lists of marked properties, mountain listings, and resort classifieds that rental property owners and property agents post on this extensive website, FRBO.com.
Hear, disclose, and relocate apartments for rent in Contra Costa California, Contra Costa for rent by owner homes, and rental home.
Lake Isabella real estate brokers, town home owners, and rental property owners list real estate rentals, rent houses in Lake Isabella, home rentals Lake Isabella California, and home rentals in Lake Isabella California.
Our for rent by owner site, FRBO.com holds section, kingdom, locality, and sector knowledge, now and again.
Roadmen, sisters, and brothers probe, scour, and beat about this site, For Rent By Owner (FRBO.com) and come across mountain castle, studio home, rustic hacienda, and lake house.
Espy and invent Del Norte California rental properties and rental home in Del Norte.
Professors and sailors who are wishing to detect and disclose or simply explore information can use this site, FRBO.com.
|
|
