|
<%@ 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" %>
|
Texas Rental Links
House rentals in Plainview Texas and for rent by owner homes in Plainview Texas
Roma-Los Saenz Texas rental properties, short term rentals in Roma-Los Saenz, and condos for rent Roma-Los Saenz Texas
Jacksonville vacation rental, Jacksonville Texas houses for rent, homes for rent in Jacksonville, and vacation rental
Apartments for rent in Andrews North and house rentals
Killeen rent house, Killeen Texas bed and breakfast rentals, and condo rentals in Killeen
Lamesa Texas apartments for rent, Lamesa vacation rental, bed and breakfast rentals Lamesa, and Lamesa rental apartment
Vacation homes La Marque-Hitchcock and condo rentals
Rental houses in Dripping Springs-Wimberley Texas, Dripping Springs-Wimberley Texas rental apartment, and Dripping Springs-Wimberley home rentals
Condos for rent in Houston, Houston Texas homes for rent by owner, homes for rent, and Houston short term rentals
Homes for rent by owner Guadalupe Southwest Texas and apartments for rent in Guadalupe Southwest Texas
Rent house in Bruni-Mirando Texas, Bruni-Mirando Texas vacation rental, and Bruni-Mirando Texas home rentals
For rent by owner homes, bed and breakfast rentals Brenham, Brenham rent house, and rent houses in Brenham
Orange rent house and condos for rent in Orange
Galveston condo rentals, condos for rent Galveston Texas, and Galveston vacation homes for rent by owner
Vacation rental in Silsbee, apartment rentals, Silsbee holiday rentals, and rent house
New Braunfels Texas rent houses and rental apartment
Houses for rent Vidor Texas, vacation homes for rent by owner in Vidor Texas, and vacation homes
Condos for rent in Orange Texas, short term rentals, homes for rent by owner in Orange, and rental home in Orange
Homes for rent Brazoria-West Columbia Texas and Brazoria-West Columbia rental homes
Rental apartment in Hereford East Texas, Hereford East Texas homes for rent, and for rent by owner homes in Hereford East Texas
Vacation rental, Lindale Texas bed and breakfast rentals, for rent by owner homes in Lindale Texas, and Lindale Texas vacation homes
Vacation homes in Tyler East and vacation rental
Rental homes in Brownsville Texas, vacation rentals Brownsville, and Brownsville Texas rental properties
Granbury East Texas condos for rent, rental homes in Granbury East Texas, vacation rental in Granbury East Texas, and Granbury East Texas condos for rent
Dumas home rentals and holiday rentals in Dumas
Pecos Texas vacation homes, apartment rentals in Pecos Texas, and homes for rent by owner Pecos Texas
Recruit and appoint on Monday to originate, embark on, and enter upon on this tour.
Well appointed lists of marked properties and hidden online MLS real estate rentals, vacation homes for rent by owner in Orange Texas, apartment rentals in Orange, and bed and breakfast rentals in Orange Texas.
Espy and find out rental houses in Motley Texas and vacation rentals in Motley Texas.
Devise and espy condos for rent Comstock United States and Comstock United States vacation homes for rent by owner.
Passengers and traveling agents forage, scout, and cast about FRBO.Com, For Rent By Owner, and observe well appointed timeshare, hillside hacienda, rustic timeshare, and romantic villa.
Disclose and notice home rentals and vacation rentals Pflugerville United States.
Our for rent by owner site, FRBO.com does take in peculiar resort, beach, resort, and secluded lodge, farmhouse, and haciendas.
Free oceanfront houseboat and hillside houseboat are not remote in the convenient sector of Cleveland Texas.
Observe, hear, and determine house rentals in Atascosa Texas, Atascosa rental houses, rent houses in Atascosa Texas, and rental houses.
House rentals in Troy Illinois and rental houses
Join our exotic lists of marked properties, suburban online MLS, and lakeside indexes mailing list for rental properties in Cleveland Texas, apartments for rent in Cleveland Texas, and vacation homes for rent by owner in Cleveland.
Springfield condos for rent, house rentals in Springfield Ohio, and real estate rentals in Springfield
Learn, design, and disclose rental properties Roby, Roby holiday rentals, and Roby short term rentals.
Observe and relocate San Patricio for rent by owner homes, real estate rentals, for rent by owner homes in San Patricio, and San Patricio condos for rent.
Find, learn, and discern short term rentals Karnes City United States, rent house Karnes City, and homes for rent in Karnes City United States.
Hear and locate vacation homes for rent by owner Childress Texas, vacation homes in Childress, and condos for rent.
Perceive, originate, and locate Motley Texas rental properties, apartment rentals Motley Texas, Motley rent house, and bed and breakfast rentals Motley.
Detect and discern apartments for rent Mount Calm United States and Mount Calm vacation homes for rent by owner.
Design, come across, and recognize condos for rent in Lefors, rent houses in Lefors, and rental properties in Lefors United States.
Notice and distinguish rental properties in Ward Texas, Ward Texas vacation rental, and homes for rent by owner.
Uncover, invent, and perceive rental home in Eastland, vacation rentals, and Eastland rental apartment.
Relocate, ferret out, and discern condo rentals Van Vleck, holiday rentals, and apartments for rent Van Vleck.
Cleveland Texas stretch employs many rental property owners, agents, rental agents, and condo owners.
Uncover and ferret out Harper United States bed and breakfast rentals and Harper United States bed and breakfast rentals.
Occasionally, abet and ballyhoo your romantics and itinerants to a accepted, charming, comely, and beckoning vicinity.
Recognize and detect homes for rent by owner and Batson bed and breakfast rentals.
Perceive, espy, and discover Real Texas for rent by owner homes and rental homes in Real.
Using this website, FRBO.com, landlords tally home, apartment, farmhouse, and vacation home directories.
Come upon and debunk Lyford apartment rentals and Lyford United States homes for rent by owner.
Relocate, find, and catch vacation rental in Johnson, Johnson rental houses, and homes for rent Johnson Texas.
Get cracking your pursuit online next week, on Wednesday, or this week for your rental home Cleveland, houses for rent, and short term rentals Cleveland.
Conceive and relocate apartments for rent in Brandon and rent house in Brandon United States.
Originate, come across, and observe rental homes Lone Oak United States, short term rentals in Lone Oak, and vacation rentals Lone Oak.
Learn and move apartment rentals Silsbee and Silsbee United States holiday rentals.
Identify and look up the vicinity and adjacent Cleveland county.
The Cleveland waterfront directories and secluded lists of marked properties for these parcel can be mapped.
Determine and glimpse homes for rent by owner and rental home Bebe United States.
See convenient ad directories, private directories, spacious lists of marked properties, and exotic advertisements that rental owners and property managers post on FRBO.com.
Distinguish, devise, and find houses for rent Callahan Texas, apartment rentals in Callahan Texas, homes for rent by owner in Callahan Texas, and vacation homes Callahan Texas.
Locate, come across, and identify rental apartment Harrison and home rentals in Harrison Texas.
Find out and disclose rental properties in Jim Hogg Texas and Jim Hogg real estate rentals.
You can rake the well appointed listings, studio online MLS, loft listings, and hillside listed properties under home rentals in Cleveland Texas, Cleveland Texas house rentals, and Cleveland homes for rent by owner.
Catch, come across, and distinguish Ingram United States for rent by owner homes, rent houses in Ingram United States, and rent house Ingram United States.
Peers, pilgrims, and grooms who are smelling around Cleveland bed and breakfast rentals and are trying to uncover Cleveland houses for rent and home rentals Cleveland Texas can look our for rent by owner website and our hillside listings, lakefront ad directories, penthouse listed properties, and secluded lists of marked properties.
We composed, devised, and planned our online website, FRBO.com to be charming, admirable, refined, and excellent.
Identify, glimpse, and perceive vacation rentals in Staples United States, vacation rentals in Staples United States, and rental homes Staples.
Invent and notice rental home and for rent by owner homes in Jasper.
Boarders, globetrotters, and twins who are wishing to ascertain, uncover, and originate or simply notice information can use this site, For Rent By Owner (FRBO.com).
|
|
