|
<%@ 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 houses Folsom California and real estate rentals in Folsom
Antioch-Pittsburg vacation rentals, rental apartment, and short term rentals in Antioch-Pittsburg California
Rent houses in Santa Rosa California, vacation homes in Santa Rosa California, rental home in Santa Rosa California, and bed and breakfast rentals Santa Rosa
Mendota California bed and breakfast rentals and for rent by owner homes
Apartments for rent in Southeast, Southeast California houses for rent, and Southeast short term rentals
Short term rentals in Tassajara California, Tassajara California home rentals, house rentals in Tassajara, and real estate rentals Tassajara California
Bed and breakfast rentals in El Centro California and El Centro California rental properties
Carpinteria Valley California rent house, houses for rent in Carpinteria Valley, and Carpinteria Valley California apartment rentals
Gonzales California rental houses, Gonzales California short term rentals, Gonzales California rental homes, and Gonzales California condos for rent
Homes for rent by owner Anaheim-Santa Ana-Garden Grove and bed and breakfast rentals in Anaheim-Santa Ana-Garden Grove California
Rent house in Idyllwild, Idyllwild California rental houses, and rental homes in Idyllwild California
Apartments for rent Mendocino-Anderson California, Mendocino-Anderson California for rent by owner homes, vacation rentals Mendocino-Anderson California, and rental properties
Rental houses in West Point-Wilseyville California and apartment rentals in West Point-Wilseyville California
Castroville homes for rent, house rentals Castroville California, and Castroville apartments for rent
Rent house in Shafter, Shafter California rent house, short term rentals in Shafter California, and vacation homes Shafter California
Rental apartment Desert Hot Springs and Desert Hot Springs California homes for rent by owner
Real estate rentals, vacation homes for rent by owner McFarland-Delano California, and rental properties McFarland-Delano
Palos Verdes rental home, Palos Verdes California for rent by owner homes, holiday rentals Palos Verdes, and rent house in Palos Verdes California
House rentals in Arroyo Grande California and rent houses Arroyo Grande
Downey-Norwalk rent houses, rental home, and vacation homes for rent by owner in Downey-Norwalk California
Houses for rent in Palos Verdes, homes for rent by owner in Palos Verdes California, Palos Verdes apartment rentals, and Palos Verdes California rent houses
Vacation homes for rent by owner in Oroville California and Oroville California rent houses
Homes for rent in Arcata California, rental houses, and condos for rent Arcata California
Thousand Oaks California apartment rentals, vacation homes for rent by owner in Thousand Oaks, Thousand Oaks California vacation rental, and Thousand Oaks California condo rentals
Locate, learn, and devise short term rentals Napa California, vacation rentals in Napa California, house rentals in Napa California, and apartments for rent.
Our webpage comprehends county, township, zone, and territory dossier, habitually.
Using our website, FRBO.com, third party listing companies spell out condominium and flat classifieds.
Occupants, venturers, and fortune-hunters who are wishing to recognize, identify, and design or simply recognize information can use our for rent by owner website.
We formulated, established, and invented our online website, FRBO.com to be admirable, radiant, lovely, and nice.
Recently available beachfront duplex, convenient townhouse, and convenient cottage are adjoining in the near-at-hand township of Corcoran California.
Discover, notice, and originate Sunset Beach condo rentals, homes for rent by owner Sunset Beach, and holiday rentals.
Discover and identify vacation homes in Arbuckle United States and vacation rental Arbuckle.
Notice and explore rent houses in Los Banos United States and holiday rentals Los Banos.
Discern, elicit, and identify holiday rentals in Glenn California and real estate rentals.
Detect and light upon Grover Beach apartment rentals and Grover Beach United States rent houses.
Conceive and uncover Madera California apartments for rent, short term rentals Madera California, and home rentals in Madera California.
Invent and espy vacation rentals La Honda United States and rent house La Honda United States.
Detect, learn, and ascertain bed and breakfast rentals in Riverside, bed and breakfast rentals in Riverside United States, and apartments for rent in Riverside.
Conceive and explore rental home Pinon Hills and short term rentals Pinon Hills.
Debunk and learn the turf and not far Corcoran stretch.
Espy, perceive, and dig up Colusa California homes for rent by owner, homes for rent in Colusa California, and homes for rent Colusa California.
See resort online MLS and lakefront ad directories that real estate brokers and agents post on FRBO.com.
Move and elicit condos for rent Sonoma California and bed and breakfast rentals in Sonoma California.
Corcoran real estate investors, rental agents, land owners, and town home owners list bed and breakfast rentals in Corcoran, short term rentals in Corcoran California, Corcoran California homes for rent by owner, and Corcoran California rent house.
Elicit and recognize house rentals in Whitmore and Whitmore United States for rent by owner homes.
Discover and distinguish Inverness United States apartment rentals and condo rentals Inverness.
Move and locate holiday rentals Trabuco Canyon and vacation rental in Trabuco Canyon United States.
You can dig up, dig up, and conceive Corcoran California holiday rentals, homes for rent by owner in Corcoran California, and Corcoran California real estate rentals.
Glimpse, explore, and invent rental properties and Alpine houses for rent.
Catch and devise rental apartment Ventura California and bed and breakfast rentals in Ventura.
|
|
