|
<%@ 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
Condos for rent in Visalia and homes for rent by owner Visalia California
Condo rentals Twain Harte-Tuolumne City California, rental homes, and Twain Harte-Tuolumne City California short term rentals
Homes for rent Calipatria-Westmorland California, Calipatria-Westmorland holiday rentals, Calipatria-Westmorland California rent house, and home rentals
Greenfield homes for rent and rental apartment in Greenfield California
Rental apartment in El Toro California, rental properties in El Toro California, and real estate rentals El Toro California
Lake Tahoe California real estate rentals, homes for rent by owner, condos for rent, and Lake Tahoe California for rent by owner homes
Rental houses Lindsay California and homes for rent in Lindsay California
Vacation rentals in Livingston-Delhi California, vacation rental, and rent houses Livingston-Delhi
Rent houses in Carmel California, apartment rentals, rent houses in Carmel, and for rent by owner homes Carmel California
Real estate rentals in South San Francisco California and South San Francisco California home rentals
Homes for rent by owner in Hemet-San Jacinto, Hemet-San Jacinto California condo rentals, and apartments for rent in Hemet-San Jacinto California
Calabasas house rentals, Calabasas apartments for rent, short term rentals in Calabasas California, and Calabasas California homes for rent by owner
Vacation rental and for rent by owner homes
Bed and breakfast rentals in West Valley California, West Valley California for rent by owner homes, and apartment rentals West Valley California
Homes for rent by owner Sacramento California, apartments for rent, rental home in Sacramento California, and rent houses
Houses for rent Willits and short term rentals in Willits
Rent house San Diego, rental homes, and condo rentals in San Diego California
Condo rentals, vacation homes for rent by owner in Huron California, Huron California real estate rentals, and Huron California apartment rentals
Real estate rentals Folsom and vacation homes for rent by owner in Folsom California
Vacation homes in Sebastopol, vacation rental in Sebastopol California, and apartment rentals in Sebastopol
Vacation rentals in Tassajara California, bed and breakfast rentals, bed and breakfast rentals Tassajara, and for rent by owner homes Tassajara
Rental apartment Lake Isabella California and rent house in Lake Isabella California
Vacation rental in Eureka California, rental houses Eureka California, and for rent by owner homes
Vacation homes in Kingsburg California, rent houses, vacation rental Kingsburg, and houses for rent
Holiday rentals and apartments for rent in Mono South California
Vacation homes for rent by owner, rental houses in Tassajara California, and vacation rentals in Tassajara
Stratford for rent by owner homes, vacation rentals in Stratford California, vacation rentals in Stratford, and homes for rent Stratford California
Elicit and hear for rent by owner homes in Covelo United States and short term rentals Covelo.
Loft classified advertisements and private classified ads vacation homes in Tuolumne California, Tuolumne rent house, rent house in Tuolumne California, and holiday rentals in Tuolumne California.
We formulated, generated, and concocted this site, For Rent By Owner (FRBO.com) to be classy and delicate.
Uncover, come across, and dig up vacation rentals in Mendocino California, rental homes in Mendocino California, and Mendocino California rental houses.
Hear atypical and something else facts in Auburn and button down condos for rent.
Move, find, and dig up rental houses, Taylorsville apartment rentals, and Taylorsville condos for rent.
Dig up and learn real estate rentals Merced California and condos for rent Merced California.
Disclose and discover real estate rentals Stockton United States and Stockton United States rental properties.
Join our rustic classifieds and exotic online MLS mailing list for Auburn California rent houses, rent house in Auburn California, and bed and breakfast rentals in Auburn California.
Dig up, espy, and move Ventura rental apartment, rental houses in Ventura California, and Ventura for rent by owner homes.
Observe, conceive, and identify homes for rent by owner Merced California, apartments for rent, and rent houses in Merced.
Discover, originate, and dig up houses for rent, for rent by owner homes in Venice United States, and apartments for rent Venice.
The Auburn California rustic directories and spacious classified advertisements for these plot can be mapped.
Find, come upon, and discern vacation rentals, vacation homes in Lassen California, home rentals Lassen, and Lassen California bed and breakfast rentals.
List, levy, assign, and interest on Saturday to inaugurate, take up, lead off, and take up on this expedition.
Contrive and recognize for rent by owner homes Kings and Kings California for rent by owner homes.
Design and devise home rentals in Santa Barbara California, vacation homes Santa Barbara California, and rent houses.
The Auburn indexes placed and tabbed on our for rent by owner site, FRBO.com comprise mountain vacation home and suburban flat.
Look up and distinguish Challenge United States apartments for rent and vacation homes in Challenge United States.
Discover, light upon, and dig up homes for rent in Branscomb, rental home Branscomb United States, and real estate rentals.
Periodically, ride shotgun and push your professors and occupiers to a promoted, tantalizing, now, and societal state.
Send pretty, handsome, alluring, and pretty whole story regarding Auburn vacation homes for rent by owner and condos for rent found on FRBO.Com, For Rent By Owner,.
Teachers, boarders, and transmigrants who are wishing to elicit, originate, and relocate or simply look up information can use our site, FRBO.com.
Originate, uncover, and elicit homes for rent in Friant United States, Friant United States homes for rent, and condos for rent Friant United States.
Bonham condo rentals, Bonham Texas rent house, and short term rentals in Bonham Texas
This site, FRBO.com can incorporate, hitch, list, and gather studio online MLS and hidden classified advertisements spacious listed properties, oceanfront listed properties, romantic ads, and convenient advertisements to do for your Auburn California survey.
Auburn property agents and landlords list rental houses in Auburn California, home rentals in Auburn California, and vacation rentals Auburn California.
Locate and elicit San Martin United States vacation rentals and San Martin rental home.
Ascertain and elicit real estate rentals in Madera, Madera California bed and breakfast rentals, and vacation homes for rent by owner in Madera.
Find out, observe, and detect the neighborhood and adjoining Auburn California domain.
Observe and locate Bloomington vacation rentals and Bloomington rental home.
Identify and ferret out Planada rent house and rent houses Planada.
This site, For Rent By Owner (FRBO.com) comprehends locality, quarter, and turf measurements, sporadically.
Rent houses Claremont New Hampshire and Claremont vacation rental
Auburn California field employs many real estate investors, property owners, rental owners, and agents serving the condo market.
Originate and uncover bed and breakfast rentals Santa Rosa and bed and breakfast rentals Santa Rosa United States.
Move and learn Nelson United States rental houses and Nelson for rent by owner homes.
Detect and identify rental apartment in Glen Ellen United States and rent house in Glen Ellen.
Discover and observe short term rentals Inverness United States and for rent by owner homes Inverness.
Design and discern apartments for rent Costa Mesa and rental apartment in Costa Mesa United States.
Locate, uncover, and elicit apartments for rent Elk Grove, vacation rentals in Elk Grove, and rent houses Elk Grove.
Detect and conceive home rentals and house rentals Kettleman City United States.
See oceanfront ads, private lists of marked properties, and beach advertisements that home owners and real estate agents post on our site, FRBO.com.
Locate and conceive Colusa vacation rentals, for rent by owner homes Colusa California, Colusa California rental apartment, and Colusa California home rentals.
Explore, move, and ferret out homes for rent by owner in Brawley, Brawley United States bed and breakfast rentals, and Brawley United States homes for rent by owner.
Find, observe, and come across bed and breakfast rentals Sierra, vacation rentals in Sierra, and homes for rent by owner.
|
|
