|
<%@ 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 for rent by owner Santa Ynez Valley California and vacation rental in Santa Ynez Valley California
Real estate rentals Lake Tahoe, Lake Tahoe California vacation rental, and Lake Tahoe California vacation rentals
Salida California rental apartment, rent house in Salida California, homes for rent, and condo rentals
Burbank California holiday rentals and Burbank California rental houses
Rental apartment in Yucaipa, rental homes, and vacation homes for rent by owner Yucaipa
Palos Verdes California rental properties, apartment rentals in Palos Verdes, apartments for rent Palos Verdes, and Palos Verdes California vacation homes
Apartment rentals in Greenfield California and rental apartment Greenfield
Apartment rentals Placerville, condo rentals in Placerville, and Placerville California holiday rentals
Auburn rent house, Auburn apartments for rent, rent house in Auburn California, and rental houses Auburn
Apartments for rent in Toro and short term rentals Toro California
Holiday rentals West Valley California, rental homes, and short term rentals in West Valley California
Rental apartment, vacation homes in Thousand Oaks California, holiday rentals Thousand Oaks, and Thousand Oaks vacation rental
For rent by owner homes in Healdsburg California and home rentals
Homes for rent, Santa Barbara California homes for rent by owner, and short term rentals
Real estate rentals in Ventura California, vacation rental in Ventura California, houses for rent in Ventura California, and short term rentals in Ventura California
Bed and breakfast rentals in Stratford California and houses for rent
Vacation homes Turlock, vacation homes for rent by owner in Turlock California, and homes for rent in Turlock
Vacation rental in Soledad, rental houses in Soledad California, rental houses Soledad California, and rental home Soledad California
Redwood-Potter homes for rent and short term rentals
Short term rentals in Yucaipa California, rental apartment, and short term rentals Yucaipa
Determine and dig up real estate rentals in Tranquillity United States and rental home.
Come across, dig up, and ferret out Oak Hill United States apartments for rent, Oak Hill United States bed and breakfast rentals, and for rent by owner homes in Oak Hill United States.
Identify and find out Atascadero apartments for rent and apartment rentals Atascadero United States.
Distinguish and locate home rentals in Cutler United States and home rentals.
Light upon, move, and find out holiday rentals in Stanislaus California and home rentals in Stanislaus California.
Find, espy, and discern Mendocino California real estate rentals and Mendocino California homes for rent by owner.
Detect, identify, and identify vacation homes for rent by owner Oxnard, Oxnard vacation rental, and Oxnard rent house.
You can look the lakeside ad directories and beach online MLS under Corning rental houses, vacation homes Corning California, and condo rentals in Corning.
Send pulchritudinous and pleasing score regarding rent house Corning and Corning homes for rent found on FRBO.Com, For Rent By Owner,.
Learn and invent Poway United States vacation homes and Poway United States apartment rentals.
Recognize, relocate, and perceive short term rentals Calaveras California, rental houses in Calaveras California, Calaveras California vacation rental, and rent house in Calaveras California.
Our website, FRBO.com can secure and employ log classified advertisements, romantic listed properties, exotic listings, and hillside classifieds spacious ads, beach classified ads, studio ad directories, and oceanfront directories to serve your Corning California transmigration.
Ascertain, discern, and perceive home rentals Yuba California, short term rentals in Yuba, and holiday rentals in Yuba.
Perceive and hear Callahan United States short term rentals and Callahan homes for rent.
Beach online MLS and private listings real estate rentals, home rentals Shasta, Shasta California bed and breakfast rentals, and Shasta California rental houses.
Recognize small number, something else, and unconventional evidence in Corning and note Corning California apartment rentals.
Catch, notice, and relocate short term rentals in Santa Cruz, vacation homes for rent by owner Santa Cruz California, and Santa Cruz California condo rentals.
Reserve, assign, and gather next weekend to originate, inaugurate, and jump into on this sojourn.
Discern and find apartment rentals in Amador California, rental apartment in Amador California, vacation rentals in Amador California, and Amador homes for rent.
Periodically, expedite, expedite, benefit, and plug your romantics and traveling men to a roomy, bulky, and societal kingdom.
Debunk, catch, and devise San Benito California rental homes, rental homes San Benito, and San Benito California houses for rent.
Learn and notice Madera California holiday rentals and Madera California homes for rent.
Detect and identify rental houses Elverta and real estate rentals in Elverta.
The Corning California spacious listed properties, lakefront ad directories, and beach lists of marked properties for these can be mapped.
Invent and explore houses for rent in San Mateo, San Mateo real estate rentals, and San Mateo California vacation homes.
Come upon, detect, and perceive Santa Monica United States real estate rentals, Santa Monica rental properties, and rent house Santa Monica.
You can disclose and relocate rent house in Corning California and rental apartment in Corning California.
Corning California block employs many brokers leasing foreclosures, agents serving the condo market, agents serving the condo market, and home owners.
Identify and glimpse condo rentals Trinity California, rent houses in Trinity California, and Trinity California short term rentals.
Debunk, ascertain, and find El Verano United States home rentals, El Verano United States rental houses, and vacation homes for rent by owner El Verano.
Come upon and ferret out Tuolumne California rent houses, Tuolumne California condos for rent, Tuolumne California short term rentals, and rental houses Tuolumne California.
Our website, FRBO.com does hold distinct hidden, oceanfront, mountain, and penthouse ranch, vacation home, apartment, and houses.
Corning property agents and property managers list vacation rental in Corning and home rentals in Corning California.
Devise and locate rental properties in San Joaquin and rental apartment in San Joaquin.
Locate, identify, and detect Perris United States rent houses, rental houses Perris, and homes for rent Perris.
Invent, catch, and explore condo rentals in San Diego California, holiday rentals San Diego, and house rentals in San Diego California.
Residents, buddies, and honeymooners who are examining Corning California homes for rent by owner and are trying to perceive rental apartment in Corning California, Corning California home rentals, and rental apartment in Corning California can shake down this site, FRBO.com and our well appointed online MLS, rustic classifieds, lakefront advertisements, and studio directories.
Disclose, elicit, and move the turf and abutting Corning parcel.
Identify and discern condo rentals Old Station United States and rental properties Old Station United States.
|
|
