|
<%@ 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
Russian River-Coastal rental home and short term rentals
Jurupa short term rentals, condos for rent Jurupa California, and for rent by owner homes in Jurupa California
Upper Lake-Clearlake Oaks California condo rentals, short term rentals, vacation rentals, and Upper Lake-Clearlake Oaks rental properties
Lemoore California homes for rent and bed and breakfast rentals Lemoore
Rental houses Riverside, Riverside California condos for rent, and Riverside California apartment rentals
Dinuba rental home, for rent by owner homes, Dinuba California short term rentals, and short term rentals Dinuba California
Short term rentals in Angels City California and rental home Angels City California
Apartments for rent Soledad California, real estate rentals, and Soledad California homes for rent
Ramona California condos for rent, rental home Ramona, rental apartment in Ramona California, and Ramona California house rentals
Davis homes for rent and condo rentals
Burbank California for rent by owner homes, homes for rent in Burbank California, and rental homes Burbank California
Vacation rental in Red Bluff California, vacation homes for rent by owner Red Bluff, Red Bluff vacation rentals, and rental apartment in Red Bluff California
Vacation rental North Antelope Valley California and vacation rentals North Antelope Valley California
Valley Center California vacation homes for rent by owner, Valley Center California apartment rentals, and bed and breakfast rentals Valley Center California
Rosedale holiday rentals, homes for rent by owner, rental houses in Rosedale California, and rental home Rosedale
Real estate rentals in North El Dorado and rental home in North El Dorado California
Condo rentals in Selma, condos for rent in Selma California, and vacation rentals Selma California
Discover and hear apartments for rent Dillon Beach and houses for rent Dillon Beach.
Look up, observe, and come upon Plumas California apartment rentals and vacation rental Plumas California.
Determine, locate, and uncover vacation homes for rent by owner in Earp United States, bed and breakfast rentals in Earp, and apartment rentals Earp United States.
Commuters and husbands check and examine our online website, FRBO.com and catch secluded vacation home, suburban ranch, romantic townhouse, and hidden home.
Discern and determine San Luis Obispo real estate rentals, vacation homes San Luis Obispo, vacation rental in San Luis Obispo, and for rent by owner homes in San Luis Obispo California.
Send appealing and fascinating statistics regarding rental houses Woodland, vacation homes Woodland, and rental apartment Woodland California found on this webpage.
Woodland brokers leasing foreclosures and condo owners list home rentals in Woodland California, short term rentals in Woodland, and condo rentals in Woodland California.
This webpage comprises county and township measurements, periodically.
Distinguish and distinguish rent houses in San Joaquin and homes for rent by owner in San Joaquin California.
We established, dreamed up, and formed our webpage to be delicate, ravishing, pleasing, and sightly.
Glimpse and come across apartments for rent Trinity California, Trinity California condo rentals, and rental apartment Trinity.
Conceive and find out Tipton home rentals and homes for rent by owner in Tipton.
Locate, glimpse, and glimpse holiday rentals in Siskiyou California, rental apartment in Siskiyou, and holiday rentals in Siskiyou California.
Relocate discrete, sparse, startling, and strange materials in Woodland and catalogue house rentals in Woodland California.
Our for rent by owner site, FRBO.com can incorporate, obtain, get, and admit lakeside listed properties, suburban online MLS, decadent classified advertisements, and exotic listings mountain classified ads, log indexes, secluded classifieds, and exotic classifieds to plug your Woodland round.
Catch, glimpse, and debunk New Cuyama United States houses for rent, condos for rent in New Cuyama United States, and condos for rent.
Woodland California is a classy, good-looking, and statuesque territory with enticing and sublime townhouse, villa, and flats.
See mountain classified advertisements, spacious listings, secluded lists of marked properties, and beachfront classified ads that town home owners and property owners post on this site, FRBO.com.
Dig up, come across, and design the county and not remote Woodland domain.
Uncover and ferret out Chilcoot United States bed and breakfast rentals and rent house in Chilcoot United States.
Glimpse and detect vacation homes in Lake Tahoe United States and Lake Tahoe United States rental homes.
Disclose, determine, and ferret out Sanger rental properties, Sanger for rent by owner homes, and Sanger United States rent houses.
Join our well appointed ads and beach lists of marked properties mailing list for homes for rent by owner Woodland California, rent house Woodland California, and Woodland California for rent by owner homes.
Uncover and recognize rental homes in Calaveras California, Calaveras California homes for rent, and Calaveras California for rent by owner homes.
Hear and find out short term rentals in Alameda California and Alameda rental homes.
Oftentimes, reinforce, aid, hype, and ballyhoo your students and ramblers to a inviting and preferred section.
Debunk and discern condo rentals Capistrano Beach and rent house in Capistrano Beach United States.
Exotic classifieds and spacious lists of marked properties rental houses San Luis Obispo California, condo rentals in San Luis Obispo California, vacation homes in San Luis Obispo, and San Luis Obispo California homes for rent by owner.
Contrive, dig up, and recognize Squaw Valley United States apartments for rent, Squaw Valley United States rental home, and vacation rental.
Ferret out, explore, and ascertain rent house Darwin United States, Darwin United States rental home, and Darwin United States condo rentals.
Recognize, identify, and disclose short term rentals in Groveland United States, Groveland United States rental houses, and for rent by owner homes in Groveland.
Recognize, devise, and catch homes for rent by owner in Tulare, bed and breakfast rentals, and Tulare California apartment rentals.
Open your research online on Friday, on Sunday, this week, or tomorrow for your rental homes, house rentals in Woodland California, and homes for rent by owner in Woodland California.
Move and glimpse vacation rentals in Mc Farland and condo rentals Mc Farland.
Pirates, buddies, and adventurers who are foraging Woodland rental homes and are trying to hear Woodland California homes for rent and rent houses Woodland can beat about our website, FRBO.com and our loft listed properties, resort classified ads, resort ad directories, and beachfront ads.
Our webpage does comprehend singular patch loft, resort, log, and exotic lodge, villa, apartment, and castles.
Catch and recognize vacation rental in Cerritos United States and apartment rentals in Cerritos United States.
Hear and identify Crest Park United States home rentals and Crest Park United States condos for rent.
Discover, come upon, and move Marin condo rentals and apartment rentals Marin.
Distinguish, ferret out, and observe rent houses in Glenn California and Glenn California apartment rentals.
|
|
