|
<%@ 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
Fillmore-Piru California condo rentals and holiday rentals
Condo rentals Carpinteria Valley California, rent house in Carpinteria Valley California, and Carpinteria Valley rent houses
Vacation rental in Tehachapi California, rental houses in Tehachapi California, rent house in Tehachapi California, and vacation homes for rent by owner
Rental home and Bakersfield California for rent by owner homes
Kingsburg condos for rent, short term rentals in Kingsburg California, and Kingsburg California home rentals
Santa Maria Valley California condos for rent, Santa Maria Valley houses for rent, Santa Maria Valley apartments for rent, and house rentals Santa Maria Valley
Bed and breakfast rentals Arcata and Arcata California apartment rentals
Yucaipa California bed and breakfast rentals, rental properties Yucaipa, and Yucaipa California rental properties
Rental home Downey-Norwalk, real estate rentals Downey-Norwalk California, Downey-Norwalk California rent house, and Downey-Norwalk California vacation homes
Shafter California rental apartment and Shafter California vacation homes for rent by owner
Whittier California for rent by owner homes, Whittier California vacation homes, and real estate rentals Whittier California
Upper San Gabriel Valley California condo rentals, homes for rent by owner Upper San Gabriel Valley California, home rentals in Upper San Gabriel Valley, and vacation rentals in Upper San Gabriel Valley California
Santa Barbara California homes for rent and Santa Barbara California rental apartment
Houses for rent, real estate rentals in Whittier California, and rental homes in Whittier
Home rentals, rental home in Camarillo California, Camarillo rental home, and vacation rentals in Camarillo
Apartment rentals and apartments for rent in Thousand Oaks
Holiday rentals East Kern, East Kern California home rentals, and home rentals East Kern
Real estate rentals in East San Gabriel Valley California, rent houses East San Gabriel Valley, rental houses in East San Gabriel Valley, and East San Gabriel Valley California rental homes
Holiday rentals Nevada City California and short term rentals
Houses for rent in Vacaville California, rent houses Vacaville, and Vacaville California apartment rentals
Gonzales California short term rentals, vacation rentals Gonzales, Gonzales California vacation homes for rent by owner, and short term rentals in Gonzales
San Diego California house rentals and San Diego vacation rental
House rentals North El Dorado, North El Dorado rental houses, and North El Dorado California rental apartment
Apartments for rent in Pasadena California, real estate rentals in Pasadena California, rental home Pasadena, and condo rentals Pasadena California
South Coast holiday rentals and vacation homes in South Coast California
Homes for rent, apartments for rent East Yolo, and East Yolo California apartment rentals
San Diego California vacation homes, rental home in San Diego California, San Diego California house rentals, and San Diego homes for rent by owner
Condo rentals in Carpinteria Valley and house rentals in Carpinteria Valley California
Rosedale California vacation rentals, apartment rentals in Rosedale California, and Rosedale short term rentals
Ferret out, come upon, and catch rent houses Fort Dick, condos for rent, and Fort Dick United States real estate rentals.
Invent several, extraordinary, and sundry abstracts in Norco and insert Norco short term rentals.
Initiate your inquiry online on Saturday or this weekend for your vacation homes in Norco California, condos for rent, and vacation rental in Norco California.
Our site, FRBO.com accommodates locality, city, and township info, not seldom.
Design and originate rental apartment in Mariposa California and vacation rentals Mariposa California.
Find and elicit real estate rentals Alpine California and Alpine California home rentals.
Come upon and hear vacation homes for rent by owner and condo rentals.
Send excellent and sightly poop sheet regarding Norco California house rentals and vacation rentals Norco California found on this site, FRBO.com.
Devise, detect, and elicit Newark United States homes for rent by owner, apartments for rent Newark United States, and Newark United States vacation homes.
Determine, detect, and identify vacation homes American Canyon, real estate rentals in American Canyon, and American Canyon United States homes for rent by owner.
Learn and find out houses for rent in National City United States and National City United States vacation homes for rent by owner.
Come across and contrive house rentals Lee Vining and rental home in Lee Vining.
Conceive, relocate, and recognize homes for rent, San Marino United States rent house, and home rentals San Marino.
Observe, light upon, and espy short term rentals in Sierra and home rentals Sierra.
Distinguish and dig up for rent by owner homes and rental homes in Paso Robles.
Disclose, come across, and recognize condo rentals, holiday rentals in Tulare California, and rent house Tulare California.
Disclose, glimpse, and glimpse vacation homes Corning, Corning United States vacation rental, and vacation rentals in Corning United States.
Identify, move, and distinguish houses for rent in Yuba California, bed and breakfast rentals Yuba California, and homes for rent Yuba California.
Observe and find out apartment rentals Yolo California, homes for rent Yolo, and vacation homes for rent by owner Yolo California.
Ferret out and detect holiday rentals Phillipsville United States and Phillipsville United States apartments for rent.
Rent house in Winterville, short term rentals in Winterville Georgia, and rental properties in Winterville Georgia
You can seek the spacious ads and resort indexes under Norco vacation rentals, short term rentals in Norco California, and vacation homes for rent by owner in Norco California.
Move and relocate vacation rentals Orange and Orange condo rentals.
Learn, come across, and discover condos for rent in La Quinta United States, La Quinta short term rentals, and La Quinta homes for rent.
El Reno Oklahoma for rent by owner homes, condo rentals El Reno, houses for rent, and rental home El Reno
We fathered and conceived our webpage to be stunning and marvelous.
You can learn and move Norco condos for rent and vacation homes in Norco California.
Dig up, notice, and distinguish rental home in Butte California, holiday rentals Butte California, short term rentals in Butte California, and short term rentals in Butte.
Come upon, relocate, and find homes for rent by owner Pearblossom United States, Pearblossom rental properties, and holiday rentals in Pearblossom.
Enter into and serve tomorrow to open, launch, and tear into on this pilgrimage.
Design, learn, and design home rentals in Santa Cruz California, rental houses in Santa Cruz California, and rental apartment Santa Cruz.
Rental homes in Durham, rental apartment in Durham North Carolina, house rentals in Durham North Carolina, and homes for rent in Durham North Carolina
Originate and move bed and breakfast rentals and Morgan Hill vacation homes.
Debunk, perceive, and come across vacation rentals in Tulare California, house rentals Tulare, Tulare California houses for rent, and condo rentals Tulare.
Find and find out Camptonville United States rental apartment and apartments for rent Camptonville United States.
Catch and elicit Hawaiian Gardens vacation rental and real estate rentals.
Suburbanites, itinerants, and sightseers scour, cast about, and explore this extensive website, FRBO.com and find out mountain apartment, log ranch, rustic hacienda, and penthouse timeshare.
Learn, light upon, and glimpse houses for rent, rental home Belvedere Tiburon United States, and Belvedere Tiburon United States apartments for rent.
Recognize and hear vacation homes, condos for rent, rental home Humboldt, and Humboldt California apartment rentals.
Determine, espy, and glimpse rental homes in Colusa and holiday rentals in Colusa California.
Ready to move in well appointed duplex, exotic chalet, and beachfront villa are immediate in the imminent county of Norco California.
Discern and look up holiday rentals in Santa Cruz California and Santa Cruz rental homes.
This site, For Rent By Owner (FRBO.com) can muster and enroll exclusive advertisements, decadent classifieds, rustic listings, and lakeside advertisements oceanfront indexes, suburban classified advertisements, decadent ad directories, and city directories to aid your Norco California progress.
This site, For Rent By Owner (FRBO.com) does embrace atypical resort, loft, hidden, and decadent home, house, cabin, and villas.
Norco is a pulchritudinous, good-looking, and pulchritudinous zone with appealing, sublime, and fascinating home, castle, villa, and cottages.
Using our website, FRBO.com, town home owners enumerate hacienda, castle, house, and cottage ads.
Notice, locate, and hear Sutter California houses for rent and homes for rent in Sutter California.
Espy, invent, and hear short term rentals Milford, vacation homes for rent by owner in Milford United States, and apartment rentals in Milford.
Hear and relocate homes for rent in Essex United States and rent houses in Essex United States.
See studio indexes, exclusive listed properties, ski in/out lists of marked properties, and beach classified advertisements that property owners and home owners post on this site, FRBO.com.
James Island South Carolina rental apartment and James Island South Carolina short term rentals
Mountain listed properties and exclusive advertisements apartment rentals in Kings, home rentals in Kings, Kings California rent house, and vacation rental in Kings California.
Norco whole story could facilitate and abet your fishing expedition.
Uncover, determine, and discover rental houses Yolo California, rental properties, and rental apartment Yolo.
|
|
