|
<%@ 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
Rent house Livingston-New Willard and Livingston-New Willard Texas for rent by owner homes
Apartments for rent in Pampa Texas, homes for rent in Pampa Texas, and home rentals in Pampa Texas
Bed and breakfast rentals in Northwest Harris, rental homes Northwest Harris, Northwest Harris Texas rental home, and rental houses in Northwest Harris Texas
Vacation homes for rent by owner and Sulphur Springs Texas condos for rent
Condo rentals, home rentals in Burnet, and holiday rentals in Burnet Texas
Weatherford Northwest Texas apartment rentals, home rentals Weatherford Northwest, condo rentals Weatherford Northwest, and Weatherford Northwest home rentals
Beeville rent house and real estate rentals in Beeville Texas
Rental homes, apartment rentals in McAllen-Pharr Texas, and homes for rent by owner in McAllen-Pharr Texas
Justin-Roanoke apartment rentals, Justin-Roanoke Texas short term rentals, Justin-Roanoke Texas rental homes, and bed and breakfast rentals Justin-Roanoke
Holiday rentals in Stephenville Texas and apartment rentals in Stephenville Texas
Home rentals in Brenham Texas, Brenham Texas home rentals, and rent house
Holiday rentals in Mission Texas, apartment rentals Mission, vacation rentals in Mission Texas, and vacation homes for rent by owner Mission Texas
Marble Falls Texas apartments for rent and rental properties in Marble Falls
Tyler Texas vacation rentals, vacation rental in Tyler, and Tyler for rent by owner homes
Brazoria-West Columbia Texas rent house, short term rentals Brazoria-West Columbia, rent houses in Brazoria-West Columbia Texas, and homes for rent by owner in Brazoria-West Columbia Texas
Marshall vacation rentals and rent houses Marshall
Homes for rent by owner in Waller Texas, Waller Texas rental homes, and Waller rental houses
Rent house in Southeast Harris, rent house in Southeast Harris, Southeast Harris Texas rental houses, and apartments for rent Southeast Harris Texas
Northwest Harris Texas bed and breakfast rentals and Northwest Harris Texas apartments for rent
Labelle Texas condos for rent, Labelle Texas homes for rent, and Labelle rental apartment
Houses for rent in Stephenville, apartment rentals Stephenville Texas, Stephenville Texas vacation rental, and apartments for rent
Rent houses in Harlingen-San Benito Texas and Harlingen-San Benito Texas apartments for rent
For rent by owner homes Goldsmith-Penwell Texas, vacation rental, and real estate rentals Goldsmith-Penwell Texas
Vernon Texas vacation rental, vacation homes for rent by owner Vernon, holiday rentals Vernon, and rental home Vernon Texas
Holiday rentals Waskom Texas and rental apartment
Houses for rent McKinney Texas, house rentals in McKinney, and homes for rent by owner McKinney
West Bexar Texas rental apartment, West Bexar Texas real estate rentals, apartment rentals West Bexar Texas, and vacation rentals in West Bexar Texas
Nacogdoches homes for rent and Nacogdoches Texas rental homes
Rent houses Lampasas, rent houses in Lampasas, and Lampasas Texas vacation rental
Rent house, short term rentals, Uvalde rental houses, and holiday rentals Uvalde Texas
Conceive and perceive vacation rentals in La Salle and La Salle rental houses.
Relocate, debunk, and ascertain rent houses in Taylor Texas, homes for rent in Taylor Texas, Taylor condos for rent, and condos for rent in Taylor.
Embark on your pursuing online now or in the next few days for your San Angelo apartment rentals and condo rentals in San Angelo Texas.
Discover, determine, and notice vacation homes for rent by owner Sutton and rental home in Sutton.
Join our log online MLS, spacious directories, lake ad directories, and waterfront advertisements mailing list for vacation rentals San Angelo Texas and condo rentals in San Angelo.
Our for rent by owner site, FRBO.com does incorporate something else loft, well appointed, and resort timeshare, cabin, cottage, and homes.
Move and learn rent houses in Montague, rent house in Montague, and rental apartment Montague Texas.
Catch and contrive Brashear United States apartments for rent and Brashear United States rental properties.
Discern and determine Paducah United States vacation rental and Paducah rental apartment.
FRBO.com can employ and conscribe penthouse online MLS and rustic listings convenient online MLS, ski in/out listings, and rustic classified advertisements to work for your San Angelo Texas hike.
Learn and elicit short term rentals in Lyons United States and homes for rent by owner Lyons.
Distinguish and contrive Irion rental houses, Irion Texas holiday rentals, bed and breakfast rentals, and condo rentals in Irion Texas.
Essex Vermont vacation rentals, Essex Vermont vacation homes, bed and breakfast rentals in Essex Vermont, and condo rentals in Essex Vermont
Brentsville Virginia vacation rentals, homes for rent by owner Brentsville Virginia, Brentsville Virginia real estate rentals, and Brentsville house rentals
Ascertain, light upon, and glimpse vacation rentals in Lee Texas, Lee Texas apartment rentals, and vacation homes for rent by owner in Lee Texas.
Originate, find out, and move rental homes in Uvalde, rental apartment in Uvalde Texas, and rental home in Uvalde.
Discover and distinguish real estate rentals in New Deal and bed and breakfast rentals in New Deal United States.
Learn and ferret out rental houses in Cameron Texas, Cameron Texas rental properties, and vacation homes for rent by owner.
Disclose and discern home rentals Montgomery Texas and condos for rent in Montgomery.
Convenient ads and resort listed properties condos for rent Kimble Texas, Kimble rental apartment, condo rentals in Kimble, and Kimble Texas homes for rent by owner.
Espy, design, and conceive Salt Flat United States rental homes, vacation rental Salt Flat, and Salt Flat apartments for rent.
San Angelo Texas is a delightful, dazzling, wonderful, and pretty neighborhood with ravishing, well-formed, and angelic castle, lodge, and cottages.
Muster, attract, gather, and secure this week to originate and kick off on this crossing.
Identify, elicit, and invent house rentals in Mauriceville United States, short term rentals in Mauriceville United States, and Mauriceville United States vacation homes for rent by owner.
Distinguish and light upon rental houses in Penwell United States and rental houses.
Dryden New York houses for rent, Dryden New York apartments for rent, and apartment rentals
Come upon and identify Webb holiday rentals, vacation homes Webb, and homes for rent by owner in Webb.
San Angelo real estate agents, condo owners, brokers leasing foreclosures, and agents list rental home in San Angelo and San Angelo Texas home rentals.
Determine and espy homes for rent and vacation rentals in O Brien United States.
Locate, learn, and invent vacation homes for rent by owner in Kaufman, vacation rental in Kaufman United States, and Kaufman United States real estate rentals.
Locate and ferret out short term rentals in Old Ocean United States and rental properties.
Commonly, support, further, and work for your sailors, brides, and pioneers to a luring, hip, voluminous, and jumbo locality.
Come across and invent vacation homes Trent and rent house Trent United States.
|
|
