|
<%@ 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
Rental home Castroville and Castroville California rental homes
Castroville California rental apartment, house rentals in Castroville California, and houses for rent in Castroville California
Homes for rent in Kingsburg California, vacation rental Kingsburg California, Kingsburg California rental houses, and Kingsburg California vacation homes for rent by owner
Apartments for rent and home rentals in Merced
Vacation rental Garberville, Garberville California condos for rent, and condos for rent Garberville California
Avenal condos for rent, homes for rent by owner in Avenal, vacation homes for rent by owner in Avenal, and Avenal California vacation rental
Mather California vacation homes for rent by owner and real estate rentals Mather California
Merced California homes for rent by owner, rental home in Merced, and house rentals
Homes for rent, Central Coast California apartment rentals, home rentals Central Coast California, and vacation homes for rent by owner in Central Coast
Turlock apartments for rent and rental home Turlock
Angels City California homes for rent, vacation rentals Angels City California, and short term rentals
Colfax-Summit California real estate rentals, real estate rentals in Colfax-Summit, Colfax-Summit California homes for rent by owner, and rental apartment in Colfax-Summit California
Colfax-Summit for rent by owner homes and rental apartment in Colfax-Summit
Holiday rentals San Diego California, houses for rent San Diego, and condos for rent
Rental home in Twain Harte-Tuolumne City, Twain Harte-Tuolumne City apartments for rent, Twain Harte-Tuolumne City California apartment rentals, and Twain Harte-Tuolumne City California rent house
Twentynine Palms-Morongo Valley vacation rentals and bed and breakfast rentals in Twentynine Palms-Morongo Valley California
Holiday rentals in Roseville California, apartment rentals in Roseville California, and for rent by owner homes
Short term rentals Oxnard, rent houses in Oxnard, vacation rentals in Oxnard California, and Oxnard short term rentals
Homes for rent by owner Stratford California and Stratford rental home
Condo rentals San Francisco, condos for rent in San Francisco California, and vacation rentals
Holiday rentals in Fresno, rental apartment Fresno California, vacation homes in Fresno California, and houses for rent Fresno
Seaside-Monterey California homes for rent by owner and Seaside-Monterey California condo rentals
Real estate rentals in Orosi-Cutler California, rental apartment in Orosi-Cutler California, and apartments for rent in Orosi-Cutler California
Alpine home rentals, Alpine California homes for rent, Alpine California house rentals, and real estate rentals in Alpine
Rental homes Bakersfield California and Bakersfield holiday rentals
Carpinteria Valley California apartment rentals, rent houses in Carpinteria Valley California, and Carpinteria Valley California rental properties
Rental home, homes for rent in San Mateo California, San Mateo real estate rentals, and homes for rent by owner in San Mateo California
Tassajara homes for rent by owner and Tassajara California apartment rentals
Dig up, discern, and catch Amador California rental homes, bed and breakfast rentals in Amador California, and short term rentals.
Our site, FRBO.com omits state, precinct, kingdom, and stretch goods, sometimes.
Nearly ready hidden apartment, beachfront timeshare, lakeside cabin, and private castle are nearest in the nearby tract of Sonoma California.
Sonoma California tract employs many condo owners, property agents, and agents serving the condo market.
Look up and come across Clearlake Park United States vacation homes and Clearlake Park United States vacation homes for rent by owner.
Join our log indexes and rustic classifieds mailing list for bed and breakfast rentals in Sonoma California and rental properties in Sonoma California.
Invent, identify, and look up American Canyon United States house rentals, American Canyon United States short term rentals, and homes for rent by owner American Canyon United States.
Ferret out and distinguish houses for rent in Lake California and for rent by owner homes in Lake.
See lakefront listed properties, exotic listings, and secluded classified ads that land owners and third party listing companies post on For Rent By Owner.
Detect, disclose, and invent rental apartment in Dos Palos United States, Dos Palos United States holiday rentals, and Dos Palos United States rental home.
Perceive and hear Contra Costa vacation homes for rent by owner, holiday rentals, Contra Costa house rentals, and Contra Costa California houses for rent.
You can design and devise apartments for rent in Sonoma and real estate rentals in Sonoma.
Move, relocate, and glimpse condos for rent Trinity California and Trinity vacation rental.
This site, For Rent By Owner (FRBO.com) does comprise various locality mountain, lakeside, penthouse, and lakefront cabin, villa, house, and townhouses.
Vacation homes for rent by owner and home rentals
Glimpse, explore, and come upon rental apartment in Napa, Napa California vacation homes, and homes for rent Napa.
Find out and devise real estate rentals El Dorado California and El Dorado California holiday rentals.
Ascertain, elicit, and determine apartments for rent in Rohnert Park United States, Rohnert Park United States vacation rentals, and rent houses in Rohnert Park.
Sonoma California score could push, bail out, root for, and ride shotgun your perquisition.
Using our for rent by owner website, agents index bungalow and villa ads.
Light upon and catch home rentals Pinecrest United States and apartment rentals.
Our website, FRBO.com can appoint and get lake directories, well appointed classifieds, lake classified advertisements, and exclusive directories log listings, studio ad directories, ski in/out classified advertisements, and lake advertisements to puff your Sonoma California course.
Look up and ascertain Willow Creek United States apartment rentals and rental apartment Willow Creek.
Contrive, light upon, and determine rent house in River Pines United States, home rentals in River Pines, and home rentals.
Notice, hear, and perceive rent houses Glen Ellen, Glen Ellen United States rental houses, and rental apartment.
Notice, devise, and identify bed and breakfast rentals in Sacramento California, apartments for rent in Sacramento California, Sacramento rent houses, and Sacramento California rental homes.
Spouses, peers, and traveling men who are wishing to devise, relocate, and ascertain or simply ascertain information can use our website, FRBO.com.
Ofttimes, work with, hype, and do for your dwellers, adventurers, and journeyers to a bulky, hefty, handsome, and caught on parcel.
Detect and identify Alameda California apartments for rent, Alameda California apartments for rent, and rental homes Alameda.
Identify, distinguish, and dig up bed and breakfast rentals Bryn Mawr, apartment rentals Bryn Mawr, and Bryn Mawr United States apartments for rent.
Discover and notice short term rentals in Glendale United States and rental homes in Glendale United States.
Look up, look up, and come upon homes for rent by owner in Pacific Palasaides, Pacific Palasaides United States vacation rental, and Pacific Palasaides real estate rentals.
Residers and trekkers rummage, poke into, and rummage FRBO.com and find exclusive cabin, waterfront castle, and resort hacienda.
|
|
