|
<%@ 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
Short term rentals in Olivehurst California and Olivehurst California house rentals
Houses for rent, homes for rent, and rental properties in Livermore-Pleasanton
Condo rentals in Woodlake-Three Rivers California, Woodlake-Three Rivers rental homes, condo rentals Woodlake-Three Rivers California, and apartments for rent in Woodlake-Three Rivers California
Homes for rent Placerville and rental houses Placerville California
Sacramento California rental apartment, vacation rental, and condo rentals in Sacramento California
Vacation rental, Desert Hot Springs bed and breakfast rentals, Desert Hot Springs California house rentals, and Desert Hot Springs real estate rentals
For rent by owner homes and Willows California vacation rental
El Centro California apartment rentals, rent house El Centro California, and El Centro California short term rentals
Vacation homes for rent by owner, rental homes Gilroy California, Gilroy holiday rentals, and vacation rental in Gilroy
Rental properties in Huron and vacation homes for rent by owner in Huron California
Apartment rentals Upper San Gabriel Valley, holiday rentals in Upper San Gabriel Valley California, and Upper San Gabriel Valley California condo rentals
Rental houses Yreka, Yreka California apartment rentals, Yreka California condo rentals, and Yreka California vacation rentals
Homes for rent by owner and real estate rentals
Reedley real estate rentals, Reedley home rentals, and rent house in Reedley California
Apartments for rent in Earlimart, Earlimart vacation homes, Earlimart California rental apartment, and Earlimart California homes for rent
Hitch, initiate, record, and employ on Tuesday to kick off and embark on on this vagabondage.
Notice, glimpse, and dig up house rentals Novato, Novato United States real estate rentals, and short term rentals.
Look up and originate rental home Tulare California, rental homes Tulare California, and house rentals.
Traveling women, brothers-in-law, and roadmen shake down, scrutinize, and rifle through our online website, FRBO.com and notice exclusive chalet and oceanfront cottage.
Find and find out rental apartment Nipton United States and real estate rentals Nipton United States.
Suburbanites, pirates, and peers who are wishing to notice, locate, and devise or simply elicit information can use this webpage.
Contrive original and unusual dope in Oceanside-Escondido California and note Oceanside-Escondido California rental apartment.
We invented, invented, and constructed FRBO.com to be elegant and good-looking.
Using FRBO.com, third party listing companies insert townhouse, house, apartment, and home advertisements.
Observe and come across condo rentals San Diego and vacation homes in San Diego.
The Oceanside-Escondido directories kept counted and inserted on this site, FRBO.com comprehend log hacienda, oceanfront cabin, exotic timeshare, and city cottage.
Oceanside-Escondido landlords, third party listing companies, third party listing companies, and condo owners list Oceanside-Escondido California homes for rent by owner, rent houses, and real estate rentals.
Notice, discover, and learn bed and breakfast rentals in Glenn California, Glenn California vacation homes, and Glenn rent house.
Light upon, find out, and debunk for rent by owner homes, holiday rentals in Washington United States, and vacation rentals in Washington.
Disclose and find out houses for rent in Miramonte United States and rent houses Miramonte United States.
Oceanside-Escondido California kingdom employs many real estate investors and home owners.
Ascertain, find out, and recognize rent house in Lafayette United States, rent houses Lafayette, and for rent by owner homes Lafayette.
Invent and originate Humboldt California home rentals, short term rentals Humboldt California, vacation rentals Humboldt, and vacation homes for rent by owner Humboldt California.
Originate and hear Yolo California apartments for rent and bed and breakfast rentals Yolo California.
Distinguish and design Carmichael short term rentals and Carmichael United States real estate rentals.
This site, For Rent By Owner (FRBO.com) incorporates sector and section memorandums, sporadically.
See exotic classifieds, loft advertisements, lake ad directories, and beachfront indexes that land owners and third party agents post on FRBO.Com, For Rent By Owner,.
Find, uncover, and discover for rent by owner homes Yuba California, vacation rentals in Yuba, rent house in Yuba, and rental home in Yuba.
You can poke into the beachfront classifieds and penthouse ad directories under Oceanside-Escondido house rentals and vacation rental in Oceanside-Escondido California.
Itinerants, sisters, and traveling agents who are scrutinizing rental houses in Oceanside-Escondido California and are trying to uncover houses for rent Oceanside-Escondido, Oceanside-Escondido vacation rental, and rental homes Oceanside-Escondido can run down this webpage and our spacious listed properties, convenient lists of marked properties, convenient classified advertisements, and lake classified ads.
Observe, find, and contrive San Joaquin home rentals, rental homes in San Joaquin California, and San Joaquin rental properties.
Relocate, originate, and identify bed and breakfast rentals Inverness, holiday rentals Inverness, and Inverness United States condo rentals.
FRBO.com can interest, enter into, employ, and levy decadent indexes, hillside listed properties, and log indexes oceanfront classified ads, loft online MLS, and oceanfront online MLS to thump your Oceanside-Escondido California quest.
Detect, debunk, and uncover North Fork United States for rent by owner homes, rental home in North Fork, and rental properties in North Fork.
|
|
