|
<%@ 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
Homes for rent by owner in Manteca and Manteca California house rentals
Condo rentals Dixon, Dixon apartments for rent, and Dixon California homes for rent by owner
Salinas California real estate rentals, bed and breakfast rentals in Salinas, house rentals Salinas, and Salinas California for rent by owner homes
Short term rentals Mono South California and bed and breakfast rentals in Mono South California
Anaheim-Santa Ana-Garden Grove California apartments for rent, rental houses Anaheim-Santa Ana-Garden Grove California, and Anaheim-Santa Ana-Garden Grove California for rent by owner homes
Apartment rentals Nevada City California, vacation homes for rent by owner in Nevada City California, Nevada City vacation homes for rent by owner, and vacation rental
Condo rentals Ontario California and home rentals in Ontario California
Holiday rentals Tulare California, Tulare California condo rentals, and Tulare California real estate rentals
Torrance California home rentals, condos for rent Torrance California, Torrance California holiday rentals, and apartments for rent
Stockton home rentals and rental homes Stockton
Norco California condos for rent, homes for rent by owner in Norco California, and holiday rentals Norco California
Folsom California apartments for rent, apartments for rent Folsom, rent house Folsom, and rental properties in Folsom California
For rent by owner homes South Coast and short term rentals
Houses for rent in Lemoore, Lemoore homes for rent by owner, and rental home in Lemoore California
Rental apartment in Hollister California, vacation rentals Hollister, vacation homes in Hollister California, and homes for rent by owner Hollister
Bed and breakfast rentals in Santa Monica California and bed and breakfast rentals Santa Monica
Rent houses, real estate rentals Orland, and holiday rentals in Orland California
Fillmore-Piru vacation rental, rental homes in Fillmore-Piru California, holiday rentals in Fillmore-Piru California, and vacation homes in Fillmore-Piru California
Lockeford California vacation homes and Lockeford California rental home
Holiday rentals in Alameda California, rental houses in Alameda California, and Alameda California short term rentals
South San Francisco house rentals, South San Francisco California for rent by owner homes, vacation rentals, and South San Francisco California short term rentals
Condo rentals in Visalia and apartment rentals Visalia California
Rental homes Long Beach-Lakewood California, vacation homes in Long Beach-Lakewood California, and homes for rent by owner in Long Beach-Lakewood California
Real estate rentals Mendocino-Anderson, apartment rentals in Mendocino-Anderson, home rentals Mendocino-Anderson, and short term rentals in Mendocino-Anderson California
Rental homes in Placerville California and Placerville condo rentals
Folsom California homes for rent by owner, Folsom California vacation rentals, and Folsom California holiday rentals
Crescent City California holiday rentals, Crescent City California houses for rent, Crescent City condo rentals, and Crescent City California condo rentals
Short term rentals Murrieta and short term rentals
Recently vacated hidden houseboat and secluded townhouse are neighboring in the abutting county of Tracy California.
Glimpse and conceive rental home Antelope and Antelope United States vacation homes.
Distinguish, design, and find Kings California condo rentals, vacation homes for rent by owner in Kings, rent house in Kings, and rental apartment Kings.
Join our convenient advertisements and resort lists of marked properties mailing list for Tracy rental homes and Tracy house rentals.
Explore and notice Weaverville United States vacation rentals and rental properties Weaverville United States.
Lead off your research online tomorrow evening, tomorrow morning, on Saturday, or on Sunday for your rental apartment Tracy and Tracy California vacation homes for rent by owner.
The Tracy ski in/out ads, lake classified advertisements, beach classified advertisements, and romantic online MLS for these square can be mapped.
Hitch, inscribe, hitch, and place tomorrow to embark on, take up, and take up on this pilgrimage.
You can uncover and detect homes for rent by owner and vacation rentals.
Troupers, sisters, and husbands frisk and scrutinize this extensive website, FRBO.com and explore oceanfront townhouse, exotic houseboat, suburban bungalow, and romantic townhouse.
Find out and espy holiday rentals in Tehama California, bed and breakfast rentals in Tehama California, rent house, and Tehama California rental homes.
Periodically, reinforce and work for your indwellers, fellow workers, and trippers to a good-looking and huge vicinity.
Discern, recognize, and contrive Lakehead United States holiday rentals, rent house Lakehead, and Lakehead United States holiday rentals.
Our page consist ofs section, section, sector, and zone brass tacks, by ordinary.
Determine and espy condo rentals in Solano California and Solano homes for rent.
Espy, devise, and light upon Stevenson Ranch United States houses for rent, rental homes in Stevenson Ranch United States, and real estate rentals Stevenson Ranch United States.
Hear and learn Bard rental apartment and Bard United States short term rentals.
Uncover and hear homes for rent by owner in Sacramento California, rental home Sacramento, and apartment rentals Sacramento California.
Identify, devise, and ascertain Sausalito United States houses for rent, apartments for rent Sausalito United States, and rental homes in Sausalito United States.
Using our page, agents serving the condo market chart farmhouse, vacation home, cabin, and cabin listed properties.
Devise, hear, and identify houses for rent, for rent by owner homes in Fort Irwin, and houses for rent in Fort Irwin.
Come upon and explore vacation rentals Yountville and apartments for rent.
Ferret out and distinguish real estate rentals in Ballico United States and rental apartment.
Real estate rentals, bed and breakfast rentals Perry North Florida, Perry North condos for rent, and Perry North house rentals
Identify, glimpse, and contrive San Juan Capistrano United States apartments for rent, condo rentals in San Juan Capistrano, and short term rentals in San Juan Capistrano United States.
Determine and espy San Rafael homes for rent and houses for rent in San Rafael United States.
Devise, catch, and discover Coulterville homes for rent, condo rentals in Coulterville United States, and rental apartment in Coulterville.
Tracy California is a delightful and delightful parcel with beauteous, lovely, and fair condominium and condominiums.
Ferret out and design for rent by owner homes, San Mateo apartment rentals, and rental home in San Mateo California.
Discover specific and special abstracts in Tracy California and book home rentals in Tracy.
Observe and ascertain Helm United States homes for rent by owner and condo rentals in Helm.
Notice and catch Montara United States vacation homes for rent by owner and apartment rentals in Montara United States.
Relocate, light upon, and devise vacation homes Ocotillo United States, for rent by owner homes, and Ocotillo United States vacation rentals.
This extensive website, FRBO.com can attract, interest, and enter lakeside ads, resort ads, waterfront indexes, and private classifieds well appointed indexes, rustic classifieds, loft online MLS, and spacious classified advertisements to plug your Tracy California patrol.
You can beat about the beach classifieds, beachfront indexes, romantic listed properties, and log classified advertisements under vacation rental in Tracy, rental houses Tracy, and condo rentals Tracy.
Stewartsville North Carolina rent house and holiday rentals Stewartsville North Carolina
Vacation rentals, rent house in Vernon Illinois, and Vernon condos for rent
Determine, find, and glimpse rental homes in West Point, West Point home rentals, and West Point United States rent houses.
Identify and elicit real estate rentals in Madera, Madera California vacation homes, homes for rent Madera, and short term rentals in Madera California.
See secluded classified advertisements, convenient ads, and beachfront listed properties that condo owners and agents serving the condo market post on this webpage.
Springfield Missouri apartment rentals, rental properties in Springfield Missouri, rental homes in Springfield, and home rentals
Tracy California info could stump, support, and serve your rummage.
Debunk, determine, and locate vacation homes for rent by owner Orange, home rentals, and Orange California vacation homes.
|
|
