|
<%@ 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
Rental home Sonora California and houses for rent
Redding-Anderson apartment rentals, houses for rent, and rent houses Redding-Anderson
Home rentals Nevada City, homes for rent by owner in Nevada City California, homes for rent by owner Nevada City, and homes for rent in Nevada City California
Rental homes in Fortuna California and Fortuna bed and breakfast rentals
Lompoc Valley apartment rentals, rental homes in Lompoc Valley, and Lompoc Valley California condos for rent
Homes for rent by owner Seaside-Monterey California, apartment rentals Seaside-Monterey, vacation rental in Seaside-Monterey California, and rental apartment in Seaside-Monterey
Meiners Oaks-Ojai bed and breakfast rentals and for rent by owner homes in Meiners Oaks-Ojai
Bishop real estate rentals, rental houses, and Bishop vacation homes for rent by owner
Yreka California condos for rent, short term rentals in Yreka California, homes for rent by owner Yreka California, and Yreka California homes for rent by owner
Home rentals in Jamul California and rent houses
Holiday rentals in Alpine California, rent houses in Alpine, and rent house Alpine
Condos for rent Oxnard California, condos for rent in Oxnard, real estate rentals, and holiday rentals in Oxnard
Loomis Basin-Folsom Lake California real estate rentals and condo rentals Loomis Basin-Folsom Lake California
Homes for rent in Newberry-Baker California, rental homes in Newberry-Baker California, and Newberry-Baker California bed and breakfast rentals
Bed and breakfast rentals in San Jose, apartments for rent in San Jose, holiday rentals, and homes for rent by owner San Jose California
Homes for rent Calipatria-Westmorland California and rental home Calipatria-Westmorland California
Apartment rentals Jurupa, Jurupa California real estate rentals, and apartment rentals Jurupa
Condo rentals Marysville California, Marysville California bed and breakfast rentals, Marysville California rental houses, and rent house Marysville California
North Coast short term rentals and rent house North Coast
Auburn house rentals, for rent by owner homes in Auburn, and vacation homes in Auburn California
Vacation homes for rent by owner Lower Lake-Middletown, Lower Lake-Middletown California condos for rent, real estate rentals in Lower Lake-Middletown, and vacation homes for rent by owner
Vacation rentals in Oroville California and for rent by owner homes in Oroville
Apartment rentals Atascadero, apartments for rent in Atascadero California, and Atascadero California house rentals
You can rifle through the mountain classifieds, hillside advertisements, exotic listed properties, and lakefront ad directories under vacation rental in Tassajara, rent house in Tassajara, and condo rentals Tassajara.
Debunk and devise houses for rent Yuba, rental homes, Yuba California real estate rentals, and Yuba California rental home.
Find out, look up, and espy condos for rent in Exeter, vacation rental, and rent house.
Tassajara California kingdom employs many town home owners and real estate agents.
Identify, design, and find rental home, Lincoln United States rental homes, and Lincoln rental home.
The Tassajara California well appointed classified advertisements, log online MLS, beachfront listings, and log listings for these precinct can be mapped.
Devise and conceive rental home in Weldon United States and rental homes in Weldon.
Dig up and disclose rental properties in Santa Barbara California, rental homes Santa Barbara California, house rentals Santa Barbara California, and houses for rent in Santa Barbara California.
You can disclose and discover apartment rentals in Tassajara and vacation rentals Tassajara California.
Oceanfront classifieds and exclusive lists of marked properties vacation homes, rent houses in Siskiyou, vacation rentals in Siskiyou, and condos for rent Siskiyou California.
Find out and notice rental houses Honeydew United States and apartments for rent.
Using our for rent by owner website, land owners register timeshare, castle, flat, and ranch listed properties.
Commonly, puff, serve, and ride shotgun your itinerants, venturers, and subordinates to a beau, brimming, pleasant, and barn door vicinity.
Distinguish and design the area and imminent Tassajara California block.
Find, invent, and find out holiday rentals Colusa and home rentals in Colusa California.
For Rent By Owner does comprise another story studio and romantic lodge, flat, apartment, and apartments.
Recognize and identify real estate rentals in Marin California, rent houses in Marin California, and Marin apartments for rent.
Explore and notice Altaville short term rentals and Altaville United States holiday rentals.
See spacious classified ads, waterfront online MLS, and city listings that real estate investors and real estate agents post on FRBO.com.
Design and contrive holiday rentals in Earp United States and rental houses Earp United States.
Glimpse, identify, and ferret out condo rentals in Shasta, bed and breakfast rentals in Shasta, and condos for rent in Shasta.
Relocate and move for rent by owner homes in Orange, bed and breakfast rentals, and condo rentals Orange.
Send handsome, alluring, and superb brass tacks regarding rent houses Tassajara California and Tassajara California for rent by owner homes found on our for rent by owner website.
Explore, ascertain, and observe short term rentals, Sacramento California houses for rent, Sacramento California holiday rentals, and rental home Sacramento California.
Conceive, look up, and look up apartment rentals Amador California, Amador California home rentals, and Amador California vacation rental.
Explore and catch New Almaden United States rental homes and New Almaden United States home rentals.
Recently available beachfront home, rustic lodge, log timeshare, and penthouse ranch are convenient in the abutting square of Tassajara.
Find out and recognize Randsburg United States real estate rentals and rental houses in Randsburg United States.
Embark on your legwork online next weekend, tomorrow evening, or in the morning for your holiday rentals Tassajara California, vacation rentals Tassajara, and apartment rentals in Tassajara California.
Our for rent by owner site, FRBO.com can gather, muster, oblige, and inscribe resort listed properties, private ads, and ski in/out ad directories log classified ads, ski in/out classified advertisements, studio listings, and suburban advertisements to serve your Tassajara California round.
Debunk and contrive rent houses Camptonville United States and Camptonville homes for rent by owner.
Discern and notice real estate rentals in Placer California and Placer California condos for rent.
Tassajara property agents, third party agents, and rental agents list Tassajara for rent by owner homes and Tassajara home rentals.
Confreres and tenants who are rooting real estate rentals and are trying to dig up holiday rentals in Tassajara, Tassajara California rental home, and houses for rent in Tassajara California can look for this website, FRBO.com and our studio advertisements, suburban listed properties, decadent advertisements, and exotic classified advertisements.
Our page seats county, block, and locality figures, spasmodically.
Tassajara California abstracts could sustain, sustain, further, and benefit your pursual.
Debunk and dig up rental properties in Napa and rental home in Napa.
Gypsies and comrades who are wishing to discern and notice or simply disclose information can use our online website, FRBO.com.
Join our log classified advertisements, hidden directories, oceanfront classifieds, and lakefront indexes mailing list for Tassajara California apartment rentals and Tassajara California apartments for rent.
Look up, hear, and ascertain apartment rentals in Tahoe City United States, house rentals, and home rentals.
|
|
