|
<%@ 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
Real estate rentals Big Bear California and house rentals
Santa Barbara for rent by owner homes, houses for rent Santa Barbara, and Santa Barbara California apartment rentals
Vacation rentals in Simi Valley, real estate rentals Simi Valley, Simi Valley California rental homes, and Simi Valley rental apartment
Valley Center rental properties and Valley Center California rent house
Houses for rent, Central Coast California rent houses, and Central Coast California rental properties
Rent house in Lodi California, homes for rent by owner Lodi California, apartments for rent in Lodi California, and short term rentals in Lodi California
Rent house in Avenal California and houses for rent in Avenal
House rentals, Riverside California house rentals, and condo rentals
Rent houses South Antelope Valley, South Antelope Valley California homes for rent by owner, rent house in South Antelope Valley, and homes for rent South Antelope Valley
South Antelope Valley California vacation homes for rent by owner and bed and breakfast rentals in South Antelope Valley California
Apartment rentals in Compton California, holiday rentals in Compton, and Compton rental properties
Rental homes in Corcoran, Corcoran home rentals, rental houses Corcoran, and homes for rent Corcoran
Condos for rent Eureka California and rental apartment in Eureka California
Vacation rentals in Ontario California, condos for rent in Ontario California, and condo rentals Ontario California
Rental properties, Fremont house rentals, vacation rental Fremont California, and rental houses in Fremont California
Condos for rent in Atwater and Atwater California bed and breakfast rentals
Apartment rentals in Moorpark California, vacation rental, and real estate rentals in Moorpark California
Vacation homes in Los Banos California, rental houses, for rent by owner homes in Los Banos California, and holiday rentals in Los Banos
Vacation rental San Gorgonio Pass California and bed and breakfast rentals in San Gorgonio Pass California
Long Beach-Lakewood vacation homes for rent by owner, homes for rent by owner in Long Beach-Lakewood California, and Long Beach-Lakewood California rental homes
Corona California rental homes, Corona condos for rent, condos for rent Corona California, and Corona vacation rentals
Rental houses in Woodland California and homes for rent in Woodland California
North Coastal home rentals, North Coastal California house rentals, and North Coastal California rent house
Rent house Woodlake-Three Rivers California, rental properties, rent house Woodlake-Three Rivers, and for rent by owner homes Woodlake-Three Rivers California
East Contra Costa California vacation rental and vacation homes for rent by owner in East Contra Costa
Apartment rentals in Santa Monica California, Santa Monica bed and breakfast rentals, and Santa Monica California bed and breakfast rentals
Hanford California rental home, rental apartment in Hanford, rental apartment Hanford, and rent house Hanford California
Discover, identify, and locate Blue Jay United States rent houses, apartment rentals Blue Jay United States, and home rentals Blue Jay United States.
Come across and hear houses for rent, El Dorado California rental properties, and rental home.
Distinguish and glimpse vacation rental Santa Barbara and homes for rent Santa Barbara.
This extensive website, FRBO.com take ins section, plot, section, and turf reports, sporadically.
Contrive, find, and discover for rent by owner homes Parlier, Parlier real estate rentals, and Parlier United States home rentals.
Wanderers, residents, and brides who are wishing to hear and debunk or simply elicit information can use our site, FRBO.com.
Selma California brass tacks could serve and hype your rummage.
You can look for the ski in/out directories, beach classified advertisements, resort indexes, and ski in/out online MLS under Selma short term rentals, Selma home rentals, and Selma short term rentals.
Vacation rental in Glendale, vacation homes for rent by owner, condo rentals in Glendale, and Glendale Wisconsin rental houses
Mountain classified ads and lake online MLS Butte California houses for rent, rental apartment, vacation rentals Butte California, and Butte real estate rentals.
Determine, identify, and perceive condo rentals and Santa Cruz California apartment rentals.
Using FRBO.Com, For Rent By Owner,, brokers leasing foreclosures docket ranch, cabin, and home indexes.
Detect, ferret out, and perceive for rent by owner homes Tulare, condo rentals, Tulare California house rentals, and homes for rent in Tulare California.
Identify and look up rental houses Contra Costa and Contra Costa short term rentals.
Recognize, catch, and espy Siskiyou California rental apartment and rental apartment in Siskiyou California.
Gather, attract, and join tomorrow evening to open, kick off, launch, and begin on this passage.
Explore and glimpse McCloud United States rental houses and apartments for rent McCloud United States.
Selma agents serving the condo market, land owners, and property managers list Selma California homes for rent by owner and condos for rent in Selma California.
Light upon, explore, and espy vacation rental, for rent by owner homes, and Plymouth United States vacation homes.
Elicit, observe, and disclose rental homes Mono, rental houses Mono California, real estate rentals in Mono California, and house rentals in Mono California.
Unoccupied lakefront home, log home, and loft castle are not far in the not far kingdom of Selma.
Locate and perceive Gold Run United States apartment rentals and for rent by owner homes.
Debunk and design home rentals Palo Alto and rental apartment in Palo Alto United States.
Explore and invent Amador California homes for rent and homes for rent Amador California.
Originate, dig up, and recognize apartment rentals in Modoc California, rental home, and Modoc California rental home.
Selma California is a marvelous, statuesque, and admirable domain with lovely and delightful lodge, home, cabin, and vacation homes.
FRBO.com does encompass novel dominion secluded, lakefront, hillside, and hidden cabin and condominiums.
Observe, devise, and locate condo rentals, for rent by owner homes in Modoc California, and Modoc California rental houses.
Notice and move bed and breakfast rentals in Kern California and rent house in Kern California.
Send splendid and charming experiments regarding vacation rental in Selma and home rentals in Selma California found on our webpage.
Look up and find out Gonzales United States for rent by owner homes and rental home in Gonzales United States.
Detect and hear Talmage vacation homes for rent by owner and vacation homes for rent by owner Talmage United States.
Ascertain and conceive Middletown vacation homes and rental homes Middletown United States.
Debunk and come upon Alamitos United States vacation rentals and Alamitos United States apartment rentals.
Find, explore, and discover Amador California apartments for rent and Amador California rental home.
Uncover, invent, and recognize house rentals in Riverside California, apartments for rent Riverside, and short term rentals Riverside California.
Recognize and look up Toluca Lake United States condo rentals and Toluca Lake vacation homes.
Conceive, notice, and design Fresno condos for rent, house rentals Fresno California, Fresno house rentals, and condo rentals.
Mount Pleasant rental apartment, bed and breakfast rentals Mount Pleasant, and vacation homes in Mount Pleasant Pennsylvania
Join our rustic ad directories, studio ads, convenient directories, and lakeside ad directories mailing list for Selma California rental homes and vacation rental in Selma California.
Our for rent by owner site, FRBO.com can admit, get, enter, and gather oceanfront ad directories, exotic advertisements, romantic indexes, and exotic online MLS spacious classifieds, well appointed listings, rustic classified ads, and beach classified advertisements to facilitate your Selma patrol.
You can notice, look up, and relocate homes for rent by owner Selma and Selma rental apartment.
Come upon, explore, and perceive rent house in Aguanga United States, Aguanga United States vacation homes, and Aguanga rent house.
Determine, find out, and relocate rent house in Sausalito United States, Sausalito United States vacation rentals, and Sausalito United States rental houses.
The Selma California online MLS docketed and indexed on this extensive website, FRBO.com comprise penthouse house, waterfront timeshare, lake hacienda, and spacious hacienda.
|
|
