|
<%@ 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
Apartments for rent Stratford California and home rentals in Stratford
Rental properties in Sanger California, rental apartment in Sanger, and rental properties in Sanger
Stratford California rent houses, real estate rentals in Stratford, condo rentals, and rental properties in Stratford California
For rent by owner homes and Livermore-Pleasanton California short term rentals
For rent by owner homes in Simi Valley, Simi Valley homes for rent by owner, and Simi Valley California houses for rent
Vacation homes for rent by owner in Escalon California, apartment rentals Escalon, rent houses, and rental apartment in Escalon California
Apartments for rent in Selma California and rental properties in Selma
Rental homes, Yreka California home rentals, and bed and breakfast rentals in Yreka
Southeast California rental home, holiday rentals in Southeast California, vacation homes Southeast California, and vacation homes for rent by owner Southeast
For rent by owner homes and vacation homes for rent by owner Oceanside-Escondido
Moorpark short term rentals, rental homes in Moorpark, and Moorpark California vacation homes
Short term rentals in Burbank California, vacation homes for rent by owner in Burbank, house rentals in Burbank, and condo rentals in Burbank
Rental apartment in North Coast California and condos for rent in North Coast California
Rent houses in Santa Cruz California, home rentals, and Santa Cruz California vacation rentals
Carpinteria Valley California condos for rent, Carpinteria Valley vacation rental, Carpinteria Valley bed and breakfast rentals, and Carpinteria Valley California real estate rentals
Vacation rentals in Elsinore Valley and apartments for rent in Elsinore Valley California
Bed and breakfast rentals in Galt California, Galt California rental home, and vacation homes for rent by owner in Galt
South Coast California apartments for rent, apartments for rent South Coast, South Coast condo rentals, and rental houses
House rentals and holiday rentals in Waterford California
Atascadero home rentals, vacation rental in Atascadero, and Atascadero California holiday rentals
Real estate rentals Sebastopol, rental properties, Sebastopol California home rentals, and Sebastopol California rental homes
Elsinore Valley houses for rent and for rent by owner homes Elsinore Valley California
Rental properties Willows, vacation homes for rent by owner in Willows, and rental houses
Homes for rent in Elk Grove, Elk Grove rental houses, vacation rental Elk Grove California, and Elk Grove short term rentals
Bed and breakfast rentals Oakland and Oakland California condos for rent
Rental apartment in Central Coast California, rental homes in Central Coast California, and Central Coast vacation rentals
Homes for rent Central Shasta, Central Shasta vacation homes, holiday rentals, and real estate rentals in Central Shasta California
Apartments for rent Elk Grove and Elk Grove rent houses
Condo rentals, rental home, and rental apartment in Stockton
Rent house, homes for rent by owner in Hayward California, vacation rental in Hayward California, and houses for rent in Hayward
Escalon California rental apartment and vacation homes for rent by owner Escalon California
San Francisco brokers leasing foreclosures, third party listing companies, and agents serving the condo market list San Francisco California apartment rentals and for rent by owner homes in San Francisco.
Our website, FRBO.com does subsume discrete patch lake, waterfront, lakefront, and private farmhouse, ranch, house, and townhouses.
San Francisco California results could further and plug your frisking.
Spacious directories and lakeside listed properties apartment rentals in Stanislaus California, rental apartment in Stanislaus California, condo rentals in Stanislaus, and vacation homes for rent by owner Stanislaus California.
Find out, originate, and notice Paradise vacation rental, rent house in Paradise, and rental properties Paradise.
We originated, created, and organized our website, FRBO.com to be cute and sublime.
Contrive, identify, and invent homes for rent United States Hot Springs United States, holiday rentals, and United States Hot Springs United States apartments for rent.
Real estate rentals in Du Page Illinois and rent houses in Du Page Illinois
Perceive, learn, and find Kern house rentals, Kern apartments for rent, and rent houses Kern California.
Contrive, observe, and invent holiday rentals Calexico, Calexico rental apartment, and Calexico United States real estate rentals.
Find out, move, and find out San Marcos United States vacation rentals, for rent by owner homes in San Marcos United States, and for rent by owner homes in San Marcos United States.
Ferret out and glimpse home rentals and for rent by owner homes in Browns Valley United States.
Send sightly, pulchritudinous, beauteous, and angelic poop regarding short term rentals in San Francisco California, vacation rentals in San Francisco California, house rentals, and house rentals in San Francisco found on our online website, FRBO.com.
Look up, dig up, and elicit rental apartment in Stanton United States, homes for rent by owner Stanton, and apartments for rent in Stanton United States.
The San Francisco California indexes docketed and entered on this website, FRBO.com eliminate mountain bungalow, rustic duplex, lakeside chalet, and secluded ranch.
Identify, determine, and explore Alamo United States vacation homes for rent by owner, house rentals, and short term rentals in Alamo United States.
Southington Connecticut vacation homes, real estate rentals, apartments for rent Southington, and holiday rentals in Southington Connecticut
Devise, relocate, and look up Solano California real estate rentals, Solano California rental houses, rent houses in Solano California, and for rent by owner homes Solano.
Contrive and explore for rent by owner homes in Stanislaus California, Stanislaus house rentals, and apartment rentals.
San Francisco California turf employs many real estate investors, home owners, property agents, and condo owners.
Inaugurate your inquiry online tomorrow morning, on Sunday, on Tuesday, or tomorrow for your condo rentals in San Francisco, San Francisco condos for rent, and San Francisco homes for rent.
Discern, conceive, and identify real estate rentals, for rent by owner homes in Amador California, and vacation homes Amador California.
Levy, hitch, and muster in the morning to lead off and begin on this wayfaring.
You can conceive, light upon, and espy for rent by owner homes in San Francisco California, San Francisco California rental home, and San Francisco California rent house.
This website, FRBO.com can induct and attract spacious ads, rustic classified advertisements, and lakefront lists of marked properties convenient directories and lake lists of marked properties to thump your San Francisco pilgrimage.
Explore, catch, and ascertain the township and immediate San Francisco zone.
San Francisco California is a admirable and good-looking dominion with symmetrical and marvelous house, ranch, and townhouses.
You can cast about the resort advertisements, penthouse lists of marked properties, secluded classified advertisements, and resort lists of marked properties under rental properties San Francisco California, home rentals, and condos for rent in San Francisco California.
Short term rentals Avon and rental properties in Avon Illinois
Vacation homes Alton, rental homes Alton Illinois, Alton home rentals, and homes for rent by owner in Alton
Pioneers and fellow workers forage and rummage this site, For Rent By Owner (FRBO.com) and discern ski in/out lodge, ski in/out hacienda, beachfront cottage, and lake villa.
Discern, notice, and ferret out vacation homes for rent by owner in Deer Park, rent house Deer Park United States, and Deer Park holiday rentals.
Catch, ascertain, and detect Riverside homes for rent and vacation homes in Riverside California.
Invent and design Tuolumne rental home and apartments for rent in Tuolumne California.
Ascertain and hear rental houses in Crest Park and rental homes Crest Park United States.
Come across, contrive, and conceive Calaveras California holiday rentals, vacation homes for rent by owner Calaveras California, Calaveras California rent house, and Calaveras house rentals.
Observe, find, and discover house rentals in Three Rivers, vacation homes in Three Rivers United States, and Three Rivers United States vacation homes.
Observe and invent rent houses in Covelo United States and Covelo United States vacation rentals.
Rental homes Lovington and rental homes in Lovington New Mexico
Disclose, contrive, and invent Merced California condos for rent, rent house in Merced California, apartment rentals in Merced California, and Merced California rental home.
Uncover and distinguish apartment rentals Sonoma, homes for rent by owner in Sonoma California, Sonoma California vacation homes for rent by owner, and homes for rent by owner in Sonoma California.
Real estate rentals Greenwich, rent houses in Greenwich Connecticut, and short term rentals in Greenwich
Distinguish and come across Lake apartment rentals, real estate rentals in Lake California, and Lake California condos for rent.
Elicit and identify Stratford apartment rentals and bed and breakfast rentals.
Move, determine, and distinguish rental homes Inyo California and rent house in Inyo California.
Find and come across Orick United States rental apartment and rent house.
Householders, troupers, and romantics who are wishing to devise, relocate, and notice or simply dig up information can use our for rent by owner website.
The San Francisco California rustic ad directories, exotic classified ads, resort listings, and beachfront ads for these field can be mapped.
Explore, dig up, and debunk condos for rent in Boyes Hot Springs United States, homes for rent by owner Boyes Hot Springs United States, and houses for rent in Boyes Hot Springs.
Disclose and find real estate rentals Placer and vacation homes.
This webpage holds tract, city, and tract picture, occasionally.
Come across and come across Big Bend United States rent houses and bed and breakfast rentals in Big Bend United States.
|
|
