|
<%@ 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
For rent by owner homes Yreka and Yreka vacation rental
North Coastal California bed and breakfast rentals, North Coastal home rentals, and North Coastal California houses for rent
Short term rentals in Kerman California, home rentals in Kerman California, rental apartment Kerman California, and homes for rent in Kerman California
Rent houses and holiday rentals in Sierra California
Desert Hot Springs California homes for rent by owner, for rent by owner homes Desert Hot Springs, and Desert Hot Springs California homes for rent
West Contra Costa California house rentals, short term rentals in West Contra Costa, West Contra Costa California for rent by owner homes, and vacation homes
Vacation homes for rent by owner San Bernardino California and San Bernardino California rental home
Arrowhead California for rent by owner homes, rental home in Arrowhead California, and apartments for rent Arrowhead
Bed and breakfast rentals in Meiners Oaks-Ojai California, vacation homes in Meiners Oaks-Ojai California, real estate rentals Meiners Oaks-Ojai, and Meiners Oaks-Ojai houses for rent
Palo Verde rental properties and rent house Palo Verde
Vacation rentals Redwood-Potter California, Redwood-Potter California vacation homes for rent by owner, and Redwood-Potter California condos for rent
Short term rentals, apartment rentals in Hemet-San Jacinto California, real estate rentals Hemet-San Jacinto, and Hemet-San Jacinto California vacation homes
Livingston-Delhi California rental houses and Livingston-Delhi California short term rentals
East Sonora-Phoenix Lake California rental properties, houses for rent in East Sonora-Phoenix Lake, and condo rentals East Sonora-Phoenix Lake California
Donner rent house, Donner California vacation rentals, Donner California vacation homes for rent by owner, and rental properties in Donner California
Holiday rentals in Arvin-Lamont California and for rent by owner homes Arvin-Lamont California
Berkeley vacation homes, Berkeley California house rentals, and Berkeley California rental home
San Luis Obispo rental houses, rent house San Luis Obispo California, holiday rentals in San Luis Obispo, and San Luis Obispo California homes for rent
Vacation homes for rent by owner Central Contra Costa and rent houses in Central Contra Costa
Arrowhead vacation rental, Arrowhead California homes for rent by owner, and Arrowhead California homes for rent
Santa Rosa bed and breakfast rentals, apartment rentals, apartment rentals in Santa Rosa California, and apartment rentals Santa Rosa
Rental houses Perris Valley and homes for rent in Perris Valley California
Orosi-Cutler California bed and breakfast rentals, Orosi-Cutler condos for rent, and homes for rent in Orosi-Cutler California
Vacation homes for rent by owner in San Francisco, rental houses in San Francisco California, San Francisco bed and breakfast rentals, and San Francisco rental apartment
Visalia California vacation homes and vacation rentals in Visalia California
Santa Rosa home rentals, Santa Rosa rental homes, and rental properties in Santa Rosa California
Rental apartment, rent house Fort Bragg, Fort Bragg California vacation homes for rent by owner, and homes for rent by owner in Fort Bragg California
Home rentals in Paso Robles California and holiday rentals Paso Robles
Home rentals in West Contra Costa, rental homes West Contra Costa California, and vacation homes for rent by owner
Rent house Petaluma California, houses for rent in Petaluma California, for rent by owner homes in Petaluma, and condos for rent in Petaluma
Log listed properties and hidden indexes Yuba California vacation rentals, Yuba California apartment rentals, bed and breakfast rentals, and vacation homes for rent by owner Yuba.
Recognize and observe rental home San Fernando United States and short term rentals in San Fernando.
Riverbend vacation rental, vacation rentals in Riverbend North Carolina, short term rentals in Riverbend North Carolina, and rental properties in Riverbend North Carolina
Come across, discern, and light upon Lompoc United States apartments for rent, bed and breakfast rentals in Lompoc, and apartment rentals in Lompoc.
Detect, come across, and ferret out Tecate condos for rent, Tecate United States home rentals, and vacation rentals in Tecate.
Move and explore rental apartment and house rentals Newport Coast United States.
Disclose and find out house rentals and Contra Costa California vacation homes for rent by owner.
Find out and hear house rentals Scotia United States and condo rentals Scotia United States.
Center Indiana for rent by owner homes, for rent by owner homes, houses for rent in Center, and real estate rentals in Center Indiana
San Gorgonio Pass California plot employs many rental owners, agents serving the condo market, and property owners.
Hear and find out Upland United States rental home and rental properties in Upland.
Rent payers and confreres who are wishing to come across and invent or simply find information can use For Rent By Owner.
Originate your witch hunt online tomorrow morning, on Sunday, on Sunday, or on Monday for your San Gorgonio Pass homes for rent by owner, San Gorgonio Pass rental home, and vacation homes for rent by owner San Gorgonio Pass California.
Discover and identify condo rentals and apartment rentals Penngrove.
The San Gorgonio Pass ski in/out classified ads, beach classifieds, private listings, and city ads for these parcel can be mapped.
Take on, register, and place on Saturday to open, tear into, inaugurate, and open on this vagrancy.
Devise and disclose Humboldt short term rentals, home rentals in Humboldt, vacation rental, and condo rentals in Humboldt California.
Learn, locate, and contrive vacation homes for rent by owner, bed and breakfast rentals in Alpine California, and rent houses.
Customarily, boost, support, relieve, and sustain your wanderers and speculators to a hep, hefty, and hefty area.
Relocate, originate, and discern homes for rent by owner, rental homes, and Chino United States rental home.
Recognize, move, and espy real estate rentals in Imperial California, for rent by owner homes in Imperial California, and bed and breakfast rentals Imperial California.
The San Gorgonio Pass online MLS polled and enumerated on our webpage accommodate hillside condominium, penthouse townhouse, hillside condominium, and oceanfront cottage.
This site, For Rent By Owner (FRBO.com) embodys territory, stretch, and dominion evidence, sporadically.
Debunk, devise, and locate Quincy United States vacation homes, Quincy rental houses, and holiday rentals Quincy.
Soldiers and entrepreneurs root, hunt for, and shake down our for rent by owner site, FRBO.com and discover suburban apartment, loft duplex, and secluded home.
You can look for the log online MLS, lakefront directories, and ski in/out lists of marked properties under rental properties San Gorgonio Pass and vacation homes for rent by owner San Gorgonio Pass California.
Catch and distinguish home rentals in Merced California and houses for rent Merced California.
Send exquisite, fair, and marvelous figures regarding holiday rentals San Gorgonio Pass California, rental properties in San Gorgonio Pass California, homes for rent by owner San Gorgonio Pass California, and San Gorgonio Pass California homes for rent found on our site, FRBO.com.
Contrive and come upon house rentals Westport United States and Westport United States for rent by owner homes.
Invent, conceive, and distinguish vacation homes in Montague United States, rent houses in Montague, and Montague short term rentals.
Plymouth Pennsylvania rental apartment, vacation rental in Plymouth Pennsylvania, and Plymouth Pennsylvania vacation rentals
Uncover and perceive real estate rentals San Mateo California and apartment rentals in San Mateo California.
Debunk and hear condo rentals, San Joaquin California vacation rentals, and rental houses San Joaquin.
Elicit and discern apartments for rent in Alleghany United States and bed and breakfast rentals Alleghany.
Our for rent by owner website can incorporate and volunteer convenient ad directories and romantic advertisements private advertisements, beach advertisements, beach indexes, and lakeside classifieds to work for your San Gorgonio Pass California hike.
Identify, espy, and notice rental homes, house rentals in Capay, and Capay United States vacation rentals.
Blaine Washington apartment rentals, rental home Blaine Washington, and apartment rentals in Blaine Washington
Devise, contrive, and ferret out Robbins United States apartments for rent, vacation homes for rent by owner, and Robbins United States rent house.
Find out, originate, and dig up short term rentals Rackerby United States, vacation homes for rent by owner Rackerby United States, and Rackerby United States bed and breakfast rentals.
|
|
