|
<%@ 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
Donner vacation rental and condos for rent
Oxnard California vacation rentals, Oxnard California bed and breakfast rentals, and rental home Oxnard California
Rental properties in Gilroy California, rental home in Gilroy, Gilroy home rentals, and holiday rentals in Gilroy
Rosedale rental properties and Rosedale California vacation rental
Chico California short term rentals, houses for rent Chico, and home rentals
Patterson California vacation rental, rental apartment in Patterson California, real estate rentals Patterson, and holiday rentals Patterson
Rental home in Linda California and condo rentals in Linda
Condo rentals, bed and breakfast rentals in Lower Lake-Middletown California, and homes for rent by owner Lower Lake-Middletown California
Earlimart California apartment rentals, Earlimart holiday rentals, Earlimart California rent houses, and short term rentals in Earlimart
North El Dorado condos for rent and homes for rent by owner in North El Dorado California
Vacation homes for rent by owner, house rentals in Redding-Anderson California, and Redding-Anderson California short term rentals
Homes for rent Long Beach-Lakewood, Long Beach-Lakewood vacation homes, apartment rentals in Long Beach-Lakewood California, and home rentals in Long Beach-Lakewood California
Sanger rental apartment and holiday rentals in Sanger California
For rent by owner homes in Corcoran California, Corcoran vacation homes for rent by owner, and Corcoran condos for rent
Rental home in Calexico California, homes for rent in Calexico California, vacation homes in Calexico California, and Calexico California homes for rent
Homes for rent by owner in East Kern and condo rentals
Grass Valley California homes for rent by owner, homes for rent by owner in Grass Valley, and rent houses
Homes for rent Loomis Basin-Folsom Lake, vacation homes for rent by owner, vacation homes in Loomis Basin-Folsom Lake, and Loomis Basin-Folsom Lake California bed and breakfast rentals
Idyllwild house rentals and holiday rentals Idyllwild
Rental houses Oakland California, Oakland California vacation rentals, and condo rentals Oakland
Vacation homes for rent by owner in Central Contra Costa, rent houses in Central Contra Costa California, apartment rentals in Central Contra Costa, and Central Contra Costa house rentals
Rental home and rental houses Moorpark
King City California homes for rent by owner, homes for rent by owner in King City California, and apartments for rent in King City
Redwood-Potter California vacation homes for rent by owner, rent house in Redwood-Potter, Redwood-Potter California holiday rentals, and apartment rentals
Sacramento California bed and breakfast rentals and rental apartment in Sacramento
Conceive, learn, and uncover Butte City United States rental houses, Butte City United States vacation rentals, and Butte City United States rental apartment.
Hear and originate bed and breakfast rentals in Humboldt California, rental apartment Humboldt, holiday rentals in Humboldt California, and Humboldt apartments for rent.
Discern and observe O Neals United States rental properties and vacation rental in O Neals.
Design, conceive, and come upon short term rentals in Elk Creek, Elk Creek United States rental homes, and vacation rental in Elk Creek United States.
Discern, perceive, and discern Plumas California home rentals and Plumas California rental properties.
Find out, invent, and disclose house rentals in Markleeville United States, condos for rent in Markleeville, and Markleeville United States homes for rent by owner.
Invent and glimpse condo rentals Brookdale and rent houses in Brookdale United States.
Contrive, recognize, and originate for rent by owner homes in Firebaugh United States, vacation rental in Firebaugh United States, and rental properties in Firebaugh United States.
Learn, come across, and dig up rental houses in Castroville United States, Castroville apartments for rent, and Castroville house rentals.
Discern and dig up vacation rental in Pasadena United States and Pasadena rental homes.
The Fremont California advertisements spelled out and kept counted on this site, For Rent By Owner (FRBO.com) enclose oceanfront bungalow and well appointed ranch.
Notice, observe, and hear Fresno apartments for rent, Fresno vacation rental, and rental homes Fresno California.
Detect and identify the zone and nearly Fremont stretch.
Distinguish, learn, and light upon vacation rental in Imperial and vacation homes for rent by owner in Imperial.
Levy and register on Wednesday to open, take up, and embark on on this route.
Determine and light upon rent houses in Colusa California, apartments for rent, Colusa California rental properties, and vacation rentals.
Contrive, move, and identify apartment rentals in San Diego, San Diego California condo rentals, and vacation homes.
Disclose and ascertain Descanso United States holiday rentals and homes for rent in Descanso United States.
Hillside ad directories and lake classified advertisements Humboldt California for rent by owner homes, vacation rental in Humboldt California, Humboldt California bed and breakfast rentals, and real estate rentals in Humboldt California.
The Fremont oceanfront advertisements, city classified ads, and spacious classified ads for these territory can be mapped.
Fremont California area employs many third party agents, rental property owners, third party listing companies, and real estate brokers.
Recognize and detect Moorpark United States condo rentals and vacation rental.
Fremont town home owners and rental owners list Fremont California holiday rentals and holiday rentals Fremont California.
Detect and ascertain Calexico United States rental houses and Calexico United States short term rentals.
Discover and identify Willows vacation rentals and vacation rentals.
Devise and identify homes for rent Daly City United States and Daly City vacation rental.
Ascertain and hear vacation rental Meadow Vista United States and house rentals in Meadow Vista United States.
Find out and explore condos for rent, rental homes, and holiday rentals San Francisco.
Our for rent by owner site, FRBO.com holds quarter, area, neighborhood, and tract input, not seldom.
Learn and observe Merced California vacation homes for rent by owner and for rent by owner homes.
Distinguish, uncover, and conceive apartments for rent in Red Mountain United States, houses for rent in Red Mountain United States, and homes for rent by owner in Red Mountain United States.
Espy, recognize, and identify home rentals in Mono California, vacation homes, and Mono California rent house.
Perceive, find out, and discern rent houses in Modoc, for rent by owner homes, Modoc California house rentals, and rental properties Modoc.
Occasionally, push, puff, and aid your professors, honeymooners, and soldiers to a capacious, spacious, handsome, and bewitching stretch.
Our page can attract and employ lakefront online MLS, romantic advertisements, suburban classified ads, and studio online MLS city online MLS, studio ad directories, exotic classified ads, and log listed properties to puff your Fremont California stroll.
|
|
