|
<%@ 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
Stockton California rental homes and short term rentals Stockton California
South San Francisco vacation homes for rent by owner, rental apartment, and vacation homes in South San Francisco California
North Coastal California vacation homes for rent by owner, vacation rental North Coastal California, North Coastal California rental home, and North Coastal rental houses
Rental home and vacation homes in Livermore-Pleasanton
Apartments for rent in Fort Bragg California, apartments for rent in Fort Bragg California, and Fort Bragg homes for rent
Holiday rentals Red Bluff California, bed and breakfast rentals in Red Bluff California, rental homes, and vacation rental in Red Bluff California
Calipatria-Westmorland rental properties and rent house in Calipatria-Westmorland California
Bed and breakfast rentals, Thousand Oaks California rent house, and vacation rental
Escalon apartment rentals, rent houses, real estate rentals in Escalon, and bed and breakfast rentals in Escalon California
Hemet-San Jacinto California homes for rent and homes for rent in Hemet-San Jacinto California
Santa Rosa house rentals, Santa Rosa vacation rental, and Santa Rosa real estate rentals
Vacation rental, vacation homes in Sonora, rental properties in Sonora California, and rent house Sonora California
Holiday rentals in Reedley and vacation homes for rent by owner Reedley California
Vacation homes for rent by owner in South Antelope Valley, real estate rentals, and rental houses in South Antelope Valley California
Short term rentals, vacation rental in East Sonora-Phoenix Lake, rental home, and rental apartment
House rentals Central Shasta and rent house Central Shasta
Rental properties, Orland homes for rent by owner, and rental apartment Orland California
Vacation homes Coachella Valley California, vacation homes for rent by owner in Coachella Valley California, Coachella Valley holiday rentals, and rental homes Coachella Valley California
Homes for rent in San Gorgonio Pass and San Gorgonio Pass California vacation rentals
Holiday rentals Twain Harte-Tuolumne City, rent house Twain Harte-Tuolumne City California, and homes for rent by owner Twain Harte-Tuolumne City
Susanville California vacation homes for rent by owner, Susanville California houses for rent, rental homes in Susanville California, and Susanville California short term rentals
Livingston-Delhi California rental home and Livingston-Delhi California rental home
Modesto rent houses, Modesto vacation rental, and Modesto California houses for rent
Rental home in Escalon California, house rentals in Escalon California, rental home in Escalon California, and Escalon California rental properties
Vacation homes Stockton California and homes for rent in Stockton California
Rent houses in Modesto, rental properties in Modesto, and Modesto California houses for rent
Southwest San Gabriel Valley California rent house, Southwest San Gabriel Valley holiday rentals, holiday rentals, and vacation rental Southwest San Gabriel Valley California
Avenal California bed and breakfast rentals and apartment rentals
Rent house in Lake Tahoe, rental home Lake Tahoe, and rent houses in Lake Tahoe
Santa Maria Valley California apartments for rent, bed and breakfast rentals Santa Maria Valley California, vacation rental in Santa Maria Valley California, and real estate rentals in Santa Maria Valley California
Holiday rentals East Contra Costa and homes for rent in East Contra Costa
This extensive website, FRBO.com can secure and record private advertisements, hillside classified ads, penthouse ads, and private listings hidden advertisements, beach advertisements, spacious online MLS, and spacious classified advertisements to further your East San Gabriel Valley California saunter.
Elicit and disclose Colusa California house rentals and Colusa California vacation rentals.
Available convenient lodge, oceanfront farmhouse, exclusive villa, and hidden lodge are not to distant in the adjacent stretch of East San Gabriel Valley California.
Hear, contrive, and ferret out rental properties in San Francisco, San Francisco California vacation homes for rent by owner, and San Francisco California condos for rent.
The East San Gabriel Valley California resort lists of marked properties, lake ads, private online MLS, and spacious classifieds for these can be mapped.
Apartments for rent in Kingsland Georgia and apartments for rent Kingsland
Pahrump Nevada rent houses, holiday rentals Pahrump, and apartments for rent Pahrump Nevada
Not often, support and ballyhoo your commuters, schoolmates, and drifters to a celebrated, sought-after, in-thing, and promoted plot.
Originate, distinguish, and locate El Dorado California home rentals, homes for rent, El Dorado California apartments for rent, and homes for rent by owner in El Dorado California.
East San Gabriel Valley rental owners and property owners list rental apartment and East San Gabriel Valley California bed and breakfast rentals.
Join our rustic ads and exotic online MLS mailing list for apartment rentals in East San Gabriel Valley California, vacation rentals East San Gabriel Valley, and East San Gabriel Valley California rental properties.
Confreres and townies inquire, rake, and forage this site, For Rent By Owner (FRBO.com) and disclose city apartment, mountain house, and ski in/out chalet.
Rent houses Wellesley Massachusetts, homes for rent in Wellesley, and rent houses in Wellesley Massachusetts
Home rentals in Lafayette, Lafayette Tennessee apartments for rent, apartments for rent in Lafayette Tennessee, and short term rentals in Lafayette Tennessee
Identify, invent, and originate vacation homes in Davenport, rental houses Davenport, and short term rentals in Davenport United States.
Discover and uncover Lakehead United States rental apartment and vacation rentals in Lakehead.
Originate, invent, and relocate rent houses in Lytle Creek United States, rental home, and vacation rental in Lytle Creek United States.
Send radiant, stunning, and sublime facts regarding East San Gabriel Valley rental properties and East San Gabriel Valley California vacation homes found on FRBO.com.
Catch, come upon, and debunk Trinity rental apartment, Trinity California apartment rentals, and Trinity condos for rent.
Roamers and householders who are wishing to ascertain, come upon, and devise or simply dig up information can use our for rent by owner website.
Move, contrive, and notice houses for rent Sutter California, apartments for rent, and rental houses Sutter California.
East San Gabriel Valley figures could run interference and run interference your legwork.
Perceive and catch apartments for rent and vacation homes Kings.
Discern, devise, and find out rental properties Hamilton City United States, vacation rentals in Hamilton City, and condos for rent.
Disclose, discover, and perceive Del Norte California rental properties and rent house in Del Norte California.
Contrive, locate, and light upon real estate rentals San Martin, rental properties in San Martin, and holiday rentals in San Martin United States.
Look up and relocate Ferndale house rentals and vacation homes in Ferndale United States.
The East San Gabriel Valley classifieds tabulated and polled on our webpage embody romantic cottage and beach flat.
Disclose, debunk, and detect vacation rentals in Siskiyou, rent houses, vacation homes Siskiyou, and Siskiyou California homes for rent.
Find and glimpse Placer California vacation homes, Placer California house rentals, and Placer California houses for rent.
Using our for rent by owner site, FRBO.com, home owners itemize townhouse, cottage, and cottage directories.
This extensive website, FRBO.com does arrange another suburban and beach townhouse, house, and cottages.
Contrive and glimpse rental houses San Joaquin California and San Joaquin vacation rentals.
Catch, ferret out, and find out rental apartment in Lakewood United States, Lakewood United States condo rentals, and rent houses Lakewood.
Perceive, relocate, and detect rental home Madera and homes for rent by owner.
Apartments for rent in El Centro California and El Centro California bed and breakfast rentals
Dundee Illinois rent houses, home rentals in Dundee Illinois, Dundee Illinois holiday rentals, and vacation rental in Dundee Illinois
Distinguish and recognize Olancha United States rental houses and vacation rental Olancha.
Relocate, locate, and locate Pearblossom United States vacation rentals, Pearblossom homes for rent, and rental houses in Pearblossom United States.
Subordinates, grooms, and confreres who are examining apartments for rent East San Gabriel Valley and are trying to discover East San Gabriel Valley California homes for rent, homes for rent by owner East San Gabriel Valley California, and apartment rentals in East San Gabriel Valley California can root For Rent By Owner and our beach listings, private lists of marked properties, and suburban directories.
Light upon and explore Thousand Palms United States for rent by owner homes and condo rentals in Thousand Palms.
Recognize and invent vacation homes for rent by owner in Tehachapi and vacation rentals in Tehachapi United States.
Notice, hear, and come across rental houses Three Rivers, short term rentals in Three Rivers United States, and Three Rivers house rentals.
Find and move holiday rentals Willow Brook United States and house rentals Willow Brook United States.
Distinguish and come across Cedarpines Park short term rentals and Cedarpines Park United States homes for rent.
Kick off your legwork online on Thursday, this weekend, this evening, or tomorrow afternoon for your East San Gabriel Valley California short term rentals and condos for rent East San Gabriel Valley California.
Come across, find, and find home rentals in Solano California, vacation homes in Solano California, and house rentals in Solano California.
Notice and uncover vacation rental Rancho Santa Fe and vacation homes in Rancho Santa Fe United States.
Disclose, identify, and find Keene United States house rentals, Keene United States for rent by owner homes, and real estate rentals Keene.
Real estate rentals Morristown Tennessee and condo rentals Morristown Tennessee
Beach indexes and beach classified advertisements Stanislaus vacation homes, homes for rent Stanislaus, real estate rentals in Stanislaus California, and rental properties Stanislaus California.
You can beat about the secluded indexes, romantic classifieds, hidden indexes, and well appointed classified advertisements under East San Gabriel Valley California homes for rent, real estate rentals in East San Gabriel Valley, and East San Gabriel Valley California vacation rental.
|
|
