Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-03T13:25:07.550' ,`MLSNumber` = '75486605' ,`ListAgentFullName` = 'David Johnston' ,`ListOfficeName` = 'BHGRE Gary GreeneLeague City' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.327678' ,`Longitude` = '-94.945098' ,`PhotoCount` = '48' ,`PostalCode` = '77563' ,`RoomCount` = '11' ,`ListPrice` = '399000.00' ,`Status` = 'Active' ,`StreetName` = 'Bayou Vista' ,`StreetNumber` = '106' ,`StreetSuffix` = 'Drive' ,`City` = 'Hitchcock' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3373' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Your 5 Bedroom custom waterfront property is waiting for you! Located in Bayou Vista, a waterfront community near Galveston has easy access – just 40 minutes from downtown Houston. This 3,240 square foot home has plenty of room for large gatherings or permanent residency. 5 bedrooms, 3.5 baths and large kitchen that opens to spacious living and dining areas. Large Game Room and master bedroom are located on top floor with expansive water views. There is a boat house and boat house deck for entertaining. Covered area below the house can park 4 cars with room to spare for an outdoor living area. The plat of land includes an area across the street where additional covered parking or boat storage could exist. House structure, including foundation, exterior walls, decks, windows and roof are in place. Interior framing in place can be modified to your needs. Contract with seller’s (or your preferred) builder to custom finish this amazing property.\r\nSchedule your tour today!' ,`Acres` = '0.1298' ,`Area` = '33' ,`BuilderName` = 'Custom' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Bayou Vista' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 7 S C BUNDICK SUR LOT 106 BAYOU VISTA ADDN 3' ,`LotDesciption` = 'Subdivision Lot,Waterfront' ,`LotSize` = '5653' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '25' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '52 - Texas City' ,`SchoolElementary` = 'HIGHLANDS ELEMENTARY SCHOOL (LA MARQUE)' ,`SchoolHigh` = 'LA MARQUE HIGH SCHOOL (TEXAS CITY)' ,`SchoolMiddle` = 'LA MARQUE MIDDLE SCHOOL (TEXAS CITY)' ,`ShowInstructions` = 'Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Bayou Vista Sec 3' ,`TaxAmount` = '3997' ,`TaxRate` = '2.2525' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675101090' WHERE `Matrix_Unique_ID` = '208206968' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-03T13:23:09.350' ,`MLSNumber` = '9418835' ,`ListAgentFullName` = 'Beth Naef' ,`ListOfficeName` = 'CI Estates Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.802478' ,`Longitude` = '-95.849652' ,`PhotoCount` = '9' ,`PostalCode` = '77493' ,`RoomCount` = '11' ,`ListPrice` = '2190000.00' ,`Status` = 'Active' ,`StreetName` = 'Palmetto Springs' ,`StreetNumber` = '7347' ,`StreetSuffix` = 'Trail' ,`City` = 'Katy' ,`BathsFull` = '5' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '6115' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come join me for a personal tour in The Estates at Cane Island. This exquisite 5 bedroom, 5.5 bath, 6115 sq ft home is situated on a 25,240 N/S facing sq ft lot. Cason Graye Homes, an award winning builder, has designed a transitional style home with a 1st floor Master Suite/Bath with a large walk-in closet, a large open great room, as well as a game room & bright airy gourmet kitchen that boasts a Caesarstone island w waterfall sides. In addition to the 4 bedrooms upstairs, find an exercise room w black regrind rubber floors & a bonus room/bar w golf simulator capabilities. Other amenities include a study, Chenin Blanc engineered wood floors thru out, a Butler\'s Pantry w a beverage center, mud room and pool bath w a shower. Relax in the rear yard veranda w a fireplace & summer kitchen. Another amenity unique to The Estates is a secure air conditioned Street Pantry for home deliveries. Buyer to verify all.' ,`Acres` = '0.57' ,`Area` = '25' ,`BuilderName` = 'Cason Graye Homes' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'lot 4, block 1' ,`LotDesciption` = 'Cleared,Cul-De-Sac,Subdivision Lot' ,`LotSize` = '25240' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'BRYANT ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'KATY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'The Estates at Cane Island' ,`TaxAmount` = '' ,`TaxRate` = '3.49' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675101091' WHERE `Matrix_Unique_ID` = '208275219' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-03T13:15:34.873' ,`MLSNumber` = '66634566' ,`ListAgentFullName` = 'Hakim Machlab' ,`ListOfficeName` = 'Texas Signature Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.654686' ,`Longitude` = '-95.311523' ,`PhotoCount` = '6' ,`PostalCode` = '77061' ,`RoomCount` = '5' ,`ListPrice` = '190000.00' ,`Status` = 'Active' ,`StreetName` = 'Alpine' ,`StreetNumber` = '6810' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1985' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great for Investors, Homes needs FULL renovation. Seller will not make any repairs. 3 Bedroom, 2 Bath Home on a Beautiful lot with mature trees. Room dimensions are approximate, Buyer to verify room dimensions and square footage of home. Seller has survey.' ,`Acres` = '0.5638' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hobby Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 4 BLK 12 GARDEN VILLAS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '24560' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'GARDEN VILLAS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'HARTMAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Garden Villas' ,`TaxAmount` = '3962' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1945' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675101091' WHERE `Matrix_Unique_ID` = '210175963' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-03T14:49:52.770' ,`MLSNumber` = '95937404' ,`ListAgentFullName` = 'Cherry Ruffino' ,`ListOfficeName` = 'Coldwell Banker Apex, REALTORS LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.691334' ,`Longitude` = '-96.294427' ,`PhotoCount` = '50' ,`PostalCode` = '77808' ,`RoomCount` = '10' ,`ListPrice` = '2500000.00' ,`Status` = 'Active' ,`StreetName` = 'Fm 1179' ,`StreetNumber` = '6000' ,`StreetSuffix` = '' ,`City` = 'Bryan' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3609' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BEAUTIFUL home on nearly 16 acres of timeless country charm with city convenience.4-beds, 3-baths with 3,600+ sq ft.Enjoy the most AMAZING sunsets in the pool, with a full bath, a full kitchen, a pizza oven, & outdoor fireplace. The main house features a large living area, huge windows, vaulted ceilings, an open kitchen, an eating bar, dining area, & a wet bar with a walk-in wine cooler. Primary bedroom is located on the main floor & offers double vanities, a steam shower & separate tub, an exercise nook, & separate walk-in closets. Bedroom #2 is also on the main floor & currently being used for cookware & serving dishes. Upstairs is an office with a built-in desk & shelves, 2 bedrooms, full bath, & additional 1,000 sq ft of storage that has been plumbed & can be finished out. Attached to the porte-cochere is a 2-car garage & a 1 bed, 1 bath casita.There is also a detached 4-bay garage with overhead roll-up doors & a tank for fishing in! Currently under Ag exemption for hay production.' ,`Acres` = '15.956' ,`Area` = '61' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TIMBERCREEK AT STEEP HOLLOW, BLOCK 1, LOT 2R (PT OF), ACRES' ,`LotDesciption` = 'Cleared' ,`LotSize` = '695043' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '6' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '148 - Bryan' ,`SchoolElementary` = 'SAM HOUSTON ELEMENTARY SCHOOL (BRYAN)' ,`SchoolHigh` = 'BRYAN HIGH SCHOOL' ,`SchoolMiddle` = 'STEPHEN F. AUSTIN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Victorian' ,`Subdivision` = 'Timbercreek At Steep Hollow' ,`TaxAmount` = '11033' ,`TaxRate` = '1.7488' ,`WaterSewer` = 'Aerobic,Water District' ,`YearBuilt` = '1996' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675101091' WHERE `Matrix_Unique_ID` = '211516208' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-03T14:26:48.993' ,`MLSNumber` = '33746001' ,`ListAgentFullName` = 'Bradley Tiffan' ,`ListOfficeName` = 'Legend Home Corporation' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.350203' ,`Longitude` = '-95.503178' ,`PhotoCount` = '33' ,`PostalCode` = '77304' ,`RoomCount` = '7' ,`ListPrice` = '331124.00' ,`Status` = 'Active' ,`StreetName` = 'Lawrence Park' ,`StreetNumber` = '2934' ,`StreetSuffix` = 'Court' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2628' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Ready Now! Love where you live in Madison Bend in Conroe, TX! Conveniently located 1.5 miles off I-45 and N FM 3083 W – homeowners enjoy a low property tax rate and close proximity to Lake Conroe and The Woodlands! The Poole floor plan is a spacious two-story home with 4 bedrooms, 3.5 baths, and 2-car garage. This home has it all - including a game room and vinyl plank flooring throughout the first floor! The gourmet kitchen is sure to please with tons of COUNTER SPACE, center island, 42\" cabinets, granite countertops, tile backsplash, and an appliance package! Enjoy the privacy and convenience of having the Owner\'s Suite on the first floor! Retreat to the Owner\'s Suite featuring a beautiful bay window, separate tub and shower, and spacious walk-in closet. Don\'t miss your opportunity to call Madison Bend home, schedule a visit today!' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'LEGEND HOMES' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 63, BLOCK 1, Section 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4608' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'GIESINGER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Madison Bend' ,`TaxAmount` = '' ,`TaxRate` = '2.89' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675101091' WHERE `Matrix_Unique_ID` = '211691756' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-03T14:52:51.307' ,`MLSNumber` = '94834995' ,`ListAgentFullName` = 'Cyndi Kornegay' ,`ListOfficeName` = 'Gatehouse Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.813964' ,`Longitude` = '-95.844864' ,`PhotoCount` = '37' ,`PostalCode` = '77493' ,`RoomCount` = '11' ,`ListPrice` = '649488.00' ,`Status` = 'Active' ,`StreetName` = 'Lantana' ,`StreetNumber` = '3050' ,`StreetSuffix` = 'Trail' ,`City` = 'Katy' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3128' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful two-story home is popular for good reason! The 8-foot front door opens to a curved staircase leading you to the family room that boasts soaring ceilings and quality details that will surely impress you and your guests. Head to the gourmet kitchen that features an island with high-end granite, 42-inch cabinets and built-in stainless-steel appliances. The conveniently placed butler\'s pantry links the elegant dining room with the breakfast nook. This home features 2 bedrooms downstairs and 2 bedrooms upstairs, each with their own bath for extra privacy. Enjoy an afternoon of entertainment on your oversized covered patio, or take it upstairs to the large game room complete with a media room that will be great for movie nights with the family. At the end of the day, relax and unwind in the private primary suite and spa-like bath. Other luxury features include the mud area, oversized utility room, ample storage space and a beautifully landscaped yard with sprinkler system.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Coventry Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'lot 31 block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '12062' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'ROBERTSON ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'KATY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Cane Island' ,`TaxAmount` = '' ,`TaxRate` = '3.4' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675101091' WHERE `Matrix_Unique_ID` = '211934474' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-03T13:59:13.273' ,`MLSNumber` = '55434222' ,`ListAgentFullName` = 'Meghan Cornelius' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.746746' ,`Longitude` = '-95.433609' ,`PhotoCount` = '49' ,`PostalCode` = '77027' ,`RoomCount` = '10' ,`ListPrice` = '3650000.00' ,`Status` = 'Active' ,`StreetName` = 'Meadow Lake' ,`StreetNumber` = '3609' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '5' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '5842' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning recent construction home in desirable River Oaks. High end transitional home featuring high ceilings, white oak hardwood floors and an open and spacious downstairs living area. Family room open to kitchen and breakfast area featuring an oversized island, Miele appliances, butler’s pantry and climate-controlled wine room. Dramatic entry staircase leads you up to the 2nd floor oversized primary bedroom, with a walk-in closet, sitting area and a spa like bathroom. All secondary guest rooms have en suite baths and walk-in closets. The third floor is the perfect flex room with a wet bar that could be used as a secondary office, zoom room or movie den. Many upgraded finishes throughout the home. The oversized garage has quarters above perfect for an in-law suite. Central location and walkable to St. Johns.' ,`Acres` = '0.2273' ,`Area` = '16' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'River Oaks Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 11 BLK 68 RIVER OAKS SEC 8' ,`LotDesciption` = 'Cleared' ,`LotSize` = '9900' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1918' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'RIVER OAKS ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LANIER MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Other Style' ,`Subdivision` = 'River Oaks Sec 08' ,`TaxAmount` = '80067' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675101092' WHERE `Matrix_Unique_ID` = '211991814' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-03T14:33:10.717' ,`MLSNumber` = '46830609' ,`ListAgentFullName` = 'Bradley Tiffan' ,`ListOfficeName` = 'Legend Home Corporation' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.349985' ,`Longitude` = '-95.502178' ,`PhotoCount` = '27' ,`PostalCode` = '77304' ,`RoomCount` = '7' ,`ListPrice` = '279990.00' ,`Status` = 'Active' ,`StreetName` = 'Madison' ,`StreetNumber` = '2870' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1707' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Love where you live in Madison Bend in Conroe, TX! Conveniently located 1.5 miles off I-45 and N FM 3083 W – homeowners enjoy a low property tax rate and close proximity to Lake Conroe and The Woodlands! The Darrel floor plan is a spacious 2-story home with 4 bedrooms, 2.5 baths, and 2-car garage. This home has it all, including an expansive game room! The first floor offers the perfect space for entertaining with a bar top kitchen open to the family room! The gourmet kitchen is sure to please with 42 inch cabinets, granite countertops, and stainless steel appliances! Retreat to the first floor Owner’s Suite featuring a beautiful bay window, oversized shower, and spacious walk-in closet! Enjoy the great outdoors with a sprinkler system and extended covered patio! Don’t miss your opportunity to call Madison Bend home, schedule a visit today!' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'LEGEND HOMES' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 54 Blk. 1 Madison Bend Sec. 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4500' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'GIESINGER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Madison Bend' ,`TaxAmount` = '' ,`TaxRate` = '2.89' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675101092' WHERE `Matrix_Unique_ID` = '212249352' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-03T14:49:31.053' ,`MLSNumber` = '20667449' ,`ListAgentFullName` = 'Bradley Tiffan' ,`ListOfficeName` = 'Legend Home Corporation' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.349886' ,`Longitude` = '-95.501829' ,`PhotoCount` = '31' ,`PostalCode` = '77304' ,`RoomCount` = '6' ,`ListPrice` = '292875.00' ,`Status` = 'Active' ,`StreetName` = 'Madison' ,`StreetNumber` = '2862' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1936' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Love where you live in Madison Bend in Conroe, TX! Conveniently located 1.5 miles off I-45 and N FM 3083 W – homeowners enjoy a low property tax rate and close proximity to Lake Conroe and The Woodlands! The Devonhurst floor plan is a spacious 2-story home with 4 bedrooms, 2.5 baths, and 2-car garage. This home has it all with vinyl plank flooring throughout the first floor common areas! The first floor offers the perfect space for entertaining with a peninsula kitchen open to both the living and dining areas! The gourmet kitchen is sure to please with 42\" cabinetry, granite countertops, and tile backsplash. Upstairs offers a private retreat for all bedrooms! Retreat to the Owner\'s Suite featuring a separate tub and shower and a sizable walk-in closet. Enjoy the great outdoors with a covered patio! Don’t miss your opportunity to call Madison Bend home, schedule a visit today!' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'LEGEND HOMES' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 52 BLK 1 MADISON BEND SEC.2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4400' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'GIESINGER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Madison Bend' ,`TaxAmount` = '' ,`TaxRate` = '2.89' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675101092' WHERE `Matrix_Unique_ID` = '212252376' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-03T14:46:02.567' ,`MLSNumber` = '73744851' ,`ListAgentFullName` = 'Bradley Tiffan' ,`ListOfficeName` = 'Legend Home Corporation' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.349517' ,`Longitude` = '-95.500195' ,`PhotoCount` = '32' ,`PostalCode` = '77304' ,`RoomCount` = '7' ,`ListPrice` = '293619.00' ,`Status` = 'Active' ,`StreetName` = 'Madison' ,`StreetNumber` = '2812' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2100' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Ready Now! Love where you live in Madison Bend in Conroe, TX! Conveniently located 1.5 miles off I-45 and N FM 3083 W – homeowners enjoy a low property tax rate and close proximity to Lake Conroe and The Woodlands! The Shannon Plan is a spacious 2-story home with 3 bedrooms, 2.5 bathrooms, FLEX AREA, and a 2-car garage. This home has it all, including vinyl plank flooring throughout the common areas and NO BACK NEIGHBORS! The gourmet kitchen is sure to please with 42\" cabinets, granite countertops, and stainless steel appliances! Upstairs features a private retreat for all the bedrooms! Retreat to the Owner\'s Suite featuring a separate tub and shower and a sizable walk-in closet! Enjoy the great outdoors on the covered patio! Don’t miss your opportunity to call Madison Bend home, schedule a visit today!' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'LEGEND HOMES' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 3 BLK 4 MADISON BEND SEC. 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'GIESINGER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Madison Bend' ,`TaxAmount` = '' ,`TaxRate` = '2.88' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675101092' WHERE `Matrix_Unique_ID` = '212270737' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-03T14:57:30.210' ,`MLSNumber` = '37092658' ,`ListAgentFullName` = 'Bradley Tiffan' ,`ListOfficeName` = 'Legend Home Corporation' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.350151' ,`Longitude` = '-95.502772' ,`PhotoCount` = '30' ,`PostalCode` = '77304' ,`RoomCount` = '6' ,`ListPrice` = '289990.00' ,`Status` = 'Active' ,`StreetName` = 'Lawrence Park' ,`StreetNumber` = '2922' ,`StreetSuffix` = 'Court' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1936' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Ready Now!! Love where you live in Madison Bend in Conroe, TX! Conveniently located 1.5 miles off I-45 and N FM 3083 W – homeowners enjoy a low property tax rate and close proximity to Lake Conroe and The Woodlands! The Devonhurst floor plan is a spacious 2-story home with 4 bedrooms, 2.5 baths, and 2-car garage. This home has it all with vinyl plank flooring throughout the first-floor common areas! The first floor offers the perfect space for entertaining with a peninsula kitchen open to both the living and dining areas! The gourmet kitchen is sure to please with 42\" cabinetry, granite countertops, and tile backsplash. Upstairs offers a private retreat for all bedrooms! Retreat to the Owner\'s Suite featuring a garden tub and shower and a sizable walk-in closet. Enjoy the great outdoors with a covered patio! Don’t miss your opportunity to call Madison Bend home, schedule a visit today!' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'LEGEND HOMES' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 60 BLK 1 MADISON BEND SEC.2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4400' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'GIESINGER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Madison Bend' ,`TaxAmount` = '' ,`TaxRate` = '2.89' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675101093' WHERE `Matrix_Unique_ID` = '213334791' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-03T14:28:18.550' ,`MLSNumber` = '50716798' ,`ListAgentFullName` = 'Cynthia Ramos' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.722821' ,`Longitude` = '-94.994005' ,`PhotoCount` = '36' ,`PostalCode` = '77520' ,`RoomCount` = '4' ,`ListPrice` = '235000.00' ,`Status` = 'Active' ,`StreetName` = 'Durrain Ferry' ,`StreetNumber` = '1916' ,`StreetSuffix` = 'Road' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '2' ,`SqFtTotal` = '1794' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A rare opportunity presents itself with this home. It is full of charm and character. Well-maintained with a cozy feel, this home sits on an acre of land. Feel closer to nature in the large yard with huge trees and garden space! The covered front porch across the front of the house perfect for relaxing. Outdoor features include an outdoor kitchen, a covered patio, a spacious seating area, two storage sheds, and a covered car port. There is also a patio tucked behind the home, perfect for morning coffee. Inside is equipped with a separated breakfast and formal dining area. In total, it has 2 bedrooms, 2.5 baths, and a laundry room. Primary bedroom and bathroom are downstairs. As an added bonus, all of the appliances (microwave excluded) will stay with the house! At this property you are minutes away from a community park with a splash pad, basketball court, and walking trail! \r\nThis Show Stopper is priced to sell! Schedule a viewing today!' ,`Acres` = '1.0081' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'TR 6A ABST 66 W SCOTT' ,`LotDesciption` = 'Cleared' ,`LotSize` = '43913' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'SAN JACINTO ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'LEE HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'BAYTOWN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Scott Wm Upper League' ,`TaxAmount` = '3234' ,`TaxRate` = '2.97' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1929' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675101093' WHERE `Matrix_Unique_ID` = '213371538' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-03T14:52:06.987' ,`MLSNumber` = '3327906' ,`ListAgentFullName` = 'Emil Ramirez' ,`ListOfficeName` = 'RE/MAX Signature Galleria' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.450065' ,`Longitude` = '-95.549265' ,`PhotoCount` = '19' ,`PostalCode` = '77318' ,`RoomCount` = '2' ,`ListPrice` = '65000.00' ,`Status` = 'Active' ,`StreetName` = 'Enchanted' ,`StreetNumber` = '13369' ,`StreetSuffix` = 'Court' ,`City` = 'Willis' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '500' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great property in the quiet Enchanted Waters neighborhood. The mobile home includes two bedrooms with washer and dryer connections. It also includes a new mini-split central AC (2019). Fresh paint throughout. Good investment opportunity as this home was previously leased for $700 per month. This home sits high and dry and no previous flooding.' ,`Acres` = '0.1102' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ENCHANTED WATERS 03, BLOCK 1, LOT 2, ACRES 0.110' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'C.C. HARDY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'LYNN LUCAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Enchanted Waters 03' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675101093' WHERE `Matrix_Unique_ID` = '213551673' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-03T13:39:37.520' ,`MLSNumber` = '32076235' ,`ListAgentFullName` = 'Natasha Tessier' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.065457' ,`Longitude` = '-95.655140' ,`PhotoCount` = '50' ,`PostalCode` = '77377' ,`RoomCount` = '7' ,`ListPrice` = '2950000.00' ,`Status` = 'Active' ,`StreetName` = 'Little Sorrell' ,`StreetNumber` = '2' ,`StreetSuffix` = 'Court' ,`City` = 'Tomball' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '7' ,`SqFtTotal` = '8500' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Magnificent custom home with luxurious amenities nestled in sought after Willowcreek Ranch on 1.5 acres! Loaded w/architectural details including soaring ceilings, numerous chandeliers & high-end designer finishes throughout! Entertainers dream w/regal dining room, wet bar w/wine fridge & ice machine. Huge kitchen featuring massive center island, two sinks, two dishwashers, professional appliances including Thermador and Viking and a large butlers pantry w/ an additional sink & beverage fridge. Grand primary features impressive private spa bath including his/her dream closets, and luxurious oversized shower! Large game room, private office, three secondary bedrooms and stunning secondary bathrooms make up the first floor. Upstairs is complete with an additional three bedrooms, flex space & another stunning spa bathroom. Huge lush lot w/multiple incredible outdoor spaces including a side court yard, lanai & pool that is just waiting for your personal touch for completion! Tomball ISD!' ,`Acres` = '1.5115' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 8 BLK 1 WILLOWCREEK RANCH SEC 8' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '65841' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '3250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'GRAND OAKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'GRAND LAKES JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Mediterranean,Traditional' ,`Subdivision` = 'Willowcreek Ranch Sec 8' ,`TaxAmount` = '51619' ,`TaxRate` = '2.7372' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675101093' WHERE `Matrix_Unique_ID` = '213871630' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-03T14:04:36.310' ,`MLSNumber` = '58709984' ,`ListAgentFullName` = 'Elizabeth Rhoden Harrell' ,`ListOfficeName` = 'Rhoden Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.746490' ,`Longitude` = '-95.091249' ,`PhotoCount` = '24' ,`PostalCode` = '77351' ,`RoomCount` = '3' ,`ListPrice` = '324900.00' ,`Status` = 'Active' ,`StreetName` = 'Indian Hill' ,`StreetNumber` = '919' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Livingston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1296' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'If quiet and peaceful lake life if what you\'re searching for, then this is the place for you! Located in the Indian Hills Subdivision on Lake Livingston, this home has water views from the covered porch! Imagine sipping cocktails while watching the lake & hearing your wind chimes in the breeze. This property has been completely remodeled...pex plumbing, electrical wiring (incl panel), newer septic, recent roof, leaf guard gutters, lawn sprinkler, flooring (incl insulated sub-floor), cabinets, granite countertops, there\'s even an outside elevator! The main part of the house is upstairs & the guest suite is downstairs in garage area. The 3 car garage & covered RV parking make storing your toys easy & convenient. RV area is on a slab w/ 50 amp service and water hookup. The storage shed in back allows for extra storage if needed. Community boat ramp is near-by. This property is rare...better in person than online. Call today for your showing & get ready for fun at the lake!' ,`Acres` = '0.2217' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'INDIAN HILL ESTATES SECTION 1 BLK 4 LOT 15' ,`LotDesciption` = 'Cleared' ,`LotSize` = '9656' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '103 - Livingston' ,`SchoolElementary` = 'LISD OPEN ENROLL' ,`SchoolHigh` = 'LIVINGSTON HIGH SCHOOL' ,`SchoolMiddle` = 'LIVINGSTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Indian Hill Estates Sec 1' ,`TaxAmount` = '2510' ,`TaxRate` = '1.8745' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1976' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675101094' WHERE `Matrix_Unique_ID` = '214028417' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-03T14:40:05.320' ,`MLSNumber` = '64166103' ,`ListAgentFullName` = 'Bradley Tiffan' ,`ListOfficeName` = 'Legend Home Corporation' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.349577' ,`Longitude` = '-95.500459' ,`PhotoCount` = '20' ,`PostalCode` = '77304' ,`RoomCount` = '4' ,`ListPrice` = '263308.00' ,`Status` = 'Active' ,`StreetName` = 'Madison' ,`StreetNumber` = '2820' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1365' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Love where you live in Madison Bend in Conroe, TX! Conveniently located 1.5 miles off I-45 and N FM 3083 W – homeowners enjoy a low property tax rate and close proximity to Lake Conroe and The Woodlands! The Cole floor plan is a charming 1-story home with 3 bedrooms, 2 bathrooms, and a 2-car garage. The gourmet kitchen is sure to please with 42\" cabinets and granite countertops! Retreat to the Owner\'s Suite with a beautiful bay window, tray ceiling for some dramatic flair, and a separate tub and shower! Enjoy the great outdoors with a covered patio! Don’t miss your opportunity to call Madison Bend home, schedule a visit today!' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'LEGEND HOMES' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 5 BLK 4 MADISON BEND SEC. 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4500' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'GIESINGER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Madison Bend' ,`TaxAmount` = '' ,`TaxRate` = '2.88' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675101094' WHERE `Matrix_Unique_ID` = '214290260' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-03T14:48:33.257' ,`MLSNumber` = '17449476' ,`ListAgentFullName` = 'Laura Sweeney' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.759379' ,`Longitude` = '-95.408871' ,`PhotoCount` = '48' ,`PostalCode` = '77019' ,`RoomCount` = '12' ,`ListPrice` = '2395000.00' ,`Status` = 'Active' ,`StreetName` = 'Kirby' ,`StreetNumber` = '897' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '5' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '5436' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Remarkably refined River Oaks 4-Bedroom residence offering a distinctive Lucian Hood design showcasing stylish interiors well-suited for artistic display enhanced by impeccable scale, substantial ceiling heights, and serene views of the sublime setting. Elevator-installed to Primary Suite with separate baths and walk-in closets. 3 Secondary Bedrooms + Game Room and Study/Library up. Sizable Rooftop Terrace awaiting customization. Home Generator. Ample off-street parking with dual-access gated motor court and three-car attached Garage. A private and timeless treasure with enviable access to the attractions at Buffalo Bayou Park and Downtown Houston.' ,`Acres` = '0.2091' ,`Area` = '16' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'River Oaks Area' ,`HeatSystem` = 'Central Electric,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 26 RIVER OAKS SEC 3 R/P' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '9110' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2386' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'RIVER OAKS ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LANIER MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'River Oaks' ,`TaxAmount` = '37430' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675101094' WHERE `Matrix_Unique_ID` = '214366595' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-03T14:38:12.380' ,`MLSNumber` = '84198521' ,`ListAgentFullName` = 'Christopher Gross' ,`ListOfficeName` = 'Landlords of Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.551366' ,`Longitude` = '-95.350828' ,`PhotoCount` = '42' ,`PostalCode` = '77584' ,`RoomCount` = '4' ,`ListPrice` = '485000.00' ,`Status` = 'Active' ,`StreetName` = 'Nahas' ,`StreetNumber` = '8409' ,`StreetSuffix` = 'Court' ,`City` = 'Pearland' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3212' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home has an occupying tenant until 2024! Investor dream! Well maintained home, 4 bedrooms, 3.5 baths, 3 car garage. Island kitchen, spacious game room upstairs. Master Bedroom on first floor. Over sized backyard. Hardwood and new vinyl flooring includes: entry, kitchen and master bath. Tile (re-grout) for bathrooms on second floor. New carpet on second floor all recently completed. Subdivision with the lake, excellent school district, easy access to med centers, groceries, shopping, restaurants, Pearland Town Center, and more.' ,`Acres` = '0.2919' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'VILLAGES OF EDGEWATER ESTATES SEC 5 (A0309 HT&B) (PEARLAND)' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '12715' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '625' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '42 - Pearland' ,`SchoolElementary` = 'SILVERLAKE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GLENDA DAWSON HIGH SCHOOL' ,`SchoolMiddle` = 'BERRY MILLER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Villages Of Edgewater Estates' ,`TaxAmount` = '10495' ,`TaxRate` = '2.8451' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675101094' WHERE `Matrix_Unique_ID` = '214783281' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-03T14:13:41.780' ,`MLSNumber` = '76175607' ,`ListAgentFullName` = 'Kim Brown' ,`ListOfficeName` = 'Full Stringer Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.965380' ,`Longitude` = '-95.967170' ,`PhotoCount` = '37' ,`PostalCode` = '77414' ,`RoomCount` = '3' ,`ListPrice` = '195000.00' ,`Status` = 'Active' ,`StreetName` = 'Sandlewood Drive' ,`StreetNumber` = '1901' ,`StreetSuffix` = 'Drive' ,`City` = 'Bay City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1860' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Wonderful home located in Baywood S/d on a large corner lot location. 3 Large bedrooms & 2 updated baths. Updates include flooring in downstairs living & kitchen area & downstairs Guestroom with fully updated bathroom area. Upstairs has 2 large bedrooms & huge closets. Master bathroom has been completely remodeled & is beautiful with 2 large master closets for his & hers. Open floor plan layout downstairs with french doors leading to a huge backyard with Shop-shed. Large backyard patio for entertaining with a separate side yard for garden area or additional storage. Sellers Motivated' ,`Acres` = '0.248' ,`Area` = '54' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'BAYWOOD S/D, BLOCK 2, LOT 28, SEC 1' ,`LotDesciption` = 'Corner' ,`LotSize` = '10803' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '132 - Bay City' ,`SchoolElementary` = 'TENIE HOLMES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BAY CITY HIGH SCHOOL' ,`SchoolMiddle` = 'BAY CITY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Baywood Sub' ,`TaxAmount` = '4973' ,`TaxRate` = '2.8238' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1968' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675101095' WHERE `Matrix_Unique_ID` = '214790969' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-03T14:39:04.297' ,`MLSNumber` = '71223720' ,`ListAgentFullName` = 'Quang Nguyen' ,`ListOfficeName` = 'Aimpro Realty & Management LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.939409' ,`Longitude` = '-95.566990' ,`PhotoCount` = '18' ,`PostalCode` = '77064' ,`RoomCount` = '8' ,`ListPrice` = '230000.00' ,`Status` = 'Active' ,`StreetName` = 'Ridge Run' ,`StreetNumber` = '11510' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1848' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'One story home with 3 bedroom, 1 study room and 2 bath. This home has a long driveway can park 4 cars.\r\nEasy access to 1960, 249, Beltway 8.' ,`Acres` = '0.1653' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate,No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Willowbrook South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 17 BLK 5 TURTLE HILL VILLAGE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'FRANCONE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'CAMPBELL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Turtle Hill Village' ,`TaxAmount` = '4633' ,`TaxRate` = '2.8087' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675101095' WHERE `Matrix_Unique_ID` = '214807932' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215035207','1675101095','215035207','2023-01-03T13:15:11.677','52214046','Melissa Walters','The MW Realty Group','','','29.812489','-95.386441','49','77009','5','599900.00','Active','28th','1011','Street','Houston','3','1','3','2555','Single-Family','Welcome to 1011 E 28th St. This Stunning New Construction Single-Family Home in The Heights Enclave Gated Community is Sure to Please! Seller offers three (3) Newly constructed units:1005, 1011 and 1013 offering a Black, Gold and Chrome Fixtures contemporary package, Designs Of The Finest High-End Finishes. High ceilings, custom wrought iron stair case, hardwood floors, Upscale Lighting, Custom Wood Kitchen Cabinets, Quartz Counter Tops, High End Stainless Steel Appliances are Standard Features. Three (3) walk-in closets, a Large Open Kitchen With an Island with Breakfast Bar, Soaring Ceilings with double french doors that open on second floor Balcony, Perfect for Those Early Morning Solaces. All 3 Spacious Bedrooms Have their Own Private Baths. Close Proximity to Hwys, Parks, Downtown, Dining and Markets including the Farmers Market and Whole Foods.','0.039','9','MELIFERA PARTNERS','','','','Owner/Agent,Sellers Disclosure','1','','','Heights/Greater Heights','Central Electric,Central Gas','1','LT 18 BLK 1 HEIGHTS ENCLAVE','Subdivision Lot','1688','Appraisal District','','1740','1','Never Lived In','2','','0','','','','','Slate','27 - Houston','FIELD ELEMENTARY SCHOOL','HEIGHTS HIGH SCHOOL','HAMILTON MIDDLE SCHOOL (HOUSTON)','Appointment Required','Appraisal District','3','Traditional','Heights Enclave','6065','2.3307','Public Sewer,Public Water','2022','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-03T14:44:02.527' ,`MLSNumber` = '32502190' ,`ListAgentFullName` = 'Sandy Laine' ,`ListOfficeName` = 'RE/MAX Universal Northwest' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.012610' ,`Longitude` = '-95.554949' ,`PhotoCount` = '34' ,`PostalCode` = '77379' ,`RoomCount` = '10' ,`ListPrice` = '265000.00' ,`Status` = 'Active' ,`StreetName` = 'Colony Creek' ,`StreetNumber` = '17315' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1843' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Clean & Tidy, Treed & Landscaped, Glass door entry, Tile on lower level, Wood like flooring in both Formals, Family Rm w/Cozy Fireplace, Kitchen boost Granite counters, Black & SS Appliances, Convection Oven, Refrigerator., Breakfast Bar, Kitchen is Open to Morning Rm, & Family Rm, Glass doors in Morning Rm open to Patio, the Social Power Rm is located on the lower level, Three Spacious bed Rms on the upper level, the Master Suite features a walk in closet, the Ensuite boots Granet counters 2/sinks & a shower, located off of one of the bed rms & through the walk in closet is a heated & cooled Rm for children to play or a storage area, the Hall Bath has Granet Counters w/knee space , Storage in rear yard or work shop with Electricity, Lighting & Outlets, Utility Rm is large w/Washer & Dryer, 2\" blinds throughout Sprinkler System Front & Rear, Two Car Garage attached w/remote control, window screens replaced, Wood fenced back yard. Snooze and you\'ll Lose' ,`Acres` = '0.1494' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Owner/Agent,Real Estate Owned,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 48 BLK 11 COLONY CREEK VILLAGE SEC 4' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '6510' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '354' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'KRAHN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN CAIN HIGH SCHOOL' ,`SchoolMiddle` = 'KLEB INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Colony Creek Village' ,`TaxAmount` = '5393' ,`TaxRate` = '2.3266' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '1987' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675101095' WHERE `Matrix_Unique_ID` = '215045275' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215119639','1675101095','215119639','2023-01-03T14:54:57.787','80210957','Jared Turner','Turner Mangum,LLC','','','30.205678','-95.734738','4','77354','7','249325.00','Active','Bellewood Manor','110','Drive','Magnolia','2','0','4','1459','Single-Family','Ridgeland plan is a great looking one story that has great site lines from the kitchen opening up into the dining and family room area. It has a spacious look and yet functions quite well as a full four bedroom plan at only 1524 sf. White 42” upper cabinets in kitchen with handles and quartz counter-tops supplements the modern look. Black appliances with gas cooking. Tall 9 ft ceilings in living areas. Oversized shower in master adds to the “Today’s Lifestyle” appeal.','','15','Rausch Coleman Homes','','Electric Dryer Connections,Washer Connections','','No Disclosures','1','','','Magnolia/1488 West','Central Gas','1','3-1-14','Subdivision Lot','5400','Other','','300','1','To Be Built/Under Construction','2','Electric Oven,Single Oven','0','','','Gas Range','','Composition','36 - Magnolia','WILLIE E. WILLIAMS ELEMENTARY SCHOOL','MAGNOLIA WEST HIGH SCHOOL','MAGNOLIA JUNIOR HIGH SCHOOL','Appointment Required','Builder','1','Traditional','Magnolia Ridge','','3.3','Water District','2023','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215125208','1675101095','215125208','2023-01-03T14:55:40.217','56383493','Jared Turner','Turner Mangum,LLC','','','30.205678','-95.734738','4','77354','7','249985.00','Active','Bellewood Manor','122','Drive','Magnolia','2','0','4','1459','Single-Family','Ridgeland plan is a great looking one story that has great site lines from the kitchen opening up into the dining and family room area. It has a spacious look and yet functions quite well as a full four bedroom plan at only 1524 sf. White 42” upper cabinets in kitchen with handles and granite counter-tops supplements the modern look. Black appliances with gas cooking. Tall 9 ft ceilings in living areas and primary bedroom. Oversized shower in master adds to the “Today’s Lifestyle” appeal. Energy savings package included.','','15','Rausch Coleman Homes','','Electric Dryer Connections,Washer Connections','','No Disclosures','1','','','Magnolia/1488 West','Central Gas','1','6-1-14','Subdivision Lot','5400','Other','','300','1','To Be Built/Under Construction','2','Electric Oven,Single Oven','0','','','Gas Range','','Composition','36 - Magnolia','WILLIE E. WILLIAMS ELEMENTARY SCHOOL','MAGNOLIA WEST HIGH SCHOOL','MAGNOLIA JUNIOR HIGH SCHOOL','Appointment Required','Builder','1','Traditional','Magnolia Ridge','','3.3','Water District','2023','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215135129','1675101095','215135129','2023-01-03T13:22:21.023','14256273','Austin Davis','Rogers Healy & Associates','','','30.399619','-95.506768','46','77318','4','400000.00','Active','Cadence Hills','132','Loop','Willis','2','0','3','2135','Single-Family','This beautiful home will easily meet everything on your checklist. It is located in the highly sought after Woodland Hills community. In this open concept home, you will find high ceilings and many upgraded features throughout. The kitchen boasts a number of different upgrades such as 42” cabinets, huge island, granite countertops, backsplash and more. Relax in your primary suite that includes bay windows, oversized shower, double vanity, and a large walk-in closet. The 6 foot extended garage features epoxy floors, insulated door, and a Husky Heavy duty steel garage storage system. This home also has a whole home dehumidifier that will always give you cleaner and healthier air. Grill in rain or shine, because the backyard has a covered patio with a Shadesol shade cover installed to keep you cool. Premium lot with no back neighbors. Home also contains flex room that could easily be converted into a bedroom. Community Features: lazy rivers, pool, 20 parks, dog park, hiking trails,& more','0.1814','39','Gehan','','','','Sellers Disclosure','1','','','Lake Conroe Area','Central Gas','1','S927104 - THE WOODLANDS HILLS 04, BLOCK 1, LOT 26','Subdivision Lot','7902','Appraisal District','','995','0','','2','','0','','','','','Composition','56 - Willis','W. LLOYD MEADOR ELEMENTARY SCHOOL','WILLIS HIGH SCHOOL','ROBERT P. BRABHAM MIDDLE SCHOOL','Appointment Required,Lockbox Front,Supra Keybox','Appraisal District','1','Contemporary/Modern','The Woodlands Hills 04','10648','3.2823','Public Sewer,Public Water','2020','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215347140','1675101095','215347140','2023-01-03T13:43:53.570','86176604','Scott Laird','Keller Williams Woodlands','','','30.158225','-95.075403','31','77327','8','259990.00','Active','Road 5105','727','','Cleveland','2','1','4','1807','Single-Family','LIKE NEW HOME!!! Located just minutes from Hwy 99 and easy access to Hwy 59 for an easy commute to IAH Airport or Downtown Houston. Welcome home to this 4 bed, 2.5 bath home on OVER 1/3 ACRE LOT featuring a new pool w/ lifetime warranty. GOURMET GRANITE kitchen w/ modern gray 36\" cabinetry, sleek granite, s/s appliances, under cabinet lighting, and breakfast bar. LIVING/DINING combo, 9-foot ceilings, recessed can lighting, and luxury vinyl wood flooring in all main living and wet areas. PRIVATE DOWNSTAIRS retreat with tub/shower combo and spacious guest bedrooms up. ENJOY YOUR WEEKENDS in this BACKYARD featuring HUGE COVERED PATIO, lots of space for entertaining, and pool with transferable warranty. Lots of great energy features -- Dual pane Low-E windows, 16-SEER HVAC, and so much more! Call for your private showing today!','0.39','52','Casas Houston','','Electric Dryer Connections,Washer Connections','','Exclusions,Sellers Disclosure','1','','','Cleveland Area','Central Gas','1','SANTA FE, SEC 1, BLOCK 11, LOT 1694, ACRES .39','Subdivision Lot','16988','Appraisal District','','120','0','','2','Gas Oven','1','Above Ground','','Gas Range','','Composition','100 - Cleveland','COTTONWOOD SCHOOL (CLEVELAND)','CLEVELAND HIGH SCHOOL','CLEVELAND MIDDLE SCHOOL','Appointment Required','Appraisal District','1','Traditional','Santa Fe','5328','2.0417','Public Sewer,Public Water','2021','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215384446','1675101095','215384446','2023-01-03T14:20:14.700','87153237','Bradley Tiffan','Legend Home Corporation','','','30.349203','-95.502880','38','77304','7','338140.00','Active','Lawrence Park','2903','Court','Conroe','3','1','4','2747','Single-Family','Love where you live in Madison Bend in Conroe, TX! Conveniently located 1.5 miles off I-45 and N FM 3083 W – homeowners enjoy a low property tax rate and close proximity to Lake Conroe and The Woodlands! The stunning Avondale plan is a two-story home with 4 bedrooms, 3.5 baths, STUDY, game room, and 2-car garage. With vinyl plank flooring throughout the common areas, you\'ll love entertaining in this home! The gourmet kitchen is sure to please with 42\" cabinetry, granite countertops, and stainless steel appliances. Enjoy the privacy and convenience of having the Owner\'s Suite on the first floor! Retreat to the Owner\'s Suite featuring a beautiful bay window, garden tub and shower, and a walk-in closet. Enjoy the great outdoors with a covered patio! Don\'t miss your opportunity to call Madison Bend home, schedule a visit today!','','19','Legend Homes','','Electric Dryer Connections,Washer Connections','','Mud','1','','','Lake Conroe Area','Central Gas','1','Lot 7, Blk 11 Madison Bend Sec. 02','Subdivision Lot','5369','Survey','','750','1','Never Lived In','2','Freestanding Oven','0','','','Freestanding Range','','Composition','11 - Conroe','GIESINGER ELEMENTARY SCHOOL','CONROE HIGH SCHOOL','PEET JUNIOR HIGH SCHOOL','Accompany,Appointment Required,No Supra Keybox','Builder','2','Traditional','Madison Bend','','2.89','Water District','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215728979','1675101096','215728979','2023-01-03T14:16:30.987','26545907','Dustin Vacek','RE/MAX Opportunities','','','29.448483','-95.749992','49','77469','6','475500.00','Active','Pisklak','6822','Road','Richmond','2','0','3','1570','Single-Family','Cozy three bedroom two bath house on 5 acres! House was built with piers under the slab for added stability. Property is a blank slate for your perfect county oasis where you could add a pool or a barn for livestock. Close proximity to Brazos Town Center and US 59/69 offers lots of amenities as far as shopping and dining. Zoned to the highly desired Needville School District.','5.224','30','','','Electric Dryer Connections,Washer Connections','','Other Disclosures,Sellers Disclosure','1','','','','Central Gas','0','0095 B WICKSON, ACRES 1.00','Cleared','227557','Survey','','','0','','2','Gas Oven','0','','','Gas Range','','Composition','38 - Needville','NEEDVILLE ELEMENTARY SCHOOL','NEEDVILLE HIGH SCHOOL','NEEDVILLE JUNIOR HIGH SCHOOL','Appointment Required','Appraisal District','1','Traditional','B Wickson','4073','1.8957','Aerobic,Well','2001','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215849950','1675101096','215849950','2023-01-03T13:18:06.110','33348594','Sherry Williams','Bay City Realty','','','28.971919','-95.940930','42','77414','4','240000.00','Active','Heatherglen','4105','Street','Bay City','3','0','4','2631','Single-Family','Come see the massive vaulted ceiling in living room with a cozy wood burning fireplace. Keep going to a spacious back room that is large enough for a pool table with windows open to the back yard with a view of open meadows. Kitchen and dining area combined with breakfast bar will make family time or entertaining a joy. There is a bonus front room, maybe for exercising or a children\'s play area? Also features a separate office off the living room The hallway leads to the 4 bedrooms, 3 baths. This home gives so much space and flexibility, even room on side for boat or RV.','0.23','54','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Wood Burning Fireplace','1','','Central Gas','0','MCDONALD MEADOWS, BLOCK 5, LOT 2, SEC 2','Subdivision Lot','10019','Appraisal District','','','0','','2','Gas Oven','0','','','Gas Range','','Composition','132 - Bay City','TENIE HOLMES ELEMENTARY SCHOOL','BAY CITY HIGH SCHOOL','BAY CITY JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Front','Appraisal District','1','Ranch','Mcdonald Meadows','6427','2.6704','Public Sewer,Public Water','1978','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215977621','1675101096','215977621','2023-01-03T14:08:22.423','4652328','Kevin Cooley','JLA Realty','','','30.938285','-95.380817','14','75862','3','19950.00','Active','Walker','525','Street','Trinity','1','0','2','960','Single-Family','This would make a great project property or investment property. It needs some work. It is located close to the school and the track. The house has a fenced in yard.','0.3','42','','','','','No Disclosures','0','','0','Trinity Area','Window Unit','0','TRINITY, TR 42, LOT 40','Cleared,Subdivision Lot','13068','Appraisal District','','','0','','0','','0','','','','','Composition','63 - Trinity','LANSBERRY ELEMENTARY SCHOOL','TRINITY HIGH SCHOOL (HEB)','TRINITY JUNIOR HIGH SCHOOL','Vacant/Unoccupied','Appraisal District','1','Other Style','Trinity Tr 42','243','2.4306','Public Sewer,Public Water','1950','Seller'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','216009194','1675101096','216009194','2023-01-03T14:10:03.400','24170037','Bo Liu','KingFay Inc','','','29.797893','-95.466765','10','77055','3','485000.00','Active','Saxet','6606','Street','Houston','1','1','3','1533','Single-Family','Location, location! This 8000+ sf lot will be for your next new building or live it or rent it and build later. House is livable and priced at lot value only! No disclosure. Available to tour after 8th.','0.1895','24','','','','','No Disclosures','','','','Spring Branch','Central Gas','0','LT 7 BLK 8 WESTVIEW TERRACE','Other','8255','Appraisal District','','','0','','1','','0','','','','','Composition','49 - Spring Branch','HOUSMAN ELEMENTARY SCHOOL','NORTHBROOK HIGH SCHOOL','LANDRUM MIDDLE SCHOOL','Appointment Required,Lockbox Front,Request Online Appointment,Vacant/Unoccupied','Appraisal District','1','Other Style','Westview Terrace','9411','2.4415','Public Sewer,Public Water','1950','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','216012970','1675101096','216012970','2023-01-03T14:11:03.787','72508181','Eduardo Zelaya','OAR Realty Partners, LLC','','','29.834137','-95.789598','43','77493','6','425000.00','Active','Scotsman','23843','Drive','Katy','2','1','4','2869','Single-Family','Extra Large Backyard!!! This house is perfect to start the 2023, this house is coming with 4 Bedrooms on the first Floor and big Gameroom on the second Floor. Your meetings will be great in the extra-large Backyard, ready to build a pool, no neighbors on the back. schedule your appointment soon.','0.3106','25','','','','','Exclusions,Sellers Disclosure','1','','','Katy - North','Central Gas','1','LT 33 BLK 1 VENTANA LAKES SEC 7','Corner','13528','Appraisal District','','650','0','','2','Gas Oven','0','','','Gas Range','','Composition','30 - Katy','BETHKE ELEMENTARY SCHOOL','PAETOW HIGH SCHOOL','STOCKDICK JUNIOR HIGH SCHOOL','Accompany,Appointment Required,Leave Business Card,Lockbox Right Side','Appraisal District','1.5','Contemporary/Modern','Ventana Lakes Sec 7','10021','3.2768','Water District','2015','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','216020281','1675101096','216020281','2023-01-03T13:09:05.803','56522651','Linda Salomon','R. Alexa Group LLC','','','30.176144','-95.027184','18','77327','3','139900.00','Active','Road 5500','479','','Cleveland','2','0','3','1216','Single-Family','BEAUTIFUL 3 BEDROOM, 2 BATHROOM MANUFACTURE HOME ALMOST AS NEW BUILT ON 2021, LOCATED IN CLEVELAND. THE AREA IS GROWING FAST AND AND IS MINUTES AWAY FROM SH-99. THE BREAKFAST BAR PROVIDES ROOM FOR ADDITIONAL SEATING AND JUST BEHIND ENOUGH SPACE FOR A DINNING TABLE, NEW BUILT DECK FRONT AND BACK. YOU\'LL LOVE THE SPACE AND QUIET IN THIS COUNTRY LOCATION.\r\nLARGE LOT (0.24 ACRES) THIS HOME IS MOVE IN READY!!!!','0.24','52','','','','','No Disclosures','1','','','Cleveland Area','Central Electric','1','SANTA FE, SEC 6, BLOCK 34, LOT 2081, ACRES 0.24','Cleared','10454','Appraisal District','','120','0','','0','','0','','','','','Other','100 - Cleveland','PINE BURR ELEMENTARY SCHOOL','CLEVELAND HIGH SCHOOL','CLEVELAND MIDDLE SCHOOL','Appointment Required,Lockbox Front','Seller','1','Other Style','Santa Fe Sec 6','901','2.0417','Public Water','2021','Seller'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','216022530','1675101096','216022530','2023-01-03T14:34:33.033','90654265','Isaiah Hinojosa','eXp Realty, LLC','','','29.792958','-95.459788','16','77055','3','575000.00','Active','Clarkson','6102','Lane','Houston','1','0','3','912','Single-Family','Price includes multiple lots with two houses. Prime location. This is a steal.\r\nPerfect for some one wanting to build their forever home or some one wanting to build and flip.','0.2296','24','','','','','Sellers Disclosure','','','','Spring Branch','Central Electric','0','TR 11A ABST 871 J WHARTON','Other','21500','Appraisal District','','','0','','0','','0','','','','','Composition','49 - Spring Branch','HOUSMAN ELEMENTARY SCHOOL','MEMORIAL HIGH SCHOOL (SPRING BRANCH)','SPRING BRANCH MIDDLE SCHOOL (SPRING BRANCH)','No Appointment Required','Appraisal District','1','Colonial','Wm Thomas','5389','2.4415','Public Sewer,Public Water','1947','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','216022794','1675101096','216022794','2023-01-03T13:51:37.550','33554216','Jessica Huang','Jessica Realty','','','29.796070','-95.711535','38','77084','7','275000.00','Active','Westlake','1922','Way','Houston','2','0','3','1626','Single-Family','Completely redone home located minutes from Katy, near plenty of shopping, eateries, & more. Original hardwood floors have been restored to their former glory. Fireplace was thoroughly cleaned & painted bright white to contrast the gorgeous wood flooring in the living room. The kitchen showcases stainless steel appliances, granite countertops, wine rack, & tons of cabinetry. Master bath boasts large garden tub w/ rain shower, & the massive backyard & deck area are perfect for entertaining or just relaxing on anice day. Don\'t forget the curb appeal! With this home\'s amazing exterior, interior, & being zoned to Katy ISD, the home definitely won\'t last long! All appliances included. Special features: Tankless Water Heater (1 y/o), 3.5 ton HVAC, two 24\" Carbon & Sediment Filters, & Reverse Osmosis water system.','0.1816','25','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gas Connections','1','Katy - North','Central Gas','1','LT 12 BLK 10 WESTLAKE SEC 1','Subdivision Lot','7912','Appraisal District','','475','0','','2','Electric Oven','0','','','Gas Range','','Composition','30 - Katy','MAYDE CREEK ELEMENTARY SCHOOL','MAYDE CREEK HIGH SCHOOL','MAYDE CREEK JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Right Side,Vacant/Unoccupied','Appraisal District','1','Traditional','Westlake','6226','2.4758','Public Water','1975','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','216023482','1675101096','216023482','2023-01-03T14:16:56.540','80576258','Stefanie Hall','eXp Realty, LLC','','','29.484032','-94.572068','24','77650','1','430000.00','Active','Tuna','1106','Drive','Crystal Beach','1','0','1','','Single-Family','INVESTOR SPECIAL! Looking for a money making machine, here it is. 6 RV spots that may or may not be in use when viewing the property. 2 tiny homes on the property, one goes with the sale & one is sold just renting a space on the the property. Small house across the street is a double container up on pilings that is can being rented month to month. This incoming producing property still has more to possibility to add more RV spots or tiny homes.','0.2082','33','','','','','No Disclosures','1','','','Crystal Beach','Wall Heater','0','ABST 141 M KNOWLTON LOT 4 BLK 8 SINGING SANDS S-D 2','Cleared','9071','Appraisal District','','','0','','0','Gas Oven','0','','','Gas Range','','Other','25 - High Island','HIGH ISLAND ELEMENTARY SCHOOL','HIGH ISLAND HIGH SCHOOL','HIGH ISLAND MIDDLE SCHOOL','Appointment Required,No Supra Keybox','','1','Other Style','Singing Sands 2','347','1.6689','Public Water,Septic Tank','2019','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','216023509','1675101096','216023509','2023-01-03T13:53:42.063','49502360','Jaclyn Joiner','JLA Realty','','','30.069889','-94.803772','9','77575','7','165000.00','Active','Maple','1320','Street','Liberty','2','1','3','2144','Single-Family','Here is your opportunity to make something truly yours! This home is placed on a a .37 acre lot on a quiet dead-end street. This blank canvas is a 3 bedroom 2 bath, the existing garage was converted into its own room with a half bath attached.','0.37','52','','','','','Sellers Disclosure','','','','Liberty','No Heating','0','LIBERTY OUTER BLOCKS, BLOCK 10, LOT PT 2, TRACT 9, ACRES .37','Cleared,Subdivision Lot','16117','Appraisal District','','','0','','0','','1','In Ground','','','','Composition','73 - Liberty','LIBERTY ELEMENTARY SCHOOL (LIBERTY)','LIBERTY HIGH SCHOOL (LIBERTY)','LIBERTY MIDDLE SCHOOL (LIBERTY)','Accompany,Appointment Required,Lockbox Left Side','Appraisal District','1','Ranch,Traditional','Liberty Outer Blocks','4881','2.5375','Public Sewer,Public Water','1975','Appraisal District'); --> New record created successfully