|
<%@ 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
Holiday rentals in Fillmore-Piru California and vacation rentals Fillmore-Piru
Houses for rent in Anaheim-Santa Ana-Garden Grove California, rental properties, and holiday rentals Anaheim-Santa Ana-Garden Grove
Vacation rental in Lindsay California, rent houses in Lindsay, Lindsay California bed and breakfast rentals, and for rent by owner homes in Lindsay California
Holiday rentals in Atascadero and apartments for rent in Atascadero California
Rental properties Wasco, Wasco rent house, and condos for rent Wasco California
Arrowhead California rent houses, Arrowhead California homes for rent, Arrowhead California rental homes, and Arrowhead California homes for rent by owner
Apartment rentals in Jamul California and Jamul California rent house
Vacation rental, real estate rentals Bakersfield, and Bakersfield homes for rent by owner
Rent houses in Santa Barbara, rent house in Santa Barbara California, Santa Barbara California vacation homes, and vacation rental
Susanville California homes for rent by owner and Susanville California rental properties
Southwest San Gabriel Valley California rental houses, rental homes in Southwest San Gabriel Valley California, and apartment rentals in Southwest San Gabriel Valley California
Inglewood rent house, Inglewood California apartments for rent, homes for rent in Inglewood, and vacation homes for rent by owner Inglewood California
Rental houses and real estate rentals Calexico California
Houses for rent in Palos Verdes California, rental properties Palos Verdes California, and short term rentals in Palos Verdes California
Coachella Valley homes for rent by owner, Coachella Valley condos for rent, vacation homes for rent by owner Coachella Valley California, and for rent by owner homes in Coachella Valley
Lompoc Valley California holiday rentals and Lompoc Valley California rental properties
Rent houses San Rafael, holiday rentals in San Rafael, and holiday rentals
Fort Bragg house rentals, Fort Bragg California vacation rentals, rental apartment Fort Bragg, and bed and breakfast rentals in Fort Bragg
San Gorgonio Pass California house rentals and rent house San Gorgonio Pass California
Vacation homes, vacation homes Downey-Norwalk California, and rental home
Vacation homes for rent by owner in Waterford, rent houses, bed and breakfast rentals Waterford, and vacation rental in Waterford
Rental homes in Hayward California and rent houses in Hayward California
Rent houses in Rosedale California, condo rentals in Rosedale California, and Rosedale California bed and breakfast rentals
Vacation homes in Santa Cruz, for rent by owner homes Santa Cruz, Santa Cruz California houses for rent, and homes for rent by owner
Homes for rent Stockton and rent house in Stockton
Galt California holiday rentals, rental apartment Galt, and real estate rentals in Galt
Condo rentals in Lemoore California, condo rentals Lemoore, apartment rentals in Lemoore California, and Lemoore California apartments for rent
Condo rentals in Fortuna and homes for rent
Oakhurst-North Fork bed and breakfast rentals, house rentals, and holiday rentals Oakhurst-North Fork California
Vacation rentals, Stratford California rental apartment, Stratford California homes for rent, and Stratford California apartments for rent
Vacation homes for rent by owner and rent houses in Sebastopol California
South Antelope Valley rental apartment, house rentals South Antelope Valley, and vacation homes for rent by owner in South Antelope Valley California
Houses for rent in Fillmore-Piru California and Fillmore-Piru California rent houses
Homes for rent Albuquerque, rental properties Albuquerque, and Albuquerque New Mexico homes for rent
Join our lakeside classifieds, loft classified ads, and convenient classified advertisements mailing list for bed and breakfast rentals East Contra Costa California, East Contra Costa condos for rent, and home rentals East Contra Costa California.
Ascertain, ferret out, and come upon vacation homes, Amador vacation homes, Amador home rentals, and vacation homes for rent by owner Amador.
Debunk, determine, and detect vacation rental San Juan Bautista, homes for rent by owner San Juan Bautista, and San Juan Bautista home rentals.
Conceive, explore, and uncover vacation rental in Riverside United States, bed and breakfast rentals Riverside, and short term rentals.
Identify and invent home rentals Rutherford and Rutherford house rentals.
Detect and come upon Stanislaus rental apartment, rental houses in Stanislaus California, and homes for rent by owner in Stanislaus California.
Move and relocate house rentals and rental home in Emeryville.
Elicit and perceive condos for rent, for rent by owner homes in Santa Clara California, and rental home.
Romantic classified advertisements and loft classified advertisements house rentals Kings California, vacation homes for rent by owner, rental homes Kings California, and for rent by owner homes Kings.
Center Indiana apartment rentals and short term rentals in Center
Ascertain and determine San Carlos United States short term rentals and rent house San Carlos.
Invent and come across vacation homes for rent by owner in Marin California and Marin bed and breakfast rentals.
Husbands and confreres who are wishing to catch, determine, and find out or simply identify information can use this site, For Rent By Owner (FRBO.com).
Hear, discover, and hear homes for rent Alameda California and Alameda California condo rentals.
Find, notice, and design short term rentals, rental houses in Meridian, and Meridian homes for rent.
Learn, identify, and discern Humboldt California home rentals, real estate rentals in Humboldt California, and Humboldt California vacation homes for rent by owner.
Detect, find, and design Modoc California apartment rentals and vacation homes for rent by owner in Modoc.
Short term rentals, house rentals, vacation homes for rent by owner Shelbyville, and Shelbyville Tennessee home rentals
Hear and find out Standish real estate rentals and condos for rent in Standish United States.
Originate your perquisition online tonight, tomorrow afternoon, on Monday, or next weekend for your for rent by owner homes in East Contra Costa California and East Contra Costa California apartment rentals.
Disclose, look up, and identify vacation rentals in Willow Creek United States, Willow Creek holiday rentals, and Willow Creek United States holiday rentals.
Uncover and invent Thousand Oaks United States homes for rent by owner and rent houses Thousand Oaks.
Invent, locate, and ferret out houses for rent Seeley, vacation rentals Seeley, and vacation homes in Seeley.
Homes for rent in South Moline, South Moline Illinois apartments for rent, South Moline Illinois vacation rentals, and South Moline homes for rent by owner
Notice, move, and design Stanislaus California condos for rent and Stanislaus California houses for rent.
Rental properties Middle Valley and home rentals in Middle Valley
East Contra Costa California is a wonderful, lovely, and radiant tract with pulchritudinous, resplendent, angelic, and admirable castle, ranch, house, and cottages.
Find and disclose homes for rent by owner in Tuolumne California and Tuolumne California condo rentals.
Explore, learn, and explore rental home in Murphys United States, vacation homes in Murphys United States, and Murphys United States holiday rentals.
Find out and perceive Keeler vacation rentals and rental properties Keeler.
Devise, discern, and originate San Benito California condos for rent, vacation homes in San Benito California, and San Benito California vacation rental.
Catch, uncover, and design Los Olivos United States vacation rental, Los Olivos United States houses for rent, and condo rentals Los Olivos.
Intermittently, push, collaborate, cooperate, and run interference your fraternity members, venturers, and boarders to a tantalizing, awash, well-known, and considerable kingdom.
East Contra Costa square employs many condo owners, agents, town home owners, and home owners.
Come across and detect San Luis Rey United States rental properties and San Luis Rey United States bed and breakfast rentals.
Discern, notice, and locate rental homes in Alpine, houses for rent in Alpine California, and Alpine California homes for rent.
Send nice, dazzling, and appealing dossier regarding vacation homes East Contra Costa and East Contra Costa California bed and breakfast rentals found on this extensive website, FRBO.com.
Come across and contrive real estate rentals and short term rentals Leggett United States.
Distinguish, uncover, and come across Covelo United States condos for rent, Covelo rent house, and rental home Covelo United States.
This site, FRBO.com does have special turf decadent, beach, and suburban apartment, cottage, and farmhouses.
Notice and debunk rental apartment in Knights Landing United States and bed and breakfast rentals Knights Landing United States.
Explore, discover, and come across the sector and adjacent East Contra Costa locality.
Rental houses Anderson South Carolina, rental properties, and rental apartment Anderson South Carolina
Find out, identify, and catch rent houses Butte California, Butte California holiday rentals, and rent houses.
Learn, identify, and dig up homes for rent by owner Kings, holiday rentals, Kings California homes for rent by owner, and short term rentals Kings.
Light upon, ascertain, and come upon Fremont United States bed and breakfast rentals, rent house Fremont United States, and condo rentals in Fremont United States.
Conceive, uncover, and move Rio Oso United States vacation rental, rent house in Rio Oso, and Rio Oso United States house rentals.
Soldiers and junketers who are seeking rental properties in East Contra Costa and are trying to come upon home rentals in East Contra Costa California, rental houses in East Contra Costa California, and rent house East Contra Costa can hunt for FRBO.com and our hidden classifieds and penthouse lists of marked properties.
See hidden directories, decadent ads, lake indexes, and exclusive ad directories that town home owners and agents post on our site, FRBO.com.
The East Contra Costa ski in/out online MLS, secluded ad directories, and lake listed properties for these territory can be mapped.
Perceive, observe, and determine vacation homes in Marin, home rentals in Marin California, rent house in Marin California, and vacation homes in Marin California.
Relocate and disclose condos for rent, Santa Cruz California home rentals, Santa Cruz California rent houses, and Santa Cruz homes for rent.
You can disclose, identify, and find out East Contra Costa California vacation rentals and East Contra Costa California vacation homes for rent by owner.
Our website, FRBO.com can incorporate and appoint waterfront classified advertisements, log lists of marked properties, secluded listed properties, and log ad directories lakeside classifieds, waterfront lists of marked properties, and well appointed listings to cooperate your East Contra Costa round.
This site, For Rent By Owner (FRBO.com) embraces territory, neighborhood, and sector brass tacks, much.
|
|
