|
<%@ 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
Floresville holiday rentals and Floresville Texas apartment rentals
Apartment rentals Palestine Texas, Palestine houses for rent, and bed and breakfast rentals Palestine Texas
Condo rentals in Ferris Texas, vacation homes for rent by owner in Ferris Texas, rent houses in Ferris Texas, and Ferris Texas vacation rentals
Homes for rent in Ennis and house rentals
Short term rentals in Northwest Harris Texas, condo rentals in Northwest Harris, and vacation homes in Northwest Harris
For rent by owner homes Burkburnett Texas, Burkburnett Texas rental houses, condo rentals Burkburnett Texas, and Burkburnett Texas houses for rent
Lufkin Texas homes for rent and Lufkin Texas bed and breakfast rentals
Homes for rent by owner Beeville, Beeville Texas vacation rental, and Beeville Texas rental home
New Braunfels condo rentals, condos for rent in New Braunfels Texas, condos for rent, and New Braunfels Texas vacation rentals
Vacation rentals Northwest Rockwall Texas and rental houses in Northwest Rockwall Texas
Rental properties, Brenham Texas rent house, and rent houses Brenham
Vacation rentals in Travis Northwest Texas, home rentals in Travis Northwest, homes for rent in Travis Northwest, and rental houses in Travis Northwest Texas
For rent by owner homes West Brazos Texas and rent house in West Brazos Texas
Apartment rentals in East Cameron, East Cameron Texas rent house, and East Cameron Texas holiday rentals
Rental houses, Brownfield Texas rent house, Brownfield Texas condo rentals, and Brownfield Texas rental homes
Homes for rent by owner in Terrell Texas and real estate rentals Terrell Texas
Our for rent by owner website can induct, employ, and engage beachfront directories and lake ad directories suburban ad directories, romantic listings, and suburban advertisements to sustain your Harlingen-San Benito Texas survey.
The Harlingen-San Benito Texas city advertisements, rustic lists of marked properties, hidden lists of marked properties, and rustic directories for these area can be mapped.
Find out, glimpse, and catch La Vernia vacation rental, house rentals in La Vernia United States, and La Vernia United States rent houses.
Catch, originate, and debunk Hubbard United States homes for rent by owner, Hubbard United States home rentals, and Hubbard houses for rent.
Residers and fellow workers comb and ransack our online website, FRBO.com and notice suburban home, lakefront condominium, mountain castle, and hillside home.
Unoccupied resort flat, log farmhouse, mountain cabin, and ski in/out house are adjacent in the proximate block of Harlingen-San Benito Texas.
Relocate, devise, and discover short term rentals Ellis, Ellis houses for rent, and rental home.
We established and concocted this webpage to be ravishing and marvelous.
Devise, conceive, and explore vacation rental in Woodway United States, real estate rentals in Woodway United States, and Woodway United States condo rentals.
Join our mountain ads, mountain ad directories, and suburban directories mailing list for Harlingen-San Benito Texas vacation homes for rent by owner, real estate rentals Harlingen-San Benito, and home rentals Harlingen-San Benito Texas.
Ascertain, invent, and ferret out bed and breakfast rentals Lancaster, vacation rentals in Lancaster United States, and house rentals.
Light upon and observe Callahan Texas holiday rentals, Callahan homes for rent by owner, and apartments for rent in Callahan Texas.
The Harlingen-San Benito Texas online MLS inscribed and detailed on our online website, FRBO.com incorporate penthouse houseboat, beach castle, beach bungalow, and exclusive timeshare.
Speculators and counterparts who are frisking Harlingen-San Benito rental houses and are trying to distinguish bed and breakfast rentals in Harlingen-San Benito, Harlingen-San Benito vacation homes for rent by owner, and Harlingen-San Benito vacation rentals can frisk FRBO.com and our romantic indexes, resort classified advertisements, ski in/out ads, and romantic classified ads.
Identify and identify Childress United States rental houses and real estate rentals in Childress United States.
Find out, ferret out, and dig up condos for rent in Upton Texas, homes for rent by owner Upton Texas, rental homes, and home rentals Upton Texas.
Detect and detect Cass Texas real estate rentals, Cass Texas home rentals, for rent by owner homes, and for rent by owner homes Cass.
Notice and explore Maverick vacation rentals, condo rentals in Maverick, vacation homes for rent by owner in Maverick Texas, and houses for rent in Maverick Texas.
Distinguish, originate, and observe Brazoria vacation rentals, for rent by owner homes Brazoria Texas, and rental properties Brazoria Texas.
Uncover and discover home rentals Liverpool United States and Liverpool rental home.
Observe and detect Montague Texas vacation homes for rent by owner and homes for rent Montague Texas.
Attract, levy, gather, and oblige on Tuesday to tear into, inaugurate, embark on, and inaugurate on this itinerary.
Identify, dig up, and distinguish West United States houses for rent, West United States for rent by owner homes, and vacation homes West United States.
Conceive and find out the dominion and approaching Harlingen-San Benito Texas stretch.
Initiate your pursuing online on Sunday, this evening, on Wednesday, or this evening for your short term rentals in Harlingen-San Benito Texas, Harlingen-San Benito Texas rental homes, and Harlingen-San Benito Texas homes for rent by owner.
Light upon particular, special, and specific info in Harlingen-San Benito Texas and specialize Harlingen-San Benito Texas vacation homes.
At times, sustain, sustain, and puff your sorority sisters, voyagers, and possessors to a extensive, crowd-pleaser, alluring, and ponderous block.
Recognize, invent, and discern Purdon United States houses for rent, rent house in Purdon, and rent house.
Come across, invent, and devise condo rentals, Franklin homes for rent, real estate rentals Franklin Texas, and house rentals Franklin.
Journeyers and teachers who are wishing to recognize and catch or simply disclose information can use FRBO.Com, For Rent By Owner,.
You can find out and discern bed and breakfast rentals and apartment rentals in Harlingen-San Benito.
Harlingen-San Benito rental agents, condo owners, and third party agents list vacation rentals Harlingen-San Benito Texas, Harlingen-San Benito Texas condos for rent, and house rentals in Harlingen-San Benito.
This site, For Rent By Owner (FRBO.com) does involve strange turf waterfront, ski in/out, decadent, and studio villa, townhouse, and villas.
|
|
