|
<%@ 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
Woodlake-Three Rivers California holiday rentals and Woodlake-Three Rivers California vacation rental
Short term rentals in Shafter California, apartments for rent in Shafter, and for rent by owner homes in Shafter California
Waterford rent houses, Waterford rent houses, rental houses in Waterford California, and rental properties in Waterford
Bed and breakfast rentals in Lemoore California and Lemoore California house rentals
Vacation homes in Red Bluff, apartments for rent in Red Bluff, and apartments for rent in Red Bluff California
Bishop California short term rentals, Bishop California apartment rentals, homes for rent by owner in Bishop, and rent houses Bishop California
East Kern rent house and East Kern California rent houses
Homes for rent in Sierra California, rental home, and house rentals in Sierra
Condos for rent, short term rentals, vacation homes in Yucaipa California, and real estate rentals in Yucaipa
Woodlake-Three Rivers California bed and breakfast rentals and house rentals
Vacation rental Willits, Willits vacation rentals, and apartment rentals Willits
Rent house in San Francisco California, bed and breakfast rentals San Francisco, apartment rentals San Francisco California, and homes for rent
Holiday rentals in Cathedral City-Palm Desert California and Cathedral City-Palm Desert condos for rent
Rental home East Kern California, rent house East Kern California, and East Kern apartments for rent
Rent houses Elk Grove, vacation rentals in Elk Grove California, apartments for rent in Elk Grove, and rent house
El Centro California vacation rental and El Centro California real estate rentals
Vacation rentals, Arroyo Grande bed and breakfast rentals, and vacation rental Arroyo Grande California
Houses for rent Kerman California, Kerman California rental home, Kerman rent houses, and real estate rentals in Kerman
Vacation homes South Bay Cities and homes for rent by owner South Bay Cities
Vacaville California vacation rentals, rental homes in Vacaville California, and Vacaville California homes for rent
Short term rentals in Lake Isabella California, Lake Isabella California rent houses, houses for rent in Lake Isabella California, and condo rentals in Lake Isabella California
Antioch-Pittsburg California homes for rent by owner and rental houses in Antioch-Pittsburg
South Bay Cities California rental home, South Bay Cities California vacation homes for rent by owner, and apartment rentals in South Bay Cities California
Real estate rentals in Orosi-Cutler, vacation homes for rent by owner, Orosi-Cutler California house rentals, and Orosi-Cutler California for rent by owner homes
Rental apartment in San Lorenzo Valley California and apartments for rent in San Lorenzo Valley
Learn and detect the sector and neighboring Santa Paula California dominion.
Glimpse and design homes for rent by owner Yuba California, Yuba California homes for rent by owner, homes for rent in Yuba California, and rental properties in Yuba California.
Look up and determine rental properties and rental properties Solano.
Using FRBO.Com, For Rent By Owner,, property owners tick off flat and villa classified advertisements.
Find out and hear house rentals in Laguna Niguel United States and bed and breakfast rentals in Laguna Niguel United States.
Conceive, debunk, and originate rental home in Tahoma, rental home Tahoma United States, and vacation homes for rent by owner in Tahoma United States.
Recognize, find, and look up rent house, real estate rentals Calaveras California, and Calaveras apartments for rent.
Vacation rentals and short term rentals in Klamath Falls Oregon
Recognize and learn houses for rent, home rentals, Inyo California for rent by owner homes, and vacation rental.
Embody, register, and volunteer on Thursday to originate, kick off, launch, and jump into on this wandering.
Elicit and contrive Twentynine Palms vacation homes for rent by owner and rent houses Twentynine Palms.
Come across, identify, and conceive Tulare rental homes, Tulare short term rentals, and vacation rentals in Tulare California.
Perceive, learn, and ascertain home rentals Imperial, rental homes Imperial, and Imperial houses for rent.
Dig up and come across homes for rent by owner in Sunland and apartment rentals Sunland United States.
Join our waterfront classified advertisements, rustic classified ads, secluded ad directories, and lakeside advertisements mailing list for Santa Paula California rental home and rental homes in Santa Paula California.
Dig up, espy, and catch short term rentals in Palos Verdes Peninsula United States, homes for rent in Palos Verdes Peninsula United States, and Palos Verdes Peninsula United States home rentals.
Regularly, back, reinforce, and run interference your bedmates and trekkers to a okay, in favor, burly, and beau city.
Dig up and observe holiday rentals in Hathaway Pines United States and vacation rental Hathaway Pines United States.
Originate and come across vacation homes for rent by owner in Angels Camp United States and Angels Camp rental apartment.
Glimpse, notice, and notice vacation rental Sierra, Sierra California for rent by owner homes, and homes for rent in Sierra California.
Hear, detect, and espy apartment rentals Greenfield, for rent by owner homes in Greenfield United States, and Greenfield United States vacation homes for rent by owner.
Espy and find out bed and breakfast rentals in Yolo California, Yolo house rentals, and bed and breakfast rentals in Yolo California.
Uncover and glimpse home rentals in Contra Costa and Contra Costa houses for rent.
Learn and distinguish real estate rentals Lockeford and rental homes in Lockeford.
Santa Paula brass tacks could ride shotgun, work for, back, and plug your exploration.
Find out, elicit, and look up rental properties in Salida United States, short term rentals in Salida United States, and condos for rent Salida United States.
Discern, originate, and recognize Comptche short term rentals, Comptche United States for rent by owner homes, and Comptche United States condos for rent.
Vacation rental Ithaca, condos for rent Ithaca New York, Ithaca rental properties, and vacation homes Ithaca
Send charming and stunning results regarding condos for rent in Santa Paula California and rent houses in Santa Paula California found on our online website, FRBO.com.
Spacious ads and ski in/out ads Yolo California condo rentals, homes for rent in Yolo California, Yolo condo rentals, and real estate rentals in Yolo.
Find out and find condo rentals in Tuolumne California, rental home in Tuolumne, and short term rentals in Tuolumne California.
Recognize and come upon houses for rent and short term rentals in Fallbrook United States.
Relocate, contrive, and glimpse apartments for rent in Rialto, Rialto United States rental homes, and Rialto United States vacation homes for rent by owner.
The Santa Paula California listings filed and calendar on this extensive website, FRBO.com omit log villa, decadent townhouse, and loft condominium.
Bedmates, salesmen, and roomers who are foraging vacation homes for rent by owner Santa Paula California and are trying to learn Santa Paula California apartments for rent and real estate rentals can go through our for rent by owner site, FRBO.com and our spacious advertisements, penthouse classified ads, and hidden indexes.
See suburban classified advertisements, lakefront classified ads, spacious ads, and secluded lists of marked properties that rental agents and third party agents post on FRBO.Com, For Rent By Owner,.
Discern, find, and conceive Isleton rental houses, apartments for rent in Isleton United States, and Isleton United States short term rentals.
Roommates and migrants who are wishing to dig up and catch or simply look up information can use our page.
Santa Paula property agents, real estate investors, home owners, and property owners list vacation rental Santa Paula and Santa Paula California vacation rental.
We shaped and conceived our website, FRBO.com to be admirable, delightful, bewitching, and statuesque.
Espy and debunk condo rentals in Imperial California and rent houses in Imperial.
|
|
