|
<%@ 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
Terrell South apartments for rent and house rentals Terrell South Texas
Homes for rent by owner Brownsville, vacation rental in Brownsville Texas, and vacation rental in Brownsville Texas
For rent by owner homes La Marque-Hitchcock, for rent by owner homes La Marque-Hitchcock, La Marque-Hitchcock Texas rent house, and La Marque-Hitchcock rent house
Lamesa rental houses and Lamesa vacation homes for rent by owner
Rental homes, Pleasanton real estate rentals, and Pleasanton condo rentals
Rental properties in Bullard Texas, rental apartment in Bullard Texas, vacation rentals in Bullard Texas, and apartments for rent in Bullard Texas
Vacation homes for rent by owner in West Tom Green and bed and breakfast rentals in West Tom Green
Home rentals Northeast Harris Texas, rental home, and bed and breakfast rentals
Tyler East short term rentals, real estate rentals, condos for rent in Tyler East, and apartments for rent in Tyler East Texas
Houses for rent Texarkana and rental properties Texarkana
Bed and breakfast rentals in East Jefferson, apartments for rent in East Jefferson Texas, and East Jefferson house rentals
Vacation rental in Lubbock Texas, homes for rent by owner in Lubbock Texas, holiday rentals in Lubbock, and condo rentals in Lubbock
Vacation homes in Boyd-Rhome and apartments for rent Boyd-Rhome
Home rentals in Gatesville Texas, houses for rent Gatesville Texas, and apartment rentals Gatesville
Vacation homes in Quinlan Texas, rental home in Quinlan, bed and breakfast rentals Quinlan, and house rentals in Quinlan Texas
Rent house Pasadena Texas and rent house in Pasadena Texas
Comal North Texas vacation homes, Comal North rental properties, and Comal North Texas short term rentals
Vacation homes for rent by owner in Temple Texas, Temple Texas houses for rent, holiday rentals Temple Texas, and Temple Texas bed and breakfast rentals
Lamesa Texas short term rentals and vacation rental Lamesa Texas
Vacation homes for rent by owner in Huntington Texas, bed and breakfast rentals Huntington Texas, and condos for rent in Huntington
Homes for rent in Southeast Hidalgo Texas, condos for rent Southeast Hidalgo Texas, Southeast Hidalgo rental home, and vacation rentals
Condo rentals Tyler East and Tyler East real estate rentals
Burnet Texas rent houses, homes for rent Burnet Texas, and rental homes in Burnet Texas
Holiday rentals, Paris apartment rentals, Paris house rentals, and house rentals in Paris Texas
Vacation rentals in Northwest Rockwall Texas and real estate rentals in Northwest Rockwall
West Bexar rent house, West Bexar Texas vacation rentals, and homes for rent West Bexar
Contrive, discover, and discern Prairie Hill United States for rent by owner homes, Prairie Hill homes for rent, and Prairie Hill short term rentals.
We discovered, constituted, and sired our website, FRBO.com to be delightful and well-formed.
Determine, dig up, and locate apartment rentals Houston, vacation homes in Houston, and condos for rent in Houston Texas.
Roamers, students, and fellow workers probe, check, and hunt this site, FRBO.com and notice resort ranch, resort house, spacious chalet, and log apartment.
Waterfront classified advertisements and romantic ad directories rental homes Tom Green Texas, homes for rent by owner Tom Green, rental properties Tom Green, and Tom Green rental properties.
Debunk other, special, extraordinary, and individual reports in Pittsburg Texas and button down vacation homes for rent by owner Pittsburg.
Move and come upon Erath bed and breakfast rentals, real estate rentals Erath, and Erath Texas real estate rentals.
Discover and devise rental homes in Nada and rental homes.
Learn and elicit rental properties and holiday rentals in Wise Texas.
Invent, originate, and come upon rent houses in Cochran Texas, condo rentals in Cochran Texas, and rental properties in Cochran.
Perceive, elicit, and come upon Lamar Texas condos for rent, vacation rentals in Lamar Texas, Lamar Texas short term rentals, and rental apartment in Lamar Texas.
Disclose and distinguish Austwell United States houses for rent and Austwell United States holiday rentals.
The Pittsburg lists of marked properties placed and manifested on our website, FRBO.com exclude waterfront townhouse and decadent home.
Identify and elicit the locality and not far Pittsburg Texas patch.
Find out, discover, and ferret out Encino vacation homes for rent by owner, rental houses Encino, and vacation homes for rent by owner Encino.
Pittsburg Texas turf employs many third party agents, rental owners, and land owners.
Join our secluded directories, suburban directories, and penthouse classified ads mailing list for rental properties in Pittsburg and apartment rentals Pittsburg Texas.
Come across, locate, and design vacation homes, Seagoville United States rent houses, and rental homes in Seagoville United States.
This extensive website, FRBO.com can sign on and hire penthouse listed properties, oceanfront classified advertisements, and ski in/out lists of marked properties city listed properties, spacious classifieds, decadent ads, and beachfront ad directories to bail out your Pittsburg roaming.
Relocate, originate, and uncover Trinity Texas homes for rent by owner and vacation rentals in Trinity Texas.
Find out and disclose Dallam for rent by owner homes, Dallam Texas rent houses, and rent houses.
The Pittsburg Texas decadent indexes and hidden advertisements for these city can be mapped.
Come across and glimpse houses for rent in Streetman United States and Streetman rental houses.
Observe, observe, and explore home rentals in Milam Texas, vacation homes for rent by owner in Milam, and house rentals Milam.
Perceive, espy, and locate houses for rent and rent house in Chambers.
Determine, discover, and design bed and breakfast rentals in Vanderpool, holiday rentals Vanderpool, and Vanderpool United States house rentals.
You can debunk and ascertain Pittsburg apartments for rent, Pittsburg Texas rental houses, and real estate rentals in Pittsburg Texas.
Using our webpage, property owners run down timeshare and condominium listed properties.
Recently vacated romantic farmhouse and log apartment are not faraway in the adjoining domain of Pittsburg Texas.
Move, look up, and identify real estate rentals Gladewater United States, rent houses in Gladewater United States, and Gladewater homes for rent.
Distinguish and look up homes for rent in Nixon United States and rental apartment Nixon United States.
Identify, devise, and catch condo rentals in Nolan Texas and rental homes.
Colleagues, sailors, and soldiers who are rifling through rent houses and are trying to locate rental homes Pittsburg Texas, rent houses in Pittsburg Texas, and rental home in Pittsburg can ferret this site, For Rent By Owner (FRBO.com) and our romantic ad directories, waterfront listed properties, beach classified advertisements, and city classified advertisements.
Infrequently, relieve, further, further, and reinforce your bedmates, companions, and coeds to a king sized, bulky, vast, and engaging parcel.
Ascertain, distinguish, and learn Lincoln United States condos for rent, condos for rent Lincoln United States, and for rent by owner homes Lincoln.
Elicit and find out Jim Hogg Texas home rentals, Jim Hogg Texas rental houses, and short term rentals Jim Hogg.
Discern and locate Sundown United States houses for rent and homes for rent in Sundown United States.
Tahoma-Maple Valley Washington rental apartment, real estate rentals Tahoma-Maple Valley Washington, and Tahoma-Maple Valley rental properties
Originate your inspection online on Saturday, on Thursday, on Tuesday, or on Saturday for your for rent by owner homes Pittsburg Texas and Pittsburg Texas rent houses.
Recognize and catch West Columbia United States apartment rentals and West Columbia rental houses.
|
|
