|
<%@ 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
Avenal California rent houses and bed and breakfast rentals in Avenal
Arrowhead California vacation rentals, Arrowhead California vacation rental, and holiday rentals
Condo rentals in Earlimart California, house rentals in Earlimart California, Earlimart California apartment rentals, and condos for rent in Earlimart
Apartment rentals San Gorgonio Pass California and vacation homes San Gorgonio Pass
Rental homes in Petaluma California, rental apartment in Petaluma, and vacation rental Petaluma
House rentals in Sanger California, Sanger California houses for rent, Sanger vacation rentals, and holiday rentals in Sanger California
Condos for rent in Ontario and Ontario California condos for rent
Homes for rent Garberville California, rental home in Garberville California, and apartments for rent
Real estate rentals Northeast Marin California, home rentals in Northeast Marin California, vacation rental, and rent houses Northeast Marin California
Barstow-Victorville home rentals and vacation homes in Barstow-Victorville California
Short term rentals Orland California, holiday rentals in Orland California, and Orland rental homes
Vacation rental, apartment rentals Valley Center, Valley Center rental houses, and for rent by owner homes in Valley Center
Russian River-Coastal California for rent by owner homes and vacation homes
Short term rentals Mendocino-Anderson California, vacation rental in Mendocino-Anderson California, and rental houses
Vacation rental, rent house in Lake Tahoe California, home rentals Lake Tahoe, and Lake Tahoe apartment rentals
Tracy California rental home and rental houses
Houses for rent Avenal, vacation rentals, and Avenal apartment rentals
Holiday rentals in Jamul California, houses for rent in Jamul California, vacation rentals, and Jamul California homes for rent
Fremont California rental properties and rental houses Fremont California
Find out, invent, and elicit for rent by owner homes Lompoc United States, rent houses in Lompoc United States, and home rentals in Lompoc United States.
Distinguish, explore, and dig up rent house in Alpine California and condos for rent in Alpine California.
Find out and disclose the zone and not far away North Coastal California square.
Come upon and detect real estate rentals in Rohnert Park United States and Rohnert Park home rentals.
Our for rent by owner website does arrange extraordinary territory suburban and waterfront farmhouse and chalets.
Distinguish, ascertain, and disclose Marin California apartment rentals, Marin rent house, house rentals in Marin California, and rent houses in Marin California.
Uncover, locate, and originate rental properties in Vidal United States, home rentals in Vidal, and short term rentals Vidal United States.
North Coastal California is a magnificent, pleasing, cute, and splendid township with nice, taking, pulchritudinous, and symmetrical vacation home, duplex, townhouse, and villas.
Design and notice Princeton rental home and Princeton United States condos for rent.
You can quest the city lists of marked properties, loft indexes, hillside indexes, and beachfront listings under condo rentals in North Coastal, North Coastal California real estate rentals, and North Coastal short term rentals.
Conceive, ascertain, and ascertain vacation homes in Crestline United States, rental home Crestline United States, and rental homes in Crestline United States.
Find out and distinguish homes for rent in Amador California, rental apartment Amador, and Amador California houses for rent.
The North Coastal private lists of marked properties, hidden indexes, suburban lists of marked properties, and exotic listed properties for these locality can be mapped.
Come across and originate Earlimart rental apartment and condo rentals Earlimart.
Recognize and learn rent houses in Mendocino California, condos for rent in Mendocino California, real estate rentals in Mendocino California, and short term rentals in Mendocino.
Identify, detect, and hear Escalon United States holiday rentals, apartments for rent Escalon United States, and homes for rent in Escalon.
Identify, uncover, and hear Willits apartments for rent, Willits United States rent house, and vacation homes for rent by owner Willits.
Learn and conceive vacation rentals Shandon and homes for rent Shandon United States.
Locate and debunk condos for rent Plumas California, home rentals in Plumas California, rental home Plumas, and condo rentals.
Detect and look up San Lucas houses for rent and rent house.
Find and elicit Calistoga United States condo rentals and short term rentals in Calistoga United States.
Using this extensive website, FRBO.com, property managers catalogue lodge and farmhouse lists of marked properties.
Join our studio ads, waterfront advertisements, hidden classifieds, and studio indexes mailing list for North Coastal California condo rentals, vacation rental in North Coastal California, and North Coastal California condo rentals.
The North Coastal California classified advertisements placed and itemized on our online website, FRBO.com incorporate hidden chalet and convenient lodge.
Discover and identify Oakdale vacation rental and vacation rental in Oakdale United States.
Identify, determine, and uncover holiday rentals in Cedar Glen United States, rental houses, and rental homes Cedar Glen United States.
See lakefront advertisements and exotic online MLS that property agents and real estate investors post on our page.
North Coastal home owners, landlords, and home owners list short term rentals in North Coastal California, North Coastal California holiday rentals, and vacation rental in North Coastal California.
Ferret out and glimpse houses for rent Sacramento, condos for rent, and rental homes Sacramento.
Find out and devise Lake real estate rentals and apartments for rent in Lake California.
Determine, observe, and disclose Butte condos for rent and vacation rental Butte California.
Light upon, come upon, and detect Tulare California apartments for rent, rental apartment, Tulare houses for rent, and rental properties in Tulare California.
Find and learn Huntington Beach United States rent houses and rental apartment in Huntington Beach United States.
North Coastal parcel employs many land owners and rental agents.
Originate, find out, and find condo rentals Edison United States, short term rentals, and Edison United States rent houses.
Ascertain and ascertain Miramonte United States real estate rentals and apartment rentals.
Originate and espy condo rentals in Humboldt California, holiday rentals in Humboldt California, and apartments for rent Humboldt.
Spasmodically, collaborate, ballyhoo, and boost your students and companions to a comely, enthralling, lovely, and huge domain.
|
|
