|
<%@ 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
Rent house Ross Valley California and Ross Valley California for rent by owner homes
Mono South California rental home, Mono South apartments for rent, and home rentals
Condos for rent in Yreka, apartment rentals Yreka, homes for rent, and homes for rent by owner in Yreka California
Bed and breakfast rentals in Ontario California and Ontario California houses for rent
Vacation rentals, rental houses in Woodlake-Three Rivers, and rental apartment in Woodlake-Three Rivers California
Rental apartment in Livingston-Delhi, for rent by owner homes in Livingston-Delhi California, vacation homes Livingston-Delhi California, and condo rentals Livingston-Delhi California
Condo rentals in Seaside-Monterey California and Seaside-Monterey apartments for rent
San Diego California holiday rentals, rent houses, and houses for rent in San Diego
Homes for rent in Antioch-Pittsburg California, homes for rent by owner in Antioch-Pittsburg, bed and breakfast rentals in Antioch-Pittsburg California, and house rentals Antioch-Pittsburg California
Home rentals in Twain Harte-Tuolumne City California and houses for rent in Twain Harte-Tuolumne City California
Rosedale California vacation homes, rent houses in Rosedale California, and home rentals in Rosedale California
Vacation homes in Northeast Marin California, holiday rentals Northeast Marin California, rental homes in Northeast Marin California, and homes for rent in Northeast Marin
House rentals Kingsburg California and house rentals Kingsburg California
Holiday rentals Fortuna, house rentals in Fortuna California, and Fortuna California houses for rent
Short term rentals in Twentynine Palms-Morongo Valley, condos for rent, Twentynine Palms-Morongo Valley home rentals, and Twentynine Palms-Morongo Valley California short term rentals
Antioch-Pittsburg real estate rentals and Antioch-Pittsburg California condos for rent
Apartment rentals Ramona, real estate rentals in Ramona California, and Ramona homes for rent
For rent by owner homes, apartment rentals in Chico, Chico California rental apartment, and vacation rentals in Chico California
House rentals Lake Tahoe California and rental houses in Lake Tahoe
Oroville California vacation rentals, vacation homes Oroville California, and homes for rent in Oroville California
Find and disclose Santa Ana United States holiday rentals and for rent by owner homes in Santa Ana United States.
Originate and find out rental apartment Alpine California, Alpine rent house, for rent by owner homes, and homes for rent by owner Alpine California.
Discern, dig up, and move Branscomb United States rent house, Branscomb United States vacation rentals, and Branscomb United States rent house.
Ascertain distinct, distinctive, and unique facts in Madera California and inscribe apartments for rent Madera California.
The Madera California beach ad directories, beach ad directories, beach classifieds, and lakefront classifieds for these can be mapped.
Conceive and catch Trinity California apartments for rent, rent houses in Trinity, rental apartment Trinity, and Trinity California houses for rent.
Move and light upon Yuba California condos for rent and rent house Yuba.
Disclose and originate Maywood United States rental properties and Maywood United States houses for rent.
Find out and originate rental apartment in Shasta California and vacation rentals in Shasta California.
Distinguish, come upon, and detect bed and breakfast rentals Oakley United States, Oakley United States apartment rentals, and Oakley United States house rentals.
Elicit and invent Yuba houses for rent, Yuba California house rentals, and condo rentals in Yuba California.
Uncover, come upon, and disclose vacation homes Alpine California and vacation homes in Alpine California.
Observe, espy, and perceive Pinecrest United States vacation homes for rent by owner, short term rentals in Pinecrest United States, and real estate rentals in Pinecrest United States.
Move, notice, and perceive Sacramento California condo rentals, Sacramento California short term rentals, and rental homes.
Madera real estate investors, agents serving the condo market, and real estate brokers list homes for rent Madera, Madera California vacation rental, and for rent by owner homes Madera California.
Disclose, devise, and ferret out for rent by owner homes in Westmorland, Westmorland United States rental home, and Westmorland United States condos for rent.
Madera California quarter employs many condo owners, town home owners, brokers leasing foreclosures, and brokers leasing foreclosures.
Look up, devise, and ferret out short term rentals Riverside, vacation homes Riverside, vacation homes in Riverside California, and rental apartment in Riverside California.
Uncover and elicit home rentals Holtville United States and apartments for rent in Holtville United States.
Find, uncover, and notice apartments for rent in Wilseyville United States, Wilseyville apartment rentals, and Wilseyville United States vacation homes.
Madera California picture could do for, assist, ballyhoo, and facilitate your exploration.
Disclose, espy, and debunk short term rentals Creston United States, homes for rent Creston United States, and Creston United States homes for rent by owner.
Learn, ascertain, and recognize apartments for rent in Santa Barbara California, short term rentals in Santa Barbara California, and Santa Barbara apartments for rent.
Muster, initiate, and enter this weekend to launch and lead off on this progress.
Catch, contrive, and come across the precinct and approaching Madera neighborhood.
Ascertain and relocate for rent by owner homes in Pacific Grove United States and real estate rentals.
Notice and distinguish house rentals and homes for rent Pacoima United States.
Roommates and fortune-hunters look over, check, and look for our for rent by owner site, FRBO.com and contrive spacious apartment, mountain hacienda, decadent hacienda, and resort houseboat.
Elicit, hear, and notice bed and breakfast rentals in Nevada California and house rentals Nevada California.
Madera California is a comely and comely precinct with fair, lovely, and statuesque hacienda and ranchs.
Join our ski in/out classifieds, ski in/out lists of marked properties, and decadent ad directories mailing list for Madera rental apartment and holiday rentals in Madera.
Using our online website, FRBO.com, property managers invoice duplex, lodge, chalet, and villa classified ads.
This site, For Rent By Owner (FRBO.com) does embody rare area lakefront, hidden, ski in/out, and loft home, ranch, apartment, and timeshares.
This site, FRBO.com can appoint, enroll, and register decadent ads, ski in/out classified advertisements, waterfront online MLS, and convenient indexes city online MLS and private classified ads to thump your Madera California progress.
Come across and invent rental apartment in San Luis Obispo California, San Luis Obispo rent houses, and San Luis Obispo California apartments for rent.
Perceive and debunk rental houses in Ross United States and Ross rent houses.
Free oceanfront castle, city vacation home, and loft farmhouse are not to distant in the handy city of Madera California.
Explore and determine rent houses in Delhi United States and short term rentals.
Look up and explore rental properties in Mendocino and rental homes in Mendocino California.
Brides, natives, and citizens who are scrutinizing rental homes Madera California and are trying to invent rental properties in Madera California and rent houses Madera can prospect this website, FRBO.com and our spacious online MLS, hidden ad directories, convenient indexes, and exotic ads.
Locate and contrive homes for rent Cayucos and real estate rentals in Cayucos United States.
Embark on your pursuance online tomorrow, tomorrow morning, tomorrow evening, or in the next few days for your for rent by owner homes Madera, Madera rental houses, and bed and breakfast rentals in Madera.
Distinguish, learn, and uncover holiday rentals in Lake California, rent house, and Lake California holiday rentals.
You can locate, come across, and design house rentals Madera California, Madera California homes for rent, and houses for rent in Madera California.
You can inquire the exotic advertisements, spacious classified advertisements, exclusive classified ads, and penthouse classifieds under apartments for rent in Madera California and rental apartment in Madera California.
Distinguish and identify rental apartment and vacation homes in Tarzana United States.
Detect, detect, and discover Sierra City United States for rent by owner homes, rent house in Sierra City United States, and homes for rent.
|
|
