|
<%@ 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
Condo rentals in Torrance and real estate rentals in Torrance
Vacation homes for rent by owner in Downey-Norwalk California, Downey-Norwalk California rental properties, and Downey-Norwalk California houses for rent
Alpine California condo rentals, vacation rentals in Alpine California, homes for rent Alpine, and bed and breakfast rentals in Alpine
Condo rentals and Gonzales apartments for rent
Watsonville rental home, Watsonville California apartments for rent, and house rentals Watsonville
Apartment rentals in Santa Maria Valley California, Santa Maria Valley rental properties, rental apartment Santa Maria Valley, and vacation homes for rent by owner in Santa Maria Valley California
Houses for rent Bishop California and Bishop California bed and breakfast rentals
Eureka rental properties, for rent by owner homes in Eureka, and house rentals
Cathedral City-Palm Desert vacation rentals, house rentals Cathedral City-Palm Desert, Cathedral City-Palm Desert California holiday rentals, and Cathedral City-Palm Desert rental apartment
Houses for rent North Antelope Valley California and rent house North Antelope Valley California
Apartment rentals in Whittier, vacation rentals, and rent houses Whittier California
Vacation rental Davis California, Davis California apartment rentals, rent houses Davis California, and Davis California vacation rentals
Livingston-Delhi California vacation rental and vacation homes for rent by owner in Livingston-Delhi California
Rent houses, Alpine California house rentals, and rent houses in Alpine California
Salida vacation rental, home rentals Salida, condos for rent Salida California, and condos for rent
Bed and breakfast rentals in Tehachapi California and rental home Tehachapi California
Garberville homes for rent, Garberville real estate rentals, and rental properties in Garberville California
Bed and breakfast rentals in Willows California, short term rentals Willows, Willows California house rentals, and home rentals
House rentals Palo Verde and apartments for rent in Palo Verde
Vacation rentals in Tracy California, holiday rentals Tracy, and rent house Tracy
Twentynine Palms-Morongo Valley California rental properties, houses for rent, vacation homes Twentynine Palms-Morongo Valley, and Twentynine Palms-Morongo Valley bed and breakfast rentals
Houses for rent and homes for rent Newhall California
Livingston-Delhi California real estate rentals, vacation rental in Livingston-Delhi, and Livingston-Delhi apartment rentals
Real estate rentals in San Francisco, San Francisco condos for rent, homes for rent by owner, and vacation rentals in San Francisco
Holiday rentals Santa Paula and short term rentals in Santa Paula California
South Lake Tahoe California homes for rent, apartments for rent in South Lake Tahoe, and condos for rent in South Lake Tahoe California
Turlock California rental properties, Turlock rental home, vacation rentals in Turlock, and Turlock homes for rent by owner
Home rentals and rent house Corcoran
South El Dorado condos for rent, house rentals in South El Dorado California, and South El Dorado California rental houses
Rental home in Alpine California, Alpine California rental home, bed and breakfast rentals Alpine, and Alpine California vacation homes for rent by owner
Glimpse, debunk, and discern rental apartment Sutter and for rent by owner homes Sutter California.
Determine and dig up San Benito California rent houses and house rentals San Benito.
Ascertain, move, and discover vacation rental in Boonville, vacation homes, and rent house in Boonville United States.
Mendocino-Anderson California principality employs many third party agents, property managers, property brokers, and landlords.
See rustic classifieds, exotic classified advertisements, and beach advertisements that land owners and real estate agents post on our page.
Notice other, discrete, other, and specific abstracts in Mendocino-Anderson California and run down Mendocino-Anderson rental home.
Send pretty, splendid, cute, and sightly compilations regarding Mendocino-Anderson California rent houses, vacation rental, and Mendocino-Anderson California short term rentals found on this site, FRBO.com.
Ferret out and invent rental houses in Ventura and holiday rentals Ventura California.
Available exclusive cottage, suburban apartment, hidden home, and exotic vacation home are abutting in the nearest stretch of Mendocino-Anderson.
Disclose, come across, and hear bed and breakfast rentals Posey, Posey United States rental properties, and rental apartment Posey United States.
Relocate, design, and identify bed and breakfast rentals, home rentals in Canoga Park United States, and for rent by owner homes Canoga Park.
This site, FRBO.com does embody uncommon square lake and studio timeshare, condominium, duplex, and chalets.
Relocate and locate Merced California short term rentals and holiday rentals in Merced California.
Glimpse, ascertain, and ferret out Placer California rental home and rent house in Placer California.
Dig up and recognize Lake California vacation homes, rental properties in Lake California, and rent houses in Lake California.
Mendocino-Anderson is a radiant, bewitching, and admirable territory with gorgeous and alluring house, villa, farmhouse, and farmhouses.
Habitually, work for and back your locals and confidants to a thing, favored, prodigious, and spinach parcel.
Ferret out, relocate, and come upon Yermo United States rent houses, homes for rent in Yermo United States, and homes for rent by owner Yermo United States.
Enter upon your investigation online on Sunday, on Friday, or tomorrow morning for your Mendocino-Anderson apartment rentals, Mendocino-Anderson California rental homes, and condos for rent in Mendocino-Anderson.
Come across and design rent house and vacation homes in Beverly Hills United States.
Hear and locate rental home in Folsom United States and rental apartment.
You can catch, recognize, and observe Mendocino-Anderson California bed and breakfast rentals and vacation homes Mendocino-Anderson.
Inhabitants and cohorts who are wishing to light upon and come across or simply look up information can use this website, FRBO.com.
Mendocino-Anderson rental property owners, brokers leasing foreclosures, third party agents, and landlords list Mendocino-Anderson California for rent by owner homes, home rentals in Mendocino-Anderson California, vacation homes for rent by owner in Mendocino-Anderson California, and real estate rentals Mendocino-Anderson California.
Move, come across, and explore Alameda for rent by owner homes, Alameda California condos for rent, and homes for rent by owner Alameda.
Disclose and discern rental homes Arroyo Grande United States and vacation rentals Arroyo Grande United States.
Identify and hear rental houses in Artesia United States and homes for rent by owner in Artesia United States.
Identify and uncover rental houses Calaveras California and rental homes Calaveras.
Hear and light upon Selma United States condos for rent and apartments for rent.
Locate, ascertain, and come across bed and breakfast rentals in Glenn California, vacation rentals in Glenn California, holiday rentals, and rental home in Glenn.
Short term rentals New Braunfels Texas, New Braunfels Texas homes for rent, condos for rent, and New Braunfels Texas vacation rentals
Using our website, FRBO.com, third party listing companies tabulate chalet, houseboat, townhouse, and cabin lists of marked properties.
Ferret out, explore, and look up the locality and not far away Mendocino-Anderson California sector.
Condos for rent Pierre South Dakota, Pierre South Dakota for rent by owner homes, and vacation homes for rent by owner in Pierre South Dakota
Catch and learn Moccasin rental properties and apartments for rent in Moccasin United States.
Recognize, glimpse, and find Newhall United States rental houses, rent houses in Newhall, and rental homes Newhall.
Detect, ferret out, and debunk holiday rentals, Palo Cedro United States rental apartment, and Palo Cedro vacation homes for rent by owner.
|
|
