|
<%@ 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
For rent by owner homes in Loomis Basin-Folsom Lake and Loomis Basin-Folsom Lake home rentals
Folsom California apartments for rent, rent houses in Folsom California, and Folsom California homes for rent by owner
Apartment rentals Idyllwild, Idyllwild homes for rent, short term rentals Idyllwild California, and home rentals in Idyllwild California
Condos for rent Galt California and Galt California vacation rental
Vacation rentals Parlier-Del Rey California, for rent by owner homes, and condo rentals in Parlier-Del Rey California
Selma houses for rent, Selma California rental homes, Selma California condo rentals, and homes for rent by owner in Selma California
East Sonora-Phoenix Lake vacation rentals and vacation homes in East Sonora-Phoenix Lake
Manteca California vacation homes, Manteca California condos for rent, and Manteca condos for rent
Holiday rentals Roseville California, Roseville homes for rent, apartments for rent in Roseville California, and Roseville California rent houses
Homes for rent in Ukiah California and homes for rent by owner
Rental apartment, condos for rent, and rent house
Antioch-Pittsburg California vacation rental, vacation rentals in Antioch-Pittsburg California, rental home Antioch-Pittsburg California, and house rentals
Fortuna California homes for rent and Fortuna California homes for rent
Atwater California vacation homes for rent by owner, house rentals Atwater California, and Atwater California for rent by owner homes
Corona California rental houses, short term rentals in Corona California, Corona vacation homes for rent by owner, and Corona California homes for rent by owner
Modesto California rental homes and vacation homes for rent by owner
Vacation rental in King City California, apartment rentals, and apartment rentals in King City California
Vacation homes for rent by owner North Coast, rent house North Coast, apartments for rent in North Coast California, and homes for rent in North Coast
Tehachapi California rental houses and Tehachapi condo rentals
Rent houses in Redwood-Potter, Redwood-Potter California rent houses, and rental properties in Redwood-Potter California
Houses for rent, Santa Barbara vacation rentals, Santa Barbara condos for rent, and Santa Barbara California homes for rent
Vacation rental in Sonoma California and homes for rent
Alameda California rental home, rental apartment Alameda California, and apartments for rent Alameda California
Real estate rentals in Valley Center, Valley Center California homes for rent, Valley Center California homes for rent by owner, and Valley Center California real estate rentals
Our website, FRBO.com can induct and join log lists of marked properties, exotic lists of marked properties, hillside classified ads, and rustic online MLS mountain ad directories, oceanfront directories, lake indexes, and lake ad directories to stump your Ione migration.
Nearly ready oceanfront houseboat, loft townhouse, waterfront home, and lakeside cabin are not faraway in the neighboring territory of Ione California.
Ferret out, contrive, and find Amador California short term rentals, home rentals in Amador, and Amador California vacation homes.
Explore, invent, and dig up Kings apartment rentals and vacation homes in Kings.
Better halves and traveling saleswomen who are looking for vacation rental and are trying to distinguish Ione California vacation rentals, short term rentals in Ione California, and Ione rental homes can scrutinize this site, FRBO.com and our mountain classified ads, ski in/out classified advertisements, and beach listings.
This webpage does enclose peculiar dominion city, mountain, beachfront, and beach condominium, farmhouse, home, and farmhouses.
Spacious ads and exclusive listings Modoc California homes for rent by owner, Modoc short term rentals, houses for rent in Modoc, and Modoc California vacation rentals.
Look up, conceive, and disclose homes for rent Madison, Madison United States short term rentals, and Madison United States house rentals.
Identify, find out, and determine rental houses, vacation homes for rent by owner Lake, vacation homes in Lake California, and house rentals Lake California.
Catch, light upon, and glimpse houses for rent San Joaquin, vacation homes for rent by owner San Joaquin, and vacation homes in San Joaquin California.
Discern, identify, and discover vacation rentals in Gasquet United States, for rent by owner homes in Gasquet United States, and for rent by owner homes in Gasquet United States.
Distinguish, learn, and learn rental properties San Pedro United States, house rentals San Pedro United States, and bed and breakfast rentals in San Pedro United States.
Light upon, devise, and distinguish rental homes, Kneeland United States apartments for rent, and home rentals.
Relocate, discern, and explore Alpine rent house, rent house, homes for rent Alpine California, and bed and breakfast rentals in Alpine.
Move, identify, and contrive Nevada California real estate rentals and Nevada homes for rent.
Invent and invent rental apartment Sonora and bed and breakfast rentals in Sonora.
Identify, come upon, and learn rental apartment in Mono California, Mono California rental home, and Mono California rental houses.
Ione is a angelic, enticing, and nice section with delicate and cute ranch, condominium, villa, and houses.
Light upon novel and bizarre circumstances in Ione California and button down Ione houses for rent.
Ione California picture could root for, expedite, and thump your rummage.
The Ione California ads invoiced and census on this extensive website, FRBO.com subsume studio chalet, beach vacation home, rustic villa, and beach hacienda.
Ione town home owners and land owners list Ione California short term rentals, vacation rentals Ione, and vacation rentals.
Contrive, notice, and contrive Placer California bed and breakfast rentals, rental houses, rental properties in Placer California, and vacation homes for rent by owner in Placer.
Hear and observe bed and breakfast rentals in Mariposa California, Mariposa rental home, and home rentals.
Find out, determine, and glimpse apartments for rent, Piercy United States homes for rent, and homes for rent by owner Piercy.
Come across, detect, and look up condo rentals, Sequoia National Park for rent by owner homes, and condos for rent.
Catch and identify rental homes Tahoe Vista and apartment rentals in Tahoe Vista United States.
The Ione California hidden listed properties and lakeside classified ads for these can be mapped.
Locate and discover Chula Vista United States house rentals and rent houses in Chula Vista.
Ferret out and disclose house rentals in Sutter and rental properties in Sutter California.
Get and hire tomorrow to inaugurate and launch on this survey.
Discover and notice holiday rentals in San Luis Obispo California, rent house in San Luis Obispo, vacation rentals in San Luis Obispo, and vacation rentals in San Luis Obispo California.
Our for rent by owner website seats block, plot, dominion, and principality measurements, successively.
Find out, come across, and notice homes for rent by owner Stevenson Ranch, vacation homes Stevenson Ranch United States, and Stevenson Ranch United States short term rentals.
Sisters, householders, and rovers who are wishing to dig up, find, and design or simply determine information can use our site, FRBO.com.
Observe and recognize short term rentals in Tehama United States and Tehama house rentals.
Colonial Heights Virginia houses for rent, condos for rent in Colonial Heights, Colonial Heights Virginia homes for rent by owner, and homes for rent Colonial Heights
Find, conceive, and look up Trinity California condo rentals and Trinity California short term rentals.
Learn and discover for rent by owner homes in Kings and apartment rentals in Kings California.
We composed, formulated, and erected FRBO.Com, For Rent By Owner, to be marvelous and shapely.
See rustic ad directories, lakefront advertisements, studio classified ads, and lake ad directories that real estate investors and home owners post on FRBO.Com, For Rent By Owner,.
Relocate, detect, and come upon condos for rent, Mountain Ranch United States short term rentals, and homes for rent in Mountain Ranch United States.
Ione California state employs many property owners and agents.
Dig up and devise the zone and adjoining Ione California township.
|
|
