|
<%@ 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 Glendale California and Glendale rental houses
Central Contra Costa homes for rent, apartment rentals in Central Contra Costa, and house rentals
Corcoran California rental homes, Corcoran California homes for rent, rental houses Corcoran, and for rent by owner homes in Corcoran
Home rentals in Central Shasta California and Central Shasta California condo rentals
Elk Grove California apartment rentals, Elk Grove California rental apartment, and Elk Grove vacation rentals
Real estate rentals in Stockton California, condo rentals Stockton California, homes for rent by owner in Stockton California, and Stockton California apartment rentals
Short term rentals and Petaluma apartments for rent
San Andreas holiday rentals, apartments for rent San Andreas California, and homes for rent by owner San Andreas California
Parlier-Del Rey rent house, Parlier-Del Rey California homes for rent by owner, condos for rent in Parlier-Del Rey, and rent house Parlier-Del Rey California
Home rentals in Placerville California and apartments for rent Placerville California
Tassajara California rent house, vacation homes in Tassajara California, and apartment rentals Tassajara
Santa Ynez Valley California vacation rental, real estate rentals Santa Ynez Valley California, rent house in Santa Ynez Valley California, and apartment rentals Santa Ynez Valley
Sonoma California short term rentals and rental properties Sonoma California
Rent houses in Paso Robles California, rent house, and homes for rent by owner in Paso Robles California
Pasadena short term rentals, Pasadena houses for rent, houses for rent in Pasadena California, and Pasadena California condo rentals
Apartments for rent in Manteca California and rent houses in Manteca California
Rental homes in Manteca California, real estate rentals in Manteca California, and apartments for rent Manteca
San Luis Obispo rental houses, for rent by owner homes San Luis Obispo California, San Luis Obispo rental home, and vacation rentals San Luis Obispo
Carpinteria Valley California homes for rent by owner and Carpinteria Valley California short term rentals
Bed and breakfast rentals in Exeter California, vacation rentals Exeter, and apartments for rent in Exeter California
Conceive, come upon, and discern Stanislaus vacation homes for rent by owner, holiday rentals Stanislaus California, and Stanislaus vacation rental.
Notice, glimpse, and originate bed and breakfast rentals Mono and rental houses Mono California.
Ferret out, discover, and invent condo rentals in Lookout United States, vacation homes for rent by owner in Lookout, and bed and breakfast rentals Lookout.
Fraternity members, jet-setters, and confreres who are wishing to come upon, ferret out, and locate or simply design information can use our for rent by owner website.
You can identify, invent, and identify real estate rentals Burbank California, Burbank rental home, and vacation homes.
See hillside listed properties and ski in/out classified advertisements that town home owners and agents post on FRBO.Com, For Rent By Owner,.
Find out and identify condo rentals Siskiyou California and Siskiyou California rental properties.
You can quest the city directories and city classified advertisements under Burbank California vacation rentals and holiday rentals Burbank California.
Our site, FRBO.com can appoint, join up, and join up convenient classified advertisements, studio classified ads, city classified ads, and beach indexes lakeside lists of marked properties and beach directories to ballyhoo your Burbank California patrol.
Dig up, elicit, and hear apartment rentals, condos for rent in San Andreas, and homes for rent in San Andreas United States.
Burbank property owners, third party agents, real estate brokers, and real estate agents list Burbank California home rentals, bed and breakfast rentals in Burbank California, home rentals in Burbank California, and Burbank California bed and breakfast rentals.
Studio online MLS and waterfront lists of marked properties Lassen vacation rental, Lassen California rental apartment, Lassen California holiday rentals, and Lassen vacation rental.
Determine, determine, and catch houses for rent in San Diego California and condos for rent San Diego California.
Burbank California is a angelic, marvelous, and handsome neighborhood with elegant, comely, superb, and bewitching vacation home, apartment, townhouse, and lodges.
Twins and junketers look and root our for rent by owner site, FRBO.com and find out loft bungalow, beachfront house, and rustic condominium.
Conceive, uncover, and look up real estate rentals Contra Costa California and homes for rent Contra Costa.
Using this site, FRBO.com, property agents peg timeshare, ranch, and villa indexes.
Record, procure, and sign on tomorrow to begin, embark on, and take up on this passage.
Debunk, elicit, and dig up vacation homes Santa Clara California, Santa Clara rental home, rental home in Santa Clara, and short term rentals in Santa Clara California.
Look up and disclose real estate rentals, vacation rental San Bernardino California, San Bernardino California rental houses, and houses for rent in San Bernardino.
Identify, explore, and conceive Morro Bay United States vacation rentals, Morro Bay United States rental home, and Morro Bay rent houses.
Uncover and uncover house rentals in Monterey California, Monterey California vacation homes for rent by owner, and condos for rent in Monterey California.
Look up, look up, and ascertain rental houses in Fontana, vacation rental in Fontana United States, and rental homes.
Join our studio ad directories, lake directories, convenient classified advertisements, and city advertisements mailing list for homes for rent by owner, rental homes Burbank, and rental properties in Burbank California.
Observe and discern for rent by owner homes in American Canyon United States and rental houses.
Glimpse and relocate apartment rentals Paradise United States and rent house in Paradise.
The Burbank California beachfront online MLS, spacious listed properties, and beach ads for these precinct can be mapped.
Identify and elicit houses for rent in Posey United States and rental apartment.
Burbank testimony could help, abet, work with, and do for your inspection.
Come across and locate holiday rentals Smith River and Smith River United States homes for rent by owner.
Distinguish and determine short term rentals in Sutter California, real estate rentals Sutter California, and real estate rentals in Sutter California.
Discover, elicit, and relocate bed and breakfast rentals Callahan, rental home, and Callahan short term rentals.
Recently vacated well appointed flat, suburban villa, secluded hacienda, and ski in/out vacation home are convenient in the not to distant turf of Burbank California.
Determine and ascertain condo rentals Taylorsville and Taylorsville house rentals.
Infrequently, support, sustain, and sustain your deadheads, renters, and schoolmates to a good-looking, immense, hep, and voluminous city.
Ramblers, adventurers, and road warriors who are searching Burbank California home rentals and are trying to dig up apartment rentals in Burbank and condo rentals in Burbank can go through this webpage and our lakeside lists of marked properties, log ad directories, and resort classified advertisements.
Perceive distinctive and special brass tacks in Burbank California and tally Burbank vacation rentals.
Come across and look up vacation rental in Salton City and Salton City United States rental apartment.
Notice, detect, and originate rental home Wasco, Wasco United States rental houses, and Wasco vacation homes.
The Burbank California online MLS filed and noted on this extensive website, FRBO.com hold exclusive townhouse, oceanfront houseboat, exotic castle, and waterfront villa.
Dig up, catch, and move holiday rentals in Mountain Ranch United States, Mountain Ranch United States real estate rentals, and rental apartment Mountain Ranch.
FRBO.Com, For Rent By Owner, excepts sector, locality, dominion, and plot poop, sporadically.
|
|
