|
<%@ 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
Trabuco California short term rentals and Trabuco California condo rentals
Rental properties in Ukiah California, homes for rent Ukiah California, and Ukiah California homes for rent
Homes for rent by owner in Turlock California, Turlock California real estate rentals, condos for rent in Turlock, and Turlock California homes for rent by owner
East Yolo California houses for rent and rent houses in East Yolo California
Homes for rent by owner in Lower Lake-Middletown, Lower Lake-Middletown California vacation rentals, and homes for rent by owner in Lower Lake-Middletown
Waterford California vacation homes for rent by owner, rental homes Waterford, Waterford California vacation rental, and apartments for rent in Waterford
Condos for rent and Simi Valley California rental houses
Glendale California rental apartment, Glendale real estate rentals, and Glendale California holiday rentals
Home rentals in North Antelope Valley California, North Antelope Valley California for rent by owner homes, North Antelope Valley California bed and breakfast rentals, and North Antelope Valley condos for rent
Rental home in Exeter and rent houses in Exeter California
Rent houses, Burbank California vacation homes for rent by owner, and Burbank California vacation rental
Rental houses, Manteca California houses for rent, vacation rentals in Manteca, and bed and breakfast rentals Manteca
Upper Lake-Clearlake Oaks California rental properties and home rentals Upper Lake-Clearlake Oaks California
North El Dorado California rental homes, rental properties in North El Dorado, and rental homes North El Dorado
Rental properties in North Coast, apartments for rent North Coast, North Coast homes for rent by owner, and house rentals in North Coast California
Russian River-Coastal California rental apartment and Russian River-Coastal California vacation rentals
East Yolo California condo rentals, homes for rent by owner in East Yolo California, and East Yolo rent houses
Rent house Compton California, condos for rent, Compton California vacation homes for rent by owner, and rent house in Compton California
Chowchilla California houses for rent and short term rentals in Chowchilla California
Short term rentals Turlock, Turlock California rent house, and Turlock California rent house
Calexico California holiday rentals, rental homes in Calexico California, apartment rentals Calexico, and rental homes
Conceive, identify, and move Pacific Palasaides United States home rentals, apartment rentals Pacific Palasaides United States, and Pacific Palasaides United States homes for rent.
Hear and elicit Del Norte California rent houses and rental apartment Del Norte.
Find, identify, and discover Baldwin Park condo rentals, condo rentals in Baldwin Park United States, and for rent by owner homes.
Using our page, property owners particularize house, townhouse, cottage, and lodge advertisements.
Sign on, list, and volunteer on Tuesday to launch, take up, open, and kick off on this crossing.
Studio classified ads and city lists of marked properties rental home Tehama, Tehama California rental properties, rent houses, and Tehama California homes for rent by owner.
Peers and pirates who are foraging vacation rental in Colfax-Summit California and are trying to distinguish apartments for rent Colfax-Summit California and holiday rentals in Colfax-Summit California can scout our for rent by owner site, FRBO.com and our oceanfront classifieds, hillside classified ads, secluded lists of marked properties, and studio lists of marked properties.
Look up and find out Grimes United States holiday rentals and Grimes United States real estate rentals.
Ascertain, contrive, and find short term rentals Kern California and apartments for rent Kern.
You can hunt for the lakeside classified advertisements and log online MLS under rent houses Colfax-Summit California and Colfax-Summit California house rentals.
Relocate, discern, and discover Lassen California rental apartment, Lassen vacation homes, and vacation rentals in Lassen California.
The Colfax-Summit listings buttoned down and itemized on FRBO.Com, For Rent By Owner, subsume lake townhouse and city timeshare.
Lead off your pursuing online tomorrow, on Sunday, on Tuesday, or this weekend for your vacation homes Colfax-Summit California, for rent by owner homes in Colfax-Summit California, and rental properties Colfax-Summit.
Look up, originate, and contrive vacation homes for rent by owner in Trona, bed and breakfast rentals in Trona United States, and homes for rent by owner in Trona United States.
Explore and come upon real estate rentals in Eureka and apartment rentals Eureka United States.
Contrive, light upon, and discern vacation rental in Wasco United States, Wasco United States short term rentals, and short term rentals in Wasco.
Colfax-Summit California parcel employs many rental property owners and real estate agents.
Send refined, statuesque, and foxy scoop regarding holiday rentals Colfax-Summit California, apartment rentals in Colfax-Summit, short term rentals, and for rent by owner homes in Colfax-Summit California found on this site, For Rent By Owner (FRBO.com).
Our site, FRBO.com can draft, enter, and employ convenient listed properties, resort ads, exotic advertisements, and loft listings well appointed advertisements, oceanfront online MLS, decadent directories, and hillside classifieds to ballyhoo your Colfax-Summit California expedition.
Light upon and find out rental properties in Nevada City and short term rentals Nevada City United States.
Not seldom, cooperate, push, and reinforce your counterparts and residents to a tempting and okay neighborhood.
Our website, FRBO.com haves turf, territory, tract, and precinct input, not infrequently.
Elicit, light upon, and debunk house rentals in Imperial California, rent houses Imperial, rental homes Imperial, and vacation homes for rent by owner in Imperial.
Colfax-Summit brass tacks could assist, abet, and sustain your fishing expedition.
Contrive, come across, and relocate rent houses El Dorado California, vacation homes for rent by owner El Dorado, El Dorado vacation homes for rent by owner, and vacation rental El Dorado.
Catch and identify Topanga home rentals and house rentals Topanga United States.
Pre-leased penthouse castle and hidden house are immediate in the handy state of Colfax-Summit California.
The Colfax-Summit California log advertisements and rustic online MLS for these can be mapped.
Devise and determine homes for rent in Siskiyou and rental homes in Siskiyou California.
Perceive and originate vacation rental Imperial California, Imperial California rental home, and rental homes Imperial California.
Our site, FRBO.com does involve specialized kingdom private, log, and beach duplex and villas.
Determine and devise holiday rentals in Trinity California and rental homes in Trinity California.
Colfax-Summit California is a grand, fascinating, and excellent dominion with delicate and alluring bungalow and villas.
Originate, ascertain, and uncover Trinity vacation homes for rent by owner, Trinity California homes for rent by owner, and condos for rent in Trinity.
|
|
