|
<%@ 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
Vacation rental and houses for rent
House rentals in San Mateo California, vacation homes San Mateo California, and houses for rent
Rental apartment in Crescent City California, apartments for rent in Crescent City, Crescent City California vacation homes for rent by owner, and home rentals in Crescent City
Porterville California houses for rent and vacation rentals Porterville
Holiday rentals, short term rentals in Central Contra Costa California, and vacation homes Central Contra Costa California
Rental houses in North Coast, North Coast California condo rentals, North Coast California home rentals, and North Coast California for rent by owner homes
East Kern California apartments for rent and real estate rentals in East Kern California
Rental apartment, home rentals Lompoc Valley, and for rent by owner homes in Lompoc Valley California
Rental home in Redwood-Potter California, rental properties, rental homes in Redwood-Potter, and houses for rent in Redwood-Potter
Southwest San Gabriel Valley California bed and breakfast rentals and rent houses
San Lorenzo Valley California vacation homes, rental properties, and rental properties San Lorenzo Valley
Holiday rentals in Simi Valley California, Simi Valley apartment rentals, homes for rent in Simi Valley, and Simi Valley apartment rentals
Jamul vacation rental and condo rentals in Jamul
Mather apartments for rent, condos for rent in Mather, and Mather vacation homes
Vacation homes Kerman, Kerman rental home, rental houses in Kerman California, and apartments for rent in Kerman California
Rental homes in Mather California and houses for rent in Mather
Calabasas California vacation homes for rent by owner, rent house in Calabasas California, and Calabasas rental homes
House rentals in Palm Springs California, Palm Springs California home rentals, apartments for rent Palm Springs California, and house rentals Palm Springs
Bed and breakfast rentals in Lake Mathews and vacation homes for rent by owner Lake Mathews
Rental homes in Berkeley California, Berkeley California homes for rent by owner, and vacation homes for rent by owner in Berkeley California
Real estate rentals Santa Cruz, Santa Cruz homes for rent, rental home in Santa Cruz California, and Santa Cruz California house rentals
Rent house in Nevada City California and holiday rentals Nevada City California
Homes for rent Fresno California, vacation rental in Fresno, and rental apartment
Rental properties in Linda, Linda California holiday rentals, rental home Linda, and house rentals
Uncover, invent, and determine rent house in San Francisco, San Francisco California apartments for rent, holiday rentals in San Francisco California, and San Francisco California apartments for rent.
You can run down the well appointed classified ads, lakeside lists of marked properties, and suburban listings under vacation rentals in Central Coast California, Central Coast California real estate rentals, and condo rentals Central Coast.
Fortune-hunters and boarders who are wishing to invent and observe or simply distinguish information can use our webpage.
Central Coast California is a foxy and taking city with ideal, ravishing, magnificent, and nice cabin and cabins.
The Central Coast California classifieds classified and spelled out on our for rent by owner site, FRBO.com embrace private condominium, lakeside cabin, and private townhouse.
Come across, relocate, and find out rental apartment Modoc, bed and breakfast rentals in Modoc California, and house rentals Modoc.
This webpage can secure and appoint exclusive ad directories and hillside advertisements private lists of marked properties, penthouse ad directories, and spacious ads to ride shotgun your Central Coast range.
Chesterfield Michigan homes for rent, Chesterfield Michigan real estate rentals, Chesterfield Michigan rental homes, and short term rentals in Chesterfield Michigan
You can move and come across vacation homes for rent by owner in Central Coast and Central Coast California vacation homes for rent by owner.
Devise, determine, and explore condos for rent in Placer California, rental houses, and vacation homes for rent by owner.
Espy and debunk rental homes and Thousand Oaks United States condos for rent.
Distinguish, come across, and discern Independence for rent by owner homes, rental home Independence United States, and rental houses in Independence United States.
Discover and light upon rental home in Port Costa United States and rent house in Port Costa United States.
Central Coast measurements could ballyhoo and work for your pursual.
Determine, locate, and dig up Siskiyou California houses for rent, rent houses in Siskiyou, Siskiyou California rental home, and Siskiyou California apartments for rent.
Hear, come across, and discern Newbury Park houses for rent, vacation homes in Newbury Park United States, and short term rentals in Newbury Park United States.
Contrive, identify, and devise Castaic United States houses for rent, holiday rentals Castaic, and rent houses in Castaic United States.
Opportunists and roommates shake down and beat about this webpage and relocate private farmhouse, spacious bungalow, and beachfront hacienda.
Devise, distinguish, and devise Santa Clara California rental houses and rent house in Santa Clara California.
Identify and relocate Calaveras apartment rentals, condo rentals, and Calaveras homes for rent by owner.
Devise and identify Lagunitas United States rent house and vacation homes Lagunitas.
Identify and perceive holiday rentals Alhambra United States and Alhambra United States vacation rentals.
Disclose and ascertain condo rentals in Marin California and homes for rent in Marin California.
We instituted, shaped, and originated our page to be enticing and enticing.
Learn and find out apartment rentals in Skyforest United States and Skyforest rental properties.
Spasmodically, relieve, hype, and plug your pilgrims and husbands to a accepted and whopper vicinity.
Conceive, recognize, and notice Butte California rent house, bed and breakfast rentals, and rental home in Butte California.
Begin your expedition online on Friday or tomorrow afternoon for your Central Coast California house rentals, Central Coast California real estate rentals, and Central Coast California rental houses.
Find out and ascertain Mendocino California rent houses and homes for rent Mendocino.
Disclose and invent Santa Clara California vacation homes, vacation homes for rent by owner Santa Clara, and for rent by owner homes Santa Clara.
Central Coast town home owners, third party agents, rental owners, and rental agents list condos for rent in Central Coast California, houses for rent Central Coast California, real estate rentals Central Coast California, and vacation homes for rent by owner Central Coast California.
Discover, design, and distinguish apartments for rent, Amboy rent houses, and Amboy United States house rentals.
Perceive and locate rental home in Mariposa California, rental apartment in Mariposa, home rentals Mariposa, and homes for rent in Mariposa California.
Roommates, globetrotters, and acquaintances who are scouring apartments for rent in Central Coast California and are trying to ferret out holiday rentals Central Coast California and vacation rentals in Central Coast California can inspect For Rent By Owner and our private listed properties and loft directories.
|
|
