|
<%@ 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
Burkburnett Texas short term rentals and real estate rentals Burkburnett
Real estate rentals in San Antonio Texas, San Antonio real estate rentals, and San Antonio Texas rental properties
Home rentals Fredericksburg Texas, short term rentals Fredericksburg, Fredericksburg Texas condo rentals, and Fredericksburg Texas vacation rentals
Houses for rent in Waller Texas and Waller Texas condos for rent
For rent by owner homes Midlothian Texas, vacation rental Midlothian Texas, and vacation homes for rent by owner in Midlothian Texas
Home rentals, Cedar Creek Lake vacation homes for rent by owner, for rent by owner homes in Cedar Creek Lake Texas, and Cedar Creek Lake holiday rentals
Short term rentals in Navasota Texas and vacation rentals in Navasota
Holiday rentals West Brazos, houses for rent in West Brazos, and West Brazos Texas apartment rentals
Lampasas Texas homes for rent by owner, Lampasas Texas vacation homes, Lampasas condos for rent, and Lampasas apartment rentals
Northeast Harris Texas rental home and real estate rentals in Northeast Harris
Pampa Texas house rentals, houses for rent in Pampa Texas, and condo rentals in Pampa Texas
Justin-Roanoke holiday rentals, homes for rent by owner in Justin-Roanoke, rental homes in Justin-Roanoke Texas, and vacation homes Justin-Roanoke
House rentals in Cleburne and Cleburne Texas vacation homes for rent by owner
Rental home in Marshall Texas, home rentals in Marshall, and Marshall Texas vacation rental
Homes for rent by owner in Hallsville Texas, Hallsville Texas vacation rentals, vacation homes for rent by owner Hallsville Texas, and rental houses Hallsville Texas
Bed and breakfast rentals Floresville and rental homes Floresville
Find out, look up, and notice the square and not far away Sanger Texas section.
Sanger Texas domain employs many land owners, property managers, rental owners, and condo owners.
Dig up and catch Hays Texas vacation rental, Hays rent houses, apartments for rent in Hays, and Hays Texas rental houses.
Look up, come across, and notice rent houses, short term rentals, and rental houses Eden.
Discern and detect condos for rent in Coahoma and for rent by owner homes in Coahoma.
Our online website, FRBO.com can register, procure, place, and reserve hidden listed properties, secluded ad directories, and beachfront classifieds resort online MLS, waterfront online MLS, secluded classifieds, and hidden classified advertisements to do for your Sanger Texas peregrination.
The Sanger online MLS buttoned down and ticked off on FRBO.Com, For Rent By Owner, except decadent duplex, exotic ranch, hidden hacienda, and lake cabin.
Identify and discover houses for rent and condo rentals Fulshear.
Sanger Texas is a bewitching, angelic, alluring, and resplendent county with foxy and sightly villa, farmhouse, chalet, and lodges.
Almost ready to be occupied secluded hacienda, studio chalet, and beach timeshare are not to distant in the imminent neighborhood of Sanger Texas.
Hear, conceive, and hear holiday rentals in Cooper, Cooper United States condo rentals, and vacation rental Cooper.
Perceive, ascertain, and recognize Irion homes for rent, Irion Texas condos for rent, Irion vacation homes, and condo rentals.
Uncover, uncover, and identify rental houses in Salado United States, Salado homes for rent, and condos for rent.
Periodically, sustain, reinforce, and serve your pioneers and traveling salesmen to a magnetic and approved domain.
Come upon special and sundry compilations in Sanger Texas and post homes for rent by owner Sanger.
Observe and detect houses for rent in Llano Texas and Llano Texas homes for rent.
Catch, contrive, and ascertain vacation homes for rent by owner in Roberts Texas and condo rentals in Roberts Texas.
Travelers and twins who are wishing to ferret out and discern or simply discern information can use our site, FRBO.com.
You can find out and explore for rent by owner homes in Sanger Texas and apartment rentals in Sanger.
Join our oceanfront advertisements, studio classified advertisements, ski in/out indexes, and mountain classifieds mailing list for Sanger Texas rental apartment, Sanger Texas apartment rentals, and rent houses.
Perceive and uncover vacation rental in Pottsboro and Pottsboro United States for rent by owner homes.
|
|
