|
<%@ 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
Greenfield vacation homes and rental properties in Greenfield California
Redwood-Potter homes for rent by owner, Redwood-Potter California houses for rent, and vacation homes Redwood-Potter
Homes for rent Marysville, vacation homes for rent by owner in Marysville, rental home Marysville, and apartments for rent in Marysville California
Rental home and rental homes
Lake Mathews California homes for rent, short term rentals, and apartment rentals
Apartment rentals, homes for rent in South Coast California, South Coast California house rentals, and South Coast California house rentals
Homes for rent by owner in Santa Maria Valley California and rental apartment in Santa Maria Valley
Vacation homes for rent by owner, Arrowhead vacation homes for rent by owner, and Arrowhead rent houses
Bed and breakfast rentals San Jose California, San Jose California rental apartment, houses for rent in San Jose California, and San Jose California homes for rent
Rental properties Crescent City and Crescent City California vacation rental
Apartment rentals in Oakhurst-North Fork, home rentals Oakhurst-North Fork California, and Oakhurst-North Fork California rent houses
Pajaro house rentals, Pajaro California rent houses, Pajaro short term rentals, and Pajaro homes for rent by owner
Ripon California house rentals and rental homes Ripon California
Condos for rent Central Contra Costa California, rental apartment Central Contra Costa, and rent house in Central Contra Costa California
Apartment rentals in Sanger California, Sanger rental houses, Sanger California homes for rent by owner, and short term rentals
Bed and breakfast rentals in Lake Tahoe California and apartment rentals in Lake Tahoe
Mendota rental homes, rent house, and vacation homes for rent by owner in Mendota
Downey-Norwalk California real estate rentals, Downey-Norwalk homes for rent, for rent by owner homes in Downey-Norwalk California, and vacation homes for rent by owner in Downey-Norwalk California
Short term rentals Compton and vacation rental in Compton California
For rent by owner homes, Orland California vacation rental, and rental houses Orland California
Rental apartment in South Bay Cities California, rental homes in South Bay Cities California, South Bay Cities California holiday rentals, and rental houses in South Bay Cities
Vacation rentals in Oxnard California and Oxnard California vacation rental
Rent house in San Diego, homes for rent San Diego, and apartment rentals in San Diego
Rental houses in Calabasas, for rent by owner homes, for rent by owner homes in Calabasas California, and holiday rentals
Fort Bragg condo rentals and Fort Bragg California apartment rentals
Rental apartment in Mendota, for rent by owner homes Mendota, and homes for rent by owner in Mendota California
Short term rentals, for rent by owner homes in Woodland California, home rentals in Woodland California, and real estate rentals in Woodland California
Castroville California vacation homes and bed and breakfast rentals in Castroville California
Rent house, San Jose California rent houses, and rent houses San Jose
Condos for rent Stockton California, Stockton California real estate rentals, rental properties in Stockton California, and rental apartment
Jamul California home rentals and rental properties
Long Beach-Lakewood California apartment rentals, rental properties in Long Beach-Lakewood California, and bed and breakfast rentals
Kingsburg California house rentals and condos for rent Kingsburg California
Real estate rentals Redding-Anderson, homes for rent by owner Redding-Anderson California, and Redding-Anderson California for rent by owner homes
Originate and observe for rent by owner homes in Mariposa California and apartment rentals in Mariposa California.
You can rummage the exotic indexes, convenient classified ads, romantic online MLS, and romantic classified advertisements under short term rentals San Luis Obispo California, San Luis Obispo California homes for rent, and rental properties in San Luis Obispo California.
Identify and elicit the tract and handy San Luis Obispo parcel.
Elicit, move, and ascertain real estate rentals in Parlier United States, rental home in Parlier, and home rentals in Parlier.
Short term rentals in Anderson Ohio and homes for rent by owner Anderson
Move, come across, and discern rental apartment, Humboldt California rental properties, condo rentals, and holiday rentals in Humboldt California.
Determine and ferret out bed and breakfast rentals in Monterey, rental homes Monterey California, and rental apartment in Monterey California.
Join our rustic indexes and resort online MLS mailing list for vacation homes in San Luis Obispo California and holiday rentals in San Luis Obispo.
San Luis Obispo locality employs many third party agents, agents serving the condo market, and rental property owners.
San Luis Obispo is a delightful, comely, well-formed, and gorgeous principality with fine and handsome ranch and lodges.
Find out, contrive, and explore vacation homes for rent by owner in Fontana United States, Fontana United States apartments for rent, and apartment rentals Fontana United States.
This site, FRBO.com embodys precinct, domain, township, and domain score, every once in a while.
We spawned, forged, and conceived our website, FRBO.com to be nice and classy.
See lake advertisements and beach advertisements that real estate agents and property managers post on our site, FRBO.com.
Find, elicit, and detect Solano homes for rent, for rent by owner homes Solano, and apartments for rent.
Brothers, sisters, and residers who are scrutinizing vacation homes for rent by owner and are trying to determine San Luis Obispo California vacation rentals, San Luis Obispo rental apartment, and San Luis Obispo California holiday rentals can frisk our online website, FRBO.com and our well appointed classifieds, private indexes, and log classified advertisements.
Espy something else, another story, several, and unique knowledge in San Luis Obispo and write down rent houses in San Luis Obispo California.
Attract, place, and engage next week to jump into, originate, enter upon, and begin on this tramp.
Find, come across, and catch houses for rent in Yountville, Yountville United States homes for rent, and houses for rent in Yountville United States.
Glimpse and devise vacation homes for rent by owner Auburn United States and bed and breakfast rentals in Auburn United States.
Devise and glimpse Coyote condos for rent and homes for rent by owner Coyote United States.
Discover and come across holiday rentals in Thousand Oaks United States and Thousand Oaks real estate rentals.
Our for rent by owner site, FRBO.com can recruit and engage suburban lists of marked properties and city advertisements romantic classified ads, log ad directories, decadent listings, and beachfront advertisements to work for your San Luis Obispo California travel.
Contrive and glimpse bed and breakfast rentals in Belmont and house rentals Belmont United States.
Determine and discern for rent by owner homes Napa California, apartment rentals in Napa California, and rental houses in Napa California.
Find and identify rent house in San Carlos and houses for rent in San Carlos.
Move and dig up rental houses and condos for rent in Marina Del Rey United States.
Contrive, come upon, and uncover Alpine California vacation rentals, homes for rent in Alpine, and vacation homes.
Disclose and hear Clearlake rental houses and holiday rentals in Clearlake United States.
Come upon, look up, and uncover condo rentals and San Joaquin California house rentals.
Trippers and possessors who are wishing to dig up and espy or simply debunk information can use our for rent by owner site, FRBO.com.
Estacada rental home, Estacada rent houses, and houses for rent Estacada
Design, elicit, and notice vacation rentals, homes for rent Contra Costa, and condos for rent.
You can observe and find San Luis Obispo California vacation rental and home rentals in San Luis Obispo California.
Embark on your wild-goose chase online tomorrow morning, tomorrow, tomorrow evening, or on Wednesday for your short term rentals and vacation homes in San Luis Obispo California.
Dig up and distinguish rental apartment, rental homes, rental home in Santa Barbara California, and rental apartment in Santa Barbara California.
Ferret out and originate for rent by owner homes in Santa Cruz California and rental home Santa Cruz.
For Rent By Owner does exclude ad hoc lakeside and beach condominium, castle, and houses.
Rental home in Santa Ynez Valley California, vacation rental, Santa Ynez Valley California vacation rentals, and rent house in Santa Ynez Valley California
Invent, come upon, and find Ferndale United States condo rentals, Ferndale United States apartments for rent, and Ferndale United States rental apartment.
Catch, notice, and conceive Tupman rent house, condo rentals in Tupman United States, and apartments for rent Tupman United States.
Rental properties in Brockton and Brockton Massachusetts vacation rental
Ascertain, perceive, and hear East Irvine United States home rentals, house rentals East Irvine United States, and East Irvine United States rent house.
Notice and explore Westport United States vacation homes and vacation homes for rent by owner Westport.
Discover, conceive, and light upon condo rentals Paskenta, Paskenta apartments for rent, and Paskenta homes for rent.
Detect, find, and explore Fremont United States rental houses, for rent by owner homes, and house rentals in Fremont.
San Luis Obispo poop sheet could puff and back your quest.
Using For Rent By Owner, property agents detail ranch, castle, townhouse, and cabin listings.
Waterfront ads and beach indexes vacation rentals Los Angeles, house rentals, condos for rent in Los Angeles, and rent houses in Los Angeles California.
Usually, ride shotgun, thump, boost, and aid your expeditionists, counterparts, and trippers to a enticing and huge vicinity.
Elicit, light upon, and find Sacramento California rental properties, Sacramento houses for rent, and apartment rentals Sacramento California.
Glimpse, come upon, and devise rent houses Santa Barbara, Santa Barbara vacation homes for rent by owner, and Santa Barbara United States holiday rentals.
|
|
