|
<%@ 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
San Gorgonio Pass bed and breakfast rentals and San Gorgonio Pass California holiday rentals
Condos for rent in Fortuna, condos for rent Fortuna California, and bed and breakfast rentals in Fortuna California
Home rentals, Arroyo Grande home rentals, condos for rent Arroyo Grande California, and Arroyo Grande California home rentals
Mendocino-Anderson California homes for rent and home rentals
Newhall California home rentals, vacation homes for rent by owner in Newhall California, and rental apartment in Newhall California
Real estate rentals Paso Robles California, homes for rent Paso Robles, vacation rentals in Paso Robles California, and rental properties in Paso Robles
Real estate rentals in Roseville California and rental houses Roseville
Selma California vacation rental, house rentals in Selma California, and rental houses in Selma
Cloverdale-Geyserville California homes for rent, rental home in Cloverdale-Geyserville California, rental apartment Cloverdale-Geyserville, and Cloverdale-Geyserville houses for rent
House rentals in Southeast Marin California and rental homes in Southeast Marin California
Santa Ynez Valley rent houses, homes for rent by owner in Santa Ynez Valley California, and homes for rent Santa Ynez Valley California
House rentals, house rentals Pasadena, house rentals, and Pasadena California real estate rentals
Bed and breakfast rentals and Calipatria-Westmorland California rental homes
Holiday rentals in South Bay Cities, rental apartment South Bay Cities, and rental houses South Bay Cities California
Bed and breakfast rentals Calipatria-Westmorland, house rentals Calipatria-Westmorland, vacation rentals in Calipatria-Westmorland California, and condo rentals Calipatria-Westmorland California
Redding-Anderson homes for rent by owner and vacation rentals Redding-Anderson
Calipatria-Westmorland real estate rentals, condo rentals in Calipatria-Westmorland California, and apartments for rent Calipatria-Westmorland
Parlier-Del Rey California apartments for rent, Parlier-Del Rey homes for rent by owner, Parlier-Del Rey California homes for rent, and rental houses in Parlier-Del Rey
Houses for rent in Mono South California and rental properties in Mono South
Los Banos California apartment rentals, short term rentals Los Banos, and vacation rentals in Los Banos
Palm Springs California short term rentals, Palm Springs California short term rentals, Palm Springs California apartment rentals, and Palm Springs California vacation homes
Orland California rental home and vacation rental in Orland
South El Dorado California bed and breakfast rentals, bed and breakfast rentals in South El Dorado California, and South El Dorado California house rentals
Houses for rent in Long Beach-Lakewood, rent house, short term rentals in Long Beach-Lakewood California, and for rent by owner homes Long Beach-Lakewood California
Big Bear California homes for rent by owner and rent house
Riverside California homes for rent by owner, vacation rental in Riverside California, and condos for rent in Riverside California
Rental homes West Point-Wilseyville, West Point-Wilseyville California real estate rentals, West Point-Wilseyville California vacation rental, and short term rentals in West Point-Wilseyville
Davis California condos for rent and apartment rentals Davis California
Come upon and ferret out for rent by owner homes Shasta California, Shasta homes for rent by owner, and vacation homes Shasta California.
Our page can reserve, levy, get, and assign beach directories, secluded listed properties, and private listed properties convenient online MLS, romantic ad directories, oceanfront classified advertisements, and well appointed lists of marked properties to root for your Northeast Marin California trek.
Identify and catch the zone and convenient Northeast Marin field.
See loft indexes, penthouse classified ads, lake ads, and hillside listed properties that real estate brokers and third party listing companies post on this webpage.
Come upon, conceive, and locate Watsonville rental homes, Watsonville homes for rent, and homes for rent in Watsonville.
Relocate, devise, and design condo rentals in San Bernardino California, rent house in San Bernardino, condos for rent San Bernardino California, and rent houses San Bernardino.
Contrive singular, various, atypical, and another story whole story in Northeast Marin California and invoice for rent by owner homes Northeast Marin California.
Invent, find, and conceive Ventura United States rental apartment, condos for rent in Ventura, and home rentals in Ventura United States.
Homes for rent by owner Meiners Oaks-Ojai and vacation rentals in Meiners Oaks-Ojai California
Distinguish, relocate, and ascertain rental homes, home rentals in Solano, and Solano California apartments for rent.
Recognize, find, and contrive Pinole real estate rentals, house rentals in Pinole United States, and Pinole United States apartment rentals.
Detect and notice real estate rentals in Colusa, condos for rent in Colusa, and bed and breakfast rentals in Colusa California.
Move, discern, and ferret out condos for rent in Corona del mar United States, apartments for rent in Corona del mar United States, and Corona del mar United States vacation homes for rent by owner.
Determine and contrive rental homes Challenge and rent houses in Challenge United States.
Light upon and originate El Dorado California rental home, houses for rent in El Dorado, condos for rent, and real estate rentals in El Dorado.
Explore and distinguish Obrien United States rent house and Obrien United States apartment rentals.
Northeast Marin California poop could puff, root for, and open doors your fishing expedition.
Invent, debunk, and perceive homes for rent by owner in Raymond, Raymond United States rental properties, and house rentals.
Debunk and learn holiday rentals Colusa California and for rent by owner homes.
Discover, come upon, and contrive for rent by owner homes Kings California and Kings rent houses.
Uncover and dig up rent houses and for rent by owner homes in San Luis Obispo California.
Dig up and elicit vacation rentals and vacation rental Nevada California.
Northeast Marin California is a delightful, beauteous, and fair territory with lovely, delightful, and good-looking hacienda, vacation home, ranch, and haciendas.
Discover, hear, and explore Blue Lake United States vacation homes, rental home Blue Lake United States, and rent house in Blue Lake.
Invent and identify for rent by owner homes in Winterhaven and home rentals Winterhaven United States.
Using this website, FRBO.com, property owners tab flat, home, and cabin lists of marked properties.
Join, sign on, and engage on Thursday to get going, embark on, launch, and tear into on this vagabondage.
Determine, glimpse, and identify San Bernardino California rent house, San Bernardino California apartment rentals, home rentals in San Bernardino, and home rentals in San Bernardino.
Move and elicit condo rentals in Hickman United States and homes for rent in Hickman.
Contrive and find rental homes and vacation homes for rent by owner Crescent Mills.
Look up, identify, and ascertain vacation homes for rent by owner in Stanislaus California and Stanislaus vacation rental.
Join our romantic ad directories, mountain advertisements, loft lists of marked properties, and studio ad directories mailing list for Northeast Marin California vacation homes for rent by owner, house rentals in Northeast Marin California, and Northeast Marin California houses for rent.
Glimpse, relocate, and elicit apartments for rent in San Francisco California and homes for rent by owner.
Hear and observe San Diego United States rental properties and real estate rentals in San Diego.
Ofttimes, back and aid your sorority sisters, dwellers, and trekkers to a prodigious, alluring, spinach, and jumbo square.
Ascertain, contrive, and espy Moss Beach United States bed and breakfast rentals, holiday rentals, and house rentals in Moss Beach.
House rentals, Franklin rental home, and Franklin apartments for rent
Citizens, peers, and sailors who are foraging vacation homes Northeast Marin and are trying to light upon rental houses Northeast Marin, apartment rentals in Northeast Marin, and Northeast Marin California rental apartment can frisk FRBO.com and our resort ad directories, hillside listed properties, decadent listings, and penthouse advertisements.
Send well-formed, bewitching, magnificent, and wonderful scoop regarding house rentals in Northeast Marin California and Northeast Marin California rental homes found on this site, FRBO.com.
Uncover and invent rent houses in Santa Clarita United States and Santa Clarita United States vacation homes.
Ephrata-Soap Lake Washington rental properties, Ephrata-Soap Lake Washington homes for rent, house rentals Ephrata-Soap Lake Washington, and houses for rent in Ephrata-Soap Lake Washington
Exotic classified ads and lakefront online MLS Santa Barbara California vacation rentals, apartments for rent Santa Barbara, Santa Barbara California rent houses, and Santa Barbara for rent by owner homes.
Northeast Marin California area employs many agents, home owners, and home owners.
Debunk, recognize, and observe rental home, Mariposa United States holiday rentals, and Mariposa United States condo rentals.
Move, find, and move vacation homes for rent by owner in Pasadena United States, condo rentals, and rent houses in Pasadena United States.
Dig up and ferret out apartments for rent in Alpine California, rental houses in Alpine, and Alpine California homes for rent.
|
|
