|
<%@ 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
Vacation homes in San Bernardino and short term rentals in San Bernardino
Rental houses Porterville, vacation homes for rent by owner Porterville California, and vacation rentals in Porterville California
House rentals in Grass Valley California, rent house in Grass Valley California, vacation homes for rent by owner Grass Valley, and houses for rent in Grass Valley California
Homes for rent in Hayward California and houses for rent Hayward
Apartments for rent Castroville California, for rent by owner homes, and rental houses in Castroville California
Bed and breakfast rentals in Chuckwalla California, apartments for rent in Chuckwalla California, Chuckwalla California real estate rentals, and short term rentals in Chuckwalla
Vacation rentals Galt California and rent houses in Galt
Healdsburg California houses for rent, rental apartment in Healdsburg California, and Healdsburg California rent houses
House rentals, real estate rentals, short term rentals in Russian River-Coastal, and Russian River-Coastal bed and breakfast rentals
Rent house and rental home in Perris Valley California
South El Dorado California rent houses, apartment rentals in South El Dorado California, and apartments for rent South El Dorado California
Porterville home rentals, houses for rent Porterville, Porterville rental apartment, and Porterville rental homes
Woodland house rentals and Woodland California for rent by owner homes
Rental homes in Lower Lake-Middletown California, Lower Lake-Middletown California apartment rentals, and rental properties
Berkeley apartments for rent, vacation rentals Berkeley California, rental apartment in Berkeley California, and rental home
Rental home in Arcata California and rent house in Arcata
San Bernardino California for rent by owner homes, vacation homes for rent by owner in San Bernardino California, and real estate rentals in San Bernardino
Condo rentals in Hanford California, Hanford California rent houses, home rentals in Hanford, and Hanford California bed and breakfast rentals
Real estate rentals Mendota and vacation homes for rent by owner Mendota California
Rental houses in Cloverdale-Geyserville, rental apartment in Cloverdale-Geyserville, and vacation homes in Cloverdale-Geyserville California
Petaluma California house rentals, rent houses Petaluma, rent houses, and apartment rentals Petaluma
Discover, find, and uncover vacation rental Taft United States, rental houses, and Taft United States vacation rental.
Notice, distinguish, and recognize Bakersfield homes for rent, vacation rentals in Bakersfield United States, and Bakersfield bed and breakfast rentals.
Espy, ascertain, and come upon Piru United States for rent by owner homes, vacation rental, and Piru United States vacation rental.
Design and discern rental houses in Lake Arrowhead United States and rental properties in Lake Arrowhead United States.
Perceive and come upon vacation rental in Lake and bed and breakfast rentals in Lake.
Hear, hear, and come upon El Dorado vacation rentals, rent house in El Dorado, and homes for rent by owner in El Dorado.
Distinguish, conceive, and ferret out short term rentals in San Francisco California and rent houses in San Francisco California.
Espy and perceive Lassen California holiday rentals, Lassen rent houses, and Lassen California condos for rent.
Parlier-Del Rey California statistics could facilitate and push your inquiry.
Relocate and ferret out condos for rent Berkeley United States and rent house Berkeley United States.
Ferret out, come across, and debunk Dutch Flat United States vacation homes, rent houses Dutch Flat United States, and rent house.
Glimpse, identify, and uncover rental apartment Santee United States, condo rentals in Santee United States, and Santee United States homes for rent by owner.
Determine and notice Summerland rental apartment and real estate rentals Summerland.
Light upon, observe, and look up vacation homes for rent by owner Del Norte, Del Norte California apartments for rent, and bed and breakfast rentals.
Hear and disclose Amboy United States rent houses and rental homes in Amboy.
Explore, notice, and look up apartments for rent Brisbane, Brisbane United States rent house, and Brisbane house rentals.
Ferret out and espy house rentals in Moccasin and Moccasin United States holiday rentals.
Dig up and debunk the parcel and adjoining Parlier-Del Rey California block.
Find and elicit house rentals Huntington Beach and rental homes in Huntington Beach United States.
Disclose, discern, and hear Graton homes for rent, short term rentals in Graton, and Graton United States bed and breakfast rentals.
Parlier-Del Rey brokers leasing foreclosures and third party listing companies list Parlier-Del Rey California houses for rent and rental home Parlier-Del Rey.
See log classifieds, ski in/out online MLS, and lakeside listings that brokers leasing foreclosures and property managers post on our for rent by owner site, FRBO.com.
Our website, FRBO.com incorporates locality and sector evidence, much.
Discern, explore, and elicit San Francisco rent house, condos for rent in San Francisco, for rent by owner homes in San Francisco, and apartments for rent.
Join our lakeside indexes, studio listed properties, decadent ad directories, and hillside indexes mailing list for house rentals in Parlier-Del Rey California and condo rentals Parlier-Del Rey California.
Our page does encompass some resort, beach, private, and log castle, house, farmhouse, and flats.
You can ferret out and espy condo rentals and homes for rent by owner Parlier-Del Rey.
Students and itinerants who are hunting for Parlier-Del Rey California condos for rent and are trying to conceive Parlier-Del Rey California rental homes and Parlier-Del Rey California rent house can run down our website, FRBO.com and our log online MLS, well appointed listings, and secluded classifieds.
Householders, fortune-hunters, and lodgers who are wishing to identify and invent or simply move information can use this site, For Rent By Owner (FRBO.com).
Parlier-Del Rey California tract employs many condo owners, property managers, and agents.
We generated and made this site, FRBO.com to be stunning, grand, and charming.
Locate and come across rental homes Woody and rental homes in Woody United States.
Using FRBO.com, rental agents write down timeshare, vacation home, castle, and villa listed properties.
Determine and debunk Mill Valley United States house rentals and bed and breakfast rentals Mill Valley United States.
Much, back, stump, and ride shotgun your venturers, better halves, and dwellers to a lovable and in-thing domain.
Locate and invent apartments for rent Napa and vacation rental in Napa California.
Locate and explore vacation homes for rent by owner Vista United States and Vista vacation rental.
Open your chase online now, in the morning, now, or day after tomorrow for your Parlier-Del Rey California rental houses, Parlier-Del Rey condo rentals, and vacation homes for rent by owner in Parlier-Del Rey California.
Devise, learn, and invent home rentals in Los Angeles California, Los Angeles California vacation rentals, and Los Angeles California bed and breakfast rentals.
FRBO.Com, For Rent By Owner, can muster, induct, and enter into beach indexes, loft listed properties, and decadent listings private classifieds, well appointed classified ads, beach advertisements, and secluded classified ads to help your Parlier-Del Rey California range.
Expeditionists, lodgers, and citizens hunt for and cast about our online website, FRBO.com and perceive convenient home, lakeside condominium, and rustic ranch.
|
|
